List of Publicly Accessible Tables

Table Name	Number of Rows	Size (bytes)	Comment
aftershock_mainshock	276	16384	Intra-event distance (CRJB) between aftershock and mainshock events.
basin_model	16	16384	Model for basin parameters (e.g., z1, z2.5)
basin_site	21932	1392640	Basin parameters (e.g., z1, z2.5) for each site
citation	910	294912	Citation information
collection	15	16384	A collection groups motions, events, or stations together into a common set
collection_motion	315659	12075008	A junction table mapping motions to collections
event	7204	1540096	Earthquake events
event_eqid	13542	1589248	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	7363	442368	Finite fault model parameters
finite_fault_kinematic_parameter	68	16384	Finite-fault kinematic parameters from a published source.
finite_fault_segment	7296	1589248	Finite fault segments for multi-segment ruptures
fourier_spectra	60127910	2703228928	Fourier amplitude spectra, smoothed and decimated
geometry	57	6832128	GeoJSON geometries delineating geophraphic features, regions, basins, etc.
intensity_measure	180453	84574208	Ground motion intensity measures
motion	180864	7880704	Ground motion parameters
network	197	65536	Seismic network parameters
path	181673	19447808	Path metrics
response_spectra	18128427	1870659584	Pseudo-acceleration response spectra
site	14352	3686400	Site information (location, VS30, etc.)
site_geometry	58266	2637824	Join table between site and geometry tables
station	14153	1589248	Station information (station code, location, etc.)
station_ssn	25613	1589248	A junction table mapping stations to NGA station sequence numbers
time_series_data	78045	70117769216	Ground motion time series data
time_series_metadata	181180	25739264	Ground motion time series metadata and processing parameters
version	0	16384
version_time_series_metadata	186917	6832128
vs30_citation	15332	540672	Citations for VS30 assignments.
vs30_code	18	16384	Methods used to assign preferred VS30 value.
z_code	7	16384	Methods used to assign preferred z1.0 and z2.5

aftershock_mainshock

Field	Type	Null	Key	Default	Comment
aftershock_mainshock_id	int(11)	NO	PRI		Primay key; unique ID assigned to each pair of aftersock-mainshock events.
aftershock_event_id	int(11)	NO	MUL		Foreign key; unique ID assigned to each earthquake for identification - corresponding to the aftershock.
mainshock_event_id	int(11)	NO	MUL		Foreign key; unique ID assigned to each earthquake for identification - corresponding to the mainshock.
crjb	float	YES			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	Null	Key	Default	Comment
basin_model_id	int(11)	NO	PRI		Primary key; unique ID assigned to each basin model for identification.
model_name	varchar(100)	YES	UNI		Full name of basin model.
model_abbreviation	varchar(25)	NO			Common abbreviation for the basin model.
model_ref	varchar(500)	YES			Basin model reference.
basin_model_citation_id	int(11)	NO	MUL	1	Foreign key; unique ID assigned to each citation for identification - citation of basin model

basin_site

Field	Type	Null	Key	Default	Comment
basin_site_id	int(11)	NO	PRI		Primary key; unique ID assigned to each basin model and site combination for identification.
site_id	int(11)	NO	MUL		Foreign key; unique ID assigned to each site for identification.
basin_model_id	int(11)	NO	MUL		Foreign key; unique ID assigned to each basin model for identification.
z1p0	float	YES			Depth (m) to Vs = 1.0 km/s.
z1p0_lnstd	float	YES			Log standard deviation (ln units) of z1p0 estimate
z2p5	float	YES			Depth (m) to Vs = 2.5 km/s.
z2p5_lnstd	float	YES			Log standard deviation (ln units) of z2p5 estimate

citation

Field	Type	Null	Key	Default	Comment
citation_id	int(11)	NO	PRI
citation_text	varchar(1000)	YES			Citation for information contained in database
citation_url	varchar(1000)	YES			Uniform resource locator (URL) for citation
citation_hash	varchar(32)	NO	UNI

collection

Field	Type	Null	Key	Default	Comment
collection_id	int(11)	NO	PRI		Primary key; unique ID assigned to each collection for identification.
collection_name	varchar(100)	YES	UNI		Common name for the collection.
collection_description	varchar(1000)	YES			Description of what the collection contains.
collection_ref	varchar(5000)	YES			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	Foreign key; unique ID assigned to each citation for identification - citation of collection

