ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
1,567 rows where county = "Elmore" sorted by county
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date, date (date)
deaths 196 ✖
- 2 95
- 3 73
- 19 72
- 70 70
- 0 56
- 4 52
- 10 37
- 14 36
- 9 30
- 12 29
- 47 29
- 52 27
- 347 24
- 7 23
- 13 19
- 214 19
- 6 18
- 50 18
- 294 18
- 1 17
- 44 17
- 54 17
- 11 16
- 15 16
- 17 16
- 205 16
- 58 15
- 61 15
- 20 14
- 51 13
- 296 13
- 53 11
- 217 11
- 297 11
- 301 11
- 59 10
- 64 10
- 200 10
- 295 10
- 302 10
- 343 10
- 23 9
- 27 9
- 37 9
- 42 9
- 48 9
- 201 9
- 208 9
- 288 9
- 57 8
- 206 8
- 8 7
- 38 7
- 39 7
- 41 7
- 43 7
- 63 7
- 69 7
- 215 7
- 220 7
- 234 7
- 284 7
- 18 6
- 24 6
- 31 6
- 34 6
- 80 6
- 83 6
- 101 6
- 202 6
- 216 6
- 236 6
- 286 6
- 324 6
- 340 6
- 342 6
- 46 5
- 49 5
- 55 5
- 72 5
- 81 5
- 85 5
- 168 5
- 185 5
- 190 5
- 198 5
- 210 5
- 212 5
- 231 5
- 239 5
- 277 5
- 314 5
- 335 5
- 346 5
- 16 4
- 178 4
- 203 4
- 204 4
- 219 4
- 308 4
- 327 4
- 330 4
- 337 4
- 5 3
- 26 3
- 35 3
- 60 3
- 67 3
- 104 3
- 110 3
- 134 3
- 152 3
- 196 3
- 199 3
- 207 3
- 245 3
- 264 3
- 273 3
- 275 3
- 289 3
- 315 3
- 317 3
- 336 3
- 21 2
- 22 2
- 33 2
- 45 2
- 62 2
- 78 2
- 91 2
- 132 2
- 179 2
- 191 2
- 197 2
- 211 2
- 213 2
- 222 2
- 225 2
- 226 2
- 228 2
- 265 2
- 290 2
- 291 2
- 298 2
- 299 2
- 311 2
- 320 2
- 325 2
- 25 1
- 28 1
- 29 1
- 30 1
- 65 1
- 66 1
- 74 1
- 76 1
- 82 1
- 86 1
- 112 1
- 123 1
- 131 1
- 143 1
- 149 1
- 151 1
- 155 1
- 162 1
- 165 1
- 170 1
- 171 1
- 182 1
- 183 1
- 192 1
- 194 1
- 209 1
- 229 1
- 230 1
- 233 1
- 235 1
- 238 1
- 240 1
- 241 1
- 254 1
- 256 1
- 259 1
- 260 1
- 268 1
- 272 1
- 279 1
- 283 1
- 319 1
- 329 1
- 332 1
- 334 1
- 339 1
- 341 1
- 344 1
county 1
- Elmore · 1,567 ✖
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 |
20098 | 20098 | 2020-03-30 | Elmore | Idaho | 16039 | 1 | 0 |
21748 | 21748 | 2020-03-31 | Elmore | Alabama | 1051 | 12 | 0 |
22189 | 22189 | 2020-03-31 | Elmore | Idaho | 16039 | 3 | 0 |
23904 | 23904 | 2020-04-01 | Elmore | Alabama | 1051 | 15 | 0 |
24355 | 24355 | 2020-04-01 | Elmore | Idaho | 16039 | 3 | 0 |
26126 | 26126 | 2020-04-02 | Elmore | Alabama | 1051 | 17 | 0 |
26587 | 26587 | 2020-04-02 | Elmore | Idaho | 16039 | 9 | 0 |
28422 | 28422 | 2020-04-03 | Elmore | Alabama | 1051 | 19 | 0 |
28894 | 28894 | 2020-04-03 | Elmore | Idaho | 16039 | 10 | 0 |
30779 | 30779 | 2020-04-04 | Elmore | Alabama | 1051 | 19 | 0 |
31256 | 31256 | 2020-04-04 | Elmore | Idaho | 16039 | 11 | 0 |
33183 | 33183 | 2020-04-05 | Elmore | Alabama | 1051 | 19 | 0 |
33663 | 33663 | 2020-04-05 | Elmore | Idaho | 16039 | 11 | 0 |
35622 | 35622 | 2020-04-06 | Elmore | Alabama | 1051 | 20 | 0 |
36114 | 36114 | 2020-04-06 | Elmore | Idaho | 16039 | 12 | 0 |
38110 | 38110 | 2020-04-07 | Elmore | Alabama | 1051 | 22 | 0 |
38607 | 38607 | 2020-04-07 | Elmore | Idaho | 16039 | 14 | 0 |
40652 | 40652 | 2020-04-08 | Elmore | Alabama | 1051 | 24 | 0 |
41151 | 41151 | 2020-04-08 | Elmore | Idaho | 16039 | 14 | 0 |
43225 | 43225 | 2020-04-09 | Elmore | Alabama | 1051 | 29 | 0 |
43725 | 43725 | 2020-04-09 | Elmore | Idaho | 16039 | 16 | 0 |
45823 | 45823 | 2020-04-10 | Elmore | Alabama | 1051 | 30 | 0 |
46327 | 46327 | 2020-04-10 | Elmore | Idaho | 16039 | 16 | 0 |
48452 | 48452 | 2020-04-11 | Elmore | Alabama | 1051 | 30 | 0 |
48958 | 48958 | 2020-04-11 | Elmore | Idaho | 16039 | 16 | 0 |
51113 | 51113 | 2020-04-12 | Elmore | Alabama | 1051 | 33 | 0 |
51620 | 51620 | 2020-04-12 | Elmore | Idaho | 16039 | 16 | 0 |
53791 | 53791 | 2020-04-13 | Elmore | Alabama | 1051 | 37 | 0 |
54300 | 54300 | 2020-04-13 | Elmore | Idaho | 16039 | 16 | 0 |
56483 | 56483 | 2020-04-14 | Elmore | Alabama | 1051 | 43 | 0 |
56992 | 56992 | 2020-04-14 | Elmore | Idaho | 16039 | 18 | 0 |
59191 | 59191 | 2020-04-15 | Elmore | Alabama | 1051 | 49 | 0 |
59699 | 59699 | 2020-04-15 | Elmore | Idaho | 16039 | 18 | 0 |
61909 | 61909 | 2020-04-16 | Elmore | Alabama | 1051 | 54 | 0 |
62419 | 62419 | 2020-04-16 | Elmore | Idaho | 16039 | 18 | 0 |
64642 | 64642 | 2020-04-17 | Elmore | Alabama | 1051 | 54 | 1 |
65151 | 65151 | 2020-04-17 | Elmore | Idaho | 16039 | 21 | 0 |
67390 | 67390 | 2020-04-18 | Elmore | Alabama | 1051 | 58 | 1 |
67899 | 67899 | 2020-04-18 | Elmore | Idaho | 16039 | 22 | 0 |
70152 | 70152 | 2020-04-19 | Elmore | Alabama | 1051 | 63 | 1 |
70661 | 70661 | 2020-04-19 | Elmore | Idaho | 16039 | 22 | 0 |
72921 | 72921 | 2020-04-20 | Elmore | Alabama | 1051 | 68 | 1 |
73430 | 73430 | 2020-04-20 | Elmore | Idaho | 16039 | 24 | 1 |
75697 | 75697 | 2020-04-21 | Elmore | Alabama | 1051 | 73 | 1 |
76206 | 76206 | 2020-04-21 | Elmore | Idaho | 16039 | 25 | 1 |
78480 | 78480 | 2020-04-22 | Elmore | Alabama | 1051 | 74 | 1 |
78990 | 78990 | 2020-04-22 | Elmore | Idaho | 16039 | 28 | 1 |
81273 | 81273 | 2020-04-23 | Elmore | Alabama | 1051 | 74 | 1 |
81783 | 81783 | 2020-04-23 | Elmore | Idaho | 16039 | 32 | 1 |
84074 | 84074 | 2020-04-24 | Elmore | Alabama | 1051 | 74 | 1 |
84583 | 84583 | 2020-04-24 | Elmore | Idaho | 16039 | 32 | 1 |
86882 | 86882 | 2020-04-25 | Elmore | Alabama | 1051 | 77 | 1 |
87392 | 87392 | 2020-04-25 | Elmore | Idaho | 16039 | 29 | 2 |
89698 | 89698 | 2020-04-26 | Elmore | Alabama | 1051 | 79 | 1 |
90208 | 90208 | 2020-04-26 | Elmore | Idaho | 16039 | 29 | 2 |
92516 | 92516 | 2020-04-27 | Elmore | Alabama | 1051 | 79 | 1 |
93027 | 93027 | 2020-04-27 | Elmore | Idaho | 16039 | 29 | 2 |
95346 | 95346 | 2020-04-28 | Elmore | Alabama | 1051 | 82 | 1 |
95859 | 95859 | 2020-04-28 | Elmore | Idaho | 16039 | 30 | 2 |
98191 | 98191 | 2020-04-29 | Elmore | Alabama | 1051 | 84 | 2 |
98703 | 98703 | 2020-04-29 | Elmore | Idaho | 16039 | 30 | 2 |
101041 | 101041 | 2020-04-30 | Elmore | Alabama | 1051 | 86 | 2 |
101554 | 101554 | 2020-04-30 | Elmore | Idaho | 16039 | 30 | 2 |
103896 | 103896 | 2020-05-01 | Elmore | Alabama | 1051 | 88 | 2 |
104409 | 104409 | 2020-05-01 | Elmore | Idaho | 16039 | 30 | 2 |
106761 | 106761 | 2020-05-02 | Elmore | Alabama | 1051 | 93 | 2 |
107274 | 107274 | 2020-05-02 | Elmore | Idaho | 16039 | 30 | 2 |
109630 | 109630 | 2020-05-03 | Elmore | Alabama | 1051 | 103 | 2 |
110144 | 110144 | 2020-05-03 | Elmore | Idaho | 16039 | 30 | 2 |
112505 | 112505 | 2020-05-04 | Elmore | Alabama | 1051 | 111 | 3 |
113019 | 113019 | 2020-05-04 | Elmore | Idaho | 16039 | 30 | 2 |
115388 | 115388 | 2020-05-05 | Elmore | Alabama | 1051 | 121 | 3 |
115902 | 115902 | 2020-05-05 | Elmore | Idaho | 16039 | 30 | 2 |
118347 | 118347 | 2020-05-06 | Elmore | Alabama | 1051 | 121 | 3 |
118862 | 118862 | 2020-05-06 | Elmore | Idaho | 16039 | 31 | 2 |
121313 | 121313 | 2020-05-07 | Elmore | Alabama | 1051 | 127 | 4 |
121832 | 121832 | 2020-05-07 | Elmore | Idaho | 16039 | 31 | 2 |
124293 | 124293 | 2020-05-08 | Elmore | Alabama | 1051 | 130 | 4 |
124811 | 124811 | 2020-05-08 | Elmore | Idaho | 16039 | 31 | 2 |
127278 | 127278 | 2020-05-09 | Elmore | Alabama | 1051 | 135 | 4 |
127798 | 127798 | 2020-05-09 | Elmore | Idaho | 16039 | 31 | 2 |
130268 | 130268 | 2020-05-10 | Elmore | Alabama | 1051 | 150 | 4 |
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);