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

Singer Community

Stitch plan

Standard

API availability

Available

Singer GitHub repository

singer-io/tap-covid-19

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

  1. Sign into your GitHub account.
  2. Click the User menu (your icon) > Settings.
  3. Click Developer settings in the navigation on the left side of the page.
  4. Click Personal access tokens.
  5. On the Personal access tokens page, click the Generate new token button. If prompted, enter your password.
  6. In the Description field, enter stitch. This will allow you to easily identify what application is using the token.
  7. In the Select Scopes section, check the repo option:

    Highlighted repo scopes on the GitHub Personal Access Tokens page

    Note: While these are full permissions, Stitch will only ever read your data. The repo scope is required due to how GitHub structures permissions.

  8. Click the Generate token button.
  9. 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

  1. Sign into your Stitch account.
  2. On the Stitch Dashboard page, click the Add Integration button.

  3. Click the COVID-19 icon.

  4. 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_data in the destination. Note: Schema names cannot be changed after you save the integration.

  5. 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:

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:

  1. Individual tables and columns

  2. All tables and columns

Click the tabs to view instructions for each selection method.

  1. In the integration’s Tables to Replicate tab, locate a table you want to replicate.
  2. To track a table, click the checkbox next to the table’s name. A blue checkmark means the table is set to replicate.

  3. To track a column, click the checkbox next to the column’s name. A blue checkmark means the column is set to replicate.

  4. Repeat this process for all the tables and columns you want to replicate.
  5. When finished, click the Finalize Your Selections button at the bottom of the screen to save your selections.
  1. Click into the integration from the Stitch Dashboard page.
  2. Click the Tables to Replicate tab.

  3. In the list of tables, click the box next to the Table Names column.
  4. In the menu that displays, click Track all Tables and Fields:

    The Track all Tables and Fields menu in the Tables to Replicate tab

  5. 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.

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

Replication Method :

Key-based Incremental

Replication Key :

git_last_modified

Primary Key :

__sdc_row_number

Official docs :

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
INTEGER

The number of the row in the source CSV.

git_last_modified
DATE-TIME

The date the git file was last modified.

date
DATE

The date.

date_checked
DATE-TIME

death
INTEGER

The number of deaths recorded for the day.

death_increase
INTEGER

The increase in recorded deaths from the previous day.

git_file_name
STRING

The name of the source git file.

git_html_url
STRING

The URL of the source git html.

git_owner
STRING

The owner of the file in git.

git_path
STRING

The path to the file in git.

git_repository
STRING

The git repository.

git_sha
STRING

The SHA of the file in git.

git_url
STRING

The git URL.

hospitalized
INTEGER

The number of recorded hospitalized cases for the day.

hospitalized_increase
INTEGER

The increase in recorded hospitalizations from the previous day.

negative
INTEGER

The number of negative tests recorded for the day.

negative_increase
INTEGER

The increase in recorded negative tests from the previous day.

pending
INTEGER

The number of pending tests for the day.

pos_neg
INTEGER

The sum of positive + negative.

positive
INTEGER

The number of recorded positive tests for the day.

positive_increase
INTEGER

The increase in recorded positive tests from the previous day.

states
INTEGER

The number of states included in the day’s statistics.

total
INTEGER

The sum of positive + negative + pending.

total_test_results
INTEGER

The total number of test results recorded for the day.

total_test_results_increase
INTEGER

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 :

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
INTEGER

The number of the row in the source CSV.

git_last_modified
DATE-TIME

The date the git file was last modified.

county
STRING

The name of the county. For example: Westchester

geo_id
STRING

git_file_name
STRING

The name of the source git file.

git_html_url
STRING

The URL of the source git html.

git_last_modified
DATE-TIME

The date the git file was last modified.

git_owner
STRING

The owner of the file in git.

git_path
STRING

The path to the file in git.

git_repository
STRING

The git repository.

git_sha
STRING

