ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
173 rows where cases = 2885 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Alabama 16
- Oklahoma 15
- Kentucky 12
- Missouri 10
- Ohio 9
- Michigan 8
- Texas 7
- West Virginia 7
- Georgia 6
- Kansas 6
- Tennessee 6
- Wisconsin 6
- Illinois 5
- North Carolina 5
- Puerto Rico 5
- Indiana 4
- Louisiana 4
- Minnesota 4
- New York 4
- Virginia 4
- Arkansas 3
- Florida 3
- Idaho 3
- Nebraska 3
- South Carolina 3
- California 2
- Colorado 2
- Mississippi 2
- South Dakota 2
- Connecticut 1
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2498693 | 2498693 | 2022-05-12 | Jayuya | Puerto Rico | 72073 | 2885 | |
2453381 | 2453381 | 2022-04-28 | Callahan | Texas | 48059 | 2885 | 72 |
2418225 | 2418225 | 2022-04-18 | Wilcox | Alabama | 1131 | 2885 | 46 |
2414969 | 2414969 | 2022-04-17 | Wilcox | Alabama | 1131 | 2885 | 46 |
2411713 | 2411713 | 2022-04-16 | Wilcox | Alabama | 1131 | 2885 | 46 |
2408457 | 2408457 | 2022-04-15 | Wilcox | Alabama | 1131 | 2885 | 46 |
2405201 | 2405201 | 2022-04-14 | Wilcox | Alabama | 1131 | 2885 | 46 |
2401946 | 2401946 | 2022-04-13 | Wilcox | Alabama | 1131 | 2885 | 46 |
2398691 | 2398691 | 2022-04-12 | Wilcox | Alabama | 1131 | 2885 | 46 |
2395436 | 2395436 | 2022-04-11 | Wilcox | Alabama | 1131 | 2885 | 46 |
2392180 | 2392180 | 2022-04-10 | Wilcox | Alabama | 1131 | 2885 | 46 |
2388924 | 2388924 | 2022-04-09 | Wilcox | Alabama | 1131 | 2885 | 46 |
2385669 | 2385669 | 2022-04-08 | Wilcox | Alabama | 1131 | 2885 | 46 |
2382414 | 2382414 | 2022-04-07 | Wilcox | Alabama | 1131 | 2885 | 46 |
2379410 | 2379410 | 2022-04-06 | Unknown | Connecticut | 2885 | 1 | |
2333193 | 2333193 | 2022-03-22 | Morgan | Utah | 49029 | 2885 | 14 |
2269506 | 2269506 | 2022-03-03 | Bath | Kentucky | 21011 | 2885 | 38 |
2269565 | 2269565 | 2022-03-03 | Lee | Kentucky | 21129 | 2885 | 46 |
2269799 | 2269799 | 2022-03-03 | Missaukee | Michigan | 26113 | 2885 | 58 |
2266546 | 2266546 | 2022-03-02 | Missaukee | Michigan | 26113 | 2885 | 58 |
2267393 | 2267393 | 2022-03-02 | Vinton | Ohio | 39163 | 2885 | 55 |
2263106 | 2263106 | 2022-03-01 | Todd | Kentucky | 21219 | 2885 | 42 |
2174311 | 2174311 | 2022-02-02 | Bradley | Arkansas | 5011 | 2885 | 43 |
2167239 | 2167239 | 2022-01-30 | Nolan | Texas | 48353 | 2885 | 89 |
2150507 | 2150507 | 2022-01-25 | Barceloneta | Puerto Rico | 72017 | 2885 | |
2147255 | 2147255 | 2022-01-24 | Barceloneta | Puerto Rico | 72017 | 2885 | |
2141323 | 2141323 | 2022-01-22 | Lamoille | Vermont | 50015 | 2885 | 12 |
2128913 | 2128913 | 2022-01-19 | Gunnison | Colorado | 8051 | 2885 | 13 |
2125425 | 2125425 | 2022-01-18 | Lamar | Alabama | 1075 | 2885 | 60 |
2106540 | 2106540 | 2022-01-12 | Massac | Illinois | 17127 | 2885 | 64 |
2102897 | 2102897 | 2022-01-11 | Grand | Colorado | 8049 | 2885 | 20 |
2088074 | 2088074 | 2022-01-06 | Gage | Nebraska | 31067 | 2885 | 33 |
2080066 | 2080066 | 2022-01-04 | Inyo | California | 6027 | 2885 | 49 |
2078172 | 2078172 | 2022-01-03 | Livingston | Missouri | 29117 | 2885 | 81 |
1994842 | 1994842 | 2021-12-08 | Houston | Texas | 48225 | 2885 | 88 |
1975594 | 1975594 | 2021-12-02 | King George | Virginia | 51099 | 2885 | 24 |
1960180 | 1960180 | 2021-11-28 | Gem | Idaho | 16045 | 2885 | 68 |
1956929 | 1956929 | 2021-11-27 | Gem | Idaho | 16045 | 2885 | 68 |
1953678 | 1953678 | 2021-11-26 | Gem | Idaho | 16045 | 2885 | 68 |
1938368 | 1938368 | 2021-11-21 | Cooper | Missouri | 29053 | 2885 | 51 |
1938795 | 1938795 | 2021-11-21 | Hertford | North Carolina | 37091 | 2885 | 72 |
1935118 | 1935118 | 2021-11-20 | Cooper | Missouri | 29053 | 2885 | 51 |
1935545 | 1935545 | 2021-11-20 | Hertford | North Carolina | 37091 | 2885 | 72 |
1932295 | 1932295 | 2021-11-19 | Hertford | North Carolina | 37091 | 2885 | 72 |
1915593 | 1915593 | 2021-11-14 | Andrew | Missouri | 29003 | 2885 | 24 |
1912343 | 1912343 | 2021-11-13 | Andrew | Missouri | 29003 | 2885 | 24 |
1877223 | 1877223 | 2021-11-02 | Paulding | Ohio | 39125 | 2885 | 47 |
1848886 | 1848886 | 2021-10-24 | Radford city | Virginia | 51750 | 2885 | 31 |
1845636 | 1845636 | 2021-10-23 | Radford city | Virginia | 51750 | 2885 | 31 |
1842386 | 1842386 | 2021-10-22 | Radford city | Virginia | 51750 | 2885 | 31 |
1808115 | 1808115 | 2021-10-12 | Alpena | Michigan | 26007 | 2885 | 69 |
1804864 | 1804864 | 2021-10-11 | Alpena | Michigan | 26007 | 2885 | 69 |
1803545 | 1803545 | 2021-10-10 | Green Lake | Wisconsin | 55047 | 2885 | 29 |
1800296 | 1800296 | 2021-10-09 | Green Lake | Wisconsin | 55047 | 2885 | 29 |
1797047 | 1797047 | 2021-10-08 | Green Lake | Wisconsin | 55047 | 2885 | 29 |
1790589 | 1790589 | 2021-10-06 | Vilas | Wisconsin | 55125 | 2885 | 50 |
1778894 | 1778894 | 2021-10-03 | Gladwin | Michigan | 26051 | 2885 | 66 |
1775644 | 1775644 | 2021-10-02 | Gladwin | Michigan | 26051 | 2885 | 66 |
1772394 | 1772394 | 2021-10-01 | Gladwin | Michigan | 26051 | 2885 | 66 |
1762481 | 1762481 | 2021-09-28 | Rockcastle | Kentucky | 21203 | 2885 | 25 |
1758619 | 1758619 | 2021-09-27 | Meriwether | Georgia | 13199 | 2885 | 100 |
1759736 | 1759736 | 2021-09-27 | Texas | Missouri | 29215 | 2885 | 40 |
1756488 | 1756488 | 2021-09-26 | Texas | Missouri | 29215 | 2885 | 40 |
1719174 | 1719174 | 2021-09-15 | Henry | Alabama | 1067 | 2885 | 50 |
1694940 | 1694940 | 2021-09-07 | Carroll | New Hampshire | 33003 | 2885 | 16 |
1674665 | 1674665 | 2021-09-01 | Allen | Kentucky | 21003 | 2885 | 48 |
1671787 | 1671787 | 2021-08-31 | Meeker | Minnesota | 27093 | 2885 | 46 |
1670350 | 1670350 | 2021-08-30 | Kewaunee | Wisconsin | 55061 | 2885 | 37 |
1629665 | 1629665 | 2021-08-18 | Stone | Mississippi | 28131 | 2885 | 38 |
1621572 | 1621572 | 2021-08-15 | Mingo | West Virginia | 54059 | 2885 | 45 |
1618324 | 1618324 | 2021-08-14 | Mingo | West Virginia | 54059 | 2885 | 45 |
1615076 | 1615076 | 2021-08-13 | Mingo | West Virginia | 54059 | 2885 | 45 |
1611827 | 1611827 | 2021-08-12 | Mingo | West Virginia | 54059 | 2885 | 45 |
1607320 | 1607320 | 2021-08-11 | Lewis | New York | 36049 | 2885 | 36 |
1598062 | 1598062 | 2021-08-08 | Dorado | Puerto Rico | 72051 | 2885 | |
1591920 | 1591920 | 2021-08-06 | Gonzales | Texas | 48177 | 2885 | 59 |
1592002 | 1592002 | 2021-08-06 | Moore | Texas | 48341 | 2885 | 75 |
1582572 | 1582572 | 2021-08-03 | Hancock | West Virginia | 54029 | 2885 | 90 |
1538326 | 1538326 | 2021-07-21 | Montgomery | Kentucky | 21173 | 2885 | 30 |
1509155 | 1509155 | 2021-07-12 | Franklin | Louisiana | 22041 | 2885 | 107 |
1473035 | 1473035 | 2021-07-01 | Greene | Indiana | 18055 | 2885 | 89 |
1468027 | 1468027 | 2021-06-29 | Seminole | Oklahoma | 40133 | 2885 | 78 |
1464782 | 1464782 | 2021-06-28 | Seminole | Oklahoma | 40133 | 2885 | 78 |
1461537 | 1461537 | 2021-06-27 | Seminole | Oklahoma | 40133 | 2885 | 78 |
1458292 | 1458292 | 2021-06-26 | Seminole | Oklahoma | 40133 | 2885 | 78 |
1455047 | 1455047 | 2021-06-25 | Seminole | Oklahoma | 40133 | 2885 | 78 |
1451802 | 1451802 | 2021-06-24 | Seminole | Oklahoma | 40133 | 2885 | 78 |
1448556 | 1448556 | 2021-06-23 | Seminole | Oklahoma | 40133 | 2885 | 78 |
1445311 | 1445311 | 2021-06-22 | Seminole | Oklahoma | 40133 | 2885 | 78 |
1442066 | 1442066 | 2021-06-21 | Seminole | Oklahoma | 40133 | 2885 | 78 |
1438821 | 1438821 | 2021-06-20 | Seminole | Oklahoma | 40133 | 2885 | 78 |
1435574 | 1435574 | 2021-06-19 | Seminole | Oklahoma | 40133 | 2885 | 78 |
1432327 | 1432327 | 2021-06-18 | Seminole | Oklahoma | 40133 | 2885 | 78 |
1429081 | 1429081 | 2021-06-17 | Seminole | Oklahoma | 40133 | 2885 | 78 |
1425836 | 1425836 | 2021-06-16 | Seminole | Oklahoma | 40133 | 2885 | 78 |
1419695 | 1419695 | 2021-06-14 | Hickman | Tennessee | 47081 | 2885 | 47 |
1416450 | 1416450 | 2021-06-13 | Hickman | Tennessee | 47081 | 2885 | 47 |
1413204 | 1413204 | 2021-06-12 | Hickman | Tennessee | 47081 | 2885 | 47 |
1409959 | 1409959 | 2021-06-11 | Hickman | Tennessee | 47081 | 2885 | 47 |
1392236 | 1392236 | 2021-06-06 | Logan | Kentucky | 21141 | 2885 | 70 |
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);