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 deaths
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date, 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 |
40531 | 40531 | 2020-04-07 | Nicholas | West Virginia | 54067 | 2 | 0 |
41548 | 41548 | 2020-04-08 | Nicholas | Kentucky | 21181 | 1 | 0 |
43103 | 43103 | 2020-04-08 | Nicholas | West Virginia | 54067 | 2 | 0 |
44124 | 44124 | 2020-04-09 | Nicholas | Kentucky | 21181 | 1 | 0 |
45699 | 45699 | 2020-04-09 | Nicholas | West Virginia | 54067 | 2 | 0 |
46732 | 46732 | 2020-04-10 | Nicholas | Kentucky | 21181 | 1 | 0 |
48327 | 48327 | 2020-04-10 | Nicholas | West Virginia | 54067 | 2 | 0 |
49372 | 49372 | 2020-04-11 | Nicholas | Kentucky | 21181 | 1 | 0 |
50986 | 50986 | 2020-04-11 | Nicholas | West Virginia | 54067 | 2 | 0 |
52039 | 52039 | 2020-04-12 | Nicholas | Kentucky | 21181 | 1 | 0 |
53663 | 53663 | 2020-04-12 | Nicholas | West Virginia | 54067 | 2 | 0 |
54720 | 54720 | 2020-04-13 | Nicholas | Kentucky | 21181 | 1 | 0 |
56353 | 56353 | 2020-04-13 | Nicholas | West Virginia | 54067 | 2 | 0 |
57418 | 57418 | 2020-04-14 | Nicholas | Kentucky | 21181 | 1 | 0 |
59060 | 59060 | 2020-04-14 | Nicholas | West Virginia | 54067 | 3 | 0 |
60127 | 60127 | 2020-04-15 | Nicholas | Kentucky | 21181 | 1 | 0 |
61779 | 61779 | 2020-04-15 | Nicholas | West Virginia | 54067 | 3 | 0 |
62847 | 62847 | 2020-04-16 | Nicholas | Kentucky | 21181 | 1 | 0 |
64512 | 64512 | 2020-04-16 | Nicholas | West Virginia | 54067 | 3 | 0 |
65586 | 65586 | 2020-04-17 | Nicholas | Kentucky | 21181 | 1 | 0 |
67260 | 67260 | 2020-04-17 | Nicholas | West Virginia | 54067 | 3 | 0 |
68335 | 68335 | 2020-04-18 | Nicholas | Kentucky | 21181 | 1 | 0 |
70022 | 70022 | 2020-04-18 | Nicholas | West Virginia | 54067 | 3 | 0 |
71098 | 71098 | 2020-04-19 | Nicholas | Kentucky | 21181 | 1 | 0 |
72791 | 72791 | 2020-04-19 | Nicholas | West Virginia | 54067 | 4 | 0 |
73870 | 73870 | 2020-04-20 | Nicholas | Kentucky | 21181 | 1 | 0 |
75567 | 75567 | 2020-04-20 | Nicholas | West Virginia | 54067 | 4 | 0 |
76651 | 76651 | 2020-04-21 | Nicholas | Kentucky | 21181 | 1 | 0 |
78350 | 78350 | 2020-04-21 | Nicholas | West Virginia | 54067 | 4 | 0 |
79436 | 79436 | 2020-04-22 | Nicholas | Kentucky | 21181 | 1 | 0 |
81143 | 81143 | 2020-04-22 | Nicholas | West Virginia | 54067 | 4 | 0 |
82233 | 82233 | 2020-04-23 | Nicholas | Kentucky | 21181 | 1 | 0 |
83944 | 83944 | 2020-04-23 | Nicholas | West Virginia | 54067 | 5 | 0 |
85036 | 85036 | 2020-04-24 | Nicholas | Kentucky | 21181 | 1 | 0 |
86751 | 86751 | 2020-04-24 | Nicholas | West Virginia | 54067 | 6 | 0 |
87845 | 87845 | 2020-04-25 | Nicholas | Kentucky | 21181 | 1 | 0 |
89567 | 89567 | 2020-04-25 | Nicholas | West Virginia | 54067 | 6 | 0 |
90661 | 90661 | 2020-04-26 | Nicholas | Kentucky | 21181 | 1 | 0 |
92385 | 92385 | 2020-04-26 | Nicholas | West Virginia | 54067 | 6 | 0 |
93482 | 93482 | 2020-04-27 | Nicholas | Kentucky | 21181 | 1 | 0 |
95214 | 95214 | 2020-04-27 | Nicholas | West Virginia | 54067 | 6 | 0 |
96316 | 96316 | 2020-04-28 | Nicholas | Kentucky | 21181 | 1 | 0 |
98059 | 98059 | 2020-04-28 | Nicholas | West Virginia | 54067 | 6 | 0 |
99162 | 99162 | 2020-04-29 | Nicholas | Kentucky | 21181 | 1 | 0 |
100909 | 100909 | 2020-04-29 | Nicholas | West Virginia | 54067 | 6 | 0 |
102014 | 102014 | 2020-04-30 | Nicholas | Kentucky | 21181 | 1 | 0 |
103764 | 103764 | 2020-04-30 | Nicholas | West Virginia | 54067 | 6 | 0 |
104875 | 104875 | 2020-05-01 | Nicholas | Kentucky | 21181 | 1 | 0 |
106628 | 106628 | 2020-05-01 | Nicholas | West Virginia | 54067 | 6 | 0 |
107740 | 107740 | 2020-05-02 | Nicholas | Kentucky | 21181 | 1 | 0 |
109497 | 109497 | 2020-05-02 | Nicholas | West Virginia | 54067 | 6 | 0 |
110611 | 110611 | 2020-05-03 | Nicholas | Kentucky | 21181 | 1 | 0 |
112371 | 112371 | 2020-05-03 | Nicholas | West Virginia | 54067 | 6 | 0 |
113488 | 113488 | 2020-05-04 | Nicholas | Kentucky | 21181 | 1 | 0 |
115254 | 115254 | 2020-05-04 | Nicholas | West Virginia | 54067 | 6 | 0 |
116370 | 116370 | 2020-05-05 | Nicholas | Kentucky | 21181 | 1 | 0 |
118213 | 118213 | 2020-05-05 | Nicholas | West Virginia | 54067 | 8 | 0 |
119331 | 119331 | 2020-05-06 | Nicholas | Kentucky | 21181 | 1 | 0 |
121178 | 121178 | 2020-05-06 | Nicholas | West Virginia | 54067 | 8 | 0 |
122302 | 122302 | 2020-05-07 | Nicholas | Kentucky | 21181 | 1 | 0 |
124158 | 124158 | 2020-05-07 | Nicholas | West Virginia | 54067 | 8 | 0 |
125284 | 125284 | 2020-05-08 | Nicholas | Kentucky | 21181 | 1 | 0 |
127143 | 127143 | 2020-05-08 | Nicholas | West Virginia | 54067 | 8 | 0 |
128272 | 128272 | 2020-05-09 | Nicholas | Kentucky | 21181 | 1 | 0 |
130133 | 130133 | 2020-05-09 | Nicholas | West Virginia | 54067 | 8 | 0 |
131262 | 131262 | 2020-05-10 | Nicholas | Kentucky | 21181 | 1 | 0 |
133123 | 133123 | 2020-05-10 | Nicholas | West Virginia | 54067 | 8 | 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 |
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);