ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
186 rows where cases = 3011 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Texas 15
- Florida 14
- Iowa 12
- Mississippi 11
- North Carolina 10
- Georgia 8
- Ohio 8
- Tennessee 8
- Wisconsin 8
- Oklahoma 7
- Arkansas 6
- Maryland 6
- Michigan 6
- California 5
- Indiana 5
- Minnesota 5
- Puerto Rico 5
- Virginia 5
- Washington 5
- Alabama 4
- Illinois 4
- Missouri 4
- South Carolina 4
- South Dakota 3
- West Virginia 3
- Kansas 2
- Kentucky 2
- New York 2
- Pennsylvania 2
- Colorado 1
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2501975 | 2501975 | 2022-05-13 | Sabana Grande | Puerto Rico | 72121 | 3011 | |
2382635 | 2382635 | 2022-04-07 | Moffat | Colorado | 8081 | 3011 | 51 |
2356529 | 2356529 | 2022-03-30 | Mariposa | California | 6043 | 3011 | 31 |
2305661 | 2305661 | 2022-03-14 | Pope | Minnesota | 27121 | 3011 | 17 |
2297900 | 2297900 | 2022-03-12 | Desha | Arkansas | 5041 | 3011 | 38 |
2255711 | 2255711 | 2022-02-27 | Plumas | California | 6063 | 3011 | 13 |
2252460 | 2252460 | 2022-02-26 | Plumas | California | 6063 | 3011 | 13 |
2249209 | 2249209 | 2022-02-25 | Plumas | California | 6063 | 3011 | 13 |
2240456 | 2240456 | 2022-02-22 | Kent | Maryland | 24029 | 3011 | 64 |
2200743 | 2200743 | 2022-02-10 | Telfair | Georgia | 13271 | 3011 | 76 |
2193420 | 2193420 | 2022-02-07 | Dickenson | Virginia | 51051 | 3011 | 40 |
2175945 | 2175945 | 2022-02-02 | Seward | Nebraska | 31159 | 3011 | 40 |
2168756 | 2168756 | 2022-01-31 | Leslie | Kentucky | 21131 | 3011 | 39 |
2146402 | 2146402 | 2022-01-24 | Walthall | Mississippi | 28147 | 3011 | 70 |
2110687 | 2110687 | 2022-01-13 | Livingston | Missouri | 29117 | 3011 | 83 |
2104107 | 2104107 | 2022-01-11 | Smith | Mississippi | 28129 | 3011 | 54 |
2104123 | 2104123 | 2022-01-11 | Yalobusha | Mississippi | 28161 | 3011 | 48 |
2097448 | 2097448 | 2022-01-09 | Unknown | Michigan | 3011 | 24 | |
2091975 | 2091975 | 2022-01-07 | Coamo | Puerto Rico | 72043 | 3011 | |
2066776 | 2066776 | 2021-12-30 | Crawford | Wisconsin | 55023 | 3011 | 25 |
2055773 | 2055773 | 2021-12-27 | Avery | North Carolina | 37011 | 3011 | 39 |
2052523 | 2052523 | 2021-12-26 | Avery | North Carolina | 37011 | 3011 | 39 |
2049273 | 2049273 | 2021-12-25 | Avery | North Carolina | 37011 | 3011 | 39 |
2046023 | 2046023 | 2021-12-24 | Avery | North Carolina | 37011 | 3011 | 39 |
2042773 | 2042773 | 2021-12-23 | Avery | North Carolina | 37011 | 3011 | 39 |
2039524 | 2039524 | 2021-12-22 | Avery | North Carolina | 37011 | 3011 | 39 |
2037132 | 2037132 | 2021-12-21 | Lee | Texas | 48287 | 3011 | 54 |
2033882 | 2033882 | 2021-12-20 | Lee | Texas | 48287 | 3011 | 54 |
2030632 | 2030632 | 2021-12-19 | Lee | Texas | 48287 | 3011 | 54 |
2001413 | 2001413 | 2021-12-10 | Panola | Texas | 48365 | 3011 | 109 |
1973692 | 1973692 | 2021-12-02 | Morgan | Kentucky | 21175 | 3011 | 11 |
1963180 | 1963180 | 2021-11-29 | Calhoun | Florida | 12013 | 3011 | 85 |
1964278 | 1964278 | 2021-11-29 | Clarke | Mississippi | 28023 | 3011 | 95 |
1965915 | 1965915 | 2021-11-29 | Asotin | Washington | 53003 | 3011 | 50 |
1959929 | 1959929 | 2021-11-28 | Calhoun | Florida | 12013 | 3011 | 85 |
1961027 | 1961027 | 2021-11-28 | Clarke | Mississippi | 28023 | 3011 | 95 |
1956678 | 1956678 | 2021-11-27 | Calhoun | Florida | 12013 | 3011 | 85 |
1957776 | 1957776 | 2021-11-27 | Clarke | Mississippi | 28023 | 3011 | 95 |
1953427 | 1953427 | 2021-11-26 | Calhoun | Florida | 12013 | 3011 | 85 |
1954525 | 1954525 | 2021-11-26 | Clarke | Mississippi | 28023 | 3011 | 95 |
1950176 | 1950176 | 2021-11-25 | Calhoun | Florida | 12013 | 3011 | 85 |
1951274 | 1951274 | 2021-11-25 | Clarke | Mississippi | 28023 | 3011 | 95 |
1946925 | 1946925 | 2021-11-24 | Calhoun | Florida | 12013 | 3011 | 85 |
1948023 | 1948023 | 2021-11-24 | Clarke | Mississippi | 28023 | 3011 | 95 |
1943674 | 1943674 | 2021-11-23 | Calhoun | Florida | 12013 | 3011 | 85 |
1940424 | 1940424 | 2021-11-22 | Calhoun | Florida | 12013 | 3011 | 85 |
1937174 | 1937174 | 2021-11-21 | Calhoun | Florida | 12013 | 3011 | 85 |
1933924 | 1933924 | 2021-11-20 | Calhoun | Florida | 12013 | 3011 | 85 |
1930672 | 1930672 | 2021-11-19 | Calhoun | Florida | 12013 | 3011 | 85 |
1929465 | 1929465 | 2021-11-18 | Juncos | Puerto Rico | 72077 | 3011 | |
1907724 | 1907724 | 2021-11-12 | Cross | Arkansas | 5037 | 3011 | 65 |
1909719 | 1909719 | 2021-11-12 | Paulding | Ohio | 39125 | 3011 | 47 |
1877267 | 1877267 | 2021-11-02 | Craig | Oklahoma | 40035 | 3011 | 32 |
1874018 | 1874018 | 2021-11-01 | Craig | Oklahoma | 40035 | 3011 | 32 |
1870769 | 1870769 | 2021-10-31 | Craig | Oklahoma | 40035 | 3011 | 32 |
1867520 | 1867520 | 2021-10-30 | Craig | Oklahoma | 40035 | 3011 | 32 |
1864271 | 1864271 | 2021-10-29 | Craig | Oklahoma | 40035 | 3011 | 32 |
1861022 | 1861022 | 2021-10-28 | Craig | Oklahoma | 40035 | 3011 | 32 |
1857773 | 1857773 | 2021-10-27 | Craig | Oklahoma | 40035 | 3011 | 32 |
1858724 | 1858724 | 2021-10-27 | Lewis | West Virginia | 54041 | 3011 | 52 |
1839285 | 1839285 | 2021-10-21 | Green Lake | Wisconsin | 55047 | 3011 | 30 |
1810055 | 1810055 | 2021-10-12 | Langlade | Wisconsin | 55067 | 3011 | 54 |
1788065 | 1788065 | 2021-10-06 | Union | Illinois | 17181 | 3011 | 51 |
1763976 | 1763976 | 2021-09-28 | Polk | Tennessee | 47139 | 3011 | 27 |
1750749 | 1750749 | 2021-09-24 | Gurabo | Puerto Rico | 72063 | 3011 | |
1742538 | 1742538 | 2021-09-22 | Lawrence | Illinois | 17101 | 3011 | 40 |
1736883 | 1736883 | 2021-09-20 | Winston | Mississippi | 28159 | 3011 | 91 |
1736927 | 1736927 | 2021-09-20 | Henry | Missouri | 29083 | 3011 | 46 |
1723696 | 1723696 | 2021-09-16 | Oceana | Michigan | 26127 | 3011 | 63 |
1720447 | 1720447 | 2021-09-15 | Oceana | Michigan | 26127 | 3011 | 63 |
1722324 | 1722324 | 2021-09-15 | Kewaunee | Wisconsin | 55061 | 3011 | 40 |
1717837 | 1717837 | 2021-09-14 | Greene | North Carolina | 37079 | 3011 | 50 |
1672491 | 1672491 | 2021-08-31 | Coshocton | Ohio | 39031 | 3011 | 63 |
1667087 | 1667087 | 2021-08-29 | Door | Wisconsin | 55029 | 3011 | 37 |
1660824 | 1660824 | 2021-08-28 | Logan | Arkansas | 5083 | 3011 | 30 |
1663839 | 1663839 | 2021-08-28 | Door | Wisconsin | 55029 | 3011 | 37 |
1660591 | 1660591 | 2021-08-27 | Door | Wisconsin | 55029 | 3011 | 37 |
1625401 | 1625401 | 2021-08-17 | Harris | Georgia | 13145 | 3011 | 66 |
1602009 | 1602009 | 2021-08-09 | Winchester city | Virginia | 51840 | 3011 | 49 |
1598476 | 1598476 | 2021-08-08 | Limestone | Texas | 48293 | 3011 | 82 |
1594058 | 1594058 | 2021-08-07 | Stoddard | Missouri | 29207 | 3011 | 48 |
1595227 | 1595227 | 2021-08-07 | Limestone | Texas | 48293 | 3011 | 82 |
1591327 | 1591327 | 2021-08-06 | Morrow | Ohio | 39117 | 3011 | 44 |
1585949 | 1585949 | 2021-08-04 | Park | Wyoming | 56029 | 3011 | 34 |
1576933 | 1576933 | 2021-08-02 | Fayette | Indiana | 18041 | 3011 | 66 |
1573685 | 1573685 | 2021-08-01 | Fayette | Indiana | 18041 | 3011 | 66 |
1570437 | 1570437 | 2021-07-31 | Fayette | Indiana | 18041 | 3011 | 66 |
1567189 | 1567189 | 2021-07-30 | Fayette | Indiana | 18041 | 3011 | 66 |
1566344 | 1566344 | 2021-07-29 | Mineral | West Virginia | 54057 | 3011 | 92 |
1559762 | 1559762 | 2021-07-27 | Smyth | Virginia | 51173 | 3011 | 96 |
1505202 | 1505202 | 2021-07-11 | Decatur | Georgia | 13087 | 3011 | 73 |
1501956 | 1501956 | 2021-07-10 | Decatur | Georgia | 13087 | 3011 | 73 |
1498710 | 1498710 | 2021-07-09 | Decatur | Georgia | 13087 | 3011 | 73 |
1494401 | 1494401 | 2021-07-07 | Wayne | Tennessee | 47181 | 3011 | 36 |
1489699 | 1489699 | 2021-07-06 | Sabine | Louisiana | 22085 | 3011 | 64 |
1476769 | 1476769 | 2021-07-02 | Queen Anne's | Maryland | 24035 | 3011 | 51 |
1473523 | 1473523 | 2021-07-01 | Queen Anne's | Maryland | 24035 | 3011 | 51 |
1469906 | 1469906 | 2021-06-30 | Jones | Iowa | 19105 | 3011 | 57 |
1470277 | 1470277 | 2021-06-30 | Queen Anne's | Maryland | 24035 | 3011 | 51 |
1466661 | 1466661 | 2021-06-29 | Jones | Iowa | 19105 | 3011 | 57 |
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);