Table List

TABLE_NAME	TABLE_ROWS	DATA_LENGTH	TABLE_COMMENT
aftershock_mainshock	276	16384	Intra-event distance (CRJB) between aftershock and mainshock events.
basin_model	11	16384	Model for basin parameters (e.g., z1, z2.5)
basin_site	19742	1589248	Basin parameters (e.g., z1, z2.5) for each site
citation	819	262144	Citation information
collection	11	16384	A collection groups motions, events, or stations together into a common set
collection_motion	86711	3686400	A junction table mapping motions to collections
event	1858	393216	Earthquake events
event_eqid	695	65536	A junction table mapping earthquakes to NGA earthquake identification numbers
event_geometry	6129	229376	Join table between event and geometry tables
event_type	7	16384	Event types (shallow crustal, interface, intraslab, outer-rise, induced, undetermined, stable continental)
finite_fault	1894	163840	Finite fault model parameters
finite_fault_kinematic_parameter	68	16384	Finite-fault kinematic parameters from a published source.
finite_fault_segment	1844	163840	Finite fault segments for multi-segment ruptures
fourier_spectra	36768641	1652555776	Fourier amplitude spectra, smoothed and decimated
geometry	57	6832128	GeoJSON geometries delineating geophraphic features, regions, basins, etc.
intensity_measure	120267	60424192	Ground motion intensity measures
motion	124416	5783552	Ground motion parameters
network	197	65536	Seismic network parameters
path	123379	11026432	Path metrics
path_old	80080	5783552
response_spectra	13309377	1083179008	Pseudo-acceleration response spectra
site	11766	3686400	Site information (location, VS30, etc.)
site_geometry	58266	2637824	Join table between site and geometry tables
station	12691	1589248	Station information (station code, location, etc.)
station_ssn	6715	294912	A junction table mapping stations to NGA station sequence numbers
time_series_data	78045	70117769216	Ground motion time series data
time_series_metadata	124083	14172160	Ground motion time series metadata and processing parameters
user	47	16384	User information
version	0	16384
version_time_series_metadata	53890	2637824
vs30_citation	16507	1589248	Citations for VS30 assignments.
vs30_code	18	16384	Methods used to assign preferred VS30 value.

aftershock_mainshock

Field	Type	Null	Key	Extra	Privileges	Comment
aftershock_mainshock_id	int(11)	NO	PRI	auto_increment	select	Primay key; unique ID assigned to each pair of aftersock-mainshock events.
aftershock_event_id	int(11)	NO	MUL		select	Foreign key; unique ID assigned to each earthquake for identification - corresponding to the aftershock.
mainshock_event_id	int(11)	NO	MUL		select	Foreign key; unique ID assigned to each earthquake for identification - corresponding to the mainshock.
crjb	float	YES			select	Shortest distance (km) between the centroid of Joyner-Boore rupture surface of the potential aftershock earthquake, and the closest point on the edge of the Joyner-Boore rupture surface of the mainshock.

basin_model

Field	Type	Collation	Null	Key	Default	Extra	Privileges	Comment
basin_model_id	int(11)		NO	PRI		auto_increment	select	Primary key; unique ID assigned to each basin model for identification.
model_name	varchar(100)	utf8_unicode_ci	YES	UNI			select	Full name of basin model.
model_abbreviation	varchar(25)	utf8_unicode_ci	NO				select	Common abbreviation for the basin model.
model_ref	varchar(500)	utf8_unicode_ci	YES				select	Basin model reference.
basin_model_citation_id	int(11)		NO	MUL	1		select	Foreign key; unique ID assigned to each citation for identification - citation of basin model

basin_site

Field	Type	Null	Key	Extra	Privileges	Comment
basin_site_id	int(11)	NO	PRI	auto_increment	select	Primary key; unique ID assigned to each basin model and site combination for identification.
site_id	int(11)	NO	MUL		select	Foreign key; unique ID assigned to each site for identification.
basin_model_id	int(11)	NO	MUL		select	Foreign key; unique ID assigned to each basin model for identification.
z1p0	float	YES			select	Depth (m) to Vs = 1.0 km/s.
z2p5	float	YES			select	Depth (m) to Vs = 2.5 km/s.

citation

Field	Type	Collation	Null	Key	Extra	Privileges	Comment
citation_id	int(11)		NO	PRI	auto_increment	select
citation_text	varchar(500)	utf8_unicode_ci	YES			select	Citation for information contained in database
citation_url	varchar(1000)	utf8_unicode_ci	YES			select	Uniform resource locator (URL) for citation
citation_hash	varchar(32)	utf8_unicode_ci	NO	UNI		select

collection

Field	Type	Collation	Null	Key	Default	Extra	Privileges	Comment
collection_id	int(11)		NO	PRI		auto_increment	select	Primary key; unique ID assigned to each collection for identification.
collection_name	varchar(100)	utf8_unicode_ci	YES	UNI			select	Common name for the collection.
collection_description	varchar(1000)	utf8_unicode_ci	YES				select	Description of what the collection contains.
collection_ref	varchar(5000)	utf8_unicode_ci	YES				select	Reference if the collection is associated with a publication (e.g., data curation, dataset used in model development, etc.)
collection_citation_id	int(11)		NO	MUL	1		select	Foreign key; unique ID assigned to each citation for identification - citation of collection

collection_motion

Field	Type	Collation	Null	Key	Extra	Privileges	Comment
collection_motion_id	int(11)		NO	PRI	auto_increment	select	Primary key; unique ID assigned to each collection and motion combination for identification.
collection_id	int(11)		NO	MUL		select	Foreign key; unique ID assigned to each collection for identification.
motion_id	int(11)		NO	MUL		select	Foreign key; unique ID assigned to each motion for identification.
record_sequence_number	varchar(50)	utf8_unicode_ci	YES			select

event

