Name: Global Cost Of Living
Creator: Kaggle
License: https://creativecommons.org/publicdomain/zero/1.0/

About this Dataset

Global Cost Of Living

This dataset contains information about the cost of living in almost 5000 cities across the world. The data were gathered by scraping Numbeo's website (https://www.numbeo.com).

Data dictionary

Column	Description
city	Name of the city
country	Name of the country
x1	Meal, Inexpensive Restaurant (USD)
x2	Meal for 2 People, Mid-range Restaurant, Three-course (USD)
x3	McMeal at McDonalds (or Equivalent Combo Meal) (USD)
x4	Domestic Beer (0.5 liter draught, in restaurants) (USD)
x5	Imported Beer (0.33 liter bottle, in restaurants) (USD)
x6	Cappuccino (regular, in restaurants) (USD)
x7	Coke/Pepsi (0.33 liter bottle, in restaurants) (USD)
x8	Water (0.33 liter bottle, in restaurants) (USD)
x9	Milk (regular), (1 liter) (USD)
x10	Loaf of Fresh White Bread (500g) (USD)
x11	Rice (white), (1kg) (USD)
x12	Eggs (regular) (12) (USD)
x13	Local Cheese (1kg) (USD)
x14	Chicken Fillets (1kg) (USD)
x15	Beef Round (1kg) (or Equivalent Back Leg Red Meat) (USD)
x16	Apples (1kg) (USD)
x17	Banana (1kg) (USD)
x18	Oranges (1kg) (USD)
x19	Tomato (1kg) (USD)
x20	Potato (1kg) (USD)
x21	Onion (1kg) (USD)
x22	Lettuce (1 head) (USD)
x23	Water (1.5 liter bottle, at the market) (USD)
x24	Bottle of Wine (Mid-Range, at the market) (USD)
x25	Domestic Beer (0.5 liter bottle, at the market) (USD)
x26	Imported Beer (0.33 liter bottle, at the market) (USD)
x27	Cigarettes 20 Pack (Marlboro) (USD)
x28	One-way Ticket (Local Transport) (USD)
x29	Monthly Pass (Regular Price) (USD)
x30	Taxi Start (Normal Tariff) (USD)
x31	Taxi 1km (Normal Tariff) (USD)
x32	Taxi 1hour Waiting (Normal Tariff) (USD)
x33	Gasoline (1 liter) (USD)
x34	Volkswagen Golf 1.4 90 KW Trendline (Or Equivalent New Car) (USD)
x35	Toyota Corolla Sedan 1.6l 97kW Comfort (Or Equivalent New Car) (USD)
x36	Basic (Electricity, Heating, Cooling, Water, Garbage) for 85m2 Apartment (USD)
x37	1 min. of Prepaid Mobile Tariff Local (No Discounts or Plans) (USD)
x38	Internet (60 Mbps or More, Unlimited Data, Cable/ADSL) (USD)
x39	Fitness Club, Monthly Fee for 1 Adult (USD)
x40	Tennis Court Rent (1 Hour on Weekend) (USD)
x41	Cinema, International Release, 1 Seat (USD)
x42	Preschool (or Kindergarten), Full Day, Private, Monthly for 1 Child (USD)
x43	International Primary School, Yearly for 1 Child (USD)
x44	1 Pair of Jeans (Levis 501 Or Similar) (USD)
x45	1 Summer Dress in a Chain Store (Zara, H&M, ...) (USD)
x46	1 Pair of Nike Running Shoes (Mid-Range) (USD)
x47	1 Pair of Men Leather Business Shoes (USD)
x48	Apartment (1 bedroom) in City Centre (USD)
x49	Apartment (1 bedroom) Outside of Centre (USD)
x50	Apartment (3 bedrooms) in City Centre (USD)
x51	Apartment (3 bedrooms) Outside of Centre (USD)
x52	Price per Square Meter to Buy Apartment in City Centre (USD)
x53	Price per Square Meter to Buy Apartment Outside of Centre (USD)
x54	Average Monthly Net Salary (After Tax) (USD)
x55	Mortgage Interest Rate in Percentages (%), Yearly, for 20 Years Fixed-Rate
data_quality	0 if Numbeo considers that more contributors are needed to increase data quality, else 1

