ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
780 rows where fips = 1021 and state = "Alabama" sorted by state
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date | county | state ▼ | fips | cases | deaths |
---|---|---|---|---|---|---|---|
10843 | 10843 | 2020-03-25 | Chilton | Alabama | 1021 | 1 | 0 |
12376 | 12376 | 2020-03-26 | Chilton | Alabama | 1021 | 4 | 0 |
14034 | 14034 | 2020-03-27 | Chilton | Alabama | 1021 | 7 | 0 |
15812 | 15812 | 2020-03-28 | Chilton | Alabama | 1021 | 7 | 0 |
17695 | 17695 | 2020-03-29 | Chilton | Alabama | 1021 | 8 | 0 |
19665 | 19665 | 2020-03-30 | Chilton | Alabama | 1021 | 10 | 0 |
21737 | 21737 | 2020-03-31 | Chilton | Alabama | 1021 | 11 | 0 |
23890 | 23890 | 2020-04-01 | Chilton | Alabama | 1021 | 13 | 0 |
26111 | 26111 | 2020-04-02 | Chilton | Alabama | 1021 | 14 | 0 |
28407 | 28407 | 2020-04-03 | Chilton | Alabama | 1021 | 15 | 0 |
30764 | 30764 | 2020-04-04 | Chilton | Alabama | 1021 | 15 | 0 |
33168 | 33168 | 2020-04-05 | Chilton | Alabama | 1021 | 18 | 0 |
35607 | 35607 | 2020-04-06 | Chilton | Alabama | 1021 | 20 | 0 |
38095 | 38095 | 2020-04-07 | Chilton | Alabama | 1021 | 20 | 0 |
40637 | 40637 | 2020-04-08 | Chilton | Alabama | 1021 | 22 | 0 |
43210 | 43210 | 2020-04-09 | Chilton | Alabama | 1021 | 25 | 0 |
45808 | 45808 | 2020-04-10 | Chilton | Alabama | 1021 | 27 | 0 |
48437 | 48437 | 2020-04-11 | Chilton | Alabama | 1021 | 30 | 0 |
51098 | 51098 | 2020-04-12 | Chilton | Alabama | 1021 | 30 | 0 |
53776 | 53776 | 2020-04-13 | Chilton | Alabama | 1021 | 33 | 0 |
56468 | 56468 | 2020-04-14 | Chilton | Alabama | 1021 | 33 | 0 |
59176 | 59176 | 2020-04-15 | Chilton | Alabama | 1021 | 37 | 0 |
61894 | 61894 | 2020-04-16 | Chilton | Alabama | 1021 | 37 | 0 |
64627 | 64627 | 2020-04-17 | Chilton | Alabama | 1021 | 37 | 0 |
67375 | 67375 | 2020-04-18 | Chilton | Alabama | 1021 | 39 | 0 |
70137 | 70137 | 2020-04-19 | Chilton | Alabama | 1021 | 42 | 0 |
72906 | 72906 | 2020-04-20 | Chilton | Alabama | 1021 | 43 | 0 |
75682 | 75682 | 2020-04-21 | Chilton | Alabama | 1021 | 44 | 0 |
78465 | 78465 | 2020-04-22 | Chilton | Alabama | 1021 | 46 | 1 |
81258 | 81258 | 2020-04-23 | Chilton | Alabama | 1021 | 47 | 1 |
84059 | 84059 | 2020-04-24 | Chilton | Alabama | 1021 | 49 | 1 |
86867 | 86867 | 2020-04-25 | Chilton | Alabama | 1021 | 49 | 1 |
89683 | 89683 | 2020-04-26 | Chilton | Alabama | 1021 | 51 | 1 |
92501 | 92501 | 2020-04-27 | Chilton | Alabama | 1021 | 51 | 1 |
95331 | 95331 | 2020-04-28 | Chilton | Alabama | 1021 | 52 | 1 |
98176 | 98176 | 2020-04-29 | Chilton | Alabama | 1021 | 53 | 1 |
101026 | 101026 | 2020-04-30 | Chilton | Alabama | 1021 | 53 | 1 |
103881 | 103881 | 2020-05-01 | Chilton | Alabama | 1021 | 52 | 1 |
106746 | 106746 | 2020-05-02 | Chilton | Alabama | 1021 | 54 | 1 |
109615 | 109615 | 2020-05-03 | Chilton | Alabama | 1021 | 57 | 1 |
112490 | 112490 | 2020-05-04 | Chilton | Alabama | 1021 | 58 | 1 |
115373 | 115373 | 2020-05-05 | Chilton | Alabama | 1021 | 60 | 1 |
118332 | 118332 | 2020-05-06 | Chilton | Alabama | 1021 | 61 | 1 |
121298 | 121298 | 2020-05-07 | Chilton | Alabama | 1021 | 63 | 1 |
124278 | 124278 | 2020-05-08 | Chilton | Alabama | 1021 | 63 | 1 |
127263 | 127263 | 2020-05-09 | Chilton | Alabama | 1021 | 64 | 1 |
130253 | 130253 | 2020-05-10 | Chilton | Alabama | 1021 | 65 | 1 |
133243 | 133243 | 2020-05-11 | Chilton | Alabama | 1021 | 67 | 1 |
136233 | 136233 | 2020-05-12 | Chilton | Alabama | 1021 | 69 | 1 |
139224 | 139224 | 2020-05-13 | Chilton | Alabama | 1021 | 73 | 1 |
142220 | 142220 | 2020-05-14 | Chilton | Alabama | 1021 | 74 | 1 |
145219 | 145219 | 2020-05-15 | Chilton | Alabama | 1021 | 75 | 1 |
148222 | 148222 | 2020-05-16 | Chilton | Alabama | 1021 | 77 | 1 |
151231 | 151231 | 2020-05-17 | Chilton | Alabama | 1021 | 77 | 1 |
154243 | 154243 | 2020-05-18 | Chilton | Alabama | 1021 | 79 | 1 |
157259 | 157259 | 2020-05-19 | Chilton | Alabama | 1021 | 80 | 1 |
160283 | 160283 | 2020-05-20 | Chilton | Alabama | 1021 | 83 | 1 |
163311 | 163311 | 2020-05-21 | Chilton | Alabama | 1021 | 84 | 1 |
166343 | 166343 | 2020-05-22 | Chilton | Alabama | 1021 | 85 | 1 |
169379 | 169379 | 2020-05-23 | Chilton | Alabama | 1021 | 86 | 1 |
172420 | 172420 | 2020-05-24 | Chilton | Alabama | 1021 | 87 | 1 |
175463 | 175463 | 2020-05-25 | Chilton | Alabama | 1021 | 87 | 1 |
178508 | 178508 | 2020-05-26 | Chilton | Alabama | 1021 | 90 | 1 |
181552 | 181552 | 2020-05-27 | Chilton | Alabama | 1021 | 93 | 1 |
184604 | 184604 | 2020-05-28 | Chilton | Alabama | 1021 | 97 | 1 |
187661 | 187661 | 2020-05-29 | Chilton | Alabama | 1021 | 99 | 1 |
190725 | 190725 | 2020-05-30 | Chilton | Alabama | 1021 | 100 | 1 |
193791 | 193791 | 2020-05-31 | Chilton | Alabama | 1021 | 101 | 1 |
196861 | 196861 | 2020-06-01 | Chilton | Alabama | 1021 | 107 | 1 |
199934 | 199934 | 2020-06-02 | Chilton | Alabama | 1021 | 108 | 1 |
203010 | 203010 | 2020-06-03 | Chilton | Alabama | 1021 | 109 | 1 |
206089 | 206089 | 2020-06-04 | Chilton | Alabama | 1021 | 112 | 1 |
209171 | 209171 | 2020-06-05 | Chilton | Alabama | 1021 | 113 | 1 |
212256 | 212256 | 2020-06-06 | Chilton | Alabama | 1021 | 113 | 2 |
215343 | 215343 | 2020-06-07 | Chilton | Alabama | 1021 | 115 | 2 |
218433 | 218433 | 2020-06-08 | Chilton | Alabama | 1021 | 116 | 2 |
221525 | 221525 | 2020-06-09 | Chilton | Alabama | 1021 | 122 | 2 |
224621 | 224621 | 2020-06-10 | Chilton | Alabama | 1021 | 124 | 2 |
227722 | 227722 | 2020-06-11 | Chilton | Alabama | 1021 | 127 | 2 |
230826 | 230826 | 2020-06-12 | Chilton | Alabama | 1021 | 128 | 2 |
233931 | 233931 | 2020-06-13 | Chilton | Alabama | 1021 | 134 | 2 |
237038 | 237038 | 2020-06-14 | Chilton | Alabama | 1021 | 138 | 2 |
240146 | 240146 | 2020-06-15 | Chilton | Alabama | 1021 | 141 | 2 |
243257 | 243257 | 2020-06-16 | Chilton | Alabama | 1021 | 144 | 2 |
246370 | 246370 | 2020-06-17 | Chilton | Alabama | 1021 | 149 | 2 |
249482 | 249482 | 2020-06-18 | Chilton | Alabama | 1021 | 152 | 3 |
252597 | 252597 | 2020-06-19 | Chilton | Alabama | 1021 | 158 | 3 |
255716 | 255716 | 2020-06-20 | Chilton | Alabama | 1021 | 163 | 3 |
258843 | 258843 | 2020-06-21 | Chilton | Alabama | 1021 | 166 | 3 |
261970 | 261970 | 2020-06-22 | Chilton | Alabama | 1021 | 170 | 3 |
265099 | 265099 | 2020-06-23 | Chilton | Alabama | 1021 | 176 | 3 |
268228 | 268228 | 2020-06-24 | Chilton | Alabama | 1021 | 185 | 3 |
271362 | 271362 | 2020-06-25 | Chilton | Alabama | 1021 | 185 | 3 |
274502 | 274502 | 2020-06-26 | Chilton | Alabama | 1021 | 196 | 3 |
277650 | 277650 | 2020-06-27 | Chilton | Alabama | 1021 | 201 | 3 |
280798 | 280798 | 2020-06-28 | Chilton | Alabama | 1021 | 203 | 3 |
283944 | 283944 | 2020-06-29 | Chilton | Alabama | 1021 | 211 | 3 |
287090 | 287090 | 2020-06-30 | Chilton | Alabama | 1021 | 214 | 3 |
290240 | 290240 | 2020-07-01 | Chilton | Alabama | 1021 | 219 | 3 |
293393 | 293393 | 2020-07-02 | Chilton | Alabama | 1021 | 222 | 3 |
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);