ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
158 rows where cases = 3126 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Georgia 18
- Puerto Rico 13
- Minnesota 10
- Alabama 9
- Ohio 9
- Arkansas 8
- Kentucky 7
- Texas 7
- Illinois 5
- Indiana 5
- Michigan 5
- Mississippi 5
- Virginia 5
- West Virginia 5
- Louisiana 4
- Missouri 4
- Tennessee 4
- New York 3
- South Dakota 3
- Vermont 3
- Washington 3
- Wyoming 3
- Connecticut 2
- New Hampshire 2
- New Mexico 2
- North Carolina 2
- South Carolina 2
- Wisconsin 2
- Arizona 1
- California 1
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2490009 | 2490009 | 2022-05-10 | Mariposa | California | 6043 | 3126 | 34 |
2421885 | 2421885 | 2022-04-19 | Jasper | Georgia | 13159 | 3126 | 71 |
2418629 | 2418629 | 2022-04-18 | Jasper | Georgia | 13159 | 3126 | 71 |
2415373 | 2415373 | 2022-04-17 | Jasper | Georgia | 13159 | 3126 | 71 |
2412117 | 2412117 | 2022-04-16 | Jasper | Georgia | 13159 | 3126 | 71 |
2408861 | 2408861 | 2022-04-15 | Jasper | Georgia | 13159 | 3126 | 71 |
2405605 | 2405605 | 2022-04-14 | Jasper | Georgia | 13159 | 3126 | 71 |
2402350 | 2402350 | 2022-04-13 | Jasper | Georgia | 13159 | 3126 | 71 |
2397219 | 2397219 | 2022-04-11 | Torrance | New Mexico | 35057 | 3126 | 53 |
2392584 | 2392584 | 2022-04-10 | Jasper | Georgia | 13159 | 3126 | 71 |
2389328 | 2389328 | 2022-04-09 | Jasper | Georgia | 13159 | 3126 | 71 |
2386073 | 2386073 | 2022-04-08 | Jasper | Georgia | 13159 | 3126 | 71 |
2382818 | 2382818 | 2022-04-07 | Jasper | Georgia | 13159 | 3126 | 71 |
2290392 | 2290392 | 2022-03-09 | Loiza | Puerto Rico | 72087 | 3126 | |
2287140 | 2287140 | 2022-03-08 | Loiza | Puerto Rico | 72087 | 3126 | |
2283888 | 2283888 | 2022-03-07 | Loiza | Puerto Rico | 72087 | 3126 | |
2280636 | 2280636 | 2022-03-06 | Loiza | Puerto Rico | 72087 | 3126 | |
2277383 | 2277383 | 2022-03-05 | Loiza | Puerto Rico | 72087 | 3126 | |
2270841 | 2270841 | 2022-03-03 | Barceloneta | Puerto Rico | 72017 | 3126 | |
2271731 | 2271731 | 2022-03-03 | Converse | Wyoming | 56009 | 3126 | 53 |
2268479 | 2268479 | 2022-03-02 | Converse | Wyoming | 56009 | 3126 | 53 |
2264478 | 2264478 | 2022-03-01 | Dewey | South Dakota | 46041 | 3126 | 39 |
2265226 | 2265226 | 2022-03-01 | Converse | Wyoming | 56009 | 3126 | 53 |
2251664 | 2251664 | 2022-02-25 | Comanche | Texas | 48093 | 3126 | 76 |
2237065 | 2237065 | 2022-02-21 | Martin | Kentucky | 21159 | 3126 | 44 |
2215461 | 2215461 | 2022-02-14 | Baker | Oregon | 41001 | 3126 | 44 |
2196404 | 2196404 | 2022-02-08 | Duval | Texas | 48131 | 3126 | 66 |
2188232 | 2188232 | 2022-02-06 | Clinton | Kentucky | 21053 | 3126 | 41 |
2190123 | 2190123 | 2022-02-06 | Lamoille | Vermont | 50015 | 3126 | 13 |
2184979 | 2184979 | 2022-02-05 | Clinton | Kentucky | 21053 | 3126 | 41 |
2186870 | 2186870 | 2022-02-05 | Lamoille | Vermont | 50015 | 3126 | 13 |
2181727 | 2181727 | 2022-02-04 | Clinton | Kentucky | 21053 | 3126 | 41 |
2183617 | 2183617 | 2022-02-04 | Lamoille | Vermont | 50015 | 3126 | 13 |
2157937 | 2157937 | 2022-01-28 | Cleburne | Alabama | 1029 | 3126 | 62 |
2154684 | 2154684 | 2022-01-27 | Cleburne | Alabama | 1029 | 3126 | 62 |
2151431 | 2151431 | 2022-01-26 | Cleburne | Alabama | 1029 | 3126 | 62 |
2148179 | 2148179 | 2022-01-25 | Cleburne | Alabama | 1029 | 3126 | 62 |
2144927 | 2144927 | 2022-01-24 | Cleburne | Alabama | 1029 | 3126 | 62 |
2131756 | 2131756 | 2022-01-19 | Grant | West Virginia | 54023 | 3126 | 49 |
2127763 | 2127763 | 2022-01-18 | Lares | Puerto Rico | 72081 | 3126 | |
2086234 | 2086234 | 2022-01-05 | Hardy | West Virginia | 54031 | 3126 | 41 |
2057240 | 2057240 | 2021-12-28 | Cross | Arkansas | 5037 | 3126 | 70 |
2056627 | 2056627 | 2021-12-27 | Lamb | Texas | 48279 | 3126 | 99 |
2031252 | 2031252 | 2021-12-20 | Hempstead | Arkansas | 5057 | 3126 | 46 |
2020445 | 2020445 | 2021-12-16 | Aguadilla | Puerto Rico | 72005 | 3126 | |
2013452 | 2013452 | 2021-12-14 | Taos | New Mexico | 35055 | 3126 | 71 |
1991200 | 1991200 | 2021-12-07 | Canovanas | Puerto Rico | 72029 | 3126 | |
1987949 | 1987949 | 2021-12-06 | Canovanas | Puerto Rico | 72029 | 3126 | |
1970781 | 1970781 | 2021-12-01 | Clay | Mississippi | 28025 | 3126 | 78 |
1945710 | 1945710 | 2021-11-23 | Gurabo | Puerto Rico | 72063 | 3126 | |
1942459 | 1942459 | 2021-11-22 | Gurabo | Puerto Rico | 72063 | 3126 | |
1939209 | 1939209 | 2021-11-21 | Gurabo | Puerto Rico | 72063 | 3126 | |
1923714 | 1923714 | 2021-11-16 | Lincoln | West Virginia | 54043 | 3126 | 48 |
1907465 | 1907465 | 2021-11-11 | Lewis | West Virginia | 54041 | 3126 | 56 |
1882000 | 1882000 | 2021-11-04 | Brantley | Georgia | 13025 | 3126 | 87 |
1864985 | 1864985 | 2021-10-29 | Carbon | Utah | 49007 | 3126 | 30 |
1850322 | 1850322 | 2021-10-25 | Garrett | Maryland | 24023 | 3126 | 79 |
1842639 | 1842639 | 2021-10-23 | Henry | Alabama | 1067 | 3126 | 66 |
1832961 | 1832961 | 2021-10-20 | La Paz | Arizona | 4012 | 3126 | 97 |
1829735 | 1829735 | 2021-10-19 | Conway | Arkansas | 5029 | 3126 | 43 |
1811612 | 1811612 | 2021-10-13 | Winston | Mississippi | 28159 | 3126 | 91 |
1809928 | 1809928 | 2021-10-12 | Adams | Washington | 53001 | 3126 | 28 |
1790734 | 1790734 | 2021-10-07 | Ashley | Arkansas | 5003 | 3126 | 44 |
1793388 | 1793388 | 2021-10-07 | Lavaca | Texas | 48285 | 3126 | 91 |
1772664 | 1772664 | 2021-10-01 | Henry | Missouri | 29083 | 3126 | 49 |
1758637 | 1758637 | 2021-09-27 | Putnam | Georgia | 13237 | 3126 | 74 |
1746509 | 1746509 | 2021-09-23 | Meeker | Minnesota | 27093 | 3126 | 49 |
1739036 | 1739036 | 2021-09-21 | Ben Hill | Georgia | 13017 | 3126 | 89 |
1721236 | 1721236 | 2021-09-15 | Henry | Ohio | 39069 | 3126 | 68 |
1710802 | 1710802 | 2021-09-12 | Todd | Minnesota | 27153 | 3126 | 34 |
1707555 | 1707555 | 2021-09-11 | Todd | Minnesota | 27153 | 3126 | 34 |
1704308 | 1704308 | 2021-09-10 | Todd | Minnesota | 27153 | 3126 | 34 |
1701742 | 1701742 | 2021-09-09 | Gallia | Ohio | 39053 | 3126 | 54 |
1690652 | 1690652 | 2021-09-06 | Jennings | Indiana | 18079 | 3126 | 54 |
1687402 | 1687402 | 2021-09-05 | Jennings | Indiana | 18079 | 3126 | 54 |
1689607 | 1689607 | 2021-09-05 | Carroll | Virginia | 51035 | 3126 | 81 |
1684152 | 1684152 | 2021-09-04 | Jennings | Indiana | 18079 | 3126 | 54 |
1686357 | 1686357 | 2021-09-04 | Carroll | Virginia | 51035 | 3126 | 81 |
1680901 | 1680901 | 2021-09-03 | Jennings | Indiana | 18079 | 3126 | 54 |
1683106 | 1683106 | 2021-09-03 | Carroll | Virginia | 51035 | 3126 | 81 |
1650792 | 1650792 | 2021-08-24 | Greenbrier | West Virginia | 54025 | 3126 | 66 |
1637453 | 1637453 | 2021-08-20 | Limestone | Texas | 48293 | 3126 | 85 |
1634491 | 1634491 | 2021-08-19 | Wythe | Virginia | 51197 | 3126 | 82 |
1611226 | 1611226 | 2021-08-12 | Yankton | South Dakota | 46135 | 3126 | 33 |
1607978 | 1607978 | 2021-08-11 | Yankton | South Dakota | 46135 | 3126 | 33 |
1587006 | 1587006 | 2021-08-05 | Harlan | Kentucky | 21095 | 3126 | 93 |
1577350 | 1577350 | 2021-08-02 | Franklin | Louisiana | 22041 | 3126 | 108 |
1550374 | 1550374 | 2021-07-25 | Johnson | Arkansas | 5071 | 3126 | 38 |
1540937 | 1540937 | 2021-07-22 | Gilmer | Georgia | 13123 | 3126 | 90 |
1535016 | 1535016 | 2021-07-20 | Clark | Kentucky | 21049 | 3126 | 32 |
1509387 | 1509387 | 2021-07-12 | Mille Lacs | Minnesota | 27095 | 3126 | 55 |
1506141 | 1506141 | 2021-07-11 | Mille Lacs | Minnesota | 27095 | 3126 | 55 |
1502895 | 1502895 | 2021-07-10 | Mille Lacs | Minnesota | 27095 | 3126 | 55 |
1499649 | 1499649 | 2021-07-09 | Mille Lacs | Minnesota | 27095 | 3126 | 55 |
1500155 | 1500155 | 2021-07-09 | Orleans | New York | 36073 | 3126 | 83 |
1473718 | 1473718 | 2021-07-01 | Adams | Mississippi | 28001 | 3126 | 86 |
1455153 | 1455153 | 2021-06-25 | Tioga | Pennsylvania | 42117 | 3126 | 112 |
1442900 | 1442900 | 2021-06-21 | Warren | Virginia | 51187 | 3126 | 59 |
1363228 | 1363228 | 2021-05-28 | Houghton | Michigan | 26061 | 3126 | 42 |
1356470 | 1356470 | 2021-05-26 | Bell | Kentucky | 21013 | 3126 | 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);