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



Source file: 'idp/idps_2407r13ncnw4sa.csv' (the number of rows 1647 and number of cols 47; output format: '==Column type (length) --> Target column name:')
TEXT (4938) --> SurveyRound
TEXT (16460) --> DateofSurvey
INTEGER (1646) --> NumberofKIs
TEXT (54116) --> PopulationTypes
TEXT (4864) --> SiteAccessible
TEXT (1170) --> ReasonsforInaccessibility
TEXT (18026) --> Region
TEXT (10288) --> State
TEXT (9876) --> StatePcode
TEXT (11035) --> LGA
TEXT (14814) --> LGAPcode
TEXT (13271) --> Ward
TEXT (18972) --> WardPcode
TEXT (11522) --> SiteID
TEXT (17392) --> SiteName
REAL (13096) --> Latitude
REAL (12209) --> Longitude
DATE (15880) --> SiteStartDate
TEXT (22736) --> SiteClassification
TEXT (22458) --> SiteStatus
TEXT (22698) --> SiteType
TEXT (8230) --> SettlementType
TEXT (24707) --> LandOwnership
TEXT (28486) --> MostCommontypeofShelter
TEXT (31123) --> ReasonsofDisplacement
INTEGER (3546) --> Households
INTEGER (4805) --> Individuals
INTEGER (1488) --> HHsArrivalIn2023
INTEGER (2133) --> INDsArrivalIn2023
INTEGER (1500) --> HHsArrivalIn2022
INTEGER (2157) --> INDsArrivalIn2022
INTEGER (1483) --> HHsArrivalIn2021
INTEGER (2113) --> INDsArrivalIn2021
INTEGER (2315) --> HHsArrivalBefore202120142020
INTEGER (3254) --> INDsArrivalBefore202120142020
INTEGER (2445) --> MaleInfants1y
INTEGER (2784) --> FemaleInfants1y
INTEGER (2947) --> MaleChildren15y
INTEGER (3062) --> FemaleChildren15y
INTEGER (3401) --> MaleChildren612y
INTEGER (2474) --> FemaleChildren612y
INTEGER (2696) --> MaleYouth1317y
INTEGER (3025) --> FemaleYouth1317y
INTEGER (3185) --> MaleAdults1859y
INTEGER (3301) --> FemaleAdults1859y
INTEGER (3389) --> MaleElderly60Yy
INTEGER (2438) --> FemaleElderly60y
