ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
79 rows where cases = 6172 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 27
- Michigan 9
- Ohio 7
- Mississippi 6
- Alabama 4
- California 4
- Indiana 4
- Minnesota 4
- Pennsylvania 4
- Arkansas 3
- Connecticut 3
- Illinois 3
- South Carolina 3
- Virginia 3
- Colorado 2
- Georgia 2
- New Mexico 2
- North Carolina 2
- Oklahoma 2
- Puerto Rico 2
- Texas 2
- Wisconsin 2
- Delaware 1
- Idaho 1
- Louisiana 1
- Maryland 1
- New Hampshire 1
- New York 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2501063 | 2501063 | 2022-05-13 | Tishomingo | Mississippi | 28141 | 6172 | 122 |
2497805 | 2497805 | 2022-05-12 | Tishomingo | Mississippi | 28141 | 6172 | 122 |
2494547 | 2494547 | 2022-05-11 | Tishomingo | Mississippi | 28141 | 6172 | 122 |
2491289 | 2491289 | 2022-05-10 | Tishomingo | Mississippi | 28141 | 6172 | 122 |
2488032 | 2488032 | 2022-05-09 | Tishomingo | Mississippi | 28141 | 6172 | 122 |
2397245 | 2397245 | 2022-04-11 | Lewis | New York | 36049 | 6172 | 49 |
2378178 | 2378178 | 2022-04-05 | Aguada | Puerto Rico | 72003 | 6172 | |
2374924 | 2374924 | 2022-04-04 | Aguada | Puerto Rico | 72003 | 6172 | |
2359040 | 2359040 | 2022-03-30 | Gray | Texas | 48179 | 6172 | 124 |
2271496 | 2271496 | 2022-03-03 | Lee | Virginia | 51105 | 6172 | 86 |
2262294 | 2262294 | 2022-03-01 | Routt | Colorado | 8107 | 6172 | 24 |
2200736 | 2200736 | 2022-02-10 | Stephens | Georgia | 13257 | 6172 | 132 |
2195078 | 2195078 | 2022-02-08 | Le Sueur | Minnesota | 27079 | 6172 | 47 |
2188471 | 2188471 | 2022-02-06 | Emmet | Michigan | 26047 | 6172 | 70 |
2185218 | 2185218 | 2022-02-05 | Emmet | Michigan | 26047 | 6172 | 70 |
2181966 | 2181966 | 2022-02-04 | Emmet | Michigan | 26047 | 6172 | 70 |
2169474 | 2169474 | 2022-01-31 | Coos | New Hampshire | 33007 | 6172 | 93 |
2169790 | 2169790 | 2022-01-31 | Hocking | Ohio | 39073 | 6172 | 107 |
2165772 | 2165772 | 2022-01-30 | Cass | Minnesota | 27021 | 6172 | 70 |
2162517 | 2162517 | 2022-01-29 | Cass | Minnesota | 27021 | 6172 | 70 |
2159262 | 2159262 | 2022-01-28 | Cass | Minnesota | 27021 | 6172 | 70 |
2115056 | 2115056 | 2022-01-14 | Cooke | Texas | 48097 | 6172 | 114 |
2054635 | 2054635 | 2021-12-27 | Ripley | Indiana | 18137 | 6172 | 97 |
2039449 | 2039449 | 2021-12-22 | Rio Arriba | New Mexico | 35039 | 6172 | 92 |
1967230 | 1967230 | 2021-11-30 | Beauregard | Louisiana | 22011 | 6172 | 124 |
1906456 | 1906456 | 2021-11-11 | Madison | Ohio | 39097 | 6172 | 86 |
1805687 | 1805687 | 2021-10-11 | Brown | Ohio | 39015 | 6172 | 79 |
1770171 | 1770171 | 2021-09-30 | Huntingdon | Pennsylvania | 42061 | 6172 | 145 |
1756141 | 1756141 | 2021-09-26 | Chippewa | Michigan | 26033 | 6172 | 51 |
1752893 | 1752893 | 2021-09-25 | Chippewa | Michigan | 26033 | 6172 | 51 |
1749645 | 1749645 | 2021-09-24 | Chippewa | Michigan | 26033 | 6172 | 51 |
1714747 | 1714747 | 2021-09-13 | Knox | Ohio | 39083 | 6172 | 120 |
1706179 | 1706179 | 2021-09-11 | Escambia | Alabama | 1053 | 6172 | 97 |
1691398 | 1691398 | 2021-09-06 | Warren | Mississippi | 28149 | 6172 | 149 |
1584980 | 1584980 | 2021-08-04 | Bradford | Pennsylvania | 42015 | 6172 | 97 |
1563191 | 1563191 | 2021-07-28 | Waupaca | Wisconsin | 55135 | 6172 | 167 |
1542810 | 1542810 | 2021-07-22 | Union | Pennsylvania | 42119 | 6172 | 89 |
1490491 | 1490491 | 2021-07-06 | Lee | North Carolina | 37105 | 6172 | 82 |
1487355 | 1487355 | 2021-07-05 | Belmont | Ohio | 39013 | 6172 | 177 |
1484108 | 1484108 | 2021-07-04 | Belmont | Ohio | 39013 | 6172 | 177 |
1480862 | 1480862 | 2021-07-03 | Belmont | Ohio | 39013 | 6172 | 177 |
1430240 | 1430240 | 2021-06-18 | Crittenden | Arkansas | 5035 | 6172 | 97 |
1422799 | 1422799 | 2021-06-15 | Cherokee | South Carolina | 45021 | 6172 | 157 |
1375609 | 1375609 | 2021-06-01 | Ogle | Illinois | 17141 | 6172 | 91 |
1356216 | 1356216 | 2021-05-26 | Marshall | Indiana | 18099 | 6172 | 115 |
1353536 | 1353536 | 2021-05-25 | St. Joseph | Michigan | 26149 | 6172 | 98 |
1339188 | 1339188 | 2021-05-20 | Sauk | Wisconsin | 55111 | 6172 | 54 |
1333456 | 1333456 | 2021-05-19 | Dubois | Indiana | 18037 | 6172 | 118 |
1277787 | 1277787 | 2021-05-02 | Yuba | California | 6115 | 6172 | 44 |
1274540 | 1274540 | 2021-05-01 | Yuba | California | 6115 | 6172 | 44 |
1271293 | 1271293 | 2021-04-30 | Yuba | California | 6115 | 6172 | 44 |
1268046 | 1268046 | 2021-04-29 | Yuba | California | 6115 | 6172 | 44 |
1220417 | 1220417 | 2021-04-14 | Van Buren | Michigan | 26159 | 6172 | 106 |
1218782 | 1218782 | 2021-04-13 | Bedford | Virginia | 51019 | 6172 | 98 |
1121458 | 1121458 | 2021-03-14 | Rockingham | Virginia | 51165 | 6172 | 102 |
1101245 | 1101245 | 2021-03-08 | Lawrence | Pennsylvania | 42073 | 6172 | 186 |
1059998 | 1059998 | 2021-02-24 | Autauga | Alabama | 1001 | 6172 | 85 |
1044355 | 1044355 | 2021-02-19 | Madison | Idaho | 16065 | 6172 | 21 |
1013479 | 1013479 | 2021-02-09 | Creek | Oklahoma | 40037 | 6172 | 103 |
970342 | 970342 | 2021-01-27 | Wicomico | Maryland | 24045 | 6172 | 123 |
953075 | 953075 | 2021-01-22 | White | Arkansas | 5145 | 6172 | 82 |
924414 | 924414 | 2021-01-13 | Hancock | Indiana | 18059 | 6172 | 97 |
914264 | 914264 | 2021-01-10 | Windham | Connecticut | 9015 | 6172 | 89 |
911019 | 911019 | 2021-01-09 | Windham | Connecticut | 9015 | 6172 | 89 |
907774 | 907774 | 2021-01-08 | Windham | Connecticut | 9015 | 6172 | 89 |
909913 | 909913 | 2021-01-08 | Sumter | South Carolina | 45085 | 6172 | 123 |
872358 | 872358 | 2020-12-28 | Adams | Illinois | 17001 | 6172 | 78 |
862081 | 862081 | 2020-12-25 | St. Clair | Alabama | 1115 | 6172 | 71 |
844715 | 844715 | 2020-12-19 | Comanche | Oklahoma | 40031 | 6172 | 50 |
805601 | 805601 | 2020-12-07 | Wayne | North Carolina | 37191 | 6172 | 119 |
787662 | 787662 | 2020-12-02 | Mesa | Colorado | 8077 | 6172 | 67 |
667945 | 667945 | 2020-10-26 | Champaign | Illinois | 17019 | 6172 | 29 |
612185 | 612185 | 2020-10-09 | Baldwin | Alabama | 1003 | 6172 | 64 |
547483 | 547483 | 2020-09-19 | Benton | Arkansas | 5007 | 6172 | 79 |
545938 | 545938 | 2020-09-18 | Bernalillo | New Mexico | 35001 | 6172 | 169 |
520680 | 520680 | 2020-09-10 | Lexington | South Carolina | 45063 | 6172 | 149 |
434556 | 434556 | 2020-08-15 | Sussex | Delaware | 10005 | 6172 | 192 |
293808 | 293808 | 2020-07-02 | DeKalb | Georgia | 13089 | 6172 | 173 |
134449 | 134449 | 2020-05-11 | Macomb | Michigan | 26099 | 6172 | 704 |
Advanced export
JSON shape: default, array, newline-delimited
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);