ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
149 rows where cases = 3589 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Indiana 19
- Mississippi 13
- Missouri 10
- Illinois 9
- Tennessee 9
- New York 7
- North Carolina 7
- Texas 7
- Nebraska 6
- Wisconsin 6
- Georgia 5
- Michigan 5
- Minnesota 5
- Ohio 5
- Alabama 4
- Kentucky 4
- Iowa 3
- Puerto Rico 3
- South Carolina 3
- Arkansas 2
- California 2
- Kansas 2
- Louisiana 2
- Oklahoma 2
- Virginia 2
- Wyoming 2
- Colorado 1
- New Mexico 1
- Oregon 1
- Pennsylvania 1
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2497717 | 2497717 | 2022-05-12 | Sibley | Minnesota | 27143 | 3589 | 24 |
2484742 | 2484742 | 2022-05-08 | Lawrence | Mississippi | 28077 | 3589 | 56 |
2481484 | 2481484 | 2022-05-07 | Lawrence | Mississippi | 28077 | 3589 | 56 |
2478226 | 2478226 | 2022-05-06 | Lawrence | Mississippi | 28077 | 3589 | 56 |
2474968 | 2474968 | 2022-05-05 | Lawrence | Mississippi | 28077 | 3589 | 56 |
2471711 | 2471711 | 2022-05-04 | Lawrence | Mississippi | 28077 | 3589 | 56 |
2468455 | 2468455 | 2022-05-03 | Lawrence | Mississippi | 28077 | 3589 | 56 |
2465200 | 2465200 | 2022-05-02 | Lawrence | Mississippi | 28077 | 3589 | 56 |
2461944 | 2461944 | 2022-05-01 | Lawrence | Mississippi | 28077 | 3589 | 56 |
2458688 | 2458688 | 2022-04-30 | Lawrence | Mississippi | 28077 | 3589 | 56 |
2455432 | 2455432 | 2022-04-29 | Lawrence | Mississippi | 28077 | 3589 | 56 |
2452176 | 2452176 | 2022-04-28 | Lawrence | Mississippi | 28077 | 3589 | 56 |
2448920 | 2448920 | 2022-04-27 | Lawrence | Mississippi | 28077 | 3589 | 56 |
2445664 | 2445664 | 2022-04-26 | Lawrence | Mississippi | 28077 | 3589 | 56 |
2430177 | 2430177 | 2022-04-21 | Hood River | Oregon | 41027 | 3589 | 43 |
2419866 | 2419866 | 2022-04-18 | Gage | Nebraska | 31067 | 3589 | 44 |
2415669 | 2415669 | 2022-04-17 | Parke | Indiana | 18121 | 3589 | 46 |
2416611 | 2416611 | 2022-04-17 | Gage | Nebraska | 31067 | 3589 | 44 |
2412413 | 2412413 | 2022-04-16 | Parke | Indiana | 18121 | 3589 | 46 |
2413355 | 2413355 | 2022-04-16 | Gage | Nebraska | 31067 | 3589 | 44 |
2409157 | 2409157 | 2022-04-15 | Parke | Indiana | 18121 | 3589 | 46 |
2410099 | 2410099 | 2022-04-15 | Gage | Nebraska | 31067 | 3589 | 44 |
2405901 | 2405901 | 2022-04-14 | Parke | Indiana | 18121 | 3589 | 46 |
2406843 | 2406843 | 2022-04-14 | Gage | Nebraska | 31067 | 3589 | 44 |
2402162 | 2402162 | 2022-04-13 | Las Animas | Colorado | 8071 | 3589 | 41 |
2402646 | 2402646 | 2022-04-13 | Parke | Indiana | 18121 | 3589 | 52 |
2403587 | 2403587 | 2022-04-13 | Gage | Nebraska | 31067 | 3589 | 44 |
2399391 | 2399391 | 2022-04-12 | Parke | Indiana | 18121 | 3589 | 52 |
2396136 | 2396136 | 2022-04-11 | Parke | Indiana | 18121 | 3589 | 52 |
2392880 | 2392880 | 2022-04-10 | Parke | Indiana | 18121 | 3589 | 52 |
2389624 | 2389624 | 2022-04-09 | Parke | Indiana | 18121 | 3589 | 52 |
2386369 | 2386369 | 2022-04-08 | Parke | Indiana | 18121 | 3589 | 52 |
2355706 | 2355706 | 2022-03-29 | Bandera | Texas | 48019 | 3589 | 75 |
2348124 | 2348124 | 2022-03-27 | Madison | Missouri | 29123 | 3589 | 57 |
2344871 | 2344871 | 2022-03-26 | Madison | Missouri | 29123 | 3589 | 57 |
2341618 | 2341618 | 2022-03-25 | Madison | Missouri | 29123 | 3589 | 57 |
2338365 | 2338365 | 2022-03-24 | Madison | Missouri | 29123 | 3589 | 57 |
2334182 | 2334182 | 2022-03-23 | Greene | Illinois | 17061 | 3589 | 57 |
2271734 | 2271734 | 2022-03-03 | Goshen | Wyoming | 56015 | 3589 | 56 |
2244048 | 2244048 | 2022-02-23 | Macon | Missouri | 29121 | 3589 | 48 |
2236024 | 2236024 | 2022-02-21 | Lamar | Alabama | 1075 | 3589 | 63 |
2164454 | 2164454 | 2022-01-30 | Crenshaw | Alabama | 1041 | 3589 | 82 |
2157409 | 2157409 | 2022-01-27 | Houston | Texas | 48225 | 3589 | 96 |
2151108 | 2151108 | 2022-01-25 | Bristol city | Virginia | 51520 | 3589 | 62 |
2103237 | 2103237 | 2022-01-11 | Cass | Illinois | 17017 | 3589 | 41 |
2075742 | 2075742 | 2022-01-02 | Manati | Puerto Rico | 72091 | 3589 | |
2058082 | 2058082 | 2021-12-28 | Pottawatomie | Kansas | 20149 | 3589 | 47 |
2054833 | 2054833 | 2021-12-27 | Pottawatomie | Kansas | 20149 | 3589 | 47 |
2051927 | 2051927 | 2021-12-26 | Roscommon | Michigan | 26143 | 3589 | 99 |
2048677 | 2048677 | 2021-12-25 | Roscommon | Michigan | 26143 | 3589 | 99 |
2045427 | 2045427 | 2021-12-24 | Roscommon | Michigan | 26143 | 3589 | 99 |
2042177 | 2042177 | 2021-12-23 | Roscommon | Michigan | 26143 | 3589 | 99 |
2038928 | 2038928 | 2021-12-22 | Roscommon | Michigan | 26143 | 3589 | 99 |
2021328 | 2021328 | 2021-12-16 | Vilas | Wisconsin | 55125 | 3589 | 65 |
1986366 | 1986366 | 2021-12-06 | Owen | Indiana | 18119 | 3589 | 80 |
1965393 | 1965393 | 2021-11-29 | Chester | Tennessee | 47023 | 3589 | 76 |
1943879 | 1943879 | 2021-11-23 | Union | Georgia | 13291 | 3589 | 129 |
1937966 | 1937966 | 2021-11-21 | Woodford | Kentucky | 21239 | 3589 | 30 |
1934716 | 1934716 | 2021-11-20 | Woodford | Kentucky | 21239 | 3589 | 30 |
1931465 | 1931465 | 2021-11-19 | Woodford | Kentucky | 21239 | 3589 | 30 |
1831706 | 1831706 | 2021-10-19 | Henry | Ohio | 39069 | 3589 | 71 |
1820015 | 1820015 | 2021-10-16 | Logan | Arkansas | 5083 | 3589 | 42 |
1784246 | 1784246 | 2021-10-05 | Cleburne | Arkansas | 5023 | 3589 | 89 |
1758793 | 1758793 | 2021-09-27 | McDonough | Illinois | 17109 | 3589 | 68 |
1734020 | 1734020 | 2021-09-19 | Orleans | New York | 36073 | 3589 | 83 |
1713789 | 1713789 | 2021-09-13 | Grant | Louisiana | 22043 | 3589 | 72 |
1697582 | 1697582 | 2021-09-08 | Union | Louisiana | 22111 | 3589 | 92 |
1697996 | 1697996 | 2021-09-08 | Saline | Missouri | 29195 | 3589 | 44 |
1677410 | 1677410 | 2021-09-02 | Peach | Georgia | 13225 | 3589 | 75 |
1654970 | 1654970 | 2021-08-26 | White | Indiana | 18181 | 3589 | 56 |
1647580 | 1647580 | 2021-08-23 | Wayne | West Virginia | 54099 | 3589 | 48 |
1614020 | 1614020 | 2021-08-13 | Champaign | Ohio | 39021 | 3589 | 60 |
1584042 | 1584042 | 2021-08-04 | Carlton | Minnesota | 27017 | 3589 | 58 |
1581864 | 1581864 | 2021-08-03 | Vega Baja | Puerto Rico | 72145 | 3589 | |
1565034 | 1565034 | 2021-07-29 | Cibola | New Mexico | 35006 | 3589 | 128 |
1556037 | 1556037 | 2021-07-26 | Hardeman | Tennessee | 47069 | 3589 | 64 |
1535904 | 1535904 | 2021-07-20 | Bladen | North Carolina | 37017 | 3589 | 53 |
1477451 | 1477451 | 2021-07-02 | Wyoming | New York | 36121 | 3589 | 53 |
1474205 | 1474205 | 2021-07-01 | Wyoming | New York | 36121 | 3589 | 53 |
1470076 | 1470076 | 2021-06-30 | Calloway | Kentucky | 21035 | 3589 | 50 |
1441393 | 1441393 | 2021-06-21 | Howell | Missouri | 29091 | 3589 | 45 |
1372481 | 1372481 | 2021-05-31 | Wabash | Indiana | 18169 | 3589 | 82 |
1369236 | 1369236 | 2021-05-30 | Wabash | Indiana | 18169 | 3589 | 82 |
1365990 | 1365990 | 2021-05-29 | Wabash | Indiana | 18169 | 3589 | 82 |
1362744 | 1362744 | 2021-05-28 | Wabash | Indiana | 18169 | 3589 | 81 |
1361271 | 1361271 | 2021-05-27 | Hardin | Tennessee | 47071 | 3589 | 68 |
1351533 | 1351533 | 2021-05-24 | Hardin | Tennessee | 47071 | 3589 | 68 |
1325556 | 1325556 | 2021-05-16 | Hardin | Tennessee | 47071 | 3589 | 68 |
1322310 | 1322310 | 2021-05-15 | Hardin | Tennessee | 47071 | 3589 | 68 |
1319064 | 1319064 | 2021-05-14 | Hardin | Tennessee | 47071 | 3589 | 68 |
1298388 | 1298388 | 2021-05-08 | Lyon | Minnesota | 27083 | 3589 | 50 |
1291071 | 1291071 | 2021-05-06 | Wayne | Georgia | 13305 | 3589 | 88 |
1288893 | 1288893 | 2021-05-05 | Webster | Missouri | 29225 | 3589 | 54 |
1289236 | 1289236 | 2021-05-05 | Jackson | North Carolina | 37099 | 3589 | 56 |
1279439 | 1279439 | 2021-05-02 | Tioga | New York | 36107 | 3589 | 61 |
1276726 | 1276726 | 2021-05-01 | Colleton | South Carolina | 45029 | 3589 | 126 |
1261914 | 1261914 | 2021-04-27 | Bureau | Illinois | 17011 | 3589 | 95 |
1258466 | 1258466 | 2021-04-26 | Bryan | Georgia | 13029 | 3589 | 37 |
1238048 | 1238048 | 2021-04-19 | Grimes | Texas | 48185 | 3589 | 66 |
1234801 | 1234801 | 2021-04-18 | Grimes | Texas | 48185 | 3589 | 66 |
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);