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



Source file: 'idp/idps_2201r8ncnw4ba.csv' (the number of rows 1564 and number of cols 87; output format: '==Column type (length) --> Target column name:')
INTEGER (1563) --> DTMRound
TEXT (7815) --> State_Pcode
TEXT (9747) --> State
TEXT (12504) --> LGAPcode
TEXT (10537) --> LGA
TEXT (17193) --> CODs_Ward_Pcode
TEXT (13111) --> WARD
TEXT (10941) --> SiteID
TEXT (15883) --> SiteName
REAL (11906) --> Latitude
REAL (11000) --> Longitude
TEXT (42201) --> GooogleMapLink
TEXT (21882) --> SiteClassification
TEXT (21882) --> SiteType
TEXT (3126) --> SiteManagementAgency
TEXT (6252) --> SMAType
TEXT (3315) --> RegistrationActivity
TEXT (3126) --> WASHSupport
TEXT (4308) --> HEALTHSupport
TEXT (4668) --> SHELTERSupport
TEXT (3215) --> NFI_support
TEXT (3416) --> FOODSupport
TEXT (4608) --> PROTECTIONSupport
TEXT (4449) --> EDUCATIONSupport
TEXT (3273) --> LIVELIHOODSupport
TEXT (12277) --> LandOwnership
TEXT (24627) --> MostCommonTypeofShelter
INTEGER (3169) --> NumberofHouseholds
INTEGER (4380) --> NumberofIndividuals
INTEGER (2102) --> Boys1
INTEGER (2186) --> Girls1
INTEGER (2538) --> Boys15y
INTEGER (2666) --> Girls15y
INTEGER (3226) --> Boys617y
INTEGER (3321) --> Girls617y
INTEGER (3161) --> Men1859y
INTEGER (3305) --> Women1859y
INTEGER (1966) --> Elderlymen60y
INTEGER (2058) --> Elderlywomen60y
TEXT (3231) --> HaveIDPsbeendisplacedpreviously
TEXT (18134) --> ReasonfordisplacementofMajority
TEXT (6793) --> NaturalHazardRisks
TEXT (23445) --> IntendedAreaofReturn
TEXT (19983) --> ReasonstoReturnHome
TEXT (13441) --> ReasonsNOTtoReturnHome
TEXT (6258) --> HHlivingoutsidenoshelter
TEXT (6276) --> HHlivinginEmS
TEXT (6333) --> HHlivinginmakeshiftselfmadeshelter
TEXT (6543) --> HHlivingindoorssolidwalls
TEXT (8490) --> HHhaveaccesstoelectricity
TEXT (8349) --> HHhaveaccesstosafecookingfacilities
TEXT (7902) --> HHhaveprivatelivingarea
TEXT (8441) --> HHhavemosquitonets
TEXT (18272) --> MostneededNFI
TEXT (26717) --> Locationofsitemainwatersource
TEXT (19555) --> Maindrinkingwatersource
TEXT (14149) --> Avgamountofwateravailabledayperson
TEXT (4129) --> Isdrinkingwaterpotable
TEXT (3686) --> Complaintsaboutdrinkingwaterquality
TEXT (17081) --> Conditionofmostofthetoilets
INTEGER (2348) --> offunctioningtoilets
TEXT (19332) --> Maingarbagedisposal
TEXT (4050) --> Garbageandsolidwasteproblem
TEXT (12759) --> Availabilityofhandwashingstation
TEXT (3690) --> Hygienepromotioncampaign
TEXT (4177) --> Evidenceofopendefecation
TEXT (7156) --> Accesstofood
TEXT (4676) --> Accesstomarketnearfromthesite
TEXT (9562) --> Frequencyoffooddistribution
TEXT (11620) --> Mostcommonsourceforobtainingfood
TEXT (3200) --> Screeningformalnutrition
TEXT (10914) --> Mosthealthproblem
TEXT (4096) --> Regularaccesstomedicine
TEXT (4679) --> Accesstohealthfacility
TEXT (25256) --> Locationofhealthfacilities
TEXT (15703) --> Mainproviderofhealthfacilities
TEXT (4689) --> Accesstoeducationservices
TEXT (9618) --> Locationofeducationfacilities
TEXT (9549) --> ofchildrenattendingschool
TEXT (15032) --> OccupationofmajorityofIDPs
INTEGER (2822) --> ofHHwithsourceofincome
TEXT (4663) --> Accesstoincomegeneratingactivities
TEXT (4575) --> Livestockonsite
TEXT (4327) --> IDPshaveaccesstolandforcultivation
TEXT (41209) --> MosttrustedsourceofInfo
TEXT (29002) --> Maintopiccommunityisrequestinginfo
TEXT (3296) --> Seriousproblemduetolackinformation
