ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
1,819 rows where deaths = 2 and state = "North Carolina" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
fips >30
county >30
- Perquimans 130
- Rockingham 100
- Davie 80
- Macon 75
- Gates 74
- Pamlico 71
- Cleveland 64
- Caswell 61
- Pitt 55
- Dare 51
- Surry 45
- Richmond 44
- Greene 43
- Bladen 42
- Scotland 42
- Tyrrell 42
- Alexander 41
- Onslow 40
- Camden 39
- Yancey 37
- Jones 35
- Swain 34
- Alleghany 31
- Chowan 29
- Person 28
- Cherokee 22
- Clay 22
- Lincoln 22
- Warren 21
- Beaufort 20
- …
state 1
- North Carolina · 1,819 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
906118 | 906118 | 2021-01-07 | Alleghany | North Carolina | 37005 | 711 | 2 |
902872 | 902872 | 2021-01-06 | Alleghany | North Carolina | 37005 | 693 | 2 |
899627 | 899627 | 2021-01-05 | Alleghany | North Carolina | 37005 | 681 | 2 |
896382 | 896382 | 2021-01-04 | Alleghany | North Carolina | 37005 | 675 | 2 |
893136 | 893136 | 2021-01-03 | Alleghany | North Carolina | 37005 | 674 | 2 |
889890 | 889890 | 2021-01-02 | Alleghany | North Carolina | 37005 | 670 | 2 |
886643 | 886643 | 2021-01-01 | Alleghany | North Carolina | 37005 | 638 | 2 |
883398 | 883398 | 2020-12-31 | Alleghany | North Carolina | 37005 | 638 | 2 |
880153 | 880153 | 2020-12-30 | Alleghany | North Carolina | 37005 | 633 | 2 |
876908 | 876908 | 2020-12-29 | Alleghany | North Carolina | 37005 | 619 | 2 |
873663 | 873663 | 2020-12-28 | Alleghany | North Carolina | 37005 | 611 | 2 |
870418 | 870418 | 2020-12-27 | Alleghany | North Carolina | 37005 | 611 | 2 |
867173 | 867173 | 2020-12-26 | Alleghany | North Carolina | 37005 | 603 | 2 |
863928 | 863928 | 2020-12-25 | Alleghany | North Carolina | 37005 | 559 | 2 |
860683 | 860683 | 2020-12-24 | Alleghany | North Carolina | 37005 | 559 | 2 |
857438 | 857438 | 2020-12-23 | Alleghany | North Carolina | 37005 | 559 | 2 |
854193 | 854193 | 2020-12-22 | Alleghany | North Carolina | 37005 | 551 | 2 |
850948 | 850948 | 2020-12-21 | Alleghany | North Carolina | 37005 | 538 | 2 |
847703 | 847703 | 2020-12-20 | Alleghany | North Carolina | 37005 | 537 | 2 |
844458 | 844458 | 2020-12-19 | Alleghany | North Carolina | 37005 | 533 | 2 |
841212 | 841212 | 2020-12-18 | Alleghany | North Carolina | 37005 | 529 | 2 |
837967 | 837967 | 2020-12-17 | Alleghany | North Carolina | 37005 | 519 | 2 |
834721 | 834721 | 2020-12-16 | Alleghany | North Carolina | 37005 | 515 | 2 |
812095 | 812095 | 2020-12-09 | Yancey | North Carolina | 37199 | 697 | 2 |
808850 | 808850 | 2020-12-08 | Yancey | North Carolina | 37199 | 671 | 2 |
805605 | 805605 | 2020-12-07 | Yancey | North Carolina | 37199 | 661 | 2 |
802360 | 802360 | 2020-12-06 | Yancey | North Carolina | 37199 | 659 | 2 |
799115 | 799115 | 2020-12-05 | Yancey | North Carolina | 37199 | 624 | 2 |
795870 | 795870 | 2020-12-04 | Yancey | North Carolina | 37199 | 593 | 2 |
792625 | 792625 | 2020-12-03 | Yancey | North Carolina | 37199 | 581 | 2 |
789380 | 789380 | 2020-12-02 | Yancey | North Carolina | 37199 | 572 | 2 |
786135 | 786135 | 2020-12-01 | Yancey | North Carolina | 37199 | 568 | 2 |
782891 | 782891 | 2020-11-30 | Yancey | North Carolina | 37199 | 561 | 2 |
779645 | 779645 | 2020-11-29 | Yancey | North Carolina | 37199 | 557 | 2 |
776400 | 776400 | 2020-11-28 | Yancey | North Carolina | 37199 | 550 | 2 |
773155 | 773155 | 2020-11-27 | Yancey | North Carolina | 37199 | 549 | 2 |
769910 | 769910 | 2020-11-26 | Yancey | North Carolina | 37199 | 520 | 2 |
766664 | 766664 | 2020-11-25 | Yancey | North Carolina | 37199 | 520 | 2 |
763419 | 763419 | 2020-11-24 | Yancey | North Carolina | 37199 | 506 | 2 |
760174 | 760174 | 2020-11-23 | Yancey | North Carolina | 37199 | 499 | 2 |
756928 | 756928 | 2020-11-22 | Yancey | North Carolina | 37199 | 497 | 2 |
753681 | 753681 | 2020-11-21 | Yancey | North Carolina | 37199 | 487 | 2 |
750435 | 750435 | 2020-11-20 | Yancey | North Carolina | 37199 | 476 | 2 |
747189 | 747189 | 2020-11-19 | Yancey | North Carolina | 37199 | 460 | 2 |
743943 | 743943 | 2020-11-18 | Yancey | North Carolina | 37199 | 450 | 2 |
740696 | 740696 | 2020-11-17 | Yancey | North Carolina | 37199 | 427 | 2 |
737357 | 737357 | 2020-11-16 | Avery | North Carolina | 37011 | 733 | 2 |
737451 | 737451 | 2020-11-16 | Yancey | North Carolina | 37199 | 421 | 2 |
734113 | 734113 | 2020-11-15 | Avery | North Carolina | 37011 | 724 | 2 |
734207 | 734207 | 2020-11-15 | Yancey | North Carolina | 37199 | 421 | 2 |
730867 | 730867 | 2020-11-14 | Avery | North Carolina | 37011 | 717 | 2 |
730961 | 730961 | 2020-11-14 | Yancey | North Carolina | 37199 | 417 | 2 |
727623 | 727623 | 2020-11-13 | Avery | North Carolina | 37011 | 714 | 2 |
727717 | 727717 | 2020-11-13 | Yancey | North Carolina | 37199 | 411 | 2 |
724379 | 724379 | 2020-11-12 | Avery | North Carolina | 37011 | 713 | 2 |
724473 | 724473 | 2020-11-12 | Yancey | North Carolina | 37199 | 411 | 2 |
721136 | 721136 | 2020-11-11 | Avery | North Carolina | 37011 | 703 | 2 |
721230 | 721230 | 2020-11-11 | Yancey | North Carolina | 37199 | 407 | 2 |
717893 | 717893 | 2020-11-10 | Avery | North Carolina | 37011 | 701 | 2 |
717987 | 717987 | 2020-11-10 | Yancey | North Carolina | 37199 | 403 | 2 |
714650 | 714650 | 2020-11-09 | Avery | North Carolina | 37011 | 692 | 2 |
714744 | 714744 | 2020-11-09 | Yancey | North Carolina | 37199 | 392 | 2 |
711406 | 711406 | 2020-11-08 | Avery | North Carolina | 37011 | 692 | 2 |
711500 | 711500 | 2020-11-08 | Yancey | North Carolina | 37199 | 387 | 2 |
708162 | 708162 | 2020-11-07 | Avery | North Carolina | 37011 | 680 | 2 |
708256 | 708256 | 2020-11-07 | Yancey | North Carolina | 37199 | 384 | 2 |
704919 | 704919 | 2020-11-06 | Avery | North Carolina | 37011 | 678 | 2 |
705013 | 705013 | 2020-11-06 | Yancey | North Carolina | 37199 | 374 | 2 |
701676 | 701676 | 2020-11-05 | Avery | North Carolina | 37011 | 673 | 2 |
701770 | 701770 | 2020-11-05 | Yancey | North Carolina | 37199 | 365 | 2 |
698432 | 698432 | 2020-11-04 | Avery | North Carolina | 37011 | 668 | 2 |
698526 | 698526 | 2020-11-04 | Yancey | North Carolina | 37199 | 349 | 2 |
695189 | 695189 | 2020-11-03 | Avery | North Carolina | 37011 | 666 | 2 |
695283 | 695283 | 2020-11-03 | Yancey | North Carolina | 37199 | 347 | 2 |
678969 | 678969 | 2020-10-29 | Alleghany | North Carolina | 37005 | 304 | 2 |
675726 | 675726 | 2020-10-28 | Alleghany | North Carolina | 37005 | 297 | 2 |
675792 | 675792 | 2020-10-28 | Pamlico | North Carolina | 37137 | 318 | 2 |
672483 | 672483 | 2020-10-27 | Alleghany | North Carolina | 37005 | 296 | 2 |
672549 | 672549 | 2020-10-27 | Pamlico | North Carolina | 37137 | 315 | 2 |
669241 | 669241 | 2020-10-26 | Alleghany | North Carolina | 37005 | 294 | 2 |
669307 | 669307 | 2020-10-26 | Pamlico | North Carolina | 37137 | 312 | 2 |
665997 | 665997 | 2020-10-25 | Alleghany | North Carolina | 37005 | 289 | 2 |
666063 | 666063 | 2020-10-25 | Pamlico | North Carolina | 37137 | 310 | 2 |
662752 | 662752 | 2020-10-24 | Alleghany | North Carolina | 37005 | 289 | 2 |
662818 | 662818 | 2020-10-24 | Pamlico | North Carolina | 37137 | 312 | 2 |
659508 | 659508 | 2020-10-23 | Alleghany | North Carolina | 37005 | 286 | 2 |
659574 | 659574 | 2020-10-23 | Pamlico | North Carolina | 37137 | 307 | 2 |
656264 | 656264 | 2020-10-22 | Alleghany | North Carolina | 37005 | 275 | 2 |
656330 | 656330 | 2020-10-22 | Pamlico | North Carolina | 37137 | 304 | 2 |
653085 | 653085 | 2020-10-21 | Pamlico | North Carolina | 37137 | 302 | 2 |
653111 | 653111 | 2020-10-21 | Watauga | North Carolina | 37189 | 1331 | 2 |
649840 | 649840 | 2020-10-20 | Pamlico | North Carolina | 37137 | 301 | 2 |
649866 | 649866 | 2020-10-20 | Watauga | North Carolina | 37189 | 1316 | 2 |
646596 | 646596 | 2020-10-19 | Pamlico | North Carolina | 37137 | 300 | 2 |
646622 | 646622 | 2020-10-19 | Watauga | North Carolina | 37189 | 1306 | 2 |
643350 | 643350 | 2020-10-18 | Pamlico | North Carolina | 37137 | 300 | 2 |
643376 | 643376 | 2020-10-18 | Watauga | North Carolina | 37189 | 1302 | 2 |
640102 | 640102 | 2020-10-17 | Pamlico | North Carolina | 37137 | 298 | 2 |
640128 | 640128 | 2020-10-17 | Watauga | North Carolina | 37189 | 1288 | 2 |
636856 | 636856 | 2020-10-16 | Pamlico | North Carolina | 37137 | 298 | 2 |
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);