ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
104 rows where cases = 5275 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 28
- Oklahoma 14
- Alabama 10
- Mississippi 8
- Wisconsin 8
- Ohio 7
- Virginia 7
- Texas 6
- South Carolina 5
- Indiana 4
- Missouri 4
- North Carolina 4
- Alaska 3
- Colorado 3
- Kentucky 3
- Georgia 2
- Illinois 2
- Minnesota 2
- Tennessee 2
- Arkansas 1
- Louisiana 1
- Michigan 1
- Nebraska 1
- New Jersey 1
- New Mexico 1
- New York 1
- North Dakota 1
- Pennsylvania 1
- West Virginia 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2483335 | 2483335 | 2022-05-08 | Monroe | Alabama | 1099 | 5275 | 80 |
2480077 | 2480077 | 2022-05-07 | Monroe | Alabama | 1099 | 5275 | 80 |
2476819 | 2476819 | 2022-05-06 | Monroe | Alabama | 1099 | 5275 | 80 |
2473561 | 2473561 | 2022-05-05 | Monroe | Alabama | 1099 | 5275 | 80 |
2470304 | 2470304 | 2022-05-04 | Monroe | Alabama | 1099 | 5275 | 80 |
2467048 | 2467048 | 2022-05-03 | Monroe | Alabama | 1099 | 5275 | 80 |
2468832 | 2468832 | 2022-05-03 | Lincoln | New Mexico | 35027 | 5275 | 67 |
2463793 | 2463793 | 2022-05-02 | Monroe | Alabama | 1099 | 5275 | 80 |
2440881 | 2440881 | 2022-04-24 | Iowa | Wisconsin | 55049 | 5275 | 28 |
2437625 | 2437625 | 2022-04-23 | Iowa | Wisconsin | 55049 | 5275 | 28 |
2434369 | 2434369 | 2022-04-22 | Iowa | Wisconsin | 55049 | 5275 | 28 |
2350597 | 2350597 | 2022-03-28 | Sullivan | Indiana | 18153 | 5275 | 76 |
2347344 | 2347344 | 2022-03-27 | Sullivan | Indiana | 18153 | 5275 | 76 |
2344091 | 2344091 | 2022-03-26 | Sullivan | Indiana | 18153 | 5275 | 76 |
2340838 | 2340838 | 2022-03-25 | Sullivan | Indiana | 18153 | 5275 | 76 |
2333261 | 2333261 | 2022-03-22 | Dinwiddie | Virginia | 51053 | 5275 | 85 |
2330008 | 2330008 | 2022-03-21 | Dinwiddie | Virginia | 51053 | 5275 | 85 |
2317007 | 2317007 | 2022-03-17 | Fredericksburg city | Virginia | 51630 | 5275 | 38 |
2304971 | 2304971 | 2022-03-14 | Wayne | Illinois | 17191 | 5275 | 83 |
2281313 | 2281313 | 2022-03-06 | Waynesboro city | Virginia | 51820 | 5275 | 60 |
2278060 | 2278060 | 2022-03-05 | Waynesboro city | Virginia | 51820 | 5275 | 60 |
2274807 | 2274807 | 2022-03-04 | Waynesboro city | Virginia | 51820 | 5275 | 60 |
2265653 | 2265653 | 2022-03-02 | Burke | Georgia | 13033 | 5275 | 100 |
2255575 | 2255575 | 2022-02-27 | Nome Census Area | Alaska | 2180 | 5275 | 5 |
2252324 | 2252324 | 2022-02-26 | Nome Census Area | Alaska | 2180 | 5275 | 5 |
2249073 | 2249073 | 2022-02-25 | Nome Census Area | Alaska | 2180 | 5275 | 5 |
2217173 | 2217173 | 2022-02-15 | Union | Illinois | 17181 | 5275 | 67 |
2198446 | 2198446 | 2022-02-09 | Stone | Mississippi | 28131 | 5275 | 68 |
2174484 | 2174484 | 2022-02-02 | Morgan | Colorado | 8087 | 5275 | 129 |
2148040 | 2148040 | 2022-01-24 | Mason | West Virginia | 54053 | 5275 | 76 |
2115041 | 2115041 | 2022-01-14 | Cass | Texas | 48067 | 5275 | 164 |
2107380 | 2107380 | 2022-01-12 | Barry | Missouri | 29009 | 5275 | 98 |
2100518 | 2100518 | 2022-01-10 | Franklin | Louisiana | 22041 | 5275 | 144 |
2087847 | 2087847 | 2022-01-06 | Scott | Mississippi | 28123 | 5275 | 101 |
2052086 | 2052086 | 2021-12-26 | Prentiss | Mississippi | 28117 | 5275 | 87 |
2048836 | 2048836 | 2021-12-25 | Prentiss | Mississippi | 28117 | 5275 | 87 |
2045586 | 2045586 | 2021-12-24 | Prentiss | Mississippi | 28117 | 5275 | 87 |
2042336 | 2042336 | 2021-12-23 | Prentiss | Mississippi | 28117 | 5275 | 87 |
2039087 | 2039087 | 2021-12-22 | Prentiss | Mississippi | 28117 | 5275 | 87 |
2023447 | 2023447 | 2021-12-17 | Fayette | Ohio | 39047 | 5275 | 75 |
2017290 | 2017290 | 2021-12-15 | Clarendon | South Carolina | 45027 | 5275 | 137 |
1991431 | 1991431 | 2021-12-07 | Lauderdale | Tennessee | 47097 | 5275 | 72 |
1944928 | 1944928 | 2021-11-23 | Polk | Missouri | 29167 | 5275 | 80 |
1945504 | 1945504 | 2021-11-23 | Caddo | Oklahoma | 40015 | 5275 | 132 |
1946063 | 1946063 | 2021-11-23 | Grimes | Texas | 48185 | 5275 | 108 |
1942253 | 1942253 | 2021-11-22 | Caddo | Oklahoma | 40015 | 5275 | 132 |
1939003 | 1939003 | 2021-11-21 | Caddo | Oklahoma | 40015 | 5275 | 132 |
1935753 | 1935753 | 2021-11-20 | Caddo | Oklahoma | 40015 | 5275 | 132 |
1932503 | 1932503 | 2021-11-19 | Caddo | Oklahoma | 40015 | 5275 | 132 |
1927274 | 1927274 | 2021-11-18 | Unknown | Arkansas | 5275 | 0 | |
1929252 | 1929252 | 2021-11-18 | Caddo | Oklahoma | 40015 | 5275 | 132 |
1926002 | 1926002 | 2021-11-17 | Caddo | Oklahoma | 40015 | 5275 | 132 |
1873402 | 1873402 | 2021-11-01 | Laclede | Missouri | 29105 | 5275 | 128 |
1860751 | 1860751 | 2021-10-28 | Tioga | New York | 36107 | 5275 | 72 |
1836396 | 1836396 | 2021-10-21 | Montrose | Colorado | 8085 | 5275 | 83 |
1799756 | 1799756 | 2021-10-09 | Bee | Texas | 48025 | 5275 | 119 |
1746466 | 1746466 | 2021-09-23 | Beltrami | Minnesota | 27007 | 5275 | 72 |
1740724 | 1740724 | 2021-09-21 | Fulton | Ohio | 39051 | 5275 | 83 |
1730985 | 1730985 | 2021-09-18 | Highland | Ohio | 39071 | 5275 | 81 |
1695272 | 1695272 | 2021-09-07 | Mercer | Ohio | 39107 | 5275 | 86 |
1659526 | 1659526 | 2021-08-27 | Knox | Ohio | 39083 | 5275 | 116 |
1650986 | 1650986 | 2021-08-25 | Russell | Alabama | 1113 | 5275 | 51 |
1652986 | 1652986 | 2021-08-25 | Williams | North Dakota | 38105 | 5275 | 42 |
1647737 | 1647737 | 2021-08-24 | Russell | Alabama | 1113 | 5275 | 51 |
1649891 | 1649891 | 2021-08-24 | Pittsburg | Oklahoma | 40121 | 5275 | 81 |
1644488 | 1644488 | 2021-08-23 | Russell | Alabama | 1113 | 5275 | 51 |
1646642 | 1646642 | 2021-08-23 | Pittsburg | Oklahoma | 40121 | 5275 | 81 |
1643393 | 1643393 | 2021-08-22 | Pittsburg | Oklahoma | 40121 | 5275 | 81 |
1640143 | 1640143 | 2021-08-21 | Pittsburg | Oklahoma | 40121 | 5275 | 81 |
1636893 | 1636893 | 2021-08-20 | Pittsburg | Oklahoma | 40121 | 5275 | 81 |
1633431 | 1633431 | 2021-08-19 | Watauga | North Carolina | 37189 | 5275 | 33 |
1633643 | 1633643 | 2021-08-19 | Pittsburg | Oklahoma | 40121 | 5275 | 81 |
1630396 | 1630396 | 2021-08-18 | Pittsburg | Oklahoma | 40121 | 5275 | 81 |
1607880 | 1607880 | 2021-08-11 | Chesterfield | South Carolina | 45025 | 5275 | 110 |
1587939 | 1587939 | 2021-08-05 | Richmond | North Carolina | 37153 | 5275 | 107 |
1512770 | 1512770 | 2021-07-13 | Callaway | Missouri | 29027 | 5275 | 51 |
1306724 | 1306724 | 2021-05-10 | Shawano | Wisconsin | 55115 | 5275 | 83 |
1303478 | 1303478 | 2021-05-09 | Shawano | Wisconsin | 55115 | 5275 | 83 |
1300231 | 1300231 | 2021-05-08 | Shawano | Wisconsin | 55115 | 5275 | 83 |
1295908 | 1295908 | 2021-05-07 | Seneca | Ohio | 39147 | 5275 | 121 |
1204113 | 1204113 | 2021-04-09 | Chippewa | Michigan | 26033 | 5275 | 46 |
1197847 | 1197847 | 2021-04-07 | Washington | Mississippi | 28151 | 5275 | 132 |
1175303 | 1175303 | 2021-03-31 | Buffalo | Nebraska | 31019 | 5275 | 57 |
1176550 | 1176550 | 2021-03-31 | Albemarle | Virginia | 51003 | 5275 | 77 |
1126015 | 1126015 | 2021-03-16 | Pike | Kentucky | 21195 | 5275 | 63 |
1094555 | 1094555 | 2021-03-06 | Lawrence | Ohio | 39087 | 5275 | 86 |
1052684 | 1052684 | 2021-02-21 | Cherokee | South Carolina | 45021 | 5275 | 131 |
949620 | 949620 | 2021-01-20 | Waupaca | Wisconsin | 55135 | 5275 | 143 |
941708 | 941708 | 2021-01-18 | Hunterdon | New Jersey | 34019 | 5275 | 144 |
922421 | 922421 | 2021-01-12 | Rutherford | North Carolina | 37161 | 5275 | 137 |
908476 | 908476 | 2021-01-08 | Campbell | Kentucky | 21037 | 5275 | 35 |
904665 | 904665 | 2021-01-07 | Gordon | Georgia | 13129 | 5275 | 66 |
906529 | 906529 | 2021-01-07 | Somerset | Pennsylvania | 42111 | 5275 | 98 |
856892 | 856892 | 2020-12-23 | Kandiyohi | Minnesota | 27067 | 5275 | 57 |
843624 | 843624 | 2020-12-19 | Madison | Kentucky | 21151 | 5275 | 26 |
784085 | 784085 | 2020-11-30 | Ozaukee | Wisconsin | 55089 | 5275 | 40 |
773732 | 773732 | 2020-11-27 | Madison | Tennessee | 47113 | 5275 | 110 |
738989 | 738989 | 2020-11-17 | Pueblo | Colorado | 8101 | 5275 | 69 |
650285 | 650285 | 2020-10-20 | Anderson | South Carolina | 45007 | 5275 | 194 |
621353 | 621353 | 2020-10-11 | Ector | Texas | 48135 | 5275 | 101 |
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);