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.

Mosaic map of Galveston County census tracts, shaded by the number of firearm incidents from 2019 to 2024. Darker shading marks tracts with more incidents.

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.

  1. 01

    Priority areas identified from the map

  2. 02

    QR-code mailers sent to households

  3. 03

    Responses collected and reviewed centrally

  4. 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.