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	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	350454	14172160	A junction table mapping motions to collections
downloads	0	16384
eas	188320	31080448
event	7496	1589248	Earthquake events
event_eqid	13371	1343488	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
flatfile	691096	23642112
fourier_spectra	62473737	2886729728	Fourier amplitude spectra, smoothed and decimated
frequencies	389	4279
geometry	57	6832128	GeoJSON geometries delineating geophraphic features, regions, basins, etc.
intensity_measure	180400	84574208	Ground motion intensity measures
motion	191822	8929280	Ground motion parameters
network	197	65536	Seismic network parameters
path	181673	19447808	Path metrics
periods	111	888
psa_h1	155601	170721280
psa_h2	168066	182272000
psa_rotd0	137092	149716992
psa_rotd100	164724	185434112
psa_rotd50	172792	190676992
psa_v	119890	125550592
response_spectra	18122544	1870659584	Pseudo-acceleration response spectra
site	14839	4734976	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	25327	1540096	A junction table mapping stations to NGA station sequence numbers
time_series_data	78045	70117769216	Ground motion time series data
time_series_metadata	188708	26787840	Ground motion time series metadata and processing parameters
user	461	163840	User information
version	1	16384
version_time_series_metadata	200	16384
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	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.
z1p0_lnstd	float	YES			select	Log standard deviation (ln units) of z1p0 estimate
z2p5	float	YES			select	Depth (m) to Vs = 2.5 km/s.
z2p5_lnstd	float	YES			select	Log standard deviation (ln units) of z2p5 estimate

citation

Field	Type	Collation	Null	Key	Extra	Privileges	Comment
citation_id	int(11)		NO	PRI	auto_increment	select
citation_text	varchar(1000)	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

downloads

Field	Type	Null	Key	Privileges
download_id	int(11)	NO	PRI	select
user_id	int(11)	NO	MUL	select
time_series_metadata_id	int(11)	NO	MUL	select
datetime	datetime	NO		select

eas

