ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
1,544 rows where county = "Nicholas" sorted by state
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date, deaths, date (date)
Link | rowid | date | county | state ▼ | fips | cases | deaths |
---|---|---|---|---|---|---|---|
16460 | 16460 | 2020-03-28 | Nicholas | Kentucky | 21181 | 1 | 0 |
18371 | 18371 | 2020-03-29 | Nicholas | Kentucky | 21181 | 1 | 0 |
20387 | 20387 | 2020-03-30 | Nicholas | Kentucky | 21181 | 1 | 0 |
22492 | 22492 | 2020-03-31 | Nicholas | Kentucky | 21181 | 1 | 0 |
24668 | 24668 | 2020-04-01 | Nicholas | Kentucky | 21181 | 1 | 0 |
26917 | 26917 | 2020-04-02 | Nicholas | Kentucky | 21181 | 1 | 0 |
29233 | 29233 | 2020-04-03 | Nicholas | Kentucky | 21181 | 1 | 0 |
31609 | 31609 | 2020-04-04 | Nicholas | Kentucky | 21181 | 1 | 0 |
34033 | 34033 | 2020-04-05 | Nicholas | Kentucky | 21181 | 1 | 0 |
36491 | 36491 | 2020-04-06 | Nicholas | Kentucky | 21181 | 1 | 0 |
38998 | 38998 | 2020-04-07 | Nicholas | Kentucky | 21181 | 1 | 0 |
41548 | 41548 | 2020-04-08 | Nicholas | Kentucky | 21181 | 1 | 0 |
44124 | 44124 | 2020-04-09 | Nicholas | Kentucky | 21181 | 1 | 0 |
46732 | 46732 | 2020-04-10 | Nicholas | Kentucky | 21181 | 1 | 0 |
49372 | 49372 | 2020-04-11 | Nicholas | Kentucky | 21181 | 1 | 0 |
52039 | 52039 | 2020-04-12 | Nicholas | Kentucky | 21181 | 1 | 0 |
54720 | 54720 | 2020-04-13 | Nicholas | Kentucky | 21181 | 1 | 0 |
57418 | 57418 | 2020-04-14 | Nicholas | Kentucky | 21181 | 1 | 0 |
60127 | 60127 | 2020-04-15 | Nicholas | Kentucky | 21181 | 1 | 0 |
62847 | 62847 | 2020-04-16 | Nicholas | Kentucky | 21181 | 1 | 0 |
65586 | 65586 | 2020-04-17 | Nicholas | Kentucky | 21181 | 1 | 0 |
68335 | 68335 | 2020-04-18 | Nicholas | Kentucky | 21181 | 1 | 0 |
71098 | 71098 | 2020-04-19 | Nicholas | Kentucky | 21181 | 1 | 0 |
73870 | 73870 | 2020-04-20 | Nicholas | Kentucky | 21181 | 1 | 0 |
76651 | 76651 | 2020-04-21 | Nicholas | Kentucky | 21181 | 1 | 0 |
79436 | 79436 | 2020-04-22 | Nicholas | Kentucky | 21181 | 1 | 0 |
82233 | 82233 | 2020-04-23 | Nicholas | Kentucky | 21181 | 1 | 0 |
85036 | 85036 | 2020-04-24 | Nicholas | Kentucky | 21181 | 1 | 0 |
87845 | 87845 | 2020-04-25 | Nicholas | Kentucky | 21181 | 1 | 0 |
90661 | 90661 | 2020-04-26 | Nicholas | Kentucky | 21181 | 1 | 0 |
93482 | 93482 | 2020-04-27 | Nicholas | Kentucky | 21181 | 1 | 0 |
96316 | 96316 | 2020-04-28 | Nicholas | Kentucky | 21181 | 1 | 0 |
99162 | 99162 | 2020-04-29 | Nicholas | Kentucky | 21181 | 1 | 0 |
102014 | 102014 | 2020-04-30 | Nicholas | Kentucky | 21181 | 1 | 0 |
104875 | 104875 | 2020-05-01 | Nicholas | Kentucky | 21181 | 1 | 0 |
107740 | 107740 | 2020-05-02 | Nicholas | Kentucky | 21181 | 1 | 0 |
110611 | 110611 | 2020-05-03 | Nicholas | Kentucky | 21181 | 1 | 0 |
113488 | 113488 | 2020-05-04 | Nicholas | Kentucky | 21181 | 1 | 0 |
116370 | 116370 | 2020-05-05 | Nicholas | Kentucky | 21181 | 1 | 0 |
119331 | 119331 | 2020-05-06 | Nicholas | Kentucky | 21181 | 1 | 0 |
122302 | 122302 | 2020-05-07 | Nicholas | Kentucky | 21181 | 1 | 0 |
125284 | 125284 | 2020-05-08 | Nicholas | Kentucky | 21181 | 1 | 0 |
128272 | 128272 | 2020-05-09 | Nicholas | Kentucky | 21181 | 1 | 0 |
131262 | 131262 | 2020-05-10 | Nicholas | Kentucky | 21181 | 1 | 0 |
134253 | 134253 | 2020-05-11 | Nicholas | Kentucky | 21181 | 1 | 0 |
137243 | 137243 | 2020-05-12 | Nicholas | Kentucky | 21181 | 1 | 0 |
140236 | 140236 | 2020-05-13 | Nicholas | Kentucky | 21181 | 1 | 0 |
143232 | 143232 | 2020-05-14 | Nicholas | Kentucky | 21181 | 1 | 0 |
146232 | 146232 | 2020-05-15 | Nicholas | Kentucky | 21181 | 1 | 0 |
149237 | 149237 | 2020-05-16 | Nicholas | Kentucky | 21181 | 1 | 0 |
152248 | 152248 | 2020-05-17 | Nicholas | Kentucky | 21181 | 1 | 0 |
155262 | 155262 | 2020-05-18 | Nicholas | Kentucky | 21181 | 1 | 0 |
158279 | 158279 | 2020-05-19 | Nicholas | Kentucky | 21181 | 1 | 0 |
161305 | 161305 | 2020-05-20 | Nicholas | Kentucky | 21181 | 1 | 0 |
164334 | 164334 | 2020-05-21 | Nicholas | Kentucky | 21181 | 1 | 0 |
167370 | 167370 | 2020-05-22 | Nicholas | Kentucky | 21181 | 1 | 0 |
170408 | 170408 | 2020-05-23 | Nicholas | Kentucky | 21181 | 1 | 0 |
173449 | 173449 | 2020-05-24 | Nicholas | Kentucky | 21181 | 1 | 0 |
176493 | 176493 | 2020-05-25 | Nicholas | Kentucky | 21181 | 1 | 0 |
179537 | 179537 | 2020-05-26 | Nicholas | Kentucky | 21181 | 1 | 0 |
182582 | 182582 | 2020-05-27 | Nicholas | Kentucky | 21181 | 3 | 0 |
185637 | 185637 | 2020-05-28 | Nicholas | Kentucky | 21181 | 3 | 0 |
188695 | 188695 | 2020-05-29 | Nicholas | Kentucky | 21181 | 3 | 0 |
191759 | 191759 | 2020-05-30 | Nicholas | Kentucky | 21181 | 3 | 0 |
194827 | 194827 | 2020-05-31 | Nicholas | Kentucky | 21181 | 3 | 0 |
197898 | 197898 | 2020-06-01 | Nicholas | Kentucky | 21181 | 3 | 0 |
200970 | 200970 | 2020-06-02 | Nicholas | Kentucky | 21181 | 3 | 0 |
204047 | 204047 | 2020-06-03 | Nicholas | Kentucky | 21181 | 3 | 0 |
207128 | 207128 | 2020-06-04 | Nicholas | Kentucky | 21181 | 3 | 0 |
210209 | 210209 | 2020-06-05 | Nicholas | Kentucky | 21181 | 4 | 0 |
213294 | 213294 | 2020-06-06 | Nicholas | Kentucky | 21181 | 4 | 0 |
216381 | 216381 | 2020-06-07 | Nicholas | Kentucky | 21181 | 4 | 0 |
219473 | 219473 | 2020-06-08 | Nicholas | Kentucky | 21181 | 4 | 0 |
222568 | 222568 | 2020-06-09 | Nicholas | Kentucky | 21181 | 4 | 0 |
225664 | 225664 | 2020-06-10 | Nicholas | Kentucky | 21181 | 4 | 0 |
228766 | 228766 | 2020-06-11 | Nicholas | Kentucky | 21181 | 4 | 0 |
231870 | 231870 | 2020-06-12 | Nicholas | Kentucky | 21181 | 4 | 0 |
234975 | 234975 | 2020-06-13 | Nicholas | Kentucky | 21181 | 4 | 0 |
238082 | 238082 | 2020-06-14 | Nicholas | Kentucky | 21181 | 4 | 0 |
241191 | 241191 | 2020-06-15 | Nicholas | Kentucky | 21181 | 4 | 0 |
244302 | 244302 | 2020-06-16 | Nicholas | Kentucky | 21181 | 4 | 0 |
247415 | 247415 | 2020-06-17 | Nicholas | Kentucky | 21181 | 4 | 0 |
250527 | 250527 | 2020-06-18 | Nicholas | Kentucky | 21181 | 4 | 0 |
253642 | 253642 | 2020-06-19 | Nicholas | Kentucky | 21181 | 5 | 0 |
256762 | 256762 | 2020-06-20 | Nicholas | Kentucky | 21181 | 5 | 0 |
259888 | 259888 | 2020-06-21 | Nicholas | Kentucky | 21181 | 5 | 0 |
263017 | 263017 | 2020-06-22 | Nicholas | Kentucky | 21181 | 5 | 0 |
266144 | 266144 | 2020-06-23 | Nicholas | Kentucky | 21181 | 5 | 0 |
269277 | 269277 | 2020-06-24 | Nicholas | Kentucky | 21181 | 5 | 0 |
272413 | 272413 | 2020-06-25 | Nicholas | Kentucky | 21181 | 5 | 0 |
275556 | 275556 | 2020-06-26 | Nicholas | Kentucky | 21181 | 5 | 0 |
278704 | 278704 | 2020-06-27 | Nicholas | Kentucky | 21181 | 5 | 0 |
281852 | 281852 | 2020-06-28 | Nicholas | Kentucky | 21181 | 5 | 0 |
284998 | 284998 | 2020-06-29 | Nicholas | Kentucky | 21181 | 5 | 0 |
288147 | 288147 | 2020-06-30 | Nicholas | Kentucky | 21181 | 5 | 0 |
291297 | 291297 | 2020-07-01 | Nicholas | Kentucky | 21181 | 5 | 0 |
294451 | 294451 | 2020-07-02 | Nicholas | Kentucky | 21181 | 6 | 0 |
297609 | 297609 | 2020-07-03 | Nicholas | Kentucky | 21181 | 8 | 0 |
300771 | 300771 | 2020-07-04 | Nicholas | Kentucky | 21181 | 8 | 0 |
303935 | 303935 | 2020-07-05 | Nicholas | Kentucky | 21181 | 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);