# Data

The two files this site is built from, and a description of every column.

## Both files are plain comma separated text

They are UTF-8 text with a header row, and they are the files the build reads.

- [registry\_et\_trials.csv](/data/registry_et_trials.csv). 192 rows, one for each [interventional study](/glossary.md#interventional-study) on [ClinicalTrials.gov](/glossary.md#clinicaltrials-gov) whose condition strings name [essential tremor](/glossary.md#essential-tremor).
- [publication\_status.csv](/data/publication_status.csv). 57 rows, one for each [completed](/glossary.md#completed) trial with no [results posted to the registry](/glossary.md#results-posted), with the outcome of the literature search.

Every figure on the site is computed from these files at build time, so the files and the pages cannot disagree.

## There is a machine readable copy of everything here

Nothing on this site is behind JavaScript, and every page has a markdown twin.

- [data.json](/data.json). Every computed figure and every trial row as JSON, with the data date.
- [llms.txt](/llms.txt). A short index of this site in the llmstxt.org format.
- [index.md](/index.md), [method.md](/method.md), [data.md](/data.md), [corrections.md](/corrections.md) and [glossary.md](/glossary.md). The five pages as markdown.
- [sitemap.xml](/sitemap.xml) and [robots.txt](/robots.txt). Every page, with its last modified date, and an open crawling policy.

## registry\_et\_trials.csv, one row per registered study

Thirteen columns, in this order.

Columns of registry\_et\_trials.csv.

| Column | Meaning |
| --- | --- |
| `nct_id` | ClinicalTrials.gov registration number. |
| `title` | Brief title as recorded in the registry. |
| `conditions` | Condition strings as recorded in the registry, separated by semicolons where there is more than one. |
| `status` | Overall status from the registry, for example COMPLETED, RECRUITING or TERMINATED. |
| `phase` | Trial phase, or NA where the study is not phased, for example a device or behavioural study. |
| `start_date` | Study start date as recorded in the registry. |
| `completion_date` | Study completion date as recorded in the registry. Some records give a year and month only. |
| `months_since_completion` | Whole months from the completion date to the data date of 18 September 2026. Blank where no completion date is recorded. |
| `enrollment` | Number of participants as recorded in the registry, actual where available, otherwise the estimate. Blank where the registry gives none. Spelled as the registry spells it. |
| `sponsor_name` | Lead sponsor name, verbatim from the registry. |
| `sponsor_class` | Sponsor class assigned by the registry, for example INDUSTRY, NIH, FED or OTHER\_GOV. |
| `results_posted` | yes where the registry record carries a results section, otherwise no. |
| `registry_url` | Link to the study record on ClinicalTrials.gov. |

## publication\_status.csv, one row per completed trial without posted results

Sixteen columns, in this order.

Columns of publication\_status.csv.

| Column | Meaning |
| --- | --- |
| `nct_id` | Registration number, the key back to the registry file. |
| `completion_date` | Completion date carried over from the registry record. |
| `due_12m` | yes where at least twelve months separate the completion date from the data date, no where less. Blank where the registry records no usable completion date. |
| `sponsor_class` | Sponsor class carried over from the registry record. |
| `enrollment` | Enrolment carried over from the registry record. Blank where the registry gives none. |
| `classification` | Outcome of the literature search: FOUND\_RESULTS, MENTIONED\_ONLY, NOT\_FOUND or UNCERTAIN. |
| `match_basis` | How the paper was tied to the trial: NCT\_ID\_MATCH, SPECIFICS\_MATCH, or NONE where no paper was tied to it. |
| `pmid` | PubMed identifier of the paper, where there is one. |
| `doi` | Digital object identifier of the paper, where there is one. |
| `url_opened` | The record that was opened and read during the search. |
| `pub_title` | Title of the paper. |
| `pub_year` | Year of publication. |
| `journal` | Journal, in its indexed abbreviation. |
| `rationale` | A short note recording why the trial was classified as it was, quoted on the tracker page. |
| `registry_url` | Link to the study record on ClinicalTrials.gov. |
| `conditions` | Condition strings carried over from the registry record. The file carries this column twice, with identical values. |

## Join the two files on nct\_id

Every `nct_id` in `publication_status.csv` appears in `registry_et_trials.csv`. The 57 rows of the publication file are exactly the rows of the registry file where `status` is COMPLETED and `results_posted` is no. Join on `nct_id` to recover the title and sponsor.

## Reproducing the figures takes one command

Clone the repository and run `npm run build`. There are no dependencies to install.

The build reads the two files, recomputes every number, writes the site into `dist/`, then recomputes the headline figures a second time and checks them against the built pages. If the two disagree, the build stops.

Data under CC BY 4.0. Code under the MIT licence. Both are in the repository at [github.com/joooord/et-trials-tracker](https://github.com/joooord/et-trials-tracker).