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-10-28 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 |
---|---|---|---|---|---|---|---|
675724 | 675724 | 2020-10-28 | Alamance | North Carolina | 37001 | 5181 | 79 |
675725 | 675725 | 2020-10-28 | Alexander | North Carolina | 37003 | 865 | 9 |
675726 | 675726 | 2020-10-28 | Alleghany | North Carolina | 37005 | 297 | 2 |
675727 | 675727 | 2020-10-28 | Anson | North Carolina | 37007 | 728 | 10 |
675728 | 675728 | 2020-10-28 | Ashe | North Carolina | 37009 | 434 | 3 |
675729 | 675729 | 2020-10-28 | Avery | North Carolina | 37011 | 618 | 0 |
675730 | 675730 | 2020-10-28 | Beaufort | North Carolina | 37013 | 1371 | 42 |
675731 | 675731 | 2020-10-28 | Bertie | North Carolina | 37015 | 726 | 19 |
675732 | 675732 | 2020-10-28 | Bladen | North Carolina | 37017 | 1088 | 19 |
675733 | 675733 | 2020-10-28 | Brunswick | North Carolina | 37019 | 2186 | 46 |
675734 | 675734 | 2020-10-28 | Buncombe | North Carolina | 37021 | 4116 | 113 |
675735 | 675735 | 2020-10-28 | Burke | North Carolina | 37023 | 2669 | 52 |
675736 | 675736 | 2020-10-28 | Cabarrus | North Carolina | 37025 | 4894 | 91 |
675737 | 675737 | 2020-10-28 | Caldwell | North Carolina | 37027 | 2487 | 19 |
675738 | 675738 | 2020-10-28 | Camden | North Carolina | 37029 | 135 | 3 |
675739 | 675739 | 2020-10-28 | Carteret | North Carolina | 37031 | 1137 | 5 |
675740 | 675740 | 2020-10-28 | Caswell | North Carolina | 37033 | 619 | 5 |
675741 | 675741 | 2020-10-28 | Catawba | North Carolina | 37035 | 4435 | 62 |
675742 | 675742 | 2020-10-28 | Chatham | North Carolina | 37037 | 1930 | 61 |
675743 | 675743 | 2020-10-28 | Cherokee | North Carolina | 37039 | 773 | 14 |
675744 | 675744 | 2020-10-28 | Chowan | North Carolina | 37041 | 529 | 10 |
675745 | 675745 | 2020-10-28 | Clay | North Carolina | 37043 | 221 | 3 |
675746 | 675746 | 2020-10-28 | Cleveland | North Carolina | 37045 | 3157 | 86 |
675747 | 675747 | 2020-10-28 | Columbus | North Carolina | 37047 | 1704 | 62 |
675748 | 675748 | 2020-10-28 | Craven | North Carolina | 37049 | 2329 | 60 |
675749 | 675749 | 2020-10-28 | Cumberland | North Carolina | 37051 | 7048 | 99 |
675750 | 675750 | 2020-10-28 | Currituck | North Carolina | 37053 | 224 | 4 |
675751 | 675751 | 2020-10-28 | Dare | North Carolina | 37055 | 370 | 3 |
675752 | 675752 | 2020-10-28 | Davidson | North Carolina | 37057 | 3717 | 43 |
675753 | 675753 | 2020-10-28 | Davie | North Carolina | 37059 | 763 | 8 |
675754 | 675754 | 2020-10-28 | Duplin | North Carolina | 37061 | 2795 | 54 |
675755 | 675755 | 2020-10-28 | Durham | North Carolina | 37063 | 9067 | 102 |
675756 | 675756 | 2020-10-28 | Edgecombe | North Carolina | 37065 | 1988 | 57 |
675757 | 675757 | 2020-10-28 | Forsyth | North Carolina | 37067 | 8834 | 119 |
675758 | 675758 | 2020-10-28 | Franklin | North Carolina | 37069 | 1467 | 32 |
675759 | 675759 | 2020-10-28 | Gaston | North Carolina | 37071 | 7399 | 116 |
675760 | 675760 | 2020-10-28 | Gates | North Carolina | 37073 | 168 | 3 |
675761 | 675761 | 2020-10-28 | Graham | North Carolina | 37075 | 247 | 8 |
675762 | 675762 | 2020-10-28 | Granville | North Carolina | 37077 | 2002 | 50 |
675763 | 675763 | 2020-10-28 | Greene | North Carolina | 37079 | 955 | 13 |
675764 | 675764 | 2020-10-28 | Guilford | North Carolina | 37081 | 11376 | 208 |
675765 | 675765 | 2020-10-28 | Halifax | North Carolina | 37083 | 1416 | 27 |
675766 | 675766 | 2020-10-28 | Harnett | North Carolina | 37085 | 2940 | 69 |
675767 | 675767 | 2020-10-28 | Haywood | North Carolina | 37087 | 714 | 36 |
675768 | 675768 | 2020-10-28 | Henderson | North Carolina | 37089 | 2506 | 67 |
675769 | 675769 | 2020-10-28 | Hertford | North Carolina | 37091 | 852 | 34 |
675770 | 675770 | 2020-10-28 | Hoke | North Carolina | 37093 | 1548 | 25 |
675771 | 675771 | 2020-10-28 | Hyde | North Carolina | 37095 | 174 | 5 |
675772 | 675772 | 2020-10-28 | Iredell | North Carolina | 37097 | 3818 | 34 |
675773 | 675773 | 2020-10-28 | Jackson | North Carolina | 37099 | 1056 | 7 |
675774 | 675774 | 2020-10-28 | Johnston | North Carolina | 37101 | 5766 | 66 |
675775 | 675775 | 2020-10-28 | Jones | North Carolina | 37103 | 200 | 15 |
675776 | 675776 | 2020-10-28 | Lee | North Carolina | 37105 | 2101 | 20 |
675777 | 675777 | 2020-10-28 | Lenoir | North Carolina | 37107 | 1450 | 41 |
675778 | 675778 | 2020-10-28 | Lincoln | North Carolina | 37109 | 2395 | 16 |
675779 | 675779 | 2020-10-28 | Macon | North Carolina | 37113 | 755 | 7 |
675780 | 675780 | 2020-10-28 | Madison | North Carolina | 37115 | 246 | 1 |
675781 | 675781 | 2020-10-28 | Martin | North Carolina | 37117 | 640 | 17 |
675782 | 675782 | 2020-10-28 | McDowell | North Carolina | 37111 | 1322 | 32 |
675783 | 675783 | 2020-10-28 | Mecklenburg | North Carolina | 37119 | 33779 | 390 |
675784 | 675784 | 2020-10-28 | Mitchell | North Carolina | 37121 | 228 | 4 |
675785 | 675785 | 2020-10-28 | Montgomery | North Carolina | 37123 | 1190 | 38 |
675786 | 675786 | 2020-10-28 | Moore | North Carolina | 37125 | 2266 | 43 |
675787 | 675787 | 2020-10-28 | Nash | North Carolina | 37127 | 3365 | 75 |
675788 | 675788 | 2020-10-28 | New Hanover | North Carolina | 37129 | 5254 | 37 |
675789 | 675789 | 2020-10-28 | Northampton | North Carolina | 37131 | 562 | 19 |
675790 | 675790 | 2020-10-28 | Onslow | North Carolina | 37133 | 3329 | 29 |
675791 | 675791 | 2020-10-28 | Orange | North Carolina | 37135 | 3088 | 58 |
675792 | 675792 | 2020-10-28 | Pamlico | North Carolina | 37137 | 318 | 2 |
675793 | 675793 | 2020-10-28 | Pasquotank | North Carolina | 37139 | 873 | 35 |
675794 | 675794 | 2020-10-28 | Pender | North Carolina | 37141 | 1398 | 13 |
675795 | 675795 | 2020-10-28 | Perquimans | North Carolina | 37143 | 250 | 4 |
675796 | 675796 | 2020-10-28 | Person | North Carolina | 37145 | 662 | 10 |
675797 | 675797 | 2020-10-28 | Pitt | North Carolina | 37147 | 6142 | 39 |
675798 | 675798 | 2020-10-28 | Polk | North Carolina | 37149 | 397 | 11 |
675799 | 675799 | 2020-10-28 | Randolph | North Carolina | 37151 | 3765 | 63 |
675800 | 675800 | 2020-10-28 | Richmond | North Carolina | 37153 | 1426 | 29 |
675801 | 675801 | 2020-10-28 | Robeson | North Carolina | 37155 | 6026 | 95 |
675802 | 675802 | 2020-10-28 | Rockingham | North Carolina | 37157 | 1967 | 19 |
675803 | 675803 | 2020-10-28 | Rowan | North Carolina | 37159 | 4122 | 120 |
675804 | 675804 | 2020-10-28 | Rutherford | North Carolina | 37161 | 1751 | 62 |
675805 | 675805 | 2020-10-28 | Sampson | North Carolina | 37163 | 2750 | 31 |
675806 | 675806 | 2020-10-28 | Scotland | North Carolina | 37165 | 1630 | 24 |
675807 | 675807 | 2020-10-28 | Stanly | North Carolina | 37167 | 2438 | 62 |
675808 | 675808 | 2020-10-28 | Stokes | North Carolina | 37169 | 685 | 10 |
675809 | 675809 | 2020-10-28 | Surry | North Carolina | 37171 | 1853 | 30 |
675810 | 675810 | 2020-10-28 | Swain | North Carolina | 37173 | 284 | 4 |
675811 | 675811 | 2020-10-28 | Transylvania | North Carolina | 37175 | 420 | 9 |
675812 | 675812 | 2020-10-28 | Tyrrell | North Carolina | 37177 | 132 | 3 |
675813 | 675813 | 2020-10-28 | Union | North Carolina | 37179 | 5914 | 65 |
675814 | 675814 | 2020-10-28 | Vance | North Carolina | 37181 | 1206 | 47 |
675815 | 675815 | 2020-10-28 | Wake | North Carolina | 37183 | 21400 | 270 |
675816 | 675816 | 2020-10-28 | Warren | North Carolina | 37185 | 433 | 7 |
675817 | 675817 | 2020-10-28 | Washington | North Carolina | 37187 | 250 | 8 |
675818 | 675818 | 2020-10-28 | Watauga | North Carolina | 37189 | 1393 | 6 |
675819 | 675819 | 2020-10-28 | Wayne | North Carolina | 37191 | 4589 | 80 |
675820 | 675820 | 2020-10-28 | Wilkes | North Carolina | 37193 | 1744 | 38 |
675821 | 675821 | 2020-10-28 | Wilson | North Carolina | 37195 | 2994 | 64 |
675822 | 675822 | 2020-10-28 | Yadkin | North Carolina | 37197 | 1028 | 9 |
675823 | 675823 | 2020-10-28 | Yancey | North Carolina | 37199 | 317 | 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);