"ct-gov/covid19-reported-patient-impact-and-hospital-vvtn-9xef:latest"."covid19_reported_patient_impact_and_hospital"

SELECT
    ":id", -- Socrata column ID
    "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)
    "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_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)
    "hhs_id", -- 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_influenza_confirmed_7_day_sum", -- [FAQ - 34] 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_total_ed_visits_7_day_sum", -- [FAQ - 19] 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_covid_suspected_80plus_7_day_sum", -- [FAQ - 17. b8)] 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_covid_ed_visits_7_day_sum", -- [FAQ - 20] 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.
    "staffed_adult_icu_bed_occupancy_7_day_coverage", -- [FAQ - 6. b)] Number of times in the 7-day period that the facility reported total number of staffed inpatient adult ICU beds that are occupied.
    "icu_patients_confirmed_influenza_7_day_sum", -- [FAQ - 35] Sum of reports of patients (all ages) currently hospitalized in a designated ICU bed with laboratory-confirmed influenza reported in the 7-day period.
    "total_patients_hospitalized_confirmed_influenza_7_day_sum", -- [FAQ - 33] 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.
    "staffed_icu_adult_patients_confirmed_covid_7_day_sum", -- [FAQ - 12. b)] 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_occupancy_7_day_sum", -- [FAQ - 6. b)] Sum of reports of total number of staffed inpatient adult ICU beds that are occupied reported in the 7-day period.
    "inpatient_beds_7_day_sum", -- [FAQ - 3. a)] 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_hospitalized_confirmed_covid_7_day_000", -- [FAQ - 10. b)] 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.
    "all_adult_hospital_beds_7_day_sum", -- [FAQ - 2. b)] 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.
    "total_beds_7_day_sum", -- [FAQ - 2. a)] 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.
    "icu_patients_confirmed_influenza_7_day_avg", -- [FAQ - 35] Average of patients (all ages) currently hospitalized in a designated ICU bed with laboratory-confirmed influenza in the 7-day period.
    "inpatient_beds_7_day_avg", -- [FAQ - 3. a)] 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.
    "total_pediatric_patients_hospitalized_confirmed_and_suspect_000", -- [FAQ - 10. a)] 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.
    "all_adult_hospital_beds_7_day_avg", -- [FAQ - 2. b)] 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.
    "total_beds_7_day_avg", -- [FAQ - 2. a)] 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.
    "address", -- The address of the facility reporting.
    "hospital_name", -- [FAQ - 1. a)] The name of the facility reporting.
    "ccn", -- [FAQ - 1. b)] CMS Certification Number (CCN) of the given facility
    "collection_week", -- This date indicates the start of the period of reporting (the starting Friday).
    "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.
    "previous_day_admission_adult_covid_suspected_70_79_7_day_sum", -- [FAQ - 17. b7)] 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_covid_suspected_30_39_7_day_sum", -- [FAQ - 17. b3)] 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.
    "all_adult_hospital_inpatient_beds_7_day_sum", -- [FAQ - 3. b)] 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_confirmed_covid_7_day_avg", -- [FAQ - 12. b)] 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.
    "previous_day_admission_adult_covid_confirmed_40_49_7_day_sum", -- [FAQ - 17. a4)] 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.
    "icu_beds_used_7_day_sum", -- [FAQ - 6. a)] Sum of reports of total number of staffed inpatient ICU beds reported in the 7-day period.
    "staffed_adult_icu_bed_occupancy_7_day_avg", -- [FAQ - 6. b)] Average of total number of staffed inpatient adult ICU beds that are occupied reported in the 7-day period.
    "icu_beds_used_7_day_avg", -- [FAQ - 6. a)] Average number of total number of staffed inpatient ICU beds that are occupied reported in the 7-day period.
    "previous_day_admission_pediatric_covid_confirmed_7_day_sum", -- [FAQ - 18. a)] 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.
    "previous_day_admission_adult_covid_confirmed_80plus_7_day_sum", -- [FAQ - 17. a8)] 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.
    "total_icu_beds_7_day_sum", -- [FAQ - 5. a)] Sum of reports of total number of staffed inpatient ICU beds reported in the 7-day period.
    "total_pediatric_patients_hospitalized_confirmed_and_suspect_001", -- [FAQ - 10. a)] 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_patients_hospitalized_confirmed_influenza_7_day_avg", -- [FAQ - 33] 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_confirmed_and_suspected_covid_7__000", -- [FAQ - 12. a)] 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_adult_patients_hospitalized_confirmed_covid_7_day_avg", -- [FAQ - 9. b)] 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.
    "all_adult_hospital_inpatient_beds_7_day_avg", -- [FAQ - 3. b)] 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.
    "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_covid_suspected_60_69_7_day_sum", -- [FAQ - 17. b6)] 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.
    "previous_day_admission_adult_covid_suspected_7_day_sum", -- [FAQ - 17. b)] 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_admission_adult_covid_confirmed_70_79_7_day_sum", -- [FAQ - 17. a7)] 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_covid_confirmed_50_59_7_day_sum", -- [FAQ - 17. a5)] 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.
    "total_adult_patients_hospitalized_confirmed_covid_7_day_coverag", -- [FAQ - 9. b)] 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_adult_patients_hospitalized_confirmed_and_suspected_c_000", -- [FAQ - 9. a)] 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.
    "total_staffed_adult_icu_beds_7_day_avg", -- [FAQ - 5. b)] Average number of total number of staffed inpatient adult ICU beds reported in the 7-day period.
    "total_pediatric_patients_hospitalized_confirmed_covid_7_day_001", -- [FAQ - 10. b)] 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_bed_occupied_7_day_avg", -- [FAQ - 4. b)] Average of total number of staffed inpatient adult beds that are occupied 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 bed on previous calendar day with suspected COVID-19
    "previous_day_admission_adult_covid_confirmed_unknown_7_day_sum", -- [FAQ - 17. a9)] 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_pediatric_patients_hospitalized_confirmed_covid_7_day_002", -- [FAQ - 10. b)] 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.
    "total_icu_beds_7_day_avg", -- [FAQ - 5. a)] Average number of total number of staffed inpatient ICU beds reported in the 7-day period.
    "previous_day_admission_adult_covid_confirmed_7_day_sum", -- [FAQ - 17. a)] 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.
    "previous_day_admission_adult_covid_suspected_18_19_7_day_sum", -- [FAQ - 17. b1)] 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.
    "total_patients_hospitalized_confirmed_influenza_and_covid_7_000", -- [FAQ - 36] 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.
    "all_adult_hospital_inpatient_bed_occupied_7_day_sum", -- [FAQ - 4. b)] Sum of reports of total number of staffed inpatient adult beds that are occupied reported during the 7-day period.
    "city", -- The city of the facility reporting.
    "state", -- [FAQ - 1. d)] The two digit state/territory code for the hospital.
    "total_adult_patients_hospitalized_confirmed_and_suspected_c_001", -- [FAQ - 9. a)] 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.
    "hospital_location", -- Geocoded hospital location
    "total_staffed_adult_icu_beds_7_day_coverage", -- [FAQ - 5. b)] Number of times in the 7-day period that the facility reported total number of staffed inpatient adult ICU beds.
    "all_adult_hospital_inpatient_bed_occupied_7_day_coverage", -- [FAQ - 4. b)] 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_covid_confirmed_20_29_7_day_sum", -- [FAQ - 17. a2)] 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.
    "total_adult_patients_hospitalized_confirmed_covid_7_day_sum", -- [FAQ - 9. b)] 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.
    "inpatient_beds_used_7_day_avg", -- [FAQ - 4. a)] Average of total number of staffed inpatient beds that are occupied reported during the 7-day period.
    "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_covid_suspected_50_59_7_day_sum", -- [FAQ - 17. b5)] 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.
    "previous_day_admission_adult_covid_suspected_40_49_7_day_sum", -- [FAQ - 17. b4)] 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_covid_confirmed_60_69_7_day_sum", -- [FAQ - 17. a6)] 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_covid_confirmed_30_39_7_day_sum", -- [FAQ - 17. a3)] 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.
    "total_pediatric_patients_hospitalized_confirmed_and_suspect_002", -- [FAQ - 10. a)] 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_staffed_adult_icu_beds_7_day_sum", -- [FAQ - 5. b)] Sum of reports of total number of staffed inpatient adult ICU beds reported in the 7-day period.
    "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_covid_suspected_20_29_7_day_sum", -- [FAQ - 17. b2)] 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.
    "staffed_icu_adult_patients_confirmed_and_suspected_covid_7__001", -- [FAQ - 12. a)] 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.
    "total_icu_beds_7_day_coverage", -- [FAQ - 5. a)] Number of times in the 7-day period that the facility reported total number of staffed inpatient ICU beds.
    "inpatient_beds_7_day_coverage", -- [FAQ - 3. a)] 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_coverage", -- [FAQ - 2. a)] 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).
    "fips_code", -- The Federal Information Processing Standard (FIPS) code of the location of the hospital.
    "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_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_unknown_7_day_sum", -- [FAQ - 17. b9)] 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.
    "icu_patients_confirmed_influenza_7_day_coverage", -- [FAQ - 35] 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.
    "previous_day_admission_pediatric_covid_suspected_7_day_sum", -- [FAQ - 18. b)] 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.
    "total_patients_hospitalized_confirmed_influenza_7_day_coverage", -- [FAQ - 33] 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.
    "total_patients_hospitalized_confirmed_influenza_and_covid_7_001", -- [FAQ - 36] 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.
    "all_adult_hospital_beds_7_day_coverage", -- [FAQ - 2. b)] 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_adult_patients_hospitalized_confirmed_and_suspected_c_002", -- [FAQ - 9. a)] 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.
    "staffed_icu_adult_patients_confirmed_and_suspected_covid_7__002", -- [FAQ - 12. a)] 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_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
    "inpatient_beds_used_7_day_sum", -- [FAQ - 4. a)] Sum of reports of total number of staffed inpatient beds that are occupied reported during the 7-day period.
    "zip", -- The 5-digit zip code of the facility reporting.
    "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.
    "previous_day_admission_adult_covid_confirmed_18_19_7_day_sum", -- [FAQ - 17. a1)] 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.
    "icu_beds_used_7_day_coverage", -- [FAQ - 6. a)] Number of times in the 7-day period that the facility reported total number of staffed inpatient ICU beds.
    "all_adult_hospital_inpatient_beds_7_day_coverage", -- [FAQ - 3. b)] 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).
    "is_metro_micro", -- This is based on whether the facility serves a Metropolitan or Micropolitan area. True if yes, and false if no.
    "staffed_icu_adult_patients_confirmed_covid_7_day_coverage", -- [FAQ - 12. b)] 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.
    "total_patients_hospitalized_confirmed_influenza_and_covid_7_002", -- [FAQ - 36] 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.
    "inpatient_beds_used_7_day_coverage", -- [FAQ - 4. a)] Number of times in the 7-day period that the facility reported total number of staffed inpatient beds that are occupied.
    "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
    ":@computed_region_snd5_k6zv", -- This column was automatically created in order to record in what polygon from the dataset 'Planning Regions' (snd5-k6zv) the point in column 'hospital_location' is located.  This enables the creation of region maps (choropleths) in the visualization canvas and data lens.
    ":@computed_region_dam5_q64j", -- This column was automatically created in order to record in what polygon from the dataset 'Counties' (dam5-q64j) the point in column 'hospital_location' is located.  This enables the creation of region maps (choropleths) in the visualization canvas and data lens.
    ":@computed_region_m4y2_whse", -- This column was automatically created in order to record in what polygon from the dataset 'Town Index' (m4y2-whse) the point in column 'hospital_location' is located.  This enables the creation of region maps (choropleths) in the visualization canvas and data lens.
    ":@computed_region_nhmp_cq6b" -- This column was automatically created in order to record in what polygon from the dataset 'Zip Code' (nhmp-cq6b) the point in column 'hospital_location' is located.  This enables the creation of region maps (choropleths) in the visualization canvas and data lens.
FROM
    "ct-gov/covid19-reported-patient-impact-and-hospital-vvtn-9xef:latest"."covid19_reported_patient_impact_and_hospital"
LIMIT 100;

sgr clone ct-gov/covid19-reported-patient-impact-and-hospital-vvtn-9xef

sgr checkout ct-gov/covid19-reported-patient-impact-and-hospital-vvtn-9xef:latest

sgr checkout --layered ct-gov/covid19-reported-patient-impact-and-hospital-vvtn-9xef:latest