ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
795 rows where county = "Pinellas" and state = "Florida" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
953265 | 953265 | 2021-01-22 | Pinellas | Florida | 12103 | 56247 | 1209 |
950020 | 950020 | 2021-01-21 | Pinellas | Florida | 12103 | 55564 | 1208 |
946774 | 946774 | 2021-01-20 | Pinellas | Florida | 12103 | 55241 | 1206 |
943527 | 943527 | 2021-01-19 | Pinellas | Florida | 12103 | 54924 | 1202 |
940282 | 940282 | 2021-01-18 | Pinellas | Florida | 12103 | 54529 | 1184 |
937037 | 937037 | 2021-01-17 | Pinellas | Florida | 12103 | 54212 | 1175 |
933792 | 933792 | 2021-01-16 | Pinellas | Florida | 12103 | 53882 | 1173 |
930547 | 930547 | 2021-01-15 | Pinellas | Florida | 12103 | 53445 | 1169 |
927302 | 927302 | 2021-01-14 | Pinellas | Florida | 12103 | 52739 | 1157 |
924056 | 924056 | 2021-01-13 | Pinellas | Florida | 12103 | 52357 | 1149 |
920811 | 920811 | 2021-01-12 | Pinellas | Florida | 12103 | 51874 | 1132 |
917566 | 917566 | 2021-01-11 | Pinellas | Florida | 12103 | 51384 | 1129 |
914321 | 914321 | 2021-01-10 | Pinellas | Florida | 12103 | 50978 | 1128 |
911076 | 911076 | 2021-01-09 | Pinellas | Florida | 12103 | 50491 | 1121 |
907831 | 907831 | 2021-01-08 | Pinellas | Florida | 12103 | 49771 | 1117 |
904585 | 904585 | 2021-01-07 | Pinellas | Florida | 12103 | 48998 | 1114 |
901340 | 901340 | 2021-01-06 | Pinellas | Florida | 12103 | 48273 | 1106 |
898095 | 898095 | 2021-01-05 | Pinellas | Florida | 12103 | 47739 | 1086 |
894850 | 894850 | 2021-01-04 | Pinellas | Florida | 12103 | 47207 | 1079 |
891603 | 891603 | 2021-01-03 | Pinellas | Florida | 12103 | 46860 | 1066 |
888356 | 888356 | 2021-01-02 | Pinellas | Florida | 12103 | 46310 | 1052 |
885111 | 885111 | 2021-01-01 | Pinellas | Florida | 12103 | 44975 | 1049 |
881866 | 881866 | 2020-12-31 | Pinellas | Florida | 12103 | 44975 | 1049 |
878621 | 878621 | 2020-12-30 | Pinellas | Florida | 12103 | 44243 | 1045 |
875376 | 875376 | 2020-12-29 | Pinellas | Florida | 12103 | 43869 | 1040 |
872131 | 872131 | 2020-12-28 | Pinellas | Florida | 12103 | 43480 | 1035 |
868886 | 868886 | 2020-12-27 | Pinellas | Florida | 12103 | 43210 | 1029 |
865641 | 865641 | 2020-12-26 | Pinellas | Florida | 12103 | 42973 | 1020 |
862396 | 862396 | 2020-12-25 | Pinellas | Florida | 12103 | 42176 | 1013 |
859151 | 859151 | 2020-12-24 | Pinellas | Florida | 12103 | 42176 | 1013 |
855906 | 855906 | 2020-12-23 | Pinellas | Florida | 12103 | 41654 | 1007 |
852661 | 852661 | 2020-12-22 | Pinellas | Florida | 12103 | 41280 | 1000 |
849416 | 849416 | 2020-12-21 | Pinellas | Florida | 12103 | 40987 | 999 |
846171 | 846171 | 2020-12-20 | Pinellas | Florida | 12103 | 40560 | 997 |
842925 | 842925 | 2020-12-19 | Pinellas | Florida | 12103 | 40299 | 996 |
839680 | 839680 | 2020-12-18 | Pinellas | Florida | 12103 | 39846 | 995 |
836435 | 836435 | 2020-12-17 | Pinellas | Florida | 12103 | 39337 | 990 |
833189 | 833189 | 2020-12-16 | Pinellas | Florida | 12103 | 38783 | 966 |
829942 | 829942 | 2020-12-15 | Pinellas | Florida | 12103 | 38457 | 957 |
826696 | 826696 | 2020-12-14 | Pinellas | Florida | 12103 | 38118 | 955 |
823449 | 823449 | 2020-12-13 | Pinellas | Florida | 12103 | 37753 | 951 |
820203 | 820203 | 2020-12-12 | Pinellas | Florida | 12103 | 37387 | 945 |
816957 | 816957 | 2020-12-11 | Pinellas | Florida | 12103 | 36962 | 943 |
813711 | 813711 | 2020-12-10 | Pinellas | Florida | 12103 | 36426 | 942 |
810467 | 810467 | 2020-12-09 | Pinellas | Florida | 12103 | 35883 | 941 |
807222 | 807222 | 2020-12-08 | Pinellas | Florida | 12103 | 35505 | 939 |
803977 | 803977 | 2020-12-07 | Pinellas | Florida | 12103 | 35202 | 930 |
800732 | 800732 | 2020-12-06 | Pinellas | Florida | 12103 | 34899 | 925 |
797487 | 797487 | 2020-12-05 | Pinellas | Florida | 12103 | 34603 | 924 |
794242 | 794242 | 2020-12-04 | Pinellas | Florida | 12103 | 34152 | 922 |
790997 | 790997 | 2020-12-03 | Pinellas | Florida | 12103 | 33857 | 915 |
787752 | 787752 | 2020-12-02 | Pinellas | Florida | 12103 | 33493 | 911 |
784508 | 784508 | 2020-12-01 | Pinellas | Florida | 12103 | 33246 | 911 |
781263 | 781263 | 2020-11-30 | Pinellas | Florida | 12103 | 33058 | 902 |
778017 | 778017 | 2020-11-29 | Pinellas | Florida | 12103 | 32808 | 899 |
774772 | 774772 | 2020-11-28 | Pinellas | Florida | 12103 | 32630 | 895 |
771527 | 771527 | 2020-11-27 | Pinellas | Florida | 12103 | 32408 | 885 |
768282 | 768282 | 2020-11-26 | Pinellas | Florida | 12103 | 31795 | 884 |
765036 | 765036 | 2020-11-25 | Pinellas | Florida | 12103 | 31795 | 884 |
761791 | 761791 | 2020-11-24 | Pinellas | Florida | 12103 | 31464 | 881 |
758546 | 758546 | 2020-11-23 | Pinellas | Florida | 12103 | 31137 | 872 |
755299 | 755299 | 2020-11-22 | Pinellas | Florida | 12103 | 30878 | 867 |
752053 | 752053 | 2020-11-21 | Pinellas | Florida | 12103 | 30611 | 867 |
748807 | 748807 | 2020-11-20 | Pinellas | Florida | 12103 | 30286 | 866 |
745561 | 745561 | 2020-11-19 | Pinellas | Florida | 12103 | 30006 | 866 |
742314 | 742314 | 2020-11-18 | Pinellas | Florida | 12103 | 29737 | 862 |
739067 | 739067 | 2020-11-17 | Pinellas | Florida | 12103 | 29509 | 859 |
735823 | 735823 | 2020-11-16 | Pinellas | Florida | 12103 | 29297 | 855 |
732577 | 732577 | 2020-11-15 | Pinellas | Florida | 12103 | 29106 | 854 |
729332 | 729332 | 2020-11-14 | Pinellas | Florida | 12103 | 28865 | 853 |
726089 | 726089 | 2020-11-13 | Pinellas | Florida | 12103 | 28746 | 850 |
722846 | 722846 | 2020-11-12 | Pinellas | Florida | 12103 | 28486 | 849 |
719603 | 719603 | 2020-11-11 | Pinellas | Florida | 12103 | 28242 | 838 |
716360 | 716360 | 2020-11-10 | Pinellas | Florida | 12103 | 28032 | 833 |
713116 | 713116 | 2020-11-09 | Pinellas | Florida | 12103 | 27849 | 831 |
709872 | 709872 | 2020-11-08 | Pinellas | Florida | 12103 | 27675 | 831 |
706628 | 706628 | 2020-11-07 | Pinellas | Florida | 12103 | 27372 | 831 |
703385 | 703385 | 2020-11-06 | Pinellas | Florida | 12103 | 27192 | 831 |
700142 | 700142 | 2020-11-05 | Pinellas | Florida | 12103 | 26884 | 830 |
696898 | 696898 | 2020-11-04 | Pinellas | Florida | 12103 | 26679 | 829 |
693656 | 693656 | 2020-11-03 | Pinellas | Florida | 12103 | 26477 | 828 |
690413 | 690413 | 2020-11-02 | Pinellas | Florida | 12103 | 26339 | 825 |
687168 | 687168 | 2020-11-01 | Pinellas | Florida | 12103 | 26214 | 823 |
683924 | 683924 | 2020-10-31 | Pinellas | Florida | 12103 | 25986 | 823 |
680681 | 680681 | 2020-10-30 | Pinellas | Florida | 12103 | 25921 | 821 |
677438 | 677438 | 2020-10-29 | Pinellas | Florida | 12103 | 25674 | 819 |
674195 | 674195 | 2020-10-28 | Pinellas | Florida | 12103 | 25534 | 818 |
670953 | 670953 | 2020-10-27 | Pinellas | Florida | 12103 | 25414 | 818 |
667710 | 667710 | 2020-10-26 | Pinellas | Florida | 12103 | 25244 | 816 |
664465 | 664465 | 2020-10-25 | Pinellas | Florida | 12103 | 25130 | 816 |
661221 | 661221 | 2020-10-24 | Pinellas | Florida | 12103 | 24986 | 816 |
657977 | 657977 | 2020-10-23 | Pinellas | Florida | 12103 | 24789 | 815 |
654732 | 654732 | 2020-10-22 | Pinellas | Florida | 12103 | 24650 | 812 |
651487 | 651487 | 2020-10-21 | Pinellas | Florida | 12103 | 24422 | 805 |
648243 | 648243 | 2020-10-20 | Pinellas | Florida | 12103 | 24327 | 803 |
644998 | 644998 | 2020-10-19 | Pinellas | Florida | 12103 | 24169 | 801 |
641750 | 641750 | 2020-10-18 | Pinellas | Florida | 12103 | 24099 | 800 |
638503 | 638503 | 2020-10-17 | Pinellas | Florida | 12103 | 23982 | 798 |
635258 | 635258 | 2020-10-16 | Pinellas | Florida | 12103 | 23746 | 793 |
632012 | 632012 | 2020-10-15 | Pinellas | Florida | 12103 | 23623 | 792 |
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);