ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
746 rows where county = "Metcalfe" and state = "Kentucky" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
297603 | 297603 | 2020-07-03 | Metcalfe | Kentucky | 21169 | 11 | 2 |
294445 | 294445 | 2020-07-02 | Metcalfe | Kentucky | 21169 | 11 | 2 |
291291 | 291291 | 2020-07-01 | Metcalfe | Kentucky | 21169 | 10 | 2 |
288141 | 288141 | 2020-06-30 | Metcalfe | Kentucky | 21169 | 9 | 2 |
284992 | 284992 | 2020-06-29 | Metcalfe | Kentucky | 21169 | 9 | 2 |
281846 | 281846 | 2020-06-28 | Metcalfe | Kentucky | 21169 | 9 | 2 |
278698 | 278698 | 2020-06-27 | Metcalfe | Kentucky | 21169 | 9 | 2 |
275550 | 275550 | 2020-06-26 | Metcalfe | Kentucky | 21169 | 9 | 2 |
272407 | 272407 | 2020-06-25 | Metcalfe | Kentucky | 21169 | 9 | 2 |
269271 | 269271 | 2020-06-24 | Metcalfe | Kentucky | 21169 | 9 | 2 |
266138 | 266138 | 2020-06-23 | Metcalfe | Kentucky | 21169 | 8 | 2 |
263011 | 263011 | 2020-06-22 | Metcalfe | Kentucky | 21169 | 8 | 2 |
259882 | 259882 | 2020-06-21 | Metcalfe | Kentucky | 21169 | 8 | 2 |
256756 | 256756 | 2020-06-20 | Metcalfe | Kentucky | 21169 | 8 | 2 |
253636 | 253636 | 2020-06-19 | Metcalfe | Kentucky | 21169 | 8 | 2 |
250521 | 250521 | 2020-06-18 | Metcalfe | Kentucky | 21169 | 8 | 2 |
247409 | 247409 | 2020-06-17 | Metcalfe | Kentucky | 21169 | 8 | 2 |
244296 | 244296 | 2020-06-16 | Metcalfe | Kentucky | 21169 | 8 | 2 |
241185 | 241185 | 2020-06-15 | Metcalfe | Kentucky | 21169 | 8 | 2 |
238076 | 238076 | 2020-06-14 | Metcalfe | Kentucky | 21169 | 7 | 2 |
234969 | 234969 | 2020-06-13 | Metcalfe | Kentucky | 21169 | 7 | 2 |
231864 | 231864 | 2020-06-12 | Metcalfe | Kentucky | 21169 | 7 | 2 |
228760 | 228760 | 2020-06-11 | Metcalfe | Kentucky | 21169 | 7 | 2 |
225658 | 225658 | 2020-06-10 | Metcalfe | Kentucky | 21169 | 7 | 2 |
222562 | 222562 | 2020-06-09 | Metcalfe | Kentucky | 21169 | 7 | 2 |
219467 | 219467 | 2020-06-08 | Metcalfe | Kentucky | 21169 | 7 | 2 |
216375 | 216375 | 2020-06-07 | Metcalfe | Kentucky | 21169 | 7 | 2 |
213288 | 213288 | 2020-06-06 | Metcalfe | Kentucky | 21169 | 7 | 2 |
210203 | 210203 | 2020-06-05 | Metcalfe | Kentucky | 21169 | 7 | 2 |
207122 | 207122 | 2020-06-04 | Metcalfe | Kentucky | 21169 | 7 | 2 |
204041 | 204041 | 2020-06-03 | Metcalfe | Kentucky | 21169 | 7 | 1 |
200964 | 200964 | 2020-06-02 | Metcalfe | Kentucky | 21169 | 7 | 1 |
197892 | 197892 | 2020-06-01 | Metcalfe | Kentucky | 21169 | 7 | 1 |
194821 | 194821 | 2020-05-31 | Metcalfe | Kentucky | 21169 | 7 | 1 |
191753 | 191753 | 2020-05-30 | Metcalfe | Kentucky | 21169 | 6 | 1 |
188689 | 188689 | 2020-05-29 | Metcalfe | Kentucky | 21169 | 6 | 0 |
185631 | 185631 | 2020-05-28 | Metcalfe | Kentucky | 21169 | 4 | 0 |
182576 | 182576 | 2020-05-27 | Metcalfe | Kentucky | 21169 | 4 | 0 |
179531 | 179531 | 2020-05-26 | Metcalfe | Kentucky | 21169 | 4 | 0 |
176487 | 176487 | 2020-05-25 | Metcalfe | Kentucky | 21169 | 4 | 0 |
173443 | 173443 | 2020-05-24 | Metcalfe | Kentucky | 21169 | 4 | 0 |
170402 | 170402 | 2020-05-23 | Metcalfe | Kentucky | 21169 | 4 | 0 |
167364 | 167364 | 2020-05-22 | Metcalfe | Kentucky | 21169 | 4 | 0 |
164328 | 164328 | 2020-05-21 | Metcalfe | Kentucky | 21169 | 4 | 0 |
161299 | 161299 | 2020-05-20 | Metcalfe | Kentucky | 21169 | 3 | 0 |
158273 | 158273 | 2020-05-19 | Metcalfe | Kentucky | 21169 | 3 | 0 |
155256 | 155256 | 2020-05-18 | Metcalfe | Kentucky | 21169 | 3 | 0 |
152242 | 152242 | 2020-05-17 | Metcalfe | Kentucky | 21169 | 3 | 0 |
149231 | 149231 | 2020-05-16 | Metcalfe | Kentucky | 21169 | 3 | 0 |
146226 | 146226 | 2020-05-15 | Metcalfe | Kentucky | 21169 | 3 | 0 |
143226 | 143226 | 2020-05-14 | Metcalfe | Kentucky | 21169 | 3 | 0 |
140230 | 140230 | 2020-05-13 | Metcalfe | Kentucky | 21169 | 3 | 0 |
137237 | 137237 | 2020-05-12 | Metcalfe | Kentucky | 21169 | 3 | 0 |
134247 | 134247 | 2020-05-11 | Metcalfe | Kentucky | 21169 | 2 | 0 |
131256 | 131256 | 2020-05-10 | Metcalfe | Kentucky | 21169 | 2 | 0 |
128266 | 128266 | 2020-05-09 | Metcalfe | Kentucky | 21169 | 2 | 0 |
125278 | 125278 | 2020-05-08 | Metcalfe | Kentucky | 21169 | 2 | 0 |
122296 | 122296 | 2020-05-07 | Metcalfe | Kentucky | 21169 | 2 | 0 |
119325 | 119325 | 2020-05-06 | Metcalfe | Kentucky | 21169 | 1 | 0 |
116364 | 116364 | 2020-05-05 | Metcalfe | Kentucky | 21169 | 1 | 0 |
113482 | 113482 | 2020-05-04 | Metcalfe | Kentucky | 21169 | 1 | 0 |
110605 | 110605 | 2020-05-03 | Metcalfe | Kentucky | 21169 | 1 | 0 |
107734 | 107734 | 2020-05-02 | Metcalfe | Kentucky | 21169 | 1 | 0 |
104869 | 104869 | 2020-05-01 | Metcalfe | Kentucky | 21169 | 1 | 0 |
102008 | 102008 | 2020-04-30 | Metcalfe | Kentucky | 21169 | 1 | 0 |
99156 | 99156 | 2020-04-29 | Metcalfe | Kentucky | 21169 | 1 | 0 |
96310 | 96310 | 2020-04-28 | Metcalfe | Kentucky | 21169 | 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);