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 |
---|---|---|---|---|---|---|---|
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 |
730926 | 730926 | 2020-11-14 | New Hanover | North Carolina | 37129 | 6092 | 47 |
727682 | 727682 | 2020-11-13 | New Hanover | North Carolina | 37129 | 5970 | 47 |
724438 | 724438 | 2020-11-12 | New Hanover | North Carolina | 37129 | 5910 | 46 |
721195 | 721195 | 2020-11-11 | New Hanover | North Carolina | 37129 | 5866 | 46 |
717952 | 717952 | 2020-11-10 | New Hanover | North Carolina | 37129 | 5811 | 46 |
714709 | 714709 | 2020-11-09 | New Hanover | North Carolina | 37129 | 5767 | 44 |
711465 | 711465 | 2020-11-08 | New Hanover | North Carolina | 37129 | 5738 | 44 |
708221 | 708221 | 2020-11-07 | New Hanover | North Carolina | 37129 | 5688 | 44 |
704978 | 704978 | 2020-11-06 | New Hanover | North Carolina | 37129 | 5648 | 42 |
701735 | 701735 | 2020-11-05 | New Hanover | North Carolina | 37129 | 5593 | 40 |
698491 | 698491 | 2020-11-04 | New Hanover | North Carolina | 37129 | 5551 | 40 |
695248 | 695248 | 2020-11-03 | New Hanover | North Carolina | 37129 | 5517 | 40 |
692006 | 692006 | 2020-11-02 | New Hanover | North Carolina | 37129 | 5468 | 40 |
688762 | 688762 | 2020-11-01 | New Hanover | North Carolina | 37129 | 5447 | 40 |
685517 | 685517 | 2020-10-31 | New Hanover | North Carolina | 37129 | 5410 | 40 |
682274 | 682274 | 2020-10-30 | New Hanover | North Carolina | 37129 | 5344 | 37 |
679031 | 679031 | 2020-10-29 | New Hanover | North Carolina | 37129 | 5305 | 37 |
675788 | 675788 | 2020-10-28 | New Hanover | North Carolina | 37129 | 5254 | 37 |
672545 | 672545 | 2020-10-27 | New Hanover | North Carolina | 37129 | 5229 | 37 |
669303 | 669303 | 2020-10-26 | New Hanover | North Carolina | 37129 | 5192 | 37 |
666059 | 666059 | 2020-10-25 | New Hanover | North Carolina | 37129 | 5171 | 37 |
662814 | 662814 | 2020-10-24 | New Hanover | North Carolina | 37129 | 5144 | 37 |
659570 | 659570 | 2020-10-23 | New Hanover | North Carolina | 37129 | 5099 | 37 |
656326 | 656326 | 2020-10-22 | New Hanover | North Carolina | 37129 | 5068 | 37 |
653081 | 653081 | 2020-10-21 | New Hanover | North Carolina | 37129 | 5011 | 37 |
649836 | 649836 | 2020-10-20 | New Hanover | North Carolina | 37129 | 4937 | 37 |
646592 | 646592 | 2020-10-19 | New Hanover | North Carolina | 37129 | 4917 | 37 |
643346 | 643346 | 2020-10-18 | New Hanover | North Carolina | 37129 | 4894 | 37 |
640098 | 640098 | 2020-10-17 | New Hanover | North Carolina | 37129 | 4850 | 36 |
636852 | 636852 | 2020-10-16 | New Hanover | North Carolina | 37129 | 4821 | 36 |
633606 | 633606 | 2020-10-15 | New Hanover | North Carolina | 37129 | 4782 | 35 |
630361 | 630361 | 2020-10-14 | New Hanover | North Carolina | 37129 | 4751 | 35 |
627117 | 627117 | 2020-10-13 | New Hanover | North Carolina | 37129 | 4723 | 35 |
623875 | 623875 | 2020-10-12 | New Hanover | North Carolina | 37129 | 4696 | 35 |
620632 | 620632 | 2020-10-11 | New Hanover | North Carolina | 37129 | 4680 | 35 |
617390 | 617390 | 2020-10-10 | New Hanover | North Carolina | 37129 | 4663 | 35 |
614148 | 614148 | 2020-10-09 | New Hanover | North Carolina | 37129 | 4628 | 33 |
610907 | 610907 | 2020-10-08 | New Hanover | North Carolina | 37129 | 4582 | 33 |
607665 | 607665 | 2020-10-07 | New Hanover | North Carolina | 37129 | 4547 | 33 |
604422 | 604422 | 2020-10-06 | New Hanover | North Carolina | 37129 | 4516 | 33 |
601180 | 601180 | 2020-10-05 | New Hanover | North Carolina | 37129 | 4481 | 33 |
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);