ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
786 rows where fips = 1017 sorted by county
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
deaths 107 ✖
- 123 51
- 147 38
- 142 36
- 124 32
- 162 31
- 38 29
- 125 26
- 42 25
- 27 22
- 127 22
- 48 21
- 161 19
- 26 17
- 43 17
- 122 15
- 149 14
- 21 13
- 143 13
- 144 12
- 0 10
- 63 10
- 121 10
- 22 8
- 41 8
- 47 8
- 61 8
- 126 8
- 145 8
- 153 8
- 8 7
- 40 7
- 50 7
- 111 7
- 138 7
- 69 6
- 70 6
- 114 6
- 116 6
- 148 6
- 150 6
- 158 6
- 159 6
- 23 5
- 24 5
- 54 5
- 57 5
- 76 5
- 81 5
- 94 5
- 112 5
- 4 4
- 32 4
- 33 4
- 66 4
- 99 4
- 113 4
- 132 4
- 139 4
- 160 4
- 11 3
- 16 3
- 18 3
- 25 3
- 37 3
- 39 3
- 44 3
- 55 3
- 60 3
- 110 3
- 120 3
- 133 3
- 134 3
- 152 3
- 6 2
- 10 2
- 30 2
- 34 2
- 58 2
- 75 2
- 98 2
- 108 2
- 117 2
- 135 2
- 137 2
- 157 2
- 1 1
- 5 1
- 7 1
- 13 1
- 14 1
- 17 1
- 19 1
- 28 1
- 49 1
- 51 1
- 62 1
- 78 1
- 80 1
- 84 1
- 89 1
- 92 1
- 102 1
- 103 1
- 115 1
- 119 1
- 130 1
- 140 1
state 1
- Alabama 786
fips 1
- 1017 · 786 ✖
county 1
- Chambers 786
Link | rowid | date | county ▼ | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
4403 | 4403 | 2020-03-19 | Chambers | Alabama | 1017 | 1 | 0 |
5169 | 5169 | 2020-03-20 | Chambers | Alabama | 1017 | 1 | 0 |
6085 | 6085 | 2020-03-21 | Chambers | Alabama | 1017 | 1 | 0 |
7119 | 7119 | 2020-03-22 | Chambers | Alabama | 1017 | 2 | 0 |
8257 | 8257 | 2020-03-23 | Chambers | Alabama | 1017 | 2 | 0 |
9484 | 9484 | 2020-03-24 | Chambers | Alabama | 1017 | 5 | 0 |
10841 | 10841 | 2020-03-25 | Chambers | Alabama | 1017 | 10 | 0 |
12374 | 12374 | 2020-03-26 | Chambers | Alabama | 1017 | 13 | 0 |
14032 | 14032 | 2020-03-27 | Chambers | Alabama | 1017 | 15 | 0 |
15810 | 15810 | 2020-03-28 | Chambers | Alabama | 1017 | 17 | 0 |
17693 | 17693 | 2020-03-29 | Chambers | Alabama | 1017 | 27 | 1 |
19663 | 19663 | 2020-03-30 | Chambers | Alabama | 1017 | 36 | 4 |
21735 | 21735 | 2020-03-31 | Chambers | Alabama | 1017 | 36 | 4 |
23888 | 23888 | 2020-04-01 | Chambers | Alabama | 1017 | 45 | 4 |
26109 | 26109 | 2020-04-02 | Chambers | Alabama | 1017 | 67 | 4 |
28405 | 28405 | 2020-04-03 | Chambers | Alabama | 1017 | 81 | 5 |
30762 | 30762 | 2020-04-04 | Chambers | Alabama | 1017 | 87 | 6 |
33166 | 33166 | 2020-04-05 | Chambers | Alabama | 1017 | 90 | 6 |
35605 | 35605 | 2020-04-06 | Chambers | Alabama | 1017 | 96 | 7 |
38093 | 38093 | 2020-04-07 | Chambers | Alabama | 1017 | 102 | 8 |
40635 | 40635 | 2020-04-08 | Chambers | Alabama | 1017 | 140 | 8 |
43208 | 43208 | 2020-04-09 | Chambers | Alabama | 1017 | 161 | 8 |
45806 | 45806 | 2020-04-10 | Chambers | Alabama | 1017 | 171 | 8 |
48435 | 48435 | 2020-04-11 | Chambers | Alabama | 1017 | 184 | 8 |
51096 | 51096 | 2020-04-12 | Chambers | Alabama | 1017 | 200 | 8 |
53774 | 53774 | 2020-04-13 | Chambers | Alabama | 1017 | 212 | 8 |
56466 | 56466 | 2020-04-14 | Chambers | Alabama | 1017 | 216 | 10 |
59174 | 59174 | 2020-04-15 | Chambers | Alabama | 1017 | 227 | 10 |
61892 | 61892 | 2020-04-16 | Chambers | Alabama | 1017 | 234 | 11 |
64625 | 64625 | 2020-04-17 | Chambers | Alabama | 1017 | 236 | 11 |
67373 | 67373 | 2020-04-18 | Chambers | Alabama | 1017 | 240 | 11 |
70135 | 70135 | 2020-04-19 | Chambers | Alabama | 1017 | 246 | 14 |
72904 | 72904 | 2020-04-20 | Chambers | Alabama | 1017 | 257 | 13 |
75680 | 75680 | 2020-04-21 | Chambers | Alabama | 1017 | 259 | 16 |
78463 | 78463 | 2020-04-22 | Chambers | Alabama | 1017 | 270 | 16 |
81256 | 81256 | 2020-04-23 | Chambers | Alabama | 1017 | 275 | 16 |
84057 | 84057 | 2020-04-24 | Chambers | Alabama | 1017 | 282 | 17 |
86865 | 86865 | 2020-04-25 | Chambers | Alabama | 1017 | 284 | 18 |
89681 | 89681 | 2020-04-26 | Chambers | Alabama | 1017 | 285 | 18 |
92499 | 92499 | 2020-04-27 | Chambers | Alabama | 1017 | 289 | 18 |
95329 | 95329 | 2020-04-28 | Chambers | Alabama | 1017 | 291 | 19 |
98174 | 98174 | 2020-04-29 | Chambers | Alabama | 1017 | 293 | 21 |
101024 | 101024 | 2020-04-30 | Chambers | Alabama | 1017 | 291 | 21 |
103879 | 103879 | 2020-05-01 | Chambers | Alabama | 1017 | 290 | 21 |
106744 | 106744 | 2020-05-02 | Chambers | Alabama | 1017 | 294 | 21 |
109613 | 109613 | 2020-05-03 | Chambers | Alabama | 1017 | 300 | 21 |
112488 | 112488 | 2020-05-04 | Chambers | Alabama | 1017 | 302 | 21 |
115371 | 115371 | 2020-05-05 | Chambers | Alabama | 1017 | 304 | 21 |
118330 | 118330 | 2020-05-06 | Chambers | Alabama | 1017 | 306 | 22 |
121296 | 121296 | 2020-05-07 | Chambers | Alabama | 1017 | 308 | 21 |
124276 | 124276 | 2020-05-08 | Chambers | Alabama | 1017 | 311 | 21 |
127261 | 127261 | 2020-05-09 | Chambers | Alabama | 1017 | 314 | 21 |
130251 | 130251 | 2020-05-10 | Chambers | Alabama | 1017 | 316 | 21 |
133241 | 133241 | 2020-05-11 | Chambers | Alabama | 1017 | 319 | 21 |
136231 | 136231 | 2020-05-12 | Chambers | Alabama | 1017 | 324 | 21 |
139222 | 139222 | 2020-05-13 | Chambers | Alabama | 1017 | 324 | 22 |
142218 | 142218 | 2020-05-14 | Chambers | Alabama | 1017 | 326 | 22 |
145217 | 145217 | 2020-05-15 | Chambers | Alabama | 1017 | 326 | 22 |
148220 | 148220 | 2020-05-16 | Chambers | Alabama | 1017 | 328 | 22 |
151229 | 151229 | 2020-05-17 | Chambers | Alabama | 1017 | 328 | 22 |
154241 | 154241 | 2020-05-18 | Chambers | Alabama | 1017 | 329 | 22 |
157257 | 157257 | 2020-05-19 | Chambers | Alabama | 1017 | 329 | 22 |
160281 | 160281 | 2020-05-20 | Chambers | Alabama | 1017 | 331 | 23 |
163309 | 163309 | 2020-05-21 | Chambers | Alabama | 1017 | 330 | 23 |
166341 | 166341 | 2020-05-22 | Chambers | Alabama | 1017 | 330 | 23 |
169377 | 169377 | 2020-05-23 | Chambers | Alabama | 1017 | 330 | 23 |
172418 | 172418 | 2020-05-24 | Chambers | Alabama | 1017 | 336 | 23 |
175461 | 175461 | 2020-05-25 | Chambers | Alabama | 1017 | 337 | 24 |
178506 | 178506 | 2020-05-26 | Chambers | Alabama | 1017 | 338 | 24 |
181550 | 181550 | 2020-05-27 | Chambers | Alabama | 1017 | 340 | 24 |
184602 | 184602 | 2020-05-28 | Chambers | Alabama | 1017 | 349 | 24 |
187659 | 187659 | 2020-05-29 | Chambers | Alabama | 1017 | 352 | 24 |
190723 | 190723 | 2020-05-30 | Chambers | Alabama | 1017 | 353 | 25 |
193789 | 193789 | 2020-05-31 | Chambers | Alabama | 1017 | 355 | 25 |
196859 | 196859 | 2020-06-01 | Chambers | Alabama | 1017 | 370 | 25 |
199932 | 199932 | 2020-06-02 | Chambers | Alabama | 1017 | 370 | 26 |
203008 | 203008 | 2020-06-03 | Chambers | Alabama | 1017 | 371 | 26 |
206087 | 206087 | 2020-06-04 | Chambers | Alabama | 1017 | 372 | 26 |
209169 | 209169 | 2020-06-05 | Chambers | Alabama | 1017 | 375 | 26 |
212254 | 212254 | 2020-06-06 | Chambers | Alabama | 1017 | 385 | 26 |
215341 | 215341 | 2020-06-07 | Chambers | Alabama | 1017 | 390 | 26 |
218431 | 218431 | 2020-06-08 | Chambers | Alabama | 1017 | 395 | 26 |
221523 | 221523 | 2020-06-09 | Chambers | Alabama | 1017 | 404 | 26 |
224619 | 224619 | 2020-06-10 | Chambers | Alabama | 1017 | 415 | 26 |
227720 | 227720 | 2020-06-11 | Chambers | Alabama | 1017 | 431 | 26 |
230824 | 230824 | 2020-06-12 | Chambers | Alabama | 1017 | 441 | 26 |
233929 | 233929 | 2020-06-13 | Chambers | Alabama | 1017 | 452 | 26 |
237036 | 237036 | 2020-06-14 | Chambers | Alabama | 1017 | 467 | 26 |
240144 | 240144 | 2020-06-15 | Chambers | Alabama | 1017 | 475 | 26 |
243255 | 243255 | 2020-06-16 | Chambers | Alabama | 1017 | 485 | 26 |
246368 | 246368 | 2020-06-17 | Chambers | Alabama | 1017 | 486 | 26 |
249480 | 249480 | 2020-06-18 | Chambers | Alabama | 1017 | 501 | 26 |
252595 | 252595 | 2020-06-19 | Chambers | Alabama | 1017 | 507 | 28 |
255714 | 255714 | 2020-06-20 | Chambers | Alabama | 1017 | 516 | 27 |
258841 | 258841 | 2020-06-21 | Chambers | Alabama | 1017 | 521 | 27 |
261968 | 261968 | 2020-06-22 | Chambers | Alabama | 1017 | 528 | 27 |
265097 | 265097 | 2020-06-23 | Chambers | Alabama | 1017 | 534 | 27 |
268226 | 268226 | 2020-06-24 | Chambers | Alabama | 1017 | 543 | 27 |
271360 | 271360 | 2020-06-25 | Chambers | Alabama | 1017 | 549 | 27 |
274500 | 274500 | 2020-06-26 | Chambers | Alabama | 1017 | 559 | 27 |
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);