ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
791 rows where county = "Harnett" 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 |
---|---|---|---|---|---|---|---|
1055452 | 1055452 | 2021-02-22 | Harnett | North Carolina | 37085 | 9388 | 147 |
1052206 | 1052206 | 2021-02-21 | Harnett | North Carolina | 37085 | 9369 | 147 |
1048959 | 1048959 | 2021-02-20 | Harnett | North Carolina | 37085 | 9336 | 147 |
1045712 | 1045712 | 2021-02-19 | Harnett | North Carolina | 37085 | 9285 | 138 |
1042467 | 1042467 | 2021-02-18 | Harnett | North Carolina | 37085 | 9246 | 138 |
1039222 | 1039222 | 2021-02-17 | Harnett | North Carolina | 37085 | 9196 | 137 |
1035977 | 1035977 | 2021-02-16 | Harnett | North Carolina | 37085 | 9144 | 133 |
1032732 | 1032732 | 2021-02-15 | Harnett | North Carolina | 37085 | 9115 | 133 |
1029486 | 1029486 | 2021-02-14 | Harnett | North Carolina | 37085 | 9093 | 133 |
1026239 | 1026239 | 2021-02-13 | Harnett | North Carolina | 37085 | 9049 | 133 |
1022994 | 1022994 | 2021-02-12 | Harnett | North Carolina | 37085 | 9001 | 133 |
1019749 | 1019749 | 2021-02-11 | Harnett | North Carolina | 37085 | 8945 | 133 |
1016504 | 1016504 | 2021-02-10 | Harnett | North Carolina | 37085 | 8911 | 132 |
1013259 | 1013259 | 2021-02-09 | Harnett | North Carolina | 37085 | 8849 | 126 |
1010014 | 1010014 | 2021-02-08 | Harnett | North Carolina | 37085 | 8804 | 126 |
1006768 | 1006768 | 2021-02-07 | Harnett | North Carolina | 37085 | 8758 | 126 |
1003522 | 1003522 | 2021-02-06 | Harnett | North Carolina | 37085 | 8721 | 126 |
1000276 | 1000276 | 2021-02-05 | Harnett | North Carolina | 37085 | 8687 | 124 |
997030 | 997030 | 2021-02-04 | Harnett | North Carolina | 37085 | 8607 | 123 |
993784 | 993784 | 2021-02-03 | Harnett | North Carolina | 37085 | 8547 | 119 |
990538 | 990538 | 2021-02-02 | Harnett | North Carolina | 37085 | 8337 | 117 |
987292 | 987292 | 2021-02-01 | Harnett | North Carolina | 37085 | 8311 | 117 |
984045 | 984045 | 2021-01-31 | Harnett | North Carolina | 37085 | 8276 | 117 |
980798 | 980798 | 2021-01-30 | Harnett | North Carolina | 37085 | 8149 | 113 |
977552 | 977552 | 2021-01-29 | Harnett | North Carolina | 37085 | 8149 | 113 |
974307 | 974307 | 2021-01-28 | Harnett | North Carolina | 37085 | 8111 | 112 |
971062 | 971062 | 2021-01-27 | Harnett | North Carolina | 37085 | 7996 | 111 |
967817 | 967817 | 2021-01-26 | Harnett | North Carolina | 37085 | 7935 | 109 |
964573 | 964573 | 2021-01-25 | Harnett | North Carolina | 37085 | 7894 | 109 |
961328 | 961328 | 2021-01-24 | Harnett | North Carolina | 37085 | 7849 | 109 |
958083 | 958083 | 2021-01-23 | Harnett | North Carolina | 37085 | 7784 | 109 |
954837 | 954837 | 2021-01-22 | Harnett | North Carolina | 37085 | 7704 | 107 |
951592 | 951592 | 2021-01-21 | Harnett | North Carolina | 37085 | 7612 | 106 |
948347 | 948347 | 2021-01-20 | Harnett | North Carolina | 37085 | 7512 | 105 |
945100 | 945100 | 2021-01-19 | Harnett | North Carolina | 37085 | 7428 | 105 |
941854 | 941854 | 2021-01-18 | Harnett | North Carolina | 37085 | 7365 | 105 |
938609 | 938609 | 2021-01-17 | Harnett | North Carolina | 37085 | 7365 | 105 |
935364 | 935364 | 2021-01-16 | Harnett | North Carolina | 37085 | 7306 | 105 |
932119 | 932119 | 2021-01-15 | Harnett | North Carolina | 37085 | 7214 | 105 |
928874 | 928874 | 2021-01-14 | Harnett | North Carolina | 37085 | 7110 | 103 |
925629 | 925629 | 2021-01-13 | Harnett | North Carolina | 37085 | 7003 | 102 |
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 |
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);