home / gorongosa

aggregations

1 row where num_classifications = 24 and subject_id = 853124

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ the_geom maximum_number_of_animals subject_id num_classifications pielou_score species percentage_of_votes_for_species number_of_votes_for_species minimum_number_of_animals most_likely_number_of_animals percentage cartodb_id percentage_behaviour_resting percentage_behaviour_standing percentage_behaviour_moving percentage_behaviour_eating percentage_behaviour_interacting most_likely_are_there_any_young_present percentage_are_there_any_young_presentyes percentage_are_there_any_young_presentno most_likely_do_you_see_any_horns percentage_do_you_see_any_hornsyes percentage_do_you_see_any_hornsno
98058 98058   3 853124 24 0.560698787621 Impala 0.791666666667 19 1 1 0.5 100868 0.0 0.0526315789474 0.0526315789474 0.0 0.0 1 0.5 0 0.0 0 1.0

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE "aggregations" (
"the_geom" INTEGER,
  "maximum_number_of_animals" TEXT,
  "subject_id" INTEGER,
  "num_classifications" INTEGER,
  "pielou_score" REAL,
  "species" TEXT,
  "percentage_of_votes_for_species" REAL,
  "number_of_votes_for_species" INTEGER,
  "minimum_number_of_animals" TEXT,
  "most_likely_number_of_animals" TEXT,
  "percentage" REAL,
  "cartodb_id" INTEGER,
  "percentage_behaviour_resting" REAL,
  "percentage_behaviour_standing" REAL,
  "percentage_behaviour_moving" REAL,
  "percentage_behaviour_eating" REAL,
  "percentage_behaviour_interacting" REAL,
  "most_likely_are_there_any_young_present" TEXT,
  "percentage_are_there_any_young_presentyes" REAL,
  "percentage_are_there_any_young_presentno" TEXT,
  "most_likely_do_you_see_any_horns" REAL,
  "percentage_do_you_see_any_hornsyes" TEXT,
  "percentage_do_you_see_any_hornsno" REAL
);
Powered by Datasette · Queries took 5291.472ms