testToSQLite

Custom SQL query returning 14 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 (bmu > :p1 or (bmu = :p1 and rowid > :p0)) order by bmu, rowid limit 101

Query parameters

This data as json, CSV

rowid	ini_id	ini_name	aia	atg	arg	arm	aus	aut	bhs	bgd	brb	bel	blz	ben	bmu	bra	bfa	khm	cmr	can	cym	caf	tcd	chl	chn	col	com	cod	cok	cri	civ	dnk	dma	dom	ecu	egy	fin	fra	gab	gmb	deu	grc	grd	gin	hti	hkg	hun	ind	idn	irl	ita	jam	jpn	jor	ken	kor	kwt	lbn	ltu	mdg	mys	mli	mhl	mrt	mex	mng	moz	nld	nzl	nic	ner	nga	nor	pak	png	pry	per	phl	pol	prt	rou	rus	rwa	kna	lca	vct	wsm	sau	sen	sgp	zaf	esp	lka	swe	che	twn	tza	tha	tgo	ton	tto	tur	tca	uga	are	gbr	usa	ury	vut	vnm	zmb
103		"0"	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0
104		"0"	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0
105		"0"	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0
106		"0"	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0
107		"0"	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0
108			0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0
109			0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0
110			0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0
111			0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0
112			0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0
113			0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0
114			0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0
22	NAZCA_18_71	Science-based Targets	0	0	0	0	1	1	0	1	0	1	0	0	1	1	0	0	1	1	0	0	0	1	1	1	0	0	0	1	0	1	0	0	0	1	1	1	0	0	1	1	1	0	0	1	1	1	1	1	1	0	1	1	1	1	1	1	1	0	1	0	0	0	1	0	0	1	1	0	0	1	1	1	0	0	0	0	1	1	1	1	0	0	0	0	0	1	0	1	1	1	1	1	1	1	0	1	0	0	0	1	0	1	1	1	1	1	0	1	0
43	NAZCA_18_23	InsuResilience Global Partnership	1	1	1	1	0	0	1	1	1	0	1	1	1	0	1	1	1	0	1	1	1	0	0	1	1	1	1	0	1	0	1	1	1	0	0	0	1	1	1	0	1	1	1	0	0	1	1	0	0	1	0	0	1	0	0	0	0	1	0	1	1	1	0	1	1	0	0	1	1	1	0	0	1	1	1	1	0	0	0	0	1	1	1	1	1	0	1	0	0	0	1	0	0	0	1	1	1	1	1	0	1	1	0	1	1	1	1	1	1