ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
171 rows where cases = 3162 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Texas 20
- Kentucky 11
- Georgia 10
- Virginia 10
- New York 9
- North Carolina 9
- Tennessee 8
- Indiana 7
- Louisiana 7
- Mississippi 6
- West Virginia 6
- Alabama 5
- Colorado 5
- Michigan 5
- New Mexico 5
- Oregon 5
- Kansas 4
- Ohio 4
- Puerto Rico 4
- Wisconsin 4
- Florida 3
- Minnesota 3
- Missouri 3
- Arkansas 2
- California 2
- Idaho 2
- New Jersey 2
- Washington 2
- Delaware 1
- Hawaii 1
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2418053 | 2418053 | 2022-04-17 | Roane | West Virginia | 54087 | 3162 | 36 |
2414797 | 2414797 | 2022-04-16 | Roane | West Virginia | 54087 | 3162 | 36 |
2411541 | 2411541 | 2022-04-15 | Roane | West Virginia | 54087 | 3162 | 36 |
2326135 | 2326135 | 2022-03-20 | Barceloneta | Puerto Rico | 72017 | 3162 | |
2238111 | 2238111 | 2022-02-21 | Noble | Ohio | 39121 | 3162 | 53 |
2238993 | 2238993 | 2022-02-21 | Martinsville city | Virginia | 51690 | 3162 | 108 |
2221970 | 2221970 | 2022-02-16 | Curry | Oregon | 41015 | 3162 | 44 |
2216752 | 2216752 | 2022-02-15 | Gunnison | Colorado | 8051 | 3162 | 13 |
2194981 | 2194981 | 2022-02-08 | Gogebic | Michigan | 26053 | 3162 | 65 |
2191727 | 2191727 | 2022-02-07 | Gogebic | Michigan | 26053 | 3162 | 65 |
2189590 | 2189590 | 2022-02-06 | Naguabo | Puerto Rico | 72103 | 3162 | |
2165470 | 2165470 | 2022-01-30 | Fleming | Kentucky | 21069 | 3162 | 44 |
2162215 | 2162215 | 2022-01-29 | Fleming | Kentucky | 21069 | 3162 | 44 |
2158960 | 2158960 | 2022-01-28 | Fleming | Kentucky | 21069 | 3162 | 44 |
2148558 | 2148558 | 2022-01-25 | Bacon | Georgia | 13005 | 3162 | 65 |
2106348 | 2106348 | 2022-01-12 | Jeff Davis | Georgia | 13161 | 3162 | 64 |
2075274 | 2075274 | 2022-01-02 | Avery | North Carolina | 37011 | 3162 | 39 |
2072023 | 2072023 | 2022-01-01 | Avery | North Carolina | 37011 | 3162 | 39 |
2072488 | 2072488 | 2022-01-01 | Las Piedras | Puerto Rico | 72085 | 3162 | |
2068772 | 2068772 | 2021-12-31 | Avery | North Carolina | 37011 | 3162 | 39 |
2069237 | 2069237 | 2021-12-31 | Las Piedras | Puerto Rico | 72085 | 3162 | |
2038016 | 2038016 | 2021-12-22 | Brantley | Georgia | 13025 | 3162 | 89 |
2031726 | 2031726 | 2021-12-20 | Clark | Illinois | 17023 | 3162 | 53 |
2029706 | 2029706 | 2021-12-19 | Taos | New Mexico | 35055 | 3162 | 72 |
2026455 | 2026455 | 2021-12-18 | Taos | New Mexico | 35055 | 3162 | 72 |
2023204 | 2023204 | 2021-12-17 | Taos | New Mexico | 35055 | 3162 | 72 |
1993942 | 1993942 | 2021-12-08 | San Miguel | New Mexico | 35047 | 3162 | 31 |
1970748 | 1970748 | 2021-12-01 | Roseau | Minnesota | 27135 | 3162 | 31 |
1956639 | 1956639 | 2021-11-27 | Otero | Colorado | 8089 | 3162 | 94 |
1953388 | 1953388 | 2021-11-26 | Otero | Colorado | 8089 | 3162 | 94 |
1950137 | 1950137 | 2021-11-25 | Otero | Colorado | 8089 | 3162 | 94 |
1933466 | 1933466 | 2021-11-19 | Lincoln | West Virginia | 54043 | 3162 | 49 |
1923713 | 1923713 | 2021-11-16 | Lewis | West Virginia | 54041 | 3162 | 57 |
1914524 | 1914524 | 2021-11-14 | Crisp | Georgia | 13081 | 3162 | 112 |
1911274 | 1911274 | 2021-11-13 | Crisp | Georgia | 13081 | 3162 | 112 |
1908025 | 1908025 | 2021-11-12 | Crisp | Georgia | 13081 | 3162 | 112 |
1904776 | 1904776 | 2021-11-11 | Crisp | Georgia | 13081 | 3162 | 111 |
1901526 | 1901526 | 2021-11-10 | Crisp | Georgia | 13081 | 3162 | 111 |
1898038 | 1898038 | 2021-11-09 | Colusa | California | 6011 | 3162 | 19 |
1895952 | 1895952 | 2021-11-08 | Hubbard | Minnesota | 27057 | 3162 | 46 |
1890168 | 1890168 | 2021-11-06 | Carroll | Ohio | 39019 | 3162 | 69 |
1880962 | 1880962 | 2021-11-03 | Unicoi | Tennessee | 47171 | 3162 | 65 |
1874463 | 1874463 | 2021-11-01 | Trousdale | Tennessee | 47169 | 3162 | 26 |
1869192 | 1869192 | 2021-10-31 | Minidoka | Idaho | 16067 | 3162 | 46 |
1871214 | 1871214 | 2021-10-31 | Trousdale | Tennessee | 47169 | 3162 | 26 |
1865943 | 1865943 | 2021-10-30 | Minidoka | Idaho | 16067 | 3162 | 46 |
1867965 | 1867965 | 2021-10-30 | Trousdale | Tennessee | 47169 | 3162 | 26 |
1868266 | 1868266 | 2021-10-30 | Franklin | Vermont | 50011 | 3162 | 50 |
1864716 | 1864716 | 2021-10-29 | Trousdale | Tennessee | 47169 | 3162 | 26 |
1858979 | 1858979 | 2021-10-28 | Conway | Arkansas | 5029 | 3162 | 44 |
1842659 | 1842659 | 2021-10-23 | Pickens | Alabama | 1107 | 3162 | 84 |
1828620 | 1828620 | 2021-10-18 | Union | Oregon | 41061 | 3162 | 47 |
1819365 | 1819365 | 2021-10-15 | Jones | Texas | 48253 | 3162 | 70 |
1816197 | 1816197 | 2021-10-14 | Scurry | Texas | 48415 | 3162 | 81 |
1812949 | 1812949 | 2021-10-13 | Scurry | Texas | 48415 | 3162 | 81 |
1796621 | 1796621 | 2021-10-08 | Jones | Texas | 48253 | 3162 | 70 |
1792160 | 1792160 | 2021-10-07 | Henry | Missouri | 29083 | 3162 | 49 |
1781416 | 1781416 | 2021-10-04 | Washington | Georgia | 13303 | 3162 | 109 |
1771180 | 1771180 | 2021-10-01 | Randolph | Alabama | 1111 | 3162 | 57 |
1732886 | 1732886 | 2021-09-19 | LaGrange | Indiana | 18087 | 3162 | 76 |
1729636 | 1729636 | 2021-09-18 | LaGrange | Indiana | 18087 | 3162 | 76 |
1726386 | 1726386 | 2021-09-17 | LaGrange | Indiana | 18087 | 3162 | 76 |
1695870 | 1695870 | 2021-09-07 | Gonzales | Texas | 48177 | 3162 | 63 |
1692622 | 1692622 | 2021-09-06 | Gonzales | Texas | 48177 | 3162 | 63 |
1689373 | 1689373 | 2021-09-05 | Gonzales | Texas | 48177 | 3162 | 63 |
1686123 | 1686123 | 2021-09-04 | Gonzales | Texas | 48177 | 3162 | 63 |
1625884 | 1625884 | 2021-08-17 | Labette | Kansas | 20099 | 3162 | 52 |
1622637 | 1622637 | 2021-08-16 | Labette | Kansas | 20099 | 3162 | 52 |
1624311 | 1624311 | 2021-08-16 | Wayne | Tennessee | 47181 | 3162 | 36 |
1524290 | 1524290 | 2021-07-17 | Lawrence | Alabama | 1079 | 3162 | 101 |
1520805 | 1520805 | 2021-07-15 | Warren | Virginia | 51187 | 3162 | 61 |
1515596 | 1515596 | 2021-07-14 | Muhlenberg | Kentucky | 21177 | 3162 | 68 |
1471016 | 1471016 | 2021-06-30 | Macon | North Carolina | 37113 | 3162 | 41 |
1437612 | 1437612 | 2021-06-20 | Bell | Kentucky | 21013 | 3162 | 58 |
1434365 | 1434365 | 2021-06-19 | Bell | Kentucky | 21013 | 3162 | 58 |
1435258 | 1435258 | 2021-06-19 | Washington | New York | 36115 | 3162 | 55 |
1430664 | 1430664 | 2021-06-18 | Hawaii | Hawaii | 15001 | 3162 | 54 |
1431119 | 1431119 | 2021-06-18 | Bell | Kentucky | 21013 | 3162 | 58 |
1432011 | 1432011 | 2021-06-18 | Washington | New York | 36115 | 3162 | 55 |
1428765 | 1428765 | 2021-06-17 | Washington | New York | 36115 | 3162 | 55 |
1425520 | 1425520 | 2021-06-16 | Washington | New York | 36115 | 3162 | 55 |
1422273 | 1422273 | 2021-06-15 | Washington | New York | 36115 | 3162 | 55 |
1387661 | 1387661 | 2021-06-04 | Isle of Wight | Virginia | 51093 | 3162 | 69 |
1384416 | 1384416 | 2021-06-03 | Isle of Wight | Virginia | 51093 | 3162 | 69 |
1381170 | 1381170 | 2021-06-02 | Isle of Wight | Virginia | 51093 | 3162 | 69 |
1377672 | 1377672 | 2021-06-01 | Hopkins | Texas | 48223 | 3162 | 112 |
1377925 | 1377925 | 2021-06-01 | Isle of Wight | Virginia | 51093 | 3162 | 69 |
1374679 | 1374679 | 2021-05-31 | Isle of Wight | Virginia | 51093 | 3162 | 69 |
1371434 | 1371434 | 2021-05-30 | Isle of Wight | Virginia | 51093 | 3162 | 69 |
1368188 | 1368188 | 2021-05-29 | Isle of Wight | Virginia | 51093 | 3162 | 69 |
1352264 | 1352264 | 2021-05-25 | Marion | Alabama | 1093 | 3162 | 102 |
1340523 | 1340523 | 2021-05-21 | Mecosta | Michigan | 26107 | 3162 | 32 |
1327349 | 1327349 | 2021-05-17 | Taylor | Kentucky | 21217 | 3162 | 48 |
1324133 | 1324133 | 2021-05-16 | East Feliciana | Louisiana | 22037 | 3162 | 112 |
1324469 | 1324469 | 2021-05-16 | Scott | Mississippi | 28123 | 3162 | 74 |
1324601 | 1324601 | 2021-05-16 | Warren | Missouri | 29219 | 3162 | 31 |
1320887 | 1320887 | 2021-05-15 | East Feliciana | Louisiana | 22037 | 3162 | 112 |
1321223 | 1321223 | 2021-05-15 | Scott | Mississippi | 28123 | 3162 | 74 |
1317640 | 1317640 | 2021-05-14 | East Feliciana | Louisiana | 22037 | 3162 | 112 |
1317977 | 1317977 | 2021-05-14 | Scott | Mississippi | 28123 | 3162 | 74 |
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);