The SHA of the file in git.

git_url
STRING

The git URL.

pop_density
NUMBER

The population density for the county.

population
INTEGER

The total population for the county.

state
STRING

The abbreviated state code for the state. For example: NY

state_name
STRING

The name of the state. For example: New York


c19_trk_us_population_states

Replication Method :

Key-based Incremental

Replication Key :

git_last_modified

Primary Key :

__sdc_row_number

Official docs :

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
INTEGER

The number of the row in the source CSV.

git_last_modified
DATE-TIME

The date the git file was last modified.

geo_id
STRING

git_file_name
STRING

The name of the source git file.

git_html_url
STRING

The URL of the source git html.

git_last_modified
DATE-TIME

The date the git file was last modified.

git_owner
STRING

The owner of the file in git.

git_path
STRING

The path to the file in git.

git_repository
STRING

The git repository.

git_sha
STRING

The SHA of the file in git.

git_url
STRING

The git URL.

pop_density
NUMBER

The population density for the state.

population
INTEGER

The total population for the state.

state
STRING

The abbreviated state code for the state. For example: NY

state_name
STRING

The name of the state. For example: New York


c19_trk_us_population_states_age_groups

Replication Method :

Key-based Incremental

Replication Key :

git_last_modified

Primary Key :

__sdc_row_number

Official docs :

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
INTEGER

The number of the row in the source CSV.

git_last_modified
DATE-TIME

The date the git file was last modified.

agegroup
STRING

The age group.

geo_id
STRING

git_file_name
STRING

The name of the source git file.

git_html_url
STRING

The URL of the source git html.

git_last_modified
DATE-TIME

The date the git file was last modified.

git_owner
STRING

The owner of the file in git.

git_path
STRING

The path to the file in git.

git_repository
STRING

The git repository.

git_sha
STRING

The SHA of the file in git.

git_url
STRING

The git URL.

pct_pop
NUMBER

population
INTEGER

The population for the state.

state
STRING

The abbreviated state code for the state. For example: NY

state_name
STRING

The name of the state. For example: New York


c19_trk_us_states_acs_health_insurance

Replication Method :

Key-based Incremental

Replication Key :

git_last_modified

Primary Key :

__sdc_row_number

Official docs :

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
INTEGER

The number of the row in the source CSV.

git_last_modified
DATE-TIME

The date the git file was last modified.

acs_variable
STRING

age_group
STRING

The age group.

concept
STRING

coverage_type
STRING

The type of health insurance coverage.

employed
STRING

estimate
NUMBER

estimate_type
STRING

geo_id
STRING

git_file_name
STRING

The name of the source git file.

git_html_url
STRING

The URL of the source git html.

git_last_modified
DATE-TIME

The date the git file was last modified.

git_owner
STRING

The owner of the file in git.

git_path
STRING

The path to the file in git.

git_repository
STRING

The git repository.

git_sha
STRING

The SHA of the file in git.

git_url
STRING

The git URL.

label
STRING

labor_force
STRING

margin_of_error
NUMBER

state
STRING

The abbreviated state code for the state. For example: NY

state_name
STRING

The name of the state. For example: New York


c19_trk_us_states_current

Replication Method :

Key-based Incremental

Replication Key :

git_last_modified

Primary Key :

__sdc_row_number

Official docs :

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
INTEGER

The number of the row in the source CSV.

git_last_modified
DATE-TIME

The date the git file was last modified.

check_time_et
STRING

commercial_score
INTEGER

+1 for reporting all commercial tests.

date_checked
DATE-TIME

The date and time when the data was last checked.

date_modified
DATE-TIME

The date the record was last modified.

death
INTEGER

The cumulative number of deaths recorded for the state.

fips
STRING

Federal Information Processing Standard state code.

git_file_name
STRING

The name of the source git file.

git_html_url
STRING

The URL of the source git html.

git_last_modified
DATE-TIME

The date the git file was last modified.

