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 |
|
|