ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
51 rows where cases = 7784 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 22
- North Carolina 9
- Illinois 5
- Arkansas 4
- Georgia 3
- New York 3
- Ohio 3
- Pennsylvania 3
- Indiana 2
- Maryland 2
- Michigan 2
- Minnesota 2
- Puerto Rico 2
- Texas 2
- Florida 1
- Mississippi 1
- Missouri 1
- Montana 1
- New Hampshire 1
- South Dakota 1
- Utah 1
- Virginia 1
- Wisconsin 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2449863 | 2449863 | 2022-04-27 | Rio Grande | Puerto Rico | 72119 | 7784 | |
2351369 | 2351369 | 2022-03-28 | Lafayette | Missouri | 29107 | 7784 | 128 |
2290827 | 2290827 | 2022-03-09 | Polk | Texas | 48373 | 7784 | 245 |
2240013 | 2240013 | 2022-02-22 | Scott | Indiana | 18143 | 7784 | 99 |
2055235 | 2055235 | 2021-12-27 | McLeod | Minnesota | 27085 | 7784 | 92 |
2055814 | 2055814 | 2021-12-27 | Hoke | North Carolina | 37093 | 7784 | 91 |
2052564 | 2052564 | 2021-12-26 | Hoke | North Carolina | 37093 | 7784 | 91 |
2049314 | 2049314 | 2021-12-25 | Hoke | North Carolina | 37093 | 7784 | 91 |
2046064 | 2046064 | 2021-12-24 | Hoke | North Carolina | 37093 | 7784 | 91 |
2042814 | 2042814 | 2021-12-23 | Hoke | North Carolina | 37093 | 7784 | 91 |
2039565 | 2039565 | 2021-12-22 | Hoke | North Carolina | 37093 | 7784 | 91 |
2037264 | 2037264 | 2021-12-21 | Summit | Utah | 49043 | 7784 | 19 |
1987898 | 1987898 | 2021-12-06 | Huntingdon | Pennsylvania | 42061 | 7784 | 183 |
1909459 | 1909459 | 2021-11-12 | Genesee | New York | 36037 | 7784 | 139 |
1870681 | 1870681 | 2021-10-31 | Darke | Ohio | 39037 | 7784 | 165 |
1867432 | 1867432 | 2021-10-30 | Darke | Ohio | 39037 | 7784 | 165 |
1804222 | 1804222 | 2021-10-11 | Boone | Illinois | 17007 | 7784 | 95 |
1800973 | 1800973 | 2021-10-10 | Boone | Illinois | 17007 | 7784 | 95 |
1797724 | 1797724 | 2021-10-09 | Boone | Illinois | 17007 | 7784 | 95 |
1794475 | 1794475 | 2021-10-08 | Boone | Illinois | 17007 | 7784 | 95 |
1752844 | 1752844 | 2021-09-25 | Cecil | Maryland | 24015 | 7784 | 164 |
1698299 | 1698299 | 2021-09-08 | Steuben | New York | 36101 | 7784 | 152 |
1693684 | 1693684 | 2021-09-07 | Tift | Georgia | 13277 | 7784 | 140 |
1681361 | 1681361 | 2021-09-03 | Allegany | Maryland | 24001 | 7784 | 218 |
1666051 | 1666051 | 2021-08-29 | Ross | Ohio | 39141 | 7784 | 167 |
1600286 | 1600286 | 2021-08-09 | Blue Earth | Minnesota | 27013 | 7784 | 44 |
1555775 | 1555775 | 2021-07-26 | Lawrence | Pennsylvania | 42073 | 7784 | 217 |
1511698 | 1511698 | 2021-07-13 | Dougherty | Georgia | 13095 | 7784 | 312 |
1483894 | 1483894 | 2021-07-04 | Chemung | New York | 36015 | 7784 | 136 |
1379615 | 1379615 | 2021-06-02 | Forrest | Mississippi | 28035 | 7784 | 153 |
1355975 | 1355975 | 2021-05-26 | Rockdale | Georgia | 13247 | 7784 | 170 |
1318820 | 1318820 | 2021-05-14 | Somerset | Pennsylvania | 42111 | 7784 | 207 |
1197062 | 1197062 | 2021-04-07 | Bartholomew | Indiana | 18005 | 7784 | 157 |
1167312 | 1167312 | 2021-03-29 | White | Arkansas | 5145 | 7784 | 116 |
1164064 | 1164064 | 2021-03-28 | White | Arkansas | 5145 | 7784 | 116 |
1160816 | 1160816 | 2021-03-27 | White | Arkansas | 5145 | 7784 | 115 |
1147977 | 1147977 | 2021-03-23 | Columbia | Florida | 12023 | 7784 | 162 |
1132662 | 1132662 | 2021-03-18 | Bay | Michigan | 26017 | 7784 | 298 |
1120209 | 1120209 | 2021-03-14 | Merrimack | New Hampshire | 33013 | 7784 | 107 |
1110304 | 1110304 | 2021-03-11 | Cascade | Montana | 30013 | 7784 | 150 |
1102360 | 1102360 | 2021-03-09 | Pope | Arkansas | 5115 | 7784 | 99 |
1085216 | 1085216 | 2021-03-03 | Lincoln | South Dakota | 46083 | 7784 | 77 |
1052173 | 1052173 | 2021-02-21 | Brunswick | North Carolina | 37019 | 7784 | 131 |
1036375 | 1036375 | 2021-02-16 | Carolina | Puerto Rico | 72031 | 7784 | |
960074 | 960074 | 2021-01-24 | Vermilion | Illinois | 17183 | 7784 | 117 |
958083 | 958083 | 2021-01-23 | Harnett | North Carolina | 37085 | 7784 | 109 |
920370 | 920370 | 2021-01-11 | Jefferson | Wisconsin | 55055 | 7784 | 65 |
910169 | 910169 | 2021-01-08 | Grayson | Texas | 48181 | 7784 | 191 |
714670 | 714670 | 2020-11-09 | Cumberland | North Carolina | 37051 | 7784 | 105 |
670327 | 670327 | 2020-10-26 | Loudoun | Virginia | 51107 | 7784 | 130 |
137452 | 137452 | 2020-05-12 | Oakland | Michigan | 26125 | 7784 | 872 |
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);