ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
173 rows where cases = 3028 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Georgia 18
- Oklahoma 17
- Arkansas 16
- Puerto Rico 8
- Louisiana 7
- Mississippi 7
- Texas 7
- Alabama 6
- Maryland 6
- Missouri 6
- Michigan 5
- Minnesota 5
- Pennsylvania 5
- Tennessee 5
- Virginia 5
- Illinois 4
- Nevada 4
- Florida 3
- Indiana 3
- South Dakota 3
- Washington 3
- West Virginia 3
- Wisconsin 3
- Colorado 2
- Idaho 2
- Massachusetts 2
- New York 2
- North Carolina 2
- North Dakota 2
- Wyoming 2
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2441083 | 2441083 | 2022-04-25 | Desha | Arkansas | 5041 | 3028 | 41 |
2443345 | 2443345 | 2022-04-25 | Orocovis | Puerto Rico | 72107 | 3028 | |
2437827 | 2437827 | 2022-04-24 | Desha | Arkansas | 5041 | 3028 | 41 |
2434571 | 2434571 | 2022-04-23 | Desha | Arkansas | 5041 | 3028 | 41 |
2431315 | 2431315 | 2022-04-22 | Desha | Arkansas | 5041 | 3028 | 41 |
2383738 | 2383738 | 2022-04-07 | Pope | Minnesota | 27121 | 3028 | 17 |
2335739 | 2335739 | 2022-03-23 | Johnston | Oklahoma | 40069 | 3028 | 52 |
2332485 | 2332485 | 2022-03-22 | Johnston | Oklahoma | 40069 | 3028 | 52 |
2329232 | 2329232 | 2022-03-21 | Johnston | Oklahoma | 40069 | 3028 | 52 |
2325980 | 2325980 | 2022-03-20 | Johnston | Oklahoma | 40069 | 3028 | 52 |
2322727 | 2322727 | 2022-03-19 | Johnston | Oklahoma | 40069 | 3028 | 52 |
2319473 | 2319473 | 2022-03-18 | Johnston | Oklahoma | 40069 | 3028 | 52 |
2316219 | 2316219 | 2022-03-17 | Johnston | Oklahoma | 40069 | 3028 | 52 |
2290209 | 2290209 | 2022-03-09 | Love | Oklahoma | 40085 | 3028 | 36 |
2286957 | 2286957 | 2022-03-08 | Love | Oklahoma | 40085 | 3028 | 36 |
2282728 | 2282728 | 2022-03-07 | Kent | Maryland | 24029 | 3028 | 66 |
2283705 | 2283705 | 2022-03-07 | Love | Oklahoma | 40085 | 3028 | 36 |
2279475 | 2279475 | 2022-03-06 | Kent | Maryland | 24029 | 3028 | 66 |
2280453 | 2280453 | 2022-03-06 | Love | Oklahoma | 40085 | 3028 | 36 |
2276222 | 2276222 | 2022-03-05 | Kent | Maryland | 24029 | 3028 | 66 |
2277200 | 2277200 | 2022-03-05 | Love | Oklahoma | 40085 | 3028 | 36 |
2273947 | 2273947 | 2022-03-04 | Love | Oklahoma | 40085 | 3028 | 36 |
2270694 | 2270694 | 2022-03-03 | Love | Oklahoma | 40085 | 3028 | 36 |
2267442 | 2267442 | 2022-03-02 | Love | Oklahoma | 40085 | 3028 | 36 |
2261687 | 2261687 | 2022-02-28 | Brunswick | Virginia | 51025 | 3028 | 42 |
2256832 | 2256832 | 2022-02-27 | Chippewa | Minnesota | 27023 | 3028 | 47 |
2256964 | 2256964 | 2022-02-27 | Perry | Mississippi | 28111 | 3028 | 63 |
2253581 | 2253581 | 2022-02-26 | Chippewa | Minnesota | 27023 | 3028 | 47 |
2253713 | 2253713 | 2022-02-26 | Perry | Mississippi | 28111 | 3028 | 63 |
2250330 | 2250330 | 2022-02-25 | Chippewa | Minnesota | 27023 | 3028 | 47 |
2250462 | 2250462 | 2022-02-25 | Perry | Mississippi | 28111 | 3028 | 63 |
2247211 | 2247211 | 2022-02-24 | Perry | Mississippi | 28111 | 3028 | 63 |
2233868 | 2233868 | 2022-02-20 | Caldwell | Louisiana | 22021 | 3028 | 47 |
2230617 | 2230617 | 2022-02-19 | Caldwell | Louisiana | 22021 | 3028 | 47 |
2227366 | 2227366 | 2022-02-18 | Caldwell | Louisiana | 22021 | 3028 | 47 |
2180606 | 2180606 | 2022-02-03 | Bayfield | Wisconsin | 55007 | 3028 | 37 |
2163559 | 2163559 | 2022-01-29 | Loiza | Puerto Rico | 72087 | 3028 | |
2153473 | 2153473 | 2022-01-26 | Walsh | North Dakota | 38099 | 3028 | 34 |
2131278 | 2131278 | 2022-01-19 | Bandera | Texas | 48019 | 3028 | 65 |
2126780 | 2126780 | 2022-01-18 | Renville | Minnesota | 27129 | 3028 | 52 |
2106387 | 2106387 | 2022-01-12 | Rabun | Georgia | 13241 | 3028 | 82 |
2105571 | 2105571 | 2022-01-11 | Buckingham | Virginia | 51029 | 3028 | 41 |
2091188 | 2091188 | 2022-01-07 | Moniteau | Missouri | 29135 | 3028 | 46 |
2077084 | 2077084 | 2022-01-03 | Jeff Davis | Georgia | 13161 | 3028 | 63 |
2073833 | 2073833 | 2022-01-02 | Jeff Davis | Georgia | 13161 | 3028 | 63 |
2070582 | 2070582 | 2022-01-01 | Jeff Davis | Georgia | 13161 | 3028 | 63 |
2067331 | 2067331 | 2021-12-31 | Jeff Davis | Georgia | 13161 | 3028 | 63 |
2061865 | 2061865 | 2021-12-29 | Benton | Missouri | 29015 | 3028 | 72 |
2063183 | 2063183 | 2021-12-29 | Robertson | Texas | 48395 | 3028 | 68 |
2056217 | 2056217 | 2021-12-27 | Corozal | Puerto Rico | 72047 | 3028 | |
2040851 | 2040851 | 2021-12-22 | Lincoln | Wyoming | 56023 | 3028 | 27 |
2016286 | 2016286 | 2021-12-15 | Clarke | Mississippi | 28023 | 3028 | 95 |
2011775 | 2011775 | 2021-12-14 | Polk | Arkansas | 5113 | 3028 | 114 |
2006997 | 2006997 | 2021-12-12 | Schoharie | New York | 36095 | 3028 | 26 |
1995968 | 1995968 | 2021-12-09 | Clay | Illinois | 17025 | 3028 | 59 |
1991878 | 1991878 | 2021-12-07 | Powhatan | Virginia | 51145 | 3028 | 30 |
1988702 | 1988702 | 2021-12-06 | Barbour | West Virginia | 54001 | 3028 | 52 |
1958721 | 1958721 | 2021-11-27 | Juncos | Puerto Rico | 72077 | 3028 | |
1943474 | 1943474 | 2021-11-23 | Cross | Arkansas | 5037 | 3028 | 66 |
1940224 | 1940224 | 2021-11-22 | Cross | Arkansas | 5037 | 3028 | 66 |
1936974 | 1936974 | 2021-11-21 | Cross | Arkansas | 5037 | 3028 | 66 |
1933724 | 1933724 | 2021-11-20 | Cross | Arkansas | 5037 | 3028 | 65 |
1913970 | 1913970 | 2021-11-13 | McDowell | West Virginia | 54047 | 3028 | 50 |
1909893 | 1909893 | 2021-11-12 | Juniata | Pennsylvania | 42067 | 3028 | 120 |
1889703 | 1889703 | 2021-11-06 | Texas | Missouri | 29215 | 3028 | 43 |
1882788 | 1882788 | 2021-11-04 | Hancock | Maine | 23009 | 3028 | 50 |
1862667 | 1862667 | 2021-10-29 | Blaine | Idaho | 16013 | 3028 | 27 |
1858819 | 1858819 | 2021-10-27 | Taylor | Wisconsin | 55119 | 3028 | 46 |
1845865 | 1845865 | 2021-10-24 | Cherokee | Alabama | 1019 | 3028 | 60 |
1842615 | 1842615 | 2021-10-23 | Cherokee | Alabama | 1019 | 3028 | 60 |
1842267 | 1842267 | 2021-10-22 | Bennington | Vermont | 50003 | 3028 | 26 |
1837323 | 1837323 | 2021-10-21 | Garrett | Maryland | 24023 | 3028 | 79 |
1835226 | 1835226 | 2021-10-20 | Humacao | Puerto Rico | 72069 | 3028 | |
1826553 | 1826553 | 2021-10-18 | Colusa | California | 6011 | 3028 | 18 |
1804167 | 1804167 | 2021-10-11 | Worth | Georgia | 13321 | 3028 | 86 |
1800918 | 1800918 | 2021-10-10 | Worth | Georgia | 13321 | 3028 | 86 |
1797669 | 1797669 | 2021-10-09 | Worth | Georgia | 13321 | 3028 | 86 |
1794420 | 1794420 | 2021-10-08 | Worth | Georgia | 13321 | 3028 | 86 |
1786458 | 1786458 | 2021-10-05 | Aguadilla | Puerto Rico | 72005 | 3028 | |
1781169 | 1781169 | 2021-10-04 | Pitkin | Colorado | 8097 | 3028 | 5 |
1766991 | 1766991 | 2021-09-29 | Gurabo | Puerto Rico | 72063 | 3028 | |
1745190 | 1745190 | 2021-09-23 | Randolph | Alabama | 1111 | 3028 | 55 |
1741998 | 1741998 | 2021-09-22 | Ashley | Arkansas | 5003 | 3028 | 42 |
1744892 | 1744892 | 2021-09-22 | Mecklenburg | Virginia | 51117 | 3028 | 73 |
1736610 | 1736610 | 2021-09-20 | Somerset | Maryland | 24039 | 3028 | 46 |
1725758 | 1725758 | 2021-09-17 | Clark | Arkansas | 5019 | 3028 | 50 |
1722930 | 1722930 | 2021-09-16 | Washington | Georgia | 13303 | 3028 | 101 |
1720374 | 1720374 | 2021-09-15 | Franklin | Massachusetts | 25011 | 3028 | 115 |
1700128 | 1700128 | 2021-09-09 | Jones | Georgia | 13169 | 3028 | 67 |
1701100 | 1701100 | 2021-09-09 | Jasper | Mississippi | 28061 | 3028 | 60 |
1677443 | 1677443 | 2021-09-02 | Union | Georgia | 13291 | 3028 | 87 |
1667319 | 1667319 | 2021-08-30 | Logan | Arkansas | 5083 | 3028 | 31 |
1664365 | 1664365 | 2021-08-29 | Fannin | Georgia | 13111 | 3028 | 78 |
1661117 | 1661117 | 2021-08-28 | Fannin | Georgia | 13111 | 3028 | 78 |
1657869 | 1657869 | 2021-08-27 | Fannin | Georgia | 13111 | 3028 | 78 |
1650338 | 1650338 | 2021-08-24 | Cass | Texas | 48067 | 3028 | 95 |
1650393 | 1650393 | 2021-08-24 | Gonzales | Texas | 48177 | 3028 | 61 |
1643690 | 1643690 | 2021-08-22 | Meade | South Dakota | 46093 | 3028 | 31 |
1640440 | 1640440 | 2021-08-21 | Meade | South Dakota | 46093 | 3028 | 31 |
1637190 | 1637190 | 2021-08-20 | Meade | South Dakota | 46093 | 3028 | 31 |
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);