ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
773 rows where fips = 48351 and state = "Texas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
936215 | 936215 | 2021-01-16 | Newton | Texas | 48351 | 696 | 19 |
932970 | 932970 | 2021-01-15 | Newton | Texas | 48351 | 690 | 19 |
929725 | 929725 | 2021-01-14 | Newton | Texas | 48351 | 688 | 19 |
926480 | 926480 | 2021-01-13 | Newton | Texas | 48351 | 676 | 19 |
923234 | 923234 | 2021-01-12 | Newton | Texas | 48351 | 672 | 19 |
919989 | 919989 | 2021-01-11 | Newton | Texas | 48351 | 661 | 19 |
916744 | 916744 | 2021-01-10 | Newton | Texas | 48351 | 661 | 19 |
913499 | 913499 | 2021-01-09 | Newton | Texas | 48351 | 661 | 19 |
910254 | 910254 | 2021-01-08 | Newton | Texas | 48351 | 661 | 18 |
907009 | 907009 | 2021-01-07 | Newton | Texas | 48351 | 424 | 18 |
903763 | 903763 | 2021-01-06 | Newton | Texas | 48351 | 418 | 18 |
900518 | 900518 | 2021-01-05 | Newton | Texas | 48351 | 418 | 18 |
897273 | 897273 | 2021-01-04 | Newton | Texas | 48351 | 392 | 18 |
894027 | 894027 | 2021-01-03 | Newton | Texas | 48351 | 392 | 18 |
890781 | 890781 | 2021-01-02 | Newton | Texas | 48351 | 392 | 18 |
887534 | 887534 | 2021-01-01 | Newton | Texas | 48351 | 392 | 18 |
884289 | 884289 | 2020-12-31 | Newton | Texas | 48351 | 392 | 17 |
881044 | 881044 | 2020-12-30 | Newton | Texas | 48351 | 392 | 17 |
877799 | 877799 | 2020-12-29 | Newton | Texas | 48351 | 384 | 17 |
874554 | 874554 | 2020-12-28 | Newton | Texas | 48351 | 368 | 17 |
871309 | 871309 | 2020-12-27 | Newton | Texas | 48351 | 368 | 17 |
868064 | 868064 | 2020-12-26 | Newton | Texas | 48351 | 368 | 17 |
864819 | 864819 | 2020-12-25 | Newton | Texas | 48351 | 368 | 17 |
861574 | 861574 | 2020-12-24 | Newton | Texas | 48351 | 368 | 17 |
858329 | 858329 | 2020-12-23 | Newton | Texas | 48351 | 368 | 17 |
855084 | 855084 | 2020-12-22 | Newton | Texas | 48351 | 361 | 17 |
851839 | 851839 | 2020-12-21 | Newton | Texas | 48351 | 356 | 17 |
848594 | 848594 | 2020-12-20 | Newton | Texas | 48351 | 356 | 17 |
845349 | 845349 | 2020-12-19 | Newton | Texas | 48351 | 356 | 17 |
842103 | 842103 | 2020-12-18 | Newton | Texas | 48351 | 353 | 17 |
838858 | 838858 | 2020-12-17 | Newton | Texas | 48351 | 349 | 17 |
835612 | 835612 | 2020-12-16 | Newton | Texas | 48351 | 343 | 17 |
832366 | 832366 | 2020-12-15 | Newton | Texas | 48351 | 328 | 16 |
829119 | 829119 | 2020-12-14 | Newton | Texas | 48351 | 328 | 16 |
825873 | 825873 | 2020-12-13 | Newton | Texas | 48351 | 328 | 16 |
822626 | 822626 | 2020-12-12 | Newton | Texas | 48351 | 328 | 16 |
819380 | 819380 | 2020-12-11 | Newton | Texas | 48351 | 327 | 16 |
816134 | 816134 | 2020-12-10 | Newton | Texas | 48351 | 201 | 16 |
812888 | 812888 | 2020-12-09 | Newton | Texas | 48351 | 201 | 16 |
809644 | 809644 | 2020-12-08 | Newton | Texas | 48351 | 201 | 16 |
806399 | 806399 | 2020-12-07 | Newton | Texas | 48351 | 201 | 16 |
803154 | 803154 | 2020-12-06 | Newton | Texas | 48351 | 201 | 16 |
799909 | 799909 | 2020-12-05 | Newton | Texas | 48351 | 201 | 16 |
796664 | 796664 | 2020-12-04 | Newton | Texas | 48351 | 201 | 16 |
793419 | 793419 | 2020-12-03 | Newton | Texas | 48351 | 201 | 16 |
790174 | 790174 | 2020-12-02 | Newton | Texas | 48351 | 201 | 16 |
786929 | 786929 | 2020-12-01 | Newton | Texas | 48351 | 200 | 16 |
783685 | 783685 | 2020-11-30 | Newton | Texas | 48351 | 199 | 16 |
780440 | 780440 | 2020-11-29 | Newton | Texas | 48351 | 199 | 16 |
777194 | 777194 | 2020-11-28 | Newton | Texas | 48351 | 199 | 16 |
773949 | 773949 | 2020-11-27 | Newton | Texas | 48351 | 199 | 16 |
770704 | 770704 | 2020-11-26 | Newton | Texas | 48351 | 199 | 16 |
767458 | 767458 | 2020-11-25 | Newton | Texas | 48351 | 198 | 16 |
764213 | 764213 | 2020-11-24 | Newton | Texas | 48351 | 197 | 16 |
760968 | 760968 | 2020-11-23 | Newton | Texas | 48351 | 195 | 16 |
757723 | 757723 | 2020-11-22 | Newton | Texas | 48351 | 195 | 16 |
754476 | 754476 | 2020-11-21 | Newton | Texas | 48351 | 195 | 16 |
751230 | 751230 | 2020-11-20 | Newton | Texas | 48351 | 195 | 16 |
747984 | 747984 | 2020-11-19 | Newton | Texas | 48351 | 193 | 16 |
744738 | 744738 | 2020-11-18 | Newton | Texas | 48351 | 192 | 16 |
741491 | 741491 | 2020-11-17 | Newton | Texas | 48351 | 192 | 15 |
738244 | 738244 | 2020-11-16 | Newton | Texas | 48351 | 192 | 15 |
735000 | 735000 | 2020-11-15 | Newton | Texas | 48351 | 192 | 15 |
731754 | 731754 | 2020-11-14 | Newton | Texas | 48351 | 192 | 15 |
728509 | 728509 | 2020-11-13 | Newton | Texas | 48351 | 192 | 15 |
725266 | 725266 | 2020-11-12 | Newton | Texas | 48351 | 190 | 15 |
722023 | 722023 | 2020-11-11 | Newton | Texas | 48351 | 190 | 15 |
718780 | 718780 | 2020-11-10 | Newton | Texas | 48351 | 190 | 15 |
715537 | 715537 | 2020-11-09 | Newton | Texas | 48351 | 190 | 14 |
712293 | 712293 | 2020-11-08 | Newton | Texas | 48351 | 190 | 14 |
709049 | 709049 | 2020-11-07 | Newton | Texas | 48351 | 190 | 14 |
705805 | 705805 | 2020-11-06 | Newton | Texas | 48351 | 190 | 14 |
702562 | 702562 | 2020-11-05 | Newton | Texas | 48351 | 190 | 14 |
699319 | 699319 | 2020-11-04 | Newton | Texas | 48351 | 190 | 14 |
696075 | 696075 | 2020-11-03 | Newton | Texas | 48351 | 190 | 14 |
692833 | 692833 | 2020-11-02 | Newton | Texas | 48351 | 189 | 14 |
689589 | 689589 | 2020-11-01 | Newton | Texas | 48351 | 189 | 14 |
686344 | 686344 | 2020-10-31 | Newton | Texas | 48351 | 189 | 14 |
683101 | 683101 | 2020-10-30 | Newton | Texas | 48351 | 188 | 14 |
679858 | 679858 | 2020-10-29 | Newton | Texas | 48351 | 188 | 14 |
676615 | 676615 | 2020-10-28 | Newton | Texas | 48351 | 188 | 13 |
673372 | 673372 | 2020-10-27 | Newton | Texas | 48351 | 188 | 13 |
670130 | 670130 | 2020-10-26 | Newton | Texas | 48351 | 188 | 13 |
666887 | 666887 | 2020-10-25 | Newton | Texas | 48351 | 188 | 13 |
663642 | 663642 | 2020-10-24 | Newton | Texas | 48351 | 188 | 13 |
660398 | 660398 | 2020-10-23 | Newton | Texas | 48351 | 188 | 13 |
657154 | 657154 | 2020-10-22 | Newton | Texas | 48351 | 188 | 13 |
653909 | 653909 | 2020-10-21 | Newton | Texas | 48351 | 188 | 13 |
650664 | 650664 | 2020-10-20 | Newton | Texas | 48351 | 188 | 13 |
647420 | 647420 | 2020-10-19 | Newton | Texas | 48351 | 187 | 13 |
644174 | 644174 | 2020-10-18 | Newton | Texas | 48351 | 187 | 13 |
640926 | 640926 | 2020-10-17 | Newton | Texas | 48351 | 187 | 13 |
637679 | 637679 | 2020-10-16 | Newton | Texas | 48351 | 187 | 13 |
634434 | 634434 | 2020-10-15 | Newton | Texas | 48351 | 187 | 13 |
631189 | 631189 | 2020-10-14 | Newton | Texas | 48351 | 187 | 13 |
627945 | 627945 | 2020-10-13 | Newton | Texas | 48351 | 187 | 13 |
624702 | 624702 | 2020-10-12 | Newton | Texas | 48351 | 187 | 13 |
621459 | 621459 | 2020-10-11 | Newton | Texas | 48351 | 187 | 13 |
618216 | 618216 | 2020-10-10 | Newton | Texas | 48351 | 187 | 13 |
614974 | 614974 | 2020-10-09 | Newton | Texas | 48351 | 187 | 13 |
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);