ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
60 rows where cases = 6428 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 24
- Alabama 10
- Iowa 7
- Louisiana 4
- Minnesota 4
- Arkansas 3
- Puerto Rico 3
- South Dakota 3
- Virgin Islands 3
- Indiana 2
- Kentucky 2
- North Carolina 2
- Ohio 2
- Pennsylvania 2
- South Carolina 2
- Virginia 2
- Florida 1
- Kansas 1
- Mississippi 1
- Montana 1
- New York 1
- Texas 1
- Washington 1
- West Virginia 1
- Wisconsin 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2427931 | 2427931 | 2022-04-21 | Bibb | Alabama | 1007 | 6428 | 103 |
2424675 | 2424675 | 2022-04-20 | Bibb | Alabama | 1007 | 6428 | 103 |
2421419 | 2421419 | 2022-04-19 | Bibb | Alabama | 1007 | 6428 | 103 |
2418163 | 2418163 | 2022-04-18 | Bibb | Alabama | 1007 | 6428 | 103 |
2419321 | 2419321 | 2022-04-18 | Plaquemines | Louisiana | 22075 | 6428 | 45 |
2414907 | 2414907 | 2022-04-17 | Bibb | Alabama | 1007 | 6428 | 103 |
2411651 | 2411651 | 2022-04-16 | Bibb | Alabama | 1007 | 6428 | 103 |
2408395 | 2408395 | 2022-04-15 | Bibb | Alabama | 1007 | 6428 | 103 |
2405139 | 2405139 | 2022-04-14 | Bibb | Alabama | 1007 | 6428 | 103 |
2399434 | 2399434 | 2022-04-12 | Buena Vista | Iowa | 19021 | 6428 | 57 |
2396178 | 2396178 | 2022-04-11 | Buena Vista | Iowa | 19021 | 6428 | 57 |
2392923 | 2392923 | 2022-04-10 | Buena Vista | Iowa | 19021 | 6428 | 57 |
2389667 | 2389667 | 2022-04-09 | Buena Vista | Iowa | 19021 | 6428 | 57 |
2386411 | 2386411 | 2022-04-08 | Buena Vista | Iowa | 19021 | 6428 | 57 |
2383157 | 2383157 | 2022-04-07 | Buena Vista | Iowa | 19021 | 6428 | 57 |
2379902 | 2379902 | 2022-04-06 | Buena Vista | Iowa | 19021 | 6428 | 57 |
2349938 | 2349938 | 2022-03-28 | Cleburne | Arkansas | 5023 | 6428 | 127 |
2346685 | 2346685 | 2022-03-27 | Cleburne | Arkansas | 5023 | 6428 | 127 |
2343432 | 2343432 | 2022-03-26 | Cleburne | Arkansas | 5023 | 6428 | 127 |
2274122 | 2274122 | 2022-03-04 | Isabela | Puerto Rico | 72071 | 6428 | |
2212483 | 2212483 | 2022-02-13 | Lawrence | South Dakota | 46081 | 6428 | 80 |
2209230 | 2209230 | 2022-02-12 | Lawrence | South Dakota | 46081 | 6428 | 80 |
2205977 | 2205977 | 2022-02-11 | Lawrence | South Dakota | 46081 | 6428 | 80 |
2199325 | 2199325 | 2022-02-09 | Dorado | Puerto Rico | 72051 | 6428 | |
2193201 | 2193201 | 2022-02-07 | Hutchinson | Texas | 48233 | 6428 | 124 |
2152565 | 2152565 | 2022-01-26 | Jefferson Davis | Louisiana | 22053 | 6428 | 135 |
2143995 | 2143995 | 2022-01-23 | Aguadilla | Puerto Rico | 72005 | 6428 | |
2121811 | 2121811 | 2022-01-16 | St. Croix | Virgin Islands | 78010 | 6428 | 38 |
2118559 | 2118559 | 2022-01-15 | St. Croix | Virgin Islands | 78010 | 6428 | 38 |
2115307 | 2115307 | 2022-01-14 | St. Croix | Virgin Islands | 78010 | 6428 | 38 |
2084167 | 2084167 | 2022-01-05 | Harlan | Kentucky | 21095 | 6428 | 160 |
2009526 | 2009526 | 2021-12-13 | St. John the Baptist | Louisiana | 22095 | 6428 | 173 |
2006436 | 2006436 | 2021-12-12 | Becker | Minnesota | 27005 | 6428 | 75 |
2003185 | 2003185 | 2021-12-11 | Becker | Minnesota | 27005 | 6428 | 75 |
1999935 | 1999935 | 2021-12-10 | Becker | Minnesota | 27005 | 6428 | 75 |
1996143 | 1996143 | 2021-12-09 | Wabash | Indiana | 18169 | 6428 | 118 |
1973374 | 1973374 | 2021-12-02 | Putnam | Indiana | 18133 | 6428 | 87 |
1974090 | 1974090 | 2021-12-02 | Union | Mississippi | 28145 | 6428 | 98 |
1929527 | 1929527 | 2021-11-18 | Dillon | South Carolina | 45033 | 6428 | 115 |
1909702 | 1909702 | 2021-11-12 | Logan | Ohio | 39091 | 6428 | 104 |
1855342 | 1855342 | 2021-10-26 | Henry | Virginia | 51089 | 6428 | 154 |
1834236 | 1834236 | 2021-10-20 | Mower | Minnesota | 27099 | 6428 | 40 |
1766551 | 1766551 | 2021-09-29 | Chatham | North Carolina | 37037 | 6428 | 91 |
1674768 | 1674768 | 2021-09-01 | Scott | Kentucky | 21209 | 6428 | 37 |
1617264 | 1617264 | 2021-08-14 | Belmont | Ohio | 39013 | 6428 | 181 |
1338916 | 1338916 | 2021-05-20 | Bedford | Virginia | 51019 | 6428 | 102 |
1264446 | 1264446 | 2021-04-27 | Raleigh | West Virginia | 54081 | 6428 | 78 |
1240518 | 1240518 | 2021-04-20 | Franklin | North Carolina | 37069 | 6428 | 49 |
1173989 | 1173989 | 2021-03-31 | Monroe | Florida | 12087 | 6428 | 48 |
1071585 | 1071585 | 2021-02-27 | Chemung | New York | 36015 | 6428 | 130 |
1047047 | 1047047 | 2021-02-20 | Jackson | Alabama | 1071 | 6428 | 99 |
961811 | 961811 | 2021-01-24 | Darlington | South Carolina | 45031 | 6428 | 124 |
889628 | 889628 | 2021-01-02 | Missoula | Montana | 30063 | 6428 | 55 |
879164 | 879164 | 2020-12-30 | Douglas | Kansas | 20045 | 6428 | 34 |
725528 | 725528 | 2020-11-12 | Benton | Washington | 53005 | 6428 | 141 |
597127 | 597127 | 2020-10-04 | Ouachita | Louisiana | 22073 | 6428 | 149 |
514980 | 514980 | 2020-09-08 | Waukesha | Wisconsin | 55133 | 6428 | 78 |
482718 | 482718 | 2020-08-30 | Madison | Alabama | 1089 | 6428 | 52 |
459109 | 459109 | 2020-08-22 | Lancaster | Pennsylvania | 42071 | 6428 | 428 |
189800 | 189800 | 2020-05-29 | Delaware | Pennsylvania | 42045 | 6428 | 550 |
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);