ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
790 rows where county = "Denton" and state = "Texas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
923120 | 923120 | 2021-01-12 | Denton | Texas | 48121 | 44158 | 402 |
919875 | 919875 | 2021-01-11 | Denton | Texas | 48121 | 43580 | 393 |
916630 | 916630 | 2021-01-10 | Denton | Texas | 48121 | 43107 | 393 |
913385 | 913385 | 2021-01-09 | Denton | Texas | 48121 | 43107 | 388 |
910140 | 910140 | 2021-01-08 | Denton | Texas | 48121 | 42708 | 378 |
906895 | 906895 | 2021-01-07 | Denton | Texas | 48121 | 42095 | 372 |
903649 | 903649 | 2021-01-06 | Denton | Texas | 48121 | 41409 | 366 |
900404 | 900404 | 2021-01-05 | Denton | Texas | 48121 | 40763 | 358 |
897159 | 897159 | 2021-01-04 | Denton | Texas | 48121 | 40202 | 355 |
893913 | 893913 | 2021-01-03 | Denton | Texas | 48121 | 39792 | 354 |
890667 | 890667 | 2021-01-02 | Denton | Texas | 48121 | 39792 | 353 |
887420 | 887420 | 2021-01-01 | Denton | Texas | 48121 | 39182 | 352 |
884175 | 884175 | 2020-12-31 | Denton | Texas | 48121 | 39182 | 348 |
880930 | 880930 | 2020-12-30 | Denton | Texas | 48121 | 38547 | 344 |
877685 | 877685 | 2020-12-29 | Denton | Texas | 48121 | 38094 | 334 |
874440 | 874440 | 2020-12-28 | Denton | Texas | 48121 | 37262 | 321 |
871195 | 871195 | 2020-12-27 | Denton | Texas | 48121 | 36813 | 320 |
867950 | 867950 | 2020-12-26 | Denton | Texas | 48121 | 36813 | 320 |
864705 | 864705 | 2020-12-25 | Denton | Texas | 48121 | 36303 | 320 |
861460 | 861460 | 2020-12-24 | Denton | Texas | 48121 | 36303 | 314 |
858215 | 858215 | 2020-12-23 | Denton | Texas | 48121 | 36303 | 312 |
854970 | 854970 | 2020-12-22 | Denton | Texas | 48121 | 35554 | 306 |
851725 | 851725 | 2020-12-21 | Denton | Texas | 48121 | 35030 | 299 |
848480 | 848480 | 2020-12-20 | Denton | Texas | 48121 | 34301 | 299 |
845235 | 845235 | 2020-12-19 | Denton | Texas | 48121 | 34301 | 294 |
841989 | 841989 | 2020-12-18 | Denton | Texas | 48121 | 33822 | 291 |
838744 | 838744 | 2020-12-17 | Denton | Texas | 48121 | 33121 | 282 |
835498 | 835498 | 2020-12-16 | Denton | Texas | 48121 | 32285 | 274 |
832252 | 832252 | 2020-12-15 | Denton | Texas | 48121 | 31587 | 270 |
829005 | 829005 | 2020-12-14 | Denton | Texas | 48121 | 30725 | 265 |
825759 | 825759 | 2020-12-13 | Denton | Texas | 48121 | 29886 | 264 |
822512 | 822512 | 2020-12-12 | Denton | Texas | 48121 | 29886 | 262 |
819266 | 819266 | 2020-12-11 | Denton | Texas | 48121 | 29463 | 256 |
816020 | 816020 | 2020-12-10 | Denton | Texas | 48121 | 28577 | 250 |
812774 | 812774 | 2020-12-09 | Denton | Texas | 48121 | 27897 | 248 |
809530 | 809530 | 2020-12-08 | Denton | Texas | 48121 | 27181 | 245 |
806285 | 806285 | 2020-12-07 | Denton | Texas | 48121 | 26623 | 243 |
803040 | 803040 | 2020-12-06 | Denton | Texas | 48121 | 26034 | 242 |
799795 | 799795 | 2020-12-05 | Denton | Texas | 48121 | 26034 | 242 |
796550 | 796550 | 2020-12-04 | Denton | Texas | 48121 | 25645 | 236 |
793305 | 793305 | 2020-12-03 | Denton | Texas | 48121 | 25094 | 227 |
790060 | 790060 | 2020-12-02 | Denton | Texas | 48121 | 24623 | 225 |
786815 | 786815 | 2020-12-01 | Denton | Texas | 48121 | 24133 | 221 |
783571 | 783571 | 2020-11-30 | Denton | Texas | 48121 | 23644 | 215 |
780326 | 780326 | 2020-11-29 | Denton | Texas | 48121 | 23276 | 215 |
777080 | 777080 | 2020-11-28 | Denton | Texas | 48121 | 23276 | 214 |
773835 | 773835 | 2020-11-27 | Denton | Texas | 48121 | 23094 | 211 |
770590 | 770590 | 2020-11-26 | Denton | Texas | 48121 | 22789 | 209 |
767344 | 767344 | 2020-11-25 | Denton | Texas | 48121 | 22789 | 208 |
764099 | 764099 | 2020-11-24 | Denton | Texas | 48121 | 22351 | 205 |
760854 | 760854 | 2020-11-23 | Denton | Texas | 48121 | 21937 | 202 |
757609 | 757609 | 2020-11-22 | Denton | Texas | 48121 | 21453 | 202 |
754362 | 754362 | 2020-11-21 | Denton | Texas | 48121 | 21453 | 200 |
751116 | 751116 | 2020-11-20 | Denton | Texas | 48121 | 21144 | 199 |
747870 | 747870 | 2020-11-19 | Denton | Texas | 48121 | 20739 | 199 |
744624 | 744624 | 2020-11-18 | Denton | Texas | 48121 | 20403 | 197 |
741377 | 741377 | 2020-11-17 | Denton | Texas | 48121 | 20151 | 196 |
738131 | 738131 | 2020-11-16 | Denton | Texas | 48121 | 19908 | 195 |
734887 | 734887 | 2020-11-15 | Denton | Texas | 48121 | 19573 | 195 |
731641 | 731641 | 2020-11-14 | Denton | Texas | 48121 | 19573 | 195 |
728396 | 728396 | 2020-11-13 | Denton | Texas | 48121 | 19322 | 195 |
725153 | 725153 | 2020-11-12 | Denton | Texas | 48121 | 19088 | 194 |
721910 | 721910 | 2020-11-11 | Denton | Texas | 48121 | 18892 | 190 |
718667 | 718667 | 2020-11-10 | Denton | Texas | 48121 | 18599 | 187 |
715424 | 715424 | 2020-11-09 | Denton | Texas | 48121 | 18390 | 185 |
712180 | 712180 | 2020-11-08 | Denton | Texas | 48121 | 18114 | 184 |
708936 | 708936 | 2020-11-07 | Denton | Texas | 48121 | 18114 | 182 |
705692 | 705692 | 2020-11-06 | Denton | Texas | 48121 | 18056 | 181 |
702449 | 702449 | 2020-11-05 | Denton | Texas | 48121 | 17842 | 179 |
699206 | 699206 | 2020-11-04 | Denton | Texas | 48121 | 17635 | 178 |
695962 | 695962 | 2020-11-03 | Denton | Texas | 48121 | 17435 | 178 |
692720 | 692720 | 2020-11-02 | Denton | Texas | 48121 | 17215 | 177 |
689476 | 689476 | 2020-11-01 | Denton | Texas | 48121 | 16978 | 177 |
686231 | 686231 | 2020-10-31 | Denton | Texas | 48121 | 16861 | 177 |
682988 | 682988 | 2020-10-30 | Denton | Texas | 48121 | 16861 | 177 |
679745 | 679745 | 2020-10-29 | Denton | Texas | 48121 | 16718 | 174 |
676502 | 676502 | 2020-10-28 | Denton | Texas | 48121 | 16592 | 174 |
673259 | 673259 | 2020-10-27 | Denton | Texas | 48121 | 16437 | 173 |
670017 | 670017 | 2020-10-26 | Denton | Texas | 48121 | 16273 | 171 |
666774 | 666774 | 2020-10-25 | Denton | Texas | 48121 | 16054 | 170 |
663529 | 663529 | 2020-10-24 | Denton | Texas | 48121 | 16054 | 169 |
660285 | 660285 | 2020-10-23 | Denton | Texas | 48121 | 15929 | 166 |
657041 | 657041 | 2020-10-22 | Denton | Texas | 48121 | 15722 | 166 |
653796 | 653796 | 2020-10-21 | Denton | Texas | 48121 | 15598 | 166 |
650551 | 650551 | 2020-10-20 | Denton | Texas | 48121 | 15429 | 166 |
647307 | 647307 | 2020-10-19 | Denton | Texas | 48121 | 15285 | 165 |
644061 | 644061 | 2020-10-18 | Denton | Texas | 48121 | 15132 | 165 |
640813 | 640813 | 2020-10-17 | Denton | Texas | 48121 | 15132 | 163 |
637566 | 637566 | 2020-10-16 | Denton | Texas | 48121 | 15009 | 162 |
634321 | 634321 | 2020-10-15 | Denton | Texas | 48121 | 14797 | 162 |
631076 | 631076 | 2020-10-14 | Denton | Texas | 48121 | 14654 | 162 |
627832 | 627832 | 2020-10-13 | Denton | Texas | 48121 | 14472 | 160 |
624590 | 624590 | 2020-10-12 | Denton | Texas | 48121 | 14347 | 158 |
621347 | 621347 | 2020-10-11 | Denton | Texas | 48121 | 14196 | 158 |
618104 | 618104 | 2020-10-10 | Denton | Texas | 48121 | 14196 | 158 |
614862 | 614862 | 2020-10-09 | Denton | Texas | 48121 | 14138 | 158 |
611621 | 611621 | 2020-10-08 | Denton | Texas | 48121 | 13993 | 158 |
608379 | 608379 | 2020-10-07 | Denton | Texas | 48121 | 13883 | 157 |
605136 | 605136 | 2020-10-06 | Denton | Texas | 48121 | 12567 | 157 |
601894 | 601894 | 2020-10-05 | Denton | Texas | 48121 | 12508 | 157 |
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);