Schemas

Aggregate Works

Work ID ISBN (onix_workid_isbn)

Name	Type	Mode	Description
isbn13	STRING	NULLABLE	ISBN13
work_id	STRING	NULLABLE	The WorkID. Likely to be an ISBN.

Work ID ISBN Errors (onix_workid_isbn_errors)

Name	Type	Mode	Description
Error	STRING	NULLABLE	Error string

Work Family ID ISBN (onix_workfamilyid_isbn)

Name	Type	Mode	Description
isbn13	STRING	NULLABLE	ISBN13
work_family_id	STRING	NULLABLE	The Work Family ID. Likely to be an ISBN.

Book List (book)

Name	Type	Mode	Description
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)

Name	Type	Mode	Description
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)

Name	Type	Mode	Description
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)

Name	Type	Mode	Description
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)

Name	Type	Mode	Description
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)

Name	Type	Mode	Description
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)

Name	Type	Mode	Description
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)

Name	Type	Mode	Description
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)

Name	Type	Mode	Description
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)

Name	Type	Mode	Description
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)

Name	Type	Mode	Description
institution	STRING	NULLABLE	Institution Name