Field	Type	Null	Key	Extra	Privileges
eas_id	int(11)	NO	PRI	auto_increment	select
time_series_metadata_id	int(11)	YES	MUL		select
eas_0p013182570	double	YES			select
eas_0p013489630	double	YES			select
eas_0p013803850	double	YES			select
eas_0p014125380	double	YES			select
eas_0p014454400	double	YES			select
eas_0p014791090	double	YES			select
eas_0p015135620	double	YES			select
eas_0p015488170	double	YES			select
eas_0p015848932	double	YES			select
eas_0p016218101	double	YES			select
eas_0p016595870	double	YES			select
eas_0p016982440	double	YES			select
eas_0p017378010	double	YES			select
eas_0p017782792	double	YES			select
eas_0p018197010	double	YES			select
eas_0p018620870	double	YES			select
eas_0p019054604	double	YES			select
eas_0p019498450	double	YES			select
eas_0p019952621	double	YES			select
eas_0p020417380	double	YES			select
eas_0p020892960	double	YES			select
eas_0p021379621	double	YES			select
eas_0p021877620	double	YES			select
eas_0p022387214	double	YES			select
eas_0p022908680	double	YES			select
eas_0p023442290	double	YES			select
eas_0p023988330	double	YES			select
eas_0p024547090	double	YES			select
eas_0p025118870	double	YES			select
eas_0p025703962	double	YES			select
eas_0p026302684	double	YES			select
eas_0p026915352	double	YES			select
eas_0p027542291	double	YES			select
eas_0p028183832	double	YES			select
eas_0p028840320	double	YES			select
eas_0p029512094	double	YES			select
eas_0p030199520	double	YES			select
eas_0p030902960	double	YES			select
eas_0p031622774	double	YES			select
eas_0p032359361	double	YES			select
eas_0p033113110	double	YES			select
eas_0p033884413	double	YES			select
eas_0p034673680	double	YES			select
eas_0p035481333	double	YES			select
eas_0p036307800	double	YES			select
eas_0p037153530	double	YES			select
eas_0p038018941	double	YES			select
eas_0p038904520	double	YES			select
eas_0p039810720	double	YES			select
eas_0p040738031	double	YES			select
eas_0p041686940	double	YES			select
eas_0p042657950	double	YES			select
eas_0p043651580	double	YES			select
eas_0p044668360	double	YES			select
eas_0p045708820	double	YES			select
eas_0p046773523	double	YES			select
eas_0p047863020	double	YES			select
eas_0p048977890	double	YES			select
eas_0p050118730	double	YES			select
eas_0p051286142	double	YES			select
eas_0p052480750	double	YES			select
eas_0p053703181	double	YES			select
eas_0p054954090	double	YES			select
eas_0p056234132	double	YES			select
eas_0p057543992	double	YES			select
eas_0p058884363	double	YES			select
eas_0p060255960	double	YES			select
eas_0p061659500	double	YES			select
eas_0p063095730	double	YES			select
eas_0p064565412	double	YES			select
eas_0p066069360	double	YES			select
eas_0p067608304	double	YES			select
eas_0p069183100	double	YES			select
eas_0p070794582	double	YES			select
eas_0p072443600	double	YES			select
eas_0p074131020	double	YES			select
eas_0p075857751	double	YES			select
eas_0p077624710	double	YES			select
eas_0p079432822	double	YES			select
eas_0p081283050	double	YES			select
eas_0p083176370	double	YES			select
eas_0p085113793	double	YES			select
eas_0p087096370	double	YES			select
eas_0p089125104	double	YES			select
eas_0p091201100	double	YES			select
eas_0p093325440	double	YES			select
eas_0p095499262	double	YES			select
eas_0p097723722	double	YES			select
eas_0p100000000	double	YES			select
eas_0p102329300	double	YES			select
eas_0p104712900	double	YES			select
eas_0p107151920	double	YES			select
eas_0p109647820	double	YES			select
eas_0p112201840	double	YES			select
eas_0p114815400	double	YES			select
eas_0p117489800	double	YES			select
eas_0p120226430	double	YES			select
eas_0p123026900	double	YES			select
eas_0p125892540	double	YES			select
eas_0p128824940	double	YES			select
eas_0p131825700	double	YES			select
eas_0p134896300	double	YES			select
eas_0p138038410	double	YES			select
eas_0p141253730	double	YES			select
eas_0p144544000	double	YES			select
eas_0p147910830	double	YES			select
eas_0p151356110	double	YES			select
eas_0p154881700	double	YES			select
eas_0p158489310	double	YES			select
eas_0p162181000	double	YES			select
eas_0p165958700	double	YES			select
eas_0p169824400	double	YES			select
eas_0p173780100	double	YES			select
eas_0p177828000	double	YES			select
eas_0p181970100	double	YES			select
eas_0p186208710	double	YES			select
eas_0p190546100	double	YES			select
eas_0p194984430	double	YES			select
eas_0p199526200	double	YES			select
eas_0p204173800	double	YES			select
eas_0p208929610	double	YES			select
eas_0p213796200	double	YES			select
eas_0p218776200	double	YES			select
eas_0p223872120	double	YES			select
eas_0p229086800	double	YES			select
eas_0p234422900	double	YES			select
eas_0p239883300	double	YES			select
eas_0p245470900	double	YES			select
eas_0p251188600	double	YES			select
eas_0p257039540	double	YES			select
eas_0p263026800	double	YES			select
eas_0p269153440	double	YES			select
eas_0p275422900	double	YES			select
eas_0p281838300	double	YES			select
eas_0p288403120	double	YES			select
eas_0p295120920	double	YES			select
eas_0p301995200	double	YES			select
eas_0p309029540	double	YES			select
eas_0p316227800	double	YES			select
eas_0p323593640	double	YES			select
eas_0p331131100	double	YES			select
eas_0p338844120	double	YES			select
eas_0p346736810	double	YES			select
eas_0p354813400	double	YES			select
eas_0p363078100	double	YES			select
eas_0p371535210	double	YES			select
eas_0p380189400	double	YES			select
eas_0p389045110	double	YES			select
eas_0p398107140	double	YES			select
eas_0p407380300	double	YES			select
eas_0p416869400	double	YES			select
eas_0p426579530	double	YES			select
eas_0p436515800	double	YES			select
eas_0p446683600	double	YES			select
eas_0p457088200	double	YES			select
eas_0p467735100	double	YES			select
eas_0p478630100	double	YES			select
eas_0p489778810	double	YES			select
eas_0p501187200	double	YES			select
eas_0p512861310	double	YES			select
eas_0p524807500	double	YES			select
eas_0p537031800	double	YES			select
eas_0p549540900	double	YES			select
eas_0p562341300	double	YES			select
eas_0p575439920	double	YES			select
eas_0p588843600	double	YES			select
eas_0p602559500	double	YES			select
eas_0p616594910	double	YES			select
eas_0p630957300	double	YES			select
eas_0p645654300	double	YES			select
eas_0p660693400	double	YES			select
eas_0p676083000	double	YES			select
eas_0p691830930	double	YES			select
eas_0p707945800	double	YES			select
eas_0p724435920	double	YES			select
eas_0p741310230	double	YES			select
eas_0p758577600	double	YES			select
eas_0p776247100	double	YES			select
eas_0p794328210	double	YES			select
eas_0p812830440	double	YES			select
eas_0p831763700	double	YES			select
eas_0p851138100	double	YES			select
eas_0p870963600	double	YES			select
eas_0p891250900	double	YES			select
eas_0p912010800	double	YES			select
eas_0p933254240	double	YES			select
eas_0p954992500	double	YES			select
eas_0p977237100	double	YES			select
eas_1p000000000	double	YES			select
eas_1p023293000	double	YES			select
eas_1p047129000	double	YES			select
eas_1p071519200	double	YES			select
eas_1p096478000	double	YES			select
eas_1p122018200	double	YES			select
eas_1p148153400	double	YES			select
eas_1p174897300	double	YES			select
eas_1p202264100	double	YES			select
eas_1p230269000	double	YES			select
eas_1p258926000	double	YES			select
eas_1p288250000	double	YES			select
eas_1p318257000	double	YES			select
eas_1p348963000	double	YES			select
eas_1p380384200	double	YES			select
eas_1p412537400	double	YES			select
eas_1p445440000	double	YES			select
eas_1p479108200	double	YES			select
eas_1p513561000	double	YES			select
eas_1p548816400	double	YES			select
eas_1p584893000	double	YES			select
eas_1p621810000	double	YES			select
eas_1p659587000	double	YES			select
eas_1p698244000	double	YES			select
eas_1p737801000	double	YES			select
eas_1p778279400	double	YES			select
eas_1p819701000	double	YES			select
eas_1p862087000	double	YES			select
eas_1p905461000	double	YES			select
eas_1p949844400	double	YES			select
eas_1p995262100	double	YES			select
eas_2p041738000	double	YES			select
eas_2p089296000	double	YES			select
eas_2p137962000	double	YES			select
eas_2p187761000	double	YES			select
eas_2p238721100	double	YES			select
eas_2p290868000	double	YES			select
eas_2p344229000	double	YES			select
eas_2p398833000	double	YES			select
eas_2p454709000	double	YES			select
eas_2p511886300	double	YES			select
eas_2p570396000	double	YES			select
eas_2p630268000	double	YES			select
eas_2p691535000	double	YES			select
eas_2p754228300	double	YES			select
eas_2p818383000	double	YES			select
eas_2p884031000	double	YES			select
eas_2p951209000	double	YES			select
eas_3p019952000	double	YES			select
eas_3p090296000	double	YES			select
eas_3p162278000	double	YES			select
eas_3p235937000	double	YES			select
eas_3p311311000	double	YES			select
eas_3p388441300	double	YES			select
eas_3p467368100	double	YES			select
eas_3p548134000	double	YES			select
eas_3p630780000	double	YES			select
eas_3p715352000	double	YES			select
eas_3p801893200	double	YES			select
eas_3p890451000	double	YES			select
eas_3p981071000	double	YES			select
eas_4p073803000	double	YES			select
eas_4p168694000	double	YES			select
eas_4p265795200	double	YES			select
eas_4p365158000	double	YES			select
eas_4p466835400	double	YES			select
eas_4p570881300	double	YES			select
eas_4p677351000	double	YES			select
eas_4p786300100	double	YES			select
eas_4p897787000	double	YES			select
eas_5p011872000	double	YES			select
eas_5p128613000	double	YES			select
eas_5p248074000	double	YES			select
eas_5p370318400	double	YES			select
eas_5p495409000	double	YES			select
eas_5p623413000	double	YES			select
eas_5p754399200	double	YES			select
eas_5p888436300	double	YES			select
eas_6p025596000	double	YES			select
eas_6p165949300	double	YES			select
eas_6p309573000	double	YES			select
eas_6p456542000	double	YES			select
eas_6p606934000	double	YES			select
eas_6p760828400	double	YES			select
eas_6p918308200	double	YES			select
eas_7p079456300	double	YES			select
eas_7p244360000	double	YES			select
eas_7p413103000	double	YES			select
eas_7p585776000	double	YES			select
eas_7p762471000	double	YES			select
eas_7p943282100	double	YES			select
eas_8p128304400	double	YES			select
eas_8p317636400	double	YES			select
eas_8p511379200	double	YES			select
eas_8p709635000	double	YES			select
eas_8p912507000	double	YES			select
eas_9p120107000	double	YES			select
eas_9p332541000	double	YES			select
eas_9p549923000	double	YES			select
eas_9p772372200	double	YES			select
eas_10p000000000	double	YES			select
eas_10p232930000	double	YES			select
eas_10p471284000	double	YES			select
eas_10p715192000	double	YES			select
eas_10p964780000	double	YES			select
eas_11p220183000	double	YES			select
eas_11p481534000	double	YES			select
eas_11p748973000	double	YES			select
eas_12p022642000	double	YES			select
eas_12p302684000	double	YES			select
eas_12p589251000	double	YES			select
eas_12p882492000	double	YES			select
eas_13p182563000	double	YES			select
eas_13p489624000	double	YES			select
eas_13p803840000	double	YES			select
eas_14p125370000	double	YES			select
eas_14p454392000	double	YES			select
eas_14p791080000	double	YES			select
eas_15p135614000	double	YES			select
eas_15p488170000	double	YES			select
eas_15p848933000	double	YES			select
eas_16p218101000	double	YES			select
eas_16p595870000	double	YES			select
eas_16p982440000	double	YES			select
eas_17p378010000	double	YES			select
eas_17p782793000	double	YES			select
eas_18p197010000	double	YES			select
eas_18p620870000	double	YES			select
eas_19p054610000	double	YES			select
eas_19p498443000	double	YES			select
eas_19p952621000	double	YES			select
eas_20p417380000	double	YES			select
eas_20p892960000	double	YES			select
eas_21p379620000	double	YES			select
eas_21p877611000	double	YES			select
eas_22p387210000	double	YES			select
eas_22p908672000	double	YES			select
eas_23p442283000	double	YES			select
eas_23p988321000	double	YES			select
eas_24p547080000	double	YES			select
eas_25p118860000	double	YES			select
eas_25p703950000	double	YES			select
eas_26p302670000	double	YES			select
eas_26p915340000	double	YES			select
eas_27p542291000	double	YES			select
eas_28p183832000	double	YES			select
eas_28p840320000	double	YES			select
eas_29p512094000	double	YES			select
eas_30p199520000	double	YES			select
eas_30p902954000	double	YES			select
eas_31p622780000	double	YES			select
eas_32p359363000	double	YES			select
eas_33p113110000	double	YES			select
eas_33p884414000	double	YES			select
eas_34p673683000	double	YES			select
eas_35p481334000	double	YES			select
eas_36p307800000	double	YES			select
eas_37p153514000	double	YES			select
eas_38p018932000	double	YES			select
eas_38p904510000	double	YES			select
eas_39p810710000	double	YES			select
eas_40p738020000	double	YES			select
eas_41p686930000	double	YES			select
eas_42p657940000	double	YES			select
eas_43p651570000	double	YES			select
eas_44p668342000	double	YES			select
eas_45p708810000	double	YES			select
eas_46p773500000	double	YES			select
eas_47p862991000	double	YES			select
eas_48p977890000	double	YES			select
eas_50p118730000	double	YES			select
eas_51p286144000	double	YES			select
eas_52p480751000	double	YES			select
eas_53p703182000	double	YES			select
eas_54p954090000	double	YES			select
eas_56p234130000	double	YES			select
eas_57p543991000	double	YES			select
eas_58p884361000	double	YES			select
eas_60p255954000	double	YES			select
eas_61p659500000	double	YES			select
eas_63p095730000	double	YES			select
eas_64p565414000	double	YES			select
eas_66p069330000	double	YES			select
eas_67p608283000	double	YES			select
eas_69p183082000	double	YES			select
eas_70p794560000	double	YES			select
eas_72p443572000	double	YES			select
eas_74p131004000	double	YES			select
eas_75p857734000	double	YES			select
eas_77p624690000	double	YES			select
eas_79p432792000	double	YES			select
eas_81p283030000	double	YES			select
eas_83p176350000	double	YES			select
eas_85p113770000	double	YES			select
eas_87p096321000	double	YES			select
eas_89p125100000	double	YES			select
eas_91p201100000	double	YES			select
eas_93p325440000	double	YES			select
eas_95p499260000	double	YES			select
eas_97p723724000	double	YES			select
eas_100p000000000	double	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
synchronous_event	int(1)		YES			select	Earthquake part of a synchronous earthquake sequence (two or more events that occur in close proximity, both temporally and spatially): 0 = No; 1 = Yes

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_complexity	int(1)		YES				select	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)	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
seg_sub_rupture_number	int(11)	YES			select	Finite fault sub-rupture 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.

