Raw Reddit posts and comments saved in SQLite.
Data Status
Current generated dataset.
GitHub Actions crawls Reddit candidates, parses pending items, rescreens flagged reports, rebuilds the static JSON bundles, and publishes the Pages site. Counts below reflect the SQLite database at build time, including the backlog still waiting for OpenAI extraction.
Candidates already read by the extraction model.
Candidates waiting for the next parse job.
Rows that need retry or manual inspection.
Canonical drug reports pulled from parsed items.
Reports that pass duration and attribution filters.
Original Reddit posts.
Reddit comments matching the search terms.
The queue is intentionally visible. A candidate enters the database when the crawler finds a Reddit post or comment matching a drug name, brand name, or shorthand term. It becomes parsed only after the one-item LLM pass has read it and written structured reports. A single candidate can mention more than one drug family, so family-level counts do not have to add up to the downloaded total.
At build time, 0 candidates are still waiting for parsing. 0 parsed posts are waiting for a stronger rescreen, and 213 reports with side-effect phrases are waiting for the side-effect severity pass.
Drug-family parse queue
These counts come from matched Reddit search terms. One post can match more than one family.
| Matched family | Downloaded | Parsed | Pending | Errors | Reports found | Plottable |
|---|---|---|---|---|---|---|
| Retatrutide | 16,812 | 11,211 | 0 | 5,601 | 9,876 | 120 |
| Tirzepatide | 37,759 | 27,913 | 0 | 9,846 | 24,363 | 489 |
| Semaglutide | 17,238 | 14,335 | 0 | 2,903 | 11,732 | 263 |
Downloaded Reddit sources
Raw candidates by subreddit, split into submissions and comments, with parse queue state.
| Subreddit | Downloaded | Posts | Comments | Parsed | Pending | Errors | Oldest | Newest |
|---|---|---|---|---|---|---|---|---|
| Semaglutide | 11,893 | 3,614 | 8,279 | 11,890 | 0 | 3 | 2022-04-17 | 2025-05-19 |
| Mounjaro | 11,002 | 3,302 | 7,700 | 9,285 | 0 | 1,717 | 2022-05-18 | 2025-05-19 |
| Retatrutide | 10,630 | 3,517 | 7,113 | 7,355 | 0 | 3,275 | 2022-08-14 | 2025-05-19 |
| WegovyWeightLoss | 3,947 | 1,722 | 2,225 | 3,125 | 0 | 822 | 2022-09-20 | 2025-05-19 |
| Peptides | 2,595 | 1,046 | 1,549 | 50 | 0 | 2,545 | 2022-12-24 | 2025-05-19 |
| tirzepatidecompound | 2,507 | 854 | 1,653 | 2,507 | 0 | 0 | 2024-01-24 | 2025-05-19 |
| Tirzepatide | 2,300 | 1,114 | 1,186 | 2,300 | 0 | 0 | 2023-01-02 | 2024-01-04 |
| Zepbound | 2,237 | 531 | 1,706 | 36 | 0 | 2,201 | 2023-11-12 | 2025-05-19 |
| MounjaroMaintenance | 1,809 | 505 | 1,304 | 1,809 | 0 | 0 | 2023-04-16 | 2025-05-19 |
| glp1 | 1,540 | 390 | 1,150 | 20 | 0 | 1,520 | 2022-11-24 | 2025-05-19 |
| compoundedtirzepatide | 1,047 | 775 | 272 | 8 | 0 | 1,039 | 2024-01-08 | 2025-05-19 |
Weight-change plot summary
| Drug family | Parsed posts | Plottable reports | Median duration | Median change |
|---|---|---|---|---|
| Retatrutide | 9,876 | 120 | 8.7 weeks | -13.2 kg |
| Tirzepatide | 24,363 | 489 | 15.0 weeks | -13.6 kg |
| Semaglutide | 11,732 | 263 | 21.7 weeks | -12.2 kg |
Crawler page progress
Each search combination tracks how many source pages have been fetched, whether it is exhausted, and whether recent errors were recorded.
| Subreddit | Type | Window | Searches | Pages fetched | Exhausted | Recent errors | Updated |
|---|---|---|---|---|---|---|---|
| GLP1 | comment | historical | 6 | 20 | 1 | 1 | 2026-07-25T04:03:45+00:00 |
| GLP1 | submission | historical | 6 | 14 | 1 | 0 | 2026-07-25T03:55:32+00:00 |
| GLP1_BeforeAfter | comment | historical | 12 | 12 | 12 | 0 | 2026-07-13T04:12:08+00:00 |
| GLP1_BeforeAfter | submission | historical | 12 | 12 | 12 | 0 | 2026-07-13T04:11:13+00:00 |
| Mounjaro | comment | historical | 7 | 96 | 0 | 0 | 2026-07-30T03:46:37+00:00 |
| Mounjaro | submission | historical | 7 | 63 | 0 | 2 | 2026-07-30T03:54:38+00:00 |
| MounjaroMaintenance | comment | historical | 7 | 22 | 1 | 1 | 2026-07-16T14:50:10+00:00 |
| MounjaroMaintenance | submission | historical | 7 | 19 | 1 | 0 | 2026-07-16T14:40:17+00:00 |
| Peptides | comment | historical | 4 | 20 | 0 | 1 | 2026-07-22T04:12:09+00:00 |
| Peptides | submission | historical | 4 | 17 | 1 | 0 | 2026-07-22T04:02:42+00:00 |
| Retatrutide | comment | historical | 6 | 94 | 0 | 1 | 2026-07-31T04:15:17+00:00 |
| Retatrutide | submission | historical | 6 | 71 | 0 | 0 | 2026-07-31T04:06:29+00:00 |
| Retatrutide | comment | recent | 428 | 404 | 404 | 24 | 2026-10-04T11:26:31+00:00 |
| Retatrutide | submission | recent | 489 | 404 | 404 | 85 | 2026-10-05T10:30:10+00:00 |
| RetatrutideTrial | submission | historical | 1 | 0 | 0 | 1 | 2026-07-02T14:53:21+00:00 |
| RetatrutideTrial | comment | recent | 139 | 108 | 108 | 31 | 2026-10-04T12:59:57+00:00 |
| RetatrutideTrial | submission | recent | 149 | 126 | 126 | 23 | 2026-10-04T13:04:13+00:00 |
| Semaglutide | comment | historical | 9 | 106 | 1 | 0 | 2026-07-06T16:12:25+00:00 |
| Semaglutide | submission | historical | 10 | 65 | 1 | 2 | 2026-07-06T16:20:34+00:00 |
| SemaglutideFreeSpeech | comment | historical | 6 | 0 | 0 | 6 | 2026-07-12T14:48:38+00:00 |
| SemaglutideFreeSpeech | submission | historical | 7 | 0 | 0 | 7 | 2026-07-12T14:52:55+00:00 |
| Tirzepatide | comment | historical | 4 | 17 | 1 | 0 | 2026-07-18T03:47:05+00:00 |
| Tirzepatide | submission | historical | 5 | 17 | 1 | 1 | 2026-07-18T03:57:32+00:00 |
| WegovyWeightLoss | comment | historical | 8 | 35 | 1 | 8 | 2026-07-29T04:37:35+00:00 |
| WegovyWeightLoss | submission | historical | 8 | 31 | 2 | 6 | 2026-07-29T04:33:17+00:00 |
| Zepbound | comment | historical | 4 | 23 | 0 | 0 | 2026-07-21T04:02:28+00:00 |
| Zepbound | submission | historical | 5 | 12 | 1 | 1 | 2026-07-21T04:11:06+00:00 |
| compoundedtirzepatide | comment | historical | 4 | 7 | 1 | 1 | 2026-08-02T04:05:48+00:00 |
| compoundedtirzepatide | submission | historical | 4 | 13 | 1 | 0 | 2026-08-02T03:57:36+00:00 |
| tirzepatidecompound | comment | historical | 4 | 21 | 0 | 1 | 2026-07-15T04:00:37+00:00 |
| tirzepatidecompound | submission | historical | 4 | 14 | 0 | 0 | 2026-07-15T03:51:18+00:00 |