ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
56 rows where cases = 7028 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 25
- Iowa 7
- Ohio 6
- Alabama 4
- Arkansas 4
- Minnesota 4
- Mississippi 4
- Puerto Rico 4
- Michigan 3
- Florida 2
- Illinois 2
- Texas 2
- Colorado 1
- Georgia 1
- Indiana 1
- Kentucky 1
- Maryland 1
- Missouri 1
- New Hampshire 1
- New York 1
- North Carolina 1
- Oregon 1
- Rhode Island 1
- Virginia 1
- Washington 1
- West Virginia 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2348901 | 2348901 | 2022-03-27 | Aguadilla | Puerto Rico | 72005 | 7028 | |
2325118 | 2325118 | 2022-03-20 | Wexford | Michigan | 26165 | 7028 | 105 |
2321864 | 2321864 | 2022-03-19 | Wexford | Michigan | 26165 | 7028 | 105 |
2318610 | 2318610 | 2022-03-18 | Wexford | Michigan | 26165 | 7028 | 105 |
2315399 | 2315399 | 2022-03-17 | Lyon | Minnesota | 27083 | 7028 | 72 |
2264360 | 2264360 | 2022-03-01 | Gurabo | Puerto Rico | 72063 | 7028 | |
2258922 | 2258922 | 2022-02-28 | St. Francis | Arkansas | 5123 | 7028 | 84 |
2261110 | 2261110 | 2022-02-28 | Gurabo | Puerto Rico | 72063 | 7028 | |
2255671 | 2255671 | 2022-02-27 | St. Francis | Arkansas | 5123 | 7028 | 84 |
2252420 | 2252420 | 2022-02-26 | St. Francis | Arkansas | 5123 | 7028 | 83 |
2249003 | 2249003 | 2022-02-25 | Clarke | Alabama | 1025 | 7028 | 96 |
2251087 | 2251087 | 2022-02-25 | Hardin | Ohio | 39065 | 7028 | 146 |
2251754 | 2251754 | 2022-02-25 | Kleberg | Texas | 48273 | 7028 | 140 |
2246367 | 2246367 | 2022-02-24 | Fayette | Illinois | 17051 | 7028 | 96 |
2242372 | 2242372 | 2022-02-22 | Nicholas | West Virginia | 54067 | 7028 | 88 |
2214660 | 2214660 | 2022-02-14 | Copiah | Mississippi | 28029 | 7028 | 106 |
2192391 | 2192391 | 2022-02-07 | Dare | North Carolina | 37055 | 7028 | 21 |
2188648 | 2188648 | 2022-02-06 | Itawamba | Mississippi | 28057 | 7028 | 126 |
2185395 | 2185395 | 2022-02-05 | Itawamba | Mississippi | 28057 | 7028 | 126 |
2182143 | 2182143 | 2022-02-04 | Itawamba | Mississippi | 28057 | 7028 | 126 |
2126268 | 2126268 | 2022-01-18 | Sioux | Iowa | 19167 | 7028 | 78 |
2123016 | 2123016 | 2022-01-17 | Sioux | Iowa | 19167 | 7028 | 78 |
2119764 | 2119764 | 2022-01-16 | Sioux | Iowa | 19167 | 7028 | 78 |
2116512 | 2116512 | 2022-01-15 | Sioux | Iowa | 19167 | 7028 | 78 |
2113261 | 2113261 | 2022-01-14 | Sioux | Iowa | 19167 | 7028 | 78 |
2110009 | 2110009 | 2022-01-13 | Sioux | Iowa | 19167 | 7028 | 78 |
2106758 | 2106758 | 2022-01-12 | Sioux | Iowa | 19167 | 7028 | 78 |
2083907 | 2083907 | 2022-01-05 | Wabash | Indiana | 18169 | 7028 | 131 |
2059259 | 2059259 | 2021-12-28 | Williams | Ohio | 39171 | 7028 | 114 |
2056262 | 2056262 | 2021-12-27 | Toa Alta | Puerto Rico | 72135 | 7028 | |
2050638 | 2050638 | 2021-12-26 | Escambia | Alabama | 1053 | 7028 | 148 |
2042938 | 2042938 | 2021-12-23 | Clinton | Ohio | 39027 | 7028 | 112 |
2029238 | 2029238 | 2021-12-19 | Morrison | Minnesota | 27097 | 7028 | 84 |
2025987 | 2025987 | 2021-12-18 | Morrison | Minnesota | 27097 | 7028 | 84 |
2022736 | 2022736 | 2021-12-17 | Morrison | Minnesota | 27097 | 7028 | 84 |
1910900 | 1910900 | 2021-11-13 | Russell | Alabama | 1113 | 7028 | 63 |
1863971 | 1863971 | 2021-10-29 | Herkimer | New York | 36043 | 7028 | 129 |
1813427 | 1813427 | 2021-10-14 | Tallapoosa | Alabama | 1123 | 7028 | 194 |
1788416 | 1788416 | 2021-10-06 | Graves | Kentucky | 21083 | 7028 | 120 |
1762957 | 1762957 | 2021-09-28 | Pettis | Missouri | 29159 | 7028 | 98 |
1745768 | 1745768 | 2021-09-23 | Grundy | Illinois | 17063 | 7028 | 85 |
1408595 | 1408595 | 2021-06-11 | Allegany | Maryland | 24001 | 7028 | 212 |
1403962 | 1403962 | 2021-06-09 | Chelan | Washington | 53007 | 7028 | 68 |
1360772 | 1360772 | 2021-05-27 | Ashtabula | Ohio | 39007 | 7028 | 176 |
1140901 | 1140901 | 2021-03-20 | Lynchburg city | Virginia | 51680 | 7028 | 144 |
1114011 | 1114011 | 2021-03-12 | Erie | Ohio | 39043 | 7028 | 150 |
1070121 | 1070121 | 2021-02-27 | Walton | Florida | 12131 | 7028 | 81 |
1071520 | 1071520 | 2021-02-27 | Strafford | New Hampshire | 33017 | 7028 | 74 |
1037460 | 1037460 | 2021-02-17 | White | Arkansas | 5145 | 7028 | 102 |
998775 | 998775 | 2021-02-05 | Fayette | Georgia | 13113 | 7028 | 114 |
968126 | 968126 | 2021-01-26 | Umatilla | Oregon | 41059 | 7028 | 74 |
938787 | 938787 | 2021-01-17 | Pickaway | Ohio | 39129 | 7028 | 50 |
868860 | 868860 | 2020-12-27 | Hernando | Florida | 12053 | 7028 | 264 |
758468 | 758468 | 2020-11-23 | Pueblo | Colorado | 8101 | 7028 | 82 |
540395 | 540395 | 2020-09-16 | Jefferson | Texas | 48245 | 7028 | 125 |
111728 | 111728 | 2020-05-03 | Providence | Rhode Island | 44007 | 7028 | 265 |
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);