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 |
---|---|---|---|---|---|---|---|
1063616 | 1063616 | 2021-02-25 | Pinellas | Florida | 12103 | 65937 | 1433 |
1060371 | 1060371 | 2021-02-24 | Pinellas | Florida | 12103 | 65623 | 1432 |
1057125 | 1057125 | 2021-02-23 | Pinellas | Florida | 12103 | 65375 | 1430 |
1053879 | 1053879 | 2021-02-22 | Pinellas | Florida | 12103 | 65191 | 1429 |
1050632 | 1050632 | 2021-02-21 | Pinellas | Florida | 12103 | 64951 | 1414 |
1047385 | 1047385 | 2021-02-20 | Pinellas | Florida | 12103 | 64785 | 1414 |
1044140 | 1044140 | 2021-02-19 | Pinellas | Florida | 12103 | 64466 | 1411 |
1040895 | 1040895 | 2021-02-18 | Pinellas | Florida | 12103 | 64099 | 1397 |
1037650 | 1037650 | 2021-02-17 | Pinellas | Florida | 12103 | 63871 | 1385 |
1034405 | 1034405 | 2021-02-16 | Pinellas | Florida | 12103 | 63568 | 1384 |
1031159 | 1031159 | 2021-02-15 | Pinellas | Florida | 12103 | 63326 | 1372 |
1027912 | 1027912 | 2021-02-14 | Pinellas | Florida | 12103 | 63171 | 1371 |
1024667 | 1024667 | 2021-02-13 | Pinellas | Florida | 12103 | 63023 | 1371 |
1021422 | 1021422 | 2021-02-12 | Pinellas | Florida | 12103 | 62788 | 1372 |
1018177 | 1018177 | 2021-02-11 | Pinellas | Florida | 12103 | 62499 | 1372 |
1014932 | 1014932 | 2021-02-10 | Pinellas | Florida | 12103 | 62132 | 1357 |
1011687 | 1011687 | 2021-02-09 | Pinellas | Florida | 12103 | 61950 | 1344 |
1008441 | 1008441 | 2021-02-08 | Pinellas | Florida | 12103 | 61730 | 1345 |
1005195 | 1005195 | 2021-02-07 | Pinellas | Florida | 12103 | 61546 | 1335 |
1001949 | 1001949 | 2021-02-06 | Pinellas | Florida | 12103 | 61344 | 1331 |
998703 | 998703 | 2021-02-05 | Pinellas | Florida | 12103 | 61001 | 1330 |
995457 | 995457 | 2021-02-04 | Pinellas | Florida | 12103 | 60623 | 1312 |
992211 | 992211 | 2021-02-03 | Pinellas | Florida | 12103 | 60322 | 1307 |
988965 | 988965 | 2021-02-02 | Pinellas | Florida | 12103 | 60130 | 1305 |
985718 | 985718 | 2021-02-01 | Pinellas | Florida | 12103 | 59716 | 1304 |
982471 | 982471 | 2021-01-31 | Pinellas | Florida | 12103 | 59475 | 1289 |
979225 | 979225 | 2021-01-30 | Pinellas | Florida | 12103 | 59207 | 1288 |
975980 | 975980 | 2021-01-29 | Pinellas | Florida | 12103 | 58591 | 1290 |
972735 | 972735 | 2021-01-28 | Pinellas | Florida | 12103 | 58125 | 1276 |
969490 | 969490 | 2021-01-27 | Pinellas | Florida | 12103 | 57774 | 1269 |
966246 | 966246 | 2021-01-26 | Pinellas | Florida | 12103 | 57493 | 1263 |
963001 | 963001 | 2021-01-25 | Pinellas | Florida | 12103 | 57197 | 1252 |
959756 | 959756 | 2021-01-24 | Pinellas | Florida | 12103 | 56935 | 1224 |
956510 | 956510 | 2021-01-23 | Pinellas | Florida | 12103 | 56564 | 1220 |
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 |
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);