
=== Tue May 19 08:34:58 GMT 2026 RUN: tclsh /prs/igistk/c/csv2sqlite.tcl idp/rets_2503r1ncnw4sa.csv /home/wdeb/idps/nga/idps22.sdb



Source file: 'idp/rets_2503r1ncnw4sa.csv' (the number of rows 669 and number of cols 79; output format: '==Column type (length) --> Target column name:')
TEXT (6680) --> col11a1Dateofcurrentsurvey
TEXT (3714) --> State
TEXT (4198) --> LGA
TEXT (5521) --> Ward
TEXT (4676) --> SSID
TEXT (6100) --> SiteName
TEXT (1512) --> col11d4SiteAlternateName
TEXT (3340) --> Settlementtype
INTEGER (1449) --> NumberofHouseholds
INTEGER (1950) --> NumberofIndividuals
INTEGER (976) --> YearofInitialDisplacementHHsArrivalin2024
INTEGER (1237) --> YearofInitialDisplacementINDsArrivalin2024
INTEGER (818) --> YearofInitialDisplacementHHsArrivalin2023
INTEGER (958) --> YearofInitialDisplacementINDsArrivalin2023
INTEGER (790) --> YearofInitialDisplacementHHsArrivalin2022
INTEGER (921) --> YearofInitialDisplacementINDsArrivalin2022
INTEGER (785) --> YearofInitialDisplacementHHsArrivalin2021
INTEGER (868) --> YearofInitialDisplacementINDsArrivalin2021
INTEGER (891) --> YearofInitialDisplacementHHsArrivalBefore202120142020
INTEGER (1037) --> YearofInitialDisplacementINDsArrivalBefore202120142020
TEXT (1610) --> AretherehouseholdsindividualsdisplacedbyArmedConflict
INTEGER (595) --> NumberofHouseholds1
INTEGER (803) --> NumberofIndividuals2
TEXT (1510) --> AretherehouseholdsindividualsdisplacedbyCommunalviolenceclashesclashesbetweennonstatearmedgroups
INTEGER (409) --> NumberofHouseholds3
INTEGER (533) --> NumberofIndividuals4
TEXT (1638) --> AretherehouseholdsindividualsdisplacedbyClimaterelateddisasterslandslideavalanchedroughtfloodswildfirestormcyclone
INTEGER (567) --> NumberofHouseholds5
INTEGER (798) --> NumberofIndividuals6
TEXT (1336) --> AretherehouseholdsindividualsdisplacedbyNonclimaterelateddisastersearthquketsunamivolcaniceruption
INTEGER (0) --> NumberofHouseholds7
INTEGER (0) --> NumberofIndividuals8
INTEGER (918) --> MaleInfants1y
INTEGER (964) --> FemaleInfants1y
INTEGER (1121) --> MaleChildren15y
INTEGER (1177) --> FemaleChildren15y
INTEGER (1196) --> MaleChildren612y
INTEGER (1253) --> FemaleChildren612y
INTEGER (1254) --> MaleYouth1317y
INTEGER (1312) --> FemaleYouth1317y
INTEGER (1429) --> MaleAdults1859y
INTEGER (1512) --> FemaleAdults1859y
INTEGER (920) --> MaleElderly60y
INTEGER (973) --> FemaleElderly60y
TEXT (41909) --> col15g3ReasonforReturning
INTEGER (668) --> col15g3ReasonforReturningImprovedsecurity
INTEGER (668) --> col15g3ReasonforReturningAccesstobetterservices
INTEGER (668) --> col15g3ReasonforReturningAccesstoland
INTEGER (668) --> col15g3ReasonforReturningFreetransportavailable
INTEGER (668) --> col15g3ReasonforReturningTojoinfamilymembers
INTEGER (668) --> col15g3ReasonforReturningRebuildpersonalshelter
INTEGER (668) --> col15g3ReasonforReturningPoorlivingconditionsinplaceofdisplacement
INTEGER (668) --> col15g3ReasonforReturningToaccesseducation
INTEGER (668) --> col15g3ReasonforReturningOthers
TEXT (4677) --> Country
TEXT (3669) --> State9
TEXT (4262) --> LGA10
TEXT (5765) --> Ward11
INTEGER (903) --> col22a1PregnantWomen
INTEGER (1132) --> col22b1BreastfeedingMothers
INTEGER (1065) --> col22e1ElderlyPersons
INTEGER (959) --> Totalnumberofindividualswithothervulnerabilities
INTEGER (1145) --> MajorityYearofReturns2024HH
INTEGER (1511) --> MajorityYearofReturns2024IND
INTEGER (831) --> MajorityYearofReturns2023HH
INTEGER (989) --> MajorityYearofReturns2023IND
INTEGER (771) --> MajorityYearofReturns2022HH
INTEGER (871) --> MajorityYearofReturns2022IND
INTEGER (741) --> MajorityYearofReturns2021HH
INTEGER (792) --> MajorityYearofReturns2021IND
INTEGER (800) --> MajorityYearofReturns20142020HH
INTEGER (887) --> MajorityYearofReturns20142020IND
INTEGER (1134) --> D21aNoDamageHH
INTEGER (1555) --> D21bNoDamageIND
INTEGER (1084) --> D22aPartiallyDamagedHH
INTEGER (1495) --> D22bPartiallyDamagedIND
INTEGER (956) --> D23aFullyDamagedHH
INTEGER (1296) --> D23bFullyDamagedIND
TEXT (43354) --> ADDITIONALCOMMENT
