ds_fortune_1000_v1


Description

{“what”:“Fortune 1000 company list for a given year; each row is one company.”,“why”:“Provides the base dataset for ranking and analysis of top US companies.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:05:29.479985094+00:00”}

Columns

Column Type Size Nulls Auto Default Children Parents Comments
company text 2147483647 √ null

{“what”:“Company name as reported in Fortune list.”,“why”:“Identifies each row; needed for display and joins.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:05:29.513104138+00:00”}

rank int8 19 √ null

{“what”:“Fortune rank for the year, 1 to 1000.”,“why”:“Defines ordering; without it the list is unordered.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:05:29.525119092+00:00”}

rank_change float8 17,17 √ null

{“what”:“Change in rank from previous year (positive=up, negative=down).”,“why”:“Shows movement; without it trend analysis is impossible.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:05:29.556868159+00:00”}

revenue float8 17,17 √ null

{“what”:“Annual revenue in US dollars (likely millions).”,“why”:“Core metric for ranking; needed for comparisons.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:05:29.660561261+00:00”}

profit float8 17,17 √ null

{“what”:“Annual profit in US dollars (likely millions).”,“why”:“Measures profitability; needed for financial analysis.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:05:29.763247126+00:00”}

num. of employees int8 19 √ null
sector text 2147483647 √ null

{“what”:“Industry sector classification (e.g., Technology, Retail).”,“why”:“Enables sector-wise aggregation and benchmarking.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:05:29.883265336+00:00”}

city text 2147483647 √ null

{“what”:“Headquarters city.”,“why”:“Geographic analysis; needed for regional breakdowns.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:05:29.906024529+00:00”}

state text 2147483647 √ null

{“what”:“Headquarters state (US state code or name).”,“why”:“State-level analysis; needed for regional comparisons.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:05:29.928145163+00:00”}

newcomer bool 1 √ null

{“what”:“True if company is new to the list this year.”,“why”:“Identifies first-time entries; needed for churn analysis.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:05:29.948701892+00:00”}

ceo_founder bool 1 √ null

{“what”:“True if CEO is also a founder of the company.”,“why”:“Indicates founder-led firms; used for governance studies.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:05:30.008366491+00:00”}

ceo_woman bool 1 √ null

{“what”:“True if CEO is female.”,“why”:“Tracks gender diversity; needed for diversity metrics.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:05:30.033164816+00:00”}

profitable bool 1 √ null

{“what”:“True if company reported positive profit.”,“why”:“Quick profitability flag; used for filtering and classification.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:05:30.045861585+00:00”}

prev_rank float8 17,17 √ null

{“what”:“Rank in previous year (null if not listed).”,“why”:“Enables rank change calculation; needed for movement analysis.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:05:30.069710576+00:00”}

CEO text 2147483647 √ null

{“what”:“Name of the current CEO.”,“why”:“Identifies leadership; needed for executive analysis.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:05:30.124630251+00:00”}

Website text 2147483647 √ null

{“what”:“Company’s primary website URL.”,“why”:“Provides external reference; needed for verification and linking.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:05:30.146062658+00:00”}

Ticker text 2147483647 √ null

{“what”:“Stock ticker symbol (e.g., AAPL).”,“why”:“Links to financial data; needed for market analysis.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:05:30.161621867+00:00”}

Market Cap float8 17,17 √ null

Relationships