ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
191 rows where cases = 2682 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Indiana 14
- Georgia 12
- Colorado 8
- Iowa 8
- Kentucky 8
- South Carolina 8
- Wisconsin 8
- Kansas 7
- Louisiana 7
- Puerto Rico 7
- Virginia 7
- Alabama 6
- Arkansas 6
- Tennessee 6
- Wyoming 6
- Maine 5
- North Carolina 5
- Ohio 5
- Texas 5
- Illinois 4
- Missouri 4
- New York 4
- California 3
- Nebraska 3
- New Mexico 3
- Oklahoma 3
- Pennsylvania 3
- Arizona 2
- Florida 2
- Idaho 2
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2476695 | 2476695 | 2022-05-05 | Forest | Wisconsin | 55041 | 2682 | 52 |
2473437 | 2473437 | 2022-05-04 | Forest | Wisconsin | 55041 | 2682 | 52 |
2428832 | 2428832 | 2022-04-21 | Brown | Kansas | 20013 | 2682 | 46 |
2425576 | 2425576 | 2022-04-20 | Brown | Kansas | 20013 | 2682 | 46 |
2422320 | 2422320 | 2022-04-19 | Brown | Kansas | 20013 | 2682 | 46 |
2419064 | 2419064 | 2022-04-18 | Brown | Kansas | 20013 | 2682 | 46 |
2415808 | 2415808 | 2022-04-17 | Brown | Kansas | 20013 | 2682 | 46 |
2412552 | 2412552 | 2022-04-16 | Brown | Kansas | 20013 | 2682 | 46 |
2409296 | 2409296 | 2022-04-15 | Brown | Kansas | 20013 | 2682 | 46 |
2323926 | 2323926 | 2022-03-20 | Fulton | Arkansas | 5049 | 2682 | 88 |
2320672 | 2320672 | 2022-03-19 | Fulton | Arkansas | 5049 | 2682 | 88 |
2293085 | 2293085 | 2022-03-10 | Colfax | New Mexico | 35007 | 2682 | 65 |
2289844 | 2289844 | 2022-03-09 | Los Alamos | New Mexico | 35028 | 2682 | 13 |
2284521 | 2284521 | 2022-03-07 | Nelson | Virginia | 51125 | 2682 | 32 |
2269097 | 2269097 | 2022-03-03 | Teton | Idaho | 16081 | 2682 | 8 |
2265844 | 2265844 | 2022-03-02 | Teton | Idaho | 16081 | 2682 | 8 |
2243623 | 2243623 | 2022-02-23 | Catahoula | Louisiana | 22025 | 2682 | 55 |
2233933 | 2233933 | 2022-02-20 | Piscataquis | Maine | 23021 | 2682 | 27 |
2220739 | 2220739 | 2022-02-16 | Bath | Kentucky | 21011 | 2682 | 37 |
2197257 | 2197257 | 2022-02-09 | Park | Colorado | 8093 | 2682 | 19 |
2194003 | 2194003 | 2022-02-08 | Park | Colorado | 8093 | 2682 | 19 |
2183563 | 2183563 | 2022-02-04 | Ward | Texas | 48475 | 2682 | 39 |
2177567 | 2177567 | 2022-02-03 | Chicot | Arkansas | 5017 | 2682 | 50 |
2179803 | 2179803 | 2022-02-03 | Comerio | Puerto Rico | 72045 | 2682 | |
2176889 | 2176889 | 2022-02-02 | Eastland | Texas | 48133 | 2682 | 97 |
2167754 | 2167754 | 2022-01-31 | Wilcox | Alabama | 1131 | 2682 | 38 |
2153424 | 2153424 | 2022-01-26 | Barnes | North Dakota | 38003 | 2682 | 42 |
2122845 | 2122845 | 2022-01-17 | Blackford | Indiana | 18009 | 2682 | 59 |
2118018 | 2118018 | 2022-01-15 | Naguabo | Puerto Rico | 72103 | 2682 | |
2114502 | 2114502 | 2022-01-14 | Morgan | Ohio | 39115 | 2682 | 48 |
2077648 | 2077648 | 2022-01-03 | Estill | Kentucky | 21065 | 2682 | 37 |
2051806 | 2051806 | 2021-12-26 | Lincoln | Maine | 23015 | 2682 | 11 |
2048556 | 2048556 | 2021-12-25 | Lincoln | Maine | 23015 | 2682 | 11 |
2045306 | 2045306 | 2021-12-24 | Lincoln | Maine | 23015 | 2682 | 11 |
2031097 | 2031097 | 2021-12-19 | Goshen | Wyoming | 56015 | 2682 | 50 |
2027846 | 2027846 | 2021-12-18 | Goshen | Wyoming | 56015 | 2682 | 50 |
2024595 | 2024595 | 2021-12-17 | Goshen | Wyoming | 56015 | 2682 | 50 |
2009755 | 2009755 | 2021-12-13 | Sibley | Minnesota | 27143 | 2682 | 19 |
1992799 | 1992799 | 2021-12-08 | Warren | Illinois | 17187 | 2682 | 72 |
1986273 | 1986273 | 2021-12-06 | Moultrie | Illinois | 17139 | 2682 | 43 |
1974348 | 1974348 | 2021-12-02 | Saline | Nebraska | 31151 | 2682 | 6 |
1952745 | 1952745 | 2021-11-25 | San Juan | Utah | 49037 | 2682 | 43 |
1949494 | 1949494 | 2021-11-24 | San Juan | Utah | 49037 | 2682 | 43 |
1943488 | 1943488 | 2021-11-23 | Izard | Arkansas | 5065 | 2682 | 55 |
1941164 | 1941164 | 2021-11-22 | Lewis | Kentucky | 21135 | 2682 | 60 |
1923744 | 1923744 | 2021-11-16 | Wetzel | West Virginia | 54103 | 2682 | 58 |
1869367 | 1869367 | 2021-10-31 | Perry | Indiana | 18123 | 2682 | 55 |
1866118 | 1866118 | 2021-10-30 | Perry | Indiana | 18123 | 2682 | 55 |
1862869 | 1862869 | 2021-10-29 | Perry | Indiana | 18123 | 2682 | 55 |
1858704 | 1858704 | 2021-10-27 | Barbour | West Virginia | 54001 | 2682 | 44 |
1849094 | 1849094 | 2021-10-24 | Lincoln | Wyoming | 56023 | 2682 | 18 |
1845844 | 1845844 | 2021-10-23 | Lincoln | Wyoming | 56023 | 2682 | 18 |
1842594 | 1842594 | 2021-10-22 | Lincoln | Wyoming | 56023 | 2682 | 18 |
1836882 | 1836882 | 2021-10-21 | Rush | Indiana | 18139 | 2682 | 32 |
1834791 | 1834791 | 2021-10-20 | Currituck | North Carolina | 37053 | 2682 | 25 |
1826817 | 1826817 | 2021-10-18 | Greene | Georgia | 13133 | 2682 | 69 |
1767804 | 1767804 | 2021-09-29 | Green Lake | Wisconsin | 55047 | 2682 | 29 |
1760200 | 1760200 | 2021-09-27 | Carroll | Ohio | 39019 | 2682 | 52 |
1746770 | 1746770 | 2021-09-23 | Hill | Montana | 30041 | 2682 | 51 |
1703043 | 1703043 | 2021-09-10 | Hempstead | Arkansas | 5057 | 2682 | 23 |
1695925 | 1695925 | 2021-09-07 | Lee | Texas | 48287 | 2682 | 45 |
1675277 | 1675277 | 2021-09-01 | Big Horn | Montana | 30003 | 2682 | 77 |
1670516 | 1670516 | 2021-08-31 | La Paz | Arizona | 4012 | 2682 | 81 |
1654370 | 1654370 | 2021-08-26 | Del Norte | California | 6015 | 2682 | 18 |
1646971 | 1646971 | 2021-08-23 | Chester | Tennessee | 47023 | 2682 | 54 |
1647655 | 1647655 | 2021-08-23 | Waushara | Wisconsin | 55137 | 2682 | 39 |
1638057 | 1638057 | 2021-08-21 | Conway | Arkansas | 5029 | 2682 | 37 |
1622483 | 1622483 | 2021-08-16 | Washington | Indiana | 18175 | 2682 | 40 |
1598122 | 1598122 | 2021-08-08 | Abbeville | South Carolina | 45001 | 2682 | 41 |
1594873 | 1594873 | 2021-08-07 | Abbeville | South Carolina | 45001 | 2682 | 41 |
1591624 | 1591624 | 2021-08-06 | Abbeville | South Carolina | 45001 | 2682 | 41 |
1573255 | 1573255 | 2021-08-01 | Pitkin | Colorado | 8097 | 2682 | 4 |
1570007 | 1570007 | 2021-07-31 | Pitkin | Colorado | 8097 | 2682 | 4 |
1566759 | 1566759 | 2021-07-30 | Pitkin | Colorado | 8097 | 2682 | 4 |
1565539 | 1565539 | 2021-07-29 | Susquehanna | Pennsylvania | 42115 | 2682 | 62 |
1565639 | 1565639 | 2021-07-29 | Barnwell | South Carolina | 45011 | 2682 | 58 |
1554637 | 1554637 | 2021-07-26 | Richland | Louisiana | 22083 | 2682 | 58 |
1538323 | 1538323 | 2021-07-21 | Mercer | Kentucky | 21167 | 2682 | 54 |
1538920 | 1538920 | 2021-07-21 | Cass | Nebraska | 31025 | 2682 | 17 |
1535673 | 1535673 | 2021-07-20 | Cass | Nebraska | 31025 | 2682 | 17 |
1497585 | 1497585 | 2021-07-08 | Grainger | Tennessee | 47057 | 2682 | 50 |
1494338 | 1494338 | 2021-07-07 | Grainger | Tennessee | 47057 | 2682 | 50 |
1491091 | 1491091 | 2021-07-06 | Grainger | Tennessee | 47057 | 2682 | 50 |
1463282 | 1463282 | 2021-06-28 | Clay | Indiana | 18021 | 2682 | 48 |
1458432 | 1458432 | 2021-06-26 | Dorado | Puerto Rico | 72051 | 2682 | |
1455187 | 1455187 | 2021-06-25 | Dorado | Puerto Rico | 72051 | 2682 | |
1451942 | 1451942 | 2021-06-24 | Dorado | Puerto Rico | 72051 | 2682 | |
1424441 | 1424441 | 2021-06-16 | Crawford | Iowa | 19047 | 2682 | 40 |
1420378 | 1420378 | 2021-06-15 | Bibb | Alabama | 1007 | 2682 | 64 |
1417590 | 1417590 | 2021-06-14 | Haralson | Georgia | 13143 | 2682 | 89 |
1415042 | 1415042 | 2021-06-13 | Pointe Coupee | Louisiana | 22077 | 2682 | 75 |
1411797 | 1411797 | 2021-06-12 | Pointe Coupee | Louisiana | 22077 | 2682 | 75 |
1408196 | 1408196 | 2021-06-11 | Boone | Iowa | 19015 | 2682 | 34 |
1408552 | 1408552 | 2021-06-11 | Pointe Coupee | Louisiana | 22077 | 2682 | 75 |
1404950 | 1404950 | 2021-06-10 | Boone | Iowa | 19015 | 2682 | 34 |
1401705 | 1401705 | 2021-06-09 | Boone | Iowa | 19015 | 2682 | 34 |
1398460 | 1398460 | 2021-06-08 | Boone | Iowa | 19015 | 2682 | 34 |
1395213 | 1395213 | 2021-06-07 | Boone | Iowa | 19015 | 2682 | 34 |
1391968 | 1391968 | 2021-06-06 | Boone | Iowa | 19015 | 2682 | 34 |
1383526 | 1383526 | 2021-06-03 | Holmes | Ohio | 39075 | 2682 | 101 |
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);