collection_motion

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

event

Field	Type	Null	Key	Default	Comment
event_id	int(11)	NO	PRI		Primary key; unique ID assigned to each earthquake for identification.
hypocenter_longitude	float(8,5)	NO	MUL		Hypocenter longitude (degrees)
hypocenter_latitude	float(8,5)	NO			Hypocenter latitude (degrees)
event_country	varchar(100)	YES			Country the event is located in (based on the epicenter).
event_subdivision	varchar(100)	YES			Subdivision within a country (e.g., state, province, prefecture) the event is located in (based on the epicenter).
event_name	varchar(100)	YES			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)	YES			The ANSS Comprehensive Earthquake Catalog (ComCat) unique ID.
event_type_id	int(11)	NO	MUL		Foreign key; unique ID assigned to each earthquake type for identification.
datetime	datetime	YES			Date and time of the earthquake.
time_zone	varchar(10)	YES			Corresponding time zone for the recorded date and time.
hypocenter_reported_depth	float	YES			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)	YES			Reference depth datum for reported hypocenter depth (e.g., WGS84 Geoid/mean sea level)
epicenter_elevation	float	YES			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			Hypocenter depth (km) relative to the ground surface; depth measured positive into the ground
magnitude	float	NO			Magnitude of the earthquake.
magnitude_type	varchar(10)	YES			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			Magnitude uncertainty assigned using Kagan's model (Kagan 2002).
magnitude_uncertainty_statistical	float	YES			Magnitude uncertainty is taken as the standard deviation of the reliable magnitude estimates.
magnitude_sample_size	int(11)	YES			Number of magnitude estimates used to compute the standard deviation.
magnitude_uncertainty_study_class	int(11)	YES			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			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			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			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			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			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			Seismic moment (dyne.cm)
p_plunge	float	YES			Plunge (degrees) of the maximum compressive (P) principal stress given by the fault plane solution.
p_trend	float	YES			Trend (degrees) of the maximum compressive (P) principal stress given by the fault plane solution.
t_plunge	float	YES			Plunge (degrees) of the minimum compressive (T) principal stress given by the fault plane solution.
t_trend	float	YES			Trend (degrees) of the minimum compressive (P) principal stress given by the fault plane solution.
coseismic_surface_rupture	int(1)	YES			Presence or absence of primary surface rupture: 0 = No; 1 = Yes.
basis_for_surface_rupture	int(11)	YES			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			Earthquake in extensional regime: 0 = No; 1 = Yes
extensional_regime_name	varchar(100)	YES			Name of the potential extensional regime

event_eqid

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

event_geometry

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

event_type

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

finite_fault

Field	Type	Null	Key	Default	Comment
finite_fault_id	int(11)	NO	PRI		Primary key; unique ID assigned to each finite-fault or simulated rupure surface for identification.
event_id	int(11)	NO	MUL		Foreign key; unique ID assigned to each earthquake for identification.
ztor	float	YES			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			Total length ("L") of the finite rupture model (km).
fault_width	float	YES			Width ("W" = A/L) of the finite rupture model (km).
fault_area	float	YES			Total area ("A") of the finite rupture model (km^2).
ffm_model	int(1)	YES			Indicator if the finite-fault parameters come from a published finite-fault model (1), were simulated (0), or are unknown (2).
ffm_complexity	int(1)	YES			Indicator for complexity of the rupture: 1 = simple (e.g., single-segment); 2 = moderate (e.g., multi-segment and single sub-rupture; variable strikes but same dip, ztor, and width); 3 = complex (e.g., multi-segment and multi-sub-rupture; variable strike, dip, ztor, and/or width; possible sub-parallel sub-ruptures)
ffm_reference	varchar(500)	YES			Reference of publication used to assign finite-fault parameters (if from a model).
finite_fault_citation_id	int(11)	NO	MUL	1	Foreign key; unique ID assigned to each citation for identification - citation of finite fault

finite_fault_kinematic_parameter

