cdc_vaccinations_timeseries
Data source: Big Local News · About: big-local-datasette
4,485 rows sorted by Administered_Dose2
This data as json, copyable, CSV (advanced)
Suggested facets: MMWR_week, Date (date)
Link | rowid | runid | 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 | MMWR_week | Ratio_Admin_Dist | Administered_Dose_Other | Administered_Dose_Other_Per_100K |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
65 | 65 | 1831 | 2021-03-01 | LTC | LTC | Long Term Care | 7154531 | 0.0 | 0.0 | |||||||||||||||||||||||||||
130 | 130 | 1830 | 2021-02-28 | LTC | LTC | Long Term Care | 7112537 | 0.0 | 0.0 | |||||||||||||||||||||||||||
195 | 195 | 1829 | 2021-02-27 | LTC | LTC | Long Term Care | 7043540 | 0.0 | 0.0 | |||||||||||||||||||||||||||
260 | 260 | 1828 | 2021-02-26 | LTC | LTC | Long Term Care | 6933071 | 0.0 | 0.0 | |||||||||||||||||||||||||||
325 | 325 | 1827 | 2021-02-25 | LTC | LTC | Long Term Care | 6817460 | 0.0 | 0.0 | |||||||||||||||||||||||||||
390 | 390 | 1824 | 2021-02-24 | LTC | LTC | Long Term Care | 6724310 | 0.0 | 0.0 | |||||||||||||||||||||||||||
455 | 455 | 1825 | 2021-02-25 | LTC | LTC | Long Term Care | 6817460 | 0.0 | 0.0 | |||||||||||||||||||||||||||
520 | 520 | 1824 | 2021-02-24 | LTC | LTC | Long Term Care | 6724310 | 0.0 | 0.0 | |||||||||||||||||||||||||||
585 | 585 | 1821 | 2021-02-23 | LTC | LTC | Long Term Care | 6627820 | 0.0 | 0.0 | |||||||||||||||||||||||||||
650 | 650 | 1820 | 2021-02-22 | LTC | LTC | Long Term Care | 6579236 | 0.0 | 0.0 | |||||||||||||||||||||||||||
715 | 715 | 1819 | 2021-02-22 | LTC | LTC | Long Term Care | 6579236 | 0.0 | 0.0 | |||||||||||||||||||||||||||
780 | 780 | 1818 | 2021-02-21 | LTC | LTC | Long Term Care | 6519848 | 0.0 | 0.0 | |||||||||||||||||||||||||||
845 | 845 | 1817 | 2021-02-20 | LTC | LTC | Long Term Care | 6399010 | 0.0 | 0.0 | |||||||||||||||||||||||||||
910 | 910 | 1816 | 2021-02-20 | LTC | LTC | Long Term Care | 6399010 | 0.0 | 0.0 | |||||||||||||||||||||||||||
975 | 975 | 1810 | 2021-02-19 | LTC | LTC | Long Term Care | 6289188 | 0.0 | 0.0 | |||||||||||||||||||||||||||
1040 | 1040 | 1806 | 2021-02-18 | LTC | LTC | Long Term Care | 6181996 | 0.0 | 0.0 | |||||||||||||||||||||||||||
1105 | 1105 | 1804 | 2021-02-17 | LTC | LTC | Long Term Care | 6070341 | 0.0 | 0.0 | |||||||||||||||||||||||||||
1170 | 1170 | 1801 | 2021-02-16 | LTC | LTC | Long Term Care | 5968542 | 0.0 | 0.0 | |||||||||||||||||||||||||||
1235 | 1235 | 1800 | 2021-02-14 | LTC | LTC | Long Term Care | 5822871 | 0.0 | 0.0 | |||||||||||||||||||||||||||
1300 | 1300 | 1799 | 2021-02-13 | LTC | LTC | Long Term Care | 5667091 | 0.0 | 0.0 | |||||||||||||||||||||||||||
1365 | 1365 | 1798 | 2021-02-12 | LTC | LTC | Long Term Care | 5507785 | 0.0 | 0.0 | |||||||||||||||||||||||||||
1430 | 1430 | 1797 | 2021-02-12 | LTC | LTC | Long Term Care | 5507785 | 0.0 | 0.0 | |||||||||||||||||||||||||||
1495 | 1495 | 1796 | 2021-02-11 | LTC | LTC | Long Term Care | 5348775 | 0.0 | 0.0 | |||||||||||||||||||||||||||
1560 | 1560 | 1795 | 2021-02-10 | LTC | LTC | Long Term Care | 5176499 | 0.0 | 0.0 | |||||||||||||||||||||||||||
1625 | 1625 | 1793 | 2021-02-09 | LTC | LTC | Long Term Care | 5015224 | 0.0 | 0.0 | |||||||||||||||||||||||||||
1690 | 1690 | 1792 | 2021-02-08 | LTC | LTC | Long Term Care | 4946483 | 0.0 | 0.0 | |||||||||||||||||||||||||||
1755 | 1755 | 1791 | 2021-02-08 | LTC | LTC | Long Term Care | 4946483 | 0.0 | 0.0 | |||||||||||||||||||||||||||
1820 | 1820 | 1790 | 2021-02-07 | LTC | LTC | Long Term Care | 4839144 | 0.0 | 0.0 | |||||||||||||||||||||||||||
1885 | 1885 | 1789 | 2021-02-06 | LTC | LTC | Long Term Care | 4628962 | 0.0 | 0.0 | |||||||||||||||||||||||||||
1950 | 1950 | 1788 | 2021-02-05 | LTC | LTC | Long Term Care | 4419633 | 0.0 | 0.0 | |||||||||||||||||||||||||||
2015 | 2015 | 1787 | 2021-02-04 | LTC | LTC | Long Term Care | 4210027 | 0.0 | 0.0 | |||||||||||||||||||||||||||
2080 | 2080 | 1783 | 2021-02-03 | LTC | LTC | Long Term Care | 4022407 | 0.0 | 0.0 | |||||||||||||||||||||||||||
2145 | 2145 | 1782 | 2021-02-02 | LTC | LTC | Long Term Care | 3851460 | 0.0 | 0.0 | |||||||||||||||||||||||||||
2210 | 2210 | 1780 | 2021-02-02 | LTC | LTC | Long Term Care | 3851460 | 0.0 | 0.0 | |||||||||||||||||||||||||||
2275 | 2275 | 1778 | 2021-02-01 | LTC | LTC | Long Term Care | 3748779 | 0.0 | 0.0 | |||||||||||||||||||||||||||
2340 | 2340 | 1777 | 2021-01-31 | LTC | LTC | Long Term Care | 3683718 | 0.0 | 0.0 | |||||||||||||||||||||||||||
2405 | 2405 | 1776 | 2021-01-30 | LTC | LTC | Long Term Care | 3505431 | 0.0 | 0.0 | |||||||||||||||||||||||||||
2470 | 2470 | 1772 | 2021-01-29 | LTC | LTC | Long Term Care | 3314266 | 0.0 | 0.0 | |||||||||||||||||||||||||||
2535 | 2535 | 1770 | 2021-01-28 | LTC | LTC | Long Term Care | 3102134 | 0.0 | 0.0 | |||||||||||||||||||||||||||
2600 | 2600 | 1765 | 2021-01-28 | LTC | LTC | Long Term Care | 3102134 | |||||||||||||||||||||||||||||
2665 | 2665 | 1762 | 2021-01-27 | LTC | LTC | Long Term Care | 2904840 | |||||||||||||||||||||||||||||
2730 | 2730 | 1831 | 2021-01-26 | LTC | LTC | Long Term Care | 2725830 | |||||||||||||||||||||||||||||
2795 | 2795 | 1830 | 2021-01-25 | LTC | LTC | Long Term Care | 2714487 | |||||||||||||||||||||||||||||
2860 | 2860 | 1826 | 2021-01-24 | LTC | LTC | Long Term Care | 2567018 | |||||||||||||||||||||||||||||
2925 | 2925 | 1824 | 2021-01-23 | LTC | LTC | Long Term Care | 2437670 | |||||||||||||||||||||||||||||
2990 | 2990 | 1822 | 2021-01-22 | LTC | LTC | Long Term Care | 2289284 | |||||||||||||||||||||||||||||
3055 | 3055 | 1821 | 2021-01-21 | LTC | LTC | Long Term Care | 2089181 | |||||||||||||||||||||||||||||
3120 | 3120 | 1819 | 2021-01-21 | LTC | LTC | Long Term Care | 2089181 | |||||||||||||||||||||||||||||
3185 | 3185 | 1815 | 2021-01-20 | LTC | LTC | Long Term Care | 1908256 | |||||||||||||||||||||||||||||
3250 | 3250 | 1812 | 2021-01-19 | LTC | LTC | Long Term Care | 1745441 | |||||||||||||||||||||||||||||
3315 | 3315 | 1810 | 2021-01-19 | LTC | LTC | Long Term Care | 1745441 | |||||||||||||||||||||||||||||
3380 | 3380 | 1809 | 2021-01-19 | LTC | LTC | Long Term Care | 1745441 | |||||||||||||||||||||||||||||
3445 | 3445 | 1805 | 2021-01-15 | LTC | LTC | Long Term Care | 1384963 | |||||||||||||||||||||||||||||
3510 | 3510 | 1804 | 2021-01-15 | LTC | LTC | Long Term Care | 1384963 | |||||||||||||||||||||||||||||
3575 | 3575 | 1803 | 2021-01-15 | LTC | LTC | Long Term Care | 1384963 | |||||||||||||||||||||||||||||
3640 | 3640 | 1802 | 2021-01-14 | LTC | LTC | Long Term Care | 1225493 | |||||||||||||||||||||||||||||
3641 | 3641 | 1801 | 2021-01-14 | AK | AKA | Alaska | 731545 | 150450 | 42596 | 20566 | 5823 | 35508 | 4854 | |||||||||||||||||||||||
3642 | 3642 | 1801 | 2021-01-14 | AL | ALA | Alabama | 4903185 | 435350 | 92300 | 8879 | 1882 | 80480 | 1641 | |||||||||||||||||||||||
3643 | 3643 | 1801 | 2021-01-14 | AR | ARA | Arkansas | 3017804 | 297800 | 108316 | 9868 | 3589 | 90339 | 2994 | |||||||||||||||||||||||
3644 | 3644 | 1801 | 2021-01-14 | AS | ASA | American Samoa | 55689 | 10650 | 2971 | 19124 | 5335 | 2409 | 4326 | |||||||||||||||||||||||
3645 | 3645 | 1801 | 2021-01-14 | AZ | AZA | Arizona | 7278717 | 570625 | 173665 | 7840 | 2386 | 157397 | 2162 | |||||||||||||||||||||||
3646 | 3646 | 1801 | 2021-01-14 | BP2 | BP2 | Bureau of Prisons | 0 | 16450 | 16118 | 0 | 0 | 13997 | 0 | |||||||||||||||||||||||
3647 | 3647 | 1801 | 2021-01-14 | CA | CAA | California | 39512223 | 3540175 | 975293 | 8960 | 2468 | 801998 | 2030 | |||||||||||||||||||||||
3648 | 3648 | 1801 | 2021-01-14 | CO | COA | Colorado | 5758736 | 531775 | 254706 | 9234 | 4423 | 209300 | 3634 | |||||||||||||||||||||||
3649 | 3649 | 1801 | 2021-01-14 | CT | CTA | Connecticut | 3565287 | 328675 | 171897 | 9219 | 4821 | 156366 | 4386 | |||||||||||||||||||||||
3650 | 3650 | 1801 | 2021-01-14 | DC | DCA | District of Columbia | 705749 | 68325 | 36679 | 9681 | 5197 | 29927 | 4240 | |||||||||||||||||||||||
3651 | 3651 | 1801 | 2021-01-14 | DD2 | DD2 | Dept of Defense | 0 | 464775 | 179724 | 0 | 0 | 159851 | 0 | |||||||||||||||||||||||
3652 | 3652 | 1801 | 2021-01-14 | DE | DEA | Delaware | 973764 | 91250 | 31090 | 9371 | 3193 | 25649 | 2634 | |||||||||||||||||||||||
3653 | 3653 | 1801 | 2021-01-14 | FL | FLA | Florida | 21477737 | 1970875 | 774485 | 9176 | 3606 | 709002 | 3301 | |||||||||||||||||||||||
3654 | 3654 | 1801 | 2021-01-14 | FM | FMA | Federated States of Micronesia | 103643 | 9800 | 605 | 9456 | 584 | 604 | 583 | |||||||||||||||||||||||
3655 | 3655 | 1801 | 2021-01-14 | GA | GAA | Georgia | 10617423 | 1010900 | 231305 | 9521 | 2179 | 204301 | 1924 | |||||||||||||||||||||||
3656 | 3656 | 1801 | 2021-01-14 | GU | GUA | Guam | 165768 | 34300 | 3791 | 20692 | 2287 | 3785 | 2283 | |||||||||||||||||||||||
3657 | 3657 | 1801 | 2021-01-14 | HI | HIA | Hawaii | 1415872 | 154150 | 47985 | 10887 | 3389 | 0 | 0 | |||||||||||||||||||||||
3658 | 3658 | 1801 | 2021-01-14 | IA | IAA | Iowa | 3155070 | 268025 | 112093 | 8495 | 3553 | 100805 | 3195 | |||||||||||||||||||||||
3659 | 3659 | 1801 | 2021-01-14 | ID | IDA | Idaho | 1787065 | 160075 | 42586 | 8957 | 2383 | 35179 | 1969 | |||||||||||||||||||||||
3660 | 3660 | 1801 | 2021-01-14 | IH2 | IH2 | Indian Health Svc | 0 | 291800 | 81726 | 0 | 0 | 69313 | 0 | |||||||||||||||||||||||
3661 | 3661 | 1801 | 2021-01-14 | IL | ILA | Illinois | 12671821 | 958125 | 403666 | 7561 | 3186 | 316876 | 2501 | |||||||||||||||||||||||
3662 | 3662 | 1801 | 2021-01-14 | IN | INA | Indiana | 6732219 | 630025 | 233488 | 9358 | 3468 | 203889 | 3029 | |||||||||||||||||||||||
3663 | 3663 | 1801 | 2021-01-14 | KS | KSA | Kansas | 2913314 | 263175 | 91565 | 9034 | 3143 | 77590 | 2663 | |||||||||||||||||||||||
3664 | 3664 | 1801 | 2021-01-14 | KY | KYA | Kentucky | 4467673 | 332375 | 155613 | 7440 | 3483 | 145320 | 3253 | |||||||||||||||||||||||
3665 | 3665 | 1801 | 2021-01-14 | LA | LAA | Louisiana | 4648794 | 370175 | 175811 | 7963 | 3782 | 149064 | 3207 | |||||||||||||||||||||||
3666 | 3666 | 1801 | 2021-01-14 | LTC | LTC | Long Term Care | 0 | 4715600 | 1225493 | 0 | 0 | 1195320 | 0 | |||||||||||||||||||||||
3667 | 3667 | 1801 | 2021-01-14 | MA | MAA | Massachusetts | 6892503 | 669225 | 233476 | 9709 | 3387 | 204481 | 2967 | |||||||||||||||||||||||
3668 | 3668 | 1801 | 2021-01-14 | MD | MDA | Maryland | 6045680 | 564625 | 178056 | 9339 | 2945 | 165318 | 2734 | |||||||||||||||||||||||
3669 | 3669 | 1801 | 2021-01-14 | ME | MEA | Maine | 1344212 | 136875 | 61129 | 10183 | 4548 | 51631 | 3841 | |||||||||||||||||||||||
3670 | 3670 | 1801 | 2021-01-14 | MH | MHA | Marshall Islands | 58413 | 13600 | 649 | 23282 | 1111 | 623 | 1067 | |||||||||||||||||||||||
3671 | 3671 | 1801 | 2021-01-14 | MI | MIA | Michigan | 9986857 | 773650 | 327235 | 7747 | 3277 | 286349 | 2867 | |||||||||||||||||||||||
3672 | 3672 | 1801 | 2021-01-14 | MN | MNA | Minnesota | 5639632 | 516800 | 179684 | 9164 | 3186 | 161507 | 2864 | |||||||||||||||||||||||
3673 | 3673 | 1801 | 2021-01-14 | MO | MOA | Missouri | 6137428 | 528300 | 175314 | 8608 | 2856 | 145521 | 2371 | |||||||||||||||||||||||
3674 | 3674 | 1801 | 2021-01-14 | MP | MPA | Northern Mariana Islands | 56882 | 18650 | 4598 | 32787 | 8083 | 3455 | 6074 | |||||||||||||||||||||||
3675 | 3675 | 1801 | 2021-01-14 | MS | MSA | Mississippi | 2976149 | 219800 | 71848 | 7385 | 2414 | 64654 | 2172 | |||||||||||||||||||||||
3676 | 3676 | 1801 | 2021-01-14 | MT | MTA | Montana | 1068778 | 98500 | 46620 | 9216 | 4362 | 39103 | 3659 | |||||||||||||||||||||||
3677 | 3677 | 1801 | 2021-01-14 | NC | NCA | North Carolina | 10488084 | 969700 | 268212 | 9246 | 2557 | 233038 | 2222 | |||||||||||||||||||||||
3678 | 3678 | 1801 | 2021-01-14 | ND | NDA | North Dakota | 762062 | 68675 | 42774 | 9012 | 5613 | 35293 | 4631 | |||||||||||||||||||||||
3679 | 3679 | 1801 | 2021-01-14 | NE | NEA | Nebraska | 1934408 | 199800 | 84920 | 10329 | 4390 | 72079 | 3726 | |||||||||||||||||||||||
3680 | 3680 | 1801 | 2021-01-14 | NH | NHA | New Hampshire | 1359711 | 127225 | 58711 | 9357 | 4318 | 53780 | 3955 | |||||||||||||||||||||||
3681 | 3681 | 1801 | 2021-01-14 | NJ | NJA | New Jersey | 8882190 | 658800 | 263422 | 7417 | 2966 | 235152 | 2647 | |||||||||||||||||||||||
3682 | 3682 | 1801 | 2021-01-14 | NM | NMA | New Mexico | 2096829 | 204750 | 89415 | 9765 | 4264 | 73428 | 3502 | |||||||||||||||||||||||
3683 | 3683 | 1801 | 2021-01-14 | NV | NVA | Nevada | 3080156 | 210075 | 76844 | 6820 | 2495 | 62370 | 2025 | |||||||||||||||||||||||
3684 | 3684 | 1801 | 2021-01-14 | NY | NYA | New York State | 19453561 | 1872625 | 688576 | 9626 | 3540 | 617596 | 3175 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [cdc_vaccinations_timeseries] ( [runid] INTEGER, [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] FLOAT, [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, [Administered_Moderna] TEXT, [Administered_Pfizer] TEXT, [Administered_Unk_Manuf] TEXT, [MMWR_week] TEXT, [Ratio_Admin_Dist] TEXT, [Administered_Dose_Other] TEXT, [Administered_Dose_Other_Per_100K] TEXT );