ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
786 rows where fips = 48467 and state = "Texas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
761026 | 761026 | 2020-11-23 | Van Zandt | Texas | 48467 | 1582 | 44 |
757781 | 757781 | 2020-11-22 | Van Zandt | Texas | 48467 | 1539 | 42 |
754534 | 754534 | 2020-11-21 | Van Zandt | Texas | 48467 | 1539 | 42 |
751288 | 751288 | 2020-11-20 | Van Zandt | Texas | 48467 | 1539 | 42 |
748042 | 748042 | 2020-11-19 | Van Zandt | Texas | 48467 | 1514 | 42 |
744796 | 744796 | 2020-11-18 | Van Zandt | Texas | 48467 | 1490 | 42 |
741549 | 741549 | 2020-11-17 | Van Zandt | Texas | 48467 | 1438 | 42 |
738302 | 738302 | 2020-11-16 | Van Zandt | Texas | 48467 | 1399 | 42 |
735058 | 735058 | 2020-11-15 | Van Zandt | Texas | 48467 | 1306 | 42 |
731812 | 731812 | 2020-11-14 | Van Zandt | Texas | 48467 | 1306 | 42 |
728567 | 728567 | 2020-11-13 | Van Zandt | Texas | 48467 | 1306 | 42 |
725324 | 725324 | 2020-11-12 | Van Zandt | Texas | 48467 | 1255 | 31 |
722081 | 722081 | 2020-11-11 | Van Zandt | Texas | 48467 | 1207 | 31 |
718838 | 718838 | 2020-11-10 | Van Zandt | Texas | 48467 | 1176 | 31 |
715595 | 715595 | 2020-11-09 | Van Zandt | Texas | 48467 | 1146 | 31 |
712351 | 712351 | 2020-11-08 | Van Zandt | Texas | 48467 | 1084 | 31 |
709107 | 709107 | 2020-11-07 | Van Zandt | Texas | 48467 | 1084 | 31 |
705863 | 705863 | 2020-11-06 | Van Zandt | Texas | 48467 | 1084 | 31 |
702620 | 702620 | 2020-11-05 | Van Zandt | Texas | 48467 | 1053 | 31 |
699377 | 699377 | 2020-11-04 | Van Zandt | Texas | 48467 | 1037 | 30 |
696133 | 696133 | 2020-11-03 | Van Zandt | Texas | 48467 | 982 | 30 |
692891 | 692891 | 2020-11-02 | Van Zandt | Texas | 48467 | 982 | 30 |
689647 | 689647 | 2020-11-01 | Van Zandt | Texas | 48467 | 966 | 30 |
686402 | 686402 | 2020-10-31 | Van Zandt | Texas | 48467 | 966 | 30 |
683159 | 683159 | 2020-10-30 | Van Zandt | Texas | 48467 | 966 | 30 |
679916 | 679916 | 2020-10-29 | Van Zandt | Texas | 48467 | 952 | 29 |
676673 | 676673 | 2020-10-28 | Van Zandt | Texas | 48467 | 944 | 29 |
673430 | 673430 | 2020-10-27 | Van Zandt | Texas | 48467 | 926 | 29 |
670188 | 670188 | 2020-10-26 | Van Zandt | Texas | 48467 | 907 | 29 |
666945 | 666945 | 2020-10-25 | Van Zandt | Texas | 48467 | 891 | 29 |
663700 | 663700 | 2020-10-24 | Van Zandt | Texas | 48467 | 891 | 29 |
660456 | 660456 | 2020-10-23 | Van Zandt | Texas | 48467 | 891 | 29 |
657212 | 657212 | 2020-10-22 | Van Zandt | Texas | 48467 | 871 | 29 |
653967 | 653967 | 2020-10-21 | Van Zandt | Texas | 48467 | 857 | 28 |
650722 | 650722 | 2020-10-20 | Van Zandt | Texas | 48467 | 850 | 28 |
647478 | 647478 | 2020-10-19 | Van Zandt | Texas | 48467 | 841 | 28 |
644232 | 644232 | 2020-10-18 | Van Zandt | Texas | 48467 | 829 | 28 |
640984 | 640984 | 2020-10-17 | Van Zandt | Texas | 48467 | 829 | 28 |
637737 | 637737 | 2020-10-16 | Van Zandt | Texas | 48467 | 829 | 28 |
634492 | 634492 | 2020-10-15 | Van Zandt | Texas | 48467 | 812 | 28 |
631247 | 631247 | 2020-10-14 | Van Zandt | Texas | 48467 | 806 | 28 |
628003 | 628003 | 2020-10-13 | Van Zandt | Texas | 48467 | 793 | 28 |
624760 | 624760 | 2020-10-12 | Van Zandt | Texas | 48467 | 781 | 28 |
621517 | 621517 | 2020-10-11 | Van Zandt | Texas | 48467 | 768 | 28 |
618274 | 618274 | 2020-10-10 | Van Zandt | Texas | 48467 | 768 | 28 |
615032 | 615032 | 2020-10-09 | Van Zandt | Texas | 48467 | 768 | 28 |
611791 | 611791 | 2020-10-08 | Van Zandt | Texas | 48467 | 756 | 28 |
608549 | 608549 | 2020-10-07 | Van Zandt | Texas | 48467 | 747 | 28 |
605306 | 605306 | 2020-10-06 | Van Zandt | Texas | 48467 | 736 | 27 |
602064 | 602064 | 2020-10-05 | Van Zandt | Texas | 48467 | 727 | 26 |
598821 | 598821 | 2020-10-04 | Van Zandt | Texas | 48467 | 716 | 26 |
595578 | 595578 | 2020-10-03 | Van Zandt | Texas | 48467 | 716 | 26 |
592336 | 592336 | 2020-10-02 | Van Zandt | Texas | 48467 | 716 | 26 |
589096 | 589096 | 2020-10-01 | Van Zandt | Texas | 48467 | 710 | 26 |
585855 | 585855 | 2020-09-30 | Van Zandt | Texas | 48467 | 705 | 26 |
582615 | 582615 | 2020-09-29 | Van Zandt | Texas | 48467 | 696 | 26 |
579376 | 579376 | 2020-09-28 | Van Zandt | Texas | 48467 | 689 | 26 |
576135 | 576135 | 2020-09-27 | Van Zandt | Texas | 48467 | 684 | 26 |
572891 | 572891 | 2020-09-26 | Van Zandt | Texas | 48467 | 684 | 26 |
569649 | 569649 | 2020-09-25 | Van Zandt | Texas | 48467 | 684 | 26 |
566408 | 566408 | 2020-09-24 | Van Zandt | Texas | 48467 | 682 | 26 |
563167 | 563167 | 2020-09-23 | Van Zandt | Texas | 48467 | 675 | 26 |
559928 | 559928 | 2020-09-22 | Van Zandt | Texas | 48467 | 668 | 26 |
556692 | 556692 | 2020-09-21 | Van Zandt | Texas | 48467 | 650 | 26 |
553455 | 553455 | 2020-09-20 | Van Zandt | Texas | 48467 | 568 | 18 |
550216 | 550216 | 2020-09-19 | Van Zandt | Texas | 48467 | 568 | 18 |
546977 | 546977 | 2020-09-18 | Van Zandt | Texas | 48467 | 565 | 18 |
543740 | 543740 | 2020-09-17 | Van Zandt | Texas | 48467 | 556 | 18 |
540504 | 540504 | 2020-09-16 | Van Zandt | Texas | 48467 | 555 | 18 |
537267 | 537267 | 2020-09-15 | Van Zandt | Texas | 48467 | 548 | 18 |
534031 | 534031 | 2020-09-14 | Van Zandt | Texas | 48467 | 540 | 18 |
530796 | 530796 | 2020-09-13 | Van Zandt | Texas | 48467 | 540 | 18 |
527559 | 527559 | 2020-09-12 | Van Zandt | Texas | 48467 | 540 | 18 |
524323 | 524323 | 2020-09-11 | Van Zandt | Texas | 48467 | 539 | 18 |
521087 | 521087 | 2020-09-10 | Van Zandt | Texas | 48467 | 532 | 18 |
517851 | 517851 | 2020-09-09 | Van Zandt | Texas | 48467 | 532 | 18 |
514616 | 514616 | 2020-09-08 | Van Zandt | Texas | 48467 | 528 | 18 |
511383 | 511383 | 2020-09-07 | Van Zandt | Texas | 48467 | 528 | 18 |
508150 | 508150 | 2020-09-06 | Van Zandt | Texas | 48467 | 528 | 18 |
504918 | 504918 | 2020-09-05 | Van Zandt | Texas | 48467 | 528 | 18 |
501684 | 501684 | 2020-09-04 | Van Zandt | Texas | 48467 | 527 | 18 |
498450 | 498450 | 2020-09-03 | Van Zandt | Texas | 48467 | 521 | 18 |
495217 | 495217 | 2020-09-02 | Van Zandt | Texas | 48467 | 521 | 18 |
491983 | 491983 | 2020-09-01 | Van Zandt | Texas | 48467 | 520 | 18 |
488750 | 488750 | 2020-08-31 | Van Zandt | Texas | 48467 | 516 | 18 |
485517 | 485517 | 2020-08-30 | Van Zandt | Texas | 48467 | 516 | 18 |
482282 | 482282 | 2020-08-29 | Van Zandt | Texas | 48467 | 516 | 18 |
479048 | 479048 | 2020-08-28 | Van Zandt | Texas | 48467 | 515 | 18 |
475815 | 475815 | 2020-08-27 | Van Zandt | Texas | 48467 | 511 | 14 |
472582 | 472582 | 2020-08-26 | Van Zandt | Texas | 48467 | 508 | 12 |
469350 | 469350 | 2020-08-25 | Van Zandt | Texas | 48467 | 499 | 12 |
466121 | 466121 | 2020-08-24 | Van Zandt | Texas | 48467 | 488 | 12 |
462892 | 462892 | 2020-08-23 | Van Zandt | Texas | 48467 | 488 | 12 |
459663 | 459663 | 2020-08-22 | Van Zandt | Texas | 48467 | 488 | 9 |
456436 | 456436 | 2020-08-21 | Van Zandt | Texas | 48467 | 485 | 9 |
453208 | 453208 | 2020-08-20 | Van Zandt | Texas | 48467 | 476 | 9 |
449980 | 449980 | 2020-08-19 | Van Zandt | Texas | 48467 | 469 | 9 |
446752 | 446752 | 2020-08-18 | Van Zandt | Texas | 48467 | 463 | 8 |
443525 | 443525 | 2020-08-17 | Van Zandt | Texas | 48467 | 446 | 8 |
440299 | 440299 | 2020-08-16 | Van Zandt | Texas | 48467 | 446 | 8 |
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);