IndianStates.sql

/* 
Indian States
Adapted from: https://en.wikipedia.org/wiki/States_and_union_territories_of_India
Collected by: Rakshith Bellare
*/


CREATE TABLE states
    (`id` INTEGER,`name` VARCHAR(64), `capital` VARCHAR(64), `population` INTEGER, `total_area` INTEGER, `Official_language` VARCHAR(64))
;
    
INSERT INTO states
    (`id`, `name`, `capital`, `population`, `total_area`, `Official_language`)
VALUES
    (   1,      "Jammu & Kashmir",      "Srinagar (Summer) Jammu (Winter)", 12541302,   222236,     "Urdu"),
    (   2,      "Himachal Pradesh",     "Shimla",                           6864602,    55673,      "Urdu"),
    (   3,      "Punjab",               "Chandigarh",                       27743338,   50362,      "Punjabi"),
    (   4,      "Uttarakhand",          "Dehradun",                         10086292,   53483,      "Hindi"),
    (   5,      "Haryana",              "Chandigarh",                       25351462,   44212,      "Hindi"),
    (   6,      "Chhattisgarh",         "Naya Raipur",                      25545198,   135194,     "Hindi"),
    (   7,      "Rajasthan",            "Jaipur",                           68548437,   342269,     "Hindi"),
    (   8,      "Uttar Pradesh",        "Lucknow",                          199812341,  243286,     "Hindi"),
    (   9,      "Bihar",                "Patna",                            104099452,  99200,      "Hindi"),
    (   10,     "Sikkim",               "Gangtok",                          610577,     7096,       "English"),
    (   11,     "Arunachal Pradesh",    "Itanagar",                         183727,     83743,      "English"),
    (   12,     "Assam",                "Dispur",                           31205576,   78550,      "Assamese"),
    (   13,     "Meghalaya",            "Shillong",                         2966889,    22720,      "English"),
    (   14,     "Nagaland",             "Kohima",                           1978502,    16579,      "English"),
    (   15,     "Manipur",              "Imphal",                           255794,     22347,      "Manipuri"),
    (   16,     "Mizoram",              "Aizwal",                           1097206,    21081,      "Mizo"),
    (   17,     "Tripura",              "Agartala",                         3673917,    88792,      "Bengali"),
    (   18,     "West Bengal",          "Kolkata",                          91276115,   10492,      "Bengali"),
    (   19,     "Madya Pradesh",        "Bhopal",                           72626809,   308252,     "Hindi"),
    (   20,     "Gujarat",              "Gandhinagar",                      60439692,   196024,     "Gujarathi"),
    (   21,     "Maharastra",           "Mumbai",                           112374333,  307713,     "Marathi"),
    (   22,     "Odissha",              "Bhubhaneshwar",                    41974218,   155820,     "Odia"),
    (   23,     "Telengana",            "Hyderabad",                        35193978,   114840,     "Telugu"),
    (   24,     "Andhra Pradesh",       "Hyderabad",                        49506799,   160205,     "Telugu"),
    (   25,     "Goa",                  "Panaji",                           1458545,    3702,       "Konkani"),
    (   26,     "Karnataka",            "Bengaluru",                        61095297,   191791,     "Kannada"),
    (   28,     "Kerala",               "Thiruvanathapuram",                33406061,   38863,      "Malayalam"),
    (   29,     "Tamil Nadu",           "Chennai",                          72147030,   130058,     "Tamil")
;