ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
130 rows where cases = 4485 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Arkansas 12
- Georgia 11
- Michigan 10
- Texas 9
- Iowa 8
- Kentucky 8
- Mississippi 7
- Illinois 6
- New York 6
- Washington 5
- California 4
- Minnesota 4
- North Carolina 4
- Puerto Rico 4
- South Carolina 4
- Alabama 3
- Missouri 3
- Florida 2
- Indiana 2
- Maine 2
- Nevada 2
- New Hampshire 2
- Ohio 2
- Pennsylvania 2
- Wisconsin 2
- Montana 1
- Oklahoma 1
- South Dakota 1
- Tennessee 1
- Utah 1
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2492643 | 2492643 | 2022-05-10 | Shelby | Texas | 48419 | 4485 | 134 |
2489385 | 2489385 | 2022-05-09 | Shelby | Texas | 48419 | 4485 | 134 |
2483775 | 2483775 | 2022-05-08 | Meriwether | Georgia | 13199 | 4485 | 145 |
2486127 | 2486127 | 2022-05-08 | Shelby | Texas | 48419 | 4485 | 134 |
2480517 | 2480517 | 2022-05-07 | Meriwether | Georgia | 13199 | 4485 | 145 |
2482869 | 2482869 | 2022-05-07 | Shelby | Texas | 48419 | 4485 | 134 |
2477259 | 2477259 | 2022-05-06 | Meriwether | Georgia | 13199 | 4485 | 145 |
2479611 | 2479611 | 2022-05-06 | Shelby | Texas | 48419 | 4485 | 134 |
2474001 | 2474001 | 2022-05-05 | Meriwether | Georgia | 13199 | 4485 | 145 |
2470744 | 2470744 | 2022-05-04 | Meriwether | Georgia | 13199 | 4485 | 145 |
2467644 | 2467644 | 2022-05-03 | Johnson | Illinois | 17087 | 4485 | 46 |
2468295 | 2468295 | 2022-05-03 | Manistee | Michigan | 26101 | 4485 | 90 |
2465040 | 2465040 | 2022-05-02 | Manistee | Michigan | 26101 | 4485 | 90 |
2461692 | 2461692 | 2022-05-01 | Washington | Maine | 23029 | 4485 | 55 |
2461784 | 2461784 | 2022-05-01 | Manistee | Michigan | 26101 | 4485 | 90 |
2458436 | 2458436 | 2022-04-30 | Washington | Maine | 23029 | 4485 | 55 |
2458528 | 2458528 | 2022-04-30 | Manistee | Michigan | 26101 | 4485 | 90 |
2455272 | 2455272 | 2022-04-29 | Manistee | Michigan | 26101 | 4485 | 90 |
2452016 | 2452016 | 2022-04-28 | Manistee | Michigan | 26101 | 4485 | 90 |
2448760 | 2448760 | 2022-04-27 | Manistee | Michigan | 26101 | 4485 | 90 |
2382856 | 2382856 | 2022-04-07 | Putnam | Georgia | 13237 | 4485 | 105 |
2384708 | 2384708 | 2022-04-07 | Coamo | Puerto Rico | 72043 | 4485 | |
2312132 | 2312132 | 2022-03-16 | Houston | Minnesota | 27055 | 4485 | 18 |
2308879 | 2308879 | 2022-03-15 | Houston | Minnesota | 27055 | 4485 | 18 |
2302086 | 2302086 | 2022-03-13 | Lawrence | Kentucky | 21127 | 4485 | 59 |
2303382 | 2303382 | 2022-03-13 | Fajardo | Puerto Rico | 72053 | 4485 | |
2304085 | 2304085 | 2022-03-13 | Asotin | Washington | 53003 | 4485 | 65 |
2298834 | 2298834 | 2022-03-12 | Lawrence | Kentucky | 21127 | 4485 | 59 |
2300833 | 2300833 | 2022-03-12 | Asotin | Washington | 53003 | 4485 | 65 |
2295582 | 2295582 | 2022-03-11 | Lawrence | Kentucky | 21127 | 4485 | 59 |
2297581 | 2297581 | 2022-03-11 | Asotin | Washington | 53003 | 4485 | 65 |
2292330 | 2292330 | 2022-03-10 | Lawrence | Kentucky | 21127 | 4485 | 59 |
2289078 | 2289078 | 2022-03-09 | Lawrence | Kentucky | 21127 | 4485 | 59 |
2285827 | 2285827 | 2022-03-08 | Lawrence | Kentucky | 21127 | 4485 | 59 |
2282575 | 2282575 | 2022-03-07 | Lawrence | Kentucky | 21127 | 4485 | 59 |
2278396 | 2278396 | 2022-03-06 | Hempstead | Arkansas | 5057 | 4485 | 58 |
2275143 | 2275143 | 2022-03-05 | Hempstead | Arkansas | 5057 | 4485 | 58 |
2198387 | 2198387 | 2022-02-09 | Calhoun | Mississippi | 28013 | 4485 | 57 |
2193842 | 2193842 | 2022-02-08 | Drew | Arkansas | 5043 | 4485 | 58 |
2195352 | 2195352 | 2022-02-08 | Lincoln | Montana | 30053 | 4485 | 77 |
2192924 | 2192924 | 2022-02-07 | Beadle | South Dakota | 46005 | 4485 | 52 |
2167137 | 2167137 | 2022-01-30 | Fayette | Texas | 48149 | 4485 | 98 |
2162678 | 2162678 | 2022-01-29 | Andrew | Missouri | 29003 | 4485 | 44 |
2131944 | 2131944 | 2022-01-20 | Monroe | Alabama | 1099 | 4485 | 67 |
2125833 | 2125833 | 2022-01-18 | Fannin | Georgia | 13111 | 4485 | 122 |
2088279 | 2088279 | 2022-01-06 | Anson | North Carolina | 37007 | 4485 | 86 |
2058542 | 2058542 | 2021-12-28 | Covington | Mississippi | 28031 | 4485 | 96 |
1945136 | 1945136 | 2021-11-23 | Sullivan | New Hampshire | 33019 | 4485 | 39 |
1930487 | 1930487 | 2021-11-19 | Jackson | Arkansas | 5067 | 4485 | 46 |
1932751 | 1932751 | 2021-11-19 | Vega Baja | Puerto Rico | 72145 | 4485 | |
1925626 | 1925626 | 2021-11-17 | Carroll | New Hampshire | 33003 | 4485 | 20 |
1921326 | 1921326 | 2021-11-16 | Greene | Indiana | 18055 | 4485 | 102 |
1891543 | 1891543 | 2021-11-07 | Glenn | California | 6021 | 4485 | 46 |
1888293 | 1888293 | 2021-11-06 | Glenn | California | 6021 | 4485 | 46 |
1885043 | 1885043 | 2021-11-05 | Glenn | California | 6021 | 4485 | 46 |
1873713 | 1873713 | 2021-11-01 | Franklin | New York | 36033 | 4485 | 22 |
1853441 | 1853441 | 2021-10-26 | Mercer | Kentucky | 21167 | 4485 | 75 |
1847287 | 1847287 | 2021-10-24 | Copiah | Mississippi | 28029 | 4485 | 92 |
1848317 | 1848317 | 2021-10-24 | Union | South Carolina | 45087 | 4485 | 101 |
1844037 | 1844037 | 2021-10-23 | Copiah | Mississippi | 28029 | 4485 | 92 |
1845067 | 1845067 | 2021-10-23 | Union | South Carolina | 45087 | 4485 | 101 |
1840787 | 1840787 | 2021-10-22 | Copiah | Mississippi | 28029 | 4485 | 92 |
1841817 | 1841817 | 2021-10-22 | Union | South Carolina | 45087 | 4485 | 101 |
1837538 | 1837538 | 2021-10-21 | Copiah | Mississippi | 28029 | 4485 | 92 |
1818498 | 1818498 | 2021-10-15 | Otsego | New York | 36077 | 4485 | 54 |
1771155 | 1771155 | 2021-10-01 | Geneva | Alabama | 1061 | 4485 | 121 |
1771073 | 1771073 | 2021-09-30 | Oneida | Wisconsin | 55085 | 4485 | 85 |
1758316 | 1758316 | 2021-09-27 | Yell | Arkansas | 5149 | 4485 | 76 |
1755068 | 1755068 | 2021-09-26 | Yell | Arkansas | 5149 | 4485 | 76 |
1751820 | 1751820 | 2021-09-25 | Yell | Arkansas | 5149 | 4485 | 76 |
1742320 | 1742320 | 2021-09-22 | Decatur | Georgia | 13087 | 4485 | 91 |
1731202 | 1731202 | 2021-09-18 | Perry | Pennsylvania | 42099 | 4485 | 104 |
1720749 | 1720749 | 2021-09-15 | Warren | Missouri | 29219 | 4485 | 39 |
1716070 | 1716070 | 2021-09-14 | St. Francis | Arkansas | 5123 | 4485 | 54 |
1671220 | 1671220 | 2021-08-31 | Buena Vista | Iowa | 19021 | 4485 | 40 |
1667973 | 1667973 | 2021-08-30 | Buena Vista | Iowa | 19021 | 4485 | 40 |
1664726 | 1664726 | 2021-08-29 | Buena Vista | Iowa | 19021 | 4485 | 40 |
1661478 | 1661478 | 2021-08-28 | Buena Vista | Iowa | 19021 | 4485 | 40 |
1658230 | 1658230 | 2021-08-27 | Buena Vista | Iowa | 19021 | 4485 | 40 |
1654982 | 1654982 | 2021-08-26 | Buena Vista | Iowa | 19021 | 4485 | 40 |
1651735 | 1651735 | 2021-08-25 | Buena Vista | Iowa | 19021 | 4485 | 40 |
1604136 | 1604136 | 2021-08-10 | Davie | North Carolina | 37059 | 4485 | 43 |
1601040 | 1601040 | 2021-08-09 | Fulton | Ohio | 39051 | 4485 | 75 |
1587509 | 1587509 | 2021-08-05 | Laclede | Missouri | 29105 | 4485 | 92 |
1587821 | 1587821 | 2021-08-05 | Fulton | New York | 36035 | 4485 | 93 |
1580814 | 1580814 | 2021-08-03 | Isanti | Minnesota | 27059 | 4485 | 67 |
1582154 | 1582154 | 2021-08-03 | Erath | Texas | 48143 | 4485 | 70 |
1582321 | 1582321 | 2021-08-03 | Washington | Texas | 48477 | 4485 | 99 |
1504924 | 1504924 | 2021-07-11 | Miller | Arkansas | 5091 | 4485 | 37 |
1501678 | 1501678 | 2021-07-10 | Miller | Arkansas | 5091 | 4485 | 37 |
1498432 | 1498432 | 2021-07-09 | Miller | Arkansas | 5091 | 4485 | 37 |
1489177 | 1489177 | 2021-07-06 | Jefferson | Illinois | 17081 | 4485 | 123 |
1330013 | 1330013 | 2021-05-18 | Thomas | Georgia | 13275 | 4485 | 124 |
1331357 | 1331357 | 2021-05-18 | Madison | New York | 36053 | 4485 | 88 |
1323520 | 1323520 | 2021-05-16 | Thomas | Georgia | 13275 | 4485 | 124 |
1306593 | 1306593 | 2021-05-10 | Lewis | Washington | 53041 | 4485 | 66 |
1288033 | 1288033 | 2021-05-05 | Lawrence | Indiana | 18093 | 4485 | 123 |
1267540 | 1267540 | 2021-04-28 | Henry | Virginia | 51089 | 4485 | 121 |
1247611 | 1247611 | 2021-04-22 | Cheatham | Tennessee | 47021 | 4485 | 55 |
1242041 | 1242041 | 2021-04-21 | Nevada | California | 6057 | 4485 | 75 |
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);