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 |
---|---|---|---|---|---|---|---|
1082261 | 1082261 | 2021-03-02 | Montgomery | Texas | 48339 | 45635 | 455 |
1079015 | 1079015 | 2021-03-01 | Montgomery | Texas | 48339 | 45528 | 450 |
1075770 | 1075770 | 2021-02-28 | Montgomery | Texas | 48339 | 44999 | 450 |
1072524 | 1072524 | 2021-02-27 | Montgomery | Texas | 48339 | 44999 | 450 |
1069278 | 1069278 | 2021-02-26 | Montgomery | Texas | 48339 | 44999 | 450 |
1066033 | 1066033 | 2021-02-25 | Montgomery | Texas | 48339 | 44862 | 448 |
1062788 | 1062788 | 2021-02-24 | Montgomery | Texas | 48339 | 44579 | 443 |
1059543 | 1059543 | 2021-02-23 | Montgomery | Texas | 48339 | 44439 | 442 |
1056297 | 1056297 | 2021-02-22 | Montgomery | Texas | 48339 | 44346 | 439 |
1053051 | 1053051 | 2021-02-21 | Montgomery | Texas | 48339 | 44060 | 439 |
1049804 | 1049804 | 2021-02-20 | Montgomery | Texas | 48339 | 44060 | 436 |
1046557 | 1046557 | 2021-02-19 | Montgomery | Texas | 48339 | 44060 | 432 |
1043312 | 1043312 | 2021-02-18 | Montgomery | Texas | 48339 | 43077 | 431 |
1040067 | 1040067 | 2021-02-17 | Montgomery | Texas | 48339 | 43077 | 430 |
1036822 | 1036822 | 2021-02-16 | Montgomery | Texas | 48339 | 43077 | 430 |
1033577 | 1033577 | 2021-02-15 | Montgomery | Texas | 48339 | 43077 | 430 |
1030331 | 1030331 | 2021-02-14 | Montgomery | Texas | 48339 | 43077 | 428 |
1027084 | 1027084 | 2021-02-13 | Montgomery | Texas | 48339 | 43077 | 424 |
1023839 | 1023839 | 2021-02-12 | Montgomery | Texas | 48339 | 43077 | 418 |
1020594 | 1020594 | 2021-02-11 | Montgomery | Texas | 48339 | 42810 | 418 |
1017349 | 1017349 | 2021-02-10 | Montgomery | Texas | 48339 | 42477 | 413 |
1014104 | 1014104 | 2021-02-09 | Montgomery | Texas | 48339 | 42261 | 408 |
1010859 | 1010859 | 2021-02-08 | Montgomery | Texas | 48339 | 41848 | 407 |
1007613 | 1007613 | 2021-02-07 | Montgomery | Texas | 48339 | 41310 | 406 |
1004367 | 1004367 | 2021-02-06 | Montgomery | Texas | 48339 | 41310 | 403 |
1001121 | 1001121 | 2021-02-05 | Montgomery | Texas | 48339 | 41310 | 401 |
997875 | 997875 | 2021-02-04 | Montgomery | Texas | 48339 | 40954 | 398 |
994629 | 994629 | 2021-02-03 | Montgomery | Texas | 48339 | 40601 | 394 |
991383 | 991383 | 2021-02-02 | Montgomery | Texas | 48339 | 40360 | 389 |
988137 | 988137 | 2021-02-01 | Montgomery | Texas | 48339 | 40042 | 384 |
984890 | 984890 | 2021-01-31 | Montgomery | Texas | 48339 | 39241 | 383 |
981643 | 981643 | 2021-01-30 | Montgomery | Texas | 48339 | 39241 | 382 |
978397 | 978397 | 2021-01-29 | Montgomery | Texas | 48339 | 39241 | 375 |
975152 | 975152 | 2021-01-28 | Montgomery | Texas | 48339 | 38904 | 369 |
971907 | 971907 | 2021-01-27 | Montgomery | Texas | 48339 | 38557 | 365 |
968662 | 968662 | 2021-01-26 | Montgomery | Texas | 48339 | 38075 | 358 |
965418 | 965418 | 2021-01-25 | Montgomery | Texas | 48339 | 36344 | 351 |
962173 | 962173 | 2021-01-24 | Montgomery | Texas | 48339 | 35480 | 351 |
958928 | 958928 | 2021-01-23 | Montgomery | Texas | 48339 | 35480 | 347 |
955682 | 955682 | 2021-01-22 | Montgomery | Texas | 48339 | 35480 | 343 |
952437 | 952437 | 2021-01-21 | Montgomery | Texas | 48339 | 35171 | 340 |
949192 | 949192 | 2021-01-20 | Montgomery | Texas | 48339 | 34719 | 332 |
945946 | 945946 | 2021-01-19 | Montgomery | Texas | 48339 | 34423 | 326 |
942699 | 942699 | 2021-01-18 | Montgomery | Texas | 48339 | 33006 | 321 |
939454 | 939454 | 2021-01-17 | Montgomery | Texas | 48339 | 33006 | 321 |
936209 | 936209 | 2021-01-16 | Montgomery | Texas | 48339 | 33006 | 320 |
932964 | 932964 | 2021-01-15 | Montgomery | Texas | 48339 | 33006 | 309 |
929719 | 929719 | 2021-01-14 | Montgomery | Texas | 48339 | 32575 | 304 |
926474 | 926474 | 2021-01-13 | Montgomery | Texas | 48339 | 32205 | 301 |
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 |
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);