ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
50 rows where cases = 8724 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2444998 | 2444998 | 2022-04-26 | Wabash | Indiana | 18169 | 8724 | 156 |
2441742 | 2441742 | 2022-04-25 | Wabash | Indiana | 18169 | 8724 | 156 |
2352860 | 2352860 | 2022-03-28 | Smyth | Virginia | 51173 | 8724 | 168 |
2320650 | 2320650 | 2022-03-19 | Baxter | Arkansas | 5005 | 8724 | 246 |
2247076 | 2247076 | 2022-02-24 | Carlton | Minnesota | 27017 | 8724 | 90 |
2173524 | 2173524 | 2022-02-01 | Lincoln | Tennessee | 47103 | 8724 | 137 |
2170272 | 2170272 | 2022-01-31 | Lincoln | Tennessee | 47103 | 8724 | 137 |
2167018 | 2167018 | 2022-01-30 | Lincoln | Tennessee | 47103 | 8724 | 137 |
2163763 | 2163763 | 2022-01-29 | Lincoln | Tennessee | 47103 | 8724 | 137 |
2160508 | 2160508 | 2022-01-28 | Lincoln | Tennessee | 47103 | 8724 | 137 |
2157252 | 2157252 | 2022-01-27 | Lincoln | Tennessee | 47103 | 8724 | 137 |
2153999 | 2153999 | 2022-01-26 | Lincoln | Tennessee | 47103 | 8724 | 137 |
2122871 | 2122871 | 2022-01-17 | Harrison | Indiana | 18061 | 8724 | 115 |
2072180 | 2072180 | 2022-01-01 | Auglaize | Ohio | 39011 | 8724 | 135 |
2068929 | 2068929 | 2021-12-31 | Auglaize | Ohio | 39011 | 8724 | 135 |
1995454 | 1995454 | 2021-12-09 | Graham | Arizona | 4009 | 8724 | 141 |
1976009 | 1976009 | 2021-12-03 | Mississippi | Arkansas | 5093 | 8724 | 150 |
1921605 | 1921605 | 2021-11-16 | Boyd | Kentucky | 21019 | 8724 | 109 |
1916058 | 1916058 | 2021-11-14 | McDowell | North Carolina | 37111 | 8724 | 133 |
1912808 | 1912808 | 2021-11-13 | McDowell | North Carolina | 37111 | 8724 | 133 |
1909558 | 1909558 | 2021-11-12 | McDowell | North Carolina | 37111 | 8724 | 133 |
1823240 | 1823240 | 2021-10-17 | Crittenden | Arkansas | 5035 | 8724 | 166 |
1562109 | 1562109 | 2021-07-28 | Tuscarawas | Ohio | 39157 | 8724 | 255 |
1541219 | 1541219 | 2021-07-22 | Hancock | Indiana | 18059 | 8724 | 153 |
1510873 | 1510873 | 2021-07-12 | Walker | Texas | 48471 | 8724 | 133 |
1490744 | 1490744 | 2021-07-06 | Payne | Oklahoma | 40119 | 8724 | 76 |
1487497 | 1487497 | 2021-07-05 | Payne | Oklahoma | 40119 | 8724 | 76 |
1484250 | 1484250 | 2021-07-04 | Payne | Oklahoma | 40119 | 8724 | 76 |
1481004 | 1481004 | 2021-07-03 | Payne | Oklahoma | 40119 | 8724 | 76 |
1477757 | 1477757 | 2021-07-02 | Payne | Oklahoma | 40119 | 8724 | 76 |
1474511 | 1474511 | 2021-07-01 | Payne | Oklahoma | 40119 | 8724 | 76 |
1471265 | 1471265 | 2021-06-30 | Payne | Oklahoma | 40119 | 8724 | 76 |
1342825 | 1342825 | 2021-05-22 | Highlands | Florida | 12055 | 8724 | 363 |
1284596 | 1284596 | 2021-05-04 | Bannock | Idaho | 16005 | 8724 | 106 |
1282865 | 1282865 | 2021-05-03 | Columbiana | Ohio | 39029 | 8724 | 229 |
1270330 | 1270330 | 2021-04-29 | Anderson | Tennessee | 47001 | 8724 | 172 |
1236501 | 1236501 | 2021-04-19 | St. Landry | Louisiana | 22097 | 8724 | 253 |
1208408 | 1208408 | 2021-04-10 | Mercer | Pennsylvania | 42085 | 8724 | 250 |
1163640 | 1163640 | 2021-03-27 | Montgomery | Virginia | 51121 | 8724 | 86 |
1113813 | 1113813 | 2021-03-12 | Putnam | New York | 36079 | 8724 | 87 |
1090280 | 1090280 | 2021-03-05 | Madison | Kentucky | 21151 | 8724 | 90 |
1081296 | 1081296 | 2021-03-02 | Lea | New Mexico | 35025 | 8724 | 149 |
1040454 | 1040454 | 2021-02-17 | Jefferson | Wisconsin | 55055 | 8724 | 84 |
958382 | 958382 | 2021-01-23 | Lane | Oregon | 41039 | 8724 | 113 |
683507 | 683507 | 2020-10-30 | Racine | Wisconsin | 55101 | 8724 | 115 |
622477 | 622477 | 2020-10-12 | Canyon | Idaho | 16027 | 8724 | 104 |
619234 | 619234 | 2020-10-11 | Canyon | Idaho | 16027 | 8724 | 103 |
615992 | 615992 | 2020-10-10 | Canyon | Idaho | 16027 | 8724 | 103 |
612751 | 612751 | 2020-10-09 | Canyon | Idaho | 16027 | 8724 | 103 |
382498 | 382498 | 2020-07-29 | Prince William | Virginia | 51153 | 8724 | 168 |
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);