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 2001–2005 June2023 Public

@kaggle.joebeachcapital_project_feederwatch.pfw_all_2001_2005_june2023_public

43.57 MB
5248988 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	effort_hrs_atleast EFFORT HRS ATLEAST	data_entry_method Data Entry Method
L100015	40.8518076	-73.6914612	US-NY	PointMaker1.0_2	S819488	OBS11880597	11	11	2001	PFW_2002	whbnut	nan	1	1	1	1	1	1	0.001	PFW Web 1.x
L100015	40.8518076	-73.6914612	US-NY	PointMaker1.0_2	S819488	OBS11880598	11	11	2001	PFW_2002	sonspa	nan	7	1	1	1	1	1	0.001	PFW Web 1.x
L100015	40.8518076	-73.6914612	US-NY	PointMaker1.0_2	S819488	OBS11880599	11	11	2001	PFW_2002	amegfi	nan	5	1	1	1	1	1	0.001	PFW Web 1.x
L100015	40.8518076	-73.6914612	US-NY	PointMaker1.0_2	S819488	OBS11880596	11	11	2001	PFW_2002	bkcchi	nan	2	1	1	1	1	1	0.001	PFW Web 1.x
L100015	40.8518076	-73.6914612	US-NY	PointMaker1.0_2	S820439	OBS11892361	11	17	2001	PFW_2002	bkcchi	nan	3	1	1	1	1	1	0.001	PFW Web 1.x
L100015	40.8518076	-73.6914612	US-NY	PointMaker1.0_2	S820439	OBS11892362	11	17	2001	PFW_2002	tuftit	nan	2	1	1	1	1	1	0.001	PFW Web 1.x
L100015	40.8518076	-73.6914612	US-NY	PointMaker1.0_2	S820439	OBS11892363	11	17	2001	PFW_2002	whbnut	nan	1	1	1	1	1	1	0.001	PFW Web 1.x
L100015	40.8518076	-73.6914612	US-NY	PointMaker1.0_2	S820439	OBS11892364	11	17	2001	PFW_2002	normoc	nan	1	1	1	1	1	1	0.001	PFW Web 1.x
L100015	40.8518076	-73.6914612	US-NY	PointMaker1.0_2	S820439	OBS11892365	11	17	2001	PFW_2002	amtspa	nan	5	1	1	1	1	1	0.001	PFW Web 1.x
L100015	40.8518076	-73.6914612	US-NY	PointMaker1.0_2	S820439	OBS11892366	11	17	2001	PFW_2002	amegfi	nan	5	1	1	1	1	1	0.001	PFW Web 1.x


CREATE TABLE pfw_all_2001_2005_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
);