Known Seller IDs attributed to Amazon (Vendor/1P)

Table Definition

Name	Type	Note
marketplace	string	Amazon Marketplace 2 letter identifier
seller_id	string	Amazon merchant ID
seller_name	string	Seller business name
seller_address	string	Seller Address (if available)
seller_phone_number	string	Seller Phone number (if available)
seller_email	string	Seller Email (if available)
brands	array<string>	array of brands held by seller
vat_id	string	VAT (Value Add Tax) ID
trade_number	string	Trade Register Number
business_type	string	Business Type - null if unavailable
representative	string	The name of the business representative
rating_count_30	bigint	Count of ratings during 30 days prior to last update
rating_count_90	bigint	Count of ratings during 90 days prior to last update
rating_count_365	bigint	Count of ratings during 365 days prior to last update
rating_count_lifetime	bigint	Count of lifetime ratings prior to last update
positive_rating_30	bigint	Count of positive (4 or 5 star) ratings during 30 days prior to last update
positive_rating_90	bigint	Count of positive (4 or 5 star) ratings during 90 days prior to last update
positive_rating_365	bigint	Count of positive (4 or 5 star) ratings during 365 days prior to last update
positive_rating_lifetime	bigint	Count of positive (4 or 5 star) ratings during lifetime prior to last update
negative_rating_30	bigint	Count of negative (1 or 2 star) ratings during 30 days prior to last update
negative_rating_90	bigint	Count of negative (1 or 2 star) ratings during 90 days prior to last update
negative_rating_365	bigint	Count of negative (1 or 2 star) ratings during 365 days prior to last update
negative_rating_lifetime	bigint	Count of negative (1 or 2 star) ratings during lifetime prior to last update
neutral_rating_30	bigint	Count of neutral (3 star) ratings during 30 days prior to last update
neutral_rating_90	bigint	Count of neutral (3 star) ratings during 90 days prior to last update
neutral_rating_365	bigint	Count of neutral (3 star) ratings during 365 days prior to last update
neutral_rating_lifetime	bigint	Count of neutral (3 star) ratings during lifetime prior to last update
ships_from_china	boolean	Boolean value indicating whether or not this seller ships from China
updated_at	date	date of last update
tracked_since	date	date of first known existence of seller_id