ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
792 rows where county = "Elmore" and state = "Alabama" sorted by date
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date ▼ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1620 | 1620 | 2020-03-13 | Elmore | Alabama | 1051 | 1 | 0 |
1936 | 1936 | 2020-03-14 | Elmore | Alabama | 1051 | 1 | 0 |
2311 | 2311 | 2020-03-15 | Elmore | Alabama | 1051 | 1 | 0 |
2740 | 2740 | 2020-03-16 | Elmore | Alabama | 1051 | 1 | 0 |
3216 | 3216 | 2020-03-17 | Elmore | Alabama | 1051 | 2 | 0 |
3763 | 3763 | 2020-03-18 | Elmore | Alabama | 1051 | 4 | 0 |
4404 | 4404 | 2020-03-19 | Elmore | Alabama | 1051 | 5 | 0 |
5171 | 5171 | 2020-03-20 | Elmore | Alabama | 1051 | 6 | 0 |
6087 | 6087 | 2020-03-21 | Elmore | Alabama | 1051 | 6 | 0 |
7121 | 7121 | 2020-03-22 | Elmore | Alabama | 1051 | 6 | 0 |
8259 | 8259 | 2020-03-23 | Elmore | Alabama | 1051 | 6 | 0 |
9486 | 9486 | 2020-03-24 | Elmore | Alabama | 1051 | 8 | 0 |
10849 | 10849 | 2020-03-25 | Elmore | Alabama | 1051 | 9 | 0 |
12386 | 12386 | 2020-03-26 | Elmore | Alabama | 1051 | 10 | 0 |
14045 | 14045 | 2020-03-27 | Elmore | Alabama | 1051 | 12 | 0 |
15823 | 15823 | 2020-03-28 | Elmore | Alabama | 1051 | 13 | 0 |
17706 | 17706 | 2020-03-29 | Elmore | Alabama | 1051 | 13 | 0 |
19676 | 19676 | 2020-03-30 | Elmore | Alabama | 1051 | 13 | 0 |
21748 | 21748 | 2020-03-31 | Elmore | Alabama | 1051 | 12 | 0 |
23904 | 23904 | 2020-04-01 | Elmore | Alabama | 1051 | 15 | 0 |
26126 | 26126 | 2020-04-02 | Elmore | Alabama | 1051 | 17 | 0 |
28422 | 28422 | 2020-04-03 | Elmore | Alabama | 1051 | 19 | 0 |
30779 | 30779 | 2020-04-04 | Elmore | Alabama | 1051 | 19 | 0 |
33183 | 33183 | 2020-04-05 | Elmore | Alabama | 1051 | 19 | 0 |
35622 | 35622 | 2020-04-06 | Elmore | Alabama | 1051 | 20 | 0 |
38110 | 38110 | 2020-04-07 | Elmore | Alabama | 1051 | 22 | 0 |
40652 | 40652 | 2020-04-08 | Elmore | Alabama | 1051 | 24 | 0 |
43225 | 43225 | 2020-04-09 | Elmore | Alabama | 1051 | 29 | 0 |
45823 | 45823 | 2020-04-10 | Elmore | Alabama | 1051 | 30 | 0 |
48452 | 48452 | 2020-04-11 | Elmore | Alabama | 1051 | 30 | 0 |
51113 | 51113 | 2020-04-12 | Elmore | Alabama | 1051 | 33 | 0 |
53791 | 53791 | 2020-04-13 | Elmore | Alabama | 1051 | 37 | 0 |
56483 | 56483 | 2020-04-14 | Elmore | Alabama | 1051 | 43 | 0 |
59191 | 59191 | 2020-04-15 | Elmore | Alabama | 1051 | 49 | 0 |
61909 | 61909 | 2020-04-16 | Elmore | Alabama | 1051 | 54 | 0 |
64642 | 64642 | 2020-04-17 | Elmore | Alabama | 1051 | 54 | 1 |
67390 | 67390 | 2020-04-18 | Elmore | Alabama | 1051 | 58 | 1 |
70152 | 70152 | 2020-04-19 | Elmore | Alabama | 1051 | 63 | 1 |
72921 | 72921 | 2020-04-20 | Elmore | Alabama | 1051 | 68 | 1 |
75697 | 75697 | 2020-04-21 | Elmore | Alabama | 1051 | 73 | 1 |
78480 | 78480 | 2020-04-22 | Elmore | Alabama | 1051 | 74 | 1 |
81273 | 81273 | 2020-04-23 | Elmore | Alabama | 1051 | 74 | 1 |
84074 | 84074 | 2020-04-24 | Elmore | Alabama | 1051 | 74 | 1 |
86882 | 86882 | 2020-04-25 | Elmore | Alabama | 1051 | 77 | 1 |
89698 | 89698 | 2020-04-26 | Elmore | Alabama | 1051 | 79 | 1 |
92516 | 92516 | 2020-04-27 | Elmore | Alabama | 1051 | 79 | 1 |
95346 | 95346 | 2020-04-28 | Elmore | Alabama | 1051 | 82 | 1 |
98191 | 98191 | 2020-04-29 | Elmore | Alabama | 1051 | 84 | 2 |
101041 | 101041 | 2020-04-30 | Elmore | Alabama | 1051 | 86 | 2 |
103896 | 103896 | 2020-05-01 | Elmore | Alabama | 1051 | 88 | 2 |
106761 | 106761 | 2020-05-02 | Elmore | Alabama | 1051 | 93 | 2 |
109630 | 109630 | 2020-05-03 | Elmore | Alabama | 1051 | 103 | 2 |
112505 | 112505 | 2020-05-04 | Elmore | Alabama | 1051 | 111 | 3 |
115388 | 115388 | 2020-05-05 | Elmore | Alabama | 1051 | 121 | 3 |
118347 | 118347 | 2020-05-06 | Elmore | Alabama | 1051 | 121 | 3 |
121313 | 121313 | 2020-05-07 | Elmore | Alabama | 1051 | 127 | 4 |
124293 | 124293 | 2020-05-08 | Elmore | Alabama | 1051 | 130 | 4 |
127278 | 127278 | 2020-05-09 | Elmore | Alabama | 1051 | 135 | 4 |
130268 | 130268 | 2020-05-10 | Elmore | Alabama | 1051 | 150 | 4 |
133258 | 133258 | 2020-05-11 | Elmore | Alabama | 1051 | 152 | 4 |
136248 | 136248 | 2020-05-12 | Elmore | Alabama | 1051 | 156 | 4 |
139239 | 139239 | 2020-05-13 | Elmore | Alabama | 1051 | 157 | 5 |
142235 | 142235 | 2020-05-14 | Elmore | Alabama | 1051 | 169 | 6 |
145234 | 145234 | 2020-05-15 | Elmore | Alabama | 1051 | 178 | 6 |
148237 | 148237 | 2020-05-16 | Elmore | Alabama | 1051 | 188 | 6 |
151246 | 151246 | 2020-05-17 | Elmore | Alabama | 1051 | 192 | 6 |
154258 | 154258 | 2020-05-18 | Elmore | Alabama | 1051 | 197 | 6 |
157274 | 157274 | 2020-05-19 | Elmore | Alabama | 1051 | 207 | 6 |
160298 | 160298 | 2020-05-20 | Elmore | Alabama | 1051 | 226 | 7 |
163326 | 163326 | 2020-05-21 | Elmore | Alabama | 1051 | 238 | 7 |
166358 | 166358 | 2020-05-22 | Elmore | Alabama | 1051 | 242 | 7 |
169394 | 169394 | 2020-05-23 | Elmore | Alabama | 1051 | 255 | 7 |
172435 | 172435 | 2020-05-24 | Elmore | Alabama | 1051 | 263 | 7 |
175478 | 175478 | 2020-05-25 | Elmore | Alabama | 1051 | 270 | 7 |
178523 | 178523 | 2020-05-26 | Elmore | Alabama | 1051 | 292 | 7 |
181567 | 181567 | 2020-05-27 | Elmore | Alabama | 1051 | 300 | 7 |
184619 | 184619 | 2020-05-28 | Elmore | Alabama | 1051 | 313 | 7 |
187676 | 187676 | 2020-05-29 | Elmore | Alabama | 1051 | 323 | 7 |
190740 | 190740 | 2020-05-30 | Elmore | Alabama | 1051 | 339 | 8 |
193806 | 193806 | 2020-05-31 | Elmore | Alabama | 1051 | 354 | 8 |
196876 | 196876 | 2020-06-01 | Elmore | Alabama | 1051 | 373 | 8 |
199949 | 199949 | 2020-06-02 | Elmore | Alabama | 1051 | 384 | 9 |
203025 | 203025 | 2020-06-03 | Elmore | Alabama | 1051 | 383 | 9 |
206104 | 206104 | 2020-06-04 | Elmore | Alabama | 1051 | 385 | 9 |
209186 | 209186 | 2020-06-05 | Elmore | Alabama | 1051 | 392 | 10 |
212271 | 212271 | 2020-06-06 | Elmore | Alabama | 1051 | 412 | 10 |
215358 | 215358 | 2020-06-07 | Elmore | Alabama | 1051 | 422 | 10 |
218448 | 218448 | 2020-06-08 | Elmore | Alabama | 1051 | 438 | 10 |
221540 | 221540 | 2020-06-09 | Elmore | Alabama | 1051 | 449 | 10 |
224636 | 224636 | 2020-06-10 | Elmore | Alabama | 1051 | 459 | 9 |
227737 | 227737 | 2020-06-11 | Elmore | Alabama | 1051 | 483 | 9 |
230841 | 230841 | 2020-06-12 | Elmore | Alabama | 1051 | 498 | 9 |
233946 | 233946 | 2020-06-13 | Elmore | Alabama | 1051 | 515 | 9 |
237053 | 237053 | 2020-06-14 | Elmore | Alabama | 1051 | 541 | 9 |
240161 | 240161 | 2020-06-15 | Elmore | Alabama | 1051 | 560 | 9 |
243272 | 243272 | 2020-06-16 | Elmore | Alabama | 1051 | 581 | 10 |
246385 | 246385 | 2020-06-17 | Elmore | Alabama | 1051 | 589 | 10 |
249497 | 249497 | 2020-06-18 | Elmore | Alabama | 1051 | 616 | 10 |
252612 | 252612 | 2020-06-19 | Elmore | Alabama | 1051 | 646 | 11 |
255731 | 255731 | 2020-06-20 | Elmore | Alabama | 1051 | 663 | 11 |
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);