squirrels

Custom SQL query returning 23 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 "Date" = :p0 and "Highlight Fur Color" = :p1 order by [Unique Squirrel ID] 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	Location	Above Ground Sighter Measurement	Specific Location	Running	Chasing	Climbing	Eating	Foraging	Other Activities	Kuks	Quaas	Tail twitches	Approaches	Indifferent	Runs from	Lat/Long
2999	-73.972415182837	40.773080463452004	10E-AM-1010-02	10E	AM	10102018	2	Adult	Black	Gray	Black+Gray	Ground Plane	FALSE		1	0	0	0	1		0	0	1	0	1	0	POINT (-73.972415182837 40.773080463452)
2739	-73.9681960138614	40.7726867422002	11H-AM-1010-02	11H	AM	10102018	2		Cinnamon	Gray	Cinnamon+Gray				0	0	0	1	0		0	0	1	0	1	0	POINT (-73.9681960138614 40.7726867422002)
2799	-73.96826273820729	40.773076674345205	11H-AM-1010-09	11H	AM	10102018	9	Adult	Cinnamon	Gray	Cinnamon+Gray	Ground Plane	FALSE		1	0	0	0	0		0	0	0	0	0	0	POINT (-73.9682627382073 40.7730766743452)
745	-73.9671640520938	40.7772236833816	16G-AM-1010-02	16G	AM	10102018	2	Adult	Cinnamon	Gray	Cinnamon+Gray	Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	1	0	POINT (-73.9671640520938 40.7772236833816)
2404	-73.96653096896159	40.7775271020244	16G-AM-1010-04	16G	AM	10102018	4	Adult	Cinnamon	Gray	Cinnamon+Gray	Ground Plane	FALSE		0	0	1	0	0		0	0	0	0	1	0	POINT (-73.9665309689616 40.7775271020244)
1816	-73.9710187505339	40.7797265666746	17B-AM-1010-02	17B	AM	10102018	2	Adult	Cinnamon	Gray	Cinnamon+Gray	Ground Plane	FALSE		0	0	0	0	1		0	0	1	0	1	0	POINT (-73.9710187505339 40.7797265666746)
1492	-73.9807078515193	40.768333529264204	2A-AM-1010-04	02A	AM	10102018	4	Adult	Cinnamon	Gray	Cinnamon+Gray	Ground Plane	FALSE		0	0	0	1	1		0	0	1	0	1	0	POINT (-73.9807078515193 40.7683335292642)
391	-73.97908754803579	40.767610478065706	2C-AM-1010-03	02C	AM	10102018	3	Adult	Black	Gray	Black+Gray	Above Ground	30		0	0	1	0	0		0	0	0	0	0	0	POINT (-73.9790875480358 40.7676104780657)
534	-73.9650499507011	40.7908191782173	30A-AM-1010-01	30A	AM	10102018	1	Adult	Cinnamon	Gray	Cinnamon+Gray	Above Ground	10		1	0	1	0	0		0	0	1	0	0	1	POINT (-73.9650499507011 40.7908191782173)
2912	-73.9632164738341	40.7921270121312	32B-PM-1010-03	32B	PM	10102018	3	Adult	Cinnamon	Gray	Cinnamon+Gray	Above Ground	15		0	0	0	1	0		0	0	0	0	0	0	POINT (-73.9632164738341 40.7921270121312)
2523	-73.9619016393127	40.792516012692104	33B-PM-1010-06	33B	PM	10102018	6	Adult	Cinnamon	Gray	Cinnamon+Gray	Ground Plane	FALSE		0	0	0	0	1		0	0	0	1	0	0	POINT (-73.9619016393127 40.7925160126921)
2461	-73.9605347462123	40.794207544838706	35B-AM-1010-04	35B	AM	10102018	4	Adult	Cinnamon	Gray	Cinnamon+Gray	Ground Plane	FALSE	lawn	0	0	0	0	1		0	0	0	0	1	0	POINT (-73.9605347462123 40.7942075448387)
1253	-73.9527227282134	40.7935061484064	37I-AM-1010-03	37I	AM	10102018	3	Adult	Cinnamon	Gray	Cinnamon+Gray	Above Ground	4	in tree	0	0	1	0	0		0	0	0	0	1	0	POINT (-73.9527227282134 40.7935061484064)
557	-73.97921538931459	40.7688272492961	3B-AM-1010-01	03B	AM	10102018	1	Adult	Cinnamon	Gray	Cinnamon+Gray	Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	1	0	POINT (-73.9792153893146 40.7688272492961)
1799	-73.978844141973	40.7696046074378	4B-AM-1010-05	04B	AM	10102018	5	Adult	Cinnamon	Gray	Cinnamon+Gray	Above Ground	10		0	1	0	0	0	chasing squirrel #6	1	1	1	0	0	0	POINT (-73.978844141973 40.7696046074378)
1909	-73.9772070122251	40.7694343352509	4C-PM-1010-02	04C	PM	10102018	2	Adult	Cinnamon	Gray	Cinnamon+Gray	Ground Plane	FALSE		1	0	0	0	1		0	0	0	0	1	0	POINT (-73.97720701222511 40.7694343352509)
1448	-73.9772810073685	40.7693577540392	4C-PM-1010-03	04C	PM	10102018	3	Adult	Cinnamon	Gray	Cinnamon+Gray	Ground Plane	FALSE		0	1	0	0	1		0	0	0	0	1	0	POINT (-73.9772810073685 40.7693577540392)
1822	-73.9775099290913	40.76976090631371	4C-PM-1010-14	04C	PM	10102018	14	Juvenile	Cinnamon	Gray	Cinnamon+Gray	Ground Plane	FALSE		1	1	0	0	0	chasing #15	0	0	0	0	0	0	POINT (-73.9775099290913 40.7697609063137)
1226	-73.97684509716998	40.7709430375069	5C-PM-1010-07	05C	PM	10102018	7	Adult	Cinnamon	Gray	Cinnamon+Gray	Above Ground	13		0	1	0	0	0		0	0	0	0	0	0	POINT (-73.97684509717 40.7709430375069)
19	-73.9768603630674	40.7702795904962	5C-PM-1010-09	05C	PM	10102018	9	Adult	Cinnamon	Gray	Cinnamon+Gray	Ground Plane	FALSE		1	0	0	0	0		0	0	0	0	0	0	POINT (-73.9768603630674 40.7702795904962)
625	-73.9764235373322	40.770606513989	5C-PM-1010-11	05C	PM	10102018	11	Adult	Cinnamon	Gray	Cinnamon+Gray	Ground Plane	FALSE		0	0	1	0	1		0	0	0	0	0	0	POINT (-73.97642353733221 40.770606513989)
1505	-73.9733461334967	40.7684314285151	5G-PM-1010-01	05G	PM	10102018	1	Adult	Cinnamon	Gray	Cinnamon+Gray	Ground Plane	FALSE		0	0	0	1	1		0	0	0	0	1	0	POINT (-73.9733461334967 40.7684314285151)
968	-73.9689781843873	40.7709333833783	9I-PM-1010-04	09I	PM	10102018	4	Adult	Cinnamon	Gray	Cinnamon+Gray	Ground Plane	FALSE		0	0	0	0	1		0	0	0	0	0	1	POINT (-73.9689781843873 40.7709333833783)