ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
775 rows where county = "Fayette" and fips = 1057 sorted by deaths
This data as json, yaml, Notebook, copyable, CSV (advanced)
date (date) >30 ✖
- 2020-03-30 1
- 2020-03-31 1
- 2020-04-01 1
- 2020-04-02 1
- 2020-04-03 1
- 2020-04-04 1
- 2020-04-05 1
- 2020-04-06 1
- 2020-04-07 1
- 2020-04-08 1
- 2020-04-09 1
- 2020-04-10 1
- 2020-04-11 1
- 2020-04-12 1
- 2020-04-13 1
- 2020-04-14 1
- 2020-04-15 1
- 2020-04-16 1
- 2020-04-17 1
- 2020-04-18 1
- 2020-04-19 1
- 2020-04-20 1
- 2020-04-21 1
- 2020-04-22 1
- 2020-04-23 1
- 2020-04-24 1
- 2020-04-25 1
- 2020-04-26 1
- 2020-04-27 1
- 2020-04-28 1
- …
state 1
- Alabama 775
fips 1
- 1057 · 775 ✖
county 1
- Fayette · 775 ✖
Link | rowid | date | county | state | fips | cases | deaths ▼ |
---|---|---|---|---|---|---|---|
19679 | 19679 | 2020-03-30 | Fayette | Alabama | 1057 | 1 | 0 |
21751 | 21751 | 2020-03-31 | Fayette | Alabama | 1057 | 1 | 0 |
23907 | 23907 | 2020-04-01 | Fayette | Alabama | 1057 | 1 | 0 |
26129 | 26129 | 2020-04-02 | Fayette | Alabama | 1057 | 1 | 0 |
28425 | 28425 | 2020-04-03 | Fayette | Alabama | 1057 | 1 | 0 |
30782 | 30782 | 2020-04-04 | Fayette | Alabama | 1057 | 1 | 0 |
33186 | 33186 | 2020-04-05 | Fayette | Alabama | 1057 | 1 | 0 |
35625 | 35625 | 2020-04-06 | Fayette | Alabama | 1057 | 1 | 0 |
38113 | 38113 | 2020-04-07 | Fayette | Alabama | 1057 | 1 | 0 |
40655 | 40655 | 2020-04-08 | Fayette | Alabama | 1057 | 1 | 0 |
43228 | 43228 | 2020-04-09 | Fayette | Alabama | 1057 | 1 | 0 |
45826 | 45826 | 2020-04-10 | Fayette | Alabama | 1057 | 2 | 0 |
48455 | 48455 | 2020-04-11 | Fayette | Alabama | 1057 | 3 | 0 |
51116 | 51116 | 2020-04-12 | Fayette | Alabama | 1057 | 4 | 0 |
53794 | 53794 | 2020-04-13 | Fayette | Alabama | 1057 | 4 | 0 |
56486 | 56486 | 2020-04-14 | Fayette | Alabama | 1057 | 4 | 0 |
59194 | 59194 | 2020-04-15 | Fayette | Alabama | 1057 | 4 | 0 |
61912 | 61912 | 2020-04-16 | Fayette | Alabama | 1057 | 4 | 0 |
64645 | 64645 | 2020-04-17 | Fayette | Alabama | 1057 | 4 | 0 |
67393 | 67393 | 2020-04-18 | Fayette | Alabama | 1057 | 4 | 0 |
70155 | 70155 | 2020-04-19 | Fayette | Alabama | 1057 | 4 | 0 |
72924 | 72924 | 2020-04-20 | Fayette | Alabama | 1057 | 3 | 0 |
75700 | 75700 | 2020-04-21 | Fayette | Alabama | 1057 | 4 | 0 |
78483 | 78483 | 2020-04-22 | Fayette | Alabama | 1057 | 4 | 0 |
81276 | 81276 | 2020-04-23 | Fayette | Alabama | 1057 | 4 | 0 |
84077 | 84077 | 2020-04-24 | Fayette | Alabama | 1057 | 4 | 0 |
86885 | 86885 | 2020-04-25 | Fayette | Alabama | 1057 | 5 | 0 |
89701 | 89701 | 2020-04-26 | Fayette | Alabama | 1057 | 5 | 0 |
92519 | 92519 | 2020-04-27 | Fayette | Alabama | 1057 | 5 | 0 |
95349 | 95349 | 2020-04-28 | Fayette | Alabama | 1057 | 5 | 0 |
98194 | 98194 | 2020-04-29 | Fayette | Alabama | 1057 | 6 | 0 |
101044 | 101044 | 2020-04-30 | Fayette | Alabama | 1057 | 6 | 0 |
103899 | 103899 | 2020-05-01 | Fayette | Alabama | 1057 | 6 | 0 |
106764 | 106764 | 2020-05-02 | Fayette | Alabama | 1057 | 6 | 0 |
109633 | 109633 | 2020-05-03 | Fayette | Alabama | 1057 | 6 | 0 |
112508 | 112508 | 2020-05-04 | Fayette | Alabama | 1057 | 6 | 0 |
115391 | 115391 | 2020-05-05 | Fayette | Alabama | 1057 | 6 | 0 |
118350 | 118350 | 2020-05-06 | Fayette | Alabama | 1057 | 6 | 0 |
121316 | 121316 | 2020-05-07 | Fayette | Alabama | 1057 | 7 | 0 |
124296 | 124296 | 2020-05-08 | Fayette | Alabama | 1057 | 7 | 0 |
127281 | 127281 | 2020-05-09 | Fayette | Alabama | 1057 | 7 | 0 |
130271 | 130271 | 2020-05-10 | Fayette | Alabama | 1057 | 7 | 0 |
133261 | 133261 | 2020-05-11 | Fayette | Alabama | 1057 | 7 | 0 |
136251 | 136251 | 2020-05-12 | Fayette | Alabama | 1057 | 9 | 0 |
139242 | 139242 | 2020-05-13 | Fayette | Alabama | 1057 | 9 | 0 |
142238 | 142238 | 2020-05-14 | Fayette | Alabama | 1057 | 10 | 0 |
145237 | 145237 | 2020-05-15 | Fayette | Alabama | 1057 | 9 | 0 |
148240 | 148240 | 2020-05-16 | Fayette | Alabama | 1057 | 9 | 0 |
151249 | 151249 | 2020-05-17 | Fayette | Alabama | 1057 | 9 | 0 |
154261 | 154261 | 2020-05-18 | Fayette | Alabama | 1057 | 9 | 0 |
157277 | 157277 | 2020-05-19 | Fayette | Alabama | 1057 | 9 | 0 |
160301 | 160301 | 2020-05-20 | Fayette | Alabama | 1057 | 9 | 0 |
163329 | 163329 | 2020-05-21 | Fayette | Alabama | 1057 | 10 | 0 |
166361 | 166361 | 2020-05-22 | Fayette | Alabama | 1057 | 11 | 0 |
169397 | 169397 | 2020-05-23 | Fayette | Alabama | 1057 | 11 | 0 |
172438 | 172438 | 2020-05-24 | Fayette | Alabama | 1057 | 11 | 0 |
175481 | 175481 | 2020-05-25 | Fayette | Alabama | 1057 | 11 | 0 |
178526 | 178526 | 2020-05-26 | Fayette | Alabama | 1057 | 13 | 0 |
181570 | 181570 | 2020-05-27 | Fayette | Alabama | 1057 | 13 | 0 |
184622 | 184622 | 2020-05-28 | Fayette | Alabama | 1057 | 13 | 0 |
187679 | 187679 | 2020-05-29 | Fayette | Alabama | 1057 | 13 | 0 |
190743 | 190743 | 2020-05-30 | Fayette | Alabama | 1057 | 15 | 0 |
193809 | 193809 | 2020-05-31 | Fayette | Alabama | 1057 | 16 | 0 |
196879 | 196879 | 2020-06-01 | Fayette | Alabama | 1057 | 18 | 0 |
199952 | 199952 | 2020-06-02 | Fayette | Alabama | 1057 | 18 | 0 |
203028 | 203028 | 2020-06-03 | Fayette | Alabama | 1057 | 18 | 0 |
206107 | 206107 | 2020-06-04 | Fayette | Alabama | 1057 | 18 | 0 |
209189 | 209189 | 2020-06-05 | Fayette | Alabama | 1057 | 18 | 0 |
212274 | 212274 | 2020-06-06 | Fayette | Alabama | 1057 | 19 | 0 |
215361 | 215361 | 2020-06-07 | Fayette | Alabama | 1057 | 20 | 0 |
218451 | 218451 | 2020-06-08 | Fayette | Alabama | 1057 | 21 | 0 |
221543 | 221543 | 2020-06-09 | Fayette | Alabama | 1057 | 23 | 0 |
224639 | 224639 | 2020-06-10 | Fayette | Alabama | 1057 | 26 | 0 |
227740 | 227740 | 2020-06-11 | Fayette | Alabama | 1057 | 26 | 0 |
230844 | 230844 | 2020-06-12 | Fayette | Alabama | 1057 | 29 | 0 |
233949 | 233949 | 2020-06-13 | Fayette | Alabama | 1057 | 40 | 0 |
237056 | 237056 | 2020-06-14 | Fayette | Alabama | 1057 | 46 | 0 |
240164 | 240164 | 2020-06-15 | Fayette | Alabama | 1057 | 48 | 0 |
243275 | 243275 | 2020-06-16 | Fayette | Alabama | 1057 | 50 | 0 |
246388 | 246388 | 2020-06-17 | Fayette | Alabama | 1057 | 52 | 0 |
249500 | 249500 | 2020-06-18 | Fayette | Alabama | 1057 | 52 | 1 |
252615 | 252615 | 2020-06-19 | Fayette | Alabama | 1057 | 60 | 1 |
255734 | 255734 | 2020-06-20 | Fayette | Alabama | 1057 | 61 | 1 |
258861 | 258861 | 2020-06-21 | Fayette | Alabama | 1057 | 61 | 1 |
261988 | 261988 | 2020-06-22 | Fayette | Alabama | 1057 | 61 | 1 |
265117 | 265117 | 2020-06-23 | Fayette | Alabama | 1057 | 62 | 1 |
268246 | 268246 | 2020-06-24 | Fayette | Alabama | 1057 | 63 | 1 |
271380 | 271380 | 2020-06-25 | Fayette | Alabama | 1057 | 65 | 1 |
274520 | 274520 | 2020-06-26 | Fayette | Alabama | 1057 | 67 | 1 |
277668 | 277668 | 2020-06-27 | Fayette | Alabama | 1057 | 68 | 1 |
280816 | 280816 | 2020-06-28 | Fayette | Alabama | 1057 | 69 | 1 |
283962 | 283962 | 2020-06-29 | Fayette | Alabama | 1057 | 69 | 1 |
287108 | 287108 | 2020-06-30 | Fayette | Alabama | 1057 | 69 | 1 |
290258 | 290258 | 2020-07-01 | Fayette | Alabama | 1057 | 70 | 1 |
293411 | 293411 | 2020-07-02 | Fayette | Alabama | 1057 | 70 | 1 |
296566 | 296566 | 2020-07-03 | Fayette | Alabama | 1057 | 70 | 1 |
299728 | 299728 | 2020-07-04 | Fayette | Alabama | 1057 | 71 | 1 |
302892 | 302892 | 2020-07-05 | Fayette | Alabama | 1057 | 73 | 1 |
306056 | 306056 | 2020-07-06 | Fayette | Alabama | 1057 | 74 | 1 |
309225 | 309225 | 2020-07-07 | Fayette | Alabama | 1057 | 75 | 1 |
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);