ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
100 rows where "date" is on date 2020-11-17 and state = "North Carolina" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
fips >30
county >30
- Alamance 1
- Alexander 1
- Alleghany 1
- Anson 1
- Ashe 1
- Avery 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
- …
state 1
- North Carolina · 100 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
740597 | 740597 | 2020-11-17 | Alamance | North Carolina | 37001 | 6197 | 96 |
740598 | 740598 | 2020-11-17 | Alexander | North Carolina | 37003 | 1337 | 13 |
740599 | 740599 | 2020-11-17 | Alleghany | North Carolina | 37005 | 363 | 1 |
740600 | 740600 | 2020-11-17 | Anson | North Carolina | 37007 | 826 | 13 |
740601 | 740601 | 2020-11-17 | Ashe | North Carolina | 37009 | 653 | 3 |
740602 | 740602 | 2020-11-17 | Avery | North Carolina | 37011 | 802 | 3 |
740603 | 740603 | 2020-11-17 | Beaufort | North Carolina | 37013 | 1566 | 52 |
740604 | 740604 | 2020-11-17 | Bertie | North Carolina | 37015 | 805 | 22 |
740605 | 740605 | 2020-11-17 | Bladen | North Carolina | 37017 | 1205 | 19 |
740606 | 740606 | 2020-11-17 | Brunswick | North Carolina | 37019 | 2587 | 55 |
740607 | 740607 | 2020-11-17 | Buncombe | North Carolina | 37021 | 4923 | 121 |
740608 | 740608 | 2020-11-17 | Burke | North Carolina | 37023 | 3285 | 61 |
740609 | 740609 | 2020-11-17 | Cabarrus | North Carolina | 37025 | 5981 | 101 |
740610 | 740610 | 2020-11-17 | Caldwell | North Carolina | 37027 | 3086 | 21 |
740611 | 740611 | 2020-11-17 | Camden | North Carolina | 37029 | 162 | 3 |
740612 | 740612 | 2020-11-17 | Carteret | North Carolina | 37031 | 1454 | 14 |
740613 | 740613 | 2020-11-17 | Caswell | North Carolina | 37033 | 732 | 6 |
740614 | 740614 | 2020-11-17 | Catawba | North Carolina | 37035 | 5800 | 72 |
740615 | 740615 | 2020-11-17 | Chatham | North Carolina | 37037 | 2193 | 65 |
740616 | 740616 | 2020-11-17 | Cherokee | North Carolina | 37039 | 865 | 15 |
740617 | 740617 | 2020-11-17 | Chowan | North Carolina | 37041 | 574 | 18 |
740618 | 740618 | 2020-11-17 | Clay | North Carolina | 37043 | 265 | 5 |
740619 | 740619 | 2020-11-17 | Cleveland | North Carolina | 37045 | 3815 | 99 |
740620 | 740620 | 2020-11-17 | Columbus | North Carolina | 37047 | 2241 | 67 |
740621 | 740621 | 2020-11-17 | Craven | North Carolina | 37049 | 2727 | 67 |
740622 | 740622 | 2020-11-17 | Cumberland | North Carolina | 37051 | 8358 | 109 |
740623 | 740623 | 2020-11-17 | Currituck | North Carolina | 37053 | 285 | 4 |
740624 | 740624 | 2020-11-17 | Dare | North Carolina | 37055 | 548 | 3 |
740625 | 740625 | 2020-11-17 | Davidson | North Carolina | 37057 | 4528 | 48 |
740626 | 740626 | 2020-11-17 | Davie | North Carolina | 37059 | 995 | 11 |
740627 | 740627 | 2020-11-17 | Duplin | North Carolina | 37061 | 3086 | 56 |
740628 | 740628 | 2020-11-17 | Durham | North Carolina | 37063 | 10422 | 108 |
740629 | 740629 | 2020-11-17 | Edgecombe | North Carolina | 37065 | 2314 | 68 |
740630 | 740630 | 2020-11-17 | Forsyth | North Carolina | 37067 | 11182 | 150 |
740631 | 740631 | 2020-11-17 | Franklin | North Carolina | 37069 | 1732 | 32 |
740632 | 740632 | 2020-11-17 | Gaston | North Carolina | 37071 | 9075 | 168 |
740633 | 740633 | 2020-11-17 | Gates | North Carolina | 37073 | 186 | 5 |
740634 | 740634 | 2020-11-17 | Graham | North Carolina | 37075 | 265 | 11 |
740635 | 740635 | 2020-11-17 | Granville | North Carolina | 37077 | 2309 | 54 |
740636 | 740636 | 2020-11-17 | Greene | North Carolina | 37079 | 1105 | 21 |
740637 | 740637 | 2020-11-17 | Guilford | North Carolina | 37081 | 14326 | 218 |
740638 | 740638 | 2020-11-17 | Halifax | North Carolina | 37083 | 1740 | 33 |
740639 | 740639 | 2020-11-17 | Harnett | North Carolina | 37085 | 3472 | 77 |
740640 | 740640 | 2020-11-17 | Haywood | North Carolina | 37087 | 900 | 37 |
740641 | 740641 | 2020-11-17 | Henderson | North Carolina | 37089 | 2877 | 70 |
740642 | 740642 | 2020-11-17 | Hertford | North Carolina | 37091 | 922 | 38 |
740643 | 740643 | 2020-11-17 | Hoke | North Carolina | 37093 | 1783 | 28 |
740644 | 740644 | 2020-11-17 | Hyde | North Carolina | 37095 | 180 | 5 |
740645 | 740645 | 2020-11-17 | Iredell | North Carolina | 37097 | 4641 | 39 |
740646 | 740646 | 2020-11-17 | Jackson | North Carolina | 37099 | 1284 | 8 |
740647 | 740647 | 2020-11-17 | Johnston | North Carolina | 37101 | 6897 | 70 |
740648 | 740648 | 2020-11-17 | Jones | North Carolina | 37103 | 224 | 15 |
740649 | 740649 | 2020-11-17 | Lee | North Carolina | 37105 | 2304 | 29 |
740650 | 740650 | 2020-11-17 | Lenoir | North Carolina | 37107 | 1803 | 46 |
740651 | 740651 | 2020-11-17 | Lincoln | North Carolina | 37109 | 2962 | 16 |
740652 | 740652 | 2020-11-17 | Macon | North Carolina | 37113 | 852 | 8 |
740653 | 740653 | 2020-11-17 | Madison | North Carolina | 37115 | 399 | 7 |
740654 | 740654 | 2020-11-17 | Martin | North Carolina | 37117 | 745 | 20 |
740655 | 740655 | 2020-11-17 | McDowell | North Carolina | 37111 | 1595 | 34 |
740656 | 740656 | 2020-11-17 | Mecklenburg | North Carolina | 37119 | 39014 | 425 |
740657 | 740657 | 2020-11-17 | Mitchell | North Carolina | 37121 | 412 | 4 |
740658 | 740658 | 2020-11-17 | Montgomery | North Carolina | 37123 | 1295 | 41 |
740659 | 740659 | 2020-11-17 | Moore | North Carolina | 37125 | 2582 | 58 |
740660 | 740660 | 2020-11-17 | Nash | North Carolina | 37127 | 4007 | 88 |
740661 | 740661 | 2020-11-17 | New Hanover | North Carolina | 37129 | 6227 | 48 |
740662 | 740662 | 2020-11-17 | Northampton | North Carolina | 37131 | 683 | 22 |
740663 | 740663 | 2020-11-17 | Onslow | North Carolina | 37133 | 4281 | 36 |
740664 | 740664 | 2020-11-17 | Orange | North Carolina | 37135 | 3539 | 61 |
740665 | 740665 | 2020-11-17 | Pamlico | North Carolina | 37137 | 356 | 3 |
740666 | 740666 | 2020-11-17 | Pasquotank | North Carolina | 37139 | 1002 | 35 |
740667 | 740667 | 2020-11-17 | Pender | North Carolina | 37141 | 1655 | 17 |
740668 | 740668 | 2020-11-17 | Perquimans | North Carolina | 37143 | 293 | 4 |
740669 | 740669 | 2020-11-17 | Person | North Carolina | 37145 | 846 | 10 |
740670 | 740670 | 2020-11-17 | Pitt | North Carolina | 37147 | 7059 | 44 |
740671 | 740671 | 2020-11-17 | Polk | North Carolina | 37149 | 433 | 13 |
740672 | 740672 | 2020-11-17 | Randolph | North Carolina | 37151 | 4699 | 74 |
740673 | 740673 | 2020-11-17 | Richmond | North Carolina | 37153 | 1675 | 36 |
740674 | 740674 | 2020-11-17 | Robeson | North Carolina | 37155 | 6775 | 103 |
740675 | 740675 | 2020-11-17 | Rockingham | North Carolina | 37157 | 2599 | 22 |
740676 | 740676 | 2020-11-17 | Rowan | North Carolina | 37159 | 4950 | 126 |
740677 | 740677 | 2020-11-17 | Rutherford | North Carolina | 37161 | 2040 | 82 |
740678 | 740678 | 2020-11-17 | Sampson | North Carolina | 37163 | 3233 | 32 |
740679 | 740679 | 2020-11-17 | Scotland | North Carolina | 37165 | 1777 | 36 |
740680 | 740680 | 2020-11-17 | Stanly | North Carolina | 37167 | 2715 | 78 |
740681 | 740681 | 2020-11-17 | Stokes | North Carolina | 37169 | 926 | 14 |
740682 | 740682 | 2020-11-17 | Surry | North Carolina | 37171 | 2385 | 41 |
740683 | 740683 | 2020-11-17 | Swain | North Carolina | 37173 | 339 | 5 |
740684 | 740684 | 2020-11-17 | Transylvania | North Carolina | 37175 | 488 | 9 |
740685 | 740685 | 2020-11-17 | Tyrrell | North Carolina | 37177 | 135 | 3 |
740686 | 740686 | 2020-11-17 | Union | North Carolina | 37179 | 6906 | 68 |
740687 | 740687 | 2020-11-17 | Vance | North Carolina | 37181 | 1466 | 48 |
740688 | 740688 | 2020-11-17 | Wake | North Carolina | 37183 | 25741 | 280 |
740689 | 740689 | 2020-11-17 | Warren | North Carolina | 37185 | 552 | 7 |
740690 | 740690 | 2020-11-17 | Washington | North Carolina | 37187 | 291 | 8 |
740691 | 740691 | 2020-11-17 | Watauga | North Carolina | 37189 | 1597 | 6 |
740692 | 740692 | 2020-11-17 | Wayne | North Carolina | 37191 | 5233 | 106 |
740693 | 740693 | 2020-11-17 | Wilkes | North Carolina | 37193 | 2307 | 44 |
740694 | 740694 | 2020-11-17 | Wilson | North Carolina | 37195 | 3599 | 72 |
740695 | 740695 | 2020-11-17 | Yadkin | North Carolina | 37197 | 1258 | 12 |
740696 | 740696 | 2020-11-17 | Yancey | North Carolina | 37199 | 427 | 2 |
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);