ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
785 rows where county = "Davidson" and state = "North Carolina" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
922369 | 922369 | 2021-01-12 | Davidson | North Carolina | 37057 | 10590 | 98 |
919124 | 919124 | 2021-01-11 | Davidson | North Carolina | 37057 | 10446 | 96 |
915879 | 915879 | 2021-01-10 | Davidson | North Carolina | 37057 | 10337 | 96 |
912634 | 912634 | 2021-01-09 | Davidson | North Carolina | 37057 | 10187 | 88 |
909389 | 909389 | 2021-01-08 | Davidson | North Carolina | 37057 | 9931 | 88 |
906144 | 906144 | 2021-01-07 | Davidson | North Carolina | 37057 | 9749 | 87 |
902898 | 902898 | 2021-01-06 | Davidson | North Carolina | 37057 | 9551 | 86 |
899653 | 899653 | 2021-01-05 | Davidson | North Carolina | 37057 | 9425 | 86 |
896408 | 896408 | 2021-01-04 | Davidson | North Carolina | 37057 | 9322 | 86 |
893162 | 893162 | 2021-01-03 | Davidson | North Carolina | 37057 | 9200 | 86 |
889916 | 889916 | 2021-01-02 | Davidson | North Carolina | 37057 | 9077 | 86 |
886669 | 886669 | 2021-01-01 | Davidson | North Carolina | 37057 | 8700 | 85 |
883424 | 883424 | 2020-12-31 | Davidson | North Carolina | 37057 | 8700 | 85 |
880179 | 880179 | 2020-12-30 | Davidson | North Carolina | 37057 | 8567 | 85 |
876934 | 876934 | 2020-12-29 | Davidson | North Carolina | 37057 | 8416 | 77 |
873689 | 873689 | 2020-12-28 | Davidson | North Carolina | 37057 | 8361 | 77 |
870444 | 870444 | 2020-12-27 | Davidson | North Carolina | 37057 | 8264 | 77 |
867199 | 867199 | 2020-12-26 | Davidson | North Carolina | 37057 | 8193 | 77 |
863954 | 863954 | 2020-12-25 | Davidson | North Carolina | 37057 | 7780 | 77 |
860709 | 860709 | 2020-12-24 | Davidson | North Carolina | 37057 | 7780 | 77 |
857464 | 857464 | 2020-12-23 | Davidson | North Carolina | 37057 | 7780 | 77 |
854219 | 854219 | 2020-12-22 | Davidson | North Carolina | 37057 | 7677 | 74 |
850974 | 850974 | 2020-12-21 | Davidson | North Carolina | 37057 | 7564 | 72 |
847729 | 847729 | 2020-12-20 | Davidson | North Carolina | 37057 | 7490 | 72 |
844484 | 844484 | 2020-12-19 | Davidson | North Carolina | 37057 | 7386 | 71 |
841238 | 841238 | 2020-12-18 | Davidson | North Carolina | 37057 | 7182 | 67 |
837993 | 837993 | 2020-12-17 | Davidson | North Carolina | 37057 | 7045 | 66 |
834747 | 834747 | 2020-12-16 | Davidson | North Carolina | 37057 | 6896 | 61 |
831501 | 831501 | 2020-12-15 | Davidson | North Carolina | 37057 | 6819 | 61 |
828254 | 828254 | 2020-12-14 | Davidson | North Carolina | 37057 | 6730 | 58 |
825008 | 825008 | 2020-12-13 | Davidson | North Carolina | 37057 | 6622 | 58 |
821761 | 821761 | 2020-12-12 | Davidson | North Carolina | 37057 | 6525 | 58 |
818515 | 818515 | 2020-12-11 | Davidson | North Carolina | 37057 | 6395 | 58 |
815269 | 815269 | 2020-12-10 | Davidson | North Carolina | 37057 | 6260 | 58 |
812024 | 812024 | 2020-12-09 | Davidson | North Carolina | 37057 | 6164 | 58 |
808779 | 808779 | 2020-12-08 | Davidson | North Carolina | 37057 | 6056 | 56 |
805534 | 805534 | 2020-12-07 | Davidson | North Carolina | 37057 | 5990 | 56 |
802289 | 802289 | 2020-12-06 | Davidson | North Carolina | 37057 | 5895 | 56 |
799044 | 799044 | 2020-12-05 | Davidson | North Carolina | 37057 | 5773 | 55 |
795799 | 795799 | 2020-12-04 | Davidson | North Carolina | 37057 | 5681 | 55 |
792554 | 792554 | 2020-12-03 | Davidson | North Carolina | 37057 | 5553 | 55 |
789309 | 789309 | 2020-12-02 | Davidson | North Carolina | 37057 | 5468 | 53 |
786064 | 786064 | 2020-12-01 | Davidson | North Carolina | 37057 | 5426 | 51 |
782820 | 782820 | 2020-11-30 | Davidson | North Carolina | 37057 | 5378 | 51 |
779574 | 779574 | 2020-11-29 | Davidson | North Carolina | 37057 | 5328 | 51 |
776329 | 776329 | 2020-11-28 | Davidson | North Carolina | 37057 | 5238 | 51 |
773084 | 773084 | 2020-11-27 | Davidson | North Carolina | 37057 | 5214 | 51 |
769839 | 769839 | 2020-11-26 | Davidson | North Carolina | 37057 | 5058 | 51 |
766593 | 766593 | 2020-11-25 | Davidson | North Carolina | 37057 | 5058 | 51 |
763348 | 763348 | 2020-11-24 | Davidson | North Carolina | 37057 | 4974 | 51 |
760103 | 760103 | 2020-11-23 | Davidson | North Carolina | 37057 | 4920 | 49 |
756857 | 756857 | 2020-11-22 | Davidson | North Carolina | 37057 | 4888 | 49 |
753610 | 753610 | 2020-11-21 | Davidson | North Carolina | 37057 | 4794 | 49 |
750364 | 750364 | 2020-11-20 | Davidson | North Carolina | 37057 | 4730 | 48 |
747118 | 747118 | 2020-11-19 | Davidson | North Carolina | 37057 | 4663 | 48 |
743872 | 743872 | 2020-11-18 | Davidson | North Carolina | 37057 | 4593 | 48 |
740625 | 740625 | 2020-11-17 | Davidson | North Carolina | 37057 | 4528 | 48 |
737380 | 737380 | 2020-11-16 | Davidson | North Carolina | 37057 | 4467 | 48 |
734136 | 734136 | 2020-11-15 | Davidson | North Carolina | 37057 | 4423 | 48 |
730890 | 730890 | 2020-11-14 | Davidson | North Carolina | 37057 | 4390 | 48 |
727646 | 727646 | 2020-11-13 | Davidson | North Carolina | 37057 | 4325 | 48 |
724402 | 724402 | 2020-11-12 | Davidson | North Carolina | 37057 | 4299 | 48 |
721159 | 721159 | 2020-11-11 | Davidson | North Carolina | 37057 | 4246 | 48 |
717916 | 717916 | 2020-11-10 | Davidson | North Carolina | 37057 | 4203 | 48 |
714673 | 714673 | 2020-11-09 | Davidson | North Carolina | 37057 | 4170 | 48 |
711429 | 711429 | 2020-11-08 | Davidson | North Carolina | 37057 | 4141 | 47 |
708185 | 708185 | 2020-11-07 | Davidson | North Carolina | 37057 | 4100 | 47 |
704942 | 704942 | 2020-11-06 | Davidson | North Carolina | 37057 | 4053 | 47 |
701699 | 701699 | 2020-11-05 | Davidson | North Carolina | 37057 | 3991 | 46 |
698455 | 698455 | 2020-11-04 | Davidson | North Carolina | 37057 | 3935 | 46 |
695212 | 695212 | 2020-11-03 | Davidson | North Carolina | 37057 | 3910 | 44 |
691970 | 691970 | 2020-11-02 | Davidson | North Carolina | 37057 | 3884 | 44 |
688726 | 688726 | 2020-11-01 | Davidson | North Carolina | 37057 | 3874 | 44 |
685481 | 685481 | 2020-10-31 | Davidson | North Carolina | 37057 | 3836 | 44 |
682238 | 682238 | 2020-10-30 | Davidson | North Carolina | 37057 | 3793 | 44 |
678995 | 678995 | 2020-10-29 | Davidson | North Carolina | 37057 | 3765 | 43 |
675752 | 675752 | 2020-10-28 | Davidson | North Carolina | 37057 | 3717 | 43 |
672509 | 672509 | 2020-10-27 | Davidson | North Carolina | 37057 | 3677 | 43 |
669267 | 669267 | 2020-10-26 | Davidson | North Carolina | 37057 | 3660 | 43 |
666023 | 666023 | 2020-10-25 | Davidson | North Carolina | 37057 | 3623 | 43 |
662778 | 662778 | 2020-10-24 | Davidson | North Carolina | 37057 | 3601 | 43 |
659534 | 659534 | 2020-10-23 | Davidson | North Carolina | 37057 | 3559 | 43 |
656290 | 656290 | 2020-10-22 | Davidson | North Carolina | 37057 | 3539 | 43 |
653045 | 653045 | 2020-10-21 | Davidson | North Carolina | 37057 | 3509 | 43 |
649800 | 649800 | 2020-10-20 | Davidson | North Carolina | 37057 | 3484 | 42 |
646556 | 646556 | 2020-10-19 | Davidson | North Carolina | 37057 | 3464 | 42 |
643310 | 643310 | 2020-10-18 | Davidson | North Carolina | 37057 | 3445 | 42 |
640062 | 640062 | 2020-10-17 | Davidson | North Carolina | 37057 | 3404 | 42 |
636816 | 636816 | 2020-10-16 | Davidson | North Carolina | 37057 | 3374 | 42 |
633570 | 633570 | 2020-10-15 | Davidson | North Carolina | 37057 | 3336 | 42 |
630325 | 630325 | 2020-10-14 | Davidson | North Carolina | 37057 | 3296 | 42 |
627081 | 627081 | 2020-10-13 | Davidson | North Carolina | 37057 | 3265 | 41 |
623839 | 623839 | 2020-10-12 | Davidson | North Carolina | 37057 | 3230 | 39 |
620596 | 620596 | 2020-10-11 | Davidson | North Carolina | 37057 | 3205 | 39 |
617354 | 617354 | 2020-10-10 | Davidson | North Carolina | 37057 | 3174 | 39 |
614112 | 614112 | 2020-10-09 | Davidson | North Carolina | 37057 | 3130 | 39 |
610871 | 610871 | 2020-10-08 | Davidson | North Carolina | 37057 | 3090 | 39 |
607629 | 607629 | 2020-10-07 | Davidson | North Carolina | 37057 | 3041 | 39 |
604386 | 604386 | 2020-10-06 | Davidson | North Carolina | 37057 | 3015 | 38 |
601144 | 601144 | 2020-10-05 | Davidson | North Carolina | 37057 | 2998 | 38 |
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);