ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
74 rows where deaths = 1074 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 25
- Texas 8
- Illinois 7
- Florida 6
- Ohio 6
- Georgia 5
- Massachusetts 5
- New Jersey 5
- Pennsylvania 5
- California 3
- Colorado 3
- Virginia 3
- Arizona 2
- Kansas 2
- Louisiana 2
- Michigan 2
- Connecticut 1
- Delaware 1
- District of Columbia 1
- Maryland 1
- New Mexico 1
- New York 1
- North Carolina 1
- Oregon 1
- Tennessee 1
- Utah 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2474719 | 2474719 | 2022-05-05 | Anne Arundel | Maryland | 24003 | 91543 | 1074 |
2353416 | 2353416 | 2022-03-29 | Hernando | Florida | 12053 | 41896 | 1074 |
2350164 | 2350164 | 2022-03-28 | Hernando | Florida | 12053 | 41896 | 1074 |
2346911 | 2346911 | 2022-03-27 | Hernando | Florida | 12053 | 41896 | 1074 |
2343658 | 2343658 | 2022-03-26 | Hernando | Florida | 12053 | 41896 | 1074 |
2340405 | 2340405 | 2022-03-25 | Hernando | Florida | 12053 | 41896 | 1074 |
2337152 | 2337152 | 2022-03-24 | Hernando | Florida | 12053 | 41798 | 1074 |
2290328 | 2290328 | 2022-03-09 | Northampton | Pennsylvania | 42095 | 78974 | 1074 |
2287018 | 2287018 | 2022-03-08 | Multnomah | Oregon | 41051 | 111494 | 1074 |
2264557 | 2264557 | 2022-03-01 | Hamilton | Tennessee | 47065 | 97442 | 1074 |
2220889 | 2220889 | 2022-02-16 | Orleans | Louisiana | 22071 | 85717 | 1074 |
2201376 | 2201376 | 2022-02-10 | Orleans | Louisiana | 22071 | 85107 | 1074 |
2177557 | 2177557 | 2022-02-03 | Yavapai | Arizona | 4025 | 45423 | 1074 |
2174304 | 2174304 | 2022-02-02 | Yavapai | Arizona | 4025 | 45182 | 1074 |
2155316 | 2155316 | 2022-01-27 | Kane | Illinois | 17089 | 117562 | 1074 |
2149960 | 2149960 | 2022-01-25 | Burlington | New Jersey | 34005 | 95355 | 1074 |
2111834 | 2111834 | 2022-01-13 | Fort Bend | Texas | 48157 | 143527 | 1074 |
2108582 | 2108582 | 2022-01-12 | Fort Bend | Texas | 48157 | 141767 | 1074 |
2071915 | 2071915 | 2022-01-01 | Mercer | New Jersey | 34021 | 52396 | 1074 |
2041108 | 2041108 | 2021-12-23 | Adams | Colorado | 8001 | 90968 | 1074 |
2037858 | 2037858 | 2021-12-22 | Adams | Colorado | 8001 | 90968 | 1074 |
2037888 | 2037888 | 2021-12-22 | Jefferson | Colorado | 8059 | 77298 | 1074 |
2039943 | 2039943 | 2021-12-22 | Westmoreland | Pennsylvania | 42129 | 56959 | 1074 |
2014296 | 2014296 | 2021-12-14 | Denton | Texas | 48121 | 112941 | 1074 |
2011045 | 2011045 | 2021-12-13 | Denton | Texas | 48121 | 112750 | 1074 |
2007794 | 2007794 | 2021-12-12 | Denton | Texas | 48121 | 112576 | 1074 |
2004543 | 2004543 | 2021-12-11 | Denton | Texas | 48121 | 112576 | 1074 |
1995673 | 1995673 | 2021-12-09 | New Castle | Delaware | 10003 | 89970 | 1074 |
1973586 | 1973586 | 2021-12-02 | Sedgwick | Kansas | 20173 | 87331 | 1074 |
1970336 | 1970336 | 2021-12-01 | Sedgwick | Kansas | 20173 | 87331 | 1074 |
1860991 | 1860991 | 2021-10-28 | Stark | Ohio | 39151 | 47255 | 1074 |
1857742 | 1857742 | 2021-10-27 | Stark | Ohio | 39151 | 47109 | 1074 |
1854493 | 1854493 | 2021-10-26 | Stark | Ohio | 39151 | 46983 | 1074 |
1837376 | 1837376 | 2021-10-21 | Genesee | Michigan | 26049 | 50989 | 1074 |
1834127 | 1834127 | 2021-10-20 | Genesee | Michigan | 26049 | 50989 | 1074 |
1782690 | 1782690 | 2021-10-04 | Bernalillo | New Mexico | 35001 | 71952 | 1074 |
1761025 | 1761025 | 2021-09-27 | Salt Lake | Utah | 49035 | 181412 | 1074 |
1737658 | 1737658 | 2021-09-20 | Berks | Pennsylvania | 42011 | 53313 | 1074 |
1734408 | 1734408 | 2021-09-19 | Berks | Pennsylvania | 42011 | 53228 | 1074 |
1701619 | 1701619 | 2021-09-09 | Mecklenburg | North Carolina | 37119 | 140432 | 1074 |
1633550 | 1633550 | 2021-08-19 | Montgomery | Ohio | 39113 | 56699 | 1074 |
1630303 | 1630303 | 2021-08-18 | Montgomery | Ohio | 39113 | 56490 | 1074 |
1627056 | 1627056 | 2021-08-17 | Montgomery | Ohio | 39113 | 56277 | 1074 |
1618047 | 1618047 | 2021-08-14 | Travis | Texas | 48453 | 95054 | 1074 |
1469491 | 1469491 | 2021-06-30 | DeKalb | Georgia | 13089 | 67767 | 1074 |
1466049 | 1466049 | 2021-06-29 | Stanislaus | California | 6099 | 63700 | 1074 |
1466246 | 1466246 | 2021-06-29 | DeKalb | Georgia | 13089 | 67745 | 1074 |
1462804 | 1462804 | 2021-06-28 | Stanislaus | California | 6099 | 63685 | 1074 |
1463001 | 1463001 | 2021-06-28 | DeKalb | Georgia | 13089 | 67745 | 1074 |
1459756 | 1459756 | 2021-06-27 | DeKalb | Georgia | 13089 | 67727 | 1074 |
1456511 | 1456511 | 2021-06-26 | DeKalb | Georgia | 13089 | 67710 | 1074 |
1369098 | 1369098 | 2021-05-30 | Lake | Illinois | 17097 | 68046 | 1074 |
1365852 | 1365852 | 2021-05-29 | Lake | Illinois | 17097 | 68022 | 1074 |
1362606 | 1362606 | 2021-05-28 | Lake | Illinois | 17097 | 67989 | 1074 |
1359359 | 1359359 | 2021-05-27 | Lake | Illinois | 17097 | 67941 | 1074 |
1336681 | 1336681 | 2021-05-20 | Will | Illinois | 17197 | 76093 | 1074 |
1321619 | 1321619 | 2021-05-15 | Monroe | New York | 36055 | 66701 | 1074 |
1296737 | 1296737 | 2021-05-07 | Fairfax | Virginia | 51059 | 76317 | 1074 |
1290245 | 1290245 | 2021-05-05 | Fairfax | Virginia | 51059 | 76144 | 1074 |
1286999 | 1286999 | 2021-05-04 | Fairfax | Virginia | 51059 | 76044 | 1074 |
1193430 | 1193430 | 2021-04-06 | District of Columbia | District of Columbia | 11001 | 45234 | 1074 |
1153189 | 1153189 | 2021-03-24 | Lancaster | Pennsylvania | 42071 | 46596 | 1074 |
898343 | 898343 | 2021-01-05 | DuPage | Illinois | 17043 | 63831 | 1074 |
780334 | 780334 | 2020-11-29 | El Paso | Texas | 48141 | 85696 | 1074 |
701572 | 701572 | 2020-11-05 | Ocean | New Jersey | 34029 | 17336 | 1074 |
680529 | 680529 | 2020-10-30 | San Bernardino | California | 6071 | 64367 | 1074 |
603692 | 603692 | 2020-10-06 | Norfolk | Massachusetts | 25021 | 10608 | 1074 |
532426 | 532426 | 2020-09-14 | Worcester | Massachusetts | 25027 | 13877 | 1074 |
529190 | 529190 | 2020-09-13 | Worcester | Massachusetts | 25027 | 13842 | 1074 |
419352 | 419352 | 2020-08-10 | Suffolk | Massachusetts | 25025 | 21929 | 1074 |
416131 | 416131 | 2020-08-09 | Suffolk | Massachusetts | 25025 | 21849 | 1074 |
293688 | 293688 | 2020-07-02 | New Haven | Connecticut | 9009 | 12383 | 1074 |
235633 | 235633 | 2020-06-13 | Middlesex | New Jersey | 34023 | 16385 | 1074 |
198553 | 198553 | 2020-06-01 | Union | New Jersey | 34039 | 15858 | 1074 |
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);