-- phpMyAdmin SQL Dump
-- version 3.1.1
-- http://www.phpmyadmin.net
--
-- Host: mysql.solcon.nl
-- Generation Time: Oct 12, 2009 at 01:54 PM
-- Server version: 5.1.30
-- PHP Version: 5.2.8

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";

--
-- Database: `romaniadurab_net`
--

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

--
-- Table structure for table `romaniadurab_net`
--

CREATE TABLE IF NOT EXISTS `romaniadurab_net` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `regionnumber` varchar(255) NOT NULL,
  `regionname` varchar(255) NOT NULL,
  `indicatornumber` varchar(255) NOT NULL,
  `indicatorname` varchar(255) NOT NULL,
  `indicatorvalue` varchar(255) NOT NULL,
  `average` varchar(255) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=177 ;

--
-- Dumping data for table `romaniadurab_net`
--

INSERT INTO `romaniadurab_net` (`id`, `regionnumber`, `regionname`, `indicatornumber`, `indicatorname`, `indicatorvalue`, `average`) VALUES
(1, '1', 'North East', '1', 'Life Expectancy', '8.7', '8.7'),
(2, '1', 'North East', '2', 'Poverty Rate', '2.0', '4.6'),
(3, '1', 'North East', '3', 'Sufficient to Drink', '5.5', '6.1'),
(4, '1', 'North East', '4', 'Safe Sanitation', '5.3', '6.3'),
(5, '1', 'North East', '5', 'Education Opportunities', '7.7', '7.6'),
(6, '1', 'North East', '6', 'Gender Equality', '-', '7.5'),
(7, '1', 'North East', '7', 'Air Quality', '9.8', '7.8'),
(8, '1', 'North East', '8', 'Surface Water Quality', '7.5', '7.0'),
(9, '1', 'North East', '9', 'Land Quality', '5.4', '5.7'),
(10, '1', 'North East', '10', 'Good Governance', '5.2', '5.2'),
(11, '1', 'North East', '11', 'Employment', '5.5', '4.9'),
(12, '1', 'North East', '12', 'Population Growth', '8.4', '8.9'),
(13, '1', 'North East', '13', 'Income Distribution', '7.4', '7.4'),
(14, '1', 'North East', '14', 'Public Debt ', '8.5', '8.5'),
(15, '1', 'North East', '15', 'Waste Recycling', '2.1', '2.1'),
(16, '1', 'North East', '16', 'Use of Renewable Water Resources', '9.6', '9.4'),
(17, '1', 'North East', '17', 'Consumption of Renewable Energy', '1.3', '1.3'),
(18, '1', 'North East', '18', 'Forest Area', '5.3', '6.1'),
(19, '1', 'North East', '19', 'Preservation of Biodiversity', '1.6', '5.1'),
(20, '1', 'North East', '20', 'Emission of Greenhouse Gases', '8.1', '5.9'),
(21, '1', 'North East', '21', 'Ecological Footprint', '5.2', '5.2'),
(22, '1', 'North East', '22', 'International Cooperation', '10.0', '10.0'),
(23, '2', 'South East', '1', 'Life Expectancy', '8.7', ''),
(24, '2', 'South East', '2', 'Poverty Rate', '3.4', ''),
(25, '2', 'South East', '3', 'Sufficient to Drink', '8.0', ''),
(26, '2', 'South East', '4', 'Safe Sanitation', '6.2', ''),
(27, '2', 'South East', '5', 'Education Opportunities', '7.0', ''),
(28, '2', 'South East', '6', 'Gender Equality', '7.3', ''),
(29, '2', 'South East', '7', 'Air Quality', '8.3', ''),
(30, '2', 'South East', '8', 'Surface Water Quality', '-', ''),
(31, '2', 'South East', '9', 'Land Quality', '6.2', ''),
(32, '2', 'South East', '10', 'Good Governance', '5.2', ''),
(33, '2', 'South East', '11', 'Employment', '4.1', ''),
(34, '2', 'South East', '12', 'Population Growth', '8.6', ''),
(35, '2', 'South East', '13', 'Income Distribution', '7.4', ''),
(36, '2', 'South East', '14', 'Public Debt ', '8.5', ''),
(37, '2', 'South East', '15', 'Waste Recycling', '2.1', ''),
(38, '2', 'South East', '16', 'Use of Renewable Water Resources', '8.4', ''),
(39, '2', 'South East', '17', 'Consumption of Renewable Energy', '1.3', ''),
(40, '2', 'South East', '18', 'Forest Area', '5.3', ''),
(41, '2', 'South East', '19', 'Preservation of Biodiversity', '10.0', ''),
(42, '2', 'South East', '20', 'Emission of Greenhouse Gases', '6.7', ''),
(43, '2', 'South East', '21', 'Ecological Footprint', '5.2', ''),
(44, '2', 'South East', '22', 'International Cooperation', '10.0', ''),
(45, '3', 'South', '1', 'Life Expectancy', '8.7', ''),
(46, '3', 'South', '2', 'Poverty Rate', '3.4', ''),
(47, '3', 'South', '3', 'Sufficient to Drink', '5.6', ''),
(48, '3', 'South', '4', 'Safe Sanitation', '4.6', ''),
(49, '3', 'South', '5', 'Education Opportunities', '6.7', ''),
(50, '3', 'South', '6', 'Gender Equality', '7.2', ''),
(51, '3', 'South', '7', 'Air Quality', '6.0', ''),
(52, '3', 'South', '8', 'Surface Water Quality', '6.8', ''),
(53, '3', 'South', '9', 'Land Quality', '6.2', ''),
(54, '3', 'South', '10', 'Good Governance', '5.2', ''),
(55, '3', 'South', '11', 'Employment', '3.9', ''),
(56, '3', 'South', '12', 'Population Growth', '8.9', ''),
(57, '3', 'South', '13', 'Income Distribution', '7.4', ''),
(58, '3', 'South', '14', 'Public Debt ', '8.5', ''),
(59, '3', 'South', '15', 'Waste Recycling', '2.1', ''),
(60, '3', 'South', '16', 'Use of Renewable Water Resources', '9.1', ''),
(61, '3', 'South', '17', 'Consumption of Renewable Energy', '1.3', ''),
(62, '3', 'South', '18', 'Forest Area', '4.6', ''),
(63, '3', 'South', '19', 'Preservation of Biodiversity', '2.0', ''),
(64, '3', 'South', '20', 'Emission of Greenhouse Gases', '6.6', ''),
(65, '3', 'South', '21', 'Ecological Footprint', '5.2', ''),
(66, '3', 'South', '22', 'International Cooperation', '10.0', ''),
(67, '4', 'South West', '1', 'Life Expectancy', '8.7', ''),
(68, '4', 'South West', '2', 'Poverty Rate', '2.4', ''),
(69, '4', 'South West', '3', 'Sufficient to Drink', '4.1', ''),
(70, '4', 'South West', '4', 'Safe Sanitation', '5.0', ''),
(71, '4', 'South West', '5', 'Education Opportunities', '7.5', ''),
(72, '4', 'South West', '6', 'Gender Equality', '7.5', ''),
(73, '4', 'South West', '7', 'Air Quality', '3.0', ''),
(74, '4', 'South West', '8', 'Surface Water Quality', '6.0', ''),
(75, '4', 'South West', '9', 'Land Quality', '6.1', ''),
(76, '4', 'South West', '10', 'Good Governance', '5.2', ''),
(77, '4', 'South West', '11', 'Employment', '4.9', ''),
(78, '4', 'South West', '12', 'Population Growth', '8.9', ''),
(79, '4', 'South West', '13', 'Income Distribution', '7.4', ''),
(80, '4', 'South West', '14', 'Public Debt ', '8.5', ''),
(81, '4', 'South West', '15', 'Waste Recycling', '2.1', ''),
(82, '4', 'South West', '16', 'Use of Renewable Water Resources', '9.5', ''),
(83, '4', 'South West', '17', 'Consumption of Renewable Energy', '1.3', ''),
(84, '4', 'South West', '18', 'Forest Area', '4.1', ''),
(85, '4', 'South West', '19', 'Preservation of Biodiversity', '4.8', ''),
(86, '4', 'South West', '20', 'Emission of Greenhouse Gases', '0.4', ''),
(87, '4', 'South West', '21', 'Ecological Footprint', '5.2', ''),
(88, '4', 'South West', '22', 'International Cooperation', '10.0', ''),
(89, '5', 'West', '1', 'Life Expectancy', '8.6', ''),
(90, '5', 'West', '2', 'Poverty Rate', '7.2', ''),
(91, '5', 'West', '3', 'Sufficient to Drink', '6.6', ''),
(92, '5', 'West', '4', 'Safe Sanitation', '7.0', ''),
(93, '5', 'West', '5', 'Education Opportunities', '7.9', ''),
(94, '5', 'West', '6', 'Gender Equality', '7.6', ''),
(95, '5', 'West', '7', 'Air Quality', '8.0', ''),
(96, '5', 'West', '8', 'Surface Water Quality', '8.1', ''),
(97, '5', 'West', '9', 'Land Quality', '5.4', ''),
(98, '5', 'West', '10', 'Good Governance', '5.2', ''),
(99, '5', 'West', '11', 'Employment ', '5.3', ''),
(100, '5', 'West', '12', 'Population Growth', '9.4', ''),
(101, '5', 'West', '13', 'Income Distribution', '7.4', ''),
(102, '5', 'West', '14', 'Public Debt', '8.5', ''),
(103, '5', 'West', '15', 'Waste Recycling', '2.1', ''),
(104, '5', 'West', '16', 'Use of Renewable Water Resources', '9.3', ''),
(105, '5', 'West', '17', 'Consumption of Renewable Energy', '1.3', ''),
(106, '5', 'West', '18', 'Forest Area', '7.6', ''),
(107, '5', 'West', '19', 'Preservation of Biodiversity', '0.7', ''),
(108, '5', 'West', '20', 'Emission of Greenhouse Gases', '3.5', ''),
(109, '5', 'West', '21', 'Ecological Footprint', '5.2', ''),
(110, '5', 'West', '22', 'International Cooperation', '10.0', ''),
(111, '6', 'North West', '1', 'Life Expectancy', '8.6', ''),
(112, '6', 'North West', '2', 'Poverty Rate', '5.8', ''),
(113, '6', 'North West', '3', 'Sufficient to Drink', '7.4', ''),
(114, '6', 'North West', '4', 'Safe Sanitation', '6.0', ''),
(115, '6', 'North West', '5', 'Education Opportunities', '7.8', ''),
(116, '6', 'North West', '6', 'Gender Equality', '7.5', ''),
(117, '6', 'North West', '7', 'Air Quality', '9.7', ''),
(118, '6', 'North West', '8', 'Surface Water Quality', '6.7', ''),
(119, '6', 'North West', '9', 'Land Quality', '4.7', ''),
(120, '6', 'North West', '10', 'Good Governance', '5.2', ''),
(121, '6', 'North West', '11', 'Employment ', '5.5', ''),
(122, '6', 'North West', '12', 'Population Growth', '8.9', ''),
(123, '6', 'North West', '13', 'Income Distribution', '7.4', ''),
(124, '6', 'North West', '14', 'Public Debt', '8.5', ''),
(125, '6', 'North West', '15', 'Waste Recycling', '2.1', ''),
(126, '6', 'North West', '16', 'Use of Renewable Water Resources', '9.9', ''),
(127, '6', 'North West', '17', 'Consumption of Renewable Energy', '1.3', ''),
(128, '6', 'North West', '18', 'Forest Area', '5.0', ''),
(129, '6', 'North West', '19', 'Preservation of Biodiversity', '3.6', ''),
(130, '6', 'North West', '20', 'Emission of Greenhouse Gases', '8.3', ''),
(131, '6', 'North West', '21', 'Ecological Footprint', '5.2', ''),
(132, '6', 'North West', '22', 'International Cooperation', '10.0', ''),
(133, '7', 'Centre', '1', 'Life Expectancy', '8.7', ''),
(134, '7', 'Centre', '2', 'Poverty Rate', '4.6', ''),
(135, '7', 'Centre', '3', 'Sufficient to Drink', '6.3', ''),
(136, '7', 'Centre', '4', 'Safe Sanitation', '6.7', ''),
(137, '7', 'Centre', '5', 'Education Opportunities', '7.6', ''),
(138, '7', 'Centre', '6', 'Gender Equality', '7.5', ''),
(139, '7', 'Centre', '7', 'Air Quality', '8.3', ''),
(140, '7', 'Centre', '8', 'Surface Water Quality', '8.4', ''),
(141, '7', 'Centre', '9', 'Land Quality', '4.5', ''),
(142, '7', 'Centre', '10', 'Good Governance', '5.2', ''),
(143, '7', 'Centre', '11', 'Employment ', '4.1', ''),
(144, '7', 'Centre', '12', 'Population Growth', '9.0', ''),
(145, '7', 'Centre', '13', 'Income Distribution', '7.4', ''),
(146, '7', 'Centre', '14', 'Public Debt', '8.5', ''),
(147, '7', 'Centre', '15', 'Waste Recycling', '2.1', ''),
(148, '7', 'Centre', '16', 'Use of Renewable Water Resources', '9.7', ''),
(149, '7', 'Centre', '17', 'Consumption of Renewable Energy', '1.3', ''),
(150, '7', 'Centre', '18', 'Forest Area', '10.0', ''),
(151, '7', 'Centre', '19', 'Preservation of Biodiversity', '1.1', ''),
(152, '7', 'Centre', '20', 'Emission of Greenhouse Gases', '5.8', ''),
(153, '7', 'Centre', '21', 'Ecological Footprint', '5.2', ''),
(154, '7', 'Centre', '22', 'International Cooperation', '10.0', ''),
(155, '8', 'Bucharest-Ilfov', '1', 'Life Expectancy', '9.0', ''),
(156, '8', 'Bucharest-Ilfov', '2', 'Poverty Rate', '8.2', ''),
(157, '8', 'Bucharest-Ilfov', '3', 'Sufficient to Drink', '4.9', ''),
(158, '8', 'Bucharest-Ilfov', '4', 'Safe Sanitation', '9.3', ''),
(159, '8', 'Bucharest-Ilfov', '5', 'Education Opportunities', '8.6', ''),
(160, '8', 'Bucharest-Ilfov', '6', 'Gender Equality', '8.1', ''),
(161, '8', 'Bucharest-Ilfov', '7', 'Air Quality', '9.4', ''),
(162, '8', 'Bucharest-Ilfov', '8', 'Surface Water Quality', '5.6', ''),
(163, '8', 'Bucharest-Ilfov', '9', 'Land Quality', '7.3', ''),
(164, '8', 'Bucharest-Ilfov', '10', 'Good Governance', '5.2', ''),
(165, '8', 'Bucharest-Ilfov', '11', 'Employment ', '6.2', ''),
(166, '8', 'Bucharest-Ilfov', '12', 'Population Growth', '8.7', ''),
(167, '8', 'Bucharest-Ilfov', '13', 'Income Distribution', '7.4', ''),
(168, '8', 'Bucharest-Ilfov', '14', 'Public Debt', '8.5', ''),
(169, '8', 'Bucharest-Ilfov', '15', 'Waste Recycling', '2.1', ''),
(170, '8', 'Bucharest-Ilfov', '16', 'Use of Renewable Water Resources', '-', ''),
(171, '8', 'Bucharest-Ilfov', '17', 'Consumption of Renewable Energy', '1.3', ''),
(172, '8', 'Bucharest-Ilfov', '18', 'Forest Area', '6.6', ''),
(173, '8', 'Bucharest-Ilfov', '19', 'Preservation of Biodiversity', '1.0', ''),
(174, '8', 'Bucharest-Ilfov', '20', 'Emission of Greenhouse Gases', '7.8', ''),
(175, '8', 'Bucharest-Ilfov', '21', 'Ecological Footprint', '5.2', ''),
(176, '8', 'Bucharest-Ilfov', '22', 'International Cooperation', '10.0', '');
