ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
795 rows where county = "Montgomery" and state = "Texas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
923228 | 923228 | 2021-01-12 | Montgomery | Texas | 48339 | 31822 | 296 |
919983 | 919983 | 2021-01-11 | Montgomery | Texas | 48339 | 31099 | 287 |
916738 | 916738 | 2021-01-10 | Montgomery | Texas | 48339 | 29994 | 285 |
913493 | 913493 | 2021-01-09 | Montgomery | Texas | 48339 | 29994 | 284 |
910248 | 910248 | 2021-01-08 | Montgomery | Texas | 48339 | 29994 | 282 |
907003 | 907003 | 2021-01-07 | Montgomery | Texas | 48339 | 29648 | 278 |
903757 | 903757 | 2021-01-06 | Montgomery | Texas | 48339 | 29296 | 273 |
900512 | 900512 | 2021-01-05 | Montgomery | Texas | 48339 | 28812 | 267 |
897267 | 897267 | 2021-01-04 | Montgomery | Texas | 48339 | 28327 | 266 |
894021 | 894021 | 2021-01-03 | Montgomery | Texas | 48339 | 26650 | 265 |
890775 | 890775 | 2021-01-02 | Montgomery | Texas | 48339 | 26650 | 264 |
887528 | 887528 | 2021-01-01 | Montgomery | Texas | 48339 | 26650 | 264 |
884283 | 884283 | 2020-12-31 | Montgomery | Texas | 48339 | 26650 | 260 |
881038 | 881038 | 2020-12-30 | Montgomery | Texas | 48339 | 26650 | 258 |
877793 | 877793 | 2020-12-29 | Montgomery | Texas | 48339 | 26379 | 257 |
874548 | 874548 | 2020-12-28 | Montgomery | Texas | 48339 | 24366 | 256 |
871303 | 871303 | 2020-12-27 | Montgomery | Texas | 48339 | 24366 | 255 |
868058 | 868058 | 2020-12-26 | Montgomery | Texas | 48339 | 24366 | 255 |
864813 | 864813 | 2020-12-25 | Montgomery | Texas | 48339 | 24366 | 255 |
861568 | 861568 | 2020-12-24 | Montgomery | Texas | 48339 | 24366 | 255 |
858323 | 858323 | 2020-12-23 | Montgomery | Texas | 48339 | 24366 | 251 |
855078 | 855078 | 2020-12-22 | Montgomery | Texas | 48339 | 23838 | 249 |
851833 | 851833 | 2020-12-21 | Montgomery | Texas | 48339 | 23267 | 246 |
848588 | 848588 | 2020-12-20 | Montgomery | Texas | 48339 | 22578 | 245 |
845343 | 845343 | 2020-12-19 | Montgomery | Texas | 48339 | 22578 | 245 |
842097 | 842097 | 2020-12-18 | Montgomery | Texas | 48339 | 22578 | 244 |
838852 | 838852 | 2020-12-17 | Montgomery | Texas | 48339 | 22241 | 240 |
835606 | 835606 | 2020-12-16 | Montgomery | Texas | 48339 | 22007 | 237 |
832360 | 832360 | 2020-12-15 | Montgomery | Texas | 48339 | 21608 | 237 |
829113 | 829113 | 2020-12-14 | Montgomery | Texas | 48339 | 21208 | 233 |
825867 | 825867 | 2020-12-13 | Montgomery | Texas | 48339 | 20619 | 233 |
822620 | 822620 | 2020-12-12 | Montgomery | Texas | 48339 | 20619 | 230 |
819374 | 819374 | 2020-12-11 | Montgomery | Texas | 48339 | 20619 | 226 |
816128 | 816128 | 2020-12-10 | Montgomery | Texas | 48339 | 20252 | 222 |
812882 | 812882 | 2020-12-09 | Montgomery | Texas | 48339 | 20014 | 221 |
809638 | 809638 | 2020-12-08 | Montgomery | Texas | 48339 | 19784 | 217 |
806393 | 806393 | 2020-12-07 | Montgomery | Texas | 48339 | 19584 | 216 |
803148 | 803148 | 2020-12-06 | Montgomery | Texas | 48339 | 18934 | 216 |
799903 | 799903 | 2020-12-05 | Montgomery | Texas | 48339 | 18934 | 216 |
796658 | 796658 | 2020-12-04 | Montgomery | Texas | 48339 | 18934 | 216 |
793413 | 793413 | 2020-12-03 | Montgomery | Texas | 48339 | 18648 | 215 |
790168 | 790168 | 2020-12-02 | Montgomery | Texas | 48339 | 18430 | 214 |
786923 | 786923 | 2020-12-01 | Montgomery | Texas | 48339 | 18183 | 212 |
783679 | 783679 | 2020-11-30 | Montgomery | Texas | 48339 | 17915 | 212 |
780434 | 780434 | 2020-11-29 | Montgomery | Texas | 48339 | 16982 | 212 |
777188 | 777188 | 2020-11-28 | Montgomery | Texas | 48339 | 16982 | 212 |
773943 | 773943 | 2020-11-27 | Montgomery | Texas | 48339 | 16982 | 212 |
770698 | 770698 | 2020-11-26 | Montgomery | Texas | 48339 | 16982 | 211 |
767452 | 767452 | 2020-11-25 | Montgomery | Texas | 48339 | 16982 | 207 |
764207 | 764207 | 2020-11-24 | Montgomery | Texas | 48339 | 16789 | 206 |
760962 | 760962 | 2020-11-23 | Montgomery | Texas | 48339 | 16549 | 205 |
757717 | 757717 | 2020-11-22 | Montgomery | Texas | 48339 | 15920 | 204 |
754470 | 754470 | 2020-11-21 | Montgomery | Texas | 48339 | 15920 | 202 |
751224 | 751224 | 2020-11-20 | Montgomery | Texas | 48339 | 15920 | 202 |
747978 | 747978 | 2020-11-19 | Montgomery | Texas | 48339 | 15758 | 201 |
744732 | 744732 | 2020-11-18 | Montgomery | Texas | 48339 | 15428 | 199 |
741485 | 741485 | 2020-11-17 | Montgomery | Texas | 48339 | 15227 | 197 |
738238 | 738238 | 2020-11-16 | Montgomery | Texas | 48339 | 15095 | 194 |
734994 | 734994 | 2020-11-15 | Montgomery | Texas | 48339 | 14912 | 193 |
731748 | 731748 | 2020-11-14 | Montgomery | Texas | 48339 | 14912 | 193 |
728503 | 728503 | 2020-11-13 | Montgomery | Texas | 48339 | 14912 | 191 |
725260 | 725260 | 2020-11-12 | Montgomery | Texas | 48339 | 14793 | 190 |
722017 | 722017 | 2020-11-11 | Montgomery | Texas | 48339 | 14280 | 188 |
718774 | 718774 | 2020-11-10 | Montgomery | Texas | 48339 | 14280 | 188 |
715531 | 715531 | 2020-11-09 | Montgomery | Texas | 48339 | 14280 | 186 |
712287 | 712287 | 2020-11-08 | Montgomery | Texas | 48339 | 14280 | 185 |
709043 | 709043 | 2020-11-07 | Montgomery | Texas | 48339 | 14280 | 185 |
705799 | 705799 | 2020-11-06 | Montgomery | Texas | 48339 | 14280 | 185 |
702556 | 702556 | 2020-11-05 | Montgomery | Texas | 48339 | 14280 | 184 |
699313 | 699313 | 2020-11-04 | Montgomery | Texas | 48339 | 14224 | 183 |
696069 | 696069 | 2020-11-03 | Montgomery | Texas | 48339 | 14231 | 183 |
692827 | 692827 | 2020-11-02 | Montgomery | Texas | 48339 | 14227 | 183 |
689583 | 689583 | 2020-11-01 | Montgomery | Texas | 48339 | 14175 | 182 |
686338 | 686338 | 2020-10-31 | Montgomery | Texas | 48339 | 14175 | 182 |
683095 | 683095 | 2020-10-30 | Montgomery | Texas | 48339 | 14175 | 182 |
679852 | 679852 | 2020-10-29 | Montgomery | Texas | 48339 | 14076 | 179 |
676609 | 676609 | 2020-10-28 | Montgomery | Texas | 48339 | 13996 | 179 |
673366 | 673366 | 2020-10-27 | Montgomery | Texas | 48339 | 13917 | 178 |
670124 | 670124 | 2020-10-26 | Montgomery | Texas | 48339 | 13796 | 174 |
666881 | 666881 | 2020-10-25 | Montgomery | Texas | 48339 | 13575 | 173 |
663636 | 663636 | 2020-10-24 | Montgomery | Texas | 48339 | 13575 | 173 |
660392 | 660392 | 2020-10-23 | Montgomery | Texas | 48339 | 13575 | 172 |
657148 | 657148 | 2020-10-22 | Montgomery | Texas | 48339 | 13436 | 172 |
653903 | 653903 | 2020-10-21 | Montgomery | Texas | 48339 | 13224 | 172 |
650658 | 650658 | 2020-10-20 | Montgomery | Texas | 48339 | 13086 | 171 |
647414 | 647414 | 2020-10-19 | Montgomery | Texas | 48339 | 12991 | 170 |
644168 | 644168 | 2020-10-18 | Montgomery | Texas | 48339 | 12844 | 170 |
640920 | 640920 | 2020-10-17 | Montgomery | Texas | 48339 | 12844 | 169 |
637673 | 637673 | 2020-10-16 | Montgomery | Texas | 48339 | 12844 | 167 |
634428 | 634428 | 2020-10-15 | Montgomery | Texas | 48339 | 12747 | 167 |
631183 | 631183 | 2020-10-14 | Montgomery | Texas | 48339 | 12591 | 167 |
627939 | 627939 | 2020-10-13 | Montgomery | Texas | 48339 | 12496 | 167 |
624696 | 624696 | 2020-10-12 | Montgomery | Texas | 48339 | 12365 | 166 |
621453 | 621453 | 2020-10-11 | Montgomery | Texas | 48339 | 12114 | 166 |
618210 | 618210 | 2020-10-10 | Montgomery | Texas | 48339 | 12114 | 165 |
614968 | 614968 | 2020-10-09 | Montgomery | Texas | 48339 | 12114 | 164 |
611727 | 611727 | 2020-10-08 | Montgomery | Texas | 48339 | 12022 | 162 |
608485 | 608485 | 2020-10-07 | Montgomery | Texas | 48339 | 11855 | 162 |
605242 | 605242 | 2020-10-06 | Montgomery | Texas | 48339 | 11682 | 162 |
602000 | 602000 | 2020-10-05 | Montgomery | Texas | 48339 | 11444 | 162 |
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);