ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
154 rows where cases = 3069 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Georgia 13
- Mississippi 10
- Texas 10
- New Mexico 9
- Puerto Rico 8
- Illinois 7
- Missouri 7
- Rhode Island 7
- Utah 7
- West Virginia 6
- Indiana 5
- Arkansas 4
- Colorado 4
- Kansas 4
- South Dakota 4
- Tennessee 4
- Virginia 4
- Alabama 3
- Maryland 3
- Minnesota 3
- Nebraska 3
- New York 3
- North Carolina 3
- Ohio 3
- Washington 3
- Wisconsin 3
- Kentucky 2
- New Jersey 2
- Oregon 2
- Florida 1
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2399396 | 2399396 | 2022-04-12 | Pulaski | Indiana | 18131 | 3069 | 86 |
2396141 | 2396141 | 2022-04-11 | Pulaski | Indiana | 18131 | 3069 | 86 |
2382763 | 2382763 | 2022-04-07 | Charlton | Georgia | 13049 | 3069 | 63 |
2379508 | 2379508 | 2022-04-06 | Charlton | Georgia | 13049 | 3069 | 62 |
2380434 | 2380434 | 2022-04-06 | Chippewa | Minnesota | 27023 | 3069 | 48 |
2334320 | 2334320 | 2022-03-23 | Pulaski | Indiana | 18131 | 3069 | 86 |
2331066 | 2331066 | 2022-03-22 | Pulaski | Indiana | 18131 | 3069 | 86 |
2327814 | 2327814 | 2022-03-21 | Pulaski | Indiana | 18131 | 3069 | 85 |
2269080 | 2269080 | 2022-03-03 | Gooding | Idaho | 16047 | 3069 | 53 |
2267091 | 2267091 | 2022-03-02 | Torrance | New Mexico | 35057 | 3069 | 50 |
2257338 | 2257338 | 2022-02-27 | Torrance | New Mexico | 35057 | 3069 | 50 |
2254087 | 2254087 | 2022-02-26 | Torrance | New Mexico | 35057 | 3069 | 50 |
2250836 | 2250836 | 2022-02-25 | Torrance | New Mexico | 35057 | 3069 | 50 |
2245633 | 2245633 | 2022-02-23 | Roane | West Virginia | 54087 | 3069 | 35 |
2203183 | 2203183 | 2022-02-10 | Dickenson | Virginia | 51051 | 3069 | 40 |
2193617 | 2193617 | 2022-02-07 | Bayfield | Wisconsin | 55007 | 3069 | 37 |
2172472 | 2172472 | 2022-02-01 | Dent | Missouri | 29065 | 3069 | 66 |
2166170 | 2166170 | 2022-01-30 | Otoe | Nebraska | 31131 | 3069 | 16 |
2167331 | 2167331 | 2022-01-30 | Millard | Utah | 49027 | 3069 | 32 |
2162915 | 2162915 | 2022-01-29 | Otoe | Nebraska | 31131 | 3069 | 16 |
2164076 | 2164076 | 2022-01-29 | Millard | Utah | 49027 | 3069 | 32 |
2159126 | 2159126 | 2022-01-28 | Washington | Maine | 23029 | 3069 | 45 |
2159660 | 2159660 | 2022-01-28 | Otoe | Nebraska | 31131 | 3069 | 16 |
2160821 | 2160821 | 2022-01-28 | Millard | Utah | 49027 | 3069 | 32 |
2154163 | 2154163 | 2022-01-26 | Jackson | Texas | 48239 | 3069 | 55 |
2132561 | 2132561 | 2022-01-20 | Menard | Illinois | 17129 | 3069 | 21 |
2112074 | 2112074 | 2022-01-13 | Buckingham | Virginia | 51029 | 3069 | 41 |
2078036 | 2078036 | 2022-01-03 | Calhoun | Mississippi | 28013 | 3069 | 51 |
2074790 | 2074790 | 2022-01-02 | Clarke | Mississippi | 28023 | 3069 | 96 |
2071539 | 2071539 | 2022-01-01 | Clarke | Mississippi | 28023 | 3069 | 96 |
2068288 | 2068288 | 2021-12-31 | Clarke | Mississippi | 28023 | 3069 | 96 |
2065037 | 2065037 | 2021-12-30 | Clarke | Mississippi | 28023 | 3069 | 96 |
2053420 | 2053420 | 2021-12-26 | Panola | Texas | 48365 | 3069 | 111 |
2050170 | 2050170 | 2021-12-25 | Panola | Texas | 48365 | 3069 | 111 |
2046920 | 2046920 | 2021-12-24 | Panola | Texas | 48365 | 3069 | 111 |
2043670 | 2043670 | 2021-12-23 | Panola | Texas | 48365 | 3069 | 111 |
2012097 | 2012097 | 2021-12-14 | Meriwether | Georgia | 13199 | 3069 | 121 |
2006950 | 2006950 | 2021-12-12 | Taos | New Mexico | 35055 | 3069 | 71 |
2003699 | 2003699 | 2021-12-11 | Taos | New Mexico | 35055 | 3069 | 71 |
2004956 | 2004956 | 2021-12-11 | Barbour | West Virginia | 54001 | 3069 | 53 |
2000449 | 2000449 | 2021-12-10 | Taos | New Mexico | 35055 | 3069 | 71 |
1995493 | 1995493 | 2021-12-09 | Hempstead | Arkansas | 5057 | 3069 | 44 |
1937135 | 1937135 | 2021-11-21 | Otero | Colorado | 8089 | 3069 | 90 |
1933885 | 1933885 | 2021-11-20 | Otero | Colorado | 8089 | 3069 | 90 |
1930633 | 1930633 | 2021-11-19 | Otero | Colorado | 8089 | 3069 | 90 |
1920230 | 1920230 | 2021-11-15 | Duchesne | Utah | 49013 | 3069 | 17 |
1916980 | 1916980 | 2021-11-14 | Duchesne | Utah | 49013 | 3069 | 17 |
1913730 | 1913730 | 2021-11-13 | Duchesne | Utah | 49013 | 3069 | 17 |
1910480 | 1910480 | 2021-11-12 | Duchesne | Utah | 49013 | 3069 | 17 |
1907178 | 1907178 | 2021-11-11 | Scurry | Texas | 48415 | 3069 | 82 |
1901401 | 1901401 | 2021-11-10 | Teller | Colorado | 8119 | 3069 | 38 |
1900181 | 1900181 | 2021-11-09 | Aguadilla | Puerto Rico | 72005 | 3069 | |
1896931 | 1896931 | 2021-11-08 | Aguadilla | Puerto Rico | 72005 | 3069 | |
1880712 | 1880712 | 2021-11-03 | Gurabo | Puerto Rico | 72063 | 3069 | |
1881467 | 1881467 | 2021-11-03 | Lewis | West Virginia | 54041 | 3069 | 55 |
1877463 | 1877463 | 2021-11-02 | Gurabo | Puerto Rico | 72063 | 3069 | |
1871859 | 1871859 | 2021-11-01 | Cherokee | Alabama | 1019 | 3069 | 61 |
1874214 | 1874214 | 2021-11-01 | Gurabo | Puerto Rico | 72063 | 3069 | |
1863711 | 1863711 | 2021-10-29 | Vernon | Missouri | 29217 | 3069 | 65 |
1857676 | 1857676 | 2021-10-27 | Carroll | Ohio | 39019 | 3069 | 65 |
1855149 | 1855149 | 2021-10-26 | Montague | Texas | 48337 | 3069 | 91 |
1815711 | 1815711 | 2021-10-14 | Canovanas | Puerto Rico | 72029 | 3069 | |
1804989 | 1804989 | 2021-10-11 | Martin | Minnesota | 27091 | 3069 | 34 |
1793542 | 1793542 | 2021-10-07 | Washington | Vermont | 50023 | 3069 | 18 |
1785128 | 1785128 | 2021-10-05 | Anderson | Kentucky | 21005 | 3069 | 39 |
1761503 | 1761503 | 2021-09-28 | Conway | Arkansas | 5029 | 3069 | 42 |
1764510 | 1764510 | 2021-09-28 | Nicholas | West Virginia | 54067 | 3069 | 32 |
1716960 | 1716960 | 2021-09-14 | Letcher | Kentucky | 21133 | 3069 | 53 |
1711268 | 1711268 | 2021-09-12 | Lewis | New York | 36049 | 3069 | 36 |
1696880 | 1696880 | 2021-09-08 | Lamar | Georgia | 13171 | 3069 | 70 |
1691394 | 1691394 | 2021-09-06 | Tishomingo | Mississippi | 28141 | 3069 | 83 |
1692502 | 1692502 | 2021-09-06 | Morgan | Tennessee | 47129 | 3069 | 41 |
1689253 | 1689253 | 2021-09-05 | Morgan | Tennessee | 47129 | 3069 | 41 |
1683532 | 1683532 | 2021-09-04 | Columbia | Arkansas | 5027 | 3069 | 61 |
1686003 | 1686003 | 2021-09-04 | Morgan | Tennessee | 47129 | 3069 | 41 |
1682752 | 1682752 | 2021-09-03 | Morgan | Tennessee | 47129 | 3069 | 41 |
1660783 | 1660783 | 2021-08-28 | Arkansas | Arkansas | 5001 | 3069 | 51 |
1648605 | 1648605 | 2021-08-24 | Franklin | Kansas | 20059 | 3069 | 49 |
1644893 | 1644893 | 2021-08-23 | Haralson | Georgia | 13143 | 3069 | 93 |
1645357 | 1645357 | 2021-08-23 | Franklin | Kansas | 20059 | 3069 | 49 |
1644266 | 1644266 | 2021-08-22 | Okanogan | Washington | 53047 | 3069 | 42 |
1641016 | 1641016 | 2021-08-21 | Okanogan | Washington | 53047 | 3069 | 42 |
1637766 | 1637766 | 2021-08-20 | Okanogan | Washington | 53047 | 3069 | 42 |
1626150 | 1626150 | 2021-08-17 | Dorchester | Maryland | 24019 | 3069 | 65 |
1624818 | 1624818 | 2021-08-16 | Mineral | West Virginia | 54057 | 3069 | 92 |
1614719 | 1614719 | 2021-08-13 | Limestone | Texas | 48293 | 3069 | 83 |
1608704 | 1608704 | 2021-08-12 | Bibb | Alabama | 1007 | 3069 | 67 |
1610308 | 1610308 | 2021-08-12 | Washington | Missouri | 29221 | 3069 | 53 |
1600173 | 1600173 | 2021-08-09 | Queen Anne's | Maryland | 24035 | 3069 | 55 |
1555038 | 1555038 | 2021-07-26 | Miller | Missouri | 29131 | 3069 | 61 |
1540920 | 1540920 | 2021-07-22 | Decatur | Georgia | 13087 | 3069 | 74 |
1535419 | 1535419 | 2021-07-20 | Coahoma | Mississippi | 28027 | 3069 | 85 |
1518237 | 1518237 | 2021-07-15 | Lumpkin | Georgia | 13187 | 3069 | 82 |
1519196 | 1519196 | 2021-07-15 | Itawamba | Mississippi | 28057 | 3069 | 80 |
1451118 | 1451118 | 2021-06-24 | Dunklin | Missouri | 29069 | 3069 | 50 |
1420909 | 1420909 | 2021-06-15 | Unknown | Georgia | 3069 | 4 | |
1350304 | 1350304 | 2021-05-24 | Brown | Minnesota | 27015 | 3069 | 40 |
1280069 | 1280069 | 2021-05-02 | Yankton | South Dakota | 46135 | 3069 | 30 |
1276822 | 1276822 | 2021-05-01 | Yankton | South Dakota | 46135 | 3069 | 30 |
1273575 | 1273575 | 2021-04-30 | Yankton | South Dakota | 46135 | 3069 | 30 |
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);