ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
48 rows where cases = 7896 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 23
- Texas 7
- North Carolina 5
- Missouri 4
- Michigan 3
- Pennsylvania 3
- Arkansas 2
- Florida 2
- Indiana 2
- Kansas 2
- New Mexico 2
- New York 2
- Ohio 2
- Virginia 2
- Georgia 1
- Idaho 1
- Illinois 1
- Kentucky 1
- Montana 1
- South Carolina 1
- Tennessee 1
- Washington 1
- West Virginia 1
- Wyoming 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2502394 | 2502394 | 2022-05-13 | Polk | Texas | 48373 | 7896 | 247 |
2426494 | 2426494 | 2022-04-20 | Cibola | New Mexico | 35006 | 7896 | 185 |
2313909 | 2313909 | 2022-03-16 | Mingo | West Virginia | 54059 | 7896 | 119 |
2269454 | 2269454 | 2022-03-03 | McPherson | Kansas | 20113 | 7896 | 124 |
2266201 | 2266201 | 2022-03-02 | McPherson | Kansas | 20113 | 7896 | 124 |
2251070 | 2251070 | 2022-02-25 | Coshocton | Ohio | 39031 | 7896 | 150 |
2216106 | 2216106 | 2022-02-14 | Wood | Texas | 48499 | 7896 | 262 |
2199287 | 2199287 | 2022-02-09 | Snyder | Pennsylvania | 42109 | 7896 | 148 |
2156574 | 2156574 | 2022-01-27 | Wyoming | New York | 36121 | 7896 | 80 |
2146456 | 2146456 | 2022-01-24 | Howell | Missouri | 29091 | 7896 | 183 |
2137030 | 2137030 | 2022-01-21 | Orleans | New York | 36073 | 7896 | 105 |
2137447 | 2137447 | 2022-01-21 | Jefferson | Pennsylvania | 42065 | 7896 | 200 |
2126900 | 2126900 | 2022-01-18 | Camden | Missouri | 29029 | 7896 | 155 |
2033566 | 2033566 | 2021-12-20 | Newberry | South Carolina | 45071 | 7896 | 153 |
2026205 | 2026205 | 2021-12-18 | Scott | Missouri | 29201 | 7896 | 132 |
2006366 | 2006366 | 2021-12-12 | Chippewa | Michigan | 26033 | 7896 | 78 |
2003115 | 2003115 | 2021-12-11 | Chippewa | Michigan | 26033 | 7896 | 78 |
1999865 | 1999865 | 2021-12-10 | Chippewa | Michigan | 26033 | 7896 | 78 |
1958675 | 1958675 | 2021-11-27 | Venango | Pennsylvania | 42121 | 7896 | 163 |
1845465 | 1845465 | 2021-10-23 | Van Zandt | Texas | 48467 | 7896 | 208 |
1842215 | 1842215 | 2021-10-22 | Van Zandt | Texas | 48467 | 7896 | 207 |
1838966 | 1838966 | 2021-10-21 | Van Zandt | Texas | 48467 | 7896 | 207 |
1833911 | 1833911 | 2021-10-20 | Henderson | Kentucky | 21101 | 7896 | 98 |
1835717 | 1835717 | 2021-10-20 | Van Zandt | Texas | 48467 | 7896 | 207 |
1832468 | 1832468 | 2021-10-19 | Van Zandt | Texas | 48467 | 7896 | 205 |
1784103 | 1784103 | 2021-10-04 | Campbell | Wyoming | 56005 | 7896 | 77 |
1765350 | 1765350 | 2021-09-29 | Dubois | Indiana | 18037 | 7896 | 126 |
1767178 | 1767178 | 2021-09-29 | Dyer | Tennessee | 47045 | 7896 | 134 |
1699441 | 1699441 | 2021-09-08 | Rockingham | Virginia | 51165 | 7896 | 117 |
1672546 | 1672546 | 2021-08-31 | Ross | Ohio | 39141 | 7896 | 168 |
1638070 | 1638070 | 2021-08-21 | Greene | Arkansas | 5055 | 7896 | 87 |
1607273 | 1607273 | 2021-08-11 | Eddy | New Mexico | 35015 | 7896 | 148 |
1402883 | 1402883 | 2021-06-09 | Rockingham | North Carolina | 37157 | 7896 | 135 |
1373679 | 1373679 | 2021-05-31 | Stanly | North Carolina | 37167 | 7896 | 134 |
1370434 | 1370434 | 2021-05-30 | Stanly | North Carolina | 37167 | 7896 | 134 |
1367188 | 1367188 | 2021-05-29 | Stanly | North Carolina | 37167 | 7896 | 134 |
1363942 | 1363942 | 2021-05-28 | Stanly | North Carolina | 37167 | 7896 | 134 |
1232269 | 1232269 | 2021-04-18 | White | Arkansas | 5145 | 7896 | 118 |
1183209 | 1183209 | 2021-04-02 | Thurston | Washington | 53067 | 7896 | 84 |
1108459 | 1108459 | 2021-03-10 | Portsmouth city | Virginia | 51740 | 7896 | 151 |
972981 | 972981 | 2021-01-28 | DeKalb | Illinois | 17037 | 7896 | 103 |
967403 | 967403 | 2021-01-26 | Franklin | Missouri | 29071 | 7896 | 131 |
875757 | 875757 | 2020-12-29 | Monroe | Indiana | 18105 | 7896 | 96 |
821457 | 821457 | 2020-12-12 | Flathead | Montana | 30029 | 7896 | 44 |
774730 | 774730 | 2020-11-28 | Clay | Florida | 12019 | 7896 | 148 |
632149 | 632149 | 2020-10-15 | Richmond | Georgia | 13245 | 7896 | 173 |
551176 | 551176 | 2020-09-20 | Canyon | Idaho | 16027 | 7896 | 99 |
473350 | 473350 | 2020-08-27 | Seminole | Florida | 12117 | 7896 | 169 |
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);