ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
790 rows where county = "Shelby" and state = "Alabama" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
382779 | 382779 | 2020-07-30 | Shelby | Alabama | 1117 | 2979 | 32 |
379562 | 379562 | 2020-07-29 | Shelby | Alabama | 1117 | 2922 | 31 |
376346 | 376346 | 2020-07-28 | Shelby | Alabama | 1117 | 2855 | 30 |
373132 | 373132 | 2020-07-27 | Shelby | Alabama | 1117 | 2810 | 30 |
369920 | 369920 | 2020-07-26 | Shelby | Alabama | 1117 | 2760 | 29 |
366710 | 366710 | 2020-07-25 | Shelby | Alabama | 1117 | 2712 | 29 |
363503 | 363503 | 2020-07-24 | Shelby | Alabama | 1117 | 2640 | 29 |
360297 | 360297 | 2020-07-23 | Shelby | Alabama | 1117 | 2555 | 29 |
357092 | 357092 | 2020-07-22 | Shelby | Alabama | 1117 | 2482 | 28 |
353889 | 353889 | 2020-07-21 | Shelby | Alabama | 1117 | 2417 | 28 |
350687 | 350687 | 2020-07-20 | Shelby | Alabama | 1117 | 2356 | 28 |
347486 | 347486 | 2020-07-19 | Shelby | Alabama | 1117 | 2275 | 28 |
344286 | 344286 | 2020-07-18 | Shelby | Alabama | 1117 | 2208 | 28 |
341087 | 341087 | 2020-07-17 | Shelby | Alabama | 1117 | 2110 | 28 |
337891 | 337891 | 2020-07-16 | Shelby | Alabama | 1117 | 2025 | 27 |
334696 | 334696 | 2020-07-15 | Shelby | Alabama | 1117 | 1923 | 27 |
331503 | 331503 | 2020-07-14 | Shelby | Alabama | 1117 | 1863 | 26 |
328317 | 328317 | 2020-07-13 | Shelby | Alabama | 1117 | 1803 | 25 |
325131 | 325131 | 2020-07-12 | Shelby | Alabama | 1117 | 1724 | 25 |
321950 | 321950 | 2020-07-11 | Shelby | Alabama | 1117 | 1674 | 25 |
318771 | 318771 | 2020-07-10 | Shelby | Alabama | 1117 | 1587 | 24 |
315598 | 315598 | 2020-07-09 | Shelby | Alabama | 1117 | 1535 | 24 |
312423 | 312423 | 2020-07-08 | Shelby | Alabama | 1117 | 1434 | 24 |
309254 | 309254 | 2020-07-07 | Shelby | Alabama | 1117 | 1376 | 24 |
306085 | 306085 | 2020-07-06 | Shelby | Alabama | 1117 | 1353 | 23 |
302921 | 302921 | 2020-07-05 | Shelby | Alabama | 1117 | 1303 | 23 |
299757 | 299757 | 2020-07-04 | Shelby | Alabama | 1117 | 1246 | 23 |
296595 | 296595 | 2020-07-03 | Shelby | Alabama | 1117 | 1195 | 23 |
293440 | 293440 | 2020-07-02 | Shelby | Alabama | 1117 | 1128 | 23 |
290287 | 290287 | 2020-07-01 | Shelby | Alabama | 1117 | 1103 | 23 |
287137 | 287137 | 2020-06-30 | Shelby | Alabama | 1117 | 1077 | 23 |
283991 | 283991 | 2020-06-29 | Shelby | Alabama | 1117 | 1039 | 23 |
280845 | 280845 | 2020-06-28 | Shelby | Alabama | 1117 | 972 | 23 |
277697 | 277697 | 2020-06-27 | Shelby | Alabama | 1117 | 963 | 23 |
274549 | 274549 | 2020-06-26 | Shelby | Alabama | 1117 | 934 | 23 |
271409 | 271409 | 2020-06-25 | Shelby | Alabama | 1117 | 897 | 23 |
268275 | 268275 | 2020-06-24 | Shelby | Alabama | 1117 | 862 | 23 |
265146 | 265146 | 2020-06-23 | Shelby | Alabama | 1117 | 830 | 22 |
262017 | 262017 | 2020-06-22 | Shelby | Alabama | 1117 | 798 | 22 |
258890 | 258890 | 2020-06-21 | Shelby | Alabama | 1117 | 784 | 22 |
255763 | 255763 | 2020-06-20 | Shelby | Alabama | 1117 | 778 | 22 |
252644 | 252644 | 2020-06-19 | Shelby | Alabama | 1117 | 759 | 21 |
249529 | 249529 | 2020-06-18 | Shelby | Alabama | 1117 | 730 | 20 |
246417 | 246417 | 2020-06-17 | Shelby | Alabama | 1117 | 706 | 20 |
243304 | 243304 | 2020-06-16 | Shelby | Alabama | 1117 | 693 | 20 |
240193 | 240193 | 2020-06-15 | Shelby | Alabama | 1117 | 674 | 20 |
237085 | 237085 | 2020-06-14 | Shelby | Alabama | 1117 | 656 | 20 |
233978 | 233978 | 2020-06-13 | Shelby | Alabama | 1117 | 634 | 20 |
230873 | 230873 | 2020-06-12 | Shelby | Alabama | 1117 | 615 | 20 |
227769 | 227769 | 2020-06-11 | Shelby | Alabama | 1117 | 599 | 20 |
224668 | 224668 | 2020-06-10 | Shelby | Alabama | 1117 | 586 | 20 |
221572 | 221572 | 2020-06-09 | Shelby | Alabama | 1117 | 579 | 20 |
218480 | 218480 | 2020-06-08 | Shelby | Alabama | 1117 | 573 | 19 |
215390 | 215390 | 2020-06-07 | Shelby | Alabama | 1117 | 568 | 19 |
212303 | 212303 | 2020-06-06 | Shelby | Alabama | 1117 | 561 | 19 |
209218 | 209218 | 2020-06-05 | Shelby | Alabama | 1117 | 555 | 19 |
206136 | 206136 | 2020-06-04 | Shelby | Alabama | 1117 | 547 | 19 |
203057 | 203057 | 2020-06-03 | Shelby | Alabama | 1117 | 541 | 20 |
199981 | 199981 | 2020-06-02 | Shelby | Alabama | 1117 | 541 | 20 |
196908 | 196908 | 2020-06-01 | Shelby | Alabama | 1117 | 541 | 20 |
193838 | 193838 | 2020-05-31 | Shelby | Alabama | 1117 | 517 | 20 |
190772 | 190772 | 2020-05-30 | Shelby | Alabama | 1117 | 503 | 19 |
187708 | 187708 | 2020-05-29 | Shelby | Alabama | 1117 | 497 | 19 |
184651 | 184651 | 2020-05-28 | Shelby | Alabama | 1117 | 484 | 19 |
181599 | 181599 | 2020-05-27 | Shelby | Alabama | 1117 | 470 | 19 |
178555 | 178555 | 2020-05-26 | Shelby | Alabama | 1117 | 467 | 19 |
175510 | 175510 | 2020-05-25 | Shelby | Alabama | 1117 | 447 | 19 |
172467 | 172467 | 2020-05-24 | Shelby | Alabama | 1117 | 433 | 19 |
169426 | 169426 | 2020-05-23 | Shelby | Alabama | 1117 | 427 | 19 |
166390 | 166390 | 2020-05-22 | Shelby | Alabama | 1117 | 420 | 19 |
163358 | 163358 | 2020-05-21 | Shelby | Alabama | 1117 | 419 | 19 |
160330 | 160330 | 2020-05-20 | Shelby | Alabama | 1117 | 414 | 19 |
157306 | 157306 | 2020-05-19 | Shelby | Alabama | 1117 | 404 | 19 |
154290 | 154290 | 2020-05-18 | Shelby | Alabama | 1117 | 404 | 19 |
151278 | 151278 | 2020-05-17 | Shelby | Alabama | 1117 | 399 | 19 |
148269 | 148269 | 2020-05-16 | Shelby | Alabama | 1117 | 398 | 19 |
145266 | 145266 | 2020-05-15 | Shelby | Alabama | 1117 | 391 | 19 |
142267 | 142267 | 2020-05-14 | Shelby | Alabama | 1117 | 390 | 19 |
139271 | 139271 | 2020-05-13 | Shelby | Alabama | 1117 | 381 | 18 |
136280 | 136280 | 2020-05-12 | Shelby | Alabama | 1117 | 378 | 18 |
133290 | 133290 | 2020-05-11 | Shelby | Alabama | 1117 | 370 | 17 |
130300 | 130300 | 2020-05-10 | Shelby | Alabama | 1117 | 367 | 17 |
127310 | 127310 | 2020-05-09 | Shelby | Alabama | 1117 | 362 | 17 |
124325 | 124325 | 2020-05-08 | Shelby | Alabama | 1117 | 358 | 17 |
121345 | 121345 | 2020-05-07 | Shelby | Alabama | 1117 | 348 | 16 |
118379 | 118379 | 2020-05-06 | Shelby | Alabama | 1117 | 339 | 16 |
115420 | 115420 | 2020-05-05 | Shelby | Alabama | 1117 | 335 | 13 |
112537 | 112537 | 2020-05-04 | Shelby | Alabama | 1117 | 328 | 13 |
109662 | 109662 | 2020-05-03 | Shelby | Alabama | 1117 | 327 | 13 |
106793 | 106793 | 2020-05-02 | Shelby | Alabama | 1117 | 324 | 13 |
103928 | 103928 | 2020-05-01 | Shelby | Alabama | 1117 | 320 | 13 |
101073 | 101073 | 2020-04-30 | Shelby | Alabama | 1117 | 320 | 12 |
98223 | 98223 | 2020-04-29 | Shelby | Alabama | 1117 | 320 | 11 |
95378 | 95378 | 2020-04-28 | Shelby | Alabama | 1117 | 319 | 10 |
92548 | 92548 | 2020-04-27 | Shelby | Alabama | 1117 | 318 | 9 |
89730 | 89730 | 2020-04-26 | Shelby | Alabama | 1117 | 311 | 9 |
86914 | 86914 | 2020-04-25 | Shelby | Alabama | 1117 | 298 | 8 |
84106 | 84106 | 2020-04-24 | Shelby | Alabama | 1117 | 294 | 7 |
81305 | 81305 | 2020-04-23 | Shelby | Alabama | 1117 | 283 | 7 |
78512 | 78512 | 2020-04-22 | Shelby | Alabama | 1117 | 278 | 7 |
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);