Elements: SQL query and data sample

Collection of data and SQL elements underpinning the 'Exploring researcher engagement with open access at Brunel University London using emergent open science infrastructure' study1) CDM highlighting Elements2) Elements query normalises data for single system publication records and selects fields relevant for open access compliance data3) Query result. Comprisiing 5803 outputs; journal articles or conference proceedings accepted, but not publishedobscured fields:- Internal System ID fields; ID, apc_jiscID, Bura 'not Live' fields- Accepted outputs, not yet published and not yet made Live on BURA system (metadata/file release)- Business fields not relevant to paper; apc_admin, apc_request, apc_jiscID, apc_corrAuthor, DataAccessS- Proprietary article level citations; citeWos, citeSco, citePubM- acceptance_yrwk. Acceptance year retained, but yrwk deemed too specific for general public release.All other released data is in the public domain.