--
-- Data for Name: dds_religion_by_country_code(id,last_changed,last_modifier_id,frequency,cumul,religion_id,country_code_id); Type: TABLE DATA; Schema: public; Owner: gazelle
--
INSERT INTO dds_religion_by_country_code(id,last_changed,last_modifier_id,frequency,cumul,religion_id,country_code_id) VALUES (1, '2009-08-25 12:30:00.000', NULL, 26, 64, 21, 14);
INSERT INTO dds_religion_by_country_code(id,last_changed,last_modifier_id,frequency,cumul,religion_id,country_code_id) VALUES (2, '2009-07-23 16:59:31.372', NULL, 2, 66, 60, 14);
INSERT INTO dds_religion_by_country_code(id,last_changed,last_modifier_id,frequency,cumul,religion_id,country_code_id) VALUES (3, '2009-07-23 16:59:31.374', NULL, 2, 68, 20, 14);
INSERT INTO dds_religion_by_country_code(id,last_changed,last_modifier_id,frequency,cumul,religion_id,country_code_id) VALUES (4, '2009-08-25 12:30:00.000', NULL, 21, 69, 11, 14);
INSERT INTO dds_religion_by_country_code(id,last_changed,last_modifier_id,frequency,cumul,religion_id,country_code_id) VALUES (5, '2009-08-25 12:30:00.000', NULL, 13, 70, 69, 14);
INSERT INTO dds_religion_by_country_code(id,last_changed,last_modifier_id,frequency,cumul,religion_id,country_code_id) VALUES (6, '2009-08-25 12:30:00.000', NULL, 15, 100, 66, 14);
INSERT INTO dds_religion_by_country_code(id,last_changed,last_modifier_id,frequency,cumul,religion_id,country_code_id) VALUES (60, '2009-08-25 12:30:00.000', NULL, 21, 100, 33, 14);

INSERT INTO dds_religion_by_country_code(id,last_changed,last_modifier_id,frequency,cumul,religion_id,country_code_id) VALUES (38, '2009-08-25 12:30:00.000', NULL, 75, 50, 21, 216);
INSERT INTO dds_religion_by_country_code(id,last_changed,last_modifier_id,frequency,cumul,religion_id,country_code_id) VALUES (39, '2009-08-25 12:30:00.000', NULL, 25, 54, 73, 216);

INSERT INTO dds_religion_by_country_code(id,last_changed,last_modifier_id,frequency,cumul,religion_id,country_code_id) VALUES (49, '2009-08-25 12:30:00.000', NULL, 46, 64, 21, 36);
INSERT INTO dds_religion_by_country_code(id,last_changed,last_modifier_id,frequency,cumul,religion_id,country_code_id) VALUES (50, '2009-07-23 16:59:31.398', NULL, 2, 66, 60, 36);
INSERT INTO dds_religion_by_country_code(id,last_changed,last_modifier_id,frequency,cumul,religion_id,country_code_id) VALUES (51, '2009-08-25 12:30:00.000', NULL, 18, 100, 66, 36);
INSERT INTO dds_religion_by_country_code(id,last_changed,last_modifier_id,frequency,cumul,religion_id,country_code_id) VALUES (52, '2009-08-25 12:30:00.000', NULL, 7, 69, 33, 36);
INSERT INTO dds_religion_by_country_code(id,last_changed,last_modifier_id,frequency,cumul,religion_id,country_code_id) VALUES (53, '2009-08-25 12:30:00.000', NULL, 24, 75, 73, 36);

INSERT INTO dds_religion_by_country_code(id,last_changed,last_modifier_id,frequency,cumul,religion_id,country_code_id) VALUES (44, '2009-08-25 12:30:00.000', NULL, 4, 4, 23, 42);
INSERT INTO dds_religion_by_country_code(id,last_changed,last_modifier_id,frequency,cumul,religion_id,country_code_id) VALUES (45, '2009-07-23 16:59:31.438', NULL, 2, 6, 60, 42);
INSERT INTO dds_religion_by_country_code(id,last_changed,last_modifier_id,frequency,cumul,religion_id,country_code_id) VALUES (46, '2009-08-25 12:30:00.000', NULL, 93, 86, 13, 42);
INSERT INTO dds_religion_by_country_code(id,last_changed,last_modifier_id,frequency,cumul,religion_id,country_code_id) VALUES (47, '2009-08-25 12:30:00.000', NULL, 1, 87, 20, 42);

INSERT INTO dds_religion_by_country_code(id,last_changed,last_modifier_id,frequency,cumul,religion_id,country_code_id) VALUES (7, '2009-08-25 12:30:00.000', NULL, 34, 63, 21, 223);
INSERT INTO dds_religion_by_country_code(id,last_changed,last_modifier_id,frequency,cumul,religion_id,country_code_id) VALUES (8, '2009-07-23 16:59:31.451', NULL, 4, 67, 60, 223);
INSERT INTO dds_religion_by_country_code(id,last_changed,last_modifier_id,frequency,cumul,religion_id,country_code_id) VALUES (9, '2009-08-25 12:30:00.000', NULL, 34, 68, 73, 223);
INSERT INTO dds_religion_by_country_code(id,last_changed,last_modifier_id,frequency,cumul,religion_id,country_code_id) VALUES (11, '2009-08-25 12:30:00.000', NULL, 28, 70, 69, 223);

