-- phpMyAdmin SQL Dump
-- version 5.0.1
-- https://www.phpmyadmin.net/
--
-- Host: 127.0.0.1
-- Generation Time: May 09, 2020 at 04:02 PM
-- Server version: 10.4.11-MariaDB
-- PHP Version: 7.4.3

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
SET AUTOCOMMIT = 0;
START TRANSACTION;
SET time_zone = "+00:00";


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8mb4 */;

--
-- Database: `mod-mysql-basic-worldhappiness`
--

-- --------------------------------------------------------

--
-- Table structure for table `jaar2015`
--

CREATE TABLE `jaar2015` (
  `country` varchar(24) DEFAULT NULL,
  `region` varchar(31) DEFAULT NULL,
  `rank` int(3) DEFAULT NULL,
  `score` int(4) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `jaar2015`
--

INSERT INTO `jaar2015` (`country`, `region`, `rank`, `score`) VALUES
('Switzerland', 'Western Europe', 1, 7587),
('Iceland', 'Western Europe', 2, 7561),
('Denmark', 'Western Europe', 3, 7527),
('Norway', 'Western Europe', 4, 7522),
('Canada', 'North America', 5, 7427),
('Finland', 'Western Europe', 6, 7406),
('Netherlands', 'Western Europe', 7, 7378),
('Sweden', 'Western Europe', 8, 7364),
('New Zealand', 'Australia and New Zealand', 9, 7286),
('Australia', 'Australia and New Zealand', 10, 7284),
('Israel', 'Middle East and Northern Africa', 11, 7278),
('Costa Rica', 'Latin America and Caribbean', 12, 7226),
('Austria', 'Western Europe', 13, 72),
('Mexico', 'Latin America and Caribbean', 14, 7187),
('United States', 'North America', 15, 7119),
('Brazil', 'Latin America and Caribbean', 16, 6983),
('Luxembourg', 'Western Europe', 17, 6946),
('Ireland', 'Western Europe', 18, 694),
('Belgium', 'Western Europe', 19, 6937),
('United Arab Emirates', 'Middle East and Northern Africa', 20, 6901),
('United Kingdom', 'Western Europe', 21, 6867),
('Oman', 'Middle East and Northern Africa', 22, 6853),
('Venezuela', 'Latin America and Caribbean', 23, 681),
('Singapore', 'Southeastern Asia', 24, 6798),
('Panama', 'Latin America and Caribbean', 25, 6786),
('Germany', 'Western Europe', 26, 675),
('Chile', 'Latin America and Caribbean', 27, 667),
('Qatar', 'Middle East and Northern Africa', 28, 6611),
('France', 'Western Europe', 29, 6575),
('Argentina', 'Latin America and Caribbean', 30, 6574),
('Czech Republic', 'Central and Eastern Europe', 31, 6505),
('Uruguay', 'Latin America and Caribbean', 32, 6485),
('Colombia', 'Latin America and Caribbean', 33, 6477),
('Thailand', 'Southeastern Asia', 34, 6455),
('Saudi Arabia', 'Middle East and Northern Africa', 35, 6411),
('Spain', 'Western Europe', 36, 6329),
('Malta', 'Western Europe', 37, 6302),
('Taiwan', 'Eastern Asia', 38, 6298),
('Kuwait', 'Middle East and Northern Africa', 39, 6295),
('Suriname', 'Latin America and Caribbean', 40, 6269),
('Trinidad and Tobago', 'Latin America and Caribbean', 41, 6168),
('El Salvador', 'Latin America and Caribbean', 42, 613),
('Guatemala', 'Latin America and Caribbean', 43, 6123),
('Uzbekistan', 'Central and Eastern Europe', 44, 6003),
('Slovakia', 'Central and Eastern Europe', 45, 5995),
('Japan', 'Eastern Asia', 46, 5987),
('South Korea', 'Eastern Asia', 47, 5984),
('Ecuador', 'Latin America and Caribbean', 48, 5975),
('Bahrain', 'Middle East and Northern Africa', 49, 596),
('Italy', 'Western Europe', 50, 5948),
('Bolivia', 'Latin America and Caribbean', 51, 589),
('Moldova', 'Central and Eastern Europe', 52, 5889),
('Paraguay', 'Latin America and Caribbean', 53, 5878),
('Kazakhstan', 'Central and Eastern Europe', 54, 5855),
('Slovenia', 'Central and Eastern Europe', 55, 5848),
('Lithuania', 'Central and Eastern Europe', 56, 5833),
('Nicaragua', 'Latin America and Caribbean', 57, 5828),
('Peru', 'Latin America and Caribbean', 58, 5824),
('Belarus', 'Central and Eastern Europe', 59, 5813),
('Poland', 'Central and Eastern Europe', 60, 5791),
('Malaysia', 'Southeastern Asia', 61, 577),
('Croatia', 'Central and Eastern Europe', 62, 5759),
('Libya', 'Middle East and Northern Africa', 63, 5754),
('Russia', 'Central and Eastern Europe', 64, 5716),
('Jamaica', 'Latin America and Caribbean', 65, 5709),
('North Cyprus', 'Western Europe', 66, 5695),
('Cyprus', 'Western Europe', 67, 5689),
('Algeria', 'Middle East and Northern Africa', 68, 5605),
('Kosovo', 'Central and Eastern Europe', 69, 5589),
('Turkmenistan', 'Central and Eastern Europe', 70, 5548),
('Mauritius', 'Sub-Saharan Africa', 71, 5477),
('Hong Kong', 'Eastern Asia', 72, 5474),
('Estonia', 'Central and Eastern Europe', 73, 5429),
('Indonesia', 'Southeastern Asia', 74, 5399),
('Vietnam', 'Southeastern Asia', 75, 536),
('Turkey', 'Middle East and Northern Africa', 76, 5332),
('Kyrgyzstan', 'Central and Eastern Europe', 77, 5286),
('Nigeria', 'Sub-Saharan Africa', 78, 5268),
('Bhutan', 'Southern Asia', 79, 5253),
('Azerbaijan', 'Central and Eastern Europe', 80, 5212),
('Pakistan', 'Southern Asia', 81, 5194),
('Jordan', 'Middle East and Northern Africa', 82, 5192),
('Montenegro', 'Central and Eastern Europe', 82, 5192),
('China', 'Eastern Asia', 84, 514),
('Zambia', 'Sub-Saharan Africa', 85, 5129),
('Romania', 'Central and Eastern Europe', 86, 5124),
('Serbia', 'Central and Eastern Europe', 87, 5123),
('Portugal', 'Western Europe', 88, 5102),
('Latvia', 'Central and Eastern Europe', 89, 5098),
('Philippines', 'Southeastern Asia', 90, 5073),
('Somaliland region', 'Sub-Saharan Africa', 91, 5057),
('Morocco', 'Middle East and Northern Africa', 92, 5013),
('Macedonia', 'Central and Eastern Europe', 93, 5007),
('Mozambique', 'Sub-Saharan Africa', 94, 4971),
('Albania', 'Central and Eastern Europe', 95, 4959),
('Bosnia and Herzegovina', 'Central and Eastern Europe', 96, 4949),
('Lesotho', 'Sub-Saharan Africa', 97, 4898),
('Dominican Republic', 'Latin America and Caribbean', 98, 4885),
('Laos', 'Southeastern Asia', 99, 4876),
('Mongolia', 'Eastern Asia', 100, 4874),
('Swaziland', 'Sub-Saharan Africa', 101, 4867),
('Greece', 'Western Europe', 102, 4857),
('Lebanon', 'Middle East and Northern Africa', 103, 4839),
('Hungary', 'Central and Eastern Europe', 104, 48),
('Honduras', 'Latin America and Caribbean', 105, 4788),
('Tajikistan', 'Central and Eastern Europe', 106, 4786),
('Tunisia', 'Middle East and Northern Africa', 107, 4739),
('Palestinian Territories', 'Middle East and Northern Africa', 108, 4715),
('Bangladesh', 'Southern Asia', 109, 4694),
('Iran', 'Middle East and Northern Africa', 110, 4686),
('Ukraine', 'Central and Eastern Europe', 111, 4681),
('Iraq', 'Middle East and Northern Africa', 112, 4677),
('South Africa', 'Sub-Saharan Africa', 113, 4642),
('Ghana', 'Sub-Saharan Africa', 114, 4633),
('Zimbabwe', 'Sub-Saharan Africa', 115, 461),
('Liberia', 'Sub-Saharan Africa', 116, 4571),
('India', 'Southern Asia', 117, 4565),
('Sudan', 'Sub-Saharan Africa', 118, 455),
('Haiti', 'Latin America and Caribbean', 119, 4518),
('Congo (Kinshasa)', 'Sub-Saharan Africa', 120, 4517),
('Nepal', 'Southern Asia', 121, 4514),
('Ethiopia', 'Sub-Saharan Africa', 122, 4512),
('Sierra Leone', 'Sub-Saharan Africa', 123, 4507),
('Mauritania', 'Sub-Saharan Africa', 124, 4436),
('Kenya', 'Sub-Saharan Africa', 125, 4419),
('Djibouti', 'Sub-Saharan Africa', 126, 4369),
('Armenia', 'Central and Eastern Europe', 127, 435),
('Botswana', 'Sub-Saharan Africa', 128, 4332),
('Myanmar', 'Southeastern Asia', 129, 4307),
('Georgia', 'Central and Eastern Europe', 130, 4297),
('Malawi', 'Sub-Saharan Africa', 131, 4292),
('Sri Lanka', 'Southern Asia', 132, 4271),
('Cameroon', 'Sub-Saharan Africa', 133, 4252),
('Bulgaria', 'Central and Eastern Europe', 134, 4218),
('Egypt', 'Middle East and Northern Africa', 135, 4194),
('Yemen', 'Middle East and Northern Africa', 136, 4077),
('Angola', 'Sub-Saharan Africa', 137, 4033),
('Mali', 'Sub-Saharan Africa', 138, 3995),
('Congo (Brazzaville)', 'Sub-Saharan Africa', 139, 3989),
('Comoros', 'Sub-Saharan Africa', 140, 3956),
('Uganda', 'Sub-Saharan Africa', 141, 3931),
('Senegal', 'Sub-Saharan Africa', 142, 3904),
('Gabon', 'Sub-Saharan Africa', 143, 3896),
('Niger', 'Sub-Saharan Africa', 144, 3845),
('Cambodia', 'Southeastern Asia', 145, 3819),
('Tanzania', 'Sub-Saharan Africa', 146, 3781),
('Madagascar', 'Sub-Saharan Africa', 147, 3681),
('Central African Republic', 'Sub-Saharan Africa', 148, 3678),
('Chad', 'Sub-Saharan Africa', 149, 3667),
('Guinea', 'Sub-Saharan Africa', 150, 3656),
('Ivory Coast', 'Sub-Saharan Africa', 151, 3655),
('Burkina Faso', 'Sub-Saharan Africa', 152, 3587),
('Afghanistan', 'Southern Asia', 153, 3575),
('Rwanda', 'Sub-Saharan Africa', 154, 3465),
('Benin', 'Sub-Saharan Africa', 155, 334),
('Syria', 'Middle East and Northern Africa', 156, 3006),
('Burundi', 'Sub-Saharan Africa', 157, 2905),
('Togo', 'Sub-Saharan Africa', 158, 2839);

-- --------------------------------------------------------

--
-- Table structure for table `jaar2016`
--

CREATE TABLE `jaar2016` (
  `country` varchar(23) DEFAULT NULL,
  `region` varchar(31) DEFAULT NULL,
  `rank` int(3) DEFAULT NULL,
  `score` int(4) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `jaar2016`
--

INSERT INTO `jaar2016` (`country`, `region`, `rank`, `score`) VALUES
('Denmark', 'Western Europe', 1, 7526),
('Switzerland', 'Western Europe', 2, 7509),
('Iceland', 'Western Europe', 3, 7501),
('Norway', 'Western Europe', 4, 7498),
('Finland', 'Western Europe', 5, 7413),
('Canada', 'North America', 6, 7404),
('Netherlands', 'Western Europe', 7, 7339),
('New Zealand', 'Australia and New Zealand', 8, 7334),
('Australia', 'Australia and New Zealand', 9, 7313),
('Sweden', 'Western Europe', 10, 7291),
('Israel', 'Middle East and Northern Africa', 11, 7267),
('Austria', 'Western Europe', 12, 7119),
('United States', 'North America', 13, 7104),
('Costa Rica', 'Latin America and Caribbean', 14, 7087),
('Puerto Rico', 'Latin America and Caribbean', 15, 7039),
('Germany', 'Western Europe', 16, 6994),
('Brazil', 'Latin America and Caribbean', 17, 6952),
('Belgium', 'Western Europe', 18, 6929),
('Ireland', 'Western Europe', 19, 6907),
('Luxembourg', 'Western Europe', 20, 6871),
('Mexico', 'Latin America and Caribbean', 21, 6778),
('Singapore', 'Southeastern Asia', 22, 6739),
('United Kingdom', 'Western Europe', 23, 6725),
('Chile', 'Latin America and Caribbean', 24, 6705),
('Panama', 'Latin America and Caribbean', 25, 6701),
('Argentina', 'Latin America and Caribbean', 26, 665),
('Czech Republic', 'Central and Eastern Europe', 27, 6596),
('United Arab Emirates', 'Middle East and Northern Africa', 28, 6573),
('Uruguay', 'Latin America and Caribbean', 29, 6545),
('Malta', 'Western Europe', 30, 6488),
('Colombia', 'Latin America and Caribbean', 31, 6481),
('France', 'Western Europe', 32, 6478),
('Thailand', 'Southeastern Asia', 33, 6474),
('Saudi Arabia', 'Middle East and Northern Africa', 34, 6379),
('Taiwan', 'Eastern Asia', 34, 6379),
('Qatar', 'Middle East and Northern Africa', 36, 6375),
('Spain', 'Western Europe', 37, 6361),
('Algeria', 'Middle East and Northern Africa', 38, 6355),
('Guatemala', 'Latin America and Caribbean', 39, 6324),
('Suriname', 'Latin America and Caribbean', 40, 6269),
('Kuwait', 'Middle East and Northern Africa', 41, 6239),
('Bahrain', 'Middle East and Northern Africa', 42, 6218),
('Trinidad and Tobago', 'Latin America and Caribbean', 43, 6168),
('Venezuela', 'Latin America and Caribbean', 44, 6084),
('Slovakia', 'Central and Eastern Europe', 45, 6078),
('El Salvador', 'Latin America and Caribbean', 46, 6068),
('Malaysia', 'Southeastern Asia', 47, 6005),
('Nicaragua', 'Latin America and Caribbean', 48, 5992),
('Uzbekistan', 'Central and Eastern Europe', 49, 5987),
('Italy', 'Western Europe', 50, 5977),
('Ecuador', 'Latin America and Caribbean', 51, 5976),
('Belize', 'Latin America and Caribbean', 52, 5956),
('Japan', 'Eastern Asia', 53, 5921),
('Kazakhstan', 'Central and Eastern Europe', 54, 5919),
('Moldova', 'Central and Eastern Europe', 55, 5897),
('Russia', 'Central and Eastern Europe', 56, 5856),
('Poland', 'Central and Eastern Europe', 57, 5835),
('South Korea', 'Eastern Asia', 57, 5835),
('Bolivia', 'Latin America and Caribbean', 59, 5822),
('Lithuania', 'Central and Eastern Europe', 60, 5813),
('Belarus', 'Central and Eastern Europe', 61, 5802),
('North Cyprus', 'Western Europe', 62, 5771),
('Slovenia', 'Central and Eastern Europe', 63, 5768),
('Peru', 'Latin America and Caribbean', 64, 5743),
('Turkmenistan', 'Central and Eastern Europe', 65, 5658),
('Mauritius', 'Sub-Saharan Africa', 66, 5648),
('Libya', 'Middle East and Northern Africa', 67, 5615),
('Latvia', 'Central and Eastern Europe', 68, 556),
('Cyprus', 'Western Europe', 69, 5546),
('Paraguay', 'Latin America and Caribbean', 70, 5538),
('Romania', 'Central and Eastern Europe', 71, 5528),
('Estonia', 'Central and Eastern Europe', 72, 5517),
('Jamaica', 'Latin America and Caribbean', 73, 551),
('Croatia', 'Central and Eastern Europe', 74, 5488),
('Hong Kong', 'Eastern Asia', 75, 5458),
('Somalia', 'Sub-Saharan Africa', 76, 544),
('Kosovo', 'Central and Eastern Europe', 77, 5401),
('Turkey', 'Middle East and Northern Africa', 78, 5389),
('Indonesia', 'Southeastern Asia', 79, 5314),
('Jordan', 'Middle East and Northern Africa', 80, 5303),
('Azerbaijan', 'Central and Eastern Europe', 81, 5291),
('Philippines', 'Southeastern Asia', 82, 5279),
('China', 'Eastern Asia', 83, 5245),
('Bhutan', 'Southern Asia', 84, 5196),
('Kyrgyzstan', 'Central and Eastern Europe', 85, 5185),
('Serbia', 'Central and Eastern Europe', 86, 5177),
('Bosnia and Herzegovina', 'Central and Eastern Europe', 87, 5163),
('Montenegro', 'Central and Eastern Europe', 88, 5161),
('Dominican Republic', 'Latin America and Caribbean', 89, 5155),
('Morocco', 'Middle East and Northern Africa', 90, 5151),
('Hungary', 'Central and Eastern Europe', 91, 5145),
('Pakistan', 'Southern Asia', 92, 5132),
('Lebanon', 'Middle East and Northern Africa', 93, 5129),
('Portugal', 'Western Europe', 94, 5123),
('Macedonia', 'Central and Eastern Europe', 95, 5121),
('Vietnam', 'Southeastern Asia', 96, 5061),
('Somaliland Region', 'Sub-Saharan Africa', 97, 5057),
('Tunisia', 'Middle East and Northern Africa', 98, 5045),
('Greece', 'Western Europe', 99, 5033),
('Tajikistan', 'Central and Eastern Europe', 100, 4996),
('Mongolia', 'Eastern Asia', 101, 4907),
('Laos', 'Southeastern Asia', 102, 4876),
('Nigeria', 'Sub-Saharan Africa', 103, 4875),
('Honduras', 'Latin America and Caribbean', 104, 4871),
('Iran', 'Middle East and Northern Africa', 105, 4813),
('Zambia', 'Sub-Saharan Africa', 106, 4795),
('Nepal', 'Southern Asia', 107, 4793),
('Palestinian Territories', 'Middle East and Northern Africa', 108, 4754),
('Albania', 'Central and Eastern Europe', 109, 4655),
('Bangladesh', 'Southern Asia', 110, 4643),
('Sierra Leone', 'Sub-Saharan Africa', 111, 4635),
('Iraq', 'Middle East and Northern Africa', 112, 4575),
('Namibia', 'Sub-Saharan Africa', 113, 4574),
('Cameroon', 'Sub-Saharan Africa', 114, 4513),
('Ethiopia', 'Sub-Saharan Africa', 115, 4508),
('South Africa', 'Sub-Saharan Africa', 116, 4459),
('Sri Lanka', 'Southern Asia', 117, 4415),
('India', 'Southern Asia', 118, 4404),
('Myanmar', 'Southeastern Asia', 119, 4395),
('Egypt', 'Middle East and Northern Africa', 120, 4362),
('Armenia', 'Central and Eastern Europe', 121, 436),
('Kenya', 'Sub-Saharan Africa', 122, 4356),
('Ukraine', 'Central and Eastern Europe', 123, 4324),
('Ghana', 'Sub-Saharan Africa', 124, 4276),
('Congo (Kinshasa)', 'Sub-Saharan Africa', 125, 4272),
('Georgia', 'Central and Eastern Europe', 126, 4252),
('Congo (Brazzaville)', 'Sub-Saharan Africa', 127, 4236),
('Senegal', 'Sub-Saharan Africa', 128, 4219),
('Bulgaria', 'Central and Eastern Europe', 129, 4217),
('Mauritania', 'Sub-Saharan Africa', 130, 4201),
('Zimbabwe', 'Sub-Saharan Africa', 131, 4193),
('Malawi', 'Sub-Saharan Africa', 132, 4156),
('Sudan', 'Sub-Saharan Africa', 133, 4139),
('Gabon', 'Sub-Saharan Africa', 134, 4121),
('Mali', 'Sub-Saharan Africa', 135, 4073),
('Haiti', 'Latin America and Caribbean', 136, 4028),
('Botswana', 'Sub-Saharan Africa', 137, 3974),
('Comoros', 'Sub-Saharan Africa', 138, 3956),
('Ivory Coast', 'Sub-Saharan Africa', 139, 3916),
('Cambodia', 'Southeastern Asia', 140, 3907),
('Angola', 'Sub-Saharan Africa', 141, 3866),
('Niger', 'Sub-Saharan Africa', 142, 3856),
('South Sudan', 'Sub-Saharan Africa', 143, 3832),
('Chad', 'Sub-Saharan Africa', 144, 3763),
('Burkina Faso', 'Sub-Saharan Africa', 145, 3739),
('Uganda', 'Sub-Saharan Africa', 145, 3739),
('Yemen', 'Middle East and Northern Africa', 147, 3724),
('Madagascar', 'Sub-Saharan Africa', 148, 3695),
('Tanzania', 'Sub-Saharan Africa', 149, 3666),
('Liberia', 'Sub-Saharan Africa', 150, 3622),
('Guinea', 'Sub-Saharan Africa', 151, 3607),
('Rwanda', 'Sub-Saharan Africa', 152, 3515),
('Benin', 'Sub-Saharan Africa', 153, 3484),
('Afghanistan', 'Southern Asia', 154, 336),
('Togo', 'Sub-Saharan Africa', 155, 3303),
('Syria', 'Middle East and Northern Africa', 156, 3069),
('Burundi', 'Sub-Saharan Africa', 157, 2905);
COMMIT;

/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;