ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
784 rows where county = "Cocke" and state = "Tennessee" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
955431 | 955431 | 2021-01-22 | Cocke | Tennessee | 47029 | 3527 | 58 |
952186 | 952186 | 2021-01-21 | Cocke | Tennessee | 47029 | 3502 | 57 |
948941 | 948941 | 2021-01-20 | Cocke | Tennessee | 47029 | 3486 | 57 |
945695 | 945695 | 2021-01-19 | Cocke | Tennessee | 47029 | 3456 | 56 |
942448 | 942448 | 2021-01-18 | Cocke | Tennessee | 47029 | 3438 | 56 |
939203 | 939203 | 2021-01-17 | Cocke | Tennessee | 47029 | 3428 | 56 |
935958 | 935958 | 2021-01-16 | Cocke | Tennessee | 47029 | 3412 | 56 |
932713 | 932713 | 2021-01-15 | Cocke | Tennessee | 47029 | 3389 | 56 |
929468 | 929468 | 2021-01-14 | Cocke | Tennessee | 47029 | 3366 | 55 |
926223 | 926223 | 2021-01-13 | Cocke | Tennessee | 47029 | 3336 | 55 |
922977 | 922977 | 2021-01-12 | Cocke | Tennessee | 47029 | 3312 | 55 |
919732 | 919732 | 2021-01-11 | Cocke | Tennessee | 47029 | 3285 | 54 |
916487 | 916487 | 2021-01-10 | Cocke | Tennessee | 47029 | 3270 | 52 |
913242 | 913242 | 2021-01-09 | Cocke | Tennessee | 47029 | 3214 | 52 |
909997 | 909997 | 2021-01-08 | Cocke | Tennessee | 47029 | 3188 | 52 |
906752 | 906752 | 2021-01-07 | Cocke | Tennessee | 47029 | 3137 | 51 |
903506 | 903506 | 2021-01-06 | Cocke | Tennessee | 47029 | 3112 | 51 |
900261 | 900261 | 2021-01-05 | Cocke | Tennessee | 47029 | 3059 | 50 |
897016 | 897016 | 2021-01-04 | Cocke | Tennessee | 47029 | 3028 | 47 |
893770 | 893770 | 2021-01-03 | Cocke | Tennessee | 47029 | 2995 | 47 |
890524 | 890524 | 2021-01-02 | Cocke | Tennessee | 47029 | 2968 | 45 |
887277 | 887277 | 2021-01-01 | Cocke | Tennessee | 47029 | 2841 | 44 |
884032 | 884032 | 2020-12-31 | Cocke | Tennessee | 47029 | 2841 | 44 |
880787 | 880787 | 2020-12-30 | Cocke | Tennessee | 47029 | 2814 | 40 |
877542 | 877542 | 2020-12-29 | Cocke | Tennessee | 47029 | 2762 | 39 |
874297 | 874297 | 2020-12-28 | Cocke | Tennessee | 47029 | 2739 | 39 |
871052 | 871052 | 2020-12-27 | Cocke | Tennessee | 47029 | 2704 | 39 |
867807 | 867807 | 2020-12-26 | Cocke | Tennessee | 47029 | 2674 | 39 |
864562 | 864562 | 2020-12-25 | Cocke | Tennessee | 47029 | 2645 | 39 |
861317 | 861317 | 2020-12-24 | Cocke | Tennessee | 47029 | 2596 | 39 |
858072 | 858072 | 2020-12-23 | Cocke | Tennessee | 47029 | 2587 | 39 |
854827 | 854827 | 2020-12-22 | Cocke | Tennessee | 47029 | 2514 | 39 |
851582 | 851582 | 2020-12-21 | Cocke | Tennessee | 47029 | 2488 | 37 |
848337 | 848337 | 2020-12-20 | Cocke | Tennessee | 47029 | 2433 | 37 |
845092 | 845092 | 2020-12-19 | Cocke | Tennessee | 47029 | 2386 | 35 |
841846 | 841846 | 2020-12-18 | Cocke | Tennessee | 47029 | 2330 | 35 |
838601 | 838601 | 2020-12-17 | Cocke | Tennessee | 47029 | 2276 | 34 |
835355 | 835355 | 2020-12-16 | Cocke | Tennessee | 47029 | 2228 | 33 |
832109 | 832109 | 2020-12-15 | Cocke | Tennessee | 47029 | 2139 | 33 |
828862 | 828862 | 2020-12-14 | Cocke | Tennessee | 47029 | 2098 | 32 |
825616 | 825616 | 2020-12-13 | Cocke | Tennessee | 47029 | 2052 | 32 |
822369 | 822369 | 2020-12-12 | Cocke | Tennessee | 47029 | 2001 | 32 |
819123 | 819123 | 2020-12-11 | Cocke | Tennessee | 47029 | 1971 | 31 |
815877 | 815877 | 2020-12-10 | Cocke | Tennessee | 47029 | 1924 | 30 |
812631 | 812631 | 2020-12-09 | Cocke | Tennessee | 47029 | 1896 | 30 |
809387 | 809387 | 2020-12-08 | Cocke | Tennessee | 47029 | 1835 | 30 |
806142 | 806142 | 2020-12-07 | Cocke | Tennessee | 47029 | 1815 | 30 |
802897 | 802897 | 2020-12-06 | Cocke | Tennessee | 47029 | 1770 | 30 |
799652 | 799652 | 2020-12-05 | Cocke | Tennessee | 47029 | 1756 | 30 |
796407 | 796407 | 2020-12-04 | Cocke | Tennessee | 47029 | 1744 | 30 |
793162 | 793162 | 2020-12-03 | Cocke | Tennessee | 47029 | 1720 | 30 |
789917 | 789917 | 2020-12-02 | Cocke | Tennessee | 47029 | 1692 | 30 |
786672 | 786672 | 2020-12-01 | Cocke | Tennessee | 47029 | 1683 | 30 |
783428 | 783428 | 2020-11-30 | Cocke | Tennessee | 47029 | 1653 | 30 |
780183 | 780183 | 2020-11-29 | Cocke | Tennessee | 47029 | 1623 | 30 |
776937 | 776937 | 2020-11-28 | Cocke | Tennessee | 47029 | 1606 | 30 |
773692 | 773692 | 2020-11-27 | Cocke | Tennessee | 47029 | 1595 | 30 |
770447 | 770447 | 2020-11-26 | Cocke | Tennessee | 47029 | 1583 | 30 |
767201 | 767201 | 2020-11-25 | Cocke | Tennessee | 47029 | 1561 | 30 |
763956 | 763956 | 2020-11-24 | Cocke | Tennessee | 47029 | 1555 | 28 |
760711 | 760711 | 2020-11-23 | Cocke | Tennessee | 47029 | 1549 | 28 |
757466 | 757466 | 2020-11-22 | Cocke | Tennessee | 47029 | 1539 | 28 |
754219 | 754219 | 2020-11-21 | Cocke | Tennessee | 47029 | 1512 | 26 |
750973 | 750973 | 2020-11-20 | Cocke | Tennessee | 47029 | 1497 | 26 |
747727 | 747727 | 2020-11-19 | Cocke | Tennessee | 47029 | 1488 | 26 |
744481 | 744481 | 2020-11-18 | Cocke | Tennessee | 47029 | 1488 | 26 |
741234 | 741234 | 2020-11-17 | Cocke | Tennessee | 47029 | 1470 | 26 |
737988 | 737988 | 2020-11-16 | Cocke | Tennessee | 47029 | 1466 | 26 |
734744 | 734744 | 2020-11-15 | Cocke | Tennessee | 47029 | 1424 | 26 |
731498 | 731498 | 2020-11-14 | Cocke | Tennessee | 47029 | 1405 | 26 |
728254 | 728254 | 2020-11-13 | Cocke | Tennessee | 47029 | 1374 | 26 |
725010 | 725010 | 2020-11-12 | Cocke | Tennessee | 47029 | 1354 | 24 |
721767 | 721767 | 2020-11-11 | Cocke | Tennessee | 47029 | 1340 | 24 |
718524 | 718524 | 2020-11-10 | Cocke | Tennessee | 47029 | 1321 | 22 |
715281 | 715281 | 2020-11-09 | Cocke | Tennessee | 47029 | 1303 | 22 |
712037 | 712037 | 2020-11-08 | Cocke | Tennessee | 47029 | 1292 | 22 |
708793 | 708793 | 2020-11-07 | Cocke | Tennessee | 47029 | 1273 | 21 |
705550 | 705550 | 2020-11-06 | Cocke | Tennessee | 47029 | 1251 | 20 |
702307 | 702307 | 2020-11-05 | Cocke | Tennessee | 47029 | 1246 | 20 |
699063 | 699063 | 2020-11-04 | Cocke | Tennessee | 47029 | 1232 | 20 |
695820 | 695820 | 2020-11-03 | Cocke | Tennessee | 47029 | 1209 | 18 |
692578 | 692578 | 2020-11-02 | Cocke | Tennessee | 47029 | 1201 | 17 |
689334 | 689334 | 2020-11-01 | Cocke | Tennessee | 47029 | 1178 | 17 |
686089 | 686089 | 2020-10-31 | Cocke | Tennessee | 47029 | 1173 | 17 |
682846 | 682846 | 2020-10-30 | Cocke | Tennessee | 47029 | 1167 | 16 |
679603 | 679603 | 2020-10-29 | Cocke | Tennessee | 47029 | 1150 | 14 |
676360 | 676360 | 2020-10-28 | Cocke | Tennessee | 47029 | 1123 | 14 |
673117 | 673117 | 2020-10-27 | Cocke | Tennessee | 47029 | 1097 | 14 |
669875 | 669875 | 2020-10-26 | Cocke | Tennessee | 47029 | 1080 | 14 |
666631 | 666631 | 2020-10-25 | Cocke | Tennessee | 47029 | 1058 | 14 |
663386 | 663386 | 2020-10-24 | Cocke | Tennessee | 47029 | 1035 | 14 |
660142 | 660142 | 2020-10-23 | Cocke | Tennessee | 47029 | 1014 | 12 |
656898 | 656898 | 2020-10-22 | Cocke | Tennessee | 47029 | 966 | 12 |
653653 | 653653 | 2020-10-21 | Cocke | Tennessee | 47029 | 952 | 12 |
650408 | 650408 | 2020-10-20 | Cocke | Tennessee | 47029 | 926 | 12 |
647164 | 647164 | 2020-10-19 | Cocke | Tennessee | 47029 | 922 | 12 |
643918 | 643918 | 2020-10-18 | Cocke | Tennessee | 47029 | 913 | 12 |
640670 | 640670 | 2020-10-17 | Cocke | Tennessee | 47029 | 895 | 12 |
637424 | 637424 | 2020-10-16 | Cocke | Tennessee | 47029 | 884 | 12 |
634178 | 634178 | 2020-10-15 | Cocke | Tennessee | 47029 | 878 | 12 |
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);