ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
100 rows where date = "2020-09-12" 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 |
---|---|---|---|---|---|---|---|
526611 | 526611 | 2020-09-12 | Alamance | North Carolina | 37001 | 3526 | 48 |
526612 | 526612 | 2020-09-12 | Alexander | North Carolina | 37003 | 471 | 3 |
526613 | 526613 | 2020-09-12 | Alleghany | North Carolina | 37005 | 215 | 0 |
526614 | 526614 | 2020-09-12 | Anson | North Carolina | 37007 | 505 | 3 |
526615 | 526615 | 2020-09-12 | Ashe | North Carolina | 37009 | 240 | 1 |
526616 | 526616 | 2020-09-12 | Avery | North Carolina | 37011 | 258 | 0 |
526617 | 526617 | 2020-09-12 | Beaufort | North Carolina | 37013 | 761 | 10 |
526618 | 526618 | 2020-09-12 | Bertie | North Carolina | 37015 | 512 | 7 |
526619 | 526619 | 2020-09-12 | Bladen | North Carolina | 37017 | 798 | 11 |
526620 | 526620 | 2020-09-12 | Brunswick | North Carolina | 37019 | 1472 | 26 |
526621 | 526621 | 2020-09-12 | Buncombe | North Carolina | 37021 | 2728 | 82 |
526622 | 526622 | 2020-09-12 | Burke | North Carolina | 37023 | 1959 | 33 |
526623 | 526623 | 2020-09-12 | Cabarrus | North Carolina | 37025 | 3565 | 57 |
526624 | 526624 | 2020-09-12 | Caldwell | North Carolina | 37027 | 1516 | 17 |
526625 | 526625 | 2020-09-12 | Camden | North Carolina | 37029 | 104 | 3 |
526626 | 526626 | 2020-09-12 | Carteret | North Carolina | 37031 | 573 | 5 |
526627 | 526627 | 2020-09-12 | Caswell | North Carolina | 37033 | 266 | 3 |
526628 | 526628 | 2020-09-12 | Catawba | North Carolina | 37035 | 2804 | 48 |
526629 | 526629 | 2020-09-12 | Chatham | North Carolina | 37037 | 1562 | 57 |
526630 | 526630 | 2020-09-12 | Cherokee | North Carolina | 37039 | 519 | 6 |
526631 | 526631 | 2020-09-12 | Chowan | North Carolina | 37041 | 272 | 3 |
526632 | 526632 | 2020-09-12 | Clay | North Carolina | 37043 | 102 | 1 |
526633 | 526633 | 2020-09-12 | Cleveland | North Carolina | 37045 | 1813 | 52 |
526634 | 526634 | 2020-09-12 | Columbus | North Carolina | 37047 | 1246 | 52 |
526635 | 526635 | 2020-09-12 | Craven | North Carolina | 37049 | 1127 | 29 |
526636 | 526636 | 2020-09-12 | Cumberland | North Carolina | 37051 | 4683 | 74 |
526637 | 526637 | 2020-09-12 | Currituck | North Carolina | 37053 | 135 | 0 |
526638 | 526638 | 2020-09-12 | Dare | North Carolina | 37055 | 253 | 2 |
526639 | 526639 | 2020-09-12 | Davidson | North Carolina | 37057 | 2416 | 32 |
526640 | 526640 | 2020-09-12 | Davie | North Carolina | 37059 | 515 | 6 |
526641 | 526641 | 2020-09-12 | Duplin | North Carolina | 37061 | 2116 | 52 |
526642 | 526642 | 2020-09-12 | Durham | North Carolina | 37063 | 7290 | 88 |
526643 | 526643 | 2020-09-12 | Edgecombe | North Carolina | 37065 | 1157 | 30 |
526644 | 526644 | 2020-09-12 | Forsyth | North Carolina | 37067 | 6579 | 86 |
526645 | 526645 | 2020-09-12 | Franklin | North Carolina | 37069 | 1137 | 30 |
526646 | 526646 | 2020-09-12 | Gaston | North Carolina | 37071 | 4515 | 69 |
526647 | 526647 | 2020-09-12 | Gates | North Carolina | 37073 | 106 | 3 |
526648 | 526648 | 2020-09-12 | Graham | North Carolina | 37075 | 106 | 0 |
526649 | 526649 | 2020-09-12 | Granville | North Carolina | 37077 | 1631 | 48 |
526650 | 526650 | 2020-09-12 | Greene | North Carolina | 37079 | 471 | 5 |
526651 | 526651 | 2020-09-12 | Guilford | North Carolina | 37081 | 7607 | 174 |
526652 | 526652 | 2020-09-12 | Halifax | North Carolina | 37083 | 921 | 17 |
526653 | 526653 | 2020-09-12 | Harnett | North Carolina | 37085 | 1847 | 49 |
526654 | 526654 | 2020-09-12 | Haywood | North Carolina | 37087 | 550 | 31 |
526655 | 526655 | 2020-09-12 | Henderson | North Carolina | 37089 | 1829 | 65 |
526656 | 526656 | 2020-09-12 | Hertford | North Carolina | 37091 | 636 | 24 |
526657 | 526657 | 2020-09-12 | Hoke | North Carolina | 37093 | 963 | 13 |
526658 | 526658 | 2020-09-12 | Hyde | North Carolina | 37095 | 123 | 3 |
526659 | 526659 | 2020-09-12 | Iredell | North Carolina | 37097 | 2536 | 25 |
526660 | 526660 | 2020-09-12 | Jackson | North Carolina | 37099 | 517 | 7 |
526661 | 526661 | 2020-09-12 | Johnston | North Carolina | 37101 | 4167 | 54 |
526662 | 526662 | 2020-09-12 | Jones | North Carolina | 37103 | 142 | 11 |
526663 | 526663 | 2020-09-12 | Lee | North Carolina | 37105 | 1512 | 13 |
526664 | 526664 | 2020-09-12 | Lenoir | North Carolina | 37107 | 892 | 22 |
526665 | 526665 | 2020-09-12 | Lincoln | North Carolina | 37109 | 1334 | 13 |
526666 | 526666 | 2020-09-12 | Macon | North Carolina | 37113 | 561 | 2 |
526667 | 526667 | 2020-09-12 | Madison | North Carolina | 37115 | 83 | 1 |
526668 | 526668 | 2020-09-12 | Martin | North Carolina | 37117 | 394 | 9 |
526669 | 526669 | 2020-09-12 | McDowell | North Carolina | 37111 | 858 | 25 |
526670 | 526670 | 2020-09-12 | Mecklenburg | North Carolina | 37119 | 27012 | 336 |
526671 | 526671 | 2020-09-12 | Mitchell | North Carolina | 37121 | 96 | 3 |
526672 | 526672 | 2020-09-12 | Montgomery | North Carolina | 37123 | 975 | 23 |
526673 | 526673 | 2020-09-12 | Moore | North Carolina | 37125 | 1446 | 22 |
526674 | 526674 | 2020-09-12 | Nash | North Carolina | 37127 | 1915 | 31 |
526675 | 526675 | 2020-09-12 | New Hanover | North Carolina | 37129 | 3609 | 25 |
526676 | 526676 | 2020-09-12 | Northampton | North Carolina | 37131 | 375 | 17 |
526677 | 526677 | 2020-09-12 | Onslow | North Carolina | 37133 | 1695 | 18 |
526678 | 526678 | 2020-09-12 | Orange | North Carolina | 37135 | 2501 | 54 |
526679 | 526679 | 2020-09-12 | Pamlico | North Carolina | 37137 | 217 | 2 |
526680 | 526680 | 2020-09-12 | Pasquotank | North Carolina | 37139 | 622 | 26 |
526681 | 526681 | 2020-09-12 | Pender | North Carolina | 37141 | 824 | 5 |
526682 | 526682 | 2020-09-12 | Perquimans | North Carolina | 37143 | 158 | 3 |
526683 | 526683 | 2020-09-12 | Person | North Carolina | 37145 | 379 | 6 |
526684 | 526684 | 2020-09-12 | Pitt | North Carolina | 37147 | 4261 | 25 |
526685 | 526685 | 2020-09-12 | Polk | North Carolina | 37149 | 250 | 7 |
526686 | 526686 | 2020-09-12 | Randolph | North Carolina | 37151 | 2571 | 49 |
526687 | 526687 | 2020-09-12 | Richmond | North Carolina | 37153 | 807 | 12 |
526688 | 526688 | 2020-09-12 | Robeson | North Carolina | 37155 | 4025 | 66 |
526689 | 526689 | 2020-09-12 | Rockingham | North Carolina | 37157 | 1042 | 11 |
526690 | 526690 | 2020-09-12 | Rowan | North Carolina | 37159 | 3033 | 81 |
526691 | 526691 | 2020-09-12 | Rutherford | North Carolina | 37161 | 1048 | 24 |
526692 | 526692 | 2020-09-12 | Sampson | North Carolina | 37163 | 1695 | 22 |
526693 | 526693 | 2020-09-12 | Scotland | North Carolina | 37165 | 811 | 12 |
526694 | 526694 | 2020-09-12 | Stanly | North Carolina | 37167 | 1705 | 52 |
526695 | 526695 | 2020-09-12 | Stokes | North Carolina | 37169 | 388 | 3 |
526696 | 526696 | 2020-09-12 | Surry | North Carolina | 37171 | 1238 | 20 |
526697 | 526697 | 2020-09-12 | Swain | North Carolina | 37173 | 135 | 3 |
526698 | 526698 | 2020-09-12 | Transylvania | North Carolina | 37175 | 288 | 6 |
526699 | 526699 | 2020-09-12 | Tyrrell | North Carolina | 37177 | 110 | 2 |
526700 | 526700 | 2020-09-12 | Union | North Carolina | 37179 | 4371 | 56 |
526701 | 526701 | 2020-09-12 | Vance | North Carolina | 37181 | 975 | 43 |
526702 | 526702 | 2020-09-12 | Wake | North Carolina | 37183 | 16396 | 213 |
526703 | 526703 | 2020-09-12 | Warren | North Carolina | 37185 | 298 | 7 |
526704 | 526704 | 2020-09-12 | Washington | North Carolina | 37187 | 194 | 7 |
526705 | 526705 | 2020-09-12 | Watauga | North Carolina | 37189 | 514 | 0 |
526706 | 526706 | 2020-09-12 | Wayne | North Carolina | 37191 | 3002 | 62 |
526707 | 526707 | 2020-09-12 | Wilkes | North Carolina | 37193 | 1102 | 28 |
526708 | 526708 | 2020-09-12 | Wilson | North Carolina | 37195 | 1932 | 44 |
526709 | 526709 | 2020-09-12 | Yadkin | North Carolina | 37197 | 681 | 7 |
526710 | 526710 | 2020-09-12 | Yancey | North Carolina | 37199 | 113 | 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);