ETL project that stores medicaid.gov drug utilization data in MySQL database and retrieves it using a SQL query. On a static web page, this project displays top ten drugs used, the number of prescriptions covered by Medicaid, and the total reimbursement amount for each drug. Only used data for Illinois and Alaska, but can use more.
Although fairly limited, one could further develop the project by adding plots to compare and contrast how Medicaid coverage occurs for these drugs in different states.
![Screenshot 2023-09-27 at 4 46 33 PM](https://private-user-images.githubusercontent.com/27388811/271123915-5c17f158-938b-4dfd-817e-6395db13879c.png?jwt=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpc3MiOiJnaXRodWIuY29tIiwiYXVkIjoicmF3LmdpdGh1YnVzZXJjb250ZW50LmNvbSIsImtleSI6ImtleTUiLCJleHAiOjE3MjA3NTY5MzUsIm5iZiI6MTcyMDc1NjYzNSwicGF0aCI6Ii8yNzM4ODgxMS8yNzExMjM5MTUtNWMxN2YxNTgtOTM4Yi00ZGZkLTgxN2UtNjM5NWRiMTM4NzljLnBuZz9YLUFtei1BbGdvcml0aG09QVdTNC1ITUFDLVNIQTI1NiZYLUFtei1DcmVkZW50aWFsPUFLSUFWQ09EWUxTQTUzUFFLNFpBJTJGMjAyNDA3MTIlMkZ1cy1lYXN0LTElMkZzMyUyRmF3czRfcmVxdWVzdCZYLUFtei1EYXRlPTIwMjQwNzEyVDAzNTcxNVomWC1BbXotRXhwaXJlcz0zMDAmWC1BbXotU2lnbmF0dXJlPWE1YTk2ZDQ0MmM0OTg5NDkxOTc3YWU2ODYxYzlhMDBlNjRiYmFiNzJlYTE0Nzg4ZTUyODVjZDZhM2NjNmMzOWEmWC1BbXotU2lnbmVkSGVhZGVycz1ob3N0JmFjdG9yX2lkPTAma2V5X2lkPTAmcmVwb19pZD0wIn0.igdEPPnWzwso-XsyO7p6qJf68m6etzRKv1_ESul-zEc)