
# Description

Statistics and research data was sourced from [Our World in Data](https://ourworldindata.org/covid-deaths) to visualize how covid-19 has spread over time and between countries. The data was explored and cleaned with Microsoft SQL and visualized in Tableau.

# Finished Product

<div id='image'>
	![Dashboard Screenshot](/images/covid-data-vis/dashboard_screenshot.png)
</div>

The interactive dashboard is hosted on Tableau Public and can be found [here](https://public.tableau.com/app/profile/kyle.rozic/viz/CovidVisualization_16319417831480/Dashboard1?publish=yes)

Covid-19 Data Dashboard


# TIFF-2019

Movie_Grabber.py extracts film information from https://2019.tiffr.com using `bs4` to build the variables 'Title', 'Director', 'Category', 'Link', and the metric 'Heart' to gauge the popularity of the title. A comma separated file 'movies.csv' is exported which can then be explored in any spreadsheet software.

'Text_Notification.py' takes a list of films and sends a text message using `twilio` when tickets become available for the title.

### Spreadsheet Sample

{/* <div style={{'text-align': 'center'}}> */}
<div>
	![Top 20 Films](/images/tiff-scraper/table_screenshot.png)
</div>
{/* <div style={{margin: '0rem 2.5rem'}}>
	<Image
		src={ '/images/tiff-scraper/table_screenshot.png' }
		alt='app'


	/>
</div> */}

Without this application, I would not have bought tickets for Jojo Rabbit, Knives Out, Parasite or The Lighthouse, which turned out to be great films at the festival.

Kyle Rozic

Excel

All Tags

Covid-19 Data Dashboard

TIFF Data Scraping with Organization in Excel