testToSQLite

Custom SQL query returning 3 rows (hide)

select rowid, ini_id, ini_name, afg, alb, dza, asm, [and], ago, aia, ata, atg, arg, arm, abw, aus, aut, aze, bhs, bhr, bgd, brb, blr, bel, blz, ben, bmu, btn, bol, bes, bih, bwa, bvt, bra, iot, brn, bgr, bfa, bdi, cpv, khm, cmr, can, cym, caf, tcd, chl, chn, cxr, cck, col, com, cod, cog, cok, cri, hrv, cub, cuw, cyp, cze, civ, dnk, dji, dma, dom, ecu, egy, slv, gnq, eri, est, swz, eth, flk, fro, fji, fin, fra, guf, pyf, atf, gab, gmb, geo, deu, gha, gib, grc, grl, grd, glp, gum, gtm, ggy, gin, gnb, guy, hti, hmd, vat, hnd, hkg, hun, isl, ind, idn, irn, irq, irl, imn, isr, ita, jam, jpn, jey, jor, kaz, ken, kir, prk, kor, kwt, kgz, lao, lva, lbn, lso, lbr, lby, lie, ltu, lux, mac, mdg, mwi, mys, mdv, mli, mlt, mhl, mtq, mrt, mus, myt, mex, fsm, mda, mco, mng, mne, msr, mar, moz, mmr, nam, nru, npl, nld, ncl, nzl, nic, ner, nga, niu, nfk, mnp, nor, omn, pak, plw, pse, pan, png, pry, per, phl, pcn, pol, prt, pri, qat, mkd, rou, rus, rwa, reu, blm, shn, kna, lca, maf, spm, vct, wsm, smr, stp, sau, sen, srb, syc, sle, sgp, sxm, svk, svn, slb, som, zaf, sgs, ssd, esp, lka, sdn, sur, sjm, swe, che, syr, twn, tjk, tza, tha, tls, tgo, tkl, ton, tto, tun, tur, tkm, tca, tuv, uga, ukr, are, gbr, umi, usa, ury, uzb, vut, ven, vnm, vgb, vir, wlf, esh, yem, zmb, zwe, ala from gca_geography where "srb" = :p0 order by rowid limit 101

Query parameters

This data as json, CSV

rowid	ini_id	ini_name	afg	alb	dza	arg	arm	aus	aut	aze	bgd	blr	bel	blz	ben	btn	bol	bih	bwa	bra	bgr	bfa	bdi	cpv	khm	cmr	can	caf	tcd	chl	chn	col	com	cod	cri	hrv	cyp	cze	civ	dnk	dji	dma	dom	ecu	egy	slv	est	swz	eth	fji	fin	fra	gab	gmb	geo	deu	gha	gib	grc	grd	gtm	gin	guy	hti	hnd	hun	isl	ind	idn	irq	irl	isr	ita	jam	jpn	jor	kaz	ken	kir	kor	kgz	lao	lva	lbn	lso	lbr	ltu	lux	mdg	mwi	mys	mli	mlt	mhl	mrt	mus	mex	mda	mco	mng	mne	mar	moz	mmr	nam	npl	nld	nzl	nic	ner	nga	nor	pak	pse	pan	png	pry	per	phl	pol	prt	pri	qat	mkd	rou	rus	rwa	lca	wsm	smr	stp	sau	sen	srb	syc	sle	sgp	svk	svn	slb	som	zaf	esp	lka	sur	swe	che	tjk	tza	tha	tls	tgo	ton	tto	tun	tur	tuv	uga	ukr	are	gbr	usa	ury	uzb	vut	ven	vnm	yem	zmb	zwe
9	NAZCA_18_41	Collaborative Climate Action Across the Air Transport World	0	1	0	0	1	1	1	1	0	0	1	0	0	0	0	1	1	0	1	1	0	0	0	0	1	0	0	0	1	0	0	0	1	1	1	1	0	1	0	0	0	0	0	1	1	0	0	0	1	1	1	0	1	1	0	0	1	0	1	0	0	0	0	1	1	0	1	0	1	1	1	1	1	0	0	1	0	1	0	0	1	0	0	0	1	1	0	0	1	0	1	1	0	0	1	1	1	0	1	0	0	0	1	0	1	1	0	0	1	1	0	0	0	1	0	0	0	1	1	0	1	1	1	0	0	0	0	1	0	1	0	1	0	0	1	1	1	0	0	0	1	0	0	1	1	0	0	1	0	0	0	0	0	1	0	0	1	1	1	1	0	0	0	0	0	0	1	0
19	NAZCA_18_81	Global Covenant of Mayors for Climate & Energy	0	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	0	1	1	1	1	1	0	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	0	1	1	1	0	0	1	1	1	1	1	1	1	1	1	1	1	1	1	0	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	0	1	1	0	1	1	0	1	1	1	1	1	1	1	1	0	1	1	1	1	0	1	1	1	1	0	1	1	1	1	0	0	1	1	1	1	1	1	1	1	1	1	1	1	0	1	1	1	0	0	0	0	0	0	1	1	0	1	0	1	1	1	1	1	1	1	0	1	1	1	1	1	0	1	0	1	1	1	0	1	1	1	1	1	1	0	1	1	1	0	1	1
59	LPA_RE_05	Global Facility for Disaster Reduction and Recovery	1	1	0	1	1	0	0	0	1	1	0	1	1	1	1	1	1	1	1	1	1	1	1	1	0	0	0	1	1	1	1	1	1	0	0	0	0	0	1	1	0	1	1	1	0	0	1	1	0	0	0	0	1	0	1	0	0	1	1	0	1	1	0	0	0	1	1	1	0	0	0	1	0	1	1	1	1	0	1	1	0	1	1	1	0	0	1	1	0	0	0	0	0	0	1	1	0	1	0	1	1	1	1	1	0	0	1	1	1	0	1	0	1	1	1	1	1	0	0	0	0	0	1	0	1	1	1	0	1	1	1	1	1	1	0	0	0	1	1	1	0	1	1	0	0	1	1	1	1	1	1	0	1	1	1	1	0	0	0	0	1	1	1	0	1	1	1	1