Tables

Cost Of Living

@kaggle.mvieira101_global_cost_of_living.cost_of_living

702.98 KB
4874 rows
59 columns


CREATE TABLE cost_of_living (
  "unnamed_0" BIGINT,
  "city" VARCHAR,
  "country" VARCHAR,
  "x1" DOUBLE,
  "x2" DOUBLE,
  "x3" DOUBLE,
  "x4" DOUBLE,
  "x5" DOUBLE,
  "x6" DOUBLE,
  "x7" DOUBLE,
  "x8" DOUBLE,
  "x9" DOUBLE,
  "x10" DOUBLE,
  "x11" DOUBLE,
  "x12" DOUBLE,
  "x13" DOUBLE,
  "x14" DOUBLE,
  "x15" DOUBLE,
  "x16" DOUBLE,
  "x17" DOUBLE,
  "x18" DOUBLE,
  "x19" DOUBLE,
  "x20" DOUBLE,
  "x21" DOUBLE,
  "x22" DOUBLE,
  "x23" DOUBLE,
  "x24" DOUBLE,
  "x25" DOUBLE,
  "x26" DOUBLE,
  "x27" DOUBLE,
  "x28" DOUBLE,
  "x29" DOUBLE,
  "x30" DOUBLE,
  "x31" DOUBLE,
  "x32" DOUBLE,
  "x33" DOUBLE,
  "x34" DOUBLE,
  "x35" DOUBLE,
  "x36" DOUBLE,
  "x37" DOUBLE,
  "x38" DOUBLE,
  "x39" DOUBLE,
  "x40" DOUBLE,
  "x41" DOUBLE,
  "x42" DOUBLE,
  "x43" DOUBLE,
  "x44" DOUBLE,
  "x45" DOUBLE,
  "x46" DOUBLE,
  "x47" DOUBLE,
  "x48" DOUBLE,
  "x49" DOUBLE,
  "x50" DOUBLE,
  "x51" DOUBLE,
  "x52" DOUBLE,
  "x53" DOUBLE,
  "x54" DOUBLE,
  "x55" DOUBLE,
  "data_quality" BIGINT
);

Cost Of Living V2

@kaggle.mvieira101_global_cost_of_living.cost_of_living_v2

685.69 KB
4956 rows
58 columns


CREATE TABLE cost_of_living_v2 (
  "city" VARCHAR,
  "country" VARCHAR,
  "x1" DOUBLE,
  "x2" DOUBLE,
  "x3" DOUBLE,
  "x4" DOUBLE,
  "x5" DOUBLE,
  "x6" DOUBLE,
  "x7" DOUBLE,
  "x8" DOUBLE,
  "x9" DOUBLE,
  "x10" DOUBLE,
  "x11" DOUBLE,
  "x12" DOUBLE,
  "x13" DOUBLE,
  "x14" DOUBLE,
  "x15" DOUBLE,
  "x16" DOUBLE,
  "x17" DOUBLE,
  "x18" DOUBLE,
  "x19" DOUBLE,
  "x20" DOUBLE,
  "x21" DOUBLE,
  "x22" DOUBLE,
  "x23" DOUBLE,
  "x24" DOUBLE,
  "x25" DOUBLE,
  "x26" DOUBLE,
  "x27" DOUBLE,
  "x28" DOUBLE,
  "x29" DOUBLE,
  "x30" DOUBLE,
  "x31" DOUBLE,
  "x32" DOUBLE,
  "x33" DOUBLE,
  "x34" DOUBLE,
  "x35" DOUBLE,
  "x36" DOUBLE,
  "x37" DOUBLE,
  "x38" DOUBLE,
  "x39" DOUBLE,
  "x40" DOUBLE,
  "x41" DOUBLE,
  "x42" DOUBLE,
  "x43" DOUBLE,
  "x44" DOUBLE,
  "x45" DOUBLE,
  "x46" DOUBLE,
  "x47" DOUBLE,
  "x48" DOUBLE,
  "x49" DOUBLE,
  "x50" DOUBLE,
  "x51" DOUBLE,
  "x52" DOUBLE,
  "x53" DOUBLE,
  "x54" DOUBLE,
  "x55" DOUBLE,
  "data_quality" BIGINT
);