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 (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
STRING
REPEATED
Title of the Book
crossref_objects.type
STRING
NULLABLE
Crossref Type
crossref_objects.publisher
STRING
NULLABLE
Publisher Name
crossref_objects.published_year
INTEGER
NULLABLE
Year of Publication
crossref_objects.published_year_month
STRING
NULLABLE
Month and Year of Publication
crossref_objects.work_isbns
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
STRING
REPEATED
Title of Chapter
chapters.type
STRING
NULLABLE
Crossref Type
events
RECORD
NULLABLE
Crossref events assoicated with ISBN
events.overall
RECORD
REPEATED
Overall Event Count
events.overall.source
STRING
NULLABLE
Event Source
events.overall.count
INTEGER
NULLABLE
Count of Events
events.months
RECORD
REPEATED
Event counts broken down by month
events.months.month
STRING
NULLABLE
Month of the count
events.months.source
STRING
NULLABLE
Event Source
events.months.count
INTEGER
NULLABLE
Event Count in time period
events.years
RECORD
REPEATED
Event counts broken down by month
events.years.year
INTEGER
NULLABLE
Year of count
events.years.source
STRING
NULLABLE
Event Source
events.years.count
INTEGER
NULLABLE
Event count in time period
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.published_year
STRING
NULLABLE
The year the book was published
onix.bic_subjects
STRING
REPEATED
A list of BIC subjects
onix.bisac_subjects
STRING
REPEATED
A list of BISAC subjects
onix.thema_subjects
STRING
REPEATED
A list of THEMA subjects
onix.keywords
STRING
REPEATED
A list of Keywords
onix.authors
RECORD
REPEATED
Book Authors
onix.authors.PersonName
STRING
NULLABLE
The Authors Full Name
onix.authors.ORCID
STRING
NULLABLE
Authors ORCID ID, if present
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
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
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
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
STRING
REPEATED
The Book Chapter title
metadata.chapters.type
STRING
NULLABLE
The Book Chapter type
metadata.events
RECORD
REPEATED
Count of events from Crossref Events
metadata.events.source
STRING
NULLABLE
Event Source Type
metadata.events.count
INTEGER
NULLABLE
Count of events
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_metadata
RECORD
NULLABLE
Metadata derived from JSTOR
metadata.jstor_metadata.ISBN13
STRING
NULLABLE
ISBN of the book (13 digits)
metadata.jstor_metadata.Book_Title
STRING
NULLABLE
Title of the book
metadata.jstor_metadata.Book_ID
STRING
NULLABLE
DOI of the book on JSTOR
metadata.jstor_metadata.Authors
STRING
NULLABLE
Author of the book
metadata.jstor_metadata.ISBN
STRING
NULLABLE
ISBN of the book
metadata.jstor_metadata.eISBN
STRING
NULLABLE
ISBN of the digital version of the book (13 digits)
metadata.jstor_metadata.Copyright_Year
INTEGER
NULLABLE
Publication year
metadata.jstor_metadata.Disciplines
STRING
NULLABLE
Subject category of the book
metadata.jstor_metadata.Usage_Type
STRING
NULLABLE
For our case it is Open Access
metadata.jstor_institution_metadata
RECORD
NULLABLE
Metadata derived from JSTOR Institutions
metadata.jstor_institution_metadata.ISBN13
STRING
NULLABLE
ISBN of the book (13 digits)
metadata.jstor_institution_metadata.Book_Title
STRING
NULLABLE
Title of the book
metadata.jstor_institution_metadata.Book_ID
STRING
NULLABLE
DOI of the book on JSTOR
metadata.jstor_institution_metadata.Authors
STRING
NULLABLE
metadata.jstor_institution_metadata.ISBN
STRING
NULLABLE
ISBN of the book (13 digits)
metadata.jstor_institution_metadata.eISBN
STRING
NULLABLE
ISBN of the digital version of the book (13 digits)
metadata.jstor_institution_metadata.Copyright_Year
INTEGER
NULLABLE
Publication year
metadata.jstor_institution_metadata.Disciplines
STRING
NULLABLE
Subject category of the book
metadata.jstor_institution_metadata.Usage_Type
STRING
NULLABLE
For our case it is Open Access
metadata.irus_oapen_metadata
RECORD
NULLABLE
Metadata derived from IRUS OAPEN
metadata.irus_oapen_metadata.ISBN13
STRING
NULLABLE
ISBN of the book
metadata.irus_oapen_metadata.book_title
STRING
NULLABLE
Title of the book
metadata.irus_oapen_metadata.publisher
STRING
NULLABLE
The publisher
metadata.irus_fulcrum_metadata
RECORD
NULLABLE
Metadata derived from IRUS Fulcrum
metadata.irus_fulcrum_metadata.ISBN13
STRING
NULLABLE
ISBN of the book
metadata.irus_fulcrum_metadata.book_title
STRING
NULLABLE
Title of the book
metadata.irus_fulcrum_metadata.publisher
STRING
NULLABLE
The publisher
metadata.ucl_discovery_metadata
RECORD
NULLABLE
Metadata derived from UCL Discovery
metadata.ucl_discovery_metadata.ISBN13
STRING
NULLABLE
ISBN of the book
metadata.ucl_discovery_metadata.eprint_id
STRING
NULLABLE
The UCL Discovery eprint ID
months
RECORD
REPEATED
Linked Metrics from all sources, organised by month of occurance
months.month
DATE
NULLABLE
Month of Recorded Metrics
months.crossref_events
RECORD
REPEATED
Metrics Derived From Crossref Events
months.crossref_events.source
STRING
NULLABLE
The event source
months.crossref_events.count
INTEGER
NULLABLE
The count of events
months.google_analytics
RECORD
NULLABLE
Metrics derived from Google Analytics
months.google_analytics.views_total_country
RECORD
REPEATED
The total number of views per country
months.google_analytics.views_total_country.name
STRING
NULLABLE
The country name
months.google_analytics.views_total_country.value
INTEGER
NULLABLE
The total number of views
months.google_analytics.downloads_total_country
RECORD
REPEATED
The total number of downloads per country
months.google_analytics.downloads_total_country.name
STRING
NULLABLE
The country name
months.google_analytics.downloads_total_country.value
INTEGER
NULLABLE
The total number of downloads
months.google_analytics.downloads_pdf_book_country
RECORD
REPEATED
PDF book downloads per country
months.google_analytics.downloads_pdf_book_country.name
STRING
NULLABLE
The country name
months.google_analytics.downloads_pdf_book_country.value
INTEGER
NULLABLE
The total number of PDF book downloads
months.google_analytics.downloads_pdf_chapter_country
RECORD
REPEATED
PDF chapter downloads per country
months.google_analytics.downloads_pdf_chapter_country.name
STRING
NULLABLE
The country name
months.google_analytics.downloads_pdf_chapter_country.value
INTEGER
NULLABLE
The total number of PDF chapter downloads
months.google_analytics.downloads_html_book_country
RECORD
REPEATED
HTML book downloads per country
months.google_analytics.downloads_html_book_country.name
STRING
NULLABLE
The country name
months.google_analytics.downloads_html_book_country.value
INTEGER
NULLABLE
The total number of HTML book downloads
months.google_analytics.downloads_html_chapter_country
RECORD
REPEATED
HTML chapter downloads per country
months.google_analytics.downloads_html_chapter_country.name
STRING
NULLABLE
The country name
months.google_analytics.downloads_html_chapter_country.value
INTEGER
NULLABLE
The total number of HTML chapter downloads
months.google_analytics.downloads_epub_book_country
RECORD
REPEATED
EPUB book downloads per country
months.google_analytics.downloads_epub_book_country.name
STRING
NULLABLE
The country name
months.google_analytics.downloads_epub_book_country.value
INTEGER
NULLABLE
The total number of EPUB book downloads
months.google_analytics.downloads_epub_chapter_country
RECORD
REPEATED
EPUB chapter downloads per country
months.google_analytics.downloads_epub_chapter_country.name
STRING
NULLABLE
The country name
months.google_analytics.downloads_epub_chapter_country.value
INTEGER
NULLABLE
The total number of EPUB chapter downloads
months.google_analytics.downloads_mobi_book_country
RECORD
REPEATED
MOBI book downloads per country
months.google_analytics.downloads_mobi_book_country.name
STRING
NULLABLE
The country name
months.google_analytics.downloads_mobi_book_country.value
INTEGER
NULLABLE
The total number of MOBI book downloads
months.google_analytics.downloads_mobi_chapter_country
RECORD
REPEATED
MOBI chapter downloads per country
months.google_analytics.downloads_mobi_chapter_country.name
STRING
NULLABLE
The country name
months.google_analytics.downloads_mobi_chapter_country.value
INTEGER
NULLABLE
The total number of MOBI chapter downloads
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
months.ucl_discovery
RECORD
NULLABLE
Metrics derived from UCL Discovery
months.ucl_discovery.total_downloads
INTEGER
NULLABLE
Number of downloads
months.ucl_discovery.country
RECORD
REPEATED
Number of downloads per country
months.ucl_discovery.country.country_code
STRING
NULLABLE
Country code
months.ucl_discovery.country.country_name
STRING
NULLABLE
Country name
months.ucl_discovery.country.country_downloads
INTEGER
NULLABLE
Number of downloads for the given country
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 published year of the book
published_date
DATE
NULLABLE
The date the book was published
publisher_name
STRING
NULLABLE
The name of the publisher
title
STRING
NULLABLE
The Books Title
bic_subjects
STRING
REPEATED
A list of BIC subjects
bisac_subjects
STRING
REPEATED
A list of BISAC subjects
thema_subjects
STRING
REPEATED
A list of thema subjects
keywords
STRING
REPEATED
A list of keywords
authors.PeronName
STRING
NULLABLE
The author's full name in the format '[first name] [last name]'
authors.PeronNameInverted
STRING
NULLABLE
The author's full name in the format '[last name], [first name]'
ORCID
STRING
NULLABLE
The Authors ORCID ID
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
authors
RECORD
REPEATED
A list of Book Authors
authors.PersonName
STRING
NULLABLE
The author's full name in the format '[first name] [last name]'
authors.PersonNameInverted
STRING
NULLABLE
The author's full name in the format '[last name], [first name]'
authors.ORCID
STRING
NULLABLE
The Authors ORCID ID
published_year
INTEGER
NULLABLE
The Books published year
published_name
STRING
NULLABLE
The name of the publisher
month
DATE
NULLABLE
The month in which the metrics took place
google_analytics
RECORD
NULLABLE
Metrics from Google Analytics
google_analytics.page_views
INTEGER
NULLABLE
Number of page views
google_analytics.downloads
INTEGER
NULLABLE
Number of total downloads
google_analytics.downloads_pdf_book
INTEGER
NULLABLE
Number of PDF book downloads
google_analytics.downloads_pdf_chapter
INTEGER
NULLABLE
Number of PDF chapter downloads
google_analytics.downloads_html_chapter
INTEGER
NULLABLE
Number of HTML chapter downloads
google_analytics.downloads_epub_book
INTEGER
NULLABLE
Number of ePUB book downloads
google_analytics.downloads_epub_chapter
INTEGER
NULLABLE
Number of ePUB chapter downloads
google_analytics.downloads_mobi_book
INTEGER
NULLABLE
Number of MOBI book downloads
google_analytics.downloads_mobi_chapter
INTEGER
NULLABLE
Number of MOBI chapter downloads
crossref_events
RECORD
NULLABLE
Metrics from Crossref Events
crossref_events.count
INTEGER
NULLABLE
Count of events
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)
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
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.
ucl_discovery
RECORD
NULLABLE
Metrics from UCL Discovery
ucl_discovery.total_downloads
INTEGER
NULLABLE
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_analytics
RECORD
NULLABLE
Metrics from Google Analytics
google_analytics.views_total_country
INTEGER
NULLABLE
Number of page views aggregated over all countries
google_analytics.downloads
INTEGER
NULLABLE
Number of total downloads
google_analytics.downloads_pdf_book
INTEGER
NULLABLE
Number of PDF book downloads
google_analytics.downloads_pdf_chapter
INTEGER
NULLABLE
Number of PDF chapter downloads
google_analytics.downloads_html_chapter
INTEGER
NULLABLE
Number of HTML chapter downloads
google_analytics.downloads_epub_book
INTEGER
NULLABLE
Number of ePUB book downloads
google_analytics.downloads_epub_chapter
INTEGER
NULLABLE
Number of ePUB chapter downloads
google_analytics.downloads_mobi_book
INTEGER
NULLABLE
Number of MOBI book downloads
google_analytics.downloads_mobi_chapter
INTEGER
NULLABLE
Number of MOBI chapter downloads
crossref_events
RECORD
NULLABLE
Metrics from Crossref events
crossref_events.count
INTEGER
NULLABLE
Count of events
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)
google_books_sales
RECORD
NULLABLE
Metrics from Google Books Sales
google_books_sales.qty
INTEGER
NULLABLE
Number of sales
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 Events (book_metrics_events)
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
published_year
INTEGER
NULLABLE
The publisher year of the book
publsiher_name
STRING
NULLABLE
The name of the publisher
month
DATE
NULLABLE
The month for which the metrics apply to
event_source
STRING
NULLABLE
Event Source
crossref_events
RECORD
NULLABLE
Metrics from Crossref Events
crossref_events.count
INTEGER
NULLABLE
Count of Events
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
published_year
INTEGER
NULLABLE
The publisher year of the book
published_name
STTING
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
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 Product Metrics Country (book_product_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
published_year
INTEGER
NULLABLE
The publisher year of the book
publisher_name
STRING
NULLABLE
The name of the publisher
month
DATE
NULLABLE
The month for which the metrics apply to
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
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
google_analytics
RECORD
NULLABLE
Metrics from Google Analytics
google_analytics.page_views
INTEGER
NULLABLE
Number of page views
google_analytics.downloads
INTEGER
NULLABLE
Number of total downloads
google_analytics.downloads_pdf_book
INTEGER
NULLABLE
Number of PDF book downloads
google_analytics.downloads_pdf_chapter
INTEGER
NULLABLE
Number of PDF chapter downloads
google_analytics.downloads_html_chapter
INTEGER
NULLABLE
Number of HTML chapter downloads
google_analytics.downloads_epub_book
INTEGER
NULLABLE
Number of ePUB book downloads
google_analytics.downloads_epub_chapter
INTEGER
NULLABLE
Number of ePUB chapter downloads
google_analytics.downloads_mobi_book
INTEGER
NULLABLE
Number of MOBI book downloads
google_analytics.downloads_mobi_chapter
INTEGER
NULLABLE
Number of MOBI chapter downloads
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.
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
ucl_discovery
RECORD
NULLABLE
Metrics from UCL Discovery
ucl_discovery.download_count
INTEGER
NULLABLE
Number of downloads
Book Metrics Institution (book_metrics_institution)
product_id
STRING
NULLABLE
Book Product ID
title
STRING
NULLABLE
The title of the book
published_year
INTEGER
NULLABLE
The publisher year of the book
month
DATE
NULLABLE
The month for which the metrics apply to
institution
STRING
NULLABLE
Institution Name
jstor
RECORD
NULLABLE
Metrics from JSTOR
jstor.Total_Item_Requests
INTEGER
NULLABLE
Total number of request made from that specific institution
Book Product Subjects BIC (book_product_subjects_bic_metrics)
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_analytics
RECORD
NULLABLE
Metrics from Google Analytics
google_analytics.page_views
INTEGER
NULLABLE
Number of page views
google_analytics.downloads
INTEGER
NULLABLE
Number of total downloads
google_analytics.downloads_pdf_book
INTEGER
NULLABLE
Number of PDF book downloads
google_analytics.downloads_pdf_chapter
INTEGER
NULLABLE
Number of PDF chapter downloads
google_analytics.downloads_html_chapter
INTEGER
NULLABLE
Number of HTML chapter downloads
google_analytics.downloads_epub_book
INTEGER
NULLABLE
Number of ePUB book downloads
google_analytics.downloads_epub_chapter
INTEGER
NULLABLE
Number of ePUB chapter downloads
google_analytics.downloads_mobi_book
INTEGER
NULLABLE
Number of MOBI book downloads
google_analytics.downloads_mobi_chapter
INTEGER
NULLABLE
Number of MOBI chapter downloads
crossref_events
RECORD
NULLABLE
Metrics from Crossref events
crossref_events.count
INTEGER
NULLABLE
Count of events
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)
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 Product Subjects BISAC (book_product_subjects_bisac_metrics)
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_analytics
RECORD
NULLABLE
Metrics from Google Analytics
google_analytics.page_views
INTEGER
NULLABLE
Number of page views
google_analytics.downloads
INTEGER
NULLABLE
Number of total downloads
google_analytics.downloads_pdf_book
INTEGER
NULLABLE
Number of PDF book downloads
google_analytics.downloads_pdf_chapter
INTEGER
NULLABLE
Number of PDF chapter downloads
google_analytics.downloads_html_chapter
INTEGER
NULLABLE
Number of HTML chapter downloads
google_analytics.downloads_epub_book
INTEGER
NULLABLE
Number of ePUB book downloads
google_analytics.downloads_epub_chapter
INTEGER
NULLABLE
Number of ePUB chapter downloads
google_analytics.downloads_mobi_book
INTEGER
NULLABLE
Number of MOBI book downloads
google_analytics.downloads_mobi_chapter
INTEGER
NULLABLE
Number of MOBI chapter downloads
crossref_events
RECORD
NULLABLE
Metrics from Crossref events
crossref_events.count
INTEGER
NULLABLE
Count of events
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)
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 Product Subjects THEMA (book_product_subjects_thema_metrics)
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_analytics
RECORD
NULLABLE
Metrics from Google Analytics
google_analytics.page_views
INTEGER
NULLABLE
Number of page views
google_analytics.downloads
INTEGER
NULLABLE
Number of total downloads
google_analytics.downloads_pdf_book
INTEGER
NULLABLE
Number of PDF book downloads
google_analytics.downloads_pdf_chapter
INTEGER
NULLABLE
Number of PDF chapter downloads
google_analytics.downloads_html_chapter
INTEGER
NULLABLE
Number of HTML chapter downloads
google_analytics.downloads_epub_book
INTEGER
NULLABLE
Number of ePUB book downloads
google_analytics.downloads_epub_chapter
INTEGER
NULLABLE
Number of ePUB chapter downloads
google_analytics.downloads_mobi_book
INTEGER
NULLABLE
Number of MOBI book downloads
google_analytics.downloads_mobi_chapter
INTEGER
NULLABLE
Number of MOBI chapter downloads
crossref_events
RECORD
NULLABLE
Metrics from Crossref events
crossref_events.count
INTEGER
NULLABLE
Count of events
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)
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.
Institution List (institution_list)
institution
STRING
NULLABLE
Institution Name
Last updated