ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
93 rows where "date" is on date 2020-04-20 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 · 93 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
74568 | 74568 | 2020-04-20 | Alamance | North Carolina | 37001 | 49 | 0 |
74569 | 74569 | 2020-04-20 | Alexander | North Carolina | 37003 | 3 | 0 |
74570 | 74570 | 2020-04-20 | Alleghany | North Carolina | 37005 | 2 | 0 |
74571 | 74571 | 2020-04-20 | Anson | North Carolina | 37007 | 18 | 0 |
74572 | 74572 | 2020-04-20 | Ashe | North Carolina | 37009 | 4 | 0 |
74573 | 74573 | 2020-04-20 | Beaufort | North Carolina | 37013 | 14 | 0 |
74574 | 74574 | 2020-04-20 | Bertie | North Carolina | 37015 | 24 | 1 |
74575 | 74575 | 2020-04-20 | Bladen | North Carolina | 37017 | 2 | 0 |
74576 | 74576 | 2020-04-20 | Brunswick | North Carolina | 37019 | 36 | 2 |
74577 | 74577 | 2020-04-20 | Buncombe | North Carolina | 37021 | 45 | 3 |
74578 | 74578 | 2020-04-20 | Burke | North Carolina | 37023 | 70 | 6 |
74579 | 74579 | 2020-04-20 | Cabarrus | North Carolina | 37025 | 212 | 3 |
74580 | 74580 | 2020-04-20 | Caldwell | North Carolina | 37027 | 23 | 0 |
74581 | 74581 | 2020-04-20 | Carteret | North Carolina | 37031 | 22 | 2 |
74582 | 74582 | 2020-04-20 | Caswell | North Carolina | 37033 | 8 | 0 |
74583 | 74583 | 2020-04-20 | Catawba | North Carolina | 37035 | 40 | 1 |
74584 | 74584 | 2020-04-20 | Chatham | North Carolina | 37037 | 127 | 0 |
74585 | 74585 | 2020-04-20 | Cherokee | North Carolina | 37039 | 14 | 1 |
74586 | 74586 | 2020-04-20 | Chowan | North Carolina | 37041 | 6 | 0 |
74587 | 74587 | 2020-04-20 | Clay | North Carolina | 37043 | 5 | 0 |
74588 | 74588 | 2020-04-20 | Cleveland | North Carolina | 37045 | 43 | 1 |
74589 | 74589 | 2020-04-20 | Columbus | North Carolina | 37047 | 59 | 3 |
74590 | 74590 | 2020-04-20 | Craven | North Carolina | 37049 | 36 | 3 |
74591 | 74591 | 2020-04-20 | Cumberland | North Carolina | 37051 | 112 | 3 |
74592 | 74592 | 2020-04-20 | Currituck | North Carolina | 37053 | 2 | 0 |
74593 | 74593 | 2020-04-20 | Dare | North Carolina | 37055 | 11 | 1 |
74594 | 74594 | 2020-04-20 | Davidson | North Carolina | 37057 | 94 | 2 |
74595 | 74595 | 2020-04-20 | Davie | North Carolina | 37059 | 23 | 2 |
74596 | 74596 | 2020-04-20 | Duplin | North Carolina | 37061 | 26 | 0 |
74597 | 74597 | 2020-04-20 | Durham | North Carolina | 37063 | 392 | 5 |
74598 | 74598 | 2020-04-20 | Edgecombe | North Carolina | 37065 | 57 | 1 |
74599 | 74599 | 2020-04-20 | Forsyth | North Carolina | 37067 | 126 | 5 |
74600 | 74600 | 2020-04-20 | Franklin | North Carolina | 37069 | 71 | 7 |
74601 | 74601 | 2020-04-20 | Gaston | North Carolina | 37071 | 112 | 3 |
74602 | 74602 | 2020-04-20 | Gates | North Carolina | 37073 | 4 | 0 |
74603 | 74603 | 2020-04-20 | Granville | North Carolina | 37077 | 112 | 5 |
74604 | 74604 | 2020-04-20 | Greene | North Carolina | 37079 | 13 | 0 |
74605 | 74605 | 2020-04-20 | Guilford | North Carolina | 37081 | 175 | 13 |
74606 | 74606 | 2020-04-20 | Halifax | North Carolina | 37083 | 33 | 1 |
74607 | 74607 | 2020-04-20 | Harnett | North Carolina | 37085 | 61 | 3 |
74608 | 74608 | 2020-04-20 | Haywood | North Carolina | 37087 | 5 | 0 |
74609 | 74609 | 2020-04-20 | Henderson | North Carolina | 37089 | 128 | 13 |
74610 | 74610 | 2020-04-20 | Hertford | North Carolina | 37091 | 9 | 1 |
74611 | 74611 | 2020-04-20 | Hoke | North Carolina | 37093 | 23 | 0 |
74612 | 74612 | 2020-04-20 | Iredell | North Carolina | 37097 | 82 | 2 |
74613 | 74613 | 2020-04-20 | Jackson | North Carolina | 37099 | 3 | 0 |
74614 | 74614 | 2020-04-20 | Johnston | North Carolina | 37101 | 123 | 9 |
74615 | 74615 | 2020-04-20 | Jones | North Carolina | 37103 | 8 | 1 |
74616 | 74616 | 2020-04-20 | Lee | North Carolina | 37105 | 38 | 0 |
74617 | 74617 | 2020-04-20 | Lenoir | North Carolina | 37107 | 21 | 0 |
74618 | 74618 | 2020-04-20 | Lincoln | North Carolina | 37109 | 19 | 0 |
74619 | 74619 | 2020-04-20 | Macon | North Carolina | 37113 | 2 | 1 |
74620 | 74620 | 2020-04-20 | Martin | North Carolina | 37117 | 9 | 0 |
74621 | 74621 | 2020-04-20 | McDowell | North Carolina | 37111 | 20 | 0 |
74622 | 74622 | 2020-04-20 | Mecklenburg | North Carolina | 37119 | 1210 | 29 |
74623 | 74623 | 2020-04-20 | Mitchell | North Carolina | 37121 | 5 | 0 |
74624 | 74624 | 2020-04-20 | Montgomery | North Carolina | 37123 | 18 | 1 |
74625 | 74625 | 2020-04-20 | Moore | North Carolina | 37125 | 67 | 0 |
74626 | 74626 | 2020-04-20 | Nash | North Carolina | 37127 | 61 | 1 |
74627 | 74627 | 2020-04-20 | New Hanover | North Carolina | 37129 | 62 | 1 |
74628 | 74628 | 2020-04-20 | Northampton | North Carolina | 37131 | 72 | 2 |
74629 | 74629 | 2020-04-20 | Onslow | North Carolina | 37133 | 33 | 1 |
74630 | 74630 | 2020-04-20 | Orange | North Carolina | 37135 | 187 | 3 |
74631 | 74631 | 2020-04-20 | Pamlico | North Carolina | 37137 | 6 | 0 |
74632 | 74632 | 2020-04-20 | Pasquotank | North Carolina | 37139 | 32 | 0 |
74633 | 74633 | 2020-04-20 | Pender | North Carolina | 37141 | 8 | 0 |
74634 | 74634 | 2020-04-20 | Perquimans | North Carolina | 37143 | 8 | 0 |
74635 | 74635 | 2020-04-20 | Person | North Carolina | 37145 | 15 | 0 |
74636 | 74636 | 2020-04-20 | Pitt | North Carolina | 37147 | 93 | 1 |
74637 | 74637 | 2020-04-20 | Polk | North Carolina | 37149 | 10 | 0 |
74638 | 74638 | 2020-04-20 | Randolph | North Carolina | 37151 | 77 | 2 |
74639 | 74639 | 2020-04-20 | Richmond | North Carolina | 37153 | 20 | 2 |
74640 | 74640 | 2020-04-20 | Robeson | North Carolina | 37155 | 27 | 0 |
74641 | 74641 | 2020-04-20 | Rockingham | North Carolina | 37157 | 19 | 2 |
74642 | 74642 | 2020-04-20 | Rowan | North Carolina | 37159 | 250 | 12 |
74643 | 74643 | 2020-04-20 | Rutherford | North Carolina | 37161 | 84 | 2 |
74644 | 74644 | 2020-04-20 | Sampson | North Carolina | 37163 | 22 | 0 |
74645 | 74645 | 2020-04-20 | Scotland | North Carolina | 37165 | 12 | 0 |
74646 | 74646 | 2020-04-20 | Stanly | North Carolina | 37167 | 21 | 3 |
74647 | 74647 | 2020-04-20 | Stokes | North Carolina | 37169 | 10 | 0 |
74648 | 74648 | 2020-04-20 | Surry | North Carolina | 37171 | 17 | 0 |
74649 | 74649 | 2020-04-20 | Transylvania | North Carolina | 37175 | 8 | 0 |
74650 | 74650 | 2020-04-20 | Tyrrell | North Carolina | 37177 | 4 | 0 |
74651 | 74651 | 2020-04-20 | Union | North Carolina | 37179 | 163 | 4 |
74652 | 74652 | 2020-04-20 | Vance | North Carolina | 37181 | 33 | 1 |
74653 | 74653 | 2020-04-20 | Wake | North Carolina | 37183 | 599 | 4 |
74654 | 74654 | 2020-04-20 | Warren | North Carolina | 37185 | 3 | 0 |
74655 | 74655 | 2020-04-20 | Washington | North Carolina | 37187 | 21 | 2 |
74656 | 74656 | 2020-04-20 | Watauga | North Carolina | 37189 | 8 | 0 |
74657 | 74657 | 2020-04-20 | Wayne | North Carolina | 37191 | 572 | 4 |
74658 | 74658 | 2020-04-20 | Wilkes | North Carolina | 37193 | 4 | 1 |
74659 | 74659 | 2020-04-20 | Wilson | North Carolina | 37195 | 116 | 4 |
74660 | 74660 | 2020-04-20 | 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);