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 |
---|---|---|---|---|---|---|---|
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 |
630924 | 630924 | 2020-10-14 | Bradley | Tennessee | 47011 | 3279 | 20 |
627680 | 627680 | 2020-10-13 | Bradley | Tennessee | 47011 | 3266 | 20 |
624438 | 624438 | 2020-10-12 | Bradley | Tennessee | 47011 | 3250 | 20 |
621195 | 621195 | 2020-10-11 | Bradley | Tennessee | 47011 | 3225 | 20 |
617952 | 617952 | 2020-10-10 | Bradley | Tennessee | 47011 | 3199 | 20 |
614710 | 614710 | 2020-10-09 | Bradley | Tennessee | 47011 | 3186 | 19 |
611469 | 611469 | 2020-10-08 | Bradley | Tennessee | 47011 | 3167 | 19 |
608227 | 608227 | 2020-10-07 | Bradley | Tennessee | 47011 | 3139 | 19 |
604984 | 604984 | 2020-10-06 | Bradley | Tennessee | 47011 | 3121 | 19 |
601742 | 601742 | 2020-10-05 | Bradley | Tennessee | 47011 | 3093 | 19 |
598499 | 598499 | 2020-10-04 | Bradley | Tennessee | 47011 | 3060 | 19 |
595256 | 595256 | 2020-10-03 | Bradley | Tennessee | 47011 | 3022 | 18 |
592015 | 592015 | 2020-10-02 | Bradley | Tennessee | 47011 | 3009 | 17 |
588774 | 588774 | 2020-10-01 | Bradley | Tennessee | 47011 | 2998 | 17 |
585534 | 585534 | 2020-09-30 | Bradley | Tennessee | 47011 | 2988 | 17 |
582294 | 582294 | 2020-09-29 | Bradley | Tennessee | 47011 | 2972 | 17 |
579054 | 579054 | 2020-09-28 | Bradley | Tennessee | 47011 | 2967 | 17 |
575813 | 575813 | 2020-09-27 | Bradley | Tennessee | 47011 | 2962 | 17 |
572569 | 572569 | 2020-09-26 | Bradley | Tennessee | 47011 | 2934 | 17 |
569327 | 569327 | 2020-09-25 | Bradley | Tennessee | 47011 | 2914 | 17 |
566086 | 566086 | 2020-09-24 | Bradley | Tennessee | 47011 | 2893 | 17 |
562845 | 562845 | 2020-09-23 | Bradley | Tennessee | 47011 | 2883 | 17 |
559608 | 559608 | 2020-09-22 | Bradley | Tennessee | 47011 | 2868 | 17 |
556371 | 556371 | 2020-09-21 | Bradley | Tennessee | 47011 | 2858 | 16 |
553134 | 553134 | 2020-09-20 | Bradley | Tennessee | 47011 | 2850 | 16 |
549895 | 549895 | 2020-09-19 | Bradley | Tennessee | 47011 | 2818 | 16 |
546656 | 546656 | 2020-09-18 | Bradley | Tennessee | 47011 | 2800 | 16 |
543419 | 543419 | 2020-09-17 | Bradley | Tennessee | 47011 | 2779 | 16 |
540183 | 540183 | 2020-09-16 | Bradley | Tennessee | 47011 | 2767 | 16 |
536946 | 536946 | 2020-09-15 | Bradley | Tennessee | 47011 | 2747 | 16 |
533710 | 533710 | 2020-09-14 | Bradley | Tennessee | 47011 | 2740 | 16 |
530475 | 530475 | 2020-09-13 | Bradley | Tennessee | 47011 | 2710 | 16 |
527238 | 527238 | 2020-09-12 | Bradley | Tennessee | 47011 | 2683 | 16 |
524002 | 524002 | 2020-09-11 | Bradley | Tennessee | 47011 | 2683 | 16 |
520766 | 520766 | 2020-09-10 | Bradley | Tennessee | 47011 | 2648 | 16 |
517530 | 517530 | 2020-09-09 | Bradley | Tennessee | 47011 | 2606 | 16 |
514295 | 514295 | 2020-09-08 | Bradley | Tennessee | 47011 | 2595 | 16 |
511062 | 511062 | 2020-09-07 | Bradley | Tennessee | 47011 | 2587 | 16 |
507829 | 507829 | 2020-09-06 | Bradley | Tennessee | 47011 | 2578 | 16 |
504597 | 504597 | 2020-09-05 | Bradley | Tennessee | 47011 | 2569 | 16 |
501363 | 501363 | 2020-09-04 | Bradley | Tennessee | 47011 | 2535 | 16 |
498129 | 498129 | 2020-09-03 | Bradley | Tennessee | 47011 | 2526 | 16 |
494896 | 494896 | 2020-09-02 | Bradley | Tennessee | 47011 | 2524 | 16 |
491662 | 491662 | 2020-09-01 | Bradley | Tennessee | 47011 | 2501 | 16 |
488429 | 488429 | 2020-08-31 | Bradley | Tennessee | 47011 | 2473 | 16 |
485196 | 485196 | 2020-08-30 | Bradley | Tennessee | 47011 | 2468 | 16 |
481961 | 481961 | 2020-08-29 | Bradley | Tennessee | 47011 | 2460 | 16 |
478727 | 478727 | 2020-08-28 | Bradley | Tennessee | 47011 | 2439 | 16 |
475494 | 475494 | 2020-08-27 | Bradley | Tennessee | 47011 | 2416 | 16 |
472261 | 472261 | 2020-08-26 | Bradley | Tennessee | 47011 | 2398 | 16 |
469029 | 469029 | 2020-08-25 | Bradley | Tennessee | 47011 | 2370 | 16 |
465800 | 465800 | 2020-08-24 | Bradley | Tennessee | 47011 | 2359 | 16 |
462571 | 462571 | 2020-08-23 | Bradley | Tennessee | 47011 | 2336 | 16 |
459343 | 459343 | 2020-08-22 | Bradley | Tennessee | 47011 | 2306 | 16 |
456115 | 456115 | 2020-08-21 | Bradley | Tennessee | 47011 | 2276 | 16 |
452887 | 452887 | 2020-08-20 | Bradley | Tennessee | 47011 | 2247 | 16 |
449659 | 449659 | 2020-08-19 | Bradley | Tennessee | 47011 | 2232 | 16 |
446431 | 446431 | 2020-08-18 | Bradley | Tennessee | 47011 | 2192 | 16 |
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);