ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
1,533 rows where county = "Alexander" sorted by rowid
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date, cases, date (date)
Link | rowid ▼ | date | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
20920 | 20920 | 2020-03-30 | Alexander | North Carolina | 37003 | 1 | 0 |
23044 | 23044 | 2020-03-31 | Alexander | North Carolina | 37003 | 2 | 0 |
25238 | 25238 | 2020-04-01 | Alexander | North Carolina | 37003 | 2 | 0 |
27499 | 27499 | 2020-04-02 | Alexander | North Carolina | 37003 | 2 | 0 |
29823 | 29823 | 2020-04-03 | Alexander | North Carolina | 37003 | 2 | 0 |
32209 | 32209 | 2020-04-04 | Alexander | North Carolina | 37003 | 2 | 0 |
34640 | 34640 | 2020-04-05 | Alexander | North Carolina | 37003 | 2 | 0 |
37109 | 37109 | 2020-04-06 | Alexander | North Carolina | 37003 | 2 | 0 |
39624 | 39624 | 2020-04-07 | Alexander | North Carolina | 37003 | 2 | 0 |
42181 | 42181 | 2020-04-08 | Alexander | North Carolina | 37003 | 2 | 0 |
44764 | 44764 | 2020-04-09 | Alexander | North Carolina | 37003 | 2 | 0 |
47377 | 47377 | 2020-04-10 | Alexander | North Carolina | 37003 | 2 | 0 |
50032 | 50032 | 2020-04-11 | Alexander | North Carolina | 37003 | 2 | 0 |
52705 | 52705 | 2020-04-12 | Alexander | North Carolina | 37003 | 2 | 0 |
55388 | 55388 | 2020-04-13 | Alexander | North Carolina | 37003 | 2 | 0 |
58088 | 58088 | 2020-04-14 | Alexander | North Carolina | 37003 | 3 | 0 |
60802 | 60802 | 2020-04-15 | Alexander | North Carolina | 37003 | 3 | 0 |
62440 | 62440 | 2020-04-16 | Alexander | Illinois | 17003 | 1 | 0 |
63528 | 63528 | 2020-04-16 | Alexander | North Carolina | 37003 | 3 | 0 |
65172 | 65172 | 2020-04-17 | Alexander | Illinois | 17003 | 1 | 0 |
66271 | 66271 | 2020-04-17 | Alexander | North Carolina | 37003 | 3 | 0 |
67920 | 67920 | 2020-04-18 | Alexander | Illinois | 17003 | 1 | 0 |
69028 | 69028 | 2020-04-18 | Alexander | North Carolina | 37003 | 3 | 0 |
70682 | 70682 | 2020-04-19 | Alexander | Illinois | 17003 | 2 | 0 |
71794 | 71794 | 2020-04-19 | Alexander | North Carolina | 37003 | 3 | 0 |
73451 | 73451 | 2020-04-20 | Alexander | Illinois | 17003 | 2 | 0 |
74569 | 74569 | 2020-04-20 | Alexander | North Carolina | 37003 | 3 | 0 |
76227 | 76227 | 2020-04-21 | Alexander | Illinois | 17003 | 2 | 0 |
77350 | 77350 | 2020-04-21 | Alexander | North Carolina | 37003 | 3 | 0 |
79011 | 79011 | 2020-04-22 | Alexander | Illinois | 17003 | 2 | 0 |
80139 | 80139 | 2020-04-22 | Alexander | North Carolina | 37003 | 3 | 0 |
81804 | 81804 | 2020-04-23 | Alexander | Illinois | 17003 | 2 | 0 |
82938 | 82938 | 2020-04-23 | Alexander | North Carolina | 37003 | 4 | 0 |
84604 | 84604 | 2020-04-24 | Alexander | Illinois | 17003 | 2 | 0 |
85742 | 85742 | 2020-04-24 | Alexander | North Carolina | 37003 | 4 | 0 |
87414 | 87414 | 2020-04-25 | Alexander | Illinois | 17003 | 2 | 0 |
88554 | 88554 | 2020-04-25 | Alexander | North Carolina | 37003 | 4 | 0 |
90230 | 90230 | 2020-04-26 | Alexander | Illinois | 17003 | 3 | 0 |
91369 | 91369 | 2020-04-26 | Alexander | North Carolina | 37003 | 4 | 0 |
93049 | 93049 | 2020-04-27 | Alexander | Illinois | 17003 | 3 | 0 |
94194 | 94194 | 2020-04-27 | Alexander | North Carolina | 37003 | 4 | 0 |
95881 | 95881 | 2020-04-28 | Alexander | Illinois | 17003 | 3 | 0 |
97030 | 97030 | 2020-04-28 | Alexander | North Carolina | 37003 | 4 | 0 |
98725 | 98725 | 2020-04-29 | Alexander | Illinois | 17003 | 3 | 0 |
99877 | 99877 | 2020-04-29 | Alexander | North Carolina | 37003 | 4 | 0 |
101576 | 101576 | 2020-04-30 | Alexander | Illinois | 17003 | 3 | 0 |
102730 | 102730 | 2020-04-30 | Alexander | North Carolina | 37003 | 4 | 0 |
104431 | 104431 | 2020-05-01 | Alexander | Illinois | 17003 | 3 | 0 |
105592 | 105592 | 2020-05-01 | Alexander | North Carolina | 37003 | 4 | 0 |
107296 | 107296 | 2020-05-02 | Alexander | Illinois | 17003 | 4 | 0 |
108459 | 108459 | 2020-05-02 | Alexander | North Carolina | 37003 | 4 | 0 |
110166 | 110166 | 2020-05-03 | Alexander | Illinois | 17003 | 4 | 0 |
111332 | 111332 | 2020-05-03 | Alexander | North Carolina | 37003 | 4 | 0 |
113041 | 113041 | 2020-05-04 | Alexander | Illinois | 17003 | 4 | 0 |
114213 | 114213 | 2020-05-04 | Alexander | North Carolina | 37003 | 4 | 0 |
115924 | 115924 | 2020-05-05 | Alexander | Illinois | 17003 | 4 | 0 |
117093 | 117093 | 2020-05-05 | Alexander | North Carolina | 37003 | 5 | 0 |
118884 | 118884 | 2020-05-06 | Alexander | Illinois | 17003 | 6 | 0 |
120054 | 120054 | 2020-05-06 | Alexander | North Carolina | 37003 | 6 | 0 |
121854 | 121854 | 2020-05-07 | Alexander | Illinois | 17003 | 6 | 0 |
123029 | 123029 | 2020-05-07 | Alexander | North Carolina | 37003 | 8 | 0 |
124833 | 124833 | 2020-05-08 | Alexander | Illinois | 17003 | 6 | 0 |
126012 | 126012 | 2020-05-08 | Alexander | North Carolina | 37003 | 8 | 0 |
127820 | 127820 | 2020-05-09 | Alexander | Illinois | 17003 | 6 | 0 |
129001 | 129001 | 2020-05-09 | Alexander | North Carolina | 37003 | 10 | 0 |
130811 | 130811 | 2020-05-10 | Alexander | Illinois | 17003 | 7 | 0 |
131990 | 131990 | 2020-05-10 | Alexander | North Carolina | 37003 | 12 | 0 |
133802 | 133802 | 2020-05-11 | Alexander | Illinois | 17003 | 7 | 0 |
134981 | 134981 | 2020-05-11 | Alexander | North Carolina | 37003 | 12 | 0 |
136791 | 136791 | 2020-05-12 | Alexander | Illinois | 17003 | 8 | 0 |
137971 | 137971 | 2020-05-12 | Alexander | North Carolina | 37003 | 13 | 0 |
139782 | 139782 | 2020-05-13 | Alexander | Illinois | 17003 | 8 | 0 |
140967 | 140967 | 2020-05-13 | Alexander | North Carolina | 37003 | 14 | 0 |
142778 | 142778 | 2020-05-14 | Alexander | Illinois | 17003 | 8 | 0 |
143962 | 143962 | 2020-05-14 | Alexander | North Carolina | 37003 | 15 | 0 |
145778 | 145778 | 2020-05-15 | Alexander | Illinois | 17003 | 8 | 0 |
146963 | 146963 | 2020-05-15 | Alexander | North Carolina | 37003 | 15 | 0 |
148781 | 148781 | 2020-05-16 | Alexander | Illinois | 17003 | 8 | 0 |
149970 | 149970 | 2020-05-16 | Alexander | North Carolina | 37003 | 18 | 0 |
151790 | 151790 | 2020-05-17 | Alexander | Illinois | 17003 | 8 | 0 |
152980 | 152980 | 2020-05-17 | Alexander | North Carolina | 37003 | 21 | 0 |
154802 | 154802 | 2020-05-18 | Alexander | Illinois | 17003 | 8 | 0 |
155997 | 155997 | 2020-05-18 | Alexander | North Carolina | 37003 | 21 | 0 |
157818 | 157818 | 2020-05-19 | Alexander | Illinois | 17003 | 8 | 0 |
159015 | 159015 | 2020-05-19 | Alexander | North Carolina | 37003 | 21 | 0 |
160844 | 160844 | 2020-05-20 | Alexander | Illinois | 17003 | 8 | 0 |
162042 | 162042 | 2020-05-20 | Alexander | North Carolina | 37003 | 23 | 0 |
163872 | 163872 | 2020-05-21 | Alexander | Illinois | 17003 | 8 | 0 |
165071 | 165071 | 2020-05-21 | Alexander | North Carolina | 37003 | 23 | 0 |
166905 | 166905 | 2020-05-22 | Alexander | Illinois | 17003 | 8 | 0 |
168106 | 168106 | 2020-05-22 | Alexander | North Carolina | 37003 | 23 | 0 |
169942 | 169942 | 2020-05-23 | Alexander | Illinois | 17003 | 8 | 0 |
171145 | 171145 | 2020-05-23 | Alexander | North Carolina | 37003 | 27 | 0 |
172983 | 172983 | 2020-05-24 | Alexander | Illinois | 17003 | 8 | 0 |
174187 | 174187 | 2020-05-24 | Alexander | North Carolina | 37003 | 27 | 0 |
176027 | 176027 | 2020-05-25 | Alexander | Illinois | 17003 | 8 | 0 |
177231 | 177231 | 2020-05-25 | Alexander | North Carolina | 37003 | 27 | 0 |
179071 | 179071 | 2020-05-26 | Alexander | Illinois | 17003 | 8 | 0 |
180274 | 180274 | 2020-05-26 | Alexander | North Carolina | 37003 | 27 | 0 |
182115 | 182115 | 2020-05-27 | Alexander | Illinois | 17003 | 8 | 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);