ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
798 rows where fips = 12091 and state = "Florida" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1193476 | 1193476 | 2021-04-06 | Okaloosa | Florida | 12091 | 19833 | 353 |
1190226 | 1190226 | 2021-04-05 | Okaloosa | Florida | 12091 | 19815 | 353 |
1186979 | 1186979 | 2021-04-04 | Okaloosa | Florida | 12091 | 19808 | 353 |
1183732 | 1183732 | 2021-04-03 | Okaloosa | Florida | 12091 | 19798 | 353 |
1180485 | 1180485 | 2021-04-02 | Okaloosa | Florida | 12091 | 19785 | 353 |
1177238 | 1177238 | 2021-04-01 | Okaloosa | Florida | 12091 | 19770 | 351 |
1173991 | 1173991 | 2021-03-31 | Okaloosa | Florida | 12091 | 19748 | 351 |
1170744 | 1170744 | 2021-03-30 | Okaloosa | Florida | 12091 | 19733 | 351 |
1167496 | 1167496 | 2021-03-29 | Okaloosa | Florida | 12091 | 19721 | 351 |
1164248 | 1164248 | 2021-03-28 | Okaloosa | Florida | 12091 | 19718 | 351 |
1161000 | 1161000 | 2021-03-27 | Okaloosa | Florida | 12091 | 19703 | 348 |
1157752 | 1157752 | 2021-03-26 | Okaloosa | Florida | 12091 | 19681 | 348 |
1154505 | 1154505 | 2021-03-25 | Okaloosa | Florida | 12091 | 19666 | 347 |
1151258 | 1151258 | 2021-03-24 | Okaloosa | Florida | 12091 | 19642 | 344 |
1148011 | 1148011 | 2021-03-23 | Okaloosa | Florida | 12091 | 19622 | 344 |
1144764 | 1144764 | 2021-03-22 | Okaloosa | Florida | 12091 | 19600 | 344 |
1141517 | 1141517 | 2021-03-21 | Okaloosa | Florida | 12091 | 19598 | 344 |
1138271 | 1138271 | 2021-03-20 | Okaloosa | Florida | 12091 | 19587 | 343 |
1135025 | 1135025 | 2021-03-19 | Okaloosa | Florida | 12091 | 19574 | 343 |
1131778 | 1131778 | 2021-03-18 | Okaloosa | Florida | 12091 | 19544 | 342 |
1128530 | 1128530 | 2021-03-17 | Okaloosa | Florida | 12091 | 19506 | 342 |
1125284 | 1125284 | 2021-03-16 | Okaloosa | Florida | 12091 | 19478 | 342 |
1122038 | 1122038 | 2021-03-15 | Okaloosa | Florida | 12091 | 19467 | 342 |
1118791 | 1118791 | 2021-03-14 | Okaloosa | Florida | 12091 | 19451 | 341 |
1115544 | 1115544 | 2021-03-13 | Okaloosa | Florida | 12091 | 19426 | 339 |
1112298 | 1112298 | 2021-03-12 | Okaloosa | Florida | 12091 | 19398 | 339 |
1109052 | 1109052 | 2021-03-11 | Okaloosa | Florida | 12091 | 19369 | 337 |
1105806 | 1105806 | 2021-03-10 | Okaloosa | Florida | 12091 | 19340 | 336 |
1102560 | 1102560 | 2021-03-09 | Okaloosa | Florida | 12091 | 19315 | 334 |
1099314 | 1099314 | 2021-03-08 | Okaloosa | Florida | 12091 | 19247 | 334 |
1096066 | 1096066 | 2021-03-07 | Okaloosa | Florida | 12091 | 19237 | 333 |
1092820 | 1092820 | 2021-03-06 | Okaloosa | Florida | 12091 | 19212 | 333 |
1089574 | 1089574 | 2021-03-05 | Okaloosa | Florida | 12091 | 19173 | 331 |
1086329 | 1086329 | 2021-03-04 | Okaloosa | Florida | 12091 | 19124 | 328 |
1083083 | 1083083 | 2021-03-03 | Okaloosa | Florida | 12091 | 19089 | 328 |
1079837 | 1079837 | 2021-03-02 | Okaloosa | Florida | 12091 | 19007 | 327 |
1076592 | 1076592 | 2021-03-01 | Okaloosa | Florida | 12091 | 18899 | 327 |
1073346 | 1073346 | 2021-02-28 | Okaloosa | Florida | 12091 | 18870 | 327 |
1070100 | 1070100 | 2021-02-27 | Okaloosa | Florida | 12091 | 18810 | 327 |
1066855 | 1066855 | 2021-02-26 | Okaloosa | Florida | 12091 | 18724 | 327 |
1063610 | 1063610 | 2021-02-25 | Okaloosa | Florida | 12091 | 18661 | 327 |
1060365 | 1060365 | 2021-02-24 | Okaloosa | Florida | 12091 | 18512 | 322 |
1057119 | 1057119 | 2021-02-23 | Okaloosa | Florida | 12091 | 18466 | 321 |
1053873 | 1053873 | 2021-02-22 | Okaloosa | Florida | 12091 | 18403 | 321 |
1050626 | 1050626 | 2021-02-21 | Okaloosa | Florida | 12091 | 18380 | 321 |
1047379 | 1047379 | 2021-02-20 | Okaloosa | Florida | 12091 | 18322 | 319 |
1044134 | 1044134 | 2021-02-19 | Okaloosa | Florida | 12091 | 18211 | 319 |
1040889 | 1040889 | 2021-02-18 | Okaloosa | Florida | 12091 | 18154 | 312 |
1037644 | 1037644 | 2021-02-17 | Okaloosa | Florida | 12091 | 18062 | 312 |
1034399 | 1034399 | 2021-02-16 | Okaloosa | Florida | 12091 | 18023 | 311 |
1031153 | 1031153 | 2021-02-15 | Okaloosa | Florida | 12091 | 17982 | 311 |
1027906 | 1027906 | 2021-02-14 | Okaloosa | Florida | 12091 | 17926 | 311 |
1024661 | 1024661 | 2021-02-13 | Okaloosa | Florida | 12091 | 17878 | 308 |
1021416 | 1021416 | 2021-02-12 | Okaloosa | Florida | 12091 | 17822 | 307 |
1018171 | 1018171 | 2021-02-11 | Okaloosa | Florida | 12091 | 17756 | 301 |
1014926 | 1014926 | 2021-02-10 | Okaloosa | Florida | 12091 | 17665 | 301 |
1011681 | 1011681 | 2021-02-09 | Okaloosa | Florida | 12091 | 17586 | 299 |
1008435 | 1008435 | 2021-02-08 | Okaloosa | Florida | 12091 | 17526 | 299 |
1005189 | 1005189 | 2021-02-07 | Okaloosa | Florida | 12091 | 17485 | 298 |
1001943 | 1001943 | 2021-02-06 | Okaloosa | Florida | 12091 | 17447 | 296 |
998697 | 998697 | 2021-02-05 | Okaloosa | Florida | 12091 | 17363 | 296 |
995451 | 995451 | 2021-02-04 | Okaloosa | Florida | 12091 | 17189 | 292 |
992205 | 992205 | 2021-02-03 | Okaloosa | Florida | 12091 | 17049 | 288 |
988959 | 988959 | 2021-02-02 | Okaloosa | Florida | 12091 | 16885 | 286 |
985712 | 985712 | 2021-02-01 | Okaloosa | Florida | 12091 | 16729 | 286 |
982465 | 982465 | 2021-01-31 | Okaloosa | Florida | 12091 | 16706 | 286 |
979219 | 979219 | 2021-01-30 | Okaloosa | Florida | 12091 | 16638 | 285 |
975974 | 975974 | 2021-01-29 | Okaloosa | Florida | 12091 | 16514 | 284 |
972729 | 972729 | 2021-01-28 | Okaloosa | Florida | 12091 | 16401 | 283 |
969484 | 969484 | 2021-01-27 | Okaloosa | Florida | 12091 | 16234 | 277 |
966240 | 966240 | 2021-01-26 | Okaloosa | Florida | 12091 | 16134 | 277 |
962995 | 962995 | 2021-01-25 | Okaloosa | Florida | 12091 | 15987 | 277 |
959750 | 959750 | 2021-01-24 | Okaloosa | Florida | 12091 | 15931 | 276 |
956504 | 956504 | 2021-01-23 | Okaloosa | Florida | 12091 | 15826 | 276 |
953259 | 953259 | 2021-01-22 | Okaloosa | Florida | 12091 | 15728 | 270 |
950014 | 950014 | 2021-01-21 | Okaloosa | Florida | 12091 | 15548 | 264 |
946768 | 946768 | 2021-01-20 | Okaloosa | Florida | 12091 | 15450 | 264 |
943521 | 943521 | 2021-01-19 | Okaloosa | Florida | 12091 | 15281 | 263 |
940276 | 940276 | 2021-01-18 | Okaloosa | Florida | 12091 | 15226 | 263 |
937031 | 937031 | 2021-01-17 | Okaloosa | Florida | 12091 | 15165 | 263 |
933786 | 933786 | 2021-01-16 | Okaloosa | Florida | 12091 | 15106 | 257 |
930541 | 930541 | 2021-01-15 | Okaloosa | Florida | 12091 | 14996 | 258 |
927296 | 927296 | 2021-01-14 | Okaloosa | Florida | 12091 | 14811 | 254 |
924050 | 924050 | 2021-01-13 | Okaloosa | Florida | 12091 | 14641 | 251 |
920805 | 920805 | 2021-01-12 | Okaloosa | Florida | 12091 | 14506 | 248 |
917560 | 917560 | 2021-01-11 | Okaloosa | Florida | 12091 | 14312 | 248 |
914315 | 914315 | 2021-01-10 | Okaloosa | Florida | 12091 | 14232 | 248 |
911070 | 911070 | 2021-01-09 | Okaloosa | Florida | 12091 | 14130 | 248 |
907825 | 907825 | 2021-01-08 | Okaloosa | Florida | 12091 | 13951 | 244 |
904579 | 904579 | 2021-01-07 | Okaloosa | Florida | 12091 | 13755 | 240 |
901334 | 901334 | 2021-01-06 | Okaloosa | Florida | 12091 | 13570 | 238 |
898089 | 898089 | 2021-01-05 | Okaloosa | Florida | 12091 | 13370 | 232 |
894844 | 894844 | 2021-01-04 | Okaloosa | Florida | 12091 | 13267 | 232 |
891597 | 891597 | 2021-01-03 | Okaloosa | Florida | 12091 | 13211 | 232 |
888350 | 888350 | 2021-01-02 | Okaloosa | Florida | 12091 | 13125 | 232 |
885105 | 885105 | 2021-01-01 | Okaloosa | Florida | 12091 | 12856 | 231 |
881860 | 881860 | 2020-12-31 | Okaloosa | Florida | 12091 | 12856 | 231 |
878615 | 878615 | 2020-12-30 | Okaloosa | Florida | 12091 | 12662 | 226 |
875370 | 875370 | 2020-12-29 | Okaloosa | Florida | 12091 | 12479 | 224 |
872125 | 872125 | 2020-12-28 | Okaloosa | Florida | 12091 | 12406 | 224 |
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);