us-counties-recent

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

94,127 rows sorted by fips

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Link rowid date county state fips ▼ cases deaths
91 91 2021-01-31 Unknown Alaska   236 0
181 181 2021-01-31 Unknown Arkansas   2907 0
316 316 2021-01-31 Unknown Connecticut   822 7
321 321 2021-01-31 Unknown Delaware   182 0
386 386 2021-01-31 Unknown Florida   3334 0
535 535 2021-01-31 Unknown Georgia   4222 10
551 551 2021-01-31 Unknown Guam   8556 130
692 692 2021-01-31 Unknown Illinois   0 106
884 884 2021-01-31 Unknown Iowa   1065 0
994 994 2021-01-31 Unknown Kansas   0 698
1178 1178 2021-01-31 Unknown Louisiana   423 0
1200 1200 2021-01-31 Unknown Maine   2 0
1225 1225 2021-01-31 Unknown Maryland   0 43
1242 1242 2021-01-31 Unknown Massachusetts   27356 8
1323 1323 2021-01-31 Unknown Michigan   0 23
1406 1406 2021-01-31 Unknown Minnesota   479 68
1549 1549 2021-01-31 Joplin Missouri   4575 94
1550 1550 2021-01-31 Kansas City Missouri   35622 440
1791 1791 2021-01-31 Unknown New Hampshire   1022 4
1812 1812 2021-01-31 Unknown New Jersey   1201 0
1846 1846 2021-01-31 Unknown New Mexico   3 0
1876 1876 2021-01-31 New York City New York   608862 27138
2055 2055 2021-01-31 Unknown North Dakota   26 25
2222 2222 2021-01-31 Unknown Oklahoma   134 0
2402 2402 2021-01-31 Unknown Puerto Rico   4297 1829
2414 2414 2021-01-31 Unknown Rhode Island   12392 73
2615 2615 2021-01-31 Unknown Tennessee   13454 152
2902 2902 2021-01-31 Unknown Utah   1468 3
2919 2919 2021-01-31 Unknown Vermont   12 0
3338 3338 2021-02-01 Unknown Alaska   246 0
3428 3428 2021-02-01 Unknown Arkansas   2913 0
3563 3563 2021-02-01 Unknown Connecticut   832 8
3568 3568 2021-02-01 Unknown Delaware   183 0
3633 3633 2021-02-01 Unknown Florida   3338 0
3782 3782 2021-02-01 Unknown Georgia   4268 10
3798 3798 2021-02-01 Unknown Guam   8577 130
3939 3939 2021-02-01 Unknown Illinois   0 6
4131 4131 2021-02-01 Unknown Iowa   1071 0
4241 4241 2021-02-01 Unknown Kansas   0 713
4425 4425 2021-02-01 Unknown Louisiana   428 0
4447 4447 2021-02-01 Unknown Maine   5 0
4472 4472 2021-02-01 Unknown Maryland   0 47
4489 4489 2021-02-01 Unknown Massachusetts   27487 8
4570 4570 2021-02-01 Unknown Michigan   0 24
4653 4653 2021-02-01 Unknown Minnesota   471 68
4796 4796 2021-02-01 Joplin Missouri   4588 94
4797 4797 2021-02-01 Kansas City Missouri   35700 440
5038 5038 2021-02-01 Unknown New Hampshire   1038 4
5059 5059 2021-02-01 Unknown New Jersey   1253 0
5093 5093 2021-02-01 Unknown New Mexico   1 0
5123 5123 2021-02-01 New York City New York   613480 27226
5302 5302 2021-02-01 Unknown North Dakota   28 25
5469 5469 2021-02-01 Unknown Oklahoma   137 0
5649 5649 2021-02-01 Unknown Puerto Rico   4321 1836
5661 5661 2021-02-01 Unknown Rhode Island   13910 92
5862 5862 2021-02-01 Unknown Tennessee   13302 153
6149 6149 2021-02-01 Unknown Utah   1220 2
6166 6166 2021-02-01 Unknown Vermont   9 0
6585 6585 2021-02-02 Unknown Alaska   239 0
6675 6675 2021-02-02 Unknown Arkansas   2845 0
6810 6810 2021-02-02 Unknown Connecticut   843 8
6815 6815 2021-02-02 Unknown Delaware   182 0
6880 6880 2021-02-02 Unknown Florida   3335 0
7029 7029 2021-02-02 Unknown Georgia   4042 10
7045 7045 2021-02-02 Unknown Guam   8579 130
7186 7186 2021-02-02 Unknown Illinois   0 21
7378 7378 2021-02-02 Unknown Iowa   1077 0
7488 7488 2021-02-02 Unknown Kansas   0 686
7672 7672 2021-02-02 Unknown Louisiana   416 0
7694 7694 2021-02-02 Unknown Maine   1 0
7719 7719 2021-02-02 Unknown Maryland   0 64
7736 7736 2021-02-02 Unknown Massachusetts   27733 8
7817 7817 2021-02-02 Unknown Michigan   0 24
7900 7900 2021-02-02 Unknown Minnesota   469 68
8043 8043 2021-02-02 Joplin Missouri   4613 96
8044 8044 2021-02-02 Kansas City Missouri   35760 454
8285 8285 2021-02-02 Unknown New Hampshire   1053 5
8306 8306 2021-02-02 Unknown New Jersey   1140 0
8369 8369 2021-02-02 New York City New York   617406 27298
8548 8548 2021-02-02 Unknown North Dakota   26 25
8715 8715 2021-02-02 Unknown Oklahoma   135 0
8895 8895 2021-02-02 Unknown Puerto Rico   4324 1846
8907 8907 2021-02-02 Unknown Rhode Island   14145 105
9108 9108 2021-02-02 Unknown Tennessee   13382 161
9395 9395 2021-02-02 Unknown Utah   1221 2
9412 9412 2021-02-02 Unknown Vermont   8 0
9831 9831 2021-02-03 Unknown Alaska   239 0
9921 9921 2021-02-03 Unknown Arkansas   2853 0
10056 10056 2021-02-03 Unknown Connecticut   845 8
10061 10061 2021-02-03 Unknown Delaware   178 0
10126 10126 2021-02-03 Unknown Florida   3340 0
10275 10275 2021-02-03 Unknown Georgia   4023 9
10291 10291 2021-02-03 Unknown Guam   8587 130
10432 10432 2021-02-03 Unknown Illinois   0 35
10624 10624 2021-02-03 Unknown Iowa   1083 0
10734 10734 2021-02-03 Unknown Kansas   0 725
10918 10918 2021-02-03 Unknown Louisiana   418 0
10940 10940 2021-02-03 Unknown Maine   7 0
10965 10965 2021-02-03 Unknown Maryland   0 46
10982 10982 2021-02-03 Unknown Massachusetts   28001 8

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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