ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
22 rows where cases = 92 and state = "Alabama" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths, date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
376307 | 376307 | 2020-07-28 | Coosa | Alabama | 1037 | 92 | 2 |
331459 | 331459 | 2020-07-14 | Clay | Alabama | 1027 | 92 | 2 |
315571 | 315571 | 2020-07-09 | Geneva | Alabama | 1061 | 92 | 0 |
224614 | 224614 | 2020-06-10 | Bibb | Alabama | 1007 | 92 | 1 |
221535 | 221535 | 2020-06-09 | Crenshaw | Alabama | 1041 | 92 | 3 |
206145 | 206145 | 2020-06-04 | Winston | Alabama | 1133 | 92 | 0 |
203066 | 203066 | 2020-06-03 | Winston | Alabama | 1133 | 92 | 0 |
199990 | 199990 | 2020-06-02 | Winston | Alabama | 1133 | 92 | 0 |
187692 | 187692 | 2020-05-29 | Limestone | Alabama | 1083 | 92 | 0 |
184625 | 184625 | 2020-05-28 | Greene | Alabama | 1063 | 92 | 4 |
178520 | 178520 | 2020-05-26 | Dale | Alabama | 1045 | 92 | 0 |
166345 | 166345 | 2020-05-22 | Clarke | Alabama | 1025 | 92 | 2 |
157260 | 157260 | 2020-05-19 | Choctaw | Alabama | 1023 | 92 | 3 |
145274 | 145274 | 2020-05-15 | Wilcox | Alabama | 1131 | 92 | 5 |
130281 | 130281 | 2020-05-10 | Lauderdale | Alabama | 1077 | 92 | 2 |
127304 | 127304 | 2020-05-09 | Morgan | Alabama | 1103 | 92 | 0 |
121347 | 121347 | 2020-05-07 | Sumter | Alabama | 1119 | 92 | 4 |
118368 | 118368 | 2020-05-06 | Marion | Alabama | 1093 | 92 | 7 |
106742 | 106742 | 2020-05-02 | Butler | Alabama | 1013 | 92 | 1 |
95328 | 95328 | 2020-04-28 | Calhoun | Alabama | 1015 | 92 | 3 |
89736 | 89736 | 2020-04-26 | Walker | Alabama | 1127 | 92 | 0 |
45847 | 45847 | 2020-04-10 | Montgomery | Alabama | 1101 | 92 | 4 |
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);