
=== Tue May 19 08:32:01 GMT 2026 RUN: tclsh /prs/igistk/c/csv2sqlite.tcl idp/idps_2503r16ncnw4sa.csv /home/wdeb/idps/nga/idps16.sdb



Source file: 'idp/idps_2503r16ncnw4sa.csv' (the number of rows 1762 and number of cols 37; output format: '==Column type (length) --> Target column name:')
TEXT (57690) --> PopulationGroup
TEXT (19452) --> Region
TEXT (10933) --> State
TEXT (11809) --> LGA
TEXT (14953) --> Ward
TEXT (27486) --> SiteType
TEXT (27560) --> SiteClassification
TEXT (12327) --> SiteIDSSID
TEXT (18999) --> SiteName
TEXT (774) --> SiteStatusIfCamp
INTEGER (3848) --> NumberofHouseholds
INTEGER (5243) --> NumberofIndividuals
TEXT (33129) --> ReasonofdisplacementofmajorityofIDPsinthesite
INTEGER (2646) --> IDPHHsArrivalin2024
INTEGER (3400) --> IDPINDArrivalin2024
INTEGER (2438) --> IDPHHsArrivalin2023
INTEGER (3153) --> IDPINDArrivalin2023
INTEGER (2347) --> IDPHHArrivalin2022
INTEGER (3025) --> IDPINDArrivalin2022
INTEGER (2337) --> IDPHHArrivalin2021
INTEGER (2964) --> IDPINDArrivalin2021
INTEGER (2754) --> IDPHHArrivalBefore202120142020
INTEGER (3671) --> IDPINDArrivalBefore202120142020
INTEGER (2680) --> MaleInfants1y
INTEGER (2806) --> FemaleInfants1y
INTEGER (3148) --> MaleChildren15y
INTEGER (3252) --> FemaleChildren15y
INTEGER (3340) --> MaleChildren612y
INTEGER (3447) --> FemaleChildren612y
INTEGER (3440) --> MaleYouth1317y
INTEGER (3540) --> FemaleYouth1317y
INTEGER (3791) --> MaleAdults1859y
INTEGER (3970) --> FemaleAdults1859y
INTEGER (2527) --> MaleElderly60y
INTEGER (2664) --> FemaleElderly60y
INTEGER (4625) --> TotalMale
INTEGER (4796) --> TotalFemale
