ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
788 rows where county = "Polk" and state = "Florida" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
907832 | 907832 | 2021-01-08 | Polk | Florida | 12105 | 41620 | 828 |
904586 | 904586 | 2021-01-07 | Polk | Florida | 12105 | 40983 | 821 |
901341 | 901341 | 2021-01-06 | Polk | Florida | 12105 | 40361 | 814 |
898096 | 898096 | 2021-01-05 | Polk | Florida | 12105 | 39739 | 809 |
894851 | 894851 | 2021-01-04 | Polk | Florida | 12105 | 39268 | 791 |
891604 | 891604 | 2021-01-03 | Polk | Florida | 12105 | 38843 | 791 |
888357 | 888357 | 2021-01-02 | Polk | Florida | 12105 | 38414 | 791 |
885112 | 885112 | 2021-01-01 | Polk | Florida | 12105 | 37403 | 790 |
881867 | 881867 | 2020-12-31 | Polk | Florida | 12105 | 37403 | 790 |
878622 | 878622 | 2020-12-30 | Polk | Florida | 12105 | 36766 | 784 |
875377 | 875377 | 2020-12-29 | Polk | Florida | 12105 | 36253 | 780 |
872132 | 872132 | 2020-12-28 | Polk | Florida | 12105 | 35942 | 767 |
868887 | 868887 | 2020-12-27 | Polk | Florida | 12105 | 35656 | 767 |
865642 | 865642 | 2020-12-26 | Polk | Florida | 12105 | 35393 | 766 |
862397 | 862397 | 2020-12-25 | Polk | Florida | 12105 | 34845 | 764 |
859152 | 859152 | 2020-12-24 | Polk | Florida | 12105 | 34845 | 764 |
855907 | 855907 | 2020-12-23 | Polk | Florida | 12105 | 34349 | 760 |
852662 | 852662 | 2020-12-22 | Polk | Florida | 12105 | 34032 | 759 |
849417 | 849417 | 2020-12-21 | Polk | Florida | 12105 | 33741 | 751 |
846172 | 846172 | 2020-12-20 | Polk | Florida | 12105 | 33384 | 747 |
842926 | 842926 | 2020-12-19 | Polk | Florida | 12105 | 33142 | 746 |
839681 | 839681 | 2020-12-18 | Polk | Florida | 12105 | 32809 | 745 |
836436 | 836436 | 2020-12-17 | Polk | Florida | 12105 | 32432 | 739 |
833190 | 833190 | 2020-12-16 | Polk | Florida | 12105 | 31996 | 735 |
829943 | 829943 | 2020-12-15 | Polk | Florida | 12105 | 31668 | 730 |
826697 | 826697 | 2020-12-14 | Polk | Florida | 12105 | 31383 | 723 |
823450 | 823450 | 2020-12-13 | Polk | Florida | 12105 | 31173 | 723 |
820204 | 820204 | 2020-12-12 | Polk | Florida | 12105 | 30967 | 722 |
816958 | 816958 | 2020-12-11 | Polk | Florida | 12105 | 30628 | 721 |
813712 | 813712 | 2020-12-10 | Polk | Florida | 12105 | 30365 | 717 |
810468 | 810468 | 2020-12-09 | Polk | Florida | 12105 | 29938 | 708 |
807223 | 807223 | 2020-12-08 | Polk | Florida | 12105 | 29734 | 707 |
803978 | 803978 | 2020-12-07 | Polk | Florida | 12105 | 29362 | 702 |
800733 | 800733 | 2020-12-06 | Polk | Florida | 12105 | 29135 | 701 |
797488 | 797488 | 2020-12-05 | Polk | Florida | 12105 | 28918 | 700 |
794243 | 794243 | 2020-12-04 | Polk | Florida | 12105 | 28640 | 697 |
790998 | 790998 | 2020-12-03 | Polk | Florida | 12105 | 28399 | 691 |
787753 | 787753 | 2020-12-02 | Polk | Florida | 12105 | 28101 | 690 |
784509 | 784509 | 2020-12-01 | Polk | Florida | 12105 | 27822 | 688 |
781264 | 781264 | 2020-11-30 | Polk | Florida | 12105 | 27611 | 678 |
778018 | 778018 | 2020-11-29 | Polk | Florida | 12105 | 27481 | 674 |
774773 | 774773 | 2020-11-28 | Polk | Florida | 12105 | 27300 | 673 |
771528 | 771528 | 2020-11-27 | Polk | Florida | 12105 | 27149 | 671 |
768283 | 768283 | 2020-11-26 | Polk | Florida | 12105 | 26833 | 671 |
765037 | 765037 | 2020-11-25 | Polk | Florida | 12105 | 26833 | 671 |
761792 | 761792 | 2020-11-24 | Polk | Florida | 12105 | 26691 | 669 |
758547 | 758547 | 2020-11-23 | Polk | Florida | 12105 | 26504 | 670 |
755300 | 755300 | 2020-11-22 | Polk | Florida | 12105 | 26352 | 663 |
752054 | 752054 | 2020-11-21 | Polk | Florida | 12105 | 26253 | 660 |
748808 | 748808 | 2020-11-20 | Polk | Florida | 12105 | 26091 | 657 |
745562 | 745562 | 2020-11-19 | Polk | Florida | 12105 | 25897 | 656 |
742315 | 742315 | 2020-11-18 | Polk | Florida | 12105 | 25696 | 657 |
739068 | 739068 | 2020-11-17 | Polk | Florida | 12105 | 25531 | 654 |
735824 | 735824 | 2020-11-16 | Polk | Florida | 12105 | 25379 | 648 |
732578 | 732578 | 2020-11-15 | Polk | Florida | 12105 | 25252 | 648 |
729333 | 729333 | 2020-11-14 | Polk | Florida | 12105 | 25020 | 648 |
726090 | 726090 | 2020-11-13 | Polk | Florida | 12105 | 24941 | 647 |
722847 | 722847 | 2020-11-12 | Polk | Florida | 12105 | 24829 | 644 |
719604 | 719604 | 2020-11-11 | Polk | Florida | 12105 | 24661 | 643 |
716361 | 716361 | 2020-11-10 | Polk | Florida | 12105 | 24440 | 642 |
713117 | 713117 | 2020-11-09 | Polk | Florida | 12105 | 24227 | 638 |
709873 | 709873 | 2020-11-08 | Polk | Florida | 12105 | 24129 | 638 |
706629 | 706629 | 2020-11-07 | Polk | Florida | 12105 | 23966 | 638 |
703386 | 703386 | 2020-11-06 | Polk | Florida | 12105 | 23879 | 637 |
700143 | 700143 | 2020-11-05 | Polk | Florida | 12105 | 23763 | 635 |
696899 | 696899 | 2020-11-04 | Polk | Florida | 12105 | 23612 | 633 |
693657 | 693657 | 2020-11-03 | Polk | Florida | 12105 | 23525 | 633 |
690414 | 690414 | 2020-11-02 | Polk | Florida | 12105 | 23405 | 625 |
687169 | 687169 | 2020-11-01 | Polk | Florida | 12105 | 23306 | 623 |
683925 | 683925 | 2020-10-31 | Polk | Florida | 12105 | 23164 | 623 |
680682 | 680682 | 2020-10-30 | Polk | Florida | 12105 | 23088 | 620 |
677439 | 677439 | 2020-10-29 | Polk | Florida | 12105 | 22960 | 615 |
674196 | 674196 | 2020-10-28 | Polk | Florida | 12105 | 22852 | 615 |
670954 | 670954 | 2020-10-27 | Polk | Florida | 12105 | 22762 | 615 |
667711 | 667711 | 2020-10-26 | Polk | Florida | 12105 | 22634 | 614 |
664466 | 664466 | 2020-10-25 | Polk | Florida | 12105 | 22541 | 615 |
661222 | 661222 | 2020-10-24 | Polk | Florida | 12105 | 22481 | 615 |
657978 | 657978 | 2020-10-23 | Polk | Florida | 12105 | 22332 | 602 |
654733 | 654733 | 2020-10-22 | Polk | Florida | 12105 | 22256 | 593 |
651488 | 651488 | 2020-10-21 | Polk | Florida | 12105 | 22061 | 593 |
648244 | 648244 | 2020-10-20 | Polk | Florida | 12105 | 21981 | 592 |
644999 | 644999 | 2020-10-19 | Polk | Florida | 12105 | 21837 | 589 |
641751 | 641751 | 2020-10-18 | Polk | Florida | 12105 | 21780 | 586 |
638504 | 638504 | 2020-10-17 | Polk | Florida | 12105 | 21713 | 582 |
635259 | 635259 | 2020-10-16 | Polk | Florida | 12105 | 21572 | 578 |
632013 | 632013 | 2020-10-15 | Polk | Florida | 12105 | 21456 | 569 |
628769 | 628769 | 2020-10-14 | Polk | Florida | 12105 | 21354 | 563 |
625526 | 625526 | 2020-10-13 | Polk | Florida | 12105 | 21280 | 561 |
622283 | 622283 | 2020-10-12 | Polk | Florida | 12105 | 21157 | 557 |
619040 | 619040 | 2020-10-11 | Polk | Florida | 12105 | 21118 | 557 |
615798 | 615798 | 2020-10-10 | Polk | Florida | 12105 | 20929 | 552 |
612557 | 612557 | 2020-10-09 | Polk | Florida | 12105 | 20929 | 552 |
609315 | 609315 | 2020-10-08 | Polk | Florida | 12105 | 20814 | 549 |
606072 | 606072 | 2020-10-07 | Polk | Florida | 12105 | 20687 | 542 |
602830 | 602830 | 2020-10-06 | Polk | Florida | 12105 | 20587 | 532 |
599587 | 599587 | 2020-10-05 | Polk | Florida | 12105 | 20500 | 533 |
596344 | 596344 | 2020-10-04 | Polk | Florida | 12105 | 20425 | 531 |
593102 | 593102 | 2020-10-03 | Polk | Florida | 12105 | 20354 | 531 |
589862 | 589862 | 2020-10-02 | Polk | Florida | 12105 | 20217 | 531 |
586621 | 586621 | 2020-10-01 | Polk | Florida | 12105 | 20120 | 531 |
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);