-- Catholics
INSERT INTO dds_religion_by_country_code(id,last_changed,last_modifier_id,frequency,cumul,religion_id,country_code_id) VALUES (55, '2009-08-25 12:30:00.000', NULL, 85, 60, 21, 222);
-- Muslim
INSERT INTO dds_religion_by_country_code(id,last_changed,last_modifier_id,frequency,cumul,religion_id,country_code_id) VALUES (56, '2009-07-23 16:59:31.464', NULL, 8, 70, 60, 222);
-- Protestant 
INSERT INTO dds_religion_by_country_code(id,last_changed,last_modifier_id,frequency,cumul,religion_id,country_code_id) VALUES (57, '2009-07-23 16:59:31.465', NULL, 2, 71, 73, 222);

INSERT INTO dds_religion_by_country_code(id,last_changed,last_modifier_id,frequency,cumul,religion_id,country_code_id) VALUES (58, '2009-08-25 12:30:00.000', NULL, 1, 100, 48, 222);
INSERT INTO dds_religion_by_country_code(id,last_changed,last_modifier_id,frequency,cumul,religion_id,country_code_id) VALUES (59, '2009-08-25 12:30:00.000', NULL, 4, 74, 69, 222);

INSERT INTO dds_religion_by_country_code(id,last_changed,last_modifier_id,frequency,cumul,religion_id,country_code_id) VALUES (32, '2009-08-25 12:30:00.000', NULL, 71, 71, 23, 238);
INSERT INTO dds_religion_by_country_code(id,last_changed,last_modifier_id,frequency,cumul,religion_id,country_code_id) VALUES (33, '2009-07-23 16:59:31.477', NULL, 3, 74, 60, 238);
INSERT INTO dds_religion_by_country_code(id,last_changed,last_modifier_id,frequency,cumul,religion_id,country_code_id) VALUES (35, '2009-07-23 16:59:31.481', NULL, 1, 77, 42, 238);
INSERT INTO dds_religion_by_country_code(id,last_changed,last_modifier_id,frequency,cumul,religion_id,country_code_id) VALUES (36, '2009-08-25 12:30:00.000', NULL, 2, 85, 69, 238);
INSERT INTO dds_religion_by_country_code(id,last_changed,last_modifier_id,frequency,cumul,religion_id,country_code_id) VALUES (37, '2009-08-25 12:30:00.000', NULL, 23, 100, 66, 238);

INSERT INTO dds_religion_by_country_code(id,last_changed,last_modifier_id,frequency,cumul,religion_id,country_code_id) VALUES (13, '2009-08-25 12:30:00.000', NULL, 90, 81, 21, 226);
INSERT INTO dds_religion_by_country_code(id,last_changed,last_modifier_id,frequency,cumul,religion_id,country_code_id) VALUES (14, '2009-07-23 16:59:31.491', NULL, 2, 83, 60, 226);
INSERT INTO dds_religion_by_country_code(id,last_changed,last_modifier_id,frequency,cumul,religion_id,country_code_id) VALUES (15, '2009-08-25 12:30:00.000', NULL, 5, 84, 73, 226);
INSERT INTO dds_religion_by_country_code(id,last_changed,last_modifier_id,frequency,cumul,religion_id,country_code_id) VALUES (16, '2009-08-25 12:30:00.000', NULL, 3, 85, 48, 226);

INSERT INTO dds_religion_by_country_code(id,last_changed,last_modifier_id,frequency,cumul,religion_id,country_code_id) VALUES (19, '2009-07-23 16:59:31.504', NULL, 1, 1, 21, 95);
INSERT INTO dds_religion_by_country_code(id,last_changed,last_modifier_id,frequency,cumul,religion_id,country_code_id) VALUES (20, '2009-08-25 12:30:00.000', NULL, 42, 2, 79, 95);
INSERT INTO dds_religion_by_country_code(id,last_changed,last_modifier_id,frequency,cumul,religion_id,country_code_id) VALUES (21, '2009-08-25 12:30:00.000', NULL, 42, 23, 20, 95);
INSERT INTO dds_religion_by_country_code(id,last_changed,last_modifier_id,frequency,cumul,religion_id,country_code_id) VALUES (23, '2009-08-25 12:30:00.000', NULL, 15, 27, 69, 95);