Field	Type	Null	Key	Default	Comment
finite_fault_kinematic_parameter_id	int(11)	NO	PRI		Primary key; unique ID assigned to each finite-fault kinematic parameter for identification.
finite_fault_id	int(11)	NO	MUL		Foreign key; unique ID assigned to each finite-fault for identification.
average_fault_displacement	float	YES			The average amount of slip (cm) over the ruptured area. It's computed as Mo/(Mu*A*1.0E+10) where Mu=3.58e11.
rise_time	float	YES			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			Average Slip Velocity (cm/s) = (Average Fault Displacement) / (Rise time)
preferred_rupture_velocity	float	YES			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			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			Percentage of moment release in the top 5 km of crust; calcualted from an appropiate slip model.
existence_of_shallow_asperity	int(1)	YES			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			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	Default	Comment
finite_fault_segment_id	int(11)	NO	PRI		Primary key; unique ID assigned to each finite-fault segment for identification.
finite_fault_id	int(11)	YES	MUL		Foreign key; unique ID assigned to each finite-fault or simulated rupure surface for identification.
seg_number	int(11)	YES			Finite fault segment number
seg_sub_rupture_number	int(11)	YES			Finite fault sub-rupture number
ULC_latitude	float(8,5)	YES			Upper left corner latitude (degrees)
ULC_longitude	float(8,5)	YES			Upper left corner longitude (degrees)
ULC_depth	float	YES			Upper left corner depth (km)
seg_length	float	YES			Segment length ("l") (km).
seg_width	float	YES			Segment width ("w") (km)
seg_area	float	YES			Segment area ("a") (km^2)
seg_strike	float	YES			Strike angle (degrees) of the fault segment; 0 <= strike <= 360.
seg_dip	float	YES			Dip angle (degrees) of the fault segment plane. 0 <= dip <= 90.
seg_rake	float	YES			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	Default	Comment
fourier_spectra_id	int(11)	NO	PRI		Primary key; unique ID assigned to each fourier specrum ordiant for identification
time_series_metadata_id	int(11)	NO	MUL
frequency	decimal(12,9)	NO	MUL		Frequency (Hz)
fas_h1	double	YES			Fourier amplitude spectra (g-s) for the first as-recorded horizontal component (H1)
fas_h2	double	YES			Fourier amplitude spectra (g-s) for the second as-recorded horizontal component (H2)
fas_v	double	YES			Fourier amplitude spectra (g-s) for the as-recorded vertical component (V)
eas	double	YES			Orientation-independent effective amplitude specrtra (g-s); defined in Kottke et al. (2021)

geometry

Field	Type	Null	Key	Default	Comment
geometry_id	int(11)	NO	PRI		Primay key; unique ID assigned to each geoJSON for identification.
geometry_class	int(11)	YES			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			Indicator for the type of geometry: 0 = point; 1 = MulitPoint; 2 = LineString; 3 = MulitLineString; 4 = Polygon; 5 = MultiPolygon; 6 = GeometryCollection.
geometry_name	varchar(100)	YES	UNI		Geometry name.
geometry_description	varchar(5000)	YES			Geometry description.
geometry_ref	varchar(1000)	YES			Reference if the geometry is associated with a publication.
geometry_citation_id	int(11)	NO	MUL	1	Foreign key; unique ID assigned to each citation for identification - citation of geometry object
geometry_geojson	mediumtext	YES			GeoJSON containing points which make up the geometry.
geometry_test	geometry	YES

intensity_measure

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

motion

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

network

Field	Type	Null	Key	Default	Comment
network_id	int(11)	NO	PRI		Primary key; unique ID assigned to each seismic network for identification.
network_code	varchar(10)	YES	MUL		Network code assigned by data provider.
network_name	varchar(200)	YES			Network name.
network_type	varchar(50)	YES			Type of network (temporary or permanent).
start_date	date	NO			Initial start date the network began operating.
end_date	date	NO			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)	YES			Operating organization.
doi	varchar(1000)	YES			Digital object identifier (DOI).
network_citation_id	int(11)	NO	MUL	1	Foreign key; unique ID assigned to each citation for identification - citation of seismic network

path

