ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
792 rows where fips = 12095 and state = "Florida" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1063612 | 1063612 | 2021-02-25 | Orange | Florida | 12095 | 113329 | 1090 |
1060367 | 1060367 | 2021-02-24 | Orange | Florida | 12095 | 112974 | 1075 |
1057121 | 1057121 | 2021-02-23 | Orange | Florida | 12095 | 112507 | 1073 |
1053875 | 1053875 | 2021-02-22 | Orange | Florida | 12095 | 112160 | 1071 |
1050628 | 1050628 | 2021-02-21 | Orange | Florida | 12095 | 111885 | 1070 |
1047381 | 1047381 | 2021-02-20 | Orange | Florida | 12095 | 111577 | 1070 |
1044136 | 1044136 | 2021-02-19 | Orange | Florida | 12095 | 111177 | 1068 |
1040891 | 1040891 | 2021-02-18 | Orange | Florida | 12095 | 110823 | 1059 |
1037646 | 1037646 | 2021-02-17 | Orange | Florida | 12095 | 110517 | 1059 |
1034401 | 1034401 | 2021-02-16 | Orange | Florida | 12095 | 110123 | 1053 |
1031155 | 1031155 | 2021-02-15 | Orange | Florida | 12095 | 109649 | 1029 |
1027908 | 1027908 | 2021-02-14 | Orange | Florida | 12095 | 109452 | 1014 |
1024663 | 1024663 | 2021-02-13 | Orange | Florida | 12095 | 109086 | 1014 |
1021418 | 1021418 | 2021-02-12 | Orange | Florida | 12095 | 108616 | 1014 |
1018173 | 1018173 | 2021-02-11 | Orange | Florida | 12095 | 108208 | 1014 |
1014928 | 1014928 | 2021-02-10 | Orange | Florida | 12095 | 107755 | 1013 |
1011683 | 1011683 | 2021-02-09 | Orange | Florida | 12095 | 107300 | 1010 |
1008437 | 1008437 | 2021-02-08 | Orange | Florida | 12095 | 106867 | 1001 |
1005191 | 1005191 | 2021-02-07 | Orange | Florida | 12095 | 106449 | 1001 |
1001945 | 1001945 | 2021-02-06 | Orange | Florida | 12095 | 106118 | 1000 |
998699 | 998699 | 2021-02-05 | Orange | Florida | 12095 | 105724 | 1000 |
995453 | 995453 | 2021-02-04 | Orange | Florida | 12095 | 104988 | 989 |
992207 | 992207 | 2021-02-03 | Orange | Florida | 12095 | 104620 | 981 |
988961 | 988961 | 2021-02-02 | Orange | Florida | 12095 | 104286 | 958 |
985714 | 985714 | 2021-02-01 | Orange | Florida | 12095 | 103648 | 957 |
982467 | 982467 | 2021-01-31 | Orange | Florida | 12095 | 103336 | 939 |
979221 | 979221 | 2021-01-30 | Orange | Florida | 12095 | 102896 | 938 |
975976 | 975976 | 2021-01-29 | Orange | Florida | 12095 | 101954 | 936 |
972731 | 972731 | 2021-01-28 | Orange | Florida | 12095 | 101245 | 936 |
969486 | 969486 | 2021-01-27 | Orange | Florida | 12095 | 100570 | 912 |
966242 | 966242 | 2021-01-26 | Orange | Florida | 12095 | 99848 | 901 |
962997 | 962997 | 2021-01-25 | Orange | Florida | 12095 | 99142 | 894 |
959752 | 959752 | 2021-01-24 | Orange | Florida | 12095 | 98490 | 893 |
956506 | 956506 | 2021-01-23 | Orange | Florida | 12095 | 97841 | 892 |
953261 | 953261 | 2021-01-22 | Orange | Florida | 12095 | 96847 | 892 |
950016 | 950016 | 2021-01-21 | Orange | Florida | 12095 | 96169 | 856 |
946770 | 946770 | 2021-01-20 | Orange | Florida | 12095 | 95405 | 849 |
943523 | 943523 | 2021-01-19 | Orange | Florida | 12095 | 94272 | 849 |
940278 | 940278 | 2021-01-18 | Orange | Florida | 12095 | 93598 | 846 |
937033 | 937033 | 2021-01-17 | Orange | Florida | 12095 | 93179 | 845 |
933788 | 933788 | 2021-01-16 | Orange | Florida | 12095 | 92438 | 827 |
930543 | 930543 | 2021-01-15 | Orange | Florida | 12095 | 91625 | 823 |
927298 | 927298 | 2021-01-14 | Orange | Florida | 12095 | 90600 | 822 |
924052 | 924052 | 2021-01-13 | Orange | Florida | 12095 | 89700 | 818 |
920807 | 920807 | 2021-01-12 | Orange | Florida | 12095 | 88696 | 804 |
917562 | 917562 | 2021-01-11 | Orange | Florida | 12095 | 87687 | 796 |
914317 | 914317 | 2021-01-10 | Orange | Florida | 12095 | 86633 | 777 |
911072 | 911072 | 2021-01-09 | Orange | Florida | 12095 | 85874 | 776 |
907827 | 907827 | 2021-01-08 | Orange | Florida | 12095 | 84853 | 776 |
904581 | 904581 | 2021-01-07 | Orange | Florida | 12095 | 83461 | 776 |
901336 | 901336 | 2021-01-06 | Orange | Florida | 12095 | 82154 | 775 |
898091 | 898091 | 2021-01-05 | Orange | Florida | 12095 | 81161 | 762 |
894846 | 894846 | 2021-01-04 | Orange | Florida | 12095 | 80052 | 750 |
891599 | 891599 | 2021-01-03 | Orange | Florida | 12095 | 79164 | 749 |
888352 | 888352 | 2021-01-02 | Orange | Florida | 12095 | 78511 | 749 |
885107 | 885107 | 2021-01-01 | Orange | Florida | 12095 | 76457 | 748 |
881862 | 881862 | 2020-12-31 | Orange | Florida | 12095 | 76457 | 748 |
878617 | 878617 | 2020-12-30 | Orange | Florida | 12095 | 75316 | 748 |
875372 | 875372 | 2020-12-29 | Orange | Florida | 12095 | 74272 | 732 |
872127 | 872127 | 2020-12-28 | Orange | Florida | 12095 | 73690 | 731 |
868882 | 868882 | 2020-12-27 | Orange | Florida | 12095 | 73049 | 727 |
865637 | 865637 | 2020-12-26 | Orange | Florida | 12095 | 72662 | 726 |
862392 | 862392 | 2020-12-25 | Orange | Florida | 12095 | 71523 | 725 |
859147 | 859147 | 2020-12-24 | Orange | Florida | 12095 | 71523 | 725 |
855902 | 855902 | 2020-12-23 | Orange | Florida | 12095 | 70813 | 725 |
852657 | 852657 | 2020-12-22 | Orange | Florida | 12095 | 70102 | 716 |
849412 | 849412 | 2020-12-21 | Orange | Florida | 12095 | 69490 | 716 |
846167 | 846167 | 2020-12-20 | Orange | Florida | 12095 | 68857 | 714 |
842921 | 842921 | 2020-12-19 | Orange | Florida | 12095 | 68366 | 712 |
839676 | 839676 | 2020-12-18 | Orange | Florida | 12095 | 67576 | 702 |
836431 | 836431 | 2020-12-17 | Orange | Florida | 12095 | 66785 | 696 |
833185 | 833185 | 2020-12-16 | Orange | Florida | 12095 | 65974 | 683 |
829938 | 829938 | 2020-12-15 | Orange | Florida | 12095 | 65250 | 680 |
826692 | 826692 | 2020-12-14 | Orange | Florida | 12095 | 64592 | 679 |
823445 | 823445 | 2020-12-13 | Orange | Florida | 12095 | 63813 | 678 |
820199 | 820199 | 2020-12-12 | Orange | Florida | 12095 | 63280 | 678 |
816953 | 816953 | 2020-12-11 | Orange | Florida | 12095 | 62521 | 677 |
813707 | 813707 | 2020-12-10 | Orange | Florida | 12095 | 61696 | 676 |
810463 | 810463 | 2020-12-09 | Orange | Florida | 12095 | 61054 | 651 |
807218 | 807218 | 2020-12-08 | Orange | Florida | 12095 | 60290 | 641 |
803973 | 803973 | 2020-12-07 | Orange | Florida | 12095 | 62040 | 657 |
800728 | 800728 | 2020-12-06 | Orange | Florida | 12095 | 61473 | 656 |
797483 | 797483 | 2020-12-05 | Orange | Florida | 12095 | 61029 | 655 |
794238 | 794238 | 2020-12-04 | Orange | Florida | 12095 | 60391 | 650 |
790993 | 790993 | 2020-12-03 | Orange | Florida | 12095 | 59790 | 651 |
787748 | 787748 | 2020-12-02 | Orange | Florida | 12095 | 59217 | 647 |
784504 | 784504 | 2020-12-01 | Orange | Florida | 12095 | 58861 | 645 |
781259 | 781259 | 2020-11-30 | Orange | Florida | 12095 | 58324 | 644 |
778013 | 778013 | 2020-11-29 | Orange | Florida | 12095 | 57804 | 644 |
774768 | 774768 | 2020-11-28 | Orange | Florida | 12095 | 57320 | 644 |
771523 | 771523 | 2020-11-27 | Orange | Florida | 12095 | 57100 | 641 |
768278 | 768278 | 2020-11-26 | Orange | Florida | 12095 | 55965 | 634 |
765032 | 765032 | 2020-11-25 | Orange | Florida | 12095 | 55965 | 634 |
761787 | 761787 | 2020-11-24 | Orange | Florida | 12095 | 55525 | 634 |
758542 | 758542 | 2020-11-23 | Orange | Florida | 12095 | 55046 | 628 |
755295 | 755295 | 2020-11-22 | Orange | Florida | 12095 | 54635 | 624 |
752049 | 752049 | 2020-11-21 | Orange | Florida | 12095 | 54340 | 624 |
748803 | 748803 | 2020-11-20 | Orange | Florida | 12095 | 53940 | 619 |
745557 | 745557 | 2020-11-19 | Orange | Florida | 12095 | 53383 | 618 |
742310 | 742310 | 2020-11-18 | Orange | Florida | 12095 | 52861 | 612 |
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);