ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
787 rows where county = "Warren" and state = "Kentucky" sorted by deaths
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date | county | state | fips | cases | deaths ▼ |
---|---|---|---|---|---|---|---|
3991 | 3991 | 2020-03-18 | Warren | Kentucky | 21227 | 1 | 0 |
4682 | 4682 | 2020-03-19 | Warren | Kentucky | 21227 | 1 | 0 |
5496 | 5496 | 2020-03-20 | Warren | Kentucky | 21227 | 2 | 0 |
6444 | 6444 | 2020-03-21 | Warren | Kentucky | 21227 | 4 | 0 |
7518 | 7518 | 2020-03-22 | Warren | Kentucky | 21227 | 5 | 0 |
8681 | 8681 | 2020-03-23 | Warren | Kentucky | 21227 | 6 | 0 |
9969 | 9969 | 2020-03-24 | Warren | Kentucky | 21227 | 6 | 0 |
11372 | 11372 | 2020-03-25 | Warren | Kentucky | 21227 | 7 | 0 |
12946 | 12946 | 2020-03-26 | Warren | Kentucky | 21227 | 7 | 0 |
14652 | 14652 | 2020-03-27 | Warren | Kentucky | 21227 | 8 | 0 |
16469 | 16469 | 2020-03-28 | Warren | Kentucky | 21227 | 10 | 0 |
18381 | 18381 | 2020-03-29 | Warren | Kentucky | 21227 | 10 | 0 |
20397 | 20397 | 2020-03-30 | Warren | Kentucky | 21227 | 11 | 0 |
22504 | 22504 | 2020-03-31 | Warren | Kentucky | 21227 | 13 | 0 |
24680 | 24680 | 2020-04-01 | Warren | Kentucky | 21227 | 17 | 0 |
26930 | 26930 | 2020-04-02 | Warren | Kentucky | 21227 | 18 | 0 |
29247 | 29247 | 2020-04-03 | Warren | Kentucky | 21227 | 18 | 0 |
31625 | 31625 | 2020-04-04 | Warren | Kentucky | 21227 | 19 | 0 |
34050 | 34050 | 2020-04-05 | Warren | Kentucky | 21227 | 20 | 0 |
36508 | 36508 | 2020-04-06 | Warren | Kentucky | 21227 | 20 | 0 |
39015 | 39015 | 2020-04-07 | Warren | Kentucky | 21227 | 32 | 0 |
41566 | 41566 | 2020-04-08 | Warren | Kentucky | 21227 | 32 | 0 |
44142 | 44142 | 2020-04-09 | Warren | Kentucky | 21227 | 35 | 0 |
46750 | 46750 | 2020-04-10 | Warren | Kentucky | 21227 | 35 | 0 |
49391 | 49391 | 2020-04-11 | Warren | Kentucky | 21227 | 49 | 0 |
52061 | 52061 | 2020-04-12 | Warren | Kentucky | 21227 | 46 | 0 |
54742 | 54742 | 2020-04-13 | Warren | Kentucky | 21227 | 47 | 0 |
57440 | 57440 | 2020-04-14 | Warren | Kentucky | 21227 | 52 | 0 |
60148 | 60148 | 2020-04-15 | Warren | Kentucky | 21227 | 64 | 0 |
62869 | 62869 | 2020-04-16 | Warren | Kentucky | 21227 | 71 | 0 |
65608 | 65608 | 2020-04-17 | Warren | Kentucky | 21227 | 82 | 0 |
68357 | 68357 | 2020-04-18 | Warren | Kentucky | 21227 | 87 | 0 |
71120 | 71120 | 2020-04-19 | Warren | Kentucky | 21227 | 95 | 0 |
73892 | 73892 | 2020-04-20 | Warren | Kentucky | 21227 | 101 | 0 |
76672 | 76672 | 2020-04-21 | Warren | Kentucky | 21227 | 132 | 0 |
79458 | 79458 | 2020-04-22 | Warren | Kentucky | 21227 | 132 | 0 |
82254 | 82254 | 2020-04-23 | Warren | Kentucky | 21227 | 184 | 0 |
85058 | 85058 | 2020-04-24 | Warren | Kentucky | 21227 | 184 | 0 |
87867 | 87867 | 2020-04-25 | Warren | Kentucky | 21227 | 184 | 0 |
90683 | 90683 | 2020-04-26 | Warren | Kentucky | 21227 | 219 | 0 |
93504 | 93504 | 2020-04-27 | Warren | Kentucky | 21227 | 234 | 0 |
96339 | 96339 | 2020-04-28 | Warren | Kentucky | 21227 | 263 | 0 |
99185 | 99185 | 2020-04-29 | Warren | Kentucky | 21227 | 313 | 1 |
102037 | 102037 | 2020-04-30 | Warren | Kentucky | 21227 | 332 | 1 |
104898 | 104898 | 2020-05-01 | Warren | Kentucky | 21227 | 344 | 1 |
107762 | 107762 | 2020-05-02 | Warren | Kentucky | 21227 | 352 | 1 |
110634 | 110634 | 2020-05-03 | Warren | Kentucky | 21227 | 369 | 1 |
113511 | 113511 | 2020-05-04 | Warren | Kentucky | 21227 | 400 | 1 |
116393 | 116393 | 2020-05-05 | Warren | Kentucky | 21227 | 426 | 1 |
119354 | 119354 | 2020-05-06 | Warren | Kentucky | 21227 | 447 | 1 |
122325 | 122325 | 2020-05-07 | Warren | Kentucky | 21227 | 492 | 2 |
125307 | 125307 | 2020-05-08 | Warren | Kentucky | 21227 | 512 | 2 |
128294 | 128294 | 2020-05-09 | Warren | Kentucky | 21227 | 530 | 2 |
131284 | 131284 | 2020-05-10 | Warren | Kentucky | 21227 | 530 | 2 |
134275 | 134275 | 2020-05-11 | Warren | Kentucky | 21227 | 573 | 2 |
137265 | 137265 | 2020-05-12 | Warren | Kentucky | 21227 | 637 | 2 |
140259 | 140259 | 2020-05-13 | Warren | Kentucky | 21227 | 637 | 2 |
143254 | 143254 | 2020-05-14 | Warren | Kentucky | 21227 | 730 | 2 |
146254 | 146254 | 2020-05-15 | Warren | Kentucky | 21227 | 751 | 2 |
149259 | 149259 | 2020-05-16 | Warren | Kentucky | 21227 | 776 | 2 |
152270 | 152270 | 2020-05-17 | Warren | Kentucky | 21227 | 776 | 2 |
155284 | 155284 | 2020-05-18 | Warren | Kentucky | 21227 | 810 | 3 |
158301 | 158301 | 2020-05-19 | Warren | Kentucky | 21227 | 828 | 3 |
161327 | 161327 | 2020-05-20 | Warren | Kentucky | 21227 | 863 | 3 |
164356 | 164356 | 2020-05-21 | Warren | Kentucky | 21227 | 879 | 5 |
167392 | 167392 | 2020-05-22 | Warren | Kentucky | 21227 | 917 | 5 |
170430 | 170430 | 2020-05-23 | Warren | Kentucky | 21227 | 920 | 5 |
173471 | 173471 | 2020-05-24 | Warren | Kentucky | 21227 | 920 | 5 |
176515 | 176515 | 2020-05-25 | Warren | Kentucky | 21227 | 920 | 5 |
179559 | 179559 | 2020-05-26 | Warren | Kentucky | 21227 | 950 | 5 |
182604 | 182604 | 2020-05-27 | Warren | Kentucky | 21227 | 950 | 5 |
185659 | 185659 | 2020-05-28 | Warren | Kentucky | 21227 | 989 | 6 |
188717 | 188717 | 2020-05-29 | Warren | Kentucky | 21227 | 1000 | 6 |
191781 | 191781 | 2020-05-30 | Warren | Kentucky | 21227 | 1007 | 6 |
194849 | 194849 | 2020-05-31 | Warren | Kentucky | 21227 | 1007 | 6 |
197920 | 197920 | 2020-06-01 | Warren | Kentucky | 21227 | 1044 | 6 |
200992 | 200992 | 2020-06-02 | Warren | Kentucky | 21227 | 1063 | 7 |
204069 | 204069 | 2020-06-03 | Warren | Kentucky | 21227 | 1079 | 7 |
207150 | 207150 | 2020-06-04 | Warren | Kentucky | 21227 | 1093 | 7 |
210231 | 210231 | 2020-06-05 | Warren | Kentucky | 21227 | 1105 | 7 |
213316 | 213316 | 2020-06-06 | Warren | Kentucky | 21227 | 1112 | 7 |
216403 | 216403 | 2020-06-07 | Warren | Kentucky | 21227 | 1112 | 7 |
219495 | 219495 | 2020-06-08 | Warren | Kentucky | 21227 | 1142 | 7 |
222590 | 222590 | 2020-06-09 | Warren | Kentucky | 21227 | 1174 | 8 |
225686 | 225686 | 2020-06-10 | Warren | Kentucky | 21227 | 1179 | 8 |
228788 | 228788 | 2020-06-11 | Warren | Kentucky | 21227 | 1192 | 8 |
231892 | 231892 | 2020-06-12 | Warren | Kentucky | 21227 | 1220 | 8 |
234997 | 234997 | 2020-06-13 | Warren | Kentucky | 21227 | 1248 | 8 |
238104 | 238104 | 2020-06-14 | Warren | Kentucky | 21227 | 1248 | 8 |
241213 | 241213 | 2020-06-15 | Warren | Kentucky | 21227 | 1275 | 10 |
244324 | 244324 | 2020-06-16 | Warren | Kentucky | 21227 | 1279 | 10 |
247437 | 247437 | 2020-06-17 | Warren | Kentucky | 21227 | 1299 | 10 |
250549 | 250549 | 2020-06-18 | Warren | Kentucky | 21227 | 1305 | 10 |
253664 | 253664 | 2020-06-19 | Warren | Kentucky | 21227 | 1323 | 10 |
256784 | 256784 | 2020-06-20 | Warren | Kentucky | 21227 | 1339 | 10 |
259910 | 259910 | 2020-06-21 | Warren | Kentucky | 21227 | 1357 | 10 |
263039 | 263039 | 2020-06-22 | Warren | Kentucky | 21227 | 1361 | 11 |
266166 | 266166 | 2020-06-23 | Warren | Kentucky | 21227 | 1376 | 11 |
269299 | 269299 | 2020-06-24 | Warren | Kentucky | 21227 | 1398 | 11 |
272435 | 272435 | 2020-06-25 | Warren | Kentucky | 21227 | 1426 | 12 |
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);