ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
787 rows where county = "Leon" and state = "Florida" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1063600 | 1063600 | 2021-02-25 | Leon | Florida | 12073 | 28960 | 276 |
1060355 | 1060355 | 2021-02-24 | Leon | Florida | 12073 | 28884 | 277 |
1057109 | 1057109 | 2021-02-23 | Leon | Florida | 12073 | 28795 | 273 |
1053863 | 1053863 | 2021-02-22 | Leon | Florida | 12073 | 28688 | 273 |
1050616 | 1050616 | 2021-02-21 | Leon | Florida | 12073 | 28676 | 272 |
1047369 | 1047369 | 2021-02-20 | Leon | Florida | 12073 | 28602 | 272 |
1044124 | 1044124 | 2021-02-19 | Leon | Florida | 12073 | 28496 | 272 |
1040879 | 1040879 | 2021-02-18 | Leon | Florida | 12073 | 28396 | 269 |
1037634 | 1037634 | 2021-02-17 | Leon | Florida | 12073 | 28290 | 266 |
1034389 | 1034389 | 2021-02-16 | Leon | Florida | 12073 | 28186 | 265 |
1031143 | 1031143 | 2021-02-15 | Leon | Florida | 12073 | 28075 | 266 |
1027896 | 1027896 | 2021-02-14 | Leon | Florida | 12073 | 28075 | 260 |
1024651 | 1024651 | 2021-02-13 | Leon | Florida | 12073 | 28011 | 259 |
1021406 | 1021406 | 2021-02-12 | Leon | Florida | 12073 | 27936 | 260 |
1018161 | 1018161 | 2021-02-11 | Leon | Florida | 12073 | 27806 | 258 |
1014916 | 1014916 | 2021-02-10 | Leon | Florida | 12073 | 27664 | 256 |
1011671 | 1011671 | 2021-02-09 | Leon | Florida | 12073 | 27560 | 252 |
1008425 | 1008425 | 2021-02-08 | Leon | Florida | 12073 | 27370 | 252 |
1005179 | 1005179 | 2021-02-07 | Leon | Florida | 12073 | 27358 | 250 |
1001933 | 1001933 | 2021-02-06 | Leon | Florida | 12073 | 27253 | 250 |
998687 | 998687 | 2021-02-05 | Leon | Florida | 12073 | 27143 | 248 |
995441 | 995441 | 2021-02-04 | Leon | Florida | 12073 | 26989 | 245 |
992195 | 992195 | 2021-02-03 | Leon | Florida | 12073 | 26837 | 239 |
988949 | 988949 | 2021-02-02 | Leon | Florida | 12073 | 26722 | 235 |
985702 | 985702 | 2021-02-01 | Leon | Florida | 12073 | 26542 | 235 |
982455 | 982455 | 2021-01-31 | Leon | Florida | 12073 | 26502 | 231 |
979209 | 979209 | 2021-01-30 | Leon | Florida | 12073 | 26394 | 230 |
975964 | 975964 | 2021-01-29 | Leon | Florida | 12073 | 26166 | 228 |
972719 | 972719 | 2021-01-28 | Leon | Florida | 12073 | 25986 | 224 |
969474 | 969474 | 2021-01-27 | Leon | Florida | 12073 | 25758 | 221 |
966230 | 966230 | 2021-01-26 | Leon | Florida | 12073 | 25548 | 218 |
962985 | 962985 | 2021-01-25 | Leon | Florida | 12073 | 25275 | 212 |
959740 | 959740 | 2021-01-24 | Leon | Florida | 12073 | 25159 | 209 |
956494 | 956494 | 2021-01-23 | Leon | Florida | 12073 | 24990 | 209 |
953249 | 953249 | 2021-01-22 | Leon | Florida | 12073 | 24737 | 207 |
950004 | 950004 | 2021-01-21 | Leon | Florida | 12073 | 24478 | 205 |
946758 | 946758 | 2021-01-20 | Leon | Florida | 12073 | 24177 | 204 |
943511 | 943511 | 2021-01-19 | Leon | Florida | 12073 | 23921 | 203 |
940266 | 940266 | 2021-01-18 | Leon | Florida | 12073 | 23661 | 203 |
937021 | 937021 | 2021-01-17 | Leon | Florida | 12073 | 23628 | 202 |
933776 | 933776 | 2021-01-16 | Leon | Florida | 12073 | 23393 | 201 |
930531 | 930531 | 2021-01-15 | Leon | Florida | 12073 | 23232 | 200 |
927286 | 927286 | 2021-01-14 | Leon | Florida | 12073 | 22975 | 192 |
924040 | 924040 | 2021-01-13 | Leon | Florida | 12073 | 22734 | 190 |
920795 | 920795 | 2021-01-12 | Leon | Florida | 12073 | 22530 | 188 |
917550 | 917550 | 2021-01-11 | Leon | Florida | 12073 | 22217 | 184 |
914305 | 914305 | 2021-01-10 | Leon | Florida | 12073 | 22137 | 184 |
911060 | 911060 | 2021-01-09 | Leon | Florida | 12073 | 21969 | 184 |
907815 | 907815 | 2021-01-08 | Leon | Florida | 12073 | 21701 | 182 |
904569 | 904569 | 2021-01-07 | Leon | Florida | 12073 | 21336 | 177 |
901324 | 901324 | 2021-01-06 | Leon | Florida | 12073 | 20954 | 177 |
898079 | 898079 | 2021-01-05 | Leon | Florida | 12073 | 20545 | 176 |
894834 | 894834 | 2021-01-04 | Leon | Florida | 12073 | 20167 | 176 |
891587 | 891587 | 2021-01-03 | Leon | Florida | 12073 | 20093 | 176 |
888340 | 888340 | 2021-01-02 | Leon | Florida | 12073 | 20020 | 175 |
885095 | 885095 | 2021-01-01 | Leon | Florida | 12073 | 19573 | 175 |
881850 | 881850 | 2020-12-31 | Leon | Florida | 12073 | 19573 | 175 |
878605 | 878605 | 2020-12-30 | Leon | Florida | 12073 | 19290 | 173 |
875360 | 875360 | 2020-12-29 | Leon | Florida | 12073 | 19015 | 173 |
872115 | 872115 | 2020-12-28 | Leon | Florida | 12073 | 18741 | 173 |
868870 | 868870 | 2020-12-27 | Leon | Florida | 12073 | 18705 | 173 |
865625 | 865625 | 2020-12-26 | Leon | Florida | 12073 | 18489 | 174 |
862380 | 862380 | 2020-12-25 | Leon | Florida | 12073 | 18359 | 173 |
859135 | 859135 | 2020-12-24 | Leon | Florida | 12073 | 18359 | 173 |
855890 | 855890 | 2020-12-23 | Leon | Florida | 12073 | 18164 | 171 |
852645 | 852645 | 2020-12-22 | Leon | Florida | 12073 | 17997 | 172 |
849400 | 849400 | 2020-12-21 | Leon | Florida | 12073 | 17809 | 171 |
846155 | 846155 | 2020-12-20 | Leon | Florida | 12073 | 17773 | 171 |
842909 | 842909 | 2020-12-19 | Leon | Florida | 12073 | 17684 | 167 |
839664 | 839664 | 2020-12-18 | Leon | Florida | 12073 | 17523 | 166 |
836419 | 836419 | 2020-12-17 | Leon | Florida | 12073 | 17364 | 168 |
833173 | 833173 | 2020-12-16 | Leon | Florida | 12073 | 17201 | 167 |
829926 | 829926 | 2020-12-15 | Leon | Florida | 12073 | 17075 | 167 |
826680 | 826680 | 2020-12-14 | Leon | Florida | 12073 | 16889 | 164 |
823433 | 823433 | 2020-12-13 | Leon | Florida | 12073 | 16858 | 159 |
820187 | 820187 | 2020-12-12 | Leon | Florida | 12073 | 16746 | 158 |
816941 | 816941 | 2020-12-11 | Leon | Florida | 12073 | 16611 | 154 |
813695 | 813695 | 2020-12-10 | Leon | Florida | 12073 | 16461 | 153 |
810451 | 810451 | 2020-12-09 | Leon | Florida | 12073 | 16289 | 153 |
807206 | 807206 | 2020-12-08 | Leon | Florida | 12073 | 16152 | 152 |
803961 | 803961 | 2020-12-07 | Leon | Florida | 12073 | 15880 | 152 |
800716 | 800716 | 2020-12-06 | Leon | Florida | 12073 | 15849 | 150 |
797471 | 797471 | 2020-12-05 | Leon | Florida | 12073 | 15761 | 150 |
794226 | 794226 | 2020-12-04 | Leon | Florida | 12073 | 15629 | 148 |
790981 | 790981 | 2020-12-03 | Leon | Florida | 12073 | 15504 | 147 |
787736 | 787736 | 2020-12-02 | Leon | Florida | 12073 | 15361 | 142 |
784492 | 784492 | 2020-12-01 | Leon | Florida | 12073 | 15252 | 141 |
781247 | 781247 | 2020-11-30 | Leon | Florida | 12073 | 14993 | 141 |
778001 | 778001 | 2020-11-29 | Leon | Florida | 12073 | 14974 | 140 |
774756 | 774756 | 2020-11-28 | Leon | Florida | 12073 | 14884 | 139 |
771511 | 771511 | 2020-11-27 | Leon | Florida | 12073 | 14768 | 139 |
768266 | 768266 | 2020-11-26 | Leon | Florida | 12073 | 14604 | 137 |
765020 | 765020 | 2020-11-25 | Leon | Florida | 12073 | 14604 | 137 |
761775 | 761775 | 2020-11-24 | Leon | Florida | 12073 | 14464 | 137 |
758530 | 758530 | 2020-11-23 | Leon | Florida | 12073 | 14311 | 136 |
755283 | 755283 | 2020-11-22 | Leon | Florida | 12073 | 14284 | 128 |
752037 | 752037 | 2020-11-21 | Leon | Florida | 12073 | 14187 | 128 |
748791 | 748791 | 2020-11-20 | Leon | Florida | 12073 | 14065 | 128 |
745545 | 745545 | 2020-11-19 | Leon | Florida | 12073 | 13946 | 128 |
742298 | 742298 | 2020-11-18 | Leon | Florida | 12073 | 13798 | 127 |
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);