---
title: Data Hackathon Recap
description: "Is the Holiday Spirit Contagious?\n\nDuring Ippon's first Data Hackathon in December 2020, the Data Practice set out\nto find the effect of holidays on COVID-19 case count after typically large\ngatherings on holidays like the 4th of July or even non-official ones, like\nBlack Friday, and as a function"
image: https://blog.ippon.tech/hubfs/Imported_Blog_Media/Data-Hackathon-Recap-3.png
---
[Skip to main content](https://blog.ippon.tech/data-hackathon-recap#main)
[   ](https://ipponusa.com/)
- [Home](https://ipponusa.com)
- [Show submenu for About About](https://ipponusa.com/about-us)
- [Who We Are](https://ipponusa.com/who-we-are)
- [Careers](https://ipponusa.com/careers)
- [Show submenu for Our Partners Our Partners](https://ipponusa.com/our-partners/)
- [AWS](https://ipponusa.com/our-partners/aws/)
- [Snowflake](https://ipponusa.com/our-partners/snowflake/)
- [Databricks](https://ipponusa.com/our-partners/databricks/)
- [Microsoft](https://ipponusa.com/our-partners/microsoft/)
- [Show submenu for Services Services](https://ipponusa.com/services)
- [Snowflake](https://ipponusa.com/service/snowflake-concierge/)
- [Artificial Intelligence](https://ipponusa.com/service/artificial-intelligence/)
- [Data & Analytics](https://ipponusa.com/service/data-analytics/)
- [Cloud Strategy](https://ipponusa.com/service/cloud-strategy/)
- [Platform Modernization](https://ipponusa.com/service/platform-moderization/)
- [Product Innovation](https://ipponusa.com/service/product-innovation/)
- [Operating Model](https://ipponusa.com/service/operating-model/)
- [Blogs](https://blog.ippon.tech/)
- [Success Stories](https://ipponusa.com/success-stories/)
- [Show submenu for Resources Resources](https://ipponusa.com/resources/)
- [eBooks](https://ipponusa.com/ebooks/)
- [The Data Pour](https://info.ippon.tech/the-data-pour)
- [Videos & Webinars](https://info.ippon.tech/videos-and-webinars)
- [Media Center](https://ipponusa.com/media-center/)
Search
Open main navigation
Close main navigation
- [Home](https://ipponusa.com)
- Show submenu for About About
- About
- [About](https://ipponusa.com/about-us)
- [Who We Are](https://ipponusa.com/who-we-are)
- [Careers](https://ipponusa.com/careers)
- Show submenu for Our Partners Our Partners
- Our Partners
- [Our Partners](https://ipponusa.com/our-partners/)
- [AWS](https://ipponusa.com/our-partners/aws/)
- [Snowflake](https://ipponusa.com/our-partners/snowflake/)
- [Databricks](https://ipponusa.com/our-partners/databricks/)
- [Microsoft](https://ipponusa.com/our-partners/microsoft/)
- Show submenu for Services Services
- Services
- [Services](https://ipponusa.com/services)
- [Snowflake](https://ipponusa.com/service/snowflake-concierge/)
- [Artificial Intelligence](https://ipponusa.com/service/artificial-intelligence/)
- [Data & Analytics](https://ipponusa.com/service/data-analytics/)
- [Cloud Strategy](https://ipponusa.com/service/cloud-strategy/)
- [Platform Modernization](https://ipponusa.com/service/platform-moderization/)
- [Product Innovation](https://ipponusa.com/service/product-innovation/)
- [Operating Model](https://ipponusa.com/service/operating-model/)
- [Blogs](https://blog.ippon.tech/)
- [Success Stories](https://ipponusa.com/success-stories/)
- Show submenu for Resources Resources
- Resources
- [Resources](https://ipponusa.com/resources/)
- [eBooks](https://ipponusa.com/ebooks/)
- [The Data Pour](https://info.ippon.tech/the-data-pour)
- [Videos & Webinars](https://info.ippon.tech/videos-and-webinars)
- [Media Center](https://ipponusa.com/media-center/)
- Search
- [Contact Us](https://ipponusa.com/contact/)
[Contact Us](https://ipponusa.com/contact/)
# Data Hackathon Recap
by [Ramya Shetty](https://blog.ippon.tech/author/ramya-shetty)
February 10, 2021
[Data](https://blog.ippon.tech/tag/data/) [Hackathon](https://blog.ippon.tech/tag/hackathon/) [COVID 19](https://blog.ippon.tech/tag/covid-19/) [COVID](https://blog.ippon.tech/tag/covid/) [AWS](https://blog.ippon.tech/tag/aws/) [AWS S3](https://blog.ippon.tech/tag/aws-s3/) [AWS Lambda](https://blog.ippon.tech/tag/aws-lambda/) [AWS SNS](https://blog.ippon.tech/tag/aws-sns/) [AWS SQS](https://blog.ippon.tech/tag/aws-sqs/) [AWS Glue](https://blog.ippon.tech/tag/aws-glue/) [Scala](https://blog.ippon.tech/tag/scala/) [AWS Athena](https://blog.ippon.tech/tag/aws-athena/) [QuickSight](https://blog.ippon.tech/tag/quicksight/) [Python](https://blog.ippon.tech/tag/python/) [Data Analytics](https://blog.ippon.tech/tag/data-analytics/) [Data Architecture](https://blog.ippon.tech/tag/data-architecture/)
Is the Holiday Spirit Contagious?
During Ippon's first Data Hackathon in December 2020, the Data Practice set out to find the effect of holidays on COVID-19 case count after typically large gatherings on holidays like the 4th of July or even non-official ones, like Black Friday, and as a function of geo-location, voter registration, and local preventative measures.
We had two brief planning sessions to identify the objective, scope, tech stack, data sources, and to organize into smaller groups to tackle the work using, in true Hackathon spirit, a Python script developed on the spot! A high-level architecture included AWS S3, Lambda, SNS, SQS, and Glue using AWS Athena and QuickSight, and Scala.
Data sources included
- COVID-19 Case Counts by state for 2020 [Source](https://data.cdc.gov/Case-Surveillance/United-States-COVID-19-Cases-and-Deaths-by-State-o/9mfq-cb36?ref=blog.ippon.tech)
- Holiday List
- Voter Data Registration by State used for state population data
All hands-on keyboard work was saved for the Hackathon Day itself. A quick meeting with our Data Practice Manager, Peter Choe, where he reiterated the driving principles of *"Learn-Something-New-and-Have-Fun"* and we were off!
Teams worked in parallel using S3 datasets, a Lambda function to call APIs to get the most up-to-date COVID-19 data, and creating an SNS with the parameters to invoke the Glue job. The second team leveraged the CloudFormation template to create SQS messages. The third team used Glue crawler to parse out the JSON datasets and Glue in Scala to transform the datasets into the target data model. This team was the largest with the biggest scope of work. Meanwhile, the team working on visualization, created a mock test data for the QuickSight dashboard and then used Python Seaborn to show COVID-19 cases by state over time.
Google Meet with its breakout rooms and a Slack channel were crucial in helping the group and then smaller teams communicate and brought us together in this virtual Hackathon.
It was a data project compressed into one day with all the usual challenges, time being the biggest. Rome (and an entire data pipelines) was not built in a day! There were hiccups along the way (as always!) with datasets, visualization, and working with a tech stack that was new to some of us. But in true Ipponite fashion, we learned quickly, worked together as a team, adapted, and helped each other resolve issues.
The team shared their findings and process in a company-wide presentation to mark the end of an exciting Data Hackathon. The visualizations below show a definite uptick in the days following exposure on holidays like July 4th that involve large gatherings --
Comparing across states over time, we also notice the difference in the curve based on the state measures to flatten the curve --
During the Data Hackathon, we had the opportunity to spend the entire day learning new technologies, sharpening our skills, working together with colleagues from different projects as a team, and with lessons learnt and ideas to improve, we are all so excited for the next one. Stay tuned!
## Related Articles
##### [ Python • June 24, 2023 Python in Production (Part 5 of 5) 8 min read](https://blog.ippon.tech/python-in-production-part-5-of-5)
##### [ Python • May 17, 2023 Why CDOs should be investing in Snowpark 2 min read](https://blog.ippon.tech/why-cdos-should-be-investing-in-snowpark-2)
##### [ Python • March 30, 2023 Python in Production (Part 4 of 5) 9 min read](https://blog.ippon.tech/python-in-production-part)
### Comments
### Subscribe to Our Blog!
Stay informed with the latest insights and updates by signing up for our weekly blog newsletter – delivered straight to your inbox!
[Back to blog homepage »](https://blog.ippon.tech/)
Ippon is a consulting and expertise firm, who is convinced that technology is a source of progress for society. We help our clients leverage their digital assets to design an appropriate strategy and deploy their transformation roadmap at scale.
#### Navigation
- [Home](https://ipponusa.com/)
- [About](https://ipponusa.com/about-us/)
- [Services](https://ipponusa.com/services/)
- [Blogs](https://blog.ippon.tech/?__hstc=223043268.1036d82247623b329dfefe4e92697801.1714729179243.1714729179243.1714729179243.1&__hssc=223043268.2.1714729179244&__hsfp=803678701)
- [eBooks](https://ipponusa.com/ebooks/)
- [The Data Pour](https://info.ippon.tech/the-data-pour?__hstc=223043268.1036d82247623b329dfefe4e92697801.1714729179243.1714729179243.1714729179243.1&__hssc=223043268.2.1714729179244&__hsfp=803678701)
[Contact Us](https://ipponusa.com/contact/)
[Join Us](https://ipponusa.com/careers/)
#### Services
- [Data & Analytics](https://ipponusa.com/service/data-analytics/)
- [Cloud Strategy](https://ipponusa.com/service/cloud-strategy/)
- [Artificial Intelligence](https://ipponusa.com/service/artificial-intelligence/)
- [Operating Model](https://ipponusa.com/service/operating-model/)
- [Platform Modernization](https://ipponusa.com/service/platform-moderization/)
- [Product Innovation](https://ipponusa.com/service/product-innovation/)
#### Ippon International
- [France](https://fr.ippon.tech/?__hstc=223043268.1036d82247623b329dfefe4e92697801.1714729179243.1714729179243.1714729179243.1&__hssc=223043268.2.1714729179244&__hsfp=803678701)
- [Australia](https://au.ippon.tech/?__hstc=223043268.1036d82247623b329dfefe4e92697801.1714729179243.1714729179243.1714729179243.1&__hssc=223043268.2.1714729179244&__hsfp=803678701)
- #### Contact
- Ippon Technologies
[3431 West Leigh Street Richmond, VA 23230, USA](https://maps.app.goo.gl/RySm6SAwZnsxeiLz9)
- [(844) 477- 6687](tel:8444776687)
- [Sales@ipponusa.com](mailto:Sales@ipponusa.com)
©Copyright 2024 Ippon USA. All Rights Reserved. | [Terms and Conditions](https://ipponusa.com/privacy-policy/) | [Privacy Policy](https://ipponusa.com/privacy-policy/) | [Website by Skol Marketing](https://skolmarketing.com/)
```json
{
"@context" : "https://schema.org",
"@type" : "BlogPosting",
"author" : {
"@type" : "Person",
"name" : "Ramya Shetty",
"url" : "https://blog.ippon.tech/author/ramya-shetty"
},
"dateModified" : "2024-01-25T17:47:09.805Z",
"datePublished" : "2021-02-10T17:47:00.000Z",
"headline" : "Data Hackathon Recap",
"image" : [ "https://blog.ippon.tech/hubfs/Imported_Blog_Media/Data-Hackathon-Recap-3.png" ],
"mainEntityOfPage" : {
"@id" : "https://blog.ippon.tech/data-hackathon-recap",
"@type" : "WebPage"
},
"publisher" : {
"@type" : "Organization",
"logo" : {
"@type" : "ImageObject",
"url" : "https://blog.ippon.tech/hubfs/logo_SVG.svg"
},
"name" : "Ippon Technologies"
}
}
```