ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
150 rows where cases = 3214 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Ohio 12
- Oregon 10
- Georgia 9
- Tennessee 9
- Arkansas 8
- Kentucky 8
- Virginia 8
- Mississippi 7
- Texas 7
- Alabama 6
- Louisiana 6
- North Dakota 6
- Illinois 4
- Minnesota 4
- Pennsylvania 4
- Wisconsin 4
- Indiana 3
- Kansas 3
- North Carolina 3
- Oklahoma 3
- Puerto Rico 3
- Florida 2
- Michigan 2
- Missouri 2
- Montana 2
- New Mexico 2
- New York 2
- South Dakota 2
- Utah 2
- California 1
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2452956 | 2452956 | 2022-04-28 | Baker | Oregon | 41001 | 3214 | 48 |
2449700 | 2449700 | 2022-04-27 | Baker | Oregon | 41001 | 3214 | 48 |
2446443 | 2446443 | 2022-04-26 | Baker | Oregon | 41001 | 3214 | 48 |
2443188 | 2443188 | 2022-04-25 | Baker | Oregon | 41001 | 3214 | 48 |
2439932 | 2439932 | 2022-04-24 | Baker | Oregon | 41001 | 3214 | 48 |
2436676 | 2436676 | 2022-04-23 | Baker | Oregon | 41001 | 3214 | 48 |
2433420 | 2433420 | 2022-04-22 | Baker | Oregon | 41001 | 3214 | 48 |
2430164 | 2430164 | 2022-04-21 | Baker | Oregon | 41001 | 3214 | 48 |
2360919 | 2360919 | 2022-03-31 | Cottonwood | Minnesota | 27033 | 3214 | 41 |
2358421 | 2358421 | 2022-03-30 | Harrison | Ohio | 39067 | 3214 | 74 |
2355167 | 2355167 | 2022-03-29 | Harrison | Ohio | 39067 | 3214 | 74 |
2351914 | 2351914 | 2022-03-28 | Harrison | Ohio | 39067 | 3214 | 74 |
2348662 | 2348662 | 2022-03-27 | Harrison | Ohio | 39067 | 3214 | 74 |
2345409 | 2345409 | 2022-03-26 | Harrison | Ohio | 39067 | 3214 | 74 |
2342156 | 2342156 | 2022-03-25 | Harrison | Ohio | 39067 | 3214 | 74 |
2338903 | 2338903 | 2022-03-24 | Harrison | Ohio | 39067 | 3214 | 74 |
2286798 | 2286798 | 2022-03-08 | Mountrail | North Dakota | 38061 | 3214 | 36 |
2287799 | 2287799 | 2022-03-08 | Rockbridge | Virginia | 51163 | 3214 | 75 |
2283546 | 2283546 | 2022-03-07 | Mountrail | North Dakota | 38061 | 3214 | 36 |
2279675 | 2279675 | 2022-03-06 | Amite | Mississippi | 28005 | 3214 | 67 |
2280294 | 2280294 | 2022-03-06 | Mountrail | North Dakota | 38061 | 3214 | 36 |
2280664 | 2280664 | 2022-03-06 | Utuado | Puerto Rico | 72141 | 3214 | |
2276422 | 2276422 | 2022-03-05 | Amite | Mississippi | 28005 | 3214 | 67 |
2277041 | 2277041 | 2022-03-05 | Mountrail | North Dakota | 38061 | 3214 | 36 |
2273169 | 2273169 | 2022-03-04 | Amite | Mississippi | 28005 | 3214 | 67 |
2260401 | 2260401 | 2022-02-28 | Roosevelt | Montana | 30085 | 3214 | 70 |
2255644 | 2255644 | 2022-02-27 | Little River | Arkansas | 5081 | 3214 | 87 |
2225015 | 2225015 | 2022-02-17 | McKenzie | North Dakota | 38053 | 3214 | 25 |
2219173 | 2219173 | 2022-02-15 | Duval | Texas | 48131 | 3214 | 67 |
2188157 | 2188157 | 2022-02-06 | Marion | Kansas | 20115 | 3214 | 39 |
2190187 | 2190187 | 2022-02-06 | Greensville | Virginia | 51081 | 3214 | 31 |
2184904 | 2184904 | 2022-02-05 | Marion | Kansas | 20115 | 3214 | 39 |
2186934 | 2186934 | 2022-02-05 | Greensville | Virginia | 51081 | 3214 | 31 |
2181652 | 2181652 | 2022-02-04 | Marion | Kansas | 20115 | 3214 | 39 |
2183681 | 2183681 | 2022-02-04 | Greensville | Virginia | 51081 | 3214 | 31 |
2160781 | 2160781 | 2022-01-28 | Tyler | Texas | 48457 | 3214 | 75 |
2152480 | 2152480 | 2022-01-26 | Larue | Kentucky | 21123 | 3214 | 60 |
2152504 | 2152504 | 2022-01-26 | Monroe | Kentucky | 21171 | 3214 | 69 |
2109250 | 2109250 | 2022-01-13 | Clay | Arkansas | 5021 | 3214 | 77 |
2111174 | 2111174 | 2022-01-13 | Richland | North Dakota | 38077 | 3214 | 21 |
2107072 | 2107072 | 2022-01-12 | Lincoln | Maine | 23015 | 3214 | 16 |
2105365 | 2105365 | 2022-01-11 | Houston | Texas | 48225 | 3214 | 91 |
2054475 | 2054475 | 2021-12-27 | Clark | Illinois | 17023 | 3214 | 54 |
2043887 | 2043887 | 2021-12-23 | Powhatan | Virginia | 51145 | 3214 | 31 |
2008389 | 2008389 | 2021-12-13 | Hale | Alabama | 1065 | 3214 | 89 |
2005138 | 2005138 | 2021-12-12 | Hale | Alabama | 1065 | 3214 | 89 |
1933720 | 1933720 | 2021-11-20 | Conway | Arkansas | 5029 | 3214 | 46 |
1930455 | 1930455 | 2021-11-19 | Ashley | Arkansas | 5003 | 3214 | 50 |
1900462 | 1900462 | 2021-11-09 | Union | Tennessee | 47173 | 3214 | 48 |
1856146 | 1856146 | 2021-10-27 | Washington | Georgia | 13303 | 3214 | 118 |
1853492 | 1853492 | 2021-10-26 | Concordia | Louisiana | 22029 | 3214 | 78 |
1849648 | 1849648 | 2021-10-25 | Washington | Georgia | 13303 | 3214 | 117 |
1830009 | 1830009 | 2021-10-19 | Ben Hill | Georgia | 13017 | 3214 | 100 |
1814774 | 1814774 | 2021-10-14 | Waseca | Minnesota | 27161 | 3214 | 29 |
1811121 | 1811121 | 2021-10-13 | Anderson | Kentucky | 21005 | 3214 | 40 |
1806539 | 1806539 | 2021-10-11 | Washington | Vermont | 50023 | 3214 | 18 |
1785570 | 1785570 | 2021-10-05 | Jasper | Mississippi | 28061 | 3214 | 62 |
1764676 | 1764676 | 2021-09-29 | Monroe | Alabama | 1099 | 3214 | 55 |
1762495 | 1762495 | 2021-09-28 | Wayne | Kentucky | 21231 | 3214 | 57 |
1759247 | 1759247 | 2021-09-27 | Wayne | Kentucky | 21231 | 3214 | 57 |
1757024 | 1757024 | 2021-09-26 | Van Wert | Ohio | 39161 | 3214 | 71 |
1747379 | 1747379 | 2021-09-23 | Jefferson | Oregon | 41031 | 3214 | 47 |
1732183 | 1732183 | 2021-09-19 | Marengo | Alabama | 1091 | 3214 | 81 |
1735307 | 1735307 | 2021-09-19 | Door | Wisconsin | 55029 | 3214 | 38 |
1732057 | 1732057 | 2021-09-18 | Door | Wisconsin | 55029 | 3214 | 38 |
1728807 | 1728807 | 2021-09-17 | Door | Wisconsin | 55029 | 3214 | 38 |
1712108 | 1712108 | 2021-09-12 | Gillespie | Texas | 48171 | 3214 | 65 |
1708861 | 1708861 | 2021-09-11 | Gillespie | Texas | 48171 | 3214 | 64 |
1705614 | 1705614 | 2021-09-10 | Gillespie | Texas | 48171 | 3214 | 64 |
1665506 | 1665506 | 2021-08-29 | Randolph | Missouri | 29175 | 3214 | 34 |
1654698 | 1654698 | 2021-08-26 | Tattnall | Georgia | 13267 | 3214 | 80 |
1653475 | 1653475 | 2021-08-25 | DeKalb | Tennessee | 47041 | 3214 | 58 |
1650228 | 1650228 | 2021-08-24 | DeKalb | Tennessee | 47041 | 3214 | 58 |
1650739 | 1650739 | 2021-08-24 | Wythe | Virginia | 51197 | 3214 | 84 |
1647039 | 1647039 | 2021-08-23 | Smith | Tennessee | 47159 | 3214 | 40 |
1634052 | 1634052 | 2021-08-19 | Wayne | Tennessee | 47181 | 3214 | 36 |
1576641 | 1576641 | 2021-08-02 | Dawson | Georgia | 13085 | 3214 | 49 |
1564371 | 1564371 | 2021-07-29 | Morehouse | Louisiana | 22067 | 3214 | 80 |
1560994 | 1560994 | 2021-07-28 | Clark | Kentucky | 21049 | 3214 | 32 |
1539518 | 1539518 | 2021-07-21 | Clarion | Pennsylvania | 42031 | 3214 | 96 |
1540227 | 1540227 | 2021-07-21 | Isle of Wight | Virginia | 51093 | 3214 | 70 |
1473779 | 1473779 | 2021-07-01 | Scott | Mississippi | 28123 | 3214 | 74 |
1466992 | 1466992 | 2021-06-29 | Vernon | Louisiana | 22115 | 3214 | 105 |
1467108 | 1467108 | 2021-06-29 | Mecosta | Michigan | 26107 | 3214 | 36 |
1440437 | 1440437 | 2021-06-21 | Latah | Idaho | 16057 | 3214 | 11 |
1439340 | 1439340 | 2021-06-20 | Hopkins | Texas | 48223 | 3214 | 114 |
1408019 | 1408019 | 2021-06-11 | Fayette | Illinois | 17051 | 3214 | 58 |
1401015 | 1401015 | 2021-06-09 | Baxter | Arkansas | 5005 | 3214 | 104 |
1356585 | 1356585 | 2021-05-26 | Allen | Louisiana | 22003 | 3214 | 92 |
1353011 | 1353011 | 2021-05-25 | White | Indiana | 18181 | 3214 | 54 |
1335309 | 1335309 | 2021-05-19 | Lauderdale | Tennessee | 47097 | 3214 | 45 |
1329295 | 1329295 | 2021-05-17 | Wise | Virginia | 51195 | 3214 | 98 |
1291906 | 1291906 | 2021-05-06 | Nicollet | Minnesota | 27103 | 3214 | 43 |
1278078 | 1278078 | 2021-05-02 | Unknown | Georgia | 3214 | 14 | |
1270280 | 1270280 | 2021-04-29 | Davison | South Dakota | 46035 | 3214 | 67 |
1261452 | 1261452 | 2021-04-27 | Jackson | Arkansas | 5067 | 3214 | 38 |
1255299 | 1255299 | 2021-04-25 | Madison | Georgia | 13195 | 3214 | 56 |
1257219 | 1257219 | 2021-04-25 | Vega Baja | Puerto Rico | 72145 | 3214 | |
1248464 | 1248464 | 2021-04-23 | Jackson | Arkansas | 5067 | 3214 | 38 |
1245217 | 1245217 | 2021-04-22 | Jackson | Arkansas | 5067 | 3214 | 38 |
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);