flatfile

Field	Type	Null	Key	Extra	Privileges
flatfile_id	int(11)	NO	PRI	auto_increment	select
time_series_metadata_id	int(11)	NO	MUL		select
query_number	int(11)	NO			select

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)

frequencies

Field	Type	Collation	Null	Key	Default	Extra	Privileges	Comment
frequencies_id	int(11)		NO	PRI		auto_increment	select
frequency	decimal(12,9)		YES				select

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	MUL		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	MUL	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).

periods

Field	Type	Collation	Null	Key	Default	Extra	Privileges	Comment
periods_id	int(11)		NO	PRI		auto_increment	select
period	decimal(5,3)		YES				select

psa_h1

Field	Type	Null	Key	Extra	Privileges
psa_h1_id	int(11)	NO	PRI	auto_increment	select
time_series_metadata_id	int(11)	YES	UNI		select
damping	float	YES			select
psa_h1_0p010	double	YES			select
psa_h1_0p020	double	YES			select
psa_h1_0p022	double	YES			select
psa_h1_0p025	double	YES			select
psa_h1_0p029	double	YES			select
psa_h1_0p030	double	YES			select
psa_h1_0p032	double	YES			select
psa_h1_0p035	double	YES			select
psa_h1_0p036	double	YES			select
psa_h1_0p040	double	YES			select
psa_h1_0p042	double	YES			select
psa_h1_0p044	double	YES			select
psa_h1_0p045	double	YES			select
psa_h1_0p046	double	YES			select
psa_h1_0p048	double	YES			select
psa_h1_0p050	double	YES			select
psa_h1_0p055	double	YES			select
psa_h1_0p060	double	YES			select
psa_h1_0p065	double	YES			select
psa_h1_0p067	double	YES			select
psa_h1_0p070	double	YES			select
psa_h1_0p075	double	YES			select
psa_h1_0p080	double	YES			select
psa_h1_0p085	double	YES			select
psa_h1_0p090	double	YES			select
psa_h1_0p095	double	YES			select
psa_h1_0p100	double	YES			select
psa_h1_0p110	double	YES			select
psa_h1_0p120	double	YES			select
psa_h1_0p130	double	YES			select
psa_h1_0p133	double	YES			select
psa_h1_0p140	double	YES			select
psa_h1_0p150	double	YES			select
psa_h1_0p160	double	YES			select
psa_h1_0p170	double	YES			select
psa_h1_0p180	double	YES			select
psa_h1_0p190	double	YES			select
psa_h1_0p200	double	YES			select
psa_h1_0p220	double	YES			select
psa_h1_0p240	double	YES			select
psa_h1_0p250	double	YES			select
psa_h1_0p260	double	YES			select
psa_h1_0p280	double	YES			select
psa_h1_0p290	double	YES			select
psa_h1_0p300	double	YES			select
psa_h1_0p320	double	YES			select
psa_h1_0p340	double	YES			select
psa_h1_0p350	double	YES			select
psa_h1_0p360	double	YES			select
psa_h1_0p380	double	YES			select
psa_h1_0p400	double	YES			select
psa_h1_0p420	double	YES			select
psa_h1_0p440	double	YES			select
psa_h1_0p450	double	YES			select
psa_h1_0p460	double	YES			select
psa_h1_0p480	double	YES			select
psa_h1_0p500	double	YES			select
psa_h1_0p550	double	YES			select
psa_h1_0p600	double	YES			select
psa_h1_0p650	double	YES			select
psa_h1_0p667	double	YES			select
psa_h1_0p700	double	YES			select
psa_h1_0p750	double	YES			select
psa_h1_0p800	double	YES			select
psa_h1_0p850	double	YES			select
psa_h1_0p900	double	YES			select
psa_h1_0p950	double	YES			select
psa_h1_1p000	double	YES			select
psa_h1_1p100	double	YES			select
psa_h1_1p200	double	YES			select
psa_h1_1p300	double	YES			select
psa_h1_1p400	double	YES			select
psa_h1_1p500	double	YES			select
psa_h1_1p600	double	YES			select
psa_h1_1p700	double	YES			select
psa_h1_1p800	double	YES			select
psa_h1_1p900	double	YES			select
psa_h1_2p000	double	YES			select
psa_h1_2p200	double	YES			select
psa_h1_2p400	double	YES			select
psa_h1_2p500	double	YES			select
psa_h1_2p600	double	YES			select
psa_h1_2p800	double	YES			select
psa_h1_3p000	double	YES			select
psa_h1_3p200	double	YES			select
psa_h1_3p400	double	YES			select
psa_h1_3p500	double	YES			select
psa_h1_3p600	double	YES			select
psa_h1_3p800	double	YES			select
psa_h1_4p000	double	YES			select
psa_h1_4p200	double	YES			select
psa_h1_4p400	double	YES			select
psa_h1_4p600	double	YES			select
psa_h1_4p800	double	YES			select
psa_h1_5p000	double	YES			select
psa_h1_5p500	double	YES			select
psa_h1_6p000	double	YES			select
psa_h1_6p500	double	YES			select
psa_h1_7p000	double	YES			select
psa_h1_7p500	double	YES			select
psa_h1_8p000	double	YES			select
psa_h1_8p500	double	YES			select
psa_h1_9p000	double	YES			select
psa_h1_9p500	double	YES			select
psa_h1_10p000	double	YES			select
psa_h1_11p000	double	YES			select
psa_h1_12p000	double	YES			select
psa_h1_13p000	double	YES			select
psa_h1_14p000	double	YES			select
psa_h1_15p000	double	YES			select
psa_h1_20p000	double	YES			select

