Preprints (UI)

Denormalized preprint data with contributors and subjects for efficient UI access

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

1 row where first_author = "Lena Roemer" and has_prereg_links = "available" sorted by date_created descending

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

These facets timed out: provider

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
dbxhp_v1 Why Does the Trait-State Relation in Vocational Interests Differ from That in Personality? Exploring Interest Variability in Daily Life Interests have been studied from a trait- and state-perspective. Recent studies propose to integrate these two traditions. This preregistered experience-samplin… 2022-07-07T07:00:45.687331 2024-03-04T18:33:43.284147 2022-07-07T07:07:13.251850     psyarxiv 1 accepted 1 1 https://doi.org/10.31234/osf.io/dbxhp CC-By Attribution 4.0 International Vocational Interests; accessibility model; experience sampling; interest state; intraindividual variability ["Vocational Interests", "accessibility model", "experience sampling", "interest state", "intraindividual variability"] Lena Roemer; Gundula Stoll; James Rounds; Matthias Ziegler [{"id": "qjp93", "name": "Lena Roemer", "index": 0, "orcid": null, "bibliographic": true}, {"id": "te3x4", "name": "Gundula Stoll", "index": 1, "orcid": null, "… Lena Roemer Social and Behavioral Sciences; Social and Personality Psychology; Individual Differences; Personality and Situations [{"id": "5b4e7425c6983001430b6c1e", "text": "Social and Behavioral Sciences"}, {"id": "5b4e7425c6983001430b6c34", "text": "Social and Personality Psychology"}, … https://osf.io/download/62c684a1c79a4c01669e5a4b 0   available available ["https://osf.io/5ezt6/?view_only=74b35ca9c8d24ba397761869f56f5d2c"] prereg_both 2025-04-09T20:49:39.327344

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

CREATE TABLE [preprints_ui] (
   [id] TEXT PRIMARY KEY,
   [title] TEXT,
   [description] TEXT,
   [date_created] TEXT,
   [date_modified] TEXT,
   [date_published] TEXT,
   [original_publication_date] TEXT,
   [publication_doi] TEXT,
   [provider] TEXT,
   [is_published] INTEGER,
   [reviews_state] TEXT,
   [version] INTEGER,
   [is_latest_version] INTEGER,
   [preprint_doi] TEXT,
   [license] TEXT,
   [tags_list] TEXT,
   [tags_data] TEXT,
   [contributors_list] TEXT,
   [contributors_data] TEXT,
   [first_author] TEXT,
   [subjects_list] TEXT,
   [subjects_data] TEXT,
   [download_url] TEXT,
   [has_coi] INTEGER,
   [conflict_of_interest_statement] TEXT,
   [has_data_links] TEXT,
   [has_prereg_links] TEXT,
   [prereg_links] TEXT,
   [prereg_link_info] TEXT,
   [last_updated] TEXT
);
CREATE INDEX idx_preprints_ui_date ON preprints_ui(date_created);
CREATE INDEX idx_preprints_ui_provider ON preprints_ui(provider);