ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
775 rows where county = "Fayette" and state = "Alabama" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
382750 | 382750 | 2020-07-30 | Fayette | Alabama | 1057 | 170 | 5 |
379533 | 379533 | 2020-07-29 | Fayette | Alabama | 1057 | 163 | 5 |
376317 | 376317 | 2020-07-28 | Fayette | Alabama | 1057 | 158 | 5 |
373103 | 373103 | 2020-07-27 | Fayette | Alabama | 1057 | 151 | 5 |
369891 | 369891 | 2020-07-26 | Fayette | Alabama | 1057 | 144 | 5 |
366681 | 366681 | 2020-07-25 | Fayette | Alabama | 1057 | 139 | 5 |
363474 | 363474 | 2020-07-24 | Fayette | Alabama | 1057 | 137 | 5 |
360268 | 360268 | 2020-07-23 | Fayette | Alabama | 1057 | 133 | 5 |
357063 | 357063 | 2020-07-22 | Fayette | Alabama | 1057 | 129 | 5 |
353860 | 353860 | 2020-07-21 | Fayette | Alabama | 1057 | 127 | 5 |
350658 | 350658 | 2020-07-20 | Fayette | Alabama | 1057 | 125 | 5 |
347457 | 347457 | 2020-07-19 | Fayette | Alabama | 1057 | 123 | 5 |
344257 | 344257 | 2020-07-18 | Fayette | Alabama | 1057 | 121 | 5 |
341058 | 341058 | 2020-07-17 | Fayette | Alabama | 1057 | 115 | 3 |
337862 | 337862 | 2020-07-16 | Fayette | Alabama | 1057 | 108 | 3 |
334667 | 334667 | 2020-07-15 | Fayette | Alabama | 1057 | 96 | 3 |
331474 | 331474 | 2020-07-14 | Fayette | Alabama | 1057 | 93 | 2 |
328288 | 328288 | 2020-07-13 | Fayette | Alabama | 1057 | 93 | 1 |
325102 | 325102 | 2020-07-12 | Fayette | Alabama | 1057 | 88 | 1 |
321921 | 321921 | 2020-07-11 | Fayette | Alabama | 1057 | 85 | 1 |
318742 | 318742 | 2020-07-10 | Fayette | Alabama | 1057 | 84 | 1 |
315569 | 315569 | 2020-07-09 | Fayette | Alabama | 1057 | 81 | 1 |
312394 | 312394 | 2020-07-08 | Fayette | Alabama | 1057 | 75 | 1 |
309225 | 309225 | 2020-07-07 | Fayette | Alabama | 1057 | 75 | 1 |
306056 | 306056 | 2020-07-06 | Fayette | Alabama | 1057 | 74 | 1 |
302892 | 302892 | 2020-07-05 | Fayette | Alabama | 1057 | 73 | 1 |
299728 | 299728 | 2020-07-04 | Fayette | Alabama | 1057 | 71 | 1 |
296566 | 296566 | 2020-07-03 | Fayette | Alabama | 1057 | 70 | 1 |
293411 | 293411 | 2020-07-02 | Fayette | Alabama | 1057 | 70 | 1 |
290258 | 290258 | 2020-07-01 | Fayette | Alabama | 1057 | 70 | 1 |
287108 | 287108 | 2020-06-30 | Fayette | Alabama | 1057 | 69 | 1 |
283962 | 283962 | 2020-06-29 | Fayette | Alabama | 1057 | 69 | 1 |
280816 | 280816 | 2020-06-28 | Fayette | Alabama | 1057 | 69 | 1 |
277668 | 277668 | 2020-06-27 | Fayette | Alabama | 1057 | 68 | 1 |
274520 | 274520 | 2020-06-26 | Fayette | Alabama | 1057 | 67 | 1 |
271380 | 271380 | 2020-06-25 | Fayette | Alabama | 1057 | 65 | 1 |
268246 | 268246 | 2020-06-24 | Fayette | Alabama | 1057 | 63 | 1 |
265117 | 265117 | 2020-06-23 | Fayette | Alabama | 1057 | 62 | 1 |
261988 | 261988 | 2020-06-22 | Fayette | Alabama | 1057 | 61 | 1 |
258861 | 258861 | 2020-06-21 | Fayette | Alabama | 1057 | 61 | 1 |
255734 | 255734 | 2020-06-20 | Fayette | Alabama | 1057 | 61 | 1 |
252615 | 252615 | 2020-06-19 | Fayette | Alabama | 1057 | 60 | 1 |
249500 | 249500 | 2020-06-18 | Fayette | Alabama | 1057 | 52 | 1 |
246388 | 246388 | 2020-06-17 | Fayette | Alabama | 1057 | 52 | 0 |
243275 | 243275 | 2020-06-16 | Fayette | Alabama | 1057 | 50 | 0 |
240164 | 240164 | 2020-06-15 | Fayette | Alabama | 1057 | 48 | 0 |
237056 | 237056 | 2020-06-14 | Fayette | Alabama | 1057 | 46 | 0 |
233949 | 233949 | 2020-06-13 | Fayette | Alabama | 1057 | 40 | 0 |
230844 | 230844 | 2020-06-12 | Fayette | Alabama | 1057 | 29 | 0 |
227740 | 227740 | 2020-06-11 | Fayette | Alabama | 1057 | 26 | 0 |
224639 | 224639 | 2020-06-10 | Fayette | Alabama | 1057 | 26 | 0 |
221543 | 221543 | 2020-06-09 | Fayette | Alabama | 1057 | 23 | 0 |
218451 | 218451 | 2020-06-08 | Fayette | Alabama | 1057 | 21 | 0 |
215361 | 215361 | 2020-06-07 | Fayette | Alabama | 1057 | 20 | 0 |
212274 | 212274 | 2020-06-06 | Fayette | Alabama | 1057 | 19 | 0 |
209189 | 209189 | 2020-06-05 | Fayette | Alabama | 1057 | 18 | 0 |
206107 | 206107 | 2020-06-04 | Fayette | Alabama | 1057 | 18 | 0 |
203028 | 203028 | 2020-06-03 | Fayette | Alabama | 1057 | 18 | 0 |
199952 | 199952 | 2020-06-02 | Fayette | Alabama | 1057 | 18 | 0 |
196879 | 196879 | 2020-06-01 | Fayette | Alabama | 1057 | 18 | 0 |
193809 | 193809 | 2020-05-31 | Fayette | Alabama | 1057 | 16 | 0 |
190743 | 190743 | 2020-05-30 | Fayette | Alabama | 1057 | 15 | 0 |
187679 | 187679 | 2020-05-29 | Fayette | Alabama | 1057 | 13 | 0 |
184622 | 184622 | 2020-05-28 | Fayette | Alabama | 1057 | 13 | 0 |
181570 | 181570 | 2020-05-27 | Fayette | Alabama | 1057 | 13 | 0 |
178526 | 178526 | 2020-05-26 | Fayette | Alabama | 1057 | 13 | 0 |
175481 | 175481 | 2020-05-25 | Fayette | Alabama | 1057 | 11 | 0 |
172438 | 172438 | 2020-05-24 | Fayette | Alabama | 1057 | 11 | 0 |
169397 | 169397 | 2020-05-23 | Fayette | Alabama | 1057 | 11 | 0 |
166361 | 166361 | 2020-05-22 | Fayette | Alabama | 1057 | 11 | 0 |
163329 | 163329 | 2020-05-21 | Fayette | Alabama | 1057 | 10 | 0 |
160301 | 160301 | 2020-05-20 | Fayette | Alabama | 1057 | 9 | 0 |
157277 | 157277 | 2020-05-19 | Fayette | Alabama | 1057 | 9 | 0 |
154261 | 154261 | 2020-05-18 | Fayette | Alabama | 1057 | 9 | 0 |
151249 | 151249 | 2020-05-17 | Fayette | Alabama | 1057 | 9 | 0 |
148240 | 148240 | 2020-05-16 | Fayette | Alabama | 1057 | 9 | 0 |
145237 | 145237 | 2020-05-15 | Fayette | Alabama | 1057 | 9 | 0 |
142238 | 142238 | 2020-05-14 | Fayette | Alabama | 1057 | 10 | 0 |
139242 | 139242 | 2020-05-13 | Fayette | Alabama | 1057 | 9 | 0 |
136251 | 136251 | 2020-05-12 | Fayette | Alabama | 1057 | 9 | 0 |
133261 | 133261 | 2020-05-11 | Fayette | Alabama | 1057 | 7 | 0 |
130271 | 130271 | 2020-05-10 | Fayette | Alabama | 1057 | 7 | 0 |
127281 | 127281 | 2020-05-09 | Fayette | Alabama | 1057 | 7 | 0 |
124296 | 124296 | 2020-05-08 | Fayette | Alabama | 1057 | 7 | 0 |
121316 | 121316 | 2020-05-07 | Fayette | Alabama | 1057 | 7 | 0 |
118350 | 118350 | 2020-05-06 | Fayette | Alabama | 1057 | 6 | 0 |
115391 | 115391 | 2020-05-05 | Fayette | Alabama | 1057 | 6 | 0 |
112508 | 112508 | 2020-05-04 | Fayette | Alabama | 1057 | 6 | 0 |
109633 | 109633 | 2020-05-03 | Fayette | Alabama | 1057 | 6 | 0 |
106764 | 106764 | 2020-05-02 | Fayette | Alabama | 1057 | 6 | 0 |
103899 | 103899 | 2020-05-01 | Fayette | Alabama | 1057 | 6 | 0 |
101044 | 101044 | 2020-04-30 | Fayette | Alabama | 1057 | 6 | 0 |
98194 | 98194 | 2020-04-29 | Fayette | Alabama | 1057 | 6 | 0 |
95349 | 95349 | 2020-04-28 | Fayette | Alabama | 1057 | 5 | 0 |
92519 | 92519 | 2020-04-27 | Fayette | Alabama | 1057 | 5 | 0 |
89701 | 89701 | 2020-04-26 | Fayette | Alabama | 1057 | 5 | 0 |
86885 | 86885 | 2020-04-25 | Fayette | Alabama | 1057 | 5 | 0 |
84077 | 84077 | 2020-04-24 | Fayette | Alabama | 1057 | 4 | 0 |
81276 | 81276 | 2020-04-23 | Fayette | Alabama | 1057 | 4 | 0 |
78483 | 78483 | 2020-04-22 | Fayette | Alabama | 1057 | 4 | 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);