ORANGE — people with resolved birth & death places

birth

{"title": "Birth date", "description": "Original birth date value from ORANGE/Wikidata."}

birth_place_choice_reason

{"title": "Birth choice reason", "description": "Resolver reason code or human-readable note explaining why a particular birth place candidate was chosen (e.g., 'ORANGE_MATCH_OK', 'ORANGE_MATCH_FAR', 'FALLBACK_FIRST_WITH_COORDS')."}

birth_place_lat

{"title": "Birth latitude", "description": "Latitude (decimal degrees) for the chosen birth place.", "type": "number"}

birth_place_lon

{"title": "Birth longitude", "description": "Longitude (decimal degrees) for the chosen birth place.", "type": "number"}

birth_place_readable

{"title": "Birth place (readable)", "description": "Human-readable place label chosen for birthplace (cleaned/normalized)."}

birth_place_readable_raw

{"title": "Birth place (raw)", "description": "Original raw readable value preserved (pre-cleaning). May be empty if not preserved for this import."}

birth_place_source

{"title": "Birth place source", "description": "Provenance token describing how the birth place was selected. Examples: 'WIKIDATA_PRIMARY' (primary Wikidata mapping), 'RESOLVED' (resolver fallback)."}

death

{"title": "Death date", "description": "Original death date value from ORANGE/Wikidata."}

death_place_choice_reason

{"title": "Death choice reason", "description": "Resolver reason code explaining why a particular death place candidate was chosen."}

death_place_lat

{"title": "Death latitude", "description": "Latitude (decimal degrees) for the chosen death place.", "type": "number"}

death_place_lon

{"title": "Death longitude", "description": "Longitude (decimal degrees) for the chosen death place.", "type": "number"}

death_place_readable

{"title": "Death place (readable)", "description": "Human-readable place label chosen for deathplace (cleaned/normalized)."}

death_place_readable_raw

{"title": "Death place (raw)", "description": "Original raw readable value preserved (pre-cleaning). May be empty if not preserved for this import."}

death_place_source

{"title": "Death place source", "description": "Provenance token describing how the death place was selected (e.g., 'WIKIDATA_PRIMARY', 'RESOLVED')."}

name

{"title": "Name", "description": "Person's name (from ORANGE source)."}

wikidata_code

{"title": "Wikidata Q-code", "description": "Unique identifier linking this row to Wikidata (e.g., Q12345)."}

>10,000 rows count all

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: updated_death_date, approx_birth, approx_death, gender, level1_main_occ, un_subregion, bigperiod_birth_graph_b, bigperiod_death_graph_b, level2_main_occ, level2_second_occ, bigperiod_birth, bigperiod_death, non_missing_score, citizenship_2_b, area2_of_rattachment, un_region, group_wikipedia_editions, pantheon_1, birth_place_source, birth_place_choice_reason, death_place_source, death_place_choice_reason

Next page

CREATE TABLE "orange_places" (
"wikidata_code" TEXT,
  "birth" TEXT,
  "death" TEXT,
  "updated_death_date" TEXT,
  "approx_birth" TEXT,
  "approx_death" TEXT,
  "birth_min" TEXT,
  "birth_max" TEXT,
  "death_min" TEXT,
  "death_max" TEXT,
  "gender" TEXT,
  "level1_main_occ" TEXT,
  "name" TEXT,
  "un_subregion" TEXT,
  "birth_estimation" TEXT,
  "death_estimation" TEXT,
  "bigperiod_birth_graph_b" TEXT,
  "bigperiod_death_graph_b" TEXT,
  "curid" TEXT,
  "level2_main_occ" TEXT,
  "freq_main_occ" TEXT,
  "freq_second_occ" TEXT,
  "level2_second_occ" TEXT,
  "level3_main_occ" TEXT,
  "bigperiod_birth" TEXT,
  "bigperiod_death" TEXT,
  "wiki_readers_2015_2018" TEXT,
  "non_missing_score" TEXT,
  "total_count_words_b" TEXT,
  "number_wiki_editions" TEXT,
  "total_noccur_links_b" TEXT,
  "sum_visib_ln_5criteria" TEXT,
  "ranking_visib_5criteria" TEXT,
  "all_geography_groups" TEXT,
  "string_citizenship_raw_d" TEXT,
  "citizenship_1_b" TEXT,
  "citizenship_2_b" TEXT,
  "list_areas_of_rattach" TEXT,
  "area1_of_rattachment" TEXT,
  "area2_of_rattachment" TEXT,
  "list_wikipedia_editions" TEXT,
  "un_region" TEXT,
  "group_wikipedia_editions" TEXT,
  "bplo1" TEXT,
  "dplo1" TEXT,
  "bpla1" TEXT,
  "dpla1" TEXT,
  "pantheon_1" TEXT,
  "level3_all_occ" TEXT,
  "birth_place_readable" TEXT,
  "birth_place_lat" TEXT,
  "birth_place_lon" TEXT,
  "birth_place_source" TEXT,
  "birth_place_choice_reason" TEXT,
  "death_place_readable" TEXT,
  "death_place_lat" TEXT,
  "death_place_lon" TEXT,
  "death_place_source" TEXT,
  "death_place_choice_reason" TEXT
, "birth_place_readable_raw" TEXT, "death_place_readable_raw" TEXT, born_died_distance_km REAL, ddg_search_url TEXT);
CREATE INDEX "idx_orange_places_qid" ON "orange_places"("qid");
CREATE INDEX "idx_orange_places_birth_place_match_quality" ON "orange_places"("birth_place_match_quality");
CREATE INDEX "idx_orange_places_death_place_match_quality" ON "orange_places"("death_place_match_quality");
CREATE INDEX idx_orange_wikidata_code ON orange_places(wikidata_code);
CREATE INDEX idx_orange_birth_coords ON orange_places(birth_place_lat, birth_place_lon);
CREATE INDEX idx_orange_death_coords ON orange_places(death_place_lat, death_place_lon);