
=== Tue May 19 08:29:13 GMT 2026 RUN: tclsh /prs/igistk/c/csv2sqlite.tcl idp/idps_2211r43ne4sa.csv /home/wdeb/idps/nga/idps1.sdb



Source file: 'idp/idps_2211r43ne4sa.csv' (the number of rows 2451 and number of cols 35; output format: '==Column type (length) --> Target column name:')
TEXT (24470) --> DateofSurvey
TEXT (79854) --> Populationtype
TEXT (13308) --> State
TEXT (15418) --> LGA
TEXT (23870) --> Ward
TEXT (17129) --> SSID
TEXT (25116) --> SITENAME
REAL (18847) --> latitude
REAL (19175) --> longitude
INTEGER (5406) --> Households
INTEGER (7251) --> Individuals
TEXT (22005) --> Sitestartdate
TEXT (12235) --> SiteClassification
TEXT (25728) --> ReasonofdisplacementofmajorityofIDPs
TEXT (60810) --> col13g4Settlementsitetype
INTEGER (2955) --> HHsarrivedtothelocationin2022
INTEGER (3583) --> INDsarrivedtothelocationin2022
INTEGER (3061) --> HHsarrivedtothelocationin2021
INTEGER (3857) --> INDsarrivedtothelocationin2021
INTEGER (5153) --> HHsarrivedtothelocationbefore202120142020
INTEGER (6930) --> INDsarrivedtothelocationbefore202120142020
INTEGER (3466) --> MaleInfants1y
INTEGER (3662) --> FemaleInfants1y
INTEGER (4403) --> MaleChildren15y
INTEGER (4566) --> FemaleChildren15y
INTEGER (4583) --> MaleChildren612y
INTEGER (4732) --> FemaleChildren612y
INTEGER (4648) --> MaleYouth1317y
INTEGER (4826) --> FemaleYouth1317y
INTEGER (5303) --> MaleAdults1859y
INTEGER (5422) --> FemaleAdults1859y
INTEGER (3194) --> MaleElderly60y
INTEGER (3193) --> FemaleElderly60y
INTEGER (6347) --> Totalmale
INTEGER (6582) --> Totalfemale
