2018_Central_Park_Squirrel_Census_-_Squirrel_Data

41 rows where Date = 10072018, Foraging = 0, Highlight Fur Color = "Cinnamon" and Running = 0

- remove filter - 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

= != contains ends with starts with > ≥ < ≤ like not like glob in not in array contains date is null is not null is blank is not blank

- remove filter - 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

= != contains ends with starts with > ≥ < ≤ like not like glob in not in array contains date is null is not null is blank is not blank

- remove filter - 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

= != contains ends with starts with > ≥ < ≤ like not like glob in not in array contains date is null is not null is blank is not blank

- remove filter - 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

= != contains ends with starts with > ≥ < ≤ like not like glob in not in array contains date is null is not null is blank is not blank

- column - 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

= != contains ends with starts with > ≥ < ≤ like not like glob in not in array contains date is null is not null is blank is not blank

Sort... Sort by rowid Sort by longitude Sort by latitude Sort by Unique Squirrel ID Sort by Hectare Sort by Shift Sort by Date Sort by Hectare Squirrel Number Sort by Age Sort by Primary Fur Color Sort by Highlight Fur Color Sort by Combination of Primary and Highlight Color Sort by Color notes Sort by Location Sort by Above Ground Sighter Measurement Sort by Specific Location Sort by Running Sort by Chasing Sort by Climbing Sort by Eating Sort by Foraging Sort by Other Activities Sort by Kuks Sort by Quaas Sort by Moans Sort by Tail flags Sort by Tail twitches Sort by Approaches Sort by Indifferent Sort by Runs from Sort by Other Interactions Sort by Lat/Long

descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Hectare, Shift, Hectare Squirrel Number, Age, Location, Above Ground Sighter Measurement, Specific Location, Chasing, Climbing, Eating, Other Activities, Kuks, Quaas, Tail flags, Tail twitches, Approaches, Indifferent, Runs from