Field	Type	Collation	Null	Key	Extra	Privileges	Comment
event_id	int(11)		NO	PRI	auto_increment	select	Primary key; unique ID assigned to each earthquake for identification.
hypocenter_longitude	float(8,5)		NO	MUL		select	Hypocenter longitude (degrees)
hypocenter_latitude	float(8,5)		NO			select	Hypocenter latitude (degrees)
event_country	varchar(100)	utf8_unicode_ci	YES			select	Country the event is located in (based on the epicenter).
event_subdivision	varchar(100)	utf8_unicode_ci	YES			select	Subdivision within a country (e.g., state, province, prefecture) the event is located in (based on the epicenter).
event_name	varchar(100)	utf8_unicode_ci	YES			select	The common name for the earthquake. The naming usually includes the name of the general area of country where the earthquake occured.
comcat_id	varchar(30)	utf8_unicode_ci	YES			select	The ANSS Comprehensive Earthquake Catalog (ComCat) unique ID.
event_type_id	int(11)		NO	MUL		select	Foreign key; unique ID assigned to each earthquake type for identification.
datetime	datetime		YES			select	Date and time of the earthquake.
time_zone	varchar(10)	utf8_unicode_ci	YES			select	Corresponding time zone for the recorded date and time.
hypocenter_reported_depth	float		YES			select	Hypocenter depth (km) reported by source documentation (e.g., earthquake catalog or published finite fault model); depth measured positive in the direction to the center of the earth
hypocenter_reported_depth_datum	varchar(100)	utf8_unicode_ci	YES			select	Reference depth datum for reported hypocenter depth (e.g., WGS84 Geoid/mean sea level)
epicenter_elevation	float		YES			select	Surface elevation (km) at epicenter location (surface projection of hypocenter) using 30 arc-sec DEM; elevation measured positive above mean sea level
hypocenter_depth	float		YES			select	Hypocenter depth (km) relative to the ground surface; depth measured positive into the ground
magnitude	float		NO			select	Magnitude of the earthquake.
magnitude_type	varchar(10)	utf8_unicode_ci	YES			select	Type of magnitude in the "magnitude" field: Mw = moment magnitude; ML = local magnitude; MS = surface-wave magnitude; Mb = body wave magnitude; or U = unknown magnitude type.
magnitude_uncertainty_Kagan_model	float		YES			select	Magnitude uncertainty assigned using Kagan's model (Kagan 2002).
magnitude_uncertainty_statistical	float		YES			select	Magnitude uncertainty is taken as the standard deviation of the reliable magnitude estimates.
magnitude_sample_size	int(11)		YES			select	Number of magnitude estimates used to compute the standard deviation.
magnitude_uncertainty_study_class	int(11)		YES			select	Magnitude uncertainty class addigned by PE&A based on the quality of special studies that yeilded the magnitude estimates and is defined as: 1 = Recent events well studied; 2 = Older events well studied or recent events not well studied; 3 = Older events not well studied.
strike	float		YES			select	Strike angle (degrees) of the fault plane used to approximate the causative fault surface; 0 <= strike <= 360. Converntion of fault strike, dip, and rake follows that described in Aki and Richards (1980, p106).
dip	float		YES			select	Dip angle (degrees) of the fault plane; 0 <= dip <= 90. Converntion of fault strike, dip, and rake follows that described in Aki and Richards (1980, p106).
rake	float		YES			select	Rake is the angle (degrees) measured on the fault plane counterclockwise from the refernce strike direction to the average slip direction; -180 <= rake < 180.
mechanism_based_on_Rake	int(11)		YES			select	Mechanism indicator based on rake angle. 0 = strike-slip (-180 < rake < -150) or (-30 < rake < 30) or (150 < rake < 180); 1 = normal (-120 < rake < -60); 2 = reverse (60 < rake < 120); 3 = reverse-oblique (30 < rake < 60) or (120 < rake < 150); 4 = normal-oblique (-150 < rake < -120) or (-60 < rake < -30).
slip_rate	float		YES			select	Slip rate (mm/yr) on the causative fault. It is taken from the fault database of the National Seismic Hazard Maps (Frankel et al. 2002).
seismic_moment	float		YES			select	Seismic moment (dyne.cm)
p_plunge	float		YES			select	Plunge (degrees) of the maximum compressive (P) principal stress given by the fault plane solution.
p_trend	float		YES			select	Trend (degrees) of the maximum compressive (P) principal stress given by the fault plane solution.
t_plunge	float		YES			select	Plunge (degrees) of the minimum compressive (T) principal stress given by the fault plane solution.
t_trend	float		YES			select	Trend (degrees) of the minimum compressive (P) principal stress given by the fault plane solution.
coseismic_surface_rupture	int(1)		YES			select	Presence or absence of primary surface rupture: 0 = No; 1 = Yes.
basis_for_surface_rupture	int(11)		YES			select	Basis for interence of surface rupture: 1 = Reference documents the presence or absence of surface faulting (sfdoc); 2 = Surface faulting discussed in references (sfdis); 3 = Location of earthquake discussed in references (locdis); 4 = M<6, likelihood of existence of surface rupture small; 5 = M~6, likelihood of existence of surface rupture is small.=;6 = M>=7, likelihood of existence of surface rupture is large.
extensional_regime	int(11)		YES			select	Earthquake in extensional regime: 0 = No; 1 = Yes
extensional_regime_name	varchar(100)	utf8_unicode_ci	YES			select	Name of the potential extensional regime

event_eqid

Field	Type	Collation	Null	Key	Extra	Privileges	Comment
event_eqid_id	int(11)		NO	PRI	auto_increment	select	Primay key; unique ID assigned to each event and collection combination for identification.
event_id	int(11)		NO	MUL		select	Foreign key; unique ID assigned to each event for identification.
collection_id	int(11)		NO	MUL		select	Foreign key; unique ID assigned to each collection for identification.
eqid	varchar(50)	utf8_unicode_ci	NO			select	Earthquake identification number (EQID): unique number assigned to each station in the linked collection.

event_geometry

Field	Type	Null	Key	Extra	Privileges	Comment
event_geometry_id	int(11)	NO	PRI	auto_increment	select	Primary key; unique ID assigned to each event and geometry combination for identification.
event_id	int(11)	NO	MUL		select	Foreign key; unique ID assigned to each event for identification.
geometry_id	int(11)	NO	MUL		select	Foreign key; unique ID assigned to each geometry for identification.

event_type

Field	Type	Collation	Null	Key	Default	Extra	Privileges	Comment
event_type_id	int(11)		NO	PRI		auto_increment	select	Primary key; unique ID assigned to each earthquake type for identification.
event_type	varchar(20)	utf8_unicode_ci	YES	UNI			select	Type of earthquake.

finite_fault

Field	Type	Collation	Null	Key	Default	Extra	Privileges	Comment
finite_fault_id	int(11)		NO	PRI		auto_increment	select	Primary key; unique ID assigned to each finite-fault or simulated rupure surface for identification.
event_id	int(11)		NO	MUL			select	Foreign key; unique ID assigned to each earthquake for identification.
ztor	float		YES				select	Depth to the top of the finite rupture model (km). Datum may be ground surface or sea level depending on the source.
fault_length	float		YES				select	Total length ("L") of the finite rupture model (km).
fault_width	float		YES				select	Width ("W" = A/L) of the finite rupture model (km).
fault_area	float		YES				select	Total area ("A") of the finite rupture model (km^2).
ffm_model	int(1)		YES				select	Indicator if the finite-fault parameters come from a published finite-fault model (1), were simulated (0), or are unknown (2).
ffm_reference	varchar(500)	utf8_unicode_ci	YES				select	Reference of publication used to assign finite-fault parameters (if from a model).
finite_fault_citation_id	int(11)		NO	MUL	1		select	Foreign key; unique ID assigned to each citation for identification - citation of finite fault

finite_fault_kinematic_parameter

