SeismiQuery - Database Tables and Fields : IRIS

Database Tables

Table names are in BOLD and FIELDS are listed below the table names. This is a relational database, therefore FIELDS from one table can be related to FIELDS in one or many tables. FIELDS that have some relation to other TABLES are marked by like colors. For example, the FIELD ID in table B31 (or more properly noted - B31.id) is related to the FIELD B31_ID in tables CHANNEL_COMMENT and STATION_COMMENT (or CHANNEL_COMMENT.b31.id and STATION_COMMENT.b31_id). A list of definitions for some of the less obvious TABLE and FIELD names can be found on the definitions page.

NEW: Tables with temporary network information (primarily PASSCAL experiments) are now available.

B30 ID FAMILY NUMKEYS NAME KEY KEY2	B31 ID CLASS TEXT B34_ID	B32 ID NAME DATE_PUB PUBLISHER	B33 ID TEXT	B34 ID NAME TEXT
CHANNEL NETWORK STATION LOCATION * CHANNEL STARTTIME ENDTIME LATITUDE LONGITUDE ELEVATION DEPTH AZIMUTH DIP RECORD_LENGTH SAMPLE_RATE MAX_DRIFT LOOKUP_DFD LOOKUP_GA SUBCHANNEL COMMENTS FLAGS LOOKUP_UNITS_IN LOOKUP_UNITS_OUT UPDATE_FLAG	STATION NETWORK STATION STARTTIME ENDTIME LATITUDE LONGITUDE ELEVATION SITE LONG_WORD WORD LOOKUP_GA UPDATE_FLAG	MAG ID MAGNITUDE TYPE CONTRIBUTOR	EVENT ID SOURCE TIME TIME_MS LATITUDE LONGITUDE DEPTH CATALOG REGION CONTRIBUTOR LOOKUP_CSD	II_1990 * NETWORK STATION CHANNEL STARTTIME ENDTIME FILENAME BYTES LOCATION * This is just an example of one of our many timeseries TABLEs. The naming convention is NETWORK-CODE_YEAR.
		REGION CODE SEISMIC_REGION REGION_TEXT
CHANNEL_COMMENT NETWORK STATION CHANNEL STARTTIME ENDTIME B31_ID VALUE	STATION_COMMENT NETWORK STATION STARTTIME ENDTIME B31_ID VALUE	CHANNEL_SUMMARY NETWORK STATION LOCATION CHANNEL EARLIEST LATEST (NOTE: this table is a compilation of data from many tables and is not "related" to any one table)

Tables specific to temporary network information

NETWORKS

ID
NETWORK
STARTYR
ENDYR
NAME
TYPE
NICKNAME
DESCRIPTION
FORMAT
MIN_LAT
MAX_LAT
MIN_LON
MAX_LON
RESULTS
PROBLEMS
ARRIVAL
RELEASE
EST_SIZE
RESTRICTED
OPERATOR

NET_OPERATORS

NETWORK_ID
NETWORK
STARTYR
CONTACT
POSITION

PERSON

ID
NAME
INSTITUTION
EMAIL

POSITION

ID
NAME

INSTITUTION

ID
NAME
ADDR1
ADDR2
COUNTRY
PHONE
FAX
TYPE

INSTITUTION_TYPE

ID
TYPE