ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
81 rows where cases = 6119 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Wisconsin 9
- North Carolina 8
- Iowa 7
- Oklahoma 7
- Nebraska 5
- Arkansas 3
- Florida 3
- New York 3
- Alabama 2
- Colorado 2
- Georgia 2
- Idaho 2
- Indiana 2
- Louisiana 2
- Maryland 2
- New Jersey 2
- Ohio 2
- Puerto Rico 2
- Tennessee 2
- California 1
- Illinois 1
- Kentucky 1
- Maine 1
- Michigan 1
- Minnesota 1
- Mississippi 1
- New Mexico 1
- Oregon 1
- Pennsylvania 1
- South Carolina 1
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2474723 | 2474723 | 2022-05-05 | Caroline | Maryland | 24011 | 6119 | 80 |
2466738 | 2466738 | 2022-05-02 | Hopewell city | Virginia | 51670 | 6119 | 119 |
2425875 | 2425875 | 2022-04-20 | Waldo | Maine | 23027 | 6119 | 57 |
2387965 | 2387965 | 2022-04-08 | Corozal | Puerto Rico | 72047 | 6119 | |
2361571 | 2361571 | 2022-03-31 | Transylvania | North Carolina | 37175 | 6119 | 71 |
2358317 | 2358317 | 2022-03-30 | Transylvania | North Carolina | 37175 | 6119 | 71 |
2327331 | 2327331 | 2022-03-21 | Montezuma | Colorado | 8083 | 6119 | 72 |
2318967 | 2318967 | 2022-03-18 | Cass | Nebraska | 31025 | 6119 | 40 |
2315714 | 2315714 | 2022-03-17 | Cass | Nebraska | 31025 | 6119 | 40 |
2302705 | 2302705 | 2022-03-13 | Cass | Nebraska | 31025 | 6119 | 40 |
2299453 | 2299453 | 2022-03-12 | Cass | Nebraska | 31025 | 6119 | 40 |
2296201 | 2296201 | 2022-03-11 | Cass | Nebraska | 31025 | 6119 | 40 |
2219762 | 2219762 | 2022-02-16 | Geneva | Alabama | 1061 | 6119 | 148 |
2191824 | 2191824 | 2022-02-07 | Le Sueur | Minnesota | 27079 | 6119 | 47 |
2184073 | 2184073 | 2022-02-05 | Cleburne | Arkansas | 5023 | 6119 | 109 |
2180821 | 2180821 | 2022-02-04 | Cleburne | Arkansas | 5023 | 6119 | 109 |
2155829 | 2155829 | 2022-01-27 | Plaquemines | Louisiana | 22075 | 6119 | 42 |
2145707 | 2145707 | 2022-01-24 | Wells | Indiana | 18179 | 6119 | 126 |
2130576 | 2130576 | 2022-01-19 | Dare | North Carolina | 37055 | 6119 | 18 |
2127560 | 2127560 | 2022-01-18 | Custer | Oklahoma | 40039 | 6119 | 137 |
2124308 | 2124308 | 2022-01-17 | Custer | Oklahoma | 40039 | 6119 | 137 |
2121056 | 2121056 | 2022-01-16 | Custer | Oklahoma | 40039 | 6119 | 137 |
2117804 | 2117804 | 2022-01-15 | Custer | Oklahoma | 40039 | 6119 | 137 |
2114553 | 2114553 | 2022-01-14 | Custer | Oklahoma | 40039 | 6119 | 137 |
2111301 | 2111301 | 2022-01-13 | Custer | Oklahoma | 40039 | 6119 | 137 |
2108049 | 2108049 | 2022-01-12 | Custer | Oklahoma | 40039 | 6119 | 137 |
2014747 | 2014747 | 2021-12-14 | Preston | West Virginia | 54077 | 6119 | 109 |
1919901 | 1919901 | 2021-11-15 | Giles | Tennessee | 47055 | 6119 | 127 |
1895723 | 1895723 | 2021-11-08 | Beauregard | Louisiana | 22011 | 6119 | 124 |
1834974 | 1834974 | 2021-10-20 | Mercer | Ohio | 39107 | 6119 | 93 |
1822264 | 1822264 | 2021-10-16 | Toa Baja | Puerto Rico | 72137 | 6119 | |
1823064 | 1823064 | 2021-10-16 | Pierce | Wisconsin | 55093 | 6119 | 45 |
1819815 | 1819815 | 2021-10-15 | Pierce | Wisconsin | 55093 | 6119 | 45 |
1816566 | 1816566 | 2021-10-14 | Pierce | Wisconsin | 55093 | 6119 | 45 |
1784990 | 1784990 | 2021-10-05 | Muscatine | Iowa | 19139 | 6119 | 111 |
1781438 | 1781438 | 2021-10-04 | Bingham | Idaho | 16011 | 6119 | 96 |
1781741 | 1781741 | 2021-10-04 | Muscatine | Iowa | 19139 | 6119 | 111 |
1778491 | 1778491 | 2021-10-03 | Muscatine | Iowa | 19139 | 6119 | 111 |
1775241 | 1775241 | 2021-10-02 | Muscatine | Iowa | 19139 | 6119 | 111 |
1771991 | 1771991 | 2021-10-01 | Muscatine | Iowa | 19139 | 6119 | 111 |
1768742 | 1768742 | 2021-09-30 | Muscatine | Iowa | 19139 | 6119 | 111 |
1765493 | 1765493 | 2021-09-29 | Muscatine | Iowa | 19139 | 6119 | 111 |
1767483 | 1767483 | 2021-09-29 | Uvalde | Texas | 48463 | 6119 | 91 |
1630326 | 1630326 | 2021-08-18 | Union | Ohio | 39159 | 6119 | 49 |
1598861 | 1598861 | 2021-08-08 | Barron | Wisconsin | 55005 | 6119 | 86 |
1595612 | 1595612 | 2021-08-07 | Barron | Wisconsin | 55005 | 6119 | 86 |
1592363 | 1592363 | 2021-08-06 | Barron | Wisconsin | 55005 | 6119 | 86 |
1541707 | 1541707 | 2021-07-22 | St. Mary's | Maryland | 24037 | 6119 | 132 |
1474110 | 1474110 | 2021-07-01 | Salem | New Jersey | 34033 | 6119 | 188 |
1475523 | 1475523 | 2021-07-01 | Waupaca | Wisconsin | 55135 | 6119 | 167 |
1472277 | 1472277 | 2021-06-30 | Waupaca | Wisconsin | 55135 | 6119 | 167 |
1469032 | 1469032 | 2021-06-29 | Waupaca | Wisconsin | 55135 | 6119 | 167 |
1446610 | 1446610 | 2021-06-23 | Garfield | Colorado | 8045 | 6119 | 47 |
1432382 | 1432382 | 2021-06-18 | Bradford | Pennsylvania | 42015 | 6119 | 94 |
1399612 | 1399612 | 2021-06-08 | Lee | North Carolina | 37105 | 6119 | 81 |
1306899 | 1306899 | 2021-05-11 | Greene | Arkansas | 5055 | 6119 | 77 |
1240514 | 1240514 | 2021-04-20 | Duplin | North Carolina | 37061 | 6119 | 130 |
1235685 | 1235685 | 2021-04-19 | Jackson | Florida | 12063 | 6119 | 157 |
1232438 | 1232438 | 2021-04-18 | Jackson | Florida | 12063 | 6119 | 156 |
1220545 | 1220545 | 2021-04-14 | Lamar | Mississippi | 28073 | 6119 | 84 |
1204747 | 1204747 | 2021-04-09 | Steuben | New York | 36101 | 6119 | 141 |
1172304 | 1172304 | 2021-03-30 | Columbus | North Carolina | 37047 | 6119 | 149 |
1137920 | 1137920 | 2021-03-20 | Colbert | Alabama | 1033 | 6119 | 125 |
1123905 | 1123905 | 2021-03-15 | Deschutes | Oregon | 41017 | 6119 | 68 |
1097581 | 1097581 | 2021-03-07 | Oswego | New York | 36075 | 6119 | 89 |
1092791 | 1092791 | 2021-03-06 | Flagler | Florida | 12035 | 6119 | 92 |
1083473 | 1083473 | 2021-03-03 | Morgan | Indiana | 18109 | 6119 | 130 |
1062432 | 1062432 | 2021-02-24 | Georgetown | South Carolina | 45043 | 6119 | 133 |
1034620 | 1034620 | 2021-02-16 | Madison | Idaho | 16065 | 6119 | 21 |
1026834 | 1026834 | 2021-02-13 | Coffee | Tennessee | 47031 | 6119 | 112 |
1003396 | 1003396 | 2021-02-06 | Eddy | New Mexico | 35015 | 6119 | 102 |
996936 | 996936 | 2021-02-04 | Chemung | New York | 36015 | 6119 | 119 |
934118 | 934118 | 2021-01-16 | Williamson | Illinois | 17199 | 6119 | 115 |
924970 | 924970 | 2021-01-13 | Lenawee | Michigan | 26091 | 6119 | 81 |
895506 | 895506 | 2021-01-04 | Daviess | Kentucky | 21059 | 6119 | 99 |
891726 | 891726 | 2021-01-03 | Newton | Georgia | 13217 | 6119 | 127 |
777849 | 777849 | 2020-11-29 | Madera | California | 6039 | 6119 | 85 |
752105 | 752105 | 2020-11-21 | Columbia | Georgia | 13073 | 6119 | 75 |
692031 | 692031 | 2020-11-02 | Union | North Carolina | 37179 | 6119 | 65 |
626957 | 626957 | 2020-10-13 | Somerset | New Jersey | 34035 | 6119 | 586 |
481367 | 481367 | 2020-08-29 | Forsyth | North Carolina | 37067 | 6119 | 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);