git_owner
STRING

The owner of the file in git.

git_path
STRING

The path to the file in git.

git_repository
STRING

The git repository.

git_sha
STRING

The SHA of the file in git.

git_url
STRING

The git URL.

grade
STRING

The letter grade, based on score. Refer to the COVID documentation for more info about how grades are caluclated.

hospitalized
INTEGER

The total cumulative number of people hospitalized.

last_update_et
STRING

negative
INTEGER

The total cumulative number of negative tests.

negative_regular_score
INTEGER

+1 for reporting negatives reliably.

notes
STRING

pending
INTEGER

The number of pending tests for the day.

positive
INTEGER

The total cumulative number of positive tests.

positive_score
INTEGER

+1 for reporting positives reliably.

score
INTEGER

The data quality grade for the state. Possible values are:

  • 4 - Corresponds to a grade of A
  • 3 - Corresponds to a grade of B
  • 2 - Corresponds to a grade of C
  • 1 - Corresponds to a grade of D

Refer to the COVID documentation for more info about how scores are caluclated.

state
STRING

The state or territory postal code abbreviation.

total
INTEGER

Deprecated. Equal to positive + negative + pending. Note: pending has been an unstable value and should not count in any totals.

total_test_results
INTEGER

The total number of test results, calculated as positive + negative.


c19_trk_us_states_daily

Replication Method :

Key-based Incremental

Replication Key :

git_last_modified

Primary Key :

__sdc_row_number

Official docs :

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
INTEGER

The number of the row in the source CSV.

git_last_modified
DATE-TIME

The date the git file was last modified.

date
DATE

The date.

date_checked
DATE-TIME

death
INTEGER

The total cumulative number of people that have died.

death_increase
INTEGER

The increase in recorded deaths from the previous day.

fips
STRING

The Federal Information Processing Standard state code.

git_file_name
STRING

The name of the source git file.

git_html_url
STRING

The URL of the source git html.

git_last_modified
DATE-TIME

The date the git file was last modified.

git_owner
STRING

The owner of the file in git.

git_path
STRING

The path to the file in git.

git_repository
STRING

The git repository.

git_sha
STRING

The SHA of the file in git.

git_url
STRING

The git URL.

hospitalized
INTEGER

The number of recorded hospitalized cases for the day.

hospitalized_increase
INTEGER

The increase in recorded hospitalizations from the previous day.

negative
INTEGER

The total cumulative negative test results.

negative_increase
INTEGER

The increase in recorded negative tests from the previous day.

pending
INTEGER

The number of tests that have been submitted to a lab but no results have been reported yet.

positive
INTEGER

The number of total cumulative positive test results.

positive_increase
INTEGER

The increase in recorded positive tests from the previous day.

state
STRING

The state or territory postal code abbreviation.

total
INTEGER

Deprecated. Equal to positive + negative + pending. Note: pending has been an unstable value and should not count in any totals.

total_test_results
INTEGER

The total number of test results

total_test_results_increase
INTEGER

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 :

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
INTEGER

The number of the row in the source CSV.

git_last_modified
DATE-TIME

The date the git file was last modified.

covid19_site
STRING

The webpage dedicated to making results available to the public.

covid19_site_old
STRING

covid19_site_secondary
STRING

An informational webpage.

fips
STRING

The Federal Information Processing Standard state code.

git_file_name
STRING

The name of the source git file.

git_html_url
STRING

The URL of the source git html.

git_last_modified
DATE-TIME

The date the git file was last modified.

git_owner
STRING

The owner of the file in git.

git_path
STRING

The path to the file in git.

git_repository
STRING

The git repository.

git_sha
STRING

The SHA of the file in git.

git_url
STRING

The git URL.

name
STRING

The full state or territory name.

notes
STRING

Notes about the information available and how it’s collected or recorded.

pui
STRING

Person Under Investigation; it is meant to capture positive, negative, and pending test results.

pum
STRING

