ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
140 rows where cases = 3445 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Indiana 10
- Iowa 9
- Oklahoma 9
- Alabama 8
- Georgia 8
- Virginia 8
- North Carolina 6
- Texas 6
- Illinois 5
- Maryland 5
- Mississippi 5
- Puerto Rico 5
- Arkansas 4
- Florida 4
- Kentucky 4
- Minnesota 4
- Missouri 4
- West Virginia 4
- Nebraska 3
- South Carolina 3
- Tennessee 3
- Colorado 2
- Idaho 2
- Kansas 2
- Louisiana 2
- Michigan 2
- New York 2
- Wisconsin 2
- Alaska 1
- Arizona 1
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2466754 | 2466754 | 2022-05-02 | Martinsville city | Virginia | 51690 | 3445 | 123 |
2339967 | 2339967 | 2022-03-24 | Buffalo | Wisconsin | 55011 | 3445 | 12 |
2316429 | 2316429 | 2022-03-17 | San German | Puerto Rico | 72125 | 3445 | |
2293258 | 2293258 | 2022-03-10 | Swain | North Carolina | 37173 | 3445 | 37 |
2285580 | 2285580 | 2022-03-08 | Clayton | Iowa | 19043 | 3445 | 72 |
2282328 | 2282328 | 2022-03-07 | Clayton | Iowa | 19043 | 3445 | 72 |
2279075 | 2279075 | 2022-03-06 | Clayton | Iowa | 19043 | 3445 | 72 |
2275822 | 2275822 | 2022-03-05 | Clayton | Iowa | 19043 | 3445 | 72 |
2272569 | 2272569 | 2022-03-04 | Clayton | Iowa | 19043 | 3445 | 72 |
2269317 | 2269317 | 2022-03-03 | Clayton | Iowa | 19043 | 3445 | 72 |
2266064 | 2266064 | 2022-03-02 | Clayton | Iowa | 19043 | 3445 | 72 |
2257832 | 2257832 | 2022-02-27 | Anasco | Puerto Rico | 72011 | 3445 | |
2240598 | 2240598 | 2022-02-22 | Kanabec | Minnesota | 27065 | 3445 | 54 |
2234440 | 2234440 | 2022-02-20 | Gage | Nebraska | 31067 | 3445 | 37 |
2231189 | 2231189 | 2022-02-19 | Gage | Nebraska | 31067 | 3445 | 37 |
2231823 | 2231823 | 2022-02-19 | Aibonito | Puerto Rico | 72009 | 3445 | |
2227938 | 2227938 | 2022-02-18 | Gage | Nebraska | 31067 | 3445 | 37 |
2220398 | 2220398 | 2022-02-16 | Menard | Illinois | 17129 | 3445 | 23 |
2201236 | 2201236 | 2022-02-10 | Butler | Kentucky | 21031 | 3445 | 49 |
2193393 | 2193393 | 2022-02-07 | Appomattox | Virginia | 51011 | 3445 | 47 |
2177300 | 2177300 | 2022-02-02 | Braxton | West Virginia | 54007 | 3445 | 35 |
2155365 | 2155365 | 2022-01-27 | Wabash | Illinois | 17185 | 3445 | 23 |
2154188 | 2154188 | 2022-01-26 | Leon | Texas | 48289 | 3445 | 77 |
2136960 | 2136960 | 2022-01-21 | Unknown | New Jersey | 3445 | 0 | |
2051386 | 2051386 | 2021-12-26 | Rush | Indiana | 18139 | 3445 | 36 |
2048136 | 2048136 | 2021-12-25 | Rush | Indiana | 18139 | 3445 | 36 |
2044886 | 2044886 | 2021-12-24 | Rush | Indiana | 18139 | 3445 | 36 |
2040908 | 2040908 | 2021-12-23 | Marengo | Alabama | 1091 | 3445 | 93 |
2041637 | 2041637 | 2021-12-23 | Rush | Indiana | 18139 | 3445 | 36 |
2037733 | 2037733 | 2021-12-22 | Clark | Arkansas | 5019 | 3445 | 65 |
2038387 | 2038387 | 2021-12-22 | Rush | Indiana | 18139 | 3445 | 36 |
2023719 | 2023719 | 2021-12-17 | Dorado | Puerto Rico | 72051 | 3445 | |
2015962 | 2015962 | 2021-12-15 | Rockcastle | Kentucky | 21203 | 3445 | 43 |
1995845 | 1995845 | 2021-12-09 | Mitchell | Georgia | 13205 | 3445 | 101 |
1991957 | 1991957 | 2021-12-07 | Brooke | West Virginia | 54009 | 3445 | 79 |
1985608 | 1985608 | 2021-12-06 | Butler | Alabama | 1013 | 3445 | 101 |
1982358 | 1982358 | 2021-12-05 | Butler | Alabama | 1013 | 3445 | 101 |
1979204 | 1979204 | 2021-12-04 | La Paz | Arizona | 4012 | 3445 | 102 |
1972609 | 1972609 | 2021-12-02 | Butler | Alabama | 1013 | 3445 | 101 |
1967674 | 1967674 | 2021-11-30 | New Madrid | Missouri | 29143 | 3445 | 70 |
1964073 | 1964073 | 2021-11-29 | Somerset | Maryland | 24039 | 3445 | 54 |
1960822 | 1960822 | 2021-11-28 | Somerset | Maryland | 24039 | 3445 | 54 |
1943094 | 1943094 | 2021-11-22 | Louisa | Virginia | 51109 | 3445 | 52 |
1904011 | 1904011 | 2021-11-10 | Franklin | Vermont | 50011 | 3445 | 51 |
1895373 | 1895373 | 2021-11-08 | Spencer | Indiana | 18147 | 3445 | 46 |
1897642 | 1897642 | 2021-11-08 | Staunton city | Virginia | 51790 | 3445 | 82 |
1855894 | 1855894 | 2021-10-27 | Morgan | Colorado | 8087 | 3445 | 99 |
1854511 | 1854511 | 2021-10-26 | Beckham | Oklahoma | 40009 | 3445 | 74 |
1851262 | 1851262 | 2021-10-25 | Beckham | Oklahoma | 40009 | 3445 | 74 |
1848012 | 1848012 | 2021-10-24 | Beckham | Oklahoma | 40009 | 3445 | 74 |
1844762 | 1844762 | 2021-10-23 | Beckham | Oklahoma | 40009 | 3445 | 74 |
1841512 | 1841512 | 2021-10-22 | Beckham | Oklahoma | 40009 | 3445 | 74 |
1838263 | 1838263 | 2021-10-21 | Beckham | Oklahoma | 40009 | 3445 | 74 |
1835014 | 1835014 | 2021-10-20 | Beckham | Oklahoma | 40009 | 3445 | 74 |
1815897 | 1815897 | 2021-10-14 | Bledsoe | Tennessee | 47007 | 3445 | 17 |
1791022 | 1791022 | 2021-10-07 | Berrien | Georgia | 13019 | 3445 | 59 |
1785070 | 1785070 | 2021-10-05 | Labette | Kansas | 20099 | 3445 | 59 |
1781821 | 1781821 | 2021-10-04 | Labette | Kansas | 20099 | 3445 | 59 |
1740570 | 1740570 | 2021-09-21 | Dare | North Carolina | 37055 | 3445 | 11 |
1735961 | 1735961 | 2021-09-20 | Cassia | Idaho | 16031 | 3445 | 29 |
1735085 | 1735085 | 2021-09-19 | Caroline | Virginia | 51033 | 3445 | 43 |
1731835 | 1731835 | 2021-09-18 | Caroline | Virginia | 51033 | 3445 | 43 |
1728585 | 1728585 | 2021-09-17 | Caroline | Virginia | 51033 | 3445 | 43 |
1684909 | 1684909 | 2021-09-04 | Audrain | Missouri | 29007 | 3445 | 60 |
1677624 | 1677624 | 2021-09-02 | Clay | Indiana | 18021 | 3445 | 51 |
1672962 | 1672962 | 2021-08-31 | DeKalb | Tennessee | 47041 | 3445 | 59 |
1663811 | 1663811 | 2021-08-28 | Randolph | West Virginia | 54083 | 3445 | 19 |
1657621 | 1657621 | 2021-08-27 | Glenn | California | 6021 | 3445 | 28 |
1660563 | 1660563 | 2021-08-27 | Randolph | West Virginia | 54083 | 3445 | 19 |
1605597 | 1605597 | 2021-08-11 | Johnson | Arkansas | 5071 | 3445 | 40 |
1559590 | 1559590 | 2021-07-27 | Willacy | Texas | 48489 | 3445 | 93 |
1555082 | 1555082 | 2021-07-26 | Warren | Missouri | 29219 | 3445 | 39 |
1524802 | 1524802 | 2021-07-17 | Hawaii | Hawaii | 15001 | 3445 | 56 |
1512743 | 1512743 | 2021-07-13 | Tate | Mississippi | 28137 | 3445 | 88 |
1509496 | 1509496 | 2021-07-12 | Tate | Mississippi | 28137 | 3445 | 88 |
1469171 | 1469171 | 2021-06-30 | Baxter | Arkansas | 5005 | 3445 | 104 |
1467785 | 1467785 | 2021-06-29 | Pasquotank | North Carolina | 37139 | 3445 | 84 |
1464540 | 1464540 | 2021-06-28 | Pasquotank | North Carolina | 37139 | 3445 | 84 |
1440380 | 1440380 | 2021-06-21 | Toombs | Georgia | 13279 | 3445 | 117 |
1437133 | 1437133 | 2021-06-20 | Toombs | Georgia | 13279 | 3445 | 117 |
1433886 | 1433886 | 2021-06-19 | Toombs | Georgia | 13279 | 3445 | 117 |
1430640 | 1430640 | 2021-06-18 | Toombs | Georgia | 13279 | 3445 | 117 |
1398185 | 1398185 | 2021-06-08 | Toombs | Georgia | 13279 | 3445 | 116 |
1400060 | 1400060 | 2021-06-08 | Vega Baja | Puerto Rico | 72145 | 3445 | |
1370329 | 1370329 | 2021-05-30 | Otsego | New York | 36077 | 3445 | 47 |
1352403 | 1352403 | 2021-05-25 | Yell | Arkansas | 5149 | 3445 | 65 |
1353566 | 1353566 | 2021-05-25 | Freeborn | Minnesota | 27047 | 3445 | 30 |
1351399 | 1351399 | 2021-05-24 | Clarendon | South Carolina | 45027 | 3445 | 114 |
1348153 | 1348153 | 2021-05-23 | Clarendon | South Carolina | 45027 | 3445 | 114 |
1344905 | 1344905 | 2021-05-22 | Clarendon | South Carolina | 45027 | 3445 | 114 |
1330498 | 1330498 | 2021-05-18 | Boyle | Kentucky | 21021 | 3445 | 70 |
1327251 | 1327251 | 2021-05-17 | Boyle | Kentucky | 21021 | 3445 | 70 |
1287571 | 1287571 | 2021-05-05 | Montrose | Colorado | 8085 | 3445 | 58 |
1254592 | 1254592 | 2021-04-24 | Prince George | Virginia | 51149 | 3445 | 27 |
1249024 | 1249024 | 2021-04-23 | Adams | Indiana | 18001 | 3445 | 54 |
1245777 | 1245777 | 2021-04-22 | Adams | Indiana | 18001 | 3445 | 54 |
1242150 | 1242150 | 2021-04-21 | Baker | Florida | 12003 | 3445 | 60 |
1234403 | 1234403 | 2021-04-18 | Snyder | Pennsylvania | 42109 | 3445 | 82 |
1176404 | 1176404 | 2021-03-31 | Matagorda | Texas | 48321 | 3445 | 97 |
1164422 | 1164422 | 2021-03-28 | Wayne | Georgia | 13305 | 3445 | 82 |
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);