Field	Type	Null	Key	Extra	Privileges	Comment
finite_fault_kinematic_parameter_id	int(11)	NO	PRI	auto_increment	select	Primary key; unique ID assigned to each finite-fault kinematic parameter for identification.
finite_fault_id	int(11)	NO	MUL		select	Foreign key; unique ID assigned to each finite-fault for identification.
average_fault_displacement	float	YES			select	The average amount of slip (cm) over the ruptured area. It's computed as Mo/(MuA1.0E+10) where Mu=3.58e11.
rise_time	float	YES			select	The time required for the completion of slip at a point on the fault plane. When there are multiple estimates of rise time, the average value is used.
average_slip_velocity	float	YES			select	Average Slip Velocity (cm/s) = (Average Fault Displacement) / (Rise time)
preferred_rupture_velocity	float	YES			select	Rupture velocity (Vr) (km/s) is the speed at which a rupture front moves along the fault during an earthquake. When there are multiple estimates of rupture velocity, the average value is used.
average_vr_vs	float	YES			select	Ratio of rupture velocity (Vr) to shear?wave velocity (Vs) in the source region. When there are multiple estimates, the average value is used.
percent_moment_release	float	YES			select	Percentage of moment release in the top 5 km of crust; calcualted from an appropiate slip model.
existence_of_shallow_asperity	int(1)	YES			select	0 = No; 1 = Yes. An asperity is defined by Somerville et al. (1999) as a rectangular region in which the slip exceeds, in a specified way, the slip averaged over the entire fault rupture.
depth_to_shallowest_asperity	float	YES			select	If the depth (km) of the top of the shallowest asperity < 5 km, the earthquake is classified as a shallow asperity event; otherwise the earthquake is classified as a deep asperity event (existence_of_shallow_asperity = 0).

finite_fault_segment

Field	Type	Null	Key	Extra	Privileges	Comment
finite_fault_segment_id	int(11)	NO	PRI	auto_increment	select	Primary key; unique ID assigned to each finite-fault segment for identification.
finite_fault_id	int(11)	YES	MUL		select	Foreign key; unique ID assigned to each finite-fault or simulated rupure surface for identification.
seg_number	int(11)	YES			select	Finite fault segment number
ULC_latitude	float(8,5)	YES			select	Upper left corner latitude (degrees)
ULC_longitude	float(8,5)	YES			select	Upper left corner longitude (degrees)
ULC_depth	float	YES			select	Upper left corner depth (km)
seg_length	float	YES			select	Segment length ("l") (km).
seg_width	float	YES			select	Segment width ("w") (km)
seg_area	float	YES			select	Segment area ("a") (km^2)
seg_strike	float	YES			select	Strike angle (degrees) of the fault segment; 0 <= strike <= 360.
seg_dip	float	YES			select	Dip angle (degrees) of the fault segment plane. 0 <= dip <= 90.
seg_rake	float	YES			select	Rake if the angle (degrees) measured on the fault segment plane counterclockwise from the reference strike direction to the average slip direction; -180 <= rake <= 180.

fourier_spectra

Field	Type	Null	Key	Extra	Privileges	Comment
fourier_spectra_id	int(11)	NO	PRI	auto_increment	select	Primary key; unique ID assigned to each fourier specrum ordiant for identification
time_series_metadata_id	int(11)	NO	MUL		select
frequency	decimal(12,9)	NO	MUL		select	Frequency (Hz)
fas_h1	double	YES			select	Fourier amplitude spectra (g-s) for the first as-recorded horizontal component (H1)
fas_h2	double	YES			select	Fourier amplitude spectra (g-s) for the second as-recorded horizontal component (H2)
fas_v	double	YES			select	Fourier amplitude spectra (g-s) for the as-recorded vertical component (V)
eas	double	YES			select	Orientation-independent effective amplitude specrtra (g-s); defined in Kottke et al. (2021)

geometry

Field	Type	Collation	Null	Key	Default	Extra	Privileges	Comment
geometry_id	int(11)		NO	PRI		auto_increment	select	Primay key; unique ID assigned to each geoJSON for identification.
geometry_class	int(11)		YES				select	Indicator for what the geometry describes: 1 = region boundary; 2 = study area boundary; 3 = geomorphic province boundary; 4 = boundary used in published model.
geometry_type	int(11)		YES				select	Indicator for the type of geometry: 0 = point; 1 = MulitPoint; 2 = LineString; 3 = MulitLineString; 4 = Polygon; 5 = MultiPolygon; 6 = GeometryCollection.
geometry_name	varchar(100)	utf8_unicode_ci	YES	UNI			select	Geometry name.
geometry_description	varchar(5000)	utf8_unicode_ci	YES				select	Geometry description.
geometry_ref	varchar(1000)	utf8_unicode_ci	YES				select	Reference if the geometry is associated with a publication.
geometry_citation_id	int(11)		NO	MUL	1		select	Foreign key; unique ID assigned to each citation for identification - citation of geometry object
geometry_geojson	mediumtext	utf8_unicode_ci	YES				select	GeoJSON containing points which make up the geometry.
geometry_test	geometry		YES				select

intensity_measure

