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



Source file: 'idp/idps_2504r14ncnw4sa.csv' (the number of rows 1734 and number of cols 50; output format: '==Column type (length) --> Target column name:')
DATE (17330) --> col11a1Dateofcurrentsurvey
TEXT (56360) --> col11b3PopulationGroup
TEXT (22488) --> HowwasthisLocationassessed
TEXT (25384) --> Isthelocationfullyaccessiblefullgeographicinformationcanbecollectedorpartiallyaccessiblequickgeographicinformationgatheredonly
TEXT (2656) --> Reasonsforinaccessibility
TEXT (19103) --> Region
TEXT (10763) --> State
TEXT (8665) --> STATE_Pcode
TEXT (11632) --> LGA
TEXT (13864) --> LGA_Pcode
TEXT (14678) --> Ward
TEXT (19063) --> WARD_CODE
TEXT (23576) --> SiteType
TEXT (23796) --> SiteClassification
TEXT (18863) --> SiteName
TEXT (12131) --> SiteIDSSID
INTEGER (3743) --> NumberofHouseholds
INTEGER (5085) --> NumberofIndividuals
TEXT (23452) --> SiteStatusIfCamp
DATE (17280) --> SiteStartDate
TEXT (8665) --> col11f5SiteClass
TEXT (33762) --> col15g2ReasonofdisplacementofmajorityofIDPsinthesite
TEXT (43603) --> col13g4SettlementsitetypeIDPs
TEXT (22083) --> col21g1Methodologyused
INTEGER (2262) --> IDPHHsArrivalin2024
INTEGER (2843) --> IDPINDArrivalin2024
INTEGER (2448) --> IDPHHsArrivalin2023
INTEGER (3145) --> IDPINDArrivalin2023
INTEGER (2363) --> IDPHHArrivalin2022
INTEGER (3015) --> IDPINDArrivalin2022
INTEGER (2364) --> IDPHHArrivalin2021
INTEGER (2987) --> IDPINDArrivalin2021
INTEGER (2776) --> IDPHHArrivalBefore202120142020
INTEGER (3742) --> IDPINDArrivalBefore202120142020
INTEGER (3743) --> total_hhs
INTEGER (5085) --> total_ind
INTEGER (2600) --> MaleInfants1y
INTEGER (2700) --> FemaleInfants1y
INTEGER (3005) --> MaleChildren15y
INTEGER (3103) --> FemaleChildren15y
INTEGER (3189) --> MaleChildren612y
INTEGER (3289) --> FemaleChildren612y
INTEGER (3317) --> MaleYouth1317y
INTEGER (3428) --> FemaleYouth1317y
INTEGER (3690) --> MaleAdults1859y
INTEGER (3875) --> FemaleAdults1859y
INTEGER (2441) --> MaleElderly60y
INTEGER (2539) --> FemaleElderly60y
INTEGER (4498) --> TotalMale
INTEGER (4632) --> TotalFemale
