ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
35 rows where cases = 9071 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 22
- Florida 7
- Nevada 3
- Kansas 2
- Mississippi 2
- New Mexico 2
- New York 2
- Wisconsin 2
- Alabama 1
- Arkansas 1
- Georgia 1
- Illinois 1
- Indiana 1
- Louisiana 1
- Maryland 1
- Minnesota 1
- Missouri 1
- New Jersey 1
- North Carolina 1
- Ohio 1
- Pennsylvania 1
- Tennessee 1
- Texas 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2446496 | 2446496 | 2022-04-26 | Clinton | Pennsylvania | 42035 | 9071 | 126 |
2377191 | 2377191 | 2022-04-05 | Freeborn | Minnesota | 27047 | 9071 | 74 |
2339984 | 2339984 | 2022-03-24 | Green | Wisconsin | 55045 | 9071 | 53 |
2267110 | 2267110 | 2022-03-02 | Franklin | New York | 36033 | 9071 | 44 |
2110337 | 2110337 | 2022-01-13 | Calvert | Maryland | 24009 | 9071 | 111 |
2086331 | 2086331 | 2022-01-05 | Shawano | Wisconsin | 55115 | 9071 | 113 |
2020910 | 2020910 | 2021-12-16 | Navarro | Texas | 48349 | 9071 | 193 |
2015300 | 2015300 | 2021-12-15 | Effingham | Georgia | 13103 | 9071 | 175 |
1899452 | 1899452 | 2021-11-09 | Taney | Missouri | 29213 | 9071 | 153 |
1893111 | 1893111 | 2021-11-07 | Carson City | Nevada | 32510 | 9071 | 157 |
1889861 | 1889861 | 2021-11-06 | Carson City | Nevada | 32510 | 9071 | 157 |
1886611 | 1886611 | 2021-11-05 | Carson City | Nevada | 32510 | 9071 | 157 |
1791005 | 1791005 | 2021-10-07 | Suwannee | Florida | 12121 | 9071 | 166 |
1787756 | 1787756 | 2021-10-06 | Suwannee | Florida | 12121 | 9071 | 166 |
1789465 | 1789465 | 2021-10-06 | Hancock | Ohio | 39063 | 9071 | 147 |
1784507 | 1784507 | 2021-10-05 | Suwannee | Florida | 12121 | 9071 | 166 |
1781258 | 1781258 | 2021-10-04 | Suwannee | Florida | 12121 | 9071 | 166 |
1778008 | 1778008 | 2021-10-03 | Suwannee | Florida | 12121 | 9071 | 166 |
1774758 | 1774758 | 2021-10-02 | Suwannee | Florida | 12121 | 9071 | 160 |
1771508 | 1771508 | 2021-10-01 | Suwannee | Florida | 12121 | 9071 | 160 |
1671361 | 1671361 | 2021-08-31 | Leavenworth | Kansas | 20103 | 9071 | 107 |
1668114 | 1668114 | 2021-08-30 | Leavenworth | Kansas | 20103 | 9071 | 107 |
1645882 | 1645882 | 2021-08-23 | Lamar | Mississippi | 28073 | 9071 | 99 |
1594308 | 1594308 | 2021-08-07 | Chautauqua | New York | 36013 | 9071 | 146 |
1423767 | 1423767 | 2021-06-16 | Jefferson | Arkansas | 5069 | 9071 | 170 |
1395579 | 1395579 | 2021-06-07 | St. Landry | Louisiana | 22097 | 9071 | 260 |
1350797 | 1350797 | 2021-05-24 | Lea | New Mexico | 35025 | 9071 | 195 |
1243642 | 1243642 | 2021-04-21 | Chaves | New Mexico | 35005 | 9071 | 167 |
1236025 | 1236025 | 2021-04-19 | Vermilion | Illinois | 17183 | 9071 | 144 |
1224956 | 1224956 | 2021-04-15 | Unknown | Tennessee | 9071 | 119 | |
1219839 | 1219839 | 2021-04-14 | Kosciusko | Indiana | 18085 | 9071 | 117 |
1220895 | 1220895 | 2021-04-14 | Hunterdon | New Jersey | 34019 | 9071 | 171 |
1019770 | 1019770 | 2021-02-11 | Nash | North Carolina | 37127 | 9071 | 150 |
960837 | 960837 | 2021-01-24 | Lee | Mississippi | 28081 | 9071 | 145 |
858785 | 858785 | 2020-12-24 | Calhoun | Alabama | 1015 | 9071 | 148 |
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);