Field	Type	Null	Key	Extra	Privileges	Comment
intensity_measure_id	int(11)	NO	PRI	auto_increment	select	Primary key; unique ID assigned to each intensity measure row for identification
time_series_metadata_id	int(11)	NO	MUL		select
pga_h1	double	YES			select	Peak ground acceleration (g) for the first as-recorded horizontal component (H1)
pga_h2	double	YES			select	Peak ground acceleration (g) for the second as-recorded horizontal component (H2)
pga_v	double	YES			select	Peak ground acceleration (g) for the as-recorded vertical component (V)
pga_rotd0	double	YES			select	Peak ground acceleration (g) for the minimum horizontal component (RotD00)
pga_rotd50	double	YES			select	Peak ground acceleration (g) for the median horizontal component (RotD50)
pga_rotd100	double	YES			select	Peak ground acceleration (g) for the maximum horizontal component (RotD100)
pgv_h1	double	YES			select	Peak ground velocity (cm/s) for the first as-recorded horizontal component (H1)
pgv_h2	double	YES			select	Peak ground velocity (cm/s) for the second as-recorded horizontal component (H2)
pgv_v	double	YES			select	Peak ground velocity (cm/s) for the as-recorded vertical component (V)
pgv_rotd0	double	YES			select	Peak ground velocity (cm/s) for the minimum horizontal component (RotD00)
pgv_rotd50	double	YES			select	Peak ground velocity (cm/s) for the median horizontal component (RotD50)
pgv_rotd100	double	YES			select	Peak ground velocity (cm/s) for the maximum horizontal component (RotD100)
cav_h1	double	YES			select	Cumulative absolute velocity (m/s) for the first as-recorded horizontal component (H1)
cav_h2	double	YES			select	Cumulative absolute velocity (m/s) for the second as-recorded horizontal component (H2)
cav_v	double	YES			select	Cumulative absolute velocity (m/s) for the as-recorded vertical component (V)
cav_rotd0	double	YES			select	Cumulative absolute velocity (m/s) for the minimum horizontal component (RotD00)
cav_rotd50	double	YES			select	Cumulative absolute velocity (m/s) for the median horizontal component (RotD50)
cav_rotd100	double	YES			select	Cumulative absolute velocity (m/s) for the maximum horizontal component (RotD100)
cav5_h1	double	YES			select	Thresholded (5 cm/s) cumulative absolute velocity (m/s) for the first as-recorded horizontal component (H1)
cav5_h2	double	YES			select	Thresholded (5 cm/s) cumulative absolute velocity (m/s) for the second as-recorded horizontal component (H2)
cav5_v	double	YES			select	Thresholded (5 cm/s) cumulative absolute velocity (m/s) for the as-recorded verticall component (H1)
cav5_rotd0	double	YES			select	Thresholded (5 cm/s) cumulative absolute velocity (m/s) for the minimum horizontal component (RotD00)
cav5_rotd50	double	YES			select	Thresholded (5 cm/s) cumulative absolute velocity (m/s) for the median horizontal component (RotD50)
cav5_rotd100	double	YES			select	Thresholded (5 cm/s) cumulative absolute velocity (m/s) for the maximum horizontal component (RotD100)
ia_h1	double	YES			select	Arias intensity (m/s) for the first as-recorded horizontal component (H1)
ia_h2	double	YES			select	Arias intensity (m/s) for the second as-recorded horizontal component (H2)
ia_v	double	YES			select	Arias intensity (m/s) for the as-recorded verticall component (V)
ia_rotd0	double	YES			select	Arias intensity (m/s) for the minimum horizontal component (RotD00)
ia_rotd50	double	YES			select	Arias intensity (m/s) for the median horizontal component (RotD50)
ia_rotd100	double	YES			select	Arias intensity (m/s) for the maximum horizontal component (RotD100)
ia_time_05_h1	float	YES			select	Time (s) to achieve 5% of the maximum arias intensity for the first as-recorded horizontal component (H1)
ia_time_10_h1	float	YES			select	Time (s) to achieve 10% of the maximum arias intensity for the first as-recorded horizontal component (H1)
ia_time_15_h1	float	YES			select	Time (s) to achieve 15% of the maximum arias intensity for the first as-recorded horizontal component (H1)
ia_time_20_h1	float	YES			select	Time (s) to achieve 20% of the maximum arias intensity for the first as-recorded horizontal component (H1)
ia_time_25_h1	float	YES			select	Time (s) to achieve 25% of the maximum arias intensity for the first as-recorded horizontal component (H1)
ia_time_30_h1	float	YES			select	Time (s) to achieve 30% of the maximum arias intensity for the first as-recorded horizontal component (H1)
ia_time_35_h1	float	YES			select	Time (s) to achieve 35% of the maximum arias intensity for the first as-recorded horizontal component (H1)
ia_time_40_h1	float	YES			select	Time (s) to achieve 40% of the maximum arias intensity for the first as-recorded horizontal component (H1)
ia_time_45_h1	float	YES			select	Time (s) to achieve 45% of the maximum arias intensity for the first as-recorded horizontal component (H1)
ia_time_50_h1	float	YES			select	Time (s) to achieve 50% of the maximum arias intensity for the first as-recorded horizontal component (H1)
ia_time_55_h1	float	YES			select	Time (s) to achieve 55% of the maximum arias intensity for the first as-recorded horizontal component (H1)
ia_time_60_h1	float	YES			select	Time (s) to achieve 60% of the maximum arias intensity for the first as-recorded horizontal component (H1)
ia_time_65_h1	float	YES			select	Time (s) to achieve 65% of the maximum arias intensity for the first as-recorded horizontal component (H1)
ia_time_70_h1	float	YES			select	Time (s) to achieve 70% of the maximum arias intensity for the first as-recorded horizontal component (H1)
ia_time_75_h1	float	YES			select	Time (s) to achieve 75% of the maximum arias intensity for the first as-recorded horizontal component (H1)
ia_time_80_h1	float	YES			select	Time (s) to achieve 80% of the maximum arias intensity for the first as-recorded horizontal component (H1)
ia_time_85_h1	float	YES			select	Time (s) to achieve 85% of the maximum arias intensity for the first as-recorded horizontal component (H1)
ia_time_90_h1	float	YES			select	Time (s) to achieve 90% of the maximum arias intensity for the first as-recorded horizontal component (H1)
ia_time_95_h1	float	YES			select	Time (s) to achieve 95% of the maximum arias intensity for the first as-recorded horizontal component (H1)
ia_time_05_h2	float	YES			select	Time (s) to achieve 5% of the maximum arias intensity for the second as-recorded horizontal component (H2)
ia_time_10_h2	float	YES			select	Time (s) to achieve 10% of the maximum arias intensity for the second as-recorded horizontal component (H2)
ia_time_15_h2	float	YES			select	Time (s) to achieve 15% of the maximum arias intensity for the second as-recorded horizontal component (H2)
ia_time_20_h2	float	YES			select	Time (s) to achieve 20% of the maximum arias intensity for the second as-recorded horizontal component (H2)
ia_time_25_h2	float	YES			select	Time (s) to achieve 25% of the maximum arias intensity for the second as-recorded horizontal component (H2)
ia_time_30_h2	float	YES			select	Time (s) to achieve 30% of the maximum arias intensity for the second as-recorded horizontal component (H2)
ia_time_35_h2	float	YES			select	Time (s) to achieve 35% of the maximum arias intensity for the second as-recorded horizontal component (H2)
ia_time_40_h2	float	YES			select	Time (s) to achieve 40% of the maximum arias intensity for the second as-recorded horizontal component (H2)
ia_time_45_h2	float	YES			select	Time (s) to achieve 45% of the maximum arias intensity for the second as-recorded horizontal component (H2)
ia_time_50_h2	float	YES			select	Time (s) to achieve 50% of the maximum arias intensity for the second as-recorded horizontal component (H2)
ia_time_55_h2	float	YES			select	Time (s) to achieve 55% of the maximum arias intensity for the second as-recorded horizontal component (H2)
ia_time_60_h2	float	YES			select	Time (s) to achieve 60% of the maximum arias intensity for the second as-recorded horizontal component (H2)
ia_time_65_h2	float	YES			select	Time (s) to achieve 65% of the maximum arias intensity for the second as-recorded horizontal component (H2)
ia_time_70_h2	float	YES			select	Time (s) to achieve 70% of the maximum arias intensity for the second as-recorded horizontal component (H2)
ia_time_75_h2	float	YES			select	Time (s) to achieve 75% of the maximum arias intensity for the second as-recorded horizontal component (H2)
ia_time_80_h2	float	YES			select	Time (s) to achieve 80% of the maximum arias intensity for the second as-recorded horizontal component (H2)
ia_time_85_h2	float	YES			select	Time (s) to achieve 85% of the maximum arias intensity for the second as-recorded horizontal component (H2)
ia_time_90_h2	float	YES			select	Time (s) to achieve 90% of the maximum arias intensity for the second as-recorded horizontal component (H2)
ia_time_95_h2	float	YES			select	Time (s) to achieve 95% of the maximum arias intensity for the second as-recorded horizontal component (H2)
ia_time_05_v	float	YES			select	Time (s) to achieve 5% of the maximum arias intensity for the as-recorded verticall component (V)
ia_time_10_v	float	YES			select	Time (s) to achieve 10% of the maximum arias intensity for the as-recorded verticall component (V)
ia_time_15_v	float	YES			select	Time (s) to achieve 15% of the maximum arias intensity for the as-recorded verticall component (V)
ia_time_20_v	float	YES			select	Time (s) to achieve 20% of the maximum arias intensity for the as-recorded verticall component (V)
ia_time_25_v	float	YES			select	Time (s) to achieve 25% of the maximum arias intensity for the as-recorded verticall component (V)
ia_time_30_v	float	YES			select	Time (s) to achieve 30% of the maximum arias intensity for the as-recorded verticall component (V)
ia_time_35_v	float	YES			select	Time (s) to achieve 35% of the maximum arias intensity for the as-recorded verticall component (V)
ia_time_40_v	float	YES			select	Time (s) to achieve 40% of the maximum arias intensity for the as-recorded verticall component (V)
ia_time_45_v	float	YES			select	Time (s) to achieve 45% of the maximum arias intensity for the as-recorded verticall component (V)
ia_time_50_v	float	YES			select	Time (s) to achieve 50% of the maximum arias intensity for the as-recorded verticall component (V)
ia_time_55_v	float	YES			select	Time (s) to achieve 55% of the maximum arias intensity for the as-recorded verticall component (V)
ia_time_60_v	float	YES			select	Time (s) to achieve 60% of the maximum arias intensity for the as-recorded verticall component (V)
ia_time_65_v	float	YES			select	Time (s) to achieve 65% of the maximum arias intensity for the as-recorded verticall component (V)
ia_time_70_v	float	YES			select	Time (s) to achieve 70% of the maximum arias intensity for the as-recorded verticall component (V)
ia_time_75_v	float	YES			select	Time (s) to achieve 75% of the maximum arias intensity for the as-recorded verticall component (V)
ia_time_80_v	float	YES			select	Time (s) to achieve 80% of the maximum arias intensity for the as-recorded verticall component (V)
ia_time_85_v	float	YES			select	Time (s) to achieve 85% of the maximum arias intensity for the as-recorded verticall component (V)
ia_time_90_v	float	YES			select	Time (s) to achieve 90% of the maximum arias intensity for the as-recorded verticall component (V)
ia_time_95_v	float	YES			select	Time (s) to achieve 95% of the maximum arias intensity for the as-recorded verticall component (V)

