Schema for wikipedia_data

CREATE TABLE data ("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, "name" TEXT, "birth_estimation" TEXT, "death_estimation" TEXT, "bigperiod_birth_graph_b" TEXT, "bigperiod_death_graph_b" TEXT, "curid" 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, "string_citizenship_raw_d" TEXT, "list_wikipedia_editions" TEXT, "group_wikipedia_editions" TEXT, "bplo1" TEXT, "dplo1" TEXT, "bpla1" TEXT, "dpla1" TEXT, "pantheon_1" TEXT, "Exhaustive_level1_main_occ" TEXT, "Exhaustive_level2_main_occ" TEXT, "Exhaustive_level2_second_occ" TEXT, "Exhaustive_citizenship_1_b" TEXT, "Exhaustive_citizenship_2_b" TEXT, "Exhaustive_area1_of_rattachment" TEXT, "Exhaustive_area2_of_rattachment" TEXT, ddg_search_url TEXT);
CREATE VIRTUAL TABLE [data_fts] USING FTS5 (
    [name], [level1_main_occ], [level2_main_occ], [level3_main_occ], [wikidata_code], [un_region], [un_subregion], [citizenship_1_b], [citizenship_2_b],
    content=[data]
);
CREATE TABLE 'data_fts_data'(id INTEGER PRIMARY KEY, block BLOB);
CREATE TABLE 'data_fts_idx'(segid, term, pgno, PRIMARY KEY(segid, term)) WITHOUT ROWID;
CREATE TABLE 'data_fts_docsize'(id INTEGER PRIMARY KEY, sz BLOB);
CREATE TABLE 'data_fts_config'(k PRIMARY KEY, v) WITHOUT ROWID