ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
147 rows where cases = 4527 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Texas 17
- Tennessee 14
- Kentucky 11
- Oklahoma 9
- Michigan 7
- Missouri 6
- Virginia 6
- California 5
- Colorado 5
- Georgia 5
- New Hampshire 5
- Puerto Rico 5
- Illinois 4
- Indiana 4
- Minnesota 4
- Mississippi 4
- Montana 4
- Oregon 4
- South Dakota 4
- Ohio 3
- Kansas 2
- Louisiana 2
- Nevada 2
- North Carolina 2
- Pennsylvania 2
- West Virginia 2
- Wisconsin 2
- Alabama 1
- Florida 1
- Iowa 1
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2492339 | 2492339 | 2022-05-10 | Benton | Tennessee | 47005 | 4527 | 92 |
2489081 | 2489081 | 2022-05-09 | Benton | Tennessee | 47005 | 4527 | 92 |
2484357 | 2484357 | 2022-05-08 | Lewis | Kentucky | 21135 | 4527 | 85 |
2485824 | 2485824 | 2022-05-08 | Benton | Tennessee | 47005 | 4527 | 92 |
2481099 | 2481099 | 2022-05-07 | Lewis | Kentucky | 21135 | 4527 | 85 |
2482566 | 2482566 | 2022-05-07 | Benton | Tennessee | 47005 | 4527 | 92 |
2477841 | 2477841 | 2022-05-06 | Lewis | Kentucky | 21135 | 4527 | 85 |
2479308 | 2479308 | 2022-05-06 | Benton | Tennessee | 47005 | 4527 | 92 |
2474583 | 2474583 | 2022-05-05 | Lewis | Kentucky | 21135 | 4527 | 85 |
2476050 | 2476050 | 2022-05-05 | Benton | Tennessee | 47005 | 4527 | 92 |
2471326 | 2471326 | 2022-05-04 | Lewis | Kentucky | 21135 | 4527 | 85 |
2472610 | 2472610 | 2022-05-04 | Catano | Puerto Rico | 72033 | 4527 | |
2472793 | 2472793 | 2022-05-04 | Benton | Tennessee | 47005 | 4527 | 92 |
2468070 | 2468070 | 2022-05-03 | Lewis | Kentucky | 21135 | 4527 | 85 |
2464419 | 2464419 | 2022-05-02 | Piatt | Illinois | 17147 | 4527 | 29 |
2464815 | 2464815 | 2022-05-02 | Lewis | Kentucky | 21135 | 4527 | 85 |
2437942 | 2437942 | 2022-04-24 | Alamosa | Colorado | 8003 | 4527 | 61 |
2434686 | 2434686 | 2022-04-23 | Alamosa | Colorado | 8003 | 4527 | 61 |
2431430 | 2431430 | 2022-04-22 | Alamosa | Colorado | 8003 | 4527 | 61 |
2424918 | 2424918 | 2022-04-20 | Alamosa | Colorado | 8003 | 4527 | 61 |
2397730 | 2397730 | 2022-04-11 | Coamo | Puerto Rico | 72043 | 4527 | |
2382541 | 2382541 | 2022-04-07 | Colusa | California | 6011 | 4527 | 21 |
2379286 | 2379286 | 2022-04-06 | Colusa | California | 6011 | 4527 | 21 |
2376032 | 2376032 | 2022-04-05 | Colusa | California | 6011 | 4527 | 21 |
2359148 | 2359148 | 2022-03-30 | Robertson | Texas | 48395 | 4527 | 76 |
2355894 | 2355894 | 2022-03-29 | Robertson | Texas | 48395 | 4527 | 76 |
2352641 | 2352641 | 2022-03-28 | Robertson | Texas | 48395 | 4527 | 76 |
2349389 | 2349389 | 2022-03-27 | Robertson | Texas | 48395 | 4527 | 76 |
2326546 | 2326546 | 2022-03-20 | Jones | Texas | 48253 | 4527 | 92 |
2323293 | 2323293 | 2022-03-19 | Jones | Texas | 48253 | 4527 | 92 |
2320039 | 2320039 | 2022-03-18 | Jones | Texas | 48253 | 4527 | 92 |
2296881 | 2296881 | 2022-03-11 | Guayama | Puerto Rico | 72057 | 4527 | |
2290211 | 2290211 | 2022-03-09 | Marshall | Oklahoma | 40095 | 4527 | 39 |
2286397 | 2286397 | 2022-03-08 | Hill | Montana | 30041 | 4527 | 71 |
2286959 | 2286959 | 2022-03-08 | Marshall | Oklahoma | 40095 | 4527 | 39 |
2281710 | 2281710 | 2022-03-07 | Inyo | California | 6027 | 4527 | 56 |
2283707 | 2283707 | 2022-03-07 | Marshall | Oklahoma | 40095 | 4527 | 39 |
2279892 | 2279892 | 2022-03-06 | Hill | Montana | 30041 | 4527 | 72 |
2280455 | 2280455 | 2022-03-06 | Marshall | Oklahoma | 40095 | 4527 | 39 |
2280492 | 2280492 | 2022-03-06 | Clatsop | Oregon | 41007 | 4527 | 39 |
2276639 | 2276639 | 2022-03-05 | Hill | Montana | 30041 | 4527 | 72 |
2277202 | 2277202 | 2022-03-05 | Marshall | Oklahoma | 40095 | 4527 | 39 |
2277239 | 2277239 | 2022-03-05 | Clatsop | Oregon | 41007 | 4527 | 39 |
2273386 | 2273386 | 2022-03-04 | Hill | Montana | 30041 | 4527 | 72 |
2273949 | 2273949 | 2022-03-04 | Marshall | Oklahoma | 40095 | 4527 | 39 |
2273986 | 2273986 | 2022-03-04 | Clatsop | Oregon | 41007 | 4527 | 39 |
2270696 | 2270696 | 2022-03-03 | Marshall | Oklahoma | 40095 | 4527 | 39 |
2270733 | 2270733 | 2022-03-03 | Clatsop | Oregon | 41007 | 4527 | 39 |
2267444 | 2267444 | 2022-03-02 | Marshall | Oklahoma | 40095 | 4527 | 39 |
2239680 | 2239680 | 2022-02-22 | Elbert | Georgia | 13105 | 4527 | 104 |
2240553 | 2240553 | 2022-02-22 | Roscommon | Michigan | 26143 | 4527 | 110 |
2237302 | 2237302 | 2022-02-21 | Roscommon | Michigan | 26143 | 4527 | 110 |
2234051 | 2234051 | 2022-02-20 | Roscommon | Michigan | 26143 | 4527 | 110 |
2215696 | 2215696 | 2022-02-14 | Beadle | South Dakota | 46005 | 4527 | 55 |
2212445 | 2212445 | 2022-02-13 | Beadle | South Dakota | 46005 | 4527 | 55 |
2209192 | 2209192 | 2022-02-12 | Beadle | South Dakota | 46005 | 4527 | 55 |
2205939 | 2205939 | 2022-02-11 | Beadle | South Dakota | 46005 | 4527 | 55 |
2171882 | 2171882 | 2022-02-01 | Jefferson | Kansas | 20087 | 4527 | 55 |
2168629 | 2168629 | 2022-01-31 | Jefferson | Kansas | 20087 | 4527 | 55 |
2159502 | 2159502 | 2022-01-28 | Perry | Missouri | 29157 | 4527 | 44 |
2128156 | 2128156 | 2022-01-18 | Lampasas | Texas | 48281 | 4527 | 72 |
2118031 | 2118031 | 2022-01-15 | San Lorenzo | Puerto Rico | 72129 | 4527 | |
2098524 | 2098524 | 2022-01-09 | San Sebastian | Puerto Rico | 72131 | 4527 | |
2099279 | 2099279 | 2022-01-09 | Wyoming | West Virginia | 54109 | 4527 | 77 |
2066592 | 2066592 | 2021-12-30 | Halifax | Virginia | 51083 | 4527 | 126 |
2061791 | 2061791 | 2021-12-29 | Covington | Mississippi | 28031 | 4527 | 96 |
2009731 | 2009731 | 2021-12-13 | Meeker | Minnesota | 27093 | 4527 | 61 |
1975038 | 1975038 | 2021-12-02 | Edgefield | South Carolina | 45037 | 4527 | 59 |
1961391 | 1961391 | 2021-11-28 | Sullivan | New Hampshire | 33019 | 4527 | 39 |
1958140 | 1958140 | 2021-11-27 | Sullivan | New Hampshire | 33019 | 4527 | 39 |
1954889 | 1954889 | 2021-11-26 | Sullivan | New Hampshire | 33019 | 4527 | 39 |
1951638 | 1951638 | 2021-11-25 | Sullivan | New Hampshire | 33019 | 4527 | 39 |
1948387 | 1948387 | 2021-11-24 | Sullivan | New Hampshire | 33019 | 4527 | 39 |
1944500 | 1944500 | 2021-11-23 | Morehouse | Louisiana | 22067 | 4527 | 116 |
1937640 | 1937640 | 2021-11-21 | White | Indiana | 18181 | 4527 | 68 |
1934390 | 1934390 | 2021-11-20 | White | Indiana | 18181 | 4527 | 68 |
1935096 | 1935096 | 2021-11-20 | Barry | Missouri | 29009 | 4527 | 90 |
1931139 | 1931139 | 2021-11-19 | White | Indiana | 18181 | 4527 | 68 |
1899010 | 1899010 | 2021-11-09 | Sabine | Louisiana | 22085 | 4527 | 93 |
1875706 | 1875706 | 2021-11-02 | Bureau | Illinois | 17011 | 4527 | 105 |
1850884 | 1850884 | 2021-10-25 | Nye | Nevada | 32023 | 4527 | 152 |
1808352 | 1808352 | 2021-10-12 | Tate | Mississippi | 28137 | 4527 | 108 |
1803900 | 1803900 | 2021-10-11 | Logan | Colorado | 8075 | 4527 | 79 |
1805385 | 1805385 | 2021-10-11 | Douglas | Nevada | 32005 | 4527 | 52 |
1732621 | 1732621 | 2021-09-19 | Lumpkin | Georgia | 13187 | 4527 | 88 |
1729371 | 1729371 | 2021-09-18 | Lumpkin | Georgia | 13187 | 4527 | 88 |
1726121 | 1726121 | 2021-09-17 | Lumpkin | Georgia | 13187 | 4527 | 88 |
1692234 | 1692234 | 2021-09-06 | Venango | Pennsylvania | 42121 | 4527 | 106 |
1689396 | 1689396 | 2021-09-05 | Hopkins | Texas | 48223 | 4527 | 126 |
1632889 | 1632889 | 2021-08-19 | Lincoln | Mississippi | 28085 | 4527 | 120 |
1618045 | 1618045 | 2021-08-14 | Titus | Texas | 48449 | 4527 | 85 |
1609971 | 1609971 | 2021-08-12 | Hillsdale | Michigan | 26059 | 4527 | 95 |
1606723 | 1606723 | 2021-08-11 | Hillsdale | Michigan | 26059 | 4527 | 95 |
1604191 | 1604191 | 2021-08-10 | Stokes | North Carolina | 37169 | 4527 | 81 |
1598487 | 1598487 | 2021-08-08 | Matagorda | Texas | 48321 | 4527 | 115 |
1590758 | 1590758 | 2021-08-06 | Laclede | Missouri | 29105 | 4527 | 92 |
1574503 | 1574503 | 2021-08-01 | Howell | Missouri | 29091 | 4527 | 50 |
1554209 | 1554209 | 2021-07-26 | Harrison | Indiana | 18061 | 4527 | 78 |
1553186 | 1553186 | 2021-07-25 | Danville city | Virginia | 51590 | 4527 | 143 |
1549939 | 1549939 | 2021-07-24 | Danville city | Virginia | 51590 | 4527 | 143 |
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);