ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
138 rows where cases = 3581 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Tennessee 16
- Ohio 11
- Virginia 10
- Michigan 9
- Iowa 7
- Indiana 6
- Kentucky 6
- Texas 6
- Alabama 5
- Louisiana 5
- Missouri 4
- New York 4
- West Virginia 4
- Wisconsin 4
- Arkansas 3
- Georgia 3
- Idaho 3
- Illinois 3
- New Mexico 3
- Oregon 3
- South Dakota 3
- California 2
- New Jersey 2
- North Dakota 2
- Oklahoma 2
- Alaska 1
- Arizona 1
- Florida 1
- Maine 1
- Maryland 1
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2399916 | 2399916 | 2022-04-12 | Leelanau | Michigan | 26089 | 3581 | 53 |
2396504 | 2396504 | 2022-04-11 | Caldwell | Louisiana | 22021 | 3581 | 55 |
2396660 | 2396660 | 2022-04-11 | Leelanau | Michigan | 26089 | 3581 | 53 |
2393249 | 2393249 | 2022-04-10 | Caldwell | Louisiana | 22021 | 3581 | 55 |
2393405 | 2393405 | 2022-04-10 | Leelanau | Michigan | 26089 | 3581 | 53 |
2389993 | 2389993 | 2022-04-09 | Caldwell | Louisiana | 22021 | 3581 | 55 |
2390149 | 2390149 | 2022-04-09 | Leelanau | Michigan | 26089 | 3581 | 53 |
2386737 | 2386737 | 2022-04-08 | Caldwell | Louisiana | 22021 | 3581 | 55 |
2386893 | 2386893 | 2022-04-08 | Leelanau | Michigan | 26089 | 3581 | 53 |
2383638 | 2383638 | 2022-04-07 | Leelanau | Michigan | 26089 | 3581 | 53 |
2380383 | 2380383 | 2022-04-06 | Leelanau | Michigan | 26089 | 3581 | 53 |
2335111 | 2335111 | 2022-03-23 | Madison | Missouri | 29123 | 3581 | 57 |
2336188 | 2336188 | 2022-03-23 | Bandera | Texas | 48019 | 3581 | 75 |
2304905 | 2304905 | 2022-03-14 | Greene | Illinois | 17061 | 3581 | 57 |
2241279 | 2241279 | 2022-02-22 | Ramsey | North Dakota | 38071 | 3581 | 54 |
2241789 | 2241789 | 2022-02-22 | Decatur | Tennessee | 47039 | 3581 | 60 |
2238538 | 2238538 | 2022-02-21 | Decatur | Tennessee | 47039 | 3581 | 60 |
2235287 | 2235287 | 2022-02-20 | Decatur | Tennessee | 47039 | 3581 | 60 |
2232036 | 2232036 | 2022-02-19 | Decatur | Tennessee | 47039 | 3581 | 60 |
2228785 | 2228785 | 2022-02-18 | Decatur | Tennessee | 47039 | 3581 | 60 |
2225534 | 2225534 | 2022-02-17 | Decatur | Tennessee | 47039 | 3581 | 60 |
2220497 | 2220497 | 2022-02-16 | Parke | Indiana | 18121 | 3581 | 45 |
2222283 | 2222283 | 2022-02-16 | Decatur | Tennessee | 47039 | 3581 | 60 |
2216335 | 2216335 | 2022-02-14 | Braxton | West Virginia | 54007 | 3581 | 38 |
2178039 | 2178039 | 2022-02-03 | Minidoka | Idaho | 16067 | 3581 | 55 |
2176038 | 2176038 | 2022-02-02 | Socorro | New Mexico | 35053 | 3581 | 79 |
2154804 | 2154804 | 2022-01-27 | Franklin | Arkansas | 5047 | 3581 | 62 |
2151560 | 2151560 | 2022-01-26 | Izard | Arkansas | 5065 | 3581 | 62 |
2148994 | 2148994 | 2022-01-25 | Fayette | Iowa | 19065 | 3581 | 63 |
2145742 | 2145742 | 2022-01-24 | Fayette | Iowa | 19065 | 3581 | 63 |
2142487 | 2142487 | 2022-01-23 | Fayette | Iowa | 19065 | 3581 | 63 |
2139232 | 2139232 | 2022-01-22 | Fayette | Iowa | 19065 | 3581 | 63 |
2135976 | 2135976 | 2022-01-21 | Fayette | Iowa | 19065 | 3581 | 63 |
2132591 | 2132591 | 2022-01-20 | Warren | Illinois | 17187 | 3581 | 79 |
2132724 | 2132724 | 2022-01-20 | Fayette | Iowa | 19065 | 3581 | 63 |
2129471 | 2129471 | 2022-01-19 | Fayette | Iowa | 19065 | 3581 | 63 |
2081437 | 2081437 | 2022-01-04 | New Madrid | Missouri | 29143 | 3581 | 71 |
2060480 | 2060480 | 2021-12-29 | Clark | Arkansas | 5019 | 3581 | 66 |
2010823 | 2010823 | 2021-12-13 | Beadle | South Dakota | 46005 | 3581 | 48 |
1962141 | 1962141 | 2021-11-28 | Chester | Tennessee | 47023 | 3581 | 76 |
1958890 | 1958890 | 2021-11-27 | Chester | Tennessee | 47023 | 3581 | 76 |
1955639 | 1955639 | 2021-11-26 | Chester | Tennessee | 47023 | 3581 | 76 |
1952388 | 1952388 | 2021-11-25 | Chester | Tennessee | 47023 | 3581 | 76 |
1949137 | 1949137 | 2021-11-24 | Chester | Tennessee | 47023 | 3581 | 76 |
1945886 | 1945886 | 2021-11-23 | Chester | Tennessee | 47023 | 3581 | 76 |
1940629 | 1940629 | 2021-11-22 | Union | Georgia | 13291 | 3581 | 129 |
1943208 | 1943208 | 2021-11-22 | Hampshire | West Virginia | 54027 | 3581 | 50 |
1938995 | 1938995 | 2021-11-21 | Wyandot | Ohio | 39175 | 3581 | 71 |
1893979 | 1893979 | 2021-11-07 | Austin | Texas | 48015 | 3581 | 54 |
1836856 | 1836856 | 2021-10-21 | LaGrange | Indiana | 18087 | 3581 | 80 |
1835912 | 1835912 | 2021-10-20 | Waynesboro city | Virginia | 51820 | 3581 | 44 |
1769097 | 1769097 | 2021-09-30 | Queen Anne's | Maryland | 24035 | 3581 | 64 |
1763857 | 1763857 | 2021-09-28 | Davison | South Dakota | 46035 | 3581 | 69 |
1666908 | 1666908 | 2021-08-29 | Isle of Wight | Virginia | 51093 | 3581 | 72 |
1663660 | 1663660 | 2021-08-28 | Isle of Wight | Virginia | 51093 | 3581 | 72 |
1659027 | 1659027 | 2021-08-27 | Stone | Missouri | 29209 | 3581 | 62 |
1660412 | 1660412 | 2021-08-27 | Isle of Wight | Virginia | 51093 | 3581 | 72 |
1653829 | 1653829 | 2021-08-25 | Uintah | Utah | 49047 | 3581 | 31 |
1631427 | 1631427 | 2021-08-18 | Sheridan | Wyoming | 56033 | 3581 | 33 |
1625612 | 1625612 | 2021-08-17 | Perry | Illinois | 17145 | 3581 | 72 |
1602767 | 1602767 | 2021-08-10 | Bonner | Idaho | 16017 | 3581 | 46 |
1597935 | 1597935 | 2021-08-08 | Benton | Oregon | 41003 | 3581 | 22 |
1594686 | 1594686 | 2021-08-07 | Benton | Oregon | 41003 | 3581 | 22 |
1591437 | 1591437 | 2021-08-06 | Benton | Oregon | 41003 | 3581 | 22 |
1588009 | 1588009 | 2021-08-05 | Stutsman | North Dakota | 38093 | 3581 | 82 |
1539055 | 1539055 | 2021-07-21 | Cibola | New Mexico | 35006 | 3581 | 128 |
1535808 | 1535808 | 2021-07-20 | Cibola | New Mexico | 35006 | 3581 | 128 |
1521015 | 1521015 | 2021-07-16 | Clarke | Alabama | 1025 | 3581 | 62 |
1462771 | 1462771 | 2021-06-28 | Lake | California | 6033 | 3581 | 56 |
1437623 | 1437623 | 2021-06-20 | Calloway | Kentucky | 21035 | 3581 | 49 |
1434376 | 1434376 | 2021-06-19 | Calloway | Kentucky | 21035 | 3581 | 49 |
1431130 | 1431130 | 2021-06-18 | Calloway | Kentucky | 21035 | 3581 | 49 |
1427885 | 1427885 | 2021-06-17 | Calloway | Kentucky | 21035 | 3581 | 49 |
1424640 | 1424640 | 2021-06-16 | Calloway | Kentucky | 21035 | 3581 | 49 |
1419030 | 1419030 | 2021-06-14 | Wyoming | New York | 36121 | 3581 | 53 |
1415785 | 1415785 | 2021-06-13 | Wyoming | New York | 36121 | 3581 | 53 |
1412539 | 1412539 | 2021-06-12 | Wyoming | New York | 36121 | 3581 | 53 |
1396506 | 1396506 | 2021-06-07 | Highland | Ohio | 39071 | 3581 | 65 |
1393259 | 1393259 | 2021-06-06 | Highland | Ohio | 39071 | 3581 | 65 |
1390014 | 1390014 | 2021-06-05 | Highland | Ohio | 39071 | 3581 | 65 |
1386769 | 1386769 | 2021-06-04 | Highland | Ohio | 39071 | 3581 | 65 |
1373787 | 1373787 | 2021-05-31 | Highland | Ohio | 39071 | 3581 | 63 |
1370542 | 1370542 | 2021-05-30 | Highland | Ohio | 39071 | 3581 | 63 |
1336004 | 1336004 | 2021-05-20 | Dallas | Alabama | 1047 | 3581 | 153 |
1329094 | 1329094 | 2021-05-17 | Uvalde | Texas | 48463 | 3581 | 72 |
1325848 | 1325848 | 2021-05-16 | Uvalde | Texas | 48463 | 3581 | 72 |
1322602 | 1322602 | 2021-05-15 | Uvalde | Texas | 48463 | 3581 | 72 |
1316509 | 1316509 | 2021-05-14 | Chambers | Alabama | 1017 | 3581 | 123 |
1289065 | 1289065 | 2021-05-05 | Cheshire | New Hampshire | 33005 | 3581 | 33 |
1274097 | 1274097 | 2021-04-30 | Tazewell | Virginia | 51185 | 3581 | 66 |
1261236 | 1261236 | 2021-04-26 | Green | Wisconsin | 55045 | 3581 | 23 |
1257989 | 1257989 | 2021-04-25 | Green | Wisconsin | 55045 | 3581 | 23 |
1225057 | 1225057 | 2021-04-15 | Grimes | Texas | 48185 | 3581 | 66 |
1225399 | 1225399 | 2021-04-15 | York | Virginia | 51199 | 3581 | 50 |
1218173 | 1218173 | 2021-04-13 | Wayne | Pennsylvania | 42127 | 3581 | 75 |
1203632 | 1203632 | 2021-04-09 | Steuben | Indiana | 18151 | 3581 | 59 |
1202678 | 1202678 | 2021-04-08 | Grays Harbor | Washington | 53027 | 3581 | 58 |
1190047 | 1190047 | 2021-04-05 | Amador | California | 6005 | 3581 | 45 |
1136784 | 1136784 | 2021-03-19 | Preble | Ohio | 39135 | 3581 | 93 |
1128957 | 1128957 | 2021-03-17 | Whitley | Indiana | 18183 | 3581 | 39 |
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);