ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
32 rows where "date" is on date 2020-03-21 and state = "North Carolina" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
fips >30
county >30
- Brunswick 1
- Buncombe 1
- Cabarrus 1
- Carteret 1
- Catawba 1
- Chatham 1
- Craven 1
- Davidson 1
- Durham 1
- Forsyth 1
- Franklin 1
- Gaston 1
- Guilford 1
- Harnett 1
- Hoke 1
- Iredell 1
- Johnston 1
- Lincoln 1
- Mecklenburg 1
- Moore 1
- New Hanover 1
- Onslow 1
- Orange 1
- Pasquotank 1
- Pitt 1
- Rowan 1
- Sampson 1
- Stanly 1
- Wake 1
- Watauga 1
- …
state 1
- North Carolina · 32 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
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 |
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);