ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
258 rows where cases = 2259 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Texas 26
- Mississippi 21
- Arkansas 16
- Kentucky 15
- Virginia 14
- Georgia 12
- West Virginia 11
- Kansas 10
- Indiana 9
- Illinois 8
- Iowa 8
- Minnesota 8
- North Carolina 8
- Tennessee 8
- Alabama 7
- Idaho 6
- New York 6
- Puerto Rico 6
- Louisiana 5
- New Mexico 5
- Ohio 5
- Wisconsin 5
- Nevada 4
- North Dakota 4
- Utah 4
- California 3
- Florida 3
- Michigan 3
- Missouri 3
- Arizona 2
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2449833 | 2449833 | 2022-04-27 | Guayanilla | Puerto Rico | 72059 | 2259 | |
2446601 | 2446601 | 2022-04-26 | Patillas | Puerto Rico | 72109 | 2259 | |
2427642 | 2427642 | 2022-04-20 | Essex | Virginia | 51057 | 2259 | 32 |
2421130 | 2421130 | 2022-04-18 | Essex | Virginia | 51057 | 2259 | 32 |
2418060 | 2418060 | 2022-04-17 | Webster | West Virginia | 54101 | 2259 | 33 |
2414804 | 2414804 | 2022-04-16 | Webster | West Virginia | 54101 | 2259 | 33 |
2411548 | 2411548 | 2022-04-15 | Webster | West Virginia | 54101 | 2259 | 33 |
2405259 | 2405259 | 2022-04-14 | Cleveland | Arkansas | 5025 | 2259 | 36 |
2408106 | 2408106 | 2022-04-14 | Essex | Virginia | 51057 | 2259 | 32 |
2408292 | 2408292 | 2022-04-14 | Webster | West Virginia | 54101 | 2259 | 33 |
2401781 | 2401781 | 2022-04-12 | Webster | West Virginia | 54101 | 2259 | 33 |
2398526 | 2398526 | 2022-04-11 | Webster | West Virginia | 54101 | 2259 | 33 |
2362729 | 2362729 | 2022-03-31 | Webster | West Virginia | 54101 | 2259 | 32 |
2359475 | 2359475 | 2022-03-30 | Webster | West Virginia | 54101 | 2259 | 31 |
2352820 | 2352820 | 2022-03-28 | Madison | Virginia | 51113 | 2259 | 37 |
2331226 | 2331226 | 2022-03-22 | Grant | Kansas | 20067 | 2259 | 34 |
2327974 | 2327974 | 2022-03-21 | Grant | Kansas | 20067 | 2259 | 34 |
2324721 | 2324721 | 2022-03-20 | Grant | Kansas | 20067 | 2259 | 34 |
2321467 | 2321467 | 2022-03-19 | Grant | Kansas | 20067 | 2259 | 34 |
2318213 | 2318213 | 2022-03-18 | Grant | Kansas | 20067 | 2259 | 34 |
2314506 | 2314506 | 2022-03-17 | Lanier | Georgia | 13173 | 2259 | 22 |
2314960 | 2314960 | 2022-03-17 | Grant | Kansas | 20067 | 2259 | 34 |
2311253 | 2311253 | 2022-03-16 | Lanier | Georgia | 13173 | 2259 | 22 |
2311707 | 2311707 | 2022-03-16 | Grant | Kansas | 20067 | 2259 | 34 |
2308454 | 2308454 | 2022-03-15 | Grant | Kansas | 20067 | 2259 | 34 |
2305203 | 2305203 | 2022-03-14 | Grant | Kansas | 20067 | 2259 | 34 |
2301615 | 2301615 | 2022-03-13 | Owyhee | Idaho | 16073 | 2259 | 52 |
2298363 | 2298363 | 2022-03-12 | Owyhee | Idaho | 16073 | 2259 | 52 |
2295111 | 2295111 | 2022-03-11 | Owyhee | Idaho | 16073 | 2259 | 52 |
2291859 | 2291859 | 2022-03-10 | Owyhee | Idaho | 16073 | 2259 | 52 |
2285356 | 2285356 | 2022-03-08 | Owyhee | Idaho | 16073 | 2259 | 52 |
2274413 | 2274413 | 2022-03-04 | Castro | Texas | 48069 | 2259 | 46 |
2269093 | 2269093 | 2022-03-03 | Owyhee | Idaho | 16073 | 2259 | 51 |
2263415 | 2263415 | 2022-03-01 | Benton | Mississippi | 28009 | 2259 | 49 |
2260164 | 2260164 | 2022-02-28 | Benton | Mississippi | 28009 | 2259 | 49 |
2249164 | 2249164 | 2022-02-25 | Scott | Arkansas | 5127 | 2259 | 38 |
2200216 | 2200216 | 2022-02-09 | Washakie | Wyoming | 56043 | 2259 | 42 |
2168736 | 2168736 | 2022-01-31 | Hancock | Kentucky | 21091 | 2259 | 19 |
2144060 | 2144060 | 2022-01-23 | Santa Isabel | Puerto Rico | 72133 | 2259 | |
2107326 | 2107326 | 2022-01-12 | Jefferson Davis | Mississippi | 28065 | 2259 | 43 |
2087505 | 2087505 | 2022-01-06 | Claiborne | Louisiana | 22027 | 2259 | 66 |
2075208 | 2075208 | 2022-01-02 | Torrance | New Mexico | 35057 | 2259 | 35 |
2076521 | 2076521 | 2022-01-02 | Bayfield | Wisconsin | 55007 | 2259 | 33 |
2071957 | 2071957 | 2022-01-01 | Torrance | New Mexico | 35057 | 2259 | 35 |
2073270 | 2073270 | 2022-01-01 | Bayfield | Wisconsin | 55007 | 2259 | 33 |
2068706 | 2068706 | 2021-12-31 | Torrance | New Mexico | 35057 | 2259 | 35 |
2070019 | 2070019 | 2021-12-31 | Bayfield | Wisconsin | 55007 | 2259 | 33 |
2065455 | 2065455 | 2021-12-30 | Torrance | New Mexico | 35057 | 2259 | 35 |
2052000 | 2052000 | 2021-12-26 | Pope | Minnesota | 27121 | 2259 | 14 |
2048750 | 2048750 | 2021-12-25 | Pope | Minnesota | 27121 | 2259 | 14 |
2045500 | 2045500 | 2021-12-24 | Pope | Minnesota | 27121 | 2259 | 14 |
2042250 | 2042250 | 2021-12-23 | Pope | Minnesota | 27121 | 2259 | 14 |
2030473 | 2030473 | 2021-12-19 | Stewart | Tennessee | 47161 | 2259 | 39 |
2027222 | 2027222 | 2021-12-18 | Stewart | Tennessee | 47161 | 2259 | 39 |
2023971 | 2023971 | 2021-12-17 | Stewart | Tennessee | 47161 | 2259 | 39 |
2012857 | 2012857 | 2021-12-14 | Arenac | Michigan | 26011 | 2259 | 49 |
2009606 | 2009606 | 2021-12-13 | Arenac | Michigan | 26011 | 2259 | 49 |
2006542 | 2006542 | 2021-12-12 | Greene | Mississippi | 28041 | 2259 | 50 |
2003291 | 2003291 | 2021-12-11 | Greene | Mississippi | 28041 | 2259 | 50 |
2000041 | 2000041 | 2021-12-10 | Greene | Mississippi | 28041 | 2259 | 50 |
2001297 | 2001297 | 2021-12-10 | Eastland | Texas | 48133 | 2259 | 85 |
1988450 | 1988450 | 2021-12-06 | Terry | Texas | 48445 | 2259 | 67 |
1985200 | 1985200 | 2021-12-05 | Terry | Texas | 48445 | 2259 | 67 |
1981950 | 1981950 | 2021-12-04 | Terry | Texas | 48445 | 2259 | 67 |
1966187 | 1966187 | 2021-11-30 | Northwest Arctic Borough | Alaska | 2188 | 2259 | 9 |
1963350 | 1963350 | 2021-11-29 | Oglethorpe | Georgia | 13221 | 2259 | 43 |
1949617 | 1949617 | 2021-11-24 | Patrick | Virginia | 51141 | 2259 | 59 |
1946325 | 1946325 | 2021-11-23 | Grayson | Virginia | 51077 | 2259 | 51 |
1941131 | 1941131 | 2021-11-22 | Fleming | Kentucky | 21069 | 2259 | 37 |
1921748 | 1921748 | 2021-11-16 | Madison | Louisiana | 22065 | 2259 | 53 |
1891990 | 1891990 | 2021-11-07 | Jo Daviess | Illinois | 17085 | 2259 | 32 |
1892730 | 1892730 | 2021-11-07 | Pennington | Minnesota | 27113 | 2259 | 28 |
1888740 | 1888740 | 2021-11-06 | Jo Daviess | Illinois | 17085 | 2259 | 32 |
1889480 | 1889480 | 2021-11-06 | Pennington | Minnesota | 27113 | 2259 | 28 |
1885490 | 1885490 | 2021-11-05 | Jo Daviess | Illinois | 17085 | 2259 | 32 |
1886230 | 1886230 | 2021-11-05 | Pennington | Minnesota | 27113 | 2259 | 28 |
1873906 | 1873906 | 2021-11-01 | Walsh | North Dakota | 38099 | 2259 | 29 |
1870657 | 1870657 | 2021-10-31 | Walsh | North Dakota | 38099 | 2259 | 29 |
1867408 | 1867408 | 2021-10-30 | Walsh | North Dakota | 38099 | 2259 | 29 |
1847384 | 1847384 | 2021-10-24 | Dallas | Missouri | 29059 | 2259 | 42 |
1831536 | 1831536 | 2021-10-19 | Chowan | North Carolina | 37041 | 2259 | 40 |
1832775 | 1832775 | 2021-10-19 | Crawford | Wisconsin | 55023 | 2259 | 22 |
1804384 | 1804384 | 2021-10-11 | Pike | Indiana | 18125 | 2259 | 44 |
1806536 | 1806536 | 2021-10-11 | Orleans | Vermont | 50019 | 2259 | 13 |
1801385 | 1801385 | 2021-10-10 | Butler | Kentucky | 21031 | 2259 | 31 |
1798136 | 1798136 | 2021-10-09 | Butler | Kentucky | 21031 | 2259 | 31 |
1794887 | 1794887 | 2021-10-08 | Butler | Kentucky | 21031 | 2259 | 31 |
1790664 | 1790664 | 2021-10-07 | Macon | Alabama | 1087 | 2259 | 60 |
1792465 | 1792465 | 2021-10-07 | Taos | New Mexico | 35055 | 2259 | 62 |
1785193 | 1785193 | 2021-10-05 | Lewis | Kentucky | 21135 | 2259 | 54 |
1781936 | 1781936 | 2021-10-04 | Knott | Kentucky | 21119 | 2259 | 34 |
1760642 | 1760642 | 2021-09-27 | Oglala Lakota | South Dakota | 46102 | 2259 | 52 |
1725158 | 1725158 | 2021-09-16 | Leon | Texas | 48289 | 2259 | 53 |
1719927 | 1719927 | 2021-09-15 | Vermillion | Indiana | 18165 | 2259 | 50 |
1721072 | 1721072 | 2021-09-15 | Currituck | North Carolina | 37053 | 2259 | 20 |
1706295 | 1706295 | 2021-09-11 | Izard | Arkansas | 5065 | 2259 | 53 |
1694285 | 1694285 | 2021-09-07 | Bienville | Louisiana | 22013 | 2259 | 87 |
1675706 | 1675706 | 2021-09-01 | Rolette | North Dakota | 38079 | 2259 | 28 |
1676435 | 1676435 | 2021-09-01 | Llano | Texas | 48299 | 2259 | 60 |
1676685 | 1676685 | 2021-09-01 | Powhatan | Virginia | 51145 | 2259 | 17 |
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);