already = ''
while True:
import os
import time
import requests
spd_roster = requests.get('https://communities.socrata.com/resource/c6fs-9giq.json?department=Police Department&$limit=20000').json()
data = os.popen("curl 'http://blue.kingcounty.gov/Courts/Detention/JILS/Default.aspx/GetBookedInLast24Hours' -H 'Cookie: __utma=118493014.656529117.1448050044.1455518831.1458849260.3; __utmz=118493014.1455385038.1.1.utmcsr=google|utmccn=(organic)|utmcmd=organic|utmctr=(not%20provided); _ceg.s=o4tlw0; _ceg.u=o4tlw0; ASP.NET_SessionId=meymw2fuyd23ru1zmff0mdqn; _gat=1; _ga=GA1.2.656529117.1448050044' -H 'Accept-Encoding: gzip, deflate, sdch' -H 'Accept-Language: en-US,en;q=0.8,es;q=0.6' -H 'User-Agent: Mozilla/5.0 (Windows NT 6.3; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/49.0.2623.112 Safari/537.36' -H 'Content-Type: application/json' -H 'Accept: */*' -H 'Referer: http://blue.kingcounty.gov/Courts/Detention/JILS/default.aspx' -H 'X-Requested-With: XMLHttpRequest' -H 'Connection: keep-alive' --compressed").read()
import json
data = json.loads(data)['d']
data = json.loads(data)
data = data['People']
for person in data:
if str(person) in already:
continue
already += str(person)
name = person['LastName']+', '+person['FirstName']
if name.lower() in str(spd_roster).lower():
print person, name, 'yes'
for row in spd_roster:
if name.lower() == row['employee'].lower():
print row
job_title = row['job_title']
print 'curl -X POST http://textbelt.com/text -d number=2067330105 -d "message=%s %s"' % (name, job_title)
print os.system('curl -X POST http://textbelt.com/text -d number=2067330105 -d "message=%s %s"' % (name, job_title))
print os.system('curl -X POST http://textbelt.com/text -d number=6144406403 -d "message=%s %s"' % (name, job_title))
time.sleep(5*60)
{u'RealLastName': u'MARTIN', u'FirstName': u'MICHAEL', u'LastName': u'MARTIN', u'DateOfBirth': u'08/17/1965 12:00 AM', u'CCN': u'1791980', u'SearchFoundAlias': False, u'CurrentCustodyFacility': u'Seattle Correctional Facility', u'LatestBooking': {u'CustodyStatus': None, u'BA': u'216010787', u'Facility': None, u'Charges': [], u'BookingDateParseError': None, u'ChargesString': u'MULTIPLE', u'ReleaseDateParseError': None, u'ReleaseDate': None, u'CCN': None, u'BailAmount': None, u'BookingDate': u'04/15/2016 03:22 PM'}, u'DateOfBirthParseError': None, u'RealMiddleName': u'JOSEPH', u'RealDateOfBirth': u'08/17/1965 12:00 AM', u'RealJuniorSenior': u'', u'MiddleName': u'JOSEPH', u'Gender': u'M', u'RealDateOfBirthParseError': None, u'JuniorSenior': u'', u'Race': u'Black', u'InCustody': False, u'VinesToolTip': u'This link will take you to the external VINE application, and will allow you to be notified if this inmate is released from King County detention. ', u'VisitingSchedule': None, u'RealFirstName': u'MICHAEL', u'Bookings': [], u'BailOnCurrentBooking': None} MARTIN, MICHAEL yes
{u'department': u'Police Department', u'employee': u'MARTIN, MICHAEL', u'employee_manager_name': u'FOX, LAURA', u'job_title': u'PARKING ENFOR OFFICER'}
curl -X POST http://textbelt.com/text -d number=2067330105 -d "message=MARTIN, MICHAEL PARKING ENFOR OFFICER"
0
0