billionaire-postgres-data

01billionaire-table.sql

CREATE TABLE "billionaire" (
  "id" serial PRIMARY KEY,
  "rank" integer,
  "worth" integer,
  "name" varchar,
  "gender" varchar,
  "category" varchar,
  "country" varchar,
  "city" varchar,
  "source" varchar,
  "industries" varchar,
  "citizenship_country" varchar,
  "organization" varchar,
  "title" varchar,
  "birth_year" integer
);

02billionarire-data.sql

INSERT INTO "billionaire" (
  rank, worth, name, gender, category, country, city, 
  source, industries, citizenship_country, organization, title, birth_year
) VALUES
(1,211000,'Bernard Arnault & family','M','Fashion & Retail','France','Paris','LVMH','Fashion & Retail','France','LVMH Moët Hennessy Louis Vuitton','Chairman and CEO',1949),
(2,180000,'Elon Musk','M','Automotive','United States','Austin','Tesla, SpaceX','Automotive','United States','Tesla','CEO',1971),
(3,114000,'Jeff Bezos','M','Technology','United States','Medina','Amazon','Technology','United States','Amazon','Chairman and Founder',1964),
(4,107000,'Larry Ellison','M','Technology','United States','Lanai','Oracle','Technology','United States','Oracle','CTO and Founder',1944),
(5,106000,'Warren Buffett','M','Finance & Investments','United States','Omaha','Berkshire Hathaway','Finance & Investments','United States','Berkshire Hathaway Inc. (Cl A)','CEO',1930),
(6,104000,'Bill Gates','M','Technology','United States','Medina','Microsoft','Technology','United States','Bill & Melinda Gates Foundation','Cochair',1955),
(7,94500,'Michael Bloomberg','M','Media & Entertainment','United States','New York','Bloomberg LP','Media & Entertainment','United States','Bloomberg','CEO',1942),
(8,93000,'Carlos Slim Helu & family','M','Telecom','Mexico','Mexico City','Telecom','Telecom','Mexico','América Móvil','Honorary Chairman',1940),
(9,83400,'Mukesh Ambani','M','Diversified','India','Mumbai','Diversified','Diversified','India','Reliance Industries','Founder and Chairman',1957),
(10,80700,'Steve Ballmer','M','Technology','United States','Hunts Point','Microsoft','Technology','United States','Los Angeles Clippers','Owner',1956),
(11,80500,'Francoise Bettencourt Meyers & family','F','Fashion & Retail','France','Paris','L''Oréal','Fashion & Retail','France','','',1953),
(12,79200,'Larry Page','M','Technology','United States','Palo Alto','Google','Technology','United States','Alphabet','Cofounder and board member',1973),
(13,77300,'Amancio Ortega','M','Fashion & Retail','Spain','La Coruna','Zara','Fashion & Retail','Spain','','',1936),
(14,76000,'Sergey Brin','M','Technology','United States','Los Altos','Google','Technology','United States','Alphabet','Cofounder and board member',1973),
(15,68000,'Zhong Shanshan','M','Food & Beverage','China','Hangzhou','Beverages, pharmaceuticals','Food & Beverage','China','','',1954),
(16,64400,'Mark Zuckerberg','M','Technology','United States','Palo Alto','Facebook','Technology','United States','Meta Platforms','Cofounder',1984),
(17,59000,'Charles Koch & family','M','Diversified','United States','Wichita','Koch Industries','Diversified','United States','Koch Industries, Inc.','Chairman and CEO',1935),
(17,59000,'Julia Koch & family','F','Diversified','United States','New York','Koch Industries','Diversified','United States','','',1962),
(19,58800,'Jim Walton','M','Fashion & Retail','United States','Bentonville','Walmart','Fashion & Retail','United States','Arvest Bank Group, Inc.','Chairman and CEO',1948),
(20,57600,'Rob Walton & family','M','Fashion & Retail','United States','Bentonville','Walmart','Fashion & Retail','United States','Walmart','Director',1944),
(21,56700,'Alice Walton','F','Fashion & Retail','United States','Fort Worth','Walmart','Fashion & Retail','United States','Crystal Bridges Museum of American Art','Philanthropist',1949),
(22,54400,'David Thomson & family','M','Media & Entertainment','Canada','Toronto','Media','Media & Entertainment','Canada','Thomson Reuters Corporation','Chairman',1957),
(23,50100,'Michael Dell','M','Technology','United States','Austin','Dell Technologies','Technology','United States','Dell Inc.','Chairman and CEO',1965),
(24,47200,'Gautam Adani','M','Diversified','India','Ahmedabad','Infrastructure, commodities','Diversified','India','','',1962),
(25,45100,'Phil Knight & family','M','Fashion & Retail','United States','Hillsboro','Nike','Fashion & Retail','United States','Nike','Chairman',1938),
(26,45000,'Zhang Yiming','M','Technology','China','Beijing','TikTok','Technology','China','ByteDance','Founder',1984),
(27,42900,'Dieter Schwarz','M','Fashion & Retail','Germany','Neckarsulm','Retail','Fashion & Retail','Germany','','',1939),
(28,40100,'François Pinault & family','M','Fashion & Retail','France','Paris','Luxury goods','Fashion & Retail','France','','',1936),
(29,39100,'Klaus-Michael Kuehne','M','Logistics','Switzerland','Schindellegi','Shipping','Logistics','Germany','','',1937),
(30,38900,'Giovanni Ferrero','M','Food & Beverage','Belgium','Brussels','Nutella, chocolates','Food & Beverage','Italy','','',1964),
(31,38300,'Jacqueline Mars','F','Food & Beverage','United States','The Plains','Candy, pet food','Food & Beverage','United States','','',1939),
(31,38300,'John Mars','M','Food & Beverage','United States','Jackson','Candy, pet food','Food & Beverage','United States','','',1935),
(33,38000,'Li Ka-shing','M','Diversified','Hong Kong','','Diversified','Diversified','Hong Kong','CK Hutchison Holdings','Senior Advisor',1928),
(34,35300,'Ma Huateng','M','Technology','China','Shenzhen','Internet media','Technology','China','Tencent Holdings','Chairman and CEO',1971),
(35,35000,'Miriam Adelson & family','F','Gambling & Casinos','United States','Las Vegas','Casinos','Gambling & Casinos','United States','','',1945),
(35,35000,'Ken Griffin','M','Finance & Investments','United States','Miami','Hedge funds','Finance & Investments','United States','Citadel LLC','Founder & CEO',1968),
(37,34700,'Mark Mateschitz','M','Food & Beverage','Austria','Salzburg','Red Bull','Food & Beverage','Austria','','',1992),
(38,33400,'Robin Zeng','M','Automotive','China','Ningde','Batteries','Automotive','Hong Kong','','',1969),
(39,32600,'Tadashi Yanai & family','M','Fashion & Retail','Japan','Tokyo','Fashion retail','Fashion & Retail','Japan','','',1949),
(40,32100,'Len Blavatnik','M','Diversified','United Kingdom','London','Music, chemicals','Diversified','United States','','',1957),
(41,31600,'Alain Wertheimer','M','Fashion & Retail','United States','New York','Chanel','Fashion & Retail','France','','',1948),
(41,31600,'Gerard Wertheimer','M','Fashion & Retail','United States','New York','Chanel','Fashion & Retail','France','','',1951),
(43,31200,'Gianluigi Aponte','M','Logistics','Switzerland','Geneva','Shipping','Logistics','Switzerland','','',1940),
(43,31200,'Rafaela Aponte-Diamant','F','Logistics','Switzerland','Geneva','Shipping','Logistics','Switzerland','','',1945),
(45,30200,'Colin Zheng Huang','M','Technology','China','Shanghai','E-commerce','Technology','China','','',1980),
(46,29700,'Reinhold Wuerth & family','M','Manufacturing','Germany','Kuenzelsau','Fasteners','Manufacturing','Germany','','',1935),
(47,29500,'Lee Shau Kee','M','Real Estate','Hong Kong','Hong Kong','Real estate','Real Estate','Hong Kong','','',1928),
(48,28500,'Jeff Yass','M','Finance & Investments','United States','Haverford','Trading, investments','Finance & Investments','United States','','',1958),
(49,28100,'Jim Simons','M','Finance & Investments','United States','East Setauket','Hedge funds','Finance & Investments','United States','Renaissance Technologies Corp.','Founder',1938),
(50,27800,'Stephen Schwarzman','M','Finance & Investments','United States','New York','Investments','Finance & Investments','United States','Blackstone Group','Chairman and CEO',1947),
(51,27400,'Susanne Klatten','F','Automotive','Germany','Bad Homburg','BMW, pharmaceuticals','Automotive','Germany','','',1962),
(52,27000,'Gina Rinehart','F','Metals & Mining','Australia','Perth','Mining','Metals & Mining','Australia','Hancock Prospecting','Executive Chairman',1954),
(53,26700,'William Ding','M','Technology','China','Hangzhou','Online games','Technology','China','','',1971),
(54,26600,'Germán Larrea Mota Velasco & family','M','Metals & Mining','Mexico','Mexico City','Mining','Metals & Mining','Mexico','','',1953),
(55,25600,'Shiv Nadar','M','Technology','India','Delhi','software services','Technology','India','','',1945),
(56,25500,'Low Tuck Kwong','M','Energy','Indonesia','Jakarta','Coal','Energy','Indonesia','','',1948),
(57,25300,'Thomas Peterffy','M','Finance & Investments','United States','Palm Beach','Discount brokerage','Finance & Investments','United States','','',1944),
(58,25200,'Andrey Melnichenko & family','M','Metals & Mining','United Arab Emirates','Ras Al Khaimah','Fertilizers, coal','Metals & Mining','Russia','','',1972),
(59,24600,'Stefan Quandt','M','Automotive','Germany','Frankfurt','BMW','Automotive','Germany','','',1966),
(60,24400,'MacKenzie Scott','F','Technology','United States','Seattle','Amazon','Technology','United States','','Philanthropist',1970),
(61,24200,'R. Budi Hartono','M','Finance & Investments','Indonesia','Kudus','Banking, tobacco','Finance & Investments','Indonesia','','',1941),
(62,23700,'Vladimir Potanin','M','Metals & Mining','Russia','Moscow','Metals','Metals & Mining','Russia','','',1961),
(63,23500,'Jack Ma','M','Technology','China','Hangzhou','E-commerce','Technology','China','','',1964),
(64,23400,'He Xiangjian & family','M','Manufacturing','China','Foshan','Home appliances','Manufacturing','China','','',1942),
(65,23100,'Iris Fontbona & family','F','Metals & Mining','Chile','Santiago','Mining','Metals & Mining','Chile','','',1943),
(65,23100,'Michael Hartono','M','Manufacturing','Indonesia','Kudus','Banking, tobacco','Manufacturing','Indonesia','','',1939),
(67,22900,'James Ratcliffe','M','Manufacturing','United Kingdom','London','Chemicals','Manufacturing','United Kingdom','','',1953),
(68,22600,'Cyrus Poonawalla','M','Healthcare','India','Pune','Vaccines','Healthcare','India','','',1941),
(69,22400,'Masayoshi Son','M','Telecom','Japan','Tokyo','Internet, telecom','Telecom','Japan','SoftBank Group Corp.','CEO',1957),
(70,22100,'Vladimir Lisin','M','Metals & Mining','Russia','Moscow','Steel, transport','Metals & Mining','Russia','','',1956),
(71,22000,'Emmanuel Besnier','M','Food & Beverage','France','Laval','Cheese','Food & Beverage','France','','',1970),
(72,21600,'Abigail Johnson','F','Finance & Investments','United States','Milton','Fidelity','Finance & Investments','United States','Fidelity Investments','CEO',1961),
(72,21600,'Leonid Mikhelson & family','M','Energy','Russia','Moscow','Gas, chemicals','Energy','Russia','','',1955),
(74,21200,'Lukas Walton','M','Fashion & Retail','United States','Chicago','Walmart','Fashion & Retail','United States','','',1986),
(74,21200,'Wang Wei','M','Service','China','Shenzhen','Package delivery','Service','China','','',1970),
(76,21100,'Jensen Huang','M','Technology','United States','Los Altos','Semiconductors','Technology','United States','Nvidia','CEO & President',1963),
(77,21000,'Leonard Lauder','M','Fashion & Retail','United States','New York','Estee Lauder','Fashion & Retail','United States','The Estée Lauder Companies','Chairman Emeritus',1933),
(77,21000,'Takemitsu Takizaki','M','Manufacturing','Japan','Osaka','Sensors','Manufacturing','Japan','','',1945),
(79,20900,'Alexey Mordashov & family','M','Metals & Mining','Russia','Moscow','Steel, investments','Metals & Mining','Russia','','',1965),
(80,20500,'Vagit Alekperov','M','Energy','Russia','Moscow','Oil','Energy','Russia','','',1950),
(81,20200,'Thomas Frist, Jr. & family','M','Healthcare','United States','Nashville','Hospitals','Healthcare','United States','','',1938),
(82,19600,'Andrew Forrest','M','Metals & Mining','Australia','Perth','Mining','Metals & Mining','Australia','','',1961),
(83,19100,'Ray Dalio','M','Finance & Investments','United States','Greenwich','Hedge funds','Finance & Investments','United States','Bridgewater Associates','Founder & Co-Chief Investment Officer',1949),
(84,19000,'Eric Li','M','Automotive','China','Hangzhou','Automobiles','Automotive','China','','',1963),
(84,19000,'Wang Wenyin','M','Metals & Mining','China','Shenzhen','Mining, copper products','Metals & Mining','China','','',1968),
(86,18900,'Eyal Ofer','M','Diversified','Monaco','Monte Carlo','Real estate, shipping','Diversified','Israel','','',1950),
(86,18900,'Qin Yinglin','M','Food & Beverage','China','Nanyang','Pig breeding','Food & Beverage','China','','',1965),
(88,18700,'Wang Chuanfu','M','Automotive','China','Shenzhen','Batteries, automobiles','Automotive','China','','',1966),
(89,18500,'Harold Hamm & family','M','Energy','United States','Oklahoma City','Oil & gas','Energy','United States','Continental Resources Inc. ','Chairman and CEO',1945),
(89,18500,'David Tepper','M','Finance & Investments','United States','Palm Beach','Hedge funds','Finance & Investments','United States','Appaloosa Management','President and Founder',1957),
(89,18500,'Gennady Timchenko','M','Energy','Russia','Moscow','Oil, gas','Energy','Russia','','',1952),
(92,18000,'Daniel Gilbert','M','Finance & Investments','United States','Franklin','Quicken Loans','Finance & Investments','United States','','',1962),
(93,17700,'Lakshmi Mittal','M','Metals & Mining','United Kingdom','London','Steel','Metals & Mining','India','ArcelorMittal (ADR)','Chairman and CEO',1950),
(94,17500,'Steve Cohen','M','Finance & Investments','United States','Greenwich','Hedge funds','Finance & Investments','United States','Point72 Asset Management','Founder',1956),
(94,17500,'Carl Icahn','M','Finance & Investments','United States','Indian Creek','Investments','Finance & Investments','United States','Icahn Capital Management','Founder',1936),
(94,17500,'Savitri Jindal & family','F','Metals & Mining','India','Hisar','Steel','Metals & Mining','India','','',1950),
(97,17400,'Donald Bren','M','Real Estate','United States','Newport Beach','Real estate','Real Estate','United States','Irvine Company','Chairman',1932),
(97,17400,'John Menard, Jr.','M','Fashion & Retail','United States','Eau Claire','Home improvement stores','Fashion & Retail','United States','Menard, Inc.','Founder',1940),
(99,17100,'Rupert Murdoch & family','M','Media & Entertainment','United States','New York','Newspapers, TV network','Media & Entertainment','United States','News Corp Class A','Chairman and CEO',1931),
(100,16700,'Vicky Safra & family','F','Finance & Investments','Switzerland','Crans-Montana','Banking','Finance & Investments','Brazil','','',1953);