ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
43 rows where cases = 8014 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 |
---|---|---|---|---|---|---|---|
2500621 | 2500621 | 2022-05-13 | Grayson | Kentucky | 21085 | 8014 | 134 |
2497363 | 2497363 | 2022-05-12 | Grayson | Kentucky | 21085 | 8014 | 134 |
2494105 | 2494105 | 2022-05-11 | Grayson | Kentucky | 21085 | 8014 | 134 |
2490847 | 2490847 | 2022-05-10 | Grayson | Kentucky | 21085 | 8014 | 134 |
2487590 | 2487590 | 2022-05-09 | Grayson | Kentucky | 21085 | 8014 | 134 |
2488365 | 2488365 | 2022-05-09 | Cibola | New Mexico | 35006 | 8014 | 188 |
2476393 | 2476393 | 2022-05-05 | Wood | Texas | 48499 | 8014 | 288 |
2473136 | 2473136 | 2022-05-04 | Wood | Texas | 48499 | 8014 | 288 |
2469880 | 2469880 | 2022-05-03 | Wood | Texas | 48499 | 8014 | 288 |
2466624 | 2466624 | 2022-05-02 | Wood | Texas | 48499 | 8014 | 288 |
2352721 | 2352721 | 2022-03-28 | Uintah | Utah | 49047 | 8014 | 71 |
2328627 | 2328627 | 2022-03-21 | Polk | Missouri | 29167 | 8014 | 105 |
2258737 | 2258737 | 2022-02-27 | Sheridan | Wyoming | 56033 | 8014 | 74 |
2255486 | 2255486 | 2022-02-26 | Sheridan | Wyoming | 56033 | 8014 | 74 |
2251312 | 2251312 | 2022-02-25 | Snyder | Pennsylvania | 42109 | 8014 | 150 |
2252235 | 2252235 | 2022-02-25 | Sheridan | Wyoming | 56033 | 8014 | 74 |
2192740 | 2192740 | 2022-02-07 | Clarion | Pennsylvania | 42031 | 8014 | 190 |
2130792 | 2130792 | 2022-01-19 | Williams | Ohio | 39171 | 8014 | 135 |
2126652 | 2126652 | 2022-01-18 | Delta | Michigan | 26041 | 8014 | 139 |
2123400 | 2123400 | 2022-01-17 | Delta | Michigan | 26041 | 8014 | 139 |
2120148 | 2120148 | 2022-01-16 | Delta | Michigan | 26041 | 8014 | 139 |
2116896 | 2116896 | 2022-01-15 | Delta | Michigan | 26041 | 8014 | 139 |
2113645 | 2113645 | 2022-01-14 | Delta | Michigan | 26041 | 8014 | 139 |
2099385 | 2099385 | 2022-01-10 | Chilton | Alabama | 1021 | 8014 | 175 |
2097705 | 2097705 | 2022-01-09 | Phelps | Missouri | 29161 | 8014 | 205 |
1944917 | 1944917 | 2021-11-23 | Newton | Missouri | 29145 | 8014 | 168 |
1893413 | 1893413 | 2021-11-07 | Athens | Ohio | 39009 | 8014 | 92 |
1781032 | 1781032 | 2021-10-04 | Mississippi | Arkansas | 5093 | 8014 | 130 |
1666203 | 1666203 | 2021-08-29 | Crawford | Pennsylvania | 42039 | 8014 | 162 |
1658524 | 1658524 | 2021-08-27 | Pulaski | Kentucky | 21199 | 8014 | 139 |
1488333 | 1488333 | 2021-07-05 | Suffolk city | Virginia | 51800 | 8014 | 190 |
1308152 | 1308152 | 2021-05-11 | Rice | Minnesota | 27131 | 8014 | 106 |
909583 | 909583 | 2021-01-08 | Portage | Ohio | 39133 | 8014 | 102 |
904958 | 904958 | 2021-01-07 | LaPorte | Indiana | 18091 | 8014 | 148 |
888346 | 888346 | 2021-01-02 | Martin | Florida | 12085 | 8014 | 210 |
833241 | 833241 | 2020-12-16 | Columbia | Georgia | 13073 | 8014 | 93 |
791188 | 791188 | 2020-12-03 | Bonneville | Idaho | 16019 | 8014 | 75 |
561352 | 561352 | 2020-09-23 | Fayette | Kentucky | 21067 | 8014 | 72 |
479666 | 479666 | 2020-08-29 | Santa Barbara | California | 6083 | 8014 | 92 |
476433 | 476433 | 2020-08-28 | Santa Barbara | California | 6083 | 8014 | 92 |
395830 | 395830 | 2020-08-03 | Ventura | California | 6111 | 8014 | 76 |
251679 | 251679 | 2020-06-18 | Montgomery | Pennsylvania | 42091 | 8014 | 780 |
246575 | 246575 | 2020-06-17 | San Bernardino | California | 6071 | 8014 | 229 |
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);