ny_times_us_counties

Table actions
⚠️ Consult the README for warnings about using and building on this data. Also review Why It’s So Freaking Hard To Make A Good COVID-19 Model and Ten Considerations Before You Create Another Chart About COVID-19.

Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette

34,609 rows where state = "North Carolina" sorted by date descending

✎ View and edit SQL

This data as json, yaml, Notebook, copyable, CSV (advanced)

Suggested facets: date (date)

fips

county

state

  • North Carolina · 34,609 ✖
Link rowid date ▲ county state fips cases deaths
1097604 1097604 2021-03-07 Alamance North Carolina 37001 15938 230
1097605 1097605 2021-03-07 Alexander North Carolina 37003 3951 76
1097606 1097606 2021-03-07 Alleghany North Carolina 37005 928 5
1097607 1097607 2021-03-07 Anson North Carolina 37007 2327 53
1097608 1097608 2021-03-07 Ashe North Carolina 37009 1893 40
1097609 1097609 2021-03-07 Avery North Carolina 37011 1849 20
1097610 1097610 2021-03-07 Beaufort North Carolina 37013 4289 83
1097611 1097611 2021-03-07 Bertie North Carolina 37015 1664 41
1097612 1097612 2021-03-07 Bladen North Carolina 37017 2979 41
1097613 1097613 2021-03-07 Brunswick North Carolina 37019 8116 137
1097614 1097614 2021-03-07 Buncombe North Carolina 37021 15752 303
1097615 1097615 2021-03-07 Burke North Carolina 37023 9289 142
1097616 1097616 2021-03-07 Cabarrus North Carolina 37025 18727 236
1097617 1097617 2021-03-07 Caldwell North Carolina 37027 8712 79
1097618 1097618 2021-03-07 Camden North Carolina 37029 596 5
1097619 1097619 2021-03-07 Carteret North Carolina 37031 4479 44
1097620 1097620 2021-03-07 Caswell North Carolina 37033 1993 24
1097621 1097621 2021-03-07 Catawba North Carolina 37035 17614 286
1097622 1097622 2021-03-07 Chatham North Carolina 37037 4166 78
1097623 1097623 2021-03-07 Cherokee North Carolina 37039 2136 19
1097624 1097624 2021-03-07 Chowan North Carolina 37041 1382 22
1097625 1097625 2021-03-07 Clay North Carolina 37043 662 18
1097626 1097626 2021-03-07 Cleveland North Carolina 37045 10422 218
1097627 1097627 2021-03-07 Columbus North Carolina 37047 5931 147
1097628 1097628 2021-03-07 Craven North Carolina 37049 8438 115
1097629 1097629 2021-03-07 Cumberland North Carolina 37051 24477 281
1097630 1097630 2021-03-07 Currituck North Carolina 37053 1396 15
1097631 1097631 2021-03-07 Dare North Carolina 37055 1871 8
1097632 1097632 2021-03-07 Davidson North Carolina 37057 14746 167
1097633 1097633 2021-03-07 Davie North Carolina 37059 3583 31
1097634 1097634 2021-03-07 Duplin North Carolina 37061 5773 128
1097635 1097635 2021-03-07 Durham North Carolina 37063 22259 210
1097636 1097636 2021-03-07 Edgecombe North Carolina 37065 4729 100
1097637 1097637 2021-03-07 Forsyth North Carolina 37067 32220 349
1097638 1097638 2021-03-07 Franklin North Carolina 37069 5521 45
1097639 1097639 2021-03-07 Gaston North Carolina 37071 23974 379
1097640 1097640 2021-03-07 Gates North Carolina 37073 678 12
1097641 1097641 2021-03-07 Graham North Carolina 37075 566 12
1097642 1097642 2021-03-07 Granville North Carolina 37077 5304 76
1097643 1097643 2021-03-07 Greene North Carolina 37079 2144 42
1097644 1097644 2021-03-07 Guilford North Carolina 37081 40451 558
1097645 1097645 2021-03-07 Halifax North Carolina 37083 5032 99
1097646 1097646 2021-03-07 Harnett North Carolina 37085 9843 155
1097647 1097647 2021-03-07 Haywood North Carolina 37087 3893 88
1097648 1097648 2021-03-07 Henderson North Carolina 37089 8995 149
1097649 1097649 2021-03-07 Hertford North Carolina 37091 1963 61
1097650 1097650 2021-03-07 Hoke North Carolina 37093 4169 54
1097651 1097651 2021-03-07 Hyde North Carolina 37095 628 8
1097652 1097652 2021-03-07 Iredell North Carolina 37097 16641 196
1097653 1097653 2021-03-07 Jackson North Carolina 37099 3372 54
1097654 1097654 2021-03-07 Johnston North Carolina 37101 18214 201
1097655 1097655 2021-03-07 Jones North Carolina 37103 739 16
1097656 1097656 2021-03-07 Lee North Carolina 37105 5506 72
1097657 1097657 2021-03-07 Lenoir North Carolina 37107 5499 107
1097658 1097658 2021-03-07 Lincoln North Carolina 37109 8904 71
1097659 1097659 2021-03-07 Macon North Carolina 37113 2586 28
1097660 1097660 2021-03-07 Madison North Carolina 37115 1373 39
1097661 1097661 2021-03-07 Martin North Carolina 37117 2089 37
1097662 1097662 2021-03-07 McDowell North Carolina 37111 4875 61
1097663 1097663 2021-03-07 Mecklenburg North Carolina 37119 97954 887
1097664 1097664 2021-03-07 Mitchell North Carolina 37121 1245 16
1097665 1097665 2021-03-07 Montgomery North Carolina 37123 3100 88
1097666 1097666 2021-03-07 Moore North Carolina 37125 8076 178
1097667 1097667 2021-03-07 Nash North Carolina 37127 9877 172
1097668 1097668 2021-03-07 New Hanover North Carolina 37129 16459 152
1097669 1097669 2021-03-07 Northampton North Carolina 37131 1728 33
1097670 1097670 2021-03-07 Onslow North Carolina 37133 14833 134
1097671 1097671 2021-03-07 Orange North Carolina 37135 7827 95
1097672 1097672 2021-03-07 Pamlico North Carolina 37137 972 10
1097673 1097673 2021-03-07 Pasquotank North Carolina 37139 3091 78
1097674 1097674 2021-03-07 Pender North Carolina 37141 4772 60
1097675 1097675 2021-03-07 Perquimans North Carolina 37143 924 8
1097676 1097676 2021-03-07 Person North Carolina 37145 3038 64
1097677 1097677 2021-03-07 Pitt North Carolina 37147 17698 83
1097678 1097678 2021-03-07 Polk North Carolina 37149 1364 27
1097679 1097679 2021-03-07 Randolph North Carolina 37151 13500 205
1097680 1097680 2021-03-07 Richmond North Carolina 37153 4247 91
1097681 1097681 2021-03-07 Robeson North Carolina 37155 15332 212
1097682 1097682 2021-03-07 Rockingham North Carolina 37157 6903 61
1097683 1097683 2021-03-07 Rowan North Carolina 37159 15041 290
1097684 1097684 2021-03-07 Rutherford North Carolina 37161 6786 200
1097685 1097685 2021-03-07 Sampson North Carolina 37163 6942 92
1097686 1097686 2021-03-07 Scotland North Carolina 37165 3508 77
1097687 1097687 2021-03-07 Stanly North Carolina 37167 6917 111
1097688 1097688 2021-03-07 Stokes North Carolina 37169 3696 74
1097689 1097689 2021-03-07 Surry North Carolina 37171 7443 140
1097690 1097690 2021-03-07 Swain North Carolina 37173 1171 16
1097691 1097691 2021-03-07 Transylvania North Carolina 37175 1950 27
1097692 1097692 2021-03-07 Tyrrell North Carolina 37177 305 6
1097693 1097693 2021-03-07 Union North Carolina 37179 21023 202
1097694 1097694 2021-03-07 Vance North Carolina 37181 4414 82
1097695 1097695 2021-03-07 Wake North Carolina 37183 79457 550
1097696 1097696 2021-03-07 Warren North Carolina 37185 1614 18
1097697 1097697 2021-03-07 Washington North Carolina 37187 999 31
1097698 1097698 2021-03-07 Watauga North Carolina 37189 4019 30
1097699 1097699 2021-03-07 Wayne North Carolina 37191 10331 225
1097700 1097700 2021-03-07 Wilkes North Carolina 37193 6054 104
1097701 1097701 2021-03-07 Wilson North Carolina 37195 8543 150
1097702 1097702 2021-03-07 Yadkin North Carolina 37197 3680 46
1097703 1097703 2021-03-07 Yancey North Carolina 37199 1463 26

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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]);