home / covid

Menu
  • GraphQL API

ny_times_us_counties

Table actions
  • GraphQL API for ny_times_us_counties
⚠️ 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

77,809 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 >30

  • 37183 802
  • 37037 799
  • 37025 793
  • 37067 793
  • 37101 793
  • 37119 793
  • 37133 793
  • 37191 792
  • 37019 791
  • 37049 791
  • 37085 791
  • 37189 790
  • 37195 790
  • 37063 789
  • 37097 788
  • 37163 788
  • 37071 787
  • 37081 787
  • 37093 787
  • 37109 787
  • 37125 787
  • 37129 787
  • 37031 785
  • 37057 785
  • 37069 785
  • 37135 785
  • 37139 785
  • 37147 785
  • 37159 785
  • 37167 785
  • …

county >30

  • Wake 802
  • Chatham 799
  • Cabarrus 793
  • Forsyth 793
  • Johnston 793
  • Mecklenburg 793
  • Onslow 793
  • Wayne 792
  • Brunswick 791
  • Craven 791
  • Harnett 791
  • Watauga 790
  • Wilson 790
  • Durham 789
  • Iredell 788
  • Sampson 788
  • Gaston 787
  • Guilford 787
  • Hoke 787
  • Lincoln 787
  • Moore 787
  • New Hanover 787
  • Carteret 785
  • Davidson 785
  • Franklin 785
  • Orange 785
  • Pasquotank 785
  • Pitt 785
  • Rowan 785
  • Stanly 785
  • …

state 1

  • North Carolina · 77,809 ✖
