
=== Tue May 19 08:31:49 GMT 2026 RUN: tclsh /prs/igistk/c/csv2sqlite.tcl idp/idps_2206r9ncnw4ba.csv /home/wdeb/idps/nga/idps12.sdb



Source file: 'idp/idps_2206r9ncnw4ba.csv' (the number of rows 860 and number of cols 59; output format: '==Column type (length) --> Target column name:')
TEXT (4295) --> StatePcode
TEXT (5366) --> StateofDisplacement
TEXT (6872) --> LGAPcode
TEXT (5798) --> LGA
TEXT (7249) --> WARD
INTEGER (1934) --> EstimatedHouseholdNumber
INTEGER (2596) --> EstimatedNumberofIDP
INTEGER (3436) --> YearofDisplacementofMajority
TEXT (23489) --> IDPcategory
TEXT (1718) --> StateofOriginofMajority_code
TEXT (5417) --> StateofOriginofMajority
TEXT (3436) --> LGAofOriginofMajority_code
TEXT (5483) --> LGAofOriginofMajority
TEXT (1866) --> DisplacementReason_insurgency_YesNo
INTEGER (266) --> DisplacementReason_insurg_HouseholdNumber
INTEGER (378) --> DisplacementReason_insurg_EstimatedNumberofIDP
TEXT (2074) --> DisplacementReason_clash_YesNo
INTEGER (800) --> DisplacementReason_clash_EstimatedHouseholdNumber
INTEGER (1068) --> DisplacementReason_clash_EstimatedNumberofIDP
TEXT (1927) --> DisplacementReason_disaster_YesNo
INTEGER (407) --> DisplacementReason_disaster_EstimatedHouseholdNumber
INTEGER (569) --> DisplacementReason_disaster_EstimatedNumberofIDP
TEXT (2088) --> DisplacementReason_others_YesNo
INTEGER (810) --> DisplacementReason_others_EstimatedHouseholdNumber
INTEGER (1102) --> DisplacementReason_others_EstimatedNumberofIDP
TEXT (2077) --> IDPs_fromLGA_displaced_InWard_YesNo
INTEGER (838) --> IDPHH_fromLGA_displaced_InWard
INTEGER (1121) --> IDPIND_fromLGAdisplaced_InWard
TEXT (718) --> StateCode_Previous_StateofDisplacement
TEXT (2338) --> StateName_Previous_StateofDisplacement
TEXT (1436) --> LGACode_Previous_StateofDisplacementoflargestgroup1
TEXT (2258) --> LGAName_Previous_StateofDisplacement
DATE (3496) --> DateofarrivallargestIDPgroup1
INTEGER (791) --> IDPHHoflargestGroup1
INTEGER (1086) --> IDPINDoflargestGroup1
TEXT (288) --> StateCode_Previous_displacementofLargestGroup2
TEXT (933) --> StateName_Previous_displacementofLargestGroup2
TEXT (576) --> LGACode_Previous_displacementofLargestGroup2
TEXT (892) --> LGAName_Previous_displacementofLargestGroup2
DATE (1450) --> DateofarrivallargestIDPgroup2
INTEGER (297) --> IDPHHoflargestGroup2
INTEGER (414) --> IDPINDoflargestGroup2
TEXT (2566) --> Displaced_FirstTime_Displacement_YesNo
INTEGER (2461) --> Displaced_FirstTime_Displacement_Percent
TEXT (1811) --> Displaced_2TIMES_Displacement_YesNo
INTEGER (193) --> Displaced_2TIMES_Displacement_Percent
TEXT (186) --> Displaced_2TIMES_Displacement_STATECode
TEXT (372) --> Displaced_2TIMES_Displacement_LGACode
TEXT (649) --> Displaced_2TIMES_Displacement_Date
TEXT (1725) --> Displaced_3TIMES_Displacement_YesNo
INTEGER (13) --> Displaced_3TIMES_Displacement_Percent
TEXT (14) --> Displaced_3TIMES_Displacement_STATECode
TEXT (28) --> Displaced_3TIMES_Displacement_LGACode
TEXT (42) --> Displaced_3TIMES_Displacement_Date
TEXT (1723) --> Displaced_3TIMES_More_Displacement_YesNo
INTEGER (9) --> Displaced_3TIMES_More_Displacement__Percent
TEXT (10) --> Displaced_3TIMES_More_Displacement__STATECode
TEXT (20) --> Displaced_3TIMES_More_Displacement_LGACode
TEXT (30) --> Displaced_3TIMES_More_Displacement_Date
