{"dry_run":true,"input_files":[{"columns":["tv_id","original_model_number","normalized_model_number","alternative_model_numbers","series","screen_size","model_year","tv_type","region","one_connect_present","model_scope","source_type","source_url","source_location","source_evidence","review_status"],"filename":"01_tvs_clean.csv","row_count":43},{"columns":["box_id","original_part_number","normalized_part_number","box_name","box_type","soc_label","model_year","region_of_source","region_of_device","related_tv_models","status","confidence","source_type","source_url","source_location","evidence_text","review_status","notes"],"filename":"02_connect_boxes_clean.csv","row_count":36},{"columns":["cable_id","original_part_number","normalized_part_number","cable_name","cable_type","length","region_of_source","region_of_device","related_tv_models","status","confidence","source_type","source_url","source_location","evidence_text","review_status","notes"],"filename":"03_cables_clean.csv","row_count":9},{"columns":["relation_id","tv_model","box_part_number","region_of_source","region_of_device","model_year","status","confidence","source_type","source_url","source_location","evidence_text","direct_or_derived","review_status","notes"],"filename":"04_tv_box_relations.csv","row_count":44},{"columns":["relation_id","tv_model","series_or_scope","cable_part_number","region_of_source","region_of_device","model_year","status","confidence","source_type","source_url","source_location","evidence_text","direct_or_derived","review_status","notes"],"filename":"05_tv_cable_relations.csv","row_count":38},{"columns":["issue_id","issue_type","tv_model","box_part_number","cable_part_number","region","status","confidence","source_url","description","required_action"],"filename":"06_conflicts_and_unverified.csv","row_count":50}],"openai_request":false,"web_research":false,"work_packages":[{"input_files":["01_tvs_clean.csv"],"input_record_count":43,"key":"tv_models_one_connect","name":"TV-Modelle mit One Connect","passes":["PASS_1_DISCOVERY","PASS_2_VERIFICATION","PASS_3_CONFLICT_REVIEW","PASS_4_FINAL_REVIEW"],"would_write":{"csv":"master_PREVIEW_tv_models_one_connect.csv","raw":"master_PREVIEW_tv_models_one_connect.json","validated":"master_PREVIEW_tv_models_one_connect.validated.json"}},{"input_files":["02_connect_boxes_clean.csv"],"input_record_count":36,"key":"one_connect_boxes","name":"One Connect Boxen","passes":["PASS_1_DISCOVERY","PASS_2_VERIFICATION","PASS_3_CONFLICT_REVIEW","PASS_4_FINAL_REVIEW"],"would_write":{"csv":"master_PREVIEW_one_connect_boxes.csv","raw":"master_PREVIEW_one_connect_boxes.json","validated":"master_PREVIEW_one_connect_boxes.validated.json"}},{"input_files":["03_cables_clean.csv"],"input_record_count":9,"key":"one_connect_cables","name":"One Connect Kabel","passes":["PASS_1_DISCOVERY","PASS_2_VERIFICATION","PASS_3_CONFLICT_REVIEW","PASS_4_FINAL_REVIEW"],"would_write":{"csv":"master_PREVIEW_one_connect_cables.csv","raw":"master_PREVIEW_one_connect_cables.json","validated":"master_PREVIEW_one_connect_cables.validated.json"}},{"input_files":["01_tvs_clean.csv","02_connect_boxes_clean.csv","04_tv_box_relations.csv"],"input_record_count":123,"key":"tv_to_box","name":"TV zu One Connect Box","passes":["PASS_1_DISCOVERY","PASS_2_VERIFICATION","PASS_3_CONFLICT_REVIEW","PASS_4_FINAL_REVIEW"],"would_write":{"csv":"master_PREVIEW_tv_to_box.csv","raw":"master_PREVIEW_tv_to_box.json","validated":"master_PREVIEW_tv_to_box.validated.json"}},{"input_files":["01_tvs_clean.csv","03_cables_clean.csv","05_tv_cable_relations.csv"],"input_record_count":90,"key":"tv_to_cable","name":"TV zu Kabel","passes":["PASS_1_DISCOVERY","PASS_2_VERIFICATION","PASS_3_CONFLICT_REVIEW","PASS_4_FINAL_REVIEW"],"would_write":{"csv":"master_PREVIEW_tv_to_cable.csv","raw":"master_PREVIEW_tv_to_cable.json","validated":"master_PREVIEW_tv_to_cable.validated.json"}},{"input_files":["02_connect_boxes_clean.csv","03_cables_clean.csv","04_tv_box_relations.csv","05_tv_cable_relations.csv"],"input_record_count":127,"key":"box_to_cable","name":"One Connect Box zu Kabel","passes":["PASS_1_DISCOVERY","PASS_2_VERIFICATION","PASS_3_CONFLICT_REVIEW","PASS_4_FINAL_REVIEW"],"would_write":{"csv":"master_PREVIEW_box_to_cable.csv","raw":"master_PREVIEW_box_to_cable.json","validated":"master_PREVIEW_box_to_cable.validated.json"}},{"input_files":["06_conflicts_and_unverified.csv"],"input_record_count":50,"key":"conflicts_unclear_models","name":"Konflikte und unklare Modellnummern","passes":["PASS_1_DISCOVERY","PASS_2_VERIFICATION","PASS_3_CONFLICT_REVIEW","PASS_4_FINAL_REVIEW"],"would_write":{"csv":"master_PREVIEW_conflicts_unclear_models.csv","raw":"master_PREVIEW_conflicts_unclear_models.json","validated":"master_PREVIEW_conflicts_unclear_models.validated.json"}}]}