Indian Real Estate - 99acres.com
Data related to Real Estate of India's Major Cities like Mumbai, Hyderabad, etc.
@kaggle.arvanshul_gurgaon_real_estate_99acres_com
Data related to Real Estate of India's Major Cities like Mumbai, Hyderabad, etc.
@kaggle.arvanshul_gurgaon_real_estate_99acres_com
CREATE TABLE gurgaon_10k (
"prop_id" VARCHAR,
"photo_url" VARCHAR,
"medium_photo_url" VARCHAR,
"preference" VARCHAR,
"description" VARCHAR,
"property_type" VARCHAR,
"city" VARCHAR,
"locality" VARCHAR,
"transact_type" DOUBLE,
"owntype" BIGINT,
"bedroom_num" DOUBLE,
"bathroom_num" BIGINT,
"balcony_num" DOUBLE,
"price_per_unit_area" DOUBLE,
"furnish" BIGINT,
"facing" BIGINT,
"age" BIGINT,
"floor_num" VARCHAR,
"total_floor" DOUBLE,
"features" VARCHAR,
"register_date" VARCHAR,
"prop_name" VARCHAR,
"min_price" BIGINT,
"max_price" BIGINT,
"price_sqft" DOUBLE,
"listing" VARCHAR,
"building_id" BIGINT,
"carpet_sqft" DOUBLE,
"superbuiltup_sqft" DOUBLE,
"brokerage" DOUBLE,
"map_details" VARCHAR,
"fsl_data" VARCHAR,
"min_area_sqft" DOUBLE,
"max_area_sqft" DOUBLE,
"formatted" VARCHAR,
"amenities" VARCHAR,
"top_usps" VARCHAR,
"pd_url" VARCHAR,
"expiry_date" VARCHAR,
"group_name" VARCHAR,
"area" VARCHAR,
"price" VARCHAR,
"prop_heading" VARCHAR,
"prop_details_url" VARCHAR,
"class_heading" VARCHAR,
"class_label" VARCHAR,
"secondary_tags" VARCHAR,
"property_images" VARCHAR,
"thumbnail_images" VARCHAR,
"total_landmark_count" DOUBLE,
"formatted_landmark_details" VARCHAR,
"contact_name" VARCHAR,
"contact_company_name" VARCHAR,
"dealer_photo_url" VARCHAR,
"society_name" VARCHAR,
"building_name" VARCHAR,
"city_id" BIGINT,
"locality_wo_city" VARCHAR,
"profile" VARCHAR,
"xid" VARCHAR,
"metadata" VARCHAR,
"location" VARCHAR,
"builtup_sqft" DOUBLE,
"super_sqft" DOUBLE,
"common_furnishing_attributes" VARCHAR,
"quality_score" DOUBLE,
"furnishing_attributes" VARCHAR
);
CREATE TABLE hyderabad (
"spid" BIGINT,
"prop_id" VARCHAR,
"preference" VARCHAR,
"description" VARCHAR,
"property_type" VARCHAR,
"city" VARCHAR,
"transact_type" DOUBLE,
"owntype" BIGINT,
"bedroom_num" DOUBLE,
"price_per_unit_area" DOUBLE,
"furnish" BIGINT,
"facing" BIGINT,
"age" BIGINT,
"total_floor" DOUBLE,
"features" VARCHAR,
"register_date" VARCHAR,
"posting_date" DOUBLE,
"update_date" BIGINT,
"class" VARCHAR,
"res_com" VARCHAR,
"prop_name" VARCHAR,
"property_number" BIGINT,
"min_price" BIGINT,
"max_price" BIGINT,
"price_sqft" DOUBLE,
"proj_id" BIGINT,
"building_id" BIGINT,
"verified" VARCHAR,
"map_details" VARCHAR,
"min_area_sqft" DOUBLE,
"max_area_sqft" DOUBLE,
"amenities" VARCHAR,
"alt_tag" VARCHAR,
"product_type" VARCHAR,
"top_usps" VARCHAR,
"expiry_date" TIMESTAMP,
"property_type_u" BIGINT,
"area" VARCHAR,
"secondary_area" VARCHAR,
"price" VARCHAR,
"prop_heading" VARCHAR,
"value_label" VARCHAR,
"class_heading" VARCHAR,
"class_label" VARCHAR,
"register_date_u" TIMESTAMP,
"registered_days" VARCHAR,
"primary_tags" VARCHAR,
"secondary_tags" VARCHAR,
"total_landmark_count" DOUBLE,
"formatted_landmark_details" VARCHAR,
"society_name" VARCHAR,
"building_name" VARCHAR,
"location" VARCHAR,
"balcony_num" DOUBLE,
"floor_num" VARCHAR
);
CREATE TABLE kolkata (
"prop_id" VARCHAR,
"preference" VARCHAR,
"description" VARCHAR,
"property_type" VARCHAR,
"city" VARCHAR,
"transact_type" DOUBLE,
"owntype" BIGINT,
"bedroom_num" DOUBLE,
"price_per_unit_area" DOUBLE,
"furnish" BIGINT,
"facing" BIGINT,
"age" BIGINT,
"total_floor" DOUBLE,
"features" VARCHAR,
"prop_name" VARCHAR,
"price_sqft" DOUBLE,
"map_details" VARCHAR,
"amenities" VARCHAR,
"area" VARCHAR,
"price" VARCHAR,
"prop_heading" VARCHAR,
"secondary_tags" VARCHAR,
"total_landmark_count" DOUBLE,
"formatted_landmark_details" VARCHAR,
"society_name" VARCHAR,
"building_name" VARCHAR,
"location" VARCHAR,
"balcony_num" DOUBLE,
"floor_num" VARCHAR,
"carpet_sqft" DOUBLE,
"superbuiltup_sqft" DOUBLE,
"builtup_sqft" DOUBLE,
"super_area" DOUBLE,
"superarea_unit" VARCHAR,
"super_sqft" DOUBLE
);
CREATE TABLE mumbai (
"spid" BIGINT,
"prop_id" VARCHAR,
"preference" VARCHAR,
"description" VARCHAR,
"property_type" VARCHAR,
"city" VARCHAR,
"transact_type" DOUBLE,
"owntype" BIGINT,
"bedroom_num" DOUBLE,
"price_per_unit_area" DOUBLE,
"furnish" BIGINT,
"facing" BIGINT,
"age" BIGINT,
"total_floor" DOUBLE,
"features" VARCHAR,
"register_date" VARCHAR,
"posting_date" DOUBLE,
"update_date" BIGINT,
"class" VARCHAR,
"res_com" VARCHAR,
"prop_name" VARCHAR,
"property_number" BIGINT,
"min_price" BIGINT,
"max_price" BIGINT,
"price_sqft" DOUBLE,
"proj_id" BIGINT,
"building_id" BIGINT,
"verified" VARCHAR,
"map_details" VARCHAR,
"min_area_sqft" DOUBLE,
"max_area_sqft" DOUBLE,
"amenities" VARCHAR,
"alt_tag" VARCHAR,
"product_type" VARCHAR,
"top_usps" VARCHAR,
"expiry_date" TIMESTAMP,
"property_type_u" BIGINT,
"area" VARCHAR,
"secondary_area" VARCHAR,
"price" VARCHAR,
"prop_heading" VARCHAR,
"value_label" VARCHAR,
"class_heading" VARCHAR,
"class_label" VARCHAR,
"register_date_u" TIMESTAMP,
"registered_days" VARCHAR,
"primary_tags" VARCHAR,
"secondary_tags" VARCHAR,
"total_landmark_count" DOUBLE,
"formatted_landmark_details" VARCHAR,
"society_name" VARCHAR,
"building_name" VARCHAR,
"location" VARCHAR,
"balcony_num" DOUBLE,
"floor_num" VARCHAR
);
Anyone who has the link will be able to view this.