ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
43 rows where cases = 7673 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 23
- Michigan 11
- Virginia 5
- Pennsylvania 3
- Texas 3
- Florida 2
- Wisconsin 2
- Alabama 1
- Arizona 1
- Arkansas 1
- California 1
- Colorado 1
- Connecticut 1
- Maryland 1
- Minnesota 1
- Missouri 1
- Montana 1
- New Mexico 1
- North Carolina 1
- Ohio 1
- Oklahoma 1
- Oregon 1
- Utah 1
- Washington 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2470294 | 2470294 | 2022-05-04 | Lawrence | Alabama | 1079 | 7673 | 158 |
2382282 | 2382282 | 2022-04-06 | Juneau | Wisconsin | 55057 | 7673 | 68 |
2359060 | 2359060 | 2022-03-30 | Hockley | Texas | 48219 | 7673 | 161 |
2294122 | 2294122 | 2022-03-10 | Upshur | Texas | 48459 | 7673 | 178 |
2263813 | 2263813 | 2022-03-01 | Cibola | New Mexico | 35006 | 7673 | 178 |
2231607 | 2231607 | 2022-02-19 | Morrow | Ohio | 39117 | 7673 | 91 |
2193486 | 2193486 | 2022-02-07 | Prince George | Virginia | 51149 | 7673 | 59 |
2189960 | 2189960 | 2022-02-06 | Kendall | Texas | 48259 | 7673 | 108 |
2084519 | 2084519 | 2022-01-05 | Steele | Minnesota | 27147 | 7673 | 43 |
2063888 | 2063888 | 2021-12-30 | La Plata | Colorado | 8067 | 7673 | 67 |
1985298 | 1985298 | 2021-12-05 | Campbell | Virginia | 51031 | 7673 | 149 |
1982048 | 1982048 | 2021-12-04 | Campbell | Virginia | 51031 | 7673 | 149 |
1978798 | 1978798 | 2021-12-03 | Campbell | Virginia | 51031 | 7673 | 149 |
1912355 | 1912355 | 2021-11-13 | Callaway | Missouri | 29027 | 7673 | 72 |
1762650 | 1762650 | 2021-09-28 | Gratiot | Michigan | 26057 | 7673 | 127 |
1759401 | 1759401 | 2021-09-27 | Gratiot | Michigan | 26057 | 7673 | 127 |
1679945 | 1679945 | 2021-09-02 | Rockingham | Virginia | 51165 | 7673 | 116 |
1532004 | 1532004 | 2021-07-19 | Clinton | Michigan | 26037 | 7673 | 95 |
1528757 | 1528757 | 2021-07-18 | Clinton | Michigan | 26037 | 7673 | 95 |
1525510 | 1525510 | 2021-07-17 | Clinton | Michigan | 26037 | 7673 | 95 |
1522263 | 1522263 | 2021-07-16 | Clinton | Michigan | 26037 | 7673 | 95 |
1519014 | 1519014 | 2021-07-15 | Clinton | Michigan | 26037 | 7673 | 95 |
1515767 | 1515767 | 2021-07-14 | Clinton | Michigan | 26037 | 7673 | 95 |
1512521 | 1512521 | 2021-07-13 | Clinton | Michigan | 26037 | 7673 | 95 |
1471956 | 1471956 | 2021-06-30 | Tooele | Utah | 49045 | 7673 | 44 |
1451886 | 1451886 | 2021-06-24 | Lawrence | Pennsylvania | 42073 | 7673 | 216 |
1366427 | 1366427 | 2021-05-29 | Wicomico | Maryland | 24045 | 7673 | 171 |
1248709 | 1248709 | 2021-04-23 | Walton | Florida | 12131 | 7673 | 87 |
1221374 | 1221374 | 2021-04-14 | Clearfield | Pennsylvania | 42033 | 7673 | 131 |
1119674 | 1119674 | 2021-03-14 | Bay | Michigan | 26017 | 7673 | 297 |
1116427 | 1116427 | 2021-03-13 | Bay | Michigan | 26017 | 7673 | 297 |
1068708 | 1068708 | 2021-02-26 | Wagoner | Oklahoma | 40145 | 7673 | 80 |
1064862 | 1064862 | 2021-02-25 | Cascade | Montana | 30013 | 7673 | 150 |
1060165 | 1060165 | 2021-02-24 | Pope | Arkansas | 5115 | 7673 | 101 |
1053820 | 1053820 | 2021-02-22 | Tolland | Connecticut | 9013 | 7673 | 161 |
1029850 | 1029850 | 2021-02-14 | Northumberland | Pennsylvania | 42097 | 7673 | 312 |
1000570 | 1000570 | 2021-02-05 | Jackson | Oregon | 41029 | 7673 | 105 |
946614 | 946614 | 2021-01-20 | Napa | California | 6055 | 7673 | 44 |
939849 | 939849 | 2021-01-17 | Manitowoc | Wisconsin | 55071 | 7673 | 68 |
888079 | 888079 | 2021-01-02 | Cochise | Arizona | 4003 | 7673 | 136 |
556924 | 556924 | 2020-09-21 | Snohomish | Washington | 53061 | 7673 | 221 |
529888 | 529888 | 2020-09-13 | Guilford | North Carolina | 37081 | 7673 | 174 |
453976 | 453976 | 2020-08-21 | Seminole | Florida | 12117 | 7673 | 160 |
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);