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



Source file: 'idp/idps_2207r40ne4sa.csv' (the number of rows 300 and number of cols 235; output format: '==Column type (length) --> Target column name:')
TEXT (897) --> phase
TEXT (2093) --> Country
TEXT (897) --> Country_Code
TEXT (3289) --> Reported_Date
TEXT (2990) --> DateofAssessment
TEXT (4885) --> WhatmethodofAssessementdidyouuse
TEXT (10367) --> IfDirectVisitSelectApplicable
TEXT (611) --> NewLocation
TEXT (1547) --> State
TEXT (1794) --> StateCode
TEXT (2270) --> LGA
TEXT (2691) --> LGACode
TEXT (2997) --> WARD
TEXT (5387) --> Type
TEXT (3041) --> classification
TEXT (2093) --> SiteID
TEXT (4625) --> SiteName
REAL (2335) --> Latitude
REAL (2366) --> Longitude
TEXT (2284) --> CampStatus
TEXT (6877) --> IDPLocationType
TEXT (2500) --> SiteStartDate
TEXT (12) --> Expectedclosingdate
TEXT (4903) --> Landownership
TEXT (6026) --> Mostcommontypeshelter
TEXT (826) --> IsthereSiteManagementCommitteeSMCatthesite
TEXT (823) --> SMCfromcommunity
TEXT (744) --> SiteManagementAgency
TEXT (1401) --> SMAtype
TEXT (711) --> Serviceprovidercontactlist
TEXT (805) --> WASHsupport
TEXT (653) --> CCCMSupport
TEXT (5148) --> CCCMOrganization
TEXT (812) --> SHELTERsupport
TEXT (805) --> NFIsupport
TEXT (768) --> FOODsupport
TEXT (715) --> HEALTHsupport
TEXT (853) --> PROTECTIONsupport
TEXT (741) --> EDUCATIONsupport
TEXT (727) --> LIVELIHOODsupport
TEXT (707) --> PSYCHOSOCIALSUPPORT
TEXT (4292) --> PSSORGANIZATION
TEXT (822) --> Registrationactivity
TEXT (718) --> registrationbiometric
TEXT (754) --> registrationonpaper
TEXT (3050) --> ReasonfordisplacementMajority
TEXT (1515) --> Stateoriginfirstlargestgroup
TEXT (1648) --> LGAoriginfirstlargestgroup
TEXT (3178) --> Wardoriginfirstlargestgroup
TEXT (1300) --> Stateoriginsecondlargestgroup
TEXT (1438) --> LGAoriginsecondlargestgroup
TEXT (2822) --> Wardoriginsecondlargestgroup
TEXT (1249) --> Naturalhazardrisks
INTEGER (801) --> Numberhouseholds
INTEGER (1006) --> Numberindividuals
INTEGER (549) --> Boyslessthan1
INTEGER (576) --> Girlslessthan1
INTEGER (653) --> Totalinfantslessthan1
INTEGER (673) --> Boys1to5y
INTEGER (702) --> Girls1to5y
INTEGER (775) --> Totalchildren1to5y
INTEGER (685) --> Boys6to12y
INTEGER (705) --> Girls6to12y
INTEGER (791) --> Totalyouth6to12y
INTEGER (679) --> Boys13to17y
INTEGER (695) --> Girls13to17y
INTEGER (781) --> Totalyouth13to17y
INTEGER (782) --> Men18to59y
INTEGER (807) --> Women18to59y
INTEGER (890) --> Totaladults18to59y
INTEGER (490) --> Elderlymen60plus
INTEGER (517) --> Elderlywomen60plus
INTEGER (573) --> Totalelderly60plus
TEXT (2530) --> DatearrivalfirstIDPgroup
TEXT (2400) --> DatearrivallastIDPgroup
TEXT (5468) --> HowmanytimeshavemajorityofIDPsbeendisplaced
TEXT (868) --> IntentionGoPlaceOrig
TEXT (5322) --> IfYesWhyIntentionGoPlaceOrig
TEXT (5246) --> IfNoWhyIntentionGoPlaceOrig
TEXT (4465) --> IntendedAreaofReturns
TEXT (1523) --> IntendedStatereturn
TEXT (1649) --> IntendedLGAreturn
TEXT (3216) --> IntendedWardreturn
TEXT (1205) --> PercentageHHlivingoutsidewithnoshelter
TEXT (1427) --> PercentageHHlivinginEmergencyShelter
TEXT (1478) --> PercentageHHlivinginmakeshiftorselfmade
TEXT (1367) --> PercentageHHlivingindoorssolidwalls
TEXT (1262) --> PercentageHHhaveaccesstoelectricity
TEXT (1733) --> PercentageHHhaveaccesstosafecookingfacilities
TEXT (1541) --> PercentageHHhaveprivatelivingarea
TEXT (1664) --> PercentageHHhavemosquitonets
TEXT (3594) --> MostneededNFI
TEXT (3483) --> SecondmostneededNFI
TEXT (3383) --> ThirdmostneededNFI
TEXT (886) --> IsthesiteaccessiblebytrucksforNFIdistribution
TEXT (2639) --> AccesstoNFISupport
TEXT (3013) --> Duration
TEXT (1173) --> MostsupportingORGforNFI
TEXT (1340) --> SecondmostsupportingORGforNFI
TEXT (1470) --> MostUnmetNeeds
TEXT (871) --> Needsheltermaterial
TEXT (2702) --> Mostneededsheltermaterial
TEXT (2817) --> Secondmostneededsheltermaterial
TEXT (2251) --> Thirdmostneededsheltermaterial
TEXT (6358) --> Locationofsitemainwatersource
TEXT (5727) --> Howoperationalarethey
TEXT (782) --> Havewaterpointsbeenimproved
TEXT (649) --> Differentiatingdrinkingwaterandnondrinkingwater
TEXT (4716) --> Mainnondrinkingwatersource
TEXT (4706) --> Maindrinkingwatersource
TEXT (2089) --> Avgamountofwateravailableperdayperperson
TEXT (891) --> Drinkingwaterpotable
TEXT (1213) --> Mainproblemwithwater
TEXT (604) --> Complaintsaboutdrinkingwaterquality
TEXT (7254) --> Conditionofmostoftoilets
INTEGER (546) --> TotalNumberofToilets
INTEGER (522) --> FunctioningToilets
INTEGER (366) --> NonFunctionalToilets
TEXT (762) --> Availabilityseparatedtoiletsformaleandfemale
TEXT (762) --> Availabilityseparatedbathingareas
TEXT (3810) --> Dotoiletsbathroomshavelocksfrominside
TEXT (3116) --> Maingarbagedisposal
INTEGER (316) --> NbGarbagedisposal
TEXT (787) --> Garbageandsolidwasteproblem
TEXT (3025) --> Availabilityofhandwashingstation
TEXT (749) --> Evidenceofhandwashingpractices
TEXT (835) --> Hygienepromotioncampaign
TEXT (650) --> Drainageworkingonsite
TEXT (790) --> Evidenceofopendefecation
TEXT (4729) --> OperationalLevelDrainage
TEXT (2548) --> Accesstofood
TEXT (2796) --> Duration1
TEXT (876) --> Accesstomarketnearfromthesite
TEXT (2788) --> Frequencyoffooddistribution
TEXT (5000) --> Mostcommonsourceforobtainingfood
TEXT (796) --> Screeningformalnutrition
TEXT (747) --> Blanketsupplfeedingforchildren
TEXT (729) --> Targetedsupplfeedingforlactatingmothers
TEXT (723) --> Counselingconductedinarea
TEXT (700) --> Distributionofmicronutrientpowders
TEXT (604) --> Supplfeedingforelderly
TEXT (1853) --> Mosthealthproblem
TEXT (1656) --> Secondmosthealthproblem
TEXT (1727) --> Thirdmosthealthproblem
TEXT (854) --> Regularaccesstomedicine
TEXT (881) --> Accesstohealthfacility
TEXT (4946) --> Locationofhealthfacilities
TEXT (2282) --> MainProviderofHealthFacilities
TEXT (1952) --> MainProviderofHealthServices
TEXT (883) --> PrimaryHealthCareforChildren
TEXT (872) --> PrimaryHealthCareforAdult
TEXT (684) --> SecondaryHealthCareforChildren
TEXT (676) --> SecondaryHealthCareforAdult
TEXT (604) --> TraditionalHealthCare
TEXT (889) --> Accesstoeducationservices
TEXT (1981) --> Locationofeducationfacilities
TEXT (1197) --> Distancetonearesteducationfacility
TEXT (2082) --> Percentagechildrenattendingschool
TEXT (721) --> Arethereanytrainedmoeteachersinthiscommunity
INTEGER (323) --> ifyeshowmany
TEXT (6339) --> Reason1childrennotcomingtoschool
TEXT (6302) --> Reason2childrennotcomingtoschool
TEXT (7517) --> Reason3childrennotcomingtoschool
TEXT (755) --> arethereanypeopleinthiscommunityskilledandwillingtovolunteerforeducation
TEXT (864) --> Childrenincommunityattendcommunitylededucation
TEXT (3174) --> SchoolBuildingstatus
TEXT (889) --> Schooloccupied
TEXT (869) --> SchoolNotOccupied
TEXT (628) --> SchoolOccupiedByIDPs
TEXT (605) --> SchoolOccupiedByMilitary
TEXT (599) --> SchoolOccupiedByArmedGroups
TEXT (1974) --> AccesstoLivelihoodSupport
TEXT (2482) --> LivelihoodSupportDuration
TEXT (5501) --> IfYesLivehoodSupportgiven
TEXT (879) --> Accesstoincomegeneratingactivities
INTEGER (640) --> NbHHwithsourceofincome
TEXT (3354) --> OccupationofmajorityofIDPs
TEXT (866) --> Livestockonsite
TEXT (727) --> IDPshaveaccesstolandforcultivation
TEXT (850) --> Securityprovided
TEXT (683) --> Securityincidentsreported
TEXT (3308) --> Mainsecurityprovider
TEXT (805) --> protectionsectorareservicesavailable
TEXT (933) --> protectionsectorareservicesavailableappropriate
TEXT (3289) --> protectionsectorpsychosocialsupportaremhpssservicesavailableappropriate
TEXT (4186) --> protectionsectorpsychosocialsupportother
TEXT (1043) --> protectionsectoraremhpssaccessible
TEXT (3127) --> protectionsectoraretheywellinformed
TEXT (1064) --> protectionsectorsafewaitingtorecieveservices
TEXT (1089) --> protectionsectorsafegoinghome
TEXT (7218) --> protectionsectorsignificantprotectionsafety
TEXT (4705) --> protection_sectorsignificant_protection_safety_other
TEXT (1698) --> Commontypeofsecurityincidents
TEXT (3611) --> MostcommontypeofGBVincidentsFemale
TEXT (2479) --> SecondMostcommontypeofGBVincidentsFemale
TEXT (1382) --> ThirdMostcommontypeofGBVincidentsFemale
TEXT (1196) --> FourthMostcommontypeofGBVincidentsFemale
TEXT (3139) --> MostcommontypeofGBVincidentsMale
TEXT (1985) --> SecondMostcommontypeofGBVincidentsMale
TEXT (1309) --> ThirdMostcommontypeofGBVincidentsMale
TEXT (1196) --> FourthMostcommontypeofGBVincidentsMale
TEXT (1499) --> Commontypeofphysicalviolence
TEXT (1568) --> Commontypeofchildprotectionincidents
TEXT (9030) --> Mostprobleminreceivingsupport
INTEGER (299) --> Nbofrecreationalplacesforchildren
INTEGER (299) --> Nbofsocialplacesforwomen
TEXT (891) --> MajorityofIDPshaveID
TEXT (3643) --> IDofMajority
TEXT (818) --> protection_sectorcommunity_based_complaint
TEXT (809) --> Referralmechanismforincidents
TEXT (893) --> WomenFeelSafe
TEXT (4813) --> SitePointAvoidByWomen
TEXT (894) --> MenFeelSafe
TEXT (4680) --> SitePointAvoidByMen
TEXT (894) --> ChildrenFeelSafe
TEXT (4883) --> SitePointAvoidByChildren
TEXT (1226) --> RelationshipamongstIDPs
TEXT (1211) --> IDPsrelationshipwithhostcommunities
TEXT (5837) --> Adequatelightinginmajorityofcommunalpoints
TEXT (611) --> Travelopportunitiesbeingoffered
TEXT (155) --> Ifyeswhere
TEXT (610) --> Educationopportunitiesbeingoffered
TEXT (2380) --> Ifyeswhere2
TEXT (609) --> Marriageopportunitiesbeingoffered
TEXT (2381) --> Ifyeswhere3
TEXT (2980) --> Mostpreferredmediumusedbythecommunitynowtoreceiveinformation
TEXT (3221) --> Mostpreferredmediumusedbychildreninthecommunitynowtoreceiveinformation
TEXT (7773) --> MosttrustedsourceofInfo
TEXT (944) --> HHsaccessToFuncRadio
TEXT (2103) --> Timepeoplelistentoradio
TEXT (12225) --> TypeofInfowillingtosharewithaidorganizations
TEXT (8038) --> Howsiteabletoexpressneeds
TEXT (4970) --> Maintopiccommunityisrequestinginfo
TEXT (635) --> Seriousproblemduetolackinformation
TEXT (3683) --> GeneralComments
