Dataset: Project FeederWatch

About this Dataset

Project FeederWatch

Project FeederWatch is a November-April survey of birds that visit backyards, nature centers, community areas, and other locales in North America. Citizen scientists could birds in areas with plantings, habitat, water, or food that attracts birds. The schedule is completely flexible. People count birds as long as they like on days of their choosing, then enter their counts online. This allows anyone to track what is happening to birds around your home and to contribute to a continental data-set of bird distribution and abundance.

FeederWatch data show which bird species visit feeders at thousands of locations across the continent every winter. The data also indicate how many individuals of each species are seen. This information can be used to measure changes in the winter ranges and abundances of bird species over time.

Project FeederWatch is operated by the Cornell Lab of Ornithology and Birds Canada. Since 2016, Project FeederWatch has been sponsored by Wild Bird Unlimited.

Acknowledging FeederWatch.

The Cornell Lab of Ornithology and Birds Canada are committed to making data gathered through our citizen science programs freely accessible to students, journalists, and the general public."

"This unique dataset is completely dependent on the efforts of our network of volunteer participants. We ask that all data analysts give credit to the thousands of participants who have made FeederWatch possible, as well as to Birds Canada and the Cornell Lab of Ornithology for developing and managing the program."

More details on analyzing this dataset:
Over 30 Years of Standardized Bird Counts at Supplementary Feeding Stations in North America: A Citizen Science Data Report for Project FeederWatch by David N. Bonter and Emma I. Greig

Tables

Pfw 2021 Public

@kaggle.joebeachcapital_project_feederwatch.pfw_2021_public

3.16 MB
100000 rows
22 columns


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

Pfw Count Site Data Public 2021

@kaggle.joebeachcapital_project_feederwatch.pfw_count_site_data_public_2021

5.07 MB
254355 rows
62 columns


CREATE TABLE pfw_count_site_data_public_2021 (
  "loc_id" VARCHAR,
  "proj_period_id" VARCHAR,
  "yard_type_pavement" DOUBLE,
  "yard_type_garden" DOUBLE,
  "yard_type_landsca" DOUBLE,
  "yard_type_woods" DOUBLE,
  "yard_type_desert" DOUBLE,
  "hab_dcid_woods" DOUBLE,
  "hab_evgr_woods" DOUBLE,
  "hab_mixed_woods" DOUBLE,
  "hab_orchard" DOUBLE,
  "hab_park" DOUBLE,
  "hab_water_fresh" DOUBLE,
  "hab_water_salt" DOUBLE,
  "hab_residential" DOUBLE,
  "hab_industrial" DOUBLE,
  "hab_agricultural" DOUBLE,
  "hab_desert_scrub" DOUBLE,
  "hab_young_woods" DOUBLE,
  "hab_swamp" DOUBLE,
  "hab_marsh" DOUBLE,
  "evgr_trees_atleast" DOUBLE,
  "evgr_shrbs_atleast" DOUBLE,
  "dcid_trees_atleast" DOUBLE,
  "dcid_shrbs_atleast" DOUBLE,
  "fru_trees_atleast" DOUBLE,
  "cacti_atleast" DOUBLE,
  "brsh_piles_atleast" DOUBLE,
  "water_srcs_atleast" DOUBLE,
  "bird_baths_atleast" DOUBLE,
  "nearby_feeders" DOUBLE,
  "squirrels" DOUBLE,
  "cats" DOUBLE,
  "dogs" DOUBLE,
  "humans" DOUBLE,
  "housing_density" DOUBLE,
  "fed_yr_round" DOUBLE,
  "fed_in_jan" DOUBLE,
  "fed_in_feb" DOUBLE,
  "fed_in_mar" DOUBLE,
  "fed_in_apr" DOUBLE,
  "fed_in_may" DOUBLE,
  "fed_in_jun" DOUBLE,
  "fed_in_jul" DOUBLE,
  "fed_in_aug" DOUBLE,
  "fed_in_sep" DOUBLE,
  "fed_in_oct" DOUBLE,
  "fed_in_nov" DOUBLE,
  "fed_in_dec" DOUBLE,
  "numfeeders_suet" DOUBLE,
  "numfeeders_ground" DOUBLE,
  "numfeeders_hanging" DOUBLE,
  "numfeeders_platfrm" DOUBLE,
  "numfeeders_humming" DOUBLE,
  "numfeeders_water" DOUBLE,
  "numfeeders_thistle" DOUBLE,
  "numfeeders_fruit" DOUBLE,
  "numfeeders_hopper" DOUBLE,
  "numfeeders_tube" DOUBLE,
  "numfeeders_other" DOUBLE,
  "population_atleast" DOUBLE,
  "count_area_size_sq_m_atleast" DOUBLE
);

