ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
98 rows where "date" is on date 2020-05-01 and state = "North Carolina" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
fips >30
county >30
- Alamance 1
- Alexander 1
- Alleghany 1
- Anson 1
- Ashe 1
- Beaufort 1
- Bertie 1
- Bladen 1
- Brunswick 1
- Buncombe 1
- Burke 1
- Cabarrus 1
- Caldwell 1
- Camden 1
- Carteret 1
- Caswell 1
- Catawba 1
- Chatham 1
- Cherokee 1
- Chowan 1
- Clay 1
- Cleveland 1
- Columbus 1
- Craven 1
- Cumberland 1
- Currituck 1
- Dare 1
- Davidson 1
- Davie 1
- Duplin 1
- …
state 1
- North Carolina · 98 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
105591 | 105591 | 2020-05-01 | Alamance | North Carolina | 37001 | 106 | 1 |
105592 | 105592 | 2020-05-01 | Alexander | North Carolina | 37003 | 4 | 0 |
105593 | 105593 | 2020-05-01 | Alleghany | North Carolina | 37005 | 4 | 0 |
105594 | 105594 | 2020-05-01 | Anson | North Carolina | 37007 | 27 | 0 |
105595 | 105595 | 2020-05-01 | Ashe | North Carolina | 37009 | 5 | 0 |
105596 | 105596 | 2020-05-01 | Beaufort | North Carolina | 37013 | 22 | 0 |
105597 | 105597 | 2020-05-01 | Bertie | North Carolina | 37015 | 44 | 2 |
105598 | 105598 | 2020-05-01 | Bladen | North Carolina | 37017 | 25 | 0 |
105599 | 105599 | 2020-05-01 | Brunswick | North Carolina | 37019 | 43 | 3 |
105600 | 105600 | 2020-05-01 | Buncombe | North Carolina | 37021 | 65 | 4 |
105601 | 105601 | 2020-05-01 | Burke | North Carolina | 37023 | 106 | 8 |
105602 | 105602 | 2020-05-01 | Cabarrus | North Carolina | 37025 | 308 | 11 |
105603 | 105603 | 2020-05-01 | Caldwell | North Carolina | 37027 | 34 | 0 |
105604 | 105604 | 2020-05-01 | Camden | North Carolina | 37029 | 1 | 0 |
105605 | 105605 | 2020-05-01 | Carteret | North Carolina | 37031 | 29 | 3 |
105606 | 105606 | 2020-05-01 | Caswell | North Carolina | 37033 | 24 | 0 |
105607 | 105607 | 2020-05-01 | Catawba | North Carolina | 37035 | 54 | 1 |
105608 | 105608 | 2020-05-01 | Chatham | North Carolina | 37037 | 343 | 9 |
105609 | 105609 | 2020-05-01 | Cherokee | North Carolina | 37039 | 16 | 1 |
105610 | 105610 | 2020-05-01 | Chowan | North Carolina | 37041 | 6 | 0 |
105611 | 105611 | 2020-05-01 | Clay | North Carolina | 37043 | 5 | 0 |
105612 | 105612 | 2020-05-01 | Cleveland | North Carolina | 37045 | 47 | 2 |
105613 | 105613 | 2020-05-01 | Columbus | North Carolina | 37047 | 149 | 10 |
105614 | 105614 | 2020-05-01 | Craven | North Carolina | 37049 | 42 | 4 |
105615 | 105615 | 2020-05-01 | Cumberland | North Carolina | 37051 | 256 | 8 |
105616 | 105616 | 2020-05-01 | Currituck | North Carolina | 37053 | 4 | 0 |
105617 | 105617 | 2020-05-01 | Dare | North Carolina | 37055 | 11 | 1 |
105618 | 105618 | 2020-05-01 | Davidson | North Carolina | 37057 | 166 | 8 |
105619 | 105619 | 2020-05-01 | Davie | North Carolina | 37059 | 31 | 2 |
105620 | 105620 | 2020-05-01 | Duplin | North Carolina | 37061 | 103 | 0 |
105621 | 105621 | 2020-05-01 | Durham | North Carolina | 37063 | 736 | 21 |
105622 | 105622 | 2020-05-01 | Edgecombe | North Carolina | 37065 | 96 | 4 |
105623 | 105623 | 2020-05-01 | Forsyth | North Carolina | 37067 | 245 | 5 |
105624 | 105624 | 2020-05-01 | Franklin | North Carolina | 37069 | 104 | 19 |
105625 | 105625 | 2020-05-01 | Gaston | North Carolina | 37071 | 142 | 3 |
105626 | 105626 | 2020-05-01 | Gates | North Carolina | 37073 | 7 | 0 |
105627 | 105627 | 2020-05-01 | Graham | North Carolina | 37075 | 1 | 0 |
105628 | 105628 | 2020-05-01 | Granville | North Carolina | 37077 | 137 | 5 |
105629 | 105629 | 2020-05-01 | Greene | North Carolina | 37079 | 17 | 0 |
105630 | 105630 | 2020-05-01 | Guilford | North Carolina | 37081 | 415 | 30 |
105631 | 105631 | 2020-05-01 | Halifax | North Carolina | 37083 | 57 | 1 |
105632 | 105632 | 2020-05-01 | Harnett | North Carolina | 37085 | 164 | 7 |
105633 | 105633 | 2020-05-01 | Haywood | North Carolina | 37087 | 10 | 0 |
105634 | 105634 | 2020-05-01 | Henderson | North Carolina | 37089 | 195 | 21 |
105635 | 105635 | 2020-05-01 | Hertford | North Carolina | 37091 | 39 | 1 |
105636 | 105636 | 2020-05-01 | Hoke | North Carolina | 37093 | 82 | 0 |
105637 | 105637 | 2020-05-01 | Hyde | North Carolina | 37095 | 1 | 0 |
105638 | 105638 | 2020-05-01 | Iredell | North Carolina | 37097 | 112 | 5 |
105639 | 105639 | 2020-05-01 | Jackson | North Carolina | 37099 | 15 | 0 |
105640 | 105640 | 2020-05-01 | Johnston | North Carolina | 37101 | 159 | 12 |
105641 | 105641 | 2020-05-01 | Jones | North Carolina | 37103 | 15 | 2 |
105642 | 105642 | 2020-05-01 | Lee | North Carolina | 37105 | 169 | 0 |
105643 | 105643 | 2020-05-01 | Lenoir | North Carolina | 37107 | 68 | 4 |
105644 | 105644 | 2020-05-01 | Lincoln | North Carolina | 37109 | 27 | 0 |
105645 | 105645 | 2020-05-01 | Macon | North Carolina | 37113 | 3 | 1 |
105646 | 105646 | 2020-05-01 | Madison | North Carolina | 37115 | 1 | 0 |
105647 | 105647 | 2020-05-01 | Martin | North Carolina | 37117 | 16 | 0 |
105648 | 105648 | 2020-05-01 | McDowell | North Carolina | 37111 | 25 | 1 |
105649 | 105649 | 2020-05-01 | Mecklenburg | North Carolina | 37119 | 1651 | 49 |
105650 | 105650 | 2020-05-01 | Mitchell | North Carolina | 37121 | 5 | 0 |
105651 | 105651 | 2020-05-01 | Montgomery | North Carolina | 37123 | 35 | 2 |
105652 | 105652 | 2020-05-01 | Moore | North Carolina | 37125 | 79 | 3 |
105653 | 105653 | 2020-05-01 | Nash | North Carolina | 37127 | 97 | 3 |
105654 | 105654 | 2020-05-01 | New Hanover | North Carolina | 37129 | 75 | 3 |
105655 | 105655 | 2020-05-01 | Northampton | North Carolina | 37131 | 87 | 4 |
105656 | 105656 | 2020-05-01 | Onslow | North Carolina | 37133 | 46 | 1 |
105657 | 105657 | 2020-05-01 | Orange | North Carolina | 37135 | 219 | 17 |
105658 | 105658 | 2020-05-01 | Pamlico | North Carolina | 37137 | 7 | 0 |
105659 | 105659 | 2020-05-01 | Pasquotank | North Carolina | 37139 | 36 | 1 |
105660 | 105660 | 2020-05-01 | Pender | North Carolina | 37141 | 13 | 0 |
105661 | 105661 | 2020-05-01 | Perquimans | North Carolina | 37143 | 14 | 0 |
105662 | 105662 | 2020-05-01 | Person | North Carolina | 37145 | 21 | 1 |
105663 | 105663 | 2020-05-01 | Pitt | North Carolina | 37147 | 124 | 2 |
105664 | 105664 | 2020-05-01 | Polk | North Carolina | 37149 | 20 | 0 |
105665 | 105665 | 2020-05-01 | Randolph | North Carolina | 37151 | 209 | 3 |
105666 | 105666 | 2020-05-01 | Richmond | North Carolina | 37153 | 48 | 2 |
105667 | 105667 | 2020-05-01 | Robeson | North Carolina | 37155 | 175 | 3 |
105668 | 105668 | 2020-05-01 | Rockingham | North Carolina | 37157 | 26 | 2 |
105669 | 105669 | 2020-05-01 | Rowan | North Carolina | 37159 | 382 | 22 |
105670 | 105670 | 2020-05-01 | Rutherford | North Carolina | 37161 | 140 | 6 |
105671 | 105671 | 2020-05-01 | Sampson | North Carolina | 37163 | 65 | 0 |
105672 | 105672 | 2020-05-01 | Scotland | North Carolina | 37165 | 26 | 0 |
105673 | 105673 | 2020-05-01 | Stanly | North Carolina | 37167 | 29 | 4 |
105674 | 105674 | 2020-05-01 | Stokes | North Carolina | 37169 | 11 | 0 |
105675 | 105675 | 2020-05-01 | Surry | North Carolina | 37171 | 13 | 0 |
105676 | 105676 | 2020-05-01 | Swain | North Carolina | 37173 | 3 | 0 |
105677 | 105677 | 2020-05-01 | Transylvania | North Carolina | 37175 | 7 | 0 |
105678 | 105678 | 2020-05-01 | Tyrrell | North Carolina | 37177 | 4 | 0 |
105679 | 105679 | 2020-05-01 | Union | North Carolina | 37179 | 254 | 11 |
105680 | 105680 | 2020-05-01 | Vance | North Carolina | 37181 | 97 | 6 |
105681 | 105681 | 2020-05-01 | Wake | North Carolina | 37183 | 839 | 18 |
105682 | 105682 | 2020-05-01 | Warren | North Carolina | 37185 | 15 | 0 |
105683 | 105683 | 2020-05-01 | Washington | North Carolina | 37187 | 24 | 2 |
105684 | 105684 | 2020-05-01 | Watauga | North Carolina | 37189 | 9 | 0 |
105685 | 105685 | 2020-05-01 | Wayne | North Carolina | 37191 | 658 | 11 |
105686 | 105686 | 2020-05-01 | Wilkes | North Carolina | 37193 | 42 | 1 |
105687 | 105687 | 2020-05-01 | Wilson | North Carolina | 37195 | 162 | 7 |
105688 | 105688 | 2020-05-01 | Yadkin | North Carolina | 37197 | 17 | 1 |
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);