ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
786 rows where county = "Chambers" and state = "Alabama" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
293391 | 293391 | 2020-07-02 | Chambers | Alabama | 1017 | 611 | 27 |
290238 | 290238 | 2020-07-01 | Chambers | Alabama | 1017 | 595 | 27 |
287088 | 287088 | 2020-06-30 | Chambers | Alabama | 1017 | 590 | 27 |
283942 | 283942 | 2020-06-29 | Chambers | Alabama | 1017 | 585 | 27 |
280796 | 280796 | 2020-06-28 | Chambers | Alabama | 1017 | 561 | 27 |
277648 | 277648 | 2020-06-27 | Chambers | Alabama | 1017 | 561 | 27 |
274500 | 274500 | 2020-06-26 | Chambers | Alabama | 1017 | 559 | 27 |
271360 | 271360 | 2020-06-25 | Chambers | Alabama | 1017 | 549 | 27 |
268226 | 268226 | 2020-06-24 | Chambers | Alabama | 1017 | 543 | 27 |
265097 | 265097 | 2020-06-23 | Chambers | Alabama | 1017 | 534 | 27 |
261968 | 261968 | 2020-06-22 | Chambers | Alabama | 1017 | 528 | 27 |
258841 | 258841 | 2020-06-21 | Chambers | Alabama | 1017 | 521 | 27 |
255714 | 255714 | 2020-06-20 | Chambers | Alabama | 1017 | 516 | 27 |
252595 | 252595 | 2020-06-19 | Chambers | Alabama | 1017 | 507 | 28 |
249480 | 249480 | 2020-06-18 | Chambers | Alabama | 1017 | 501 | 26 |
246368 | 246368 | 2020-06-17 | Chambers | Alabama | 1017 | 486 | 26 |
243255 | 243255 | 2020-06-16 | Chambers | Alabama | 1017 | 485 | 26 |
240144 | 240144 | 2020-06-15 | Chambers | Alabama | 1017 | 475 | 26 |
237036 | 237036 | 2020-06-14 | Chambers | Alabama | 1017 | 467 | 26 |
233929 | 233929 | 2020-06-13 | Chambers | Alabama | 1017 | 452 | 26 |
230824 | 230824 | 2020-06-12 | Chambers | Alabama | 1017 | 441 | 26 |
227720 | 227720 | 2020-06-11 | Chambers | Alabama | 1017 | 431 | 26 |
224619 | 224619 | 2020-06-10 | Chambers | Alabama | 1017 | 415 | 26 |
221523 | 221523 | 2020-06-09 | Chambers | Alabama | 1017 | 404 | 26 |
218431 | 218431 | 2020-06-08 | Chambers | Alabama | 1017 | 395 | 26 |
215341 | 215341 | 2020-06-07 | Chambers | Alabama | 1017 | 390 | 26 |
212254 | 212254 | 2020-06-06 | Chambers | Alabama | 1017 | 385 | 26 |
209169 | 209169 | 2020-06-05 | Chambers | Alabama | 1017 | 375 | 26 |
206087 | 206087 | 2020-06-04 | Chambers | Alabama | 1017 | 372 | 26 |
203008 | 203008 | 2020-06-03 | Chambers | Alabama | 1017 | 371 | 26 |
199932 | 199932 | 2020-06-02 | Chambers | Alabama | 1017 | 370 | 26 |
196859 | 196859 | 2020-06-01 | Chambers | Alabama | 1017 | 370 | 25 |
193789 | 193789 | 2020-05-31 | Chambers | Alabama | 1017 | 355 | 25 |
190723 | 190723 | 2020-05-30 | Chambers | Alabama | 1017 | 353 | 25 |
187659 | 187659 | 2020-05-29 | Chambers | Alabama | 1017 | 352 | 24 |
184602 | 184602 | 2020-05-28 | Chambers | Alabama | 1017 | 349 | 24 |
181550 | 181550 | 2020-05-27 | Chambers | Alabama | 1017 | 340 | 24 |
178506 | 178506 | 2020-05-26 | Chambers | Alabama | 1017 | 338 | 24 |
175461 | 175461 | 2020-05-25 | Chambers | Alabama | 1017 | 337 | 24 |
172418 | 172418 | 2020-05-24 | Chambers | Alabama | 1017 | 336 | 23 |
169377 | 169377 | 2020-05-23 | Chambers | Alabama | 1017 | 330 | 23 |
166341 | 166341 | 2020-05-22 | Chambers | Alabama | 1017 | 330 | 23 |
163309 | 163309 | 2020-05-21 | Chambers | Alabama | 1017 | 330 | 23 |
160281 | 160281 | 2020-05-20 | Chambers | Alabama | 1017 | 331 | 23 |
157257 | 157257 | 2020-05-19 | Chambers | Alabama | 1017 | 329 | 22 |
154241 | 154241 | 2020-05-18 | Chambers | Alabama | 1017 | 329 | 22 |
151229 | 151229 | 2020-05-17 | Chambers | Alabama | 1017 | 328 | 22 |
148220 | 148220 | 2020-05-16 | Chambers | Alabama | 1017 | 328 | 22 |
145217 | 145217 | 2020-05-15 | Chambers | Alabama | 1017 | 326 | 22 |
142218 | 142218 | 2020-05-14 | Chambers | Alabama | 1017 | 326 | 22 |
139222 | 139222 | 2020-05-13 | Chambers | Alabama | 1017 | 324 | 22 |
136231 | 136231 | 2020-05-12 | Chambers | Alabama | 1017 | 324 | 21 |
133241 | 133241 | 2020-05-11 | Chambers | Alabama | 1017 | 319 | 21 |
130251 | 130251 | 2020-05-10 | Chambers | Alabama | 1017 | 316 | 21 |
127261 | 127261 | 2020-05-09 | Chambers | Alabama | 1017 | 314 | 21 |
124276 | 124276 | 2020-05-08 | Chambers | Alabama | 1017 | 311 | 21 |
121296 | 121296 | 2020-05-07 | Chambers | Alabama | 1017 | 308 | 21 |
118330 | 118330 | 2020-05-06 | Chambers | Alabama | 1017 | 306 | 22 |
115371 | 115371 | 2020-05-05 | Chambers | Alabama | 1017 | 304 | 21 |
112488 | 112488 | 2020-05-04 | Chambers | Alabama | 1017 | 302 | 21 |
109613 | 109613 | 2020-05-03 | Chambers | Alabama | 1017 | 300 | 21 |
106744 | 106744 | 2020-05-02 | Chambers | Alabama | 1017 | 294 | 21 |
103879 | 103879 | 2020-05-01 | Chambers | Alabama | 1017 | 290 | 21 |
101024 | 101024 | 2020-04-30 | Chambers | Alabama | 1017 | 291 | 21 |
98174 | 98174 | 2020-04-29 | Chambers | Alabama | 1017 | 293 | 21 |
95329 | 95329 | 2020-04-28 | Chambers | Alabama | 1017 | 291 | 19 |
92499 | 92499 | 2020-04-27 | Chambers | Alabama | 1017 | 289 | 18 |
89681 | 89681 | 2020-04-26 | Chambers | Alabama | 1017 | 285 | 18 |
86865 | 86865 | 2020-04-25 | Chambers | Alabama | 1017 | 284 | 18 |
84057 | 84057 | 2020-04-24 | Chambers | Alabama | 1017 | 282 | 17 |
81256 | 81256 | 2020-04-23 | Chambers | Alabama | 1017 | 275 | 16 |
78463 | 78463 | 2020-04-22 | Chambers | Alabama | 1017 | 270 | 16 |
75680 | 75680 | 2020-04-21 | Chambers | Alabama | 1017 | 259 | 16 |
72904 | 72904 | 2020-04-20 | Chambers | Alabama | 1017 | 257 | 13 |
70135 | 70135 | 2020-04-19 | Chambers | Alabama | 1017 | 246 | 14 |
67373 | 67373 | 2020-04-18 | Chambers | Alabama | 1017 | 240 | 11 |
64625 | 64625 | 2020-04-17 | Chambers | Alabama | 1017 | 236 | 11 |
61892 | 61892 | 2020-04-16 | Chambers | Alabama | 1017 | 234 | 11 |
59174 | 59174 | 2020-04-15 | Chambers | Alabama | 1017 | 227 | 10 |
56466 | 56466 | 2020-04-14 | Chambers | Alabama | 1017 | 216 | 10 |
53774 | 53774 | 2020-04-13 | Chambers | Alabama | 1017 | 212 | 8 |
51096 | 51096 | 2020-04-12 | Chambers | Alabama | 1017 | 200 | 8 |
48435 | 48435 | 2020-04-11 | Chambers | Alabama | 1017 | 184 | 8 |
45806 | 45806 | 2020-04-10 | Chambers | Alabama | 1017 | 171 | 8 |
43208 | 43208 | 2020-04-09 | Chambers | Alabama | 1017 | 161 | 8 |
40635 | 40635 | 2020-04-08 | Chambers | Alabama | 1017 | 140 | 8 |
38093 | 38093 | 2020-04-07 | Chambers | Alabama | 1017 | 102 | 8 |
35605 | 35605 | 2020-04-06 | Chambers | Alabama | 1017 | 96 | 7 |
33166 | 33166 | 2020-04-05 | Chambers | Alabama | 1017 | 90 | 6 |
30762 | 30762 | 2020-04-04 | Chambers | Alabama | 1017 | 87 | 6 |
28405 | 28405 | 2020-04-03 | Chambers | Alabama | 1017 | 81 | 5 |
26109 | 26109 | 2020-04-02 | Chambers | Alabama | 1017 | 67 | 4 |
23888 | 23888 | 2020-04-01 | Chambers | Alabama | 1017 | 45 | 4 |
21735 | 21735 | 2020-03-31 | Chambers | Alabama | 1017 | 36 | 4 |
19663 | 19663 | 2020-03-30 | Chambers | Alabama | 1017 | 36 | 4 |
17693 | 17693 | 2020-03-29 | Chambers | Alabama | 1017 | 27 | 1 |
15810 | 15810 | 2020-03-28 | Chambers | Alabama | 1017 | 17 | 0 |
14032 | 14032 | 2020-03-27 | Chambers | Alabama | 1017 | 15 | 0 |
12374 | 12374 | 2020-03-26 | Chambers | Alabama | 1017 | 13 | 0 |
10841 | 10841 | 2020-03-25 | Chambers | Alabama | 1017 | 10 | 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);