testToSQLite: adaptation_solution_basic_information: 1 row where where Database = "IFAD" sorted by Province

1 row where Database = "IFAD" sorted by Province_Community

descending

Link	rowid	ID	Project_Name	Region	Country	Province_Community ▼	Scale	Focus_Sector	Main_Climate_Risks	Adaptation_Measures	Time_frame	Finance_Desegregation	Main_funding_agencies	Implementing_agency	Database	Description	Main_Source
12	12	12	Char Development and Settlement Project – Phase IV	South Asia	Bangladesh	Nangulia, Noler, Caring, Ziauddin and Urir Chars in the coastal area of Noakhali District in southeast Bangladesh.	Subnational	Water; Disaster risk reduction; Coastal protection; Infrastructure; Food and agriculture	Storms; Floods; Drought; Saltwater intrusion; Forest and land degradation	Infrastructure; Finance; Nature-based solutions and ecosystem services	2011 - 2018	Total USD89.2 million IFAD loan: USD47.30 (SDR30.6 million) GoN grant: USD20.6 million GoB counterpart financing: USD15.6 million NGOs credit contribution:USD4.9 million Beneficiaries’ in kind or cash contribution: USD0.81 million	International Fund for Agricultural Development (IFAD), the Government of Netherlands (GoN) and the Government of the People’s Republic of Bangladesh (GoB)	For each component a different ministry	IFAD	The Goal of CDSP-IV is reduced poverty and hunger for poor people living on newly accreted coastal chars. The Project Purpose is improved and more secure rural livelihoods for 28,000 households who comprise the population of Nangulia, Noler, Caring, Ziauddin and Urir Chars in the coastal area of Noakhali District in southeast Bangladesh. 3. Project implementation is organised in five components: (1) protection from climate change (water management and social forestry); (2) climate-resilient infrastructure (internal infrastructure, water and sanitation); (3) land settlement and titling; (4) livelihood support (agricultural support, social and livelihoods support); and (v) technical assistance and management support.	https://www.ifad.org/documents/38711624/40089498/CDSP_sv_report_2017_0010-41-4540_7612.pdf/8f78a3b2-172e-4030-a63b-363d09f92241?1517983961769= AND https://www.mottmac.com/article/1127/char-development-and-settlement-project

Advanced export

JSON shape: default, array, newline-delimited

CREATE TABLE "adaptation_solution_basic_information" (
	"ID" VARCHAR(255) NULL,
	"Project_Name" VARCHAR(255) NULL,
	"Region" VARCHAR(255) NULL,
	"Country" VARCHAR(255) NULL,
	"Province_Community" VARCHAR(255) NULL,
	"Scale" VARCHAR(255) NULL,
	"Focus_Sector" VARCHAR(255) NULL,
	"Main_Climate_Risks" VARCHAR(255) NULL,
	"Adaptation_Measures" VARCHAR(255) NULL,
	"Time_frame" VARCHAR(255) NULL,
	"Finance_Desegregation" VARCHAR(255) NULL,
	"Main_funding_agencies" VARCHAR(255) NULL,
	"Implementing_agency" VARCHAR(255) NULL,
	"Database" VARCHAR(255) NULL,
	"Description" TEXT NULL,
	"Main_Source" VARCHAR(255) NULL
);