ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
786 rows where fips = 21101 and state = "Kentucky" sorted by date
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date ▼ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
4673 | 4673 | 2020-03-19 | Henderson | Kentucky | 21101 | 1 | 0 |
5487 | 5487 | 2020-03-20 | Henderson | Kentucky | 21101 | 2 | 0 |
6433 | 6433 | 2020-03-21 | Henderson | Kentucky | 21101 | 3 | 0 |
7505 | 7505 | 2020-03-22 | Henderson | Kentucky | 21101 | 5 | 0 |
8667 | 8667 | 2020-03-23 | Henderson | Kentucky | 21101 | 5 | 0 |
9950 | 9950 | 2020-03-24 | Henderson | Kentucky | 21101 | 5 | 0 |
11351 | 11351 | 2020-03-25 | Henderson | Kentucky | 21101 | 5 | 0 |
12921 | 12921 | 2020-03-26 | Henderson | Kentucky | 21101 | 5 | 0 |
14626 | 14626 | 2020-03-27 | Henderson | Kentucky | 21101 | 5 | 0 |
16441 | 16441 | 2020-03-28 | Henderson | Kentucky | 21101 | 5 | 0 |
18351 | 18351 | 2020-03-29 | Henderson | Kentucky | 21101 | 5 | 0 |
20365 | 20365 | 2020-03-30 | Henderson | Kentucky | 21101 | 5 | 0 |
22468 | 22468 | 2020-03-31 | Henderson | Kentucky | 21101 | 5 | 0 |
24644 | 24644 | 2020-04-01 | Henderson | Kentucky | 21101 | 7 | 0 |
26891 | 26891 | 2020-04-02 | Henderson | Kentucky | 21101 | 7 | 0 |
29207 | 29207 | 2020-04-03 | Henderson | Kentucky | 21101 | 7 | 0 |
31583 | 31583 | 2020-04-04 | Henderson | Kentucky | 21101 | 9 | 0 |
34002 | 34002 | 2020-04-05 | Henderson | Kentucky | 21101 | 15 | 0 |
36460 | 36460 | 2020-04-06 | Henderson | Kentucky | 21101 | 15 | 0 |
38967 | 38967 | 2020-04-07 | Henderson | Kentucky | 21101 | 20 | 0 |
41516 | 41516 | 2020-04-08 | Henderson | Kentucky | 21101 | 20 | 0 |
44091 | 44091 | 2020-04-09 | Henderson | Kentucky | 21101 | 23 | 0 |
46699 | 46699 | 2020-04-10 | Henderson | Kentucky | 21101 | 23 | 0 |
49338 | 49338 | 2020-04-11 | Henderson | Kentucky | 21101 | 29 | 0 |
52004 | 52004 | 2020-04-12 | Henderson | Kentucky | 21101 | 23 | 0 |
54685 | 54685 | 2020-04-13 | Henderson | Kentucky | 21101 | 23 | 0 |
57382 | 57382 | 2020-04-14 | Henderson | Kentucky | 21101 | 24 | 0 |
60091 | 60091 | 2020-04-15 | Henderson | Kentucky | 21101 | 26 | 0 |
62811 | 62811 | 2020-04-16 | Henderson | Kentucky | 21101 | 28 | 0 |
65550 | 65550 | 2020-04-17 | Henderson | Kentucky | 21101 | 30 | 0 |
68299 | 68299 | 2020-04-18 | Henderson | Kentucky | 21101 | 30 | 0 |
71062 | 71062 | 2020-04-19 | Henderson | Kentucky | 21101 | 36 | 0 |
73834 | 73834 | 2020-04-20 | Henderson | Kentucky | 21101 | 36 | 0 |
76614 | 76614 | 2020-04-21 | Henderson | Kentucky | 21101 | 43 | 0 |
79399 | 79399 | 2020-04-22 | Henderson | Kentucky | 21101 | 43 | 0 |
82196 | 82196 | 2020-04-23 | Henderson | Kentucky | 21101 | 47 | 1 |
84999 | 84999 | 2020-04-24 | Henderson | Kentucky | 21101 | 47 | 1 |
87808 | 87808 | 2020-04-25 | Henderson | Kentucky | 21101 | 47 | 1 |
90624 | 90624 | 2020-04-26 | Henderson | Kentucky | 21101 | 58 | 1 |
93445 | 93445 | 2020-04-27 | Henderson | Kentucky | 21101 | 58 | 1 |
96278 | 96278 | 2020-04-28 | Henderson | Kentucky | 21101 | 63 | 1 |
99124 | 99124 | 2020-04-29 | Henderson | Kentucky | 21101 | 63 | 1 |
101976 | 101976 | 2020-04-30 | Henderson | Kentucky | 21101 | 63 | 1 |
104837 | 104837 | 2020-05-01 | Henderson | Kentucky | 21101 | 63 | 1 |
107702 | 107702 | 2020-05-02 | Henderson | Kentucky | 21101 | 63 | 1 |
110573 | 110573 | 2020-05-03 | Henderson | Kentucky | 21101 | 65 | 1 |
113450 | 113450 | 2020-05-04 | Henderson | Kentucky | 21101 | 72 | 1 |
116332 | 116332 | 2020-05-05 | Henderson | Kentucky | 21101 | 74 | 2 |
119293 | 119293 | 2020-05-06 | Henderson | Kentucky | 21101 | 76 | 2 |
122264 | 122264 | 2020-05-07 | Henderson | Kentucky | 21101 | 79 | 2 |
125246 | 125246 | 2020-05-08 | Henderson | Kentucky | 21101 | 79 | 2 |
128234 | 128234 | 2020-05-09 | Henderson | Kentucky | 21101 | 81 | 2 |
131224 | 131224 | 2020-05-10 | Henderson | Kentucky | 21101 | 82 | 2 |
134215 | 134215 | 2020-05-11 | Henderson | Kentucky | 21101 | 82 | 3 |
137205 | 137205 | 2020-05-12 | Henderson | Kentucky | 21101 | 86 | 3 |
140198 | 140198 | 2020-05-13 | Henderson | Kentucky | 21101 | 87 | 3 |
143194 | 143194 | 2020-05-14 | Henderson | Kentucky | 21101 | 89 | 3 |
146194 | 146194 | 2020-05-15 | Henderson | Kentucky | 21101 | 93 | 3 |
149198 | 149198 | 2020-05-16 | Henderson | Kentucky | 21101 | 95 | 3 |
152209 | 152209 | 2020-05-17 | Henderson | Kentucky | 21101 | 95 | 3 |
155223 | 155223 | 2020-05-18 | Henderson | Kentucky | 21101 | 95 | 3 |
158240 | 158240 | 2020-05-19 | Henderson | Kentucky | 21101 | 97 | 4 |
161266 | 161266 | 2020-05-20 | Henderson | Kentucky | 21101 | 98 | 4 |
164295 | 164295 | 2020-05-21 | Henderson | Kentucky | 21101 | 101 | 4 |
167331 | 167331 | 2020-05-22 | Henderson | Kentucky | 21101 | 103 | 4 |
170369 | 170369 | 2020-05-23 | Henderson | Kentucky | 21101 | 103 | 4 |
173410 | 173410 | 2020-05-24 | Henderson | Kentucky | 21101 | 104 | 4 |
176454 | 176454 | 2020-05-25 | Henderson | Kentucky | 21101 | 104 | 4 |
179498 | 179498 | 2020-05-26 | Henderson | Kentucky | 21101 | 104 | 4 |
182543 | 182543 | 2020-05-27 | Henderson | Kentucky | 21101 | 109 | 4 |
185597 | 185597 | 2020-05-28 | Henderson | Kentucky | 21101 | 112 | 4 |
188655 | 188655 | 2020-05-29 | Henderson | Kentucky | 21101 | 115 | 4 |
191719 | 191719 | 2020-05-30 | Henderson | Kentucky | 21101 | 116 | 4 |
194787 | 194787 | 2020-05-31 | Henderson | Kentucky | 21101 | 116 | 4 |
197858 | 197858 | 2020-06-01 | Henderson | Kentucky | 21101 | 118 | 4 |
200930 | 200930 | 2020-06-02 | Henderson | Kentucky | 21101 | 119 | 4 |
204007 | 204007 | 2020-06-03 | Henderson | Kentucky | 21101 | 120 | 4 |
207088 | 207088 | 2020-06-04 | Henderson | Kentucky | 21101 | 121 | 4 |
210169 | 210169 | 2020-06-05 | Henderson | Kentucky | 21101 | 121 | 4 |
213254 | 213254 | 2020-06-06 | Henderson | Kentucky | 21101 | 121 | 4 |
216341 | 216341 | 2020-06-07 | Henderson | Kentucky | 21101 | 121 | 4 |
219433 | 219433 | 2020-06-08 | Henderson | Kentucky | 21101 | 121 | 4 |
222528 | 222528 | 2020-06-09 | Henderson | Kentucky | 21101 | 121 | 4 |
225624 | 225624 | 2020-06-10 | Henderson | Kentucky | 21101 | 122 | 4 |
228726 | 228726 | 2020-06-11 | Henderson | Kentucky | 21101 | 126 | 4 |
231830 | 231830 | 2020-06-12 | Henderson | Kentucky | 21101 | 131 | 4 |
234935 | 234935 | 2020-06-13 | Henderson | Kentucky | 21101 | 131 | 4 |
238042 | 238042 | 2020-06-14 | Henderson | Kentucky | 21101 | 138 | 4 |
241151 | 241151 | 2020-06-15 | Henderson | Kentucky | 21101 | 138 | 4 |
244262 | 244262 | 2020-06-16 | Henderson | Kentucky | 21101 | 142 | 4 |
247375 | 247375 | 2020-06-17 | Henderson | Kentucky | 21101 | 147 | 4 |
250487 | 250487 | 2020-06-18 | Henderson | Kentucky | 21101 | 150 | 4 |
253602 | 253602 | 2020-06-19 | Henderson | Kentucky | 21101 | 151 | 4 |
256722 | 256722 | 2020-06-20 | Henderson | Kentucky | 21101 | 151 | 4 |
259848 | 259848 | 2020-06-21 | Henderson | Kentucky | 21101 | 152 | 4 |
262977 | 262977 | 2020-06-22 | Henderson | Kentucky | 21101 | 152 | 4 |
266104 | 266104 | 2020-06-23 | Henderson | Kentucky | 21101 | 155 | 4 |
269237 | 269237 | 2020-06-24 | Henderson | Kentucky | 21101 | 155 | 4 |
272373 | 272373 | 2020-06-25 | Henderson | Kentucky | 21101 | 155 | 4 |
275516 | 275516 | 2020-06-26 | Henderson | Kentucky | 21101 | 155 | 4 |
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);