ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
39 rows where cases = 7168 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 |
---|---|---|---|---|---|---|---|
2492790 | 2492790 | 2022-05-10 | Halifax | Virginia | 51083 | 7168 | 159 |
2488799 | 2488799 | 2022-05-09 | Lincoln | Oregon | 41041 | 7168 | 85 |
2469374 | 2469374 | 2022-05-03 | Isabela | Puerto Rico | 72071 | 7168 | |
2336315 | 2336315 | 2022-03-23 | Kleberg | Texas | 48273 | 7168 | 145 |
2285245 | 2285245 | 2022-03-08 | Lumpkin | Georgia | 13187 | 7168 | 127 |
2174900 | 2174900 | 2022-02-02 | Adams | Indiana | 18001 | 7168 | 106 |
2173548 | 2173548 | 2022-02-01 | Scott | Tennessee | 47151 | 7168 | 96 |
2170296 | 2170296 | 2022-01-31 | Scott | Tennessee | 47151 | 7168 | 96 |
2167042 | 2167042 | 2022-01-30 | Scott | Tennessee | 47151 | 7168 | 96 |
2163787 | 2163787 | 2022-01-29 | Scott | Tennessee | 47151 | 7168 | 96 |
2160532 | 2160532 | 2022-01-28 | Scott | Tennessee | 47151 | 7168 | 96 |
2157276 | 2157276 | 2022-01-27 | Scott | Tennessee | 47151 | 7168 | 96 |
2154023 | 2154023 | 2022-01-26 | Scott | Tennessee | 47151 | 7168 | 96 |
2111034 | 2111034 | 2022-01-13 | Wyoming | New York | 36121 | 7168 | 75 |
2069178 | 2069178 | 2021-12-31 | Pike | Pennsylvania | 42103 | 7168 | 73 |
1935731 | 1935731 | 2021-11-20 | Shelby | Ohio | 39149 | 7168 | 132 |
1895336 | 1895336 | 2021-11-08 | Jackson | Indiana | 18071 | 7168 | 96 |
1869216 | 1869216 | 2021-10-31 | Clinton | Illinois | 17027 | 7168 | 111 |
1865967 | 1865967 | 2021-10-30 | Clinton | Illinois | 17027 | 7168 | 111 |
1862718 | 1862718 | 2021-10-29 | Clinton | Illinois | 17027 | 7168 | 111 |
1847405 | 1847405 | 2021-10-24 | Johnson | Missouri | 29101 | 7168 | 73 |
1757954 | 1757954 | 2021-09-26 | Grays Harbor | Washington | 53027 | 7168 | 103 |
1754706 | 1754706 | 2021-09-25 | Grays Harbor | Washington | 53027 | 7168 | 103 |
1751458 | 1751458 | 2021-09-24 | Grays Harbor | Washington | 53027 | 7168 | 103 |
1700391 | 1700391 | 2021-09-09 | Henry | Indiana | 18065 | 7168 | 125 |
1654198 | 1654198 | 2021-08-26 | Dale | Alabama | 1045 | 7168 | 132 |
1646326 | 1646326 | 2021-08-23 | Sullivan | New York | 36105 | 7168 | 76 |
1633325 | 1633325 | 2021-08-19 | Steuben | New York | 36101 | 7168 | 148 |
1618461 | 1618461 | 2021-08-15 | Colbert | Alabama | 1033 | 7168 | 145 |
1554596 | 1554596 | 2021-07-26 | Acadia | Louisiana | 22001 | 7168 | 199 |
1193645 | 1193645 | 2021-04-06 | Walker | Georgia | 13295 | 7168 | 85 |
904152 | 904152 | 2021-01-06 | Manitowoc | Wisconsin | 55071 | 7168 | 57 |
797141 | 797141 | 2020-12-05 | Etowah | Alabama | 1055 | 7168 | 70 |
743214 | 743214 | 2020-11-18 | Ingham | Michigan | 26065 | 7168 | 91 |
715349 | 715349 | 2020-11-09 | Sumner | Tennessee | 47165 | 7168 | 120 |
641651 | 641651 | 2020-10-18 | Jefferson | Colorado | 8059 | 7168 | 299 |
627310 | 627310 | 2020-10-13 | Cleveland | Oklahoma | 40027 | 7168 | 83 |
264496 | 264496 | 2020-06-22 | Bexar | Texas | 48029 | 7168 | 97 |
176748 | 176748 | 2020-05-25 | Hennepin | Minnesota | 27053 | 7168 | 539 |
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);