ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
345 rows where deaths = 14 and state = "Florida" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1066827 | 1066827 | 2021-02-26 | Franklin | Florida | 12037 | 1278 | 14 |
1063582 | 1063582 | 2021-02-25 | Franklin | Florida | 12037 | 1278 | 14 |
1050618 | 1050618 | 2021-02-21 | Liberty | Florida | 12077 | 1036 | 14 |
1047371 | 1047371 | 2021-02-20 | Liberty | Florida | 12077 | 1036 | 14 |
1044126 | 1044126 | 2021-02-19 | Liberty | Florida | 12077 | 1035 | 14 |
1040881 | 1040881 | 2021-02-18 | Liberty | Florida | 12077 | 1032 | 14 |
1037636 | 1037636 | 2021-02-17 | Liberty | Florida | 12077 | 1030 | 14 |
1034391 | 1034391 | 2021-02-16 | Liberty | Florida | 12077 | 1029 | 14 |
1031145 | 1031145 | 2021-02-15 | Liberty | Florida | 12077 | 1026 | 14 |
1027898 | 1027898 | 2021-02-14 | Liberty | Florida | 12077 | 1026 | 14 |
1024636 | 1024636 | 2021-02-13 | Glades | Florida | 12043 | 882 | 14 |
1024653 | 1024653 | 2021-02-13 | Liberty | Florida | 12077 | 1025 | 14 |
1021391 | 1021391 | 2021-02-12 | Glades | Florida | 12043 | 879 | 14 |
1021408 | 1021408 | 2021-02-12 | Liberty | Florida | 12077 | 1023 | 14 |
1018146 | 1018146 | 2021-02-11 | Glades | Florida | 12043 | 872 | 14 |
1018163 | 1018163 | 2021-02-11 | Liberty | Florida | 12077 | 1019 | 14 |
1014894 | 1014894 | 2021-02-10 | Dixie | Florida | 12029 | 1424 | 14 |
1014901 | 1014901 | 2021-02-10 | Glades | Florida | 12043 | 872 | 14 |
1014918 | 1014918 | 2021-02-10 | Liberty | Florida | 12077 | 1014 | 14 |
1011649 | 1011649 | 2021-02-09 | Dixie | Florida | 12029 | 1418 | 14 |
1011656 | 1011656 | 2021-02-09 | Glades | Florida | 12043 | 872 | 14 |
1011673 | 1011673 | 2021-02-09 | Liberty | Florida | 12077 | 1009 | 14 |
1008403 | 1008403 | 2021-02-08 | Dixie | Florida | 12029 | 1412 | 14 |
1008427 | 1008427 | 2021-02-08 | Liberty | Florida | 12077 | 1006 | 14 |
1005157 | 1005157 | 2021-02-07 | Dixie | Florida | 12029 | 1410 | 14 |
1005181 | 1005181 | 2021-02-07 | Liberty | Florida | 12077 | 1006 | 14 |
1001911 | 1001911 | 2021-02-06 | Dixie | Florida | 12029 | 1410 | 14 |
1001935 | 1001935 | 2021-02-06 | Liberty | Florida | 12077 | 1006 | 14 |
998689 | 998689 | 2021-02-05 | Liberty | Florida | 12077 | 1005 | 14 |
995443 | 995443 | 2021-02-04 | Liberty | Florida | 12077 | 1001 | 14 |
992197 | 992197 | 2021-02-03 | Liberty | Florida | 12077 | 998 | 14 |
988951 | 988951 | 2021-02-02 | Liberty | Florida | 12077 | 995 | 14 |
985704 | 985704 | 2021-02-01 | Liberty | Florida | 12077 | 994 | 14 |
982457 | 982457 | 2021-01-31 | Liberty | Florida | 12077 | 993 | 14 |
979211 | 979211 | 2021-01-30 | Liberty | Florida | 12077 | 993 | 14 |
975966 | 975966 | 2021-01-29 | Liberty | Florida | 12077 | 991 | 14 |
972721 | 972721 | 2021-01-28 | Liberty | Florida | 12077 | 982 | 14 |
969476 | 969476 | 2021-01-27 | Liberty | Florida | 12077 | 974 | 14 |
966232 | 966232 | 2021-01-26 | Liberty | Florida | 12077 | 971 | 14 |
962987 | 962987 | 2021-01-25 | Liberty | Florida | 12077 | 967 | 14 |
959742 | 959742 | 2021-01-24 | Liberty | Florida | 12077 | 966 | 14 |
956496 | 956496 | 2021-01-23 | Liberty | Florida | 12077 | 962 | 14 |
953251 | 953251 | 2021-01-22 | Liberty | Florida | 12077 | 958 | 14 |
950006 | 950006 | 2021-01-21 | Liberty | Florida | 12077 | 952 | 14 |
946760 | 946760 | 2021-01-20 | Liberty | Florida | 12077 | 945 | 14 |
943513 | 943513 | 2021-01-19 | Liberty | Florida | 12077 | 941 | 14 |
940268 | 940268 | 2021-01-18 | Liberty | Florida | 12077 | 932 | 14 |
937023 | 937023 | 2021-01-17 | Liberty | Florida | 12077 | 931 | 14 |
933778 | 933778 | 2021-01-16 | Liberty | Florida | 12077 | 926 | 14 |
930533 | 930533 | 2021-01-15 | Liberty | Florida | 12077 | 923 | 14 |
927288 | 927288 | 2021-01-14 | Liberty | Florida | 12077 | 916 | 14 |
924042 | 924042 | 2021-01-13 | Liberty | Florida | 12077 | 890 | 14 |
920797 | 920797 | 2021-01-12 | Liberty | Florida | 12077 | 881 | 14 |
917552 | 917552 | 2021-01-11 | Liberty | Florida | 12077 | 864 | 14 |
914307 | 914307 | 2021-01-10 | Liberty | Florida | 12077 | 861 | 14 |
911062 | 911062 | 2021-01-09 | Liberty | Florida | 12077 | 855 | 14 |
907817 | 907817 | 2021-01-08 | Liberty | Florida | 12077 | 844 | 14 |
904571 | 904571 | 2021-01-07 | Liberty | Florida | 12077 | 827 | 14 |
901326 | 901326 | 2021-01-06 | Liberty | Florida | 12077 | 803 | 14 |
898081 | 898081 | 2021-01-05 | Liberty | Florida | 12077 | 795 | 14 |
894836 | 894836 | 2021-01-04 | Liberty | Florida | 12077 | 767 | 14 |
891589 | 891589 | 2021-01-03 | Liberty | Florida | 12077 | 765 | 14 |
888342 | 888342 | 2021-01-02 | Liberty | Florida | 12077 | 765 | 14 |
885097 | 885097 | 2021-01-01 | Liberty | Florida | 12077 | 750 | 14 |
881852 | 881852 | 2020-12-31 | Liberty | Florida | 12077 | 750 | 14 |
878607 | 878607 | 2020-12-30 | Liberty | Florida | 12077 | 741 | 14 |
875362 | 875362 | 2020-12-29 | Liberty | Florida | 12077 | 721 | 14 |
872117 | 872117 | 2020-12-28 | Liberty | Florida | 12077 | 716 | 14 |
868872 | 868872 | 2020-12-27 | Liberty | Florida | 12077 | 714 | 14 |
865627 | 865627 | 2020-12-26 | Liberty | Florida | 12077 | 708 | 14 |
862382 | 862382 | 2020-12-25 | Liberty | Florida | 12077 | 704 | 14 |
859137 | 859137 | 2020-12-24 | Liberty | Florida | 12077 | 704 | 14 |
855892 | 855892 | 2020-12-23 | Liberty | Florida | 12077 | 692 | 14 |
852647 | 852647 | 2020-12-22 | Liberty | Florida | 12077 | 684 | 14 |
849402 | 849402 | 2020-12-21 | Liberty | Florida | 12077 | 676 | 14 |
846151 | 846151 | 2020-12-20 | Jefferson | Florida | 12065 | 885 | 14 |
846157 | 846157 | 2020-12-20 | Liberty | Florida | 12077 | 676 | 14 |
842905 | 842905 | 2020-12-19 | Jefferson | Florida | 12065 | 875 | 14 |
842911 | 842911 | 2020-12-19 | Liberty | Florida | 12077 | 672 | 14 |
839660 | 839660 | 2020-12-18 | Jefferson | Florida | 12065 | 872 | 14 |
839666 | 839666 | 2020-12-18 | Liberty | Florida | 12077 | 666 | 14 |
836415 | 836415 | 2020-12-17 | Jefferson | Florida | 12065 | 864 | 14 |
836421 | 836421 | 2020-12-17 | Liberty | Florida | 12077 | 664 | 14 |
833175 | 833175 | 2020-12-16 | Liberty | Florida | 12077 | 657 | 14 |
829928 | 829928 | 2020-12-15 | Liberty | Florida | 12077 | 655 | 14 |
826682 | 826682 | 2020-12-14 | Liberty | Florida | 12077 | 647 | 14 |
823435 | 823435 | 2020-12-13 | Liberty | Florida | 12077 | 645 | 14 |
820189 | 820189 | 2020-12-12 | Liberty | Florida | 12077 | 645 | 14 |
816943 | 816943 | 2020-12-11 | Liberty | Florida | 12077 | 642 | 14 |
813697 | 813697 | 2020-12-10 | Liberty | Florida | 12077 | 638 | 14 |
810453 | 810453 | 2020-12-09 | Liberty | Florida | 12077 | 632 | 14 |
807208 | 807208 | 2020-12-08 | Liberty | Florida | 12077 | 631 | 14 |
803963 | 803963 | 2020-12-07 | Liberty | Florida | 12077 | 630 | 14 |
800717 | 800717 | 2020-12-06 | Levy | Florida | 12075 | 1495 | 14 |
800718 | 800718 | 2020-12-06 | Liberty | Florida | 12077 | 628 | 14 |
797472 | 797472 | 2020-12-05 | Levy | Florida | 12075 | 1482 | 14 |
797473 | 797473 | 2020-12-05 | Liberty | Florida | 12077 | 623 | 14 |
794227 | 794227 | 2020-12-04 | Levy | Florida | 12075 | 1460 | 14 |
794228 | 794228 | 2020-12-04 | Liberty | Florida | 12077 | 622 | 14 |
790982 | 790982 | 2020-12-03 | Levy | Florida | 12075 | 1452 | 14 |
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);