Like most people, my family has gotten really into Wordle. We have a group chat where we share scores everyday and complain about particularly hard words. We had a good sense of who was doing better than others, but I wanted to make it a bit more competitive...
Wordles With Friends is a text-bot that automatically tracks all Wordle scores in any group text-chain based on the standard Wordle "Share" format. Once all members of the group chat have shared their scores for the day, the bot tabulates rolling scores and shares the current leaderboard.The bot awards points based on the number of guesses.
Include +1-507-WORDLES (+1-507-967-3537) in any group-text to start an automatic score tracker. (Or use it to track your own scores across devices)
IHCDA Indiana Housing Dashboard
On behalf of the Indiana Housing and Community Development Authority, I developed an interactive web-based dashboard to showcase metrics measuring relevant demographic and housing related trends for the whole state and across all counties.
Combined, these metrics form the baseline of a housing needs assessment meant to inform the public of the state of housing production and affordability where they live in order to highlight inequities and help to better promote racially equitable outcomes through the allocation of housing resources across the state.
An interactive dashboard featuring map and data visualizations of demographics and housing trends in the State of Indiana.
Miami DDA Interactive Office Market Report
Working on behalf of the Miami Downtown Development Authority I helped drive a shift away from a prior focus on PDF market reports to a new web-based format featuring an interactive scrolling narrative that combines the timeliness and dynamism of live dashboards with the nuance and critical lens of a research brief.
This modular structure contains a series of interactive graphics and charts that ingest and transform live data from a variety of sources and displays the outputs instantaneously accompanied by a static narrative that provides color to recent development trends and draws attention to the dynamism and potential of Downtown Miami.
A scrolling data visualization of the future of Miami’s downtown.
Mobile Location Data Analysis
To support a variety of projects across the country assessing the impact of COVID on small businesses, I’ve looked to the data vendor SafeGraph.
SafeGraph’s core product is a comprehensive dataset of "locations where consumers can spend money and/or time” which they enrich with anonymized mobile location data using a proprietary attribution model to estimate visitation trends for these places.
Purely a raw data vendor, SafeGraph leaves it up to you to make the data actionable. Using this data I’ve developed custom Python modules to conduct a variety of analyses such as:
understanding the catchment area of whole retail corridors, extrapolated to understand what share of visitors are local, regional, or out-of-market tourists.
charting the visitation trends of specific categories of retail to understand which sectors are driving recovery.
assessing the impact of interventions such as open streets on the performance of small businesses.
Using these analyses, HR&A is able to produce tailored assessments of the current state of local small businesses and develop specific recovery strategies targeting the areas of most need.
June 2020 - Present
Mapping the change in visitor-shed to Downtown Newark post-COVID. In many downtowns, closing – and then reopening – food and beverage establishments has had the greatest impact on foot traffic.
Zillow Data Scraper: Google Chrome Extension
In residential real estate analysis, data on trends in the single-family market is hard to come by. Public data from local jurisdictions are seldom easy to access and rarely are they comprehensive.
Zillow maintains an extensive database for most markets containing information about property sales that they source directly from the local municipal agencies responsible for recording real estate transactions.
In order to utilize this data which should be accessible to the general public, I’ve developed a custom data scraping script to assist in exporting search queries and packaged it as a Google Chrome extension — slapping a simple user interface on top of the script, allowing anyone to easily scrape data directly from Zillow’s website.