ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
89 rows where deaths = 931 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 30
- South Carolina 8
- New Jersey 6
- Pennsylvania 6
- Colorado 5
- Michigan 5
- New York 5
- Ohio 5
- Tennessee 5
- Texas 5
- Arizona 4
- North Carolina 4
- Washington 4
- Alabama 3
- Maryland 3
- Idaho 2
- Kansas 2
- Louisiana 2
- Massachusetts 2
- New Mexico 2
- Arkansas 1
- California 1
- Connecticut 1
- Delaware 1
- Florida 1
- Georgia 1
- Illinois 1
- Indiana 1
- Minnesota 1
- Utah 1
- Virginia 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2430920 | 2430920 | 2022-04-21 | Henrico | Virginia | 51087 | 65222 | 931 |
2397803 | 2397803 | 2022-04-11 | Charleston | South Carolina | 45019 | 111709 | 931 |
2394548 | 2394548 | 2022-04-10 | Charleston | South Carolina | 45019 | 111709 | 931 |
2391292 | 2391292 | 2022-04-09 | Charleston | South Carolina | 45019 | 111709 | 931 |
2388036 | 2388036 | 2022-04-08 | Charleston | South Carolina | 45019 | 111709 | 931 |
2384781 | 2384781 | 2022-04-07 | Charleston | South Carolina | 45019 | 111709 | 931 |
2381526 | 2381526 | 2022-04-06 | Charleston | South Carolina | 45019 | 111709 | 931 |
2378271 | 2378271 | 2022-04-05 | Charleston | South Carolina | 45019 | 111709 | 931 |
2323835 | 2323835 | 2022-03-20 | Madison | Alabama | 1089 | 88882 | 931 |
2320581 | 2320581 | 2022-03-19 | Madison | Alabama | 1089 | 88882 | 931 |
2317327 | 2317327 | 2022-03-18 | Madison | Alabama | 1089 | 88882 | 931 |
2314451 | 2314451 | 2022-03-17 | Clayton | Georgia | 13063 | 63364 | 931 |
2308840 | 2308840 | 2022-03-15 | Saginaw | Michigan | 26145 | 50181 | 931 |
2305589 | 2305589 | 2022-03-14 | Saginaw | Michigan | 26145 | 50181 | 931 |
2302337 | 2302337 | 2022-03-13 | Saginaw | Michigan | 26145 | 50177 | 931 |
2299085 | 2299085 | 2022-03-12 | Saginaw | Michigan | 26145 | 50177 | 931 |
2295833 | 2295833 | 2022-03-11 | Saginaw | Michigan | 26145 | 50177 | 931 |
2261032 | 2261032 | 2022-02-28 | Dauphin | Pennsylvania | 42043 | 58659 | 931 |
2257781 | 2257781 | 2022-02-27 | Dauphin | Pennsylvania | 42043 | 58652 | 931 |
2254530 | 2254530 | 2022-02-26 | Dauphin | Pennsylvania | 42043 | 58637 | 931 |
2224864 | 2224864 | 2022-02-17 | Orange | New York | 36071 | 104897 | 931 |
2221613 | 2221613 | 2022-02-16 | Orange | New York | 36071 | 104825 | 931 |
2218362 | 2218362 | 2022-02-15 | Orange | New York | 36071 | 104768 | 931 |
2192250 | 2192250 | 2022-02-07 | Atlantic | New Jersey | 34001 | 66963 | 931 |
2178006 | 2178006 | 2022-02-03 | Ada | Idaho | 16001 | 108139 | 931 |
2174753 | 2174753 | 2022-02-02 | Ada | Idaho | 16001 | 107232 | 931 |
2146118 | 2146118 | 2022-01-24 | Anne Arundel | Maryland | 24003 | 82816 | 931 |
2130522 | 2130522 | 2022-01-19 | Onondaga | New York | 36067 | 94516 | 931 |
2114695 | 2114695 | 2022-01-14 | Northampton | Pennsylvania | 42095 | 71205 | 931 |
2066053 | 2066053 | 2021-12-30 | Horry | South Carolina | 45051 | 66648 | 931 |
1985712 | 1985712 | 2021-12-06 | Yuma | Arizona | 4027 | 43083 | 931 |
1982462 | 1982462 | 2021-12-05 | Yuma | Arizona | 4027 | 43033 | 931 |
1933765 | 1933765 | 2021-11-20 | Pulaski | Arkansas | 5119 | 59743 | 931 |
1926930 | 1926930 | 2021-11-17 | Pierce | Washington | 53053 | 96814 | 931 |
1864407 | 1864407 | 2021-10-29 | Luzerne | Pennsylvania | 42079 | 40950 | 931 |
1859796 | 1859796 | 2021-10-28 | Johnson | Kansas | 20091 | 77880 | 931 |
1855852 | 1855852 | 2021-10-27 | Arapahoe | Colorado | 8005 | 81062 | 931 |
1856547 | 1856547 | 2021-10-27 | Johnson | Kansas | 20091 | 77880 | 931 |
1852603 | 1852603 | 2021-10-26 | Arapahoe | Colorado | 8005 | 81064 | 931 |
1849354 | 1849354 | 2021-10-25 | Arapahoe | Colorado | 8005 | 80807 | 931 |
1807998 | 1807998 | 2021-10-12 | Caddo | Louisiana | 22017 | 38959 | 931 |
1804747 | 1804747 | 2021-10-11 | Caddo | Louisiana | 22017 | 38870 | 931 |
1767980 | 1767980 | 2021-09-30 | Mohave | Arizona | 4015 | 31252 | 931 |
1770670 | 1770670 | 2021-09-30 | Montgomery | Texas | 48339 | 84857 | 931 |
1702321 | 1702321 | 2021-09-09 | Collin | Texas | 48085 | 115857 | 931 |
1657743 | 1657743 | 2021-08-27 | New Castle | Delaware | 10003 | 69360 | 931 |
1654441 | 1654441 | 2021-08-26 | El Paso | Colorado | 8041 | 81239 | 931 |
1651194 | 1651194 | 2021-08-25 | El Paso | Colorado | 8041 | 80981 | 931 |
1625046 | 1625046 | 2021-08-17 | Pinal | Arizona | 4021 | 60006 | 931 |
1540134 | 1540134 | 2021-07-21 | Salt Lake | Utah | 49035 | 157126 | 931 |
1464702 | 1464702 | 2021-06-28 | Stark | Ohio | 39151 | 33396 | 931 |
1461457 | 1461457 | 2021-06-27 | Stark | Ohio | 39151 | 33394 | 931 |
1458212 | 1458212 | 2021-06-26 | Stark | Ohio | 39151 | 33388 | 931 |
1454967 | 1454967 | 2021-06-25 | Stark | Ohio | 39151 | 33382 | 931 |
1285850 | 1285850 | 2021-05-04 | Bernalillo | New Mexico | 35001 | 57211 | 931 |
1282604 | 1282604 | 2021-05-03 | Bernalillo | New Mexico | 35001 | 57121 | 931 |
1283336 | 1283336 | 2021-05-03 | Davidson | Tennessee | 47037 | 98378 | 931 |
1280089 | 1280089 | 2021-05-02 | Davidson | Tennessee | 47037 | 98183 | 931 |
1276842 | 1276842 | 2021-05-01 | Davidson | Tennessee | 47037 | 98183 | 931 |
1272851 | 1272851 | 2021-04-30 | Mercer | New Jersey | 34021 | 33259 | 931 |
1273595 | 1273595 | 2021-04-30 | Davidson | Tennessee | 47037 | 98183 | 931 |
1269604 | 1269604 | 2021-04-29 | Mercer | New Jersey | 34021 | 33214 | 931 |
1270348 | 1270348 | 2021-04-29 | Davidson | Tennessee | 47037 | 98121 | 931 |
1240543 | 1240543 | 2021-04-20 | Mecklenburg | North Carolina | 37119 | 107698 | 931 |
1237296 | 1237296 | 2021-04-19 | Mecklenburg | North Carolina | 37119 | 107500 | 931 |
1234049 | 1234049 | 2021-04-18 | Mecklenburg | North Carolina | 37119 | 106736 | 931 |
1230801 | 1230801 | 2021-04-17 | Mecklenburg | North Carolina | 37119 | 106736 | 931 |
1140752 | 1140752 | 2021-03-20 | Travis | Texas | 48453 | 78108 | 931 |
1106187 | 1106187 | 2021-03-10 | Lake | Indiana | 18089 | 48913 | 931 |
1053741 | 1053741 | 2021-02-22 | Stanislaus | California | 6099 | 55347 | 931 |
1009939 | 1009939 | 2021-02-08 | Monroe | New York | 36055 | 49597 | 931 |
999029 | 999029 | 2021-02-05 | Will | Illinois | 17197 | 62143 | 931 |
903043 | 903043 | 2021-01-06 | Cuyahoga | Ohio | 39035 | 74199 | 931 |
850846 | 850846 | 2020-12-21 | Morris | New Jersey | 34027 | 18477 | 931 |
826149 | 826149 | 2020-12-13 | King | Washington | 53033 | 54036 | 931 |
822902 | 822902 | 2020-12-12 | King | Washington | 53033 | 53365 | 931 |
819656 | 819656 | 2020-12-11 | King | Washington | 53033 | 52594 | 931 |
811895 | 811895 | 2020-12-09 | Monmouth | New Jersey | 34025 | 23961 | 931 |
801591 | 801591 | 2020-12-06 | Hampden | Massachusetts | 25013 | 18325 | 931 |
782107 | 782107 | 2020-11-30 | Prince George's | Maryland | 24033 | 41508 | 931 |
770214 | 770214 | 2020-11-26 | Montgomery | Pennsylvania | 42091 | 20766 | 931 |
756142 | 756142 | 2020-11-22 | Montgomery | Maryland | 24031 | 31218 | 931 |
574636 | 574636 | 2020-09-27 | Hennepin | Minnesota | 27053 | 27177 | 931 |
436949 | 436949 | 2020-08-15 | Hidalgo | Texas | 48215 | 21806 | 931 |
433723 | 433723 | 2020-08-14 | Hidalgo | Texas | 48215 | 21746 | 931 |
415268 | 415268 | 2020-08-09 | Palm Beach | Florida | 12099 | 37018 | 931 |
219621 | 219621 | 2020-06-08 | Suffolk | Massachusetts | 25025 | 19028 | 931 |
201623 | 201623 | 2020-06-02 | Passaic | New Jersey | 34031 | 16234 | 931 |
136511 | 136511 | 2020-05-12 | Hartford | Connecticut | 9003 | 7528 | 931 |
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);