ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
159 rows where cases = 3068 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Indiana 15
- Iowa 9
- Minnesota 8
- Oklahoma 8
- Texas 8
- Illinois 7
- Missouri 7
- South Carolina 7
- Tennessee 7
- Kentucky 6
- Puerto Rico 6
- Virginia 6
- Colorado 5
- Georgia 5
- Louisiana 5
- Ohio 5
- Wisconsin 5
- Michigan 4
- Mississippi 4
- North Carolina 4
- Pennsylvania 4
- Alabama 3
- Montana 3
- Arkansas 2
- Florida 2
- New York 2
- Alaska 1
- Arizona 1
- California 1
- Connecticut 1
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2477969 | 2477969 | 2022-05-06 | Piscataquis | Maine | 23021 | 3068 | 31 |
2423831 | 2423831 | 2022-04-19 | Villalba | Puerto Rico | 72149 | 3068 | |
2392885 | 2392885 | 2022-04-10 | Pulaski | Indiana | 18131 | 3068 | 86 |
2389629 | 2389629 | 2022-04-09 | Pulaski | Indiana | 18131 | 3068 | 86 |
2386374 | 2386374 | 2022-04-08 | Pulaski | Indiana | 18131 | 3068 | 86 |
2383119 | 2383119 | 2022-04-07 | Pulaski | Indiana | 18131 | 3068 | 86 |
2379864 | 2379864 | 2022-04-06 | Pulaski | Indiana | 18131 | 3068 | 86 |
2376254 | 2376254 | 2022-04-05 | Charlton | Georgia | 13049 | 3068 | 62 |
2377179 | 2377179 | 2022-04-05 | Chippewa | Minnesota | 27023 | 3068 | 48 |
2338143 | 2338143 | 2022-03-24 | Chippewa | Minnesota | 27023 | 3068 | 48 |
2324561 | 2324561 | 2022-03-20 | Pulaski | Indiana | 18131 | 3068 | 85 |
2321307 | 2321307 | 2022-03-19 | Pulaski | Indiana | 18131 | 3068 | 85 |
2318053 | 2318053 | 2022-03-18 | Pulaski | Indiana | 18131 | 3068 | 85 |
2314800 | 2314800 | 2022-03-17 | Pulaski | Indiana | 18131 | 3068 | 85 |
2247585 | 2247585 | 2022-02-24 | Torrance | New Mexico | 35057 | 3068 | 50 |
2219944 | 2219944 | 2022-02-16 | Mono | California | 6051 | 3068 | 5 |
2210236 | 2210236 | 2022-02-13 | Crowley | Colorado | 8025 | 3068 | 28 |
2212321 | 2212321 | 2022-02-13 | Barceloneta | Puerto Rico | 72017 | 3068 | |
2206983 | 2206983 | 2022-02-12 | Crowley | Colorado | 8025 | 3068 | 28 |
2203730 | 2203730 | 2022-02-11 | Crowley | Colorado | 8025 | 3068 | 28 |
2171093 | 2171093 | 2022-02-01 | Little River | Arkansas | 5081 | 3068 | 85 |
2171803 | 2171803 | 2022-02-01 | Mills | Iowa | 19129 | 3068 | 38 |
2168550 | 2168550 | 2022-01-31 | Mills | Iowa | 19129 | 3068 | 38 |
2168824 | 2168824 | 2022-01-31 | Claiborne | Louisiana | 22027 | 3068 | 67 |
2165295 | 2165295 | 2022-01-30 | Mills | Iowa | 19129 | 3068 | 38 |
2166559 | 2166559 | 2022-01-30 | Noble | Ohio | 39121 | 3068 | 53 |
2162040 | 2162040 | 2022-01-29 | Mills | Iowa | 19129 | 3068 | 38 |
2158785 | 2158785 | 2022-01-28 | Mills | Iowa | 19129 | 3068 | 38 |
2155531 | 2155531 | 2022-01-27 | Mills | Iowa | 19129 | 3068 | 38 |
2152278 | 2152278 | 2022-01-26 | Mills | Iowa | 19129 | 3068 | 38 |
2153322 | 2153322 | 2022-01-26 | Yates | New York | 36123 | 3068 | 36 |
2145974 | 2145974 | 2022-01-24 | Knott | Kentucky | 21119 | 3068 | 51 |
2109638 | 2109638 | 2022-01-13 | Rabun | Georgia | 13241 | 3068 | 82 |
2108858 | 2108858 | 2022-01-12 | Greene | Virginia | 51079 | 3068 | 47 |
2100043 | 2100043 | 2022-01-10 | Mercer | Illinois | 17131 | 3068 | 38 |
2088414 | 2088414 | 2022-01-06 | Richland | North Dakota | 38077 | 3068 | 21 |
2083033 | 2083033 | 2022-01-04 | Crawford | Wisconsin | 55023 | 3068 | 25 |
2046406 | 2046406 | 2021-12-24 | Fulton | Pennsylvania | 42057 | 3068 | 45 |
2033990 | 2033990 | 2021-12-20 | Young | Texas | 48503 | 3068 | 74 |
2030740 | 2030740 | 2021-12-19 | Young | Texas | 48503 | 3068 | 74 |
2027489 | 2027489 | 2021-12-18 | Young | Texas | 48503 | 3068 | 74 |
2019150 | 2019150 | 2021-12-16 | Garrard | Kentucky | 21079 | 3068 | 55 |
1893681 | 1893681 | 2021-11-07 | Aguadilla | Puerto Rico | 72005 | 3068 | |
1894563 | 1894563 | 2021-11-07 | Vernon | Wisconsin | 55123 | 3068 | 62 |
1891313 | 1891313 | 2021-11-06 | Vernon | Wisconsin | 55123 | 3068 | 62 |
1888063 | 1888063 | 2021-11-05 | Vernon | Wisconsin | 55123 | 3068 | 62 |
1868610 | 1868610 | 2021-10-31 | Cherokee | Alabama | 1019 | 3068 | 61 |
1870965 | 1870965 | 2021-10-31 | Gurabo | Puerto Rico | 72063 | 3068 | |
1865361 | 1865361 | 2021-10-30 | Cherokee | Alabama | 1019 | 3068 | 61 |
1867716 | 1867716 | 2021-10-30 | Gurabo | Puerto Rico | 72063 | 3068 | |
1849805 | 1849805 | 2021-10-25 | Wayne | Illinois | 17191 | 3068 | 64 |
1847104 | 1847104 | 2021-10-24 | Alpena | Michigan | 26007 | 3068 | 70 |
1843854 | 1843854 | 2021-10-23 | Alpena | Michigan | 26007 | 3068 | 70 |
1840604 | 1840604 | 2021-10-22 | Alpena | Michigan | 26007 | 3068 | 70 |
1829322 | 1829322 | 2021-10-18 | Dinwiddie | Virginia | 51053 | 3068 | 51 |
1824747 | 1824747 | 2021-10-17 | Hill | Montana | 30041 | 3068 | 57 |
1821498 | 1821498 | 2021-10-16 | Hill | Montana | 30041 | 3068 | 57 |
1818249 | 1818249 | 2021-10-15 | Hill | Montana | 30041 | 3068 | 57 |
1812463 | 1812463 | 2021-10-13 | Canovanas | Puerto Rico | 72029 | 3068 | |
1800470 | 1800470 | 2021-10-10 | La Paz | Arizona | 4012 | 3068 | 95 |
1761677 | 1761677 | 2021-09-28 | Routt | Colorado | 8107 | 3068 | 22 |
1761808 | 1761808 | 2021-09-28 | Crisp | Georgia | 13081 | 3068 | 104 |
1751035 | 1751035 | 2021-09-24 | Burleson | Texas | 48051 | 3068 | 56 |
1747786 | 1747786 | 2021-09-23 | Burleson | Texas | 48051 | 3068 | 56 |
1738801 | 1738801 | 2021-09-21 | Phillips | Arkansas | 5107 | 3068 | 65 |
1735255 | 1735255 | 2021-09-19 | Jackson | West Virginia | 54035 | 3068 | 65 |
1719190 | 1719190 | 2021-09-15 | Monroe | Alabama | 1099 | 3068 | 44 |
1701617 | 1701617 | 2021-09-09 | Martin | North Carolina | 37117 | 3068 | 53 |
1689077 | 1689077 | 2021-09-05 | Abbeville | South Carolina | 45001 | 3068 | 42 |
1685827 | 1685827 | 2021-09-04 | Abbeville | South Carolina | 45001 | 3068 | 42 |
1682576 | 1682576 | 2021-09-03 | Abbeville | South Carolina | 45001 | 3068 | 42 |
1671056 | 1671056 | 2021-08-31 | Jersey | Illinois | 17083 | 3068 | 71 |
1647378 | 1647378 | 2021-08-23 | Caroline | Virginia | 51033 | 3068 | 42 |
1643748 | 1643748 | 2021-08-22 | Haywood | Tennessee | 47075 | 3068 | 66 |
1640498 | 1640498 | 2021-08-21 | Haywood | Tennessee | 47075 | 3068 | 66 |
1637248 | 1637248 | 2021-08-20 | Haywood | Tennessee | 47075 | 3068 | 66 |
1627996 | 1627996 | 2021-08-17 | Wythe | Virginia | 51197 | 3068 | 82 |
1622466 | 1622466 | 2021-08-16 | Scott | Indiana | 18143 | 3068 | 60 |
1606171 | 1606171 | 2021-08-11 | Decatur | Indiana | 18031 | 3068 | 97 |
1606951 | 1606951 | 2021-08-11 | Audrain | Missouri | 29007 | 3068 | 59 |
1599370 | 1599370 | 2021-08-09 | Chattooga | Georgia | 13055 | 3068 | 76 |
1489253 | 1489253 | 2021-07-06 | Daviess | Indiana | 18027 | 3068 | 102 |
1432844 | 1432844 | 2021-06-18 | Hockley | Texas | 48219 | 3068 | 103 |
1424711 | 1424711 | 2021-06-16 | Muhlenberg | Kentucky | 21177 | 3068 | 67 |
1347058 | 1347058 | 2021-05-23 | Brown | Minnesota | 27015 | 3068 | 40 |
1343810 | 1343810 | 2021-05-22 | Brown | Minnesota | 27015 | 3068 | 40 |
1334107 | 1334107 | 2021-05-19 | Mille Lacs | Minnesota | 27095 | 3068 | 54 |
1279822 | 1279822 | 2021-05-02 | Clarion | Pennsylvania | 42031 | 3068 | 91 |
1268210 | 1268210 | 2021-04-29 | Butts | Georgia | 13035 | 3068 | 82 |
1257273 | 1257273 | 2021-04-25 | Union | South Carolina | 45087 | 3068 | 84 |
1257417 | 1257417 | 2021-04-25 | Scott | Tennessee | 47151 | 3068 | 45 |
1252574 | 1252574 | 2021-04-24 | Bell | Kentucky | 21013 | 3068 | 53 |
1254170 | 1254170 | 2021-04-24 | Scott | Tennessee | 47151 | 3068 | 45 |
1250923 | 1250923 | 2021-04-23 | Scott | Tennessee | 47151 | 3068 | 45 |
1246681 | 1246681 | 2021-04-22 | Warren | Missouri | 29219 | 3068 | 31 |
1218028 | 1218028 | 2021-04-13 | Jackson | Oklahoma | 40065 | 3068 | 56 |
1214780 | 1214780 | 2021-04-12 | Jackson | Oklahoma | 40065 | 3068 | 56 |
1211533 | 1211533 | 2021-04-11 | Jackson | Oklahoma | 40065 | 3068 | 56 |
1208284 | 1208284 | 2021-04-10 | Jackson | Oklahoma | 40065 | 3068 | 56 |
1205036 | 1205036 | 2021-04-09 | Jackson | Oklahoma | 40065 | 3068 | 56 |
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);