Summer 2023 KSR DATA LAB

Our goal for the summer is to pull together the threads and loose ends of previous work. Those threads include: 1. A presentation and collaboration platform for our work that can be a model for other similar projects 2. Wikidata as part of the KSR data ecosystem (contributing to and pulling from) 3. Making recommendations to lawmakers for making policies and inventories computational (machine readable) 4. Making California Law Enforcement policies accessible and useful to citizens 5. Making Military Equipment Inventories more visible and understandable to citizens 6. Connecting siloed data to show relationships between past injustices and present harm as well as showing the positive change resulting from activism and civic engagement 7. “Humanizing the harm rather than [just] presenting cold, dead statistics”

Weeks 1-2 (Anabelle)

  1. Quarto. Quarto is now our online publishing platform. It provides a way for people on the team to update content without writing code (just markdown). It is a flexible platform that can take content from Jupyter notebooks, Observable, R, Plotly, etc. and output to a website hosted by github, slide presentations, and print-ready articles.
  2. Establishing data visualization tools and pipelines. KSR data comes from heterogenous sources. That means that we need to be able to access and integrate data stored in different systems. We need to visualize data created by activists and stored in Google Sheets. We need to access community-constructed data in Wikidata and data we have created that is stored in github, the Stanford Digital Repository, and Redivis.

Weeks 3-4 (Anabelle and Chloe)

  1. Source data. Evaluate source datasets for fatalencounters with the police in the US. How are they different? Which should we be using and why?
  2. Interactivity and Lookup. Experiment through building solutions for data interactivity and lookup, e.g. searchbar for exploring the law enforcement agencies.
  3. Wikidata. Create a Wikiproject page for the Systemic Racism Knowledge Graph project. Add/Update California Law Enforcement Agencies, and improve process and tooling for creation of records.

Week 5: Working together at Stanford

Code 
import pandas as pd

def make_clickable(val):
    # target _blank to open new window
    return '<a target="_blank" href="{}">{}</a>'.format(val, val)

sheet_url = 'https://docs.google.com/spreadsheets/d/1G4WIcWJK9c1OKdaeDTRwDgDaJkAqAd-IcUrFwmLr04k/edit#gid=58406731'
url_1 = sheet_url.replace('/edit#gid=', '/export?format=csv&gid=')

pd.read_csv(url_1)
#df.loc[:, ~df.columns.isin(['Unnamed: 6', 'Unnamed: 7', 'Unnamed: 8'])]
Time Monday Tuesday Wednesday Thursday Friday
0 PROGRAM Policy Manuals Day Military Equipment Policy Day Simple Sabotage Day App Building Day Wrap Up
1 9:00-10:00 Meeting - Chloe, Anabelle, Nicole Dig in to Military Equipment policies Index issues around access to manuals, data. Humanize the harm of militarization Our plan for the next few weeks
2 10:00 - 11:00 Review California LEA Policy Manuals Gather sources of evidence of Military equipme... Define standards for publishing military equip... Do these exists in my city, town, neighborhood? ...
3 11:00 - 12:00 CRJ-KSR Meeting Military Equipment ... Community Hour Workshop: Rochelle Lundy
4 12:00 - 1:00 Lunch Lunch with Regina Roberts Field Trip Lunch CESTA interns lunch
5 1:00 - 2:00 Use LLM Military Equiment into Wikidata/Wikimedia to APP Breathe
6 2:00 - 3:00 to ask questions of More MEI Computer History APP Nicole and Chloe depart for SFO
7 3:00 - 4:00 Lexipol Policy Manuals AFSC Meeting Museum APP FLYING

Scheduled activities for the week of July 24-28, 2023

Weeks 6, 7, & 8

  • By the end of this period of time we should have built our Wikidata ecosystem: Enriched entries for Black people killed through interaction with police in California, Military equipment, LEAS, California Legislation, Policies, and, if possible, protests as well.
  • We will build on the Week 5 collaboration to build an interface to the military equipment.
  • We will make progress on writing the Simple Sabotage paper

Weeks 9 & 10

  • Anthology entry
  • Simple Sabotage
  • Documentation of all work on the website

Note: Chloe’s time with us will be officially over. Her contributions to the project will be reflected in the CESTA anthology and in the “Simple Sabotage” paper as co-author.