HomeInsightsCase studyResearchPublic health
Research Firearm Injuryand Fatalityin Galveston, TXResearch FirearmInjury and Fatalityin Galveston, TX
Academic Implementation for Firearm Injury Researchwith the University of Texas Medical Branch (UTMB)
Client
Investigators at UTMB
A public health research team at the University of Texas Medical Branch
4
Flourish solutions deployed
100%
Digital research ecosystem
~5 hrs
From survey idea to live
65
Census tracts mapped
01 · Goal
Find where firearm injuries cluster, and what drives them
Our client wished to conduct a study to identify which public health and social variables were correlated with an increased risk of firearm injury, as well as identify firearm injury and fatality hotspots in Galveston, Texas, and surrounding areas.
What they needed
01
One central database
02
Injuries mapped to census tracts
03
A geospatial review tool
04
Survey and reward automation
05
Reporting from study data
02 · Solution
Patterns you cannot see in a spreadsheet
Interactive mapping turned complex datasets into something the team could read at a glance: incident clusters, service deserts, and areas with limited community engagement.
Records are grouped by county and census tract automatically, so geographic findings line up with local services.

These insights helped guide a core question:Where should the team focus resources to reduce harm and improve outcomes?
03 · What changed
What changed in the workflow
The same study, before and after the ecosystem was in place.
Before
Data scattered across separate sources
Grouping by county and tract done by hand in spreadsheets
Duplicates and errors found late, if at all
Survey rewards issued manually, one at a time
After
One central database receiving every source
Records grouped by county and census tract automatically
Anomalies flagged for staff review before analysis
Approved responses trigger digital gift cards automatically
04 · From insight to action
Reaching the households the data pointed to
Mailers with QR codes went to households in priority areas, directing residents to a brief online survey. Approved responses triggered digital gift cards automatically, turning insight into community-driven action quickly and at scale.
01
Priority areas identified from the map
02
QR-code mailers sent to households
03
Responses collected and reviewed centrally
04
Gift cards issued on approval
05 · Conclusion
Through Flourish’s Core, Mosaic, Pinpoint, and Agent Platform solutions, the client was able to quickly and cost effectively conduct their study within a fully digital ecosystem. This freed the investigators to spend more of their time on their study, rather than the processes and systems necessary to enable the research.
Learn how we can support you
No pressure. No big pitch deck. Just a conversation.