Field	Type	Null	Key	Default	Comment
path_id	int(11)	NO	PRI		Primary key; unique ID assigned to each ground motion for identification.
station_id	int(11)	NO	MUL		Foreign key; unique ID assigned to each station for identification.
finite_fault_id	int(11)	NO	MUL		Foreign key; unique ID assigned to each finite_fault for identification.
epicentral_distance	float	YES			Distance (km) from the recording site to the earthquake epicenter.
hypocentral_distance	float	YES			Distance (km) from the recording site to the earthquake hypocenter
rjb	float	YES			Joyner-Boore distance (km). Shortest horizontal distance from the recording site to the vertical projection of the rupture surface.
rrup	float	YES			Closest distance (km) from the recording site to the ruptured fault area.
rx	float	YES			Horizontal distance (km) from the top edge of the rupture, measured perpendicular to the fault strike (|T|)
ry	float	YES			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			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			Average distance (km) to the rupture surface (formally rmsd or Rrms)
rebe	float	YES			Distance (km) from the epicenter to the basin edge along a line between the epicenter and the station.
rsbe1	float	YES			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			Latitude (degrees) of the closest point on the fault.
closest_point_longitude	float(8,5)	YES			Longitude (degrees) of the closest point on the fault.
closest_point_depth	float	YES			Depth (km) of the closest point on the fault; positive direction into the ground.
hanging_wall	varchar(5)	YES			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			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			Somerville et al. (1997) X parameter (nondimensional units). For multiple‐ segment faults calculated following a method of Boatwright (2007).
theta_D	float	YES			Somerville et al. (1997) theta_D parameter (degrees). For multiple‐ segment faults calculated following a method of Boatwright (2007).
Y	float	YES			Somerville et al. (1997) Y parameter (nondimensional units). For multiple‐ segment faults calculated following a method of Boatwright (2007).
phi_D	float	YES			Somerville et al. (1997) phi_D parameter (degrees). For multiple‐ segment faults calculated following a method of Boatwright (2007).
ssga_strike_slip	float	YES			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			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			s parameter in Spudich and Chiou (2008). s is the length (km) of fault that ruptures toward site.
d	float	YES			d parameter in Spudich and Chiou (2008). d is the width (km) of fault that ruptures toward site.
ctildepr	float	YES			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			Generalized T Coordinate at the site, produced using the algorithm in Appendix A of Spudich and Chiou (2008).
U	float	YES			Generalized U Coordinate at the site, produced using the algorithm in Appendix A of Spudich and Chiou (2008).

response_spectra

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

site

Field	Type	Null	Key	Default	Comment
site_id	int(11)	NO	PRI		Primary key; unique ID assigned to each site for identification.
site_longitude	float(8,5)	NO			Site longitude (degrees).
site_latitude	float(8,5)	NO			Site latitude (degrees).
site_elevation	float	YES			Elevation (m) of the site (ground surface)
site_country	varchar(100)	YES			Country the site is located in.
site_subdivision	varchar(100)	YES			Subdivision within a country (e.g., state, province, prefecture) the site is located in.
site_name	varchar(100)	YES			Site name, usually the same as station name for sites with one station.
vs30	float	NO			Preferred 30 m time-averaged shear wave veloctiy (VS30) (m/s)
vs30_lnstd	float	YES			Log standard deviation (ln units) of preferred VS30 value.
vs30_code_id	int(11)	YES	MUL		Foreign key; unique ID assigned to each vs30 code for identification.
vs30_ref	varchar(500)	YES			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(25)	YES			Surficial geological unit.
geological_ref	varchar(500)	YES			Reference to geologic map used to assign geological unit.
geological_citation_id	int(11)	NO	MUL	1	Foreign key; unique ID assigned to each citation for identification - citation for geological unit
slope_gradient	float	YES			Topographic slope (%)
slope_resolution	varchar(10)	YES			Resolution of digital elevation map (DEM) used to calculate topographic slope.
terrain_class	int(11)	YES			Geomorphology-based terrain category (Iwahashi and Pike 2007)
terrain_citation_id	int(11)	NO	MUL	1	Foreign key; unique ID assigned to each citation for identification - citation for terrain class
z1p0_preferred	float	YES			Preferred depth (m) to Vs = 1.0 km/s
z1p0_preferred_lnstd	float	YES			Log standard deviation (ln units) of preferred z1.0
z1p0_code_id	int(11)	YES	MUL		Foreign key; unique ID assigned to each z1p0 code for identification
z2p5_preferred	float	YES			Preferred depth (m) to Vs = 2.5 km/s
z2p5_preferred_lnstd	float	YES			Log standard deviation (ln units) of preferred z2.5
z2p5_code_id	int(11)	YES	MUL		Foreign key; unique ID assigned to each z2p5 code for identification
basin_province	int(11)	YES			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)	YES			Second letter of Geomatrix's site classification: Mapped local geology.
gmx_c3	varchar(5)	YES			Third letter of Geomatrix's site classification: Geotechnical subsuface characteristics.
rsbe	float	YES			Closest distance (km) from the site to the basin edge.
rcebe	float	YES			Perpendicular distance (km) from the site to the basin edge.

