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 2021-02-16 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 |
---|---|---|---|---|---|---|---|
1035935 | 1035935 | 2021-02-16 | Alamance | North Carolina | 37001 | 15094 | 207 |
1035936 | 1035936 | 2021-02-16 | Alexander | North Carolina | 37003 | 3781 | 71 |
1035937 | 1035937 | 2021-02-16 | Alleghany | North Carolina | 37005 | 889 | 4 |
1035938 | 1035938 | 2021-02-16 | Anson | North Carolina | 37007 | 2216 | 51 |
1035939 | 1035939 | 2021-02-16 | Ashe | North Carolina | 37009 | 1797 | 40 |
1035940 | 1035940 | 2021-02-16 | Avery | North Carolina | 37011 | 1782 | 18 |
1035941 | 1035941 | 2021-02-16 | Beaufort | North Carolina | 37013 | 4083 | 79 |
1035942 | 1035942 | 2021-02-16 | Bertie | North Carolina | 37015 | 1598 | 39 |
1035943 | 1035943 | 2021-02-16 | Bladen | North Carolina | 37017 | 2828 | 38 |
1035944 | 1035944 | 2021-02-16 | Brunswick | North Carolina | 37019 | 7543 | 121 |
1035945 | 1035945 | 2021-02-16 | Buncombe | North Carolina | 37021 | 14671 | 284 |
1035946 | 1035946 | 2021-02-16 | Burke | North Carolina | 37023 | 8948 | 128 |
1035947 | 1035947 | 2021-02-16 | Cabarrus | North Carolina | 37025 | 17648 | 222 |
1035948 | 1035948 | 2021-02-16 | Caldwell | North Carolina | 37027 | 8388 | 65 |
1035949 | 1035949 | 2021-02-16 | Camden | North Carolina | 37029 | 532 | 5 |
1035950 | 1035950 | 2021-02-16 | Carteret | North Carolina | 37031 | 4195 | 43 |
1035951 | 1035951 | 2021-02-16 | Caswell | North Carolina | 37033 | 1880 | 19 |
1035952 | 1035952 | 2021-02-16 | Catawba | North Carolina | 37035 | 16906 | 265 |
1035953 | 1035953 | 2021-02-16 | Chatham | North Carolina | 37037 | 4022 | 73 |
1035954 | 1035954 | 2021-02-16 | Cherokee | North Carolina | 37039 | 2013 | 17 |
1035955 | 1035955 | 2021-02-16 | Chowan | North Carolina | 37041 | 1320 | 21 |
1035956 | 1035956 | 2021-02-16 | Clay | North Carolina | 37043 | 633 | 18 |
1035957 | 1035957 | 2021-02-16 | Cleveland | North Carolina | 37045 | 9889 | 209 |
1035958 | 1035958 | 2021-02-16 | Columbus | North Carolina | 37047 | 5586 | 133 |
1035959 | 1035959 | 2021-02-16 | Craven | North Carolina | 37049 | 7938 | 113 |
1035960 | 1035960 | 2021-02-16 | Cumberland | North Carolina | 37051 | 22907 | 252 |
1035961 | 1035961 | 2021-02-16 | Currituck | North Carolina | 37053 | 1272 | 14 |
1035962 | 1035962 | 2021-02-16 | Dare | North Carolina | 37055 | 1820 | 8 |
1035963 | 1035963 | 2021-02-16 | Davidson | North Carolina | 37057 | 14168 | 148 |
1035964 | 1035964 | 2021-02-16 | Davie | North Carolina | 37059 | 3388 | 23 |
1035965 | 1035965 | 2021-02-16 | Duplin | North Carolina | 37061 | 5540 | 121 |
1035966 | 1035966 | 2021-02-16 | Durham | North Carolina | 37063 | 21359 | 201 |
1035967 | 1035967 | 2021-02-16 | Edgecombe | North Carolina | 37065 | 4457 | 95 |
1035968 | 1035968 | 2021-02-16 | Forsyth | North Carolina | 37067 | 30617 | 322 |
1035969 | 1035969 | 2021-02-16 | Franklin | North Carolina | 37069 | 5055 | 42 |
1035970 | 1035970 | 2021-02-16 | Gaston | North Carolina | 37071 | 22891 | 369 |
1035971 | 1035971 | 2021-02-16 | Gates | North Carolina | 37073 | 627 | 12 |
1035972 | 1035972 | 2021-02-16 | Graham | North Carolina | 37075 | 548 | 12 |
1035973 | 1035973 | 2021-02-16 | Granville | North Carolina | 37077 | 5030 | 75 |
1035974 | 1035974 | 2021-02-16 | Greene | North Carolina | 37079 | 2100 | 38 |
1035975 | 1035975 | 2021-02-16 | Guilford | North Carolina | 37081 | 38403 | 517 |
1035976 | 1035976 | 2021-02-16 | Halifax | North Carolina | 37083 | 4882 | 94 |
1035977 | 1035977 | 2021-02-16 | Harnett | North Carolina | 37085 | 9144 | 133 |
1035978 | 1035978 | 2021-02-16 | Haywood | North Carolina | 37087 | 3684 | 81 |
1035979 | 1035979 | 2021-02-16 | Henderson | North Carolina | 37089 | 8426 | 127 |
1035980 | 1035980 | 2021-02-16 | Hertford | North Carolina | 37091 | 1892 | 56 |
1035981 | 1035981 | 2021-02-16 | Hoke | North Carolina | 37093 | 3964 | 52 |
1035982 | 1035982 | 2021-02-16 | Hyde | North Carolina | 37095 | 613 | 7 |
1035983 | 1035983 | 2021-02-16 | Iredell | North Carolina | 37097 | 15707 | 175 |
1035984 | 1035984 | 2021-02-16 | Jackson | North Carolina | 37099 | 3159 | 47 |
1035985 | 1035985 | 2021-02-16 | Johnston | North Carolina | 37101 | 17278 | 181 |
1035986 | 1035986 | 2021-02-16 | Jones | North Carolina | 37103 | 668 | 16 |
1035987 | 1035987 | 2021-02-16 | Lee | North Carolina | 37105 | 5259 | 65 |
1035988 | 1035988 | 2021-02-16 | Lenoir | North Carolina | 37107 | 5217 | 103 |
1035989 | 1035989 | 2021-02-16 | Lincoln | North Carolina | 37109 | 8488 | 61 |
1035990 | 1035990 | 2021-02-16 | Macon | North Carolina | 37113 | 2500 | 12 |
1035991 | 1035991 | 2021-02-16 | Madison | North Carolina | 37115 | 1303 | 32 |
1035992 | 1035992 | 2021-02-16 | Martin | North Carolina | 37117 | 1993 | 36 |
1035993 | 1035993 | 2021-02-16 | McDowell | North Carolina | 37111 | 4646 | 55 |
1035994 | 1035994 | 2021-02-16 | Mecklenburg | North Carolina | 37119 | 93325 | 832 |
1035995 | 1035995 | 2021-02-16 | Mitchell | North Carolina | 37121 | 1222 | 15 |
1035996 | 1035996 | 2021-02-16 | Montgomery | North Carolina | 37123 | 2932 | 81 |
1035997 | 1035997 | 2021-02-16 | Moore | North Carolina | 37125 | 7614 | 160 |
1035998 | 1035998 | 2021-02-16 | Nash | North Carolina | 37127 | 9280 | 155 |
1035999 | 1035999 | 2021-02-16 | New Hanover | North Carolina | 37129 | 15359 | 136 |
1036000 | 1036000 | 2021-02-16 | Northampton | North Carolina | 37131 | 1649 | 28 |
1036001 | 1036001 | 2021-02-16 | Onslow | North Carolina | 37133 | 14168 | 126 |
1036002 | 1036002 | 2021-02-16 | Orange | North Carolina | 37135 | 7438 | 90 |
1036003 | 1036003 | 2021-02-16 | Pamlico | North Carolina | 37137 | 891 | 9 |
1036004 | 1036004 | 2021-02-16 | Pasquotank | North Carolina | 37139 | 2946 | 74 |
1036005 | 1036005 | 2021-02-16 | Pender | North Carolina | 37141 | 4436 | 51 |
1036006 | 1036006 | 2021-02-16 | Perquimans | North Carolina | 37143 | 854 | 6 |
1036007 | 1036007 | 2021-02-16 | Person | North Carolina | 37145 | 2826 | 59 |
1036008 | 1036008 | 2021-02-16 | Pitt | North Carolina | 37147 | 16759 | 76 |
1036009 | 1036009 | 2021-02-16 | Polk | North Carolina | 37149 | 1299 | 25 |
1036010 | 1036010 | 2021-02-16 | Randolph | North Carolina | 37151 | 12598 | 194 |
1036011 | 1036011 | 2021-02-16 | Richmond | North Carolina | 37153 | 4035 | 83 |
1036012 | 1036012 | 2021-02-16 | Robeson | North Carolina | 37155 | 14167 | 186 |
1036013 | 1036013 | 2021-02-16 | Rockingham | North Carolina | 37157 | 6607 | 55 |
1036014 | 1036014 | 2021-02-16 | Rowan | North Carolina | 37159 | 14318 | 265 |
1036015 | 1036015 | 2021-02-16 | Rutherford | North Carolina | 37161 | 6586 | 193 |
1036016 | 1036016 | 2021-02-16 | Sampson | North Carolina | 37163 | 6447 | 86 |
1036017 | 1036017 | 2021-02-16 | Scotland | North Carolina | 37165 | 3361 | 71 |
1036018 | 1036018 | 2021-02-16 | Stanly | North Carolina | 37167 | 6472 | 104 |
1036019 | 1036019 | 2021-02-16 | Stokes | North Carolina | 37169 | 3506 | 62 |
1036020 | 1036020 | 2021-02-16 | Surry | North Carolina | 37171 | 7067 | 124 |
1036021 | 1036021 | 2021-02-16 | Swain | North Carolina | 37173 | 1120 | 15 |
1036022 | 1036022 | 2021-02-16 | Transylvania | North Carolina | 37175 | 1817 | 23 |
1036023 | 1036023 | 2021-02-16 | Tyrrell | North Carolina | 37177 | 292 | 6 |
1036024 | 1036024 | 2021-02-16 | Union | North Carolina | 37179 | 19844 | 186 |
1036025 | 1036025 | 2021-02-16 | Vance | North Carolina | 37181 | 4066 | 78 |
1036026 | 1036026 | 2021-02-16 | Wake | North Carolina | 37183 | 72499 | 518 |
1036027 | 1036027 | 2021-02-16 | Warren | North Carolina | 37185 | 1538 | 16 |
1036028 | 1036028 | 2021-02-16 | Washington | North Carolina | 37187 | 938 | 27 |
1036029 | 1036029 | 2021-02-16 | Watauga | North Carolina | 37189 | 3733 | 28 |
1036030 | 1036030 | 2021-02-16 | Wayne | North Carolina | 37191 | 9985 | 200 |
1036031 | 1036031 | 2021-02-16 | Wilkes | North Carolina | 37193 | 5823 | 97 |
1036032 | 1036032 | 2021-02-16 | Wilson | North Carolina | 37195 | 8054 | 141 |
1036033 | 1036033 | 2021-02-16 | Yadkin | North Carolina | 37197 | 3529 | 42 |
1036034 | 1036034 | 2021-02-16 | Yancey | North Carolina | 37199 | 1400 | 23 |
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);