ebird.int_observations_by_h3_day

eBird observations rolled up to H3 cell x species x observation_date. H3 resolution 6 (~36 km^2 hex). Feeds analytics.fct_species_environment_daily.

Overview

Field	Value
Schema	ebird
Name	int_observations_by_h3_day
Kind	FULL
Soda contract	none

Columns

Column	Type	Checks	Notes
common_name	UNKNOWN	—	—
h3_cell	UNKNOWN	—	—
last_loaded_at	UNKNOWN	—	—
n_checklists	BIGINT	—	—
n_notable_observations	BIGINT	—	—
n_observations	BIGINT	—	—
observation_date	UNKNOWN	—	—
scientific_name	UNKNOWN	—	—
species_code	UNKNOWN	—	—
total_birds_counted	UNKNOWN	—	—

Lineage

Upstream

• ebird_staging.stg_ebird_observations

Downstream

• analytics.fct_species_environment_daily
• noaa.int_weather_by_h3_day
• usgs.int_streamflow_by_h3_day

Example query

SELECT * FROM ebird.int_observations_by_h3_day LIMIT 100;