ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
137 rows where cases = 4327 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 30
- Ohio 12
- Kentucky 11
- South Dakota 10
- Mississippi 9
- Texas 9
- Oklahoma 8
- Indiana 7
- Georgia 6
- Minnesota 6
- Tennessee 6
- Iowa 5
- Virginia 5
- Illinois 4
- Puerto Rico 4
- West Virginia 4
- Alabama 3
- Florida 3
- Kansas 3
- Louisiana 3
- Michigan 3
- Arkansas 2
- California 2
- Idaho 2
- Missouri 2
- North Carolina 2
- Vermont 2
- Maryland 1
- New York 1
- Oregon 1
- Washington 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2469500 | 2469500 | 2022-05-03 | Hughes | South Dakota | 46065 | 4327 | 58 |
2466244 | 2466244 | 2022-05-02 | Hughes | South Dakota | 46065 | 4327 | 58 |
2462989 | 2462989 | 2022-05-01 | Hughes | South Dakota | 46065 | 4327 | 58 |
2459733 | 2459733 | 2022-04-30 | Hughes | South Dakota | 46065 | 4327 | 58 |
2456477 | 2456477 | 2022-04-29 | Hughes | South Dakota | 46065 | 4327 | 58 |
2453221 | 2453221 | 2022-04-28 | Hughes | South Dakota | 46065 | 4327 | 58 |
2449965 | 2449965 | 2022-04-27 | Hughes | South Dakota | 46065 | 4327 | 58 |
2440051 | 2440051 | 2022-04-24 | Catano | Puerto Rico | 72033 | 4327 | |
2405756 | 2405756 | 2022-04-14 | De Witt | Illinois | 17039 | 4327 | 44 |
2402501 | 2402501 | 2022-04-13 | De Witt | Illinois | 17039 | 4327 | 44 |
2392514 | 2392514 | 2022-04-10 | Ben Hill | Georgia | 13017 | 4327 | 122 |
2389258 | 2389258 | 2022-04-09 | Ben Hill | Georgia | 13017 | 4327 | 122 |
2386003 | 2386003 | 2022-04-08 | Ben Hill | Georgia | 13017 | 4327 | 122 |
2388375 | 2388375 | 2022-04-08 | Lamb | Texas | 48279 | 4327 | 122 |
2347677 | 2347677 | 2022-03-27 | Union | Kentucky | 21225 | 4327 | 55 |
2344424 | 2344424 | 2022-03-26 | Union | Kentucky | 21225 | 4327 | 55 |
2341171 | 2341171 | 2022-03-25 | Union | Kentucky | 21225 | 4327 | 55 |
2337918 | 2337918 | 2022-03-24 | Union | Kentucky | 21225 | 4327 | 55 |
2334664 | 2334664 | 2022-03-23 | Union | Kentucky | 21225 | 4327 | 55 |
2331410 | 2331410 | 2022-03-22 | Union | Kentucky | 21225 | 4327 | 55 |
2328158 | 2328158 | 2022-03-21 | Union | Kentucky | 21225 | 4327 | 55 |
2243030 | 2243030 | 2022-02-23 | Washington | Georgia | 13303 | 4327 | 132 |
2239779 | 2239779 | 2022-02-22 | Washington | Georgia | 13303 | 4327 | 132 |
2221127 | 2221127 | 2022-02-16 | Roseau | Minnesota | 27135 | 4327 | 43 |
2211419 | 2211419 | 2022-02-13 | Holmes | Mississippi | 28051 | 4327 | 103 |
2208166 | 2208166 | 2022-02-12 | Holmes | Mississippi | 28051 | 4327 | 103 |
2204913 | 2204913 | 2022-02-11 | Holmes | Mississippi | 28051 | 4327 | 103 |
2180360 | 2180360 | 2022-02-03 | Caledonia | Vermont | 50005 | 4327 | 22 |
2169296 | 2169296 | 2022-01-31 | Texas | Missouri | 29215 | 4327 | 79 |
2165200 | 2165200 | 2022-01-30 | Perry | Indiana | 18123 | 4327 | 61 |
2161945 | 2161945 | 2022-01-29 | Perry | Indiana | 18123 | 4327 | 61 |
2158690 | 2158690 | 2022-01-28 | Perry | Indiana | 18123 | 4327 | 61 |
2160750 | 2160750 | 2022-01-28 | Robertson | Texas | 48395 | 4327 | 70 |
2157799 | 2157799 | 2022-01-27 | McDowell | West Virginia | 54047 | 4327 | 57 |
2148659 | 2148659 | 2022-01-25 | Morgan | Georgia | 13211 | 4327 | 52 |
2145994 | 2145994 | 2022-01-24 | McCreary | Kentucky | 21147 | 4327 | 68 |
2134889 | 2134889 | 2022-01-20 | King George | Virginia | 51099 | 4327 | 27 |
2128309 | 2128309 | 2022-01-18 | Orleans | Vermont | 50019 | 4327 | 31 |
2087668 | 2087668 | 2022-01-06 | Menominee | Michigan | 26109 | 4327 | 62 |
2084416 | 2084416 | 2022-01-05 | Menominee | Michigan | 26109 | 4327 | 62 |
2074578 | 2074578 | 2022-01-02 | Garrett | Maryland | 24023 | 4327 | 98 |
2006567 | 2006567 | 2021-12-12 | Marion | Mississippi | 28091 | 4327 | 112 |
2003316 | 2003316 | 2021-12-11 | Marion | Mississippi | 28091 | 4327 | 112 |
2000066 | 2000066 | 2021-12-10 | Marion | Mississippi | 28091 | 4327 | 112 |
1930927 | 1930927 | 2021-11-19 | Jerome | Idaho | 16053 | 4327 | 53 |
1927677 | 1927677 | 2021-11-18 | Jerome | Idaho | 16053 | 4327 | 53 |
1901214 | 1901214 | 2021-11-10 | Carroll | Arkansas | 5015 | 4327 | 75 |
1891210 | 1891210 | 2021-11-06 | Hancock | West Virginia | 54029 | 4327 | 116 |
1887608 | 1887608 | 2021-11-05 | Kleberg | Texas | 48273 | 4327 | 129 |
1879143 | 1879143 | 2021-11-03 | White | Indiana | 18181 | 4327 | 67 |
1880442 | 1880442 | 2021-11-03 | Hardin | Ohio | 39065 | 4327 | 87 |
1875893 | 1875893 | 2021-11-02 | Wells | Indiana | 18179 | 4327 | 91 |
1849145 | 1849145 | 2021-10-25 | Lawrence | Alabama | 1079 | 4327 | 117 |
1851664 | 1851664 | 2021-10-25 | Grainger | Tennessee | 47057 | 4327 | 66 |
1848414 | 1848414 | 2021-10-24 | Grainger | Tennessee | 47057 | 4327 | 66 |
1845164 | 1845164 | 2021-10-23 | Grainger | Tennessee | 47057 | 4327 | 66 |
1841914 | 1841914 | 2021-10-22 | Grainger | Tennessee | 47057 | 4327 | 66 |
1838235 | 1838235 | 2021-10-21 | Pike | Ohio | 39131 | 4327 | 63 |
1824067 | 1824067 | 2021-10-17 | McPherson | Kansas | 20113 | 4327 | 93 |
1820818 | 1820818 | 2021-10-16 | McPherson | Kansas | 20113 | 4327 | 93 |
1817569 | 1817569 | 2021-10-15 | McPherson | Kansas | 20113 | 4327 | 93 |
1796528 | 1796528 | 2021-10-08 | Cass | Texas | 48067 | 4327 | 130 |
1782058 | 1782058 | 2021-10-04 | West Baton Rouge | Louisiana | 22121 | 4327 | 71 |
1759272 | 1759272 | 2021-09-27 | Franklin | Louisiana | 22041 | 4327 | 134 |
1743370 | 1743370 | 2021-09-22 | Tate | Mississippi | 28137 | 4327 | 101 |
1741043 | 1741043 | 2021-09-21 | Vega Baja | Puerto Rico | 72145 | 4327 | |
1735534 | 1735534 | 2021-09-20 | Johnson | Arkansas | 5071 | 4327 | 55 |
1673686 | 1673686 | 2021-09-01 | Dallas | Alabama | 1047 | 4327 | 168 |
1628815 | 1628815 | 2021-08-18 | Fulton | Illinois | 17057 | 4327 | 69 |
1620911 | 1620911 | 2021-08-15 | Brookings | South Dakota | 46011 | 4327 | 37 |
1617663 | 1617663 | 2021-08-14 | Brookings | South Dakota | 46011 | 4327 | 37 |
1614415 | 1614415 | 2021-08-13 | Brookings | South Dakota | 46011 | 4327 | 37 |
1608422 | 1608422 | 2021-08-11 | Franklin | Virginia | 51067 | 4327 | 83 |
1581703 | 1581703 | 2021-08-03 | Josephine | Oregon | 41033 | 4327 | 76 |
1561511 | 1561511 | 2021-07-28 | Howell | Missouri | 29091 | 4327 | 50 |
1558939 | 1558939 | 2021-07-27 | Sequoyah | Oklahoma | 40135 | 4327 | 57 |
1555692 | 1555692 | 2021-07-26 | Sequoyah | Oklahoma | 40135 | 4327 | 57 |
1552445 | 1552445 | 2021-07-25 | Sequoyah | Oklahoma | 40135 | 4327 | 57 |
1549198 | 1549198 | 2021-07-24 | Sequoyah | Oklahoma | 40135 | 4327 | 57 |
1545951 | 1545951 | 2021-07-23 | Sequoyah | Oklahoma | 40135 | 4327 | 57 |
1542704 | 1542704 | 2021-07-22 | Sequoyah | Oklahoma | 40135 | 4327 | 57 |
1539456 | 1539456 | 2021-07-21 | Sequoyah | Oklahoma | 40135 | 4327 | 57 |
1540241 | 1540241 | 2021-07-21 | Manassas city | Virginia | 51683 | 4327 | 48 |
1509385 | 1509385 | 2021-07-12 | McLeod | Minnesota | 27085 | 4327 | 61 |
1506139 | 1506139 | 2021-07-11 | McLeod | Minnesota | 27085 | 4327 | 61 |
1502893 | 1502893 | 2021-07-10 | McLeod | Minnesota | 27085 | 4327 | 61 |
1499647 | 1499647 | 2021-07-09 | McLeod | Minnesota | 27085 | 4327 | 61 |
1496401 | 1496401 | 2021-07-08 | McLeod | Minnesota | 27085 | 4327 | 61 |
1493862 | 1493862 | 2021-07-07 | Defiance | Ohio | 39039 | 4327 | 99 |
1484127 | 1484127 | 2021-07-04 | Fulton | Ohio | 39051 | 4327 | 75 |
1480881 | 1480881 | 2021-07-03 | Fulton | Ohio | 39051 | 4327 | 75 |
1477634 | 1477634 | 2021-07-02 | Fulton | Ohio | 39051 | 4327 | 75 |
1474388 | 1474388 | 2021-07-01 | Fulton | Ohio | 39051 | 4327 | 75 |
1471142 | 1471142 | 2021-06-30 | Fulton | Ohio | 39051 | 4327 | 75 |
1405272 | 1405272 | 2021-06-10 | Avoyelles | Louisiana | 22009 | 4327 | 123 |
1401659 | 1401659 | 2021-06-09 | Montgomery | Indiana | 18107 | 4327 | 92 |
1379070 | 1379070 | 2021-06-02 | Wapello | Iowa | 19179 | 4327 | 122 |
1364083 | 1364083 | 2021-05-28 | Putnam | Ohio | 39137 | 4327 | 103 |
1358558 | 1358558 | 2021-05-26 | Whitman | Washington | 53075 | 4327 | 49 |
1316110 | 1316110 | 2021-05-13 | Van Zandt | Texas | 48467 | 4327 | 117 |
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);