Forbes Billionaires Evolution (1997-2024)
Comprehensive Data on Billionaires from 1997-2024
@kaggle.guillemservera_forbes_billionaires_1997_2023
Comprehensive Data on Billionaires from 1997-2024
@kaggle.guillemservera_forbes_billionaires_1997_2023
Introduction:
The "Forbes Billionaires Evolution" dataset provides a comprehensive examination of the financial growth and status of global billionaires from 1997 to 2024. It meticulously chronicles the transformations, both subtle and substantial, in the fortunes of these financial titans over nearly three decades.
The cover image used for this dataset is sourced from Forbes, with the illustration credited to Geoff J. Kim for Forbes.
Content:
This dataset offers a plethora of valuable information, including:
Use Cases:
The potential applications for this dataset are vast and varied:
Leverage this dataset to extract trends, narratives, and crucial data-driven insights into the financial landscape of our world's most affluent individuals.
CREATE TABLE all_billionaires_1997_2024 (
  "year" BIGINT,
  "month" BIGINT,
  "rank" DOUBLE,
  "net_worth" VARCHAR,
  "last_name" VARCHAR,
  "first_name" VARCHAR,
  "full_name" VARCHAR,
  "birth_date" TIMESTAMP,
  "age" DOUBLE,
  "gender" VARCHAR,
  "country_of_citizenship" VARCHAR,
  "country_of_residence" VARCHAR,
  "city_of_residence" VARCHAR,
  "business_category" VARCHAR,
  "business_industries" VARCHAR,
  "organization_name" VARCHAR,
  "position_in_organization" VARCHAR,
  "self_made" VARCHAR,
  "wealth_status" VARCHAR
);CREATE TABLE billionaires_1997 (
  "year" BIGINT,
  "month" BIGINT,
  "rank" VARCHAR,
  "net_worth" VARCHAR,
  "last_name" VARCHAR,
  "first_name" VARCHAR,
  "full_name" VARCHAR,
  "birth_date" TIMESTAMP,
  "age" BIGINT,
  "gender" VARCHAR,
  "country_of_citizenship" VARCHAR,
  "country_of_residence" VARCHAR,
  "city_of_residence" VARCHAR,
  "business_category" VARCHAR,
  "business_industries" VARCHAR,
  "organization_name" VARCHAR,
  "position_in_organization" VARCHAR,
  "self_made" BOOLEAN,
  "wealth_status" VARCHAR
);CREATE TABLE billionaires_1998 (
  "year" BIGINT,
  "month" BIGINT,
  "rank" VARCHAR,
  "net_worth" VARCHAR,
  "last_name" VARCHAR,
  "first_name" VARCHAR,
  "full_name" VARCHAR,
  "birth_date" TIMESTAMP,
  "age" BIGINT,
  "gender" VARCHAR,
  "country_of_citizenship" VARCHAR,
  "country_of_residence" VARCHAR,
  "city_of_residence" VARCHAR,
  "business_category" VARCHAR,
  "business_industries" VARCHAR,
  "organization_name" VARCHAR,
  "position_in_organization" VARCHAR,
  "self_made" BOOLEAN,
  "wealth_status" VARCHAR
);CREATE TABLE billionaires_1999 (
  "year" BIGINT,
  "month" BIGINT,
  "rank" VARCHAR,
  "net_worth" VARCHAR,
  "last_name" VARCHAR,
  "first_name" VARCHAR,
  "full_name" VARCHAR,
  "birth_date" TIMESTAMP,
  "age" DOUBLE,
  "gender" VARCHAR,
  "country_of_citizenship" VARCHAR,
  "country_of_residence" VARCHAR,
  "city_of_residence" VARCHAR,
  "business_category" VARCHAR,
  "business_industries" VARCHAR,
  "organization_name" VARCHAR,
  "position_in_organization" VARCHAR,
  "self_made" BOOLEAN,
  "wealth_status" VARCHAR
);CREATE TABLE billionaires_2000 (
  "year" BIGINT,
  "month" BIGINT,
  "rank" DOUBLE,
  "net_worth" VARCHAR,
  "last_name" VARCHAR,
  "first_name" VARCHAR,
  "full_name" VARCHAR,
  "birth_date" TIMESTAMP,
  "age" DOUBLE,
  "gender" VARCHAR,
  "country_of_citizenship" VARCHAR,
  "country_of_residence" VARCHAR,
  "city_of_residence" VARCHAR,
  "business_category" VARCHAR,
  "business_industries" VARCHAR,
  "organization_name" VARCHAR,
  "position_in_organization" VARCHAR,
  "self_made" BOOLEAN,
  "wealth_status" VARCHAR
);CREATE TABLE billionaires_2001 (
  "year" BIGINT,
  "month" BIGINT,
  "rank" BIGINT,
  "net_worth" VARCHAR,
  "last_name" VARCHAR,
  "first_name" VARCHAR,
  "full_name" VARCHAR,
  "birth_date" TIMESTAMP,
  "age" DOUBLE,
  "gender" VARCHAR,
  "country_of_citizenship" VARCHAR,
  "country_of_residence" VARCHAR,
  "city_of_residence" VARCHAR,
  "business_category" VARCHAR,
  "business_industries" VARCHAR,
  "organization_name" VARCHAR,
  "position_in_organization" VARCHAR,
  "self_made" VARCHAR,
  "wealth_status" VARCHAR
);CREATE TABLE billionaires_2002 (
  "year" BIGINT,
  "month" BIGINT,
  "rank" BIGINT,
  "net_worth" VARCHAR,
  "last_name" VARCHAR,
  "first_name" VARCHAR,
  "full_name" VARCHAR,
  "birth_date" TIMESTAMP,
  "age" DOUBLE,
  "gender" VARCHAR,
  "country_of_citizenship" VARCHAR,
  "country_of_residence" VARCHAR,
  "city_of_residence" VARCHAR,
  "business_category" VARCHAR,
  "business_industries" VARCHAR,
  "organization_name" VARCHAR,
  "position_in_organization" VARCHAR,
  "self_made" VARCHAR,
  "wealth_status" VARCHAR
);CREATE TABLE billionaires_2003 (
  "year" BIGINT,
  "month" BIGINT,
  "rank" BIGINT,
  "net_worth" VARCHAR,
  "last_name" VARCHAR,
  "first_name" VARCHAR,
  "full_name" VARCHAR,
  "birth_date" TIMESTAMP,
  "age" DOUBLE,
  "gender" VARCHAR,
  "country_of_citizenship" VARCHAR,
  "country_of_residence" VARCHAR,
  "city_of_residence" VARCHAR,
  "business_category" VARCHAR,
  "business_industries" VARCHAR,
  "organization_name" VARCHAR,
  "position_in_organization" VARCHAR,
  "self_made" VARCHAR,
  "wealth_status" VARCHAR
);CREATE TABLE billionaires_2004 (
  "year" BIGINT,
  "month" BIGINT,
  "rank" BIGINT,
  "net_worth" VARCHAR,
  "last_name" VARCHAR,
  "first_name" VARCHAR,
  "full_name" VARCHAR,
  "birth_date" TIMESTAMP,
  "age" DOUBLE,
  "gender" VARCHAR,
  "country_of_citizenship" VARCHAR,
  "country_of_residence" VARCHAR,
  "city_of_residence" VARCHAR,
  "business_category" VARCHAR,
  "business_industries" VARCHAR,
  "organization_name" VARCHAR,
  "position_in_organization" VARCHAR,
  "self_made" VARCHAR,
  "wealth_status" VARCHAR
);CREATE TABLE billionaires_2005 (
  "year" BIGINT,
  "month" BIGINT,
  "rank" BIGINT,
  "net_worth" VARCHAR,
  "last_name" VARCHAR,
  "first_name" VARCHAR,
  "full_name" VARCHAR,
  "birth_date" TIMESTAMP,
  "age" DOUBLE,
  "gender" VARCHAR,
  "country_of_citizenship" VARCHAR,
  "country_of_residence" VARCHAR,
  "city_of_residence" VARCHAR,
  "business_category" VARCHAR,
  "business_industries" VARCHAR,
  "organization_name" VARCHAR,
  "position_in_organization" VARCHAR,
  "self_made" VARCHAR,
  "wealth_status" VARCHAR
);CREATE TABLE billionaires_2006 (
  "year" BIGINT,
  "month" BIGINT,
  "rank" BIGINT,
  "net_worth" VARCHAR,
  "last_name" VARCHAR,
  "first_name" VARCHAR,
  "full_name" VARCHAR,
  "birth_date" TIMESTAMP,
  "age" BIGINT,
  "gender" VARCHAR,
  "country_of_citizenship" VARCHAR,
  "country_of_residence" VARCHAR,
  "city_of_residence" VARCHAR,
  "business_category" VARCHAR,
  "business_industries" VARCHAR,
  "organization_name" VARCHAR,
  "position_in_organization" VARCHAR,
  "self_made" VARCHAR,
  "wealth_status" VARCHAR
);CREATE TABLE billionaires_2007 (
  "year" BIGINT,
  "month" BIGINT,
  "rank" BIGINT,
  "net_worth" VARCHAR,
  "last_name" VARCHAR,
  "first_name" VARCHAR,
  "full_name" VARCHAR,
  "birth_date" TIMESTAMP,
  "age" DOUBLE,
  "gender" VARCHAR,
  "country_of_citizenship" VARCHAR,
  "country_of_residence" VARCHAR,
  "city_of_residence" VARCHAR,
  "business_category" VARCHAR,
  "business_industries" VARCHAR,
  "organization_name" VARCHAR,
  "position_in_organization" VARCHAR,
  "self_made" VARCHAR,
  "wealth_status" VARCHAR
);CREATE TABLE billionaires_2008 (
  "year" BIGINT,
  "month" BIGINT,
  "rank" BIGINT,
  "net_worth" VARCHAR,
  "last_name" VARCHAR,
  "first_name" VARCHAR,
  "full_name" VARCHAR,
  "birth_date" TIMESTAMP,
  "age" DOUBLE,
  "gender" VARCHAR,
  "country_of_citizenship" VARCHAR,
  "country_of_residence" VARCHAR,
  "city_of_residence" VARCHAR,
  "business_category" VARCHAR,
  "business_industries" VARCHAR,
  "organization_name" VARCHAR,
  "position_in_organization" VARCHAR,
  "self_made" VARCHAR,
  "wealth_status" VARCHAR
);CREATE TABLE billionaires_2009 (
  "year" BIGINT,
  "month" BIGINT,
  "rank" BIGINT,
  "net_worth" VARCHAR,
  "last_name" VARCHAR,
  "first_name" VARCHAR,
  "full_name" VARCHAR,
  "birth_date" TIMESTAMP,
  "age" DOUBLE,
  "gender" VARCHAR,
  "country_of_citizenship" VARCHAR,
  "country_of_residence" VARCHAR,
  "city_of_residence" VARCHAR,
  "business_category" VARCHAR,
  "business_industries" VARCHAR,
  "organization_name" VARCHAR,
  "position_in_organization" VARCHAR,
  "self_made" VARCHAR,
  "wealth_status" VARCHAR
);CREATE TABLE billionaires_2010 (
  "year" BIGINT,
  "month" BIGINT,
  "rank" BIGINT,
  "net_worth" VARCHAR,
  "last_name" VARCHAR,
  "first_name" VARCHAR,
  "full_name" VARCHAR,
  "birth_date" TIMESTAMP,
  "age" DOUBLE,
  "gender" VARCHAR,
  "country_of_citizenship" VARCHAR,
  "country_of_residence" VARCHAR,
  "city_of_residence" VARCHAR,
  "business_category" VARCHAR,
  "business_industries" VARCHAR,
  "organization_name" VARCHAR,
  "position_in_organization" VARCHAR,
  "self_made" BOOLEAN,
  "wealth_status" VARCHAR
);CREATE TABLE billionaires_2011 (
  "year" BIGINT,
  "month" BIGINT,
  "rank" BIGINT,
  "net_worth" VARCHAR,
  "last_name" VARCHAR,
  "first_name" VARCHAR,
  "full_name" VARCHAR,
  "birth_date" TIMESTAMP,
  "age" DOUBLE,
  "gender" VARCHAR,
  "country_of_citizenship" VARCHAR,
  "country_of_residence" VARCHAR,
  "city_of_residence" VARCHAR,
  "business_category" VARCHAR,
  "business_industries" VARCHAR,
  "organization_name" VARCHAR,
  "position_in_organization" VARCHAR,
  "self_made" BOOLEAN,
  "wealth_status" VARCHAR
);CREATE TABLE billionaires_2012 (
  "year" BIGINT,
  "month" BIGINT,
  "rank" BIGINT,
  "net_worth" VARCHAR,
  "last_name" VARCHAR,
  "first_name" VARCHAR,
  "full_name" VARCHAR,
  "birth_date" TIMESTAMP,
  "age" DOUBLE,
  "gender" VARCHAR,
  "country_of_citizenship" VARCHAR,
  "country_of_residence" VARCHAR,
  "city_of_residence" VARCHAR,
  "business_category" VARCHAR,
  "business_industries" VARCHAR,
  "organization_name" VARCHAR,
  "position_in_organization" VARCHAR,
  "self_made" BOOLEAN,
  "wealth_status" VARCHAR
);CREATE TABLE billionaires_2013 (
  "year" BIGINT,
  "month" BIGINT,
  "rank" BIGINT,
  "net_worth" VARCHAR,
  "last_name" VARCHAR,
  "first_name" VARCHAR,
  "full_name" VARCHAR,
  "birth_date" TIMESTAMP,
  "age" DOUBLE,
  "gender" VARCHAR,
  "country_of_citizenship" VARCHAR,
  "country_of_residence" VARCHAR,
  "city_of_residence" VARCHAR,
  "business_category" VARCHAR,
  "business_industries" VARCHAR,
  "organization_name" VARCHAR,
  "position_in_organization" VARCHAR,
  "self_made" BOOLEAN,
  "wealth_status" VARCHAR
);CREATE TABLE billionaires_2014 (
  "year" BIGINT,
  "month" BIGINT,
  "rank" BIGINT,
  "net_worth" VARCHAR,
  "last_name" VARCHAR,
  "first_name" VARCHAR,
  "full_name" VARCHAR,
  "birth_date" TIMESTAMP,
  "age" DOUBLE,
  "gender" VARCHAR,
  "country_of_citizenship" VARCHAR,
  "country_of_residence" VARCHAR,
  "city_of_residence" VARCHAR,
  "business_category" VARCHAR,
  "business_industries" VARCHAR,
  "organization_name" VARCHAR,
  "position_in_organization" VARCHAR,
  "self_made" BOOLEAN,
  "wealth_status" VARCHAR
);CREATE TABLE billionaires_2015 (
  "year" BIGINT,
  "month" BIGINT,
  "rank" BIGINT,
  "net_worth" VARCHAR,
  "last_name" VARCHAR,
  "first_name" VARCHAR,
  "full_name" VARCHAR,
  "birth_date" TIMESTAMP,
  "age" DOUBLE,
  "gender" VARCHAR,
  "country_of_citizenship" VARCHAR,
  "country_of_residence" VARCHAR,
  "city_of_residence" VARCHAR,
  "business_category" VARCHAR,
  "business_industries" VARCHAR,
  "organization_name" VARCHAR,
  "position_in_organization" VARCHAR,
  "self_made" BOOLEAN,
  "wealth_status" VARCHAR
);CREATE TABLE billionaires_2016 (
  "year" BIGINT,
  "month" BIGINT,
  "rank" BIGINT,
  "net_worth" VARCHAR,
  "last_name" VARCHAR,
  "first_name" VARCHAR,
  "full_name" VARCHAR,
  "birth_date" TIMESTAMP,
  "age" DOUBLE,
  "gender" VARCHAR,
  "country_of_citizenship" VARCHAR,
  "country_of_residence" VARCHAR,
  "city_of_residence" VARCHAR,
  "business_category" VARCHAR,
  "business_industries" VARCHAR,
  "organization_name" VARCHAR,
  "position_in_organization" VARCHAR,
  "self_made" BOOLEAN,
  "wealth_status" VARCHAR
);CREATE TABLE billionaires_2017 (
  "year" BIGINT,
  "month" BIGINT,
  "rank" BIGINT,
  "net_worth" VARCHAR,
  "last_name" VARCHAR,
  "first_name" VARCHAR,
  "full_name" VARCHAR,
  "birth_date" TIMESTAMP,
  "age" DOUBLE,
  "gender" VARCHAR,
  "country_of_citizenship" VARCHAR,
  "country_of_residence" VARCHAR,
  "city_of_residence" VARCHAR,
  "business_category" VARCHAR,
  "business_industries" VARCHAR,
  "organization_name" VARCHAR,
  "position_in_organization" VARCHAR,
  "self_made" BOOLEAN,
  "wealth_status" VARCHAR
);CREATE TABLE billionaires_2018 (
  "year" BIGINT,
  "month" BIGINT,
  "rank" BIGINT,
  "net_worth" VARCHAR,
  "last_name" VARCHAR,
  "first_name" VARCHAR,
  "full_name" VARCHAR,
  "birth_date" TIMESTAMP,
  "age" DOUBLE,
  "gender" VARCHAR,
  "country_of_citizenship" VARCHAR,
  "country_of_residence" VARCHAR,
  "city_of_residence" VARCHAR,
  "business_category" VARCHAR,
  "business_industries" VARCHAR,
  "organization_name" VARCHAR,
  "position_in_organization" VARCHAR,
  "self_made" BOOLEAN,
  "wealth_status" VARCHAR
);CREATE TABLE billionaires_2019 (
  "year" BIGINT,
  "month" BIGINT,
  "rank" BIGINT,
  "net_worth" VARCHAR,
  "last_name" VARCHAR,
  "first_name" VARCHAR,
  "full_name" VARCHAR,
  "birth_date" TIMESTAMP,
  "age" DOUBLE,
  "gender" VARCHAR,
  "country_of_citizenship" VARCHAR,
  "country_of_residence" VARCHAR,
  "city_of_residence" VARCHAR,
  "business_category" VARCHAR,
  "business_industries" VARCHAR,
  "organization_name" VARCHAR,
  "position_in_organization" VARCHAR,
  "self_made" BOOLEAN,
  "wealth_status" VARCHAR
);CREATE TABLE billionaires_2020 (
  "year" BIGINT,
  "month" BIGINT,
  "rank" BIGINT,
  "net_worth" VARCHAR,
  "last_name" VARCHAR,
  "first_name" VARCHAR,
  "full_name" VARCHAR,
  "birth_date" TIMESTAMP,
  "age" DOUBLE,
  "gender" VARCHAR,
  "country_of_citizenship" VARCHAR,
  "country_of_residence" VARCHAR,
  "city_of_residence" VARCHAR,
  "business_category" VARCHAR,
  "business_industries" VARCHAR,
  "organization_name" VARCHAR,
  "position_in_organization" VARCHAR,
  "self_made" BOOLEAN,
  "wealth_status" VARCHAR
);Anyone who has the link will be able to view this.