ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
100 rows where date = "2020-10-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 |
---|---|---|---|---|---|---|---|
678967 | 678967 | 2020-10-29 | Alamance | North Carolina | 37001 | 5254 | 79 |
678968 | 678968 | 2020-10-29 | Alexander | North Carolina | 37003 | 882 | 10 |
678969 | 678969 | 2020-10-29 | Alleghany | North Carolina | 37005 | 304 | 2 |
678970 | 678970 | 2020-10-29 | Anson | North Carolina | 37007 | 727 | 10 |
678971 | 678971 | 2020-10-29 | Ashe | North Carolina | 37009 | 442 | 3 |
678972 | 678972 | 2020-10-29 | Avery | North Carolina | 37011 | 622 | 0 |
678973 | 678973 | 2020-10-29 | Beaufort | North Carolina | 37013 | 1388 | 42 |
678974 | 678974 | 2020-10-29 | Bertie | North Carolina | 37015 | 729 | 20 |
678975 | 678975 | 2020-10-29 | Bladen | North Carolina | 37017 | 1090 | 19 |
678976 | 678976 | 2020-10-29 | Brunswick | North Carolina | 37019 | 2201 | 46 |
678977 | 678977 | 2020-10-29 | Buncombe | North Carolina | 37021 | 4178 | 114 |
678978 | 678978 | 2020-10-29 | Burke | North Carolina | 37023 | 2696 | 52 |
678979 | 678979 | 2020-10-29 | Cabarrus | North Carolina | 37025 | 4931 | 91 |
678980 | 678980 | 2020-10-29 | Caldwell | North Carolina | 37027 | 2548 | 19 |
678981 | 678981 | 2020-10-29 | Camden | North Carolina | 37029 | 137 | 3 |
678982 | 678982 | 2020-10-29 | Carteret | North Carolina | 37031 | 1149 | 5 |
678983 | 678983 | 2020-10-29 | Caswell | North Carolina | 37033 | 624 | 5 |
678984 | 678984 | 2020-10-29 | Catawba | North Carolina | 37035 | 4507 | 62 |
678985 | 678985 | 2020-10-29 | Chatham | North Carolina | 37037 | 1947 | 61 |
678986 | 678986 | 2020-10-29 | Cherokee | North Carolina | 37039 | 776 | 15 |
678987 | 678987 | 2020-10-29 | Chowan | North Carolina | 37041 | 532 | 11 |
678988 | 678988 | 2020-10-29 | Clay | North Carolina | 37043 | 234 | 3 |
678989 | 678989 | 2020-10-29 | Cleveland | North Carolina | 37045 | 3204 | 86 |
678990 | 678990 | 2020-10-29 | Columbus | North Carolina | 37047 | 1714 | 62 |
678991 | 678991 | 2020-10-29 | Craven | North Carolina | 37049 | 2369 | 60 |
678992 | 678992 | 2020-10-29 | Cumberland | North Carolina | 37051 | 7129 | 99 |
678993 | 678993 | 2020-10-29 | Currituck | North Carolina | 37053 | 224 | 4 |
678994 | 678994 | 2020-10-29 | Dare | North Carolina | 37055 | 373 | 3 |
678995 | 678995 | 2020-10-29 | Davidson | North Carolina | 37057 | 3765 | 43 |
678996 | 678996 | 2020-10-29 | Davie | North Carolina | 37059 | 771 | 8 |
678997 | 678997 | 2020-10-29 | Duplin | North Carolina | 37061 | 2812 | 54 |
678998 | 678998 | 2020-10-29 | Durham | North Carolina | 37063 | 9141 | 103 |
678999 | 678999 | 2020-10-29 | Edgecombe | North Carolina | 37065 | 2020 | 59 |
679000 | 679000 | 2020-10-29 | Forsyth | North Carolina | 37067 | 8937 | 120 |
679001 | 679001 | 2020-10-29 | Franklin | North Carolina | 37069 | 1474 | 32 |
679002 | 679002 | 2020-10-29 | Gaston | North Carolina | 37071 | 7479 | 121 |
679003 | 679003 | 2020-10-29 | Gates | North Carolina | 37073 | 168 | 3 |
679004 | 679004 | 2020-10-29 | Graham | North Carolina | 37075 | 247 | 8 |
679005 | 679005 | 2020-10-29 | Granville | North Carolina | 37077 | 2018 | 50 |
679006 | 679006 | 2020-10-29 | Greene | North Carolina | 37079 | 962 | 13 |
679007 | 679007 | 2020-10-29 | Guilford | North Carolina | 37081 | 11581 | 209 |
679008 | 679008 | 2020-10-29 | Halifax | North Carolina | 37083 | 1434 | 27 |
679009 | 679009 | 2020-10-29 | Harnett | North Carolina | 37085 | 2969 | 70 |
679010 | 679010 | 2020-10-29 | Haywood | North Carolina | 37087 | 726 | 36 |
679011 | 679011 | 2020-10-29 | Henderson | North Carolina | 37089 | 2523 | 68 |
679012 | 679012 | 2020-10-29 | Hertford | North Carolina | 37091 | 854 | 34 |
679013 | 679013 | 2020-10-29 | Hoke | North Carolina | 37093 | 1554 | 25 |
679014 | 679014 | 2020-10-29 | Hyde | North Carolina | 37095 | 175 | 5 |
679015 | 679015 | 2020-10-29 | Iredell | North Carolina | 37097 | 3870 | 34 |
679016 | 679016 | 2020-10-29 | Jackson | North Carolina | 37099 | 1072 | 7 |
679017 | 679017 | 2020-10-29 | Johnston | North Carolina | 37101 | 5808 | 66 |
679018 | 679018 | 2020-10-29 | Jones | North Carolina | 37103 | 201 | 15 |
679019 | 679019 | 2020-10-29 | Lee | North Carolina | 37105 | 2116 | 20 |
679020 | 679020 | 2020-10-29 | Lenoir | North Carolina | 37107 | 1470 | 41 |
679021 | 679021 | 2020-10-29 | Lincoln | North Carolina | 37109 | 2426 | 16 |
679022 | 679022 | 2020-10-29 | Macon | North Carolina | 37113 | 764 | 7 |
679023 | 679023 | 2020-10-29 | Madison | North Carolina | 37115 | 247 | 1 |
679024 | 679024 | 2020-10-29 | Martin | North Carolina | 37117 | 647 | 17 |
679025 | 679025 | 2020-10-29 | McDowell | North Carolina | 37111 | 1340 | 32 |
679026 | 679026 | 2020-10-29 | Mecklenburg | North Carolina | 37119 | 33988 | 390 |
679027 | 679027 | 2020-10-29 | Mitchell | North Carolina | 37121 | 239 | 4 |
679028 | 679028 | 2020-10-29 | Montgomery | North Carolina | 37123 | 1195 | 38 |
679029 | 679029 | 2020-10-29 | Moore | North Carolina | 37125 | 2281 | 43 |
679030 | 679030 | 2020-10-29 | Nash | North Carolina | 37127 | 3423 | 76 |
679031 | 679031 | 2020-10-29 | New Hanover | North Carolina | 37129 | 5305 | 37 |
679032 | 679032 | 2020-10-29 | Northampton | North Carolina | 37131 | 566 | 19 |
679033 | 679033 | 2020-10-29 | Onslow | North Carolina | 37133 | 3394 | 29 |
679034 | 679034 | 2020-10-29 | Orange | North Carolina | 37135 | 3109 | 59 |
679035 | 679035 | 2020-10-29 | Pamlico | North Carolina | 37137 | 323 | 3 |
679036 | 679036 | 2020-10-29 | Pasquotank | North Carolina | 37139 | 881 | 35 |
679037 | 679037 | 2020-10-29 | Pender | North Carolina | 37141 | 1407 | 14 |
679038 | 679038 | 2020-10-29 | Perquimans | North Carolina | 37143 | 251 | 4 |
679039 | 679039 | 2020-10-29 | Person | North Carolina | 37145 | 677 | 10 |
679040 | 679040 | 2020-10-29 | Pitt | North Carolina | 37147 | 6196 | 39 |
679041 | 679041 | 2020-10-29 | Polk | North Carolina | 37149 | 402 | 11 |
679042 | 679042 | 2020-10-29 | Randolph | North Carolina | 37151 | 3831 | 64 |
679043 | 679043 | 2020-10-29 | Richmond | North Carolina | 37153 | 1439 | 30 |
679044 | 679044 | 2020-10-29 | Robeson | North Carolina | 37155 | 6071 | 95 |
679045 | 679045 | 2020-10-29 | Rockingham | North Carolina | 37157 | 2003 | 19 |
679046 | 679046 | 2020-10-29 | Rowan | North Carolina | 37159 | 4144 | 120 |
679047 | 679047 | 2020-10-29 | Rutherford | North Carolina | 37161 | 1763 | 64 |
679048 | 679048 | 2020-10-29 | Sampson | North Carolina | 37163 | 2802 | 31 |
679049 | 679049 | 2020-10-29 | Scotland | North Carolina | 37165 | 1652 | 25 |
679050 | 679050 | 2020-10-29 | Stanly | North Carolina | 37167 | 2446 | 63 |
679051 | 679051 | 2020-10-29 | Stokes | North Carolina | 37169 | 692 | 10 |
679052 | 679052 | 2020-10-29 | Surry | North Carolina | 37171 | 1885 | 33 |
679053 | 679053 | 2020-10-29 | Swain | North Carolina | 37173 | 288 | 4 |
679054 | 679054 | 2020-10-29 | Transylvania | North Carolina | 37175 | 424 | 9 |
679055 | 679055 | 2020-10-29 | Tyrrell | North Carolina | 37177 | 132 | 3 |
679056 | 679056 | 2020-10-29 | Union | North Carolina | 37179 | 5940 | 65 |
679057 | 679057 | 2020-10-29 | Vance | North Carolina | 37181 | 1214 | 47 |
679058 | 679058 | 2020-10-29 | Wake | North Carolina | 37183 | 21604 | 270 |
679059 | 679059 | 2020-10-29 | Warren | North Carolina | 37185 | 469 | 7 |
679060 | 679060 | 2020-10-29 | Washington | North Carolina | 37187 | 253 | 8 |
679061 | 679061 | 2020-10-29 | Watauga | North Carolina | 37189 | 1400 | 6 |
679062 | 679062 | 2020-10-29 | Wayne | North Carolina | 37191 | 4642 | 81 |
679063 | 679063 | 2020-10-29 | Wilkes | North Carolina | 37193 | 1775 | 38 |
679064 | 679064 | 2020-10-29 | Wilson | North Carolina | 37195 | 3056 | 64 |
679065 | 679065 | 2020-10-29 | Yadkin | North Carolina | 37197 | 1047 | 9 |
679066 | 679066 | 2020-10-29 | Yancey | North Carolina | 37199 | 328 | 1 |
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);