Collate resources for Module 1 - Data Collection - Session 1

[apoorv74]

Topics

• Data organisation in spreadsheets
• Data quality parameters
• Working with PDFs
• Data scraping vs Data standards
• No code tools for collecting data from the web

Case Study

• Can we create a data standard for publishing crime statistics ?
• What is Akoma Ntoso ?

Skills acquired

• Best practices to work with any spreadsheet tool like Excel, Google Sheets, etc
• Learning to assess and measure the quality of datasets
• Working with public datasets
• Collecting data from PDF files without writing code
• Understanding the difference between building processes to scrape data regularly vs investing in creating data standards
• Using tools to collect data from the web especially from pages which include tabular data

[apoorv74]

Session Structure

Session 1 - Plan

Session Time: 2 hours

• Data Collection
  • Primary Sources (Surveys, Books, Interviews, Pictures, etc)
  • Secondary Sources
    • Excel sheets (Cite: Data organization in spreadsheets)
    • PDFs (PDF to CSV)
    • Websites (Web scraping)
      • No code web scraping
      • Web scraping tools, terminologies and ethics
• Data Quality Assessments
• Introduction about the second session [Data scraping vs Data standards]

Case Study 1

Topic - Collecting data to analyse state level trends in victim compensation Data Source - Link

---

Session 2 - Plan

Session Time: 2 hours

• Summary of topics discussed in the first session
  • Queries/Feedback, etc
• Data Standards [What / Why / How]
  • Examples of a few common standards
  • Examples of Data standards in the Law and Justice space

Case Study 2 - Standardizing Crime Records in the country

[apoorv74]

Resources

• CSV Lint - https://csvlint.io/ - Validate CSV files

[apoorv74]

Stories

• https://www.thequint.com/news/law/how-delhi-courts-penalise-the-poor-through-mechanical-remand#read-more The Quint analysed 153 remand orders passed by magistrates from all trial courts in Delhi, during the peak of the second wave (30 April-15 June). To substantiate the themes emerging from the remand orders, they interviewed 25 remand lawyers (legal aid counsel) empanelled with the District Legal Services Authority across the state.

[samwhocodes]

Stories

• https://thewire.in/law/supreme-court-foreign-citations-study This study is an interesting one where the researcher has collected data from judgements of 43 countries and analysed them. They divided the reference period into two parts (2009-2014 and 2014-2020). The study concluded that there has been a clear decline in the number of times international judges cite Indian judgments in their own rulings by identifying the frequency and pattern of citations of the Supreme Court of India's judgments.

• https://link.springer.com/chapter/10.1007%2F978-981-15-3129-3_6 In addition to the judicial system, views of general citizens of the country also contribute toward the retention or rejection of capital punishment. The study was an exploratory survey that collected 25210 responses from general population from almost all states and union territories of India. “Research indicates that opinions of citizens on death penalty vary according to factors such as demographic variables (like age, gender, and education qualification), social values, and beliefs.”