ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
781 rows where county = "Martin" and state = "Kentucky" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
387009 | 387009 | 2020-07-31 | Martin | Kentucky | 21159 | 29 | 0 |
383791 | 383791 | 2020-07-30 | Martin | Kentucky | 21159 | 29 | 0 |
380574 | 380574 | 2020-07-29 | Martin | Kentucky | 21159 | 29 | 0 |
377357 | 377357 | 2020-07-28 | Martin | Kentucky | 21159 | 28 | 0 |
374142 | 374142 | 2020-07-27 | Martin | Kentucky | 21159 | 26 | 0 |
370930 | 370930 | 2020-07-26 | Martin | Kentucky | 21159 | 25 | 0 |
367720 | 367720 | 2020-07-25 | Martin | Kentucky | 21159 | 24 | 0 |
364513 | 364513 | 2020-07-24 | Martin | Kentucky | 21159 | 23 | 0 |
361306 | 361306 | 2020-07-23 | Martin | Kentucky | 21159 | 20 | 0 |
358101 | 358101 | 2020-07-22 | Martin | Kentucky | 21159 | 20 | 0 |
354898 | 354898 | 2020-07-21 | Martin | Kentucky | 21159 | 18 | 0 |
351696 | 351696 | 2020-07-20 | Martin | Kentucky | 21159 | 15 | 0 |
348496 | 348496 | 2020-07-19 | Martin | Kentucky | 21159 | 15 | 0 |
345295 | 345295 | 2020-07-18 | Martin | Kentucky | 21159 | 13 | 0 |
342095 | 342095 | 2020-07-17 | Martin | Kentucky | 21159 | 13 | 0 |
338899 | 338899 | 2020-07-16 | Martin | Kentucky | 21159 | 12 | 0 |
335703 | 335703 | 2020-07-15 | Martin | Kentucky | 21159 | 12 | 0 |
332510 | 332510 | 2020-07-14 | Martin | Kentucky | 21159 | 12 | 0 |
329323 | 329323 | 2020-07-13 | Martin | Kentucky | 21159 | 12 | 0 |
326137 | 326137 | 2020-07-12 | Martin | Kentucky | 21159 | 12 | 0 |
322954 | 322954 | 2020-07-11 | Martin | Kentucky | 21159 | 12 | 0 |
319775 | 319775 | 2020-07-10 | Martin | Kentucky | 21159 | 12 | 0 |
316600 | 316600 | 2020-07-09 | Martin | Kentucky | 21159 | 10 | 0 |
313426 | 313426 | 2020-07-08 | Martin | Kentucky | 21159 | 10 | 0 |
310256 | 310256 | 2020-07-07 | Martin | Kentucky | 21159 | 9 | 0 |
307088 | 307088 | 2020-07-06 | Martin | Kentucky | 21159 | 9 | 0 |
303921 | 303921 | 2020-07-05 | Martin | Kentucky | 21159 | 8 | 0 |
300757 | 300757 | 2020-07-04 | Martin | Kentucky | 21159 | 8 | 0 |
297595 | 297595 | 2020-07-03 | Martin | Kentucky | 21159 | 8 | 0 |
294437 | 294437 | 2020-07-02 | Martin | Kentucky | 21159 | 8 | 0 |
291283 | 291283 | 2020-07-01 | Martin | Kentucky | 21159 | 7 | 0 |
288133 | 288133 | 2020-06-30 | Martin | Kentucky | 21159 | 5 | 0 |
284984 | 284984 | 2020-06-29 | Martin | Kentucky | 21159 | 5 | 0 |
281838 | 281838 | 2020-06-28 | Martin | Kentucky | 21159 | 5 | 0 |
278690 | 278690 | 2020-06-27 | Martin | Kentucky | 21159 | 5 | 0 |
275542 | 275542 | 2020-06-26 | Martin | Kentucky | 21159 | 5 | 0 |
272399 | 272399 | 2020-06-25 | Martin | Kentucky | 21159 | 5 | 0 |
269263 | 269263 | 2020-06-24 | Martin | Kentucky | 21159 | 5 | 0 |
266130 | 266130 | 2020-06-23 | Martin | Kentucky | 21159 | 5 | 0 |
263003 | 263003 | 2020-06-22 | Martin | Kentucky | 21159 | 4 | 0 |
259874 | 259874 | 2020-06-21 | Martin | Kentucky | 21159 | 4 | 0 |
256748 | 256748 | 2020-06-20 | Martin | Kentucky | 21159 | 3 | 0 |
253628 | 253628 | 2020-06-19 | Martin | Kentucky | 21159 | 3 | 0 |
250513 | 250513 | 2020-06-18 | Martin | Kentucky | 21159 | 3 | 0 |
247401 | 247401 | 2020-06-17 | Martin | Kentucky | 21159 | 3 | 0 |
244288 | 244288 | 2020-06-16 | Martin | Kentucky | 21159 | 3 | 0 |
241177 | 241177 | 2020-06-15 | Martin | Kentucky | 21159 | 3 | 0 |
238068 | 238068 | 2020-06-14 | Martin | Kentucky | 21159 | 3 | 0 |
234961 | 234961 | 2020-06-13 | Martin | Kentucky | 21159 | 3 | 0 |
231856 | 231856 | 2020-06-12 | Martin | Kentucky | 21159 | 3 | 0 |
228752 | 228752 | 2020-06-11 | Martin | Kentucky | 21159 | 3 | 0 |
225650 | 225650 | 2020-06-10 | Martin | Kentucky | 21159 | 3 | 0 |
222554 | 222554 | 2020-06-09 | Martin | Kentucky | 21159 | 3 | 0 |
219459 | 219459 | 2020-06-08 | Martin | Kentucky | 21159 | 3 | 0 |
216367 | 216367 | 2020-06-07 | Martin | Kentucky | 21159 | 3 | 0 |
213280 | 213280 | 2020-06-06 | Martin | Kentucky | 21159 | 3 | 0 |
210195 | 210195 | 2020-06-05 | Martin | Kentucky | 21159 | 3 | 0 |
207114 | 207114 | 2020-06-04 | Martin | Kentucky | 21159 | 3 | 0 |
204033 | 204033 | 2020-06-03 | Martin | Kentucky | 21159 | 3 | 0 |
200956 | 200956 | 2020-06-02 | Martin | Kentucky | 21159 | 3 | 0 |
197884 | 197884 | 2020-06-01 | Martin | Kentucky | 21159 | 3 | 0 |
194813 | 194813 | 2020-05-31 | Martin | Kentucky | 21159 | 3 | 0 |
191745 | 191745 | 2020-05-30 | Martin | Kentucky | 21159 | 3 | 0 |
188681 | 188681 | 2020-05-29 | Martin | Kentucky | 21159 | 3 | 0 |
185623 | 185623 | 2020-05-28 | Martin | Kentucky | 21159 | 3 | 0 |
182568 | 182568 | 2020-05-27 | Martin | Kentucky | 21159 | 3 | 0 |
179523 | 179523 | 2020-05-26 | Martin | Kentucky | 21159 | 3 | 0 |
176479 | 176479 | 2020-05-25 | Martin | Kentucky | 21159 | 3 | 0 |
173435 | 173435 | 2020-05-24 | Martin | Kentucky | 21159 | 3 | 0 |
170394 | 170394 | 2020-05-23 | Martin | Kentucky | 21159 | 3 | 0 |
167356 | 167356 | 2020-05-22 | Martin | Kentucky | 21159 | 3 | 0 |
164320 | 164320 | 2020-05-21 | Martin | Kentucky | 21159 | 3 | 0 |
161291 | 161291 | 2020-05-20 | Martin | Kentucky | 21159 | 3 | 0 |
158265 | 158265 | 2020-05-19 | Martin | Kentucky | 21159 | 3 | 0 |
155248 | 155248 | 2020-05-18 | Martin | Kentucky | 21159 | 3 | 0 |
152234 | 152234 | 2020-05-17 | Martin | Kentucky | 21159 | 3 | 0 |
149223 | 149223 | 2020-05-16 | Martin | Kentucky | 21159 | 3 | 0 |
146218 | 146218 | 2020-05-15 | Martin | Kentucky | 21159 | 3 | 0 |
143218 | 143218 | 2020-05-14 | Martin | Kentucky | 21159 | 3 | 0 |
140222 | 140222 | 2020-05-13 | Martin | Kentucky | 21159 | 3 | 0 |
137229 | 137229 | 2020-05-12 | Martin | Kentucky | 21159 | 3 | 0 |
134239 | 134239 | 2020-05-11 | Martin | Kentucky | 21159 | 3 | 0 |
131248 | 131248 | 2020-05-10 | Martin | Kentucky | 21159 | 3 | 0 |
128258 | 128258 | 2020-05-09 | Martin | Kentucky | 21159 | 3 | 0 |
125270 | 125270 | 2020-05-08 | Martin | Kentucky | 21159 | 3 | 0 |
122288 | 122288 | 2020-05-07 | Martin | Kentucky | 21159 | 3 | 0 |
119317 | 119317 | 2020-05-06 | Martin | Kentucky | 21159 | 3 | 0 |
116356 | 116356 | 2020-05-05 | Martin | Kentucky | 21159 | 3 | 0 |
113474 | 113474 | 2020-05-04 | Martin | Kentucky | 21159 | 3 | 0 |
110597 | 110597 | 2020-05-03 | Martin | Kentucky | 21159 | 3 | 0 |
107726 | 107726 | 2020-05-02 | Martin | Kentucky | 21159 | 3 | 0 |
104861 | 104861 | 2020-05-01 | Martin | Kentucky | 21159 | 3 | 0 |
102000 | 102000 | 2020-04-30 | Martin | Kentucky | 21159 | 3 | 0 |
99148 | 99148 | 2020-04-29 | Martin | Kentucky | 21159 | 3 | 0 |
96302 | 96302 | 2020-04-28 | Martin | Kentucky | 21159 | 3 | 0 |
93469 | 93469 | 2020-04-27 | Martin | Kentucky | 21159 | 3 | 0 |
90648 | 90648 | 2020-04-26 | Martin | Kentucky | 21159 | 3 | 0 |
87832 | 87832 | 2020-04-25 | Martin | Kentucky | 21159 | 3 | 0 |
85023 | 85023 | 2020-04-24 | Martin | Kentucky | 21159 | 3 | 0 |
82220 | 82220 | 2020-04-23 | Martin | Kentucky | 21159 | 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);