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 |
---|---|---|---|---|---|---|---|
1193485 | 1193485 | 2021-04-06 | Santa Rosa | Florida | 12113 | 17830 | 278 |
1190235 | 1190235 | 2021-04-05 | Santa Rosa | Florida | 12113 | 17824 | 278 |
1186988 | 1186988 | 2021-04-04 | Santa Rosa | Florida | 12113 | 17809 | 278 |
1183741 | 1183741 | 2021-04-03 | Santa Rosa | Florida | 12113 | 17805 | 278 |
1180494 | 1180494 | 2021-04-02 | Santa Rosa | Florida | 12113 | 17781 | 278 |
1177247 | 1177247 | 2021-04-01 | Santa Rosa | Florida | 12113 | 17763 | 278 |
1174000 | 1174000 | 2021-03-31 | Santa Rosa | Florida | 12113 | 17744 | 278 |
1170753 | 1170753 | 2021-03-30 | Santa Rosa | Florida | 12113 | 17725 | 278 |
1167505 | 1167505 | 2021-03-29 | Santa Rosa | Florida | 12113 | 17709 | 278 |
1164257 | 1164257 | 2021-03-28 | Santa Rosa | Florida | 12113 | 17702 | 278 |
1161009 | 1161009 | 2021-03-27 | Santa Rosa | Florida | 12113 | 17693 | 278 |
1157761 | 1157761 | 2021-03-26 | Santa Rosa | Florida | 12113 | 17684 | 277 |
1154514 | 1154514 | 2021-03-25 | Santa Rosa | Florida | 12113 | 17673 | 276 |
1151267 | 1151267 | 2021-03-24 | Santa Rosa | Florida | 12113 | 17644 | 276 |
1148020 | 1148020 | 2021-03-23 | Santa Rosa | Florida | 12113 | 17616 | 276 |
1144773 | 1144773 | 2021-03-22 | Santa Rosa | Florida | 12113 | 17592 | 276 |
1141526 | 1141526 | 2021-03-21 | Santa Rosa | Florida | 12113 | 17579 | 276 |
1138280 | 1138280 | 2021-03-20 | Santa Rosa | Florida | 12113 | 17566 | 276 |
1135034 | 1135034 | 2021-03-19 | Santa Rosa | Florida | 12113 | 17551 | 276 |
1131787 | 1131787 | 2021-03-18 | Santa Rosa | Florida | 12113 | 17527 | 276 |
1128539 | 1128539 | 2021-03-17 | Santa Rosa | Florida | 12113 | 17508 | 276 |
1125293 | 1125293 | 2021-03-16 | Santa Rosa | Florida | 12113 | 17485 | 276 |
1122047 | 1122047 | 2021-03-15 | Santa Rosa | Florida | 12113 | 17460 | 276 |
1118800 | 1118800 | 2021-03-14 | Santa Rosa | Florida | 12113 | 17454 | 274 |
1115553 | 1115553 | 2021-03-13 | Santa Rosa | Florida | 12113 | 17435 | 274 |
1112307 | 1112307 | 2021-03-12 | Santa Rosa | Florida | 12113 | 17427 | 274 |
1109061 | 1109061 | 2021-03-11 | Santa Rosa | Florida | 12113 | 17396 | 274 |
1105815 | 1105815 | 2021-03-10 | Santa Rosa | Florida | 12113 | 17374 | 271 |
1102569 | 1102569 | 2021-03-09 | Santa Rosa | Florida | 12113 | 17342 | 270 |
1099323 | 1099323 | 2021-03-08 | Santa Rosa | Florida | 12113 | 17321 | 269 |
1096075 | 1096075 | 2021-03-07 | Santa Rosa | Florida | 12113 | 17314 | 267 |
1092829 | 1092829 | 2021-03-06 | Santa Rosa | Florida | 12113 | 17301 | 267 |
1089583 | 1089583 | 2021-03-05 | Santa Rosa | Florida | 12113 | 17276 | 267 |
1086338 | 1086338 | 2021-03-04 | Santa Rosa | Florida | 12113 | 17252 | 267 |
1083092 | 1083092 | 2021-03-03 | Santa Rosa | Florida | 12113 | 17220 | 262 |
1079846 | 1079846 | 2021-03-02 | Santa Rosa | Florida | 12113 | 17163 | 262 |
1076601 | 1076601 | 2021-03-01 | Santa Rosa | Florida | 12113 | 17118 | 262 |
1073355 | 1073355 | 2021-02-28 | Santa Rosa | Florida | 12113 | 17108 | 262 |
1070109 | 1070109 | 2021-02-27 | Santa Rosa | Florida | 12113 | 17058 | 262 |
1066864 | 1066864 | 2021-02-26 | Santa Rosa | Florida | 12113 | 17020 | 257 |
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 |
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);