Retrieve tri facility history data from tri database
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 | tri_tri_facility_history(TRI_FACILITY_ID = NULL, REPORTING_YEAR = NULL,
FACILITY_NAME = NULL, STREET_ADDRESS = NULL, CITY_NAME = NULL,
COUNTY_NAME = NULL, STATE_COUNTY_FIPS_CODE = NULL,
STATE_ABBR = NULL, ZIP_CODE = NULL, REGION = NULL,
MAIL_NAME = NULL, MAIL_STREET_ADDRESS = NULL, MAIL_CITY = NULL,
MAIL_STATE_ABBR = NULL, MAIL_PROVINCE = NULL, MAIL_COUNTRY = NULL,
MAIL_ZIP_CODE = NULL, ASGN_FEDERAL_IND = NULL, ASGN_AGENCY = NULL,
PARENT_CO_DB_NUM = NULL, PARENT_CO_NAME = NULL,
FAC_LATITUDE = NULL, FAC_LONGITUDE = NULL, PREF_LATITUDE = NULL,
PREF_LONGITUDE = NULL, PREF_ACCURACY = NULL,
PREF_COLLECT_METH = NULL, PREF_DESC_CATEGORY = NULL,
PREF_HORIZONTAL_DATUM = NULL, PREF_SOURCE_SCALE = NULL,
PREF_QA_CODE = NULL, ASGN_PARTIAL_IND = NULL,
ASGN_PUBLIC_CONTACT = NULL, ASGN_PUBLIC_PHONE = NULL,
ASGN_PUBLIC_CONTACT_EMAIL = NULL, BIA_CODE = NULL,
STANDARDIZED_PARENT_COMPANY = NULL, ASGN_PUBLIC_PHONE_EXT = NULL)
|
TRI_FACILITY_ID |
e.g. '00602BXTRF111CO'. See Details. |
REPORTING_YEAR |
e.g. '1988'. See Details. |
FACILITY_NAME |
e.g. 'BAXTER FENWAL DIV.,'. See Details. |
STREET_ADDRESS |
e.g. '111 COLON ST.,'. See Details. |
CITY_NAME |
e.g. 'AGUADA'. See Details. |
COUNTY_NAME |
e.g. 'AGUADA'. See Details. |
STATE_COUNTY_FIPS_CODE |
e.g. 'NA'. See Details. |
STATE_ABBR |
e.g. 'PR'. See Details. |
ZIP_CODE |
e.g. '00602'. See Details. |
REGION |
e.g. '2'. See Details. |
MAIL_NAME |
e.g. 'NA'. See Details. |
MAIL_STREET_ADDRESS |
e.g. 'NA'. See Details. |
MAIL_CITY |
e.g. 'NA'. See Details. |
MAIL_STATE_ABBR |
e.g. 'NA'. See Details. |
MAIL_PROVINCE |
e.g. 'NA'. See Details. |
MAIL_COUNTRY |
e.g. 'NA'. See Details. |
MAIL_ZIP_CODE |
e.g. 'NA'. See Details. |
ASGN_FEDERAL_IND |
e.g. 'C'. See Details. |
ASGN_AGENCY |
e.g. 'NA'. See Details. |
PARENT_CO_DB_NUM |
e.g. 'NA'. See Details. |
PARENT_CO_NAME |
e.g. 'BAXTER SALES CORP.'. See Details. |
FAC_LATITUDE |
e.g. 'NA'. See Details. |
FAC_LONGITUDE |
e.g. 'NA'. See Details. |
PREF_LATITUDE |
e.g. 'NA'. See Details. |
PREF_LONGITUDE |
e.g. 'NA'. See Details. |
PREF_ACCURACY |
e.g. 'NA'. See Details. |
PREF_COLLECT_METH |
e.g. 'NA'. See Details. |
PREF_DESC_CATEGORY |
e.g. 'NA'. See Details. |
PREF_HORIZONTAL_DATUM |
e.g. 'NA'. See Details. |
PREF_SOURCE_SCALE |
e.g. 'NA'. See Details. |
PREF_QA_CODE |
e.g. 'NA'. See Details. |
ASGN_PARTIAL_IND |
e.g. 'NA'. See Details. |
ASGN_PUBLIC_CONTACT |
e.g. 'NA'. See Details. |
ASGN_PUBLIC_PHONE |
e.g. 'NA'. See Details. |
ASGN_PUBLIC_CONTACT_EMAIL |
e.g. 'NA'. See Details. |
BIA_CODE |
e.g. 'NA'. See Details. |
STANDARDIZED_PARENT_COMPANY |
e.g. 'NA'. See Details. |
ASGN_PUBLIC_PHONE_EXT |
e.g. 'NA'. See Details. |
Add the following code to your website.
For more information on customizing the embed code, read Embedding Snippets.