ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
161 rows where cases = 3140 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Georgia 13
- Alabama 11
- Iowa 9
- Tennessee 9
- Wisconsin 9
- Arkansas 8
- Illinois 8
- Minnesota 8
- Mississippi 7
- South Carolina 7
- Wyoming 7
- Missouri 6
- Indiana 5
- New Mexico 5
- West Virginia 5
- New York 4
- Pennsylvania 4
- Texas 4
- Florida 3
- Michigan 3
- Vermont 3
- Kentucky 2
- Louisiana 2
- Maryland 2
- North Carolina 2
- Ohio 2
- Oregon 2
- Utah 2
- California 1
- Idaho 1
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2489782 | 2489782 | 2022-05-09 | Converse | Wyoming | 56009 | 3140 | 55 |
2485135 | 2485135 | 2022-05-08 | Torrance | New Mexico | 35057 | 3140 | 55 |
2486525 | 2486525 | 2022-05-08 | Converse | Wyoming | 56009 | 3140 | 55 |
2481877 | 2481877 | 2022-05-07 | Torrance | New Mexico | 35057 | 3140 | 55 |
2483267 | 2483267 | 2022-05-07 | Converse | Wyoming | 56009 | 3140 | 55 |
2478619 | 2478619 | 2022-05-06 | Torrance | New Mexico | 35057 | 3140 | 55 |
2480009 | 2480009 | 2022-05-06 | Converse | Wyoming | 56009 | 3140 | 55 |
2476751 | 2476751 | 2022-05-05 | Converse | Wyoming | 56009 | 3140 | 55 |
2473493 | 2473493 | 2022-05-04 | Converse | Wyoming | 56009 | 3140 | 55 |
2470236 | 2470236 | 2022-05-03 | Converse | Wyoming | 56009 | 3140 | 55 |
2345690 | 2345690 | 2022-03-26 | Loiza | Puerto Rico | 72087 | 3140 | |
2331153 | 2331153 | 2022-03-22 | Madison | Iowa | 19121 | 3140 | 38 |
2327901 | 2327901 | 2022-03-21 | Madison | Iowa | 19121 | 3140 | 38 |
2324648 | 2324648 | 2022-03-20 | Madison | Iowa | 19121 | 3140 | 38 |
2321394 | 2321394 | 2022-03-19 | Madison | Iowa | 19121 | 3140 | 38 |
2318140 | 2318140 | 2022-03-18 | Madison | Iowa | 19121 | 3140 | 38 |
2314887 | 2314887 | 2022-03-17 | Madison | Iowa | 19121 | 3140 | 38 |
2311634 | 2311634 | 2022-03-16 | Madison | Iowa | 19121 | 3140 | 38 |
2290333 | 2290333 | 2022-03-09 | Potter | Pennsylvania | 42105 | 3140 | 91 |
2214723 | 2214723 | 2022-02-14 | Webster | Mississippi | 28155 | 3140 | 60 |
2215468 | 2215468 | 2022-02-14 | Curry | Oregon | 41015 | 3140 | 43 |
2212103 | 2212103 | 2022-02-13 | Noble | Ohio | 39121 | 3140 | 53 |
2212898 | 2212898 | 2022-02-13 | Orange | Vermont | 50017 | 3140 | 11 |
2209645 | 2209645 | 2022-02-12 | Orange | Vermont | 50017 | 3140 | 11 |
2206392 | 2206392 | 2022-02-11 | Orange | Vermont | 50017 | 3140 | 11 |
2196458 | 2196458 | 2022-02-08 | Jackson | Texas | 48239 | 3140 | 55 |
2196919 | 2196919 | 2022-02-08 | Price | Wisconsin | 55099 | 3140 | 28 |
2152871 | 2152871 | 2022-01-26 | Lawrence | Mississippi | 28077 | 3140 | 45 |
2128494 | 2128494 | 2022-01-18 | Braxton | West Virginia | 54007 | 3140 | 32 |
2123640 | 2123640 | 2022-01-17 | Bates | Missouri | 29013 | 3140 | 67 |
2120388 | 2120388 | 2022-01-16 | Bates | Missouri | 29013 | 3140 | 67 |
2117136 | 2117136 | 2022-01-15 | Bates | Missouri | 29013 | 3140 | 67 |
2037752 | 2037752 | 2021-12-22 | Hempstead | Arkansas | 5057 | 3140 | 46 |
2039194 | 2039194 | 2021-12-22 | Pike | Missouri | 29163 | 3140 | 53 |
2023251 | 2023251 | 2021-12-17 | Schoharie | New York | 36095 | 3140 | 27 |
1989402 | 1989402 | 2021-12-07 | Worth | Georgia | 13321 | 3140 | 95 |
1992032 | 1992032 | 2021-12-07 | Iowa | Wisconsin | 55049 | 3140 | 19 |
1988781 | 1988781 | 2021-12-06 | Iowa | Wisconsin | 55049 | 3140 | 19 |
1985531 | 1985531 | 2021-12-05 | Iowa | Wisconsin | 55049 | 3140 | 19 |
1982281 | 1982281 | 2021-12-04 | Iowa | Wisconsin | 55049 | 3140 | 19 |
1979031 | 1979031 | 2021-12-03 | Iowa | Wisconsin | 55049 | 3140 | 19 |
1933604 | 1933604 | 2021-11-20 | Cherokee | Alabama | 1019 | 3140 | 62 |
1897700 | 1897700 | 2021-11-08 | Brooke | West Virginia | 54009 | 3140 | 74 |
1875131 | 1875131 | 2021-11-02 | Hale | Alabama | 1065 | 3140 | 89 |
1857183 | 1857183 | 2021-10-27 | Perry | Missouri | 29157 | 3140 | 33 |
1836233 | 1836233 | 2021-10-21 | Conway | Arkansas | 5029 | 3140 | 43 |
1836538 | 1836538 | 2021-10-21 | Crisp | Georgia | 13081 | 3140 | 107 |
1833289 | 1833289 | 2021-10-20 | Crisp | Georgia | 13081 | 3140 | 107 |
1834354 | 1834354 | 2021-10-20 | Winston | Mississippi | 28159 | 3140 | 91 |
1829663 | 1829663 | 2021-10-19 | Pickens | Alabama | 1107 | 3140 | 82 |
1830040 | 1830040 | 2021-10-19 | Crisp | Georgia | 13081 | 3140 | 107 |
1826414 | 1826414 | 2021-10-18 | Pickens | Alabama | 1107 | 3140 | 82 |
1815150 | 1815150 | 2021-10-14 | Coos | New Hampshire | 33007 | 3140 | 52 |
1784244 | 1784244 | 2021-10-05 | Clark | Arkansas | 5019 | 3140 | 51 |
1772347 | 1772347 | 2021-10-01 | Somerset | Maryland | 24039 | 3140 | 47 |
1756255 | 1756255 | 2021-09-26 | Meeker | Minnesota | 27093 | 3140 | 49 |
1753007 | 1753007 | 2021-09-25 | Meeker | Minnesota | 27093 | 3140 | 49 |
1753955 | 1753955 | 2021-09-25 | Susquehanna | Pennsylvania | 42115 | 3140 | 63 |
1749759 | 1749759 | 2021-09-24 | Meeker | Minnesota | 27093 | 3140 | 49 |
1741536 | 1741536 | 2021-09-21 | Sevier | Utah | 49041 | 3140 | 16 |
1721854 | 1721854 | 2021-09-15 | Gray | Texas | 48179 | 3140 | 64 |
1700446 | 1700446 | 2021-09-09 | Washington | Indiana | 18175 | 3140 | 44 |
1677020 | 1677020 | 2021-09-02 | Arkansas | Arkansas | 5001 | 3140 | 53 |
1630712 | 1630712 | 2021-08-18 | Yankton | South Dakota | 46135 | 3140 | 33 |
1621064 | 1621064 | 2021-08-15 | Wayne | Tennessee | 47181 | 3140 | 36 |
1617816 | 1617816 | 2021-08-14 | Wayne | Tennessee | 47181 | 3140 | 36 |
1614568 | 1614568 | 2021-08-13 | Wayne | Tennessee | 47181 | 3140 | 36 |
1600426 | 1600426 | 2021-08-09 | Prentiss | Mississippi | 28117 | 3140 | 63 |
1573444 | 1573444 | 2021-08-01 | Lumpkin | Georgia | 13187 | 3140 | 83 |
1574389 | 1574389 | 2021-08-01 | Coahoma | Mississippi | 28027 | 3140 | 85 |
1570196 | 1570196 | 2021-07-31 | Lumpkin | Georgia | 13187 | 3140 | 83 |
1571141 | 1571141 | 2021-07-31 | Coahoma | Mississippi | 28027 | 3140 | 85 |
1566948 | 1566948 | 2021-07-30 | Lumpkin | Georgia | 13187 | 3140 | 83 |
1567893 | 1567893 | 2021-07-30 | Coahoma | Mississippi | 28027 | 3140 | 85 |
1563668 | 1563668 | 2021-07-29 | Gilmer | Georgia | 13123 | 3140 | 91 |
1532117 | 1532117 | 2021-07-19 | Mille Lacs | Minnesota | 27095 | 3140 | 56 |
1478598 | 1478598 | 2021-07-02 | Warren | Virginia | 51187 | 3140 | 61 |
1426922 | 1426922 | 2021-06-17 | Pike | Alabama | 1109 | 3140 | 78 |
1423676 | 1423676 | 2021-06-16 | Pike | Alabama | 1109 | 3140 | 78 |
1420429 | 1420429 | 2021-06-15 | Pike | Alabama | 1109 | 3140 | 78 |
1358197 | 1358197 | 2021-05-26 | Hopkins | Texas | 48223 | 3140 | 111 |
1348307 | 1348307 | 2021-05-23 | Marion | Tennessee | 47115 | 3140 | 47 |
1348871 | 1348871 | 2021-05-23 | Wayne | West Virginia | 54099 | 3140 | 41 |
1345059 | 1345059 | 2021-05-22 | Marion | Tennessee | 47115 | 3140 | 47 |
1345623 | 1345623 | 2021-05-22 | Wayne | West Virginia | 54099 | 3140 | 41 |
1341811 | 1341811 | 2021-05-21 | Marion | Tennessee | 47115 | 3140 | 47 |
1342375 | 1342375 | 2021-05-21 | Wayne | West Virginia | 54099 | 3140 | 41 |
1331586 | 1331586 | 2021-05-18 | Jackson | Ohio | 39079 | 3140 | 52 |
1326287 | 1326287 | 2021-05-17 | Marion | Alabama | 1093 | 3140 | 101 |
1323041 | 1323041 | 2021-05-16 | Marion | Alabama | 1093 | 3140 | 101 |
1318780 | 1318780 | 2021-05-14 | Clarion | Pennsylvania | 42031 | 3140 | 91 |
1315712 | 1315712 | 2021-05-13 | Union | South Carolina | 45087 | 3140 | 83 |
1310415 | 1310415 | 2021-05-12 | Butts | Georgia | 13035 | 3140 | 83 |
1312466 | 1312466 | 2021-05-12 | Union | South Carolina | 45087 | 3140 | 83 |
1307346 | 1307346 | 2021-05-11 | Latah | Idaho | 16057 | 3140 | 10 |
1309219 | 1309219 | 2021-05-11 | Union | South Carolina | 45087 | 3140 | 83 |
1304309 | 1304309 | 2021-05-10 | White | Indiana | 18181 | 3140 | 55 |
1305973 | 1305973 | 2021-05-10 | Union | South Carolina | 45087 | 3140 | 83 |
1302727 | 1302727 | 2021-05-09 | Union | South Carolina | 45087 | 3140 | 83 |
1278216 | 1278216 | 2021-05-02 | Perry | Illinois | 17145 | 3140 | 68 |
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);