ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
185 rows where cases = 2257 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Virginia 18
- Minnesota 11
- Kansas 10
- Missouri 10
- North Carolina 10
- Texas 10
- Georgia 9
- Mississippi 9
- Alabama 8
- Kentucky 8
- Michigan 8
- South Dakota 8
- Indiana 7
- Iowa 7
- Arkansas 6
- Tennessee 5
- Colorado 4
- Ohio 4
- West Virginia 4
- Wisconsin 4
- Florida 3
- Illinois 3
- Puerto Rico 3
- Maine 2
- Montana 2
- New York 2
- South Carolina 2
- Arizona 1
- Idaho 1
- Louisiana 1
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2472628 | 2472628 | 2022-05-04 | Hormigueros | Puerto Rico | 72067 | 2257 | |
2404850 | 2404850 | 2022-04-13 | Essex | Virginia | 51057 | 2257 | 32 |
2401595 | 2401595 | 2022-04-12 | Essex | Virginia | 51057 | 2257 | 32 |
2395494 | 2395494 | 2022-04-11 | Cleveland | Arkansas | 5025 | 2257 | 36 |
2398340 | 2398340 | 2022-04-11 | Essex | Virginia | 51057 | 2257 | 32 |
2392238 | 2392238 | 2022-04-10 | Cleveland | Arkansas | 5025 | 2257 | 36 |
2395085 | 2395085 | 2022-04-10 | Essex | Virginia | 51057 | 2257 | 32 |
2388982 | 2388982 | 2022-04-09 | Cleveland | Arkansas | 5025 | 2257 | 36 |
2391829 | 2391829 | 2022-04-09 | Essex | Virginia | 51057 | 2257 | 32 |
2388573 | 2388573 | 2022-04-08 | Essex | Virginia | 51057 | 2257 | 32 |
2385318 | 2385318 | 2022-04-07 | Essex | Virginia | 51057 | 2257 | 32 |
2291741 | 2291741 | 2022-03-10 | Lanier | Georgia | 13173 | 2257 | 22 |
2279187 | 2279187 | 2022-03-06 | Grant | Kansas | 20067 | 2257 | 34 |
2280201 | 2280201 | 2022-03-06 | Graham | North Carolina | 37075 | 2257 | 30 |
2275934 | 2275934 | 2022-03-05 | Grant | Kansas | 20067 | 2257 | 34 |
2276948 | 2276948 | 2022-03-05 | Graham | North Carolina | 37075 | 2257 | 30 |
2272681 | 2272681 | 2022-03-04 | Grant | Kansas | 20067 | 2257 | 34 |
2273695 | 2273695 | 2022-03-04 | Graham | North Carolina | 37075 | 2257 | 30 |
2269429 | 2269429 | 2022-03-03 | Grant | Kansas | 20067 | 2257 | 34 |
2266176 | 2266176 | 2022-03-02 | Grant | Kansas | 20067 | 2257 | 34 |
2264995 | 2264995 | 2022-03-01 | Lunenburg | Virginia | 51111 | 2257 | 29 |
2261405 | 2261405 | 2022-02-28 | Castro | Texas | 48069 | 2257 | 46 |
2256913 | 2256913 | 2022-02-27 | Benton | Mississippi | 28009 | 2257 | 49 |
2258154 | 2258154 | 2022-02-27 | Castro | Texas | 48069 | 2257 | 46 |
2253662 | 2253662 | 2022-02-26 | Benton | Mississippi | 28009 | 2257 | 49 |
2254903 | 2254903 | 2022-02-26 | Castro | Texas | 48069 | 2257 | 46 |
2250411 | 2250411 | 2022-02-25 | Benton | Mississippi | 28009 | 2257 | 49 |
2247160 | 2247160 | 2022-02-24 | Benton | Mississippi | 28009 | 2257 | 49 |
2237390 | 2237390 | 2022-02-21 | Swift | Minnesota | 27151 | 2257 | 33 |
2234139 | 2234139 | 2022-02-20 | Swift | Minnesota | 27151 | 2257 | 33 |
2230888 | 2230888 | 2022-02-19 | Swift | Minnesota | 27151 | 2257 | 33 |
2227637 | 2227637 | 2022-02-18 | Swift | Minnesota | 27151 | 2257 | 33 |
2196737 | 2196737 | 2022-02-08 | Poquoson city | Virginia | 51735 | 2257 | 27 |
2191994 | 2191994 | 2022-02-07 | Grundy | Missouri | 29079 | 2257 | 62 |
2178841 | 2178841 | 2022-02-03 | Rock | Minnesota | 27133 | 2257 | 32 |
2111602 | 2111602 | 2022-01-13 | Butte | South Dakota | 46019 | 2257 | 40 |
2102919 | 2102919 | 2022-01-11 | Park | Colorado | 8093 | 2257 | 15 |
2054011 | 2054011 | 2021-12-27 | Lee | Arkansas | 5077 | 2257 | 55 |
2054148 | 2054148 | 2021-12-27 | Moffat | Colorado | 8081 | 2257 | 48 |
2020720 | 2020720 | 2021-12-16 | Stewart | Tennessee | 47161 | 2257 | 39 |
2015956 | 2015956 | 2021-12-15 | Pendleton | Kentucky | 21191 | 2257 | 26 |
2017089 | 2017089 | 2021-12-15 | Baker | Oregon | 41001 | 2257 | 36 |
2006359 | 2006359 | 2021-12-12 | Benzie | Michigan | 26019 | 2257 | 45 |
2003108 | 2003108 | 2021-12-11 | Benzie | Michigan | 26019 | 2257 | 45 |
1999858 | 1999858 | 2021-12-10 | Benzie | Michigan | 26019 | 2257 | 45 |
1997945 | 1997945 | 2021-12-09 | Meigs | Tennessee | 47121 | 2257 | 33 |
1994694 | 1994694 | 2021-12-08 | Meigs | Tennessee | 47121 | 2257 | 33 |
1995109 | 1995109 | 2021-12-08 | Martinsville city | Virginia | 51690 | 2257 | 94 |
1990135 | 1990135 | 2021-12-07 | Kalkaska | Michigan | 26079 | 2257 | 42 |
1986885 | 1986885 | 2021-12-06 | Kalkaska | Michigan | 26079 | 2257 | 42 |
1966602 | 1966602 | 2021-11-30 | Oglethorpe | Georgia | 13221 | 2257 | 43 |
1949633 | 1949633 | 2021-11-24 | Rockbridge | Virginia | 51163 | 2257 | 66 |
1928750 | 1928750 | 2021-11-18 | Roosevelt | Montana | 30085 | 2257 | 60 |
1901077 | 1901077 | 2021-11-09 | Converse | Wyoming | 56009 | 2257 | 39 |
1877140 | 1877140 | 2021-11-02 | Ramsey | North Dakota | 38071 | 2257 | 37 |
1869950 | 1869950 | 2021-10-31 | Faribault | Minnesota | 27043 | 2257 | 30 |
1866701 | 1866701 | 2021-10-30 | Faribault | Minnesota | 27043 | 2257 | 30 |
1863452 | 1863452 | 2021-10-29 | Faribault | Minnesota | 27043 | 2257 | 30 |
1852393 | 1852393 | 2021-10-26 | Lamar | Alabama | 1075 | 2257 | 47 |
1852937 | 1852937 | 2021-10-26 | Gooding | Idaho | 16047 | 2257 | 39 |
1855516 | 1855516 | 2021-10-26 | Burnett | Wisconsin | 55013 | 2257 | 32 |
1850755 | 1850755 | 2021-10-25 | Park | Montana | 30067 | 2257 | 27 |
1844134 | 1844134 | 2021-10-23 | Dallas | Missouri | 29059 | 2257 | 42 |
1814869 | 1814869 | 2021-10-14 | Bates | Missouri | 29013 | 2257 | 42 |
1810531 | 1810531 | 2021-10-13 | Charlton | Georgia | 13049 | 2257 | 53 |
1811941 | 1811941 | 2021-10-13 | Grant | New Mexico | 35017 | 2257 | 49 |
1809736 | 1809736 | 2021-10-12 | Wilbarger | Texas | 48487 | 2257 | 59 |
1772685 | 1772685 | 2021-10-01 | Madison | Missouri | 29123 | 2257 | 23 |
1762247 | 1762247 | 2021-09-28 | Page | Iowa | 19145 | 2257 | 24 |
1758999 | 1758999 | 2021-09-27 | Page | Iowa | 19145 | 2257 | 24 |
1755751 | 1755751 | 2021-09-26 | Page | Iowa | 19145 | 2257 | 24 |
1752503 | 1752503 | 2021-09-25 | Page | Iowa | 19145 | 2257 | 24 |
1749254 | 1749254 | 2021-09-24 | Page | Iowa | 19145 | 2257 | 24 |
1750760 | 1750760 | 2021-09-24 | Las Piedras | Puerto Rico | 72085 | 2257 | |
1745149 | 1745149 | 2021-09-23 | Cleburne | Alabama | 1029 | 2257 | 50 |
1746004 | 1746004 | 2021-09-23 | Page | Iowa | 19145 | 2257 | 24 |
1742755 | 1742755 | 2021-09-22 | Page | Iowa | 19145 | 2257 | 24 |
1722694 | 1722694 | 2021-09-16 | Teller | Colorado | 8119 | 2257 | 21 |
1715913 | 1715913 | 2021-09-14 | Crenshaw | Alabama | 1041 | 2257 | 62 |
1680125 | 1680125 | 2021-09-02 | Vernon | Wisconsin | 55123 | 2257 | 48 |
1668176 | 1668176 | 2021-08-30 | Bourbon | Kentucky | 21017 | 2257 | 21 |
1643092 | 1643092 | 2021-08-22 | Avery | North Carolina | 37011 | 2257 | 21 |
1639842 | 1639842 | 2021-08-21 | Avery | North Carolina | 37011 | 2257 | 21 |
1636592 | 1636592 | 2021-08-20 | Avery | North Carolina | 37011 | 2257 | 21 |
1632729 | 1632729 | 2021-08-19 | Menominee | Michigan | 26109 | 2257 | 43 |
1629482 | 1629482 | 2021-08-18 | Menominee | Michigan | 26109 | 2257 | 43 |
1604727 | 1604727 | 2021-08-10 | Union | South Dakota | 46127 | 2257 | 43 |
1601478 | 1601478 | 2021-08-09 | Union | South Dakota | 46127 | 2257 | 43 |
1598230 | 1598230 | 2021-08-08 | Union | South Dakota | 46127 | 2257 | 43 |
1594981 | 1594981 | 2021-08-07 | Union | South Dakota | 46127 | 2257 | 43 |
1591305 | 1591305 | 2021-08-06 | Hocking | Ohio | 39073 | 2257 | 63 |
1591732 | 1591732 | 2021-08-06 | Union | South Dakota | 46127 | 2257 | 43 |
1588483 | 1588483 | 2021-08-05 | Union | South Dakota | 46127 | 2257 | 43 |
1585233 | 1585233 | 2021-08-04 | Union | South Dakota | 46127 | 2257 | 43 |
1581015 | 1581015 | 2021-08-03 | Livingston | Missouri | 29117 | 2257 | 51 |
1553330 | 1553330 | 2021-07-25 | Brooke | West Virginia | 54009 | 2257 | 60 |
1550083 | 1550083 | 2021-07-24 | Brooke | West Virginia | 54009 | 2257 | 60 |
1546836 | 1546836 | 2021-07-23 | Brooke | West Virginia | 54009 | 2257 | 60 |
1541930 | 1541930 | 2021-07-22 | Jasper | Mississippi | 28061 | 2257 | 48 |
1523770 | 1523770 | 2021-07-16 | Lee | Texas | 48287 | 2257 | 40 |
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);