ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
765 rows where county = "McCulloch" and state = "Texas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
923218 | 923218 | 2021-01-12 | McCulloch | Texas | 48307 | 456 | 12 |
919973 | 919973 | 2021-01-11 | McCulloch | Texas | 48307 | 455 | 12 |
916728 | 916728 | 2021-01-10 | McCulloch | Texas | 48307 | 455 | 12 |
913483 | 913483 | 2021-01-09 | McCulloch | Texas | 48307 | 454 | 12 |
910238 | 910238 | 2021-01-08 | McCulloch | Texas | 48307 | 453 | 12 |
906993 | 906993 | 2021-01-07 | McCulloch | Texas | 48307 | 447 | 12 |
903747 | 903747 | 2021-01-06 | McCulloch | Texas | 48307 | 444 | 12 |
900502 | 900502 | 2021-01-05 | McCulloch | Texas | 48307 | 453 | 12 |
897257 | 897257 | 2021-01-04 | McCulloch | Texas | 48307 | 452 | 12 |
894011 | 894011 | 2021-01-03 | McCulloch | Texas | 48307 | 452 | 12 |
890765 | 890765 | 2021-01-02 | McCulloch | Texas | 48307 | 452 | 12 |
887518 | 887518 | 2021-01-01 | McCulloch | Texas | 48307 | 448 | 12 |
884273 | 884273 | 2020-12-31 | McCulloch | Texas | 48307 | 447 | 12 |
881028 | 881028 | 2020-12-30 | McCulloch | Texas | 48307 | 437 | 12 |
877783 | 877783 | 2020-12-29 | McCulloch | Texas | 48307 | 437 | 11 |
874538 | 874538 | 2020-12-28 | McCulloch | Texas | 48307 | 434 | 11 |
871293 | 871293 | 2020-12-27 | McCulloch | Texas | 48307 | 434 | 11 |
868048 | 868048 | 2020-12-26 | McCulloch | Texas | 48307 | 434 | 11 |
864803 | 864803 | 2020-12-25 | McCulloch | Texas | 48307 | 431 | 11 |
861558 | 861558 | 2020-12-24 | McCulloch | Texas | 48307 | 435 | 11 |
858313 | 858313 | 2020-12-23 | McCulloch | Texas | 48307 | 430 | 11 |
855068 | 855068 | 2020-12-22 | McCulloch | Texas | 48307 | 426 | 10 |
851823 | 851823 | 2020-12-21 | McCulloch | Texas | 48307 | 424 | 10 |
848578 | 848578 | 2020-12-20 | McCulloch | Texas | 48307 | 424 | 10 |
845333 | 845333 | 2020-12-19 | McCulloch | Texas | 48307 | 424 | 10 |
842087 | 842087 | 2020-12-18 | McCulloch | Texas | 48307 | 423 | 10 |
838842 | 838842 | 2020-12-17 | McCulloch | Texas | 48307 | 419 | 9 |
835596 | 835596 | 2020-12-16 | McCulloch | Texas | 48307 | 412 | 9 |
832350 | 832350 | 2020-12-15 | McCulloch | Texas | 48307 | 405 | 9 |
829103 | 829103 | 2020-12-14 | McCulloch | Texas | 48307 | 402 | 9 |
825857 | 825857 | 2020-12-13 | McCulloch | Texas | 48307 | 398 | 9 |
822610 | 822610 | 2020-12-12 | McCulloch | Texas | 48307 | 391 | 9 |
819364 | 819364 | 2020-12-11 | McCulloch | Texas | 48307 | 351 | 8 |
816118 | 816118 | 2020-12-10 | McCulloch | Texas | 48307 | 278 | 8 |
812872 | 812872 | 2020-12-09 | McCulloch | Texas | 48307 | 277 | 8 |
809628 | 809628 | 2020-12-08 | McCulloch | Texas | 48307 | 286 | 7 |
806383 | 806383 | 2020-12-07 | McCulloch | Texas | 48307 | 286 | 7 |
803138 | 803138 | 2020-12-06 | McCulloch | Texas | 48307 | 286 | 7 |
799893 | 799893 | 2020-12-05 | McCulloch | Texas | 48307 | 285 | 6 |
796648 | 796648 | 2020-12-04 | McCulloch | Texas | 48307 | 282 | 6 |
793403 | 793403 | 2020-12-03 | McCulloch | Texas | 48307 | 279 | 6 |
790158 | 790158 | 2020-12-02 | McCulloch | Texas | 48307 | 279 | 6 |
786913 | 786913 | 2020-12-01 | McCulloch | Texas | 48307 | 279 | 6 |
783669 | 783669 | 2020-11-30 | McCulloch | Texas | 48307 | 279 | 6 |
780424 | 780424 | 2020-11-29 | McCulloch | Texas | 48307 | 277 | 6 |
777178 | 777178 | 2020-11-28 | McCulloch | Texas | 48307 | 276 | 6 |
773933 | 773933 | 2020-11-27 | McCulloch | Texas | 48307 | 270 | 6 |
770688 | 770688 | 2020-11-26 | McCulloch | Texas | 48307 | 290 | 6 |
767442 | 767442 | 2020-11-25 | McCulloch | Texas | 48307 | 290 | 6 |
764197 | 764197 | 2020-11-24 | McCulloch | Texas | 48307 | 284 | 6 |
760952 | 760952 | 2020-11-23 | McCulloch | Texas | 48307 | 280 | 6 |
757707 | 757707 | 2020-11-22 | McCulloch | Texas | 48307 | 279 | 6 |
754460 | 754460 | 2020-11-21 | McCulloch | Texas | 48307 | 277 | 6 |
751214 | 751214 | 2020-11-20 | McCulloch | Texas | 48307 | 274 | 6 |
747968 | 747968 | 2020-11-19 | McCulloch | Texas | 48307 | 269 | 6 |
744722 | 744722 | 2020-11-18 | McCulloch | Texas | 48307 | 263 | 6 |
741475 | 741475 | 2020-11-17 | McCulloch | Texas | 48307 | 261 | 6 |
738228 | 738228 | 2020-11-16 | McCulloch | Texas | 48307 | 236 | 6 |
734984 | 734984 | 2020-11-15 | McCulloch | Texas | 48307 | 236 | 6 |
731738 | 731738 | 2020-11-14 | McCulloch | Texas | 48307 | 236 | 6 |
728493 | 728493 | 2020-11-13 | McCulloch | Texas | 48307 | 343 | 5 |
725250 | 725250 | 2020-11-12 | McCulloch | Texas | 48307 | 235 | 5 |
722007 | 722007 | 2020-11-11 | McCulloch | Texas | 48307 | 233 | 5 |
718764 | 718764 | 2020-11-10 | McCulloch | Texas | 48307 | 227 | 5 |
715521 | 715521 | 2020-11-09 | McCulloch | Texas | 48307 | 227 | 5 |
712277 | 712277 | 2020-11-08 | McCulloch | Texas | 48307 | 227 | 5 |
709033 | 709033 | 2020-11-07 | McCulloch | Texas | 48307 | 227 | 5 |
705789 | 705789 | 2020-11-06 | McCulloch | Texas | 48307 | 227 | 5 |
702546 | 702546 | 2020-11-05 | McCulloch | Texas | 48307 | 225 | 5 |
699303 | 699303 | 2020-11-04 | McCulloch | Texas | 48307 | 223 | 5 |
696059 | 696059 | 2020-11-03 | McCulloch | Texas | 48307 | 222 | 5 |
692817 | 692817 | 2020-11-02 | McCulloch | Texas | 48307 | 220 | 5 |
689573 | 689573 | 2020-11-01 | McCulloch | Texas | 48307 | 220 | 5 |
686328 | 686328 | 2020-10-31 | McCulloch | Texas | 48307 | 220 | 5 |
683085 | 683085 | 2020-10-30 | McCulloch | Texas | 48307 | 216 | 5 |
679842 | 679842 | 2020-10-29 | McCulloch | Texas | 48307 | 212 | 5 |
676599 | 676599 | 2020-10-28 | McCulloch | Texas | 48307 | 209 | 4 |
673356 | 673356 | 2020-10-27 | McCulloch | Texas | 48307 | 206 | 4 |
670114 | 670114 | 2020-10-26 | McCulloch | Texas | 48307 | 202 | 4 |
666871 | 666871 | 2020-10-25 | McCulloch | Texas | 48307 | 202 | 4 |
663626 | 663626 | 2020-10-24 | McCulloch | Texas | 48307 | 202 | 4 |
660382 | 660382 | 2020-10-23 | McCulloch | Texas | 48307 | 196 | 4 |
657138 | 657138 | 2020-10-22 | McCulloch | Texas | 48307 | 194 | 4 |
653893 | 653893 | 2020-10-21 | McCulloch | Texas | 48307 | 194 | 4 |
650648 | 650648 | 2020-10-20 | McCulloch | Texas | 48307 | 190 | 4 |
647404 | 647404 | 2020-10-19 | McCulloch | Texas | 48307 | 187 | 4 |
644158 | 644158 | 2020-10-18 | McCulloch | Texas | 48307 | 187 | 4 |
640910 | 640910 | 2020-10-17 | McCulloch | Texas | 48307 | 187 | 4 |
637663 | 637663 | 2020-10-16 | McCulloch | Texas | 48307 | 183 | 4 |
634418 | 634418 | 2020-10-15 | McCulloch | Texas | 48307 | 183 | 4 |
631173 | 631173 | 2020-10-14 | McCulloch | Texas | 48307 | 181 | 4 |
627929 | 627929 | 2020-10-13 | McCulloch | Texas | 48307 | 179 | 4 |
624686 | 624686 | 2020-10-12 | McCulloch | Texas | 48307 | 174 | 4 |
621443 | 621443 | 2020-10-11 | McCulloch | Texas | 48307 | 174 | 4 |
618200 | 618200 | 2020-10-10 | McCulloch | Texas | 48307 | 174 | 4 |
614958 | 614958 | 2020-10-09 | McCulloch | Texas | 48307 | 174 | 4 |
611717 | 611717 | 2020-10-08 | McCulloch | Texas | 48307 | 172 | 4 |
608475 | 608475 | 2020-10-07 | McCulloch | Texas | 48307 | 172 | 4 |
605232 | 605232 | 2020-10-06 | McCulloch | Texas | 48307 | 172 | 4 |
601990 | 601990 | 2020-10-05 | McCulloch | Texas | 48307 | 168 | 4 |
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);