Person Under Monitoring. Note: The source doesn’t track these numbers as they are reported less consistently across states.

state
STRING

The state or territory postal code abbreviation.

twitter
STRING

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 :

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
INTEGER

The number of the row in the source CSV.

git_last_modified
DATE-TIME

The date the git file was last modified.

for_profit
NUMBER

The number of hospital beds for for-profit hospitals.

git_file_name
STRING

The name of the source git file.

git_html_url
STRING

The URL of the source git html.

git_last_modified
DATE-TIME

The date the git file was last modified.

git_owner
STRING

The owner of the file in git.

git_path
STRING

The path to the file in git.

git_repository
STRING

The git repository.

git_sha
STRING

The SHA of the file in git.

git_url
STRING

The git URL.

non_profit
NUMBER

The number of hospital beds for non-profit hospitals.

state
STRING

The state or territory postal code abbreviation.

state_local_government
NUMBER

The number of hospital beds for state/local government hospitals.

state_name
STRING

The full name of the state or territory.

total
NUMBER

The total number of hospital beds, calculated by for_profit + non_profit + state_local_government.


Replication Method :

Key-based Incremental

Replication Key :

git_last_modified

Primary Key :

git_path : __sdc_row_number

Official docs :

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
STRING

The path to the file in git.

__sdc_row_number
INTEGER

The number of the row in the source CSV.

git_last_modified
DATE-TIME

The date the git file was last modified.

cases
NUMBER

The number of cases by the specified datetime.

cases_100k_pop
NUMBER

The number of cases per 100k population. When looking at this value, note that:

  • Germany did not track this in the beginning, thus there may be missing values.

cases_lower
INTEGER

cases_upper
INTEGER

country
STRING

The country code.

date
DATE

The date.

datetime
DATE-TIME

The local datetime of the record.

deaths
NUMBER

The number of deaths. When looking at this value, note that:

  • Austria started tracking this on 2020-03-13
  • Germany did not track this in the beginning, thus there may be missing values.

git_file_name
STRING

The name of the source git file.

git_html_url
STRING

The URL of the source git html.

git_owner
STRING

The owner of the file in git.

git_repository
STRING

The git repository.

git_sha
STRING

The SHA of the file in git.

git_url
STRING

The git URL.

hospitalized
NUMBER

The number of hospitalized patients.

intensive_care
INTEGER

The number of patients in intensive care.

lau
STRING

  • Netherlands: LAU (city).

nuts_1
STRING

Applicable to Germany. NUTS 1 (states) in Germany.

nuts_2
STRING

  • Austria: NUTS 2 administrative divisions (states) in Austria.
  • France: Local provinces or oversea authorities in France. Oversea and Metropolis are also added as conditional sum.
  • Italy: NUTS 2 (regions).
  • Poland: NUTS 2 (provinces) in PL or sum as the total.
  • Switzerland: NUTS 2 (regions).

nuts_3
STRING

  • Czechia: NUTS 3 (regions, Kraje) in Czechia (Czech Republic).
  • England, Scotland, Wales: Local authorities in the city, town, borough, etc.
  • Italy: NUTS 3 (provinces).
  • Norway: NUTS 3 (counties).
  • Sweden: NUTS 3 (counties) in Sweden.

percent
NUMBER

The percent of cases by the specified datetime.

population
NUMBER

The population of the city.

quarantine
INTEGER

The number of quarantined patients.

recovered
INTEGER

The number of recovered patients. When looking at this value, note that:

  • Austria started tracking this on 2020-03-13.

tests
INTEGER


Replication Method :

Key-based Incremental

Replication Key :

git_last_modified

Primary Key :

git_path : __sdc_row_number

Official docs :

Official Docs

The eu_ecdc_daily table contains statistics reported to the European Centre for Disease Prevention and Control, segmented by day.

git_path
STRING

The path to the file in git.

__sdc_row_number
INTEGER