motion

Field	Type	Null	Key	Default	Extra	Privileges	Comment
motion_id	int(11)	NO	PRI		auto_increment	select	Primary key; unique ID assigned to each ground motion for identification.
event_id	int(11)	NO	MUL			select	Foreign key; unique ID assigned to each earthquake for identification.
station_id	int(11)	NO	MUL			select	Foreign key; unique ID assigned to each station for identification.
path_id	int(11)	NO				select	Foreign key; unique ID assigned to each source-to-site path for identification.
user_id	int(11)	NO	MUL			select	Foreign key; unique ID assigned to each user for identification.
public_motion	tinyint(4)	NO		0		select	Indicator for the release status of the motion (and associated metadata and intensity measures): 0 = private (not released); 1 = public (released)

network

Field	Type	Collation	Null	Key	Default	Extra	Privileges	Comment
network_id	int(11)		NO	PRI		auto_increment	select	Primary key; unique ID assigned to each seismic network for identification.
network_code	varchar(10)	utf8_unicode_ci	YES	MUL			select	Network code assigned by data provider.
network_name	varchar(200)	utf8_unicode_ci	YES				select	Network name.
network_type	varchar(50)	utf8_unicode_ci	YES				select	Type of network (temporary or permanent).
start_date	date		NO				select	Initial start date the network began operating.
end_date	date		NO				select	Final end date the network stopped operating; if the network has planned perpetual opperation, an end date of "9999-00-00" is assigned.
operation_org	varchar(500)	utf8_unicode_ci	YES				select	Operating organization.
doi	varchar(1000)	utf8_unicode_ci	YES				select	Digital object identifier (DOI).
network_citation_id	int(11)		NO	MUL	1		select	Foreign key; unique ID assigned to each citation for identification - citation of seismic network

path

Field	Type	Collation	Null	Key	Extra	Privileges	Comment
path_id	int(11)		NO	PRI	auto_increment	select	Primary key; unique ID assigned to each ground motion for identification.
station_id	int(11)		NO	MUL		select	Foreign key; unique ID assigned to each station for identification.
finite_fault_id	int(11)		NO	MUL		select	Foreign key; unique ID assigned to each finite_fault for identification.
epicentral_distance	float		YES			select	Distance (km) from the recording site to the earthquake epicenter.
hypocentral_distance	float		YES			select	Distance (km) from the recording site to the earthquake hypocenter
rjb	float		YES			select	Joyner-Boore distance (km). Shortest horizontal distance from the recording site to the vertical projection of the rupture surface.
rrup	float		YES			select	Closest distance (km) from the recording site to the ruptured fault area.
rx	float		YES			select	Horizontal distance (km) from the top edge of the rupture, measured perpendicular to the fault strike (\|T\|)
ry	float		YES			select	Horizontal distance (km) from the top edge of the rupture, measured along the fault strike from the midpoint of the trace (U - L/2)
ry0	float		YES			select	Horizontal distance (km) from the top edge of the rupture, measured along the fault strike from the closest edge of the rupture
ravg	float		YES			select	Average distance (km) to the rupture surface (formally rmsd or Rrms)
rebe	float		YES			select	Distance (km) from the epicenter to the basin edge along a line between the epicenter and the station.
rsbe1	float		YES			select	Distance (km) from the station to the basin edge along a line between the epicenter and the station.
closest_point_latitude	float(8,5)		YES			select	Latitude (degrees) of the closest point on the fault.
closest_point_longitude	float(8,5)		YES			select	Longitude (degrees) of the closest point on the fault.
closest_point_depth	float		YES			select	Depth (km) of the closest point on the fault; positive direction into the ground.
hanging_wall	varchar(5)	utf8_unicode_ci	YES			select	This field mimics the FW/HW indicator defined in Abrahamson and Somerville (1996). hw = site is within hanging wall region; fw = site is within the footwall region; nu = site is in the neutral region; na = not applicable as fault dip is greader than 70 degrees.
source_to_site_azimuth	float		YES			select	The (finite) source to site direction: It is the angle measured clockwise from the fault strike direction to the direction connecting the site and the site's closest point on the surface projection of top edge of fault. This column can be used an alternative to the FW/HW indicator given previously.
X	float		YES			select	Somerville et al. (1997) X parameter (nondimensional units). For multiple? segment faults calculated following a method of Boatwright (2007).
theta_D	float		YES			select	Somerville et al. (1997) theta_D parameter (degrees). For multiple? segment faults calculated following a method of Boatwright (2007).
Y	float		YES			select	Somerville et al. (1997) Y parameter (nondimensional units). For multiple? segment faults calculated following a method of Boatwright (2007).
phi_D	float		YES			select	Somerville et al. (1997) phi_D parameter (degrees). For multiple? segment faults calculated following a method of Boatwright (2007).
ssga_strike_slip	float		YES			select	Somerville et al. (1997) X cos(theta_D) parameter. For multiple?segment faults calculated following a method of Boatwright (2007); Calculated for sites within 50km (Rrup) of a strike?slip fault (mechanism = 0).
ssga_dip_slip	float		YES			select	Somerville et al. (1997) Y cos(phi_D) parameter (degrees). For multiple?segment faults calculated following a method of Boatwright (2007). Calculated for sites within 50km (ClstD) on the footwall (FW) or hanging wall (HW) of a dip? slip fault (mechanism not equal to 0).
s	float		YES			select	s parameter in Spudich and Chiou (2008). s is the length (km) of fault that ruptures toward site.
d	float		YES			select	d parameter in Spudich and Chiou (2008). d is the width (km) of fault that ruptures toward site.
ctildepr	float		YES			select	c' parameter in Spudich et al. (2004). The approximate isochrone velocity ratio, has an angular behavior similar to cos(Theta.D) and cos(Phi.D). To calculate c.tilde.prime, Vr/beta (Vs) is assumed to be 0.8 for all earthquakes.
T	float		YES			select	Generalized T Coordinate at the site, produced using the algorithm in Appendix A of Spudich and Chiou (2008).
U	float		YES			select	Generalized U Coordinate at the site, produced using the algorithm in Appendix A of Spudich and Chiou (2008).

