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 Spp Translation Table May2023

@kaggle.joebeachcapital_project_feederwatch.pfw_spp_translation_table_may2023

52.89 KB
1090 rows
7 columns

species_code Species Code	alt_full_spp_code Alt Full Spp Code	n_locations N Locations	scientific_name Scientific Name	american_english_name American English Name	taxonomy_version Taxonomy Version	taxonomic_sort_order Taxonomic Sort Order
grerhe1	nan	1	Rhea americana	Greater Rhea	2022	10
gretin1	nan	3	Tinamus major	Great Tinamou	2022	42
wfwduc1	nan	1	Dendrocygna viduata	White-faced Whistling-Duck	2022	228
bbwduc	nan	105	Dendrocygna autumnalis	Black-bellied Whistling-Duck	2022	230
fuwduc	nan	2	Dendrocygna bicolor	Fulvous Whistling-Duck	2022	235
snogoo	nan	140	Anser caerulescens	Snow Goose	2022	252
rosgoo	nan	5	Anser rossii	Ross's Goose	2022	256
swagoo2	swagoo1	1	Anser cygnoides (Domestic type)	Swan Goose (Domestic type)	2022	265
gwfgoo	nan	13	Anser albifrons	Greater White-fronted Goose	2022	267
gwfgoo2	gwfgoo	1	Anser albifrons gambelli/sponsa	Greater White-fronted Goose (Western)	2022	270


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