USE [Build_file]
GO

/****** Object:  Table [dbo].[tbcoPSGCProvinces]    Script Date: 10/12/2009 00:26:20 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE [dbo].[tbcoPSGCProvinces](
	[RCODE] [nvarchar](255) NULL,
	[PCODE] [nvarchar](255) NULL,
	[PROV] [nvarchar](255) NULL,
	[TPOP] [float] NULL,
	[HPOP] [float] NULL,
	[NOHH] [float] NULL
) ON [PRIMARY]

GO





INSERT INTO [tbcopsgcprovinces] ([RCODE],[PCODE],[PROV],[TPOP],[HPOP],[NOHH])VALUES('02','09','Batanes',1.646700000000000e+004,1.642100000000000e+004,3.489000000000000e+003)
INSERT INTO [tbcopsgcprovinces] ([RCODE],[PCODE],[PROV],[TPOP],[HPOP],[NOHH])VALUES('02','15','Cagayan',9.935800000000000e+005,9.920510000000000e+005,1.906040000000000e+005)
INSERT INTO [tbcopsgcprovinces] ([RCODE],[PCODE],[PROV],[TPOP],[HPOP],[NOHH])VALUES('02','31','Isabela',1.287575000000000e+006,1.286413000000000e+006,2.549280000000000e+005)
INSERT INTO [tbcopsgcprovinces] ([RCODE],[PCODE],[PROV],[TPOP],[HPOP],[NOHH])VALUES('02','50','Nueva Vizcaya',3.669620000000000e+005,3.660040000000000e+005,7.440200000000000e+004)
INSERT INTO [tbcopsgcprovinces] ([RCODE],[PCODE],[PROV],[TPOP],[HPOP],[NOHH])VALUES('02','57','Quirino',1.485750000000000e+005,1.485150000000000e+005,3.058100000000000e+004)
INSERT INTO [tbcopsgcprovinces] ([RCODE],[PCODE],[PROV],[TPOP],[HPOP],[NOHH])VALUES('03','08','Bataan',5.576590000000000e+005,5.564890000000000e+005,1.136740000000000e+005)
INSERT INTO [tbcopsgcprovinces] ([RCODE],[PCODE],[PROV],[TPOP],[HPOP],[NOHH])VALUES('03','14','Bulacan',2.234088000000000e+006,2.229266000000000e+006,4.638860000000000e+005)
INSERT INTO [tbcopsgcprovinces] ([RCODE],[PCODE],[PROV],[TPOP],[HPOP],[NOHH])VALUES('03','49','Nueva Ecija',1.659883000000000e+006,1.655687000000000e+006,3.401580000000000e+005)
INSERT INTO [tbcopsgcprovinces] ([RCODE],[PCODE],[PROV],[TPOP],[HPOP],[NOHH])VALUES('03','54','Pampanga',1.618759000000000e+006,1.617040000000000e+006,3.084450000000000e+005)
INSERT INTO [tbcopsgcprovinces] ([RCODE],[PCODE],[PROV],[TPOP],[HPOP],[NOHH])VALUES('03','69','Tarlac',1.068783000000000e+006,1.067484000000000e+006,2.153950000000000e+005)
INSERT INTO [tbcopsgcprovinces] ([RCODE],[PCODE],[PROV],[TPOP],[HPOP],[NOHH])VALUES('03','71','Zambales',4.335420000000000e+005,4.327290000000000e+005,9.161300000000000e+004)
INSERT INTO [tbcopsgcprovinces] ([RCODE],[PCODE],[PROV],[TPOP],[HPOP],[NOHH])VALUES('03','77','Aurora',1.737970000000000e+005,1.735890000000000e+005,3.502400000000000e+004)
INSERT INTO [tbcopsgcprovinces] ([RCODE],[PCODE],[PROV],[TPOP],[HPOP],[NOHH])VALUES('04','10','Batangas',1.905348000000000e+006,1.901604000000000e+006,3.728960000000000e+005)
INSERT INTO [tbcopsgcprovinces] ([RCODE],[PCODE],[PROV],[TPOP],[HPOP],[NOHH])VALUES('04','21','Cavite',2.063161000000000e+006,2.049758000000000e+006,4.288790000000000e+005)
INSERT INTO [tbcopsgcprovinces] ([RCODE],[PCODE],[PROV],[TPOP],[HPOP],[NOHH])VALUES('04','34','Laguna',1.965872000000000e+006,1.959080000000000e+006,4.178860000000000e+005)
INSERT INTO [tbcopsgcprovinces] ([RCODE],[PCODE],[PROV],[TPOP],[HPOP],[NOHH])VALUES('04','56','Quezon',1.679030000000000e+006,1.675260000000000e+006,3.399230000000000e+005)
INSERT INTO [tbcopsgcprovinces] ([RCODE],[PCODE],[PROV],[TPOP],[HPOP],[NOHH])VALUES('04','58','Rizal',1.707218000000000e+006,1.702110000000000e+006,3.565780000000000e+005)
INSERT INTO [tbcopsgcprovinces] ([RCODE],[PCODE],[PROV],[TPOP],[HPOP],[NOHH])VALUES('17','40','Marinduque',2.173920000000000e+005,2.172440000000000e+005,4.392100000000000e+004)
INSERT INTO [tbcopsgcprovinces] ([RCODE],[PCODE],[PROV],[TPOP],[HPOP],[NOHH])VALUES('17','51','Occidental Mindoro',3.802500000000000e+005,3.785340000000000e+005,7.684000000000000e+004)
INSERT INTO [tbcopsgcprovinces] ([RCODE],[PCODE],[PROV],[TPOP],[HPOP],[NOHH])VALUES('17','52','Oriental Mindoro',6.818180000000000e+005,6.810770000000000e+005,1.343220000000000e+005)
INSERT INTO [tbcopsgcprovinces] ([RCODE],[PCODE],[PROV],[TPOP],[HPOP],[NOHH])VALUES('17','53','Palawan',7.554120000000000e+005,7.520120000000000e+005,1.509830000000000e+005)
INSERT INTO [tbcopsgcprovinces] ([RCODE],[PCODE],[PROV],[TPOP],[HPOP],[NOHH])VALUES('17','59','Romblon',2.643570000000000e+005,2.640810000000000e+005,5.372000000000000e+004)
INSERT INTO [tbcopsgcprovinces] ([RCODE],[PCODE],[PROV],[TPOP],[HPOP],[NOHH])VALUES('05','05','Albay',1.090907000000000e+006,1.089752000000000e+006,2.086400000000000e+005)
INSERT INTO [tbcopsgcprovinces] ([RCODE],[PCODE],[PROV],[TPOP],[HPOP],[NOHH])VALUES('05','16','Camarines Norte',4.588400000000000e+005,4.582730000000000e+005,8.957400000000000e+004)
INSERT INTO [tbcopsgcprovinces] ([RCODE],[PCODE],[PROV],[TPOP],[HPOP],[NOHH])VALUES('05','17','Camarines Sur',1.551549000000000e+006,1.548846000000000e+006,2.881720000000000e+005)
INSERT INTO [tbcopsgcprovinces] ([RCODE],[PCODE],[PROV],[TPOP],[HPOP],[NOHH])VALUES('05','20','Catanduanes',2.153560000000000e+005,2.151510000000000e+005,4.101900000000000e+004)
INSERT INTO [tbcopsgcprovinces] ([RCODE],[PCODE],[PROV],[TPOP],[HPOP],[NOHH])VALUES('05','41','Masbate',7.076680000000000e+005,7.070550000000000e+005,1.389450000000000e+005)
INSERT INTO [tbcopsgcprovinces] ([RCODE],[PCODE],[PROV],[TPOP],[HPOP],[NOHH])VALUES('05','62','Sorsogon',6.505350000000000e+005,6.494110000000000e+005,1.251910000000000e+005)
INSERT INTO [tbcopsgcprovinces] ([RCODE],[PCODE],[PROV],[TPOP],[HPOP],[NOHH])VALUES('06','04','Aklan',4.513140000000000e+005,4.503530000000000e+005,8.821300000000000e+004)
INSERT INTO [tbcopsgcprovinces] ([RCODE],[PCODE],[PROV],[TPOP],[HPOP],[NOHH])VALUES('06','06','Antique',4.710880000000000e+005,4.701980000000000e+005,9.294100000000000e+004)
INSERT INTO [tbcopsgcprovinces] ([RCODE],[PCODE],[PROV],[TPOP],[HPOP],[NOHH])VALUES('06','19','Capiz',6.541560000000000e+005,6.535960000000000e+005,1.285540000000000e+005)
INSERT INTO [tbcopsgcprovinces] ([RCODE],[PCODE],[PROV],[TPOP],[HPOP],[NOHH])VALUES('06','79','Guimaras',1.414500000000000e+005,1.412180000000000e+005,2.746500000000000e+004)
INSERT INTO [tbcopsgcprovinces] ([RCODE],[PCODE],[PROV],[TPOP],[HPOP],[NOHH])VALUES('06','30','Iloilo',1.559182000000000e+006,1.558290000000000e+006,2.985930000000000e+005)
INSERT INTO [tbcopsgcprovinces] ([RCODE],[PCODE],[PROV],[TPOP],[HPOP],[NOHH])VALUES('06','45','Negros Occidental',2.136647000000000e+006,2.134479000000000e+006,4.162220000000000e+005)
INSERT INTO [tbcopsgcprovinces] ([RCODE],[PCODE],[PROV],[TPOP],[HPOP],[NOHH])VALUES('07','12','Bohol',1.137268000000000e+006,1.134733000000000e+006,2.095880000000000e+005)
INSERT INTO [tbcopsgcprovinces] ([RCODE],[PCODE],[PROV],[TPOP],[HPOP],[NOHH])VALUES('07','22','Cebu',2.377588000000000e+006,2.366585000000000e+006,4.735590000000000e+005)
INSERT INTO [tbcopsgcprovinces] ([RCODE],[PCODE],[PROV],[TPOP],[HPOP],[NOHH])VALUES('07','46','Negros Oriental',1.126061000000000e+006,1.124710000000000e+006,2.263370000000000e+005)
INSERT INTO [tbcopsgcprovinces] ([RCODE],[PCODE],[PROV],[TPOP],[HPOP],[NOHH])VALUES('07','61','Siquijor',8.159800000000000e+004,8.151700000000000e+004,1.735100000000000e+004)
INSERT INTO [tbcopsgcprovinces] ([RCODE],[PCODE],[PROV],[TPOP],[HPOP],[NOHH])VALUES('08','78','Biliran',1.402740000000000e+005,1.401740000000000e+005,2.790700000000000e+004)
INSERT INTO [tbcopsgcprovinces] ([RCODE],[PCODE],[PROV],[TPOP],[HPOP],[NOHH])VALUES('08','26','Eastern Samar',3.758220000000000e+005,3.751240000000000e+005,7.303200000000000e+004)
INSERT INTO [tbcopsgcprovinces] ([RCODE],[PCODE],[PROV],[TPOP],[HPOP],[NOHH])VALUES('08','37','Leyte',1.592336000000000e+006,1.587847000000000e+006,3.225270000000000e+005)
INSERT INTO [tbcopsgcprovinces] ([RCODE],[PCODE],[PROV],[TPOP],[HPOP],[NOHH])VALUES('08','48','Northern Samar',5.006390000000000e+005,4.999920000000000e+005,9.441000000000000e+004)
INSERT INTO [tbcopsgcprovinces] ([RCODE],[PCODE],[PROV],[TPOP],[HPOP],[NOHH])VALUES('08','64','Southern Leyte',3.601600000000000e+005,3.597380000000000e+005,7.289400000000000e+004)
INSERT INTO [tbcopsgcprovinces] ([RCODE],[PCODE],[PROV],[TPOP],[HPOP],[NOHH])VALUES('08','60','Samar (Western Samar)',6.411240000000000e+005,6.400790000000000e+005,1.242550000000000e+005)
INSERT INTO [tbcopsgcprovinces] ([RCODE],[PCODE],[PROV],[TPOP],[HPOP],[NOHH])VALUES('09','72','Zamboanga Del Norte',8.231300000000000e+005,8.219180000000000e+005,1.615110000000000e+005)
INSERT INTO [tbcopsgcprovinces] ([RCODE],[PCODE],[PROV],[TPOP],[HPOP],[NOHH])VALUES('09','73','Zamboanga Del Sur',1.333456000000000e+006,1.331030000000000e+006,2.555180000000000e+005)
INSERT INTO [tbcopsgcprovinces] ([RCODE],[PCODE],[PROV],[TPOP],[HPOP],[NOHH])VALUES('09','83','Zamboanga Sibugay',NULL,NULL,NULL)
INSERT INTO [tbcopsgcprovinces] ([RCODE],[PCODE],[PROV],[TPOP],[HPOP],[NOHH])VALUES('09','97','Isabela City',7.303200000000000e+004,7.287600000000000e+004,1.375300000000000e+004)
INSERT INTO [tbcopsgcprovinces] ([RCODE],[PCODE],[PROV],[TPOP],[HPOP],[NOHH])VALUES('10','13','Bukidnon',1.060265000000000e+006,1.059203000000000e+006,2.017520000000000e+005)
INSERT INTO [tbcopsgcprovinces] ([RCODE],[PCODE],[PROV],[TPOP],[HPOP],[NOHH])VALUES('10','18','Camiguin',7.423200000000000e+004,7.413400000000000e+004,1.482600000000000e+004)
INSERT INTO [tbcopsgcprovinces] ([RCODE],[PCODE],[PROV],[TPOP],[HPOP],[NOHH])VALUES('10','42','Misamis Occidental',4.867230000000000e+005,4.859780000000000e+005,9.990100000000000e+004)
INSERT INTO [tbcopsgcprovinces] ([RCODE],[PCODE],[PROV],[TPOP],[HPOP],[NOHH])VALUES('10','43','Misamis Oriental',6.643380000000000e+005,6.635590000000000e+005,1.320420000000000e+005)
INSERT INTO [tbcopsgcprovinces] ([RCODE],[PCODE],[PROV],[TPOP],[HPOP],[NOHH])VALUES('10','35','Lanao Del Norte',4.730620000000000e+005,4.726460000000000e+005,9.009200000000000e+004)
INSERT INTO [tbcopsgcprovinces] ([RCODE],[PCODE],[PROV],[TPOP],[HPOP],[NOHH])VALUES('11','23','Davao Del Norte (Davao)',7.438110000000000e+005,7.420840000000000e+005,1.508440000000000e+005)
INSERT INTO [tbcopsgcprovinces] ([RCODE],[PCODE],[PROV],[TPOP],[HPOP],[NOHH])VALUES('11','24','Davao Del Sur',7.588010000000000e+005,7.579480000000000e+005,1.570540000000000e+005)
INSERT INTO [tbcopsgcprovinces] ([RCODE],[PCODE],[PROV],[TPOP],[HPOP],[NOHH])VALUES('11','25','Davao Oriental',4.461910000000000e+005,4.456170000000000e+005,8.656900000000000e+004)
INSERT INTO [tbcopsgcprovinces] ([RCODE],[PCODE],[PROV],[TPOP],[HPOP],[NOHH])VALUES('11','82','Compostela Valley',5.802440000000000e+005,5.796760000000000e+005,1.207660000000000e+005)
INSERT INTO [tbcopsgcprovinces] ([RCODE],[PCODE],[PROV],[TPOP],[HPOP],[NOHH])VALUES('12','47','Cotabato (North Cotabato)',9.586430000000000e+005,9.572940000000000e+005,1.885810000000000e+005)
INSERT INTO [tbcopsgcprovinces] ([RCODE],[PCODE],[PROV],[TPOP],[HPOP],[NOHH])VALUES('12','80','Sarangani',4.106220000000000e+005,4.101250000000000e+005,8.289600000000000e+004)
INSERT INTO [tbcopsgcprovinces] ([RCODE],[PCODE],[PROV],[TPOP],[HPOP],[NOHH])VALUES('12','63','South Cotabato',6.907280000000000e+005,6.896420000000000e+005,1.414180000000000e+005)
INSERT INTO [tbcopsgcprovinces] ([RCODE],[PCODE],[PROV],[TPOP],[HPOP],[NOHH])VALUES('12','65','Sultan Kudarat',5.865050000000000e+005,5.857680000000000e+005,1.144610000000000e+005)
INSERT INTO [tbcopsgcprovinces] ([RCODE],[PCODE],[PROV],[TPOP],[HPOP],[NOHH])VALUES('13','39','Ncr, First District',1.581082000000000e+006,1.568092000000000e+006,3.335470000000000e+005)
INSERT INTO [tbcopsgcprovinces] ([RCODE],[PCODE],[PROV],[TPOP],[HPOP],[NOHH])VALUES('13','74','Ncr, Second District',3.466213000000000e+006,3.443647000000000e+006,7.529060000000000e+005)
INSERT INTO [tbcopsgcprovinces] ([RCODE],[PCODE],[PROV],[TPOP],[HPOP],[NOHH])VALUES('13','75','Ncr, Third District',2.232295000000000e+006,2.221953000000000e+006,4.795360000000000e+005)
INSERT INTO [tbcopsgcprovinces] ([RCODE],[PCODE],[PROV],[TPOP],[HPOP],[NOHH])VALUES('13','76','Ncr, Fourth District',2.626458000000000e+006,2.602958000000000e+006,5.612440000000000e+005)
INSERT INTO [tbcopsgcprovinces] ([RCODE],[PCODE],[PROV],[TPOP],[HPOP],[NOHH])VALUES('14','01','Abra',2.094910000000000e+005,2.089960000000000e+005,4.070900000000000e+004)
INSERT INTO [tbcopsgcprovinces] ([RCODE],[PCODE],[PROV],[TPOP],[HPOP],[NOHH])VALUES('14','81','Apayao',9.712900000000000e+004,9.702800000000000e+004,1.816500000000000e+004)
INSERT INTO [tbcopsgcprovinces] ([RCODE],[PCODE],[PROV],[TPOP],[HPOP],[NOHH])VALUES('14','11','Benguet',3.301290000000000e+005,3.291640000000000e+005,6.312300000000000e+004)
INSERT INTO [tbcopsgcprovinces] ([RCODE],[PCODE],[PROV],[TPOP],[HPOP],[NOHH])VALUES('14','27','Ifugao',1.616230000000000e+005,1.613760000000000e+005,3.134600000000000e+004)
INSERT INTO [tbcopsgcprovinces] ([RCODE],[PCODE],[PROV],[TPOP],[HPOP],[NOHH])VALUES('14','32','Kalinga',1.740230000000000e+005,1.733520000000000e+005,3.045000000000000e+004)
INSERT INTO [tbcopsgcprovinces] ([RCODE],[PCODE],[PROV],[TPOP],[HPOP],[NOHH])VALUES('14','44','Mountain Province',1.404390000000000e+005,1.403380000000000e+005,2.772100000000000e+004)
INSERT INTO [tbcopsgcprovinces] ([RCODE],[PCODE],[PROV],[TPOP],[HPOP],[NOHH])VALUES('15','07','Basilan',3.328280000000000e+005,3.325790000000000e+005,6.154600000000000e+004)
INSERT INTO [tbcopsgcprovinces] ([RCODE],[PCODE],[PROV],[TPOP],[HPOP],[NOHH])VALUES('15','36','Lanao Del Sur',6.690720000000000e+005,6.686430000000000e+005,9.710400000000000e+004)
INSERT INTO [tbcopsgcprovinces] ([RCODE],[PCODE],[PROV],[TPOP],[HPOP],[NOHH])VALUES('15','38','Maguindanao',8.011020000000000e+005,8.003690000000000e+005,1.436690000000000e+005)
INSERT INTO [tbcopsgcprovinces] ([RCODE],[PCODE],[PROV],[TPOP],[HPOP],[NOHH])VALUES('15','66','Sulu',6.196680000000000e+005,6.194300000000000e+005,9.815100000000000e+004)
INSERT INTO [tbcopsgcprovinces] ([RCODE],[PCODE],[PROV],[TPOP],[HPOP],[NOHH])VALUES('15','70','Tawi-Tawi',3.223170000000000e+005,3.220660000000000e+005,5.434500000000000e+004)
INSERT INTO [tbcopsgcprovinces] ([RCODE],[PCODE],[PROV],[TPOP],[HPOP],[NOHH])VALUES('16','02','Agusan Del Norte',2.855700000000000e+005,2.850650000000000e+005,5.277900000000000e+004)
INSERT INTO [tbcopsgcprovinces] ([RCODE],[PCODE],[PROV],[TPOP],[HPOP],[NOHH])VALUES('16','03','Agusan Del Sur',5.592940000000000e+005,5.584060000000000e+005,1.036370000000000e+005)
INSERT INTO [tbcopsgcprovinces] ([RCODE],[PCODE],[PROV],[TPOP],[HPOP],[NOHH])VALUES('16','67','Surigao Del Norte',4.814160000000000e+005,4.806910000000000e+005,9.264500000000000e+004)
INSERT INTO [tbcopsgcprovinces] ([RCODE],[PCODE],[PROV],[TPOP],[HPOP],[NOHH])VALUES('16','68','Surigao Del Sur',5.018080000000000e+005,5.011350000000000e+005,9.402800000000000e+004)
INSERT INTO [tbcopsgcprovinces] ([RCODE],[PCODE],[PROV],[TPOP],[HPOP],[NOHH])VALUES('01','28','Ilocos Norte',5.142410000000000e+005,5.130870000000000e+005,1.069390000000000e+005)
INSERT INTO [tbcopsgcprovinces] ([RCODE],[PCODE],[PROV],[TPOP],[HPOP],[NOHH])VALUES('01','29','Ilocos Sur',5.942060000000000e+005,5.934490000000000e+005,1.192120000000000e+005)
INSERT INTO [tbcopsgcprovinces] ([RCODE],[PCODE],[PROV],[TPOP],[HPOP],[NOHH])VALUES('01','33','La Union',6.579450000000000e+005,6.568520000000000e+005,1.275790000000000e+005)
INSERT INTO [tbcopsgcprovinces] ([RCODE],[PCODE],[PROV],[TPOP],[HPOP],[NOHH])VALUES('01','55','Pangasinan',2.434086000000000e+006,2.432126000000000e+006,4.778190000000000e+005)