cdc_vaccinations_ltc_timeseries

Table actions
Data provided by Big Local News and snapshotted daily from the COVID19 Tracker, https://covidtracking.com/.

Data source: Big Local News · About: big-local-datasette

2,816 rows sorted by Administered_Fed_LTC_Dose1

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Suggested facets: Date (date)

Link rowid runid Date Location ShortName LongName Census2019 Administered_Fed_LTC Administered_Fed_LTC_Dose1 ▼ Administered_Fed_LTC_Dose2 Administered_Fed_LTC_Dose1_Residents Administered_Fed_LTC_Dose1_Staff Administered_Fed_LTC_Dose1_Unk Administered_Fed_LTC_Dose2_Residents Administered_Fed_LTC_Dose2_Staff Administered_Fed_LTC_Dose2_Unk
4 4 1831 2021-03-01 AS ASA American Samoa 55689 0 0 0            
6 6 1831 2021-03-01 BP2 BP2 Bureau of Prisons 0 0 0 0            
11 11 1831 2021-03-01 DD2 DD2 Dept of Defense 0 0 0 0            
20 20 1831 2021-03-01 IH2 IH2 Indian Health Svc 2082813 0 0 0            
29 29 1831 2021-03-01 MH MHA Marshall Islands 58413 0 0 0            
50 50 1831 2021-03-01 RP RPA Republic of Palau 17907 0 0 0            
57 57 1831 2021-03-01 VA2 VA2 Veterans Health 0 0 0 0            
68 68 1830 2021-02-28 AS ASA American Samoa 55689 0 0 0            
70 70 1830 2021-02-28 BP2 BP2 Bureau of Prisons 0 0 0 0            
75 75 1830 2021-02-28 DD2 DD2 Dept of Defense 0 0 0 0            
84 84 1830 2021-02-28 IH2 IH2 Indian Health Svc 2082813 0 0 0            
93 93 1830 2021-02-28 MH MHA Marshall Islands 58413 0 0 0            
114 114 1830 2021-02-28 RP RPA Republic of Palau 17907 0 0 0            
121 121 1830 2021-02-28 VA2 VA2 Veterans Health 0 0 0 0            
132 132 1829 2021-02-27 AS ASA American Samoa 55689 0 0 0            
134 134 1829 2021-02-27 BP2 BP2 Bureau of Prisons 0 0 0 0            
139 139 1829 2021-02-27 DD2 DD2 Dept of Defense 0 0 0 0            
148 148 1829 2021-02-27 IH2 IH2 Indian Health Svc 2082813 0 0 0            
157 157 1829 2021-02-27 MH MHA Marshall Islands 58413 0 0 0            
178 178 1829 2021-02-27 RP RPA Republic of Palau 17907 0 0 0            
185 185 1829 2021-02-27 VA2 VA2 Veterans Health 0 0 0 0            
196 196 1828 2021-02-26 AS ASA American Samoa 55689 0 0 0            
198 198 1828 2021-02-26 BP2 BP2 Bureau of Prisons 0 0 0 0            
203 203 1828 2021-02-26 DD2 DD2 Dept of Defense 0 0 0 0            
212 212 1828 2021-02-26 IH2 IH2 Indian Health Svc 2082813 0 0 0            
221 221 1828 2021-02-26 MH MHA Marshall Islands 58413 0 0 0            
242 242 1828 2021-02-26 RP RPA Republic of Palau 17907 0 0 0            
249 249 1828 2021-02-26 VA2 VA2 Veterans Health 0 0 0 0            
260 260 1827 2021-02-25 AS ASA American Samoa 55689 0 0 0            
262 262 1827 2021-02-25 BP2 BP2 Bureau of Prisons 0 0 0 0            
267 267 1827 2021-02-25 DD2 DD2 Dept of Defense 0 0 0 0            
276 276 1827 2021-02-25 IH2 IH2 Indian Health Svc 2082813 0 0 0            
285 285 1827 2021-02-25 MH MHA Marshall Islands 58413 0 0 0            
306 306 1827 2021-02-25 RP RPA Republic of Palau 17907 0 0 0            
313 313 1827 2021-02-25 VA2 VA2 Veterans Health 0 0 0 0            
324 324 1824 2021-02-24 AS ASA American Samoa 55689 0 0 0            
326 326 1824 2021-02-24 BP2 BP2 Bureau of Prisons 0 0 0 0            
331 331 1824 2021-02-24 DD2 DD2 Dept of Defense 0 0 0 0            
340 340 1824 2021-02-24 IH2 IH2 Indian Health Svc 2082813 0 0 0            
349 349 1824 2021-02-24 MH MHA Marshall Islands 58413 0 0 0            
370 370 1824 2021-02-24 RP RPA Republic of Palau 17907 0 0 0            
377 377 1824 2021-02-24 VA2 VA2 Veterans Health 0 0 0 0            
388 388 1825 2021-02-25 AS ASA American Samoa 55689 0 0 0            
390 390 1825 2021-02-25 BP2 BP2 Bureau of Prisons 0 0 0 0            
395 395 1825 2021-02-25 DD2 DD2 Dept of Defense 0 0 0 0            
404 404 1825 2021-02-25 IH2 IH2 Indian Health Svc 2082813 0 0 0            
413 413 1825 2021-02-25 MH MHA Marshall Islands 58413 0 0 0            
434 434 1825 2021-02-25 RP RPA Republic of Palau 17907 0 0 0            
441 441 1825 2021-02-25 VA2 VA2 Veterans Health 0 0 0 0            
452 452 1824 2021-02-24 AS ASA American Samoa 55689 0 0 0            
454 454 1824 2021-02-24 BP2 BP2 Bureau of Prisons 0 0 0 0            
459 459 1824 2021-02-24 DD2 DD2 Dept of Defense 0 0 0 0            
468 468 1824 2021-02-24 IH2 IH2 Indian Health Svc 2082813 0 0 0            
477 477 1824 2021-02-24 MH MHA Marshall Islands 58413 0 0 0            
498 498 1824 2021-02-24 RP RPA Republic of Palau 17907 0 0 0            
505 505 1824 2021-02-24 VA2 VA2 Veterans Health 0 0 0 0            
516 516 1821 2021-02-23 AS ASA American Samoa 55689 0 0 0            
518 518 1821 2021-02-23 BP2 BP2 Bureau of Prisons 0 0 0 0            
523 523 1821 2021-02-23 DD2 DD2 Dept of Defense 0 0 0 0            
532 532 1821 2021-02-23 IH2 IH2 Indian Health Svc 2082813 0 0 0            
541 541 1821 2021-02-23 MH MHA Marshall Islands 58413 0 0 0            
562 562 1821 2021-02-23 RP RPA Republic of Palau 17907 0 0 0            
569 569 1821 2021-02-23 VA2 VA2 Veterans Health 0 0 0 0            
580 580 1820 2021-02-22 AS ASA American Samoa 55689 0 0 0            
582 582 1820 2021-02-22 BP2 BP2 Bureau of Prisons 0 0 0 0            
587 587 1820 2021-02-22 DD2 DD2 Dept of Defense 0 0 0 0            
596 596 1820 2021-02-22 IH2 IH2 Indian Health Svc 2082813 0 0 0            
605 605 1820 2021-02-22 MH MHA Marshall Islands 58413 0 0 0            
626 626 1820 2021-02-22 RP RPA Republic of Palau 17907 0 0 0            
633 633 1820 2021-02-22 VA2 VA2 Veterans Health 0 0 0 0            
644 644 1819 2021-02-22 AS ASA American Samoa 55689 0 0 0            
646 646 1819 2021-02-22 BP2 BP2 Bureau of Prisons 0 0 0 0            
651 651 1819 2021-02-22 DD2 DD2 Dept of Defense 0 0 0 0            
660 660 1819 2021-02-22 IH2 IH2 Indian Health Svc 2082813 0 0 0            
669 669 1819 2021-02-22 MH MHA Marshall Islands 58413 0 0 0            
690 690 1819 2021-02-22 RP RPA Republic of Palau 17907 0 0 0            
697 697 1819 2021-02-22 VA2 VA2 Veterans Health 0 0 0 0            
708 708 1818 2021-02-21 AS ASA American Samoa 55689 0 0 0            
710 710 1818 2021-02-21 BP2 BP2 Bureau of Prisons 0 0 0 0            
715 715 1818 2021-02-21 DD2 DD2 Dept of Defense 0 0 0 0            
724 724 1818 2021-02-21 IH2 IH2 Indian Health Svc 2082813 0 0 0            
733 733 1818 2021-02-21 MH MHA Marshall Islands 58413 0 0 0            
754 754 1818 2021-02-21 RP RPA Republic of Palau 17907 0 0 0            
761 761 1818 2021-02-21 VA2 VA2 Veterans Health 0 0 0 0            
772 772 1817 2021-02-20 AS ASA American Samoa 55689 0 0 0            
774 774 1817 2021-02-20 BP2 BP2 Bureau of Prisons 0 0 0 0            
779 779 1817 2021-02-20 DD2 DD2 Dept of Defense 0 0 0 0            
788 788 1817 2021-02-20 IH2 IH2 Indian Health Svc 2082813 0 0 0            
797 797 1817 2021-02-20 MH MHA Marshall Islands 58413 0 0 0            
818 818 1817 2021-02-20 RP RPA Republic of Palau 17907 0 0 0            
825 825 1817 2021-02-20 VA2 VA2 Veterans Health 0 0 0 0            
836 836 1816 2021-02-20 AS ASA American Samoa 55689 0 0 0            
838 838 1816 2021-02-20 BP2 BP2 Bureau of Prisons 0 0 0 0            
843 843 1816 2021-02-20 DD2 DD2 Dept of Defense 0 0 0 0            
852 852 1816 2021-02-20 IH2 IH2 Indian Health Svc 2082813 0 0 0            
861 861 1816 2021-02-20 MH MHA Marshall Islands 58413 0 0 0            
882 882 1816 2021-02-20 RP RPA Republic of Palau 17907 0 0 0            
889 889 1816 2021-02-20 VA2 VA2 Veterans Health 0 0 0 0            
900 900 1810 2021-02-19 AS ASA American Samoa 55689 0 0 0            
902 902 1810 2021-02-19 BP2 BP2 Bureau of Prisons 0 0 0 0            

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE [cdc_vaccinations_ltc_timeseries] (
   [runid] INTEGER,
   [Date] TEXT,
   [Location] TEXT,
   [ShortName] TEXT,
   [LongName] TEXT,
   [Census2019] INTEGER,
   [Administered_Fed_LTC] INTEGER,
   [Administered_Fed_LTC_Dose1] INTEGER,
   [Administered_Fed_LTC_Dose2] INTEGER,
   [Administered_Fed_LTC_Dose1_Residents] INTEGER,
   [Administered_Fed_LTC_Dose1_Staff] INTEGER,
   [Administered_Fed_LTC_Dose1_Unk] INTEGER,
   [Administered_Fed_LTC_Dose2_Residents] INTEGER,
   [Administered_Fed_LTC_Dose2_Staff] INTEGER,
   [Administered_Fed_LTC_Dose2_Unk] INTEGER
);