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-17 and state = "North Carolina" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
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 |
---|---|---|---|---|---|---|---|
837965 | 837965 | 2020-12-17 | Alamance | North Carolina | 37001 | 8919 | 114 |
837966 | 837966 | 2020-12-17 | Alexander | North Carolina | 37003 | 2133 | 21 |
837967 | 837967 | 2020-12-17 | Alleghany | North Carolina | 37005 | 519 | 2 |
837968 | 837968 | 2020-12-17 | Anson | North Carolina | 37007 | 1207 | 19 |
837969 | 837969 | 2020-12-17 | Ashe | North Carolina | 37009 | 1041 | 16 |
837970 | 837970 | 2020-12-17 | Avery | North Carolina | 37011 | 1224 | 13 |
837971 | 837971 | 2020-12-17 | Beaufort | North Carolina | 37013 | 2097 | 58 |
837972 | 837972 | 2020-12-17 | Bertie | North Carolina | 37015 | 1080 | 26 |
837973 | 837973 | 2020-12-17 | Bladen | North Carolina | 37017 | 1611 | 23 |
837974 | 837974 | 2020-12-17 | Brunswick | North Carolina | 37019 | 3761 | 70 |
837975 | 837975 | 2020-12-17 | Buncombe | North Carolina | 37021 | 7359 | 148 |
837976 | 837976 | 2020-12-17 | Burke | North Carolina | 37023 | 5270 | 73 |
837977 | 837977 | 2020-12-17 | Cabarrus | North Carolina | 37025 | 9201 | 120 |
837978 | 837978 | 2020-12-17 | Caldwell | North Carolina | 37027 | 4685 | 27 |
837979 | 837979 | 2020-12-17 | Camden | North Carolina | 37029 | 236 | 4 |
837980 | 837980 | 2020-12-17 | Carteret | North Carolina | 37031 | 2298 | 16 |
837981 | 837981 | 2020-12-17 | Caswell | North Carolina | 37033 | 993 | 8 |
837982 | 837982 | 2020-12-17 | Catawba | North Carolina | 37035 | 9269 | 118 |
837983 | 837983 | 2020-12-17 | Chatham | North Carolina | 37037 | 2635 | 65 |
837984 | 837984 | 2020-12-17 | Cherokee | North Carolina | 37039 | 1091 | 15 |
837985 | 837985 | 2020-12-17 | Chowan | North Carolina | 37041 | 739 | 19 |
837986 | 837986 | 2020-12-17 | Clay | North Carolina | 37043 | 316 | 5 |
837987 | 837987 | 2020-12-17 | Cleveland | North Carolina | 37045 | 5512 | 130 |
837988 | 837988 | 2020-12-17 | Columbus | North Carolina | 37047 | 3125 | 77 |
837989 | 837989 | 2020-12-17 | Craven | North Carolina | 37049 | 4209 | 79 |
837990 | 837990 | 2020-12-17 | Cumberland | North Carolina | 37051 | 11782 | 130 |
837991 | 837991 | 2020-12-17 | Currituck | North Carolina | 37053 | 522 | 8 |
837992 | 837992 | 2020-12-17 | Dare | North Carolina | 37055 | 818 | 4 |
837993 | 837993 | 2020-12-17 | Davidson | North Carolina | 37057 | 7045 | 66 |
837994 | 837994 | 2020-12-17 | Davie | North Carolina | 37059 | 1723 | 13 |
837995 | 837995 | 2020-12-17 | Duplin | North Carolina | 37061 | 3824 | 63 |
837996 | 837996 | 2020-12-17 | Durham | North Carolina | 37063 | 13574 | 133 |
837997 | 837997 | 2020-12-17 | Edgecombe | North Carolina | 37065 | 2940 | 78 |
837998 | 837998 | 2020-12-17 | Forsyth | North Carolina | 37067 | 17429 | 196 |
837999 | 837999 | 2020-12-17 | Franklin | North Carolina | 37069 | 2557 | 37 |
838000 | 838000 | 2020-12-17 | Gaston | North Carolina | 37071 | 12917 | 203 |
838001 | 838001 | 2020-12-17 | Gates | North Carolina | 37073 | 302 | 11 |
838002 | 838002 | 2020-12-17 | Graham | North Carolina | 37075 | 324 | 11 |
838003 | 838003 | 2020-12-17 | Granville | North Carolina | 37077 | 3177 | 60 |
838004 | 838004 | 2020-12-17 | Greene | North Carolina | 37079 | 1396 | 28 |
838005 | 838005 | 2020-12-17 | Guilford | North Carolina | 37081 | 21086 | 290 |
838006 | 838006 | 2020-12-17 | Halifax | North Carolina | 37083 | 2424 | 44 |
838007 | 838007 | 2020-12-17 | Harnett | North Carolina | 37085 | 5111 | 88 |
838008 | 838008 | 2020-12-17 | Haywood | North Carolina | 37087 | 1691 | 55 |
838009 | 838009 | 2020-12-17 | Henderson | North Carolina | 37089 | 4188 | 91 |
838010 | 838010 | 2020-12-17 | Hertford | North Carolina | 37091 | 1181 | 44 |
838011 | 838011 | 2020-12-17 | Hoke | North Carolina | 37093 | 2409 | 34 |
838012 | 838012 | 2020-12-17 | Hyde | North Carolina | 37095 | 220 | 5 |
838013 | 838013 | 2020-12-17 | Iredell | North Carolina | 37097 | 7692 | 61 |
838014 | 838014 | 2020-12-17 | Jackson | North Carolina | 37099 | 1897 | 12 |
838015 | 838015 | 2020-12-17 | Johnston | North Carolina | 37101 | 9895 | 92 |
838016 | 838016 | 2020-12-17 | Jones | North Carolina | 37103 | 338 | 15 |
838017 | 838017 | 2020-12-17 | Lee | North Carolina | 37105 | 2987 | 37 |
838018 | 838018 | 2020-12-17 | Lenoir | North Carolina | 37107 | 2762 | 62 |
838019 | 838019 | 2020-12-17 | Lincoln | North Carolina | 37109 | 4487 | 20 |
838020 | 838020 | 2020-12-17 | Macon | North Carolina | 37113 | 1122 | 9 |
838021 | 838021 | 2020-12-17 | Madison | North Carolina | 37115 | 694 | 18 |
838022 | 838022 | 2020-12-17 | Martin | North Carolina | 37117 | 1096 | 23 |
838023 | 838023 | 2020-12-17 | McDowell | North Carolina | 37111 | 2551 | 38 |
838024 | 838024 | 2020-12-17 | Mecklenburg | North Carolina | 37119 | 53979 | 508 |
838025 | 838025 | 2020-12-17 | Mitchell | North Carolina | 37121 | 740 | 7 |
838026 | 838026 | 2020-12-17 | Montgomery | North Carolina | 37123 | 1685 | 44 |
838027 | 838027 | 2020-12-17 | Moore | North Carolina | 37125 | 4032 | 72 |
838028 | 838028 | 2020-12-17 | Nash | North Carolina | 37127 | 5266 | 116 |
838029 | 838029 | 2020-12-17 | New Hanover | North Carolina | 37129 | 8435 | 68 |
838030 | 838030 | 2020-12-17 | Northampton | North Carolina | 37131 | 947 | 27 |
838031 | 838031 | 2020-12-17 | Onslow | North Carolina | 37133 | 7383 | 54 |
838032 | 838032 | 2020-12-17 | Orange | North Carolina | 37135 | 4528 | 62 |
838033 | 838033 | 2020-12-17 | Pamlico | North Carolina | 37137 | 479 | 5 |
838034 | 838034 | 2020-12-17 | Pasquotank | North Carolina | 37139 | 1388 | 38 |
838035 | 838035 | 2020-12-17 | Pender | North Carolina | 37141 | 2362 | 20 |
838036 | 838036 | 2020-12-17 | Perquimans | North Carolina | 37143 | 429 | 4 |
838037 | 838037 | 2020-12-17 | Person | North Carolina | 37145 | 1331 | 18 |
838038 | 838038 | 2020-12-17 | Pitt | North Carolina | 37147 | 9778 | 64 |
838039 | 838039 | 2020-12-17 | Polk | North Carolina | 37149 | 582 | 13 |
838040 | 838040 | 2020-12-17 | Randolph | North Carolina | 37151 | 6867 | 107 |
838041 | 838041 | 2020-12-17 | Richmond | North Carolina | 37153 | 2344 | 43 |
838042 | 838042 | 2020-12-17 | Robeson | North Carolina | 37155 | 8556 | 115 |
838043 | 838043 | 2020-12-17 | Rockingham | North Carolina | 37157 | 3832 | 23 |
838044 | 838044 | 2020-12-17 | Rowan | North Carolina | 37159 | 7403 | 155 |
838045 | 838045 | 2020-12-17 | Rutherford | North Carolina | 37161 | 3452 | 100 |
838046 | 838046 | 2020-12-17 | Sampson | North Carolina | 37163 | 4327 | 56 |
838047 | 838047 | 2020-12-17 | Scotland | North Carolina | 37165 | 2302 | 50 |
838048 | 838048 | 2020-12-17 | Stanly | North Carolina | 37167 | 3689 | 78 |
838049 | 838049 | 2020-12-17 | Stokes | North Carolina | 37169 | 1601 | 23 |
838050 | 838050 | 2020-12-17 | Surry | North Carolina | 37171 | 3645 | 53 |
838051 | 838051 | 2020-12-17 | Swain | North Carolina | 37173 | 526 | 5 |
838052 | 838052 | 2020-12-17 | Transylvania | North Carolina | 37175 | 730 | 10 |
838053 | 838053 | 2020-12-17 | Tyrrell | North Carolina | 37177 | 159 | 3 |
838054 | 838054 | 2020-12-17 | Union | North Carolina | 37179 | 10201 | 87 |
838055 | 838055 | 2020-12-17 | Vance | North Carolina | 37181 | 2288 | 63 |
838056 | 838056 | 2020-12-17 | Wake | North Carolina | 37183 | 37236 | 328 |
838057 | 838057 | 2020-12-17 | Warren | North Carolina | 37185 | 983 | 9 |
838058 | 838058 | 2020-12-17 | Washington | North Carolina | 37187 | 372 | 10 |
838059 | 838059 | 2020-12-17 | Watauga | North Carolina | 37189 | 2356 | 14 |
838060 | 838060 | 2020-12-17 | Wayne | North Carolina | 37191 | 6718 | 131 |
838061 | 838061 | 2020-12-17 | Wilkes | North Carolina | 37193 | 3338 | 66 |
838062 | 838062 | 2020-12-17 | Wilson | North Carolina | 37195 | 4851 | 94 |
838063 | 838063 | 2020-12-17 | Yadkin | North Carolina | 37197 | 2061 | 24 |
838064 | 838064 | 2020-12-17 | Yancey | North Carolina | 37199 | 867 | 8 |
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);