Skip to content

Instantly share code, notes, and snippets.

@eoglethorpe

eoglethorpe/winter.sql

Last active November 30, 2015 04:04
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save eoglethorpe/c92a6438397129c6e19b to your computer and use it in GitHub Desktop.
Save eoglethorpe/c92a6438397129c6e19b to your computer and use it in GitHub Desktop.
Download ZIP
Raw
winter.sql
--add winterisation data
drop table if exists winterisation_db;
CREATE TABLE winterisation_db
("dist_code" varchar(11), "vdc_code" varchar(17), "district" varchar(15), "vdc" varchar(32), "rep_ag" varchar(26), "imp_ag" varchar(21), "target_hh" int, "type" varchar(61), "full" varchar(3), "comment" varchar(362), "act_state" varchar(9), "edit_dt" timestamp, "comments" varchar(119))
;
INSERT INTO winterisation_db
("dist_code", "vdc_code", "district", "vdc", "rep_ag", "imp_ag", "target_hh", "type", "full", "comment", "act_state", "edit_dt", "comments")
VALUES
('524 3 07 36', '524 3 07 36 5 037', 'Gorkha', 'Bihi', 'PIN', 'PIN/CRS/SCI/UVN', 235, NULL, 'Yes', NULL, 'Ongoing', '2015-11-11 00:00:00', NULL),
('524 3 07 36', '524 3 07 36 5 038', 'Gorkha', 'Chhekampar', 'PIN', 'PIN/CRS/SCI/UVN', 269, NULL, 'Yes', NULL, 'Ongoing', '2015-11-11 00:00:00', NULL),
('524 3 07 36', '524 3 07 36 5 039', 'Gorkha', 'Chumchet', 'PIN', 'PIN/CRS/SCI/UVN', 250, NULL, 'Yes', NULL, 'Ongoing', '2015-11-11 00:00:00', NULL),
('524 3 07 36', '524 3 07 36 5 040', 'Gorkha', 'Lho', 'PIN', 'PIN/CRS/SCI/UVN', 302, NULL, 'Yes', NULL, 'Ongoing', '2015-11-11 00:00:00', NULL),
('524 3 07 36', '524 3 07 36 5 041', 'Gorkha', 'Prok', 'PIN', 'PIN/CRS/SCI/UVN', 221, NULL, 'Yes', NULL, 'Ongoing', '2015-11-11 00:00:00', NULL),
('524 3 07 36', '524 3 07 36 5 042', 'Gorkha', 'Samagaun', 'Christian Aid', 'CA/GORETO', 212, NULL, NULL, NULL, 'Planned', '2015-11-11 00:00:00', NULL),
('524 3 07 36', '524 3 07 36 5 043', 'Gorkha', 'Sirdibas', 'PIN', 'PIN/CRS/SCI/UVN', 690, NULL, 'Yes', NULL, 'Ongoing', '2015-11-11 00:00:00', NULL),
('524 3 07 36', '524 3 07 36 5 065', 'Gorkha', 'Barpak', 'CARE', 'CARE', 1354, NULL, NULL, NULL, 'Planned', '2015-11-11 00:00:00', NULL),
('524 3 07 36', '524 3 07 36 5 066', 'Gorkha', 'Ghyachok', 'OXFAM', 'OXFAM/GORETO', 453, NULL, NULL, NULL, 'Planned', '2015-11-11 00:00:00', NULL),
('524 3 07 36', '524 3 07 36 5 044', 'Gorkha', 'Gumda', 'CARE', 'CARE', 645, NULL, NULL, NULL, 'Planned', '2015-11-11 00:00:00', NULL),
('524 3 07 36', '524 3 07 36 5 045', 'Gorkha', 'Kashigaun', 'SCI', 'SCI', 508, 'Voucher', NULL, '126 USD worth voucher/cash grants for shelter/winterisation support.', 'Planned', '2015-11-11 00:00:00', NULL),
('524 3 07 36', '524 3 07 36 5 046', 'Gorkha', 'Kerauja', 'CARE', 'PIN/CARE', 844, NULL, NULL, NULL, 'Planned', '2015-11-11 00:00:00', NULL),
('524 3 07 36', '524 3 07 36 5 047', 'Gorkha', 'Laprak', 'CARE', 'CARE', 620, NULL, NULL, NULL, 'Planned', '2015-11-11 00:00:00', NULL),
('524 3 07 36', '524 3 07 36 5 048', 'Gorkha', 'Lapu', 'SCI', 'SCI', 522, 'Voucher', NULL, '126 USD worth voucher/cash grants for shelter/winterisation support.', 'Planned', '2015-11-11 00:00:00', NULL),
('524 3 07 36', '524 3 07 36 5 051', 'Gorkha', 'Uhiya', 'CARE', 'PIN/CARE', 529, NULL, NULL, NULL, 'Planned', '2015-11-11 00:00:00', NULL),
('524 3 07 36', '524 3 07 36 5 019', 'Gorkha', 'Hansapur', 'CRS', 'CRS/CN', 1056, NULL, NULL, NULL, 'Planned', '2015-11-11 00:00:00', NULL),
('524 3 07 36', '524 3 07 36 5 022', 'Gorkha', 'Kerabari', 'CRS', 'CRS/CN', 299, NULL, NULL, NULL, 'Planned', '2015-11-11 00:00:00', NULL),
('524 3 07 36', '524 3 07 36 5 023', 'Gorkha', 'Kharibot', 'CRS', 'CRS/CN', 575, NULL, NULL, NULL, 'Planned', '2015-11-11 00:00:00', NULL),
('524 3 07 36', '524 3 07 36 5 049', 'Gorkha', 'Manbu', 'CRS', 'SCI', 1766, NULL, NULL, NULL, 'Planned', '2015-11-11 00:00:00', NULL),
('524 3 07 36', '524 3 07 36 5 036', 'Gorkha', 'Muchhok', 'CARE', 'CARE', 1012, NULL, NULL, NULL, 'Planned', '2015-11-11 00:00:00', NULL),
('524 3 07 36', '524 3 07 36 5 061', 'Gorkha', 'Saurpani', 'CARE', 'CARE', 1535, NULL, NULL, NULL, 'Planned', '2015-11-11 00:00:00', NULL),
('524 3 07 36', '524 3 07 36 5 035', 'Gorkha', 'Simjung', 'OXFAM', 'OXFAM/GORETO', 913, NULL, NULL, NULL, 'Planned', '2015-11-11 00:00:00', NULL),
('524 3 07 36', '524 3 07 36 5 062', 'Gorkha', 'Swara', 'SCI', 'SCI/SSICDC/SDSC', 891, 'Voucher', NULL, '126 USD worth voucher/cash grants for shelter/winterisation support.', 'Planned', '2015-11-11 00:00:00', NULL),
('524 3 07 36', '524 3 07 36 5 064', 'Gorkha', 'Takumajh Lakuribot', 'OXFAM', 'OXFAM/TMUC', 637, NULL, NULL, NULL, 'Planned', '2015-11-11 00:00:00', NULL),
('524 3 07 36', '524 3 07 36 5 050', 'Gorkha', 'Thumi', 'CRS', 'CRS/CN', 1230, NULL, NULL, '126 USD worth voucher/cash grants for shelter/winterisation support.', 'Planned', '2015-11-11 00:00:00', NULL),
('524 2 06 31', '524 2 06 31 5 032', 'Makawanpur', 'Agra', 'Tearfund', 'RADO Nepal', 625, NULL, 'No', 'Clothes| Blankets| Socks| Baby Warmer', 'Planned', '2015-11-11 00:00:00', NULL),
('524 2 06 31', '524 2 06 31 5 033', 'Makawanpur', 'Tistung', 'Tearfund', 'RADO Nepal', 625, NULL, 'No', 'Clothes| Blankets| Socks| Baby Warmer', 'Planned', '2015-11-11 00:00:00', NULL),
('524 2 06 31', '524 2 06 31 5 029', 'Makawanpur', 'Palung', 'ICCO', 'CCDN', 265, 'Voucher', NULL, 'Blankets| Clothes| Tarpaulin| Floor Bed Foam| Mattress', 'Planned', '2015-11-11 00:00:00', NULL),
('524 2 06 31', '524 2 06 31 5 030', 'Makawanpur', 'Daman', 'ICCO', 'CCDN', 265, 'Voucher', NULL, NULL, 'Planned', '2015-11-11 00:00:00', NULL),
('524 2 06 31', '524 2 06 31 5 035', 'Makawanpur', 'Bajrabarahi', 'ICCO', 'CCDN', 265, 'Voucher', NULL, NULL, 'Planned', '2015-11-11 00:00:00', NULL),
('524 2 06 31', '524 2 06 31 5 026', 'Makawanpur', 'Namtar', 'ICCO', 'CCDN', 200, 'Voucher', NULL, NULL, 'Planned', '2015-11-11 00:00:00', NULL),
('524 2 06 31', '524 2 06 31 5 036', 'Makawanpur', 'Chitlang', 'ICCO', 'CCDN', 170, 'Voucher', NULL, NULL, 'Planned', '2015-11-11 00:00:00', NULL),
('524 2 06 31', '524 2 06 31 5 036', 'Makawanpur', 'Chitlang', 'Plan International', NULL, NULL, NULL, NULL, NULL, 'Planned', '2015-11-11 00:00:00', NULL),
('524 2 06 31', '524 2 06 31 5 040', 'Makawanpur', 'Phakhel', 'Plan International', NULL, NULL, NULL, NULL, NULL, 'Planned', '2015-11-11 00:00:00', NULL),
('524 2 06 31', '524 2 06 31 5 034', 'Makawanpur', 'Markhu', 'Plan International', NULL, NULL, NULL, NULL, NULL, 'Planned', '2015-11-11 00:00:00', NULL),
('524 2 06 31', '524 2 06 31 5 037', 'Makawanpur', 'Kulekhani', 'Plan International', NULL, NULL, NULL, NULL, NULL, 'Planned', '2015-11-11 00:00:00', NULL),
('524 2 05 23', '524 2 05 23 5 054', 'Sindhupalchok', 'Banskharka', 'CARE', 'CARE /CSRC', NULL, NULL, NULL, 'Blankets| Mattress| Tarpaulin| Stoves', 'Planned', '2015-11-11 00:00:00', NULL),
('524 2 05 23', '524 2 05 23 5 070', 'Sindhupalchok', 'Baruwa', 'CARE', 'CARE /CSRC', NULL, NULL, NULL, NULL, 'Planned', '2015-11-11 00:00:00', NULL),
('524 2 05 23', '524 2 05 23 5 069', 'Sindhupalchok', 'Bhotang (Motang)', 'CARE', 'CARE /CSRC', NULL, NULL, NULL, NULL, 'Planned', '2015-11-11 00:00:00', NULL),
('524 2 05 23', '524 2 05 23 5 055', 'Sindhupalchok', 'Duwachaur', 'CARE', 'CARE /CSRC', NULL, NULL, NULL, NULL, 'Planned', '2015-11-11 00:00:00', NULL),
('524 2 05 23', '524 2 05 23 5 076', 'Sindhupalchok', 'Lagarche', 'CARE', 'CARE /CSRC', NULL, NULL, NULL, NULL, 'Planned', '2015-11-11 00:00:00', NULL),
('524 2 05 23', '#N/A', 'Sindhupalchok', NULL, 'CARE', 'CARE /CSRC', NULL, NULL, NULL, NULL, 'Planned', '2015-11-11 00:00:00', NULL),
('524 2 05 23', '524 2 05 23 5 055', 'Sindhupalchok', 'Duwachaur', 'HELVETAS/SOLIDARITIES', 'CDECF', NULL, NULL, NULL, NULL, 'Planned', '2015-11-11 00:00:00', NULL),
('524 2 05 23', '524 2 05 23 5 065', 'Sindhupalchok', 'Helambu', 'HELVETAS/SOLIDARITIES', 'CDECF', NULL, NULL, NULL, NULL, 'Planned', '2015-11-11 00:00:00', NULL),
('524 2 05 23', '524 2 05 23 5 058', 'Sindhupalchok', 'Ichowk', 'HELVETAS/SOLIDARITIES', 'CDECF', NULL, NULL, NULL, NULL, 'Planned', '2015-11-11 00:00:00', NULL),
('524 2 05 23', '524 2 05 23 5 073', 'Sindhupalchok', 'Kiwool', 'HELVETAS/SOLIDARITIES', 'CDECF', NULL, NULL, NULL, NULL, 'Planned', '2015-11-11 00:00:00', NULL),
('524 2 05 23', 'NONE', 'Sindhupalchok', 'Mahankal', 'HELVETAS/SOLIDARITIES', 'CDECF', NULL, NULL, NULL, NULL, 'Planned', '2015-11-11 00:00:00', NULL),
('524 2 05 23', '524 2 05 23 5 061', 'Sindhupalchok', 'Melamchi', 'HELVETAS/SOLIDARITIES', 'CDECF', NULL, NULL, NULL, NULL, 'Planned', '2015-11-11 00:00:00', NULL),
('524 2 05 23', '524 2 05 23 5 056', 'Sindhupalchok', 'Palchowk', 'HELVETAS/SOLIDARITIES', 'CDECF', NULL, NULL, NULL, NULL, 'Planned', '2015-11-11 00:00:00', NULL),
('524 2 05 23', '524 2 05 23 5 060', 'Sindhupalchok', 'Talamarang', 'HELVETAS/SOLIDARITIES', 'CDECF', NULL, NULL, NULL, NULL, 'Planned', '2015-11-11 00:00:00', NULL),
('524 2 05 23', '524 2 05 23 5 012', 'Sindhupalchok', 'Tekanpur', 'Christian Aid', 'Clean Energy Nepal', 422, NULL, NULL, 'Blanket| Tarpaulin| Thermal Floor mat| Floor Bed Foam', 'Planned', '2015-11-11 00:00:00', NULL),
('524 2 05 23', '524 2 05 23 5 025', 'Sindhupalchok', 'Thulopakhar', 'Christian Aid', 'Clean Energy Nepal', 972, NULL, NULL, 'Blanket| Tarpaulin| Thermal Floor mat| Floor Bed Foam', 'Planned', '2015-11-11 00:00:00', NULL),
('524 2 05 23', '524 2 05 23 5 022', 'Sindhupalchok', 'Atarpur', 'Christian Aid', 'Clean Energy Nepal', 464, NULL, NULL, 'Blanket| Tarpaulin| Thermal Floor mat| Floor Bed Foam', 'Planned', '2015-11-11 00:00:00', NULL),
('524 2 05 23', '524 2 05 23 5 027', 'Sindhupalchok', 'Pangretar', 'Christian Aid', 'Clean Energy Nepal', 762, NULL, NULL, 'Blanket| Tarpaulin| Thermal Floor mat| Floor Bed Foam', 'Planned', '2015-11-11 00:00:00', NULL),
('524 2 05 23', 'NONE', 'Sindhupalchok', 'Ramche', 'OXFAM', 'GMSP', 325, NULL, NULL, 'Blanket| Mattress| Tarpaulin| Plastic Sheet| Thermal Floor mats| Solar Lamp| Hot water bottle| rope| IEC Materials', 'Planned', '2015-11-11 00:00:00', NULL),
('524 2 05 23', 'NONE', 'Sindhupalchok', 'Sunkhani', 'OXFAM', 'GMSP', 325, NULL, NULL, NULL, 'Planned', '2015-11-11 00:00:00', NULL),
('524 2 05 23', '524 2 05 23 5 006', 'Sindhupalchok', 'Tatopani', 'OXFAM', 'GMSP', 325, NULL, NULL, NULL, 'Planned', '2015-11-11 00:00:00', NULL),
('524 2 05 23', '524 2 05 23 5 027', 'Sindhupalchok', 'Pangretar', 'OXFAM', 'GMSP', 325, NULL, NULL, NULL, 'Planned', '2015-11-11 00:00:00', NULL),
('524 2 05 23', '524 2 05 23 5 016', 'Sindhupalchok', 'Chokati', 'Phase Nepal| OXFAM', 'GMSP', 300, NULL, NULL, 'Blanket| Mattress| Tarpaulin| Plastic Sheet| Thermal Floor mats| Solar Lamp| Hot water bottle| rope| IEC Materials', 'Planned', '2015-11-11 00:00:00', NULL),
('524 2 05 23', '524 2 05 23 5 007', 'Sindhupalchok', 'Listikot', 'Medair/Mission East', 'Medair', 1300, 'Cash NPR15|000', NULL, NULL, 'Planned', '2015-11-11 00:00:00', NULL),
('524 2 05 23', '524 2 05 23 5 005', 'Sindhupalchok', 'Fulpingkatti', 'Medair/Mission East', 'Medair', 1300, 'Cash NPR15|000', NULL, NULL, 'Planned', '2015-11-11 00:00:00', NULL),
('524 2 05 23', '524 2 05 23 5 003', 'Sindhupalchok', 'Gaati', 'Medair/Mission East', 'Medair', 1300, 'Cash NPR15|000', NULL, NULL, 'Planned', '2015-11-11 00:00:00', NULL),
('524 2 05 23', '524 2 05 23 5 014', 'Sindhupalchok', 'Piskar', 'Medair/Mission East', 'Medair', 1300, 'Cash NPR15|000', NULL, NULL, 'Planned', '2015-11-11 00:00:00', NULL),
('524 2 05 23', '524 2 05 23 5 044', 'Sindhupalchok', 'Badegau', 'PLAN', 'Plan Nepal', 1391, NULL, NULL, 'Clothes| Blankets| Tarpaulins| Floor Bed Foam| Stoves| Solar Lamp', 'Planned', '2015-11-11 00:00:00', NULL),
('524 2 05 23', '524 2 05 23 5 033', 'Sindhupalchok', 'Batase', 'PLAN', 'Plan Nepal', 1355, NULL, NULL, NULL, 'Planned', '2015-11-11 00:00:00', NULL),
('524 2 05 23', '524 2 05 23 5 077', 'Sindhupalchok', 'Bhotenamlang', 'PLAN', 'Plan Nepal', 1332, NULL, NULL, NULL, 'Planned', '2015-11-11 00:00:00', NULL),
('524 2 05 23', '524 2 05 23 5 043', 'Sindhupalchok', 'Bhotsipa', 'PLAN', 'Plan Nepal', 1294, NULL, NULL, NULL, 'Planned', '2015-11-11 00:00:00', NULL),
('524 2 05 23', '524 2 05 23 5 075', 'Sindhupalchok', 'Jyamire', 'PLAN', 'Plan Nepal', 1199, NULL, NULL, NULL, 'Planned', '2015-11-11 00:00:00', NULL),
('524 2 05 23', '524 2 05 23 5 046', 'Sindhupalchok', 'Kunchowk', 'PLAN', 'Plan Nepal', 1332, NULL, NULL, NULL, 'Planned', '2015-11-11 00:00:00', NULL),
('524 2 05 23', '524 2 05 23 5 076', 'Sindhupalchok', 'Lagarche', 'PLAN', 'Plan Nepal', 1190, NULL, NULL, NULL, 'Planned', '2015-11-11 00:00:00', NULL),
('524 2 05 23', '524 2 05 23 5 048', 'Sindhupalchok', 'Nawalpur', 'PLAN', 'Plan Nepal', 1101, NULL, NULL, NULL, 'Planned', '2015-11-11 00:00:00', NULL),
('524 2 06 31', '524 2 06 31 5 014', 'Sindhupalchok', 'Shikharpur', 'PLAN', 'Plan Nepal', 843, NULL, NULL, NULL, 'Planned', '2015-11-11 00:00:00', NULL),
('524 2 05 23', '524 2 05 23 5 047', 'Sindhupalchok', 'Simpalkavre', 'PLAN', 'Plan Nepal', 1074, NULL, NULL, NULL, 'Planned', '2015-11-11 00:00:00', NULL),
('524 2 05 23', '524 2 05 23 5 034', 'Sindhupalchok', 'Syaule', 'PLAN', 'Plan Nepal', 1240, NULL, NULL, NULL, 'Planned', '2015-11-11 00:00:00', NULL),
('524 2 05 23', '524 2 05 23 5 066', 'Sindhupalchok', 'Bansbari', 'Save the Children', 'TUKI & HURADEC', 0, NULL, NULL, NULL, 'Planned', '2015-11-11 00:00:00', NULL),
('524 2 05 23', '524 2 05 23 5 031', 'Sindhupalchok', 'Golche', 'Save the Children', 'TUKI & HURADEC', 915, NULL, NULL, NULL, 'Planned', '2015-11-11 00:00:00', NULL),
('524 2 05 23', '524 2 05 23 5 057', 'Sindhupalchok', 'Gumba', 'Save the Children', 'TUKI & HURADEC', 542, NULL, NULL, NULL, 'Planned', '2015-11-11 00:00:00', NULL),
('524 2 05 23', '524 2 05 23 5 029', 'Sindhupalchok', 'Mankha', 'Save the Children', 'TUKI & HURADEC', 750, NULL, NULL, NULL, 'Planned', '2015-11-11 00:00:00', NULL),
('524 2 05 23', '524 2 05 23 5 067', 'Sindhupalchok', 'Gunsa (Gunsakot)', 'IOM', 'ARSOW Nepal', 120, NULL, NULL, NULL, 'Planned', '2015-11-11 00:00:00', NULL),
('524 2 05 23', '524 2 05 23 5 064', 'Sindhupalchok', 'Thangpalchap (Ghuyang)', 'IOM', 'ARSOW Nepal', 204, NULL, NULL, NULL, 'Planned', '2015-11-11 00:00:00', NULL),
('524 2 05 23', '524 2 05 23 5 068', 'Sindhupalchok', 'Thangpalkot', 'IOM', 'ARSOW Nepal', 726, NULL, NULL, NULL, 'Planned', '2015-11-11 00:00:00', NULL),
('524 2 05 23', '524 2 05 23 5 053', 'Sindhupalchok', 'Baramchi', 'Phase Nepal', NULL, NULL, NULL, NULL, NULL, 'Planned', '2015-11-11 00:00:00', NULL),
('524 2 05 23', '524 2 05 23 5 049', 'Sindhupalchok', 'Fulpingkot', 'Phase Nepal', NULL, NULL, NULL, NULL, NULL, 'Planned', '2015-11-11 00:00:00', NULL),
('524 2 05 23', '524 2 05 23 5 031', 'Sindhupalchok', 'Golche', 'Phase Nepal', NULL, NULL, NULL, NULL, NULL, 'Planned', '2015-11-11 00:00:00', NULL),
('524 2 05 23', '524 2 05 23 5 057', 'Sindhupalchok', 'Gumba', 'Phase Nepal', NULL, NULL, NULL, NULL, NULL, 'Planned', '2015-11-11 00:00:00', NULL),
('524 2 05 23', '524 2 05 23 5 051', 'Sindhupalchok', 'Hagam', 'Phase Nepal', NULL, NULL, NULL, NULL, NULL, 'Planned', '2015-11-11 00:00:00', NULL),
('524 2 05 23', '524 2 05 23 5 050', 'Sindhupalchok', 'Jalbire', 'Phase Nepal', NULL, NULL, NULL, NULL, NULL, 'Planned', '2015-11-11 00:00:00', NULL),
('524 2 05 23', '524 2 05 23 5 013', 'Sindhupalchok', 'Tauthali', 'Phase Nepal', NULL, NULL, NULL, NULL, NULL, 'Planned', '2015-11-11 00:00:00', NULL),
('524 2 05 23', '524 2 05 23 5 015', 'Sindhupalchok', 'Dhuskun (Ghuskun)', 'PIN', NULL, NULL, NULL, 'Yes', NULL, 'Planned', '2015-11-11 00:00:00', NULL),
('524 2 05 23', '524 2 05 23 5 072', 'Sindhupalchok', 'Pangtang', 'PIN/Phase Nepal', NULL, NULL, NULL, 'Yes', NULL, 'Planned', '2015-11-11 00:00:00', NULL),
('524 2 05 23', '524 2 05 23 5 032', 'Sindhupalchok', 'Selang', 'PIN/Phase Nepal', NULL, NULL, NULL, NULL, NULL, 'Planned', '2015-11-11 00:00:00', NULL),
('524 2 04 22', '524 2 04 22 5 022', 'Dolakha', 'Kabre', 'IOM/ACTED', 'ACTED', 42, NULL, NULL, 'Blanket| Solar Lamp| Clothes', 'Ongoing', '2015-11-11 00:00:00', NULL),
('524 2 04 22', '#N/A', 'Dolakha', 'Khare', 'ACTED', 'ACTED', 869, 'In kind', NULL, 'Blanket| Solar Lamp| Clothes', 'Ongoing', '2015-11-11 00:00:00', NULL),
('524 2 04 22', '#N/A', 'Dolakha', 'Suri', 'ACTED', 'ACTED', 801, 'In kind', NULL, 'Blanket| Cooking stoves| clothes', 'Ongoing', '2015-11-11 00:00:00', NULL),
('524 2 04 22', '#N/A', 'Dolakha', 'Chilankha', 'Christian Aid', NULL, 611, NULL, NULL, 'Blanket', 'Planned', '2015-11-11 00:00:00', NULL),
('524 2 04 22', '#N/A', 'Dolakha', NULL, 'IOM', NULL, NULL, NULL, NULL, NULL, 'Planned', '2015-11-11 00:00:00', NULL),
('524 2 04 22', '#N/A', 'Dolakha', NULL, 'IOM', NULL, NULL, NULL, NULL, NULL, 'Planned', '2015-11-11 00:00:00', NULL),
('524 2 04 22', '#N/A', 'Dolakha', NULL, 'IOM', NULL, NULL, NULL, NULL, NULL, 'Planned', '2015-11-11 00:00:00', NULL),
('524 2 04 22', '#N/A', 'Dolakha', NULL, 'IOM', NULL, NULL, NULL, NULL, NULL, 'Planned', '2015-11-11 00:00:00', NULL),
('524 2 04 22', '#N/A', 'Dolakha', NULL, 'IOM', NULL, NULL, NULL, NULL, NULL, 'Planned', '2015-11-11 00:00:00', NULL),
('524 2 04 22', '524 2 04 22 5 035', 'Dolakha', 'Lamidanda', 'IOM', NULL, 1384, NULL, NULL, NULL, 'Planned', '2015-11-11 00:00:00', NULL),
('524 2 04 22', '#N/A', 'Dolakha', NULL, 'IOM', NULL, NULL, NULL, NULL, NULL, 'Planned', '2015-11-11 00:00:00', NULL),
('524 2 04 22', '524 2 04 22 5 039', 'Dolakha', 'Bigu', 'Plan International', NULL, 661, NULL, NULL, 'Clothes| Blankets| Tarpaulins| Floor Bed Foam| Stoves| Solar Lamp| Ropes', 'Planned', '2015-11-11 00:00:00', NULL),
('524 2 04 22', '524 2 04 22 5 026', 'Dolakha', 'Ghyangsukathokar', 'Plan International', NULL, 1345, NULL, NULL, 'Blankets| Mattress', 'Planned', '2015-11-11 00:00:00', NULL),
('524 2 04 22', '524 2 04 22 5 041', 'Dolakha', 'Kalinchowk', 'Plan International', NULL, 627, NULL, NULL, 'Clothes| Blankets| Tarpaulins| Floor Bed Foam| Stoves| Ropes', 'Planned', '2015-11-11 00:00:00', NULL),
('524 2 04 22', '524 2 04 22 5 042', 'Dolakha', 'Khopachangu', 'Plan International', NULL, 610, NULL, NULL, 'Clothes| Blankets| Tarpaulins| Floor Bed Foam| Stoves| Ropes', 'Planned', '2015-11-11 00:00:00', NULL),
('524 2 04 22', '524 2 04 22 5 050', 'Dolakha', 'Shailungeshwor', 'Plan International', NULL, 1223, NULL, NULL, 'Blankets| Mattress', 'Planned', '2015-11-11 00:00:00', NULL),
('524 2 04 22', '524 2 04 22 5 044', 'Dolakha', 'Tamchet Dudhpokhari', 'Plan International', NULL, 776, NULL, NULL, 'Blankets| Mattress', 'Planned', '2015-11-11 00:00:00', NULL),
('524 2 04 22', '#N/A', 'Dolakha', NULL, 'Plan International', NULL, NULL, NULL, NULL, NULL, 'Planned', '2015-11-11 00:00:00', NULL),
('524 2 04 22', '#N/A', 'Dolakha', NULL, 'Plan International', NULL, NULL, NULL, NULL, NULL, 'Planned', '2015-11-11 00:00:00', NULL),
('524 2 04 22', '#N/A', 'Dolakha', NULL, 'Plan International', NULL, 1301, NULL, NULL, NULL, 'Planned', '2015-11-11 00:00:00', NULL),
('524 2 04 22', '#N/A', 'Dolakha', NULL, 'Plan International', NULL, 576, NULL, NULL, NULL, 'Planned', '2015-11-11 00:00:00', NULL),
('524 2 04 22', '524 2 04 22 5 051', 'Dolakha', 'Bulung', 'Plan International', NULL, 699, NULL, NULL, 'Above 1500 households receive clothing (for 5 people)| foam sheets for bedding and flooring| and blankets (value £57). Affected households above 2|000 metres receive clothing (for 5 people)| foam sheets for bedding and flooring| blankets| solar lamps and wood stoves (value (£99).', 'Planned', '2015-11-11 00:00:00', NULL),
('524 2 04 22', '524 2 04 22 5 021', 'Dolakha', 'Gaurishankar', 'Plan International', NULL, 469, NULL, NULL, NULL, 'Planned', '2015-11-11 00:00:00', NULL),
('524 2 04 22', '524 2 04 22 5 027', 'Dolakha', 'Lama Bagar', 'Plan International', NULL, 573, NULL, NULL, NULL, 'Planned', '2015-11-11 00:00:00', NULL),
('524 2 04 22', '524 2 04 22 5 023', 'Dolakha', 'Marbu', 'Plan International', NULL, 567, NULL, NULL, NULL, 'Planned', '2015-11-11 00:00:00', NULL),
('524 2 04 22', '524 2 04 22 5 022', 'Dolakha', 'Khare', 'Plan International', NULL, 785, NULL, NULL, NULL, 'Planned', '2015-11-11 00:00:00', NULL),
('524 2 04 22', '524 2 04 22 5 033', 'Dolakha', 'Sushpakshamawati', 'Plan International', NULL, 1122, NULL, NULL, NULL, 'Planned', '2015-11-11 00:00:00', NULL),
('524 2 04 22', '524 2 04 22 5 020', 'Dolakha', 'Pawati', 'Plan International', NULL, 1512, NULL, NULL, NULL, 'Planned', '2015-11-11 00:00:00', NULL),
('524 2 04 22', '524 2 04 22 5 046', 'Dolakha', 'Magapauwa', 'Plan International', NULL, 923, NULL, NULL, NULL, 'Planned', '2015-11-11 00:00:00', NULL),
('524 2 04 22', '524 2 04 22 5 028', 'Dolakha', 'Boch', 'Plan International', NULL, 1087, NULL, NULL, NULL, 'Planned', '2015-11-11 00:00:00', NULL),
('524 2 04 22', '#N/A', 'Dolakha', NULL, 'Plan International', NULL, NULL, NULL, NULL, NULL, 'Planned', '2015-11-11 00:00:00', NULL),
('524 2 04 22', '524 2 04 22 5 033', 'Dolakha', 'Sushpakshamawati', 'Samaritans Purse', NULL, 1122, NULL, NULL, 'Blanket', 'Planned', '2015-11-11 00:00:00', NULL),
('524 2 04 22', '524 2 04 22 5 009', 'Dolakha', 'Jhyaku', 'Save the Children', NULL, 1357, 'Voucher- USD 126', NULL, NULL, 'Planned', '2015-11-11 00:00:00', NULL),
('524 2 04 22', '524 2 04 22 5 010', 'Dolakha', 'Jugu', 'Save the Children', NULL, 1115, 'Voucher- USD 126', NULL, NULL, 'Planned', '2015-11-11 00:00:00', NULL),
('524 2 04 22', '#N/A', 'Dolakha', NULL, 'Save the Children', NULL, NULL, 'Voucher- USD 126', NULL, NULL, 'Planned', '2015-11-11 00:00:00', NULL),
('524 2 04 22', '#N/A', 'Dolakha', NULL, 'Save the Children', NULL, NULL, 'Voucher- USD 126', NULL, NULL, 'Planned', '2015-11-11 00:00:00', NULL),
('524 2 04 22', '#N/A', 'Dolakha', NULL, 'Save the Children', NULL, NULL, 'Voucher- USD 126', NULL, NULL, 'Planned', '2015-11-11 00:00:00', NULL),
('524 2 04 22', '#N/A', 'Dolakha', NULL, 'Save the Children', NULL, NULL, 'Voucher- USD 126', NULL, NULL, 'Planned', '2015-11-11 00:00:00', NULL),
('524 2 04 22', '524 2 04 22 5 021', 'Dolakha', 'Gaurishankar', 'Save the Children', NULL, 469, NULL, NULL, NULL, 'Planned', '2015-11-11 00:00:00', NULL),
('524 2 04 22', '524 2 04 22 5 027', 'Dolakha', 'Lamabagar', 'Save the Children', NULL, 573, NULL, NULL, NULL, 'Planned', '2015-11-11 00:00:00', NULL),
('524 2 04 22', '524 2 04 22 5 034', 'Dolakha', 'Babare', 'Samaritans Purse', 'United Vision Nepal', 1077, NULL, NULL, 'Blanket| Tarpaulin| Floor bed Foam| Stoves| Solar Lamp', 'Planned', '2015-11-11 00:00:00', NULL),
('524 2 04 22', '524 2 04 22 5 036', 'Dolakha', 'Lapilang', 'Samaritans Purse', 'United Vision Nepal', 1442, NULL, NULL, NULL, 'Planned', '2015-11-11 00:00:00', NULL),
('524 2 04 22', '#N/A', 'Dolakha', 'Chilangkha', 'Samaritans Purse', 'United Vision Nepal', 872, NULL, NULL, NULL, 'Planned', '2015-11-11 00:00:00', NULL),
('524 2 04 22', NULL, 'Dolakha', 'Bhimeshwor Municipality', 'ACTED', 'ACTED', 42, 'In kind', NULL, 'Blanket| Solar Lamp| Clothes', 'Ongoing', '2015-11-11 00:00:00', NULL),
('524 1 03 13', '524 1 03 13 5 055', 'Okhaldhunga', 'Khijikaanti', 'ACTED', 'ACTED', 314, 'In kind', NULL, 'Blanket| Solar Lamp| Clothes', 'Planned', '2015-11-11 00:00:00', NULL),
('524 1 03 13', '524 1 03 13 5 025', 'Okhaldhunga', 'Khijichandeshwori', 'ACTED', 'ACTED', 147, 'In kind', NULL, 'Blanket| Solar Lamp| Clothes', 'Planned', '2015-11-11 00:00:00', NULL),
('524 1 03 13', '524 1 03 13 5 027', 'Okhaldhunga', 'Rawadol', 'ACTED', 'ACTED', 137, 'In kind', NULL, 'Blanket| Solar Lamp| Clothes', 'Planned', '2015-11-11 00:00:00', 'In okhaldhunga| ACTED is covering total 2274 HHs in 7 VDCs. As the VDC level data was not there| we have divided 2274/7'),
('524 1 03 13', '524 1 03 13 5 023', 'Okhaldhunga', 'Bhushanga', 'ACTED', 'ACTED', 248, 'In kind', NULL, 'Blanket|Solar Lamp| Clothes', 'Planned', '2015-11-11 00:00:00', NULL),
('524 1 03 13', '524 1 03 13 5 026', 'Okhaldhunga', 'Ragani', 'ACTED', 'ACTED', 741, 'In kind', NULL, 'Blanket|Solar Lamp| Clothes', 'Planned', '2015-11-11 00:00:00', NULL),
('524 1 03 13', '524 1 03 13 5 022', 'Okhaldhunga', 'Shrichaor', 'ACTED', 'ACTED', 469, 'In kind', NULL, 'Blanket|Solar Lamp| Clothes', 'Ongoing', '2015-11-11 00:00:00', NULL),
('524 1 03 13', '524 1 03 13 5 024', 'Okhaldhunga', 'Khijiflate', 'ACTED', 'ACTED', 218, 'In kind', NULL, 'Blanket|Solar Lamp| Clothes', 'Ongoing', '2015-11-11 00:00:00', NULL),
('524 2 04 21', '524 2 04 21 5 015', 'Ramechhap', 'Gupteshwar', 'ACTED', 'ACTED', 413, 'In kind', NULL, 'Blanket|Solar Lamp| Clothes', 'Planned', '2015-11-11 00:00:00', 'In Ramechhap| ACTED is covering total 1010 HHS in 2 VDCs. As the VDC level data was not available so we divided 1010/2.'),
('524 2 04 21', '524 2 04 21 5 011', 'Ramechhap', 'Bhuji', 'ACTED', 'ACTED', 597, 'In kind', NULL, 'Blanket| Solar Lamp| Clothes', 'Planned', '2015-11-11 00:00:00', NULL),
('524 2 05 29', 'NONE', 'Rasuwa', 'Bhamti', 'GOAL', 'CDS', 370, NULL, NULL, 'Blanket| Tarpaulin| Plastic Sheet| Stoves| Solar Lamp| Rope', 'Ongoing', '2015-11-11 00:00:00', NULL),
('524 2 05 29', 'NONE', 'Rasuwa', 'Chuchure', 'GOAL', 'CDS', 300, NULL, NULL, NULL, 'Ongoing', '2015-11-11 00:00:00', NULL),
('524 2 05 29', 'NONE', 'Rasuwa', 'Gumdel', 'GOAL', 'CDS', 250, NULL, NULL, NULL, 'Ongoing', '2015-11-11 00:00:00', NULL),
('524 2 05 29', '524 2 05 29 5 002', 'Rasuwa', 'Dhunche', 'GOAL', 'Umbrella Organisation', 400, NULL, NULL, NULL, 'Ongoing', '2015-11-11 00:00:00', NULL),
('524 2 05 29', '524 2 05 29 5 011', 'Rasuwa', 'Gatlang', 'GOAL', 'Umbrella Organisation', 400, NULL, NULL, NULL, 'Ongoing', '2015-11-11 00:00:00', NULL),
('524 2 05 29', '524 2 05 29 5 017', 'Rasuwa', 'Syaphru', 'GOAL', 'Umbrella Organisation', 400, NULL, NULL, NULL, 'Ongoing', '2015-11-11 00:00:00', NULL),
('524 2 05 29', '524 2 05 29 5 009', 'Rasuwa', 'Danda Gaun IDPs', 'ASIA', 'NAF', 188, NULL, NULL, 'Blanket| Mattress| Floor Bed Foam| Solar Light| Bamboo| Plain wood', 'Ongoing', '2015-11-11 00:00:00', NULL),
('524 2 05 29', '524 2 05 29 5 001', 'Rasuwa', 'Haku IDPs', 'ASIA', 'NAF', 337, NULL, NULL, 'Blanket| Mattress| Floor Bed Foam| Stove| Solar Light| Bamboo| Plain wood| Gas Cylinder', 'Ongoing', '2015-11-11 00:00:00', NULL),
('524 2 05 29', '524 2 05 29 5 004', 'Rasuwa', 'Saramthali', 'ASIA', 'NAF', 1015, NULL, NULL, 'Blanket', 'Ongoing', '2015-11-11 00:00:00', NULL),
('524 2 05 29', '524 2 05 29 5 003', 'Rasuwa', 'Yarsa', 'ASIA', 'NAF', 571, NULL, NULL, 'Blanket', 'Ongoing', '2015-11-11 00:00:00', NULL),
('524 2 05 29', '524 2 05 29 5 005', 'Rasuwa', 'Bhorle', 'CSRC', 'CSRC', 1486, NULL, NULL, 'Blanket', 'Ongoing', '2015-11-11 00:00:00', NULL),
('524 2 05 29', '524 2 05 29 5 006', 'Rasuwa', 'Dhaibung', 'CSRC', 'CSRC', 1422, NULL, NULL, 'Blanket', 'Ongoing', '2015-11-11 00:00:00', NULL),
('524 2 05 29', '524 2 05 29 5 001', 'Rasuwa', 'Haku', 'CSRC', 'CSRC', 765, NULL, NULL, 'Blanket', 'Ongoing', '2015-11-11 00:00:00', NULL),
('524 2 05 29', '524 2 05 29 5 007', 'Rasuwa', 'Laharepauwa', 'CSRC', 'CSRC', 1526, NULL, NULL, 'Blanket', 'Ongoing', '2015-11-11 00:00:00', NULL),
('524 2 05 29', '524 2 05 29 5 001', 'Rasuwa', 'Haku', 'Om Nepal', NULL, NULL, NULL, NULL, NULL, 'Ongoing', '2015-11-11 00:00:00', NULL),
('524 2 05 29', '524 2 05 29 5 015', 'Rasuwa', 'Lagtang', 'Om Nepal', NULL, NULL, NULL, NULL, NULL, 'Ongoing', '2015-11-11 00:00:00', NULL),
('524 2 05 29', '524 2 05 29 5 009', 'Rasuwa', 'Dandagau', 'German GIZ', NULL, 654, NULL, NULL, 'Blanket| Thermal Floor mats', 'Ongoing', '2015-11-11 00:00:00', NULL),
('524 2 05 29', '524 2 05 29 5 017', 'Rasuwa', 'Syaphru', 'German GIZ', NULL, 600, NULL, NULL, 'Thermal Floor mats', 'Ongoing', '2015-11-11 00:00:00', NULL),
('524 2 05 29', '524 2 05 29 5 018', 'Rasuwa', 'Goljung', 'LWF', NULL, 422, 'Voucher- link the beneficiaries with local venders + in kind', 'Yes', 'voucher NPR 3500 Inkind- Blanket-2| mattress-2| tarp-1| plastic sheet-1', 'Planned', '2015-11-11 00:00:00', NULL),
('524 2 05 29', '524 2 05 29 5 003', 'Rasuwa', 'Yarsa', 'LWF', NULL, 422, 'Voucher- link the beneficiaries with local venders +in kind', 'Yes', NULL, 'Planned', '2015-11-11 00:00:00', NULL),
('524 2 05 29', '524 2 05 29 5 012', 'Rasuwa', 'Chilime', 'LWF', NULL, 422, 'Voucher- link the beneficiaries with local venders +in kind', 'Yes', NULL, 'Planned', '2015-11-11 00:00:00', NULL),
('524 2 05 28', '524 2 05 28 5 022', 'Nuwakot', 'Beteni', 'OXFAM', NULL, 573, NULL, NULL, 'Blanket| Mattress| Tarpaulin| Plastic Sheet| Thermal Floor mats| Hot water bottle| rope| Gaff/Duct Tape| Floor Bed Foam', 'Planned', '2015-11-11 00:00:00', NULL),
('524 2 05 28', '524 2 05 28 5 044', 'Nuwakot', 'Budhasing', 'OXFAM', NULL, 573, NULL, NULL, NULL, 'Planned', '2015-11-11 00:00:00', NULL),
('524 2 05 28', '524 2 05 28 5 048', 'Nuwakot', 'Khadga Bhanjyang', 'OXFAM', NULL, 573, NULL, NULL, NULL, 'Planned', '2015-11-11 00:00:00', NULL),
('524 2 05 28', '524 2 05 28 5 012', 'Nuwakot', 'Madanpur', 'OXFAM', NULL, 573, NULL, NULL, NULL, 'Planned', '2015-11-11 00:00:00', NULL),
('524 2 05 28', '524 2 05 28 5 025', 'Nuwakot', 'Rautbesi', 'OXFAM', NULL, 573, NULL, NULL, NULL, 'Planned', '2015-11-11 00:00:00', NULL),
('524 2 05 28', '524 2 05 28 5 055', 'Nuwakot', 'Samari', 'OXFAM', NULL, 573, NULL, NULL, NULL, 'Planned', '2015-11-11 00:00:00', NULL),
('524 2 05 28', '524 2 05 28 5 016', 'Nuwakot', 'Samudradevi Kholegaun', 'OXFAM', NULL, 573, NULL, NULL, NULL, 'Planned', '2015-11-11 00:00:00', NULL),
('524 2 05 28', '524 2 05 28 5 026', 'Nuwakot', 'Thaprek', 'OXFAM', NULL, 573, NULL, NULL, NULL, 'Planned', '2015-11-11 00:00:00', NULL),
('524 2 05 28', '524 2 05 28 5 019', 'Nuwakot', 'Sikre', 'German GIZ', NULL, 525, NULL, NULL, 'Blanket| Mattress', 'Planned', '2015-11-11 00:00:00', NULL),
('524 2 05 28', '524 2 05 28 5 032', 'Nuwakot', 'Samundratar', 'German GIZ', NULL, 550, NULL, NULL, 'Blanket| Mattress', 'Planned', '2015-11-11 00:00:00', NULL),
('524 2 05 30', '524 2 05 30 5 047', 'Dhading', 'Chhatredeurali', 'ADRA Nepal', 'RIMS Nepal', 310, 'In Kind', NULL, 'Blankets and sleeping mats', 'Ongoing', '2015-11-11 00:00:00', NULL),
('524 2 05 30', '524 2 05 30 5 031', 'Dhading', 'Kalleri', 'ADRA Nepal', 'RIMS Nepal', 320, 'In Kind', NULL, 'Blankets and sleeping mats', 'Ongoing', '2015-11-11 00:00:00', NULL),
('524 2 05 30', '524 2 05 30 5 032', 'Dhading', 'Khalte', 'ADRA Nepal', 'RIMS Nepal', 405, 'IN Kind', NULL, 'Blankets and sleeping mats', 'Ongoing', '2015-11-11 00:00:00', NULL),
('524 2 05 30', '524 2 05 30 5 033', 'Dhading', 'Kumpur', 'ADRA Nepal', 'RIMS Nepal', 765, NULL, NULL, 'Blankets and sleeping mats', 'Ongoing', '2015-11-11 00:00:00', NULL),
('524 2 05 30', '524 2 05 30 5 012', 'Dhading', 'Mulpani', 'CARE', NULL, 811, NULL, NULL, 'Blanket-5| mattress-2| kitchen set-1', 'Completed', '2015-11-11 00:00:00', NULL),
('524 2 05 30', '524 2 05 30 5 010', 'Dhading', 'Budhathum', 'CARE', NULL, 1032, NULL, NULL, 'Blanket-5| mattress-2| kitchen set-1', 'Completed', '2015-11-11 00:00:00', NULL),
('524 2 05 30', '524 2 05 30 5 008', 'Dhading', 'Salyantar', 'Care International', NULL, NULL, NULL, NULL, NULL, 'Ongoing', '2015-11-11 00:00:00', NULL),
('524 2 05 30', '524 2 05 30 5 006', 'Dhading', 'Aginchok', 'Christian Aid', 'Focus Nepal', 1072, NULL, NULL, 'Blanket| Tarpaulin| Thermal Floor mat', 'Planned', '2015-11-11 00:00:00', NULL),
('524 2 05 30', '524 2 05 30 5 048', 'Dhading', 'Jeewanpur', 'Christian Aid', 'Focus Nepal', 500, NULL, NULL, 'Blanket| Tarpaulin| Thermal Floor mat', 'Planned', '2015-11-11 00:00:00', NULL),
('524 2 05 30', '524 2 05 30 5 023', 'Dhading', 'Jyamrung', 'Christian Aid', 'Focus Nepal', 1000, NULL, NULL, 'Blanket| Tarpaulin| Thermal Floor mat', 'Planned', '2015-11-11 00:00:00', NULL),
('524 2 05 30', '524 2 05 30 5 048', 'Dhading', 'Jeewanpur', 'German GIZ', 'Lumanti', 1500, NULL, NULL, 'Blanket| Mattress', 'Ongoing', '2015-11-11 00:00:00', NULL),
('524 2 05 30', '524 2 05 30 5 019', 'Dhading', 'Semjong', 'German GIZ', 'Lumanti', 1500, NULL, NULL, 'Blanket| Mattress', 'Ongoing', '2015-11-11 00:00:00', NULL),
('524 2 05 30', '524 2 05 30 5 004', 'Dhading', 'Satyadevi', 'Oxfam', 'Cosoc', 1000, NULL, NULL, 'Blanket| Mattress| Tarpaulin| Plastic Sheet| Thermal Floor mats| Solar Lamp| Hot water bottle| rope', 'Ongoing', '2015-11-11 00:00:00', NULL),
('524 2 05 30', '524 2 05 30 5 015', 'Dhading', 'Tripureswor', 'Oxfam', 'Cosoc', 1000, NULL, NULL, NULL, 'Ongoing', '2015-11-11 00:00:00', NULL),
('524 2 05 30', '524 2 05 30 5 016', 'Dhading', 'Jharlang', 'United Mission Nepal (UMN)', NULL, NULL, NULL, NULL, NULL, 'Ongoing', '2015-11-11 00:00:00', NULL),
('524 2 05 30', '524 2 05 30 5 017', 'Dhading', 'Lapa', 'United Mission Nepal (UMN)', NULL, NULL, NULL, NULL, NULL, 'Ongoing', '2015-11-11 00:00:00', NULL),
('524 2 05 30', '524 2 05 30 5 040', 'Dhading', 'Mahadevsthan', 'United Mission Nepal (UMN)', NULL, NULL, NULL, NULL, NULL, 'Ongoing', '2015-11-11 00:00:00', NULL),
('524 2 05 30', '524 2 05 30 5 045', 'Dhading', 'Pida', 'United Mission Nepal (UMN)', NULL, NULL, NULL, NULL, NULL, 'Ongoing', '2015-11-11 00:00:00', NULL),
('524 2 05 30', '524 2 05 30 5 018', 'Dhading', 'Ree Gaun', 'United Mission Nepal (UMN)', NULL, NULL, NULL, NULL, NULL, 'Ongoing', '2015-11-11 00:00:00', NULL),
('524 2 05 27', '524 2 05 27 5 054', 'Kathmandu', 'Dakshinkali', 'OXFAM', NULL, 36, NULL, NULL, NULL, 'Planned', '2015-11-11 00:00:00', NULL),
('524 2 05 27', '524 2 05 27 1 001', 'Kathmandu', 'Kathmandu Metropolitan', 'OXFAM', NULL, 36, NULL, NULL, NULL, 'Planned', '2015-11-11 00:00:00', NULL),
('524 2 05 27', '524 2 05 27 3 002', 'Kathmandu', 'Kirtipur Municipality', 'OXFAM', NULL, 36, NULL, NULL, NULL, 'Planned', '2015-11-11 00:00:00', NULL),
('524 2 05 24', '524 2 05 24 5 015', 'Kathmandu', 'Machchhegaun', 'OXFAM', NULL, 36, NULL, NULL, NULL, 'Planned', '2015-11-11 00:00:00', NULL),
('524 2 05 27', '524 2 05 27 5 038', 'Kathmandu', 'Ramkot', 'OXFAM', NULL, 36, NULL, NULL, NULL, 'Planned', '2015-11-11 00:00:00', NULL),
('524 2 05 27', '524 2 05 27 5 041', 'Kathmandu', 'Syuchatar', 'OXFAM', NULL, 36, NULL, NULL, NULL, 'Planned', '2015-11-11 00:00:00', NULL),
('524 2 05 27', '524 2 05 27 5 044', 'Kathmandu', 'Thankot', 'OXFAM', NULL, 36, NULL, NULL, NULL, 'Planned', '2015-11-11 00:00:00', NULL),
('524 2 05 26', '524 2 05 26 5 013', 'Bhaktapur', 'Gundu', 'OXFAM', NULL, 27, NULL, NULL, NULL, 'Planned', '2015-11-11 00:00:00', NULL),
('524 2 05 26', '524 2 05 26 5 008', 'Bhaktapur', 'Jhaukhel', 'OXFAM', NULL, 27, NULL, NULL, NULL, 'Planned', '2015-11-11 00:00:00', NULL),
('524 2 05 26', '524 2 05 26 3 002', 'Bhaktapur', 'Madhyapur Thimi Municipality', 'OXFAM', NULL, 27, NULL, NULL, NULL, 'Planned', '2015-11-11 00:00:00', NULL),
('524 2 05 26', '524 2 05 26 5 004', 'Bhaktapur', 'Nagarkot', 'OXFAM', NULL, 27, NULL, NULL, NULL, 'Planned', '2015-11-11 00:00:00', NULL),
('524 2 05 26', '524 2 05 26 5 002', 'Bhaktapur', 'Sudal', 'OXFAM', NULL, 27, NULL, NULL, NULL, 'Planned', '2015-11-11 00:00:00', NULL),
('524 2 05 25', '524 2 05 25 5 005', 'Lalitpur', 'Khumaltar', 'OXFAM', NULL, 17, NULL, NULL, NULL, 'Planned', '2015-11-11 00:00:00', NULL),
('524 2 05 25', '524 2 05 25 5 021', 'Lalitpur', 'Chhampi', 'OXFAM', NULL, 17, NULL, NULL, NULL, 'Planned', '2015-11-11 00:00:00', NULL),
('524 2 05 25', '524 2 05 25 5 017', 'Lalitpur', 'Gotikhel', 'OXFAM', NULL, 17, NULL, NULL, NULL, 'Planned', '2015-11-11 00:00:00', NULL),
('524 2 05 25', '524 2 05 25 5 011', 'Lalitpur', 'Ikudol', 'OXFAM', NULL, 17, NULL, NULL, NULL, 'Planned', '2015-11-11 00:00:00', NULL),
('524 2 05 25', '524 2 05 25 5 032', 'Lalitpur', 'Imadol', 'OXFAM', NULL, 17, NULL, NULL, NULL, 'Planned', '2015-11-11 00:00:00', NULL),
('524 2 05 25', '524 2 05 25 2 001', 'Lalitpur', 'Lalitpur Sub Metropolitan', 'OXFAM', NULL, 17, NULL, NULL, NULL, 'Planned', '2015-11-11 00:00:00', NULL),
('524 2 05 25', '524 2 05 25 5 028', 'Lalitpur', 'Lamatar', 'OXFAM', NULL, 17, NULL, NULL, NULL, 'Planned', '2015-11-11 00:00:00', NULL),
('524 2 05 25', '524 2 05 25 5 029', 'Lalitpur', 'Lubhu', 'OXFAM', NULL, 17, NULL, NULL, NULL, 'Planned', '2015-11-11 00:00:00', NULL),
('524 2 05 25', '524 2 05 25 5 031', 'Lalitpur', 'Siddhipur', 'OXFAM', NULL, 17, NULL, NULL, NULL, 'Planned', '2015-11-11 00:00:00', NULL),
('524 2 05 25', '524 2 05 25 5 019', 'Lalitpur', 'Thuladurlung', 'OXFAM', NULL, 17, NULL, NULL, NULL, 'Planned', '2015-11-11 00:00:00', NULL),
('524 2 05 24', '524 2 05 24 5 013', 'Kabhrepalanchok', 'Kanpur Kalapani', 'News club of Nepal', NULL, 228, NULL, NULL, 'Blankets', 'Planned', '2015-11-11 00:00:00', NULL),
('524 2 05 24', '524 2 05 24 5 012', 'Kabhrepalanchok', 'Kuruwas Chapakhori', 'News club of Nepal', NULL, 215, NULL, NULL, NULL, 'Planned', '2015-11-11 00:00:00', NULL),
('524 2 05 24', '524 2 05 24 5 017', 'Kabhrepalanchok', 'Pokhari Narayansthan', 'News club of Nepal', NULL, 127, NULL, NULL, NULL, 'Planned', '2015-11-11 00:00:00', NULL),
('524 2 05 24', '524 2 05 24 5 080', 'Kabhrepalanchok', 'Kashikhanda', 'News club of Nepal', NULL, 5514, NULL, NULL, NULL, 'Planned', '2015-11-11 00:00:00', NULL),
('524 2 05 24', '524 2 05 24 5 018', 'Kabhrepalanchok', 'Sankhupatichour', 'SPSWO', NULL, 926, NULL, NULL, 'Blanket', 'Planned', '2015-11-11 00:00:00', NULL),
('524 2 05 24', '524 2 05 24 5 052', 'Kabhrepalanchok', 'Chyamrangbesi', 'SPSWO', NULL, 926, NULL, NULL, NULL, 'Planned', '2015-11-11 00:00:00', NULL),
('524 2 05 24', '524 2 05 24 5 064', 'Kabhrepalanchok', 'Rayale', 'SPSWO', NULL, 366, NULL, NULL, NULL, 'Planned', '2015-11-11 00:00:00', NULL),
('524 2 05 24', '524 2 05 24 5 075', 'Kabhrepalanchok', 'Bhumlutar', 'SPSWO', NULL, 1182, NULL, NULL, NULL, 'Planned', '2015-11-11 00:00:00', NULL),
('524 2 05 24', 'NONE', 'Kabhrepalanchok', 'Phalate', 'SPSWO', NULL, 627, NULL, NULL, NULL, 'Planned', '2015-11-11 00:00:00', NULL),
('524 2 05 24', '524 2 05 24 5 074', 'Kabhrepalanchok', 'Kolante', 'SPSWO', NULL, 401, NULL, NULL, NULL, 'Planned', '2015-11-11 00:00:00', NULL),
('524 2 05 24', '524 2 05 24 5 062', 'Kabhrepalanchok', 'Kushadevi', 'SPSWO', NULL, 407, NULL, NULL, NULL, 'Planned', '2015-11-11 00:00:00', NULL),
('524 2 05 24', '524 2 05 24 5 044', 'Kabhrepalanchok', 'Shyampati', 'SPSWO', NULL, 654, NULL, NULL, NULL, 'Planned', '2015-11-11 00:00:00', NULL),
('524 2 05 24', '524 2 05 24 3 002', 'Kabhrepalanchok', 'Panauti', 'SPSWO', NULL, 586, NULL, NULL, NULL, 'Planned', '2015-11-11 00:00:00', NULL),
('524 2 05 24', '524 2 05 24 5 080', 'Kabhrepalanchok', 'Kashikhanda', 'SPSWO', NULL, 105, NULL, NULL, NULL, 'Planned', '2015-11-11 00:00:00', NULL),
('524 2 05 24', '524 2 05 24 5 040', 'Kabhrepalanchok', 'Patlekhet', 'SPSWO', NULL, 120, NULL, NULL, NULL, 'Planned', '2015-11-11 00:00:00', NULL),
('524 2 05 24', '524 2 05 24 5 087', 'Kabhrepalanchok', 'Shiphali', 'SPSWO', NULL, 606, NULL, NULL, NULL, 'Planned', '2015-11-11 00:00:00', NULL),
('524 2 05 24', '524 2 05 24 5 031', 'Kabhrepalanchok', 'Mahadevtar', 'Namaste Nepal', NULL, 461, NULL, NULL, 'Blankets', 'Planned', '2015-11-11 00:00:00', NULL),
('524 2 05 24', '524 2 05 24 5 064', 'Kabhrepalanchok', 'Rayale', 'CRED', NULL, 250, NULL, NULL, 'Blankets', 'Planned', '2015-11-11 00:00:00', NULL),
('524 2 05 24', '524 2 05 24 5 062', 'Kabhrepalanchok', 'Kusadev', 'CRED', NULL, 250, NULL, NULL, NULL, 'Planned', '2015-11-11 00:00:00', NULL),
('524 2 05 24', '524 2 05 24 5 072', 'Kabhrepalanchok', 'Mahadevstan Mandan', 'CRED', NULL, 46, NULL, NULL, NULL, 'Planned', '2015-11-11 00:00:00', NULL),
('524 2 05 24', '524 2 05 24 5 071', 'Kabhrepalanchok', 'Jyamdi Mandan', 'CRED', NULL, 100, NULL, NULL, NULL, 'Planned', '2015-11-11 00:00:00', NULL),
('524 2 05 24', '524 2 05 24 5 070', 'Kabhrepalanchok', 'Jaisithok Mandan', 'CRED', NULL, 50, NULL, NULL, NULL, 'Planned', '2015-11-11 00:00:00', NULL),
('524 2 05 24', '524 2 05 24 5 060', 'Kabhrepalanchok', 'Giribisauna Deupur', 'CRED', NULL, 150, NULL, NULL, NULL, 'Planned', '2015-11-11 00:00:00', NULL),
('524 2 05 24', '524 2 05 24 5 061', 'Kabhrepalanchok', 'Nayagau Deupur', 'CRED', NULL, 103, NULL, NULL, NULL, 'Planned', '2015-11-11 00:00:00', NULL),
('524 2 05 24', '524 2 05 24 5 055', 'Kabhrepalanchok', 'Ugrachandi Nala', 'CRED', NULL, 100, NULL, NULL, NULL, 'Planned', '2015-11-11 00:00:00', NULL),
('524 2 05 24', '524 2 05 24 5 057', 'Kabhrepalanchok', 'Tukucha Nala', 'CRED', NULL, 100, NULL, NULL, NULL, 'Planned', '2015-11-11 00:00:00', NULL),
('524 2 05 24', '524 2 05 24 5 003', 'Kabhrepalanchok', 'Birta Deurali', 'CRED', NULL, 50, NULL, NULL, NULL, 'Planned', '2015-11-11 00:00:00', NULL),
('524 2 05 24', '524 2 05 24 5 087', 'Kabhrepalanchok', 'Simthali', 'CRED', NULL, 50, NULL, NULL, NULL, 'Planned', '2015-11-11 00:00:00', NULL),
('524 2 05 24', '524 2 05 24 5 082', 'Kabhrepalanchok', 'Falante Bhumlu', 'CRED', NULL, 50, NULL, NULL, NULL, 'Planned', '2015-11-11 00:00:00', NULL),
('524 2 05 24', '524 2 05 24 5 086', 'Kabhrepalanchok', 'Beghsimle', 'CRED', NULL, 50, NULL, NULL, NULL, 'Planned', '2015-11-11 00:00:00', NULL),
('524 2 05 24', '524 2 05 24 5 075', 'Kabhrepalanchok', 'Bhumlutar', 'CRED', NULL, 50, NULL, NULL, NULL, 'Planned', '2015-11-11 00:00:00', NULL),
('524 2 05 24', '524 2 05 24 5 083', 'Kabhrepalanchok', 'Salle Bhumlu', 'CRED', NULL, 50, NULL, NULL, NULL, 'Planned', '2015-11-11 00:00:00', NULL),
('524 2 05 24', '524 2 05 24 5 076', 'Kabhrepalanchok', 'Chaubas', 'CRED', NULL, 51, NULL, NULL, NULL, 'Planned', '2015-11-11 00:00:00', NULL),
('524 2 05 24', '524 2 05 24 5 084', 'Kabhrepalanchok', 'Saping', 'CRED', NULL, 50, NULL, NULL, NULL, 'Planned', '2015-11-11 00:00:00', NULL),
('524 2 05 24', '524 2 05 24 5 074', 'Kabhrepalanchok', 'Kolanti Bhumlu', 'CRED', NULL, 50, NULL, NULL, NULL, 'Planned', '2015-11-11 00:00:00', NULL),
('524 2 05 24', '524 2 05 24 5 004', 'Kabhrepalanchok', 'Dhusini Sibalaya', 'CRED', NULL, 50, NULL, NULL, NULL, 'Planned', '2015-11-11 00:00:00', NULL),
('524 2 05 24', '524 2 05 24 5 008', 'Kabhrepalanchok', 'Majhi Feda', 'CRED', NULL, 50, NULL, NULL, NULL, 'Planned', '2015-11-11 00:00:00', NULL),
('524 2 05 24', '524 2 05 24 5 005', 'Kabhrepalanchok', 'Godhpani', 'CRED', NULL, 50, NULL, NULL, NULL, 'Planned', '2015-11-11 00:00:00', NULL),
('524 2 05 24', '524 2 05 24 5 006', 'Kabhrepalanchok', 'Kattike Deurali', 'CRED', NULL, 50, NULL, NULL, NULL, 'Planned', '2015-11-11 00:00:00', NULL),
('524 2 05 24', '524 2 05 24 5 007', 'Kabhrepalanchok', 'Madan Kiundari', 'CRED', NULL, 50, NULL, NULL, NULL, 'Planned', '2015-11-11 00:00:00', NULL),
('524 2 05 24', '524 2 05 24 5 042', 'Kabhrepalanchok', 'Pokhari Chaunri', 'CRED', NULL, 50, NULL, NULL, NULL, 'Planned', '2015-11-11 00:00:00', NULL),
('524 2 05 24', '524 2 05 24 5 009', 'Kabhrepalanchok', 'Nagre Gagarche', 'CRED', NULL, 50, NULL, NULL, NULL, 'Planned', '2015-11-11 00:00:00', NULL),
('524 2 05 24', '524 2 05 24 5 010', 'Kabhrepalanchok', 'Sano Bangathali', 'CRED', NULL, 50, NULL, NULL, NULL, 'Planned', '2015-11-11 00:00:00', NULL),
('524 2 04 21', '524 2 04 21 5 018', 'Ramechhap', 'Bamti', 'GOAL', NULL, 234, NULL, NULL, 'Ordered 1407 winter kits to IOM', 'Planned', '2015-11-11 00:00:00', NULL),
('524 2 04 21', '524 2 04 21 5 020', 'Ramechhap', 'Gumdel', 'GOAL', NULL, 234, NULL, NULL, NULL, 'Planned', '2015-11-11 00:00:00', NULL),
('524 2 04 21', '524 2 04 21 5 019', 'Ramechhap', 'Chuchure', 'GOAL', NULL, 234, NULL, NULL, NULL, 'Planned', '2015-11-11 00:00:00', NULL),
('524 2 05 23', '524 2 05 23 5 060', 'Sindhupalchok', 'Talamarang', 'ActionAid', NULL, 921, NULL, NULL, 'TBC mattresses and blankets', 'Planned', '2015-11-11 00:00:00', NULL),
('524 2 05 23', '524 2 05 23 5 065', 'Sindhupalchok', 'Helambu', 'ActionAid', NULL, 946, NULL, NULL, NULL, 'Planned', '2015-11-11 00:00:00', NULL),
('524 2 05 23', '#N/A', 'Sindhupalchok', 'Kiul', 'ActionAid', NULL, 1012, NULL, NULL, NULL, 'Planned', '2015-11-11 00:00:00', NULL),
('524 2 05 23', '524 2 05 23 5 058', 'Sindhupalchok', 'Ichowk', 'ActionAid', NULL, 1620, NULL, NULL, NULL, 'Planned', '2015-11-11 00:00:00', NULL),
('524 2 05 23', '524 2 05 23 5 059', 'Sindhupalchok', 'Mahankal', 'ActionAid', NULL, 1246, NULL, NULL, NULL, 'Planned', '2015-11-11 00:00:00', NULL),
('524 2 05 23', '524 2 05 23 5 031', 'Sindhupalchok', 'Golche', 'Goal/PIN', NULL, 915, NULL, NULL, '126 USD worth voucher/cash grants for shelter/winterisation support.', 'Planned', '2015-11-11 00:00:00', NULL),
('524 2 05 23', '524 2 05 23 5 057', 'Sindhupalchok', 'Gumba', 'Goal/PIN', NULL, 542, NULL, NULL, NULL, 'Planned', '2015-11-11 00:00:00', NULL),
('524 2 05 23', '524 2 05 23 5 029', 'Sindhupalchok', 'Mankha', 'Goal/PIN', NULL, 930, NULL, NULL, NULL, 'Planned', '2015-11-11 00:00:00', NULL),
('524 2 05 23', '524 2 05 23 5 006', 'Sindhupalchok', 'Tatopani', 'Goal/PIN', NULL, 1753, NULL, NULL, NULL, 'Planned', '2015-11-11 00:00:00', NULL),
('524 2 05 23', '524 2 05 23 5 007', 'Sindhupalchok', 'Listokot', 'Goal/PIN', NULL, 949, NULL, NULL, NULL, 'Planned', '2015-11-11 00:00:00', NULL),
('524 2 05 23', '524 2 05 23 5 005', 'Sindhupalchok', 'Phulpinkatti', 'Goal/PIN', NULL, 783, NULL, NULL, NULL, 'Planned', '2015-11-11 00:00:00', NULL),
('524 2 05 23', '524 2 05 23 5 072', 'Sindhupalchok', 'Pangtang', 'Goal/PIN', NULL, 638, NULL, NULL, '2 or 3 Blankets (depending on HH size). 360 sq feet tarp (for walls and drop ceiling)| 13 sq meter of PvE foam (two rolls of 5m by 1.3m)| Tie wire and rope. An additional 20% of HH will be provided with cook-stoves. All children (from ages 5-18) will receive winter jackets as well. Also provision of shawls to mothers of young children (0-4) and pregnant women.', 'Planned', '2015-11-11 00:00:00', NULL),
('524 2 05 23', '524 2 05 23 5 051', 'Sindhupalchok', 'Hagam', 'Goal/PIN', NULL, 1130, NULL, NULL, NULL, 'Planned', '2015-11-11 00:00:00', NULL),
('524 2 05 23', '524 2 05 23 5 049', 'Sindhupalchok', 'Phulpingkot', 'Goal/PIN', NULL, 900, NULL, NULL, NULL, 'Planned', '2015-11-11 00:00:00', NULL),
('524 1 03 13', '524 1 03 13 5 020', 'Okhaldhunga', 'Harkapur', NULL, 'NRCS', 209, 'Cash- NPR 7000', NULL, NULL, 'Planned', '2015-11-11 00:00:00', NULL),
('524 1 03 13', '524 1 03 13 5 021', 'Okhaldhunga', 'Prapcha', NULL, 'NRCS', 209, 'Cash- NPR 7000', NULL, NULL, 'Planned', '2015-11-11 00:00:00', NULL),
('524 1 03 13', '524 1 03 13 5 022', 'Okhaldhunga', 'Shrichaur', NULL, 'NRCS', 209, 'Cash- NPR 7000', NULL, NULL, 'Planned', '2015-11-11 00:00:00', NULL),
('524 2 05 24', '524 2 05 24 5 040', 'Okhaldhunga', 'Patale', NULL, 'NRCS', 209, 'Cash- NPR 7000', NULL, NULL, 'Planned', '2015-11-11 00:00:00', NULL),
('524 1 03 13', '524 1 03 13 5 024', 'Okhaldhunga', 'Khijifalate', NULL, 'NRCS', 209, 'Cash- NPR 7000', NULL, NULL, 'Planned', '2015-11-11 00:00:00', NULL),
('524 1 03 13', '524 1 03 13 5 026', 'Okhaldhunga', 'Ragani', NULL, 'NRCS', 209, 'Cash- NPR 7000', NULL, NULL, 'Planned', '2015-11-11 00:00:00', NULL),
('524 1 03 13', '524 1 03 13 5 053', 'Okhaldhunga', 'Pokali', NULL, 'NRCS', 209, 'Cash- NPR 7000', NULL, NULL, 'Planned', '2015-11-11 00:00:00', NULL),
('524 1 03 13', '524 1 03 13 5 051', 'Okhaldhunga', 'Tarkerabari', NULL, 'NRCS', 209, 'Cash- NPR 7000', NULL, NULL, 'Planned', '2015-11-11 00:00:00', NULL),
('524 1 03 13', '524 1 03 13 5 042', 'Okhaldhunga', 'Bilandu', NULL, 'NRCS', 209, 'Cash- NPR 7000', NULL, NULL, 'Planned', '2015-11-11 00:00:00', NULL),
('524 1 03 13', '#N/A', 'Okhaldhunga', 'Siddhicharan Municipality Ward 1', NULL, 'NRCS', 209, 'Cash- NPR 7000', NULL, NULL, 'Planned', '2015-11-11 00:00:00', NULL),
('524 1 03 13', '#N/A', 'Okhaldhunga', 'Siddhicharan Municipality Ward 2', NULL, 'NRCS', 209, 'Cash- NPR 7000', NULL, NULL, 'Planned', '2015-11-11 00:00:00', NULL),
('524 1 03 13', '524 1 03 13 5 015', 'Okhaldhunga', 'Barneshwor', NULL, 'NRCS', 209, 'Cash- NPR 7000', NULL, NULL, 'Planned', '2015-11-11 00:00:00', NULL),
('524 2 05 24', '524 2 05 24 5 080', 'Kabhrepalanchok', 'Koshidekha', 'MSF/TGH(France)', 'ARSOW Nepal', 492, 'In kind (Blanket-1|Mattress-10m|Rope 5m| Plastic Sheet-15*18)', NULL, NULL, 'Planned', '2015-11-17 00:00:00', NULL),
('524 2 05 28', '524 2 05 28 5 028', 'Nuwakot', 'Chaughadha 1-9', 'Batas Foundation', NULL, 7554, 'In kind', NULL, NULL, 'Planned', '2015-11-17 00:00:00', NULL),
('524 2 05 23', '524 2 05 23 5 019', 'Sindhupalchok', 'Kalika 1-9', 'Batas Foundation', NULL, 3950, 'In Kind', NULL, NULL, 'Planned', '2015-11-17 00:00:00', NULL),
('524 2 05 29', '524 2 05 29 5 003', 'Rasuwa', 'Yarsa', 'Am Red Cross', 'NRCS', 944, 'Cash- NPR 7000', NULL, NULL, NULL, '2015-11-17 00:00:00', NULL),
('524 2 05 29', '524 2 05 29 5 004', 'Rasuwa', 'Samarthali', 'Am Red Cross', 'NRCS', 1021, 'Cash- NPR 7000', NULL, NULL, NULL, '2015-11-17 00:00:00', NULL),
('524 2 05 29', '524 2 05 29 5 005', 'Rasuwa', 'Bhorle', 'Am Red Cross', 'NRCS', 1438, 'Cash- NPR 7000', NULL, NULL, NULL, '2015-11-17 00:00:00', NULL),
('524 2 05 29', '524 2 05 29 5 010', 'Rasuwa', 'Thulogaon', 'Am Red Cross', 'NRCS', 399, 'Cash- NPR 7000', NULL, NULL, NULL, '2015-11-17 00:00:00', NULL),
('524 2 05 29', '524 2 05 29 5 009', 'Rasuwa', 'Danda Gaon', 'Am Red Cross', 'NRCS', 587, 'Cash- NPR 7000', NULL, NULL, NULL, '2015-11-17 00:00:00', NULL),
('524 2 05 28', '524 2 05 28 5 042', 'Nuwakot', 'Lachhyang', 'Am Red Cross', 'NRCS', 1130, 'Cash- NPR 7000', NULL, NULL, NULL, '2015-11-17 00:00:00', NULL),
('524 2 05 28', '524 2 05 28 5 058', 'Nuwakot', 'Kahule', 'Am Red Cross', 'NRCS', 870, 'Cash- NPR 7000', NULL, NULL, NULL, '2015-11-17 00:00:00', NULL),
('524 2 05 28', '524 2 05 28 5 035', 'Nuwakot', 'Urleni', 'Am Red Cross', 'NRCS', 835, 'Cash- NPR 7000', NULL, NULL, NULL, '2015-11-17 00:00:00', NULL),
('524 2 05 28', '524 2 05 28 5 056', 'Nuwakot', 'Bhalche', 'Am Red Cross', 'NRCS', 847, 'Cash- NPR 7000', NULL, NULL, NULL, '2015-11-17 00:00:00', NULL),
('524 2 06 31', '524 2 06 31 5 026', 'Makawanpur', 'Namtar', 'Am Red Cross', 'NRCS', 520, 'Cash- NPR 7000', NULL, NULL, NULL, '2015-11-17 00:00:00', NULL),
('524 2 06 31', '524 2 06 31 5 023', 'Makawanpur', 'Kairang', 'Am Red Cross', 'NRCS', 187, 'Cash- NPR 7000', NULL, NULL, NULL, '2015-11-17 00:00:00', NULL),
('524 2 06 31', '524 2 06 31 5 028', 'Makawanpur', 'Dandakharka', 'Am Red Cross', 'NRCS', 800, 'Cash- NPR 7000', NULL, NULL, NULL, '2015-11-17 00:00:00', NULL),
('524 2 06 31', '524 2 06 31 5 031', 'Makawanpur', 'Gogane', 'Am Red Cross', 'NRCS', 1190, 'Cash- NPR 7000', NULL, NULL, NULL, '2015-11-17 00:00:00', NULL),
('524 2 05 26', '#N/A', 'Bhaktapur', 'Mahamanjushree', 'British Red Cross', 'NRCS', 4259, 'Cash- NPR 7000', NULL, NULL, NULL, '2015-11-17 00:00:00', NULL),
('524 2 05 26', '#N/A', 'Bhaktapur', 'Anantalingeswar', 'British Red Cross', 'NRCS', 628, 'Cash- NPR 7000', NULL, NULL, NULL, '2015-11-17 00:00:00', NULL),
('524 2 05 26', '524 2 05 26 5 006', 'Bhaktapur', 'Changunarayan', 'British Red Cross', 'NRCS', 2920, 'Cash- NPR 7000', NULL, NULL, NULL, '2015-11-17 00:00:00', NULL),
('524 2 05 25', '#N/A', 'Lalitpur', 'Karyavinayak', 'British Red Cross', 'NRCS', 1273, 'Cash- NPR 7000', NULL, NULL, NULL, '2015-11-17 00:00:00', NULL),
('524 2 05 25', '#N/A', 'Lalitpur', 'Mahalaxmi', 'British Red Cross', 'NRCS', 1737, 'Cash- NPR 7000', NULL, NULL, NULL, '2015-11-17 00:00:00', NULL),
('524 2 05 25', '524 2 05 25 5 025', 'Lalitpur', 'Godawari', 'British Red Cross', 'NRCS', 1466, 'Cash- NPR 7000', NULL, NULL, NULL, '2015-11-17 00:00:00', NULL),
('524 2 05 25', '524 2 05 25 2 001', 'Lalitpur', 'Lalitpu SM', 'British Red Cross', 'NRCS', 1001, 'Cash- NPR 7000', NULL, NULL, NULL, '2015-11-17 00:00:00', NULL),
('524 2 05 27', '#N/A', 'Kathmandu', 'Takakeshwar', 'British Red Cross', 'NRCS', 3714, 'Cash- NPR 7000', NULL, NULL, NULL, '2015-11-17 00:00:00', NULL),
('524 2 05 27', '#N/A', 'Kathmandu', 'Sankarapur', 'British Red Cross', 'NRCS', 1420, 'Cash- NPR 7000', NULL, NULL, NULL, '2015-11-17 00:00:00', NULL),
('524 2 05 27', '524 2 05 27 1 001', 'Kathmandu', 'Metro', 'British Red Cross', 'NRCS', 266, 'Cash- NPR 7000', NULL, NULL, NULL, '2015-11-17 00:00:00', NULL),
('524 2 05 23', '524 2 05 23 5 061', 'Sindhupalchok', 'Melamchi', 'DRC/BRC', 'NRCS', 707, 'Cash- NPR 7000', NULL, NULL, NULL, '2015-11-17 00:00:00', NULL),
('524 2 05 23', '524 2 05 23 5 061', 'Sindhupalchok', 'Melamchi', 'DRC/BRC', 'NRCS', 453, 'Cash- NPR 7000', NULL, NULL, NULL, '2015-11-17 00:00:00', NULL),
('524 2 05 23', '524 2 05 23 5 048', 'Sindhupalchok', 'Nawalpur', 'DRC/BRC', 'NRCS', 734, 'Cash- NPR 7000', NULL, NULL, NULL, '2015-11-17 00:00:00', NULL),
('524 2 05 23', '524 2 05 23 5 046', 'Sindhupalchok', 'Kunchok', 'DRC/BRC', 'NRCS', 1080, 'Cash- NPR 7000', NULL, NULL, NULL, '2015-11-17 00:00:00', NULL),
('524 2 05 23', '524 2 05 23 5 044', 'Sindhupalchok', 'Bandegaun', 'DRC/BRC', 'NRCS', 1487, 'Cash- NPR 7000', NULL, NULL, NULL, '2015-11-17 00:00:00', NULL),
('524 2 05 24', '524 2 05 24 5 071', 'Kabhrepalanchok', 'Jyamdi Mandan', 'DRC/BRC', 'NRCS', 800, 'Cash- NPR 7000', NULL, NULL, NULL, '2015-11-17 00:00:00', NULL),
('524 2 05 24', '524 2 05 24 5 078', 'Kabhrepalanchok', 'Dolalghat', 'DRC/BRC', 'NRCS', 800, 'Cash- NPR 7000', NULL, NULL, NULL, '2015-11-17 00:00:00', NULL),
('524 2 05 24', '524 2 05 24 5 081', 'Kabhrepalanchok', 'Kharelthok', 'DRC/BRC', 'NRCS', 800, 'Cash- NPR 7000', NULL, NULL, NULL, '2015-11-17 00:00:00', NULL),
('524 2 05 30', '524 2 05 30 5 006', 'Dhading', 'Aginchok', 'CARE', NULL, 1020, NULL, NULL, 'Blanket-5| mattress-2| kitchen set-1', NULL, '2015-11-17 00:00:00', NULL),
('524 2 05 30', '524 2 05 30 5 009', 'Dhading', 'Baseri', 'CARE', NULL, 1091, 'Voucher', NULL, NULL, NULL, '2015-11-17 00:00:00', NULL),
('524 2 05 30', '524 2 05 30 5 013', 'Dhading', 'Phulkharka', 'CARE', NULL, 1132, 'Voucher', NULL, NULL, NULL, '2015-11-17 00:00:00', NULL),
('524 2 05 30', '524 2 05 30 5 033', 'Dhading', 'Kumpur', 'DCA', NULL, 624, NULL, NULL, NULL, 'Planned', '2015-11-17 00:00:00', NULL),
('524 2 05 30', '524 2 05 30 5 014', 'Dhading', 'Salyankot', 'DCA', NULL, 600, NULL, NULL, NULL, 'Planned', '2015-11-17 00:00:00', NULL),
('524 2 05 30', '524 2 05 30 5 034', 'Dhading', 'Nalang', 'DCA', NULL, NULL, NULL, NULL, NULL, 'Planned', '2015-11-17 00:00:00', NULL),
('524 2 05 30', '524 2 05 30 5 028', 'Dhading', 'Salang', 'DCA', NULL, NULL, NULL, NULL, NULL, 'Planned', '2015-11-17 00:00:00', NULL),
('524 2 05 30', '524 2 05 30 5 022', 'Dhading', 'Khari', 'DCA', NULL, NULL, NULL, NULL, NULL, 'Planned', '2015-11-17 00:00:00', NULL),
('524 2 04 21', '524 2 04 21 5 013', 'Ramechhap', 'Duragoun', 'Humedica e.V', 'United Vision Nepal', 820, NULL, NULL, 'Solar lamps| bed foams and pressure cookers will be given along with blankets. These materials are according to the request of villagers.', NULL, '2015-11-23 00:00:00', NULL),
('524 2 04 21', '524 2 04 21 5 017', 'Ramechhap', 'Saipu', 'Humedica e.V', 'United Vision Nepal', 712, NULL, NULL, 'Solar lamps| bed foams and pressure cookers will be given along with blankets. These materials are according to the request of villagers.', NULL, '2015-11-23 00:00:00', NULL),
('524 2 05 30', '524 2 05 30 5 011', 'Dhading', 'Gumdi', 'ACTED', 'ACTED', 500, 'In kind', NULL, 'Blankets- 5pcs/hh', 'Planned', '2015-11-23 00:00:00', NULL),
('524 1 03 11', NULL, 'Solukhumbu', NULL, 'ACTED', 'ACTED', 350, 'In kind', NULL, 'Blankets', 'Planned', '2015-11-23 00:00:00', NULL)
;
drop table if exists winterisation;
create table winterisation as select * from codes where priority is true;
--add columns
alter table winterisation add column num_hh_damage float;
alter table winterisation add column pct_damage float;
alter table winterisation add column target_hh float;
alter table winterisation add column in_db boolean;
alter table winterisation add column map_cd float;
alter table winterisation add column census_hh_dmg float;
--data cleaning
update winterisation set target_hh = null where target_hh = 0;
--set if in db
update winterisation set in_db =
case
when hlcit_code in (select vdc_code from winterisation_db) then TRUE
else FALSE end;
--get hh damage counts
update winterisation set num_hh_damage = d.tot_dmg_cnt
from vdc_damage d
where winterisation.hlcit_code = d.hlcit_code;
--add target counts through group by of winter_db
update winterisation set target_hh = s.sum from
(
select vdc_code, sum(target_hh) from winterisation_db
group by 1
)s
where winterisation.hlcit_code = s.vdc_code;
--set pct damage... by default use regular division. if vdc_code is not null and num_hh_damage is null, set to 100 pct
update winterisation set pct_damage =
case when num_hh_damage is null or num_hh_damage = 0 then 1.0
when num_hh_damage <> 0 and target_hh is not null then target_hh/num_hh_damage end;
--map codes:
-- pct damage: if not pct damgae not null
-- neg 1: above 1500m, no coverage... above_1500 true and in_db false
-- neg 2: covered, less than 1500m... target_hh not null and ab_15 false
-- neg 3: presence but unknown coverage amount... in_db TRUE and target_hh is null
-- neg 4: not in db... in_db = FALSE
UPDATE winterisation SET map_cd = CASE
WHEN above_1500 IS TRUE AND in_db IS FALSE THEN -1
WHEN target_hh IS NOT NULL AND above_1500 IS FALSE THEN -2
WHEN in_db IS TRUE AND target_hh IS NULL THEN -3
WHEN in_db IS FALSE THEN -4
WHEN pct_damage IS NOT NULL THEN pct_damage
END;
SELECT CASE
WHEN map_cd = -1 THEN '-1: above 1500m, no coverage (red stripe)'
WHEN map_cd = -2 THEN '-2: covered, less than 1500m (green dots)'
WHEN map_cd = -3 THEN '-3: presence but unknown coverage amount (dark grey)'
WHEN map_cd = -4 THEN '-4: vdc not in consideration (light grey)'
WHEN map_cd >=0 THEN 'properly covered VDC (shades of red)'
ELSE 'THIS IS BAD' END as cd, count(*) from winterisation
group by 1;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment