ny_times_us_counties
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
This data as json, yaml, Notebook, copyable, CSV (advanced)
fips >30
- 37183 118
- 37037 115
- 37025 109
- 37067 109
- 37101 109
- 37119 109
- 37133 109
- 37191 108
- 37019 107
- 37049 107
- 37085 107
- 37189 106
- 37195 106
- 37063 105
- 37097 104
- 37163 104
- 37071 103
- 37081 103
- 37093 103
- 37109 103
- 37125 103
- 37129 103
- 37031 101
- 37057 101
- 37069 101
- 37135 101
- 37139 101
- 37147 101
- 37159 101
- 37167 101
- …
county >30
- Wake 118
- Chatham 115
- Cabarrus 109
- Forsyth 109
- Johnston 109
- Mecklenburg 109
- Onslow 109
- Wayne 108
- Brunswick 107
- Craven 107
- Harnett 107
- Watauga 106
- Wilson 106
- Durham 105
- Iredell 104
- Sampson 104
- Gaston 103
- Guilford 103
- Hoke 103
- Lincoln 103
- Moore 103
- New Hanover 103
- Carteret 101
- Davidson 101
- Franklin 101
- Orange 101
- Pasquotank 101
- Pitt 101
- Rowan 101
- Stanly 101
- …
state 1
- North Carolina · 9,408 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
282624 | 282624 | 2020-06-28 | Alamance | North Carolina | 37001 | 1088 | 37 |
282625 | 282625 | 2020-06-28 | Alexander | North Carolina | 37003 | 84 | 0 |
282626 | 282626 | 2020-06-28 | Alleghany | North Carolina | 37005 | 31 | 0 |
282627 | 282627 | 2020-06-28 | Anson | North Carolina | 37007 | 125 | 1 |
282628 | 282628 | 2020-06-28 | Ashe | North Carolina | 37009 | 52 | 1 |
282629 | 282629 | 2020-06-28 | Avery | North Carolina | 37011 | 9 | 0 |
282630 | 282630 | 2020-06-28 | Beaufort | North Carolina | 37013 | 77 | 0 |
282631 | 282631 | 2020-06-28 | Bertie | North Carolina | 37015 | 141 | 4 |
282632 | 282632 | 2020-06-28 | Bladen | North Carolina | 37017 | 357 | 3 |
282633 | 282633 | 2020-06-28 | Brunswick | North Carolina | 37019 | 482 | 6 |
282634 | 282634 | 2020-06-28 | Buncombe | North Carolina | 37021 | 547 | 36 |
282635 | 282635 | 2020-06-28 | Burke | North Carolina | 37023 | 1016 | 20 |
282636 | 282636 | 2020-06-28 | Cabarrus | North Carolina | 37025 | 1064 | 27 |
282637 | 282637 | 2020-06-28 | Caldwell | North Carolina | 37027 | 398 | 4 |
282638 | 282638 | 2020-06-28 | Camden | North Carolina | 37029 | 24 | 0 |
282639 | 282639 | 2020-06-28 | Carteret | North Carolina | 37031 | 76 | 3 |
282640 | 282640 | 2020-06-28 | Caswell | North Carolina | 37033 | 135 | 1 |
282641 | 282641 | 2020-06-28 | Catawba | North Carolina | 37035 | 720 | 10 |
282642 | 282642 | 2020-06-28 | Chatham | North Carolina | 37037 | 936 | 42 |
282643 | 282643 | 2020-06-28 | Cherokee | North Carolina | 37039 | 33 | 1 |
282644 | 282644 | 2020-06-28 | Chowan | North Carolina | 37041 | 24 | 0 |
282645 | 282645 | 2020-06-28 | Clay | North Carolina | 37043 | 9 | 0 |
282646 | 282646 | 2020-06-28 | Cleveland | North Carolina | 37045 | 277 | 3 |
282647 | 282647 | 2020-06-28 | Columbus | North Carolina | 37047 | 513 | 37 |
282648 | 282648 | 2020-06-28 | Craven | North Carolina | 37049 | 354 | 6 |
282649 | 282649 | 2020-06-28 | Cumberland | North Carolina | 37051 | 1142 | 41 |
282650 | 282650 | 2020-06-28 | Currituck | North Carolina | 37053 | 18 | 0 |
282651 | 282651 | 2020-06-28 | Dare | North Carolina | 37055 | 43 | 1 |
282652 | 282652 | 2020-06-28 | Davidson | North Carolina | 37057 | 925 | 15 |
282653 | 282653 | 2020-06-28 | Davie | North Carolina | 37059 | 188 | 3 |
282654 | 282654 | 2020-06-28 | Duplin | North Carolina | 37061 | 1438 | 27 |
282655 | 282655 | 2020-06-28 | Durham | North Carolina | 37063 | 3571 | 63 |
282656 | 282656 | 2020-06-28 | Edgecombe | North Carolina | 37065 | 309 | 9 |
282657 | 282657 | 2020-06-28 | Forsyth | North Carolina | 37067 | 2935 | 34 |
282658 | 282658 | 2020-06-28 | Franklin | North Carolina | 37069 | 332 | 21 |
282659 | 282659 | 2020-06-28 | Gaston | North Carolina | 37071 | 1004 | 11 |
282660 | 282660 | 2020-06-28 | Gates | North Carolina | 37073 | 27 | 2 |
282661 | 282661 | 2020-06-28 | Graham | North Carolina | 37075 | 9 | 0 |
282662 | 282662 | 2020-06-28 | Granville | North Carolina | 37077 | 786 | 19 |
282663 | 282663 | 2020-06-28 | Greene | North Carolina | 37079 | 174 | 2 |
282664 | 282664 | 2020-06-28 | Guilford | North Carolina | 37081 | 2743 | 112 |
282665 | 282665 | 2020-06-28 | Halifax | North Carolina | 37083 | 298 | 4 |
282666 | 282666 | 2020-06-28 | Harnett | North Carolina | 37085 | 615 | 30 |
282667 | 282667 | 2020-06-28 | Haywood | North Carolina | 37087 | 88 | 0 |
282668 | 282668 | 2020-06-28 | Henderson | North Carolina | 37089 | 569 | 50 |
282669 | 282669 | 2020-06-28 | Hertford | North Carolina | 37091 | 160 | 10 |
282670 | 282670 | 2020-06-28 | Hoke | North Carolina | 37093 | 357 | 3 |
282671 | 282671 | 2020-06-28 | Hyde | North Carolina | 37095 | 10 | 0 |
282672 | 282672 | 2020-06-28 | Iredell | North Carolina | 37097 | 731 | 7 |
282673 | 282673 | 2020-06-28 | Jackson | North Carolina | 37099 | 96 | 1 |
282674 | 282674 | 2020-06-28 | Johnston | North Carolina | 37101 | 1393 | 29 |
282675 | 282675 | 2020-06-28 | Jones | North Carolina | 37103 | 35 | 3 |
282676 | 282676 | 2020-06-28 | Lee | North Carolina | 37105 | 798 | 8 |
282677 | 282677 | 2020-06-28 | Lenoir | North Carolina | 37107 | 363 | 10 |
282678 | 282678 | 2020-06-28 | Lincoln | North Carolina | 37109 | 240 | 1 |
282679 | 282679 | 2020-06-28 | Macon | North Carolina | 37113 | 277 | 1 |
282680 | 282680 | 2020-06-28 | Madison | North Carolina | 37115 | 12 | 0 |
282681 | 282681 | 2020-06-28 | Martin | North Carolina | 37117 | 120 | 4 |
282682 | 282682 | 2020-06-28 | McDowell | North Carolina | 37111 | 222 | 1 |
282683 | 282683 | 2020-06-28 | Mecklenburg | North Carolina | 37119 | 10592 | 149 |
282684 | 282684 | 2020-06-28 | Mitchell | North Carolina | 37121 | 29 | 0 |
282685 | 282685 | 2020-06-28 | Montgomery | North Carolina | 37123 | 298 | 7 |
282686 | 282686 | 2020-06-28 | Moore | North Carolina | 37125 | 439 | 13 |
282687 | 282687 | 2020-06-28 | Nash | North Carolina | 37127 | 437 | 4 |
282688 | 282688 | 2020-06-28 | New Hanover | North Carolina | 37129 | 810 | 5 |
282689 | 282689 | 2020-06-28 | Northampton | North Carolina | 37131 | 180 | 15 |
282690 | 282690 | 2020-06-28 | Onslow | North Carolina | 37133 | 258 | 3 |
282691 | 282691 | 2020-06-28 | Orange | North Carolina | 37135 | 635 | 41 |
282692 | 282692 | 2020-06-28 | Pamlico | North Carolina | 37137 | 19 | 0 |
282693 | 282693 | 2020-06-28 | Pasquotank | North Carolina | 37139 | 204 | 15 |
282694 | 282694 | 2020-06-28 | Pender | North Carolina | 37141 | 235 | 1 |
282695 | 282695 | 2020-06-28 | Perquimans | North Carolina | 37143 | 36 | 2 |
282696 | 282696 | 2020-06-28 | Person | North Carolina | 37145 | 104 | 1 |
282697 | 282697 | 2020-06-28 | Pitt | North Carolina | 37147 | 660 | 6 |
282698 | 282698 | 2020-06-28 | Polk | North Carolina | 37149 | 72 | 4 |
282699 | 282699 | 2020-06-28 | Randolph | North Carolina | 37151 | 1149 | 29 |
282700 | 282700 | 2020-06-28 | Richmond | North Carolina | 37153 | 273 | 5 |
282701 | 282701 | 2020-06-28 | Robeson | North Carolina | 37155 | 1185 | 38 |
282702 | 282702 | 2020-06-28 | Rockingham | North Carolina | 37157 | 218 | 2 |
282703 | 282703 | 2020-06-28 | Rowan | North Carolina | 37159 | 1163 | 42 |
282704 | 282704 | 2020-06-28 | Rutherford | North Carolina | 37161 | 281 | 9 |
282705 | 282705 | 2020-06-28 | Sampson | North Carolina | 37163 | 1018 | 6 |
282706 | 282706 | 2020-06-28 | Scotland | North Carolina | 37165 | 134 | 0 |
282707 | 282707 | 2020-06-28 | Stanly | North Carolina | 37167 | 359 | 5 |
282708 | 282708 | 2020-06-28 | Stokes | North Carolina | 37169 | 125 | 1 |
282709 | 282709 | 2020-06-28 | Surry | North Carolina | 37171 | 451 | 2 |
282710 | 282710 | 2020-06-28 | Swain | North Carolina | 37173 | 51 | 0 |
282711 | 282711 | 2020-06-28 | Transylvania | North Carolina | 37175 | 21 | 1 |
282712 | 282712 | 2020-06-28 | Tyrrell | North Carolina | 37177 | 8 | 0 |
282713 | 282713 | 2020-06-28 | Union | North Carolina | 37179 | 1151 | 24 |
282714 | 282714 | 2020-06-28 | Vance | North Carolina | 37181 | 499 | 36 |
282715 | 282715 | 2020-06-28 | Wake | North Carolina | 37183 | 4838 | 47 |
282716 | 282716 | 2020-06-28 | Warren | North Carolina | 37185 | 159 | 5 |
282717 | 282717 | 2020-06-28 | Washington | North Carolina | 37187 | 38 | 3 |
282718 | 282718 | 2020-06-28 | Watauga | North Carolina | 37189 | 65 | 0 |
282719 | 282719 | 2020-06-28 | Wayne | North Carolina | 37191 | 1767 | 25 |
282720 | 282720 | 2020-06-28 | Wilkes | North Carolina | 37193 | 570 | 6 |
282721 | 282721 | 2020-06-28 | Wilson | North Carolina | 37195 | 682 | 18 |
282722 | 282722 | 2020-06-28 | Yadkin | North Carolina | 37197 | 322 | 4 |
282723 | 282723 | 2020-06-28 | Yancey | North Carolina | 37199 | 43 | 0 |
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);