path_old

Field	Type	Collation	Null	Key	Extra	Privileges	Comment
path_id	int(11)		NO	PRI	auto_increment	select	Primary key; unique ID assigned to each ground motion for identification.
epicentral_distance	float		YES			select	Distance (km) from the recording site to the earthquake epicenter.
hypo_distance	float		YES			select	Distance (km) from the recording site to the earthquake hypocenter
rjb	float		YES			select	Joyner-Boore distance (km). Shortest horizontal distance from the recording site to the vertical projection of the rupture surface.
rrup	float		YES			select	Closest distance (km) from the recording site to the ruptured fault area.
rx	float		YES			select	Horizontal distance (km) from the top edge of the rupture, measured perpendicular to the fault strike.
ry	float		YES			select	Horizontal distance (km) from the top edge of the rupture, measured along the fault strike.
ry0	float		YES			select
rmsd	float		YES			select	Root-mean-squared distance (km).
rebe	float		YES			select	Distance (km) from the epicenter to the basin edge along a line between the epicenter and the station.
rsbe1	float		YES			select	Distance (km) from the station to the basin edge along a line between the epicenter and the station.
closest_point_latitude	float(8,5)		YES			select	Latitude (degrees) of the closest point on the fault.
closest_point_longitude	float(8,5)		YES			select	Longitude (degrees) of the closest point on the fault.
closest_point_depth	float		YES			select	Depth (km) of the closest point on the fault.
hanging_wall	varchar(1)	utf8_unicode_ci	YES			select	This field mimics the FW/HW indicator defined in Abrahamson and Somerville (1996). hw = site is within hanging wall region; fw = site is within the footwall region; nu = site is in the neutral region; na = not applicable as fault dip is greader than 70 degrees.
source_to_site_azimuth	float		YES			select	The (finite) source to site direction: It is the angle measured clockwise from the fault strike direction to the direction connecting the site and the site's closest point on the surface projection of top edge of fault. This column can be used an alternative to the FW/HW indicator given previously.
X	float		YES			select	Somerville et al. (1997) X parameter (nondimensional units). For multiple? segment faults calculated following a method of Boatwright (2007).
theta_D	float		YES			select	Somerville et al. (1997) theta_D parameter (degrees). For multiple? segment faults calculated following a method of Boatwright (2007).
Y	float		YES			select	Somerville et al. (1997) Y parameter (nondimensional units). For multiple? segment faults calculated following a method of Boatwright (2007).
phi_D	float		YES			select	Somerville et al. (1997) phi_D parameter (degrees). For multiple? segment faults calculated following a method of Boatwright (2007).
ssga_strike_slip	float		YES			select	Somerville et al. (1997) X cos(theta_D) parameter. For multiple?segment faults calculated following a method of Boatwright (2007); Calculated for sites within 50km (Rrup) of a strike?slip fault (mechanism = 0).
ssga_dip_slip	float		YES			select	Somerville et al. (1997) Y cos(phi_D) parameter (degrees). For multiple?segment faults calculated following a method of Boatwright (2007). Calculated for sites within 50km (ClstD) on the footwall (FW) or hanging wall (HW) of a dip? slip fault (mechanism not equal to 0).
s	float		YES			select	s parameter in Spudich and Chiou (2008). s is the length (km) of fault that ruptures toward site.
d	float		YES			select	d parameter in Spudich and Chiou (2008). d is the width (km) of fault that ruptures toward site.
ctildepr	float		YES			select	c' parameter in Spudich et al. (2004). The approximate isochrone velocity ratio, has an angular behavior similar to cos(Theta.D) and cos(Phi.D). To calculate c.tilde.prime, Vr/beta (Vs) is assumed to be 0.8 for all earthquakes.
T	float		YES			select	Generalized T Coordinate at the site, produced using the algorithm in Appendix A of Spudich and Chiou (2008).
U	float		YES			select	Generalized U Coordinate at the site, produced using the algorithm in Appendix A of Spudich and Chiou (2008).

response_spectra

Field	Type	Null	Key	Extra	Privileges	Comment
response_spectra_id	int(11)	NO	PRI	auto_increment	select	Primary key; unique ID assigned to each response specrum spectral ordiant for identification
time_series_metadata_id	int(11)	NO	MUL		select	Foreign key; unique ID assigned to time series metadata field motion for identification
period	decimal(5,3)	NO	MUL		select	Oscillator period (s)
psa_h1	double	YES			select	Pseudo-acceleration response spectral ordinant (g) for the first as-recorded horizontal component (H1)
psa_h2	double	YES			select	Pseudo-acceleration response spectral ordinant (g) for the second as-recorded horizontal component (H2)
psa_v	double	YES			select	Pseudo-acceleration response spectral ordinant (g) for the as-recorded vertical component (V)
psa_rotd0	double	YES			select	Pseudo-acceleration response spectral ordinant (g) for the minimum horizontal component (RotD00)
psa_rotd50	double	YES			select	Pseudo-acceleration response spectral ordinant (g) for the median horizontal component (RotD50)
psa_rotd100	double	YES			select	Pseudo-acceleration response spectral ordinant (g) for the maximum horizontal component (RotD100)
damping	float	NO			select	Damping (expressed as a decimal)

site

