ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
101 rows where deaths = 892 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 24
- Pennsylvania 22
- Texas 15
- New York 9
- New Jersey 8
- Florida 5
- Massachusetts 5
- Ohio 5
- Colorado 4
- New Hampshire 4
- Arizona 3
- Georgia 3
- North Carolina 3
- Illinois 2
- Indiana 2
- Utah 2
- Alabama 1
- Louisiana 1
- Maryland 1
- Minnesota 1
- Missouri 1
- New Mexico 1
- South Carolina 1
- Tennessee 1
- Washington 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2501867 | 2501867 | 2022-05-13 | Cumberland | Pennsylvania | 42041 | 51754 | 892 |
2498609 | 2498609 | 2022-05-12 | Cumberland | Pennsylvania | 42041 | 51754 | 892 |
2495351 | 2495351 | 2022-05-11 | Cumberland | Pennsylvania | 42041 | 51754 | 892 |
2492093 | 2492093 | 2022-05-10 | Cumberland | Pennsylvania | 42041 | 51406 | 892 |
2488835 | 2488835 | 2022-05-09 | Cumberland | Pennsylvania | 42041 | 51406 | 892 |
2485578 | 2485578 | 2022-05-08 | Cumberland | Pennsylvania | 42041 | 51406 | 892 |
2482320 | 2482320 | 2022-05-07 | Cumberland | Pennsylvania | 42041 | 51406 | 892 |
2479062 | 2479062 | 2022-05-06 | Cumberland | Pennsylvania | 42041 | 51406 | 892 |
2475804 | 2475804 | 2022-05-05 | Cumberland | Pennsylvania | 42041 | 51406 | 892 |
2472547 | 2472547 | 2022-05-04 | Cumberland | Pennsylvania | 42041 | 51406 | 892 |
2469291 | 2469291 | 2022-05-03 | Cumberland | Pennsylvania | 42041 | 51362 | 892 |
2466035 | 2466035 | 2022-05-02 | Cumberland | Pennsylvania | 42041 | 51327 | 892 |
2462780 | 2462780 | 2022-05-01 | Cumberland | Pennsylvania | 42041 | 51308 | 892 |
2459524 | 2459524 | 2022-04-30 | Cumberland | Pennsylvania | 42041 | 51299 | 892 |
2456268 | 2456268 | 2022-04-29 | Cumberland | Pennsylvania | 42041 | 51260 | 892 |
2453012 | 2453012 | 2022-04-28 | Cumberland | Pennsylvania | 42041 | 51224 | 892 |
2449356 | 2449356 | 2022-04-27 | Rockland | New York | 36087 | 94130 | 892 |
2446099 | 2446099 | 2022-04-26 | Rockland | New York | 36087 | 94024 | 892 |
2442844 | 2442844 | 2022-04-25 | Rockland | New York | 36087 | 93943 | 892 |
2439588 | 2439588 | 2022-04-24 | Rockland | New York | 36087 | 93887 | 892 |
2436332 | 2436332 | 2022-04-23 | Rockland | New York | 36087 | 93819 | 892 |
2433076 | 2433076 | 2022-04-22 | Rockland | New York | 36087 | 93744 | 892 |
2429820 | 2429820 | 2022-04-21 | Rockland | New York | 36087 | 93618 | 892 |
2426564 | 2426564 | 2022-04-20 | Rockland | New York | 36087 | 93544 | 892 |
2378483 | 2378483 | 2022-04-05 | Bell | Texas | 48027 | 66859 | 892 |
2375229 | 2375229 | 2022-04-04 | Bell | Texas | 48027 | 66852 | 892 |
2371977 | 2371977 | 2022-04-03 | Bell | Texas | 48027 | 66845 | 892 |
2348352 | 2348352 | 2022-03-27 | Hillsborough | New Hampshire | 33011 | 96602 | 892 |
2345099 | 2345099 | 2022-03-26 | Hillsborough | New Hampshire | 33011 | 96602 | 892 |
2341846 | 2341846 | 2022-03-25 | Hillsborough | New Hampshire | 33011 | 96602 | 892 |
2338593 | 2338593 | 2022-03-24 | Hillsborough | New Hampshire | 33011 | 96514 | 892 |
2313566 | 2313566 | 2022-03-16 | McLennan | Texas | 48309 | 56956 | 892 |
2310313 | 2310313 | 2022-03-15 | McLennan | Texas | 48309 | 56915 | 892 |
2307060 | 2307060 | 2022-03-14 | McLennan | Texas | 48309 | 56845 | 892 |
2303809 | 2303809 | 2022-03-13 | McLennan | Texas | 48309 | 56843 | 892 |
2300557 | 2300557 | 2022-03-12 | McLennan | Texas | 48309 | 56837 | 892 |
2268542 | 2268542 | 2022-03-03 | Madison | Alabama | 1089 | 88394 | 892 |
2260885 | 2260885 | 2022-02-28 | Trumbull | Ohio | 39155 | 41208 | 892 |
2257634 | 2257634 | 2022-02-27 | Trumbull | Ohio | 39155 | 41196 | 892 |
2254383 | 2254383 | 2022-02-26 | Trumbull | Ohio | 39155 | 41188 | 892 |
2251132 | 2251132 | 2022-02-25 | Trumbull | Ohio | 39155 | 41172 | 892 |
2246161 | 2246161 | 2022-02-24 | Clayton | Georgia | 13063 | 63057 | 892 |
2185751 | 2185751 | 2022-02-05 | Gloucester | New Jersey | 34015 | 67731 | 892 |
2143540 | 2143540 | 2022-01-23 | Orange | New York | 36071 | 100966 | 892 |
2056423 | 2056423 | 2021-12-27 | Hamilton | Tennessee | 47065 | 68617 | 892 |
1990662 | 1990662 | 2021-12-07 | Somerset | New Jersey | 34035 | 37119 | 892 |
1924536 | 1924536 | 2021-11-17 | Unknown | Illinois | 0 | 892 | |
1906625 | 1906625 | 2021-11-11 | Chester | Pennsylvania | 42029 | 52226 | 892 |
1903376 | 1903376 | 2021-11-10 | Chester | Pennsylvania | 42029 | 52084 | 892 |
1893292 | 1893292 | 2021-11-07 | Guilford | North Carolina | 37081 | 68533 | 892 |
1890042 | 1890042 | 2021-11-06 | Guilford | North Carolina | 37081 | 68533 | 892 |
1886792 | 1886792 | 2021-11-05 | Guilford | North Carolina | 37081 | 68533 | 892 |
1881434 | 1881434 | 2021-11-03 | Pierce | Washington | 53053 | 93522 | 892 |
1854685 | 1854685 | 2021-10-26 | Westmoreland | Pennsylvania | 42129 | 44630 | 892 |
1823387 | 1823387 | 2021-10-17 | Jefferson | Colorado | 8059 | 60831 | 892 |
1820138 | 1820138 | 2021-10-16 | Jefferson | Colorado | 8059 | 60831 | 892 |
1816889 | 1816889 | 2021-10-15 | Jefferson | Colorado | 8059 | 60831 | 892 |
1735649 | 1735649 | 2021-09-20 | Denver | Colorado | 8031 | 84212 | 892 |
1731191 | 1731191 | 2021-09-18 | Lehigh | Pennsylvania | 42077 | 44792 | 892 |
1723035 | 1723035 | 2021-09-16 | Kane | Illinois | 17089 | 65287 | 892 |
1679367 | 1679367 | 2021-09-02 | Spartanburg | South Carolina | 45083 | 50132 | 892 |
1617998 | 1617998 | 2021-08-14 | Nueces | Texas | 48355 | 47114 | 892 |
1614750 | 1614750 | 2021-08-13 | Nueces | Texas | 48355 | 47114 | 892 |
1611501 | 1611501 | 2021-08-12 | Nueces | Texas | 48355 | 46756 | 892 |
1375045 | 1375045 | 2021-06-01 | Pinal | Arizona | 4021 | 52877 | 892 |
1377832 | 1377832 | 2021-06-01 | Salt Lake | Utah | 49035 | 151004 | 892 |
1371800 | 1371800 | 2021-05-31 | Pinal | Arizona | 4021 | 52876 | 892 |
1374586 | 1374586 | 2021-05-31 | Salt Lake | Utah | 49035 | 150965 | 892 |
1368554 | 1368554 | 2021-05-30 | Pinal | Arizona | 4021 | 52877 | 892 |
1349298 | 1349298 | 2021-05-24 | Brevard | Florida | 12009 | 42676 | 892 |
1285183 | 1285183 | 2021-05-04 | Jefferson | Louisiana | 22051 | 46025 | 892 |
1136470 | 1136470 | 2021-03-19 | Bernalillo | New Mexico | 35001 | 53932 | 892 |
1125349 | 1125349 | 2021-03-16 | DeKalb | Georgia | 13089 | 59558 | 892 |
1123471 | 1123471 | 2021-03-15 | Mercer | New Jersey | 34021 | 29126 | 892 |
1108287 | 1108287 | 2021-03-10 | Travis | Texas | 48453 | 77082 | 892 |
1078340 | 1078340 | 2021-03-01 | Montgomery | Ohio | 39113 | 47254 | 892 |
1057174 | 1057174 | 2021-02-23 | Cobb | Georgia | 13067 | 68761 | 892 |
1051007 | 1051007 | 2021-02-21 | Lake | Indiana | 18089 | 48102 | 892 |
956506 | 956506 | 2021-01-23 | Orange | Florida | 12095 | 97841 | 892 |
953261 | 953261 | 2021-01-22 | Orange | Florida | 12095 | 96847 | 892 |
915741 | 915741 | 2021-01-10 | Camden | New Jersey | 34007 | 34601 | 892 |
912496 | 912496 | 2021-01-09 | Camden | New Jersey | 34007 | 34294 | 892 |
818387 | 818387 | 2020-12-11 | Morris | New Jersey | 34027 | 16321 | 892 |
778881 | 778881 | 2020-11-29 | Plymouth | Massachusetts | 25023 | 14588 | 892 |
775636 | 775636 | 2020-11-28 | Plymouth | Massachusetts | 25023 | 14495 | 892 |
772391 | 772391 | 2020-11-27 | Plymouth | Massachusetts | 25023 | 14369 | 892 |
769141 | 769141 | 2020-11-26 | Hampden | Massachusetts | 25013 | 15169 | 892 |
765895 | 765895 | 2020-11-25 | Hampden | Massachusetts | 25013 | 15169 | 892 |
761767 | 761767 | 2020-11-24 | Hillsborough | Florida | 12057 | 56166 | 892 |
763219 | 763219 | 2020-11-24 | Monmouth | New Jersey | 34025 | 19207 | 892 |
752429 | 752429 | 2020-11-21 | Marion | Indiana | 18097 | 40035 | 892 |
722067 | 722067 | 2020-11-11 | Tarrant | Texas | 48439 | 76838 | 892 |
713959 | 713959 | 2020-11-09 | Montgomery | Maryland | 24031 | 27587 | 892 |
685149 | 685149 | 2020-10-31 | St. Louis | Missouri | 29189 | 31585 | 892 |
653420 | 653420 | 2020-10-21 | Montgomery | Pennsylvania | 42091 | 13270 | 892 |
650175 | 650175 | 2020-10-20 | Montgomery | Pennsylvania | 42091 | 13228 | 892 |
513123 | 513123 | 2020-09-08 | Hennepin | Minnesota | 27053 | 24385 | 892 |
443309 | 443309 | 2020-08-17 | Bexar | Texas | 48029 | 44134 | 892 |
440083 | 440083 | 2020-08-16 | Bexar | Texas | 48029 | 44064 | 892 |
405609 | 405609 | 2020-08-06 | Palm Beach | Florida | 12099 | 35735 | 892 |
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);