ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
789 rows where fips = 12033 and state = "Florida" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1060335 | 1060335 | 2021-02-24 | Escambia | Florida | 12033 | 33391 | 618 |
1057089 | 1057089 | 2021-02-23 | Escambia | Florida | 12033 | 33304 | 620 |
1053843 | 1053843 | 2021-02-22 | Escambia | Florida | 12033 | 33242 | 608 |
1050596 | 1050596 | 2021-02-21 | Escambia | Florida | 12033 | 33210 | 608 |
1047349 | 1047349 | 2021-02-20 | Escambia | Florida | 12033 | 33158 | 608 |
1044104 | 1044104 | 2021-02-19 | Escambia | Florida | 12033 | 33047 | 607 |
1040859 | 1040859 | 2021-02-18 | Escambia | Florida | 12033 | 33007 | 604 |
1037614 | 1037614 | 2021-02-17 | Escambia | Florida | 12033 | 32958 | 598 |
1034369 | 1034369 | 2021-02-16 | Escambia | Florida | 12033 | 32890 | 598 |
1031123 | 1031123 | 2021-02-15 | Escambia | Florida | 12033 | 32788 | 594 |
1027876 | 1027876 | 2021-02-14 | Escambia | Florida | 12033 | 32743 | 593 |
1024631 | 1024631 | 2021-02-13 | Escambia | Florida | 12033 | 32681 | 593 |
1021386 | 1021386 | 2021-02-12 | Escambia | Florida | 12033 | 32590 | 585 |
1018141 | 1018141 | 2021-02-11 | Escambia | Florida | 12033 | 32484 | 582 |
1014896 | 1014896 | 2021-02-10 | Escambia | Florida | 12033 | 32332 | 580 |
1011651 | 1011651 | 2021-02-09 | Escambia | Florida | 12033 | 32208 | 569 |
1008405 | 1008405 | 2021-02-08 | Escambia | Florida | 12033 | 32101 | 563 |
1005159 | 1005159 | 2021-02-07 | Escambia | Florida | 12033 | 32016 | 563 |
1001913 | 1001913 | 2021-02-06 | Escambia | Florida | 12033 | 31919 | 562 |
998667 | 998667 | 2021-02-05 | Escambia | Florida | 12033 | 31794 | 550 |
995421 | 995421 | 2021-02-04 | Escambia | Florida | 12033 | 31579 | 541 |
992175 | 992175 | 2021-02-03 | Escambia | Florida | 12033 | 31410 | 538 |
988929 | 988929 | 2021-02-02 | Escambia | Florida | 12033 | 31195 | 536 |
985682 | 985682 | 2021-02-01 | Escambia | Florida | 12033 | 31029 | 528 |
982435 | 982435 | 2021-01-31 | Escambia | Florida | 12033 | 30942 | 528 |
979189 | 979189 | 2021-01-30 | Escambia | Florida | 12033 | 30783 | 528 |
975944 | 975944 | 2021-01-29 | Escambia | Florida | 12033 | 30381 | 518 |
972699 | 972699 | 2021-01-28 | Escambia | Florida | 12033 | 30195 | 513 |
969454 | 969454 | 2021-01-27 | Escambia | Florida | 12033 | 29903 | 506 |
966210 | 966210 | 2021-01-26 | Escambia | Florida | 12033 | 29597 | 501 |
962965 | 962965 | 2021-01-25 | Escambia | Florida | 12033 | 29363 | 488 |
959720 | 959720 | 2021-01-24 | Escambia | Florida | 12033 | 29228 | 488 |
956474 | 956474 | 2021-01-23 | Escambia | Florida | 12033 | 29045 | 487 |
953229 | 953229 | 2021-01-22 | Escambia | Florida | 12033 | 28757 | 484 |
949984 | 949984 | 2021-01-21 | Escambia | Florida | 12033 | 28431 | 472 |
946738 | 946738 | 2021-01-20 | Escambia | Florida | 12033 | 28035 | 469 |
943491 | 943491 | 2021-01-19 | Escambia | Florida | 12033 | 27733 | 448 |
940246 | 940246 | 2021-01-18 | Escambia | Florida | 12033 | 27606 | 448 |
937001 | 937001 | 2021-01-17 | Escambia | Florida | 12033 | 27455 | 448 |
933756 | 933756 | 2021-01-16 | Escambia | Florida | 12033 | 27242 | 448 |
930511 | 930511 | 2021-01-15 | Escambia | Florida | 12033 | 26968 | 440 |
927266 | 927266 | 2021-01-14 | Escambia | Florida | 12033 | 26577 | 435 |
924020 | 924020 | 2021-01-13 | Escambia | Florida | 12033 | 26212 | 432 |
920775 | 920775 | 2021-01-12 | Escambia | Florida | 12033 | 25913 | 426 |
917530 | 917530 | 2021-01-11 | Escambia | Florida | 12033 | 25570 | 414 |
914285 | 914285 | 2021-01-10 | Escambia | Florida | 12033 | 25393 | 413 |
911040 | 911040 | 2021-01-09 | Escambia | Florida | 12033 | 25153 | 413 |
907795 | 907795 | 2021-01-08 | Escambia | Florida | 12033 | 24868 | 405 |
904549 | 904549 | 2021-01-07 | Escambia | Florida | 12033 | 24530 | 400 |
901304 | 901304 | 2021-01-06 | Escambia | Florida | 12033 | 24062 | 393 |
898059 | 898059 | 2021-01-05 | Escambia | Florida | 12033 | 23602 | 387 |
894814 | 894814 | 2021-01-04 | Escambia | Florida | 12033 | 23378 | 384 |
891567 | 891567 | 2021-01-03 | Escambia | Florida | 12033 | 23206 | 383 |
888320 | 888320 | 2021-01-02 | Escambia | Florida | 12033 | 23014 | 379 |
885075 | 885075 | 2021-01-01 | Escambia | Florida | 12033 | 22349 | 373 |
881830 | 881830 | 2020-12-31 | Escambia | Florida | 12033 | 22349 | 373 |
878585 | 878585 | 2020-12-30 | Escambia | Florida | 12033 | 22008 | 372 |
875340 | 875340 | 2020-12-29 | Escambia | Florida | 12033 | 21643 | 367 |
872095 | 872095 | 2020-12-28 | Escambia | Florida | 12033 | 21507 | 360 |
868850 | 868850 | 2020-12-27 | Escambia | Florida | 12033 | 21408 | 359 |
865605 | 865605 | 2020-12-26 | Escambia | Florida | 12033 | 21268 | 356 |
862360 | 862360 | 2020-12-25 | Escambia | Florida | 12033 | 20946 | 353 |
859115 | 859115 | 2020-12-24 | Escambia | Florida | 12033 | 20946 | 353 |
855870 | 855870 | 2020-12-23 | Escambia | Florida | 12033 | 20737 | 352 |
852625 | 852625 | 2020-12-22 | Escambia | Florida | 12033 | 20438 | 351 |
849380 | 849380 | 2020-12-21 | Escambia | Florida | 12033 | 20278 | 346 |
846135 | 846135 | 2020-12-20 | Escambia | Florida | 12033 | 20162 | 343 |
842889 | 842889 | 2020-12-19 | Escambia | Florida | 12033 | 20027 | 341 |
839644 | 839644 | 2020-12-18 | Escambia | Florida | 12033 | 19762 | 341 |
836399 | 836399 | 2020-12-17 | Escambia | Florida | 12033 | 19475 | 338 |
833153 | 833153 | 2020-12-16 | Escambia | Florida | 12033 | 19256 | 337 |
829906 | 829906 | 2020-12-15 | Escambia | Florida | 12033 | 18998 | 336 |
826660 | 826660 | 2020-12-14 | Escambia | Florida | 12033 | 18869 | 332 |
823413 | 823413 | 2020-12-13 | Escambia | Florida | 12033 | 18761 | 332 |
820167 | 820167 | 2020-12-12 | Escambia | Florida | 12033 | 18616 | 332 |
816921 | 816921 | 2020-12-11 | Escambia | Florida | 12033 | 18427 | 328 |
813675 | 813675 | 2020-12-10 | Escambia | Florida | 12033 | 18238 | 328 |
810431 | 810431 | 2020-12-09 | Escambia | Florida | 12033 | 17965 | 327 |
807186 | 807186 | 2020-12-08 | Escambia | Florida | 12033 | 17793 | 324 |
803941 | 803941 | 2020-12-07 | Escambia | Florida | 12033 | 17702 | 318 |
800696 | 800696 | 2020-12-06 | Escambia | Florida | 12033 | 17617 | 316 |
797451 | 797451 | 2020-12-05 | Escambia | Florida | 12033 | 17514 | 315 |
794206 | 794206 | 2020-12-04 | Escambia | Florida | 12033 | 17335 | 313 |
790961 | 790961 | 2020-12-03 | Escambia | Florida | 12033 | 17177 | 310 |
787716 | 787716 | 2020-12-02 | Escambia | Florida | 12033 | 17007 | 307 |
784472 | 784472 | 2020-12-01 | Escambia | Florida | 12033 | 16872 | 306 |
781227 | 781227 | 2020-11-30 | Escambia | Florida | 12033 | 16729 | 305 |
777981 | 777981 | 2020-11-29 | Escambia | Florida | 12033 | 16675 | 304 |
774736 | 774736 | 2020-11-28 | Escambia | Florida | 12033 | 16578 | 304 |
771491 | 771491 | 2020-11-27 | Escambia | Florida | 12033 | 16470 | 301 |
768246 | 768246 | 2020-11-26 | Escambia | Florida | 12033 | 16223 | 299 |
765000 | 765000 | 2020-11-25 | Escambia | Florida | 12033 | 16223 | 299 |
761755 | 761755 | 2020-11-24 | Escambia | Florida | 12033 | 16101 | 297 |
758510 | 758510 | 2020-11-23 | Escambia | Florida | 12033 | 15990 | 296 |
755263 | 755263 | 2020-11-22 | Escambia | Florida | 12033 | 15926 | 296 |
752017 | 752017 | 2020-11-21 | Escambia | Florida | 12033 | 15873 | 296 |
748771 | 748771 | 2020-11-20 | Escambia | Florida | 12033 | 15732 | 297 |
745525 | 745525 | 2020-11-19 | Escambia | Florida | 12033 | 15584 | 293 |
742278 | 742278 | 2020-11-18 | Escambia | Florida | 12033 | 15436 | 290 |
739031 | 739031 | 2020-11-17 | Escambia | Florida | 12033 | 15298 | 289 |
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);