Project detail
FDA Device Intelligence Platform
A production-quality public-data product built around FDA AccessGUDID releases, Python ingestion, SQLite analytics, an Express API, and a dashboard experience.
Case study
Business Problem and Product Vision
Business Problem
FDA AccessGUDID is a rich public dataset, but the raw release archives are not packaged as a decision-support product. Supply chain, manufacturers, regulatory teams, and analysts need faster ways to understand listing velocity, manufacturer activity, product-code momentum, and recently published devices without manually parsing delimited files.
Product Vision
The product vision is a repeatable intelligence platform: download public FDA release ZIPs, preserve raw files for traceability, import delimited tables with Python, build SQLite analytics tables, expose Express API endpoints, and present executives and analysts with a dashboard for search, filtering, trend analysis, and impact-score review.
Users
Product Users
Live product
Interactive Dashboard
All confidential data is excluded. Portfolio demos use public data or fictional, portfolio-safe sample data to show KPI hierarchy, trust signals, filtering, and regulated-enterprise product workflows.
FDA AccessGUDID intelligence
Medical device market intelligence platform
API-first dashboard for public FDA AccessGUDID data. In local mode it consumes the Express API backed by SQLite; on Vercel it falls back to a portfolio-safe snapshot that mirrors the same product model.
Total device listings
5,152,799
SQLite analytics table
Manufacturers
184,276
Distinct company names
New listings this week
11,761
+2.3% WoW
High-impact listings
438
Directional product impact score
Risk/watchlist items
27
Recent listings needing review
Trend
Manufacturer activity ranking
Apex BioSystems
+18.4%1,842 total listings / 241 recent
Northstar Surgical
+11.7%1,326 total listings / 169 recent
Pulse River Medical
+9.2%1,108 total listings / 97 recent
Harbor Health Devices
+6.4%884 total listings / 74 recent
Meridian HealthTech
+5.8%742 total listings / 62 recent
Portfolio review queue
Supply chain and market intelligence teams can use the impact score to triage high-velocity categories before reviewing individual listings.
Manufacturer momentum
Recently active manufacturers help leaders understand where portfolio, contracting, or competitive monitoring should focus.
Governed public data product
Raw FDA archives remain traceable while analytics tables and API endpoints support repeatable dashboard consumption.
Listings explorer
Search by device name, manufacturer, catalog number, or DI. Sort and page through API-compatible records.
| Device | Manufacturer | Catalog / DI | Code / Class | Publish date | Status | Impact |
|---|---|---|---|---|---|---|
CardioSense Patch XT Ambulatory ECG monitor | Apex BioSystems | CS-XT-400 00819876543210 | DPS Class II | 2026-07-06 | In Commercial Distribution | 94.2 |
OrthoNav Precision Guide Surgical navigation system | Northstar Surgical | ON-PG-210 00345678901234 | HWT Class II | 2026-07-05 | In Commercial Distribution | 91.5 |
GlucoWave Mini Sensor Glucose monitoring system | Apex BioSystems | GW-M-108 00678901234567 | QBJ Class II | 2026-07-04 | In Commercial Distribution | 88.9 |
SonoFlow Vascular Catheter Cardiovascular catheter | Pulse River Medical | SF-V-88 00112233445566 | DQY Class III | 2026-07-03 | In Commercial Distribution | 86.7 |
Recently flagged listings
CardioSense Patch XT
94.2Apex BioSystems
High listing velocity in cardiac monitoring
NeuroMap Micro Array
84.1Northstar Surgical
Class III product with sparse category history
SonoFlow Vascular Catheter
86.7Pulse River Medical
Recent Class III vascular listing
Pipeline status
Last refresh
2026-07-06 07:50 ET
Database size
824 MB local SQLite artifact
Latest release
AccessGUDID weekly release 2026-07-06
Pipeline health
Healthy
| Run date | Files | Records | Scored | Status |
|---|---|---|---|---|
| 2026-07-06 | 31 | 5,152,799 | 699,830 | Completed |
| 2026-06-29 | 29 | 5,141,038 | 688,412 | Completed |
| 2026-06-22 | 33 | 5,132,904 | 676,905 | Completed |
FDA AccessGUDID
Public delimited release archive from FDA/NLM.
Weekly ZIP
Full and weekly releases preserved in raw storage.
Python import
Pipe-delimited files loaded and normalized.
SQLite analytics
Devices, counts, product baselines, impact scores.
Express API
Dashboard endpoints for filters and analytics.
Next dashboard
Portfolio surface with API-first live demo.
Architecture
Architecture
Reference architecture
Executive view of source, ingestion, analytics, governance, and dashboard delivery.
01
Source systems
FDA AccessGUDID delimited release archive
02
Ingestion
Python download and raw ZIP storage
03
Raw / staging
SQLite raw and staging tables
04
Quality / transform
Analytics tables, quality checks, impact scores
05
Product layer
Express REST API for dashboard queries
06
Experience
React / Next.js portfolio dashboard
Technical Stack
Data model, pipeline, and implementation
AccessGUDID release archives are downloaded into local raw ZIP storage, imported by a Python pipeline into SQLite, normalized into device and analytics tables, scored for directional market impact, and served through an Express API. The portfolio dashboard is API-first and uses a safe static snapshot when the local API is unavailable on Vercel.
Technology stack
Data Product Decisions
Governance, UX, and architecture choices
Execution Notes
Challenges solved, lessons learned, and future enhancements
Challenges Solved
- Parsing large public release archives while keeping raw data traceable and replayable.
- Normalizing inconsistent delimited source tables into dashboard-ready SQLite analytics views.
- Designing an API and dashboard that expose useful product signals without overclaiming what public data can prove.
Lessons Learned
- Public datasets still need product management: users need questions, workflows, trust signals, and refresh expectations.
- SQLite can be a strong analytics layer for local product demos when paired with clean API boundaries.
- Dashboard UX should make the pipeline understandable, not hide data freshness and lineage from users.
Future Enhancements
- Add recall, 510(k), PMA, De Novo, MAUDE, and adverse-event joins for stronger signal context.
- Publish scheduled GitHub Actions artifacts and API snapshots for repeatable portfolio demos.
- Add saved views, manufacturer profiles, and product-code alerting for analyst workflows.
What This Demonstrates
What this demonstrates to hiring managers
This project demonstrates data product management, ETL pipeline design, analytics engineering, API design, dashboard UX, data modeling, GitHub Actions automation, and enterprise architecture using a real public FDA data source.