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_Dose2

✎ 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            
14 14 1831 2021-03-01 FM FMA Federated States of Micronesia 103643 56 56 0            
16 16 1831 2021-03-01 GU GUA Guam 165768 1 1 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            
33 33 1831 2021-03-01 MP MPA Northern Mariana Islands 56882 1 1 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            
78 78 1830 2021-02-28 FM FMA Federated States of Micronesia 103643 56 56 0            
80 80 1830 2021-02-28 GU GUA Guam 165768 1 1 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            
97 97 1830 2021-02-28 MP MPA Northern Mariana Islands 56882 1 1 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            
142 142 1829 2021-02-27 FM FMA Federated States of Micronesia 103643 56 56 0            
144 144 1829 2021-02-27 GU GUA Guam 165768 1 1 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            
161 161 1829 2021-02-27 MP MPA Northern Mariana Islands 56882 1 1 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            
206 206 1828 2021-02-26 FM FMA Federated States of Micronesia 103643 56 56 0            
208 208 1828 2021-02-26 GU GUA Guam 165768 1 1 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            
225 225 1828 2021-02-26 MP MPA Northern Mariana Islands 56882 1 1 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            
270 270 1827 2021-02-25 FM FMA Federated States of Micronesia 103643 56 56 0            
272 272 1827 2021-02-25 GU GUA Guam 165768 1 1 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            
289 289 1827 2021-02-25 MP MPA Northern Mariana Islands 56882 1 1 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            
334 334 1824 2021-02-24 FM FMA Federated States of Micronesia 103643 56 56 0            
336 336 1824 2021-02-24 GU GUA Guam 165768 1 1 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            
353 353 1824 2021-02-24 MP MPA Northern Mariana Islands 56882 1 1 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            
398 398 1821 2021-02-23 FM FMA Federated States of Micronesia 103643 56 56 0            
400 400 1821 2021-02-23 GU GUA Guam 165768 1 1 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            
417 417 1821 2021-02-23 MP MPA Northern Mariana Islands 56882 1 1 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            
462 462 1820 2021-02-22 FM FMA Federated States of Micronesia 103643 56 56 0            
464 464 1820 2021-02-22 GU GUA Guam 165768 1 1 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            
481 481 1820 2021-02-22 MP MPA Northern Mariana Islands 56882 1 1 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            
526 526 1818 2021-02-21 FM FMA Federated States of Micronesia 103643 56 56 0            
528 528 1818 2021-02-21 GU GUA Guam 165768 1 1 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            
545 545 1818 2021-02-21 MP MPA Northern Mariana Islands 56882 1 1 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            
590 590 1817 2021-02-20 FM FMA Federated States of Micronesia 103643 56 56 0            
592 592 1817 2021-02-20 GU GUA Guam 165768 1 1 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            
609 609 1817 2021-02-20 MP MPA Northern Mariana Islands 56882 1 1 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            

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
);