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



Source file: 'idp/idpsrets_2503r48ne4sa.csv' (the number of rows 2961 and number of cols 63; output format: '==Column type (length) --> Target column name:')
TEXT (8880) --> DTMround
TEXT (29600) --> SurveyDate
TEXT (75495) --> PopulationGroup
TEXT (36303) --> HowwasthisLocationassessed
TEXT (46012) --> Isthelocationfullyaccessiblefullgeographicinformationcanbecollectedorpartiallyaccessiblequickgeographicinformationgatheredonly
TEXT (6843) --> site_accessibility
TEXT (16527) --> State
TEXT (14800) --> StatePcode
TEXT (18888) --> LGA
TEXT (23680) --> LGAPcode
TEXT (28923) --> Ward
TEXT (32560) --> WardPcode
TEXT (42659) --> SiteType
TEXT (41031) --> SiteClassification
TEXT (22164) --> SiteIDSSID
TEXT (29233) --> SiteName
TEXT (1224) --> SiteStatusIfCamp
TEXT (28170) --> SiteStartDate
TEXT (14610) --> col11f5SiteClass
TEXT (31313) --> col15g2ReasonofdisplacementofmajorityofIDPsReturneesinthesite
TEXT (12801) --> col15g3ReasonforReturning
TEXT (71565) --> col13g4Settlementsitetype
INTEGER (7034) --> NumberofHouseholds
INTEGER (9311) --> NumberofIndividuals
INTEGER (1340) --> IDPSRETURNEESHHsArrivalin2024
INTEGER (2048) --> IDPSRETURNEESINDsArrivalin2024
INTEGER (1452) --> IDPSRETURNEESHHsArrivalin2023
INTEGER (2165) --> IDPSRETURNEESINDsArrivalin2023
INTEGER (1986) --> IDPSRETURNEESHHsArrivalin2022
INTEGER (2877) --> IDPSRETURNEESINDsArrivalin2022
INTEGER (2481) --> IDPSRETURNEESHHsArrivalin2021
INTEGER (3624) --> IDPSRETURNEESINDsArrivalin2021
INTEGER (6496) --> IDPSRETURNEESHHsArrivalBefore202120142020
INTEGER (8639) --> IDPSRETURNEESINDsArrivalBefore202120142020
TEXT (18257) --> ReturneeStatus
TEXT (4886) --> initiallydisplacedCountry
TEXT (4129) --> InitiallydisplacedState
TEXT (4726) --> InitiallydisplacedLGA
TEXT (6290) --> InitiallydisplacedWARD
INTEGER (785) --> MajorityYearofReturns2024HH
INTEGER (1029) --> MajorityYearofReturns2024IND
INTEGER (835) --> MajorityYearofReturns2023HH
INTEGER (1058) --> MajorityYearofReturns2023IND
INTEGER (885) --> MajorityYearofReturns2022HH
INTEGER (1093) --> MajorityYearofReturns2022IND
INTEGER (965) --> MajorityYearofReturns2021HH
INTEGER (1218) --> MajorityYearofReturns2021IND
INTEGER (1979) --> MajorityYearofReturns20142020HH
INTEGER (2537) --> MajorityYearofReturns20142020IND
INTEGER (4693) --> MaleInfants1y
INTEGER (4912) --> FemaleInfants1y
INTEGER (5759) --> MaleChildren15y
INTEGER (6000) --> FemaleChildren15y
INTEGER (6112) --> MaleChildren612y
INTEGER (6304) --> FemaleChildren612y
INTEGER (6246) --> MaleYouth1317y
INTEGER (6441) --> FemaleYouth1317y
INTEGER (6961) --> MaleAdults1859y
INTEGER (7109) --> FemaleAdults1859y
INTEGER (4420) --> MaleElderly60y
INTEGER (4491) --> FemaleElderly60y
INTEGER (8248) --> TotalMale
INTEGER (8523) --> TotalFemale
