ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
196 rows where cases = 2985 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Indiana 21
- Arkansas 18
- Texas 12
- Virginia 12
- Mississippi 11
- Georgia 9
- Illinois 8
- Louisiana 8
- Idaho 7
- Puerto Rico 7
- Kentucky 6
- West Virginia 6
- California 5
- Minnesota 5
- Florida 4
- Maryland 4
- Missouri 4
- North Carolina 4
- Wisconsin 4
- Alaska 3
- Kansas 3
- Nebraska 3
- New York 3
- Ohio 3
- Pennsylvania 3
- Utah 3
- Virgin Islands 3
- Michigan 2
- North Dakota 2
- Oklahoma 2
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2392697 | 2392697 | 2022-04-10 | Idaho | Idaho | 16049 | 2985 | 51 |
2389441 | 2389441 | 2022-04-09 | Idaho | Idaho | 16049 | 2985 | 51 |
2386186 | 2386186 | 2022-04-08 | Idaho | Idaho | 16049 | 2985 | 51 |
2382931 | 2382931 | 2022-04-07 | Idaho | Idaho | 16049 | 2985 | 51 |
2372704 | 2372704 | 2022-04-04 | Bradley | Arkansas | 5011 | 2985 | 49 |
2369451 | 2369451 | 2022-04-03 | Bradley | Arkansas | 5011 | 2985 | 49 |
2366198 | 2366198 | 2022-04-02 | Bradley | Arkansas | 5011 | 2985 | 49 |
2327160 | 2327160 | 2022-03-21 | Bradley | Arkansas | 5011 | 2985 | 48 |
2323907 | 2323907 | 2022-03-20 | Bradley | Arkansas | 5011 | 2985 | 48 |
2320653 | 2320653 | 2022-03-19 | Bradley | Arkansas | 5011 | 2985 | 48 |
2317399 | 2317399 | 2022-03-18 | Bradley | Arkansas | 5011 | 2985 | 48 |
2301229 | 2301229 | 2022-03-13 | Mariposa | California | 6043 | 2985 | 30 |
2297977 | 2297977 | 2022-03-12 | Mariposa | California | 6043 | 2985 | 30 |
2294725 | 2294725 | 2022-03-11 | Mariposa | California | 6043 | 2985 | 30 |
2223114 | 2223114 | 2022-02-17 | Desha | Arkansas | 5041 | 2985 | 37 |
2172191 | 2172191 | 2022-02-01 | Arenac | Michigan | 26011 | 2985 | 60 |
2172909 | 2172909 | 2022-02-01 | Mitchell | North Carolina | 37121 | 2985 | 28 |
2168938 | 2168938 | 2022-01-31 | Arenac | Michigan | 26011 | 2985 | 60 |
2154475 | 2154475 | 2022-01-26 | Westmoreland | Virginia | 51193 | 2985 | 39 |
2145958 | 2145958 | 2022-01-24 | Green | Kentucky | 21087 | 2985 | 40 |
2140309 | 2140309 | 2022-01-22 | Yates | New York | 36123 | 2985 | 36 |
2140436 | 2140436 | 2022-01-22 | McKenzie | North Dakota | 38053 | 2985 | 23 |
2141310 | 2141310 | 2022-01-22 | Unknown | Utah | 2985 | 56 | |
2130534 | 2130534 | 2022-01-19 | Schuyler | New York | 36097 | 2985 | 23 |
2118487 | 2118487 | 2022-01-15 | Tyler | Texas | 48457 | 2985 | 74 |
2102768 | 2102768 | 2022-01-11 | Howard | Arkansas | 5061 | 2985 | 39 |
2078181 | 2078181 | 2022-01-03 | Moniteau | Missouri | 29135 | 2985 | 46 |
2054466 | 2054466 | 2021-12-27 | Bond | Illinois | 17005 | 2985 | 34 |
2012078 | 2012078 | 2021-12-14 | Jeff Davis | Georgia | 13161 | 2985 | 61 |
1996935 | 1996935 | 2021-12-09 | Pike | Missouri | 29163 | 2985 | 51 |
1975371 | 1975371 | 2021-12-02 | Lee | Texas | 48287 | 2985 | 54 |
1972122 | 1972122 | 2021-12-01 | Lee | Texas | 48287 | 2985 | 54 |
1968872 | 1968872 | 2021-11-30 | Lee | Texas | 48287 | 2985 | 54 |
1968911 | 1968911 | 2021-11-30 | Panola | Texas | 48365 | 2985 | 108 |
1965621 | 1965621 | 2021-11-29 | Lee | Texas | 48287 | 2985 | 54 |
1942971 | 1942971 | 2021-11-22 | Young | Texas | 48503 | 2985 | 72 |
1937400 | 1937400 | 2021-11-21 | Kauai | Hawaii | 15007 | 2985 | 13 |
1939721 | 1939721 | 2021-11-21 | Young | Texas | 48503 | 2985 | 72 |
1936471 | 1936471 | 2021-11-20 | Young | Texas | 48503 | 2985 | 72 |
1920733 | 1920733 | 2021-11-16 | Hempstead | Arkansas | 5057 | 2985 | 41 |
1915521 | 1915521 | 2021-11-14 | Clarke | Mississippi | 28023 | 2985 | 95 |
1912271 | 1912271 | 2021-11-13 | Clarke | Mississippi | 28023 | 2985 | 95 |
1909021 | 1909021 | 2021-11-12 | Clarke | Mississippi | 28023 | 2985 | 95 |
1871979 | 1871979 | 2021-11-01 | Cross | Arkansas | 5037 | 2985 | 64 |
1872017 | 1872017 | 2021-11-01 | Polk | Arkansas | 5113 | 2985 | 110 |
1868730 | 1868730 | 2021-10-31 | Cross | Arkansas | 5037 | 2985 | 64 |
1868768 | 1868768 | 2021-10-31 | Polk | Arkansas | 5113 | 2985 | 110 |
1869364 | 1869364 | 2021-10-31 | Orange | Indiana | 18117 | 2985 | 69 |
1865481 | 1865481 | 2021-10-30 | Cross | Arkansas | 5037 | 2985 | 64 |
1865519 | 1865519 | 2021-10-30 | Polk | Arkansas | 5113 | 2985 | 110 |
1866115 | 1866115 | 2021-10-30 | Orange | Indiana | 18117 | 2985 | 69 |
1862866 | 1862866 | 2021-10-29 | Orange | Indiana | 18117 | 2985 | 69 |
1841728 | 1841728 | 2021-10-22 | Juncos | Puerto Rico | 72077 | 2985 | |
1838479 | 1838479 | 2021-10-21 | Juncos | Puerto Rico | 72077 | 2985 | |
1835230 | 1835230 | 2021-10-20 | Juncos | Puerto Rico | 72077 | 2985 | |
1831681 | 1831681 | 2021-10-19 | Carroll | Ohio | 39019 | 2985 | 59 |
1831981 | 1831981 | 2021-10-19 | Juncos | Puerto Rico | 72077 | 2985 | |
1828732 | 1828732 | 2021-10-18 | Juncos | Puerto Rico | 72077 | 2985 | |
1754958 | 1754958 | 2021-09-26 | Juneau City and Borough | Alaska | 2110 | 2985 | 7 |
1751710 | 1751710 | 2021-09-25 | Juneau City and Borough | Alaska | 2110 | 2985 | 7 |
1748461 | 1748461 | 2021-09-24 | Juneau City and Borough | Alaska | 2110 | 2985 | 7 |
1735145 | 1735145 | 2021-09-19 | Mecklenburg | Virginia | 51117 | 2985 | 73 |
1731895 | 1731895 | 2021-09-18 | Mecklenburg | Virginia | 51117 | 2985 | 73 |
1732013 | 1732013 | 2021-09-18 | Mason | West Virginia | 54053 | 2985 | 45 |
1728645 | 1728645 | 2021-09-17 | Mecklenburg | Virginia | 51117 | 2985 | 73 |
1715294 | 1715294 | 2021-09-13 | Burleson | Texas | 48051 | 2985 | 55 |
1711081 | 1711081 | 2021-09-12 | Cass | Nebraska | 31025 | 2985 | 17 |
1707834 | 1707834 | 2021-09-11 | Cass | Nebraska | 31025 | 2985 | 17 |
1704587 | 1704587 | 2021-09-10 | Cass | Nebraska | 31025 | 2985 | 17 |
1656167 | 1656167 | 2021-08-26 | Transylvania | North Carolina | 37175 | 2985 | 36 |
1656462 | 1656462 | 2021-08-26 | Elk | Pennsylvania | 42047 | 2985 | 42 |
1648263 | 1648263 | 2021-08-24 | Jerome | Idaho | 16053 | 2985 | 27 |
1642205 | 1642205 | 2021-08-22 | Carter | Kentucky | 21043 | 2985 | 38 |
1638955 | 1638955 | 2021-08-21 | Carter | Kentucky | 21043 | 2985 | 38 |
1635705 | 1635705 | 2021-08-20 | Carter | Kentucky | 21043 | 2985 | 38 |
1633875 | 1633875 | 2021-08-19 | Jasper | South Carolina | 45053 | 2985 | 50 |
1627402 | 1627402 | 2021-08-17 | Beadle | South Dakota | 46005 | 2985 | 42 |
1621370 | 1621370 | 2021-08-15 | St. Thomas | Virgin Islands | 78030 | 2985 | 24 |
1618122 | 1618122 | 2021-08-14 | St. Thomas | Virgin Islands | 78030 | 2985 | 24 |
1614874 | 1614874 | 2021-08-13 | St. Thomas | Virgin Islands | 78030 | 2985 | 24 |
1606663 | 1606663 | 2021-08-11 | Dorchester | Maryland | 24019 | 2985 | 65 |
1581578 | 1581578 | 2021-08-03 | Morrow | Ohio | 39117 | 2985 | 44 |
1573867 | 1573867 | 2021-08-01 | Cherokee | Kansas | 20021 | 2985 | 57 |
1575342 | 1575342 | 2021-08-01 | Mayaguez | Puerto Rico | 72097 | 2985 | |
1570619 | 1570619 | 2021-07-31 | Cherokee | Kansas | 20021 | 2985 | 57 |
1567371 | 1567371 | 2021-07-30 | Cherokee | Kansas | 20021 | 2985 | 57 |
1518326 | 1518326 | 2021-07-15 | Cassia | Idaho | 16031 | 2985 | 28 |
1519315 | 1519315 | 2021-07-15 | McDonald | Missouri | 29119 | 2985 | 38 |
1512626 | 1512626 | 2021-07-13 | Le Sueur | Minnesota | 27079 | 2985 | 27 |
1488414 | 1488414 | 2021-07-05 | Mineral | West Virginia | 54057 | 2985 | 92 |
1485167 | 1485167 | 2021-07-04 | Mineral | West Virginia | 54057 | 2985 | 92 |
1481921 | 1481921 | 2021-07-03 | Mineral | West Virginia | 54057 | 2985 | 92 |
1478588 | 1478588 | 2021-07-02 | Smyth | Virginia | 51173 | 2985 | 96 |
1478674 | 1478674 | 2021-07-02 | Mineral | West Virginia | 54057 | 2985 | 92 |
1475342 | 1475342 | 2021-07-01 | Smyth | Virginia | 51173 | 2985 | 96 |
1465497 | 1465497 | 2021-06-28 | Amherst | Virginia | 51009 | 2985 | 40 |
1459007 | 1459007 | 2021-06-26 | Amherst | Virginia | 51009 | 2985 | 40 |
1455762 | 1455762 | 2021-06-25 | Amherst | Virginia | 51009 | 2985 | 40 |
1450311 | 1450311 | 2021-06-24 | Fayette | Indiana | 18041 | 2985 | 66 |
1452517 | 1452517 | 2021-06-24 | Amherst | Virginia | 51009 | 2985 | 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);