ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
77,809 rows where state = "North Carolina" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
fips >30
- 37183 151
- 37037 148
- 37025 142
- 37067 142
- 37101 142
- 37119 142
- 37133 142
- 37191 141
- 37019 140
- 37049 140
- 37085 140
- 37189 139
- 37195 139
- 37063 138
- 37097 137
- 37163 137
- 37071 136
- 37081 136
- 37093 136
- 37109 136
- 37125 136
- 37129 136
- 37031 134
- 37057 134
- 37069 134
- 37135 134
- 37139 134
- 37147 134
- 37159 134
- 37167 134
- …
county >30
- Wake 151
- Chatham 148
- Cabarrus 142
- Forsyth 142
- Johnston 142
- Mecklenburg 142
- Onslow 142
- Wayne 141
- Brunswick 140
- Craven 140
- Harnett 140
- Watauga 139
- Wilson 139
- Durham 138
- Iredell 137
- Sampson 137
- Gaston 136
- Guilford 136
- Hoke 136
- Lincoln 136
- Moore 136
- New Hanover 136
- Carteret 134
- Davidson 134
- Franklin 134
- Orange 134
- Pasquotank 134
- Pitt 134
- Rowan 134
- Stanly 134
- …
state 1
- North Carolina · 12,708 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
387821 | 387821 | 2020-07-31 | Alamance | North Carolina | 37001 | 2148 | 41 |
387822 | 387822 | 2020-07-31 | Alexander | North Carolina | 37003 | 262 | 2 |
387823 | 387823 | 2020-07-31 | Alleghany | North Carolina | 37005 | 67 | 0 |
387824 | 387824 | 2020-07-31 | Anson | North Carolina | 37007 | 301 | 2 |
387825 | 387825 | 2020-07-31 | Ashe | North Carolina | 37009 | 114 | 1 |
387826 | 387826 | 2020-07-31 | Avery | North Carolina | 37011 | 79 | 0 |
387827 | 387827 | 2020-07-31 | Beaufort | North Carolina | 37013 | 335 | 2 |
387828 | 387828 | 2020-07-31 | Bertie | North Carolina | 37015 | 232 | 4 |
387829 | 387829 | 2020-07-31 | Bladen | North Carolina | 37017 | 563 | 7 |
387830 | 387830 | 2020-07-31 | Brunswick | North Carolina | 37019 | 1181 | 17 |
387831 | 387831 | 2020-07-31 | Buncombe | North Carolina | 37021 | 1605 | 56 |
387832 | 387832 | 2020-07-31 | Burke | North Carolina | 37023 | 1537 | 25 |
387833 | 387833 | 2020-07-31 | Cabarrus | North Carolina | 37025 | 2342 | 42 |
387834 | 387834 | 2020-07-31 | Caldwell | North Carolina | 37027 | 1085 | 9 |
387835 | 387835 | 2020-07-31 | Camden | North Carolina | 37029 | 56 | 2 |
387836 | 387836 | 2020-07-31 | Carteret | North Carolina | 37031 | 284 | 4 |
387837 | 387837 | 2020-07-31 | Caswell | North Carolina | 37033 | 183 | 2 |
387838 | 387838 | 2020-07-31 | Catawba | North Carolina | 37035 | 1859 | 24 |
387839 | 387839 | 2020-07-31 | Chatham | North Carolina | 37037 | 1208 | 50 |
387840 | 387840 | 2020-07-31 | Cherokee | North Carolina | 37039 | 228 | 3 |
387841 | 387841 | 2020-07-31 | Chowan | North Carolina | 37041 | 120 | 1 |
387842 | 387842 | 2020-07-31 | Clay | North Carolina | 37043 | 56 | 0 |
387843 | 387843 | 2020-07-31 | Cleveland | North Carolina | 37045 | 964 | 14 |
387844 | 387844 | 2020-07-31 | Columbus | North Carolina | 37047 | 807 | 45 |
387845 | 387845 | 2020-07-31 | Craven | North Carolina | 37049 | 621 | 10 |
387846 | 387846 | 2020-07-31 | Cumberland | North Carolina | 37051 | 2636 | 50 |
387847 | 387847 | 2020-07-31 | Currituck | North Carolina | 37053 | 70 | 0 |
387848 | 387848 | 2020-07-31 | Dare | North Carolina | 37055 | 197 | 1 |
387849 | 387849 | 2020-07-31 | Davidson | North Carolina | 37057 | 1620 | 17 |
387850 | 387850 | 2020-07-31 | Davie | North Carolina | 37059 | 349 | 3 |
387851 | 387851 | 2020-07-31 | Duplin | North Carolina | 37061 | 1913 | 42 |
387852 | 387852 | 2020-07-31 | Durham | North Carolina | 37063 | 5789 | 77 |
387853 | 387853 | 2020-07-31 | Edgecombe | North Carolina | 37065 | 564 | 11 |
387854 | 387854 | 2020-07-31 | Forsyth | North Carolina | 37067 | 4833 | 48 |
387855 | 387855 | 2020-07-31 | Franklin | North Carolina | 37069 | 762 | 25 |
387856 | 387856 | 2020-07-31 | Gaston | North Carolina | 37071 | 2939 | 33 |
387857 | 387857 | 2020-07-31 | Gates | North Carolina | 37073 | 41 | 2 |
387858 | 387858 | 2020-07-31 | Graham | North Carolina | 37075 | 23 | 0 |
387859 | 387859 | 2020-07-31 | Granville | North Carolina | 37077 | 1144 | 25 |
387860 | 387860 | 2020-07-31 | Greene | North Carolina | 37079 | 297 | 3 |
387861 | 387861 | 2020-07-31 | Guilford | North Carolina | 37081 | 5093 | 142 |
387862 | 387862 | 2020-07-31 | Halifax | North Carolina | 37083 | 610 | 6 |
387863 | 387863 | 2020-07-31 | Harnett | North Carolina | 37085 | 1094 | 36 |
387864 | 387864 | 2020-07-31 | Haywood | North Carolina | 37087 | 276 | 3 |
387865 | 387865 | 2020-07-31 | Henderson | North Carolina | 37089 | 1365 | 54 |
387866 | 387866 | 2020-07-31 | Hertford | North Carolina | 37091 | 273 | 11 |
387867 | 387867 | 2020-07-31 | Hoke | North Carolina | 37093 | 659 | 8 |
387868 | 387868 | 2020-07-31 | Hyde | North Carolina | 37095 | 37 | 0 |
387869 | 387869 | 2020-07-31 | Iredell | North Carolina | 37097 | 1661 | 16 |
387870 | 387870 | 2020-07-31 | Jackson | North Carolina | 37099 | 389 | 3 |
387871 | 387871 | 2020-07-31 | Johnston | North Carolina | 37101 | 2964 | 44 |
387872 | 387872 | 2020-07-31 | Jones | North Carolina | 37103 | 58 | 3 |
387873 | 387873 | 2020-07-31 | Lee | North Carolina | 37105 | 1141 | 9 |
387874 | 387874 | 2020-07-31 | Lenoir | North Carolina | 37107 | 522 | 11 |
387875 | 387875 | 2020-07-31 | Lincoln | North Carolina | 37109 | 721 | 3 |
387876 | 387876 | 2020-07-31 | Macon | North Carolina | 37113 | 439 | 2 |
387877 | 387877 | 2020-07-31 | Madison | North Carolina | 37115 | 38 | 0 |
387878 | 387878 | 2020-07-31 | Martin | North Carolina | 37117 | 236 | 6 |
387879 | 387879 | 2020-07-31 | McDowell | North Carolina | 37111 | 573 | 8 |
387880 | 387880 | 2020-07-31 | Mecklenburg | North Carolina | 37119 | 20502 | 202 |
387881 | 387881 | 2020-07-31 | Mitchell | North Carolina | 37121 | 74 | 2 |
387882 | 387882 | 2020-07-31 | Montgomery | North Carolina | 37123 | 569 | 13 |
387883 | 387883 | 2020-07-31 | Moore | North Carolina | 37125 | 872 | 20 |
387884 | 387884 | 2020-07-31 | Nash | North Carolina | 37127 | 994 | 10 |
387885 | 387885 | 2020-07-31 | New Hanover | North Carolina | 37129 | 2285 | 19 |
387886 | 387886 | 2020-07-31 | Northampton | North Carolina | 37131 | 274 | 16 |
387887 | 387887 | 2020-07-31 | Onslow | North Carolina | 37133 | 890 | 10 |
387888 | 387888 | 2020-07-31 | Orange | North Carolina | 37135 | 1266 | 45 |
387889 | 387889 | 2020-07-31 | Pamlico | North Carolina | 37137 | 54 | 1 |
387890 | 387890 | 2020-07-31 | Pasquotank | North Carolina | 37139 | 346 | 17 |
387891 | 387891 | 2020-07-31 | Pender | North Carolina | 37141 | 610 | 3 |
387892 | 387892 | 2020-07-31 | Perquimans | North Carolina | 37143 | 64 | 2 |
387893 | 387893 | 2020-07-31 | Person | North Carolina | 37145 | 189 | 2 |
387894 | 387894 | 2020-07-31 | Pitt | North Carolina | 37147 | 1699 | 11 |
387895 | 387895 | 2020-07-31 | Polk | North Carolina | 37149 | 132 | 5 |
387896 | 387896 | 2020-07-31 | Randolph | North Carolina | 37151 | 2026 | 36 |
387897 | 387897 | 2020-07-31 | Richmond | North Carolina | 37153 | 475 | 8 |
387898 | 387898 | 2020-07-31 | Robeson | North Carolina | 37155 | 2563 | 51 |
387899 | 387899 | 2020-07-31 | Rockingham | North Carolina | 37157 | 450 | 3 |
387900 | 387900 | 2020-07-31 | Rowan | North Carolina | 37159 | 1985 | 50 |
387901 | 387901 | 2020-07-31 | Rutherford | North Carolina | 37161 | 654 | 14 |
387902 | 387902 | 2020-07-31 | Sampson | North Carolina | 37163 | 1411 | 12 |
387903 | 387903 | 2020-07-31 | Scotland | North Carolina | 37165 | 263 | 2 |
387904 | 387904 | 2020-07-31 | Stanly | North Carolina | 37167 | 866 | 11 |
387905 | 387905 | 2020-07-31 | Stokes | North Carolina | 37169 | 248 | 3 |
387906 | 387906 | 2020-07-31 | Surry | North Carolina | 37171 | 845 | 7 |
387907 | 387907 | 2020-07-31 | Swain | North Carolina | 37173 | 103 | 2 |
387908 | 387908 | 2020-07-31 | Transylvania | North Carolina | 37175 | 121 | 1 |
387909 | 387909 | 2020-07-31 | Tyrrell | North Carolina | 37177 | 90 | 1 |
387910 | 387910 | 2020-07-31 | Union | North Carolina | 37179 | 2727 | 41 |
387911 | 387911 | 2020-07-31 | Vance | North Carolina | 37181 | 721 | 40 |
387912 | 387912 | 2020-07-31 | Wake | North Carolina | 37183 | 10913 | 128 |
387913 | 387913 | 2020-07-31 | Warren | North Carolina | 37185 | 238 | 6 |
387914 | 387914 | 2020-07-31 | Washington | North Carolina | 37187 | 114 | 3 |
387915 | 387915 | 2020-07-31 | Watauga | North Carolina | 37189 | 247 | 0 |
387916 | 387916 | 2020-07-31 | Wayne | North Carolina | 37191 | 2282 | 37 |
387917 | 387917 | 2020-07-31 | Wilkes | North Carolina | 37193 | 723 | 9 |
387918 | 387918 | 2020-07-31 | Wilson | North Carolina | 37195 | 1370 | 33 |
387919 | 387919 | 2020-07-31 | Yadkin | North Carolina | 37197 | 480 | 6 |
387920 | 387920 | 2020-07-31 | Yancey | North Carolina | 37199 | 72 | 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);