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 All 1996–2000 June2023 Public

@kaggle.joebeachcapital_project_feederwatch.pfw_all_1996_2000_june2023_public

26.99 MB
3001912 rows
24 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	alt_full_spp_code Alt Full Spp Code	how_many HOW MANY	valid VALID	data_entry_method Data Entry Method
L102954	43.0159963	-77.4657177	US-NY	PointMaker1.0_2	S352291	OBS7320031	11	16	1996	PFW_1997	houspa	nan	22	1	nan
L102954	43.0159963	-77.4657177	US-NY	PointMaker1.0_2	S352291	OBS7320029	11	16	1996	PFW_1997	haiwoo	nan	1	1	nan
L102954	43.0159963	-77.4657177	US-NY	PointMaker1.0_2	S352291	OBS7320030	11	16	1996	PFW_1997	houfin	nan	2	1	nan
L102954	43.0159963	-77.4657177	US-NY	PointMaker1.0_2	S352291	OBS6455317	11	16	1996	PFW_1997	dowwoo	nan	4	1	nan
L102954	43.0159963	-77.4657177	US-NY	PointMaker1.0_2	S352291	OBS6455318	11	16	1996	PFW_1997	daejun	nan	1	1	nan
L102954	43.0159963	-77.4657177	US-NY	PointMaker1.0_2	S352291	OBS5354998	11	16	1996	PFW_1997	blujay	nan	3	1	nan
L102954	43.0159963	-77.4657177	US-NY	PointMaker1.0_2	S352291	OBS5354999	11	16	1996	PFW_1997	bkcchi	nan	2	1	nan
L102954	43.0159963	-77.4657177	US-NY	PointMaker1.0_2	S352291	OBS8446933	11	16	1996	PFW_1997	rebwoo	nan	1	1	nan
L102954	43.0159963	-77.4657177	US-NY	PointMaker1.0_2	S352291	OBS9354873	11	16	1996	PFW_1997	whbnut	nan	2	1	nan
L102954	43.0159963	-77.4657177	US-NY	PointMaker1.0_2	S352291	OBS8070762	11	16	1996	PFW_1997	norcar	nan	5	1	nan


CREATE TABLE pfw_all_1996_2000_june2023_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,
  "alt_full_spp_code" VARCHAR,
  "how_many" DOUBLE,
  "plus_code" VARCHAR,
  "valid" DOUBLE,
  "reviewed" DOUBLE,
  "day1_am" DOUBLE,
  "day1_pm" DOUBLE,
  "day2_am" DOUBLE,
  "day2_pm" DOUBLE,
  "effort_hrs_atleast" DOUBLE,
  "snow_dep_atleast" DOUBLE,
  "data_entry_method" VARCHAR
);