ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
234 rows where cases = 2515 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Texas 19
- Virginia 19
- Missouri 17
- Puerto Rico 17
- Georgia 16
- Mississippi 15
- Indiana 10
- Kentucky 9
- Arkansas 8
- Michigan 8
- Tennessee 8
- Wisconsin 8
- Iowa 7
- North Carolina 7
- Alabama 5
- Colorado 5
- Louisiana 5
- Idaho 4
- Illinois 4
- Kansas 4
- Montana 4
- New York 4
- Pennsylvania 4
- South Carolina 4
- Ohio 3
- Wyoming 3
- Florida 2
- Minnesota 2
- Nevada 2
- New Mexico 2
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2501120 | 2501120 | 2022-05-13 | Howard | Missouri | 29089 | 2515 | 30 |
2501206 | 2501206 | 2022-05-13 | Fergus | Montana | 30027 | 2515 | 56 |
2473211 | 2473211 | 2022-05-04 | Charlotte | Virginia | 51037 | 2515 | 46 |
2463444 | 2463444 | 2022-05-01 | Charlotte | Virginia | 51037 | 2515 | 46 |
2460188 | 2460188 | 2022-04-30 | Charlotte | Virginia | 51037 | 2515 | 46 |
2456932 | 2456932 | 2022-04-29 | Charlotte | Virginia | 51037 | 2515 | 46 |
2444371 | 2444371 | 2022-04-26 | Perry | Arkansas | 5105 | 2515 | 37 |
2441115 | 2441115 | 2022-04-25 | Perry | Arkansas | 5105 | 2515 | 37 |
2376671 | 2376671 | 2022-04-05 | Franklin | Iowa | 19069 | 2515 | 43 |
2373419 | 2373419 | 2022-04-04 | Franklin | Iowa | 19069 | 2515 | 43 |
2370166 | 2370166 | 2022-04-03 | Franklin | Iowa | 19069 | 2515 | 43 |
2371690 | 2371690 | 2022-04-03 | Ciales | Puerto Rico | 72039 | 2515 | |
2366913 | 2366913 | 2022-04-02 | Franklin | Iowa | 19069 | 2515 | 43 |
2363660 | 2363660 | 2022-04-01 | Franklin | Iowa | 19069 | 2515 | 43 |
2360406 | 2360406 | 2022-03-31 | Franklin | Iowa | 19069 | 2515 | 43 |
2356571 | 2356571 | 2022-03-30 | Bent | Colorado | 8011 | 2515 | 47 |
2357152 | 2357152 | 2022-03-30 | Franklin | Iowa | 19069 | 2515 | 43 |
2352666 | 2352666 | 2022-03-28 | Terry | Texas | 48445 | 2515 | 84 |
2349414 | 2349414 | 2022-03-27 | Terry | Texas | 48445 | 2515 | 84 |
2346161 | 2346161 | 2022-03-26 | Terry | Texas | 48445 | 2515 | 84 |
2266904 | 2266904 | 2022-03-02 | Rosebud | Montana | 30087 | 2515 | 59 |
2248716 | 2248716 | 2022-02-24 | Galax city | Virginia | 51640 | 2515 | 74 |
2232901 | 2232901 | 2022-02-20 | Pike | Arkansas | 5109 | 2515 | 39 |
2221388 | 2221388 | 2022-02-16 | Richland | Montana | 30083 | 2515 | 30 |
2210738 | 2210738 | 2022-02-13 | Newton | Indiana | 18111 | 2515 | 65 |
2207485 | 2207485 | 2022-02-12 | Newton | Indiana | 18111 | 2515 | 65 |
2204069 | 2204069 | 2022-02-11 | Shoshone | Idaho | 16079 | 2515 | 71 |
2204232 | 2204232 | 2022-02-11 | Newton | Indiana | 18111 | 2515 | 65 |
2202194 | 2202194 | 2022-02-10 | Pamlico | North Carolina | 37137 | 2515 | 27 |
2194687 | 2194687 | 2022-02-08 | Rice | Kansas | 20159 | 2515 | 19 |
2191433 | 2191433 | 2022-02-07 | Rice | Kansas | 20159 | 2515 | 19 |
2157143 | 2157143 | 2022-01-27 | Butte | South Dakota | 46019 | 2515 | 43 |
2152015 | 2152015 | 2022-01-26 | Teton | Idaho | 16081 | 2515 | 8 |
2100865 | 2100865 | 2022-01-10 | Walthall | Mississippi | 28147 | 2515 | 69 |
2077018 | 2077018 | 2022-01-03 | Brooks | Georgia | 13027 | 2515 | 75 |
2073767 | 2073767 | 2022-01-02 | Brooks | Georgia | 13027 | 2515 | 75 |
2070516 | 2070516 | 2022-01-01 | Brooks | Georgia | 13027 | 2515 | 75 |
2067265 | 2067265 | 2021-12-31 | Brooks | Georgia | 13027 | 2515 | 75 |
2061926 | 2061926 | 2021-12-29 | Mississippi | Missouri | 29133 | 2515 | 49 |
2057066 | 2057066 | 2021-12-27 | Price | Wisconsin | 55099 | 2515 | 19 |
2044155 | 2044155 | 2021-12-24 | Macon | Alabama | 1087 | 2515 | 68 |
2044267 | 2044267 | 2021-12-24 | Marion | Arkansas | 5089 | 2515 | 70 |
2036481 | 2036481 | 2021-12-21 | Monroe | Ohio | 39111 | 2515 | 64 |
2032149 | 2032149 | 2021-12-20 | Fleming | Kentucky | 21069 | 2515 | 41 |
2034092 | 2034092 | 2021-12-20 | Grayson | Virginia | 51077 | 2515 | 56 |
2023679 | 2023679 | 2021-12-17 | Potter | Pennsylvania | 42105 | 2515 | 72 |
2020979 | 2020979 | 2021-12-16 | Wilbarger | Texas | 48487 | 2515 | 70 |
2008239 | 2008239 | 2021-12-12 | Morgan | West Virginia | 54065 | 2515 | 51 |
1992748 | 1992748 | 2021-12-08 | Johnson | Illinois | 17087 | 2515 | 38 |
1986665 | 1986665 | 2021-12-06 | Larue | Kentucky | 21123 | 2515 | 53 |
1983369 | 1983369 | 2021-12-05 | Butler | Kentucky | 21031 | 2515 | 41 |
1980119 | 1980119 | 2021-12-04 | Butler | Kentucky | 21031 | 2515 | 41 |
1976869 | 1976869 | 2021-12-03 | Butler | Kentucky | 21031 | 2515 | 41 |
1943486 | 1943486 | 2021-11-23 | Howard | Arkansas | 5061 | 2515 | 38 |
1917498 | 1917498 | 2021-11-15 | Madison | Arkansas | 5087 | 2515 | 40 |
1920355 | 1920355 | 2021-11-15 | New Kent | Virginia | 51127 | 2515 | 26 |
1914248 | 1914248 | 2021-11-14 | Madison | Arkansas | 5087 | 2515 | 40 |
1897860 | 1897860 | 2021-11-09 | Cleburne | Alabama | 1029 | 2515 | 60 |
1872096 | 1872096 | 2021-11-01 | Alamosa | Colorado | 8003 | 2515 | 44 |
1853937 | 1853937 | 2021-10-26 | Pike | Missouri | 29163 | 2515 | 37 |
1851686 | 1851686 | 2021-10-25 | Lewis | Tennessee | 47101 | 2515 | 38 |
1848436 | 1848436 | 2021-10-24 | Lewis | Tennessee | 47101 | 2515 | 38 |
1842670 | 1842670 | 2021-10-23 | Washington | Alabama | 1129 | 2515 | 51 |
1845186 | 1845186 | 2021-10-23 | Lewis | Tennessee | 47101 | 2515 | 38 |
1841936 | 1841936 | 2021-10-22 | Lewis | Tennessee | 47101 | 2515 | 38 |
1831314 | 1831314 | 2021-10-19 | Gage | Nebraska | 31067 | 2515 | 27 |
1807808 | 1807808 | 2021-10-12 | Jefferson | Kansas | 20087 | 2515 | 46 |
1804557 | 1804557 | 2021-10-11 | Jefferson | Kansas | 20087 | 2515 | 46 |
1803605 | 1803605 | 2021-10-10 | Lincoln | Wyoming | 56023 | 2515 | 15 |
1800356 | 1800356 | 2021-10-09 | Lincoln | Wyoming | 56023 | 2515 | 15 |
1797107 | 1797107 | 2021-10-08 | Lincoln | Wyoming | 56023 | 2515 | 15 |
1785691 | 1785691 | 2021-10-05 | Moniteau | Missouri | 29135 | 2515 | 38 |
1781587 | 1781587 | 2021-10-04 | Carroll | Indiana | 18015 | 2515 | 33 |
1773754 | 1773754 | 2021-10-01 | Aransas | Texas | 48007 | 2515 | 58 |
1769434 | 1769434 | 2021-09-30 | Livingston | Missouri | 29117 | 2515 | 62 |
1771030 | 1771030 | 2021-09-30 | Adams | Wisconsin | 55001 | 2515 | 33 |
1745745 | 1745745 | 2021-09-23 | Cass | Illinois | 17017 | 2515 | 37 |
1735178 | 1735178 | 2021-09-19 | Scott | Virginia | 51169 | 2515 | 67 |
1731928 | 1731928 | 2021-09-18 | Scott | Virginia | 51169 | 2515 | 67 |
1728678 | 1728678 | 2021-09-17 | Scott | Virginia | 51169 | 2515 | 67 |
1724460 | 1724460 | 2021-09-16 | Carroll | Ohio | 39019 | 2515 | 51 |
1719536 | 1719536 | 2021-09-15 | Banks | Georgia | 13011 | 2515 | 51 |
1719079 | 1719079 | 2021-09-14 | Langlade | Wisconsin | 55067 | 2515 | 52 |
1710922 | 1710922 | 2021-09-12 | Cooper | Missouri | 29053 | 2515 | 31 |
1705609 | 1705609 | 2021-09-10 | Freestone | Texas | 48161 | 2515 | 57 |
1691155 | 1691155 | 2021-09-06 | Alpena | Michigan | 26007 | 2515 | 66 |
1687905 | 1687905 | 2021-09-05 | Alpena | Michigan | 26007 | 2515 | 66 |
1689633 | 1689633 | 2021-09-05 | Fredericksburg city | Virginia | 51630 | 2515 | 25 |
1684655 | 1684655 | 2021-09-04 | Alpena | Michigan | 26007 | 2515 | 66 |
1686383 | 1686383 | 2021-09-04 | Fredericksburg city | Virginia | 51630 | 2515 | 25 |
1681404 | 1681404 | 2021-09-03 | Alpena | Michigan | 26007 | 2515 | 66 |
1683132 | 1683132 | 2021-09-03 | Fredericksburg city | Virginia | 51630 | 2515 | 25 |
1619221 | 1619221 | 2021-08-15 | Spencer | Indiana | 18147 | 2515 | 31 |
1619929 | 1619929 | 2021-08-15 | Tishomingo | Mississippi | 28141 | 2515 | 70 |
1615973 | 1615973 | 2021-08-14 | Spencer | Indiana | 18147 | 2515 | 31 |
1616681 | 1616681 | 2021-08-14 | Tishomingo | Mississippi | 28141 | 2515 | 70 |
1612724 | 1612724 | 2021-08-13 | Spencer | Indiana | 18147 | 2515 | 31 |
1613433 | 1613433 | 2021-08-13 | Tishomingo | Mississippi | 28141 | 2515 | 70 |
1611752 | 1611752 | 2021-08-12 | Waynesboro city | Virginia | 51820 | 2515 | 39 |
1585801 | 1585801 | 2021-08-04 | Stevens | Washington | 53065 | 2515 | 32 |
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);