psa_h2

Field	Type	Null	Key	Extra	Privileges
psa_h2_id	int(11)	NO	PRI	auto_increment	select
time_series_metadata_id	int(11)	YES	UNI		select
damping	float	YES			select
psa_h2_0p010	double	YES			select
psa_h2_0p020	double	YES			select
psa_h2_0p022	double	YES			select
psa_h2_0p025	double	YES			select
psa_h2_0p029	double	YES			select
psa_h2_0p030	double	YES			select
psa_h2_0p032	double	YES			select
psa_h2_0p035	double	YES			select
psa_h2_0p036	double	YES			select
psa_h2_0p040	double	YES			select
psa_h2_0p042	double	YES			select
psa_h2_0p044	double	YES			select
psa_h2_0p045	double	YES			select
psa_h2_0p046	double	YES			select
psa_h2_0p048	double	YES			select
psa_h2_0p050	double	YES			select
psa_h2_0p055	double	YES			select
psa_h2_0p060	double	YES			select
psa_h2_0p065	double	YES			select
psa_h2_0p067	double	YES			select
psa_h2_0p070	double	YES			select
psa_h2_0p075	double	YES			select
psa_h2_0p080	double	YES			select
psa_h2_0p085	double	YES			select
psa_h2_0p090	double	YES			select
psa_h2_0p095	double	YES			select
psa_h2_0p100	double	YES			select
psa_h2_0p110	double	YES			select
psa_h2_0p120	double	YES			select
psa_h2_0p130	double	YES			select
psa_h2_0p133	double	YES			select
psa_h2_0p140	double	YES			select
psa_h2_0p150	double	YES			select
psa_h2_0p160	double	YES			select
psa_h2_0p170	double	YES			select
psa_h2_0p180	double	YES			select
psa_h2_0p190	double	YES			select
psa_h2_0p200	double	YES			select
psa_h2_0p220	double	YES			select
psa_h2_0p240	double	YES			select
psa_h2_0p250	double	YES			select
psa_h2_0p260	double	YES			select
psa_h2_0p280	double	YES			select
psa_h2_0p290	double	YES			select
psa_h2_0p300	double	YES			select
psa_h2_0p320	double	YES			select
psa_h2_0p340	double	YES			select
psa_h2_0p350	double	YES			select
psa_h2_0p360	double	YES			select
psa_h2_0p380	double	YES			select
psa_h2_0p400	double	YES			select
psa_h2_0p420	double	YES			select
psa_h2_0p440	double	YES			select
psa_h2_0p450	double	YES			select
psa_h2_0p460	double	YES			select
psa_h2_0p480	double	YES			select
psa_h2_0p500	double	YES			select
psa_h2_0p550	double	YES			select
psa_h2_0p600	double	YES			select
psa_h2_0p650	double	YES			select
psa_h2_0p667	double	YES			select
psa_h2_0p700	double	YES			select
psa_h2_0p750	double	YES			select
psa_h2_0p800	double	YES			select
psa_h2_0p850	double	YES			select
psa_h2_0p900	double	YES			select
psa_h2_0p950	double	YES			select
psa_h2_1p000	double	YES			select
psa_h2_1p100	double	YES			select
psa_h2_1p200	double	YES			select
psa_h2_1p300	double	YES			select
psa_h2_1p400	double	YES			select
psa_h2_1p500	double	YES			select
psa_h2_1p600	double	YES			select
psa_h2_1p700	double	YES			select
psa_h2_1p800	double	YES			select
psa_h2_1p900	double	YES			select
psa_h2_2p000	double	YES			select
psa_h2_2p200	double	YES			select
psa_h2_2p400	double	YES			select
psa_h2_2p500	double	YES			select
psa_h2_2p600	double	YES			select
psa_h2_2p800	double	YES			select
psa_h2_3p000	double	YES			select
psa_h2_3p200	double	YES			select
psa_h2_3p400	double	YES			select
psa_h2_3p500	double	YES			select
psa_h2_3p600	double	YES			select
psa_h2_3p800	double	YES			select
psa_h2_4p000	double	YES			select
psa_h2_4p200	double	YES			select
psa_h2_4p400	double	YES			select
psa_h2_4p600	double	YES			select
psa_h2_4p800	double	YES			select
psa_h2_5p000	double	YES			select
psa_h2_5p500	double	YES			select
psa_h2_6p000	double	YES			select
psa_h2_6p500	double	YES			select
psa_h2_7p000	double	YES			select
psa_h2_7p500	double	YES			select
psa_h2_8p000	double	YES			select
psa_h2_8p500	double	YES			select
psa_h2_9p000	double	YES			select
psa_h2_9p500	double	YES			select
psa_h2_10p000	double	YES			select
psa_h2_11p000	double	YES			select
psa_h2_12p000	double	YES			select
psa_h2_13p000	double	YES			select
psa_h2_14p000	double	YES			select
psa_h2_15p000	double	YES			select
psa_h2_20p000	double	YES			select

