Skip to content

Instantly share code, notes, and snippets.

@kmoppel

kmoppel/oil.sql

Last active December 5, 2017 12:57
Show Gist options
  • Save kmoppel/8224a7839d92cc9b99b698288b946ae8 to your computer and use it in GitHub Desktop.
Save kmoppel/8224a7839d92cc9b99b698288b946ae8 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
oil.sql
-- COPY t_oil FROM PROGRAM 'curl https://www.cybertec-postgresql.com/secret/oil_ext.txt';
BEGIN;
CREATE TABLE t_oil (
region text,
country text,
year integer,
production integer,
consumption integer
);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('North America', 'USA', 1965, 9014, 11522);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('North America', 'USA', 1966, 9579, 12100);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('North America', 'USA', 1967, 10219, 12567);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('North America', 'USA', 1968, 10600, 13405);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('North America', 'USA', 1969, 10828, 14153);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('North America', 'USA', 1970, 11297, 14710);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('North America', 'USA', 1971, 11156, 15223);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('North America', 'USA', 1972, 11185, 16381);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('North America', 'USA', 1973, 10946, 17318);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('North America', 'USA', 1974, 10461, 16631);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('North America', 'USA', 1975, 10008, 16334);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('North America', 'USA', 1976, 9736, 17461);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('North America', 'USA', 1977, 9863, 18443);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('North America', 'USA', 1978, 10274, 18756);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('North America', 'USA', 1979, 10136, 18438);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('North America', 'USA', 1980, 10170, 17062);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('North America', 'USA', 1981, 10181, 16060);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('North America', 'USA', 1982, 10199, 15295);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('North America', 'USA', 1983, 10247, 15235);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('North America', 'USA', 1984, 10509, 15725);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('North America', 'USA', 1985, 10580, 15726);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('North America', 'USA', 1986, 10231, 16281);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('North America', 'USA', 1987, 9944, 16665);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('North America', 'USA', 1988, 9765, 17283);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('North America', 'USA', 1989, 9159, 17325);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('North America', 'USA', 1990, 8914, 16988);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('North America', 'USA', 1991, 9076, 16713);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('North America', 'USA', 1992, 8868, 17033);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('North America', 'USA', 1993, 8583, 17236);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('North America', 'USA', 1994, 8389, 17719);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('North America', 'USA', 1995, 8322, 17725);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('North America', 'USA', 1996, 8295, 18309);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('North America', 'USA', 1997, 8269, 18621);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('North America', 'USA', 1998, 8011, 18917);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('North America', 'USA', 1999, 7731, 19519);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('North America', 'USA', 2000, 7733, 19701);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('North America', 'USA', 2001, 7669, 19649);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('North America', 'USA', 2002, 7626, 19761);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('North America', 'USA', 2003, 7400, 20033);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('North America', 'USA', 2004, 7228, 20732);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('North America', 'USA', 2005, 6895, 20802);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('North America', 'USA', 2006, 6841, 20687);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('North America', 'USA', 2007, 6847, 20680);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('North America', 'USA', 2008, 6734, 19490);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('North America', 'USA', 2009, 7271, 18771);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('North America', 'USA', 2010, 7513, 19180);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('North America', 'Canada', 1965, 920, 1108);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('North America', 'Canada', 1966, 1012, 1167);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('North America', 'Canada', 1967, 1106, 1246);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('North America', 'Canada', 1968, 1194, 1322);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('North America', 'Canada', 1969, 1306, 1380);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('North America', 'Canada', 1970, 1473, 1472);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('North America', 'Canada', 1971, 1582, 1512);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('North America', 'Canada', 1972, 1829, 1589);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('North America', 'Canada', 1973, 2114, 1682);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('North America', 'Canada', 1974, 1993, 1713);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('North America', 'Canada', 1975, 1735, 1682);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('North America', 'Canada', 1976, 1598, 1789);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('North America', 'Canada', 1977, 1608, 1812);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('North America', 'Canada', 1978, 1597, 1849);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('North America', 'Canada', 1979, 1835, 1931);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('North America', 'Canada', 1980, 1764, 1898);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('North America', 'Canada', 1981, 1610, 1788);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('North America', 'Canada', 1982, 1590, 1609);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('North America', 'Canada', 1983, 1661, 1518);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('North America', 'Canada', 1984, 1775, 1540);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('North America', 'Canada', 1985, 1812, 1556);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('North America', 'Canada', 1986, 1805, 1559);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('North America', 'Canada', 1987, 1908, 1627);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('North America', 'Canada', 1988, 2002, 1710);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('North America', 'Canada', 1989, 1961, 1771);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('North America', 'Canada', 1990, 1967, 1747);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('North America', 'Canada', 1991, 1983, 1659);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('North America', 'Canada', 1992, 2065, 1689);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('North America', 'Canada', 1993, 2189, 1697);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('North America', 'Canada', 1994, 2281, 1726);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('North America', 'Canada', 1995, 2402, 1848);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('North America', 'Canada', 1996, 2479, 1889);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('North America', 'Canada', 1997, 2587, 1969);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('North America', 'Canada', 1998, 2672, 2002);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('North America', 'Canada', 1999, 2604, 2061);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('North America', 'Canada', 2000, 2703, 2043);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('North America', 'Canada', 2001, 2727, 2094);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('North America', 'Canada', 2002, 2858, 2172);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('North America', 'Canada', 2003, 3003, 2228);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('North America', 'Canada', 2004, 3079, 2309);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('North America', 'Canada', 2005, 3040, 2288);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('North America', 'Canada', 2006, 3208, 2295);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('North America', 'Canada', 2007, 3290, 2361);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('North America', 'Canada', 2008, 3207, 2315);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('North America', 'Canada', 2009, 3202, 2190);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('North America', 'Canada', 2010, 3332, 2316);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('North America', 'Mexico', 1965, 362, 296);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('North America', 'Mexico', 1966, 370, 309);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('North America', 'Mexico', 1967, 411, 331);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('North America', 'Mexico', 1968, 439, 361);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('North America', 'Mexico', 1969, 461, 383);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('North America', 'Mexico', 1970, 487, 412);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('North America', 'Mexico', 1971, 486, 434);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('North America', 'Mexico', 1972, 506, 481);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('North America', 'Mexico', 1973, 525, 515);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('North America', 'Mexico', 1974, 653, 589);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('North America', 'Mexico', 1975, 806, 663);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('North America', 'Mexico', 1976, 894, 730);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('North America', 'Mexico', 1977, 1085, 755);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('North America', 'Mexico', 1978, 1327, 874);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('North America', 'Mexico', 1979, 1607, 951);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('North America', 'Mexico', 1980, 2129, 1048);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('North America', 'Mexico', 1981, 2553, 1172);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('North America', 'Mexico', 1982, 3001, 1228);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('North America', 'Mexico', 1983, 2930, 1203);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('North America', 'Mexico', 1984, 2942, 1280);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('North America', 'Mexico', 1985, 2912, 1345);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('North America', 'Mexico', 1986, 2758, 1371);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('North America', 'Mexico', 1987, 2879, 1421);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('North America', 'Mexico', 1988, 2877, 1407);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('North America', 'Mexico', 1989, 2897, 1503);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('North America', 'Mexico', 1990, 2940, 1580);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('North America', 'Mexico', 1991, 3099, 1660);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('North America', 'Mexico', 1992, 3098, 1683);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('North America', 'Mexico', 1993, 3115, 1687);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('North America', 'Mexico', 1994, 3135, 1821);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('North America', 'Mexico', 1995, 3054, 1690);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('North America', 'Mexico', 1996, 3270, 1720);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('North America', 'Mexico', 1997, 3408, 1770);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('North America', 'Mexico', 1998, 3498, 1868);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('North America', 'Mexico', 1999, 3351, 1887);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('North America', 'Mexico', 2000, 3455, 1965);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('North America', 'Mexico', 2001, 3568, 1939);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('North America', 'Mexico', 2002, 3592, 1864);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('North America', 'Mexico', 2003, 3794, 1909);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('North America', 'Mexico', 2004, 3830, 1983);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('North America', 'Mexico', 2005, 3765, 2030);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('North America', 'Mexico', 2006, 3689, 2019);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('North America', 'Mexico', 2007, 3478, 2067);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('North America', 'Mexico', 2008, 3165, 2054);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('North America', 'Mexico', 2009, 2978, 1996);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('North America', 'Mexico', 2010, 2959, 2014);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('Middle East', 'Iran', 1965, 1908, 134);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('Middle East', 'Iran', 1966, 2132, 148);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('Middle East', 'Iran', 1967, 2603, 165);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('Middle East', 'Iran', 1968, 2840, 184);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('Middle East', 'Iran', 1969, 3376, 203);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('Middle East', 'Iran', 1970, 3848, 222);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('Middle East', 'Iran', 1971, 4572, 245);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('Middle East', 'Iran', 1972, 5059, 273);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('Middle East', 'Iran', 1973, 5907, 328);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('Middle East', 'Iran', 1974, 6060, 381);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('Middle East', 'Iran', 1975, 5387, 448);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('Middle East', 'Iran', 1976, 5918, 505);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('Middle East', 'Iran', 1977, 5714, 590);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('Middle East', 'Iran', 1978, 5302, 652);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('Middle East', 'Iran', 1979, 3218, 674);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('Middle East', 'Iran', 1980, 1479, 591);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('Middle East', 'Iran', 1981, 1321, 585);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('Middle East', 'Iran', 1982, 2397, 636);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('Middle East', 'Iran', 1983, 2454, 772);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('Middle East', 'Iran', 1984, 2043, 827);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('Middle East', 'Iran', 1985, 2205, 918);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('Middle East', 'Iran', 1986, 2054, 843);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('Middle East', 'Iran', 1987, 2342, 892);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('Middle East', 'Iran', 1988, 2349, 929);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('Middle East', 'Iran', 1989, 2894, 1032);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('Middle East', 'Iran', 1990, 3270, 1070);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('Middle East', 'Iran', 1991, 3500, 1147);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('Middle East', 'Iran', 1992, 3523, 1234);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('Middle East', 'Iran', 1993, 3712, 1288);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('Middle East', 'Iran', 1994, 3730, 1329);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('Middle East', 'Iran', 1995, 3744, 1314);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('Middle East', 'Iran', 1996, 3759, 1347);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('Middle East', 'Iran', 1997, 3776, 1415);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('Middle East', 'Iran', 1998, 3855, 1400);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('Middle East', 'Iran', 1999, 3603, 1413);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('Middle East', 'Iran', 2000, 3852, 1457);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('Middle East', 'Iran', 2001, 3825, 1486);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('Middle East', 'Iran', 2002, 3580, 1493);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('Middle East', 'Iran', 2003, 4002, 1509);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('Middle East', 'Iran', 2004, 4201, 1549);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('Middle East', 'Iran', 2005, 4184, 1700);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('Middle East', 'Iran', 2006, 4260, 1845);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('Middle East', 'Iran', 2007, 4303, 1875);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('Middle East', 'Iran', 2008, 4396, 1960);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('Middle East', 'Iran', 2009, 4249, 2012);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('Middle East', 'Iran', 2010, 4352, 1874);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('Middle East', 'Iraq', 1965, 1313, NULL);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('Middle East', 'Iraq', 1966, 1392, NULL);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('Middle East', 'Iraq', 1967, 1228, NULL);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('Middle East', 'Iraq', 1968, 1503, NULL);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('Middle East', 'Iraq', 1969, 1521, NULL);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('Middle East', 'Iraq', 1970, 1549, NULL);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('Middle East', 'Iraq', 1971, 1694, NULL);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('Middle East', 'Iraq', 1972, 1466, NULL);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('Middle East', 'Iraq', 1973, 2018, NULL);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('Middle East', 'Iraq', 1974, 1977, NULL);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('Middle East', 'Iraq', 1975, 2271, NULL);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('Middle East', 'Iraq', 1976, 2422, NULL);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('Middle East', 'Iraq', 1977, 2358, NULL);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('Middle East', 'Iraq', 1978, 2574, NULL);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('Middle East', 'Iraq', 1979, 3489, NULL);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('Middle East', 'Iraq', 1980, 2658, NULL);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('Middle East', 'Iraq', 1981, 907, NULL);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('Middle East', 'Iraq', 1982, 988, NULL);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('Middle East', 'Iraq', 1983, 1106, NULL);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('Middle East', 'Iraq', 1984, 1228, NULL);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('Middle East', 'Iraq', 1985, 1425, NULL);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('Middle East', 'Iraq', 1986, 1899, NULL);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('Middle East', 'Iraq', 1987, 2391, NULL);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('Middle East', 'Iraq', 1988, 2782, NULL);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('Middle East', 'Iraq', 1989, 2838, NULL);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('Middle East', 'Iraq', 1990, 2149, NULL);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('Middle East', 'Iraq', 1991, 285, NULL);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('Middle East', 'Iraq', 1992, 531, NULL);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('Middle East', 'Iraq', 1993, 455, NULL);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('Middle East', 'Iraq', 1994, 505, NULL);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('Middle East', 'Iraq', 1995, 530, NULL);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('Middle East', 'Iraq', 1996, 580, NULL);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('Middle East', 'Iraq', 1997, 1166, NULL);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('Middle East', 'Iraq', 1998, 2121, NULL);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('Middle East', 'Iraq', 1999, 2610, NULL);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('Middle East', 'Iraq', 2000, 2613, NULL);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('Middle East', 'Iraq', 2001, 2522, NULL);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('Middle East', 'Iraq', 2002, 2116, NULL);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('Middle East', 'Iraq', 2003, 1344, NULL);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('Middle East', 'Iraq', 2004, 2030, NULL);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('Middle East', 'Iraq', 2005, 1833, NULL);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('Middle East', 'Iraq', 2006, 1999, NULL);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('Middle East', 'Iraq', 2007, 2143, NULL);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('Middle East', 'Iraq', 2008, 2428, NULL);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('Middle East', 'Iraq', 2009, 2452, NULL);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('Middle East', 'Iraq', 2010, 2490, NULL);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('Middle East', 'Israel', 1965, NULL, 81);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('Middle East', 'Israel', 1966, NULL, 84);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('Middle East', 'Israel', 1967, NULL, 88);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('Middle East', 'Israel', 1968, NULL, 92);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('Middle East', 'Israel', 1969, NULL, 96);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('Middle East', 'Israel', 1970, NULL, 100);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('Middle East', 'Israel', 1971, NULL, 104);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('Middle East', 'Israel', 1972, NULL, 108);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('Middle East', 'Israel', 1973, NULL, 116);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('Middle East', 'Israel', 1974, NULL, 118);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('Middle East', 'Israel', 1975, NULL, 122);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('Middle East', 'Israel', 1976, NULL, 129);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('Middle East', 'Israel', 1977, NULL, 136);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('Middle East', 'Israel', 1978, NULL, 145);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('Middle East', 'Israel', 1979, NULL, 160);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('Middle East', 'Israel', 1980, NULL, 157);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('Middle East', 'Israel', 1981, NULL, 160);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('Middle East', 'Israel', 1982, NULL, 155);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('Middle East', 'Israel', 1983, NULL, 147);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('Middle East', 'Israel', 1984, NULL, 138);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('Middle East', 'Israel', 1985, NULL, 132);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('Middle East', 'Israel', 1986, NULL, 137);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('Middle East', 'Israel', 1987, NULL, 153);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('Middle East', 'Israel', 1988, NULL, 168);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('Middle East', 'Israel', 1989, NULL, 172);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('Middle East', 'Israel', 1990, NULL, 177);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('Middle East', 'Israel', 1991, NULL, 182);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('Middle East', 'Israel', 1992, NULL, 193);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('Middle East', 'Israel', 1993, NULL, 198);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('Middle East', 'Israel', 1994, NULL, 220);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('Middle East', 'Israel', 1995, NULL, 248);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('Middle East', 'Israel', 1996, NULL, 248);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('Middle East', 'Israel', 1997, NULL, 245);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('Middle East', 'Israel', 1998, NULL, 261);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('Middle East', 'Israel', 1999, NULL, 278);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('Middle East', 'Israel', 2000, NULL, 279);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('Middle East', 'Israel', 2001, NULL, 260);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('Middle East', 'Israel', 2002, NULL, 260);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('Middle East', 'Israel', 2003, NULL, 265);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('Middle East', 'Israel', 2004, NULL, 250);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('Middle East', 'Israel', 2005, NULL, 256);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('Middle East', 'Israel', 2006, NULL, 249);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('Middle East', 'Israel', 2007, NULL, 257);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('Middle East', 'Israel', 2008, NULL, 252);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('Middle East', 'Israel', 2009, NULL, 237);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('Middle East', 'Israel', 2010, NULL, 234);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('Middle East', 'Kuwait', 1965, 2371, 104);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('Middle East', 'Kuwait', 1966, 2505, 101);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('Middle East', 'Kuwait', 1967, 2522, 98);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('Middle East', 'Kuwait', 1968, 2656, 94);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('Middle East', 'Kuwait', 1969, 2819, 92);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('Middle East', 'Kuwait', 1970, 3036, 89);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('Middle East', 'Kuwait', 1971, 3253, 88);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('Middle East', 'Kuwait', 1972, 3339, 95);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('Middle East', 'Kuwait', 1973, 3080, 90);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('Middle East', 'Kuwait', 1974, 2603, 82);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('Middle East', 'Kuwait', 1975, 2132, 63);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('Middle East', 'Kuwait', 1976, 2199, 75);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('Middle East', 'Kuwait', 1977, 2024, 73);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('Middle East', 'Kuwait', 1978, 2182, 78);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('Middle East', 'Kuwait', 1979, 2623, 88);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('Middle East', 'Kuwait', 1980, 1757, 86);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('Middle East', 'Kuwait', 1981, 1187, 114);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('Middle East', 'Kuwait', 1982, 862, 130);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('Middle East', 'Kuwait', 1983, 1117, 145);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('Middle East', 'Kuwait', 1984, 1229, 160);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('Middle East', 'Kuwait', 1985, 1127, 162);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('Middle East', 'Kuwait', 1986, 1210, 168);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('Middle East', 'Kuwait', 1987, 1072, 166);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('Middle East', 'Kuwait', 1988, 1286, 162);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('Middle East', 'Kuwait', 1989, 1408, 161);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('Middle East', 'Kuwait', 1990, 964, 106);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('Middle East', 'Kuwait', 1991, 185, 75);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('Middle East', 'Kuwait', 1992, 1077, 112);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('Middle East', 'Kuwait', 1993, 1945, 104);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('Middle East', 'Kuwait', 1994, 2085, 137);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('Middle East', 'Kuwait', 1995, 2130, 142);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('Middle East', 'Kuwait', 1996, 2129, 139);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('Middle East', 'Kuwait', 1997, 2137, 155);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('Middle East', 'Kuwait', 1998, 2232, 230);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('Middle East', 'Kuwait', 1999, 2085, 256);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('Middle East', 'Kuwait', 2000, 2244, 257);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('Middle East', 'Kuwait', 2001, 2186, 265);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('Middle East', 'Kuwait', 2002, 2032, 285);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('Middle East', 'Kuwait', 2003, 2370, 334);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('Middle East', 'Kuwait', 2004, 2523, 374);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('Middle East', 'Kuwait', 2005, 2668, 411);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('Middle East', 'Kuwait', 2006, 2737, 378);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('Middle East', 'Kuwait', 2007, 2663, 383);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('Middle East', 'Kuwait', 2008, 2786, 406);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('Middle East', 'Kuwait', 2009, 2511, 455);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('Middle East', 'Kuwait', 2010, 2562, 486);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('Middle East', 'Oman', 1965, NULL, NULL);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('Middle East', 'Oman', 1966, NULL, NULL);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('Middle East', 'Oman', 1967, 57, NULL);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('Middle East', 'Oman', 1968, 241, NULL);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('Middle East', 'Oman', 1969, 327, NULL);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('Middle East', 'Oman', 1970, 332, NULL);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('Middle East', 'Oman', 1971, 294, NULL);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('Middle East', 'Oman', 1972, 282, NULL);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('Middle East', 'Oman', 1973, 293, NULL);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('Middle East', 'Oman', 1974, 290, NULL);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('Middle East', 'Oman', 1975, 341, NULL);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('Middle East', 'Oman', 1976, 367, NULL);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('Middle East', 'Oman', 1977, 340, NULL);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('Middle East', 'Oman', 1978, 314, NULL);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('Middle East', 'Oman', 1979, 295, NULL);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('Middle East', 'Oman', 1980, 285, NULL);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('Middle East', 'Oman', 1981, 330, NULL);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('Middle East', 'Oman', 1982, 338, NULL);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('Middle East', 'Oman', 1983, 391, NULL);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('Middle East', 'Oman', 1984, 419, NULL);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('Middle East', 'Oman', 1985, 502, NULL);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('Middle East', 'Oman', 1986, 564, NULL);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('Middle East', 'Oman', 1987, 588, NULL);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('Middle East', 'Oman', 1988, 625, NULL);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('Middle East', 'Oman', 1989, 651, NULL);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('Middle East', 'Oman', 1990, 695, NULL);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('Middle East', 'Oman', 1991, 716, NULL);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('Middle East', 'Oman', 1992, 748, NULL);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('Middle East', 'Oman', 1993, 785, NULL);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('Middle East', 'Oman', 1994, 819, NULL);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('Middle East', 'Oman', 1995, 868, NULL);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('Middle East', 'Oman', 1996, 897, NULL);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('Middle East', 'Oman', 1997, 909, NULL);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('Middle East', 'Oman', 1998, 905, NULL);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('Middle East', 'Oman', 1999, 911, NULL);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('Middle East', 'Oman', 2000, 961, NULL);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('Middle East', 'Oman', 2001, 959, NULL);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('Middle East', 'Oman', 2002, 900, NULL);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('Middle East', 'Oman', 2003, 822, NULL);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('Middle East', 'Oman', 2004, 783, NULL);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('Middle East', 'Oman', 2005, 777, NULL);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('Middle East', 'Oman', 2006, 738, NULL);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('Middle East', 'Oman', 2007, 710, NULL);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('Middle East', 'Oman', 2008, 757, NULL);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('Middle East', 'Oman', 2009, 813, NULL);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('Middle East', 'Oman', 2010, 865, NULL);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('Middle East', 'Qatar', 1965, 233, 1);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('Middle East', 'Qatar', 1966, 291, 1);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('Middle East', 'Qatar', 1967, 324, 2);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('Middle East', 'Qatar', 1968, 340, 2);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('Middle East', 'Qatar', 1969, 356, 2);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('Middle East', 'Qatar', 1970, 363, 2);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('Middle East', 'Qatar', 1971, 430, 2);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('Middle East', 'Qatar', 1972, 482, 2);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('Middle East', 'Qatar', 1973, 570, 3);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('Middle East', 'Qatar', 1974, 518, 4);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('Middle East', 'Qatar', 1975, 437, 5);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('Middle East', 'Qatar', 1976, 487, 7);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('Middle East', 'Qatar', 1977, 435, 9);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('Middle East', 'Qatar', 1978, 484, 9);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('Middle East', 'Qatar', 1979, 506, 9);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('Middle East', 'Qatar', 1980, 476, 17);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('Middle East', 'Qatar', 1981, 421, 19);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('Middle East', 'Qatar', 1982, 345, 27);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('Middle East', 'Qatar', 1983, 316, 30);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('Middle East', 'Qatar', 1984, 353, 33);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('Middle East', 'Qatar', 1985, 315, 44);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('Middle East', 'Qatar', 1986, 355, 50);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('Middle East', 'Qatar', 1987, 315, 53);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('Middle East', 'Qatar', 1988, 360, 38);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('Middle East', 'Qatar', 1989, 403, 42);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('Middle East', 'Qatar', 1990, 434, 43);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('Middle East', 'Qatar', 1991, 420, 39);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('Middle East', 'Qatar', 1992, 495, 40);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('Middle East', 'Qatar', 1993, 460, 41);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('Middle East', 'Qatar', 1994, 451, 44);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('Middle East', 'Qatar', 1995, 461, 46);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('Middle East', 'Qatar', 1996, 568, 48);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('Middle East', 'Qatar', 1997, 692, 51);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('Middle East', 'Qatar', 1998, 701, 52);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('Middle East', 'Qatar', 1999, 723, 51);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('Middle East', 'Qatar', 2000, 853, 60);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('Middle East', 'Qatar', 2001, 858, 73);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('Middle East', 'Qatar', 2002, 803, 84);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('Middle East', 'Qatar', 2003, 949, 95);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('Middle East', 'Qatar', 2004, 1082, 106);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('Middle East', 'Qatar', 2005, 1149, 120);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('Middle East', 'Qatar', 2006, 1241, 135);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('Middle East', 'Qatar', 2007, 1279, 153);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('Middle East', 'Qatar', 2008, 1449, 173);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('Middle East', 'Qatar', 2009, 1416, 172);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('Middle East', 'Qatar', 2010, 1655, 193);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('Middle East', 'Saudi Arabien', 1965, 2219, 391);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('Middle East', 'Saudi Arabien', 1966, 2615, 394);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('Middle East', 'Saudi Arabien', 1967, 2825, 397);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('Middle East', 'Saudi Arabien', 1968, 3081, 400);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('Middle East', 'Saudi Arabien', 1969, 3262, 404);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('Middle East', 'Saudi Arabien', 1970, 3851, 408);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('Middle East', 'Saudi Arabien', 1971, 4821, 411);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('Middle East', 'Saudi Arabien', 1972, 6070, 438);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('Middle East', 'Saudi Arabien', 1973, 7693, 466);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('Middle East', 'Saudi Arabien', 1974, 8618, 488);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('Middle East', 'Saudi Arabien', 1975, 7216, 366);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('Middle East', 'Saudi Arabien', 1976, 8762, 428);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('Middle East', 'Saudi Arabien', 1977, 9419, 500);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('Middle East', 'Saudi Arabien', 1978, 8554, 537);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('Middle East', 'Saudi Arabien', 1979, 9841, 653);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('Middle East', 'Saudi Arabien', 1980, 10270, 607);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('Middle East', 'Saudi Arabien', 1981, 10256, 727);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('Middle East', 'Saudi Arabien', 1982, 6961, 805);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('Middle East', 'Saudi Arabien', 1983, 4951, 878);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('Middle East', 'Saudi Arabien', 1984, 4534, 929);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('Middle East', 'Saudi Arabien', 1985, 3601, 955);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('Middle East', 'Saudi Arabien', 1986, 5208, 949);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('Middle East', 'Saudi Arabien', 1987, 4599, 990);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('Middle East', 'Saudi Arabien', 1988, 5720, 987);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('Middle East', 'Saudi Arabien', 1989, 5635, 979);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('Middle East', 'Saudi Arabien', 1990, 7105, 1158);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('Middle East', 'Saudi Arabien', 1991, 8820, 1235);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('Middle East', 'Saudi Arabien', 1992, 9098, 1189);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('Middle East', 'Saudi Arabien', 1993, 8962, 1225);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('Middle East', 'Saudi Arabien', 1994, 9084, 1359);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('Middle East', 'Saudi Arabien', 1995, 9145, 1299);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('Middle East', 'Saudi Arabien', 1996, 9299, 1370);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('Middle East', 'Saudi Arabien', 1997, 9482, 1423);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('Middle East', 'Saudi Arabien', 1998, 9502, 1532);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('Middle East', 'Saudi Arabien', 1999, 8853, 1542);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('Middle East', 'Saudi Arabien', 2000, 9491, 1578);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('Middle East', 'Saudi Arabien', 2001, 9209, 1622);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('Middle East', 'Saudi Arabien', 2002, 8928, 1668);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('Middle East', 'Saudi Arabien', 2003, 10164, 1780);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('Middle East', 'Saudi Arabien', 2004, 10638, 1913);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('Middle East', 'Saudi Arabien', 2005, 11114, 2013);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('Middle East', 'Saudi Arabien', 2006, 10853, 2084);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('Middle East', 'Saudi Arabien', 2007, 10449, 2203);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('Middle East', 'Saudi Arabien', 2008, 10846, 2378);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('Middle East', 'Saudi Arabien', 2009, 9893, 2593);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('Middle East', 'Saudi Arabien', 2010, 10007, 2793);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('Middle East', 'Syria', 1965, NULL, NULL);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('Middle East', 'Syria', 1966, NULL, NULL);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('Middle East', 'Syria', 1967, NULL, NULL);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('Middle East', 'Syria', 1968, 21, NULL);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('Middle East', 'Syria', 1969, 53, NULL);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('Middle East', 'Syria', 1970, 85, NULL);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('Middle East', 'Syria', 1971, 106, NULL);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('Middle East', 'Syria', 1972, 117, NULL);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('Middle East', 'Syria', 1973, 111, NULL);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('Middle East', 'Syria', 1974, 129, NULL);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('Middle East', 'Syria', 1975, 192, NULL);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('Middle East', 'Syria', 1976, 201, NULL);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('Middle East', 'Syria', 1977, 183, NULL);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('Middle East', 'Syria', 1978, 179, NULL);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('Middle East', 'Syria', 1979, 167, NULL);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('Middle East', 'Syria', 1980, 158, NULL);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('Middle East', 'Syria', 1981, 164, NULL);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('Middle East', 'Syria', 1982, 155, NULL);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('Middle East', 'Syria', 1983, 161, NULL);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('Middle East', 'Syria', 1984, 162, NULL);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('Middle East', 'Syria', 1985, 159, NULL);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('Middle East', 'Syria', 1986, 201, NULL);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('Middle East', 'Syria', 1987, 231, NULL);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('Middle East', 'Syria', 1988, 268, NULL);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('Middle East', 'Syria', 1989, 341, NULL);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('Middle East', 'Syria', 1990, 407, NULL);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('Middle East', 'Syria', 1991, 472, NULL);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('Middle East', 'Syria', 1992, 514, NULL);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('Middle East', 'Syria', 1993, 566, NULL);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('Middle East', 'Syria', 1994, 563, NULL);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('Middle East', 'Syria', 1995, 596, NULL);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('Middle East', 'Syria', 1996, 586, NULL);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('Middle East', 'Syria', 1997, 577, NULL);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('Middle East', 'Syria', 1998, 576, NULL);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('Middle East', 'Syria', 1999, 579, NULL);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('Middle East', 'Syria', 2000, 573, NULL);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('Middle East', 'Syria', 2001, 613, NULL);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('Middle East', 'Syria', 2002, 677, NULL);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('Middle East', 'Syria', 2003, 652, NULL);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('Middle East', 'Syria', 2004, 487, NULL);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('Middle East', 'Syria', 2005, 448, NULL);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('Middle East', 'Syria', 2006, 421, NULL);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('Middle East', 'Syria', 2007, 404, NULL);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('Middle East', 'Syria', 2008, 406, NULL);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('Middle East', 'Syria', 2009, 401, NULL);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('Middle East', 'Syria', 2010, 385, NULL);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('Middle East', 'United Arab Emirates', 1965, 282, NULL);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('Middle East', 'United Arab Emirates', 1966, 360, NULL);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('Middle East', 'United Arab Emirates', 1967, 382, NULL);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('Middle East', 'United Arab Emirates', 1968, 498, 1);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('Middle East', 'United Arab Emirates', 1969, 599, 1);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('Middle East', 'United Arab Emirates', 1970, 762, 3);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('Middle East', 'United Arab Emirates', 1971, 1106, 3);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('Middle East', 'United Arab Emirates', 1972, 1300, 4);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('Middle East', 'United Arab Emirates', 1973, 1456, 6);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('Middle East', 'United Arab Emirates', 1974, 1631, 8);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('Middle East', 'United Arab Emirates', 1975, 1696, 13);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('Middle East', 'United Arab Emirates', 1976, 1937, 19);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('Middle East', 'United Arab Emirates', 1977, 1998, 28);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('Middle East', 'United Arab Emirates', 1978, 1829, 31);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('Middle East', 'United Arab Emirates', 1979, 1831, 42);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('Middle East', 'United Arab Emirates', 1980, 1745, 99);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('Middle East', 'United Arab Emirates', 1981, 1540, 110);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('Middle East', 'United Arab Emirates', 1982, 1375, 122);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('Middle East', 'United Arab Emirates', 1983, 1296, 123);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('Middle East', 'United Arab Emirates', 1984, 1283, 140);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('Middle East', 'United Arab Emirates', 1985, 1260, 172);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('Middle East', 'United Arab Emirates', 1986, 1594, 207);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('Middle East', 'United Arab Emirates', 1987, 1603, 227);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('Middle East', 'United Arab Emirates', 1988, 1620, 271);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('Middle East', 'United Arab Emirates', 1989, 2024, 285);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('Middle East', 'United Arab Emirates', 1990, 2283, 300);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('Middle East', 'United Arab Emirates', 1991, 2639, 365);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('Middle East', 'United Arab Emirates', 1992, 2510, 367);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('Middle East', 'United Arab Emirates', 1993, 2443, 382);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('Middle East', 'United Arab Emirates', 1994, 2482, 399);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('Middle East', 'United Arab Emirates', 1995, 2401, 400);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('Middle East', 'United Arab Emirates', 1996, 2519, 385);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('Middle East', 'United Arab Emirates', 1997, 2620, 393);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('Middle East', 'United Arab Emirates', 1998, 2687, 391);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('Middle East', 'United Arab Emirates', 1999, 2583, 383);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('Middle East', 'United Arab Emirates', 2000, 2660, 380);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('Middle East', 'United Arab Emirates', 2001, 2561, 381);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('Middle East', 'United Arab Emirates', 2002, 2439, 412);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('Middle East', 'United Arab Emirates', 2003, 2722, 453);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('Middle East', 'United Arab Emirates', 2004, 2836, 484);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('Middle East', 'United Arab Emirates', 2005, 2922, 504);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('Middle East', 'United Arab Emirates', 2006, 3099, 540);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('Middle East', 'United Arab Emirates', 2007, 3001, 580);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('Middle East', 'United Arab Emirates', 2008, 3026, 602);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('Middle East', 'United Arab Emirates', 2009, 2723, 593);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('Middle East', 'United Arab Emirates', 2010, 2895, 645);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('Middle East', 'Yemen', 1965, NULL, NULL);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('Middle East', 'Yemen', 1966, NULL, NULL);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('Middle East', 'Yemen', 1967, NULL, NULL);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('Middle East', 'Yemen', 1968, NULL, NULL);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('Middle East', 'Yemen', 1969, NULL, NULL);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('Middle East', 'Yemen', 1970, NULL, NULL);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('Middle East', 'Yemen', 1971, NULL, NULL);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('Middle East', 'Yemen', 1972, NULL, NULL);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('Middle East', 'Yemen', 1973, NULL, NULL);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('Middle East', 'Yemen', 1974, NULL, NULL);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('Middle East', 'Yemen', 1975, NULL, NULL);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('Middle East', 'Yemen', 1976, NULL, NULL);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('Middle East', 'Yemen', 1977, NULL, NULL);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('Middle East', 'Yemen', 1978, NULL, NULL);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('Middle East', 'Yemen', 1979, NULL, NULL);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('Middle East', 'Yemen', 1980, NULL, NULL);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('Middle East', 'Yemen', 1981, NULL, NULL);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('Middle East', 'Yemen', 1982, NULL, NULL);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('Middle East', 'Yemen', 1983, NULL, NULL);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('Middle East', 'Yemen', 1984, NULL, NULL);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('Middle East', 'Yemen', 1985, NULL, NULL);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('Middle East', 'Yemen', 1986, 10, NULL);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('Middle East', 'Yemen', 1987, 26, NULL);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('Middle East', 'Yemen', 1988, 170, NULL);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('Middle East', 'Yemen', 1989, 178, NULL);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('Middle East', 'Yemen', 1990, 182, NULL);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('Middle East', 'Yemen', 1991, 197, NULL);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('Middle East', 'Yemen', 1992, 184, NULL);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('Middle East', 'Yemen', 1993, 209, NULL);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('Middle East', 'Yemen', 1994, 346, NULL);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('Middle East', 'Yemen', 1995, 351, NULL);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('Middle East', 'Yemen', 1996, 357, NULL);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('Middle East', 'Yemen', 1997, 375, NULL);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('Middle East', 'Yemen', 1998, 380, NULL);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('Middle East', 'Yemen', 1999, 405, NULL);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('Middle East', 'Yemen', 2000, 450, NULL);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('Middle East', 'Yemen', 2001, 453, NULL);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('Middle East', 'Yemen', 2002, 457, NULL);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('Middle East', 'Yemen', 2003, 451, NULL);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('Middle East', 'Yemen', 2004, 424, NULL);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('Middle East', 'Yemen', 2005, 421, NULL);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('Middle East', 'Yemen', 2006, 387, NULL);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('Middle East', 'Yemen', 2007, 341, NULL);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('Middle East', 'Yemen', 2008, 315, NULL);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('Middle East', 'Yemen', 2009, 307, NULL);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('Middle East', 'Yemen', 2010, 306, NULL);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('Middle East', 'Other Middle East', 1965, 61, 176);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('Middle East', 'Other Middle East', 1966, 66, 185);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('Middle East', 'Other Middle East', 1967, 73, 195);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('Middle East', 'Other Middle East', 1968, 78, 204);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('Middle East', 'Other Middle East', 1969, 78, 216);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('Middle East', 'Other Middle East', 1970, 79, 227);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('Middle East', 'Other Middle East', 1971, 76, 251);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('Middle East', 'Other Middle East', 1972, 71, 270);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('Middle East', 'Other Middle East', 1973, 69, 279);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('Middle East', 'Other Middle East', 1974, 68, 282);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('Middle East', 'Other Middle East', 1975, 62, 291);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('Middle East', 'Other Middle East', 1976, 59, 319);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('Middle East', 'Other Middle East', 1977, 59, 342);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('Middle East', 'Other Middle East', 1978, 55, 374);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('Middle East', 'Other Middle East', 1979, 51, 436);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('Middle East', 'Other Middle East', 1980, 55, 456);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('Middle East', 'Other Middle East', 1981, 54, 522);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('Middle East', 'Other Middle East', 1982, 52, 541);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('Middle East', 'Other Middle East', 1983, 50, 542);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('Middle East', 'Other Middle East', 1984, 50, 596);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('Middle East', 'Other Middle East', 1985, 50, 633);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('Middle East', 'Other Middle East', 1986, 51, 660);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('Middle East', 'Other Middle East', 1987, 52, 662);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('Middle East', 'Other Middle East', 1988, 53, 708);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('Middle East', 'Other Middle East', 1989, 53, 738);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('Middle East', 'Other Middle East', 1990, 52, 803);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('Middle East', 'Other Middle East', 1991, 53, 775);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('Middle East', 'Other Middle East', 1992, 54, 841);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('Middle East', 'Other Middle East', 1993, 53, 916);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('Middle East', 'Other Middle East', 1994, 52, 950);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('Middle East', 'Other Middle East', 1995, 52, 995);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('Middle East', 'Other Middle East', 1996, 50, 998);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('Middle East', 'Other Middle East', 1997, 50, 1033);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('Middle East', 'Other Middle East', 1998, 49, 1044);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('Middle East', 'Other Middle East', 1999, 48, 1107);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('Middle East', 'Other Middle East', 2000, 48, 1112);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('Middle East', 'Other Middle East', 2001, 47, 1162);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('Middle East', 'Other Middle East', 2002, 48, 1215);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('Middle East', 'Other Middle East', 2003, 48, 1233);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('Middle East', 'Other Middle East', 2004, 48, 1265);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('Middle East', 'Other Middle East', 2005, 185, 1343);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('Middle East', 'Other Middle East', 2006, 182, 1238);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('Middle East', 'Other Middle East', 2007, 194, 1314);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('Middle East', 'Other Middle East', 2008, 192, 1442);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('Middle East', 'Other Middle East', 2009, 192, 1467);
INSERT INTO t_oil (region, country, year, production, consumption) VALUES ('Middle East', 'Other Middle East', 2010, 192, 1540);
COMMIT;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment