ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
800 rows where county = "Santa Rosa" and state = "Florida" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1063619 | 1063619 | 2021-02-25 | Santa Rosa | Florida | 12113 | 16972 | 256 |
1060374 | 1060374 | 2021-02-24 | Santa Rosa | Florida | 12113 | 16915 | 256 |
1057128 | 1057128 | 2021-02-23 | Santa Rosa | Florida | 12113 | 16860 | 252 |
1053882 | 1053882 | 2021-02-22 | Santa Rosa | Florida | 12113 | 16824 | 251 |
1050635 | 1050635 | 2021-02-21 | Santa Rosa | Florida | 12113 | 16801 | 251 |
1047388 | 1047388 | 2021-02-20 | Santa Rosa | Florida | 12113 | 16760 | 250 |
1044143 | 1044143 | 2021-02-19 | Santa Rosa | Florida | 12113 | 16696 | 250 |
1040898 | 1040898 | 2021-02-18 | Santa Rosa | Florida | 12113 | 16650 | 247 |
1037653 | 1037653 | 2021-02-17 | Santa Rosa | Florida | 12113 | 16616 | 246 |
1034408 | 1034408 | 2021-02-16 | Santa Rosa | Florida | 12113 | 16557 | 244 |
1031162 | 1031162 | 2021-02-15 | Santa Rosa | Florida | 12113 | 16516 | 243 |
1027915 | 1027915 | 2021-02-14 | Santa Rosa | Florida | 12113 | 16497 | 243 |
1024670 | 1024670 | 2021-02-13 | Santa Rosa | Florida | 12113 | 16442 | 241 |
1021425 | 1021425 | 2021-02-12 | Santa Rosa | Florida | 12113 | 16390 | 238 |
1018180 | 1018180 | 2021-02-11 | Santa Rosa | Florida | 12113 | 16308 | 237 |
1014935 | 1014935 | 2021-02-10 | Santa Rosa | Florida | 12113 | 16217 | 237 |
1011690 | 1011690 | 2021-02-09 | Santa Rosa | Florida | 12113 | 16152 | 234 |
1008444 | 1008444 | 2021-02-08 | Santa Rosa | Florida | 12113 | 16090 | 222 |
1005198 | 1005198 | 2021-02-07 | Santa Rosa | Florida | 12113 | 16050 | 222 |
1001952 | 1001952 | 2021-02-06 | Santa Rosa | Florida | 12113 | 15995 | 222 |
998706 | 998706 | 2021-02-05 | Santa Rosa | Florida | 12113 | 15917 | 222 |
995460 | 995460 | 2021-02-04 | Santa Rosa | Florida | 12113 | 15784 | 217 |
992214 | 992214 | 2021-02-03 | Santa Rosa | Florida | 12113 | 15700 | 217 |
988968 | 988968 | 2021-02-02 | Santa Rosa | Florida | 12113 | 15592 | 215 |
985721 | 985721 | 2021-02-01 | Santa Rosa | Florida | 12113 | 15513 | 215 |
982474 | 982474 | 2021-01-31 | Santa Rosa | Florida | 12113 | 15486 | 215 |
979228 | 979228 | 2021-01-30 | Santa Rosa | Florida | 12113 | 15391 | 211 |
975983 | 975983 | 2021-01-29 | Santa Rosa | Florida | 12113 | 15249 | 209 |
972738 | 972738 | 2021-01-28 | Santa Rosa | Florida | 12113 | 15178 | 209 |
969493 | 969493 | 2021-01-27 | Santa Rosa | Florida | 12113 | 15013 | 209 |
966249 | 966249 | 2021-01-26 | Santa Rosa | Florida | 12113 | 14893 | 206 |
963004 | 963004 | 2021-01-25 | Santa Rosa | Florida | 12113 | 14796 | 195 |
959759 | 959759 | 2021-01-24 | Santa Rosa | Florida | 12113 | 14711 | 195 |
956513 | 956513 | 2021-01-23 | Santa Rosa | Florida | 12113 | 14611 | 195 |
953268 | 953268 | 2021-01-22 | Santa Rosa | Florida | 12113 | 14421 | 199 |
950023 | 950023 | 2021-01-21 | Santa Rosa | Florida | 12113 | 14261 | 194 |
946777 | 946777 | 2021-01-20 | Santa Rosa | Florida | 12113 | 14093 | 189 |
943530 | 943530 | 2021-01-19 | Santa Rosa | Florida | 12113 | 13958 | 178 |
940285 | 940285 | 2021-01-18 | Santa Rosa | Florida | 12113 | 13853 | 177 |
937040 | 937040 | 2021-01-17 | Santa Rosa | Florida | 12113 | 13803 | 177 |
933795 | 933795 | 2021-01-16 | Santa Rosa | Florida | 12113 | 13698 | 177 |
930550 | 930550 | 2021-01-15 | Santa Rosa | Florida | 12113 | 13543 | 174 |
927305 | 927305 | 2021-01-14 | Santa Rosa | Florida | 12113 | 13337 | 169 |
924059 | 924059 | 2021-01-13 | Santa Rosa | Florida | 12113 | 13145 | 164 |
920814 | 920814 | 2021-01-12 | Santa Rosa | Florida | 12113 | 13026 | 157 |
917569 | 917569 | 2021-01-11 | Santa Rosa | Florida | 12113 | 12914 | 155 |
914324 | 914324 | 2021-01-10 | Santa Rosa | Florida | 12113 | 12843 | 155 |
911079 | 911079 | 2021-01-09 | Santa Rosa | Florida | 12113 | 12657 | 155 |
907834 | 907834 | 2021-01-08 | Santa Rosa | Florida | 12113 | 12524 | 148 |
904588 | 904588 | 2021-01-07 | Santa Rosa | Florida | 12113 | 12310 | 143 |
901343 | 901343 | 2021-01-06 | Santa Rosa | Florida | 12113 | 12088 | 142 |
898098 | 898098 | 2021-01-05 | Santa Rosa | Florida | 12113 | 11876 | 137 |
894853 | 894853 | 2021-01-04 | Santa Rosa | Florida | 12113 | 11772 | 130 |
891606 | 891606 | 2021-01-03 | Santa Rosa | Florida | 12113 | 11656 | 130 |
888359 | 888359 | 2021-01-02 | Santa Rosa | Florida | 12113 | 11492 | 130 |
885114 | 885114 | 2021-01-01 | Santa Rosa | Florida | 12113 | 11180 | 128 |
881869 | 881869 | 2020-12-31 | Santa Rosa | Florida | 12113 | 11180 | 128 |
878624 | 878624 | 2020-12-30 | Santa Rosa | Florida | 12113 | 10936 | 124 |
875379 | 875379 | 2020-12-29 | Santa Rosa | Florida | 12113 | 10687 | 123 |
872134 | 872134 | 2020-12-28 | Santa Rosa | Florida | 12113 | 10575 | 122 |
868889 | 868889 | 2020-12-27 | Santa Rosa | Florida | 12113 | 10486 | 121 |
865644 | 865644 | 2020-12-26 | Santa Rosa | Florida | 12113 | 10382 | 121 |
862399 | 862399 | 2020-12-25 | Santa Rosa | Florida | 12113 | 10195 | 120 |
859154 | 859154 | 2020-12-24 | Santa Rosa | Florida | 12113 | 10195 | 120 |
855909 | 855909 | 2020-12-23 | Santa Rosa | Florida | 12113 | 10025 | 120 |
852664 | 852664 | 2020-12-22 | Santa Rosa | Florida | 12113 | 9911 | 120 |
849419 | 849419 | 2020-12-21 | Santa Rosa | Florida | 12113 | 9781 | 117 |
846174 | 846174 | 2020-12-20 | Santa Rosa | Florida | 12113 | 9697 | 117 |
842928 | 842928 | 2020-12-19 | Santa Rosa | Florida | 12113 | 9602 | 115 |
839683 | 839683 | 2020-12-18 | Santa Rosa | Florida | 12113 | 9463 | 115 |
836438 | 836438 | 2020-12-17 | Santa Rosa | Florida | 12113 | 9270 | 114 |
833192 | 833192 | 2020-12-16 | Santa Rosa | Florida | 12113 | 9147 | 114 |
829945 | 829945 | 2020-12-15 | Santa Rosa | Florida | 12113 | 9001 | 113 |
826699 | 826699 | 2020-12-14 | Santa Rosa | Florida | 12113 | 8925 | 113 |
823452 | 823452 | 2020-12-13 | Santa Rosa | Florida | 12113 | 8852 | 112 |
820206 | 820206 | 2020-12-12 | Santa Rosa | Florida | 12113 | 8761 | 110 |
816960 | 816960 | 2020-12-11 | Santa Rosa | Florida | 12113 | 8619 | 110 |
813714 | 813714 | 2020-12-10 | Santa Rosa | Florida | 12113 | 8481 | 109 |
810470 | 810470 | 2020-12-09 | Santa Rosa | Florida | 12113 | 8298 | 105 |
807225 | 807225 | 2020-12-08 | Santa Rosa | Florida | 12113 | 8208 | 105 |
803980 | 803980 | 2020-12-07 | Santa Rosa | Florida | 12113 | 8143 | 104 |
800735 | 800735 | 2020-12-06 | Santa Rosa | Florida | 12113 | 8070 | 104 |
797490 | 797490 | 2020-12-05 | Santa Rosa | Florida | 12113 | 7995 | 104 |
794245 | 794245 | 2020-12-04 | Santa Rosa | Florida | 12113 | 7884 | 104 |
791000 | 791000 | 2020-12-03 | Santa Rosa | Florida | 12113 | 7769 | 103 |
787755 | 787755 | 2020-12-02 | Santa Rosa | Florida | 12113 | 7660 | 103 |
784511 | 784511 | 2020-12-01 | Santa Rosa | Florida | 12113 | 7550 | 102 |
781266 | 781266 | 2020-11-30 | Santa Rosa | Florida | 12113 | 7483 | 102 |
778020 | 778020 | 2020-11-29 | Santa Rosa | Florida | 12113 | 7451 | 102 |
774775 | 774775 | 2020-11-28 | Santa Rosa | Florida | 12113 | 7403 | 102 |
771530 | 771530 | 2020-11-27 | Santa Rosa | Florida | 12113 | 7355 | 102 |
768285 | 768285 | 2020-11-26 | Santa Rosa | Florida | 12113 | 7192 | 100 |
765039 | 765039 | 2020-11-25 | Santa Rosa | Florida | 12113 | 7192 | 100 |
761794 | 761794 | 2020-11-24 | Santa Rosa | Florida | 12113 | 7088 | 99 |
758549 | 758549 | 2020-11-23 | Santa Rosa | Florida | 12113 | 7051 | 97 |
755302 | 755302 | 2020-11-22 | Santa Rosa | Florida | 12113 | 7014 | 97 |
752056 | 752056 | 2020-11-21 | Santa Rosa | Florida | 12113 | 6961 | 97 |
748810 | 748810 | 2020-11-20 | Santa Rosa | Florida | 12113 | 6903 | 97 |
745564 | 745564 | 2020-11-19 | Santa Rosa | Florida | 12113 | 6839 | 96 |
742317 | 742317 | 2020-11-18 | Santa Rosa | Florida | 12113 | 6740 | 96 |
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);