psa_rotd0

Field	Type	Null	Key	Extra	Privileges
psa_rotd0_id	int(11)	NO	PRI	auto_increment	select
time_series_metadata_id	int(11)	YES	UNI		select
damping	float	YES			select
psa_rotd0_0p010	double	YES	MUL		select
psa_rotd0_0p020	double	YES			select
psa_rotd0_0p022	double	YES			select
psa_rotd0_0p025	double	YES			select
psa_rotd0_0p029	double	YES			select
psa_rotd0_0p030	double	YES			select
psa_rotd0_0p032	double	YES			select
psa_rotd0_0p035	double	YES			select
psa_rotd0_0p036	double	YES			select
psa_rotd0_0p040	double	YES			select
psa_rotd0_0p042	double	YES			select
psa_rotd0_0p044	double	YES			select
psa_rotd0_0p045	double	YES			select
psa_rotd0_0p046	double	YES			select
psa_rotd0_0p048	double	YES			select
psa_rotd0_0p050	double	YES			select
psa_rotd0_0p055	double	YES			select
psa_rotd0_0p060	double	YES			select
psa_rotd0_0p065	double	YES			select
psa_rotd0_0p067	double	YES			select
psa_rotd0_0p070	double	YES			select
psa_rotd0_0p075	double	YES			select
psa_rotd0_0p080	double	YES			select
psa_rotd0_0p085	double	YES			select
psa_rotd0_0p090	double	YES			select
psa_rotd0_0p095	double	YES			select
psa_rotd0_0p100	double	YES			select
psa_rotd0_0p110	double	YES			select
psa_rotd0_0p120	double	YES			select
psa_rotd0_0p130	double	YES			select
psa_rotd0_0p133	double	YES			select
psa_rotd0_0p140	double	YES			select
psa_rotd0_0p150	double	YES			select
psa_rotd0_0p160	double	YES			select
psa_rotd0_0p170	double	YES			select
psa_rotd0_0p180	double	YES			select
psa_rotd0_0p190	double	YES			select
psa_rotd0_0p200	double	YES			select
psa_rotd0_0p220	double	YES			select
psa_rotd0_0p240	double	YES			select
psa_rotd0_0p250	double	YES			select
psa_rotd0_0p260	double	YES			select
psa_rotd0_0p280	double	YES			select
psa_rotd0_0p290	double	YES			select
psa_rotd0_0p300	double	YES			select
psa_rotd0_0p320	double	YES			select
psa_rotd0_0p340	double	YES			select
psa_rotd0_0p350	double	YES			select
psa_rotd0_0p360	double	YES			select
psa_rotd0_0p380	double	YES			select
psa_rotd0_0p400	double	YES			select
psa_rotd0_0p420	double	YES			select
psa_rotd0_0p440	double	YES			select
psa_rotd0_0p450	double	YES			select
psa_rotd0_0p460	double	YES			select
psa_rotd0_0p480	double	YES			select
psa_rotd0_0p500	double	YES			select
psa_rotd0_0p550	double	YES			select
psa_rotd0_0p600	double	YES			select
psa_rotd0_0p650	double	YES			select
psa_rotd0_0p667	double	YES			select
psa_rotd0_0p700	double	YES			select
psa_rotd0_0p750	double	YES			select
psa_rotd0_0p800	double	YES			select
psa_rotd0_0p850	double	YES			select
psa_rotd0_0p900	double	YES			select
psa_rotd0_0p950	double	YES			select
psa_rotd0_1p000	double	YES			select
psa_rotd0_1p100	double	YES			select
psa_rotd0_1p200	double	YES			select
psa_rotd0_1p300	double	YES			select
psa_rotd0_1p400	double	YES			select
psa_rotd0_1p500	double	YES			select
psa_rotd0_1p600	double	YES			select
psa_rotd0_1p700	double	YES			select
psa_rotd0_1p800	double	YES			select
psa_rotd0_1p900	double	YES			select
psa_rotd0_2p000	double	YES			select
psa_rotd0_2p200	double	YES			select
psa_rotd0_2p400	double	YES			select
psa_rotd0_2p500	double	YES			select
psa_rotd0_2p600	double	YES			select
psa_rotd0_2p800	double	YES			select
psa_rotd0_3p000	double	YES			select
psa_rotd0_3p200	double	YES			select
psa_rotd0_3p400	double	YES			select
psa_rotd0_3p500	double	YES			select
psa_rotd0_3p600	double	YES			select
psa_rotd0_3p800	double	YES			select
psa_rotd0_4p000	double	YES			select
psa_rotd0_4p200	double	YES			select
psa_rotd0_4p400	double	YES			select
psa_rotd0_4p600	double	YES			select
psa_rotd0_4p800	double	YES			select
psa_rotd0_5p000	double	YES			select
psa_rotd0_5p500	double	YES			select
psa_rotd0_6p000	double	YES			select
psa_rotd0_6p500	double	YES			select
psa_rotd0_7p000	double	YES			select
psa_rotd0_7p500	double	YES			select
psa_rotd0_8p000	double	YES			select
psa_rotd0_8p500	double	YES			select
psa_rotd0_9p000	double	YES			select
psa_rotd0_9p500	double	YES			select
psa_rotd0_10p000	double	YES			select
psa_rotd0_11p000	double	YES			select
psa_rotd0_12p000	double	YES			select
psa_rotd0_13p000	double	YES			select
psa_rotd0_14p000	double	YES			select
psa_rotd0_15p000	double	YES			select
psa_rotd0_20p000	double	YES			select

