Project FeederWatch

A November-April survey of birds that visit backyards, nature centers, etc.

@kaggle.joebeachcapital_project_feederwatch

Table List

8 tables(165.91 MB)

Pfw 2021 Public

Pfw Count Site Data Public 2021

Pfw All 1988–1995 June2023 Public

Pfw All 1996–2000 June2023 Public

Pfw All 2001–2005 June2023 Public

Pfw All 2006–2010 June2023 Public

Pfw Count Site Data Public June2023

Pfw Spp Translation Table May2023

Pfw 2021 Public

@kaggle.joebeachcapital_project_feederwatch.pfw_2021_public

3.16 MB
100000 rows
22 columns

loc_id Loc Id	latitude Latitude	longitude Longitude	subnational1_code Subnational1 Code	entry_technique Entry Technique	sub_id Sub Id	obs_id Obs Id	month Month	day Day	year Year	proj_period_id PROJ PERIOD ID	species_code Species Code	how_many How Many	valid Valid	day1_am Day1 Am	day1_pm Day1 Pm	day2_am Day2 Am	day2_pm Day2 Pm	effort_hrs_atleast Effort Hrs Atleast	snow_dep_atleast Snow Dep Atleast	data_entry_method Data Entry Method
L981010	52.12976	-122.13547	CA-BC	POSTCODE LAT/LONG LOOKUP	S83206450	OBS1092604618	3	4	2021	PFW_2021	amegfi	20	1	1		1		1.001	5	PFW Web 4.1.4
L3161698	43.8322069	-123.092405	US-OR	/GOOGLE_MAP/ZOOM:18	S78031190	OBS1036509564	12	19	2020	PFW_2021	moudov	11	1	1	1	1	1	1.001		PFW Web 4.1.4
L13210778	39.7214697	-75.9336597	US-MD	/GOOGLE_MAP/ZOOM:15	S81318993	OBS1073386105	2	13	2021	PFW_2021	tuftit	2	1	1	1	1	1	8.001	5	PFW Web 4.1.4
L13258348	42.2178739	-83.6722998	US-MI	/GOOGLE_MAP/ZOOM:15	S79251313	OBS1051702542	1	13	2021	PFW_2021	houspa	2	1	1	1	1	1	4.001		PFW Web 4.1.4
L149639	32.7499211	-79.9415821	US-SC	PointMaker1.0_2	S79183993	OBS1050809672	1	11	2021	PFW_2021	balori	10	1	1	1	1	1	1.001		PFW Web 4.1.4
L10140349	46.053008	-73.0702722	CA-QC	/GOOGLE_MAP/ZOOM:18	S83449147	OBS1095479883	3	13	2021	PFW_2021	norcar	2	1	1	1	1	1	1.001	15.001	PFW Web 4.1.4
L74629	37.7113765	-122.0745566	US-CA	POSTCODE LAT/LONG LOOKUP	S85555888	OBS1121406888	1	23	2021	PFW_2021	pinsis	5	1	1	1	1	1	0.001		PFW Web 4.1.4
L162342	40.242817	-76.13628	US-PA	POSTCODE LAT/LONG LOOKUP	S86340705	OBS1131766383	4	23	2021	PFW_2021	brnthr	2		1	1	1	1	4.001		PFW Web 4.1.4
L189158	40.9467697	-73.0295105	US-NY	PointMaker1.0_2	S80199248	OBS1063201047	11	28	2020	PFW_2021	whtspa	6	1	1	1	1	1	1.001		PFW Web 4.1.4
L19251	56.2820309	-120.8336922	CA-BC	POSTCODE LAT/LONG LOOKUP	S86496546	OBS1133802647	1	2	2021	PFW_2021	pingro	9	1	1	1	1	1	1.001	15.001	PFW Web 4.1.4


CREATE TABLE pfw_2021_public (
  "loc_id" VARCHAR,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "subnational1_code" VARCHAR,
  "entry_technique" VARCHAR,
  "sub_id" VARCHAR,
  "obs_id" VARCHAR,
  "month" BIGINT,
  "day" BIGINT,
  "year" BIGINT,
  "proj_period_id" VARCHAR,
  "species_code" VARCHAR,
  "how_many" BIGINT,
  "valid" BIGINT,
  "reviewed" BIGINT,
  "day1_am" BIGINT,
  "day1_pm" BIGINT,
  "day2_am" BIGINT,
  "day2_pm" BIGINT,
  "effort_hrs_atleast" DOUBLE,
  "snow_dep_atleast" DOUBLE,
  "data_entry_method" VARCHAR
);