squirrels

Custom SQL query returning 48 rows (hide)

select rowid, longitude, latitude, [Unique Squirrel ID], Hectare, Shift, Date, [Hectare Squirrel Number], Age, [Primary Fur Color], [Highlight Fur Color], [Combination of Primary and Highlight Color], [Color notes], Location, [Above Ground Sighter Measurement], [Specific Location], Running, Chasing, Climbing, Eating, Foraging, [Other Activities], Kuks, Quaas, Moans, [Tail flags], [Tail twitches], Approaches, Indifferent, [Runs from], [Other Interactions], [Lat/Long] from [2018_Central_Park_Squirrel_Census_-_Squirrel_Data] where ([Primary Fur Color] > :p1 or ([Primary Fur Color] = :p1 and rowid > :p0)) order by [Primary Fur Color], rowid limit 101

Query parameters

This data as json, CSV

rowid	longitude	latitude	Unique Squirrel ID	Hectare	Shift	Date	Hectare Squirrel Number	Age	Primary Fur Color	Highlight Fur Color	Combination of Primary and Highlight Color	Color notes	Location	Above Ground Sighter Measurement	Specific Location	Running	Chasing	Climbing	Eating	Foraging	Other Activities	Kuks	Tail flags	Tail twitches	Indifferent	Runs from	Other Interactions	Lat/Long
2961	-73.9736238258579	40.7688712771191	5F-PM-1007-04	05F	PM	10072018	4	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	0	0	0	1		0	0	1	1	0		POINT (-73.9736238258579 40.7688712771191)
2962	-73.9722530826293	40.7667138028361	3I-AM-1010-05	03I	AM	10102018	5	Adult	Gray		Gray+		Ground Plane	FALSE		0	0	0	0	1		0	0	0	1	0		POINT (-73.9722530826293 40.7667138028361)
2963	-73.9687020800791	40.7735903424522	11H-AM-1010-08	11H	AM	10102018	8	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	0	0	0	1		0	0	1	0	1		POINT (-73.9687020800791 40.7735903424522)
2964	-73.9703604542938	40.776269022329394	13E-AM-1017-04	13E	AM	10172018	4	Adult	Gray		Gray+		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	0		POINT (-73.9703604542938 40.7762690223294)
2966	-73.9630596103391	40.792572062055605	32A-AM-1018-04	32A	AM	10182018	4	Adult	Gray		Gray+		Ground Plane	FALSE	Base of tree	0	0	0	0	1		0	1	0	1	0		POINT (-73.9630596103391 40.7925720620556)
2967	-73.97132575863719	40.776271961946705	13D-AM-1014-09	13D	AM	10142018	9	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	0	0	1	1		0	0	0	1	0		POINT (-73.9713257586372 40.7762719619467)
2968	-73.9587236619579	40.799185018043396	40A-AM-1010-02	40A	AM	10102018	2	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE	edge of park at 108th West	1	0	1	0	0		0	1	0	0	1		POINT (-73.9587236619579 40.7991850180434)
2969	-73.9654409838612	40.7901338748522	29A-AM-1013-01	29A	AM	10132018	1	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	0	0	0	1	climbed tree (oak)	0	0	1	0	1		POINT (-73.9654409838612 40.7901338748522)
2970	-73.9619019299709	40.7924476439693	33B-PM-1010-05	33B	PM	10102018	5	Adult	Gray		Gray+		Ground Plane	FALSE		0	0	0	0	0		0	0	0	1	0		POINT (-73.9619019299709 40.7924476439693)
2972	-73.9631468456897	40.7926110399714	32A-AM-1018-03	32A	AM	10182018	3	Adult	Gray		Gray+		Ground Plane	FALSE		0	0	0	0	1		0	0	0	1	0		POINT (-73.9631468456897 40.7926110399714)
2973	-73.9766693184436	40.7708879215854	6C-PM-1020-01	06C	PM	10202018	1	Adult	Gray	White	Gray+White		Above Ground	25	Across Transverse	0	0	1	0	0		0	0	0	1	0		POINT (-73.9766693184436 40.7708879215854)
2977	-73.95806816485471	40.799201001265295	41B-AM-1010-01	41B	AM	10102018	1	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	0		POINT (-73.9580681648547 40.7992010012653)
2978	-73.96888170064429	40.7829120321438	20B-PM-1013-09	20B	PM	10132018	9	Adult	Gray	White	Gray+White		Ground Plane	FALSE		0	0	0	0	1		0	0	0	1	0		POINT (-73.9688817006443 40.7829120321438)
2979	-73.9571808775915	40.793444386672505	35E-AM-1020-02	35E	AM	10202018	2	Adult	Gray	Cinnamon	Gray+Cinnamon		Above Ground	25		0	0	0	0	0	cleaning herself	0	0	0	1	0		POINT (-73.9571808775915 40.7934443866725)
2980	-73.97164145863809	40.771760114722	9F-PM-1014-06	09F	PM	10142018	6	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		1	0	0	1	0	running (from birds)	0	1	0	1	0		POINT (-73.9716414586381 40.771760114722)
2981	-73.9800094828465	40.7677782585639	1B-AM-1012-04	01B	AM	10122018	4		Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		1	0	0	1	0		0	0	0	1	0		POINT (-73.9800094828465 40.7677782585639)
2982	-73.9513477815203	40.7945259614138	39I-PM-1013-02	39I	PM	10132018	2	Juvenile	Gray		Gray+		Ground Plane	FALSE	along the road	0	1	1	0	0	playing	0	0	0	0	0		POINT (-73.9513477815203 40.7945259614138)
2983	-73.9689586689061	40.7839613907139	21B-PM-1017-04	21B	PM	10172018	4	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	0	0	1	1		0	0	0	0	1		POINT (-73.9689586689061 40.7839613907139)
2984	-73.9700158929437	40.7762359066591	14E-AM-1008-18	14E	AM	10082018	18	Adult	Gray		Gray+		Ground Plane	FALSE		0	0	0	1	1		0	0	0	1	0		POINT (-73.9700158929437 40.7762359066591)
2987	-73.9563724838337	40.7882504581015	31I-PM-1019-04	31I	PM	10192018	4	Adult	Gray		Gray+		Ground Plane	FALSE		1	0	0	0	0		0	0	0	1	0		POINT (-73.95637248383372 40.7882504581015)
2988	-73.9766342759486	40.7687518380873	4D-AM-1012-04	04D	AM	10122018	4	Adult	Gray		Gray+		Above Ground	3	on tree trunk	0	1	1	0	0		0	0	1	1	0		POINT (-73.9766342759486 40.7687518380873)
2990	-73.97660121083071	40.7712310725379	6C-AM-1007-05	06C	AM	10072018	5	Adult	Gray		Gray+		Above Ground	20		0	1	1	0	0	chasing #4	0	0	0	1	0		POINT (-73.9766012108307 40.7712310725379)
2991	-73.96846326736029	40.784890952519795	23A-AM-1018-05	23A	AM	10182018	5	Adult	Gray		Gray+		Ground Plane	FALSE		1	0	0	0	0		0	0	0	0	1		POINT (-73.9684632673603 40.7848909525198)
2993	-73.95707222626929	40.798570614351895	40C-AM-1017-04	40C	AM	10172018	4	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	1	0	1	1	chasing (#3)	0	0	0	1	0		POINT (-73.9570722262693 40.7985706143519)
2994	-73.96172070912449	40.792283902593496	33B-AM-1010-01	33B	AM	10102018	1	Adult	Gray		Gray+		Ground Plane	FALSE		0	0	0	0	1	digging	0	0	0	1	0		POINT (-73.9617207091245 40.7922839025935)
2995	-73.9668442742942	40.7870781042595	25B-PM-1007-01	25B	PM	10072018	1		Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	0	0	1	1		0	0	0	1	0		POINT (-73.9668442742942 40.7870781042595)
2996	-73.970033345821	40.777259393859	15E-PM-1008-08	15E	PM	10082018	8	Adult	Gray		Gray+		Ground Plane	FALSE		0	0	0	1	0		0	0	0	1	0		POINT (-73.970033345821 40.777259393859)
2997	-73.96197353854829	40.7944667974974	35A-PM-1013-01	35A	PM	10132018	1	Adult	Gray	White	Gray+White		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	1		POINT (-73.9619735385483 40.7944667974974)
3000	-73.9688293382172	40.7738958027568	12G-AM-1012-04	12G	AM	10122018	4	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White		Ground Plane	FALSE		0	0	0	0	1		0	0	1	1	0		POINT (-73.9688293382172 40.773895802756805)
3001	-73.97755922284159	40.7668485329273	1D-PM-1007-01	01D	PM	10072018	1	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White		Ground Plane	FALSE		0	0	0	0	1		0	0	0	1	0		POINT (-73.9775592228416 40.7668485329273)
3002	-73.9710991846972	40.768982782424104	6H-PM-1020-01	06H	PM	10202018	1	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White		Ground Plane	FALSE		0	0	0	0	1		0	0	0	1	0		POINT (-73.9710991846972 40.7689827824241)
3005	-73.96161411525391	40.7921803313341	33C-PM-1007-04	33C	PM	10072018	4	Adult	Gray	White	Gray+White		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	1		POINT (-73.9616141152539 40.7921803313341)
3006	-73.97443902173859	40.7663168362582	2G-AM-1010-02	02G	AM	10102018	2	Adult	Gray		Gray+		Ground Plane	FALSE		0	0	0	1	0		0	0	0	1	0		POINT (-73.9744390217386 40.7663168362582)
3007	-73.9635140434993	40.7912807969365	31B-AM-1017-01	31B	AM	10172018	1	Adult	Gray		Gray+		Ground Plane	FALSE		0	0	0	1	0		0	0	0	1	0		POINT (-73.9635140434993 40.7912807969365)
3008	-73.9503533343658	40.7976543603953	42H-PM-1014-04	42H	PM	10142018	4	Adult	Gray	Cinnamon	Gray+Cinnamon		Above Ground	15		1	1	0	0	0		0	0	1	0	1		POINT (-73.9503533343658 40.7976543603953)
3009	-73.9675637870968	40.782388067172796	21D-PM-1008-02	21D	PM	10082018	2		Gray	White	Gray+White		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	0		POINT (-73.9675637870968 40.7823880671728)
3010	-73.9580906814132	40.7948404060484	37D-PM-1014-01	37D	PM	10142018	1	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	1	eyes from a safe distance	POINT (-73.9580906814132 40.7948404060484)
3011	-73.96788313129359	40.7847605974975	23B-PM-1012-06	23B	PM	10122018	6	Adult	Gray		Gray+		Above Ground	30		0	0	0	0	0		1	0	0	0	0	scolding	POINT (-73.9678831312936 40.7847605974975)
3012	-73.96137019608979	40.7943363227822	35B-PM-1013-04	35B	PM	10132018	4	Adult	Gray		Gray+		Ground Plane	FALSE		1	0	1	0	1	got threatened by dog (same dog,dog #1)	0	0	0	0	1	runs from (dog)	POINT (-73.9613701960898 40.7943363227822)
3013	-73.964661337306	40.7769785494935	17I-AM-1014-03	17I	AM	10142018	3	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White	Cinnamon face	Above Ground	10		0	0	1	0	0	climbing (dog barked & it ran up tree)	0	0	0	1	0		POINT (-73.964661337306 40.7769785494935)
3014	-73.9665572004288	40.780434754830296	19E-PM-1018-04	19E	PM	10182018	4		Gray		Gray+		Ground Plane	FALSE		0	0	0	1	0		0	0	0	1	0		POINT (-73.9665572004288 40.7804347548303)
3015	-73.97591633005351	40.7736180793606	9B-AM-1010-08	09B	AM	10102018	8	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White	Cinnamon head, White (Almost Silver)	Ground Plane	FALSE		0	0	0	1	1		0	0	1	0	0		POINT (-73.9759163300535 40.7736180793606)
3016	-73.9756457597888	40.7703559775625	6D-PM-1020-02	06D	PM	10202018	2	Juvenile	Gray		Gray+		Ground Plane	FALSE		0	1	0	0	0		0	0	1	0	1		POINT (-73.9756457597888 40.7703559775625)
3017	-73.9662895079734	40.7843300758044	23C-AM-1019-01	23C	AM	10192018	1	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White	Gray & Cinnamon selected as Primary. Gray, Cinnamon & White selected as Highlights. Made executive adjustments.	Above Ground	7		0	0	1	1	0	eating (on branch)	1	0	0	1	0		POINT (-73.9662895079734 40.7843300758044)
3019	-73.9639431360458	40.7908677445466	30B-AM-1007-04	30B	AM	10072018	4	Adult	Gray		Gray+		Ground Plane	FALSE		0	0	0	1	1		0	0	0	0	1		POINT (-73.9639431360458 40.7908677445466)
3020	-73.97040158596391	40.7825600069973	19A-PM-1013-05	19A	PM	10132018	5	Adult	Gray	White	Gray+White		Ground Plane	FALSE		0	0	0	0	1		0	0	0	1	0		POINT (-73.9704015859639 40.7825600069973)
3021	-73.96658719935171	40.783677506488296	22D-PM-1012-07	22D	PM	10122018	7	Adult	Gray	Black, Cinnamon, White	Gray+Black, Cinnamon, White		Ground Plane	FALSE		0	0	0	1	1		0	0	0	1	0		POINT (-73.9665871993517 40.7836775064883)
3022	-73.9639941227864	40.7899152327912	29B-PM-1010-02	29B	PM	10102018	2		Gray	Cinnamon, White	Gray+Cinnamon, White		Ground Plane	FALSE		0	0	0	1	0		0	0	0	1	0		POINT (-73.9639941227864 40.7899152327912)