ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
74 rows where cases = 6263 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 26
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2338396 | 2338396 | 2022-03-24 | Saline | Missouri | 29195 | 6263 | 102 |
2335142 | 2335142 | 2022-03-23 | Saline | Missouri | 29195 | 6263 | 102 |
2328635 | 2328635 | 2022-03-21 | Saline | Missouri | 29195 | 6263 | 101 |
2239755 | 2239755 | 2022-02-22 | Stephens | Georgia | 13257 | 6263 | 136 |
2220999 | 2220999 | 2022-02-16 | Emmet | Michigan | 26047 | 6263 | 75 |
2213352 | 2213352 | 2022-02-14 | Cleburne | Arkansas | 5023 | 6263 | 111 |
2216231 | 2216231 | 2022-02-14 | Louisa | Virginia | 51109 | 6263 | 68 |
2203324 | 2203324 | 2022-02-10 | Boone | West Virginia | 54005 | 6263 | 64 |
2178851 | 2178851 | 2022-02-03 | Todd | Minnesota | 27153 | 6263 | 54 |
2170731 | 2170731 | 2022-01-31 | Salem city | Virginia | 51775 | 6263 | 87 |
2167199 | 2167199 | 2022-01-30 | Kleberg | Texas | 48273 | 6263 | 134 |
2164053 | 2164053 | 2022-01-29 | Willacy | Texas | 48489 | 6263 | 118 |
2157370 | 2157370 | 2022-01-27 | Fannin | Texas | 48147 | 6263 | 161 |
2132522 | 2132522 | 2022-01-20 | Fayette | Illinois | 17051 | 6263 | 88 |
2102231 | 2102231 | 2022-01-10 | Upshur | Texas | 48459 | 6263 | 158 |
2083083 | 2083083 | 2022-01-04 | Trempealeau | Wisconsin | 55121 | 6263 | 56 |
2056168 | 2056168 | 2021-12-27 | McKean | Pennsylvania | 42083 | 6263 | 113 |
2016585 | 2016585 | 2021-12-15 | Lincoln | Nebraska | 31111 | 6263 | 85 |
2017336 | 2017336 | 2021-12-15 | Codington | South Dakota | 46029 | 6263 | 90 |
1898944 | 1898944 | 2021-11-09 | Perry | Kentucky | 21193 | 6263 | 100 |
1880969 | 1880969 | 2021-11-03 | Weakley | Tennessee | 47183 | 6263 | 89 |
1873965 | 1873965 | 2021-11-01 | Mercer | Ohio | 39107 | 6263 | 94 |
1849058 | 1849058 | 2021-10-24 | Pierce | Wisconsin | 55093 | 6263 | 46 |
1845808 | 1845808 | 2021-10-23 | Pierce | Wisconsin | 55093 | 6263 | 46 |
1842558 | 1842558 | 2021-10-22 | Pierce | Wisconsin | 55093 | 6263 | 46 |
1826417 | 1826417 | 2021-10-18 | Russell | Alabama | 1113 | 6263 | 58 |
1791027 | 1791027 | 2021-10-07 | Bryan | Georgia | 13029 | 6263 | 60 |
1787529 | 1787529 | 2021-10-06 | Miller | Arkansas | 5091 | 6263 | 47 |
1769876 | 1769876 | 2021-09-30 | Watauga | North Carolina | 37189 | 6263 | 34 |
1716549 | 1716549 | 2021-09-14 | Macoupin | Illinois | 17117 | 6263 | 126 |
1694705 | 1694705 | 2021-09-07 | Johnson | Missouri | 29101 | 6263 | 64 |
1695109 | 1695109 | 2021-09-07 | Hoke | North Carolina | 37093 | 6263 | 63 |
1665302 | 1665302 | 2021-08-29 | Otter Tail | Minnesota | 27111 | 6263 | 89 |
1662054 | 1662054 | 2021-08-28 | Otter Tail | Minnesota | 27111 | 6263 | 89 |
1658806 | 1658806 | 2021-08-27 | Otter Tail | Minnesota | 27111 | 6263 | 89 |
1659325 | 1659325 | 2021-08-27 | Wayne | New York | 36117 | 6263 | 75 |
1631065 | 1631065 | 2021-08-18 | Box Elder | Utah | 49003 | 6263 | 61 |
1605425 | 1605425 | 2021-08-10 | Waupaca | Wisconsin | 55135 | 6263 | 167 |
1538577 | 1538577 | 2021-07-21 | Chisago | Minnesota | 27025 | 6263 | 54 |
1522573 | 1522573 | 2021-07-16 | Newton | Missouri | 29145 | 6263 | 83 |
1513416 | 1513416 | 2021-07-13 | Bryan | Oklahoma | 40013 | 6263 | 79 |
1510170 | 1510170 | 2021-07-12 | Bryan | Oklahoma | 40013 | 6263 | 79 |
1506923 | 1506923 | 2021-07-11 | Bryan | Oklahoma | 40013 | 6263 | 79 |
1503677 | 1503677 | 2021-07-10 | Bryan | Oklahoma | 40013 | 6263 | 79 |
1500431 | 1500431 | 2021-07-09 | Bryan | Oklahoma | 40013 | 6263 | 79 |
1497185 | 1497185 | 2021-07-08 | Bryan | Oklahoma | 40013 | 6263 | 79 |
1498237 | 1498237 | 2021-07-08 | Sauk | Wisconsin | 55111 | 6263 | 57 |
1493938 | 1493938 | 2021-07-07 | Bryan | Oklahoma | 40013 | 6263 | 79 |
1481534 | 1481534 | 2021-07-03 | Hunt | Texas | 48231 | 6263 | 179 |
1447661 | 1447661 | 2021-06-23 | St. Joseph | Michigan | 26149 | 6263 | 100 |
1408940 | 1408940 | 2021-06-11 | Joplin | Missouri | 6263 | 109 | |
1379633 | 1379633 | 2021-06-02 | Lafayette | Mississippi | 28071 | 6263 | 119 |
1343686 | 1343686 | 2021-05-22 | Cecil | Maryland | 24015 | 6263 | 139 |
1336334 | 1336334 | 2021-05-20 | Jackson | Florida | 12063 | 6263 | 157 |
1266483 | 1266483 | 2021-04-28 | Columbus | North Carolina | 37047 | 6263 | 150 |
1244964 | 1244964 | 2021-04-21 | Raleigh | West Virginia | 54081 | 6263 | 79 |
1213678 | 1213678 | 2021-04-12 | McCracken | Kentucky | 21145 | 6263 | 118 |
1214731 | 1214731 | 2021-04-12 | Scioto | Ohio | 39145 | 6263 | 99 |
1207181 | 1207181 | 2021-04-10 | McCracken | Kentucky | 21145 | 6263 | 118 |
1159476 | 1159476 | 2021-03-26 | Hancock | Ohio | 39063 | 6263 | 122 |
1130293 | 1130293 | 2021-03-17 | Ross | Ohio | 39141 | 6263 | 136 |
1117476 | 1117476 | 2021-03-13 | Lawrence | Pennsylvania | 42073 | 6263 | 189 |
1103217 | 1103217 | 2021-03-09 | Christian | Kentucky | 21047 | 6263 | 82 |
1048027 | 1048027 | 2021-02-20 | Bullitt | Kentucky | 21029 | 6263 | 47 |
1040927 | 1040927 | 2021-02-18 | Bulloch | Georgia | 13031 | 6263 | 86 |
1023214 | 1023214 | 2021-02-12 | Creek | Oklahoma | 40037 | 6263 | 106 |
930964 | 930964 | 2021-01-15 | Wayne | Indiana | 18177 | 6263 | 159 |
830315 | 830315 | 2020-12-15 | LaPorte | Indiana | 18091 | 6263 | 117 |
807970 | 807970 | 2020-12-08 | Ascension | Louisiana | 22005 | 6263 | 109 |
802953 | 802953 | 2020-12-06 | Putnam | Tennessee | 47141 | 6263 | 85 |
761843 | 761843 | 2020-11-24 | Columbia | Georgia | 13073 | 6263 | 75 |
514754 | 514754 | 2020-09-08 | Loudoun | Virginia | 51107 | 6263 | 118 |
349654 | 349654 | 2020-07-19 | Allegheny | Pennsylvania | 42003 | 6263 | 208 |
82295 | 82295 | 2020-04-23 | Orleans | Louisiana | 22071 | 6263 | 387 |
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);