ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
113 rows where cases = 3809 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Wisconsin 13
- Texas 12
- Arkansas 8
- Minnesota 7
- Georgia 6
- Missouri 6
- Alabama 5
- Ohio 5
- Virginia 5
- New York 4
- Pennsylvania 4
- Illinois 3
- Indiana 3
- Kentucky 3
- Louisiana 3
- West Virginia 3
- California 2
- Iowa 2
- Michigan 2
- Nebraska 2
- New Jersey 2
- Puerto Rico 2
- Tennessee 2
- Florida 1
- Mississippi 1
- Montana 1
- New Mexico 1
- North Carolina 1
- Oklahoma 1
- South Carolina 1
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2489553 | 2489553 | 2022-05-09 | Manassas Park city | Virginia | 51685 | 3809 | 27 |
2479185 | 2479185 | 2022-05-06 | Villalba | Puerto Rico | 72149 | 3809 | |
2474863 | 2474863 | 2022-05-05 | Faribault | Minnesota | 27043 | 3809 | 51 |
2443295 | 2443295 | 2022-04-25 | Aibonito | Puerto Rico | 72009 | 3809 | |
2437716 | 2437716 | 2022-04-24 | Crenshaw | Alabama | 1041 | 3809 | 99 |
2434460 | 2434460 | 2022-04-23 | Crenshaw | Alabama | 1041 | 3809 | 99 |
2431204 | 2431204 | 2022-04-22 | Crenshaw | Alabama | 1041 | 3809 | 99 |
2427948 | 2427948 | 2022-04-21 | Crenshaw | Alabama | 1041 | 3809 | 99 |
2418103 | 2418103 | 2022-04-17 | Marquette | Wisconsin | 55077 | 3809 | 61 |
2414847 | 2414847 | 2022-04-16 | Marquette | Wisconsin | 55077 | 3809 | 61 |
2411591 | 2411591 | 2022-04-15 | Marquette | Wisconsin | 55077 | 3809 | 61 |
2398760 | 2398760 | 2022-04-12 | Franklin | Arkansas | 5047 | 3809 | 72 |
2395505 | 2395505 | 2022-04-11 | Franklin | Arkansas | 5047 | 3809 | 72 |
2392249 | 2392249 | 2022-04-10 | Franklin | Arkansas | 5047 | 3809 | 72 |
2336470 | 2336470 | 2022-03-23 | Lamoille | Vermont | 50015 | 3809 | 17 |
2309092 | 2309092 | 2022-03-15 | Moniteau | Missouri | 29135 | 3809 | 55 |
2270113 | 2270113 | 2022-03-03 | Wright | Missouri | 29229 | 3809 | 77 |
2263627 | 2263627 | 2022-03-01 | Glacier | Montana | 30035 | 3809 | 68 |
2219775 | 2219775 | 2022-02-16 | Macon | Alabama | 1087 | 3809 | 72 |
2222439 | 2222439 | 2022-02-16 | Freestone | Texas | 48161 | 3809 | 81 |
2222508 | 2222508 | 2022-02-16 | Llano | Texas | 48299 | 3809 | 91 |
2212961 | 2212961 | 2022-02-13 | Greene | Virginia | 51079 | 3809 | 55 |
2209708 | 2209708 | 2022-02-12 | Greene | Virginia | 51079 | 3809 | 55 |
2206455 | 2206455 | 2022-02-11 | Greene | Virginia | 51079 | 3809 | 55 |
2193088 | 2193088 | 2022-02-07 | Aransas | Texas | 48007 | 3809 | 72 |
2190426 | 2190426 | 2022-02-06 | Washburn | Wisconsin | 55129 | 3809 | 39 |
2187173 | 2187173 | 2022-02-05 | Washburn | Wisconsin | 55129 | 3809 | 39 |
2183920 | 2183920 | 2022-02-04 | Washburn | Wisconsin | 55129 | 3809 | 39 |
2161074 | 2161074 | 2022-01-28 | Taylor | West Virginia | 54091 | 3809 | 59 |
2154187 | 2154187 | 2022-01-26 | Lee | Texas | 48287 | 3809 | 56 |
2105990 | 2105990 | 2022-01-12 | Ashley | Arkansas | 5003 | 3809 | 56 |
2083266 | 2083266 | 2022-01-05 | Lawrence | Arkansas | 5075 | 3809 | 63 |
2012015 | 2012015 | 2021-12-14 | Burke | Georgia | 13033 | 3809 | 86 |
1970878 | 1970878 | 2021-12-01 | Crawford | Missouri | 29055 | 3809 | 74 |
1943539 | 1943539 | 2021-11-23 | Del Norte | California | 6015 | 3809 | 42 |
1912944 | 1912944 | 2021-11-13 | Holmes | Ohio | 39075 | 3809 | 132 |
1913946 | 1913946 | 2021-11-13 | Boone | West Virginia | 54005 | 3809 | 60 |
1897968 | 1897968 | 2021-11-09 | Cleburne | Arkansas | 5023 | 3809 | 93 |
1895344 | 1895344 | 2021-11-08 | LaGrange | Indiana | 18087 | 3809 | 89 |
1897820 | 1897820 | 2021-11-08 | Waushara | Wisconsin | 55137 | 3809 | 54 |
1882101 | 1882101 | 2021-11-04 | Pike | Georgia | 13231 | 3809 | 69 |
1837267 | 1837267 | 2021-10-21 | Plaquemines | Louisiana | 22075 | 3809 | 40 |
1834018 | 1834018 | 2021-10-20 | Plaquemines | Louisiana | 22075 | 3809 | 40 |
1830769 | 1830769 | 2021-10-19 | Plaquemines | Louisiana | 22075 | 3809 | 40 |
1832586 | 1832586 | 2021-10-19 | Gloucester | Virginia | 51073 | 3809 | 74 |
1782706 | 1782706 | 2021-10-04 | Luna | New Mexico | 35029 | 3809 | 93 |
1749989 | 1749989 | 2021-09-24 | Stone | Missouri | 29209 | 3809 | 78 |
1727229 | 1727229 | 2021-09-17 | Saline | Missouri | 29195 | 3809 | 45 |
1715104 | 1715104 | 2021-09-13 | Union | South Carolina | 45087 | 3809 | 86 |
1697493 | 1697493 | 2021-09-08 | Montgomery | Kentucky | 21173 | 3809 | 36 |
1690411 | 1690411 | 2021-09-06 | Pierce | Georgia | 13229 | 3809 | 72 |
1687161 | 1687161 | 2021-09-05 | Pierce | Georgia | 13229 | 3809 | 72 |
1683911 | 1683911 | 2021-09-04 | Pierce | Georgia | 13229 | 3809 | 72 |
1680660 | 1680660 | 2021-09-03 | Pierce | Georgia | 13229 | 3809 | 72 |
1678278 | 1678278 | 2021-09-02 | Lyon | Minnesota | 27083 | 3809 | 54 |
1665991 | 1665991 | 2021-08-29 | Champaign | Ohio | 39021 | 3809 | 60 |
1656149 | 1656149 | 2021-08-26 | Pasquotank | North Carolina | 37139 | 3809 | 88 |
1652782 | 1652782 | 2021-08-25 | Chenango | New York | 36017 | 3809 | 82 |
1649030 | 1649030 | 2021-08-24 | Freeborn | Minnesota | 27047 | 3809 | 37 |
1646750 | 1646750 | 2021-08-23 | Snyder | Pennsylvania | 42109 | 3809 | 86 |
1624799 | 1624799 | 2021-08-16 | Fayette | West Virginia | 54019 | 3809 | 86 |
1559343 | 1559343 | 2021-07-27 | White | Tennessee | 47185 | 3809 | 74 |
1556096 | 1556096 | 2021-07-26 | White | Tennessee | 47185 | 3809 | 74 |
1520427 | 1520427 | 2021-07-15 | Cooke | Texas | 48097 | 3809 | 72 |
1500947 | 1500947 | 2021-07-09 | Cooke | Texas | 48097 | 3809 | 72 |
1497701 | 1497701 | 2021-07-08 | Cooke | Texas | 48097 | 3809 | 72 |
1468116 | 1468116 | 2021-06-29 | McKean | Pennsylvania | 42083 | 3809 | 72 |
1445400 | 1445400 | 2021-06-22 | McKean | Pennsylvania | 42083 | 3809 | 72 |
1398508 | 1398508 | 2021-06-08 | Lee | Iowa | 19111 | 3809 | 56 |
1361021 | 1361021 | 2021-05-27 | Perry | Pennsylvania | 42099 | 3809 | 100 |
1352166 | 1352166 | 2021-05-24 | Oneida | Wisconsin | 55085 | 3809 | 77 |
1348920 | 1348920 | 2021-05-23 | Oneida | Wisconsin | 55085 | 3809 | 77 |
1345672 | 1345672 | 2021-05-22 | Oneida | Wisconsin | 55085 | 3809 | 77 |
1342424 | 1342424 | 2021-05-21 | Oneida | Wisconsin | 55085 | 3809 | 77 |
1339176 | 1339176 | 2021-05-20 | Oneida | Wisconsin | 55085 | 3809 | 77 |
1321076 | 1321076 | 2021-05-15 | Becker | Minnesota | 27005 | 3809 | 53 |
1312904 | 1312904 | 2021-05-12 | Sanpete | Utah | 49039 | 3809 | 22 |
1287398 | 1287398 | 2021-05-05 | Boone | Arkansas | 5009 | 3809 | 80 |
1289388 | 1289388 | 2021-05-05 | Logan | Ohio | 39091 | 3809 | 76 |
1245811 | 1245811 | 2021-04-22 | Huntington | Indiana | 18069 | 3809 | 82 |
1224197 | 1224197 | 2021-04-15 | Columbia | New York | 36021 | 3809 | 99 |
1172444 | 1172444 | 2021-03-30 | Brown | Ohio | 39015 | 3809 | 55 |
1119126 | 1119126 | 2021-03-14 | Woodford | Illinois | 17203 | 3809 | 73 |
1115879 | 1115879 | 2021-03-13 | Woodford | Illinois | 17203 | 3809 | 73 |
1112633 | 1112633 | 2021-03-12 | Woodford | Illinois | 17203 | 3809 | 73 |
1090456 | 1090456 | 2021-03-05 | Barry | Michigan | 26015 | 3809 | 46 |
1025672 | 1025672 | 2021-02-13 | Nobles | Minnesota | 27105 | 3809 | 47 |
996202 | 996202 | 2021-02-04 | Whitley | Kentucky | 21235 | 3809 | 16 |
996775 | 996775 | 2021-02-04 | Dakota | Nebraska | 31043 | 3809 | 67 |
997879 | 997879 | 2021-02-04 | Nacogdoches | Texas | 48347 | 3809 | 129 |
993529 | 993529 | 2021-02-03 | Dakota | Nebraska | 31043 | 3809 | 67 |
987195 | 987195 | 2021-02-01 | Cattaraugus | New York | 36009 | 3809 | 68 |
970463 | 970463 | 2021-01-27 | Douglas | Minnesota | 27041 | 3809 | 66 |
971244 | 971244 | 2021-01-27 | Putnam | Ohio | 39137 | 3809 | 76 |
954359 | 954359 | 2021-01-22 | Panola | Mississippi | 28107 | 3809 | 81 |
937486 | 937486 | 2021-01-17 | Des Moines | Iowa | 19057 | 3809 | 41 |
925094 | 925094 | 2021-01-13 | Winona | Minnesota | 27169 | 3809 | 46 |
923158 | 923158 | 2021-01-12 | Hardin | Texas | 48199 | 3809 | 59 |
919913 | 919913 | 2021-01-11 | Hardin | Texas | 48199 | 3809 | 58 |
916668 | 916668 | 2021-01-10 | Hardin | Texas | 48199 | 3809 | 58 |
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);