ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
100 rows where date = "2022-03-29" 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 |
---|---|---|---|---|---|---|---|
2354976 | 2354976 | 2022-03-29 | Alamance | North Carolina | 37001 | 46699 | 452 |
2354977 | 2354977 | 2022-03-29 | Alexander | North Carolina | 37003 | 10420 | 133 |
2354978 | 2354978 | 2022-03-29 | Alleghany | North Carolina | 37005 | 2941 | 12 |
2354979 | 2354979 | 2022-03-29 | Anson | North Carolina | 37007 | 6543 | 96 |
2354980 | 2354980 | 2022-03-29 | Ashe | North Carolina | 37009 | 6374 | 73 |
2354981 | 2354981 | 2022-03-29 | Avery | North Carolina | 37011 | 4498 | 42 |
2354982 | 2354982 | 2022-03-29 | Beaufort | North Carolina | 37013 | 12339 | 160 |
2354983 | 2354983 | 2022-03-29 | Bertie | North Carolina | 37015 | 4232 | 67 |
2354984 | 2354984 | 2022-03-29 | Bladen | North Carolina | 37017 | 9311 | 121 |
2354985 | 2354985 | 2022-03-29 | Brunswick | North Carolina | 37019 | 29728 | 309 |
2354986 | 2354986 | 2022-03-29 | Buncombe | North Carolina | 37021 | 52180 | 559 |
2354987 | 2354987 | 2022-03-29 | Burke | North Carolina | 37023 | 25031 | 316 |
2354988 | 2354988 | 2022-03-29 | Cabarrus | North Carolina | 37025 | 55471 | 468 |
2354989 | 2354989 | 2022-03-29 | Caldwell | North Carolina | 37027 | 22156 | 299 |
2354990 | 2354990 | 2022-03-29 | Camden | North Carolina | 37029 | 1747 | 9 |
2354991 | 2354991 | 2022-03-29 | Carteret | North Carolina | 37031 | 14069 | 85 |
2354992 | 2354992 | 2022-03-29 | Caswell | North Carolina | 37033 | 5261 | 44 |
2354993 | 2354993 | 2022-03-29 | Catawba | North Carolina | 37035 | 47536 | 566 |
2354994 | 2354994 | 2022-03-29 | Chatham | North Carolina | 37037 | 12716 | 108 |
2354995 | 2354995 | 2022-03-29 | Cherokee | North Carolina | 37039 | 7097 | 117 |
2354996 | 2354996 | 2022-03-29 | Chowan | North Carolina | 37041 | 4124 | 54 |
2354997 | 2354997 | 2022-03-29 | Clay | North Carolina | 37043 | 2641 | 39 |
2354998 | 2354998 | 2022-03-29 | Cleveland | North Carolina | 37045 | 29526 | 364 |
2354999 | 2354999 | 2022-03-29 | Columbus | North Carolina | 37047 | 15909 | 266 |
2355000 | 2355000 | 2022-03-29 | Craven | North Carolina | 37049 | 24115 | 195 |
2355001 | 2355001 | 2022-03-29 | Cumberland | North Carolina | 37051 | 84086 | 563 |
2355002 | 2355002 | 2022-03-29 | Currituck | North Carolina | 37053 | 4973 | 32 |
2355003 | 2355003 | 2022-03-29 | Dare | North Carolina | 37055 | 7365 | 23 |
2355004 | 2355004 | 2022-03-29 | Davidson | North Carolina | 37057 | 42960 | 393 |
2355005 | 2355005 | 2022-03-29 | Davie | North Carolina | 37059 | 11111 | 93 |
2355006 | 2355006 | 2022-03-29 | Duplin | North Carolina | 37061 | 16811 | 239 |
2355007 | 2355007 | 2022-03-29 | Durham | North Carolina | 37063 | 72307 | 298 |
2355008 | 2355008 | 2022-03-29 | Edgecombe | North Carolina | 37065 | 13473 | 141 |
2355009 | 2355009 | 2022-03-29 | Forsyth | North Carolina | 37067 | 92034 | 792 |
2355010 | 2355010 | 2022-03-29 | Franklin | North Carolina | 37069 | 20222 | 65 |
2355011 | 2355011 | 2022-03-29 | Gaston | North Carolina | 37071 | 65036 | 792 |
2355012 | 2355012 | 2022-03-29 | Gates | North Carolina | 37073 | 1890 | 19 |
2355013 | 2355013 | 2022-03-29 | Graham | North Carolina | 37075 | 2269 | 30 |
2355014 | 2355014 | 2022-03-29 | Granville | North Carolina | 37077 | 14208 | 111 |
2355015 | 2355015 | 2022-03-29 | Greene | North Carolina | 37079 | 5773 | 61 |
2355016 | 2355016 | 2022-03-29 | Guilford | North Carolina | 37081 | 116275 | 1157 |
2355017 | 2355017 | 2022-03-29 | Halifax | North Carolina | 37083 | 13905 | 181 |
2355018 | 2355018 | 2022-03-29 | Harnett | North Carolina | 37085 | 32745 | 327 |
2355019 | 2355019 | 2022-03-29 | Haywood | North Carolina | 37087 | 12908 | 198 |
2355020 | 2355020 | 2022-03-29 | Henderson | North Carolina | 37089 | 24861 | 293 |
2355021 | 2355021 | 2022-03-29 | Hertford | North Carolina | 37091 | 4714 | 81 |
2355022 | 2355022 | 2022-03-29 | Hoke | North Carolina | 37093 | 14638 | 103 |
2355023 | 2355023 | 2022-03-29 | Hyde | North Carolina | 37095 | 1310 | 13 |
2355024 | 2355024 | 2022-03-29 | Iredell | North Carolina | 37097 | 48276 | 444 |
2355025 | 2355025 | 2022-03-29 | Jackson | North Carolina | 37099 | 9319 | 86 |
2355026 | 2355026 | 2022-03-29 | Johnston | North Carolina | 37101 | 59022 | 432 |
2355027 | 2355027 | 2022-03-29 | Jones | North Carolina | 37103 | 2209 | 38 |
2355028 | 2355028 | 2022-03-29 | Lee | North Carolina | 37105 | 15912 | 145 |
2355029 | 2355029 | 2022-03-29 | Lenoir | North Carolina | 37107 | 15731 | 204 |
2355030 | 2355030 | 2022-03-29 | Lincoln | North Carolina | 37109 | 24265 | 158 |
2355031 | 2355031 | 2022-03-29 | Macon | North Carolina | 37113 | 7697 | 113 |
2355032 | 2355032 | 2022-03-29 | Madison | North Carolina | 37115 | 5065 | 79 |
2355033 | 2355033 | 2022-03-29 | Martin | North Carolina | 37117 | 6046 | 89 |
2355034 | 2355034 | 2022-03-29 | McDowell | North Carolina | 37111 | 13650 | 167 |
2355035 | 2355035 | 2022-03-29 | Mecklenburg | North Carolina | 37119 | 277510 | 1557 |
2355036 | 2355036 | 2022-03-29 | Mitchell | North Carolina | 37121 | 3416 | 34 |
2355037 | 2355037 | 2022-03-29 | Montgomery | North Carolina | 37123 | 7259 | 126 |
2355038 | 2355038 | 2022-03-29 | Moore | North Carolina | 37125 | 24121 | 318 |
2355039 | 2355039 | 2022-03-29 | Nash | North Carolina | 37127 | 26730 | 296 |
2355040 | 2355040 | 2022-03-29 | New Hanover | North Carolina | 37129 | 50222 | 385 |
2355041 | 2355041 | 2022-03-29 | Northampton | North Carolina | 37131 | 4314 | 82 |
2355042 | 2355042 | 2022-03-29 | Onslow | North Carolina | 37133 | 51783 | 374 |
2355043 | 2355043 | 2022-03-29 | Orange | North Carolina | 37135 | 26026 | 124 |
2355044 | 2355044 | 2022-03-29 | Pamlico | North Carolina | 37137 | 2592 | 27 |
2355045 | 2355045 | 2022-03-29 | Pasquotank | North Carolina | 37139 | 8470 | 111 |
2355046 | 2355046 | 2022-03-29 | Pender | North Carolina | 37141 | 15225 | 118 |
2355047 | 2355047 | 2022-03-29 | Perquimans | North Carolina | 37143 | 2742 | 18 |
2355048 | 2355048 | 2022-03-29 | Person | North Carolina | 37145 | 9251 | 104 |
2355049 | 2355049 | 2022-03-29 | Pitt | North Carolina | 37147 | 52335 | 168 |
2355050 | 2355050 | 2022-03-29 | Polk | North Carolina | 37149 | 3850 | 54 |
2355051 | 2355051 | 2022-03-29 | Randolph | North Carolina | 37151 | 35422 | 401 |
2355052 | 2355052 | 2022-03-29 | Richmond | North Carolina | 37153 | 12773 | 185 |
2355053 | 2355053 | 2022-03-29 | Robeson | North Carolina | 37155 | 40360 | 523 |
2355054 | 2355054 | 2022-03-29 | Rockingham | North Carolina | 37157 | 21915 | 267 |
2355055 | 2355055 | 2022-03-29 | Rowan | North Carolina | 37159 | 41086 | 566 |
2355056 | 2355056 | 2022-03-29 | Rutherford | North Carolina | 37161 | 17448 | 397 |
2355057 | 2355057 | 2022-03-29 | Sampson | North Carolina | 37163 | 18704 | 170 |
2355058 | 2355058 | 2022-03-29 | Scotland | North Carolina | 37165 | 9966 | 126 |
2355059 | 2355059 | 2022-03-29 | Stanly | North Carolina | 37167 | 19397 | 249 |
2355060 | 2355060 | 2022-03-29 | Stokes | North Carolina | 37169 | 11160 | 171 |
2355061 | 2355061 | 2022-03-29 | Surry | North Carolina | 37171 | 20996 | 331 |
2355062 | 2355062 | 2022-03-29 | Swain | North Carolina | 37173 | 3483 | 38 |
2355063 | 2355063 | 2022-03-29 | Transylvania | North Carolina | 37175 | 6118 | 71 |
2355064 | 2355064 | 2022-03-29 | Tyrrell | North Carolina | 37177 | 974 | 8 |
2355065 | 2355065 | 2022-03-29 | Union | North Carolina | 37179 | 61479 | 479 |
2355066 | 2355066 | 2022-03-29 | Vance | North Carolina | 37181 | 11828 | 112 |
2355067 | 2355067 | 2022-03-29 | Wake | North Carolina | 37183 | 290032 | 1046 |
2355068 | 2355068 | 2022-03-29 | Warren | North Carolina | 37185 | 4306 | 39 |
2355069 | 2355069 | 2022-03-29 | Washington | North Carolina | 37187 | 3010 | 50 |
2355070 | 2355070 | 2022-03-29 | Watauga | North Carolina | 37189 | 12301 | 58 |
2355071 | 2355071 | 2022-03-29 | Wayne | North Carolina | 37191 | 29931 | 385 |
2355072 | 2355072 | 2022-03-29 | Wilkes | North Carolina | 37193 | 17518 | 256 |
2355073 | 2355073 | 2022-03-29 | Wilson | North Carolina | 37195 | 21574 | 304 |
2355074 | 2355074 | 2022-03-29 | Yadkin | North Carolina | 37197 | 10754 | 111 |
2355075 | 2355075 | 2022-03-29 | Yancey | North Carolina | 37199 | 4997 | 51 |
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);