Mental Health Support Feature Analysis
Correlating Text Features and Mental Health Indicators
@kaggle.thedevastator_mental_health_support_feature_analysis
Correlating Text Features and Mental Health Indicators
@kaggle.thedevastator_mental_health_support_feature_analysis
CREATE TABLE addiction_2018_features_tfidf_256 (
"subreddit" VARCHAR,
"author" VARCHAR,
"date" VARCHAR,
"post" VARCHAR,
"automated_readability_index" DOUBLE,
"coleman_liau_index" DOUBLE,
"flesch_kincaid_grade_level" DOUBLE,
"flesch_reading_ease" DOUBLE,
"gulpease_index" DOUBLE,
"gunning_fog_index" DOUBLE,
"lix" DOUBLE,
"smog_index" DOUBLE,
"wiener_sachtextformel" DOUBLE,
"n_chars" BIGINT,
"n_long_words" BIGINT,
"n_monosyllable_words" BIGINT,
"n_polysyllable_words" BIGINT,
"n_sents" BIGINT,
"n_syllables" BIGINT,
"n_unique_words" BIGINT,
"n_words" BIGINT,
"sent_neg" DOUBLE,
"sent_neu" DOUBLE,
"sent_pos" DOUBLE,
"sent_compound" DOUBLE,
"economic_stress_total" BIGINT,
"isolation_total" BIGINT,
"substance_use_total" BIGINT,
"guns_total" BIGINT,
"domestic_stress_total" BIGINT,
"suicidality_total" BIGINT,
"punctuation" DOUBLE,
"liwc_1st_pers" BIGINT,
"liwc_2nd_pers" BIGINT,
"liwc_3rd_pers" BIGINT,
"liwc_achievement" BIGINT,
"liwc_adverbs" BIGINT,
"liwc_affective_processes" BIGINT,
"liwc_anger" BIGINT,
"liwc_anxiety" BIGINT,
"liwc_articles_article" BIGINT,
"liwc_assent" BIGINT,
"liwc_auxiliary_verbs" BIGINT,
"liwc_biological" BIGINT,
"liwc_body" BIGINT,
"liwc_causation" BIGINT,
"liwc_certainty" BIGINT,
"liwc_cognitive" BIGINT,
"liwc_common_verbs" BIGINT,
"liwc_conjunctions" BIGINT,
"liwc_death" BIGINT,
"liwc_discrepancy" BIGINT,
"liwc_exclusive" BIGINT,
"liwc_family" BIGINT,
"liwc_feel" BIGINT,
"liwc_fillers" BIGINT,
"liwc_friends" BIGINT,
"liwc_future_tense" BIGINT,
"liwc_health" BIGINT,
"liwc_hear" BIGINT,
"liwc_home" BIGINT,
"liwc_humans" BIGINT,
"liwc_impersonal_pronouns" BIGINT,
"liwc_inclusive" BIGINT,
"liwc_ingestion" BIGINT,
"liwc_inhibition" BIGINT,
"liwc_insight" BIGINT,
"liwc_leisure" BIGINT,
"liwc_money" BIGINT,
"liwc_motion" BIGINT,
"liwc_negations" BIGINT,
"liwc_negative_emotion" BIGINT,
"liwc_nonfluencies" BIGINT,
"liwc_numbers" BIGINT,
"liwc_past_tense" BIGINT,
"liwc_perceptual_processes" BIGINT,
"liwc_personal_pronouns" BIGINT,
"liwc_positive_emotion" BIGINT,
"liwc_prepositions" BIGINT,
"liwc_present_tense" BIGINT,
"liwc_quantifiers" BIGINT,
"liwc_relativity" BIGINT,
"liwc_religion" BIGINT,
"liwc_sadness" BIGINT,
"liwc_see" BIGINT,
"liwc_sexual" BIGINT,
"liwc_social_processes" BIGINT,
"liwc_space" BIGINT,
"liwc_swear_words" BIGINT,
"liwc_tentative" BIGINT,
"liwc_time" BIGINT,
"liwc_total_functional" BIGINT,
"liwc_total_pronouns" BIGINT,
"liwc_work" BIGINT,
"tfidf_abl" DOUBLE,
"tfidf_abus" DOUBLE,
"tfidf_actual" DOUBLE,
"tfidf_addict" DOUBLE,
"tfidf_adhd" DOUBLE,
"tfidf_advic" DOUBLE
);
CREATE TABLE addiction_2019_features_tfidf_256 (
"subreddit" VARCHAR,
"author" VARCHAR,
"date" VARCHAR,
"post" VARCHAR,
"automated_readability_index" DOUBLE,
"coleman_liau_index" DOUBLE,
"flesch_kincaid_grade_level" DOUBLE,
"flesch_reading_ease" DOUBLE,
"gulpease_index" DOUBLE,
"gunning_fog_index" DOUBLE,
"lix" DOUBLE,
"smog_index" DOUBLE,
"wiener_sachtextformel" DOUBLE,
"n_chars" BIGINT,
"n_long_words" BIGINT,
"n_monosyllable_words" BIGINT,
"n_polysyllable_words" BIGINT,
"n_sents" BIGINT,
"n_syllables" BIGINT,
"n_unique_words" BIGINT,
"n_words" BIGINT,
"sent_neg" DOUBLE,
"sent_neu" DOUBLE,
"sent_pos" DOUBLE,
"sent_compound" DOUBLE,
"economic_stress_total" BIGINT,
"isolation_total" BIGINT,
"substance_use_total" BIGINT,
"guns_total" BIGINT,
"domestic_stress_total" BIGINT,
"suicidality_total" BIGINT,
"punctuation" DOUBLE,
"liwc_1st_pers" BIGINT,
"liwc_2nd_pers" BIGINT,
"liwc_3rd_pers" BIGINT,
"liwc_achievement" BIGINT,
"liwc_adverbs" BIGINT,
"liwc_affective_processes" BIGINT,
"liwc_anger" BIGINT,
"liwc_anxiety" BIGINT,
"liwc_articles_article" BIGINT,
"liwc_assent" BIGINT,
"liwc_auxiliary_verbs" BIGINT,
"liwc_biological" BIGINT,
"liwc_body" BIGINT,
"liwc_causation" BIGINT,
"liwc_certainty" BIGINT,
"liwc_cognitive" BIGINT,
"liwc_common_verbs" BIGINT,
"liwc_conjunctions" BIGINT,
"liwc_death" BIGINT,
"liwc_discrepancy" BIGINT,
"liwc_exclusive" BIGINT,
"liwc_family" BIGINT,
"liwc_feel" BIGINT,
"liwc_fillers" BIGINT,
"liwc_friends" BIGINT,
"liwc_future_tense" BIGINT,
"liwc_health" BIGINT,
"liwc_hear" BIGINT,
"liwc_home" BIGINT,
"liwc_humans" BIGINT,
"liwc_impersonal_pronouns" BIGINT,
"liwc_inclusive" BIGINT,
"liwc_ingestion" BIGINT,
"liwc_inhibition" BIGINT,
"liwc_insight" BIGINT,
"liwc_leisure" BIGINT,
"liwc_money" BIGINT,
"liwc_motion" BIGINT,
"liwc_negations" BIGINT,
"liwc_negative_emotion" BIGINT,
"liwc_nonfluencies" BIGINT,
"liwc_numbers" BIGINT,
"liwc_past_tense" BIGINT,
"liwc_perceptual_processes" BIGINT,
"liwc_personal_pronouns" BIGINT,
"liwc_positive_emotion" BIGINT,
"liwc_prepositions" BIGINT,
"liwc_present_tense" BIGINT,
"liwc_quantifiers" BIGINT,
"liwc_relativity" BIGINT,
"liwc_religion" BIGINT,
"liwc_sadness" BIGINT,
"liwc_see" BIGINT,
"liwc_sexual" BIGINT,
"liwc_social_processes" BIGINT,
"liwc_space" BIGINT,
"liwc_swear_words" BIGINT,
"liwc_tentative" BIGINT,
"liwc_time" BIGINT,
"liwc_total_functional" BIGINT,
"liwc_total_pronouns" BIGINT,
"liwc_work" BIGINT,
"tfidf_abl" DOUBLE,
"tfidf_abus" DOUBLE,
"tfidf_actual" DOUBLE,
"tfidf_addict" DOUBLE,
"tfidf_adhd" DOUBLE,
"tfidf_advic" DOUBLE
);
CREATE TABLE addiction_post_features_tfidf_256 (
"subreddit" VARCHAR,
"author" VARCHAR,
"date" VARCHAR,
"post" VARCHAR,
"automated_readability_index" DOUBLE,
"coleman_liau_index" DOUBLE,
"flesch_kincaid_grade_level" DOUBLE,
"flesch_reading_ease" DOUBLE,
"gulpease_index" DOUBLE,
"gunning_fog_index" DOUBLE,
"lix" DOUBLE,
"smog_index" DOUBLE,
"wiener_sachtextformel" DOUBLE,
"n_chars" BIGINT,
"n_long_words" BIGINT,
"n_monosyllable_words" BIGINT,
"n_polysyllable_words" BIGINT,
"n_sents" BIGINT,
"n_syllables" BIGINT,
"n_unique_words" BIGINT,
"n_words" BIGINT,
"sent_neg" DOUBLE,
"sent_neu" DOUBLE,
"sent_pos" DOUBLE,
"sent_compound" DOUBLE,
"economic_stress_total" BIGINT,
"isolation_total" BIGINT,
"substance_use_total" BIGINT,
"guns_total" BIGINT,
"domestic_stress_total" BIGINT,
"suicidality_total" BIGINT,
"punctuation" DOUBLE,
"liwc_1st_pers" BIGINT,
"liwc_2nd_pers" BIGINT,
"liwc_3rd_pers" BIGINT,
"liwc_achievement" BIGINT,
"liwc_adverbs" BIGINT,
"liwc_affective_processes" BIGINT,
"liwc_anger" BIGINT,
"liwc_anxiety" BIGINT,
"liwc_articles_article" BIGINT,
"liwc_assent" BIGINT,
"liwc_auxiliary_verbs" BIGINT,
"liwc_biological" BIGINT,
"liwc_body" BIGINT,
"liwc_causation" BIGINT,
"liwc_certainty" BIGINT,
"liwc_cognitive" BIGINT,
"liwc_common_verbs" BIGINT,
"liwc_conjunctions" BIGINT,
"liwc_death" BIGINT,
"liwc_discrepancy" BIGINT,
"liwc_exclusive" BIGINT,
"liwc_family" BIGINT,
"liwc_feel" BIGINT,
"liwc_fillers" BIGINT,
"liwc_friends" BIGINT,
"liwc_future_tense" BIGINT,
"liwc_health" BIGINT,
"liwc_hear" BIGINT,
"liwc_home" BIGINT,
"liwc_humans" BIGINT,
"liwc_impersonal_pronouns" BIGINT,
"liwc_inclusive" BIGINT,
"liwc_ingestion" BIGINT,
"liwc_inhibition" BIGINT,
"liwc_insight" BIGINT,
"liwc_leisure" BIGINT,
"liwc_money" BIGINT,
"liwc_motion" BIGINT,
"liwc_negations" BIGINT,
"liwc_negative_emotion" BIGINT,
"liwc_nonfluencies" BIGINT,
"liwc_numbers" BIGINT,
"liwc_past_tense" BIGINT,
"liwc_perceptual_processes" BIGINT,
"liwc_personal_pronouns" BIGINT,
"liwc_positive_emotion" BIGINT,
"liwc_prepositions" BIGINT,
"liwc_present_tense" BIGINT,
"liwc_quantifiers" BIGINT,
"liwc_relativity" BIGINT,
"liwc_religion" BIGINT,
"liwc_sadness" BIGINT,
"liwc_see" BIGINT,
"liwc_sexual" BIGINT,
"liwc_social_processes" BIGINT,
"liwc_space" BIGINT,
"liwc_swear_words" BIGINT,
"liwc_tentative" BIGINT,
"liwc_time" BIGINT,
"liwc_total_functional" BIGINT,
"liwc_total_pronouns" BIGINT,
"liwc_work" BIGINT,
"tfidf_abl" DOUBLE,
"tfidf_abus" DOUBLE,
"tfidf_actual" DOUBLE,
"tfidf_addict" DOUBLE,
"tfidf_adhd" DOUBLE,
"tfidf_advic" DOUBLE
);
CREATE TABLE addiction_pre_features_tfidf_256 (
"subreddit" VARCHAR,
"author" VARCHAR,
"date" VARCHAR,
"post" VARCHAR,
"automated_readability_index" DOUBLE,
"coleman_liau_index" DOUBLE,
"flesch_kincaid_grade_level" DOUBLE,
"flesch_reading_ease" DOUBLE,
"gulpease_index" DOUBLE,
"gunning_fog_index" DOUBLE,
"lix" DOUBLE,
"smog_index" DOUBLE,
"wiener_sachtextformel" DOUBLE,
"n_chars" BIGINT,
"n_long_words" BIGINT,
"n_monosyllable_words" BIGINT,
"n_polysyllable_words" BIGINT,
"n_sents" BIGINT,
"n_syllables" BIGINT,
"n_unique_words" BIGINT,
"n_words" BIGINT,
"sent_neg" DOUBLE,
"sent_neu" DOUBLE,
"sent_pos" DOUBLE,
"sent_compound" DOUBLE,
"economic_stress_total" BIGINT,
"isolation_total" BIGINT,
"substance_use_total" BIGINT,
"guns_total" BIGINT,
"domestic_stress_total" BIGINT,
"suicidality_total" BIGINT,
"punctuation" DOUBLE,
"liwc_1st_pers" BIGINT,
"liwc_2nd_pers" BIGINT,
"liwc_3rd_pers" BIGINT,
"liwc_achievement" BIGINT,
"liwc_adverbs" BIGINT,
"liwc_affective_processes" BIGINT,
"liwc_anger" BIGINT,
"liwc_anxiety" BIGINT,
"liwc_articles_article" BIGINT,
"liwc_assent" BIGINT,
"liwc_auxiliary_verbs" BIGINT,
"liwc_biological" BIGINT,
"liwc_body" BIGINT,
"liwc_causation" BIGINT,
"liwc_certainty" BIGINT,
"liwc_cognitive" BIGINT,
"liwc_common_verbs" BIGINT,
"liwc_conjunctions" BIGINT,
"liwc_death" BIGINT,
"liwc_discrepancy" BIGINT,
"liwc_exclusive" BIGINT,
"liwc_family" BIGINT,
"liwc_feel" BIGINT,
"liwc_fillers" BIGINT,
"liwc_friends" BIGINT,
"liwc_future_tense" BIGINT,
"liwc_health" BIGINT,
"liwc_hear" BIGINT,
"liwc_home" BIGINT,
"liwc_humans" BIGINT,
"liwc_impersonal_pronouns" BIGINT,
"liwc_inclusive" BIGINT,
"liwc_ingestion" BIGINT,
"liwc_inhibition" BIGINT,
"liwc_insight" BIGINT,
"liwc_leisure" BIGINT,
"liwc_money" BIGINT,
"liwc_motion" BIGINT,
"liwc_negations" BIGINT,
"liwc_negative_emotion" BIGINT,
"liwc_nonfluencies" BIGINT,
"liwc_numbers" BIGINT,
"liwc_past_tense" BIGINT,
"liwc_perceptual_processes" BIGINT,
"liwc_personal_pronouns" BIGINT,
"liwc_positive_emotion" BIGINT,
"liwc_prepositions" BIGINT,
"liwc_present_tense" BIGINT,
"liwc_quantifiers" BIGINT,
"liwc_relativity" BIGINT,
"liwc_religion" BIGINT,
"liwc_sadness" BIGINT,
"liwc_see" BIGINT,
"liwc_sexual" BIGINT,
"liwc_social_processes" BIGINT,
"liwc_space" BIGINT,
"liwc_swear_words" BIGINT,
"liwc_tentative" BIGINT,
"liwc_time" BIGINT,
"liwc_total_functional" BIGINT,
"liwc_total_pronouns" BIGINT,
"liwc_work" BIGINT,
"tfidf_abl" DOUBLE,
"tfidf_abus" DOUBLE,
"tfidf_actual" DOUBLE,
"tfidf_addict" DOUBLE,
"tfidf_adhd" DOUBLE,
"tfidf_advic" DOUBLE
);
CREATE TABLE adhd_2018_features_tfidf_256 (
"subreddit" VARCHAR,
"author" VARCHAR,
"date" VARCHAR,
"post" VARCHAR,
"automated_readability_index" DOUBLE,
"coleman_liau_index" DOUBLE,
"flesch_kincaid_grade_level" DOUBLE,
"flesch_reading_ease" DOUBLE,
"gulpease_index" DOUBLE,
"gunning_fog_index" DOUBLE,
"lix" DOUBLE,
"smog_index" DOUBLE,
"wiener_sachtextformel" DOUBLE,
"n_chars" BIGINT,
"n_long_words" BIGINT,
"n_monosyllable_words" BIGINT,
"n_polysyllable_words" BIGINT,
"n_sents" BIGINT,
"n_syllables" BIGINT,
"n_unique_words" BIGINT,
"n_words" BIGINT,
"sent_neg" DOUBLE,
"sent_neu" DOUBLE,
"sent_pos" DOUBLE,
"sent_compound" DOUBLE,
"economic_stress_total" BIGINT,
"isolation_total" BIGINT,
"substance_use_total" BIGINT,
"guns_total" BIGINT,
"domestic_stress_total" BIGINT,
"suicidality_total" BIGINT,
"punctuation" DOUBLE,
"liwc_1st_pers" BIGINT,
"liwc_2nd_pers" BIGINT,
"liwc_3rd_pers" BIGINT,
"liwc_achievement" BIGINT,
"liwc_adverbs" BIGINT,
"liwc_affective_processes" BIGINT,
"liwc_anger" BIGINT,
"liwc_anxiety" BIGINT,
"liwc_articles_article" BIGINT,
"liwc_assent" BIGINT,
"liwc_auxiliary_verbs" BIGINT,
"liwc_biological" BIGINT,
"liwc_body" BIGINT,
"liwc_causation" BIGINT,
"liwc_certainty" BIGINT,
"liwc_cognitive" BIGINT,
"liwc_common_verbs" BIGINT,
"liwc_conjunctions" BIGINT,
"liwc_death" BIGINT,
"liwc_discrepancy" BIGINT,
"liwc_exclusive" BIGINT,
"liwc_family" BIGINT,
"liwc_feel" BIGINT,
"liwc_fillers" BIGINT,
"liwc_friends" BIGINT,
"liwc_future_tense" BIGINT,
"liwc_health" BIGINT,
"liwc_hear" BIGINT,
"liwc_home" BIGINT,
"liwc_humans" BIGINT,
"liwc_impersonal_pronouns" BIGINT,
"liwc_inclusive" BIGINT,
"liwc_ingestion" BIGINT,
"liwc_inhibition" BIGINT,
"liwc_insight" BIGINT,
"liwc_leisure" BIGINT,
"liwc_money" BIGINT,
"liwc_motion" BIGINT,
"liwc_negations" BIGINT,
"liwc_negative_emotion" BIGINT,
"liwc_nonfluencies" BIGINT,
"liwc_numbers" BIGINT,
"liwc_past_tense" BIGINT,
"liwc_perceptual_processes" BIGINT,
"liwc_personal_pronouns" BIGINT,
"liwc_positive_emotion" BIGINT,
"liwc_prepositions" BIGINT,
"liwc_present_tense" BIGINT,
"liwc_quantifiers" BIGINT,
"liwc_relativity" BIGINT,
"liwc_religion" BIGINT,
"liwc_sadness" BIGINT,
"liwc_see" BIGINT,
"liwc_sexual" BIGINT,
"liwc_social_processes" BIGINT,
"liwc_space" BIGINT,
"liwc_swear_words" BIGINT,
"liwc_tentative" BIGINT,
"liwc_time" BIGINT,
"liwc_total_functional" BIGINT,
"liwc_total_pronouns" BIGINT,
"liwc_work" BIGINT,
"tfidf_abl" DOUBLE,
"tfidf_abus" DOUBLE,
"tfidf_actual" DOUBLE,
"tfidf_addict" DOUBLE,
"tfidf_adhd" DOUBLE,
"tfidf_advic" DOUBLE
);
CREATE TABLE adhd_2019_features_tfidf_256 (
"subreddit" VARCHAR,
"author" VARCHAR,
"date" VARCHAR,
"post" VARCHAR,
"automated_readability_index" DOUBLE,
"coleman_liau_index" DOUBLE,
"flesch_kincaid_grade_level" DOUBLE,
"flesch_reading_ease" DOUBLE,
"gulpease_index" DOUBLE,
"gunning_fog_index" DOUBLE,
"lix" DOUBLE,
"smog_index" DOUBLE,
"wiener_sachtextformel" DOUBLE,
"n_chars" BIGINT,
"n_long_words" BIGINT,
"n_monosyllable_words" BIGINT,
"n_polysyllable_words" BIGINT,
"n_sents" BIGINT,
"n_syllables" BIGINT,
"n_unique_words" BIGINT,
"n_words" BIGINT,
"sent_neg" DOUBLE,
"sent_neu" DOUBLE,
"sent_pos" DOUBLE,
"sent_compound" DOUBLE,
"economic_stress_total" BIGINT,
"isolation_total" BIGINT,
"substance_use_total" BIGINT,
"guns_total" BIGINT,
"domestic_stress_total" BIGINT,
"suicidality_total" BIGINT,
"punctuation" DOUBLE,
"liwc_1st_pers" BIGINT,
"liwc_2nd_pers" BIGINT,
"liwc_3rd_pers" BIGINT,
"liwc_achievement" BIGINT,
"liwc_adverbs" BIGINT,
"liwc_affective_processes" BIGINT,
"liwc_anger" BIGINT,
"liwc_anxiety" BIGINT,
"liwc_articles_article" BIGINT,
"liwc_assent" BIGINT,
"liwc_auxiliary_verbs" BIGINT,
"liwc_biological" BIGINT,
"liwc_body" BIGINT,
"liwc_causation" BIGINT,
"liwc_certainty" BIGINT,
"liwc_cognitive" BIGINT,
"liwc_common_verbs" BIGINT,
"liwc_conjunctions" BIGINT,
"liwc_death" BIGINT,
"liwc_discrepancy" BIGINT,
"liwc_exclusive" BIGINT,
"liwc_family" BIGINT,
"liwc_feel" BIGINT,
"liwc_fillers" BIGINT,
"liwc_friends" BIGINT,
"liwc_future_tense" BIGINT,
"liwc_health" BIGINT,
"liwc_hear" BIGINT,
"liwc_home" BIGINT,
"liwc_humans" BIGINT,
"liwc_impersonal_pronouns" BIGINT,
"liwc_inclusive" BIGINT,
"liwc_ingestion" BIGINT,
"liwc_inhibition" BIGINT,
"liwc_insight" BIGINT,
"liwc_leisure" BIGINT,
"liwc_money" BIGINT,
"liwc_motion" BIGINT,
"liwc_negations" BIGINT,
"liwc_negative_emotion" BIGINT,
"liwc_nonfluencies" BIGINT,
"liwc_numbers" BIGINT,
"liwc_past_tense" BIGINT,
"liwc_perceptual_processes" BIGINT,
"liwc_personal_pronouns" BIGINT,
"liwc_positive_emotion" BIGINT,
"liwc_prepositions" BIGINT,
"liwc_present_tense" BIGINT,
"liwc_quantifiers" BIGINT,
"liwc_relativity" BIGINT,
"liwc_religion" BIGINT,
"liwc_sadness" BIGINT,
"liwc_see" BIGINT,
"liwc_sexual" BIGINT,
"liwc_social_processes" BIGINT,
"liwc_space" BIGINT,
"liwc_swear_words" BIGINT,
"liwc_tentative" BIGINT,
"liwc_time" BIGINT,
"liwc_total_functional" BIGINT,
"liwc_total_pronouns" BIGINT,
"liwc_work" BIGINT,
"tfidf_abl" DOUBLE,
"tfidf_abus" DOUBLE,
"tfidf_actual" DOUBLE,
"tfidf_addict" DOUBLE,
"tfidf_adhd" DOUBLE,
"tfidf_advic" DOUBLE
);
CREATE TABLE adhd_post_features_tfidf_256 (
"subreddit" VARCHAR,
"author" VARCHAR,
"date" VARCHAR,
"post" VARCHAR,
"automated_readability_index" DOUBLE,
"coleman_liau_index" DOUBLE,
"flesch_kincaid_grade_level" DOUBLE,
"flesch_reading_ease" DOUBLE,
"gulpease_index" DOUBLE,
"gunning_fog_index" DOUBLE,
"lix" DOUBLE,
"smog_index" DOUBLE,
"wiener_sachtextformel" DOUBLE,
"n_chars" BIGINT,
"n_long_words" BIGINT,
"n_monosyllable_words" BIGINT,
"n_polysyllable_words" BIGINT,
"n_sents" BIGINT,
"n_syllables" BIGINT,
"n_unique_words" BIGINT,
"n_words" BIGINT,
"sent_neg" DOUBLE,
"sent_neu" DOUBLE,
"sent_pos" DOUBLE,
"sent_compound" DOUBLE,
"economic_stress_total" BIGINT,
"isolation_total" BIGINT,
"substance_use_total" BIGINT,
"guns_total" BIGINT,
"domestic_stress_total" BIGINT,
"suicidality_total" BIGINT,
"punctuation" DOUBLE,
"liwc_1st_pers" BIGINT,
"liwc_2nd_pers" BIGINT,
"liwc_3rd_pers" BIGINT,
"liwc_achievement" BIGINT,
"liwc_adverbs" BIGINT,
"liwc_affective_processes" BIGINT,
"liwc_anger" BIGINT,
"liwc_anxiety" BIGINT,
"liwc_articles_article" BIGINT,
"liwc_assent" BIGINT,
"liwc_auxiliary_verbs" BIGINT,
"liwc_biological" BIGINT,
"liwc_body" BIGINT,
"liwc_causation" BIGINT,
"liwc_certainty" BIGINT,
"liwc_cognitive" BIGINT,
"liwc_common_verbs" BIGINT,
"liwc_conjunctions" BIGINT,
"liwc_death" BIGINT,
"liwc_discrepancy" BIGINT,
"liwc_exclusive" BIGINT,
"liwc_family" BIGINT,
"liwc_feel" BIGINT,
"liwc_fillers" BIGINT,
"liwc_friends" BIGINT,
"liwc_future_tense" BIGINT,
"liwc_health" BIGINT,
"liwc_hear" BIGINT,
"liwc_home" BIGINT,
"liwc_humans" BIGINT,
"liwc_impersonal_pronouns" BIGINT,
"liwc_inclusive" BIGINT,
"liwc_ingestion" BIGINT,
"liwc_inhibition" BIGINT,
"liwc_insight" BIGINT,
"liwc_leisure" BIGINT,
"liwc_money" BIGINT,
"liwc_motion" BIGINT,
"liwc_negations" BIGINT,
"liwc_negative_emotion" BIGINT,
"liwc_nonfluencies" BIGINT,
"liwc_numbers" BIGINT,
"liwc_past_tense" BIGINT,
"liwc_perceptual_processes" BIGINT,
"liwc_personal_pronouns" BIGINT,
"liwc_positive_emotion" BIGINT,
"liwc_prepositions" BIGINT,
"liwc_present_tense" BIGINT,
"liwc_quantifiers" BIGINT,
"liwc_relativity" BIGINT,
"liwc_religion" BIGINT,
"liwc_sadness" BIGINT,
"liwc_see" BIGINT,
"liwc_sexual" BIGINT,
"liwc_social_processes" BIGINT,
"liwc_space" BIGINT,
"liwc_swear_words" BIGINT,
"liwc_tentative" BIGINT,
"liwc_time" BIGINT,
"liwc_total_functional" BIGINT,
"liwc_total_pronouns" BIGINT,
"liwc_work" BIGINT,
"tfidf_abl" DOUBLE,
"tfidf_abus" DOUBLE,
"tfidf_actual" DOUBLE,
"tfidf_addict" DOUBLE,
"tfidf_adhd" DOUBLE,
"tfidf_advic" DOUBLE
);
CREATE TABLE adhd_pre_features_tfidf_256 (
"subreddit" VARCHAR,
"author" VARCHAR,
"date" VARCHAR,
"post" VARCHAR,
"automated_readability_index" DOUBLE,
"coleman_liau_index" DOUBLE,
"flesch_kincaid_grade_level" DOUBLE,
"flesch_reading_ease" DOUBLE,
"gulpease_index" DOUBLE,
"gunning_fog_index" DOUBLE,
"lix" DOUBLE,
"smog_index" DOUBLE,
"wiener_sachtextformel" DOUBLE,
"n_chars" BIGINT,
"n_long_words" BIGINT,
"n_monosyllable_words" BIGINT,
"n_polysyllable_words" BIGINT,
"n_sents" BIGINT,
"n_syllables" BIGINT,
"n_unique_words" BIGINT,
"n_words" BIGINT,
"sent_neg" DOUBLE,
"sent_neu" DOUBLE,
"sent_pos" DOUBLE,
"sent_compound" DOUBLE,
"economic_stress_total" BIGINT,
"isolation_total" BIGINT,
"substance_use_total" BIGINT,
"guns_total" BIGINT,
"domestic_stress_total" BIGINT,
"suicidality_total" BIGINT,
"punctuation" DOUBLE,
"liwc_1st_pers" BIGINT,
"liwc_2nd_pers" BIGINT,
"liwc_3rd_pers" BIGINT,
"liwc_achievement" BIGINT,
"liwc_adverbs" BIGINT,
"liwc_affective_processes" BIGINT,
"liwc_anger" BIGINT,
"liwc_anxiety" BIGINT,
"liwc_articles_article" BIGINT,
"liwc_assent" BIGINT,
"liwc_auxiliary_verbs" BIGINT,
"liwc_biological" BIGINT,
"liwc_body" BIGINT,
"liwc_causation" BIGINT,
"liwc_certainty" BIGINT,
"liwc_cognitive" BIGINT,
"liwc_common_verbs" BIGINT,
"liwc_conjunctions" BIGINT,
"liwc_death" BIGINT,
"liwc_discrepancy" BIGINT,
"liwc_exclusive" BIGINT,
"liwc_family" BIGINT,
"liwc_feel" BIGINT,
"liwc_fillers" BIGINT,
"liwc_friends" BIGINT,
"liwc_future_tense" BIGINT,
"liwc_health" BIGINT,
"liwc_hear" BIGINT,
"liwc_home" BIGINT,
"liwc_humans" BIGINT,
"liwc_impersonal_pronouns" BIGINT,
"liwc_inclusive" BIGINT,
"liwc_ingestion" BIGINT,
"liwc_inhibition" BIGINT,
"liwc_insight" BIGINT,
"liwc_leisure" BIGINT,
"liwc_money" BIGINT,
"liwc_motion" BIGINT,
"liwc_negations" BIGINT,
"liwc_negative_emotion" BIGINT,
"liwc_nonfluencies" BIGINT,
"liwc_numbers" BIGINT,
"liwc_past_tense" BIGINT,
"liwc_perceptual_processes" BIGINT,
"liwc_personal_pronouns" BIGINT,
"liwc_positive_emotion" BIGINT,
"liwc_prepositions" BIGINT,
"liwc_present_tense" BIGINT,
"liwc_quantifiers" BIGINT,
"liwc_relativity" BIGINT,
"liwc_religion" BIGINT,
"liwc_sadness" BIGINT,
"liwc_see" BIGINT,
"liwc_sexual" BIGINT,
"liwc_social_processes" BIGINT,
"liwc_space" BIGINT,
"liwc_swear_words" BIGINT,
"liwc_tentative" BIGINT,
"liwc_time" BIGINT,
"liwc_total_functional" BIGINT,
"liwc_total_pronouns" BIGINT,
"liwc_work" BIGINT,
"tfidf_abl" DOUBLE,
"tfidf_abus" DOUBLE,
"tfidf_actual" DOUBLE,
"tfidf_addict" DOUBLE,
"tfidf_adhd" DOUBLE,
"tfidf_advic" DOUBLE
);
CREATE TABLE alcoholism_2018_features_tfidf_256 (
"subreddit" VARCHAR,
"author" VARCHAR,
"date" VARCHAR,
"post" VARCHAR,
"automated_readability_index" DOUBLE,
"coleman_liau_index" DOUBLE,
"flesch_kincaid_grade_level" DOUBLE,
"flesch_reading_ease" DOUBLE,
"gulpease_index" DOUBLE,
"gunning_fog_index" DOUBLE,
"lix" DOUBLE,
"smog_index" DOUBLE,
"wiener_sachtextformel" DOUBLE,
"n_chars" BIGINT,
"n_long_words" BIGINT,
"n_monosyllable_words" BIGINT,
"n_polysyllable_words" BIGINT,
"n_sents" BIGINT,
"n_syllables" BIGINT,
"n_unique_words" BIGINT,
"n_words" BIGINT,
"sent_neg" DOUBLE,
"sent_neu" DOUBLE,
"sent_pos" DOUBLE,
"sent_compound" DOUBLE,
"economic_stress_total" BIGINT,
"isolation_total" BIGINT,
"substance_use_total" BIGINT,
"guns_total" BIGINT,
"domestic_stress_total" BIGINT,
"suicidality_total" BIGINT,
"punctuation" DOUBLE,
"liwc_1st_pers" BIGINT,
"liwc_2nd_pers" BIGINT,
"liwc_3rd_pers" BIGINT,
"liwc_achievement" BIGINT,
"liwc_adverbs" BIGINT,
"liwc_affective_processes" BIGINT,
"liwc_anger" BIGINT,
"liwc_anxiety" BIGINT,
"liwc_articles_article" BIGINT,
"liwc_assent" BIGINT,
"liwc_auxiliary_verbs" BIGINT,
"liwc_biological" BIGINT,
"liwc_body" BIGINT,
"liwc_causation" BIGINT,
"liwc_certainty" BIGINT,
"liwc_cognitive" BIGINT,
"liwc_common_verbs" BIGINT,
"liwc_conjunctions" BIGINT,
"liwc_death" BIGINT,
"liwc_discrepancy" BIGINT,
"liwc_exclusive" BIGINT,
"liwc_family" BIGINT,
"liwc_feel" BIGINT,
"liwc_fillers" BIGINT,
"liwc_friends" BIGINT,
"liwc_future_tense" BIGINT,
"liwc_health" BIGINT,
"liwc_hear" BIGINT,
"liwc_home" BIGINT,
"liwc_humans" BIGINT,
"liwc_impersonal_pronouns" BIGINT,
"liwc_inclusive" BIGINT,
"liwc_ingestion" BIGINT,
"liwc_inhibition" BIGINT,
"liwc_insight" BIGINT,
"liwc_leisure" BIGINT,
"liwc_money" BIGINT,
"liwc_motion" BIGINT,
"liwc_negations" BIGINT,
"liwc_negative_emotion" BIGINT,
"liwc_nonfluencies" BIGINT,
"liwc_numbers" BIGINT,
"liwc_past_tense" BIGINT,
"liwc_perceptual_processes" BIGINT,
"liwc_personal_pronouns" BIGINT,
"liwc_positive_emotion" BIGINT,
"liwc_prepositions" BIGINT,
"liwc_present_tense" BIGINT,
"liwc_quantifiers" BIGINT,
"liwc_relativity" BIGINT,
"liwc_religion" BIGINT,
"liwc_sadness" BIGINT,
"liwc_see" BIGINT,
"liwc_sexual" BIGINT,
"liwc_social_processes" BIGINT,
"liwc_space" BIGINT,
"liwc_swear_words" BIGINT,
"liwc_tentative" BIGINT,
"liwc_time" BIGINT,
"liwc_total_functional" BIGINT,
"liwc_total_pronouns" BIGINT,
"liwc_work" BIGINT,
"tfidf_abl" DOUBLE,
"tfidf_abus" DOUBLE,
"tfidf_actual" DOUBLE,
"tfidf_addict" DOUBLE,
"tfidf_adhd" DOUBLE,
"tfidf_advic" DOUBLE
);
CREATE TABLE alcoholism_2019_features_tfidf_256 (
"subreddit" VARCHAR,
"author" VARCHAR,
"date" VARCHAR,
"post" VARCHAR,
"automated_readability_index" DOUBLE,
"coleman_liau_index" DOUBLE,
"flesch_kincaid_grade_level" DOUBLE,
"flesch_reading_ease" DOUBLE,
"gulpease_index" DOUBLE,
"gunning_fog_index" DOUBLE,
"lix" DOUBLE,
"smog_index" DOUBLE,
"wiener_sachtextformel" DOUBLE,
"n_chars" BIGINT,
"n_long_words" BIGINT,
"n_monosyllable_words" BIGINT,
"n_polysyllable_words" BIGINT,
"n_sents" BIGINT,
"n_syllables" BIGINT,
"n_unique_words" BIGINT,
"n_words" BIGINT,
"sent_neg" DOUBLE,
"sent_neu" DOUBLE,
"sent_pos" DOUBLE,
"sent_compound" DOUBLE,
"economic_stress_total" BIGINT,
"isolation_total" BIGINT,
"substance_use_total" BIGINT,
"guns_total" BIGINT,
"domestic_stress_total" BIGINT,
"suicidality_total" BIGINT,
"punctuation" DOUBLE,
"liwc_1st_pers" BIGINT,
"liwc_2nd_pers" BIGINT,
"liwc_3rd_pers" BIGINT,
"liwc_achievement" BIGINT,
"liwc_adverbs" BIGINT,
"liwc_affective_processes" BIGINT,
"liwc_anger" BIGINT,
"liwc_anxiety" BIGINT,
"liwc_articles_article" BIGINT,
"liwc_assent" BIGINT,
"liwc_auxiliary_verbs" BIGINT,
"liwc_biological" BIGINT,
"liwc_body" BIGINT,
"liwc_causation" BIGINT,
"liwc_certainty" BIGINT,
"liwc_cognitive" BIGINT,
"liwc_common_verbs" BIGINT,
"liwc_conjunctions" BIGINT,
"liwc_death" BIGINT,
"liwc_discrepancy" BIGINT,
"liwc_exclusive" BIGINT,
"liwc_family" BIGINT,
"liwc_feel" BIGINT,
"liwc_fillers" BIGINT,
"liwc_friends" BIGINT,
"liwc_future_tense" BIGINT,
"liwc_health" BIGINT,
"liwc_hear" BIGINT,
"liwc_home" BIGINT,
"liwc_humans" BIGINT,
"liwc_impersonal_pronouns" BIGINT,
"liwc_inclusive" BIGINT,
"liwc_ingestion" BIGINT,
"liwc_inhibition" BIGINT,
"liwc_insight" BIGINT,
"liwc_leisure" BIGINT,
"liwc_money" BIGINT,
"liwc_motion" BIGINT,
"liwc_negations" BIGINT,
"liwc_negative_emotion" BIGINT,
"liwc_nonfluencies" BIGINT,
"liwc_numbers" BIGINT,
"liwc_past_tense" BIGINT,
"liwc_perceptual_processes" BIGINT,
"liwc_personal_pronouns" BIGINT,
"liwc_positive_emotion" BIGINT,
"liwc_prepositions" BIGINT,
"liwc_present_tense" BIGINT,
"liwc_quantifiers" BIGINT,
"liwc_relativity" BIGINT,
"liwc_religion" BIGINT,
"liwc_sadness" BIGINT,
"liwc_see" BIGINT,
"liwc_sexual" BIGINT,
"liwc_social_processes" BIGINT,
"liwc_space" BIGINT,
"liwc_swear_words" BIGINT,
"liwc_tentative" BIGINT,
"liwc_time" BIGINT,
"liwc_total_functional" BIGINT,
"liwc_total_pronouns" BIGINT,
"liwc_work" BIGINT,
"tfidf_abl" DOUBLE,
"tfidf_abus" DOUBLE,
"tfidf_actual" DOUBLE,
"tfidf_addict" DOUBLE,
"tfidf_adhd" DOUBLE,
"tfidf_advic" DOUBLE
);
CREATE TABLE alcoholism_post_features_tfidf_256 (
"subreddit" VARCHAR,
"author" VARCHAR,
"date" VARCHAR,
"post" VARCHAR,
"automated_readability_index" DOUBLE,
"coleman_liau_index" DOUBLE,
"flesch_kincaid_grade_level" DOUBLE,
"flesch_reading_ease" DOUBLE,
"gulpease_index" DOUBLE,
"gunning_fog_index" DOUBLE,
"lix" DOUBLE,
"smog_index" DOUBLE,
"wiener_sachtextformel" DOUBLE,
"n_chars" BIGINT,
"n_long_words" BIGINT,
"n_monosyllable_words" BIGINT,
"n_polysyllable_words" BIGINT,
"n_sents" BIGINT,
"n_syllables" BIGINT,
"n_unique_words" BIGINT,
"n_words" BIGINT,
"sent_neg" DOUBLE,
"sent_neu" DOUBLE,
"sent_pos" DOUBLE,
"sent_compound" DOUBLE,
"economic_stress_total" BIGINT,
"isolation_total" BIGINT,
"substance_use_total" BIGINT,
"guns_total" BIGINT,
"domestic_stress_total" BIGINT,
"suicidality_total" BIGINT,
"punctuation" DOUBLE,
"liwc_1st_pers" BIGINT,
"liwc_2nd_pers" BIGINT,
"liwc_3rd_pers" BIGINT,
"liwc_achievement" BIGINT,
"liwc_adverbs" BIGINT,
"liwc_affective_processes" BIGINT,
"liwc_anger" BIGINT,
"liwc_anxiety" BIGINT,
"liwc_articles_article" BIGINT,
"liwc_assent" BIGINT,
"liwc_auxiliary_verbs" BIGINT,
"liwc_biological" BIGINT,
"liwc_body" BIGINT,
"liwc_causation" BIGINT,
"liwc_certainty" BIGINT,
"liwc_cognitive" BIGINT,
"liwc_common_verbs" BIGINT,
"liwc_conjunctions" BIGINT,
"liwc_death" BIGINT,
"liwc_discrepancy" BIGINT,
"liwc_exclusive" BIGINT,
"liwc_family" BIGINT,
"liwc_feel" BIGINT,
"liwc_fillers" BIGINT,
"liwc_friends" BIGINT,
"liwc_future_tense" BIGINT,
"liwc_health" BIGINT,
"liwc_hear" BIGINT,
"liwc_home" BIGINT,
"liwc_humans" BIGINT,
"liwc_impersonal_pronouns" BIGINT,
"liwc_inclusive" BIGINT,
"liwc_ingestion" BIGINT,
"liwc_inhibition" BIGINT,
"liwc_insight" BIGINT,
"liwc_leisure" BIGINT,
"liwc_money" BIGINT,
"liwc_motion" BIGINT,
"liwc_negations" BIGINT,
"liwc_negative_emotion" BIGINT,
"liwc_nonfluencies" BIGINT,
"liwc_numbers" BIGINT,
"liwc_past_tense" BIGINT,
"liwc_perceptual_processes" BIGINT,
"liwc_personal_pronouns" BIGINT,
"liwc_positive_emotion" BIGINT,
"liwc_prepositions" BIGINT,
"liwc_present_tense" BIGINT,
"liwc_quantifiers" BIGINT,
"liwc_relativity" BIGINT,
"liwc_religion" BIGINT,
"liwc_sadness" BIGINT,
"liwc_see" BIGINT,
"liwc_sexual" BIGINT,
"liwc_social_processes" BIGINT,
"liwc_space" BIGINT,
"liwc_swear_words" BIGINT,
"liwc_tentative" BIGINT,
"liwc_time" BIGINT,
"liwc_total_functional" BIGINT,
"liwc_total_pronouns" BIGINT,
"liwc_work" BIGINT,
"tfidf_abl" DOUBLE,
"tfidf_abus" DOUBLE,
"tfidf_actual" DOUBLE,
"tfidf_addict" DOUBLE,
"tfidf_adhd" DOUBLE,
"tfidf_advic" DOUBLE
);
CREATE TABLE alcoholism_pre_features_tfidf_256 (
"subreddit" VARCHAR,
"author" VARCHAR,
"date" VARCHAR,
"post" VARCHAR,
"automated_readability_index" DOUBLE,
"coleman_liau_index" DOUBLE,
"flesch_kincaid_grade_level" DOUBLE,
"flesch_reading_ease" DOUBLE,
"gulpease_index" DOUBLE,
"gunning_fog_index" DOUBLE,
"lix" DOUBLE,
"smog_index" DOUBLE,
"wiener_sachtextformel" DOUBLE,
"n_chars" BIGINT,
"n_long_words" BIGINT,
"n_monosyllable_words" BIGINT,
"n_polysyllable_words" BIGINT,
"n_sents" BIGINT,
"n_syllables" BIGINT,
"n_unique_words" BIGINT,
"n_words" BIGINT,
"sent_neg" DOUBLE,
"sent_neu" DOUBLE,
"sent_pos" DOUBLE,
"sent_compound" DOUBLE,
"economic_stress_total" BIGINT,
"isolation_total" BIGINT,
"substance_use_total" BIGINT,
"guns_total" BIGINT,
"domestic_stress_total" BIGINT,
"suicidality_total" BIGINT,
"punctuation" DOUBLE,
"liwc_1st_pers" BIGINT,
"liwc_2nd_pers" BIGINT,
"liwc_3rd_pers" BIGINT,
"liwc_achievement" BIGINT,
"liwc_adverbs" BIGINT,
"liwc_affective_processes" BIGINT,
"liwc_anger" BIGINT,
"liwc_anxiety" BIGINT,
"liwc_articles_article" BIGINT,
"liwc_assent" BIGINT,
"liwc_auxiliary_verbs" BIGINT,
"liwc_biological" BIGINT,
"liwc_body" BIGINT,
"liwc_causation" BIGINT,
"liwc_certainty" BIGINT,
"liwc_cognitive" BIGINT,
"liwc_common_verbs" BIGINT,
"liwc_conjunctions" BIGINT,
"liwc_death" BIGINT,
"liwc_discrepancy" BIGINT,
"liwc_exclusive" BIGINT,
"liwc_family" BIGINT,
"liwc_feel" BIGINT,
"liwc_fillers" BIGINT,
"liwc_friends" BIGINT,
"liwc_future_tense" BIGINT,
"liwc_health" BIGINT,
"liwc_hear" BIGINT,
"liwc_home" BIGINT,
"liwc_humans" BIGINT,
"liwc_impersonal_pronouns" BIGINT,
"liwc_inclusive" BIGINT,
"liwc_ingestion" BIGINT,
"liwc_inhibition" BIGINT,
"liwc_insight" BIGINT,
"liwc_leisure" BIGINT,
"liwc_money" BIGINT,
"liwc_motion" BIGINT,
"liwc_negations" BIGINT,
"liwc_negative_emotion" BIGINT,
"liwc_nonfluencies" BIGINT,
"liwc_numbers" BIGINT,
"liwc_past_tense" BIGINT,
"liwc_perceptual_processes" BIGINT,
"liwc_personal_pronouns" BIGINT,
"liwc_positive_emotion" BIGINT,
"liwc_prepositions" BIGINT,
"liwc_present_tense" BIGINT,
"liwc_quantifiers" BIGINT,
"liwc_relativity" BIGINT,
"liwc_religion" BIGINT,
"liwc_sadness" BIGINT,
"liwc_see" BIGINT,
"liwc_sexual" BIGINT,
"liwc_social_processes" BIGINT,
"liwc_space" BIGINT,
"liwc_swear_words" BIGINT,
"liwc_tentative" BIGINT,
"liwc_time" BIGINT,
"liwc_total_functional" BIGINT,
"liwc_total_pronouns" BIGINT,
"liwc_work" BIGINT,
"tfidf_abl" DOUBLE,
"tfidf_abus" DOUBLE,
"tfidf_actual" DOUBLE,
"tfidf_addict" DOUBLE,
"tfidf_adhd" DOUBLE,
"tfidf_advic" DOUBLE
);
CREATE TABLE anxiety_2018_features_tfidf_256 (
"subreddit" VARCHAR,
"author" VARCHAR,
"date" VARCHAR,
"post" VARCHAR,
"automated_readability_index" DOUBLE,
"coleman_liau_index" DOUBLE,
"flesch_kincaid_grade_level" DOUBLE,
"flesch_reading_ease" DOUBLE,
"gulpease_index" DOUBLE,
"gunning_fog_index" DOUBLE,
"lix" DOUBLE,
"smog_index" DOUBLE,
"wiener_sachtextformel" DOUBLE,
"n_chars" BIGINT,
"n_long_words" BIGINT,
"n_monosyllable_words" BIGINT,
"n_polysyllable_words" BIGINT,
"n_sents" BIGINT,
"n_syllables" BIGINT,
"n_unique_words" BIGINT,
"n_words" BIGINT,
"sent_neg" DOUBLE,
"sent_neu" DOUBLE,
"sent_pos" DOUBLE,
"sent_compound" DOUBLE,
"economic_stress_total" BIGINT,
"isolation_total" BIGINT,
"substance_use_total" BIGINT,
"guns_total" BIGINT,
"domestic_stress_total" BIGINT,
"suicidality_total" BIGINT,
"punctuation" DOUBLE,
"liwc_1st_pers" BIGINT,
"liwc_2nd_pers" BIGINT,
"liwc_3rd_pers" BIGINT,
"liwc_achievement" BIGINT,
"liwc_adverbs" BIGINT,
"liwc_affective_processes" BIGINT,
"liwc_anger" BIGINT,
"liwc_anxiety" BIGINT,
"liwc_articles_article" BIGINT,
"liwc_assent" BIGINT,
"liwc_auxiliary_verbs" BIGINT,
"liwc_biological" BIGINT,
"liwc_body" BIGINT,
"liwc_causation" BIGINT,
"liwc_certainty" BIGINT,
"liwc_cognitive" BIGINT,
"liwc_common_verbs" BIGINT,
"liwc_conjunctions" BIGINT,
"liwc_death" BIGINT,
"liwc_discrepancy" BIGINT,
"liwc_exclusive" BIGINT,
"liwc_family" BIGINT,
"liwc_feel" BIGINT,
"liwc_fillers" BIGINT,
"liwc_friends" BIGINT,
"liwc_future_tense" BIGINT,
"liwc_health" BIGINT,
"liwc_hear" BIGINT,
"liwc_home" BIGINT,
"liwc_humans" BIGINT,
"liwc_impersonal_pronouns" BIGINT,
"liwc_inclusive" BIGINT,
"liwc_ingestion" BIGINT,
"liwc_inhibition" BIGINT,
"liwc_insight" BIGINT,
"liwc_leisure" BIGINT,
"liwc_money" BIGINT,
"liwc_motion" BIGINT,
"liwc_negations" BIGINT,
"liwc_negative_emotion" BIGINT,
"liwc_nonfluencies" BIGINT,
"liwc_numbers" BIGINT,
"liwc_past_tense" BIGINT,
"liwc_perceptual_processes" BIGINT,
"liwc_personal_pronouns" BIGINT,
"liwc_positive_emotion" BIGINT,
"liwc_prepositions" BIGINT,
"liwc_present_tense" BIGINT,
"liwc_quantifiers" BIGINT,
"liwc_relativity" BIGINT,
"liwc_religion" BIGINT,
"liwc_sadness" BIGINT,
"liwc_see" BIGINT,
"liwc_sexual" BIGINT,
"liwc_social_processes" BIGINT,
"liwc_space" BIGINT,
"liwc_swear_words" BIGINT,
"liwc_tentative" BIGINT,
"liwc_time" BIGINT,
"liwc_total_functional" BIGINT,
"liwc_total_pronouns" BIGINT,
"liwc_work" BIGINT,
"tfidf_abl" DOUBLE,
"tfidf_abus" DOUBLE,
"tfidf_actual" DOUBLE,
"tfidf_addict" DOUBLE,
"tfidf_adhd" DOUBLE,
"tfidf_advic" DOUBLE
);
CREATE TABLE anxiety_2019_features_tfidf_256 (
"subreddit" VARCHAR,
"author" VARCHAR,
"date" VARCHAR,
"post" VARCHAR,
"automated_readability_index" DOUBLE,
"coleman_liau_index" DOUBLE,
"flesch_kincaid_grade_level" DOUBLE,
"flesch_reading_ease" DOUBLE,
"gulpease_index" DOUBLE,
"gunning_fog_index" DOUBLE,
"lix" DOUBLE,
"smog_index" DOUBLE,
"wiener_sachtextformel" DOUBLE,
"n_chars" BIGINT,
"n_long_words" BIGINT,
"n_monosyllable_words" BIGINT,
"n_polysyllable_words" BIGINT,
"n_sents" BIGINT,
"n_syllables" BIGINT,
"n_unique_words" BIGINT,
"n_words" BIGINT,
"sent_neg" DOUBLE,
"sent_neu" DOUBLE,
"sent_pos" DOUBLE,
"sent_compound" DOUBLE,
"economic_stress_total" BIGINT,
"isolation_total" BIGINT,
"substance_use_total" BIGINT,
"guns_total" BIGINT,
"domestic_stress_total" BIGINT,
"suicidality_total" BIGINT,
"punctuation" DOUBLE,
"liwc_1st_pers" BIGINT,
"liwc_2nd_pers" BIGINT,
"liwc_3rd_pers" BIGINT,
"liwc_achievement" BIGINT,
"liwc_adverbs" BIGINT,
"liwc_affective_processes" BIGINT,
"liwc_anger" BIGINT,
"liwc_anxiety" BIGINT,
"liwc_articles_article" BIGINT,
"liwc_assent" BIGINT,
"liwc_auxiliary_verbs" BIGINT,
"liwc_biological" BIGINT,
"liwc_body" BIGINT,
"liwc_causation" BIGINT,
"liwc_certainty" BIGINT,
"liwc_cognitive" BIGINT,
"liwc_common_verbs" BIGINT,
"liwc_conjunctions" BIGINT,
"liwc_death" BIGINT,
"liwc_discrepancy" BIGINT,
"liwc_exclusive" BIGINT,
"liwc_family" BIGINT,
"liwc_feel" BIGINT,
"liwc_fillers" BIGINT,
"liwc_friends" BIGINT,
"liwc_future_tense" BIGINT,
"liwc_health" BIGINT,
"liwc_hear" BIGINT,
"liwc_home" BIGINT,
"liwc_humans" BIGINT,
"liwc_impersonal_pronouns" BIGINT,
"liwc_inclusive" BIGINT,
"liwc_ingestion" BIGINT,
"liwc_inhibition" BIGINT,
"liwc_insight" BIGINT,
"liwc_leisure" BIGINT,
"liwc_money" BIGINT,
"liwc_motion" BIGINT,
"liwc_negations" BIGINT,
"liwc_negative_emotion" BIGINT,
"liwc_nonfluencies" BIGINT,
"liwc_numbers" BIGINT,
"liwc_past_tense" BIGINT,
"liwc_perceptual_processes" BIGINT,
"liwc_personal_pronouns" BIGINT,
"liwc_positive_emotion" BIGINT,
"liwc_prepositions" BIGINT,
"liwc_present_tense" BIGINT,
"liwc_quantifiers" BIGINT,
"liwc_relativity" BIGINT,
"liwc_religion" BIGINT,
"liwc_sadness" BIGINT,
"liwc_see" BIGINT,
"liwc_sexual" BIGINT,
"liwc_social_processes" BIGINT,
"liwc_space" BIGINT,
"liwc_swear_words" BIGINT,
"liwc_tentative" BIGINT,
"liwc_time" BIGINT,
"liwc_total_functional" BIGINT,
"liwc_total_pronouns" BIGINT,
"liwc_work" BIGINT,
"tfidf_abl" DOUBLE,
"tfidf_abus" DOUBLE,
"tfidf_actual" DOUBLE,
"tfidf_addict" DOUBLE,
"tfidf_adhd" DOUBLE,
"tfidf_advic" DOUBLE
);
CREATE TABLE anxiety_post_features_tfidf_256 (
"subreddit" VARCHAR,
"author" VARCHAR,
"date" VARCHAR,
"post" VARCHAR,
"automated_readability_index" DOUBLE,
"coleman_liau_index" DOUBLE,
"flesch_kincaid_grade_level" DOUBLE,
"flesch_reading_ease" DOUBLE,
"gulpease_index" DOUBLE,
"gunning_fog_index" DOUBLE,
"lix" DOUBLE,
"smog_index" DOUBLE,
"wiener_sachtextformel" DOUBLE,
"n_chars" BIGINT,
"n_long_words" BIGINT,
"n_monosyllable_words" BIGINT,
"n_polysyllable_words" BIGINT,
"n_sents" BIGINT,
"n_syllables" BIGINT,
"n_unique_words" BIGINT,
"n_words" BIGINT,
"sent_neg" DOUBLE,
"sent_neu" DOUBLE,
"sent_pos" DOUBLE,
"sent_compound" DOUBLE,
"economic_stress_total" BIGINT,
"isolation_total" BIGINT,
"substance_use_total" BIGINT,
"guns_total" BIGINT,
"domestic_stress_total" BIGINT,
"suicidality_total" BIGINT,
"punctuation" DOUBLE,
"liwc_1st_pers" BIGINT,
"liwc_2nd_pers" BIGINT,
"liwc_3rd_pers" BIGINT,
"liwc_achievement" BIGINT,
"liwc_adverbs" BIGINT,
"liwc_affective_processes" BIGINT,
"liwc_anger" BIGINT,
"liwc_anxiety" BIGINT,
"liwc_articles_article" BIGINT,
"liwc_assent" BIGINT,
"liwc_auxiliary_verbs" BIGINT,
"liwc_biological" BIGINT,
"liwc_body" BIGINT,
"liwc_causation" BIGINT,
"liwc_certainty" BIGINT,
"liwc_cognitive" BIGINT,
"liwc_common_verbs" BIGINT,
"liwc_conjunctions" BIGINT,
"liwc_death" BIGINT,
"liwc_discrepancy" BIGINT,
"liwc_exclusive" BIGINT,
"liwc_family" BIGINT,
"liwc_feel" BIGINT,
"liwc_fillers" BIGINT,
"liwc_friends" BIGINT,
"liwc_future_tense" BIGINT,
"liwc_health" BIGINT,
"liwc_hear" BIGINT,
"liwc_home" BIGINT,
"liwc_humans" BIGINT,
"liwc_impersonal_pronouns" BIGINT,
"liwc_inclusive" BIGINT,
"liwc_ingestion" BIGINT,
"liwc_inhibition" BIGINT,
"liwc_insight" BIGINT,
"liwc_leisure" BIGINT,
"liwc_money" BIGINT,
"liwc_motion" BIGINT,
"liwc_negations" BIGINT,
"liwc_negative_emotion" BIGINT,
"liwc_nonfluencies" BIGINT,
"liwc_numbers" BIGINT,
"liwc_past_tense" BIGINT,
"liwc_perceptual_processes" BIGINT,
"liwc_personal_pronouns" BIGINT,
"liwc_positive_emotion" BIGINT,
"liwc_prepositions" BIGINT,
"liwc_present_tense" BIGINT,
"liwc_quantifiers" BIGINT,
"liwc_relativity" BIGINT,
"liwc_religion" BIGINT,
"liwc_sadness" BIGINT,
"liwc_see" BIGINT,
"liwc_sexual" BIGINT,
"liwc_social_processes" BIGINT,
"liwc_space" BIGINT,
"liwc_swear_words" BIGINT,
"liwc_tentative" BIGINT,
"liwc_time" BIGINT,
"liwc_total_functional" BIGINT,
"liwc_total_pronouns" BIGINT,
"liwc_work" BIGINT,
"tfidf_abl" DOUBLE,
"tfidf_abus" DOUBLE,
"tfidf_actual" DOUBLE,
"tfidf_addict" DOUBLE,
"tfidf_adhd" DOUBLE,
"tfidf_advic" DOUBLE
);
CREATE TABLE anxiety_pre_features_tfidf_256 (
"subreddit" VARCHAR,
"author" VARCHAR,
"date" VARCHAR,
"post" VARCHAR,
"automated_readability_index" DOUBLE,
"coleman_liau_index" DOUBLE,
"flesch_kincaid_grade_level" DOUBLE,
"flesch_reading_ease" DOUBLE,
"gulpease_index" DOUBLE,
"gunning_fog_index" DOUBLE,
"lix" DOUBLE,
"smog_index" DOUBLE,
"wiener_sachtextformel" DOUBLE,
"n_chars" BIGINT,
"n_long_words" BIGINT,
"n_monosyllable_words" BIGINT,
"n_polysyllable_words" BIGINT,
"n_sents" BIGINT,
"n_syllables" BIGINT,
"n_unique_words" BIGINT,
"n_words" BIGINT,
"sent_neg" DOUBLE,
"sent_neu" DOUBLE,
"sent_pos" DOUBLE,
"sent_compound" DOUBLE,
"economic_stress_total" BIGINT,
"isolation_total" BIGINT,
"substance_use_total" BIGINT,
"guns_total" BIGINT,
"domestic_stress_total" BIGINT,
"suicidality_total" BIGINT,
"punctuation" DOUBLE,
"liwc_1st_pers" BIGINT,
"liwc_2nd_pers" BIGINT,
"liwc_3rd_pers" BIGINT,
"liwc_achievement" BIGINT,
"liwc_adverbs" BIGINT,
"liwc_affective_processes" BIGINT,
"liwc_anger" BIGINT,
"liwc_anxiety" BIGINT,
"liwc_articles_article" BIGINT,
"liwc_assent" BIGINT,
"liwc_auxiliary_verbs" BIGINT,
"liwc_biological" BIGINT,
"liwc_body" BIGINT,
"liwc_causation" BIGINT,
"liwc_certainty" BIGINT,
"liwc_cognitive" BIGINT,
"liwc_common_verbs" BIGINT,
"liwc_conjunctions" BIGINT,
"liwc_death" BIGINT,
"liwc_discrepancy" BIGINT,
"liwc_exclusive" BIGINT,
"liwc_family" BIGINT,
"liwc_feel" BIGINT,
"liwc_fillers" BIGINT,
"liwc_friends" BIGINT,
"liwc_future_tense" BIGINT,
"liwc_health" BIGINT,
"liwc_hear" BIGINT,
"liwc_home" BIGINT,
"liwc_humans" BIGINT,
"liwc_impersonal_pronouns" BIGINT,
"liwc_inclusive" BIGINT,
"liwc_ingestion" BIGINT,
"liwc_inhibition" BIGINT,
"liwc_insight" BIGINT,
"liwc_leisure" BIGINT,
"liwc_money" BIGINT,
"liwc_motion" BIGINT,
"liwc_negations" BIGINT,
"liwc_negative_emotion" BIGINT,
"liwc_nonfluencies" BIGINT,
"liwc_numbers" BIGINT,
"liwc_past_tense" BIGINT,
"liwc_perceptual_processes" BIGINT,
"liwc_personal_pronouns" BIGINT,
"liwc_positive_emotion" BIGINT,
"liwc_prepositions" BIGINT,
"liwc_present_tense" BIGINT,
"liwc_quantifiers" BIGINT,
"liwc_relativity" BIGINT,
"liwc_religion" BIGINT,
"liwc_sadness" BIGINT,
"liwc_see" BIGINT,
"liwc_sexual" BIGINT,
"liwc_social_processes" BIGINT,
"liwc_space" BIGINT,
"liwc_swear_words" BIGINT,
"liwc_tentative" BIGINT,
"liwc_time" BIGINT,
"liwc_total_functional" BIGINT,
"liwc_total_pronouns" BIGINT,
"liwc_work" BIGINT,
"tfidf_abl" DOUBLE,
"tfidf_abus" DOUBLE,
"tfidf_actual" DOUBLE,
"tfidf_addict" DOUBLE,
"tfidf_adhd" DOUBLE,
"tfidf_advic" DOUBLE
);
CREATE TABLE autism_2018_features_tfidf_256 (
"subreddit" VARCHAR,
"author" VARCHAR,
"date" VARCHAR,
"post" VARCHAR,
"automated_readability_index" DOUBLE,
"coleman_liau_index" DOUBLE,
"flesch_kincaid_grade_level" DOUBLE,
"flesch_reading_ease" DOUBLE,
"gulpease_index" DOUBLE,
"gunning_fog_index" DOUBLE,
"lix" DOUBLE,
"smog_index" DOUBLE,
"wiener_sachtextformel" DOUBLE,
"n_chars" BIGINT,
"n_long_words" BIGINT,
"n_monosyllable_words" BIGINT,
"n_polysyllable_words" BIGINT,
"n_sents" BIGINT,
"n_syllables" BIGINT,
"n_unique_words" BIGINT,
"n_words" BIGINT,
"sent_neg" DOUBLE,
"sent_neu" DOUBLE,
"sent_pos" DOUBLE,
"sent_compound" DOUBLE,
"economic_stress_total" BIGINT,
"isolation_total" BIGINT,
"substance_use_total" BIGINT,
"guns_total" BIGINT,
"domestic_stress_total" BIGINT,
"suicidality_total" BIGINT,
"punctuation" DOUBLE,
"liwc_1st_pers" BIGINT,
"liwc_2nd_pers" BIGINT,
"liwc_3rd_pers" BIGINT,
"liwc_achievement" BIGINT,
"liwc_adverbs" BIGINT,
"liwc_affective_processes" BIGINT,
"liwc_anger" BIGINT,
"liwc_anxiety" BIGINT,
"liwc_articles_article" BIGINT,
"liwc_assent" BIGINT,
"liwc_auxiliary_verbs" BIGINT,
"liwc_biological" BIGINT,
"liwc_body" BIGINT,
"liwc_causation" BIGINT,
"liwc_certainty" BIGINT,
"liwc_cognitive" BIGINT,
"liwc_common_verbs" BIGINT,
"liwc_conjunctions" BIGINT,
"liwc_death" BIGINT,
"liwc_discrepancy" BIGINT,
"liwc_exclusive" BIGINT,
"liwc_family" BIGINT,
"liwc_feel" BIGINT,
"liwc_fillers" BIGINT,
"liwc_friends" BIGINT,
"liwc_future_tense" BIGINT,
"liwc_health" BIGINT,
"liwc_hear" BIGINT,
"liwc_home" BIGINT,
"liwc_humans" BIGINT,
"liwc_impersonal_pronouns" BIGINT,
"liwc_inclusive" BIGINT,
"liwc_ingestion" BIGINT,
"liwc_inhibition" BIGINT,
"liwc_insight" BIGINT,
"liwc_leisure" BIGINT,
"liwc_money" BIGINT,
"liwc_motion" BIGINT,
"liwc_negations" BIGINT,
"liwc_negative_emotion" BIGINT,
"liwc_nonfluencies" BIGINT,
"liwc_numbers" BIGINT,
"liwc_past_tense" BIGINT,
"liwc_perceptual_processes" BIGINT,
"liwc_personal_pronouns" BIGINT,
"liwc_positive_emotion" BIGINT,
"liwc_prepositions" BIGINT,
"liwc_present_tense" BIGINT,
"liwc_quantifiers" BIGINT,
"liwc_relativity" BIGINT,
"liwc_religion" BIGINT,
"liwc_sadness" BIGINT,
"liwc_see" BIGINT,
"liwc_sexual" BIGINT,
"liwc_social_processes" BIGINT,
"liwc_space" BIGINT,
"liwc_swear_words" BIGINT,
"liwc_tentative" BIGINT,
"liwc_time" BIGINT,
"liwc_total_functional" BIGINT,
"liwc_total_pronouns" BIGINT,
"liwc_work" BIGINT,
"tfidf_abl" DOUBLE,
"tfidf_abus" DOUBLE,
"tfidf_actual" DOUBLE,
"tfidf_addict" DOUBLE,
"tfidf_adhd" DOUBLE,
"tfidf_advic" DOUBLE
);
CREATE TABLE autism_2019_features_tfidf_256 (
"subreddit" VARCHAR,
"author" VARCHAR,
"date" VARCHAR,
"post" VARCHAR,
"automated_readability_index" DOUBLE,
"coleman_liau_index" DOUBLE,
"flesch_kincaid_grade_level" DOUBLE,
"flesch_reading_ease" DOUBLE,
"gulpease_index" DOUBLE,
"gunning_fog_index" DOUBLE,
"lix" DOUBLE,
"smog_index" DOUBLE,
"wiener_sachtextformel" DOUBLE,
"n_chars" BIGINT,
"n_long_words" BIGINT,
"n_monosyllable_words" BIGINT,
"n_polysyllable_words" BIGINT,
"n_sents" BIGINT,
"n_syllables" BIGINT,
"n_unique_words" BIGINT,
"n_words" BIGINT,
"sent_neg" DOUBLE,
"sent_neu" DOUBLE,
"sent_pos" DOUBLE,
"sent_compound" DOUBLE,
"economic_stress_total" BIGINT,
"isolation_total" BIGINT,
"substance_use_total" BIGINT,
"guns_total" BIGINT,
"domestic_stress_total" BIGINT,
"suicidality_total" BIGINT,
"punctuation" DOUBLE,
"liwc_1st_pers" BIGINT,
"liwc_2nd_pers" BIGINT,
"liwc_3rd_pers" BIGINT,
"liwc_achievement" BIGINT,
"liwc_adverbs" BIGINT,
"liwc_affective_processes" BIGINT,
"liwc_anger" BIGINT,
"liwc_anxiety" BIGINT,
"liwc_articles_article" BIGINT,
"liwc_assent" BIGINT,
"liwc_auxiliary_verbs" BIGINT,
"liwc_biological" BIGINT,
"liwc_body" BIGINT,
"liwc_causation" BIGINT,
"liwc_certainty" BIGINT,
"liwc_cognitive" BIGINT,
"liwc_common_verbs" BIGINT,
"liwc_conjunctions" BIGINT,
"liwc_death" BIGINT,
"liwc_discrepancy" BIGINT,
"liwc_exclusive" BIGINT,
"liwc_family" BIGINT,
"liwc_feel" BIGINT,
"liwc_fillers" BIGINT,
"liwc_friends" BIGINT,
"liwc_future_tense" BIGINT,
"liwc_health" BIGINT,
"liwc_hear" BIGINT,
"liwc_home" BIGINT,
"liwc_humans" BIGINT,
"liwc_impersonal_pronouns" BIGINT,
"liwc_inclusive" BIGINT,
"liwc_ingestion" BIGINT,
"liwc_inhibition" BIGINT,
"liwc_insight" BIGINT,
"liwc_leisure" BIGINT,
"liwc_money" BIGINT,
"liwc_motion" BIGINT,
"liwc_negations" BIGINT,
"liwc_negative_emotion" BIGINT,
"liwc_nonfluencies" BIGINT,
"liwc_numbers" BIGINT,
"liwc_past_tense" BIGINT,
"liwc_perceptual_processes" BIGINT,
"liwc_personal_pronouns" BIGINT,
"liwc_positive_emotion" BIGINT,
"liwc_prepositions" BIGINT,
"liwc_present_tense" BIGINT,
"liwc_quantifiers" BIGINT,
"liwc_relativity" BIGINT,
"liwc_religion" BIGINT,
"liwc_sadness" BIGINT,
"liwc_see" BIGINT,
"liwc_sexual" BIGINT,
"liwc_social_processes" BIGINT,
"liwc_space" BIGINT,
"liwc_swear_words" BIGINT,
"liwc_tentative" BIGINT,
"liwc_time" BIGINT,
"liwc_total_functional" BIGINT,
"liwc_total_pronouns" BIGINT,
"liwc_work" BIGINT,
"tfidf_abl" DOUBLE,
"tfidf_abus" DOUBLE,
"tfidf_actual" DOUBLE,
"tfidf_addict" DOUBLE,
"tfidf_adhd" DOUBLE,
"tfidf_advic" DOUBLE
);
CREATE TABLE autism_post_features_tfidf_256 (
"subreddit" VARCHAR,
"author" VARCHAR,
"date" VARCHAR,
"post" VARCHAR,
"automated_readability_index" DOUBLE,
"coleman_liau_index" DOUBLE,
"flesch_kincaid_grade_level" DOUBLE,
"flesch_reading_ease" DOUBLE,
"gulpease_index" DOUBLE,
"gunning_fog_index" DOUBLE,
"lix" DOUBLE,
"smog_index" DOUBLE,
"wiener_sachtextformel" DOUBLE,
"n_chars" BIGINT,
"n_long_words" BIGINT,
"n_monosyllable_words" BIGINT,
"n_polysyllable_words" BIGINT,
"n_sents" BIGINT,
"n_syllables" BIGINT,
"n_unique_words" BIGINT,
"n_words" BIGINT,
"sent_neg" DOUBLE,
"sent_neu" DOUBLE,
"sent_pos" DOUBLE,
"sent_compound" DOUBLE,
"economic_stress_total" BIGINT,
"isolation_total" BIGINT,
"substance_use_total" BIGINT,
"guns_total" BIGINT,
"domestic_stress_total" BIGINT,
"suicidality_total" BIGINT,
"punctuation" DOUBLE,
"liwc_1st_pers" BIGINT,
"liwc_2nd_pers" BIGINT,
"liwc_3rd_pers" BIGINT,
"liwc_achievement" BIGINT,
"liwc_adverbs" BIGINT,
"liwc_affective_processes" BIGINT,
"liwc_anger" BIGINT,
"liwc_anxiety" BIGINT,
"liwc_articles_article" BIGINT,
"liwc_assent" BIGINT,
"liwc_auxiliary_verbs" BIGINT,
"liwc_biological" BIGINT,
"liwc_body" BIGINT,
"liwc_causation" BIGINT,
"liwc_certainty" BIGINT,
"liwc_cognitive" BIGINT,
"liwc_common_verbs" BIGINT,
"liwc_conjunctions" BIGINT,
"liwc_death" BIGINT,
"liwc_discrepancy" BIGINT,
"liwc_exclusive" BIGINT,
"liwc_family" BIGINT,
"liwc_feel" BIGINT,
"liwc_fillers" BIGINT,
"liwc_friends" BIGINT,
"liwc_future_tense" BIGINT,
"liwc_health" BIGINT,
"liwc_hear" BIGINT,
"liwc_home" BIGINT,
"liwc_humans" BIGINT,
"liwc_impersonal_pronouns" BIGINT,
"liwc_inclusive" BIGINT,
"liwc_ingestion" BIGINT,
"liwc_inhibition" BIGINT,
"liwc_insight" BIGINT,
"liwc_leisure" BIGINT,
"liwc_money" BIGINT,
"liwc_motion" BIGINT,
"liwc_negations" BIGINT,
"liwc_negative_emotion" BIGINT,
"liwc_nonfluencies" BIGINT,
"liwc_numbers" BIGINT,
"liwc_past_tense" BIGINT,
"liwc_perceptual_processes" BIGINT,
"liwc_personal_pronouns" BIGINT,
"liwc_positive_emotion" BIGINT,
"liwc_prepositions" BIGINT,
"liwc_present_tense" BIGINT,
"liwc_quantifiers" BIGINT,
"liwc_relativity" BIGINT,
"liwc_religion" BIGINT,
"liwc_sadness" BIGINT,
"liwc_see" BIGINT,
"liwc_sexual" BIGINT,
"liwc_social_processes" BIGINT,
"liwc_space" BIGINT,
"liwc_swear_words" BIGINT,
"liwc_tentative" BIGINT,
"liwc_time" BIGINT,
"liwc_total_functional" BIGINT,
"liwc_total_pronouns" BIGINT,
"liwc_work" BIGINT,
"tfidf_abl" DOUBLE,
"tfidf_abus" DOUBLE,
"tfidf_actual" DOUBLE,
"tfidf_addict" DOUBLE,
"tfidf_adhd" DOUBLE,
"tfidf_advic" DOUBLE
);
CREATE TABLE autism_pre_features_tfidf_256 (
"subreddit" VARCHAR,
"author" VARCHAR,
"date" VARCHAR,
"post" VARCHAR,
"automated_readability_index" DOUBLE,
"coleman_liau_index" DOUBLE,
"flesch_kincaid_grade_level" DOUBLE,
"flesch_reading_ease" DOUBLE,
"gulpease_index" DOUBLE,
"gunning_fog_index" DOUBLE,
"lix" DOUBLE,
"smog_index" DOUBLE,
"wiener_sachtextformel" DOUBLE,
"n_chars" BIGINT,
"n_long_words" BIGINT,
"n_monosyllable_words" BIGINT,
"n_polysyllable_words" BIGINT,
"n_sents" BIGINT,
"n_syllables" BIGINT,
"n_unique_words" BIGINT,
"n_words" BIGINT,
"sent_neg" DOUBLE,
"sent_neu" DOUBLE,
"sent_pos" DOUBLE,
"sent_compound" DOUBLE,
"economic_stress_total" BIGINT,
"isolation_total" BIGINT,
"substance_use_total" BIGINT,
"guns_total" BIGINT,
"domestic_stress_total" BIGINT,
"suicidality_total" BIGINT,
"punctuation" DOUBLE,
"liwc_1st_pers" BIGINT,
"liwc_2nd_pers" BIGINT,
"liwc_3rd_pers" BIGINT,
"liwc_achievement" BIGINT,
"liwc_adverbs" BIGINT,
"liwc_affective_processes" BIGINT,
"liwc_anger" BIGINT,
"liwc_anxiety" BIGINT,
"liwc_articles_article" BIGINT,
"liwc_assent" BIGINT,
"liwc_auxiliary_verbs" BIGINT,
"liwc_biological" BIGINT,
"liwc_body" BIGINT,
"liwc_causation" BIGINT,
"liwc_certainty" BIGINT,
"liwc_cognitive" BIGINT,
"liwc_common_verbs" BIGINT,
"liwc_conjunctions" BIGINT,
"liwc_death" BIGINT,
"liwc_discrepancy" BIGINT,
"liwc_exclusive" BIGINT,
"liwc_family" BIGINT,
"liwc_feel" BIGINT,
"liwc_fillers" BIGINT,
"liwc_friends" BIGINT,
"liwc_future_tense" BIGINT,
"liwc_health" BIGINT,
"liwc_hear" BIGINT,
"liwc_home" BIGINT,
"liwc_humans" BIGINT,
"liwc_impersonal_pronouns" BIGINT,
"liwc_inclusive" BIGINT,
"liwc_ingestion" BIGINT,
"liwc_inhibition" BIGINT,
"liwc_insight" BIGINT,
"liwc_leisure" BIGINT,
"liwc_money" BIGINT,
"liwc_motion" BIGINT,
"liwc_negations" BIGINT,
"liwc_negative_emotion" BIGINT,
"liwc_nonfluencies" BIGINT,
"liwc_numbers" BIGINT,
"liwc_past_tense" BIGINT,
"liwc_perceptual_processes" BIGINT,
"liwc_personal_pronouns" BIGINT,
"liwc_positive_emotion" BIGINT,
"liwc_prepositions" BIGINT,
"liwc_present_tense" BIGINT,
"liwc_quantifiers" BIGINT,
"liwc_relativity" BIGINT,
"liwc_religion" BIGINT,
"liwc_sadness" BIGINT,
"liwc_see" BIGINT,
"liwc_sexual" BIGINT,
"liwc_social_processes" BIGINT,
"liwc_space" BIGINT,
"liwc_swear_words" BIGINT,
"liwc_tentative" BIGINT,
"liwc_time" BIGINT,
"liwc_total_functional" BIGINT,
"liwc_total_pronouns" BIGINT,
"liwc_work" BIGINT,
"tfidf_abl" DOUBLE,
"tfidf_abus" DOUBLE,
"tfidf_actual" DOUBLE,
"tfidf_addict" DOUBLE,
"tfidf_adhd" DOUBLE,
"tfidf_advic" DOUBLE
);
CREATE TABLE bipolarreddit_2018_features_tfidf_256 (
"subreddit" VARCHAR,
"author" VARCHAR,
"date" VARCHAR,
"post" VARCHAR,
"automated_readability_index" DOUBLE,
"coleman_liau_index" DOUBLE,
"flesch_kincaid_grade_level" DOUBLE,
"flesch_reading_ease" DOUBLE,
"gulpease_index" DOUBLE,
"gunning_fog_index" DOUBLE,
"lix" DOUBLE,
"smog_index" DOUBLE,
"wiener_sachtextformel" DOUBLE,
"n_chars" BIGINT,
"n_long_words" BIGINT,
"n_monosyllable_words" BIGINT,
"n_polysyllable_words" BIGINT,
"n_sents" BIGINT,
"n_syllables" BIGINT,
"n_unique_words" BIGINT,
"n_words" BIGINT,
"sent_neg" DOUBLE,
"sent_neu" DOUBLE,
"sent_pos" DOUBLE,
"sent_compound" DOUBLE,
"economic_stress_total" BIGINT,
"isolation_total" BIGINT,
"substance_use_total" BIGINT,
"guns_total" BIGINT,
"domestic_stress_total" BIGINT,
"suicidality_total" BIGINT,
"punctuation" DOUBLE,
"liwc_1st_pers" BIGINT,
"liwc_2nd_pers" BIGINT,
"liwc_3rd_pers" BIGINT,
"liwc_achievement" BIGINT,
"liwc_adverbs" BIGINT,
"liwc_affective_processes" BIGINT,
"liwc_anger" BIGINT,
"liwc_anxiety" BIGINT,
"liwc_articles_article" BIGINT,
"liwc_assent" BIGINT,
"liwc_auxiliary_verbs" BIGINT,
"liwc_biological" BIGINT,
"liwc_body" BIGINT,
"liwc_causation" BIGINT,
"liwc_certainty" BIGINT,
"liwc_cognitive" BIGINT,
"liwc_common_verbs" BIGINT,
"liwc_conjunctions" BIGINT,
"liwc_death" BIGINT,
"liwc_discrepancy" BIGINT,
"liwc_exclusive" BIGINT,
"liwc_family" BIGINT,
"liwc_feel" BIGINT,
"liwc_fillers" BIGINT,
"liwc_friends" BIGINT,
"liwc_future_tense" BIGINT,
"liwc_health" BIGINT,
"liwc_hear" BIGINT,
"liwc_home" BIGINT,
"liwc_humans" BIGINT,
"liwc_impersonal_pronouns" BIGINT,
"liwc_inclusive" BIGINT,
"liwc_ingestion" BIGINT,
"liwc_inhibition" BIGINT,
"liwc_insight" BIGINT,
"liwc_leisure" BIGINT,
"liwc_money" BIGINT,
"liwc_motion" BIGINT,
"liwc_negations" BIGINT,
"liwc_negative_emotion" BIGINT,
"liwc_nonfluencies" BIGINT,
"liwc_numbers" BIGINT,
"liwc_past_tense" BIGINT,
"liwc_perceptual_processes" BIGINT,
"liwc_personal_pronouns" BIGINT,
"liwc_positive_emotion" BIGINT,
"liwc_prepositions" BIGINT,
"liwc_present_tense" BIGINT,
"liwc_quantifiers" BIGINT,
"liwc_relativity" BIGINT,
"liwc_religion" BIGINT,
"liwc_sadness" BIGINT,
"liwc_see" BIGINT,
"liwc_sexual" BIGINT,
"liwc_social_processes" BIGINT,
"liwc_space" BIGINT,
"liwc_swear_words" BIGINT,
"liwc_tentative" BIGINT,
"liwc_time" BIGINT,
"liwc_total_functional" BIGINT,
"liwc_total_pronouns" BIGINT,
"liwc_work" BIGINT,
"tfidf_abl" DOUBLE,
"tfidf_abus" DOUBLE,
"tfidf_actual" DOUBLE,
"tfidf_addict" DOUBLE,
"tfidf_adhd" DOUBLE,
"tfidf_advic" DOUBLE
);
CREATE TABLE bipolarreddit_2019_features_tfidf_256 (
"subreddit" VARCHAR,
"author" VARCHAR,
"date" VARCHAR,
"post" VARCHAR,
"automated_readability_index" DOUBLE,
"coleman_liau_index" DOUBLE,
"flesch_kincaid_grade_level" DOUBLE,
"flesch_reading_ease" DOUBLE,
"gulpease_index" DOUBLE,
"gunning_fog_index" DOUBLE,
"lix" DOUBLE,
"smog_index" DOUBLE,
"wiener_sachtextformel" DOUBLE,
"n_chars" BIGINT,
"n_long_words" BIGINT,
"n_monosyllable_words" BIGINT,
"n_polysyllable_words" BIGINT,
"n_sents" BIGINT,
"n_syllables" BIGINT,
"n_unique_words" BIGINT,
"n_words" BIGINT,
"sent_neg" DOUBLE,
"sent_neu" DOUBLE,
"sent_pos" DOUBLE,
"sent_compound" DOUBLE,
"economic_stress_total" BIGINT,
"isolation_total" BIGINT,
"substance_use_total" BIGINT,
"guns_total" BIGINT,
"domestic_stress_total" BIGINT,
"suicidality_total" BIGINT,
"punctuation" DOUBLE,
"liwc_1st_pers" BIGINT,
"liwc_2nd_pers" BIGINT,
"liwc_3rd_pers" BIGINT,
"liwc_achievement" BIGINT,
"liwc_adverbs" BIGINT,
"liwc_affective_processes" BIGINT,
"liwc_anger" BIGINT,
"liwc_anxiety" BIGINT,
"liwc_articles_article" BIGINT,
"liwc_assent" BIGINT,
"liwc_auxiliary_verbs" BIGINT,
"liwc_biological" BIGINT,
"liwc_body" BIGINT,
"liwc_causation" BIGINT,
"liwc_certainty" BIGINT,
"liwc_cognitive" BIGINT,
"liwc_common_verbs" BIGINT,
"liwc_conjunctions" BIGINT,
"liwc_death" BIGINT,
"liwc_discrepancy" BIGINT,
"liwc_exclusive" BIGINT,
"liwc_family" BIGINT,
"liwc_feel" BIGINT,
"liwc_fillers" BIGINT,
"liwc_friends" BIGINT,
"liwc_future_tense" BIGINT,
"liwc_health" BIGINT,
"liwc_hear" BIGINT,
"liwc_home" BIGINT,
"liwc_humans" BIGINT,
"liwc_impersonal_pronouns" BIGINT,
"liwc_inclusive" BIGINT,
"liwc_ingestion" BIGINT,
"liwc_inhibition" BIGINT,
"liwc_insight" BIGINT,
"liwc_leisure" BIGINT,
"liwc_money" BIGINT,
"liwc_motion" BIGINT,
"liwc_negations" BIGINT,
"liwc_negative_emotion" BIGINT,
"liwc_nonfluencies" BIGINT,
"liwc_numbers" BIGINT,
"liwc_past_tense" BIGINT,
"liwc_perceptual_processes" BIGINT,
"liwc_personal_pronouns" BIGINT,
"liwc_positive_emotion" BIGINT,
"liwc_prepositions" BIGINT,
"liwc_present_tense" BIGINT,
"liwc_quantifiers" BIGINT,
"liwc_relativity" BIGINT,
"liwc_religion" BIGINT,
"liwc_sadness" BIGINT,
"liwc_see" BIGINT,
"liwc_sexual" BIGINT,
"liwc_social_processes" BIGINT,
"liwc_space" BIGINT,
"liwc_swear_words" BIGINT,
"liwc_tentative" BIGINT,
"liwc_time" BIGINT,
"liwc_total_functional" BIGINT,
"liwc_total_pronouns" BIGINT,
"liwc_work" BIGINT,
"tfidf_abl" DOUBLE,
"tfidf_abus" DOUBLE,
"tfidf_actual" DOUBLE,
"tfidf_addict" DOUBLE,
"tfidf_adhd" DOUBLE,
"tfidf_advic" DOUBLE
);
CREATE TABLE bipolarreddit_post_features_tfidf_256 (
"subreddit" VARCHAR,
"author" VARCHAR,
"date" VARCHAR,
"post" VARCHAR,
"automated_readability_index" DOUBLE,
"coleman_liau_index" DOUBLE,
"flesch_kincaid_grade_level" DOUBLE,
"flesch_reading_ease" DOUBLE,
"gulpease_index" DOUBLE,
"gunning_fog_index" DOUBLE,
"lix" DOUBLE,
"smog_index" DOUBLE,
"wiener_sachtextformel" DOUBLE,
"n_chars" BIGINT,
"n_long_words" BIGINT,
"n_monosyllable_words" BIGINT,
"n_polysyllable_words" BIGINT,
"n_sents" BIGINT,
"n_syllables" BIGINT,
"n_unique_words" BIGINT,
"n_words" BIGINT,
"sent_neg" DOUBLE,
"sent_neu" DOUBLE,
"sent_pos" DOUBLE,
"sent_compound" DOUBLE,
"economic_stress_total" BIGINT,
"isolation_total" BIGINT,
"substance_use_total" BIGINT,
"guns_total" BIGINT,
"domestic_stress_total" BIGINT,
"suicidality_total" BIGINT,
"punctuation" DOUBLE,
"liwc_1st_pers" BIGINT,
"liwc_2nd_pers" BIGINT,
"liwc_3rd_pers" BIGINT,
"liwc_achievement" BIGINT,
"liwc_adverbs" BIGINT,
"liwc_affective_processes" BIGINT,
"liwc_anger" BIGINT,
"liwc_anxiety" BIGINT,
"liwc_articles_article" BIGINT,
"liwc_assent" BIGINT,
"liwc_auxiliary_verbs" BIGINT,
"liwc_biological" BIGINT,
"liwc_body" BIGINT,
"liwc_causation" BIGINT,
"liwc_certainty" BIGINT,
"liwc_cognitive" BIGINT,
"liwc_common_verbs" BIGINT,
"liwc_conjunctions" BIGINT,
"liwc_death" BIGINT,
"liwc_discrepancy" BIGINT,
"liwc_exclusive" BIGINT,
"liwc_family" BIGINT,
"liwc_feel" BIGINT,
"liwc_fillers" BIGINT,
"liwc_friends" BIGINT,
"liwc_future_tense" BIGINT,
"liwc_health" BIGINT,
"liwc_hear" BIGINT,
"liwc_home" BIGINT,
"liwc_humans" BIGINT,
"liwc_impersonal_pronouns" BIGINT,
"liwc_inclusive" BIGINT,
"liwc_ingestion" BIGINT,
"liwc_inhibition" BIGINT,
"liwc_insight" BIGINT,
"liwc_leisure" BIGINT,
"liwc_money" BIGINT,
"liwc_motion" BIGINT,
"liwc_negations" BIGINT,
"liwc_negative_emotion" BIGINT,
"liwc_nonfluencies" BIGINT,
"liwc_numbers" BIGINT,
"liwc_past_tense" BIGINT,
"liwc_perceptual_processes" BIGINT,
"liwc_personal_pronouns" BIGINT,
"liwc_positive_emotion" BIGINT,
"liwc_prepositions" BIGINT,
"liwc_present_tense" BIGINT,
"liwc_quantifiers" BIGINT,
"liwc_relativity" BIGINT,
"liwc_religion" BIGINT,
"liwc_sadness" BIGINT,
"liwc_see" BIGINT,
"liwc_sexual" BIGINT,
"liwc_social_processes" BIGINT,
"liwc_space" BIGINT,
"liwc_swear_words" BIGINT,
"liwc_tentative" BIGINT,
"liwc_time" BIGINT,
"liwc_total_functional" BIGINT,
"liwc_total_pronouns" BIGINT,
"liwc_work" BIGINT,
"tfidf_abl" DOUBLE,
"tfidf_abus" DOUBLE,
"tfidf_actual" DOUBLE,
"tfidf_addict" DOUBLE,
"tfidf_adhd" DOUBLE,
"tfidf_advic" DOUBLE
);
CREATE TABLE bipolarreddit_pre_features_tfidf_256 (
"subreddit" VARCHAR,
"author" VARCHAR,
"date" VARCHAR,
"post" VARCHAR,
"automated_readability_index" DOUBLE,
"coleman_liau_index" DOUBLE,
"flesch_kincaid_grade_level" DOUBLE,
"flesch_reading_ease" DOUBLE,
"gulpease_index" DOUBLE,
"gunning_fog_index" DOUBLE,
"lix" DOUBLE,
"smog_index" DOUBLE,
"wiener_sachtextformel" DOUBLE,
"n_chars" BIGINT,
"n_long_words" BIGINT,
"n_monosyllable_words" BIGINT,
"n_polysyllable_words" BIGINT,
"n_sents" BIGINT,
"n_syllables" BIGINT,
"n_unique_words" BIGINT,
"n_words" BIGINT,
"sent_neg" DOUBLE,
"sent_neu" DOUBLE,
"sent_pos" DOUBLE,
"sent_compound" DOUBLE,
"economic_stress_total" BIGINT,
"isolation_total" BIGINT,
"substance_use_total" BIGINT,
"guns_total" BIGINT,
"domestic_stress_total" BIGINT,
"suicidality_total" BIGINT,
"punctuation" DOUBLE,
"liwc_1st_pers" BIGINT,
"liwc_2nd_pers" BIGINT,
"liwc_3rd_pers" BIGINT,
"liwc_achievement" BIGINT,
"liwc_adverbs" BIGINT,
"liwc_affective_processes" BIGINT,
"liwc_anger" BIGINT,
"liwc_anxiety" BIGINT,
"liwc_articles_article" BIGINT,
"liwc_assent" BIGINT,
"liwc_auxiliary_verbs" BIGINT,
"liwc_biological" BIGINT,
"liwc_body" BIGINT,
"liwc_causation" BIGINT,
"liwc_certainty" BIGINT,
"liwc_cognitive" BIGINT,
"liwc_common_verbs" BIGINT,
"liwc_conjunctions" BIGINT,
"liwc_death" BIGINT,
"liwc_discrepancy" BIGINT,
"liwc_exclusive" BIGINT,
"liwc_family" BIGINT,
"liwc_feel" BIGINT,
"liwc_fillers" BIGINT,
"liwc_friends" BIGINT,
"liwc_future_tense" BIGINT,
"liwc_health" BIGINT,
"liwc_hear" BIGINT,
"liwc_home" BIGINT,
"liwc_humans" BIGINT,
"liwc_impersonal_pronouns" BIGINT,
"liwc_inclusive" BIGINT,
"liwc_ingestion" BIGINT,
"liwc_inhibition" BIGINT,
"liwc_insight" BIGINT,
"liwc_leisure" BIGINT,
"liwc_money" BIGINT,
"liwc_motion" BIGINT,
"liwc_negations" BIGINT,
"liwc_negative_emotion" BIGINT,
"liwc_nonfluencies" BIGINT,
"liwc_numbers" BIGINT,
"liwc_past_tense" BIGINT,
"liwc_perceptual_processes" BIGINT,
"liwc_personal_pronouns" BIGINT,
"liwc_positive_emotion" BIGINT,
"liwc_prepositions" BIGINT,
"liwc_present_tense" BIGINT,
"liwc_quantifiers" BIGINT,
"liwc_relativity" BIGINT,
"liwc_religion" BIGINT,
"liwc_sadness" BIGINT,
"liwc_see" BIGINT,
"liwc_sexual" BIGINT,
"liwc_social_processes" BIGINT,
"liwc_space" BIGINT,
"liwc_swear_words" BIGINT,
"liwc_tentative" BIGINT,
"liwc_time" BIGINT,
"liwc_total_functional" BIGINT,
"liwc_total_pronouns" BIGINT,
"liwc_work" BIGINT,
"tfidf_abl" DOUBLE,
"tfidf_abus" DOUBLE,
"tfidf_actual" DOUBLE,
"tfidf_addict" DOUBLE,
"tfidf_adhd" DOUBLE,
"tfidf_advic" DOUBLE
);
CREATE TABLE bpd_2018_features_tfidf_256 (
"subreddit" VARCHAR,
"author" VARCHAR,
"date" VARCHAR,
"post" VARCHAR,
"automated_readability_index" DOUBLE,
"coleman_liau_index" DOUBLE,
"flesch_kincaid_grade_level" DOUBLE,
"flesch_reading_ease" DOUBLE,
"gulpease_index" DOUBLE,
"gunning_fog_index" DOUBLE,
"lix" DOUBLE,
"smog_index" DOUBLE,
"wiener_sachtextformel" DOUBLE,
"n_chars" BIGINT,
"n_long_words" BIGINT,
"n_monosyllable_words" BIGINT,
"n_polysyllable_words" BIGINT,
"n_sents" BIGINT,
"n_syllables" BIGINT,
"n_unique_words" BIGINT,
"n_words" BIGINT,
"sent_neg" DOUBLE,
"sent_neu" DOUBLE,
"sent_pos" DOUBLE,
"sent_compound" DOUBLE,
"economic_stress_total" BIGINT,
"isolation_total" BIGINT,
"substance_use_total" BIGINT,
"guns_total" BIGINT,
"domestic_stress_total" BIGINT,
"suicidality_total" BIGINT,
"punctuation" DOUBLE,
"liwc_1st_pers" BIGINT,
"liwc_2nd_pers" BIGINT,
"liwc_3rd_pers" BIGINT,
"liwc_achievement" BIGINT,
"liwc_adverbs" BIGINT,
"liwc_affective_processes" BIGINT,
"liwc_anger" BIGINT,
"liwc_anxiety" BIGINT,
"liwc_articles_article" BIGINT,
"liwc_assent" BIGINT,
"liwc_auxiliary_verbs" BIGINT,
"liwc_biological" BIGINT,
"liwc_body" BIGINT,
"liwc_causation" BIGINT,
"liwc_certainty" BIGINT,
"liwc_cognitive" BIGINT,
"liwc_common_verbs" BIGINT,
"liwc_conjunctions" BIGINT,
"liwc_death" BIGINT,
"liwc_discrepancy" BIGINT,
"liwc_exclusive" BIGINT,
"liwc_family" BIGINT,
"liwc_feel" BIGINT,
"liwc_fillers" BIGINT,
"liwc_friends" BIGINT,
"liwc_future_tense" BIGINT,
"liwc_health" BIGINT,
"liwc_hear" BIGINT,
"liwc_home" BIGINT,
"liwc_humans" BIGINT,
"liwc_impersonal_pronouns" BIGINT,
"liwc_inclusive" BIGINT,
"liwc_ingestion" BIGINT,
"liwc_inhibition" BIGINT,
"liwc_insight" BIGINT,
"liwc_leisure" BIGINT,
"liwc_money" BIGINT,
"liwc_motion" BIGINT,
"liwc_negations" BIGINT,
"liwc_negative_emotion" BIGINT,
"liwc_nonfluencies" BIGINT,
"liwc_numbers" BIGINT,
"liwc_past_tense" BIGINT,
"liwc_perceptual_processes" BIGINT,
"liwc_personal_pronouns" BIGINT,
"liwc_positive_emotion" BIGINT,
"liwc_prepositions" BIGINT,
"liwc_present_tense" BIGINT,
"liwc_quantifiers" BIGINT,
"liwc_relativity" BIGINT,
"liwc_religion" BIGINT,
"liwc_sadness" BIGINT,
"liwc_see" BIGINT,
"liwc_sexual" BIGINT,
"liwc_social_processes" BIGINT,
"liwc_space" BIGINT,
"liwc_swear_words" BIGINT,
"liwc_tentative" BIGINT,
"liwc_time" BIGINT,
"liwc_total_functional" BIGINT,
"liwc_total_pronouns" BIGINT,
"liwc_work" BIGINT,
"tfidf_abl" DOUBLE,
"tfidf_abus" DOUBLE,
"tfidf_actual" DOUBLE,
"tfidf_addict" DOUBLE,
"tfidf_adhd" DOUBLE,
"tfidf_advic" DOUBLE
);
Anyone who has the link will be able to view this.