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 rowid
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid ▼ | date | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
9957 | 9957 | 2020-03-24 | Martin | Kentucky | 21159 | 1 | 0 |
11359 | 11359 | 2020-03-25 | Martin | Kentucky | 21159 | 1 | 0 |
12930 | 12930 | 2020-03-26 | Martin | Kentucky | 21159 | 1 | 0 |
14636 | 14636 | 2020-03-27 | Martin | Kentucky | 21159 | 1 | 0 |
16451 | 16451 | 2020-03-28 | Martin | Kentucky | 21159 | 1 | 0 |
18362 | 18362 | 2020-03-29 | Martin | Kentucky | 21159 | 1 | 0 |
20378 | 20378 | 2020-03-30 | Martin | Kentucky | 21159 | 1 | 0 |
22483 | 22483 | 2020-03-31 | Martin | Kentucky | 21159 | 1 | 0 |
24659 | 24659 | 2020-04-01 | Martin | Kentucky | 21159 | 1 | 0 |
26907 | 26907 | 2020-04-02 | Martin | Kentucky | 21159 | 1 | 0 |
29223 | 29223 | 2020-04-03 | Martin | Kentucky | 21159 | 1 | 0 |
31599 | 31599 | 2020-04-04 | Martin | Kentucky | 21159 | 1 | 0 |
34021 | 34021 | 2020-04-05 | Martin | Kentucky | 21159 | 1 | 0 |
36479 | 36479 | 2020-04-06 | Martin | Kentucky | 21159 | 1 | 0 |
38986 | 38986 | 2020-04-07 | Martin | Kentucky | 21159 | 1 | 0 |
41536 | 41536 | 2020-04-08 | Martin | Kentucky | 21159 | 4 | 0 |
44112 | 44112 | 2020-04-09 | Martin | Kentucky | 21159 | 4 | 0 |
46720 | 46720 | 2020-04-10 | Martin | Kentucky | 21159 | 4 | 0 |
49360 | 49360 | 2020-04-11 | Martin | Kentucky | 21159 | 4 | 0 |
52026 | 52026 | 2020-04-12 | Martin | Kentucky | 21159 | 1 | 0 |
54707 | 54707 | 2020-04-13 | Martin | Kentucky | 21159 | 1 | 0 |
57405 | 57405 | 2020-04-14 | Martin | Kentucky | 21159 | 1 | 0 |
60114 | 60114 | 2020-04-15 | Martin | Kentucky | 21159 | 1 | 0 |
62834 | 62834 | 2020-04-16 | Martin | Kentucky | 21159 | 2 | 0 |
65573 | 65573 | 2020-04-17 | Martin | Kentucky | 21159 | 2 | 0 |
68322 | 68322 | 2020-04-18 | Martin | Kentucky | 21159 | 2 | 0 |
71085 | 71085 | 2020-04-19 | Martin | Kentucky | 21159 | 2 | 0 |
73857 | 73857 | 2020-04-20 | Martin | Kentucky | 21159 | 2 | 0 |
76638 | 76638 | 2020-04-21 | Martin | Kentucky | 21159 | 3 | 0 |
79423 | 79423 | 2020-04-22 | Martin | Kentucky | 21159 | 3 | 0 |
82220 | 82220 | 2020-04-23 | Martin | Kentucky | 21159 | 3 | 0 |
85023 | 85023 | 2020-04-24 | Martin | Kentucky | 21159 | 3 | 0 |
87832 | 87832 | 2020-04-25 | Martin | Kentucky | 21159 | 3 | 0 |
90648 | 90648 | 2020-04-26 | Martin | Kentucky | 21159 | 3 | 0 |
93469 | 93469 | 2020-04-27 | Martin | Kentucky | 21159 | 3 | 0 |
96302 | 96302 | 2020-04-28 | Martin | Kentucky | 21159 | 3 | 0 |
99148 | 99148 | 2020-04-29 | Martin | Kentucky | 21159 | 3 | 0 |
102000 | 102000 | 2020-04-30 | Martin | Kentucky | 21159 | 3 | 0 |
104861 | 104861 | 2020-05-01 | Martin | Kentucky | 21159 | 3 | 0 |
107726 | 107726 | 2020-05-02 | Martin | Kentucky | 21159 | 3 | 0 |
110597 | 110597 | 2020-05-03 | Martin | Kentucky | 21159 | 3 | 0 |
113474 | 113474 | 2020-05-04 | Martin | Kentucky | 21159 | 3 | 0 |
116356 | 116356 | 2020-05-05 | Martin | Kentucky | 21159 | 3 | 0 |
119317 | 119317 | 2020-05-06 | Martin | Kentucky | 21159 | 3 | 0 |
122288 | 122288 | 2020-05-07 | Martin | Kentucky | 21159 | 3 | 0 |
125270 | 125270 | 2020-05-08 | Martin | Kentucky | 21159 | 3 | 0 |
128258 | 128258 | 2020-05-09 | Martin | Kentucky | 21159 | 3 | 0 |
131248 | 131248 | 2020-05-10 | Martin | Kentucky | 21159 | 3 | 0 |
134239 | 134239 | 2020-05-11 | Martin | Kentucky | 21159 | 3 | 0 |
137229 | 137229 | 2020-05-12 | Martin | Kentucky | 21159 | 3 | 0 |
140222 | 140222 | 2020-05-13 | Martin | Kentucky | 21159 | 3 | 0 |
143218 | 143218 | 2020-05-14 | Martin | Kentucky | 21159 | 3 | 0 |
146218 | 146218 | 2020-05-15 | Martin | Kentucky | 21159 | 3 | 0 |
149223 | 149223 | 2020-05-16 | Martin | Kentucky | 21159 | 3 | 0 |
152234 | 152234 | 2020-05-17 | Martin | Kentucky | 21159 | 3 | 0 |
155248 | 155248 | 2020-05-18 | Martin | Kentucky | 21159 | 3 | 0 |
158265 | 158265 | 2020-05-19 | Martin | Kentucky | 21159 | 3 | 0 |
161291 | 161291 | 2020-05-20 | Martin | Kentucky | 21159 | 3 | 0 |
164320 | 164320 | 2020-05-21 | Martin | Kentucky | 21159 | 3 | 0 |
167356 | 167356 | 2020-05-22 | Martin | Kentucky | 21159 | 3 | 0 |
170394 | 170394 | 2020-05-23 | Martin | Kentucky | 21159 | 3 | 0 |
173435 | 173435 | 2020-05-24 | Martin | Kentucky | 21159 | 3 | 0 |
176479 | 176479 | 2020-05-25 | Martin | Kentucky | 21159 | 3 | 0 |
179523 | 179523 | 2020-05-26 | Martin | Kentucky | 21159 | 3 | 0 |
182568 | 182568 | 2020-05-27 | Martin | Kentucky | 21159 | 3 | 0 |
185623 | 185623 | 2020-05-28 | Martin | Kentucky | 21159 | 3 | 0 |
188681 | 188681 | 2020-05-29 | Martin | Kentucky | 21159 | 3 | 0 |
191745 | 191745 | 2020-05-30 | Martin | Kentucky | 21159 | 3 | 0 |
194813 | 194813 | 2020-05-31 | Martin | Kentucky | 21159 | 3 | 0 |
197884 | 197884 | 2020-06-01 | Martin | Kentucky | 21159 | 3 | 0 |
200956 | 200956 | 2020-06-02 | Martin | Kentucky | 21159 | 3 | 0 |
204033 | 204033 | 2020-06-03 | Martin | Kentucky | 21159 | 3 | 0 |
207114 | 207114 | 2020-06-04 | Martin | Kentucky | 21159 | 3 | 0 |
210195 | 210195 | 2020-06-05 | Martin | Kentucky | 21159 | 3 | 0 |
213280 | 213280 | 2020-06-06 | Martin | Kentucky | 21159 | 3 | 0 |
216367 | 216367 | 2020-06-07 | Martin | Kentucky | 21159 | 3 | 0 |
219459 | 219459 | 2020-06-08 | Martin | Kentucky | 21159 | 3 | 0 |
222554 | 222554 | 2020-06-09 | Martin | Kentucky | 21159 | 3 | 0 |
225650 | 225650 | 2020-06-10 | Martin | Kentucky | 21159 | 3 | 0 |
228752 | 228752 | 2020-06-11 | Martin | Kentucky | 21159 | 3 | 0 |
231856 | 231856 | 2020-06-12 | Martin | Kentucky | 21159 | 3 | 0 |
234961 | 234961 | 2020-06-13 | Martin | Kentucky | 21159 | 3 | 0 |
238068 | 238068 | 2020-06-14 | Martin | Kentucky | 21159 | 3 | 0 |
241177 | 241177 | 2020-06-15 | Martin | Kentucky | 21159 | 3 | 0 |
244288 | 244288 | 2020-06-16 | Martin | Kentucky | 21159 | 3 | 0 |
247401 | 247401 | 2020-06-17 | Martin | Kentucky | 21159 | 3 | 0 |
250513 | 250513 | 2020-06-18 | Martin | Kentucky | 21159 | 3 | 0 |
253628 | 253628 | 2020-06-19 | Martin | Kentucky | 21159 | 3 | 0 |
256748 | 256748 | 2020-06-20 | Martin | Kentucky | 21159 | 3 | 0 |
259874 | 259874 | 2020-06-21 | Martin | Kentucky | 21159 | 4 | 0 |
263003 | 263003 | 2020-06-22 | Martin | Kentucky | 21159 | 4 | 0 |
266130 | 266130 | 2020-06-23 | Martin | Kentucky | 21159 | 5 | 0 |
269263 | 269263 | 2020-06-24 | Martin | Kentucky | 21159 | 5 | 0 |
272399 | 272399 | 2020-06-25 | Martin | Kentucky | 21159 | 5 | 0 |
275542 | 275542 | 2020-06-26 | Martin | Kentucky | 21159 | 5 | 0 |
278690 | 278690 | 2020-06-27 | Martin | Kentucky | 21159 | 5 | 0 |
281838 | 281838 | 2020-06-28 | Martin | Kentucky | 21159 | 5 | 0 |
284984 | 284984 | 2020-06-29 | Martin | Kentucky | 21159 | 5 | 0 |
288133 | 288133 | 2020-06-30 | Martin | Kentucky | 21159 | 5 | 0 |
291283 | 291283 | 2020-07-01 | Martin | Kentucky | 21159 | 7 | 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);