ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
94 rows where "date" is on date 2020-04-25 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
- 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
- Durham 1
- …
state 1
- North Carolina · 94 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
88553 | 88553 | 2020-04-25 | Alamance | North Carolina | 37001 | 77 | 1 |
88554 | 88554 | 2020-04-25 | Alexander | North Carolina | 37003 | 4 | 0 |
88555 | 88555 | 2020-04-25 | Alleghany | North Carolina | 37005 | 2 | 0 |
88556 | 88556 | 2020-04-25 | Anson | North Carolina | 37007 | 20 | 0 |
88557 | 88557 | 2020-04-25 | Ashe | North Carolina | 37009 | 4 | 0 |
88558 | 88558 | 2020-04-25 | Beaufort | North Carolina | 37013 | 20 | 0 |
88559 | 88559 | 2020-04-25 | Bertie | North Carolina | 37015 | 37 | 1 |
88560 | 88560 | 2020-04-25 | Bladen | North Carolina | 37017 | 7 | 0 |
88561 | 88561 | 2020-04-25 | Brunswick | North Carolina | 37019 | 39 | 3 |
88562 | 88562 | 2020-04-25 | Buncombe | North Carolina | 37021 | 50 | 3 |
88563 | 88563 | 2020-04-25 | Burke | North Carolina | 37023 | 86 | 8 |
88564 | 88564 | 2020-04-25 | Cabarrus | North Carolina | 37025 | 247 | 8 |
88565 | 88565 | 2020-04-25 | Caldwell | North Carolina | 37027 | 30 | 0 |
88566 | 88566 | 2020-04-25 | Carteret | North Carolina | 37031 | 26 | 3 |
88567 | 88567 | 2020-04-25 | Caswell | North Carolina | 37033 | 15 | 0 |
88568 | 88568 | 2020-04-25 | Catawba | North Carolina | 37035 | 47 | 1 |
88569 | 88569 | 2020-04-25 | Chatham | North Carolina | 37037 | 211 | 6 |
88570 | 88570 | 2020-04-25 | Cherokee | North Carolina | 37039 | 15 | 1 |
88571 | 88571 | 2020-04-25 | Chowan | North Carolina | 37041 | 7 | 0 |
88572 | 88572 | 2020-04-25 | Clay | North Carolina | 37043 | 5 | 0 |
88573 | 88573 | 2020-04-25 | Cleveland | North Carolina | 37045 | 46 | 2 |
88574 | 88574 | 2020-04-25 | Columbus | North Carolina | 37047 | 87 | 6 |
88575 | 88575 | 2020-04-25 | Craven | North Carolina | 37049 | 39 | 4 |
88576 | 88576 | 2020-04-25 | Cumberland | North Carolina | 37051 | 184 | 6 |
88577 | 88577 | 2020-04-25 | Currituck | North Carolina | 37053 | 2 | 0 |
88578 | 88578 | 2020-04-25 | Dare | North Carolina | 37055 | 11 | 1 |
88579 | 88579 | 2020-04-25 | Davidson | North Carolina | 37057 | 120 | 4 |
88580 | 88580 | 2020-04-25 | Davie | North Carolina | 37059 | 29 | 2 |
88581 | 88581 | 2020-04-25 | Duplin | North Carolina | 37061 | 61 | 0 |
88582 | 88582 | 2020-04-25 | Durham | North Carolina | 37063 | 517 | 9 |
88583 | 88583 | 2020-04-25 | Edgecombe | North Carolina | 37065 | 73 | 1 |
88584 | 88584 | 2020-04-25 | Forsyth | North Carolina | 37067 | 149 | 5 |
88585 | 88585 | 2020-04-25 | Franklin | North Carolina | 37069 | 92 | 14 |
88586 | 88586 | 2020-04-25 | Gaston | North Carolina | 37071 | 132 | 3 |
88587 | 88587 | 2020-04-25 | Gates | North Carolina | 37073 | 7 | 0 |
88588 | 88588 | 2020-04-25 | Granville | North Carolina | 37077 | 126 | 5 |
88589 | 88589 | 2020-04-25 | Greene | North Carolina | 37079 | 15 | 0 |
88590 | 88590 | 2020-04-25 | Guilford | North Carolina | 37081 | 293 | 19 |
88591 | 88591 | 2020-04-25 | Halifax | North Carolina | 37083 | 46 | 1 |
88592 | 88592 | 2020-04-25 | Harnett | North Carolina | 37085 | 119 | 5 |
88593 | 88593 | 2020-04-25 | Haywood | North Carolina | 37087 | 5 | 0 |
88594 | 88594 | 2020-04-25 | Henderson | North Carolina | 37089 | 152 | 14 |
88595 | 88595 | 2020-04-25 | Hertford | North Carolina | 37091 | 27 | 1 |
88596 | 88596 | 2020-04-25 | Hoke | North Carolina | 37093 | 46 | 0 |
88597 | 88597 | 2020-04-25 | Iredell | North Carolina | 37097 | 97 | 3 |
88598 | 88598 | 2020-04-25 | Jackson | North Carolina | 37099 | 4 | 0 |
88599 | 88599 | 2020-04-25 | Johnston | North Carolina | 37101 | 127 | 10 |
88600 | 88600 | 2020-04-25 | Jones | North Carolina | 37103 | 11 | 2 |
88601 | 88601 | 2020-04-25 | Lee | North Carolina | 37105 | 101 | 0 |
88602 | 88602 | 2020-04-25 | Lenoir | North Carolina | 37107 | 43 | 3 |
88603 | 88603 | 2020-04-25 | Lincoln | North Carolina | 37109 | 24 | 0 |
88604 | 88604 | 2020-04-25 | Macon | North Carolina | 37113 | 2 | 1 |
88605 | 88605 | 2020-04-25 | Madison | North Carolina | 37115 | 1 | 0 |
88606 | 88606 | 2020-04-25 | Martin | North Carolina | 37117 | 15 | 0 |
88607 | 88607 | 2020-04-25 | McDowell | North Carolina | 37111 | 21 | 1 |
88608 | 88608 | 2020-04-25 | Mecklenburg | North Carolina | 37119 | 1450 | 41 |
88609 | 88609 | 2020-04-25 | Mitchell | North Carolina | 37121 | 5 | 0 |
88610 | 88610 | 2020-04-25 | Montgomery | North Carolina | 37123 | 20 | 1 |
88611 | 88611 | 2020-04-25 | Moore | North Carolina | 37125 | 67 | 2 |
88612 | 88612 | 2020-04-25 | Nash | North Carolina | 37127 | 80 | 1 |
88613 | 88613 | 2020-04-25 | New Hanover | North Carolina | 37129 | 71 | 3 |
88614 | 88614 | 2020-04-25 | Northampton | North Carolina | 37131 | 80 | 3 |
88615 | 88615 | 2020-04-25 | Onslow | North Carolina | 37133 | 42 | 1 |
88616 | 88616 | 2020-04-25 | Orange | North Carolina | 37135 | 208 | 13 |
88617 | 88617 | 2020-04-25 | Pamlico | North Carolina | 37137 | 7 | 0 |
88618 | 88618 | 2020-04-25 | Pasquotank | North Carolina | 37139 | 34 | 1 |
88619 | 88619 | 2020-04-25 | Pender | North Carolina | 37141 | 10 | 0 |
88620 | 88620 | 2020-04-25 | Perquimans | North Carolina | 37143 | 10 | 0 |
88621 | 88621 | 2020-04-25 | Person | North Carolina | 37145 | 18 | 0 |
88622 | 88622 | 2020-04-25 | Pitt | North Carolina | 37147 | 111 | 2 |
88623 | 88623 | 2020-04-25 | Polk | North Carolina | 37149 | 12 | 0 |
88624 | 88624 | 2020-04-25 | Randolph | North Carolina | 37151 | 118 | 2 |
88625 | 88625 | 2020-04-25 | Richmond | North Carolina | 37153 | 36 | 2 |
88626 | 88626 | 2020-04-25 | Robeson | North Carolina | 37155 | 92 | 3 |
88627 | 88627 | 2020-04-25 | Rockingham | North Carolina | 37157 | 23 | 2 |
88628 | 88628 | 2020-04-25 | Rowan | North Carolina | 37159 | 342 | 20 |
88629 | 88629 | 2020-04-25 | Rutherford | North Carolina | 37161 | 108 | 6 |
88630 | 88630 | 2020-04-25 | Sampson | North Carolina | 37163 | 36 | 0 |
88631 | 88631 | 2020-04-25 | Scotland | North Carolina | 37165 | 21 | 0 |
88632 | 88632 | 2020-04-25 | Stanly | North Carolina | 37167 | 28 | 4 |
88633 | 88633 | 2020-04-25 | Stokes | North Carolina | 37169 | 11 | 0 |
88634 | 88634 | 2020-04-25 | Surry | North Carolina | 37171 | 12 | 0 |
88635 | 88635 | 2020-04-25 | Transylvania | North Carolina | 37175 | 7 | 0 |
88636 | 88636 | 2020-04-25 | Tyrrell | North Carolina | 37177 | 4 | 0 |
88637 | 88637 | 2020-04-25 | Union | North Carolina | 37179 | 195 | 7 |
88638 | 88638 | 2020-04-25 | Vance | North Carolina | 37181 | 41 | 2 |
88639 | 88639 | 2020-04-25 | Wake | North Carolina | 37183 | 645 | 13 |
88640 | 88640 | 2020-04-25 | Warren | North Carolina | 37185 | 4 | 0 |
88641 | 88641 | 2020-04-25 | Washington | North Carolina | 37187 | 24 | 2 |
88642 | 88642 | 2020-04-25 | Watauga | North Carolina | 37189 | 8 | 0 |
88643 | 88643 | 2020-04-25 | Wayne | North Carolina | 37191 | 618 | 8 |
88644 | 88644 | 2020-04-25 | Wilkes | North Carolina | 37193 | 18 | 1 |
88645 | 88645 | 2020-04-25 | Wilson | North Carolina | 37195 | 148 | 6 |
88646 | 88646 | 2020-04-25 | Yadkin | North Carolina | 37197 | 11 | 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);