﻿_id	Field Name	Field Description
1	DATE	Date of the event, being equal to the specimen collection date, or if the collection date is unknown, investigation starting date for positive cases; the date of death for deaths; the coalesce of specimen date and report date for testings (if specimen collected date is unknown, use report date), respectively.
2	COVID_TEST	Total number of testings(i.e. number of new people tested on the date. Indiana residents only.
3	DAILY_DELTA_TESTS	The number of most recent(i.e lastest report) new testings that are reported into the testing pool. The date of specimen collected is typically earlier than the report date. Column is NULL after 3/30/22 because of a change in reporting requirements
4	DAILY_BASE_TESTS	The number of tests from the last report. Records might be removed due to information correctness. Column is NULL after 3/30/22 because of a change in reporting requirements
5	COVID_DEATHS	Total number of deaths on the date.
6	DAILY_DELTA_DEATHS	The number of most recent(i.e lastest report) new positive cases that are reported into the positive case pool. The investigation starting date could be earlier than the report date due to necessary process. Column is NULL after 3/30/22 because of a change in reporting requirements
7	DAILY_BASE_DEATHS	The number of positive cases from the last report. Records might be removed due to information correctness. Column is NULL after 3/30/22 because of a change in reporting requirements
8	COVID_COUNT	Total number of positive cases (i.e. number of patient who started investigation for their positive report) on the date.
9	DAILY_DELTA_CASES	The number of most recent(i.e lastest report) new death cases that are reported into the death case pool. The date of death could be earlier than the report date due to necessary process and confirmation. Column is NULL after 3/30/22 because of a change in reporting requirements
10	DAILY_BASE_CASES	The number of deaths from the last report. Records might be removed due to information correctness. Column is NULL after 3/30/22 because of a change in reporting requirements
11	COVID_COUNT_CUMSUM	The cumulative number of positive cases as of the report date.
12	COVID_DEATHS_CUMSUM	The cumulative number of deaths as of the report date.
13	COVID_TEST_CUMSUM	The cumulative number of tests as of the report date.
14	POSITIVITY_RATE_ALL_TESTS	Total positivity percentage for entire state, by day. Measured by all positive tests divided by all tests administered. Column is NULL after 3/30/22 because of a change in reporting requirements. For further details on positivity see https://www.coronavirus.in.gov/map/positive-test-rate.pdf
15	COVID_COUNT_BY_SPECIMEN_COLLECTION_DATE	Total number of confirmed cases grouped by their lab specimen collection date. In instances where the specimen collection date is not provided, the date the specimen result is recorded in the ISDH system is used.
