daily_reports
Data source: CDC · About: simonw/cdc-vaccination-history
8 rows where Distributed_Unk_Manuf = 7500
This data as json, CSV (advanced)
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]);