2018_Central_Park_Squirrel_Census_-_Squirrel_Data

56 rows where Climbing = 0, Date = 10072018, Foraging = 0 and Indifferent = 1

- 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, Primary Fur Color, Highlight Fur Color, Combination of Primary and Highlight Color, Location, Above Ground Sighter Measurement, Running, Chasing, Eating, Other Activities, Kuks, Tail flags, Tail twitches

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
25	25	-73.96711306801141	40.7784859700171	17F-AM-1007-07	17F	AM	10072018	7	Adult	Gray	White	Gray+White		Above Ground	24		1	0	0	0	0		0	0	0	1	0	0	1	0		POINT (-73.9671130680114 40.7784859700171)
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)
115	115	-73.9530040923555	40.7922896176936	36I-PM-1007-10	36I	PM	10072018	10	Juvenile	Gray	White	Gray+White		Ground Plane	FALSE		0	0	0	1	0	stole (found?) an entire sandwich	0	0	0	0	0	0	1	0		POINT (-73.9530040923555 40.7922896176936)
163	163	-73.97123088643941	40.7714534847379	9G-AM-1007-04	09G	AM	10072018	4	Adult	Gray	White	Gray+White		Above Ground	15		0	0	0	0	0	grooming	0	0	0	0	0	0	1	0		POINT (-73.9712308864394 40.7714534847379)
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)
269	269	-73.9591400366159	40.7891708599318	31F-PM-1007-01	31F	PM	10072018	1	Adult	Gray	White	Gray+White	white neck and belly	Ground Plane	FALSE		0	0	0	0	0		0	0	0	0	0	0	1	0		POINT (-73.9591400366159 40.7891708599318)
319	319	-73.96590343597059	40.779751668884394	19F-AM-1007-02	19F	AM	10072018	2	Adult	Cinnamon	Gray	Cinnamon+Gray		Above Ground	8		0	0	0	1	0		0	0	0	0	0	0	1	0		POINT (-73.9659034359706 40.77975166888441)
406	406	-73.97663549671971	40.7734575166319	8B-AM-1007-09	08B	AM	10072018	9	Adult	Gray		Gray+		Ground Plane	FALSE		1	0	0	1	0	shelling and eating a nut then a dog chased it up a tree & squirrel carried its nut up the tree,settled in a branch & resumed eating	0	0	0	0	0	0	1	0		POINT (-73.9766354967197 40.7734575166319)
407	407	-73.9787658435198	40.768941976539296	3B-PM-1007-07	03B	PM	10072018	7	Adult	Gray	White	Gray+White		Ground Plane	FALSE		0	0	0	1	0	eating loudly <- peanuts w/ shells	0	0	0	0	0	0	1	0		POINT (-73.9787658435198 40.7689419765393)
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)
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)
575	575	-73.9783366903829	40.7668300056094	1D-PM-1007-03	01D	PM	10072018	3	Adult	Gray	White	Gray+White		Ground Plane	FALSE		0	1	0	0	0		0	0	0	0	0	0	1	0		POINT (-73.9783366903829 40.7668300056094)
610	610	-73.96715495660659	40.7751342870705	14H-AM-1007-01	14H	AM	10072018	1	Adult	Gray		Gray+		Above Ground	180	top of tree	1	0	0	0	0	jumping between branches	0	0	0	0	0	0	1	0		POINT (-73.9671549566066 40.7751342870705)
616	616	-73.9556937218252	40.7990928062435	42C-AM-1007-04	42C	AM	10072018	4	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White	young adult	Ground Plane	FALSE		0	0	0	0	0	walking	0	0	0	0	0	0	1	0		POINT (-73.9556937218252 40.7990928062435)
660	660	-73.9638298997554	40.78259663323671	22F-AM-1007-03	22F	AM	10072018	3	Adult	Cinnamon	Gray, White	Cinnamon+Gray, White	large white highlight	Ground Plane	FALSE		0	0	0	1	0		0	0	0	0	0	0	1	0		POINT (-73.9638298997554 40.7825966332367)
725	725	-73.9689627791	40.776062004359005	14F-AM-1007-06	14F	AM	10072018	6	Juvenile	Gray	Cinnamon, White	Gray+Cinnamon, White		Ground Plane	FALSE		0	1	0	0	0		0	0	0	0	0	0	1	0		POINT (-73.9689627791 40.776062004359)
741	741	-73.9790214253443	40.7686791169776	3B-PM-1007-10	03B	PM	10072018	10	Adult	Gray	White	Gray+White		Ground Plane	FALSE		0	0	0	1	0	hopping	0	0	0	0	0	0	1	0		POINT (-73.9790214253443 40.7686791169776)
799	799	-73.9529413156461	40.7920963446605	36I-PM-1007-06	36I	PM	10072018	6	Adult	Cinnamon	Gray, White	Cinnamon+Gray, White		Ground Plane	FALSE		0	0	0	1	0		0	0	0	0	0	0	1	0		POINT (-73.9529413156461 40.7920963446605)
928	928	-73.96704295859901	40.778437071937105	17F-AM-1007-05	17F	AM	10072018	5	Juvenile	Cinnamon	Gray	Cinnamon+Gray		Ground Plane	FALSE		1	0	0	1	0		0	0	0	1	0	0	1	0		POINT (-73.967042958599 40.7784370719371)
936	936	-73.9684758245091	40.7858531619022	24A-PM-1007-02	24A	PM	10072018	2	Adult	Gray		Gray+		Ground Plane	FALSE		1	0	0	0	0		0	0	0	0	0	0	1	0		POINT (-73.9684758245091 40.7858531619022)
1068	1068	-73.96660639702	40.7756655031741	14H-AM-1007-03	14H	AM	10072018	3	Juvenile	Gray	Cinnamon, White	Gray+Cinnamon, White		Ground Plane	FALSE		0	1	0	0	0		0	0	0	0	0	0	1	0		POINT (-73.96660639702002 40.7756655031741)
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)
1217	1217	-73.9764850086767	40.7737340720562	8B-AM-1007-07	08B	AM	10072018	7	Juvenile	Gray	Black	Gray+Black		Above Ground	8		0	0	0	1	0	holding nut	0	0	0	0	0	0	1	0		POINT (-73.9764850086767 40.7737340720562)
1325	1325	-73.97752788478971	40.7687881061059	3C-AM-1007-02	03C	AM	10072018	2	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White		Ground Plane	FALSE		1	0	0	0	0		0	0	0	0	0	0	1	0		POINT (-73.9775278847897 40.7687881061059)
1418	1418	-73.9673924060436	40.7788781851716	17F-AM-1007-03	17F	AM	10072018	3	Adult	Cinnamon	White	Cinnamon+White		Ground Plane	FALSE		1	0	0	0	0		0	0	0	0	0	0	1	0		POINT (-73.9673924060436 40.7788781851716)
1546	1546	-73.976422624924	40.7735818387346	8B-AM-1007-08	08B	AM	10072018	8	Adult	Gray		Gray+		Above Ground	6		0	0	0	1	0	holding nut	0	0	0	0	0	0	1	0		POINT (-73.976422624924 40.7735818387346)
1570	1570	-73.96628648847891	40.7891062338302	28A-PM-1007-02	28A	PM	10072018	2	Adult	Gray		Gray+		Ground Plane	FALSE		1	0	0	0	0	running from #3	0	0	0	0	0	0	1	0		POINT (-73.9662864884789 40.7891062338302)
1590	1590	-73.9610388059192	40.793952935840004	34B-PM-1007-01	34B	PM	10072018	1	Adult	Gray	White	Gray+White		Ground Plane	FALSE		1	0	0	0	0		0	0	0	0	0	0	1	0		POINT (-73.9610388059192 40.79395293584)
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)
1743	1743	-73.9635412640983	40.7902529354639	30B-AM-1007-11	30B	AM	10072018	11	Adult	Gray		Gray+		Ground Plane	FALSE		0	0	0	1	0		0	0	0	0	0	0	1	0		POINT (-73.9635412640983 40.7902529354639)
1750	1750	-73.9684806250183	40.7858776210151	24A-PM-1007-03	24A	PM	10072018	3	Adult	Gray		Gray+		Ground Plane	FALSE		1	0	0	0	0		0	0	0	0	0	0	1	0		POINT (-73.9684806250183 40.7858776210151)
1847	1847	-73.9782283921819	40.766793260207706	1D-PM-1007-02	01D	PM	10072018	2	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White		Ground Plane	FALSE		0	1	0	0	0		0	0	0	0	0	0	1	0		POINT (-73.9782283921819 40.7667932602077)
1929	1929	-73.9646023053207	40.7810680044024	20F-PM-1007-14	20F	PM	10072018	14	Adult	Gray	White	Gray+White		Ground Plane	FALSE		0	0	0	1	0		0	0	0	0	0	0	1	0		POINT (-73.9646023053207 40.78106800440241)
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)
1954	1954	-73.9794840520702	40.7709595369804	4A-PM-1007-02	04A	PM	10072018	2	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White		Ground Plane	FALSE		1	0	0	0	0		0	0	0	0	0	0	1	0		POINT (-73.9794840520702 40.770959536980406)
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)
1969	1969	-73.96890514730721	40.7764511282884	14F-AM-1007-04	14F	AM	10072018	4	Adult	Gray	Black, Cinnamon, White	Gray+Black, Cinnamon, White		Ground Plane	FALSE		1	0	0	0	0		0	0	0	0	0	0	1	0		POINT (-73.9689051473072 40.7764511282884)
2026	2026	-73.9622752768962	40.7814921913101	22H-PM-1007-02	22H	PM	10072018	2	Adult	Cinnamon	Gray	Cinnamon+Gray		Above Ground	4	low branch	0	0	0	0	0	watching me scratching	1	0	0	1	0	0	1	0		POINT (-73.9622752768962 40.7814921913101)
2031	2031	-73.9795454787631	40.768802689274104	3B-PM-1007-09	03B	PM	10072018	9	Adult			+					0	0	0	0	0		0	0	0	0	0	0	1	0		POINT (-73.9795454787631 40.7688026892741)
2111	2111	-73.968446056806	40.785824818871	24A-PM-1007-01	24A	PM	10072018	1	Adult	Gray	White	Gray+White		Ground Plane	FALSE		1	0	0	0	0		0	0	0	0	0	0	1	0		POINT (-73.96844605680602 40.785824818871)
2141	2141	-73.97870151846621	40.7690114585688	3B-PM-1007-06	03B	PM	10072018	6	Juvenile			+					0	0	0	1	0		0	0	0	0	0	0	1	0		POINT (-73.9787015184662 40.7690114585688)
2167	2167	-73.9799594281222	40.7701978146968	4A-AM-1007-05	04A	AM	10072018	5	Adult	Gray		Gray+		Ground Plane	FALSE		0	0	0	1	0		0	0	0	0	0	0	1	0		POINT (-73.9799594281222 40.7701978146968)
2208	2208	-73.96149727573321	40.7921404951324	33C-PM-1007-02	33C	PM	10072018	2	Adult	Gray	Black, White	Gray+Black, White		Ground Plane	FALSE		0	0	0	1	0		0	0	0	0	0	0	1	0		POINT (-73.9614972757332 40.7921404951324)
2227	2227	-73.9792814244424	40.770503194056	4A-AM-1007-04	04A	AM	10072018	4	Adult	Gray		Gray+		Ground Plane	FALSE		0	0	0	0	0		0	0	0	0	0	0	1	0		POINT (-73.9792814244424 40.770503194056)
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)
2402	2402	-73.9777206733344	40.7668595585487	1D-PM-1007-07	01D	PM	10072018	7	Adult	Gray		Gray+		Ground Plane	FALSE		0	0	0	0	0	lying down	0	0	0	0	0	0	1	0		POINT (-73.9777206733344 40.7668595585487)
2478	2478	-73.96749310703241	40.778369369095394	17F-AM-1007-04	17F	AM	10072018	4	Adult	Cinnamon	White	Cinnamon+White		Above Ground	4		0	0	0	1	0	chilling	1	0	0	0	0	0	1	0		POINT (-73.9674931070324 40.7783693690954)
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)
2905	2905	-73.9784872728213	40.768812260393204	3C-AM-1007-01	03C	AM	10072018	1	Adult	Gray	Cinnamon, White	Gray+Cinnamon, White		Ground Plane	FALSE		1	0	0	0	0		0	0	0	0	0	0	1	0		POINT (-73.9784872728213 40.7688122603932)
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)
3004	3004	-73.9528482858163	40.7922056218325	36I-PM-1007-08	36I	PM	10072018	8	Juvenile	Cinnamon	Gray	Cinnamon+Gray		Ground Plane	FALSE		0	0	0	1	0		0	0	0	0	1	0	1	0		POINT (-73.9528482858163 40.7922056218325)

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
);