ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
785 rows where county = "Hamblen" and state = "Tennessee" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
955448 | 955448 | 2021-01-22 | Hamblen | Tennessee | 47063 | 7172 | 117 |
952203 | 952203 | 2021-01-21 | Hamblen | Tennessee | 47063 | 7114 | 115 |
948958 | 948958 | 2021-01-20 | Hamblen | Tennessee | 47063 | 7088 | 112 |
945712 | 945712 | 2021-01-19 | Hamblen | Tennessee | 47063 | 7018 | 109 |
942465 | 942465 | 2021-01-18 | Hamblen | Tennessee | 47063 | 6990 | 109 |
939220 | 939220 | 2021-01-17 | Hamblen | Tennessee | 47063 | 6954 | 109 |
935975 | 935975 | 2021-01-16 | Hamblen | Tennessee | 47063 | 6910 | 109 |
932730 | 932730 | 2021-01-15 | Hamblen | Tennessee | 47063 | 6855 | 106 |
929485 | 929485 | 2021-01-14 | Hamblen | Tennessee | 47063 | 6779 | 106 |
926240 | 926240 | 2021-01-13 | Hamblen | Tennessee | 47063 | 6716 | 103 |
922994 | 922994 | 2021-01-12 | Hamblen | Tennessee | 47063 | 6660 | 102 |
919749 | 919749 | 2021-01-11 | Hamblen | Tennessee | 47063 | 6611 | 96 |
916504 | 916504 | 2021-01-10 | Hamblen | Tennessee | 47063 | 6576 | 96 |
913259 | 913259 | 2021-01-09 | Hamblen | Tennessee | 47063 | 6494 | 96 |
910014 | 910014 | 2021-01-08 | Hamblen | Tennessee | 47063 | 6441 | 95 |
906769 | 906769 | 2021-01-07 | Hamblen | Tennessee | 47063 | 6391 | 91 |
903523 | 903523 | 2021-01-06 | Hamblen | Tennessee | 47063 | 6289 | 91 |
900278 | 900278 | 2021-01-05 | Hamblen | Tennessee | 47063 | 6200 | 91 |
897033 | 897033 | 2021-01-04 | Hamblen | Tennessee | 47063 | 6142 | 90 |
893787 | 893787 | 2021-01-03 | Hamblen | Tennessee | 47063 | 6114 | 89 |
890541 | 890541 | 2021-01-02 | Hamblen | Tennessee | 47063 | 6044 | 89 |
887294 | 887294 | 2021-01-01 | Hamblen | Tennessee | 47063 | 5862 | 86 |
884049 | 884049 | 2020-12-31 | Hamblen | Tennessee | 47063 | 5862 | 86 |
880804 | 880804 | 2020-12-30 | Hamblen | Tennessee | 47063 | 5799 | 83 |
877559 | 877559 | 2020-12-29 | Hamblen | Tennessee | 47063 | 5718 | 80 |
874314 | 874314 | 2020-12-28 | Hamblen | Tennessee | 47063 | 5662 | 79 |
871069 | 871069 | 2020-12-27 | Hamblen | Tennessee | 47063 | 5617 | 78 |
867824 | 867824 | 2020-12-26 | Hamblen | Tennessee | 47063 | 5586 | 78 |
864579 | 864579 | 2020-12-25 | Hamblen | Tennessee | 47063 | 5536 | 77 |
861334 | 861334 | 2020-12-24 | Hamblen | Tennessee | 47063 | 5397 | 77 |
858089 | 858089 | 2020-12-23 | Hamblen | Tennessee | 47063 | 5360 | 75 |
854844 | 854844 | 2020-12-22 | Hamblen | Tennessee | 47063 | 5264 | 74 |
851599 | 851599 | 2020-12-21 | Hamblen | Tennessee | 47063 | 5268 | 72 |
848354 | 848354 | 2020-12-20 | Hamblen | Tennessee | 47063 | 5155 | 71 |
845109 | 845109 | 2020-12-19 | Hamblen | Tennessee | 47063 | 5063 | 71 |
841863 | 841863 | 2020-12-18 | Hamblen | Tennessee | 47063 | 4977 | 70 |
838618 | 838618 | 2020-12-17 | Hamblen | Tennessee | 47063 | 4873 | 70 |
835372 | 835372 | 2020-12-16 | Hamblen | Tennessee | 47063 | 4736 | 68 |
832126 | 832126 | 2020-12-15 | Hamblen | Tennessee | 47063 | 4652 | 68 |
828879 | 828879 | 2020-12-14 | Hamblen | Tennessee | 47063 | 4566 | 68 |
825633 | 825633 | 2020-12-13 | Hamblen | Tennessee | 47063 | 4457 | 67 |
822386 | 822386 | 2020-12-12 | Hamblen | Tennessee | 47063 | 4292 | 66 |
819140 | 819140 | 2020-12-11 | Hamblen | Tennessee | 47063 | 4244 | 65 |
815894 | 815894 | 2020-12-10 | Hamblen | Tennessee | 47063 | 4168 | 64 |
812648 | 812648 | 2020-12-09 | Hamblen | Tennessee | 47063 | 4118 | 64 |
809404 | 809404 | 2020-12-08 | Hamblen | Tennessee | 47063 | 3985 | 64 |
806159 | 806159 | 2020-12-07 | Hamblen | Tennessee | 47063 | 3961 | 63 |
802914 | 802914 | 2020-12-06 | Hamblen | Tennessee | 47063 | 3810 | 63 |
799669 | 799669 | 2020-12-05 | Hamblen | Tennessee | 47063 | 3788 | 63 |
796424 | 796424 | 2020-12-04 | Hamblen | Tennessee | 47063 | 3752 | 63 |
793179 | 793179 | 2020-12-03 | Hamblen | Tennessee | 47063 | 3724 | 62 |
789934 | 789934 | 2020-12-02 | Hamblen | Tennessee | 47063 | 3697 | 62 |
786689 | 786689 | 2020-12-01 | Hamblen | Tennessee | 47063 | 3679 | 61 |
783445 | 783445 | 2020-11-30 | Hamblen | Tennessee | 47063 | 3607 | 61 |
780200 | 780200 | 2020-11-29 | Hamblen | Tennessee | 47063 | 3501 | 61 |
776954 | 776954 | 2020-11-28 | Hamblen | Tennessee | 47063 | 3455 | 60 |
773709 | 773709 | 2020-11-27 | Hamblen | Tennessee | 47063 | 3408 | 60 |
770464 | 770464 | 2020-11-26 | Hamblen | Tennessee | 47063 | 3383 | 60 |
767218 | 767218 | 2020-11-25 | Hamblen | Tennessee | 47063 | 3360 | 59 |
763973 | 763973 | 2020-11-24 | Hamblen | Tennessee | 47063 | 3322 | 58 |
760728 | 760728 | 2020-11-23 | Hamblen | Tennessee | 47063 | 3315 | 57 |
757483 | 757483 | 2020-11-22 | Hamblen | Tennessee | 47063 | 3282 | 57 |
754236 | 754236 | 2020-11-21 | Hamblen | Tennessee | 47063 | 3214 | 57 |
750990 | 750990 | 2020-11-20 | Hamblen | Tennessee | 47063 | 3163 | 57 |
747744 | 747744 | 2020-11-19 | Hamblen | Tennessee | 47063 | 3131 | 57 |
744498 | 744498 | 2020-11-18 | Hamblen | Tennessee | 47063 | 3109 | 56 |
741251 | 741251 | 2020-11-17 | Hamblen | Tennessee | 47063 | 3084 | 56 |
738005 | 738005 | 2020-11-16 | Hamblen | Tennessee | 47063 | 3085 | 56 |
734761 | 734761 | 2020-11-15 | Hamblen | Tennessee | 47063 | 3034 | 56 |
731515 | 731515 | 2020-11-14 | Hamblen | Tennessee | 47063 | 2961 | 56 |
728271 | 728271 | 2020-11-13 | Hamblen | Tennessee | 47063 | 2917 | 56 |
725027 | 725027 | 2020-11-12 | Hamblen | Tennessee | 47063 | 2848 | 55 |
721784 | 721784 | 2020-11-11 | Hamblen | Tennessee | 47063 | 2816 | 55 |
718541 | 718541 | 2020-11-10 | Hamblen | Tennessee | 47063 | 2788 | 54 |
715298 | 715298 | 2020-11-09 | Hamblen | Tennessee | 47063 | 2783 | 51 |
712054 | 712054 | 2020-11-08 | Hamblen | Tennessee | 47063 | 2742 | 51 |
708810 | 708810 | 2020-11-07 | Hamblen | Tennessee | 47063 | 2707 | 51 |
705567 | 705567 | 2020-11-06 | Hamblen | Tennessee | 47063 | 2681 | 51 |
702324 | 702324 | 2020-11-05 | Hamblen | Tennessee | 47063 | 2648 | 51 |
699080 | 699080 | 2020-11-04 | Hamblen | Tennessee | 47063 | 2635 | 51 |
695837 | 695837 | 2020-11-03 | Hamblen | Tennessee | 47063 | 2620 | 50 |
692595 | 692595 | 2020-11-02 | Hamblen | Tennessee | 47063 | 2600 | 50 |
689351 | 689351 | 2020-11-01 | Hamblen | Tennessee | 47063 | 2584 | 50 |
686106 | 686106 | 2020-10-31 | Hamblen | Tennessee | 47063 | 2582 | 50 |
682863 | 682863 | 2020-10-30 | Hamblen | Tennessee | 47063 | 2569 | 50 |
679620 | 679620 | 2020-10-29 | Hamblen | Tennessee | 47063 | 2547 | 50 |
676377 | 676377 | 2020-10-28 | Hamblen | Tennessee | 47063 | 2525 | 50 |
673134 | 673134 | 2020-10-27 | Hamblen | Tennessee | 47063 | 2495 | 48 |
669892 | 669892 | 2020-10-26 | Hamblen | Tennessee | 47063 | 2475 | 48 |
666648 | 666648 | 2020-10-25 | Hamblen | Tennessee | 47063 | 2464 | 48 |
663403 | 663403 | 2020-10-24 | Hamblen | Tennessee | 47063 | 2445 | 48 |
660159 | 660159 | 2020-10-23 | Hamblen | Tennessee | 47063 | 2422 | 48 |
656915 | 656915 | 2020-10-22 | Hamblen | Tennessee | 47063 | 2379 | 43 |
653670 | 653670 | 2020-10-21 | Hamblen | Tennessee | 47063 | 2365 | 43 |
650425 | 650425 | 2020-10-20 | Hamblen | Tennessee | 47063 | 2338 | 43 |
647181 | 647181 | 2020-10-19 | Hamblen | Tennessee | 47063 | 2327 | 43 |
643935 | 643935 | 2020-10-18 | Hamblen | Tennessee | 47063 | 2316 | 43 |
640687 | 640687 | 2020-10-17 | Hamblen | Tennessee | 47063 | 2292 | 43 |
637441 | 637441 | 2020-10-16 | Hamblen | Tennessee | 47063 | 2281 | 43 |
634195 | 634195 | 2020-10-15 | Hamblen | Tennessee | 47063 | 2271 | 43 |
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);