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-05-16 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 |
---|---|---|---|---|---|---|---|
1324898 | 1324898 | 2021-05-16 | Alamance | North Carolina | 37001 | 18304 | 277 |
1324899 | 1324899 | 2021-05-16 | Alexander | North Carolina | 37003 | 4396 | 84 |
1324900 | 1324900 | 2021-05-16 | Alleghany | North Carolina | 37005 | 1052 | 5 |
1324901 | 1324901 | 2021-05-16 | Anson | North Carolina | 37007 | 2585 | 55 |
1324902 | 1324902 | 2021-05-16 | Ashe | North Carolina | 37009 | 2127 | 41 |
1324903 | 1324903 | 2021-05-16 | Avery | North Carolina | 37011 | 2128 | 20 |
1324904 | 1324904 | 2021-05-16 | Beaufort | North Carolina | 37013 | 4614 | 95 |
1324905 | 1324905 | 2021-05-16 | Bertie | North Carolina | 37015 | 1768 | 43 |
1324906 | 1324906 | 2021-05-16 | Bladen | North Carolina | 37017 | 3275 | 42 |
1324907 | 1324907 | 2021-05-16 | Brunswick | North Carolina | 37019 | 9160 | 153 |
1324908 | 1324908 | 2021-05-16 | Buncombe | North Carolina | 37021 | 17737 | 326 |
1324909 | 1324909 | 2021-05-16 | Burke | North Carolina | 37023 | 9990 | 153 |
1324910 | 1324910 | 2021-05-16 | Cabarrus | North Carolina | 37025 | 21931 | 257 |
1324911 | 1324911 | 2021-05-16 | Caldwell | North Carolina | 37027 | 9364 | 104 |
1324912 | 1324912 | 2021-05-16 | Camden | North Carolina | 37029 | 663 | 5 |
1324913 | 1324913 | 2021-05-16 | Carteret | North Carolina | 37031 | 5131 | 54 |
1324914 | 1324914 | 2021-05-16 | Caswell | North Carolina | 37033 | 2175 | 28 |
1324915 | 1324915 | 2021-05-16 | Catawba | North Carolina | 37035 | 19461 | 303 |
1324916 | 1324916 | 2021-05-16 | Chatham | North Carolina | 37037 | 4654 | 88 |
1324917 | 1324917 | 2021-05-16 | Cherokee | North Carolina | 37039 | 2587 | 34 |
1324918 | 1324918 | 2021-05-16 | Chowan | North Carolina | 37041 | 1465 | 23 |
1324919 | 1324919 | 2021-05-16 | Clay | North Carolina | 37043 | 773 | 18 |
1324920 | 1324920 | 2021-05-16 | Cleveland | North Carolina | 37045 | 11475 | 224 |
1324921 | 1324921 | 2021-05-16 | Columbus | North Carolina | 37047 | 6344 | 151 |
1324922 | 1324922 | 2021-05-16 | Craven | North Carolina | 37049 | 9318 | 124 |
1324923 | 1324923 | 2021-05-16 | Cumberland | North Carolina | 37051 | 28931 | 304 |
1324924 | 1324924 | 2021-05-16 | Currituck | North Carolina | 37053 | 1555 | 16 |
1324925 | 1324925 | 2021-05-16 | Dare | North Carolina | 37055 | 2118 | 10 |
1324926 | 1324926 | 2021-05-16 | Davidson | North Carolina | 37057 | 16605 | 187 |
1324927 | 1324927 | 2021-05-16 | Davie | North Carolina | 37059 | 4078 | 37 |
1324928 | 1324928 | 2021-05-16 | Duplin | North Carolina | 37061 | 6285 | 133 |
1324929 | 1324929 | 2021-05-16 | Durham | North Carolina | 37063 | 25501 | 226 |
1324930 | 1324930 | 2021-05-16 | Edgecombe | North Carolina | 37065 | 5579 | 111 |
1324931 | 1324931 | 2021-05-16 | Forsyth | North Carolina | 37067 | 35861 | 378 |
1324932 | 1324932 | 2021-05-16 | Franklin | North Carolina | 37069 | 6901 | 51 |
1324933 | 1324933 | 2021-05-16 | Gaston | North Carolina | 37071 | 26582 | 426 |
1324934 | 1324934 | 2021-05-16 | Gates | North Carolina | 37073 | 739 | 13 |
1324935 | 1324935 | 2021-05-16 | Graham | North Carolina | 37075 | 593 | 12 |
1324936 | 1324936 | 2021-05-16 | Granville | North Carolina | 37077 | 5955 | 82 |
1324937 | 1324937 | 2021-05-16 | Greene | North Carolina | 37079 | 2340 | 44 |
1324938 | 1324938 | 2021-05-16 | Guilford | North Carolina | 37081 | 47588 | 700 |
1324939 | 1324939 | 2021-05-16 | Halifax | North Carolina | 37083 | 5596 | 112 |
1324940 | 1324940 | 2021-05-16 | Harnett | North Carolina | 37085 | 11647 | 173 |
1324941 | 1324941 | 2021-05-16 | Haywood | North Carolina | 37087 | 4382 | 96 |
1324942 | 1324942 | 2021-05-16 | Henderson | North Carolina | 37089 | 10201 | 159 |
1324943 | 1324943 | 2021-05-16 | Hertford | North Carolina | 37091 | 2102 | 63 |
1324944 | 1324944 | 2021-05-16 | Hoke | North Carolina | 37093 | 4682 | 55 |
1324945 | 1324945 | 2021-05-16 | Hyde | North Carolina | 37095 | 669 | 9 |
1324946 | 1324946 | 2021-05-16 | Iredell | North Carolina | 37097 | 18820 | 208 |
1324947 | 1324947 | 2021-05-16 | Jackson | North Carolina | 37099 | 3601 | 56 |
1324948 | 1324948 | 2021-05-16 | Johnston | North Carolina | 37101 | 21622 | 221 |
1324949 | 1324949 | 2021-05-16 | Jones | North Carolina | 37103 | 851 | 27 |
1324950 | 1324950 | 2021-05-16 | Lee | North Carolina | 37105 | 6010 | 78 |
1324951 | 1324951 | 2021-05-16 | Lenoir | North Carolina | 37107 | 6033 | 116 |
1324952 | 1324952 | 2021-05-16 | Lincoln | North Carolina | 37109 | 10085 | 85 |
1324953 | 1324953 | 2021-05-16 | Macon | North Carolina | 37113 | 3129 | 37 |
1324954 | 1324954 | 2021-05-16 | Madison | North Carolina | 37115 | 1580 | 41 |
1324955 | 1324955 | 2021-05-16 | Martin | North Carolina | 37117 | 2247 | 40 |
1324956 | 1324956 | 2021-05-16 | McDowell | North Carolina | 37111 | 5230 | 63 |
1324957 | 1324957 | 2021-05-16 | Mecklenburg | North Carolina | 37119 | 112120 | 952 |
1324958 | 1324958 | 2021-05-16 | Mitchell | North Carolina | 37121 | 1456 | 16 |
1324959 | 1324959 | 2021-05-16 | Montgomery | North Carolina | 37123 | 3327 | 93 |
1324960 | 1324960 | 2021-05-16 | Moore | North Carolina | 37125 | 8902 | 188 |
1324961 | 1324961 | 2021-05-16 | Nash | North Carolina | 37127 | 11520 | 190 |
1324962 | 1324962 | 2021-05-16 | New Hanover | North Carolina | 37129 | 19218 | 166 |
1324963 | 1324963 | 2021-05-16 | Northampton | North Carolina | 37131 | 1876 | 59 |
1324964 | 1324964 | 2021-05-16 | Onslow | North Carolina | 37133 | 17132 | 144 |
1324965 | 1324965 | 2021-05-16 | Orange | North Carolina | 37135 | 8542 | 101 |
1324966 | 1324966 | 2021-05-16 | Pamlico | North Carolina | 37137 | 1118 | 13 |
1324967 | 1324967 | 2021-05-16 | Pasquotank | North Carolina | 37139 | 3380 | 80 |
1324968 | 1324968 | 2021-05-16 | Pender | North Carolina | 37141 | 5443 | 69 |
1324969 | 1324969 | 2021-05-16 | Perquimans | North Carolina | 37143 | 1013 | 12 |
1324970 | 1324970 | 2021-05-16 | Person | North Carolina | 37145 | 3378 | 70 |
1324971 | 1324971 | 2021-05-16 | Pitt | North Carolina | 37147 | 19824 | 90 |
1324972 | 1324972 | 2021-05-16 | Polk | North Carolina | 37149 | 1479 | 29 |
1324973 | 1324973 | 2021-05-16 | Randolph | North Carolina | 37151 | 15049 | 227 |
1324974 | 1324974 | 2021-05-16 | Richmond | North Carolina | 37153 | 4664 | 93 |
1324975 | 1324975 | 2021-05-16 | Robeson | North Carolina | 37155 | 16471 | 240 |
1324976 | 1324976 | 2021-05-16 | Rockingham | North Carolina | 37157 | 7668 | 110 |
1324977 | 1324977 | 2021-05-16 | Rowan | North Carolina | 37159 | 16868 | 305 |
1324978 | 1324978 | 2021-05-16 | Rutherford | North Carolina | 37161 | 7347 | 211 |
1324979 | 1324979 | 2021-05-16 | Sampson | North Carolina | 37163 | 7944 | 111 |
1324980 | 1324980 | 2021-05-16 | Scotland | North Carolina | 37165 | 3799 | 85 |
1324981 | 1324981 | 2021-05-16 | Stanly | North Carolina | 37167 | 7823 | 132 |
1324982 | 1324982 | 2021-05-16 | Stokes | North Carolina | 37169 | 4087 | 79 |
1324983 | 1324983 | 2021-05-16 | Surry | North Carolina | 37171 | 8223 | 161 |
1324984 | 1324984 | 2021-05-16 | Swain | North Carolina | 37173 | 1217 | 18 |
1324985 | 1324985 | 2021-05-16 | Transylvania | North Carolina | 37175 | 2386 | 32 |
1324986 | 1324986 | 2021-05-16 | Tyrrell | North Carolina | 37177 | 320 | 6 |
1324987 | 1324987 | 2021-05-16 | Union | North Carolina | 37179 | 24439 | 219 |
1324988 | 1324988 | 2021-05-16 | Vance | North Carolina | 37181 | 4943 | 86 |
1324989 | 1324989 | 2021-05-16 | Wake | North Carolina | 37183 | 88228 | 732 |
1324990 | 1324990 | 2021-05-16 | Warren | North Carolina | 37185 | 1792 | 20 |
1324991 | 1324991 | 2021-05-16 | Washington | North Carolina | 37187 | 1075 | 31 |
1324992 | 1324992 | 2021-05-16 | Watauga | North Carolina | 37189 | 4637 | 31 |
1324993 | 1324993 | 2021-05-16 | Wayne | North Carolina | 37191 | 11206 | 245 |
1324994 | 1324994 | 2021-05-16 | Wilkes | North Carolina | 37193 | 6678 | 113 |
1324995 | 1324995 | 2021-05-16 | Wilson | North Carolina | 37195 | 9692 | 173 |
1324996 | 1324996 | 2021-05-16 | Yadkin | North Carolina | 37197 | 4032 | 49 |
1324997 | 1324997 | 2021-05-16 | Yancey | North Carolina | 37199 | 1623 | 28 |
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);