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 |
---|---|---|---|---|---|---|---|
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 |
723599 | 723599 | 2020-11-12 | Bossier | Louisiana | 22015 | 4817 | 127 |
720356 | 720356 | 2020-11-11 | Bossier | Louisiana | 22015 | 4717 | 127 |
717113 | 717113 | 2020-11-10 | Bossier | Louisiana | 22015 | 4717 | 127 |
713869 | 713869 | 2020-11-09 | Bossier | Louisiana | 22015 | 4660 | 126 |
710625 | 710625 | 2020-11-08 | Bossier | Louisiana | 22015 | 4636 | 126 |
707381 | 707381 | 2020-11-07 | Bossier | Louisiana | 22015 | 4572 | 125 |
704138 | 704138 | 2020-11-06 | Bossier | Louisiana | 22015 | 4572 | 125 |
700896 | 700896 | 2020-11-05 | Bossier | Louisiana | 22015 | 4550 | 124 |
697652 | 697652 | 2020-11-04 | Bossier | Louisiana | 22015 | 4468 | 123 |
694409 | 694409 | 2020-11-03 | Bossier | Louisiana | 22015 | 4446 | 123 |
691167 | 691167 | 2020-11-02 | Bossier | Louisiana | 22015 | 4399 | 122 |
687922 | 687922 | 2020-11-01 | Bossier | Louisiana | 22015 | 4381 | 122 |
684678 | 684678 | 2020-10-31 | Bossier | Louisiana | 22015 | 4339 | 121 |
681435 | 681435 | 2020-10-30 | Bossier | Louisiana | 22015 | 4339 | 121 |
678191 | 678191 | 2020-10-29 | Bossier | Louisiana | 22015 | 4322 | 121 |
674949 | 674949 | 2020-10-28 | Bossier | Louisiana | 22015 | 4286 | 120 |
671706 | 671706 | 2020-10-27 | Bossier | Louisiana | 22015 | 4259 | 120 |
668464 | 668464 | 2020-10-26 | Bossier | Louisiana | 22015 | 4212 | 120 |
665220 | 665220 | 2020-10-25 | Bossier | Louisiana | 22015 | 4188 | 117 |
661975 | 661975 | 2020-10-24 | Bossier | Louisiana | 22015 | 4129 | 117 |
658731 | 658731 | 2020-10-23 | Bossier | Louisiana | 22015 | 4129 | 117 |
655486 | 655486 | 2020-10-22 | Bossier | Louisiana | 22015 | 4082 | 117 |
652241 | 652241 | 2020-10-21 | Bossier | Louisiana | 22015 | 4023 | 117 |
648996 | 648996 | 2020-10-20 | Bossier | Louisiana | 22015 | 3983 | 117 |
645752 | 645752 | 2020-10-19 | Bossier | Louisiana | 22015 | 3909 | 116 |
642505 | 642505 | 2020-10-18 | Bossier | Louisiana | 22015 | 3894 | 115 |
639258 | 639258 | 2020-10-17 | Bossier | Louisiana | 22015 | 3821 | 112 |
636012 | 636012 | 2020-10-16 | Bossier | Louisiana | 22015 | 3821 | 112 |
632766 | 632766 | 2020-10-15 | Bossier | Louisiana | 22015 | 3761 | 111 |
629522 | 629522 | 2020-10-14 | Bossier | Louisiana | 22015 | 3692 | 111 |
626278 | 626278 | 2020-10-13 | Bossier | Louisiana | 22015 | 3674 | 111 |
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);