ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
785 rows where county = "Bradley" and state = "Tennessee" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
955422 | 955422 | 2021-01-22 | Bradley | Tennessee | 47011 | 11088 | 95 |
952177 | 952177 | 2021-01-21 | Bradley | Tennessee | 47011 | 10993 | 94 |
948932 | 948932 | 2021-01-20 | Bradley | Tennessee | 47011 | 10934 | 94 |
945686 | 945686 | 2021-01-19 | Bradley | Tennessee | 47011 | 10838 | 91 |
942439 | 942439 | 2021-01-18 | Bradley | Tennessee | 47011 | 10791 | 91 |
939194 | 939194 | 2021-01-17 | Bradley | Tennessee | 47011 | 10751 | 90 |
935949 | 935949 | 2021-01-16 | Bradley | Tennessee | 47011 | 10662 | 90 |
932704 | 932704 | 2021-01-15 | Bradley | Tennessee | 47011 | 10583 | 90 |
929459 | 929459 | 2021-01-14 | Bradley | Tennessee | 47011 | 10500 | 91 |
926214 | 926214 | 2021-01-13 | Bradley | Tennessee | 47011 | 10355 | 90 |
922968 | 922968 | 2021-01-12 | Bradley | Tennessee | 47011 | 10246 | 89 |
919723 | 919723 | 2021-01-11 | Bradley | Tennessee | 47011 | 10173 | 86 |
916478 | 916478 | 2021-01-10 | Bradley | Tennessee | 47011 | 10117 | 86 |
913233 | 913233 | 2021-01-09 | Bradley | Tennessee | 47011 | 10010 | 82 |
909988 | 909988 | 2021-01-08 | Bradley | Tennessee | 47011 | 9934 | 82 |
906743 | 906743 | 2021-01-07 | Bradley | Tennessee | 47011 | 9828 | 81 |
903497 | 903497 | 2021-01-06 | Bradley | Tennessee | 47011 | 9721 | 81 |
900252 | 900252 | 2021-01-05 | Bradley | Tennessee | 47011 | 9605 | 77 |
897007 | 897007 | 2021-01-04 | Bradley | Tennessee | 47011 | 9493 | 76 |
893761 | 893761 | 2021-01-03 | Bradley | Tennessee | 47011 | 9434 | 74 |
890515 | 890515 | 2021-01-02 | Bradley | Tennessee | 47011 | 9360 | 73 |
887268 | 887268 | 2021-01-01 | Bradley | Tennessee | 47011 | 9120 | 72 |
884023 | 884023 | 2020-12-31 | Bradley | Tennessee | 47011 | 9120 | 72 |
880778 | 880778 | 2020-12-30 | Bradley | Tennessee | 47011 | 8994 | 72 |
877533 | 877533 | 2020-12-29 | Bradley | Tennessee | 47011 | 8845 | 69 |
874288 | 874288 | 2020-12-28 | Bradley | Tennessee | 47011 | 8754 | 65 |
871043 | 871043 | 2020-12-27 | Bradley | Tennessee | 47011 | 8688 | 65 |
867798 | 867798 | 2020-12-26 | Bradley | Tennessee | 47011 | 8647 | 64 |
864553 | 864553 | 2020-12-25 | Bradley | Tennessee | 47011 | 8583 | 64 |
861308 | 861308 | 2020-12-24 | Bradley | Tennessee | 47011 | 8471 | 64 |
858063 | 858063 | 2020-12-23 | Bradley | Tennessee | 47011 | 8406 | 63 |
854818 | 854818 | 2020-12-22 | Bradley | Tennessee | 47011 | 8269 | 61 |
851573 | 851573 | 2020-12-21 | Bradley | Tennessee | 47011 | 8209 | 61 |
848328 | 848328 | 2020-12-20 | Bradley | Tennessee | 47011 | 8060 | 60 |
845083 | 845083 | 2020-12-19 | Bradley | Tennessee | 47011 | 7891 | 60 |
841837 | 841837 | 2020-12-18 | Bradley | Tennessee | 47011 | 7763 | 57 |
838592 | 838592 | 2020-12-17 | Bradley | Tennessee | 47011 | 7520 | 56 |
835346 | 835346 | 2020-12-16 | Bradley | Tennessee | 47011 | 7352 | 52 |
832100 | 832100 | 2020-12-15 | Bradley | Tennessee | 47011 | 7178 | 50 |
828853 | 828853 | 2020-12-14 | Bradley | Tennessee | 47011 | 7106 | 50 |
825607 | 825607 | 2020-12-13 | Bradley | Tennessee | 47011 | 6854 | 48 |
822360 | 822360 | 2020-12-12 | Bradley | Tennessee | 47011 | 6722 | 48 |
819114 | 819114 | 2020-12-11 | Bradley | Tennessee | 47011 | 6607 | 45 |
815868 | 815868 | 2020-12-10 | Bradley | Tennessee | 47011 | 6473 | 43 |
812622 | 812622 | 2020-12-09 | Bradley | Tennessee | 47011 | 6335 | 43 |
809378 | 809378 | 2020-12-08 | Bradley | Tennessee | 47011 | 6081 | 41 |
806133 | 806133 | 2020-12-07 | Bradley | Tennessee | 47011 | 5999 | 39 |
802888 | 802888 | 2020-12-06 | Bradley | Tennessee | 47011 | 5877 | 38 |
799643 | 799643 | 2020-12-05 | Bradley | Tennessee | 47011 | 5830 | 38 |
796398 | 796398 | 2020-12-04 | Bradley | Tennessee | 47011 | 5775 | 38 |
793153 | 793153 | 2020-12-03 | Bradley | Tennessee | 47011 | 5716 | 37 |
789908 | 789908 | 2020-12-02 | Bradley | Tennessee | 47011 | 5643 | 37 |
786663 | 786663 | 2020-12-01 | Bradley | Tennessee | 47011 | 5583 | 37 |
783419 | 783419 | 2020-11-30 | Bradley | Tennessee | 47011 | 5469 | 35 |
780174 | 780174 | 2020-11-29 | Bradley | Tennessee | 47011 | 5252 | 34 |
776928 | 776928 | 2020-11-28 | Bradley | Tennessee | 47011 | 5197 | 35 |
773683 | 773683 | 2020-11-27 | Bradley | Tennessee | 47011 | 5084 | 35 |
770438 | 770438 | 2020-11-26 | Bradley | Tennessee | 47011 | 5014 | 35 |
767192 | 767192 | 2020-11-25 | Bradley | Tennessee | 47011 | 4932 | 35 |
763947 | 763947 | 2020-11-24 | Bradley | Tennessee | 47011 | 4845 | 33 |
760702 | 760702 | 2020-11-23 | Bradley | Tennessee | 47011 | 4832 | 33 |
757457 | 757457 | 2020-11-22 | Bradley | Tennessee | 47011 | 4768 | 33 |
754210 | 754210 | 2020-11-21 | Bradley | Tennessee | 47011 | 4712 | 33 |
750964 | 750964 | 2020-11-20 | Bradley | Tennessee | 47011 | 4649 | 33 |
747718 | 747718 | 2020-11-19 | Bradley | Tennessee | 47011 | 4622 | 31 |
744472 | 744472 | 2020-11-18 | Bradley | Tennessee | 47011 | 4567 | 30 |
741225 | 741225 | 2020-11-17 | Bradley | Tennessee | 47011 | 4498 | 30 |
737979 | 737979 | 2020-11-16 | Bradley | Tennessee | 47011 | 4460 | 29 |
734735 | 734735 | 2020-11-15 | Bradley | Tennessee | 47011 | 4378 | 27 |
731489 | 731489 | 2020-11-14 | Bradley | Tennessee | 47011 | 4304 | 27 |
728245 | 728245 | 2020-11-13 | Bradley | Tennessee | 47011 | 4224 | 27 |
725001 | 725001 | 2020-11-12 | Bradley | Tennessee | 47011 | 4170 | 27 |
721758 | 721758 | 2020-11-11 | Bradley | Tennessee | 47011 | 4122 | 27 |
718515 | 718515 | 2020-11-10 | Bradley | Tennessee | 47011 | 4073 | 27 |
715272 | 715272 | 2020-11-09 | Bradley | Tennessee | 47011 | 4034 | 25 |
712028 | 712028 | 2020-11-08 | Bradley | Tennessee | 47011 | 3948 | 24 |
708784 | 708784 | 2020-11-07 | Bradley | Tennessee | 47011 | 3936 | 24 |
705541 | 705541 | 2020-11-06 | Bradley | Tennessee | 47011 | 3894 | 24 |
702298 | 702298 | 2020-11-05 | Bradley | Tennessee | 47011 | 3879 | 24 |
699054 | 699054 | 2020-11-04 | Bradley | Tennessee | 47011 | 3850 | 24 |
695811 | 695811 | 2020-11-03 | Bradley | Tennessee | 47011 | 3823 | 24 |
692569 | 692569 | 2020-11-02 | Bradley | Tennessee | 47011 | 3778 | 24 |
689325 | 689325 | 2020-11-01 | Bradley | Tennessee | 47011 | 3754 | 24 |
686080 | 686080 | 2020-10-31 | Bradley | Tennessee | 47011 | 3753 | 24 |
682837 | 682837 | 2020-10-30 | Bradley | Tennessee | 47011 | 3729 | 23 |
679594 | 679594 | 2020-10-29 | Bradley | Tennessee | 47011 | 3703 | 23 |
676351 | 676351 | 2020-10-28 | Bradley | Tennessee | 47011 | 3667 | 23 |
673108 | 673108 | 2020-10-27 | Bradley | Tennessee | 47011 | 3641 | 23 |
669866 | 669866 | 2020-10-26 | Bradley | Tennessee | 47011 | 3619 | 23 |
666622 | 666622 | 2020-10-25 | Bradley | Tennessee | 47011 | 3587 | 23 |
663377 | 663377 | 2020-10-24 | Bradley | Tennessee | 47011 | 3558 | 23 |
660133 | 660133 | 2020-10-23 | Bradley | Tennessee | 47011 | 3519 | 23 |
656889 | 656889 | 2020-10-22 | Bradley | Tennessee | 47011 | 3479 | 23 |
653644 | 653644 | 2020-10-21 | Bradley | Tennessee | 47011 | 3447 | 22 |
650399 | 650399 | 2020-10-20 | Bradley | Tennessee | 47011 | 3434 | 21 |
647155 | 647155 | 2020-10-19 | Bradley | Tennessee | 47011 | 3408 | 21 |
643909 | 643909 | 2020-10-18 | Bradley | Tennessee | 47011 | 3368 | 21 |
640661 | 640661 | 2020-10-17 | Bradley | Tennessee | 47011 | 3341 | 21 |
637415 | 637415 | 2020-10-16 | Bradley | Tennessee | 47011 | 3312 | 21 |
634169 | 634169 | 2020-10-15 | Bradley | Tennessee | 47011 | 3306 | 21 |
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);