ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
51 rows where cases = 12, fips = 21033 and state = "Kentucky" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
256688 | 256688 | 2020-06-20 | Caldwell | Kentucky | 21033 | 12 | 0 |
253568 | 253568 | 2020-06-19 | Caldwell | Kentucky | 21033 | 12 | 0 |
250453 | 250453 | 2020-06-18 | Caldwell | Kentucky | 21033 | 12 | 0 |
247341 | 247341 | 2020-06-17 | Caldwell | Kentucky | 21033 | 12 | 0 |
244228 | 244228 | 2020-06-16 | Caldwell | Kentucky | 21033 | 12 | 0 |
241117 | 241117 | 2020-06-15 | Caldwell | Kentucky | 21033 | 12 | 0 |
238008 | 238008 | 2020-06-14 | Caldwell | Kentucky | 21033 | 12 | 0 |
234901 | 234901 | 2020-06-13 | Caldwell | Kentucky | 21033 | 12 | 0 |
231796 | 231796 | 2020-06-12 | Caldwell | Kentucky | 21033 | 12 | 0 |
228692 | 228692 | 2020-06-11 | Caldwell | Kentucky | 21033 | 12 | 0 |
225590 | 225590 | 2020-06-10 | Caldwell | Kentucky | 21033 | 12 | 0 |
222494 | 222494 | 2020-06-09 | Caldwell | Kentucky | 21033 | 12 | 0 |
219399 | 219399 | 2020-06-08 | Caldwell | Kentucky | 21033 | 12 | 0 |
216307 | 216307 | 2020-06-07 | Caldwell | Kentucky | 21033 | 12 | 0 |
213220 | 213220 | 2020-06-06 | Caldwell | Kentucky | 21033 | 12 | 0 |
210135 | 210135 | 2020-06-05 | Caldwell | Kentucky | 21033 | 12 | 0 |
207054 | 207054 | 2020-06-04 | Caldwell | Kentucky | 21033 | 12 | 0 |
203973 | 203973 | 2020-06-03 | Caldwell | Kentucky | 21033 | 12 | 0 |
200896 | 200896 | 2020-06-02 | Caldwell | Kentucky | 21033 | 12 | 0 |
197825 | 197825 | 2020-06-01 | Caldwell | Kentucky | 21033 | 12 | 0 |
194754 | 194754 | 2020-05-31 | Caldwell | Kentucky | 21033 | 12 | 0 |
191686 | 191686 | 2020-05-30 | Caldwell | Kentucky | 21033 | 12 | 0 |
188622 | 188622 | 2020-05-29 | Caldwell | Kentucky | 21033 | 12 | 0 |
185564 | 185564 | 2020-05-28 | Caldwell | Kentucky | 21033 | 12 | 0 |
182510 | 182510 | 2020-05-27 | Caldwell | Kentucky | 21033 | 12 | 0 |
179465 | 179465 | 2020-05-26 | Caldwell | Kentucky | 21033 | 12 | 0 |
176421 | 176421 | 2020-05-25 | Caldwell | Kentucky | 21033 | 12 | 0 |
173377 | 173377 | 2020-05-24 | Caldwell | Kentucky | 21033 | 12 | 0 |
170336 | 170336 | 2020-05-23 | Caldwell | Kentucky | 21033 | 12 | 0 |
167298 | 167298 | 2020-05-22 | Caldwell | Kentucky | 21033 | 12 | 0 |
164262 | 164262 | 2020-05-21 | Caldwell | Kentucky | 21033 | 12 | 0 |
161233 | 161233 | 2020-05-20 | Caldwell | Kentucky | 21033 | 12 | 0 |
158208 | 158208 | 2020-05-19 | Caldwell | Kentucky | 21033 | 12 | 0 |
155191 | 155191 | 2020-05-18 | Caldwell | Kentucky | 21033 | 12 | 0 |
152177 | 152177 | 2020-05-17 | Caldwell | Kentucky | 21033 | 12 | 0 |
149166 | 149166 | 2020-05-16 | Caldwell | Kentucky | 21033 | 12 | 0 |
146162 | 146162 | 2020-05-15 | Caldwell | Kentucky | 21033 | 12 | 0 |
143162 | 143162 | 2020-05-14 | Caldwell | Kentucky | 21033 | 12 | 0 |
140166 | 140166 | 2020-05-13 | Caldwell | Kentucky | 21033 | 12 | 0 |
137173 | 137173 | 2020-05-12 | Caldwell | Kentucky | 21033 | 12 | 0 |
134183 | 134183 | 2020-05-11 | Caldwell | Kentucky | 21033 | 12 | 0 |
131192 | 131192 | 2020-05-10 | Caldwell | Kentucky | 21033 | 12 | 0 |
128202 | 128202 | 2020-05-09 | Caldwell | Kentucky | 21033 | 12 | 0 |
125214 | 125214 | 2020-05-08 | Caldwell | Kentucky | 21033 | 12 | 0 |
122232 | 122232 | 2020-05-07 | Caldwell | Kentucky | 21033 | 12 | 0 |
119262 | 119262 | 2020-05-06 | Caldwell | Kentucky | 21033 | 12 | 0 |
116301 | 116301 | 2020-05-05 | Caldwell | Kentucky | 21033 | 12 | 0 |
113419 | 113419 | 2020-05-04 | Caldwell | Kentucky | 21033 | 12 | 0 |
82165 | 82165 | 2020-04-23 | Caldwell | Kentucky | 21033 | 12 | 0 |
79369 | 79369 | 2020-04-22 | Caldwell | Kentucky | 21033 | 12 | 0 |
76584 | 76584 | 2020-04-21 | Caldwell | Kentucky | 21033 | 12 | 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);