ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
32 rows where cases = 11959 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 14
- Ohio 8
- Rhode Island 7
- North Carolina 3
- Georgia 2
- Kansas 2
- Minnesota 2
- Arkansas 1
- Indiana 1
- Michigan 1
- Missouri 1
- New York 1
- Oregon 1
- Pennsylvania 1
- Washington 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2403951 | 2403951 | 2022-04-13 | Ashland | Ohio | 39005 | 11959 | 217 |
2400696 | 2400696 | 2022-04-12 | Ashland | Ohio | 39005 | 11959 | 217 |
2397441 | 2397441 | 2022-04-11 | Ashland | Ohio | 39005 | 11959 | 217 |
2394186 | 2394186 | 2022-04-10 | Ashland | Ohio | 39005 | 11959 | 217 |
2390930 | 2390930 | 2022-04-09 | Ashland | Ohio | 39005 | 11959 | 217 |
2387674 | 2387674 | 2022-04-08 | Ashland | Ohio | 39005 | 11959 | 217 |
2384419 | 2384419 | 2022-04-07 | Ashland | Ohio | 39005 | 11959 | 217 |
2356847 | 2356847 | 2022-03-30 | Thomas | Georgia | 13275 | 11959 | 207 |
2009750 | 2009750 | 2021-12-13 | Rice | Minnesota | 27131 | 11959 | 147 |
1941988 | 1941988 | 2021-11-22 | Steuben | New York | 36101 | 11959 | 186 |
1859022 | 1859022 | 2021-10-28 | Pope | Arkansas | 5115 | 11959 | 157 |
1792761 | 1792761 | 2021-10-07 | Tuscarawas | Ohio | 39157 | 11959 | 282 |
1785043 | 1785043 | 2021-10-05 | Douglas | Kansas | 20045 | 11959 | 99 |
1781794 | 1781794 | 2021-10-04 | Douglas | Kansas | 20045 | 11959 | 99 |
1668689 | 1668689 | 2021-08-30 | Cole | Missouri | 29051 | 11959 | 147 |
1579302 | 1579302 | 2021-08-02 | Thurston | Washington | 53067 | 11959 | 122 |
1552154 | 1552154 | 2021-07-25 | Cleveland | North Carolina | 37045 | 11959 | 228 |
1548907 | 1548907 | 2021-07-24 | Cleveland | North Carolina | 37045 | 11959 | 228 |
1545660 | 1545660 | 2021-07-23 | Cleveland | North Carolina | 37045 | 11959 | 228 |
1532986 | 1532986 | 2021-07-19 | Jackson | Oregon | 41029 | 11959 | 149 |
1468115 | 1468115 | 2021-06-29 | Lycoming | Pennsylvania | 42081 | 11959 | 294 |
1310755 | 1310755 | 2021-05-12 | LaPorte | Indiana | 18091 | 11959 | 213 |
1119676 | 1119676 | 2021-03-14 | Berrien | Michigan | 26021 | 11959 | 247 |
986758 | 986758 | 2021-02-01 | Wright | Minnesota | 27171 | 11959 | 108 |
940327 | 940327 | 2021-01-18 | Clarke | Georgia | 13059 | 11959 | 80 |
239334 | 239334 | 2020-06-14 | Providence | Rhode Island | 44007 | 11959 | 637 |
236226 | 236226 | 2020-06-13 | Providence | Rhode Island | 44007 | 11959 | 637 |
233121 | 233121 | 2020-06-12 | Providence | Rhode Island | 44007 | 11959 | 637 |
230016 | 230016 | 2020-06-11 | Providence | Rhode Island | 44007 | 11959 | 637 |
226912 | 226912 | 2020-06-10 | Providence | Rhode Island | 44007 | 11959 | 637 |
223812 | 223812 | 2020-06-09 | Providence | Rhode Island | 44007 | 11959 | 637 |
220717 | 220717 | 2020-06-08 | Providence | Rhode Island | 44007 | 11959 | 637 |
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);