Healthcare & Medical Data
Analyze CDC, CMS, and clinical data. Locally.
Open million-row healthcare datasets in seconds. Run SQL queries on Medicare records, COVID mortality data, and chronic disease indicators. Nothing leaves your machine.
Open million-row healthcare datasets in seconds. Run SQL queries on Medicare records, COVID mortality data, and chronic disease indicators. Nothing leaves your machine.
If you work with public health data, you know the drill. You download a CSV from the CDC or CMS. It has 300K rows and 34 columns. You double-click it. Excel freezes. You wait. It crashes. You try again with a subset.
Or maybe you need Medicare prescriber data. 1.16 million rows, 84 columns, 534 MB. Excel won't even open it. You could load it into a database, but that means setting up PostgreSQL, writing import scripts, and waiting for ingestion. For a file you just want to look at.
PowerBI and Tableau need licenses, cloud accounts, and training. Jupyter needs Python, pandas, and terminal comfort. All of that for "show me the top 20 states by COVID deaths."
ColumnLens opens that 534 MB file in under 3 seconds. You get a table, SQL, charts, and export. No setup. No account. No data leaves your Mac.
This is the CDC's Provisional COVID-19 Death Counts by Week. 17 fields, weekly data from January 2020 through March 2026 for every US state. Downloaded as a 3.7 MB CSV from data.cdc.gov.
ColumnLens loaded it in 93 milliseconds. Sort by any column, filter by state, search across all fields. No import step, no schema definition, no waiting.
Switch to Chart View and select COVID-19 Deaths on the left axis, Influenza Deaths on the right. ColumnLens auto-aggregates by month and renders the dual-axis time series. You can see the seasonal patterns, the COVID waves, and the correlation between the two. Export as PNG for your report.
Write a SQL query directly against the data. No need to set up a database or learn a query DSL. ColumnLens runs DuckDB under the hood, so you get full SQL: GROUP BY, aggregations, window functions, CTEs. The query above ran in 1 millisecond.
These public datasets work perfectly with ColumnLens. Download the CSV, open it, start querying.
Provider-level drug utilization data. Prescribing patterns, opioid rates, demographics.
Health status, risk factors, and chronic disease metrics across all US states. Stratified by sex, race, and age.
Provisional death counts by week, state, with pneumonia and influenza co-occurrence.
Individual case data with demographics, hospitalization, ICU admission, and outcomes.
Full registry of 400K+ clinical trials. Filter by condition, phase, sponsor, status.
Medical device adverse event reports. Manufacturer, device, event type, patient outcome.
In healthcare, where your data lives matters. Cloud tools mean data transfer agreements, BAAs, and compliance reviews. ColumnLens sidesteps all of that because your data never leaves your machine.
Download a CDC dataset and open it in ColumnLens. No account required.