ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
40 rows where cases = 8956 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 18
- Tennessee 8
- Oklahoma 7
- New York 3
- Pennsylvania 3
- Texas 3
- North Carolina 2
- Ohio 2
- Washington 2
- Arkansas 1
- Connecticut 1
- Florida 1
- Georgia 1
- Idaho 1
- Kentucky 1
- Louisiana 1
- Maryland 1
- Massachusetts 1
- Minnesota 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2423960 | 2423960 | 2022-04-19 | Carroll | Tennessee | 47017 | 8956 | 156 |
2420704 | 2420704 | 2022-04-18 | Carroll | Tennessee | 47017 | 8956 | 156 |
2417448 | 2417448 | 2022-04-17 | Carroll | Tennessee | 47017 | 8956 | 156 |
2414192 | 2414192 | 2022-04-16 | Carroll | Tennessee | 47017 | 8956 | 156 |
2410936 | 2410936 | 2022-04-15 | Carroll | Tennessee | 47017 | 8956 | 156 |
2407680 | 2407680 | 2022-04-14 | Carroll | Tennessee | 47017 | 8956 | 156 |
2404424 | 2404424 | 2022-04-13 | Carroll | Tennessee | 47017 | 8956 | 156 |
2313078 | 2313078 | 2022-03-16 | Jefferson | Pennsylvania | 42065 | 8956 | 226 |
2261609 | 2261609 | 2022-02-28 | Washington | Texas | 48477 | 8956 | 144 |
2251275 | 2251275 | 2022-02-25 | Clinton | Pennsylvania | 42035 | 8956 | 123 |
2221687 | 2221687 | 2022-02-16 | Jackson | North Carolina | 37099 | 8956 | 83 |
2152597 | 2152597 | 2022-01-26 | Vernon | Louisiana | 22115 | 8956 | 171 |
2148728 | 2148728 | 2022-01-25 | Bingham | Idaho | 16011 | 8956 | 140 |
2114279 | 2114279 | 2022-01-14 | Tioga | New York | 36107 | 8956 | 79 |
2110487 | 2110487 | 2022-01-13 | Itasca | Minnesota | 27061 | 8956 | 122 |
2080393 | 2080393 | 2022-01-04 | Tift | Georgia | 13277 | 8956 | 188 |
2059336 | 2059336 | 2021-12-28 | Washington | Oklahoma | 40147 | 8956 | 210 |
2056087 | 2056087 | 2021-12-27 | Washington | Oklahoma | 40147 | 8956 | 210 |
2052838 | 2052838 | 2021-12-26 | Washington | Oklahoma | 40147 | 8956 | 210 |
2049588 | 2049588 | 2021-12-25 | Washington | Oklahoma | 40147 | 8956 | 210 |
2046338 | 2046338 | 2021-12-24 | Washington | Oklahoma | 40147 | 8956 | 210 |
2043088 | 2043088 | 2021-12-23 | Washington | Oklahoma | 40147 | 8956 | 210 |
2039839 | 2039839 | 2021-12-22 | Washington | Oklahoma | 40147 | 8956 | 210 |
2033194 | 2033194 | 2021-12-20 | Darke | Ohio | 39037 | 8956 | 183 |
1967158 | 1967158 | 2021-11-30 | Hopkins | Kentucky | 21107 | 8956 | 213 |
1907419 | 1907419 | 2021-11-11 | Grays Harbor | Washington | 53027 | 8956 | 135 |
1904170 | 1904170 | 2021-11-10 | Grays Harbor | Washington | 53027 | 8956 | 135 |
1733992 | 1733992 | 2021-09-19 | Chemung | New York | 36015 | 8956 | 144 |
1601723 | 1601723 | 2021-08-09 | Liberty | Texas | 48291 | 8956 | 209 |
1428717 | 1428717 | 2021-06-17 | Chautauqua | New York | 36013 | 8956 | 145 |
1362101 | 1362101 | 2021-05-28 | Jefferson | Arkansas | 5069 | 8956 | 167 |
1203235 | 1203235 | 2021-04-09 | Sumter | Florida | 12119 | 8956 | 263 |
966184 | 966184 | 2021-01-26 | Middlesex | Connecticut | 9007 | 8956 | 314 |
887036 | 887036 | 2021-01-01 | Lebanon | Pennsylvania | 42075 | 8956 | 158 |
871095 | 871095 | 2020-12-27 | Maury | Tennessee | 47119 | 8956 | 102 |
828402 | 828402 | 2020-12-14 | Delaware | Ohio | 39041 | 8956 | 50 |
692679 | 692679 | 2020-11-02 | Brazos | Texas | 48041 | 8956 | 76 |
519443 | 519443 | 2020-09-10 | Anne Arundel | Maryland | 24003 | 8956 | 241 |
364675 | 364675 | 2020-07-24 | Plymouth | Massachusetts | 25023 | 8956 | 701 |
263842 | 263842 | 2020-06-22 | Mecklenburg | North Carolina | 37119 | 8956 | 143 |
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);