ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
100 rows where date = "2020-12-13" 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 |
---|---|---|---|---|---|---|---|
824980 | 824980 | 2020-12-13 | Alamance | North Carolina | 37001 | 8492 | 113 |
824981 | 824981 | 2020-12-13 | Alexander | North Carolina | 37003 | 2044 | 21 |
824982 | 824982 | 2020-12-13 | Alleghany | North Carolina | 37005 | 485 | 1 |
824983 | 824983 | 2020-12-13 | Anson | North Carolina | 37007 | 1108 | 18 |
824984 | 824984 | 2020-12-13 | Ashe | North Carolina | 37009 | 995 | 3 |
824985 | 824985 | 2020-12-13 | Avery | North Carolina | 37011 | 1163 | 13 |
824986 | 824986 | 2020-12-13 | Beaufort | North Carolina | 37013 | 2012 | 58 |
824987 | 824987 | 2020-12-13 | Bertie | North Carolina | 37015 | 1041 | 26 |
824988 | 824988 | 2020-12-13 | Bladen | North Carolina | 37017 | 1533 | 21 |
824989 | 824989 | 2020-12-13 | Brunswick | North Carolina | 37019 | 3610 | 66 |
824990 | 824990 | 2020-12-13 | Buncombe | North Carolina | 37021 | 6913 | 145 |
824991 | 824991 | 2020-12-13 | Burke | North Carolina | 37023 | 5057 | 71 |
824992 | 824992 | 2020-12-13 | Cabarrus | North Carolina | 37025 | 8687 | 113 |
824993 | 824993 | 2020-12-13 | Caldwell | North Carolina | 37027 | 4446 | 25 |
824994 | 824994 | 2020-12-13 | Camden | North Carolina | 37029 | 226 | 4 |
824995 | 824995 | 2020-12-13 | Carteret | North Carolina | 37031 | 2167 | 16 |
824996 | 824996 | 2020-12-13 | Caswell | North Carolina | 37033 | 960 | 8 |
824997 | 824997 | 2020-12-13 | Catawba | North Carolina | 37035 | 8746 | 105 |
824998 | 824998 | 2020-12-13 | Chatham | North Carolina | 37037 | 2584 | 65 |
824999 | 824999 | 2020-12-13 | Cherokee | North Carolina | 37039 | 1066 | 15 |
825000 | 825000 | 2020-12-13 | Chowan | North Carolina | 37041 | 712 | 19 |
825001 | 825001 | 2020-12-13 | Clay | North Carolina | 37043 | 312 | 5 |
825002 | 825002 | 2020-12-13 | Cleveland | North Carolina | 37045 | 5234 | 119 |
825003 | 825003 | 2020-12-13 | Columbus | North Carolina | 37047 | 3037 | 74 |
825004 | 825004 | 2020-12-13 | Craven | North Carolina | 37049 | 3952 | 77 |
825005 | 825005 | 2020-12-13 | Cumberland | North Carolina | 37051 | 11193 | 125 |
825006 | 825006 | 2020-12-13 | Currituck | North Carolina | 37053 | 487 | 6 |
825007 | 825007 | 2020-12-13 | Dare | North Carolina | 37055 | 794 | 4 |
825008 | 825008 | 2020-12-13 | Davidson | North Carolina | 37057 | 6622 | 58 |
825009 | 825009 | 2020-12-13 | Davie | North Carolina | 37059 | 1584 | 13 |
825010 | 825010 | 2020-12-13 | Duplin | North Carolina | 37061 | 3740 | 63 |
825011 | 825011 | 2020-12-13 | Durham | North Carolina | 37063 | 12767 | 128 |
825012 | 825012 | 2020-12-13 | Edgecombe | North Carolina | 37065 | 2873 | 76 |
825013 | 825013 | 2020-12-13 | Forsyth | North Carolina | 37067 | 16568 | 185 |
825014 | 825014 | 2020-12-13 | Franklin | North Carolina | 37069 | 2448 | 36 |
825015 | 825015 | 2020-12-13 | Gaston | North Carolina | 37071 | 12381 | 194 |
825016 | 825016 | 2020-12-13 | Gates | North Carolina | 37073 | 283 | 10 |
825017 | 825017 | 2020-12-13 | Graham | North Carolina | 37075 | 311 | 11 |
825018 | 825018 | 2020-12-13 | Granville | North Carolina | 37077 | 3014 | 60 |
825019 | 825019 | 2020-12-13 | Greene | North Carolina | 37079 | 1339 | 28 |
825020 | 825020 | 2020-12-13 | Guilford | North Carolina | 37081 | 20129 | 276 |
825021 | 825021 | 2020-12-13 | Halifax | North Carolina | 37083 | 2341 | 41 |
825022 | 825022 | 2020-12-13 | Harnett | North Carolina | 37085 | 4844 | 84 |
825023 | 825023 | 2020-12-13 | Haywood | North Carolina | 37087 | 1594 | 53 |
825024 | 825024 | 2020-12-13 | Henderson | North Carolina | 37089 | 3893 | 88 |
825025 | 825025 | 2020-12-13 | Hertford | North Carolina | 37091 | 1141 | 42 |
825026 | 825026 | 2020-12-13 | Hoke | North Carolina | 37093 | 2311 | 34 |
825027 | 825027 | 2020-12-13 | Hyde | North Carolina | 37095 | 201 | 5 |
825028 | 825028 | 2020-12-13 | Iredell | North Carolina | 37097 | 7269 | 61 |
825029 | 825029 | 2020-12-13 | Jackson | North Carolina | 37099 | 1755 | 10 |
825030 | 825030 | 2020-12-13 | Johnston | North Carolina | 37101 | 9291 | 86 |
825031 | 825031 | 2020-12-13 | Jones | North Carolina | 37103 | 322 | 15 |
825032 | 825032 | 2020-12-13 | Lee | North Carolina | 37105 | 2862 | 36 |
825033 | 825033 | 2020-12-13 | Lenoir | North Carolina | 37107 | 2667 | 59 |
825034 | 825034 | 2020-12-13 | Lincoln | North Carolina | 37109 | 4246 | 20 |
825035 | 825035 | 2020-12-13 | Macon | North Carolina | 37113 | 1062 | 9 |
825036 | 825036 | 2020-12-13 | Madison | North Carolina | 37115 | 659 | 17 |
825037 | 825037 | 2020-12-13 | Martin | North Carolina | 37117 | 1002 | 21 |
825038 | 825038 | 2020-12-13 | McDowell | North Carolina | 37111 | 2398 | 36 |
825039 | 825039 | 2020-12-13 | Mecklenburg | North Carolina | 37119 | 51290 | 485 |
825040 | 825040 | 2020-12-13 | Mitchell | North Carolina | 37121 | 684 | 6 |
825041 | 825041 | 2020-12-13 | Montgomery | North Carolina | 37123 | 1600 | 44 |
825042 | 825042 | 2020-12-13 | Moore | North Carolina | 37125 | 3779 | 69 |
825043 | 825043 | 2020-12-13 | Nash | North Carolina | 37127 | 5116 | 113 |
825044 | 825044 | 2020-12-13 | New Hanover | North Carolina | 37129 | 8136 | 68 |
825045 | 825045 | 2020-12-13 | Northampton | North Carolina | 37131 | 917 | 27 |
825046 | 825046 | 2020-12-13 | Onslow | North Carolina | 37133 | 7077 | 49 |
825047 | 825047 | 2020-12-13 | Orange | North Carolina | 37135 | 4405 | 62 |
825048 | 825048 | 2020-12-13 | Pamlico | North Carolina | 37137 | 464 | 5 |
825049 | 825049 | 2020-12-13 | Pasquotank | North Carolina | 37139 | 1312 | 36 |
825050 | 825050 | 2020-12-13 | Pender | North Carolina | 37141 | 2234 | 19 |
825051 | 825051 | 2020-12-13 | Perquimans | North Carolina | 37143 | 413 | 4 |
825052 | 825052 | 2020-12-13 | Person | North Carolina | 37145 | 1259 | 16 |
825053 | 825053 | 2020-12-13 | Pitt | North Carolina | 37147 | 9467 | 59 |
825054 | 825054 | 2020-12-13 | Polk | North Carolina | 37149 | 565 | 13 |
825055 | 825055 | 2020-12-13 | Randolph | North Carolina | 37151 | 6570 | 102 |
825056 | 825056 | 2020-12-13 | Richmond | North Carolina | 37153 | 2240 | 41 |
825057 | 825057 | 2020-12-13 | Robeson | North Carolina | 37155 | 8282 | 114 |
825058 | 825058 | 2020-12-13 | Rockingham | North Carolina | 37157 | 3697 | 23 |
825059 | 825059 | 2020-12-13 | Rowan | North Carolina | 37159 | 7060 | 150 |
825060 | 825060 | 2020-12-13 | Rutherford | North Carolina | 37161 | 3213 | 94 |
825061 | 825061 | 2020-12-13 | Sampson | North Carolina | 37163 | 4208 | 53 |
825062 | 825062 | 2020-12-13 | Scotland | North Carolina | 37165 | 2225 | 46 |
825063 | 825063 | 2020-12-13 | Stanly | North Carolina | 37167 | 3520 | 78 |
825064 | 825064 | 2020-12-13 | Stokes | North Carolina | 37169 | 1480 | 22 |
825065 | 825065 | 2020-12-13 | Surry | North Carolina | 37171 | 3439 | 52 |
825066 | 825066 | 2020-12-13 | Swain | North Carolina | 37173 | 482 | 5 |
825067 | 825067 | 2020-12-13 | Transylvania | North Carolina | 37175 | 685 | 10 |
825068 | 825068 | 2020-12-13 | Tyrrell | North Carolina | 37177 | 158 | 3 |
825069 | 825069 | 2020-12-13 | Union | North Carolina | 37179 | 9645 | 84 |
825070 | 825070 | 2020-12-13 | Vance | North Carolina | 37181 | 2182 | 61 |
825071 | 825071 | 2020-12-13 | Wake | North Carolina | 37183 | 35029 | 323 |
825072 | 825072 | 2020-12-13 | Warren | North Carolina | 37185 | 949 | 9 |
825073 | 825073 | 2020-12-13 | Washington | North Carolina | 37187 | 367 | 8 |
825074 | 825074 | 2020-12-13 | Watauga | North Carolina | 37189 | 2295 | 8 |
825075 | 825075 | 2020-12-13 | Wayne | North Carolina | 37191 | 6605 | 127 |
825076 | 825076 | 2020-12-13 | Wilkes | North Carolina | 37193 | 3192 | 62 |
825077 | 825077 | 2020-12-13 | Wilson | North Carolina | 37195 | 4707 | 89 |
825078 | 825078 | 2020-12-13 | Yadkin | North Carolina | 37197 | 1943 | 21 |
825079 | 825079 | 2020-12-13 | Yancey | North Carolina | 37199 | 791 | 4 |
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);