ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
100 rows where date = "2020-10-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 |
---|---|---|---|---|---|---|---|
636788 | 636788 | 2020-10-16 | Alamance | North Carolina | 37001 | 4675 | 59 |
636789 | 636789 | 2020-10-16 | Alexander | North Carolina | 37003 | 653 | 9 |
636790 | 636790 | 2020-10-16 | Alleghany | North Carolina | 37005 | 262 | 1 |
636791 | 636791 | 2020-10-16 | Anson | North Carolina | 37007 | 687 | 8 |
636792 | 636792 | 2020-10-16 | Ashe | North Carolina | 37009 | 358 | 1 |
636793 | 636793 | 2020-10-16 | Avery | North Carolina | 37011 | 490 | 0 |
636794 | 636794 | 2020-10-16 | Beaufort | North Carolina | 37013 | 1189 | 35 |
636795 | 636795 | 2020-10-16 | Bertie | North Carolina | 37015 | 674 | 13 |
636796 | 636796 | 2020-10-16 | Bladen | North Carolina | 37017 | 1014 | 19 |
636797 | 636797 | 2020-10-16 | Brunswick | North Carolina | 37019 | 1986 | 31 |
636798 | 636798 | 2020-10-16 | Buncombe | North Carolina | 37021 | 3717 | 103 |
636799 | 636799 | 2020-10-16 | Burke | North Carolina | 37023 | 2453 | 46 |
636800 | 636800 | 2020-10-16 | Cabarrus | North Carolina | 37025 | 4531 | 82 |
636801 | 636801 | 2020-10-16 | Caldwell | North Carolina | 37027 | 2111 | 19 |
636802 | 636802 | 2020-10-16 | Camden | North Carolina | 37029 | 131 | 3 |
636803 | 636803 | 2020-10-16 | Carteret | North Carolina | 37031 | 964 | 5 |
636804 | 636804 | 2020-10-16 | Caswell | North Carolina | 37033 | 549 | 5 |
636805 | 636805 | 2020-10-16 | Catawba | North Carolina | 37035 | 3855 | 57 |
636806 | 636806 | 2020-10-16 | Chatham | North Carolina | 37037 | 1845 | 60 |
636807 | 636807 | 2020-10-16 | Cherokee | North Carolina | 37039 | 723 | 12 |
636808 | 636808 | 2020-10-16 | Chowan | North Carolina | 37041 | 482 | 10 |
636809 | 636809 | 2020-10-16 | Clay | North Carolina | 37043 | 167 | 3 |
636810 | 636810 | 2020-10-16 | Cleveland | North Carolina | 37045 | 2783 | 75 |
636811 | 636811 | 2020-10-16 | Columbus | North Carolina | 37047 | 1557 | 59 |
636812 | 636812 | 2020-10-16 | Craven | North Carolina | 37049 | 2076 | 50 |
636813 | 636813 | 2020-10-16 | Cumberland | North Carolina | 37051 | 6416 | 91 |
636814 | 636814 | 2020-10-16 | Currituck | North Carolina | 37053 | 214 | 4 |
636815 | 636815 | 2020-10-16 | Dare | North Carolina | 37055 | 319 | 3 |
636816 | 636816 | 2020-10-16 | Davidson | North Carolina | 37057 | 3374 | 42 |
636817 | 636817 | 2020-10-16 | Davie | North Carolina | 37059 | 688 | 6 |
636818 | 636818 | 2020-10-16 | Duplin | North Carolina | 37061 | 2644 | 54 |
636819 | 636819 | 2020-10-16 | Durham | North Carolina | 37063 | 8484 | 98 |
636820 | 636820 | 2020-10-16 | Edgecombe | North Carolina | 37065 | 1732 | 52 |
636821 | 636821 | 2020-10-16 | Forsyth | North Carolina | 37067 | 7968 | 110 |
636822 | 636822 | 2020-10-16 | Franklin | North Carolina | 37069 | 1362 | 31 |
636823 | 636823 | 2020-10-16 | Gaston | North Carolina | 37071 | 6472 | 102 |
636824 | 636824 | 2020-10-16 | Gates | North Carolina | 37073 | 160 | 3 |
636825 | 636825 | 2020-10-16 | Graham | North Carolina | 37075 | 227 | 7 |
636826 | 636826 | 2020-10-16 | Granville | North Carolina | 37077 | 1878 | 50 |
636827 | 636827 | 2020-10-16 | Greene | North Carolina | 37079 | 820 | 15 |
636828 | 636828 | 2020-10-16 | Guilford | North Carolina | 37081 | 10286 | 192 |
636829 | 636829 | 2020-10-16 | Halifax | North Carolina | 37083 | 1220 | 25 |
636830 | 636830 | 2020-10-16 | Harnett | North Carolina | 37085 | 2652 | 64 |
636831 | 636831 | 2020-10-16 | Haywood | North Carolina | 37087 | 676 | 36 |
636832 | 636832 | 2020-10-16 | Henderson | North Carolina | 37089 | 2342 | 66 |
636833 | 636833 | 2020-10-16 | Hertford | North Carolina | 37091 | 837 | 34 |
636834 | 636834 | 2020-10-16 | Hoke | North Carolina | 37093 | 1423 | 22 |
636835 | 636835 | 2020-10-16 | Hyde | North Carolina | 37095 | 174 | 5 |
636836 | 636836 | 2020-10-16 | Iredell | North Carolina | 37097 | 3492 | 34 |
636837 | 636837 | 2020-10-16 | Jackson | North Carolina | 37099 | 818 | 7 |
636838 | 636838 | 2020-10-16 | Johnston | North Carolina | 37101 | 5157 | 62 |
636839 | 636839 | 2020-10-16 | Jones | North Carolina | 37103 | 173 | 14 |
636840 | 636840 | 2020-10-16 | Lee | North Carolina | 37105 | 1913 | 16 |
636841 | 636841 | 2020-10-16 | Lenoir | North Carolina | 37107 | 1236 | 35 |
636842 | 636842 | 2020-10-16 | Lincoln | North Carolina | 37109 | 2098 | 16 |
636843 | 636843 | 2020-10-16 | Macon | North Carolina | 37113 | 698 | 7 |
636844 | 636844 | 2020-10-16 | Madison | North Carolina | 37115 | 135 | 1 |
636845 | 636845 | 2020-10-16 | Martin | North Carolina | 37117 | 586 | 16 |
636846 | 636846 | 2020-10-16 | McDowell | North Carolina | 37111 | 1195 | 32 |
636847 | 636847 | 2020-10-16 | Mecklenburg | North Carolina | 37119 | 31279 | 375 |
636848 | 636848 | 2020-10-16 | Mitchell | North Carolina | 37121 | 182 | 4 |
636849 | 636849 | 2020-10-16 | Montgomery | North Carolina | 37123 | 1119 | 38 |
636850 | 636850 | 2020-10-16 | Moore | North Carolina | 37125 | 2081 | 36 |
636851 | 636851 | 2020-10-16 | Nash | North Carolina | 37127 | 3037 | 60 |
636852 | 636852 | 2020-10-16 | New Hanover | North Carolina | 37129 | 4821 | 36 |
636853 | 636853 | 2020-10-16 | Northampton | North Carolina | 37131 | 514 | 18 |
636854 | 636854 | 2020-10-16 | Onslow | North Carolina | 37133 | 2880 | 26 |
636855 | 636855 | 2020-10-16 | Orange | North Carolina | 37135 | 2907 | 57 |
636856 | 636856 | 2020-10-16 | Pamlico | North Carolina | 37137 | 298 | 2 |
636857 | 636857 | 2020-10-16 | Pasquotank | North Carolina | 37139 | 806 | 33 |
636858 | 636858 | 2020-10-16 | Pender | North Carolina | 37141 | 1166 | 8 |
636859 | 636859 | 2020-10-16 | Perquimans | North Carolina | 37143 | 221 | 3 |
636860 | 636860 | 2020-10-16 | Person | North Carolina | 37145 | 541 | 9 |
636861 | 636861 | 2020-10-16 | Pitt | North Carolina | 37147 | 5703 | 35 |
636862 | 636862 | 2020-10-16 | Polk | North Carolina | 37149 | 370 | 11 |
636863 | 636863 | 2020-10-16 | Randolph | North Carolina | 37151 | 3400 | 57 |
636864 | 636864 | 2020-10-16 | Richmond | North Carolina | 37153 | 1271 | 24 |
636865 | 636865 | 2020-10-16 | Robeson | North Carolina | 37155 | 5537 | 86 |
636866 | 636866 | 2020-10-16 | Rockingham | North Carolina | 37157 | 1670 | 17 |
636867 | 636867 | 2020-10-16 | Rowan | North Carolina | 37159 | 3854 | 111 |
636868 | 636868 | 2020-10-16 | Rutherford | North Carolina | 37161 | 1535 | 54 |
636869 | 636869 | 2020-10-16 | Sampson | North Carolina | 37163 | 2503 | 28 |
636870 | 636870 | 2020-10-16 | Scotland | North Carolina | 37165 | 1498 | 21 |
636871 | 636871 | 2020-10-16 | Stanly | North Carolina | 37167 | 2328 | 57 |
636872 | 636872 | 2020-10-16 | Stokes | North Carolina | 37169 | 604 | 5 |
636873 | 636873 | 2020-10-16 | Surry | North Carolina | 37171 | 1577 | 26 |
636874 | 636874 | 2020-10-16 | Swain | North Carolina | 37173 | 207 | 3 |
636875 | 636875 | 2020-10-16 | Transylvania | North Carolina | 37175 | 383 | 9 |
636876 | 636876 | 2020-10-16 | Tyrrell | North Carolina | 37177 | 119 | 3 |
636877 | 636877 | 2020-10-16 | Union | North Carolina | 37179 | 5526 | 62 |
636878 | 636878 | 2020-10-16 | Vance | North Carolina | 37181 | 1135 | 46 |
636879 | 636879 | 2020-10-16 | Wake | North Carolina | 37183 | 19881 | 261 |
636880 | 636880 | 2020-10-16 | Warren | North Carolina | 37185 | 385 | 7 |
636881 | 636881 | 2020-10-16 | Washington | North Carolina | 37187 | 236 | 8 |
636882 | 636882 | 2020-10-16 | Watauga | North Carolina | 37189 | 1284 | 2 |
636883 | 636883 | 2020-10-16 | Wayne | North Carolina | 37191 | 4056 | 76 |
636884 | 636884 | 2020-10-16 | Wilkes | North Carolina | 37193 | 1533 | 36 |
636885 | 636885 | 2020-10-16 | Wilson | North Carolina | 37195 | 2640 | 62 |
636886 | 636886 | 2020-10-16 | Yadkin | North Carolina | 37197 | 890 | 9 |
636887 | 636887 | 2020-10-16 | Yancey | North Carolina | 37199 | 254 | 0 |
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);