ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
3,702 rows where county = "Carter" sorted by fips
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date, deaths, date (date)
county 1
- Carter · 3,702 ✖
Link | rowid | date | county | state | fips ▼ | cases | deaths |
---|---|---|---|---|---|---|---|
33984 | 33984 | 2020-04-05 | Carter | Kentucky | 21043 | 1 | 0 |
36442 | 36442 | 2020-04-06 | Carter | Kentucky | 21043 | 1 | 0 |
38947 | 38947 | 2020-04-07 | Carter | Kentucky | 21043 | 1 | 0 |
41496 | 41496 | 2020-04-08 | Carter | Kentucky | 21043 | 1 | 0 |
44071 | 44071 | 2020-04-09 | Carter | Kentucky | 21043 | 1 | 0 |
46679 | 46679 | 2020-04-10 | Carter | Kentucky | 21043 | 1 | 0 |
49316 | 49316 | 2020-04-11 | Carter | Kentucky | 21043 | 1 | 0 |
51982 | 51982 | 2020-04-12 | Carter | Kentucky | 21043 | 3 | 0 |
54663 | 54663 | 2020-04-13 | Carter | Kentucky | 21043 | 3 | 0 |
57358 | 57358 | 2020-04-14 | Carter | Kentucky | 21043 | 3 | 0 |
60067 | 60067 | 2020-04-15 | Carter | Kentucky | 21043 | 5 | 0 |
62787 | 62787 | 2020-04-16 | Carter | Kentucky | 21043 | 5 | 0 |
65526 | 65526 | 2020-04-17 | Carter | Kentucky | 21043 | 5 | 0 |
68275 | 68275 | 2020-04-18 | Carter | Kentucky | 21043 | 4 | 0 |
71036 | 71036 | 2020-04-19 | Carter | Kentucky | 21043 | 4 | 0 |
73808 | 73808 | 2020-04-20 | Carter | Kentucky | 21043 | 4 | 0 |
76588 | 76588 | 2020-04-21 | Carter | Kentucky | 21043 | 4 | 0 |
79373 | 79373 | 2020-04-22 | Carter | Kentucky | 21043 | 4 | 0 |
82170 | 82170 | 2020-04-23 | Carter | Kentucky | 21043 | 4 | 0 |
84973 | 84973 | 2020-04-24 | Carter | Kentucky | 21043 | 4 | 0 |
87782 | 87782 | 2020-04-25 | Carter | Kentucky | 21043 | 4 | 0 |
90598 | 90598 | 2020-04-26 | Carter | Kentucky | 21043 | 4 | 0 |
93419 | 93419 | 2020-04-27 | Carter | Kentucky | 21043 | 4 | 0 |
96252 | 96252 | 2020-04-28 | Carter | Kentucky | 21043 | 5 | 0 |
99098 | 99098 | 2020-04-29 | Carter | Kentucky | 21043 | 5 | 0 |
101950 | 101950 | 2020-04-30 | Carter | Kentucky | 21043 | 5 | 0 |
104811 | 104811 | 2020-05-01 | Carter | Kentucky | 21043 | 5 | 0 |
107676 | 107676 | 2020-05-02 | Carter | Kentucky | 21043 | 5 | 0 |
110547 | 110547 | 2020-05-03 | Carter | Kentucky | 21043 | 6 | 0 |
113424 | 113424 | 2020-05-04 | Carter | Kentucky | 21043 | 6 | 0 |
116306 | 116306 | 2020-05-05 | Carter | Kentucky | 21043 | 6 | 0 |
119267 | 119267 | 2020-05-06 | Carter | Kentucky | 21043 | 6 | 0 |
122237 | 122237 | 2020-05-07 | Carter | Kentucky | 21043 | 6 | 0 |
125219 | 125219 | 2020-05-08 | Carter | Kentucky | 21043 | 6 | 0 |
128207 | 128207 | 2020-05-09 | Carter | Kentucky | 21043 | 6 | 0 |
131197 | 131197 | 2020-05-10 | Carter | Kentucky | 21043 | 6 | 0 |
134188 | 134188 | 2020-05-11 | Carter | Kentucky | 21043 | 6 | 0 |
137178 | 137178 | 2020-05-12 | Carter | Kentucky | 21043 | 7 | 0 |
140171 | 140171 | 2020-05-13 | Carter | Kentucky | 21043 | 7 | 0 |
143167 | 143167 | 2020-05-14 | Carter | Kentucky | 21043 | 7 | 0 |
146167 | 146167 | 2020-05-15 | Carter | Kentucky | 21043 | 8 | 0 |
149171 | 149171 | 2020-05-16 | Carter | Kentucky | 21043 | 8 | 0 |
152182 | 152182 | 2020-05-17 | Carter | Kentucky | 21043 | 8 | 0 |
155196 | 155196 | 2020-05-18 | Carter | Kentucky | 21043 | 8 | 0 |
158213 | 158213 | 2020-05-19 | Carter | Kentucky | 21043 | 9 | 0 |
161238 | 161238 | 2020-05-20 | Carter | Kentucky | 21043 | 9 | 0 |
164267 | 164267 | 2020-05-21 | Carter | Kentucky | 21043 | 9 | 0 |
167303 | 167303 | 2020-05-22 | Carter | Kentucky | 21043 | 9 | 0 |
170341 | 170341 | 2020-05-23 | Carter | Kentucky | 21043 | 9 | 0 |
173382 | 173382 | 2020-05-24 | Carter | Kentucky | 21043 | 9 | 0 |
176426 | 176426 | 2020-05-25 | Carter | Kentucky | 21043 | 9 | 0 |
179470 | 179470 | 2020-05-26 | Carter | Kentucky | 21043 | 9 | 0 |
182515 | 182515 | 2020-05-27 | Carter | Kentucky | 21043 | 9 | 0 |
185569 | 185569 | 2020-05-28 | Carter | Kentucky | 21043 | 9 | 0 |
188627 | 188627 | 2020-05-29 | Carter | Kentucky | 21043 | 9 | 0 |
191691 | 191691 | 2020-05-30 | Carter | Kentucky | 21043 | 11 | 0 |
194759 | 194759 | 2020-05-31 | Carter | Kentucky | 21043 | 11 | 0 |
197830 | 197830 | 2020-06-01 | Carter | Kentucky | 21043 | 12 | 0 |
200901 | 200901 | 2020-06-02 | Carter | Kentucky | 21043 | 12 | 0 |
203978 | 203978 | 2020-06-03 | Carter | Kentucky | 21043 | 14 | 0 |
207059 | 207059 | 2020-06-04 | Carter | Kentucky | 21043 | 14 | 0 |
210140 | 210140 | 2020-06-05 | Carter | Kentucky | 21043 | 14 | 0 |
213225 | 213225 | 2020-06-06 | Carter | Kentucky | 21043 | 17 | 0 |
216312 | 216312 | 2020-06-07 | Carter | Kentucky | 21043 | 17 | 0 |
219404 | 219404 | 2020-06-08 | Carter | Kentucky | 21043 | 17 | 0 |
222499 | 222499 | 2020-06-09 | Carter | Kentucky | 21043 | 17 | 0 |
225595 | 225595 | 2020-06-10 | Carter | Kentucky | 21043 | 17 | 0 |
228697 | 228697 | 2020-06-11 | Carter | Kentucky | 21043 | 17 | 0 |
231801 | 231801 | 2020-06-12 | Carter | Kentucky | 21043 | 17 | 0 |
234906 | 234906 | 2020-06-13 | Carter | Kentucky | 21043 | 18 | 0 |
238013 | 238013 | 2020-06-14 | Carter | Kentucky | 21043 | 18 | 0 |
241122 | 241122 | 2020-06-15 | Carter | Kentucky | 21043 | 18 | 0 |
244233 | 244233 | 2020-06-16 | Carter | Kentucky | 21043 | 18 | 0 |
247346 | 247346 | 2020-06-17 | Carter | Kentucky | 21043 | 21 | 0 |
250458 | 250458 | 2020-06-18 | Carter | Kentucky | 21043 | 20 | 0 |
253573 | 253573 | 2020-06-19 | Carter | Kentucky | 21043 | 21 | 0 |
256693 | 256693 | 2020-06-20 | Carter | Kentucky | 21043 | 21 | 0 |
259819 | 259819 | 2020-06-21 | Carter | Kentucky | 21043 | 21 | 0 |
262948 | 262948 | 2020-06-22 | Carter | Kentucky | 21043 | 21 | 0 |
266075 | 266075 | 2020-06-23 | Carter | Kentucky | 21043 | 21 | 0 |
269208 | 269208 | 2020-06-24 | Carter | Kentucky | 21043 | 21 | 0 |
272344 | 272344 | 2020-06-25 | Carter | Kentucky | 21043 | 22 | 0 |
275487 | 275487 | 2020-06-26 | Carter | Kentucky | 21043 | 22 | 0 |
278635 | 278635 | 2020-06-27 | Carter | Kentucky | 21043 | 22 | 0 |
281783 | 281783 | 2020-06-28 | Carter | Kentucky | 21043 | 22 | 0 |
284929 | 284929 | 2020-06-29 | Carter | Kentucky | 21043 | 22 | 0 |
288078 | 288078 | 2020-06-30 | Carter | Kentucky | 21043 | 23 | 0 |
291228 | 291228 | 2020-07-01 | Carter | Kentucky | 21043 | 25 | 0 |
294382 | 294382 | 2020-07-02 | Carter | Kentucky | 21043 | 26 | 0 |
297540 | 297540 | 2020-07-03 | Carter | Kentucky | 21043 | 29 | 0 |
300702 | 300702 | 2020-07-04 | Carter | Kentucky | 21043 | 29 | 0 |
303866 | 303866 | 2020-07-05 | Carter | Kentucky | 21043 | 29 | 0 |
307033 | 307033 | 2020-07-06 | Carter | Kentucky | 21043 | 31 | 0 |
310201 | 310201 | 2020-07-07 | Carter | Kentucky | 21043 | 32 | 0 |
313371 | 313371 | 2020-07-08 | Carter | Kentucky | 21043 | 32 | 0 |
316545 | 316545 | 2020-07-09 | Carter | Kentucky | 21043 | 32 | 0 |
319720 | 319720 | 2020-07-10 | Carter | Kentucky | 21043 | 37 | 0 |
322899 | 322899 | 2020-07-11 | Carter | Kentucky | 21043 | 37 | 0 |
326082 | 326082 | 2020-07-12 | Carter | Kentucky | 21043 | 38 | 0 |
329268 | 329268 | 2020-07-13 | Carter | Kentucky | 21043 | 38 | 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);