daily_reports
Data source: CDC · About: simonw/cdc-vaccination-history
13 rows where Distributed_Unk_Manuf = 450
This data as json, CSV (advanced)
id ▼ | Date | Location | ShortName | LongName | Census2019 | Doses_Distributed | Doses_Administered | Dist_Per_100K | Admin_Per_100K | Administered_Dose1 | Administered_Dose1_Per_100K | Administered_Dose2 | Administered_Dose2_Per_100K | Administered_Dose1_Pop_Pct | Administered_Dose2_Pop_Pct | date_type | Recip_Administered | Administered_Dose1_Recip | Administered_Dose2_Recip | Administered_Dose1_Recip_18Plus | Administered_Dose2_Recip_18Plus | Administered_Dose1_Recip_18PlusPop_Pct | Administered_Dose2_Recip_18PlusPop_Pct | Census2019_18PlusPop | Distributed_Per_100k_18Plus | Administered_18Plus | Admin_Per_100k_18Plus | Administered_Moderna | Administered_Pfizer | Administered_Unk_Manuf | Administered_Janssen | Administered_Dose1_Recip_65Plus | Administered_Dose1_Recip_65PlusPop_Pct | Administered_65Plus | Admin_Per_100k_65Plus | Distributed_Moderna | Distributed_Pfizer | Distributed_Janssen | Distributed_Unk_Manuf | Series_Complete_Moderna | Series_Complete_Pfizer | Series_Complete_Janssen | Series_Complete_Unk_Manuf | Series_Complete_Moderna_18Plus | Series_Complete_Pfizer_18Plus | Series_Complete_Janssen_18Plus | Series_Complete_Unk_Manuf_18Plus | Series_Complete_Moderna_65Plus | Series_Complete_Pfizer_65Plus | Series_Complete_Janssen_65Plus | Series_Complete_Unk_Manuf_65Plus | Series_Complete_Yes | Series_Complete_Pop_Pct | Series_Complete_18Plus | Series_Complete_18PlusPop_Pct | Series_Complete_65Plus | Series_Complete_65PlusPop_Pct | Administered_Fed_LTC | Administered_Fed_LTC_Dose1 | Administered_Fed_LTC_Dose2 | Series_Complete_FedLTC | Distributed_Per_100k_65Plus | Administered_65Plus_Entity | Census2019_12PlusPop | Administered_12Plus | Admin_Per_100k_12Plus | Distributed_Per_100k_12Plus | Administered_Dose1_Recip_12Plus | Administered_Dose1_Recip_12PlusPop_Pct | Administered_Dose2_Recip_12Plus | Administered_Dose2_Recip_12PlusPop_Pct | Series_Complete_12Plus | Series_Complete_12PlusPop_Pct | Series_Complete_Moderna_12Plus | Series_Complete_Pfizer_12Plus | Series_Complete_Janssen_12Plus | Series_Complete_Unk_Manuf_12Plus | Administered_12Plus_Entity | Count_70pct_vacc | additional_doses | Additional_Doses_Vax_Pct | Additional_Doses_50Plus | Additional_Doses_50Plus_Vax_Pct | Additional_Doses_18Plus | Additional_Doses_18Plus_Vax_Pct | Additional_Doses_65Plus | Additional_Doses_65Plus_Vax_Pct | Additional_Doses_Moderna | Additional_Doses_Pfizer | Additional_Doses_Janssen | Additional_Doses_Unk_Manuf | Moderna_Any_Booster_noTX | Pfizer_Any_Booster_noTX | Janssen_Any_Booster_noTX | Unk_Any_Booster_noTX | Additional_Dose_Moderna_noTX | Additional_Dose_Pfizer_noTX | Additional_Dose_Janssen_noTX | Additional_Dose_Unk_noTX | Moderna_Moderna_Booster | Moderna_Pfizer_Booster | Moderna_Janssen_Booster | Moderna_Unk_Booster | Pfizer_Moderna_Booster | Pfizer_Pfizer_Booster | Pfizer_Janssen_Booster | Pfizer_Unk_Booster | Janssen_Moderna_Booster | Janssen_Pfizer_Booster | Janssen_Janssen_Booster | Janssen_Unk_Booster | Unk_Moderna_Booster | Unk_Pfizer_Booster | Unk_Janssen_Booster | Unk_Unk_Booster | Moderna_Moderna_Booster_Pct | Moderna_Pfizer_Booster_Pct | Moderna_Janssen_Booster_Pct | Moderna_Unk_Booster_Pct | Pfizer_Moderna_Booster_Pct | Pfizer_Pfizer_Booster_Pct | Pfizer_Janssen_Booster_Pct | Pfizer_Unk_Booster_Pct | Janssen_Moderna_Booster_Pct | Janssen_Pfizer_Booster_Pct | Janssen_Janssen_Booster_Pct | Janssen_Unk_Booster_Pct | Unk_Moderna_Booster_Pct | Unk_Pfizer_Booster_Pct | Unk_Janssen_Booster_Pct | Unk_Unk_Booster_Pct | Administered_Dose1_Recip_5Plus | Administered_Dose1_Recip_5PlusPop_Pct | Series_Complete_5PlusPop_Pct | Series_Complete_5Plus | Administered_5Plus | Admin_Per_100k_5Plus | Distributed_Per_100k_5Plus | Series_Complete_Moderna_5Plus | Series_Complete_Pfizer_5Plus | Series_Complete_Janssen_5Plus | Series_Complete_Unk_Manuf_5Plus | Booster_Eligible_NotBoosted | Booster_Eligible_NotBoosted_Pct | Booster_Eligible_NotBoosted_18Plus | Booster_Eligible_NotBoosted_18Plus_Pct | Booster_Eligible_NotBoosted_50Plus | Booster_Eligible_NotBoosted_50Plus_Pct | Booster_Eligible_NotBoosted_65Plus | Booster_Eligible_NotBoosted_65Plus_Pct | Booster_Eligible_NotBoosted_12Plus | Booster_Eligible_NotBoosted_12Plus_Pct | Additional_Doses_12Plus | Additional_Doses_12Plus_Vax_Pct | Second_Booster | Second_Booster_50plus | Second_Booster_65plus | Second_Booster_Vax_Pct | Second_Booster_50plus_Vax_Pct | Second_Booster_65plus_Vax_Pct | Second_Booster_Moderna | Second_Booster_Pfizer | Second_Booster_Janssen | Second_Booster_Unk_Manuf | Additional_Doses_5Plus | Additional_Doses_5Plus_Vax_Pct | Administered_Dose1_<5 | Administered_Novavax | Distributed_Novavax | Series_Complete_Novavax | Administered_Bivalent | Dist_Bivalent_MOD | Dist_Bivalent_PFR | Admin_Bivalent_MOD | Admin_Bivalent_PFR |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
DD2-2021-06-24 | 2021-06-24 | DD2 | DD2 | Dept of Defense | 0 | 5396080 | 4024448 | 0 | 0 | 0.0 | 0 | Report | 2334155 | 1596576 | 2252246 | 1551610 | 0.0 | 0.0 | 0 | 3896914 | 0 | 1670753 | 2206762 | 520 | 146413 | 181315 | 0.0 | 323637 | 0 | 2842420 | 2366910 | 186300 | 450 | 674304 | 922272 | 143495 | 0 | 674217 | 877393 | 143405 | 0 | 48020 | 79950 | 5794 | 0 | 1740071 | 0.0 | 1695015 | 0.0 | 133764 | 0.0 | 0 | 323637 | 0 | 4021874 | 0 | 0 | 2331677 | 0.0 | 1596481 | 0.0 | 1739959 | 0.0 | 674281 | 922200 | 143478 | 0 | 4021874 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
DD2-2021-06-25 | 2021-06-25 | DD2 | DD2 | Dept of Defense | 0 | 4396060 | 4039898 | 0 | 0 | 0.0 | 0 | Report | 2341206 | 1604784 | 2258269 | 1557955 | 0.0 | 0.0 | 0 | 3909459 | 0 | 1674384 | 2216805 | 978 | 147731 | 181549 | 0.0 | 324105 | 0 | 1842400 | 2366910 | 186300 | 450 | 676595 | 928189 | 144813 | 0 | 676506 | 881449 | 144723 | 0 | 48107 | 80091 | 5817 | 0 | 1749597 | 0.0 | 1702678 | 0.0 | 134015 | 0.0 | 0 | 324105 | 0 | 4037324 | 0 | 0 | 2338728 | 0.0 | 1604689 | 0.0 | 1749485 | 0.0 | 676572 | 928117 | 144796 | 0 | 4037324 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
DD2-2021-06-26 | 2021-06-26 | DD2 | DD2 | Dept of Defense | 0 | 4396060 | 4056097 | 0 | 0 | 0.0 | 0 | Report | 2348266 | 1613703 | 2264274 | 1565440 | 0.0 | 0.0 | 0 | 3923147 | 0 | 1679474 | 2226991 | 987 | 148645 | 181790 | 0.0 | 324585 | 0 | 1842400 | 2366910 | 186300 | 450 | 679745 | 933958 | 145727 | 0 | 679654 | 885786 | 145636 | 0 | 48200 | 80228 | 5849 | 0 | 1759430 | 0.0 | 1711076 | 0.0 | 134277 | 0.0 | 0 | 324585 | 0 | 4053523 | 0 | 0 | 2345788 | 0.0 | 1613608 | 0.0 | 1759318 | 0.0 | 679722 | 933886 | 145710 | 0 | 4053523 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
DD2-2021-06-27 | 2021-06-27 | DD2 | DD2 | Dept of Defense | 0 | 4396060 | 4056097 | 0 | 0 | 0.0 | 0 | Report | 2348266 | 1613703 | 2264274 | 1565440 | 0.0 | 0.0 | 0 | 3923147 | 0 | 1679474 | 2226991 | 987 | 148645 | 181790 | 0.0 | 324585 | 0 | 1842400 | 2366910 | 186300 | 450 | 679745 | 933958 | 145727 | 0 | 679654 | 885786 | 145636 | 0 | 48200 | 80228 | 5849 | 0 | 1759430 | 0.0 | 1711076 | 0.0 | 134277 | 0.0 | 0 | 324585 | 0 | 4053523 | 0 | 0 | 2345788 | 0.0 | 1613608 | 0.0 | 1759318 | 0.0 | 679722 | 933886 | 145710 | 0 | 4053523 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
DD2-2021-06-28 | 2021-06-28 | DD2 | DD2 | Dept of Defense | 0 | 4396060 | 4120562 | 0 | 0 | 0.0 | 0 | Report | 2372897 | 1644676 | 2285939 | 1592775 | 0.0 | 0.0 | 0 | 3980065 | 0 | 1699904 | 2269312 | 1031 | 150315 | 183194 | 0.0 | 327626 | 0 | 1842400 | 2366910 | 186300 | 450 | 691551 | 953125 | 147397 | 0 | 691457 | 901318 | 147304 | 0 | 48778 | 80970 | 5942 | 0 | 1792073 | 0.0 | 1740079 | 0.0 | 135690 | 0.0 | 0 | 327626 | 0 | 4117984 | 0 | 0 | 2370416 | 0.0 | 1644580 | 0.0 | 1791960 | 0.0 | 691528 | 953052 | 147380 | 0 | 4117984 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
DD2-2021-06-29 | 2021-06-29 | DD2 | DD2 | Dept of Defense | 0 | 4396060 | 4166924 | 0 | 0 | 0.0 | 0 | Report | 2395321 | 1657063 | 2306921 | 1603569 | 0.0 | 0.0 | 0 | 4022575 | 0 | 1713632 | 2301285 | 1038 | 150969 | 184841 | 0.0 | 330624 | 0 | 1842400 | 2366910 | 186300 | 450 | 694938 | 962124 | 148051 | 1 | 694844 | 908724 | 147954 | 1 | 49103 | 81477 | 5997 | 0 | 1805114 | 0.0 | 1751523 | 0.0 | 136577 | 0.0 | 0 | 330624 | 0 | 4164345 | 0 | 0 | 2392839 | 0.0 | 1656967 | 0.0 | 1805001 | 0.0 | 694915 | 962051 | 148034 | 1 | 4164345 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
DD2-2021-06-30 | 2021-06-30 | DD2 | DD2 | Dept of Defense | 0 | 4396060 | 4205568 | 0 | 0 | 0.0 | 0 | Report | 2410058 | 1665320 | 2320754 | 1610751 | 0.0 | 0.0 | 0 | 4058835 | 0 | 1724295 | 2328303 | 1048 | 151922 | 186493 | 0.0 | 333643 | 0 | 1842400 | 2366910 | 186300 | 450 | 697253 | 968066 | 149003 | 1 | 697159 | 913591 | 148904 | 1 | 49352 | 81725 | 6035 | 0 | 1814323 | 0.0 | 1759655 | 0.0 | 137112 | 0.0 | 0 | 333643 | 0 | 4202987 | 0 | 0 | 2407574 | 0.0 | 1665224 | 0.0 | 1814210 | 0.0 | 697230 | 967993 | 148986 | 1 | 4202987 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
DD2-2021-07-01 | 2021-07-01 | DD2 | DD2 | Dept of Defense | 0 | 4396060 | 4229739 | 0 | 0 | 0.0 | 0 | Report | 2420375 | 1672891 | 2330169 | 1617196 | 0.0 | 0.0 | 0 | 4080886 | 0 | 1731550 | 2344173 | 1054 | 152962 | 187485 | 0.0 | 335407 | 0 | 1842400 | 2366910 | 186300 | 450 | 699342 | 973548 | 150041 | 1 | 699245 | 917950 | 149942 | 1 | 49520 | 81926 | 6064 | 0 | 1822932 | 0.0 | 1767138 | 0.0 | 137510 | 0.0 | 0 | 335407 | 0 | 4227157 | 0 | 0 | 2417890 | 0.0 | 1672795 | 0.0 | 1822819 | 0.0 | 699319 | 973475 | 150024 | 1 | 4227157 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
DD2-2021-07-02 | 2021-07-02 | DD2 | DD2 | Dept of Defense | 0 | 4396060 | 4244303 | 0 | 0 | 0.0 | 0 | Report | 2426962 | 1680686 | 2335902 | 1623844 | 0.0 | 0.0 | 0 | 4093442 | 0 | 1735242 | 2353850 | 1068 | 154143 | 187674 | 0.0 | 335801 | 0 | 1842400 | 2366910 | 186300 | 450 | 701498 | 979187 | 151222 | 1 | 701400 | 922443 | 151121 | 1 | 49582 | 82067 | 6090 | 0 | 1831908 | 0.0 | 1774965 | 0.0 | 137739 | 0.0 | 0 | 335801 | 0 | 4241721 | 0 | 0 | 2424477 | 0.0 | 1680590 | 0.0 | 1831795 | 0.0 | 701475 | 979114 | 151205 | 1 | 4241721 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
DD2-2021-07-03 | 2021-07-03 | DD2 | DD2 | Dept of Defense | 0 | 4396060 | 4257035 | 0 | 0 | 0.0 | 0 | Report | 2432474 | 1686794 | 2340705 | 1629015 | 0.0 | 0.0 | 0 | 4104508 | 0 | 1738604 | 2362522 | 1076 | 154833 | 187955 | 0.0 | 336281 | 0 | 1842400 | 2366910 | 186300 | 450 | 703016 | 983777 | 151912 | 1 | 702917 | 926097 | 151810 | 1 | 49644 | 82160 | 6110 | 0 | 1838706 | 0.0 | 1780825 | 0.0 | 137914 | 0.0 | 0 | 336281 | 0 | 4254450 | 0 | 0 | 2429987 | 0.0 | 1686697 | 0.0 | 1838592 | 0.0 | 702993 | 983703 | 151895 | 1 | 4254450 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
DD2-2021-07-04 | 2021-07-04 | DD2 | DD2 | Dept of Defense | 0 | 4396060 | 4289104 | 0 | 0 | 0.0 | 0 | Report | 2445298 | 1694934 | 2353127 | 1636743 | 0.0 | 0.0 | 0 | 4135708 | 0 | 1747778 | 2384923 | 1089 | 155314 | 190655 | 0.0 | 340957 | 0 | 1842400 | 2366910 | 186300 | 450 | 705351 | 989582 | 152393 | 1 | 705248 | 931494 | 152291 | 1 | 50014 | 82729 | 6121 | 0 | 1847327 | 0.0 | 1789034 | 0.0 | 138864 | 0.0 | 0 | 340957 | 0 | 4286512 | 0 | 0 | 2442808 | 0.0 | 1694833 | 0.0 | 1847209 | 0.0 | 705325 | 989507 | 152376 | 1 | 4286512 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
DD2-2021-07-06 | 2021-07-06 | DD2 | DD2 | Dept of Defense | 0 | 4396160 | 4341321 | 0 | 0 | 0.0 | 0 | Report | 2461332 | 1711406 | 2368547 | 1652573 | 0.0 | 0.0 | 0 | 4186635 | 0 | 1766836 | 2417682 | 1095 | 155708 | 193297 | 0.0 | 350624 | 0 | 1842500 | 2366910 | 186300 | 450 | 711951 | 999454 | 152787 | 1 | 711847 | 940725 | 152685 | 1 | 50409 | 84035 | 6139 | 0 | 1864193 | 0.0 | 1805258 | 0.0 | 140583 | 0.0 | 0 | 350624 | 0 | 4338725 | 0 | 0 | 2458839 | 0.0 | 1711305 | 0.0 | 1864075 | 0.0 | 711925 | 999379 | 152770 | 1 | 4338725 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
DD2-2021-07-07 | 2021-07-07 | DD2 | DD2 | Dept of Defense | 0 | 4396160 | 4344061 | 0 | 0 | 0.0 | 0 | Report | 2462650 | 1712822 | 2369505 | 1653571 | 0.0 | 0.0 | 0 | 4188596 | 0 | 1767546 | 2419532 | 1097 | 155886 | 193361 | 0.0 | 350744 | 0 | 1842500 | 2366910 | 186300 | 450 | 712417 | 1000404 | 152965 | 1 | 712313 | 941257 | 152863 | 1 | 50425 | 84075 | 6150 | 0 | 1865787 | 0.0 | 1806434 | 0.0 | 140650 | 0.0 | 0 | 350744 | 0 | 4341463 | 0 | 0 | 2460155 | 0.0 | 1712721 | 0.0 | 1865669 | 0.0 | 712391 | 1000329 | 152948 | 1 | 4341463 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE [daily_reports] ( [Date] TEXT, [Location] TEXT, [ShortName] TEXT, [LongName] TEXT, [Census2019] INTEGER, [Doses_Distributed] INTEGER, [Doses_Administered] INTEGER, [Dist_Per_100K] INTEGER, [Admin_Per_100K] INTEGER, [Administered_Dose1] INTEGER, [Administered_Dose1_Per_100K] INTEGER, [Administered_Dose2] INTEGER, [Administered_Dose2_Per_100K] INTEGER, [Administered_Dose1_Pop_Pct] FLOAT, [Administered_Dose2_Pop_Pct] INTEGER, [date_type] TEXT, [Recip_Administered] INTEGER, [Administered_Dose1_Recip] INTEGER, [Administered_Dose2_Recip] INTEGER, [Administered_Dose1_Recip_18Plus] INTEGER, [Administered_Dose2_Recip_18Plus] INTEGER, [Administered_Dose1_Recip_18PlusPop_Pct] FLOAT, [Administered_Dose2_Recip_18PlusPop_Pct] FLOAT, [Census2019_18PlusPop] INTEGER, [Distributed_Per_100k_18Plus] INTEGER, [Administered_18Plus] INTEGER, [Admin_Per_100k_18Plus] INTEGER, [id] TEXT PRIMARY KEY , [Administered_Moderna] INTEGER, [Administered_Pfizer] INTEGER, [Administered_Unk_Manuf] INTEGER, [Administered_Janssen] INTEGER, [Administered_Dose1_Recip_65Plus] INTEGER, [Administered_Dose1_Recip_65PlusPop_Pct] FLOAT, [Administered_65Plus] INTEGER, [Admin_Per_100k_65Plus] INTEGER, [Distributed_Moderna] INTEGER, [Distributed_Pfizer] INTEGER, [Distributed_Janssen] INTEGER, [Distributed_Unk_Manuf] INTEGER, [Series_Complete_Moderna] INTEGER, [Series_Complete_Pfizer] INTEGER, [Series_Complete_Janssen] INTEGER, [Series_Complete_Unk_Manuf] INTEGER, [Series_Complete_Moderna_18Plus] INTEGER, [Series_Complete_Pfizer_18Plus] INTEGER, [Series_Complete_Janssen_18Plus] INTEGER, [Series_Complete_Unk_Manuf_18Plus] INTEGER, [Series_Complete_Moderna_65Plus] INTEGER, [Series_Complete_Pfizer_65Plus] INTEGER, [Series_Complete_Janssen_65Plus] INTEGER, [Series_Complete_Unk_Manuf_65Plus] INTEGER, [Series_Complete_Yes] INTEGER, [Series_Complete_Pop_Pct] FLOAT, [Series_Complete_18Plus] INTEGER, [Series_Complete_18PlusPop_Pct] FLOAT, [Series_Complete_65Plus] INTEGER, [Series_Complete_65PlusPop_Pct] FLOAT, [Administered_Fed_LTC] INTEGER, [Administered_Fed_LTC_Dose1] INTEGER, [Administered_Fed_LTC_Dose2] INTEGER, [Series_Complete_FedLTC] INTEGER, [Distributed_Per_100k_65Plus] INTEGER, [Administered_65Plus_Entity] INTEGER, [Census2019_12PlusPop] INTEGER, [Administered_12Plus] INTEGER, [Admin_Per_100k_12Plus] INTEGER, [Distributed_Per_100k_12Plus] INTEGER, [Administered_Dose1_Recip_12Plus] INTEGER, [Administered_Dose1_Recip_12PlusPop_Pct] FLOAT, [Administered_Dose2_Recip_12Plus] INTEGER, [Administered_Dose2_Recip_12PlusPop_Pct] FLOAT, [Series_Complete_12Plus] INTEGER, [Series_Complete_12PlusPop_Pct] FLOAT, [Series_Complete_Moderna_12Plus] INTEGER, [Series_Complete_Pfizer_12Plus] INTEGER, [Series_Complete_Janssen_12Plus] INTEGER, [Series_Complete_Unk_Manuf_12Plus] INTEGER, [Administered_12Plus_Entity] INTEGER, [Count_70pct_vacc] INTEGER, [additional_doses] INTEGER, [Additional_Doses_Vax_Pct] FLOAT, [Additional_Doses_50Plus] INTEGER, [Additional_Doses_50Plus_Vax_Pct] FLOAT, [Additional_Doses_18Plus] INTEGER, [Additional_Doses_18Plus_Vax_Pct] FLOAT, [Additional_Doses_65Plus] INTEGER, [Additional_Doses_65Plus_Vax_Pct] FLOAT, [Additional_Doses_Moderna] INTEGER, [Additional_Doses_Pfizer] INTEGER, [Additional_Doses_Janssen] INTEGER, [Additional_Doses_Unk_Manuf] INTEGER, [Moderna_Any_Booster_noTX] INTEGER, [Pfizer_Any_Booster_noTX] INTEGER, [Janssen_Any_Booster_noTX] INTEGER, [Unk_Any_Booster_noTX] INTEGER, [Additional_Dose_Moderna_noTX] INTEGER, [Additional_Dose_Pfizer_noTX] INTEGER, [Additional_Dose_Janssen_noTX] INTEGER, [Additional_Dose_Unk_noTX] INTEGER, [Moderna_Moderna_Booster] INTEGER, [Moderna_Pfizer_Booster] INTEGER, [Moderna_Janssen_Booster] INTEGER, [Moderna_Unk_Booster] INTEGER, [Pfizer_Moderna_Booster] INTEGER, [Pfizer_Pfizer_Booster] INTEGER, [Pfizer_Janssen_Booster] INTEGER, [Pfizer_Unk_Booster] INTEGER, [Janssen_Moderna_Booster] INTEGER, [Janssen_Pfizer_Booster] INTEGER, [Janssen_Janssen_Booster] INTEGER, [Janssen_Unk_Booster] INTEGER, [Unk_Moderna_Booster] INTEGER, [Unk_Pfizer_Booster] INTEGER, [Unk_Janssen_Booster] INTEGER, [Unk_Unk_Booster] INTEGER, [Moderna_Moderna_Booster_Pct] FLOAT, [Moderna_Pfizer_Booster_Pct] INTEGER, [Moderna_Janssen_Booster_Pct] FLOAT, [Moderna_Unk_Booster_Pct] FLOAT, [Pfizer_Moderna_Booster_Pct] FLOAT, [Pfizer_Pfizer_Booster_Pct] FLOAT, [Pfizer_Janssen_Booster_Pct] INTEGER, [Pfizer_Unk_Booster_Pct] INTEGER, [Janssen_Moderna_Booster_Pct] FLOAT, [Janssen_Pfizer_Booster_Pct] INTEGER, [Janssen_Janssen_Booster_Pct] FLOAT, [Janssen_Unk_Booster_Pct] FLOAT, [Unk_Moderna_Booster_Pct] FLOAT, [Unk_Pfizer_Booster_Pct] FLOAT, [Unk_Janssen_Booster_Pct] FLOAT, [Unk_Unk_Booster_Pct] FLOAT, [Administered_Dose1_Recip_5Plus] INTEGER, [Administered_Dose1_Recip_5PlusPop_Pct] FLOAT, [Series_Complete_5PlusPop_Pct] FLOAT, [Series_Complete_5Plus] INTEGER, [Administered_5Plus] INTEGER, [Admin_Per_100k_5Plus] INTEGER, [Distributed_Per_100k_5Plus] INTEGER, [Series_Complete_Moderna_5Plus] INTEGER, [Series_Complete_Pfizer_5Plus] INTEGER, [Series_Complete_Janssen_5Plus] INTEGER, [Series_Complete_Unk_Manuf_5Plus] INTEGER, [Booster_Eligible_NotBoosted] INTEGER, [Booster_Eligible_NotBoosted_Pct] FLOAT, [Booster_Eligible_NotBoosted_18Plus] INTEGER, [Booster_Eligible_NotBoosted_18Plus_Pct] FLOAT, [Booster_Eligible_NotBoosted_50Plus] INTEGER, [Booster_Eligible_NotBoosted_50Plus_Pct] FLOAT, [Booster_Eligible_NotBoosted_65Plus] INTEGER, [Booster_Eligible_NotBoosted_65Plus_Pct] INTEGER, [Booster_Eligible_NotBoosted_12Plus] INTEGER, [Booster_Eligible_NotBoosted_12Plus_Pct] FLOAT, [Additional_Doses_12Plus] INTEGER, [Additional_Doses_12Plus_Vax_Pct] FLOAT, [Second_Booster] INTEGER, [Second_Booster_50plus] INTEGER, [Second_Booster_65plus] INTEGER, [Second_Booster_Vax_Pct] FLOAT, [Second_Booster_50plus_Vax_Pct] INTEGER, [Second_Booster_65plus_Vax_Pct] FLOAT, [Second_Booster_Moderna] INTEGER, [Second_Booster_Pfizer] INTEGER, [Second_Booster_Janssen] INTEGER, [Second_Booster_Unk_Manuf] INTEGER, [Additional_Doses_5Plus] INTEGER, [Additional_Doses_5Plus_Vax_Pct] FLOAT, [Administered_Dose1_<5] INTEGER, [Administered_Novavax] INTEGER, [Distributed_Novavax] INTEGER, [Series_Complete_Novavax] INTEGER, [Administered_Bivalent] INTEGER, [Dist_Bivalent_MOD] INTEGER, [Dist_Bivalent_PFR] INTEGER, [Admin_Bivalent_MOD] INTEGER, [Admin_Bivalent_PFR] INTEGER); CREATE INDEX [idx_daily_reports_Location] ON [daily_reports] ([Location]); CREATE INDEX [idx_daily_reports_ShortName] ON [daily_reports] ([ShortName]); CREATE INDEX [idx_daily_reports_LongName] ON [daily_reports] ([LongName]);