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 |
---|---|---|---|---|---|---|---|
1046531 | 1046531 | 2021-02-19 | Lee | Texas | 48287 | 1943 | 36 |
1043286 | 1043286 | 2021-02-18 | Lee | Texas | 48287 | 1937 | 36 |
1040041 | 1040041 | 2021-02-17 | Lee | Texas | 48287 | 1930 | 36 |
1036796 | 1036796 | 2021-02-16 | Lee | Texas | 48287 | 1926 | 36 |
1033551 | 1033551 | 2021-02-15 | Lee | Texas | 48287 | 1912 | 36 |
1030305 | 1030305 | 2021-02-14 | Lee | Texas | 48287 | 1912 | 36 |
1027058 | 1027058 | 2021-02-13 | Lee | Texas | 48287 | 1912 | 36 |
1023813 | 1023813 | 2021-02-12 | Lee | Texas | 48287 | 1902 | 36 |
1020568 | 1020568 | 2021-02-11 | Lee | Texas | 48287 | 1868 | 36 |
1017323 | 1017323 | 2021-02-10 | Lee | Texas | 48287 | 1836 | 36 |
1014078 | 1014078 | 2021-02-09 | Lee | Texas | 48287 | 1812 | 36 |
1010833 | 1010833 | 2021-02-08 | Lee | Texas | 48287 | 1806 | 36 |
1007587 | 1007587 | 2021-02-07 | Lee | Texas | 48287 | 1802 | 36 |
1004341 | 1004341 | 2021-02-06 | Lee | Texas | 48287 | 1802 | 36 |
1001095 | 1001095 | 2021-02-05 | Lee | Texas | 48287 | 1780 | 36 |
997849 | 997849 | 2021-02-04 | Lee | Texas | 48287 | 1749 | 36 |
994603 | 994603 | 2021-02-03 | Lee | Texas | 48287 | 1708 | 36 |
991357 | 991357 | 2021-02-02 | Lee | Texas | 48287 | 1699 | 36 |
988111 | 988111 | 2021-02-01 | Lee | Texas | 48287 | 1674 | 36 |
984864 | 984864 | 2021-01-31 | Lee | Texas | 48287 | 1307 | 36 |
981617 | 981617 | 2021-01-30 | Lee | Texas | 48287 | 1300 | 36 |
978371 | 978371 | 2021-01-29 | Lee | Texas | 48287 | 1291 | 36 |
975126 | 975126 | 2021-01-28 | Lee | Texas | 48287 | 1270 | 36 |
971881 | 971881 | 2021-01-27 | Lee | Texas | 48287 | 1252 | 36 |
968636 | 968636 | 2021-01-26 | Lee | Texas | 48287 | 1247 | 36 |
965392 | 965392 | 2021-01-25 | Lee | Texas | 48287 | 1245 | 36 |
962147 | 962147 | 2021-01-24 | Lee | Texas | 48287 | 1245 | 36 |
958902 | 958902 | 2021-01-23 | Lee | Texas | 48287 | 1244 | 36 |
955656 | 955656 | 2021-01-22 | Lee | Texas | 48287 | 1237 | 36 |
952411 | 952411 | 2021-01-21 | Lee | Texas | 48287 | 1212 | 36 |
949166 | 949166 | 2021-01-20 | Lee | Texas | 48287 | 1196 | 35 |
945920 | 945920 | 2021-01-19 | Lee | Texas | 48287 | 1182 | 34 |
942673 | 942673 | 2021-01-18 | Lee | Texas | 48287 | 1182 | 34 |
939428 | 939428 | 2021-01-17 | Lee | Texas | 48287 | 1180 | 34 |
936183 | 936183 | 2021-01-16 | Lee | Texas | 48287 | 1179 | 34 |
932938 | 932938 | 2021-01-15 | Lee | Texas | 48287 | 1157 | 34 |
929693 | 929693 | 2021-01-14 | Lee | Texas | 48287 | 1145 | 34 |
926448 | 926448 | 2021-01-13 | Lee | Texas | 48287 | 1126 | 33 |
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 |
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);