"pa-gov/percent-of-hospitalizations-for-opioid-overdose-by-e67c-nheg:latest"."percent_of_hospitalizations_for_opioid_overdose_by"

SELECT
    ":id", -- Socrata column ID
    "state_fips_code", -- These are the first 2 digits of the 5-digit Federal Information Processing Standard (FIPS) code that designate the State association. Each State has its own 2-digit number and each County within the state has its own 3-digit number which are combined into a 5-digit number to uniquely identify every US county. For more technical details : Federal Information Processing Standards Publications (FIPS PUBS) are issued by the National Institute of Standards and Technology (NIST) after approval by the Secretary of Commerce pursuant to Section 111 (d) of the Federal Property and Administrative Services Act of 1949 as amended by the Computer Security Act of 1987, Public Law 100-235. Federal Information Processing Standard (FIPS) 6-4, Counties and Equivalent Entities of the U.S., Its Possessions, and Associated Areas -- 90 Aug 31 , provides the names and codes that represent the counties and other entities treated as equivalent legal and/or statistical subdivisions of the 50 States, the District of Columbia, and the possessions and freely associated areas of the United States. Counties are considered to be the "first-order subdivisions" of each State and statistically equivalent entity, regardless of their local designations (county, parish, borough, etc.). Information gathered from census data - https://www.census.gov/library/reference/code-lists/ansi.html
    "percent_of_hospitalizations", -- The percent of hospitalizations within the specified opioid overdose category (“Heroin” or “Pain Medication”) with the specified anticipated primary payer (“Commercial”, “Medicaid”, “Medicare”, “Other”), rounded to the nearest tenth.
    "state", -- Commonwealth meaning the entire state of Pennsylvania - always will be Commonwealth
    "time_period_date_end", -- End of the reporting period that covers the hospitalization's discharge date.
    "time_period_date_start", -- Beginning of the reporting period that covers the hospitalization's discharge date.
    "anticipated_primary_payer", -- Specifies the anticipated primary payer as reported in the hospital record. Values: 1) “Commercial” = Anticipated primary payer listed as Commercial, 2) “Medicaid” = Anticipated primary payer listed as Medicaid, 3) “Medicare” = Anticipated primary payer listed as Medicare, and 4) “Other” = Anticipated primary payer listed as self-pay, other government, unknown/not listed, or is invalid.
    "category", -- Specifies whether the measurement is for hospitalizations for heroin overdose or for opioid pain medication overdose. Values: 1) “Heroin” = Hospitalizations with a principal diagnosis of heroin overdose, and 2) “Pain Medication” = Hospitalizations with a principal diagnosis of opioid pain medication overdose. 
    "time_period" -- Reporting period that the measurement is based upon; "CY-" prefix is shorthand for "calendar year", which begins on January 1st of the stated year and ends on December 31st of the stated year.
FROM
    "pa-gov/percent-of-hospitalizations-for-opioid-overdose-by-e67c-nheg:latest"."percent_of_hospitalizations_for_opioid_overdose_by"
LIMIT 100;

sgr mount socrata \
  "pa-gov/percent-of-hospitalizations-for-opioid-overdose-by-e67c-nheg" \
  --handler-options '{
    "domain": "data.pa.gov",
    "tables": {
        "percent_of_hospitalizations_for_opioid_overdose_by": "e67c-nheg"
    }
}'