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 1988–1995 June2023 Public

@kaggle.joebeachcapital_project_feederwatch.pfw_all_1988_1995_june2023_public

25.9 MB
2950137 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	day1_am DAY1 AM	day1_pm DAY1 PM	day2_am DAY2 AM	day2_pm DAY2 PM	data_entry_method Data Entry Method
L103924	42.5574686	-83.1997153	US-MI	PointMaker1.0_2	S119768	OBS6669852	1	11	1992	PFW_1992	houfin	nan	4	1	1	1	1	1	nan
L103924	42.5574686	-83.1997153	US-MI	PointMaker1.0_2	S119768	OBS6669853	1	11	1992	PFW_1992	houspa	nan	26	1	1	1	1	1	nan
L103924	42.5574686	-83.1997153	US-MI	PointMaker1.0_2	S119768	OBS7763087	1	11	1992	PFW_1992	moudov	nan	5	1	1	1	1	1	nan
L103924	42.5574686	-83.1997153	US-MI	PointMaker1.0_2	S119768	OBS5875613	1	11	1992	PFW_1992	eursta	nan	35	1	1	1	1	1	nan
L103924	42.5574686	-83.1997153	US-MI	PointMaker1.0_2	S119768	OBS5875614	1	11	1992	PFW_1992	daejun	nan	2	1	1	1	1	1	nan
L103924	42.5574686	-83.1997153	US-MI	PointMaker1.0_2	S119768	OBS4316815	1	11	1992	PFW_1992	amecro	nan	3	1	1	1	1	1	nan
L103924	42.5574686	-83.1997153	US-MI	PointMaker1.0_2	S119768	OBS4316816	1	11	1992	PFW_1992	amegfi	nan	1	1	1	1	1	1	nan
L103924	42.5574686	-83.1997153	US-MI	PointMaker1.0_2	S119768	OBS8505640	1	11	1992	PFW_1992	rocpig1	rocpig	1	1	1	1	1	1	nan
L103924	42.5574686	-83.1997153	US-MI	PointMaker1.0_2	S119768	OBS4824346	1	11	1992	PFW_1992	blujay	nan	2	1	1	1	1	1	nan
L103924	42.5574686	-83.1997153	US-MI	PointMaker1.0_2	S119768	OBS4824347	1	11	1992	PFW_1992	bkcchi	nan	1	1	1	1	1	1	nan


CREATE TABLE pfw_all_1988_1995_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" DOUBLE,
  "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
);