ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
775 rows where county = "Marshall" and state = "Kentucky" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
387008 | 387008 | 2020-07-31 | Marshall | Kentucky | 21157 | 120 | 2 |
383790 | 383790 | 2020-07-30 | Marshall | Kentucky | 21157 | 115 | 2 |
380573 | 380573 | 2020-07-29 | Marshall | Kentucky | 21157 | 113 | 2 |
377356 | 377356 | 2020-07-28 | Marshall | Kentucky | 21157 | 112 | 2 |
374141 | 374141 | 2020-07-27 | Marshall | Kentucky | 21157 | 112 | 2 |
370929 | 370929 | 2020-07-26 | Marshall | Kentucky | 21157 | 112 | 2 |
367719 | 367719 | 2020-07-25 | Marshall | Kentucky | 21157 | 110 | 2 |
364512 | 364512 | 2020-07-24 | Marshall | Kentucky | 21157 | 103 | 2 |
361305 | 361305 | 2020-07-23 | Marshall | Kentucky | 21157 | 100 | 2 |
358100 | 358100 | 2020-07-22 | Marshall | Kentucky | 21157 | 98 | 2 |
354897 | 354897 | 2020-07-21 | Marshall | Kentucky | 21157 | 94 | 2 |
351695 | 351695 | 2020-07-20 | Marshall | Kentucky | 21157 | 92 | 2 |
348495 | 348495 | 2020-07-19 | Marshall | Kentucky | 21157 | 92 | 2 |
345294 | 345294 | 2020-07-18 | Marshall | Kentucky | 21157 | 88 | 2 |
342094 | 342094 | 2020-07-17 | Marshall | Kentucky | 21157 | 87 | 2 |
338898 | 338898 | 2020-07-16 | Marshall | Kentucky | 21157 | 82 | 2 |
335702 | 335702 | 2020-07-15 | Marshall | Kentucky | 21157 | 81 | 2 |
332509 | 332509 | 2020-07-14 | Marshall | Kentucky | 21157 | 74 | 2 |
329322 | 329322 | 2020-07-13 | Marshall | Kentucky | 21157 | 72 | 2 |
326136 | 326136 | 2020-07-12 | Marshall | Kentucky | 21157 | 70 | 2 |
322953 | 322953 | 2020-07-11 | Marshall | Kentucky | 21157 | 69 | 2 |
319774 | 319774 | 2020-07-10 | Marshall | Kentucky | 21157 | 68 | 2 |
316599 | 316599 | 2020-07-09 | Marshall | Kentucky | 21157 | 66 | 2 |
313425 | 313425 | 2020-07-08 | Marshall | Kentucky | 21157 | 66 | 2 |
310255 | 310255 | 2020-07-07 | Marshall | Kentucky | 21157 | 65 | 2 |
307087 | 307087 | 2020-07-06 | Marshall | Kentucky | 21157 | 65 | 2 |
303920 | 303920 | 2020-07-05 | Marshall | Kentucky | 21157 | 60 | 2 |
300756 | 300756 | 2020-07-04 | Marshall | Kentucky | 21157 | 60 | 2 |
297594 | 297594 | 2020-07-03 | Marshall | Kentucky | 21157 | 60 | 2 |
294436 | 294436 | 2020-07-02 | Marshall | Kentucky | 21157 | 60 | 2 |
291282 | 291282 | 2020-07-01 | Marshall | Kentucky | 21157 | 59 | 2 |
288132 | 288132 | 2020-06-30 | Marshall | Kentucky | 21157 | 58 | 2 |
284983 | 284983 | 2020-06-29 | Marshall | Kentucky | 21157 | 56 | 2 |
281837 | 281837 | 2020-06-28 | Marshall | Kentucky | 21157 | 55 | 2 |
278689 | 278689 | 2020-06-27 | Marshall | Kentucky | 21157 | 54 | 2 |
275541 | 275541 | 2020-06-26 | Marshall | Kentucky | 21157 | 53 | 2 |
272398 | 272398 | 2020-06-25 | Marshall | Kentucky | 21157 | 53 | 2 |
269262 | 269262 | 2020-06-24 | Marshall | Kentucky | 21157 | 53 | 2 |
266129 | 266129 | 2020-06-23 | Marshall | Kentucky | 21157 | 53 | 2 |
263002 | 263002 | 2020-06-22 | Marshall | Kentucky | 21157 | 52 | 2 |
259873 | 259873 | 2020-06-21 | Marshall | Kentucky | 21157 | 50 | 2 |
256747 | 256747 | 2020-06-20 | Marshall | Kentucky | 21157 | 50 | 2 |
253627 | 253627 | 2020-06-19 | Marshall | Kentucky | 21157 | 50 | 2 |
250512 | 250512 | 2020-06-18 | Marshall | Kentucky | 21157 | 48 | 2 |
247400 | 247400 | 2020-06-17 | Marshall | Kentucky | 21157 | 47 | 2 |
244287 | 244287 | 2020-06-16 | Marshall | Kentucky | 21157 | 44 | 2 |
241176 | 241176 | 2020-06-15 | Marshall | Kentucky | 21157 | 44 | 2 |
238067 | 238067 | 2020-06-14 | Marshall | Kentucky | 21157 | 41 | 2 |
234960 | 234960 | 2020-06-13 | Marshall | Kentucky | 21157 | 41 | 2 |
231855 | 231855 | 2020-06-12 | Marshall | Kentucky | 21157 | 41 | 2 |
228751 | 228751 | 2020-06-11 | Marshall | Kentucky | 21157 | 40 | 2 |
225649 | 225649 | 2020-06-10 | Marshall | Kentucky | 21157 | 37 | 2 |
222553 | 222553 | 2020-06-09 | Marshall | Kentucky | 21157 | 37 | 2 |
219458 | 219458 | 2020-06-08 | Marshall | Kentucky | 21157 | 37 | 2 |
216366 | 216366 | 2020-06-07 | Marshall | Kentucky | 21157 | 37 | 2 |
213279 | 213279 | 2020-06-06 | Marshall | Kentucky | 21157 | 37 | 2 |
210194 | 210194 | 2020-06-05 | Marshall | Kentucky | 21157 | 37 | 2 |
207113 | 207113 | 2020-06-04 | Marshall | Kentucky | 21157 | 37 | 2 |
204032 | 204032 | 2020-06-03 | Marshall | Kentucky | 21157 | 37 | 2 |
200955 | 200955 | 2020-06-02 | Marshall | Kentucky | 21157 | 38 | 2 |
197883 | 197883 | 2020-06-01 | Marshall | Kentucky | 21157 | 38 | 2 |
194812 | 194812 | 2020-05-31 | Marshall | Kentucky | 21157 | 38 | 2 |
191744 | 191744 | 2020-05-30 | Marshall | Kentucky | 21157 | 38 | 2 |
188680 | 188680 | 2020-05-29 | Marshall | Kentucky | 21157 | 38 | 2 |
185622 | 185622 | 2020-05-28 | Marshall | Kentucky | 21157 | 37 | 2 |
182567 | 182567 | 2020-05-27 | Marshall | Kentucky | 21157 | 37 | 2 |
179522 | 179522 | 2020-05-26 | Marshall | Kentucky | 21157 | 37 | 2 |
176478 | 176478 | 2020-05-25 | Marshall | Kentucky | 21157 | 37 | 2 |
173434 | 173434 | 2020-05-24 | Marshall | Kentucky | 21157 | 37 | 2 |
170393 | 170393 | 2020-05-23 | Marshall | Kentucky | 21157 | 37 | 2 |
167355 | 167355 | 2020-05-22 | Marshall | Kentucky | 21157 | 37 | 2 |
164319 | 164319 | 2020-05-21 | Marshall | Kentucky | 21157 | 36 | 2 |
161290 | 161290 | 2020-05-20 | Marshall | Kentucky | 21157 | 36 | 2 |
158264 | 158264 | 2020-05-19 | Marshall | Kentucky | 21157 | 36 | 2 |
155247 | 155247 | 2020-05-18 | Marshall | Kentucky | 21157 | 36 | 2 |
152233 | 152233 | 2020-05-17 | Marshall | Kentucky | 21157 | 35 | 2 |
149222 | 149222 | 2020-05-16 | Marshall | Kentucky | 21157 | 35 | 2 |
146217 | 146217 | 2020-05-15 | Marshall | Kentucky | 21157 | 35 | 2 |
143217 | 143217 | 2020-05-14 | Marshall | Kentucky | 21157 | 34 | 2 |
140221 | 140221 | 2020-05-13 | Marshall | Kentucky | 21157 | 34 | 1 |
137228 | 137228 | 2020-05-12 | Marshall | Kentucky | 21157 | 34 | 1 |
134238 | 134238 | 2020-05-11 | Marshall | Kentucky | 21157 | 34 | 1 |
131247 | 131247 | 2020-05-10 | Marshall | Kentucky | 21157 | 34 | 1 |
128257 | 128257 | 2020-05-09 | Marshall | Kentucky | 21157 | 34 | 1 |
125269 | 125269 | 2020-05-08 | Marshall | Kentucky | 21157 | 33 | 1 |
122287 | 122287 | 2020-05-07 | Marshall | Kentucky | 21157 | 34 | 1 |
119316 | 119316 | 2020-05-06 | Marshall | Kentucky | 21157 | 34 | 1 |
116355 | 116355 | 2020-05-05 | Marshall | Kentucky | 21157 | 34 | 1 |
113473 | 113473 | 2020-05-04 | Marshall | Kentucky | 21157 | 34 | 1 |
110596 | 110596 | 2020-05-03 | Marshall | Kentucky | 21157 | 34 | 1 |
107725 | 107725 | 2020-05-02 | Marshall | Kentucky | 21157 | 34 | 1 |
104860 | 104860 | 2020-05-01 | Marshall | Kentucky | 21157 | 34 | 1 |
101999 | 101999 | 2020-04-30 | Marshall | Kentucky | 21157 | 34 | 0 |
99147 | 99147 | 2020-04-29 | Marshall | Kentucky | 21157 | 34 | 0 |
96301 | 96301 | 2020-04-28 | Marshall | Kentucky | 21157 | 34 | 0 |
93468 | 93468 | 2020-04-27 | Marshall | Kentucky | 21157 | 33 | 0 |
90647 | 90647 | 2020-04-26 | Marshall | Kentucky | 21157 | 31 | 0 |
87831 | 87831 | 2020-04-25 | Marshall | Kentucky | 21157 | 27 | 0 |
85022 | 85022 | 2020-04-24 | Marshall | Kentucky | 21157 | 23 | 0 |
82219 | 82219 | 2020-04-23 | Marshall | Kentucky | 21157 | 23 | 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);