amz_audible_books

201821 rows


Description

Sure thing! The table in this list called “amz_audible_books” contains information about available books on Amazon Audible. Each row represents a single book in the table and there are several fields within each row:

  • id is a unique identifier for the book, usually starting with the string “AS123456789”
  • asin_audible is a shorter product ID that can be used to quickly locate the book on Amazon Audible’s website
  • total_review represents the number of ratings (stars) given by customers who have listened to the book.
  • total_rating is the average rating given by all reviewers for the book, expressed as a numerical value between 1 and 5 stars
  • language is the preferred language of the book, e.g. “English”, “Spanish” etc.
  • duration represents how long (in minutes) it takes to listen to the entire book
  • md5_hash_categories shows the categories that Amazon Audible uses for categorizing its books, which are not shown on the list provided, but can be used to sort through available books based on genre, popularity, etc.
  • md5_hash_tags is a string that is unique to the book and represents the set of trending keyword tags related to it, which may vary by customer’s preference and browsing activity note: these tags are not shown in the column as they tend to vary every month/quarter
  • scraped includes a timestamp indicating when Amazon Audible began collecting data for this record. This field is generally empty and only shows up on newer versions of Amazon Audible’s API
  • error represents any errors encountered by the API call used to get data about this book, including “rate_too_fast”, “can’t_get_metadata()” etc. It’s mainly useful for debugging purposes.
  • updated_at indicates when was last updated with the information in the Amazon Audible system, usually in a format like datetime
  • created_at is the date that this information was created on Amazon Audible’s servers as per API call note: again, this may not necessarily represent the most up-to-date data available
  • country_id indicates the location of where the book has been sold (Amazon stores globally)
  • book_id refers to a unique identifier assigned by Amazon Audible for each book in its catalog

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id int8 19 √ null
amz_audible_author_reviews.book_id amz_audible_author_r_book_id_d31e733d_fk_amz_audib R
amz_audible_books_categories_m2m.amzaudiblebook_id amz_audible_books_ca_amzaudiblebook_id_c0ac4aa1_fk_amz_audib R
amz_audible_books_customers_rating.amzaudiblebook_id amz_audible_books_cu_amzaudiblebook_id_cbc7b259_fk_amz_audib R
amz_audible_books_tags_m2m.amzaudiblebook_id amz_audible_books_ta_amzaudiblebook_id_424b03c1_fk_amz_audib R
amz_audible_category_history.book_id amz_audible_category_book_id_7e770389_fk_amz_audib R
amz_audible_listeners_also_enjoyed.related_id amz_audible_listener_related_id_00ce4264_fk_amz_audib R
amz_audible_people_who_viewed.related_id amz_audible_people_w_related_id_9ab01c3d_fk_amz_audib R
amz_audible_rating_history.book_id amz_audible_rating_h_book_id_089528e1_fk_amz_audib R
amz_audible_related_to_this.related_id amz_audible_related__related_id_09682afd_fk_amz_audib R
amz_audible_review_history.book_id amz_audible_review_h_book_id_cea0ab80_fk_amz_audib R
amz_audible_stars.book_id amz_audible_stars_book_id_9b5ea4c0_fk_amz_audible_books_id R
amz_audible_tag_history.book_id amz_audible_tag_hist_book_id_7c5f9b76_fk_amz_audib R
asin_audible varchar 10 √ null
total_review float8 17,17 √ null
total_rating int4 10 √ null
language varchar 32 √ null
duration varchar 64 √ null
md5_hash_categories varchar 32 √ null
md5_hash_tags varchar 32 √ null
scraped bool 1 null
error bool 1 null
updated_at timestamptz 35,6 null
created_at timestamptz 35,6 null
country_id int8 19 √ null
amz_audible_countries.id amz_audible_books_country_id_193d2ac4_fk_amz_audib R
book_id int8 19 √ null
amz_books.id amz_audible_books_book_id_102b3c53_fk_amz_books_id R
check_by_validation bool 1 null
in_data_validation bool 1 null
status_data_validation jsonb 2147483647 √ null

Indexes

Constraint Name Type Sort Column(s)
amz_audible_books_pkey Primary key Asc id
amz_audible_books_book_id_102b3c53 Performance Asc book_id
amz_audible_books_country_id_193d2ac4 Performance Asc country_id
FK_amz_audible_books_amz_books Performance Asc book_id

Relationships

Close relationships within degrees of separation