ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
799 rows where county = "Lee" and state = "Florida" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1193465 | 1193465 | 2021-04-06 | Lee | Florida | 12071 | 63773 | 930 |
1190215 | 1190215 | 2021-04-05 | Lee | Florida | 12071 | 63571 | 923 |
1186968 | 1186968 | 2021-04-04 | Lee | Florida | 12071 | 63511 | 923 |
1183721 | 1183721 | 2021-04-03 | Lee | Florida | 12071 | 63333 | 923 |
1180474 | 1180474 | 2021-04-02 | Lee | Florida | 12071 | 63129 | 921 |
1177227 | 1177227 | 2021-04-01 | Lee | Florida | 12071 | 62901 | 921 |
1173980 | 1173980 | 2021-03-31 | Lee | Florida | 12071 | 62712 | 915 |
1170733 | 1170733 | 2021-03-30 | Lee | Florida | 12071 | 62482 | 913 |
1167485 | 1167485 | 2021-03-29 | Lee | Florida | 12071 | 62299 | 910 |
1164237 | 1164237 | 2021-03-28 | Lee | Florida | 12071 | 62142 | 910 |
1160989 | 1160989 | 2021-03-27 | Lee | Florida | 12071 | 61967 | 910 |
1157741 | 1157741 | 2021-03-26 | Lee | Florida | 12071 | 61775 | 910 |
1154494 | 1154494 | 2021-03-25 | Lee | Florida | 12071 | 61571 | 910 |
1151247 | 1151247 | 2021-03-24 | Lee | Florida | 12071 | 61387 | 909 |
1148000 | 1148000 | 2021-03-23 | Lee | Florida | 12071 | 61201 | 907 |
1144753 | 1144753 | 2021-03-22 | Lee | Florida | 12071 | 61014 | 907 |
1141506 | 1141506 | 2021-03-21 | Lee | Florida | 12071 | 60913 | 906 |
1138260 | 1138260 | 2021-03-20 | Lee | Florida | 12071 | 60771 | 906 |
1135014 | 1135014 | 2021-03-19 | Lee | Florida | 12071 | 60613 | 906 |
1131767 | 1131767 | 2021-03-18 | Lee | Florida | 12071 | 60450 | 905 |
1128519 | 1128519 | 2021-03-17 | Lee | Florida | 12071 | 60277 | 905 |
1125273 | 1125273 | 2021-03-16 | Lee | Florida | 12071 | 60116 | 904 |
1122027 | 1122027 | 2021-03-15 | Lee | Florida | 12071 | 59950 | 900 |
1118780 | 1118780 | 2021-03-14 | Lee | Florida | 12071 | 59833 | 900 |
1115533 | 1115533 | 2021-03-13 | Lee | Florida | 12071 | 59684 | 904 |
1112287 | 1112287 | 2021-03-12 | Lee | Florida | 12071 | 59517 | 899 |
1109041 | 1109041 | 2021-03-11 | Lee | Florida | 12071 | 59370 | 899 |
1105795 | 1105795 | 2021-03-10 | Lee | Florida | 12071 | 59219 | 895 |
1102549 | 1102549 | 2021-03-09 | Lee | Florida | 12071 | 59052 | 894 |
1099303 | 1099303 | 2021-03-08 | Lee | Florida | 12071 | 58885 | 889 |
1096055 | 1096055 | 2021-03-07 | Lee | Florida | 12071 | 58767 | 889 |
1092809 | 1092809 | 2021-03-06 | Lee | Florida | 12071 | 58652 | 889 |
1089563 | 1089563 | 2021-03-05 | Lee | Florida | 12071 | 58528 | 886 |
1086318 | 1086318 | 2021-03-04 | Lee | Florida | 12071 | 58359 | 883 |
1083072 | 1083072 | 2021-03-03 | Lee | Florida | 12071 | 58192 | 877 |
1079826 | 1079826 | 2021-03-02 | Lee | Florida | 12071 | 58003 | 877 |
1076581 | 1076581 | 2021-03-01 | Lee | Florida | 12071 | 57762 | 872 |
1073335 | 1073335 | 2021-02-28 | Lee | Florida | 12071 | 57736 | 872 |
1070089 | 1070089 | 2021-02-27 | Lee | Florida | 12071 | 57617 | 872 |
1066844 | 1066844 | 2021-02-26 | Lee | Florida | 12071 | 57468 | 872 |
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 |
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);