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



Source file: 'idp/rets_2207r41ne4sa.csv' (the number of rows 689 and number of cols 70; output format: '==Column type (length) --> Target column name:')
DATE (6880) --> DateOfAssessment
TEXT (4083) --> STATE
TEXT (4538) --> LGA
TEXT (6722) --> WARD
TEXT (6221) --> RETURNLOCATIONNAME
REAL (5338) --> GPSCoordinateslatitude
REAL (5418) --> GPSCoordinateslongitude
TEXT (1887) --> aretheypeopleleftduringtheinsurgency
TEXT (3440) --> Type
TEXT (12348) --> reasonforreturn
INTEGER (2016) --> NumberofHouseholds
INTEGER (2555) --> Numberofindividuals
INTEGER (348) --> RETURNREFUGEEYEAROFARRIVAL
TEXT (672) --> RETURNREFUGEECOUNTRY
TEXT (533) --> RETURNREFUGEESTATE
TEXT (543) --> RETURNREFUGEELGA
INTEGER (823) --> RETURNREFUGEEHH
INTEGER (895) --> RETURNREFUGEEIND
INTEGER (2712) --> IDPRETURNSYEAROFARRIVAL
TEXT (4746) --> IDPRETURNSCOUNTRY
TEXT (3907) --> IDPRETURNSSTATE
TEXT (5201) --> IDPRETURNSLGA
INTEGER (1950) --> IDPRETURNSHH
INTEGER (2486) --> IDPRETURNSIND
INTEGER (2130) --> NumberofinitiallydisplacedHouseholds
INTEGER (2690) --> Numberofinitiallydisplacedindividuals
INTEGER (1409) --> MaleInfants
INTEGER (1457) --> FemaleInfants
INTEGER (1699) --> MaleChildren15
INTEGER (1732) --> FemaleChildren15
INTEGER (1828) --> MaleChildren612
INTEGER (1864) --> FemaleChildren612
INTEGER (1891) --> MaleAdolescent
INTEGER (1926) --> FemaleAdolescent
INTEGER (2013) --> MaleAdults
INTEGER (2060) --> FemaleAdults
INTEGER (1347) --> MaleElderly
INTEGER (1386) --> FemaleElderly
INTEGER (1388) --> pregnantwomen
INTEGER (1590) --> breastfeedingmothers
INTEGER (741) --> personswithphysicaldisabilities
INTEGER (730) --> difficultycommunicatingorbeingunderstood
INTEGER (1572) --> elderlypersons
INTEGER (745) --> personswithchronicdiseasesandseriousmedicalcondtions
INTEGER (757) --> seeingdifficulty
INTEGER (754) --> difficultywalking
INTEGER (719) --> unaccompaniedchildren
INTEGER (727) --> separatedchildren
INTEGER (835) --> orphanedminors
INTEGER (968) --> singlefemaleHouseholds
INTEGER (870) --> singlemaleHouseholds
INTEGER (725) --> childHouseholds
INTEGER (725) --> hearingdifficulty
INTEGER (737) --> difficultythinkingconcentrating
TEXT (7360) --> DisplacementReasons
TEXT (3032) --> DisplacementYear
INTEGER (2016) --> DisplacedHouseholds
INTEGER (2555) --> DisplacedIndividuals
INTEGER (1889) --> wallbuildingsHH
INTEGER (2408) --> wallbuildingsIND
INTEGER (921) --> emergencyshelterHH
INTEGER (1084) --> emergencyshelterIND
INTEGER (1224) --> traditionalshelterHH
INTEGER (1518) --> traditionalshelterIND
INTEGER (1913) --> nodamagehousesHH
INTEGER (2427) --> nodamagehousesIND
INTEGER (1207) --> paritallydamagedhousesHH
INTEGER (1529) --> paritallydamagedhousesIND
INTEGER (926) --> fullydamagedHH
INTEGER (1100) --> fullydamagedIND
