ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
147 rows where cases = 3160 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Mississippi 15
- Arkansas 11
- North Carolina 11
- Georgia 10
- Ohio 8
- Oklahoma 8
- Texas 7
- Illinois 6
- Minnesota 6
- Missouri 6
- Kentucky 5
- Tennessee 5
- Virginia 5
- Alabama 4
- South Carolina 4
- South Dakota 4
- Louisiana 3
- Maine 3
- Massachusetts 3
- California 2
- Colorado 2
- Idaho 2
- Kansas 2
- Pennsylvania 2
- Puerto Rico 2
- Florida 1
- Iowa 1
- Maryland 1
- Nebraska 1
- Nevada 1
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2313452 | 2313452 | 2022-03-16 | Comanche | Texas | 48093 | 3160 | 78 |
2310199 | 2310199 | 2022-03-15 | Comanche | Texas | 48093 | 3160 | 78 |
2237423 | 2237423 | 2022-02-21 | Greene | Mississippi | 28041 | 3160 | 55 |
2234172 | 2234172 | 2022-02-20 | Greene | Mississippi | 28041 | 3160 | 55 |
2234860 | 2234860 | 2022-02-20 | Noble | Ohio | 39121 | 3160 | 53 |
2230921 | 2230921 | 2022-02-19 | Greene | Mississippi | 28041 | 3160 | 55 |
2231609 | 2231609 | 2022-02-19 | Noble | Ohio | 39121 | 3160 | 53 |
2227670 | 2227670 | 2022-02-18 | Greene | Mississippi | 28041 | 3160 | 55 |
2217964 | 2217964 | 2022-02-15 | Tallahatchie | Mississippi | 28135 | 3160 | 59 |
2215976 | 2215976 | 2022-02-14 | Jackson | Texas | 48239 | 3160 | 55 |
2192193 | 2192193 | 2022-02-07 | Otoe | Nebraska | 31131 | 3160 | 17 |
2153813 | 2153813 | 2022-01-26 | Salinas | Puerto Rico | 72123 | 3160 | |
2133453 | 2133453 | 2022-01-20 | Livingston | Missouri | 29117 | 3160 | 83 |
2100432 | 2100432 | 2022-01-10 | Jackson | Kentucky | 21109 | 3160 | 59 |
2092754 | 2092754 | 2022-01-07 | Morgan | West Virginia | 54065 | 3160 | 57 |
2074718 | 2074718 | 2022-01-02 | Houston | Minnesota | 27055 | 3160 | 18 |
2071467 | 2071467 | 2022-01-01 | Houston | Minnesota | 27055 | 3160 | 18 |
2068216 | 2068216 | 2021-12-31 | Houston | Minnesota | 27055 | 3160 | 18 |
2064965 | 2064965 | 2021-12-30 | Houston | Minnesota | 27055 | 3160 | 18 |
2062716 | 2062716 | 2021-12-29 | Corozal | Puerto Rico | 72047 | 3160 | |
2063272 | 2063272 | 2021-12-29 | Caledonia | Vermont | 50005 | 3160 | 21 |
2055443 | 2055443 | 2021-12-27 | Pike | Missouri | 29163 | 3160 | 53 |
2028412 | 2028412 | 2021-12-19 | Worth | Georgia | 13321 | 3160 | 96 |
2025161 | 2025161 | 2021-12-18 | Worth | Georgia | 13321 | 3160 | 96 |
2021910 | 2021910 | 2021-12-17 | Worth | Georgia | 13321 | 3160 | 96 |
1991647 | 1991647 | 2021-12-07 | Montague | Texas | 48337 | 3160 | 98 |
1974826 | 1974826 | 2021-12-02 | Unknown | Oklahoma | 3160 | 0 | |
1916589 | 1916589 | 2021-11-14 | Hughes | South Dakota | 46065 | 3160 | 48 |
1913339 | 1913339 | 2021-11-13 | Hughes | South Dakota | 46065 | 3160 | 48 |
1910089 | 1910089 | 2021-11-12 | Hughes | South Dakota | 46065 | 3160 | 48 |
1898276 | 1898276 | 2021-11-09 | Crisp | Georgia | 13081 | 3160 | 111 |
1884879 | 1884879 | 2021-11-05 | Henry | Alabama | 1067 | 3160 | 66 |
1875393 | 1875393 | 2021-11-02 | Pitkin | Colorado | 8097 | 3160 | 5 |
1876594 | 1876594 | 2021-11-02 | Winston | Mississippi | 28159 | 3160 | 91 |
1873345 | 1873345 | 2021-11-01 | Winston | Mississippi | 28159 | 3160 | 91 |
1870096 | 1870096 | 2021-10-31 | Winston | Mississippi | 28159 | 3160 | 91 |
1866847 | 1866847 | 2021-10-30 | Winston | Mississippi | 28159 | 3160 | 91 |
1863598 | 1863598 | 2021-10-29 | Winston | Mississippi | 28159 | 3160 | 91 |
1855730 | 1855730 | 2021-10-27 | Conway | Arkansas | 5029 | 3160 | 44 |
1842719 | 1842719 | 2021-10-23 | Ashley | Arkansas | 5003 | 3160 | 48 |
1843816 | 1843816 | 2021-10-23 | Caroline | Maryland | 24011 | 3160 | 47 |
1839469 | 1839469 | 2021-10-22 | Ashley | Arkansas | 5003 | 3160 | 48 |
1831532 | 1831532 | 2021-10-19 | Caswell | North Carolina | 37033 | 3160 | 37 |
1784746 | 1784746 | 2021-10-05 | Douglas | Illinois | 17041 | 3160 | 43 |
1786774 | 1786774 | 2021-10-05 | Burleson | Texas | 48051 | 3160 | 57 |
1781023 | 1781023 | 2021-10-04 | Lawrence | Arkansas | 5075 | 3160 | 53 |
1777773 | 1777773 | 2021-10-03 | Lawrence | Arkansas | 5075 | 3160 | 53 |
1767091 | 1767091 | 2021-09-29 | Beadle | South Dakota | 46005 | 3160 | 43 |
1763814 | 1763814 | 2021-09-28 | Fairfield | South Carolina | 45039 | 3160 | 91 |
1759318 | 1759318 | 2021-09-27 | Aroostook | Maine | 23003 | 3160 | 73 |
1759575 | 1759575 | 2021-09-27 | Jasper | Mississippi | 28061 | 3160 | 62 |
1756070 | 1756070 | 2021-09-26 | Aroostook | Maine | 23003 | 3160 | 73 |
1756115 | 1756115 | 2021-09-26 | Franklin | Massachusetts | 25011 | 3160 | 118 |
1752822 | 1752822 | 2021-09-25 | Aroostook | Maine | 23003 | 3160 | 73 |
1752867 | 1752867 | 2021-09-25 | Franklin | Massachusetts | 25011 | 3160 | 118 |
1749619 | 1749619 | 2021-09-24 | Franklin | Massachusetts | 25011 | 3160 | 118 |
1745141 | 1745141 | 2021-09-23 | Butler | Alabama | 1013 | 3160 | 88 |
1700249 | 1700249 | 2021-09-09 | Payette | Idaho | 16075 | 3160 | 42 |
1670112 | 1670112 | 2021-08-30 | Caroline | Virginia | 51033 | 3160 | 43 |
1654638 | 1654638 | 2021-08-26 | Harris | Georgia | 13145 | 3160 | 66 |
1631609 | 1631609 | 2021-08-19 | Sevier | Arkansas | 5133 | 3160 | 29 |
1609282 | 1609282 | 2021-08-12 | Jefferson | Idaho | 16051 | 3160 | 33 |
1607774 | 1607774 | 2021-08-11 | Tioga | Pennsylvania | 42117 | 3160 | 113 |
1600001 | 1600001 | 2021-08-09 | Harlan | Kentucky | 21095 | 3160 | 93 |
1596731 | 1596731 | 2021-08-08 | Clay | Kentucky | 21051 | 3160 | 46 |
1593482 | 1593482 | 2021-08-07 | Clay | Kentucky | 21051 | 3160 | 46 |
1590233 | 1590233 | 2021-08-06 | Clay | Kentucky | 21051 | 3160 | 46 |
1590797 | 1590797 | 2021-08-06 | Saline | Missouri | 29195 | 3160 | 40 |
1576692 | 1576692 | 2021-08-02 | Lumpkin | Georgia | 13187 | 3160 | 83 |
1531176 | 1531176 | 2021-07-19 | Dawson | Georgia | 13085 | 3160 | 49 |
1517794 | 1517794 | 2021-07-15 | Lawrence | Alabama | 1079 | 3160 | 101 |
1472942 | 1472942 | 2021-07-01 | Iroquois | Illinois | 17075 | 3160 | 70 |
1461281 | 1461281 | 2021-06-27 | Macon | North Carolina | 37113 | 3160 | 41 |
1458036 | 1458036 | 2021-06-26 | Macon | North Carolina | 37113 | 3160 | 41 |
1454791 | 1454791 | 2021-06-25 | Macon | North Carolina | 37113 | 3160 | 41 |
1448300 | 1448300 | 2021-06-23 | Macon | North Carolina | 37113 | 3160 | 41 |
1441810 | 1441810 | 2021-06-21 | Macon | North Carolina | 37113 | 3160 | 41 |
1428825 | 1428825 | 2021-06-17 | Macon | North Carolina | 37113 | 3160 | 41 |
1425580 | 1425580 | 2021-06-16 | Macon | North Carolina | 37113 | 3160 | 41 |
1422333 | 1422333 | 2021-06-15 | Macon | North Carolina | 37113 | 3160 | 41 |
1415435 | 1415435 | 2021-06-13 | Lafayette | Missouri | 29107 | 3160 | 57 |
1383528 | 1383528 | 2021-06-03 | Jackson | Ohio | 39079 | 3160 | 54 |
1380282 | 1380282 | 2021-06-02 | Jackson | Ohio | 39079 | 3160 | 54 |
1377037 | 1377037 | 2021-06-01 | Jackson | Ohio | 39079 | 3160 | 53 |
1369863 | 1369863 | 2021-05-30 | Alcorn | Mississippi | 28003 | 3160 | 71 |
1366617 | 1366617 | 2021-05-29 | Alcorn | Mississippi | 28003 | 3160 | 71 |
1363371 | 1363371 | 2021-05-28 | Alcorn | Mississippi | 28003 | 3160 | 71 |
1361696 | 1361696 | 2021-05-27 | Isle of Wight | Virginia | 51093 | 3160 | 69 |
1354675 | 1354675 | 2021-05-25 | Union | South Carolina | 45087 | 3160 | 83 |
1351429 | 1351429 | 2021-05-24 | Union | South Carolina | 45087 | 3160 | 83 |
1348183 | 1348183 | 2021-05-23 | Union | South Carolina | 45087 | 3160 | 83 |
1328842 | 1328842 | 2021-05-17 | Scott | Tennessee | 47151 | 3160 | 45 |
1321355 | 1321355 | 2021-05-15 | Warren | Missouri | 29219 | 3160 | 31 |
1307434 | 1307434 | 2021-05-11 | Perry | Illinois | 17145 | 3160 | 69 |
1308987 | 1308987 | 2021-05-11 | Woodward | Oklahoma | 40153 | 3160 | 33 |
1305604 | 1305604 | 2021-05-10 | Guernsey | Ohio | 39059 | 3160 | 53 |
1305741 | 1305741 | 2021-05-10 | Woodward | Oklahoma | 40153 | 3160 | 33 |
1302495 | 1302495 | 2021-05-09 | Woodward | Oklahoma | 40153 | 3160 | 33 |
1299247 | 1299247 | 2021-05-08 | Woodward | Oklahoma | 40153 | 3160 | 33 |
1296001 | 1296001 | 2021-05-07 | Woodward | Oklahoma | 40153 | 3160 | 33 |
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);