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



Source file: 'idp/idps_2405r12ncnw4sa.csv' (the number of rows 1638 and number of cols 109; output format: '==Column type (length) --> Target column name:')
TEXT (4911) --> DTMRound
TEXT (16370) --> DateofAssessment
INTEGER (1637) --> KIs
TEXT (53810) --> PopulationTypes
TEXT (17936) --> Region
TEXT (10233) --> State
TEXT (9822) --> StatePcode
TEXT (10962) --> LGA
TEXT (14733) --> LGAPcode
TEXT (13700) --> Ward
TEXT (18852) --> WardPcode
TEXT (11459) --> SiteID
TEXT (17258) --> SiteName
REAL (13022) --> Latitude
REAL (12142) --> Longitude
TEXT (22332) --> LocationStatusIfCamp
TEXT (22572) --> Type
TEXT (22610) --> Classification
INTEGER (3512) --> HouseholdsHH
INTEGER (4775) --> IndividualsIND
INTEGER (1281) --> IDPDisplacementYear2023HH
INTEGER (1844) --> IDPDisplacementYear2023IND
INTEGER (1478) --> IDPDisplacementYear2022HH
INTEGER (2116) --> IDPDisplacementYear2022IND
INTEGER (1477) --> IDPDisplacementYear2021HH
INTEGER (2107) --> IDPDisplacementYear2021IND
INTEGER (2366) --> IDPDisplacementBefore202120142020HH
INTEGER (3314) --> IDPDisplacementBefore202120142020IND
TEXT (24563) --> Landownership
TEXT (28253) --> MostCommonTypeofShelter
TEXT (29391) --> ReasonsforDisplacement
TEXT (10371) --> PrimaryOriginState
TEXT (10374) --> PrimaryOriginLGA
TEXT (13156) --> PrimaryOriginWard
TEXT (7269) --> NaturalHazardRisk
TEXT (45978) --> DisplacedPreviously
TEXT (4355) --> IntentionofMajority
TEXT (6635) --> LivinginEmergencyShelter
TEXT (6824) --> LivinginMakeshiftShelter
TEXT (8687) --> LivingIndoors
TEXT (8846) --> LivinginPreExisitingShelter
TEXT (7304) --> LivinginTraditinalShelter
TEXT (8756) --> SafeCookingFacilities
TEXT (18100) --> MostNeededNFI
TEXT (9051) --> AccesstoNFISupport
TEXT (38503) --> CommunityaccessInformationonDistribution
TEXT (8776) --> MainUnfufilledNeed
TEXT (4554) --> NeedShelterMaterial
TEXT (14129) --> MostNeededShelterMaterial
TEXT (34525) --> LocationofSitesMainWaterSource
TEXT (4802) --> CommunityFeelSafeWash
TEXT (11065) --> AverageAmountofWaterAvailableDaily
TEXT (3799) --> ComplaintsaboutDrinkingWaterQuality
TEXT (40295) --> ConditionOfMostOfTheToilets
TEXT (3384) --> AvailabilityOfSeparateMaleAndFemaleToilets
TEXT (3372) --> AvailabilityOfSeparateBathingAreas
TEXT (30842) --> ToiletsBathroomshaveLocksfromtheInside
TEXT (30462) --> NumberOfLatrinesThatAreLit
TEXT (17962) --> MainGarbageDisposal
TEXT (4167) --> GarbageAndSolidWasteProblemInSite
TEXT (15327) --> HandWashingStationFilledWithWaterAndSoapCloseToTheToilets
TEXT (31333) --> EvidenceOfOpenDefecation
TEXT (3774) --> DrainageOnSite
TEXT (6609) --> AccessToFoodSupport
TEXT (4709) --> AccessToFunctioningFoodMarket
TEXT (1036) --> CommunityFeelSafeToGo
TEXT (969) --> DistributionSitesPointsDesignedToEnsureAccessibilityForAll
TEXT (3213) --> FrequencyOfFoodCashOrVouchersDistribution
TEXT (29670) --> MostCommonSourceForObtainingFood
TEXT (3377) --> ScreeningForMalnutritionConductedOnSiteMUAC
TEXT (3324) --> OutpatientTherapeutic
TEXT (3302) --> SupplementaryFeeding
TEXT (3389) --> StabilizationCenter
TEXT (3314) --> BlanketSupplementary
TEXT (3393) --> TargetSupplementary
TEXT (4031) --> CounselingOnInfant
TEXT (3306) --> DistributionOfMicronutrientPowdersConductedInTheArea
TEXT (3284) --> CashVoucherAssistanceCVAForNutritionInTheArea
TEXT (3572) --> SafeAndAccessibleNutritionServicesForWomenAdolescentGirlsAndPeopleWithDisabilitiesOlderAdults
TEXT (27488) --> TimeToTheNearestNutritionFeedingCentre
TEXT (11580) --> MostPrevalentHealthProblem
TEXT (22377) --> RegularAccessToMedicine
TEXT (4796) --> AccessToHealthFacility
TEXT (26652) --> LocationOfHealthFacilitiesServices
TEXT (17299) --> OwnerOfHealthFacilities
TEXT (17196) --> MainProviderOfHealthServices
TEXT (34821) --> WhatIsPreventingMostPeopleFromAccessingHealthcareServices
TEXT (4811) --> AccessToSafeHealthcareFacility
TEXT (4779) --> AccessToFormalInformalEducationServicesForChildrenFromDisplacedHHs
TEXT (11402) --> LocationOfFormalInformalEducationFacilitiesServicesForChildrenFromDisplacedHHs
TEXT (6059) --> DistanceToNearestEducationFacility
TEXT (10902) --> ChildrenAtTheSiteAttendingSchool
TEXT (37120) --> SufficientLearningSpaceOrClassroomsForChildren
TEXT (4614) --> TrainedMoETeachersInThisCommunity
TEXT (28723) --> MainReasonsForChildrenNotComingToSchool
TEXT (127057) --> TeachersEnoughToTeachPrimaryAndSecondaryLevelClassesForChildren
TEXT (4705) --> SkilledAndWillingToVolunteerAsTeachers
TEXT (4811) --> CommunityLedEducationActivitiesForTheChildren
TEXT (5914) --> AccessToLivelihoodSupport
TEXT (3108) --> IfYesCommunityReceiveLivelihoodSupport
TEXT (5484) --> IfYesLivelihoodSupportProvided
TEXT (4732) --> AccessToIncomeGeneratingActivities
INTEGER (2732) --> HHInTheSiteWithSourceOfIncome
TEXT (16020) --> DisplacedHouseholdsCopingMechanism
TEXT (4646) --> LivestockOnSite
TEXT (4388) --> AccessToLandForCultivation
TEXT (4614) --> SecurityIsProvidedOnSite
TEXT (4246) --> SecurityIncidentsReportedInTheSite
TEXT (14920) --> MainSecurityInTheSite
