Aggregation Output Table Schema
This is the common schema for a range of output tables. It is captured on this separate page due to its length.
This schema applies to the following tables:
author
country
funder
group
institution
journal
publisher
region
subregion
name |
type |
mode |
description |
|---|---|---|---|
id |
STRING |
NULLABLE |
The Relevant ID of the table |
time_period |
INTEGER |
NULLABLE |
The time period for which the metrics apply |
name |
STRING |
NULLABLE |
The name of the entity |
country |
STRING |
NULLABLE |
The country where the entity is located |
country_code |
STRING |
NULLABLE |
The country_code where the entity is located |
country_code_2 |
STRING |
NULLABLE |
The country_code where the entity is located |
region |
STRING |
NULLABLE |
The region where the entity is located |
subregion |
STRING |
NULLABLE |
The sub-region where the entity is located |
coordinates |
STRING |
NULLABLE |
The coordinates of the entity |
total_outputs |
INTEGER |
NULLABLE |
The total number of outputs in the given time period |
access_types |
RECORD |
NULLABLE |
Data summarised and broken down by OA access type |
access_types.oa |
RECORD |
NULLABLE |
Open Access |
access_types.oa.total_outputs |
INTEGER |
NULLABLE |
Total Output Count for this OA type |
access_types.oa.percent |
FLOAT |
NULLABLE |
Percent of Outputs that are this OA type |
access_types.green |
RECORD |
NULLABLE |
Green OA |
access_types.green.total_outputs |
INTEGER |
NULLABLE |
Total Output Count for this OA type |
access_types.green.percent |
FLOAT |
NULLABLE |
Percent of Outputs that are this OA type |
access_types.gold |
RECORD |
NULLABLE |
Gold OA |
access_types.gold.total_outputs |
INTEGER |
NULLABLE |
Total Output Count for this OA type |
access_types.gold.percent |
FLOAT |
NULLABLE |
Percent of Outputs that are this OA type |
access_types.gold_doaj |
RECORD |
NULLABLE |
GOlD in doaj |
access_types.gold_doaj.total_outputs |
INTEGER |
NULLABLE |
Total Output Count for this OA type |
access_types.gold_doaj.percent |
FLOAT |
NULLABLE |
Percent of Outputs that are this OA type |
access_types.hybrid |
RECORD |
NULLABLE |
Hybrid OA |
access_types.hybrid.total_outputs |
INTEGER |
NULLABLE |
Total Output Count for this OA type |
access_types.hybrid.percent |
FLOAT |
NULLABLE |
Percent of Outputs that are this OA type |
access_types.bronze |
RECORD |
NULLABLE |
Bronze OA |
access_types.bronze.total_outputs |
INTEGER |
NULLABLE |
Total Output Count for this OA type |
access_types.bronze.percent |
FLOAT |
NULLABLE |
Percent of Outputs that are this OA type |
access_types.green_only |
RECORD |
NULLABLE |
Green Only |
access_types.green_only.total_outputs |
INTEGER |
NULLABLE |
Total Output Count for this OA type |
access_types.green_only.percent |
FLOAT |
NULLABLE |
Percent of Outputs that are this OA type |
access_types.publisher |
RECORD |
NULLABLE |
Publisher OA |
access_types.publisher.total_outputs |
INTEGER |
NULLABLE |
Total Output Count for this OA type |
access_types.publisher.percent |
FLOAT |
NULLABLE |
Percent of Outputs that are this OA type |
access_types.breakdown |
RECORD |
REPEATED |
Break down |
access_types.breakdown.label |
STRING |
NULLABLE |
Access Type Display Label |
access_types.breakdown.access_type |
STRING |
NULLABLE |
OA Access Type |
access_types.breakdown.status |
BOOLEAN |
NULLABLE |
TRUE / FALSE value for whether it is taling about the OA or not OA count for the oa sub-category |
access_types.breakdown.total_outputs |
INTEGER |
NULLABLE |
Total Outputs of this type |
access_types.breakdown.outputs_with_citations |
INTEGER |
NULLABLE |
Total number of citations for this type that have citations |
access_types.breakdown.outputs_without_citations |
INTEGER |
NULLABLE |
Total number of citations for this type that don’t have citations |
access_types.breakdown.citations |
RECORD |
NULLABLE |
Citation information |
access_types.breakdown.citations.mag |
RECORD |
NULLABLE |
Citations coming from the MAG data source |
access_types.breakdown.citations.mag.total_citations |
INTEGER |
NULLABLE |
Total Number of Citataions |
access_types.breakdown.citations.mag.percentiles |
RECORD |
NULLABLE |
Percentile breakdown of citations |
access_types.breakdown.citations.mag.percentiles.per_25th |
FLOAT |
NULLABLE |
25th Percentile |
access_types.breakdown.citations.mag.percentiles.median |
FLOAT |
NULLABLE |
Median number of citations |
access_types.breakdown.citations.mag.percentiles.per_90th |
FLOAT |
NULLABLE |
90th percentile |
access_types.breakdown.citations.mag.percentiles.per_95th |
FLOAT |
NULLABLE |
95th percentile |
access_types.breakdown.citations.open_citations |
RECORD |
NULLABLE |
Citations coming from the Open Citations data source |
access_types.breakdown.citations.open_citations.total_citations |
INTEGER |
NULLABLE |
Total Number of Citataions |
access_types.breakdown.citations.open_citations.percentiles |
RECORD |
NULLABLE |
Percentile breakdown of citations |
access_types.breakdown.citations.open_citations.percentiles.per_25th |
FLOAT |
NULLABLE |
25th Percentile |
access_types.breakdown.citations.open_citations.percentiles.median |
FLOAT |
NULLABLE |
Median number of citations |
access_types.breakdown.citations.open_citations.percentiles.per_90th |
FLOAT |
NULLABLE |
90th percentile |
access_types.breakdown.citations.open_citations.percentiles.per_95th |
FLOAT |
NULLABLE |
95th percentile |
access_types.breakdown.citations.crossref |
RECORD |
NULLABLE |
Citations coming from the crossref data source |
access_types.breakdown.citations.crossref.total_citations |
INTEGER |
NULLABLE |
Total Number of Citataions |
access_types.breakdown.citations.crossref.percentiles |
RECORD |
NULLABLE |
Percentile breakdown of citations |
access_types.breakdown.citations.crossref.percentiles.per_25th |
FLOAT |
NULLABLE |
25th Percentile |
access_types.breakdown.citations.crossref.percentiles.median |
FLOAT |
NULLABLE |
Median number of citations |
access_types.breakdown.citations.crossref.percentiles.per_90th |
FLOAT |
NULLABLE |
90th percentile |
access_types.breakdown.citations.crossref.percentiles.per_95th |
FLOAT |
NULLABLE |
95th percentile |
citations |
RECORD |
NULLABLE |
Breakdown of Citations |
citations.mag |
RECORD |
NULLABLE |
MAG Citation data |
citations.mag.total_citations |
INTEGER |
NULLABLE |
Total number of citations from this source |
citations.mag.citations_per_output |
FLOAT |
NULLABLE |
total number of citations divided by number of outputs |
citations.mag.outputs_with_citations |
INTEGER |
NULLABLE |
Number of outputs that have at least one citations |
citations.mag.outputs_without_citations |
INTEGER |
NULLABLE |
Number of outputs that have no citations |
citations.mag.citations_per_cited_output |
FLOAT |
NULLABLE |
total number of citations divided by number of outputs that have at least one citation |
citations.crossref |
RECORD |
NULLABLE |
Crossref Citation Data |
citations.crossref.total_citations |
INTEGER |
NULLABLE |
Total number of citations from this source |
citations.crossref.citations_per_output |
FLOAT |
NULLABLE |
total number of citations divided by number of outputs |
citations.crossref.outputs_with_citations |
INTEGER |
NULLABLE |
Number of outputs that have at least one citations |
citations.crossref.outputs_without_citations |
INTEGER |
NULLABLE |
Number of outputs that have no citations |
citations.crossref.citations_per_cited_output |
FLOAT |
NULLABLE |
total number of citations divided by number of outputs that have at least one citation |
citations.open_citations |
RECORD |
NULLABLE |
Open Citations citation data |
citations.open_citations.total_citations |
INTEGER |
NULLABLE |
Total number of citations from this source |
citations.open_citations.citations_per_output |
FLOAT |
NULLABLE |
total number of citations divided by number of outputs |
citations.open_citations.outputs_with_citations |
INTEGER |
NULLABLE |
Number of outputs that have at least one citations |
citations.open_citations.outputs_without_citations |
INTEGER |
NULLABLE |
Number of outputs that have no citations |
citations.open_citations.citations_per_cited_output |
FLOAT |
NULLABLE |
total number of citations divided by number of outputs that have at least one citation |
output_types |
RECORD |
REPEATED |
Data broken down by crossref output type |
output_types.output_type |
STRING |
NULLABLE |
Crossref output type |
output_types.total_outputs |
INTEGER |
NULLABLE |
total number of outputs of this type |
output_types.num_oa_outputs |
INTEGER |
NULLABLE |
total number of OA outputs of this type |
output_types.num_green_outputs |
INTEGER |
NULLABLE |
total number of green OA outputs of this type |
output_types.num_gold_outputs |
INTEGER |
NULLABLE |
total number of gold OA outputs of this type |
output_types.num_gold_just_doaj_outputs |
INTEGER |
NULLABLE |
total number of gold in doaj outputs of this type |
output_types.num_hybrid_outputs |
INTEGER |
NULLABLE |
total number of hybrid OA outputs of this type |
output_types.num_bronze_outputs |
INTEGER |
NULLABLE |
total number of hybrid OA outputs of this type |
output_types.num_green_only_outputs |
INTEGER |
NULLABLE |
total number of green only outputs of this type |
output_types.citations |
RECORD |
NULLABLE |
Citation breakdown |
output_types.citations.total_mag_citations |
INTEGER |
NULLABLE |
total number of citations from mag |
output_types.citations.total_open_citations_citations |
INTEGER |
NULLABLE |
total number of citations from open citations |
output_types.citations.total_crossref_citations |
INTEGER |
NULLABLE |
total number of citations from crossref |
disciplines |
RECORD |
NULLABLE |
Discipline Breakdown |
disciplines.level0 |
RECORD |
REPEATED |
Level0 of the MAG fields of study Hierarchy |
disciplines.level0.field |
STRING |
NULLABLE |
MAG Field name |
disciplines.level0.total_outputs |
INTEGER |
NULLABLE |
number of outputs of that field |
disciplines.level0.sum_of_scores |
FLOAT |
NULLABLE |
Sum of the MAG scores. A score roughly represents how strongly 0.0-1.0 each article is associated with a field |
disciplines.level0.citations |
RECORD |
NULLABLE |
Citation breakdown |
disciplines.level0.citations.mag |
RECORD |
NULLABLE |
Citation Data from MAG |
disciplines.level0.citations.mag.total_citations |
INTEGER |
NULLABLE |
Total number of citations |
disciplines.level0.citations.mag.percentiles |
RECORD |
NULLABLE |
Percentile Breakdown |
disciplines.level0.citations.mag.percentiles.per_25th |
FLOAT |
NULLABLE |
25th Percentile |
disciplines.level0.citations.mag.percentiles.median |
FLOAT |
NULLABLE |
Median citations |
disciplines.level0.citations.mag.percentiles.per_90th |
FLOAT |
NULLABLE |
90th Percentile |
disciplines.level0.citations.mag.percentiles.per_95th |
FLOAT |
NULLABLE |
95th Percentile |
disciplines.level0.citations.open_citations |
RECORD |
NULLABLE |
Open Citations citation data |
disciplines.level0.citations.open_citations.total_citations |
INTEGER |
NULLABLE |
Total number of citations |
disciplines.level0.citations.open_citations.percentiles |
RECORD |
NULLABLE |
Percentile Breakdown |
disciplines.level0.citations.open_citations.percentiles.per_25th |
FLOAT |
NULLABLE |
25th Percentile |
disciplines.level0.citations.open_citations.percentiles.median |
FLOAT |
NULLABLE |
Median citations |
disciplines.level0.citations.open_citations.percentiles.per_90th |
FLOAT |
NULLABLE |
90th Percentile |
disciplines.level0.citations.open_citations.percentiles.per_95th |
FLOAT |
NULLABLE |
95th Percentile |
disciplines.level0.citations.crossref |
RECORD |
NULLABLE |
Crossref citation data |
disciplines.level0.citations.crossref.total_citations |
INTEGER |
NULLABLE |
Total number of citations |
disciplines.level0.citations.crossref.percentiles |
RECORD |
NULLABLE |
Percentile Breakdown |
disciplines.level0.citations.crossref.percentiles.per_25th |
FLOAT |
NULLABLE |
25th Percentile |
disciplines.level0.citations.crossref.percentiles.median |
FLOAT |
NULLABLE |
Median citations |
disciplines.level0.citations.crossref.percentiles.per_90th |
FLOAT |
NULLABLE |
90th Percentile |
disciplines.level0.citations.crossref.percentiles.per_95th |
FLOAT |
NULLABLE |
95th Percentile |
disciplines.level0.num_oa_outputs |
INTEGER |
NULLABLE |
number of OA outputs of that field |
disciplines.level0.num_green_outputs |
INTEGER |
NULLABLE |
number of green OA outputs of that field |
disciplines.level0.num_gold_outputs |
INTEGER |
NULLABLE |
number of gold OA outputs of that field |
disciplines.level0.num_gold_just_doaj_outputs |
INTEGER |
NULLABLE |
number of gold just in doaj outputs of that field |
disciplines.level0.num_hybrid_outputs |
INTEGER |
NULLABLE |
number of hybrid OA outputs of that field |
disciplines.level0.num_bronze_outputs |
INTEGER |
NULLABLE |
number of bronze OA outputs of that field |
disciplines.level0.num_green_only_outputs |
INTEGER |
NULLABLE |
number of green only outputs of that field |
disciplines.level0.funding |
RECORD |
NULLABLE |
Breakdown of Funding Data for this type |
disciplines.level0.funding.total_funded_outputs |
INTEGER |
NULLABLE |
number of funded outputs of that field |
disciplines.level0.funding.num_international_outputs |
INTEGER |
NULLABLE |
number of internationally funded outputs of that field |
disciplines.level0.funding.num_domestic_outputs |
INTEGER |
NULLABLE |
number of domestically funded outputs of that field |
disciplines.level0.funding.num_international_and_domestic_outputs |
INTEGER |
NULLABLE |
number of joint internationally and domestic funded outputs of that field |
disciplines.level0.funding.num_government_outputs |
INTEGER |
NULLABLE |
number of government funded outputs of that field |
disciplines.level0.funding.num_private_outputs |
INTEGER |
NULLABLE |
number of private funded outputs of that field |
disciplines.level0.funding.num_government_and_private_outputs |
INTEGER |
NULLABLE |
number of jointly governemtn and private funded outputs of that field |
disciplines.level0.num_international_collaboration_outputs |
INTEGER |
NULLABLE |
number of internationally collaborated on outputs of that field |
disciplines.level0.international_collaboration_with_funding_outputs |
INTEGER |
NULLABLE |
|
repositories |
RECORD |
REPEATED |
Breakdown of repositories |
repositories.id |
STRING |
NULLABLE |
Repository Name |
repositories.total_outputs |
INTEGER |
NULLABLE |
Total number of outputs found on that repository |
repositories.percentage_of_all_green |
FLOAT |
NULLABLE |
The percentage of all green outputs linked to that specific repository |
institutions |
RECORD |
REPEATED |
Institutional Breakdown |
institutions.id |
STRING |
NULLABLE |
ID of entity |
institutions.total_outputs |
INTEGER |
NULLABLE |
total number of outputs associated with this entity |
institutions.percentage_of_all_outputs |
FLOAT |
NULLABLE |
percentage of all outputs associated with this entity |
institutions.percentage_of_all_oa |
FLOAT |
NULLABLE |
percentage of all OA associated with this entity |
institutions.name |
STRING |
NULLABLE |
Name of the entity |
institutions.country |
STRING |
NULLABLE |
Country where the entity is located |
institutions.country_code |
STRING |
NULLABLE |
Country code of the country where the entity is located |
institutions.region |
STRING |
NULLABLE |
Region where the entity is located |
institutions.subregion |
STRING |
NULLABLE |
Sub-region where the entity is located |
institutions.coordinates |
STRING |
NULLABLE |
Coordinates of where the entity is located |
institutions.num_oa_outputs |
INTEGER |
NULLABLE |
total number of OA outputs associated with this entity |
institutions.num_in_doaj |
INTEGER |
NULLABLE |
total number of outputs associated with this entity in doaj |
institutions.num_green_outputs |
INTEGER |
NULLABLE |
total number of green OA outputs associated with this entity |
institutions.num_gold_outputs |
INTEGER |
NULLABLE |
total number of gold OA outputs associated with this entity |
institutions.num_gold_just_doaj_outputs |
INTEGER |
NULLABLE |
total number of gold OA outputs just in doaj associated with this entity |
institutions.num_hybrid_outputs |
INTEGER |
NULLABLE |
total number of hybrid OA outputs associated with this entity |
institutions.num_bronze_outputs |
INTEGER |
NULLABLE |
total number of bronze OA outputs associated with this entity |
institutions.num_green_only_outputs |
INTEGER |
NULLABLE |
total number of green only outputs associated with this entity |
institutions.num_green_only_ignoring_bronze_outputs |
INTEGER |
NULLABLE |
total number of green only ignoring bronze outputs associated with this entity |
institutions.num_has_license |
INTEGER |
NULLABLE |
total number of outputs that have a license associated with this entity |
institutions.num_is_cclicensed |
INTEGER |
NULLABLE |
total number of outputs that have a Creative Commons license associated with this entity |
institutions.citations |
RECORD |
NULLABLE |
Breakdown of citations across data providers |
institutions.citations.mag |
INTEGER |
NULLABLE |
Number of citations derived from MAG |
institutions.citations.crosssref |
INTEGER |
NULLABLE |
Number of citations derived from Crossref |
institutions.citations.open_citations |
INTEGER |
NULLABLE |
Number of citations derived from Open Citations |
institutions.disciplines |
RECORD |
REPEATED |
Discipline breakdown |
institutions.disciplines.field |
STRING |
NULLABLE |
MAG Field Name |
institutions.disciplines.total_outputs |
INTEGER |
NULLABLE |
Total number of outputs linked that that field type |
institutions.disciplines.num_oa_outputs |
INTEGER |
NULLABLE |
Total number of oa putputs linked to that field type |
institutions.disciplines.sum_of_scores |
FLOAT |
NULLABLE |
Sum of the MAG scores. A score roughly represents how strongly 0.0-1.0 each article is associated with a field |
countries |
RECORD |
REPEATED |
Countries Breakdown |
countries.id |
STRING |
NULLABLE |
ID of entity |
countries.total_outputs |
INTEGER |
NULLABLE |
total number of outputs associated with this entity |
countries.percentage_of_all_outputs |
FLOAT |
NULLABLE |
percentage of all outputs associated with this entity |
countries.percentage_of_all_oa |
FLOAT |
NULLABLE |
percentage of all OA associated with this entity |
countries.name |
STRING |
NULLABLE |
Name of the entity |
countries.country |
STRING |
NULLABLE |
Country where the entity is located |
countries.country_code |
STRING |
NULLABLE |
Country code of the country where the entity is located |
countries.region |
STRING |
NULLABLE |
Region where the entity is located |
countries.subregion |
STRING |
NULLABLE |
Sub-region where the entity is located |
countries.coordinates |
STRING |
NULLABLE |
Coordinates of where the entity is located |
countries.num_oa_outputs |
INTEGER |
NULLABLE |
total number of OA outputs associated with this entity |
countries.num_in_doaj |
INTEGER |
NULLABLE |
total number of outputs associated with this entity in doaj |
countries.num_green_outputs |
INTEGER |
NULLABLE |
total number of green OA outputs associated with this entity |
countries.num_gold_outputs |
INTEGER |
NULLABLE |
total number of gold OA outputs associated with this entity |
countries.num_gold_just_doaj_outputs |
INTEGER |
NULLABLE |
total number of gold OA outputs just in doaj associated with this entity |
countries.num_hybrid_outputs |
INTEGER |
NULLABLE |
total number of hybrid OA outputs associated with this entity |
countries.num_bronze_outputs |
INTEGER |
NULLABLE |
total number of bronze OA outputs associated with this entity |
countries.num_green_only_outputs |
INTEGER |
NULLABLE |
total number of green only outputs associated with this entity |
countries.num_green_only_ignoring_bronze_outputs |
INTEGER |
NULLABLE |
total number of green only ignoring bronze outputs associated with this entity |
countries.num_has_license |
INTEGER |
NULLABLE |
total number of outputs that have a license associated with this entity |
countries.num_is_cclicensed |
INTEGER |
NULLABLE |
total number of outputs that have a Creative Commons license associated with this entity |
countries.citations |
RECORD |
NULLABLE |
Breakdown of citations across data providers |
countries.citations.mag |
INTEGER |
NULLABLE |
Number of citations derived from MAG |
countries.citations.crosssref |
INTEGER |
NULLABLE |
Number of citations derived from Crossref |
countries.citations.open_citations |
INTEGER |
NULLABLE |
Number of citations derived from Open Citations |
countries.disciplines |
RECORD |
REPEATED |
Discipline breakdown |
countries.disciplines.field |
STRING |
NULLABLE |
MAG Field Name |
countries.disciplines.total_outputs |
INTEGER |
NULLABLE |
Total number of outputs linked that that field type |
countries.disciplines.num_oa_outputs |
INTEGER |
NULLABLE |
Total number of oa putputs linked to that field type |
countries.disciplines.sum_of_scores |
FLOAT |
NULLABLE |
Sum of the MAG scores. A score roughly represents how strongly 0.0-1.0 each article is associated with a field |
funders |
RECORD |
REPEATED |
Funders Breakdown |
funders.id |
STRING |
NULLABLE |
ID of entity |
funders.total_outputs |
INTEGER |
NULLABLE |
total number of outputs associated with this entity |
funders.percentage_of_all_outputs |
FLOAT |
NULLABLE |
percentage of all outputs associated with this entity |
funders.percentage_of_all_oa |
FLOAT |
NULLABLE |
percentage of all OA associated with this entity |
funders.name |
STRING |
NULLABLE |
Name of the entity |
funders.country |
STRING |
NULLABLE |
Country where the entity is located |
funders.country_code |
STRING |
NULLABLE |
Country code of the country where the entity is located |
funders.region |
STRING |
NULLABLE |
Region where the entity is located |
funders.subregion |
STRING |
NULLABLE |
Sub-region where the entity is located |
funders.coordinates |
STRING |
NULLABLE |
Coordinates of where the entity is located |
funders.num_oa_outputs |
INTEGER |
NULLABLE |
total number of OA outputs associated with this entity |
funders.num_in_doaj |
INTEGER |
NULLABLE |
total number of outputs associated with this entity in doaj |
funders.num_green_outputs |
INTEGER |
NULLABLE |
total number of green OA outputs associated with this entity |
funders.num_gold_outputs |
INTEGER |
NULLABLE |
total number of gold OA outputs associated with this entity |
funders.num_gold_just_doaj_outputs |
INTEGER |
NULLABLE |
total number of gold OA outputs just in doaj associated with this entity |
funders.num_hybrid_outputs |
INTEGER |
NULLABLE |
total number of hybrid OA outputs associated with this entity |
funders.num_bronze_outputs |
INTEGER |
NULLABLE |
total number of bronze OA outputs associated with this entity |
funders.num_green_only_outputs |
INTEGER |
NULLABLE |
total number of green only outputs associated with this entity |
funders.num_green_only_ignoring_bronze_outputs |
INTEGER |
NULLABLE |
total number of green only ignoring bronze outputs associated with this entity |
funders.num_has_license |
INTEGER |
NULLABLE |
total number of outputs that have a license associated with this entity |
funders.num_is_cclicensed |
INTEGER |
NULLABLE |
total number of outputs that have a Creative Commons license associated with this entity |
funders.citations |
RECORD |
NULLABLE |
Breakdown of citations across data providers |
funders.citations.mag |
INTEGER |
NULLABLE |
Number of citations derived from MAG |
funders.citations.crosssref |
INTEGER |
NULLABLE |
Number of citations derived from Crossref |
funders.citations.open_citations |
INTEGER |
NULLABLE |
Number of citations derived from Open Citations |
funders.disciplines |
RECORD |
REPEATED |
Discipline breakdown |
funders.disciplines.field |
STRING |
NULLABLE |
MAG Field Name |
funders.disciplines.total_outputs |
INTEGER |
NULLABLE |
Total number of outputs linked that that field type |
funders.disciplines.num_oa_outputs |
INTEGER |
NULLABLE |
Total number of oa putputs linked to that field type |
funders.disciplines.sum_of_scores |
FLOAT |
NULLABLE |
Sum of the MAG scores. A score roughly represents how strongly 0.0-1.0 each article is associated with a field |
publishers |
RECORD |
REPEATED |
Publishers Breakdown |
publishers.id |
STRING |
NULLABLE |
ID of entity |
publishers.total_outputs |
INTEGER |
NULLABLE |
total number of outputs associated with this entity |
publishers.percentage_of_all_outputs |
FLOAT |
NULLABLE |
percentage of all outputs associated with this entity |
publishers.percentage_of_all_oa |
FLOAT |
NULLABLE |
percentage of all OA associated with this entity |
publishers.name |
STRING |
NULLABLE |
Name of the entity |
publishers.country |
STRING |
NULLABLE |
Country where the entity is located |
publishers.country_code |
STRING |
NULLABLE |
Country code of the country where the entity is located |
publishers.region |
STRING |
NULLABLE |
Region where the entity is located |
publishers.subregion |
STRING |
NULLABLE |
Sub-region where the entity is located |
publishers.coordinates |
STRING |
NULLABLE |
Coordinates of where the entity is located |
publishers.num_oa_outputs |
INTEGER |
NULLABLE |
total number of OA outputs associated with this entity |
publishers.num_in_doaj |
INTEGER |
NULLABLE |
total number of outputs associated with this entity in doaj |
publishers.num_green_outputs |
INTEGER |
NULLABLE |
total number of green OA outputs associated with this entity |
publishers.num_gold_outputs |
INTEGER |
NULLABLE |
total number of gold OA outputs associated with this entity |
publishers.num_gold_just_doaj_outputs |
INTEGER |
NULLABLE |
total number of gold OA outputs just in doaj associated with this entity |
publishers.num_hybrid_outputs |
INTEGER |
NULLABLE |
total number of hybrid OA outputs associated with this entity |
publishers.num_bronze_outputs |
INTEGER |
NULLABLE |
total number of bronze OA outputs associated with this entity |
publishers.num_green_only_outputs |
INTEGER |
NULLABLE |
total number of green only outputs associated with this entity |
publishers.num_green_only_ignoring_bronze_outputs |
INTEGER |
NULLABLE |
total number of green only ignoring bronze outputs associated with this entity |
publishers.num_has_license |
INTEGER |
NULLABLE |
total number of outputs that have a license associated with this entity |
publishers.num_is_cclicensed |
INTEGER |
NULLABLE |
total number of outputs that have a Creative Commons license associated with this entity |
publishers.citations |
RECORD |
NULLABLE |
Breakdown of citations across data providers |
publishers.citations.mag |
INTEGER |
NULLABLE |
Number of citations derived from MAG |
publishers.citations.crosssref |
INTEGER |
NULLABLE |
Number of citations derived from Crossref |
publishers.citations.open_citations |
INTEGER |
NULLABLE |
Number of citations derived from Open Citations |
publishers.disciplines |
RECORD |
REPEATED |
Discipline breakdown |
publishers.disciplines.field |
STRING |
NULLABLE |
MAG Field Name |
publishers.disciplines.total_outputs |
INTEGER |
NULLABLE |
Total number of outputs linked that that field type |
publishers.disciplines.num_oa_outputs |
INTEGER |
NULLABLE |
Total number of oa putputs linked to that field type |
publishers.disciplines.sum_of_scores |
FLOAT |
NULLABLE |
Sum of the MAG scores. A score roughly represents how strongly 0.0-1.0 each article is associated with a field |
journals |
RECORD |
REPEATED |
Journals Breakdown |
journals.id |
STRING |
NULLABLE |
ID of entity |
journals.total_outputs |
INTEGER |
NULLABLE |
total number of outputs associated with this entity |
journals.percentage_of_all_outputs |
FLOAT |
NULLABLE |
percentage of all outputs associated with this entity |
journals.percentage_of_all_oa |
FLOAT |
NULLABLE |
percentage of all OA associated with this entity |
journals.name |
STRING |
NULLABLE |
Name of the entity |
journals.country |
STRING |
NULLABLE |
Country where the entity is located |
journals.country_code |
STRING |
NULLABLE |
Country code of the country where the entity is located |
journals.region |
STRING |
NULLABLE |
Region where the entity is located |
journals.subregion |
STRING |
NULLABLE |
Sub-region where the entity is located |
journals.coordinates |
STRING |
NULLABLE |
Coordinates of where the entity is located |
journals.num_oa_outputs |
INTEGER |
NULLABLE |
total number of OA outputs associated with this entity |
journals.num_in_doaj |
INTEGER |
NULLABLE |
total number of outputs associated with this entity in doaj |
journals.num_green_outputs |
INTEGER |
NULLABLE |
total number of green OA outputs associated with this entity |
journals.num_gold_outputs |
INTEGER |
NULLABLE |
total number of gold OA outputs associated with this entity |
journals.num_gold_just_doaj_outputs |
INTEGER |
NULLABLE |
total number of gold OA outputs just in doaj associated with this entity |
journals.num_hybrid_outputs |
INTEGER |
NULLABLE |
total number of hybrid OA outputs associated with this entity |
journals.num_bronze_outputs |
INTEGER |
NULLABLE |
total number of bronze OA outputs associated with this entity |
journals.num_green_only_outputs |
INTEGER |
NULLABLE |
total number of green only outputs associated with this entity |
journals.num_green_only_ignoring_bronze_outputs |
INTEGER |
NULLABLE |
total number of green only ignoring bronze outputs associated with this entity |
journals.num_has_license |
INTEGER |
NULLABLE |
total number of outputs that have a license associated with this entity |
journals.num_is_cclicensed |
INTEGER |
NULLABLE |
total number of outputs that have a Creative Commons license associated with this entity |
journals.citations |
RECORD |
NULLABLE |
Breakdown of citations across data providers |
journals.citations.mag |
INTEGER |
NULLABLE |
Number of citations derived from MAG |
journals.citations.crosssref |
INTEGER |
NULLABLE |
Number of citations derived from Crossref |
journals.citations.open_citations |
INTEGER |
NULLABLE |
Number of citations derived from Open Citations |
journals.disciplines |
RECORD |
REPEATED |
Discipline breakdown |
journals.disciplines.field |
STRING |
NULLABLE |
MAG Field Name |
journals.disciplines.total_outputs |
INTEGER |
NULLABLE |
Total number of outputs linked that that field type |
journals.disciplines.num_oa_outputs |
INTEGER |
NULLABLE |
Total number of oa putputs linked to that field type |
journals.disciplines.sum_of_scores |
FLOAT |
NULLABLE |
Sum of the MAG scores. A score roughly represents how strongly 0.0-1.0 each article is associated with a field |
events |
RECORD |
REPEATED |
Events Breakdown |
events.source |
STRING |
NULLABLE |
Event Source |
events.total_outputs |
INTEGER |
NULLABLE |
Total number of events for that source |
events.num_oa_outputs |
INTEGER |
NULLABLE |
Total number of events for that source for OA outputs |
events.num_green_outputs |
INTEGER |
NULLABLE |
Total number of events for that source for green OA outputs |
events.num_gold_outputs |
INTEGER |
NULLABLE |
Total number of events for that source for gold OA outputs |
events.num_gold_just_doaj_outputs |
INTEGER |
NULLABLE |
Total number of events for that source for gold just in doaj outputs |
events.num_hybrid_outputs |
INTEGER |
NULLABLE |
Total number of events for that source for hybrid OA outputs |
events.num_bronze_outputs |
INTEGER |
NULLABLE |
Total number of events for that source for bronze OA outputs |
events.num_green_only_outputs |
INTEGER |
NULLABLE |
Total number of events for that source for green only outputs |