This integration is powered by Singer's COVID-19 tap. For support, visit the GitHub repo or join the Singer Slack.
COVID-19 Public Data integration summary
Stitch’s COVID-19 Public Data integration was developed in a collaboration between Bytecode and Talend. It replicates data from multiple public data sources using the GitHub REST API v3. Refer to the Schema section for a list of objects available for replication.
COVID-19 Public Data feature snapshot
A high-level look at Stitch's COVID-19 Public Data (v1) integration, including release status, useful links, and the features supported in Stitch.
| STITCH | |||
| Release status |
Released on April 2, 2020 |
Supported by | |
| Stitch plan |
Standard |
API availability |
Available |
| Singer GitHub repository | |||
| REPLICATION SETTINGS | |||
| Anchor Scheduling |
Supported |
Advanced Scheduling |
Supported |
| Table-level reset |
Unsupported |
Configurable Replication Methods |
Unsupported |
| DATA SELECTION | |||
| Table selection |
Supported |
Column selection |
Supported |
| Select all |
Supported |
||
| TRANSPARENCY | |||
| Extraction Logs |
Supported |
Loading Reports |
Supported |
Connecting COVID-19 Public Data
COVID-19 Public Data setup requirements
To set up COVID-19 Public Data in Stitch, you need:
-
A regular (free) GitHub account. The GitHub repo for this integration is public - no special access is required.
Step 1: Create a GitHub personal access token
- Sign into your GitHub account.
- Click the User menu (your icon) > Settings.
- Click Developer settings in the navigation on the left side of the page.
- Click Personal access tokens.
- On the Personal access tokens page, click the Generate new token button. If prompted, enter your password.
- In the Description field, enter
stitch. This will allow you to easily identify what application is using the token. -
In the Select Scopes section, check the repo option:
Note: While these are full permissions, Stitch will only ever read your data. The repo scope is required due to how GitHub structures permissions.
- Click the Generate token button.
- The new access token will display on the next page. Copy the token before navigating away from the page - GitHub won’t display it again.
Step 2: Add COVID-19 Public Data as a Stitch data source
- Sign into your Stitch account.
-
On the Stitch Dashboard page, click the Add Integration button.
-
Click the COVID-19 icon.
-
Enter a name for the integration. This is the name that will display on the Stitch Dashboard for the integration; it’ll also be used to create the schema in your destination.
For example, the name “Stitch COVID-19 Public Data” would create a schema called
stitch_covid_19_public_datain the destination. Note: Schema names cannot be changed after you save the integration. - In the GitHub Access Token field, paste the access token you created in Step 1.
Step 3: Define the historical replication start date
The Sync Historical Data setting defines the starting date for your COVID-19 Public Data integration. This means that:
- For tables using Key-based Incremental Replication, data equal to or newer than this date will be replicated to your destination.
- For tables using Full Table Replication, all data - including records that are older, equal to, or newer than this date - will be replicated to your destination.
Change this setting if you want to replicate data beyond COVID-19 Public Data’s default setting of 1 year. For a detailed look at historical replication jobs, check out the Syncing Historical SaaS Data guide.
Step 4: Create a replication schedule
In the Replication Frequency section, you’ll create the integration’s replication schedule. An integration’s replication schedule determines how often Stitch runs a replication job, and the time that job begins.
COVID-19 Public Data integrations support the following replication scheduling methods:
-
Advanced Scheduling using Cron (Advanced or Premium plans only)
To keep your row usage low, consider setting the integration to replicate less frequently. See the Understanding and Reducing Your Row Usage guide for tips on reducing your usage.
Step 5: Set objects to replicate
The last step is to select the tables and columns you want to replicate. Learn about the available tables for this integration.
Note: If a replication job is currently in progress, new selections won’t be used until the next job starts.
For COVID-19 Public Data integrations, you can select:
-
Individual tables and columns
-
All tables and columns
Click the tabs to view instructions for each selection method.
- In the integration’s Tables to Replicate tab, locate a table you want to replicate.
-
To track a table, click the checkbox next to the table’s name. A blue checkmark means the table is set to replicate.
-
To track a column, click the checkbox next to the column’s name. A blue checkmark means the column is set to replicate.
- Repeat this process for all the tables and columns you want to replicate.
- When finished, click the Finalize Your Selections button at the bottom of the screen to save your selections.
- Click into the integration from the Stitch Dashboard page.
-
Click the Tables to Replicate tab.
- In the list of tables, click the box next to the Table Names column.
-
In the menu that displays, click Track all Tables and Fields:
- Click the Finalize Your Selections button at the bottom of the page to save your data selections.
Initial and historical replication jobs
After you finish setting up COVID-19 Public Data, its Sync Status may show as Pending on either the Stitch Dashboard or in the Integration Details page.
For a new integration, a Pending status indicates that Stitch is in the process of scheduling the initial replication job for the integration. This may take some time to complete.
Initial replication jobs with Anchor Scheduling
If using Anchor Scheduling, an initial replication job may not kick off immediately. This depends on the selected Replication Frequency and Anchor Time. Refer to the Anchor Scheduling documentation for more information.
Free historical data loads
The first seven days of replication, beginning when data is first replicated, are free. Rows replicated from the new integration during this time won’t count towards your quota. Stitch offers this as a way of testing new integrations, measuring usage, and ensuring historical data volumes don’t quickly consume your quota.
COVID-19 Public Data table reference
Schemas and versioning
Schemas and naming conventions can change from version to version, so we recommend verifying your integration’s version before continuing.
The schema and info displayed below is for version 1 of this integration.
This is the latest version of the COVID-19 Public Data integration.
Table and column names in your destination
Depending on your destination, table and column names may not appear as they are outlined below.
For example: Object names are lowercased in Redshift (CusTomERs > customers), while case is maintained in PostgreSQL destinations (CusTomERs > CusTomERs). Refer to the Loading Guide for your destination for more info.
c19_trk_us_daily
| Replication Method : |
Key-based Incremental |
Replication Key  :
|
git_last_modified |
Primary Key  :
|
__sdc_row_number |
Official docs : |
The c19_trk_us_daily table contains statistics for the United States, aggregated by day.
Note: The source file for this table is a single file that updates on a daily basis. When Stitch replicates this table, it will replicate the entire contents of the file, but only if the file has been modified since the integration’s last replication job.
|
__sdc_row_number
The number of the row in the source CSV. |
|
git_last_modified
The date the git file was last modified. |
|
date
The date. |
|
date_checked
|
|
death
The number of deaths recorded for the day. |
|
death_increase
The increase in recorded deaths from the previous day. |
|
git_file_name
The name of the source git file. |
|
git_html_url
The URL of the source git html. |
|
git_owner
The owner of the file in git. |
|
git_path
The path to the file in git. |
|
git_repository
The git repository. |
|
git_sha
The SHA of the file in git. |
|
git_url
The git URL. |
|
hospitalized
The number of recorded hospitalized cases for the day. |
|
hospitalized_increase
The increase in recorded hospitalizations from the previous day. |
|
negative
The number of negative tests recorded for the day. |
|
negative_increase
The increase in recorded negative tests from the previous day. |
|
pending
The number of pending tests for the day. |
|
pos_neg
The sum of |
|
positive
The number of recorded positive tests for the day. |
|
positive_increase
The increase in recorded positive tests from the previous day. |
|
states
The number of states included in the day’s statistics. |
|
total
The sum of |
|
total_test_results
The total number of test results recorded for the day. |
|
total_test_results_increase
The increase in test results from the previous day. |
c19_trk_us_population_counties
| Replication Method : |
Key-based Incremental |
Replication Key :
|
git_last_modified |
|
Primary Key :
|
__sdc_row_number |
Official docs : |
The c19_trk_us_population_counties table contains statistics for reporting counties in the United States.
Note: The source file for this table is a single file that updates on a daily basis. When Stitch replicates this table, it will replicate the entire contents of the file, but only if the file has been modified since the integration’s last replication job.
|
__sdc_row_number
The number of the row in the source CSV. |
|
git_last_modified
The date the git file was last modified. |
|
county
The name of the county. For example: |
|
geo_id
|
|
git_file_name
The name of the source git file. |
|
git_html_url
The URL of the source git html. |
|
git_last_modified
The date the git file was last modified. |
|
git_owner
The owner of the file in git. |
|
git_path
The path to the file in git. |
|
git_repository
The git repository. |
|
git_sha
The SHA of the file in git. |
|
git_url
The git URL. |
|
pop_density
The population density for the county. |
|
population
The total population for the county. |
|
state
The abbreviated state code for the state. For example: |
|
state_name
The name of the state. For example: |
c19_trk_us_population_states
| Replication Method : |
Key-based Incremental |
Replication Key :
|
git_last_modified |
|
Primary Key :
|
__sdc_row_number |
Official docs : |
The c19_trk_us_population_states table contains population statistics for states in the United States.
Note: The source file for this table is a single file that updates on a daily basis. When Stitch replicates this table, it will replicate the entire contents of the file, but only if the file has been modified since the integration’s last replication job.
|
__sdc_row_number
The number of the row in the source CSV. |
|
git_last_modified
The date the git file was last modified. |
|
geo_id
|
|
git_file_name
The name of the source git file. |
|
git_html_url
The URL of the source git html. |
|
git_last_modified
The date the git file was last modified. |
|
git_owner
The owner of the file in git. |
|
git_path
The path to the file in git. |
|
git_repository
The git repository. |
|
git_sha
The SHA of the file in git. |
|
git_url
The git URL. |
|
pop_density
The population density for the state. |
|
population
The total population for the state. |
|
state
The abbreviated state code for the state. For example: |
|
state_name
The name of the state. For example: |
c19_trk_us_population_states_age_groups
| Replication Method : |
Key-based Incremental |
Replication Key :
|
git_last_modified |
|
Primary Key :
|
__sdc_row_number |
Official docs : |
The c19_trk_us_population_states_age_groups table contains population statistics in the United States, aggregated by age group and state.
Note: The source file for this table is a single file that updates on a daily basis. When Stitch replicates this table, it will replicate the entire contents of the file, but only if the file has been modified since the integration’s last replication job.
|
__sdc_row_number
The number of the row in the source CSV. |
|
git_last_modified
The date the git file was last modified. |
|
agegroup
The age group. |
|
geo_id
|
|
git_file_name
The name of the source git file. |
|
git_html_url
The URL of the source git html. |
|
git_last_modified
The date the git file was last modified. |
|
git_owner
The owner of the file in git. |
|
git_path
The path to the file in git. |
|
git_repository
The git repository. |
|
git_sha
The SHA of the file in git. |
|
git_url
The git URL. |
|
pct_pop
|
|
population
The population for the state. |
|
state
The abbreviated state code for the state. For example: |
|
state_name
The name of the state. For example: |
c19_trk_us_states_acs_health_insurance
| Replication Method : |
Key-based Incremental |
Replication Key :
|
git_last_modified |
|
Primary Key :
|
__sdc_row_number |
Official docs : |
The c19_trk_us_states_acs_health_insurance table contains health insurance statistics for the United States.
Note: The source file for this table is a single file that updates on a daily basis. When Stitch replicates this table, it will replicate the entire contents of the file, but only if the file has been modified since the integration’s last replication job.
|
__sdc_row_number
The number of the row in the source CSV. |
|
git_last_modified
The date the git file was last modified. |
|
acs_variable
|
|
age_group
The age group. |
|
concept
|
|
coverage_type
The type of health insurance coverage. |
|
employed
|
|
estimate
|
|
estimate_type
|
|
geo_id
|
|
git_file_name
The name of the source git file. |
|
git_html_url
The URL of the source git html. |
|
git_last_modified
The date the git file was last modified. |
|
git_owner
The owner of the file in git. |
|
git_path
The path to the file in git. |
|
git_repository
The git repository. |
|
git_sha
The SHA of the file in git. |
|
git_url
The git URL. |
|
label
|
|
labor_force
|
|
margin_of_error
|
|
state
The abbreviated state code for the state. For example: |
|
state_name
The name of the state. For example: |
c19_trk_us_states_current
| Replication Method : |
Key-based Incremental |
Replication Key :
|
git_last_modified |
|
Primary Key :
|
__sdc_row_number |
Official docs : |
The c19_trk_us_states_current table contains current statistics for states in the United States.
Note: The source file for this table is a single file that updates on a daily basis. When Stitch replicates this table, it will replicate the entire contents of the file, but only if the file has been modified since the integration’s last replication job.
|
__sdc_row_number
The number of the row in the source CSV. |
|
git_last_modified
The date the git file was last modified. |
|
check_time_et
|
|
commercial_score
|
|
date_checked
The date and time when the data was last checked. |
|
date_modified
The date the record was last modified. |
|
death
The cumulative number of deaths recorded for the state. |
|
fips
Federal Information Processing Standard state code. |
|
git_file_name
The name of the source git file. |
|
git_html_url
The URL of the source git html. |
|
git_last_modified
The date the git file was last modified. |
|
git_owner
The owner of the file in git. |
|
git_path
The path to the file in git. |
|
git_repository
The git repository. |
|
git_sha
The SHA of the file in git. |
|
git_url
The git URL. |
|
grade
The letter grade, based on |
|
hospitalized
The total cumulative number of people hospitalized. |
|
last_update_et
|
|
negative
The total cumulative number of negative tests. |
|
negative_regular_score
+1 for reporting negatives reliably. |
|
notes
|
|
pending
The number of pending tests for the day. |
|
positive
The total cumulative number of positive tests. |
|
positive_score
+1 for reporting positives reliably. |
|
score
The data quality grade for the state. Possible values are:
Refer to the COVID documentation for more info about how scores are caluclated. |
|
state
The state or territory postal code abbreviation. |
|
total
Deprecated. Equal to |
|
total_test_results
The total number of test results, calculated as |
c19_trk_us_states_daily
| Replication Method : |
Key-based Incremental |
Replication Key :
|
git_last_modified |
|
Primary Key :
|
__sdc_row_number |
Official docs : |
The c19_trk_us_states_daily table contains historical data for states in the United States, aggregated by day. Note: COVID-19 Public Data updates this data every day at 4PM ET.
Note: The source file for this table is a single file that updates on a daily basis. When Stitch replicates this table, it will replicate the entire contents of the file, but only if the file has been modified since the integration’s last replication job.
|
__sdc_row_number
The number of the row in the source CSV. |
|
git_last_modified
The date the git file was last modified. |
|
date
The date. |
|
date_checked
|
|
death
The total cumulative number of people that have died. |
|
death_increase
The increase in recorded deaths from the previous day. |
|
fips
The Federal Information Processing Standard state code. |
|
git_file_name
The name of the source git file. |
|
git_html_url
The URL of the source git html. |
|
git_last_modified
The date the git file was last modified. |
|
git_owner
The owner of the file in git. |
|
git_path
The path to the file in git. |
|
git_repository
The git repository. |
|
git_sha
The SHA of the file in git. |
|
git_url
The git URL. |
|
hospitalized
The number of recorded hospitalized cases for the day. |
|
hospitalized_increase
The increase in recorded hospitalizations from the previous day. |
|
negative
The total cumulative negative test results. |
|
negative_increase
The increase in recorded negative tests from the previous day. |
|
pending
The number of tests that have been submitted to a lab but no results have been reported yet. |
|
positive
The number of total cumulative positive test results. |
|
positive_increase
The increase in recorded positive tests from the previous day. |
|
state
The state or territory postal code abbreviation. |
|
total
Deprecated. Equal to |
|
total_test_results
The total number of test results |
|
total_test_results_increase
The increase in test results from the previous day. |
c19_trk_us_states_info
| Replication Method : |
Key-based Incremental |
Replication Key :
|
git_last_modified |
|
Primary Key :
|
__sdc_row_number |
Official docs : |
The c19_trk_us_states_info table contains information about states in the United States.
Note: The source file for this table is a single file that updates on a daily basis. When Stitch replicates this table, it will replicate the entire contents of the file, but only if the file has been modified since the integration’s last replication job.
|
__sdc_row_number
The number of the row in the source CSV. |
|
git_last_modified
The date the git file was last modified. |
|
covid19_site
The webpage dedicated to making results available to the public. |
|
covid19_site_old
|
|
covid19_site_secondary
An informational webpage. |
|
fips
The Federal Information Processing Standard state code. |
|
git_file_name
The name of the source git file. |
|
git_html_url
The URL of the source git html. |
|
git_last_modified
The date the git file was last modified. |
|
git_owner
The owner of the file in git. |
|
git_path
The path to the file in git. |
|
git_repository
The git repository. |
|
git_sha
The SHA of the file in git. |
|
git_url
The git URL. |
|
name
The full state or territory name. |
|
notes
Notes about the information available and how it’s collected or recorded. |
|
pui
Person Under Investigation; it is meant to capture positive, negative, and pending test results. |
|
pum
Person Under Monitoring. Note: The source doesn’t track these numbers as they are reported less consistently across states. |
|
state
The state or territory postal code abbreviation. |
|
twitter
Twitter for the state’s health department. |
c19_trk_us_states_kff_hospital_beds
| Replication Method : |
Key-based Incremental |
Replication Key :
|
git_last_modified |
|
Primary Key :
|
__sdc_row_number |
Official docs : |
The c19_trk_us_states_kff_hospital_beds table contains statistics about hospital beds per 1,000 population, segmented by hospital ownership type.
Note: The source file for this table is a single file that updates on a daily basis. When Stitch replicates this table, it will replicate the entire contents of the file, but only if the file has been modified since the integration’s last replication job.
|
__sdc_row_number
The number of the row in the source CSV. |
|
git_last_modified
The date the git file was last modified. |
|
for_profit
The number of hospital beds for for-profit hospitals. |
|
git_file_name
The name of the source git file. |
|
git_html_url
The URL of the source git html. |
|
git_last_modified
The date the git file was last modified. |
|
git_owner
The owner of the file in git. |
|
git_path
The path to the file in git. |
|
git_repository
The git repository. |
|
git_sha
The SHA of the file in git. |
|
git_url
The git URL. |
|
non_profit
The number of hospital beds for non-profit hospitals. |
|
state
The state or territory postal code abbreviation. |
|
state_local_government
The number of hospital beds for state/local government hospitals. |
|
state_name
The full name of the state or territory. |
|
total
The total number of hospital beds, calculated by |
eu_daily
| Replication Method : |
Key-based Incremental |
Replication Key :
|
git_last_modified |
|
Primary Key :
|
git_path : __sdc_row_number |
Official docs : |
The eu_daily table contains statistics for the European Union, aggregated by day. This data is sourced from the covid19-eu-data GitHub repository.
|
git_path
The path to the file in git. |
|
__sdc_row_number
The number of the row in the source CSV. |
|
git_last_modified
The date the git file was last modified. |
|
cases
The number of cases by the specified |
|
cases_100k_pop
The number of cases per 100k population. When looking at this value, note that:
|
|
cases_lower
|
|
cases_upper
|
|
country
The country code. |
|
date
The date. |
|
datetime
The local datetime of the record. |
|
deaths
The number of deaths. When looking at this value, note that:
|
|
git_file_name
The name of the source git file. |
|
git_html_url
The URL of the source git html. |
|
git_owner
The owner of the file in git. |
|
git_repository
The git repository. |
|
git_sha
The SHA of the file in git. |
|
git_url
The git URL. |
|
hospitalized
The number of hospitalized patients. |
|
intensive_care
The number of patients in intensive care. |
|
lau
|
|
nuts_1
Applicable to Germany. NUTS 1 (states) in Germany. |
|
nuts_2
|
|
nuts_3
|
|
percent
The percent of cases by the specified |
|
population
The population of the city. |
|
quarantine
The number of quarantined patients. |
|
recovered
The number of recovered patients. When looking at this value, note that:
|
|
tests
|
eu_ecdc_daily
| Replication Method : |
Key-based Incremental |
Replication Key :
|
git_last_modified |
|
Primary Key :
|
git_path : __sdc_row_number |
Official docs : |
The eu_ecdc_daily table contains statistics reported to the European Centre for Disease Prevention and Control, segmented by day.
|
git_path
The path to the file in git. |
|
__sdc_row_number
The number of the row in the source CSV. |
|
git_last_modified
The date the git file was last modified. |
|
cases
The number of cases. |
|
country
The country code. |
|
date
The date. |
|
datetime
The local datetime of the record. |
|
deaths
The number of deaths. |
|
git_file_name
The name of the source git file. |
|
git_html_url
The URL of the source git html. |
|
git_owner
The owner of the file in git. |
|
git_repository
The git repository. |
|
git_sha
The SHA of the file in git. |
|
git_url
The git URL. |
italy_national_daily
| Replication Method : |
Key-based Incremental |
Replication Key :
|
git_last_modified |
|
Primary Key :
|
git_path : __sdc_row_number |
Official docs : |
The italy_national_daily table contains statistics for Italy, segmented by day.
|
git_path
The path to the file in git. |
|
__sdc_row_number
The number of the row in the source CSV. |
|
git_last_modified
The date the git file was last modified. |
|
country
The country code. |
|
date
The date. |
|
date_of_notification
The date of the record. |
|
datetime
The datetime of the record. |
|
deaths
The number of recorded deaths. |
|
discharged_recovered
The number of recovered patients. |
|
git_file_name
The name of the source git file. |
|
git_html_url
The URL of the source git html. |
|
git_owner
The owner of the file in git. |
|
git_repository
The git repository. |
|
git_sha
The SHA of the file in git. |
|
git_url
The git URL. |
|
home_isolation
The number of people in home isolation. |
|
hospitalized_with_symptoms
The number of people hospitalized with symptoms. |
|
intensive_care
The number of people hospitalized in intensive care. |
|
new_currently_positive
The new amount of current positive cases, calculated as the current day’s |
|
note_en
Notes in English. |
|
note_it
Notes in Italian. |
|
tested
The number of tested cases. |
|
total_cases
The total number of cases. |
|
total_currently_positive
The total number of currently positive cases. |
|
total_hospitalized
The total number of hospitalized cases. |
italy_provincial_daily
| Replication Method : |
Key-based Incremental |
Replication Key :
|
git_last_modified |
|
Primary Key :
|
git_path : __sdc_row_number |
Official docs : |
The italy_provincial_daily table contains statistics for Italian provinces, segmented by day.
|
git_path
The path to the file in git. |
|
__sdc_row_number
The number of the row in the source CSV. |
|
git_last_modified
The date the git file was last modified. |
|
country
The country reference code. |
|
date
The date. |
|
date_of_notification
|
|
datetime
|
|
git_file_name
The name of the source git file. |
|
git_html_url
The URL of the source git html. |
|
git_owner
The owner of the file in git. |
|
git_repository
The git repository. |
|
git_sha
The SHA of the file in git. |
|
git_url
The git URL. |
|
lat
The latitude of the province. |
|
long
The longitude of the province. |
|
note_en
Notes in English. |
|
note_it
Notes in Italian. |
|
province
The full name of the province. |
|
province_abbr
The abbreviation of the province’s name. |
|
province_code
The code of the region. |
|
region
The full name of the region. |
|
region_code
The code of the region. |
|
total_cases
The total number of positive cases for the province. |
italy_regional_daily
| Replication Method : |
Key-based Incremental |
Replication Key :
|
git_last_modified |
|
Primary Key :
|
git_path : __sdc_row_number |
Official docs : |
The italy_regional_daily table contains statistics for Italian regions, segmented by day.
|
git_path
The path to the file in git. |
|
__sdc_row_number
The number of the row in the source CSV. |
|
git_last_modified
The date the git file was last modified. |
|
country
The country reference code. |
|
date
The date. |
|
date_of_notification
The date of the record. |
|
datetime
The datetime of the record. |
|
deaths
The number of recorded deaths. |
|
discharged_recovered
The number of recovered patients. |
|
git_file_name
The name of the source git file. |
|
git_html_url
The URL of the source git html. |
|
git_owner
The owner of the file in git. |
|
git_repository
The git repository. |
|
git_sha
The SHA of the file in git. |
|
git_url
The git URL. |
|
home_isolation
The number of people in home isolation. |
|
hospitalized_with_symptoms
The number of people hospitalized with symptoms. |
|
intensive_care
The number of people hospitalized in intensive care. |
|
lat
The latitude of the region. |
|
long
The longitude of the region. |
|
new_currently_positive
The new amount of current positive cases, calculated as the current day’s |
|
note_en
Notes in English. |
|
note_it
Notes in Italian. |
|
region
The name of the region. |
|
region_code
The reference code of the region. |
|
tested
The number of tested cases. |
|
total_cases
The total number of cases. |
|
total_currently_positive
The total number of currently positive cases. |
|
total_hospitalized
The total number of hospitalized cases. |
jh_csse_daily
| Replication Method : |
Key-based Incremental |
Replication Key :
|
git_last_modified |
|
Primary Key :
|
git_path : __sdc_row_number |
Official docs : |
The jh_csse_daily table contains data collected by Johns Hopkins CSSE.
|
git_path
The path to the file in git. |
|
__sdc_row_number
The number of the row in the source CSV. |
|
git_last_modified
The date the git file was last modified. |
|
active
|
|
admin_area
|
|
combined_key
|
|
confirmed
|
|
country_region
|
|
country_region_cleansed
|
|
date
The date. |
|
datetime
The datetime of the record. |
|
deaths
|
|
fips
The Federal Information Processing Standard state code. |
|
git_file_name
The name of the source git file. |
|
git_html_url
The URL of the source git html. |
|
git_owner
The owner of the file in git. |
|
git_repository
The git repository. |
|
git_sha
The SHA of the file in git. |
|
git_url
The git URL. |
|
is_a_cruise
|
|
last_update
|
|
latitude
|
|
longitude
|
|
province_state
|
|
province_state_cleansed
|
|
recovered
|
neherlab_case_counts
| Replication Method : |
Key-based Incremental |
Replication Key :
|
git_last_modified |
|
Primary Key :
|
git_path : __sdc_row_number |
Official docs : |
The neherlab_case_counts table contains Neherlab Scenarios Data from Neherlab Biozentrum, Center for Computational Biology.
|
git_path
The path to the file in git. |
|
__sdc_row_number
The number of the row in the source CSV. |
|
git_last_modified
The date the git file was last modified. |
|
cases
|
|
date
The date. |
|
datetime
|
|
deaths
|
|
git_file_name
The name of the source git file. |
|
git_html_url
The URL of the source git html. |
|
git_owner
The owner of the file in git. |
|
git_repository
The git repository. |
|
git_sha
The SHA of the file in git. |
|
git_url
The git URL. |
|
hospitalized
The number of recorded hospitalized cases for the day. |
|
icu
|
|
location
|
|
recovered
|
neherlab_country_codes
| Replication Method : |
Key-based Incremental |
Replication Key :
|
git_last_modified |
|
Primary Key :
|
__sdc_row_number |
Official docs : |
The neherlab_country_codes table contains Neherlab Scenarios Data from Neherlab Biozentrum, Center for Computational Biology.
Note: The source file for this table is a single file that updates on a daily basis. When Stitch replicates this table, it will replicate the entire contents of the file, but only if the file has been modified since the integration’s last replication job.
|
__sdc_row_number
The number of the row in the source CSV. |
|
git_last_modified
The date the git file was last modified. |
|
alpha_2
|
|
alpha_3
|
|
country_code
|
|
git_file_name
The name of the source git file. |
|
git_html_url
The URL of the source git html. |
|
git_path
The path to the file in git. |
|
git_owner
The owner of the file in git. |
|
git_repository
The git repository. |
|
git_sha
The SHA of the file in git. |
|
git_url
The git URL. |
|
intermediate_region
|
|
intermediate_region_code
|
|
iso_3166_2
|
|
name
|
|
region
|
|
region_code
|
|
sub_region
|
|
sub_region_code
|
neherlab_icu_capacity
| Replication Method : |
Key-based Incremental |
Replication Key :
|
git_last_modified |
|
Primary Key :
|
git_path : __sdc_row_number |
Official docs : |
The neherlab_icu_capacity table contains Neherlab Scenarios Data from Neherlab Biozentrum, Center for Computational Biology.
Note: The source file for this table is a single file that updates on a daily basis. When Stitch replicates this table, it will replicate the entire contents of the file, but only if the file has been modified since the integration’s last replication job.
|
git_path
The path to the file in git. |
|
__sdc_row_number
The number of the row in the source CSV. |
|
git_last_modified
The date the git file was last modified. |
|
country
|
|
git_file_name
The name of the source git file. |
|
git_html_url
The URL of the source git html. |
|
git_last_modified
The date the git file was last modified. |
|
git_owner
The owner of the file in git. |
|
git_repository
The git repository. |
|
git_sha
The SHA of the file in git. |
|
git_url
The git URL. |
|
acute_care
|
|
acute_care_per_100k
|
|
imcu
|
|
icu
|
|
critical_care
|
|
critical_care_per_100k
|
|
percent_of_total
|
|
gdp
|
neherlab_population
| Replication Method : |
Key-based Incremental |
Replication Key :
|
git_last_modified |
|
Primary Key :
|
git_path : __sdc_row_number |
Official docs : |
The neherlab_population table contains Neherlab Scenarios Data from Neherlab Biozentrum, Center for Computational Biology.
Note: The source file for this table is a single file that updates on a daily basis. When Stitch replicates this table, it will replicate the entire contents of the file, but only if the file has been modified since the integration’s last replication job.
|
git_path
The path to the file in git. |
|
__sdc_row_number
The number of the row in the source CSV. |
|
git_last_modified
The date the git file was last modified. |
|
country
|
|
git_file_name
The name of the source git file. |
|
git_html_url
The URL of the source git html. |
|
git_last_modified
The date the git file was last modified. |
|
git_owner
The owner of the file in git. |
|
git_repository
The git repository. |
|
git_sha
The SHA of the file in git. |
|
git_url
The git URL. |
|
hemisphere
|
|
hospital_beds
|
|
icu_beds
|
|
imports_per_day
|
|
name
|
|
population
|
|
suspected_cases_mar_1st
|
nytimes_us_counties
| Replication Method : |
Key-based Incremental |
Replication Key :
|
git_last_modified |
|
Primary Key :
|
__sdc_row_number |
Official docs : |
The nytimes_us_counties table contains data
Note: The source file for this table is a single file that updates on a daily basis. When Stitch replicates this table, it will replicate the entire contents of the file, but only if the file has been modified since the integration’s last replication job.
|
__sdc_row_number
The number of the row in the source CSV. |
|
git_last_modified
The date the git file was last modified. |
|
cases
The number of cases. Note: The source considers |
|
county
The county. |
|
date
The date. |
|
datetime
The datetime of the record. |
|
deaths
The number deaths. |
|
fips
The Federal Information Processing Standard state code. |
|
git_file_name
The name of the source git file. |
|
git_html_url
The URL of the source git html. |
|
git_owner
The owner of the file in git. |
|
git_path
The path to the file in git. |
|
git_repository
The git repository. |
|
git_sha
The SHA of the file in git. |
|
git_url
The git URL. |
|
state
The full name of the US state. |
|
state_code
The state’s reference code. |
nytimes_us_states
| Replication Method : |
Full Table |
Primary Key :
|
__sdc_row_number |
| Official docs : | |||
The nytimes_us_states table contains data collected by Johns Hopkins CSSE.
Note: The source file for this table is a single file that updates on a daily basis. When Stitch replicates this table, it will replicate the entire contents of the file, but only if the file has been modified since the integration’s last replication job.
|
__sdc_row_number
The number of the row in the source CSV. |
|
git_last_modified
The date the git file was last modified. |
|
cases
The number of cases. Note: The source considers |
|
date
The date. |
|
datetime
The datetime for the record. |
|
deaths
The number of deaths. |
|
fips
The Federal Information Processing Standard state code. |
|
git_file_name
The name of the source git file. |
|
git_html_url
The URL of the source git html. |
|
git_owner
The owner of the file in git. |
|
git_path
The path to the file in git. |
|
git_repository
The git repository. |
|
git_sha
The SHA of the file in git. |
|
git_url
The git URL. |
|
state
The full name of the US state. |
|
state_code
The state’s reference code. |
| Related | Troubleshooting |
Questions? Feedback?
Did this article help? If you have questions or feedback, feel free to submit a pull request with your suggestions, open an issue on GitHub, or reach out to us.