ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
773 rows where fips = 48063 and state = "Texas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
923090 | 923090 | 2021-01-12 | Camp | Texas | 48063 | 912 | 29 |
919845 | 919845 | 2021-01-11 | Camp | Texas | 48063 | 897 | 28 |
916600 | 916600 | 2021-01-10 | Camp | Texas | 48063 | 872 | 28 |
913355 | 913355 | 2021-01-09 | Camp | Texas | 48063 | 870 | 28 |
910110 | 910110 | 2021-01-08 | Camp | Texas | 48063 | 848 | 28 |
906865 | 906865 | 2021-01-07 | Camp | Texas | 48063 | 826 | 28 |
903619 | 903619 | 2021-01-06 | Camp | Texas | 48063 | 824 | 26 |
900374 | 900374 | 2021-01-05 | Camp | Texas | 48063 | 814 | 26 |
897129 | 897129 | 2021-01-04 | Camp | Texas | 48063 | 812 | 26 |
893883 | 893883 | 2021-01-03 | Camp | Texas | 48063 | 803 | 26 |
890637 | 890637 | 2021-01-02 | Camp | Texas | 48063 | 782 | 26 |
887390 | 887390 | 2021-01-01 | Camp | Texas | 48063 | 771 | 25 |
884145 | 884145 | 2020-12-31 | Camp | Texas | 48063 | 766 | 23 |
880900 | 880900 | 2020-12-30 | Camp | Texas | 48063 | 758 | 23 |
877655 | 877655 | 2020-12-29 | Camp | Texas | 48063 | 751 | 23 |
874410 | 874410 | 2020-12-28 | Camp | Texas | 48063 | 749 | 23 |
871165 | 871165 | 2020-12-27 | Camp | Texas | 48063 | 747 | 23 |
867920 | 867920 | 2020-12-26 | Camp | Texas | 48063 | 733 | 23 |
864675 | 864675 | 2020-12-25 | Camp | Texas | 48063 | 724 | 23 |
861430 | 861430 | 2020-12-24 | Camp | Texas | 48063 | 723 | 23 |
858185 | 858185 | 2020-12-23 | Camp | Texas | 48063 | 714 | 23 |
854940 | 854940 | 2020-12-22 | Camp | Texas | 48063 | 707 | 21 |
851695 | 851695 | 2020-12-21 | Camp | Texas | 48063 | 708 | 21 |
848450 | 848450 | 2020-12-20 | Camp | Texas | 48063 | 703 | 21 |
845205 | 845205 | 2020-12-19 | Camp | Texas | 48063 | 685 | 21 |
841959 | 841959 | 2020-12-18 | Camp | Texas | 48063 | 668 | 20 |
838714 | 838714 | 2020-12-17 | Camp | Texas | 48063 | 665 | 20 |
835468 | 835468 | 2020-12-16 | Camp | Texas | 48063 | 658 | 19 |
832222 | 832222 | 2020-12-15 | Camp | Texas | 48063 | 659 | 19 |
828975 | 828975 | 2020-12-14 | Camp | Texas | 48063 | 658 | 18 |
825729 | 825729 | 2020-12-13 | Camp | Texas | 48063 | 658 | 18 |
822482 | 822482 | 2020-12-12 | Camp | Texas | 48063 | 653 | 16 |
819236 | 819236 | 2020-12-11 | Camp | Texas | 48063 | 647 | 16 |
815990 | 815990 | 2020-12-10 | Camp | Texas | 48063 | 494 | 16 |
812744 | 812744 | 2020-12-09 | Camp | Texas | 48063 | 491 | 16 |
809500 | 809500 | 2020-12-08 | Camp | Texas | 48063 | 491 | 15 |
806255 | 806255 | 2020-12-07 | Camp | Texas | 48063 | 484 | 15 |
803010 | 803010 | 2020-12-06 | Camp | Texas | 48063 | 484 | 15 |
799765 | 799765 | 2020-12-05 | Camp | Texas | 48063 | 483 | 15 |
796520 | 796520 | 2020-12-04 | Camp | Texas | 48063 | 474 | 15 |
793275 | 793275 | 2020-12-03 | Camp | Texas | 48063 | 472 | 15 |
790030 | 790030 | 2020-12-02 | Camp | Texas | 48063 | 464 | 15 |
786785 | 786785 | 2020-12-01 | Camp | Texas | 48063 | 451 | 15 |
783541 | 783541 | 2020-11-30 | Camp | Texas | 48063 | 449 | 15 |
780296 | 780296 | 2020-11-29 | Camp | Texas | 48063 | 449 | 15 |
777050 | 777050 | 2020-11-28 | Camp | Texas | 48063 | 449 | 15 |
773805 | 773805 | 2020-11-27 | Camp | Texas | 48063 | 449 | 15 |
770560 | 770560 | 2020-11-26 | Camp | Texas | 48063 | 449 | 15 |
767314 | 767314 | 2020-11-25 | Camp | Texas | 48063 | 447 | 15 |
764069 | 764069 | 2020-11-24 | Camp | Texas | 48063 | 445 | 15 |
760824 | 760824 | 2020-11-23 | Camp | Texas | 48063 | 441 | 15 |
757579 | 757579 | 2020-11-22 | Camp | Texas | 48063 | 441 | 15 |
754332 | 754332 | 2020-11-21 | Camp | Texas | 48063 | 441 | 15 |
751086 | 751086 | 2020-11-20 | Camp | Texas | 48063 | 441 | 15 |
747840 | 747840 | 2020-11-19 | Camp | Texas | 48063 | 436 | 15 |
744594 | 744594 | 2020-11-18 | Camp | Texas | 48063 | 435 | 15 |
741347 | 741347 | 2020-11-17 | Camp | Texas | 48063 | 432 | 15 |
738101 | 738101 | 2020-11-16 | Camp | Texas | 48063 | 432 | 14 |
734857 | 734857 | 2020-11-15 | Camp | Texas | 48063 | 430 | 14 |
731611 | 731611 | 2020-11-14 | Camp | Texas | 48063 | 425 | 14 |
728366 | 728366 | 2020-11-13 | Camp | Texas | 48063 | 425 | 14 |
725123 | 725123 | 2020-11-12 | Camp | Texas | 48063 | 424 | 13 |
721880 | 721880 | 2020-11-11 | Camp | Texas | 48063 | 424 | 13 |
718637 | 718637 | 2020-11-10 | Camp | Texas | 48063 | 424 | 13 |
715394 | 715394 | 2020-11-09 | Camp | Texas | 48063 | 420 | 13 |
712150 | 712150 | 2020-11-08 | Camp | Texas | 48063 | 420 | 13 |
708906 | 708906 | 2020-11-07 | Camp | Texas | 48063 | 412 | 13 |
705662 | 705662 | 2020-11-06 | Camp | Texas | 48063 | 412 | 13 |
702419 | 702419 | 2020-11-05 | Camp | Texas | 48063 | 411 | 13 |
699176 | 699176 | 2020-11-04 | Camp | Texas | 48063 | 410 | 13 |
695932 | 695932 | 2020-11-03 | Camp | Texas | 48063 | 408 | 13 |
692690 | 692690 | 2020-11-02 | Camp | Texas | 48063 | 407 | 13 |
689446 | 689446 | 2020-11-01 | Camp | Texas | 48063 | 407 | 13 |
686201 | 686201 | 2020-10-31 | Camp | Texas | 48063 | 406 | 13 |
682958 | 682958 | 2020-10-30 | Camp | Texas | 48063 | 405 | 13 |
679715 | 679715 | 2020-10-29 | Camp | Texas | 48063 | 399 | 13 |
676472 | 676472 | 2020-10-28 | Camp | Texas | 48063 | 399 | 13 |
673229 | 673229 | 2020-10-27 | Camp | Texas | 48063 | 399 | 13 |
669987 | 669987 | 2020-10-26 | Camp | Texas | 48063 | 391 | 13 |
666744 | 666744 | 2020-10-25 | Camp | Texas | 48063 | 391 | 13 |
663499 | 663499 | 2020-10-24 | Camp | Texas | 48063 | 391 | 13 |
660255 | 660255 | 2020-10-23 | Camp | Texas | 48063 | 390 | 13 |
657011 | 657011 | 2020-10-22 | Camp | Texas | 48063 | 388 | 13 |
653766 | 653766 | 2020-10-21 | Camp | Texas | 48063 | 388 | 13 |
650521 | 650521 | 2020-10-20 | Camp | Texas | 48063 | 388 | 13 |
647277 | 647277 | 2020-10-19 | Camp | Texas | 48063 | 384 | 13 |
644031 | 644031 | 2020-10-18 | Camp | Texas | 48063 | 383 | 13 |
640783 | 640783 | 2020-10-17 | Camp | Texas | 48063 | 383 | 13 |
637536 | 637536 | 2020-10-16 | Camp | Texas | 48063 | 381 | 13 |
634291 | 634291 | 2020-10-15 | Camp | Texas | 48063 | 379 | 12 |
631046 | 631046 | 2020-10-14 | Camp | Texas | 48063 | 376 | 12 |
627802 | 627802 | 2020-10-13 | Camp | Texas | 48063 | 376 | 12 |
624560 | 624560 | 2020-10-12 | Camp | Texas | 48063 | 371 | 12 |
621317 | 621317 | 2020-10-11 | Camp | Texas | 48063 | 369 | 12 |
618074 | 618074 | 2020-10-10 | Camp | Texas | 48063 | 369 | 12 |
614832 | 614832 | 2020-10-09 | Camp | Texas | 48063 | 369 | 12 |
611591 | 611591 | 2020-10-08 | Camp | Texas | 48063 | 369 | 12 |
608349 | 608349 | 2020-10-07 | Camp | Texas | 48063 | 369 | 11 |
605106 | 605106 | 2020-10-06 | Camp | Texas | 48063 | 366 | 11 |
601864 | 601864 | 2020-10-05 | Camp | Texas | 48063 | 363 | 11 |
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);