home / data

Menu
  • GraphQL API

observations

Table actions
  • GraphQL API for observations

0 rows where taxon = 3839

✎ View and edit SQL

This data as json

0 records

CREATE TABLE [observations] (
   [place] TEXT REFERENCES [places]([slug]),
   [taxon] INTEGER REFERENCES [taxons]([id]),
   [quality_grade] TEXT,
   [time_observed_at] TEXT,
   [taxon_geoprivacy] TEXT,
   [annotations] TEXT,
   [uuid] TEXT,
   [observed_on_details] TEXT,
   [id] INTEGER PRIMARY KEY,
   [cached_votes_total] INTEGER,
   [identifications_most_agree] INTEGER,
   [created_at_details] TEXT,
   [species_guess] TEXT,
   [identifications_most_disagree] INTEGER,
   [tags] TEXT,
   [positional_accuracy] INTEGER,
   [comments_count] INTEGER,
   [site_id] INTEGER,
   [created_time_zone] TEXT,
   [license_code] TEXT,
   [observed_time_zone] TEXT,
   [quality_metrics] TEXT,
   [public_positional_accuracy] INTEGER,
   [reviewed_by] TEXT,
   [oauth_application_id] INTEGER,
   [flags] TEXT,
   [created_at] TEXT,
   [description] TEXT,
   [time_zone_offset] TEXT,
   [project_ids_with_curator_id] TEXT,
   [observed_on] TEXT,
   [observed_on_string] TEXT,
   [updated_at] TEXT,
   [sounds] TEXT,
   [place_ids] TEXT,
   [captive] INTEGER,
   [ident_taxon_ids] TEXT,
   [outlinks] TEXT,
   [faves_count] INTEGER,
   [ofvs] TEXT,
   [num_identification_agreements] INTEGER,
   [preferences] TEXT,
   [comments] TEXT,
   [map_scale] TEXT,
   [uri] TEXT,
   [project_ids] TEXT,
   [community_taxon_id] INTEGER,
   [geojson] TEXT,
   [owners_identification_from_vision] INTEGER,
   [identifications_count] INTEGER,
   [obscured] INTEGER,
   [num_identification_disagreements] INTEGER,
   [geoprivacy] TEXT,
   [location] TEXT,
   [votes] TEXT,
   [spam] INTEGER,
   [user] TEXT,
   [mappable] INTEGER,
   [identifications_some_agree] INTEGER,
   [project_ids_without_curator_id] TEXT,
   [place_guess] TEXT,
   [identifications] TEXT,
   [project_observations] TEXT,
   [observation_photos] TEXT,
   [photos] TEXT,
   [faves] TEXT,
   [non_owner_ids] TEXT
);
Powered by Datasette · Queries took 146.44ms