OSF Preprints

Browse the database tables below or construct custom SQL queries. See Datasette's documentation for help. Variables in data closely follow the Open Science Framework API documentation.

You are probably most interested in the (perhaps poorly named; help me!) preprints UI table, which contains a denormalized list of all preprints, with contributor and subject information.

Data license: ODbL (database) & original licenses (content) · Data source: Open Science Framework

Custom SQL query

Queries

Tables

contributors

id, full_name, given_name, middle_names, family_name, suffix, date_registered, active, timezone, locale, orcid, github, scholar, profile_websites, employment, education, profile_url

Many rows

preprints

id, title, description, date_created, date_modified, date_published, original_publication_date, publication_doi, provider, is_published, reviews_state, version, is_latest_version, download_url, preprint_doi, license, tags, has_coi, conflict_of_interest_statement, has_data_links, why_no_data, data_links, has_prereg_links, why_no_prereg, prereg_links, prereg_link_info

Many rows

preprints_ui

id, title, description, date_created, date_modified, date_published, original_publication_date, publication_doi, provider, is_published, reviews_state, version, is_latest_version, preprint_doi, license, tags_list, tags_data, contributors_list, contributors_data, first_author, subjects_list, subjects_data, download_url, has_coi, conflict_of_interest_statement, has_data_links, has_prereg_links, prereg_links, prereg_link_info, last_updated

166,272 rows

providers

id

30 rows

subjects

id, text

5,411 rows

... and 9 hidden tables