ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
774 rows where county = "Rockcastle" and state = "Kentucky" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
297620 | 297620 | 2020-07-03 | Rockcastle | Kentucky | 21203 | 21 | 0 |
294462 | 294462 | 2020-07-02 | Rockcastle | Kentucky | 21203 | 21 | 0 |
291308 | 291308 | 2020-07-01 | Rockcastle | Kentucky | 21203 | 21 | 0 |
288157 | 288157 | 2020-06-30 | Rockcastle | Kentucky | 21203 | 21 | 0 |
285008 | 285008 | 2020-06-29 | Rockcastle | Kentucky | 21203 | 19 | 0 |
281862 | 281862 | 2020-06-28 | Rockcastle | Kentucky | 21203 | 19 | 0 |
278714 | 278714 | 2020-06-27 | Rockcastle | Kentucky | 21203 | 19 | 0 |
275566 | 275566 | 2020-06-26 | Rockcastle | Kentucky | 21203 | 18 | 0 |
272423 | 272423 | 2020-06-25 | Rockcastle | Kentucky | 21203 | 18 | 0 |
269287 | 269287 | 2020-06-24 | Rockcastle | Kentucky | 21203 | 18 | 0 |
266154 | 266154 | 2020-06-23 | Rockcastle | Kentucky | 21203 | 18 | 0 |
263027 | 263027 | 2020-06-22 | Rockcastle | Kentucky | 21203 | 17 | 0 |
259898 | 259898 | 2020-06-21 | Rockcastle | Kentucky | 21203 | 17 | 0 |
256772 | 256772 | 2020-06-20 | Rockcastle | Kentucky | 21203 | 16 | 0 |
253652 | 253652 | 2020-06-19 | Rockcastle | Kentucky | 21203 | 16 | 0 |
250537 | 250537 | 2020-06-18 | Rockcastle | Kentucky | 21203 | 16 | 0 |
247425 | 247425 | 2020-06-17 | Rockcastle | Kentucky | 21203 | 15 | 0 |
244312 | 244312 | 2020-06-16 | Rockcastle | Kentucky | 21203 | 14 | 0 |
241201 | 241201 | 2020-06-15 | Rockcastle | Kentucky | 21203 | 14 | 0 |
238092 | 238092 | 2020-06-14 | Rockcastle | Kentucky | 21203 | 14 | 0 |
234985 | 234985 | 2020-06-13 | Rockcastle | Kentucky | 21203 | 14 | 0 |
231880 | 231880 | 2020-06-12 | Rockcastle | Kentucky | 21203 | 14 | 0 |
228776 | 228776 | 2020-06-11 | Rockcastle | Kentucky | 21203 | 13 | 0 |
225674 | 225674 | 2020-06-10 | Rockcastle | Kentucky | 21203 | 13 | 0 |
222578 | 222578 | 2020-06-09 | Rockcastle | Kentucky | 21203 | 13 | 0 |
219483 | 219483 | 2020-06-08 | Rockcastle | Kentucky | 21203 | 13 | 0 |
216391 | 216391 | 2020-06-07 | Rockcastle | Kentucky | 21203 | 13 | 0 |
213304 | 213304 | 2020-06-06 | Rockcastle | Kentucky | 21203 | 13 | 0 |
210219 | 210219 | 2020-06-05 | Rockcastle | Kentucky | 21203 | 13 | 0 |
207138 | 207138 | 2020-06-04 | Rockcastle | Kentucky | 21203 | 13 | 0 |
204057 | 204057 | 2020-06-03 | Rockcastle | Kentucky | 21203 | 13 | 0 |
200980 | 200980 | 2020-06-02 | Rockcastle | Kentucky | 21203 | 13 | 0 |
197908 | 197908 | 2020-06-01 | Rockcastle | Kentucky | 21203 | 13 | 0 |
194837 | 194837 | 2020-05-31 | Rockcastle | Kentucky | 21203 | 13 | 0 |
191769 | 191769 | 2020-05-30 | Rockcastle | Kentucky | 21203 | 13 | 0 |
188705 | 188705 | 2020-05-29 | Rockcastle | Kentucky | 21203 | 13 | 0 |
185647 | 185647 | 2020-05-28 | Rockcastle | Kentucky | 21203 | 13 | 0 |
182592 | 182592 | 2020-05-27 | Rockcastle | Kentucky | 21203 | 13 | 0 |
179547 | 179547 | 2020-05-26 | Rockcastle | Kentucky | 21203 | 13 | 0 |
176503 | 176503 | 2020-05-25 | Rockcastle | Kentucky | 21203 | 13 | 0 |
173459 | 173459 | 2020-05-24 | Rockcastle | Kentucky | 21203 | 13 | 0 |
170418 | 170418 | 2020-05-23 | Rockcastle | Kentucky | 21203 | 13 | 0 |
167380 | 167380 | 2020-05-22 | Rockcastle | Kentucky | 21203 | 13 | 0 |
164344 | 164344 | 2020-05-21 | Rockcastle | Kentucky | 21203 | 13 | 0 |
161315 | 161315 | 2020-05-20 | Rockcastle | Kentucky | 21203 | 13 | 0 |
158289 | 158289 | 2020-05-19 | Rockcastle | Kentucky | 21203 | 12 | 0 |
155272 | 155272 | 2020-05-18 | Rockcastle | Kentucky | 21203 | 12 | 0 |
152258 | 152258 | 2020-05-17 | Rockcastle | Kentucky | 21203 | 12 | 0 |
149247 | 149247 | 2020-05-16 | Rockcastle | Kentucky | 21203 | 13 | 0 |
146242 | 146242 | 2020-05-15 | Rockcastle | Kentucky | 21203 | 13 | 0 |
143242 | 143242 | 2020-05-14 | Rockcastle | Kentucky | 21203 | 13 | 0 |
140246 | 140246 | 2020-05-13 | Rockcastle | Kentucky | 21203 | 13 | 0 |
137253 | 137253 | 2020-05-12 | Rockcastle | Kentucky | 21203 | 13 | 0 |
134263 | 134263 | 2020-05-11 | Rockcastle | Kentucky | 21203 | 13 | 0 |
131272 | 131272 | 2020-05-10 | Rockcastle | Kentucky | 21203 | 13 | 0 |
128282 | 128282 | 2020-05-09 | Rockcastle | Kentucky | 21203 | 13 | 0 |
125294 | 125294 | 2020-05-08 | Rockcastle | Kentucky | 21203 | 13 | 0 |
122312 | 122312 | 2020-05-07 | Rockcastle | Kentucky | 21203 | 13 | 0 |
119341 | 119341 | 2020-05-06 | Rockcastle | Kentucky | 21203 | 13 | 0 |
116380 | 116380 | 2020-05-05 | Rockcastle | Kentucky | 21203 | 12 | 0 |
113498 | 113498 | 2020-05-04 | Rockcastle | Kentucky | 21203 | 11 | 0 |
110621 | 110621 | 2020-05-03 | Rockcastle | Kentucky | 21203 | 11 | 0 |
107750 | 107750 | 2020-05-02 | Rockcastle | Kentucky | 21203 | 11 | 0 |
104885 | 104885 | 2020-05-01 | Rockcastle | Kentucky | 21203 | 11 | 0 |
102024 | 102024 | 2020-04-30 | Rockcastle | Kentucky | 21203 | 11 | 0 |
99172 | 99172 | 2020-04-29 | Rockcastle | Kentucky | 21203 | 11 | 0 |
96326 | 96326 | 2020-04-28 | Rockcastle | Kentucky | 21203 | 11 | 0 |
93491 | 93491 | 2020-04-27 | Rockcastle | Kentucky | 21203 | 11 | 0 |
90670 | 90670 | 2020-04-26 | Rockcastle | Kentucky | 21203 | 11 | 0 |
87854 | 87854 | 2020-04-25 | Rockcastle | Kentucky | 21203 | 11 | 0 |
85045 | 85045 | 2020-04-24 | Rockcastle | Kentucky | 21203 | 11 | 0 |
82242 | 82242 | 2020-04-23 | Rockcastle | Kentucky | 21203 | 11 | 0 |
79445 | 79445 | 2020-04-22 | Rockcastle | Kentucky | 21203 | 11 | 0 |
76660 | 76660 | 2020-04-21 | Rockcastle | Kentucky | 21203 | 11 | 0 |
73879 | 73879 | 2020-04-20 | Rockcastle | Kentucky | 21203 | 11 | 0 |
71107 | 71107 | 2020-04-19 | Rockcastle | Kentucky | 21203 | 11 | 0 |
68344 | 68344 | 2020-04-18 | Rockcastle | Kentucky | 21203 | 11 | 0 |
65595 | 65595 | 2020-04-17 | Rockcastle | Kentucky | 21203 | 11 | 0 |
62856 | 62856 | 2020-04-16 | Rockcastle | Kentucky | 21203 | 11 | 0 |
60136 | 60136 | 2020-04-15 | Rockcastle | Kentucky | 21203 | 10 | 0 |
57427 | 57427 | 2020-04-14 | Rockcastle | Kentucky | 21203 | 9 | 0 |
54729 | 54729 | 2020-04-13 | Rockcastle | Kentucky | 21203 | 9 | 0 |
52048 | 52048 | 2020-04-12 | Rockcastle | Kentucky | 21203 | 9 | 0 |
49380 | 49380 | 2020-04-11 | Rockcastle | Kentucky | 21203 | 8 | 0 |
46740 | 46740 | 2020-04-10 | Rockcastle | Kentucky | 21203 | 6 | 0 |
44132 | 44132 | 2020-04-09 | Rockcastle | Kentucky | 21203 | 6 | 0 |
41556 | 41556 | 2020-04-08 | Rockcastle | Kentucky | 21203 | 6 | 0 |
39006 | 39006 | 2020-04-07 | Rockcastle | Kentucky | 21203 | 4 | 0 |
36499 | 36499 | 2020-04-06 | Rockcastle | Kentucky | 21203 | 1 | 0 |
34041 | 34041 | 2020-04-05 | Rockcastle | Kentucky | 21203 | 1 | 0 |
31616 | 31616 | 2020-04-04 | Rockcastle | Kentucky | 21203 | 1 | 0 |
29238 | 29238 | 2020-04-03 | Rockcastle | Kentucky | 21203 | 1 | 0 |
26922 | 26922 | 2020-04-02 | Rockcastle | Kentucky | 21203 | 1 | 0 |
24672 | 24672 | 2020-04-01 | Rockcastle | Kentucky | 21203 | 1 | 0 |
22496 | 22496 | 2020-03-31 | Rockcastle | Kentucky | 21203 | 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);