Clinical trial fields in every export
The study record covers NCT identifier, brief title, official title, sponsor and collaborators, condition, intervention and intervention type, phase, study type, enrolment and whether it is actual or estimated, eligibility criteria, sex and age limits, primary and secondary outcome measures, and overall status.
Dates come as a set and each one is kept separately: first posted, last update posted, study start, primary completion and completion, each flagged as actual or estimated. Mixing an estimated completion date with an actual one is the fastest way to build a misleading timeline, and the registry marks the difference, so there is no excuse for losing it.
Facilities are delivered as their own rows rather than flattened into a string. Each site carries the facility name, city, state, country and recruitment status, which is what makes questions about geographic footprint answerable: how many sites in Germany, which of them stopped recruiting, when did the first site in Japan appear.
The change history is the field set that distinguishes this from an API pull. Every observation is stored, and the differences between observations are delivered as a change log: what field changed, from what value, to what value, and when we saw it. Status transitions, enrolment revisions, date shifts and site additions all fall out of that automatically.
Results and linked publications are joined where posted, along with the collection timestamp on every row.