ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
98 rows where date = "2020-04-29" and state = "North Carolina" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths, date (date)
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
- 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
- Duplin 1
- …
state 1
- North Carolina · 98 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
99876 | 99876 | 2020-04-29 | Alamance | North Carolina | 37001 | 95 | 1 |
99877 | 99877 | 2020-04-29 | Alexander | North Carolina | 37003 | 4 | 0 |
99878 | 99878 | 2020-04-29 | Alleghany | North Carolina | 37005 | 2 | 0 |
99879 | 99879 | 2020-04-29 | Anson | North Carolina | 37007 | 24 | 0 |
99880 | 99880 | 2020-04-29 | Ashe | North Carolina | 37009 | 5 | 0 |
99881 | 99881 | 2020-04-29 | Beaufort | North Carolina | 37013 | 20 | 0 |
99882 | 99882 | 2020-04-29 | Bertie | North Carolina | 37015 | 38 | 2 |
99883 | 99883 | 2020-04-29 | Bladen | North Carolina | 37017 | 20 | 0 |
99884 | 99884 | 2020-04-29 | Brunswick | North Carolina | 37019 | 43 | 3 |
99885 | 99885 | 2020-04-29 | Buncombe | North Carolina | 37021 | 54 | 4 |
99886 | 99886 | 2020-04-29 | Burke | North Carolina | 37023 | 93 | 8 |
99887 | 99887 | 2020-04-29 | Cabarrus | North Carolina | 37025 | 267 | 10 |
99888 | 99888 | 2020-04-29 | Caldwell | North Carolina | 37027 | 32 | 0 |
99889 | 99889 | 2020-04-29 | Camden | North Carolina | 37029 | 1 | 0 |
99890 | 99890 | 2020-04-29 | Carteret | North Carolina | 37031 | 27 | 3 |
99891 | 99891 | 2020-04-29 | Caswell | North Carolina | 37033 | 19 | 0 |
99892 | 99892 | 2020-04-29 | Catawba | North Carolina | 37035 | 52 | 1 |
99893 | 99893 | 2020-04-29 | Chatham | North Carolina | 37037 | 287 | 6 |
99894 | 99894 | 2020-04-29 | Cherokee | North Carolina | 37039 | 16 | 1 |
99895 | 99895 | 2020-04-29 | Chowan | North Carolina | 37041 | 6 | 0 |
99896 | 99896 | 2020-04-29 | Clay | North Carolina | 37043 | 5 | 0 |
99897 | 99897 | 2020-04-29 | Cleveland | North Carolina | 37045 | 46 | 2 |
99898 | 99898 | 2020-04-29 | Columbus | North Carolina | 37047 | 102 | 8 |
99899 | 99899 | 2020-04-29 | Craven | North Carolina | 37049 | 39 | 4 |
99900 | 99900 | 2020-04-29 | Cumberland | North Carolina | 37051 | 223 | 7 |
99901 | 99901 | 2020-04-29 | Currituck | North Carolina | 37053 | 5 | 0 |
99902 | 99902 | 2020-04-29 | Dare | North Carolina | 37055 | 11 | 1 |
99903 | 99903 | 2020-04-29 | Davidson | North Carolina | 37057 | 160 | 7 |
99904 | 99904 | 2020-04-29 | Davie | North Carolina | 37059 | 29 | 2 |
99905 | 99905 | 2020-04-29 | Duplin | North Carolina | 37061 | 75 | 0 |
99906 | 99906 | 2020-04-29 | Durham | North Carolina | 37063 | 708 | 17 |
99907 | 99907 | 2020-04-29 | Edgecombe | North Carolina | 37065 | 81 | 4 |
99908 | 99908 | 2020-04-29 | Forsyth | North Carolina | 37067 | 194 | 5 |
99909 | 99909 | 2020-04-29 | Franklin | North Carolina | 37069 | 100 | 18 |
99910 | 99910 | 2020-04-29 | Gaston | North Carolina | 37071 | 137 | 3 |
99911 | 99911 | 2020-04-29 | Gates | North Carolina | 37073 | 7 | 0 |
99912 | 99912 | 2020-04-29 | Graham | North Carolina | 37075 | 1 | 0 |
99913 | 99913 | 2020-04-29 | Granville | North Carolina | 37077 | 136 | 5 |
99914 | 99914 | 2020-04-29 | Greene | North Carolina | 37079 | 15 | 0 |
99915 | 99915 | 2020-04-29 | Guilford | North Carolina | 37081 | 357 | 23 |
99916 | 99916 | 2020-04-29 | Halifax | North Carolina | 37083 | 55 | 1 |
99917 | 99917 | 2020-04-29 | Harnett | North Carolina | 37085 | 151 | 7 |
99918 | 99918 | 2020-04-29 | Haywood | North Carolina | 37087 | 6 | 0 |
99919 | 99919 | 2020-04-29 | Henderson | North Carolina | 37089 | 159 | 18 |
99920 | 99920 | 2020-04-29 | Hertford | North Carolina | 37091 | 34 | 1 |
99921 | 99921 | 2020-04-29 | Hoke | North Carolina | 37093 | 72 | 0 |
99922 | 99922 | 2020-04-29 | Hyde | North Carolina | 37095 | 1 | 0 |
99923 | 99923 | 2020-04-29 | Iredell | North Carolina | 37097 | 105 | 5 |
99924 | 99924 | 2020-04-29 | Jackson | North Carolina | 37099 | 10 | 0 |
99925 | 99925 | 2020-04-29 | Johnston | North Carolina | 37101 | 147 | 12 |
99926 | 99926 | 2020-04-29 | Jones | North Carolina | 37103 | 12 | 2 |
99927 | 99927 | 2020-04-29 | Lee | North Carolina | 37105 | 142 | 0 |
99928 | 99928 | 2020-04-29 | Lenoir | North Carolina | 37107 | 60 | 3 |
99929 | 99929 | 2020-04-29 | Lincoln | North Carolina | 37109 | 27 | 0 |
99930 | 99930 | 2020-04-29 | Macon | North Carolina | 37113 | 2 | 1 |
99931 | 99931 | 2020-04-29 | Madison | North Carolina | 37115 | 1 | 0 |
99932 | 99932 | 2020-04-29 | Martin | North Carolina | 37117 | 16 | 0 |
99933 | 99933 | 2020-04-29 | McDowell | North Carolina | 37111 | 22 | 1 |
99934 | 99934 | 2020-04-29 | Mecklenburg | North Carolina | 37119 | 1567 | 44 |
99935 | 99935 | 2020-04-29 | Mitchell | North Carolina | 37121 | 5 | 0 |
99936 | 99936 | 2020-04-29 | Montgomery | North Carolina | 37123 | 31 | 1 |
99937 | 99937 | 2020-04-29 | Moore | North Carolina | 37125 | 71 | 2 |
99938 | 99938 | 2020-04-29 | Nash | North Carolina | 37127 | 87 | 3 |
99939 | 99939 | 2020-04-29 | New Hanover | North Carolina | 37129 | 74 | 3 |
99940 | 99940 | 2020-04-29 | Northampton | North Carolina | 37131 | 81 | 4 |
99941 | 99941 | 2020-04-29 | Onslow | North Carolina | 37133 | 43 | 1 |
99942 | 99942 | 2020-04-29 | Orange | North Carolina | 37135 | 217 | 15 |
99943 | 99943 | 2020-04-29 | Pamlico | North Carolina | 37137 | 7 | 0 |
99944 | 99944 | 2020-04-29 | Pasquotank | North Carolina | 37139 | 36 | 1 |
99945 | 99945 | 2020-04-29 | Pender | North Carolina | 37141 | 11 | 0 |
99946 | 99946 | 2020-04-29 | Perquimans | North Carolina | 37143 | 13 | 0 |
99947 | 99947 | 2020-04-29 | Person | North Carolina | 37145 | 20 | 1 |
99948 | 99948 | 2020-04-29 | Pitt | North Carolina | 37147 | 120 | 2 |
99949 | 99949 | 2020-04-29 | Polk | North Carolina | 37149 | 19 | 0 |
99950 | 99950 | 2020-04-29 | Randolph | North Carolina | 37151 | 168 | 3 |
99951 | 99951 | 2020-04-29 | Richmond | North Carolina | 37153 | 42 | 2 |
99952 | 99952 | 2020-04-29 | Robeson | North Carolina | 37155 | 145 | 3 |
99953 | 99953 | 2020-04-29 | Rockingham | North Carolina | 37157 | 25 | 2 |
99954 | 99954 | 2020-04-29 | Rowan | North Carolina | 37159 | 366 | 22 |
99955 | 99955 | 2020-04-29 | Rutherford | North Carolina | 37161 | 123 | 6 |
99956 | 99956 | 2020-04-29 | Sampson | North Carolina | 37163 | 51 | 0 |
99957 | 99957 | 2020-04-29 | Scotland | North Carolina | 37165 | 24 | 0 |
99958 | 99958 | 2020-04-29 | Stanly | North Carolina | 37167 | 28 | 4 |
99959 | 99959 | 2020-04-29 | Stokes | North Carolina | 37169 | 11 | 0 |
99960 | 99960 | 2020-04-29 | Surry | North Carolina | 37171 | 13 | 0 |
99961 | 99961 | 2020-04-29 | Swain | North Carolina | 37173 | 3 | 0 |
99962 | 99962 | 2020-04-29 | Transylvania | North Carolina | 37175 | 7 | 0 |
99963 | 99963 | 2020-04-29 | Tyrrell | North Carolina | 37177 | 4 | 0 |
99964 | 99964 | 2020-04-29 | Union | North Carolina | 37179 | 228 | 9 |
99965 | 99965 | 2020-04-29 | Vance | North Carolina | 37181 | 84 | 6 |
99966 | 99966 | 2020-04-29 | Wake | North Carolina | 37183 | 788 | 16 |
99967 | 99967 | 2020-04-29 | Warren | North Carolina | 37185 | 7 | 0 |
99968 | 99968 | 2020-04-29 | Washington | North Carolina | 37187 | 23 | 2 |
99969 | 99969 | 2020-04-29 | Watauga | North Carolina | 37189 | 8 | 0 |
99970 | 99970 | 2020-04-29 | Wayne | North Carolina | 37191 | 645 | 10 |
99971 | 99971 | 2020-04-29 | Wilkes | North Carolina | 37193 | 26 | 1 |
99972 | 99972 | 2020-04-29 | Wilson | North Carolina | 37195 | 152 | 6 |
99973 | 99973 | 2020-04-29 | Yadkin | North Carolina | 37197 | 16 | 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);