ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
780 rows where fips = 1013 and state = "Alabama" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
382728 | 382728 | 2020-07-30 | Butler | Alabama | 1013 | 747 | 36 |
379511 | 379511 | 2020-07-29 | Butler | Alabama | 1013 | 742 | 36 |
376295 | 376295 | 2020-07-28 | Butler | Alabama | 1013 | 734 | 36 |
373081 | 373081 | 2020-07-27 | Butler | Alabama | 1013 | 730 | 36 |
369869 | 369869 | 2020-07-26 | Butler | Alabama | 1013 | 724 | 35 |
366659 | 366659 | 2020-07-25 | Butler | Alabama | 1013 | 720 | 35 |
363452 | 363452 | 2020-07-24 | Butler | Alabama | 1013 | 711 | 35 |
360246 | 360246 | 2020-07-23 | Butler | Alabama | 1013 | 706 | 35 |
357041 | 357041 | 2020-07-22 | Butler | Alabama | 1013 | 701 | 34 |
353838 | 353838 | 2020-07-21 | Butler | Alabama | 1013 | 695 | 34 |
350636 | 350636 | 2020-07-20 | Butler | Alabama | 1013 | 689 | 33 |
347435 | 347435 | 2020-07-19 | Butler | Alabama | 1013 | 686 | 33 |
344235 | 344235 | 2020-07-18 | Butler | Alabama | 1013 | 678 | 33 |
341036 | 341036 | 2020-07-17 | Butler | Alabama | 1013 | 672 | 33 |
337840 | 337840 | 2020-07-16 | Butler | Alabama | 1013 | 669 | 32 |
334645 | 334645 | 2020-07-15 | Butler | Alabama | 1013 | 664 | 31 |
331452 | 331452 | 2020-07-14 | Butler | Alabama | 1013 | 661 | 31 |
328266 | 328266 | 2020-07-13 | Butler | Alabama | 1013 | 660 | 29 |
325080 | 325080 | 2020-07-12 | Butler | Alabama | 1013 | 655 | 29 |
321899 | 321899 | 2020-07-11 | Butler | Alabama | 1013 | 654 | 29 |
318720 | 318720 | 2020-07-10 | Butler | Alabama | 1013 | 648 | 29 |
315547 | 315547 | 2020-07-09 | Butler | Alabama | 1013 | 646 | 28 |
312372 | 312372 | 2020-07-08 | Butler | Alabama | 1013 | 639 | 28 |
309203 | 309203 | 2020-07-07 | Butler | Alabama | 1013 | 634 | 28 |
306034 | 306034 | 2020-07-06 | Butler | Alabama | 1013 | 636 | 28 |
302870 | 302870 | 2020-07-05 | Butler | Alabama | 1013 | 635 | 28 |
299706 | 299706 | 2020-07-04 | Butler | Alabama | 1013 | 626 | 28 |
296544 | 296544 | 2020-07-03 | Butler | Alabama | 1013 | 625 | 28 |
293389 | 293389 | 2020-07-02 | Butler | Alabama | 1013 | 610 | 27 |
290236 | 290236 | 2020-07-01 | Butler | Alabama | 1013 | 607 | 27 |
287086 | 287086 | 2020-06-30 | Butler | Alabama | 1013 | 607 | 27 |
283940 | 283940 | 2020-06-29 | Butler | Alabama | 1013 | 605 | 27 |
280794 | 280794 | 2020-06-28 | Butler | Alabama | 1013 | 602 | 27 |
277646 | 277646 | 2020-06-27 | Butler | Alabama | 1013 | 600 | 27 |
274498 | 274498 | 2020-06-26 | Butler | Alabama | 1013 | 594 | 27 |
271358 | 271358 | 2020-06-25 | Butler | Alabama | 1013 | 588 | 27 |
268224 | 268224 | 2020-06-24 | Butler | Alabama | 1013 | 584 | 27 |
265095 | 265095 | 2020-06-23 | Butler | Alabama | 1013 | 581 | 27 |
261966 | 261966 | 2020-06-22 | Butler | Alabama | 1013 | 578 | 26 |
258839 | 258839 | 2020-06-21 | Butler | Alabama | 1013 | 576 | 26 |
255712 | 255712 | 2020-06-20 | Butler | Alabama | 1013 | 572 | 26 |
252593 | 252593 | 2020-06-19 | Butler | Alabama | 1013 | 569 | 26 |
249478 | 249478 | 2020-06-18 | Butler | Alabama | 1013 | 566 | 25 |
246366 | 246366 | 2020-06-17 | Butler | Alabama | 1013 | 554 | 25 |
243253 | 243253 | 2020-06-16 | Butler | Alabama | 1013 | 551 | 25 |
240142 | 240142 | 2020-06-15 | Butler | Alabama | 1013 | 544 | 25 |
237034 | 237034 | 2020-06-14 | Butler | Alabama | 1013 | 539 | 25 |
233927 | 233927 | 2020-06-13 | Butler | Alabama | 1013 | 520 | 25 |
230822 | 230822 | 2020-06-12 | Butler | Alabama | 1013 | 502 | 25 |
227718 | 227718 | 2020-06-11 | Butler | Alabama | 1013 | 487 | 25 |
224617 | 224617 | 2020-06-10 | Butler | Alabama | 1013 | 473 | 24 |
221521 | 221521 | 2020-06-09 | Butler | Alabama | 1013 | 466 | 24 |
218429 | 218429 | 2020-06-08 | Butler | Alabama | 1013 | 457 | 24 |
215339 | 215339 | 2020-06-07 | Butler | Alabama | 1013 | 451 | 22 |
212252 | 212252 | 2020-06-06 | Butler | Alabama | 1013 | 444 | 22 |
209167 | 209167 | 2020-06-05 | Butler | Alabama | 1013 | 433 | 21 |
206085 | 206085 | 2020-06-04 | Butler | Alabama | 1013 | 423 | 18 |
203006 | 203006 | 2020-06-03 | Butler | Alabama | 1013 | 421 | 18 |
199930 | 199930 | 2020-06-02 | Butler | Alabama | 1013 | 418 | 18 |
196857 | 196857 | 2020-06-01 | Butler | Alabama | 1013 | 416 | 18 |
193787 | 193787 | 2020-05-31 | Butler | Alabama | 1013 | 411 | 18 |
190721 | 190721 | 2020-05-30 | Butler | Alabama | 1013 | 402 | 17 |
187657 | 187657 | 2020-05-29 | Butler | Alabama | 1013 | 396 | 16 |
184600 | 184600 | 2020-05-28 | Butler | Alabama | 1013 | 392 | 13 |
181548 | 181548 | 2020-05-27 | Butler | Alabama | 1013 | 391 | 13 |
178504 | 178504 | 2020-05-26 | Butler | Alabama | 1013 | 380 | 13 |
175459 | 175459 | 2020-05-25 | Butler | Alabama | 1013 | 359 | 12 |
172416 | 172416 | 2020-05-24 | Butler | Alabama | 1013 | 344 | 11 |
169375 | 169375 | 2020-05-23 | Butler | Alabama | 1013 | 335 | 11 |
166339 | 166339 | 2020-05-22 | Butler | Alabama | 1013 | 329 | 11 |
163307 | 163307 | 2020-05-21 | Butler | Alabama | 1013 | 321 | 11 |
160279 | 160279 | 2020-05-20 | Butler | Alabama | 1013 | 312 | 11 |
157255 | 157255 | 2020-05-19 | Butler | Alabama | 1013 | 295 | 10 |
154239 | 154239 | 2020-05-18 | Butler | Alabama | 1013 | 285 | 10 |
151227 | 151227 | 2020-05-17 | Butler | Alabama | 1013 | 272 | 9 |
148218 | 148218 | 2020-05-16 | Butler | Alabama | 1013 | 271 | 9 |
145215 | 145215 | 2020-05-15 | Butler | Alabama | 1013 | 258 | 9 |
142216 | 142216 | 2020-05-14 | Butler | Alabama | 1013 | 249 | 8 |
139220 | 139220 | 2020-05-13 | Butler | Alabama | 1013 | 230 | 6 |
136229 | 136229 | 2020-05-12 | Butler | Alabama | 1013 | 224 | 6 |
133239 | 133239 | 2020-05-11 | Butler | Alabama | 1013 | 196 | 6 |
130249 | 130249 | 2020-05-10 | Butler | Alabama | 1013 | 189 | 6 |
127259 | 127259 | 2020-05-09 | Butler | Alabama | 1013 | 178 | 6 |
124274 | 124274 | 2020-05-08 | Butler | Alabama | 1013 | 162 | 3 |
121294 | 121294 | 2020-05-07 | Butler | Alabama | 1013 | 155 | 2 |
118328 | 118328 | 2020-05-06 | Butler | Alabama | 1013 | 130 | 2 |
115369 | 115369 | 2020-05-05 | Butler | Alabama | 1013 | 120 | 2 |
112486 | 112486 | 2020-05-04 | Butler | Alabama | 1013 | 114 | 1 |
109611 | 109611 | 2020-05-03 | Butler | Alabama | 1013 | 105 | 1 |
106742 | 106742 | 2020-05-02 | Butler | Alabama | 1013 | 92 | 1 |
103877 | 103877 | 2020-05-01 | Butler | Alabama | 1013 | 65 | 1 |
101022 | 101022 | 2020-04-30 | Butler | Alabama | 1013 | 53 | 1 |
98172 | 98172 | 2020-04-29 | Butler | Alabama | 1013 | 51 | 1 |
95327 | 95327 | 2020-04-28 | Butler | Alabama | 1013 | 45 | 1 |
92497 | 92497 | 2020-04-27 | Butler | Alabama | 1013 | 34 | 1 |
89679 | 89679 | 2020-04-26 | Butler | Alabama | 1013 | 32 | 1 |
86863 | 86863 | 2020-04-25 | Butler | Alabama | 1013 | 28 | 0 |
84055 | 84055 | 2020-04-24 | Butler | Alabama | 1013 | 21 | 0 |
81254 | 81254 | 2020-04-23 | Butler | Alabama | 1013 | 19 | 0 |
78461 | 78461 | 2020-04-22 | Butler | Alabama | 1013 | 17 | 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);