seed_themes.sql

INSERT INTO themes (id, name, definitions, keywords, examples, status)
VALUES
(
  '550e8400-e29b-41d4-a716-446655440001'::UUID,
  'Poverty and Economic Barriers',
  'This theme captures insights where families link irregular school attendance or dropouts to financial hardship. It includes responses describing how poverty forces children to prioritize work over education, how households depend on children''s income for survival, and how limited resources—such as inability to afford uniforms, books, or transport—become barriers to schooling.',
  'Poor,no money,lack of money,financial constraints,child labour,economic constraint,unemployment,financial difficulties,no fees,school fees,can''t afford,daily wage,labourer,cannot buy books,no money for uniform,financial problems,poor economic condition,economic condition,education hampered,family affect,child labour,no money for fees,cannot afford school,daily wage family,BPL family,landless family,no stable income,food insecurity,school dress not affordable,no money for travel,scholarship not received,deprived community,tribal poverty,wage labor family,farm labor family,migrant labor family,sending children to work,child labor poverty,cannot afford books,financial condition,household chores,brick kiln,graze goats,earn living,enough money,failed matriculation,uniform dress,scholarship hostel,migrant workers,seasonal work,goat herding,kiln work',
  'Due to economic constraints, families force girls to engage in domestic work or labour, which hinders their education|Due to poor financial condition, the girl is not able to study|Poverty in the society is another challenge that affects education|Financial constraints and poverty were major challenges for some families in educating their daughters|Unemployment in the family is a significant problem that affects children''s education|Financial difficulties greatly affect a child''s education|Education is hampered due to poverty|We are poor people, if we spend all our money on the girl''s education then where will we get the money for her marriage.|due to poor economic condition|Financial difficulties greatly affect a child''s education.|due to poor economic conditions|Education has been hampered due to poverty|Education is being hampered due to poverty|Due to poor financial condition the girl is not able to study.|Education hampered due to poverty|Some children are not going to school due to poverty.|Children are not going to school because of poverty.|Education was hampered due to poverty|Some children are also unable to attend school due to poverty.|Some children are unable to go to school due to poverty.|Children are also unable to go to school due to poverty.|Children are also not able to go to school due to poverty.|Children are not going to school due to poverty|Some children do not go to school due to poverty.|Children do not go to school because of poverty|Children cannot go to school due to poverty|I have three children and I am saying how will I educate them. I am facing a big problem in educating my children. I am unemployed and I do not have money to educate my children and take them forward.|Children do not get a single penny and when they go to the bank people are told that this money will be spent and children do not get a single penny and they do not even take responsibility for it.|We are poor, our child grows mangoes in the garden and that is our livelihood, if he goes to study then who will take care of him, studies after eight o''clock cost money, we don''t have money|During the meeting, people of the community said that we are working hard to educate our children but the children are not getting jobs and the paper is being sold and leaked for money.',
  'approved'
),
(
  '550e8400-e29b-41d4-a716-446655440002'::UUID,
  'Legal Document linked Barriers',
  'This theme includes responses where children are unable to enroll in school due to missing or incomplete legal documents such as Aadhaar cards, birth certificates, or identity proofs. It captures how lack of proper documentation creates administrative hurdles that keep children out of the education system.',
  'No Aadhar card,no aadhaar,no adhar,aadhar card not made,no birth certificate,lack of Aadhar card,no ID,no id proof,no legal document,no identity proof,enrollment barriers,admission refused,adhar,aadhaar,certificate not made,document pending,lack aadhar,having aadhar,birth certificate,unable study,Aadhaar card errors,date of birth missing,name mismatch,no birth date,birth certificate pending,enrollment blocked,documents not accepted,UID not made,government ID,aadhar errors,aadhaar update,not enrolled due to document,admission refused without document,no documents for school,identity not proven,date of birth not recorded,certificate not available,proper documentation,caste certificate,residence certificate,child registration,non enrolment,wrong name',
  'Aadhar cards of children have not been made, due to which they are not getting admission in school|Due to lack of Aadhar cards, schools in the community are facing challenges in enrolling children|Children are not getting admission due to lack of Aadhaar card, which is affecting their education|Due to lack of Aadhar card|The child does not have an Aadhaar card|A child does not have an Aadhaar card|Child does not have an Aadhaar card|Some children do not have Aadhaar cards|Children do not have Aadhaar cards|The child did not have an Aadhaar card|Many children do not have Aadhaar cards|Another child did not have an Aadhaar card|There are many children who do not have Aadhaar cards.|Children do not have Aadhaar card|Your child does not have an Aadhaar card|Due to not having Aadhar card|Some children are unable to enroll in school without an Aadhaar card.|The community faces challenges in enrolling children in school due to lack of Aadhar cards.|Some children are not enrolled in school because they do not have Aadhaar cards.|Children not getting admission in school due to lack of Aadhaar card|The child there did not have an Aadhaar card|Children did not have Aadhaar card|Many children are not enrolled in school because their Aadhaar cards are not made.|Many children could not be enrolled in school due to lack of Aadhaar card.|Many children do not have an Aadhaar card.|There is a child who does not have an Aadhaar card.|One child did not have an Aadhaar card|Most of the children do not have Aadhaar card.|Through Shiksha Chaupal, it was learnt that Archana Kumari, daughter of Pramod Sharma and Kaushalya Devi, is not getting a job in the college due to wrong date of birth in her Aadhar card.|Nirahua Chunariya Aayegi will give information about getting all those who do not have birth certificate and Aadhar card made and through Shiksha Chappal, he has to select the beneficiary',
  'approved'
),
(
  '550e8400-e29b-41d4-a716-446655440003'::UUID,
  'Early Marriage',
  'This theme captures responses where child marriage or early marriage prevents girls from continuing their education. It includes situations where early marriage leads to school dropout, limits learning opportunities, or shifts responsibilities toward household duties instead of schooling.',
  'Child marriage,marriage,early marriage,shadi,vivah,baal vivah,underage marriage,married off,got married young,left school after marriage,nikah,banning child marriage,marriage girls,run away,ban child marriage,married after,girls should,preventing child marriage,marriage before 18,underage marriage,minor married,married in childhood,marriage at 14,marriage at 15,married before school complete,dropout after marriage,forced to marry,marriage arranged young,married off early,engagement of minor,nikah at young age,early nikah,married off daughters early,girls withdrawn for marriage,marry after 18,married class 8, adolescent marriage,forced marriage',
  'Child marriage is prevalent which causes girls to drop out of school before completing their education|Child marriage is a prevalent issue in the community|We are poor people, if we spend all our money on the girl''s education then where will we get the money for her marriage.|Banning child marriage|Child marriage should be banned|Child marriage was discussed|There is a problem of child marriage in the community|Child marriage causes girls to drop out of school.|Banning child marriage as it is a legal offence|The community faces the issue of child marriage.|Child marriage is hindering girls'' ability to continue their education.|There was a discussion on child marriage|Many girls drop out of school because of child marriage.|Child marriage is another challenge faced by the community which affects the education of children.|Child marriage is a significant challenge that hinders education|Early marriage of girls hinders their education|Child marriage is a prevalent problem affecting children''s education.|Decision taken to ban child marriage|Due to child marriage, girls'' education gets interrupted and due to marriage they are unable to study further.|Early marriage also affects education, as girls are unable to study.|Girls dropping out of school after completing 8th grade due to financial situations and child marriage.|Child marriage at an early age prevents girls from pursuing education.|Girls are not able to complete their education due to being married at an early age.|Denial of education: Child marriage often forces girls to drop out of school, depriving them of the necessary education and skills they need to earn an income and build a better life.|Child marriage is a significant issue in our community, affecting the education and well-being of young girls.|Due to child marriage, girls are unable to get education.|Child marriage is a significant problem in the community, causing problems for children and their families.|The ban on child marriage was explained.|Girls face barriers to education due to child marriage|We are poor, if we educate our daughter till the age of 18, then by the time she gets married, we will be old, so where will we get the money for her marriage?',
  'approved'
),
(
  '550e8400-e29b-41d4-a716-446655440004'::UUID,
  'Distance and Accessibility Issues',
  'This theme captures challenges that prevent children from attending school due to physical and environmental conditions. It includes long distances to school, poor road or transport infrastructure, and difficulties caused by weather or seasonal factors (such as heavy rains, heat, or floods). These conditions make daily travel to school inconvenient, unreliable, or physically demanding for children.',
  'school is far,distance of school,no bus,lack of transportation,no road,roads are bad,no school in village,rain,hot,heat,sun,has to walk a lot,long distances,no clean roads,flood,waterlogged,muddy road,no transport facility,remote village,far away,school far,very far,long distance walk,cycle not provided,bicycle for girls,no vehicle,long walk,remote area,school far from village,bad road condition,unpaved road,seasonal flooding,monsoon rain,extreme heat walking,rough terrain,hilly area,no public transport,inaccessible village,bad weather attendance,transportation system,gram panchayat road,no high school',
  'The school is very far from the village|If the school is far away, children cannot go there|The child is unable to reach school due to rain|There is no school in the village, the school is very far from the village, due to this the girls leave their studies midway|The transportation system is a significant problem, making it difficult for children to reach school on time|There is a lack of buses for children and teachers to come to class|Children are not able to go to school because the school is far away and the roads are bad so they cannot go to study|The child is unable to go to school because of the heat|Sun, heat, rain and rain create hindrance in studies|If the school is far away, children cannot go there.|Children are not going to school because the school is far away.|Some children are not going to school because the school is far away.|The school is quite far from the village.|Children are not attending school because the school is far away.|The school is far away from the village|The school is far from the village.|Children are unable to go to school because the school is far away|Due to the school being far away, the children are not going to school.|In our village the school is very far from the village|The school is very far away, so children cannot go there|Children are unable to study because the school is far away|Children do not go to school because the school is far away|The school is far away, making it difficult for children to attend.|Children are unable to attend school because the school is far away|Children are not able to study because the school is far away.|Some children are unable to attend school because the school is far away.|Due to the distance of the school, children face difficulty in commuting.|Children don''t go to school because the school is far away|The garden there is not educated, that is why children are not able to study well. Some children study, some people do not study. They do not pay attention to education. They take care of the animals.|Pinki Devi also said that she wanted to marry her daughter after educating her till class 10, reflecting the common practice of early marriage and the limited importance given to education for girls.',
  'approved'
),
(
  '550e8400-e29b-41d4-a716-446655440005'::UUID,
  'Parental Attitudes and Socio-Cultural Barriers',
  'This theme captures responses where parental beliefs, family mindsets, and cultural norms discourage girls from attending school. It includes attitudes such as prioritizing domestic roles for girls, believing education is unnecessary for them, concerns about dowry increasing with higher education, or long-standing traditions that limit girls'' mobility and learning opportunities. These socio-cultural factors collectively shape decisions that keep girls out of school.',
  'Discrimination,cultural beliefs,social pressure,not allowed,marriage,dowry,take care of siblings,girls do not need to study,girls run away,speak foul language,purdah,burkha,ghoonghat,caste,Dalit,SC ST,gender discrimination,religious restriction,much dowry,self esteem,lack role model,where will,after studying,villagers here,girls not allowed to go out,boys prioritized,gender inequality,girls restricted,girls kept at home,community norms,village tradition,conservative family,religious restrictions for girls,girls no need to study,girls should stay home,family honor at stake,girls not permitted,purdah system,women seclusion,girls education waste,cook food,become officer,role models,educational aspirations,urdu medium,what will she do,housework,no son,daughter burden,speech weak,mother tongue',
  'Cultural beliefs that girls do not need education because they will only get married and stay at home are a major challenge|Gender discrimination is a significant issue in the community, affecting the education and empowerment of girls|Purdah system is prevalent in Muslim community, due to which we do not send teenage girls out|The community believes that educating girls will increase the demand for dowry|Social discrimination based on caste or gender also leads to low participation|Social pressure was identified as another challenge that can prevent girls from pursuing their education|Girls leave their studies and run away. Due to this fear, parents are unable to provide higher education to their daughters|Parents are afraid that their daughters might get exposed to foul language and hence do not allow them to go to school|Girls are not allowed to study for fear of going astray or running away|The villagers here say that what will the girl do after studying, if she studies then from where will they get so much dowry for her marriage.|The villagers here said that what will the girl do after studying, even if she studies then from where will they get so much dowry for her marriage.|We are poor people, if we spend all our money on the girl''s education then where will we get the money for her marriage.|Child marriage|Parents are afraid that girls may be exposed to foul language and hence do not allow them to go to school.|Due to poverty, children are deprived of education.|Some girls have not been able to enroll in school due to lack of Aadhaar card.|Some girls are not getting enrolled in school due to lack of Aadhar card.|Girls could not enroll in school due to lack of Aadhaar card|Some girls there are not getting enrolled in school due to Aadhar card, hence their education is hampered.|Girls are unable to enroll in school due to lack of Aadhaar card|Some girls are unable to go to school due to lack of Aadhaar card.|There are some girls who have not yet made their Aadhar card and due to not having Aadhar card they are never able to go to school.|There is a girl in this locality who is 16 years old, her sister is doing matriculation and intermediate, the third sister does not study, what will she do by studying, she has to cook the food only.|During the village meeting, Didi said that I have 5 daughters and I stay at home and take care of them. Didi said that we go to work in the fields and because of this I am not able to go to school.|Her mother was saying that we will not educate our daughter because we are sending her to impress girls, many girls are running away so how will we educate our daughter, we will educate our son|We explained a lot to that girl that you have studied matriculation but you cannot read Hindi, this is a very sad thing, you are sitting at home and reading Hindi by watching it on your mobile.|Emphasis should be laid on the education of girls and girls should be given the status of daughter or daughter-in-law at least till 12th class and should be given as much education as possible|Didi has two children, they study, they get books from the government, they get money for food, but their parents live in poverty, and they need additional support to continue their education.|A woman was telling the Chaupal that Didi, I have passed Matriculation and I want to study further, so Didi you people please make my mother-in-law understand so that I can study further.|Six Jain household children are facing problems. They are playing with the group and are not paying attention to their studies. Their names are registered but they are not going to study.',
  'approved'
),
(
  '550e8400-e29b-41d4-a716-446655440006'::UUID,
  'School Infrastructure and Facility Issues',
  'This theme captures responses highlighting gaps in school facilities and infrastructure gaps. It includes issues such as inadequate classrooms, lack of basic amenities, insufficient learning resources, as well as delays, inconsistencies, or limited access to government schemes. Together, these systemic gaps reduce the attractiveness and effectiveness of schooling for children and families.',
  'No clean water,toilets,mid day meal,scholarships,playgrounds,classrooms,pads,hygiene,books,uniforms,government schemes,sanitation,infrastructure,clean,cleanliness,no library,shortage of books,basic facilities,no electricity,no fan,PM Poshan,MDM,scholarship not received,hot meals,drinking water,reading corner,environment around school,conducive learning,well being,no toilet for girls,broken toilet,no drinking water in school,no separate toilet,no library,school building broken,no electricity in school,no blackboard,books not given on time,uniform not distributed,mid-day meal stopped,bad quality food,MDM irregularly provided,no playground,no boundary wall school,school not child friendly,compound system,play materials,water tank,coaching centre,special needs,anganwadi center,kasturba vidyalaya,upper primary school,disabled child,seating arrangement,menstruation facilities,reading interest,extracurricular',
  'Our school children are not given books on time|The benefits of government schemes are not being received, due to which children are not going to school|Children did not get uniforms|Sanitary pads are not provided in school|Mid day meals are not provided properly to the children in the school|Lack of toilets in schools|Girls face significant barriers to accessing education due to poor infrastructure and lack of resources|Lack of school infrastructure, including poor classrooms, sanitation facilities, water, and transportation, hinders the learning environment|There is no water in the toilet|There is no fan facility in my school|Drinking water is a challenge in schools|There are not enough playgrounds for sports children|The environment around the school is not clean, which affects the health and well-being of children|The library lacks sufficient books for students|There is no school in the village, the school is very far from the village, due to this the girls leave their studies midway|The school is very far from the village|The child is unable to go to school because of the heat|The child is unable to reach school due to rain|Sun, heat, rain and rain create hindrance in studies|Children are not able to go to school because the school is far away and the roads are bad so they cannot go to study|Mid-day meals are not provided properly to the children in the school|Drinking water is a challenge in schools.|If the school is far away, children cannot go there.|The transportation system is a significant problem, making it difficult for children to reach school on time.|There is a lack of buses for children and teachers to come to class.|The school is quite far from the village.|There are not enough playgrounds for sports children.|Lack of toilets in schools.|Due to poverty, the guardian is somehow educating him and after passing the eighth grade, she wants to send him to Kasturba for further studies as his studies will not stop further.|When you send your child to school, he runs off to play and says he has gone to school. Some other person asks whether your daughter or son is studying in school or roaming around.',
  'approved'
),
(
  '550e8400-e29b-41d4-a716-446655440007'::UUID,
  'Teacher Capacity and Quality Issues',
  'This theme covers responses highlighting challenges related to insufficient teachers or concerns about teaching quality. It includes issues such as vacant positions, irregular teacher attendance, overburdened staff, and gaps in subject knowledge or pedagogy. These factors affect the learning environment and reduce children''s motivation to attend school regularly.',
  'Shortage,quality issue,teacher not on time,dont pay attention,slow learning progress,academic progress,lack in academics,Lack of english education,para teacher,shiksha mitra,single teacher,teacher absent,no subject teacher,election duty,teacher vacancy,learning progress,english medium,illiterate parents,children learning,teacher transfer,frequent teacher change,teacher absent regularly,no subject-wise teacher,no trained teacher,multi-grade teaching,overcrowded classroom,children not learning,reading not improved,numeracy weak,teacher on election duty,teacher not attentive,no English teacher,poor teaching quality,children learning slow,learning english,kasturba gandhi,struck off,rural areas,digital divide,internet access,english learning,government schools,subject recruitment,tola sevak',
  'There is a shortage of teachers in the school, due to which subject-wise studies are not done|The work of the teacher is not being done properly in our school|Attendance of teachers is a problem|Teachers do not come to school on time|Teachers do not pay attention to them|The quality of teachers is a major concern|The community lacks education, training and management of teachers, which affects the quality of teaching|Lack of language-specific teachers in school|Children''s learning progress is a challenge|There is a lack of English medium education in government schools|Children''s learning progress is a challenge.|Teachers don''t come to school on time|The quality of teachers is a major concern.|Attendance of teachers is a problem.|Teachers do not pay attention|Children are not going to school due to the negligence of parents|Negligence of parents hinders children''s education.|Children do not go to school due to the negligence of parents|Some children do not want to study further.|Some children do not want to study|Some children don''t want to study.|Negligence of parents hinders the education of children.|Negligence of parents hinders education|Negligence in education due to parental negligence|Teachers do not pay attention to them.|Some children do not want to study.|Negligence of parents towards education.|The girl there left her studies after 8th standard and when she went to school the teacher did not register her name. This happened 5 to 6 years ago and the children of today are studying.|Education was provided for the public welfare of the girls concerned through Japan and in case of dropping out of studies, their name and their father''s name were recorded in their diary.|The community is concerned about offering English medium classes up to the 7th grade and the potential difficulties high school students may face when transferring to another school.',
  'approved'
),
(
  '550e8400-e29b-41d4-a716-446655440008'::UUID,
  'Safety Concerns',
  'This theme includes responses where children''s school attendance is affected by worries related to their overall safety and security. It covers issues such as unsafe routes, harassment, or any situation that makes families feel that the environment around schooling is not secure enough for children to travel or attend regularly.',
  'Harassment,molestation,eve-teasing,tease,violence,environment around house,house surroundings,no boundary wall,unsafe path,caste harassment,bullying,unsafe for girls,no street light,deserted road,domestic violence,public places,child safety,safety public,gender-based violence,violence against women,accident on road,stray animals danger,dark road at night,no street lighting,unsafe playground,physical abuse at school,corporal punishment,girls followed,bad elements near school,crime near school,children not safe traveling,sexual harassment fear,teasing on route,no police protection,unsafe area for girls,eve teasing,molested,flirting,miscreants,drunk public,school vandalism,unsafe routes',
  'The presence of stray dogs on the streets as children walk to school raises concerns about their safety|Violence against women is a significant issue|It is a challenge for parents in the village to protect their girls from molestation|Seeing the atmosphere of the village, there is a fear in the minds of parents that someone might tease their daughter|Musahar children face harassment from other children in school because of their caste, which causes them to develop fear and reluctance to go to school|The school premises do not have a boundary wall, which poses a security threat|Girls are harassed on their way to school due to which they are afraid and are refusing to go to school|The community raised concerns about the environment around the house|Violence against women is a significant issue.|It is also a challenge for parents in the village to protect their girls from molestation.|Children are unable to study because the school is far away|Children are not able to study because the school is far away.|Due to the distance of the school, children face difficulty in commuting.|Children are not able to study properly because the school is far away.|Children are unable to study well because the school is far away.|Children are unable to complete their studies because the school is far away.|Due to school being far away, children are not able to study.|Parents are afraid to send their children to school.|Children cannot study because the school is far away.|Children face difficulty in commuting as the school is far away.|Parents are afraid to send their daughters to school due to lack of safe transportation like buses and distance of the school.|The school being far away causes difficulty for children in commuting.|The school is far away and children have to face difficulties in commuting, due to which many children do not go to school.|Due to the school being far away, children have a lot of problems in commuting to and from school.|Didi told that our husband drinks alcohol, he spent all his earnings on alcohol for educating the boy and girl, she has to leave her studies because of poverty|During the school holidays, the miscreants go inside the school and break the windows of the classrooms, drinking alcohol and vandalizing the school premises.|A woman suffering from alcoholism is beaten by her husband, he does not even bear her expenses and interrupts her during conversations.|He developed a big addiction from a young age due to which he used to work in fire like working in a furnace, working on a tractor etc.|After passing the eighth grade, hearing the news of rape makes the girl afraid to send her to a distant high school or college.|A lady said that the school level ko school girl punishment pata north doorao jaaye very surprised very two school mouse le',
  'approved'
),
(
  '550e8400-e29b-41d4-a716-446655440009'::UUID,
  'Substance Abuse and Addiction',
  'This theme captures responses where children''s education is affected by alcohol or drug use within the family or community, as well as issues like gambling or addiction to online games. These problems create unstable home environments, distract children from studies, and contribute to irregular attendance or dropout.',
  'Addiction,Addicted,Alcohol,Drugs,Alcoholism,online games,mobile phones,Gambling,sharab,daru,nasha,ganja,drunk father,mobile addiction,drinking problem,alcohol addiction,use mobile,online gaming,using mobile,children mobile phones,father drinks,husband alcohol,drunk parent,neglect due to alcohol,drug use in community,gutka,tobacco addiction,mobile gaming addiction,smartphone overuse,screen time excessive,children watch videos all day,internet addiction,children distracted by phone,online gaming harm,alcoholic parent neglect,drunkard father,marijuana',
  'Gambling addiction in children|Children''s education is affected by alcohol|Drug addiction is a significant challenge that is affecting the education of children in the community|The father is an alcoholic, so the daughter is being forced to study|Alcohol addiction in a household member is a problem|Children use mobile phones more often|Children are increasingly playing online games using mobile phones|Alcohol addiction in a household member is a problem.|Children are increasingly using mobile phones to play online games.|Alcohol addiction among members of the household is a problem.|About alcohol addiction in a household member|There is an issue of alcohol addiction among members of the household.|About children using mobile phones more often|Improving education of children affected by drug addiction|Children are spending more time playing online games using mobile phones, which is affecting their education.|A parent said that nowadays mobile phones have become a part of sending children to school, so children are not studying.|Children use mobile phones too much and do not concentrate on studies.|Nowadays children spend most of their time on mobile phones.|About the alcohol addiction of members of the household|Children do not go to school because they are too busy watching mobile phones|Children spend a lot of their time on mobile phones.|Children use mobile phones excessively|Household members addicted to alcohol|Drug addiction is another challenge that hinders the educational progress of children.|Increased mobile phone use among children|Alcohol addiction among household members is a challenge.|Children''s mobile phone use is increasing|Children''s education affected due to drug addiction|Parents say that children get spoiled by using mobile phones, so we do not teach them because they are not interested in studying and remain busy with the mobile phones.|Some children do not attend school due to excessive use of mobile phones.',
  'approved'
)
ON CONFLICT (name) DO NOTHING;