ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
763 rows where fips = 21077 and state = "Kentucky" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
386971 | 386971 | 2020-07-31 | Gallatin | Kentucky | 21077 | 77 | 8 |
383753 | 383753 | 2020-07-30 | Gallatin | Kentucky | 21077 | 77 | 8 |
380536 | 380536 | 2020-07-29 | Gallatin | Kentucky | 21077 | 77 | 8 |
377319 | 377319 | 2020-07-28 | Gallatin | Kentucky | 21077 | 77 | 8 |
374104 | 374104 | 2020-07-27 | Gallatin | Kentucky | 21077 | 77 | 8 |
370892 | 370892 | 2020-07-26 | Gallatin | Kentucky | 21077 | 77 | 8 |
367682 | 367682 | 2020-07-25 | Gallatin | Kentucky | 21077 | 77 | 8 |
364475 | 364475 | 2020-07-24 | Gallatin | Kentucky | 21077 | 77 | 8 |
361268 | 361268 | 2020-07-23 | Gallatin | Kentucky | 21077 | 77 | 8 |
358063 | 358063 | 2020-07-22 | Gallatin | Kentucky | 21077 | 74 | 8 |
354860 | 354860 | 2020-07-21 | Gallatin | Kentucky | 21077 | 73 | 8 |
351658 | 351658 | 2020-07-20 | Gallatin | Kentucky | 21077 | 72 | 8 |
348458 | 348458 | 2020-07-19 | Gallatin | Kentucky | 21077 | 72 | 8 |
345257 | 345257 | 2020-07-18 | Gallatin | Kentucky | 21077 | 72 | 8 |
342057 | 342057 | 2020-07-17 | Gallatin | Kentucky | 21077 | 71 | 8 |
338861 | 338861 | 2020-07-16 | Gallatin | Kentucky | 21077 | 71 | 8 |
335665 | 335665 | 2020-07-15 | Gallatin | Kentucky | 21077 | 69 | 8 |
332472 | 332472 | 2020-07-14 | Gallatin | Kentucky | 21077 | 68 | 8 |
329285 | 329285 | 2020-07-13 | Gallatin | Kentucky | 21077 | 68 | 8 |
326099 | 326099 | 2020-07-12 | Gallatin | Kentucky | 21077 | 68 | 8 |
322916 | 322916 | 2020-07-11 | Gallatin | Kentucky | 21077 | 68 | 8 |
319737 | 319737 | 2020-07-10 | Gallatin | Kentucky | 21077 | 67 | 8 |
316562 | 316562 | 2020-07-09 | Gallatin | Kentucky | 21077 | 67 | 8 |
313388 | 313388 | 2020-07-08 | Gallatin | Kentucky | 21077 | 66 | 8 |
310218 | 310218 | 2020-07-07 | Gallatin | Kentucky | 21077 | 65 | 8 |
307050 | 307050 | 2020-07-06 | Gallatin | Kentucky | 21077 | 65 | 8 |
303883 | 303883 | 2020-07-05 | Gallatin | Kentucky | 21077 | 65 | 8 |
300719 | 300719 | 2020-07-04 | Gallatin | Kentucky | 21077 | 65 | 8 |
297557 | 297557 | 2020-07-03 | Gallatin | Kentucky | 21077 | 65 | 8 |
294399 | 294399 | 2020-07-02 | Gallatin | Kentucky | 21077 | 65 | 8 |
291245 | 291245 | 2020-07-01 | Gallatin | Kentucky | 21077 | 65 | 7 |
288095 | 288095 | 2020-06-30 | Gallatin | Kentucky | 21077 | 61 | 7 |
284946 | 284946 | 2020-06-29 | Gallatin | Kentucky | 21077 | 61 | 7 |
281800 | 281800 | 2020-06-28 | Gallatin | Kentucky | 21077 | 61 | 7 |
278652 | 278652 | 2020-06-27 | Gallatin | Kentucky | 21077 | 61 | 7 |
275504 | 275504 | 2020-06-26 | Gallatin | Kentucky | 21077 | 59 | 7 |
272361 | 272361 | 2020-06-25 | Gallatin | Kentucky | 21077 | 58 | 7 |
269225 | 269225 | 2020-06-24 | Gallatin | Kentucky | 21077 | 58 | 7 |
266092 | 266092 | 2020-06-23 | Gallatin | Kentucky | 21077 | 58 | 7 |
262965 | 262965 | 2020-06-22 | Gallatin | Kentucky | 21077 | 57 | 7 |
259836 | 259836 | 2020-06-21 | Gallatin | Kentucky | 21077 | 57 | 7 |
256710 | 256710 | 2020-06-20 | Gallatin | Kentucky | 21077 | 57 | 7 |
253590 | 253590 | 2020-06-19 | Gallatin | Kentucky | 21077 | 57 | 7 |
250475 | 250475 | 2020-06-18 | Gallatin | Kentucky | 21077 | 57 | 7 |
247363 | 247363 | 2020-06-17 | Gallatin | Kentucky | 21077 | 57 | 7 |
244250 | 244250 | 2020-06-16 | Gallatin | Kentucky | 21077 | 57 | 7 |
241139 | 241139 | 2020-06-15 | Gallatin | Kentucky | 21077 | 57 | 7 |
238030 | 238030 | 2020-06-14 | Gallatin | Kentucky | 21077 | 57 | 7 |
234923 | 234923 | 2020-06-13 | Gallatin | Kentucky | 21077 | 57 | 7 |
231818 | 231818 | 2020-06-12 | Gallatin | Kentucky | 21077 | 51 | 7 |
228714 | 228714 | 2020-06-11 | Gallatin | Kentucky | 21077 | 51 | 7 |
225612 | 225612 | 2020-06-10 | Gallatin | Kentucky | 21077 | 51 | 6 |
222516 | 222516 | 2020-06-09 | Gallatin | Kentucky | 21077 | 49 | 6 |
219421 | 219421 | 2020-06-08 | Gallatin | Kentucky | 21077 | 46 | 5 |
216329 | 216329 | 2020-06-07 | Gallatin | Kentucky | 21077 | 46 | 5 |
213242 | 213242 | 2020-06-06 | Gallatin | Kentucky | 21077 | 46 | 5 |
210157 | 210157 | 2020-06-05 | Gallatin | Kentucky | 21077 | 46 | 5 |
207076 | 207076 | 2020-06-04 | Gallatin | Kentucky | 21077 | 46 | 5 |
203995 | 203995 | 2020-06-03 | Gallatin | Kentucky | 21077 | 46 | 5 |
200918 | 200918 | 2020-06-02 | Gallatin | Kentucky | 21077 | 43 | 4 |
197846 | 197846 | 2020-06-01 | Gallatin | Kentucky | 21077 | 37 | 4 |
194775 | 194775 | 2020-05-31 | Gallatin | Kentucky | 21077 | 36 | 3 |
191707 | 191707 | 2020-05-30 | Gallatin | Kentucky | 21077 | 36 | 3 |
188643 | 188643 | 2020-05-29 | Gallatin | Kentucky | 21077 | 33 | 2 |
185585 | 185585 | 2020-05-28 | Gallatin | Kentucky | 21077 | 15 | 0 |
182531 | 182531 | 2020-05-27 | Gallatin | Kentucky | 21077 | 12 | 0 |
179486 | 179486 | 2020-05-26 | Gallatin | Kentucky | 21077 | 8 | 0 |
176442 | 176442 | 2020-05-25 | Gallatin | Kentucky | 21077 | 8 | 0 |
173398 | 173398 | 2020-05-24 | Gallatin | Kentucky | 21077 | 8 | 0 |
170357 | 170357 | 2020-05-23 | Gallatin | Kentucky | 21077 | 8 | 0 |
167319 | 167319 | 2020-05-22 | Gallatin | Kentucky | 21077 | 5 | 0 |
164283 | 164283 | 2020-05-21 | Gallatin | Kentucky | 21077 | 3 | 0 |
161254 | 161254 | 2020-05-20 | Gallatin | Kentucky | 21077 | 3 | 0 |
158228 | 158228 | 2020-05-19 | Gallatin | Kentucky | 21077 | 3 | 0 |
155211 | 155211 | 2020-05-18 | Gallatin | Kentucky | 21077 | 3 | 0 |
152197 | 152197 | 2020-05-17 | Gallatin | Kentucky | 21077 | 2 | 0 |
149186 | 149186 | 2020-05-16 | Gallatin | Kentucky | 21077 | 2 | 0 |
146182 | 146182 | 2020-05-15 | Gallatin | Kentucky | 21077 | 2 | 0 |
143182 | 143182 | 2020-05-14 | Gallatin | Kentucky | 21077 | 2 | 0 |
140186 | 140186 | 2020-05-13 | Gallatin | Kentucky | 21077 | 1 | 0 |
137193 | 137193 | 2020-05-12 | Gallatin | Kentucky | 21077 | 1 | 0 |
134203 | 134203 | 2020-05-11 | Gallatin | Kentucky | 21077 | 1 | 0 |
131212 | 131212 | 2020-05-10 | Gallatin | Kentucky | 21077 | 1 | 0 |
128222 | 128222 | 2020-05-09 | Gallatin | Kentucky | 21077 | 1 | 0 |
125234 | 125234 | 2020-05-08 | Gallatin | Kentucky | 21077 | 1 | 0 |
122252 | 122252 | 2020-05-07 | Gallatin | Kentucky | 21077 | 1 | 0 |
119282 | 119282 | 2020-05-06 | Gallatin | Kentucky | 21077 | 1 | 0 |
116321 | 116321 | 2020-05-05 | Gallatin | Kentucky | 21077 | 1 | 0 |
113439 | 113439 | 2020-05-04 | Gallatin | Kentucky | 21077 | 1 | 0 |
110562 | 110562 | 2020-05-03 | Gallatin | Kentucky | 21077 | 1 | 0 |
107691 | 107691 | 2020-05-02 | Gallatin | Kentucky | 21077 | 1 | 0 |
104826 | 104826 | 2020-05-01 | Gallatin | Kentucky | 21077 | 1 | 0 |
101965 | 101965 | 2020-04-30 | Gallatin | Kentucky | 21077 | 1 | 0 |
99113 | 99113 | 2020-04-29 | Gallatin | Kentucky | 21077 | 1 | 0 |
96267 | 96267 | 2020-04-28 | Gallatin | Kentucky | 21077 | 1 | 0 |
93434 | 93434 | 2020-04-27 | Gallatin | Kentucky | 21077 | 1 | 0 |
90613 | 90613 | 2020-04-26 | Gallatin | Kentucky | 21077 | 1 | 0 |
87797 | 87797 | 2020-04-25 | Gallatin | Kentucky | 21077 | 1 | 0 |
84988 | 84988 | 2020-04-24 | Gallatin | Kentucky | 21077 | 1 | 0 |
82185 | 82185 | 2020-04-23 | Gallatin | Kentucky | 21077 | 1 | 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);