ClinicalTrials.gov is changing the format of how they deliever data January 1st 2022. They will switch from XML to JSON format. In preparation for migration that we have added the ability to capture that data to the code base of AACT and set up the data it captures into a separate database.
On this page you will find information about AACT Beta. For those who are testing the beta database, you can submit issues and requests on this page.
If you are interested in using the data in AACT Beta the only thing you have to do is add "ctgov_beta" to any tables that you querying. For example if you want to see data from the studies table in beta you can run the following code
SELECT * FROM ctgov_beta.studies WHERE nct_id='NCT04750434'
Visit the Connect page for information on connecting to AACT. The steps on that page can be used for AACT Beta as long as you set "aact_beta" as the database name and "ctgov_beta" as the schema name.
The column ctgov_group_code is named ctgov_beta_group_code. Please note the codes themselves are different between the Beta and regular API on ClinicalTrials.gov.
Empty Design and Enrollment objects are not created if there is no data for them.
There are more agency_types. However, the number of agencies is the same between ctgov and ctgov_beta.
Reported event totals are handled differently in Beta on ClinicalTrials.gov. There is no total all cause mortality.
There is no download date for StudyJsonRecords, because none is provided by the ClinicalTrials.gov Beta API.
The Beta API provides Reported_event_totals with addtional data for the following columns: restriction_type, other_details and restrictive_agreement.
When no data is provided for a column the value is saved as null/nil (rather than an empty string).
There are some capitalization differences and minor verbiage differences.