psa_rotd100

Field	Type	Null	Key	Extra	Privileges
psa_rotd100_id	int(11)	NO	PRI	auto_increment	select
time_series_metadata_id	int(11)	YES	UNI		select
damping	float	YES			select
psa_rotd100_0p010	double	YES			select
psa_rotd100_0p020	double	YES			select
psa_rotd100_0p022	double	YES			select
psa_rotd100_0p025	double	YES			select
psa_rotd100_0p029	double	YES			select
psa_rotd100_0p030	double	YES			select
psa_rotd100_0p032	double	YES			select
psa_rotd100_0p035	double	YES			select
psa_rotd100_0p036	double	YES			select
psa_rotd100_0p040	double	YES			select
psa_rotd100_0p042	double	YES			select
psa_rotd100_0p044	double	YES			select
psa_rotd100_0p045	double	YES			select
psa_rotd100_0p046	double	YES			select
psa_rotd100_0p048	double	YES			select
psa_rotd100_0p050	double	YES			select
psa_rotd100_0p055	double	YES			select
psa_rotd100_0p060	double	YES			select
psa_rotd100_0p065	double	YES			select
psa_rotd100_0p067	double	YES			select
psa_rotd100_0p070	double	YES			select
psa_rotd100_0p075	double	YES			select
psa_rotd100_0p080	double	YES			select
psa_rotd100_0p085	double	YES			select
psa_rotd100_0p090	double	YES			select
psa_rotd100_0p095	double	YES			select
psa_rotd100_0p100	double	YES			select
psa_rotd100_0p110	double	YES			select
psa_rotd100_0p120	double	YES			select
psa_rotd100_0p130	double	YES			select
psa_rotd100_0p133	double	YES			select
psa_rotd100_0p140	double	YES			select
psa_rotd100_0p150	double	YES			select
psa_rotd100_0p160	double	YES			select
psa_rotd100_0p170	double	YES			select
psa_rotd100_0p180	double	YES			select
psa_rotd100_0p190	double	YES			select
psa_rotd100_0p200	double	YES			select
psa_rotd100_0p220	double	YES			select
psa_rotd100_0p240	double	YES			select
psa_rotd100_0p250	double	YES			select
psa_rotd100_0p260	double	YES			select
psa_rotd100_0p280	double	YES			select
psa_rotd100_0p290	double	YES			select
psa_rotd100_0p300	double	YES			select
psa_rotd100_0p320	double	YES			select
psa_rotd100_0p340	double	YES			select
psa_rotd100_0p350	double	YES			select
psa_rotd100_0p360	double	YES			select
psa_rotd100_0p380	double	YES			select
psa_rotd100_0p400	double	YES			select
psa_rotd100_0p420	double	YES			select
psa_rotd100_0p440	double	YES			select
psa_rotd100_0p450	double	YES			select
psa_rotd100_0p460	double	YES			select
psa_rotd100_0p480	double	YES			select
psa_rotd100_0p500	double	YES			select
psa_rotd100_0p550	double	YES			select
psa_rotd100_0p600	double	YES			select
psa_rotd100_0p650	double	YES			select
psa_rotd100_0p667	double	YES			select
psa_rotd100_0p700	double	YES			select
psa_rotd100_0p750	double	YES			select
psa_rotd100_0p800	double	YES			select
psa_rotd100_0p850	double	YES			select
psa_rotd100_0p900	double	YES			select
psa_rotd100_0p950	double	YES			select
psa_rotd100_1p000	double	YES			select
psa_rotd100_1p100	double	YES			select
psa_rotd100_1p200	double	YES			select
psa_rotd100_1p300	double	YES			select
psa_rotd100_1p400	double	YES			select
psa_rotd100_1p500	double	YES			select
psa_rotd100_1p600	double	YES			select
psa_rotd100_1p700	double	YES			select
psa_rotd100_1p800	double	YES			select
psa_rotd100_1p900	double	YES			select
psa_rotd100_2p000	double	YES			select
psa_rotd100_2p200	double	YES			select
psa_rotd100_2p400	double	YES			select
psa_rotd100_2p500	double	YES			select
psa_rotd100_2p600	double	YES			select
psa_rotd100_2p800	double	YES			select
psa_rotd100_3p000	double	YES			select
psa_rotd100_3p200	double	YES			select
psa_rotd100_3p400	double	YES			select
psa_rotd100_3p500	double	YES			select
psa_rotd100_3p600	double	YES			select
psa_rotd100_3p800	double	YES			select
psa_rotd100_4p000	double	YES			select
psa_rotd100_4p200	double	YES			select
psa_rotd100_4p400	double	YES			select
psa_rotd100_4p600	double	YES			select
psa_rotd100_4p800	double	YES			select
psa_rotd100_5p000	double	YES			select
psa_rotd100_5p500	double	YES			select
psa_rotd100_6p000	double	YES			select
psa_rotd100_6p500	double	YES			select
psa_rotd100_7p000	double	YES			select
psa_rotd100_7p500	double	YES			select
psa_rotd100_8p000	double	YES			select
psa_rotd100_8p500	double	YES			select
psa_rotd100_9p000	double	YES			select
psa_rotd100_9p500	double	YES			select
psa_rotd100_10p000	double	YES			select
psa_rotd100_11p000	double	YES			select
psa_rotd100_12p000	double	YES			select
psa_rotd100_13p000	double	YES			select
psa_rotd100_14p000	double	YES			select
psa_rotd100_15p000	double	YES			select
psa_rotd100_20p000	double	YES			select

psa_rotd50

