ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
154 rows where cases = 2930 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Kentucky 18
- Idaho 9
- Puerto Rico 9
- Louisiana 8
- Texas 8
- Arkansas 7
- Virginia 7
- Indiana 6
- Mississippi 6
- Missouri 6
- West Virginia 6
- Illinois 5
- Minnesota 5
- North Carolina 5
- Alabama 4
- Georgia 4
- Iowa 4
- Michigan 4
- Ohio 4
- Wisconsin 4
- Florida 3
- Nebraska 3
- Arizona 2
- California 2
- North Dakota 2
- Wyoming 2
- Colorado 1
- Kansas 1
- Maryland 1
- Montana 1
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2347674 | 2347674 | 2022-03-27 | Todd | Kentucky | 21219 | 2930 | 43 |
2344421 | 2344421 | 2022-03-26 | Todd | Kentucky | 21219 | 2930 | 43 |
2341168 | 2341168 | 2022-03-25 | Todd | Kentucky | 21219 | 2930 | 43 |
2337915 | 2337915 | 2022-03-24 | Todd | Kentucky | 21219 | 2930 | 43 |
2334661 | 2334661 | 2022-03-23 | Todd | Kentucky | 21219 | 2930 | 43 |
2331407 | 2331407 | 2022-03-22 | Todd | Kentucky | 21219 | 2930 | 43 |
2328155 | 2328155 | 2022-03-21 | Todd | Kentucky | 21219 | 2930 | 43 |
2302349 | 2302349 | 2022-03-13 | Aitkin | Minnesota | 27001 | 2930 | 60 |
2302930 | 2302930 | 2022-03-13 | Alleghany | North Carolina | 37005 | 2930 | 12 |
2299097 | 2299097 | 2022-03-12 | Aitkin | Minnesota | 27001 | 2930 | 60 |
2299678 | 2299678 | 2022-03-12 | Alleghany | North Carolina | 37005 | 2930 | 12 |
2295845 | 2295845 | 2022-03-11 | Aitkin | Minnesota | 27001 | 2930 | 60 |
2296426 | 2296426 | 2022-03-11 | Alleghany | North Carolina | 37005 | 2930 | 12 |
2293174 | 2293174 | 2022-03-10 | Alleghany | North Carolina | 37005 | 2930 | 12 |
2285344 | 2285344 | 2022-03-08 | Idaho | Idaho | 16049 | 2930 | 50 |
2282092 | 2282092 | 2022-03-07 | Idaho | Idaho | 16049 | 2930 | 50 |
2278839 | 2278839 | 2022-03-06 | Idaho | Idaho | 16049 | 2930 | 50 |
2275586 | 2275586 | 2022-03-05 | Idaho | Idaho | 16049 | 2930 | 50 |
2272333 | 2272333 | 2022-03-04 | Idaho | Idaho | 16049 | 2930 | 50 |
2243953 | 2243953 | 2022-02-23 | Montgomery | Mississippi | 28097 | 2930 | 71 |
2221355 | 2221355 | 2022-02-16 | Custer | Montana | 30017 | 2930 | 45 |
2195556 | 2195556 | 2022-02-08 | Torrance | New Mexico | 35057 | 2930 | 48 |
2147157 | 2147157 | 2022-01-24 | Hood River | Oregon | 41027 | 2930 | 39 |
2121222 | 2121222 | 2022-01-16 | Aibonito | Puerto Rico | 72009 | 2930 | |
2095543 | 2095543 | 2022-01-08 | Colorado | Texas | 48089 | 2930 | 56 |
2087928 | 2087928 | 2022-01-06 | Livingston | Missouri | 29117 | 2930 | 81 |
2024099 | 2024099 | 2021-12-17 | Houston | Texas | 48225 | 2930 | 89 |
2019531 | 2019531 | 2021-12-16 | Calhoun | Mississippi | 28013 | 2930 | 51 |
2013653 | 2013653 | 2021-12-14 | Richland | North Dakota | 38077 | 2930 | 21 |
1998184 | 1998184 | 2021-12-09 | San Jacinto | Texas | 48407 | 2930 | 82 |
1987183 | 1987183 | 2021-12-06 | Pike | Missouri | 29163 | 2930 | 51 |
1982966 | 1982966 | 2021-12-05 | Clay | Illinois | 17025 | 2930 | 59 |
1979716 | 1979716 | 2021-12-04 | Clay | Illinois | 17025 | 2930 | 59 |
1976466 | 1976466 | 2021-12-03 | Clay | Illinois | 17025 | 2930 | 59 |
1973627 | 1973627 | 2021-12-02 | Casey | Kentucky | 21045 | 2930 | 59 |
1960641 | 1960641 | 2021-11-28 | Garrard | Kentucky | 21079 | 2930 | 51 |
1957390 | 1957390 | 2021-11-27 | Garrard | Kentucky | 21079 | 2930 | 51 |
1954139 | 1954139 | 2021-11-26 | Garrard | Kentucky | 21079 | 2930 | 51 |
1950888 | 1950888 | 2021-11-25 | Garrard | Kentucky | 21079 | 2930 | 51 |
1947637 | 1947637 | 2021-11-24 | Garrard | Kentucky | 21079 | 2930 | 51 |
1938152 | 1938152 | 2021-11-21 | Ogemaw | Michigan | 26129 | 2930 | 68 |
1934902 | 1934902 | 2021-11-20 | Ogemaw | Michigan | 26129 | 2930 | 68 |
1931652 | 1931652 | 2021-11-19 | Ogemaw | Michigan | 26129 | 2930 | 68 |
1930331 | 1930331 | 2021-11-18 | Lincoln | Wyoming | 56023 | 2930 | 24 |
1877933 | 1877933 | 2021-11-02 | Shelby | Texas | 48419 | 2930 | 110 |
1874879 | 1874879 | 2021-11-01 | Radford city | Virginia | 51750 | 2930 | 33 |
1864508 | 1864508 | 2021-10-29 | Vega Alta | Puerto Rico | 72143 | 2930 | |
1865228 | 1865228 | 2021-10-29 | McDowell | West Virginia | 54047 | 2930 | 50 |
1847445 | 1847445 | 2021-10-24 | Ray | Missouri | 29177 | 2930 | 50 |
1844195 | 1844195 | 2021-10-23 | Ray | Missouri | 29177 | 2930 | 50 |
1839496 | 1839496 | 2021-10-22 | Hempstead | Arkansas | 5057 | 2930 | 38 |
1817178 | 1817178 | 2021-10-15 | Blaine | Idaho | 16013 | 2930 | 23 |
1816172 | 1816172 | 2021-10-14 | Panola | Texas | 48365 | 2930 | 106 |
1758162 | 1758162 | 2021-09-27 | Hale | Alabama | 1065 | 2930 | 85 |
1741988 | 1741988 | 2021-09-22 | La Paz | Arizona | 4012 | 2930 | 86 |
1742994 | 1742994 | 2021-09-22 | Simpson | Kentucky | 21213 | 2930 | 47 |
1725513 | 1725513 | 2021-09-16 | Mason | West Virginia | 54053 | 2930 | 43 |
1706277 | 1706277 | 2021-09-11 | Conway | Arkansas | 5029 | 2930 | 41 |
1700148 | 1700148 | 2021-09-09 | Morgan | Georgia | 13211 | 2930 | 32 |
1700381 | 1700381 | 2021-09-09 | Fountain | Indiana | 18045 | 2930 | 55 |
1695521 | 1695521 | 2021-09-07 | Gurabo | Puerto Rico | 72063 | 2930 | |
1692273 | 1692273 | 2021-09-06 | Gurabo | Puerto Rico | 72063 | 2930 | |
1689844 | 1689844 | 2021-09-05 | Kewaunee | Wisconsin | 55061 | 2930 | 39 |
1686594 | 1686594 | 2021-09-04 | Kewaunee | Wisconsin | 55061 | 2930 | 39 |
1683344 | 1683344 | 2021-09-03 | Kewaunee | Wisconsin | 55061 | 2930 | 39 |
1654300 | 1654300 | 2021-08-26 | Columbia | Arkansas | 5027 | 2930 | 61 |
1634804 | 1634804 | 2021-08-20 | Cleburne | Arkansas | 5023 | 2930 | 76 |
1629278 | 1629278 | 2021-08-18 | Ohio | Kentucky | 21183 | 2930 | 57 |
1631313 | 1631313 | 2021-08-18 | Mingo | West Virginia | 54059 | 2930 | 45 |
1625101 | 1625101 | 2021-08-17 | Ouachita | Arkansas | 5103 | 2930 | 67 |
1594541 | 1594541 | 2021-08-07 | Fayette | Ohio | 39047 | 2930 | 50 |
1587170 | 1587170 | 2021-08-05 | Dorchester | Maryland | 24019 | 2930 | 65 |
1582738 | 1582738 | 2021-08-04 | Geneva | Alabama | 1061 | 2930 | 83 |
1579320 | 1579320 | 2021-08-02 | Greenbrier | West Virginia | 54025 | 2930 | 65 |
1559409 | 1559409 | 2021-07-27 | Dimmit | Texas | 48127 | 2930 | 37 |
1533983 | 1533983 | 2021-07-19 | Park | Wyoming | 56029 | 2930 | 33 |
1515643 | 1515643 | 2021-07-14 | De Soto | Louisiana | 22031 | 2930 | 78 |
1500394 | 1500394 | 2021-07-09 | Morrow | Ohio | 39117 | 2930 | 42 |
1464051 | 1464051 | 2021-06-28 | Tippah | Mississippi | 28139 | 2930 | 68 |
1352363 | 1352363 | 2021-05-25 | Johnson | Arkansas | 5071 | 2930 | 38 |
1340253 | 1340253 | 2021-05-21 | Clark | Kentucky | 21049 | 2930 | 29 |
1336127 | 1336127 | 2021-05-20 | Johnson | Arkansas | 5071 | 2930 | 38 |
1332931 | 1332931 | 2021-05-19 | Glenn | California | 6021 | 2930 | 25 |
1333573 | 1333573 | 2021-05-19 | Henry | Iowa | 19087 | 2930 | 37 |
1332417 | 1332417 | 2021-05-18 | Amherst | Virginia | 51009 | 2930 | 37 |
1329170 | 1329170 | 2021-05-17 | Amherst | Virginia | 51009 | 2930 | 37 |
1325924 | 1325924 | 2021-05-16 | Amherst | Virginia | 51009 | 2930 | 37 |
1301938 | 1301938 | 2021-05-09 | Adams | Nebraska | 31001 | 2930 | 43 |
1300071 | 1300071 | 2021-05-08 | Warren | Virginia | 51187 | 2930 | 55 |
1294499 | 1294499 | 2021-05-07 | Fayette | Indiana | 18041 | 2930 | 64 |
1294864 | 1294864 | 2021-05-07 | Muhlenberg | Kentucky | 21177 | 2930 | 61 |
1291322 | 1291322 | 2021-05-06 | Wells | Indiana | 18179 | 2930 | 83 |
1288076 | 1288076 | 2021-05-05 | Wells | Indiana | 18179 | 2930 | 83 |
1288446 | 1288446 | 2021-05-05 | Sabine | Louisiana | 22085 | 2930 | 60 |
1281224 | 1281224 | 2021-05-03 | Decatur | Georgia | 13087 | 2930 | 70 |
1268965 | 1268965 | 2021-04-29 | Sabine | Louisiana | 22085 | 2930 | 60 |
1267423 | 1267423 | 2021-04-28 | Willacy | Texas | 48489 | 2930 | 88 |
1241080 | 1241080 | 2021-04-20 | Lawrence | South Dakota | 46081 | 2930 | 47 |
1229684 | 1229684 | 2021-04-17 | Jones | Iowa | 19105 | 2930 | 55 |
1226436 | 1226436 | 2021-04-16 | Jones | Iowa | 19105 | 2930 | 55 |
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);