Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

API Notifications and Updates for Integrators #504

Open
MikeCraig418 opened this issue Jun 9, 2020 · 9 comments
Open

API Notifications and Updates for Integrators #504

MikeCraig418 opened this issue Jun 9, 2020 · 9 comments
Labels
Engineering Changes our tools and data pipeline

Comments

@MikeCraig418
Copy link
Collaborator

MikeCraig418 commented Jun 9, 2020

Are you currently integrating with 2020PB data? Subscribe to this issue to be notified when the official data feed receives new features, new data feeds become available, or ancillary APIs are updated.

JSON-V2 / CSV / MD API to build your own front end

  • Version 1.0 stable

RESTful API that includes geolocation data

  • Version 1.0 stable - add /incidents endpoint with geocoding and direct video mp4 links from attributed sources
  • 1.1 (2020-06-09) - add /legislators endpoint with contact information for House and Senate members
  • 1.2 (2020-06-09) - add ?filer[field]=value capabilities for all end points

REST API that points to backed-up video files

  • Version 1.0 stable
@ubershmekel ubershmekel pinned this issue Jun 9, 2020
@ubershmekel ubershmekel added the Engineering Changes our tools and data pipeline label Jun 9, 2020
@hossain-khan
Copy link
Collaborator

hossain-khan commented Jun 9, 2020

Subscribed to it 👍 . Quick question about the RESTful API, is it maintained by the same 2020PB community? or it's individual effort to provide convenient API for the same data set?

EDIT: Sorry, I just noticed that @949mac is the owner of the RESTful API repository 😊. I also posted some questions on that repo.

@MikeCraig418
Copy link
Collaborator Author

@amardeshbd, My API pulls directly from the data feed that @ubershmekel wrote. I'm actively involved with the team here :) And will continue to support them and you.

Happy coding!

@nickatnight
Copy link

What a champ @949mac hell ya

@jlev
Copy link

jlev commented Jun 11, 2020

I've also set up a site to map and provide more local context and actions for readers (mayor and chief of police phone numbers, military equipment transferred under 1033). It's using the API from @nickatnight, but I can switch to using GitHub hosted json directly if that's preferable. Gatsby is pretty flexible...

https://policebrutality.media/

@MikeCraig418
Copy link
Collaborator Author

@jlev - Thanks for integrating! Your project looks great. Can you show me an example of the 1033 transfer? That sounds interesting.

@jlev
Copy link

jlev commented Jun 11, 2020

The 1033 program is where local police departments get surplus military equipment from the Defense Logistics Agency. They issue quarterly reports at https://www.dla.mil/DispositionServices/Offers/Reutilization/LawEnforcement/PublicInformation/ in a huge excel file.

Marshall Project has scripts to clean the file and all the quarterly reports archived from 2014-2020
https://github.com/themarshallproject/dod1033

@dannguyen is doing a bunch of work to clean that up and export to CSV by state and agency.
https://github.com/dannguyen/dod-leso-1033-data

@rainmaker rainmaker unpinned this issue Jun 26, 2020
@ubershmekel
Copy link
Collaborator

ubershmekel commented Jun 28, 2020

The v2 data json is live at https://raw.githubusercontent.com/2020PB/police-brutality/data_build/all-locations-v2.json

New things are:

  • tags
  • description
  • text describing each link

Gonna update a few of the links soon, and update the readme

@hossain-khan
Copy link
Collaborator

This is incredible as to how all the incident now has description! Amazing work by the community! 🙏

Here is a visual diff of schema change for v2
json-schema-visual-diff

@949mac do you have any plan to integrate this into the existing 846-backend? I think this also needs to be versioned because of the link description.

@nickatnight
Copy link

@ubershmekel wow nice chief! Can't wait to integrate this into my api

@ubershmekel ubershmekel pinned this issue Jul 9, 2020
@dostran4 dostran4 unpinned this issue Jul 17, 2020
@dostran4 dostran4 pinned this issue Jul 17, 2020
@SiP-C SiP-C unpinned this issue Aug 4, 2020
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
Engineering Changes our tools and data pipeline
Projects
None yet
Development

No branches or pull requests

5 participants