ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
35 rows where cases = 11705 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 21
- Iowa 7
- Georgia 3
- New York 3
- North Carolina 3
- Illinois 2
- Ohio 2
- Alabama 1
- Arizona 1
- California 1
- Colorado 1
- Hawaii 1
- Louisiana 1
- Maine 1
- Michigan 1
- Minnesota 1
- Missouri 1
- New Jersey 1
- North Dakota 1
- Pennsylvania 1
- South Carolina 1
- Wisconsin 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2417235 | 2417235 | 2022-04-17 | Union | Pennsylvania | 42119 | 11705 | 153 |
2397246 | 2397246 | 2022-04-11 | Livingston | New York | 36051 | 11705 | 115 |
2393440 | 2393440 | 2022-04-10 | Unknown | Michigan | 11705 | 38 | |
2360000 | 2360000 | 2022-03-31 | Colquitt | Georgia | 13071 | 11705 | 240 |
2286636 | 2286636 | 2022-03-08 | Montgomery | New York | 36057 | 11705 | 199 |
1966655 | 1966655 | 2021-11-30 | Hawaii | Hawaii | 15001 | 11705 | 138 |
1963388 | 1963388 | 2021-11-29 | Walker | Georgia | 13295 | 11705 | 158 |
1923756 | 1923756 | 2021-11-16 | Chippewa | Wisconsin | 55017 | 11705 | 125 |
1886981 | 1886981 | 2021-11-05 | Scioto | Ohio | 39145 | 11705 | 177 |
1825096 | 1825096 | 2021-10-17 | Rockingham | North Carolina | 37157 | 11705 | 192 |
1821847 | 1821847 | 2021-10-16 | Rockingham | North Carolina | 37157 | 11705 | 192 |
1818598 | 1818598 | 2021-10-15 | Rockingham | North Carolina | 37157 | 11705 | 192 |
1811919 | 1811919 | 2021-10-13 | Hunterdon | New Jersey | 34019 | 11705 | 190 |
1766684 | 1766684 | 2021-09-29 | Ward | North Dakota | 38101 | 11705 | 209 |
1727523 | 1727523 | 2021-09-17 | Putnam | New York | 36079 | 11705 | 95 |
1719165 | 1719165 | 2021-09-15 | DeKalb | Alabama | 1049 | 11705 | 220 |
1716513 | 1716513 | 2021-09-14 | DeKalb | Illinois | 17037 | 11705 | 131 |
1636204 | 1636204 | 2021-08-20 | Cole | Missouri | 29051 | 11705 | 141 |
1625812 | 1625812 | 2021-08-17 | Pottawattamie | Iowa | 19155 | 11705 | 178 |
1622565 | 1622565 | 2021-08-16 | Pottawattamie | Iowa | 19155 | 11705 | 178 |
1619318 | 1619318 | 2021-08-15 | Pottawattamie | Iowa | 19155 | 11705 | 178 |
1616070 | 1616070 | 2021-08-14 | Pottawattamie | Iowa | 19155 | 11705 | 178 |
1612821 | 1612821 | 2021-08-13 | Pottawattamie | Iowa | 19155 | 11705 | 178 |
1609573 | 1609573 | 2021-08-12 | Pottawattamie | Iowa | 19155 | 11705 | 178 |
1606324 | 1606324 | 2021-08-11 | Pottawattamie | Iowa | 19155 | 11705 | 178 |
1560065 | 1560065 | 2021-07-28 | Apache | Arizona | 4001 | 11705 | 438 |
1009256 | 1009256 | 2021-02-08 | Cumberland | Maine | 23005 | 11705 | 167 |
953391 | 953391 | 2021-01-22 | Paulding | Georgia | 13223 | 11705 | 139 |
843949 | 843949 | 2020-12-19 | St. Louis | Minnesota | 27137 | 11705 | 177 |
829864 | 829864 | 2020-12-15 | Pueblo | Colorado | 8101 | 11705 | 237 |
815479 | 815479 | 2020-12-10 | Warren | Ohio | 39165 | 11705 | 92 |
739821 | 739821 | 2020-11-17 | Caddo | Louisiana | 22017 | 11705 | 427 |
680520 | 680520 | 2020-10-30 | Monterey | California | 6053 | 11705 | 95 |
637323 | 637323 | 2020-10-16 | Horry | South Carolina | 45051 | 11705 | 207 |
502717 | 502717 | 2020-09-05 | Kane | Illinois | 17089 | 11705 | 317 |
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);