ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
782 rows where county = "Franklin" and state = "Alabama" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
531218 | 531218 | 2020-09-14 | Franklin | Alabama | 1059 | 1693 | 28 |
527981 | 527981 | 2020-09-13 | Franklin | Alabama | 1059 | 1693 | 28 |
524745 | 524745 | 2020-09-12 | Franklin | Alabama | 1059 | 1672 | 28 |
521509 | 521509 | 2020-09-11 | Franklin | Alabama | 1059 | 1662 | 28 |
518272 | 518272 | 2020-09-10 | Franklin | Alabama | 1059 | 1653 | 28 |
515037 | 515037 | 2020-09-09 | Franklin | Alabama | 1059 | 1650 | 27 |
511804 | 511804 | 2020-09-08 | Franklin | Alabama | 1059 | 1629 | 27 |
508571 | 508571 | 2020-09-07 | Franklin | Alabama | 1059 | 1628 | 27 |
505339 | 505339 | 2020-09-06 | Franklin | Alabama | 1059 | 1621 | 27 |
502105 | 502105 | 2020-09-05 | Franklin | Alabama | 1059 | 1620 | 27 |
498871 | 498871 | 2020-09-04 | Franklin | Alabama | 1059 | 1608 | 27 |
495638 | 495638 | 2020-09-03 | Franklin | Alabama | 1059 | 1597 | 27 |
492404 | 492404 | 2020-09-02 | Franklin | Alabama | 1059 | 1580 | 27 |
489171 | 489171 | 2020-09-01 | Franklin | Alabama | 1059 | 1567 | 27 |
485938 | 485938 | 2020-08-31 | Franklin | Alabama | 1059 | 1565 | 27 |
482703 | 482703 | 2020-08-30 | Franklin | Alabama | 1059 | 1562 | 27 |
479469 | 479469 | 2020-08-29 | Franklin | Alabama | 1059 | 1554 | 27 |
476236 | 476236 | 2020-08-28 | Franklin | Alabama | 1059 | 1531 | 26 |
473003 | 473003 | 2020-08-27 | Franklin | Alabama | 1059 | 1500 | 25 |
469771 | 469771 | 2020-08-26 | Franklin | Alabama | 1059 | 1490 | 24 |
466542 | 466542 | 2020-08-25 | Franklin | Alabama | 1059 | 1480 | 24 |
463313 | 463313 | 2020-08-24 | Franklin | Alabama | 1059 | 1476 | 22 |
460084 | 460084 | 2020-08-23 | Franklin | Alabama | 1059 | 1454 | 22 |
456857 | 456857 | 2020-08-22 | Franklin | Alabama | 1059 | 1445 | 22 |
453629 | 453629 | 2020-08-21 | Franklin | Alabama | 1059 | 1440 | 22 |
450401 | 450401 | 2020-08-20 | Franklin | Alabama | 1059 | 1428 | 22 |
447173 | 447173 | 2020-08-19 | Franklin | Alabama | 1059 | 1402 | 22 |
443946 | 443946 | 2020-08-18 | Franklin | Alabama | 1059 | 1391 | 22 |
440720 | 440720 | 2020-08-17 | Franklin | Alabama | 1059 | 1377 | 22 |
437494 | 437494 | 2020-08-16 | Franklin | Alabama | 1059 | 1367 | 22 |
434268 | 434268 | 2020-08-15 | Franklin | Alabama | 1059 | 1341 | 22 |
431043 | 431043 | 2020-08-14 | Franklin | Alabama | 1059 | 1332 | 22 |
427815 | 427815 | 2020-08-13 | Franklin | Alabama | 1059 | 1327 | 22 |
424591 | 424591 | 2020-08-12 | Franklin | Alabama | 1059 | 1325 | 22 |
421370 | 421370 | 2020-08-11 | Franklin | Alabama | 1059 | 1314 | 22 |
418149 | 418149 | 2020-08-10 | Franklin | Alabama | 1059 | 1306 | 20 |
414928 | 414928 | 2020-08-09 | Franklin | Alabama | 1059 | 1292 | 20 |
411708 | 411708 | 2020-08-08 | Franklin | Alabama | 1059 | 1288 | 20 |
408489 | 408489 | 2020-08-07 | Franklin | Alabama | 1059 | 1275 | 20 |
405269 | 405269 | 2020-08-06 | Franklin | Alabama | 1059 | 1255 | 20 |
402051 | 402051 | 2020-08-05 | Franklin | Alabama | 1059 | 1232 | 20 |
398835 | 398835 | 2020-08-04 | Franklin | Alabama | 1059 | 1223 | 20 |
395619 | 395619 | 2020-08-03 | Franklin | Alabama | 1059 | 1213 | 20 |
392403 | 392403 | 2020-08-02 | Franklin | Alabama | 1059 | 1198 | 20 |
389186 | 389186 | 2020-08-01 | Franklin | Alabama | 1059 | 1177 | 20 |
385969 | 385969 | 2020-07-31 | Franklin | Alabama | 1059 | 1174 | 20 |
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 |
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);