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



Source file: 'idp/idps_2305r44ne4sa.csv' (the number of rows 2483 and number of cols 127; output format: '==Column type (length) --> Target column name:')
TEXT (7446) --> DTMRound
TEXT (24820) --> DateofAssessment
INTEGER (2482) --> KIs
TEXT (51704) --> PopulationTypes
TEXT (13515) --> State
TEXT (12410) --> StatePcode
TEXT (15642) --> LGA
TEXT (19856) --> LGAPcode
TEXT (23640) --> Ward
TEXT (27302) --> WardPcode
TEXT (17374) --> SiteID
TEXT (25385) --> SiteName
TEXT (32822) --> CampStatus
TEXT (32812) --> Type
TEXT (33588) --> Classification
TEXT (693) --> SiteManagementAgency
TEXT (569) --> SMAType
INTEGER (5476) --> HouseholdsHH
INTEGER (7350) --> IndividualsIND
INTEGER (1572) --> IDPRETDisplacement2022HH
INTEGER (2281) --> IDPRETDisplacement2022IND
INTEGER (1713) --> IDPRETDisplacement2021HH
INTEGER (2518) --> IDPRETDisplacement2021IND
INTEGER (5173) --> IDPRETDisplacementBefore202120142020HH
INTEGER (6981) --> IDPRETDisplacementBefore202120142020IND
INTEGER (0) --> MajorityYearofReturns2022HH
INTEGER (0) --> MajorityYearofReturns2022IND
INTEGER (0) --> MajorityYearofReturns2021HH
INTEGER (0) --> MajorityYearofReturns2021IND
INTEGER (0) --> MajorityYearofReturns20142020HH
INTEGER (0) --> MajorityYearofReturns20142020IND
INTEGER (0) --> InitiallyDisplacedCountryReturnees
INTEGER (0) --> InitiallyDisplacedStateReturnees
INTEGER (0) --> InitiallyDisplacedLGAReturnees
TEXT (40840) --> LandOwnership
TEXT (57249) --> MostCommontypeofShelter
TEXT (6472) --> RegistrationActivity
TEXT (5229) --> ServiceProvider
TEXT (699) --> CCCMSupport
TEXT (483) --> CCCMorganization
TEXT (26831) --> ReasonsforDisplacement
TEXT (13106) --> PrimaryOriginState
TEXT (14575) --> PrimaryOriginLGA
TEXT (25015) --> PrimaryOriginWard
TEXT (10616) --> NaturalHazardRisk
TEXT (65628) --> DisplacedPreviously
TEXT (6878) --> IntentionofMajority
TEXT (34) --> ReasonforReturnReturnees
TEXT (10363) --> LivinginEmergencyShelter
TEXT (10840) --> LivinginMakeshiftShelter
TEXT (12043) --> LivingIndoors
TEXT (11224) --> LivinginPreExisitingShelter
TEXT (5557) --> LivinginTraditinalShelter
TEXT (13678) --> SafeCookingFacilities
INTEGER (0) --> DamageHousesHouseholdsReturnees
INTEGER (0) --> DamageHousesIndividualsReturnees
INTEGER (0) --> ParitallyDamagedHousesHouseholdsReturnees
INTEGER (0) --> ParitallyDamagedHousesIndividualsReturnees
INTEGER (0) --> FullyDamagedHouseholdsReturnees
INTEGER (0) --> FullyDamagedIndividualsReturnees
TEXT (28790) --> MostNeededNFI
TEXT (19699) --> AccesstoNFISupport
TEXT (59690) --> CommunityaccesstoInformationonDistribution
TEXT (11552) --> MainUnfufilledNeeds
TEXT (6987) --> NeedofShelterMaterial
TEXT (20767) --> MostNeededShelterMaterial
TEXT (52048) --> LocationOfSitesMainWaterSource
TEXT (7394) --> CommunityFeelSafeWash
TEXT (15972) --> AverageAmountofWaterAvailableDaily
TEXT (5376) --> ComplaintsAboutDrinkingWaterQuality
TEXT (61940) --> ConditionofMostoftheToilets
TEXT (5292) --> AvailabilityofSeparateMaleandFemaleToilets
TEXT (5239) --> AvailabilityofSeparateBathingAreas
TEXT (46569) --> ToiletsbathroomshaveLocksfromtheInside
TEXT (46694) --> NumberofLatrinesthatareLit
TEXT (26021) --> MaingarbageDisposal
TEXT (6174) --> GarbageandSolidWasteProbleminSite
TEXT (20144) --> HandWashingStationfilledwithWaterandSoapClosetotheToilets
TEXT (46534) --> EvidenceofOpenDefecation
TEXT (5607) --> DrainageonSite
TEXT (22782) --> AccesstoFoodSupport
TEXT (7314) --> AccesstoFunctioningFoodMarket
TEXT (7313) --> CommunityfeelSafetogothereDistancetoOrRouteUnsafe
TEXT (6503) --> DistributionSitesPointsdesignedtoensureaccessibilityforallPersonsPersonswithDisabilitiesOlderPeopleandChildren
TEXT (21572) --> FrequencyofFoodCashorVouchersDistribution
TEXT (43232) --> MostCommonSourceforObtainingFood
TEXT (67935) --> FoodConsumption
TEXT (5701) --> ScreeningforMalnutritionConductedonSiteMUAC
TEXT (5417) --> OutpatientTherapeutic
TEXT (5503) --> SupplementaryFeeding
TEXT (5485) --> StabilizationCenter
TEXT (5410) --> BlanketSupplementary
TEXT (5464) --> TargetSupplementary
TEXT (5835) --> CounselingonInfant
TEXT (5545) --> DistributionofMicronutrientPowdersConductedintheArea
TEXT (5186) --> CashVoucherAssistanceCVAforNutritionintheArea
TEXT (5996) --> SafeandAccessibleNutritionServicesforWomenAdolescentGirlsandPeoplewithDisabilitiesOlderAdultsEtc
TEXT (41593) --> TimetotheNearestNutritionFeedingCentre
TEXT (16694) --> MostPrevalentHealthProblem
TEXT (32943) --> RegularAccesstoMedicine
TEXT (7339) --> AccesstoHealthFacility
TEXT (37889) --> LocationofHealthFacilitiesServices
TEXT (25034) --> OwnerofHealthFacilities
TEXT (24300) --> MainProviderofHealthServices
TEXT (66851) --> WhatisPreventingMostPeoplefromAccessingHealthcareServices
TEXT (7365) --> AccesstoSafeHealthcareFacility
TEXT (7316) --> AccesstoformalinformaleducationservicesforchildrenfromddisplacedHHs
TEXT (14798) --> LocationofformalinformaleducationfacilitiesservicesforchildrenfromdisplacedHHs
TEXT (9409) --> DistancetoNearestEducationFacility
TEXT (14787) --> ChildrenattheSiteAttendingSchool
TEXT (55680) --> SufficientLearningSpaceorClassroomsforChildren
TEXT (6824) --> TrainedMoETeachersinthisCommunity
TEXT (45943) --> MainReasonsforChildrennotGoingtoSchool
TEXT (192478) --> TeachersenoughtoteachPrimaryandSecondaryLevelClassesforChildren
TEXT (6889) --> SkilledVolunteersforEducation
TEXT (7351) --> CommunityLedEducationActivitiesfortheChildren
TEXT (20427) --> AccesstoLivelihoodSupport
TEXT (17464) --> IfYesAccessSupport
TEXT (43089) --> IfYesLivelihoodSuportGiven
TEXT (7231) --> AccesstoIncomeGeneratingActivities
INTEGER (4358) --> HHintheSitewithSourceofIncome
TEXT (23260) --> DisplacedHouseholdsCopingMechanism
TEXT (7204) --> LivestockonSite
TEXT (7056) --> AccesstoLandforCultivation
TEXT (7035) --> SecurityProvidedOnSite
TEXT (5812) --> SecurityIncidentsReportedintheSite
TEXT (24484) --> MainSecurityintheSite
