Ubudehe Livestock 1

Ubudehe Livestock 1 from Rwanda NISR

@kaggle.jprukundo_ubudehelivestock1

Table List

1 table(368.34 KB)

S08a1 Livestock

@kaggle.jprukundo_ubudehelivestock1.s08a1_livestock

368.34 KB
78432 rows
24 columns

hhid HHID	province PROVINCE	district DISTRICT	urb2002 URB2002	quintile QUINTILE	poverty POVERTY	hh_wt HH WT	cluster CLUSTER	item ITEM	s8a1q2 S8A1Q2	s8a1q3 S8A1Q3	s8a1q4 S8A1Q4	s8a1q5 S8A1Q5	s8a1q6 S8A1Q6	s8a1q9 S8A1Q9	s8a1q12 S8A1Q12	s8a1q14 S8A1Q14	s8a1q15 S8A1Q15	s8a1q16 S8A1Q16
100040	Kigali City	101	Urban	Q5	Non-poor	121.8516999	10005	Cattle	1	1	1	120000	2	2	2	nan	2
100040	Kigali City	101	Urban	Q5	Non-poor	121.8516999	10005	Sheep	2							nan
100040	Kigali City	101	Urban	Q5	Non-poor	121.8516999	10005	Goats	1	2	3	18000	2	2	2	nan	2
100040	Kigali City	101	Urban	Q5	Non-poor	121.8516999	10005	Pigs	2							nan
100040	Kigali City	101	Urban	Q5	Non-poor	121.8516999	10005	Rabbits	2							nan
100040	Kigali City	101	Urban	Q5	Non-poor	121.8516999	10005	Chickens	2							nan
100040	Kigali City	101	Urban	Q5	Non-poor	121.8516999	10005	Other poultry	2							nan
100040	Kigali City	101	Urban	Q5	Non-poor	121.8516999	10005	Other Livestock	2							nan
100050	Kigali City	101	Rural	Q5	Non-poor	184.6104255	10006	Cattle	1	2	1	200000	2	2	2	nan	1	30000
100050	Kigali City	101	Rural	Q5	Non-poor	184.6104255	10006	Sheep	2							nan


CREATE TABLE s08a1_livestock (
  "hhid" BIGINT,
  "province" VARCHAR,
  "district" BIGINT,
  "urb2002" VARCHAR,
  "quintile" VARCHAR,
  "poverty" VARCHAR,
  "hh_wt" DOUBLE,
  "cluster" BIGINT,
  "item" VARCHAR,
  "s8a1q2" BIGINT,
  "s8a1q3" DOUBLE,
  "s8a1q4" DOUBLE,
  "s8a1q5" DOUBLE,
  "s8a1q6" DOUBLE,
  "s8a1q7" DOUBLE,
  "s8a1q8" DOUBLE,
  "s8a1q9" DOUBLE,
  "s8a1q10" DOUBLE,
  "s8a1q11" DOUBLE,
  "s8a1q12" DOUBLE,
  "s8a1q13" DOUBLE,
  "s8a1q14" VARCHAR,
  "s8a1q15" DOUBLE,
  "s8a1q16" DOUBLE
);