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 130
- 37037 127
- 37025 121
- 37067 121
- 37101 121
- 37119 121
- 37133 121
- 37191 120
- 37019 119
- 37049 119
- 37085 119
- 37189 118
- 37195 118
- 37063 117
- 37097 116
- 37163 116
- 37071 115
- 37081 115
- 37093 115
- 37109 115
- 37125 115
- 37129 115
- 37031 113
- 37057 113
- 37069 113
- 37135 113
- 37139 113
- 37147 113
- 37159 113
- 37167 113
- …
county >30
- Wake 130
- Chatham 127
- Cabarrus 121
- Forsyth 121
- Johnston 121
- Mecklenburg 121
- Onslow 121
- Wayne 120
- Brunswick 119
- Craven 119
- Harnett 119
- Watauga 118
- Wilson 118
- Durham 117
- Iredell 116
- Sampson 116
- Gaston 115
- Guilford 115
- Hoke 115
- Lincoln 115
- Moore 115
- New Hanover 115
- Carteret 113
- Davidson 113
- Franklin 113
- Orange 113
- Pasquotank 113
- Pitt 113
- Rowan 113
- Stanly 113
- …
state 1
- North Carolina · 10,608 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
320569 | 320569 | 2020-07-10 | Alamance | North Carolina | 37001 | 1388 | 37 |
320570 | 320570 | 2020-07-10 | Alexander | North Carolina | 37003 | 149 | 1 |
320571 | 320571 | 2020-07-10 | Alleghany | North Carolina | 37005 | 41 | 0 |
320572 | 320572 | 2020-07-10 | Anson | North Carolina | 37007 | 182 | 1 |
320573 | 320573 | 2020-07-10 | Ashe | North Carolina | 37009 | 63 | 1 |
320574 | 320574 | 2020-07-10 | Avery | North Carolina | 37011 | 23 | 0 |
320575 | 320575 | 2020-07-10 | Beaufort | North Carolina | 37013 | 134 | 0 |
320576 | 320576 | 2020-07-10 | Bertie | North Carolina | 37015 | 155 | 4 |
320577 | 320577 | 2020-07-10 | Bladen | North Carolina | 37017 | 424 | 5 |
320578 | 320578 | 2020-07-10 | Brunswick | North Carolina | 37019 | 765 | 10 |
320579 | 320579 | 2020-07-10 | Buncombe | North Carolina | 37021 | 802 | 40 |
320580 | 320580 | 2020-07-10 | Burke | North Carolina | 37023 | 1161 | 20 |
320581 | 320581 | 2020-07-10 | Cabarrus | North Carolina | 37025 | 1521 | 33 |
320582 | 320582 | 2020-07-10 | Caldwell | North Carolina | 37027 | 580 | 5 |
320583 | 320583 | 2020-07-10 | Camden | North Carolina | 37029 | 34 | 1 |
320584 | 320584 | 2020-07-10 | Carteret | North Carolina | 37031 | 117 | 3 |
320585 | 320585 | 2020-07-10 | Caswell | North Carolina | 37033 | 149 | 2 |
320586 | 320586 | 2020-07-10 | Catawba | North Carolina | 37035 | 1105 | 13 |
320587 | 320587 | 2020-07-10 | Chatham | North Carolina | 37037 | 1035 | 44 |
320588 | 320588 | 2020-07-10 | Cherokee | North Carolina | 37039 | 58 | 2 |
320589 | 320589 | 2020-07-10 | Chowan | North Carolina | 37041 | 34 | 0 |
320590 | 320590 | 2020-07-10 | Clay | North Carolina | 37043 | 11 | 0 |
320591 | 320591 | 2020-07-10 | Cleveland | North Carolina | 37045 | 463 | 8 |
320592 | 320592 | 2020-07-10 | Columbus | North Carolina | 37047 | 602 | 39 |
320593 | 320593 | 2020-07-10 | Craven | North Carolina | 37049 | 427 | 8 |
320594 | 320594 | 2020-07-10 | Cumberland | North Carolina | 37051 | 1521 | 41 |
320595 | 320595 | 2020-07-10 | Currituck | North Carolina | 37053 | 23 | 0 |
320596 | 320596 | 2020-07-10 | Dare | North Carolina | 37055 | 97 | 1 |
320597 | 320597 | 2020-07-10 | Davidson | North Carolina | 37057 | 1210 | 15 |
320598 | 320598 | 2020-07-10 | Davie | North Carolina | 37059 | 241 | 3 |
320599 | 320599 | 2020-07-10 | Duplin | North Carolina | 37061 | 1646 | 32 |
320600 | 320600 | 2020-07-10 | Durham | North Carolina | 37063 | 4421 | 68 |
320601 | 320601 | 2020-07-10 | Edgecombe | North Carolina | 37065 | 370 | 9 |
320602 | 320602 | 2020-07-10 | Forsyth | North Carolina | 37067 | 3580 | 39 |
320603 | 320603 | 2020-07-10 | Franklin | North Carolina | 37069 | 441 | 21 |
320604 | 320604 | 2020-07-10 | Gaston | North Carolina | 37071 | 1640 | 15 |
320605 | 320605 | 2020-07-10 | Gates | North Carolina | 37073 | 29 | 2 |
320606 | 320606 | 2020-07-10 | Graham | North Carolina | 37075 | 10 | 0 |
320607 | 320607 | 2020-07-10 | Granville | North Carolina | 37077 | 884 | 23 |
320608 | 320608 | 2020-07-10 | Greene | North Carolina | 37079 | 200 | 3 |
320609 | 320609 | 2020-07-10 | Guilford | North Carolina | 37081 | 3440 | 123 |
320610 | 320610 | 2020-07-10 | Halifax | North Carolina | 37083 | 361 | 4 |
320611 | 320611 | 2020-07-10 | Harnett | North Carolina | 37085 | 757 | 31 |
320612 | 320612 | 2020-07-10 | Haywood | North Carolina | 37087 | 117 | 0 |
320613 | 320613 | 2020-07-10 | Henderson | North Carolina | 37089 | 883 | 51 |
320614 | 320614 | 2020-07-10 | Hertford | North Carolina | 37091 | 178 | 10 |
320615 | 320615 | 2020-07-10 | Hoke | North Carolina | 37093 | 444 | 5 |
320616 | 320616 | 2020-07-10 | Hyde | North Carolina | 37095 | 28 | 0 |
320617 | 320617 | 2020-07-10 | Iredell | North Carolina | 37097 | 1031 | 10 |
320618 | 320618 | 2020-07-10 | Jackson | North Carolina | 37099 | 164 | 1 |
320619 | 320619 | 2020-07-10 | Johnston | North Carolina | 37101 | 1934 | 35 |
320620 | 320620 | 2020-07-10 | Jones | North Carolina | 37103 | 37 | 3 |
320621 | 320621 | 2020-07-10 | Lee | North Carolina | 37105 | 909 | 8 |
320622 | 320622 | 2020-07-10 | Lenoir | North Carolina | 37107 | 416 | 11 |
320623 | 320623 | 2020-07-10 | Lincoln | North Carolina | 37109 | 360 | 2 |
320624 | 320624 | 2020-07-10 | Macon | North Carolina | 37113 | 322 | 1 |
320625 | 320625 | 2020-07-10 | Madison | North Carolina | 37115 | 15 | 0 |
320626 | 320626 | 2020-07-10 | Martin | North Carolina | 37117 | 163 | 5 |
320627 | 320627 | 2020-07-10 | McDowell | North Carolina | 37111 | 310 | 2 |
320628 | 320628 | 2020-07-10 | Mecklenburg | North Carolina | 37119 | 14157 | 163 |
320629 | 320629 | 2020-07-10 | Mitchell | North Carolina | 37121 | 55 | 0 |
320630 | 320630 | 2020-07-10 | Montgomery | North Carolina | 37123 | 376 | 9 |
320631 | 320631 | 2020-07-10 | Moore | North Carolina | 37125 | 599 | 14 |
320632 | 320632 | 2020-07-10 | Nash | North Carolina | 37127 | 591 | 6 |
320633 | 320633 | 2020-07-10 | New Hanover | North Carolina | 37129 | 1342 | 7 |
320634 | 320634 | 2020-07-10 | Northampton | North Carolina | 37131 | 192 | 16 |
320635 | 320635 | 2020-07-10 | Onslow | North Carolina | 37133 | 382 | 3 |
320636 | 320636 | 2020-07-10 | Orange | North Carolina | 37135 | 910 | 42 |
320637 | 320637 | 2020-07-10 | Pamlico | North Carolina | 37137 | 28 | 0 |
320638 | 320638 | 2020-07-10 | Pasquotank | North Carolina | 37139 | 234 | 17 |
320639 | 320639 | 2020-07-10 | Pender | North Carolina | 37141 | 338 | 2 |
320640 | 320640 | 2020-07-10 | Perquimans | North Carolina | 37143 | 39 | 2 |
320641 | 320641 | 2020-07-10 | Person | North Carolina | 37145 | 127 | 1 |
320642 | 320642 | 2020-07-10 | Pitt | North Carolina | 37147 | 890 | 6 |
320643 | 320643 | 2020-07-10 | Polk | North Carolina | 37149 | 93 | 4 |
320644 | 320644 | 2020-07-10 | Randolph | North Carolina | 37151 | 1405 | 32 |
320645 | 320645 | 2020-07-10 | Richmond | North Carolina | 37153 | 350 | 7 |
320646 | 320646 | 2020-07-10 | Robeson | North Carolina | 37155 | 1582 | 44 |
320647 | 320647 | 2020-07-10 | Rockingham | North Carolina | 37157 | 289 | 2 |
320648 | 320648 | 2020-07-10 | Rowan | North Carolina | 37159 | 1475 | 45 |
320649 | 320649 | 2020-07-10 | Rutherford | North Carolina | 37161 | 391 | 11 |
320650 | 320650 | 2020-07-10 | Sampson | North Carolina | 37163 | 1170 | 7 |
320651 | 320651 | 2020-07-10 | Scotland | North Carolina | 37165 | 163 | 2 |
320652 | 320652 | 2020-07-10 | Stanly | North Carolina | 37167 | 539 | 5 |
320653 | 320653 | 2020-07-10 | Stokes | North Carolina | 37169 | 162 | 1 |
320654 | 320654 | 2020-07-10 | Surry | North Carolina | 37171 | 565 | 2 |
320655 | 320655 | 2020-07-10 | Swain | North Carolina | 37173 | 71 | 1 |
320656 | 320656 | 2020-07-10 | Transylvania | North Carolina | 37175 | 41 | 1 |
320657 | 320657 | 2020-07-10 | Tyrrell | North Carolina | 37177 | 34 | 1 |
320658 | 320658 | 2020-07-10 | Union | North Carolina | 37179 | 1712 | 25 |
320659 | 320659 | 2020-07-10 | Vance | North Carolina | 37181 | 555 | 40 |
320660 | 320660 | 2020-07-10 | Wake | North Carolina | 37183 | 7065 | 61 |
320661 | 320661 | 2020-07-10 | Warren | North Carolina | 37185 | 181 | 6 |
320662 | 320662 | 2020-07-10 | Washington | North Carolina | 37187 | 42 | 3 |
320663 | 320663 | 2020-07-10 | Watauga | North Carolina | 37189 | 116 | 0 |
320664 | 320664 | 2020-07-10 | Wayne | North Carolina | 37191 | 1964 | 30 |
320665 | 320665 | 2020-07-10 | Wilkes | North Carolina | 37193 | 608 | 6 |
320666 | 320666 | 2020-07-10 | Wilson | North Carolina | 37195 | 870 | 23 |
320667 | 320667 | 2020-07-10 | Yadkin | North Carolina | 37197 | 376 | 5 |
320668 | 320668 | 2020-07-10 | Yancey | North Carolina | 37199 | 53 | 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);