CEPHIA HIV Recency Assay Data
Global Assay Results and Participant Characteristics
@kaggle.thedevastator_cephia_hiv_recency_assay_data
Global Assay Results and Participant Characteristics
@kaggle.thedevastator_cephia_hiv_recency_assay_data
CREATE TABLE cephia_public_use_dataset_20210604 (
"assay" VARCHAR,
"cephia_panel" VARCHAR,
"testing_laboratory" VARCHAR,
"test_date" TIMESTAMP,
"assay_result_field" VARCHAR,
"assay_result_value" DOUBLE,
"assay_result_method" VARCHAR,
"specific_result_identifier" BIGINT,
"generic_result_identifier" BIGINT,
"participant_identifier" BIGINT,
"visit_identifier" BIGINT,
"specimen_type" VARCHAR,
"hiv_status_at_visit" VARCHAR,
"cohort_entry_hiv_status" VARCHAR,
"days_since_cohort_entry" BIGINT,
"hiv_subtype" VARCHAR,
"hiv_subtype_confirmed" BOOLEAN,
"country" VARCHAR,
"sex" VARCHAR,
"age_in_years" DOUBLE,
"eddi_interval_size" DOUBLE,
"days_since_eddi" DOUBLE,
"days_since_ep_ddi" DOUBLE,
"days_since_lp_ddi" DOUBLE,
"designated_as_elite_controller_at_visit" BOOLEAN,
"ever_designated_as_elite_controller" BOOLEAN,
"treatment_naive_at_visit" BOOLEAN,
"on_treatment_at_visit" BOOLEAN,
"first_treatment_episode" VARCHAR,
"days_since_first_art" DOUBLE,
"days_since_current_art" DOUBLE,
"days_from_eddi_to_first_art" DOUBLE,
"days_from_eddi_to_current_art" DOUBLE,
"viral_load_closest_to_visit" DOUBLE,
"viral_load_date_offset_from_visit_date" DOUBLE,
"viral_load_type" VARCHAR,
"viral_load_detectable" VARCHAR,
"cd4_count_at_visit" DOUBLE
);
Anyone who has the link will be able to view this.