ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
787 rows where county = "New Hanover" 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 |
---|---|---|---|---|---|---|---|
1055474 | 1055474 | 2021-02-22 | New Hanover | North Carolina | 37129 | 15797 | 139 |
1052228 | 1052228 | 2021-02-21 | New Hanover | North Carolina | 37129 | 15760 | 139 |
1048981 | 1048981 | 2021-02-20 | New Hanover | North Carolina | 37129 | 15711 | 139 |
1045734 | 1045734 | 2021-02-19 | New Hanover | North Carolina | 37129 | 15645 | 139 |
1042489 | 1042489 | 2021-02-18 | New Hanover | North Carolina | 37129 | 15569 | 139 |
1039244 | 1039244 | 2021-02-17 | New Hanover | North Carolina | 37129 | 15440 | 138 |
1035999 | 1035999 | 2021-02-16 | New Hanover | North Carolina | 37129 | 15359 | 136 |
1032754 | 1032754 | 2021-02-15 | New Hanover | North Carolina | 37129 | 15286 | 136 |
1029508 | 1029508 | 2021-02-14 | New Hanover | North Carolina | 37129 | 15227 | 136 |
1026261 | 1026261 | 2021-02-13 | New Hanover | North Carolina | 37129 | 15125 | 136 |
1023016 | 1023016 | 2021-02-12 | New Hanover | North Carolina | 37129 | 15008 | 135 |
1019771 | 1019771 | 2021-02-11 | New Hanover | North Carolina | 37129 | 14887 | 135 |
1016526 | 1016526 | 2021-02-10 | New Hanover | North Carolina | 37129 | 14731 | 135 |
1013281 | 1013281 | 2021-02-09 | New Hanover | North Carolina | 37129 | 14645 | 135 |
1010036 | 1010036 | 2021-02-08 | New Hanover | North Carolina | 37129 | 14572 | 134 |
1006790 | 1006790 | 2021-02-07 | New Hanover | North Carolina | 37129 | 14484 | 134 |
1003544 | 1003544 | 2021-02-06 | New Hanover | North Carolina | 37129 | 14372 | 133 |
1000298 | 1000298 | 2021-02-05 | New Hanover | North Carolina | 37129 | 14279 | 133 |
997052 | 997052 | 2021-02-04 | New Hanover | North Carolina | 37129 | 14169 | 131 |
993806 | 993806 | 2021-02-03 | New Hanover | North Carolina | 37129 | 14060 | 131 |
990560 | 990560 | 2021-02-02 | New Hanover | North Carolina | 37129 | 13869 | 130 |
987314 | 987314 | 2021-02-01 | New Hanover | North Carolina | 37129 | 13784 | 130 |
984067 | 984067 | 2021-01-31 | New Hanover | North Carolina | 37129 | 13699 | 130 |
980820 | 980820 | 2021-01-30 | New Hanover | North Carolina | 37129 | 13416 | 122 |
977574 | 977574 | 2021-01-29 | New Hanover | North Carolina | 37129 | 13416 | 122 |
974329 | 974329 | 2021-01-28 | New Hanover | North Carolina | 37129 | 13278 | 121 |
971084 | 971084 | 2021-01-27 | New Hanover | North Carolina | 37129 | 13163 | 116 |
967839 | 967839 | 2021-01-26 | New Hanover | North Carolina | 37129 | 12992 | 110 |
964595 | 964595 | 2021-01-25 | New Hanover | North Carolina | 37129 | 12870 | 110 |
961350 | 961350 | 2021-01-24 | New Hanover | North Carolina | 37129 | 12763 | 110 |
958105 | 958105 | 2021-01-23 | New Hanover | North Carolina | 37129 | 12691 | 108 |
954859 | 954859 | 2021-01-22 | New Hanover | North Carolina | 37129 | 12564 | 103 |
951614 | 951614 | 2021-01-21 | New Hanover | North Carolina | 37129 | 12392 | 101 |
948369 | 948369 | 2021-01-20 | New Hanover | North Carolina | 37129 | 12298 | 101 |
945122 | 945122 | 2021-01-19 | New Hanover | North Carolina | 37129 | 11510 | 100 |
941876 | 941876 | 2021-01-18 | New Hanover | North Carolina | 37129 | 11415 | 100 |
938631 | 938631 | 2021-01-17 | New Hanover | North Carolina | 37129 | 11415 | 100 |
935386 | 935386 | 2021-01-16 | New Hanover | North Carolina | 37129 | 11298 | 100 |
932141 | 932141 | 2021-01-15 | New Hanover | North Carolina | 37129 | 11200 | 100 |
928896 | 928896 | 2021-01-14 | New Hanover | North Carolina | 37129 | 11090 | 99 |
925651 | 925651 | 2021-01-13 | New Hanover | North Carolina | 37129 | 10985 | 99 |
922405 | 922405 | 2021-01-12 | New Hanover | North Carolina | 37129 | 10891 | 99 |
919160 | 919160 | 2021-01-11 | New Hanover | North Carolina | 37129 | 10828 | 97 |
915915 | 915915 | 2021-01-10 | New Hanover | North Carolina | 37129 | 10720 | 97 |
912670 | 912670 | 2021-01-09 | New Hanover | North Carolina | 37129 | 10612 | 96 |
909425 | 909425 | 2021-01-08 | New Hanover | North Carolina | 37129 | 10504 | 96 |
906180 | 906180 | 2021-01-07 | New Hanover | North Carolina | 37129 | 10384 | 94 |
902934 | 902934 | 2021-01-06 | New Hanover | North Carolina | 37129 | 10205 | 94 |
899689 | 899689 | 2021-01-05 | New Hanover | North Carolina | 37129 | 10093 | 94 |
896444 | 896444 | 2021-01-04 | New Hanover | North Carolina | 37129 | 10012 | 91 |
893198 | 893198 | 2021-01-03 | New Hanover | North Carolina | 37129 | 9946 | 91 |
889952 | 889952 | 2021-01-02 | New Hanover | North Carolina | 37129 | 9860 | 91 |
886705 | 886705 | 2021-01-01 | New Hanover | North Carolina | 37129 | 9597 | 89 |
883460 | 883460 | 2020-12-31 | New Hanover | North Carolina | 37129 | 9597 | 89 |
880215 | 880215 | 2020-12-30 | New Hanover | North Carolina | 37129 | 9531 | 85 |
876970 | 876970 | 2020-12-29 | New Hanover | North Carolina | 37129 | 9417 | 84 |
873725 | 873725 | 2020-12-28 | New Hanover | North Carolina | 37129 | 9381 | 84 |
870480 | 870480 | 2020-12-27 | New Hanover | North Carolina | 37129 | 9319 | 84 |
867235 | 867235 | 2020-12-26 | New Hanover | North Carolina | 37129 | 9292 | 83 |
863990 | 863990 | 2020-12-25 | New Hanover | North Carolina | 37129 | 8961 | 75 |
860745 | 860745 | 2020-12-24 | New Hanover | North Carolina | 37129 | 8961 | 75 |
857500 | 857500 | 2020-12-23 | New Hanover | North Carolina | 37129 | 8961 | 75 |
854255 | 854255 | 2020-12-22 | New Hanover | North Carolina | 37129 | 8882 | 74 |
851010 | 851010 | 2020-12-21 | New Hanover | North Carolina | 37129 | 8793 | 71 |
847765 | 847765 | 2020-12-20 | New Hanover | North Carolina | 37129 | 8743 | 71 |
844520 | 844520 | 2020-12-19 | New Hanover | North Carolina | 37129 | 8650 | 71 |
841274 | 841274 | 2020-12-18 | New Hanover | North Carolina | 37129 | 8570 | 69 |
838029 | 838029 | 2020-12-17 | New Hanover | North Carolina | 37129 | 8435 | 68 |
834783 | 834783 | 2020-12-16 | New Hanover | North Carolina | 37129 | 8373 | 68 |
831537 | 831537 | 2020-12-15 | New Hanover | North Carolina | 37129 | 8307 | 68 |
828290 | 828290 | 2020-12-14 | New Hanover | North Carolina | 37129 | 8204 | 68 |
825044 | 825044 | 2020-12-13 | New Hanover | North Carolina | 37129 | 8136 | 68 |
821797 | 821797 | 2020-12-12 | New Hanover | North Carolina | 37129 | 8056 | 66 |
818551 | 818551 | 2020-12-11 | New Hanover | North Carolina | 37129 | 7987 | 66 |
815305 | 815305 | 2020-12-10 | New Hanover | North Carolina | 37129 | 7799 | 62 |
812060 | 812060 | 2020-12-09 | New Hanover | North Carolina | 37129 | 7719 | 62 |
808815 | 808815 | 2020-12-08 | New Hanover | North Carolina | 37129 | 7628 | 62 |
805570 | 805570 | 2020-12-07 | New Hanover | North Carolina | 37129 | 7589 | 62 |
802325 | 802325 | 2020-12-06 | New Hanover | North Carolina | 37129 | 7550 | 62 |
799080 | 799080 | 2020-12-05 | New Hanover | North Carolina | 37129 | 7429 | 61 |
795835 | 795835 | 2020-12-04 | New Hanover | North Carolina | 37129 | 7339 | 60 |
792590 | 792590 | 2020-12-03 | New Hanover | North Carolina | 37129 | 7261 | 60 |
789345 | 789345 | 2020-12-02 | New Hanover | North Carolina | 37129 | 7161 | 60 |
786100 | 786100 | 2020-12-01 | New Hanover | North Carolina | 37129 | 7076 | 55 |
782856 | 782856 | 2020-11-30 | New Hanover | North Carolina | 37129 | 7008 | 53 |
779610 | 779610 | 2020-11-29 | New Hanover | North Carolina | 37129 | 6961 | 53 |
776365 | 776365 | 2020-11-28 | New Hanover | North Carolina | 37129 | 6889 | 53 |
773120 | 773120 | 2020-11-27 | New Hanover | North Carolina | 37129 | 6840 | 53 |
769875 | 769875 | 2020-11-26 | New Hanover | North Carolina | 37129 | 6723 | 53 |
766629 | 766629 | 2020-11-25 | New Hanover | North Carolina | 37129 | 6723 | 53 |
763384 | 763384 | 2020-11-24 | New Hanover | North Carolina | 37129 | 6662 | 52 |
760139 | 760139 | 2020-11-23 | New Hanover | North Carolina | 37129 | 6610 | 52 |
756893 | 756893 | 2020-11-22 | New Hanover | North Carolina | 37129 | 6564 | 52 |
753646 | 753646 | 2020-11-21 | New Hanover | North Carolina | 37129 | 6490 | 51 |
750400 | 750400 | 2020-11-20 | New Hanover | North Carolina | 37129 | 6421 | 50 |
747154 | 747154 | 2020-11-19 | New Hanover | North Carolina | 37129 | 6362 | 49 |
743908 | 743908 | 2020-11-18 | New Hanover | North Carolina | 37129 | 6281 | 49 |
740661 | 740661 | 2020-11-17 | New Hanover | North Carolina | 37129 | 6227 | 48 |
737416 | 737416 | 2020-11-16 | New Hanover | North Carolina | 37129 | 6180 | 47 |
734172 | 734172 | 2020-11-15 | New Hanover | North Carolina | 37129 | 6134 | 47 |
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);