Data Dictionary

 

COLUMN DATA TYPE EXAMPLE
ticker varchar(10) BIG
company_id varchar(10) cw_4437
company_name varchar(max) BIG LOTS INC
security_type varchar(max) Common Stock
figi_composite varchar(max) BBG000J0D904
share_class varchar(max) BBG001SFZBL7
unique_id varchar(max) EQ0010038600001000
market_sector varchar(max) Equity
exchange_code varchar(max) US
figi varchar(max) BBG000J0D904
security_type2 varchar(max) Common Stock
website_url varchar(max) http://local.biglots.com/
store_location_id varchar(max) 7A1A581D0A46F8CB697FFBEC2015FFE7
store_name varchar(max) Big Lots - Binghamton
address varchar(max) 10 Glenwood Ave.
city varchar(max) Binghamton
state varchar(2) NY
zip numeric(9) 13905
phone numeric(10) 6077290980
latitude decimal(9,4) 42.1082
longitude decimal(9,4) -75.9371
store_hours varchar(max) Monday 9:00 AM - 9:00 PM, Tuesday 9:00 AM - 9:00 PM, Wednesday 9:00 AM - 9:00 PM, Thursday 9:00 AM - 9:00 PM, Friday 9:00 AM - 9:00 PM, Saturday 9:00 AM - 9:00 PM, Sunday 9:00 AM - 8:00 PM
last_change_date datetime(UTC) 1/14/2019
last_change varchar(max) Added
columns_affected varchar(max) All
Was this article helpful?
0 out of 0 found this helpful

Comments

0 comments

Please sign in to leave a comment.