ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
786 rows where county = "Christian" and state = "Kentucky" sorted by state
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date | county | state ▼ | fips | cases | deaths |
---|---|---|---|---|---|---|---|
4667 | 4667 | 2020-03-19 | Christian | Kentucky | 21047 | 1 | 0 |
5481 | 5481 | 2020-03-20 | Christian | Kentucky | 21047 | 1 | 0 |
6427 | 6427 | 2020-03-21 | Christian | Kentucky | 21047 | 1 | 0 |
7498 | 7498 | 2020-03-22 | Christian | Kentucky | 21047 | 2 | 0 |
8660 | 8660 | 2020-03-23 | Christian | Kentucky | 21047 | 2 | 0 |
9943 | 9943 | 2020-03-24 | Christian | Kentucky | 21047 | 3 | 0 |
11343 | 11343 | 2020-03-25 | Christian | Kentucky | 21047 | 3 | 0 |
12913 | 12913 | 2020-03-26 | Christian | Kentucky | 21047 | 5 | 0 |
14618 | 14618 | 2020-03-27 | Christian | Kentucky | 21047 | 6 | 0 |
16431 | 16431 | 2020-03-28 | Christian | Kentucky | 21047 | 6 | 0 |
18341 | 18341 | 2020-03-29 | Christian | Kentucky | 21047 | 6 | 0 |
20355 | 20355 | 2020-03-30 | Christian | Kentucky | 21047 | 7 | 0 |
22455 | 22455 | 2020-03-31 | Christian | Kentucky | 21047 | 8 | 0 |
24631 | 24631 | 2020-04-01 | Christian | Kentucky | 21047 | 9 | 0 |
26876 | 26876 | 2020-04-02 | Christian | Kentucky | 21047 | 15 | 0 |
29192 | 29192 | 2020-04-03 | Christian | Kentucky | 21047 | 15 | 0 |
31567 | 31567 | 2020-04-04 | Christian | Kentucky | 21047 | 18 | 0 |
33985 | 33985 | 2020-04-05 | Christian | Kentucky | 21047 | 23 | 0 |
36443 | 36443 | 2020-04-06 | Christian | Kentucky | 21047 | 23 | 0 |
38948 | 38948 | 2020-04-07 | Christian | Kentucky | 21047 | 33 | 0 |
41497 | 41497 | 2020-04-08 | Christian | Kentucky | 21047 | 45 | 0 |
44072 | 44072 | 2020-04-09 | Christian | Kentucky | 21047 | 45 | 0 |
46680 | 46680 | 2020-04-10 | Christian | Kentucky | 21047 | 54 | 3 |
49317 | 49317 | 2020-04-11 | Christian | Kentucky | 21047 | 62 | 3 |
51983 | 51983 | 2020-04-12 | Christian | Kentucky | 21047 | 67 | 3 |
54664 | 54664 | 2020-04-13 | Christian | Kentucky | 21047 | 69 | 3 |
57360 | 57360 | 2020-04-14 | Christian | Kentucky | 21047 | 71 | 3 |
60069 | 60069 | 2020-04-15 | Christian | Kentucky | 21047 | 73 | 3 |
62789 | 62789 | 2020-04-16 | Christian | Kentucky | 21047 | 73 | 3 |
65528 | 65528 | 2020-04-17 | Christian | Kentucky | 21047 | 81 | 3 |
68277 | 68277 | 2020-04-18 | Christian | Kentucky | 21047 | 81 | 3 |
71038 | 71038 | 2020-04-19 | Christian | Kentucky | 21047 | 81 | 3 |
73810 | 73810 | 2020-04-20 | Christian | Kentucky | 21047 | 81 | 3 |
76590 | 76590 | 2020-04-21 | Christian | Kentucky | 21047 | 84 | 3 |
79375 | 79375 | 2020-04-22 | Christian | Kentucky | 21047 | 86 | 3 |
82172 | 82172 | 2020-04-23 | Christian | Kentucky | 21047 | 86 | 3 |
84975 | 84975 | 2020-04-24 | Christian | Kentucky | 21047 | 86 | 3 |
87784 | 87784 | 2020-04-25 | Christian | Kentucky | 21047 | 86 | 3 |
90600 | 90600 | 2020-04-26 | Christian | Kentucky | 21047 | 85 | 3 |
93421 | 93421 | 2020-04-27 | Christian | Kentucky | 21047 | 86 | 3 |
96254 | 96254 | 2020-04-28 | Christian | Kentucky | 21047 | 88 | 3 |
99100 | 99100 | 2020-04-29 | Christian | Kentucky | 21047 | 88 | 3 |
101952 | 101952 | 2020-04-30 | Christian | Kentucky | 21047 | 88 | 3 |
104813 | 104813 | 2020-05-01 | Christian | Kentucky | 21047 | 88 | 3 |
107678 | 107678 | 2020-05-02 | Christian | Kentucky | 21047 | 88 | 3 |
110549 | 110549 | 2020-05-03 | Christian | Kentucky | 21047 | 90 | 3 |
113426 | 113426 | 2020-05-04 | Christian | Kentucky | 21047 | 90 | 3 |
116308 | 116308 | 2020-05-05 | Christian | Kentucky | 21047 | 91 | 3 |
119269 | 119269 | 2020-05-06 | Christian | Kentucky | 21047 | 92 | 3 |
122239 | 122239 | 2020-05-07 | Christian | Kentucky | 21047 | 92 | 3 |
125221 | 125221 | 2020-05-08 | Christian | Kentucky | 21047 | 93 | 3 |
128209 | 128209 | 2020-05-09 | Christian | Kentucky | 21047 | 93 | 3 |
131199 | 131199 | 2020-05-10 | Christian | Kentucky | 21047 | 93 | 3 |
134190 | 134190 | 2020-05-11 | Christian | Kentucky | 21047 | 95 | 3 |
137180 | 137180 | 2020-05-12 | Christian | Kentucky | 21047 | 95 | 3 |
140173 | 140173 | 2020-05-13 | Christian | Kentucky | 21047 | 95 | 3 |
143169 | 143169 | 2020-05-14 | Christian | Kentucky | 21047 | 95 | 3 |
146169 | 146169 | 2020-05-15 | Christian | Kentucky | 21047 | 95 | 3 |
149173 | 149173 | 2020-05-16 | Christian | Kentucky | 21047 | 97 | 3 |
152184 | 152184 | 2020-05-17 | Christian | Kentucky | 21047 | 97 | 3 |
155198 | 155198 | 2020-05-18 | Christian | Kentucky | 21047 | 97 | 3 |
158215 | 158215 | 2020-05-19 | Christian | Kentucky | 21047 | 98 | 3 |
161240 | 161240 | 2020-05-20 | Christian | Kentucky | 21047 | 98 | 3 |
164269 | 164269 | 2020-05-21 | Christian | Kentucky | 21047 | 98 | 3 |
167305 | 167305 | 2020-05-22 | Christian | Kentucky | 21047 | 101 | 3 |
170343 | 170343 | 2020-05-23 | Christian | Kentucky | 21047 | 103 | 3 |
173384 | 173384 | 2020-05-24 | Christian | Kentucky | 21047 | 111 | 3 |
176428 | 176428 | 2020-05-25 | Christian | Kentucky | 21047 | 111 | 3 |
179472 | 179472 | 2020-05-26 | Christian | Kentucky | 21047 | 111 | 3 |
182517 | 182517 | 2020-05-27 | Christian | Kentucky | 21047 | 111 | 3 |
185571 | 185571 | 2020-05-28 | Christian | Kentucky | 21047 | 111 | 3 |
188629 | 188629 | 2020-05-29 | Christian | Kentucky | 21047 | 111 | 3 |
191693 | 191693 | 2020-05-30 | Christian | Kentucky | 21047 | 111 | 3 |
194761 | 194761 | 2020-05-31 | Christian | Kentucky | 21047 | 119 | 3 |
197832 | 197832 | 2020-06-01 | Christian | Kentucky | 21047 | 119 | 3 |
200903 | 200903 | 2020-06-02 | Christian | Kentucky | 21047 | 119 | 3 |
203980 | 203980 | 2020-06-03 | Christian | Kentucky | 21047 | 119 | 3 |
207061 | 207061 | 2020-06-04 | Christian | Kentucky | 21047 | 119 | 3 |
210142 | 210142 | 2020-06-05 | Christian | Kentucky | 21047 | 123 | 3 |
213227 | 213227 | 2020-06-06 | Christian | Kentucky | 21047 | 127 | 3 |
216314 | 216314 | 2020-06-07 | Christian | Kentucky | 21047 | 142 | 3 |
219406 | 219406 | 2020-06-08 | Christian | Kentucky | 21047 | 147 | 3 |
222501 | 222501 | 2020-06-09 | Christian | Kentucky | 21047 | 148 | 3 |
225597 | 225597 | 2020-06-10 | Christian | Kentucky | 21047 | 150 | 3 |
228699 | 228699 | 2020-06-11 | Christian | Kentucky | 21047 | 150 | 3 |
231803 | 231803 | 2020-06-12 | Christian | Kentucky | 21047 | 152 | 3 |
234908 | 234908 | 2020-06-13 | Christian | Kentucky | 21047 | 155 | 3 |
238015 | 238015 | 2020-06-14 | Christian | Kentucky | 21047 | 155 | 3 |
241124 | 241124 | 2020-06-15 | Christian | Kentucky | 21047 | 159 | 3 |
244235 | 244235 | 2020-06-16 | Christian | Kentucky | 21047 | 160 | 3 |
247348 | 247348 | 2020-06-17 | Christian | Kentucky | 21047 | 166 | 3 |
250460 | 250460 | 2020-06-18 | Christian | Kentucky | 21047 | 166 | 3 |
253575 | 253575 | 2020-06-19 | Christian | Kentucky | 21047 | 167 | 3 |
256695 | 256695 | 2020-06-20 | Christian | Kentucky | 21047 | 167 | 3 |
259821 | 259821 | 2020-06-21 | Christian | Kentucky | 21047 | 174 | 3 |
262950 | 262950 | 2020-06-22 | Christian | Kentucky | 21047 | 178 | 3 |
266077 | 266077 | 2020-06-23 | Christian | Kentucky | 21047 | 179 | 3 |
269210 | 269210 | 2020-06-24 | Christian | Kentucky | 21047 | 183 | 3 |
272346 | 272346 | 2020-06-25 | Christian | Kentucky | 21047 | 225 | 4 |
275489 | 275489 | 2020-06-26 | Christian | Kentucky | 21047 | 226 | 4 |
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);