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



Source file: 'idp/rets_2211r43ne4sa.csv' (the number of rows 706 and number of cols 35; output format: '==Column type (length) --> Target column name:')
TEXT (7050) --> DateofSurvey
TEXT (6345) --> Populationtype
TEXT (4168) --> State
TEXT (4582) --> LGA
TEXT (6916) --> Ward
TEXT (6393) --> SSID
REAL (5484) --> latitude
REAL (5567) --> longitude
INTEGER (2072) --> Households
INTEGER (2626) --> Individuals
TEXT (4830) --> col14f1Sitestartdate
TEXT (3525) --> SiteClassification
TEXT (7292) --> col15g2ReasonofdisplacementofmajorityofReturneesinthesite
TEXT (12135) --> col15g3ReasonforReturning
TEXT (16055) --> col13g4Settlementsitetype
INTEGER (880) --> HHsarrivedtothelocationin2022
INTEGER (1092) --> INDsarrivedtothelocationin2022
INTEGER (976) --> HHsarrivedtothelocationin2021
INTEGER (1300) --> INDsarrivedtothelocationin2021
INTEGER (2019) --> HHsarrivedtothelocationbefore202120142020
INTEGER (2560) --> INDsarrivedtothelocationbefore202120142020
INTEGER (1437) --> MaleInfants1y
INTEGER (1495) --> FemaleInfants1y
INTEGER (1766) --> MaleChildren15y
INTEGER (1797) --> FemaleChildren15y
INTEGER (1885) --> MaleChildren612y
INTEGER (1921) --> FemaleChildren612y
INTEGER (1945) --> MaleYouth1317y
INTEGER (1976) --> FemaleYouth1317y
INTEGER (2077) --> MaleAdults1859y
INTEGER (2115) --> FemaleAdults1859y
INTEGER (1370) --> MaleElderly60y
INTEGER (1405) --> FemaleElderly60y
INTEGER (2395) --> Totalmale
INTEGER (2460) --> Totalfemale
