ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
63 rows where cases = 6360 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 |
---|---|---|---|---|---|---|---|
2490996 | 2490996 | 2022-05-10 | Knox | Maine | 23013 | 6360 | 37 |
2491698 | 2491698 | 2022-05-10 | Seneca | New York | 36099 | 6360 | 91 |
2361926 | 2361926 | 2022-03-31 | Canovanas | Puerto Rico | 72029 | 6360 | |
2330270 | 2330270 | 2022-03-21 | Waushara | Wisconsin | 55137 | 6360 | 87 |
2324867 | 2324867 | 2022-03-20 | Marion | Kentucky | 21155 | 6360 | 77 |
2321613 | 2321613 | 2022-03-19 | Marion | Kentucky | 21155 | 6360 | 77 |
2318359 | 2318359 | 2022-03-18 | Marion | Kentucky | 21155 | 6360 | 77 |
2315106 | 2315106 | 2022-03-17 | Marion | Kentucky | 21155 | 6360 | 77 |
2311853 | 2311853 | 2022-03-16 | Marion | Kentucky | 21155 | 6360 | 77 |
2308600 | 2308600 | 2022-03-15 | Marion | Kentucky | 21155 | 6360 | 77 |
2305349 | 2305349 | 2022-03-14 | Marion | Kentucky | 21155 | 6360 | 77 |
2258866 | 2258866 | 2022-02-28 | Cleburne | Arkansas | 5023 | 6360 | 118 |
2239241 | 2239241 | 2022-02-22 | Bibb | Alabama | 1007 | 6360 | 99 |
2241004 | 2241004 | 2022-02-22 | Churchill | Nevada | 32001 | 6360 | 101 |
2237753 | 2237753 | 2022-02-21 | Churchill | Nevada | 32001 | 6360 | 101 |
2234502 | 2234502 | 2022-02-20 | Churchill | Nevada | 32001 | 6360 | 101 |
2231251 | 2231251 | 2022-02-19 | Churchill | Nevada | 32001 | 6360 | 101 |
2228000 | 2228000 | 2022-02-18 | Churchill | Nevada | 32001 | 6360 | 101 |
2218579 | 2218579 | 2022-02-15 | Henry | Ohio | 39069 | 6360 | 102 |
2191226 | 2191226 | 2022-02-07 | Posey | Indiana | 18129 | 6360 | 52 |
2176555 | 2176555 | 2022-02-02 | Dorado | Puerto Rico | 72051 | 6360 | |
2171393 | 2171393 | 2022-02-01 | Gilmer | Georgia | 13123 | 6360 | 152 |
2172358 | 2172358 | 2022-02-01 | Adams | Mississippi | 28001 | 6360 | 132 |
2156325 | 2156325 | 2022-01-27 | Ravalli | Montana | 30081 | 6360 | 130 |
2087979 | 2087979 | 2022-01-06 | Warren | Missouri | 29219 | 6360 | 78 |
2035315 | 2035315 | 2021-12-21 | Lyon | Kansas | 20111 | 6360 | 98 |
2032065 | 2032065 | 2021-12-20 | Lyon | Kansas | 20111 | 6360 | 98 |
2024227 | 2024227 | 2021-12-17 | Wharton | Texas | 48481 | 6360 | 190 |
1969758 | 1969758 | 2021-12-01 | Bryan | Georgia | 13029 | 6360 | 75 |
1966508 | 1966508 | 2021-11-30 | Bryan | Georgia | 13029 | 6360 | 76 |
1963443 | 1963443 | 2021-11-29 | Nez Perce | Idaho | 16069 | 6360 | 105 |
1951958 | 1951958 | 2021-11-25 | Madison | Ohio | 39097 | 6360 | 87 |
1948707 | 1948707 | 2021-11-24 | Madison | Ohio | 39097 | 6360 | 87 |
1938014 | 1938014 | 2021-11-21 | St. John the Baptist | Louisiana | 22095 | 6360 | 173 |
1934764 | 1934764 | 2021-11-20 | St. John the Baptist | Louisiana | 22095 | 6360 | 173 |
1931513 | 1931513 | 2021-11-19 | St. John the Baptist | Louisiana | 22095 | 6360 | 173 |
1724158 | 1724158 | 2021-09-16 | Elko | Nevada | 32007 | 6360 | 76 |
1697411 | 1697411 | 2021-09-08 | Barren | Kentucky | 21009 | 6360 | 110 |
1603424 | 1603424 | 2021-08-10 | St. Mary's | Maryland | 24037 | 6360 | 132 |
1577380 | 1577380 | 2021-08-02 | St. Mary | Louisiana | 22101 | 6360 | 147 |
1557900 | 1557900 | 2021-07-27 | Vermilion | Louisiana | 22113 | 6360 | 129 |
1500125 | 1500125 | 2021-07-09 | Cayuga | New York | 36011 | 6360 | 92 |
1472568 | 1472568 | 2021-07-01 | Eagle | Colorado | 8037 | 6360 | 23 |
1441302 | 1441302 | 2021-06-21 | Lamar | Mississippi | 28073 | 6360 | 88 |
1373967 | 1373967 | 2021-05-31 | Carbon | Pennsylvania | 42025 | 6360 | 171 |
1182205 | 1182205 | 2021-04-02 | Geauga | Ohio | 39055 | 6360 | 144 |
1075260 | 1075260 | 2021-02-28 | Crawford | Pennsylvania | 42039 | 6360 | 136 |
1027602 | 1027602 | 2021-02-14 | Walker | Alabama | 1127 | 6360 | 238 |
1025496 | 1025496 | 2021-02-13 | Allegany | Maryland | 24001 | 6360 | 194 |
896362 | 896362 | 2021-01-04 | Saratoga | New York | 36091 | 6360 | 48 |
847317 | 847317 | 2020-12-20 | Clay | Missouri | 29047 | 6360 | 87 |
842576 | 842576 | 2020-12-19 | DeKalb | Alabama | 1049 | 6360 | 51 |
844071 | 844071 | 2020-12-19 | Clay | Missouri | 29047 | 6360 | 87 |
844678 | 844678 | 2020-12-19 | Portage | Ohio | 39133 | 6360 | 89 |
840826 | 840826 | 2020-12-18 | Clay | Missouri | 29047 | 6360 | 87 |
786748 | 786748 | 2020-12-01 | Washington | Tennessee | 47179 | 6360 | 109 |
775841 | 775841 | 2020-11-28 | Jackson | Mississippi | 28059 | 6360 | 119 |
635303 | 635303 | 2020-10-16 | Clarke | Georgia | 13059 | 6360 | 46 |
622404 | 622404 | 2020-10-12 | Muscogee | Georgia | 13215 | 6360 | 173 |
508775 | 508775 | 2020-09-07 | Sonoma | California | 6097 | 6360 | 93 |
449871 | 449871 | 2020-08-19 | Jefferson | Texas | 48245 | 6360 | 96 |
391988 | 391988 | 2020-08-01 | Webb | Texas | 48479 | 6360 | 128 |
35773 | 35773 | 2020-04-06 | Los Angeles | California | 6037 | 6360 | 147 |
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);