ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
796 rows where county = "Collin", fips = 48085 and state = "Texas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
923101 | 923101 | 2021-01-12 | Collin | Texas | 48085 | 58968 | 428 |
919856 | 919856 | 2021-01-11 | Collin | Texas | 48085 | 57870 | 422 |
916611 | 916611 | 2021-01-10 | Collin | Texas | 48085 | 56988 | 422 |
913366 | 913366 | 2021-01-09 | Collin | Texas | 48085 | 56236 | 416 |
910121 | 910121 | 2021-01-08 | Collin | Texas | 48085 | 55259 | 405 |
906876 | 906876 | 2021-01-07 | Collin | Texas | 48085 | 54623 | 397 |
903630 | 903630 | 2021-01-06 | Collin | Texas | 48085 | 53731 | 388 |
900385 | 900385 | 2021-01-05 | Collin | Texas | 48085 | 52695 | 382 |
897140 | 897140 | 2021-01-04 | Collin | Texas | 48085 | 51408 | 380 |
893894 | 893894 | 2021-01-03 | Collin | Texas | 48085 | 50954 | 378 |
890648 | 890648 | 2021-01-02 | Collin | Texas | 48085 | 50012 | 377 |
887401 | 887401 | 2021-01-01 | Collin | Texas | 48085 | 49393 | 373 |
884156 | 884156 | 2020-12-31 | Collin | Texas | 48085 | 48423 | 370 |
880911 | 880911 | 2020-12-30 | Collin | Texas | 48085 | 47757 | 365 |
877666 | 877666 | 2020-12-29 | Collin | Texas | 48085 | 47197 | 357 |
874421 | 874421 | 2020-12-28 | Collin | Texas | 48085 | 46018 | 351 |
871176 | 871176 | 2020-12-27 | Collin | Texas | 48085 | 45600 | 351 |
867931 | 867931 | 2020-12-26 | Collin | Texas | 48085 | 45092 | 350 |
864686 | 864686 | 2020-12-25 | Collin | Texas | 48085 | 44070 | 350 |
861441 | 861441 | 2020-12-24 | Collin | Texas | 48085 | 44070 | 345 |
858196 | 858196 | 2020-12-23 | Collin | Texas | 48085 | 43169 | 340 |
854951 | 854951 | 2020-12-22 | Collin | Texas | 48085 | 41965 | 334 |
851706 | 851706 | 2020-12-21 | Collin | Texas | 48085 | 40900 | 326 |
848461 | 848461 | 2020-12-20 | Collin | Texas | 48085 | 40153 | 326 |
845216 | 845216 | 2020-12-19 | Collin | Texas | 48085 | 39728 | 323 |
841970 | 841970 | 2020-12-18 | Collin | Texas | 48085 | 39127 | 322 |
838725 | 838725 | 2020-12-17 | Collin | Texas | 48085 | 38228 | 311 |
835479 | 835479 | 2020-12-16 | Collin | Texas | 48085 | 37433 | 309 |
832233 | 832233 | 2020-12-15 | Collin | Texas | 48085 | 36640 | 302 |
828986 | 828986 | 2020-12-14 | Collin | Texas | 48085 | 35794 | 300 |
825740 | 825740 | 2020-12-13 | Collin | Texas | 48085 | 35186 | 300 |
822493 | 822493 | 2020-12-12 | Collin | Texas | 48085 | 34709 | 298 |
819247 | 819247 | 2020-12-11 | Collin | Texas | 48085 | 33946 | 295 |
816001 | 816001 | 2020-12-10 | Collin | Texas | 48085 | 30763 | 291 |
812755 | 812755 | 2020-12-09 | Collin | Texas | 48085 | 30232 | 288 |
809511 | 809511 | 2020-12-08 | Collin | Texas | 48085 | 29797 | 284 |
806266 | 806266 | 2020-12-07 | Collin | Texas | 48085 | 29554 | 279 |
803021 | 803021 | 2020-12-06 | Collin | Texas | 48085 | 29239 | 277 |
799776 | 799776 | 2020-12-05 | Collin | Texas | 48085 | 28547 | 277 |
796531 | 796531 | 2020-12-04 | Collin | Texas | 48085 | 28105 | 272 |
793286 | 793286 | 2020-12-03 | Collin | Texas | 48085 | 27848 | 266 |
790041 | 790041 | 2020-12-02 | Collin | Texas | 48085 | 27553 | 261 |
786796 | 786796 | 2020-12-01 | Collin | Texas | 48085 | 26990 | 256 |
783552 | 783552 | 2020-11-30 | Collin | Texas | 48085 | 26600 | 253 |
780307 | 780307 | 2020-11-29 | Collin | Texas | 48085 | 26192 | 253 |
777061 | 777061 | 2020-11-28 | Collin | Texas | 48085 | 25566 | 252 |
773816 | 773816 | 2020-11-27 | Collin | Texas | 48085 | 25153 | 251 |
770571 | 770571 | 2020-11-26 | Collin | Texas | 48085 | 24882 | 248 |
767325 | 767325 | 2020-11-25 | Collin | Texas | 48085 | 24571 | 245 |
764080 | 764080 | 2020-11-24 | Collin | Texas | 48085 | 24325 | 241 |
760835 | 760835 | 2020-11-23 | Collin | Texas | 48085 | 23784 | 239 |
757590 | 757590 | 2020-11-22 | Collin | Texas | 48085 | 23381 | 238 |
754343 | 754343 | 2020-11-21 | Collin | Texas | 48085 | 22691 | 238 |
751097 | 751097 | 2020-11-20 | Collin | Texas | 48085 | 22369 | 234 |
747851 | 747851 | 2020-11-19 | Collin | Texas | 48085 | 22337 | 229 |
744605 | 744605 | 2020-11-18 | Collin | Texas | 48085 | 21983 | 225 |
741358 | 741358 | 2020-11-17 | Collin | Texas | 48085 | 21689 | 222 |
738112 | 738112 | 2020-11-16 | Collin | Texas | 48085 | 21665 | 218 |
734868 | 734868 | 2020-11-15 | Collin | Texas | 48085 | 21665 | 218 |
731622 | 731622 | 2020-11-14 | Collin | Texas | 48085 | 21431 | 213 |
728377 | 728377 | 2020-11-13 | Collin | Texas | 48085 | 21264 | 209 |
725134 | 725134 | 2020-11-12 | Collin | Texas | 48085 | 21034 | 207 |
721891 | 721891 | 2020-11-11 | Collin | Texas | 48085 | 20888 | 205 |
718648 | 718648 | 2020-11-10 | Collin | Texas | 48085 | 20460 | 201 |
715405 | 715405 | 2020-11-09 | Collin | Texas | 48085 | 20313 | 200 |
712161 | 712161 | 2020-11-08 | Collin | Texas | 48085 | 20165 | 200 |
708917 | 708917 | 2020-11-07 | Collin | Texas | 48085 | 19810 | 199 |
705673 | 705673 | 2020-11-06 | Collin | Texas | 48085 | 19701 | 198 |
702430 | 702430 | 2020-11-05 | Collin | Texas | 48085 | 19480 | 196 |
699187 | 699187 | 2020-11-04 | Collin | Texas | 48085 | 19189 | 193 |
695943 | 695943 | 2020-11-03 | Collin | Texas | 48085 | 18905 | 190 |
692701 | 692701 | 2020-11-02 | Collin | Texas | 48085 | 18844 | 189 |
689457 | 689457 | 2020-11-01 | Collin | Texas | 48085 | 18748 | 188 |
686212 | 686212 | 2020-10-31 | Collin | Texas | 48085 | 18635 | 186 |
682969 | 682969 | 2020-10-30 | Collin | Texas | 48085 | 18362 | 184 |
679726 | 679726 | 2020-10-29 | Collin | Texas | 48085 | 18247 | 181 |
676483 | 676483 | 2020-10-28 | Collin | Texas | 48085 | 18015 | 180 |
673240 | 673240 | 2020-10-27 | Collin | Texas | 48085 | 17883 | 177 |
669998 | 669998 | 2020-10-26 | Collin | Texas | 48085 | 17768 | 175 |
666755 | 666755 | 2020-10-25 | Collin | Texas | 48085 | 17690 | 175 |
663510 | 663510 | 2020-10-24 | Collin | Texas | 48085 | 17611 | 175 |
660266 | 660266 | 2020-10-23 | Collin | Texas | 48085 | 17248 | 174 |
657022 | 657022 | 2020-10-22 | Collin | Texas | 48085 | 17122 | 173 |
653777 | 653777 | 2020-10-21 | Collin | Texas | 48085 | 17122 | 173 |
650532 | 650532 | 2020-10-20 | Collin | Texas | 48085 | 17048 | 172 |
647288 | 647288 | 2020-10-19 | Collin | Texas | 48085 | 16937 | 171 |
644042 | 644042 | 2020-10-18 | Collin | Texas | 48085 | 16937 | 171 |
640794 | 640794 | 2020-10-17 | Collin | Texas | 48085 | 16862 | 170 |
637547 | 637547 | 2020-10-16 | Collin | Texas | 48085 | 16751 | 169 |
634302 | 634302 | 2020-10-15 | Collin | Texas | 48085 | 16588 | 168 |
631057 | 631057 | 2020-10-14 | Collin | Texas | 48085 | 16488 | 167 |
627813 | 627813 | 2020-10-13 | Collin | Texas | 48085 | 16384 | 166 |
624571 | 624571 | 2020-10-12 | Collin | Texas | 48085 | 16282 | 166 |
621328 | 621328 | 2020-10-11 | Collin | Texas | 48085 | 16208 | 165 |
618085 | 618085 | 2020-10-10 | Collin | Texas | 48085 | 16151 | 164 |
614843 | 614843 | 2020-10-09 | Collin | Texas | 48085 | 16006 | 162 |
611602 | 611602 | 2020-10-08 | Collin | Texas | 48085 | 15923 | 161 |
608360 | 608360 | 2020-10-07 | Collin | Texas | 48085 | 15814 | 158 |
605117 | 605117 | 2020-10-06 | Collin | Texas | 48085 | 15736 | 155 |
601875 | 601875 | 2020-10-05 | Collin | Texas | 48085 | 15610 | 152 |
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);