Query the Data Delivery Network
Query the DDNThe easiest way to query any data on Splitgraph is via the "Data Delivery Network" (DDN). The DDN is a single endpoint that speaks the PostgreSQL wire protocol. Any Splitgraph user can connect to it at data.splitgraph.com:5432 and query any version of over 40,000 datasets that are hosted or proxied by Splitgraph.
For example, you can query the covid19_reported_patient_impact_and_hospital table in this repository, by referencing it like:
"pa-gov/covid19-reported-patient-impact-and-hospital-c7w7-maff:latest"."covid19_reported_patient_impact_and_hospital"or in a full query, like:
SELECT
":id", -- Socrata column ID
"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_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.
"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.
"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_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.
"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", -- 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_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.
"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.
"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_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_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.
"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.
"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.
"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_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.
"icu_patients_confirmed", -- Average of patients (all ages) currently hospitalized in a designated ICU bed with laboratory-confirmed influenza 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.
"total_icu_beds_7_day_avg", -- Average of total staffed inpatient ICU beds 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.
"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
"zip", -- The 5-digit zip code of the facility reporting
"hospital_name", -- The name of the facility reporting
"city", -- The city of the facility reporting
"geocoded_hospital_address", -- The geocoded latitude and longitude of the facility reporting.
"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_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
"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_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_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.
"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.
"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.
"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).
"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).
"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_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.
"total_icu_beds_7_day_sum", -- Sum of reports of total number of staffed inpatient ICU beds reported 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.
"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.
"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.
"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
"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
"ccn", -- CMS Certification Number (CCN) of the given facility
"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_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.
"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.
"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.
"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.
"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).
"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.
"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.
"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.
"state", -- The two digit state/territory code for the hospital
"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.
"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_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.
"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.
"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_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_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.
"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.
"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
"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.
"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)
"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.
"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
":@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;Connecting to the DDN is easy. All you need is an existing SQL client that can connect to Postgres. As long as you have a SQL client ready, you'll be able to query pa-gov/covid19-reported-patient-impact-and-hospital-c7w7-maff with SQL in under 60 seconds.
Query Your Local Engine
Install Splitgraph Locally
bash -c "$(curl -sL https://github.com/splitgraph/splitgraph/releases/latest/download/install.sh)"Read the installation docs.
Splitgraph Cloud is built around Splitgraph Core (GitHub), which includes a local Splitgraph Engine packaged as a Docker image. Splitgraph Cloud is basically a scaled-up version of that local Engine. When you query the Data Delivery Network or the REST API, we mount the relevant datasets in an Engine on our servers and execute your query on it.
It's possible to run this engine locally. You'll need a Mac, Windows or Linux system to install sgr, and a Docker installation to run the engine. You don't need to know how to actually use Docker; sgrcan manage the image, container and volume for you.
There are a few ways to ingest data into the local engine.
For external repositories, the Splitgraph Engine can "mount" upstream data sources by using sgr mount. This feature is built around Postgres Foreign Data Wrappers (FDW). You can write custom "mount handlers" for any upstream data source. For an example, we blogged about making a custom mount handler for HackerNews stories.
For hosted datasets (like this repository), where the author has pushed Splitgraph Images to the repository, you can "clone" and/or "checkout" the data using sgr cloneand sgr checkout.
Cloning Data
Because pa-gov/covid19-reported-patient-impact-and-hospital-c7w7-maff:latest is a Splitgraph Image, you can clone the data from Spltgraph Cloud to your local engine, where you can query it like any other Postgres database, using any of your existing tools.
First, install Splitgraph if you haven't already.
Clone the metadata with sgr clone
This will be quick, and does not download the actual data.
sgr clone pa-gov/covid19-reported-patient-impact-and-hospital-c7w7-maffCheckout the data
Once you've cloned the data, you need to "checkout" the tag that you want. For example, to checkout the latest tag:
sgr checkout pa-gov/covid19-reported-patient-impact-and-hospital-c7w7-maff:latestThis will download all the objects for the latest tag of pa-gov/covid19-reported-patient-impact-and-hospital-c7w7-maff and load them into the Splitgraph Engine. Depending on your connection speed and the size of the data, you will need to wait for the checkout to complete. Once it's complete, you will be able to query the data like you would any other Postgres database.
Alternatively, use "layered checkout" to avoid downloading all the data
The data in pa-gov/covid19-reported-patient-impact-and-hospital-c7w7-maff:latest is 0 bytes. If this is too big to download all at once, or perhaps you only need to query a subset of it, you can use a layered checkout.:
sgr checkout --layered pa-gov/covid19-reported-patient-impact-and-hospital-c7w7-maff:latestThis will not download all the data, but it will create a schema comprised of foreign tables, that you can query as you would any other data. Splitgraph will lazily download the required objects as you query the data. In some cases, this might be faster or more efficient than a regular checkout.
Read the layered querying documentation to learn about when and why you might want to use layered queries.
Query the data with your existing tools
Once you've loaded the data into your local Splitgraph Engine, you can query it with any of your existing tools. As far as they're concerned, pa-gov/covid19-reported-patient-impact-and-hospital-c7w7-maff is just another Postgres schema.