ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
49 rows where cases = 7892 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 |
---|---|---|---|---|---|---|---|
2489362 | 2489362 | 2022-05-09 | Polk | Texas | 48373 | 7892 | 247 |
2476648 | 2476648 | 2022-05-05 | Mineral | West Virginia | 54057 | 7892 | 156 |
2256512 | 2256512 | 2022-02-27 | Calloway | Kentucky | 21035 | 7892 | 82 |
2253261 | 2253261 | 2022-02-26 | Calloway | Kentucky | 21035 | 7892 | 82 |
2250010 | 2250010 | 2022-02-25 | Calloway | Kentucky | 21035 | 7892 | 82 |
2223029 | 2223029 | 2022-02-17 | Marion | Alabama | 1093 | 7892 | 139 |
2170541 | 2170541 | 2022-01-31 | Titus | Texas | 48449 | 7892 | 113 |
2157797 | 2157797 | 2022-01-27 | Marshall | West Virginia | 54051 | 7892 | 143 |
2148278 | 2148278 | 2022-01-25 | Baxter | Arkansas | 5005 | 7892 | 217 |
2143525 | 2143525 | 2022-01-23 | Greene | New York | 36039 | 7892 | 108 |
2008609 | 2008609 | 2021-12-13 | Broomfield | Colorado | 8014 | 7892 | 90 |
1928017 | 1928017 | 2021-11-18 | Finney | Kansas | 20055 | 7892 | 91 |
1896677 | 1896677 | 2021-11-08 | Darke | Ohio | 39037 | 7892 | 168 |
1851051 | 1851051 | 2021-10-25 | Granville | North Carolina | 37077 | 7892 | 99 |
1666357 | 1666357 | 2021-08-29 | Georgetown | South Carolina | 45043 | 7892 | 151 |
1662551 | 1662551 | 2021-08-28 | Ontario | New York | 36069 | 7892 | 93 |
1663109 | 1663109 | 2021-08-28 | Georgetown | South Carolina | 45043 | 7892 | 151 |
1659861 | 1659861 | 2021-08-27 | Georgetown | South Carolina | 45043 | 7892 | 151 |
1630186 | 1630186 | 2021-08-18 | Wilkes | North Carolina | 37193 | 7892 | 121 |
1604371 | 1604371 | 2021-08-10 | Creek | Oklahoma | 40037 | 7892 | 169 |
1601122 | 1601122 | 2021-08-09 | Creek | Oklahoma | 40037 | 7892 | 169 |
1597874 | 1597874 | 2021-08-08 | Creek | Oklahoma | 40037 | 7892 | 169 |
1594625 | 1594625 | 2021-08-07 | Creek | Oklahoma | 40037 | 7892 | 169 |
1591376 | 1591376 | 2021-08-06 | Creek | Oklahoma | 40037 | 7892 | 169 |
1588127 | 1588127 | 2021-08-05 | Creek | Oklahoma | 40037 | 7892 | 169 |
1584877 | 1584877 | 2021-08-04 | Creek | Oklahoma | 40037 | 7892 | 169 |
1574187 | 1574187 | 2021-08-01 | Wicomico | Maryland | 24045 | 7892 | 175 |
1555183 | 1555183 | 2021-07-26 | Hall | Nebraska | 31079 | 7892 | 120 |
1551936 | 1551936 | 2021-07-25 | Hall | Nebraska | 31079 | 7892 | 120 |
1548689 | 1548689 | 2021-07-24 | Hall | Nebraska | 31079 | 7892 | 120 |
1545442 | 1545442 | 2021-07-23 | Hall | Nebraska | 31079 | 7892 | 120 |
1542194 | 1542194 | 2021-07-22 | Hall | Nebraska | 31079 | 7892 | 120 |
1538947 | 1538947 | 2021-07-21 | Hall | Nebraska | 31079 | 7892 | 120 |
1535700 | 1535700 | 2021-07-20 | Hall | Nebraska | 31079 | 7892 | 120 |
1532452 | 1532452 | 2021-07-19 | Hall | Nebraska | 31079 | 7892 | 120 |
1466350 | 1466350 | 2021-06-29 | Walker | Georgia | 13295 | 7892 | 90 |
1463105 | 1463105 | 2021-06-28 | Walker | Georgia | 13295 | 7892 | 90 |
1453370 | 1453370 | 2021-06-25 | Walker | Georgia | 13295 | 7892 | 90 |
1378088 | 1378088 | 2021-06-01 | Wood | West Virginia | 54107 | 7892 | 173 |
1084926 | 1084926 | 2021-03-03 | Pottawatomie | Oklahoma | 40125 | 7892 | 79 |
1036169 | 1036169 | 2021-02-16 | Tuscarawas | Ohio | 39157 | 7892 | 229 |
987263 | 987263 | 2021-02-01 | Caldwell | North Carolina | 37027 | 7892 | 40 |
963544 | 963544 | 2021-01-25 | Douglas | Kansas | 20045 | 7892 | 36 |
960584 | 960584 | 2021-01-24 | York | Maine | 23031 | 7892 | 96 |
957338 | 957338 | 2021-01-23 | York | Maine | 23031 | 7892 | 96 |
902362 | 902362 | 2021-01-06 | Sherburne | Minnesota | 27141 | 7892 | 60 |
760897 | 760897 | 2020-11-23 | Hays | Texas | 48209 | 7892 | 99 |
737325 | 737325 | 2020-11-16 | Onondaga | New York | 36067 | 7892 | 197 |
584136 | 584136 | 2020-09-30 | Calcasieu | Louisiana | 22019 | 7892 | 212 |
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);