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



Source file: 'idp/idps_2307r11ncnw4sa.csv' (the number of rows 1759 and number of cols 325; output format: '==Column type (length) --> Target column name:')
TEXT (5274) --> surveyround
TEXT (17580) --> surveydate
TEXT (17580) --> Snapshotdate
INTEGER (1758) --> numberofKIs
TEXT (57546) --> populationtypes
TEXT (7032) --> Locationtype
TEXT (10955) --> State
TEXT (10548) --> StatePcode
TEXT (11817) --> LGA
TEXT (15822) --> LGAPcode
TEXT (14739) --> Ward
TEXT (24398) --> sitetypeexisting
TEXT (2270) --> siteclassificationexisting
TEXT (12306) --> SSID
TEXT (18351) --> sitelocationname
TEXT (494) --> sitestatusexisting
INTEGER (3753) --> HH
INTEGER (5108) --> IND
INTEGER (0) --> BSITESETTLEMENTDETAILS
TEXT (14176) --> Latitude
TEXT (14501) --> Longitude
TEXT (1010) --> sitestartdate
TEXT (190) --> informedofsiteclosure
INTEGER (0) --> siteclosingdate
TEXT (197) --> siteareameasurement
INTEGER (17) --> estimatedsitearea
TEXT (132) --> siteextension
INTEGER (0) --> estimatedsiteextension
TEXT (1499) --> landownership
TEXT (2626) --> mostcommontypeofshelter
TEXT (99) --> typeofshelterspecify
TEXT (3525) --> smcsite
TEXT (171) --> smcmade
INTEGER (0) --> smcmembers
INTEGER (59) --> malesmc
INTEGER (62) --> femalesmc
TEXT (575) --> smcfpp
TEXT (256) --> smasite
TEXT (134) --> smatype
INTEGER (0) --> smaname
TEXT (74) --> smafpn
TEXT (122) --> smafocalpointphone
TEXT (3541) --> serviceprovider
TEXT (250) --> ccmsupport
TEXT (18) --> ccmsupportorg
TEXT (3739) --> regactivity
TEXT (7760) --> typeofregistrationactivity
TEXT (33731) --> displacemntreason
TEXT (1059) --> otherreasonsfordisplacement
TEXT (11075) --> primaryoriginstate
TEXT (11113) --> primaryoriginlga
TEXT (14375) --> primaryoriginward
TEXT (11115) --> secondaryoriginstate
TEXT (11168) --> secondaryoriginlga
TEXT (14159) --> secondaryoriginward
TEXT (7862) --> naturalhazardrisk
INTEGER (1934) --> personswithchronicdiseasesandseriousmedicalcondtions
INTEGER (3701) --> VulnurablePoplation
INTEGER (2627) --> IDPSRETURNEESHHsArrivalin2022
INTEGER (3383) --> IDPSRETURNEESINDsArrivalin2022
INTEGER (2584) --> IDPSRETURNEESHHsArrivalin2021
INTEGER (3300) --> IDPSRETURNEESINDsArrivalin2021
INTEGER (2950) --> IDPSRETURNEESHHsArrivalBefore202120142020
INTEGER (4022) --> IDPSRETURNEESINDsArrivalBefore202120142020
TEXT (50714) --> displacedpreviously
TEXT (4646) --> intentionofmajority
TEXT (15930) --> ifnowhy
TEXT (17901) --> ifyeswhen
TEXT (23010) --> ifyeswhy
TEXT (30882) --> areaofintendedreturn
TEXT (10963) --> statereturnint
TEXT (11008) --> lgareturnint
TEXT (14292) --> wardreturnint
INTEGER (0) --> initiallydisplacedCountry
INTEGER (0) --> InitiallydisplacedState
INTEGER (0) --> InitiallydisplacedLGA
TEXT (437) --> reasonforreturn
TEXT (3537) --> livingoutsidehh
INTEGER (37) --> livingoutside
TEXT (7277) --> livingemergencyshelter
TEXT (7472) --> livingmakeshiftshelter
TEXT (10227) --> livingindoors
TEXT (10712) --> livingpreexisitingshelter
TEXT (7992) --> livingtraditinalshelter
TEXT (11242) --> livingsafecookingfacilities
INTEGER (0) --> shelterhavelocks
INTEGER (0) --> reportsandexperiencesofthefts
INTEGER (0) --> nodamagehouseshh
INTEGER (0) --> nodamagehousesind
INTEGER (0) --> paritallydamagedhouseshh
INTEGER (0) --> paritallydamagedhousesind
INTEGER (0) --> fullydamagedhh
INTEGER (0) --> fullydamagedind
INTEGER (0) --> calctotalshelterconditionshh
INTEGER (0) --> calctotalshelterconditionsind
TEXT (19715) --> mostneedednfi
TEXT (4) --> otherneedednfi1
TEXT (20480) --> secondmostneedednfi
TEXT (7) --> otherneedednfi2
TEXT (19776) --> thirdmostneedednfi
TEXT (5) --> otherneedednfi3
TEXT (5197) --> truckaccessible
TEXT (9262) --> isthereaccesstosupport
TEXT (7175) --> ifyeshowlongagodidthesitereceivelastassistance
TEXT (41859) --> communityaccessinfodistri
TEXT (1424) --> othercommunityaccess
TEXT (8593) --> mainunfufilledneed
INTEGER (0) --> mainunfufilledneedother
TEXT (4095) --> istheredrainageonsite
TEXT (4902) --> needsheltermaterial
TEXT (15117) --> mostneededsheltermaterial
INTEGER (0) --> needsheltermaterial1
TEXT (14008) --> secondmostneededsheltermaterial
TEXT (6) --> needsheltermaterial2
TEXT (13355) --> thirdmostneededsheltermaterial
TEXT (137) --> needsheltermaterial3
TEXT (317) --> sitefacilitationsupport
TEXT (316) --> cccmcccmrelatedactivites
TEXT (37047) --> locationofsitesmainwatersource
TEXT (5186) --> communityufeelsafewash
TEXT (34670) --> howoperationalarethey
TEXT (12284) --> averageamountofwateravailabledaily
TEXT (4062) --> aretherecomplaintsaboutdrinkingwaterquality
TEXT (5205) --> whatarethemainproblemwiththewater
TEXT (115) --> otherwaterproblem
TEXT (46765) --> sanitationfacilities
TEXT (42791) --> conditionofmostofthetoilets
INTEGER (2863) --> numberoftoilets
INTEGER (2100) --> numberofnonfunctioningtoiletsonsite
TEXT (34895) --> sanitationpeople
TEXT (3627) --> availabilityofseparatemaleandfemaletoilets
TEXT (3634) --> availabilityofseparatebathingareas
TEXT (32877) --> dotoiletsbathroomshavelocksfromtheinside
TEXT (32632) --> numberoflatrinesthatarelit
TEXT (19700) --> maingarbagedisposal
INTEGER (1924) --> numberofgarbagedisposal
TEXT (4499) --> physicaldisabilities
TEXT (4562) --> garbageandsolidwasteprobleminsite
TEXT (16856) --> availabilityofhandwashingstationfilledinwithwaterandsoapclosetothetoilets
TEXT (34037) --> hygieneawarenessperiod
TEXT (3610) --> femalehygiene
TEXT (33727) --> evidenceofopendefecation
TEXT (7320) --> isthereaccesstofoodsupport
TEXT (4663) --> ifyeshowlongagodidthesitereceivelastfoodassistance
TEXT (8478) --> foodprovider
TEXT (1401) --> otherfoodprovider
TEXT (5121) --> accesstofunctioningfoodmarket
TEXT (2550) --> feelsafetogo
TEXT (2169) --> accessibilityforall
TEXT (1769) --> restrictionstogetfoodforgirls
TEXT (6594) --> frequencyoffoodcashorvouchersdistribution
TEXT (32502) --> mostcommonsourceforobtainingfood
TEXT (129) --> otherfoodsource
TEXT (48635) --> foodconsumption
TEXT (35052) --> proportion3mealsperday
TEXT (3634) --> screeningformalnutritionconductedonsitemuac
TEXT (3581) --> outpatienttherapeutic
TEXT (3583) --> supplementaryfeeding
TEXT (3606) --> stabilizationcenter
TEXT (3557) --> blanketsupplementary
TEXT (3661) --> targetsupplementary
TEXT (4226) --> counselingoninfant
TEXT (3582) --> distmicronutrients
TEXT (3545) --> availabilitycash
TEXT (3653) --> nutriservices
TEXT (29511) --> nutridist
TEXT (12318) --> mostprevalenthealthproblem
TEXT (97) --> prevalentother1
TEXT (10888) --> secondmostprevalenthealthproblem
TEXT (264) --> prevalentother2
TEXT (11806) --> thirdmostprevalenthealthproblem
TEXT (275) --> prevalentother3
TEXT (23560) --> regularaccesstomedicine
TEXT (5193) --> accesstohealthfacility
TEXT (28485) --> locationofhealthfacilitiesservices
TEXT (18160) --> whoistheownerofhealthfacilities
TEXT (52) --> specifyotherproviderofhealthfacilities
TEXT (17976) --> whoisthemainproviderofhealthservices
TEXT (68) --> specifyotherproviderofhealthservices
TEXT (38901) --> healthprev
TEXT (5169) --> healthacareaccesssafe
TEXT (4565) --> privatetreat
TEXT (132331) --> typesofhealthcareservicesavailableonsite
INTEGER (1758) --> typesofhealthcareservicesavailableonsiteprimaryhealthcareforchildren
INTEGER (1758) --> typesofhealthcareservicesavailableonsiteprimaryhealthcareforadult
INTEGER (1758) --> typesofhealthcareservicesavailableonsitesecondaryhealthcareforchildren
INTEGER (1758) --> typesofhealthcareservicesavailableonsitesecondaryhealthcareforadult
INTEGER (1758) --> typesofhealthcareservicesavailableonsitetraditionalhealthcare
INTEGER (1758) --> typesofhealthcareservicesavailableonsiteChemistMedicineStore
INTEGER (10) --> typesofhealthcareservicesavailableonsiteNone
TEXT (191) --> typesofhealthcareservicesavailableonsiteother
INTEGER (0) --> healthcareservicestype
TEXT (5185) --> accesstoformalinformaleducationservicesforchildrenfromdisplacedhhs
TEXT (10337) --> locationofformalinformaleducationfacilitiesservicesforchildrenfromdisplacedhhs
TEXT (6699) --> distancetonearesteducationfacility
TEXT (11991) --> childrenatthesiteattendingschool
INTEGER (1796) --> numofschools
INTEGER (4372) --> numberofschoolage
TEXT (148889) --> sufficientlearning
INTEGER (2698) --> maleinfants35
INTEGER (2821) --> femaleinfants35
INTEGER (3105) --> malechildren612
INTEGER (3229) --> femalechildren612
INTEGER (3219) --> maleyouth1317
INTEGER (3353) --> femaleyouth1317
INTEGER (4465) --> calctotalschoolage
TEXT (4970) --> arethereanytrainedmoeteachersinthiscommunity
TEXT (4849) --> schoollatrines
TEXT (4253) --> schoolseparatedtoilets
TEXT (34536) --> youthattendedu
TEXT (31846) --> reason1
TEXT (38987) --> reason2
TEXT (39907) --> reason3
TEXT (134187) --> enoughteachers
INTEGER (0) --> numteachers
INTEGER (2102) --> maleteachers
INTEGER (2002) --> femaleteachers
TEXT (495022) --> schoolobstacles
INTEGER (1758) --> schoolobstaclesObstaclesonthewaytoschoollearningspacePhysicalbarriers
INTEGER (1758) --> schoolobstaclesObstaclestoenterormovearoundinschoollearningspacePhysicalbarriers
INTEGER (1758) --> schoolobstaclesimpossibleforthemtoengageinlearningcenter
INTEGER (1758) --> schoolobstaclesFearofharassmentviolenceonthewaytoschoollearningcenteroratschoollearningcenter
INTEGER (1758) --> schoolobstaclesEducationisnotadaptedtotheirlearningrequirementseducation
INTEGER (1758) --> schoolobstaclesChildrenwithdisabilitiesdonotfaceanyadditionalobstaclecomparedtoeverybodyelse
INTEGER (1758) --> schoolobstaclesDonotKnowNoanswer
INTEGER (0) --> schoolobstaclesobstaclesonthewaytoschoollearningspacephysicalbarriers2
INTEGER (0) --> schoolobstaclesobstaclestoenterormovearoundinschoollearningspacephysicalbarriers3
INTEGER (0) --> schoolobstaclesimpossibleforthemtoengageinlearningcenter4
INTEGER (0) --> schoolobstacleslearningcenteroratschoollearningcenterattitudinalbarriers5
INTEGER (0) --> schoolobstaclesnecessarydocumentationtoaccesseducationinstitutionallegaladminbarriers6
INTEGER (0) --> schoolobstacleschildrenwithdisabilitiesdonotfaceanyadditionalobstaclecomparedtoeverybodyelse7
INTEGER (0) --> schoolobstaclesdonotknownoanswer8
INTEGER (0) --> schoolobstaclesother
INTEGER (0) --> otherschoolobstacles
TEXT (62791) --> femalesnotattending
INTEGER (1758) --> femalesnotattendinglackoffoodathomeandschool
INTEGER (1758) --> femalesnotattendingtheyareworking
INTEGER (1758) --> femalesnotattendingfeesorcosts9
INTEGER (1758) --> femalesnotattendingdistancetoschool10
INTEGER (1758) --> femalesnotattendingdisabilities11
INTEGER (1758) --> femalesnotattendinglackofspaceinlocalschools12
INTEGER (1758) --> femalesnotattendinglackoffacilitiesseparatedbysex13
INTEGER (1758) --> femalesnotattendinglackofdocumentation14
INTEGER (1758) --> femalesnotattendingearlymarriagepregnancy
INTEGER (1758) --> femalesnotattendingsafetyconcerns15
INTEGER (1758) --> femalesnotattendingnonegirls
INTEGER (1758) --> femalesnotattendingdnkgirls
INTEGER (1758) --> femalesnotattendingother
INTEGER (1758) --> femalesnotattendingearlymarriagepregnancy16
INTEGER (1758) --> femalesnotattendingnonegirlsunder18gotoschool17
INTEGER (1758) --> femalesnotattendingdonotknownoanswer18
TEXT (54414) --> malesnotattending
INTEGER (1758) --> malesnotattendingfeesorcosts19
INTEGER (1758) --> malesnotattendinglackoffoodathomeandschool
INTEGER (1758) --> malesnotattendingtheyareworking
INTEGER (1758) --> malesnotattendingdistancetoschool20
INTEGER (1758) --> malesnotattendingdisabilities21
INTEGER (1758) --> malesnotattendinglackofspaceinlocalschools22
INTEGER (1758) --> malesnotattendinglackoffacilitiesseparatedbysex23
INTEGER (1758) --> malesnotattendinglackofdocumentation24
INTEGER (1758) --> malesnotattendingearlymarriage
INTEGER (1758) --> malesnotattendingsafetyconcerns25
INTEGER (1758) --> malesnotattendingnoneboys
INTEGER (1758) --> malesnotattendingdnkno
INTEGER (1758) --> malesnotattendingother
TEXT (5008) --> arethereanypeopleinthiscommunityskilledandwillingtovolunteerforeducation
TEXT (5153) --> iftherewereanycommunitylededucationactivitieswouldthechildreninyourcommunityattend
TEXT (23221) --> theschooliscurrentlyselectoneresponse
TEXT (38634) --> istheschooloccupiedbyselectallrelevant
INTEGER (1758) --> istheschooloccupiedbyselectallrelevantschoolisnotoccupied
INTEGER (1758) --> istheschooloccupiedbyselectallrelevantcommunityidps
INTEGER (1758) --> istheschooloccupiedbyselectallrelevantmilitarypersonnel
INTEGER (1758) --> istheschooloccupiedbyselectallrelevantarmedgroups
TEXT (6371) --> accesstolivelihoodsupport
TEXT (3320) --> ifyeslasttimecommunityreceivedlivelihoodsupport
TEXT (6409) --> ifyeslivelihoodsuportgiven
TEXT (112) --> specifyotherlivelihoodsuportgiven
TEXT (5097) --> accesstoincomegeneratingactivities
INTEGER (2952) --> numberofhhinthesitewithsourceofincome
TEXT (17040) --> occupationtradeofmajorityofdisplacedhouseholdscopingmechanism
TEXT (5064) --> istherelivestockonsite
TEXT (4768) --> doidpshaveaccesstolandforcultivation
TEXT (32671) --> livelihoodchallenges
INTEGER (500) --> livelihoodchallengesinsecuritypreventingaccess26
INTEGER (500) --> livelihoodchallengeslackoftools27
INTEGER (500) --> livelihoodchallengeslackoftraining28
INTEGER (500) --> livelihoodchallengeslackofcapitalmoneytobuyinputsegseeds29
INTEGER (500) --> livelihoodchallengesinputsegseedsnotavailableinthemarket30
INTEGER (500) --> livelihoodchallengescannotsellproductsataprofitpricestooloworinputstooexpensive31
INTEGER (500) --> livelihoodchallengescroplivestockdisease32
INTEGER (500) --> livelihoodchallengesfloodingaffectedjobsworkcropslivestock33
INTEGER (500) --> livelihoodchallengescropslivestocklootedordestroyedbyconflict34
INTEGER (500) --> livelihoodchallengesroadsimpassable35
INTEGER (500) --> livelihoodchallengesnowagedjobsworkavailable36
INTEGER (500) --> livelihoodchallengesnochallenges37
INTEGER (500) --> livelihoodchallengesunknown38
INTEGER (500) --> livelihoodchallengesother
TEXT (152346) --> householdcoping
INTEGER (1758) --> householdcopingsendhouseholdmemberstoeatelsewhere39
INTEGER (1758) --> householdcopingpurchasefoodoncreditorborrowfood40
INTEGER (1758) --> householdcopingborrowmoney41
INTEGER (1758) --> householdcopingrelyonsupportfromfamilyhostfamilyexternalassistance42
INTEGER (1758) --> householdcopingwithdrawchildrenfromschool43
INTEGER (1758) --> householdcopingreduceexpenditureonotherserviceslikehealthandeducation44
INTEGER (1758) --> householdcopingharvestimmaturecropsgreenmaize45
INTEGER (1758) --> householdcopingconsumeseedstocksthatweretobesavedforthenextseason46
INTEGER (1758) --> householdcopingselllandorproperty47
INTEGER (1758) --> householdcopingbegformoneyandorfood48
INTEGER (1758) --> householdcopingengageindangerousorillegalworkactivityincltheftillegalsubstancesdealingprostitution49
TEXT (127547) --> publicfacilities
INTEGER (1758) --> publicfacilitiesnigeriaregisteredbank50
INTEGER (1758) --> publicfacilitiespublicfacilitywherecommunitymemberscanmeetsuchaswomanshallorcommunitycentre51
INTEGER (1758) --> publicfacilitiesfunctionalmarket52
INTEGER (1758) --> publicfacilitiesprivatecommunitysecurityserviceinitiativeapartfrompoliceandothergovernmentbodies53
INTEGER (1758) --> publicfacilitieslocalgovernmentbuilding54
INTEGER (1758) --> publicfacilitiesmobilemoneyplatforms55
INTEGER (1758) --> publicfacilitiesdebrisorwastemanagementcollectionservice56
INTEGER (1758) --> publicfacilitiespolicestation57
INTEGER (1758) --> publicfacilitiesprimaryschool58
INTEGER (1758) --> publicfacilitiessecondaryschool59
INTEGER (1758) --> publicfacilitiesNofacility
INTEGER (1758) --> publicfacilitiesother
TEXT (228) --> publicfacilitiesother2
TEXT (3640) --> siteawarenes
INTEGER (170) --> numberofpeopleutilization
