ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
804 rows where fips = 12057 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
868862 | 868862 | 2020-12-27 | Hillsborough | Florida | 12057 | 74368 | 1058 |
865617 | 865617 | 2020-12-26 | Hillsborough | Florida | 12057 | 73980 | 1058 |
862372 | 862372 | 2020-12-25 | Hillsborough | Florida | 12057 | 72860 | 1056 |
859127 | 859127 | 2020-12-24 | Hillsborough | Florida | 12057 | 72860 | 1056 |
855882 | 855882 | 2020-12-23 | Hillsborough | Florida | 12057 | 71957 | 1046 |
852637 | 852637 | 2020-12-22 | Hillsborough | Florida | 12057 | 71388 | 1038 |
849392 | 849392 | 2020-12-21 | Hillsborough | Florida | 12057 | 70849 | 1034 |
846147 | 846147 | 2020-12-20 | Hillsborough | Florida | 12057 | 70027 | 1026 |
842901 | 842901 | 2020-12-19 | Hillsborough | Florida | 12057 | 69530 | 1023 |
839656 | 839656 | 2020-12-18 | Hillsborough | Florida | 12057 | 68739 | 1021 |
836411 | 836411 | 2020-12-17 | Hillsborough | Florida | 12057 | 67801 | 1015 |
833165 | 833165 | 2020-12-16 | Hillsborough | Florida | 12057 | 67060 | 1011 |
829918 | 829918 | 2020-12-15 | Hillsborough | Florida | 12057 | 66548 | 996 |
826672 | 826672 | 2020-12-14 | Hillsborough | Florida | 12057 | 66041 | 999 |
823425 | 823425 | 2020-12-13 | Hillsborough | Florida | 12057 | 65502 | 986 |
820179 | 820179 | 2020-12-12 | Hillsborough | Florida | 12057 | 64999 | 985 |
816933 | 816933 | 2020-12-11 | Hillsborough | Florida | 12057 | 64281 | 984 |
813687 | 813687 | 2020-12-10 | Hillsborough | Florida | 12057 | 63339 | 977 |
810443 | 810443 | 2020-12-09 | Hillsborough | Florida | 12057 | 62439 | 972 |
807198 | 807198 | 2020-12-08 | Hillsborough | Florida | 12057 | 62149 | 969 |
803953 | 803953 | 2020-12-07 | Hillsborough | Florida | 12057 | 61599 | 967 |
800708 | 800708 | 2020-12-06 | Hillsborough | Florida | 12057 | 61276 | 960 |
797463 | 797463 | 2020-12-05 | Hillsborough | Florida | 12057 | 60761 | 959 |
794218 | 794218 | 2020-12-04 | Hillsborough | Florida | 12057 | 60241 | 955 |
790973 | 790973 | 2020-12-03 | Hillsborough | Florida | 12057 | 59809 | 947 |
787728 | 787728 | 2020-12-02 | Hillsborough | Florida | 12057 | 59270 | 938 |
784484 | 784484 | 2020-12-01 | Hillsborough | Florida | 12057 | 58749 | 933 |
781239 | 781239 | 2020-11-30 | Hillsborough | Florida | 12057 | 58293 | 932 |
777993 | 777993 | 2020-11-29 | Hillsborough | Florida | 12057 | 58092 | 929 |
774748 | 774748 | 2020-11-28 | Hillsborough | Florida | 12057 | 57728 | 923 |
771503 | 771503 | 2020-11-27 | Hillsborough | Florida | 12057 | 57371 | 920 |
768258 | 768258 | 2020-11-26 | Hillsborough | Florida | 12057 | 56497 | 904 |
765012 | 765012 | 2020-11-25 | Hillsborough | Florida | 12057 | 56497 | 904 |
761767 | 761767 | 2020-11-24 | Hillsborough | Florida | 12057 | 56166 | 892 |
758522 | 758522 | 2020-11-23 | Hillsborough | Florida | 12057 | 55835 | 897 |
755275 | 755275 | 2020-11-22 | Hillsborough | Florida | 12057 | 55482 | 885 |
752029 | 752029 | 2020-11-21 | Hillsborough | Florida | 12057 | 55257 | 884 |
748783 | 748783 | 2020-11-20 | Hillsborough | Florida | 12057 | 54792 | 885 |
745537 | 745537 | 2020-11-19 | Hillsborough | Florida | 12057 | 54326 | 883 |
742290 | 742290 | 2020-11-18 | Hillsborough | Florida | 12057 | 53900 | 877 |
739043 | 739043 | 2020-11-17 | Hillsborough | Florida | 12057 | 53432 | 866 |
735799 | 735799 | 2020-11-16 | Hillsborough | Florida | 12057 | 53187 | 866 |
732553 | 732553 | 2020-11-15 | Hillsborough | Florida | 12057 | 52907 | 857 |
729308 | 729308 | 2020-11-14 | Hillsborough | Florida | 12057 | 52481 | 857 |
726065 | 726065 | 2020-11-13 | Hillsborough | Florida | 12057 | 52330 | 857 |
722822 | 722822 | 2020-11-12 | Hillsborough | Florida | 12057 | 52014 | 855 |
719579 | 719579 | 2020-11-11 | Hillsborough | Florida | 12057 | 51635 | 851 |
716336 | 716336 | 2020-11-10 | Hillsborough | Florida | 12057 | 51296 | 847 |
713092 | 713092 | 2020-11-09 | Hillsborough | Florida | 12057 | 51055 | 847 |
709848 | 709848 | 2020-11-08 | Hillsborough | Florida | 12057 | 50790 | 842 |
706604 | 706604 | 2020-11-07 | Hillsborough | Florida | 12057 | 50380 | 836 |
703361 | 703361 | 2020-11-06 | Hillsborough | Florida | 12057 | 50127 | 830 |
700118 | 700118 | 2020-11-05 | Hillsborough | Florida | 12057 | 49794 | 828 |
696874 | 696874 | 2020-11-04 | Hillsborough | Florida | 12057 | 49376 | 827 |
693632 | 693632 | 2020-11-03 | Hillsborough | Florida | 12057 | 49150 | 822 |
690389 | 690389 | 2020-11-02 | Hillsborough | Florida | 12057 | 48925 | 822 |
687144 | 687144 | 2020-11-01 | Hillsborough | Florida | 12057 | 48669 | 816 |
683900 | 683900 | 2020-10-31 | Hillsborough | Florida | 12057 | 48287 | 816 |
680657 | 680657 | 2020-10-30 | Hillsborough | Florida | 12057 | 48148 | 820 |
677414 | 677414 | 2020-10-29 | Hillsborough | Florida | 12057 | 47800 | 798 |
674171 | 674171 | 2020-10-28 | Hillsborough | Florida | 12057 | 47596 | 782 |
670929 | 670929 | 2020-10-27 | Hillsborough | Florida | 12057 | 47371 | 762 |
667686 | 667686 | 2020-10-26 | Hillsborough | Florida | 12057 | 47080 | 759 |
664441 | 664441 | 2020-10-25 | Hillsborough | Florida | 12057 | 46907 | 759 |
661197 | 661197 | 2020-10-24 | Hillsborough | Florida | 12057 | 46790 | 759 |
657953 | 657953 | 2020-10-23 | Hillsborough | Florida | 12057 | 46518 | 757 |
654708 | 654708 | 2020-10-22 | Hillsborough | Florida | 12057 | 46300 | 755 |
651463 | 651463 | 2020-10-21 | Hillsborough | Florida | 12057 | 45948 | 755 |
648219 | 648219 | 2020-10-20 | Hillsborough | Florida | 12057 | 45798 | 754 |
644974 | 644974 | 2020-10-19 | Hillsborough | Florida | 12057 | 45538 | 751 |
641726 | 641726 | 2020-10-18 | Hillsborough | Florida | 12057 | 45455 | 750 |
638479 | 638479 | 2020-10-17 | Hillsborough | Florida | 12057 | 45275 | 745 |
635234 | 635234 | 2020-10-16 | Hillsborough | Florida | 12057 | 44999 | 738 |
631988 | 631988 | 2020-10-15 | Hillsborough | Florida | 12057 | 44811 | 734 |
628744 | 628744 | 2020-10-14 | Hillsborough | Florida | 12057 | 44652 | 720 |
625501 | 625501 | 2020-10-13 | Hillsborough | Florida | 12057 | 44460 | 719 |
622258 | 622258 | 2020-10-12 | Hillsborough | Florida | 12057 | 44256 | 709 |
619015 | 619015 | 2020-10-11 | Hillsborough | Florida | 12057 | 44138 | 706 |
615773 | 615773 | 2020-10-10 | Hillsborough | Florida | 12057 | 43808 | 691 |
612532 | 612532 | 2020-10-09 | Hillsborough | Florida | 12057 | 43808 | 691 |
609290 | 609290 | 2020-10-08 | Hillsborough | Florida | 12057 | 43578 | 685 |
606047 | 606047 | 2020-10-07 | Hillsborough | Florida | 12057 | 43304 | 675 |
602805 | 602805 | 2020-10-06 | Hillsborough | Florida | 12057 | 43166 | 669 |
599562 | 599562 | 2020-10-05 | Hillsborough | Florida | 12057 | 43027 | 673 |
596319 | 596319 | 2020-10-04 | Hillsborough | Florida | 12057 | 42891 | 671 |
593077 | 593077 | 2020-10-03 | Hillsborough | Florida | 12057 | 42765 | 668 |
589837 | 589837 | 2020-10-02 | Hillsborough | Florida | 12057 | 42565 | 660 |
586596 | 586596 | 2020-10-01 | Hillsborough | Florida | 12057 | 42380 | 654 |
583356 | 583356 | 2020-09-30 | Hillsborough | Florida | 12057 | 42248 | 646 |
580117 | 580117 | 2020-09-29 | Hillsborough | Florida | 12057 | 42118 | 636 |
576876 | 576876 | 2020-09-28 | Hillsborough | Florida | 12057 | 41947 | 628 |
573633 | 573633 | 2020-09-27 | Hillsborough | Florida | 12057 | 41826 | 628 |
570391 | 570391 | 2020-09-26 | Hillsborough | Florida | 12057 | 41722 | 628 |
567149 | 567149 | 2020-09-25 | Hillsborough | Florida | 12057 | 41506 | 625 |
563909 | 563909 | 2020-09-24 | Hillsborough | Florida | 12057 | 41351 | 620 |
560669 | 560669 | 2020-09-23 | Hillsborough | Florida | 12057 | 41178 | 614 |
557433 | 557433 | 2020-09-22 | Hillsborough | Florida | 12057 | 41016 | 605 |
554196 | 554196 | 2020-09-21 | Hillsborough | Florida | 12057 | 40898 | 604 |
550957 | 550957 | 2020-09-20 | Hillsborough | Florida | 12057 | 40751 | 604 |
547718 | 547718 | 2020-09-19 | Hillsborough | Florida | 12057 | 40587 | 604 |
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);