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



Source file: 'idp/idps_2404r45ne4sa.csv' (the number of rows 2349 and number of cols 37; output format: '==Column type (length) --> Target column name:')
TEXT (23480) --> DateofSurvey
TEXT (74015) --> PopulationType
TEXT (12867) --> State
TEXT (11740) --> StatePCode
TEXT (14915) --> LGA
TEXT (18784) --> LGAPCode
TEXT (23047) --> Ward
TEXT (16436) --> SSID
TEXT (23779) --> SiteName
INTEGER (5149) --> Households
INTEGER (6936) --> Individuals
TEXT (24909) --> SiteStartDate
TEXT (11740) --> SiteClassification
TEXT (24558) --> Reasonfordisplacement
TEXT (52766) --> Settlementsitetype
INTEGER (2521) --> HHsarrivedtotheLocationin2023
INTEGER (2769) --> INDsarrivedtotheLocationin2023
INTEGER (2856) --> HHsarrivedtotheLocationin2022
INTEGER (3471) --> INDsarrivedtotheLocationin2022
INTEGER (2906) --> HHsarrivedtotheLocationin2021
INTEGER (3678) --> INDsarrivedtotheLocationin2021
INTEGER (4951) --> HHsarrivedtotheLocationbefore202120142020
INTEGER (6668) --> INDsarrivedtotheLocationbefore202120142020
INTEGER (3402) --> MaleInfants1y
INTEGER (3680) --> FemaleInfants1y
INTEGER (4242) --> MaleChildren15y
INTEGER (4378) --> FemaleChildren15y
INTEGER (4487) --> MaleChildren612y
INTEGER (4415) --> FemaleChildren612y
INTEGER (4370) --> MaleYouth1317y
INTEGER (4603) --> FemaleYouth1317y
INTEGER (5013) --> MaleAdults1859y
INTEGER (5126) --> FemaleAdults1859y
INTEGER (3434) --> MaleElderly60y
INTEGER (3231) --> FemaleElderly60y
INTEGER (6118) --> TotalMale
INTEGER (6268) --> TotalFemale