Link rowid date ▲ county state fips cases deaths
2501486 2501486 2022-05-13 Alamance North Carolina 37001 47756 488
2501487 2501487 2022-05-13 Alexander North Carolina 37003 10479 139
2501488 2501488 2022-05-13 Alleghany North Carolina 37005 2981 16
2501489 2501489 2022-05-13 Anson North Carolina 37007 6567 101
2501490 2501490 2022-05-13 Ashe North Carolina 37009 6471 78
2501491 2501491 2022-05-13 Avery North Carolina 37011 4621 44
2501492 2501492 2022-05-13 Beaufort North Carolina 37013 12715 171
2501493 2501493 2022-05-13 Bertie North Carolina 37015 4277 68
2501494 2501494 2022-05-13 Bladen North Carolina 37017 9365 127
2501495 2501495 2022-05-13 Brunswick North Carolina 37019 30542 332
2501496 2501496 2022-05-13 Buncombe North Carolina 37021 54155 593
2501497 2501497 2022-05-13 Burke North Carolina 37023 25399 327
2501498 2501498 2022-05-13 Cabarrus North Carolina 37025 56620 494
2501499 2501499 2022-05-13 Caldwell North Carolina 37027 22411 308
2501500 2501500 2022-05-13 Camden North Carolina 37029 1786 9
2501501 2501501 2022-05-13 Carteret North Carolina 37031 14255 124
2501502 2501502 2022-05-13 Caswell North Carolina 37033 5357 48
2501503 2501503 2022-05-13 Catawba North Carolina 37035 47959 600
2501504 2501504 2022-05-13 Chatham North Carolina 37037 13262 114
2501505 2501505 2022-05-13 Cherokee North Carolina 37039 7126 121
2501506 2501506 2022-05-13 Chowan North Carolina 37041 4160 61
2501507 2501507 2022-05-13 Clay North Carolina 37043 2634 44
2501508 2501508 2022-05-13 Cleveland North Carolina 37045 29743 387
2501509 2501509 2022-05-13 Columbus North Carolina 37047 15997 269
2501510 2501510 2022-05-13 Craven North Carolina 37049 24698 207
2501511 2501511 2022-05-13 Cumberland North Carolina 37051 87898 630
2501512 2501512 2022-05-13 Currituck North Carolina 37053 5051 36
2501513 2501513 2022-05-13 Dare North Carolina 37055 7565 27
2501514 2501514 2022-05-13 Davidson North Carolina 37057 43561 427
2501515 2501515 2022-05-13 Davie North Carolina 37059 11315 104
2501516 2501516 2022-05-13 Duplin North Carolina 37061 16909 245
2501517 2501517 2022-05-13 Durham North Carolina 37063 76734 338
2501518 2501518 2022-05-13 Edgecombe North Carolina 37065 13616 154
2501519 2501519 2022-05-13 Forsyth North Carolina 37067 94312 824
2501520 2501520 2022-05-13 Franklin North Carolina 37069 20719 79
2501521 2501521 2022-05-13 Gaston North Carolina 37071 65857 850
2501522 2501522 2022-05-13 Gates North Carolina 37073 1926 20
2501523 2501523 2022-05-13 Graham North Carolina 37075 2310 31
2501524 2501524 2022-05-13 Granville North Carolina 37077 14536 115
2501525 2501525 2022-05-13 Greene North Carolina 37079 5826 67
2501526 2501526 2022-05-13 Guilford North Carolina 37081 121303 1208
2501527 2501527 2022-05-13 Halifax North Carolina 37083 14035 187
2501528 2501528 2022-05-13 Harnett North Carolina 37085 33797 339
2501529 2501529 2022-05-13 Haywood North Carolina 37087 13175 221
2501530 2501530 2022-05-13 Henderson North Carolina 37089 25284 316
2501531 2501531 2022-05-13 Hertford North Carolina 37091 4779 84
2501532 2501532 2022-05-13 Hoke North Carolina 37093 15074 116
2501533 2501533 2022-05-13 Hyde North Carolina 37095 1340 13
2501534 2501534 2022-05-13 Iredell North Carolina 37097 49004 466
2501535 2501535 2022-05-13 Jackson North Carolina 37099 9794 96
2501536 2501536 2022-05-13 Johnston North Carolina 37101 60301 452
2501537 2501537 2022-05-13 Jones North Carolina 37103 2235 39
2501538 2501538 2022-05-13 Lee North Carolina 37105 16113 151
2501539 2501539 2022-05-13 Lenoir North Carolina 37107 15839 220
2501540 2501540 2022-05-13 Lincoln North Carolina 37109 24543 174
2501541 2501541 2022-05-13 Macon North Carolina 37113 7978 121
2501542 2501542 2022-05-13 Madison North Carolina 37115 5186 81
2501543 2501543 2022-05-13 Martin North Carolina 37117 6112 93
2501544 2501544 2022-05-13 McDowell North Carolina 37111 13855 176
2501545 2501545 2022-05-13 Mecklenburg North Carolina 37119 284986 1621
2501546 2501546 2022-05-13 Mitchell North Carolina 37121 3474 37
2501547 2501547 2022-05-13 Montgomery North Carolina 37123 7308 129
2501548 2501548 2022-05-13 Moore North Carolina 37125 24595 324
2501549 2501549 2022-05-13 Nash North Carolina 37127 26558 309
2501550 2501550 2022-05-13 New Hanover North Carolina 37129 51432 394
2501551 2501551 2022-05-13 Northampton North Carolina 37131 4351 84
2501552 2501552 2022-05-13 Onslow North Carolina 37133 52306 376
2501553 2501553 2022-05-13 Orange North Carolina 37135 28209 134
2501554 2501554 2022-05-13 Pamlico North Carolina 37137 2630 28
2501555 2501555 2022-05-13 Pasquotank North Carolina 37139 8571 125
2501556 2501556 2022-05-13 Pender North Carolina 37141 15405 128
2501557 2501557 2022-05-13 Perquimans North Carolina 37143 2780 24
2501558 2501558 2022-05-13 Person North Carolina 37145 9449 109
2501559 2501559 2022-05-13 Pitt North Carolina 37147 52792 205
2501560 2501560 2022-05-13 Polk North Carolina 37149 3918 64
2501561 2501561 2022-05-13 Randolph North Carolina 37151 35874 444
2501562 2501562 2022-05-13 Richmond North Carolina 37153 12917 192
2501563 2501563 2022-05-13 Robeson North Carolina 37155 40690 538
2501564 2501564 2022-05-13 Rockingham North Carolina 37157 22198 293
2501565 2501565 2022-05-13 Rowan North Carolina 37159 41591 581
2501566 2501566 2022-05-13 Rutherford North Carolina 37161 17579 401
2501567 2501567 2022-05-13 Sampson North Carolina 37163 18913 183
2501568 2501568 2022-05-13 Scotland North Carolina 37165 10125 132
2501569 2501569 2022-05-13 Stanly North Carolina 37167 19435 261
2501570 2501570 2022-05-13 Stokes North Carolina 37169 11315 180
2501571 2501571 2022-05-13 Surry North Carolina 37171 21231 350
2501572 2501572 2022-05-13 Swain North Carolina 37173 3715 43
2501573 2501573 2022-05-13 Transylvania North Carolina 37175 6199 75
2501574 2501574 2022-05-13 Tyrrell North Carolina 37177 982 8
2501575 2501575 2022-05-13 Union North Carolina 37179 62697 490
2501576 2501576 2022-05-13 Vance North Carolina 37181 11936 122
2501577 2501577 2022-05-13 Wake North Carolina 37183 300453 1119
2501578 2501578 2022-05-13 Warren North Carolina 37185 4381 45
2501579 2501579 2022-05-13 Washington North Carolina 37187 3056 50
2501580 2501580 2022-05-13 Watauga North Carolina 37189 12877 68
2501581 2501581 2022-05-13 Wayne North Carolina 37191 31560 405
2501582 2501582 2022-05-13 Wilkes North Carolina 37193 17625 264
2501583 2501583 2022-05-13 Wilson North Carolina 37195 21886 316
2501584 2501584 2022-05-13 Yadkin North Carolina 37197 11048 120
2501585 2501585 2022-05-13 Yancey North Carolina 37199 5353 57

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] desc);
Powered by Datasette · Queries took 657.647ms · Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette