ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
63 rows where deaths = 1444 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 15
- New Jersey 15
- California 10
- Arizona 8
- Pennsylvania 8
- Massachusetts 6
- Wisconsin 4
- Virginia 3
- New York 2
- Florida 1
- Georgia 1
- Illinois 1
- Nevada 1
- Texas 1
- Utah 1
- Washington 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2467103 | 2467103 | 2022-05-03 | Mohave | Arizona | 4015 | 57442 | 1444 |
2463848 | 2463848 | 2022-05-02 | Mohave | Arizona | 4015 | 57442 | 1444 |
2460592 | 2460592 | 2022-05-01 | Mohave | Arizona | 4015 | 57442 | 1444 |
2457336 | 2457336 | 2022-04-30 | Mohave | Arizona | 4015 | 57442 | 1444 |
2454080 | 2454080 | 2022-04-29 | Mohave | Arizona | 4015 | 57442 | 1444 |
2450824 | 2450824 | 2022-04-28 | Mohave | Arizona | 4015 | 57442 | 1444 |
2447568 | 2447568 | 2022-04-27 | Mohave | Arizona | 4015 | 57442 | 1444 |
2430899 | 2430899 | 2022-04-21 | Fairfax | Virginia | 51059 | 179636 | 1444 |
2427643 | 2427643 | 2022-04-20 | Fairfax | Virginia | 51059 | 179307 | 1444 |
2424387 | 2424387 | 2022-04-19 | Fairfax | Virginia | 51059 | 179076 | 1444 |
2170589 | 2170589 | 2022-01-31 | Salt Lake | Utah | 49035 | 326024 | 1444 |
1873646 | 1873646 | 2021-11-01 | Camden | New Jersey | 34007 | 68441 | 1444 |
1870397 | 1870397 | 2021-10-31 | Camden | New Jersey | 34007 | 68368 | 1444 |
1867148 | 1867148 | 2021-10-30 | Camden | New Jersey | 34007 | 68273 | 1444 |
1863899 | 1863899 | 2021-10-29 | Camden | New Jersey | 34007 | 68192 | 1444 |
1860650 | 1860650 | 2021-10-28 | Camden | New Jersey | 34007 | 68112 | 1444 |
1857401 | 1857401 | 2021-10-27 | Camden | New Jersey | 34007 | 67910 | 1444 |
1745758 | 1745758 | 2021-09-23 | DuPage | Illinois | 17043 | 104074 | 1444 |
1714931 | 1714931 | 2021-09-13 | Delaware | Pennsylvania | 42045 | 57349 | 1444 |
1711685 | 1711685 | 2021-09-12 | Delaware | Pennsylvania | 42045 | 57265 | 1444 |
1708438 | 1708438 | 2021-09-11 | Delaware | Pennsylvania | 42045 | 57161 | 1444 |
1705191 | 1705191 | 2021-09-10 | Delaware | Pennsylvania | 42045 | 57012 | 1444 |
1589152 | 1589152 | 2021-08-05 | Milwaukee | Wisconsin | 55079 | 122876 | 1444 |
1585903 | 1585903 | 2021-08-04 | Milwaukee | Wisconsin | 55079 | 122454 | 1444 |
1582653 | 1582653 | 2021-08-03 | Milwaukee | Wisconsin | 55079 | 122085 | 1444 |
1579403 | 1579403 | 2021-08-02 | Milwaukee | Wisconsin | 55079 | 121713 | 1444 |
1488760 | 1488760 | 2021-07-06 | San Joaquin | California | 6077 | 74900 | 1444 |
1485513 | 1485513 | 2021-07-05 | San Joaquin | California | 6077 | 74900 | 1444 |
1482267 | 1482267 | 2021-07-04 | San Joaquin | California | 6077 | 74900 | 1444 |
1479020 | 1479020 | 2021-07-03 | San Joaquin | California | 6077 | 74900 | 1444 |
1475774 | 1475774 | 2021-07-02 | San Joaquin | California | 6077 | 74900 | 1444 |
1472528 | 1472528 | 2021-07-01 | San Joaquin | California | 6077 | 74900 | 1444 |
1469283 | 1469283 | 2021-06-30 | San Joaquin | California | 6077 | 74900 | 1444 |
1466038 | 1466038 | 2021-06-29 | San Joaquin | California | 6077 | 74900 | 1444 |
1444335 | 1444335 | 2021-06-22 | Plymouth | Massachusetts | 25023 | 49270 | 1444 |
1441090 | 1441090 | 2021-06-21 | Plymouth | Massachusetts | 25023 | 49268 | 1444 |
1437844 | 1437844 | 2021-06-20 | Plymouth | Massachusetts | 25023 | 49263 | 1444 |
1434597 | 1434597 | 2021-06-19 | Plymouth | Massachusetts | 25023 | 49261 | 1444 |
1431350 | 1431350 | 2021-06-18 | Plymouth | Massachusetts | 25023 | 49256 | 1444 |
1428105 | 1428105 | 2021-06-17 | Plymouth | Massachusetts | 25023 | 49249 | 1444 |
1404597 | 1404597 | 2021-06-10 | Fulton | Georgia | 13121 | 98967 | 1444 |
1373977 | 1373977 | 2021-05-31 | Delaware | Pennsylvania | 42045 | 52146 | 1444 |
1370732 | 1370732 | 2021-05-30 | Delaware | Pennsylvania | 42045 | 52131 | 1444 |
1367486 | 1367486 | 2021-05-29 | Delaware | Pennsylvania | 42045 | 52113 | 1444 |
1364240 | 1364240 | 2021-05-28 | Delaware | Pennsylvania | 42045 | 52085 | 1444 |
1320085 | 1320085 | 2021-05-15 | Duval | Florida | 12031 | 99277 | 1444 |
1131237 | 1131237 | 2021-03-17 | King | Washington | 53033 | 86852 | 1444 |
1120226 | 1120226 | 2021-03-14 | Monmouth | New Jersey | 34025 | 61647 | 1444 |
974220 | 974220 | 2021-01-28 | Erie | New York | 36029 | 56080 | 1444 |
792432 | 792432 | 2020-12-03 | Union | New Jersey | 34039 | 29466 | 1444 |
787597 | 787597 | 2020-12-02 | Riverside | California | 6065 | 88530 | 1444 |
725106 | 725106 | 2020-11-12 | Bexar | Texas | 48029 | 68388 | 1444 |
672379 | 672379 | 2020-10-27 | Middlesex | New Jersey | 34023 | 22141 | 1444 |
669137 | 669137 | 2020-10-26 | Middlesex | New Jersey | 34023 | 21985 | 1444 |
665893 | 665893 | 2020-10-25 | Middlesex | New Jersey | 34023 | 21870 | 1444 |
661063 | 661063 | 2020-10-24 | Orange | California | 6059 | 60184 | 1444 |
662648 | 662648 | 2020-10-24 | Middlesex | New Jersey | 34023 | 21780 | 1444 |
659404 | 659404 | 2020-10-23 | Middlesex | New Jersey | 34023 | 21617 | 1444 |
626915 | 626915 | 2020-10-13 | Clark | Nevada | 32003 | 72439 | 1444 |
344329 | 344329 | 2020-07-18 | Maricopa | Arizona | 4013 | 93870 | 1444 |
273081 | 273081 | 2020-06-25 | Hudson | New Jersey | 34017 | 18946 | 1444 |
168102 | 168102 | 2020-05-22 | Westchester | New York | 36119 | 32766 | 1444 |
137866 | 137866 | 2020-05-12 | Essex | New Jersey | 34013 | 15658 | 1444 |
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);