ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
791 rows where fips = 37085 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 |
---|---|---|---|---|---|---|---|
922383 | 922383 | 2021-01-12 | Harnett | North Carolina | 37085 | 6923 | 101 |
919138 | 919138 | 2021-01-11 | Harnett | North Carolina | 37085 | 6816 | 101 |
915893 | 915893 | 2021-01-10 | Harnett | North Carolina | 37085 | 6753 | 101 |
912648 | 912648 | 2021-01-09 | Harnett | North Carolina | 37085 | 6664 | 102 |
909403 | 909403 | 2021-01-08 | Harnett | North Carolina | 37085 | 6554 | 102 |
906158 | 906158 | 2021-01-07 | Harnett | North Carolina | 37085 | 6440 | 100 |
902912 | 902912 | 2021-01-06 | Harnett | North Carolina | 37085 | 6336 | 97 |
899667 | 899667 | 2021-01-05 | Harnett | North Carolina | 37085 | 6256 | 96 |
896422 | 896422 | 2021-01-04 | Harnett | North Carolina | 37085 | 6212 | 95 |
893176 | 893176 | 2021-01-03 | Harnett | North Carolina | 37085 | 6162 | 95 |
889930 | 889930 | 2021-01-02 | Harnett | North Carolina | 37085 | 6113 | 95 |
886683 | 886683 | 2021-01-01 | Harnett | North Carolina | 37085 | 5958 | 94 |
883438 | 883438 | 2020-12-31 | Harnett | North Carolina | 37085 | 5958 | 94 |
880193 | 880193 | 2020-12-30 | Harnett | North Carolina | 37085 | 5850 | 93 |
876948 | 876948 | 2020-12-29 | Harnett | North Carolina | 37085 | 5750 | 89 |
873703 | 873703 | 2020-12-28 | Harnett | North Carolina | 37085 | 5714 | 89 |
870458 | 870458 | 2020-12-27 | Harnett | North Carolina | 37085 | 5685 | 89 |
867213 | 867213 | 2020-12-26 | Harnett | North Carolina | 37085 | 5668 | 89 |
863968 | 863968 | 2020-12-25 | Harnett | North Carolina | 37085 | 5476 | 89 |
860723 | 860723 | 2020-12-24 | Harnett | North Carolina | 37085 | 5476 | 89 |
857478 | 857478 | 2020-12-23 | Harnett | North Carolina | 37085 | 5476 | 89 |
854233 | 854233 | 2020-12-22 | Harnett | North Carolina | 37085 | 5411 | 89 |
850988 | 850988 | 2020-12-21 | Harnett | North Carolina | 37085 | 5359 | 89 |
847743 | 847743 | 2020-12-20 | Harnett | North Carolina | 37085 | 5318 | 89 |
844498 | 844498 | 2020-12-19 | Harnett | North Carolina | 37085 | 5250 | 89 |
841252 | 841252 | 2020-12-18 | Harnett | North Carolina | 37085 | 5213 | 89 |
838007 | 838007 | 2020-12-17 | Harnett | North Carolina | 37085 | 5111 | 88 |
834761 | 834761 | 2020-12-16 | Harnett | North Carolina | 37085 | 5043 | 88 |
831515 | 831515 | 2020-12-15 | Harnett | North Carolina | 37085 | 4944 | 84 |
828268 | 828268 | 2020-12-14 | Harnett | North Carolina | 37085 | 4889 | 84 |
825022 | 825022 | 2020-12-13 | Harnett | North Carolina | 37085 | 4844 | 84 |
821775 | 821775 | 2020-12-12 | Harnett | North Carolina | 37085 | 4782 | 84 |
818529 | 818529 | 2020-12-11 | Harnett | North Carolina | 37085 | 4710 | 83 |
815283 | 815283 | 2020-12-10 | Harnett | North Carolina | 37085 | 4652 | 83 |
812038 | 812038 | 2020-12-09 | Harnett | North Carolina | 37085 | 4590 | 79 |
808793 | 808793 | 2020-12-08 | Harnett | North Carolina | 37085 | 4514 | 79 |
805548 | 805548 | 2020-12-07 | Harnett | North Carolina | 37085 | 4474 | 79 |
802303 | 802303 | 2020-12-06 | Harnett | North Carolina | 37085 | 4435 | 79 |
799058 | 799058 | 2020-12-05 | Harnett | North Carolina | 37085 | 4282 | 79 |
795813 | 795813 | 2020-12-04 | Harnett | North Carolina | 37085 | 4247 | 79 |
792568 | 792568 | 2020-12-03 | Harnett | North Carolina | 37085 | 4175 | 78 |
789323 | 789323 | 2020-12-02 | Harnett | North Carolina | 37085 | 4112 | 78 |
786078 | 786078 | 2020-12-01 | Harnett | North Carolina | 37085 | 4044 | 77 |
782834 | 782834 | 2020-11-30 | Harnett | North Carolina | 37085 | 3978 | 77 |
779588 | 779588 | 2020-11-29 | Harnett | North Carolina | 37085 | 3963 | 77 |
776343 | 776343 | 2020-11-28 | Harnett | North Carolina | 37085 | 3931 | 77 |
773098 | 773098 | 2020-11-27 | Harnett | North Carolina | 37085 | 3878 | 77 |
769853 | 769853 | 2020-11-26 | Harnett | North Carolina | 37085 | 3802 | 77 |
766607 | 766607 | 2020-11-25 | Harnett | North Carolina | 37085 | 3802 | 77 |
763362 | 763362 | 2020-11-24 | Harnett | North Carolina | 37085 | 3753 | 77 |
760117 | 760117 | 2020-11-23 | Harnett | North Carolina | 37085 | 3741 | 77 |
756871 | 756871 | 2020-11-22 | Harnett | North Carolina | 37085 | 3709 | 77 |
753624 | 753624 | 2020-11-21 | Harnett | North Carolina | 37085 | 3657 | 77 |
750378 | 750378 | 2020-11-20 | Harnett | North Carolina | 37085 | 3635 | 77 |
747132 | 747132 | 2020-11-19 | Harnett | North Carolina | 37085 | 3589 | 77 |
743886 | 743886 | 2020-11-18 | Harnett | North Carolina | 37085 | 3513 | 77 |
740639 | 740639 | 2020-11-17 | Harnett | North Carolina | 37085 | 3472 | 77 |
737394 | 737394 | 2020-11-16 | Harnett | North Carolina | 37085 | 3436 | 77 |
734150 | 734150 | 2020-11-15 | Harnett | North Carolina | 37085 | 3414 | 77 |
730904 | 730904 | 2020-11-14 | Harnett | North Carolina | 37085 | 3387 | 77 |
727660 | 727660 | 2020-11-13 | Harnett | North Carolina | 37085 | 3358 | 76 |
724416 | 724416 | 2020-11-12 | Harnett | North Carolina | 37085 | 3345 | 76 |
721173 | 721173 | 2020-11-11 | Harnett | North Carolina | 37085 | 3319 | 76 |
717930 | 717930 | 2020-11-10 | Harnett | North Carolina | 37085 | 3283 | 75 |
714687 | 714687 | 2020-11-09 | Harnett | North Carolina | 37085 | 3254 | 75 |
711443 | 711443 | 2020-11-08 | Harnett | North Carolina | 37085 | 3244 | 75 |
708199 | 708199 | 2020-11-07 | Harnett | North Carolina | 37085 | 3224 | 75 |
704956 | 704956 | 2020-11-06 | Harnett | North Carolina | 37085 | 3197 | 75 |
701713 | 701713 | 2020-11-05 | Harnett | North Carolina | 37085 | 3167 | 74 |
698469 | 698469 | 2020-11-04 | Harnett | North Carolina | 37085 | 3122 | 72 |
695226 | 695226 | 2020-11-03 | Harnett | North Carolina | 37085 | 3088 | 72 |
691984 | 691984 | 2020-11-02 | Harnett | North Carolina | 37085 | 3072 | 72 |
688740 | 688740 | 2020-11-01 | Harnett | North Carolina | 37085 | 3059 | 72 |
685495 | 685495 | 2020-10-31 | Harnett | North Carolina | 37085 | 3036 | 72 |
682252 | 682252 | 2020-10-30 | Harnett | North Carolina | 37085 | 3000 | 72 |
679009 | 679009 | 2020-10-29 | Harnett | North Carolina | 37085 | 2969 | 70 |
675766 | 675766 | 2020-10-28 | Harnett | North Carolina | 37085 | 2940 | 69 |
672523 | 672523 | 2020-10-27 | Harnett | North Carolina | 37085 | 2901 | 68 |
669281 | 669281 | 2020-10-26 | Harnett | North Carolina | 37085 | 2883 | 68 |
666037 | 666037 | 2020-10-25 | Harnett | North Carolina | 37085 | 2874 | 68 |
662792 | 662792 | 2020-10-24 | Harnett | North Carolina | 37085 | 2856 | 68 |
659548 | 659548 | 2020-10-23 | Harnett | North Carolina | 37085 | 2808 | 68 |
656304 | 656304 | 2020-10-22 | Harnett | North Carolina | 37085 | 2791 | 68 |
653059 | 653059 | 2020-10-21 | Harnett | North Carolina | 37085 | 2762 | 68 |
649814 | 649814 | 2020-10-20 | Harnett | North Carolina | 37085 | 2736 | 68 |
646570 | 646570 | 2020-10-19 | Harnett | North Carolina | 37085 | 2717 | 66 |
643324 | 643324 | 2020-10-18 | Harnett | North Carolina | 37085 | 2704 | 66 |
640076 | 640076 | 2020-10-17 | Harnett | North Carolina | 37085 | 2683 | 66 |
636830 | 636830 | 2020-10-16 | Harnett | North Carolina | 37085 | 2652 | 64 |
633584 | 633584 | 2020-10-15 | Harnett | North Carolina | 37085 | 2630 | 64 |
630339 | 630339 | 2020-10-14 | Harnett | North Carolina | 37085 | 2599 | 65 |
627095 | 627095 | 2020-10-13 | Harnett | North Carolina | 37085 | 2581 | 63 |
623853 | 623853 | 2020-10-12 | Harnett | North Carolina | 37085 | 2551 | 62 |
620610 | 620610 | 2020-10-11 | Harnett | North Carolina | 37085 | 2545 | 62 |
617368 | 617368 | 2020-10-10 | Harnett | North Carolina | 37085 | 2529 | 62 |
614126 | 614126 | 2020-10-09 | Harnett | North Carolina | 37085 | 2515 | 60 |
610885 | 610885 | 2020-10-08 | Harnett | North Carolina | 37085 | 2488 | 60 |
607643 | 607643 | 2020-10-07 | Harnett | North Carolina | 37085 | 2451 | 56 |
604400 | 604400 | 2020-10-06 | Harnett | North Carolina | 37085 | 2421 | 56 |
601158 | 601158 | 2020-10-05 | Harnett | North Carolina | 37085 | 2401 | 54 |
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);