ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
792 rows where fips = 1083 and state = "Alabama" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
382763 | 382763 | 2020-07-30 | Limestone | Alabama | 1083 | 1134 | 12 |
379546 | 379546 | 2020-07-29 | Limestone | Alabama | 1083 | 1096 | 12 |
376330 | 376330 | 2020-07-28 | Limestone | Alabama | 1083 | 1064 | 11 |
373116 | 373116 | 2020-07-27 | Limestone | Alabama | 1083 | 1048 | 11 |
369904 | 369904 | 2020-07-26 | Limestone | Alabama | 1083 | 1023 | 10 |
366694 | 366694 | 2020-07-25 | Limestone | Alabama | 1083 | 1018 | 10 |
363487 | 363487 | 2020-07-24 | Limestone | Alabama | 1083 | 986 | 10 |
360281 | 360281 | 2020-07-23 | Limestone | Alabama | 1083 | 958 | 8 |
357076 | 357076 | 2020-07-22 | Limestone | Alabama | 1083 | 940 | 8 |
353873 | 353873 | 2020-07-21 | Limestone | Alabama | 1083 | 914 | 7 |
350671 | 350671 | 2020-07-20 | Limestone | Alabama | 1083 | 889 | 6 |
347470 | 347470 | 2020-07-19 | Limestone | Alabama | 1083 | 854 | 6 |
344270 | 344270 | 2020-07-18 | Limestone | Alabama | 1083 | 823 | 6 |
341071 | 341071 | 2020-07-17 | Limestone | Alabama | 1083 | 796 | 6 |
337875 | 337875 | 2020-07-16 | Limestone | Alabama | 1083 | 757 | 5 |
334680 | 334680 | 2020-07-15 | Limestone | Alabama | 1083 | 731 | 5 |
331487 | 331487 | 2020-07-14 | Limestone | Alabama | 1083 | 697 | 5 |
328301 | 328301 | 2020-07-13 | Limestone | Alabama | 1083 | 671 | 4 |
325115 | 325115 | 2020-07-12 | Limestone | Alabama | 1083 | 645 | 4 |
321934 | 321934 | 2020-07-11 | Limestone | Alabama | 1083 | 628 | 4 |
318755 | 318755 | 2020-07-10 | Limestone | Alabama | 1083 | 602 | 4 |
315582 | 315582 | 2020-07-09 | Limestone | Alabama | 1083 | 579 | 1 |
312407 | 312407 | 2020-07-08 | Limestone | Alabama | 1083 | 530 | 1 |
309238 | 309238 | 2020-07-07 | Limestone | Alabama | 1083 | 523 | 1 |
306069 | 306069 | 2020-07-06 | Limestone | Alabama | 1083 | 506 | 0 |
302905 | 302905 | 2020-07-05 | Limestone | Alabama | 1083 | 500 | 0 |
299741 | 299741 | 2020-07-04 | Limestone | Alabama | 1083 | 486 | 0 |
296579 | 296579 | 2020-07-03 | Limestone | Alabama | 1083 | 471 | 0 |
293424 | 293424 | 2020-07-02 | Limestone | Alabama | 1083 | 434 | 0 |
290271 | 290271 | 2020-07-01 | Limestone | Alabama | 1083 | 413 | 0 |
287121 | 287121 | 2020-06-30 | Limestone | Alabama | 1083 | 407 | 0 |
283975 | 283975 | 2020-06-29 | Limestone | Alabama | 1083 | 398 | 0 |
280829 | 280829 | 2020-06-28 | Limestone | Alabama | 1083 | 363 | 0 |
277681 | 277681 | 2020-06-27 | Limestone | Alabama | 1083 | 355 | 0 |
274533 | 274533 | 2020-06-26 | Limestone | Alabama | 1083 | 338 | 0 |
271393 | 271393 | 2020-06-25 | Limestone | Alabama | 1083 | 321 | 0 |
268259 | 268259 | 2020-06-24 | Limestone | Alabama | 1083 | 297 | 0 |
265130 | 265130 | 2020-06-23 | Limestone | Alabama | 1083 | 285 | 0 |
262001 | 262001 | 2020-06-22 | Limestone | Alabama | 1083 | 275 | 0 |
258874 | 258874 | 2020-06-21 | Limestone | Alabama | 1083 | 271 | 0 |
255747 | 255747 | 2020-06-20 | Limestone | Alabama | 1083 | 267 | 0 |
252628 | 252628 | 2020-06-19 | Limestone | Alabama | 1083 | 262 | 0 |
249513 | 249513 | 2020-06-18 | Limestone | Alabama | 1083 | 257 | 0 |
246401 | 246401 | 2020-06-17 | Limestone | Alabama | 1083 | 244 | 0 |
243288 | 243288 | 2020-06-16 | Limestone | Alabama | 1083 | 238 | 0 |
240177 | 240177 | 2020-06-15 | Limestone | Alabama | 1083 | 228 | 0 |
237069 | 237069 | 2020-06-14 | Limestone | Alabama | 1083 | 217 | 0 |
233962 | 233962 | 2020-06-13 | Limestone | Alabama | 1083 | 199 | 0 |
230857 | 230857 | 2020-06-12 | Limestone | Alabama | 1083 | 177 | 0 |
227753 | 227753 | 2020-06-11 | Limestone | Alabama | 1083 | 164 | 0 |
224652 | 224652 | 2020-06-10 | Limestone | Alabama | 1083 | 153 | 0 |
221556 | 221556 | 2020-06-09 | Limestone | Alabama | 1083 | 146 | 0 |
218464 | 218464 | 2020-06-08 | Limestone | Alabama | 1083 | 137 | 0 |
215374 | 215374 | 2020-06-07 | Limestone | Alabama | 1083 | 125 | 0 |
212287 | 212287 | 2020-06-06 | Limestone | Alabama | 1083 | 121 | 0 |
209202 | 209202 | 2020-06-05 | Limestone | Alabama | 1083 | 112 | 0 |
206120 | 206120 | 2020-06-04 | Limestone | Alabama | 1083 | 110 | 0 |
203041 | 203041 | 2020-06-03 | Limestone | Alabama | 1083 | 110 | 0 |
199965 | 199965 | 2020-06-02 | Limestone | Alabama | 1083 | 110 | 0 |
196892 | 196892 | 2020-06-01 | Limestone | Alabama | 1083 | 110 | 0 |
193822 | 193822 | 2020-05-31 | Limestone | Alabama | 1083 | 106 | 0 |
190756 | 190756 | 2020-05-30 | Limestone | Alabama | 1083 | 94 | 0 |
187692 | 187692 | 2020-05-29 | Limestone | Alabama | 1083 | 92 | 0 |
184635 | 184635 | 2020-05-28 | Limestone | Alabama | 1083 | 87 | 0 |
181583 | 181583 | 2020-05-27 | Limestone | Alabama | 1083 | 86 | 0 |
178539 | 178539 | 2020-05-26 | Limestone | Alabama | 1083 | 82 | 0 |
175494 | 175494 | 2020-05-25 | Limestone | Alabama | 1083 | 77 | 0 |
172451 | 172451 | 2020-05-24 | Limestone | Alabama | 1083 | 74 | 0 |
169410 | 169410 | 2020-05-23 | Limestone | Alabama | 1083 | 72 | 0 |
166374 | 166374 | 2020-05-22 | Limestone | Alabama | 1083 | 72 | 0 |
163342 | 163342 | 2020-05-21 | Limestone | Alabama | 1083 | 71 | 0 |
160314 | 160314 | 2020-05-20 | Limestone | Alabama | 1083 | 69 | 0 |
157290 | 157290 | 2020-05-19 | Limestone | Alabama | 1083 | 65 | 0 |
154274 | 154274 | 2020-05-18 | Limestone | Alabama | 1083 | 65 | 0 |
151262 | 151262 | 2020-05-17 | Limestone | Alabama | 1083 | 64 | 0 |
148253 | 148253 | 2020-05-16 | Limestone | Alabama | 1083 | 64 | 0 |
145250 | 145250 | 2020-05-15 | Limestone | Alabama | 1083 | 64 | 0 |
142251 | 142251 | 2020-05-14 | Limestone | Alabama | 1083 | 62 | 0 |
139255 | 139255 | 2020-05-13 | Limestone | Alabama | 1083 | 60 | 0 |
136264 | 136264 | 2020-05-12 | Limestone | Alabama | 1083 | 58 | 0 |
133274 | 133274 | 2020-05-11 | Limestone | Alabama | 1083 | 57 | 0 |
130284 | 130284 | 2020-05-10 | Limestone | Alabama | 1083 | 57 | 0 |
127294 | 127294 | 2020-05-09 | Limestone | Alabama | 1083 | 57 | 0 |
124309 | 124309 | 2020-05-08 | Limestone | Alabama | 1083 | 55 | 0 |
121329 | 121329 | 2020-05-07 | Limestone | Alabama | 1083 | 54 | 0 |
118363 | 118363 | 2020-05-06 | Limestone | Alabama | 1083 | 49 | 0 |
115404 | 115404 | 2020-05-05 | Limestone | Alabama | 1083 | 48 | 0 |
112521 | 112521 | 2020-05-04 | Limestone | Alabama | 1083 | 47 | 0 |
109646 | 109646 | 2020-05-03 | Limestone | Alabama | 1083 | 45 | 0 |
106777 | 106777 | 2020-05-02 | Limestone | Alabama | 1083 | 44 | 0 |
103912 | 103912 | 2020-05-01 | Limestone | Alabama | 1083 | 44 | 0 |
101057 | 101057 | 2020-04-30 | Limestone | Alabama | 1083 | 44 | 0 |
98207 | 98207 | 2020-04-29 | Limestone | Alabama | 1083 | 44 | 0 |
95362 | 95362 | 2020-04-28 | Limestone | Alabama | 1083 | 44 | 0 |
92532 | 92532 | 2020-04-27 | Limestone | Alabama | 1083 | 42 | 0 |
89714 | 89714 | 2020-04-26 | Limestone | Alabama | 1083 | 41 | 0 |
86898 | 86898 | 2020-04-25 | Limestone | Alabama | 1083 | 41 | 0 |
84090 | 84090 | 2020-04-24 | Limestone | Alabama | 1083 | 41 | 0 |
81289 | 81289 | 2020-04-23 | Limestone | Alabama | 1083 | 40 | 0 |
78496 | 78496 | 2020-04-22 | Limestone | Alabama | 1083 | 38 | 0 |
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);