ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
189 rows where cases = 2530 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Puerto Rico 15
- Texas 15
- Missouri 14
- Virginia 12
- Georgia 11
- Iowa 9
- South Dakota 9
- Kansas 8
- South Carolina 7
- Colorado 6
- Illinois 6
- Louisiana 6
- Ohio 6
- Idaho 5
- Minnesota 5
- Mississippi 5
- Wisconsin 5
- New York 4
- Pennsylvania 4
- Tennessee 4
- Alabama 3
- Indiana 3
- Kentucky 3
- North Carolina 3
- Oklahoma 3
- Virgin Islands 3
- Maryland 2
- Nebraska 2
- North Dakota 2
- Arkansas 1
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2395621 | 2395621 | 2022-04-11 | Bent | Colorado | 8011 | 2530 | 47 |
2396787 | 2396787 | 2022-04-11 | Yellow Medicine | Minnesota | 27173 | 2530 | 29 |
2392365 | 2392365 | 2022-04-10 | Bent | Colorado | 8011 | 2530 | 47 |
2389109 | 2389109 | 2022-04-09 | Bent | Colorado | 8011 | 2530 | 47 |
2391217 | 2391217 | 2022-04-09 | Ciales | Puerto Rico | 72039 | 2530 | |
2385854 | 2385854 | 2022-04-08 | Bent | Colorado | 8011 | 2530 | 47 |
2308663 | 2308663 | 2022-03-15 | East Carroll | Louisiana | 22035 | 2530 | 38 |
2305412 | 2305412 | 2022-03-14 | East Carroll | Louisiana | 22035 | 2530 | 38 |
2289571 | 2289571 | 2022-03-09 | Linn | Missouri | 29115 | 2530 | 62 |
2270157 | 2270157 | 2022-03-03 | Rosebud | Montana | 30087 | 2530 | 59 |
2262829 | 2262829 | 2022-03-01 | Grundy | Iowa | 19075 | 2530 | 40 |
2259578 | 2259578 | 2022-02-28 | Grundy | Iowa | 19075 | 2530 | 40 |
2256327 | 2256327 | 2022-02-27 | Grundy | Iowa | 19075 | 2530 | 40 |
2253076 | 2253076 | 2022-02-26 | Grundy | Iowa | 19075 | 2530 | 40 |
2249825 | 2249825 | 2022-02-25 | Grundy | Iowa | 19075 | 2530 | 40 |
2246574 | 2246574 | 2022-02-24 | Grundy | Iowa | 19075 | 2530 | 40 |
2243021 | 2243021 | 2022-02-23 | Turner | Georgia | 13287 | 2530 | 53 |
2243323 | 2243323 | 2022-02-23 | Grundy | Iowa | 19075 | 2530 | 40 |
2239998 | 2239998 | 2022-02-22 | Newton | Indiana | 18111 | 2530 | 68 |
2217904 | 2217904 | 2022-02-15 | Carroll | Mississippi | 28015 | 2530 | 49 |
2199650 | 2199650 | 2022-02-09 | Dawson | Texas | 48115 | 2530 | 92 |
2148383 | 2148383 | 2022-01-25 | Plumas | California | 6063 | 2530 | 12 |
2128958 | 2128958 | 2022-01-19 | Unknown | Connecticut | 2530 | 5 | |
2128352 | 2128352 | 2022-01-18 | Dickenson | Virginia | 51051 | 2530 | 40 |
2104385 | 2104385 | 2022-01-11 | Unknown | Nebraska | 2530 | 305 | |
2063880 | 2063880 | 2021-12-30 | Grand | Colorado | 8049 | 2530 | 20 |
2037133 | 2037133 | 2021-12-21 | Leon | Texas | 48289 | 2530 | 72 |
2033511 | 2033511 | 2021-12-20 | San Lorenzo | Puerto Rico | 72129 | 2530 | |
2033663 | 2033663 | 2021-12-20 | Decatur | Tennessee | 47039 | 2530 | 44 |
2030181 | 2030181 | 2021-12-19 | Potter | Pennsylvania | 42105 | 2530 | 73 |
2017215 | 2017215 | 2021-12-15 | Corozal | Puerto Rico | 72047 | 2530 | |
2013665 | 2013665 | 2021-12-14 | Walsh | North Dakota | 38099 | 2530 | 30 |
2011490 | 2011490 | 2021-12-13 | Morgan | West Virginia | 54065 | 2530 | 51 |
1996482 | 1996482 | 2021-12-09 | Bienville | Louisiana | 22013 | 2530 | 99 |
1998134 | 1998134 | 2021-12-09 | Madison | Texas | 48313 | 2530 | 46 |
1993166 | 1993166 | 2021-12-08 | Larue | Kentucky | 21123 | 2530 | 53 |
1982365 | 1982365 | 2021-12-05 | Clay | Alabama | 1027 | 2530 | 69 |
1960949 | 1960949 | 2021-11-28 | Faribault | Minnesota | 27043 | 2530 | 32 |
1957698 | 1957698 | 2021-11-27 | Faribault | Minnesota | 27043 | 2530 | 32 |
1954447 | 1954447 | 2021-11-26 | Faribault | Minnesota | 27043 | 2530 | 32 |
1938757 | 1938757 | 2021-11-21 | Bertie | North Carolina | 37015 | 2530 | 53 |
1935507 | 1935507 | 2021-11-20 | Bertie | North Carolina | 37015 | 2530 | 53 |
1932257 | 1932257 | 2021-11-19 | Bertie | North Carolina | 37015 | 2530 | 53 |
1926242 | 1926242 | 2021-11-17 | San Sebastian | Puerto Rico | 72131 | 2530 | |
1873431 | 1873431 | 2021-11-01 | Pike | Missouri | 29163 | 2530 | 37 |
1871048 | 1871048 | 2021-10-31 | Lee | South Carolina | 45061 | 2530 | 75 |
1867799 | 1867799 | 2021-10-30 | Lee | South Carolina | 45061 | 2530 | 75 |
1864550 | 1864550 | 2021-10-29 | Lee | South Carolina | 45061 | 2530 | 75 |
1842026 | 1842026 | 2021-10-22 | Colorado | Texas | 48089 | 2530 | 51 |
1835316 | 1835316 | 2021-10-20 | Saluda | South Carolina | 45081 | 2530 | 54 |
1827414 | 1827414 | 2021-10-18 | Henry | Kentucky | 21103 | 2530 | 25 |
1821477 | 1821477 | 2021-10-16 | Wright | Missouri | 29229 | 2530 | 47 |
1813133 | 1813133 | 2021-10-13 | Nottoway | Virginia | 51135 | 2530 | 62 |
1796644 | 1796644 | 2021-10-08 | Llano | Texas | 48299 | 2530 | 68 |
1769381 | 1769381 | 2021-09-30 | Benton | Missouri | 29015 | 2530 | 44 |
1769446 | 1769446 | 2021-09-30 | Morgan | Missouri | 29141 | 2530 | 57 |
1766751 | 1766751 | 2021-09-29 | Paulding | Ohio | 39125 | 2530 | 43 |
1736574 | 1736574 | 2021-09-20 | Winn | Louisiana | 22127 | 2530 | 57 |
1737225 | 1737225 | 2021-09-20 | Roosevelt | New Mexico | 35041 | 2530 | 65 |
1722327 | 1722327 | 2021-09-15 | Langlade | Wisconsin | 55067 | 2530 | 52 |
1694656 | 1694656 | 2021-09-07 | Andrew | Missouri | 29003 | 2530 | 23 |
1670383 | 1670383 | 2021-08-30 | Vilas | Wisconsin | 55125 | 2530 | 46 |
1645697 | 1645697 | 2021-08-23 | Emmet | Michigan | 26047 | 2530 | 43 |
1646008 | 1646008 | 2021-08-23 | Perry | Missouri | 29157 | 2530 | 30 |
1633039 | 1633039 | 2021-08-19 | Vernon | Missouri | 29217 | 2530 | 50 |
1617530 | 1617530 | 2021-08-14 | Aguadilla | Puerto Rico | 72005 | 2530 | |
1613806 | 1613806 | 2021-08-13 | Delaware | New York | 36025 | 2530 | 39 |
1586412 | 1586412 | 2021-08-05 | Grady | Georgia | 13131 | 2530 | 66 |
1575887 | 1575887 | 2021-08-01 | St. Thomas | Virgin Islands | 78030 | 2530 | 22 |
1572639 | 1572639 | 2021-07-31 | St. Thomas | Virgin Islands | 78030 | 2530 | 22 |
1569391 | 1569391 | 2021-07-30 | St. Thomas | Virgin Islands | 78030 | 2530 | 22 |
1559215 | 1559215 | 2021-07-27 | Hughes | South Dakota | 46065 | 2530 | 42 |
1559371 | 1559371 | 2021-07-27 | Burleson | Texas | 48051 | 2530 | 48 |
1559486 | 1559486 | 2021-07-27 | Lamb | Texas | 48279 | 2530 | 83 |
1555968 | 1555968 | 2021-07-26 | Hughes | South Dakota | 46065 | 2530 | 42 |
1552721 | 1552721 | 2021-07-25 | Hughes | South Dakota | 46065 | 2530 | 42 |
1549474 | 1549474 | 2021-07-24 | Hughes | South Dakota | 46065 | 2530 | 42 |
1546227 | 1546227 | 2021-07-23 | Hughes | South Dakota | 46065 | 2530 | 42 |
1542980 | 1542980 | 2021-07-22 | Hughes | South Dakota | 46065 | 2530 | 42 |
1539732 | 1539732 | 2021-07-21 | Hughes | South Dakota | 46065 | 2530 | 42 |
1520307 | 1520307 | 2021-07-15 | Fentress | Tennessee | 47049 | 2530 | 49 |
1514669 | 1514669 | 2021-07-14 | Ouachita | Arkansas | 5103 | 2530 | 63 |
1517059 | 1517059 | 2021-07-14 | Fentress | Tennessee | 47049 | 2530 | 49 |
1485085 | 1485085 | 2021-07-04 | Staunton city | Virginia | 51790 | 2530 | 70 |
1481839 | 1481839 | 2021-07-03 | Staunton city | Virginia | 51790 | 2530 | 70 |
1478592 | 1478592 | 2021-07-02 | Staunton city | Virginia | 51790 | 2530 | 70 |
1472807 | 1472807 | 2021-07-01 | Pierce | Georgia | 13229 | 2530 | 61 |
1472100 | 1472100 | 2021-06-30 | Staunton city | Virginia | 51790 | 2530 | 71 |
1468855 | 1468855 | 2021-06-29 | Staunton city | Virginia | 51790 | 2530 | 71 |
1465610 | 1465610 | 2021-06-28 | Staunton city | Virginia | 51790 | 2530 | 71 |
1462365 | 1462365 | 2021-06-27 | Staunton city | Virginia | 51790 | 2530 | 71 |
1459120 | 1459120 | 2021-06-26 | Staunton city | Virginia | 51790 | 2530 | 71 |
1435738 | 1435738 | 2021-06-19 | Mayaguez | Puerto Rico | 72097 | 2530 | |
1429228 | 1429228 | 2021-06-17 | Gurabo | Puerto Rico | 72063 | 2530 | |
1425983 | 1425983 | 2021-06-16 | Gurabo | Puerto Rico | 72063 | 2530 | |
1422736 | 1422736 | 2021-06-15 | Gurabo | Puerto Rico | 72063 | 2530 | |
1404634 | 1404634 | 2021-06-10 | McDuffie | Georgia | 13189 | 2530 | 50 |
1405053 | 1405053 | 2021-06-10 | Cherokee | Kansas | 20021 | 2530 | 53 |
1401808 | 1401808 | 2021-06-09 | Cherokee | Kansas | 20021 | 2530 | 53 |
1383798 | 1383798 | 2021-06-03 | Juncos | Puerto Rico | 72077 | 2530 |
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);