Field	Type	Null	Key	Extra	Privileges
psa_rotd50_id	int(11)	NO	PRI	auto_increment	select
time_series_metadata_id	int(11)	YES	UNI		select
damping	float	YES			select
psa_rotd50_0p010	double	YES			select
psa_rotd50_0p020	double	YES			select
psa_rotd50_0p022	double	YES			select
psa_rotd50_0p025	double	YES			select
psa_rotd50_0p029	double	YES			select
psa_rotd50_0p030	double	YES			select
psa_rotd50_0p032	double	YES			select
psa_rotd50_0p035	double	YES			select
psa_rotd50_0p036	double	YES			select
psa_rotd50_0p040	double	YES			select
psa_rotd50_0p042	double	YES			select
psa_rotd50_0p044	double	YES			select
psa_rotd50_0p045	double	YES			select
psa_rotd50_0p046	double	YES			select
psa_rotd50_0p048	double	YES			select
psa_rotd50_0p050	double	YES			select
psa_rotd50_0p055	double	YES			select
psa_rotd50_0p060	double	YES			select
psa_rotd50_0p065	double	YES			select
psa_rotd50_0p067	double	YES			select
psa_rotd50_0p070	double	YES			select
psa_rotd50_0p075	double	YES			select
psa_rotd50_0p080	double	YES			select
psa_rotd50_0p085	double	YES			select
psa_rotd50_0p090	double	YES			select
psa_rotd50_0p095	double	YES			select
psa_rotd50_0p100	double	YES			select
psa_rotd50_0p110	double	YES			select
psa_rotd50_0p120	double	YES			select
psa_rotd50_0p130	double	YES			select
psa_rotd50_0p133	double	YES			select
psa_rotd50_0p140	double	YES			select
psa_rotd50_0p150	double	YES			select
psa_rotd50_0p160	double	YES			select
psa_rotd50_0p170	double	YES			select
psa_rotd50_0p180	double	YES			select
psa_rotd50_0p190	double	YES			select
psa_rotd50_0p200	double	YES			select
psa_rotd50_0p220	double	YES			select
psa_rotd50_0p240	double	YES			select
psa_rotd50_0p250	double	YES			select
psa_rotd50_0p260	double	YES			select
psa_rotd50_0p280	double	YES			select
psa_rotd50_0p290	double	YES			select
psa_rotd50_0p300	double	YES			select
psa_rotd50_0p320	double	YES			select
psa_rotd50_0p340	double	YES			select
psa_rotd50_0p350	double	YES			select
psa_rotd50_0p360	double	YES			select
psa_rotd50_0p380	double	YES			select
psa_rotd50_0p400	double	YES			select
psa_rotd50_0p420	double	YES			select
psa_rotd50_0p440	double	YES			select
psa_rotd50_0p450	double	YES			select
psa_rotd50_0p460	double	YES			select
psa_rotd50_0p480	double	YES			select
psa_rotd50_0p500	double	YES			select
psa_rotd50_0p550	double	YES			select
psa_rotd50_0p600	double	YES			select
psa_rotd50_0p650	double	YES			select
psa_rotd50_0p667	double	YES			select
psa_rotd50_0p700	double	YES			select
psa_rotd50_0p750	double	YES			select
psa_rotd50_0p800	double	YES			select
psa_rotd50_0p850	double	YES			select
psa_rotd50_0p900	double	YES			select
psa_rotd50_0p950	double	YES			select
psa_rotd50_1p000	double	YES			select
psa_rotd50_1p100	double	YES			select
psa_rotd50_1p200	double	YES			select
psa_rotd50_1p300	double	YES			select
psa_rotd50_1p400	double	YES			select
psa_rotd50_1p500	double	YES			select
psa_rotd50_1p600	double	YES			select
psa_rotd50_1p700	double	YES			select
psa_rotd50_1p800	double	YES			select
psa_rotd50_1p900	double	YES			select
psa_rotd50_2p000	double	YES			select
psa_rotd50_2p200	double	YES			select
psa_rotd50_2p400	double	YES			select
psa_rotd50_2p500	double	YES			select
psa_rotd50_2p600	double	YES			select
psa_rotd50_2p800	double	YES			select
psa_rotd50_3p000	double	YES			select
psa_rotd50_3p200	double	YES			select
psa_rotd50_3p400	double	YES			select
psa_rotd50_3p500	double	YES			select
psa_rotd50_3p600	double	YES			select
psa_rotd50_3p800	double	YES			select
psa_rotd50_4p000	double	YES			select
psa_rotd50_4p200	double	YES			select
psa_rotd50_4p400	double	YES			select
psa_rotd50_4p600	double	YES			select
psa_rotd50_4p800	double	YES			select
psa_rotd50_5p000	double	YES			select
psa_rotd50_5p500	double	YES			select
psa_rotd50_6p000	double	YES			select
psa_rotd50_6p500	double	YES			select
psa_rotd50_7p000	double	YES			select
psa_rotd50_7p500	double	YES			select
psa_rotd50_8p000	double	YES			select
psa_rotd50_8p500	double	YES			select
psa_rotd50_9p000	double	YES			select
psa_rotd50_9p500	double	YES			select
psa_rotd50_10p000	double	YES			select
psa_rotd50_11p000	double	YES			select
psa_rotd50_12p000	double	YES			select
psa_rotd50_13p000	double	YES			select
psa_rotd50_14p000	double	YES			select
psa_rotd50_15p000	double	YES			select
psa_rotd50_20p000	double	YES			select

psa_v

