ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
221 rows where cases = 2375 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Georgia 41
- Iowa 30
- Kentucky 14
- Alabama 11
- Tennessee 8
- Virginia 8
- Alaska 7
- Arkansas 6
- Indiana 6
- Louisiana 6
- Minnesota 6
- Missouri 6
- New York 6
- California 5
- Illinois 5
- Ohio 5
- Puerto Rico 5
- Idaho 4
- Mississippi 4
- Oklahoma 3
- Oregon 3
- Texas 3
- West Virginia 3
- Wisconsin 3
- Colorado 2
- Florida 2
- Kansas 2
- North Carolina 2
- North Dakota 2
- Pennsylvania 2
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2496633 | 2496633 | 2022-05-12 | Unknown | Connecticut | 2375 | 1 | |
2467435 | 2467435 | 2022-05-03 | Dooly | Georgia | 13093 | 2375 | 69 |
2464180 | 2464180 | 2022-05-02 | Dooly | Georgia | 13093 | 2375 | 69 |
2460924 | 2460924 | 2022-05-01 | Dooly | Georgia | 13093 | 2375 | 69 |
2457668 | 2457668 | 2022-04-30 | Dooly | Georgia | 13093 | 2375 | 69 |
2454412 | 2454412 | 2022-04-29 | Dooly | Georgia | 13093 | 2375 | 69 |
2451156 | 2451156 | 2022-04-28 | Dooly | Georgia | 13093 | 2375 | 69 |
2447900 | 2447900 | 2022-04-27 | Dooly | Georgia | 13093 | 2375 | 69 |
2446602 | 2446602 | 2022-04-26 | Penuelas | Puerto Rico | 72111 | 2375 | |
2421503 | 2421503 | 2022-04-19 | Sitka City and Borough | Alaska | 2220 | 2375 | 5 |
2418247 | 2418247 | 2022-04-18 | Sitka City and Borough | Alaska | 2220 | 2375 | 5 |
2414991 | 2414991 | 2022-04-17 | Sitka City and Borough | Alaska | 2220 | 2375 | 5 |
2411735 | 2411735 | 2022-04-16 | Sitka City and Borough | Alaska | 2220 | 2375 | 5 |
2408479 | 2408479 | 2022-04-15 | Sitka City and Borough | Alaska | 2220 | 2375 | 5 |
2405223 | 2405223 | 2022-04-14 | Sitka City and Borough | Alaska | 2220 | 2375 | 5 |
2401968 | 2401968 | 2022-04-13 | Sitka City and Borough | Alaska | 2220 | 2375 | 5 |
2399062 | 2399062 | 2022-04-12 | Dooly | Georgia | 13093 | 2375 | 68 |
2395807 | 2395807 | 2022-04-11 | Dooly | Georgia | 13093 | 2375 | 68 |
2392551 | 2392551 | 2022-04-10 | Dooly | Georgia | 13093 | 2375 | 68 |
2389295 | 2389295 | 2022-04-09 | Dooly | Georgia | 13093 | 2375 | 68 |
2386040 | 2386040 | 2022-04-08 | Dooly | Georgia | 13093 | 2375 | 68 |
2382785 | 2382785 | 2022-04-07 | Dooly | Georgia | 13093 | 2375 | 68 |
2379530 | 2379530 | 2022-04-06 | Dooly | Georgia | 13093 | 2375 | 68 |
2376276 | 2376276 | 2022-04-05 | Dooly | Georgia | 13093 | 2375 | 68 |
2369771 | 2369771 | 2022-04-03 | Dooly | Georgia | 13093 | 2375 | 68 |
2369779 | 2369779 | 2022-04-03 | Evans | Georgia | 13109 | 2375 | 66 |
2370368 | 2370368 | 2022-04-03 | Elliott | Kentucky | 21063 | 2375 | 18 |
2366518 | 2366518 | 2022-04-02 | Dooly | Georgia | 13093 | 2375 | 68 |
2366526 | 2366526 | 2022-04-02 | Evans | Georgia | 13109 | 2375 | 66 |
2367115 | 2367115 | 2022-04-02 | Elliott | Kentucky | 21063 | 2375 | 18 |
2363265 | 2363265 | 2022-04-01 | Dooly | Georgia | 13093 | 2375 | 68 |
2363273 | 2363273 | 2022-04-01 | Evans | Georgia | 13109 | 2375 | 66 |
2363862 | 2363862 | 2022-04-01 | Elliott | Kentucky | 21063 | 2375 | 18 |
2360011 | 2360011 | 2022-03-31 | Dooly | Georgia | 13093 | 2375 | 68 |
2360608 | 2360608 | 2022-03-31 | Elliott | Kentucky | 21063 | 2375 | 18 |
2356757 | 2356757 | 2022-03-30 | Dooly | Georgia | 13093 | 2375 | 68 |
2357354 | 2357354 | 2022-03-30 | Elliott | Kentucky | 21063 | 2375 | 18 |
2353504 | 2353504 | 2022-03-29 | Dooly | Georgia | 13093 | 2375 | 68 |
2354101 | 2354101 | 2022-03-29 | Elliott | Kentucky | 21063 | 2375 | 18 |
2350252 | 2350252 | 2022-03-28 | Dooly | Georgia | 13093 | 2375 | 68 |
2350849 | 2350849 | 2022-03-28 | Elliott | Kentucky | 21063 | 2375 | 18 |
2315023 | 2315023 | 2022-03-17 | Thomas | Kansas | 20193 | 2375 | 27 |
2311770 | 2311770 | 2022-03-16 | Thomas | Kansas | 20193 | 2375 | 27 |
2284461 | 2284461 | 2022-03-07 | Charlotte | Virginia | 51037 | 2375 | 44 |
2266366 | 2266366 | 2022-03-02 | Wolfe | Kentucky | 21237 | 2375 | 18 |
2206137 | 2206137 | 2022-02-11 | Childress | Texas | 48075 | 2375 | 27 |
2195297 | 2195297 | 2022-02-08 | Ralls | Missouri | 29173 | 2375 | 20 |
2179826 | 2179826 | 2022-02-03 | Luquillo | Puerto Rico | 72089 | 2375 | |
2157965 | 2157965 | 2022-01-28 | Lowndes | Alabama | 1085 | 2375 | 68 |
2154712 | 2154712 | 2022-01-27 | Lowndes | Alabama | 1085 | 2375 | 68 |
2151459 | 2151459 | 2022-01-26 | Lowndes | Alabama | 1085 | 2375 | 68 |
2148207 | 2148207 | 2022-01-25 | Lowndes | Alabama | 1085 | 2375 | 68 |
2144955 | 2144955 | 2022-01-24 | Lowndes | Alabama | 1085 | 2375 | 68 |
2110517 | 2110517 | 2022-01-13 | Pope | Minnesota | 27121 | 2375 | 14 |
2088612 | 2088612 | 2022-01-06 | Hood River | Oregon | 41027 | 2375 | 38 |
2060341 | 2060341 | 2021-12-28 | Converse | Wyoming | 56009 | 2375 | 48 |
2051014 | 2051014 | 2021-12-26 | Bleckley | Georgia | 13023 | 2375 | 84 |
2047764 | 2047764 | 2021-12-25 | Bleckley | Georgia | 13023 | 2375 | 84 |
2044514 | 2044514 | 2021-12-24 | Bleckley | Georgia | 13023 | 2375 | 84 |
2012455 | 2012455 | 2021-12-14 | Jefferson | Iowa | 19101 | 2375 | 44 |
2014769 | 2014769 | 2021-12-14 | Buffalo | Wisconsin | 55011 | 2375 | 9 |
2009204 | 2009204 | 2021-12-13 | Jefferson | Iowa | 19101 | 2375 | 44 |
2005953 | 2005953 | 2021-12-12 | Jefferson | Iowa | 19101 | 2375 | 44 |
2002702 | 2002702 | 2021-12-11 | Jefferson | Iowa | 19101 | 2375 | 44 |
1999452 | 1999452 | 2021-12-10 | Jefferson | Iowa | 19101 | 2375 | 44 |
1996201 | 1996201 | 2021-12-09 | Jefferson | Iowa | 19101 | 2375 | 44 |
1992950 | 1992950 | 2021-12-08 | Jefferson | Iowa | 19101 | 2375 | 44 |
1993215 | 1993215 | 2021-12-08 | Trigg | Kentucky | 21221 | 2375 | 28 |
1972025 | 1972025 | 2021-12-01 | Comanche | Texas | 48093 | 2375 | 66 |
1966978 | 1966978 | 2021-11-30 | Poweshiek | Iowa | 19157 | 2375 | 43 |
1963726 | 1963726 | 2021-11-29 | Poweshiek | Iowa | 19157 | 2375 | 43 |
1960475 | 1960475 | 2021-11-28 | Poweshiek | Iowa | 19157 | 2375 | 43 |
1957224 | 1957224 | 2021-11-27 | Poweshiek | Iowa | 19157 | 2375 | 43 |
1953973 | 1953973 | 2021-11-26 | Poweshiek | Iowa | 19157 | 2375 | 43 |
1950722 | 1950722 | 2021-11-25 | Poweshiek | Iowa | 19157 | 2375 | 43 |
1952226 | 1952226 | 2021-11-25 | Manati | Puerto Rico | 72091 | 2375 | |
1947471 | 1947471 | 2021-11-24 | Poweshiek | Iowa | 19157 | 2375 | 43 |
1949538 | 1949538 | 2021-11-24 | Bristol city | Virginia | 51520 | 2375 | 49 |
1942135 | 1942135 | 2021-11-22 | Ramsey | North Dakota | 38071 | 2375 | 38 |
1935128 | 1935128 | 2021-11-20 | Gasconade | Missouri | 29073 | 2375 | 77 |
1892111 | 1892111 | 2021-11-07 | Parke | Indiana | 18121 | 2375 | 31 |
1888861 | 1888861 | 2021-11-06 | Parke | Indiana | 18121 | 2375 | 31 |
1885611 | 1885611 | 2021-11-05 | Parke | Indiana | 18121 | 2375 | 31 |
1881540 | 1881540 | 2021-11-03 | Marquette | Wisconsin | 55077 | 2375 | 35 |
1857101 | 1857101 | 2021-10-27 | Yalobusha | Mississippi | 28161 | 2375 | 47 |
1851105 | 1851105 | 2021-10-25 | Warren | North Carolina | 37185 | 2375 | 31 |
1836366 | 1836366 | 2021-10-21 | Crowley | Colorado | 8025 | 2375 | 22 |
1830671 | 1830671 | 2021-10-19 | Knott | Kentucky | 21119 | 2375 | 36 |
1800381 | 1800381 | 2021-10-10 | Clay | Alabama | 1027 | 2375 | 67 |
1783272 | 1783272 | 2021-10-04 | San Lorenzo | Puerto Rico | 72129 | 2375 | |
1768019 | 1768019 | 2021-09-30 | Izard | Arkansas | 5065 | 2375 | 55 |
1755506 | 1755506 | 2021-09-26 | Edgar | Illinois | 17045 | 2375 | 65 |
1752258 | 1752258 | 2021-09-25 | Edgar | Illinois | 17045 | 2375 | 65 |
1749009 | 1749009 | 2021-09-24 | Edgar | Illinois | 17045 | 2375 | 65 |
1724434 | 1724434 | 2021-09-16 | Rolette | North Dakota | 38079 | 2375 | 28 |
1721032 | 1721032 | 2021-09-15 | Seneca | New York | 36099 | 2375 | 58 |
1718423 | 1718423 | 2021-09-14 | Benton | Tennessee | 47005 | 2375 | 44 |
1702597 | 1702597 | 2021-09-09 | Buckingham | Virginia | 51029 | 2375 | 34 |
1698476 | 1698476 | 2021-09-08 | Carroll | Ohio | 39019 | 2375 | 49 |
1694008 | 1694008 | 2021-09-07 | Kossuth | Iowa | 19109 | 2375 | 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);