ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
118 rows where cases = 5016 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- North Carolina 10
- Alabama 9
- Michigan 8
- Tennessee 8
- Iowa 7
- Ohio 6
- Oregon 6
- Virginia 6
- Kentucky 5
- Texas 5
- Minnesota 4
- Missouri 4
- Nebraska 4
- South Carolina 4
- Wisconsin 4
- Illinois 3
- New Hampshire 3
- Arkansas 2
- Indiana 2
- Nevada 2
- New Mexico 2
- North Dakota 2
- Pennsylvania 2
- Alaska 1
- California 1
- Colorado 1
- District of Columbia 1
- Florida 1
- Idaho 1
- Maryland 1
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2485082 | 2485082 | 2022-05-08 | Unknown | New Hampshire | 5016 | 2 | |
2481824 | 2481824 | 2022-05-07 | Unknown | New Hampshire | 5016 | 2 | |
2478566 | 2478566 | 2022-05-06 | Unknown | New Hampshire | 5016 | 2 | |
2472912 | 2472912 | 2022-05-04 | Burleson | Texas | 48051 | 5016 | 66 |
2468840 | 2468840 | 2022-05-03 | Roosevelt | New Mexico | 35041 | 5016 | 95 |
2449215 | 2449215 | 2022-04-27 | Saunders | Nebraska | 31155 | 5016 | 30 |
2445520 | 2445520 | 2022-04-26 | Osceola | Michigan | 26133 | 5016 | 80 |
2445958 | 2445958 | 2022-04-26 | Saunders | Nebraska | 31155 | 5016 | 30 |
2442264 | 2442264 | 2022-04-25 | Osceola | Michigan | 26133 | 5016 | 80 |
2439008 | 2439008 | 2022-04-24 | Osceola | Michigan | 26133 | 5016 | 80 |
2435752 | 2435752 | 2022-04-23 | Osceola | Michigan | 26133 | 5016 | 80 |
2432496 | 2432496 | 2022-04-22 | Osceola | Michigan | 26133 | 5016 | 80 |
2429240 | 2429240 | 2022-04-21 | Osceola | Michigan | 26133 | 5016 | 80 |
2425984 | 2425984 | 2022-04-20 | Osceola | Michigan | 26133 | 5016 | 80 |
2427782 | 2427782 | 2022-04-20 | Brooke | West Virginia | 54009 | 5016 | 104 |
2400635 | 2400635 | 2022-04-12 | Yancey | North Carolina | 37199 | 5016 | 51 |
2397380 | 2397380 | 2022-04-11 | Yancey | North Carolina | 37199 | 5016 | 51 |
2394125 | 2394125 | 2022-04-10 | Yancey | North Carolina | 37199 | 5016 | 51 |
2390869 | 2390869 | 2022-04-09 | Yancey | North Carolina | 37199 | 5016 | 51 |
2387613 | 2387613 | 2022-04-08 | Yancey | North Carolina | 37199 | 5016 | 51 |
2384358 | 2384358 | 2022-04-07 | Yancey | North Carolina | 37199 | 5016 | 51 |
2381103 | 2381103 | 2022-04-06 | Yancey | North Carolina | 37199 | 5016 | 51 |
2371598 | 2371598 | 2022-04-03 | Union | Oregon | 41061 | 5016 | 76 |
2368345 | 2368345 | 2022-04-02 | Union | Oregon | 41061 | 5016 | 76 |
2365092 | 2365092 | 2022-04-01 | Union | Oregon | 41061 | 5016 | 76 |
2361839 | 2361839 | 2022-03-31 | Union | Oregon | 41061 | 5016 | 76 |
2358585 | 2358585 | 2022-03-30 | Union | Oregon | 41061 | 5016 | 76 |
2355331 | 2355331 | 2022-03-29 | Union | Oregon | 41061 | 5016 | 75 |
2351564 | 2351564 | 2022-03-28 | Saunders | Nebraska | 31155 | 5016 | 29 |
2347239 | 2347239 | 2022-03-27 | Pike | Illinois | 17149 | 5016 | 68 |
2343986 | 2343986 | 2022-03-26 | Pike | Illinois | 17149 | 5016 | 68 |
2340733 | 2340733 | 2022-03-25 | Pike | Illinois | 17149 | 5016 | 68 |
2226382 | 2226382 | 2022-02-18 | Lawrence | Arkansas | 5075 | 5016 | 68 |
2216535 | 2216535 | 2022-02-15 | Pickens | Alabama | 1107 | 5016 | 95 |
2210033 | 2210033 | 2022-02-13 | Randolph | Alabama | 1111 | 5016 | 72 |
2206780 | 2206780 | 2022-02-12 | Randolph | Alabama | 1111 | 5016 | 72 |
2200803 | 2200803 | 2022-02-10 | Jerome | Idaho | 16053 | 5016 | 60 |
2173998 | 2173998 | 2022-02-01 | Waynesboro city | Virginia | 51820 | 5016 | 55 |
2174132 | 2174132 | 2022-02-01 | Langlade | Wisconsin | 55067 | 5016 | 73 |
2169096 | 2169096 | 2022-01-31 | Wabasha | Minnesota | 27157 | 5016 | 14 |
2098784 | 2098784 | 2022-01-09 | Cass | Texas | 48067 | 5016 | 163 |
1997046 | 1997046 | 2021-12-09 | Dakota | Nebraska | 31043 | 5016 | 82 |
1970906 | 1970906 | 2021-12-01 | Lafayette | Missouri | 29107 | 5016 | 87 |
1941469 | 1941469 | 2021-11-22 | Mille Lacs | Minnesota | 27095 | 5016 | 71 |
1894650 | 1894650 | 2021-11-08 | Pike | Alabama | 1109 | 5016 | 108 |
1891400 | 1891400 | 2021-11-07 | Pike | Alabama | 1109 | 5016 | 108 |
1888150 | 1888150 | 2021-11-06 | Pike | Alabama | 1109 | 5016 | 108 |
1884900 | 1884900 | 2021-11-05 | Pike | Alabama | 1109 | 5016 | 107 |
1873686 | 1873686 | 2021-11-01 | Rio Arriba | New Mexico | 35039 | 5016 | 85 |
1858908 | 1858908 | 2021-10-28 | Pike | Alabama | 1109 | 5016 | 106 |
1860463 | 1860463 | 2021-10-28 | Warren | Missouri | 29219 | 5016 | 47 |
1852402 | 1852402 | 2021-10-26 | Marion | Alabama | 1093 | 5016 | 127 |
1853433 | 1853433 | 2021-10-26 | Marshall | Kentucky | 21157 | 5016 | 78 |
1855258 | 1855258 | 2021-10-26 | Uintah | Utah | 49047 | 5016 | 43 |
1739524 | 1739524 | 2021-09-21 | Wapello | Iowa | 19179 | 5016 | 128 |
1736275 | 1736275 | 2021-09-20 | Wapello | Iowa | 19179 | 5016 | 128 |
1733025 | 1733025 | 2021-09-19 | Wapello | Iowa | 19179 | 5016 | 128 |
1729775 | 1729775 | 2021-09-18 | Wapello | Iowa | 19179 | 5016 | 128 |
1726525 | 1726525 | 2021-09-17 | Wapello | Iowa | 19179 | 5016 | 128 |
1723276 | 1723276 | 2021-09-16 | Wapello | Iowa | 19179 | 5016 | 128 |
1720027 | 1720027 | 2021-09-15 | Wapello | Iowa | 19179 | 5016 | 128 |
1714731 | 1714731 | 2021-09-13 | Fulton | Ohio | 39051 | 5016 | 81 |
1711982 | 1711982 | 2021-09-12 | Marion | Tennessee | 47115 | 5016 | 51 |
1708735 | 1708735 | 2021-09-11 | Marion | Tennessee | 47115 | 5016 | 51 |
1705488 | 1705488 | 2021-09-10 | Marion | Tennessee | 47115 | 5016 | 51 |
1696006 | 1696006 | 2021-09-07 | Titus | Texas | 48449 | 5016 | 89 |
1676196 | 1676196 | 2021-09-01 | Campbell | Tennessee | 47013 | 5016 | 66 |
1620559 | 1620559 | 2021-08-15 | Mercer | Ohio | 39107 | 5016 | 85 |
1598672 | 1598672 | 2021-08-08 | Fauquier | Virginia | 51061 | 5016 | 70 |
1595423 | 1595423 | 2021-08-07 | Fauquier | Virginia | 51061 | 5016 | 70 |
1592174 | 1592174 | 2021-08-06 | Fauquier | Virginia | 51061 | 5016 | 70 |
1553428 | 1553428 | 2021-07-25 | Pierce | Wisconsin | 55093 | 5016 | 44 |
1550181 | 1550181 | 2021-07-24 | Pierce | Wisconsin | 55093 | 5016 | 44 |
1546934 | 1546934 | 2021-07-23 | Pierce | Wisconsin | 55093 | 5016 | 44 |
1522549 | 1522549 | 2021-07-16 | Johnson | Missouri | 29101 | 5016 | 59 |
1520699 | 1520699 | 2021-07-15 | Campbell | Virginia | 51031 | 5016 | 103 |
1465363 | 1465363 | 2021-06-28 | Nacogdoches | Texas | 48347 | 5016 | 173 |
1460413 | 1460413 | 2021-06-27 | Nelson | Kentucky | 21179 | 5016 | 61 |
1457168 | 1457168 | 2021-06-26 | Nelson | Kentucky | 21179 | 5016 | 61 |
1453923 | 1453923 | 2021-06-25 | Nelson | Kentucky | 21179 | 5016 | 61 |
1441908 | 1441908 | 2021-06-21 | Williams | North Dakota | 38105 | 5016 | 40 |
1438663 | 1438663 | 2021-06-20 | Williams | North Dakota | 38105 | 5016 | 40 |
1422439 | 1422439 | 2021-06-15 | Auglaize | Ohio | 39011 | 5016 | 87 |
1419193 | 1419193 | 2021-06-14 | Auglaize | Ohio | 39011 | 5016 | 87 |
1373202 | 1373202 | 2021-05-31 | Callaway | Missouri | 29027 | 5016 | 50 |
1329725 | 1329725 | 2021-05-18 | Tehama | California | 6103 | 5016 | 63 |
1330592 | 1330592 | 2021-05-18 | Scott | Kentucky | 21209 | 5016 | 33 |
1315704 | 1315704 | 2021-05-13 | Newberry | South Carolina | 45071 | 5016 | 104 |
1309546 | 1309546 | 2021-05-11 | Medina | Texas | 48325 | 5016 | 103 |
1236588 | 1236588 | 2021-04-19 | Cass | Michigan | 26027 | 5016 | 72 |
1196496 | 1196496 | 2021-04-07 | Hot Spring | Arkansas | 5059 | 5016 | 71 |
1198502 | 1198502 | 2021-04-07 | Washington | Ohio | 39167 | 5016 | 105 |
1195390 | 1195390 | 2021-04-06 | Columbia | Pennsylvania | 42037 | 5016 | 129 |
1172313 | 1172313 | 2021-03-30 | Edgecombe | North Carolina | 37065 | 5016 | 102 |
1156100 | 1156100 | 2021-03-25 | McDowell | North Carolina | 37111 | 5016 | 63 |
1087906 | 1087906 | 2021-03-04 | Halifax | North Carolina | 37083 | 5016 | 97 |
1074188 | 1074188 | 2021-02-28 | Cecil | Maryland | 24015 | 5016 | 120 |
1065320 | 1065320 | 2021-02-25 | Darke | Ohio | 39037 | 5016 | 123 |
1034791 | 1034791 | 2021-02-16 | Noble | Indiana | 18113 | 5016 | 78 |
1007287 | 1007287 | 2021-02-07 | Brown | South Dakota | 46013 | 5016 | 79 |
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);