ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
67 rows where deaths = 919 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 21
- New Jersey 10
- Florida 8
- Colorado 6
- Louisiana 6
- Arizona 5
- Ohio 4
- Pennsylvania 4
- Utah 4
- Tennessee 3
- Arkansas 2
- Maryland 2
- New York 2
- North Carolina 2
- South Carolina 2
- Georgia 1
- Hawaii 1
- Indiana 1
- Massachusetts 1
- Nevada 1
- Texas 1
- Virginia 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2401617 | 2401617 | 2022-04-12 | Henrico | Virginia | 51087 | 64812 | 919 |
2288434 | 2288434 | 2022-03-09 | Clayton | Georgia | 13063 | 63279 | 919 |
2248162 | 2248162 | 2022-02-24 | Anderson | South Carolina | 45007 | 57407 | 919 |
2245327 | 2245327 | 2022-02-23 | Smith | Texas | 48423 | 45112 | 919 |
2238097 | 2238097 | 2022-02-21 | Lorain | Ohio | 39093 | 65984 | 919 |
2234846 | 2234846 | 2022-02-20 | Lorain | Ohio | 39093 | 65967 | 919 |
2231595 | 2231595 | 2022-02-19 | Lorain | Ohio | 39093 | 65952 | 919 |
2228344 | 2228344 | 2022-02-18 | Lorain | Ohio | 39093 | 65940 | 919 |
2204025 | 2204025 | 2022-02-11 | Honolulu | Hawaii | 15003 | 160390 | 919 |
2127198 | 2127198 | 2022-01-18 | Somerset | New Jersey | 34035 | 62035 | 919 |
2123946 | 2123946 | 2022-01-17 | Somerset | New Jersey | 34035 | 61724 | 919 |
2120694 | 2120694 | 2022-01-16 | Somerset | New Jersey | 34035 | 61410 | 919 |
2117442 | 2117442 | 2022-01-15 | Somerset | New Jersey | 34035 | 60945 | 919 |
2114261 | 2114261 | 2022-01-14 | Onondaga | New York | 36067 | 89688 | 919 |
2108440 | 2108440 | 2022-01-12 | Hamilton | Tennessee | 47065 | 77963 | 919 |
2014052 | 2014052 | 2021-12-14 | Horry | South Carolina | 45051 | 64692 | 919 |
2008728 | 2008728 | 2021-12-13 | Osceola | Florida | 12097 | 73093 | 919 |
2005477 | 2005477 | 2021-12-12 | Osceola | Florida | 12097 | 73093 | 919 |
2002226 | 2002226 | 2021-12-11 | Osceola | Florida | 12097 | 73093 | 919 |
1998976 | 1998976 | 2021-12-10 | Osceola | Florida | 12097 | 73093 | 919 |
1995725 | 1995725 | 2021-12-09 | Osceola | Florida | 12097 | 72806 | 919 |
1992474 | 1992474 | 2021-12-08 | Osceola | Florida | 12097 | 72806 | 919 |
1904456 | 1904456 | 2021-11-11 | Yuma | Arizona | 4027 | 42029 | 919 |
1898016 | 1898016 | 2021-11-09 | Pulaski | Arkansas | 5119 | 59171 | 919 |
1894766 | 1894766 | 2021-11-08 | Pulaski | Arkansas | 5119 | 59102 | 919 |
1896376 | 1896376 | 2021-11-08 | Washoe | Nevada | 32031 | 66433 | 919 |
1887176 | 1887176 | 2021-11-05 | Westmoreland | Pennsylvania | 42129 | 45983 | 919 |
1839604 | 1839604 | 2021-10-22 | Arapahoe | Colorado | 8005 | 79966 | 919 |
1836355 | 1836355 | 2021-10-21 | Arapahoe | Colorado | 8005 | 79633 | 919 |
1833106 | 1833106 | 2021-10-20 | Arapahoe | Colorado | 8005 | 79629 | 919 |
1800629 | 1800629 | 2021-10-10 | Denver | Colorado | 8031 | 87441 | 919 |
1797380 | 1797380 | 2021-10-09 | Denver | Colorado | 8031 | 87441 | 919 |
1794131 | 1794131 | 2021-10-08 | Denver | Colorado | 8031 | 87441 | 919 |
1778755 | 1778755 | 2021-10-03 | Caddo | Louisiana | 22017 | 38375 | 919 |
1775505 | 1775505 | 2021-10-02 | Caddo | Louisiana | 22017 | 38375 | 919 |
1772255 | 1772255 | 2021-10-01 | Caddo | Louisiana | 22017 | 38375 | 919 |
1769006 | 1769006 | 2021-09-30 | Caddo | Louisiana | 22017 | 38306 | 919 |
1756676 | 1756676 | 2021-09-26 | Burlington | New Jersey | 34005 | 51617 | 919 |
1753428 | 1753428 | 2021-09-25 | Burlington | New Jersey | 34005 | 51550 | 919 |
1606588 | 1606588 | 2021-08-11 | East Baton Rouge | Louisiana | 22033 | 52100 | 919 |
1554621 | 1554621 | 2021-07-26 | Jefferson | Louisiana | 22051 | 51000 | 919 |
1537346 | 1537346 | 2021-07-21 | Pinal | Arizona | 4021 | 55215 | 919 |
1530851 | 1530851 | 2021-07-19 | Pinal | Arizona | 4021 | 54937 | 919 |
1527604 | 1527604 | 2021-07-18 | Pinal | Arizona | 4021 | 54933 | 919 |
1524357 | 1524357 | 2021-07-17 | Pinal | Arizona | 4021 | 54930 | 919 |
1488183 | 1488183 | 2021-07-05 | Salt Lake | Utah | 49035 | 154070 | 919 |
1484936 | 1484936 | 2021-07-04 | Salt Lake | Utah | 49035 | 154070 | 919 |
1481690 | 1481690 | 2021-07-03 | Salt Lake | Utah | 49035 | 154070 | 919 |
1478443 | 1478443 | 2021-07-02 | Salt Lake | Utah | 49035 | 154070 | 919 |
1240381 | 1240381 | 2021-04-20 | Mercer | New Jersey | 34021 | 32885 | 919 |
1218392 | 1218392 | 2021-04-13 | Davidson | Tennessee | 47037 | 96014 | 919 |
1215144 | 1215144 | 2021-04-12 | Davidson | Tennessee | 47037 | 95651 | 919 |
1195072 | 1195072 | 2021-04-06 | Mecklenburg | North Carolina | 37119 | 104118 | 919 |
1191824 | 1191824 | 2021-04-05 | Mecklenburg | North Carolina | 37119 | 103967 | 919 |
1173986 | 1173986 | 2021-03-31 | Marion | Florida | 12083 | 29044 | 919 |
1140171 | 1140171 | 2021-03-20 | Berks | Pennsylvania | 42011 | 38084 | 919 |
1132617 | 1132617 | 2021-03-18 | Baltimore city | Maryland | 24510 | 42251 | 919 |
1083464 | 1083464 | 2021-03-03 | Lake | Indiana | 18089 | 48587 | 919 |
928722 | 928722 | 2021-01-14 | Camden | New Jersey | 34007 | 35867 | 919 |
903236 | 903236 | 2021-01-06 | Bucks | Pennsylvania | 42017 | 32484 | 919 |
815196 | 815196 | 2020-12-10 | Erie | New York | 36029 | 31282 | 919 |
805405 | 805405 | 2020-12-07 | Monmouth | New Jersey | 34025 | 23168 | 919 |
802160 | 802160 | 2020-12-06 | Monmouth | New Jersey | 34025 | 22929 | 919 |
750740 | 750740 | 2020-11-20 | Montgomery | Pennsylvania | 42091 | 18861 | 919 |
746404 | 746404 | 2020-11-19 | Montgomery | Maryland | 24031 | 30339 | 919 |
408829 | 408829 | 2020-08-07 | Palm Beach | Florida | 12099 | 36112 | 919 |
266289 | 266289 | 2020-06-23 | Norfolk | Massachusetts | 25021 | 9042 | 919 |
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);