{"id":46739,"date":"2022-12-09T00:00:00","date_gmt":"2022-12-09T08:00:00","guid":{"rendered":"https:\/\/griddb-linux-hte8hndjf8cka8ht.westus-01.azurewebsites.net\/blog\/bird-building-collisions-an-evaluation-using-griddb\/"},"modified":"2025-11-13T12:56:24","modified_gmt":"2025-11-13T20:56:24","slug":"bird-building-collisions-an-evaluation-using-griddb","status":"publish","type":"post","link":"https:\/\/griddb.net\/en\/blog\/bird-building-collisions-an-evaluation-using-griddb\/","title":{"rendered":"Bird-Building Collisions – An Evaluation using GridDB"},"content":{"rendered":"
\n
\n
\n
\n
\n<\/div>\n
\n<\/div>
\n

The Alarming Upsurge of Bird-Building Collisions\u00b6<\/a><\/h2>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n
\n
\n
\n<\/div>\n
\n<\/div>
\n

Skyscrapers and tall towers look splendid and can uplift the look of any city. Big buildings and bright lights are great to look at, and perfectly safe for human beings. But are they safe for birds? Apparently not. According to the Audubon Mid-Atlantic, atleast 365 million birds collide with buildings every year in the United States. The numbers can go upto 1 billion in some cases. Scientists warn that while bird-building collisions can result in an increased mortality of birds, they also lead to the decline and subsequent extinction of many bird species. In this article, we use GridDB and Python to derive insights into this often-overlooked threat.<\/p>\n<\/div>\n<\/div>\n<\/div>\n<\/div>

\n
\n
\n<\/div>\n
\n
In\u00a0[154]:<\/div>\n
\n
\n
<\/span>import<\/span> <\/span>os<\/span>\nimport<\/span> <\/span>pandas<\/span> <\/span>as<\/span> <\/span>pd<\/span>\nimport<\/span> <\/span>numpy<\/span> <\/span>as<\/span> <\/span>np<\/span>\nimport<\/span> <\/span>requests<\/span>  # to make http calls<\/span>\nimport<\/span> <\/span>http<\/span>\nhttp<\/span>.<\/span>client<\/span>.<\/span>HTTPConnection<\/span>.<\/span>debuglevel<\/span> =<\/span> 1<\/span>\nfrom<\/span> <\/span>datetime<\/span> <\/span>import<\/span> date<\/span>\nfrom<\/span> <\/span>datetime<\/span> <\/span>import<\/span> datetime<\/span>\nimport<\/span> <\/span>json<\/span> # to parse different data objects like string, etc. to JSON<\/span>\nimport<\/span> <\/span>tabulate<\/span>\nimport<\/span> <\/span>seaborn<\/span> <\/span>as<\/span> <\/span>sns<\/span>\nfrom<\/span> <\/span>matplotlib<\/span> <\/span>import<\/span> pyplot<\/span> as<\/span> plt<\/span>\nfrom<\/span> <\/span>scipy<\/span> <\/span>import<\/span> stats<\/span>\nimport<\/span> <\/span>random<\/span>\n<\/pre><\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n
\n
\n
\n<\/div>\n
\n<\/div>
\n
The Dataset\u00b6<\/a><\/h2>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n
\n
\n
\n<\/div>\n
\n<\/div>
\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n
\n
\n
\n<\/div>\n
\n<\/div>
\n
The dataset used for this analysis can be downloaded from  data.world <\/a> or from the official website of  DRYAD <\/a>. The Dataset contains collisions recorded in Chicago and Cleveland along with the associated light levels. Please not that this data is limited to Chicago and Cleveland and hence are not representative of other states in the United States.<\/p>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n
\n
\n
\n<\/div>\n
\n<\/div>
\n
 Citation: <\/b> Winger, Benjamin M. et al. (2019), Nocturnal flight-calling behaviour predicts vulnerability to artificial light in migratory birds, Proceedings of the Royal Society B: Biological Sciences, Article-journal, https:\/\/doi.org\/10.1098\/rspb.2019.0364<\/a><\/p>\n<\/div>\n<\/div>\n<\/div>\n<\/div>
\n
\n
\n<\/div>\n
\n
In\u00a0[155]:<\/div>\n
\n
\n
<\/span>os<\/span>.<\/span>chdir<\/span>(<\/span>\"C:<\/span>\\\\<\/span>Users<\/span>\\\\<\/span>Desktop<\/span>\\\\<\/span>GridDB)<\/span>\nChicago_Collisions<\/span> =<\/span> pd<\/span>.<\/span>read_csv<\/span>(<\/span>\"Chicago_collision_data.csv\"<\/span>,<\/span> sep<\/span> =<\/span>\",\"<\/span>)<\/span>\nCleveland_Collisions<\/span> =<\/span> pd<\/span>.<\/span>read_csv<\/span>(<\/span>\"Cleveland_collision_data.csv\"<\/span>,<\/span> sep<\/span> =<\/span>\",\"<\/span>)<\/span>\nLight_levels<\/span> =<\/span> pd<\/span>.<\/span>read_csv<\/span>(<\/span>\"Light_levels_dryad.csv\"<\/span>,<\/span> sep<\/span> =<\/span>\",\"<\/span>)<\/span>\n<\/pre><\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n
\n
\n
\n<\/div>\n
\n<\/div>
\n
For Collection containers, the rowkey can be of any type. However, for Timeseries containers, the  rowkey <\/b> should be of the  timestamp <\/b> format. Hence, we process the 'Date' field in the form of a timestamp.<\/p>\n<\/div>\n<\/div>\n<\/div>\n<\/div>
\n
\n
\n<\/div>\n
\n
In\u00a0[156]:<\/div>\n
\n
\n
<\/span>Chicago_Collisions<\/span>[<\/span>'Date'<\/span>]<\/span> =<\/span> Chicago_Collisions<\/span>[<\/span>'Date'<\/span>]<\/span> +<\/span> \" 00:00:00\"<\/span>\nCleveland_Collisions<\/span>[<\/span>'Date'<\/span>]<\/span> =<\/span> Cleveland_Collisions<\/span>[<\/span>'Date'<\/span>]<\/span> +<\/span> \" 00:00:00\"<\/span>\nLight_levels<\/span>[<\/span>'Date'<\/span>]<\/span> =<\/span> Light_levels<\/span>[<\/span>'Date'<\/span>]<\/span> +<\/span> \" 00:00:00\"<\/span>\n\nChicago_Collisions<\/span>[<\/span>'Date'<\/span>]<\/span> =<\/span> pd<\/span>.<\/span>to_datetime<\/span>(<\/span>Chicago_Collisions<\/span>[<\/span>'Date'<\/span>])<\/span>\nCleveland_Collisions<\/span>[<\/span>'Date'<\/span>]<\/span> =<\/span> pd<\/span>.<\/span>to_datetime<\/span>(<\/span>Cleveland_Collisions<\/span>[<\/span>'Date'<\/span>])<\/span>\nLight_levels<\/span>[<\/span>'Date'<\/span>]<\/span> =<\/span> pd<\/span>.<\/span>to_datetime<\/span>(<\/span>Light_levels<\/span>[<\/span>'Date'<\/span>])<\/span>\nLight_levels<\/span>.<\/span>Light_Score<\/span> =<\/span> Light_levels<\/span>.<\/span>Light_Score<\/span>.<\/span>astype<\/span>(<\/span>str<\/span>)<\/span>\n<\/pre><\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n
\n
\n
\n<\/div>\n
\n<\/div>
\n
Importance of Uniqueness of Timestamps\u00b6<\/a><\/h2>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n
\n
\n
\n<\/div>\n
\n<\/div>
\n
 Timeseries Containers in GridDB require you to have unique timestamp values. If not, they will overwrite each other. <\/b>\nNote that as we converted dates to timestamps, rows which have the same date will also have the same timestamp value. Hence, printing out the number of rows inserted may not be a true validation. To prevent an over-write, let's add a random number of seconds to each timestamp value to ensure that the values are unique.<\/p>\n<\/div>\n<\/div>\n<\/div>\n<\/div>
\n
\n
\n<\/div>\n
\n
In\u00a0[\u00a0]:<\/div>\n
\n
\n
<\/span>myCounter<\/span> =<\/span> 0<\/span>\nfor<\/span> i<\/span>,<\/span> row<\/span> in<\/span> Chicago_Collisions<\/span>.<\/span>iterrows<\/span>():<\/span>\n    myCounter<\/span> =<\/span> myCounter<\/span>+<\/span>1<\/span>\n    Chicago_Collisions<\/span>.<\/span>loc<\/span>[<\/span>i<\/span>,<\/span> \"Date\"<\/span>]<\/span> =<\/span> row<\/span>[<\/span>'Date'<\/span>]<\/span> +<\/span> pd<\/span>.<\/span>DateOffset<\/span>(<\/span>seconds<\/span>=<\/span>myCounter<\/span>)<\/span>\n\nmyCounter<\/span> =<\/span> 0<\/span>\nfor<\/span> i<\/span>,<\/span> row<\/span> in<\/span> Cleveland_Collisions<\/span>.<\/span>iterrows<\/span>():<\/span>\n    myCounter<\/span> =<\/span> myCounter<\/span>+<\/span>1<\/span>\n    Cleveland_Collisions<\/span>.<\/span>loc<\/span>[<\/span>i<\/span>,<\/span> \"Date\"<\/span>]<\/span> =<\/span> row<\/span>[<\/span>'Date'<\/span>]<\/span> +<\/span> pd<\/span>.<\/span>DateOffset<\/span>(<\/span>seconds<\/span>=<\/span>myCounter<\/span>)<\/span>\n\nmyCounter<\/span> =<\/span> 0<\/span>\nfor<\/span> i<\/span>,<\/span> row<\/span> in<\/span> Light_levels<\/span>.<\/span>iterrows<\/span>():<\/span>\n    myCounter<\/span> =<\/span> myCounter<\/span>+<\/span>1<\/span>\n    Light_levels<\/span>.<\/span>loc<\/span>[<\/span>i<\/span>,<\/span> \"Date\"<\/span>]<\/span> =<\/span> row<\/span>[<\/span>'Date'<\/span>]<\/span> +<\/span> pd<\/span>.<\/span>DateOffset<\/span>(<\/span>seconds<\/span>=<\/span>myCounter<\/span>)<\/span>\n<\/pre><\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n
\n
\n
\n<\/div>\n
\n<\/div>
\n
Changing the sequence of columns\u00b6<\/a><\/h3>
The columns need to be re-ordered such that the 'Date' is the first column in the data. This is because time-series containers in GridDB expect a timestamp column to be the first key column.<\/p>\n<\/div>\n<\/div>\n<\/div>\n<\/div>
\n
\n
\n<\/div>\n
\n
In\u00a0[158]:<\/div>\n
\n
\n
<\/span>chicago_cols<\/span> =<\/span> list<\/span>(<\/span>Chicago_Collisions<\/span>.<\/span>columns<\/span>.<\/span>values<\/span>)<\/span>\nchicago_cols<\/span> # ['Genus', 'Species', 'Date', 'Locality']<\/span>\n# Re-arrange to ['Date', 'Genus', 'Species', 'Locality']<\/span>\nChicago_Collisions<\/span> =<\/span> Chicago_Collisions<\/span>[[<\/span>'Date'<\/span>,<\/span> 'Genus'<\/span>,<\/span> 'Species'<\/span>,<\/span> 'Locality'<\/span>]]<\/span>\n<\/pre><\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>
\n
\n
\n<\/div>\n
\n
In\u00a0[159]:<\/div>\n
\n
\n
<\/span>cleveland_cols<\/span> =<\/span> list<\/span>(<\/span>Cleveland_Collisions<\/span>.<\/span>columns<\/span>.<\/span>values<\/span>)<\/span>\ncleveland_cols<\/span> # ['Genus', 'Species', 'Date']<\/span>\n# Re-arrange to ['Date', 'Genus', 'Species']<\/span>\nCleveland_Collisions<\/span> =<\/span> Cleveland_Collisions<\/span>[[<\/span>'Date'<\/span>,<\/span> 'Genus'<\/span>,<\/span> 'Species'<\/span>]]<\/span>\n<\/pre><\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n
\n
\n
\n<\/div>\n
\n<\/div>
\n
Formatting Date as Timestamp\u00b6<\/a><\/h3>
GridDB requires the key column for its timeseries to be of the format %Y-%m-%dT%H:%M:%SZ. As an example, the expected format is 2022-10-16T12:00:00Z.<\/p>\n<\/div>\n<\/div>\n<\/div>\n<\/div>
\n
\n
\n<\/div>\n
\n
In\u00a0[160]:<\/div>\n
\n
\n
<\/span>Chicago_Collisions<\/span>[<\/span>'Date'<\/span>]<\/span> =<\/span> Chicago_Collisions<\/span>[<\/span>'Date'<\/span>]<\/span>.<\/span>apply<\/span>(<\/span>lambda<\/span> x<\/span>:<\/span> x<\/span>.<\/span>strftime<\/span>(<\/span>\"%Y-%m-<\/span>%d<\/span>T%H:%M:%S.000Z\"<\/span>))<\/span>\n<\/pre><\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>
\n
\n
\n<\/div>\n
\n
In\u00a0[161]:<\/div>\n
\n
\n
<\/span>cleveland_cols<\/span> =<\/span> list<\/span>(<\/span>Cleveland_Collisions<\/span>.<\/span>columns<\/span>.<\/span>values<\/span>)<\/span>\ncleveland_cols<\/span> #['Genus', 'Species', 'Date']<\/span>\n# Re-arrange to ['Date','Genus','Species']<\/span>\nCleveland_Collisions<\/span> =<\/span> Cleveland_Collisions<\/span>[[<\/span>'Date'<\/span>,<\/span> 'Genus'<\/span>,<\/span> 'Species'<\/span>]]<\/span>\n<\/pre><\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>
\n
\n
\n<\/div>\n
\n
In\u00a0[162]:<\/div>\n
\n
\n
<\/span>Cleveland_Collisions<\/span>[<\/span>'Date'<\/span>]<\/span> =<\/span> Cleveland_Collisions<\/span>[<\/span>'Date'<\/span>]<\/span>.<\/span>apply<\/span>(<\/span>lambda<\/span> x<\/span>:<\/span> x<\/span>.<\/span>strftime<\/span>(<\/span>\"%Y-%m-<\/span>%d<\/span>T%H:%M:%S.000Z\"<\/span>))<\/span>\n<\/pre><\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>
\n
\n
\n<\/div>\n
\n
In\u00a0[163]:<\/div>\n
\n
\n
<\/span>Light_levels<\/span>[<\/span>'Date'<\/span>]<\/span> =<\/span> Light_levels<\/span>[<\/span>'Date'<\/span>]<\/span>.<\/span>apply<\/span>(<\/span>lambda<\/span> x<\/span>:<\/span> x<\/span>.<\/span>strftime<\/span>(<\/span>\"%Y-%m-<\/span>%d<\/span>T%H:%M:%S.000Z\"<\/span>))<\/span>\n<\/pre><\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n
\n
\n
\n<\/div>\n
\n<\/div>
\n
Constructing the Container - Setting up the Data Model\u00b6<\/a><\/h2>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n
\n
\n
\n<\/div>\n
\n<\/div>
\n
As you might already know, GridDB is highly scaleable NoSQL database that extends the typical Key-value store model to a key-container model. In addition, it supports two types of containers - a Collection and a Time Series Container. Refer to https:\/\/griddb.net\/en\/blog\/data-modeling-with-griddb\/<\/a> to learn more on how GridDB compares to other NoSQL databases like Riak, Cassandra and MongoDB and why GridDB is the best of the lot. This resource also clearly explains how each type of container needs to be created. The rowkey determines the type of container. In this case, our data model looks like the one below -<\/p>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n
\n
\n
\n<\/div>\n
\n<\/div>
\n
\"Collisions_Data_Model.jpg\"<\/p>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n
\n
\n
\n<\/div>\n
\n<\/div>
\n
Creating the Request (& Containers)\u00b6<\/a><\/h2>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n
\n
\n
\n<\/div>\n
\n<\/div>
\n
As per our requirements, we are required to create 3 containers. While constructing a time series container, note that the container type should be 'TIME_SERIES' and the rowkey must be set to 'True'.<\/p>\n<\/div>\n<\/div>\n<\/div>\n<\/div>
\n
\n
\n<\/div>\n
\n
In\u00a0[164]:<\/div>\n
\n
\n
<\/span>#Construct an object to hold the request headers (ensure that you replace the XXX placeholder with the correct value that matches the credentials for your GridDB instance)<\/span>\nheader_obj<\/span> =<\/span> {<\/span>\"Authorization\"<\/span>:<\/span>\"XXX\"<\/span>,<\/span>\"Content-Type\"<\/span>:<\/span>\"application\/json; charset=UTF-8\"<\/span>,<\/span>\"User-Agent\"<\/span>:<\/span>\"PostmanRuntime\/7.29.0\"<\/span>}<\/span>\n\n#Construct the base URL based on your GridDB cluster you'd like to connect to (ensure that you replace the placeholders in the URL below with the correct values that correspond to your GridDB instance)<\/span>\n#'https:\/\/[host]:[port]\/griddb\/v2\/[clustername]\/dbs\/[database_name]'<\/span>\nbase_url<\/span> =<\/span> 'https:\/\/[host]:[port]\/griddb\/v2\/[clustername]\/dbs\/[database_name]'<\/span>\n<\/pre><\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>
\n
\n
\n<\/div>\n
\n
In\u00a0[165]:<\/div>\n
\n
\n
<\/span>#Creating the container 'Chicago_Collisions'<\/span>\n#Construct an object to hold the request body (i.e., the first container that needs to be created)<\/span>\n# Genus,Species,Date,Locality<\/span>\ndata_obj_1<\/span> =<\/span> {<\/span>\n    \"container_name\"<\/span>:<\/span> \"Chicago_Collisions\"<\/span>,<\/span>\n    \"container_type\"<\/span>:<\/span> \"TIME_SERIES\"<\/span>,<\/span>\n    \"rowkey\"<\/span>:<\/span> True<\/span>,<\/span>\n    \"columns\"<\/span>:<\/span> [<\/span>\n    {<\/span>\n    \"name\"<\/span>:<\/span> \"Date\"<\/span>,<\/span>\n    \"type\"<\/span>:<\/span> \"TIMESTAMP\"<\/span>\n    },<\/span>\n    {<\/span>\n    \"name\"<\/span>:<\/span> \"Genus\"<\/span>,<\/span>\n    \"type\"<\/span>:<\/span> \"STRING\"<\/span>\n    },<\/span>\n    {<\/span>\n    \"name\"<\/span>:<\/span> \"Species\"<\/span>,<\/span>\n    \"type\"<\/span>:<\/span> \"STRING\"<\/span>\n    },<\/span>\n    {<\/span>\n    \"name\"<\/span>:<\/span> \"Locality\"<\/span>,<\/span>\n    \"type\"<\/span>:<\/span> \"STRING\"<\/span>\n    }<\/span>\n    ]<\/span>\n}<\/span>\n<\/pre><\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>
\n
\n
\n<\/div>\n
\n
In\u00a0[\u00a0]:<\/div>\n
\n
\n
<\/span>#Set up the GridDB WebAPI URL<\/span>\nurl<\/span> =<\/span> base_url<\/span>+<\/span>'containers'<\/span>\n\n#Invoke the GridDB WebAPI with the headers and the request body<\/span>\nx<\/span> =<\/span> requests<\/span>.<\/span>post<\/span>(<\/span>url<\/span>,<\/span> json<\/span> =<\/span> data_obj_1<\/span>,<\/span> headers<\/span> =<\/span> header_obj<\/span>)<\/span>\n<\/pre><\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n
\n
\n
\n<\/div>\n
\n<\/div>
\n
Here's a  TIP <\/b>: If you are new to GridDB and need help understanding the data types, check out this resource -  'Data Types in GridDB' <\/a> It is important to note that the data types are case sensitive e.g. Timestamp should be specified in upper case and not in title case or lower case.<\/p>\n<\/div>\n<\/div>\n<\/div>\n<\/div>
\n
\n
\n<\/div>\n
\n
In\u00a0[167]:<\/div>\n
\n
\n
<\/span>#Creating the container 'Cleveland_Collisions'<\/span>\n#Construct an object to hold the request body (i.e., the second container that needs to be created)<\/span>\ndata_obj_2<\/span> =<\/span> {<\/span>\n    \"container_name\"<\/span>:<\/span> \"Cleveland_Collisions\"<\/span>,<\/span>\n    \"container_type\"<\/span>:<\/span> \"TIME_SERIES\"<\/span>,<\/span>\n    \"rowkey\"<\/span>:<\/span> True<\/span>,<\/span>\n    \"columns\"<\/span>:<\/span> [<\/span>\n    {<\/span>\n    \"name\"<\/span>:<\/span> \"Date\"<\/span>,<\/span>\n    \"type\"<\/span>:<\/span> \"TIMESTAMP\"<\/span>\n    },<\/span>\n    {<\/span>\n    \"name\"<\/span>:<\/span> \"Genus\"<\/span>,<\/span>\n    \"type\"<\/span>:<\/span> \"STRING\"<\/span>\n    },<\/span>\n    {<\/span>\n    \"name\"<\/span>:<\/span> \"Species\"<\/span>,<\/span>\n    \"type\"<\/span>:<\/span> \"STRING\"<\/span>\n    },<\/span>    \n    ]<\/span>\n}<\/span>\n<\/pre><\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>
\n
\n
\n<\/div>\n
\n
In\u00a0[\u00a0]:<\/div>\n
\n
\n
<\/span>#Set up the GridDB WebAPI URL<\/span>\nurl<\/span> =<\/span> base_url<\/span> +<\/span> 'containers'<\/span>\n\n#Invoke the GridDB WebAPI with the headers and the request body<\/span>\nx<\/span> =<\/span> requests<\/span>.<\/span>post<\/span>(<\/span>url<\/span>,<\/span> json<\/span> =<\/span> data_obj_2<\/span>,<\/span> headers<\/span> =<\/span> header_obj<\/span>)<\/span>\n<\/pre><\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>
\n
\n
\n<\/div>\n
\n
In\u00a0[169]:<\/div>\n
\n
\n
<\/span>#Creating the container 'Light_levels'<\/span>\n#Construct an object to hold the request body (i.e., the third container that needs to be created)<\/span>\ndata_obj_3<\/span> =<\/span> {<\/span>\n    \"container_name\"<\/span>:<\/span> \"Light_levels\"<\/span>,<\/span>\n    \"container_type\"<\/span>:<\/span> \"TIME_SERIES\"<\/span>,<\/span>\n    \"rowkey\"<\/span>:<\/span> True<\/span>,<\/span>\n    \"columns\"<\/span>:<\/span> [<\/span>\n    {<\/span>\n    \"name\"<\/span>:<\/span> \"Date\"<\/span>,<\/span>\n    \"type\"<\/span>:<\/span> \"TIMESTAMP\"<\/span>\n    },<\/span>\n    {<\/span>\n    \"name\"<\/span>:<\/span> \"Light_Score\"<\/span>,<\/span>\n    \"type\"<\/span>:<\/span> \"STRING\"<\/span>\n    },<\/span>    \n    ]<\/span>\n}<\/span>\n<\/pre><\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>
\n
\n
\n<\/div>\n
\n
In\u00a0[\u00a0]:<\/div>\n
\n
\n
<\/span>#Set up the GridDB WebAPI URL<\/span>\nurl<\/span> =<\/span> base_url<\/span> +<\/span> 'containers'<\/span>\n\n#Invoke the GridDB WebAPI with the headers and the request body<\/span>\nx<\/span> =<\/span> requests<\/span>.<\/span>post<\/span>(<\/span>url<\/span>,<\/span> json<\/span> =<\/span> data_obj_3<\/span>,<\/span> headers<\/span> =<\/span> header_obj<\/span>)<\/span>\n<\/pre><\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n
\n
\n
\n<\/div>\n
\n<\/div>
\n
Data Loading - Populating the containers with data (Row Registration)\u00b6<\/a><\/h2>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n
\n
\n
\n<\/div>\n
\n<\/div>
\n
Now that all containers have been loaded, we load the data from the three dataframes into each of the containers. The process of loading data into a container is also known as  'Row Registration' <\/b>. To read more about it, refer to the GridDB resource  here<\/a>.<\/p>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n
\n
\n
\n<\/div>\n
\n<\/div>
\n
\"Row%20Registration.jpg\"<\/p>\n
 Steps involved in Row Registration <\/center>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n
\n
\n
\n<\/div>\n
\n<\/div>
\n
The 'to_json' function of the Pandas library is useful in constructing the JSON structure required for row registration.<\/p>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n
\n
\n
\n<\/div>\n
\n<\/div>
\n
Populating data in the container 'Chicago_Collisions'\u00b6<\/a><\/h3>\n<\/div>\n<\/div>\n<\/div>\n<\/div>
\n
\n
\n<\/div>\n
\n
In\u00a0[171]:<\/div>\n
\n
\n
<\/span>#Convert the data in the dataframe to the JSON format<\/span>\nChicago_Collisions_json<\/span> =<\/span> Chicago_Collisions<\/span>.<\/span>to_json<\/span>(<\/span>orient<\/span>=<\/span>'values'<\/span>)<\/span>\nrequest_body_chicago_collisions<\/span> =<\/span> Chicago_Collisions_json<\/span>\n<\/pre><\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>
\n
\n
\n<\/div>\n
\n
In\u00a0[\u00a0]:<\/div>\n
\n
\n
<\/span>#Setup the URL to be used to invoke the GridDB WebAPI to register rows in the container created previously<\/span>\nurl<\/span> =<\/span> base_url<\/span> +<\/span> 'containers\/Chicago_Collisions\/rows'<\/span>\n\n#Invoke the GridDB WebAPI using the request constructed<\/span>\nx<\/span> =<\/span> requests<\/span>.<\/span>put<\/span>(<\/span>url<\/span>,<\/span> data<\/span>=<\/span>request_body_chicago_collisions<\/span>,<\/span> headers<\/span>=<\/span>header_obj<\/span>)<\/span>\n<\/pre><\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>
\n
\n
\n<\/div>\n
\n
In\u00a0[173]:<\/div>\n
\n
\n
<\/span>print<\/span>(<\/span>str<\/span>(<\/span>json<\/span>.<\/span>loads<\/span>(<\/span>x<\/span>.<\/span>text<\/span>)[<\/span>'count'<\/span>])<\/span> +<\/span> ' rows have been registered in the container Chicago_Collisions.'<\/span>)<\/span>\n<\/pre><\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n
\n
\n<\/div>\n
\n
\n
<\/div>\n
\n
69784 rows have been registered in the container Chicago_Collisions.\n<\/pre>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>
\n
\n
\n<\/div>\n
\n
In\u00a0[\u00a0]:<\/div>\n
\n
\n
<\/span>###############################################<\/span>\n#Construct the SQL to be used<\/span>\nsql_query1<\/span> =<\/span> (<\/span>\"SELECT count(*) as cnt FROM Chicago_Collisions\"<\/span>)<\/span>\n#Setup the URL to be used to invoke the GridDB WebAPI to retrieve data from the container<\/span>\nurl<\/span> =<\/span> base_url<\/span> +<\/span> '\/sql'<\/span>\n\n#Construct the request body<\/span>\nrequest_body<\/span> =<\/span> '[{\"type\":\"sql-select\", \"stmt\":\"'<\/span>+<\/span>sql_query1<\/span>+<\/span>'\"}]'<\/span>\n\n#Invoke the GridDB WebAPI<\/span>\nquery_req1<\/span> =<\/span> requests<\/span>.<\/span>post<\/span>(<\/span>url<\/span>,<\/span> data<\/span>=<\/span>request_body<\/span>,<\/span> headers<\/span>=<\/span>header_obj<\/span>)<\/span>\n\n#print the response and compare the output to the number of rows loaded<\/span>\nquery_req1<\/span>.<\/span>text<\/span>\n<\/pre><\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n
\n
\n
\n<\/div>\n
\n<\/div>
\n
Populating data in the container 'Cleveland_Collisions'\u00b6<\/a><\/h3>\n<\/div>\n<\/div>\n<\/div>\n<\/div>
\n
\n
\n<\/div>\n
\n
In\u00a0[197]:<\/div>\n
\n
\n
<\/span>#Convert the data in the dataframe to the JSON format<\/span>\nCleveland_Collisions_json<\/span> =<\/span> Cleveland_Collisions<\/span>.<\/span>to_json<\/span>(<\/span>orient<\/span>=<\/span>'values'<\/span>)<\/span>\nrequest_body_cleveland_collisions<\/span> =<\/span> Cleveland_Collisions_json<\/span>\n<\/pre><\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>
\n
\n
\n<\/div>\n
\n
In\u00a0[\u00a0]:<\/div>\n
\n
\n
<\/span>#Setup the URL to be used to invoke the GridDB WebAPI to register rows in the container created previously<\/span>\nurl<\/span> =<\/span> base_url<\/span> +<\/span> 'containers\/Cleveland_Collisions\/rows'<\/span>\n\n#Invoke the GridDB WebAPI using the request constructed<\/span>\nx<\/span> =<\/span> requests<\/span>.<\/span>put<\/span>(<\/span>url<\/span>,<\/span> data<\/span>=<\/span>request_body_cleveland_collisions<\/span>,<\/span> headers<\/span>=<\/span>header_obj<\/span>)<\/span>\n<\/pre><\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>
\n
\n
\n<\/div>\n
\n
In\u00a0[199]:<\/div>\n
\n
\n
<\/span>print<\/span>(<\/span>str<\/span>(<\/span>json<\/span>.<\/span>loads<\/span>(<\/span>x<\/span>.<\/span>text<\/span>)[<\/span>'count'<\/span>])<\/span> +<\/span> ' rows have been registered in the container Cleveland_Collisions.'<\/span>)<\/span>\n<\/pre><\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n
\n
\n<\/div>\n
\n
\n
<\/div>\n
\n
2273 rows have been registered in the container Cleveland_Collisions.\n<\/pre>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>
\n
\n
\n<\/div>\n
\n
In\u00a0[\u00a0]:<\/div>\n
\n
\n
<\/span>###############################################<\/span>\n#Construct the SQL to be used<\/span>\nsql_query1<\/span> =<\/span> (<\/span>\"SELECT count(*) as cnt FROM Cleveland_Collisions\"<\/span>)<\/span>\n#Setup the URL to be used to invoke the GridDB WebAPI to retrieve data from the container<\/span>\nurl<\/span> =<\/span> base_url<\/span> +<\/span> '\/sql'<\/span>\n\n#Construct the request body<\/span>\nrequest_body<\/span> =<\/span> '[{\"type\":\"sql-select\", \"stmt\":\"'<\/span>+<\/span>sql_query1<\/span>+<\/span>'\"}]'<\/span>\n\n#Invoke the GridDB WebAPI<\/span>\nquery_req1<\/span> =<\/span> requests<\/span>.<\/span>post<\/span>(<\/span>url<\/span>,<\/span> data<\/span>=<\/span>request_body<\/span>,<\/span> headers<\/span>=<\/span>header_obj<\/span>)<\/span>\n\n#print the response and compare the output to the number of rows loaded<\/span>\nquery_req1<\/span>.<\/span>text<\/span>\n<\/pre><\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n
\n
\n
\n<\/div>\n
\n<\/div>
\n
Populating data in the container 'Light_levels'\u00b6<\/a><\/h3>\n<\/div>\n<\/div>\n<\/div>\n<\/div>
\n
\n
\n<\/div>\n
\n
In\u00a0[201]:<\/div>\n
\n
\n
<\/span>#Convert the data in the dataframe to the JSON format<\/span>\nLight_levels_json<\/span> =<\/span> Light_levels<\/span>.<\/span>to_json<\/span>(<\/span>orient<\/span>=<\/span>'values'<\/span>)<\/span>\nrequest_body_Light_levels<\/span> =<\/span> Light_levels_json<\/span>\n<\/pre><\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>
\n
\n
\n<\/div>\n
\n
In\u00a0[\u00a0]:<\/div>\n
\n
\n
<\/span>#Setup the URL to be used to invoke the GridDB WebAPI to register rows in the container created previously<\/span>\nurl<\/span> =<\/span> base_url<\/span> +<\/span> 'containers\/Light_levels\/rows'<\/span>\n\n#Invoke the GridDB WebAPI using the request constructed<\/span>\nx<\/span> =<\/span> requests<\/span>.<\/span>put<\/span>(<\/span>url<\/span>,<\/span> data<\/span>=<\/span>request_body_Light_levels<\/span>,<\/span> headers<\/span>=<\/span>header_obj<\/span>)<\/span>\n<\/pre><\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>
\n
\n
\n<\/div>\n
\n
In\u00a0[203]:<\/div>\n
\n
\n
<\/span>print<\/span>(<\/span>str<\/span>(<\/span>json<\/span>.<\/span>loads<\/span>(<\/span>x<\/span>.<\/span>text<\/span>)[<\/span>'count'<\/span>])<\/span> +<\/span> ' rows have been registered in the container Light_levels.'<\/span>)<\/span>\n<\/pre><\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n
\n
\n<\/div>\n
\n
\n
<\/div>\n
\n
3067 rows have been registered in the container Light_levels.\n<\/pre>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>
\n
\n
\n<\/div>\n
\n
In\u00a0[\u00a0]:<\/div>\n
\n
\n
<\/span>###############################################<\/span>\n#Construct the SQL to be used<\/span>\nsql_query1<\/span> =<\/span> (<\/span>\"SELECT count(*) as cnt FROM Light_levels\"<\/span>)<\/span>\n#Setup the URL to be used to invoke the GridDB WebAPI to retrieve data from the container<\/span>\nurl<\/span> =<\/span> base_url<\/span> +<\/span> '\/sql'<\/span>\n\n#Construct the request body<\/span>\nrequest_body<\/span> =<\/span> '[{\"type\":\"sql-select\", \"stmt\":\"'<\/span>+<\/span>sql_query1<\/span>+<\/span>'\"}]'<\/span>\n\n#Invoke the GridDB WebAPI<\/span>\nquery_req1<\/span> =<\/span> requests<\/span>.<\/span>post<\/span>(<\/span>url<\/span>,<\/span> data<\/span>=<\/span>request_body<\/span>,<\/span> headers<\/span>=<\/span>header_obj<\/span>)<\/span>\n\n#print the response and compare the output to the number of rows loaded<\/span>\nquery_req1<\/span>.<\/span>text<\/span>\n<\/pre><\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n
\n
\n
\n<\/div>\n
\n<\/div>
\n
Querying the database\u00b6<\/a><\/h2>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n
\n
\n
\n<\/div>\n
\n<\/div>
\n
We are now going to find insightful answers to questions about Bird-Building collisions using GridDB's powerful query database. The three containers that were created are going to be queried for actionable insights.<\/p>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n
\n
\n
\n<\/div>\n
\n<\/div>
\n
Harnessing the timeseries functions of GridDB\u00b6<\/a><\/h3>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n
\n
\n
\n<\/div>\n
\n<\/div>
\n
GridDB offers easy to use time-series functions that can be leveraged for quick insights. Read more  here.<\/a> Here, we use some time-series functions along with the standard sql functions available in GridDB.<\/p>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n
\n
\n
\n<\/div>\n
\n<\/div>
\n
What is the range of data available for Collisions in Chicago?\u00b6<\/a><\/h3>\n<\/div>\n<\/div>\n<\/div>\n<\/div>
\n
\n
\n<\/div>\n
\n
In\u00a0[205]:<\/div>\n
\n
\n
<\/span>#Construct the SQL to be used<\/span>\nsql_query1<\/span> =<\/span> (<\/span>\"SELECT max(Date) as cnt FROM Chicago_Collisions\"<\/span>)<\/span>\n<\/pre><\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>
\n
\n
\n<\/div>\n
\n
In\u00a0[206]:<\/div>\n
\n
\n
<\/span>#Setup the URL to be used to invoke the GridDB WebAPI to retrieve data from the container<\/span>\nurl<\/span> =<\/span> base_url<\/span> +<\/span> '\/sql'<\/span>\n\n#Construct the request body<\/span>\nrequest_body<\/span> =<\/span> '[{\"type\":\"sql-select\", \"stmt\":\"'<\/span>+<\/span>sql_query1<\/span>+<\/span>'\"}]'<\/span>\n<\/pre><\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>
\n
\n
\n<\/div>\n
\n
In\u00a0[\u00a0]:<\/div>\n
\n
\n
<\/span>#Invoke the GridDB WebAPI<\/span>\nquery_req1<\/span> =<\/span> requests<\/span>.<\/span>post<\/span>(<\/span>url<\/span>,<\/span> data<\/span>=<\/span>request_body<\/span>,<\/span> headers<\/span>=<\/span>header_obj<\/span>)<\/span>\n<\/pre><\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>
\n
\n
\n<\/div>\n
\n
In\u00a0[208]:<\/div>\n
\n
\n
<\/span>query_req1<\/span>.<\/span>text<\/span>\n<\/pre><\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n
\n
\n<\/div>\n
\n
\n
Out[208]:<\/div>\n
\n
'[{\"columns\":[{\"name\":\"cnt\",\"type\":\"TIMESTAMP\"}],\"results\":[[\"2016-11-30T17:05:37.000Z\"]]}]'<\/pre>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n
\n
\n
\n<\/div>\n
\n<\/div>
\n
There's data as recent as  November 2016 <\/b>.<\/p>\n<\/div>\n<\/div>\n<\/div>\n<\/div>
\n
\n
\n<\/div>\n
\n
In\u00a0[209]:<\/div>\n
\n
\n
<\/span>#Construct the SQL to be used<\/span>\nsql_query2<\/span> =<\/span> (<\/span>\"SELECT min(Date) as cnt FROM Chicago_Collisions\"<\/span>)<\/span>\n<\/pre><\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>
\n
\n
\n<\/div>\n
\n
In\u00a0[210]:<\/div>\n
\n
\n
<\/span>#Setup the URL to be used to invoke the GridDB WebAPI to retrieve data from the container<\/span>\nurl<\/span> =<\/span> base_url<\/span> +<\/span> '\/sql'<\/span>\n\n#Construct the request body<\/span>\nrequest_body<\/span> =<\/span> '[{\"type\":\"sql-select\", \"stmt\":\"'<\/span>+<\/span>sql_query2<\/span>+<\/span>'\"}]'<\/span>\n<\/pre><\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>
\n
\n
\n<\/div>\n
\n
In\u00a0[\u00a0]:<\/div>\n
\n
\n
<\/span>#Invoke the GridDB WebAPI<\/span>\nquery_req2<\/span> =<\/span> requests<\/span>.<\/span>post<\/span>(<\/span>url<\/span>,<\/span> data<\/span>=<\/span>request_body<\/span>,<\/span> headers<\/span>=<\/span>header_obj<\/span>)<\/span>\n<\/pre><\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>
\n
\n
\n<\/div>\n
\n
In\u00a0[212]:<\/div>\n
\n
\n
<\/span>query_req2<\/span>.<\/span>text<\/span>\n<\/pre><\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n
\n
\n<\/div>\n
\n
\n
Out[212]:<\/div>\n
\n
'[{\"columns\":[{\"name\":\"cnt\",\"type\":\"TIMESTAMP\"}],\"results\":[[\"1978-09-15T03:02:59.000Z\"]]}]'<\/pre>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n
\n
\n
\n<\/div>\n
\n<\/div>
\n
The 'Chicago Collisions' dataset has data from  1978 to 2016 <\/b>.<\/p>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n
\n
\n
\n<\/div>\n
\n<\/div>
\n
When did a collision take place in Chicago on or after the New Year 2014 (1st of Jan 2014)?\u00b6<\/a><\/h3>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n
\n
\n
\n<\/div>\n
\n<\/div>
\n
The start of every Year is indeed a happy occasion for all of us; but not for all living beings. Let's see if there was a bird that was killed on or after New Year's day.<\/p>\n
For this, we use the TIME_NEXT function of TQL. When this statement is used, GridDB selects a row whose timestamp is identical with or just after the specified timestamp. Read more about it  here. <\/a><\/p>\n
In this case, it fetches the specific bird-building collision that happened after 2014-01-01.<\/p>\n<\/div>\n<\/div>\n<\/div>\n<\/div>
\n
\n
\n<\/div>\n
\n
In\u00a0[213]:<\/div>\n
\n
\n
<\/span>#Construct the TQL to be used<\/span>\ntql_query1<\/span> =<\/span> \"SELECT TIME_NEXT(*, TIMESTAMP('2014-01-01T00:00:00Z')) \"<\/span>\n<\/pre><\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>
\n
\n
\n<\/div>\n
\n
In\u00a0[\u00a0]:<\/div>\n
\n
\n
<\/span>#Setup the URL to be used to invoke the GridDB WebAPI to retrieve data from the container<\/span>\nurl<\/span> =<\/span> base_url<\/span> +<\/span> 'tql'<\/span>\n\n#Construct the request body which has the SQL that is to be used to retrieve the data<\/span>\nrequest_body<\/span> =<\/span> '[{\"name\":\"Chicago_Collisions\", \"stmt\":\"'<\/span>+<\/span>tql_query1<\/span>+<\/span>'\",\"columns\":[]}]'<\/span> \n\n#Invoke the GridDB WebAPI<\/span>\nquery_req3<\/span> =<\/span> requests<\/span>.<\/span>post<\/span>(<\/span>url<\/span>,<\/span> data<\/span>=<\/span>request_body<\/span>,<\/span> headers<\/span>=<\/span>header_obj<\/span>)<\/span>\n<\/pre><\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>
\n
\n
\n<\/div>\n
\n
In\u00a0[215]:<\/div>\n
\n
\n
<\/span>query_req3<\/span>.<\/span>text<\/span>\n<\/pre><\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n
\n
\n<\/div>\n
\n
\n
Out[215]:<\/div>\n
\n
'[{\"columns\":[{\"name\":\"Date\",\"type\":\"TIMESTAMP\"},{\"name\":\"Genus\",\"type\":\"STRING\"},{\"name\":\"Species\",\"type\":\"STRING\"},{\"name\":\"Locality\",\"type\":\"STRING\"}],\"results\":[[\"2014-03-14T19:19:27.000Z\",\"Melospiza\",\"melodia\",\"MP\"]],\"offset\":0,\"limit\":10000,\"total\":-1}]'<\/pre>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n
\n
\n
\n<\/div>\n
\n<\/div>
\n
Insight: <\/b>\nAs per the  TIME_NEXT <\/b> function, the very next time a collision has been recorded after 2014-01-01 is  2014-03-14<\/b>. A bird of the Melospiza genus and Melodia species was killed in McCormick Place, Chicago. In other words, a  song sparrow <\/b> was killed in a bird-building collision after  2014-01-01.<\/p>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n
\n
\n
\n<\/div>\n
\n<\/div>
\n
When did a collision take place in Chicago before the 4th of July 2016?\u00b6<\/a><\/h3>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n
\n
\n
\n<\/div>\n
\n<\/div>
\n
The TIME_PREV function fetches the record that lies just before the specified timestamp, in this case, just before 2016-07-04.<\/p>\n<\/div>\n<\/div>\n<\/div>\n<\/div>
\n
\n
\n<\/div>\n
\n
In\u00a0[216]:<\/div>\n
\n
\n
<\/span>#Construct the TQL to be used<\/span>\ntql_query2<\/span> =<\/span> \"SELECT TIME_PREV(*, TIMESTAMP('2016-07-04T00:00:00Z')) \"<\/span>\n<\/pre><\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>
\n
\n
\n<\/div>\n
\n
In\u00a0[\u00a0]:<\/div>\n
\n
\n
<\/span>#Setup the URL to be used to invoke the GridDB WebAPI to retrieve data from the container<\/span>\nurl<\/span> =<\/span> base_url<\/span> +<\/span> 'tql'<\/span>\n\n#Construct the request body which has the SQL that is to be used to retrieve the data<\/span>\nrequest_body<\/span> =<\/span> '[{\"name\":\"Chicago_Collisions\", \"stmt\":\"'<\/span>+<\/span>tql_query2<\/span>+<\/span>'\",\"columns\":[]}]'<\/span> \n\n#Invoke the GridDB WebAPI<\/span>\nquery_req4<\/span> =<\/span> requests<\/span>.<\/span>post<\/span>(<\/span>url<\/span>,<\/span> data<\/span>=<\/span>request_body<\/span>,<\/span> headers<\/span>=<\/span>header_obj<\/span>)<\/span>\n<\/pre><\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>
\n
\n
\n<\/div>\n
\n
In\u00a0[218]:<\/div>\n
\n
\n
<\/span>query_req4<\/span>.<\/span>text<\/span>\n<\/pre><\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n
\n
\n<\/div>\n
\n
\n
Out[218]:<\/div>\n
\n
'[{\"columns\":[{\"name\":\"Date\",\"type\":\"TIMESTAMP\"},{\"name\":\"Genus\",\"type\":\"STRING\"},{\"name\":\"Species\",\"type\":\"STRING\"},{\"name\":\"Locality\",\"type\":\"STRING\"}],\"results\":[[\"2016-05-30T04:37:39.000Z\",\"Dumetella\",\"carolinensis\",\"MP\"]],\"offset\":0,\"limit\":10000,\"total\":-1}]'<\/pre>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n
\n
\n
\n<\/div>\n
\n<\/div>
\n
A bird of the genus 'Dumetella' and species 'Carolinensis' was killed in a collision as of 2016-05-30. This bird that died was a  Gray Catbird <\/b>.<\/p>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n
\n
\n
\n<\/div>\n
\n<\/div>
\n
In each year, how many birds of each species were killed?\u00b6<\/a><\/h2>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n
\n
\n
\n<\/div>\n
\n<\/div>
\n
In addition to TQL, GridDB also offers all standard SQL functions like Aggregation and Time functions. Read more about it  GridDB's official SQL Reference. <\/a><\/p>\n<\/div>\n<\/div>\n<\/div>\n<\/div>
\n
\n
\n<\/div>\n
\n
In\u00a0[219]:<\/div>\n
\n
\n
<\/span>#Construct the SQL to be used<\/span>\nsql_query1<\/span> =<\/span> (<\/span>\"SELECT genus, species, EXTRACT(YEAR, Date) as Incident_Year, count(*) as cnt FROM Chicago_Collisions group by 1,2,3\"<\/span>)<\/span>\n<\/pre><\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>
\n
\n
\n<\/div>\n
\n
In\u00a0[220]:<\/div>\n
\n
\n
<\/span>#Setup the URL to be used to invoke the GridDB WebAPI to retrieve data from the container<\/span>\nurl<\/span> =<\/span> base_url<\/span> +<\/span> '\/sql'<\/span>\n\n#Construct the request body<\/span>\nrequest_body<\/span> =<\/span> '[{\"type\":\"sql-select\", \"stmt\":\"'<\/span>+<\/span>sql_query1<\/span>+<\/span>'\"}]'<\/span>\n\n#Validate the constructed request body<\/span>\nrequest_body<\/span>\n<\/pre><\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n
\n
\n<\/div>\n
\n
\n
Out[220]:<\/div>\n
\n
'[{\"type\":\"sql-select\", \"stmt\":\"SELECT genus, species, EXTRACT(YEAR, Date) as Incident_Year, count(*) as cnt FROM Chicago_Collisions group by 1,2,3\"}]'<\/pre>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n
\n
\n
\n<\/div>\n
\n<\/div>
\n
Invoke the GridDB SQL API to retrieve the results and process it.<\/p>\n<\/div>\n<\/div>\n<\/div>\n<\/div>
\n
\n
\n<\/div>\n
\n
In\u00a0[\u00a0]:<\/div>\n
\n
\n
<\/span>#Invoke the GridDB WebAPI<\/span>\ndata_req1<\/span> =<\/span> requests<\/span>.<\/span>post<\/span>(<\/span>url<\/span>,<\/span> data<\/span>=<\/span>request_body<\/span>,<\/span> headers<\/span>=<\/span>header_obj<\/span>)<\/span>\n<\/pre><\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>
\n
\n
\n<\/div>\n
\n
In\u00a0[222]:<\/div>\n
\n
\n
<\/span>#Process the response received and construct a Pandas dataframe with the data from the response<\/span>\nmyJson<\/span> =<\/span> data_req1<\/span>.<\/span>json<\/span>()<\/span>\nChicago_Collision_Incidents<\/span> =<\/span> pd<\/span>.<\/span>DataFrame<\/span>(<\/span>myJson<\/span>[<\/span>0<\/span>][<\/span>\"results\"<\/span>],<\/span> columns<\/span>=<\/span>[<\/span>myJson<\/span>[<\/span>0<\/span>][<\/span>\"columns\"<\/span>][<\/span>0<\/span>][<\/span>\"name\"<\/span>],<\/span> myJson<\/span>[<\/span>0<\/span>][<\/span>\"columns\"<\/span>][<\/span>1<\/span>][<\/span>\"name\"<\/span>],<\/span>myJson<\/span>[<\/span>0<\/span>][<\/span>\"columns\"<\/span>][<\/span>2<\/span>][<\/span>\"name\"<\/span>],<\/span>myJson<\/span>[<\/span>0<\/span>][<\/span>\"columns\"<\/span>][<\/span>3<\/span>][<\/span>\"name\"<\/span>]])<\/span>\nChicago_Collision_Incidents<\/span>=<\/span>Chicago_Collision_Incidents<\/span>.<\/span>sort_values<\/span>(<\/span>by<\/span>=<\/span>[<\/span>'cnt'<\/span>],<\/span> ascending<\/span>=<\/span>False<\/span>)<\/span>\n<\/pre><\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>
\n
\n
\n<\/div>\n
\n
In\u00a0[223]:<\/div>\n
\n
\n
<\/span>print<\/span>(<\/span>Chicago_Collision_Incidents<\/span>.<\/span>to_markdown<\/span>())<\/span> \n<\/pre><\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n
\n
\n<\/div>\n
\n
\n
<\/div>\n
\n
|      | Genus        | Species          |   Incident_Year |   cnt |\n|-----:|:-------------|:-----------------|----------------:|------:|\n|  773 | Zonotrichia  | albicollis       |            2013 |   984 |\n|  655 | Zonotrichia  | albicollis       |            2010 |   859 |\n| 2258 | Zonotrichia  | albicollis       |            2008 |   756 |\n|    4 | Zonotrichia  | albicollis       |            2009 |   623 |\n| 2285 | Zonotrichia  | albicollis       |            2006 |   567 |\n| 2055 | Zonotrichia  | albicollis       |            2011 |   540 |\n| 1293 | Zonotrichia  | albicollis       |            2007 |   520 |\n| 1411 | Zonotrichia  | albicollis       |            2014 |   500 |\n|  624 | Zonotrichia  | albicollis       |            2012 |   482 |\n| 2410 | Melospiza    | melodia          |            1988 |   456 |\n| 1630 | Zonotrichia  | albicollis       |            2015 |   453 |\n|  479 | Zonotrichia  | albicollis       |            2005 |   432 |\n|  705 | Melospiza    | melodia          |            1998 |   412 |\n|  272 | Melospiza    | melodia          |            1994 |   401 |\n| 1902 | Junco        | hyemalis         |            1996 |   358 |\n| 2367 | Seiurus      | aurocapilla      |            2011 |   352 |\n|  883 | Seiurus      | aurocapilla      |            2014 |   347 |\n| 1393 | Certhia      | americana        |            2010 |   328 |\n| 1733 | Seiurus      | aurocapilla      |            2012 |   323 |\n| 1502 | Melospiza    | melodia          |            1996 |   320 |\n| 1553 | Melospiza    | melodia          |            1990 |   307 |\n|  937 | Seiurus      | aurocapilla      |            2008 |   295 |\n| 2178 | Junco        | hyemalis         |            2014 |   289 |\n|  330 | Zonotrichia  | albicollis       |            2002 |   287 |\n| 1935 | Seiurus      | aurocapilla      |            2015 |   282 |\n| 1200 | Junco        | hyemalis         |            2015 |   278 |\n| 1595 | Catharus     | guttatus         |            2015 |   274 |\n| 1124 | Zonotrichia  | albicollis       |            2016 |   274 |\n| 2383 | Melospiza    | georgiana        |            1994 |   274 |\n|  744 | Seiurus      | aurocapilla      |            2009 |   268 |\n| 1177 | Certhia      | americana        |            2011 |   265 |\n| 2020 | Certhia      | americana        |            2013 |   263 |\n| 1370 | Junco        | hyemalis         |            2012 |   261 |\n| 2355 | Melospiza    | melodia          |            1986 |   261 |\n| 1809 | Oreothlypis  | peregrina        |            2014 |   260 |\n|  343 | Junco        | hyemalis         |            2013 |   250 |\n|  310 | Seiurus      | aurocapilla      |            2013 |   245 |\n| 1958 | Catharus     | guttatus         |            2013 |   245 |\n| 1591 | Junco        | hyemalis         |            1988 |   240 |\n|   65 | Melospiza    | melodia          |            1995 |   240 |\n| 2197 | Melospiza    | georgiana        |            1995 |   238 |\n| 1700 | Melospiza    | georgiana        |            1985 |   238 |\n| 1487 | Zonotrichia  | albicollis       |            2004 |   237 |\n|  925 | Melospiza    | melodia          |            1987 |   234 |\n|  572 | Junco        | hyemalis         |            2010 |   233 |\n|   22 | Catharus     | guttatus         |            2007 |   232 |\n| 1245 | Seiurus      | aurocapilla      |            2006 |   228 |\n|  247 | Zonotrichia  | albicollis       |            1985 |   226 |\n|  751 | Certhia      | americana        |            2016 |   223 |\n| 1014 | Catharus     | guttatus         |            2010 |   221 |\n| 1114 | Junco        | hyemalis         |            1994 |   221 |\n|  972 | Certhia      | americana        |            2012 |   219 |\n| 1966 | Junco        | hyemalis         |            1982 |   219 |\n|  741 | Junco        | hyemalis         |            2011 |   218 |\n| 1850 | Junco        | hyemalis         |            2006 |   218 |\n| 1029 | Seiurus      | aurocapilla      |            2007 |   215 |\n|  130 | Seiurus      | aurocapilla      |            2010 |   215 |\n|  102 | Junco        | hyemalis         |            1985 |   215 |\n|  329 | Junco        | hyemalis         |            1998 |   211 |\n| 1120 | Melospiza    | georgiana        |            2007 |   209 |\n| 1806 | Certhia      | americana        |            2014 |   209 |\n| 2011 | Oreothlypis  | peregrina        |            2015 |   206 |\n| 2422 | Catharus     | guttatus         |            2009 |   204 |\n|  137 | Catharus     | ustulatus        |            2014 |   201 |\n| 1377 | Melospiza    | melodia          |            1991 |   201 |\n| 2132 | Junco        | hyemalis         |            2008 |   199 |\n| 1142 | Junco        | hyemalis         |            1984 |   198 |\n| 1194 | Zonotrichia  | albicollis       |            1994 |   192 |\n| 1764 | Junco        | hyemalis         |            1989 |   189 |\n| 1915 | Melospiza    | melodia          |            2007 |   187 |\n|  811 | Melospiza    | georgiana        |            1996 |   187 |\n| 1795 | Catharus     | guttatus         |            2014 |   186 |\n|  801 | Catharus     | guttatus         |            2011 |   185 |\n| 2061 | Melospiza    | georgiana        |            2002 |   182 |\n| 1171 | Melospiza    | georgiana        |            2013 |   179 |\n| 2390 | Junco        | hyemalis         |            1990 |   178 |\n|  952 | Melospiza    | georgiana        |            1989 |   178 |\n| 1577 | Catharus     | ustulatus        |            2011 |   176 |\n| 1960 | Junco        | hyemalis         |            1986 |   175 |\n| 2053 | Junco        | hyemalis         |            2007 |   174 |\n| 1522 | Melospiza    | georgiana        |            1986 |   173 |\n|  200 | Zonotrichia  | albicollis       |            1995 |   173 |\n|  405 | Certhia      | americana        |            2015 |   172 |\n|  114 | Oreothlypis  | ruficapilla      |            2011 |   170 |\n|  369 | Certhia      | americana        |            2009 |   168 |\n|  236 | Oreothlypis  | peregrina        |            2012 |   168 |\n| 1781 | Melospiza    | melodia          |            1985 |   168 |\n|  514 | Zonotrichia  | albicollis       |            2003 |   166 |\n|  440 | Oreothlypis  | peregrina        |            2013 |   166 |\n|   58 | Junco        | hyemalis         |            2016 |   165 |\n|   93 | Melospiza    | georgiana        |            1987 |   162 |\n|  385 | Oreothlypis  | peregrina        |            2011 |   161 |\n|  935 | Catharus     | guttatus         |            2012 |   161 |\n| 1801 | Passerella   | iliaca           |            2007 |   161 |\n| 1945 | Melospiza    | georgiana        |            1982 |   160 |\n| 1844 | Regulus      | satrapa          |            2010 |   157 |\n| 1720 | Catharus     | ustulatus        |            2012 |   157 |\n| 1903 | Zonotrichia  | albicollis       |            2000 |   156 |\n|   43 | Zonotrichia  | albicollis       |            1984 |   155 |\n|  256 | Junco        | hyemalis         |            1992 |   153 |\n|  759 | Melospiza    | georgiana        |            1990 |   153 |\n| 2315 | Junco        | hyemalis         |            2009 |   153 |\n|  689 | Melospiza    | georgiana        |            1984 |   152 |\n| 2328 | Melospiza    | georgiana        |            1988 |   151 |\n| 1940 | Melospiza    | georgiana        |            2009 |   148 |\n| 1143 | Zonotrichia  | albicollis       |            1996 |   147 |\n| 1921 | Spizelloides | arborea          |            1998 |   147 |\n| 2245 | Melospiza    | georgiana        |            2001 |   146 |\n| 1292 | Junco        | hyemalis         |            1995 |   146 |\n| 1873 | Seiurus      | aurocapilla      |            2005 |   143 |\n| 2108 | Melospiza    | georgiana        |            2008 |   143 |\n| 1583 | Melospiza    | georgiana        |            1992 |   142 |\n|  562 | Melospiza    | melodia          |            1983 |   142 |\n|   78 | Certhia      | americana        |            2007 |   142 |\n| 2279 | Seiurus      | aurocapilla      |            1996 |   142 |\n| 1944 | Seiurus      | aurocapilla      |            2016 |   140 |\n| 2352 | Catharus     | ustulatus        |            2015 |   137 |\n| 1347 | Melospiza    | georgiana        |            2012 |   136 |\n|  265 | Certhia      | americana        |            2006 |   135 |\n|  547 | Certhia      | americana        |            2008 |   135 |\n|  866 | Catharus     | ustulatus        |            2016 |   134 |\n|  168 | Catharus     | guttatus         |            2008 |   134 |\n|  362 | Zonotrichia  | albicollis       |            1992 |   133 |\n| 1048 | Junco        | hyemalis         |            2004 |   132 |\n| 1100 | Passerella   | iliaca           |            2012 |   132 |\n|  955 | Junco        | hyemalis         |            1987 |   130 |\n| 1643 | Geothlypis   | trichas          |            1996 |   127 |\n| 1776 | Catharus     | ustulatus        |            2010 |   125 |\n|  986 | Zonotrichia  | albicollis       |            1989 |   125 |\n| 1442 | Catharus     | guttatus         |            2006 |   125 |\n| 1659 | Regulus      | satrapa          |            2016 |   125 |\n|  198 | Junco        | hyemalis         |            1991 |   124 |\n| 1072 | Melospiza    | melodia          |            1992 |   124 |\n|  865 | Melospiza    | melodia          |            1993 |   123 |\n| 1318 | Melospiza    | georgiana        |            2006 |   123 |\n| 1925 | Oreothlypis  | ruficapilla      |            2008 |   122 |\n|  838 | Zonotrichia  | albicollis       |            1986 |   122 |\n|  780 | Catharus     | ustulatus        |            2009 |   122 |\n| 1542 | Catharus     | ustulatus        |            2013 |   122 |\n|  418 | Zonotrichia  | albicollis       |            1990 |   120 |\n| 1575 | Passerella   | iliaca           |            2006 |   120 |\n|    1 | Passerella   | iliaca           |            1992 |   119 |\n|  943 | Catharus     | ustulatus        |            2008 |   119 |\n| 1717 | Melospiza    | melodia          |            1999 |   117 |\n|  760 | Oreothlypis  | ruficapilla      |            2014 |   117 |\n|  488 | Junco        | hyemalis         |            1993 |   116 |\n| 1400 | Melospiza    | georgiana        |            1993 |   116 |\n|  622 | Junco        | hyemalis         |            2000 |   116 |\n|  718 | Passerella   | iliaca           |            2014 |   114 |\n| 2129 | Melospiza    | melodia          |            2006 |   114 |\n| 1560 | Catharus     | guttatus         |            1994 |   113 |\n| 1702 | Oreothlypis  | ruficapilla      |            2009 |   112 |\n|  206 | Spizelloides | arborea          |            1991 |   111 |\n| 2347 | Junco        | hyemalis         |            1980 |   111 |\n|  323 | Melospiza    | lincolnii        |            2013 |   109 |\n| 1754 | Oreothlypis  | ruficapilla      |            2015 |   109 |\n|  316 | Oreothlypis  | ruficapilla      |            2010 |   108 |\n|  368 | Setophaga    | magnolia         |            2012 |   107 |\n| 2168 | Melospiza    | lincolnii        |            2010 |   107 |\n| 1496 | Catharus     | guttatus         |            2016 |   105 |\n| 2063 | Melospiza    | melodia          |            2012 |   105 |\n| 1613 | Melospiza    | georgiana        |            1998 |   105 |\n| 2159 | Melospiza    | georgiana        |            2014 |   105 |\n| 1275 | Melospiza    | georgiana        |            2000 |   102 |\n| 2167 | Catharus     | guttatus         |            1989 |   101 |\n| 1156 | Oreothlypis  | peregrina        |            2007 |   100 |\n| 2218 | Melospiza    | melodia          |            1989 |   100 |\n|  470 | Zonotrichia  | albicollis       |            1982 |    99 |\n|  389 | Melospiza    | lincolnii        |            2007 |    99 |\n| 1655 | Seiurus      | aurocapilla      |            2002 |    99 |\n| 1660 | Catharus     | ustulatus        |            2006 |    98 |\n| 1649 | Seiurus      | aurocapilla      |            1985 |    97 |\n| 1207 | Spizelloides | arborea          |            1988 |    96 |\n|  544 | Melospiza    | georgiana        |            1983 |    96 |\n| 1132 | Oreothlypis  | ruficapilla      |            2012 |    96 |\n| 2379 | Setophaga    | magnolia         |            2014 |    95 |\n| 1732 | Junco        | hyemalis         |            1999 |    95 |\n|  926 | Oreothlypis  | ruficapilla      |            2013 |    95 |\n| 1808 | Melospiza    | lincolnii        |            2008 |    95 |\n|  466 | Melospiza    | georgiana        |            2004 |    95 |\n| 1742 | Setophaga    | magnolia         |            2011 |    94 |\n| 1300 | Melospiza    | melodia          |            2000 |    93 |\n|  855 | Passerella   | iliaca           |            2009 |    93 |\n|  538 | Melospiza    | georgiana        |            2010 |    93 |\n| 1432 | Catharus     | guttatus         |            1985 |    91 |\n| 1121 | Setophaga    | magnolia         |            2008 |    91 |\n| 1334 | Oreothlypis  | peregrina        |            2000 |    91 |\n| 1879 | Passerella   | iliaca           |            2008 |    90 |\n|  566 | Zonotrichia  | albicollis       |            1993 |    90 |\n| 2123 | Zonotrichia  | albicollis       |            2001 |    89 |\n|  354 | Oreothlypis  | peregrina        |            1992 |    89 |\n| 1787 | Geothlypis   | trichas          |            2014 |    88 |\n| 1315 | Passerella   | iliaca           |            1988 |    88 |\n| 1982 | Zonotrichia  | albicollis       |            1998 |    88 |\n|  548 | Melospiza    | lincolnii        |            2014 |    88 |\n|  257 | Seiurus      | aurocapilla      |            2003 |    88 |\n| 1968 | Melospiza    | georgiana        |            2015 |    88 |\n|  677 | Melospiza    | georgiana        |            2003 |    87 |\n| 1428 | Melospiza    | melodia          |            2009 |    87 |\n|  283 | Passerella   | iliaca           |            2010 |    87 |\n| 2079 | Seiurus      | aurocapilla      |            2004 |    87 |\n| 1697 | Regulus      | satrapa          |            2013 |    86 |\n| 2037 | Zonotrichia  | albicollis       |            1988 |    86 |\n|  941 | Setophaga    | magnolia         |            2009 |    85 |\n| 1382 | Oreothlypis  | peregrina        |            2010 |    85 |\n|  950 | Zonotrichia  | leucophrys       |            2015 |    84 |\n| 1647 | Catharus     | guttatus         |            2005 |    84 |\n| 1656 | Certhia      | americana        |            2005 |    83 |\n|  890 | Passerella   | iliaca           |            2015 |    83 |\n| 1049 | Zonotrichia  | albicollis       |            1987 |    82 |\n| 1665 | Seiurus      | aurocapilla      |            1983 |    82 |\n| 1004 | Spizelloides | arborea          |            1982 |    81 |\n|  755 | Setophaga    | coronata         |            2001 |    81 |\n| 1980 | Melospiza    | lincolnii        |            2009 |    81 |\n| 1258 | Junco        | hyemalis         |            2005 |    81 |\n| 1658 | Passerella   | iliaca           |            2011 |    81 |\n| 1519 | Setophaga    | striata          |            2014 |    80 |\n| 1384 | Catharus     | guttatus         |            1995 |    80 |\n|  806 | Passerella   | iliaca           |            1994 |    80 |\n| 1951 | Melospiza    | lincolnii        |            2015 |    79 |\n|  646 | Seiurus      | aurocapilla      |            1984 |    79 |\n| 1247 | Melospiza    | melodia          |            2014 |    79 |\n|  315 | Melospiza    | georgiana        |            2011 |    79 |\n|  611 | Melospiza    | georgiana        |            1997 |    79 |\n|  549 | Melospiza    | georgiana        |            1991 |    79 |\n| 1507 | Catharus     | guttatus         |            1996 |    79 |\n| 2209 | Setophaga    | ruticilla        |            2008 |    78 |\n| 2365 | Catharus     | guttatus         |            1988 |    78 |\n|  914 | Setophaga    | ruticilla        |            2014 |    78 |\n| 2221 | Oreothlypis  | peregrina        |            2008 |    77 |\n| 2112 | Regulus      | satrapa          |            2015 |    77 |\n|  832 | Mniotilta    | varia            |            2014 |    77 |\n| 1001 | Melospiza    | lincolnii        |            1985 |    77 |\n| 1884 | Seiurus      | aurocapilla      |            1982 |    77 |\n| 1615 | Oreothlypis  | ruficapilla      |            2006 |    76 |\n|  784 | Melospiza    | melodia          |            2010 |    76 |\n| 1953 | Oreothlypis  | peregrina        |            2005 |    76 |\n| 1510 | Passerella   | iliaca           |            1989 |    76 |\n|  995 | Setophaga    | magnolia         |            2015 |    75 |\n| 1183 | Oreothlypis  | peregrina        |            2009 |    75 |\n| 1446 | Sitta        | canadensis       |            2012 |    75 |\n| 2005 | Geothlypis   | trichas          |            2013 |    75 |\n|  331 | Catharus     | minimus          |            2012 |    75 |\n| 2064 | Geothlypis   | trichas          |            2011 |    74 |\n|  573 | Oreothlypis  | peregrina        |            2016 |    74 |\n|  779 | Oreothlypis  | peregrina        |            1996 |    74 |\n| 1796 | Seiurus      | aurocapilla      |            1990 |    74 |\n| 2104 | Oreothlypis  | ruficapilla      |            2016 |    74 |\n| 2289 | Passerella   | iliaca           |            1985 |    73 |\n| 2337 | Passerella   | iliaca           |            1991 |    73 |\n|  423 | Junco        | hyemalis         |            2003 |    73 |\n| 1478 | Melospiza    | georgiana        |            2005 |    73 |\n| 2002 | Junco        | hyemalis         |            2001 |    72 |\n| 1848 | Melospiza    | melodia          |            2016 |    72 |\n|  166 | Setophaga    | magnolia         |            2013 |    71 |\n|  432 | Catharus     | ustulatus        |            1992 |    71 |\n|  518 | Melospiza    | melodia          |            2004 |    71 |\n| 2345 | Setophaga    | ruticilla        |            2015 |    71 |\n|  285 | Catharus     | ustulatus        |            2007 |    71 |\n| 2085 | Oreothlypis  | peregrina        |            1985 |    70 |\n| 2148 | Passerella   | iliaca           |            1990 |    70 |\n| 1988 | Melospiza    | melodia          |            1982 |    70 |\n| 2421 | Geothlypis   | trichas          |            1984 |    69 |\n| 1814 | Catharus     | guttatus         |            1983 |    69 |\n| 1972 | Regulus      | satrapa          |            2006 |    69 |\n| 1179 | Melospiza    | lincolnii        |            2011 |    69 |\n| 2191 | Geothlypis   | trichas          |            2012 |    69 |\n|   32 | Mniotilta    | varia            |            2012 |    68 |\n| 2283 | Catharus     | guttatus         |            2000 |    68 |\n|  665 | Catharus     | guttatus         |            2002 |    68 |\n|  793 | Catharus     | guttatus         |            1982 |    68 |\n| 1863 | Oreothlypis  | peregrina        |            1984 |    67 |\n|  727 | Melospiza    | melodia          |            1984 |    66 |\n|  217 | Geothlypis   | trichas          |            2008 |    66 |\n|  671 | Setophaga    | magnolia         |            2007 |    66 |\n| 2014 | Catharus     | guttatus         |            1990 |    66 |\n|  667 | Seiurus      | aurocapilla      |            1994 |    66 |\n| 1282 | Regulus      | satrapa          |            2009 |    65 |\n| 2304 | Catharus     | fuscescens       |            1990 |    65 |\n| 1891 | Melospiza    | lincolnii        |            1996 |    65 |\n|  762 | Passerella   | iliaca           |            2016 |    65 |\n|  672 | Passerella   | iliaca           |            1987 |    65 |\n|  824 | Zonotrichia  | albicollis       |            1980 |    65 |\n| 2300 | Zonotrichia  | albicollis       |            1979 |    64 |\n| 1476 | Spizelloides | arborea          |            1994 |    64 |\n|  886 | Seiurus      | aurocapilla      |            1979 |    64 |\n| 2268 | Melospiza    | melodia          |            2015 |    64 |\n| 2397 | Setophaga    | ruticilla        |            2009 |    64 |\n|  848 | Setophaga    | magnolia         |            2006 |    64 |\n| 2306 | Catharus     | guttatus         |            1998 |    64 |\n|  215 | Setophaga    | coronata         |            1985 |    63 |\n| 1892 | Regulus      | satrapa          |            2012 |    63 |\n|  805 | Melospiza    | lincolnii        |            1984 |    63 |\n|  739 | Parkesia     | noveboracensis   |            2012 |    63 |\n| 2150 | Setophaga    | striata          |            2016 |    63 |\n| 1877 | Mniotilta    | varia            |            2015 |    62 |\n|   80 | Passerella   | iliaca           |            2013 |    62 |\n|  581 | Spizelloides | arborea          |            1985 |    62 |\n| 1952 | Catharus     | minimus          |            2014 |    62 |\n| 1218 | Geothlypis   | trichas          |            2009 |    61 |\n|  714 | Catharus     | guttatus         |            1992 |    61 |\n| 1420 | Junco        | hyemalis         |            2002 |    61 |\n| 1541 | Setophaga    | ruticilla        |            2011 |    60 |\n|  162 | Seiurus      | aurocapilla      |            1988 |    60 |\n| 1246 | Melospiza    | lincolnii        |            2005 |    60 |\n| 2161 | Oreothlypis  | peregrina        |            2006 |    60 |\n| 1439 | Passerella   | iliaca           |            1982 |    59 |\n| 2242 | Setophaga    | magnolia         |            1996 |    59 |\n|   72 | Setophaga    | palmarum         |            2014 |    59 |\n| 1129 | Melospiza    | georgiana        |            1980 |    59 |\n| 2222 | Zonotrichia  | leucophrys       |            2009 |    59 |\n| 2140 | Junco        | hyemalis         |            1983 |    58 |\n| 1500 | Junco        | hyemalis         |            1978 |    58 |\n|  868 | Catharus     | guttatus         |            2001 |    58 |\n| 2235 | Passerella   | iliaca           |            1995 |    58 |\n|  314 | Melospiza    | lincolnii        |            1994 |    58 |\n| 1359 | Zonotrichia  | albicollis       |            1997 |    58 |\n| 1250 | Passerina    | cyanea           |            1982 |    57 |\n| 1381 | Melospiza    | lincolnii        |            2012 |    57 |\n| 1862 | Melospiza    | lincolnii        |            2002 |    57 |\n| 1860 | Catharus     | ustulatus        |            2005 |    56 |\n| 1249 | Catharus     | guttatus         |            1986 |    56 |\n| 2277 | Catharus     | guttatus         |            1979 |    56 |\n|  188 | Melospiza    | lincolnii        |            2006 |    56 |\n|  512 | Passerella   | iliaca           |            1986 |    56 |\n| 2415 | Catharus     | guttatus         |            1980 |    56 |\n|  657 | Melospiza    | melodia          |            2013 |    56 |\n| 1263 | Passerella   | iliaca           |            1998 |    55 |\n|  717 | Setophaga    | ruticilla        |            2013 |    55 |\n|  266 | Seiurus      | aurocapilla      |            1980 |    55 |\n| 1636 | Melospiza    | melodia          |            2008 |    55 |\n| 1099 | Regulus      | satrapa          |            2014 |    55 |\n| 1928 | Geothlypis   | trichas          |            2007 |    54 |\n| 1268 | Melospiza    | lincolnii        |            1982 |    54 |\n|  644 | Zonotrichia  | albicollis       |            1983 |    54 |\n| 1943 | Oreothlypis  | peregrina        |            1994 |    53 |\n| 1344 | Junco        | hyemalis         |            1981 |    53 |\n|  564 | Parkesia     | noveboracensis   |            2013 |    53 |\n| 1429 | Oreothlypis  | ruficapilla      |            2007 |    53 |\n|   81 | Setophaga    | striata          |            2011 |    53 |\n|  338 | Oreothlypis  | peregrina        |            1983 |    52 |\n| 1942 | Setophaga    | magnolia         |            2010 |    52 |\n|  814 | Zonotrichia  | leucophrys       |            2008 |    52 |\n|  177 | Zonotrichia  | leucophrys       |            1986 |    52 |\n|  663 | Geothlypis   | trichas          |            1993 |    52 |\n| 1181 | Catharus     | minimus          |            2010 |    52 |\n| 1317 | Geothlypis   | trichas          |            2016 |    52 |\n|  616 | Parkesia     | noveboracensis   |            2011 |    52 |\n|  498 | Junco        | hyemalis         |            1979 |    52 |\n|  942 | Passerella   | iliaca           |            2005 |    52 |\n| 1588 | Parkesia     | noveboracensis   |            2014 |    51 |\n| 1870 | Melospiza    | lincolnii        |            2016 |    51 |\n|  408 | Geothlypis   | trichas          |            2015 |    51 |\n| 1772 | Setophaga    | coronata         |            2000 |    51 |\n| 1094 | Setophaga    | striata          |            2010 |    51 |\n|  534 | Catharus     | guttatus         |            1993 |    51 |\n|  976 | Setophaga    | coronata         |            2012 |    51 |\n| 2200 | Parkesia     | noveboracensis   |            2009 |    51 |\n| 1191 | Parkesia     | noveboracensis   |            2008 |    51 |\n|  592 | Oreothlypis  | ruficapilla      |            1996 |    51 |\n| 2004 | Mniotilta    | varia            |            2008 |    51 |\n| 1766 | Setophaga    | ruticilla        |            2012 |    51 |\n| 1309 | Seiurus      | aurocapilla      |            1993 |    50 |\n|  893 | Setophaga    | striata          |            2009 |    50 |\n| 2205 | Geothlypis   | trichas          |            1985 |    50 |\n| 1059 | Mniotilta    | varia            |            2013 |    50 |\n| 2402 | Setophaga    | coronata         |            2013 |    50 |\n|   77 | Seiurus      | aurocapilla      |            2000 |    50 |\n| 1248 | Catharus     | ustulatus        |            1994 |    49 |\n| 1716 | Melospiza    | lincolnii        |            1995 |    49 |\n| 1959 | Passerina    | cyanea           |            2011 |    49 |\n|  183 | Zonotrichia  | leucophrys       |            2011 |    49 |\n|  875 | Spizelloides | arborea          |            2012 |    48 |\n| 1324 | Melospiza    | georgiana        |            1979 |    48 |\n| 1721 | Setophaga    | striata          |            2015 |    48 |\n| 1704 | Catharus     | guttatus         |            2003 |    47 |\n| 1355 | Geothlypis   | trichas          |            2002 |    46 |\n| 1888 | Dumetella    | carolinensis     |            2014 |    46 |\n|  506 | Seiurus      | aurocapilla      |            1995 |    46 |\n| 2124 | Catharus     | minimus          |            2015 |    46 |\n| 2384 | Melospiza    | lincolnii        |            1986 |    46 |\n| 1648 | Setophaga    | palmarum         |            1985 |    46 |\n|  541 | Zonotrichia  | leucophrys       |            1994 |    46 |\n|  731 | Zonotrichia  | leucophrys       |            2014 |    46 |\n|  610 | Zonotrichia  | leucophrys       |            2007 |    46 |\n| 1654 | Passerella   | iliaca           |            1996 |    46 |\n|  441 | Setophaga    | coronata         |            1996 |    46 |\n| 2041 | Melospiza    | georgiana        |            2016 |    46 |\n|  729 | Troglodytes  | hiemalis         |            2008 |    46 |\n| 1492 | Melospiza    | melodia          |            2003 |    45 |\n|   30 | Pheucticus   | ludovicianus     |            2011 |    45 |\n| 2229 | Catharus     | guttatus         |            1987 |    45 |\n| 1755 | Regulus      | satrapa          |            2007 |    45 |\n|  457 | Setophaga    | palmarum         |            2012 |    45 |\n| 1103 | Catharus     | ustulatus        |            1982 |    45 |\n|  126 | Catharus     | minimus          |            2011 |    45 |\n| 2040 | Passerina    | cyanea           |            1985 |    44 |\n|  218 | Catharus     | ustulatus        |            1993 |    44 |\n|  493 | Melospiza    | melodia          |            2002 |    44 |\n| 1257 | Setophaga    | palmarum         |            2008 |    44 |\n| 1006 | Geothlypis   | trichas          |            2010 |    44 |\n| 1947 | Catharus     | ustulatus        |            1984 |    44 |\n| 1311 | Catharus     | fuscescens       |            1985 |    44 |\n|  346 | Spizelloides | arborea          |            1996 |    44 |\n|  467 | Regulus      | satrapa          |            2011 |    43 |\n| 1448 | Regulus      | calendula        |            2009 |    43 |\n|  922 | Oreothlypis  | peregrina        |            1995 |    43 |\n|   87 | Melospiza    | lincolnii        |            1993 |    43 |\n|  340 | Melospiza    | melodia          |            2005 |    43 |\n|  239 | Melospiza    | lincolnii        |            2000 |    43 |\n|  397 | Spizelloides | arborea          |            1990 |    43 |\n|  132 | Oreothlypis  | peregrina        |            1982 |    43 |\n|  298 | Catharus     | ustulatus        |            1988 |    43 |\n|  379 | Troglodytes  | hiemalis         |            2014 |    42 |\n|  268 | Regulus      | satrapa          |            2008 |    42 |\n|  264 | Setophaga    | ruticilla        |            2007 |    42 |\n| 2356 | Setophaga    | coronata         |            1982 |    42 |\n| 2078 | Geothlypis   | trichas          |            1983 |    42 |\n|  778 | Passerella   | iliaca           |            2004 |    42 |\n|  631 | Melospiza    | melodia          |            2011 |    42 |\n|  211 | Mniotilta    | varia            |            2011 |    42 |\n| 1876 | Melospiza    | lincolnii        |            1979 |    42 |\n|  796 | Seiurus      | aurocapilla      |            1987 |    42 |\n|  654 | Regulus      | calendula        |            2011 |    42 |\n| 1543 | Oreothlypis  | ruficapilla      |            1979 |    41 |\n|  726 | Melospiza    | lincolnii        |            1990 |    41 |\n| 1243 | Zonotrichia  | leucophrys       |            1985 |    41 |\n|  172 | Melospiza    | lincolnii        |            1987 |    41 |\n| 2319 | Melospiza    | lincolnii        |            1992 |    41 |\n| 2029 | Melospiza    | lincolnii        |            2003 |    41 |\n|  175 | Regulus      | satrapa          |            2005 |    41 |\n|  234 | Melospiza    | lincolnii        |            1983 |    41 |\n| 1211 | Catharus     | ustulatus        |            1996 |    40 |\n| 2141 | Geothlypis   | trichas          |            2006 |    40 |\n| 1756 | Zonotrichia  | leucophrys       |            2013 |    40 |\n|  585 | Catharus     | ustulatus        |            1985 |    40 |\n| 1054 | Spizelloides | arborea          |            2015 |    40 |\n|  227 | Setophaga    | palmarum         |            2009 |    40 |\n| 2313 | Melospiza    | melodia          |            2001 |    40 |\n| 2238 | Catharus     | fuscescens       |            1996 |    40 |\n|  394 | Catharus     | guttatus         |            1984 |    39 |\n| 1484 | Geothlypis   | trichas          |            1995 |    39 |\n| 1584 | Setophaga    | magnolia         |            2016 |    39 |\n| 2231 | Seiurus      | aurocapilla      |            1986 |    39 |\n| 2385 | Zonotrichia  | leucophrys       |            2010 |    39 |\n| 1063 | Catharus     | ustulatus        |            1995 |    39 |\n|    5 | Setophaga    | striata          |            2006 |    39 |\n|  856 | Catharus     | ustulatus        |            2004 |    39 |\n| 2100 | Passerina    | cyanea           |            2012 |    38 |\n|  110 | Setophaga    | palmarum         |            2016 |    38 |\n| 1396 | Passerella   | iliaca           |            1993 |    38 |\n|  524 | Oreothlypis  | peregrina        |            2002 |    38 |\n| 2169 | Zonotrichia  | albicollis       |            1999 |    38 |\n| 2116 | Zonotrichia  | albicollis       |            1978 |    38 |\n| 1406 | Parkesia     | noveboracensis   |            2015 |    38 |\n|  648 | Passerella   | iliaca           |            1980 |    38 |\n| 1981 | Oreothlypis  | ruficapilla      |            1995 |    38 |\n| 1508 | Seiurus      | aurocapilla      |            1992 |    38 |\n| 1571 | Seiurus      | aurocapilla      |            1991 |    38 |\n|   63 | Catharus     | ustulatus        |            2000 |    38 |\n| 1580 | Melospiza    | lincolnii        |            1988 |    38 |\n|  640 | Geothlypis   | trichas          |            1987 |    38 |\n|  393 | Melospiza    | melodia          |            1980 |    38 |\n| 2232 | Setophaga    | pensylvanica     |            1996 |    37 |\n|  554 | Catharus     | minimus          |            2013 |    37 |\n| 2240 | Setophaga    | magnolia         |            2005 |    37 |\n| 1828 | Mniotilta    | varia            |            2009 |    37 |\n| 1319 | Zonotrichia  | leucophrys       |            1998 |    37 |\n|  267 | Setophaga    | coronata         |            1995 |    37 |\n| 1205 | Mniotilta    | varia            |            2006 |    37 |\n| 2357 | Troglodytes  | hiemalis         |            2010 |    37 |\n|  249 | Passerina    | cyanea           |            1996 |    37 |\n| 1736 | Sitta        | canadensis       |            2007 |    37 |\n|  430 | Spizelloides | arborea          |            2008 |    37 |\n|  923 | Catharus     | ustulatus        |            1983 |    37 |\n| 1302 | Dumetella    | carolinensis     |            2011 |    37 |\n| 1823 | Catharus     | guttatus         |            2004 |    36 |\n|  136 | Passerella   | iliaca           |            2003 |    36 |\n|  504 | Geothlypis   | trichas          |            1994 |    36 |\n| 1040 | Oreothlypis  | ruficapilla      |            1984 |    36 |\n| 1098 | Melospiza    | lincolnii        |            1998 |    36 |\n| 1750 | Setophaga    | ruticilla        |            2016 |    36 |\n| 2162 | Zonotrichia  | leucophrys       |            1990 |    36 |\n| 2312 | Spizelloides | arborea          |            1992 |    36 |\n| 2192 | Catharus     | minimus          |            2016 |    36 |\n| 1071 | Oreothlypis  | peregrina        |            1986 |    36 |\n|  721 | Setophaga    | striata          |            2008 |    36 |\n| 2286 | Geothlypis   | trichas          |            1982 |    36 |\n| 1927 | Hylocichla   | mustelina        |            2010 |    35 |\n| 1752 | Hylocichla   | mustelina        |            2011 |    35 |\n|  604 | Sitta        | canadensis       |            2010 |    35 |\n| 1277 | Setophaga    | magnolia         |            1985 |    35 |\n|  684 | Certhia      | americana        |            1985 |    35 |\n| 1567 | Geothlypis   | trichas          |            1990 |    35 |\n| 2164 | Troglodytes  | hiemalis         |            2009 |    35 |\n|  138 | Setophaga    | striata          |            2013 |    35 |\n| 1383 | Troglodytes  | hiemalis         |            2013 |    34 |\n| 2305 | Setophaga    | ruticilla        |            1996 |    34 |\n| 1517 | Passerella   | iliaca           |            2000 |    34 |\n|   60 | Setophaga    | coronata         |            1994 |    34 |\n| 1451 | Melospiza    | georgiana        |            1999 |    34 |\n|  556 | Geothlypis   | trichas          |            2000 |    34 |\n| 2086 | Zonotrichia  | leucophrys       |            2002 |    34 |\n| 1998 | Spizelloides | arborea          |            1984 |    33 |\n| 2118 | Melospiza    | georgiana        |            1981 |    33 |\n| 1861 | Dumetella    | carolinensis     |            2008 |    33 |\n| 1867 | Setophaga    | palmarum         |            2013 |    33 |\n| 1807 | Parkesia     | noveboracensis   |            1990 |    33 |\n| 1885 | Catharus     | fuscescens       |            2015 |    33 |\n| 1027 | Zonotrichia  | leucophrys       |            1984 |    33 |\n| 1152 | Catharus     | ustulatus        |            1990 |    33 |\n| 2377 | Setophaga    | striata          |            2012 |    33 |\n| 1327 | Troglodytes  | hiemalis         |            2011 |    33 |\n| 1329 | Parkesia     | noveboracensis   |            1996 |    33 |\n|  586 | Troglodytes  | hiemalis         |            2015 |    33 |\n|  847 | Seiurus      | aurocapilla      |            1997 |    33 |\n|  973 | Hylocichla   | mustelina        |            2007 |    33 |\n| 1101 | Oreothlypis  | peregrina        |            1988 |    33 |\n| 1166 | Passerina    | cyanea           |            2009 |    32 |\n|  711 | Catharus     | fuscescens       |            1988 |    32 |\n|  196 | Melospiza    | melodia          |            1981 |    32 |\n| 1670 | Oreothlypis  | peregrina        |            1991 |    32 |\n|  584 | Oreothlypis  | peregrina        |            2004 |    32 |\n|  240 | Sitta        | canadensis       |            2016 |    32 |\n| 2035 | Parkesia     | noveboracensis   |            2010 |    32 |\n| 1719 | Oreothlypis  | peregrina        |            1993 |    32 |\n|   96 | Spizelloides | arborea          |            2000 |    32 |\n|  764 | Geothlypis   | trichas          |            1988 |    32 |\n|  804 | Oreothlypis  | ruficapilla      |            1983 |    31 |\n|  807 | Regulus      | calendula        |            2010 |    31 |\n|  863 | Spizelloides | arborea          |            2016 |    31 |\n| 1073 | Setophaga    | coronata         |            1993 |    31 |\n| 1466 | Catharus     | fuscescens       |            1984 |    31 |\n|   57 | Setophaga    | ruticilla        |            2006 |    31 |\n| 1453 | Cardellina   | canadensis       |            1996 |    31 |\n|  342 | Oporornis    | agilis           |            2006 |    31 |\n| 1159 | Geothlypis   | trichas          |            2003 |    31 |\n|   15 | Catharus     | guttatus         |            1978 |    31 |\n| 1161 | Setophaga    | palmarum         |            2007 |    31 |\n|  957 | Catharus     | minimus          |            2009 |    30 |\n|  735 | Setophaga    | pensylvanica     |            2014 |    30 |\n| 1333 | Catharus     | minimus          |            1985 |    30 |\n|  975 | Oreothlypis  | ruficapilla      |            1982 |    30 |\n| 1061 | Setophaga    | ruticilla        |            2005 |    30 |\n|  903 | Junco        | hyemalis         |            1997 |    30 |\n| 1033 | Pheucticus   | ludovicianus     |            2014 |    30 |\n|  724 | Zonotrichia  | leucophrys       |            1995 |    30 |\n| 1341 | Parkesia     | noveboracensis   |            1982 |    30 |\n| 1039 | Melospiza    | lincolnii        |            2004 |    30 |\n| 2417 | Passerella   | iliaca           |            1979 |    30 |\n| 1843 | Zonotrichia  | albicollis       |            1991 |    30 |\n| 2382 | Hylocichla   | mustelina        |            2006 |    30 |\n|  112 | Melospiza    | melodia          |            1997 |    30 |\n|  109 | Geothlypis   | philadelphia     |            1996 |    30 |\n| 1650 | Passerella   | iliaca           |            1983 |    30 |\n| 1260 | Zonotrichia  | leucophrys       |            1982 |    29 |\n| 2068 | Oreothlypis  | ruficapilla      |            1985 |    29 |\n|  123 | Setophaga    | coronata         |            2016 |    29 |\n| 2214 | Catharus     | minimus          |            1996 |    29 |\n|  690 | Setophaga    | castanea         |            2012 |    29 |\n|   83 | Seiurus      | aurocapilla      |            1981 |    29 |\n|   91 | Passerina    | cyanea           |            1995 |    29 |\n| 1155 | Spizelloides | arborea          |            1986 |    29 |\n| 2331 | Zonotrichia  | leucophrys       |            2016 |    29 |\n| 1747 | Melospiza    | lincolnii        |            1989 |    29 |\n| 1185 | Troglodytes  | hiemalis         |            2012 |    28 |\n| 1358 | Oreothlypis  | ruficapilla      |            1992 |    28 |\n|  590 | Setophaga    | pensylvanica     |            2013 |    28 |\n| 1576 | Regulus      | calendula        |            2014 |    28 |\n| 1043 | Passerina    | cyanea           |            1983 |    28 |\n|  376 | Catharus     | ustulatus        |            1986 |    28 |\n| 1325 | Catharus     | ustulatus        |            1989 |    28 |\n| 2075 | Geothlypis   | trichas          |            1992 |    28 |\n| 1066 | Geothlypis   | philadelphia     |            2009 |    28 |\n|   25 | Seiurus      | aurocapilla      |            1999 |    28 |\n| 1000 | Spizelloides | arborea          |            1989 |    28 |\n|  899 | Hylocichla   | mustelina        |            2009 |    28 |\n|  619 | Catharus     | fuscescens       |            1992 |    28 |\n| 1985 | Catharus     | minimus          |            2008 |    28 |\n|  782 | Setophaga    | coronata         |            2011 |    28 |\n| 2376 | Passerella   | iliaca           |            2002 |    28 |\n| 1037 | Parkesia     | noveboracensis   |            1986 |    28 |\n| 2411 | Oreothlypis  | ruficapilla      |            2002 |    28 |\n|   10 | Parkesia     | noveboracensis   |            1985 |    28 |\n|  911 | Spizelloides | arborea          |            2006 |    28 |\n| 1767 | Passerina    | cyanea           |            1988 |    28 |\n| 2236 | Regulus      | calendula        |            2013 |    28 |\n| 2185 | Catharus     | fuscescens       |            1994 |    28 |\n|  591 | Catharus     | guttatus         |            1991 |    28 |\n| 1555 | Oreothlypis  | ruficapilla      |            2000 |    27 |\n|  462 | Dumetella    | carolinensis     |            2009 |    27 |\n| 1030 | Certhia      | americana        |            2002 |    27 |\n| 1610 | Mniotilta    | varia            |            2010 |    27 |\n|   41 | Melospiza    | lincolnii        |            1999 |    27 |\n|  147 | Setophaga    | coronata         |            2014 |    27 |\n| 1228 | Spizella     | pusilla          |            1986 |    27 |\n|  670 | Catharus     | fuscescens       |            1986 |    27 |\n| 2144 | Catharus     | guttatus         |            1999 |    27 |\n| 2062 | Setophaga    | coronata         |            1998 |    27 |\n| 2343 | Spizella     | pusilla          |            1982 |    27 |\n| 1657 | Catharus     | fuscescens       |            2010 |    27 |\n|  261 | Pheucticus   | ludovicianus     |            2010 |    27 |\n| 1368 | Setophaga    | ruticilla        |            2010 |    27 |\n|  284 | Oreothlypis  | peregrina        |            1990 |    27 |\n|  149 | Catharus     | ustulatus        |            1987 |    26 |\n| 1637 | Setophaga    | coronata         |            2009 |    26 |\n|  632 | Oreothlypis  | ruficapilla      |            2005 |    26 |\n|  857 | Dumetella    | carolinensis     |            2013 |    26 |\n| 2351 | Oreothlypis  | peregrina        |            1998 |    26 |\n|  601 | Zonotrichia  | leucophrys       |            1988 |    26 |\n| 2346 | Parkesia     | noveboracensis   |            1983 |    26 |\n|  939 | Oreothlypis  | peregrina        |            1980 |    26 |\n| 1815 | Catharus     | minimus          |            2007 |    25 |\n| 2027 | Dumetella    | carolinensis     |            2007 |    25 |\n| 1255 | Oreothlypis  | peregrina        |            1987 |    25 |\n| 1765 | Spizelloides | arborea          |            2004 |    25 |\n| 1093 | Dumetella    | carolinensis     |            2012 |    25 |\n|  979 | Mniotilta    | varia            |            2007 |    25 |\n|  197 | Passerina    | cyanea           |            1990 |    25 |\n|  259 | Spizelloides | arborea          |            2009 |    25 |\n|  435 | Troglodytes  | hiemalis         |            2016 |    25 |\n|  275 | Hylocichla   | mustelina        |            2014 |    25 |\n| 1178 | Parkesia     | noveboracensis   |            1995 |    25 |\n|  607 | Dumetella    | carolinensis     |            2002 |    25 |\n| 1213 | Geothlypis   | philadelphia     |            2014 |    25 |\n| 1629 | Passerina    | cyanea           |            1987 |    25 |\n|  262 | Catharus     | fuscescens       |            2011 |    25 |\n|  459 | Pheucticus   | ludovicianus     |            2013 |    25 |\n|  499 | Hylocichla   | mustelina        |            2013 |    24 |\n|  186 | Parkesia     | noveboracensis   |            1984 |    24 |\n| 1457 | Catharus     | minimus          |            1992 |    24 |\n|   33 | Zonotrichia  | leucophrys       |            2004 |    24 |\n|  151 | Parkesia     | noveboracensis   |            1994 |    24 |\n| 1398 | Setophaga    | striata          |            2007 |    24 |\n| 1452 | Zonotrichia  | leucophrys       |            2005 |    24 |\n| 1590 | Setophaga    | palmarum         |            1995 |    24 |\n| 1874 | Certhia      | americana        |            2004 |    24 |\n| 1596 | Catharus     | fuscescens       |            1982 |    24 |\n| 1833 | Pheucticus   | ludovicianus     |            2012 |    24 |\n| 1831 | Spizelloides | arborea          |            2011 |    24 |\n| 1096 | Oreothlypis  | peregrina        |            1979 |    24 |\n|  238 | Catharus     | minimus          |            1982 |    24 |\n|  929 | Passerculus  | sandwichensis    |            1996 |    24 |\n|  296 | Catharus     | ustulatus        |            1980 |    24 |\n|  255 | Setophaga    | palmarum         |            2015 |    24 |\n| 1751 | Parkesia     | noveboracensis   |            1992 |    24 |\n| 2006 | Catharus     | ustulatus        |            1998 |    24 |\n|   67 | Oreothlypis  | peregrina        |            1989 |    24 |\n| 1715 | Dumetella    | carolinensis     |            2015 |    24 |\n| 1016 | Setophaga    | palmarum         |            1996 |    24 |\n| 1018 | Setophaga    | palmarum         |            2011 |    24 |\n| 1360 | Empidonax    | traillii         |            2013 |    24 |\n|  852 | Melospiza    | lincolnii        |            1980 |    24 |\n| 2056 | Spizelloides | arborea          |            2010 |    23 |\n|  828 | Oporornis    | agilis           |            2008 |    23 |\n|  946 | Melospiza    | lincolnii        |            1991 |    23 |\n| 2180 | Spizelloides | arborea          |            1987 |    23 |\n| 1308 | Geothlypis   | trichas          |            2004 |    23 |\n|  993 | Hylocichla   | mustelina        |            1979 |    23 |\n| 1337 | Setophaga    | virens           |            2011 |    23 |\n| 1529 | Parkesia     | noveboracensis   |            2016 |    23 |\n|  634 | Geothlypis   | philadelphia     |            2013 |    23 |\n|  415 | Catharus     | minimus          |            2006 |    23 |\n| 2249 | Zonotrichia  | albicollis       |            1981 |    23 |\n| 2103 | Setophaga    | fusca            |            2013 |    23 |\n| 1896 | Passerina    | cyanea           |            1992 |    23 |\n|  880 | Catharus     | fuscescens       |            2014 |    23 |\n|  531 | Setophaga    | virens           |            2009 |    22 |\n| 2084 | Certhia      | americana        |            2003 |    22 |\n|  682 | Zonotrichia  | leucophrys       |            2001 |    22 |\n|  288 | Setophaga    | fusca            |            2014 |    22 |\n|  529 | Setophaga    | pensylvanica     |            2011 |    22 |\n|  719 | Catharus     | ustulatus        |            2003 |    22 |\n|    2 | Regulus      | calendula        |            2012 |    22 |\n| 1136 | Catharus     | minimus          |            1984 |    22 |\n|  954 | Parkesia     | noveboracensis   |            1988 |    22 |\n| 1130 | Hylocichla   | mustelina        |            2008 |    22 |\n|  860 | Setophaga    | coronata         |            1992 |    22 |\n| 1445 | Seiurus      | aurocapilla      |            1998 |    22 |\n| 1447 | Passerella   | iliaca           |            1999 |    22 |\n| 1909 | Passerina    | cyanea           |            2013 |    22 |\n| 1279 | Parkesia     | noveboracensis   |            2006 |    22 |\n|  997 | Spizella     | pusilla          |            1985 |    22 |\n| 1303 | Spizelloides | arborea          |            1995 |    22 |\n| 2282 | Regulus      | calendula        |            2007 |    22 |\n| 2324 | Geothlypis   | trichas          |            2005 |    22 |\n| 1602 | Oporornis    | agilis           |            2012 |    22 |\n|  167 | Regulus      | calendula        |            2015 |    22 |\n|  465 | Melospiza    | lincolnii        |            2001 |    22 |\n| 1974 | Zonotrichia  | leucophrys       |            1989 |    22 |\n| 2111 | Setophaga    | castanea         |            2011 |    21 |\n| 2260 | Catharus     | minimus          |            1990 |    21 |\n|  237 | Dumetella    | carolinensis     |            2010 |    21 |\n|  233 | Setophaga    | magnolia         |            1984 |    21 |\n|  426 | Catharus     | minimus          |            1993 |    21 |\n|  963 | Catharus     | fuscescens       |            1979 |    21 |\n| 1834 | Cardellina   | canadensis       |            2011 |    21 |\n| 1668 | Setophaga    | castanea         |            2016 |    21 |\n| 1554 | Setophaga    | coronata         |            2015 |    21 |\n|  404 | Cardellina   | canadensis       |            2014 |    21 |\n|  844 | Spizella     | pusilla          |            1994 |    21 |\n| 1812 | Setophaga    | striata          |            1996 |    21 |\n|  449 | Setophaga    | pensylvanica     |            2006 |    21 |\n|  160 | Setophaga    | palmarum         |            1994 |    21 |\n| 1718 | Passerella   | iliaca           |            2001 |    21 |\n|  334 | Mniotilta    | varia            |            2016 |    21 |\n| 2190 | Setophaga    | coronata         |            1989 |    20 |\n| 2423 | Seiurus      | aurocapilla      |            1989 |    20 |\n| 1464 | Oreothlypis  | celata           |            2015 |    20 |\n|   86 | Spizella     | pusilla          |            1983 |    20 |\n| 2212 | Passerella   | iliaca           |            1978 |    20 |\n|  710 | Oreothlypis  | peregrina        |            2003 |    20 |\n|  377 | Zonotrichia  | leucophrys       |            1987 |    20 |\n|   69 | Hylocichla   | mustelina        |            2015 |    20 |\n|  124 | Passerculus  | sandwichensis    |            1992 |    20 |\n| 1091 | Catharus     | fuscescens       |            2009 |    20 |\n|  812 | Oreothlypis  | ruficapilla      |            2004 |    20 |\n|  388 | Oporornis    | agilis           |            2016 |    20 |\n| 1424 | Setophaga    | coronata         |            2008 |    20 |\n| 1652 | Regulus      | calendula        |            2008 |    20 |\n|  792 | Geothlypis   | trichas          |            1986 |    19 |\n| 1085 | Melospiza    | lincolnii        |            1981 |    19 |\n| 2082 | Passerella   | iliaca           |            1984 |    19 |\n|   39 | Setophaga    | caerulescens     |            2015 |    19 |\n|  994 | Cardellina   | pusilla          |            2014 |    19 |\n|  213 | Geothlypis   | philadelphia     |            2011 |    19 |\n|  228 | Spizella     | pusilla          |            1989 |    19 |\n| 1008 | Catharus     | guttatus         |            1981 |    19 |\n|  278 | Vireo        | olivaceus        |            2011 |    19 |\n|  546 | Setophaga    | striata          |            1994 |    19 |\n| 1480 | Melospiza    | georgiana        |            1978 |    19 |\n| 1696 | Setophaga    | coronata         |            2006 |    19 |\n| 1242 | Dumetella    | carolinensis     |            2005 |    19 |\n| 1605 | Geothlypis   | philadelphia     |            1993 |    19 |\n| 1273 | Geothlypis   | philadelphia     |            2008 |    19 |\n|  673 | Regulus      | calendula        |            2005 |    19 |\n| 1513 | Catharus     | fuscescens       |            2013 |    19 |\n|  337 | Passerina    | cyanea           |            2015 |    19 |\n|  468 | Zonotrichia  | leucophrys       |            2000 |    19 |\n| 1663 | Catharus     | minimus          |            1983 |    19 |\n|  605 | Setophaga    | magnolia         |            1992 |    19 |\n|  477 | Dumetella    | carolinensis     |            1990 |    19 |\n| 1326 | Dumetella    | carolinensis     |            1992 |    19 |\n| 2198 | Oreothlypis  | ruficapilla      |            1994 |    19 |\n|  491 | Setophaga    | fusca            |            2015 |    19 |\n|  383 | Setophaga    | pensylvanica     |            2012 |    19 |\n| 1438 | Catharus     | fuscescens       |            1983 |    19 |\n|  294 | Dumetella    | carolinensis     |            2016 |    19 |\n| 1475 | Zonotrichia  | leucophrys       |            1999 |    18 |\n|  146 | Catharus     | ustulatus        |            1979 |    18 |\n| 1401 | Setophaga    | magnolia         |            1994 |    18 |\n|   71 | Catharus     | guttatus         |            1997 |    18 |\n|   74 | Passerculus  | sandwichensis    |            1986 |    18 |\n| 1172 | Pheucticus   | ludovicianus     |            2007 |    18 |\n|  427 | Toxostoma    | rufum            |            2014 |    18 |\n| 2147 | Setophaga    | pensylvanica     |            2015 |    18 |\n| 1618 | Zonotrichia  | leucophrys       |            2006 |    18 |\n|  674 | Passerina    | cyanea           |            2007 |    18 |\n| 1534 | Pheucticus   | ludovicianus     |            1983 |    18 |\n|  734 | Spizelloides | arborea          |            2007 |    18 |\n|  414 | Regulus      | satrapa          |            1985 |    18 |\n| 1606 | Catharus     | fuscescens       |            1993 |    18 |\n| 1385 | Geothlypis   | trichas          |            1991 |    18 |\n| 1038 | Setophaga    | magnolia         |            1979 |    18 |\n| 1890 | Hylocichla   | mustelina        |            2012 |    18 |\n| 1339 | Passerina    | cyanea           |            2008 |    18 |\n| 1140 | Setophaga    | virens           |            2012 |    18 |\n| 1741 | Catharus     | fuscescens       |            2006 |    18 |\n| 1783 | Setophaga    | coronata         |            1979 |    18 |\n|   31 | Catharus     | fuscescens       |            2008 |    18 |\n| 2224 | Passerculus  | sandwichensis    |            2000 |    18 |\n|  297 | Passerculus  | sandwichensis    |            1985 |    18 |\n|  318 | Regulus      | satrapa          |            2002 |    18 |\n|  879 | Pheucticus   | ludovicianus     |            2009 |    18 |\n|  992 | Empidonax    | traillii         |            1996 |    18 |\n|  292 | Passerina    | cyanea           |            1979 |    18 |\n|  826 | Oreothlypis  | celata           |            2010 |    18 |\n| 1002 | Catharus     | ustulatus        |            1997 |    17 |\n|  181 | Setophaga    | castanea         |            2005 |    17 |\n| 1581 | Zonotrichia  | leucophrys       |            2012 |    17 |\n| 2401 | Oreothlypis  | ruficapilla      |            1981 |    17 |\n| 1376 | Zonotrichia  | leucophrys       |            1992 |    17 |\n| 2142 | Catharus     | ustulatus        |            1991 |    17 |\n| 2106 | Zonotrichia  | leucophrys       |            1996 |    17 |\n|   28 | Regulus      | calendula        |            2006 |    17 |\n| 1842 | Oreothlypis  | ruficapilla      |            1986 |    17 |\n|  797 | Passerella   | iliaca           |            1981 |    17 |\n|  478 | Parkesia     | noveboracensis   |            2002 |    17 |\n| 1010 | Dumetella    | carolinensis     |            2006 |    17 |\n| 1456 | Parkesia     | noveboracensis   |            2005 |    17 |\n|  608 | Cardellina   | canadensis       |            2013 |    17 |\n|  771 | Setophaga    | striata          |            1983 |    17 |\n| 2165 | Setophaga    | virens           |            2013 |    17 |\n| 2299 | Dumetella    | carolinensis     |            1993 |    17 |\n|  785 | Setophaga    | palmarum         |            1982 |    17 |\n| 1633 | Spizella     | pusilla          |            1990 |    17 |\n| 1683 | Passerina    | cyanea           |            1993 |    17 |\n|  931 | Setophaga    | palmarum         |            2006 |    17 |\n| 1913 | Setophaga    | fusca            |            2012 |    16 |\n| 1266 | Certhia      | americana        |            2001 |    16 |\n|  831 | Vireo        | olivaceus        |            2014 |    16 |\n|  982 | Setophaga    | castanea         |            2007 |    16 |\n| 2042 | Piranga      | olivacea         |            2014 |    16 |\n| 2278 | Setophaga    | palmarum         |            1986 |    16 |\n| 1957 | Setophaga    | virens           |            2014 |    16 |\n|  533 | Passerina    | cyanea           |            2014 |    16 |\n|  652 | Setophaga    | ruticilla        |            1984 |    16 |\n| 1299 | Setophaga    | fusca            |            2011 |    16 |\n| 1313 | Geothlypis   | trichas          |            1979 |    16 |\n|  894 | Geothlypis   | philadelphia     |            1984 |    16 |\n| 1003 | Setophaga    | striata          |            1998 |    16 |\n| 1731 | Setophaga    | palmarum         |            2002 |    16 |\n|  174 | Mniotilta    | varia            |            2005 |    16 |\n|  243 | Setophaga    | virens           |            2007 |    16 |\n| 2136 | Spizelloides | arborea          |            1993 |    16 |\n| 2125 | Oporornis    | agilis           |            1996 |    16 |\n|  387 | Parkesia     | noveboracensis   |            1991 |    16 |\n|  246 | Setophaga    | magnolia         |            1983 |    16 |\n| 1708 | Setophaga    | ruticilla        |            2002 |    16 |\n|  204 | Zonotrichia  | leucophrys       |            1983 |    16 |\n| 1158 | Setophaga    | coronata         |            1990 |    16 |\n| 1239 | Setophaga    | magnolia         |            1995 |    16 |\n| 1810 | Catharus     | ustulatus        |            1999 |    16 |\n| 1088 | Setophaga    | palmarum         |            2001 |    16 |\n|  775 | Dumetella    | carolinensis     |            1979 |    16 |\n|  728 | Dumetella    | carolinensis     |            1995 |    16 |\n|  322 | Parkesia     | noveboracensis   |            1993 |    15 |\n|  328 | Setophaga    | ruticilla        |            1992 |    15 |\n|  463 | Certhia      | americana        |            1996 |    15 |\n|  885 | Hylocichla   | mustelina        |            1988 |    15 |\n|  392 | Passerina    | cyanea           |            1989 |    15 |\n| 1762 | Setophaga    | caerulescens     |            2006 |    15 |\n| 2047 | Toxostoma    | rufum            |            2008 |    15 |\n|  452 | Regulus      | calendula        |            1985 |    15 |\n|  971 | Geothlypis   | philadelphia     |            1994 |    15 |\n| 1119 | Spizelloides | arborea          |            2001 |    15 |\n| 2049 | Passerina    | cyanea           |            2006 |    15 |\n|  577 | Cardellina   | pusilla          |            2010 |    15 |\n| 2058 | Pheucticus   | ludovicianus     |            2015 |    15 |\n| 1352 | Geothlypis   | philadelphia     |            2007 |    15 |\n| 1357 | Setophaga    | coronata         |            1991 |    15 |\n| 1388 | Oporornis    | agilis           |            1992 |    15 |\n|  933 | Catharus     | fuscescens       |            2000 |    15 |\n|   84 | Catharus     | fuscescens       |            2002 |    15 |\n| 2009 | Geothlypis   | philadelphia     |            2012 |    15 |\n| 1739 | Pheucticus   | ludovicianus     |            1982 |    15 |\n|  816 | Certhia      | americana        |            1994 |    15 |\n|  798 | Catharus     | fuscescens       |            1995 |    15 |\n| 1259 | Geothlypis   | trichas          |            1981 |    15 |\n| 1028 | Cardellina   | canadensis       |            2009 |    15 |\n|  276 | Catharus     | minimus          |            1986 |    15 |\n|  803 | Spizella     | pusilla          |            1984 |    15 |\n|  649 | Oreothlypis  | celata           |            2009 |    15 |\n|  378 | Setophaga    | striata          |            1993 |    15 |\n| 1015 | Passerina    | cyanea           |            1984 |    15 |\n|  398 | Setophaga    | pensylvanica     |            2016 |    15 |\n| 2157 | Certhia      | americana        |            1990 |    15 |\n| 1840 | Setophaga    | caerulescens     |            2012 |    15 |\n| 1046 | Passerina    | cyanea           |            1998 |    15 |\n|  431 | Oreothlypis  | celata           |            1985 |    15 |\n| 1078 | Oreothlypis  | ruficapilla      |            1990 |    15 |\n| 2113 | Dumetella    | carolinensis     |            1994 |    15 |\n|  542 | Cardellina   | canadensis       |            2007 |    14 |\n| 1574 | Catharus     | fuscescens       |            2007 |    14 |\n|  921 | Setophaga    | tigrina          |            2006 |    14 |\n|  887 | Melospiza    | lincolnii        |            1997 |    14 |\n|  537 | Parkesia     | noveboracensis   |            1980 |    14 |\n|   34 | Catharus     | minimus          |            1981 |    14 |\n| 1572 | Troglodytes  | aedon            |            2009 |    14 |\n|  139 | Setophaga    | fusca            |            2007 |    14 |\n|  647 | Setophaga    | ruticilla        |            1983 |    14 |\n|  273 | Oreothlypis  | ruficapilla      |            1988 |    14 |\n|  381 | Setophaga    | magnolia         |            1993 |    14 |\n| 1713 | Melospiza    | lincolnii        |            1978 |    14 |\n| 1397 | Cardellina   | canadensis       |            2015 |    14 |\n|  507 | Setophaga    | castanea         |            2013 |    14 |\n| 2057 | Spizelloides | arborea          |            1983 |    14 |\n| 1727 | Certhia      | americana        |            1980 |    14 |\n|  906 | Setophaga    | castanea         |            1992 |    14 |\n| 2059 | Cardellina   | pusilla          |            2007 |    14 |\n| 1330 | Setophaga    | pensylvanica     |            2009 |    14 |\n|  909 | Spizella     | pusilla          |            1996 |    14 |\n|  241 | Passerina    | cyanea           |            1981 |    14 |\n| 1609 | Hylocichla   | mustelina        |            2002 |    14 |\n|  203 | Spizella     | pusilla          |            1987 |    14 |\n|  996 | Oporornis    | agilis           |            2015 |    14 |\n|  420 | Setophaga    | virens           |            2006 |    14 |\n| 1681 | Vireo        | olivaceus        |            2012 |    14 |\n| 1481 | Setophaga    | castanea         |            2008 |    14 |\n| 1089 | Seiurus      | aurocapilla      |            2001 |    14 |\n|   52 | Spizelloides | arborea          |            2014 |    14 |\n| 1069 | Pheucticus   | ludovicianus     |            2008 |    14 |\n| 2199 | Empidonax    | traillii         |            2015 |    14 |\n| 2237 | Setophaga    | striata          |            2005 |    14 |\n| 1458 | Oporornis    | agilis           |            1982 |    14 |\n| 1790 | Setophaga    | palmarum         |            1992 |    14 |\n|  991 | Piranga      | olivacea         |            2013 |    14 |\n|  691 | Catharus     | minimus          |            1988 |    14 |\n|  178 | Setophaga    | striata          |            1992 |    14 |\n|  594 | Hylocichla   | mustelina        |            1983 |    14 |\n| 1820 | Oreothlypis  | celata           |            2007 |    14 |\n| 2138 | Cardellina   | pusilla          |            2008 |    14 |\n|  231 | Setophaga    | striata          |            1986 |    14 |\n|  626 | Oporornis    | agilis           |            2009 |    14 |\n|  977 | Oreothlypis  | ruficapilla      |            2003 |    14 |\n| 2173 | Passerina    | cyanea           |            2010 |    14 |\n| 1206 | Cardellina   | pusilla          |            2015 |    13 |\n| 1187 | Oreothlypis  | ruficapilla      |            1993 |    13 |\n| 1147 | Oreothlypis  | peregrina        |            1981 |    13 |\n| 1926 | Setophaga    | fusca            |            2016 |    13 |\n| 2039 | Catharus     | minimus          |            1995 |    13 |\n| 1346 | Hylocichla   | mustelina        |            1984 |    13 |\n| 1435 | Geothlypis   | trichas          |            1997 |    13 |\n| 1646 | Dumetella    | carolinensis     |            1984 |    13 |\n| 2196 | Geothlypis   | philadelphia     |            2015 |    13 |\n| 1852 | Zonotrichia  | leucophrys       |            1979 |    13 |\n| 1436 | Setophaga    | pensylvanica     |            2005 |    13 |\n| 2090 | Dumetella    | carolinensis     |            1988 |    13 |\n| 1444 | Geothlypis   | trichas          |            1980 |    13 |\n|  985 | Cardellina   | canadensis       |            1984 |    13 |\n| 2256 | Parkesia     | noveboracensis   |            2007 |    13 |\n| 2135 | Hylocichla   | mustelina        |            1986 |    13 |\n| 1827 | Toxostoma    | rufum            |            2015 |    13 |\n| 2077 | Setophaga    | palmarum         |            2010 |    13 |\n|  434 | Setophaga    | petechia         |            1996 |    13 |\n|  639 | Catharus     | minimus          |            1994 |    13 |\n| 2276 | Geothlypis   | trichas          |            1999 |    13 |\n|  325 | Setophaga    | castanea         |            2014 |    13 |\n|  820 | Setophaga    | caerulescens     |            2011 |    13 |\n|  830 | Ammodramus   | savannarum       |            1990 |    13 |\n|  511 | Setophaga    | ruticilla        |            1993 |    13 |\n|  916 | Catharus     | ustulatus        |            2002 |    13 |\n|  706 | Passerculus  | sandwichensis    |            2008 |    13 |\n|  743 | Setophaga    | palmarum         |            1993 |    13 |\n|  745 | Pheucticus   | ludovicianus     |            2016 |    13 |\n|   13 | Setophaga    | striata          |            1985 |    13 |\n|  919 | Setophaga    | coronata         |            2002 |    13 |\n|  351 | Cardellina   | pusilla          |            2013 |    13 |\n| 1505 | Oreothlypis  | peregrina        |            2001 |    12 |\n| 1607 | Setophaga    | magnolia         |            2002 |    12 |\n| 1520 | Certhia      | americana        |            1987 |    12 |\n| 1531 | Regulus      | satrapa          |            1999 |    12 |\n| 2254 | Setophaga    | caerulescens     |            2016 |    12 |\n| 2380 | Icterus      | galbula          |            2011 |    12 |\n|  320 | Zonotrichia  | leucophrys       |            1993 |    12 |\n| 1693 | Catharus     | fuscescens       |            2012 |    12 |\n| 1737 | Geothlypis   | philadelphia     |            1983 |    12 |\n| 1744 | Oporornis    | agilis           |            2005 |    12 |\n| 1785 | Setophaga    | coronata         |            1987 |    12 |\n| 2119 | Oreothlypis  | celata           |            2012 |    12 |\n| 2253 | Dumetella    | carolinensis     |            1987 |    12 |\n|  517 | Spizelloides | arborea          |            1999 |    12 |\n| 1467 | Oporornis    | agilis           |            2011 |    12 |\n|  612 | Setophaga    | pensylvanica     |            2007 |    12 |\n|  753 | Geothlypis   | philadelphia     |            1995 |    12 |\n|  686 | Troglodytes  | hiemalis         |            2006 |    12 |\n| 1262 | Sitta        | canadensis       |            2013 |    12 |\n| 1281 | Geothlypis   | trichas          |            1998 |    12 |\n| 1288 | Oreothlypis  | celata           |            2014 |    12 |\n|  625 | Setophaga    | coronata         |            2010 |    12 |\n|  578 | Mniotilta    | varia            |            1996 |    12 |\n|  482 | Catharus     | minimus          |            1987 |    12 |\n| 2293 | Certhia      | americana        |            1999 |    12 |\n|  526 | Troglodytes  | hiemalis         |            2005 |    12 |\n| 2251 | Oreothlypis  | celata           |            2011 |    12 |\n| 1824 | Passerina    | cyanea           |            1986 |    12 |\n| 1441 | Catharus     | fuscescens       |            1998 |    12 |\n|  497 | Certhia      | americana        |            1986 |    12 |\n|  193 | Setophaga    | caerulescens     |            2008 |    12 |\n| 1102 | Catharus     | ustulatus        |            2001 |    12 |\n| 1971 | Mniotilta    | varia            |            2002 |    12 |\n| 1917 | Geothlypis   | philadelphia     |            1982 |    12 |\n| 2022 | Sitta        | canadensis       |            2009 |    12 |\n|   44 | Oporornis    | agilis           |            1983 |    12 |\n|   35 | Hylocichla   | mustelina        |            1994 |    12 |\n| 2018 | Geothlypis   | philadelphia     |            2016 |    12 |\n| 1901 | Setophaga    | ruticilla        |            1994 |    12 |\n| 2091 | Parkesia     | noveboracensis   |            2000 |    12 |\n|  118 | Hylocichla   | mustelina        |            2005 |    12 |\n| 2036 | Setophaga    | magnolia         |            1980 |    12 |\n| 2115 | Parkesia     | noveboracensis   |            1998 |    12 |\n|  561 | Setophaga    | virens           |            2015 |    11 |\n| 1563 | Empidonax    | traillii         |            2012 |    11 |\n|  184 | Dumetella    | carolinensis     |            2004 |    11 |\n|   85 | Setophaga    | magnolia         |            1991 |    11 |\n| 1005 | Setophaga    | palmarum         |            1983 |    11 |\n|  522 | Regulus      | calendula        |            2016 |    11 |\n| 2107 | Certhia      | americana        |            1984 |    11 |\n| 1975 | Cardellina   | canadensis       |            2012 |    11 |\n|  818 | Pheucticus   | ludovicianus     |            1990 |    11 |\n| 1538 | Spizelloides | arborea          |            2005 |    11 |\n|  471 | Setophaga    | magnolia         |            1982 |    11 |\n|  758 | Setophaga    | tigrina          |            2007 |    11 |\n|  436 | Setophaga    | fusca            |            2009 |    11 |\n|  490 | Setophaga    | tigrina          |            2009 |    11 |\n| 1886 | Setophaga    | magnolia         |            1988 |    11 |\n| 1351 | Setophaga    | fusca            |            1996 |    11 |\n|  454 | Catharus     | fuscescens       |            1987 |    11 |\n|  902 | Setophaga    | virens           |            2016 |    11 |\n|  576 | Troglodytes  | aedon            |            2008 |    11 |\n| 1955 | Troglodytes  | hiemalis         |            1985 |    11 |\n|  224 | Dumetella    | carolinensis     |            1982 |    11 |\n| 2302 | Oreothlypis  | celata           |            2013 |    11 |\n|  981 | Passerculus  | sandwichensis    |            1994 |    11 |\n|  171 | Oreothlypis  | ruficapilla      |            1980 |    11 |\n| 1095 | Catharus     | minimus          |            1980 |    11 |\n|  142 | Oreothlypis  | peregrina        |            1999 |    11 |\n| 2051 | Setophaga    | ruticilla        |            1985 |    11 |\n|  700 | Setophaga    | ruticilla        |            2003 |    11 |\n|  699 | Setophaga    | virens           |            2008 |    11 |\n|  232 | Certhia      | americana        |            2000 |    11 |\n|   29 | Setophaga    | tigrina          |            2013 |    11 |\n| 1786 | Geothlypis   | trichas          |            1989 |    11 |\n|  208 | Oporornis    | agilis           |            2013 |    11 |\n| 1261 | Toxostoma    | rufum            |            2012 |    11 |\n|  864 | Setophaga    | palmarum         |            1989 |    11 |\n| 1264 | Passerina    | cyanea           |            2004 |    11 |\n|  636 | Certhia      | americana        |            1995 |    11 |\n| 2066 | Geothlypis   | philadelphia     |            1990 |    10 |\n|   75 | Empidonax    | traillii         |            2007 |    10 |\n|  817 | Parkesia     | noveboracensis   |            1987 |    10 |\n| 2234 | Toxostoma    | rufum            |            2009 |    10 |\n|   17 | Dumetella    | carolinensis     |            1986 |    10 |\n| 1362 | Empidonax    | flaviventris     |            2015 |    10 |\n| 1278 | Certhia      | americana        |            1998 |    10 |\n| 1149 | Cardellina   | pusilla          |            2009 |    10 |\n|  810 | Setophaga    | striata          |            2004 |    10 |\n|  563 | Contopus     | virens           |            1996 |    10 |\n| 1354 | Pheucticus   | ludovicianus     |            2006 |    10 |\n| 2244 | Certhia      | americana        |            1993 |    10 |\n| 1190 | Setophaga    | castanea         |            2006 |    10 |\n| 1199 | Passerina    | cyanea           |            1991 |    10 |\n| 2327 | Geothlypis   | philadelphia     |            2004 |    10 |\n| 1332 | Regulus      | satrapa          |            1994 |    10 |\n| 1065 | Setophaga    | fusca            |            2010 |    10 |\n|  679 | Pheucticus   | ludovicianus     |            1985 |    10 |\n|  653 | Passerella   | iliaca           |            1997 |    10 |\n| 1289 | Setophaga    | castanea         |            2009 |    10 |\n|  190 | Catharus     | minimus          |            2005 |    10 |\n|  333 | Geothlypis   | philadelphia     |            1980 |    10 |\n|  411 | Setophaga    | striata          |            1987 |    10 |\n| 2388 | Setophaga    | caerulescens     |            2009 |    10 |\n|  884 | Catharus     | minimus          |            1979 |    10 |\n| 1846 | Piranga      | olivacea         |            2015 |    10 |\n|  984 | Setophaga    | caerulescens     |            2010 |    10 |\n|  280 | Spizelloides | arborea          |            2003 |    10 |\n|  290 | Setophaga    | coronata         |            2005 |    10 |\n|  165 | Catharus     | fuscescens       |            2004 |    10 |\n|  299 | Passerina    | cyanea           |            1994 |    10 |\n| 1692 | Spizelloides | arborea          |            2002 |    10 |\n|  867 | Troglodytes  | hiemalis         |            2007 |    10 |\n| 1628 | Setophaga    | ruticilla        |            1989 |    10 |\n| 2151 | Hylocichla   | mustelina        |            1981 |    10 |\n| 2424 | Dumetella    | carolinensis     |            1983 |    10 |\n|  106 | Oporornis    | agilis           |            2007 |    10 |\n| 1949 | Setophaga    | striata          |            1995 |    10 |\n| 2349 | Setophaga    | coronata         |            2003 |    10 |\n| 1946 | Icterus      | galbula          |            2015 |    10 |\n|  120 | Setophaga    | coronata         |            1983 |    10 |\n| 1488 | Oporornis    | agilis           |            1985 |    10 |\n| 1995 | Oporornis    | agilis           |            1995 |     9 |\n| 1698 | Setophaga    | tigrina          |            1994 |     9 |\n| 1705 | Spizella     | pusilla          |            1992 |     9 |\n| 1204 | Toxostoma    | rufum            |            2010 |     9 |\n| 1202 | Setophaga    | fusca            |            2006 |     9 |\n|  302 | Certhia      | americana        |            1981 |     9 |\n| 1192 | Oporornis    | agilis           |            1993 |     9 |\n| 1930 | Setophaga    | palmarum         |            2003 |     9 |\n|  486 | Passerina    | cyanea           |            2000 |     9 |\n| 1395 | Toxostoma    | rufum            |            2011 |     9 |\n|  666 | Setophaga    | palmarum         |            1988 |     9 |\n| 1175 | Dumetella    | carolinensis     |            1999 |     9 |\n| 1167 | Zonotrichia  | leucophrys       |            1991 |     9 |\n| 1449 | Troglodytes  | hiemalis         |            1980 |     9 |\n|  251 | Oreothlypis  | celata           |            1984 |     9 |\n|  226 | Setophaga    | magnolia         |            2003 |     9 |\n|   14 | Certhia      | americana        |            1992 |     9 |\n|  752 | Hylocichla   | mustelina        |            1987 |     9 |\n|  500 | Hylocichla   | mustelina        |            1990 |     9 |\n|  675 | Setophaga    | tigrina          |            2008 |     9 |\n|  156 | Pheucticus   | ludovicianus     |            1980 |     9 |\n| 2318 | Hylocichla   | mustelina        |            1985 |     9 |\n| 1506 | Troglodytes  | hiemalis         |            2004 |     9 |\n|  442 | Oreothlypis  | ruficapilla      |            1987 |     9 |\n| 2360 | Setophaga    | pensylvanica     |            2008 |     9 |\n| 2405 | Oporornis    | agilis           |            2014 |     9 |\n| 1536 | Parkesia     | noveboracensis   |            1981 |     9 |\n| 1331 | Setophaga    | castanea         |            2015 |     9 |\n| 1321 | Certhia      | americana        |            1988 |     9 |\n|  606 | Troglodytes  | hiemalis         |            1982 |     9 |\n|   50 | Spizella     | pusilla          |            1988 |     9 |\n|  623 | Passerculus  | sandwichensis    |            1982 |     9 |\n| 1340 | Oporornis    | agilis           |            1986 |     9 |\n| 1614 | Pheucticus   | ludovicianus     |            1988 |     9 |\n| 2366 | Setophaga    | americana        |            2011 |     9 |\n|  627 | Setophaga    | tigrina          |            2014 |     9 |\n| 1407 | Piranga      | olivacea         |            2011 |     9 |\n| 1881 | Setophaga    | striata          |            1990 |     9 |\n| 1671 | Setophaga    | tigrina          |            1984 |     9 |\n| 1688 | Oporornis    | agilis           |            1984 |     9 |\n|  475 | Setophaga    | castanea         |            1991 |     9 |\n| 1252 | Setophaga    | pensylvanica     |            2004 |     9 |\n| 1418 | Setophaga    | ruticilla        |            1988 |     9 |\n| 1501 | Setophaga    | palmarum         |            1990 |     9 |\n|  961 | Troglodytes  | hiemalis         |            1988 |     9 |\n| 1053 | Ammodramus   | savannarum       |            2011 |     9 |\n|  815 | Cardellina   | canadensis       |            1985 |     9 |\n|  799 | Setophaga    | magnolia         |            2000 |     9 |\n|  853 | Setophaga    | ruticilla        |            2004 |     9 |\n|  878 | Sitta        | canadensis       |            2005 |     9 |\n|  786 | Passerculus  | sandwichensis    |            1995 |     9 |\n| 1035 | Setophaga    | striata          |            1984 |     9 |\n| 2297 | Setophaga    | ruticilla        |            1979 |     9 |\n|  403 | Passerculus  | sandwichensis    |            1983 |     8 |\n| 1579 | Setophaga    | striata          |            2000 |     8 |\n|  819 | Catharus     | minimus          |            2002 |     8 |\n|  877 | Oreothlypis  | celata           |            1989 |     8 |\n| 1773 | Mniotilta    | varia            |            2003 |     8 |\n|  520 | Cardellina   | pusilla          |            1979 |     8 |\n|  593 | Empidonax    | traillii         |            2009 |     8 |\n| 1979 | Parkesia     | noveboracensis   |            1989 |     8 |\n| 1679 | Mniotilta    | varia            |            1979 |     8 |\n| 1604 | Setophaga    | pinus            |            2012 |     8 |\n|  229 | Regulus      | satrapa          |            1980 |     8 |\n| 2166 | Dumetella    | carolinensis     |            2000 |     8 |\n| 1941 | Cardellina   | pusilla          |            2011 |     8 |\n|  580 | Geothlypis   | philadelphia     |            2003 |     8 |\n| 2255 | Setophaga    | ruticilla        |            1986 |     8 |\n| 1217 | Setophaga    | pensylvanica     |            2002 |     8 |\n|  948 | Oreothlypis  | peregrina        |            1997 |     8 |\n| 1338 | Melospiza    | melodia          |            1979 |     8 |\n|  525 | Dumetella    | carolinensis     |            1996 |     8 |\n| 1976 | Geothlypis   | philadelphia     |            2002 |     8 |\n| 2098 | Setophaga    | magnolia         |            1987 |     8 |\n| 2307 | Vireo        | olivaceus        |            2009 |     8 |\n|  367 | Empidonax    | traillii         |            1985 |     8 |\n| 1455 | Dumetella    | carolinensis     |            1985 |     8 |\n| 2243 | Setophaga    | tigrina          |            2010 |     8 |\n| 2372 | Catharus     | fuscescens       |            2005 |     8 |\n| 2393 | Catharus     | minimus          |            1997 |     8 |\n|  510 | Cistothorus  | palustris        |            2012 |     8 |\n|  513 | Regulus      | calendula        |            2002 |     8 |\n| 1841 | Setophaga    | magnolia         |            1981 |     8 |\n|  789 | Troglodytes  | hiemalis         |            1995 |     8 |\n| 1433 | Spizella     | pusilla          |            2010 |     8 |\n| 1851 | Spizella     | pusilla          |            1991 |     8 |\n|  638 | Passerculus  | sandwichensis    |            2002 |     8 |\n|  199 | Oreothlypis  | ruficapilla      |            1998 |     8 |\n| 1855 | Vireo        | olivaceus        |            2013 |     8 |\n| 1639 | Oporornis    | agilis           |            2010 |     8 |\n|  339 | Empidonax    | minimus          |            2008 |     8 |\n| 1803 | Regulus      | satrapa          |            1982 |     8 |\n| 1869 | Passerculus  | sandwichensis    |            1991 |     8 |\n|  656 | Piranga      | olivacea         |            1996 |     8 |\n|  150 | Catharus     | fuscescens       |            2016 |     8 |\n| 1244 | Cardellina   | canadensis       |            2008 |     8 |\n| 2314 | Catharus     | fuscescens       |            2003 |     8 |\n| 1794 | Setophaga    | striata          |            1982 |     8 |\n|  221 | Hylocichla   | mustelina        |            2016 |     8 |\n| 1626 | Setophaga    | caerulescens     |            2013 |     8 |\n|  613 | Setophaga    | castanea         |            1984 |     8 |\n| 1225 | Oreothlypis  | ruficapilla      |            1999 |     8 |\n| 1685 | Oreothlypis  | celata           |            1995 |     8 |\n|  100 | Setophaga    | ruticilla        |            2000 |     8 |\n| 1514 | Setophaga    | striata          |            1979 |     8 |\n|  835 | Passerculus  | sandwichensis    |            2001 |     8 |\n|  422 | Parkesia     | noveboracensis   |            2004 |     8 |\n| 2362 | Certhia      | americana        |            1983 |     8 |\n| 1725 | Contopus     | virens           |            2015 |     8 |\n| 2046 | Catharus     | fuscescens       |            1997 |     8 |\n|   49 | Oporornis    | agilis           |            1988 |     8 |\n| 1552 | Oreothlypis  | celata           |            2016 |     8 |\n|  446 | Empidonax    | traillii         |            2016 |     8 |\n| 1369 | Regulus      | calendula        |            1994 |     8 |\n| 1515 | Hylocichla   | mustelina        |            1991 |     8 |\n| 1097 | Seiurus      | aurocapilla      |            1978 |     8 |\n| 2335 | Vermivora    | chrysoptera      |            2015 |     8 |\n| 1051 | Vireo        | olivaceus        |            2015 |     8 |\n| 2072 | Passerculus  | sandwichensis    |            1990 |     8 |\n|   47 | Empidonax    | traillii         |            1993 |     8 |\n| 1106 | Parkesia     | noveboracensis   |            1997 |     8 |\n|  908 | Vireo        | olivaceus        |            2008 |     8 |\n| 2092 | Passerina    | cyanea           |            2016 |     8 |\n| 2247 | Zonotrichia  | leucophrys       |            2003 |     8 |\n|  274 | Parkesia     | noveboracensis   |            2003 |     8 |\n|  287 | Setophaga    | striata          |            1988 |     8 |\n| 1664 | Hylocichla   | mustelina        |            1992 |     7 |\n| 1883 | Geothlypis   | philadelphia     |            1991 |     7 |\n| 2181 | Empidonax    | minimus          |            2015 |     7 |\n|  359 | Geothlypis   | trichas          |            2001 |     7 |\n|  216 | Passerculus  | sandwichensis    |            2006 |     7 |\n|  492 | Geothlypis   | philadelphia     |            1988 |     7 |\n| 1662 | Setophaga    | striata          |            1989 |     7 |\n|   42 | Oreothlypis  | ruficapilla      |            1989 |     7 |\n|  424 | Troglodytes  | aedon            |            2015 |     7 |\n| 1229 | Spizella     | pusilla          |            2009 |     7 |\n| 2418 | Passerculus  | sandwichensis    |            2007 |     7 |\n| 1301 | Cardellina   | pusilla          |            1984 |     7 |\n| 1623 | Oreothlypis  | celata           |            2006 |     7 |\n| 2359 | Empidonax    | traillii         |            2014 |     7 |\n| 1296 | Passerina    | cyanea           |            2002 |     7 |\n| 2263 | Passerina    | cyanea           |            2005 |     7 |\n| 2206 | Vireo        | olivaceus        |            1996 |     7 |\n|  347 | Geothlypis   | philadelphia     |            1999 |     7 |\n| 2177 | Oporornis    | agilis           |            1994 |     7 |\n|  550 | Setophaga    | castanea         |            1982 |     7 |\n| 1518 | Setophaga    | tigrina          |            1995 |     7 |\n|  895 | Oreothlypis  | ruficapilla      |            1991 |     7 |\n|  836 | Cardellina   | pusilla          |            1996 |     7 |\n| 2145 | Geothlypis   | philadelphia     |            2005 |     7 |\n|   20 | Catharus     | fuscescens       |            1980 |     7 |\n| 2121 | Setophaga    | ruticilla        |            1995 |     7 |\n| 1118 | Geothlypis   | philadelphia     |            1987 |     7 |\n| 1254 | Catharus     | minimus          |            2004 |     7 |\n| 1253 | Regulus      | satrapa          |            1991 |     7 |\n|  749 | Setophaga    | striata          |            2002 |     7 |\n|  872 | Setophaga    | palmarum         |            2000 |     7 |\n| 2370 | Pheucticus   | ludovicianus     |            1981 |     7 |\n| 1348 | Passerculus  | sandwichensis    |            2011 |     7 |\n| 1122 | Certhia      | americana        |            1989 |     7 |\n| 1635 | Ammodramus   | savannarum       |            1988 |     7 |\n| 1904 | Spizelloides | arborea          |            2013 |     7 |\n| 1070 | Cistothorus  | platensis        |            2012 |     7 |\n| 1525 | Geothlypis   | philadelphia     |            2006 |     7 |\n| 2269 | Oporornis    | agilis           |            1989 |     7 |\n| 1196 | Empidonax    | minimus          |            2014 |     7 |\n|  380 | Setophaga    | coronata         |            1986 |     7 |\n|  104 | Geothlypis   | philadelphia     |            1981 |     7 |\n|  192 | Troglodytes  | hiemalis         |            1992 |     7 |\n|   61 | Mniotilta    | varia            |            1986 |     7 |\n| 2374 | Toxostoma    | rufum            |            2016 |     7 |\n|  473 | Setophaga    | ruticilla        |            1982 |     7 |\n| 1479 | Setophaga    | ruticilla        |            1981 |     7 |\n|   95 | Toxostoma    | rufum            |            2006 |     7 |\n| 2008 | Dumetella    | carolinensis     |            2001 |     7 |\n| 1749 | Setophaga    | tigrina          |            2004 |     7 |\n| 1746 | Oreothlypis  | ruficapilla      |            1978 |     7 |\n|  730 | Regulus      | satrapa          |            1993 |     7 |\n|  571 | Setophaga    | tigrina          |            2016 |     7 |\n|  725 | Cardellina   | canadensis       |            2006 |     7 |\n| 2250 | Spizella     | pusilla          |            2008 |     7 |\n| 2330 | Regulus      | satrapa          |            1995 |     7 |\n| 1568 | Setophaga    | striata          |            1981 |     7 |\n|   56 | Vireo        | olivaceus        |            2010 |     7 |\n|  695 | Spizella     | pusilla          |            1993 |     7 |\n|  244 | Setophaga    | caerulescens     |            2014 |     7 |\n| 1041 | Catharus     | minimus          |            2003 |     7 |\n|  737 | Setophaga    | castanea         |            1993 |     7 |\n|  602 | Troglodytes  | aedon            |            2014 |     7 |\n| 1674 | Oreothlypis  | celata           |            2008 |     7 |\n| 2099 | Catharus     | fuscescens       |            1991 |     7 |\n| 1728 | Troglodytes  | hiemalis         |            1984 |     7 |\n| 1389 | Empidonax    | minimus          |            2009 |     7 |\n|  871 | Oporornis    | agilis           |            1990 |     7 |\n| 2416 | Setophaga    | palmarum         |            1997 |     7 |\n| 1778 | Geothlypis   | philadelphia     |            1992 |     7 |\n| 1284 | Empidonax    | minimus          |            1979 |     6 |\n|  570 | Empidonax    | minimus          |            2011 |     6 |\n|  560 | Empidonax    | flaviventris     |            2011 |     6 |\n|  305 | Setophaga    | palmarum         |            2005 |     6 |\n|  869 | Passerina    | cyanea           |            1999 |     6 |\n| 1409 | Catharus     | minimus          |            1998 |     6 |\n| 1710 | Spizella     | passerina        |            1996 |     6 |\n| 1813 | Setophaga    | virens           |            2005 |     6 |\n| 1320 | Cardellina   | canadensis       |            1995 |     6 |\n| 2201 | Regulus      | calendula        |            1992 |     6 |\n|  595 | Regulus      | calendula        |            1990 |     6 |\n| 1291 | Setophaga    | caerulescens     |            1996 |     6 |\n|  553 | Regulus      | satrapa          |            1998 |     6 |\n|  618 | Setophaga    | virens           |            1996 |     6 |\n| 1699 | Setophaga    | palmarum         |            1991 |     6 |\n|  252 | Toxostoma    | rufum            |            2013 |     6 |\n| 2179 | Setophaga    | pinus            |            2015 |     6 |\n| 1712 | Setophaga    | magnolia         |            1989 |     6 |\n|  876 | Mniotilta    | varia            |            1983 |     6 |\n|  987 | Empidonax    | flaviventris     |            1996 |     6 |\n| 2375 | Pipilo       | erythrophthalmus |            2011 |     6 |\n|  617 | Setophaga    | palmarum         |            1998 |     6 |\n| 1761 | Setophaga    | castanea         |            1994 |     6 |\n| 2246 | Regulus      | satrapa          |            1988 |     6 |\n|  433 | Troglodytes  | hiemalis         |            1981 |     6 |\n| 1427 | Setophaga    | tigrina          |            2012 |     6 |\n| 1562 | Setophaga    | palmarum         |            1978 |     6 |\n| 1565 | Spizella     | pusilla          |            2001 |     6 |\n| 2152 | Spizella     | pusilla          |            1981 |     6 |\n|   76 | Spizella     | pusilla          |            1998 |     6 |\n|  400 | Pheucticus   | ludovicianus     |            2003 |     6 |\n|  395 | Parkesia     | noveboracensis   |            1979 |     6 |\n|  460 | Setophaga    | magnolia         |            1999 |     6 |\n| 1585 | Cardellina   | pusilla          |            1992 |     6 |\n|  386 | Dumetella    | carolinensis     |            2003 |     6 |\n| 1593 | Troglodytes  | hiemalis         |            1993 |     6 |\n| 1950 | Parkesia     | noveboracensis   |            1999 |     6 |\n|  693 | Oporornis    | agilis           |            1991 |     6 |\n|  105 | Mniotilta    | varia            |            1992 |     6 |\n|  375 | Regulus      | satrapa          |            2004 |     6 |\n| 1936 | Cistothorus  | palustris        |            2009 |     6 |\n|  790 | Pheucticus   | ludovicianus     |            1979 |     6 |\n| 1472 | Certhia      | americana        |            1997 |     6 |\n| 1469 | Setophaga    | fusca            |            2008 |     6 |\n| 1165 | Regulus      | calendula        |            1995 |     6 |\n| 1557 | Setophaga    | coronata         |            1978 |     6 |\n| 1923 | Pheucticus   | ludovicianus     |            1995 |     6 |\n|   66 | Passerculus  | sandwichensis    |            2013 |     6 |\n|    7 | Setophaga    | magnolia         |            2004 |     6 |\n|  928 | Setophaga    | coronata         |            1981 |     6 |\n|   19 | Setophaga    | palmarum         |            1987 |     6 |\n|   24 | Setophaga    | petechia         |            2011 |     6 |\n| 1511 | Regulus      | calendula        |            2003 |     6 |\n| 1128 | Regulus      | satrapa          |            2000 |     6 |\n| 1509 | Setophaga    | pensylvanica     |            2010 |     6 |\n| 1133 | Passerculus  | sandwichensis    |            1987 |     6 |\n| 2025 | Setophaga    | magnolia         |            1997 |     6 |\n| 1503 | Passerculus  | sandwichensis    |            2010 |     6 |\n|  912 | Oreothlypis  | peregrina        |            1978 |     6 |\n| 2010 | Setophaga    | coronata         |            1988 |     6 |\n|   64 | Geothlypis   | philadelphia     |            1986 |     6 |\n|  723 | Spizella     | pusilla          |            1980 |     6 |\n|  412 | Geothlypis   | philadelphia     |            2010 |     6 |\n| 1992 | Hylocichla   | mustelina        |            1982 |     6 |\n| 2093 | Cistothorus  | palustris        |            2014 |     6 |\n| 1924 | Setophaga    | coronata         |            2007 |     6 |\n| 1201 | Piranga      | olivacea         |            2012 |     6 |\n| 1380 | Dumetella    | carolinensis     |            1998 |     6 |\n|  897 | Icterus      | galbula          |            2014 |     6 |\n|  502 | Passerculus  | sandwichensis    |            2009 |     6 |\n| 1854 | Spizella     | passerina        |            2014 |     6 |\n| 2110 | Setophaga    | pinus            |            2016 |     6 |\n|  358 | Mniotilta    | varia            |            2004 |     6 |\n| 1631 | Oporornis    | agilis           |            1981 |     6 |\n|  959 | Geothlypis   | philadelphia     |            1979 |     6 |\n| 1080 | Empidonax    | traillii         |            1994 |     6 |\n|  360 | Geothlypis   | philadelphia     |            2000 |     6 |\n| 1032 | Sitta        | canadensis       |            2014 |     6 |\n| 1234 | Cistothorus  | palustris        |            1990 |     6 |\n| 1437 | Setophaga    | palmarum         |            1984 |     6 |\n|  127 | Certhia      | americana        |            1982 |     6 |\n|  133 | Oreothlypis  | celata           |            2003 |     6 |\n|  350 | Pheucticus   | ludovicianus     |            1993 |     6 |\n|  635 | Pheucticus   | ludovicianus     |            1991 |     6 |\n| 1276 | Pheucticus   | ludovicianus     |            1986 |     6 |\n| 1612 | Setophaga    | tigrina          |            2015 |     6 |\n| 1919 | Setophaga    | tigrina          |            1997 |     6 |\n| 1463 | Setophaga    | pensylvanica     |            1984 |     6 |\n| 2369 | Troglodytes  | hiemalis         |            1989 |     6 |\n|  680 | Dumetella    | carolinensis     |            1989 |     6 |\n| 1642 | Passerculus  | sandwichensis    |            2003 |     5 |\n|  516 | Ammodramus   | savannarum       |            1995 |     5 |\n| 1528 | Setophaga    | virens           |            2010 |     5 |\n| 1011 | Setophaga    | coronata         |            1999 |     5 |\n|  345 | Ammodramus   | savannarum       |            1992 |     5 |\n|  532 | Catharus     | fuscescens       |            1989 |     5 |\n| 2358 | Passerculus  | sandwichensis    |            1993 |     5 |\n| 2339 | Troglodytes  | aedon            |            2005 |     5 |\n|  509 | Empidonax    | flaviventris     |            2013 |     5 |\n| 1539 | Oreothlypis  | celata           |            1996 |     5 |\n| 1651 | Setophaga    | pensylvanica     |            1985 |     5 |\n| 2143 | Cardellina   | pusilla          |            1983 |     5 |\n| 1431 | Empidonax    | traillii         |            2011 |     5 |\n|  413 | Oreothlypis  | ruficapilla      |            1997 |     5 |\n| 1465 | Setophaga    | virens           |            1988 |     5 |\n| 1391 | Setophaga    | striata          |            1980 |     5 |\n| 1499 | Dumetella    | carolinensis     |            1991 |     5 |\n|  371 | Setophaga    | castanea         |            1983 |     5 |\n| 1669 | Catharus     | minimus          |            2000 |     5 |\n| 1608 | Regulus      | satrapa          |            1983 |     5 |\n| 1461 | Troglodytes  | hiemalis         |            2002 |     5 |\n| 2174 | Piranga      | olivacea         |            2007 |     5 |\n|  366 | Piranga      | olivacea         |            2010 |     5 |\n|  827 | Setophaga    | virens           |            1985 |     5 |\n| 2373 | Cistothorus  | palustris        |            1996 |     5 |\n|  757 | Oporornis    | agilis           |            2002 |     5 |\n|  361 | Passerculus  | sandwichensis    |            1999 |     5 |\n| 1412 | Setophaga    | pinus            |            2011 |     5 |\n| 1414 | Oreothlypis  | celata           |            2005 |     5 |\n|  304 | Toxostoma    | rufum            |            2007 |     5 |\n|  370 | Ammodramus   | savannarum       |            1986 |     5 |\n| 1394 | Cistothorus  | palustris        |            1993 |     5 |\n| 1440 | Regulus      | calendula        |            1980 |     5 |\n|  312 | Setophaga    | magnolia         |            1990 |     5 |\n|  356 | Hylocichla   | mustelina        |            2004 |     5 |\n|  384 | Setophaga    | castanea         |            2004 |     5 |\n| 1703 | Passerculus  | sandwichensis    |            1984 |     5 |\n|  791 | Setophaga    | pensylvanica     |            1993 |     5 |\n|   97 | Empidonax    | minimus          |            1996 |     5 |\n|  694 | Contopus     | virens           |            2014 |     5 |\n| 1210 | Toxostoma    | rufum            |            1981 |     5 |\n| 2311 | Oporornis    | agilis           |            1987 |     5 |\n|  683 | Cardellina   | canadensis       |            1992 |     5 |\n| 1215 | Setophaga    | coronata         |            1984 |     5 |\n| 1918 | Oporornis    | agilis           |            2004 |     5 |\n| 1911 | Setophaga    | americana        |            2015 |     5 |\n| 1905 | Empidonax    | minimus          |            1993 |     5 |\n|  122 | Setophaga    | caerulescens     |            2002 |     5 |\n| 1711 | Vireo        | olivaceus        |            2006 |     5 |\n| 1232 | Spizella     | passerina        |            2011 |     5 |\n|  135 | Setophaga    | castanea         |            1996 |     5 |\n| 1079 | Passerculus  | sandwichensis    |            1989 |     5 |\n|  658 | Cardellina   | pusilla          |            1999 |     5 |\n| 1864 | Regulus      | calendula        |            1984 |     5 |\n|  157 | Cardellina   | pusilla          |            2016 |     5 |\n|  641 | Regulus      | calendula        |            1982 |     5 |\n| 2400 | Troglodytes  | aedon            |            2011 |     5 |\n|  698 | Vireo        | olivaceus        |            2007 |     5 |\n| 1184 | Setophaga    | striata          |            1999 |     5 |\n| 1090 | Sitta        | canadensis       |            2004 |     5 |\n| 2298 | Setophaga    | castanea         |            2010 |     5 |\n| 2074 | Catharus     | minimus          |            1989 |     5 |\n| 2080 | Sitta        | canadensis       |            2015 |     5 |\n| 2272 | Pheucticus   | ludovicianus     |            1987 |     5 |\n|  763 | Hylocichla   | mustelina        |            2000 |     5 |\n|  747 | Mniotilta    | varia            |            1995 |     5 |\n| 1126 | Mniotilta    | varia            |            2000 |     5 |\n| 2031 | Regulus      | satrapa          |            1989 |     5 |\n| 2024 | Setophaga    | striata          |            1997 |     5 |\n|  720 | Troglodytes  | aedon            |            2007 |     5 |\n|   89 | Icterus      | galbula          |            2012 |     5 |\n|   68 | Catharus     | ustulatus        |            1981 |     5 |\n| 2412 | Hylocichla   | mustelina        |            1996 |     5 |\n| 1978 | Setophaga    | castanea         |            2002 |     5 |\n|  713 | Regulus      | calendula        |            1999 |     5 |\n| 1977 | Pheucticus   | ludovicianus     |            2005 |     5 |\n| 1092 | Setophaga    | magnolia         |            1986 |     5 |\n|  945 | Setophaga    | striata          |            2003 |     5 |\n|   82 | Setophaga    | virens           |            1983 |     5 |\n| 1269 | Pipilo       | erythrophthalmus |            1990 |     5 |\n|  129 | Setophaga    | palmarum         |            2004 |     5 |\n| 1314 | Cistothorus  | palustris        |            2010 |     5 |\n| 2294 | Piranga      | olivacea         |            1983 |     5 |\n| 1312 | Regulus      | calendula        |            2000 |     5 |\n| 1305 | Pheucticus   | ludovicianus     |            1996 |     5 |\n| 1784 | Hylocichla   | mustelina        |            2001 |     5 |\n| 1782 | Setophaga    | palmarum         |            1979 |     5 |\n|  621 | Setophaga    | ruticilla        |            1990 |     5 |\n|  271 | Geothlypis   | philadelphia     |            1989 |     5 |\n|  263 | Mniotilta    | varia            |            1985 |     5 |\n| 1730 | Setophaga    | americana        |            2012 |     5 |\n|  891 | Setophaga    | tigrina          |            1996 |     5 |\n| 2391 | Spizella     | pusilla          |            2007 |     5 |\n|  889 | Mniotilta    | varia            |            1988 |     5 |\n|  220 | Regulus      | calendula        |            1988 |     5 |\n|  291 | Ammodramus   | nelsoni          |            1986 |     5 |\n| 1286 | Setophaga    | ruticilla        |            1980 |     5 |\n| 1365 | Spizella     | pusilla          |            2000 |     5 |\n|  588 | Ammodramus   | nelsoni          |            2000 |     5 |\n| 1769 | Piranga      | olivacea         |            1984 |     5 |\n| 1287 | Passerculus  | sandwichensis    |            1988 |     5 |\n| 1771 | Setophaga    | petechia         |            1983 |     5 |\n| 2325 | Setophaga    | tigrina          |            1993 |     5 |\n|  795 | Setophaga    | palmarum         |            1999 |     5 |\n|  277 | Setophaga    | caerulescens     |            1995 |     4 |\n|  319 | Dumetella    | carolinensis     |            1997 |     4 |\n| 1758 | Ammodramus   | savannarum       |            1983 |     4 |\n| 1987 | Setophaga    | caerulescens     |            2005 |     4 |\n|  983 | Pipilo       | erythrophthalmus |            1983 |     4 |\n| 2094 | Toxostoma    | rufum            |            2002 |     4 |\n|   88 | Regulus      | satrapa          |            2003 |     4 |\n| 1759 | Spizella     | pusilla          |            2002 |     4 |\n| 1745 | Setophaga    | petechia         |            1984 |     4 |\n| 2270 | Spizella     | passerina        |            1993 |     4 |\n| 1997 | Ammodramus   | savannarum       |            1996 |     4 |\n| 2000 | Empidonax    | minimus          |            2012 |     4 |\n|  300 | Geothlypis   | trichas          |            1978 |     4 |\n|  840 | Setophaga    | pensylvanica     |            1987 |     4 |\n| 1533 | Oporornis    | agilis           |            1999 |     4 |\n| 2067 | Pheucticus   | ludovicianus     |            1984 |     4 |\n|  289 | Setophaga    | virens           |            1982 |     4 |\n| 2083 | Regulus      | calendula        |            2004 |     4 |\n| 1724 | Empidonax    | minimus          |            1983 |     4 |\n|   27 | Catharus     | fuscescens       |            1999 |     4 |\n|  932 | Empidonax    | traillii         |            1990 |     4 |\n| 2419 | Empidonax    | traillii         |            1987 |     4 |\n| 2043 | Setophaga    | pinus            |            2008 |     4 |\n| 1545 | Setophaga    | tigrina          |            2005 |     4 |\n| 1691 | Ammodramus   | savannarum       |            2014 |     4 |\n|  279 | Sayornis     | phoebe           |            2009 |     4 |\n| 2158 | Setophaga    | caerulescens     |            1982 |     4 |\n| 2023 | Cardellina   | canadensis       |            1981 |     4 |\n| 1770 | Setophaga    | fusca            |            2005 |     4 |\n| 2016 | Regulus      | calendula        |            1993 |     4 |\n| 1734 | Cistothorus  | palustris        |            2006 |     4 |\n| 1586 | Icterus      | galbula          |            2007 |     4 |\n| 2117 | Regulus      | satrapa          |            1992 |     4 |\n|  947 | Regulus      | satrapa          |            2001 |     4 |\n|  859 | Setophaga    | striata          |            1991 |     4 |\n|  958 | Toxostoma    | rufum            |            1998 |     4 |\n| 1804 | Setophaga    | magnolia         |            2001 |     4 |\n| 1889 | Parkesia     | noveboracensis   |            2001 |     4 |\n|  140 | Ammodramus   | savannarum       |            1993 |     4 |\n|  148 | Icterus      | galbula          |            2010 |     4 |\n|  357 | Passerculus  | sandwichensis    |            2016 |     4 |\n| 1871 | Empidonax    | minimus          |            2007 |     4 |\n|  152 | Setophaga    | palmarum         |            1981 |     4 |\n|  155 | Troglodytes  | hiemalis         |            1990 |     4 |\n| 1816 | Toxostoma    | rufum            |            1996 |     4 |\n| 1819 | Empidonax    | minimus          |            2013 |     4 |\n| 1845 | Catharus     | minimus          |            2001 |     4 |\n| 2368 | Pipilo       | erythrophthalmus |            1982 |     4 |\n|  176 | Setophaga    | tigrina          |            2002 |     4 |\n| 2114 | Cardellina   | canadensis       |            2005 |     4 |\n|  187 | Hylocichla   | mustelina        |            2003 |     4 |\n| 1830 | Cardellina   | canadensis       |            1982 |     4 |\n| 1627 | Vermivora    | chrysoptera      |            2005 |     4 |\n|  128 | Setophaga    | striata          |            1978 |     4 |\n| 1672 | Troglodytes  | hiemalis         |            2003 |     4 |\n|  209 | Setophaga    | petechia         |            2008 |     4 |\n|  382 | Icterus      | galbula          |            1998 |     4 |\n|   99 | Vermivora    | chrysoptera      |            2008 |     4 |\n| 1937 | Sitta        | canadensis       |            2006 |     4 |\n|  968 | Setophaga    | virens           |            1994 |     4 |\n| 1599 | Toxostoma    | rufum            |            1987 |     4 |\n| 1601 | Pipilo       | erythrophthalmus |            2007 |     4 |\n|  107 | Cistothorus  | platensis        |            2009 |     4 |\n|  901 | Empidonax    | minimus          |            1992 |     4 |\n| 2408 | Setophaga    | pinus            |            2010 |     4 |\n|  116 | Setophaga    | tigrina          |            1992 |     4 |\n| 1922 | Geothlypis   | philadelphia     |            1985 |     4 |\n| 2126 | Piranga      | olivacea         |            2001 |     4 |\n| 2149 | Regulus      | calendula        |            1998 |     4 |\n| 1920 | Ammodramus   | savannarum       |            1994 |     4 |\n|  898 | Contopus     | virens           |            2013 |     4 |\n| 1906 | Oreothlypis  | celata           |            1988 |     4 |\n| 1619 | Cardellina   | canadensis       |            1987 |     4 |\n| 1598 | Catharus     | minimus          |            1999 |     4 |\n| 1104 | Icterus      | galbula          |            2013 |     4 |\n| 1170 | Geothlypis   | philadelphia     |            1997 |     4 |\n|  736 | Oreothlypis  | celata           |            1998 |     4 |\n| 2326 | Cistothorus  | platensis        |            2010 |     4 |\n| 1139 | Empidonax    | flaviventris     |            2014 |     4 |\n| 1082 | Spizella     | pusilla          |            1995 |     4 |\n|  800 | Piranga      | rubra            |            2010 |     4 |\n| 2341 | Vireo        | olivaceus        |            2003 |     4 |\n|  740 | Setophaga    | americana        |            2009 |     4 |\n| 1473 | Hylocichla   | mustelina        |            1993 |     4 |\n| 1134 | Setophaga    | castanea         |            2000 |     4 |\n| 1023 | Spizella     | pallida          |            1984 |     4 |\n| 2202 | Spizella     | pusilla          |            2006 |     4 |\n|  469 | Cardellina   | canadensis       |            1993 |     4 |\n| 1485 | Setophaga    | ruticilla        |            1998 |     4 |\n| 1489 | Spizella     | pusilla          |            1999 |     4 |\n|  767 | Oreothlypis  | celata           |            2000 |     4 |\n|  669 | Empidonax    | traillii         |            2004 |     4 |\n| 1295 | Empidonax    | flaviventris     |            1985 |     4 |\n|  766 | Spizella     | pusilla          |            2005 |     4 |\n|  802 | Pipilo       | erythrophthalmus |            2009 |     4 |\n| 1057 | Toxostoma    | rufum            |            2003 |     4 |\n| 1236 | Setophaga    | ruticilla        |            1987 |     4 |\n|  487 | Setophaga    | ruticilla        |            1999 |     4 |\n| 1076 | Setophaga    | tigrina          |            1982 |     4 |\n| 1162 | Empidonax    | traillii         |            1989 |     4 |\n| 2183 | Pheucticus   | ludovicianus     |            2004 |     4 |\n| 1408 | Setophaga    | castanea         |            1986 |     4 |\n| 2182 | Sitta        | canadensis       |            2008 |     4 |\n| 1378 | Cardellina   | pusilla          |            2012 |     4 |\n|  515 | Spizella     | passerina        |            1979 |     4 |\n| 2252 | Setophaga    | castanea         |            1988 |     4 |\n| 1151 | Oporornis    | agilis           |            2000 |     4 |\n|  697 | Spizella     | passerina        |            1995 |     4 |\n|  774 | Setophaga    | pinus            |            2014 |     4 |\n|  777 | Setophaga    | ruticilla        |            1991 |     4 |\n| 1144 | Hylocichla   | mustelina        |            1980 |     4 |\n|  781 | Setophaga    | fusca            |            1985 |     4 |\n|  783 | Ammodramus   | nelsoni          |            1992 |     4 |\n|  495 | Spizella     | pallida          |            2000 |     4 |\n| 2176 | Mniotilta    | varia            |            1994 |     4 |\n| 1290 | Catharus     | minimus          |            1991 |     4 |\n| 1399 | Geothlypis   | philadelphia     |            2001 |     4 |\n|  746 | Catharus     | fuscescens       |            2001 |     4 |\n| 2301 | Mniotilta    | varia            |            1982 |     4 |\n| 2208 | Setophaga    | caerulescens     |            1985 |     4 |\n| 1267 | Cistothorus  | palustris        |            1984 |     4 |\n|  833 | Hylocichla   | mustelina        |            1998 |     4 |\n| 1110 | Troglodytes  | hiemalis         |            1987 |     4 |\n|  662 | Troglodytes  | hiemalis         |            1996 |     4 |\n|  645 | Spizella     | pusilla          |            2014 |     4 |\n| 1116 | Toxostoma    | rufum            |            2005 |     4 |\n| 1117 | Contopus     | virens           |            1993 |     4 |\n|  629 | Piranga      | olivacea         |            1990 |     4 |\n| 1113 | Passerina    | cyanea           |            2003 |     4 |\n| 2230 | Catharus     | fuscescens       |            1981 |     4 |\n| 1240 | Cardellina   | pusilla          |            2005 |     4 |\n| 2321 | Sitta        | canadensis       |            1985 |     3 |\n|  964 | Setophaga    | americana        |            2008 |     3 |\n| 1265 | Setophaga    | americana        |            2006 |     3 |\n| 2193 | Setophaga    | fusca            |            1983 |     3 |\n| 1726 | Passerculus  | sandwichensis    |            1998 |     3 |\n| 1856 | Cardellina   | pusilla          |            2006 |     3 |\n| 2194 | Setophaga    | tigrina          |            2000 |     3 |\n| 1954 | Contopus     | virens           |            1995 |     3 |\n| 1866 | Icterus      | galbula          |            1985 |     3 |\n| 2381 | Cistothorus  | platensis        |            2000 |     3 |\n|   98 | Oreothlypis  | celata           |            1993 |     3 |\n|  776 | Setophaga    | virens           |            1995 |     3 |\n|  701 | Piranga      | olivacea         |            2002 |     3 |\n| 1690 | Setophaga    | americana        |            1983 |     3 |\n|  101 | Setophaga    | americana        |            2010 |     3 |\n|  103 | Setophaga    | petechia         |            1988 |     3 |\n| 1938 | Pipilo       | erythrophthalmus |            2015 |     3 |\n| 1349 | Spizella     | pallida          |            2008 |     3 |\n|  787 | Empidonax    | traillii         |            2008 |     3 |\n| 1689 | Setophaga    | petechia         |            1994 |     3 |\n|  907 | Toxostoma    | rufum            |            2004 |     3 |\n|  651 | Empidonax    | virescens        |            1981 |     3 |\n| 1934 | Certhia      | americana        |            1979 |     3 |\n| 1723 | Icterus      | galbula          |            2008 |     3 |\n|  712 | Setophaga    | pensylvanica     |            1983 |     3 |\n| 2241 | Pipilo       | erythrophthalmus |            2002 |     3 |\n|  306 | Pipilo       | erythrophthalmus |            1987 |     3 |\n|   79 | Pipilo       | erythrophthalmus |            1984 |     3 |\n|  543 | Pheucticus   | ludovicianus     |            1992 |     3 |\n| 2133 | Empidonax    | traillii         |            1979 |     3 |\n|  962 | Pheucticus   | ludovicianus     |            1978 |     3 |\n| 1970 | Ammodramus   | nelsoni          |            1998 |     3 |\n|  303 | Cistothorus  | palustris        |            2013 |     3 |\n|  990 | Pipilo       | erythrophthalmus |            2008 |     3 |\n|  788 | Myiarchus    | crinitus         |            1986 |     3 |\n| 2261 | Empidonax    | flaviventris     |            1994 |     3 |\n| 1969 | Setophaga    | castanea         |            1981 |     3 |\n| 1709 | Troglodytes  | aedon            |            2002 |     3 |\n|  308 | Setophaga    | americana        |            2013 |     3 |\n| 1256 | Vermivora    | chrysoptera      |            1996 |     3 |\n| 1965 | Certhia      | americana        |            1991 |     3 |\n|  988 | Empidonax    | flaviventris     |            2007 |     3 |\n|  905 | Spizella     | pallida          |            1982 |     3 |\n| 1839 | Cistothorus  | platensis        |            1984 |     3 |\n|  702 | Hylocichla   | mustelina        |            1989 |     3 |\n| 1180 | Regulus      | satrapa          |            1997 |     3 |\n| 2333 | Spizella     | pusilla          |            1997 |     3 |\n|  286 | Oreothlypis  | celata           |            1979 |     3 |\n| 1371 | Troglodytes  | aedon            |            2010 |     3 |\n| 1757 | Cardellina   | canadensis       |            1988 |     3 |\n| 2309 | Contopus     | virens           |            2016 |     3 |\n| 2387 | Setophaga    | castanea         |            1997 |     3 |\n|  882 | Setophaga    | americana        |            2014 |     3 |\n| 2262 | Setophaga    | virens           |            1984 |     3 |\n|  191 | Setophaga    | tigrina          |            1991 |     3 |\n| 1910 | Spizella     | pallida          |            1992 |     3 |\n|  141 | Pipilo       | erythrophthalmus |            2010 |     3 |\n| 1908 | Vermivora    | chrysoptera      |            2011 |     3 |\n| 1792 | Empidonax    | traillii         |            1984 |     3 |\n| 1793 | Pipilo       | erythrophthalmus |            1981 |     3 |\n| 1306 | Piranga      | olivacea         |            1982 |     3 |\n| 1797 | Dumetella    | carolinensis     |            1980 |     3 |\n| 1798 | Setophaga    | pensylvanica     |            1992 |     3 |\n|  678 | Sitta        | canadensis       |            1997 |     3 |\n| 1224 | Ammodramus   | leconteii        |            2012 |     3 |\n| 1227 | Regulus      | calendula        |            1989 |     3 |\n| 1821 | Oporornis    | agilis           |            1980 |     3 |\n| 2105 | Ammodramus   | nelsoni          |            1989 |     3 |\n| 2295 | Zonotrichia  | leucophrys       |            1997 |     3 |\n|  207 | Spizella     | pallida          |            2014 |     3 |\n|  892 | Cistothorus  | platensis        |            2013 |     3 |\n|  205 | Ammodramus   | savannarum       |            1987 |     3 |\n| 2211 | Troglodytes  | aedon            |            2012 |     3 |\n| 1233 | Sturnella    | magna            |            2011 |     3 |\n|  134 | Empidonax    | traillii         |            1988 |     3 |\n|  609 | Regulus      | satrapa          |            1984 |     3 |\n|  603 | Setophaga    | striata          |            2001 |     3 |\n| 1875 | Cistothorus  | palustris        |            2015 |     3 |\n|  119 | Vireo        | solitarius       |            2012 |     3 |\n|  250 | Empidonax    | minimus          |            2005 |     3 |\n| 1887 | Cistothorus  | platensis        |            2014 |     3 |\n|  966 | Setophaga    | pensylvanica     |            1994 |     3 |\n| 1336 | Contopus     | virens           |            1992 |     3 |\n| 1760 | Empidonax    | minimus          |            1984 |     3 |\n|  579 | Setophaga    | fusca            |            1984 |     3 |\n| 1058 | Sayornis     | phoebe           |            2013 |     3 |\n| 1763 | Vermivora    | chrysoptera      |            2012 |     3 |\n| 2386 | Cardellina   | canadensis       |            1991 |     3 |\n|  145 | Troglodytes  | aedon            |            1985 |     3 |\n|  230 | Cistothorus  | palustris        |            1987 |     3 |\n| 1768 | Oreothlypis  | celata           |            1982 |     3 |\n|  144 | Piranga      | olivacea         |            1986 |     3 |\n| 2403 | Ammodramus   | nelsoni          |            1994 |     3 |\n|  596 | Spizella     | pusilla          |            2004 |     3 |\n|  978 | Ammodramus   | nelsoni          |            1993 |     3 |\n| 2217 | Setophaga    | pinus            |            2009 |     3 |\n| 1880 | Catharus     | minimus          |            1978 |     3 |\n| 1916 | Ammodramus   | nelsoni          |            1988 |     3 |\n|  900 | Setophaga    | tigrina          |            1983 |     3 |\n|  633 | Hylocichla   | mustelina        |            1999 |     3 |\n| 1914 | Protonotaria | citrea           |            1996 |     3 |\n| 1241 | Pipilo       | erythrophthalmus |            1996 |     3 |\n|  881 | Spizella     | pallida          |            1993 |     3 |\n| 2273 | Empidonax    | traillii         |            1980 |     3 |\n|  715 | Spizella     | pusilla          |            2003 |     3 |\n| 2026 | Pipilo       | erythrophthalmus |            1994 |     3 |\n| 1587 | Cardellina   | canadensis       |            1989 |     3 |\n| 1589 | Contopus     | virens           |            2006 |     3 |\n|   45 | Contopus     | virens           |            2011 |     3 |\n| 2034 | Setophaga    | virens           |            2004 |     3 |\n| 1024 | Toxostoma    | rufum            |            1980 |     3 |\n| 2171 | Empidonax    | flaviventris     |            2009 |     3 |\n| 2032 | Icterus      | galbula          |            1994 |     3 |\n| 1025 | Setophaga    | americana        |            2007 |     3 |\n| 2172 | Vireo        | olivaceus        |            2002 |     3 |\n| 1603 | Setophaga    | petechia         |            2009 |     3 |\n| 2028 | Cardellina   | canadensis       |            2010 |     3 |\n|  849 | Ammodramus   | savannarum       |            2008 |     3 |\n|  458 | Sitta        | canadensis       |            2001 |     3 |\n|  738 | Vermivora    | chrysoptera      |            2013 |     3 |\n|  850 | Spizella     | passerina        |            1994 |     3 |\n| 1141 | Setophaga    | caerulescens     |            2003 |     3 |\n| 1617 | Empidonax    | traillii         |            2010 |     3 |\n|  851 | Spizella     | pusilla          |            1979 |     3 |\n|  364 | Cistothorus  | palustris        |            2007 |     3 |\n| 1622 | Dumetella    | carolinensis     |            1981 |     3 |\n|  825 | Zonotrichia  | leucophrys       |            1980 |     3 |\n| 1625 | Setophaga    | castanea         |            1985 |     3 |\n| 1031 | Hylocichla   | mustelina        |            1997 |     3 |\n|  496 | Empidonax    | traillii         |            1983 |     3 |\n|  391 | Regulus      | calendula        |            1991 |     3 |\n| 1582 | Troglodytes  | aedon            |            1990 |     3 |\n| 1443 | Pipilo       | erythrophthalmus |            2004 |     3 |\n|  417 | Geothlypis   | formosa          |            1979 |     3 |\n|    6 | Vireo        | olivaceus        |            2016 |     3 |\n| 1530 | Setophaga    | castanea         |            1995 |     3 |\n| 1521 | Setophaga    | caerulescens     |            1979 |     3 |\n| 1532 | Vireo        | olivaceus        |            2005 |     3 |\n|  761 | Setophaga    | coronata         |            1980 |     3 |\n|  837 | Setophaga    | americana        |            2016 |     3 |\n|    9 | Troglodytes  | aedon            |            1992 |     3 |\n| 2288 | Empidonax    | flaviventris     |            1984 |     3 |\n|  421 | Setophaga    | caerulescens     |            1988 |     3 |\n|  918 | Setophaga    | fusca            |            1992 |     3 |\n|  930 | Troglodytes  | hiemalis         |            1986 |     3 |\n| 2060 | Setophaga    | tigrina          |            2011 |     3 |\n|  399 | Sitta        | canadensis       |            2011 |     3 |\n| 1551 | Setophaga    | petechia         |            1982 |     3 |\n| 1504 | Empidonax    | traillii         |            2006 |     3 |\n|  445 | Passerina    | cyanea           |            1980 |     3 |\n| 1558 | Vireo        | solitarius       |            2013 |     3 |\n|  917 | Setophaga    | petechia         |            1990 |     3 |\n| 1564 | Setophaga    | caerulescens     |            2007 |     3 |\n| 2353 | Spizella     | passerina        |            1982 |     3 |\n|  410 | Cistothorus  | platensis        |            1995 |     3 |\n| 1494 | Setophaga    | ruticilla        |            2001 |     3 |\n| 2364 | Cistothorus  | palustris        |            2016 |     3 |\n|   40 | Pooecetes    | gramineus        |            1987 |     3 |\n| 1632 | Empidonax    | flaviventris     |            1993 |     3 |\n| 1859 | Setophaga    | magnolia         |            1998 |     3 |\n| 1413 | Spizella     | passerina        |            2010 |     3 |\n| 1640 | Troglodytes  | aedon            |            1996 |     3 |\n| 1430 | Ammodramus   | nelsoni          |            2014 |     3 |\n| 1426 | Vireo        | solitarius       |            2006 |     3 |\n| 1425 | Cardellina   | pusilla          |            1995 |     3 |\n|  344 | Setophaga    | fusca            |            2004 |     3 |\n| 1405 | Geothlypis   | formosa          |            2015 |     3 |\n| 1153 | Troglodytes  | aedon            |            1986 |     3 |\n|  321 | Empidonax    | minimus          |            1980 |     3 |\n| 1673 | Passerina    | cyanea           |            1978 |     3 |\n| 1434 | Pheucticus   | ludovicianus     |            1989 |     3 |\n|  324 | Icterus      | galbula          |            2009 |     3 |\n|  355 | Troglodytes  | aedon            |            1984 |     3 |\n|  999 | Ammodramus   | savannarum       |            1985 |     3 |\n|  505 | Sitta        | canadensis       |            1981 |     3 |\n|  519 | Myiarchus    | crinitus         |            1996 |     3 |\n|  335 | Troglodytes  | hiemalis         |            1991 |     3 |\n|  349 | Ammodramus   | nelsoni          |            1996 |     3 |\n|  332 | Toxostoma    | rufum            |            1993 |     3 |\n| 1984 | Regulus      | satrapa          |            1987 |     3 |\n| 1157 | Cardellina   | pusilla          |            1980 |     3 |\n| 1677 | Contopus     | virens           |            2009 |     3 |\n| 1986 | Empidonax    | flaviventris     |            2008 |     3 |\n| 1994 | Contopus     | virens           |            1985 |     3 |\n| 1680 | Oporornis    | agilis           |            1979 |     3 |\n| 1164 | Cistothorus  | palustris        |            2005 |     3 |\n| 1894 | Empidonax    | minimus          |            1982 |     2 |\n|  960 | Contopus     | virens           |            1984 |     2 |\n| 2044 | Empidonax    | minimus          |            2006 |     2 |\n|   23 | Passerina    | cyanea           |            1997 |     2 |\n| 2045 | Oreothlypis  | celata           |            1987 |     2 |\n| 1238 | Empidonax    | flaviventris     |            2016 |     2 |\n|   26 | Regulus      | satrapa          |            1981 |     2 |\n| 2052 | Setophaga    | americana        |            2004 |     2 |\n| 1125 | Ammodramus   | nelsoni          |            1984 |     2 |\n|  770 | Vireo        | olivaceus        |            2001 |     2 |\n| 1235 | Setophaga    | caerulescens     |            1990 |     2 |\n| 2420 | Setophaga    | castanea         |            1987 |     2 |\n| 1127 | Vireo        | solitarius       |            2009 |     2 |\n| 1146 | Piranga      | olivacea         |            2006 |     2 |\n| 1176 | Cardellina   | canadensis       |            2002 |     2 |\n| 1251 | Icterus      | galbula          |            1990 |     2 |\n|    3 | Vermivora    | cyanoptera       |            2013 |     2 |\n|  158 | Toxostoma    | rufum            |            1992 |     2 |\n| 1107 | Cistothorus  | palustris        |            1982 |     2 |\n| 1169 | Regulus      | satrapa          |            1979 |     2 |\n| 2073 | Spizella     | passerina        |            2013 |     2 |\n| 2225 | Icterus      | galbula          |            1993 |     2 |\n|  153 | Cistothorus  | palustris        |            1979 |     2 |\n| 2109 | Pheucticus   | ludovicianus     |            1994 |     2 |\n|  716 | Ammodramus   | savannarum       |            2003 |     2 |\n| 1111 | Setophaga    | caerulescens     |            1997 |     2 |\n|  754 | Setophaga    | caerulescens     |            1983 |     2 |\n| 1882 | Setophaga    | virens           |            1980 |     2 |\n|  765 | Cistothorus  | platensis        |            2016 |     2 |\n| 1872 | Sitta        | canadensis       |            2000 |     2 |\n|  708 | Setophaga    | tigrina          |            1980 |     2 |\n| 1990 | Piranga      | olivacea         |            2008 |     2 |\n|   16 | Toxostoma    | rufum            |            1985 |     2 |\n| 2095 | Cardellina   | canadensis       |            1979 |     2 |\n| 1878 | Pipilo       | erythrophthalmus |            1989 |     2 |\n| 1131 | Parkesia     | motacilla        |            1985 |     2 |\n| 1991 | Empidonax    | traillii         |            1991 |     2 |\n|  722 | Spizella     | passerina        |            1985 |     2 |\n|   18 | Troglodytes  | hiemalis         |            1999 |     2 |\n|  904 | Vireo        | flavifrons       |            2011 |     2 |\n|   38 | Cistothorus  | platensis        |            1987 |     2 |\n| 2239 | Cistothorus  | palustris        |            1991 |     2 |\n| 1209 | Spizella     | pallida          |            1985 |     2 |\n| 1150 | Spizella     | pallida          |            2011 |     2 |\n| 2017 | Vermivora    | cyanoptera       |            2009 |     2 |\n| 1148 | Sayornis     | phoebe           |            1992 |     2 |\n| 2015 | Setophaga    | pensylvanica     |            2000 |     2 |\n| 1948 | Cardellina   | pusilla          |            1982 |     2 |\n|  733 | Ammodramus   | savannarum       |            1982 |     2 |\n|   55 | Empidonax    | minimus          |            1994 |     2 |\n| 2007 | Troglodytes  | hiemalis         |            1983 |     2 |\n| 1208 | Pheucticus   | ludovicianus     |            2001 |     2 |\n|  113 | Setophaga    | coronata         |            2004 |     2 |\n|  117 | Geothlypis   | formosa          |            1996 |     2 |\n|   51 | Ammodramus   | savannarum       |            2010 |     2 |\n| 2409 | Ammodramus   | savannarum       |            1984 |     2 |\n| 1197 | Setophaga    | caerulescens     |            1984 |     2 |\n| 1931 | Passerculus  | sandwichensis    |            1997 |     2 |\n| 1932 | Cistothorus  | palustris        |            1980 |     2 |\n| 1203 | Contopus     | virens           |            1982 |     2 |\n| 1198 | Vermivora    | chrysoptera      |            1994 |     2 |\n|   53 | Spizella     | passerina        |            1992 |     2 |\n|  692 | Oporornis    | agilis           |            1978 |     2 |\n| 1145 | Pipilo       | erythrophthalmus |            1985 |     2 |\n| 2019 | Myiarchus    | crinitus         |            1982 |     2 |\n| 1168 | Vermivora    | cyanoptera       |            2011 |     2 |\n| 2087 | Setophaga    | virens           |            1979 |     2 |\n| 1996 | Troglodytes  | aedon            |            2013 |     2 |\n| 1081 | Sturnella    | magna            |            1986 |     2 |\n| 1967 | Setophaga    | petechia         |            1980 |     2 |\n| 2213 | Spizella     | passerina        |            1990 |     2 |\n| 1939 | Vermivora    | cyanoptera       |            1991 |     2 |\n| 2096 | Spizella     | pallida          |            2016 |     2 |\n| 1221 | Geothlypis   | formosa          |            2008 |     2 |\n| 2102 | Cardellina   | canadensis       |            2016 |     2 |\n|  915 | Spizella     | pallida          |            1999 |     2 |\n|  936 | Pipilo       | erythrophthalmus |            2014 |     2 |\n| 1963 | Empidonax    | minimus          |            2010 |     2 |\n| 1219 | Setophaga    | tigrina          |            1988 |     2 |\n| 2228 | Troglodytes  | hiemalis         |            1998 |     2 |\n| 2101 | Setophaga    | petechia         |            1992 |     2 |\n| 1154 | Ammodramus   | savannarum       |            1998 |     2 |\n| 1999 | Spizella     | passerina        |            1991 |     2 |\n| 2030 | Vireo        | philadelphicus   |            2006 |     2 |\n|   92 | Ammodramus   | savannarum       |            1979 |     2 |\n|   48 | Vermivora    | chrysoptera      |            1990 |     2 |\n| 1956 | Icterus      | galbula          |            1996 |     2 |\n|  953 | Vermivora    | chrysoptera      |            2014 |     2 |\n| 2001 | Sayornis     | phoebe           |            1994 |     2 |\n| 1137 | Vireo        | olivaceus        |            1984 |     2 |\n| 2021 | Cistothorus  | palustris        |            1988 |     2 |\n| 1524 | Contopus     | virens           |            2000 |     2 |\n| 1857 | Pipilo       | erythrophthalmus |            1995 |     2 |\n|  565 | Oporornis    | agilis           |            1998 |     2 |\n|  998 | Piranga      | olivacea         |            1988 |     2 |\n| 2371 | Setophaga    | pensylvanica     |            1995 |     2 |\n| 1416 | Setophaga    | virens           |            1998 |     2 |\n|  821 | Vermivora    | chrysoptera      |            2007 |     2 |\n|  822 | Vireo        | olivaceus        |            1995 |     2 |\n|  341 | Sayornis     | phoebe           |            2007 |     2 |\n| 1421 | Piranga      | olivacea         |            1992 |     2 |\n|  352 | Spizella     | pallida          |            2009 |     2 |\n| 1644 | Myiarchus    | crinitus         |            1994 |     2 |\n|  503 | Pheucticus   | ludovicianus     |            1998 |     2 |\n| 2146 | Cistothorus  | palustris        |            1983 |     2 |\n|  501 | Ammodramus   | nelsoni          |            1987 |     2 |\n| 1034 | Cistothorus  | platensis        |            1990 |     2 |\n| 1634 | Piranga      | olivacea         |            1991 |     2 |\n| 2291 | Troglodytes  | aedon            |            1999 |     2 |\n|  494 | Piranga      | olivacea         |            1980 |     2 |\n| 1454 | Vireo        | philadelphicus   |            2011 |     2 |\n| 1621 | Vireo        | flavifrons       |            1996 |     2 |\n|  484 | Vireo        | olivaceus        |            1987 |     2 |\n| 2139 | Spizella     | passerina        |            1983 |     2 |\n| 1676 | Pooecetes    | gramineus        |            1991 |     2 |\n| 1678 | Setophaga    | petechia         |            2007 |     2 |\n| 2336 | Ammodramus   | henslowii        |            1984 |     2 |\n| 1729 | Vermivora    | chrysoptera      |            2010 |     2 |\n|  282 | Oreothlypis  | celata           |            1994 |     2 |\n| 1372 | Ammodramus   | savannarum       |            2006 |     2 |\n|  552 | Setophaga    | castanea         |            2003 |     2 |\n| 1375 | Sayornis     | phoebe           |            1999 |     2 |\n| 1074 | Ammodramus   | nelsoni          |            1990 |     2 |\n| 1707 | Setophaga    | caerulescens     |            2000 |     2 |\n| 1379 | Troglodytes  | hiemalis         |            1978 |     2 |\n| 2338 | Regulus      | calendula        |            2001 |     2 |\n| 2184 | Parkesia     | motacilla        |            2011 |     2 |\n|  536 | Regulus      | calendula        |            1996 |     2 |\n| 2134 | Troglodytes  | aedon            |            2006 |     2 |\n| 2187 | Cistothorus  | platensis        |            2001 |     2 |\n|  870 | Certhia      | americana        |            1978 |     2 |\n| 2186 | Toxostoma    | rufum            |            1978 |     2 |\n|  530 | Setophaga    | fusca            |            1979 |     2 |\n| 1684 | Setophaga    | americana        |            2002 |     2 |\n| 1402 | Regulus      | satrapa          |            1990 |     2 |\n| 1616 | Passerculus  | sandwichensis    |            2005 |     2 |\n| 2175 | Setophaga    | castanea         |            1998 |     2 |\n| 1462 | Parkesia     | motacilla        |            1982 |     2 |\n| 1512 | Ammodramus   | leconteii        |            1988 |     2 |\n|  451 | Cardellina   | canadensis       |            1983 |     2 |\n| 1559 | Myiarchus    | crinitus         |            2014 |     2 |\n| 1556 | Ammodramus   | nelsoni          |            2005 |     2 |\n| 2274 | Hylocichla   | mustelina        |            1995 |     2 |\n| 1549 | Piranga      | olivacea         |            1985 |     2 |\n| 1547 | Cistothorus  | platensis        |            2006 |     2 |\n| 1017 | Toxostoma    | rufum            |            1984 |     2 |\n|  439 | Cardellina   | pusilla          |            1998 |     2 |\n| 1540 | Mniotilta    | varia            |            1991 |     2 |\n| 1569 | Pipilo       | erythrophthalmus |            2013 |     2 |\n| 1516 | Sitta        | canadensis       |            1999 |     2 |\n| 1537 | Ammodramus   | savannarum       |            2001 |     2 |\n| 2160 | Setophaga    | castanea         |            1980 |     2 |\n|  425 | Spizella     | passerina        |            2009 |     2 |\n|  839 | Empidonax    | traillii         |            1995 |     2 |\n|  428 | Cardellina   | pusilla          |            2003 |     2 |\n| 2257 | Setophaga    | petechia         |            2010 |     2 |\n| 1527 | Empidonax    | flaviventris     |            2012 |     2 |\n|  842 | Empidonax    | flaviventris     |            1989 |     2 |\n|  409 | Setophaga    | tigrina          |            1990 |     2 |\n|  481 | Empidonax    | minimus          |            2004 |     2 |\n| 1600 | Mniotilta    | varia            |            1997 |     2 |\n|  480 | Spizella     | passerina        |            2015 |     2 |\n| 2290 | Piranga      | olivacea         |            2000 |     2 |\n| 1468 | Setophaga    | petechia         |            2006 |     2 |\n|  476 | Setophaga    | caerulescens     |            1994 |     2 |\n|  372 | Cistothorus  | palustris        |            1992 |     2 |\n|  373 | Sayornis     | phoebe           |            1988 |     2 |\n| 1471 | Passerina    | cyanea           |            2001 |     2 |\n|  374 | Pipilo       | erythrophthalmus |            1998 |     2 |\n| 1597 | Setophaga    | pensylvanica     |            1999 |     2 |\n|  455 | Cistothorus  | palustris        |            1986 |     2 |\n| 2348 | Parkesia     | motacilla        |            2008 |     2 |\n| 2170 | Regulus      | satrapa          |            1986 |     2 |\n|  390 | Setophaga    | virens           |            2000 |     2 |\n| 1021 | Myiarchus    | crinitus         |            1983 |     2 |\n| 1578 | Troglodytes  | hiemalis         |            1979 |     2 |\n|  401 | Spizella     | pallida          |            2015 |     2 |\n|  402 | Toxostoma    | rufum            |            1983 |     2 |\n| 1490 | Ammodramus   | savannarum       |            2015 |     2 |\n| 1361 | Regulus      | satrapa          |            1996 |     2 |\n| 2204 | Ammodramus   | savannarum       |            2004 |     2 |\n| 1735 | Toxostoma    | rufum            |            1994 |     2 |\n|  225 | Setophaga    | pensylvanica     |            1998 |     2 |\n|  615 | Vermivora    | chrysoptera      |            2006 |     2 |\n|  614 | Cardellina   | canadensis       |            1986 |     2 |\n|  223 | Empidonax    | traillii         |            1992 |     2 |\n| 1780 | Pheucticus   | ludovicianus     |            2002 |     2 |\n| 1274 | Vireo        | philadelphicus   |            2010 |     2 |\n|  600 | Cistothorus  | palustris        |            1995 |     2 |\n| 1775 | Oporornis    | agilis           |            2003 |     2 |\n| 1791 | Passerculus  | sandwichensis    |            2004 |     2 |\n| 1774 | Spizella     | pallida          |            2012 |     2 |\n| 1272 | Sturnella    | magna            |            1983 |     2 |\n|  597 | Myiarchus    | crinitus         |            1979 |     2 |\n|  589 | Cardellina   | pusilla          |            1993 |     2 |\n| 1060 | Cardellina   | pusilla          |            2004 |     2 |\n|  980 | Cistothorus  | platensis        |            1983 |     2 |\n| 1829 | Cardellina   | pusilla          |            2000 |     2 |\n|  630 | Setophaga    | pinus            |            2007 |     2 |\n|  253 | Spizella     | pallida          |            1988 |     2 |\n| 1297 | Ammodramus   | leconteii        |            1993 |     2 |\n| 1064 | Setophaga    | petechia         |            1993 |     2 |\n| 1811 | Cistothorus  | platensis        |            1994 |     2 |\n|  194 | Pooecetes    | gramineus        |            1992 |     2 |\n| 1294 | Oreothlypis  | celata           |            1991 |     2 |\n| 1067 | Spizella     | passerina        |            2016 |     2 |\n|  202 | Contopus     | virens           |            1988 |     2 |\n| 1298 | Piranga      | olivacea         |            1999 |     2 |\n| 1826 | Setophaga    | petechia         |            2014 |     2 |\n| 1817 | Troglodytes  | hiemalis         |            1994 |     2 |\n|  429 | Setophaga    | pinus            |            2006 |     2 |\n|  969 | Setophaga    | petechia         |            2012 |     2 |\n| 2122 | Ammodramus   | leconteii        |            1991 |     2 |\n| 1799 | Sturnella    | magna            |            2008 |     2 |\n|  210 | Troglodytes  | aedon            |            1991 |     2 |\n|  185 | Cardellina   | canadensis       |            1990 |     2 |\n|  575 | Setophaga    | pinus            |            2013 |     2 |\n| 1740 | Setophaga    | caerulescens     |            1978 |     2 |\n|  260 | Mniotilta    | varia            |            1980 |     2 |\n|  179 | Pheucticus   | ludovicianus     |            2000 |     2 |\n| 2329 | Empidonax    | traillii         |            2000 |     2 |\n|  637 | Ammodramus   | leconteii        |            1982 |     2 |\n| 2195 | Cistothorus  | platensis        |            1992 |     2 |\n| 1838 | Setophaga    | tigrina          |            1987 |     2 |\n|  254 | Setophaga    | americana        |            2003 |     2 |\n|  269 | Setophaga    | tigrina          |            1985 |     2 |\n| 2128 | Spizella     | passerina        |            1984 |     2 |\n|  569 | Spizella     | passerina        |            1986 |     2 |\n| 1345 | Spizelloides | arborea          |            1997 |     2 |\n| 1343 | Cardellina   | pusilla          |            1990 |     2 |\n|  965 | Icterus      | galbula          |            2016 |     2 |\n| 1270 | Setophaga    | petechia         |            1998 |     2 |\n|  180 | Oreothlypis  | ruficapilla      |            2001 |     2 |\n|  574 | Piranga      | olivacea         |            2009 |     2 |\n| 1853 | Ammodramus   | savannarum       |            1991 |     2 |\n|  258 | Ammodramus   | savannarum       |            1989 |     2 |\n| 1353 | Ammodramus   | nelsoni          |            2004 |     2 |\n| 1748 | Geothlypis   | philadelphia     |            1998 |     2 |\n| 1849 | Setophaga    | caerulescens     |            1993 |     2 |\n| 1356 | Troglodytes  | aedon            |            1982 |     2 |\n| 2398 | Setophaga    | petechia         |            2013 |     2 |\n| 2396 | Vireo        | olivaceus        |            1997 |     1 |\n| 2399 | Piranga      | olivacea         |            1987 |     1 |\n| 2320 | Polioptila   | caerulea         |            2004 |     1 |\n| 2233 | Empidonax    | virescens        |            1979 |     1 |\n| 2350 | Contopus     | cooperi          |            2008 |     1 |\n| 2207 | Piranga      | rubra            |            2011 |     1 |\n| 2322 | Pheucticus   | ludovicianus     |            1997 |     1 |\n| 2081 | Sayornis     | phoebe           |            2014 |     1 |\n| 2163 | Cardellina   | canadensis       |            2003 |     1 |\n| 2395 | Setophaga    | virens           |            1993 |     1 |\n| 2361 | Myiarchus    | crinitus         |            2012 |     1 |\n| 2363 | Sturnella    | magna            |            1992 |     1 |\n| 2153 | Icteria      | virens           |            1979 |     1 |\n| 2271 | Icteria      | virens           |            1987 |     1 |\n| 2154 | Ammodramus   | leconteii        |            1985 |     1 |\n| 2317 | Setophaga    | fusca            |            1993 |     1 |\n| 2316 | Cardellina   | canadensis       |            2004 |     1 |\n| 2156 | Sayornis     | phoebe           |            1993 |     1 |\n| 2155 | Sitta        | canadensis       |            1986 |     1 |\n| 2088 | Cardellina   | pusilla          |            1986 |     1 |\n| 2259 | Spizella     | passerina        |            2012 |     1 |\n| 2264 | Passerculus  | sandwichensis    |            1978 |     1 |\n| 2354 | Setophaga    | fusca            |            1999 |     1 |\n| 2394 | Oreothlypis  | celata           |            2002 |     1 |\n| 2287 | Setophaga    | pensylvanica     |            1990 |     1 |\n| 2089 | Icterus      | galbula          |            1984 |     1 |\n| 2392 | Ammodramus   | savannarum       |            2007 |     1 |\n| 2404 | Mniotilta    | varia            |            1999 |     1 |\n| 2413 | Setophaga    | palmarum         |            1980 |     1 |\n| 2137 | Icteria      | virens           |            1988 |     1 |\n| 2340 | Ammodramus   | savannarum       |            2013 |     1 |\n| 2188 | Passerculus  | sandwichensis    |            1980 |     1 |\n| 2266 | Piranga      | olivacea         |            1994 |     1 |\n| 2189 | Setophaga    | fusca            |            1998 |     1 |\n| 2131 | Setophaga    | americana        |            1987 |     1 |\n| 2219 | Setophaga    | fusca            |            1988 |     1 |\n| 2097 | Setophaga    | pinus            |            2002 |     1 |\n| 2280 | Regulus      | calendula        |            1978 |     1 |\n| 2334 | Vireo        | flavifrons       |            2010 |     1 |\n| 2130 | Spizella     | pallida          |            2004 |     1 |\n| 2332 | Contopus     | virens           |            2002 |     1 |\n| 2223 | Vireo        | philadelphicus   |            2007 |     1 |\n| 2296 | Troglodytes  | hiemalis         |            2000 |     1 |\n| 2248 | Geothlypis   | formosa          |            2009 |     1 |\n| 2267 | Empidonax    | flaviventris     |            1979 |     1 |\n| 2308 | Mniotilta    | varia            |            1987 |     1 |\n| 2220 | Ammodramus   | nelsoni          |            2012 |     1 |\n| 2342 | Mniotilta    | varia            |            1993 |     1 |\n| 2127 | Setophaga    | pinus            |            1996 |     1 |\n| 2226 | Myiarchus    | crinitus         |            1989 |     1 |\n| 2215 | Icteria      | virens           |            1981 |     1 |\n| 2210 | Ammodramus   | leconteii        |            2011 |     1 |\n| 2120 | Setophaga    | caerulescens     |            1998 |     1 |\n| 2275 | Passerculus  | sandwichensis    |            2014 |     1 |\n| 2323 | Icterus      | spurius          |            2014 |     1 |\n| 2265 | Ammodramus   | leconteii        |            1998 |     1 |\n| 2406 | Setophaga    | tigrina          |            2003 |     1 |\n| 2389 | Vermivora    | chrysoptera      |            2001 |     1 |\n| 2292 | Sitta        | canadensis       |            1995 |     1 |\n| 2203 | Setophaga    | cerulea          |            1994 |     1 |\n| 2407 | Geothlypis   | formosa          |            1995 |     1 |\n| 2303 | Setophaga    | virens           |            1990 |     1 |\n| 2344 | Vireo        | philadelphicus   |            1983 |     1 |\n| 2414 | Cardellina   | pusilla          |            1994 |     1 |\n| 2284 | Vermivora    | cyanoptera       |            2006 |     1 |\n| 2216 | Empidonax    | flaviventris     |            1981 |     1 |\n| 2227 | Setophaga    | virens           |            2003 |     1 |\n| 2281 | Contopus     | cooperi          |            1997 |     1 |\n| 2310 | Spizella     | pallida          |            1996 |     1 |\n| 2378 | Setophaga    | caerulescens     |            1981 |     1 |\n|    0 | Pipilo       | erythrophthalmus |            2005 |     1 |\n| 2076 | Piranga      | rubra            |            2012 |     1 |\n|  704 | Mniotilta    | varia            |            1989 |     1 |\n|  668 | Empidonax    | virescens        |            1996 |     1 |\n|  676 | Vermivora    | chrysoptera      |            1983 |     1 |\n|  681 | Setophaga    | petechia         |            2016 |     1 |\n|  685 | Vireo        | olivaceus        |            1988 |     1 |\n|  687 | Pooecetes    | gramineus        |            1990 |     1 |\n|  688 | Sitta        | canadensis       |            1980 |     1 |\n|  696 | Ammodramus   | savannarum       |            2009 |     1 |\n|  703 | Cardellina   | pusilla          |            1989 |     1 |\n|  707 | Ammodramus   | nelsoni          |            2007 |     1 |\n|  661 | Piranga      | olivacea         |            2016 |     1 |\n|  709 | Setophaga    | pensylvanica     |            1988 |     1 |\n|  732 | Contopus     | virens           |            2004 |     1 |\n|  742 | Tyrannus     | tyrannus         |            1995 |     1 |\n|  748 | Cistothorus  | platensis        |            2004 |     1 |\n|  750 | Oreothlypis  | celata           |            1983 |     1 |\n|  756 | Cistothorus  | palustris        |            1994 |     1 |\n|  768 | Setophaga    | castanea         |            1999 |     1 |\n|  769 | Contopus     | cooperi          |            2010 |     1 |\n|  664 | Setophaga    | pensylvanica     |            1986 |     1 |\n|  660 | Icteria      | virens           |            1985 |     1 |\n|  539 | Spizella     | pallida          |            2006 |     1 |\n|  582 | Icteria      | virens           |            2012 |     1 |\n|  545 | Cistothorus  | platensis        |            1996 |     1 |\n|  551 | Ammodramus   | nelsoni          |            2006 |     1 |\n|  555 | Icterus      | spurius          |            2011 |     1 |\n|  557 | Contopus     | virens           |            2005 |     1 |\n|  558 | Ammodramus   | henslowii        |            2010 |     1 |\n|  559 | Icterus      | galbula          |            1997 |     1 |\n|  567 | Setophaga    | pinus            |            1994 |     1 |\n|  568 | Ammodramus   | savannarum       |            2000 |     1 |\n|  583 | Parkesia     | motacilla        |            2013 |     1 |\n|  659 | Myiarchus    | crinitus         |            1995 |     1 |\n|  587 | Polioptila   | caerulea         |            2013 |     1 |\n|  598 | Spizella     | passerina        |            2008 |     1 |\n|  599 | Empidonax    | flaviventris     |            1998 |     1 |\n|  620 | Setophaga    | caerulescens     |            1987 |     1 |\n|  628 | Cistothorus  | platensis        |            2003 |     1 |\n|  642 | Vireo        | olivaceus        |            1994 |     1 |\n|  643 | Piranga      | rubra            |            2009 |     1 |\n|  650 | Setophaga    | castanea         |            1990 |     1 |\n|  772 | Setophaga    | petechia         |            2015 |     1 |\n|  794 | Pipilo       | erythrophthalmus |            1980 |     1 |\n|  808 | Cistothorus  | platensis        |            2002 |     1 |\n|  970 | Ammodramus   | savannarum       |            1999 |     1 |\n|  934 | Cistothorus  | palustris        |            2008 |     1 |\n|  938 | Empidonax    | virescens        |            2014 |     1 |\n|  940 | Contopus     | cooperi          |            2009 |     1 |\n|  944 | Cistothorus  | platensis        |            2011 |     1 |\n|  949 | Tyrannus     | tyrannus         |            2015 |     1 |\n|  951 | Troglodytes  | aedon            |            1987 |     1 |\n|  956 | Empidonax    | minimus          |            1986 |     1 |\n|  967 | Oreothlypis  | celata           |            2001 |     1 |\n|  974 | Setophaga    | petechia         |            1979 |     1 |\n|  809 | Troglodytes  | aedon            |            1994 |     1 |\n|  989 | Sayornis     | phoebe           |            2002 |     1 |\n| 1007 | Icterus      | galbula          |            2002 |     1 |\n| 1009 | Sayornis     | phoebe           |            1980 |     1 |\n| 1012 | Empidonax    | minimus          |            1988 |     1 |\n| 1013 | Vermivora    | chrysoptera      |            2000 |     1 |\n| 1019 | Regulus      | calendula        |            1986 |     1 |\n| 1020 | Vermivora    | cyanoptera       |            2012 |     1 |\n| 1022 | Pipilo       | erythrophthalmus |            1997 |     1 |\n|  927 | Sayornis     | phoebe           |            2016 |     1 |\n|  924 | Setophaga    | petechia         |            1981 |     1 |\n|  920 | Vireo        | solitarius       |            2008 |     1 |\n|  913 | Sayornis     | phoebe           |            2004 |     1 |\n|  813 | Icterus      | galbula          |            2003 |     1 |\n|  823 | Contopus     | virens           |            1991 |     1 |\n|  829 | Setophaga    | petechia         |            2005 |     1 |\n|  834 | Parkesia     | motacilla        |            1999 |     1 |\n|  841 | Regulus      | calendula        |            1979 |     1 |\n|  843 | Pipilo       | erythrophthalmus |            2003 |     1 |\n|  845 | Vireo        | flavifrons       |            2013 |     1 |\n|  846 | Piranga      | olivacea         |            1995 |     1 |\n|  854 | Pipilo       | erythrophthalmus |            1988 |     1 |\n|  858 | Troglodytes  | aedon            |            2000 |     1 |\n|  861 | Icteria      | virens           |            1986 |     1 |\n|  862 | Pooecetes    | gramineus        |            1985 |     1 |\n|  873 | Setophaga    | petechia         |            2003 |     1 |\n|  874 | Vermivora    | cyanoptera       |            2005 |     1 |\n|  888 | Sitta        | canadensis       |            1996 |     1 |\n|  896 | Passerculus  | sandwichensis    |            2015 |     1 |\n|  910 | Ammodramus   | savannarum       |            2002 |     1 |\n|  540 | Setophaga    | americana        |            1985 |     1 |\n|  535 | Setophaga    | citrina          |            2009 |     1 |\n| 2071 | Spizella     | pusilla          |            2015 |     1 |\n|  189 | Empidonax    | minimus          |            1990 |     1 |\n|  159 | Contopus     | virens           |            1998 |     1 |\n|  161 | Setophaga    | petechia         |            1986 |     1 |\n|  163 | Vermivora    | cyanoptera       |            1988 |     1 |\n|  164 | Empidonax    | traillii         |            1986 |     1 |\n|  169 | Cistothorus  | platensis        |            2007 |     1 |\n|  170 | Regulus      | satrapa          |            1978 |     1 |\n|  173 | Ammodramus   | nelsoni          |            1995 |     1 |\n|  182 | Ammodramus   | henslowii        |            1983 |     1 |\n|  195 | Vermivora    | chrysoptera      |            2002 |     1 |\n|  143 | Oreothlypis  | celata           |            1980 |     1 |\n|  201 | Cistothorus  | platensis        |            1979 |     1 |\n|  212 | Geothlypis   | formosa          |            1984 |     1 |\n|  214 | Parkesia     | motacilla        |            1994 |     1 |\n|  219 | Pipilo       | erythrophthalmus |            1979 |     1 |\n|  222 | Setophaga    | cerulea          |            2013 |     1 |\n|  235 | Pipilo       | erythrophthalmus |            1993 |     1 |\n|  242 | Icterus      | galbula          |            1989 |     1 |\n|  245 | Pooecetes    | gramineus        |            1986 |     1 |\n|  154 | Myiarchus    | crinitus         |            2013 |     1 |\n|  131 | Vireo        | flavifrons       |            2007 |     1 |\n|  528 | Myiarchus    | crinitus         |            2016 |     1 |\n|   59 | Troglodytes  | aedon            |            1998 |     1 |\n|    8 | Piranga      | olivacea         |            1993 |     1 |\n|   11 | Myiarchus    | crinitus         |            1990 |     1 |\n|   12 | Icterus      | galbula          |            2001 |     1 |\n|   21 | Vireo        | gilvus           |            2015 |     1 |\n|   36 | Zonotrichia  | querula          |            2008 |     1 |\n|   37 | Icterus      | spurius          |            1996 |     1 |\n|   46 | Protonotaria | citrea           |            2012 |     1 |\n|   54 | Mniotilta    | varia            |            1981 |     1 |\n|   62 | Myiarchus    | crinitus         |            1992 |     1 |\n|  125 | Spizella     | passerina        |            2007 |     1 |\n|   70 | Myiarchus    | crinitus         |            2011 |     1 |\n|   73 | Ammodramus   | leconteii        |            2000 |     1 |\n|   90 | Empidonax    | minimus          |            1981 |     1 |\n|   94 | Protonotaria | citrea           |            2002 |     1 |\n|  108 | Oreothlypis  | celata           |            1978 |     1 |\n|  111 | Parkesia     | motacilla        |            2009 |     1 |\n|  115 | Ammodramus   | nelsoni          |            1985 |     1 |\n|  121 | Sturnella    | magna            |            1999 |     1 |\n|  248 | Contopus     | virens           |            2010 |     1 |\n|  270 | Cistothorus  | platensis        |            1986 |     1 |\n|  281 | Piranga      | rubra            |            1979 |     1 |\n|  464 | Setophaga    | virens           |            1981 |     1 |\n|  443 | Setophaga    | citrina          |            1996 |     1 |\n|  444 | Ammodramus   | nelsoni          |            2009 |     1 |\n|  447 | Vireo        | solitarius       |            1986 |     1 |\n|  448 | Icterus      | galbula          |            1988 |     1 |\n|  450 | Spizella     | pusilla          |            2013 |     1 |\n|  453 | Myiarchus    | crinitus         |            1980 |     1 |\n|  456 | Pipilo       | erythrophthalmus |            1992 |     1 |\n|  461 | Icterus      | spurius          |            1998 |     1 |\n|  472 | Vireo        | philadelphicus   |            2014 |     1 |\n|  293 | Vireo        | solitarius       |            2011 |     1 |\n|  474 | Icterus      | galbula          |            1986 |     1 |\n|  483 | Empidonax    | flaviventris     |            1991 |     1 |\n|  485 | Vermivora    | chrysoptera      |            1984 |     1 |\n|  489 | Toxostoma    | rufum            |            2000 |     1 |\n|  508 | Troglodytes  | aedon            |            1980 |     1 |\n|  521 | Setophaga    | fusca            |            1994 |     1 |\n|  523 | Icteria      | virens           |            2010 |     1 |\n|  527 | Empidonax    | traillii         |            2003 |     1 |\n|  438 | Icteria      | virens           |            2005 |     1 |\n|  437 | Ammodramus   | nelsoni          |            1982 |     1 |\n|  419 | Vireo        | philadelphicus   |            2004 |     1 |\n|  416 | Contopus     | virens           |            1987 |     1 |\n|  295 | Vireo        | olivaceus        |            1983 |     1 |\n|  301 | Spizella     | pallida          |            1981 |     1 |\n|  307 | Spizella     | pallida          |            1994 |     1 |\n|  309 | Setophaga    | petechia         |            1989 |     1 |\n|  311 | Vermivora    | cyanoptera       |            1987 |     1 |\n|  313 | Cistothorus  | platensis        |            2008 |     1 |\n|  317 | Troglodytes  | aedon            |            1981 |     1 |\n|  326 | Setophaga    | caerulescens     |            2001 |     1 |\n|  327 | Vermivora    | chrysoptera      |            2009 |     1 |\n|  336 | Melospiza    | melodia          |            1978 |     1 |\n|  348 | Contopus     | virens           |            1980 |     1 |\n|  353 | Setophaga    | americana        |            1998 |     1 |\n|  363 | Empidonax    | flaviventris     |            2010 |     1 |\n|  365 | Ammodramus   | leconteii        |            2014 |     1 |\n|  396 | Sturnella    | magna            |            2009 |     1 |\n|  406 | Polioptila   | caerulea         |            2010 |     1 |\n|  407 | Ammodramus   | nelsoni          |            2015 |     1 |\n| 1026 | Tyrannus     | tyrannus         |            2009 |     1 |\n| 1036 | Setophaga    | virens           |            1978 |     1 |\n| 1042 | Vireo        | philadelphicus   |            2009 |     1 |\n| 1701 | Ammodramus   | leconteii        |            2002 |     1 |\n| 1666 | Icteria      | virens           |            1984 |     1 |\n| 1667 | Vermivora    | chrysoptera      |            1982 |     1 |\n| 1675 | Toxostoma    | rufum            |            1989 |     1 |\n| 1682 | Icterus      | galbula          |            1983 |     1 |\n| 1686 | Mniotilta    | varia            |            1984 |     1 |\n| 1687 | Spizella     | pallida          |            1995 |     1 |\n| 1694 | Cistothorus  | platensis        |            2015 |     1 |\n| 1695 | Polioptila   | caerulea         |            1998 |     1 |\n| 1706 | Vireo        | flavifrons       |            2015 |     1 |\n| 1653 | Pipilo       | erythrophthalmus |            2001 |     1 |\n| 1714 | Pipilo       | erythrophthalmus |            1986 |     1 |\n| 1722 | Vireo        | solitarius       |            2014 |     1 |\n| 1738 | Mniotilta    | varia            |            1990 |     1 |\n| 1743 | Pipilo       | erythrophthalmus |            2012 |     1 |\n| 1753 | Zonotrichia  | querula          |            2007 |     1 |\n| 1777 | Ammodramus   | savannarum       |            1997 |     1 |\n| 1779 | Parkesia     | motacilla        |            1986 |     1 |\n| 1788 | Myiarchus    | crinitus         |            1985 |     1 |\n| 1661 | Cistothorus  | platensis        |            1985 |     1 |\n| 1645 | Piranga      | rubra            |            2008 |     1 |\n| 1044 | Icterus      | galbula          |            1991 |     1 |\n| 1561 | Vireo        | flavifrons       |            2006 |     1 |\n| 1498 | Vermivora    | chrysoptera      |            1981 |     1 |\n| 1523 | Cardellina   | canadensis       |            2000 |     1 |\n| 1526 | Setophaga    | tigrina          |            1978 |     1 |\n| 1535 | Ammodramus   | henslowii        |            1986 |     1 |\n| 1544 | Parkesia     | motacilla        |            2006 |     1 |\n| 1546 | Setophaga    | citrina          |            1980 |     1 |\n| 1548 | Oreothlypis  | celata           |            1981 |     1 |\n| 1550 | Catharus     | ustulatus        |            1978 |     1 |\n| 1566 | Spizella     | passerina        |            1987 |     1 |\n| 1641 | Icteria      | virens           |            1998 |     1 |\n| 1570 | Ammodramus   | henslowii        |            1988 |     1 |\n| 1573 | Empidonax    | virescens        |            1985 |     1 |\n| 1592 | Empidonax    | minimus          |            1985 |     1 |\n| 1594 | Vermivora    | chrysoptera      |            2003 |     1 |\n| 1611 | Vireo        | solitarius       |            2007 |     1 |\n| 1620 | Spizella     | pusilla          |            2011 |     1 |\n| 1624 | Setophaga    | virens           |            1997 |     1 |\n| 1638 | Spizella     | pallida          |            1989 |     1 |\n| 1789 | Ammodramus   | henslowii        |            2012 |     1 |\n| 1800 | Cistothorus  | palustris        |            2000 |     1 |\n| 1802 | Troglodytes  | aedon            |            1989 |     1 |\n| 2012 | Lanius       | excubitor        |            2006 |     1 |\n| 1961 | Setophaga    | petechia         |            1985 |     1 |\n| 1962 | Setophaga    | fusca            |            2002 |     1 |\n| 1964 | Setophaga    | americana        |            1984 |     1 |\n| 1973 | Tyrannus     | tyrannus         |            2012 |     1 |\n| 1983 | Vireo        | solitarius       |            1994 |     1 |\n| 1989 | Ammodramus   | leconteii        |            1984 |     1 |\n| 1993 | Setophaga    | caerulescens     |            1986 |     1 |\n| 2003 | Passerculus  | sandwichensis    |            1981 |     1 |\n| 2013 | Ammodramus   | leconteii        |            1983 |     1 |\n| 1805 | Icterus      | galbula          |            2006 |     1 |\n| 2033 | Empidonax    | flaviventris     |            2006 |     1 |\n| 2038 | Setophaga    | castanea         |            1989 |     1 |\n| 2048 | Vermivora    | chrysoptera      |            1986 |     1 |\n| 2050 | Spizella     | pallida          |            1987 |     1 |\n| 2054 | Passerculus  | sandwichensis    |            1979 |     1 |\n| 2065 | Setophaga    | tigrina          |            1986 |     1 |\n| 2069 | Regulus      | calendula        |            1987 |     1 |\n| 2070 | Ammodramus   | leconteii        |            2004 |     1 |\n| 1933 | Polioptila   | caerulea         |            1983 |     1 |\n| 1929 | Vireo        | solitarius       |            2015 |     1 |\n| 1912 | Setophaga    | petechia         |            1995 |     1 |\n| 1907 | Sayornis     | phoebe           |            2015 |     1 |\n| 1818 | Setophaga    | citrina          |            1997 |     1 |\n| 1822 | Vermivora    | chrysoptera      |            1999 |     1 |\n| 1825 | Setophaga    | americana        |            1995 |     1 |\n| 1832 | Oreothlypis  | celata           |            1986 |     1 |\n| 1835 | Ammodramus   | nelsoni          |            2010 |     1 |\n| 1836 | Spizelloides | arborea          |            1980 |     1 |\n| 1837 | Icterus      | spurius          |            1999 |     1 |\n| 1847 | Protonotaria | citrea           |            2011 |     1 |\n| 1858 | Troglodytes  | aedon            |            1995 |     1 |\n| 1865 | Myiarchus    | crinitus         |            2006 |     1 |\n| 1868 | Vermivora    | cyanoptera       |            2002 |     1 |\n| 1893 | Geothlypis   | formosa          |            2001 |     1 |\n| 1895 | Icterus      | galbula          |            1982 |     1 |\n| 1897 | Vireo        | flavifrons       |            2014 |     1 |\n| 1898 | Spizella     | pallida          |            1979 |     1 |\n| 1899 | Troglodytes  | aedon            |            1979 |     1 |\n| 1900 | Toxostoma    | rufum            |            2001 |     1 |\n| 1497 | Icteria      | virens           |            1991 |     1 |\n| 1495 | Troglodytes  | aedon            |            2003 |     1 |\n| 1493 | Piranga      | olivacea         |            1981 |     1 |\n| 1189 | Icterus      | galbula          |            1992 |     1 |\n| 1138 | Ammodramus   | henslowii        |            2005 |     1 |\n| 1160 | Vireo        | gilvus           |            1996 |     1 |\n| 1163 | Sturnella    | magna            |            2013 |     1 |\n| 1173 | Cistothorus  | platensis        |            1999 |     1 |\n| 1174 | Toxostoma    | rufum            |            1979 |     1 |\n| 1182 | Icterus      | spurius          |            2008 |     1 |\n| 1186 | Ammodramus   | henslowii        |            2015 |     1 |\n| 1188 | Cistothorus  | platensis        |            1982 |     1 |\n| 1193 | Geothlypis   | formosa          |            1983 |     1 |\n| 1237 | Icteria      | virens           |            2001 |     1 |\n| 1195 | Spizella     | passerina        |            1989 |     1 |\n| 1214 | Polioptila   | caerulea         |            2008 |     1 |\n| 1216 | Ammodramus   | nelsoni          |            2013 |     1 |\n| 1220 | Empidonax    | flaviventris     |            2004 |     1 |\n| 1222 | Cistothorus  | platensis        |            1989 |     1 |\n| 1223 | Pipilo       | erythrophthalmus |            2016 |     1 |\n| 1226 | Hylocichla   | mustelina        |            1978 |     1 |\n| 1230 | Icteria      | virens           |            1982 |     1 |\n| 1135 | Troglodytes  | aedon            |            1983 |     1 |\n| 1123 | Setophaga    | castanea         |            1979 |     1 |\n| 1115 | Cistothorus  | palustris        |            2011 |     1 |\n| 1112 | Vermivora    | chrysoptera      |            1989 |     1 |\n| 1045 | Setophaga    | caerulescens     |            1991 |     1 |\n| 1047 | Contopus     | virens           |            1990 |     1 |\n| 1050 | Empidonax    | minimus          |            2001 |     1 |\n| 1052 | Vireo        | flavifrons       |            2012 |     1 |\n| 1055 | Passerina    | caerulea         |            1991 |     1 |\n| 1056 | Oreothlypis  | celata           |            1990 |     1 |\n| 1062 | Spizella     | pallida          |            1990 |     1 |\n| 1068 | Parkesia     | motacilla        |            1996 |     1 |\n| 1075 | Setophaga    | tigrina          |            1999 |     1 |\n| 1077 | Ammodramus   | leconteii        |            2005 |     1 |\n| 1083 | Spizella     | passerina        |            2002 |     1 |\n| 1084 | Cistothorus  | palustris        |            1985 |     1 |\n| 1086 | Cardellina   | canadensis       |            1978 |     1 |\n| 1087 | Pipilo       | erythrophthalmus |            1991 |     1 |\n| 1105 | Contopus     | virens           |            2012 |     1 |\n| 1108 | Ammodramus   | savannarum       |            2016 |     1 |\n| 1109 | Myiarchus    | crinitus         |            2010 |     1 |\n| 1231 | Setophaga    | cerulea          |            2014 |     1 |\n| 1271 | Vermivora    | cyanoptera       |            1992 |     1 |\n| 1491 | Spizella     | passerina        |            1997 |     1 |\n| 1423 | Setophaga    | fusca            |            1986 |     1 |\n| 1392 | Setophaga    | americana        |            1999 |     1 |\n| 1403 | Empidonax    | flaviventris     |            2005 |     1 |\n| 1404 | Setophaga    | virens           |            2001 |     1 |\n| 1410 | Mniotilta    | varia            |            1998 |     1 |\n| 1415 | Empidonax    | flaviventris     |            1992 |     1 |\n| 1417 | Setophaga    | caerulescens     |            1989 |     1 |\n| 1419 | Toxostoma    | rufum            |            1982 |     1 |\n| 1422 | Troglodytes  | aedon            |            2016 |     1 |\n| 1450 | Vermivora    | cyanoptera       |            1993 |     1 |\n| 1280 | Ammodramus   | leconteii        |            1979 |     1 |\n| 1459 | Toxostoma    | rufum            |            1988 |     1 |\n| 1460 | Vireo        | olivaceus        |            1992 |     1 |\n| 1470 | Setophaga    | pensylvanica     |            1979 |     1 |\n| 1474 | Cardellina   | pusilla          |            1985 |     1 |\n| 1477 | Vireo        | flavifrons       |            1995 |     1 |\n| 1482 | Cardellina   | canadensis       |            1994 |     1 |\n| 1483 | Spizella     | pusilla          |            2012 |     1 |\n| 1486 | Ammodramus   | leconteii        |            1994 |     1 |\n| 1390 | Vermivora    | chrysoptera      |            1995 |     1 |\n| 1387 | Setophaga    | pensylvanica     |            2003 |     1 |\n| 1386 | Icterus      | galbula          |            1999 |     1 |\n| 1374 | Cistothorus  | palustris        |            1999 |     1 |\n| 1283 | Vireo        | olivaceus        |            1991 |     1 |\n| 1285 | Ammodramus   | leconteii        |            2006 |     1 |\n| 1304 | Icteria      | virens           |            1990 |     1 |\n| 1307 | Spizella     | pallida          |            2002 |     1 |\n| 1310 | Setophaga    | citrina          |            2013 |     1 |\n| 1316 | Troglodytes  | aedon            |            2004 |     1 |\n| 1322 | Setophaga    | castanea         |            1978 |     1 |\n| 1323 | Vireo        | philadelphicus   |            2012 |     1 |\n| 1328 | Sitta        | canadensis       |            1983 |     1 |\n| 1335 | Vireo        | olivaceus        |            1985 |     1 |\n| 1342 | Setophaga    | fusca            |            2001 |     1 |\n| 1350 | Cardellina   | pusilla          |            1981 |     1 |\n| 1363 | Geothlypis   | formosa          |            1982 |     1 |\n| 1364 | Ammodramus   | savannarum       |            1981 |     1 |\n| 1366 | Ammodramus   | leconteii        |            1987 |     1 |\n| 1367 | Piranga      | olivacea         |            2005 |     1 |\n| 1373 | Spizella     | passerina        |            1988 |     1 |\n| 1212 | Setophaga    | fusca            |            1989 |     1 |\n<\/pre>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n
\n
\n
\n<\/div>\n
\n<\/div>
\n
Insights:<\/b> As you can see in the data table above, we see that birds of the  Zonotrichia albicollis <\/b> species (White-throated sparrow) are the ones that were most affected in any given year i.e., they had the  highest collisions in a specific year  since the data tracking was being done. This is followed by Seiurus aurocapilla (ovenbird). Atleast  400-500 birds have been killed every year <\/b>.<\/b><\/b><\/p>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n
\n
\n
\n<\/div>\n
\n<\/div>
\n
\"No<\/div>\n
 Melospiza Lincolnii (Lincoln's Sparrows)<\/center>\n
 Image Courtesy:  Joshua J. Cotten <\/a> and  Tyler Moulton\n<\/a> on Unsplash <\/center>\n<\/div>\n<\/div>\n<\/div>\n<\/div>
\n
\n
\n<\/div>\n
\n
In\u00a0[224]:<\/div>\n
\n
\n
<\/span>Chicago_Collision_Incidents<\/span>\n<\/pre><\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n
\n
\n<\/div>\n
\n
\n
Out[224]:<\/div>\n
\n
\n