Field	Type	Null	Key	Extra	Privileges
psa_v_id	int(11)	NO	PRI	auto_increment	select
time_series_metadata_id	int(11)	YES	UNI		select
damping	float	YES			select
psa_v_0p010	double	YES			select
psa_v_0p020	double	YES			select
psa_v_0p022	double	YES			select
psa_v_0p025	double	YES			select
psa_v_0p029	double	YES			select
psa_v_0p030	double	YES			select
psa_v_0p032	double	YES			select
psa_v_0p035	double	YES			select
psa_v_0p036	double	YES			select
psa_v_0p040	double	YES			select
psa_v_0p042	double	YES			select
psa_v_0p044	double	YES			select
psa_v_0p045	double	YES			select
psa_v_0p046	double	YES			select
psa_v_0p048	double	YES			select
psa_v_0p050	double	YES			select
psa_v_0p055	double	YES			select
psa_v_0p060	double	YES			select
psa_v_0p065	double	YES			select
psa_v_0p067	double	YES			select
psa_v_0p070	double	YES			select
psa_v_0p075	double	YES			select
psa_v_0p080	double	YES			select
psa_v_0p085	double	YES			select
psa_v_0p090	double	YES			select
psa_v_0p095	double	YES			select
psa_v_0p100	double	YES			select
psa_v_0p110	double	YES			select
psa_v_0p120	double	YES			select
psa_v_0p130	double	YES			select
psa_v_0p133	double	YES			select
psa_v_0p140	double	YES			select
psa_v_0p150	double	YES			select
psa_v_0p160	double	YES			select
psa_v_0p170	double	YES			select
psa_v_0p180	double	YES			select
psa_v_0p190	double	YES			select
psa_v_0p200	double	YES			select
psa_v_0p220	double	YES			select
psa_v_0p240	double	YES			select
psa_v_0p250	double	YES			select
psa_v_0p260	double	YES			select
psa_v_0p280	double	YES			select
psa_v_0p290	double	YES			select
psa_v_0p300	double	YES			select
psa_v_0p320	double	YES			select
psa_v_0p340	double	YES			select
psa_v_0p350	double	YES			select
psa_v_0p360	double	YES			select
psa_v_0p380	double	YES			select
psa_v_0p400	double	YES			select
psa_v_0p420	double	YES			select
psa_v_0p440	double	YES			select
psa_v_0p450	double	YES			select
psa_v_0p460	double	YES			select
psa_v_0p480	double	YES			select
psa_v_0p500	double	YES			select
psa_v_0p550	double	YES			select
psa_v_0p600	double	YES			select
psa_v_0p650	double	YES			select
psa_v_0p667	double	YES			select
psa_v_0p700	double	YES			select
psa_v_0p750	double	YES			select
psa_v_0p800	double	YES			select
psa_v_0p850	double	YES			select
psa_v_0p900	double	YES			select
psa_v_0p950	double	YES			select
psa_v_1p000	double	YES			select
psa_v_1p100	double	YES			select
psa_v_1p200	double	YES			select
psa_v_1p300	double	YES			select
psa_v_1p400	double	YES			select
psa_v_1p500	double	YES			select
psa_v_1p600	double	YES			select
psa_v_1p700	double	YES			select
psa_v_1p800	double	YES			select
psa_v_1p900	double	YES			select
psa_v_2p000	double	YES			select
psa_v_2p200	double	YES			select
psa_v_2p400	double	YES			select
psa_v_2p500	double	YES			select
psa_v_2p600	double	YES			select
psa_v_2p800	double	YES			select
psa_v_3p000	double	YES			select
psa_v_3p200	double	YES			select
psa_v_3p400	double	YES			select
psa_v_3p500	double	YES			select
psa_v_3p600	double	YES			select
psa_v_3p800	double	YES			select
psa_v_4p000	double	YES			select
psa_v_4p200	double	YES			select
psa_v_4p400	double	YES			select
psa_v_4p600	double	YES			select
psa_v_4p800	double	YES			select
psa_v_5p000	double	YES			select
psa_v_5p500	double	YES			select
psa_v_6p000	double	YES			select
psa_v_6p500	double	YES			select
psa_v_7p000	double	YES			select
psa_v_7p500	double	YES			select
psa_v_8p000	double	YES			select
psa_v_8p500	double	YES			select
psa_v_9p000	double	YES			select
psa_v_9p500	double	YES			select
psa_v_10p000	double	YES			select
psa_v_11p000	double	YES			select
psa_v_12p000	double	YES			select
psa_v_13p000	double	YES			select
psa_v_14p000	double	YES			select
psa_v_15p000	double	YES			select
psa_v_20p000	double	YES			select

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	MUL		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(25)	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
z1p0_preferred_lnstd	float		YES				select	Log standard deviation (ln units) of preferred z1.0
z1p0_code_id	int(11)		YES	MUL			select	Foreign key; unique ID assigned to each z1p0 code for identification
z2p5_preferred	float		YES				select	Preferred depth (m) to Vs = 2.5 km/s
z2p5_preferred_lnstd	float		YES				select	Log standard deviation (ln units) of preferred z2.5
z2p5_code_id	int(11)		YES	MUL			select	Foreign key; unique ID assigned to each z2p5 code for identification
basin_geomorphic_category	int(11)		YES				select	Geomorphic province category (Nweke et al. 2022; Stewart et al. 2025): 0 = non-basin/mountain-hill (sites without significant sediments, generally having topographic relief); 2 = transitional zone (along basin margin; within 300 m of a basin edge); 3 = valley ("small" sedimentary structure; short direction width < 3 km); 4 = basin (short direction width >= 3 km); 5 = shelf-deposit (shallow-sediments over firm rock without directly bounding rock in one or more directions).
basin_geospatial_category	int(1)		YES				select	Geospatial province category (Nie et al. 2025): 0 = non-basin (sites with significant topographic relief or bodies of water); 1 = transition zone (basin edges, small channels, and ambiguous terrain); 2 = small basin (size determined from CWT coefficients); 3 = medium basin (size determined from CWT coefficients); 4 = large basin (size determined from CWT coefficients)
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
multiple_wave_train	int(11)		YES				select	Indicator if the record contains multiple events: 0 = single event; 1 = multiple wave-train arrivals
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_applied_h1	int(1)		YES				select	Applied a high-pass filter to the first horizontal component (H1) during signal processing: 0 = No; 1 = Yes; NULL = component was not recorded/processed
hpass_applied_h2	int(1)		YES				select	Applied a high-pass filter to the second horizontal component (H2) during signal processing: 0 = No; 1 = Yes; NULL = component was not recorded/processed
hpass_applied_v	int(1)		YES				select	Applied a high-pass filter to the vertical component (V) during signal processing: 0 = No; 1 = Yes; NULL = component was not recorded/processed
hpass_fc_h1	float		YES				select	High-pass filter corner frequency (Hz) used on the first horizontal component (H1).
hpass_fc_h2	float		YES				select	High-pass filter corner frequency (Hz) used on the second horizontal component (H2).
hpass_fc_v	float		YES				select	High-pass filter corner frequency (Hz) used on the vertical component (V).
lpass_applied_h1	int(1)		YES				select	Applied a low-pass filter to the first horizontal component (H1) during signal processing: 0 = No; 1 = Yes; NULL = component was not recorded/processed
lpass_applied_h2	int(1)		YES				select	Applied a low-pass filter to the second horizontal component (H2) during signal processing: 0 = No; 1 = Yes; NULL = component was not recorded/processed
lpass_applied_v	int(1)		YES				select	Applied a low-pass filter to the vertical component (V) during signal processing: 0 = No; 1 = Yes; NULL = component was not recorded/processed
lpass_fc_h1	float		YES				select	Low-pass filter corner frequency (Hz) used on the first horizontal component (H1).
lpass_fc_h2	float		YES				select	Low-pass filter corner frequency (Hz) used on the second horizontal component (H2).
lpass_fc_v	float		YES				select	Low-pass filter corner frequency (Hz) used on the vertical component (V).
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	MUL	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(1000)	utf8_unicode_ci	NO			select
version_citations	varchar(5000)	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.

z_code

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