data

Custom SQL query

noaa_stations

stationId, lat, lon, refStationId, stationType, parentGeoGroupId, seq, geoGroupId, geoGroupName...

207 rows

observations

place, taxon, quality_grade, time_observed_at, taxon_geoprivacy, annotations, uuid, observed_on_details, id...

180 rows

places

airtable_createdTime, airtable_id, area, body, country_slug, latitude, longitude, name, region...

64 rows

species_counts

place, taxon, count

1,462 rows

stations

id, name, latitude, longitude

2 rows

sunrise_sunset

place, day, dawn, sunrise, noon, sunset, dusk

198 rows

taxons

observations_count, taxon_schemes_count, ancestry, is_active, flag_counts, wikipedia_url, current_synonymous_taxon_ids, iconic_taxon_id, rank_level...

800 rows

tide_predictions

station_id, datetime, mllw_feet

31,680 rows

Views

Download SQLite DB: data.db 13.8 MB

Powered by Datasette · Query took 12.702ms