ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
161 rows where cases = 3044 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Iowa 15
- Oklahoma 14
- Georgia 11
- Missouri 9
- Virginia 8
- Wisconsin 8
- Alabama 7
- Idaho 6
- Kentucky 6
- Michigan 6
- Mississippi 6
- Indiana 5
- Louisiana 5
- Minnesota 5
- Tennessee 5
- Arkansas 4
- Montana 4
- Puerto Rico 4
- Texas 4
- Wyoming 4
- Illinois 3
- North Carolina 3
- Ohio 3
- Pennsylvania 3
- Florida 2
- New Mexico 2
- Utah 2
- Arizona 1
- California 1
- Nebraska 1
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2495268 | 2495268 | 2022-05-11 | Noble | Oklahoma | 40103 | 3044 | 39 |
2492010 | 2492010 | 2022-05-10 | Noble | Oklahoma | 40103 | 3044 | 39 |
2488752 | 2488752 | 2022-05-09 | Noble | Oklahoma | 40103 | 3044 | 39 |
2485495 | 2485495 | 2022-05-08 | Noble | Oklahoma | 40103 | 3044 | 39 |
2482237 | 2482237 | 2022-05-07 | Noble | Oklahoma | 40103 | 3044 | 39 |
2478979 | 2478979 | 2022-05-06 | Noble | Oklahoma | 40103 | 3044 | 39 |
2475721 | 2475721 | 2022-05-05 | Noble | Oklahoma | 40103 | 3044 | 39 |
2325415 | 2325415 | 2022-03-20 | Custer | Montana | 30017 | 3044 | 46 |
2322161 | 2322161 | 2022-03-19 | Custer | Montana | 30017 | 3044 | 46 |
2318907 | 2318907 | 2022-03-18 | Custer | Montana | 30017 | 3044 | 46 |
2311191 | 2311191 | 2022-03-16 | Charlton | Georgia | 13049 | 3044 | 62 |
2284453 | 2284453 | 2022-03-07 | Brunswick | Virginia | 51025 | 3044 | 44 |
2279596 | 2279596 | 2022-03-06 | Chippewa | Minnesota | 27023 | 3044 | 47 |
2276343 | 2276343 | 2022-03-05 | Chippewa | Minnesota | 27023 | 3044 | 47 |
2273090 | 2273090 | 2022-03-04 | Chippewa | Minnesota | 27023 | 3044 | 47 |
2265827 | 2265827 | 2022-03-02 | Gooding | Idaho | 16047 | 3044 | 53 |
2246264 | 2246264 | 2022-02-24 | Telfair | Georgia | 13271 | 3044 | 79 |
2246510 | 2246510 | 2022-02-24 | Pulaski | Indiana | 18131 | 3044 | 85 |
2197674 | 2197674 | 2022-02-09 | Blackford | Indiana | 18009 | 3044 | 66 |
2194420 | 2194420 | 2022-02-08 | Blackford | Indiana | 18009 | 3044 | 66 |
2193690 | 2193690 | 2022-02-07 | Converse | Wyoming | 56009 | 3044 | 49 |
2169811 | 2169811 | 2022-01-31 | Morgan | Ohio | 39115 | 3044 | 48 |
2167494 | 2167494 | 2022-01-30 | Westmoreland | Virginia | 51193 | 3044 | 40 |
2164239 | 2164239 | 2022-01-29 | Westmoreland | Virginia | 51193 | 3044 | 40 |
2160984 | 2160984 | 2022-01-28 | Westmoreland | Virginia | 51193 | 3044 | 40 |
2134530 | 2134530 | 2022-01-20 | Bandera | Texas | 48019 | 3044 | 66 |
2099318 | 2099318 | 2022-01-09 | Marquette | Wisconsin | 55077 | 3044 | 41 |
2096067 | 2096067 | 2022-01-08 | Marquette | Wisconsin | 55077 | 3044 | 41 |
2092815 | 2092815 | 2022-01-07 | Marquette | Wisconsin | 55077 | 3044 | 41 |
2074868 | 2074868 | 2022-01-02 | Benton | Missouri | 29015 | 3044 | 72 |
2071617 | 2071617 | 2022-01-01 | Benton | Missouri | 29015 | 3044 | 72 |
2068366 | 2068366 | 2021-12-31 | Benton | Missouri | 29015 | 3044 | 72 |
2065115 | 2065115 | 2021-12-30 | Benton | Missouri | 29015 | 3044 | 72 |
2063129 | 2063129 | 2021-12-29 | Lee | Texas | 48287 | 3044 | 54 |
2059310 | 2059310 | 2021-12-28 | McIntosh | Oklahoma | 40091 | 3044 | 106 |
2056061 | 2056061 | 2021-12-27 | McIntosh | Oklahoma | 40091 | 3044 | 106 |
2052812 | 2052812 | 2021-12-26 | McIntosh | Oklahoma | 40091 | 3044 | 106 |
2053832 | 2053832 | 2021-12-26 | Washburn | Wisconsin | 55129 | 3044 | 34 |
2049562 | 2049562 | 2021-12-25 | McIntosh | Oklahoma | 40091 | 3044 | 106 |
2050582 | 2050582 | 2021-12-25 | Washburn | Wisconsin | 55129 | 3044 | 34 |
2046312 | 2046312 | 2021-12-24 | McIntosh | Oklahoma | 40091 | 3044 | 106 |
2047332 | 2047332 | 2021-12-24 | Washburn | Wisconsin | 55129 | 3044 | 34 |
2043062 | 2043062 | 2021-12-23 | McIntosh | Oklahoma | 40091 | 3044 | 106 |
2039813 | 2039813 | 2021-12-22 | McIntosh | Oklahoma | 40091 | 3044 | 106 |
2035201 | 2035201 | 2021-12-21 | Hardin | Iowa | 19083 | 3044 | 55 |
2031951 | 2031951 | 2021-12-20 | Hardin | Iowa | 19083 | 3044 | 55 |
2033921 | 2033921 | 2021-12-20 | Panola | Texas | 48365 | 3044 | 111 |
2028700 | 2028700 | 2021-12-19 | Hardin | Iowa | 19083 | 3044 | 55 |
2025449 | 2025449 | 2021-12-18 | Hardin | Iowa | 19083 | 3044 | 55 |
2022198 | 2022198 | 2021-12-17 | Hardin | Iowa | 19083 | 3044 | 55 |
2018947 | 2018947 | 2021-12-16 | Hardin | Iowa | 19083 | 3044 | 55 |
2015697 | 2015697 | 2021-12-15 | Hardin | Iowa | 19083 | 3044 | 55 |
2013189 | 2013189 | 2021-12-14 | Pike | Missouri | 29163 | 3044 | 51 |
2011235 | 2011235 | 2021-12-13 | Young | Texas | 48503 | 3044 | 74 |
1989676 | 1989676 | 2021-12-07 | Delaware | Iowa | 19055 | 3044 | 55 |
1986426 | 1986426 | 2021-12-06 | Delaware | Iowa | 19055 | 3044 | 55 |
1983176 | 1983176 | 2021-12-05 | Delaware | Iowa | 19055 | 3044 | 55 |
1979926 | 1979926 | 2021-12-04 | Delaware | Iowa | 19055 | 3044 | 55 |
1976676 | 1976676 | 2021-12-03 | Delaware | Iowa | 19055 | 3044 | 55 |
1973427 | 1973427 | 2021-12-02 | Delaware | Iowa | 19055 | 3044 | 55 |
1970177 | 1970177 | 2021-12-01 | Delaware | Iowa | 19055 | 3044 | 55 |
1971190 | 1971190 | 2021-12-01 | Roosevelt | New Mexico | 35041 | 3044 | 71 |
1862068 | 1862068 | 2021-10-28 | Taylor | Wisconsin | 55119 | 3044 | 46 |
1853666 | 1853666 | 2021-10-26 | Osceola | Michigan | 26133 | 3044 | 41 |
1850417 | 1850417 | 2021-10-25 | Osceola | Michigan | 26133 | 3044 | 41 |
1844941 | 1844941 | 2021-10-23 | Aguadilla | Puerto Rico | 72005 | 3044 | |
1841691 | 1841691 | 2021-10-22 | Aguadilla | Puerto Rico | 72005 | 3044 | |
1817205 | 1817205 | 2021-10-15 | Minidoka | Idaho | 16067 | 3044 | 44 |
1814943 | 1814943 | 2021-10-14 | Perry | Missouri | 29157 | 3044 | 33 |
1816326 | 1816326 | 2021-10-14 | Dinwiddie | Virginia | 51053 | 3044 | 51 |
1801471 | 1801471 | 2021-10-10 | Rockcastle | Kentucky | 21203 | 3044 | 28 |
1798222 | 1798222 | 2021-10-09 | Rockcastle | Kentucky | 21203 | 3044 | 28 |
1794973 | 1794973 | 2021-10-08 | Rockcastle | Kentucky | 21203 | 3044 | 28 |
1789013 | 1789013 | 2021-10-06 | Lincoln | Montana | 30053 | 3044 | 51 |
1751687 | 1751687 | 2021-09-25 | Pickens | Alabama | 1107 | 3044 | 74 |
1748440 | 1748440 | 2021-09-24 | Randolph | Alabama | 1111 | 3044 | 56 |
1746674 | 1746674 | 2021-09-23 | Henry | Missouri | 29083 | 3044 | 48 |
1739718 | 1739718 | 2021-09-21 | McCreary | Kentucky | 21147 | 3044 | 41 |
1736469 | 1736469 | 2021-09-20 | McCreary | Kentucky | 21147 | 3044 | 41 |
1732286 | 1732286 | 2021-09-19 | Lawrence | Arkansas | 5075 | 3044 | 49 |
1722966 | 1722966 | 2021-09-16 | Elmore | Idaho | 16039 | 3044 | 26 |
1677504 | 1677504 | 2021-09-02 | Payette | Idaho | 16075 | 3044 | 39 |
1657586 | 1657586 | 2021-08-27 | Ouachita | Arkansas | 5103 | 3044 | 68 |
1627919 | 1627919 | 2021-08-17 | Halifax | Virginia | 51083 | 3044 | 80 |
1602774 | 1602774 | 2021-08-10 | Cassia | Idaho | 16031 | 3044 | 28 |
1598984 | 1598984 | 2021-08-09 | Geneva | Alabama | 1061 | 3044 | 85 |
1600319 | 1600319 | 2021-08-09 | Le Sueur | Minnesota | 27079 | 3044 | 28 |
1561110 | 1561110 | 2021-07-28 | Franklin | Louisiana | 22041 | 3044 | 108 |
1554611 | 1554611 | 2021-07-26 | De Soto | Louisiana | 22031 | 3044 | 79 |
1541279 | 1541279 | 2021-07-22 | Wells | Indiana | 18179 | 3044 | 83 |
1537436 | 1537436 | 2021-07-21 | Glenn | California | 6021 | 3044 | 27 |
1492318 | 1492318 | 2021-07-07 | Unknown | Georgia | 3044 | 4 | |
1469593 | 1469593 | 2021-06-30 | Unknown | Georgia | 3044 | 4 | |
1430595 | 1430595 | 2021-06-18 | Lumpkin | Georgia | 13187 | 3044 | 77 |
1427350 | 1427350 | 2021-06-17 | Lumpkin | Georgia | 13187 | 3044 | 77 |
1424105 | 1424105 | 2021-06-16 | Lumpkin | Georgia | 13187 | 3044 | 77 |
1399071 | 1399071 | 2021-06-08 | Adams | Mississippi | 28001 | 3044 | 85 |
1379626 | 1379626 | 2021-06-02 | Itawamba | Mississippi | 28057 | 3044 | 77 |
1376381 | 1376381 | 2021-06-01 | Itawamba | Mississippi | 28057 | 3044 | 77 |
1355789 | 1355789 | 2021-05-26 | Bradford | Florida | 12007 | 3044 | 57 |
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);