site_geometry

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

station

Field	Type	Null	Key	Default	Comment
station_id	int(11)	NO	PRI		Primary key; unique ID assigned to each station for identification.
site_id	int(11)	NO	MUL		Foreign key; unique ID assigned to each site for identification.
network_id	int(11)	NO	MUL		Foreign key; unique ID assigned to each network for identification.
station_name	varchar(100)	YES			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			Station latitude (degrees)
station_longitude	float(8,5)	NO			Station logitude (degrees)
station_elevation	float	YES			Station elevation (m)
station_code	varchar(10)	YES			Station code assigned by data provider.
housing	varchar(5)	YES			Code for station housing, adapted from Geomatrix 1st letter.
cosmos_station_type	int(11)	YES
sensor_depth	float	YES			Station depth (m) from ground surface; negative values indicate height in structure relative to ground surface.
installation_date	date	YES			Date the instrument was installed
removal_date	date	YES			Date the instrument was removed

station_ssn

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

time_series_data

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

time_series_metadata

Field	Type	Null	Key	Default	Comment
time_series_metadata_id	int(11)	NO	PRI		Primary key; unique ID assigned to each time-series metadata for identification
motion_id	int(11)	NO	UNI		Foreign key; unique ID assigned to each ground motion for identification
user_id	int(11)	NO
instrument_type	int(11)	YES			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			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			Natural frequency (Hz) of the instrument
sampling_rate	float	YES			Sampling rate (Hz)
late_p_trigger	varchar(45)	YES			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)	YES			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
multiple_wave_train	int(11)	YES			Indicator if the record contains multiple events: 0 = single event; 1 = multiple wave-train arrivals
processing_type	int(11)	NO			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			Type of filter: 1 = Ormsby (O); 2 = Acausal Butterworth (A); 3 = Causal Butterworth (C)
order_hpass	int(11)	YES			High-pass filter order
order_lpass	int(11)	YES			Low-pass filter order
azimuth_h1	float	YES			Azimuth of the first horizontal component (H1) (degrees clockwise from north)
azimuth_h2	float	YES			Azimuth of the second horizontal component (H2) (degrees clockwise from north)
hpass_fc_h1	float	YES			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			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			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			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			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			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			Factor used to compute the usable frequency range: longest usable period = 1 / (usable_frequency_factor * hpass_fc)
konno_omachi_points	int(11)	YES			Number of frequencies per log cycle in smoothed FAS (fourier_spectra table)
smoothing_bandwidth	float	YES			Bandwidth of smoothing window in log10 units for FAS (fourier_spectra table); Variable is "bw" in Kottke et al. (2021)
window_width	float	YES			Frequency multiplier defining width of Konno-Omachi smoothing window for FAS (fourier_spectra_table)
public_time_series	tinyint(4)	NO		0	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	Foreign key; unique ID assigned to each citation for identification - citation for original source of processed time-series data

version

Field	Type	Null	Key	Default	Comment
version_id	int(11)	NO	PRI
version_number	int(11)	NO
version_description	varchar(100)	NO
version_database	varchar(30)	NO
version_date	datetime	NO

version_time_series_metadata

Field	Type	Null	Key	Default	Comment
version_time_series_metadata_id	int(11)	NO	PRI
version_id	int(11)	NO	MUL	1
time_series_metadata_id	int(11)	NO	MUL

vs30_citation

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

vs30_code

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

z_code

Field	Type	Null	Key	Default	Comment
z_code_id	int(11)	NO	PRI		Primary key; unique ID assigned to each z code for identification
z_code_description	varchar(1000)	NO			Description of method used to assigne preferred z1.0 or z2.5