The number of the row in the source CSV.

git_last_modified
DATE-TIME

The date the git file was last modified.

cases
NUMBER

The number of cases.

country
STRING

The country code.

date
DATE

The date.

datetime
DATE-TIME

The local datetime of the record.

deaths
NUMBER

The number of deaths.

git_file_name
STRING

The name of the source git file.

git_html_url
STRING

The URL of the source git html.

git_owner
STRING

The owner of the file in git.

git_repository
STRING

The git repository.

git_sha
STRING

The SHA of the file in git.

git_url
STRING

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 :

Official Docs

The italy_national_daily table contains statistics for Italy, segmented by day.

git_path
STRING

The path to the file in git.

__sdc_row_number
INTEGER

The number of the row in the source CSV.

git_last_modified
DATE-TIME

The date the git file was last modified.

country
STRING

The country code.

date
DATE

The date.

date_of_notification
DATE-TIME

The date of the record.

datetime
DATE-TIME

The datetime of the record.

deaths
INTEGER

The number of recorded deaths.

discharged_recovered
INTEGER

The number of recovered patients.

git_file_name
STRING

The name of the source git file.

git_html_url
STRING

The URL of the source git html.

git_owner
STRING

The owner of the file in git.

git_repository
STRING

The git repository.

git_sha
STRING

The SHA of the file in git.

git_url
STRING

The git URL.

home_isolation
INTEGER

The number of people in home isolation.

hospitalized_with_symptoms
INTEGER

The number of people hospitalized with symptoms.

intensive_care
INTEGER

The number of people hospitalized in intensive care.

new_currently_positive
INTEGER

The new amount of current positive cases, calculated as the current day’s total_currently_positive - previous day’s total_currently_positive

note_en
STRING

Notes in English.

note_it
STRING

Notes in Italian.

tested
INTEGER

The number of tested cases.

total_cases
INTEGER

The total number of cases.

total_currently_positive
INTEGER

The total number of currently positive cases.

total_hospitalized
INTEGER

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 :

Official Docs

The italy_provincial_daily table contains statistics for Italian provinces, segmented by day.

git_path
STRING

The path to the file in git.

__sdc_row_number
INTEGER

The number of the row in the source CSV.

git_last_modified
DATE-TIME

The date the git file was last modified.

country
STRING

The country reference code.

date
DATE

The date.

date_of_notification
DATE-TIME

datetime
DATE-TIME

git_file_name
STRING

The name of the source git file.

git_html_url
STRING

The URL of the source git html.

git_owner
STRING

The owner of the file in git.

git_repository
STRING

The git repository.

git_sha
STRING

The SHA of the file in git.

git_url
STRING

The git URL.

lat
NUMBER

The latitude of the province.

long
NUMBER

The longitude of the province.

note_en
STRING

Notes in English.

note_it
STRING

Notes in Italian.

province
STRING

The full name of the province.

province_abbr
STRING

The abbreviation of the province’s name.

province_code
STRING

The code of the region.

region
STRING

The full name of the region.

region_code
STRING

The code of the region.

total_cases
INTEGER

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 :

Official Docs

The italy_regional_daily table contains statistics for Italian regions, segmented by day.

git_path
STRING

The path to the file in git.

__sdc_row_number
INTEGER

The number of the row in the source CSV.

git_last_modified
DATE-TIME

The date the git file was last modified.

country
STRING

The country reference code.

date
DATE

The date.

date_of_notification
DATE-TIME

The date of the record.

datetime
DATE-TIME

The datetime of the record.

deaths
INTEGER

The number of recorded deaths.

discharged_recovered
INTEGER

The number of recovered patients.

git_file_name
STRING

The name of the source git file.

git_html_url
STRING

The URL of the source git html.

git_owner
STRING

The owner of the file in git.

git_repository
STRING

The git repository.

git_sha
STRING

The SHA of the file in git.

git_url
STRING

The git URL.

