ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
791 rows where county = "Bossier" and state = "Louisiana" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1048140 | 1048140 | 2021-02-20 | Bossier | Louisiana | 22015 | 12852 | 256 |
1044895 | 1044895 | 2021-02-19 | Bossier | Louisiana | 22015 | 12852 | 256 |
1041650 | 1041650 | 2021-02-18 | Bossier | Louisiana | 22015 | 12842 | 256 |
1038405 | 1038405 | 2021-02-17 | Bossier | Louisiana | 22015 | 12827 | 256 |
1035160 | 1035160 | 2021-02-16 | Bossier | Louisiana | 22015 | 12807 | 255 |
1031914 | 1031914 | 2021-02-15 | Bossier | Louisiana | 22015 | 12807 | 255 |
1028667 | 1028667 | 2021-02-14 | Bossier | Louisiana | 22015 | 12785 | 253 |
1025422 | 1025422 | 2021-02-13 | Bossier | Louisiana | 22015 | 12741 | 253 |
1022177 | 1022177 | 2021-02-12 | Bossier | Louisiana | 22015 | 12741 | 253 |
1018932 | 1018932 | 2021-02-11 | Bossier | Louisiana | 22015 | 12702 | 251 |
1015687 | 1015687 | 2021-02-10 | Bossier | Louisiana | 22015 | 12608 | 251 |
1012442 | 1012442 | 2021-02-09 | Bossier | Louisiana | 22015 | 12604 | 249 |
1009196 | 1009196 | 2021-02-08 | Bossier | Louisiana | 22015 | 12547 | 249 |
1005950 | 1005950 | 2021-02-07 | Bossier | Louisiana | 22015 | 12489 | 247 |
1002704 | 1002704 | 2021-02-06 | Bossier | Louisiana | 22015 | 12422 | 246 |
999458 | 999458 | 2021-02-05 | Bossier | Louisiana | 22015 | 12422 | 246 |
996212 | 996212 | 2021-02-04 | Bossier | Louisiana | 22015 | 12385 | 245 |
992966 | 992966 | 2021-02-03 | Bossier | Louisiana | 22015 | 12105 | 243 |
989720 | 989720 | 2021-02-02 | Bossier | Louisiana | 22015 | 11985 | 243 |
986473 | 986473 | 2021-02-01 | Bossier | Louisiana | 22015 | 11865 | 243 |
983226 | 983226 | 2021-01-31 | Bossier | Louisiana | 22015 | 11833 | 237 |
979980 | 979980 | 2021-01-30 | Bossier | Louisiana | 22015 | 11695 | 235 |
976734 | 976734 | 2021-01-29 | Bossier | Louisiana | 22015 | 11695 | 235 |
973489 | 973489 | 2021-01-28 | Bossier | Louisiana | 22015 | 11600 | 234 |
970244 | 970244 | 2021-01-27 | Bossier | Louisiana | 22015 | 11514 | 234 |
967000 | 967000 | 2021-01-26 | Bossier | Louisiana | 22015 | 11383 | 234 |
963755 | 963755 | 2021-01-25 | Bossier | Louisiana | 22015 | 11278 | 233 |
960510 | 960510 | 2021-01-24 | Bossier | Louisiana | 22015 | 11230 | 232 |
957264 | 957264 | 2021-01-23 | Bossier | Louisiana | 22015 | 11031 | 225 |
954019 | 954019 | 2021-01-22 | Bossier | Louisiana | 22015 | 11031 | 225 |
950774 | 950774 | 2021-01-21 | Bossier | Louisiana | 22015 | 10953 | 225 |
947528 | 947528 | 2021-01-20 | Bossier | Louisiana | 22015 | 10826 | 224 |
944281 | 944281 | 2021-01-19 | Bossier | Louisiana | 22015 | 10712 | 222 |
941036 | 941036 | 2021-01-18 | Bossier | Louisiana | 22015 | 10662 | 217 |
937791 | 937791 | 2021-01-17 | Bossier | Louisiana | 22015 | 10648 | 213 |
934546 | 934546 | 2021-01-16 | Bossier | Louisiana | 22015 | 10558 | 211 |
931301 | 931301 | 2021-01-15 | Bossier | Louisiana | 22015 | 10558 | 211 |
928056 | 928056 | 2021-01-14 | Bossier | Louisiana | 22015 | 10455 | 211 |
924810 | 924810 | 2021-01-13 | Bossier | Louisiana | 22015 | 10368 | 210 |
921565 | 921565 | 2021-01-12 | Bossier | Louisiana | 22015 | 10260 | 210 |
918320 | 918320 | 2021-01-11 | Bossier | Louisiana | 22015 | 10102 | 210 |
915075 | 915075 | 2021-01-10 | Bossier | Louisiana | 22015 | 10068 | 208 |
911830 | 911830 | 2021-01-09 | Bossier | Louisiana | 22015 | 9695 | 207 |
908585 | 908585 | 2021-01-08 | Bossier | Louisiana | 22015 | 9695 | 207 |
905339 | 905339 | 2021-01-07 | Bossier | Louisiana | 22015 | 9594 | 204 |
902094 | 902094 | 2021-01-06 | Bossier | Louisiana | 22015 | 9519 | 203 |
898849 | 898849 | 2021-01-05 | Bossier | Louisiana | 22015 | 9361 | 201 |
895604 | 895604 | 2021-01-04 | Bossier | Louisiana | 22015 | 9163 | 200 |
892357 | 892357 | 2021-01-03 | Bossier | Louisiana | 22015 | 9144 | 199 |
889111 | 889111 | 2021-01-02 | Bossier | Louisiana | 22015 | 8979 | 199 |
885865 | 885865 | 2021-01-01 | Bossier | Louisiana | 22015 | 8979 | 199 |
882620 | 882620 | 2020-12-31 | Bossier | Louisiana | 22015 | 8979 | 199 |
879375 | 879375 | 2020-12-30 | Bossier | Louisiana | 22015 | 8868 | 194 |
876130 | 876130 | 2020-12-29 | Bossier | Louisiana | 22015 | 8615 | 194 |
872885 | 872885 | 2020-12-28 | Bossier | Louisiana | 22015 | 8497 | 193 |
869640 | 869640 | 2020-12-27 | Bossier | Louisiana | 22015 | 8478 | 190 |
866395 | 866395 | 2020-12-26 | Bossier | Louisiana | 22015 | 8297 | 188 |
863150 | 863150 | 2020-12-25 | Bossier | Louisiana | 22015 | 8297 | 188 |
859905 | 859905 | 2020-12-24 | Bossier | Louisiana | 22015 | 8297 | 188 |
856660 | 856660 | 2020-12-23 | Bossier | Louisiana | 22015 | 8244 | 186 |
853415 | 853415 | 2020-12-22 | Bossier | Louisiana | 22015 | 8112 | 187 |
850170 | 850170 | 2020-12-21 | Bossier | Louisiana | 22015 | 8026 | 185 |
846925 | 846925 | 2020-12-20 | Bossier | Louisiana | 22015 | 7991 | 177 |
843679 | 843679 | 2020-12-19 | Bossier | Louisiana | 22015 | 7801 | 170 |
840434 | 840434 | 2020-12-18 | Bossier | Louisiana | 22015 | 7801 | 170 |
837189 | 837189 | 2020-12-17 | Bossier | Louisiana | 22015 | 7712 | 170 |
833943 | 833943 | 2020-12-16 | Bossier | Louisiana | 22015 | 7569 | 170 |
830696 | 830696 | 2020-12-15 | Bossier | Louisiana | 22015 | 7455 | 170 |
827450 | 827450 | 2020-12-14 | Bossier | Louisiana | 22015 | 7394 | 170 |
824203 | 824203 | 2020-12-13 | Bossier | Louisiana | 22015 | 7384 | 164 |
820957 | 820957 | 2020-12-12 | Bossier | Louisiana | 22015 | 7237 | 163 |
817711 | 817711 | 2020-12-11 | Bossier | Louisiana | 22015 | 7237 | 163 |
814465 | 814465 | 2020-12-10 | Bossier | Louisiana | 22015 | 7145 | 163 |
811220 | 811220 | 2020-12-09 | Bossier | Louisiana | 22015 | 7062 | 163 |
807975 | 807975 | 2020-12-08 | Bossier | Louisiana | 22015 | 6976 | 160 |
804730 | 804730 | 2020-12-07 | Bossier | Louisiana | 22015 | 6897 | 159 |
801485 | 801485 | 2020-12-06 | Bossier | Louisiana | 22015 | 6875 | 158 |
798240 | 798240 | 2020-12-05 | Bossier | Louisiana | 22015 | 6734 | 158 |
794995 | 794995 | 2020-12-04 | Bossier | Louisiana | 22015 | 6734 | 158 |
791750 | 791750 | 2020-12-03 | Bossier | Louisiana | 22015 | 6596 | 158 |
788505 | 788505 | 2020-12-02 | Bossier | Louisiana | 22015 | 6528 | 158 |
785261 | 785261 | 2020-12-01 | Bossier | Louisiana | 22015 | 6410 | 156 |
782016 | 782016 | 2020-11-30 | Bossier | Louisiana | 22015 | 6289 | 153 |
778770 | 778770 | 2020-11-29 | Bossier | Louisiana | 22015 | 6286 | 152 |
775525 | 775525 | 2020-11-28 | Bossier | Louisiana | 22015 | 6244 | 152 |
772280 | 772280 | 2020-11-27 | Bossier | Louisiana | 22015 | 6244 | 152 |
769035 | 769035 | 2020-11-26 | Bossier | Louisiana | 22015 | 6079 | 149 |
765789 | 765789 | 2020-11-25 | Bossier | Louisiana | 22015 | 6079 | 149 |
762544 | 762544 | 2020-11-24 | Bossier | Louisiana | 22015 | 6034 | 147 |
759299 | 759299 | 2020-11-23 | Bossier | Louisiana | 22015 | 5916 | 147 |
756052 | 756052 | 2020-11-22 | Bossier | Louisiana | 22015 | 5900 | 145 |
752806 | 752806 | 2020-11-21 | Bossier | Louisiana | 22015 | 5774 | 144 |
749560 | 749560 | 2020-11-20 | Bossier | Louisiana | 22015 | 5774 | 144 |
746314 | 746314 | 2020-11-19 | Bossier | Louisiana | 22015 | 5625 | 141 |
743067 | 743067 | 2020-11-18 | Bossier | Louisiana | 22015 | 5424 | 141 |
739820 | 739820 | 2020-11-17 | Bossier | Louisiana | 22015 | 5295 | 141 |
736576 | 736576 | 2020-11-16 | Bossier | Louisiana | 22015 | 5193 | 139 |
733330 | 733330 | 2020-11-15 | Bossier | Louisiana | 22015 | 5186 | 139 |
730085 | 730085 | 2020-11-14 | Bossier | Louisiana | 22015 | 5099 | 139 |
726842 | 726842 | 2020-11-13 | Bossier | Louisiana | 22015 | 5099 | 139 |
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);