ny_times_us_counties

Table actions
⚠️ Consult the README for warnings about using and building on this data. Also review Why It’s So Freaking Hard To Make A Good COVID-19 Model and Ten Considerations Before You Create Another Chart About COVID-19.

Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette

101 rows where cases = 5244 sorted by date descending

✎ View and edit SQL

This data as json, yaml, Notebook, copyable, CSV (advanced)

These facets timed out: county, fips

Link rowid date ▲ county state fips cases deaths
2500010 2500010 2022-05-13 Dodge Georgia 13091 5244 154
2496752 2496752 2022-05-12 Dodge Georgia 13091 5244 154
2493494 2493494 2022-05-11 Dodge Georgia 13091 5244 154
2473480 2473480 2022-05-04 Vilas Wisconsin 55125 5244 89
2443304 2443304 2022-04-25 Camuy Puerto Rico 72027 5244  
2421907 2421907 2022-04-19 Mitchell Georgia 13205 5244 116
2418651 2418651 2022-04-18 Mitchell Georgia 13205 5244 116
2415395 2415395 2022-04-17 Mitchell Georgia 13205 5244 116
2416737 2416737 2022-04-17 Lincoln New Mexico 35027 5244 66
2412139 2412139 2022-04-16 Mitchell Georgia 13205 5244 116
2413481 2413481 2022-04-16 Lincoln New Mexico 35027 5244 66
2408883 2408883 2022-04-15 Mitchell Georgia 13205 5244 116
2410225 2410225 2022-04-15 Lincoln New Mexico 35027 5244 66
2405627 2405627 2022-04-14 Mitchell Georgia 13205 5244 116
2335951 2335951 2022-03-23 San Lorenzo Puerto Rico 72129 5244  
2273825 2273825 2022-03-04 Carroll Ohio 39019 5244 122
2270572 2270572 2022-03-03 Carroll Ohio 39019 5244 121
2267320 2267320 2022-03-02 Carroll Ohio 39019 5244 121
2196466 2196466 2022-02-08 Karnes Texas 48255 5244 63
2182851 2182851 2022-02-04 Wyandot Ohio 39175 5244 96
2153789 2153789 2022-01-26 Juana Diaz Puerto Rico 72075 5244  
2149539 2149539 2022-01-25 Meeker Minnesota 27093 5244 70
2150350 2150350 2022-01-25 Jackson Oklahoma 40065 5244 91
2147098 2147098 2022-01-24 Jackson Oklahoma 40065 5244 91
2143844 2143844 2022-01-23 Jackson Oklahoma 40065 5244 91
2140589 2140589 2022-01-22 Jackson Oklahoma 40065 5244 91
2137333 2137333 2022-01-21 Jackson Oklahoma 40065 5244 91
2134079 2134079 2022-01-20 Jackson Oklahoma 40065 5244 91
2128839 2128839 2022-01-19 Glenn California 6021 5244 55
2130097 2130097 2022-01-19 Leake Mississippi 28079 5244 92
2130827 2130827 2022-01-19 Jackson Oklahoma 40065 5244 91
2104724 2104724 2022-01-11 Henry Ohio 39069 5244 90
2102394 2102394 2022-01-10 Orange Virginia 51137 5244 69
2088737 2088737 2022-01-06 Humacao Puerto Rico 72069 5244  
2082790 2082790 2022-01-04 Windsor Vermont 50027 5244 44
2039390 2039390 2021-12-22 Nye Nevada 32023 5244 195
2037491 2037491 2021-12-21 Mineral West Virginia 54057 5244 133
2008523 2008523 2021-12-13 Poinsett Arkansas 5111 5244 102
2000471 2000471 2021-12-10 Greene New York 36039 5244 91
1990643 1990643 2021-12-07 Sullivan New Hampshire 33019 5244 40
1986987 1986987 2021-12-06 Pine Minnesota 27115 5244 43
1891369 1891369 2021-11-07 Dallas Alabama 1047 5244 207
1835007 1835007 2021-10-20 Williams Ohio 39171 5244 85
1811129 1811129 2021-10-13 Boyle Kentucky 21021 5244 79
1780075 1780075 2021-10-03 Marion South Carolina 45067 5244 131
1776825 1776825 2021-10-02 Marion South Carolina 45067 5244 131
1773575 1773575 2021-10-01 Marion South Carolina 45067 5244 131
1768986 1768986 2021-09-30 Taylor Kentucky 21217 5244 73
1756610 1756610 2021-09-26 Madison Nebraska 31119 5244 44
1753362 1753362 2021-09-25 Madison Nebraska 31119 5244 44
1750114 1750114 2021-09-24 Madison Nebraska 31119 5244 44
1732319 1732319 2021-09-19 Unknown Arkansas   5244 0
1727735 1727735 2021-09-17 Highland Ohio 39071 5244 81
1695853 1695853 2021-09-07 Erath Texas 48143 5244 79
1692605 1692605 2021-09-06 Erath Texas 48143 5244 79
1689356 1689356 2021-09-05 Erath Texas 48143 5244 79
1685525 1685525 2021-09-04 Mercer Ohio 39107 5244 86
1686106 1686106 2021-09-04 Erath Texas 48143 5244 79
1679342 1679342 2021-09-02 Dillon South Carolina 45033 5244 92
1628213 1628213 2021-08-18 Escambia Alabama 1053 5244 84
1619103 1619103 2021-08-15 Marion Illinois 17121 5244 127
1615855 1615855 2021-08-14 Marion Illinois 17121 5244 127
1612606 1612606 2021-08-13 Marion Illinois 17121 5244 127
1584689 1584689 2021-08-04 Richmond North Carolina 37153 5244 105
1578160 1578160 2021-08-02 Hoke North Carolina 37093 5244 56
1497582 1497582 2021-07-08 Franklin Tennessee 47051 5244 92
1474135 1474135 2021-07-01 Otero New Mexico 35035 5244 81
1448405 1448405 2021-06-23 Athens Ohio 39009 5244 60
1347543 1347543 2021-05-23 Curry New Mexico 35009 5244 79
1344295 1344295 2021-05-22 Curry New Mexico 35009 5244 79
1341047 1341047 2021-05-21 Curry New Mexico 35009 5244 79
1341373 1341373 2021-05-21 Washington Ohio 39167 5244 109
1331449 1331449 2021-05-18 McDowell North Carolina 37111 5244 63
1282924 1282924 2021-05-03 Seneca Ohio 39147 5244 121
1250170 1250170 2021-04-23 Cattaraugus New York 36009 5244 82
1197616 1197616 2021-04-07 Chippewa Michigan 26033 5244 46
1195293 1195293 2021-04-06 Kay Oklahoma 40071 5244 86
1192045 1192045 2021-04-05 Kay Oklahoma 40071 5244 86
1187429 1187429 2021-04-04 Clinton Iowa 19045 5244 89
1188796 1188796 2021-04-04 Kay Oklahoma 40071 5244 86
1185549 1185549 2021-04-03 Kay Oklahoma 40071 5244 86
1181985 1181985 2021-04-02 Jefferson New York 36045 5244 63
1182302 1182302 2021-04-02 Kay Oklahoma 40071 5244 86
1179055 1179055 2021-04-01 Kay Oklahoma 40071 5244 86
1175808 1175808 2021-03-31 Kay Oklahoma 40071 5244 86
1150110 1150110 2021-03-23 Brown South Dakota 46013 5244 91
1063747 1063747 2021-02-25 Polk Georgia 13233 5244 79
1043866 1043866 2021-02-19 Graham Arizona 4009 5244 71
1023663 1023663 2021-02-12 Warren Tennessee 47177 5244 73
974702 974702 2021-01-28 Caguas Puerto Rico 72025 5244  
919174 919174 2021-01-11 Rockingham North Carolina 37157 5244 31
890989 890989 2021-01-02 Montgomery Virginia 51121 5244 42
837306 837306 2020-12-17 Allegan Michigan 26005 5244 49
819871 819871 2020-12-12 Limestone Alabama 1083 5244 49
811242 811242 2020-12-09 Lafourche Louisiana 22057 5244 144
623413 623413 2020-10-12 Boone Missouri 29019 5244 14
620170 620170 2020-10-11 Boone Missouri 29019 5244 14
616928 616928 2020-10-10 Boone Missouri 29019 5244 14
497898 497898 2020-09-03 Lehigh Pennsylvania 42077 5244 344
341345 341345 2020-07-17 Sussex Delaware 10005 5244 178

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE [ny_times_us_counties] (
   [date] TEXT,
   [county] TEXT,
   [state] TEXT,
   [fips] INTEGER,
   [cases] INTEGER,
   [deaths] INTEGER
);
CREATE INDEX [idx_ny_times_us_counties_state]
    ON [ny_times_us_counties] ([state]);
CREATE INDEX [idx_ny_times_us_counties_county]
    ON [ny_times_us_counties] ([county]);
CREATE INDEX [idx_ny_times_us_counties_fips]
    ON [ny_times_us_counties] ([fips]);
CREATE INDEX [idx_ny_times_us_counties_date]
    ON [ny_times_us_counties] ([date] desc);