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-09 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 |
---|---|---|---|---|---|---|---|
811996 | 811996 | 2020-12-09 | Alamance | North Carolina | 37001 | 8094 | 112 |
811997 | 811997 | 2020-12-09 | Alexander | North Carolina | 37003 | 1923 | 19 |
811998 | 811998 | 2020-12-09 | Alleghany | North Carolina | 37005 | 445 | 1 |
811999 | 811999 | 2020-12-09 | Anson | North Carolina | 37007 | 1047 | 18 |
812000 | 812000 | 2020-12-09 | Ashe | North Carolina | 37009 | 935 | 3 |
812001 | 812001 | 2020-12-09 | Avery | North Carolina | 37011 | 1105 | 10 |
812002 | 812002 | 2020-12-09 | Beaufort | North Carolina | 37013 | 1904 | 56 |
812003 | 812003 | 2020-12-09 | Bertie | North Carolina | 37015 | 995 | 26 |
812004 | 812004 | 2020-12-09 | Bladen | North Carolina | 37017 | 1463 | 20 |
812005 | 812005 | 2020-12-09 | Brunswick | North Carolina | 37019 | 3425 | 66 |
812006 | 812006 | 2020-12-09 | Buncombe | North Carolina | 37021 | 6438 | 145 |
812007 | 812007 | 2020-12-09 | Burke | North Carolina | 37023 | 4750 | 68 |
812008 | 812008 | 2020-12-09 | Cabarrus | North Carolina | 37025 | 8112 | 111 |
812009 | 812009 | 2020-12-09 | Caldwell | North Carolina | 37027 | 4115 | 25 |
812010 | 812010 | 2020-12-09 | Camden | North Carolina | 37029 | 214 | 4 |
812011 | 812011 | 2020-12-09 | Carteret | North Carolina | 37031 | 2024 | 16 |
812012 | 812012 | 2020-12-09 | Caswell | North Carolina | 37033 | 908 | 8 |
812013 | 812013 | 2020-12-09 | Catawba | North Carolina | 37035 | 8119 | 102 |
812014 | 812014 | 2020-12-09 | Chatham | North Carolina | 37037 | 2497 | 65 |
812015 | 812015 | 2020-12-09 | Cherokee | North Carolina | 37039 | 1026 | 15 |
812016 | 812016 | 2020-12-09 | Chowan | North Carolina | 37041 | 689 | 18 |
812017 | 812017 | 2020-12-09 | Clay | North Carolina | 37043 | 303 | 5 |
812018 | 812018 | 2020-12-09 | Cleveland | North Carolina | 37045 | 4891 | 115 |
812019 | 812019 | 2020-12-09 | Columbus | North Carolina | 37047 | 2932 | 74 |
812020 | 812020 | 2020-12-09 | Craven | North Carolina | 37049 | 3659 | 75 |
812021 | 812021 | 2020-12-09 | Cumberland | North Carolina | 37051 | 10545 | 124 |
812022 | 812022 | 2020-12-09 | Currituck | North Carolina | 37053 | 431 | 5 |
812023 | 812023 | 2020-12-09 | Dare | North Carolina | 37055 | 744 | 4 |
812024 | 812024 | 2020-12-09 | Davidson | North Carolina | 37057 | 6164 | 58 |
812025 | 812025 | 2020-12-09 | Davie | North Carolina | 37059 | 1470 | 13 |
812026 | 812026 | 2020-12-09 | Duplin | North Carolina | 37061 | 3587 | 63 |
812027 | 812027 | 2020-12-09 | Durham | North Carolina | 37063 | 12431 | 128 |
812028 | 812028 | 2020-12-09 | Edgecombe | North Carolina | 37065 | 2754 | 74 |
812029 | 812029 | 2020-12-09 | Forsyth | North Carolina | 37067 | 15480 | 176 |
812030 | 812030 | 2020-12-09 | Franklin | North Carolina | 37069 | 2306 | 34 |
812031 | 812031 | 2020-12-09 | Gaston | North Carolina | 37071 | 11645 | 193 |
812032 | 812032 | 2020-12-09 | Gates | North Carolina | 37073 | 262 | 10 |
812033 | 812033 | 2020-12-09 | Graham | North Carolina | 37075 | 296 | 11 |
812034 | 812034 | 2020-12-09 | Granville | North Carolina | 37077 | 2794 | 59 |
812035 | 812035 | 2020-12-09 | Greene | North Carolina | 37079 | 1295 | 28 |
812036 | 812036 | 2020-12-09 | Guilford | North Carolina | 37081 | 19009 | 272 |
812037 | 812037 | 2020-12-09 | Halifax | North Carolina | 37083 | 2184 | 38 |
812038 | 812038 | 2020-12-09 | Harnett | North Carolina | 37085 | 4590 | 79 |
812039 | 812039 | 2020-12-09 | Haywood | North Carolina | 37087 | 1481 | 43 |
812040 | 812040 | 2020-12-09 | Henderson | North Carolina | 37089 | 3576 | 88 |
812041 | 812041 | 2020-12-09 | Hertford | North Carolina | 37091 | 1078 | 42 |
812042 | 812042 | 2020-12-09 | Hoke | North Carolina | 37093 | 2181 | 34 |
812043 | 812043 | 2020-12-09 | Hyde | North Carolina | 37095 | 192 | 5 |
812044 | 812044 | 2020-12-09 | Iredell | North Carolina | 37097 | 6652 | 58 |
812045 | 812045 | 2020-12-09 | Jackson | North Carolina | 37099 | 1613 | 10 |
812046 | 812046 | 2020-12-09 | Johnston | North Carolina | 37101 | 8912 | 83 |
812047 | 812047 | 2020-12-09 | Jones | North Carolina | 37103 | 312 | 15 |
812048 | 812048 | 2020-12-09 | Lee | North Carolina | 37105 | 2735 | 34 |
812049 | 812049 | 2020-12-09 | Lenoir | North Carolina | 37107 | 2503 | 55 |
812050 | 812050 | 2020-12-09 | Lincoln | North Carolina | 37109 | 4002 | 20 |
812051 | 812051 | 2020-12-09 | Macon | North Carolina | 37113 | 1017 | 9 |
812052 | 812052 | 2020-12-09 | Madison | North Carolina | 37115 | 611 | 17 |
812053 | 812053 | 2020-12-09 | Martin | North Carolina | 37117 | 946 | 21 |
812054 | 812054 | 2020-12-09 | McDowell | North Carolina | 37111 | 2235 | 36 |
812055 | 812055 | 2020-12-09 | Mecklenburg | North Carolina | 37119 | 48673 | 481 |
812056 | 812056 | 2020-12-09 | Mitchell | North Carolina | 37121 | 631 | 6 |
812057 | 812057 | 2020-12-09 | Montgomery | North Carolina | 37123 | 1529 | 43 |
812058 | 812058 | 2020-12-09 | Moore | North Carolina | 37125 | 3492 | 66 |
812059 | 812059 | 2020-12-09 | Nash | North Carolina | 37127 | 4847 | 112 |
812060 | 812060 | 2020-12-09 | New Hanover | North Carolina | 37129 | 7719 | 62 |
812061 | 812061 | 2020-12-09 | Northampton | North Carolina | 37131 | 890 | 26 |
812062 | 812062 | 2020-12-09 | Onslow | North Carolina | 37133 | 6308 | 47 |
812063 | 812063 | 2020-12-09 | Orange | North Carolina | 37135 | 4215 | 62 |
812064 | 812064 | 2020-12-09 | Pamlico | North Carolina | 37137 | 441 | 4 |
812065 | 812065 | 2020-12-09 | Pasquotank | North Carolina | 37139 | 1215 | 35 |
812066 | 812066 | 2020-12-09 | Pender | North Carolina | 37141 | 2065 | 17 |
812067 | 812067 | 2020-12-09 | Perquimans | North Carolina | 37143 | 381 | 4 |
812068 | 812068 | 2020-12-09 | Person | North Carolina | 37145 | 1152 | 14 |
812069 | 812069 | 2020-12-09 | Pitt | North Carolina | 37147 | 8884 | 58 |
812070 | 812070 | 2020-12-09 | Polk | North Carolina | 37149 | 534 | 13 |
812071 | 812071 | 2020-12-09 | Randolph | North Carolina | 37151 | 6156 | 98 |
812072 | 812072 | 2020-12-09 | Richmond | North Carolina | 37153 | 2126 | 40 |
812073 | 812073 | 2020-12-09 | Robeson | North Carolina | 37155 | 7937 | 114 |
812074 | 812074 | 2020-12-09 | Rockingham | North Carolina | 37157 | 3450 | 23 |
812075 | 812075 | 2020-12-09 | Rowan | North Carolina | 37159 | 6564 | 146 |
812076 | 812076 | 2020-12-09 | Rutherford | North Carolina | 37161 | 2941 | 92 |
812077 | 812077 | 2020-12-09 | Sampson | North Carolina | 37163 | 4022 | 51 |
812078 | 812078 | 2020-12-09 | Scotland | North Carolina | 37165 | 2132 | 43 |
812079 | 812079 | 2020-12-09 | Stanly | North Carolina | 37167 | 3348 | 78 |
812080 | 812080 | 2020-12-09 | Stokes | North Carolina | 37169 | 1376 | 21 |
812081 | 812081 | 2020-12-09 | Surry | North Carolina | 37171 | 3187 | 49 |
812082 | 812082 | 2020-12-09 | Swain | North Carolina | 37173 | 459 | 5 |
812083 | 812083 | 2020-12-09 | Transylvania | North Carolina | 37175 | 622 | 9 |
812084 | 812084 | 2020-12-09 | Tyrrell | North Carolina | 37177 | 153 | 3 |
812085 | 812085 | 2020-12-09 | Union | North Carolina | 37179 | 9130 | 82 |
812086 | 812086 | 2020-12-09 | Vance | North Carolina | 37181 | 2033 | 60 |
812087 | 812087 | 2020-12-09 | Wake | North Carolina | 37183 | 33769 | 315 |
812088 | 812088 | 2020-12-09 | Warren | North Carolina | 37185 | 881 | 8 |
812089 | 812089 | 2020-12-09 | Washington | North Carolina | 37187 | 345 | 8 |
812090 | 812090 | 2020-12-09 | Watauga | North Carolina | 37189 | 2202 | 8 |
812091 | 812091 | 2020-12-09 | Wayne | North Carolina | 37191 | 6305 | 120 |
812092 | 812092 | 2020-12-09 | Wilkes | North Carolina | 37193 | 3036 | 58 |
812093 | 812093 | 2020-12-09 | Wilson | North Carolina | 37195 | 4465 | 86 |
812094 | 812094 | 2020-12-09 | Yadkin | North Carolina | 37197 | 1782 | 19 |
812095 | 812095 | 2020-12-09 | Yancey | North Carolina | 37199 | 697 | 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);