Pfw All 1988–1995 June2023 Public

@kaggle.joebeachcapital_project_feederwatch.pfw_all_1988_1995_june2023_public

25.9 MB
2950137 rows
24 columns


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

Pfw All 1996–2000 June2023 Public

@kaggle.joebeachcapital_project_feederwatch.pfw_all_1996_2000_june2023_public

26.99 MB
3001912 rows
24 columns


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

Pfw All 2001–2005 June2023 Public

@kaggle.joebeachcapital_project_feederwatch.pfw_all_2001_2005_june2023_public

43.57 MB
5248988 rows
24 columns


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

Pfw All 2006–2010 June2023 Public

@kaggle.joebeachcapital_project_feederwatch.pfw_all_2006_2010_june2023_public

51.71 MB
6238587 rows
24 columns


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

Pfw Count Site Data Public June2023

@kaggle.joebeachcapital_project_feederwatch.pfw_count_site_data_public_june2023

9.47 MB
284356 rows
66 columns


CREATE TABLE pfw_count_site_data_public_june2023 (
  "loc_id" VARCHAR,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "proj_period_id" VARCHAR,
  "yard_type_pavement" DOUBLE,
  "yard_type_garden" DOUBLE,
  "yard_type_landsca" DOUBLE,
  "yard_type_woods" DOUBLE,
  "yard_type_desert" DOUBLE,
  "hab_dcid_woods" VARCHAR,
  "hab_evgr_woods" VARCHAR,
  "hab_mixed_woods" VARCHAR,
  "hab_orchard" VARCHAR,
  "hab_park" VARCHAR,
  "hab_water_fresh" VARCHAR,
  "hab_water_salt" VARCHAR,
  "hab_residential" VARCHAR,
  "hab_industrial" VARCHAR,
  "hab_agricultural" VARCHAR,
  "hab_desert_scrub" VARCHAR,
  "hab_young_woods" VARCHAR,
  "hab_swamp" VARCHAR,
  "hab_marsh" VARCHAR,
  "evgr_trees_atleast" DOUBLE,
  "evgr_shrbs_atleast" DOUBLE,
  "dcid_trees_atleast" DOUBLE,
  "dcid_shrbs_atleast" DOUBLE,
  "fru_trees_atleast" DOUBLE,
  "cacti_atleast" DOUBLE,
  "brsh_piles_atleast" DOUBLE,
  "water_srcs_atleast" DOUBLE,
  "bird_baths_atleast" DOUBLE,
  "nearby_feeders" DOUBLE,
  "squirrels" DOUBLE,
  "cats" DOUBLE,
  "dogs" DOUBLE,
  "humans" DOUBLE,
  "housing_density" DOUBLE,
  "fed_yr_round" DOUBLE,
  "fed_in_jan" DOUBLE,
  "fed_in_feb" DOUBLE,
  "fed_in_mar" DOUBLE,
  "fed_in_apr" DOUBLE,
  "fed_in_may" DOUBLE,
  "fed_in_jun" DOUBLE,
  "fed_in_jul" DOUBLE,
  "fed_in_aug" DOUBLE,
  "fed_in_sep" DOUBLE,
  "fed_in_oct" DOUBLE,
  "fed_in_nov" DOUBLE,
  "fed_in_dec" DOUBLE,
  "numfeeders_suet" DOUBLE,
  "numfeeders_ground" DOUBLE,
  "numfeeders_hanging" DOUBLE,
  "numfeeders_platfrm" DOUBLE,
  "numfeeders_humming" DOUBLE,
  "numfeeders_water" DOUBLE,
  "numfeeders_thistle" DOUBLE,
  "numfeeders_fruit" DOUBLE,
  "numfeeders_hopper" DOUBLE,
  "numfeeders_tube" DOUBLE,
  "numfeeders_other" DOUBLE,
  "population_atleast" DOUBLE,
  "count_area_size_sq_m_atleast" DOUBLE,
  "create_dt" TIMESTAMP,
  "supp_food" DOUBLE
);

Pfw Spp Translation Table May2023

@kaggle.joebeachcapital_project_feederwatch.pfw_spp_translation_table_may2023

52.89 KB
1090 rows
7 columns


CREATE TABLE pfw_spp_translation_table_may2023 (
  "species_code" VARCHAR,
  "alt_full_spp_code" VARCHAR,
  "n_locations" BIGINT,
  "scientific_name" VARCHAR,
  "american_english_name" VARCHAR,
  "taxonomy_version" BIGINT,
  "taxonomic_sort_order" BIGINT
);