us-states

Table actions
Big Local News snapshots this data daily from https://github.com/nytimes/covid-19-data. This is time series data for U.S. confirmed cases and deaths down to the county level. There are three CSV files released once a day: national-level data, state-level data and county-level data. Each file contains date, county/state name, FIPS code, number of confirmed cases, number of deaths going back to January 21. All data is gathered by New York Times reporters from state and local health departments or official government announcements. The data is updated once a day in the morning, usually around 8 a.m. EDT, with a full day’s worth of data from the day before. Please cite the New York Times as described in the README and check terms of use.

Data source: Big Local News · About: big-local-datasette

19,979 rows sorted by state descending

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Suggested facets: date (date)

Link rowid date state ▲ fips cases deaths
539 539 2020-03-11 Wyoming 56 1 0
586 586 2020-03-12 Wyoming 56 1 0
637 637 2020-03-13 Wyoming 56 2 0
689 689 2020-03-14 Wyoming 56 3 0
742 742 2020-03-15 Wyoming 56 3 0
795 795 2020-03-16 Wyoming 56 10 0
849 849 2020-03-17 Wyoming 56 15 0
903 903 2020-03-18 Wyoming 56 17 0
957 957 2020-03-19 Wyoming 56 18 0
1011 1011 2020-03-20 Wyoming 56 22 0
1065 1065 2020-03-21 Wyoming 56 24 0
1119 1119 2020-03-22 Wyoming 56 26 0
1173 1173 2020-03-23 Wyoming 56 28 0
1227 1227 2020-03-24 Wyoming 56 37 0
1281 1281 2020-03-25 Wyoming 56 49 0
1335 1335 2020-03-26 Wyoming 56 56 0
1389 1389 2020-03-27 Wyoming 56 74 0
1444 1444 2020-03-28 Wyoming 56 85 0
1499 1499 2020-03-29 Wyoming 56 88 0
1554 1554 2020-03-30 Wyoming 56 96 0
1609 1609 2020-03-31 Wyoming 56 121 0
1664 1664 2020-04-01 Wyoming 56 138 0
1719 1719 2020-04-02 Wyoming 56 154 0
1774 1774 2020-04-03 Wyoming 56 167 0
1829 1829 2020-04-04 Wyoming 56 189 0
1884 1884 2020-04-05 Wyoming 56 200 0
1939 1939 2020-04-06 Wyoming 56 213 0
1994 1994 2020-04-07 Wyoming 56 221 0
2049 2049 2020-04-08 Wyoming 56 230 0
2104 2104 2020-04-09 Wyoming 56 303 0
2159 2159 2020-04-10 Wyoming 56 320 0
2214 2214 2020-04-11 Wyoming 56 343 0
2269 2269 2020-04-12 Wyoming 56 364 0
2324 2324 2020-04-13 Wyoming 56 373 1
2379 2379 2020-04-14 Wyoming 56 373 1
2434 2434 2020-04-15 Wyoming 56 392 2
2489 2489 2020-04-16 Wyoming 56 393 2
2544 2544 2020-04-17 Wyoming 56 401 2
2599 2599 2020-04-18 Wyoming 56 412 2
2654 2654 2020-04-19 Wyoming 56 422 2
2709 2709 2020-04-20 Wyoming 56 426 2
2764 2764 2020-04-21 Wyoming 56 442 6
2819 2819 2020-04-22 Wyoming 56 447 6
2874 2874 2020-04-23 Wyoming 56 453 7
2929 2929 2020-04-24 Wyoming 56 473 7
2984 2984 2020-04-25 Wyoming 56 477 7
3039 3039 2020-04-26 Wyoming 56 502 7
3094 3094 2020-04-27 Wyoming 56 520 7
3149 3149 2020-04-28 Wyoming 56 536 7
3204 3204 2020-04-29 Wyoming 56 544 7
3259 3259 2020-04-30 Wyoming 56 559 7
3314 3314 2020-05-01 Wyoming 56 566 7
3369 3369 2020-05-02 Wyoming 56 579 7
3424 3424 2020-05-03 Wyoming 56 586 7
3479 3479 2020-05-04 Wyoming 56 596 7
3534 3534 2020-05-05 Wyoming 56 604 7
3589 3589 2020-05-06 Wyoming 56 631 7
3644 3644 2020-05-07 Wyoming 56 635 7
3699 3699 2020-05-08 Wyoming 56 644 7
3754 3754 2020-05-09 Wyoming 56 653 7
3809 3809 2020-05-10 Wyoming 56 662 7
3864 3864 2020-05-11 Wyoming 56 669 7
3919 3919 2020-05-12 Wyoming 56 675 7
3974 3974 2020-05-13 Wyoming 56 688 7
4029 4029 2020-05-14 Wyoming 56 701 7
4084 4084 2020-05-15 Wyoming 56 716 7
4139 4139 2020-05-16 Wyoming 56 741 7
4194 4194 2020-05-17 Wyoming 56 754 8
4249 4249 2020-05-18 Wyoming 56 766 10
4304 4304 2020-05-19 Wyoming 56 776 10
4359 4359 2020-05-20 Wyoming 56 787 11
4414 4414 2020-05-21 Wyoming 56 801 12
4469 4469 2020-05-22 Wyoming 56 803 12
4524 4524 2020-05-23 Wyoming 56 813 12
4579 4579 2020-05-24 Wyoming 56 813 12
4634 4634 2020-05-25 Wyoming 56 843 12
4689 4689 2020-05-26 Wyoming 56 850 13
4744 4744 2020-05-27 Wyoming 56 860 14
4799 4799 2020-05-28 Wyoming 56 876 15
4854 4854 2020-05-29 Wyoming 56 891 15
4909 4909 2020-05-30 Wyoming 56 898 16
4964 4964 2020-05-31 Wyoming 56 903 16
5019 5019 2020-06-01 Wyoming 56 910 17
5074 5074 2020-06-02 Wyoming 56 912 17
5129 5129 2020-06-03 Wyoming 56 915 17
5184 5184 2020-06-04 Wyoming 56 921 17
5239 5239 2020-06-05 Wyoming 56 933 17
5294 5294 2020-06-06 Wyoming 56 939 17
5349 5349 2020-06-07 Wyoming 56 947 17
5404 5404 2020-06-08 Wyoming 56 960 17
5459 5459 2020-06-09 Wyoming 56 970 17
5514 5514 2020-06-10 Wyoming 56 980 18
5569 5569 2020-06-11 Wyoming 56 1009 18
5624 5624 2020-06-12 Wyoming 56 1027 18
5679 5679 2020-06-13 Wyoming 56 1050 18
5734 5734 2020-06-14 Wyoming 56 1060 18
5789 5789 2020-06-15 Wyoming 56 1079 18
5844 5844 2020-06-16 Wyoming 56 1089 18
5899 5899 2020-06-17 Wyoming 56 1114 18
5954 5954 2020-06-18 Wyoming 56 1144 18

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE [us-states] (
   [date] TEXT,
   [state] TEXT,
   [fips] INTEGER,
   [cases] INTEGER,
   [deaths] INTEGER
);