ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
786 rows where county = "Mobile" and state = "Alabama" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
917241 | 917241 | 2021-01-11 | Mobile | Alabama | 1097 | 28793 | 527 |
913996 | 913996 | 2021-01-10 | Mobile | Alabama | 1097 | 28584 | 523 |
910751 | 910751 | 2021-01-09 | Mobile | Alabama | 1097 | 28266 | 523 |
907506 | 907506 | 2021-01-08 | Mobile | Alabama | 1097 | 28034 | 521 |
904260 | 904260 | 2021-01-07 | Mobile | Alabama | 1097 | 27708 | 518 |
901015 | 901015 | 2021-01-06 | Mobile | Alabama | 1097 | 27343 | 513 |
897770 | 897770 | 2021-01-05 | Mobile | Alabama | 1097 | 27099 | 511 |
894524 | 894524 | 2021-01-04 | Mobile | Alabama | 1097 | 26854 | 510 |
891278 | 891278 | 2021-01-03 | Mobile | Alabama | 1097 | 26677 | 508 |
888031 | 888031 | 2021-01-02 | Mobile | Alabama | 1097 | 26431 | 508 |
884786 | 884786 | 2021-01-01 | Mobile | Alabama | 1097 | 26151 | 508 |
881541 | 881541 | 2020-12-31 | Mobile | Alabama | 1097 | 25858 | 506 |
878296 | 878296 | 2020-12-30 | Mobile | Alabama | 1097 | 25635 | 494 |
875051 | 875051 | 2020-12-29 | Mobile | Alabama | 1097 | 25353 | 491 |
871806 | 871806 | 2020-12-28 | Mobile | Alabama | 1097 | 25171 | 489 |
868561 | 868561 | 2020-12-27 | Mobile | Alabama | 1097 | 24933 | 487 |
865316 | 865316 | 2020-12-26 | Mobile | Alabama | 1097 | 24668 | 487 |
862071 | 862071 | 2020-12-25 | Mobile | Alabama | 1097 | 24578 | 482 |
858826 | 858826 | 2020-12-24 | Mobile | Alabama | 1097 | 24325 | 481 |
855581 | 855581 | 2020-12-23 | Mobile | Alabama | 1097 | 24002 | 468 |
852336 | 852336 | 2020-12-22 | Mobile | Alabama | 1097 | 23754 | 439 |
849091 | 849091 | 2020-12-21 | Mobile | Alabama | 1097 | 23627 | 415 |
845846 | 845846 | 2020-12-20 | Mobile | Alabama | 1097 | 23463 | 415 |
842600 | 842600 | 2020-12-19 | Mobile | Alabama | 1097 | 23224 | 415 |
839355 | 839355 | 2020-12-18 | Mobile | Alabama | 1097 | 23078 | 392 |
836110 | 836110 | 2020-12-17 | Mobile | Alabama | 1097 | 22829 | 392 |
832864 | 832864 | 2020-12-16 | Mobile | Alabama | 1097 | 22651 | 390 |
829617 | 829617 | 2020-12-15 | Mobile | Alabama | 1097 | 22488 | 389 |
826371 | 826371 | 2020-12-14 | Mobile | Alabama | 1097 | 22294 | 389 |
823124 | 823124 | 2020-12-13 | Mobile | Alabama | 1097 | 22169 | 389 |
819878 | 819878 | 2020-12-12 | Mobile | Alabama | 1097 | 22034 | 389 |
816632 | 816632 | 2020-12-11 | Mobile | Alabama | 1097 | 21937 | 387 |
813386 | 813386 | 2020-12-10 | Mobile | Alabama | 1097 | 21704 | 386 |
810142 | 810142 | 2020-12-09 | Mobile | Alabama | 1097 | 21480 | 384 |
806897 | 806897 | 2020-12-08 | Mobile | Alabama | 1097 | 21257 | 383 |
803652 | 803652 | 2020-12-07 | Mobile | Alabama | 1097 | 21166 | 380 |
800407 | 800407 | 2020-12-06 | Mobile | Alabama | 1097 | 20869 | 379 |
797162 | 797162 | 2020-12-05 | Mobile | Alabama | 1097 | 20764 | 377 |
793917 | 793917 | 2020-12-04 | Mobile | Alabama | 1097 | 20626 | 372 |
790672 | 790672 | 2020-12-03 | Mobile | Alabama | 1097 | 20452 | 370 |
787427 | 787427 | 2020-12-02 | Mobile | Alabama | 1097 | 20299 | 366 |
784183 | 784183 | 2020-12-01 | Mobile | Alabama | 1097 | 20103 | 365 |
780938 | 780938 | 2020-11-30 | Mobile | Alabama | 1097 | 19951 | 362 |
777692 | 777692 | 2020-11-29 | Mobile | Alabama | 1097 | 19904 | 362 |
774447 | 774447 | 2020-11-28 | Mobile | Alabama | 1097 | 19859 | 361 |
771202 | 771202 | 2020-11-27 | Mobile | Alabama | 1097 | 19687 | 361 |
767956 | 767956 | 2020-11-26 | Mobile | Alabama | 1097 | 19651 | 361 |
764711 | 764711 | 2020-11-25 | Mobile | Alabama | 1097 | 19562 | 361 |
761466 | 761466 | 2020-11-24 | Mobile | Alabama | 1097 | 19446 | 360 |
758221 | 758221 | 2020-11-23 | Mobile | Alabama | 1097 | 19306 | 358 |
754974 | 754974 | 2020-11-22 | Mobile | Alabama | 1097 | 19260 | 356 |
751728 | 751728 | 2020-11-21 | Mobile | Alabama | 1097 | 19189 | 356 |
748482 | 748482 | 2020-11-20 | Mobile | Alabama | 1097 | 19090 | 356 |
745236 | 745236 | 2020-11-19 | Mobile | Alabama | 1097 | 18966 | 356 |
741989 | 741989 | 2020-11-18 | Mobile | Alabama | 1097 | 18834 | 354 |
738742 | 738742 | 2020-11-17 | Mobile | Alabama | 1097 | 18696 | 342 |
735498 | 735498 | 2020-11-16 | Mobile | Alabama | 1097 | 18565 | 340 |
732252 | 732252 | 2020-11-15 | Mobile | Alabama | 1097 | 18524 | 339 |
729007 | 729007 | 2020-11-14 | Mobile | Alabama | 1097 | 18445 | 337 |
725764 | 725764 | 2020-11-13 | Mobile | Alabama | 1097 | 18319 | 336 |
722521 | 722521 | 2020-11-12 | Mobile | Alabama | 1097 | 18228 | 334 |
719278 | 719278 | 2020-11-11 | Mobile | Alabama | 1097 | 18089 | 334 |
716035 | 716035 | 2020-11-10 | Mobile | Alabama | 1097 | 17998 | 334 |
712791 | 712791 | 2020-11-09 | Mobile | Alabama | 1097 | 17807 | 328 |
709547 | 709547 | 2020-11-08 | Mobile | Alabama | 1097 | 17782 | 328 |
706303 | 706303 | 2020-11-07 | Mobile | Alabama | 1097 | 17729 | 327 |
703060 | 703060 | 2020-11-06 | Mobile | Alabama | 1097 | 17667 | 325 |
699817 | 699817 | 2020-11-05 | Mobile | Alabama | 1097 | 17591 | 324 |
696573 | 696573 | 2020-11-04 | Mobile | Alabama | 1097 | 17505 | 324 |
693331 | 693331 | 2020-11-03 | Mobile | Alabama | 1097 | 17406 | 323 |
690088 | 690088 | 2020-11-02 | Mobile | Alabama | 1097 | 17342 | 322 |
686843 | 686843 | 2020-11-01 | Mobile | Alabama | 1097 | 17298 | 322 |
683599 | 683599 | 2020-10-31 | Mobile | Alabama | 1097 | 17261 | 320 |
680356 | 680356 | 2020-10-30 | Mobile | Alabama | 1097 | 17166 | 319 |
677113 | 677113 | 2020-10-29 | Mobile | Alabama | 1097 | 17123 | 319 |
673870 | 673870 | 2020-10-28 | Mobile | Alabama | 1097 | 17039 | 318 |
670628 | 670628 | 2020-10-27 | Mobile | Alabama | 1097 | 16994 | 316 |
667385 | 667385 | 2020-10-26 | Mobile | Alabama | 1097 | 16934 | 315 |
664140 | 664140 | 2020-10-25 | Mobile | Alabama | 1097 | 16916 | 315 |
660896 | 660896 | 2020-10-24 | Mobile | Alabama | 1097 | 16849 | 315 |
657652 | 657652 | 2020-10-23 | Mobile | Alabama | 1097 | 16788 | 315 |
654407 | 654407 | 2020-10-22 | Mobile | Alabama | 1097 | 14468 | 314 |
651162 | 651162 | 2020-10-21 | Mobile | Alabama | 1097 | 14405 | 314 |
647918 | 647918 | 2020-10-20 | Mobile | Alabama | 1097 | 14335 | 314 |
644673 | 644673 | 2020-10-19 | Mobile | Alabama | 1097 | 14282 | 314 |
641425 | 641425 | 2020-10-18 | Mobile | Alabama | 1097 | 14273 | 314 |
638178 | 638178 | 2020-10-17 | Mobile | Alabama | 1097 | 14217 | 314 |
634933 | 634933 | 2020-10-16 | Mobile | Alabama | 1097 | 14160 | 313 |
631688 | 631688 | 2020-10-15 | Mobile | Alabama | 1097 | 14120 | 313 |
628444 | 628444 | 2020-10-14 | Mobile | Alabama | 1097 | 14056 | 312 |
625201 | 625201 | 2020-10-13 | Mobile | Alabama | 1097 | 14023 | 309 |
621958 | 621958 | 2020-10-12 | Mobile | Alabama | 1097 | 13983 | 309 |
618715 | 618715 | 2020-10-11 | Mobile | Alabama | 1097 | 13954 | 308 |
615473 | 615473 | 2020-10-10 | Mobile | Alabama | 1097 | 13920 | 308 |
612232 | 612232 | 2020-10-09 | Mobile | Alabama | 1097 | 13871 | 308 |
608990 | 608990 | 2020-10-08 | Mobile | Alabama | 1097 | 13829 | 308 |
605747 | 605747 | 2020-10-07 | Mobile | Alabama | 1097 | 13811 | 307 |
602505 | 602505 | 2020-10-06 | Mobile | Alabama | 1097 | 13778 | 300 |
599262 | 599262 | 2020-10-05 | Mobile | Alabama | 1097 | 13744 | 297 |
596019 | 596019 | 2020-10-04 | Mobile | Alabama | 1097 | 13739 | 296 |
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);