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



Source file: 'idp/idps_2307r10ncnw4sa.csv' (the number of rows 1691 and number of cols 44; output format: '==Column type (length) --> Target column name:')
TEXT (5070) --> SurveyRound
TEXT (16900) --> Dateofcurrentsurvey
TEXT (24872) --> IDPLocationType
TEXT (10556) --> State
TEXT (10140) --> StatePcode
TEXT (11369) --> LGA
TEXT (15210) --> LGAPcode
TEXT (13302) --> Ward
TEXT (11830) --> SITEID
TEXT (17629) --> SiteName
TEXT (13608) --> GPSLatitudeN
TEXT (13240) --> GPSLongitudeE
TEXT (16320) --> Sitestartdate
TEXT (120) --> Closingdate
TEXT (8450) --> SiteClassification
TEXT (6760) --> PopulationType
TEXT (33820) --> Reasonfordisplacement
TEXT (9769) --> IfOtherspecify
TEXT (54) --> ReasonforReturning
INTEGER (0) --> Ifotherspecify2
TEXT (42692) --> Settlementsitetype
TEXT (26341) --> Methodologyused
INTEGER (3539) --> NumberofHouseholds
INTEGER (4821) --> NumberofIndividuals
INTEGER (2403) --> MaleInfants1y
INTEGER (2838) --> MaleChildren15y
INTEGER (3015) --> MaleChildren612y
INTEGER (3113) --> MaleYouth1317y
INTEGER (3519) --> MaleAdults1859y
INTEGER (2235) --> MaleElderly60y
INTEGER (2522) --> FemaleInfants1y
INTEGER (2960) --> FemaleChildren15y
INTEGER (3131) --> FemaleChildren612y
INTEGER (3228) --> FemaleYouth1317y
INTEGER (3673) --> FemaleAdults1859y
INTEGER (2355) --> FemaleElderly60y
INTEGER (4298) --> Total_male
INTEGER (4417) --> Total_female
INTEGER (2308) --> YearofArrival2022Households
INTEGER (2873) --> YearofArrival2022Individuals
INTEGER (2501) --> YearofArrival2021Households
INTEGER (3215) --> YearofArrival2021Individuals
INTEGER (2939) --> YearofArrivalBefore20202014Households
INTEGER (4031) --> YearofArrivalBefore20202014Individuals
