ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
780 rows where fips = 1019 and state = "Alabama" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
293392 | 293392 | 2020-07-02 | Cherokee | Alabama | 1019 | 82 | 7 |
290239 | 290239 | 2020-07-01 | Cherokee | Alabama | 1019 | 77 | 7 |
287089 | 287089 | 2020-06-30 | Cherokee | Alabama | 1019 | 74 | 7 |
283943 | 283943 | 2020-06-29 | Cherokee | Alabama | 1019 | 73 | 7 |
280797 | 280797 | 2020-06-28 | Cherokee | Alabama | 1019 | 70 | 7 |
277649 | 277649 | 2020-06-27 | Cherokee | Alabama | 1019 | 69 | 7 |
274501 | 274501 | 2020-06-26 | Cherokee | Alabama | 1019 | 68 | 7 |
271361 | 271361 | 2020-06-25 | Cherokee | Alabama | 1019 | 64 | 7 |
268227 | 268227 | 2020-06-24 | Cherokee | Alabama | 1019 | 58 | 7 |
265098 | 265098 | 2020-06-23 | Cherokee | Alabama | 1019 | 58 | 7 |
261969 | 261969 | 2020-06-22 | Cherokee | Alabama | 1019 | 58 | 6 |
258842 | 258842 | 2020-06-21 | Cherokee | Alabama | 1019 | 58 | 6 |
255715 | 255715 | 2020-06-20 | Cherokee | Alabama | 1019 | 58 | 6 |
252596 | 252596 | 2020-06-19 | Cherokee | Alabama | 1019 | 58 | 6 |
249481 | 249481 | 2020-06-18 | Cherokee | Alabama | 1019 | 55 | 5 |
246369 | 246369 | 2020-06-17 | Cherokee | Alabama | 1019 | 53 | 5 |
243256 | 243256 | 2020-06-16 | Cherokee | Alabama | 1019 | 53 | 5 |
240145 | 240145 | 2020-06-15 | Cherokee | Alabama | 1019 | 53 | 5 |
237037 | 237037 | 2020-06-14 | Cherokee | Alabama | 1019 | 53 | 5 |
233930 | 233930 | 2020-06-13 | Cherokee | Alabama | 1019 | 49 | 5 |
230825 | 230825 | 2020-06-12 | Cherokee | Alabama | 1019 | 48 | 5 |
227721 | 227721 | 2020-06-11 | Cherokee | Alabama | 1019 | 44 | 4 |
224620 | 224620 | 2020-06-10 | Cherokee | Alabama | 1019 | 44 | 4 |
221524 | 221524 | 2020-06-09 | Cherokee | Alabama | 1019 | 43 | 4 |
218432 | 218432 | 2020-06-08 | Cherokee | Alabama | 1019 | 43 | 4 |
215342 | 215342 | 2020-06-07 | Cherokee | Alabama | 1019 | 43 | 4 |
212255 | 212255 | 2020-06-06 | Cherokee | Alabama | 1019 | 41 | 4 |
209170 | 209170 | 2020-06-05 | Cherokee | Alabama | 1019 | 39 | 3 |
206088 | 206088 | 2020-06-04 | Cherokee | Alabama | 1019 | 39 | 3 |
203009 | 203009 | 2020-06-03 | Cherokee | Alabama | 1019 | 39 | 3 |
199933 | 199933 | 2020-06-02 | Cherokee | Alabama | 1019 | 39 | 3 |
196860 | 196860 | 2020-06-01 | Cherokee | Alabama | 1019 | 39 | 3 |
193790 | 193790 | 2020-05-31 | Cherokee | Alabama | 1019 | 37 | 3 |
190724 | 190724 | 2020-05-30 | Cherokee | Alabama | 1019 | 37 | 3 |
187660 | 187660 | 2020-05-29 | Cherokee | Alabama | 1019 | 36 | 3 |
184603 | 184603 | 2020-05-28 | Cherokee | Alabama | 1019 | 34 | 2 |
181551 | 181551 | 2020-05-27 | Cherokee | Alabama | 1019 | 33 | 2 |
178507 | 178507 | 2020-05-26 | Cherokee | Alabama | 1019 | 33 | 2 |
175462 | 175462 | 2020-05-25 | Cherokee | Alabama | 1019 | 33 | 2 |
172419 | 172419 | 2020-05-24 | Cherokee | Alabama | 1019 | 33 | 2 |
169378 | 169378 | 2020-05-23 | Cherokee | Alabama | 1019 | 33 | 2 |
166342 | 166342 | 2020-05-22 | Cherokee | Alabama | 1019 | 33 | 2 |
163310 | 163310 | 2020-05-21 | Cherokee | Alabama | 1019 | 31 | 0 |
160282 | 160282 | 2020-05-20 | Cherokee | Alabama | 1019 | 30 | 0 |
157258 | 157258 | 2020-05-19 | Cherokee | Alabama | 1019 | 29 | 0 |
154242 | 154242 | 2020-05-18 | Cherokee | Alabama | 1019 | 28 | 0 |
151230 | 151230 | 2020-05-17 | Cherokee | Alabama | 1019 | 27 | 0 |
148221 | 148221 | 2020-05-16 | Cherokee | Alabama | 1019 | 27 | 0 |
145218 | 145218 | 2020-05-15 | Cherokee | Alabama | 1019 | 26 | 0 |
142219 | 142219 | 2020-05-14 | Cherokee | Alabama | 1019 | 25 | 0 |
139223 | 139223 | 2020-05-13 | Cherokee | Alabama | 1019 | 24 | 0 |
136232 | 136232 | 2020-05-12 | Cherokee | Alabama | 1019 | 24 | 0 |
133242 | 133242 | 2020-05-11 | Cherokee | Alabama | 1019 | 24 | 0 |
130252 | 130252 | 2020-05-10 | Cherokee | Alabama | 1019 | 22 | 0 |
127262 | 127262 | 2020-05-09 | Cherokee | Alabama | 1019 | 22 | 0 |
124277 | 124277 | 2020-05-08 | Cherokee | Alabama | 1019 | 21 | 0 |
121297 | 121297 | 2020-05-07 | Cherokee | Alabama | 1019 | 18 | 0 |
118331 | 118331 | 2020-05-06 | Cherokee | Alabama | 1019 | 18 | 0 |
115372 | 115372 | 2020-05-05 | Cherokee | Alabama | 1019 | 17 | 0 |
112489 | 112489 | 2020-05-04 | Cherokee | Alabama | 1019 | 16 | 0 |
109614 | 109614 | 2020-05-03 | Cherokee | Alabama | 1019 | 16 | 0 |
106745 | 106745 | 2020-05-02 | Cherokee | Alabama | 1019 | 15 | 0 |
103880 | 103880 | 2020-05-01 | Cherokee | Alabama | 1019 | 15 | 0 |
101025 | 101025 | 2020-04-30 | Cherokee | Alabama | 1019 | 15 | 0 |
98175 | 98175 | 2020-04-29 | Cherokee | Alabama | 1019 | 15 | 0 |
95330 | 95330 | 2020-04-28 | Cherokee | Alabama | 1019 | 15 | 0 |
92500 | 92500 | 2020-04-27 | Cherokee | Alabama | 1019 | 14 | 0 |
89682 | 89682 | 2020-04-26 | Cherokee | Alabama | 1019 | 14 | 0 |
86866 | 86866 | 2020-04-25 | Cherokee | Alabama | 1019 | 12 | 0 |
84058 | 84058 | 2020-04-24 | Cherokee | Alabama | 1019 | 12 | 0 |
81257 | 81257 | 2020-04-23 | Cherokee | Alabama | 1019 | 12 | 0 |
78464 | 78464 | 2020-04-22 | Cherokee | Alabama | 1019 | 13 | 0 |
75681 | 75681 | 2020-04-21 | Cherokee | Alabama | 1019 | 13 | 0 |
72905 | 72905 | 2020-04-20 | Cherokee | Alabama | 1019 | 12 | 0 |
70136 | 70136 | 2020-04-19 | Cherokee | Alabama | 1019 | 12 | 0 |
67374 | 67374 | 2020-04-18 | Cherokee | Alabama | 1019 | 12 | 0 |
64626 | 64626 | 2020-04-17 | Cherokee | Alabama | 1019 | 12 | 0 |
61893 | 61893 | 2020-04-16 | Cherokee | Alabama | 1019 | 11 | 0 |
59175 | 59175 | 2020-04-15 | Cherokee | Alabama | 1019 | 10 | 0 |
56467 | 56467 | 2020-04-14 | Cherokee | Alabama | 1019 | 9 | 0 |
53775 | 53775 | 2020-04-13 | Cherokee | Alabama | 1019 | 9 | 0 |
51097 | 51097 | 2020-04-12 | Cherokee | Alabama | 1019 | 9 | 0 |
48436 | 48436 | 2020-04-11 | Cherokee | Alabama | 1019 | 7 | 0 |
45807 | 45807 | 2020-04-10 | Cherokee | Alabama | 1019 | 7 | 0 |
43209 | 43209 | 2020-04-09 | Cherokee | Alabama | 1019 | 7 | 0 |
40636 | 40636 | 2020-04-08 | Cherokee | Alabama | 1019 | 7 | 0 |
38094 | 38094 | 2020-04-07 | Cherokee | Alabama | 1019 | 6 | 0 |
35606 | 35606 | 2020-04-06 | Cherokee | Alabama | 1019 | 6 | 0 |
33167 | 33167 | 2020-04-05 | Cherokee | Alabama | 1019 | 6 | 0 |
30763 | 30763 | 2020-04-04 | Cherokee | Alabama | 1019 | 6 | 0 |
28406 | 28406 | 2020-04-03 | Cherokee | Alabama | 1019 | 5 | 0 |
26110 | 26110 | 2020-04-02 | Cherokee | Alabama | 1019 | 4 | 0 |
23889 | 23889 | 2020-04-01 | Cherokee | Alabama | 1019 | 2 | 0 |
21736 | 21736 | 2020-03-31 | Cherokee | Alabama | 1019 | 2 | 0 |
19664 | 19664 | 2020-03-30 | Cherokee | Alabama | 1019 | 2 | 0 |
17694 | 17694 | 2020-03-29 | Cherokee | Alabama | 1019 | 2 | 0 |
15811 | 15811 | 2020-03-28 | Cherokee | Alabama | 1019 | 1 | 0 |
14033 | 14033 | 2020-03-27 | Cherokee | Alabama | 1019 | 1 | 0 |
12375 | 12375 | 2020-03-26 | Cherokee | Alabama | 1019 | 1 | 0 |
10842 | 10842 | 2020-03-25 | Cherokee | Alabama | 1019 | 1 | 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);