ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
792 rows where fips = 1125 and state = "Alabama" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
592791 | 592791 | 2020-10-03 | Tuscaloosa | Alabama | 1125 | 9131 | 119 |
589551 | 589551 | 2020-10-02 | Tuscaloosa | Alabama | 1125 | 9099 | 119 |
586310 | 586310 | 2020-10-01 | Tuscaloosa | Alabama | 1125 | 9040 | 118 |
583070 | 583070 | 2020-09-30 | Tuscaloosa | Alabama | 1125 | 9029 | 118 |
579831 | 579831 | 2020-09-29 | Tuscaloosa | Alabama | 1125 | 8837 | 118 |
576590 | 576590 | 2020-09-28 | Tuscaloosa | Alabama | 1125 | 8744 | 118 |
573346 | 573346 | 2020-09-27 | Tuscaloosa | Alabama | 1125 | 8654 | 118 |
570104 | 570104 | 2020-09-26 | Tuscaloosa | Alabama | 1125 | 8621 | 118 |
566863 | 566863 | 2020-09-25 | Tuscaloosa | Alabama | 1125 | 8586 | 117 |
563622 | 563622 | 2020-09-24 | Tuscaloosa | Alabama | 1125 | 7496 | 119 |
560383 | 560383 | 2020-09-23 | Tuscaloosa | Alabama | 1125 | 7418 | 116 |
557147 | 557147 | 2020-09-22 | Tuscaloosa | Alabama | 1125 | 7355 | 114 |
553910 | 553910 | 2020-09-21 | Tuscaloosa | Alabama | 1125 | 7323 | 114 |
550671 | 550671 | 2020-09-20 | Tuscaloosa | Alabama | 1125 | 7240 | 114 |
547432 | 547432 | 2020-09-19 | Tuscaloosa | Alabama | 1125 | 7180 | 114 |
544195 | 544195 | 2020-09-18 | Tuscaloosa | Alabama | 1125 | 7081 | 114 |
540959 | 540959 | 2020-09-17 | Tuscaloosa | Alabama | 1125 | 7015 | 112 |
537722 | 537722 | 2020-09-16 | Tuscaloosa | Alabama | 1125 | 6984 | 109 |
534486 | 534486 | 2020-09-15 | Tuscaloosa | Alabama | 1125 | 6842 | 109 |
531251 | 531251 | 2020-09-14 | Tuscaloosa | Alabama | 1125 | 6789 | 107 |
528014 | 528014 | 2020-09-13 | Tuscaloosa | Alabama | 1125 | 6724 | 107 |
524778 | 524778 | 2020-09-12 | Tuscaloosa | Alabama | 1125 | 6646 | 107 |
521542 | 521542 | 2020-09-11 | Tuscaloosa | Alabama | 1125 | 6590 | 107 |
518305 | 518305 | 2020-09-10 | Tuscaloosa | Alabama | 1125 | 6525 | 105 |
515070 | 515070 | 2020-09-09 | Tuscaloosa | Alabama | 1125 | 6445 | 104 |
511837 | 511837 | 2020-09-08 | Tuscaloosa | Alabama | 1125 | 6379 | 104 |
508604 | 508604 | 2020-09-07 | Tuscaloosa | Alabama | 1125 | 6285 | 104 |
505372 | 505372 | 2020-09-06 | Tuscaloosa | Alabama | 1125 | 6244 | 104 |
502138 | 502138 | 2020-09-05 | Tuscaloosa | Alabama | 1125 | 6215 | 104 |
498904 | 498904 | 2020-09-04 | Tuscaloosa | Alabama | 1125 | 6124 | 104 |
495671 | 495671 | 2020-09-03 | Tuscaloosa | Alabama | 1125 | 6047 | 100 |
492437 | 492437 | 2020-09-02 | Tuscaloosa | Alabama | 1125 | 5970 | 100 |
489204 | 489204 | 2020-09-01 | Tuscaloosa | Alabama | 1125 | 5949 | 100 |
485971 | 485971 | 2020-08-31 | Tuscaloosa | Alabama | 1125 | 5877 | 100 |
482736 | 482736 | 2020-08-30 | Tuscaloosa | Alabama | 1125 | 5848 | 97 |
479502 | 479502 | 2020-08-29 | Tuscaloosa | Alabama | 1125 | 5774 | 96 |
476269 | 476269 | 2020-08-28 | Tuscaloosa | Alabama | 1125 | 5665 | 94 |
473036 | 473036 | 2020-08-27 | Tuscaloosa | Alabama | 1125 | 5541 | 93 |
469804 | 469804 | 2020-08-26 | Tuscaloosa | Alabama | 1125 | 5331 | 91 |
466575 | 466575 | 2020-08-25 | Tuscaloosa | Alabama | 1125 | 5178 | 90 |
463346 | 463346 | 2020-08-24 | Tuscaloosa | Alabama | 1125 | 5163 | 89 |
460117 | 460117 | 2020-08-23 | Tuscaloosa | Alabama | 1125 | 4994 | 89 |
456890 | 456890 | 2020-08-22 | Tuscaloosa | Alabama | 1125 | 4971 | 89 |
453662 | 453662 | 2020-08-21 | Tuscaloosa | Alabama | 1125 | 4910 | 89 |
450434 | 450434 | 2020-08-20 | Tuscaloosa | Alabama | 1125 | 4850 | 89 |
447206 | 447206 | 2020-08-19 | Tuscaloosa | Alabama | 1125 | 4800 | 88 |
443979 | 443979 | 2020-08-18 | Tuscaloosa | Alabama | 1125 | 4697 | 88 |
440753 | 440753 | 2020-08-17 | Tuscaloosa | Alabama | 1125 | 4639 | 88 |
437527 | 437527 | 2020-08-16 | Tuscaloosa | Alabama | 1125 | 4593 | 82 |
434301 | 434301 | 2020-08-15 | Tuscaloosa | Alabama | 1125 | 4554 | 82 |
431076 | 431076 | 2020-08-14 | Tuscaloosa | Alabama | 1125 | 4519 | 82 |
427848 | 427848 | 2020-08-13 | Tuscaloosa | Alabama | 1125 | 4487 | 82 |
424624 | 424624 | 2020-08-12 | Tuscaloosa | Alabama | 1125 | 4458 | 82 |
421403 | 421403 | 2020-08-11 | Tuscaloosa | Alabama | 1125 | 4402 | 81 |
418182 | 418182 | 2020-08-10 | Tuscaloosa | Alabama | 1125 | 4363 | 80 |
414961 | 414961 | 2020-08-09 | Tuscaloosa | Alabama | 1125 | 4344 | 75 |
411741 | 411741 | 2020-08-08 | Tuscaloosa | Alabama | 1125 | 4316 | 75 |
408522 | 408522 | 2020-08-07 | Tuscaloosa | Alabama | 1125 | 4221 | 73 |
405302 | 405302 | 2020-08-06 | Tuscaloosa | Alabama | 1125 | 4174 | 71 |
402084 | 402084 | 2020-08-05 | Tuscaloosa | Alabama | 1125 | 4099 | 71 |
398868 | 398868 | 2020-08-04 | Tuscaloosa | Alabama | 1125 | 4065 | 68 |
395652 | 395652 | 2020-08-03 | Tuscaloosa | Alabama | 1125 | 4048 | 65 |
392436 | 392436 | 2020-08-02 | Tuscaloosa | Alabama | 1125 | 3988 | 65 |
389219 | 389219 | 2020-08-01 | Tuscaloosa | Alabama | 1125 | 3927 | 63 |
386002 | 386002 | 2020-07-31 | Tuscaloosa | Alabama | 1125 | 3873 | 63 |
382784 | 382784 | 2020-07-30 | Tuscaloosa | Alabama | 1125 | 3822 | 63 |
379567 | 379567 | 2020-07-29 | Tuscaloosa | Alabama | 1125 | 3759 | 63 |
376351 | 376351 | 2020-07-28 | Tuscaloosa | Alabama | 1125 | 3731 | 60 |
373137 | 373137 | 2020-07-27 | Tuscaloosa | Alabama | 1125 | 3686 | 60 |
369925 | 369925 | 2020-07-26 | Tuscaloosa | Alabama | 1125 | 3576 | 60 |
366715 | 366715 | 2020-07-25 | Tuscaloosa | Alabama | 1125 | 3542 | 60 |
363508 | 363508 | 2020-07-24 | Tuscaloosa | Alabama | 1125 | 3440 | 59 |
360302 | 360302 | 2020-07-23 | Tuscaloosa | Alabama | 1125 | 3356 | 59 |
357097 | 357097 | 2020-07-22 | Tuscaloosa | Alabama | 1125 | 3308 | 59 |
353894 | 353894 | 2020-07-21 | Tuscaloosa | Alabama | 1125 | 3273 | 57 |
350692 | 350692 | 2020-07-20 | Tuscaloosa | Alabama | 1125 | 3240 | 57 |
347491 | 347491 | 2020-07-19 | Tuscaloosa | Alabama | 1125 | 3177 | 57 |
344291 | 344291 | 2020-07-18 | Tuscaloosa | Alabama | 1125 | 3092 | 57 |
341092 | 341092 | 2020-07-17 | Tuscaloosa | Alabama | 1125 | 3018 | 57 |
337896 | 337896 | 2020-07-16 | Tuscaloosa | Alabama | 1125 | 2955 | 56 |
334701 | 334701 | 2020-07-15 | Tuscaloosa | Alabama | 1125 | 2861 | 56 |
331508 | 331508 | 2020-07-14 | Tuscaloosa | Alabama | 1125 | 2799 | 56 |
328322 | 328322 | 2020-07-13 | Tuscaloosa | Alabama | 1125 | 2765 | 55 |
325136 | 325136 | 2020-07-12 | Tuscaloosa | Alabama | 1125 | 2712 | 55 |
321955 | 321955 | 2020-07-11 | Tuscaloosa | Alabama | 1125 | 2654 | 55 |
318776 | 318776 | 2020-07-10 | Tuscaloosa | Alabama | 1125 | 2608 | 54 |
315603 | 315603 | 2020-07-09 | Tuscaloosa | Alabama | 1125 | 2566 | 50 |
312428 | 312428 | 2020-07-08 | Tuscaloosa | Alabama | 1125 | 2405 | 50 |
309259 | 309259 | 2020-07-07 | Tuscaloosa | Alabama | 1125 | 2368 | 46 |
306090 | 306090 | 2020-07-06 | Tuscaloosa | Alabama | 1125 | 2342 | 44 |
302926 | 302926 | 2020-07-05 | Tuscaloosa | Alabama | 1125 | 2309 | 44 |
299762 | 299762 | 2020-07-04 | Tuscaloosa | Alabama | 1125 | 2247 | 44 |
296600 | 296600 | 2020-07-03 | Tuscaloosa | Alabama | 1125 | 2209 | 44 |
293445 | 293445 | 2020-07-02 | Tuscaloosa | Alabama | 1125 | 2129 | 41 |
290292 | 290292 | 2020-07-01 | Tuscaloosa | Alabama | 1125 | 2071 | 40 |
287142 | 287142 | 2020-06-30 | Tuscaloosa | Alabama | 1125 | 1986 | 38 |
283996 | 283996 | 2020-06-29 | Tuscaloosa | Alabama | 1125 | 1946 | 38 |
280850 | 280850 | 2020-06-28 | Tuscaloosa | Alabama | 1125 | 1866 | 38 |
277702 | 277702 | 2020-06-27 | Tuscaloosa | Alabama | 1125 | 1860 | 38 |
274554 | 274554 | 2020-06-26 | Tuscaloosa | Alabama | 1125 | 1814 | 37 |
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);