ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
788 rows where fips = 12105 and state = "Florida" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1063617 | 1063617 | 2021-02-25 | Polk | Florida | 12105 | 56583 | 1131 |
1060372 | 1060372 | 2021-02-24 | Polk | Florida | 12105 | 56409 | 1133 |
1057126 | 1057126 | 2021-02-23 | Polk | Florida | 12105 | 56153 | 1116 |
1053880 | 1053880 | 2021-02-22 | Polk | Florida | 12105 | 55986 | 1108 |
1050633 | 1050633 | 2021-02-21 | Polk | Florida | 12105 | 55861 | 1107 |
1047386 | 1047386 | 2021-02-20 | Polk | Florida | 12105 | 55694 | 1107 |
1044141 | 1044141 | 2021-02-19 | Polk | Florida | 12105 | 55473 | 1101 |
1040896 | 1040896 | 2021-02-18 | Polk | Florida | 12105 | 55269 | 1094 |
1037651 | 1037651 | 2021-02-17 | Polk | Florida | 12105 | 55058 | 1087 |
1034406 | 1034406 | 2021-02-16 | Polk | Florida | 12105 | 54829 | 1077 |
1031160 | 1031160 | 2021-02-15 | Polk | Florida | 12105 | 54573 | 1057 |
1027913 | 1027913 | 2021-02-14 | Polk | Florida | 12105 | 54435 | 1056 |
1024668 | 1024668 | 2021-02-13 | Polk | Florida | 12105 | 54235 | 1056 |
1021423 | 1021423 | 2021-02-12 | Polk | Florida | 12105 | 53925 | 1050 |
1018178 | 1018178 | 2021-02-11 | Polk | Florida | 12105 | 53651 | 1050 |
1014933 | 1014933 | 2021-02-10 | Polk | Florida | 12105 | 53316 | 1030 |
1011688 | 1011688 | 2021-02-09 | Polk | Florida | 12105 | 53005 | 1029 |
1008442 | 1008442 | 2021-02-08 | Polk | Florida | 12105 | 52731 | 1008 |
1005196 | 1005196 | 2021-02-07 | Polk | Florida | 12105 | 52533 | 1008 |
1001950 | 1001950 | 2021-02-06 | Polk | Florida | 12105 | 52275 | 1008 |
998704 | 998704 | 2021-02-05 | Polk | Florida | 12105 | 52029 | 1008 |
995458 | 995458 | 2021-02-04 | Polk | Florida | 12105 | 51630 | 991 |
992212 | 992212 | 2021-02-03 | Polk | Florida | 12105 | 51297 | 979 |
988966 | 988966 | 2021-02-02 | Polk | Florida | 12105 | 51050 | 977 |
985719 | 985719 | 2021-02-01 | Polk | Florida | 12105 | 50702 | 967 |
982472 | 982472 | 2021-01-31 | Polk | Florida | 12105 | 50474 | 967 |
979226 | 979226 | 2021-01-30 | Polk | Florida | 12105 | 50201 | 967 |
975981 | 975981 | 2021-01-29 | Polk | Florida | 12105 | 49692 | 964 |
972736 | 972736 | 2021-01-28 | Polk | Florida | 12105 | 49348 | 960 |
969491 | 969491 | 2021-01-27 | Polk | Florida | 12105 | 48974 | 953 |
966247 | 966247 | 2021-01-26 | Polk | Florida | 12105 | 48656 | 942 |
963002 | 963002 | 2021-01-25 | Polk | Florida | 12105 | 48371 | 929 |
959757 | 959757 | 2021-01-24 | Polk | Florida | 12105 | 48119 | 929 |
956511 | 956511 | 2021-01-23 | Polk | Florida | 12105 | 47795 | 928 |
953266 | 953266 | 2021-01-22 | Polk | Florida | 12105 | 47254 | 920 |
950021 | 950021 | 2021-01-21 | Polk | Florida | 12105 | 46855 | 914 |
946775 | 946775 | 2021-01-20 | Polk | Florida | 12105 | 46486 | 909 |
943528 | 943528 | 2021-01-19 | Polk | Florida | 12105 | 46137 | 895 |
940283 | 940283 | 2021-01-18 | Polk | Florida | 12105 | 45853 | 891 |
937038 | 937038 | 2021-01-17 | Polk | Florida | 12105 | 45550 | 891 |
933793 | 933793 | 2021-01-16 | Polk | Florida | 12105 | 45224 | 887 |
930548 | 930548 | 2021-01-15 | Polk | Florida | 12105 | 44755 | 884 |
927303 | 927303 | 2021-01-14 | Polk | Florida | 12105 | 44252 | 874 |
924057 | 924057 | 2021-01-13 | Polk | Florida | 12105 | 43839 | 868 |
920812 | 920812 | 2021-01-12 | Polk | Florida | 12105 | 43363 | 863 |
917567 | 917567 | 2021-01-11 | Polk | Florida | 12105 | 42880 | 835 |
914322 | 914322 | 2021-01-10 | Polk | Florida | 12105 | 42422 | 834 |
911077 | 911077 | 2021-01-09 | Polk | Florida | 12105 | 42056 | 834 |
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 |
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);