ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
53 rows where cases = 7714 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 24
- Wisconsin 8
- Kansas 5
- Ohio 5
- Texas 4
- Georgia 3
- Indiana 3
- Kentucky 2
- Michigan 2
- New Jersey 2
- Oregon 2
- Pennsylvania 2
- Puerto Rico 2
- South Carolina 2
- Arizona 1
- California 1
- Florida 1
- Illinois 1
- Minnesota 1
- Missouri 1
- Montana 1
- Nebraska 1
- New Hampshire 1
- New York 1
- Washington 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2495423 | 2495423 | 2022-05-11 | Dorado | Puerto Rico | 72051 | 7714 | |
2449704 | 2449704 | 2022-04-27 | Columbia | Oregon | 41009 | 7714 | 93 |
2324748 | 2324748 | 2022-03-20 | Miami | Kansas | 20121 | 7714 | 90 |
2321494 | 2321494 | 2022-03-19 | Miami | Kansas | 20121 | 7714 | 90 |
2318240 | 2318240 | 2022-03-18 | Miami | Kansas | 20121 | 7714 | 90 |
2292539 | 2292539 | 2022-03-10 | Houghton | Michigan | 26061 | 7714 | 89 |
2289287 | 2289287 | 2022-03-09 | Houghton | Michigan | 26061 | 7714 | 89 |
2280380 | 2280380 | 2022-03-06 | Morrow | Ohio | 39117 | 7714 | 99 |
2225435 | 2225435 | 2022-02-17 | Marlboro | South Carolina | 45069 | 7714 | 100 |
2196468 | 2196468 | 2022-02-08 | Kendall | Texas | 48259 | 7714 | 109 |
2191469 | 2191469 | 2022-02-07 | Boyle | Kentucky | 21021 | 7714 | 120 |
2172052 | 2172052 | 2022-02-01 | Taylor | Kentucky | 21217 | 7714 | 106 |
2098528 | 2098528 | 2022-01-09 | Trujillo Alto | Puerto Rico | 72139 | 7714 | |
2091938 | 2091938 | 2022-01-07 | Pike | Pennsylvania | 42103 | 7714 | 75 |
2089119 | 2089119 | 2022-01-06 | Jim Wells | Texas | 48249 | 7714 | 184 |
2024013 | 2024013 | 2021-12-17 | Burnet | Texas | 48053 | 7714 | 132 |
2013688 | 2013688 | 2021-12-14 | Crawford | Ohio | 39033 | 7714 | 156 |
2000476 | 2000476 | 2021-12-10 | Livingston | New York | 36051 | 7714 | 81 |
1961668 | 1961668 | 2021-11-28 | Auglaize | Ohio | 39011 | 7714 | 115 |
1875199 | 1875199 | 2021-11-02 | Graham | Arizona | 4009 | 7714 | 119 |
1834431 | 1834431 | 2021-10-20 | Newton | Missouri | 29145 | 7714 | 125 |
1834668 | 1834668 | 2021-10-20 | Salem | New Jersey | 34033 | 7714 | 202 |
1813892 | 1813892 | 2021-10-14 | Thomas | Georgia | 13275 | 7714 | 173 |
1715296 | 1715296 | 2021-09-13 | Caldwell | Texas | 48055 | 7714 | 120 |
1688725 | 1688725 | 2021-09-05 | Ashtabula | Ohio | 39007 | 7714 | 183 |
1599745 | 1599745 | 2021-08-09 | Wayne | Indiana | 18177 | 7714 | 205 |
1491696 | 1491696 | 2021-07-06 | Chippewa | Wisconsin | 55017 | 7714 | 97 |
1488449 | 1488449 | 2021-07-05 | Chippewa | Wisconsin | 55017 | 7714 | 97 |
1485202 | 1485202 | 2021-07-04 | Chippewa | Wisconsin | 55017 | 7714 | 97 |
1481956 | 1481956 | 2021-07-03 | Chippewa | Wisconsin | 55017 | 7714 | 97 |
1478709 | 1478709 | 2021-07-02 | Chippewa | Wisconsin | 55017 | 7714 | 97 |
1475463 | 1475463 | 2021-07-01 | Chippewa | Wisconsin | 55017 | 7714 | 97 |
1343013 | 1343013 | 2021-05-22 | Walker | Georgia | 13295 | 7714 | 86 |
1253649 | 1253649 | 2021-04-24 | Erie | Ohio | 39043 | 7714 | 154 |
1224621 | 1224621 | 2021-04-15 | Clearfield | Pennsylvania | 42033 | 7714 | 131 |
1192299 | 1192299 | 2021-04-05 | Greenwood | South Carolina | 45047 | 7714 | 167 |
1174356 | 1174356 | 2021-03-31 | Hancock | Indiana | 18059 | 7714 | 140 |
1160477 | 1160477 | 2021-03-26 | Thurston | Washington | 53067 | 7714 | 83 |
1152679 | 1152679 | 2021-03-24 | Strafford | New Hampshire | 33017 | 7714 | 76 |
1044148 | 1044148 | 2021-02-19 | Sumter | Florida | 12119 | 7714 | 226 |
998294 | 998294 | 2021-02-04 | St. Croix | Wisconsin | 55109 | 7714 | 45 |
986990 | 986990 | 2021-02-01 | Missoula | Montana | 30063 | 7714 | 81 |
979452 | 979452 | 2021-01-30 | Adams | Illinois | 17001 | 7714 | 136 |
946341 | 946341 | 2021-01-19 | Manitowoc | Wisconsin | 55071 | 7714 | 70 |
811473 | 811473 | 2020-12-09 | Olmsted | Minnesota | 27109 | 7714 | 39 |
755690 | 755690 | 2020-11-22 | Porter | Indiana | 18127 | 7714 | 79 |
731217 | 731217 | 2020-11-14 | Washington | Oregon | 41067 | 7714 | 89 |
630117 | 630117 | 2020-10-14 | Lancaster | Nebraska | 31109 | 7714 | 32 |
512753 | 512753 | 2020-09-08 | Sedgwick | Kansas | 20173 | 7714 | 56 |
509520 | 509520 | 2020-09-07 | Sedgwick | Kansas | 20173 | 7714 | 56 |
486365 | 486365 | 2020-08-31 | Hall | Georgia | 13139 | 7714 | 125 |
379696 | 379696 | 2020-07-29 | Contra Costa | California | 6013 | 7714 | 109 |
291970 | 291970 | 2020-07-01 | Mercer | New Jersey | 34021 | 7714 | 579 |
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);