ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
125 rows where cases = 4722 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Alabama 14
- Iowa 9
- Kentucky 8
- North Carolina 8
- Rhode Island 8
- Tennessee 8
- Texas 8
- Wisconsin 8
- Indiana 7
- Minnesota 6
- Georgia 5
- Virginia 5
- Missouri 4
- Ohio 4
- Pennsylvania 3
- Puerto Rico 3
- South Carolina 3
- Arizona 1
- Arkansas 1
- California 1
- Colorado 1
- Florida 1
- Idaho 1
- Illinois 1
- Kansas 1
- Michigan 1
- New York 1
- North Dakota 1
- Oklahoma 1
- Washington 1
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2493312 | 2493312 | 2022-05-11 | Chaffee | Colorado | 8015 | 4722 | 47 |
2446927 | 2446927 | 2022-04-26 | Gonzales | Texas | 48177 | 4722 | 98 |
2427960 | 2427960 | 2022-04-21 | Hale | Alabama | 1065 | 4722 | 106 |
2424704 | 2424704 | 2022-04-20 | Hale | Alabama | 1065 | 4722 | 106 |
2421448 | 2421448 | 2022-04-19 | Hale | Alabama | 1065 | 4722 | 106 |
2418192 | 2418192 | 2022-04-18 | Hale | Alabama | 1065 | 4722 | 106 |
2414936 | 2414936 | 2022-04-17 | Hale | Alabama | 1065 | 4722 | 106 |
2411680 | 2411680 | 2022-04-16 | Hale | Alabama | 1065 | 4722 | 106 |
2408424 | 2408424 | 2022-04-15 | Hale | Alabama | 1065 | 4722 | 106 |
2355670 | 2355670 | 2022-03-29 | Polk | Tennessee | 47139 | 4722 | 70 |
2352417 | 2352417 | 2022-03-28 | Polk | Tennessee | 47139 | 4722 | 70 |
2349165 | 2349165 | 2022-03-27 | Polk | Tennessee | 47139 | 4722 | 70 |
2345912 | 2345912 | 2022-03-26 | Polk | Tennessee | 47139 | 4722 | 70 |
2342659 | 2342659 | 2022-03-25 | Polk | Tennessee | 47139 | 4722 | 70 |
2339406 | 2339406 | 2022-03-24 | Polk | Tennessee | 47139 | 4722 | 70 |
2336152 | 2336152 | 2022-03-23 | Polk | Tennessee | 47139 | 4722 | 70 |
2301800 | 2301800 | 2022-03-13 | Starke | Indiana | 18149 | 4722 | 94 |
2298548 | 2298548 | 2022-03-12 | Starke | Indiana | 18149 | 4722 | 94 |
2295296 | 2295296 | 2022-03-11 | Starke | Indiana | 18149 | 4722 | 94 |
2241170 | 2241170 | 2022-02-22 | Currituck | North Carolina | 37053 | 4722 | 32 |
2169297 | 2169297 | 2022-01-31 | Vernon | Missouri | 29217 | 4722 | 93 |
2159512 | 2159512 | 2022-01-28 | Ray | Missouri | 29177 | 4722 | 81 |
2145497 | 2145497 | 2022-01-24 | Jerome | Idaho | 16053 | 4722 | 58 |
2114732 | 2114732 | 2022-01-14 | Cayey | Puerto Rico | 72035 | 4722 | |
2100480 | 2100480 | 2022-01-10 | Rowan | Kentucky | 21205 | 4722 | 47 |
2089594 | 2089594 | 2022-01-06 | Waushara | Wisconsin | 55137 | 4722 | 74 |
2063307 | 2063307 | 2021-12-29 | Caroline | Virginia | 51033 | 4722 | 58 |
2057141 | 2057141 | 2021-12-28 | Geneva | Alabama | 1061 | 4722 | 137 |
2010697 | 2010697 | 2021-12-13 | Arecibo | Puerto Rico | 72013 | 4722 | |
2011348 | 2011348 | 2021-12-13 | Isle of Wight | Virginia | 51093 | 4722 | 93 |
2007446 | 2007446 | 2021-12-12 | Arecibo | Puerto Rico | 72013 | 4722 | |
1960688 | 1960688 | 2021-11-28 | Montgomery | Kentucky | 21173 | 4722 | 61 |
1957437 | 1957437 | 2021-11-27 | Montgomery | Kentucky | 21173 | 4722 | 61 |
1954186 | 1954186 | 2021-11-26 | Montgomery | Kentucky | 21173 | 4722 | 61 |
1950935 | 1950935 | 2021-11-25 | Montgomery | Kentucky | 21173 | 4722 | 61 |
1947684 | 1947684 | 2021-11-24 | Montgomery | Kentucky | 21173 | 4722 | 61 |
1948885 | 1948885 | 2021-11-24 | Elk | Pennsylvania | 42047 | 4722 | 65 |
1942664 | 1942664 | 2021-11-22 | Hickman | Tennessee | 47081 | 4722 | 78 |
1914280 | 1914280 | 2021-11-14 | Yell | Arkansas | 5149 | 4722 | 80 |
1857924 | 1857924 | 2021-10-27 | Snyder | Pennsylvania | 42109 | 4722 | 103 |
1849642 | 1849642 | 2021-10-25 | Unknown | Georgia | 4722 | 9 | |
1836162 | 1836162 | 2021-10-21 | Pike | Alabama | 1109 | 4722 | 105 |
1832913 | 1832913 | 2021-10-20 | Pike | Alabama | 1109 | 4722 | 105 |
1829664 | 1829664 | 2021-10-19 | Pike | Alabama | 1109 | 4722 | 105 |
1806880 | 1806880 | 2021-10-12 | Clarke | Alabama | 1025 | 4722 | 80 |
1803583 | 1803583 | 2021-10-10 | Trempealeau | Wisconsin | 55121 | 4722 | 52 |
1800334 | 1800334 | 2021-10-09 | Trempealeau | Wisconsin | 55121 | 4722 | 52 |
1797085 | 1797085 | 2021-10-08 | Trempealeau | Wisconsin | 55121 | 4722 | 52 |
1691281 | 1691281 | 2021-09-06 | McLeod | Minnesota | 27085 | 4722 | 61 |
1688031 | 1688031 | 2021-09-05 | McLeod | Minnesota | 27085 | 4722 | 61 |
1684781 | 1684781 | 2021-09-04 | McLeod | Minnesota | 27085 | 4722 | 61 |
1681530 | 1681530 | 2021-09-03 | McLeod | Minnesota | 27085 | 4722 | 61 |
1667695 | 1667695 | 2021-08-30 | Toombs | Georgia | 13279 | 4722 | 127 |
1648525 | 1648525 | 2021-08-24 | Jasper | Iowa | 19099 | 4722 | 73 |
1645277 | 1645277 | 2021-08-23 | Jasper | Iowa | 19099 | 4722 | 73 |
1642028 | 1642028 | 2021-08-22 | Jasper | Iowa | 19099 | 4722 | 73 |
1638778 | 1638778 | 2021-08-21 | Jasper | Iowa | 19099 | 4722 | 73 |
1635528 | 1635528 | 2021-08-20 | Jasper | Iowa | 19099 | 4722 | 73 |
1632278 | 1632278 | 2021-08-19 | Jasper | Iowa | 19099 | 4722 | 73 |
1629031 | 1629031 | 2021-08-18 | Jasper | Iowa | 19099 | 4722 | 73 |
1623562 | 1623562 | 2021-08-16 | Madison | New York | 36053 | 4722 | 89 |
1543677 | 1543677 | 2021-07-22 | Marinette | Wisconsin | 55075 | 4722 | 74 |
1489911 | 1489911 | 2021-07-06 | Mower | Minnesota | 27099 | 4722 | 33 |
1472012 | 1472012 | 2021-06-30 | Culpeper | Virginia | 51047 | 4722 | 67 |
1468767 | 1468767 | 2021-06-29 | Culpeper | Virginia | 51047 | 4722 | 67 |
1419913 | 1419913 | 2021-06-14 | Medina | Texas | 48325 | 4722 | 106 |
1416668 | 1416668 | 2021-06-13 | Medina | Texas | 48325 | 4722 | 106 |
1413422 | 1413422 | 2021-06-12 | Medina | Texas | 48325 | 4722 | 106 |
1404897 | 1404897 | 2021-06-10 | Lawrence | Indiana | 18093 | 4722 | 124 |
1402811 | 1402811 | 2021-06-09 | Beaufort | North Carolina | 37013 | 4722 | 97 |
1378131 | 1378131 | 2021-06-01 | Monroe | Wisconsin | 55081 | 4722 | 41 |
1373614 | 1373614 | 2021-05-31 | Chatham | North Carolina | 37037 | 4722 | 90 |
1374885 | 1374885 | 2021-05-31 | Monroe | Wisconsin | 55081 | 4722 | 41 |
1370369 | 1370369 | 2021-05-30 | Chatham | North Carolina | 37037 | 4722 | 90 |
1367123 | 1367123 | 2021-05-29 | Chatham | North Carolina | 37037 | 4722 | 90 |
1363877 | 1363877 | 2021-05-28 | Chatham | North Carolina | 37037 | 4722 | 90 |
1354215 | 1354215 | 2021-05-25 | Watauga | North Carolina | 37189 | 4722 | 31 |
1354351 | 1354351 | 2021-05-25 | Shelby | Ohio | 39149 | 4722 | 93 |
1280668 | 1280668 | 2021-05-02 | Mercer | West Virginia | 54055 | 4722 | 116 |
1270970 | 1270970 | 2021-04-29 | Douglas | Wisconsin | 55031 | 4722 | 51 |
1240126 | 1240126 | 2021-04-20 | Johnson | Missouri | 29101 | 4722 | 49 |
1241630 | 1241630 | 2021-04-20 | Washington | Virginia | 51191 | 4722 | 102 |
1220687 | 1220687 | 2021-04-14 | Scott | Missouri | 29201 | 4722 | 83 |
1221504 | 1221504 | 2021-04-14 | Bristol | Rhode Island | 44001 | 4722 | 140 |
1218256 | 1218256 | 2021-04-13 | Bristol | Rhode Island | 44001 | 4722 | 140 |
1215008 | 1215008 | 2021-04-12 | Bristol | Rhode Island | 44001 | 4722 | 140 |
1211761 | 1211761 | 2021-04-11 | Bristol | Rhode Island | 44001 | 4722 | 140 |
1208512 | 1208512 | 2021-04-10 | Bristol | Rhode Island | 44001 | 4722 | 140 |
1205264 | 1205264 | 2021-04-09 | Bristol | Rhode Island | 44001 | 4722 | 140 |
1205579 | 1205579 | 2021-04-09 | Harrison | Texas | 48203 | 4722 | 105 |
1200711 | 1200711 | 2021-04-08 | Scott | Kentucky | 21209 | 4722 | 32 |
1202016 | 1202016 | 2021-04-08 | Bristol | Rhode Island | 44001 | 4722 | 140 |
1198767 | 1198767 | 2021-04-07 | Bristol | Rhode Island | 44001 | 4722 | 140 |
1176710 | 1176710 | 2021-03-31 | Skagit | Washington | 53057 | 4722 | 65 |
1160870 | 1160870 | 2021-03-27 | Tehama | California | 6103 | 4722 | 51 |
1154676 | 1154676 | 2021-03-25 | Ware | Georgia | 13299 | 4722 | 157 |
1154996 | 1154996 | 2021-03-25 | Marshall | Iowa | 19127 | 4722 | 74 |
1148734 | 1148734 | 2021-03-23 | Nelson | Kentucky | 21179 | 4722 | 50 |
1132665 | 1132665 | 2021-03-18 | Branch | Michigan | 26023 | 4722 | 111 |
1128185 | 1128185 | 2021-03-17 | Dale | Alabama | 1045 | 4722 | 109 |
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);