ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
801 rows where fips = 48157 and state = "Texas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
923137 | 923137 | 2021-01-12 | Fort Bend | Texas | 48157 | 41264 | 415 |
919892 | 919892 | 2021-01-11 | Fort Bend | Texas | 48157 | 40143 | 413 |
916647 | 916647 | 2021-01-10 | Fort Bend | Texas | 48157 | 39662 | 411 |
913402 | 913402 | 2021-01-09 | Fort Bend | Texas | 48157 | 39662 | 409 |
910157 | 910157 | 2021-01-08 | Fort Bend | Texas | 48157 | 39662 | 404 |
906912 | 906912 | 2021-01-07 | Fort Bend | Texas | 48157 | 39322 | 402 |
903666 | 903666 | 2021-01-06 | Fort Bend | Texas | 48157 | 38930 | 400 |
900421 | 900421 | 2021-01-05 | Fort Bend | Texas | 48157 | 37246 | 398 |
897176 | 897176 | 2021-01-04 | Fort Bend | Texas | 48157 | 36526 | 397 |
893930 | 893930 | 2021-01-03 | Fort Bend | Texas | 48157 | 36324 | 393 |
890684 | 890684 | 2021-01-02 | Fort Bend | Texas | 48157 | 36324 | 393 |
887437 | 887437 | 2021-01-01 | Fort Bend | Texas | 48157 | 36324 | 392 |
884192 | 884192 | 2020-12-31 | Fort Bend | Texas | 48157 | 36324 | 390 |
880947 | 880947 | 2020-12-30 | Fort Bend | Texas | 48157 | 36158 | 386 |
877702 | 877702 | 2020-12-29 | Fort Bend | Texas | 48157 | 35705 | 383 |
874457 | 874457 | 2020-12-28 | Fort Bend | Texas | 48157 | 34493 | 378 |
871212 | 871212 | 2020-12-27 | Fort Bend | Texas | 48157 | 33985 | 377 |
867967 | 867967 | 2020-12-26 | Fort Bend | Texas | 48157 | 33985 | 377 |
864722 | 864722 | 2020-12-25 | Fort Bend | Texas | 48157 | 33985 | 377 |
861477 | 861477 | 2020-12-24 | Fort Bend | Texas | 48157 | 33985 | 374 |
858232 | 858232 | 2020-12-23 | Fort Bend | Texas | 48157 | 33985 | 367 |
854987 | 854987 | 2020-12-22 | Fort Bend | Texas | 48157 | 33399 | 364 |
851742 | 851742 | 2020-12-21 | Fort Bend | Texas | 48157 | 32082 | 362 |
848497 | 848497 | 2020-12-20 | Fort Bend | Texas | 48157 | 31946 | 362 |
845252 | 845252 | 2020-12-19 | Fort Bend | Texas | 48157 | 31946 | 361 |
842006 | 842006 | 2020-12-18 | Fort Bend | Texas | 48157 | 31846 | 359 |
838761 | 838761 | 2020-12-17 | Fort Bend | Texas | 48157 | 31382 | 357 |
835515 | 835515 | 2020-12-16 | Fort Bend | Texas | 48157 | 30938 | 355 |
832269 | 832269 | 2020-12-15 | Fort Bend | Texas | 48157 | 30201 | 353 |
829022 | 829022 | 2020-12-14 | Fort Bend | Texas | 48157 | 30042 | 353 |
825776 | 825776 | 2020-12-13 | Fort Bend | Texas | 48157 | 29844 | 353 |
822529 | 822529 | 2020-12-12 | Fort Bend | Texas | 48157 | 29844 | 351 |
819283 | 819283 | 2020-12-11 | Fort Bend | Texas | 48157 | 29594 | 350 |
816037 | 816037 | 2020-12-10 | Fort Bend | Texas | 48157 | 29461 | 349 |
812791 | 812791 | 2020-12-09 | Fort Bend | Texas | 48157 | 29240 | 348 |
809547 | 809547 | 2020-12-08 | Fort Bend | Texas | 48157 | 28006 | 346 |
806302 | 806302 | 2020-12-07 | Fort Bend | Texas | 48157 | 27533 | 345 |
803057 | 803057 | 2020-12-06 | Fort Bend | Texas | 48157 | 26876 | 345 |
799812 | 799812 | 2020-12-05 | Fort Bend | Texas | 48157 | 26876 | 344 |
796567 | 796567 | 2020-12-04 | Fort Bend | Texas | 48157 | 25893 | 341 |
793322 | 793322 | 2020-12-03 | Fort Bend | Texas | 48157 | 23955 | 339 |
790077 | 790077 | 2020-12-02 | Fort Bend | Texas | 48157 | 23353 | 336 |
786832 | 786832 | 2020-12-01 | Fort Bend | Texas | 48157 | 22501 | 335 |
783588 | 783588 | 2020-11-30 | Fort Bend | Texas | 48157 | 22319 | 333 |
780343 | 780343 | 2020-11-29 | Fort Bend | Texas | 48157 | 22165 | 332 |
777097 | 777097 | 2020-11-28 | Fort Bend | Texas | 48157 | 22165 | 332 |
773852 | 773852 | 2020-11-27 | Fort Bend | Texas | 48157 | 21588 | 331 |
770607 | 770607 | 2020-11-26 | Fort Bend | Texas | 48157 | 21588 | 331 |
767361 | 767361 | 2020-11-25 | Fort Bend | Texas | 48157 | 21588 | 329 |
764116 | 764116 | 2020-11-24 | Fort Bend | Texas | 48157 | 21328 | 327 |
760871 | 760871 | 2020-11-23 | Fort Bend | Texas | 48157 | 20821 | 325 |
757626 | 757626 | 2020-11-22 | Fort Bend | Texas | 48157 | 20593 | 325 |
754379 | 754379 | 2020-11-21 | Fort Bend | Texas | 48157 | 20593 | 325 |
751133 | 751133 | 2020-11-20 | Fort Bend | Texas | 48157 | 20464 | 324 |
747887 | 747887 | 2020-11-19 | Fort Bend | Texas | 48157 | 20336 | 324 |
744641 | 744641 | 2020-11-18 | Fort Bend | Texas | 48157 | 20142 | 322 |
741394 | 741394 | 2020-11-17 | Fort Bend | Texas | 48157 | 20043 | 322 |
738148 | 738148 | 2020-11-16 | Fort Bend | Texas | 48157 | 19865 | 322 |
734904 | 734904 | 2020-11-15 | Fort Bend | Texas | 48157 | 19811 | 322 |
731658 | 731658 | 2020-11-14 | Fort Bend | Texas | 48157 | 19811 | 322 |
728413 | 728413 | 2020-11-13 | Fort Bend | Texas | 48157 | 19600 | 319 |
725170 | 725170 | 2020-11-12 | Fort Bend | Texas | 48157 | 19310 | 318 |
721927 | 721927 | 2020-11-11 | Fort Bend | Texas | 48157 | 19149 | 318 |
718684 | 718684 | 2020-11-10 | Fort Bend | Texas | 48157 | 19149 | 318 |
715441 | 715441 | 2020-11-09 | Fort Bend | Texas | 48157 | 18948 | 318 |
712197 | 712197 | 2020-11-08 | Fort Bend | Texas | 48157 | 18948 | 317 |
708953 | 708953 | 2020-11-07 | Fort Bend | Texas | 48157 | 18948 | 317 |
705709 | 705709 | 2020-11-06 | Fort Bend | Texas | 48157 | 18903 | 316 |
702466 | 702466 | 2020-11-05 | Fort Bend | Texas | 48157 | 18802 | 313 |
699223 | 699223 | 2020-11-04 | Fort Bend | Texas | 48157 | 18614 | 312 |
695979 | 695979 | 2020-11-03 | Fort Bend | Texas | 48157 | 18518 | 311 |
692737 | 692737 | 2020-11-02 | Fort Bend | Texas | 48157 | 18461 | 311 |
689493 | 689493 | 2020-11-01 | Fort Bend | Texas | 48157 | 18416 | 310 |
686248 | 686248 | 2020-10-31 | Fort Bend | Texas | 48157 | 18416 | 309 |
683005 | 683005 | 2020-10-30 | Fort Bend | Texas | 48157 | 18340 | 309 |
679762 | 679762 | 2020-10-29 | Fort Bend | Texas | 48157 | 18302 | 309 |
676519 | 676519 | 2020-10-28 | Fort Bend | Texas | 48157 | 18215 | 308 |
673276 | 673276 | 2020-10-27 | Fort Bend | Texas | 48157 | 18186 | 307 |
670034 | 670034 | 2020-10-26 | Fort Bend | Texas | 48157 | 18091 | 306 |
666791 | 666791 | 2020-10-25 | Fort Bend | Texas | 48157 | 17997 | 306 |
663546 | 663546 | 2020-10-24 | Fort Bend | Texas | 48157 | 17997 | 306 |
660302 | 660302 | 2020-10-23 | Fort Bend | Texas | 48157 | 17997 | 305 |
657058 | 657058 | 2020-10-22 | Fort Bend | Texas | 48157 | 17944 | 303 |
653813 | 653813 | 2020-10-21 | Fort Bend | Texas | 48157 | 17909 | 303 |
650568 | 650568 | 2020-10-20 | Fort Bend | Texas | 48157 | 17758 | 303 |
647324 | 647324 | 2020-10-19 | Fort Bend | Texas | 48157 | 17658 | 303 |
644078 | 644078 | 2020-10-18 | Fort Bend | Texas | 48157 | 17571 | 303 |
640830 | 640830 | 2020-10-17 | Fort Bend | Texas | 48157 | 17571 | 303 |
637583 | 637583 | 2020-10-16 | Fort Bend | Texas | 48157 | 17507 | 303 |
634338 | 634338 | 2020-10-15 | Fort Bend | Texas | 48157 | 17470 | 303 |
631093 | 631093 | 2020-10-14 | Fort Bend | Texas | 48157 | 17438 | 303 |
627849 | 627849 | 2020-10-13 | Fort Bend | Texas | 48157 | 17364 | 297 |
624607 | 624607 | 2020-10-12 | Fort Bend | Texas | 48157 | 17310 | 295 |
621364 | 621364 | 2020-10-11 | Fort Bend | Texas | 48157 | 17268 | 295 |
618121 | 618121 | 2020-10-10 | Fort Bend | Texas | 48157 | 17251 | 295 |
614879 | 614879 | 2020-10-09 | Fort Bend | Texas | 48157 | 17106 | 295 |
611638 | 611638 | 2020-10-08 | Fort Bend | Texas | 48157 | 17021 | 295 |
608396 | 608396 | 2020-10-07 | Fort Bend | Texas | 48157 | 17012 | 295 |
605153 | 605153 | 2020-10-06 | Fort Bend | Texas | 48157 | 16920 | 295 |
601911 | 601911 | 2020-10-05 | Fort Bend | Texas | 48157 | 16877 | 294 |
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);