ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
48 rows where cases = 8105 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 22
- Oklahoma 9
- Ohio 4
- Idaho 3
- Illinois 3
- Tennessee 3
- Virginia 3
- Wyoming 3
- California 2
- Florida 2
- Kentucky 2
- North Carolina 2
- Pennsylvania 2
- Colorado 1
- Georgia 1
- Maryland 1
- Massachusetts 1
- Missouri 1
- New York 1
- South Carolina 1
- Texas 1
- West Virginia 1
- Wisconsin 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2407462 | 2407462 | 2022-04-14 | Snyder | Pennsylvania | 42109 | 8105 | 156 |
2170804 | 2170804 | 2022-01-31 | Greenbrier | West Virginia | 54025 | 8105 | 125 |
2127602 | 2127602 | 2022-01-18 | Pontotoc | Oklahoma | 40123 | 8105 | 109 |
2124350 | 2124350 | 2022-01-17 | Pontotoc | Oklahoma | 40123 | 8105 | 109 |
2121098 | 2121098 | 2022-01-16 | Pontotoc | Oklahoma | 40123 | 8105 | 109 |
2117846 | 2117846 | 2022-01-15 | Pontotoc | Oklahoma | 40123 | 8105 | 109 |
2114595 | 2114595 | 2022-01-14 | Pontotoc | Oklahoma | 40123 | 8105 | 109 |
2111343 | 2111343 | 2022-01-13 | Pontotoc | Oklahoma | 40123 | 8105 | 109 |
2108091 | 2108091 | 2022-01-12 | Pontotoc | Oklahoma | 40123 | 8105 | 109 |
2088477 | 2088477 | 2022-01-06 | Logan | Ohio | 39091 | 8105 | 135 |
2081074 | 2081074 | 2022-01-04 | Calvert | Maryland | 24009 | 8105 | 106 |
2036234 | 2036234 | 2021-12-21 | Livingston | New York | 36051 | 8105 | 88 |
1970925 | 1970925 | 2021-12-01 | Newton | Missouri | 29145 | 8105 | 168 |
1958674 | 1958674 | 2021-11-27 | Union | Pennsylvania | 42119 | 8105 | 112 |
1898852 | 1898852 | 2021-11-09 | Barren | Kentucky | 21009 | 8105 | 147 |
1875367 | 1875367 | 2021-11-02 | Garfield | Colorado | 8045 | 8105 | 63 |
1848003 | 1848003 | 2021-10-24 | Washington | Ohio | 39167 | 8105 | 144 |
1803596 | 1803596 | 2021-10-10 | Campbell | Wyoming | 56005 | 8105 | 85 |
1800347 | 1800347 | 2021-10-09 | Campbell | Wyoming | 56005 | 8105 | 85 |
1797098 | 1797098 | 2021-10-08 | Campbell | Wyoming | 56005 | 8105 | 85 |
1762078 | 1762078 | 2021-09-28 | Whiteside | Illinois | 17195 | 8105 | 218 |
1758830 | 1758830 | 2021-09-27 | Whiteside | Illinois | 17195 | 8105 | 218 |
1721233 | 1721233 | 2021-09-15 | Hancock | Ohio | 39063 | 8105 | 140 |
1699869 | 1699869 | 2021-09-09 | Nevada | California | 6057 | 8105 | 85 |
1701612 | 1701612 | 2021-09-09 | Lee | North Carolina | 37105 | 8105 | 91 |
1666469 | 1666469 | 2021-08-29 | Dickson | Tennessee | 47043 | 8105 | 131 |
1663221 | 1663221 | 2021-08-28 | Dickson | Tennessee | 47043 | 8105 | 131 |
1659973 | 1659973 | 2021-08-27 | Dickson | Tennessee | 47043 | 8105 | 131 |
1647432 | 1647432 | 2021-08-23 | Lynchburg city | Virginia | 51680 | 8105 | 152 |
1542569 | 1542569 | 2021-07-22 | Erie | Ohio | 39043 | 8105 | 166 |
1537751 | 1537751 | 2021-07-21 | Rockdale | Georgia | 13247 | 8105 | 180 |
1439374 | 1439374 | 2021-06-20 | Liberty | Texas | 48291 | 8105 | 191 |
1428851 | 1428851 | 2021-06-17 | Sampson | North Carolina | 37163 | 8105 | 114 |
1292967 | 1292967 | 2021-05-06 | Greenwood | South Carolina | 45047 | 8105 | 172 |
1284371 | 1284371 | 2021-05-04 | Columbia | Florida | 12023 | 8105 | 169 |
1225955 | 1225955 | 2021-04-16 | Nassau | Florida | 12089 | 8105 | 123 |
1202639 | 1202639 | 2021-04-08 | Roanoke city | Virginia | 51770 | 8105 | 184 |
1152126 | 1152126 | 2021-03-24 | Hampshire | Massachusetts | 25015 | 8105 | 279 |
1010275 | 1010275 | 2021-02-08 | Payne | Oklahoma | 40119 | 8105 | 43 |
992885 | 992885 | 2021-02-03 | Hardin | Kentucky | 21093 | 8105 | 75 |
812247 | 812247 | 2020-12-09 | Canadian | Oklahoma | 40017 | 8105 | 36 |
803810 | 803810 | 2020-12-07 | Marin | California | 6041 | 8105 | 132 |
745151 | 745151 | 2020-11-18 | Sheboygan | Wisconsin | 55117 | 8105 | 50 |
696272 | 696272 | 2020-11-03 | Loudoun | Virginia | 51107 | 8105 | 132 |
622595 | 622595 | 2020-10-12 | St. Clair | Illinois | 17163 | 8105 | 202 |
573852 | 573852 | 2020-09-27 | Canyon | Idaho | 16027 | 8105 | 101 |
570610 | 570610 | 2020-09-26 | Canyon | Idaho | 16027 | 8105 | 101 |
567368 | 567368 | 2020-09-25 | Canyon | Idaho | 16027 | 8105 | 101 |
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);