ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
91 rows where cases = 4726 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Tennessee 16
- Georgia 9
- North Carolina 7
- Oklahoma 7
- Illinois 4
- Missouri 4
- Pennsylvania 4
- Texas 4
- Alabama 3
- Ohio 3
- Arkansas 2
- Florida 2
- Kentucky 2
- Louisiana 2
- Nebraska 2
- New York 2
- Virginia 2
- Washington 2
- Wisconsin 2
- California 1
- Colorado 1
- Idaho 1
- Indiana 1
- Michigan 1
- Mississippi 1
- Montana 1
- Oregon 1
- Puerto Rico 1
- Utah 1
- West Virginia 1
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2450752 | 2450752 | 2022-04-28 | Hale | Alabama | 1065 | 4726 | 106 |
2453440 | 2453440 | 2022-04-28 | Gonzales | Texas | 48177 | 4726 | 99 |
2397014 | 2397014 | 2022-04-11 | Lincoln | Montana | 30053 | 4726 | 86 |
2281815 | 2281815 | 2022-03-07 | Teller | Colorado | 8119 | 4726 | 55 |
2262609 | 2262609 | 2022-03-01 | Clay | Illinois | 17025 | 4726 | 70 |
2259797 | 2259797 | 2022-02-28 | Henry | Kentucky | 21103 | 4726 | 46 |
2252406 | 2252406 | 2022-02-26 | Phillips | Arkansas | 5107 | 4726 | 93 |
2210512 | 2210512 | 2022-02-13 | Union | Georgia | 13291 | 4726 | 142 |
2207259 | 2207259 | 2022-02-12 | Union | Georgia | 13291 | 4726 | 142 |
2204006 | 2204006 | 2022-02-11 | Union | Georgia | 13291 | 4726 | 142 |
2187057 | 2187057 | 2022-02-05 | Brooke | West Virginia | 54009 | 4726 | 97 |
2179708 | 2179708 | 2022-02-03 | Union | Oregon | 41061 | 4726 | 67 |
2129767 | 2129767 | 2022-01-19 | Assumption | Louisiana | 22007 | 4726 | 58 |
2130336 | 2130336 | 2022-01-19 | Dawson | Nebraska | 31047 | 4726 | 39 |
2127938 | 2127938 | 2022-01-18 | DeKalb | Tennessee | 47041 | 4726 | 87 |
2124686 | 2124686 | 2022-01-17 | DeKalb | Tennessee | 47041 | 4726 | 87 |
2121434 | 2121434 | 2022-01-16 | DeKalb | Tennessee | 47041 | 4726 | 87 |
2118182 | 2118182 | 2022-01-15 | DeKalb | Tennessee | 47041 | 4726 | 87 |
2113985 | 2113985 | 2022-01-14 | Stone | Missouri | 29209 | 4726 | 101 |
2114765 | 2114765 | 2022-01-14 | Moca | Puerto Rico | 72099 | 4726 | |
2114931 | 2114931 | 2022-01-14 | DeKalb | Tennessee | 47041 | 4726 | 87 |
2111679 | 2111679 | 2022-01-13 | DeKalb | Tennessee | 47041 | 4726 | 87 |
2108427 | 2108427 | 2022-01-12 | DeKalb | Tennessee | 47041 | 4726 | 87 |
2014599 | 2014599 | 2021-12-14 | Isle of Wight | Virginia | 51093 | 4726 | 93 |
1996957 | 1996957 | 2021-12-09 | Stoddard | Missouri | 29207 | 4726 | 107 |
1994071 | 1994071 | 2021-12-08 | Montgomery | North Carolina | 37123 | 4726 | 110 |
1961525 | 1961525 | 2021-11-28 | Cherokee | North Carolina | 37039 | 4726 | 78 |
1962170 | 1962170 | 2021-11-28 | Hickman | Tennessee | 47081 | 4726 | 78 |
1958274 | 1958274 | 2021-11-27 | Cherokee | North Carolina | 37039 | 4726 | 78 |
1958919 | 1958919 | 2021-11-27 | Hickman | Tennessee | 47081 | 4726 | 78 |
1955023 | 1955023 | 2021-11-26 | Cherokee | North Carolina | 37039 | 4726 | 78 |
1955668 | 1955668 | 2021-11-26 | Hickman | Tennessee | 47081 | 4726 | 78 |
1951772 | 1951772 | 2021-11-25 | Cherokee | North Carolina | 37039 | 4726 | 78 |
1952417 | 1952417 | 2021-11-25 | Hickman | Tennessee | 47081 | 4726 | 78 |
1948521 | 1948521 | 2021-11-24 | Cherokee | North Carolina | 37039 | 4726 | 78 |
1949166 | 1949166 | 2021-11-24 | Hickman | Tennessee | 47081 | 4726 | 78 |
1920780 | 1920780 | 2021-11-16 | Yell | Arkansas | 5149 | 4726 | 80 |
1877274 | 1877274 | 2021-11-02 | Garvin | Oklahoma | 40049 | 4726 | 100 |
1872998 | 1872998 | 2021-11-01 | Jefferson Davis | Louisiana | 22053 | 4726 | 126 |
1874025 | 1874025 | 2021-11-01 | Garvin | Oklahoma | 40049 | 4726 | 100 |
1870776 | 1870776 | 2021-10-31 | Garvin | Oklahoma | 40049 | 4726 | 100 |
1867527 | 1867527 | 2021-10-30 | Garvin | Oklahoma | 40049 | 4726 | 100 |
1864278 | 1864278 | 2021-10-29 | Garvin | Oklahoma | 40049 | 4726 | 100 |
1861029 | 1861029 | 2021-10-28 | Garvin | Oklahoma | 40049 | 4726 | 100 |
1857780 | 1857780 | 2021-10-27 | Garvin | Oklahoma | 40049 | 4726 | 100 |
1837585 | 1837585 | 2021-10-21 | Scott | Mississippi | 28123 | 4726 | 98 |
1816626 | 1816626 | 2021-10-15 | Clarke | Alabama | 1025 | 4726 | 81 |
1813378 | 1813378 | 2021-10-14 | Clarke | Alabama | 1025 | 4726 | 81 |
1792518 | 1792518 | 2021-10-07 | Tioga | New York | 36107 | 4726 | 68 |
1763692 | 1763692 | 2021-09-28 | Perry | Pennsylvania | 42099 | 4726 | 106 |
1725634 | 1725634 | 2021-09-16 | Teton | Wyoming | 56039 | 4726 | 11 |
1720159 | 1720159 | 2021-09-15 | Calloway | Kentucky | 21035 | 4726 | 56 |
1695739 | 1695739 | 2021-09-07 | Macon | Tennessee | 47111 | 4726 | 80 |
1678783 | 1678783 | 2021-09-02 | Montgomery | New York | 36057 | 4726 | 131 |
1678978 | 1678978 | 2021-09-02 | Brown | Ohio | 39015 | 4726 | 65 |
1621044 | 1621044 | 2021-08-15 | Rhea | Tennessee | 47143 | 4726 | 83 |
1617796 | 1617796 | 2021-08-14 | Rhea | Tennessee | 47143 | 4726 | 83 |
1614548 | 1614548 | 2021-08-13 | Rhea | Tennessee | 47143 | 4726 | 83 |
1608903 | 1608903 | 2021-08-12 | Lake | California | 6033 | 4726 | 68 |
1523789 | 1523789 | 2021-07-16 | Medina | Texas | 48325 | 4726 | 107 |
1501145 | 1501145 | 2021-07-09 | Wilson | Texas | 48493 | 4726 | 69 |
1364089 | 1364089 | 2021-05-28 | Shelby | Ohio | 39149 | 4726 | 94 |
1326665 | 1326665 | 2021-05-17 | Colquitt | Georgia | 13071 | 4726 | 121 |
1313679 | 1313679 | 2021-05-13 | Colquitt | Georgia | 13071 | 4726 | 121 |
1304140 | 1304140 | 2021-05-10 | Effingham | Illinois | 17049 | 4726 | 83 |
1243373 | 1243373 | 2021-04-21 | Johnson | Missouri | 29101 | 4726 | 50 |
1227182 | 1227182 | 2021-04-16 | Scott | Missouri | 29201 | 4726 | 83 |
1224635 | 1224635 | 2021-04-15 | Huntingdon | Pennsylvania | 42061 | 4726 | 128 |
1190420 | 1190420 | 2021-04-05 | Bingham | Idaho | 16011 | 4726 | 69 |
1164519 | 1164519 | 2021-03-28 | Jackson | Illinois | 17077 | 4726 | 73 |
1163802 | 1163802 | 2021-03-27 | Dunn | Wisconsin | 55033 | 4726 | 30 |
1148914 | 1148914 | 2021-03-23 | Grand Traverse | Michigan | 26055 | 4726 | 75 |
1141888 | 1141888 | 2021-03-21 | Jackson | Indiana | 18071 | 4726 | 68 |
1096225 | 1096225 | 2021-03-07 | Tift | Georgia | 13277 | 4726 | 120 |
1062098 | 1062098 | 2021-02-24 | Jefferson | Ohio | 39081 | 4726 | 107 |
1052222 | 1052222 | 2021-02-21 | McDowell | North Carolina | 37111 | 4726 | 55 |
1010965 | 1010965 | 2021-02-08 | Summit | Utah | 49043 | 4726 | 7 |
979309 | 979309 | 2021-01-30 | Habersham | Georgia | 13137 | 4726 | 122 |
914484 | 914484 | 2021-01-10 | Walker | Georgia | 13295 | 4726 | 60 |
878693 | 878693 | 2020-12-30 | Fayette | Georgia | 13113 | 4726 | 75 |
878221 | 878221 | 2020-12-29 | Waupaca | Wisconsin | 55135 | 4726 | 135 |
862371 | 862371 | 2020-12-25 | Highlands | Florida | 12055 | 4726 | 198 |
859126 | 859126 | 2020-12-24 | Highlands | Florida | 12055 | 4726 | 198 |
855347 | 855347 | 2020-12-22 | Chelan | Washington | 53007 | 4726 | 35 |
816172 | 816172 | 2020-12-10 | Starr | Texas | 48427 | 4726 | 192 |
782597 | 782597 | 2020-11-30 | Hall | Nebraska | 31079 | 4726 | 70 |
757222 | 757222 | 2020-11-22 | Lackawanna | Pennsylvania | 42069 | 4726 | 230 |
741620 | 741620 | 2020-11-17 | Alexandria city | Virginia | 51510 | 4726 | 76 |
634704 | 634704 | 2020-10-15 | Franklin | Washington | 53021 | 4726 | 68 |
431697 | 431697 | 2020-08-14 | St. Clair | Illinois | 17163 | 4726 | 162 |
165414 | 165414 | 2020-05-21 | Bucks | Pennsylvania | 42017 | 4726 | 442 |
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);