Global Cost Of Living
Cost of living in 4500+ world cities
@kaggle.mvieira101_global_cost_of_living
Cost of living in 4500+ world cities
@kaggle.mvieira101_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).
| 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 |
CREATE TABLE cost_of_living (
"unnamed_0" BIGINT -- Unnamed: 0,
"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
);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
);Anyone who has the link will be able to view this.