ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
68 rows where deaths = 1092 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 19
- Florida 9
- Pennsylvania 9
- Iowa 7
- Illinois 6
- California 5
- Georgia 4
- New Jersey 4
- Texas 4
- Colorado 3
- Connecticut 3
- Louisiana 3
- Maryland 2
- Massachusetts 2
- Wisconsin 2
- Kansas 1
- Michigan 1
- North Carolina 1
- Virginia 1
- Washington 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2476742 | 2476742 | 2022-05-05 | Waukesha | Wisconsin | 55133 | 114443 | 1092 |
2473484 | 2473484 | 2022-05-04 | Waukesha | Wisconsin | 55133 | 114304 | 1092 |
2467378 | 2467378 | 2022-05-03 | Seminole | Florida | 12117 | 104213 | 1092 |
2464123 | 2464123 | 2022-05-02 | Seminole | Florida | 12117 | 104213 | 1092 |
2460867 | 2460867 | 2022-05-01 | Seminole | Florida | 12117 | 104213 | 1092 |
2457611 | 2457611 | 2022-04-30 | Seminole | Florida | 12117 | 104213 | 1092 |
2454355 | 2454355 | 2022-04-29 | Seminole | Florida | 12117 | 104213 | 1092 |
2451099 | 2451099 | 2022-04-28 | Seminole | Florida | 12117 | 104213 | 1092 |
2453039 | 2453039 | 2022-04-28 | Northampton | Pennsylvania | 42095 | 80502 | 1092 |
2447843 | 2447843 | 2022-04-27 | Seminole | Florida | 12117 | 104213 | 1092 |
2449783 | 2449783 | 2022-04-27 | Northampton | Pennsylvania | 42095 | 80408 | 1092 |
2422290 | 2422290 | 2022-04-19 | Polk | Iowa | 19153 | 124811 | 1092 |
2419034 | 2419034 | 2022-04-18 | Polk | Iowa | 19153 | 124811 | 1092 |
2415778 | 2415778 | 2022-04-17 | Polk | Iowa | 19153 | 124811 | 1092 |
2412522 | 2412522 | 2022-04-16 | Polk | Iowa | 19153 | 124811 | 1092 |
2409266 | 2409266 | 2022-04-15 | Polk | Iowa | 19153 | 124811 | 1092 |
2406010 | 2406010 | 2022-04-14 | Polk | Iowa | 19153 | 124811 | 1092 |
2402754 | 2402754 | 2022-04-13 | Polk | Iowa | 19153 | 124811 | 1092 |
2247686 | 2247686 | 2022-02-24 | Guilford | North Carolina | 37081 | 113940 | 1092 |
2151610 | 2151610 | 2022-01-26 | Contra Costa | California | 6013 | 172490 | 1092 |
2148358 | 2148358 | 2022-01-25 | Contra Costa | California | 6013 | 170859 | 1092 |
2145106 | 2145106 | 2022-01-24 | Contra Costa | California | 6013 | 169496 | 1092 |
2108182 | 2108182 | 2022-01-12 | Lehigh | Pennsylvania | 42077 | 78188 | 1092 |
2056191 | 2056191 | 2021-12-27 | Westmoreland | Pennsylvania | 42129 | 57974 | 1092 |
2052942 | 2052942 | 2021-12-26 | Westmoreland | Pennsylvania | 42129 | 57907 | 1092 |
2049692 | 2049692 | 2021-12-25 | Westmoreland | Pennsylvania | 42129 | 57796 | 1092 |
2046442 | 2046442 | 2021-12-24 | Westmoreland | Pennsylvania | 42129 | 57529 | 1092 |
1991185 | 1991185 | 2021-12-07 | York | Pennsylvania | 42133 | 73026 | 1092 |
1965945 | 1965945 | 2021-11-29 | Spokane | Washington | 53063 | 77869 | 1092 |
1910389 | 1910389 | 2021-11-12 | Montgomery | Texas | 48339 | 88670 | 1092 |
1846122 | 1846122 | 2021-10-24 | El Paso | Colorado | 8041 | 99562 | 1092 |
1842872 | 1842872 | 2021-10-23 | El Paso | Colorado | 8041 | 99562 | 1092 |
1839622 | 1839622 | 2021-10-22 | El Paso | Colorado | 8041 | 99562 | 1092 |
1779896 | 1779896 | 2021-10-03 | Berks | Pennsylvania | 42011 | 55072 | 1092 |
1733276 | 1733276 | 2021-09-19 | East Baton Rouge | Louisiana | 22033 | 61634 | 1092 |
1730026 | 1730026 | 2021-09-18 | East Baton Rouge | Louisiana | 22033 | 61634 | 1092 |
1726776 | 1726776 | 2021-09-17 | East Baton Rouge | Louisiana | 22033 | 61634 | 1092 |
1605884 | 1605884 | 2021-08-11 | DeKalb | Georgia | 13089 | 73178 | 1092 |
1602635 | 1602635 | 2021-08-10 | DeKalb | Georgia | 13089 | 72905 | 1092 |
1466463 | 1466463 | 2021-06-29 | Lake | Illinois | 17097 | 68451 | 1092 |
1463218 | 1463218 | 2021-06-28 | Lake | Illinois | 17097 | 68444 | 1092 |
1375638 | 1375638 | 2021-06-01 | Will | Illinois | 17197 | 76648 | 1092 |
1372393 | 1372393 | 2021-05-31 | Will | Illinois | 17197 | 76635 | 1092 |
1369148 | 1369148 | 2021-05-30 | Will | Illinois | 17197 | 76593 | 1092 |
1358425 | 1358425 | 2021-05-26 | Fairfax | Virginia | 51059 | 76877 | 1092 |
1060991 | 1060991 | 2021-02-24 | Unknown | Kansas | 0 | 1092 | |
1050708 | 1050708 | 2021-02-21 | Fulton | Georgia | 13121 | 83722 | 1092 |
1047461 | 1047461 | 2021-02-20 | Fulton | Georgia | 13121 | 83521 | 1092 |
1032580 | 1032580 | 2021-02-15 | Camden | New Jersey | 34007 | 42469 | 1092 |
1029333 | 1029333 | 2021-02-14 | Camden | New Jersey | 34007 | 42416 | 1092 |
954096 | 954096 | 2021-01-22 | Baltimore | Maryland | 24005 | 45229 | 1092 |
904833 | 904833 | 2021-01-07 | DuPage | Illinois | 17043 | 64755 | 1092 |
894826 | 894826 | 2021-01-04 | Hillsborough | Florida | 12057 | 80586 | 1092 |
863240 | 863240 | 2020-12-25 | Montgomery | Maryland | 24031 | 43961 | 1092 |
743745 | 743745 | 2020-11-18 | Ocean | New Jersey | 34029 | 19230 | 1092 |
712149 | 712149 | 2020-11-08 | Cameron | Texas | 48061 | 24598 | 1092 |
708905 | 708905 | 2020-11-07 | Cameron | Texas | 48061 | 24598 | 1092 |
703233 | 703233 | 2020-11-06 | San Bernardino | California | 6071 | 67777 | 1092 |
705661 | 705661 | 2020-11-06 | Cameron | Texas | 48061 | 24598 | 1092 |
699990 | 699990 | 2020-11-05 | San Bernardino | California | 6071 | 67196 | 1092 |
671870 | 671870 | 2020-10-27 | Macomb | Michigan | 26099 | 18793 | 1092 |
454833 | 454833 | 2020-08-21 | Suffolk | Massachusetts | 25025 | 22694 | 1092 |
357343 | 357343 | 2020-07-22 | New Haven | Connecticut | 9009 | 12825 | 1092 |
354140 | 354140 | 2020-07-21 | New Haven | Connecticut | 9009 | 12794 | 1092 |
350938 | 350938 | 2020-07-20 | New Haven | Connecticut | 9009 | 12788 | 1092 |
315899 | 315899 | 2020-07-09 | Miami-Dade | Florida | 12086 | 55960 | 1092 |
275696 | 275696 | 2020-06-26 | Essex | Massachusetts | 25009 | 15975 | 1092 |
210867 | 210867 | 2020-06-05 | Union | New Jersey | 34039 | 16038 | 1092 |
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);