ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
97 rows where cases = 5393 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 27
- Tennessee 15
- Kansas 9
- Florida 8
- Missouri 7
- California 6
- Alabama 5
- Texas 5
- Wisconsin 5
- Arkansas 4
- Mississippi 4
- New York 3
- Ohio 3
- Georgia 2
- Indiana 2
- Kentucky 2
- Minnesota 2
- New Mexico 2
- North Carolina 2
- Pennsylvania 2
- Puerto Rico 2
- Illinois 1
- Maryland 1
- New Jersey 1
- Oklahoma 1
- Vermont 1
- Virginia 1
- Washington 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2497845 | 2497845 | 2022-05-12 | Crawford | Missouri | 29055 | 5393 | 102 |
2494587 | 2494587 | 2022-05-11 | Crawford | Missouri | 29055 | 5393 | 102 |
2491329 | 2491329 | 2022-05-10 | Crawford | Missouri | 29055 | 5393 | 102 |
2488071 | 2488071 | 2022-05-09 | Crawford | Missouri | 29055 | 5393 | 102 |
2484814 | 2484814 | 2022-05-08 | Crawford | Missouri | 29055 | 5393 | 102 |
2481556 | 2481556 | 2022-05-07 | Crawford | Missouri | 29055 | 5393 | 102 |
2478298 | 2478298 | 2022-05-06 | Crawford | Missouri | 29055 | 5393 | 102 |
2355687 | 2355687 | 2022-03-29 | Union | Tennessee | 47173 | 5393 | 72 |
2352434 | 2352434 | 2022-03-28 | Union | Tennessee | 47173 | 5393 | 72 |
2349182 | 2349182 | 2022-03-27 | Union | Tennessee | 47173 | 5393 | 72 |
2345929 | 2345929 | 2022-03-26 | Union | Tennessee | 47173 | 5393 | 72 |
2342676 | 2342676 | 2022-03-25 | Union | Tennessee | 47173 | 5393 | 72 |
2337531 | 2337531 | 2022-03-24 | Fountain | Indiana | 18045 | 5393 | 101 |
2339423 | 2339423 | 2022-03-24 | Union | Tennessee | 47173 | 5393 | 72 |
2336169 | 2336169 | 2022-03-23 | Union | Tennessee | 47173 | 5393 | 72 |
2271412 | 2271412 | 2022-03-03 | Caledonia | Vermont | 50005 | 5393 | 24 |
2260896 | 2260896 | 2022-02-28 | Wyandot | Ohio | 39175 | 5393 | 101 |
2261541 | 2261541 | 2022-02-28 | Moore | Texas | 48341 | 5393 | 109 |
2257645 | 2257645 | 2022-02-27 | Wyandot | Ohio | 39175 | 5393 | 101 |
2258290 | 2258290 | 2022-02-27 | Moore | Texas | 48341 | 5393 | 109 |
2255039 | 2255039 | 2022-02-26 | Moore | Texas | 48341 | 5393 | 109 |
2231839 | 2231839 | 2022-02-19 | Cidra | Puerto Rico | 72041 | 5393 | |
2215938 | 2215938 | 2022-02-14 | Frio | Texas | 48163 | 5393 | 85 |
2195550 | 2195550 | 2022-02-08 | San Miguel | New Mexico | 35047 | 5393 | 46 |
2135265 | 2135265 | 2022-01-21 | Carroll | Arkansas | 5015 | 5393 | 87 |
2133804 | 2133804 | 2022-01-20 | Anson | North Carolina | 37007 | 5393 | 86 |
2062219 | 2062219 | 2021-12-29 | Delaware | New York | 36025 | 5393 | 58 |
2051567 | 2051567 | 2021-12-26 | McPherson | Kansas | 20113 | 5393 | 100 |
2048317 | 2048317 | 2021-12-25 | McPherson | Kansas | 20113 | 5393 | 100 |
2045067 | 2045067 | 2021-12-24 | McPherson | Kansas | 20113 | 5393 | 100 |
2041818 | 2041818 | 2021-12-23 | McPherson | Kansas | 20113 | 5393 | 100 |
2038568 | 2038568 | 2021-12-22 | McPherson | Kansas | 20113 | 5393 | 100 |
2035318 | 2035318 | 2021-12-21 | McPherson | Kansas | 20113 | 5393 | 99 |
2032190 | 2032190 | 2021-12-20 | Marshall | Kentucky | 21157 | 5393 | 85 |
1937781 | 1937781 | 2021-11-21 | Harvey | Kansas | 20079 | 5393 | 92 |
1934531 | 1934531 | 2021-11-20 | Harvey | Kansas | 20079 | 5393 | 92 |
1931280 | 1931280 | 2021-11-19 | Harvey | Kansas | 20079 | 5393 | 92 |
1900451 | 1900451 | 2021-11-09 | Scott | Tennessee | 47151 | 5393 | 61 |
1872862 | 1872862 | 2021-11-01 | Boyle | Kentucky | 21021 | 5393 | 81 |
1873747 | 1873747 | 2021-11-01 | Tioga | New York | 36107 | 5393 | 72 |
1851648 | 1851648 | 2021-10-25 | Claiborne | Tennessee | 47025 | 5393 | 111 |
1848398 | 1848398 | 2021-10-24 | Claiborne | Tennessee | 47025 | 5393 | 111 |
1845148 | 1845148 | 2021-10-23 | Claiborne | Tennessee | 47025 | 5393 | 111 |
1841898 | 1841898 | 2021-10-22 | Claiborne | Tennessee | 47025 | 5393 | 111 |
1826897 | 1826897 | 2021-10-18 | Upson | Georgia | 13293 | 5393 | 167 |
1795078 | 1795078 | 2021-10-08 | Calvert | Maryland | 24009 | 5393 | 98 |
1793024 | 1793024 | 2021-10-07 | Unknown | Puerto Rico | 5393 | 3182 | |
1712599 | 1712599 | 2021-09-12 | Pierce | Wisconsin | 55093 | 5393 | 44 |
1709352 | 1709352 | 2021-09-11 | Pierce | Wisconsin | 55093 | 5393 | 44 |
1706105 | 1706105 | 2021-09-10 | Pierce | Wisconsin | 55093 | 5393 | 44 |
1686800 | 1686800 | 2021-09-05 | Independence | Arkansas | 5063 | 5393 | 144 |
1656170 | 1656170 | 2021-08-26 | Vance | North Carolina | 37181 | 5393 | 90 |
1634797 | 1634797 | 2021-08-20 | Boone | Arkansas | 5009 | 5393 | 93 |
1583246 | 1583246 | 2021-08-04 | Ware | Georgia | 13299 | 5393 | 185 |
1565769 | 1565769 | 2021-07-29 | Fayette | Tennessee | 47047 | 5393 | 83 |
1556745 | 1556745 | 2021-07-27 | Dale | Alabama | 1045 | 5393 | 117 |
1559932 | 1559932 | 2021-07-27 | Shawano | Wisconsin | 55115 | 5393 | 85 |
1542318 | 1542318 | 2021-07-22 | Otero | New Mexico | 35035 | 5393 | 86 |
1427250 | 1427250 | 2021-06-17 | Suwannee | Florida | 12121 | 5393 | 140 |
1424005 | 1424005 | 2021-06-16 | Suwannee | Florida | 12121 | 5393 | 140 |
1420757 | 1420757 | 2021-06-15 | Suwannee | Florida | 12121 | 5393 | 140 |
1417512 | 1417512 | 2021-06-14 | Suwannee | Florida | 12121 | 5393 | 140 |
1414266 | 1414266 | 2021-06-13 | Suwannee | Florida | 12121 | 5393 | 140 |
1411021 | 1411021 | 2021-06-12 | Suwannee | Florida | 12121 | 5393 | 140 |
1407776 | 1407776 | 2021-06-11 | Suwannee | Florida | 12121 | 5393 | 140 |
1381812 | 1381812 | 2021-06-03 | Suwannee | Florida | 12121 | 5393 | 140 |
1379673 | 1379673 | 2021-06-02 | Washington | Mississippi | 28151 | 5393 | 135 |
1376428 | 1376428 | 2021-06-01 | Washington | Mississippi | 28151 | 5393 | 135 |
1373182 | 1373182 | 2021-05-31 | Washington | Mississippi | 28151 | 5393 | 135 |
1263858 | 1263858 | 2021-04-27 | Dyer | Tennessee | 47045 | 5393 | 105 |
1223723 | 1223723 | 2021-04-15 | Otter Tail | Minnesota | 27111 | 5393 | 73 |
1199621 | 1199621 | 2021-04-08 | Coffee | Alabama | 1031 | 5393 | 112 |
1202533 | 1202533 | 2021-04-08 | Albemarle | Virginia | 51003 | 5393 | 82 |
1196372 | 1196372 | 2021-04-07 | Coffee | Alabama | 1031 | 5393 | 111 |
1193124 | 1193124 | 2021-04-06 | Coffee | Alabama | 1031 | 5393 | 112 |
1189874 | 1189874 | 2021-04-05 | Coffee | Alabama | 1031 | 5393 | 112 |
1171047 | 1171047 | 2021-03-30 | Ogle | Illinois | 17141 | 5393 | 86 |
1162528 | 1162528 | 2021-03-27 | Sullivan | New York | 36105 | 5393 | 64 |
1130726 | 1130726 | 2021-03-17 | Hawkins | Tennessee | 47073 | 5393 | 100 |
1065400 | 1065400 | 2021-02-25 | Cherokee | Oklahoma | 40021 | 5393 | 41 |
1057504 | 1057504 | 2021-02-23 | Marshall | Indiana | 18099 | 5393 | 105 |
982301 | 982301 | 2021-01-31 | Lassen | California | 6035 | 5393 | 16 |
979055 | 979055 | 2021-01-30 | Lassen | California | 6035 | 5393 | 16 |
975810 | 975810 | 2021-01-29 | Lassen | California | 6035 | 5393 | 16 |
946553 | 946553 | 2021-01-20 | Lonoke | Arkansas | 5085 | 5393 | 98 |
900523 | 900523 | 2021-01-05 | Orange | Texas | 48361 | 5393 | 75 |
889343 | 889343 | 2021-01-02 | Kandiyohi | Minnesota | 27067 | 5393 | 66 |
816497 | 816497 | 2020-12-10 | Chippewa | Wisconsin | 55017 | 5393 | 60 |
676129 | 676129 | 2020-10-28 | Northampton | Pennsylvania | 42095 | 5393 | 311 |
670392 | 670392 | 2020-10-26 | Benton | Washington | 53005 | 5393 | 137 |
581900 | 581900 | 2020-09-29 | Summit | Ohio | 39153 | 5393 | 252 |
548798 | 548798 | 2020-09-19 | DeSoto | Mississippi | 28033 | 5393 | 55 |
533479 | 533479 | 2020-09-14 | Lehigh | Pennsylvania | 42077 | 5393 | 345 |
482906 | 482906 | 2020-08-30 | Solano | California | 6095 | 5393 | 46 |
479672 | 479672 | 2020-08-29 | Solano | California | 6095 | 5393 | 46 |
476439 | 476439 | 2020-08-28 | Solano | California | 6095 | 5393 | 46 |
134880 | 134880 | 2020-05-11 | Mercer | New Jersey | 34021 | 5393 | 340 |
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);