ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
53 rows where cases = 6979 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2491183 | 2491183 | 2022-05-10 | Nobles | Minnesota | 27105 | 6979 | 60 |
2474439 | 2474439 | 2022-05-05 | Franklin | Kansas | 20059 | 6979 | 81 |
2471182 | 2471182 | 2022-05-04 | Franklin | Kansas | 20059 | 6979 | 81 |
2467926 | 2467926 | 2022-05-03 | Franklin | Kansas | 20059 | 6979 | 81 |
2464671 | 2464671 | 2022-05-02 | Franklin | Kansas | 20059 | 6979 | 81 |
2461415 | 2461415 | 2022-05-01 | Franklin | Kansas | 20059 | 6979 | 81 |
2458159 | 2458159 | 2022-04-30 | Franklin | Kansas | 20059 | 6979 | 81 |
2454903 | 2454903 | 2022-04-29 | Franklin | Kansas | 20059 | 6979 | 81 |
2291204 | 2291204 | 2022-03-09 | Lincoln | Wisconsin | 55069 | 6979 | 142 |
2218771 | 2218771 | 2022-02-15 | Elk | Pennsylvania | 42047 | 6979 | 94 |
2190130 | 2190130 | 2022-02-06 | Windsor | Vermont | 50027 | 6979 | 47 |
2186877 | 2186877 | 2022-02-05 | Windsor | Vermont | 50027 | 6979 | 47 |
2183624 | 2183624 | 2022-02-04 | Windsor | Vermont | 50027 | 6979 | 47 |
2147770 | 2147770 | 2022-01-24 | Upshur | Texas | 48459 | 6979 | 162 |
2080655 | 2080655 | 2022-01-04 | Wabash | Indiana | 18169 | 6979 | 131 |
2079043 | 2079043 | 2022-01-03 | Chester | South Carolina | 45023 | 6979 | 124 |
2075792 | 2075792 | 2022-01-02 | Chester | South Carolina | 45023 | 6979 | 124 |
2072541 | 2072541 | 2022-01-01 | Chester | South Carolina | 45023 | 6979 | 124 |
2066976 | 2066976 | 2021-12-31 | Boone | Arkansas | 5009 | 6979 | 139 |
2068710 | 2068710 | 2021-12-31 | Allegany | New York | 36003 | 6979 | 137 |
2069290 | 2069290 | 2021-12-31 | Chester | South Carolina | 45023 | 6979 | 124 |
2054150 | 2054150 | 2021-12-27 | Montrose | Colorado | 8085 | 6979 | 138 |
2040488 | 2040488 | 2021-12-22 | Wood | Texas | 48499 | 6979 | 238 |
1940105 | 1940105 | 2021-11-22 | Chilton | Alabama | 1021 | 6979 | 170 |
1875041 | 1875041 | 2021-11-01 | Marinette | Wisconsin | 55075 | 6979 | 80 |
1814913 | 1814913 | 2021-10-14 | Johnson | Missouri | 29101 | 6979 | 72 |
1697166 | 1697166 | 2021-09-08 | Noble | Indiana | 18113 | 6979 | 101 |
1643420 | 1643420 | 2021-08-22 | Douglas | Oregon | 41019 | 6979 | 109 |
1640170 | 1640170 | 2021-08-21 | Douglas | Oregon | 41019 | 6979 | 109 |
1636920 | 1636920 | 2021-08-20 | Douglas | Oregon | 41019 | 6979 | 109 |
1585246 | 1585246 | 2021-08-04 | Carter | Tennessee | 47019 | 6979 | 164 |
1519886 | 1519886 | 2021-07-15 | Ross | Ohio | 39141 | 6979 | 165 |
1426163 | 1426163 | 2021-06-16 | Coffee | Tennessee | 47031 | 6979 | 123 |
1422916 | 1422916 | 2021-06-15 | Coffee | Tennessee | 47031 | 6979 | 123 |
1350173 | 1350173 | 2021-05-24 | Allegany | Maryland | 24001 | 6979 | 208 |
1211796 | 1211796 | 2021-04-11 | Laurens | South Carolina | 45059 | 6979 | 165 |
1204707 | 1204707 | 2021-04-09 | Chemung | New York | 36015 | 6979 | 133 |
1134392 | 1134392 | 2021-03-18 | Hanover | Virginia | 51085 | 6979 | 147 |
1131133 | 1131133 | 2021-03-17 | Frederick | Virginia | 51069 | 6979 | 96 |
1124980 | 1124980 | 2021-03-16 | Walker | Alabama | 1127 | 6979 | 268 |
1067018 | 1067018 | 2021-02-26 | Troup | Georgia | 13285 | 6979 | 199 |
999035 | 999035 | 2021-02-05 | Bartholomew | Indiana | 18005 | 6979 | 143 |
984270 | 984270 | 2021-01-31 | Garfield | Oklahoma | 40047 | 6979 | 60 |
849454 | 849454 | 2020-12-21 | Carroll | Georgia | 13045 | 6979 | 110 |
837573 | 837573 | 2020-12-17 | Cape Girardeau | Missouri | 29031 | 6979 | 97 |
793229 | 793229 | 2020-12-03 | Sullivan | Tennessee | 47163 | 6979 | 111 |
693607 | 693607 | 2020-11-03 | Bay | Florida | 12005 | 6979 | 135 |
686452 | 686452 | 2020-10-31 | Weber | Utah | 49057 | 6979 | 33 |
585458 | 585458 | 2020-09-30 | Spartanburg | South Carolina | 45083 | 6979 | 199 |
569063 | 569063 | 2020-09-25 | Berks | Pennsylvania | 42011 | 6979 | 393 |
555283 | 555283 | 2020-09-21 | Hinds | Mississippi | 28049 | 6979 | 155 |
334837 | 334837 | 2020-07-15 | Kern | California | 6029 | 6979 | 98 |
296734 | 296734 | 2020-07-03 | Imperial | California | 6025 | 6979 | 104 |
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);