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



Source file: 'idp/rets_2503gtb4sa.csv' (the number of rows 150 and number of cols 78; output format: '==Column type (length) --> Target column name:')
TEXT (1490) --> col11a1Dateofcurrentsurvey
TEXT (840) --> State
TEXT (825) --> LGA
TEXT (1393) --> Ward
TEXT (1341) --> SiteName
TEXT (637) --> col11d4SiteAlternateName
TEXT (745) --> Settlementtype
INTEGER (260) --> NumberofHouseholds
INTEGER (374) --> NumberofIndividuals
INTEGER (172) --> YearofInitialDisplacementHHsArrivalin2024
INTEGER (206) --> YearofInitialDisplacementINDsArrivalin2024
INTEGER (168) --> YearofInitialDisplacementHHsArrivalin2023
INTEGER (197) --> YearofInitialDisplacementINDsArrivalin2023
INTEGER (201) --> YearofInitialDisplacementHHsArrivalin2022
INTEGER (241) --> YearofInitialDisplacementINDsArrivalin2022
INTEGER (160) --> YearofInitialDisplacementHHsArrivalin2021
INTEGER (174) --> YearofInitialDisplacementINDsArrivalin2021
INTEGER (167) --> YearofInitialDisplacementHHsArrivalBefore202120142020
INTEGER (190) --> YearofInitialDisplacementINDsArrivalBefore202120142020
TEXT (324) --> AretherehouseholdsindividualsdisplacedbyArmedConflict
INTEGER (41) --> NumberofHouseholds1
INTEGER (60) --> NumberofIndividuals2
TEXT (341) --> AretherehouseholdsindividualsdisplacedbyCommunalviolenceclashesclashesbetweennonstatearmedgroups
INTEGER (81) --> NumberofHouseholds3
INTEGER (119) --> NumberofIndividuals4
TEXT (383) --> AretherehouseholdsindividualsdisplacedbyClimaterelateddisasterslandslideavalanchedroughtfloodswildfirestormcyclone
INTEGER (144) --> NumberofHouseholds5
INTEGER (205) --> NumberofIndividuals6
TEXT (298) --> AretherehouseholdsindividualsdisplacedbyNonclimaterelateddisastersearthquketsunamivolcaniceruption
INTEGER (0) --> NumberofHouseholds7
INTEGER (0) --> NumberofIndividuals8
INTEGER (163) --> MaleInfants1y
INTEGER (175) --> FemaleInfants1y
INTEGER (200) --> MaleChildren15y
INTEGER (202) --> FemaleChildren15y
INTEGER (216) --> MaleChildren612y
INTEGER (226) --> FemaleChildren612y
INTEGER (232) --> MaleYouth1317y
INTEGER (232) --> FemaleYouth1317y
INTEGER (256) --> MaleAdults1859y
INTEGER (265) --> FemaleAdults1859y
INTEGER (158) --> MaleElderly60y
INTEGER (163) --> FemaleElderly60y
TEXT (9608) --> col15g3ReasonforReturning
INTEGER (149) --> col15g3ReasonforReturningImprovedsecurity
INTEGER (149) --> col15g3ReasonforReturningAccesstobetterservices
INTEGER (149) --> col15g3ReasonforReturningAccesstoland
INTEGER (149) --> col15g3ReasonforReturningFreetransportavailable
INTEGER (149) --> col15g3ReasonforReturningTojoinfamilymembers
INTEGER (149) --> col15g3ReasonforReturningRebuildpersonalshelter
INTEGER (149) --> col15g3ReasonforReturningPoorlivingconditionsinplaceofdisplacement
INTEGER (149) --> col15g3ReasonforReturningToaccesseducation
INTEGER (149) --> col15g3ReasonforReturningOthers
TEXT (1043) --> Country
TEXT (834) --> State9
TEXT (865) --> LGA10
TEXT (1330) --> Ward11
INTEGER (170) --> col22a1PregnantWomen
INTEGER (189) --> col22b1BreastfeedingMothers
INTEGER (178) --> col22e1ElderlyPersons
INTEGER (166) --> Totalnumberofindividualswithothervulnerabilities
INTEGER (216) --> MajorityYearofReturns2024HH
INTEGER (285) --> MajorityYearofReturns2024IND
INTEGER (175) --> MajorityYearofReturns2023HH
INTEGER (209) --> MajorityYearofReturns2023IND
INTEGER (173) --> MajorityYearofReturns2022HH
INTEGER (196) --> MajorityYearofReturns2022IND
INTEGER (152) --> MajorityYearofReturns2021HH
INTEGER (155) --> MajorityYearofReturns2021IND
INTEGER (158) --> MajorityYearofReturns20142020HH
INTEGER (171) --> MajorityYearofReturns20142020IND
INTEGER (184) --> D21aNoDamageHH
INTEGER (241) --> D21bNoDamageIND
INTEGER (200) --> D22aPartiallyDamagedHH
INTEGER (290) --> D22bPartiallyDamagedIND
INTEGER (216) --> D23aFullyDamagedHH
INTEGER (287) --> D23bFullyDamagedIND
TEXT (4833) --> ADDITIONALCOMMENT
