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 deaths
This data as json, yaml, Notebook, copyable, CSV (advanced)
fips >30
- 37133 787
- 37163 787
- 37183 787
- 37189 787
- 37191 787
- 37195 787
- 37019 786
- 37025 786
- 37037 786
- 37049 786
- 37063 786
- 37067 786
- 37071 786
- 37081 786
- 37085 786
- 37093 786
- 37097 786
- 37101 786
- 37109 786
- 37119 786
- 37125 786
- 37129 786
- 37031 785
- 37057 785
- 37069 785
- 37135 785
- 37139 785
- 37147 785
- 37159 785
- 37167 785
- …
county >30
- Onslow 787
- Sampson 787
- Wake 787
- Watauga 787
- Wayne 787
- Wilson 787
- Brunswick 786
- Cabarrus 786
- Chatham 786
- Craven 786
- Durham 786
- Forsyth 786
- Gaston 786
- Guilford 786
- Harnett 786
- Hoke 786
- Iredell 786
- Johnston 786
- Lincoln 786
- Mecklenburg 786
- Moore 786
- New Hanover 786
- Carteret 785
- Davidson 785
- Franklin 785
- Orange 785
- Pasquotank 785
- Pitt 785
- Rowan 785
- Stanly 785
- …
state 1
- North Carolina · 77,709 ✖
Link | rowid | date | county | state | fips | cases | deaths ▼ |
---|---|---|---|---|---|---|---|
4185 | 4185 | 2020-03-18 | Onslow | North Carolina | 37133 | 1 | 0 |
4186 | 4186 | 2020-03-18 | Sampson | North Carolina | 37163 | 1 | 0 |
4187 | 4187 | 2020-03-18 | Wake | North Carolina | 37183 | 17 | 0 |
4188 | 4188 | 2020-03-18 | Watauga | North Carolina | 37189 | 1 | 0 |
4189 | 4189 | 2020-03-18 | Wayne | North Carolina | 37191 | 1 | 0 |
4190 | 4190 | 2020-03-18 | Wilson | North Carolina | 37195 | 1 | 0 |
4900 | 4900 | 2020-03-19 | Brunswick | North Carolina | 37019 | 2 | 0 |
4901 | 4901 | 2020-03-19 | Cabarrus | North Carolina | 37025 | 1 | 0 |
4902 | 4902 | 2020-03-19 | Chatham | North Carolina | 37037 | 3 | 0 |
4903 | 4903 | 2020-03-19 | Craven | North Carolina | 37049 | 1 | 0 |
4904 | 4904 | 2020-03-19 | Durham | North Carolina | 37063 | 32 | 0 |
4905 | 4905 | 2020-03-19 | Forsyth | North Carolina | 37067 | 2 | 0 |
4906 | 4906 | 2020-03-19 | Gaston | North Carolina | 37071 | 1 | 0 |
4907 | 4907 | 2020-03-19 | Guilford | North Carolina | 37081 | 2 | 0 |
4908 | 4908 | 2020-03-19 | Harnett | North Carolina | 37085 | 6 | 0 |
4909 | 4909 | 2020-03-19 | Hoke | North Carolina | 37093 | 1 | 0 |
4910 | 4910 | 2020-03-19 | Iredell | North Carolina | 37097 | 2 | 0 |
4911 | 4911 | 2020-03-19 | Johnston | North Carolina | 37101 | 2 | 0 |
4912 | 4912 | 2020-03-19 | Lincoln | North Carolina | 37109 | 1 | 0 |
4913 | 4913 | 2020-03-19 | Mecklenburg | North Carolina | 37119 | 13 | 0 |
4914 | 4914 | 2020-03-19 | Moore | North Carolina | 37125 | 2 | 0 |
4915 | 4915 | 2020-03-19 | New Hanover | North Carolina | 37129 | 1 | 0 |
4916 | 4916 | 2020-03-19 | Onslow | North Carolina | 37133 | 1 | 0 |
4917 | 4917 | 2020-03-19 | Sampson | North Carolina | 37163 | 1 | 0 |
4918 | 4918 | 2020-03-19 | Wake | North Carolina | 37183 | 25 | 0 |
4919 | 4919 | 2020-03-19 | Watauga | North Carolina | 37189 | 2 | 0 |
4920 | 4920 | 2020-03-19 | Wayne | North Carolina | 37191 | 1 | 0 |
4921 | 4921 | 2020-03-19 | Wilson | North Carolina | 37195 | 2 | 0 |
5751 | 5751 | 2020-03-20 | Brunswick | North Carolina | 37019 | 4 | 0 |
5752 | 5752 | 2020-03-20 | Cabarrus | North Carolina | 37025 | 2 | 0 |
5753 | 5753 | 2020-03-20 | Carteret | North Carolina | 37031 | 1 | 0 |
5754 | 5754 | 2020-03-20 | Chatham | North Carolina | 37037 | 3 | 0 |
5755 | 5755 | 2020-03-20 | Craven | North Carolina | 37049 | 2 | 0 |
5756 | 5756 | 2020-03-20 | Davidson | North Carolina | 37057 | 1 | 0 |
5757 | 5757 | 2020-03-20 | Durham | North Carolina | 37063 | 33 | 0 |
5758 | 5758 | 2020-03-20 | Forsyth | North Carolina | 37067 | 7 | 0 |
5759 | 5759 | 2020-03-20 | Franklin | North Carolina | 37069 | 4 | 0 |
5760 | 5760 | 2020-03-20 | Gaston | North Carolina | 37071 | 1 | 0 |
5761 | 5761 | 2020-03-20 | Guilford | North Carolina | 37081 | 4 | 0 |
5762 | 5762 | 2020-03-20 | Harnett | North Carolina | 37085 | 6 | 0 |
5763 | 5763 | 2020-03-20 | Hoke | North Carolina | 37093 | 1 | 0 |
5764 | 5764 | 2020-03-20 | Iredell | North Carolina | 37097 | 2 | 0 |
5765 | 5765 | 2020-03-20 | Johnston | North Carolina | 37101 | 2 | 0 |
5766 | 5766 | 2020-03-20 | Lincoln | North Carolina | 37109 | 1 | 0 |
5767 | 5767 | 2020-03-20 | Mecklenburg | North Carolina | 37119 | 28 | 0 |
5768 | 5768 | 2020-03-20 | Moore | North Carolina | 37125 | 2 | 0 |
5769 | 5769 | 2020-03-20 | New Hanover | North Carolina | 37129 | 1 | 0 |
5770 | 5770 | 2020-03-20 | Onslow | North Carolina | 37133 | 1 | 0 |
5771 | 5771 | 2020-03-20 | Orange | North Carolina | 37135 | 3 | 0 |
5772 | 5772 | 2020-03-20 | Pasquotank | North Carolina | 37139 | 1 | 0 |
5773 | 5773 | 2020-03-20 | Pitt | North Carolina | 37147 | 1 | 0 |
5774 | 5774 | 2020-03-20 | Rowan | North Carolina | 37159 | 1 | 0 |
5775 | 5775 | 2020-03-20 | Sampson | North Carolina | 37163 | 1 | 0 |
5776 | 5776 | 2020-03-20 | Stanly | North Carolina | 37167 | 1 | 0 |
5777 | 5777 | 2020-03-20 | Wake | North Carolina | 37183 | 25 | 0 |
5778 | 5778 | 2020-03-20 | Watauga | North Carolina | 37189 | 2 | 0 |
5779 | 5779 | 2020-03-20 | Wayne | North Carolina | 37191 | 1 | 0 |
5780 | 5780 | 2020-03-20 | Wilson | North Carolina | 37195 | 2 | 0 |
6746 | 6746 | 2020-03-21 | Brunswick | North Carolina | 37019 | 4 | 0 |
6747 | 6747 | 2020-03-21 | Buncombe | North Carolina | 37021 | 1 | 0 |
6748 | 6748 | 2020-03-21 | Cabarrus | North Carolina | 37025 | 2 | 0 |
6749 | 6749 | 2020-03-21 | Carteret | North Carolina | 37031 | 1 | 0 |
6750 | 6750 | 2020-03-21 | Catawba | North Carolina | 37035 | 1 | 0 |
6751 | 6751 | 2020-03-21 | Chatham | North Carolina | 37037 | 3 | 0 |
6752 | 6752 | 2020-03-21 | Craven | North Carolina | 37049 | 2 | 0 |
6753 | 6753 | 2020-03-21 | Davidson | North Carolina | 37057 | 1 | 0 |
6754 | 6754 | 2020-03-21 | Durham | North Carolina | 37063 | 33 | 0 |
6755 | 6755 | 2020-03-21 | Forsyth | North Carolina | 37067 | 8 | 0 |
6756 | 6756 | 2020-03-21 | Franklin | North Carolina | 37069 | 4 | 0 |
6757 | 6757 | 2020-03-21 | Gaston | North Carolina | 37071 | 1 | 0 |
6758 | 6758 | 2020-03-21 | Guilford | North Carolina | 37081 | 4 | 0 |
6759 | 6759 | 2020-03-21 | Harnett | North Carolina | 37085 | 6 | 0 |
6760 | 6760 | 2020-03-21 | Hoke | North Carolina | 37093 | 1 | 0 |
6761 | 6761 | 2020-03-21 | Iredell | North Carolina | 37097 | 2 | 0 |
6762 | 6762 | 2020-03-21 | Johnston | North Carolina | 37101 | 2 | 0 |
6763 | 6763 | 2020-03-21 | Lincoln | North Carolina | 37109 | 1 | 0 |
6764 | 6764 | 2020-03-21 | Mecklenburg | North Carolina | 37119 | 41 | 0 |
6765 | 6765 | 2020-03-21 | Moore | North Carolina | 37125 | 2 | 0 |
6766 | 6766 | 2020-03-21 | New Hanover | North Carolina | 37129 | 1 | 0 |
6767 | 6767 | 2020-03-21 | Onslow | North Carolina | 37133 | 1 | 0 |
6768 | 6768 | 2020-03-21 | Orange | North Carolina | 37135 | 3 | 0 |
6769 | 6769 | 2020-03-21 | Pasquotank | North Carolina | 37139 | 1 | 0 |
6770 | 6770 | 2020-03-21 | Pitt | North Carolina | 37147 | 1 | 0 |
6771 | 6771 | 2020-03-21 | Rowan | North Carolina | 37159 | 1 | 0 |
6772 | 6772 | 2020-03-21 | Sampson | North Carolina | 37163 | 1 | 0 |
6773 | 6773 | 2020-03-21 | Stanly | North Carolina | 37167 | 1 | 0 |
6774 | 6774 | 2020-03-21 | Wake | North Carolina | 37183 | 49 | 0 |
6775 | 6775 | 2020-03-21 | Watauga | North Carolina | 37189 | 2 | 0 |
6776 | 6776 | 2020-03-21 | Wayne | North Carolina | 37191 | 1 | 0 |
6777 | 6777 | 2020-03-21 | Wilson | North Carolina | 37195 | 2 | 0 |
7842 | 7842 | 2020-03-22 | Brunswick | North Carolina | 37019 | 5 | 0 |
7843 | 7843 | 2020-03-22 | Buncombe | North Carolina | 37021 | 1 | 0 |
7844 | 7844 | 2020-03-22 | Cabarrus | North Carolina | 37025 | 4 | 0 |
7845 | 7845 | 2020-03-22 | Carteret | North Carolina | 37031 | 2 | 0 |
7846 | 7846 | 2020-03-22 | Catawba | North Carolina | 37035 | 1 | 0 |
7847 | 7847 | 2020-03-22 | Chatham | North Carolina | 37037 | 3 | 0 |
7848 | 7848 | 2020-03-22 | Cherokee | North Carolina | 37039 | 4 | 0 |
7849 | 7849 | 2020-03-22 | Craven | North Carolina | 37049 | 2 | 0 |
7850 | 7850 | 2020-03-22 | Cumberland | North Carolina | 37051 | 2 | 0 |
7851 | 7851 | 2020-03-22 | Davidson | North Carolina | 37057 | 1 | 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);