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 |
---|---|---|---|---|---|---|---|
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 |
739051 | 739051 | 2020-11-17 | Leon | Florida | 12073 | 13677 | 128 |
735807 | 735807 | 2020-11-16 | Leon | Florida | 12073 | 13574 | 127 |
732561 | 732561 | 2020-11-15 | Leon | Florida | 12073 | 13562 | 126 |
729316 | 729316 | 2020-11-14 | Leon | Florida | 12073 | 13456 | 124 |
726073 | 726073 | 2020-11-13 | Leon | Florida | 12073 | 13394 | 120 |
722830 | 722830 | 2020-11-12 | Leon | Florida | 12073 | 13325 | 120 |
719587 | 719587 | 2020-11-11 | Leon | Florida | 12073 | 13218 | 120 |
716344 | 716344 | 2020-11-10 | Leon | Florida | 12073 | 13129 | 119 |
713100 | 713100 | 2020-11-09 | Leon | Florida | 12073 | 13013 | 119 |
709856 | 709856 | 2020-11-08 | Leon | Florida | 12073 | 12987 | 119 |
706612 | 706612 | 2020-11-07 | Leon | Florida | 12073 | 12863 | 119 |
703369 | 703369 | 2020-11-06 | Leon | Florida | 12073 | 12824 | 119 |
700126 | 700126 | 2020-11-05 | Leon | Florida | 12073 | 12745 | 119 |
696882 | 696882 | 2020-11-04 | Leon | Florida | 12073 | 12657 | 118 |
693640 | 693640 | 2020-11-03 | Leon | Florida | 12073 | 12550 | 118 |
690397 | 690397 | 2020-11-02 | Leon | Florida | 12073 | 12482 | 118 |
687152 | 687152 | 2020-11-01 | Leon | Florida | 12073 | 12429 | 118 |
683908 | 683908 | 2020-10-31 | Leon | Florida | 12073 | 12393 | 118 |
680665 | 680665 | 2020-10-30 | Leon | Florida | 12073 | 12370 | 116 |
677422 | 677422 | 2020-10-29 | Leon | Florida | 12073 | 12315 | 115 |
674179 | 674179 | 2020-10-28 | Leon | Florida | 12073 | 12245 | 115 |
670937 | 670937 | 2020-10-27 | Leon | Florida | 12073 | 12136 | 114 |
667694 | 667694 | 2020-10-26 | Leon | Florida | 12073 | 12059 | 112 |
664449 | 664449 | 2020-10-25 | Leon | Florida | 12073 | 11990 | 112 |
661205 | 661205 | 2020-10-24 | Leon | Florida | 12073 | 11957 | 112 |
657961 | 657961 | 2020-10-23 | Leon | Florida | 12073 | 11901 | 102 |
654716 | 654716 | 2020-10-22 | Leon | Florida | 12073 | 11853 | 101 |
651471 | 651471 | 2020-10-21 | Leon | Florida | 12073 | 11769 | 101 |
648227 | 648227 | 2020-10-20 | Leon | Florida | 12073 | 11716 | 101 |
644982 | 644982 | 2020-10-19 | Leon | Florida | 12073 | 11645 | 99 |
641734 | 641734 | 2020-10-18 | Leon | Florida | 12073 | 11638 | 98 |
638487 | 638487 | 2020-10-17 | Leon | Florida | 12073 | 11615 | 98 |
635242 | 635242 | 2020-10-16 | Leon | Florida | 12073 | 11563 | 97 |
631996 | 631996 | 2020-10-15 | Leon | Florida | 12073 | 11482 | 96 |
628752 | 628752 | 2020-10-14 | Leon | Florida | 12073 | 11412 | 93 |
625509 | 625509 | 2020-10-13 | Leon | Florida | 12073 | 11355 | 93 |
622266 | 622266 | 2020-10-12 | Leon | Florida | 12073 | 11315 | 92 |
619023 | 619023 | 2020-10-11 | Leon | Florida | 12073 | 11249 | 92 |
615781 | 615781 | 2020-10-10 | Leon | Florida | 12073 | 11131 | 90 |
612540 | 612540 | 2020-10-09 | Leon | Florida | 12073 | 11131 | 90 |
609298 | 609298 | 2020-10-08 | Leon | Florida | 12073 | 11063 | 90 |
606055 | 606055 | 2020-10-07 | Leon | Florida | 12073 | 10972 | 86 |
602813 | 602813 | 2020-10-06 | Leon | Florida | 12073 | 10910 | 85 |
599570 | 599570 | 2020-10-05 | Leon | Florida | 12073 | 10877 | 84 |
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);