ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
64 rows where cases = 9980 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 24
- Tennessee 15
- Florida 8
- Kansas 7
- Maine 4
- Alabama 3
- Indiana 3
- Puerto Rico 3
- Georgia 2
- Louisiana 2
- Virginia 2
- Wisconsin 2
- Arizona 1
- Arkansas 1
- Colorado 1
- Illinois 1
- Massachusetts 1
- Mississippi 1
- New Jersey 1
- New York 1
- North Carolina 1
- Oklahoma 1
- Pennsylvania 1
- South Carolina 1
- Texas 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2473816 | 2473816 | 2022-05-05 | Summit | Colorado | 8117 | 9980 | 14 |
2474465 | 2474465 | 2022-05-05 | Lyon | Kansas | 20111 | 9980 | 122 |
2471208 | 2471208 | 2022-05-04 | Lyon | Kansas | 20111 | 9980 | 122 |
2467952 | 2467952 | 2022-05-03 | Lyon | Kansas | 20111 | 9980 | 122 |
2464697 | 2464697 | 2022-05-02 | Lyon | Kansas | 20111 | 9980 | 122 |
2461441 | 2461441 | 2022-05-01 | Lyon | Kansas | 20111 | 9980 | 122 |
2458185 | 2458185 | 2022-04-30 | Lyon | Kansas | 20111 | 9980 | 122 |
2454929 | 2454929 | 2022-04-29 | Lyon | Kansas | 20111 | 9980 | 122 |
2446794 | 2446794 | 2022-04-26 | Lincoln | Tennessee | 47103 | 9980 | 170 |
2443539 | 2443539 | 2022-04-25 | Lincoln | Tennessee | 47103 | 9980 | 170 |
2440283 | 2440283 | 2022-04-24 | Lincoln | Tennessee | 47103 | 9980 | 170 |
2437027 | 2437027 | 2022-04-23 | Lincoln | Tennessee | 47103 | 9980 | 170 |
2433771 | 2433771 | 2022-04-22 | Lincoln | Tennessee | 47103 | 9980 | 170 |
2430515 | 2430515 | 2022-04-21 | Lincoln | Tennessee | 47103 | 9980 | 170 |
2427259 | 2427259 | 2022-04-20 | Lincoln | Tennessee | 47103 | 9980 | 170 |
2378425 | 2378425 | 2022-04-05 | Lincoln | Tennessee | 47103 | 9980 | 166 |
2375171 | 2375171 | 2022-04-04 | Lincoln | Tennessee | 47103 | 9980 | 166 |
2371919 | 2371919 | 2022-04-03 | Lincoln | Tennessee | 47103 | 9980 | 166 |
2368666 | 2368666 | 2022-04-02 | Lincoln | Tennessee | 47103 | 9980 | 166 |
2365413 | 2365413 | 2022-04-01 | Lincoln | Tennessee | 47103 | 9980 | 166 |
2362160 | 2362160 | 2022-03-31 | Lincoln | Tennessee | 47103 | 9980 | 166 |
2358906 | 2358906 | 2022-03-30 | Lincoln | Tennessee | 47103 | 9980 | 166 |
2310803 | 2310803 | 2022-03-16 | Escambia | Alabama | 1053 | 9980 | 165 |
2309844 | 2309844 | 2022-03-15 | Pike | Pennsylvania | 42103 | 9980 | 93 |
2243101 | 2243101 | 2022-02-23 | Christian | Illinois | 17021 | 9980 | 126 |
2227429 | 2227429 | 2022-02-18 | Oxford | Maine | 23017 | 9980 | 128 |
2199374 | 2199374 | 2022-02-09 | Vega Baja | Puerto Rico | 72145 | 9980 | |
2157660 | 2157660 | 2022-01-27 | Henry | Virginia | 51089 | 9980 | 215 |
2132242 | 2132242 | 2022-01-20 | Hendry | Florida | 12051 | 9980 | 145 |
2128989 | 2128989 | 2022-01-19 | Hendry | Florida | 12051 | 9980 | 145 |
2125735 | 2125735 | 2022-01-18 | Hendry | Florida | 12051 | 9980 | 143 |
2122483 | 2122483 | 2022-01-17 | Hendry | Florida | 12051 | 9980 | 143 |
2119231 | 2119231 | 2022-01-16 | Hendry | Florida | 12051 | 9980 | 143 |
2115979 | 2115979 | 2022-01-15 | Hendry | Florida | 12051 | 9980 | 143 |
2112728 | 2112728 | 2022-01-14 | Hendry | Florida | 12051 | 9980 | 143 |
2004592 | 2004592 | 2021-12-11 | Hood | Texas | 48221 | 9980 | 214 |
1884170 | 1884170 | 2021-11-04 | Jefferson | Tennessee | 47089 | 9980 | 147 |
1759326 | 1759326 | 2021-09-27 | Penobscot | Maine | 23019 | 9980 | 136 |
1756078 | 1756078 | 2021-09-26 | Penobscot | Maine | 23019 | 9980 | 136 |
1752830 | 1752830 | 2021-09-25 | Penobscot | Maine | 23019 | 9980 | 136 |
1717014 | 1717014 | 2021-09-14 | Acadia | Louisiana | 22001 | 9980 | 232 |
1619191 | 1619191 | 2021-08-15 | Kosciusko | Indiana | 18085 | 9980 | 129 |
1615943 | 1615943 | 2021-08-14 | Kosciusko | Indiana | 18085 | 9980 | 129 |
1612694 | 1612694 | 2021-08-13 | Kosciusko | Indiana | 18085 | 9980 | 129 |
1510015 | 1510015 | 2021-07-12 | Wilson | North Carolina | 37195 | 9980 | 181 |
1421524 | 1421524 | 2021-06-15 | Lafourche | Louisiana | 22057 | 9980 | 205 |
1339286 | 1339286 | 2021-05-21 | St. Clair | Alabama | 1115 | 9980 | 246 |
1314708 | 1314708 | 2021-05-13 | Lee | Mississippi | 28081 | 9980 | 174 |
1310049 | 1310049 | 2021-05-12 | Limestone | Alabama | 1083 | 9980 | 151 |
1303912 | 1303912 | 2021-05-10 | Barrow | Georgia | 13013 | 9980 | 137 |
1292874 | 1292874 | 2021-05-06 | Carolina | Puerto Rico | 72031 | 9980 | |
1289628 | 1289628 | 2021-05-05 | Carolina | Puerto Rico | 72031 | 9980 | |
1147779 | 1147779 | 2021-03-23 | Garland | Arkansas | 5051 | 9980 | 251 |
1101160 | 1101160 | 2021-03-08 | Rogers | Oklahoma | 40131 | 9980 | 119 |
995435 | 995435 | 2021-02-04 | Indian River | Florida | 12061 | 9980 | 235 |
877454 | 877454 | 2020-12-29 | Pickens | South Carolina | 45077 | 9980 | 143 |
832920 | 832920 | 2020-12-16 | Navajo | Arizona | 4017 | 9980 | 292 |
777391 | 777391 | 2020-11-28 | Loudoun | Virginia | 51107 | 9980 | 142 |
761928 | 761928 | 2020-11-24 | Richmond | Georgia | 13245 | 9980 | 215 |
683500 | 683500 | 2020-10-30 | Outagamie | Wisconsin | 55087 | 9980 | 78 |
589397 | 589397 | 2020-10-01 | Brown | Wisconsin | 55009 | 9980 | 66 |
581557 | 581557 | 2020-09-29 | Camden | New Jersey | 34007 | 9980 | 611 |
545367 | 545367 | 2020-09-18 | Norfolk | Massachusetts | 25021 | 9980 | 1044 |
155971 | 155971 | 2020-05-18 | Orange | New York | 36071 | 9980 | 350 |
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);