ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
799 rows where county = "Fayette", fips = 21067 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 ▼ |
---|---|---|---|---|---|---|---|
615 | 615 | 2020-03-06 | Fayette | Kentucky | 21067 | 1 | 0 |
700 | 700 | 2020-03-07 | Fayette | Kentucky | 21067 | 1 | 0 |
799 | 799 | 2020-03-08 | Fayette | Kentucky | 21067 | 2 | 0 |
921 | 921 | 2020-03-09 | Fayette | Kentucky | 21067 | 3 | 0 |
1066 | 1066 | 2020-03-10 | Fayette | Kentucky | 21067 | 3 | 0 |
1244 | 1244 | 2020-03-11 | Fayette | Kentucky | 21067 | 3 | 0 |
1460 | 1460 | 2020-03-12 | Fayette | Kentucky | 21067 | 4 | 0 |
1733 | 1733 | 2020-03-13 | Fayette | Kentucky | 21067 | 4 | 0 |
2069 | 2069 | 2020-03-14 | Fayette | Kentucky | 21067 | 5 | 0 |
2466 | 2466 | 2020-03-15 | Fayette | Kentucky | 21067 | 5 | 0 |
2911 | 2911 | 2020-03-16 | Fayette | Kentucky | 21067 | 5 | 0 |
3406 | 3406 | 2020-03-17 | Fayette | Kentucky | 21067 | 5 | 0 |
3983 | 3983 | 2020-03-18 | Fayette | Kentucky | 21067 | 6 | 0 |
4670 | 4670 | 2020-03-19 | Fayette | Kentucky | 21067 | 7 | 0 |
5484 | 5484 | 2020-03-20 | Fayette | Kentucky | 21067 | 10 | 0 |
6430 | 6430 | 2020-03-21 | Fayette | Kentucky | 21067 | 13 | 0 |
7501 | 7501 | 2020-03-22 | Fayette | Kentucky | 21067 | 14 | 0 |
8663 | 8663 | 2020-03-23 | Fayette | Kentucky | 21067 | 14 | 0 |
9946 | 9946 | 2020-03-24 | Fayette | Kentucky | 21067 | 20 | 0 |
11346 | 11346 | 2020-03-25 | Fayette | Kentucky | 21067 | 24 | 0 |
12916 | 12916 | 2020-03-26 | Fayette | Kentucky | 21067 | 33 | 0 |
14621 | 14621 | 2020-03-27 | Fayette | Kentucky | 21067 | 37 | 1 |
16434 | 16434 | 2020-03-28 | Fayette | Kentucky | 21067 | 60 | 1 |
18344 | 18344 | 2020-03-29 | Fayette | Kentucky | 21067 | 75 | 1 |
20358 | 20358 | 2020-03-30 | Fayette | Kentucky | 21067 | 83 | 1 |
22459 | 22459 | 2020-03-31 | Fayette | Kentucky | 21067 | 106 | 2 |
24635 | 24635 | 2020-04-01 | Fayette | Kentucky | 21067 | 118 | 2 |
33992 | 33992 | 2020-04-05 | Fayette | Kentucky | 21067 | 153 | 6 |
36450 | 36450 | 2020-04-06 | Fayette | Kentucky | 21067 | 153 | 6 |
38955 | 38955 | 2020-04-07 | Fayette | Kentucky | 21067 | 170 | 7 |
41504 | 41504 | 2020-04-08 | Fayette | Kentucky | 21067 | 170 | 7 |
44079 | 44079 | 2020-04-09 | Fayette | Kentucky | 21067 | 174 | 7 |
46687 | 46687 | 2020-04-10 | Fayette | Kentucky | 21067 | 174 | 7 |
49324 | 49324 | 2020-04-11 | Fayette | Kentucky | 21067 | 179 | 7 |
51990 | 51990 | 2020-04-12 | Fayette | Kentucky | 21067 | 194 | 7 |
54671 | 54671 | 2020-04-13 | Fayette | Kentucky | 21067 | 197 | 7 |
57367 | 57367 | 2020-04-14 | Fayette | Kentucky | 21067 | 206 | 7 |
60076 | 60076 | 2020-04-15 | Fayette | Kentucky | 21067 | 212 | 7 |
62796 | 62796 | 2020-04-16 | Fayette | Kentucky | 21067 | 213 | 7 |
65535 | 65535 | 2020-04-17 | Fayette | Kentucky | 21067 | 214 | 7 |
68284 | 68284 | 2020-04-18 | Fayette | Kentucky | 21067 | 218 | 7 |
71046 | 71046 | 2020-04-19 | Fayette | Kentucky | 21067 | 221 | 7 |
73818 | 73818 | 2020-04-20 | Fayette | Kentucky | 21067 | 221 | 7 |
76598 | 76598 | 2020-04-21 | Fayette | Kentucky | 21067 | 222 | 7 |
26882 | 26882 | 2020-04-02 | Fayette | Kentucky | 21067 | 124 | 8 |
29198 | 29198 | 2020-04-03 | Fayette | Kentucky | 21067 | 124 | 8 |
79383 | 79383 | 2020-04-22 | Fayette | Kentucky | 21067 | 223 | 8 |
82180 | 82180 | 2020-04-23 | Fayette | Kentucky | 21067 | 223 | 8 |
84983 | 84983 | 2020-04-24 | Fayette | Kentucky | 21067 | 226 | 8 |
87792 | 87792 | 2020-04-25 | Fayette | Kentucky | 21067 | 235 | 8 |
90608 | 90608 | 2020-04-26 | Fayette | Kentucky | 21067 | 238 | 8 |
31574 | 31574 | 2020-04-04 | Fayette | Kentucky | 21067 | 125 | 9 |
93429 | 93429 | 2020-04-27 | Fayette | Kentucky | 21067 | 239 | 9 |
99108 | 99108 | 2020-04-29 | Fayette | Kentucky | 21067 | 246 | 9 |
101960 | 101960 | 2020-04-30 | Fayette | Kentucky | 21067 | 248 | 9 |
104821 | 104821 | 2020-05-01 | Fayette | Kentucky | 21067 | 254 | 9 |
107686 | 107686 | 2020-05-02 | Fayette | Kentucky | 21067 | 254 | 9 |
110557 | 110557 | 2020-05-03 | Fayette | Kentucky | 21067 | 292 | 9 |
113434 | 113434 | 2020-05-04 | Fayette | Kentucky | 21067 | 295 | 9 |
116316 | 116316 | 2020-05-05 | Fayette | Kentucky | 21067 | 298 | 9 |
119277 | 119277 | 2020-05-06 | Fayette | Kentucky | 21067 | 320 | 9 |
122247 | 122247 | 2020-05-07 | Fayette | Kentucky | 21067 | 336 | 9 |
125229 | 125229 | 2020-05-08 | Fayette | Kentucky | 21067 | 361 | 9 |
128217 | 128217 | 2020-05-09 | Fayette | Kentucky | 21067 | 386 | 9 |
131207 | 131207 | 2020-05-10 | Fayette | Kentucky | 21067 | 389 | 9 |
96262 | 96262 | 2020-04-28 | Fayette | Kentucky | 21067 | 242 | 10 |
134198 | 134198 | 2020-05-11 | Fayette | Kentucky | 21067 | 411 | 10 |
137188 | 137188 | 2020-05-12 | Fayette | Kentucky | 21067 | 426 | 10 |
140181 | 140181 | 2020-05-13 | Fayette | Kentucky | 21067 | 457 | 10 |
143177 | 143177 | 2020-05-14 | Fayette | Kentucky | 21067 | 529 | 10 |
146177 | 146177 | 2020-05-15 | Fayette | Kentucky | 21067 | 532 | 12 |
149181 | 149181 | 2020-05-16 | Fayette | Kentucky | 21067 | 550 | 12 |
152192 | 152192 | 2020-05-17 | Fayette | Kentucky | 21067 | 550 | 12 |
155206 | 155206 | 2020-05-18 | Fayette | Kentucky | 21067 | 564 | 12 |
158223 | 158223 | 2020-05-19 | Fayette | Kentucky | 21067 | 596 | 12 |
161249 | 161249 | 2020-05-20 | Fayette | Kentucky | 21067 | 591 | 12 |
164278 | 164278 | 2020-05-21 | Fayette | Kentucky | 21067 | 596 | 13 |
167314 | 167314 | 2020-05-22 | Fayette | Kentucky | 21067 | 603 | 13 |
170352 | 170352 | 2020-05-23 | Fayette | Kentucky | 21067 | 619 | 13 |
173393 | 173393 | 2020-05-24 | Fayette | Kentucky | 21067 | 619 | 13 |
176437 | 176437 | 2020-05-25 | Fayette | Kentucky | 21067 | 619 | 13 |
179481 | 179481 | 2020-05-26 | Fayette | Kentucky | 21067 | 644 | 13 |
182526 | 182526 | 2020-05-27 | Fayette | Kentucky | 21067 | 650 | 13 |
185580 | 185580 | 2020-05-28 | Fayette | Kentucky | 21067 | 673 | 13 |
188638 | 188638 | 2020-05-29 | Fayette | Kentucky | 21067 | 702 | 13 |
191702 | 191702 | 2020-05-30 | Fayette | Kentucky | 21067 | 714 | 13 |
194770 | 194770 | 2020-05-31 | Fayette | Kentucky | 21067 | 714 | 13 |
197841 | 197841 | 2020-06-01 | Fayette | Kentucky | 21067 | 760 | 13 |
200913 | 200913 | 2020-06-02 | Fayette | Kentucky | 21067 | 781 | 13 |
203990 | 203990 | 2020-06-03 | Fayette | Kentucky | 21067 | 803 | 13 |
207071 | 207071 | 2020-06-04 | Fayette | Kentucky | 21067 | 812 | 13 |
210152 | 210152 | 2020-06-05 | Fayette | Kentucky | 21067 | 847 | 14 |
213237 | 213237 | 2020-06-06 | Fayette | Kentucky | 21067 | 872 | 14 |
216324 | 216324 | 2020-06-07 | Fayette | Kentucky | 21067 | 872 | 14 |
219416 | 219416 | 2020-06-08 | Fayette | Kentucky | 21067 | 928 | 14 |
222511 | 222511 | 2020-06-09 | Fayette | Kentucky | 21067 | 947 | 14 |
225607 | 225607 | 2020-06-10 | Fayette | Kentucky | 21067 | 978 | 14 |
228709 | 228709 | 2020-06-11 | Fayette | Kentucky | 21067 | 1008 | 15 |
231813 | 231813 | 2020-06-12 | Fayette | Kentucky | 21067 | 1041 | 17 |
234918 | 234918 | 2020-06-13 | Fayette | Kentucky | 21067 | 1075 | 17 |
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);