ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
52 rows where cases = 9810 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 21
- Oklahoma 7
- Nebraska 6
- Illinois 4
- North Carolina 4
- California 3
- Montana 3
- New Hampshire 3
- Tennessee 3
- Wisconsin 3
- Florida 2
- New Jersey 2
- Texas 2
- West Virginia 2
- Alabama 1
- Georgia 1
- Maine 1
- Missouri 1
- Ohio 1
- Pennsylvania 1
- Virginia 1
- Wyoming 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2415573 | 2415573 | 2022-04-17 | Montgomery | Illinois | 17135 | 9810 | 111 |
2412317 | 2412317 | 2022-04-16 | Montgomery | Illinois | 17135 | 9810 | 111 |
2409061 | 2409061 | 2022-04-15 | Montgomery | Illinois | 17135 | 9810 | 111 |
2378993 | 2378993 | 2022-04-05 | Wayne | West Virginia | 54099 | 9810 | 121 |
2265632 | 2265632 | 2022-03-02 | Unknown | Florida | 9810 | 457 | |
2218061 | 2218061 | 2022-02-15 | Phelps | Missouri | 29161 | 9810 | 225 |
2212309 | 2212309 | 2022-02-13 | Wayne | Pennsylvania | 42127 | 9810 | 159 |
2170551 | 2170551 | 2022-01-31 | Van Zandt | Texas | 48467 | 9810 | 247 |
2154665 | 2154665 | 2022-01-26 | Sweetwater | Wyoming | 56037 | 9810 | 115 |
2122615 | 2122615 | 2022-01-17 | Liberty | Georgia | 13179 | 9810 | 138 |
2104788 | 2104788 | 2022-01-11 | Carter | Oklahoma | 40019 | 9810 | 201 |
2101537 | 2101537 | 2022-01-10 | Carter | Oklahoma | 40019 | 9810 | 201 |
2097907 | 2097907 | 2022-01-09 | Belknap | New Hampshire | 33001 | 9810 | 149 |
2098272 | 2098272 | 2022-01-09 | Washington | Ohio | 39167 | 9810 | 167 |
2098286 | 2098286 | 2022-01-09 | Carter | Oklahoma | 40019 | 9810 | 201 |
2094655 | 2094655 | 2022-01-08 | Belknap | New Hampshire | 33001 | 9810 | 149 |
2095034 | 2095034 | 2022-01-08 | Carter | Oklahoma | 40019 | 9810 | 201 |
2091403 | 2091403 | 2022-01-07 | Belknap | New Hampshire | 33001 | 9810 | 149 |
2091782 | 2091782 | 2022-01-07 | Carter | Oklahoma | 40019 | 9810 | 201 |
2088530 | 2088530 | 2022-01-06 | Carter | Oklahoma | 40019 | 9810 | 201 |
2085279 | 2085279 | 2022-01-05 | Carter | Oklahoma | 40019 | 9810 | 201 |
2085845 | 2085845 | 2022-01-05 | Harrison | Texas | 48203 | 9810 | 192 |
2040144 | 2040144 | 2021-12-22 | Bedford | Tennessee | 47003 | 9810 | 178 |
1937060 | 1937060 | 2021-11-21 | Nevada | California | 6057 | 9810 | 92 |
1933810 | 1933810 | 2021-11-20 | Nevada | California | 6057 | 9810 | 92 |
1930558 | 1930558 | 2021-11-19 | Nevada | California | 6057 | 9810 | 92 |
1860046 | 1860046 | 2021-10-28 | Kennebec | Maine | 23011 | 9810 | 103 |
1854066 | 1854066 | 2021-10-26 | Hall | Nebraska | 31079 | 9810 | 120 |
1850817 | 1850817 | 2021-10-25 | Hall | Nebraska | 31079 | 9810 | 120 |
1847567 | 1847567 | 2021-10-24 | Hall | Nebraska | 31079 | 9810 | 120 |
1844317 | 1844317 | 2021-10-23 | Hall | Nebraska | 31079 | 9810 | 120 |
1841067 | 1841067 | 2021-10-22 | Hall | Nebraska | 31079 | 9810 | 120 |
1837818 | 1837818 | 2021-10-21 | Hall | Nebraska | 31079 | 9810 | 120 |
1815966 | 1815966 | 2021-10-14 | Roane | Tennessee | 47145 | 9810 | 147 |
1787373 | 1787373 | 2021-10-06 | Autauga | Alabama | 1001 | 9810 | 143 |
1787239 | 1787239 | 2021-10-05 | Harrison | West Virginia | 54033 | 9810 | 122 |
1712587 | 1712587 | 2021-09-12 | Manitowoc | Wisconsin | 55071 | 9810 | 99 |
1709340 | 1709340 | 2021-09-11 | Manitowoc | Wisconsin | 55071 | 9810 | 99 |
1706093 | 1706093 | 2021-09-10 | Manitowoc | Wisconsin | 55071 | 9810 | 99 |
1676695 | 1676695 | 2021-09-01 | Roanoke city | Virginia | 51770 | 9810 | 207 |
1597350 | 1597350 | 2021-08-08 | Missoula | Montana | 30063 | 9810 | 102 |
1594101 | 1594101 | 2021-08-07 | Missoula | Montana | 30063 | 9810 | 102 |
1590852 | 1590852 | 2021-08-06 | Missoula | Montana | 30063 | 9810 | 102 |
1396210 | 1396210 | 2021-06-07 | Hunterdon | New Jersey | 34019 | 9810 | 176 |
1396412 | 1396412 | 2021-06-07 | Wilson | North Carolina | 37195 | 9810 | 179 |
1328840 | 1328840 | 2021-05-17 | Robertson | Tennessee | 47147 | 9810 | 132 |
1234034 | 1234034 | 2021-04-18 | Henderson | North Carolina | 37089 | 9810 | 157 |
1230786 | 1230786 | 2021-04-17 | Henderson | North Carolina | 37089 | 9810 | 157 |
1227538 | 1227538 | 2021-04-16 | Henderson | North Carolina | 37089 | 9810 | 157 |
842883 | 842883 | 2020-12-19 | Clay | Florida | 12019 | 9810 | 171 |
704811 | 704811 | 2020-11-06 | Mercer | New Jersey | 34021 | 9810 | 642 |
332058 | 332058 | 2020-07-14 | DuPage | Illinois | 17043 | 9810 | 491 |
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);