ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
783 rows where county = "Allen" and state = "Kentucky" sorted by county
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date | county ▼ | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
7493 | 7493 | 2020-03-22 | Allen | Kentucky | 21003 | 1 | 0 |
8655 | 8655 | 2020-03-23 | Allen | Kentucky | 21003 | 1 | 0 |
9938 | 9938 | 2020-03-24 | Allen | Kentucky | 21003 | 1 | 0 |
11338 | 11338 | 2020-03-25 | Allen | Kentucky | 21003 | 1 | 0 |
12907 | 12907 | 2020-03-26 | Allen | Kentucky | 21003 | 1 | 0 |
14610 | 14610 | 2020-03-27 | Allen | Kentucky | 21003 | 1 | 0 |
16418 | 16418 | 2020-03-28 | Allen | Kentucky | 21003 | 1 | 0 |
18327 | 18327 | 2020-03-29 | Allen | Kentucky | 21003 | 1 | 0 |
20341 | 20341 | 2020-03-30 | Allen | Kentucky | 21003 | 1 | 0 |
22440 | 22440 | 2020-03-31 | Allen | Kentucky | 21003 | 1 | 0 |
24616 | 24616 | 2020-04-01 | Allen | Kentucky | 21003 | 1 | 0 |
26860 | 26860 | 2020-04-02 | Allen | Kentucky | 21003 | 1 | 0 |
29176 | 29176 | 2020-04-03 | Allen | Kentucky | 21003 | 1 | 0 |
31550 | 31550 | 2020-04-04 | Allen | Kentucky | 21003 | 1 | 0 |
33967 | 33967 | 2020-04-05 | Allen | Kentucky | 21003 | 3 | 0 |
36425 | 36425 | 2020-04-06 | Allen | Kentucky | 21003 | 3 | 0 |
38930 | 38930 | 2020-04-07 | Allen | Kentucky | 21003 | 3 | 0 |
41478 | 41478 | 2020-04-08 | Allen | Kentucky | 21003 | 3 | 0 |
44053 | 44053 | 2020-04-09 | Allen | Kentucky | 21003 | 4 | 0 |
46661 | 46661 | 2020-04-10 | Allen | Kentucky | 21003 | 4 | 0 |
49298 | 49298 | 2020-04-11 | Allen | Kentucky | 21003 | 4 | 0 |
51964 | 51964 | 2020-04-12 | Allen | Kentucky | 21003 | 2 | 0 |
54645 | 54645 | 2020-04-13 | Allen | Kentucky | 21003 | 2 | 0 |
57340 | 57340 | 2020-04-14 | Allen | Kentucky | 21003 | 2 | 0 |
60049 | 60049 | 2020-04-15 | Allen | Kentucky | 21003 | 3 | 0 |
62769 | 62769 | 2020-04-16 | Allen | Kentucky | 21003 | 3 | 0 |
65508 | 65508 | 2020-04-17 | Allen | Kentucky | 21003 | 4 | 0 |
68257 | 68257 | 2020-04-18 | Allen | Kentucky | 21003 | 4 | 0 |
71018 | 71018 | 2020-04-19 | Allen | Kentucky | 21003 | 4 | 0 |
73790 | 73790 | 2020-04-20 | Allen | Kentucky | 21003 | 4 | 0 |
76570 | 76570 | 2020-04-21 | Allen | Kentucky | 21003 | 4 | 0 |
79355 | 79355 | 2020-04-22 | Allen | Kentucky | 21003 | 5 | 0 |
82151 | 82151 | 2020-04-23 | Allen | Kentucky | 21003 | 5 | 0 |
84954 | 84954 | 2020-04-24 | Allen | Kentucky | 21003 | 6 | 0 |
87763 | 87763 | 2020-04-25 | Allen | Kentucky | 21003 | 7 | 0 |
90579 | 90579 | 2020-04-26 | Allen | Kentucky | 21003 | 7 | 0 |
93400 | 93400 | 2020-04-27 | Allen | Kentucky | 21003 | 8 | 0 |
96233 | 96233 | 2020-04-28 | Allen | Kentucky | 21003 | 9 | 0 |
99079 | 99079 | 2020-04-29 | Allen | Kentucky | 21003 | 12 | 0 |
101931 | 101931 | 2020-04-30 | Allen | Kentucky | 21003 | 13 | 0 |
104792 | 104792 | 2020-05-01 | Allen | Kentucky | 21003 | 14 | 0 |
107657 | 107657 | 2020-05-02 | Allen | Kentucky | 21003 | 14 | 0 |
110528 | 110528 | 2020-05-03 | Allen | Kentucky | 21003 | 14 | 0 |
113405 | 113405 | 2020-05-04 | Allen | Kentucky | 21003 | 14 | 0 |
116287 | 116287 | 2020-05-05 | Allen | Kentucky | 21003 | 16 | 0 |
119248 | 119248 | 2020-05-06 | Allen | Kentucky | 21003 | 19 | 0 |
122218 | 122218 | 2020-05-07 | Allen | Kentucky | 21003 | 25 | 0 |
125200 | 125200 | 2020-05-08 | Allen | Kentucky | 21003 | 25 | 0 |
128188 | 128188 | 2020-05-09 | Allen | Kentucky | 21003 | 25 | 0 |
131178 | 131178 | 2020-05-10 | Allen | Kentucky | 21003 | 25 | 0 |
134169 | 134169 | 2020-05-11 | Allen | Kentucky | 21003 | 29 | 1 |
137159 | 137159 | 2020-05-12 | Allen | Kentucky | 21003 | 30 | 1 |
140152 | 140152 | 2020-05-13 | Allen | Kentucky | 21003 | 30 | 1 |
143148 | 143148 | 2020-05-14 | Allen | Kentucky | 21003 | 33 | 1 |
146148 | 146148 | 2020-05-15 | Allen | Kentucky | 21003 | 37 | 1 |
149152 | 149152 | 2020-05-16 | Allen | Kentucky | 21003 | 39 | 2 |
152163 | 152163 | 2020-05-17 | Allen | Kentucky | 21003 | 40 | 2 |
155176 | 155176 | 2020-05-18 | Allen | Kentucky | 21003 | 40 | 2 |
158193 | 158193 | 2020-05-19 | Allen | Kentucky | 21003 | 41 | 2 |
161218 | 161218 | 2020-05-20 | Allen | Kentucky | 21003 | 43 | 2 |
164247 | 164247 | 2020-05-21 | Allen | Kentucky | 21003 | 44 | 2 |
167283 | 167283 | 2020-05-22 | Allen | Kentucky | 21003 | 44 | 2 |
170321 | 170321 | 2020-05-23 | Allen | Kentucky | 21003 | 47 | 2 |
173362 | 173362 | 2020-05-24 | Allen | Kentucky | 21003 | 52 | 2 |
176406 | 176406 | 2020-05-25 | Allen | Kentucky | 21003 | 52 | 2 |
179450 | 179450 | 2020-05-26 | Allen | Kentucky | 21003 | 56 | 3 |
182495 | 182495 | 2020-05-27 | Allen | Kentucky | 21003 | 56 | 3 |
185549 | 185549 | 2020-05-28 | Allen | Kentucky | 21003 | 63 | 3 |
188607 | 188607 | 2020-05-29 | Allen | Kentucky | 21003 | 70 | 3 |
191671 | 191671 | 2020-05-30 | Allen | Kentucky | 21003 | 70 | 3 |
194739 | 194739 | 2020-05-31 | Allen | Kentucky | 21003 | 88 | 3 |
197810 | 197810 | 2020-06-01 | Allen | Kentucky | 21003 | 93 | 3 |
200881 | 200881 | 2020-06-02 | Allen | Kentucky | 21003 | 92 | 3 |
203958 | 203958 | 2020-06-03 | Allen | Kentucky | 21003 | 96 | 3 |
207039 | 207039 | 2020-06-04 | Allen | Kentucky | 21003 | 100 | 3 |
210120 | 210120 | 2020-06-05 | Allen | Kentucky | 21003 | 102 | 3 |
213205 | 213205 | 2020-06-06 | Allen | Kentucky | 21003 | 102 | 3 |
216292 | 216292 | 2020-06-07 | Allen | Kentucky | 21003 | 111 | 4 |
219384 | 219384 | 2020-06-08 | Allen | Kentucky | 21003 | 116 | 4 |
222479 | 222479 | 2020-06-09 | Allen | Kentucky | 21003 | 118 | 4 |
225575 | 225575 | 2020-06-10 | Allen | Kentucky | 21003 | 120 | 4 |
228677 | 228677 | 2020-06-11 | Allen | Kentucky | 21003 | 123 | 4 |
231781 | 231781 | 2020-06-12 | Allen | Kentucky | 21003 | 130 | 4 |
234886 | 234886 | 2020-06-13 | Allen | Kentucky | 21003 | 133 | 4 |
237993 | 237993 | 2020-06-14 | Allen | Kentucky | 21003 | 133 | 4 |
241102 | 241102 | 2020-06-15 | Allen | Kentucky | 21003 | 136 | 4 |
244213 | 244213 | 2020-06-16 | Allen | Kentucky | 21003 | 138 | 4 |
247326 | 247326 | 2020-06-17 | Allen | Kentucky | 21003 | 138 | 4 |
250438 | 250438 | 2020-06-18 | Allen | Kentucky | 21003 | 145 | 4 |
253553 | 253553 | 2020-06-19 | Allen | Kentucky | 21003 | 145 | 4 |
256673 | 256673 | 2020-06-20 | Allen | Kentucky | 21003 | 152 | 4 |
259799 | 259799 | 2020-06-21 | Allen | Kentucky | 21003 | 152 | 5 |
262928 | 262928 | 2020-06-22 | Allen | Kentucky | 21003 | 154 | 5 |
266055 | 266055 | 2020-06-23 | Allen | Kentucky | 21003 | 156 | 5 |
269188 | 269188 | 2020-06-24 | Allen | Kentucky | 21003 | 158 | 5 |
272324 | 272324 | 2020-06-25 | Allen | Kentucky | 21003 | 162 | 5 |
275467 | 275467 | 2020-06-26 | Allen | Kentucky | 21003 | 164 | 6 |
278615 | 278615 | 2020-06-27 | Allen | Kentucky | 21003 | 165 | 6 |
281763 | 281763 | 2020-06-28 | Allen | Kentucky | 21003 | 165 | 6 |
284909 | 284909 | 2020-06-29 | Allen | Kentucky | 21003 | 165 | 7 |
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);