ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
71 rows where cases = 6199 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 29
- Michigan 11
- Indiana 7
- Puerto Rico 7
- Minnesota 5
- Arkansas 4
- Pennsylvania 4
- North Carolina 3
- Ohio 3
- California 2
- Florida 2
- Illinois 2
- Maryland 2
- Texas 2
- West Virginia 2
- Alabama 1
- Arizona 1
- Colorado 1
- Georgia 1
- Kentucky 1
- Louisiana 1
- Mississippi 1
- Missouri 1
- New Jersey 1
- Oklahoma 1
- South Carolina 1
- Tennessee 1
- Vermont 1
- Washington 1
- Wyoming 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2501573 | 2501573 | 2022-05-13 | Transylvania | North Carolina | 37175 | 6199 | 75 |
2498315 | 2498315 | 2022-05-12 | Transylvania | North Carolina | 37175 | 6199 | 75 |
2495057 | 2495057 | 2022-05-11 | Transylvania | North Carolina | 37175 | 6199 | 75 |
2470542 | 2470542 | 2022-05-04 | Montezuma | Colorado | 8083 | 6199 | 80 |
2414053 | 2414053 | 2022-04-16 | San Sebastian | Puerto Rico | 72131 | 6199 | |
2410797 | 2410797 | 2022-04-15 | San Sebastian | Puerto Rico | 72131 | 6199 | |
2407541 | 2407541 | 2022-04-14 | San Sebastian | Puerto Rico | 72131 | 6199 | |
2355990 | 2355990 | 2022-03-29 | Orleans | Vermont | 50019 | 6199 | 37 |
2156815 | 2156815 | 2022-01-27 | Van Wert | Ohio | 39161 | 6199 | 124 |
2149650 | 2149650 | 2022-01-25 | Tippah | Mississippi | 28139 | 6199 | 90 |
2029159 | 2029159 | 2021-12-19 | Mecosta | Michigan | 26107 | 6199 | 78 |
2025908 | 2025908 | 2021-12-18 | Mecosta | Michigan | 26107 | 6199 | 78 |
2022657 | 2022657 | 2021-12-17 | Mecosta | Michigan | 26107 | 6199 | 78 |
2012024 | 2012024 | 2021-12-14 | Chattahoochee | Georgia | 13053 | 6199 | 21 |
1968505 | 1968505 | 2021-11-30 | Toa Baja | Puerto Rico | 72137 | 6199 | |
1965254 | 1965254 | 2021-11-29 | Toa Baja | Puerto Rico | 72137 | 6199 | |
1962002 | 1962002 | 2021-11-28 | Toa Baja | Puerto Rico | 72137 | 6199 | |
1958751 | 1958751 | 2021-11-27 | Toa Baja | Puerto Rico | 72137 | 6199 | |
1940799 | 1940799 | 2021-11-22 | Woodford | Illinois | 17203 | 6199 | 105 |
1891230 | 1891230 | 2021-11-06 | Ohio | West Virginia | 54069 | 6199 | 108 |
1847209 | 1847209 | 2021-10-24 | Goodhue | Minnesota | 27049 | 6199 | 85 |
1843959 | 1843959 | 2021-10-23 | Goodhue | Minnesota | 27049 | 6199 | 85 |
1839472 | 1839472 | 2021-10-22 | Boone | Arkansas | 5009 | 6199 | 126 |
1840709 | 1840709 | 2021-10-22 | Goodhue | Minnesota | 27049 | 6199 | 85 |
1839334 | 1839334 | 2021-10-21 | Albany | Wyoming | 56001 | 6199 | 32 |
1816061 | 1816061 | 2021-10-14 | Erath | Texas | 48143 | 6199 | 99 |
1810259 | 1810259 | 2021-10-13 | Independence | Arkansas | 5063 | 6199 | 154 |
1769045 | 1769045 | 2021-09-30 | St. John the Baptist | Louisiana | 22095 | 6199 | 162 |
1723711 | 1723711 | 2021-09-16 | Tuscola | Michigan | 26157 | 6199 | 182 |
1720462 | 1720462 | 2021-09-15 | Tuscola | Michigan | 26157 | 6199 | 182 |
1704984 | 1704984 | 2021-09-10 | Darke | Ohio | 39037 | 6199 | 135 |
1680035 | 1680035 | 2021-09-02 | Mercer | West Virginia | 54055 | 6199 | 132 |
1636949 | 1636949 | 2021-08-20 | Armstrong | Pennsylvania | 42005 | 6199 | 148 |
1619205 | 1619205 | 2021-08-15 | Noble | Indiana | 18113 | 6199 | 95 |
1615957 | 1615957 | 2021-08-14 | Noble | Indiana | 18113 | 6199 | 95 |
1612708 | 1612708 | 2021-08-13 | Noble | Indiana | 18113 | 6199 | 95 |
1588548 | 1588548 | 2021-08-05 | Monroe | Tennessee | 47123 | 6199 | 98 |
1581782 | 1581782 | 2021-08-03 | Union | Pennsylvania | 42119 | 6199 | 90 |
1578533 | 1578533 | 2021-08-02 | Union | Pennsylvania | 42119 | 6199 | 90 |
1567687 | 1567687 | 2021-07-30 | St. Mary's | Maryland | 24037 | 6199 | 132 |
1561777 | 1561777 | 2021-07-28 | Salem | New Jersey | 34033 | 6199 | 189 |
1437944 | 1437944 | 2021-06-20 | Chisago | Minnesota | 27025 | 6199 | 52 |
1429604 | 1429604 | 2021-06-17 | Hunt | Texas | 48231 | 6199 | 179 |
1410776 | 1410776 | 2021-06-12 | Greene | Arkansas | 5055 | 6199 | 77 |
1407531 | 1407531 | 2021-06-11 | Greene | Arkansas | 5055 | 6199 | 77 |
1395958 | 1395958 | 2021-06-07 | Joplin | Missouri | 6199 | 109 | |
1391918 | 1391918 | 2021-06-06 | Marshall | Indiana | 18099 | 6199 | 118 |
1388673 | 1388673 | 2021-06-05 | Marshall | Indiana | 18099 | 6199 | 118 |
1382151 | 1382151 | 2021-06-03 | Dubois | Indiana | 18037 | 6199 | 118 |
1330765 | 1330765 | 2021-05-18 | Isabella | Michigan | 26073 | 6199 | 93 |
1328534 | 1328534 | 2021-05-17 | Indiana | Pennsylvania | 42063 | 6199 | 173 |
1308078 | 1308078 | 2021-05-11 | Shiawassee | Michigan | 26155 | 6199 | 101 |
1278813 | 1278813 | 2021-05-02 | Grand Traverse | Michigan | 26055 | 6199 | 88 |
1275566 | 1275566 | 2021-05-01 | Grand Traverse | Michigan | 26055 | 6199 | 88 |
1272319 | 1272319 | 2021-04-30 | Grand Traverse | Michigan | 26055 | 6199 | 88 |
1220194 | 1220194 | 2021-04-14 | Pulaski | Kentucky | 21199 | 6199 | 96 |
1202870 | 1202870 | 2021-04-09 | Colbert | Alabama | 1033 | 6199 | 129 |
1181419 | 1181419 | 2021-04-02 | Montcalm | Michigan | 26117 | 6199 | 96 |
1148342 | 1148342 | 2021-03-23 | Whiteside | Illinois | 17195 | 6199 | 196 |
1123757 | 1123757 | 2021-03-15 | Geauga | Ohio | 39055 | 6199 | 143 |
1119181 | 1119181 | 2021-03-14 | Morgan | Indiana | 18109 | 6199 | 135 |
1116509 | 1116509 | 2021-03-13 | Blue Earth | Minnesota | 27013 | 6199 | 37 |
1043581 | 1043581 | 2021-02-18 | Chelan | Washington | 53007 | 6199 | 61 |
1016724 | 1016724 | 2021-02-10 | Creek | Oklahoma | 40037 | 6199 | 104 |
983301 | 983301 | 2021-01-31 | Allegany | Maryland | 24001 | 6199 | 183 |
897935 | 897935 | 2021-01-05 | Napa | California | 6055 | 6199 | 30 |
799543 | 799543 | 2020-12-05 | Dorchester | South Carolina | 45035 | 6199 | 114 |
780993 | 780993 | 2020-11-30 | Mohave | Arizona | 4015 | 6199 | 260 |
706631 | 706631 | 2020-11-07 | Santa Rosa | Florida | 12113 | 6199 | 89 |
599537 | 599537 | 2020-10-05 | Bay | Florida | 12005 | 6199 | 113 |
557318 | 557318 | 2020-09-22 | Solano | California | 6095 | 6199 | 57 |
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);