ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
80 rows where cases = 4793 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 30
- Kentucky 12
- Georgia 6
- Wisconsin 5
- Illinois 4
- Indiana 4
- Ohio 4
- Texas 4
- West Virginia 4
- Louisiana 3
- Michigan 3
- Mississippi 3
- North Carolina 3
- Puerto Rico 3
- Kansas 2
- Minnesota 2
- New Hampshire 2
- New York 2
- South Dakota 2
- Alabama 1
- Arkansas 1
- Colorado 1
- Idaho 1
- Iowa 1
- Maryland 1
- Missouri 1
- Nevada 1
- New Mexico 1
- Pennsylvania 1
- Tennessee 1
- Virginia 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2431034 | 2431034 | 2022-04-21 | Barbour | West Virginia | 54001 | 4793 | 73 |
2424938 | 2424938 | 2022-04-20 | Elbert | Colorado | 8039 | 4793 | 37 |
2387955 | 2387955 | 2022-04-08 | Camuy | Puerto Rico | 72027 | 4793 | |
2370376 | 2370376 | 2022-04-03 | Garrard | Kentucky | 21079 | 4793 | 74 |
2367123 | 2367123 | 2022-04-02 | Garrard | Kentucky | 21079 | 4793 | 74 |
2363870 | 2363870 | 2022-04-01 | Garrard | Kentucky | 21079 | 4793 | 74 |
2360616 | 2360616 | 2022-03-31 | Garrard | Kentucky | 21079 | 4793 | 74 |
2357362 | 2357362 | 2022-03-30 | Garrard | Kentucky | 21079 | 4793 | 74 |
2354109 | 2354109 | 2022-03-29 | Garrard | Kentucky | 21079 | 4793 | 74 |
2350857 | 2350857 | 2022-03-28 | Garrard | Kentucky | 21079 | 4793 | 74 |
2331213 | 2331213 | 2022-03-22 | Dickinson | Kansas | 20041 | 4793 | 75 |
2331574 | 2331574 | 2022-03-22 | Iosco | Michigan | 26069 | 4793 | 138 |
2327961 | 2327961 | 2022-03-21 | Dickinson | Kansas | 20041 | 4793 | 75 |
2328322 | 2328322 | 2022-03-21 | Iosco | Michigan | 26069 | 4793 | 138 |
2268463 | 2268463 | 2022-03-02 | Taylor | Wisconsin | 55119 | 4793 | 68 |
2265210 | 2265210 | 2022-03-01 | Taylor | Wisconsin | 55119 | 4793 | 68 |
2239018 | 2239018 | 2022-02-21 | Radford city | Virginia | 51750 | 4793 | 45 |
2209832 | 2209832 | 2022-02-12 | Brooke | West Virginia | 54009 | 4793 | 97 |
2194969 | 2194969 | 2022-02-08 | Charlevoix | Michigan | 26029 | 4793 | 56 |
2179792 | 2179792 | 2022-02-03 | Cabo Rojo | Puerto Rico | 72023 | 4793 | |
2172078 | 2172078 | 2022-02-01 | Concordia | Louisiana | 22029 | 4793 | 85 |
2101856 | 2101856 | 2022-01-10 | Davison | South Dakota | 46035 | 4793 | 75 |
2028545 | 2028545 | 2021-12-19 | Saline | Illinois | 17165 | 4793 | 90 |
2025294 | 2025294 | 2021-12-18 | Saline | Illinois | 17165 | 4793 | 90 |
2022043 | 2022043 | 2021-12-17 | Saline | Illinois | 17165 | 4793 | 90 |
2009450 | 2009450 | 2021-12-13 | Ohio | Kentucky | 21183 | 4793 | 89 |
1994607 | 1994607 | 2021-12-08 | Lawrence | South Dakota | 46081 | 4793 | 69 |
1989577 | 1989577 | 2021-12-07 | Fayette | Indiana | 18041 | 4793 | 102 |
1986010 | 1986010 | 2021-12-06 | Butts | Georgia | 13035 | 4793 | 123 |
1979168 | 1979168 | 2021-12-04 | Winston | Alabama | 1133 | 4793 | 110 |
1924294 | 1924294 | 2021-11-17 | Gilmer | Georgia | 13123 | 4793 | 137 |
1924321 | 1924321 | 2021-11-17 | Lee | Georgia | 13177 | 4793 | 80 |
1912748 | 1912748 | 2021-11-13 | Wyoming | New York | 36121 | 4793 | 62 |
1875533 | 1875533 | 2021-11-02 | Decatur | Georgia | 13087 | 4793 | 100 |
1860703 | 1860703 | 2021-10-28 | Allegany | New York | 36003 | 4793 | 100 |
1810600 | 1810600 | 2021-10-13 | Lumpkin | Georgia | 13187 | 4793 | 97 |
1796568 | 1796568 | 2021-10-08 | Fannin | Texas | 48147 | 4793 | 138 |
1680338 | 1680338 | 2021-09-03 | Unknown | Arkansas | 4793 | 0 | |
1556669 | 1556669 | 2021-07-26 | Monroe | Wisconsin | 55081 | 4793 | 49 |
1533614 | 1533614 | 2021-07-19 | Wilson | Texas | 48493 | 4793 | 70 |
1529089 | 1529089 | 2021-07-18 | Scott | Missouri | 29201 | 4793 | 88 |
1530367 | 1530367 | 2021-07-18 | Wilson | Texas | 48493 | 4793 | 70 |
1527120 | 1527120 | 2021-07-17 | Wilson | Texas | 48493 | 4793 | 70 |
1519890 | 1519890 | 2021-07-15 | Shelby | Ohio | 39149 | 4793 | 97 |
1507166 | 1507166 | 2021-07-11 | Toa Alta | Puerto Rico | 72135 | 4793 | |
1489286 | 1489286 | 2021-07-06 | Lawrence | Indiana | 18093 | 4793 | 128 |
1460380 | 1460380 | 2021-06-27 | Jessamine | Kentucky | 21113 | 4793 | 72 |
1457135 | 1457135 | 2021-06-26 | Jessamine | Kentucky | 21113 | 4793 | 72 |
1453890 | 1453890 | 2021-06-25 | Jessamine | Kentucky | 21113 | 4793 | 72 |
1452702 | 1452702 | 2021-06-24 | Jefferson | West Virginia | 54037 | 4793 | 57 |
1449456 | 1449456 | 2021-06-23 | Jefferson | West Virginia | 54037 | 4793 | 57 |
1363062 | 1363062 | 2021-05-28 | Shelby | Kentucky | 21211 | 4793 | 71 |
1350142 | 1350142 | 2021-05-24 | St. Mary | Louisiana | 22101 | 4793 | 139 |
1330837 | 1330837 | 2021-05-18 | Goodhue | Minnesota | 27049 | 4793 | 72 |
1278963 | 1278963 | 2021-05-02 | Bolivar | Mississippi | 28011 | 4793 | 131 |
1275716 | 1275716 | 2021-05-01 | Bolivar | Mississippi | 28011 | 4793 | 131 |
1272469 | 1272469 | 2021-04-30 | Bolivar | Mississippi | 28011 | 4793 | 131 |
1263076 | 1263076 | 2021-04-27 | Elko | Nevada | 32007 | 4793 | 56 |
1250386 | 1250386 | 2021-04-23 | Auglaize | Ohio | 39011 | 4793 | 83 |
1235894 | 1235894 | 2021-04-19 | Bingham | Idaho | 16011 | 4793 | 73 |
1174150 | 1174150 | 2021-03-31 | Tift | Georgia | 13277 | 4793 | 123 |
1167867 | 1167867 | 2021-03-29 | Jackson | Indiana | 18071 | 4793 | 68 |
1163828 | 1163828 | 2021-03-27 | Oconto | Wisconsin | 55083 | 4793 | 56 |
1120360 | 1120360 | 2021-03-14 | Edgecombe | North Carolina | 37065 | 4793 | 100 |
1117113 | 1117113 | 2021-03-13 | Edgecombe | North Carolina | 37065 | 4793 | 100 |
1049287 | 1049287 | 2021-02-20 | Carbon | Pennsylvania | 42025 | 4793 | 146 |
1016503 | 1016503 | 2021-02-10 | Halifax | North Carolina | 37083 | 4793 | 88 |
1009886 | 1009886 | 2021-02-08 | Curry | New Mexico | 35009 | 4793 | 61 |
995973 | 995973 | 2021-02-04 | Webster | Iowa | 19187 | 4793 | 81 |
993977 | 993977 | 2021-02-03 | Union | Ohio | 39159 | 4793 | 33 |
984661 | 984661 | 2021-01-31 | Hawkins | Tennessee | 47073 | 4793 | 84 |
926891 | 926891 | 2021-01-13 | Shawano | Wisconsin | 55115 | 4793 | 74 |
886523 | 886523 | 2021-01-01 | Merrimack | New Hampshire | 33013 | 4793 | 64 |
883278 | 883278 | 2020-12-31 | Merrimack | New Hampshire | 33013 | 4793 | 64 |
865965 | 865965 | 2020-12-26 | Whiteside | Illinois | 17195 | 4793 | 154 |
853408 | 853408 | 2020-12-22 | Acadia | Louisiana | 22001 | 4793 | 134 |
840639 | 840639 | 2020-12-18 | Blue Earth | Minnesota | 27013 | 4793 | 22 |
561050 | 561050 | 2020-09-23 | Hamilton | Indiana | 18057 | 4793 | 118 |
532400 | 532400 | 2020-09-14 | Howard | Maryland | 24027 | 4793 | 119 |
162207 | 162207 | 2020-05-20 | Franklin | Ohio | 39049 | 4793 | 200 |
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);