ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
58 rows where deaths = 880 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 23
- Pennsylvania 14
- Arizona 4
- New Hampshire 4
- Texas 4
- Colorado 3
- South Carolina 3
- Arkansas 2
- Indiana 2
- Maryland 2
- Massachusetts 2
- Missouri 2
- New Jersey 2
- New York 2
- North Carolina 2
- Virginia 2
- California 1
- Florida 1
- Georgia 1
- Illinois 1
- Louisiana 1
- Nevada 1
- Tennessee 1
- Washington 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2329332 | 2329332 | 2022-03-21 | Cumberland | Pennsylvania | 42041 | 50763 | 880 |
2326080 | 2326080 | 2022-03-20 | Cumberland | Pennsylvania | 42041 | 50755 | 880 |
2322827 | 2322827 | 2022-03-19 | Cumberland | Pennsylvania | 42041 | 50752 | 880 |
2319573 | 2319573 | 2022-03-18 | Cumberland | Pennsylvania | 42041 | 50742 | 880 |
2294253 | 2294253 | 2022-03-10 | Henrico | Virginia | 51087 | 63586 | 880 |
2280044 | 2280044 | 2022-03-06 | Hillsborough | New Hampshire | 33011 | 95829 | 880 |
2276791 | 2276791 | 2022-03-05 | Hillsborough | New Hampshire | 33011 | 95829 | 880 |
2273538 | 2273538 | 2022-03-04 | Hillsborough | New Hampshire | 33011 | 95829 | 880 |
2270286 | 2270286 | 2022-03-03 | Hillsborough | New Hampshire | 33011 | 95829 | 880 |
2247337 | 2247337 | 2022-02-24 | St. Charles | Missouri | 29183 | 100780 | 880 |
2222190 | 2222190 | 2022-02-16 | Richland | South Carolina | 45079 | 119056 | 880 |
2149701 | 2149701 | 2022-01-25 | Greene | Missouri | 29077 | 63552 | 880 |
2065489 | 2065489 | 2021-12-30 | Onondaga | New York | 36067 | 69885 | 880 |
2062239 | 2062239 | 2021-12-29 | Onondaga | New York | 36067 | 69041 | 880 |
1877541 | 1877541 | 2021-11-02 | Horry | South Carolina | 45051 | 62256 | 880 |
1873796 | 1873796 | 2021-11-01 | Guilford | North Carolina | 37081 | 68151 | 880 |
1874129 | 1874129 | 2021-11-01 | Chester | Pennsylvania | 42029 | 51038 | 880 |
1874292 | 1874292 | 2021-11-01 | Horry | South Carolina | 45051 | 62218 | 880 |
1874936 | 1874936 | 2021-11-01 | Pierce | Washington | 53053 | 93117 | 880 |
1870880 | 1870880 | 2021-10-31 | Chester | Pennsylvania | 42029 | 51038 | 880 |
1828141 | 1828141 | 2021-10-18 | Washoe | Nevada | 32031 | 63717 | 880 |
1812114 | 1812114 | 2021-10-13 | Wake | North Carolina | 37183 | 128204 | 880 |
1789676 | 1789676 | 2021-10-06 | Luzerne | Pennsylvania | 42079 | 38103 | 880 |
1781045 | 1781045 | 2021-10-04 | Pulaski | Arkansas | 5119 | 57606 | 880 |
1777795 | 1777795 | 2021-10-03 | Pulaski | Arkansas | 5119 | 57584 | 880 |
1731219 | 1731219 | 2021-09-18 | York | Pennsylvania | 42133 | 53746 | 880 |
1713776 | 1713776 | 2021-09-13 | Caddo | Louisiana | 22017 | 36986 | 880 |
1703144 | 1703144 | 2021-09-10 | Tulare | California | 6107 | 69723 | 880 |
1675964 | 1675964 | 2021-09-01 | Lehigh | Pennsylvania | 42077 | 42783 | 880 |
1672717 | 1672717 | 2021-08-31 | Lehigh | Pennsylvania | 42077 | 42627 | 880 |
1667812 | 1667812 | 2021-08-30 | Kane | Illinois | 17089 | 63236 | 880 |
1669469 | 1669469 | 2021-08-30 | Lehigh | Pennsylvania | 42077 | 42550 | 880 |
1666222 | 1666222 | 2021-08-29 | Lehigh | Pennsylvania | 42077 | 42499 | 880 |
1662974 | 1662974 | 2021-08-28 | Lehigh | Pennsylvania | 42077 | 42431 | 880 |
1624555 | 1624555 | 2021-08-16 | Webb | Texas | 48479 | 51564 | 880 |
1621308 | 1621308 | 2021-08-15 | Webb | Texas | 48479 | 51278 | 880 |
1618060 | 1618060 | 2021-08-14 | Webb | Texas | 48479 | 51121 | 880 |
1614812 | 1614812 | 2021-08-13 | Webb | Texas | 48479 | 50950 | 880 |
1529290 | 1529290 | 2021-07-18 | Burlington | New Jersey | 34005 | 44671 | 880 |
1488801 | 1488801 | 2021-07-06 | El Paso | Colorado | 8041 | 73725 | 880 |
1485554 | 1485554 | 2021-07-05 | El Paso | Colorado | 8041 | 73673 | 880 |
1482308 | 1482308 | 2021-07-04 | El Paso | Colorado | 8041 | 73635 | 880 |
1326347 | 1326347 | 2021-05-17 | Pinal | Arizona | 4021 | 52143 | 880 |
1323101 | 1323101 | 2021-05-16 | Pinal | Arizona | 4021 | 52143 | 880 |
1323321 | 1323321 | 2021-05-16 | Brevard | Florida | 12009 | 42237 | 880 |
1319855 | 1319855 | 2021-05-15 | Pinal | Arizona | 4021 | 52138 | 880 |
1146942 | 1146942 | 2021-03-22 | Davidson | Tennessee | 47037 | 93145 | 880 |
1109117 | 1109117 | 2021-03-11 | DeKalb | Georgia | 13089 | 58984 | 880 |
1084517 | 1084517 | 2021-03-03 | Mercer | New Jersey | 34021 | 28076 | 880 |
1062958 | 1062958 | 2021-02-24 | Fairfax | Virginia | 51059 | 65718 | 880 |
1055773 | 1055773 | 2021-02-22 | Berks | Pennsylvania | 42011 | 35105 | 880 |
1031534 | 1031534 | 2021-02-15 | Lake | Indiana | 18089 | 47754 | 880 |
853492 | 853492 | 2020-12-22 | Baltimore | Maryland | 24005 | 36363 | 880 |
752912 | 752912 | 2020-11-21 | Hampden | Massachusetts | 25013 | 14167 | 880 |
746425 | 746425 | 2020-11-19 | Plymouth | Massachusetts | 25023 | 13386 | 880 |
739443 | 739443 | 2020-11-17 | Marion | Indiana | 18097 | 37048 | 880 |
726933 | 726933 | 2020-11-13 | Prince George's | Maryland | 24033 | 35953 | 880 |
299800 | 299800 | 2020-07-04 | Maricopa | Arizona | 4013 | 59829 | 880 |
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);