ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
772 rows where county = "Lee" and fips = 48287 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
923202 | 923202 | 2021-01-12 | Lee | Texas | 48287 | 1103 | 33 |
919957 | 919957 | 2021-01-11 | Lee | Texas | 48287 | 1102 | 31 |
916712 | 916712 | 2021-01-10 | Lee | Texas | 48287 | 1102 | 31 |
913467 | 913467 | 2021-01-09 | Lee | Texas | 48287 | 1102 | 31 |
910222 | 910222 | 2021-01-08 | Lee | Texas | 48287 | 1053 | 31 |
906977 | 906977 | 2021-01-07 | Lee | Texas | 48287 | 1031 | 30 |
903731 | 903731 | 2021-01-06 | Lee | Texas | 48287 | 1019 | 28 |
900486 | 900486 | 2021-01-05 | Lee | Texas | 48287 | 1005 | 28 |
897241 | 897241 | 2021-01-04 | Lee | Texas | 48287 | 983 | 28 |
893995 | 893995 | 2021-01-03 | Lee | Texas | 48287 | 983 | 28 |
890749 | 890749 | 2021-01-02 | Lee | Texas | 48287 | 977 | 28 |
887502 | 887502 | 2021-01-01 | Lee | Texas | 48287 | 977 | 28 |
884257 | 884257 | 2020-12-31 | Lee | Texas | 48287 | 962 | 27 |
881012 | 881012 | 2020-12-30 | Lee | Texas | 48287 | 920 | 27 |
877767 | 877767 | 2020-12-29 | Lee | Texas | 48287 | 911 | 25 |
874522 | 874522 | 2020-12-28 | Lee | Texas | 48287 | 876 | 24 |
871277 | 871277 | 2020-12-27 | Lee | Texas | 48287 | 876 | 24 |
868032 | 868032 | 2020-12-26 | Lee | Texas | 48287 | 874 | 24 |
864787 | 864787 | 2020-12-25 | Lee | Texas | 48287 | 874 | 24 |
861542 | 861542 | 2020-12-24 | Lee | Texas | 48287 | 872 | 23 |
858297 | 858297 | 2020-12-23 | Lee | Texas | 48287 | 859 | 23 |
855052 | 855052 | 2020-12-22 | Lee | Texas | 48287 | 839 | 23 |
851807 | 851807 | 2020-12-21 | Lee | Texas | 48287 | 808 | 23 |
848562 | 848562 | 2020-12-20 | Lee | Texas | 48287 | 808 | 23 |
845317 | 845317 | 2020-12-19 | Lee | Texas | 48287 | 806 | 23 |
842071 | 842071 | 2020-12-18 | Lee | Texas | 48287 | 790 | 23 |
838826 | 838826 | 2020-12-17 | Lee | Texas | 48287 | 772 | 23 |
835580 | 835580 | 2020-12-16 | Lee | Texas | 48287 | 756 | 23 |
832334 | 832334 | 2020-12-15 | Lee | Texas | 48287 | 734 | 21 |
829087 | 829087 | 2020-12-14 | Lee | Texas | 48287 | 719 | 21 |
825841 | 825841 | 2020-12-13 | Lee | Texas | 48287 | 719 | 21 |
822594 | 822594 | 2020-12-12 | Lee | Texas | 48287 | 714 | 21 |
819348 | 819348 | 2020-12-11 | Lee | Texas | 48287 | 702 | 21 |
816102 | 816102 | 2020-12-10 | Lee | Texas | 48287 | 330 | 21 |
812856 | 812856 | 2020-12-09 | Lee | Texas | 48287 | 327 | 19 |
809612 | 809612 | 2020-12-08 | Lee | Texas | 48287 | 327 | 19 |
806367 | 806367 | 2020-12-07 | Lee | Texas | 48287 | 326 | 19 |
803122 | 803122 | 2020-12-06 | Lee | Texas | 48287 | 326 | 19 |
799877 | 799877 | 2020-12-05 | Lee | Texas | 48287 | 326 | 19 |
796632 | 796632 | 2020-12-04 | Lee | Texas | 48287 | 318 | 19 |
793387 | 793387 | 2020-12-03 | Lee | Texas | 48287 | 301 | 19 |
790142 | 790142 | 2020-12-02 | Lee | Texas | 48287 | 300 | 19 |
786897 | 786897 | 2020-12-01 | Lee | Texas | 48287 | 299 | 17 |
783653 | 783653 | 2020-11-30 | Lee | Texas | 48287 | 299 | 17 |
780408 | 780408 | 2020-11-29 | Lee | Texas | 48287 | 299 | 17 |
777162 | 777162 | 2020-11-28 | Lee | Texas | 48287 | 295 | 17 |
773917 | 773917 | 2020-11-27 | Lee | Texas | 48287 | 293 | 17 |
770672 | 770672 | 2020-11-26 | Lee | Texas | 48287 | 293 | 17 |
767426 | 767426 | 2020-11-25 | Lee | Texas | 48287 | 289 | 17 |
764181 | 764181 | 2020-11-24 | Lee | Texas | 48287 | 287 | 17 |
760936 | 760936 | 2020-11-23 | Lee | Texas | 48287 | 282 | 15 |
757691 | 757691 | 2020-11-22 | Lee | Texas | 48287 | 280 | 15 |
754444 | 754444 | 2020-11-21 | Lee | Texas | 48287 | 277 | 15 |
751198 | 751198 | 2020-11-20 | Lee | Texas | 48287 | 273 | 15 |
747952 | 747952 | 2020-11-19 | Lee | Texas | 48287 | 272 | 15 |
744706 | 744706 | 2020-11-18 | Lee | Texas | 48287 | 263 | 15 |
741459 | 741459 | 2020-11-17 | Lee | Texas | 48287 | 261 | 15 |
738213 | 738213 | 2020-11-16 | Lee | Texas | 48287 | 259 | 15 |
734969 | 734969 | 2020-11-15 | Lee | Texas | 48287 | 262 | 15 |
731723 | 731723 | 2020-11-14 | Lee | Texas | 48287 | 262 | 15 |
728478 | 728478 | 2020-11-13 | Lee | Texas | 48287 | 262 | 15 |
725235 | 725235 | 2020-11-12 | Lee | Texas | 48287 | 262 | 15 |
721992 | 721992 | 2020-11-11 | Lee | Texas | 48287 | 262 | 15 |
718749 | 718749 | 2020-11-10 | Lee | Texas | 48287 | 255 | 15 |
715506 | 715506 | 2020-11-09 | Lee | Texas | 48287 | 253 | 15 |
712262 | 712262 | 2020-11-08 | Lee | Texas | 48287 | 253 | 15 |
709018 | 709018 | 2020-11-07 | Lee | Texas | 48287 | 253 | 15 |
705774 | 705774 | 2020-11-06 | Lee | Texas | 48287 | 250 | 15 |
702531 | 702531 | 2020-11-05 | Lee | Texas | 48287 | 249 | 15 |
699288 | 699288 | 2020-11-04 | Lee | Texas | 48287 | 249 | 14 |
696044 | 696044 | 2020-11-03 | Lee | Texas | 48287 | 246 | 15 |
692802 | 692802 | 2020-11-02 | Lee | Texas | 48287 | 245 | 15 |
689558 | 689558 | 2020-11-01 | Lee | Texas | 48287 | 245 | 15 |
686313 | 686313 | 2020-10-31 | Lee | Texas | 48287 | 245 | 14 |
683070 | 683070 | 2020-10-30 | Lee | Texas | 48287 | 245 | 14 |
679827 | 679827 | 2020-10-29 | Lee | Texas | 48287 | 243 | 14 |
676584 | 676584 | 2020-10-28 | Lee | Texas | 48287 | 242 | 14 |
673341 | 673341 | 2020-10-27 | Lee | Texas | 48287 | 241 | 14 |
670099 | 670099 | 2020-10-26 | Lee | Texas | 48287 | 239 | 14 |
666856 | 666856 | 2020-10-25 | Lee | Texas | 48287 | 239 | 14 |
663611 | 663611 | 2020-10-24 | Lee | Texas | 48287 | 239 | 14 |
660367 | 660367 | 2020-10-23 | Lee | Texas | 48287 | 236 | 14 |
657123 | 657123 | 2020-10-22 | Lee | Texas | 48287 | 235 | 14 |
653878 | 653878 | 2020-10-21 | Lee | Texas | 48287 | 235 | 14 |
650633 | 650633 | 2020-10-20 | Lee | Texas | 48287 | 235 | 14 |
647389 | 647389 | 2020-10-19 | Lee | Texas | 48287 | 235 | 14 |
644143 | 644143 | 2020-10-18 | Lee | Texas | 48287 | 235 | 14 |
640895 | 640895 | 2020-10-17 | Lee | Texas | 48287 | 235 | 14 |
637648 | 637648 | 2020-10-16 | Lee | Texas | 48287 | 235 | 14 |
634403 | 634403 | 2020-10-15 | Lee | Texas | 48287 | 235 | 14 |
631158 | 631158 | 2020-10-14 | Lee | Texas | 48287 | 234 | 14 |
627914 | 627914 | 2020-10-13 | Lee | Texas | 48287 | 234 | 14 |
624671 | 624671 | 2020-10-12 | Lee | Texas | 48287 | 234 | 14 |
621428 | 621428 | 2020-10-11 | Lee | Texas | 48287 | 234 | 14 |
618185 | 618185 | 2020-10-10 | Lee | Texas | 48287 | 234 | 14 |
614943 | 614943 | 2020-10-09 | Lee | Texas | 48287 | 233 | 14 |
611702 | 611702 | 2020-10-08 | Lee | Texas | 48287 | 233 | 14 |
608460 | 608460 | 2020-10-07 | Lee | Texas | 48287 | 232 | 14 |
605217 | 605217 | 2020-10-06 | Lee | Texas | 48287 | 231 | 14 |
601975 | 601975 | 2020-10-05 | Lee | Texas | 48287 | 230 | 14 |
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);