cdc_vaccinations_ltc_timeseries_daily

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,304 rows sorted by Administered_Fed_LTC

✎ 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 1821 2021-02-23 AS ASA American Samoa 55689 0 0 0            
390 390 1821 2021-02-23 BP2 BP2 Bureau of Prisons 0 0 0 0            
395 395 1821 2021-02-23 DD2 DD2 Dept of Defense 0 0 0 0            
404 404 1821 2021-02-23 IH2 IH2 Indian Health Svc 2082813 0 0 0            
413 413 1821 2021-02-23 MH MHA Marshall Islands 58413 0 0 0            
434 434 1821 2021-02-23 RP RPA Republic of Palau 17907 0 0 0            
441 441 1821 2021-02-23 VA2 VA2 Veterans Health 0 0 0 0            
452 452 1820 2021-02-22 AS ASA American Samoa 55689 0 0 0            
454 454 1820 2021-02-22 BP2 BP2 Bureau of Prisons 0 0 0 0            
459 459 1820 2021-02-22 DD2 DD2 Dept of Defense 0 0 0 0            
468 468 1820 2021-02-22 IH2 IH2 Indian Health Svc 2082813 0 0 0            
477 477 1820 2021-02-22 MH MHA Marshall Islands 58413 0 0 0            
498 498 1820 2021-02-22 RP RPA Republic of Palau 17907 0 0 0            
505 505 1820 2021-02-22 VA2 VA2 Veterans Health 0 0 0 0            
516 516 1818 2021-02-21 AS ASA American Samoa 55689 0 0 0            
518 518 1818 2021-02-21 BP2 BP2 Bureau of Prisons 0 0 0 0            
523 523 1818 2021-02-21 DD2 DD2 Dept of Defense 0 0 0 0            
532 532 1818 2021-02-21 IH2 IH2 Indian Health Svc 2082813 0 0 0            
541 541 1818 2021-02-21 MH MHA Marshall Islands 58413 0 0 0            
562 562 1818 2021-02-21 RP RPA Republic of Palau 17907 0 0 0            
569 569 1818 2021-02-21 VA2 VA2 Veterans Health 0 0 0 0            
580 580 1817 2021-02-20 AS ASA American Samoa 55689 0 0 0            
582 582 1817 2021-02-20 BP2 BP2 Bureau of Prisons 0 0 0 0            
587 587 1817 2021-02-20 DD2 DD2 Dept of Defense 0 0 0 0            
596 596 1817 2021-02-20 IH2 IH2 Indian Health Svc 2082813 0 0 0            
605 605 1817 2021-02-20 MH MHA Marshall Islands 58413 0 0 0            
626 626 1817 2021-02-20 RP RPA Republic of Palau 17907 0 0 0            
633 633 1817 2021-02-20 VA2 VA2 Veterans Health 0 0 0 0            
644 644 1810 2021-02-19 AS ASA American Samoa 55689 0 0 0            
646 646 1810 2021-02-19 BP2 BP2 Bureau of Prisons 0 0 0 0            
651 651 1810 2021-02-19 DD2 DD2 Dept of Defense 0 0 0 0            
660 660 1810 2021-02-19 IH2 IH2 Indian Health Svc 2082813 0 0 0            
669 669 1810 2021-02-19 MH MHA Marshall Islands 58413 0 0 0            
690 690 1810 2021-02-19 RP RPA Republic of Palau 17907 0 0 0            
697 697 1810 2021-02-19 VA2 VA2 Veterans Health 0 0 0 0            
708 708 1806 2021-02-18 AS ASA American Samoa 55689 0 0 0            
710 710 1806 2021-02-18 BP2 BP2 Bureau of Prisons 0 0 0 0            
715 715 1806 2021-02-18 DD2 DD2 Dept of Defense 0 0 0 0            
724 724 1806 2021-02-18 IH2 IH2 Indian Health Svc 2033753 0 0 0            
733 733 1806 2021-02-18 MH MHA Marshall Islands 58413 0 0 0            
754 754 1806 2021-02-18 RP RPA Republic of Palau 17907 0 0 0            
761 761 1806 2021-02-18 VA2 VA2 Veterans Health 0 0 0 0            
772 772 1804 2021-02-17 AS ASA American Samoa 55689 0 0 0            
774 774 1804 2021-02-17 BP2 BP2 Bureau of Prisons 0 0 0 0            
779 779 1804 2021-02-17 DD2 DD2 Dept of Defense 0 0 0 0            
788 788 1804 2021-02-17 IH2 IH2 Indian Health Svc 2033753 0 0 0            
797 797 1804 2021-02-17 MH MHA Marshall Islands 58413 0 0 0            
818 818 1804 2021-02-17 RP RPA Republic of Palau 17907 0 0 0            
825 825 1804 2021-02-17 VA2 VA2 Veterans Health 0 0 0 0            
836 836 1801 2021-02-16 AS ASA American Samoa 55689 0 0 0            
838 838 1801 2021-02-16 BP2 BP2 Bureau of Prisons 0 0 0 0            
843 843 1801 2021-02-16 DD2 DD2 Dept of Defense 0 0 0 0            
848 848 1801 2021-02-16 GU GUA Guam 165768 0 0 0            
852 852 1801 2021-02-16 IH2 IH2 Indian Health Svc 0 0 0 0            
861 861 1801 2021-02-16 MH MHA Marshall Islands 58413 0 0 0            
882 882 1801 2021-02-16 RP RPA Republic of Palau 17907 0 0 0            
889 889 1801 2021-02-16 VA2 VA2 Veterans Health 0 0 0 0            
900 900 1800 2021-02-14 AS ASA American Samoa 55689 0 0 0            

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE [cdc_vaccinations_ltc_timeseries_daily] (
   [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
);