ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
193 rows where cases = 2579 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Georgia 17
- Wyoming 16
- Indiana 11
- Texas 11
- Colorado 10
- Kentucky 10
- Virginia 10
- Missouri 8
- Wisconsin 8
- Alabama 7
- Massachusetts 7
- Puerto Rico 7
- Louisiana 6
- Ohio 6
- Arkansas 5
- Tennessee 5
- Idaho 4
- Iowa 4
- Kansas 4
- Illinois 3
- Minnesota 3
- North Carolina 3
- Pennsylvania 3
- Alaska 2
- Michigan 2
- Mississippi 2
- Montana 2
- New York 2
- Oklahoma 2
- West Virginia 2
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2492777 | 2492777 | 2022-05-10 | Floyd | Virginia | 51063 | 2579 | 49 |
2489519 | 2489519 | 2022-05-09 | Floyd | Virginia | 51063 | 2579 | 49 |
2421394 | 2421394 | 2022-04-18 | Big Horn | Wyoming | 56003 | 2579 | 60 |
2418138 | 2418138 | 2022-04-17 | Big Horn | Wyoming | 56003 | 2579 | 60 |
2414882 | 2414882 | 2022-04-16 | Big Horn | Wyoming | 56003 | 2579 | 60 |
2411626 | 2411626 | 2022-04-15 | Big Horn | Wyoming | 56003 | 2579 | 60 |
2408370 | 2408370 | 2022-04-14 | Big Horn | Wyoming | 56003 | 2579 | 60 |
2405114 | 2405114 | 2022-04-13 | Big Horn | Wyoming | 56003 | 2579 | 60 |
2401859 | 2401859 | 2022-04-12 | Big Horn | Wyoming | 56003 | 2579 | 60 |
2398604 | 2398604 | 2022-04-11 | Big Horn | Wyoming | 56003 | 2579 | 60 |
2395349 | 2395349 | 2022-04-10 | Big Horn | Wyoming | 56003 | 2579 | 60 |
2392093 | 2392093 | 2022-04-09 | Big Horn | Wyoming | 56003 | 2579 | 60 |
2388837 | 2388837 | 2022-04-08 | Big Horn | Wyoming | 56003 | 2579 | 60 |
2385582 | 2385582 | 2022-04-07 | Big Horn | Wyoming | 56003 | 2579 | 60 |
2382327 | 2382327 | 2022-04-06 | Big Horn | Wyoming | 56003 | 2579 | 60 |
2379072 | 2379072 | 2022-04-05 | Big Horn | Wyoming | 56003 | 2579 | 60 |
2304438 | 2304438 | 2022-03-14 | Pike | Arkansas | 5109 | 2579 | 41 |
2301186 | 2301186 | 2022-03-13 | Pike | Arkansas | 5109 | 2579 | 41 |
2278552 | 2278552 | 2022-03-06 | Prowers | Colorado | 8099 | 2579 | 48 |
2275299 | 2275299 | 2022-03-05 | Prowers | Colorado | 8099 | 2579 | 48 |
2272046 | 2272046 | 2022-03-04 | Prowers | Colorado | 8099 | 2579 | 48 |
2270473 | 2270473 | 2022-03-03 | Pamlico | North Carolina | 37137 | 2579 | 27 |
2256204 | 2256204 | 2022-02-27 | Brown | Indiana | 18013 | 2579 | 62 |
2252953 | 2252953 | 2022-02-26 | Brown | Indiana | 18013 | 2579 | 62 |
2249702 | 2249702 | 2022-02-25 | Brown | Indiana | 18013 | 2579 | 62 |
2246451 | 2246451 | 2022-02-24 | Brown | Indiana | 18013 | 2579 | 62 |
2200260 | 2200260 | 2022-02-10 | Lowndes | Alabama | 1085 | 2579 | 69 |
2183511 | 2183511 | 2022-02-04 | Pecos | Texas | 48371 | 2579 | 65 |
2158504 | 2158504 | 2022-01-28 | Gooding | Idaho | 16047 | 2579 | 48 |
2155251 | 2155251 | 2022-01-27 | Gooding | Idaho | 16047 | 2579 | 48 |
2155330 | 2155330 | 2022-01-27 | Marshall | Illinois | 17123 | 2579 | 30 |
2154075 | 2154075 | 2022-01-26 | Camp | Texas | 48063 | 2579 | 70 |
2115184 | 2115184 | 2022-01-14 | Nolan | Texas | 48353 | 2579 | 85 |
2109212 | 2109212 | 2022-01-13 | Northwest Arctic Borough | Alaska | 2188 | 2579 | 9 |
2105961 | 2105961 | 2022-01-12 | Northwest Arctic Borough | Alaska | 2188 | 2579 | 9 |
2101499 | 2101499 | 2022-01-10 | Noble | Ohio | 39121 | 2579 | 50 |
2079820 | 2079820 | 2022-01-03 | Price | Wisconsin | 55099 | 2579 | 22 |
2060089 | 2060089 | 2021-12-28 | Grayson | Virginia | 51077 | 2579 | 62 |
2050649 | 2050649 | 2021-12-26 | Lamar | Alabama | 1075 | 2579 | 57 |
2032200 | 2032200 | 2021-12-20 | Monroe | Kentucky | 21171 | 2579 | 67 |
1996552 | 1996552 | 2021-12-09 | Sagadahoc | Maine | 23023 | 2579 | 16 |
1983397 | 1983397 | 2021-12-05 | Green | Kentucky | 21087 | 2579 | 37 |
1980147 | 1980147 | 2021-12-04 | Green | Kentucky | 21087 | 2579 | 37 |
1970467 | 1970467 | 2021-12-01 | Union | Kentucky | 21225 | 2579 | 40 |
1952859 | 1952859 | 2021-11-25 | New Kent | Virginia | 51127 | 2579 | 26 |
1945714 | 1945714 | 2021-11-23 | Isabela | Puerto Rico | 72071 | 2579 | |
1942463 | 1942463 | 2021-11-22 | Isabela | Puerto Rico | 72071 | 2579 | |
1923516 | 1923516 | 2021-11-16 | Windham | Vermont | 50025 | 2579 | 26 |
1920578 | 1920578 | 2021-11-15 | Goshen | Wyoming | 56015 | 2579 | 40 |
1886404 | 1886404 | 2021-11-05 | Livingston | Missouri | 29117 | 2579 | 63 |
1882891 | 1882891 | 2021-11-04 | Manistee | Michigan | 26101 | 2579 | 38 |
1883155 | 1883155 | 2021-11-04 | Livingston | Missouri | 29117 | 2579 | 63 |
1879642 | 1879642 | 2021-11-03 | Manistee | Michigan | 26101 | 2579 | 38 |
1875000 | 1875000 | 2021-11-01 | Wetzel | West Virginia | 54103 | 2579 | 53 |
1840924 | 1840924 | 2021-10-22 | Moniteau | Missouri | 29135 | 2579 | 38 |
1835633 | 1835633 | 2021-10-20 | Llano | Texas | 48299 | 2579 | 71 |
1808373 | 1808373 | 2021-10-12 | Benton | Missouri | 29015 | 2579 | 44 |
1785310 | 1785310 | 2021-10-05 | Winn | Louisiana | 22127 | 2579 | 58 |
1782355 | 1782355 | 2021-10-04 | Smith | Mississippi | 28129 | 2579 | 49 |
1776421 | 1776421 | 2021-10-02 | Rolette | North Dakota | 38079 | 2579 | 30 |
1769713 | 1769713 | 2021-09-30 | Roosevelt | New Mexico | 35041 | 2579 | 66 |
1762144 | 1762144 | 2021-09-28 | Perry | Indiana | 18123 | 2579 | 55 |
1762602 | 1762602 | 2021-09-28 | Talbot | Maryland | 24041 | 2579 | 50 |
1734209 | 1734209 | 2021-09-19 | Carroll | Ohio | 39019 | 2579 | 52 |
1718890 | 1718890 | 2021-09-14 | Louisa | Virginia | 51109 | 2579 | 39 |
1710545 | 1710545 | 2021-09-12 | Jackson | Louisiana | 22049 | 2579 | 58 |
1707298 | 1707298 | 2021-09-11 | Jackson | Louisiana | 22049 | 2579 | 58 |
1704050 | 1704050 | 2021-09-10 | Jackson | Louisiana | 22049 | 2579 | 58 |
1699623 | 1699623 | 2021-09-08 | Vilas | Wisconsin | 55125 | 2579 | 47 |
1664057 | 1664057 | 2021-08-29 | Grant | Arkansas | 5053 | 2579 | 44 |
1633972 | 1633972 | 2021-08-19 | Chester | Tennessee | 47023 | 2579 | 54 |
1627432 | 1627432 | 2021-08-17 | Hughes | South Dakota | 46065 | 2579 | 43 |
1615250 | 1615250 | 2021-08-14 | Pickens | Alabama | 1107 | 2579 | 63 |
1612001 | 1612001 | 2021-08-13 | Pickens | Alabama | 1107 | 2579 | 63 |
1607395 | 1607395 | 2021-08-11 | Greene | North Carolina | 37079 | 2579 | 48 |
1597793 | 1597793 | 2021-08-08 | Gallia | Ohio | 39053 | 2579 | 50 |
1581320 | 1581320 | 2021-08-03 | Franklin | New York | 36033 | 2579 | 12 |
1578071 | 1578071 | 2021-08-02 | Franklin | New York | 36033 | 2579 | 12 |
1566589 | 1566589 | 2021-07-30 | Columbia | Arkansas | 5027 | 2579 | 58 |
1562333 | 1562333 | 2021-07-28 | Gurabo | Puerto Rico | 72063 | 2579 | |
1559085 | 1559085 | 2021-07-27 | Gurabo | Puerto Rico | 72063 | 2579 | |
1555838 | 1555838 | 2021-07-26 | Gurabo | Puerto Rico | 72063 | 2579 | |
1510394 | 1510394 | 2021-07-12 | Mayaguez | Puerto Rico | 72097 | 2579 | |
1510405 | 1510405 | 2021-07-12 | Rio Grande | Puerto Rico | 72119 | 2579 | |
1492941 | 1492941 | 2021-07-07 | Plaquemines | Louisiana | 22075 | 2579 | 27 |
1436636 | 1436636 | 2021-06-20 | Geneva | Alabama | 1061 | 2579 | 81 |
1433389 | 1433389 | 2021-06-19 | Geneva | Alabama | 1061 | 2579 | 81 |
1430143 | 1430143 | 2021-06-18 | Geneva | Alabama | 1061 | 2579 | 81 |
1431344 | 1431344 | 2021-06-18 | Franklin | Massachusetts | 25011 | 2579 | 113 |
1428099 | 1428099 | 2021-06-17 | Franklin | Massachusetts | 25011 | 2579 | 113 |
1424854 | 1424854 | 2021-06-16 | Franklin | Massachusetts | 25011 | 2579 | 113 |
1426842 | 1426842 | 2021-06-16 | Waushara | Wisconsin | 55137 | 2579 | 38 |
1421606 | 1421606 | 2021-06-15 | Franklin | Massachusetts | 25011 | 2579 | 113 |
1423596 | 1423596 | 2021-06-15 | Waushara | Wisconsin | 55137 | 2579 | 38 |
1418361 | 1418361 | 2021-06-14 | Franklin | Massachusetts | 25011 | 2579 | 113 |
1420065 | 1420065 | 2021-06-14 | Botetourt | Virginia | 51023 | 2579 | 38 |
1415116 | 1415116 | 2021-06-13 | Franklin | Massachusetts | 25011 | 2579 | 113 |
1411870 | 1411870 | 2021-06-12 | Franklin | Massachusetts | 25011 | 2579 | 113 |
1398582 | 1398582 | 2021-06-08 | Franklin | Kansas | 20059 | 2579 | 43 |
1395335 | 1395335 | 2021-06-07 | Franklin | Kansas | 20059 | 2579 | 43 |
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);