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.

Generated 2026-11-22T14:47:17+00:00

Downloaded candidates 51,507

Raw Reddit posts and comments saved in SQLite.

Parsed 38,385

Candidates already read by the extraction model.

Still in queue 0

Candidates waiting for the next parse job.

Parse errors 13,122

Rows that need retry or manual inspection.

Extracted reports 50,624

Canonical drug reports pulled from parsed items.

Plottable reports 872

Reports that pass duration and attribution filters.

Submissions 17,370

Original Reddit posts.

Comments 34,137

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 familyDownloadedParsedPendingErrorsReports foundPlottable
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.

SubredditDownloadedPostsCommentsParsedPendingErrorsOldestNewest
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 familyParsed postsPlottable reportsMedian durationMedian 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.

SubredditTypeWindowSearchesPages fetchedExhaustedRecent errorsUpdated
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 comment recent 180 0 0 180 2026-11-19T12:29:03+00:00
GLP1 submission recent 180 0 0 180 2026-11-19T12:28:55+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
GLP1_BeforeAfter comment recent 180 0 0 180 2026-11-19T12:32:16+00:00
GLP1_BeforeAfter submission recent 180 0 0 180 2026-11-19T12:32:08+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
Mounjaro comment recent 180 0 0 180 2026-11-19T12:06:34+00:00
Mounjaro submission recent 180 0 0 180 2026-11-19T12:06:26+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
MounjaroMaintenance comment recent 180 0 0 180 2026-11-19T12:09:47+00:00
MounjaroMaintenance submission recent 180 0 0 180 2026-11-19T12:09:39+00:00
MounjaroUK comment recent 180 0 0 180 2026-11-19T12:12:59+00:00
MounjaroUK submission recent 180 0 0 180 2026-11-19T12:12:51+00:00
Ozempic comment recent 180 0 0 180 2026-11-19T11:53:43+00:00
Ozempic submission recent 180 0 0 180 2026-11-19T11:53:34+00:00
OzempicForWeightLoss comment recent 180 0 0 180 2026-11-19T11:56:55+00:00
OzempicForWeightLoss submission recent 180 0 0 180 2026-11-19T11:56:47+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
Peptides comment recent 180 0 0 180 2026-11-19T11:44:04+00:00
Peptides submission recent 180 0 0 180 2026-11-19T11:43:56+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 608 404 404 204 2026-11-19T11:37:38+00:00
Retatrutide submission recent 702 404 404 298 2026-11-22T11:24:52+00:00
RetatrutideTrial submission historical 1 0 0 1 2026-07-02T14:53:21+00:00
RetatrutideTrial comment recent 319 108 108 211 2026-11-19T11:40:51+00:00
RetatrutideTrial submission recent 329 126 126 203 2026-11-19T11:40:43+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
Semaglutide comment recent 180 0 0 180 2026-11-19T11:47:17+00:00
Semaglutide submission recent 180 0 0 180 2026-11-19T11:47:09+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
SemaglutideFreeSpeech comment recent 180 0 0 180 2026-11-19T11:50:30+00:00
SemaglutideFreeSpeech submission recent 180 0 0 180 2026-11-19T11:50:22+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
Tirzepatide comment recent 180 0 0 180 2026-11-19T12:19:25+00:00
Tirzepatide submission recent 180 0 0 180 2026-11-19T12:19:17+00:00
WegovyUK comment recent 180 0 0 180 2026-11-19T12:03:21+00:00
WegovyUK submission recent 180 0 0 180 2026-11-19T12:03:13+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
WegovyWeightLoss comment recent 180 0 0 180 2026-11-19T12:00:08+00:00
WegovyWeightLoss submission recent 180 0 0 180 2026-11-19T12:00:00+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
Zepbound comment recent 180 0 0 180 2026-11-19T12:16:12+00:00
Zepbound submission recent 180 0 0 180 2026-11-19T12:16:04+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
compoundedtirzepatide comment recent 180 0 0 180 2026-11-19T12:25:51+00:00
compoundedtirzepatide submission recent 180 0 0 180 2026-11-19T12:25:43+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
tirzepatidecompound comment recent 180 0 0 180 2026-11-19T12:22:38+00:00
tirzepatidecompound submission recent 180 0 0 180 2026-11-19T12:22:30+00:00