"pa-gov/covid19-reported-patient-impact-and-hospital-c7w7-maff:latest"."covid19_reported_patient_impact_and_hospital"

SELECT
    ":id", -- Socrata column ID
    "previous_day_admission_adult_11", -- Sum of number of patients age 18-19 who were admitted to an adult inpatient bed on the previous calendar day who had suspected COVID-19 at the time of admission reported in 7-day period.
    "previous_day_admission", -- Sum of number of pediatric patients who were admitted to an inpatient bed, including NICU, PICU, newborn, and nursery, on the previous calendar day who had confirmed COVID-19 at the time of admission.
    "staffed_icu_adult_patients_5", -- Number of times in the 7-day period that the facility reported patients currently hospitalized in a designated adult ICU bed who have laboratory-confirmed COVID-19. Including patients who have both laboratory-confirmed COVID-19 and laboratory-confirmed influenza in this field.
    "staffed_icu_adult_patients_3", -- Sum of reports of patients currently hospitalized in a designated adult ICU bed who have laboratory-confirmed COVID-19. Including patients who have both laboratory-confirmed COVID-19 and laboratory-confirmed influenza in this field reported in the 7-day period.
    "staffed_adult_icu_bed_1", -- Sum of reports of total number of staffed inpatient adult ICU beds that are occupied reported in the 7-day period.
    "total_pediatric_patients_3", -- Sum of reports of patients currently hospitalized in a pediatric inpatient bed, including NICU, PICU, newborn, and nursery, who have laboratory-confirmed COVID-19. Including those in observation beds. Including patients who have both laboratory-confirmed COVID-19 and laboratory confirmed influenza in this field reported in the 7-day period.
    "total_adult_patients_3", -- Sum of reports of patients currently hospitalized in an adult inpatient bed who have laboratory-confirmed COVID-19. Including those in observation beds. Including patients who have both laboratory-confirmed COVID-19 and laboratory confirmed influenza in this field during the 7-day period.
    "total_personnel_covid_vaccinated_doses_one_7_day", -- [FAQ - 43] The current number reported of healthcare personnel who have received at least one dose of COVID-19 vaccination that is administered in a multi-dose series. This field is meant to represent those who have begun but not completed the vaccination process. Does not include those who received a single-dose vaccine in this field. (Collected on Wednesdays only)
    "previous_day_admission_2", -- Sum of number of patients (all ages) who were admitted to an inpatient bed on the previous calendar day who had laboratory-confirmed influenza at the time of admission reported in 7-day period.
    "previous_day_admission_adult_15", -- Sum of number of patients age 50-59 who were admitted to an adult inpatient bed on the previous calendar day who had suspected COVID-19 at the time of admission reported in 7-day period.
    "icu_patients_confirmed_2", -- Number of times in the 7-day period that the facility reported patients (all ages) currently hospitalized in a designated ICU bed with laboratory-confirmed influenza.
    "total_adult_patients_5", -- Number of times in the 7-day period that the facility reported patients currently hospitalized in an adult inpatient bed who have laboratory-confirmed COVID-19. Including those in observation beds. Including patients who have both laboratory-confirmed COVID-19 and laboratory confirmed influenza in this field.
    "total_beds_7_day_coverage", -- Number of times in the 7 day period that the facility reported total number of all staffed inpatient and outpatient beds in your hospital, including all overflow, observation, and active surge/expansion beds used for inpatients and for outpatients (including all ICU, ED, and observation).
    "icu_patients_confirmed", -- Average of patients (all ages) currently hospitalized in a designated ICU bed with laboratory-confirmed influenza in the 7-day period.
    "total_patients_hospitalized", -- Average number of patients (all ages) currently hospitalized in an inpatient bed who have laboratory-confirmed influenza. Including those in observation beds reported in the 7-day period.
    "staffed_icu_adult_patients_1", --  Average number of patients currently hospitalized in a designated adult ICU bed who have laboratory-confirmed COVID-19. Including patients who have both laboratory-confirmed COVID-19 and laboratory-confirmed influenza in this field reported in the 7-day period.
    "inpatient_beds_7_day_avg", -- Average number of total number of staffed inpatient beds in your hospital including all overflow, observation, and active surge/expansion beds used for inpatients (including all ICU beds) reported in the 7-day period.
    "all_adult_hospital_inpatient", -- Average of total number of staffed inpatient adult beds in the hospital including all overflow and active surge/expansion beds used for inpatients (including all designated ICU beds) reported during the 7-day period.
    "hospital_name", -- The name of the facility reporting
    "hospital_pk", -- This unique key for the given hospital that will match the CCN column if it exists, otherwise, it is a derived unique key
    "total_icu_beds_7_day_avg", --  Average of total staffed inpatient ICU beds reported in the 7-day period.
    "all_adult_hospital_inpatient_5", -- Number of times in the 7-day period that the facility reported total number of staffed inpatient adult beds that are occupied.
    "previous_day_admission_adult_17", -- Sum of number of patients age 70-79 who were admitted to an adult inpatient bed on the previous calendar day who had suspected COVID-19 at the time of admission reported in 7-day period.
    "staffed_adult_icu_bed_2", --  Number of times in the 7-day period that the facility reported total number of staffed inpatient adult ICU beds that are occupied.
    "total_adult_patients_4", -- Number of times in the 7-day period that the facility reported patients currently hospitalized in an adult inpatient bed who have laboratory-confirmed or suspected COVID19. Including those in observation beds.
    "total_icu_beds_7_day_sum", -- Sum of reports of total number of staffed inpatient ICU beds reported in the 7-day period.
    "geocoded_hospital_address", -- The geocoded latitude and longitude of the facility reporting.
    "total_personnel_covid_vaccinated_doses_all_7_day", -- [FAQ - 44] The current number reported of healthcare personnel who have received a complete series of a COVID-19vaccination.Includes those who have received all doses in a multi-dose series as well as those who received a single-dose vaccine. (Collected on Wednesdays only)
    "previous_day_admission_adult_16", -- Sum of number of patients age 60-69 who were admitted to an adult inpatient bed on the previous calendar day who had suspected COVID-19 at the time of admission reported in 7-day period.
    "icu_patients_confirmed_1", -- Sum of reports of patients (all ages) currently hospitalized in a designated ICU bed with laboratory-confirmed influenza reported in the 7-day period.
    "staffed_icu_adult_patients_2", -- Sum of reports of patients currently hospitalized in a designated adult ICU bed who have suspected or laboratory-confirmed COVID-19 reported in the 7-day period.
    "previous_day_admission_adult_4", -- Sum of number of patients age 40-49 who were admitted to an adult inpatient bed on the previous calendar day who had confirmed COVID-19 at the time of admission reported in 7-day period.
    "city", -- The city of the facility reporting
    "previous_week_personnel_covid_vaccinated_doses_administered_7_d", -- [FAQ - 41] The number reported of COVID-19 vaccination doses administered in the previous week regardless of whether it is a first or second dose in a series. (Collected on Wednesdays only)
    "previous_day_admission_adult_covid_confirmed_7_day_coverage", -- [FAQ - 17a] Number of times in the 7 day period that the facility reported the number of patients admitted to adult inpatient bed on previous calendar day with confirmed COVID-19
    "previous_day_total_ed_visits", -- Sum of total number of patient visits to the ED who were seen on the previous calendar day regardless of reason for visit. Including all patients who are triaged even if they leave before being seen by a provider reported in the 7-day period.
    "previous_day_admission_adult_18", -- Sum of number of patients 80 or older who were admitted to an adult inpatient bed on the previous calendar day who had suspected COVID-19 at the time of admission reported in 7-day period.
    "previous_day_admission_adult_10", -- Sum of number of patients who were admitted to an adult inpatient bed on the previous calendar day who had suspected COVID-19 at the time of admission reported in 7-day period.
    "previous_day_covid_ed_visits", -- Sum of total number of ED visits who were seen on the previous calendar day who had a visit related to COVID-19 (meets suspected or confirmed definition or presents for COVID diagnostic testing – do not count patients who present for pre-procedure screening) reported in 7-day period.
    "previous_day_admission_adult_8", -- Sum of number of patients 80 or older who were admitted to an adult inpatient bed on the previous calendar day who had confirmed COVID-19 at the time of admission reported in 7-day period.
    "previous_day_admission_adult_7", -- Sum of number of patients age 70-79 who were admitted to an adult inpatient bed on the previous calendar day who had suspected COVID-19 at the time of admission reported in 7-day period.
    "previous_day_admission_adult_5", --  Sum of number of patients age 50-59 who were admitted to an adult inpatient bed on the previous calendar day who had confirmed COVID-19 at the time of admission reported in 7-day period.
    "previous_day_admission_adult_3", -- Sum of number of patients age 30-39 who were admitted to an adult inpatient bed on the previous calendar day who had confirmed COVID-19 at the time of admission reported in 7-day period.
    "staffed_icu_adult_patients_4", -- Number of times in the 7-day period that the facility reported patients currently hospitalized in a designated adult ICU bed who have suspected or laboratory-confirmed COVID-19.
    "icu_beds_used_7_day_coverage", -- Number of times in the 7-day period that the facility reported total number of staffed inpatient ICU beds.
    "total_pediatric_patients_5", -- Number of times in the 7-day period that the facility reported patients currently hospitalized in a pediatric inpatient bed, including NICU, PICU, newborn, and nursery, who have laboratory-confirmed COVID-19. Including those in observation beds. Including patients who have both laboratory-confirmed COVID-19 and laboratory confirmed influenza in this field.
    "icu_beds_used_7_day_sum", -- Sum of reports of total staffed inpatient ICU beds occupied in the 7-day period.
    "total_staffed_adult_icu_beds_1", -- Sum of reports of total number of staffed inpatient adult ICU beds reported in the 7-day period.
    "inpatient_beds_7_day_sum", -- Sum of reports of total number of staffed inpatient beds in your hospital including all overflow, observation, and active surge/expansion beds used for inpatients (including all ICU beds) reported in the 7-day period.
    "total_pediatric_patients_2", -- Sum of reports of patients currently hospitalized in a pediatric inpatient bed, including NICU, PICU, newborn, and nursery, who are suspected or laboratory-confirmed-positive for COVID-19. Including those in observation beds reported in the 7-day period.
    "total_adult_patients_2", -- Sum of reports of patients currently hospitalized in an adult inpatient bed who have laboratory-confirmed or suspected COVID19. Including those in observation beds reported during the 7-day period.
    "all_adult_hospital_inpatient_3", -- um of reports of total number of staffed inpatient adult beds that are occupied reported during the 7-day period.
    "all_adult_hospital_beds_7_1", -- Sum of reports of all staffed inpatient and outpatient adult beds in the hospital, including all overflow and active surge/expansion beds for inpatients and for outpatients (including all ICU, ED, and observation) reported during the 7-day period.
    "staffed_icu_adult_patients", -- Average number of patients currently hospitalized in a designated adult ICU bed who have suspected or laboratory-confirmed COVID-19 reported in the 7-day period.
    "total_staffed_adult_icu_beds", -- Average of total number of staffed adult ICU beds reported in the 7-day period.
    "total_pediatric_patients_1", -- Average number of patients currently hospitalized in a pediatric inpatient bed, including NICU, PICU, newborn, and nursery, who have laboratory-confirmed COVID-19. Including those in observation beds. Including patients who have both laboratory-confirmed COVID-19 and laboratory confirmed influenza in this field reported in the 7-day period.
    "all_adult_hospital_inpatient_1", -- Average of total number of staffed inpatient adult beds that are occupied reported during the 7-day period.
    "inpatient_beds_used_7_day", -- Average of total number of staffed inpatient beds that are occupied reported during the 7-day period.
    "all_adult_hospital_beds_7", -- Average of all staffed inpatient and outpatient adult beds in the hospital, including all overflow and active surge/expansion beds for inpatients and for outpatients (including all ICU, ED, and observation) reported during the 7-day period
    "previous_day_admission_pediatric_covid_suspected_7_day_coverage", -- [FAQ - 18b] Number of times in the 7 day period that the facility reported the number of pediatric patients admitted to inpatient b
    "previous_day_admission_1", -- Sum of number of pediatrics patients who were admitted to an inpatient bed, including NICU, PICU, newborn, and nursery, on the previous calendar day who had suspected COVID-19 at the time of admission reported in 7-day period.
    "previous_day_admission_adult_19", -- Sum of number of patients age unknown who were admitted to an adult inpatient bed on the previous calendar day who had suspected COVID-19 at the time of admission reported in 7-day period.
    "previous_day_admission_adult_12", -- Sum of number of patients age 20-29 who were admitted to an adult inpatient bed on the previous calendar day who had suspected COVID-19 at the time of admission reported in 7-day period.
    "all_adult_hospital_inpatient_4", -- Number of times in the 7-day period that the facility reported total number of staffed inpatient adult beds in your hospital including all overflow and active surge/expansion beds used for inpatients (including all designated ICU beds).
    "total_patients_hospitalized_3", -- Sum of reports of patients (all ages) currently hospitalized in an inpatient bed who have laboratory-confirmed COVID-19 and laboratory-confirmed influenza reported in the 7-day period.
    "total_beds_7_day_avg", -- Average of total number of all staffed inpatient and outpatient beds in the hospital, including all overflow, observation, and active surge/expansion beds used for inpatients and for outpatients (including all ICU, ED, and observation) reported during the 7-day period
    "fips_code", -- The Federal Information Processing Standard (FIPS) code of the location of the hospital. This is 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
    "previous_week_patients_covid_vaccinated_doses_one_7_day", -- [FAQ - 46] The number reported of patients who received the first dose of a COVID-19 vaccine that is administered in a multi-dose series. (Collected on Wednesdays only)
    "previous_day_admission_adult_6", -- Sum of number of patients age 60-69 who were admitted to an adult inpatient bed on the previous calendar day who had confirmed COVID-19 at the time of admission reported in 7-day period.
    "previous_day_admission_adult_2", -- Sum of number of patients age 20-29 who were admitted to an adult inpatient bed on the previous calendar day who had confirmed COVID-19 at the time of admission reported in the 7-day period.
    "inpatient_beds_used_7_day_2", -- Number of times in the 7-day period that the facility reported total number of staffed inpatient beds that are occupied.
    "staffed_adult_icu_bed", -- Average of total number of staffed inpatient adult ICU beds that are occupied reported in the 7-day period.
    "zip", -- The 5-digit zip code of the facility reporting
    "total_personnel_covid_vaccinated_doses_none_7_day", -- [FAQ - 42] The number reported of healthcare personnel who have not yet received a single vaccine dose. (Collected on Wednesdays only)
    "previous_day_admission_adult_9", -- Sum of number of patients age unknown who were admitted to an adult inpatient bed on the previous calendar day who had confirmed COVID-19 at the time of admission reported in 7-day period.
    "total_icu_beds_7_day_coverage", -- Number of times in the 7-day period that the facility reported total number of staffed inpatient ICU beds.
    "total_pediatric_patients_4", -- Number of times in the 7-day period that the facility reported Patients currently hospitalized in a pediatric inpatient bed, including NICU, PICU, newborn, and nursery, who are suspected or laboratory-confirmed-positive for COVID-19. Including those in observation beds.
    "total_patients_hospitalized_2", --  Sum of reports of patients (all ages) currently hospitalized in an inpatient bed who have laboratory-confirmed influenza. Including those in observation beds reported in the 7-day period.
    "all_adult_hospital_inpatient_2", --  Sum of reports of all staffed inpatient adult beds in the hospital, including all overflow and active surge/expansion beds for inpatients and for outpatients (including all ICU, ED, and observation) reported during the 7-day period.
    "icu_beds_used_7_day_avg", -- Average of total number of staffed adult ICU beds that are occupied reported in the 7-day period.
    "total_pediatric_patients", -- Average number of patients currently hospitalized in a pediatric inpatient bed, including NICU, PICU, newborn, and nursery, who are suspected or laboratory-confirmed-positive for COVID-19. This average includes those in observation beds reported in the 7-day period.
    "total_adult_patients_1", -- Average number of patients currently hospitalized in an adult inpatient bed who have laboratory-confirmed COVID-19, including those in observation beds. This average includes patients who have both laboratory-confirmed COVID-19 and laboratory-confirmed influenza.
    "address", -- he address of the facility reporting
    "collection_week", -- This date indicates the start of the period of reporting (the starting Friday)
    "hhs_ids", -- As a part of an effort to improve the granularity of spatial data, unique identifiers (named “HHS IDs” in the datasets) have been assigned to each individual facility. These unique identifiers are provided so data users can reference each individual “brick and mortar” facility that is reporting data to HHS, even in cases when multiple facilities report under the same CMS Certification Number (CCN). Additional datasets and further details related to HHS IDs will be released at a later date.
    "previous_day_admission_adult_14", -- Sum of number of patients age 40-49 who were admitted to an adult inpatient bed on the previous calendar day who had suspected COVID-19 at the time of admission reported in 7-day period.
    "previous_day_admission_adult_1", -- Sum of number of patients age 18-19 who were admitted to an adult inpatient bed on the previous calendar day who had confirmed COVID-19 at the time of admission reported in the 7-day period.
    "previous_day_admission_adult", --  Sum of number of patients who were admitted to an adult inpatient bed on the previous calendar day who had confirmed COVID-19 at the time of admission reported in the 7-day period.
    "total_patients_hospitalized_4", -- Number of times in the 7-day period that the facility reported patients (all ages) currently hospitalized in an inpatient bed who have laboratory-confirmed influenza. Including those in observation beds.
    "inpatient_beds_used_7_day_1", -- Sum of reports of total number of staffed inpatient beds that are occupied reported during the 7-day period.
    "is_metro_micro", -- This is based on whether the facility serves a Metropolitan or Micropolitan area. True if yes, and false if no
    "is_corrected", -- If a fields has been altered from it's submitted form to smooth out data anomalies, this flag will be set to true
    "previous_day_admission_adult_13", -- Sum of number of patients age 30-39 who were admitted to an adult inpatient bed on the previous calendar day who had suspected COVID-19 at the time of admission reported in 7-day period.
    "total_patients_hospitalized_5", -- Number of times in the 7-day period that the facility reported patients (all ages) currently hospitalized in an inpatient bed who have laboratory-confirmed COVID-19 and laboratory-confirmed influenza.
    "inpatient_beds_7_day_coverage", -- Number of times in the 7-day period that the facility reported total number of staffed inpatient beds in your hospital including all overflow, observation, and active surge/expansion beds used for inpatients (including all ICU beds).
    "total_beds_7_day_sum", -- Sum of reports of total number of all staffed inpatient and outpatient beds in the hospital, including all overflow, observation, and active surge/expansion beds used for inpatients and for outpatients (including all ICU, ED, and observation) reported during the 7-day period.
    "total_adult_patients", -- Average number of patients currently hospitalized in an adult inpatient bed who have laboratory-confirmed or suspected COVID19, including those in observation beds reported during the 7-day period.
    "hospital_subtype", -- The sub-type of the facility reporting. Valid values are: Children's Hospitals, Critical Access Hospitals, Long Term, Psychiatric, Rehabilitation & Short Term. Some facilities are not designated with this field
    "all_adult_hospital_beds_7_2", --  Number of times in the 7-day period that the facility reported total number of all staffed inpatient and outpatient adult beds in your hospital, including all overflow and active surge/expansion beds for inpatients and for outpatients (including all ICU, ED, and observation).
    "total_patients_hospitalized_1", -- Average number of patients (all ages) currently hospitalized in an inpatient bed who have laboratory-confirmed COVID-19 and laboratory-confirmed influenza reported in the 7-day period.
    "ccn", -- CMS Certification Number (CCN) of the given facility
    "state", -- The two digit state/territory code for the hospital
    "total_staffed_adult_icu_beds_2", -- Number of times in the 7-day period that the facility reported total number of staffed inpatient adult ICU beds.
    "previous_day_admission_pediatric_covid_confirmed_7_day_coverage", -- [FAQ - 18a] Number of times in the 7 day period that the facility reported the number of pediatric patients admitted to an inpatient bed on previous calendar day with confirmed COVID-19
    "previous_day_admission_adult_covid_suspected_7_day_coverage", -- [FAQ - 17b] Number of times in the 7 day period that the facility reported the number of patients admitted to adult inpatient bed on previous calendar day with suspected COVID-19
    "previous_week_patients_covid_vaccinated_doses_all_7_day", -- [FAQ - 47] The number reported of patients who received the final dose in a COVID-19 vaccination series. (Collected on Wednesdays only)
    ":@computed_region_nmsq_hqvv" -- This column was automatically created in order to record in what polygon from the dataset 'Pennsylvania County Boundaries' (nmsq-hqvv) the point in column 'geocoded_hospital_address' is located.  This enables the creation of region maps (choropleths) in the visualization canvas and data lens.
FROM
    "pa-gov/covid19-reported-patient-impact-and-hospital-c7w7-maff:latest"."covid19_reported_patient_impact_and_hospital"
LIMIT 100;

sgr mount socrata \
  "pa-gov/covid19-reported-patient-impact-and-hospital-c7w7-maff" \
  --handler-options '{
    "domain": "data.pa.gov",
    "tables": {
        "covid19_reported_patient_impact_and_hospital": "c7w7-maff"
    }
}'