home_isolation
INTEGER

The number of people in home isolation.

hospitalized_with_symptoms
INTEGER

The number of people hospitalized with symptoms.

intensive_care
INTEGER

The number of people hospitalized in intensive care.

lat
NUMBER

The latitude of the region.

long
NUMBER

The longitude of the region.

new_currently_positive
INTEGER

The new amount of current positive cases, calculated as the current day’s total_currently_positive - previous day’s total_currently_positive

note_en
STRING

Notes in English.

note_it
STRING

Notes in Italian.

region
STRING

The name of the region.

region_code
STRING

The reference code of the region.

tested
INTEGER

The number of tested cases.

total_cases
INTEGER

The total number of cases.

total_currently_positive
INTEGER

The total number of currently positive cases.

total_hospitalized
INTEGER

The total number of hospitalized cases.


Replication Method :

Key-based Incremental

Replication Key :

git_last_modified

Primary Key :

git_path : __sdc_row_number

Official docs :

Official Docs

The jh_csse_daily table contains data collected by Johns Hopkins CSSE.

git_path
STRING

The path to the file in git.

__sdc_row_number
INTEGER

The number of the row in the source CSV.

git_last_modified
DATE-TIME

The date the git file was last modified.

active
INTEGER

admin_area
STRING

combined_key
STRING

confirmed
INTEGER

country_region
STRING

country_region_cleansed
STRING

date
DATE

The date.

datetime
DATE-TIME

The datetime of the record.

deaths
INTEGER

fips
STRING

The Federal Information Processing Standard state code.

git_file_name
STRING

The name of the source git file.

git_html_url
STRING

The URL of the source git html.

git_owner
STRING

The owner of the file in git.

git_repository
STRING

The git repository.

git_sha
STRING

The SHA of the file in git.

git_url
STRING

The git URL.

is_a_cruise
BOOLEAN

last_update
DATE-TIME

latitude
NUMBER

longitude
NUMBER

province_state
STRING

province_state_cleansed
STRING

recovered
INTEGER


neherlab_case_counts

Replication Method :

Key-based Incremental

Replication Key :

git_last_modified

Primary Key :

git_path : __sdc_row_number

Official docs :

Official Docs

The neherlab_case_counts table contains Neherlab Scenarios Data from Neherlab Biozentrum, Center for Computational Biology.

git_path
STRING

The path to the file in git.

__sdc_row_number
INTEGER

The number of the row in the source CSV.

git_last_modified
DATE-TIME

The date the git file was last modified.

cases
INTEGER

date
DATE

The date.

datetime
DATE-TIME

deaths
INTEGER

git_file_name
STRING

The name of the source git file.

git_html_url
STRING

The URL of the source git html.

git_owner
STRING

The owner of the file in git.

git_repository
STRING

The git repository.

git_sha
STRING

The SHA of the file in git.

git_url
STRING

The git URL.

hospitalized
INTEGER

The number of recorded hospitalized cases for the day.

icu
INTEGER

location
STRING

recovered
INTEGER


neherlab_country_codes

Replication Method :

Key-based Incremental

Replication Key :

git_last_modified

Primary Key :

__sdc_row_number

Official docs :

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
INTEGER

The number of the row in the source CSV.

git_last_modified
DATE-TIME

The date the git file was last modified.

alpha_2
STRING

alpha_3
STRING

country_code
STRING

git_file_name
STRING

The name of the source git file.

git_html_url
STRING

The URL of the source git html.

git_path
STRING

The path to the file in git.

git_owner
STRING

The owner of the file in git.

git_repository
STRING

The git repository.

git_sha
STRING

The SHA of the file in git.

git_url
STRING

The git URL.

intermediate_region
STRING

intermediate_region_code
STRING

iso_3166_2
STRING

name
STRING

region
STRING

region_code
STRING

sub_region
STRING

sub_region_code
STRING


neherlab_icu_capacity

Replication Method :

