{ "cells": [ { "cell_type": "markdown", "metadata": {}, "source": [ "## API\n", "\n", "https://fred.stlouisfed.org/docs/api/fred/" ] }, { "cell_type": "code", "execution_count": 2, "metadata": {}, "outputs": [], "source": [ "import requests\n", "\n", "import pandas as pd\n", "\n", "\n", "FRED_URL = \"https://api.stlouisfed.org/fred\"\n", "\n", "\n", "def fred_series_request(series):\n", " key = \"d4f97d5305ace8b756e361252fbf02cd\"\n", " url = (\n", " FRED_URL +\n", " \"/series/observations\" +\n", " f\"?series_id={series}&file_type=json&api_key={key}\"\n", " )\n", "\n", " return requests.get(url).json()\n" ] }, { "cell_type": "code", "execution_count": 5, "metadata": {}, "outputs": [], "source": [ "data = fred_series_request(\"UNRATE\")\n", "df = pd.DataFrame(data[\"observations\"])\n", "df.to_csv(\"UNRATE.csv\")\n" ] }, { "cell_type": "code", "execution_count": 6, "metadata": {}, "outputs": [ { "data": { "text/html": [ "
\n", "\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
realtime_startrealtime_enddatevalue
02021-03-302021-03-301948-01-013.4
12021-03-302021-03-301948-02-013.8
22021-03-302021-03-301948-03-014.0
32021-03-302021-03-301948-04-013.9
42021-03-302021-03-301948-05-013.5
...............
8732021-03-302021-03-302020-10-016.9
8742021-03-302021-03-302020-11-016.7
8752021-03-302021-03-302020-12-016.7
8762021-03-302021-03-302021-01-016.3
8772021-03-302021-03-302021-02-016.2
\n", "

878 rows × 4 columns

\n", "
" ], "text/plain": [ " realtime_start realtime_end date value\n", "0 2021-03-30 2021-03-30 1948-01-01 3.4\n", "1 2021-03-30 2021-03-30 1948-02-01 3.8\n", "2 2021-03-30 2021-03-30 1948-03-01 4.0\n", "3 2021-03-30 2021-03-30 1948-04-01 3.9\n", "4 2021-03-30 2021-03-30 1948-05-01 3.5\n", ".. ... ... ... ...\n", "873 2021-03-30 2021-03-30 2020-10-01 6.9\n", "874 2021-03-30 2021-03-30 2020-11-01 6.7\n", "875 2021-03-30 2021-03-30 2020-12-01 6.7\n", "876 2021-03-30 2021-03-30 2021-01-01 6.3\n", "877 2021-03-30 2021-03-30 2021-02-01 6.2\n", "\n", "[878 rows x 4 columns]" ] }, "execution_count": 6, "metadata": {}, "output_type": "execute_result" } ], "source": [ "df" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "## `pd.read_html`\n", "\n", "https://www.espn.com/soccer/schedule/_/league/ger.1" ] }, { "cell_type": "code", "execution_count": 10, "metadata": {}, "outputs": [], "source": [ "import pandas as pd\n", "\n", "\n", "def retrieve_soccer_schedule():\n", " url = \"https://www.espn.com/soccer/schedule/_/league/ger.1\"\n", "\n", " # Returns a list of tables -- We know that the first one\n", " # is the one we want\n", " return pd.read_html(url)\n" ] }, { "cell_type": "code", "execution_count": 14, "metadata": {}, "outputs": [], "source": [ "tables = pd.read_html(\"https://www.espn.com/soccer/team/stats/_/id/125\")" ] }, { "cell_type": "code", "execution_count": 16, "metadata": {}, "outputs": [ { "data": { "text/html": [ "
\n", "\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
RKNamePA
01.0Filip Kostic2210
12.0Daichi Kamada249
23.0André Silva243
3NaNAymen Barkok213
45.0Djibril Sow212
5NaNAmin Younes192
6NaNSteven Zuber142
7NaNBas Dost122
89.0Martin Hinteregger241
9NaNObite Ndicka161
10NaNAlmamy Touré161
11NaNErik Durm141
1213.0Kevin Trapp260
13NaNMakoto Hasebe220
14NaNSebastian Rode210
15NaNStefan Ilsanker200
16NaNDavid Abraham140
17NaNLucas Silva Melo110
18NaNLuka Jovic110
19NaNAjdin Hrustic80
20NaNTimothy Chandler70
21NaNRagnar Ache50
22NaNElias Bördner00
\n", "
" ], "text/plain": [ " RK Name P A\n", "0 1.0 Filip Kostic 22 10\n", "1 2.0 Daichi Kamada 24 9\n", "2 3.0 André Silva 24 3\n", "3 NaN Aymen Barkok 21 3\n", "4 5.0 Djibril Sow 21 2\n", "5 NaN Amin Younes 19 2\n", "6 NaN Steven Zuber 14 2\n", "7 NaN Bas Dost 12 2\n", "8 9.0 Martin Hinteregger 24 1\n", "9 NaN Obite Ndicka 16 1\n", "10 NaN Almamy Touré 16 1\n", "11 NaN Erik Durm 14 1\n", "12 13.0 Kevin Trapp 26 0\n", "13 NaN Makoto Hasebe 22 0\n", "14 NaN Sebastian Rode 21 0\n", "15 NaN Stefan Ilsanker 20 0\n", "16 NaN David Abraham 14 0\n", "17 NaN Lucas Silva Melo 11 0\n", "18 NaN Luka Jovic 11 0\n", "19 NaN Ajdin Hrustic 8 0\n", "20 NaN Timothy Chandler 7 0\n", "21 NaN Ragnar Ache 5 0\n", "22 NaN Elias Bördner 0 0" ] }, "execution_count": 16, "metadata": {}, "output_type": "execute_result" } ], "source": [ "tables[1]" ] }, { "cell_type": "code", "execution_count": 11, "metadata": {}, "outputs": [], "source": [ "df = retrieve_soccer_schedule()" ] }, { "cell_type": "code", "execution_count": 12, "metadata": {}, "outputs": [ { "data": { "text/plain": [ "[ match Unnamed: 1 time tv \\\n", " 0 Bayer Leverkusen LEVv Schalke 04 SCHA NaN NaN \n", " 1 Borussia Dortmund DORv Eintracht Frankfurt EINF NaN NaN \n", " 2 FC Augsburg AUGv TSG Hoffenheim HOF NaN NaN \n", " 3 Mainz MAINv Arminia Bielefeld DSC NaN NaN \n", " 4 VfL Wolfsburg WOLFv FC Cologne COL NaN NaN \n", " 5 RB Leipzig LEIv Bayern Munich MUN NaN NaN \n", " 6 Borussia Monchengladbach MONv SC Freiburg FREI NaN NaN \n", " \n", " Unnamed: 4 \n", " 0 NaN \n", " 1 NaN \n", " 2 NaN \n", " 3 NaN \n", " 4 NaN \n", " 5 NaN \n", " 6 NaN ,\n", " match Unnamed: 1 time tv Unnamed: 4\n", " 0 VfB Stuttgart STUv Werder Bremen WER NaN NaN NaN\n", " 1 FC Union Berlin FCUBv Hertha Berlin HERT NaN NaN NaN,\n", " match Unnamed: 1 time tv Unnamed: 4\n", " 0 Arminia Bielefeld DSCv SC Freiburg FREI NaN NaN NaN]" ] }, "execution_count": 12, "metadata": {}, "output_type": "execute_result" } ], "source": [ "df" ] }, { "cell_type": "code", "execution_count": null, "metadata": {}, "outputs": [], "source": [ "df.to_csv(\"soccer_schedule.csv\")" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "## Request intercept\n", "\n", "https://covid.cdc.gov/covid-data-tracker/#vaccinations" ] }, { "cell_type": "code", "execution_count": 17, "metadata": {}, "outputs": [], "source": [ "import requests\n", "\n", "import pandas as pd\n", "\n", "\n", "def retrieve_vaccination_data():\n", " url = \"https://covid.cdc.gov/covid-data-tracker/COVIDData/getAjaxData?id=vaccination_data\"\n", "\n", " data = requests.get(url).json()\n", "\n", " return data\n", "\n", "\n", "def parse_vaccine_json_to_df(data):\n", " df = pd.DataFrame(data[\"vaccination_data\"])\n", "\n", " return df\n" ] }, { "cell_type": "code", "execution_count": 18, "metadata": {}, "outputs": [], "source": [ "data = retrieve_vaccination_data()" ] }, { "cell_type": "code", "execution_count": 27, "metadata": {}, "outputs": [ { "data": { "text/plain": [ "[{'Date': '2021-03-29',\n", " 'Location': 'US',\n", " 'ShortName': 'USA',\n", " 'LongName': 'United States',\n", " 'Census2019': 331996199,\n", " 'date_type': 'Report',\n", " 'Doses_Distributed': 180646565,\n", " 'Doses_Administered': 145812835,\n", " 'Dist_Per_100K': 54412,\n", " 'Admin_Per_100K': 43920,\n", " 'Administered_Moderna': 68177850,\n", " 'Administered_Pfizer': 74338025,\n", " 'Administered_Janssen': 3155418,\n", " 'Administered_Unk_Manuf': 141542,\n", " 'Administered_Dose1_Recip': 95015762,\n", " 'Administered_Dose1_Pop_Pct': 28.6,\n", " 'Administered_Dose2_Pop_Pct': 14.9,\n", " 'Administered_Dose1_Recip_18Plus': 94686188,\n", " 'Administered_Dose1_Recip_18PlusPop_Pct': 36.7,\n", " 'Administered_18Plus': 145400967,\n", " 'Admin_Per_100k_18Plus': 56328,\n", " 'Distributed_Per_100k_18Plus': 69983,\n", " 'Administered_Dose1_Recip_65Plus': 39799162,\n", " 'Administered_Dose1_Recip_65PlusPop_Pct': 72.8,\n", " 'Administered_65Plus': 66457122,\n", " 'Admin_Per_100k_65Plus': 121501,\n", " 'Distributed_Per_100k_65Plus': 330268,\n", " 'Administered_Dose2_Recip': 49480294,\n", " 'Administered_Dose2_Recip_18Plus': 49399809,\n", " 'Administered_Dose2_Recip_18PlusPop_Pct': 19.1,\n", " 'Distributed_Moderna': 85398300,\n", " 'Distributed_Pfizer': 90301965,\n", " 'Distributed_Janssen': 4946300,\n", " 'Distributed_Unk_Manuf': 0,\n", " 'Series_Complete_Moderna': 23149108,\n", " 'Series_Complete_Pfizer': 26299019,\n", " 'Series_Complete_Janssen': 3134304,\n", " 'Series_Complete_Unk_Manuf': 31800,\n", " 'Series_Complete_Moderna_18Plus': 23136027,\n", " 'Series_Complete_Pfizer_18Plus': 26231645,\n", " 'Series_Complete_Janssen_18Plus': 3130505,\n", " 'Series_Complete_Unk_Manuf_18Plus': 31771,\n", " 'Series_Complete_Moderna_65Plus': 12625417,\n", " 'Series_Complete_Pfizer_65Plus': 13429039,\n", " 'Series_Complete_Janssen_65Plus': 839456,\n", " 'Series_Complete_Unk_Manuf_65Plus': 11110,\n", " 'Series_Complete_Yes': 52614231,\n", " 'Series_Complete_Pop_Pct': 15.8,\n", " 'Series_Complete_18Plus': 52529949,\n", " 'Series_Complete_18PlusPop_Pct': 20.4,\n", " 'Series_Complete_65Plus': 26905023,\n", " 'Series_Complete_65PlusPop_Pct': 49.2},\n", " {'Date': '2021-03-29',\n", " 'Location': 'AK',\n", " 'ShortName': 'AKA',\n", " 'LongName': 'Alaska',\n", " 'Census2019': 731545,\n", " 'date_type': 'Report',\n", " 'Doses_Distributed': 570465,\n", " 'Doses_Administered': 403284,\n", " 'Dist_Per_100K': 77981,\n", " 'Admin_Per_100K': 55128,\n", " 'Administered_Moderna': 184195,\n", " 'Administered_Pfizer': 213826,\n", " 'Administered_Janssen': 5207,\n", " 'Administered_Unk_Manuf': 56,\n", " 'Administered_Dose1_Recip': 246515,\n", " 'Administered_Dose1_Pop_Pct': 33.7,\n", " 'Administered_Dose2_Pop_Pct': 21.3,\n", " 'Administered_Dose1_Recip_18Plus': 242453,\n", " 'Administered_Dose1_Recip_18PlusPop_Pct': 44.0,\n", " 'Administered_18Plus': 397513,\n", " 'Admin_Per_100k_18Plus': 72070,\n", " 'Distributed_Per_100k_18Plus': 103427,\n", " 'Administered_Dose1_Recip_65Plus': 66080,\n", " 'Administered_Dose1_Recip_65PlusPop_Pct': 72.1,\n", " 'Administered_65Plus': 118775,\n", " 'Admin_Per_100k_65Plus': 129684,\n", " 'Distributed_Per_100k_65Plus': 622860,\n", " 'Administered_Dose2_Recip': 155843,\n", " 'Administered_Dose2_Recip_18Plus': 154139,\n", " 'Administered_Dose2_Recip_18PlusPop_Pct': 27.9,\n", " 'Distributed_Moderna': 263900,\n", " 'Distributed_Pfizer': 289965,\n", " 'Distributed_Janssen': 16600,\n", " 'Distributed_Unk_Manuf': 0,\n", " 'Series_Complete_Moderna': 70237,\n", " 'Series_Complete_Pfizer': 85597,\n", " 'Series_Complete_Janssen': 5089,\n", " 'Series_Complete_Unk_Manuf': 9,\n", " 'Series_Complete_Moderna_18Plus': 70159,\n", " 'Series_Complete_Pfizer_18Plus': 83971,\n", " 'Series_Complete_Janssen_18Plus': 5064,\n", " 'Series_Complete_Unk_Manuf_18Plus': 9,\n", " 'Series_Complete_Moderna_65Plus': 32077,\n", " 'Series_Complete_Pfizer_65Plus': 22183,\n", " 'Series_Complete_Janssen_65Plus': 554,\n", " 'Series_Complete_Unk_Manuf_65Plus': 3,\n", " 'Series_Complete_Yes': 160932,\n", " 'Series_Complete_Pop_Pct': 22.0,\n", " 'Series_Complete_18Plus': 159203,\n", " 'Series_Complete_18PlusPop_Pct': 28.9,\n", " 'Series_Complete_65Plus': 54817,\n", " 'Series_Complete_65PlusPop_Pct': 59.9},\n", " {'Date': '2021-03-29',\n", " 'Location': 'AL',\n", " 'ShortName': 'ALA',\n", " 'LongName': 'Alabama',\n", " 'Census2019': 4903185,\n", " 'date_type': 'Report',\n", " 'Doses_Distributed': 2537050,\n", " 'Doses_Administered': 1666585,\n", " 'Dist_Per_100K': 51743,\n", " 'Admin_Per_100K': 33990,\n", " 'Administered_Moderna': 836716,\n", " 'Administered_Pfizer': 792924,\n", " 'Administered_Janssen': 36945,\n", " 'Administered_Unk_Manuf': 0,\n", " 'Administered_Dose1_Recip': 1113924,\n", " 'Administered_Dose1_Pop_Pct': 22.7,\n", " 'Administered_Dose2_Pop_Pct': 12.1,\n", " 'Administered_Dose1_Recip_18Plus': 1112419,\n", " 'Administered_Dose1_Recip_18PlusPop_Pct': 29.2,\n", " 'Administered_18Plus': 1664902,\n", " 'Admin_Per_100k_18Plus': 43642,\n", " 'Distributed_Per_100k_18Plus': 66504,\n", " 'Administered_Dose1_Recip_65Plus': 528699,\n", " 'Administered_Dose1_Recip_65PlusPop_Pct': 62.2,\n", " 'Administered_65Plus': 840346,\n", " 'Admin_Per_100k_65Plus': 98883,\n", " 'Distributed_Per_100k_65Plus': 298534,\n", " 'Administered_Dose2_Recip': 593437,\n", " 'Administered_Dose2_Recip_18Plus': 593211,\n", " 'Administered_Dose2_Recip_18PlusPop_Pct': 15.5,\n", " 'Distributed_Moderna': 1255200,\n", " 'Distributed_Pfizer': 1210950,\n", " 'Distributed_Janssen': 70900,\n", " 'Distributed_Unk_Manuf': 0,\n", " 'Series_Complete_Moderna': 299819,\n", " 'Series_Complete_Pfizer': 293589,\n", " 'Series_Complete_Janssen': 37951,\n", " 'Series_Complete_Unk_Manuf': 29,\n", " 'Series_Complete_Moderna_18Plus': 299791,\n", " 'Series_Complete_Pfizer_18Plus': 293391,\n", " 'Series_Complete_Janssen_18Plus': 37945,\n", " 'Series_Complete_Unk_Manuf_18Plus': 29,\n", " 'Series_Complete_Moderna_65Plus': 180712,\n", " 'Series_Complete_Pfizer_65Plus': 148073,\n", " 'Series_Complete_Janssen_65Plus': 14386,\n", " 'Series_Complete_Unk_Manuf_65Plus': 20,\n", " 'Series_Complete_Yes': 631388,\n", " 'Series_Complete_Pop_Pct': 12.9,\n", " 'Series_Complete_18Plus': 631156,\n", " 'Series_Complete_18PlusPop_Pct': 16.5,\n", " 'Series_Complete_65Plus': 343191,\n", " 'Series_Complete_65PlusPop_Pct': 40.4},\n", " {'Date': '2021-03-29',\n", " 'Location': 'AR',\n", " 'ShortName': 'ARA',\n", " 'LongName': 'Arkansas',\n", " 'Census2019': 3017804,\n", " 'date_type': 'Report',\n", " 'Doses_Distributed': 1662850,\n", " 'Doses_Administered': 1153739,\n", " 'Dist_Per_100K': 55101,\n", " 'Admin_Per_100K': 38231,\n", " 'Administered_Moderna': 565346,\n", " 'Administered_Pfizer': 562723,\n", " 'Administered_Janssen': 25426,\n", " 'Administered_Unk_Manuf': 244,\n", " 'Administered_Dose1_Recip': 769106,\n", " 'Administered_Dose1_Pop_Pct': 25.5,\n", " 'Administered_Dose2_Pop_Pct': 12.7,\n", " 'Administered_Dose1_Recip_18Plus': 766732,\n", " 'Administered_Dose1_Recip_18PlusPop_Pct': 33.1,\n", " 'Administered_18Plus': 1151251,\n", " 'Admin_Per_100k_18Plus': 49673,\n", " 'Distributed_Per_100k_18Plus': 71747,\n", " 'Administered_Dose1_Recip_65Plus': 334880,\n", " 'Administered_Dose1_Recip_65PlusPop_Pct': 63.9,\n", " 'Administered_65Plus': 538858,\n", " 'Admin_Per_100k_65Plus': 102859,\n", " 'Distributed_Per_100k_65Plus': 317409,\n", " 'Administered_Dose2_Recip': 383151,\n", " 'Administered_Dose2_Recip_18Plus': 382970,\n", " 'Administered_Dose2_Recip_18PlusPop_Pct': 16.5,\n", " 'Distributed_Moderna': 802400,\n", " 'Distributed_Pfizer': 801450,\n", " 'Distributed_Janssen': 59000,\n", " 'Distributed_Unk_Manuf': 0,\n", " 'Series_Complete_Moderna': 192254,\n", " 'Series_Complete_Pfizer': 190847,\n", " 'Series_Complete_Janssen': 24677,\n", " 'Series_Complete_Unk_Manuf': 50,\n", " 'Series_Complete_Moderna_18Plus': 192228,\n", " 'Series_Complete_Pfizer_18Plus': 190692,\n", " 'Series_Complete_Janssen_18Plus': 24643,\n", " 'Series_Complete_Unk_Manuf_18Plus': 50,\n", " 'Series_Complete_Moderna_65Plus': 117181,\n", " 'Series_Complete_Pfizer_65Plus': 87869,\n", " 'Series_Complete_Janssen_65Plus': 4412,\n", " 'Series_Complete_Unk_Manuf_65Plus': 39,\n", " 'Series_Complete_Yes': 407828,\n", " 'Series_Complete_Pop_Pct': 13.5,\n", " 'Series_Complete_18Plus': 407613,\n", " 'Series_Complete_18PlusPop_Pct': 17.6,\n", " 'Series_Complete_65Plus': 209501,\n", " 'Series_Complete_65PlusPop_Pct': 40.0},\n", " {'Date': '2021-03-29',\n", " 'Location': 'AS',\n", " 'ShortName': 'ASA',\n", " 'LongName': 'American Samoa',\n", " 'Census2019': 55689,\n", " 'date_type': 'Report',\n", " 'Doses_Distributed': 43810,\n", " 'Doses_Administered': 28527,\n", " 'Dist_Per_100K': 78669,\n", " 'Admin_Per_100K': 51226,\n", " 'Administered_Moderna': 6143,\n", " 'Administered_Pfizer': 22384,\n", " 'Administered_Janssen': 0,\n", " 'Administered_Unk_Manuf': 0,\n", " 'Administered_Dose1_Recip': 17575,\n", " 'Administered_Dose1_Pop_Pct': 31.6,\n", " 'Administered_Dose2_Pop_Pct': 19.8,\n", " 'Administered_Dose1_Recip_18Plus': 17046,\n", " 'Administered_Dose1_Recip_18PlusPop_Pct': 39.2,\n", " 'Administered_18Plus': 27691,\n", " 'Admin_Per_100k_18Plus': 63750,\n", " 'Distributed_Per_100k_18Plus': 100859,\n", " 'Administered_Dose1_Recip_65Plus': 2204,\n", " 'Administered_Dose1_Recip_65PlusPop_Pct': 23.3,\n", " 'Administered_65Plus': 3708,\n", " 'Admin_Per_100k_65Plus': 39168,\n", " 'Distributed_Per_100k_65Plus': 462765,\n", " 'Administered_Dose2_Recip': 11045,\n", " 'Administered_Dose2_Recip_18Plus': 10741,\n", " 'Administered_Dose2_Recip_18PlusPop_Pct': 24.7,\n", " 'Distributed_Moderna': 12400,\n", " 'Distributed_Pfizer': 30810,\n", " 'Distributed_Janssen': 600,\n", " 'Distributed_Unk_Manuf': 0,\n", " 'Series_Complete_Moderna': 2285,\n", " 'Series_Complete_Pfizer': 8760,\n", " 'Series_Complete_Janssen': 4,\n", " 'Series_Complete_Unk_Manuf': 0,\n", " 'Series_Complete_Moderna_18Plus': 2284,\n", " 'Series_Complete_Pfizer_18Plus': 8457,\n", " 'Series_Complete_Janssen_18Plus': 4,\n", " 'Series_Complete_Unk_Manuf_18Plus': 0,\n", " 'Series_Complete_Moderna_65Plus': 609,\n", " 'Series_Complete_Pfizer_65Plus': 955,\n", " 'Series_Complete_Janssen_65Plus': 1,\n", " 'Series_Complete_Unk_Manuf_65Plus': 0,\n", " 'Series_Complete_Yes': 11049,\n", " 'Series_Complete_Pop_Pct': 19.8,\n", " 'Series_Complete_18Plus': 10745,\n", " 'Series_Complete_18PlusPop_Pct': 24.7,\n", " 'Series_Complete_65Plus': 1565,\n", " 'Series_Complete_65PlusPop_Pct': 16.5},\n", " {'Date': '2021-03-29',\n", " 'Location': 'AZ',\n", " 'ShortName': 'AZA',\n", " 'LongName': 'Arizona',\n", " 'Census2019': 7278717,\n", " 'date_type': 'Report',\n", " 'Doses_Distributed': 3970345,\n", " 'Doses_Administered': 3363062,\n", " 'Dist_Per_100K': 54547,\n", " 'Admin_Per_100K': 46204,\n", " 'Administered_Moderna': 1534427,\n", " 'Administered_Pfizer': 1782491,\n", " 'Administered_Janssen': 44723,\n", " 'Administered_Unk_Manuf': 1421,\n", " 'Administered_Dose1_Recip': 2105116,\n", " 'Administered_Dose1_Pop_Pct': 28.9,\n", " 'Administered_Dose2_Pop_Pct': 16.0,\n", " 'Administered_Dose1_Recip_18Plus': 2094426,\n", " 'Administered_Dose1_Recip_18PlusPop_Pct': 37.1,\n", " 'Administered_18Plus': 3346987,\n", " 'Admin_Per_100k_18Plus': 59360,\n", " 'Distributed_Per_100k_18Plus': 70415,\n", " 'Administered_Dose1_Recip_65Plus': 932017,\n", " 'Administered_Dose1_Recip_65PlusPop_Pct': 71.2,\n", " 'Administered_65Plus': 1606150,\n", " 'Admin_Per_100k_65Plus': 122735,\n", " 'Distributed_Per_100k_65Plus': 303396,\n", " 'Administered_Dose2_Recip': 1162369,\n", " 'Administered_Dose2_Recip_18Plus': 1158670,\n", " 'Administered_Dose2_Recip_18PlusPop_Pct': 20.5,\n", " 'Distributed_Moderna': 1868900,\n", " 'Distributed_Pfizer': 1995045,\n", " 'Distributed_Janssen': 106400,\n", " 'Distributed_Unk_Manuf': 0,\n", " 'Series_Complete_Moderna': 522913,\n", " 'Series_Complete_Pfizer': 638970,\n", " 'Series_Complete_Janssen': 43152,\n", " 'Series_Complete_Unk_Manuf': 486,\n", " 'Series_Complete_Moderna_18Plus': 522837,\n", " 'Series_Complete_Pfizer_18Plus': 635347,\n", " 'Series_Complete_Janssen_18Plus': 43106,\n", " 'Series_Complete_Unk_Manuf_18Plus': 486,\n", " 'Series_Complete_Moderna_65Plus': 287112,\n", " 'Series_Complete_Pfizer_65Plus': 327066,\n", " 'Series_Complete_Janssen_65Plus': 11739,\n", " 'Series_Complete_Unk_Manuf_65Plus': 331,\n", " 'Series_Complete_Yes': 1205521,\n", " 'Series_Complete_Pop_Pct': 16.6,\n", " 'Series_Complete_18Plus': 1201776,\n", " 'Series_Complete_18PlusPop_Pct': 21.3,\n", " 'Series_Complete_65Plus': 626248,\n", " 'Series_Complete_65PlusPop_Pct': 47.9},\n", " {'Date': '2021-03-29',\n", " 'Location': 'BP2',\n", " 'ShortName': 'BP2',\n", " 'LongName': 'Bureau of Prisons',\n", " 'Census2019': 0,\n", " 'date_type': 'Report',\n", " 'Doses_Distributed': 97960,\n", " 'Doses_Administered': 101786,\n", " 'Dist_Per_100K': 0,\n", " 'Admin_Per_100K': 0,\n", " 'Administered_Moderna': 40161,\n", " 'Administered_Pfizer': 61264,\n", " 'Administered_Janssen': 361,\n", " 'Administered_Unk_Manuf': 0,\n", " 'Administered_Dose1_Recip': 60990,\n", " 'Administered_Dose1_Pop_Pct': 0.0,\n", " 'Administered_Dose2_Pop_Pct': 0.0,\n", " 'Administered_Dose1_Recip_18Plus': 60990,\n", " 'Administered_Dose1_Recip_18PlusPop_Pct': 0.0,\n", " 'Administered_18Plus': 101786,\n", " 'Admin_Per_100k_18Plus': 0,\n", " 'Distributed_Per_100k_18Plus': 0,\n", " 'Administered_Dose1_Recip_65Plus': 2595,\n", " 'Administered_Dose1_Recip_65PlusPop_Pct': 0.0,\n", " 'Administered_65Plus': 4447,\n", " 'Admin_Per_100k_65Plus': 0,\n", " 'Distributed_Per_100k_65Plus': 0,\n", " 'Administered_Dose2_Recip': 40213,\n", " 'Administered_Dose2_Recip_18Plus': 40213,\n", " 'Administered_Dose2_Recip_18PlusPop_Pct': 0.0,\n", " 'Distributed_Moderna': 40100,\n", " 'Distributed_Pfizer': 56160,\n", " 'Distributed_Janssen': 1700,\n", " 'Distributed_Unk_Manuf': 0,\n", " 'Series_Complete_Moderna': 15262,\n", " 'Series_Complete_Pfizer': 24951,\n", " 'Series_Complete_Janssen': 360,\n", " 'Series_Complete_Unk_Manuf': 0,\n", " 'Series_Complete_Moderna_18Plus': 15262,\n", " 'Series_Complete_Pfizer_18Plus': 24951,\n", " 'Series_Complete_Janssen_18Plus': 360,\n", " 'Series_Complete_Unk_Manuf_18Plus': 0,\n", " 'Series_Complete_Moderna_65Plus': 790,\n", " 'Series_Complete_Pfizer_65Plus': 1034,\n", " 'Series_Complete_Janssen_65Plus': 2,\n", " 'Series_Complete_Unk_Manuf_65Plus': 0,\n", " 'Series_Complete_Yes': 40573,\n", " 'Series_Complete_Pop_Pct': 0.0,\n", " 'Series_Complete_18Plus': 40573,\n", " 'Series_Complete_18PlusPop_Pct': 0.0,\n", " 'Series_Complete_65Plus': 1826,\n", " 'Series_Complete_65PlusPop_Pct': 0.0},\n", " {'Date': '2021-03-29',\n", " 'Location': 'CA',\n", " 'ShortName': 'CAA',\n", " 'LongName': 'California',\n", " 'Census2019': 39512223,\n", " 'date_type': 'Report',\n", " 'Doses_Distributed': 21865730,\n", " 'Doses_Administered': 17703550,\n", " 'Dist_Per_100K': 55339,\n", " 'Admin_Per_100K': 44805,\n", " 'Administered_Moderna': 8346037,\n", " 'Administered_Pfizer': 9015933,\n", " 'Administered_Janssen': 340130,\n", " 'Administered_Unk_Manuf': 1450,\n", " 'Administered_Dose1_Recip': 11802833,\n", " 'Administered_Dose1_Pop_Pct': 29.9,\n", " 'Administered_Dose2_Pop_Pct': 14.7,\n", " 'Administered_Dose1_Recip_18Plus': 11748137,\n", " 'Administered_Dose1_Recip_18PlusPop_Pct': 38.4,\n", " 'Administered_18Plus': 17639894,\n", " 'Admin_Per_100k_18Plus': 57614,\n", " 'Distributed_Per_100k_18Plus': 71416,\n", " 'Administered_Dose1_Recip_65Plus': 4516009,\n", " 'Administered_Dose1_Recip_65PlusPop_Pct': 77.4,\n", " 'Administered_65Plus': 7526330,\n", " 'Admin_Per_100k_65Plus': 128917,\n", " 'Distributed_Per_100k_65Plus': 374534,\n", " 'Administered_Dose2_Recip': 5793632,\n", " 'Administered_Dose2_Recip_18Plus': 5784852,\n", " 'Administered_Dose2_Recip_18PlusPop_Pct': 18.9,\n", " 'Distributed_Moderna': 10261100,\n", " 'Distributed_Pfizer': 10981230,\n", " 'Distributed_Janssen': 623400,\n", " 'Distributed_Unk_Manuf': 0,\n", " 'Series_Complete_Moderna': 2679016,\n", " 'Series_Complete_Pfizer': 3114389,\n", " 'Series_Complete_Janssen': 337704,\n", " 'Series_Complete_Unk_Manuf': 227,\n", " 'Series_Complete_Moderna_18Plus': 2678095,\n", " 'Series_Complete_Pfizer_18Plus': 3106531,\n", " 'Series_Complete_Janssen_18Plus': 336998,\n", " 'Series_Complete_Unk_Manuf_18Plus': 226,\n", " 'Series_Complete_Moderna_65Plus': 1521220,\n", " 'Series_Complete_Pfizer_65Plus': 1433764,\n", " 'Series_Complete_Janssen_65Plus': 47411,\n", " 'Series_Complete_Unk_Manuf_65Plus': 146,\n", " 'Series_Complete_Yes': 6131336,\n", " 'Series_Complete_Pop_Pct': 15.5,\n", " 'Series_Complete_18Plus': 6121850,\n", " 'Series_Complete_18PlusPop_Pct': 20.0,\n", " 'Series_Complete_65Plus': 3002541,\n", " 'Series_Complete_65PlusPop_Pct': 51.4},\n", " {'Date': '2021-03-29',\n", " 'Location': 'CO',\n", " 'ShortName': 'COA',\n", " 'LongName': 'Colorado',\n", " 'Census2019': 5758736,\n", " 'date_type': 'Report',\n", " 'Doses_Distributed': 3060410,\n", " 'Doses_Administered': 2602792,\n", " 'Dist_Per_100K': 53144,\n", " 'Admin_Per_100K': 45197,\n", " 'Administered_Moderna': 1258019,\n", " 'Administered_Pfizer': 1285511,\n", " 'Administered_Janssen': 58600,\n", " 'Administered_Unk_Manuf': 662,\n", " 'Administered_Dose1_Recip': 1664752,\n", " 'Administered_Dose1_Pop_Pct': 28.9,\n", " 'Administered_Dose2_Pop_Pct': 15.9,\n", " 'Administered_Dose1_Recip_18Plus': 1658310,\n", " 'Administered_Dose1_Recip_18PlusPop_Pct': 36.9,\n", " 'Administered_18Plus': 2595367,\n", " 'Admin_Per_100k_18Plus': 57685,\n", " 'Distributed_Per_100k_18Plus': 68021,\n", " 'Administered_Dose1_Recip_65Plus': 649585,\n", " 'Administered_Dose1_Recip_65PlusPop_Pct': 77.1,\n", " 'Administered_65Plus': 1158915,\n", " 'Admin_Per_100k_65Plus': 137571,\n", " 'Distributed_Per_100k_65Plus': 363291,\n", " 'Administered_Dose2_Recip': 918505,\n", " 'Administered_Dose2_Recip_18Plus': 917519,\n", " 'Administered_Dose2_Recip_18PlusPop_Pct': 20.4,\n", " 'Distributed_Moderna': 1476400,\n", " 'Distributed_Pfizer': 1508910,\n", " 'Distributed_Janssen': 75100,\n", " 'Distributed_Unk_Manuf': 0,\n", " 'Series_Complete_Moderna': 432184,\n", " 'Series_Complete_Pfizer': 486174,\n", " 'Series_Complete_Janssen': 57632,\n", " 'Series_Complete_Unk_Manuf': 147,\n", " 'Series_Complete_Moderna_18Plus': 432095,\n", " 'Series_Complete_Pfizer_18Plus': 485277,\n", " 'Series_Complete_Janssen_18Plus': 57536,\n", " 'Series_Complete_Unk_Manuf_18Plus': 147,\n", " 'Series_Complete_Moderna_65Plus': 242139,\n", " 'Series_Complete_Pfizer_65Plus': 257784,\n", " 'Series_Complete_Janssen_65Plus': 8134,\n", " 'Series_Complete_Unk_Manuf_65Plus': 89,\n", " 'Series_Complete_Yes': 976137,\n", " 'Series_Complete_Pop_Pct': 17.0,\n", " 'Series_Complete_18Plus': 975055,\n", " 'Series_Complete_18PlusPop_Pct': 21.7,\n", " 'Series_Complete_65Plus': 508146,\n", " 'Series_Complete_65PlusPop_Pct': 60.3},\n", " {'Date': '2021-03-29',\n", " 'Location': 'CT',\n", " 'ShortName': 'CTA',\n", " 'LongName': 'Connecticut',\n", " 'Census2019': 3565287,\n", " 'date_type': 'Report',\n", " 'Doses_Distributed': 2211275,\n", " 'Doses_Administered': 1891603,\n", " 'Dist_Per_100K': 62022,\n", " 'Admin_Per_100K': 53056,\n", " 'Administered_Moderna': 832374,\n", " 'Administered_Pfizer': 1014001,\n", " 'Administered_Janssen': 45092,\n", " 'Administered_Unk_Manuf': 136,\n", " 'Administered_Dose1_Recip': 1225480,\n", " 'Administered_Dose1_Pop_Pct': 34.4,\n", " 'Administered_Dose2_Pop_Pct': 18.3,\n", " 'Administered_Dose1_Recip_18Plus': 1223595,\n", " 'Administered_Dose1_Recip_18PlusPop_Pct': 43.1,\n", " 'Administered_18Plus': 1888859,\n", " 'Admin_Per_100k_18Plus': 66560,\n", " 'Distributed_Per_100k_18Plus': 77921,\n", " 'Administered_Dose1_Recip_65Plus': 522756,\n", " 'Administered_Dose1_Recip_65PlusPop_Pct': 82.9,\n", " 'Administered_65Plus': 927803,\n", " 'Admin_Per_100k_65Plus': 147213,\n", " 'Distributed_Per_100k_65Plus': 350860,\n", " 'Administered_Dose2_Recip': 652633,\n", " 'Administered_Dose2_Recip_18Plus': 651895,\n", " 'Administered_Dose2_Recip_18PlusPop_Pct': 23.0,\n", " 'Distributed_Moderna': 995900,\n", " 'Distributed_Pfizer': 1159275,\n", " 'Distributed_Janssen': 56100,\n", " 'Distributed_Unk_Manuf': 0,\n", " 'Series_Complete_Moderna': 281592,\n", " 'Series_Complete_Pfizer': 371022,\n", " 'Series_Complete_Janssen': 45151,\n", " 'Series_Complete_Unk_Manuf': 19,\n", " 'Series_Complete_Moderna_18Plus': 281424,\n", " 'Series_Complete_Pfizer_18Plus': 370452,\n", " 'Series_Complete_Janssen_18Plus': 45119,\n", " 'Series_Complete_Unk_Manuf_18Plus': 19,\n", " 'Series_Complete_Moderna_65Plus': 148642,\n", " 'Series_Complete_Pfizer_65Plus': 244545,\n", " 'Series_Complete_Janssen_65Plus': 5459,\n", " 'Series_Complete_Unk_Manuf_65Plus': 12,\n", " 'Series_Complete_Yes': 697784,\n", " 'Series_Complete_Pop_Pct': 19.6,\n", " 'Series_Complete_18Plus': 697014,\n", " 'Series_Complete_18PlusPop_Pct': 24.6,\n", " 'Series_Complete_65Plus': 398658,\n", " 'Series_Complete_65PlusPop_Pct': 63.3},\n", " {'Date': '2021-03-29',\n", " 'Location': 'DC',\n", " 'ShortName': 'DCA',\n", " 'LongName': 'District of Columbia',\n", " 'Census2019': 705749,\n", " 'date_type': 'Report',\n", " 'Doses_Distributed': 491635,\n", " 'Doses_Administered': 353718,\n", " 'Dist_Per_100K': 69661,\n", " 'Admin_Per_100K': 50120,\n", " 'Administered_Moderna': 140966,\n", " 'Administered_Pfizer': 205495,\n", " 'Administered_Janssen': 7257,\n", " 'Administered_Unk_Manuf': 0,\n", " 'Administered_Dose1_Recip': 181374,\n", " 'Administered_Dose1_Pop_Pct': 25.7,\n", " 'Administered_Dose2_Pop_Pct': 11.8,\n", " 'Administered_Dose1_Recip_18Plus': 180795,\n", " 'Administered_Dose1_Recip_18PlusPop_Pct': 31.3,\n", " 'Administered_18Plus': 353149,\n", " 'Admin_Per_100k_18Plus': 61143,\n", " 'Distributed_Per_100k_18Plus': 85120,\n", " 'Administered_Dose1_Recip_65Plus': 59062,\n", " 'Administered_Dose1_Recip_65PlusPop_Pct': 67.6,\n", " 'Administered_65Plus': 122464,\n", " 'Admin_Per_100k_65Plus': 140210,\n", " 'Distributed_Per_100k_65Plus': 562879,\n", " 'Administered_Dose2_Recip': 83416,\n", " 'Administered_Dose2_Recip_18Plus': 83394,\n", " 'Administered_Dose2_Recip_18PlusPop_Pct': 14.4,\n", " 'Distributed_Moderna': 214600,\n", " 'Distributed_Pfizer': 263835,\n", " 'Distributed_Janssen': 13200,\n", " 'Distributed_Unk_Manuf': 0,\n", " 'Series_Complete_Moderna': 39668,\n", " 'Series_Complete_Pfizer': 43733,\n", " 'Series_Complete_Janssen': 7901,\n", " 'Series_Complete_Unk_Manuf': 15,\n", " 'Series_Complete_Moderna_18Plus': 39667,\n", " 'Series_Complete_Pfizer_18Plus': 43712,\n", " 'Series_Complete_Janssen_18Plus': 7900,\n", " 'Series_Complete_Unk_Manuf_18Plus': 15,\n", " 'Series_Complete_Moderna_65Plus': 22630,\n", " 'Series_Complete_Pfizer_65Plus': 16112,\n", " 'Series_Complete_Janssen_65Plus': 657,\n", " 'Series_Complete_Unk_Manuf_65Plus': 7,\n", " 'Series_Complete_Yes': 91317,\n", " 'Series_Complete_Pop_Pct': 12.9,\n", " 'Series_Complete_18Plus': 91294,\n", " 'Series_Complete_18PlusPop_Pct': 15.8,\n", " 'Series_Complete_65Plus': 39406,\n", " 'Series_Complete_65PlusPop_Pct': 45.1},\n", " {'Date': '2021-03-29',\n", " 'Location': 'DD2',\n", " 'ShortName': 'DD2',\n", " 'LongName': 'Dept of Defense',\n", " 'Census2019': 0,\n", " 'date_type': 'Report',\n", " 'Doses_Distributed': 2405690,\n", " 'Doses_Administered': 1886141,\n", " 'Dist_Per_100K': 0,\n", " 'Admin_Per_100K': 0,\n", " 'Administered_Moderna': 868249,\n", " 'Administered_Pfizer': 996161,\n", " 'Administered_Janssen': 21332,\n", " 'Administered_Unk_Manuf': 399,\n", " 'Administered_Dose1_Recip': 1191364,\n", " 'Administered_Dose1_Pop_Pct': 0.0,\n", " 'Administered_Dose2_Pop_Pct': 0.0,\n", " 'Administered_Dose1_Recip_18Plus': 1186474,\n", " 'Administered_Dose1_Recip_18PlusPop_Pct': 0.0,\n", " 'Administered_18Plus': 1880365,\n", " 'Admin_Per_100k_18Plus': 0,\n", " 'Distributed_Per_100k_18Plus': 0,\n", " 'Administered_Dose1_Recip_65Plus': 133637,\n", " 'Administered_Dose1_Recip_65PlusPop_Pct': 0.0,\n", " 'Administered_65Plus': 221232,\n", " 'Admin_Per_100k_65Plus': 0,\n", " 'Distributed_Per_100k_65Plus': 0,\n", " 'Administered_Dose2_Recip': 646331,\n", " 'Administered_Dose2_Recip_18Plus': 645618,\n", " 'Administered_Dose2_Recip_18PlusPop_Pct': 0.0,\n", " 'Distributed_Moderna': 1062500,\n", " 'Distributed_Pfizer': 1291290,\n", " 'Distributed_Janssen': 51900,\n", " 'Distributed_Unk_Manuf': 0,\n", " 'Series_Complete_Moderna': 284953,\n", " 'Series_Complete_Pfizer': 361378,\n", " 'Series_Complete_Janssen': 18417,\n", " 'Series_Complete_Unk_Manuf': 0,\n", " 'Series_Complete_Moderna_18Plus': 284919,\n", " 'Series_Complete_Pfizer_18Plus': 360699,\n", " 'Series_Complete_Janssen_18Plus': 18408,\n", " 'Series_Complete_Unk_Manuf_18Plus': 0,\n", " 'Series_Complete_Moderna_65Plus': 26484,\n", " 'Series_Complete_Pfizer_65Plus': 55994,\n", " 'Series_Complete_Janssen_65Plus': 1028,\n", " 'Series_Complete_Unk_Manuf_65Plus': 0,\n", " 'Series_Complete_Yes': 664748,\n", " 'Series_Complete_Pop_Pct': 0.0,\n", " 'Series_Complete_18Plus': 664026,\n", " 'Series_Complete_18PlusPop_Pct': 0.0,\n", " 'Series_Complete_65Plus': 83506,\n", " 'Series_Complete_65PlusPop_Pct': 0.0},\n", " {'Date': '2021-03-29',\n", " 'Location': 'DE',\n", " 'ShortName': 'DEA',\n", " 'LongName': 'Delaware',\n", " 'Census2019': 973764,\n", " 'date_type': 'Report',\n", " 'Doses_Distributed': 555005,\n", " 'Doses_Administered': 447568,\n", " 'Dist_Per_100K': 56996,\n", " 'Admin_Per_100K': 45963,\n", " 'Administered_Moderna': 189524,\n", " 'Administered_Pfizer': 250816,\n", " 'Administered_Janssen': 7171,\n", " 'Administered_Unk_Manuf': 57,\n", " 'Administered_Dose1_Recip': 290527,\n", " 'Administered_Dose1_Pop_Pct': 29.8,\n", " 'Administered_Dose2_Pop_Pct': 14.9,\n", " 'Administered_Dose1_Recip_18Plus': 289695,\n", " 'Administered_Dose1_Recip_18PlusPop_Pct': 37.6,\n", " 'Administered_18Plus': 446501,\n", " 'Admin_Per_100k_18Plus': 57973,\n", " 'Distributed_Per_100k_18Plus': 72061,\n", " 'Administered_Dose1_Recip_65Plus': 148255,\n", " 'Administered_Dose1_Recip_65PlusPop_Pct': 78.5,\n", " 'Administered_65Plus': 244459,\n", " 'Admin_Per_100k_65Plus': 129408,\n", " 'Distributed_Per_100k_65Plus': 293800,\n", " 'Administered_Dose2_Recip': 145260,\n", " 'Administered_Dose2_Recip_18Plus': 145180,\n", " 'Administered_Dose2_Recip_18PlusPop_Pct': 18.8,\n", " 'Distributed_Moderna': 256700,\n", " 'Distributed_Pfizer': 284505,\n", " 'Distributed_Janssen': 13800,\n", " 'Distributed_Unk_Manuf': 0,\n", " 'Series_Complete_Moderna': 65241,\n", " 'Series_Complete_Pfizer': 79998,\n", " 'Series_Complete_Janssen': 7641,\n", " 'Series_Complete_Unk_Manuf': 21,\n", " 'Series_Complete_Moderna_18Plus': 65228,\n", " 'Series_Complete_Pfizer_18Plus': 79931,\n", " 'Series_Complete_Janssen_18Plus': 7640,\n", " 'Series_Complete_Unk_Manuf_18Plus': 21,\n", " 'Series_Complete_Moderna_65Plus': 42526,\n", " 'Series_Complete_Pfizer_65Plus': 47434,\n", " 'Series_Complete_Janssen_65Plus': 4820,\n", " 'Series_Complete_Unk_Manuf_65Plus': 13,\n", " 'Series_Complete_Yes': 152901,\n", " 'Series_Complete_Pop_Pct': 15.7,\n", " 'Series_Complete_18Plus': 152820,\n", " 'Series_Complete_18PlusPop_Pct': 19.8,\n", " 'Series_Complete_65Plus': 94793,\n", " 'Series_Complete_65PlusPop_Pct': 50.2},\n", " {'Date': '2021-03-29',\n", " 'Location': 'FL',\n", " 'ShortName': 'FLA',\n", " 'LongName': 'Florida',\n", " 'Census2019': 21477737,\n", " 'date_type': 'Report',\n", " 'Doses_Distributed': 12219465,\n", " 'Doses_Administered': 9276711,\n", " 'Dist_Per_100K': 56894,\n", " 'Admin_Per_100K': 43192,\n", " 'Administered_Moderna': 4451063,\n", " 'Administered_Pfizer': 4594805,\n", " 'Administered_Janssen': 218165,\n", " 'Administered_Unk_Manuf': 12678,\n", " 'Administered_Dose1_Recip': 5840928,\n", " 'Administered_Dose1_Pop_Pct': 27.2,\n", " 'Administered_Dose2_Pop_Pct': 14.1,\n", " 'Administered_Dose1_Recip_18Plus': 5830070,\n", " 'Administered_Dose1_Recip_18PlusPop_Pct': 33.8,\n", " 'Administered_18Plus': 9264325,\n", " 'Admin_Per_100k_18Plus': 53713,\n", " 'Distributed_Per_100k_18Plus': 70846,\n", " 'Administered_Dose1_Recip_65Plus': 3380979,\n", " 'Administered_Dose1_Recip_65PlusPop_Pct': 75.2,\n", " 'Administered_65Plus': 5986283,\n", " 'Admin_Per_100k_65Plus': 133107,\n", " 'Distributed_Per_100k_65Plus': 271704,\n", " 'Administered_Dose2_Recip': 3035343,\n", " 'Administered_Dose2_Recip_18Plus': 3033971,\n", " 'Administered_Dose2_Recip_18PlusPop_Pct': 17.6,\n", " 'Distributed_Moderna': 5602900,\n", " 'Distributed_Pfizer': 6241365,\n", " 'Distributed_Janssen': 375200,\n", " 'Distributed_Unk_Manuf': 0,\n", " 'Series_Complete_Moderna': 1462504,\n", " 'Series_Complete_Pfizer': 1568645,\n", " 'Series_Complete_Janssen': 216565,\n", " 'Series_Complete_Unk_Manuf': 4194,\n", " 'Series_Complete_Moderna_18Plus': 1461919,\n", " 'Series_Complete_Pfizer_18Plus': 1567858,\n", " 'Series_Complete_Janssen_18Plus': 216465,\n", " 'Series_Complete_Unk_Manuf_18Plus': 4194,\n", " 'Series_Complete_Moderna_65Plus': 1107818,\n", " 'Series_Complete_Pfizer_65Plus': 1136121,\n", " 'Series_Complete_Janssen_65Plus': 73453,\n", " 'Series_Complete_Unk_Manuf_65Plus': 3597,\n", " 'Series_Complete_Yes': 3251908,\n", " 'Series_Complete_Pop_Pct': 15.1,\n", " 'Series_Complete_18Plus': 3250436,\n", " 'Series_Complete_18PlusPop_Pct': 18.8,\n", " 'Series_Complete_65Plus': 2320989,\n", " 'Series_Complete_65PlusPop_Pct': 51.6},\n", " {'Date': '2021-03-29',\n", " 'Location': 'FM',\n", " 'ShortName': 'FMA',\n", " 'LongName': 'Federated States of Micronesia',\n", " 'Census2019': 103643,\n", " 'date_type': 'Report',\n", " 'Doses_Distributed': 47400,\n", " 'Doses_Administered': 24114,\n", " 'Dist_Per_100K': 45734,\n", " 'Admin_Per_100K': 23266,\n", " 'Administered_Moderna': 24114,\n", " 'Administered_Pfizer': 0,\n", " 'Administered_Janssen': 0,\n", " 'Administered_Unk_Manuf': 0,\n", " 'Administered_Dose1_Recip': 14736,\n", " 'Administered_Dose1_Pop_Pct': 14.2,\n", " 'Administered_Dose2_Pop_Pct': 9.1,\n", " 'Administered_Dose1_Recip_18Plus': 14726,\n", " 'Administered_Dose1_Recip_18PlusPop_Pct': 18.2,\n", " 'Administered_18Plus': 24104,\n", " 'Admin_Per_100k_18Plus': 29816,\n", " 'Distributed_Per_100k_18Plus': 58633,\n", " 'Administered_Dose1_Recip_65Plus': 1388,\n", " 'Administered_Dose1_Recip_65PlusPop_Pct': 7.9,\n", " 'Administered_65Plus': 2364,\n", " 'Admin_Per_100k_65Plus': 13417,\n", " 'Distributed_Per_100k_65Plus': 269028,\n", " 'Administered_Dose2_Recip': 9435,\n", " 'Administered_Dose2_Recip_18Plus': 9435,\n", " 'Administered_Dose2_Recip_18PlusPop_Pct': 11.7,\n", " 'Distributed_Moderna': 46600,\n", " 'Distributed_Pfizer': 0,\n", " 'Distributed_Janssen': 800,\n", " 'Distributed_Unk_Manuf': 0,\n", " 'Series_Complete_Moderna': 9416,\n", " 'Series_Complete_Pfizer': 19,\n", " 'Series_Complete_Janssen': 1,\n", " 'Series_Complete_Unk_Manuf': 0,\n", " 'Series_Complete_Moderna_18Plus': 9416,\n", " 'Series_Complete_Pfizer_18Plus': 19,\n", " 'Series_Complete_Janssen_18Plus': 1,\n", " 'Series_Complete_Unk_Manuf_18Plus': 0,\n", " 'Series_Complete_Moderna_65Plus': 999,\n", " 'Series_Complete_Pfizer_65Plus': 4,\n", " 'Series_Complete_Janssen_65Plus': 0,\n", " 'Series_Complete_Unk_Manuf_65Plus': 0,\n", " 'Series_Complete_Yes': 9436,\n", " 'Series_Complete_Pop_Pct': 9.1,\n", " 'Series_Complete_18Plus': 9436,\n", " 'Series_Complete_18PlusPop_Pct': 11.7,\n", " 'Series_Complete_65Plus': 1003,\n", " 'Series_Complete_65PlusPop_Pct': 5.7},\n", " {'Date': '2021-03-29',\n", " 'Location': 'GA',\n", " 'ShortName': 'GAA',\n", " 'LongName': 'Georgia',\n", " 'Census2019': 10617423,\n", " 'date_type': 'Report',\n", " 'Doses_Distributed': 5385975,\n", " 'Doses_Administered': 3764344,\n", " 'Dist_Per_100K': 50728,\n", " 'Admin_Per_100K': 35454,\n", " 'Administered_Moderna': 1918194,\n", " 'Administered_Pfizer': 1778404,\n", " 'Administered_Janssen': 67486,\n", " 'Administered_Unk_Manuf': 260,\n", " 'Administered_Dose1_Recip': 2447419,\n", " 'Administered_Dose1_Pop_Pct': 23.1,\n", " 'Administered_Dose2_Pop_Pct': 11.4,\n", " 'Administered_Dose1_Recip_18Plus': 2438588,\n", " 'Administered_Dose1_Recip_18PlusPop_Pct': 30.1,\n", " 'Administered_18Plus': 3754884,\n", " 'Admin_Per_100k_18Plus': 46279,\n", " 'Distributed_Per_100k_18Plus': 66383,\n", " 'Administered_Dose1_Recip_65Plus': 1033914,\n", " 'Administered_Dose1_Recip_65PlusPop_Pct': 68.2,\n", " 'Administered_65Plus': 1834217,\n", " 'Admin_Per_100k_65Plus': 120914,\n", " 'Distributed_Per_100k_65Plus': 355052,\n", " 'Administered_Dose2_Recip': 1210013,\n", " 'Administered_Dose2_Recip_18Plus': 1209436,\n", " 'Administered_Dose2_Recip_18PlusPop_Pct': 14.9,\n", " 'Distributed_Moderna': 2609000,\n", " 'Distributed_Pfizer': 2633475,\n", " 'Distributed_Janssen': 143500,\n", " 'Distributed_Unk_Manuf': 0,\n", " 'Series_Complete_Moderna': 653752,\n", " 'Series_Complete_Pfizer': 556092,\n", " 'Series_Complete_Janssen': 65055,\n", " 'Series_Complete_Unk_Manuf': 169,\n", " 'Series_Complete_Moderna_18Plus': 653677,\n", " 'Series_Complete_Pfizer_18Plus': 555590,\n", " 'Series_Complete_Janssen_18Plus': 64938,\n", " 'Series_Complete_Unk_Manuf_18Plus': 169,\n", " 'Series_Complete_Moderna_65Plus': 428069,\n", " 'Series_Complete_Pfizer_65Plus': 305238,\n", " 'Series_Complete_Janssen_65Plus': 8379,\n", " 'Series_Complete_Unk_Manuf_65Plus': 105,\n", " 'Series_Complete_Yes': 1275068,\n", " 'Series_Complete_Pop_Pct': 12.0,\n", " 'Series_Complete_18Plus': 1274374,\n", " 'Series_Complete_18PlusPop_Pct': 15.7,\n", " 'Series_Complete_65Plus': 741791,\n", " 'Series_Complete_65PlusPop_Pct': 48.9},\n", " {'Date': '2021-03-29',\n", " 'Location': 'GU',\n", " 'ShortName': 'GUA',\n", " 'LongName': 'Guam',\n", " 'Census2019': 165768,\n", " 'date_type': 'Report',\n", " 'Doses_Distributed': 87860,\n", " 'Doses_Administered': 84899,\n", " 'Dist_Per_100K': 53002,\n", " 'Admin_Per_100K': 51216,\n", " 'Administered_Moderna': 38790,\n", " 'Administered_Pfizer': 45956,\n", " 'Administered_Janssen': 153,\n", " 'Administered_Unk_Manuf': 0,\n", " 'Administered_Dose1_Recip': 52481,\n", " 'Administered_Dose1_Pop_Pct': 31.7,\n", " 'Administered_Dose2_Pop_Pct': 19.1,\n", " 'Administered_Dose1_Recip_18Plus': 51946,\n", " 'Administered_Dose1_Recip_18PlusPop_Pct': 40.2,\n", " 'Administered_18Plus': 84342,\n", " 'Admin_Per_100k_18Plus': 65230,\n", " 'Distributed_Per_100k_18Plus': 67951,\n", " 'Administered_Dose1_Recip_65Plus': 12290,\n", " 'Administered_Dose1_Recip_65PlusPop_Pct': 43.6,\n", " 'Administered_65Plus': 22459,\n", " 'Admin_Per_100k_65Plus': 79696,\n", " 'Distributed_Per_100k_65Plus': 311770,\n", " 'Administered_Dose2_Recip': 31639,\n", " 'Administered_Dose2_Recip_18Plus': 31619,\n", " 'Administered_Dose2_Recip_18PlusPop_Pct': 24.5,\n", " 'Distributed_Moderna': 38200,\n", " 'Distributed_Pfizer': 48360,\n", " 'Distributed_Janssen': 1300,\n", " 'Distributed_Unk_Manuf': 0,\n", " 'Series_Complete_Moderna': 15893,\n", " 'Series_Complete_Pfizer': 15746,\n", " 'Series_Complete_Janssen': 152,\n", " 'Series_Complete_Unk_Manuf': 0,\n", " 'Series_Complete_Moderna_18Plus': 15891,\n", " 'Series_Complete_Pfizer_18Plus': 15728,\n", " 'Series_Complete_Janssen_18Plus': 152,\n", " 'Series_Complete_Unk_Manuf_18Plus': 0,\n", " 'Series_Complete_Moderna_65Plus': 4410,\n", " 'Series_Complete_Pfizer_65Plus': 5582,\n", " 'Series_Complete_Janssen_65Plus': 24,\n", " 'Series_Complete_Unk_Manuf_65Plus': 0,\n", " 'Series_Complete_Yes': 31791,\n", " 'Series_Complete_Pop_Pct': 19.2,\n", " 'Series_Complete_18Plus': 31771,\n", " 'Series_Complete_18PlusPop_Pct': 24.6,\n", " 'Series_Complete_65Plus': 10016,\n", " 'Series_Complete_65PlusPop_Pct': 35.5},\n", " {'Date': '2021-03-29',\n", " 'Location': 'HI',\n", " 'ShortName': 'HIA',\n", " 'LongName': 'Hawaii',\n", " 'Census2019': 1415872,\n", " 'date_type': 'Report',\n", " 'Doses_Distributed': 890600,\n", " 'Doses_Administered': 685464,\n", " 'Dist_Per_100K': 62901,\n", " 'Admin_Per_100K': 48413,\n", " 'Administered_Moderna': 245051,\n", " 'Administered_Pfizer': 337742,\n", " 'Administered_Janssen': 8911,\n", " 'Administered_Unk_Manuf': 93760,\n", " 'Administered_Dose1_Recip': 439169,\n", " 'Administered_Dose1_Pop_Pct': 31.0,\n", " 'Administered_Dose2_Pop_Pct': 17.7,\n", " 'Administered_Dose1_Recip_18Plus': 437142,\n", " 'Administered_Dose1_Recip_18PlusPop_Pct': 39.2,\n", " 'Administered_18Plus': 683768,\n", " 'Admin_Per_100k_18Plus': 61269,\n", " 'Distributed_Per_100k_18Plus': 79803,\n", " 'Administered_Dose1_Recip_65Plus': 165143,\n", " 'Administered_Dose1_Recip_65PlusPop_Pct': 61.5,\n", " 'Administered_65Plus': 258598,\n", " 'Admin_Per_100k_65Plus': 96331,\n", " 'Distributed_Per_100k_65Plus': 331759,\n", " 'Administered_Dose2_Recip': 250416,\n", " 'Administered_Dose2_Recip_18Plus': 250121,\n", " 'Administered_Dose2_Recip_18PlusPop_Pct': 22.4,\n", " 'Distributed_Moderna': 383000,\n", " 'Distributed_Pfizer': 487500,\n", " 'Distributed_Janssen': 20100,\n", " 'Distributed_Unk_Manuf': 0,\n", " 'Series_Complete_Moderna': 96897,\n", " 'Series_Complete_Pfizer': 135483,\n", " 'Series_Complete_Janssen': 9047,\n", " 'Series_Complete_Unk_Manuf': 18036,\n", " 'Series_Complete_Moderna_18Plus': 96849,\n", " 'Series_Complete_Pfizer_18Plus': 135253,\n", " 'Series_Complete_Janssen_18Plus': 9029,\n", " 'Series_Complete_Unk_Manuf_18Plus': 18019,\n", " 'Series_Complete_Moderna_65Plus': 46216,\n", " 'Series_Complete_Pfizer_65Plus': 47669,\n", " 'Series_Complete_Janssen_65Plus': 2681,\n", " 'Series_Complete_Unk_Manuf_65Plus': 1408,\n", " 'Series_Complete_Yes': 259463,\n", " 'Series_Complete_Pop_Pct': 18.3,\n", " 'Series_Complete_18Plus': 259150,\n", " 'Series_Complete_18PlusPop_Pct': 23.2,\n", " 'Series_Complete_65Plus': 97974,\n", " 'Series_Complete_65PlusPop_Pct': 36.5},\n", " {'Date': '2021-03-29',\n", " 'Location': 'IA',\n", " 'ShortName': 'IAA',\n", " 'LongName': 'Iowa',\n", " 'Census2019': 3155070,\n", " 'date_type': 'Report',\n", " 'Doses_Distributed': 1696035,\n", " 'Doses_Administered': 1514487,\n", " 'Dist_Per_100K': 53756,\n", " 'Admin_Per_100K': 48002,\n", " 'Administered_Moderna': 781782,\n", " 'Administered_Pfizer': 692562,\n", " 'Administered_Janssen': 40024,\n", " 'Administered_Unk_Manuf': 119,\n", " 'Administered_Dose1_Recip': 956164,\n", " 'Administered_Dose1_Pop_Pct': 30.3,\n", " 'Administered_Dose2_Pop_Pct': 17.7,\n", " 'Administered_Dose1_Recip_18Plus': 953614,\n", " 'Administered_Dose1_Recip_18PlusPop_Pct': 39.3,\n", " 'Administered_18Plus': 1511108,\n", " 'Admin_Per_100k_18Plus': 62231,\n", " 'Distributed_Per_100k_18Plus': 69847,\n", " 'Administered_Dose1_Recip_65Plus': 435712,\n", " 'Administered_Dose1_Recip_65PlusPop_Pct': 78.8,\n", " 'Administered_65Plus': 756182,\n", " 'Admin_Per_100k_65Plus': 136753,\n", " 'Distributed_Per_100k_65Plus': 306723,\n", " 'Administered_Dose2_Recip': 558800,\n", " 'Administered_Dose2_Recip_18Plus': 557906,\n", " 'Administered_Dose2_Recip_18PlusPop_Pct': 23.0,\n", " 'Distributed_Moderna': 837700,\n", " 'Distributed_Pfizer': 809835,\n", " 'Distributed_Janssen': 48500,\n", " 'Distributed_Unk_Manuf': 0,\n", " 'Series_Complete_Moderna': 302515,\n", " 'Series_Complete_Pfizer': 256261,\n", " 'Series_Complete_Janssen': 40135,\n", " 'Series_Complete_Unk_Manuf': 24,\n", " 'Series_Complete_Moderna_18Plus': 302503,\n", " 'Series_Complete_Pfizer_18Plus': 255379,\n", " 'Series_Complete_Janssen_18Plus': 40124,\n", " 'Series_Complete_Unk_Manuf_18Plus': 24,\n", " 'Series_Complete_Moderna_65Plus': 166875,\n", " 'Series_Complete_Pfizer_65Plus': 153324,\n", " 'Series_Complete_Janssen_65Plus': 3259,\n", " 'Series_Complete_Unk_Manuf_65Plus': 18,\n", " 'Series_Complete_Yes': 598935,\n", " 'Series_Complete_Pop_Pct': 19.0,\n", " 'Series_Complete_18Plus': 598030,\n", " 'Series_Complete_18PlusPop_Pct': 24.6,\n", " 'Series_Complete_65Plus': 323476,\n", " 'Series_Complete_65PlusPop_Pct': 58.5},\n", " {'Date': '2021-03-29',\n", " 'Location': 'ID',\n", " 'ShortName': 'IDA',\n", " 'LongName': 'Idaho',\n", " 'Census2019': 1787065,\n", " 'date_type': 'Report',\n", " 'Doses_Distributed': 910095,\n", " 'Doses_Administered': 736941,\n", " 'Dist_Per_100K': 50927,\n", " 'Admin_Per_100K': 41238,\n", " 'Administered_Moderna': 356171,\n", " 'Administered_Pfizer': 365720,\n", " 'Administered_Janssen': 14807,\n", " 'Administered_Unk_Manuf': 243,\n", " 'Administered_Dose1_Recip': 452828,\n", " 'Administered_Dose1_Pop_Pct': 25.3,\n", " 'Administered_Dose2_Pop_Pct': 15.2,\n", " 'Administered_Dose1_Recip_18Plus': 452791,\n", " 'Administered_Dose1_Recip_18PlusPop_Pct': 33.8,\n", " 'Administered_18Plus': 736912,\n", " 'Admin_Per_100k_18Plus': 55040,\n", " 'Distributed_Per_100k_18Plus': 67975,\n", " 'Administered_Dose1_Recip_65Plus': 205741,\n", " 'Administered_Dose1_Recip_65PlusPop_Pct': 70.8,\n", " 'Administered_65Plus': 361714,\n", " 'Admin_Per_100k_65Plus': 124441,\n", " 'Distributed_Per_100k_65Plus': 313102,\n", " 'Administered_Dose2_Recip': 272274,\n", " 'Administered_Dose2_Recip_18Plus': 272263,\n", " 'Administered_Dose2_Recip_18PlusPop_Pct': 20.3,\n", " 'Distributed_Moderna': 451400,\n", " 'Distributed_Pfizer': 433095,\n", " 'Distributed_Janssen': 25600,\n", " 'Distributed_Unk_Manuf': 0,\n", " 'Series_Complete_Moderna': 136188,\n", " 'Series_Complete_Pfizer': 136034,\n", " 'Series_Complete_Janssen': 14605,\n", " 'Series_Complete_Unk_Manuf': 52,\n", " 'Series_Complete_Moderna_18Plus': 136186,\n", " 'Series_Complete_Pfizer_18Plus': 136025,\n", " 'Series_Complete_Janssen_18Plus': 14599,\n", " 'Series_Complete_Unk_Manuf_18Plus': 52,\n", " 'Series_Complete_Moderna_65Plus': 71640,\n", " 'Series_Complete_Pfizer_65Plus': 82156,\n", " 'Series_Complete_Janssen_65Plus': 4253,\n", " 'Series_Complete_Unk_Manuf_65Plus': 29,\n", " 'Series_Complete_Yes': 286879,\n", " 'Series_Complete_Pop_Pct': 16.1,\n", " 'Series_Complete_18Plus': 286862,\n", " 'Series_Complete_18PlusPop_Pct': 21.4,\n", " 'Series_Complete_65Plus': 158078,\n", " 'Series_Complete_65PlusPop_Pct': 54.4},\n", " {'Date': '2021-03-29',\n", " 'Location': 'IH2',\n", " 'ShortName': 'IH2',\n", " 'LongName': 'Indian Health Svc',\n", " 'Census2019': 2082813,\n", " 'date_type': 'Report',\n", " 'Doses_Distributed': 1462525,\n", " 'Doses_Administered': 945805,\n", " 'Dist_Per_100K': 70219,\n", " 'Admin_Per_100K': 45410,\n", " 'Administered_Moderna': 528073,\n", " 'Administered_Pfizer': 409758,\n", " 'Administered_Janssen': 7974,\n", " 'Administered_Unk_Manuf': 0,\n", " 'Administered_Dose1_Recip': 592001,\n", " 'Administered_Dose1_Pop_Pct': 28.4,\n", " 'Administered_Dose2_Pop_Pct': 16.7,\n", " 'Administered_Dose1_Recip_18Plus': 581359,\n", " 'Administered_Dose1_Recip_18PlusPop_Pct': 0.0,\n", " 'Administered_18Plus': 930643,\n", " 'Admin_Per_100k_18Plus': 0,\n", " 'Distributed_Per_100k_18Plus': 0,\n", " 'Administered_Dose1_Recip_65Plus': 133928,\n", " 'Administered_Dose1_Recip_65PlusPop_Pct': 0.0,\n", " 'Administered_65Plus': 232475,\n", " 'Admin_Per_100k_65Plus': 0,\n", " 'Distributed_Per_100k_65Plus': 0,\n", " 'Administered_Dose2_Recip': 346849,\n", " 'Administered_Dose2_Recip_18Plus': 342390,\n", " 'Administered_Dose2_Recip_18PlusPop_Pct': 0.0,\n", " 'Distributed_Moderna': 831300,\n", " 'Distributed_Pfizer': 603525,\n", " 'Distributed_Janssen': 27700,\n", " 'Distributed_Unk_Manuf': 0,\n", " 'Series_Complete_Moderna': 185981,\n", " 'Series_Complete_Pfizer': 160868,\n", " 'Series_Complete_Janssen': 7851,\n", " 'Series_Complete_Unk_Manuf': 0,\n", " 'Series_Complete_Moderna_18Plus': 185891,\n", " 'Series_Complete_Pfizer_18Plus': 156499,\n", " 'Series_Complete_Janssen_18Plus': 7839,\n", " 'Series_Complete_Unk_Manuf_18Plus': 0,\n", " 'Series_Complete_Moderna_65Plus': 54027,\n", " 'Series_Complete_Pfizer_65Plus': 41603,\n", " 'Series_Complete_Janssen_65Plus': 888,\n", " 'Series_Complete_Unk_Manuf_65Plus': 0,\n", " 'Series_Complete_Yes': 354700,\n", " 'Series_Complete_Pop_Pct': 17.0,\n", " 'Series_Complete_18Plus': 350229,\n", " 'Series_Complete_18PlusPop_Pct': 0.0,\n", " 'Series_Complete_65Plus': 96518,\n", " 'Series_Complete_65PlusPop_Pct': 0.0},\n", " {'Date': '2021-03-29',\n", " 'Location': 'IL',\n", " 'ShortName': 'ILA',\n", " 'LongName': 'Illinois',\n", " 'Census2019': 12671821,\n", " 'date_type': 'Report',\n", " 'Doses_Distributed': 6883535,\n", " 'Doses_Administered': 5793846,\n", " 'Dist_Per_100K': 54322,\n", " 'Admin_Per_100K': 45722,\n", " 'Administered_Moderna': 2718496,\n", " 'Administered_Pfizer': 2955173,\n", " 'Administered_Janssen': 117715,\n", " 'Administered_Unk_Manuf': 2462,\n", " 'Administered_Dose1_Recip': 3832086,\n", " 'Administered_Dose1_Pop_Pct': 30.2,\n", " 'Administered_Dose2_Pop_Pct': 15.2,\n", " 'Administered_Dose1_Recip_18Plus': 3818867,\n", " 'Administered_Dose1_Recip_18PlusPop_Pct': 38.8,\n", " 'Administered_18Plus': 5777193,\n", " 'Admin_Per_100k_18Plus': 58628,\n", " 'Distributed_Per_100k_18Plus': 69856,\n", " 'Administered_Dose1_Recip_65Plus': 1497587,\n", " 'Administered_Dose1_Recip_65PlusPop_Pct': 73.3,\n", " 'Administered_65Plus': 2381608,\n", " 'Admin_Per_100k_65Plus': 116561,\n", " 'Distributed_Per_100k_65Plus': 336894,\n", " 'Administered_Dose2_Recip': 1927319,\n", " 'Administered_Dose2_Recip_18Plus': 1924058,\n", " 'Administered_Dose2_Recip_18PlusPop_Pct': 19.5,\n", " 'Distributed_Moderna': 3218600,\n", " 'Distributed_Pfizer': 3477435,\n", " 'Distributed_Janssen': 187500,\n", " 'Distributed_Unk_Manuf': 0,\n", " 'Series_Complete_Moderna': 917487,\n", " 'Series_Complete_Pfizer': 1009032,\n", " 'Series_Complete_Janssen': 115139,\n", " 'Series_Complete_Unk_Manuf': 800,\n", " 'Series_Complete_Moderna_18Plus': 917186,\n", " 'Series_Complete_Pfizer_18Plus': 1006073,\n", " 'Series_Complete_Janssen_18Plus': 114912,\n", " 'Series_Complete_Unk_Manuf_18Plus': 799,\n", " 'Series_Complete_Moderna_65Plus': 433475,\n", " 'Series_Complete_Pfizer_65Plus': 453162,\n", " 'Series_Complete_Janssen_65Plus': 24685,\n", " 'Series_Complete_Unk_Manuf_65Plus': 524,\n", " 'Series_Complete_Yes': 2042458,\n", " 'Series_Complete_Pop_Pct': 16.1,\n", " 'Series_Complete_18Plus': 2038970,\n", " 'Series_Complete_18PlusPop_Pct': 20.7,\n", " 'Series_Complete_65Plus': 911846,\n", " 'Series_Complete_65PlusPop_Pct': 44.6},\n", " {'Date': '2021-03-29',\n", " 'Location': 'IN',\n", " 'ShortName': 'INA',\n", " 'LongName': 'Indiana',\n", " 'Census2019': 6732219,\n", " 'date_type': 'Report',\n", " 'Doses_Distributed': 3328110,\n", " 'Doses_Administered': 2734813,\n", " 'Dist_Per_100K': 49436,\n", " 'Admin_Per_100K': 40623,\n", " 'Administered_Moderna': 1233756,\n", " 'Administered_Pfizer': 1441423,\n", " 'Administered_Janssen': 55688,\n", " 'Administered_Unk_Manuf': 3946,\n", " 'Administered_Dose1_Recip': 1673593,\n", " 'Administered_Dose1_Pop_Pct': 24.9,\n", " 'Administered_Dose2_Pop_Pct': 15.5,\n", " 'Administered_Dose1_Recip_18Plus': 1672348,\n", " 'Administered_Dose1_Recip_18PlusPop_Pct': 32.4,\n", " 'Administered_18Plus': 2733164,\n", " 'Admin_Per_100k_18Plus': 52925,\n", " 'Distributed_Per_100k_18Plus': 64445,\n", " 'Administered_Dose1_Recip_65Plus': 783089,\n", " 'Administered_Dose1_Recip_65PlusPop_Pct': 72.1,\n", " 'Administered_65Plus': 1452355,\n", " 'Admin_Per_100k_65Plus': 133766,\n", " 'Distributed_Per_100k_65Plus': 306528,\n", " 'Administered_Dose2_Recip': 1042306,\n", " 'Administered_Dose2_Recip_18Plus': 1041884,\n", " 'Administered_Dose2_Recip_18PlusPop_Pct': 20.2,\n", " 'Distributed_Moderna': 1627000,\n", " 'Distributed_Pfizer': 1602510,\n", " 'Distributed_Janssen': 98600,\n", " 'Distributed_Unk_Manuf': 0,\n", " 'Series_Complete_Moderna': 482836,\n", " 'Series_Complete_Pfizer': 558106,\n", " 'Series_Complete_Janssen': 56000,\n", " 'Series_Complete_Unk_Manuf': 1364,\n", " 'Series_Complete_Moderna_18Plus': 482801,\n", " 'Series_Complete_Pfizer_18Plus': 557719,\n", " 'Series_Complete_Janssen_18Plus': 55992,\n", " 'Series_Complete_Unk_Manuf_18Plus': 1364,\n", " 'Series_Complete_Moderna_65Plus': 342355,\n", " 'Series_Complete_Pfizer_65Plus': 306161,\n", " 'Series_Complete_Janssen_65Plus': 7594,\n", " 'Series_Complete_Unk_Manuf_65Plus': 992,\n", " 'Series_Complete_Yes': 1098306,\n", " 'Series_Complete_Pop_Pct': 16.3,\n", " 'Series_Complete_18Plus': 1097876,\n", " 'Series_Complete_18PlusPop_Pct': 21.3,\n", " 'Series_Complete_65Plus': 657102,\n", " 'Series_Complete_65PlusPop_Pct': 60.5},\n", " {'Date': '2021-03-29',\n", " 'Location': 'KS',\n", " 'ShortName': 'KSA',\n", " 'LongName': 'Kansas',\n", " 'Census2019': 2913314,\n", " 'date_type': 'Report',\n", " 'Doses_Distributed': 1643765,\n", " 'Doses_Administered': 1261951,\n", " 'Dist_Per_100K': 56423,\n", " 'Admin_Per_100K': 43317,\n", " 'Administered_Moderna': 651902,\n", " 'Administered_Pfizer': 588518,\n", " 'Administered_Janssen': 21290,\n", " 'Administered_Unk_Manuf': 241,\n", " 'Administered_Dose1_Recip': 854185,\n", " 'Administered_Dose1_Pop_Pct': 29.3,\n", " 'Administered_Dose2_Pop_Pct': 15.6,\n", " 'Administered_Dose1_Recip_18Plus': 851538,\n", " 'Administered_Dose1_Recip_18PlusPop_Pct': 38.5,\n", " 'Administered_18Plus': 1258836,\n", " 'Admin_Per_100k_18Plus': 56882,\n", " 'Distributed_Per_100k_18Plus': 74276,\n", " 'Administered_Dose1_Recip_65Plus': 371186,\n", " 'Administered_Dose1_Recip_65PlusPop_Pct': 78.1,\n", " 'Administered_65Plus': 583855,\n", " 'Admin_Per_100k_65Plus': 122791,\n", " 'Distributed_Per_100k_65Plus': 345701,\n", " 'Administered_Dose2_Recip': 455016,\n", " 'Administered_Dose2_Recip_18Plus': 454253,\n", " 'Administered_Dose2_Recip_18PlusPop_Pct': 20.5,\n", " 'Distributed_Moderna': 817900,\n", " 'Distributed_Pfizer': 785265,\n", " 'Distributed_Janssen': 40600,\n", " 'Distributed_Unk_Manuf': 0,\n", " 'Series_Complete_Moderna': 239472,\n", " 'Series_Complete_Pfizer': 215441,\n", " 'Series_Complete_Janssen': 22003,\n", " 'Series_Complete_Unk_Manuf': 103,\n", " 'Series_Complete_Moderna_18Plus': 239450,\n", " 'Series_Complete_Pfizer_18Plus': 214700,\n", " 'Series_Complete_Janssen_18Plus': 21993,\n", " 'Series_Complete_Unk_Manuf_18Plus': 103,\n", " 'Series_Complete_Moderna_65Plus': 121291,\n", " 'Series_Complete_Pfizer_65Plus': 113601,\n", " 'Series_Complete_Janssen_65Plus': 5098,\n", " 'Series_Complete_Unk_Manuf_65Plus': 68,\n", " 'Series_Complete_Yes': 477019,\n", " 'Series_Complete_Pop_Pct': 16.4,\n", " 'Series_Complete_18Plus': 476246,\n", " 'Series_Complete_18PlusPop_Pct': 21.5,\n", " 'Series_Complete_65Plus': 240058,\n", " 'Series_Complete_65PlusPop_Pct': 50.5},\n", " {'Date': '2021-03-29',\n", " 'Location': 'KY',\n", " 'ShortName': 'KYA',\n", " 'LongName': 'Kentucky',\n", " 'Census2019': 4467673,\n", " 'date_type': 'Report',\n", " 'Doses_Distributed': 2371375,\n", " 'Doses_Administered': 2058753,\n", " 'Dist_Per_100K': 53079,\n", " 'Admin_Per_100K': 46081,\n", " 'Administered_Moderna': 978845,\n", " 'Administered_Pfizer': 1035005,\n", " 'Administered_Janssen': 44747,\n", " 'Administered_Unk_Manuf': 156,\n", " 'Administered_Dose1_Recip': 1365477,\n", " 'Administered_Dose1_Pop_Pct': 30.6,\n", " 'Administered_Dose2_Pop_Pct': 15.9,\n", " 'Administered_Dose1_Recip_18Plus': 1360908,\n", " 'Administered_Dose1_Recip_18PlusPop_Pct': 39.3,\n", " 'Administered_18Plus': 2052803,\n", " 'Admin_Per_100k_18Plus': 59247,\n", " 'Distributed_Per_100k_18Plus': 68442,\n", " 'Administered_Dose1_Recip_65Plus': 537970,\n", " 'Administered_Dose1_Recip_65PlusPop_Pct': 71.7,\n", " 'Administered_65Plus': 862555,\n", " 'Admin_Per_100k_65Plus': 114921,\n", " 'Distributed_Per_100k_65Plus': 315946,\n", " 'Administered_Dose2_Recip': 710038,\n", " 'Administered_Dose2_Recip_18Plus': 709327,\n", " 'Administered_Dose2_Recip_18PlusPop_Pct': 20.5,\n", " 'Distributed_Moderna': 1147600,\n", " 'Distributed_Pfizer': 1167075,\n", " 'Distributed_Janssen': 56700,\n", " 'Distributed_Unk_Manuf': 0,\n", " 'Series_Complete_Moderna': 339691,\n", " 'Series_Complete_Pfizer': 370242,\n", " 'Series_Complete_Janssen': 42575,\n", " 'Series_Complete_Unk_Manuf': 105,\n", " 'Series_Complete_Moderna_18Plus': 339671,\n", " 'Series_Complete_Pfizer_18Plus': 369551,\n", " 'Series_Complete_Janssen_18Plus': 42555,\n", " 'Series_Complete_Unk_Manuf_18Plus': 105,\n", " 'Series_Complete_Moderna_65Plus': 150374,\n", " 'Series_Complete_Pfizer_65Plus': 191007,\n", " 'Series_Complete_Janssen_65Plus': 13067,\n", " 'Series_Complete_Unk_Manuf_65Plus': 69,\n", " 'Series_Complete_Yes': 752613,\n", " 'Series_Complete_Pop_Pct': 16.8,\n", " 'Series_Complete_18Plus': 751882,\n", " 'Series_Complete_18PlusPop_Pct': 21.7,\n", " 'Series_Complete_65Plus': 354517,\n", " 'Series_Complete_65PlusPop_Pct': 47.2},\n", " {'Date': '2021-03-29',\n", " 'Location': 'LA',\n", " 'ShortName': 'LAA',\n", " 'LongName': 'Louisiana',\n", " 'Census2019': 4648794,\n", " 'date_type': 'Report',\n", " 'Doses_Distributed': 2550580,\n", " 'Doses_Administered': 1911134,\n", " 'Dist_Per_100K': 54865,\n", " 'Admin_Per_100K': 41110,\n", " 'Administered_Moderna': 848549,\n", " 'Administered_Pfizer': 1009621,\n", " 'Administered_Janssen': 52150,\n", " 'Administered_Unk_Manuf': 814,\n", " 'Administered_Dose1_Recip': 1191044,\n", " 'Administered_Dose1_Pop_Pct': 25.6,\n", " 'Administered_Dose2_Pop_Pct': 14.7,\n", " 'Administered_Dose1_Recip_18Plus': 1187977,\n", " 'Administered_Dose1_Recip_18PlusPop_Pct': 33.4,\n", " 'Administered_18Plus': 1907822,\n", " 'Admin_Per_100k_18Plus': 53573,\n", " 'Distributed_Per_100k_18Plus': 71622,\n", " 'Administered_Dose1_Recip_65Plus': 513275,\n", " 'Administered_Dose1_Recip_65PlusPop_Pct': 69.3,\n", " 'Administered_65Plus': 934278,\n", " 'Admin_Per_100k_65Plus': 126080,\n", " 'Distributed_Per_100k_65Plus': 344198,\n", " 'Administered_Dose2_Recip': 684360,\n", " 'Administered_Dose2_Recip_18Plus': 684165,\n", " 'Administered_Dose2_Recip_18PlusPop_Pct': 19.2,\n", " 'Distributed_Moderna': 1209300,\n", " 'Distributed_Pfizer': 1276080,\n", " 'Distributed_Janssen': 65200,\n", " 'Distributed_Unk_Manuf': 0,\n", " 'Series_Complete_Moderna': 279342,\n", " 'Series_Complete_Pfizer': 404652,\n", " 'Series_Complete_Janssen': 50696,\n", " 'Series_Complete_Unk_Manuf': 366,\n", " 'Series_Complete_Moderna_18Plus': 279318,\n", " 'Series_Complete_Pfizer_18Plus': 404482,\n", " 'Series_Complete_Janssen_18Plus': 50667,\n", " 'Series_Complete_Unk_Manuf_18Plus': 365,\n", " 'Series_Complete_Moderna_65Plus': 179517,\n", " 'Series_Complete_Pfizer_65Plus': 222468,\n", " 'Series_Complete_Janssen_65Plus': 11179,\n", " 'Series_Complete_Unk_Manuf_65Plus': 75,\n", " 'Series_Complete_Yes': 735056,\n", " 'Series_Complete_Pop_Pct': 15.8,\n", " 'Series_Complete_18Plus': 734832,\n", " 'Series_Complete_18PlusPop_Pct': 20.6,\n", " 'Series_Complete_65Plus': 413239,\n", " 'Series_Complete_65PlusPop_Pct': 55.8},\n", " {'Date': '2021-03-29',\n", " 'Location': 'MA',\n", " 'ShortName': 'MAA',\n", " 'LongName': 'Massachusetts',\n", " 'Census2019': 6892503,\n", " 'date_type': 'Report',\n", " 'Doses_Distributed': 3848770,\n", " 'Doses_Administered': 3495331,\n", " 'Dist_Per_100K': 55840,\n", " 'Admin_Per_100K': 50712,\n", " 'Administered_Moderna': 1696716,\n", " 'Administered_Pfizer': 1714188,\n", " 'Administered_Janssen': 84366,\n", " 'Administered_Unk_Manuf': 61,\n", " 'Administered_Dose1_Recip': 2293964,\n", " 'Administered_Dose1_Pop_Pct': 33.3,\n", " 'Administered_Dose2_Pop_Pct': 17.0,\n", " 'Administered_Dose1_Recip_18Plus': 2286758,\n", " 'Administered_Dose1_Recip_18PlusPop_Pct': 41.3,\n", " 'Administered_18Plus': 3485600,\n", " 'Admin_Per_100k_18Plus': 62920,\n", " 'Distributed_Per_100k_18Plus': 69476,\n", " 'Administered_Dose1_Recip_65Plus': 949278,\n", " 'Administered_Dose1_Recip_65PlusPop_Pct': 81.2,\n", " 'Administered_65Plus': 1520373,\n", " 'Admin_Per_100k_65Plus': 130021,\n", " 'Distributed_Per_100k_65Plus': 329143,\n", " 'Administered_Dose2_Recip': 1172283,\n", " 'Administered_Dose2_Recip_18Plus': 1169948,\n", " 'Administered_Dose2_Recip_18PlusPop_Pct': 21.1,\n", " 'Distributed_Moderna': 1869500,\n", " 'Distributed_Pfizer': 1877070,\n", " 'Distributed_Janssen': 102200,\n", " 'Distributed_Unk_Manuf': 0,\n", " 'Series_Complete_Moderna': 573625,\n", " 'Series_Complete_Pfizer': 598649,\n", " 'Series_Complete_Janssen': 84333,\n", " 'Series_Complete_Unk_Manuf': 9,\n", " 'Series_Complete_Moderna_18Plus': 573487,\n", " 'Series_Complete_Pfizer_18Plus': 596452,\n", " 'Series_Complete_Janssen_18Plus': 84277,\n", " 'Series_Complete_Unk_Manuf_18Plus': 9,\n", " 'Series_Complete_Moderna_65Plus': 258737,\n", " 'Series_Complete_Pfizer_65Plus': 311984,\n", " 'Series_Complete_Janssen_65Plus': 39172,\n", " 'Series_Complete_Unk_Manuf_65Plus': 5,\n", " 'Series_Complete_Yes': 1256616,\n", " 'Series_Complete_Pop_Pct': 18.2,\n", " 'Series_Complete_18Plus': 1254225,\n", " 'Series_Complete_18PlusPop_Pct': 22.6,\n", " 'Series_Complete_65Plus': 609898,\n", " 'Series_Complete_65PlusPop_Pct': 52.2},\n", " {'Date': '2021-03-29',\n", " 'Location': 'MD',\n", " 'ShortName': 'MDA',\n", " 'LongName': 'Maryland',\n", " 'Census2019': 6045680,\n", " 'date_type': 'Report',\n", " 'Doses_Distributed': 3335590,\n", " 'Doses_Administered': 2681526,\n", " 'Dist_Per_100K': 55173,\n", " 'Admin_Per_100K': 44354,\n", " 'Administered_Moderna': 1277347,\n", " 'Administered_Pfizer': 1331547,\n", " 'Administered_Janssen': 70971,\n", " 'Administered_Unk_Manuf': 1661,\n", " 'Administered_Dose1_Recip': 1813685,\n", " 'Administered_Dose1_Pop_Pct': 30.0,\n", " 'Administered_Dose2_Pop_Pct': 15.1,\n", " 'Administered_Dose1_Recip_18Plus': 1808398,\n", " 'Administered_Dose1_Recip_18PlusPop_Pct': 38.4,\n", " 'Administered_18Plus': 2675194,\n", " 'Admin_Per_100k_18Plus': 56786,\n", " 'Distributed_Per_100k_18Plus': 70804,\n", " 'Administered_Dose1_Recip_65Plus': 712281,\n", " 'Administered_Dose1_Recip_65PlusPop_Pct': 74.2,\n", " 'Administered_65Plus': 1102694,\n", " 'Admin_Per_100k_65Plus': 114936,\n", " 'Distributed_Per_100k_65Plus': 347676,\n", " 'Administered_Dose2_Recip': 910486,\n", " 'Administered_Dose2_Recip_18Plus': 909490,\n", " 'Administered_Dose2_Recip_18PlusPop_Pct': 19.3,\n", " 'Distributed_Moderna': 1559000,\n", " 'Distributed_Pfizer': 1692990,\n", " 'Distributed_Janssen': 83600,\n", " 'Distributed_Unk_Manuf': 0,\n", " 'Series_Complete_Moderna': 439139,\n", " 'Series_Complete_Pfizer': 470888,\n", " 'Series_Complete_Janssen': 69911,\n", " 'Series_Complete_Unk_Manuf': 459,\n", " 'Series_Complete_Moderna_18Plus': 439092,\n", " 'Series_Complete_Pfizer_18Plus': 469939,\n", " 'Series_Complete_Janssen_18Plus': 69895,\n", " 'Series_Complete_Unk_Manuf_18Plus': 459,\n", " 'Series_Complete_Moderna_65Plus': 201938,\n", " 'Series_Complete_Pfizer_65Plus': 206492,\n", " 'Series_Complete_Janssen_65Plus': 25471,\n", " 'Series_Complete_Unk_Manuf_65Plus': 219,\n", " 'Series_Complete_Yes': 980397,\n", " 'Series_Complete_Pop_Pct': 16.2,\n", " 'Series_Complete_18Plus': 979385,\n", " 'Series_Complete_18PlusPop_Pct': 20.8,\n", " 'Series_Complete_65Plus': 434120,\n", " 'Series_Complete_65PlusPop_Pct': 45.2},\n", " {'Date': '2021-03-29',\n", " 'Location': 'ME',\n", " 'ShortName': 'MEA',\n", " 'LongName': 'Maine',\n", " 'Census2019': 1344212,\n", " 'date_type': 'Report',\n", " 'Doses_Distributed': 791220,\n", " 'Doses_Administered': 683925,\n", " 'Dist_Per_100K': 58861,\n", " 'Admin_Per_100K': 50879,\n", " 'Administered_Moderna': 331840,\n", " 'Administered_Pfizer': 330400,\n", " 'Administered_Janssen': 21630,\n", " 'Administered_Unk_Manuf': 55,\n", " 'Administered_Dose1_Recip': 452561,\n", " 'Administered_Dose1_Pop_Pct': 33.7,\n", " 'Administered_Dose2_Pop_Pct': 17.7,\n", " 'Administered_Dose1_Recip_18Plus': 452172,\n", " 'Administered_Dose1_Recip_18PlusPop_Pct': 41.3,\n", " 'Administered_18Plus': 683340,\n", " 'Admin_Per_100k_18Plus': 62384,\n", " 'Distributed_Per_100k_18Plus': 72233,\n", " 'Administered_Dose1_Recip_65Plus': 235336,\n", " 'Administered_Dose1_Recip_65PlusPop_Pct': 82.5,\n", " 'Administered_65Plus': 379194,\n", " 'Admin_Per_100k_65Plus': 132927,\n", " 'Distributed_Per_100k_65Plus': 277363,\n", " 'Administered_Dose2_Recip': 237603,\n", " 'Administered_Dose2_Recip_18Plus': 237390,\n", " 'Administered_Dose2_Recip_18PlusPop_Pct': 21.7,\n", " 'Distributed_Moderna': 397700,\n", " 'Distributed_Pfizer': 365820,\n", " 'Distributed_Janssen': 27700,\n", " 'Distributed_Unk_Manuf': 0,\n", " 'Series_Complete_Moderna': 117342,\n", " 'Series_Complete_Pfizer': 120245,\n", " 'Series_Complete_Janssen': 21726,\n", " 'Series_Complete_Unk_Manuf': 16,\n", " 'Series_Complete_Moderna_18Plus': 117320,\n", " 'Series_Complete_Pfizer_18Plus': 120054,\n", " 'Series_Complete_Janssen_18Plus': 21722,\n", " 'Series_Complete_Unk_Manuf_18Plus': 16,\n", " 'Series_Complete_Moderna_65Plus': 65460,\n", " 'Series_Complete_Pfizer_65Plus': 80527,\n", " 'Series_Complete_Janssen_65Plus': 10769,\n", " 'Series_Complete_Unk_Manuf_65Plus': 7,\n", " 'Series_Complete_Yes': 259329,\n", " 'Series_Complete_Pop_Pct': 19.3,\n", " 'Series_Complete_18Plus': 259112,\n", " 'Series_Complete_18PlusPop_Pct': 23.7,\n", " 'Series_Complete_65Plus': 156763,\n", " 'Series_Complete_65PlusPop_Pct': 55.0},\n", " {'Date': '2021-03-29',\n", " 'Location': 'MH',\n", " 'ShortName': 'MHA',\n", " 'LongName': 'Marshall Islands',\n", " 'Census2019': 58413,\n", " 'date_type': 'Report',\n", " 'Doses_Distributed': 35800,\n", " 'Doses_Administered': 20342,\n", " 'Dist_Per_100K': 61288,\n", " 'Admin_Per_100K': 34824,\n", " 'Administered_Moderna': 20342,\n", " 'Administered_Pfizer': 0,\n", " 'Administered_Janssen': 0,\n", " 'Administered_Unk_Manuf': 0,\n", " 'Administered_Dose1_Recip': 12452,\n", " 'Administered_Dose1_Pop_Pct': 21.3,\n", " 'Administered_Dose2_Pop_Pct': 13.4,\n", " 'Administered_Dose1_Recip_18Plus': 12421,\n", " 'Administered_Dose1_Recip_18PlusPop_Pct': 27.3,\n", " 'Administered_18Plus': 20308,\n", " 'Admin_Per_100k_18Plus': 44572,\n", " 'Distributed_Per_100k_18Plus': 78574,\n", " 'Administered_Dose1_Recip_65Plus': 831,\n", " 'Administered_Dose1_Recip_65PlusPop_Pct': 8.4,\n", " 'Administered_65Plus': 1388,\n", " 'Admin_Per_100k_65Plus': 13978,\n", " 'Distributed_Per_100k_65Plus': 360524,\n", " 'Administered_Dose2_Recip': 7839,\n", " 'Administered_Dose2_Recip_18Plus': 7834,\n", " 'Administered_Dose2_Recip_18PlusPop_Pct': 17.2,\n", " 'Distributed_Moderna': 35000,\n", " 'Distributed_Pfizer': 0,\n", " 'Distributed_Janssen': 800,\n", " 'Distributed_Unk_Manuf': 0,\n", " 'Series_Complete_Moderna': 7837,\n", " 'Series_Complete_Pfizer': 2,\n", " 'Series_Complete_Janssen': 2,\n", " 'Series_Complete_Unk_Manuf': 0,\n", " 'Series_Complete_Moderna_18Plus': 7832,\n", " 'Series_Complete_Pfizer_18Plus': 2,\n", " 'Series_Complete_Janssen_18Plus': 2,\n", " 'Series_Complete_Unk_Manuf_18Plus': 0,\n", " 'Series_Complete_Moderna_65Plus': 555,\n", " 'Series_Complete_Pfizer_65Plus': 0,\n", " 'Series_Complete_Janssen_65Plus': 2,\n", " 'Series_Complete_Unk_Manuf_65Plus': 0,\n", " 'Series_Complete_Yes': 7841,\n", " 'Series_Complete_Pop_Pct': 13.4,\n", " 'Series_Complete_18Plus': 7836,\n", " 'Series_Complete_18PlusPop_Pct': 17.2,\n", " 'Series_Complete_65Plus': 557,\n", " 'Series_Complete_65PlusPop_Pct': 5.6},\n", " {'Date': '2021-03-29',\n", " 'Location': 'MI',\n", " 'ShortName': 'MIA',\n", " 'LongName': 'Michigan',\n", " 'Census2019': 9986857,\n", " 'date_type': 'Report',\n", " 'Doses_Distributed': 5249380,\n", " 'Doses_Administered': 4295979,\n", " 'Dist_Per_100K': 52563,\n", " 'Admin_Per_100K': 43016,\n", " 'Administered_Moderna': 2027891,\n", " 'Administered_Pfizer': 2182870,\n", " 'Administered_Janssen': 85218,\n", " 'Administered_Unk_Manuf': 0,\n", " 'Administered_Dose1_Recip': 2779143,\n", " 'Administered_Dose1_Pop_Pct': 27.8,\n", " 'Administered_Dose2_Pop_Pct': 15.6,\n", " 'Administered_Dose1_Recip_18Plus': 2773734,\n", " 'Administered_Dose1_Recip_18PlusPop_Pct': 35.4,\n", " 'Administered_18Plus': 4289823,\n", " 'Admin_Per_100k_18Plus': 54697,\n", " 'Distributed_Per_100k_18Plus': 66931,\n", " 'Administered_Dose1_Recip_65Plus': 1243133,\n", " 'Administered_Dose1_Recip_65PlusPop_Pct': 70.4,\n", " 'Administered_65Plus': 2095705,\n", " 'Admin_Per_100k_65Plus': 118710,\n", " 'Distributed_Per_100k_65Plus': 297348,\n", " 'Administered_Dose2_Recip': 1561771,\n", " 'Administered_Dose2_Recip_18Plus': 1560894,\n", " 'Administered_Dose2_Recip_18PlusPop_Pct': 19.9,\n", " 'Distributed_Moderna': 2511200,\n", " 'Distributed_Pfizer': 2594280,\n", " 'Distributed_Janssen': 143900,\n", " 'Distributed_Unk_Manuf': 0,\n", " 'Series_Complete_Moderna': 701702,\n", " 'Series_Complete_Pfizer': 860000,\n", " 'Series_Complete_Janssen': 86179,\n", " 'Series_Complete_Unk_Manuf': 69,\n", " 'Series_Complete_Moderna_18Plus': 701622,\n", " 'Series_Complete_Pfizer_18Plus': 859203,\n", " 'Series_Complete_Janssen_18Plus': 86138,\n", " 'Series_Complete_Unk_Manuf_18Plus': 69,\n", " 'Series_Complete_Moderna_65Plus': 416945,\n", " 'Series_Complete_Pfizer_65Plus': 462389,\n", " 'Series_Complete_Janssen_65Plus': 23079,\n", " 'Series_Complete_Unk_Manuf_65Plus': 56,\n", " 'Series_Complete_Yes': 1647950,\n", " 'Series_Complete_Pop_Pct': 16.5,\n", " 'Series_Complete_18Plus': 1647032,\n", " 'Series_Complete_18PlusPop_Pct': 21.0,\n", " 'Series_Complete_65Plus': 902469,\n", " 'Series_Complete_65PlusPop_Pct': 51.1},\n", " {'Date': '2021-03-29',\n", " 'Location': 'MN',\n", " 'ShortName': 'MNA',\n", " 'LongName': 'Minnesota',\n", " 'Census2019': 5639632,\n", " 'date_type': 'Report',\n", " 'Doses_Distributed': 2907150,\n", " 'Doses_Administered': 2665779,\n", " 'Dist_Per_100K': 51549,\n", " 'Admin_Per_100K': 47269,\n", " 'Administered_Moderna': 1233947,\n", " 'Administered_Pfizer': 1369964,\n", " 'Administered_Janssen': 61671,\n", " 'Administered_Unk_Manuf': 197,\n", " 'Administered_Dose1_Recip': 1722919,\n", " 'Administered_Dose1_Pop_Pct': 30.6,\n", " 'Administered_Dose2_Pop_Pct': 17.0,\n", " 'Administered_Dose1_Recip_18Plus': 1717742,\n", " 'Administered_Dose1_Recip_18PlusPop_Pct': 39.6,\n", " 'Administered_18Plus': 2659722,\n", " 'Admin_Per_100k_18Plus': 61334,\n", " 'Distributed_Per_100k_18Plus': 67039,\n", " 'Administered_Dose1_Recip_65Plus': 749850,\n", " 'Administered_Dose1_Recip_65PlusPop_Pct': 81.5,\n", " 'Administered_65Plus': 1245072,\n", " 'Admin_Per_100k_65Plus': 135278,\n", " 'Distributed_Per_100k_65Plus': 315863,\n", " 'Administered_Dose2_Recip': 955987,\n", " 'Administered_Dose2_Recip_18Plus': 955060,\n", " 'Administered_Dose2_Recip_18PlusPop_Pct': 22.0,\n", " 'Distributed_Moderna': 1400000,\n", " 'Distributed_Pfizer': 1429350,\n", " 'Distributed_Janssen': 77800,\n", " 'Distributed_Unk_Manuf': 0,\n", " 'Series_Complete_Moderna': 431948,\n", " 'Series_Complete_Pfizer': 523992,\n", " 'Series_Complete_Janssen': 62120,\n", " 'Series_Complete_Unk_Manuf': 47,\n", " 'Series_Complete_Moderna_18Plus': 431904,\n", " 'Series_Complete_Pfizer_18Plus': 523109,\n", " 'Series_Complete_Janssen_18Plus': 62100,\n", " 'Series_Complete_Unk_Manuf_18Plus': 47,\n", " 'Series_Complete_Moderna_65Plus': 212980,\n", " 'Series_Complete_Pfizer_65Plus': 299042,\n", " 'Series_Complete_Janssen_65Plus': 29903,\n", " 'Series_Complete_Unk_Manuf_65Plus': 19,\n", " 'Series_Complete_Yes': 1018107,\n", " 'Series_Complete_Pop_Pct': 18.1,\n", " 'Series_Complete_18Plus': 1017160,\n", " 'Series_Complete_18PlusPop_Pct': 23.5,\n", " 'Series_Complete_65Plus': 541944,\n", " 'Series_Complete_65PlusPop_Pct': 58.9},\n", " {'Date': '2021-03-29',\n", " 'Location': 'MO',\n", " 'ShortName': 'MOA',\n", " 'LongName': 'Missouri',\n", " 'Census2019': 6137428,\n", " 'date_type': 'Report',\n", " 'Doses_Distributed': 3256125,\n", " 'Doses_Administered': 2464910,\n", " 'Dist_Per_100K': 53054,\n", " 'Admin_Per_100K': 40162,\n", " 'Administered_Moderna': 1024686,\n", " 'Administered_Pfizer': 1394907,\n", " 'Administered_Janssen': 45000,\n", " 'Administered_Unk_Manuf': 317,\n", " 'Administered_Dose1_Recip': 1544780,\n", " 'Administered_Dose1_Pop_Pct': 25.2,\n", " 'Administered_Dose2_Pop_Pct': 13.7,\n", " 'Administered_Dose1_Recip_18Plus': 1542104,\n", " 'Administered_Dose1_Recip_18PlusPop_Pct': 32.4,\n", " 'Administered_18Plus': 2461424,\n", " 'Admin_Per_100k_18Plus': 51636,\n", " 'Distributed_Per_100k_18Plus': 68308,\n", " 'Administered_Dose1_Recip_65Plus': 702137,\n", " 'Administered_Dose1_Recip_65PlusPop_Pct': 66.1,\n", " 'Administered_65Plus': 1181257,\n", " 'Admin_Per_100k_65Plus': 111226,\n", " 'Distributed_Per_100k_65Plus': 306592,\n", " 'Administered_Dose2_Recip': 842467,\n", " 'Administered_Dose2_Recip_18Plus': 841848,\n", " 'Administered_Dose2_Recip_18PlusPop_Pct': 17.7,\n", " 'Distributed_Moderna': 1504700,\n", " 'Distributed_Pfizer': 1664325,\n", " 'Distributed_Janssen': 87100,\n", " 'Distributed_Unk_Manuf': 0,\n", " 'Series_Complete_Moderna': 339306,\n", " 'Series_Complete_Pfizer': 503121,\n", " 'Series_Complete_Janssen': 46333,\n", " 'Series_Complete_Unk_Manuf': 40,\n", " 'Series_Complete_Moderna_18Plus': 339266,\n", " 'Series_Complete_Pfizer_18Plus': 502543,\n", " 'Series_Complete_Janssen_18Plus': 46313,\n", " 'Series_Complete_Unk_Manuf_18Plus': 39,\n", " 'Series_Complete_Moderna_65Plus': 199101,\n", " 'Series_Complete_Pfizer_65Plus': 243317,\n", " 'Series_Complete_Janssen_65Plus': 13975,\n", " 'Series_Complete_Unk_Manuf_65Plus': 18,\n", " 'Series_Complete_Yes': 888800,\n", " 'Series_Complete_Pop_Pct': 14.5,\n", " 'Series_Complete_18Plus': 888161,\n", " 'Series_Complete_18PlusPop_Pct': 18.6,\n", " 'Series_Complete_65Plus': 456411,\n", " 'Series_Complete_65PlusPop_Pct': 43.0},\n", " {'Date': '2021-03-29',\n", " 'Location': 'MP',\n", " 'ShortName': 'MPA',\n", " 'LongName': 'Northern Mariana Islands',\n", " 'Census2019': 56882,\n", " 'date_type': 'Report',\n", " 'Doses_Distributed': 44210,\n", " 'Doses_Administered': 27787,\n", " 'Dist_Per_100K': 77722,\n", " 'Admin_Per_100K': 48850,\n", " 'Administered_Moderna': 3829,\n", " 'Administered_Pfizer': 23924,\n", " 'Administered_Janssen': 34,\n", " 'Administered_Unk_Manuf': 0,\n", " 'Administered_Dose1_Recip': 16121,\n", " 'Administered_Dose1_Pop_Pct': 28.3,\n", " 'Administered_Dose2_Pop_Pct': 20.5,\n", " 'Administered_Dose1_Recip_18Plus': 16043,\n", " 'Administered_Dose1_Recip_18PlusPop_Pct': 36.2,\n", " 'Administered_18Plus': 27697,\n", " 'Admin_Per_100k_18Plus': 62426,\n", " 'Distributed_Per_100k_18Plus': 99644,\n", " 'Administered_Dose1_Recip_65Plus': 2252,\n", " 'Administered_Dose1_Recip_65PlusPop_Pct': 23.3,\n", " 'Administered_65Plus': 4280,\n", " 'Admin_Per_100k_65Plus': 44261,\n", " 'Distributed_Per_100k_65Plus': 457187,\n", " 'Administered_Dose2_Recip': 11650,\n", " 'Administered_Dose2_Recip_18Plus': 11638,\n", " 'Administered_Dose2_Recip_18PlusPop_Pct': 26.2,\n", " 'Distributed_Moderna': 12800,\n", " 'Distributed_Pfizer': 30810,\n", " 'Distributed_Janssen': 600,\n", " 'Distributed_Unk_Manuf': 0,\n", " 'Series_Complete_Moderna': 1540,\n", " 'Series_Complete_Pfizer': 10110,\n", " 'Series_Complete_Janssen': 35,\n", " 'Series_Complete_Unk_Manuf': 0,\n", " 'Series_Complete_Moderna_18Plus': 1540,\n", " 'Series_Complete_Pfizer_18Plus': 10098,\n", " 'Series_Complete_Janssen_18Plus': 35,\n", " 'Series_Complete_Unk_Manuf_18Plus': 0,\n", " 'Series_Complete_Moderna_65Plus': 298,\n", " 'Series_Complete_Pfizer_65Plus': 1728,\n", " 'Series_Complete_Janssen_65Plus': 31,\n", " 'Series_Complete_Unk_Manuf_65Plus': 0,\n", " 'Series_Complete_Yes': 11685,\n", " 'Series_Complete_Pop_Pct': 20.5,\n", " 'Series_Complete_18Plus': 11673,\n", " 'Series_Complete_18PlusPop_Pct': 26.3,\n", " 'Series_Complete_65Plus': 2057,\n", " 'Series_Complete_65PlusPop_Pct': 21.3},\n", " {'Date': '2021-03-29',\n", " 'Location': 'MS',\n", " 'ShortName': 'MSA',\n", " 'LongName': 'Mississippi',\n", " 'Census2019': 2976149,\n", " 'date_type': 'Report',\n", " 'Doses_Distributed': 1614655,\n", " 'Doses_Administered': 1134229,\n", " 'Dist_Per_100K': 54253,\n", " 'Admin_Per_100K': 38111,\n", " 'Administered_Moderna': 575124,\n", " 'Administered_Pfizer': 531157,\n", " 'Administered_Janssen': 27218,\n", " 'Administered_Unk_Manuf': 730,\n", " 'Administered_Dose1_Recip': 722545,\n", " 'Administered_Dose1_Pop_Pct': 24.3,\n", " 'Administered_Dose2_Pop_Pct': 13.8,\n", " 'Administered_Dose1_Recip_18Plus': 720906,\n", " 'Administered_Dose1_Recip_18PlusPop_Pct': 31.7,\n", " 'Administered_18Plus': 1132394,\n", " 'Admin_Per_100k_18Plus': 49719,\n", " 'Distributed_Per_100k_18Plus': 70894,\n", " 'Administered_Dose1_Recip_65Plus': 315852,\n", " 'Administered_Dose1_Recip_65PlusPop_Pct': 64.9,\n", " 'Administered_65Plus': 530841,\n", " 'Admin_Per_100k_65Plus': 109071,\n", " 'Distributed_Per_100k_65Plus': 331760,\n", " 'Administered_Dose2_Recip': 411258,\n", " 'Administered_Dose2_Recip_18Plus': 411082,\n", " 'Administered_Dose2_Recip_18PlusPop_Pct': 18.0,\n", " 'Distributed_Moderna': 801500,\n", " 'Distributed_Pfizer': 770055,\n", " 'Distributed_Janssen': 43100,\n", " 'Distributed_Unk_Manuf': 0,\n", " 'Series_Complete_Moderna': 209799,\n", " 'Series_Complete_Pfizer': 201446,\n", " 'Series_Complete_Janssen': 26537,\n", " 'Series_Complete_Unk_Manuf': 13,\n", " 'Series_Complete_Moderna_18Plus': 209775,\n", " 'Series_Complete_Pfizer_18Plus': 201294,\n", " 'Series_Complete_Janssen_18Plus': 26522,\n", " 'Series_Complete_Unk_Manuf_18Plus': 13,\n", " 'Series_Complete_Moderna_65Plus': 118710,\n", " 'Series_Complete_Pfizer_65Plus': 101303,\n", " 'Series_Complete_Janssen_65Plus': 7802,\n", " 'Series_Complete_Unk_Manuf_65Plus': 4,\n", " 'Series_Complete_Yes': 437795,\n", " 'Series_Complete_Pop_Pct': 14.7,\n", " 'Series_Complete_18Plus': 437604,\n", " 'Series_Complete_18PlusPop_Pct': 19.2,\n", " 'Series_Complete_65Plus': 227819,\n", " 'Series_Complete_65PlusPop_Pct': 46.8},\n", " {'Date': '2021-03-29',\n", " 'Location': 'MT',\n", " 'ShortName': 'MTA',\n", " 'LongName': 'Montana',\n", " 'Census2019': 1068778,\n", " 'date_type': 'Report',\n", " 'Doses_Distributed': 632625,\n", " 'Doses_Administered': 502390,\n", " 'Dist_Per_100K': 59191,\n", " 'Admin_Per_100K': 47006,\n", " 'Administered_Moderna': 261507,\n", " 'Administered_Pfizer': 231591,\n", " 'Administered_Janssen': 9168,\n", " 'Administered_Unk_Manuf': 124,\n", " 'Administered_Dose1_Recip': 317475,\n", " 'Administered_Dose1_Pop_Pct': 29.7,\n", " 'Administered_Dose2_Pop_Pct': 17.4,\n", " 'Administered_Dose1_Recip_18Plus': 316077,\n", " 'Administered_Dose1_Recip_18PlusPop_Pct': 37.6,\n", " 'Administered_18Plus': 500570,\n", " 'Admin_Per_100k_18Plus': 59578,\n", " 'Distributed_Per_100k_18Plus': 75295,\n", " 'Administered_Dose1_Recip_65Plus': 144683,\n", " 'Administered_Dose1_Recip_65PlusPop_Pct': 70.1,\n", " 'Administered_65Plus': 244372,\n", " 'Admin_Per_100k_65Plus': 118376,\n", " 'Distributed_Per_100k_65Plus': 306449,\n", " 'Administered_Dose2_Recip': 185627,\n", " 'Administered_Dose2_Recip_18Plus': 185223,\n", " 'Administered_Dose2_Recip_18PlusPop_Pct': 22.0,\n", " 'Distributed_Moderna': 320700,\n", " 'Distributed_Pfizer': 295425,\n", " 'Distributed_Janssen': 16500,\n", " 'Distributed_Unk_Manuf': 0,\n", " 'Series_Complete_Moderna': 98542,\n", " 'Series_Complete_Pfizer': 87051,\n", " 'Series_Complete_Janssen': 9111,\n", " 'Series_Complete_Unk_Manuf': 34,\n", " 'Series_Complete_Moderna_18Plus': 98521,\n", " 'Series_Complete_Pfizer_18Plus': 86668,\n", " 'Series_Complete_Janssen_18Plus': 9106,\n", " 'Series_Complete_Unk_Manuf_18Plus': 34,\n", " 'Series_Complete_Moderna_65Plus': 51148,\n", " 'Series_Complete_Pfizer_65Plus': 50228,\n", " 'Series_Complete_Janssen_65Plus': 2791,\n", " 'Series_Complete_Unk_Manuf_65Plus': 19,\n", " 'Series_Complete_Yes': 194738,\n", " 'Series_Complete_Pop_Pct': 18.2,\n", " 'Series_Complete_18Plus': 194329,\n", " 'Series_Complete_18PlusPop_Pct': 23.1,\n", " 'Series_Complete_65Plus': 104186,\n", " 'Series_Complete_65PlusPop_Pct': 50.5},\n", " {'Date': '2021-03-29',\n", " 'Location': 'NC',\n", " 'ShortName': 'NCA',\n", " 'LongName': 'North Carolina',\n", " 'Census2019': 10488084,\n", " 'date_type': 'Report',\n", " 'Doses_Distributed': 5680940,\n", " 'Doses_Administered': 4596429,\n", " 'Dist_Per_100K': 54166,\n", " 'Admin_Per_100K': 43825,\n", " 'Administered_Moderna': 1967790,\n", " 'Administered_Pfizer': 2508712,\n", " 'Administered_Janssen': 119598,\n", " 'Administered_Unk_Manuf': 329,\n", " 'Administered_Dose1_Recip': 2974973,\n", " 'Administered_Dose1_Pop_Pct': 28.4,\n", " 'Administered_Dose2_Pop_Pct': 14.9,\n", " 'Administered_Dose1_Recip_18Plus': 2960120,\n", " 'Administered_Dose1_Recip_18PlusPop_Pct': 36.2,\n", " 'Administered_18Plus': 4580024,\n", " 'Admin_Per_100k_18Plus': 55940,\n", " 'Distributed_Per_100k_18Plus': 69387,\n", " 'Administered_Dose1_Recip_65Plus': 1247929,\n", " 'Administered_Dose1_Recip_65PlusPop_Pct': 71.3,\n", " 'Administered_65Plus': 2264567,\n", " 'Admin_Per_100k_65Plus': 129323,\n", " 'Distributed_Per_100k_65Plus': 324422,\n", " 'Administered_Dose2_Recip': 1560978,\n", " 'Administered_Dose2_Recip_18Plus': 1559471,\n", " 'Administered_Dose2_Recip_18PlusPop_Pct': 19.0,\n", " 'Distributed_Moderna': 2622200,\n", " 'Distributed_Pfizer': 2911740,\n", " 'Distributed_Janssen': 147000,\n", " 'Distributed_Unk_Manuf': 0,\n", " 'Series_Complete_Moderna': 648619,\n", " 'Series_Complete_Pfizer': 912333,\n", " 'Series_Complete_Janssen': 117704,\n", " 'Series_Complete_Unk_Manuf': 26,\n", " 'Series_Complete_Moderna_18Plus': 648474,\n", " 'Series_Complete_Pfizer_18Plus': 910971,\n", " 'Series_Complete_Janssen_18Plus': 117473,\n", " 'Series_Complete_Unk_Manuf_18Plus': 26,\n", " 'Series_Complete_Moderna_65Plus': 453642,\n", " 'Series_Complete_Pfizer_65Plus': 517852,\n", " 'Series_Complete_Janssen_65Plus': 16633,\n", " 'Series_Complete_Unk_Manuf_65Plus': 20,\n", " 'Series_Complete_Yes': 1678682,\n", " 'Series_Complete_Pop_Pct': 16.0,\n", " 'Series_Complete_18Plus': 1676944,\n", " 'Series_Complete_18PlusPop_Pct': 20.5,\n", " 'Series_Complete_65Plus': 988147,\n", " 'Series_Complete_65PlusPop_Pct': 56.4},\n", " {'Date': '2021-03-29',\n", " 'Location': 'ND',\n", " 'ShortName': 'NDA',\n", " 'LongName': 'North Dakota',\n", " 'Census2019': 762062,\n", " 'date_type': 'Report',\n", " 'Doses_Distributed': 437720,\n", " 'Doses_Administered': 401626,\n", " 'Dist_Per_100K': 57439,\n", " 'Admin_Per_100K': 52703,\n", " 'Administered_Moderna': 188728,\n", " 'Administered_Pfizer': 204796,\n", " 'Administered_Janssen': 8102,\n", " 'Administered_Unk_Manuf': 0,\n", " 'Administered_Dose1_Recip': 237354,\n", " 'Administered_Dose1_Pop_Pct': 31.1,\n", " 'Administered_Dose2_Pop_Pct': 19.0,\n", " 'Administered_Dose1_Recip_18Plus': 236233,\n", " 'Administered_Dose1_Recip_18PlusPop_Pct': 40.6,\n", " 'Administered_18Plus': 400110,\n", " 'Admin_Per_100k_18Plus': 68760,\n", " 'Distributed_Per_100k_18Plus': 75224,\n", " 'Administered_Dose1_Recip_65Plus': 91802,\n", " 'Administered_Dose1_Recip_65PlusPop_Pct': 76.6,\n", " 'Administered_65Plus': 173344,\n", " 'Admin_Per_100k_65Plus': 144640,\n", " 'Distributed_Per_100k_65Plus': 365238,\n", " 'Administered_Dose2_Recip': 144591,\n", " 'Administered_Dose2_Recip_18Plus': 144292,\n", " 'Administered_Dose2_Recip_18PlusPop_Pct': 24.8,\n", " 'Distributed_Moderna': 216500,\n", " 'Distributed_Pfizer': 209820,\n", " 'Distributed_Janssen': 11400,\n", " 'Distributed_Unk_Manuf': 0,\n", " 'Series_Complete_Moderna': 69526,\n", " 'Series_Complete_Pfizer': 75065,\n", " 'Series_Complete_Janssen': 7393,\n", " 'Series_Complete_Unk_Manuf': 0,\n", " 'Series_Complete_Moderna_18Plus': 69503,\n", " 'Series_Complete_Pfizer_18Plus': 74789,\n", " 'Series_Complete_Janssen_18Plus': 7381,\n", " 'Series_Complete_Unk_Manuf_18Plus': 0,\n", " 'Series_Complete_Moderna_65Plus': 36915,\n", " 'Series_Complete_Pfizer_65Plus': 36917,\n", " 'Series_Complete_Janssen_65Plus': 1363,\n", " 'Series_Complete_Unk_Manuf_65Plus': 0,\n", " 'Series_Complete_Yes': 151984,\n", " 'Series_Complete_Pop_Pct': 19.9,\n", " 'Series_Complete_18Plus': 151673,\n", " 'Series_Complete_18PlusPop_Pct': 26.1,\n", " 'Series_Complete_65Plus': 75195,\n", " 'Series_Complete_65PlusPop_Pct': 62.7},\n", " {'Date': '2021-03-29',\n", " 'Location': 'NE',\n", " 'ShortName': 'NEA',\n", " 'LongName': 'Nebraska',\n", " 'Census2019': 1934408,\n", " 'date_type': 'Report',\n", " 'Doses_Distributed': 1072470,\n", " 'Doses_Administered': 900049,\n", " 'Dist_Per_100K': 55442,\n", " 'Admin_Per_100K': 46528,\n", " 'Administered_Moderna': 420092,\n", " 'Administered_Pfizer': 456463,\n", " 'Administered_Janssen': 21733,\n", " 'Administered_Unk_Manuf': 1761,\n", " 'Administered_Dose1_Recip': 578881,\n", " 'Administered_Dose1_Pop_Pct': 29.9,\n", " 'Administered_Dose2_Pop_Pct': 16.3,\n", " 'Administered_Dose1_Recip_18Plus': 577238,\n", " 'Administered_Dose1_Recip_18PlusPop_Pct': 39.6,\n", " 'Administered_18Plus': 897954,\n", " 'Admin_Per_100k_18Plus': 61574,\n", " 'Distributed_Per_100k_18Plus': 73541,\n", " 'Administered_Dose1_Recip_65Plus': 243484,\n", " 'Administered_Dose1_Recip_65PlusPop_Pct': 77.9,\n", " 'Administered_65Plus': 419367,\n", " 'Admin_Per_100k_65Plus': 134215,\n", " 'Distributed_Per_100k_65Plus': 343237,\n", " 'Administered_Dose2_Recip': 314782,\n", " 'Administered_Dose2_Recip_18Plus': 314320,\n", " 'Administered_Dose2_Recip_18PlusPop_Pct': 21.6,\n", " 'Distributed_Moderna': 505200,\n", " 'Distributed_Pfizer': 535470,\n", " 'Distributed_Janssen': 31800,\n", " 'Distributed_Unk_Manuf': 0,\n", " 'Series_Complete_Moderna': 151212,\n", " 'Series_Complete_Pfizer': 163088,\n", " 'Series_Complete_Janssen': 22392,\n", " 'Series_Complete_Unk_Manuf': 482,\n", " 'Series_Complete_Moderna_18Plus': 151181,\n", " 'Series_Complete_Pfizer_18Plus': 162657,\n", " 'Series_Complete_Janssen_18Plus': 22386,\n", " 'Series_Complete_Unk_Manuf_18Plus': 482,\n", " 'Series_Complete_Moderna_65Plus': 79896,\n", " 'Series_Complete_Pfizer_65Plus': 91181,\n", " 'Series_Complete_Janssen_65Plus': 1795,\n", " 'Series_Complete_Unk_Manuf_65Plus': 379,\n", " 'Series_Complete_Yes': 337174,\n", " 'Series_Complete_Pop_Pct': 17.4,\n", " 'Series_Complete_18Plus': 336706,\n", " 'Series_Complete_18PlusPop_Pct': 23.1,\n", " 'Series_Complete_65Plus': 173251,\n", " 'Series_Complete_65PlusPop_Pct': 55.4},\n", " {'Date': '2021-03-29',\n", " 'Location': 'NH',\n", " 'ShortName': 'NHA',\n", " 'LongName': 'New Hampshire',\n", " 'Census2019': 1359711,\n", " 'date_type': 'Report',\n", " 'Doses_Distributed': 743355,\n", " 'Doses_Administered': 602562,\n", " 'Dist_Per_100K': 54670,\n", " 'Admin_Per_100K': 44315,\n", " 'Administered_Moderna': 318174,\n", " 'Administered_Pfizer': 269541,\n", " 'Administered_Janssen': 14820,\n", " 'Administered_Unk_Manuf': 27,\n", " 'Administered_Dose1_Recip': 410366,\n", " 'Administered_Dose1_Pop_Pct': 30.2,\n", " 'Administered_Dose2_Pop_Pct': 15.8,\n", " 'Administered_Dose1_Recip_18Plus': 409094,\n", " 'Administered_Dose1_Recip_18PlusPop_Pct': 37.0,\n", " 'Administered_18Plus': 600868,\n", " 'Admin_Per_100k_18Plus': 54404,\n", " 'Distributed_Per_100k_18Plus': 67305,\n", " 'Administered_Dose1_Recip_65Plus': 209648,\n", " 'Administered_Dose1_Recip_65PlusPop_Pct': 82.6,\n", " 'Administered_65Plus': 312357,\n", " 'Admin_Per_100k_65Plus': 123041,\n", " 'Distributed_Per_100k_65Plus': 292816,\n", " 'Administered_Dose2_Recip': 215432,\n", " 'Administered_Dose2_Recip_18Plus': 215039,\n", " 'Administered_Dose2_Recip_18PlusPop_Pct': 19.5,\n", " 'Distributed_Moderna': 369200,\n", " 'Distributed_Pfizer': 352755,\n", " 'Distributed_Janssen': 21400,\n", " 'Distributed_Unk_Manuf': 0,\n", " 'Series_Complete_Moderna': 122659,\n", " 'Series_Complete_Pfizer': 92767,\n", " 'Series_Complete_Janssen': 15564,\n", " 'Series_Complete_Unk_Manuf': 6,\n", " 'Series_Complete_Moderna_18Plus': 122568,\n", " 'Series_Complete_Pfizer_18Plus': 92465,\n", " 'Series_Complete_Janssen_18Plus': 15549,\n", " 'Series_Complete_Unk_Manuf_18Plus': 6,\n", " 'Series_Complete_Moderna_65Plus': 59508,\n", " 'Series_Complete_Pfizer_65Plus': 53529,\n", " 'Series_Complete_Janssen_65Plus': 8675,\n", " 'Series_Complete_Unk_Manuf_65Plus': 3,\n", " 'Series_Complete_Yes': 230996,\n", " 'Series_Complete_Pop_Pct': 17.0,\n", " 'Series_Complete_18Plus': 230588,\n", " 'Series_Complete_18PlusPop_Pct': 20.9,\n", " 'Series_Complete_65Plus': 121715,\n", " 'Series_Complete_65PlusPop_Pct': 47.9},\n", " {'Date': '2021-03-29',\n", " 'Location': 'NJ',\n", " 'ShortName': 'NJA',\n", " 'LongName': 'New Jersey',\n", " 'Census2019': 8882190,\n", " 'date_type': 'Report',\n", " 'Doses_Distributed': 4794085,\n", " 'Doses_Administered': 4204062,\n", " 'Dist_Per_100K': 53974,\n", " 'Admin_Per_100K': 47331,\n", " 'Administered_Moderna': 2030039,\n", " 'Administered_Pfizer': 2081908,\n", " 'Administered_Janssen': 91640,\n", " 'Administered_Unk_Manuf': 475,\n", " 'Administered_Dose1_Recip': 2859012,\n", " 'Administered_Dose1_Pop_Pct': 32.2,\n", " 'Administered_Dose2_Pop_Pct': 16.6,\n", " 'Administered_Dose1_Recip_18Plus': 2846112,\n", " 'Administered_Dose1_Recip_18PlusPop_Pct': 41.0,\n", " 'Administered_18Plus': 4187348,\n", " 'Admin_Per_100k_18Plus': 60305,\n", " 'Distributed_Per_100k_18Plus': 69043,\n", " 'Administered_Dose1_Recip_65Plus': 1033834,\n", " 'Administered_Dose1_Recip_65PlusPop_Pct': 70.1,\n", " 'Administered_65Plus': 1616900,\n", " 'Admin_Per_100k_65Plus': 109581,\n", " 'Distributed_Per_100k_65Plus': 324905,\n", " 'Administered_Dose2_Recip': 1474851,\n", " 'Administered_Dose2_Recip_18Plus': 1470978,\n", " 'Administered_Dose2_Recip_18PlusPop_Pct': 21.2,\n", " 'Distributed_Moderna': 2271200,\n", " 'Distributed_Pfizer': 2399085,\n", " 'Distributed_Janssen': 123800,\n", " 'Distributed_Unk_Manuf': 0,\n", " 'Series_Complete_Moderna': 704308,\n", " 'Series_Complete_Pfizer': 770536,\n", " 'Series_Complete_Janssen': 91760,\n", " 'Series_Complete_Unk_Manuf': 7,\n", " 'Series_Complete_Moderna_18Plus': 704214,\n", " 'Series_Complete_Pfizer_18Plus': 766757,\n", " 'Series_Complete_Janssen_18Plus': 91736,\n", " 'Series_Complete_Unk_Manuf_18Plus': 7,\n", " 'Series_Complete_Moderna_65Plus': 292601,\n", " 'Series_Complete_Pfizer_65Plus': 330713,\n", " 'Series_Complete_Janssen_65Plus': 26511,\n", " 'Series_Complete_Unk_Manuf_65Plus': 5,\n", " 'Series_Complete_Yes': 1566611,\n", " 'Series_Complete_Pop_Pct': 17.6,\n", " 'Series_Complete_18Plus': 1562714,\n", " 'Series_Complete_18PlusPop_Pct': 22.5,\n", " 'Series_Complete_65Plus': 649830,\n", " 'Series_Complete_65PlusPop_Pct': 44.0},\n", " {'Date': '2021-03-29',\n", " 'Location': 'NM',\n", " 'ShortName': 'NMA',\n", " 'LongName': 'New Mexico',\n", " 'Census2019': 2096829,\n", " 'date_type': 'Report',\n", " 'Doses_Distributed': 1337435,\n", " 'Doses_Administered': 1239316,\n", " 'Dist_Per_100K': 63784,\n", " 'Admin_Per_100K': 59104,\n", " 'Administered_Moderna': 559459,\n", " 'Administered_Pfizer': 656089,\n", " 'Administered_Janssen': 22353,\n", " 'Administered_Unk_Manuf': 1415,\n", " 'Administered_Dose1_Recip': 785813,\n", " 'Administered_Dose1_Pop_Pct': 37.5,\n", " 'Administered_Dose2_Pop_Pct': 22.1,\n", " 'Administered_Dose1_Recip_18Plus': 778348,\n", " 'Administered_Dose1_Recip_18PlusPop_Pct': 48.0,\n", " 'Administered_18Plus': 1229597,\n", " 'Admin_Per_100k_18Plus': 75855,\n", " 'Distributed_Per_100k_18Plus': 82507,\n", " 'Administered_Dose1_Recip_65Plus': 280736,\n", " 'Administered_Dose1_Recip_65PlusPop_Pct': 74.3,\n", " 'Administered_65Plus': 458883,\n", " 'Admin_Per_100k_65Plus': 121524,\n", " 'Distributed_Per_100k_65Plus': 354188,\n", " 'Administered_Dose2_Recip': 463531,\n", " 'Administered_Dose2_Recip_18Plus': 459732,\n", " 'Administered_Dose2_Recip_18PlusPop_Pct': 28.4,\n", " 'Distributed_Moderna': 614600,\n", " 'Distributed_Pfizer': 688935,\n", " 'Distributed_Janssen': 33900,\n", " 'Distributed_Unk_Manuf': 0,\n", " 'Series_Complete_Moderna': 198259,\n", " 'Series_Complete_Pfizer': 264910,\n", " 'Series_Complete_Janssen': 21629,\n", " 'Series_Complete_Unk_Manuf': 362,\n", " 'Series_Complete_Moderna_18Plus': 198167,\n", " 'Series_Complete_Pfizer_18Plus': 261203,\n", " 'Series_Complete_Janssen_18Plus': 21594,\n", " 'Series_Complete_Unk_Manuf_18Plus': 362,\n", " 'Series_Complete_Moderna_65Plus': 84609,\n", " 'Series_Complete_Pfizer_65Plus': 98719,\n", " 'Series_Complete_Janssen_65Plus': 7862,\n", " 'Series_Complete_Unk_Manuf_65Plus': 218,\n", " 'Series_Complete_Yes': 485160,\n", " 'Series_Complete_Pop_Pct': 23.1,\n", " 'Series_Complete_18Plus': 481326,\n", " 'Series_Complete_18PlusPop_Pct': 29.7,\n", " 'Series_Complete_65Plus': 191408,\n", " 'Series_Complete_65PlusPop_Pct': 50.7},\n", " {'Date': '2021-03-29',\n", " 'Location': 'NV',\n", " 'ShortName': 'NVA',\n", " 'LongName': 'Nevada',\n", " 'Census2019': 3080156,\n", " 'date_type': 'Report',\n", " 'Doses_Distributed': 1548430,\n", " 'Doses_Administered': 1328018,\n", " 'Dist_Per_100K': 50271,\n", " 'Admin_Per_100K': 43115,\n", " 'Administered_Moderna': 577615,\n", " 'Administered_Pfizer': 721681,\n", " 'Administered_Janssen': 28722,\n", " 'Administered_Unk_Manuf': 0,\n", " 'Administered_Dose1_Recip': 842620,\n", " 'Administered_Dose1_Pop_Pct': 27.4,\n", " 'Administered_Dose2_Pop_Pct': 14.8,\n", " 'Administered_Dose1_Recip_18Plus': 841110,\n", " 'Administered_Dose1_Recip_18PlusPop_Pct': 35.2,\n", " 'Administered_18Plus': 1326173,\n", " 'Admin_Per_100k_18Plus': 55546,\n", " 'Distributed_Per_100k_18Plus': 64855,\n", " 'Administered_Dose1_Recip_65Plus': 342219,\n", " 'Administered_Dose1_Recip_65PlusPop_Pct': 69.0,\n", " 'Administered_65Plus': 590840,\n", " 'Admin_Per_100k_65Plus': 119128,\n", " 'Distributed_Per_100k_65Plus': 312201,\n", " 'Administered_Dose2_Recip': 455646,\n", " 'Administered_Dose2_Recip_18Plus': 455338,\n", " 'Administered_Dose2_Recip_18PlusPop_Pct': 19.1,\n", " 'Distributed_Moderna': 745700,\n", " 'Distributed_Pfizer': 759330,\n", " 'Distributed_Janssen': 43400,\n", " 'Distributed_Unk_Manuf': 0,\n", " 'Series_Complete_Moderna': 199836,\n", " 'Series_Complete_Pfizer': 255809,\n", " 'Series_Complete_Janssen': 28315,\n", " 'Series_Complete_Unk_Manuf': 1,\n", " 'Series_Complete_Moderna_18Plus': 199816,\n", " 'Series_Complete_Pfizer_18Plus': 255521,\n", " 'Series_Complete_Janssen_18Plus': 28312,\n", " 'Series_Complete_Unk_Manuf_18Plus': 1,\n", " 'Series_Complete_Moderna_65Plus': 107598,\n", " 'Series_Complete_Pfizer_65Plus': 125988,\n", " 'Series_Complete_Janssen_65Plus': 8442,\n", " 'Series_Complete_Unk_Manuf_65Plus': 0,\n", " 'Series_Complete_Yes': 483961,\n", " 'Series_Complete_Pop_Pct': 15.7,\n", " 'Series_Complete_18Plus': 483650,\n", " 'Series_Complete_18PlusPop_Pct': 20.3,\n", " 'Series_Complete_65Plus': 242028,\n", " 'Series_Complete_65PlusPop_Pct': 48.8},\n", " {'Date': '2021-03-29',\n", " 'Location': 'NY',\n", " 'ShortName': 'NYA',\n", " 'LongName': 'New York State',\n", " 'Census2019': 19453561,\n", " 'date_type': 'Report',\n", " 'Doses_Distributed': 11109835,\n", " 'Doses_Administered': 8862843,\n", " 'Dist_Per_100K': 57110,\n", " 'Admin_Per_100K': 45559,\n", " 'Administered_Moderna': 4102805,\n", " 'Administered_Pfizer': 4555645,\n", " 'Administered_Janssen': 203233,\n", " 'Administered_Unk_Manuf': 1160,\n", " 'Administered_Dose1_Recip': 5861761,\n", " 'Administered_Dose1_Pop_Pct': 30.1,\n", " 'Administered_Dose2_Pop_Pct': 14.8,\n", " 'Administered_Dose1_Recip_18Plus': 5845365,\n", " 'Administered_Dose1_Recip_18PlusPop_Pct': 37.9,\n", " 'Administered_18Plus': 8842212,\n", " 'Admin_Per_100k_18Plus': 57323,\n", " 'Distributed_Per_100k_18Plus': 72024,\n", " 'Administered_Dose1_Recip_65Plus': 2166574,\n", " 'Administered_Dose1_Recip_65PlusPop_Pct': 65.7,\n", " 'Administered_65Plus': 3416914,\n", " 'Admin_Per_100k_65Plus': 103664,\n", " 'Distributed_Per_100k_65Plus': 337055,\n", " 'Administered_Dose2_Recip': 2870001,\n", " 'Administered_Dose2_Recip_18Plus': 2865633,\n", " 'Administered_Dose2_Recip_18PlusPop_Pct': 18.6,\n", " 'Distributed_Moderna': 5116100,\n", " 'Distributed_Pfizer': 5716035,\n", " 'Distributed_Janssen': 277700,\n", " 'Distributed_Unk_Manuf': 0,\n", " 'Series_Complete_Moderna': 1330621,\n", " 'Series_Complete_Pfizer': 1539161,\n", " 'Series_Complete_Janssen': 201120,\n", " 'Series_Complete_Unk_Manuf': 219,\n", " 'Series_Complete_Moderna_18Plus': 1330442,\n", " 'Series_Complete_Pfizer_18Plus': 1534972,\n", " 'Series_Complete_Janssen_18Plus': 201075,\n", " 'Series_Complete_Unk_Manuf_18Plus': 219,\n", " 'Series_Complete_Moderna_65Plus': 598789,\n", " 'Series_Complete_Pfizer_65Plus': 650634,\n", " 'Series_Complete_Janssen_65Plus': 59919,\n", " 'Series_Complete_Unk_Manuf_65Plus': 142,\n", " 'Series_Complete_Yes': 3071121,\n", " 'Series_Complete_Pop_Pct': 15.8,\n", " 'Series_Complete_18Plus': 3066708,\n", " 'Series_Complete_18PlusPop_Pct': 19.9,\n", " 'Series_Complete_65Plus': 1309484,\n", " 'Series_Complete_65PlusPop_Pct': 39.7},\n", " {'Date': '2021-03-29',\n", " 'Location': 'OH',\n", " 'ShortName': 'OHA',\n", " 'LongName': 'Ohio',\n", " 'Census2019': 11689100,\n", " 'date_type': 'Report',\n", " 'Doses_Distributed': 6386995,\n", " 'Doses_Administered': 5168120,\n", " 'Dist_Per_100K': 54641,\n", " 'Admin_Per_100K': 44213,\n", " 'Administered_Moderna': 2465860,\n", " 'Administered_Pfizer': 2553662,\n", " 'Administered_Janssen': 144315,\n", " 'Administered_Unk_Manuf': 4283,\n", " 'Administered_Dose1_Recip': 3324459,\n", " 'Administered_Dose1_Pop_Pct': 28.4,\n", " 'Administered_Dose2_Pop_Pct': 15.2,\n", " 'Administered_Dose1_Recip_18Plus': 3318563,\n", " 'Administered_Dose1_Recip_18PlusPop_Pct': 36.4,\n", " 'Administered_18Plus': 5160470,\n", " 'Admin_Per_100k_18Plus': 56639,\n", " 'Distributed_Per_100k_18Plus': 70101,\n", " 'Administered_Dose1_Recip_65Plus': 1467349,\n", " 'Administered_Dose1_Recip_65PlusPop_Pct': 71.7,\n", " 'Administered_65Plus': 2548292,\n", " 'Admin_Per_100k_65Plus': 124530,\n", " 'Distributed_Per_100k_65Plus': 312121,\n", " 'Administered_Dose2_Recip': 1778049,\n", " 'Administered_Dose2_Recip_18Plus': 1776441,\n", " 'Administered_Dose2_Recip_18PlusPop_Pct': 19.5,\n", " 'Distributed_Moderna': 2956500,\n", " 'Distributed_Pfizer': 3260595,\n", " 'Distributed_Janssen': 169900,\n", " 'Distributed_Unk_Manuf': 0,\n", " 'Series_Complete_Moderna': 885466,\n", " 'Series_Complete_Pfizer': 891406,\n", " 'Series_Complete_Janssen': 141844,\n", " 'Series_Complete_Unk_Manuf': 1177,\n", " 'Series_Complete_Moderna_18Plus': 885414,\n", " 'Series_Complete_Pfizer_18Plus': 889854,\n", " 'Series_Complete_Janssen_18Plus': 141816,\n", " 'Series_Complete_Unk_Manuf_18Plus': 1173,\n", " 'Series_Complete_Moderna_65Plus': 483301,\n", " 'Series_Complete_Pfizer_65Plus': 568551,\n", " 'Series_Complete_Janssen_65Plus': 40091,\n", " 'Series_Complete_Unk_Manuf_65Plus': 793,\n", " 'Series_Complete_Yes': 1919893,\n", " 'Series_Complete_Pop_Pct': 16.4,\n", " 'Series_Complete_18Plus': 1918257,\n", " 'Series_Complete_18PlusPop_Pct': 21.1,\n", " 'Series_Complete_65Plus': 1092736,\n", " 'Series_Complete_65PlusPop_Pct': 53.4},\n", " {'Date': '2021-03-29',\n", " 'Location': 'OK',\n", " 'ShortName': 'OKA',\n", " 'LongName': 'Oklahoma',\n", " 'Census2019': 3956971,\n", " 'date_type': 'Report',\n", " 'Doses_Distributed': 2530785,\n", " 'Doses_Administered': 1888004,\n", " 'Dist_Per_100K': 63958,\n", " 'Admin_Per_100K': 47713,\n", " 'Administered_Moderna': 876800,\n", " 'Administered_Pfizer': 980691,\n", " 'Administered_Janssen': 30502,\n", " 'Administered_Unk_Manuf': 11,\n", " 'Administered_Dose1_Recip': 1201827,\n", " 'Administered_Dose1_Pop_Pct': 30.4,\n", " 'Administered_Dose2_Pop_Pct': 16.6,\n", " 'Administered_Dose1_Recip_18Plus': 1193769,\n", " 'Administered_Dose1_Recip_18PlusPop_Pct': 39.7,\n", " 'Administered_18Plus': 1878476,\n", " 'Admin_Per_100k_18Plus': 62517,\n", " 'Distributed_Per_100k_18Plus': 84227,\n", " 'Administered_Dose1_Recip_65Plus': 466287,\n", " 'Administered_Dose1_Recip_65PlusPop_Pct': 73.4,\n", " 'Administered_65Plus': 817038,\n", " 'Admin_Per_100k_65Plus': 128641,\n", " 'Distributed_Per_100k_65Plus': 398466,\n", " 'Administered_Dose2_Recip': 655018,\n", " 'Administered_Dose2_Recip_18Plus': 653828,\n", " 'Administered_Dose2_Recip_18PlusPop_Pct': 21.8,\n", " 'Distributed_Moderna': 1245200,\n", " 'Distributed_Pfizer': 1217385,\n", " 'Distributed_Janssen': 68200,\n", " 'Distributed_Unk_Manuf': 0,\n", " 'Series_Complete_Moderna': 298611,\n", " 'Series_Complete_Pfizer': 356406,\n", " 'Series_Complete_Janssen': 30330,\n", " 'Series_Complete_Unk_Manuf': 1,\n", " 'Series_Complete_Moderna_18Plus': 298575,\n", " 'Series_Complete_Pfizer_18Plus': 355252,\n", " 'Series_Complete_Janssen_18Plus': 30318,\n", " 'Series_Complete_Unk_Manuf_18Plus': 1,\n", " 'Series_Complete_Moderna_65Plus': 182527,\n", " 'Series_Complete_Pfizer_65Plus': 160132,\n", " 'Series_Complete_Janssen_65Plus': 6648,\n", " 'Series_Complete_Unk_Manuf_65Plus': 0,\n", " 'Series_Complete_Yes': 685348,\n", " 'Series_Complete_Pop_Pct': 17.3,\n", " 'Series_Complete_18Plus': 684146,\n", " 'Series_Complete_18PlusPop_Pct': 22.8,\n", " 'Series_Complete_65Plus': 349307,\n", " 'Series_Complete_65PlusPop_Pct': 55.0},\n", " {'Date': '2021-03-29',\n", " 'Location': 'OR',\n", " 'ShortName': 'ORA',\n", " 'LongName': 'Oregon',\n", " 'Census2019': 4217737,\n", " 'date_type': 'Report',\n", " 'Doses_Distributed': 2205385,\n", " 'Doses_Administered': 1802561,\n", " 'Dist_Per_100K': 52288,\n", " 'Admin_Per_100K': 42738,\n", " 'Administered_Moderna': 864045,\n", " 'Administered_Pfizer': 897470,\n", " 'Administered_Janssen': 39925,\n", " 'Administered_Unk_Manuf': 1121,\n", " 'Administered_Dose1_Recip': 1158213,\n", " 'Administered_Dose1_Pop_Pct': 27.5,\n", " 'Administered_Dose2_Pop_Pct': 15.2,\n", " 'Administered_Dose1_Recip_18Plus': 1154268,\n", " 'Administered_Dose1_Recip_18PlusPop_Pct': 34.4,\n", " 'Administered_18Plus': 1796768,\n", " 'Admin_Per_100k_18Plus': 53616,\n", " 'Distributed_Per_100k_18Plus': 65809,\n", " 'Administered_Dose1_Recip_65Plus': 543113,\n", " 'Administered_Dose1_Recip_65PlusPop_Pct': 70.9,\n", " 'Administered_65Plus': 797459,\n", " 'Admin_Per_100k_65Plus': 104096,\n", " 'Distributed_Per_100k_65Plus': 287879,\n", " 'Administered_Dose2_Recip': 639792,\n", " 'Administered_Dose2_Recip_18Plus': 637956,\n", " 'Administered_Dose2_Recip_18PlusPop_Pct': 19.0,\n", " 'Distributed_Moderna': 1062100,\n", " 'Distributed_Pfizer': 1080885,\n", " 'Distributed_Janssen': 62400,\n", " 'Distributed_Unk_Manuf': 0,\n", " 'Series_Complete_Moderna': 306191,\n", " 'Series_Complete_Pfizer': 333412,\n", " 'Series_Complete_Janssen': 39724,\n", " 'Series_Complete_Unk_Manuf': 189,\n", " 'Series_Complete_Moderna_18Plus': 306011,\n", " 'Series_Complete_Pfizer_18Plus': 331756,\n", " 'Series_Complete_Janssen_18Plus': 39695,\n", " 'Series_Complete_Unk_Manuf_18Plus': 189,\n", " 'Series_Complete_Moderna_65Plus': 116817,\n", " 'Series_Complete_Pfizer_65Plus': 143384,\n", " 'Series_Complete_Janssen_65Plus': 23896,\n", " 'Series_Complete_Unk_Manuf_65Plus': 95,\n", " 'Series_Complete_Yes': 679516,\n", " 'Series_Complete_Pop_Pct': 16.1,\n", " 'Series_Complete_18Plus': 677651,\n", " 'Series_Complete_18PlusPop_Pct': 20.2,\n", " 'Series_Complete_65Plus': 284192,\n", " 'Series_Complete_65PlusPop_Pct': 37.1},\n", " {'Date': '2021-03-29',\n", " 'Location': 'PA',\n", " 'ShortName': 'PAA',\n", " 'LongName': 'Pennsylvania',\n", " 'Census2019': 12801989,\n", " 'date_type': 'Report',\n", " 'Doses_Distributed': 7164385,\n", " 'Doses_Administered': 5893502,\n", " 'Dist_Per_100K': 55963,\n", " 'Admin_Per_100K': 46036,\n", " 'Administered_Moderna': 2776827,\n", " 'Administered_Pfizer': 2990914,\n", " 'Administered_Janssen': 125641,\n", " 'Administered_Unk_Manuf': 120,\n", " 'Administered_Dose1_Recip': 3971897,\n", " 'Administered_Dose1_Pop_Pct': 31.0,\n", " 'Administered_Dose2_Pop_Pct': 15.1,\n", " 'Administered_Dose1_Recip_18Plus': 3962159,\n", " 'Administered_Dose1_Recip_18PlusPop_Pct': 39.0,\n", " 'Administered_18Plus': 5880679,\n", " 'Admin_Per_100k_18Plus': 57839,\n", " 'Distributed_Per_100k_18Plus': 70464,\n", " 'Administered_Dose1_Recip_65Plus': 1754720,\n", " 'Administered_Dose1_Recip_65PlusPop_Pct': 73.3,\n", " 'Administered_65Plus': 2694401,\n", " 'Admin_Per_100k_65Plus': 112578,\n", " 'Distributed_Per_100k_65Plus': 299344,\n", " 'Administered_Dose2_Recip': 1927632,\n", " 'Administered_Dose2_Recip_18Plus': 1924394,\n", " 'Administered_Dose2_Recip_18PlusPop_Pct': 18.9,\n", " 'Distributed_Moderna': 3385400,\n", " 'Distributed_Pfizer': 3580785,\n", " 'Distributed_Janssen': 198200,\n", " 'Distributed_Unk_Manuf': 0,\n", " 'Series_Complete_Moderna': 921460,\n", " 'Series_Complete_Pfizer': 1006067,\n", " 'Series_Complete_Janssen': 127773,\n", " 'Series_Complete_Unk_Manuf': 105,\n", " 'Series_Complete_Moderna_18Plus': 921261,\n", " 'Series_Complete_Pfizer_18Plus': 1003029,\n", " 'Series_Complete_Janssen_18Plus': 127762,\n", " 'Series_Complete_Unk_Manuf_18Plus': 104,\n", " 'Series_Complete_Moderna_65Plus': 465443,\n", " 'Series_Complete_Pfizer_65Plus': 467796,\n", " 'Series_Complete_Janssen_65Plus': 17523,\n", " 'Series_Complete_Unk_Manuf_65Plus': 65,\n", " 'Series_Complete_Yes': 2055405,\n", " 'Series_Complete_Pop_Pct': 16.1,\n", " 'Series_Complete_18Plus': 2052156,\n", " 'Series_Complete_18PlusPop_Pct': 20.2,\n", " 'Series_Complete_65Plus': 950827,\n", " 'Series_Complete_65PlusPop_Pct': 39.7},\n", " {'Date': '2021-03-29',\n", " 'Location': 'PR',\n", " 'ShortName': 'PRA',\n", " 'LongName': 'Puerto Rico',\n", " 'Census2019': 3193694,\n", " 'date_type': 'Report',\n", " 'Doses_Distributed': 1882480,\n", " 'Doses_Administered': 1055993,\n", " 'Dist_Per_100K': 58944,\n", " 'Admin_Per_100K': 33065,\n", " 'Administered_Moderna': 429655,\n", " 'Administered_Pfizer': 608560,\n", " 'Administered_Janssen': 17528,\n", " 'Administered_Unk_Manuf': 250,\n", " 'Administered_Dose1_Recip': 687175,\n", " 'Administered_Dose1_Pop_Pct': 21.5,\n", " 'Administered_Dose2_Pop_Pct': 11.7,\n", " 'Administered_Dose1_Recip_18Plus': 686562,\n", " 'Administered_Dose1_Recip_18PlusPop_Pct': 26.2,\n", " 'Administered_18Plus': 1055281,\n", " 'Admin_Per_100k_18Plus': 40263,\n", " 'Distributed_Per_100k_18Plus': 71824,\n", " 'Administered_Dose1_Recip_65Plus': 308322,\n", " 'Administered_Dose1_Recip_65PlusPop_Pct': 56.8,\n", " 'Administered_65Plus': 476038,\n", " 'Admin_Per_100k_65Plus': 87680,\n", " 'Distributed_Per_100k_65Plus': 346727,\n", " 'Administered_Dose2_Recip': 374449,\n", " 'Administered_Dose2_Recip_18Plus': 374321,\n", " 'Administered_Dose2_Recip_18PlusPop_Pct': 14.3,\n", " 'Distributed_Moderna': 909600,\n", " 'Distributed_Pfizer': 925080,\n", " 'Distributed_Janssen': 47800,\n", " 'Distributed_Unk_Manuf': 0,\n", " 'Series_Complete_Moderna': 147870,\n", " 'Series_Complete_Pfizer': 226571,\n", " 'Series_Complete_Janssen': 17607,\n", " 'Series_Complete_Unk_Manuf': 8,\n", " 'Series_Complete_Moderna_18Plus': 147850,\n", " 'Series_Complete_Pfizer_18Plus': 226463,\n", " 'Series_Complete_Janssen_18Plus': 17598,\n", " 'Series_Complete_Unk_Manuf_18Plus': 8,\n", " 'Series_Complete_Moderna_65Plus': 75769,\n", " 'Series_Complete_Pfizer_65Plus': 95457,\n", " 'Series_Complete_Janssen_65Plus': 4329,\n", " 'Series_Complete_Unk_Manuf_65Plus': 1,\n", " 'Series_Complete_Yes': 392056,\n", " 'Series_Complete_Pop_Pct': 12.3,\n", " 'Series_Complete_18Plus': 391919,\n", " 'Series_Complete_18PlusPop_Pct': 15.0,\n", " 'Series_Complete_65Plus': 175556,\n", " 'Series_Complete_65PlusPop_Pct': 32.3},\n", " {'Date': '2021-03-29',\n", " 'Location': 'RI',\n", " 'ShortName': 'RIA',\n", " 'LongName': 'Rhode Island',\n", " 'Census2019': 1059361,\n", " 'date_type': 'Report',\n", " 'Doses_Distributed': 616065,\n", " 'Doses_Administered': 538434,\n", " 'Dist_Per_100K': 58154,\n", " 'Admin_Per_100K': 50826,\n", " 'Administered_Moderna': 257226,\n", " 'Administered_Pfizer': 268982,\n", " 'Administered_Janssen': 12225,\n", " 'Administered_Unk_Manuf': 1,\n", " 'Administered_Dose1_Recip': 336637,\n", " 'Administered_Dose1_Pop_Pct': 31.8,\n", " 'Administered_Dose2_Pop_Pct': 19.0,\n", " 'Administered_Dose1_Recip_18Plus': 336035,\n", " 'Administered_Dose1_Recip_18PlusPop_Pct': 39.3,\n", " 'Administered_18Plus': 537671,\n", " 'Admin_Per_100k_18Plus': 62895,\n", " 'Distributed_Per_100k_18Plus': 72066,\n", " 'Administered_Dose1_Recip_65Plus': 154840,\n", " 'Administered_Dose1_Recip_65PlusPop_Pct': 82.8,\n", " 'Administered_65Plus': 263744,\n", " 'Admin_Per_100k_65Plus': 141005,\n", " 'Distributed_Per_100k_65Plus': 329366,\n", " 'Administered_Dose2_Recip': 200812,\n", " 'Administered_Dose2_Recip_18Plus': 200643,\n", " 'Administered_Dose2_Recip_18PlusPop_Pct': 23.5,\n", " 'Distributed_Moderna': 301700,\n", " 'Distributed_Pfizer': 297765,\n", " 'Distributed_Janssen': 16600,\n", " 'Distributed_Unk_Manuf': 0,\n", " 'Series_Complete_Moderna': 102917,\n", " 'Series_Complete_Pfizer': 97892,\n", " 'Series_Complete_Janssen': 12110,\n", " 'Series_Complete_Unk_Manuf': 3,\n", " 'Series_Complete_Moderna_18Plus': 102913,\n", " 'Series_Complete_Pfizer_18Plus': 97727,\n", " 'Series_Complete_Janssen_18Plus': 12110,\n", " 'Series_Complete_Unk_Manuf_18Plus': 3,\n", " 'Series_Complete_Moderna_65Plus': 49611,\n", " 'Series_Complete_Pfizer_65Plus': 59628,\n", " 'Series_Complete_Janssen_65Plus': 2024,\n", " 'Series_Complete_Unk_Manuf_65Plus': 2,\n", " 'Series_Complete_Yes': 212922,\n", " 'Series_Complete_Pop_Pct': 20.1,\n", " 'Series_Complete_18Plus': 212753,\n", " 'Series_Complete_18PlusPop_Pct': 24.9,\n", " 'Series_Complete_65Plus': 111265,\n", " 'Series_Complete_65PlusPop_Pct': 59.5},\n", " {'Date': '2021-03-29',\n", " 'Location': 'RP',\n", " 'ShortName': 'RPA',\n", " 'LongName': 'Republic of Palau',\n", " 'Census2019': 17907,\n", " 'date_type': 'Report',\n", " 'Doses_Distributed': 15000,\n", " 'Doses_Administered': 13381,\n", " 'Dist_Per_100K': 83766,\n", " 'Admin_Per_100K': 74725,\n", " 'Administered_Moderna': 13237,\n", " 'Administered_Pfizer': 1,\n", " 'Administered_Janssen': 143,\n", " 'Administered_Unk_Manuf': 0,\n", " 'Administered_Dose1_Recip': 8404,\n", " 'Administered_Dose1_Pop_Pct': 46.9,\n", " 'Administered_Dose2_Pop_Pct': 28.5,\n", " 'Administered_Dose1_Recip_18Plus': 8404,\n", " 'Administered_Dose1_Recip_18PlusPop_Pct': 60.2,\n", " 'Administered_18Plus': 13381,\n", " 'Admin_Per_100k_18Plus': 95804,\n", " 'Distributed_Per_100k_18Plus': 107396,\n", " 'Administered_Dose1_Recip_65Plus': 1450,\n", " 'Administered_Dose1_Recip_65PlusPop_Pct': 47.6,\n", " 'Administered_65Plus': 2674,\n", " 'Admin_Per_100k_65Plus': 87845,\n", " 'Distributed_Per_100k_65Plus': 492773,\n", " 'Administered_Dose2_Recip': 5107,\n", " 'Administered_Dose2_Recip_18Plus': 5107,\n", " 'Administered_Dose2_Recip_18PlusPop_Pct': 36.6,\n", " 'Distributed_Moderna': 14600,\n", " 'Distributed_Pfizer': 0,\n", " 'Distributed_Janssen': 400,\n", " 'Distributed_Unk_Manuf': 0,\n", " 'Series_Complete_Moderna': 5094,\n", " 'Series_Complete_Pfizer': 13,\n", " 'Series_Complete_Janssen': 143,\n", " 'Series_Complete_Unk_Manuf': 0,\n", " 'Series_Complete_Moderna_18Plus': 5094,\n", " 'Series_Complete_Pfizer_18Plus': 13,\n", " 'Series_Complete_Janssen_18Plus': 143,\n", " 'Series_Complete_Unk_Manuf_18Plus': 0,\n", " 'Series_Complete_Moderna_65Plus': 1251,\n", " 'Series_Complete_Pfizer_65Plus': 8,\n", " 'Series_Complete_Janssen_65Plus': 83,\n", " 'Series_Complete_Unk_Manuf_65Plus': 0,\n", " 'Series_Complete_Yes': 5250,\n", " 'Series_Complete_Pop_Pct': 29.3,\n", " 'Series_Complete_18Plus': 5250,\n", " 'Series_Complete_18PlusPop_Pct': 37.6,\n", " 'Series_Complete_65Plus': 1342,\n", " 'Series_Complete_65PlusPop_Pct': 44.1},\n", " {'Date': '2021-03-29',\n", " 'Location': 'SC',\n", " 'ShortName': 'SCA',\n", " 'LongName': 'South Carolina',\n", " 'Census2019': 5148714,\n", " 'date_type': 'Report',\n", " 'Doses_Distributed': 2652225,\n", " 'Doses_Administered': 2109171,\n", " 'Dist_Per_100K': 51512,\n", " 'Admin_Per_100K': 40965,\n", " 'Administered_Moderna': 811836,\n", " 'Administered_Pfizer': 1250400,\n", " 'Administered_Janssen': 45910,\n", " 'Administered_Unk_Manuf': 1025,\n", " 'Administered_Dose1_Recip': 1378779,\n", " 'Administered_Dose1_Pop_Pct': 26.8,\n", " 'Administered_Dose2_Pop_Pct': 13.8,\n", " 'Administered_Dose1_Recip_18Plus': 1375284,\n", " 'Administered_Dose1_Recip_18PlusPop_Pct': 34.1,\n", " 'Administered_18Plus': 2105131,\n", " 'Admin_Per_100k_18Plus': 52139,\n", " 'Distributed_Per_100k_18Plus': 65689,\n", " 'Administered_Dose1_Recip_65Plus': 684356,\n", " 'Administered_Dose1_Recip_65PlusPop_Pct': 73.0,\n", " 'Administered_65Plus': 1173603,\n", " 'Admin_Per_100k_65Plus': 125248,\n", " 'Distributed_Per_100k_65Plus': 283048,\n", " 'Administered_Dose2_Recip': 711699,\n", " 'Administered_Dose2_Recip_18Plus': 711209,\n", " 'Administered_Dose2_Recip_18PlusPop_Pct': 17.6,\n", " 'Distributed_Moderna': 1201200,\n", " 'Distributed_Pfizer': 1375725,\n", " 'Distributed_Janssen': 75300,\n", " 'Distributed_Unk_Manuf': 0,\n", " 'Series_Complete_Moderna': 251969,\n", " 'Series_Complete_Pfizer': 459526,\n", " 'Series_Complete_Janssen': 44788,\n", " 'Series_Complete_Unk_Manuf': 204,\n", " 'Series_Complete_Moderna_18Plus': 251933,\n", " 'Series_Complete_Pfizer_18Plus': 459072,\n", " 'Series_Complete_Janssen_18Plus': 44749,\n", " 'Series_Complete_Unk_Manuf_18Plus': 204,\n", " 'Series_Complete_Moderna_65Plus': 193013,\n", " 'Series_Complete_Pfizer_65Plus': 294146,\n", " 'Series_Complete_Janssen_65Plus': 9296,\n", " 'Series_Complete_Unk_Manuf_65Plus': 140,\n", " 'Series_Complete_Yes': 756487,\n", " 'Series_Complete_Pop_Pct': 14.7,\n", " 'Series_Complete_18Plus': 755958,\n", " 'Series_Complete_18PlusPop_Pct': 18.7,\n", " 'Series_Complete_65Plus': 496595,\n", " 'Series_Complete_65PlusPop_Pct': 53.0},\n", " {'Date': '2021-03-29',\n", " 'Location': 'SD',\n", " 'ShortName': 'SDA',\n", " 'LongName': 'South Dakota',\n", " 'Census2019': 884659,\n", " 'date_type': 'Report',\n", " 'Doses_Distributed': 581525,\n", " 'Doses_Administered': 488046,\n", " 'Dist_Per_100K': 65734,\n", " 'Admin_Per_100K': 55168,\n", " 'Administered_Moderna': 239609,\n", " 'Administered_Pfizer': 239807,\n", " 'Administered_Janssen': 8617,\n", " 'Administered_Unk_Manuf': 13,\n", " 'Administered_Dose1_Recip': 303587,\n", " 'Administered_Dose1_Pop_Pct': 34.3,\n", " 'Administered_Dose2_Pop_Pct': 21.0,\n", " 'Administered_Dose1_Recip_18Plus': 302216,\n", " 'Administered_Dose1_Recip_18PlusPop_Pct': 45.3,\n", " 'Administered_18Plus': 486235,\n", " 'Admin_Per_100k_18Plus': 72838,\n", " 'Distributed_Per_100k_18Plus': 87112,\n", " 'Administered_Dose1_Recip_65Plus': 127205,\n", " 'Administered_Dose1_Recip_65PlusPop_Pct': 83.8,\n", " 'Administered_65Plus': 227396,\n", " 'Admin_Per_100k_65Plus': 149730,\n", " 'Distributed_Per_100k_65Plus': 382907,\n", " 'Administered_Dose2_Recip': 185494,\n", " 'Administered_Dose2_Recip_18Plus': 185062,\n", " 'Administered_Dose2_Recip_18PlusPop_Pct': 27.7,\n", " 'Distributed_Moderna': 294400,\n", " 'Distributed_Pfizer': 272025,\n", " 'Distributed_Janssen': 15100,\n", " 'Distributed_Unk_Manuf': 0,\n", " 'Series_Complete_Moderna': 91738,\n", " 'Series_Complete_Pfizer': 93751,\n", " 'Series_Complete_Janssen': 8554,\n", " 'Series_Complete_Unk_Manuf': 5,\n", " 'Series_Complete_Moderna_18Plus': 91724,\n", " 'Series_Complete_Pfizer_18Plus': 93333,\n", " 'Series_Complete_Janssen_18Plus': 8551,\n", " 'Series_Complete_Unk_Manuf_18Plus': 5,\n", " 'Series_Complete_Moderna_65Plus': 50883,\n", " 'Series_Complete_Pfizer_65Plus': 50980,\n", " 'Series_Complete_Janssen_65Plus': 1226,\n", " 'Series_Complete_Unk_Manuf_65Plus': 2,\n", " 'Series_Complete_Yes': 194048,\n", " 'Series_Complete_Pop_Pct': 21.9,\n", " 'Series_Complete_18Plus': 193613,\n", " 'Series_Complete_18PlusPop_Pct': 29.0,\n", " 'Series_Complete_65Plus': 103091,\n", " 'Series_Complete_65PlusPop_Pct': 67.9},\n", " {'Date': '2021-03-29',\n", " 'Location': 'TN',\n", " 'ShortName': 'TNA',\n", " 'LongName': 'Tennessee',\n", " 'Census2019': 6829174,\n", " 'date_type': 'Report',\n", " 'Doses_Distributed': 3554800,\n", " 'Doses_Administered': 2582046,\n", " 'Dist_Per_100K': 52053,\n", " 'Admin_Per_100K': 37809,\n", " 'Administered_Moderna': 1209349,\n", " 'Administered_Pfizer': 1317136,\n", " 'Administered_Janssen': 52501,\n", " 'Administered_Unk_Manuf': 3060,\n", " 'Administered_Dose1_Recip': 1669271,\n", " 'Administered_Dose1_Pop_Pct': 24.4,\n", " 'Administered_Dose2_Pop_Pct': 12.6,\n", " 'Administered_Dose1_Recip_18Plus': 1665626,\n", " 'Administered_Dose1_Recip_18PlusPop_Pct': 31.3,\n", " 'Administered_18Plus': 2578113,\n", " 'Admin_Per_100k_18Plus': 48469,\n", " 'Distributed_Per_100k_18Plus': 66831,\n", " 'Administered_Dose1_Recip_65Plus': 748984,\n", " 'Administered_Dose1_Recip_65PlusPop_Pct': 65.5,\n", " 'Administered_65Plus': 1275735,\n", " 'Admin_Per_100k_65Plus': 111574,\n", " 'Distributed_Per_100k_65Plus': 310899,\n", " 'Administered_Dose2_Recip': 859836,\n", " 'Administered_Dose2_Recip_18Plus': 859579,\n", " 'Administered_Dose2_Recip_18PlusPop_Pct': 16.2,\n", " 'Distributed_Moderna': 1735800,\n", " 'Distributed_Pfizer': 1731600,\n", " 'Distributed_Janssen': 87400,\n", " 'Distributed_Unk_Manuf': 0,\n", " 'Series_Complete_Moderna': 396982,\n", " 'Series_Complete_Pfizer': 462014,\n", " 'Series_Complete_Janssen': 52265,\n", " 'Series_Complete_Unk_Manuf': 840,\n", " 'Series_Complete_Moderna_18Plus': 396960,\n", " 'Series_Complete_Pfizer_18Plus': 461780,\n", " 'Series_Complete_Janssen_18Plus': 52200,\n", " 'Series_Complete_Unk_Manuf_18Plus': 839,\n", " 'Series_Complete_Moderna_65Plus': 252045,\n", " 'Series_Complete_Pfizer_65Plus': 249209,\n", " 'Series_Complete_Janssen_65Plus': 10003,\n", " 'Series_Complete_Unk_Manuf_65Plus': 563,\n", " 'Series_Complete_Yes': 912101,\n", " 'Series_Complete_Pop_Pct': 13.4,\n", " 'Series_Complete_18Plus': 911779,\n", " 'Series_Complete_18PlusPop_Pct': 17.1,\n", " 'Series_Complete_65Plus': 511820,\n", " 'Series_Complete_65PlusPop_Pct': 44.8},\n", " {'Date': '2021-03-29',\n", " 'Location': 'TX',\n", " 'ShortName': 'TXA',\n", " 'LongName': 'Texas',\n", " 'Census2019': 28995881,\n", " 'date_type': 'Report',\n", " 'Doses_Distributed': 14660795,\n", " 'Doses_Administered': 11130215,\n", " 'Dist_Per_100K': 50562,\n", " 'Admin_Per_100K': 38386,\n", " 'Administered_Moderna': 5117886,\n", " 'Administered_Pfizer': 5745688,\n", " 'Administered_Janssen': 266124,\n", " 'Administered_Unk_Manuf': 517,\n", " 'Administered_Dose1_Recip': 7211223,\n", " 'Administered_Dose1_Pop_Pct': 24.9,\n", " 'Administered_Dose2_Pop_Pct': 12.1,\n", " 'Administered_Dose1_Recip_18Plus': 7174625,\n", " 'Administered_Dose1_Recip_18PlusPop_Pct': 33.2,\n", " 'Administered_18Plus': 11075125,\n", " 'Admin_Per_100k_18Plus': 51283,\n", " 'Distributed_Per_100k_18Plus': 67886,\n", " 'Administered_Dose1_Recip_65Plus': 2565754,\n", " 'Administered_Dose1_Recip_65PlusPop_Pct': 68.7,\n", " 'Administered_65Plus': 4151944,\n", " 'Admin_Per_100k_65Plus': 111186,\n", " 'Distributed_Per_100k_65Plus': 392606,\n", " 'Administered_Dose2_Recip': 3496059,\n", " 'Administered_Dose2_Recip_18Plus': 3478316,\n", " 'Administered_Dose2_Recip_18PlusPop_Pct': 16.1,\n", " 'Distributed_Moderna': 6771800,\n", " 'Distributed_Pfizer': 7441395,\n", " 'Distributed_Janssen': 447600,\n", " 'Distributed_Unk_Manuf': 0,\n", " 'Series_Complete_Moderna': 1650349,\n", " 'Series_Complete_Pfizer': 1844970,\n", " 'Series_Complete_Janssen': 260489,\n", " 'Series_Complete_Unk_Manuf': 373,\n", " 'Series_Complete_Moderna_18Plus': 1641973,\n", " 'Series_Complete_Pfizer_18Plus': 1835606,\n", " 'Series_Complete_Janssen_18Plus': 259167,\n", " 'Series_Complete_Unk_Manuf_18Plus': 371,\n", " 'Series_Complete_Moderna_65Plus': 720212,\n", " 'Series_Complete_Pfizer_65Plus': 805145,\n", " 'Series_Complete_Janssen_65Plus': 113677,\n", " 'Series_Complete_Unk_Manuf_65Plus': 163,\n", " 'Series_Complete_Yes': 3756181,\n", " 'Series_Complete_Pop_Pct': 13.0,\n", " 'Series_Complete_18Plus': 3737118,\n", " 'Series_Complete_18PlusPop_Pct': 17.3,\n", " 'Series_Complete_65Plus': 1639198,\n", " 'Series_Complete_65PlusPop_Pct': 43.9},\n", " {'Date': '2021-03-29',\n", " 'Location': 'UT',\n", " 'ShortName': 'UTA',\n", " 'LongName': 'Utah',\n", " 'Census2019': 3205958,\n", " 'date_type': 'Report',\n", " 'Doses_Distributed': 1500500,\n", " 'Doses_Administered': 1276193,\n", " 'Dist_Per_100K': 46803,\n", " 'Admin_Per_100K': 39807,\n", " 'Administered_Moderna': 589230,\n", " 'Administered_Pfizer': 656009,\n", " 'Administered_Janssen': 30954,\n", " 'Administered_Unk_Manuf': 0,\n", " 'Administered_Dose1_Recip': 784153,\n", " 'Administered_Dose1_Pop_Pct': 24.5,\n", " 'Administered_Dose2_Pop_Pct': 10.0,\n", " 'Administered_Dose1_Recip_18Plus': 779956,\n", " 'Administered_Dose1_Recip_18PlusPop_Pct': 34.3,\n", " 'Administered_18Plus': 1270829,\n", " 'Admin_Per_100k_18Plus': 55866,\n", " 'Distributed_Per_100k_18Plus': 65963,\n", " 'Administered_Dose1_Recip_65Plus': 276223,\n", " 'Administered_Dose1_Recip_65PlusPop_Pct': 75.5,\n", " 'Administered_65Plus': 482774,\n", " 'Admin_Per_100k_65Plus': 131952,\n", " 'Distributed_Per_100k_65Plus': 410116,\n", " 'Administered_Dose2_Recip': 320556,\n", " 'Administered_Dose2_Recip_18Plus': 319804,\n", " 'Administered_Dose2_Recip_18PlusPop_Pct': 14.1,\n", " 'Distributed_Moderna': 735200,\n", " 'Distributed_Pfizer': 725400,\n", " 'Distributed_Janssen': 39900,\n", " 'Distributed_Unk_Manuf': 0,\n", " 'Series_Complete_Moderna': 152618,\n", " 'Series_Complete_Pfizer': 167938,\n", " 'Series_Complete_Janssen': 29540,\n", " 'Series_Complete_Unk_Manuf': 0,\n", " 'Series_Complete_Moderna_18Plus': 152563,\n", " 'Series_Complete_Pfizer_18Plus': 167241,\n", " 'Series_Complete_Janssen_18Plus': 29516,\n", " 'Series_Complete_Unk_Manuf_18Plus': 0,\n", " 'Series_Complete_Moderna_65Plus': 58550,\n", " 'Series_Complete_Pfizer_65Plus': 86029,\n", " 'Series_Complete_Janssen_65Plus': 6146,\n", " 'Series_Complete_Unk_Manuf_65Plus': 0,\n", " 'Series_Complete_Yes': 350096,\n", " 'Series_Complete_Pop_Pct': 10.9,\n", " 'Series_Complete_18Plus': 349320,\n", " 'Series_Complete_18PlusPop_Pct': 15.4,\n", " 'Series_Complete_65Plus': 150725,\n", " 'Series_Complete_65PlusPop_Pct': 41.2},\n", " {'Date': '2021-03-29',\n", " 'Location': 'VA',\n", " 'ShortName': 'VAA',\n", " 'LongName': 'Virginia',\n", " 'Census2019': 8535519,\n", " 'date_type': 'Report',\n", " 'Doses_Distributed': 4489825,\n", " 'Doses_Administered': 3867013,\n", " 'Dist_Per_100K': 52602,\n", " 'Admin_Per_100K': 45305,\n", " 'Administered_Moderna': 1753016,\n", " 'Administered_Pfizer': 2022517,\n", " 'Administered_Janssen': 90743,\n", " 'Administered_Unk_Manuf': 737,\n", " 'Administered_Dose1_Recip': 2553135,\n", " 'Administered_Dose1_Pop_Pct': 29.9,\n", " 'Administered_Dose2_Pop_Pct': 15.2,\n", " 'Administered_Dose1_Recip_18Plus': 2542708,\n", " 'Administered_Dose1_Recip_18PlusPop_Pct': 38.1,\n", " 'Administered_18Plus': 3854261,\n", " 'Admin_Per_100k_18Plus': 57745,\n", " 'Distributed_Per_100k_18Plus': 67267,\n", " 'Administered_Dose1_Recip_65Plus': 990818,\n", " 'Administered_Dose1_Recip_65PlusPop_Pct': 72.9,\n", " 'Administered_65Plus': 1585222,\n", " 'Admin_Per_100k_65Plus': 116654,\n", " 'Distributed_Per_100k_65Plus': 330400,\n", " 'Administered_Dose2_Recip': 1296348,\n", " 'Administered_Dose2_Recip_18Plus': 1294162,\n", " 'Administered_Dose2_Recip_18PlusPop_Pct': 19.4,\n", " 'Distributed_Moderna': 2150800,\n", " 'Distributed_Pfizer': 2225925,\n", " 'Distributed_Janssen': 113100,\n", " 'Distributed_Unk_Manuf': 0,\n", " 'Series_Complete_Moderna': 595979,\n", " 'Series_Complete_Pfizer': 700144,\n", " 'Series_Complete_Janssen': 90487,\n", " 'Series_Complete_Unk_Manuf': 225,\n", " 'Series_Complete_Moderna_18Plus': 595714,\n", " 'Series_Complete_Pfizer_18Plus': 698223,\n", " 'Series_Complete_Janssen_18Plus': 90348,\n", " 'Series_Complete_Unk_Manuf_18Plus': 225,\n", " 'Series_Complete_Moderna_65Plus': 276448,\n", " 'Series_Complete_Pfizer_65Plus': 314626,\n", " 'Series_Complete_Janssen_65Plus': 31590,\n", " 'Series_Complete_Unk_Manuf_65Plus': 165,\n", " 'Series_Complete_Yes': 1386835,\n", " 'Series_Complete_Pop_Pct': 16.2,\n", " 'Series_Complete_18Plus': 1384510,\n", " 'Series_Complete_18PlusPop_Pct': 20.7,\n", " 'Series_Complete_65Plus': 622829,\n", " 'Series_Complete_65PlusPop_Pct': 45.8},\n", " {'Date': '2021-03-29',\n", " 'Location': 'VA2',\n", " 'ShortName': 'VA2',\n", " 'LongName': 'Veterans Health',\n", " 'Census2019': 0,\n", " 'date_type': 'Report',\n", " 'Doses_Distributed': 4356075,\n", " 'Doses_Administered': 3854450,\n", " 'Dist_Per_100K': 0,\n", " 'Admin_Per_100K': 0,\n", " 'Administered_Moderna': 2060807,\n", " 'Administered_Pfizer': 1731274,\n", " 'Administered_Janssen': 62368,\n", " 'Administered_Unk_Manuf': 1,\n", " 'Administered_Dose1_Recip': 2297542,\n", " 'Administered_Dose1_Pop_Pct': 0.0,\n", " 'Administered_Dose2_Pop_Pct': 0.0,\n", " 'Administered_Dose1_Recip_18Plus': 2297437,\n", " 'Administered_Dose1_Recip_18PlusPop_Pct': 0.0,\n", " 'Administered_18Plus': 3854290,\n", " 'Admin_Per_100k_18Plus': 0,\n", " 'Distributed_Per_100k_18Plus': 0,\n", " 'Administered_Dose1_Recip_65Plus': 1334760,\n", " 'Administered_Dose1_Recip_65PlusPop_Pct': 0.0,\n", " 'Administered_65Plus': 2406773,\n", " 'Admin_Per_100k_65Plus': 0,\n", " 'Distributed_Per_100k_65Plus': 0,\n", " 'Administered_Dose2_Recip': 1555163,\n", " 'Administered_Dose2_Recip_18Plus': 1555108,\n", " 'Administered_Dose2_Recip_18PlusPop_Pct': 0.0,\n", " 'Distributed_Moderna': 2291600,\n", " 'Distributed_Pfizer': 1974375,\n", " 'Distributed_Janssen': 90100,\n", " 'Distributed_Unk_Manuf': 0,\n", " 'Series_Complete_Moderna': 834477,\n", " 'Series_Complete_Pfizer': 720686,\n", " 'Series_Complete_Janssen': 62341,\n", " 'Series_Complete_Unk_Manuf': 0,\n", " 'Series_Complete_Moderna_18Plus': 834458,\n", " 'Series_Complete_Pfizer_18Plus': 720650,\n", " 'Series_Complete_Janssen_18Plus': 62336,\n", " 'Series_Complete_Unk_Manuf_18Plus': 0,\n", " 'Series_Complete_Moderna_65Plus': 603176,\n", " 'Series_Complete_Pfizer_65Plus': 468423,\n", " 'Series_Complete_Janssen_65Plus': 23153,\n", " 'Series_Complete_Unk_Manuf_65Plus': 0,\n", " 'Series_Complete_Yes': 1617504,\n", " 'Series_Complete_Pop_Pct': 0.0,\n", " 'Series_Complete_18Plus': 1617444,\n", " 'Series_Complete_18PlusPop_Pct': 0.0,\n", " 'Series_Complete_65Plus': 1094752,\n", " 'Series_Complete_65PlusPop_Pct': 0.0},\n", " {'Date': '2021-03-29',\n", " 'Location': 'VI',\n", " 'ShortName': 'VIA',\n", " 'LongName': 'Virgin Islands',\n", " 'Census2019': 104680,\n", " 'date_type': 'Report',\n", " 'Doses_Distributed': 56960,\n", " 'Doses_Administered': 38261,\n", " 'Dist_Per_100K': 54413,\n", " 'Admin_Per_100K': 36550,\n", " 'Administered_Moderna': 15646,\n", " 'Administered_Pfizer': 22600,\n", " 'Administered_Janssen': 15,\n", " 'Administered_Unk_Manuf': 0,\n", " 'Administered_Dose1_Recip': 23754,\n", " 'Administered_Dose1_Pop_Pct': 22.7,\n", " 'Administered_Dose2_Pop_Pct': 12.3,\n", " 'Administered_Dose1_Recip_18Plus': 23570,\n", " 'Administered_Dose1_Recip_18PlusPop_Pct': 28.9,\n", " 'Administered_18Plus': 37987,\n", " 'Admin_Per_100k_18Plus': 46524,\n", " 'Distributed_Per_100k_18Plus': 69761,\n", " 'Administered_Dose1_Recip_65Plus': 8422,\n", " 'Administered_Dose1_Recip_65PlusPop_Pct': 47.3,\n", " 'Administered_65Plus': 13872,\n", " 'Admin_Per_100k_65Plus': 77950,\n", " 'Distributed_Per_100k_65Plus': 320072,\n", " 'Administered_Dose2_Recip': 12912,\n", " 'Administered_Dose2_Recip_18Plus': 12853,\n", " 'Administered_Dose2_Recip_18PlusPop_Pct': 15.7,\n", " 'Distributed_Moderna': 19900,\n", " 'Distributed_Pfizer': 36660,\n", " 'Distributed_Janssen': 400,\n", " 'Distributed_Unk_Manuf': 0,\n", " 'Series_Complete_Moderna': 6080,\n", " 'Series_Complete_Pfizer': 6832,\n", " 'Series_Complete_Janssen': 21,\n", " 'Series_Complete_Unk_Manuf': 0,\n", " 'Series_Complete_Moderna_18Plus': 6075,\n", " 'Series_Complete_Pfizer_18Plus': 6778,\n", " 'Series_Complete_Janssen_18Plus': 21,\n", " 'Series_Complete_Unk_Manuf_18Plus': 0,\n", " 'Series_Complete_Moderna_65Plus': 2904,\n", " 'Series_Complete_Pfizer_65Plus': 2429,\n", " 'Series_Complete_Janssen_65Plus': 8,\n", " 'Series_Complete_Unk_Manuf_65Plus': 0,\n", " 'Series_Complete_Yes': 12933,\n", " 'Series_Complete_Pop_Pct': 12.4,\n", " 'Series_Complete_18Plus': 12874,\n", " 'Series_Complete_18PlusPop_Pct': 15.8,\n", " 'Series_Complete_65Plus': 5341,\n", " 'Series_Complete_65PlusPop_Pct': 30.0},\n", " {'Date': '2021-03-29',\n", " 'Location': 'VT',\n", " 'ShortName': 'VTA',\n", " 'LongName': 'Vermont',\n", " 'Census2019': 623989,\n", " 'date_type': 'Report',\n", " 'Doses_Distributed': 393330,\n", " 'Doses_Administered': 316145,\n", " 'Dist_Per_100K': 63035,\n", " 'Admin_Per_100K': 50665,\n", " 'Administered_Moderna': 154405,\n", " 'Administered_Pfizer': 155780,\n", " 'Administered_Janssen': 5724,\n", " 'Administered_Unk_Manuf': 236,\n", " 'Administered_Dose1_Recip': 203266,\n", " 'Administered_Dose1_Pop_Pct': 32.6,\n", " 'Administered_Dose2_Pop_Pct': 16.9,\n", " 'Administered_Dose1_Recip_18Plus': 202756,\n", " 'Administered_Dose1_Recip_18PlusPop_Pct': 39.8,\n", " 'Administered_18Plus': 315497,\n", " 'Admin_Per_100k_18Plus': 61864,\n", " 'Distributed_Per_100k_18Plus': 77126,\n", " 'Administered_Dose1_Recip_65Plus': 107922,\n", " 'Administered_Dose1_Recip_65PlusPop_Pct': 86.3,\n", " 'Administered_65Plus': 170360,\n", " 'Admin_Per_100k_65Plus': 136245,\n", " 'Distributed_Per_100k_65Plus': 314566,\n", " 'Administered_Dose2_Recip': 105663,\n", " 'Administered_Dose2_Recip_18Plus': 105522,\n", " 'Administered_Dose2_Recip_18PlusPop_Pct': 20.7,\n", " 'Distributed_Moderna': 193800,\n", " 'Distributed_Pfizer': 186030,\n", " 'Distributed_Janssen': 13500,\n", " 'Distributed_Unk_Manuf': 0,\n", " 'Series_Complete_Moderna': 51822,\n", " 'Series_Complete_Pfizer': 53776,\n", " 'Series_Complete_Janssen': 5488,\n", " 'Series_Complete_Unk_Manuf': 65,\n", " 'Series_Complete_Moderna_18Plus': 51811,\n", " 'Series_Complete_Pfizer_18Plus': 53646,\n", " 'Series_Complete_Janssen_18Plus': 5485,\n", " 'Series_Complete_Unk_Manuf_18Plus': 65,\n", " 'Series_Complete_Moderna_65Plus': 25271,\n", " 'Series_Complete_Pfizer_65Plus': 32825,\n", " 'Series_Complete_Janssen_65Plus': 111,\n", " 'Series_Complete_Unk_Manuf_65Plus': 42,\n", " 'Series_Complete_Yes': 111151,\n", " 'Series_Complete_Pop_Pct': 17.8,\n", " 'Series_Complete_18Plus': 111007,\n", " 'Series_Complete_18PlusPop_Pct': 21.8,\n", " 'Series_Complete_65Plus': 58249,\n", " 'Series_Complete_65PlusPop_Pct': 46.6},\n", " {'Date': '2021-03-29',\n", " 'Location': 'WA',\n", " 'ShortName': 'WAA',\n", " 'LongName': 'Washington',\n", " 'Census2019': 7614893,\n", " 'date_type': 'Report',\n", " 'Doses_Distributed': 4114320,\n", " 'Doses_Administered': 3501641,\n", " 'Dist_Per_100K': 54030,\n", " 'Admin_Per_100K': 45984,\n", " 'Administered_Moderna': 1618821,\n", " 'Administered_Pfizer': 1808091,\n", " 'Administered_Janssen': 72154,\n", " 'Administered_Unk_Manuf': 2575,\n", " 'Administered_Dose1_Recip': 2232951,\n", " 'Administered_Dose1_Pop_Pct': 29.3,\n", " 'Administered_Dose2_Pop_Pct': 16.4,\n", " 'Administered_Dose1_Recip_18Plus': 2225639,\n", " 'Administered_Dose1_Recip_18PlusPop_Pct': 37.4,\n", " 'Administered_18Plus': 3492773,\n", " 'Admin_Per_100k_18Plus': 58684,\n", " 'Distributed_Per_100k_18Plus': 69127,\n", " 'Administered_Dose1_Recip_65Plus': 947358,\n", " 'Administered_Dose1_Recip_65PlusPop_Pct': 78.3,\n", " 'Administered_65Plus': 1635387,\n", " 'Admin_Per_100k_65Plus': 135187,\n", " 'Distributed_Per_100k_65Plus': 340104,\n", " 'Administered_Dose2_Recip': 1245782,\n", " 'Administered_Dose2_Recip_18Plus': 1244251,\n", " 'Administered_Dose2_Recip_18PlusPop_Pct': 20.9,\n", " 'Distributed_Moderna': 1966500,\n", " 'Distributed_Pfizer': 2042820,\n", " 'Distributed_Janssen': 105000,\n", " 'Distributed_Unk_Manuf': 0,\n", " 'Series_Complete_Moderna': 597042,\n", " 'Series_Complete_Pfizer': 648251,\n", " 'Series_Complete_Janssen': 72304,\n", " 'Series_Complete_Unk_Manuf': 489,\n", " 'Series_Complete_Moderna_18Plus': 596974,\n", " 'Series_Complete_Pfizer_18Plus': 646788,\n", " 'Series_Complete_Janssen_18Plus': 72293,\n", " 'Series_Complete_Unk_Manuf_18Plus': 489,\n", " 'Series_Complete_Moderna_65Plus': 327230,\n", " 'Series_Complete_Pfizer_65Plus': 346630,\n", " 'Series_Complete_Janssen_65Plus': 25144,\n", " 'Series_Complete_Unk_Manuf_65Plus': 356,\n", " 'Series_Complete_Yes': 1318086,\n", " 'Series_Complete_Pop_Pct': 17.3,\n", " 'Series_Complete_18Plus': 1316544,\n", " 'Series_Complete_18PlusPop_Pct': 22.1,\n", " 'Series_Complete_65Plus': 699360,\n", " 'Series_Complete_65PlusPop_Pct': 57.8},\n", " {'Date': '2021-03-29',\n", " 'Location': 'WI',\n", " 'ShortName': 'WIA',\n", " 'LongName': 'Wisconsin',\n", " 'Census2019': 5822434,\n", " 'date_type': 'Report',\n", " 'Doses_Distributed': 2996415,\n", " 'Doses_Administered': 2853949,\n", " 'Dist_Per_100K': 51463,\n", " 'Admin_Per_100K': 49016,\n", " 'Administered_Moderna': 1296015,\n", " 'Administered_Pfizer': 1502447,\n", " 'Administered_Janssen': 55262,\n", " 'Administered_Unk_Manuf': 225,\n", " 'Administered_Dose1_Recip': 1819527,\n", " 'Administered_Dose1_Pop_Pct': 31.3,\n", " 'Administered_Dose2_Pop_Pct': 17.3,\n", " 'Administered_Dose1_Recip_18Plus': 1812773,\n", " 'Administered_Dose1_Recip_18PlusPop_Pct': 39.8,\n", " 'Administered_18Plus': 2845948,\n", " 'Admin_Per_100k_18Plus': 62468,\n", " 'Distributed_Per_100k_18Plus': 65771,\n", " 'Administered_Dose1_Recip_65Plus': 813581,\n", " 'Administered_Dose1_Recip_65PlusPop_Pct': 80.0,\n", " 'Administered_65Plus': 1442075,\n", " 'Admin_Per_100k_65Plus': 141763,\n", " 'Distributed_Per_100k_65Plus': 294562,\n", " 'Administered_Dose2_Recip': 1005175,\n", " 'Administered_Dose2_Recip_18Plus': 1004086,\n", " 'Administered_Dose2_Recip_18PlusPop_Pct': 22.0,\n", " 'Distributed_Moderna': 1447700,\n", " 'Distributed_Pfizer': 1473615,\n", " 'Distributed_Janssen': 75100,\n", " 'Distributed_Unk_Manuf': 0,\n", " 'Series_Complete_Moderna': 450484,\n", " 'Series_Complete_Pfizer': 554629,\n", " 'Series_Complete_Janssen': 53528,\n", " 'Series_Complete_Unk_Manuf': 62,\n", " 'Series_Complete_Moderna_18Plus': 450451,\n", " 'Series_Complete_Pfizer_18Plus': 553573,\n", " 'Series_Complete_Janssen_18Plus': 53494,\n", " 'Series_Complete_Unk_Manuf_18Plus': 62,\n", " 'Series_Complete_Moderna_65Plus': 294546,\n", " 'Series_Complete_Pfizer_65Plus': 308999,\n", " 'Series_Complete_Janssen_65Plus': 6696,\n", " 'Series_Complete_Unk_Manuf_65Plus': 33,\n", " 'Series_Complete_Yes': 1058703,\n", " 'Series_Complete_Pop_Pct': 18.2,\n", " 'Series_Complete_18Plus': 1057580,\n", " 'Series_Complete_18PlusPop_Pct': 23.2,\n", " 'Series_Complete_65Plus': 610274,\n", " 'Series_Complete_65PlusPop_Pct': 60.0},\n", " {'Date': '2021-03-29',\n", " 'Location': 'WV',\n", " 'ShortName': 'WVA',\n", " 'LongName': 'West Virginia',\n", " 'Census2019': 1792147,\n", " 'date_type': 'Report',\n", " 'Doses_Distributed': 1067635,\n", " 'Doses_Administered': 857701,\n", " 'Dist_Per_100K': 59573,\n", " 'Admin_Per_100K': 47859,\n", " 'Administered_Moderna': 425372,\n", " 'Administered_Pfizer': 425115,\n", " 'Administered_Janssen': 7214,\n", " 'Administered_Unk_Manuf': 0,\n", " 'Administered_Dose1_Recip': 525033,\n", " 'Administered_Dose1_Pop_Pct': 29.3,\n", " 'Administered_Dose2_Pop_Pct': 18.0,\n", " 'Administered_Dose1_Recip_18Plus': 522372,\n", " 'Administered_Dose1_Recip_18PlusPop_Pct': 36.5,\n", " 'Administered_18Plus': 854686,\n", " 'Admin_Per_100k_18Plus': 59661,\n", " 'Distributed_Per_100k_18Plus': 74525,\n", " 'Administered_Dose1_Recip_65Plus': 240576,\n", " 'Administered_Dose1_Recip_65PlusPop_Pct': 65.6,\n", " 'Administered_65Plus': 427529,\n", " 'Admin_Per_100k_65Plus': 116489,\n", " 'Distributed_Per_100k_65Plus': 290900,\n", " 'Administered_Dose2_Recip': 323442,\n", " 'Administered_Dose2_Recip_18Plus': 323133,\n", " 'Administered_Dose2_Recip_18PlusPop_Pct': 22.6,\n", " 'Distributed_Moderna': 556600,\n", " 'Distributed_Pfizer': 482235,\n", " 'Distributed_Janssen': 28800,\n", " 'Distributed_Unk_Manuf': 0,\n", " 'Series_Complete_Moderna': 154469,\n", " 'Series_Complete_Pfizer': 168952,\n", " 'Series_Complete_Janssen': 7719,\n", " 'Series_Complete_Unk_Manuf': 21,\n", " 'Series_Complete_Moderna_18Plus': 154412,\n", " 'Series_Complete_Pfizer_18Plus': 168700,\n", " 'Series_Complete_Janssen_18Plus': 7709,\n", " 'Series_Complete_Unk_Manuf_18Plus': 21,\n", " 'Series_Complete_Moderna_65Plus': 89555,\n", " 'Series_Complete_Pfizer_65Plus': 93680,\n", " 'Series_Complete_Janssen_65Plus': 1560,\n", " 'Series_Complete_Unk_Manuf_65Plus': 13,\n", " 'Series_Complete_Yes': 331161,\n", " 'Series_Complete_Pop_Pct': 18.5,\n", " 'Series_Complete_18Plus': 330842,\n", " 'Series_Complete_18PlusPop_Pct': 23.1,\n", " 'Series_Complete_65Plus': 184808,\n", " 'Series_Complete_65PlusPop_Pct': 50.4},\n", " {'Date': '2021-03-29',\n", " 'Location': 'WY',\n", " 'ShortName': 'WYA',\n", " 'LongName': 'Wyoming',\n", " 'Census2019': 578759,\n", " 'date_type': 'Report',\n", " 'Doses_Distributed': 353975,\n", " 'Doses_Administered': 261950,\n", " 'Dist_Per_100K': 61161,\n", " 'Admin_Per_100K': 45261,\n", " 'Administered_Moderna': 130693,\n", " 'Administered_Pfizer': 125994,\n", " 'Administered_Janssen': 5167,\n", " 'Administered_Unk_Manuf': 96,\n", " 'Administered_Dose1_Recip': 156608,\n", " 'Administered_Dose1_Pop_Pct': 27.1,\n", " 'Administered_Dose2_Pop_Pct': 17.3,\n", " 'Administered_Dose1_Recip_18Plus': 156138,\n", " 'Administered_Dose1_Recip_18PlusPop_Pct': 35.1,\n", " 'Administered_18Plus': 261352,\n", " 'Admin_Per_100k_18Plus': 58727,\n", " 'Distributed_Per_100k_18Plus': 79540,\n", " 'Administered_Dose1_Recip_65Plus': 67653,\n", " 'Administered_Dose1_Recip_65PlusPop_Pct': 68.2,\n", " 'Administered_65Plus': 123928,\n", " 'Admin_Per_100k_65Plus': 124954,\n", " 'Distributed_Per_100k_65Plus': 356905,\n", " 'Administered_Dose2_Recip': 100035,\n", " 'Administered_Dose2_Recip_18Plus': 99909,\n", " 'Administered_Dose2_Recip_18PlusPop_Pct': 22.5,\n", " 'Distributed_Moderna': 180000,\n", " 'Distributed_Pfizer': 164775,\n", " 'Distributed_Janssen': 9200,\n", " 'Distributed_Unk_Manuf': 0,\n", " 'Series_Complete_Moderna': 49919,\n", " 'Series_Complete_Pfizer': 50096,\n", " 'Series_Complete_Janssen': 4748,\n", " 'Series_Complete_Unk_Manuf': 20,\n", " 'Series_Complete_Moderna_18Plus': 49915,\n", " 'Series_Complete_Pfizer_18Plus': 49974,\n", " 'Series_Complete_Janssen_18Plus': 4747,\n", " 'Series_Complete_Unk_Manuf_18Plus': 20,\n", " 'Series_Complete_Moderna_65Plus': 28948,\n", " 'Series_Complete_Pfizer_65Plus': 26728,\n", " 'Series_Complete_Janssen_65Plus': 849,\n", " 'Series_Complete_Unk_Manuf_65Plus': 12,\n", " 'Series_Complete_Yes': 104783,\n", " 'Series_Complete_Pop_Pct': 18.1,\n", " 'Series_Complete_18Plus': 104656,\n", " 'Series_Complete_18PlusPop_Pct': 23.5,\n", " 'Series_Complete_65Plus': 56537,\n", " 'Series_Complete_65PlusPop_Pct': 57.0},\n", " {'Date': '2021-03-29',\n", " 'Location': 'LTC',\n", " 'ShortName': 'LTC',\n", " 'LongName': 'Long Term Care',\n", " 'Doses_Administered': 7718036,\n", " 'Administered_Dose1_Pop_Pct': 0.0,\n", " 'Administered_Dose2_Pop_Pct': 0.0,\n", " 'Administered_Fed_LTC': 0,\n", " 'Administered_Fed_LTC_Dose1': 0,\n", " 'Administered_Fed_LTC_Dose2': 0,\n", " 'Series_Complete_Yes': 0,\n", " 'Series_Complete_FedLTC': 0}]" ] }, "execution_count": 27, "metadata": {}, "output_type": "execute_result" } ], "source": [ "data[\"vaccination_data\"]" ] }, { "cell_type": "code", "execution_count": 28, "metadata": {}, "outputs": [], "source": [ "data = retrieve_vaccination_data()\n", "df = parse_vaccine_json_to_df(data)\n", "df.to_csv(\"vaccination_data.csv\")\n" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "## Parsing page\n", "\n", "https://magicseaweed.com/Baltrum-Surf-Report/1117/" ] }, { "cell_type": "code", "execution_count": 44, "metadata": {}, "outputs": [], "source": [ "import requests\n", "\n", "from bs4 import BeautifulSoup\n", "\n", "\n", "def retrieve_webpage_soup():\n", "# html = requests.get(\"https://magicseaweed.com/Baltrum-Surf-Report/1117/\").text\n", " html = requests.get(\"https://magicseaweed.com/St-Peter-Ording-Surf-Report/157/\").text\n", " soup = BeautifulSoup(html)\n", "\n", " return soup" ] }, { "cell_type": "code", "execution_count": 31, "metadata": {}, "outputs": [], "source": [ "soup = retrieve_webpage_soup()" ] }, { "cell_type": "code", "execution_count": 33, "metadata": {}, "outputs": [ { "data": { "text/plain": [ "[

Baltrum Surf Report and Forecast

]" ] }, "execution_count": 33, "metadata": {}, "output_type": "execute_result" } ], "source": [ "soup.find_all(\"h1\")" ] }, { "cell_type": "code", "execution_count": 38, "metadata": {}, "outputs": [ { "data": { "text/plain": [ "'Primary Swell'" ] }, "execution_count": 38, "metadata": {}, "output_type": "execute_result" } ], "source": [ "soup.find_all(\n", " \"li\", attrs={\"class\": \"list-group-item\"}\n", ")[0].find(\n", " \"div\", attrs={\"class\": \"list-group-title\"}\n", ").text.strip()" ] }, { "cell_type": "code", "execution_count": 40, "metadata": {}, "outputs": [ { "data": { "text/plain": [ "'3ft at 6s'" ] }, "execution_count": 40, "metadata": {}, "output_type": "execute_result" } ], "source": [ "soup.find_all(\n", " \"li\", attrs={\"class\": \"list-group-item\"}\n", ")[0].find(\n", " \"div\", attrs={\"class\": \"list-group-content\"}\n", ").text.strip()" ] }, { "cell_type": "code", "execution_count": 45, "metadata": {}, "outputs": [], "source": [ "def extract_swell(soup):\n", " list_group_items = soup.find_all(\"li\", attrs={\"class\": \"list-group-item\"})\n", "\n", " rows = []\n", " for item in list_group_items[:2]:\n", " out = {}\n", " out[\"variable\"] = item.find(\"div\", attrs={\"class\": \"list-group-title\"}).text.strip()\n", " out[\"value\"] = item.find(\"div\", attrs={\"class\": \"list-group-content\"}).text.strip()\n", " rows.append(out)\n", "\n", " return pd.DataFrame(rows)" ] }, { "cell_type": "code", "execution_count": 46, "metadata": {}, "outputs": [], "source": [ "soup = retrieve_webpage_soup()\n", "df = extract_swell(soup)\n", "\n", "df.to_csv(\"swell.csv\")\n" ] }, { "cell_type": "code", "execution_count": 47, "metadata": {}, "outputs": [ { "data": { "text/html": [ "
\n", "\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
variablevalue
0Primary Swell3.5ft at 6s
1Secondary Swell0.4ft at 14s
\n", "
" ], "text/plain": [ " variable value\n", "0 Primary Swell 3.5ft at 6s\n", "1 Secondary Swell 0.4ft at 14s" ] }, "execution_count": 47, "metadata": {}, "output_type": "execute_result" } ], "source": [ "df" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "**Downloading files**" ] }, { "cell_type": "code", "execution_count": 1, "metadata": {}, "outputs": [], "source": [ "import requests" ] }, { "cell_type": "code", "execution_count": 2, "metadata": {}, "outputs": [], "source": [ "res = requests.get(\n", " \"http://www.africau.edu/images/default/sample.pdf\"\n", ")" ] }, { "cell_type": "code", "execution_count": 52, "metadata": {}, "outputs": [], "source": [ "with open(\"test.pdf\", \"wb\") as f:\n", " f.write(res.content)\n" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "## Read content from pdf" ] }, { "cell_type": "code", "execution_count": 54, "metadata": {}, "outputs": [], "source": [ "import camelot" ] }, { "cell_type": "code", "execution_count": null, "metadata": {}, "outputs": [], "source": [ "# Bad because camelot reads tables rather than just text\n", "camelot.read_pdf(\"test.pdf\") " ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "https://pypi.org/project/PyMuPDF/" ] }, { "cell_type": "code", "execution_count": 1, "metadata": {}, "outputs": [], "source": [ "import fitz\n", "# fitz.read_pdf" ] }, { "cell_type": "code", "execution_count": 3, "metadata": {}, "outputs": [], "source": [ "doc = fitz.open(\"test.pdf\")" ] }, { "cell_type": "code", "execution_count": 5, "metadata": {}, "outputs": [ { "data": { "text/plain": [ "' A Simple PDF File \\n This is a small demonstration .pdf file - \\n just for use in the Virtual Mechanics tutorials. More text. And more \\n text. And more text. And more text. And more text. \\n And more text. And more text. And more text. And more text. And more \\n text. And more text. Boring, zzzzz. And more text. And more text. And \\n more text. And more text. And more text. And more text. And more text. \\n And more text. And more text. \\n And more text. And more text. And more text. And more text. And more \\n text. And more text. And more text. Even more. Continued on page 2 ...\\n'" ] }, "execution_count": 5, "metadata": {}, "output_type": "execute_result" } ], "source": [ "doc.get_page_text(0)" ] } ], "metadata": { "kernelspec": { "display_name": "Python 3", "language": "python", "name": "python3" }, "language_info": { "codemirror_mode": { "name": "ipython", "version": 3 }, "file_extension": ".py", "mimetype": "text/x-python", "name": "python", "nbconvert_exporter": "python", "pygments_lexer": "ipython3", "version": "3.8.3" } }, "nbformat": 4, "nbformat_minor": 4 }