DataCheckpoint_Group054_WI24.ipynb

{
 "cells": [
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# COGS 108 - Data Checkpoint"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# Names\n",
    "\n",
    "- Ivan Chen \n",
    "- Leo Fleury\n",
    "- Daniel Yoon   \n",
    "- Fei He\n",
    "- HaoTing Huang"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# Research Question"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "What is the association between the amount of federal money a state receives for disaster relief and the factors, state GDP , number of disasters, and political leaning per year from 2017 to 2022?\n"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Background and Prior Work"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "The United States was born out of the colonies' desire to free from the tyranny of a government holding complete control over their commerce and rights. This wariness of a centralized governmental structure influences many aspects of how the government runs today, such as the separation of powers as labeled within the United States Constitution. The states can be considered, to an extent, nations within a nation. A study published in 2023 by smartasset<a name=\"cite_ref-1\"></a>[<sup>1</sup>](#cite_note-1) displays one aspect of this relationship - the depth to which states receive their funding from the federal government. But after decades of peace and prosperity as a singular united nation on the world stage - how many maintain this level of self-sufficiency in disasters?\n",
    "\n",
    "Another source we looked at was a data science project done by Money Geek that looked at which states were most reliant on federal aid. This project is relevant to ours because federal aid reduces the burden on a states budget and how much they can allocate towards disaster relief <a name=\"cite_ref-2\"></a>[<sup>2</sup>](#cite_note-2). To compute this, the team at Money Geek did not just look at total federal aid, but looked at federal funding as a percentage of state revenue and return on tax dollars which was a statistic showing how much the state got back for every dollar that they gave the government. What we learned from the metrics used (such as aid as a percentage of state revenue and return on tax dollars) is that often a data set will require a lot of cleaning and development of our own metrics before we can get the answer to our question. Our question being the relation between GDP and a state's amount spent on disaster relief. From the Money Geek project, we also saw how others incorporate graphs into their findings. Money geek did a very good job about making the main findings visible in the titles of their graphs and throughout their paragraphs. For example, one of the main findings from the data set was that states that get the most in federal aid are often republican states. Then, they created a illustrative bar chart to display this. \n",
    "\n",
    "Lastly, another project we found relevant from economy.com looking at how natural disasters affect national GDP, which we also found relevant to our project as it relates to natural disasters and uses GDP as a metric. However, our project takes a different angle by using GDP as a measure of a states self sufficiency and seeing how that correlates to how much disaster relief aid that state gets. Some relevant take-aways from the source were that natural disasters only have a minor impact on national GDP but can be very impactful for local GDP. For example, from economy.com calculations, real GDP growth for New Orleans fell 20% at an annual rate in the third quarter of 2005 after Katrina <a name=\"cite_ref-3\"></a>[<sup>3</sup>](#cite_note-3). \n",
    "\n",
    "1. <a name=\\\"cite_note-1\\\"></a> [^](#cite_ref-1) Jaclyn, D. (14 Apr. 2023)  Where Your Tax Dollars Go: States Most Dependent on the Federal Government – 2023 Study *smartasset* https://smartasset.com/data-studies/states-most-dependent-federal-government-2023 \n",
    "2. <a name=\\\"cite_note-2\\\"></a> [^](#cite_ref-2) MoneyGeek. (n.d.). States Most Reliant on the Federal Government., from https://www.moneygeek.com/living/states-most-reliant-federal-government/\n",
    "3. <a name=\\\"cite_note-3\\\"></a> [^](#cite_ref-3) Moody's Analytics. (n.d.). How Natural Disasters Affect US GDP. Economy.com., from https://www.economy.com/economicview/analysis/296804/How-Natural-Disasters-Affect-US-GDP"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# Hypothesis\n"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "We predict that in the United States in 2022, states with lower Gross Domestic Product (GDP) and historical Republican inclinations will be associated with an increase in federal disaster relief funding (as a percentage of the state's GDP). Conversely, states with higher GDP and historical Democratic ties will receive a lower percentage of their GDP in federal disaster relief funding. This study aims to analyze data over the past two decades to investigate these relationships, employing statistical analysis methods to understand the impact of economic status and political affiliation on disaster relief funding."
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# Data"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Data overview\n",
    "\n",
    "For each dataset include the following information\n",
    "- Dataset #1\n",
    "  - Dataset Name: Gross Domestic Product (GDP) by state\n",
    "  - Link to the dataset: https://usafacts.org/metrics/gross-domestic-product-gdp-by-state/?adjustment=None&timeGranularity=Yearly\n",
    "  - Number of observations: 45\n",
    "  - Number of variables: 51\n",
    "- Dataset #2 \n",
    "  - Dataset Name:\n",
    "  - Link to the dataset: https://www.bea.gov/data/gdp/gdp-state\n",
    "  - Number of observations:\n",
    "  - Number of variables:\n",
    "- Dataset #3\n",
    "  - Dataset Name: Emergency Management Performance Grants\n",
    "  - Link to dataset: https://www.fema.gov/openfema-data-page/emergency-management-performance-grants-v2\n",
    "  - Number of observations: 19615\n",
    "  - Number of variables: 9\n",
    "- Dataset #4\n",
    "  - Dataset Name: Public Assistance Funded Projects Detail\n",
    "  - Link to dataset: https://www.fema.gov/openfema-data-page/public-assistance-funded-projects-details-v1\n",
    "  - Number of observations: 805,572\n",
    "  - Number of variables: 22\n",
    "\n",
    "\n",
    "For our first dataset, GDP by state, is a dataset that gives us each states, GDP by year. The dataset includes data from 1977 - 2022, with the GDP of each state per year. The states are organized by alphabetical order and the year from 2022 down to 1977. As for data, majority of it are integers, which simplifies it a little. As for cleaning the dataset, we want to extract data from 2017 to 2022 only, which means we need to filter more than half the dataset.\n",
    "\n",
    "The second dataset by BEA, it is a dataset that provides the GDP by each state, seperated by region from most to least. This dataset includes each states GDP by quarter and takes inflation into account (2017 Dollar value). This dataset has many tables with valuable information, but we are focused on Tables 1, 3, and 5. Table 2 includes data about the Personal Income per state in the same format as Table 1. A few important varaibles in this dataset would include States, Regions, Quarters, and Total. These are the main variables that will help us analyze the data. Since the data is already well organized, the only things we would need to do is find missing data, if there is any, and understand why it may be missing. \n",
    "\n",
    "Our third dataset, Emergency Managment Performance Grants, is a detailed dataset of emergency funding each state as received. This dataset inlcudes every agency that has provided a specific state emergency funding. The data variables includes states, id, agency name, closing and opening date, and more. We are mainly looking for state, amount and reporting period (2017-2022), so we can focus on extracting those variables out. With the large amount of agency's in each state, it would be best to combine it all under the state, where we have the total number of funding per state. \n",
    "\n",
    "Our last dataset, Public Assistance Funded Projects Detail, is another very detailed dataset that has information about emergency funding. To be more exact, it has information about what kind of natural disasters, which county and it's county code, project amount, federal share obligated, total obligated, and more. For this project, knowing what specific natural disaster and how much a state got because of that isn't our main goal, so we would have to sort it by year, maintaining our goal of finding data from 2017-2022.\n",
    "\n",
    "\n",
    "With our datasets, it would be useful to look at them and understand if a state with a higher GDP gets more emergency funding overall. We want to see the relationships between the two and with the information we have, it would help prove our research question."
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Dataset #1 Emergency Management Performance Grants "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "C:\\Users\\leofl\\AppData\\Local\\Temp\\ipykernel_14600\\558211804.py:42: FutureWarning: The default value of numeric_only in DataFrameGroupBy.sum is deprecated. In a future version, numeric_only will default to False. Either specify numeric_only or select only columns which should be valid for the function.\n",
      "  df_grouped = df.groupby(by = ['state', 'reportingPeriod']).sum()\n"
     ]
    },
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>state</th>\n",
       "      <th>year</th>\n",
       "      <th>funding</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>AL</td>\n",
       "      <td>2019</td>\n",
       "      <td>5728503</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>AL</td>\n",
       "      <td>2020</td>\n",
       "      <td>5810021</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>AL</td>\n",
       "      <td>2021</td>\n",
       "      <td>7446681</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>AL</td>\n",
       "      <td>2022</td>\n",
       "      <td>6681181</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>AK</td>\n",
       "      <td>2019</td>\n",
       "      <td>3093229</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>195</th>\n",
       "      <td>WI</td>\n",
       "      <td>2022</td>\n",
       "      <td>7311711</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>196</th>\n",
       "      <td>WY</td>\n",
       "      <td>2019</td>\n",
       "      <td>2991828</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>197</th>\n",
       "      <td>WY</td>\n",
       "      <td>2020</td>\n",
       "      <td>3033266</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>198</th>\n",
       "      <td>WY</td>\n",
       "      <td>2021</td>\n",
       "      <td>3889834</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>199</th>\n",
       "      <td>WY</td>\n",
       "      <td>2022</td>\n",
       "      <td>3455841</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>200 rows × 3 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "    state  year  funding\n",
       "0      AL  2019  5728503\n",
       "1      AL  2020  5810021\n",
       "2      AL  2021  7446681\n",
       "3      AL  2022  6681181\n",
       "4      AK  2019  3093229\n",
       "..    ...   ...      ...\n",
       "195    WI  2022  7311711\n",
       "196    WY  2019  2991828\n",
       "197    WY  2020  3033266\n",
       "198    WY  2021  3889834\n",
       "199    WY  2022  3455841\n",
       "\n",
       "[200 rows x 3 columns]"
      ]
     },
     "execution_count": 1,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "import pandas as pd\n",
    "pd.set_option('display.max_rows', 10)\n",
    "\n",
    "url = 'Data/EmergencyManagementPerformanceGrants.csv'\n",
    "df = pd.read_csv(url)\n",
    "df['state'].unique()\n",
    "df_not_state = df['state'].str.contains('Puerto Rico|American Samoa|District of Columbia|Northern Mariana Islands|Guam|Virgin Islands')\n",
    "df = df[~df_not_state] #filter to only include US states\n",
    "df['state'].unique().size #check to see that our state column only has 50 values\n",
    "\n",
    "def standardize_reportingPeriod(string):\n",
    "    \n",
    "    string = string.lower().strip()\n",
    "    \n",
    "    if '2014' in string:\n",
    "        output = 2014\n",
    "    elif '2015' in string:\n",
    "        output = 2015\n",
    "    elif '2016' in string:\n",
    "        output = 2016\n",
    "    elif '2017' in string:\n",
    "        output = 2017\n",
    "    elif '2018' in string:\n",
    "        output = 2018\n",
    "    elif '2019' in string:\n",
    "        output = 2019\n",
    "    elif '2020' in string:\n",
    "        output = 2020\n",
    "    elif '2021' in string:\n",
    "        output = 2021\n",
    "    elif '2022' in string:\n",
    "        output = 2022\n",
    "    # Otherwise, if uncaught - keep as is\n",
    "    else:\n",
    "        output = string\n",
    "    \n",
    "    return output\n",
    "\n",
    "df['reportingPeriod'] = df['reportingPeriod'].apply(standardize_reportingPeriod)\n",
    "df = df.query('reportingPeriod >= 2019') #filter so lowest year is 2017 to match other data\n",
    "\n",
    "df_grouped = df.groupby(by = ['state', 'reportingPeriod']).sum()\n",
    "df_grouped = df_grouped.reset_index()\n",
    "df_grouped = df_grouped.rename(columns = {'reportingPeriod': 'year', 'fundingAmount' : 'funding'})\n",
    "df_grouped['funding'] = df_grouped['funding'].astype(int)\n",
    "\n",
    "us_state_to_abbrev = {\n",
    "    \"Alabama\": \"AL\", \"Alaska\": \"AK\", \"Arizona\": \"AZ\", \"Arkansas\": \"AR\", \"California\": \"CA\",\n",
    "    \"Colorado\": \"CO\", \"Connecticut\": \"CT\", \"Delaware\": \"DE\", \"Florida\": \"FL\", \"Georgia\": \"GA\",\n",
    "    \"Hawaii\": \"HI\", \"Idaho\": \"ID\", \"Illinois\": \"IL\", \"Indiana\": \"IN\", \"Iowa\": \"IA\",\n",
    "    \"Kansas\": \"KS\", \"Kentucky\": \"KY\", \"Louisiana\": \"LA\", \"Maine\": \"ME\", \"Maryland\": \"MD\",\n",
    "    \"Massachusetts\": \"MA\", \"Michigan\": \"MI\", \"Minnesota\": \"MN\", \"Mississippi\": \"MS\", \"Missouri\": \"MO\",\n",
    "    \"Montana\": \"MT\", \"Nebraska\": \"NE\", \"Nevada\": \"NV\", \"New hampshire\": \"NH\", \"New jersey\": \"NJ\",\n",
    "    \"New mexico\": \"NM\", \"New york\": \"NY\", \"North carolina\": \"NC\", \"North dakota\": \"ND\", \"Ohio\": \"OH\",\n",
    "    \"Oklahoma\": \"OK\", \"Oregon\": \"OR\", \"Pennsylvania\": \"PA\", \"Rhode island\": \"RI\", \"South carolina\": \"SC\",\n",
    "    \"South dakota\": \"SD\", \"Tennessee\": \"TN\", \"Texas\": \"TX\", \"Utah\": \"UT\", \"Vermont\": \"VT\",\n",
    "    \"Virginia\": \"VA\", \"Washington\": \"WA\", \"West virginia\": \"WV\", \"Wisconsin\": \"WI\", \"Wyoming\": \"WY\"\n",
    "}\n",
    "\n",
    "df_grouped['state'] = df_grouped['state'].str.lower().str.capitalize().map(us_state_to_abbrev)\n",
    "EMPG = df_grouped #naming to something we will remember\n",
    "EMPG['year'] = EMPG['year'].astype(int) # change to integers\n",
    "EMPG"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Dataset #2 Disaster Declarations by State"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>state</th>\n",
       "      <th>year</th>\n",
       "      <th>disasters</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>AL</td>\n",
       "      <td>2019</td>\n",
       "      <td>36</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>AL</td>\n",
       "      <td>2020</td>\n",
       "      <td>257</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>AL</td>\n",
       "      <td>2021</td>\n",
       "      <td>30</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>AL</td>\n",
       "      <td>2022</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>AK</td>\n",
       "      <td>2019</td>\n",
       "      <td>9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>195</th>\n",
       "      <td>WI</td>\n",
       "      <td>2022</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>196</th>\n",
       "      <td>WY</td>\n",
       "      <td>2019</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>197</th>\n",
       "      <td>WY</td>\n",
       "      <td>2020</td>\n",
       "      <td>51</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>198</th>\n",
       "      <td>WY</td>\n",
       "      <td>2021</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>199</th>\n",
       "      <td>WY</td>\n",
       "      <td>2022</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>200 rows × 3 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "    state  year  disasters\n",
       "0      AL  2019         36\n",
       "1      AL  2020        257\n",
       "2      AL  2021         30\n",
       "3      AL  2022          2\n",
       "4      AK  2019          9\n",
       "..    ...   ...        ...\n",
       "195    WI  2022          0\n",
       "196    WY  2019          0\n",
       "197    WY  2020         51\n",
       "198    WY  2021          0\n",
       "199    WY  2022          0\n",
       "\n",
       "[200 rows x 3 columns]"
      ]
     },
     "execution_count": 2,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "url2 = 'Data/DisasterDeclarationsSummaries.csv'\n",
    "df2= pd.read_csv(url2)\n",
    "\n",
    "df2 = df2.query('2023 > fyDeclared >= 2019 ') # make sure to include equals so 2017 included\n",
    "df2.sort_values(by = 'fyDeclared', ascending = True) # set to true so make sure have correct info\n",
    "df2 = df2.groupby(by = ['state', 'fyDeclared']).size().reset_index(name= 'disasters') # use size for num of disasters instead of sum & give column name\n",
    "df2 = df2.rename(columns={'fyDeclared': 'year'})\n",
    "valid_states = ['AL', 'AK', 'AZ', 'AR', 'CA', 'CO', 'CT', 'DE', 'FL', 'GA', \n",
    "                'HI', 'ID', 'IL', 'IN', 'IA', 'KS', 'KY', 'LA', 'ME', 'MD', \n",
    "                'MA', 'MI', 'MN', 'MS', 'MO', 'MT', 'NE', 'NV', 'NH', 'NJ', \n",
    "                'NM', 'NY', 'NC', 'ND', 'OH', 'OK', 'OR', 'PA', 'RI', 'SC', \n",
    "                'SD', 'TN', 'TX', 'UT', 'VT', 'VA', 'WA', 'WV', 'WI', 'WY']\n",
    "\n",
    "# Filter the DataFrame to only include rows where the state code is in the list of valid states\n",
    "df2 = df2[df2['state'].isin(valid_states)]\n",
    "df2\n",
    "\n",
    "# states didnt have disasters every year so we need to create columns with 0 for years no disasters were declared\n",
    "import itertools\n",
    "\n",
    "years = [2019, 2020, 2021, 2022]\n",
    "combinations = list(itertools.product(valid_states, years)) # Use itertools.product to get all combinations of states and years -- this works like a double sum where the valid states is fixed and its looking at all the states to match\n",
    "combinations\n",
    "df2_combinations = pd.DataFrame(combinations, columns=['state', 'year'])\n",
    "df2_combinations\n",
    "df2_merged = pd.merge(df2_combinations, df2, on = ['state', 'year'], how = 'left')# how on left so that df2_combinations has all rows saved and df2 added -- state and year pairs will get na values\n",
    "df2_merged['disasters'].fillna(0, inplace= True) #in place so a new data frame is not created and old one is kept\n",
    "df2_merged['disasters'] = df2_merged['disasters'].astype(int) # astype converts to a integer\n",
    "disasters =  df2_merged #naming to something we will remember\n",
    "disasters['year'] = disasters['year'].astype(int) # change to integers\n",
    "disasters"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Dataset #3 State Historical Political Leaning"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>state</th>\n",
       "      <th>year</th>\n",
       "      <th>party</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>AL</td>\n",
       "      <td>2019</td>\n",
       "      <td>REPUBLICAN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>AL</td>\n",
       "      <td>2020</td>\n",
       "      <td>REPUBLICAN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>AL</td>\n",
       "      <td>2021</td>\n",
       "      <td>REPUBLICAN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>AL</td>\n",
       "      <td>2022</td>\n",
       "      <td>REPUBLICAN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>AK</td>\n",
       "      <td>2019</td>\n",
       "      <td>REPUBLICAN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>199</th>\n",
       "      <td>WI</td>\n",
       "      <td>2022</td>\n",
       "      <td>REPUBLICAN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>200</th>\n",
       "      <td>WY</td>\n",
       "      <td>2019</td>\n",
       "      <td>REPUBLICAN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>201</th>\n",
       "      <td>WY</td>\n",
       "      <td>2020</td>\n",
       "      <td>REPUBLICAN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>202</th>\n",
       "      <td>WY</td>\n",
       "      <td>2021</td>\n",
       "      <td>REPUBLICAN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>203</th>\n",
       "      <td>WY</td>\n",
       "      <td>2022</td>\n",
       "      <td>REPUBLICAN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>204 rows × 3 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "    state  year       party\n",
       "0      AL  2019  REPUBLICAN\n",
       "1      AL  2020  REPUBLICAN\n",
       "2      AL  2021  REPUBLICAN\n",
       "3      AL  2022  REPUBLICAN\n",
       "4      AK  2019  REPUBLICAN\n",
       "..    ...   ...         ...\n",
       "199    WI  2022  REPUBLICAN\n",
       "200    WY  2019  REPUBLICAN\n",
       "201    WY  2020  REPUBLICAN\n",
       "202    WY  2021  REPUBLICAN\n",
       "203    WY  2022  REPUBLICAN\n",
       "\n",
       "[204 rows x 3 columns]"
      ]
     },
     "execution_count": 3,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "url3 = 'Data/1976-2022-house.csv'\n",
    "election_data= pd.read_csv(url3)\n",
    "\n",
    "elections_post_2017 = election_data[election_data['year'] > 2019]\n",
    "relevant_elections = elections_post_2017[elections_post_2017['party'].isin(['DEMOCRAT', 'REPUBLICAN'])]\n",
    "grouped_elections = relevant_elections.groupby(['state', 'year', 'party'])['candidatevotes'].sum().reset_index()\n",
    "winning_party = grouped_elections.sort_values('candidatevotes', ascending=False).drop_duplicates(['state', 'year'])\n",
    "winning_party = winning_party.sort_values(by = 'state')\n",
    "winning_party = winning_party.drop(columns= 'candidatevotes')\n",
    "\n",
    "\n",
    "#df.reindex -- confrom DF to a new index w. optional filling -- places NA in locastions having no value in teh previous index\n",
    "# we reindex the winning_party data frame to do this\n",
    "# we use pd.MultiIndex.from_product instead of iterools.prodcut(state, year) bcs it returns a list instead of a multiindex\n",
    "winning_party_indexed = winning_party.set_index(['state', 'year'])\n",
    "state = winning_party_indexed.index.levels[0]\n",
    "year = [2019,2020,2021,2022]\n",
    "multi_index = pd.MultiIndex.from_product([state, year])\n",
    "winning_party_indexed = winning_party_indexed.reindex(multi_index)\n",
    "winning_party_indexed_filled = winning_party_indexed.groupby(level=0).fillna(method='ffill').fillna(method='bfill').reset_index()\n",
    "winning_party_indexed_filled = winning_party_indexed_filled.rename(columns = {'level_1' : 'year'})\n",
    "\n",
    "#the rest of our data tables use state postal codes instead of the full names\n",
    "#using a dictionary I found on GitHub we can map these states to their postal codes\n",
    "us_state_to_abbrev = {\n",
    "    \"Alabama\": \"AL\", \"Alaska\": \"AK\", \"Arizona\": \"AZ\", \"Arkansas\": \"AR\", \"California\": \"CA\",\n",
    "    \"Colorado\": \"CO\", \"Connecticut\": \"CT\", \"Delaware\": \"DE\", \"Florida\": \"FL\", \"Georgia\": \"GA\",\n",
    "    \"Hawaii\": \"HI\", \"Idaho\": \"ID\", \"Illinois\": \"IL\", \"Indiana\": \"IN\", \"Iowa\": \"IA\",\n",
    "    \"Kansas\": \"KS\", \"Kentucky\": \"KY\", \"Louisiana\": \"LA\", \"Maine\": \"ME\", \"Maryland\": \"MD\",\n",
    "    \"Massachusetts\": \"MA\", \"Michigan\": \"MI\", \"Minnesota\": \"MN\", \"Mississippi\": \"MS\", \"Missouri\": \"MO\",\n",
    "    \"Montana\": \"MT\", \"Nebraska\": \"NE\", \"Nevada\": \"NV\", \"New hampshire\": \"NH\", \"New jersey\": \"NJ\",\n",
    "    \"New mexico\": \"NM\", \"New york\": \"NY\", \"North carolina\": \"NC\", \"North dakota\": \"ND\", \"Ohio\": \"OH\",\n",
    "    \"Oklahoma\": \"OK\", \"Oregon\": \"OR\", \"Pennsylvania\": \"PA\", \"Rhode island\": \"RI\", \"South carolina\": \"SC\",\n",
    "    \"South dakota\": \"SD\", \"Tennessee\": \"TN\", \"Texas\": \"TX\", \"Utah\": \"UT\", \"Vermont\": \"VT\",\n",
    "    \"Virginia\": \"VA\", \"Washington\": \"WA\", \"West virginia\": \"WV\", \"Wisconsin\": \"WI\", \"Wyoming\": \"WY\"\n",
    "}\n",
    "\n",
    "winning_party_indexed_filled['state'] = winning_party_indexed_filled['state'].str.lower().str.capitalize().map(us_state_to_abbrev)\n",
    "state_political_leaning = winning_party_indexed_filled #naming to something will actually remember\n",
    "state_political_leaning['year'] = state_political_leaning['year'].astype('int32')\n",
    "state_political_leaning\n"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Dataset #4 GDP by State"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>state</th>\n",
       "      <th>year</th>\n",
       "      <th>GDP</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>AL</td>\n",
       "      <td>2019</td>\n",
       "      <td>234526.4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>50</th>\n",
       "      <td>AL</td>\n",
       "      <td>2020</td>\n",
       "      <td>235118.3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>150</th>\n",
       "      <td>AL</td>\n",
       "      <td>2022</td>\n",
       "      <td>281569.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>100</th>\n",
       "      <td>AL</td>\n",
       "      <td>2021</td>\n",
       "      <td>257986.5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>151</th>\n",
       "      <td>AK</td>\n",
       "      <td>2022</td>\n",
       "      <td>65698.8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>48</th>\n",
       "      <td>WI</td>\n",
       "      <td>2019</td>\n",
       "      <td>347398.6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>99</th>\n",
       "      <td>WY</td>\n",
       "      <td>2020</td>\n",
       "      <td>36675.5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>49</th>\n",
       "      <td>WY</td>\n",
       "      <td>2019</td>\n",
       "      <td>39971.4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>149</th>\n",
       "      <td>WY</td>\n",
       "      <td>2021</td>\n",
       "      <td>42176.2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>199</th>\n",
       "      <td>WY</td>\n",
       "      <td>2022</td>\n",
       "      <td>49080.6</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>200 rows × 3 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "    state  year       GDP\n",
       "0      AL  2019  234526.4\n",
       "50     AL  2020  235118.3\n",
       "150    AL  2022  281569.0\n",
       "100    AL  2021  257986.5\n",
       "151    AK  2022   65698.8\n",
       "..    ...   ...       ...\n",
       "48     WI  2019  347398.6\n",
       "99     WY  2020   36675.5\n",
       "49     WY  2019   39971.4\n",
       "149    WY  2021   42176.2\n",
       "199    WY  2022   49080.6\n",
       "\n",
       "[200 rows x 3 columns]"
      ]
     },
     "execution_count": 4,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Log onto the BEA website (Bureau of Economic Analysis), the official site for government data.\n",
    "# Navigate to the \"Data\" section, select \"GDP,\" and then choose \"GDP by State.\"\n",
    "# Go to \"Interactive Data\" and select \"Interactive Tables: GDP by State.\"\n",
    "# Choose \"ANNUAL GROSS DOMESTIC PRODUCT (GDP) BY STATE,\" then \"SAGDP2 GDP in current dollars.\"\n",
    "# Select the United States, and view all statistics in the table.\n",
    "# In the resulting table, select the first row's line code where the description is \"all industry total.\"\n",
    "# The resulting table displays the GDP by state in millions of current dollars, with data collected from 2017 to 2022.\n",
    "\n",
    "url4 =  \"Data/GDP by state (2017-2022).csv\"\n",
    "\n",
    "df4 = pd.read_csv(url4, skiprows = 3) #skip first 3 rows because they are a description\n",
    "df4 = df4.drop(columns = ['GeoFips', '2017', '2018'])\n",
    "df4 = df4.rename(columns= {'GeoName': 'state'})\n",
    "df4_bad_GeoName = df4['state'].str.contains('District of Columbia|New England|nited States *|Mideast|Great Lakes|Plains|Southeast|Southwest|nan|Rocky Mountain|Far West').fillna(False) #dealing with NA values\n",
    "df4 = df4[~ df4_bad_GeoName] #this removes all the regions and territories we don't care about \n",
    "indexes_to_drop = df4.iloc[-4:].index #get the last 4 rows index using iloc\n",
    "df4 = df4.drop(indexes_to_drop)\n",
    "melted_df = pd.melt(df4, id_vars=['state'], value_vars=['2019', '2020', '2021', '2022'], var_name='year', value_name='amount')\n",
    "melted_df = melted_df.sort_values('state')\n",
    "melted_df\n",
    "\n",
    "#using the same code I used on the state leaning dat set we change the years to their postal codes\n",
    "\n",
    "us_state_to_abbrev = {\n",
    "    \"Alabama\": \"AL\", \"Alaska\": \"AK\", \"Arizona\": \"AZ\", \"Arkansas\": \"AR\", \"California\": \"CA\",\n",
    "    \"Colorado\": \"CO\", \"Connecticut\": \"CT\", \"Delaware\": \"DE\", \"Florida\": \"FL\", \"Georgia\": \"GA\",\n",
    "    \"Hawaii\": \"HI\", \"Idaho\": \"ID\", \"Illinois\": \"IL\", \"Indiana\": \"IN\", \"Iowa\": \"IA\",\n",
    "    \"Kansas\": \"KS\", \"Kentucky\": \"KY\", \"Louisiana\": \"LA\", \"Maine\": \"ME\", \"Maryland\": \"MD\",\n",
    "    \"Massachusetts\": \"MA\", \"Michigan\": \"MI\", \"Minnesota\": \"MN\", \"Mississippi\": \"MS\", \"Missouri\": \"MO\",\n",
    "    \"Montana\": \"MT\", \"Nebraska\": \"NE\", \"Nevada\": \"NV\", \"New Hampshire\": \"NH\", \"New Jersey\": \"NJ\",\n",
    "    \"New Mexico\": \"NM\", \"New York\": \"NY\", \"North Carolina\": \"NC\", \"North Dakota\": \"ND\", \"Ohio\": \"OH\",\n",
    "    \"Oklahoma\": \"OK\", \"Oregon\": \"OR\", \"Pennsylvania\": \"PA\", \"Rhode Island\": \"RI\", \"South Carolina\": \"SC\",\n",
    "    \"South Dakota\": \"SD\", \"Tennessee\": \"TN\", \"Texas\": \"TX\", \"Utah\": \"UT\", \"Vermont\": \"VT\",\n",
    "    \"Virginia\": \"VA\", \"Washington\": \"WA\", \"West Virginia\": \"WV\", \"Wisconsin\": \"WI\", \"Wyoming\": \"WY\",\n",
    "}\n",
    "\n",
    "melted_df\n",
    "melted_df['state'] = melted_df['state'].map(us_state_to_abbrev)\n",
    "gdp_by_state = melted_df.rename(columns = {'amount': 'GDP'})\n",
    "gdp_by_state #naming to something we will remember\n",
    "gdp_by_state['year'] = gdp_by_state['year'].astype(int) # change to integers\n",
    "gdp_by_state"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Merged Data Sets"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>state</th>\n",
       "      <th>year</th>\n",
       "      <th>disasters</th>\n",
       "      <th>funding</th>\n",
       "      <th>party</th>\n",
       "      <th>GDP</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>AL</td>\n",
       "      <td>2019</td>\n",
       "      <td>36</td>\n",
       "      <td>5728503</td>\n",
       "      <td>REPUBLICAN</td>\n",
       "      <td>234526.4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>AL</td>\n",
       "      <td>2020</td>\n",
       "      <td>257</td>\n",
       "      <td>5810021</td>\n",
       "      <td>REPUBLICAN</td>\n",
       "      <td>235118.3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>AL</td>\n",
       "      <td>2021</td>\n",
       "      <td>30</td>\n",
       "      <td>7446681</td>\n",
       "      <td>REPUBLICAN</td>\n",
       "      <td>257986.5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>AL</td>\n",
       "      <td>2022</td>\n",
       "      <td>2</td>\n",
       "      <td>6681181</td>\n",
       "      <td>REPUBLICAN</td>\n",
       "      <td>281569.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>AK</td>\n",
       "      <td>2019</td>\n",
       "      <td>9</td>\n",
       "      <td>3093229</td>\n",
       "      <td>REPUBLICAN</td>\n",
       "      <td>54469.9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>AK</td>\n",
       "      <td>2020</td>\n",
       "      <td>121</td>\n",
       "      <td>3132103</td>\n",
       "      <td>REPUBLICAN</td>\n",
       "      <td>51261.5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>AK</td>\n",
       "      <td>2021</td>\n",
       "      <td>5</td>\n",
       "      <td>4011830</td>\n",
       "      <td>REPUBLICAN</td>\n",
       "      <td>58646.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>AK</td>\n",
       "      <td>2022</td>\n",
       "      <td>16</td>\n",
       "      <td>3569365</td>\n",
       "      <td>REPUBLICAN</td>\n",
       "      <td>65698.8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>AZ</td>\n",
       "      <td>2019</td>\n",
       "      <td>3</td>\n",
       "      <td>7178562</td>\n",
       "      <td>REPUBLICAN</td>\n",
       "      <td>375545.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>AZ</td>\n",
       "      <td>2020</td>\n",
       "      <td>81</td>\n",
       "      <td>7334955</td>\n",
       "      <td>REPUBLICAN</td>\n",
       "      <td>386443.5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>AZ</td>\n",
       "      <td>2021</td>\n",
       "      <td>8</td>\n",
       "      <td>9495825</td>\n",
       "      <td>REPUBLICAN</td>\n",
       "      <td>432279.8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>AZ</td>\n",
       "      <td>2022</td>\n",
       "      <td>4</td>\n",
       "      <td>8223874</td>\n",
       "      <td>REPUBLICAN</td>\n",
       "      <td>475653.7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>AR</td>\n",
       "      <td>2019</td>\n",
       "      <td>36</td>\n",
       "      <td>4538597</td>\n",
       "      <td>REPUBLICAN</td>\n",
       "      <td>132637.2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>AR</td>\n",
       "      <td>2020</td>\n",
       "      <td>240</td>\n",
       "      <td>4599731</td>\n",
       "      <td>REPUBLICAN</td>\n",
       "      <td>135884.5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>AR</td>\n",
       "      <td>2021</td>\n",
       "      <td>0</td>\n",
       "      <td>5896620</td>\n",
       "      <td>REPUBLICAN</td>\n",
       "      <td>151931.9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>AR</td>\n",
       "      <td>2022</td>\n",
       "      <td>5</td>\n",
       "      <td>5221502</td>\n",
       "      <td>REPUBLICAN</td>\n",
       "      <td>165989.3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>CA</td>\n",
       "      <td>2019</td>\n",
       "      <td>44</td>\n",
       "      <td>27741329</td>\n",
       "      <td>DEMOCRAT</td>\n",
       "      <td>3062158.9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>CA</td>\n",
       "      <td>2020</td>\n",
       "      <td>175</td>\n",
       "      <td>28026736</td>\n",
       "      <td>DEMOCRAT</td>\n",
       "      <td>3068809.4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>CA</td>\n",
       "      <td>2021</td>\n",
       "      <td>37</td>\n",
       "      <td>35682527</td>\n",
       "      <td>DEMOCRAT</td>\n",
       "      <td>3416939.4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>CA</td>\n",
       "      <td>2022</td>\n",
       "      <td>7</td>\n",
       "      <td>31711205</td>\n",
       "      <td>DEMOCRAT</td>\n",
       "      <td>3641643.4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>CO</td>\n",
       "      <td>2019</td>\n",
       "      <td>0</td>\n",
       "      <td>6241339</td>\n",
       "      <td>DEMOCRAT</td>\n",
       "      <td>397701.6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>CO</td>\n",
       "      <td>2020</td>\n",
       "      <td>137</td>\n",
       "      <td>6359228</td>\n",
       "      <td>DEMOCRAT</td>\n",
       "      <td>397612.2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>CO</td>\n",
       "      <td>2021</td>\n",
       "      <td>4</td>\n",
       "      <td>8173089</td>\n",
       "      <td>DEMOCRAT</td>\n",
       "      <td>447051.7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>CO</td>\n",
       "      <td>2022</td>\n",
       "      <td>2</td>\n",
       "      <td>7224682</td>\n",
       "      <td>DEMOCRAT</td>\n",
       "      <td>491289.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>CT</td>\n",
       "      <td>2019</td>\n",
       "      <td>2</td>\n",
       "      <td>4893426</td>\n",
       "      <td>DEMOCRAT</td>\n",
       "      <td>285466.4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>CT</td>\n",
       "      <td>2020</td>\n",
       "      <td>31</td>\n",
       "      <td>4951179</td>\n",
       "      <td>DEMOCRAT</td>\n",
       "      <td>275801.9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>CT</td>\n",
       "      <td>2021</td>\n",
       "      <td>20</td>\n",
       "      <td>6328179</td>\n",
       "      <td>DEMOCRAT</td>\n",
       "      <td>295907.5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>CT</td>\n",
       "      <td>2022</td>\n",
       "      <td>7</td>\n",
       "      <td>5652584</td>\n",
       "      <td>DEMOCRAT</td>\n",
       "      <td>319344.8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>DE</td>\n",
       "      <td>2019</td>\n",
       "      <td>0</td>\n",
       "      <td>3239095</td>\n",
       "      <td>DEMOCRAT</td>\n",
       "      <td>78685.8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>DE</td>\n",
       "      <td>2020</td>\n",
       "      <td>6</td>\n",
       "      <td>3287592</td>\n",
       "      <td>DEMOCRAT</td>\n",
       "      <td>77615.1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30</th>\n",
       "      <td>DE</td>\n",
       "      <td>2021</td>\n",
       "      <td>2</td>\n",
       "      <td>4221388</td>\n",
       "      <td>DEMOCRAT</td>\n",
       "      <td>82952.8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>31</th>\n",
       "      <td>DE</td>\n",
       "      <td>2022</td>\n",
       "      <td>1</td>\n",
       "      <td>3755425</td>\n",
       "      <td>DEMOCRAT</td>\n",
       "      <td>90208.3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>32</th>\n",
       "      <td>FL</td>\n",
       "      <td>2019</td>\n",
       "      <td>126</td>\n",
       "      <td>16148783</td>\n",
       "      <td>REPUBLICAN</td>\n",
       "      <td>1127988.6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>33</th>\n",
       "      <td>FL</td>\n",
       "      <td>2020</td>\n",
       "      <td>213</td>\n",
       "      <td>16449788</td>\n",
       "      <td>REPUBLICAN</td>\n",
       "      <td>1140133.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>34</th>\n",
       "      <td>FL</td>\n",
       "      <td>2021</td>\n",
       "      <td>74</td>\n",
       "      <td>21227302</td>\n",
       "      <td>REPUBLICAN</td>\n",
       "      <td>1292391.3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>35</th>\n",
       "      <td>FL</td>\n",
       "      <td>2022</td>\n",
       "      <td>147</td>\n",
       "      <td>18657311</td>\n",
       "      <td>REPUBLICAN</td>\n",
       "      <td>1439065.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>36</th>\n",
       "      <td>GA</td>\n",
       "      <td>2019</td>\n",
       "      <td>189</td>\n",
       "      <td>9304231</td>\n",
       "      <td>REPUBLICAN</td>\n",
       "      <td>646939.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>37</th>\n",
       "      <td>GA</td>\n",
       "      <td>2020</td>\n",
       "      <td>320</td>\n",
       "      <td>9478184</td>\n",
       "      <td>REPUBLICAN</td>\n",
       "      <td>637930.6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38</th>\n",
       "      <td>GA</td>\n",
       "      <td>2021</td>\n",
       "      <td>30</td>\n",
       "      <td>12191504</td>\n",
       "      <td>REPUBLICAN</td>\n",
       "      <td>701606.1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>39</th>\n",
       "      <td>GA</td>\n",
       "      <td>2022</td>\n",
       "      <td>0</td>\n",
       "      <td>10805934</td>\n",
       "      <td>REPUBLICAN</td>\n",
       "      <td>767377.6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>40</th>\n",
       "      <td>HI</td>\n",
       "      <td>2019</td>\n",
       "      <td>0</td>\n",
       "      <td>3526926</td>\n",
       "      <td>DEMOCRAT</td>\n",
       "      <td>93356.2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>41</th>\n",
       "      <td>HI</td>\n",
       "      <td>2020</td>\n",
       "      <td>15</td>\n",
       "      <td>3571396</td>\n",
       "      <td>DEMOCRAT</td>\n",
       "      <td>84615.2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>42</th>\n",
       "      <td>HI</td>\n",
       "      <td>2021</td>\n",
       "      <td>2</td>\n",
       "      <td>4565823</td>\n",
       "      <td>DEMOCRAT</td>\n",
       "      <td>93089.8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>43</th>\n",
       "      <td>HI</td>\n",
       "      <td>2022</td>\n",
       "      <td>2</td>\n",
       "      <td>4092884</td>\n",
       "      <td>DEMOCRAT</td>\n",
       "      <td>101082.6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>44</th>\n",
       "      <td>ID</td>\n",
       "      <td>2019</td>\n",
       "      <td>6</td>\n",
       "      <td>3738816</td>\n",
       "      <td>REPUBLICAN</td>\n",
       "      <td>84550.2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>45</th>\n",
       "      <td>ID</td>\n",
       "      <td>2020</td>\n",
       "      <td>93</td>\n",
       "      <td>3805773</td>\n",
       "      <td>REPUBLICAN</td>\n",
       "      <td>88187.7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>46</th>\n",
       "      <td>ID</td>\n",
       "      <td>2021</td>\n",
       "      <td>6</td>\n",
       "      <td>4910021</td>\n",
       "      <td>REPUBLICAN</td>\n",
       "      <td>98792.8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>47</th>\n",
       "      <td>ID</td>\n",
       "      <td>2022</td>\n",
       "      <td>4</td>\n",
       "      <td>4371247</td>\n",
       "      <td>REPUBLICAN</td>\n",
       "      <td>110871.1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>48</th>\n",
       "      <td>IL</td>\n",
       "      <td>2019</td>\n",
       "      <td>28</td>\n",
       "      <td>10714815</td>\n",
       "      <td>DEMOCRAT</td>\n",
       "      <td>895800.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>49</th>\n",
       "      <td>IL</td>\n",
       "      <td>2020</td>\n",
       "      <td>204</td>\n",
       "      <td>10796972</td>\n",
       "      <td>DEMOCRAT</td>\n",
       "      <td>860747.5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>50</th>\n",
       "      <td>IL</td>\n",
       "      <td>2021</td>\n",
       "      <td>0</td>\n",
       "      <td>13730502</td>\n",
       "      <td>DEMOCRAT</td>\n",
       "      <td>943993.3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>51</th>\n",
       "      <td>IL</td>\n",
       "      <td>2022</td>\n",
       "      <td>14</td>\n",
       "      <td>12329319</td>\n",
       "      <td>DEMOCRAT</td>\n",
       "      <td>1025667.2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>52</th>\n",
       "      <td>IN</td>\n",
       "      <td>2019</td>\n",
       "      <td>0</td>\n",
       "      <td>6873938</td>\n",
       "      <td>REPUBLICAN</td>\n",
       "      <td>385446.2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>53</th>\n",
       "      <td>IN</td>\n",
       "      <td>2020</td>\n",
       "      <td>185</td>\n",
       "      <td>6984140</td>\n",
       "      <td>REPUBLICAN</td>\n",
       "      <td>377901.1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>54</th>\n",
       "      <td>IN</td>\n",
       "      <td>2021</td>\n",
       "      <td>0</td>\n",
       "      <td>8932441</td>\n",
       "      <td>REPUBLICAN</td>\n",
       "      <td>422951.9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>55</th>\n",
       "      <td>IN</td>\n",
       "      <td>2022</td>\n",
       "      <td>0</td>\n",
       "      <td>7955682</td>\n",
       "      <td>REPUBLICAN</td>\n",
       "      <td>470323.6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>56</th>\n",
       "      <td>IA</td>\n",
       "      <td>2019</td>\n",
       "      <td>81</td>\n",
       "      <td>4628961</td>\n",
       "      <td>REPUBLICAN</td>\n",
       "      <td>196085.1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>57</th>\n",
       "      <td>IA</td>\n",
       "      <td>2020</td>\n",
       "      <td>227</td>\n",
       "      <td>4687846</td>\n",
       "      <td>REPUBLICAN</td>\n",
       "      <td>199447.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>58</th>\n",
       "      <td>IA</td>\n",
       "      <td>2021</td>\n",
       "      <td>0</td>\n",
       "      <td>6005672</td>\n",
       "      <td>REPUBLICAN</td>\n",
       "      <td>220818.2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>59</th>\n",
       "      <td>IA</td>\n",
       "      <td>2022</td>\n",
       "      <td>25</td>\n",
       "      <td>5351202</td>\n",
       "      <td>REPUBLICAN</td>\n",
       "      <td>238342.3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>60</th>\n",
       "      <td>KS</td>\n",
       "      <td>2019</td>\n",
       "      <td>125</td>\n",
       "      <td>4473630</td>\n",
       "      <td>REPUBLICAN</td>\n",
       "      <td>176917.7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>61</th>\n",
       "      <td>KS</td>\n",
       "      <td>2020</td>\n",
       "      <td>233</td>\n",
       "      <td>4532655</td>\n",
       "      <td>REPUBLICAN</td>\n",
       "      <td>177720.6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>62</th>\n",
       "      <td>KS</td>\n",
       "      <td>2021</td>\n",
       "      <td>0</td>\n",
       "      <td>5800947</td>\n",
       "      <td>REPUBLICAN</td>\n",
       "      <td>191831.7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>63</th>\n",
       "      <td>KS</td>\n",
       "      <td>2022</td>\n",
       "      <td>77</td>\n",
       "      <td>5168094</td>\n",
       "      <td>REPUBLICAN</td>\n",
       "      <td>209326.1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>64</th>\n",
       "      <td>KY</td>\n",
       "      <td>2019</td>\n",
       "      <td>61</td>\n",
       "      <td>5462165</td>\n",
       "      <td>REPUBLICAN</td>\n",
       "      <td>220683.3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>65</th>\n",
       "      <td>KY</td>\n",
       "      <td>2020</td>\n",
       "      <td>267</td>\n",
       "      <td>5530451</td>\n",
       "      <td>REPUBLICAN</td>\n",
       "      <td>218755.2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>66</th>\n",
       "      <td>KY</td>\n",
       "      <td>2021</td>\n",
       "      <td>95</td>\n",
       "      <td>7082504</td>\n",
       "      <td>REPUBLICAN</td>\n",
       "      <td>237925.9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>67</th>\n",
       "      <td>KY</td>\n",
       "      <td>2022</td>\n",
       "      <td>72</td>\n",
       "      <td>6305199</td>\n",
       "      <td>REPUBLICAN</td>\n",
       "      <td>258981.2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>68</th>\n",
       "      <td>LA</td>\n",
       "      <td>2019</td>\n",
       "      <td>95</td>\n",
       "      <td>5583804</td>\n",
       "      <td>REPUBLICAN</td>\n",
       "      <td>257096.7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>69</th>\n",
       "      <td>LA</td>\n",
       "      <td>2020</td>\n",
       "      <td>400</td>\n",
       "      <td>5646719</td>\n",
       "      <td>REPUBLICAN</td>\n",
       "      <td>236135.9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>70</th>\n",
       "      <td>LA</td>\n",
       "      <td>2021</td>\n",
       "      <td>554</td>\n",
       "      <td>7220269</td>\n",
       "      <td>REPUBLICAN</td>\n",
       "      <td>263162.7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>71</th>\n",
       "      <td>LA</td>\n",
       "      <td>2022</td>\n",
       "      <td>0</td>\n",
       "      <td>6415373</td>\n",
       "      <td>REPUBLICAN</td>\n",
       "      <td>291951.9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>72</th>\n",
       "      <td>ME</td>\n",
       "      <td>2019</td>\n",
       "      <td>0</td>\n",
       "      <td>3474806</td>\n",
       "      <td>DEMOCRAT</td>\n",
       "      <td>69298.2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>73</th>\n",
       "      <td>ME</td>\n",
       "      <td>2020</td>\n",
       "      <td>623</td>\n",
       "      <td>3525395</td>\n",
       "      <td>DEMOCRAT</td>\n",
       "      <td>72091.6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>74</th>\n",
       "      <td>ME</td>\n",
       "      <td>2021</td>\n",
       "      <td>0</td>\n",
       "      <td>4519211</td>\n",
       "      <td>DEMOCRAT</td>\n",
       "      <td>78918.4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>75</th>\n",
       "      <td>ME</td>\n",
       "      <td>2022</td>\n",
       "      <td>3</td>\n",
       "      <td>4025503</td>\n",
       "      <td>DEMOCRAT</td>\n",
       "      <td>85801.2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>76</th>\n",
       "      <td>MD</td>\n",
       "      <td>2019</td>\n",
       "      <td>0</td>\n",
       "      <td>6461761</td>\n",
       "      <td>DEMOCRAT</td>\n",
       "      <td>419447.6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>77</th>\n",
       "      <td>MD</td>\n",
       "      <td>2020</td>\n",
       "      <td>48</td>\n",
       "      <td>6543427</td>\n",
       "      <td>DEMOCRAT</td>\n",
       "      <td>413417.7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>78</th>\n",
       "      <td>MD</td>\n",
       "      <td>2021</td>\n",
       "      <td>3</td>\n",
       "      <td>8376441</td>\n",
       "      <td>DEMOCRAT</td>\n",
       "      <td>446941.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>79</th>\n",
       "      <td>MD</td>\n",
       "      <td>2022</td>\n",
       "      <td>0</td>\n",
       "      <td>7517313</td>\n",
       "      <td>DEMOCRAT</td>\n",
       "      <td>480112.7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>80</th>\n",
       "      <td>MA</td>\n",
       "      <td>2019</td>\n",
       "      <td>0</td>\n",
       "      <td>7007447</td>\n",
       "      <td>DEMOCRAT</td>\n",
       "      <td>588617.5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>81</th>\n",
       "      <td>MA</td>\n",
       "      <td>2020</td>\n",
       "      <td>33</td>\n",
       "      <td>7087032</td>\n",
       "      <td>DEMOCRAT</td>\n",
       "      <td>589033.3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>82</th>\n",
       "      <td>MA</td>\n",
       "      <td>2021</td>\n",
       "      <td>1</td>\n",
       "      <td>9063165</td>\n",
       "      <td>DEMOCRAT</td>\n",
       "      <td>645434.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>83</th>\n",
       "      <td>MA</td>\n",
       "      <td>2022</td>\n",
       "      <td>5</td>\n",
       "      <td>8135699</td>\n",
       "      <td>DEMOCRAT</td>\n",
       "      <td>691460.6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>84</th>\n",
       "      <td>MI</td>\n",
       "      <td>2019</td>\n",
       "      <td>0</td>\n",
       "      <td>8971802</td>\n",
       "      <td>DEMOCRAT</td>\n",
       "      <td>536975.6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>85</th>\n",
       "      <td>MI</td>\n",
       "      <td>2020</td>\n",
       "      <td>195</td>\n",
       "      <td>9073402</td>\n",
       "      <td>DEMOCRAT</td>\n",
       "      <td>530231.1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>86</th>\n",
       "      <td>MI</td>\n",
       "      <td>2021</td>\n",
       "      <td>5</td>\n",
       "      <td>11582088</td>\n",
       "      <td>DEMOCRAT</td>\n",
       "      <td>576502.2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>87</th>\n",
       "      <td>MI</td>\n",
       "      <td>2022</td>\n",
       "      <td>0</td>\n",
       "      <td>10345728</td>\n",
       "      <td>DEMOCRAT</td>\n",
       "      <td>622562.7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>88</th>\n",
       "      <td>MN</td>\n",
       "      <td>2019</td>\n",
       "      <td>56</td>\n",
       "      <td>6187758</td>\n",
       "      <td>REPUBLICAN</td>\n",
       "      <td>383961.6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>89</th>\n",
       "      <td>MN</td>\n",
       "      <td>2020</td>\n",
       "      <td>214</td>\n",
       "      <td>6282770</td>\n",
       "      <td>REPUBLICAN</td>\n",
       "      <td>379438.7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>90</th>\n",
       "      <td>MN</td>\n",
       "      <td>2021</td>\n",
       "      <td>0</td>\n",
       "      <td>8049824</td>\n",
       "      <td>REPUBLICAN</td>\n",
       "      <td>413063.1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>91</th>\n",
       "      <td>MN</td>\n",
       "      <td>2022</td>\n",
       "      <td>65</td>\n",
       "      <td>7175934</td>\n",
       "      <td>REPUBLICAN</td>\n",
       "      <td>448032.4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>92</th>\n",
       "      <td>MS</td>\n",
       "      <td>2019</td>\n",
       "      <td>50</td>\n",
       "      <td>4521266</td>\n",
       "      <td>REPUBLICAN</td>\n",
       "      <td>115441.7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>93</th>\n",
       "      <td>MS</td>\n",
       "      <td>2020</td>\n",
       "      <td>301</td>\n",
       "      <td>4572833</td>\n",
       "      <td>REPUBLICAN</td>\n",
       "      <td>116193.1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>94</th>\n",
       "      <td>MS</td>\n",
       "      <td>2021</td>\n",
       "      <td>170</td>\n",
       "      <td>5835046</td>\n",
       "      <td>REPUBLICAN</td>\n",
       "      <td>128364.5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>95</th>\n",
       "      <td>MS</td>\n",
       "      <td>2022</td>\n",
       "      <td>83</td>\n",
       "      <td>5185063</td>\n",
       "      <td>REPUBLICAN</td>\n",
       "      <td>139976.4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>96</th>\n",
       "      <td>MO</td>\n",
       "      <td>2019</td>\n",
       "      <td>103</td>\n",
       "      <td>6514927</td>\n",
       "      <td>REPUBLICAN</td>\n",
       "      <td>334364.7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>97</th>\n",
       "      <td>MO</td>\n",
       "      <td>2020</td>\n",
       "      <td>249</td>\n",
       "      <td>6602323</td>\n",
       "      <td>REPUBLICAN</td>\n",
       "      <td>335278.3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>98</th>\n",
       "      <td>MO</td>\n",
       "      <td>2021</td>\n",
       "      <td>21</td>\n",
       "      <td>8454926</td>\n",
       "      <td>REPUBLICAN</td>\n",
       "      <td>365145.4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>99</th>\n",
       "      <td>MO</td>\n",
       "      <td>2022</td>\n",
       "      <td>11</td>\n",
       "      <td>7501134</td>\n",
       "      <td>REPUBLICAN</td>\n",
       "      <td>396889.9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>100</th>\n",
       "      <td>MT</td>\n",
       "      <td>2019</td>\n",
       "      <td>18</td>\n",
       "      <td>3299499</td>\n",
       "      <td>REPUBLICAN</td>\n",
       "      <td>52772.5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>101</th>\n",
       "      <td>MT</td>\n",
       "      <td>2020</td>\n",
       "      <td>138</td>\n",
       "      <td>3348585</td>\n",
       "      <td>REPUBLICAN</td>\n",
       "      <td>53130.7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>102</th>\n",
       "      <td>MT</td>\n",
       "      <td>2021</td>\n",
       "      <td>12</td>\n",
       "      <td>4298249</td>\n",
       "      <td>REPUBLICAN</td>\n",
       "      <td>59996.7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>103</th>\n",
       "      <td>MT</td>\n",
       "      <td>2022</td>\n",
       "      <td>7</td>\n",
       "      <td>3823796</td>\n",
       "      <td>REPUBLICAN</td>\n",
       "      <td>67071.9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>104</th>\n",
       "      <td>NE</td>\n",
       "      <td>2019</td>\n",
       "      <td>91</td>\n",
       "      <td>3849969</td>\n",
       "      <td>REPUBLICAN</td>\n",
       "      <td>132741.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>105</th>\n",
       "      <td>NE</td>\n",
       "      <td>2020</td>\n",
       "      <td>205</td>\n",
       "      <td>3904262</td>\n",
       "      <td>REPUBLICAN</td>\n",
       "      <td>135285.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>106</th>\n",
       "      <td>NE</td>\n",
       "      <td>2021</td>\n",
       "      <td>14</td>\n",
       "      <td>5000711</td>\n",
       "      <td>REPUBLICAN</td>\n",
       "      <td>149360.3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>107</th>\n",
       "      <td>NE</td>\n",
       "      <td>2022</td>\n",
       "      <td>48</td>\n",
       "      <td>4460012</td>\n",
       "      <td>REPUBLICAN</td>\n",
       "      <td>164933.9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>108</th>\n",
       "      <td>NV</td>\n",
       "      <td>2019</td>\n",
       "      <td>3</td>\n",
       "      <td>4551655</td>\n",
       "      <td>DEMOCRAT</td>\n",
       "      <td>184343.9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>109</th>\n",
       "      <td>NV</td>\n",
       "      <td>2020</td>\n",
       "      <td>93</td>\n",
       "      <td>4639757</td>\n",
       "      <td>DEMOCRAT</td>\n",
       "      <td>175982.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>110</th>\n",
       "      <td>NV</td>\n",
       "      <td>2021</td>\n",
       "      <td>3</td>\n",
       "      <td>5984930</td>\n",
       "      <td>DEMOCRAT</td>\n",
       "      <td>200127.3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>111</th>\n",
       "      <td>NV</td>\n",
       "      <td>2022</td>\n",
       "      <td>1</td>\n",
       "      <td>5289011</td>\n",
       "      <td>REPUBLICAN</td>\n",
       "      <td>222938.6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>112</th>\n",
       "      <td>NH</td>\n",
       "      <td>2019</td>\n",
       "      <td>1</td>\n",
       "      <td>3486269</td>\n",
       "      <td>DEMOCRAT</td>\n",
       "      <td>87472.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>113</th>\n",
       "      <td>NH</td>\n",
       "      <td>2020</td>\n",
       "      <td>20</td>\n",
       "      <td>3535345</td>\n",
       "      <td>DEMOCRAT</td>\n",
       "      <td>88589.4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>114</th>\n",
       "      <td>NH</td>\n",
       "      <td>2021</td>\n",
       "      <td>1</td>\n",
       "      <td>4532436</td>\n",
       "      <td>DEMOCRAT</td>\n",
       "      <td>99100.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>115</th>\n",
       "      <td>NH</td>\n",
       "      <td>2022</td>\n",
       "      <td>2</td>\n",
       "      <td>4036504</td>\n",
       "      <td>DEMOCRAT</td>\n",
       "      <td>105024.6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>116</th>\n",
       "      <td>NJ</td>\n",
       "      <td>2019</td>\n",
       "      <td>0</td>\n",
       "      <td>8281372</td>\n",
       "      <td>DEMOCRAT</td>\n",
       "      <td>641877.6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>117</th>\n",
       "      <td>NJ</td>\n",
       "      <td>2020</td>\n",
       "      <td>44</td>\n",
       "      <td>8364279</td>\n",
       "      <td>DEMOCRAT</td>\n",
       "      <td>630212.7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>118</th>\n",
       "      <td>NJ</td>\n",
       "      <td>2021</td>\n",
       "      <td>58</td>\n",
       "      <td>10693382</td>\n",
       "      <td>DEMOCRAT</td>\n",
       "      <td>692227.3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>119</th>\n",
       "      <td>NJ</td>\n",
       "      <td>2022</td>\n",
       "      <td>0</td>\n",
       "      <td>9774016</td>\n",
       "      <td>DEMOCRAT</td>\n",
       "      <td>754948.2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>120</th>\n",
       "      <td>NM</td>\n",
       "      <td>2019</td>\n",
       "      <td>1</td>\n",
       "      <td>3955470</td>\n",
       "      <td>DEMOCRAT</td>\n",
       "      <td>103869.2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>121</th>\n",
       "      <td>NM</td>\n",
       "      <td>2020</td>\n",
       "      <td>151</td>\n",
       "      <td>4008525</td>\n",
       "      <td>DEMOCRAT</td>\n",
       "      <td>100434.5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>122</th>\n",
       "      <td>NM</td>\n",
       "      <td>2021</td>\n",
       "      <td>1</td>\n",
       "      <td>5139050</td>\n",
       "      <td>DEMOCRAT</td>\n",
       "      <td>111730.6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>123</th>\n",
       "      <td>NM</td>\n",
       "      <td>2022</td>\n",
       "      <td>13</td>\n",
       "      <td>4573158</td>\n",
       "      <td>DEMOCRAT</td>\n",
       "      <td>125540.6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>124</th>\n",
       "      <td>NY</td>\n",
       "      <td>2019</td>\n",
       "      <td>7</td>\n",
       "      <td>15033121</td>\n",
       "      <td>DEMOCRAT</td>\n",
       "      <td>1793261.3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>125</th>\n",
       "      <td>NY</td>\n",
       "      <td>2020</td>\n",
       "      <td>148</td>\n",
       "      <td>15150401</td>\n",
       "      <td>DEMOCRAT</td>\n",
       "      <td>1766857.4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>126</th>\n",
       "      <td>NY</td>\n",
       "      <td>2021</td>\n",
       "      <td>61</td>\n",
       "      <td>19262861</td>\n",
       "      <td>DEMOCRAT</td>\n",
       "      <td>1911345.8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>127</th>\n",
       "      <td>NY</td>\n",
       "      <td>2022</td>\n",
       "      <td>9</td>\n",
       "      <td>17687743</td>\n",
       "      <td>DEMOCRAT</td>\n",
       "      <td>2048402.6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>128</th>\n",
       "      <td>NC</td>\n",
       "      <td>2019</td>\n",
       "      <td>122</td>\n",
       "      <td>9211806</td>\n",
       "      <td>DEMOCRAT</td>\n",
       "      <td>593126.9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>129</th>\n",
       "      <td>NC</td>\n",
       "      <td>2020</td>\n",
       "      <td>355</td>\n",
       "      <td>9395156</td>\n",
       "      <td>DEMOCRAT</td>\n",
       "      <td>601148.7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>130</th>\n",
       "      <td>NC</td>\n",
       "      <td>2021</td>\n",
       "      <td>46</td>\n",
       "      <td>12101967</td>\n",
       "      <td>DEMOCRAT</td>\n",
       "      <td>659529.3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>131</th>\n",
       "      <td>NC</td>\n",
       "      <td>2022</td>\n",
       "      <td>0</td>\n",
       "      <td>10608296</td>\n",
       "      <td>REPUBLICAN</td>\n",
       "      <td>715968.3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>132</th>\n",
       "      <td>ND</td>\n",
       "      <td>2019</td>\n",
       "      <td>19</td>\n",
       "      <td>3107603</td>\n",
       "      <td>REPUBLICAN</td>\n",
       "      <td>60516.3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>133</th>\n",
       "      <td>ND</td>\n",
       "      <td>2020</td>\n",
       "      <td>155</td>\n",
       "      <td>3151693</td>\n",
       "      <td>REPUBLICAN</td>\n",
       "      <td>55347.6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>134</th>\n",
       "      <td>ND</td>\n",
       "      <td>2021</td>\n",
       "      <td>15</td>\n",
       "      <td>4039824</td>\n",
       "      <td>REPUBLICAN</td>\n",
       "      <td>63208.6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>135</th>\n",
       "      <td>ND</td>\n",
       "      <td>2022</td>\n",
       "      <td>40</td>\n",
       "      <td>3602510</td>\n",
       "      <td>REPUBLICAN</td>\n",
       "      <td>72651.3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>136</th>\n",
       "      <td>OH</td>\n",
       "      <td>2019</td>\n",
       "      <td>33</td>\n",
       "      <td>10047089</td>\n",
       "      <td>REPUBLICAN</td>\n",
       "      <td>703127.8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>137</th>\n",
       "      <td>OH</td>\n",
       "      <td>2020</td>\n",
       "      <td>176</td>\n",
       "      <td>10166130</td>\n",
       "      <td>REPUBLICAN</td>\n",
       "      <td>692121.9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>138</th>\n",
       "      <td>OH</td>\n",
       "      <td>2021</td>\n",
       "      <td>0</td>\n",
       "      <td>12997432</td>\n",
       "      <td>REPUBLICAN</td>\n",
       "      <td>759626.2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>139</th>\n",
       "      <td>OH</td>\n",
       "      <td>2022</td>\n",
       "      <td>0</td>\n",
       "      <td>11594633</td>\n",
       "      <td>REPUBLICAN</td>\n",
       "      <td>825990.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>140</th>\n",
       "      <td>OK</td>\n",
       "      <td>2019</td>\n",
       "      <td>81</td>\n",
       "      <td>5128617</td>\n",
       "      <td>REPUBLICAN</td>\n",
       "      <td>205262.6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>141</th>\n",
       "      <td>OK</td>\n",
       "      <td>2020</td>\n",
       "      <td>242</td>\n",
       "      <td>5202614</td>\n",
       "      <td>REPUBLICAN</td>\n",
       "      <td>191653.5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>142</th>\n",
       "      <td>OK</td>\n",
       "      <td>2021</td>\n",
       "      <td>183</td>\n",
       "      <td>6675549</td>\n",
       "      <td>REPUBLICAN</td>\n",
       "      <td>217730.8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>143</th>\n",
       "      <td>OK</td>\n",
       "      <td>2022</td>\n",
       "      <td>9</td>\n",
       "      <td>5908881</td>\n",
       "      <td>REPUBLICAN</td>\n",
       "      <td>242738.5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>144</th>\n",
       "      <td>OR</td>\n",
       "      <td>2019</td>\n",
       "      <td>12</td>\n",
       "      <td>5285848</td>\n",
       "      <td>DEMOCRAT</td>\n",
       "      <td>248939.8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>145</th>\n",
       "      <td>OR</td>\n",
       "      <td>2020</td>\n",
       "      <td>139</td>\n",
       "      <td>5370008</td>\n",
       "      <td>DEMOCRAT</td>\n",
       "      <td>251855.8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>146</th>\n",
       "      <td>OR</td>\n",
       "      <td>2021</td>\n",
       "      <td>11</td>\n",
       "      <td>6889265</td>\n",
       "      <td>DEMOCRAT</td>\n",
       "      <td>275444.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>147</th>\n",
       "      <td>OR</td>\n",
       "      <td>2022</td>\n",
       "      <td>2</td>\n",
       "      <td>6110421</td>\n",
       "      <td>DEMOCRAT</td>\n",
       "      <td>297308.9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>148</th>\n",
       "      <td>PA</td>\n",
       "      <td>2019</td>\n",
       "      <td>11</td>\n",
       "      <td>10756709</td>\n",
       "      <td>REPUBLICAN</td>\n",
       "      <td>803078.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>149</th>\n",
       "      <td>PA</td>\n",
       "      <td>2020</td>\n",
       "      <td>134</td>\n",
       "      <td>10880531</td>\n",
       "      <td>REPUBLICAN</td>\n",
       "      <td>777427.1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>150</th>\n",
       "      <td>PA</td>\n",
       "      <td>2021</td>\n",
       "      <td>13</td>\n",
       "      <td>13890936</td>\n",
       "      <td>REPUBLICAN</td>\n",
       "      <td>844391.6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>151</th>\n",
       "      <td>PA</td>\n",
       "      <td>2022</td>\n",
       "      <td>0</td>\n",
       "      <td>12467250</td>\n",
       "      <td>REPUBLICAN</td>\n",
       "      <td>911813.3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>152</th>\n",
       "      <td>RI</td>\n",
       "      <td>2019</td>\n",
       "      <td>0</td>\n",
       "      <td>3296330</td>\n",
       "      <td>DEMOCRAT</td>\n",
       "      <td>62526.9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>153</th>\n",
       "      <td>RI</td>\n",
       "      <td>2020</td>\n",
       "      <td>13</td>\n",
       "      <td>3342540</td>\n",
       "      <td>DEMOCRAT</td>\n",
       "      <td>62054.2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>154</th>\n",
       "      <td>RI</td>\n",
       "      <td>2021</td>\n",
       "      <td>6</td>\n",
       "      <td>4279026</td>\n",
       "      <td>DEMOCRAT</td>\n",
       "      <td>67236.7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>155</th>\n",
       "      <td>RI</td>\n",
       "      <td>2022</td>\n",
       "      <td>6</td>\n",
       "      <td>3833335</td>\n",
       "      <td>DEMOCRAT</td>\n",
       "      <td>72771.4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>156</th>\n",
       "      <td>SC</td>\n",
       "      <td>2019</td>\n",
       "      <td>59</td>\n",
       "      <td>5853113</td>\n",
       "      <td>REPUBLICAN</td>\n",
       "      <td>248046.5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>157</th>\n",
       "      <td>SC</td>\n",
       "      <td>2020</td>\n",
       "      <td>114</td>\n",
       "      <td>5967634</td>\n",
       "      <td>REPUBLICAN</td>\n",
       "      <td>249482.2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>158</th>\n",
       "      <td>SC</td>\n",
       "      <td>2021</td>\n",
       "      <td>0</td>\n",
       "      <td>7689729</td>\n",
       "      <td>REPUBLICAN</td>\n",
       "      <td>271494.5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>159</th>\n",
       "      <td>SC</td>\n",
       "      <td>2022</td>\n",
       "      <td>46</td>\n",
       "      <td>6749457</td>\n",
       "      <td>REPUBLICAN</td>\n",
       "      <td>297546.3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>160</th>\n",
       "      <td>SD</td>\n",
       "      <td>2019</td>\n",
       "      <td>90</td>\n",
       "      <td>3185166</td>\n",
       "      <td>REPUBLICAN</td>\n",
       "      <td>55007.4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>161</th>\n",
       "      <td>SD</td>\n",
       "      <td>2020</td>\n",
       "      <td>319</td>\n",
       "      <td>3230393</td>\n",
       "      <td>REPUBLICAN</td>\n",
       "      <td>56162.9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>162</th>\n",
       "      <td>SD</td>\n",
       "      <td>2021</td>\n",
       "      <td>1</td>\n",
       "      <td>4144260</td>\n",
       "      <td>REPUBLICAN</td>\n",
       "      <td>62607.1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>163</th>\n",
       "      <td>SD</td>\n",
       "      <td>2022</td>\n",
       "      <td>29</td>\n",
       "      <td>3680524</td>\n",
       "      <td>REPUBLICAN</td>\n",
       "      <td>68781.7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>164</th>\n",
       "      <td>TN</td>\n",
       "      <td>2019</td>\n",
       "      <td>59</td>\n",
       "      <td>6923547</td>\n",
       "      <td>REPUBLICAN</td>\n",
       "      <td>385819.5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>165</th>\n",
       "      <td>TN</td>\n",
       "      <td>2020</td>\n",
       "      <td>235</td>\n",
       "      <td>7046379</td>\n",
       "      <td>REPUBLICAN</td>\n",
       "      <td>390172.6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>166</th>\n",
       "      <td>TN</td>\n",
       "      <td>2021</td>\n",
       "      <td>42</td>\n",
       "      <td>9057640</td>\n",
       "      <td>REPUBLICAN</td>\n",
       "      <td>438180.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>167</th>\n",
       "      <td>TN</td>\n",
       "      <td>2022</td>\n",
       "      <td>30</td>\n",
       "      <td>8049343</td>\n",
       "      <td>REPUBLICAN</td>\n",
       "      <td>485657.5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>168</th>\n",
       "      <td>TX</td>\n",
       "      <td>2019</td>\n",
       "      <td>40</td>\n",
       "      <td>20563652</td>\n",
       "      <td>REPUBLICAN</td>\n",
       "      <td>1860108.3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>169</th>\n",
       "      <td>TX</td>\n",
       "      <td>2020</td>\n",
       "      <td>616</td>\n",
       "      <td>21275940</td>\n",
       "      <td>REPUBLICAN</td>\n",
       "      <td>1798596.1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>170</th>\n",
       "      <td>TX</td>\n",
       "      <td>2021</td>\n",
       "      <td>513</td>\n",
       "      <td>27479523</td>\n",
       "      <td>REPUBLICAN</td>\n",
       "      <td>2087490.9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>171</th>\n",
       "      <td>TX</td>\n",
       "      <td>2022</td>\n",
       "      <td>9</td>\n",
       "      <td>24174249</td>\n",
       "      <td>REPUBLICAN</td>\n",
       "      <td>2402137.2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>172</th>\n",
       "      <td>UT</td>\n",
       "      <td>2019</td>\n",
       "      <td>1</td>\n",
       "      <td>4632111</td>\n",
       "      <td>REPUBLICAN</td>\n",
       "      <td>201285.4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>173</th>\n",
       "      <td>UT</td>\n",
       "      <td>2020</td>\n",
       "      <td>78</td>\n",
       "      <td>4720513</td>\n",
       "      <td>REPUBLICAN</td>\n",
       "      <td>205666.3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>174</th>\n",
       "      <td>UT</td>\n",
       "      <td>2021</td>\n",
       "      <td>8</td>\n",
       "      <td>6076427</td>\n",
       "      <td>REPUBLICAN</td>\n",
       "      <td>232125.1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>175</th>\n",
       "      <td>UT</td>\n",
       "      <td>2022</td>\n",
       "      <td>0</td>\n",
       "      <td>5410125</td>\n",
       "      <td>REPUBLICAN</td>\n",
       "      <td>256369.9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>176</th>\n",
       "      <td>VT</td>\n",
       "      <td>2019</td>\n",
       "      <td>6</td>\n",
       "      <td>3022662</td>\n",
       "      <td>DEMOCRAT</td>\n",
       "      <td>34628.1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>177</th>\n",
       "      <td>VT</td>\n",
       "      <td>2020</td>\n",
       "      <td>36</td>\n",
       "      <td>3063060</td>\n",
       "      <td>DEMOCRAT</td>\n",
       "      <td>34470.8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>178</th>\n",
       "      <td>VT</td>\n",
       "      <td>2021</td>\n",
       "      <td>16</td>\n",
       "      <td>3923458</td>\n",
       "      <td>DEMOCRAT</td>\n",
       "      <td>37593.5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>179</th>\n",
       "      <td>VT</td>\n",
       "      <td>2022</td>\n",
       "      <td>0</td>\n",
       "      <td>3503868</td>\n",
       "      <td>DEMOCRAT</td>\n",
       "      <td>40830.8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>180</th>\n",
       "      <td>VA</td>\n",
       "      <td>2019</td>\n",
       "      <td>68</td>\n",
       "      <td>8033214</td>\n",
       "      <td>DEMOCRAT</td>\n",
       "      <td>561989.6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>181</th>\n",
       "      <td>VA</td>\n",
       "      <td>2020</td>\n",
       "      <td>276</td>\n",
       "      <td>8140854</td>\n",
       "      <td>DEMOCRAT</td>\n",
       "      <td>565063.1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>182</th>\n",
       "      <td>VA</td>\n",
       "      <td>2021</td>\n",
       "      <td>33</td>\n",
       "      <td>10454187</td>\n",
       "      <td>DEMOCRAT</td>\n",
       "      <td>613920.3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>183</th>\n",
       "      <td>VA</td>\n",
       "      <td>2022</td>\n",
       "      <td>31</td>\n",
       "      <td>9297114</td>\n",
       "      <td>DEMOCRAT</td>\n",
       "      <td>663105.5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>184</th>\n",
       "      <td>WA</td>\n",
       "      <td>2019</td>\n",
       "      <td>8</td>\n",
       "      <td>7409645</td>\n",
       "      <td>DEMOCRAT</td>\n",
       "      <td>608966.4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>185</th>\n",
       "      <td>WA</td>\n",
       "      <td>2020</td>\n",
       "      <td>136</td>\n",
       "      <td>7550758</td>\n",
       "      <td>DEMOCRAT</td>\n",
       "      <td>621493.2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>186</th>\n",
       "      <td>WA</td>\n",
       "      <td>2021</td>\n",
       "      <td>38</td>\n",
       "      <td>9718956</td>\n",
       "      <td>DEMOCRAT</td>\n",
       "      <td>688631.9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>187</th>\n",
       "      <td>WA</td>\n",
       "      <td>2022</td>\n",
       "      <td>40</td>\n",
       "      <td>8625483</td>\n",
       "      <td>DEMOCRAT</td>\n",
       "      <td>738101.4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>188</th>\n",
       "      <td>WV</td>\n",
       "      <td>2019</td>\n",
       "      <td>5</td>\n",
       "      <td>3771594</td>\n",
       "      <td>REPUBLICAN</td>\n",
       "      <td>79883.8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>189</th>\n",
       "      <td>WV</td>\n",
       "      <td>2020</td>\n",
       "      <td>110</td>\n",
       "      <td>3812940</td>\n",
       "      <td>REPUBLICAN</td>\n",
       "      <td>76975.9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>190</th>\n",
       "      <td>WV</td>\n",
       "      <td>2021</td>\n",
       "      <td>12</td>\n",
       "      <td>4875490</td>\n",
       "      <td>REPUBLICAN</td>\n",
       "      <td>86509.9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>191</th>\n",
       "      <td>WV</td>\n",
       "      <td>2022</td>\n",
       "      <td>0</td>\n",
       "      <td>4338329</td>\n",
       "      <td>REPUBLICAN</td>\n",
       "      <td>97417.3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>192</th>\n",
       "      <td>WI</td>\n",
       "      <td>2019</td>\n",
       "      <td>34</td>\n",
       "      <td>6316264</td>\n",
       "      <td>REPUBLICAN</td>\n",
       "      <td>347398.6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>193</th>\n",
       "      <td>WI</td>\n",
       "      <td>2020</td>\n",
       "      <td>170</td>\n",
       "      <td>6400118</td>\n",
       "      <td>REPUBLICAN</td>\n",
       "      <td>343783.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>194</th>\n",
       "      <td>WI</td>\n",
       "      <td>2021</td>\n",
       "      <td>0</td>\n",
       "      <td>8193529</td>\n",
       "      <td>REPUBLICAN</td>\n",
       "      <td>369032.4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>195</th>\n",
       "      <td>WI</td>\n",
       "      <td>2022</td>\n",
       "      <td>0</td>\n",
       "      <td>7311711</td>\n",
       "      <td>REPUBLICAN</td>\n",
       "      <td>396209.3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>196</th>\n",
       "      <td>WY</td>\n",
       "      <td>2019</td>\n",
       "      <td>0</td>\n",
       "      <td>2991828</td>\n",
       "      <td>REPUBLICAN</td>\n",
       "      <td>39971.4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>197</th>\n",
       "      <td>WY</td>\n",
       "      <td>2020</td>\n",
       "      <td>51</td>\n",
       "      <td>3033266</td>\n",
       "      <td>REPUBLICAN</td>\n",
       "      <td>36675.5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>198</th>\n",
       "      <td>WY</td>\n",
       "      <td>2021</td>\n",
       "      <td>0</td>\n",
       "      <td>3889834</td>\n",
       "      <td>REPUBLICAN</td>\n",
       "      <td>42176.2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>199</th>\n",
       "      <td>WY</td>\n",
       "      <td>2022</td>\n",
       "      <td>0</td>\n",
       "      <td>3455841</td>\n",
       "      <td>REPUBLICAN</td>\n",
       "      <td>49080.6</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "    state  year  disasters   funding       party        GDP\n",
       "0      AL  2019         36   5728503  REPUBLICAN   234526.4\n",
       "1      AL  2020        257   5810021  REPUBLICAN   235118.3\n",
       "2      AL  2021         30   7446681  REPUBLICAN   257986.5\n",
       "3      AL  2022          2   6681181  REPUBLICAN   281569.0\n",
       "4      AK  2019          9   3093229  REPUBLICAN    54469.9\n",
       "5      AK  2020        121   3132103  REPUBLICAN    51261.5\n",
       "6      AK  2021          5   4011830  REPUBLICAN    58646.0\n",
       "7      AK  2022         16   3569365  REPUBLICAN    65698.8\n",
       "8      AZ  2019          3   7178562  REPUBLICAN   375545.0\n",
       "9      AZ  2020         81   7334955  REPUBLICAN   386443.5\n",
       "10     AZ  2021          8   9495825  REPUBLICAN   432279.8\n",
       "11     AZ  2022          4   8223874  REPUBLICAN   475653.7\n",
       "12     AR  2019         36   4538597  REPUBLICAN   132637.2\n",
       "13     AR  2020        240   4599731  REPUBLICAN   135884.5\n",
       "14     AR  2021          0   5896620  REPUBLICAN   151931.9\n",
       "15     AR  2022          5   5221502  REPUBLICAN   165989.3\n",
       "16     CA  2019         44  27741329    DEMOCRAT  3062158.9\n",
       "17     CA  2020        175  28026736    DEMOCRAT  3068809.4\n",
       "18     CA  2021         37  35682527    DEMOCRAT  3416939.4\n",
       "19     CA  2022          7  31711205    DEMOCRAT  3641643.4\n",
       "20     CO  2019          0   6241339    DEMOCRAT   397701.6\n",
       "21     CO  2020        137   6359228    DEMOCRAT   397612.2\n",
       "22     CO  2021          4   8173089    DEMOCRAT   447051.7\n",
       "23     CO  2022          2   7224682    DEMOCRAT   491289.0\n",
       "24     CT  2019          2   4893426    DEMOCRAT   285466.4\n",
       "25     CT  2020         31   4951179    DEMOCRAT   275801.9\n",
       "26     CT  2021         20   6328179    DEMOCRAT   295907.5\n",
       "27     CT  2022          7   5652584    DEMOCRAT   319344.8\n",
       "28     DE  2019          0   3239095    DEMOCRAT    78685.8\n",
       "29     DE  2020          6   3287592    DEMOCRAT    77615.1\n",
       "30     DE  2021          2   4221388    DEMOCRAT    82952.8\n",
       "31     DE  2022          1   3755425    DEMOCRAT    90208.3\n",
       "32     FL  2019        126  16148783  REPUBLICAN  1127988.6\n",
       "33     FL  2020        213  16449788  REPUBLICAN  1140133.0\n",
       "34     FL  2021         74  21227302  REPUBLICAN  1292391.3\n",
       "35     FL  2022        147  18657311  REPUBLICAN  1439065.0\n",
       "36     GA  2019        189   9304231  REPUBLICAN   646939.0\n",
       "37     GA  2020        320   9478184  REPUBLICAN   637930.6\n",
       "38     GA  2021         30  12191504  REPUBLICAN   701606.1\n",
       "39     GA  2022          0  10805934  REPUBLICAN   767377.6\n",
       "40     HI  2019          0   3526926    DEMOCRAT    93356.2\n",
       "41     HI  2020         15   3571396    DEMOCRAT    84615.2\n",
       "42     HI  2021          2   4565823    DEMOCRAT    93089.8\n",
       "43     HI  2022          2   4092884    DEMOCRAT   101082.6\n",
       "44     ID  2019          6   3738816  REPUBLICAN    84550.2\n",
       "45     ID  2020         93   3805773  REPUBLICAN    88187.7\n",
       "46     ID  2021          6   4910021  REPUBLICAN    98792.8\n",
       "47     ID  2022          4   4371247  REPUBLICAN   110871.1\n",
       "48     IL  2019         28  10714815    DEMOCRAT   895800.0\n",
       "49     IL  2020        204  10796972    DEMOCRAT   860747.5\n",
       "50     IL  2021          0  13730502    DEMOCRAT   943993.3\n",
       "51     IL  2022         14  12329319    DEMOCRAT  1025667.2\n",
       "52     IN  2019          0   6873938  REPUBLICAN   385446.2\n",
       "53     IN  2020        185   6984140  REPUBLICAN   377901.1\n",
       "54     IN  2021          0   8932441  REPUBLICAN   422951.9\n",
       "55     IN  2022          0   7955682  REPUBLICAN   470323.6\n",
       "56     IA  2019         81   4628961  REPUBLICAN   196085.1\n",
       "57     IA  2020        227   4687846  REPUBLICAN   199447.0\n",
       "58     IA  2021          0   6005672  REPUBLICAN   220818.2\n",
       "59     IA  2022         25   5351202  REPUBLICAN   238342.3\n",
       "60     KS  2019        125   4473630  REPUBLICAN   176917.7\n",
       "61     KS  2020        233   4532655  REPUBLICAN   177720.6\n",
       "62     KS  2021          0   5800947  REPUBLICAN   191831.7\n",
       "63     KS  2022         77   5168094  REPUBLICAN   209326.1\n",
       "64     KY  2019         61   5462165  REPUBLICAN   220683.3\n",
       "65     KY  2020        267   5530451  REPUBLICAN   218755.2\n",
       "66     KY  2021         95   7082504  REPUBLICAN   237925.9\n",
       "67     KY  2022         72   6305199  REPUBLICAN   258981.2\n",
       "68     LA  2019         95   5583804  REPUBLICAN   257096.7\n",
       "69     LA  2020        400   5646719  REPUBLICAN   236135.9\n",
       "70     LA  2021        554   7220269  REPUBLICAN   263162.7\n",
       "71     LA  2022          0   6415373  REPUBLICAN   291951.9\n",
       "72     ME  2019          0   3474806    DEMOCRAT    69298.2\n",
       "73     ME  2020        623   3525395    DEMOCRAT    72091.6\n",
       "74     ME  2021          0   4519211    DEMOCRAT    78918.4\n",
       "75     ME  2022          3   4025503    DEMOCRAT    85801.2\n",
       "76     MD  2019          0   6461761    DEMOCRAT   419447.6\n",
       "77     MD  2020         48   6543427    DEMOCRAT   413417.7\n",
       "78     MD  2021          3   8376441    DEMOCRAT   446941.0\n",
       "79     MD  2022          0   7517313    DEMOCRAT   480112.7\n",
       "80     MA  2019          0   7007447    DEMOCRAT   588617.5\n",
       "81     MA  2020         33   7087032    DEMOCRAT   589033.3\n",
       "82     MA  2021          1   9063165    DEMOCRAT   645434.0\n",
       "83     MA  2022          5   8135699    DEMOCRAT   691460.6\n",
       "84     MI  2019          0   8971802    DEMOCRAT   536975.6\n",
       "85     MI  2020        195   9073402    DEMOCRAT   530231.1\n",
       "86     MI  2021          5  11582088    DEMOCRAT   576502.2\n",
       "87     MI  2022          0  10345728    DEMOCRAT   622562.7\n",
       "88     MN  2019         56   6187758  REPUBLICAN   383961.6\n",
       "89     MN  2020        214   6282770  REPUBLICAN   379438.7\n",
       "90     MN  2021          0   8049824  REPUBLICAN   413063.1\n",
       "91     MN  2022         65   7175934  REPUBLICAN   448032.4\n",
       "92     MS  2019         50   4521266  REPUBLICAN   115441.7\n",
       "93     MS  2020        301   4572833  REPUBLICAN   116193.1\n",
       "94     MS  2021        170   5835046  REPUBLICAN   128364.5\n",
       "95     MS  2022         83   5185063  REPUBLICAN   139976.4\n",
       "96     MO  2019        103   6514927  REPUBLICAN   334364.7\n",
       "97     MO  2020        249   6602323  REPUBLICAN   335278.3\n",
       "98     MO  2021         21   8454926  REPUBLICAN   365145.4\n",
       "99     MO  2022         11   7501134  REPUBLICAN   396889.9\n",
       "100    MT  2019         18   3299499  REPUBLICAN    52772.5\n",
       "101    MT  2020        138   3348585  REPUBLICAN    53130.7\n",
       "102    MT  2021         12   4298249  REPUBLICAN    59996.7\n",
       "103    MT  2022          7   3823796  REPUBLICAN    67071.9\n",
       "104    NE  2019         91   3849969  REPUBLICAN   132741.0\n",
       "105    NE  2020        205   3904262  REPUBLICAN   135285.0\n",
       "106    NE  2021         14   5000711  REPUBLICAN   149360.3\n",
       "107    NE  2022         48   4460012  REPUBLICAN   164933.9\n",
       "108    NV  2019          3   4551655    DEMOCRAT   184343.9\n",
       "109    NV  2020         93   4639757    DEMOCRAT   175982.0\n",
       "110    NV  2021          3   5984930    DEMOCRAT   200127.3\n",
       "111    NV  2022          1   5289011  REPUBLICAN   222938.6\n",
       "112    NH  2019          1   3486269    DEMOCRAT    87472.0\n",
       "113    NH  2020         20   3535345    DEMOCRAT    88589.4\n",
       "114    NH  2021          1   4532436    DEMOCRAT    99100.0\n",
       "115    NH  2022          2   4036504    DEMOCRAT   105024.6\n",
       "116    NJ  2019          0   8281372    DEMOCRAT   641877.6\n",
       "117    NJ  2020         44   8364279    DEMOCRAT   630212.7\n",
       "118    NJ  2021         58  10693382    DEMOCRAT   692227.3\n",
       "119    NJ  2022          0   9774016    DEMOCRAT   754948.2\n",
       "120    NM  2019          1   3955470    DEMOCRAT   103869.2\n",
       "121    NM  2020        151   4008525    DEMOCRAT   100434.5\n",
       "122    NM  2021          1   5139050    DEMOCRAT   111730.6\n",
       "123    NM  2022         13   4573158    DEMOCRAT   125540.6\n",
       "124    NY  2019          7  15033121    DEMOCRAT  1793261.3\n",
       "125    NY  2020        148  15150401    DEMOCRAT  1766857.4\n",
       "126    NY  2021         61  19262861    DEMOCRAT  1911345.8\n",
       "127    NY  2022          9  17687743    DEMOCRAT  2048402.6\n",
       "128    NC  2019        122   9211806    DEMOCRAT   593126.9\n",
       "129    NC  2020        355   9395156    DEMOCRAT   601148.7\n",
       "130    NC  2021         46  12101967    DEMOCRAT   659529.3\n",
       "131    NC  2022          0  10608296  REPUBLICAN   715968.3\n",
       "132    ND  2019         19   3107603  REPUBLICAN    60516.3\n",
       "133    ND  2020        155   3151693  REPUBLICAN    55347.6\n",
       "134    ND  2021         15   4039824  REPUBLICAN    63208.6\n",
       "135    ND  2022         40   3602510  REPUBLICAN    72651.3\n",
       "136    OH  2019         33  10047089  REPUBLICAN   703127.8\n",
       "137    OH  2020        176  10166130  REPUBLICAN   692121.9\n",
       "138    OH  2021          0  12997432  REPUBLICAN   759626.2\n",
       "139    OH  2022          0  11594633  REPUBLICAN   825990.0\n",
       "140    OK  2019         81   5128617  REPUBLICAN   205262.6\n",
       "141    OK  2020        242   5202614  REPUBLICAN   191653.5\n",
       "142    OK  2021        183   6675549  REPUBLICAN   217730.8\n",
       "143    OK  2022          9   5908881  REPUBLICAN   242738.5\n",
       "144    OR  2019         12   5285848    DEMOCRAT   248939.8\n",
       "145    OR  2020        139   5370008    DEMOCRAT   251855.8\n",
       "146    OR  2021         11   6889265    DEMOCRAT   275444.0\n",
       "147    OR  2022          2   6110421    DEMOCRAT   297308.9\n",
       "148    PA  2019         11  10756709  REPUBLICAN   803078.0\n",
       "149    PA  2020        134  10880531  REPUBLICAN   777427.1\n",
       "150    PA  2021         13  13890936  REPUBLICAN   844391.6\n",
       "151    PA  2022          0  12467250  REPUBLICAN   911813.3\n",
       "152    RI  2019          0   3296330    DEMOCRAT    62526.9\n",
       "153    RI  2020         13   3342540    DEMOCRAT    62054.2\n",
       "154    RI  2021          6   4279026    DEMOCRAT    67236.7\n",
       "155    RI  2022          6   3833335    DEMOCRAT    72771.4\n",
       "156    SC  2019         59   5853113  REPUBLICAN   248046.5\n",
       "157    SC  2020        114   5967634  REPUBLICAN   249482.2\n",
       "158    SC  2021          0   7689729  REPUBLICAN   271494.5\n",
       "159    SC  2022         46   6749457  REPUBLICAN   297546.3\n",
       "160    SD  2019         90   3185166  REPUBLICAN    55007.4\n",
       "161    SD  2020        319   3230393  REPUBLICAN    56162.9\n",
       "162    SD  2021          1   4144260  REPUBLICAN    62607.1\n",
       "163    SD  2022         29   3680524  REPUBLICAN    68781.7\n",
       "164    TN  2019         59   6923547  REPUBLICAN   385819.5\n",
       "165    TN  2020        235   7046379  REPUBLICAN   390172.6\n",
       "166    TN  2021         42   9057640  REPUBLICAN   438180.0\n",
       "167    TN  2022         30   8049343  REPUBLICAN   485657.5\n",
       "168    TX  2019         40  20563652  REPUBLICAN  1860108.3\n",
       "169    TX  2020        616  21275940  REPUBLICAN  1798596.1\n",
       "170    TX  2021        513  27479523  REPUBLICAN  2087490.9\n",
       "171    TX  2022          9  24174249  REPUBLICAN  2402137.2\n",
       "172    UT  2019          1   4632111  REPUBLICAN   201285.4\n",
       "173    UT  2020         78   4720513  REPUBLICAN   205666.3\n",
       "174    UT  2021          8   6076427  REPUBLICAN   232125.1\n",
       "175    UT  2022          0   5410125  REPUBLICAN   256369.9\n",
       "176    VT  2019          6   3022662    DEMOCRAT    34628.1\n",
       "177    VT  2020         36   3063060    DEMOCRAT    34470.8\n",
       "178    VT  2021         16   3923458    DEMOCRAT    37593.5\n",
       "179    VT  2022          0   3503868    DEMOCRAT    40830.8\n",
       "180    VA  2019         68   8033214    DEMOCRAT   561989.6\n",
       "181    VA  2020        276   8140854    DEMOCRAT   565063.1\n",
       "182    VA  2021         33  10454187    DEMOCRAT   613920.3\n",
       "183    VA  2022         31   9297114    DEMOCRAT   663105.5\n",
       "184    WA  2019          8   7409645    DEMOCRAT   608966.4\n",
       "185    WA  2020        136   7550758    DEMOCRAT   621493.2\n",
       "186    WA  2021         38   9718956    DEMOCRAT   688631.9\n",
       "187    WA  2022         40   8625483    DEMOCRAT   738101.4\n",
       "188    WV  2019          5   3771594  REPUBLICAN    79883.8\n",
       "189    WV  2020        110   3812940  REPUBLICAN    76975.9\n",
       "190    WV  2021         12   4875490  REPUBLICAN    86509.9\n",
       "191    WV  2022          0   4338329  REPUBLICAN    97417.3\n",
       "192    WI  2019         34   6316264  REPUBLICAN   347398.6\n",
       "193    WI  2020        170   6400118  REPUBLICAN   343783.0\n",
       "194    WI  2021          0   8193529  REPUBLICAN   369032.4\n",
       "195    WI  2022          0   7311711  REPUBLICAN   396209.3\n",
       "196    WY  2019          0   2991828  REPUBLICAN    39971.4\n",
       "197    WY  2020         51   3033266  REPUBLICAN    36675.5\n",
       "198    WY  2021          0   3889834  REPUBLICAN    42176.2\n",
       "199    WY  2022          0   3455841  REPUBLICAN    49080.6"
      ]
     },
     "execution_count": 7,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#the data sets we have now are EMPG, disasters, state_political_leaning, & gdp_by_state \n",
    "#we have individually pre procesesed every data frame so that merging will be a smooth process\n",
    "pd.set_option('display.max_rows', None)\n",
    "master_df = disasters.merge(EMPG)\n",
    "master_df = master_df.merge(state_political_leaning)\n",
    "master_df = master_df.merge(gdp_by_state)\n",
    "master_df"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# Ethics & Privacy"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Our data is sourced from governmental agencies and nonprofit organizations such as USA Facts, FEMA, and BEA.gov. These sources aim to provide a strictly non-partisan outlook on the actions of the federal government in an effort to promote a pillar of government so necessary to any government's foundation - transparency. These sources do not contain any private data, as any data determined to be accessible to the public by the Freedom of Information act forgoes data which would be deemed a breach of privacy. Our research does not aim to harm any particular population within a county or state, as it is focused on compiling and analyzing the financial aspect of the relationship between state and federal governments. Moreover, decisions on federal funding are guided by uniform, pre-established standards, and commitments, all found within the constitution of the United States. Our compilation of statistical information lacks sufficient means to overturn the nature of this centuries old relation. Electoral data analyzed is on a strictly state-level basis, meaning that we do not utilize a voter's personal information. "
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# Team Expectations "
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "\n",
    "* *Be Communicative* - Communicate any difficulties ahead of time! If assistance is needed, or maybe if a team member is unable to do/finish what they need to do, communicating it ahead of time will allow others to help expedite the process.\n",
    "\n",
    "* *Contribute Fairly* - Uphold the responsibilities assigned or taken up by each individual group member, but also keep in mind to make key decisions as a group. \n",
    "\n",
    "* *Communication Guideline* - Communicate primarily through Discord and attend scheduled weekly/bi-weekly calls. Most, if not all calls will be virtual, but be present and be involved in the project."
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# Project Timeline Proposal"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "| Meeting Date | Meeting Time | Completed Before Meeting      | Discuss at Meeting                                                                 |\n",
    "|--------------|--------------|-------------------------------|------------------------------------------------------------------------------------|\n",
    "| 2/4          | 6 PM         | Read Previous COGS 108 Projects | Discussed the strengths and weaknesses of two COGS 108 projects made by previous groups and noted things to keep and leave in our projects. |\n",
    "| 2/8          | 3 PM         | Research Question              | Discuss hypothesis, research question, project timeline proposal                   |\n",
    "| 2/11         | 6 PM         | Work on Project Proposal       | Discuss hypothesis, research question, project timeline proposal                   |\n",
    "| 2/19         | 7 PM         | Find Relevant Data             | Choose which data we found best fits our research purposes                         |\n",
    "| 2/22         | 8:30 PM      | Categorize Relevant Data       | Discuss what kind of further questions we want to ask within our research question |\n",
    "| 3/4          | 7 PM         | Work on individual categories  | Review and discuss progress                                                        |\n",
    "| 3/7          | 7 PM         | Work on individual categories  | Review and discuss progress                                                        |\n",
    "| 3/14         | 7 PM         | Work on individual categories  | Review and discuss progress                                                        |\n",
    "| 3/17         | 7 PM         | Work on individual categories  | Review and discuss progress                                                        |\n",
    "| 3/20         | Before 11:59\n"
   ]
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3.9.6 64-bit",
   "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.9.6"
  },
  "vscode": {
   "interpreter": {
    "hash": "31f2aee4e71d21fbe5cf8b01ff0e069b9275f58929596ceb00d14d90e3e16cd6"
   }
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}