ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
59 rows where deaths = 1048 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 20
- North Carolina 10
- New Jersey 8
- Pennsylvania 7
- Massachusetts 5
- Georgia 4
- Michigan 4
- Texas 4
- Colorado 2
- Illinois 2
- New York 2
- South Carolina 2
- Arkansas 1
- California 1
- Florida 1
- Indiana 1
- Louisiana 1
- Maryland 1
- Tennessee 1
- Virginia 1
- Washington 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2426556 | 2426556 | 2022-04-20 | Onondaga | New York | 36067 | 116954 | 1048 |
2423300 | 2423300 | 2022-04-19 | Onondaga | New York | 36067 | 116674 | 1048 |
2400627 | 2400627 | 2022-04-12 | Wake | North Carolina | 37183 | 290240 | 1048 |
2397372 | 2397372 | 2022-04-11 | Wake | North Carolina | 37183 | 290240 | 1048 |
2394117 | 2394117 | 2022-04-10 | Wake | North Carolina | 37183 | 290240 | 1048 |
2390861 | 2390861 | 2022-04-09 | Wake | North Carolina | 37183 | 290240 | 1048 |
2387605 | 2387605 | 2022-04-08 | Wake | North Carolina | 37183 | 290240 | 1048 |
2384350 | 2384350 | 2022-04-07 | Wake | North Carolina | 37183 | 290240 | 1048 |
2381095 | 2381095 | 2022-04-06 | Wake | North Carolina | 37183 | 290240 | 1048 |
2377840 | 2377840 | 2022-04-05 | Wake | North Carolina | 37183 | 290545 | 1048 |
2374587 | 2374587 | 2022-04-04 | Wake | North Carolina | 37183 | 290535 | 1048 |
2218427 | 2218427 | 2022-02-15 | Guilford | North Carolina | 37081 | 112294 | 1048 |
2187374 | 2187374 | 2022-02-06 | Pulaski | Arkansas | 5119 | 98914 | 1048 |
2178578 | 2178578 | 2022-02-03 | Caddo | Louisiana | 22017 | 65374 | 1048 |
2034610 | 2034610 | 2021-12-21 | Arapahoe | Colorado | 8005 | 96084 | 1048 |
2008618 | 2008618 | 2021-12-13 | Denver | Colorado | 8031 | 105104 | 1048 |
2006909 | 2006909 | 2021-12-12 | Mercer | New Jersey | 34021 | 43493 | 1048 |
2003658 | 2003658 | 2021-12-11 | Mercer | New Jersey | 34021 | 43348 | 1048 |
2000408 | 2000408 | 2021-12-10 | Mercer | New Jersey | 34021 | 43178 | 1048 |
1972796 | 1972796 | 2021-12-02 | Contra Costa | California | 6013 | 104045 | 1048 |
1920436 | 1920436 | 2021-11-15 | Spokane | Washington | 53063 | 75811 | 1048 |
1848651 | 1848651 | 2021-10-24 | Montgomery | Texas | 48339 | 87429 | 1048 |
1808136 | 1808136 | 2021-10-12 | Genesee | Michigan | 26049 | 49156 | 1048 |
1804885 | 1804885 | 2021-10-11 | Genesee | Michigan | 26049 | 49156 | 1048 |
1770334 | 1770334 | 2021-09-30 | Spartanburg | South Carolina | 45083 | 58946 | 1048 |
1721687 | 1721687 | 2021-09-15 | Davidson | Tennessee | 47037 | 122946 | 1048 |
1675931 | 1675931 | 2021-09-01 | Berks | Pennsylvania | 42011 | 51081 | 1048 |
1672684 | 1672684 | 2021-08-31 | Berks | Pennsylvania | 42011 | 50958 | 1048 |
1669436 | 1669436 | 2021-08-30 | Berks | Pennsylvania | 42011 | 50809 | 1048 |
1666189 | 1666189 | 2021-08-29 | Berks | Pennsylvania | 42011 | 50757 | 1048 |
1662941 | 1662941 | 2021-08-28 | Berks | Pennsylvania | 42011 | 50654 | 1048 |
1659693 | 1659693 | 2021-08-27 | Berks | Pennsylvania | 42011 | 50554 | 1048 |
1601392 | 1601392 | 2021-08-09 | Greenville | South Carolina | 45045 | 79229 | 1048 |
1559572 | 1559572 | 2021-07-27 | Travis | Texas | 48453 | 87571 | 1048 |
1381862 | 1381862 | 2021-06-03 | DeKalb | Georgia | 13089 | 67204 | 1048 |
1287706 | 1287706 | 2021-05-05 | Cobb | Georgia | 13067 | 78493 | 1048 |
1288488 | 1288488 | 2021-05-05 | Baltimore city | Maryland | 24510 | 51511 | 1048 |
1284460 | 1284460 | 2021-05-04 | Cobb | Georgia | 13067 | 78390 | 1048 |
1284687 | 1284687 | 2021-05-04 | Lake | Illinois | 17097 | 66368 | 1048 |
1262008 | 1262008 | 2021-04-27 | Will | Illinois | 17197 | 73250 | 1048 |
1196072 | 1196072 | 2021-04-06 | Fairfax | Virginia | 51059 | 72390 | 1048 |
1157841 | 1157841 | 2021-03-26 | Gwinnett | Georgia | 13135 | 96319 | 1048 |
997354 | 997354 | 2021-02-04 | Bucks | Pennsylvania | 42017 | 40869 | 1048 |
974165 | 974165 | 2021-01-28 | Morris | New Jersey | 34027 | 31316 | 1048 |
908696 | 908696 | 2021-01-08 | Plymouth | Massachusetts | 25023 | 27624 | 1048 |
830319 | 830319 | 2020-12-15 | Marion | Indiana | 18097 | 59718 | 1048 |
770598 | 770598 | 2020-11-26 | El Paso | Texas | 48141 | 83993 | 1048 |
626441 | 626441 | 2020-10-13 | Macomb | Michigan | 26099 | 16407 | 1048 |
581568 | 581568 | 2020-09-29 | Ocean | New Jersey | 34029 | 13546 | 1048 |
578327 | 578327 | 2020-09-28 | Ocean | New Jersey | 34029 | 13467 | 1048 |
575086 | 575086 | 2020-09-27 | Ocean | New Jersey | 34029 | 13223 | 1048 |
571843 | 571843 | 2020-09-26 | Ocean | New Jersey | 34029 | 12968 | 1048 |
558319 | 558319 | 2020-09-22 | Norfolk | Massachusetts | 25021 | 10080 | 1048 |
555082 | 555082 | 2020-09-21 | Norfolk | Massachusetts | 25021 | 10065 | 1048 |
453969 | 453969 | 2020-08-21 | Palm Beach | Florida | 12099 | 40155 | 1048 |
453084 | 453084 | 2020-08-20 | Hidalgo | Texas | 48215 | 23453 | 1048 |
374305 | 374305 | 2020-07-27 | Suffolk | Massachusetts | 25025 | 20914 | 1048 |
371093 | 371093 | 2020-07-26 | Suffolk | Massachusetts | 25025 | 20896 | 1048 |
210420 | 210420 | 2020-06-05 | Oakland | Michigan | 26125 | 10859 | 1048 |
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);