Schemas
Aggregate Works
Work ID ISBN (onix_workid_isbn)
isbn13
STRING
NULLABLE
ISBN13
work_id
STRING
NULLABLE
The WorkID. Likely to be an ISBN.
Work ID ISBN Errors (onix_workid_isbn_errors)
Error
STRING
NULLABLE
Error string
Work Family ID ISBN (onix_workfamilyid_isbn)
isbn13
STRING
NULLABLE
ISBN13
work_family_id
STRING
NULLABLE
The Work Family ID. Likely to be an ISBN.
Book List (book)
isbn
STRING
NULLABLE
ISBN of the Book
crossref_objects
RECORD
REPEATED
Crossref Objects (that are not chapter types) associated with the primary ISBN
crossref_objects.doi
STRING
NULLABLE
DOI
crossref_objects.title
ARRAY<STRING>
REPEATED
Title of the Book
crossref_objects.type
STRING
NULLABLE
Crossref Type
crossref_objects.publisher
STRING
NULLABLE
Publisher Name
crossref_objects.published_year
INT64
NULLABLE
Year of Publication
crossref_objects.published_year_month
STRING
NULLABLE
Month and Year of Publication
crossref_objects.work_isbns
ARRAY<STRING>
REPEATED
Full list of Assoicated ISBNs
chapters
RECORD
REPEATED
Crossref Objects (that are of type chapter) associated with the primary ISBN
chapters.doi
STRING
NULLABLE
DOI of chapter
chapters.title
ARRAY<STRING>
REPEATED
Title of Chapter
chapters.type
STRING
NULLABLE
Crossref Type
Book Product (book_product)
ISBN13
STRING
NULLABLE
ISBN13
onix
RECORD
NULLABLE
Fields Pulled from the ONIX Record for this Book Product
onix.Doi
STRING
NULLABLE
DOI
onix.ProductForm
STRING
NULLABLE
The product form, such as digital, print etc
onix.EditionNumber
INTEGER
NULLABLE
The edition number of this book product
onix.title
STRING
NULLABLE
The Book's Title
onix.subtitle
STRING
NULLABLE
The Book's Subtitle
onix.published_year
STRING
NULLABLE
The year the book was published
onix.published_date
DATE
NULLABLE
The date the book was published
onix.bic_subjects
ARRAY<STRING>
REPEATED
A list of BIC subjects
onix.bisac_subjects
ARRAY<STRING>
REPEATED
A list of BISAC subjects
onix.thema_subjects
ARRAY<STRING>
REPEATED
A list of THEMA subjects
onix.keywords
ARRAY<STRING>
REPEATED
A list of Keywords
onix.authors
RECORD
REPEATED
Book Authors
onix.authors.PersonName
STRING
NULLABLE
The Author's Full Name in the format '[first name] [last name]'
onix.authors.PersonNameInverted
STRING
NULLABLE
The Authors Full Name in the format '[last name], [first name]'
onix.authors.ORCID
STRING
NULLABLE
Authors ORCID ID, if present
onix.publisher
RECORD
REPEATED
Publisher fields
onix.publisher.publisher_name
STRING
NULLABLE
The name of an entity associated with the publication process. See publisher_role for type of entity the name refers to
onix.publisher.publishing_role
STRING
NULLABLE
The role of the publishing entity
subjects
RECORD
NULLABLE
Subjects associated with this product
subjects.bic_codes
ARRAY<STRING>
REPEATED
A list of BIC subject codes
subjects.bic_top
ARRAY<STRING>
REPEATED
A list of BIC subject codes for the top level subject
subjects.bic_names
ARRAY<STRING>
REPEATED
A list of BIC subject names
subjects.bisac_codes
ARRAY<STRING>
REPEATED
A list of BISAC subject codes
subjects.bisac_top
ARRAY<STRING>
REPEATED
A list of BISAC subject codes for the top level subject
subjects.bisac_names
ARRAY<STRING>
REPEATED
A list of BISAC subject names
subjects.thema_codes
ARRAY<STRING>
REPEATED
A list of Thema subject codes
subjects.thema_top
ARRAY<STRING>
REPEATED
A list of Thema subject codes for the top level subject
subjects.thema_names
ARRAY<STRING>
REPEATED
A list of Thema subject names
work_id
STRING
NULLABLE
The dervied Work_ID that we calculate
work_family_id
STRING
NULLABLE
The Dervied Work_Family_ID that we calculate
metadata
RECORD
NULLABLE
Metadata on this book, derived and organised by source
metadata.crossref_objects
RECORD
REPEATED
Linked Objects from Crossref and their values
metadata.crossref_objects.doi
STRING
NULLABLE
The DOI from crossref
metadata.crossref_objects.title
ARRAY<STRING>
REPEATED
The title from crossref
metadata.crossref_objects.type
STRING
NULLABLE
The type from crossref
metadata.crossref_objects.publisher
STRING
NULLABLE
The publisher from crossref
metadata.crossref_objects.published_year
INTEGER
NULLABLE
The published year from crossref
metadata.crossref_objects.published_year_month
STRING
NULLABLE
The published year-month from crossref
metadata.crossref_objects.work_isbns
ARRAY<STRING>
REPEATED
ISBNs
metadata.chapters
RECORD
REPEATED
Linked Objects from Crossref where they are of type book-chapter only
metadata.chapters.doi
STRING
NULLABLE
The Book Chapter DOI
metadata.chapters.title
ARRAY<STRING>
REPEATED
The Book Chapter title
metadata.chapters.type
STRING
NULLABLE
The Book Chapter type
metadata.google_books_sales
RECORD
NULLABLE
Metadata derived from Google Books Sales
metadata.google_books_sales.ISBN13
STRING
NULLABLE
ISBN
metadata.google_books_sales.Imprint_Name
STRING
NULLABLE
The template used for the book.
metadata.google_books_sales.Title
STRING
NULLABLE
The title of the book.
metadata.google_books_sales.Author
STRING
NULLABLE
The author of the book.
metadata.google_books_traffic
RECORD
NULLABLE
Metadata derived from Google Books Sales
metadata.google_books_traffic.ISBN13
STRING
NULLABLE
ISBN
metadata.google_books_traffic.Title
STRING
NULLABLE
The title of the book
metadata.jstor_country
RECORD
NULLABLE
Metadata derived from JSTOR country
metadata.jstor_country.ISBN13
STRING
NULLABLE
ISBN of the book (13 digits)
metadata.jstor_country.Book_Title
STRING
NULLABLE
Title of the book
metadata.jstor_country.Book_ID
STRING
NULLABLE
DOI of the book on JSTOR
metadata.jstor_country.Authors
STRING
NULLABLE
Author of the book
metadata.jstor_country.ISBN
STRING
NULLABLE
ISBN of the book
metadata.jstor_country.eISBN
STRING
NULLABLE
ISBN of the digital version of the book (13 digits)
metadata.jstor_country.Copyright_Year
INTEGER
NULLABLE
Publication year
metadata.jstor_country.Disciplines
STRING
NULLABLE
Subject category of the book
metadata.jstor_country.Usage_Type
STRING
NULLABLE
For our case it is Open Access
metadata.jstor_institution
RECORD
NULLABLE
Metadata derived from JSTOR Institutions
metadata.jstor_institution.ISBN13
STRING
NULLABLE
ISBN of the book (13 digits)
metadata.jstor_institution.Book_Title
STRING
NULLABLE
Title of the book
metadata.jstor_institution.Book_ID
STRING
NULLABLE
DOI of the book on JSTOR
metadata.jstor_institution.Authors
STRING
NULLABLE
metadata.jstor_institution.ISBN
STRING
NULLABLE
ISBN of the book (13 digits)
metadata.jstor_institution.eISBN
STRING
NULLABLE
ISBN of the digital version of the book (13 digits)
metadata.jstor_institution.Copyright_Year
INTEGER
NULLABLE
Publication year
metadata.jstor_institution.Disciplines
STRING
NULLABLE
Subject category of the book
metadata.jstor_institution.Usage_Type
STRING
NULLABLE
For our case it is Open Access
metadata.irus_oapen
RECORD
NULLABLE
Metadata derived from IRUS OAPEN
metadata.irus_oapen.ISBN13
STRING
NULLABLE
ISBN of the book
metadata.irus_oapen.book_title
STRING
NULLABLE
Title of the book
metadata.irus_oapen.publisher
STRING
NULLABLE
The publisher
metadata.irus_fulcrum
RECORD
NULLABLE
Metadata derived from IRUS Fulcrum
metadata.irus_fulcrum.ISBN13
STRING
NULLABLE
ISBN of the book
metadata.irus_fulcrum.book_title
STRING
NULLABLE
Title of the book
metadata.irus_fulcrum.publisher
STRING
NULLABLE
The publisher
months
RECORD
REPEATED
Linked Metrics from all sources, organised by month of occurence
months.month
DATE
NULLABLE
Month of Recorded Metrics
months.google_books_sales
RECORD
NULLABLE
Metrics derived from Google Books Sales
months.google_books_sales.qty
INTEGER
NULLABLE
The number of units in the transaction. Negative for refunds
months.google_books_sales.countries
RECORD
REPEATED
The list of countries where buyers brought the book
months.google_books_sales.countries.Country_of_Sale
STRING
NULLABLE
The country where the buyer bought the book
months.google_books_sales.countries.qty
INTEGER
NULLABLE
The number of units in the transaction. Negative for refunds
months.google_books_traffic
RECORD
NULLABLE
Metrics derived from Google Books Traffic
months.google_books_traffic.Book_Visits_BV_
INTEGER
NULLABLE
A Book Visit is registered each time a unique user views one of your books on Google Books. This number includes informational page views (such as the “About this book” page) as well as preview content page views
months.google_books_traffic.BV_with_Pages_Viewed
INTEGER
NULLABLE
The number of Book Visits in which users accessed preview pages of your book. This doesn’t include visits where a user accessed only informational pages for your books
months.google_books_traffic.Non_Unique_Buy_Clicks
INTEGER
NULLABLE
The number of clicks on links for purchasing the book on retailer websites (including your website, if you provided a buy link)
months.google_books_traffic.BV_with_Buy_Clicks
INTEGER
NULLABLE
The number of visits which included a click on a purchase link
months.google_books_traffic.Buy_Link_CTR
FLOAT
NULLABLE
The clickthrough rate for purchase links. The values are percentages
months.google_books_traffic.Pages_Viewed
INTEGER
NULLABLE
The total number of unique preview content pages that a user viewed in a given session (counted as a 24-hour period). If a user views the same page of your book twice during a session, only a single page view is registered
months.jstor_country
RECORD
REPEATED
Metrics derived from JSTOR Country
months.jstor_country.Country_name
STRING
NULLABLE
Country Name
months.jstor_country.Total_Item_Requests
INTEGER
NULLABLE
Total number of request made from that specific country
months.jstor_institution
RECORD
REPEATED
Metrics derived from JSTOR Institutions
months.jstor_institution.Institution
STRING
NULLABLE
Institution name
months.jstor_institution.Total_Item_Requests
INTEGER
NULLABLE
Total number of request made from that specific institution
months.irus_oapen
RECORD
NULLABLE
Metrics from OAPEN. Recorded with the IRUS-UK platform
months.irus_oapen.version
STRING
NULLABLE
Version of the OAPEN IRUS UK API, corresponds to the COUNTER report version
months.irus_oapen.title_requests
INTEGER
NULLABLE
The total number of title requests. Only available for data before 2020-04-01
months.irus_oapen.total_item_investigations
INTEGER
NULLABLE
The total number of item investigations. Only available for data since 2020-04-01
months.irus_oapen.total_item_requests
INTEGER
NULLABLE
The total number of item requests. Only available for data since 2020-04-01
months.irus_oapen.unique_item_investigations
INTEGER
NULLABLE
The number of unique item investigations. Only available for data since 2020-04-01
months.irus_oapen.unique_item_requests
INTEGER
NULLABLE
The number of unique item requests. Only available for data since 2020-04-01
months.irus_oapen.country
RECORD
REPEATED
Record to store statistics on the country level
months.irus_oapen.country.name
STRING
NULLABLE
The country name of the client registered by oapen irus uk
months.irus_oapen.country.code
STRING
NULLABLE
The country code of the client registered by oapen irus uk
months.irus_oapen.country.title_requests
INTEGER
NULLABLE
The total number of title requests. Only available for data before 2020-04-01
months.irus_oapen.country.total_item_investigations
INTEGER
NULLABLE
The total number of item investigations. Only available for data since 2020-04-01
months.irus_oapen.country.total_item_requests
INTEGER
NULLABLE
The total number of item requests. Only available for data since 2020-04-01
months.irus_oapen.country.unique_item_investigations
INTEGER
NULLABLE
The number of unique item investigations. Only available for data since 2020-04-01
months.irus_oapen.country.unique_item_requests
INTEGER
NULLABLE
The number of unique item requests. Only available for data since 2020-04-01
months.irus_oapen.locations
RECORD
REPEATED
Record to store statistics on the location level
months.irus_oapen.locations.latitude
FLOAT
NULLABLE
The latitude geolocated from the client’s ip address
months.irus_oapen.locations.longitude
FLOAT
NULLABLE
The longitude geolocated from the client’s ip address
months.irus_oapen.locations.city
STRING
NULLABLE
The city geolocated from the client’s ip address
months.irus_oapen.locations.country_name
STRING
NULLABLE
The country name geolocated from the client’s ip address
months.irus_oapen.locations.country_code
STRING
NULLABLE
The country code geolocated from the client’s ip address
months.irus_oapen.locations.title_requests
INTEGER
NULLABLE
The total number of title requests. Only available for data before 2020-04-01
months.irus_oapen.locations.total_item_investigations
INTEGER
NULLABLE
The total number of item investigations. Only available for data since 2020-04-01
months.irus_oapen.locations.total_item_requests
INTEGER
NULLABLE
The total number of item requests. Only available for data since 2020-04-01
months.irus_oapen.locations.unique_item_investigations
INTEGER
NULLABLE
The number of unique item investigations. Only available for data since 2020-04-01
months.irus_oapen.locations.unique_item_requests
INTEGER
NULLABLE
The number of unique item requests. Only available for data since 2020-04-01
months.irus_fulcrum
RECORD
NULLABLE
Metrics from Fulcrum. Recorded with the IRUS platform
months.irus_fulcrum.total_item_investigations
INTEGER
NULLABLE
The total number of item investigations
months.irus_fulcrum.total_item_requests
INTEGER
NULLABLE
The total number of item requests
months.irus_fulcrum.unique_item_investigations
INTEGER
NULLABLE
The number of unique item investigations
months.irus_fulcrum.unique_item_requests
INTEGER
NULLABLE
The number of unique item requests
months.irus_fulcrum.country
RECORD
REPEATED
Record to store statistics on the country level
months.irus_fulcrum.country.name
STRING
NULLABLE
The country name of the client
months.irus_fulcrum.country.code
STRING
NULLABLE
The country code of the client
months.irus_fulcrum.country.total_item_investigations
INTEGER
NULLABLE
The total number of item investigations
months.irus_fulcrum.country.total_item_requests
INTEGER
NULLABLE
The total number of item requests
months.irus_fulcrum.country.unique_item_investigations
INTEGER
NULLABLE
The number of unique item investigations
months.irus_fulcrum.country.unique_item_requests
INTEGER
NULLABLE
The number of unique item requests
Data Export Tables
Book List (book_list)
product_id
STRING
NULLABLE
Book Product ID
work_id
STRING
NULLABLE
Book Work ID
work_family_id
STRING
NULLABLE
Book Work Family ID
ProductForm
STRING
NULLABLE
The product form of the book
usage_flag
BOOLEAN
NULLABLE
Was there any usage detected, from any source, for this book
EditionNumber
INTEGER
NULLABLE
The edition number of the book
published_year
INTEGER
NULLABLE
The year the book was published
published_date
DATE
NULLABLE
The date the book was published
publisher_name
STRING
NULLABLE
The name of the publisher
title
STRING
NULLABLE
The Book's Title
subtitle
STRING
NULLABLE
Subtitle of the Book
title_subtitle
STRING
NULLABLE
The concatenated title and subtitle of the Book
keywords
ARRAY<STRING>
REPEATED
A list of keywords
subjects
RECORD
NULLABLE
Subjects associated with this product
subjects.bic_codes
ARRAY<STRING>
REPEATED
A list of BIC subject codes
subjects.bic_top
ARRAY<STRING>
REPEATED
A list of BIC subject codes for the top level subject
subjects.bic_names
ARRAY<STRING>
REPEATED
A list of BIC subject names
subjects.bisac_codes
ARRAY<STRING>
REPEATED
A list of BISAC subject codes
subjects.bisac_top
ARRAY<STRING>
REPEATED
A list of BISAC subject codes for the top level subject
subjects.bisac_names
ARRAY<STRING>
REPEATED
A list of BISAC subject names
subjects.thema_codes
ARRAY<STRING>
REPEATED
A list of Thema subject codes
subjects.thema_top
ARRAY<STRING>
REPEATED
A list of Thema subject codes for the top level subject
subjects.thema_names
ARRAY<STRING>
REPEATED
A list of Thema subject names
authors
RECORD
REPEATED
Author information
authors.person_name
STRING
NULLABLE
Name of the author
authors.person_name_inverted
STRING
NULLABLE
Inverted name of the author
authors.ORCID
STRING
NULLABLE
Author ORCID identifier
Book Metrics (book_metrics)
product_id
STRING
NULLABLE
Book Product ID
work_id
STRING
NULLABLE
Book Work ID
work_family_id
STRING
NULLABLE
Book Work Family ID
title
STRING
NULLABLE
The title of the book
subtitle
STRING
NULLABLE
Subtitle of the Book
title_subtitle
STRING
NULLABLE
The concatenated title and subtitle of the Book
subjects
RECORD
NULLABLE
Subjects associated with this product
subjects.bic_codes
ARRAY<STRING>
REPEATED
A list of BIC subject codes
subjects.bic_top
ARRAY<STRING>
REPEATED
A list of BIC subject codes for the top level subject
subjects.bic_names
ARRAY<STRING>
REPEATED
A list of BIC subject names
subjects.bisac_codes
ARRAY<STRING>
REPEATED
A list of BISAC subject codes
subjects.bisac_top
ARRAY<STRING>
REPEATED
A list of BISAC subject codes for the top level subject
subjects.bisac_names
ARRAY<STRING>
REPEATED
A list of BISAC subject names
subjects.thema_codes
ARRAY<STRING>
REPEATED
A list of Thema subject codes
subjects.thema_top
ARRAY<STRING>
REPEATED
A list of Thema subject codes for the top level subject
subjects.thema_names
ARRAY<STRING>
REPEATED
A list of Thema subject names
authors
RECORD
REPEATED
Author information
authors.person_name
STRING
NULLABLE
Name of the author
authors.person_name_inverted
STRING
NULLABLE
Inverted name of the author
authors.ORCID
STRING
NULLABLE
Author ORCID identifier
published_year
INTEGER
NULLABLE
The Books published year
published_date
DATE
NULLABLE
The publisher Date of the book
publisher_name
STRING
NULLABLE
The name of the publisher
month
DATE
NULLABLE
The month in which the metrics took place
google_books_sales
RECORD
NULLABLE
Metrics from Google Books Sales
google_books_sales.qty
INTEGER
NULLABLE
Quantity of sales
google_books_sales.countries
RECORD
REPEATED
A list of Countries
google_books_sales.countries.Country_of_Sale
STRING
NULLABLE
Country in which sale occured
google_books_sales.countries.qty
INTEGER
NULLABLE
Quantity of sales
google_books_traffic
RECORD
NULLABLE
Metrics from Google Books Traffic
google_books_traffic.Book_Visits_BV_
INTEGER
NULLABLE
A Book Visit is registered each time a unique user views one of your books on Google Books. This number includes informational page views (such as the “About this book” page) as well as preview content page views
google_books_traffic.BV_with_Pages_Viewed
INTEGER
NULLABLE
The number of Book Visits in which users accessed preview pages of your book. This doesn’t include visits where a user accessed only informational pages for your books
google_books_traffic.Non_Unique_Buy_Clicks
INTEGER
NULLABLE
The number of clicks on links for purchasing the book on retailer websites (including your website, if you provided a buy link)
google_books_traffic.BV_with_Buy_Clicks
INTEGER
NULLABLE
The number of visits which included a click on a purchase link
google_books_traffic.Buy_Link_CTR
FLOAT
NULLABLE
The clickthrough rate for purchase links. The values are percentages
google_books_traffic.Pages_Viewed
INTEGER
NULLABLE
The total number of unique preview content pages that a user viewed in a given session (counted as a 24-hour period)
jstor
RECORD
NULLABLE
Metrics from JSTOR
jstor.Total_Item_Requests
INTEGER
NULLABLE
Total number of item requests
irus_oapen
RECORD
NULLABLE
Metrics from OAPEN. Recorded with the IRUS-UK platform
irus_oapen.version
STRING
NULLABLE
Version of the OAPEN IRUS UK API, corresponds to the COUNTER report version
irus_oapen.title_requests
INTEGER
NULLABLE
The total number of title requests. Only available for data before 2020-04-01
irus_oapen.total_item_investigations
INTEGER
NULLABLE
The total number of item investigations. Only available for data since 2020-04-01
irus_oapen.total_item_requests
INTEGER
NULLABLE
The total number of item requests. Only available for data since 2020-04-01
irus_oapen.unique_item_investigations
INTEGER
NULLABLE
The number of unique item investigations. Only available for data since 2020-04-01
irus_oapen.unique_item_requests
INTEGER
NULLABLE
The number of unique item requests. Only available for data since 2020-04-01
irus_fulcrum
RECORD
NULLABLE
Metrics from Fulcrum. Recorded with the IRUS platform
irus_fulcrum.total_item_investigations
INTEGER
NULLABLE
The total number of item investigations.
irus_fulcrum.total_item_requests
INTEGER
NULLABLE
The total number of item requests.
irus_fulcrum.unique_item_investigations
INTEGER
NULLABLE
The number of unique item investigations.
irus_fulcrum.unique_item_requests
INTEGER
NULLABLE
The number of unique item requests.
Book Metrics Author (book_metrics_author)
PersonName
STRING
NULLABLE
The author's full name in the format '[first name] [last name]'
PersonNameInverted
STRING
NULLABLE
The author's full name in the format '[last name], [first name]'
orcid
STRING
NULLABLE
Author's ORCID ID
unique_books
INTEGER
NULLABLE
Number of unique Books matched to the author
month
DATE
NULLABLE
Month in which metrics took place
google_books_sales
RECORD
NULLABLE
Metrics from Google Books Sales
google_books_sales.qty
INTEGER
NULLABLE
Number of sales
google_books_traffic
RECORD
NULLABLE
Metrics from Google Books Traffic
google_books_traffic.Book_Visits_BV_
INTEGER
NULLABLE
A Book Visit is registered each time a unique user views one of your books on Google Books. This number includes informational page views (such as the “About this book” page) as well as preview content page views
google_books_traffic.BV_with_Pages_Viewed
INTEGER
NULLABLE
The number of Book Visits in which users accessed preview pages of your book. This doesn’t include visits where a user accessed only informational pages for your books
google_books_traffic.Non_Unique_Buy_Clicks
INTEGER
NULLABLE
The number of clicks on links for purchasing the book on retailer websites (including your website, if you provided a buy link)
google_books_traffic.BV_with_Buy_Clicks
INTEGER
NULLABLE
The number of visits which included a click on a purchase link
google_books_traffic.Buy_Link_CTR
FLOAT
NULLABLE
The clickthrough rate for purchase links. The values are percentages
google_books_traffic.Pages_Viewed
INTEGER
NULLABLE
The total number of unique preview content pages that a user viewed in a given session (counted as a 24-hour period)
jstor
RECORD
NULLABLE
Metrics from JSTOR
jstor.Total_Item_Requests
INTEGER
NULLABLE
The total number of item requests
irus_oapen
RECORD
NULLABLE
Metrics from OAPEN. Recorded with the IRUS-UK platform
irus_oapen.title_requests
INTEGER
NULLABLE
The total number of title requests. Only available for data before 2020-04-01
irus_oapen.total_item_investigations
INTEGER
NULLABLE
The total number of item investigations. Only available for data since 2020-04-01
irus_oapen.total_item_requests
INTEGER
NULLABLE
The total number of item requests. Only available for data since 2020-04-01
irus_oapen.unique_item_investigations
INTEGER
NULLABLE
The number of unique item investigations. Only available for data since 2020-04-01
irus_oapen.unique_item_requests
INTEGER
NULLABLE
The number of unique item requests. Only available for data since 2020-04-01
irus_fulcrum
RECORD
NULLABLE
Metrics from Fulcrum. Recorded with the IRUS platform
irus_fulcrum.total_item_investigations
INTEGER
NULLABLE
The total number of item investigations.
irus_fulcrum.total_item_requests
INTEGER
NULLABLE
The total number of item requests.
irus_fulcrum.unique_item_investigations
INTEGER
NULLABLE
The number of unique item investigations.
irus_fulcrum.unique_item_requests
INTEGER
NULLABLE
The number of unique item requests.
Book Metrics City (book_metrics_city)
product_id
STRING
NULLABLE
Book Product ID
work_id
STRING
NULLABLE
Book Work ID
work_family_id
STRING
NULLABLE
Book Work Family ID
title
STRING
NULLABLE
The title of the book
subtitle
STRING
NULLABLE
Subtitle of the Book
title_subtitle
STRING
NULLABLE
The concatenated title and subtitle of the Book
published_year
INTEGER
NULLABLE
The publisher year of the book
published_date
DATE
NULLABLE
The publisher Date of the book
publisher_name
STRING
NULLABLE
The name of the publisher
month
DATE
NULLABLE
The month for which the metrics apply to
city
STRING
NULLABLE
The name of the city
coordinates
STRING
NULLABLE
Geographical coordinates of the city
subjects
RECORD
NULLABLE
Subjects associated with this product
subjects.bic_codes
ARRAY<STRING>
REPEATED
A list of BIC subject codes
subjects.bic_top
ARRAY<STRING>
REPEATED
A list of BIC subject codes for the top level subject
subjects.bic_names
ARRAY<STRING>
REPEATED
A list of BIC subject names
subjects.bisac_codes
ARRAY<STRING>
REPEATED
A list of BISAC subject codes
subjects.bisac_top
ARRAY<STRING>
REPEATED
A list of BISAC subject codes for the top level subject
subjects.bisac_names
ARRAY<STRING>
REPEATED
A list of BISAC subject names
subjects.thema_codes
ARRAY<STRING>
REPEATED
A list of Thema subject codes
subjects.thema_top
ARRAY<STRING>
REPEATED
A list of Thema subject codes for the top level subject
subjects.thema_names
ARRAY<STRING>
REPEATED
A list of Thema subject names
authors
RECORD
REPEATED
Author information
authors.person_name
STRING
NULLABLE
Name of the author
authors.person_name_inverted
STRING
NULLABLE
Inverted name of the author
authors.ORCID
STRING
NULLABLE
Author's ORCID identifier
irus_oapen
RECORD
NULLABLE
Metrics from OAPEN. Recorded with the IRUS-UK platform
irus_oapen.title_requests
INTEGER
NULLABLE
The total number of title requests. Only available for data before 2020-04-01
irus_oapen.total_item_investigations
INTEGER
NULLABLE
The total number of item investigations. Only available for data since 2020-04-01
irus_oapen.total_item_requests
INTEGER
NULLABLE
The total number of item requests. Only available for data since 2020-04-01
irus_oapen.unique_item_investigations
INTEGER
NULLABLE
The number of unique item investigations. Only available for data since 2020-04-01
irus_oapen.unique_item_requests
INTEGER
NULLABLE
The number of unique item requests. Only available for data since 2020-04-01
Book Metrics Country (book_metrics_country)
product_id
STRING
NULLABLE
Book Product ID
work_id
STRING
NULLABLE
Book Work ID
work_family_id
STRING
NULLABLE
Book Work Family ID
title
STRING
NULLABLE
The title of the book
subtitle
STRING
NULLABLE
Subtitle of the Book
title_subtitle
STRING
NULLABLE
The concatenated title and subtitle of the Book
published_year
INTEGER
NULLABLE
The publisher year of the book
published_date
DATE
NULLABLE
The publisher Date of the book
publisher_name
STRING
NULLABLE
The name of the publisher
month
DATE
NULLABLE
The month for which the metrics apply to
subjects
RECORD
NULLABLE
Subjects associated with this product
subjects.bic_codes
ARRAY<STRING>
REPEATED
A list of BIC subject codes
subjects.bic_top
ARRAY<STRING>
REPEATED
A list of BIC subject codes for the top level subject
subjects.bic_names
ARRAY<STRING>
REPEATED
A list of BIC subject names
subjects.bisac_codes
ARRAY<STRING>
REPEATED
A list of BISAC subject codes
subjects.bisac_top
ARRAY<STRING>
REPEATED
A list of BISAC subject codes for the top level subject
subjects.bisac_names
ARRAY<STRING>
REPEATED
A list of BISAC subject names
subjects.thema_codes
ARRAY<STRING>
REPEATED
A list of Thema subject codes
subjects.thema_top
ARRAY<STRING>
REPEATED
A list of Thema subject codes for the top level subject
subjects.thema_names
ARRAY<STRING>
REPEATED
A list of Thema subject names
authors
RECORD
REPEATED
Author information
authors.person_name
STRING
NULLABLE
Name of the author
authors.person_name_inverted
STRING
NULLABLE
Inverted name of the author
authors.ORCID
STRING
NULLABLE
Author ORCID identifier
country_code
STRING
NULLABLE
The Country Code
country_name
STRING
NULLABLE
The Country Name
country_iso_name
STRING
NULLABLE
The ISO3166 (alpha 2) Country Name
country_wikipedia_name
STRING
NULLABLE
The Country Wikipedia Name
google_books_sales
RECORD
NULLABLE
Metrics from Google Books Sales
google_books_sales.qty
INTEGER
NULLABLE
The number of units in the transaction. Negative for refunds
jstor
RECORD
NULLABLE
Metrics from JSTOR
jstor.Total_Item_Requests
INTEGER
NULLABLE
Total number of request made
irus_oapen
RECORD
NULLABLE
Metrics from OAPEN. Recorded with the IRUS-UK platform
irus_oapen.title_requests
INTEGER
NULLABLE
The total number of title requests. Only available for data before 2020-04-01
irus_oapen.total_item_investigations
INTEGER
NULLABLE
The total number of item investigations. Only available for data since 2020-04-01
irus_oapen.total_item_requests
INTEGER
NULLABLE
The total number of item requests. Only available for data since 2020-04-01
irus_oapen.unique_item_investigations
INTEGER
NULLABLE
The number of unique item investigations. Only available for data since 2020-04-01
irus_oapen.unique_item_requests
INTEGER
NULLABLE
The number of unique item requests. Only available for data since 2020-04-01
irus_fulcrum
RECORD
NULLABLE
Metrics from Fulcrum. Recorded with the IRUS platform
irus_fulcrum.total_item_investigations
INTEGER
NULLABLE
The total number of item investigations.
irus_fulcrum.total_item_requests
INTEGER
NULLABLE
The total number of item requests.
irus_fulcrum.unique_item_investigations
INTEGER
NULLABLE
The number of unique item investigations.
irus_fulcrum.unique_item_requests
INTEGER
NULLABLE
The number of unique item requests.
Book Metrics Institution (book_metrics_institution)
product_id
STRING
NULLABLE
Book Product ID
title
STRING
NULLABLE
The title of the book
subtitle
STRING
NULLABLE
Subtitle of the Book
title_subtitle
STRING
NULLABLE
The concatenated title and subtitle of the Book
published_year
INTEGER
NULLABLE
The publisher year of the book
published_date
DATE
NULLABLE
The publisher Date of the book
month
DATE
NULLABLE
The month for which the metrics apply to
publisher_name
STRING
NULLABLE
The name of the publisher
institution
STRING
NULLABLE
Institution Name
subjects
RECORD
NULLABLE
Subjects associated with this product
subjects.bic_codes
ARRAY<STRING>
REPEATED
A list of BIC subject codes
subjects.bic_top
ARRAY<STRING>
REPEATED
A list of BIC subject codes for the top level subject
subjects.bic_names
ARRAY<STRING>
REPEATED
A list of BIC subject names
subjects.bisac_codes
ARRAY<STRING>
REPEATED
A list of BISAC subject codes
subjects.bisac_top
ARRAY<STRING>
REPEATED
A list of BISAC subject codes for the top level subject
subjects.bisac_names
ARRAY<STRING>
REPEATED
A list of BISAC subject names
subjects.thema_codes
ARRAY<STRING>
REPEATED
A list of Thema subject codes
subjects.thema_top
ARRAY<STRING>
REPEATED
A list of Thema subject codes for the top level subject
subjects.thema_names
ARRAY<STRING>
REPEATED
A list of Thema subject names
authors
RECORD
REPEATED
Author information
authors.person_name
STRING
NULLABLE
Name of the author
authors.person_name_inverted
STRING
NULLABLE
Inverted name of the author
authors.ORCID
STRING
NULLABLE
Author's ORCID identifier
jstor
RECORD
NULLABLE
Metrics from JSTOR
jstor.Total_Item_Requests
INTEGER
NULLABLE
Total number of request made from that specific institution
Book Metrics Subjects BIC (book_metrics_subject_bic)
subject
STRING
NULLABLE
BIC Subject
subject_code
STRING
NULLABLE
BIC Subject Code
unique_books
INTEGER
NULLABLE
The number of unique books
month
DATE
NULLABLE
The month in which the metrics occurred
google_books_sales
RECORD
NULLABLE
Metrics from Google Books Sales
google_books_sales.qty
INTEGER
NULLABLE
The number of units in the transaction. Negative for refunds
google_books_traffic
RECORD
NULLABLE
Metrics from Google Books Traffic
google_books_traffic.Book_Visits_BV_
INTEGER
NULLABLE
A Book Visit is registered each time a unique user views one of your books on Google Books. This number includes informational page views (such as the “About this book” page) as well as preview content page views
google_books_traffic.BV_with_Pages_Viewed
INTEGER
NULLABLE
The number of Book Visits in which users accessed preview pages of your book. This doesn’t include visits where a user accessed only informational pages for your books
google_books_traffic.Non_Unique_Buy_Clicks
INTEGER
NULLABLE
The number of clicks on links for purchasing the book on retailer websites (including your website, if you provided a buy link)
google_books_traffic.BV_with_Buy_Clicks
INTEGER
NULLABLE
The number of visits which included a click on a purchase link
google_books_traffic.Buy_Link_CTR
FLOAT
NULLABLE
The clickthrough rate for purchase links. The values are percentages
google_books_traffic.Pages_Viewed
INTEGER
NULLABLE
The total number of unique preview content pages that a user viewed in a given session (counted as a 24-hour period)
jstor
RECORD
NULLABLE
Metrics from JSTOR
jstor.Total_Item_Requests
INTEGER
NULLABLE
Total number of request made
irus_oapen
RECORD
NULLABLE
Metrics from OAPEN. Recorded with the IRUS-UK platform
irus_oapen.title_requests
INTEGER
NULLABLE
The total number of title requests. Only available for data before 2020-04-01
irus_oapen.total_item_investigations
INTEGER
NULLABLE
The total number of item investigations. Only available for data since 2020-04-01
irus_oapen.total_item_requests
INTEGER
NULLABLE
The total number of item requests. Only available for data since 2020-04-01
irus_oapen.unique_item_investigations
INTEGER
NULLABLE
The number of unique item investigations. Only available for data since 2020-04-01
irus_oapen.unique_item_requests
INTEGER
NULLABLE
The number of unique item requests. Only available for data since 2020-04-01
irus_fulcrum
RECORD
NULLABLE
Metrics from Fulcrum. Recorded with the IRUS platform
irus_fulcrum.total_item_investigations
INTEGER
NULLABLE
The total number of item investigations.
irus_fulcrum.total_item_requests
INTEGER
NULLABLE
The total number of item requests.
irus_fulcrum.unique_item_investigations
INTEGER
NULLABLE
The number of unique item investigations.
irus_fulcrum.unique_item_requests
INTEGER
NULLABLE
The number of unique item requests.
Book Metrics Subjects BISAC (book_metrics_subject_bisac)
subject
STRING
NULLABLE
BISAC Subject
subject_code
STRING
NULLABLE
BISAC Subject Code
unique_books
INTEGER
NULLABLE
The number of unique books
month
DATE
NULLABLE
The month in which the metrics occurred
google_books_sales
RECORD
NULLABLE
Metrics from Google Books Sales
google_books_sales.qty
INTEGER
NULLABLE
The number of units in the transaction. Negative for refunds
google_books_traffic
RECORD
NULLABLE
Metrics from Google Books Traffic
google_books_traffic.Book_Visits_BV_
INTEGER
NULLABLE
A Book Visit is registered each time a unique user views one of your books on Google Books. This number includes informational page views (such as the “About this book” page) as well as preview content page views
google_books_traffic.BV_with_Pages_Viewed
INTEGER
NULLABLE
The number of Book Visits in which users accessed preview pages of your book. This doesn’t include visits where a user accessed only informational pages for your books
google_books_traffic.Non_Unique_Buy_Clicks
INTEGER
NULLABLE
The number of clicks on links for purchasing the book on retailer websites (including your website, if you provided a buy link)
google_books_traffic.BV_with_Buy_Clicks
INTEGER
NULLABLE
The number of visits which included a click on a purchase link
google_books_traffic.Buy_Link_CTR
FLOAT
NULLABLE
The clickthrough rate for purchase links. The values are percentages
google_books_traffic.Pages_Viewed
INTEGER
NULLABLE
The total number of unique preview content pages that a user viewed in a given session (counted as a 24-hour period)
jstor
RECORD
NULLABLE
Metrics from JSTOR
jstor.Total_Item_Requests
INTEGER
NULLABLE
Total number of request made
irus_oapen
RECORD
NULLABLE
Metrics from OAPEN. Recorded with the IRUS-UK platform
irus_oapen.title_requests
INTEGER
NULLABLE
The total number of title requests. Only available for data before 2020-04-01
irus_oapen.total_item_investigations
INTEGER
NULLABLE
The total number of item investigations. Only available for data since 2020-04-01
irus_oapen.total_item_requests
INTEGER
NULLABLE
The total number of item requests. Only available for data since 2020-04-01
irus_oapen.unique_item_investigations
INTEGER
NULLABLE
The number of unique item investigations. Only available for data since 2020-04-01
irus_oapen.unique_item_requests
INTEGER
NULLABLE
The number of unique item requests. Only available for data since 2020-04-01
irus_fulcrum
RECORD
NULLABLE
Metrics from Fulcrum. Recorded with the IRUS platform
irus_fulcrum.total_item_investigations
INTEGER
NULLABLE
The total number of item investigations.
irus_fulcrum.total_item_requests
INTEGER
NULLABLE
The total number of item requests.
irus_fulcrum.unique_item_investigations
INTEGER
NULLABLE
The number of unique item investigations.
irus_fulcrum.unique_item_requests
INTEGER
NULLABLE
The number of unique item requests.
Book Metrics Subjects Thema (book_metrics_subject_thema)
subject
STRING
NULLABLE
Thema Subject
subject_code
STRING
NULLABLE
Thema Subject Code
unique_books
INTEGER
NULLABLE
The number of unique books
month
DATE
NULLABLE
The month in which the metrics occurred
google_books_sales
RECORD
NULLABLE
Metrics from Google Books Sales
google_books_sales.qty
INTEGER
NULLABLE
The number of units in the transaction. Negative for refunds
google_books_traffic
RECORD
NULLABLE
Metrics from Google Books Traffic
google_books_traffic.Book_Visits_BV_
INTEGER
NULLABLE
A Book Visit is registered each time a unique user views one of your books on Google Books. This number includes informational page views (such as the “About this book” page) as well as preview content page views
google_books_traffic.BV_with_Pages_Viewed
INTEGER
NULLABLE
The number of Book Visits in which users accessed preview pages of your book. This doesn’t include visits where a user accessed only informational pages for your books
google_books_traffic.Non_Unique_Buy_Clicks
INTEGER
NULLABLE
The number of clicks on links for purchasing the book on retailer websites (including your website, if you provided a buy link)
google_books_traffic.BV_with_Buy_Clicks
INTEGER
NULLABLE
The number of visits which included a click on a purchase link
google_books_traffic.Buy_Link_CTR
FLOAT
NULLABLE
The clickthrough rate for purchase links. The values are percentages
google_books_traffic.Pages_Viewed
INTEGER
NULLABLE
The total number of unique preview content pages that a user viewed in a given session (counted as a 24-hour period)
jstor
RECORD
NULLABLE
Metrics from JSTOR
jstor.Total_Item_Requests
INTEGER
NULLABLE
Total number of request made
irus_oapen
RECORD
NULLABLE
Metrics from OAPEN. Recorded with the IRUS-UK platform
irus_oapen.title_requests
INTEGER
NULLABLE
The total number of title requests. Only available for data before 2020-04-01
irus_oapen.total_item_investigations
INTEGER
NULLABLE
The total number of item investigations. Only available for data since 2020-04-01
irus_oapen.total_item_requests
INTEGER
NULLABLE
The total number of item requests. Only available for data since 2020-04-01
irus_oapen.unique_item_investigations
INTEGER
NULLABLE
The number of unique item investigations. Only available for data since 2020-04-01
irus_oapen.unique_item_requests
INTEGER
NULLABLE
The number of unique item requests. Only available for data since 2020-04-01
irus_fulcrum
RECORD
NULLABLE
Metrics from Fulcrum. Recorded with the IRUS platform
irus_fulcrum.total_item_investigations
INTEGER
NULLABLE
The total number of item investigations.
irus_fulcrum.total_item_requests
INTEGER
NULLABLE
The total number of item requests.
irus_fulcrum.unique_item_investigations
INTEGER
NULLABLE
The number of unique item investigations.
irus_fulcrum.unique_item_requests
INTEGER
NULLABLE
The number of unique item requests.
Institution List (institution_list)
institution
STRING
NULLABLE
Institution Name
Last updated