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
county >30
- Wake 32
- Chatham 29
- Cabarrus 23
- Forsyth 23
- Johnston 23
- Mecklenburg 23
- Onslow 23
- Wayne 22
- Brunswick 21
- Craven 21
- Harnett 21
- Watauga 20
- Wilson 20
- Durham 19
- Iredell 18
- Sampson 18
- Gaston 17
- Guilford 17
- Hoke 17
- Lincoln 17
- Moore 17
- New Hanover 17
- Carteret 15
- Davidson 15
- Franklin 15
- Orange 15
- Pasquotank 15
- Pitt 15
- Rowan 15
- Stanly 15
- …
state 1
- North Carolina · 1,028 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
29822 | 29822 | 2020-04-03 | Alamance | North Carolina | 37001 | 14 | 0 |
29823 | 29823 | 2020-04-03 | Alexander | North Carolina | 37003 | 2 | 0 |
29824 | 29824 | 2020-04-03 | Alleghany | North Carolina | 37005 | 2 | 0 |
29825 | 29825 | 2020-04-03 | Anson | North Carolina | 37007 | 3 | 0 |
29826 | 29826 | 2020-04-03 | Beaufort | North Carolina | 37013 | 7 | 0 |
29827 | 29827 | 2020-04-03 | Bertie | North Carolina | 37015 | 6 | 1 |
29828 | 29828 | 2020-04-03 | Bladen | North Carolina | 37017 | 1 | 0 |
29829 | 29829 | 2020-04-03 | Brunswick | North Carolina | 37019 | 22 | 1 |
29830 | 29830 | 2020-04-03 | Buncombe | North Carolina | 37021 | 24 | 1 |
29831 | 29831 | 2020-04-03 | Burke | North Carolina | 37023 | 10 | 0 |
29832 | 29832 | 2020-04-03 | Cabarrus | North Carolina | 37025 | 56 | 1 |
29833 | 29833 | 2020-04-03 | Caldwell | North Carolina | 37027 | 3 | 0 |
29834 | 29834 | 2020-04-03 | Carteret | North Carolina | 37031 | 14 | 0 |
29835 | 29835 | 2020-04-03 | Caswell | North Carolina | 37033 | 1 | 0 |
29836 | 29836 | 2020-04-03 | Catawba | North Carolina | 37035 | 16 | 1 |
29837 | 29837 | 2020-04-03 | Chatham | North Carolina | 37037 | 19 | 0 |
29838 | 29838 | 2020-04-03 | Cherokee | North Carolina | 37039 | 8 | 1 |
29839 | 29839 | 2020-04-03 | Chowan | North Carolina | 37041 | 1 | 0 |
29840 | 29840 | 2020-04-03 | Clay | North Carolina | 37043 | 3 | 0 |
29841 | 29841 | 2020-04-03 | Cleveland | North Carolina | 37045 | 10 | 0 |
29842 | 29842 | 2020-04-03 | Columbus | North Carolina | 37047 | 2 | 0 |
29843 | 29843 | 2020-04-03 | Craven | North Carolina | 37049 | 11 | 0 |
29844 | 29844 | 2020-04-03 | Cumberland | North Carolina | 37051 | 35 | 0 |
29845 | 29845 | 2020-04-03 | Currituck | North Carolina | 37053 | 2 | 0 |
29846 | 29846 | 2020-04-03 | Dare | North Carolina | 37055 | 1 | 0 |
29847 | 29847 | 2020-04-03 | Davidson | North Carolina | 37057 | 43 | 0 |
29848 | 29848 | 2020-04-03 | Davie | North Carolina | 37059 | 12 | 1 |
29849 | 29849 | 2020-04-03 | Duplin | North Carolina | 37061 | 3 | 0 |
29850 | 29850 | 2020-04-03 | Durham | North Carolina | 37063 | 159 | 0 |
29851 | 29851 | 2020-04-03 | Edgecombe | North Carolina | 37065 | 4 | 0 |
29852 | 29852 | 2020-04-03 | Forsyth | North Carolina | 37067 | 63 | 1 |
29853 | 29853 | 2020-04-03 | Franklin | North Carolina | 37069 | 13 | 0 |
29854 | 29854 | 2020-04-03 | Gaston | North Carolina | 37071 | 37 | 1 |
29855 | 29855 | 2020-04-03 | Gates | North Carolina | 37073 | 1 | 0 |
29856 | 29856 | 2020-04-03 | Granville | North Carolina | 37077 | 22 | 0 |
29857 | 29857 | 2020-04-03 | Greene | North Carolina | 37079 | 5 | 0 |
29858 | 29858 | 2020-04-03 | Guilford | North Carolina | 37081 | 79 | 3 |
29859 | 29859 | 2020-04-03 | Halifax | North Carolina | 37083 | 7 | 0 |
29860 | 29860 | 2020-04-03 | Harnett | North Carolina | 37085 | 19 | 1 |
29861 | 29861 | 2020-04-03 | Haywood | North Carolina | 37087 | 1 | 0 |
29862 | 29862 | 2020-04-03 | Henderson | North Carolina | 37089 | 22 | 1 |
29863 | 29863 | 2020-04-03 | Hertford | North Carolina | 37091 | 4 | 0 |
29864 | 29864 | 2020-04-03 | Hoke | North Carolina | 37093 | 9 | 0 |
29865 | 29865 | 2020-04-03 | Iredell | North Carolina | 37097 | 36 | 0 |
29866 | 29866 | 2020-04-03 | Johnston | North Carolina | 37101 | 24 | 1 |
29867 | 29867 | 2020-04-03 | Lee | North Carolina | 37105 | 3 | 0 |
29868 | 29868 | 2020-04-03 | Lenoir | North Carolina | 37107 | 5 | 0 |
29869 | 29869 | 2020-04-03 | Lincoln | North Carolina | 37109 | 9 | 0 |
29870 | 29870 | 2020-04-03 | Macon | North Carolina | 37113 | 1 | 0 |
29871 | 29871 | 2020-04-03 | Martin | North Carolina | 37117 | 3 | 0 |
29872 | 29872 | 2020-04-03 | McDowell | North Carolina | 37111 | 8 | 0 |
29873 | 29873 | 2020-04-03 | Mecklenburg | North Carolina | 37119 | 564 | 2 |
29874 | 29874 | 2020-04-03 | Mitchell | North Carolina | 37121 | 1 | 0 |
29875 | 29875 | 2020-04-03 | Montgomery | North Carolina | 37123 | 8 | 1 |
29876 | 29876 | 2020-04-03 | Moore | North Carolina | 37125 | 8 | 0 |
29877 | 29877 | 2020-04-03 | Nash | North Carolina | 37127 | 14 | 0 |
29878 | 29878 | 2020-04-03 | New Hanover | North Carolina | 37129 | 36 | 0 |
29879 | 29879 | 2020-04-03 | Northampton | North Carolina | 37131 | 33 | 0 |
29880 | 29880 | 2020-04-03 | Onslow | North Carolina | 37133 | 9 | 1 |
29881 | 29881 | 2020-04-03 | Orange | North Carolina | 37135 | 44 | 0 |
29882 | 29882 | 2020-04-03 | Pamlico | North Carolina | 37137 | 2 | 0 |
29883 | 29883 | 2020-04-03 | Pasquotank | North Carolina | 37139 | 7 | 0 |
29884 | 29884 | 2020-04-03 | Perquimans | North Carolina | 37143 | 1 | 0 |
29885 | 29885 | 2020-04-03 | Person | North Carolina | 37145 | 2 | 0 |
29886 | 29886 | 2020-04-03 | Pitt | North Carolina | 37147 | 31 | 0 |
29887 | 29887 | 2020-04-03 | Polk | North Carolina | 37149 | 6 | 0 |
29888 | 29888 | 2020-04-03 | Randolph | North Carolina | 37151 | 19 | 1 |
29889 | 29889 | 2020-04-03 | Robeson | North Carolina | 37155 | 3 | 0 |
29890 | 29890 | 2020-04-03 | Rockingham | North Carolina | 37157 | 3 | 1 |
29891 | 29891 | 2020-04-03 | Rowan | North Carolina | 37159 | 36 | 1 |
29892 | 29892 | 2020-04-03 | Rutherford | North Carolina | 37161 | 10 | 0 |
29893 | 29893 | 2020-04-03 | Sampson | North Carolina | 37163 | 1 | 0 |
29894 | 29894 | 2020-04-03 | Scotland | North Carolina | 37165 | 2 | 0 |
29895 | 29895 | 2020-04-03 | Stanly | North Carolina | 37167 | 7 | 0 |
29896 | 29896 | 2020-04-03 | Stokes | North Carolina | 37169 | 3 | 0 |
29897 | 29897 | 2020-04-03 | Surry | North Carolina | 37171 | 2 | 0 |
29898 | 29898 | 2020-04-03 | Transylvania | North Carolina | 37175 | 5 | 0 |
29899 | 29899 | 2020-04-03 | Union | North Carolina | 37179 | 60 | 0 |
29900 | 29900 | 2020-04-03 | Vance | North Carolina | 37181 | 6 | 0 |
29901 | 29901 | 2020-04-03 | Wake | North Carolina | 37183 | 258 | 0 |
29902 | 29902 | 2020-04-03 | Washington | North Carolina | 37187 | 2 | 0 |
29903 | 29903 | 2020-04-03 | Watauga | North Carolina | 37189 | 7 | 0 |
29904 | 29904 | 2020-04-03 | Wayne | North Carolina | 37191 | 9 | 0 |
29905 | 29905 | 2020-04-03 | Wilkes | North Carolina | 37193 | 4 | 1 |
29906 | 29906 | 2020-04-03 | Wilson | North Carolina | 37195 | 20 | 0 |
29907 | 29907 | 2020-04-03 | Yadkin | North Carolina | 37197 | 5 | 0 |
27498 | 27498 | 2020-04-02 | Alamance | North Carolina | 37001 | 13 | 0 |
27499 | 27499 | 2020-04-02 | Alexander | North Carolina | 37003 | 2 | 0 |
27500 | 27500 | 2020-04-02 | Alleghany | North Carolina | 37005 | 2 | 0 |
27501 | 27501 | 2020-04-02 | Anson | North Carolina | 37007 | 1 | 0 |
27502 | 27502 | 2020-04-02 | Beaufort | North Carolina | 37013 | 7 | 0 |
27503 | 27503 | 2020-04-02 | Bertie | North Carolina | 37015 | 6 | 1 |
27504 | 27504 | 2020-04-02 | Brunswick | North Carolina | 37019 | 19 | 0 |
27505 | 27505 | 2020-04-02 | Buncombe | North Carolina | 37021 | 22 | 1 |
27506 | 27506 | 2020-04-02 | Burke | North Carolina | 37023 | 9 | 0 |
27507 | 27507 | 2020-04-02 | Cabarrus | North Carolina | 37025 | 50 | 1 |
27508 | 27508 | 2020-04-02 | Caldwell | North Carolina | 37027 | 3 | 0 |
27509 | 27509 | 2020-04-02 | Carteret | North Carolina | 37031 | 13 | 0 |
27510 | 27510 | 2020-04-02 | Caswell | North Carolina | 37033 | 1 | 0 |
27511 | 27511 | 2020-04-02 | Catawba | North Carolina | 37035 | 16 | 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);