Field	Type	Collation	Null	Key	Default	Extra	Privileges	Comment
site_id	int(11)		NO	PRI		auto_increment	select	Primary key; unique ID assigned to each site for identification.
site_longitude	float(8,5)		NO				select	Site longitude (degrees).
site_latitude	float(8,5)		NO				select	Site latitude (degrees).
site_elevation	float		YES				select	Elevation (m) of the site (ground surface)
site_country	varchar(100)	utf8_unicode_ci	YES				select	Country the site is located in.
site_subdivision	varchar(100)	utf8_unicode_ci	YES				select	Subdivision within a country (e.g., state, province, prefecture) the site is located in.
site_name	varchar(100)	utf8_unicode_ci	YES				select	Site name, usually the same as station name for sites with one station.
vs30	float		NO				select	Preferred 30 m time-averaged shear wave veloctiy (VS30) (m/s)
vs30_lnstd	float		YES				select	Log standard deviation (ln units) of preferred VS30 value.
vs30_code_id	int(11)		YES	MUL			select	Foreign key; unique ID assigned to each vs30 code for identification.
vs30_ref	varchar(500)	utf8_unicode_ci	YES				select	Reference for source of assigned VS30: If VS30 calculated from a VS profile, reference to source database abbreviation and entry: CESMD = Center for Engineering Strong Motion Data; NGAW2 = NGA-West2 site database; USGS = USGS VS30 database; VSPDB = Community Velocity Profile Database. If VS30 estimated: Geo = geology-based proxy; Geo_Terr = geology and terrain-based proxies; Kri = Kriging; Kri_Terr = Kriging and terrain-based proxies; Terr = terrain-based proxy.
geological_unit	varchar(10)	utf8_unicode_ci	YES				select	Surficial geological unit.
geological_ref	varchar(500)	utf8_unicode_ci	YES				select	Reference to geologic map used to assign geological unit.
geological_citation_id	int(11)		NO	MUL	1		select	Foreign key; unique ID assigned to each citation for identification - citation for geological unit
slope_gradient	float		YES				select	Topographic slope (%)
slope_resolution	varchar(10)	utf8_unicode_ci	YES				select	Resolution of digital elevation map (DEM) used to calculate topographic slope.
terrain_class	int(11)		YES				select	Geomorphology-based terrain category (Iwahashi and Pike 2007)
terrain_citation_id	int(11)		NO	MUL	1		select	Foreign key; unique ID assigned to each citation for identification - citation for terrain class
z1p0_preferred	float		YES				select	Preferred depth (m) to Vs = 1.0 km/s
z2p5_preferred	float		YES				select	Preferred depth (m) to Vs = 2.5 km/s
basin_province	int(11)		YES				select	Geomorphic province category (Nweke et al. 2020): 0 = mountain-hill (sites without significant sediments, generally having topographic relief); 1 = valley ("small" sedimentary structure); 2 = basin edge (along basin margin); 3 = basin (site location in basin interior).
gmx_c2	varchar(5)	utf8_unicode_ci	YES				select	Second letter of Geomatrix's site classification: Mapped local geology.
gmx_c3	varchar(5)	utf8_unicode_ci	YES				select	Third letter of Geomatrix's site classification: Geotechnical subsuface characteristics.
rsbe	float		YES				select	Closest distance (km) from the site to the basin edge.
rcebe	float		YES				select	Perpendicular distance (km) from the site to the basin edge.

site_geometry

Field	Type	Null	Key	Extra	Privileges	Comment
site_geometry_id	int(11)	NO	PRI	auto_increment	select	Primary key; unique ID assigned to each site and geometry combination for identification.
site_id	int(11)	NO	MUL		select	Foreign key; unique ID assigned to each site for identification.
geometry_id	int(11)	NO	MUL		select	Foreign key; unique ID assigned to each geometry for identification.

station

Field	Type	Collation	Null	Key	Extra	Privileges	Comment
station_id	int(11)		NO	PRI	auto_increment	select	Primary key; unique ID assigned to each station for identification.
site_id	int(11)		NO	MUL		select	Foreign key; unique ID assigned to each site for identification.
network_id	int(11)		NO	MUL		select	Foreign key; unique ID assigned to each network for identification.
station_name	varchar(100)	utf8_unicode_ci	YES			select	The unique name of the strong-motion station, which may differ slightly from that provided by the data provider. When it is part of an array, a short phrase is sometimes added to indicate the location of the instrument (for example, "Rio Del Overpass E Ground" and "Rio Del Overpass W Ground").
station_latitude	float(8,5)		NO			select	Station latitude (degrees)
station_longitude	float(8,5)		NO			select	Station logitude (degrees)
station_elevation	float		YES			select	Station elevation (m)
station_code	varchar(10)	utf8_unicode_ci	YES			select	Station code assigned by data provider.
housing	varchar(5)	utf8_unicode_ci	YES			select	Code for station housing, adapted from Geomatrix 1st letter.
cosmos_station_type	int(11)		YES			select
sensor_depth	float		YES			select	Station depth (m) from ground surface; negative values indicate height in structure relative to ground surface.
installation_date	date		YES			select	Date the instrument was installed
removal_date	date		YES			select	Date the instrument was removed

station_ssn

Field	Type	Collation	Null	Key	Extra	Privileges	Comment
station_ssn_id	int(11)		NO	PRI	auto_increment	select	Primay key; unique ID assigned to each station and collection combination for identification.
station_id	int(11)		NO	MUL		select	Foreign key; unique ID assigned to each station for identification.
collection_id	int(11)		NO	MUL		select	Foreign key; unique ID assigned to each collection for identification.
ssn	varchar(50)	utf8_unicode_ci	NO			select	Station sequence number (SSN): unique number assigned to each station in the linked collection.

time_series_data

Field	Type	Collation	Null	Key	Extra	Privileges	Comment
time_series_data_id	int(11)		NO	PRI	auto_increment	select	Primary key; unique ID assigned to each time-series data for identification
time_series_metadata_id	int(11)		NO	UNI		select	Foreign key; unique ID assigned to each time-series metadata for identification
acc_h1	mediumtext	utf8_unicode_ci	YES			select	Acceleration (g) time-series for the first horizontal component (H1); JSON format {"acceleration":[...]}
acc_h2	mediumtext	utf8_unicode_ci	YES			select	Acceleration (g) time-series for the second horizontal component (H2); JSON format {"acceleration":[...]}
acc_v	mediumtext	utf8_unicode_ci	YES			select	Acceleration (g) time-series for the vertical component (V); JSON format {"acceleration":[...]}

time_series_metadata

