ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
81 rows where cases = 5657 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 28
- Georgia 10
- Virginia 9
- Michigan 8
- Oklahoma 8
- Missouri 6
- Minnesota 4
- Texas 4
- New Hampshire 3
- Ohio 3
- Vermont 3
- Colorado 2
- Florida 2
- Kansas 2
- Tennessee 2
- Wisconsin 2
- Alabama 1
- Arizona 1
- Arkansas 1
- California 1
- Illinois 1
- Kentucky 1
- Louisiana 1
- Maine 1
- New York 1
- North Carolina 1
- Pennsylvania 1
- South Carolina 1
- Washington 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2484660 | 2484660 | 2022-05-08 | Martin | Minnesota | 27091 | 5657 | 64 |
2481402 | 2481402 | 2022-05-07 | Martin | Minnesota | 27091 | 5657 | 64 |
2478144 | 2478144 | 2022-05-06 | Martin | Minnesota | 27091 | 5657 | 64 |
2418449 | 2418449 | 2022-04-18 | Morgan | Colorado | 8087 | 5657 | 135 |
2417949 | 2417949 | 2022-04-17 | Salem city | Virginia | 51775 | 5657 | 96 |
2414693 | 2414693 | 2022-04-16 | Salem city | Virginia | 51775 | 5657 | 96 |
2411437 | 2411437 | 2022-04-15 | Salem city | Virginia | 51775 | 5657 | 96 |
2408323 | 2408323 | 2022-04-14 | Jackson | Wisconsin | 55053 | 5657 | 43 |
2379096 | 2379096 | 2022-04-06 | Barbour | Alabama | 1005 | 5657 | 98 |
2375502 | 2375502 | 2022-04-04 | Caledonia | Vermont | 50005 | 5657 | 24 |
2364019 | 2364019 | 2022-04-01 | Franklin | Maine | 23007 | 5657 | 57 |
2323174 | 2323174 | 2022-03-19 | Austin | Texas | 48015 | 5657 | 72 |
2308516 | 2308516 | 2022-03-15 | Sumner | Kansas | 20191 | 5657 | 66 |
2305265 | 2305265 | 2022-03-14 | Sumner | Kansas | 20191 | 5657 | 66 |
2291376 | 2291376 | 2022-03-10 | Arkansas | Arkansas | 5001 | 5657 | 78 |
2288516 | 2288516 | 2022-03-09 | Pierce | Georgia | 13229 | 5657 | 125 |
2248430 | 2248430 | 2022-02-24 | Dimmit | Texas | 48127 | 5657 | 50 |
2243990 | 2243990 | 2022-02-23 | Audrain | Missouri | 29007 | 5657 | 101 |
2237526 | 2237526 | 2022-02-21 | Henry | Missouri | 29083 | 5657 | 77 |
2234275 | 2234275 | 2022-02-20 | Henry | Missouri | 29083 | 5657 | 77 |
2231024 | 2231024 | 2022-02-19 | Henry | Missouri | 29083 | 5657 | 77 |
2227773 | 2227773 | 2022-02-18 | Henry | Missouri | 29083 | 5657 | 77 |
2193455 | 2193455 | 2022-02-07 | Lee | Virginia | 51105 | 5657 | 76 |
2182309 | 2182309 | 2022-02-04 | Washington | Missouri | 29221 | 5657 | 117 |
2154419 | 2154419 | 2022-01-26 | Louisa | Virginia | 51109 | 5657 | 55 |
2128936 | 2128936 | 2022-01-19 | Pitkin | Colorado | 8097 | 5657 | 6 |
2129727 | 2129727 | 2022-01-19 | Mercer | Kentucky | 21167 | 5657 | 95 |
2082781 | 2082781 | 2022-01-04 | Franklin | Vermont | 50011 | 5657 | 57 |
2058496 | 2058496 | 2021-12-28 | Pine | Minnesota | 27115 | 5657 | 48 |
2059281 | 2059281 | 2021-12-28 | Custer | Oklahoma | 40039 | 5657 | 134 |
2056032 | 2056032 | 2021-12-27 | Custer | Oklahoma | 40039 | 5657 | 134 |
2052783 | 2052783 | 2021-12-26 | Custer | Oklahoma | 40039 | 5657 | 134 |
2049533 | 2049533 | 2021-12-25 | Custer | Oklahoma | 40039 | 5657 | 134 |
2046283 | 2046283 | 2021-12-24 | Custer | Oklahoma | 40039 | 5657 | 134 |
2043033 | 2043033 | 2021-12-23 | Custer | Oklahoma | 40039 | 5657 | 134 |
2039784 | 2039784 | 2021-12-22 | Custer | Oklahoma | 40039 | 5657 | 134 |
2014192 | 2014192 | 2021-12-14 | Macon | Tennessee | 47111 | 5657 | 100 |
1991937 | 1991937 | 2021-12-07 | Okanogan | Washington | 53047 | 5657 | 101 |
1946406 | 1946406 | 2021-11-23 | York | Virginia | 51199 | 5657 | 83 |
1919776 | 1919776 | 2021-11-15 | Colleton | South Carolina | 45029 | 5657 | 190 |
1899995 | 1899995 | 2021-11-09 | Williams | Ohio | 39171 | 5657 | 92 |
1884219 | 1884219 | 2021-11-04 | White | Tennessee | 47185 | 5657 | 98 |
1837372 | 1837372 | 2021-10-21 | Delta | Michigan | 26041 | 5657 | 103 |
1834123 | 1834123 | 2021-10-20 | Delta | Michigan | 26041 | 5657 | 103 |
1802150 | 1802150 | 2021-10-10 | Belknap | New Hampshire | 33001 | 5657 | 118 |
1798901 | 1798901 | 2021-10-09 | Belknap | New Hampshire | 33001 | 5657 | 118 |
1795652 | 1795652 | 2021-10-08 | Belknap | New Hampshire | 33001 | 5657 | 118 |
1783613 | 1783613 | 2021-10-04 | Howard | Texas | 48227 | 5657 | 122 |
1735930 | 1735930 | 2021-09-20 | Wayne | Georgia | 13305 | 5657 | 132 |
1720320 | 1720320 | 2021-09-15 | Vernon | Louisiana | 22115 | 5657 | 143 |
1696608 | 1696608 | 2021-09-08 | Lake | California | 6033 | 5657 | 78 |
1690313 | 1690313 | 2021-09-06 | Bryan | Georgia | 13029 | 5657 | 44 |
1687063 | 1687063 | 2021-09-05 | Bryan | Georgia | 13029 | 5657 | 44 |
1683813 | 1683813 | 2021-09-04 | Bryan | Georgia | 13029 | 5657 | 44 |
1680562 | 1680562 | 2021-09-03 | Bryan | Georgia | 13029 | 5657 | 44 |
1539213 | 1539213 | 2021-07-21 | Pender | North Carolina | 37141 | 5657 | 69 |
1532002 | 1532002 | 2021-07-19 | Chippewa | Michigan | 26033 | 5657 | 50 |
1528755 | 1528755 | 2021-07-18 | Chippewa | Michigan | 26033 | 5657 | 50 |
1525508 | 1525508 | 2021-07-17 | Chippewa | Michigan | 26033 | 5657 | 50 |
1522261 | 1522261 | 2021-07-16 | Chippewa | Michigan | 26033 | 5657 | 50 |
1511034 | 1511034 | 2021-07-12 | Pittsylvania | Virginia | 51143 | 5657 | 83 |
1507787 | 1507787 | 2021-07-11 | Pittsylvania | Virginia | 51143 | 5657 | 83 |
1504541 | 1504541 | 2021-07-10 | Pittsylvania | Virginia | 51143 | 5657 | 83 |
1394887 | 1394887 | 2021-06-07 | Laurens | Georgia | 13175 | 5657 | 170 |
1391642 | 1391642 | 2021-06-06 | Laurens | Georgia | 13175 | 5657 | 170 |
1382750 | 1382750 | 2021-06-03 | Tuscola | Michigan | 26157 | 5657 | 175 |
1376192 | 1376192 | 2021-06-01 | Branch | Michigan | 26023 | 5657 | 120 |
1305796 | 1305796 | 2021-05-10 | Columbia | Pennsylvania | 42037 | 5657 | 133 |
1243893 | 1243893 | 2021-04-21 | Belmont | Ohio | 39013 | 5657 | 159 |
1154751 | 1154751 | 2021-03-25 | Clinton | Illinois | 17027 | 5657 | 98 |
1150554 | 1150554 | 2021-03-23 | Chittenden | Vermont | 50007 | 5657 | 94 |
1089722 | 1089722 | 2021-03-05 | Spalding | Georgia | 13255 | 5657 | 162 |
1082231 | 1082231 | 2021-03-02 | Lamar | Texas | 48277 | 5657 | 146 |
1044132 | 1044132 | 2021-02-19 | Monroe | Florida | 12087 | 5657 | 44 |
1006954 | 1006954 | 2021-02-07 | Scioto | Ohio | 39145 | 5657 | 70 |
852264 | 852264 | 2020-12-21 | Wood | Wisconsin | 55141 | 5657 | 46 |
844765 | 844765 | 2020-12-19 | Rogers | Oklahoma | 40131 | 5657 | 78 |
792470 | 792470 | 2020-12-03 | Broome | New York | 36007 | 5657 | 156 |
511878 | 511878 | 2020-09-08 | Navajo | Arizona | 4017 | 5657 | 223 |
399262 | 399262 | 2020-08-04 | Hall | Georgia | 13139 | 5657 | 86 |
357417 | 357417 | 2020-07-22 | Volusia | Florida | 12127 | 5657 | 89 |
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);