ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
799 rows where fips = 12071 and state = "Florida" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1063599 | 1063599 | 2021-02-25 | Lee | Florida | 12071 | 57274 | 869 |
1060354 | 1060354 | 2021-02-24 | Lee | Florida | 12071 | 57123 | 869 |
1057108 | 1057108 | 2021-02-23 | Lee | Florida | 12071 | 56936 | 870 |
1053862 | 1053862 | 2021-02-22 | Lee | Florida | 12071 | 56786 | 865 |
1050615 | 1050615 | 2021-02-21 | Lee | Florida | 12071 | 56637 | 865 |
1047368 | 1047368 | 2021-02-20 | Lee | Florida | 12071 | 56491 | 865 |
1044123 | 1044123 | 2021-02-19 | Lee | Florida | 12071 | 56276 | 864 |
1040878 | 1040878 | 2021-02-18 | Lee | Florida | 12071 | 56125 | 859 |
1037633 | 1037633 | 2021-02-17 | Lee | Florida | 12071 | 56005 | 861 |
1034388 | 1034388 | 2021-02-16 | Lee | Florida | 12071 | 55829 | 861 |
1031142 | 1031142 | 2021-02-15 | Lee | Florida | 12071 | 55651 | 855 |
1027895 | 1027895 | 2021-02-14 | Lee | Florida | 12071 | 55512 | 854 |
1024650 | 1024650 | 2021-02-13 | Lee | Florida | 12071 | 55345 | 854 |
1021405 | 1021405 | 2021-02-12 | Lee | Florida | 12071 | 55175 | 849 |
1018160 | 1018160 | 2021-02-11 | Lee | Florida | 12071 | 55000 | 848 |
1014915 | 1014915 | 2021-02-10 | Lee | Florida | 12071 | 54761 | 835 |
1011670 | 1011670 | 2021-02-09 | Lee | Florida | 12071 | 54548 | 834 |
1008424 | 1008424 | 2021-02-08 | Lee | Florida | 12071 | 54372 | 829 |
1005178 | 1005178 | 2021-02-07 | Lee | Florida | 12071 | 54233 | 829 |
1001932 | 1001932 | 2021-02-06 | Lee | Florida | 12071 | 54019 | 829 |
998686 | 998686 | 2021-02-05 | Lee | Florida | 12071 | 53785 | 828 |
995440 | 995440 | 2021-02-04 | Lee | Florida | 12071 | 53548 | 813 |
992194 | 992194 | 2021-02-03 | Lee | Florida | 12071 | 53331 | 808 |
988948 | 988948 | 2021-02-02 | Lee | Florida | 12071 | 53080 | 808 |
985701 | 985701 | 2021-02-01 | Lee | Florida | 12071 | 52819 | 794 |
982454 | 982454 | 2021-01-31 | Lee | Florida | 12071 | 52652 | 794 |
979208 | 979208 | 2021-01-30 | Lee | Florida | 12071 | 52419 | 793 |
975963 | 975963 | 2021-01-29 | Lee | Florida | 12071 | 52072 | 785 |
972718 | 972718 | 2021-01-28 | Lee | Florida | 12071 | 51813 | 781 |
969473 | 969473 | 2021-01-27 | Lee | Florida | 12071 | 51454 | 779 |
966229 | 966229 | 2021-01-26 | Lee | Florida | 12071 | 51202 | 777 |
962984 | 962984 | 2021-01-25 | Lee | Florida | 12071 | 50891 | 774 |
959739 | 959739 | 2021-01-24 | Lee | Florida | 12071 | 50624 | 772 |
956493 | 956493 | 2021-01-23 | Lee | Florida | 12071 | 50277 | 771 |
953248 | 953248 | 2021-01-22 | Lee | Florida | 12071 | 49889 | 750 |
950003 | 950003 | 2021-01-21 | Lee | Florida | 12071 | 49492 | 746 |
946757 | 946757 | 2021-01-20 | Lee | Florida | 12071 | 49115 | 742 |
943510 | 943510 | 2021-01-19 | Lee | Florida | 12071 | 48777 | 730 |
940265 | 940265 | 2021-01-18 | Lee | Florida | 12071 | 48437 | 729 |
937020 | 937020 | 2021-01-17 | Lee | Florida | 12071 | 48144 | 728 |
933775 | 933775 | 2021-01-16 | Lee | Florida | 12071 | 47802 | 727 |
930530 | 930530 | 2021-01-15 | Lee | Florida | 12071 | 47421 | 726 |
927285 | 927285 | 2021-01-14 | Lee | Florida | 12071 | 46980 | 722 |
924039 | 924039 | 2021-01-13 | Lee | Florida | 12071 | 46550 | 720 |
920794 | 920794 | 2021-01-12 | Lee | Florida | 12071 | 46103 | 715 |
917549 | 917549 | 2021-01-11 | Lee | Florida | 12071 | 45649 | 715 |
914304 | 914304 | 2021-01-10 | Lee | Florida | 12071 | 45281 | 714 |
911059 | 911059 | 2021-01-09 | Lee | Florida | 12071 | 44818 | 710 |
907814 | 907814 | 2021-01-08 | Lee | Florida | 12071 | 44394 | 708 |
904568 | 904568 | 2021-01-07 | Lee | Florida | 12071 | 43870 | 695 |
901323 | 901323 | 2021-01-06 | Lee | Florida | 12071 | 43326 | 691 |
898078 | 898078 | 2021-01-05 | Lee | Florida | 12071 | 42844 | 682 |
894833 | 894833 | 2021-01-04 | Lee | Florida | 12071 | 42367 | 680 |
891586 | 891586 | 2021-01-03 | Lee | Florida | 12071 | 41915 | 675 |
888339 | 888339 | 2021-01-02 | Lee | Florida | 12071 | 41312 | 675 |
885094 | 885094 | 2021-01-01 | Lee | Florida | 12071 | 40634 | 672 |
881849 | 881849 | 2020-12-31 | Lee | Florida | 12071 | 40634 | 672 |
878604 | 878604 | 2020-12-30 | Lee | Florida | 12071 | 40168 | 673 |
875359 | 875359 | 2020-12-29 | Lee | Florida | 12071 | 39678 | 653 |
872114 | 872114 | 2020-12-28 | Lee | Florida | 12071 | 39331 | 652 |
868869 | 868869 | 2020-12-27 | Lee | Florida | 12071 | 39002 | 652 |
865624 | 865624 | 2020-12-26 | Lee | Florida | 12071 | 38574 | 651 |
862379 | 862379 | 2020-12-25 | Lee | Florida | 12071 | 38287 | 646 |
859134 | 859134 | 2020-12-24 | Lee | Florida | 12071 | 38287 | 646 |
855889 | 855889 | 2020-12-23 | Lee | Florida | 12071 | 37908 | 645 |
852644 | 852644 | 2020-12-22 | Lee | Florida | 12071 | 37506 | 643 |
849399 | 849399 | 2020-12-21 | Lee | Florida | 12071 | 37169 | 637 |
846154 | 846154 | 2020-12-20 | Lee | Florida | 12071 | 36794 | 639 |
842908 | 842908 | 2020-12-19 | Lee | Florida | 12071 | 36519 | 632 |
839663 | 839663 | 2020-12-18 | Lee | Florida | 12071 | 36144 | 630 |
836418 | 836418 | 2020-12-17 | Lee | Florida | 12071 | 35758 | 626 |
833172 | 833172 | 2020-12-16 | Lee | Florida | 12071 | 35352 | 626 |
829925 | 829925 | 2020-12-15 | Lee | Florida | 12071 | 35030 | 622 |
826679 | 826679 | 2020-12-14 | Lee | Florida | 12071 | 34716 | 615 |
823432 | 823432 | 2020-12-13 | Lee | Florida | 12071 | 34477 | 613 |
820186 | 820186 | 2020-12-12 | Lee | Florida | 12071 | 34176 | 613 |
816940 | 816940 | 2020-12-11 | Lee | Florida | 12071 | 33828 | 610 |
813694 | 813694 | 2020-12-10 | Lee | Florida | 12071 | 33430 | 610 |
810450 | 810450 | 2020-12-09 | Lee | Florida | 12071 | 33131 | 608 |
807205 | 807205 | 2020-12-08 | Lee | Florida | 12071 | 32789 | 607 |
803960 | 803960 | 2020-12-07 | Lee | Florida | 12071 | 32475 | 599 |
800715 | 800715 | 2020-12-06 | Lee | Florida | 12071 | 32208 | 598 |
797470 | 797470 | 2020-12-05 | Lee | Florida | 12071 | 31896 | 598 |
794225 | 794225 | 2020-12-04 | Lee | Florida | 12071 | 31570 | 594 |
790980 | 790980 | 2020-12-03 | Lee | Florida | 12071 | 31242 | 596 |
787735 | 787735 | 2020-12-02 | Lee | Florida | 12071 | 30855 | 588 |
784491 | 784491 | 2020-12-01 | Lee | Florida | 12071 | 30456 | 587 |
781246 | 781246 | 2020-11-30 | Lee | Florida | 12071 | 30112 | 584 |
778000 | 778000 | 2020-11-29 | Lee | Florida | 12071 | 29867 | 574 |
774755 | 774755 | 2020-11-28 | Lee | Florida | 12071 | 29612 | 574 |
771510 | 771510 | 2020-11-27 | Lee | Florida | 12071 | 29333 | 574 |
768265 | 768265 | 2020-11-26 | Lee | Florida | 12071 | 28880 | 577 |
765019 | 765019 | 2020-11-25 | Lee | Florida | 12071 | 28880 | 577 |
761774 | 761774 | 2020-11-24 | Lee | Florida | 12071 | 28607 | 570 |
758529 | 758529 | 2020-11-23 | Lee | Florida | 12071 | 28278 | 563 |
755282 | 755282 | 2020-11-22 | Lee | Florida | 12071 | 28114 | 561 |
752036 | 752036 | 2020-11-21 | Lee | Florida | 12071 | 27890 | 561 |
748790 | 748790 | 2020-11-20 | Lee | Florida | 12071 | 27584 | 556 |
745544 | 745544 | 2020-11-19 | Lee | Florida | 12071 | 27274 | 553 |
742297 | 742297 | 2020-11-18 | Lee | Florida | 12071 | 26988 | 549 |
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);