Field	Type	Collation	Null	Key	Default	Extra	Privileges	Comment
time_series_metadata_id	int(11)		NO	PRI		auto_increment	select	Primary key; unique ID assigned to each time-series metadata for identification
motion_id	int(11)		NO	UNI			select	Foreign key; unique ID assigned to each ground motion for identification
user_id	int(11)		NO				select
instrument_type	int(11)		YES				select	Type of instrument: 0 = analog; 1 = accelerometer; 2 = seismometer; 3 = MEMS accelerometer; NULL = unknown (likely digital if from a modern earthquake)
colocated_instrument	int(11)		YES				select	Indicator if the station has colocated instruments: 0 = only one instrument; 1 = at least two colocated instruments (the record in the database was selected from the instrument with the widest usable bandwidth for the combined horizontal component - based on hpass_fc and lpass_fc)
instrument_natural_frequency	float		YES				select	Natural frequency (Hz) of the instrument
sampling_rate	float		YES				select	Sampling rate (Hz)
late_p_trigger	varchar(45)	utf8_unicode_ci	YES				select	DNR = Did not record the vertcal component; DNP = Did not process the vertical component (e.g., late trigger); d = Digital with pre-event memory, did not record the first P-wave onset; ? = Analog recording that probably recorded largest amplitudes on the vertical component but the P-wave onset not recorded, OR probably recorded largest amplitude on the horizontal component(s) for the S-wave; Y = Late trigger, probably did not record the largest vertical amplitude, the characteristicdiagnostic is that the largest amplitude is at start of recording on the vertical component
late_s_trigger	varchar(45)	utf8_unicode_ci	YES				select	DNR = Did not record the vertcal component; DNP = Did not process the vertical component (e.g., late trigger); d = Digital with pre-event memory, did not record the first P-wave onset; ? = Analog recording that probably recorded largest amplitudes on the vertical component but the P-wave onset not recorded, OR probably recorded largest amplitude on the horizontal component(s) for the S-wave; Y = Late trigger, probably did not record the largest vertical amplitude, the characteristicdiagnostic is that the largest amplitude is at start of recording on the vertical component
processing_type	int(11)		NO				select	Indicator for how the acceleration time history was processed: 0 = Adopting already processed record (e.g., NGA-West2 records); 1 = fully-manual processing; 2 = automated-processing with manual inspection/modification (e.g., gm_process GUI); 3 = fully-automated (not preferred)
filter_type	int(11)		YES				select	Type of filter: 1 = Ormsby (O); 2 = Acausal Butterworth (A); 3 = Causal Butterworth (C)
order_hpass	int(11)		YES				select	High-pass filter order
order_lpass	int(11)		YES				select	Low-pass filter order
azimuth_h1	float		YES				select	Azimuth of the first horizontal component (H1) (degrees clockwise from north)
azimuth_h2	float		YES				select	Azimuth of the second horizontal component (H2) (degrees clockwise from north)
hpass_fc_h1	float		YES				select	High-pass filter corner frequency (Hz) used on the first horizontal component (H1). NULL entries indicate that a high-pass filter was not applied (either because the component was not recorded or filtering was not needed).
hpass_fc_h2	float		YES				select	High-pass filter corner frequency (Hz) used on the second horizontal component (H2). NULL entries indicate that a high-pass filter was not applied (either because the component was not recorded or filtering was not needed).
hpass_fc_v	float		YES				select	High-pass filter corner frequency (Hz) used on the vertical component (V). NULL entries indicate that a high-pass filter was not applied (either because the component was not recorded or filtering was not needed).
lpass_fc_h1	float		YES				select	Low-pass filter corner frequency (Hz) used on the first horizontal component (H1). NULL entries indicate that a low-pass filter was not applied (either because the component was not recorded or filtering was not needed).
lpass_fc_h2	float		YES				select	Low-pass filter corner frequency (Hz) used on the second horizontal component (H2). NULL entries indicate that a low-pass filter was not applied (either because the component was not recorded or filtering was not needed).
lpass_fc_v	float		YES				select	Low-pass filter corner frequency (Hz) used on the vertical component (V). NULL entries indicate that a low-pass filter was not applied (either because the component was not recorded or filtering was not needed).
usable_frequency_factor	float		YES				select	Factor used to compute the usable frequency range: longest usable period = 1 / (usable_frequency_factor * hpass_fc)
konno_omachi_points	int(11)		YES				select	Number of frequencies per log cycle in smoothed FAS (fourier_spectra table)
smoothing_bandwidth	float		YES				select	Bandwidth of smoothing window in log10 units for FAS (fourier_spectra table); Variable is "bw" in Kottke et al. (2021)
window_width	float		YES				select	Frequency multiplier defining width of Konno-Omachi smoothing window for FAS (fourier_spectra_table)
public_time_series	tinyint(4)		NO		0		select	Indicator for the release status of the time-series data: 0 = private (not released); 1 = public (released)
time_series_citation_id	int(11)		NO	MUL	1		select	Foreign key; unique ID assigned to each citation for identification - citation for original source of processed time-series data

user

Field	Type	Collation	Null	Key	Default	Extra	Privileges	Comment
user_id	int(255)		NO	PRI		auto_increment	select	Primary key; unique ID assigned to each user for identification.
username	varchar(100)	utf8_unicode_ci	NO	UNI			select
password	varchar(60)	utf8_unicode_ci	NO				select
first_name	varchar(100)	utf8_unicode_ci	NO				select	User first name.
last_name	varchar(100)	utf8_unicode_ci	NO				select	User last name.
email	varchar(255)	utf8_unicode_ci	NO	UNI			select	User contact email address.
reg_date	datetime		NO				select
organization	varchar(100)	utf8_unicode_ci	NO				select
country	varchar(50)	utf8_unicode_ci	NO				select
num_logins	int(11)		NO				select
num_html_requests	int(11)		NO				select
num_json_requests	int(11)		NO				select
num_csv_requests	int(11)		NO				select
is_verified	tinyint(4)		NO				select
is_active	tinyint(4)		NO				select
modeler	tinyint(4)		NO		0		select
admin	tinyint(4)		NO		0		select
role	varchar(30)	utf8_unicode_ci	NO		user		select
token	varchar(64)	utf8_unicode_ci	NO				select

version

Field	Type	Collation	Null	Key	Extra	Privileges
version_id	int(11)		NO	PRI	auto_increment	select
version_number	int(11)		NO			select
version_description	varchar(100)	utf8_unicode_ci	NO			select
version_database	varchar(30)	utf8_unicode_ci	NO			select
version_date	datetime		NO			select

version_time_series_metadata

Field	Type	Null	Key	Default	Extra	Privileges
version_time_series_metadata_id	int(11)	NO	PRI		auto_increment	select
version_id	int(11)	NO	MUL	1		select
time_series_metadata_id	int(11)	NO	MUL			select

vs30_citation

Field	Type	Null	Key	Extra	Privileges	Comment
vs30_citation_id	int(11)	NO	PRI	auto_increment	select	Primary key; unique ID assigned to each site and citation combination for identification.
site_id	int(11)	NO	MUL		select	Foreign key; unique ID assigned to each site for identification.
citation_id	int(11)	NO	MUL		select	Foreign key; unique ID assigned to each citation for identification.

vs30_code

Field	Type	Collation	Null	Key	Extra	Privileges	Comment
vs30_code_id	int(11)		NO	PRI	auto_increment	select	Primary key; unique ID assigned to each vs30 code for identification.
published_code	varchar(10)	utf8_unicode_ci	YES			select
vs30_code_description	varchar(1000)	utf8_unicode_ci	YES			select	Description of method used to assign preferred VS30 value.