ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
58 rows where cases = 6616 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2312603 | 2312603 | 2022-03-16 | Grant | New Mexico | 35017 | 6616 | 80 |
2313905 | 2313905 | 2022-03-16 | Mason | West Virginia | 54053 | 6616 | 90 |
2266409 | 2266409 | 2022-03-02 | Richland | Louisiana | 22083 | 6616 | 94 |
2258608 | 2258608 | 2022-02-27 | Hancock | West Virginia | 54029 | 6616 | 135 |
2255357 | 2255357 | 2022-02-26 | Hancock | West Virginia | 54029 | 6616 | 135 |
2252106 | 2252106 | 2022-02-25 | Hancock | West Virginia | 54029 | 6616 | 135 |
2241069 | 2241069 | 2022-02-22 | Luna | New Mexico | 35029 | 6616 | 116 |
2237818 | 2237818 | 2022-02-21 | Luna | New Mexico | 35029 | 6616 | 116 |
2213222 | 2213222 | 2022-02-13 | Park | Wyoming | 56029 | 6616 | 130 |
2209969 | 2209969 | 2022-02-12 | Park | Wyoming | 56029 | 6616 | 130 |
2206716 | 2206716 | 2022-02-11 | Park | Wyoming | 56029 | 6616 | 130 |
2196475 | 2196475 | 2022-02-08 | Kleberg | Texas | 48273 | 6616 | 136 |
2178603 | 2178603 | 2022-02-03 | Morehouse | Louisiana | 22067 | 6616 | 125 |
2172084 | 2172084 | 2022-02-01 | Franklin | Louisiana | 22041 | 6616 | 153 |
2107440 | 2107440 | 2022-01-12 | Marion | Missouri | 29127 | 6616 | 109 |
2088206 | 2088206 | 2022-01-06 | Rio Arriba | New Mexico | 35039 | 6616 | 102 |
2076060 | 2076060 | 2022-01-02 | Erath | Texas | 48143 | 6616 | 109 |
2072809 | 2072809 | 2022-01-01 | Erath | Texas | 48143 | 6616 | 109 |
2069558 | 2069558 | 2021-12-31 | Erath | Texas | 48143 | 6616 | 109 |
2066307 | 2066307 | 2021-12-30 | Erath | Texas | 48143 | 6616 | 109 |
2052743 | 2052743 | 2021-12-26 | Putnam | Ohio | 39137 | 6616 | 129 |
1972215 | 1972215 | 2021-12-01 | Waller | Texas | 48473 | 6616 | 85 |
1964363 | 1964363 | 2021-11-29 | Camden | Missouri | 29029 | 6616 | 144 |
1951223 | 1951223 | 2021-11-25 | Morrison | Minnesota | 27097 | 6616 | 78 |
1947972 | 1947972 | 2021-11-24 | Morrison | Minnesota | 27097 | 6616 | 78 |
1943501 | 1943501 | 2021-11-23 | Miller | Arkansas | 5091 | 6616 | 142 |
1853538 | 1853538 | 2021-10-26 | Webster | Louisiana | 22119 | 6616 | 147 |
1826999 | 1826999 | 2021-10-18 | Henry | Illinois | 17073 | 6616 | 106 |
1827870 | 1827870 | 2021-10-18 | Butler | Missouri | 29023 | 6616 | 71 |
1783536 | 1783536 | 2021-10-04 | Cherokee | Texas | 48073 | 6616 | 197 |
1780287 | 1780287 | 2021-10-03 | Cherokee | Texas | 48073 | 6616 | 193 |
1777037 | 1777037 | 2021-10-02 | Cherokee | Texas | 48073 | 6616 | 192 |
1748446 | 1748446 | 2021-09-24 | Tallapoosa | Alabama | 1123 | 6616 | 177 |
1746467 | 1746467 | 2021-09-23 | Benton | Minnesota | 27009 | 6616 | 102 |
1717958 | 1717958 | 2021-09-14 | Athens | Ohio | 39009 | 6616 | 63 |
1715393 | 1715393 | 2021-09-13 | Jim Wells | Texas | 48249 | 6616 | 138 |
1712147 | 1712147 | 2021-09-12 | Jim Wells | Texas | 48249 | 6616 | 138 |
1678830 | 1678830 | 2021-09-02 | Carteret | North Carolina | 37031 | 6616 | 58 |
1617047 | 1617047 | 2021-08-14 | Cayuga | New York | 36011 | 6616 | 93 |
1405247 | 1405247 | 2021-06-10 | Pulaski | Kentucky | 21199 | 6616 | 117 |
1383320 | 1383320 | 2021-06-03 | St. Lawrence | New York | 36089 | 6616 | 96 |
1380736 | 1380736 | 2021-06-02 | Gibson | Tennessee | 47053 | 6616 | 147 |
1360603 | 1360603 | 2021-05-27 | Sullivan | New York | 36105 | 6616 | 73 |
1311086 | 1311086 | 2021-05-12 | McCracken | Kentucky | 21145 | 6616 | 123 |
1284641 | 1284641 | 2021-05-04 | Boone | Illinois | 17007 | 6616 | 83 |
1274301 | 1274301 | 2021-05-01 | Blount | Alabama | 1009 | 6616 | 135 |
1269890 | 1269890 | 2021-04-29 | Geauga | Ohio | 39055 | 6616 | 147 |
1197995 | 1197995 | 2021-04-07 | Lewis and Clark | Montana | 30049 | 6616 | 81 |
1139755 | 1139755 | 2021-03-20 | Chemung | New York | 36015 | 6616 | 131 |
956113 | 956113 | 2021-01-22 | Wood | Wisconsin | 55141 | 6616 | 74 |
891830 | 891830 | 2021-01-03 | Adams | Illinois | 17001 | 6616 | 83 |
886335 | 886335 | 2021-01-01 | St. Francois | Missouri | 29187 | 6616 | 69 |
836459 | 836459 | 2020-12-17 | Bartow | Georgia | 13015 | 6616 | 112 |
817021 | 817021 | 2020-12-11 | Douglas | Georgia | 13097 | 6616 | 102 |
808136 | 808136 | 2020-12-08 | Livingston | Michigan | 26093 | 6616 | 54 |
799194 | 799194 | 2020-12-05 | Fairfield | Ohio | 39045 | 6616 | 67 |
291802 | 291802 | 2020-07-01 | St. Louis | Missouri | 29189 | 6616 | 581 |
226374 | 226374 | 2020-06-10 | Erie | New York | 36029 | 6616 | 563 |
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);