ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
785 rows where fips = 1077 and state = "Alabama" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
382760 | 382760 | 2020-07-30 | Lauderdale | Alabama | 1077 | 996 | 10 |
379543 | 379543 | 2020-07-29 | Lauderdale | Alabama | 1077 | 952 | 9 |
376327 | 376327 | 2020-07-28 | Lauderdale | Alabama | 1077 | 932 | 9 |
373113 | 373113 | 2020-07-27 | Lauderdale | Alabama | 1077 | 922 | 9 |
369901 | 369901 | 2020-07-26 | Lauderdale | Alabama | 1077 | 897 | 9 |
366691 | 366691 | 2020-07-25 | Lauderdale | Alabama | 1077 | 888 | 9 |
363484 | 363484 | 2020-07-24 | Lauderdale | Alabama | 1077 | 861 | 9 |
360278 | 360278 | 2020-07-23 | Lauderdale | Alabama | 1077 | 829 | 9 |
357073 | 357073 | 2020-07-22 | Lauderdale | Alabama | 1077 | 818 | 9 |
353870 | 353870 | 2020-07-21 | Lauderdale | Alabama | 1077 | 801 | 8 |
350668 | 350668 | 2020-07-20 | Lauderdale | Alabama | 1077 | 776 | 8 |
347467 | 347467 | 2020-07-19 | Lauderdale | Alabama | 1077 | 751 | 8 |
344267 | 344267 | 2020-07-18 | Lauderdale | Alabama | 1077 | 733 | 8 |
341068 | 341068 | 2020-07-17 | Lauderdale | Alabama | 1077 | 704 | 8 |
337872 | 337872 | 2020-07-16 | Lauderdale | Alabama | 1077 | 693 | 7 |
334677 | 334677 | 2020-07-15 | Lauderdale | Alabama | 1077 | 667 | 7 |
331484 | 331484 | 2020-07-14 | Lauderdale | Alabama | 1077 | 636 | 7 |
328298 | 328298 | 2020-07-13 | Lauderdale | Alabama | 1077 | 603 | 6 |
325112 | 325112 | 2020-07-12 | Lauderdale | Alabama | 1077 | 580 | 6 |
321931 | 321931 | 2020-07-11 | Lauderdale | Alabama | 1077 | 571 | 6 |
318752 | 318752 | 2020-07-10 | Lauderdale | Alabama | 1077 | 558 | 6 |
315579 | 315579 | 2020-07-09 | Lauderdale | Alabama | 1077 | 540 | 6 |
312404 | 312404 | 2020-07-08 | Lauderdale | Alabama | 1077 | 517 | 6 |
309235 | 309235 | 2020-07-07 | Lauderdale | Alabama | 1077 | 503 | 6 |
306066 | 306066 | 2020-07-06 | Lauderdale | Alabama | 1077 | 498 | 6 |
302902 | 302902 | 2020-07-05 | Lauderdale | Alabama | 1077 | 492 | 6 |
299738 | 299738 | 2020-07-04 | Lauderdale | Alabama | 1077 | 491 | 6 |
296576 | 296576 | 2020-07-03 | Lauderdale | Alabama | 1077 | 475 | 6 |
293421 | 293421 | 2020-07-02 | Lauderdale | Alabama | 1077 | 459 | 6 |
290268 | 290268 | 2020-07-01 | Lauderdale | Alabama | 1077 | 446 | 6 |
287118 | 287118 | 2020-06-30 | Lauderdale | Alabama | 1077 | 412 | 5 |
283972 | 283972 | 2020-06-29 | Lauderdale | Alabama | 1077 | 394 | 4 |
280826 | 280826 | 2020-06-28 | Lauderdale | Alabama | 1077 | 374 | 4 |
277678 | 277678 | 2020-06-27 | Lauderdale | Alabama | 1077 | 365 | 4 |
274530 | 274530 | 2020-06-26 | Lauderdale | Alabama | 1077 | 354 | 4 |
271390 | 271390 | 2020-06-25 | Lauderdale | Alabama | 1077 | 334 | 4 |
268256 | 268256 | 2020-06-24 | Lauderdale | Alabama | 1077 | 325 | 4 |
265127 | 265127 | 2020-06-23 | Lauderdale | Alabama | 1077 | 308 | 4 |
261998 | 261998 | 2020-06-22 | Lauderdale | Alabama | 1077 | 299 | 4 |
258871 | 258871 | 2020-06-21 | Lauderdale | Alabama | 1077 | 298 | 4 |
255744 | 255744 | 2020-06-20 | Lauderdale | Alabama | 1077 | 295 | 4 |
252625 | 252625 | 2020-06-19 | Lauderdale | Alabama | 1077 | 290 | 4 |
249510 | 249510 | 2020-06-18 | Lauderdale | Alabama | 1077 | 282 | 4 |
246398 | 246398 | 2020-06-17 | Lauderdale | Alabama | 1077 | 267 | 4 |
243285 | 243285 | 2020-06-16 | Lauderdale | Alabama | 1077 | 262 | 4 |
240174 | 240174 | 2020-06-15 | Lauderdale | Alabama | 1077 | 251 | 3 |
237066 | 237066 | 2020-06-14 | Lauderdale | Alabama | 1077 | 236 | 3 |
233959 | 233959 | 2020-06-13 | Lauderdale | Alabama | 1077 | 232 | 3 |
230854 | 230854 | 2020-06-12 | Lauderdale | Alabama | 1077 | 218 | 3 |
227750 | 227750 | 2020-06-11 | Lauderdale | Alabama | 1077 | 209 | 3 |
224649 | 224649 | 2020-06-10 | Lauderdale | Alabama | 1077 | 198 | 3 |
221553 | 221553 | 2020-06-09 | Lauderdale | Alabama | 1077 | 193 | 3 |
218461 | 218461 | 2020-06-08 | Lauderdale | Alabama | 1077 | 189 | 3 |
215371 | 215371 | 2020-06-07 | Lauderdale | Alabama | 1077 | 185 | 2 |
212284 | 212284 | 2020-06-06 | Lauderdale | Alabama | 1077 | 182 | 2 |
209199 | 209199 | 2020-06-05 | Lauderdale | Alabama | 1077 | 176 | 2 |
206117 | 206117 | 2020-06-04 | Lauderdale | Alabama | 1077 | 173 | 2 |
203038 | 203038 | 2020-06-03 | Lauderdale | Alabama | 1077 | 170 | 2 |
199962 | 199962 | 2020-06-02 | Lauderdale | Alabama | 1077 | 168 | 2 |
196889 | 196889 | 2020-06-01 | Lauderdale | Alabama | 1077 | 167 | 2 |
193819 | 193819 | 2020-05-31 | Lauderdale | Alabama | 1077 | 164 | 2 |
190753 | 190753 | 2020-05-30 | Lauderdale | Alabama | 1077 | 161 | 2 |
187689 | 187689 | 2020-05-29 | Lauderdale | Alabama | 1077 | 156 | 2 |
184632 | 184632 | 2020-05-28 | Lauderdale | Alabama | 1077 | 153 | 2 |
181580 | 181580 | 2020-05-27 | Lauderdale | Alabama | 1077 | 145 | 2 |
178536 | 178536 | 2020-05-26 | Lauderdale | Alabama | 1077 | 141 | 2 |
175491 | 175491 | 2020-05-25 | Lauderdale | Alabama | 1077 | 135 | 2 |
172448 | 172448 | 2020-05-24 | Lauderdale | Alabama | 1077 | 128 | 2 |
169407 | 169407 | 2020-05-23 | Lauderdale | Alabama | 1077 | 126 | 2 |
166371 | 166371 | 2020-05-22 | Lauderdale | Alabama | 1077 | 122 | 2 |
163339 | 163339 | 2020-05-21 | Lauderdale | Alabama | 1077 | 119 | 2 |
160311 | 160311 | 2020-05-20 | Lauderdale | Alabama | 1077 | 117 | 2 |
157287 | 157287 | 2020-05-19 | Lauderdale | Alabama | 1077 | 116 | 2 |
154271 | 154271 | 2020-05-18 | Lauderdale | Alabama | 1077 | 115 | 2 |
151259 | 151259 | 2020-05-17 | Lauderdale | Alabama | 1077 | 113 | 2 |
148250 | 148250 | 2020-05-16 | Lauderdale | Alabama | 1077 | 113 | 2 |
145247 | 145247 | 2020-05-15 | Lauderdale | Alabama | 1077 | 110 | 2 |
142248 | 142248 | 2020-05-14 | Lauderdale | Alabama | 1077 | 109 | 2 |
139252 | 139252 | 2020-05-13 | Lauderdale | Alabama | 1077 | 102 | 2 |
136261 | 136261 | 2020-05-12 | Lauderdale | Alabama | 1077 | 99 | 2 |
133271 | 133271 | 2020-05-11 | Lauderdale | Alabama | 1077 | 96 | 2 |
130281 | 130281 | 2020-05-10 | Lauderdale | Alabama | 1077 | 92 | 2 |
127291 | 127291 | 2020-05-09 | Lauderdale | Alabama | 1077 | 88 | 2 |
124306 | 124306 | 2020-05-08 | Lauderdale | Alabama | 1077 | 87 | 2 |
121326 | 121326 | 2020-05-07 | Lauderdale | Alabama | 1077 | 79 | 2 |
118360 | 118360 | 2020-05-06 | Lauderdale | Alabama | 1077 | 71 | 2 |
115401 | 115401 | 2020-05-05 | Lauderdale | Alabama | 1077 | 68 | 2 |
112518 | 112518 | 2020-05-04 | Lauderdale | Alabama | 1077 | 63 | 2 |
109643 | 109643 | 2020-05-03 | Lauderdale | Alabama | 1077 | 61 | 2 |
106774 | 106774 | 2020-05-02 | Lauderdale | Alabama | 1077 | 56 | 2 |
103909 | 103909 | 2020-05-01 | Lauderdale | Alabama | 1077 | 50 | 2 |
101054 | 101054 | 2020-04-30 | Lauderdale | Alabama | 1077 | 38 | 2 |
98204 | 98204 | 2020-04-29 | Lauderdale | Alabama | 1077 | 33 | 2 |
95359 | 95359 | 2020-04-28 | Lauderdale | Alabama | 1077 | 30 | 2 |
92529 | 92529 | 2020-04-27 | Lauderdale | Alabama | 1077 | 31 | 2 |
89711 | 89711 | 2020-04-26 | Lauderdale | Alabama | 1077 | 31 | 2 |
86895 | 86895 | 2020-04-25 | Lauderdale | Alabama | 1077 | 27 | 2 |
84087 | 84087 | 2020-04-24 | Lauderdale | Alabama | 1077 | 25 | 2 |
81286 | 81286 | 2020-04-23 | Lauderdale | Alabama | 1077 | 25 | 3 |
78493 | 78493 | 2020-04-22 | Lauderdale | Alabama | 1077 | 25 | 3 |
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);