ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
39 rows where cases = 9159 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 21
- Kentucky 8
- Michigan 3
- North Carolina 3
- South Carolina 3
- Georgia 2
- New Mexico 2
- Ohio 2
- Pennsylvania 2
- Virginia 2
- Alabama 1
- Arizona 1
- Colorado 1
- Idaho 1
- Indiana 1
- Louisiana 1
- Missouri 1
- New Hampshire 1
- New York 1
- Oklahoma 1
- Oregon 1
- Texas 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2500316 | 2500316 | 2022-05-13 | Jasper | Indiana | 18073 | 9159 | 149 |
2352682 | 2352682 | 2022-03-28 | Washington | Texas | 48477 | 9159 | 146 |
2328836 | 2328836 | 2022-03-21 | Sullivan | New Hampshire | 33019 | 9159 | 67 |
2324840 | 2324840 | 2022-03-20 | Harlan | Kentucky | 21095 | 9159 | 189 |
2321586 | 2321586 | 2022-03-19 | Harlan | Kentucky | 21095 | 9159 | 189 |
2318332 | 2318332 | 2022-03-18 | Harlan | Kentucky | 21095 | 9159 | 189 |
2315079 | 2315079 | 2022-03-17 | Harlan | Kentucky | 21095 | 9159 | 189 |
2311826 | 2311826 | 2022-03-16 | Harlan | Kentucky | 21095 | 9159 | 189 |
2308573 | 2308573 | 2022-03-15 | Harlan | Kentucky | 21095 | 9159 | 189 |
2305322 | 2305322 | 2022-03-14 | Harlan | Kentucky | 21095 | 9159 | 189 |
2260699 | 2260699 | 2022-02-28 | Jackson | North Carolina | 37099 | 9159 | 84 |
2169525 | 2169525 | 2022-01-31 | Rio Arriba | New Mexico | 35039 | 9159 | 111 |
2153529 | 2153529 | 2022-01-26 | Madison | Ohio | 39097 | 9159 | 113 |
2137478 | 2137478 | 2022-01-21 | Wayne | Pennsylvania | 42127 | 9159 | 148 |
2015127 | 2015127 | 2021-12-15 | Garfield | Colorado | 8045 | 9159 | 76 |
1989442 | 1989442 | 2021-12-07 | Madison | Idaho | 16065 | 9159 | 42 |
1964828 | 1964828 | 2021-11-29 | Pender | North Carolina | 37141 | 9159 | 102 |
1878825 | 1878825 | 2021-11-03 | Laurens | Georgia | 13175 | 9159 | 240 |
1847181 | 1847181 | 2021-10-24 | Van Buren | Michigan | 26159 | 9159 | 163 |
1843931 | 1843931 | 2021-10-23 | Van Buren | Michigan | 26159 | 9159 | 163 |
1840681 | 1840681 | 2021-10-22 | Van Buren | Michigan | 26159 | 9159 | 163 |
1757319 | 1757319 | 2021-09-26 | Georgetown | South Carolina | 45043 | 9159 | 159 |
1754071 | 1754071 | 2021-09-25 | Georgetown | South Carolina | 45043 | 9159 | 159 |
1750823 | 1750823 | 2021-09-24 | Georgetown | South Carolina | 45043 | 9159 | 159 |
1631945 | 1631945 | 2021-08-19 | Rockdale | Georgia | 13247 | 9159 | 184 |
1611733 | 1611733 | 2021-08-12 | Roanoke city | Virginia | 51770 | 9159 | 201 |
1555072 | 1555072 | 2021-07-26 | St. Francois | Missouri | 29187 | 9159 | 117 |
1536067 | 1536067 | 2021-07-20 | Columbiana | Ohio | 39029 | 9159 | 236 |
1444266 | 1444266 | 2021-06-22 | St. Landry | Louisiana | 22097 | 9159 | 261 |
1289098 | 1289098 | 2021-05-05 | Chaves | New Mexico | 35005 | 9159 | 170 |
1276602 | 1276602 | 2021-05-01 | Mercer | Pennsylvania | 42085 | 9159 | 254 |
1186650 | 1186650 | 2021-04-04 | Lauderdale | Alabama | 1077 | 9159 | 227 |
1169371 | 1169371 | 2021-03-29 | Jackson | Oregon | 41029 | 9159 | 120 |
1033827 | 1033827 | 2021-02-15 | Stafford | Virginia | 51179 | 9159 | 54 |
1012344 | 1012344 | 2021-02-09 | Daviess | Kentucky | 21059 | 9159 | 150 |
834736 | 834736 | 2020-12-16 | Catawba | North Carolina | 37035 | 9159 | 117 |
810198 | 810198 | 2020-12-09 | Navajo | Arizona | 4017 | 9159 | 283 |
397786 | 397786 | 2020-08-03 | Tulsa | Oklahoma | 40143 | 9159 | 101 |
117067 | 117067 | 2020-05-05 | Orange | New York | 36071 | 9159 | 256 |
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);