ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
19 rows where cases = 13328 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 13
- Pennsylvania 3
- California 2
- Minnesota 2
- Ohio 2
- Oregon 2
- Colorado 1
- Florida 1
- Missouri 1
- New Jersey 1
- South Carolina 1
- South Dakota 1
- Tennessee 1
- Wisconsin 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2176428 | 2176428 | 2022-02-02 | Benton | Oregon | 41003 | 13328 | 54 |
1838415 | 1838415 | 2021-10-21 | Mercer | Pennsylvania | 42085 | 13328 | 319 |
1542635 | 1542635 | 2021-07-22 | Wood | Ohio | 39173 | 13328 | 201 |
1350351 | 1350351 | 2021-05-24 | Olmsted | Minnesota | 27109 | 13328 | 101 |
1283395 | 1283395 | 2021-05-03 | Sevier | Tennessee | 47155 | 13328 | 175 |
1241763 | 1241763 | 2021-04-20 | La Crosse | Wisconsin | 55063 | 13328 | 80 |
1202119 | 1202119 | 2021-04-08 | Pennington | South Dakota | 46103 | 13328 | 190 |
1102399 | 1102399 | 2021-03-09 | Marin | California | 6041 | 13328 | 199 |
1068715 | 1068715 | 2021-02-26 | Clackamas | Oregon | 41005 | 13328 | 178 |
1020074 | 1020074 | 2021-02-11 | Butler | Pennsylvania | 42019 | 13328 | 350 |
968153 | 968153 | 2021-01-26 | Cumberland | Pennsylvania | 42041 | 13328 | 419 |
940114 | 940114 | 2021-01-18 | Madera | California | 6039 | 13328 | 130 |
885033 | 885033 | 2021-01-01 | Pueblo | Colorado | 8101 | 13328 | 313 |
776190 | 776190 | 2020-11-28 | Burlington | New Jersey | 34005 | 13328 | 543 |
746721 | 746721 | 2020-11-19 | Greene | Missouri | 29077 | 13328 | 188 |
747255 | 747255 | 2020-11-19 | Butler | Ohio | 39017 | 13328 | 142 |
667674 | 667674 | 2020-10-26 | Escambia | Florida | 12033 | 13328 | 269 |
533615 | 533615 | 2020-09-14 | Greenville | South Carolina | 45045 | 13328 | 283 |
323230 | 323230 | 2020-07-11 | Hennepin | Minnesota | 27053 | 13328 | 790 |
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);