ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
3,132 rows where county = "Lamar" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
state 4
- Georgia 299
- Alabama 298
- Mississippi 296
- Texas 294
county 1
- Lamar · 1,187 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
920912 | 920912 | 2021-01-12 | Lamar | Georgia | 13171 | 1440 | 35 |
921888 | 921888 | 2021-01-12 | Lamar | Mississippi | 28073 | 4628 | 62 |
923198 | 923198 | 2021-01-12 | Lamar | Texas | 48277 | 4761 | 103 |
917230 | 917230 | 2021-01-11 | Lamar | Alabama | 1075 | 1146 | 16 |
917667 | 917667 | 2021-01-11 | Lamar | Georgia | 13171 | 1415 | 35 |
918643 | 918643 | 2021-01-11 | Lamar | Mississippi | 28073 | 4601 | 61 |
919953 | 919953 | 2021-01-11 | Lamar | Texas | 48277 | 4761 | 103 |
913985 | 913985 | 2021-01-10 | Lamar | Alabama | 1075 | 1137 | 16 |
914422 | 914422 | 2021-01-10 | Lamar | Georgia | 13171 | 1401 | 35 |
915398 | 915398 | 2021-01-10 | Lamar | Mississippi | 28073 | 4585 | 61 |
916708 | 916708 | 2021-01-10 | Lamar | Texas | 48277 | 4685 | 102 |
910740 | 910740 | 2021-01-09 | Lamar | Alabama | 1075 | 1132 | 16 |
911177 | 911177 | 2021-01-09 | Lamar | Georgia | 13171 | 1385 | 35 |
912153 | 912153 | 2021-01-09 | Lamar | Mississippi | 28073 | 4562 | 61 |
913463 | 913463 | 2021-01-09 | Lamar | Texas | 48277 | 4685 | 102 |
907495 | 907495 | 2021-01-08 | Lamar | Alabama | 1075 | 1124 | 16 |
907932 | 907932 | 2021-01-08 | Lamar | Georgia | 13171 | 1355 | 34 |
908908 | 908908 | 2021-01-08 | Lamar | Mississippi | 28073 | 4505 | 61 |
910218 | 910218 | 2021-01-08 | Lamar | Texas | 48277 | 4568 | 102 |
904249 | 904249 | 2021-01-07 | Lamar | Alabama | 1075 | 1114 | 16 |
904686 | 904686 | 2021-01-07 | Lamar | Georgia | 13171 | 1325 | 34 |
905662 | 905662 | 2021-01-07 | Lamar | Mississippi | 28073 | 4460 | 61 |
906973 | 906973 | 2021-01-07 | Lamar | Texas | 48277 | 4568 | 102 |
901004 | 901004 | 2021-01-06 | Lamar | Alabama | 1075 | 1098 | 16 |
901441 | 901441 | 2021-01-06 | Lamar | Georgia | 13171 | 1301 | 32 |
902417 | 902417 | 2021-01-06 | Lamar | Mississippi | 28073 | 4393 | 61 |
903727 | 903727 | 2021-01-06 | Lamar | Texas | 48277 | 4498 | 102 |
897759 | 897759 | 2021-01-05 | Lamar | Alabama | 1075 | 1083 | 15 |
898196 | 898196 | 2021-01-05 | Lamar | Georgia | 13171 | 1287 | 32 |
899172 | 899172 | 2021-01-05 | Lamar | Mississippi | 28073 | 4335 | 61 |
900482 | 900482 | 2021-01-05 | Lamar | Texas | 48277 | 4206 | 100 |
894513 | 894513 | 2021-01-04 | Lamar | Alabama | 1075 | 1077 | 15 |
894951 | 894951 | 2021-01-04 | Lamar | Georgia | 13171 | 1266 | 32 |
895927 | 895927 | 2021-01-04 | Lamar | Mississippi | 28073 | 4291 | 60 |
897237 | 897237 | 2021-01-04 | Lamar | Texas | 48277 | 4206 | 99 |
891267 | 891267 | 2021-01-03 | Lamar | Alabama | 1075 | 1074 | 15 |
891704 | 891704 | 2021-01-03 | Lamar | Georgia | 13171 | 1251 | 32 |
892680 | 892680 | 2021-01-03 | Lamar | Mississippi | 28073 | 4245 | 60 |
893991 | 893991 | 2021-01-03 | Lamar | Texas | 48277 | 4163 | 99 |
888020 | 888020 | 2021-01-02 | Lamar | Alabama | 1075 | 1069 | 15 |
888457 | 888457 | 2021-01-02 | Lamar | Georgia | 13171 | 1233 | 32 |
889434 | 889434 | 2021-01-02 | Lamar | Mississippi | 28073 | 4212 | 60 |
890745 | 890745 | 2021-01-02 | Lamar | Texas | 48277 | 4163 | 99 |
884775 | 884775 | 2021-01-01 | Lamar | Alabama | 1075 | 1065 | 15 |
885212 | 885212 | 2021-01-01 | Lamar | Georgia | 13171 | 1201 | 32 |
886188 | 886188 | 2021-01-01 | Lamar | Mississippi | 28073 | 4162 | 60 |
887498 | 887498 | 2021-01-01 | Lamar | Texas | 48277 | 4109 | 99 |
881530 | 881530 | 2020-12-31 | Lamar | Alabama | 1075 | 1056 | 15 |
881967 | 881967 | 2020-12-31 | Lamar | Georgia | 13171 | 1172 | 32 |
882943 | 882943 | 2020-12-31 | Lamar | Mississippi | 28073 | 4106 | 60 |
884253 | 884253 | 2020-12-31 | Lamar | Texas | 48277 | 4109 | 95 |
878285 | 878285 | 2020-12-30 | Lamar | Alabama | 1075 | 1037 | 15 |
878722 | 878722 | 2020-12-30 | Lamar | Georgia | 13171 | 1146 | 32 |
879698 | 879698 | 2020-12-30 | Lamar | Mississippi | 28073 | 4037 | 60 |
881008 | 881008 | 2020-12-30 | Lamar | Texas | 48277 | 4109 | 91 |
875040 | 875040 | 2020-12-29 | Lamar | Alabama | 1075 | 1025 | 15 |
875477 | 875477 | 2020-12-29 | Lamar | Georgia | 13171 | 1127 | 31 |
876453 | 876453 | 2020-12-29 | Lamar | Mississippi | 28073 | 3982 | 60 |
877763 | 877763 | 2020-12-29 | Lamar | Texas | 48277 | 3967 | 91 |
871795 | 871795 | 2020-12-28 | Lamar | Alabama | 1075 | 1017 | 15 |
872232 | 872232 | 2020-12-28 | Lamar | Georgia | 13171 | 1090 | 31 |
873208 | 873208 | 2020-12-28 | Lamar | Mississippi | 28073 | 3955 | 59 |
874518 | 874518 | 2020-12-28 | Lamar | Texas | 48277 | 3752 | 91 |
868550 | 868550 | 2020-12-27 | Lamar | Alabama | 1075 | 1012 | 15 |
868987 | 868987 | 2020-12-27 | Lamar | Georgia | 13171 | 1080 | 31 |
869963 | 869963 | 2020-12-27 | Lamar | Mississippi | 28073 | 3918 | 58 |
871273 | 871273 | 2020-12-27 | Lamar | Texas | 48277 | 3681 | 90 |
865305 | 865305 | 2020-12-26 | Lamar | Alabama | 1075 | 1009 | 15 |
865742 | 865742 | 2020-12-26 | Lamar | Georgia | 13171 | 1065 | 31 |
866718 | 866718 | 2020-12-26 | Lamar | Mississippi | 28073 | 3909 | 56 |
868028 | 868028 | 2020-12-26 | Lamar | Texas | 48277 | 3681 | 90 |
862060 | 862060 | 2020-12-25 | Lamar | Alabama | 1075 | 1007 | 15 |
862497 | 862497 | 2020-12-25 | Lamar | Georgia | 13171 | 1058 | 31 |
863473 | 863473 | 2020-12-25 | Lamar | Mississippi | 28073 | 3895 | 56 |
864783 | 864783 | 2020-12-25 | Lamar | Texas | 48277 | 3600 | 90 |
858815 | 858815 | 2020-12-24 | Lamar | Alabama | 1075 | 997 | 15 |
859252 | 859252 | 2020-12-24 | Lamar | Georgia | 13171 | 1048 | 30 |
860228 | 860228 | 2020-12-24 | Lamar | Mississippi | 28073 | 3862 | 55 |
861538 | 861538 | 2020-12-24 | Lamar | Texas | 48277 | 3648 | 88 |
855570 | 855570 | 2020-12-23 | Lamar | Alabama | 1075 | 986 | 15 |
856007 | 856007 | 2020-12-23 | Lamar | Georgia | 13171 | 1023 | 30 |
856983 | 856983 | 2020-12-23 | Lamar | Mississippi | 28073 | 3815 | 55 |
858293 | 858293 | 2020-12-23 | Lamar | Texas | 48277 | 3648 | 87 |
852325 | 852325 | 2020-12-22 | Lamar | Alabama | 1075 | 979 | 12 |
852762 | 852762 | 2020-12-22 | Lamar | Georgia | 13171 | 1000 | 30 |
853738 | 853738 | 2020-12-22 | Lamar | Mississippi | 28073 | 3765 | 54 |
855048 | 855048 | 2020-12-22 | Lamar | Texas | 48277 | 3547 | 87 |
849080 | 849080 | 2020-12-21 | Lamar | Alabama | 1075 | 966 | 12 |
849517 | 849517 | 2020-12-21 | Lamar | Georgia | 13171 | 983 | 30 |
850493 | 850493 | 2020-12-21 | Lamar | Mississippi | 28073 | 3731 | 54 |
851803 | 851803 | 2020-12-21 | Lamar | Texas | 48277 | 3453 | 87 |
845835 | 845835 | 2020-12-20 | Lamar | Alabama | 1075 | 946 | 12 |
846272 | 846272 | 2020-12-20 | Lamar | Georgia | 13171 | 976 | 30 |
847248 | 847248 | 2020-12-20 | Lamar | Mississippi | 28073 | 3707 | 54 |
848558 | 848558 | 2020-12-20 | Lamar | Texas | 48277 | 3423 | 86 |
842589 | 842589 | 2020-12-19 | Lamar | Alabama | 1075 | 941 | 12 |
843026 | 843026 | 2020-12-19 | Lamar | Georgia | 13171 | 962 | 30 |
844002 | 844002 | 2020-12-19 | Lamar | Mississippi | 28073 | 3670 | 53 |
845313 | 845313 | 2020-12-19 | Lamar | Texas | 48277 | 3423 | 85 |
839344 | 839344 | 2020-12-18 | Lamar | Alabama | 1075 | 925 | 12 |
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);