Key-based Incremental

Replication Key :

git_last_modified

Primary Key :

git_path : __sdc_row_number

Official docs :

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
STRING

The path to the file in git.

__sdc_row_number
INTEGER

The number of the row in the source CSV.

git_last_modified
DATE-TIME

The date the git file was last modified.

country
STRING

git_file_name
STRING

The name of the source git file.

git_html_url
STRING

The URL of the source git html.

git_last_modified
DATE-TIME

The date the git file was last modified.

git_owner
STRING

The owner of the file in git.

git_repository
STRING

The git repository.

git_sha
STRING

The SHA of the file in git.

git_url
STRING

The git URL.

acute_care
INTEGER

acute_care_per_100k
INTEGER

imcu
INTEGER

icu
INTEGER

critical_care
INTEGER

critical_care_per_100k
INTEGER

percent_of_total
NUMBER

gdp
NUMBER


neherlab_population

Replication Method :

Key-based Incremental

Replication Key :

git_last_modified

Primary Key :

git_path : __sdc_row_number

Official docs :

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
STRING

The path to the file in git.

__sdc_row_number
INTEGER

The number of the row in the source CSV.

git_last_modified
DATE-TIME

The date the git file was last modified.

country
STRING

git_file_name
STRING

The name of the source git file.

git_html_url
STRING

The URL of the source git html.

git_last_modified
DATE-TIME

The date the git file was last modified.

git_owner
STRING

The owner of the file in git.

git_repository
STRING

The git repository.

git_sha
STRING

The SHA of the file in git.

git_url
STRING

The git URL.

hemisphere
STRING

hospital_beds
INTEGER

icu_beds
INTEGER

imports_per_day
NUMBER

name
STRING

population
STRING

suspected_cases_mar_1st
INTEGER


nytimes_us_counties

Replication Method :

Key-based Incremental

Replication Key :

git_last_modified

Primary Key :

__sdc_row_number

Official docs :

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
INTEGER

The number of the row in the source CSV.

git_last_modified
DATE-TIME

The date the git file was last modified.

cases
INTEGER

The number of cases. Note: The source considers confirmed cases as patients who test positive for the coronavirus. A case is confirmed when it is reported by a federal, state, territorial or local government agency. Additionally, cases are counted on the date they are first announced.

county
STRING

The county.

date
DATE

The date.

datetime
DATE-TIME

The datetime of the record.

deaths
INTEGER

The number deaths.

fips
STRING

The Federal Information Processing Standard state code.

git_file_name
STRING

The name of the source git file.

git_html_url
STRING

The URL of the source git html.

git_owner
STRING

The owner of the file in git.

git_path
STRING

The path to the file in git.

git_repository
STRING

The git repository.

git_sha
STRING

The SHA of the file in git.

git_url
STRING

The git URL.

state
STRING

The full name of the US state.

state_code
STRING

The state’s reference code.


nytimes_us_states

Replication Method :

Full Table

Primary Key :

__sdc_row_number

Official docs :

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
INTEGER

The number of the row in the source CSV.

git_last_modified
DATE-TIME

The date the git file was last modified.

cases
INTEGER

The number of cases. Note: The source considers confirmed cases as patients who test positive for the coronavirus. A case is confirmed when it is reported by a federal, state, territorial or local government agency. Additionally, cases are counted on the date they are first announced.

date
DATE

The date.

datetime
DATE-TIME

The datetime for the record.

deaths
INTEGER

The number of deaths.

fips
STRING

The Federal Information Processing Standard state code.

git_file_name
STRING

The name of the source git file.

git_html_url
STRING

The URL of the source git html.

git_owner
STRING

The owner of the file in git.

git_path
STRING

The path to the file in git.

git_repository
STRING

The git repository.

git_sha
STRING

The SHA of the file in git.

git_url
STRING

The git URL.

state
STRING

The full name of the US state.

state_code
STRING

The state’s reference code.



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.