ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
778 rows where county = "Larue" and state = "Kentucky" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
386994 | 386994 | 2020-07-31 | Larue | Kentucky | 21123 | 60 | 1 |
383776 | 383776 | 2020-07-30 | Larue | Kentucky | 21123 | 58 | 1 |
380559 | 380559 | 2020-07-29 | Larue | Kentucky | 21123 | 58 | 1 |
377342 | 377342 | 2020-07-28 | Larue | Kentucky | 21123 | 56 | 1 |
374127 | 374127 | 2020-07-27 | Larue | Kentucky | 21123 | 54 | 1 |
370915 | 370915 | 2020-07-26 | Larue | Kentucky | 21123 | 50 | 1 |
367705 | 367705 | 2020-07-25 | Larue | Kentucky | 21123 | 50 | 1 |
364498 | 364498 | 2020-07-24 | Larue | Kentucky | 21123 | 50 | 1 |
361291 | 361291 | 2020-07-23 | Larue | Kentucky | 21123 | 50 | 1 |
358086 | 358086 | 2020-07-22 | Larue | Kentucky | 21123 | 50 | 1 |
354883 | 354883 | 2020-07-21 | Larue | Kentucky | 21123 | 42 | 1 |
351681 | 351681 | 2020-07-20 | Larue | Kentucky | 21123 | 38 | 1 |
348481 | 348481 | 2020-07-19 | Larue | Kentucky | 21123 | 36 | 1 |
345280 | 345280 | 2020-07-18 | Larue | Kentucky | 21123 | 36 | 1 |
342080 | 342080 | 2020-07-17 | Larue | Kentucky | 21123 | 36 | 1 |
338884 | 338884 | 2020-07-16 | Larue | Kentucky | 21123 | 26 | 1 |
335688 | 335688 | 2020-07-15 | Larue | Kentucky | 21123 | 26 | 1 |
332495 | 332495 | 2020-07-14 | Larue | Kentucky | 21123 | 24 | 1 |
329308 | 329308 | 2020-07-13 | Larue | Kentucky | 21123 | 23 | 1 |
326122 | 326122 | 2020-07-12 | Larue | Kentucky | 21123 | 20 | 1 |
322939 | 322939 | 2020-07-11 | Larue | Kentucky | 21123 | 20 | 1 |
319760 | 319760 | 2020-07-10 | Larue | Kentucky | 21123 | 20 | 1 |
316585 | 316585 | 2020-07-09 | Larue | Kentucky | 21123 | 20 | 1 |
313411 | 313411 | 2020-07-08 | Larue | Kentucky | 21123 | 20 | 1 |
310241 | 310241 | 2020-07-07 | Larue | Kentucky | 21123 | 20 | 1 |
307073 | 307073 | 2020-07-06 | Larue | Kentucky | 21123 | 19 | 1 |
303906 | 303906 | 2020-07-05 | Larue | Kentucky | 21123 | 17 | 1 |
300742 | 300742 | 2020-07-04 | Larue | Kentucky | 21123 | 17 | 1 |
297580 | 297580 | 2020-07-03 | Larue | Kentucky | 21123 | 17 | 1 |
294422 | 294422 | 2020-07-02 | Larue | Kentucky | 21123 | 17 | 1 |
291268 | 291268 | 2020-07-01 | Larue | Kentucky | 21123 | 17 | 1 |
288118 | 288118 | 2020-06-30 | Larue | Kentucky | 21123 | 17 | 1 |
284969 | 284969 | 2020-06-29 | Larue | Kentucky | 21123 | 16 | 1 |
281823 | 281823 | 2020-06-28 | Larue | Kentucky | 21123 | 15 | 1 |
278675 | 278675 | 2020-06-27 | Larue | Kentucky | 21123 | 15 | 1 |
275527 | 275527 | 2020-06-26 | Larue | Kentucky | 21123 | 15 | 1 |
272384 | 272384 | 2020-06-25 | Larue | Kentucky | 21123 | 15 | 1 |
269248 | 269248 | 2020-06-24 | Larue | Kentucky | 21123 | 15 | 1 |
266115 | 266115 | 2020-06-23 | Larue | Kentucky | 21123 | 15 | 1 |
262988 | 262988 | 2020-06-22 | Larue | Kentucky | 21123 | 15 | 1 |
259859 | 259859 | 2020-06-21 | Larue | Kentucky | 21123 | 15 | 1 |
256733 | 256733 | 2020-06-20 | Larue | Kentucky | 21123 | 15 | 1 |
253613 | 253613 | 2020-06-19 | Larue | Kentucky | 21123 | 15 | 1 |
250498 | 250498 | 2020-06-18 | Larue | Kentucky | 21123 | 15 | 1 |
247386 | 247386 | 2020-06-17 | Larue | Kentucky | 21123 | 15 | 1 |
244273 | 244273 | 2020-06-16 | Larue | Kentucky | 21123 | 15 | 1 |
241162 | 241162 | 2020-06-15 | Larue | Kentucky | 21123 | 15 | 1 |
238053 | 238053 | 2020-06-14 | Larue | Kentucky | 21123 | 15 | 1 |
234946 | 234946 | 2020-06-13 | Larue | Kentucky | 21123 | 15 | 1 |
231841 | 231841 | 2020-06-12 | Larue | Kentucky | 21123 | 15 | 1 |
228737 | 228737 | 2020-06-11 | Larue | Kentucky | 21123 | 15 | 1 |
225635 | 225635 | 2020-06-10 | Larue | Kentucky | 21123 | 13 | 1 |
222539 | 222539 | 2020-06-09 | Larue | Kentucky | 21123 | 12 | 1 |
219444 | 219444 | 2020-06-08 | Larue | Kentucky | 21123 | 12 | 0 |
216352 | 216352 | 2020-06-07 | Larue | Kentucky | 21123 | 11 | 0 |
213265 | 213265 | 2020-06-06 | Larue | Kentucky | 21123 | 11 | 0 |
210180 | 210180 | 2020-06-05 | Larue | Kentucky | 21123 | 9 | 0 |
207099 | 207099 | 2020-06-04 | Larue | Kentucky | 21123 | 9 | 0 |
204018 | 204018 | 2020-06-03 | Larue | Kentucky | 21123 | 8 | 0 |
200941 | 200941 | 2020-06-02 | Larue | Kentucky | 21123 | 8 | 0 |
197869 | 197869 | 2020-06-01 | Larue | Kentucky | 21123 | 8 | 0 |
194798 | 194798 | 2020-05-31 | Larue | Kentucky | 21123 | 8 | 0 |
191730 | 191730 | 2020-05-30 | Larue | Kentucky | 21123 | 8 | 0 |
188666 | 188666 | 2020-05-29 | Larue | Kentucky | 21123 | 7 | 0 |
185608 | 185608 | 2020-05-28 | Larue | Kentucky | 21123 | 7 | 0 |
182554 | 182554 | 2020-05-27 | Larue | Kentucky | 21123 | 7 | 0 |
179509 | 179509 | 2020-05-26 | Larue | Kentucky | 21123 | 7 | 0 |
176465 | 176465 | 2020-05-25 | Larue | Kentucky | 21123 | 7 | 0 |
173421 | 173421 | 2020-05-24 | Larue | Kentucky | 21123 | 7 | 0 |
170380 | 170380 | 2020-05-23 | Larue | Kentucky | 21123 | 7 | 0 |
167342 | 167342 | 2020-05-22 | Larue | Kentucky | 21123 | 6 | 0 |
164306 | 164306 | 2020-05-21 | Larue | Kentucky | 21123 | 6 | 0 |
161277 | 161277 | 2020-05-20 | Larue | Kentucky | 21123 | 6 | 0 |
158251 | 158251 | 2020-05-19 | Larue | Kentucky | 21123 | 6 | 0 |
155234 | 155234 | 2020-05-18 | Larue | Kentucky | 21123 | 6 | 0 |
152220 | 152220 | 2020-05-17 | Larue | Kentucky | 21123 | 6 | 0 |
149209 | 149209 | 2020-05-16 | Larue | Kentucky | 21123 | 6 | 0 |
146205 | 146205 | 2020-05-15 | Larue | Kentucky | 21123 | 6 | 0 |
143205 | 143205 | 2020-05-14 | Larue | Kentucky | 21123 | 6 | 0 |
140209 | 140209 | 2020-05-13 | Larue | Kentucky | 21123 | 6 | 0 |
137216 | 137216 | 2020-05-12 | Larue | Kentucky | 21123 | 6 | 0 |
134226 | 134226 | 2020-05-11 | Larue | Kentucky | 21123 | 6 | 0 |
131235 | 131235 | 2020-05-10 | Larue | Kentucky | 21123 | 6 | 0 |
128245 | 128245 | 2020-05-09 | Larue | Kentucky | 21123 | 6 | 0 |
125257 | 125257 | 2020-05-08 | Larue | Kentucky | 21123 | 6 | 0 |
122275 | 122275 | 2020-05-07 | Larue | Kentucky | 21123 | 6 | 0 |
119304 | 119304 | 2020-05-06 | Larue | Kentucky | 21123 | 6 | 0 |
116343 | 116343 | 2020-05-05 | Larue | Kentucky | 21123 | 5 | 0 |
113461 | 113461 | 2020-05-04 | Larue | Kentucky | 21123 | 5 | 0 |
110584 | 110584 | 2020-05-03 | Larue | Kentucky | 21123 | 5 | 0 |
107713 | 107713 | 2020-05-02 | Larue | Kentucky | 21123 | 5 | 0 |
104848 | 104848 | 2020-05-01 | Larue | Kentucky | 21123 | 5 | 0 |
101987 | 101987 | 2020-04-30 | Larue | Kentucky | 21123 | 5 | 0 |
99135 | 99135 | 2020-04-29 | Larue | Kentucky | 21123 | 5 | 0 |
96289 | 96289 | 2020-04-28 | Larue | Kentucky | 21123 | 5 | 0 |
93456 | 93456 | 2020-04-27 | Larue | Kentucky | 21123 | 5 | 0 |
90635 | 90635 | 2020-04-26 | Larue | Kentucky | 21123 | 5 | 0 |
87819 | 87819 | 2020-04-25 | Larue | Kentucky | 21123 | 5 | 0 |
85010 | 85010 | 2020-04-24 | Larue | Kentucky | 21123 | 5 | 0 |
82207 | 82207 | 2020-04-23 | Larue | Kentucky | 21123 | 5 | 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);