ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
782 rows where fips = 1059 and state = "Alabama" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
382751 | 382751 | 2020-07-30 | Franklin | Alabama | 1059 | 1156 | 20 |
379534 | 379534 | 2020-07-29 | Franklin | Alabama | 1059 | 1129 | 20 |
376318 | 376318 | 2020-07-28 | Franklin | Alabama | 1059 | 1117 | 20 |
373104 | 373104 | 2020-07-27 | Franklin | Alabama | 1059 | 1110 | 20 |
369892 | 369892 | 2020-07-26 | Franklin | Alabama | 1059 | 1088 | 19 |
366682 | 366682 | 2020-07-25 | Franklin | Alabama | 1059 | 1083 | 17 |
363475 | 363475 | 2020-07-24 | Franklin | Alabama | 1059 | 1072 | 17 |
360269 | 360269 | 2020-07-23 | Franklin | Alabama | 1059 | 1057 | 17 |
357064 | 357064 | 2020-07-22 | Franklin | Alabama | 1059 | 1050 | 17 |
353861 | 353861 | 2020-07-21 | Franklin | Alabama | 1059 | 1043 | 16 |
350659 | 350659 | 2020-07-20 | Franklin | Alabama | 1059 | 1032 | 16 |
347458 | 347458 | 2020-07-19 | Franklin | Alabama | 1059 | 1025 | 16 |
344258 | 344258 | 2020-07-18 | Franklin | Alabama | 1059 | 1016 | 16 |
341059 | 341059 | 2020-07-17 | Franklin | Alabama | 1059 | 1001 | 16 |
337863 | 337863 | 2020-07-16 | Franklin | Alabama | 1059 | 984 | 16 |
334668 | 334668 | 2020-07-15 | Franklin | Alabama | 1059 | 975 | 16 |
331475 | 331475 | 2020-07-14 | Franklin | Alabama | 1059 | 965 | 16 |
328289 | 328289 | 2020-07-13 | Franklin | Alabama | 1059 | 955 | 16 |
325103 | 325103 | 2020-07-12 | Franklin | Alabama | 1059 | 943 | 16 |
321922 | 321922 | 2020-07-11 | Franklin | Alabama | 1059 | 937 | 16 |
318743 | 318743 | 2020-07-10 | Franklin | Alabama | 1059 | 933 | 16 |
315570 | 315570 | 2020-07-09 | Franklin | Alabama | 1059 | 927 | 16 |
312395 | 312395 | 2020-07-08 | Franklin | Alabama | 1059 | 911 | 16 |
309226 | 309226 | 2020-07-07 | Franklin | Alabama | 1059 | 907 | 16 |
306057 | 306057 | 2020-07-06 | Franklin | Alabama | 1059 | 903 | 14 |
302893 | 302893 | 2020-07-05 | Franklin | Alabama | 1059 | 900 | 14 |
299729 | 299729 | 2020-07-04 | Franklin | Alabama | 1059 | 894 | 14 |
296567 | 296567 | 2020-07-03 | Franklin | Alabama | 1059 | 883 | 14 |
293412 | 293412 | 2020-07-02 | Franklin | Alabama | 1059 | 867 | 14 |
290259 | 290259 | 2020-07-01 | Franklin | Alabama | 1059 | 856 | 13 |
287109 | 287109 | 2020-06-30 | Franklin | Alabama | 1059 | 847 | 13 |
283963 | 283963 | 2020-06-29 | Franklin | Alabama | 1059 | 835 | 11 |
280817 | 280817 | 2020-06-28 | Franklin | Alabama | 1059 | 839 | 11 |
277669 | 277669 | 2020-06-27 | Franklin | Alabama | 1059 | 833 | 11 |
274521 | 274521 | 2020-06-26 | Franklin | Alabama | 1059 | 830 | 11 |
271381 | 271381 | 2020-06-25 | Franklin | Alabama | 1059 | 816 | 11 |
268247 | 268247 | 2020-06-24 | Franklin | Alabama | 1059 | 803 | 10 |
265118 | 265118 | 2020-06-23 | Franklin | Alabama | 1059 | 788 | 10 |
261989 | 261989 | 2020-06-22 | Franklin | Alabama | 1059 | 783 | 10 |
258862 | 258862 | 2020-06-21 | Franklin | Alabama | 1059 | 782 | 10 |
255735 | 255735 | 2020-06-20 | Franklin | Alabama | 1059 | 776 | 10 |
252616 | 252616 | 2020-06-19 | Franklin | Alabama | 1059 | 773 | 10 |
249501 | 249501 | 2020-06-18 | Franklin | Alabama | 1059 | 764 | 10 |
246389 | 246389 | 2020-06-17 | Franklin | Alabama | 1059 | 758 | 10 |
243276 | 243276 | 2020-06-16 | Franklin | Alabama | 1059 | 741 | 10 |
240165 | 240165 | 2020-06-15 | Franklin | Alabama | 1059 | 734 | 10 |
237057 | 237057 | 2020-06-14 | Franklin | Alabama | 1059 | 727 | 10 |
233950 | 233950 | 2020-06-13 | Franklin | Alabama | 1059 | 713 | 10 |
230845 | 230845 | 2020-06-12 | Franklin | Alabama | 1059 | 668 | 10 |
227741 | 227741 | 2020-06-11 | Franklin | Alabama | 1059 | 655 | 10 |
224640 | 224640 | 2020-06-10 | Franklin | Alabama | 1059 | 637 | 10 |
221544 | 221544 | 2020-06-09 | Franklin | Alabama | 1059 | 634 | 10 |
218452 | 218452 | 2020-06-08 | Franklin | Alabama | 1059 | 628 | 10 |
215362 | 215362 | 2020-06-07 | Franklin | Alabama | 1059 | 620 | 9 |
212275 | 212275 | 2020-06-06 | Franklin | Alabama | 1059 | 611 | 9 |
209190 | 209190 | 2020-06-05 | Franklin | Alabama | 1059 | 596 | 9 |
206108 | 206108 | 2020-06-04 | Franklin | Alabama | 1059 | 588 | 8 |
203029 | 203029 | 2020-06-03 | Franklin | Alabama | 1059 | 581 | 8 |
199953 | 199953 | 2020-06-02 | Franklin | Alabama | 1059 | 579 | 8 |
196880 | 196880 | 2020-06-01 | Franklin | Alabama | 1059 | 565 | 8 |
193810 | 193810 | 2020-05-31 | Franklin | Alabama | 1059 | 556 | 7 |
190744 | 190744 | 2020-05-30 | Franklin | Alabama | 1059 | 545 | 7 |
187680 | 187680 | 2020-05-29 | Franklin | Alabama | 1059 | 540 | 7 |
184623 | 184623 | 2020-05-28 | Franklin | Alabama | 1059 | 514 | 7 |
181571 | 181571 | 2020-05-27 | Franklin | Alabama | 1059 | 498 | 6 |
178527 | 178527 | 2020-05-26 | Franklin | Alabama | 1059 | 486 | 6 |
175482 | 175482 | 2020-05-25 | Franklin | Alabama | 1059 | 467 | 6 |
172439 | 172439 | 2020-05-24 | Franklin | Alabama | 1059 | 447 | 6 |
169398 | 169398 | 2020-05-23 | Franklin | Alabama | 1059 | 435 | 6 |
166362 | 166362 | 2020-05-22 | Franklin | Alabama | 1059 | 422 | 5 |
163330 | 163330 | 2020-05-21 | Franklin | Alabama | 1059 | 411 | 5 |
160302 | 160302 | 2020-05-20 | Franklin | Alabama | 1059 | 399 | 5 |
157278 | 157278 | 2020-05-19 | Franklin | Alabama | 1059 | 364 | 4 |
154262 | 154262 | 2020-05-18 | Franklin | Alabama | 1059 | 344 | 4 |
151250 | 151250 | 2020-05-17 | Franklin | Alabama | 1059 | 334 | 4 |
148241 | 148241 | 2020-05-16 | Franklin | Alabama | 1059 | 329 | 4 |
145238 | 145238 | 2020-05-15 | Franklin | Alabama | 1059 | 309 | 4 |
142239 | 142239 | 2020-05-14 | Franklin | Alabama | 1059 | 288 | 3 |
139243 | 139243 | 2020-05-13 | Franklin | Alabama | 1059 | 270 | 3 |
136252 | 136252 | 2020-05-12 | Franklin | Alabama | 1059 | 264 | 3 |
133262 | 133262 | 2020-05-11 | Franklin | Alabama | 1059 | 247 | 2 |
130272 | 130272 | 2020-05-10 | Franklin | Alabama | 1059 | 226 | 1 |
127282 | 127282 | 2020-05-09 | Franklin | Alabama | 1059 | 216 | 1 |
124297 | 124297 | 2020-05-08 | Franklin | Alabama | 1059 | 202 | 1 |
121317 | 121317 | 2020-05-07 | Franklin | Alabama | 1059 | 184 | 1 |
118351 | 118351 | 2020-05-06 | Franklin | Alabama | 1059 | 164 | 1 |
115392 | 115392 | 2020-05-05 | Franklin | Alabama | 1059 | 152 | 0 |
112509 | 112509 | 2020-05-04 | Franklin | Alabama | 1059 | 136 | 0 |
109634 | 109634 | 2020-05-03 | Franklin | Alabama | 1059 | 132 | 0 |
106765 | 106765 | 2020-05-02 | Franklin | Alabama | 1059 | 100 | 0 |
103900 | 103900 | 2020-05-01 | Franklin | Alabama | 1059 | 78 | 0 |
101045 | 101045 | 2020-04-30 | Franklin | Alabama | 1059 | 58 | 0 |
98195 | 98195 | 2020-04-29 | Franklin | Alabama | 1059 | 45 | 0 |
95350 | 95350 | 2020-04-28 | Franklin | Alabama | 1059 | 44 | 0 |
92520 | 92520 | 2020-04-27 | Franklin | Alabama | 1059 | 43 | 0 |
89702 | 89702 | 2020-04-26 | Franklin | Alabama | 1059 | 41 | 0 |
86886 | 86886 | 2020-04-25 | Franklin | Alabama | 1059 | 38 | 0 |
84078 | 84078 | 2020-04-24 | Franklin | Alabama | 1059 | 32 | 0 |
81277 | 81277 | 2020-04-23 | Franklin | Alabama | 1059 | 25 | 0 |
78484 | 78484 | 2020-04-22 | Franklin | Alabama | 1059 | 22 | 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);