Link	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
38	38	-73.9742073452913	40.7757957380463	12B-AM-1007-01	12B	AM	10072018	1	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	1	0	0	0		0	0	0	1	0	0	1	0		POINT (-73.9742073452913 40.7757957380463)
57	57	-73.9690175838534	40.77604327200171	14F-AM-1007-05	14F	AM	10072018	5	Juvenile	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	0	0	1	0		0	0	0	0	0	0	1	0		POINT (-73.9690175838534 40.7760432720017)
65	65	-73.9741824992294	40.7689486657963	5F-PM-1007-03	05F	PM	10072018	3	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	0	0	0	0	hiding nut	0	0	0	0	1	0	1	0		POINT (-73.9741824992294 40.7689486657963)
94	94	-73.9641971813967	40.781353795943495	21G-PM-1007-01	21G	PM	10072018	1	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	0	0	1	0		0	0	0	1	0	0	1	0		POINT (-73.9641971813967 40.7813537959435)
136	136	-73.9528682507794	40.792580780830704	36I-PM-1007-13	36I	PM	10072018	13	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	0	0	1	0		0	0	0	0	1	1	0	0		POINT (-73.9528682507794 40.7925807808307)
234	234	-73.9741401377844	40.7758134257881	12B-AM-1007-02	12B	AM	10072018	2	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	1	0	0	0		0	0	0	1	0	0	1	0		POINT (-73.9741401377844 40.7758134257881)
433	433	-73.9558474701153	40.7913335515534	34H-AM-1007-01	34H	AM	10072018	1	Adult	Gray	Cinnamon	Gray+Cinnamon		Above Ground	40	tree	0	0	0	0	0		1	1	0	0	0	0	0	0		POINT (-73.9558474701153 40.7913335515534)
444	444	-73.96414623605409	40.7778316005464	18I-PM-1007-09	18I	PM	10072018	9	Adult	Gray	Cinnamon	Gray+Cinnamon		Above Ground	20		0	0	1	0	0	canoodling w/ 8	0	0	0	0	0	0	1	0		POINT (-73.9641462360541 40.7778316005464)
446	446	-73.9678774314725	40.7738535171265	12H-PM-1007-04	12H	PM	10072018	4		Gray	Cinnamon	Gray+Cinnamon					0	0	0	1	0	mushroom	0	0	0	0	0	0	1	0		POINT (-73.9678774314725 40.7738535171265)
484	484	-73.9666526554772	40.7756111718355	14H-AM-1007-02	14H	AM	10072018	2	Juvenile	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	0	0	0	0	sitting	0	0	0	0	0	0	1	0		POINT (-73.9666526554772 40.77561117183551)
505	505	-73.9677387336667	40.774269591199996	12H-PM-1007-02	12H	PM	10072018	2	Adult	Gray	Cinnamon	Gray+Cinnamon		Above Ground	10	in tree	0	0	1	1	0	peanuts	0	0	0	0	0	0	1	0		POINT (-73.9677387336667 40.7742695912)
553	553	-73.9638526062093	40.782693848993	22F-AM-1007-02	22F	AM	10072018	2	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	0	0	0	0	standing	0	0	0	0	0	0	1	0		POINT (-73.9638526062093 40.782693848993)
591	591	-73.95433237868879	40.7943086530436	37G-PM-1007-03	37G	PM	10072018	3	Adult	Gray	Cinnamon	Gray+Cinnamon		Above Ground	15		0	0	0	1	0	lying on belly on branch,eating big nut	0	0	0	0	0	0	0	0		POINT (-73.9543323786888 40.7943086530436)
613	613	-73.9688466874605	40.77379115598671	12G-PM-1007-05	12G	PM	10072018	5		Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	0	0	0	0		0	0	0	0	0	0	0	0		POINT (-73.9688466874605 40.7737911559867)
722	722	-73.9745953710328	40.7728284025195	8D-AM-1007-07	08D	AM	10072018	7	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	0	0	1	0		0	0	0	0	0	0	0	0		POINT (-73.9745953710328 40.7728284025195)
727	727	-73.9634563222926	40.780992836417	21G-PM-1007-04	21G	PM	10072018	4		Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	0	0	1	0		0	0	0	1	0	0	0	1		POINT (-73.9634563222926 40.780992836417)
733	733	-73.9764397550289	40.7737004557104	8B-AM-1007-01	08B	AM	10072018	1	Adult	Gray	Cinnamon	Gray+Cinnamon		Above Ground	10		0	0	1	0	0		0	0	0	0	1	0	1	0		POINT (-73.9764397550289 40.7737004557104)
942	942	-73.9533923917973	40.796170187476896	40G-AM-1007-01	40G	AM	10072018	1	Adult	Gray	Cinnamon	Gray+Cinnamon		Above Ground	25	large tree	0	0	1	1	0		0	0	0	0	0	0	1	0		POINT (-73.9533923917973 40.7961701874769)
1010	1010	-73.9689723590015	40.7756860990338	13F-AM-1007-01	13F	AM	10072018	1	Adult	Gray	Cinnamon	Gray+Cinnamon		Above Ground	20		0	0	1	0	0		0	0	0	0	0	0	1	0		POINT (-73.9689723590015 40.7756860990338)
1044	1044	-73.9693254080548	40.77616003271179	14F-AM-1007-01	14F	AM	10072018	1	Adult	Gray	Cinnamon	Gray+Cinnamon		Above Ground	30		0	0	1	0	0		0	0	0	0	0	0	1	0		POINT (-73.9693254080548 40.7761600327118)
1055	1055	-73.9632337134707	40.791468237073396	31B-PM-1007-01	31B	PM	10072018	1	Adult	Gray	Cinnamon	Gray+Cinnamon		Above Ground	10		0	1	1	0	0	chasing #2 and climbing tree w/ #2	0	0	0	0	0	0	0	1		POINT (-73.9632337134707 40.7914682370734)
1099	1099	-73.9761527947483	40.770960700253895	6C-AM-1007-06	06C	AM	10072018	6	Adult	Gray	Cinnamon	Gray+Cinnamon		Above Ground	7		0	0	1	0	0		0	0	0	0	0	0	0	0	disappeared when jogger ran by	POINT (-73.9761527947483 40.7709607002539)
1109	1109	-73.96781540330991	40.774278348448604	12H-PM-1007-01	12H	PM	10072018	1	Adult	Gray	Cinnamon	Gray+Cinnamon		Above Ground	10	in tree	0	0	0	1	0		0	0	0	0	0	0	0	0		POINT (-73.9678154033099 40.7742783484486)
1168	1168	-73.9779874405715	40.7730765377366	7A-PM-1007-02	07A	PM	10072018	2	Adult	Gray	Cinnamon	Gray+Cinnamon		Above Ground	10		0	0	1	0	0		0	0	0	0	0	0	0	0		POINT (-73.9779874405715 40.7730765377366)
1208	1208	-73.96628049257741	40.7890284642399	28A-PM-1007-01	28A	PM	10072018	1	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	0	0	1	0		0	0	0	0	0	0	1	0		POINT (-73.9662804925774 40.7890284642399)
1300	1300	-73.964280573021	40.777830911491	18I-PM-1007-08	18I	PM	10072018	8	Adult	Gray	Cinnamon	Gray+Cinnamon		Above Ground	20		0	1	1	0	0	canoodling w/ #9	0	0	0	0	0	0	1	0		POINT (-73.964280573021 40.777830911491)
1431	1431	-73.9601918930677	40.7944134683406	35C-AM-1007-01	35C	AM	10072018	1	Juvenile	Gray	Cinnamon	Gray+Cinnamon		Above Ground	20	(white oak)	0	0	0	0	0	sitting still	0	0	0	0	0	0	0	0		POINT (-73.9601918930677 40.7944134683406)
1668	1668	-73.97469348106671	40.7659431884158	2G-PM-1007-02	02G	PM	10072018	2	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	0	0	0	0	burying nut	0	0	0	0	1	0	1	0		POINT (-73.9746934810667 40.7659431884158)
1698	1698	-73.9631392113757	40.791463563578404	31B-PM-1007-02	31B	PM	10072018	2	Adult	Gray	Cinnamon	Gray+Cinnamon		Above Ground	10		0	1	1	0	0	chasing #1 and climbing tree w/ #1	0	0	0	0	0	0	0	1		POINT (-73.9631392113757 40.7914635635784)
1862	1862	-73.97648512317541	40.771573686286104	6C-AM-1007-07	06C	AM	10072018	7	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	0	1	0	0	ambling	0	0	0	0	0	1	0	1	trucks	POINT (-73.9764851231754 40.7715736862861)
1948	1948	-73.9738410069766	40.7691686156505	5F-PM-1007-06	05F	PM	10072018	6	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	0	0	0	0	jumping on fence	0	0	0	0	1	0	1	0		POINT (-73.9738410069766 40.7691686156505)
1949	1949	-73.9605362268777	40.7939470599346	35C-AM-1007-02	35C	AM	10072018	2	Adult	Gray	Cinnamon	Gray+Cinnamon		Above Ground	13		0	0	1	0	0		0	0	0	0	0	0	0	1		POINT (-73.9605362268777 40.7939470599346)
1963	1963	-73.96515918613991	40.781183828857	20F-PM-1007-06	20F	PM	10072018	6	Juvenile	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	0	0	1	0		0	0	0	0	0	0	1	0		POINT (-73.9651591861399 40.781183828857)
2074	2074	-73.9676246014119	40.786355136088	24A-PM-1007-05	24A	PM	10072018	5	Juvenile	Gray	Cinnamon	Gray+Cinnamon		Above Ground	45	in tree	0	0	1	0	0		0	0	0	0	0	0	0	0		POINT (-73.9676246014119 40.786355136088)
2350	2350	-73.9564777440695	40.7993068355401	42C-AM-1007-01	42C	AM	10072018	1	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	0	0	0	0	nut in mouth	0	0	0	0	0	0	0	1		POINT (-73.9564777440695 40.7993068355401)
2382	2382	-73.97439704555329	40.7687880243986	5F-PM-1007-01	05F	PM	10072018	1	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	0	0	1	0		0	0	0	0	1	0	1	0		POINT (-73.9743970455533 40.7687880243986)
2463	2463	-73.9653343572865	40.77752869246171	17H-PM-1007-01	17H	PM	10072018	1	Adult	Gray	Cinnamon	Gray+Cinnamon		Above Ground	4		0	0	1	1	0		0	0	0	1	0	0	0	1		POINT (-73.9653343572865 40.7775286924617)
2472	2472	-73.9596820155238	40.7932886803231	34D-PM-1007-03	34D	PM	10072018	3	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	0	0	1	0		0	0	0	0	1	0	0	1		POINT (-73.9596820155238 40.7932886803231)
2491	2491	-73.98069052596709	40.76811522108579	1A-AM-1007-03	01A	AM	10072018	3	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	0	0	0	0	looking in bush	0	0	0	0	0	0	1	0		POINT (-73.9806905259671 40.7681152210858)
2626	2626	-73.9737329655838	40.7726424441344	8D-PM-1007-02	08D	PM	10072018	2	Adult	Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	0	0	1	0		0	0	0	0	0	0	1	0		POINT (-73.9737329655838 40.7726424441344)
2954	2954	-73.9677474313377	40.7742119240825	12H-PM-1007-03	12H	PM	10072018	3		Gray	Cinnamon	Gray+Cinnamon		Ground Plane	FALSE		0	0	0	1	0	peanuts	0	0	0	0	0	0	1	0		POINT (-73.9677474313377 40.7742119240825)

CREATE TABLE "2018_Central_Park_Squirrel_Census_-_Squirrel_Data" (
"longitude" REAL,
  "latitude" REAL,
  "Unique Squirrel ID" TEXT,
  "Hectare" TEXT,
  "Shift" TEXT,
  "Date" INTEGER,
  "Hectare Squirrel Number" INTEGER,
  "Age" TEXT,
  "Primary Fur Color" TEXT,
  "Highlight Fur Color" TEXT,
  "Combination of Primary and Highlight Color" TEXT,
  "Color notes" TEXT,
  "Location" TEXT,
  "Above Ground Sighter Measurement" TEXT,
  "Specific Location" TEXT,
  "Running" INTEGER,
  "Chasing" INTEGER,
  "Climbing" INTEGER,
  "Eating" INTEGER,
  "Foraging" INTEGER,
  "Other Activities" TEXT,
  "Kuks" INTEGER,
  "Quaas" INTEGER,
  "Moans" INTEGER,
  "Tail flags" INTEGER,
  "Tail twitches" INTEGER,
  "Approaches" INTEGER,
  "Indifferent" INTEGER,
  "Runs from" INTEGER,
  "Other Interactions" TEXT,
  "Lat/Long" TEXT
);