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 |
---|---|---|---|---|---|---|---|
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 |
544480 | 544480 | 2020-09-18 | Hillsborough | Florida | 12057 | 40349 | 604 |
541244 | 541244 | 2020-09-17 | Hillsborough | Florida | 12057 | 40126 | 601 |
538007 | 538007 | 2020-09-16 | Hillsborough | Florida | 12057 | 39888 | 596 |
534771 | 534771 | 2020-09-15 | Hillsborough | Florida | 12057 | 39751 | 591 |
531536 | 531536 | 2020-09-14 | Hillsborough | Florida | 12057 | 39600 | 585 |
528299 | 528299 | 2020-09-13 | Hillsborough | Florida | 12057 | 39450 | 586 |
525063 | 525063 | 2020-09-12 | Hillsborough | Florida | 12057 | 39298 | 585 |
521827 | 521827 | 2020-09-11 | Hillsborough | Florida | 12057 | 39138 | 584 |
518590 | 518590 | 2020-09-10 | Hillsborough | Florida | 12057 | 38917 | 579 |
515355 | 515355 | 2020-09-09 | Hillsborough | Florida | 12057 | 38790 | 568 |
512122 | 512122 | 2020-09-08 | Hillsborough | Florida | 12057 | 38652 | 565 |
508889 | 508889 | 2020-09-07 | Hillsborough | Florida | 12057 | 38545 | 562 |
505657 | 505657 | 2020-09-06 | Hillsborough | Florida | 12057 | 38426 | 562 |
502423 | 502423 | 2020-09-05 | Hillsborough | Florida | 12057 | 38262 | 559 |
499189 | 499189 | 2020-09-04 | Hillsborough | Florida | 12057 | 37981 | 558 |
495956 | 495956 | 2020-09-03 | Hillsborough | Florida | 12057 | 37821 | 558 |
492722 | 492722 | 2020-09-02 | Hillsborough | Florida | 12057 | 37668 | 554 |
489489 | 489489 | 2020-09-01 | Hillsborough | Florida | 12057 | 37458 | 551 |
486256 | 486256 | 2020-08-31 | Hillsborough | Florida | 12057 | 37136 | 551 |
483021 | 483021 | 2020-08-30 | Hillsborough | Florida | 12057 | 37013 | 547 |
479787 | 479787 | 2020-08-29 | Hillsborough | Florida | 12057 | 36784 | 545 |
476554 | 476554 | 2020-08-28 | Hillsborough | Florida | 12057 | 36574 | 541 |
473321 | 473321 | 2020-08-27 | Hillsborough | Florida | 12057 | 36354 | 540 |
470089 | 470089 | 2020-08-26 | Hillsborough | Florida | 12057 | 36157 | 537 |
466860 | 466860 | 2020-08-25 | Hillsborough | Florida | 12057 | 35953 | 534 |
463631 | 463631 | 2020-08-24 | Hillsborough | Florida | 12057 | 35814 | 530 |
460402 | 460402 | 2020-08-23 | Hillsborough | Florida | 12057 | 35721 | 520 |
457175 | 457175 | 2020-08-22 | Hillsborough | Florida | 12057 | 35574 | 519 |
453947 | 453947 | 2020-08-21 | Hillsborough | Florida | 12057 | 35293 | 519 |
450719 | 450719 | 2020-08-20 | Hillsborough | Florida | 12057 | 35061 | 512 |
447491 | 447491 | 2020-08-19 | Hillsborough | Florida | 12057 | 34851 | 508 |
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);