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-12-01 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 |
---|---|---|---|---|---|---|---|
786036 | 786036 | 2020-12-01 | Alamance | North Carolina | 37001 | 7249 | 97 |
786037 | 786037 | 2020-12-01 | Alexander | North Carolina | 37003 | 1663 | 17 |
786038 | 786038 | 2020-12-01 | Alleghany | North Carolina | 37005 | 397 | 1 |
786039 | 786039 | 2020-12-01 | Anson | North Carolina | 37007 | 941 | 14 |
786040 | 786040 | 2020-12-01 | Ashe | North Carolina | 37009 | 795 | 3 |
786041 | 786041 | 2020-12-01 | Avery | North Carolina | 37011 | 977 | 8 |
786042 | 786042 | 2020-12-01 | Beaufort | North Carolina | 37013 | 1729 | 54 |
786043 | 786043 | 2020-12-01 | Bertie | North Carolina | 37015 | 905 | 24 |
786044 | 786044 | 2020-12-01 | Bladen | North Carolina | 37017 | 1353 | 19 |
786045 | 786045 | 2020-12-01 | Brunswick | North Carolina | 37019 | 3068 | 60 |
786046 | 786046 | 2020-12-01 | Buncombe | North Carolina | 37021 | 5713 | 142 |
786047 | 786047 | 2020-12-01 | Burke | North Carolina | 37023 | 4026 | 64 |
786048 | 786048 | 2020-12-01 | Cabarrus | North Carolina | 37025 | 7116 | 107 |
786049 | 786049 | 2020-12-01 | Caldwell | North Carolina | 37027 | 3626 | 21 |
786050 | 786050 | 2020-12-01 | Camden | North Carolina | 37029 | 188 | 4 |
786051 | 786051 | 2020-12-01 | Carteret | North Carolina | 37031 | 1756 | 14 |
786052 | 786052 | 2020-12-01 | Caswell | North Carolina | 37033 | 854 | 7 |
786053 | 786053 | 2020-12-01 | Catawba | North Carolina | 37035 | 7052 | 89 |
786054 | 786054 | 2020-12-01 | Chatham | North Carolina | 37037 | 2378 | 65 |
786055 | 786055 | 2020-12-01 | Cherokee | North Carolina | 37039 | 946 | 15 |
786056 | 786056 | 2020-12-01 | Chowan | North Carolina | 37041 | 644 | 18 |
786057 | 786057 | 2020-12-01 | Clay | North Carolina | 37043 | 284 | 5 |
786058 | 786058 | 2020-12-01 | Cleveland | North Carolina | 37045 | 4378 | 110 |
786059 | 786059 | 2020-12-01 | Columbus | North Carolina | 37047 | 2766 | 71 |
786060 | 786060 | 2020-12-01 | Craven | North Carolina | 37049 | 3157 | 70 |
786061 | 786061 | 2020-12-01 | Cumberland | North Carolina | 37051 | 9557 | 115 |
786062 | 786062 | 2020-12-01 | Currituck | North Carolina | 37053 | 332 | 5 |
786063 | 786063 | 2020-12-01 | Dare | North Carolina | 37055 | 654 | 4 |
786064 | 786064 | 2020-12-01 | Davidson | North Carolina | 37057 | 5426 | 51 |
786065 | 786065 | 2020-12-01 | Davie | North Carolina | 37059 | 1268 | 13 |
786066 | 786066 | 2020-12-01 | Duplin | North Carolina | 37061 | 3384 | 62 |
786067 | 786067 | 2020-12-01 | Durham | North Carolina | 37063 | 11559 | 122 |
786068 | 786068 | 2020-12-01 | Edgecombe | North Carolina | 37065 | 2567 | 71 |
786069 | 786069 | 2020-12-01 | Forsyth | North Carolina | 37067 | 13538 | 166 |
786070 | 786070 | 2020-12-01 | Franklin | North Carolina | 37069 | 2045 | 33 |
786071 | 786071 | 2020-12-01 | Gaston | North Carolina | 37071 | 10373 | 186 |
786072 | 786072 | 2020-12-01 | Gates | North Carolina | 37073 | 220 | 6 |
786073 | 786073 | 2020-12-01 | Graham | North Carolina | 37075 | 275 | 11 |
786074 | 786074 | 2020-12-01 | Granville | North Carolina | 37077 | 2536 | 57 |
786075 | 786075 | 2020-12-01 | Greene | North Carolina | 37079 | 1205 | 25 |
786076 | 786076 | 2020-12-01 | Guilford | North Carolina | 37081 | 16987 | 239 |
786077 | 786077 | 2020-12-01 | Halifax | North Carolina | 37083 | 1996 | 36 |
786078 | 786078 | 2020-12-01 | Harnett | North Carolina | 37085 | 4044 | 77 |
786079 | 786079 | 2020-12-01 | Haywood | North Carolina | 37087 | 1230 | 40 |
786080 | 786080 | 2020-12-01 | Henderson | North Carolina | 37089 | 3294 | 74 |
786081 | 786081 | 2020-12-01 | Hertford | North Carolina | 37091 | 993 | 41 |
786082 | 786082 | 2020-12-01 | Hoke | North Carolina | 37093 | 1979 | 31 |
786083 | 786083 | 2020-12-01 | Hyde | North Carolina | 37095 | 186 | 5 |
786084 | 786084 | 2020-12-01 | Iredell | North Carolina | 37097 | 5675 | 51 |
786085 | 786085 | 2020-12-01 | Jackson | North Carolina | 37099 | 1409 | 10 |
786086 | 786086 | 2020-12-01 | Johnston | North Carolina | 37101 | 7932 | 79 |
786087 | 786087 | 2020-12-01 | Jones | North Carolina | 37103 | 277 | 15 |
786088 | 786088 | 2020-12-01 | Lee | North Carolina | 37105 | 2511 | 30 |
786089 | 786089 | 2020-12-01 | Lenoir | North Carolina | 37107 | 2187 | 52 |
786090 | 786090 | 2020-12-01 | Lincoln | North Carolina | 37109 | 3509 | 20 |
786091 | 786091 | 2020-12-01 | Macon | North Carolina | 37113 | 948 | 9 |
786092 | 786092 | 2020-12-01 | Madison | North Carolina | 37115 | 536 | 17 |
786093 | 786093 | 2020-12-01 | Martin | North Carolina | 37117 | 852 | 21 |
786094 | 786094 | 2020-12-01 | McDowell | North Carolina | 37111 | 1906 | 34 |
786095 | 786095 | 2020-12-01 | Mecklenburg | North Carolina | 37119 | 43983 | 456 |
786096 | 786096 | 2020-12-01 | Mitchell | North Carolina | 37121 | 533 | 6 |
786097 | 786097 | 2020-12-01 | Montgomery | North Carolina | 37123 | 1413 | 41 |
786098 | 786098 | 2020-12-01 | Moore | North Carolina | 37125 | 2970 | 65 |
786099 | 786099 | 2020-12-01 | Nash | North Carolina | 37127 | 4474 | 108 |
786100 | 786100 | 2020-12-01 | New Hanover | North Carolina | 37129 | 7076 | 55 |
786101 | 786101 | 2020-12-01 | Northampton | North Carolina | 37131 | 825 | 25 |
786102 | 786102 | 2020-12-01 | Onslow | North Carolina | 37133 | 5445 | 43 |
786103 | 786103 | 2020-12-01 | Orange | North Carolina | 37135 | 3934 | 62 |
786104 | 786104 | 2020-12-01 | Pamlico | North Carolina | 37137 | 406 | 3 |
786105 | 786105 | 2020-12-01 | Pasquotank | North Carolina | 37139 | 1122 | 35 |
786106 | 786106 | 2020-12-01 | Pender | North Carolina | 37141 | 1919 | 17 |
786107 | 786107 | 2020-12-01 | Perquimans | North Carolina | 37143 | 352 | 4 |
786108 | 786108 | 2020-12-01 | Person | North Carolina | 37145 | 1011 | 11 |
786109 | 786109 | 2020-12-01 | Pitt | North Carolina | 37147 | 7977 | 48 |
786110 | 786110 | 2020-12-01 | Polk | North Carolina | 37149 | 481 | 13 |
786111 | 786111 | 2020-12-01 | Randolph | North Carolina | 37151 | 5489 | 87 |
786112 | 786112 | 2020-12-01 | Richmond | North Carolina | 37153 | 1867 | 38 |
786113 | 786113 | 2020-12-01 | Robeson | North Carolina | 37155 | 7425 | 111 |
786114 | 786114 | 2020-12-01 | Rockingham | North Carolina | 37157 | 3132 | 22 |
786115 | 786115 | 2020-12-01 | Rowan | North Carolina | 37159 | 5794 | 133 |
786116 | 786116 | 2020-12-01 | Rutherford | North Carolina | 37161 | 2501 | 86 |
786117 | 786117 | 2020-12-01 | Sampson | North Carolina | 37163 | 3710 | 43 |
786118 | 786118 | 2020-12-01 | Scotland | North Carolina | 37165 | 1978 | 42 |
786119 | 786119 | 2020-12-01 | Stanly | North Carolina | 37167 | 3013 | 78 |
786120 | 786120 | 2020-12-01 | Stokes | North Carolina | 37169 | 1179 | 17 |
786121 | 786121 | 2020-12-01 | Surry | North Carolina | 37171 | 2839 | 44 |
786122 | 786122 | 2020-12-01 | Swain | North Carolina | 37173 | 398 | 5 |
786123 | 786123 | 2020-12-01 | Transylvania | North Carolina | 37175 | 561 | 9 |
786124 | 786124 | 2020-12-01 | Tyrrell | North Carolina | 37177 | 140 | 3 |
786125 | 786125 | 2020-12-01 | Union | North Carolina | 37179 | 7989 | 76 |
786126 | 786126 | 2020-12-01 | Vance | North Carolina | 37181 | 1799 | 55 |
786127 | 786127 | 2020-12-01 | Wake | North Carolina | 37183 | 29779 | 289 |
786128 | 786128 | 2020-12-01 | Warren | North Carolina | 37185 | 701 | 8 |
786129 | 786129 | 2020-12-01 | Washington | North Carolina | 37187 | 321 | 8 |
786130 | 786130 | 2020-12-01 | Watauga | North Carolina | 37189 | 1916 | 8 |
786131 | 786131 | 2020-12-01 | Wayne | North Carolina | 37191 | 5837 | 113 |
786132 | 786132 | 2020-12-01 | Wilkes | North Carolina | 37193 | 2733 | 51 |
786133 | 786133 | 2020-12-01 | Wilson | North Carolina | 37195 | 4111 | 81 |
786134 | 786134 | 2020-12-01 | Yadkin | North Carolina | 37197 | 1563 | 14 |
786135 | 786135 | 2020-12-01 | Yancey | North Carolina | 37199 | 568 | 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);