data
Tables
noaa_stations
stationId, lat, lon, refStationId, stationType, parentGeoGroupId, seq, geoGroupId, geoGroupName, level, geoGroupType, abbrev, good
208 rows
observations
place, taxon, quality_grade, time_observed_at, taxon_geoprivacy, annotations, uuid, observed_on_details, id, cached_votes_total, identifications_most_agree, created_at_details, species_guess, identifications_most_disagree, tags, positional_accuracy, comments_count, site_id, created_time_zone, license_code, observed_time_zone, quality_metrics, public_positional_accuracy, reviewed_by, oauth_application_id, flags, created_at, description, time_zone_offset, project_ids_with_curator_id, observed_on, observed_on_string, updated_at, sounds, place_ids, captive, ident_taxon_ids, outlinks, faves_count, ofvs, num_identification_agreements, preferences, comments, map_scale, uri, project_ids, community_taxon_id, geojson, owners_identification_from_vision, identifications_count, obscured, num_identification_disagreements, geoprivacy, location, votes, spam, user, mappable, identifications_some_agree, project_ids_without_curator_id, place_guess, identifications, project_observations, observation_photos, photos, faves, non_owner_ids
210 rows
places
airtable_createdTime, airtable_id, area, body, country_slug, latitude, longitude, name, region, slug, time_zone, website_url, directions_to_tidepools, address, bathroom_info, bathrooms, header_credit, header_image, parking, temp_reference, managment, open_to_public, phone, visitor_center, cost, hours, directions_latitude, directions_longitude, docents, dogs, food_options, rules_and_collecting, groups, accessibility_and_safety, live_on_site, natalie_visited, pet_policy, radius_km, rules_and_collecting_url, station_id, tagline, tidepool_height, variance_ft, wikipedia, other_names, picnic_options, header_credit_url, official_open, docent_info, webcam_url
64 rows
taxons
id, rank, rank_level, iconic_taxon_id, ancestor_ids, is_active, name, parent_id, ancestry, extinct, default_photo, taxon_changes_count, taxon_schemes_count, observations_count, flag_counts, current_synonymous_taxon_ids, atlas_id, complete_species_count, wikipedia_url, iconic_taxon_name, preferred_common_name, complete_rank, conservation_status, min_species_ancestry, endemic, min_species_taxon_id, threatened, introduced, native, created_at, photos_locked, universal_search_rank
1,116 rows
Views
Download SQLite DB: data.db 43.5 MB