INSERT INTO dds_religion_by_country_code(id,last_changed,last_modifier_id,frequency,cumul,religion_id,country_code_id) VALUES (25, '2009-08-25 12:30:00.000', NULL, 26, 78, 21, 201);
INSERT INTO dds_religion_by_country_code(id,last_changed,last_modifier_id,frequency,cumul,religion_id,country_code_id) VALUES (26, '2009-08-25 12:30:00.000', NULL, 2, 79, 60, 201);
INSERT INTO dds_religion_by_country_code(id,last_changed,last_modifier_id,frequency,cumul,religion_id,country_code_id) VALUES (27, '2009-08-25 12:30:00.000', NULL, 54, 82, 73, 201);
INSERT INTO dds_religion_by_country_code(id,last_changed,last_modifier_id,frequency,cumul,religion_id,country_code_id) VALUES (28, '2009-08-25 12:30:00.000', NULL, 2, 83, 48, 201);
INSERT INTO dds_religion_by_country_code(id,last_changed,last_modifier_id,frequency,cumul,religion_id,country_code_id) VALUES (29, '2009-08-25 12:30:00.000', NULL, 4, 84, 69, 201);
INSERT INTO dds_religion_by_country_code(id,last_changed,last_modifier_id,frequency,cumul,religion_id,country_code_id) VALUES (30, '2009-08-25 12:30:00.000', NULL, 12, 98, 66, 201);

INSERT INTO dds_religion_by_country_code(id,last_changed,last_modifier_id,frequency,cumul,religion_id,country_code_id) VALUES (31, '2009-08-25 12:30:00.000', NULL, 69, null, 21, 215);
INSERT INTO dds_religion_by_country_code(id,last_changed,last_modifier_id,frequency,cumul,religion_id,country_code_id) VALUES (61, '2009-08-25 12:30:00.000', NULL, 5, null, 73, 215);
INSERT INTO dds_religion_by_country_code(id,last_changed,last_modifier_id,frequency,cumul,religion_id,country_code_id) VALUES (62, '2009-08-25 12:30:00.000', NULL, 4, null, 60, 215);
INSERT INTO dds_religion_by_country_code(id,last_changed,last_modifier_id,frequency,cumul,religion_id,country_code_id) VALUES (63, '2009-08-25 12:30:00.000', NULL, 3, null, 69, 215);
INSERT INTO dds_religion_by_country_code(id,last_changed,last_modifier_id,frequency,cumul,religion_id,country_code_id) VALUES (64, '2009-08-25 12:30:00.000', NULL, 2, null, 87, 215);
INSERT INTO dds_religion_by_country_code(id,last_changed,last_modifier_id,frequency,cumul,religion_id,country_code_id) VALUES (65, '2009-08-25 12:30:00.000', NULL, 17, null, 66, 215);



SELECT pg_catalog.setval('dds_religion_by_country_code_id_seq', 66, true);

UPDATE dds_religion_by_country_code set cumul = ( SELECT sum(frequency) from dds_religion_by_country_code a where a.country_code_id = 201 and a.id <= dds_religion_by_country_code.id) where country_code_id = 201 ;
UPDATE dds_religion_by_country_code set cumul = ( SELECT sum(frequency) from dds_religion_by_country_code a where a.country_code_id = 95 and a.id <= dds_religion_by_country_code.id) where country_code_id = 95 ;
UPDATE dds_religion_by_country_code set cumul = ( SELECT sum(frequency) from dds_religion_by_country_code a where a.country_code_id = 222 and a.id <= dds_religion_by_country_code.id) where country_code_id = 222 ;
UPDATE dds_religion_by_country_code set cumul = ( SELECT sum(frequency) from dds_religion_by_country_code a where a.country_code_id = 226 and a.id <= dds_religion_by_country_code.id) where country_code_id = 226 ;
UPDATE dds_religion_by_country_code set cumul = ( SELECT sum(frequency) from dds_religion_by_country_code a where a.country_code_id = 238 and a.id <= dds_religion_by_country_code.id) where country_code_id = 238 ;
UPDATE dds_religion_by_country_code set cumul = ( SELECT sum(frequency) from dds_religion_by_country_code a where a.country_code_id = 223 and a.id <= dds_religion_by_country_code.id) where country_code_id = 223 ;
UPDATE dds_religion_by_country_code set cumul = ( SELECT sum(frequency) from dds_religion_by_country_code a where a.country_code_id = 36 and a.id <= dds_religion_by_country_code.id) where country_code_id = 36 ;
UPDATE dds_religion_by_country_code set cumul = ( SELECT sum(frequency) from dds_religion_by_country_code a where a.country_code_id = 42 and a.id <= dds_religion_by_country_code.id) where country_code_id = 42 ;
UPDATE dds_religion_by_country_code set cumul = ( SELECT sum(frequency) from dds_religion_by_country_code a where a.country_code_id = 216 and a.id <= dds_religion_by_country_code.id) where country_code_id = 216 ;
UPDATE dds_religion_by_country_code set cumul = ( SELECT sum(frequency) from dds_religion_by_country_code a where a.country_code_id = 14 and a.id <= dds_religion_by_country_code.id) where country_code_id = 14 ;
UPDATE dds_religion_by_country_code set cumul = ( SELECT sum(frequency) from dds_religion_by_country_code a where a.country_code_id = 215 and a.id <= dds_religion_by_country_code.id) where country_code_id = 215 ;
