api_examples.sagews

import requests
import json
payload = {'table': 'tables', 'get': 'datasets'}
payload = json.dumps(payload)
print requests.get('http://ws.insideyourgovernment.com/retrive/', {'payload': payload}).json()

{u'data': {u'fields': [u'classification', u'updatedAt', u'id', u'view_count', u'api_url', u'domain_tags', u'columns_name', u'type', u'metadata', u'description', u'tags', u'domain_category', u'link', u'number_of_rows', u'page_views_last_month', u'domain_metadata', u'categories', u'page_views_total', u'columns_description', u'permalink', u'resource', u'name', u'columns_field_name', u'nbe_fxf', u'page_views_last_week'], u'name': u'Datasets', u'number_of_rows': 16174, u'categories': [u'Information Technology'], u'id': u'datasets'}, u'payload': {u'table': u'tables', u'get': u'datasets'}}

import requests
import json
payload = {'global_search_query': 'case number for 6706@20121209003807'}
payload = json.dumps(payload)
print requests.get('http://ws.insideyourgovernment.com/retrive/', {'payload': payload}).json()['sentence']

The case number is 12-419949.

import requests
import json
payload = {'table': 'datasets', 'page': int(1), 'rows_per_page': int(50), 'order_by': [{'field': 'page_views_last_week', 'direction': 'desc'}]}
payload = json.dumps(payload)
print requests.get('http://ws.insideyourgovernment.com/retrive/', {'payload': payload}).json()['expression']
data = requests.get('http://ws.insideyourgovernment.com/retrive/', {'payload': payload}).json()['data']
for row in data:
    print row['domain'], '|', row['name'], '|', row['page_views_last_week']

r.db('public').table(u'datasets').order_by(r.desc(u'page_views_last_week'), index=r.desc(u'page_views_last_week')).slice(0, 50) data.iae.alberta.ca | Consumer Price Index | 99805 data.cityofboston.gov | Approved Building Permits | 75200 data.iae.alberta.ca | Housing Starts | 72953 data.iae.alberta.ca | Merchandise Exports | 62000 data.iae.alberta.ca | Retail Trade | 56437 data.iae.alberta.ca | Unemployment Rate | 46015 data.iae.alberta.ca | New Motor Vehicle Sales | 40379 data.iae.alberta.ca | Total Value of Building Permits | 36917 data.medicare.gov | Hospital-Acquired Condition Reduction Program | 36902 data.iae.alberta.ca | Manufacturing Shipments | 30428 data.iae.alberta.ca | Inventory of Major Projects | 30363 data.cityofnewyork.us | DOB Job Application Filings | 26490 data.iae.alberta.ca | Employment | 25657 data.cms.gov | Order and Referring | 23857 data.ny.gov | Lottery Cash 4 Life Winning Numbers: Beginning 2014 | 23753 data.iae.alberta.ca | Major Projects | 17141 data.iae.alberta.ca | Business Incorporations | 17095 data.iae.alberta.ca | Net Migration | 16131 data.iae.alberta.ca | Farm Cash Receipts | 15376 data.iae.alberta.ca | Employment Insurance | 14747 data.iae.alberta.ca | Investment | 11620 data.iae.alberta.ca | Energy Prices | 10686 data.iae.alberta.ca | Gross Domestic Product Basic | 9856 data.iae.alberta.ca | Total Number of Completed Apprentices and Individuals Issued Occupation and Qualification Certificates (Totals, Averages and Percent Changes) by Trade, 2007 - 2012 | 9719 data.iae.alberta.ca | Wholesale Trade | 8631 data.iae.alberta.ca | Population | 8279 data.iae.alberta.ca | Average Weekly Earnings | 7309 data.iae.alberta.ca | Full Load Equivalent (FLE) Enrolment in Alberta's Publicly funded post secondary system by Sector and Institution | 6115 data.iae.alberta.ca | Job Vacancies | 5741 data.iae.alberta.ca | Total Number of Apprentices Registered (Totals, Averages and Percent Changes) by Trade, 2007 - 2012 | 5708 data.iae.alberta.ca | Number of New Apprentices Registered (Totals, Averages and Percent Changes) by Trade, 2007 - 2012 | 5558 data.baltimorecity.gov | Calls for Service | 5534 data.cms.gov | Comprehensive Care for Joint Replacement Model: Metropolitan Statistical Areas (MSAs) | 4996 data.iae.alberta.ca | Full Load Equivalent (FLE) Enrolment in Alberta's Publicly funded post secondary system by CIP code | 4623 data.iae.alberta.ca | Other Provinces’ Grade 12-level Courses Acceptable For Admission To Degree Granting Institutions | 4520 data.cityofchicago.org | Current Employee Names, Salaries, and Position Titles | 4472 data.iae.alberta.ca | Productivity | 4250 data.cityofnewyork.us | For Hire Vehicles (FHV) - Active Drivers | 4194 data.iae.alberta.ca | Approved Credential Program Completions in Alberta's Publicly funded post secondary system by Credential Type | 4173 data.healthcare.gov | QHP Landscape Individual Market Medical | 4169 data.iae.alberta.ca | Approved Credential Program Completions in Alberta's Publicly funded post secondary system by Program Content | 3659 data.iae.alberta.ca | Number of Participants in the Registered Apprenticeship Program by Trade as of December 31, 2012 | 3619 data.healthcare.gov | Local Help | 3466 data.healthcare.gov | QHP Landscape Individual Market Dental | 3235 data.cms.gov | Medicare Individual Provider List | 2788 data.iae.alberta.ca | Approved Credential Program Completions in Alberta's Publicly funded post secondary system by Sector and Institution | 2736 data.consumerfinance.gov | Consumer Complaints | 2694 open.whitehouse.gov | The White House - Nominations & Appointments | 2646 open.whitehouse.gov | White House Visitor Records Requests | 2526 data.healthcare.gov | 2016 QHP Landscape Individual Market Medical | 2498

import requests
import json
payload = {'table': 'police_response_events', 'page': int(1)}
payload = json.dumps(payload)
print requests.get('http://ws.insideyourgovernment.com/retrive/', {'payload': payload, 'page': 1, 'order_by': {'field': 'id', 'direction': 'asc'}}).json()

{u'field_selectors': [{u'items': [u'15XX BLOCK OF 3RD AVE', u'1XX BLOCK OF S WASHINGTON ST', u'30XX BLOCK OF NE 127 ST', u'42XX BLOCK OF AURORA AVE N', u'72XX BLOCK OF LINDEN AV N', u'8XX BLOCK OF DENNY WAY', u'92XX BLOCK OF 3 AV SW', u'E MARGINAL WY S / S HORTON ST', u'RAINIER AV S / S HOLLY ST', u'S HOLGATE ST / 6 AV S'], u'display_name': u'Hundred block location', u'name': u'hundred_block_location', u'selector': u'dropdown'}, {u'items': [u'127'], u'display_name': u'Socrata @computed region 2day rhn5', u'name': u'socrata_@computed_region_2day_rhn5', u'selector': u'dropdown'}, {u'items': [u'109710', u'1106825', u'119939', u'1256241', u'1541198', u'1963750', u'2254461', u'71786', u'719604', u'973533'], u'display_name': u'Cad cdw id', u'name': u'cad_cdw_id', u'selector': u'dropdown'}, {u'items': [u'BURGLARY ALARMS (FALSE)', u'DISTURBANCES', u'HAZARDS', u'LIQUOR VIOLATIONS', u'SUSPICIOUS CIRCUMSTANCES', u'WARRANT CALLS'], u'display_name': u'Event clearance subgroup', u'name': u'event_clearance_subgroup', u'selector': u'dropdown'}, {u'items': [u'100.5006', u'11101.1003', u'11300.1000', u'2800.3001', u'5000.3020', u'7200.1039', u'8100.2005', u'9200.2013', u'9300.2029', u'9300.3045'], u'display_name': u'Census tract', u'name': u'census_tract', u'selector': u'dropdown'}, {u'items': [u'ALARM - RESIDENTIAL - SILENT/AUD PANIC/DURESS', u'DISTURBANCE, MISCELLANEOUS/OTHER', u'PANHANDLING, AGGRESSIVE', u'PROWLER - IP/JO', u'SUSPICIOUS STOP - OFFICER INITIATED ONVIEW'], u'display_name': u'Initial type description', u'name': u'initial_type_description', u'selector': u'dropdown'}, {u'items': [u'ARREST', u'DISTURBANCES', u'FALSE ALARMS', u'HAZARDS', u'LIQUOR VIOLATIONS', u'SUSPICIOUS CIRCUMSTANCES'], u'display_name': u'Event clearance group', u'name': u'event_clearance_group', u'selector': u'dropdown'}, {u'items': [u'2'], u'display_name': u'Socrata @computed region cyqu gs94', u'name': u'socrata_@computed_region_cyqu_gs94', u'selector': u'dropdown'}, {u'items': [u'rv-2fg7-y4q7.nxrw', u'rv-a52f-yxhw_syfs', u'rv-aysu.uzb4.sw49', u'rv-bja8-qcks_82yp', u'rv-cinp.4vzp-fx3m', u'rv-f82r_yfwg-2xgk', u'rv-fdzv.94yr_cy9c', u'rv-iw7y~jhxb.ftz8', u'rv-mtgq-xybv-y7vf', u'rv-pqdg_srny-7aan'], u'display_name': u'Socrata version', u'name': u'socrata_version', u'selector': u'dropdown'}, {u'items': [u'ALARMS - RESIDENTIAL BURGLARY (FALSE)', u'DISTURBANCE, OTHER', u'HAZARDS', u'LIQUOR VIOLATION - INTOXICATED PERSON', u'MISDEMEANOR WARRANT SERVICE', u'SUSPICIOUS PERSON'], u'display_name': u'Event clearance description', u'name': u'event_clearance_description', u'selector': u'dropdown'}, {u'items': [u'F3', u'J1', u'J2', u'K1', u'K3', u'L3', u'M2', u'O2', u'S1'], u'display_name': u'Zone beat', u'name': u'zone_beat', u'selector': u'dropdown'}, {u'items': [u'Seattle Police Department'], u'display_name': u'Organization name', u'name': u'organization_name', u'selector': u'dropdown'}, {u'items': [], u'display_name': u'At scene time', u'name': u'at_scene_time', u'selector': u'dropdown'}, {u'items': [u'47.521193232', u'47.542475825', u'47.57438649', u'47.586171999', u'47.600882389', u'47.610246302', u'47.61854329', u'47.659003785', u'47.681445995', u'47.721091916'], u'display_name': u'Latitude', u'name': u'latitude', u'selector': u'dropdown'}, {u'items': [u'2010327788', u'2010383893', u'2010398567', u'201130987', u'201226674', u'2012406028', u'201479192', u'2015171661', u'201525039', u'2015311556'], u'display_name': u'General offense number', u'name': u'general_offense_number', u'selector': u'dropdown'}, {u'items': [u'F', u'J', u'K', u'L', u'M', u'O', u'S'], u'display_name': u'District sector', u'name': u'district_sector', u'selector': u'dropdown'}, {u'items': [u'DISTURBANCES', u'PROWLER', u'SUSPICIOUS CIRCUMSTANCES'], u'display_name': u'Initial type group', u'name': u'initial_type_group', u'selector': u'dropdown'}, {u'items': [], u'display_name': u'Event clearance date', u'name': u'event_clearance_date', u'selector': u'dropdown'}, {u'items': [], u'display_name': u'Socrata created at', u'name': u'socrata_created_at', u'selector': u'dropdown'}, {u'items': [], u'display_name': u'Incident location', u'name': u'incident_location', u'selector': u'dropdown'}, {u'display_name': u'Rms_event', u'name': u'is_rms_event', u'selector': u'checkbox'}, {u'items': [], u'display_name': u'Socrata updated at', u'name': u'socrata_updated_at', u'selector': u'dropdown'}, {u'items': [u'cfee2384-fb23-450a-90bf-2cbfa2912876'], u'display_name': u'Organization id', u'name': u'organization_id', u'selector': u'dropdown'}, {u'items': [u'ALARMS', u'DISTURBANCES', u'PROWLER', u'SUSPICIOUS CIRCUMSTANCES'], u'display_name': u'Initial type subgroup', u'name': u'initial_type_subgroup', u'selector': u'dropdown'}, {u'items': [u'177', u'192', u'201', u'245', u'280', u'282', u'350'], u'display_name': u'Event clearance code', u'name': u'event_clearance_code', u'selector': u'dropdown'}, {u'items': [u'15', u'2', u'20', u'24', u'25', u'29', u'35', u'45', u'7'], u'display_name': u'Socrata @computed region kuhn 3gp2', u'name': u'socrata_@computed_region_kuhn_3gp2', u'selector': u'dropdown'}, {u'items': [u'-122.272807659', u'-122.295248396', u'-122.32597823', u'-122.333529121', u'-122.338247307', u'-122.3389273', u'-122.339935928', u'-122.340602321', u'-122.346762321', u'-122.347333798'], u'display_name': u'Longitude', u'name': u'longitude', u'selector': u'dropdown'}, {u'items': [u'10000327788', u'10000383893', u'10000398567', u'11000030987', u'12000026674', u'12000406028', u'14000079192', u'15000025039', u'15000171661', u'15000311556'], u'display_name': u'Cad event number', u'name': u'cad_event_number', u'selector': u'dropdown'}, {u'items': [u'18081', u'18377', u'18379', u'18385', u'18800', u'19576', u'19579', u'19584'], u'display_name': u'Socrata @computed region q256 3sug', u'name': u'socrata_@computed_region_q256_3sug', u'selector': u'dropdown'}], u'percentages': [{u'field': u'is_rms_event', u'percentage': u'0% (0/10)', u'value': True, u'sentence': u'0% (0/10) of police response events are rms_event.'}], u'fields': [u'hundred_block_location', u'socrata_@computed_region_2day_rhn5', u'cad_cdw_id', u'event_clearance_subgroup', u'census_tract', u'initial_type_description', u'id', u'event_clearance_group', u'socrata_@computed_region_cyqu_gs94', u'socrata_version', u'event_clearance_description', u'zone_beat', u'organization_name', u'at_scene_time', u'latitude', u'general_offense_number', u'district_sector', u'initial_type_group', u'event_clearance_date', u'socrata_created_at', u'incident_location', u'is_rms_event', u'socrata_updated_at', u'organization_id', u'initial_type_subgroup', u'event_clearance_code', u'socrata_@computed_region_kuhn_3gp2', u'longitude', u'cad_event_number', u'socrata_@computed_region_q256_3sug'], u'group_counts': [[u'organizations', [[[{u'id': u'cfee2384-fb23-450a-90bf-2cbfa2912876', u'name': u'Seattle Police Department'}], 10]]]], u'number_of_rows': 10, u'name_for_rows': u'events', u'table': {u'name': u'Police response events', u'number_of_rows': 808477, u'categories': [u'Policing'], u'id': u'police_response_events'}, u'data': [{u'hundred_block_location': u'RAINIER AV S / S HOLLY ST', u'cad_cdw_id': u'1256241', u'event_clearance_subgroup': u'SUSPICIOUS CIRCUMSTANCES', u'census_tract': u'11101.1003', u'initial_type_description': u'SUSPICIOUS STOP - OFFICER INITIATED ONVIEW', u'id': u'row-2225~m5xg_kk3u', u'event_clearance_group': u'SUSPICIOUS CIRCUMSTANCES', u'socrata_version': u'rv-aysu.uzb4.sw49', u'event_clearance_description': u'SUSPICIOUS PERSON', u'zone_beat': u'S1', u'organization_name': u'Seattle Police Department', u'at_scene_time': {u'timezone': u'-08:00', u'$reql_type$': u'TIME', u'epoch_time': 1296090660}, u'latitude': u'47.542475825', u'general_offense_number': u'201130987', u'district_sector': u'S', u'initial_type_group': u'SUSPICIOUS CIRCUMSTANCES', u'event_clearance_date': {u'timezone': u'-08:00', u'$reql_type$': u'TIME', u'epoch_time': 1296091440}, u'socrata_created_at': {u'timezone': u'+00:00', u'$reql_type$': u'TIME', u'epoch_time': 1430280343.584}, u'incident_location': {u'type': u'Point', u'coordinates': [-122.272808, 47.542476]}, u'is_rms_event': False, u'socrata_updated_at': {u'timezone': u'+00:00', u'$reql_type$': u'TIME', u'epoch_time': 1437410708.024}, u'organization_id': u'cfee2384-fb23-450a-90bf-2cbfa2912876', u'initial_type_subgroup': u'SUSPICIOUS CIRCUMSTANCES', u'event_clearance_code': u'280', u'socrata_@computed_region_kuhn_3gp2': u'45', u'longitude': u'-122.272807659', u'cad_event_number': u'11000030987', u'socrata_@computed_region_q256_3sug': u'18800'}, {u'hundred_block_location': u'72XX BLOCK OF LINDEN AV N', u'cad_cdw_id': u'2254461', u'event_clearance_subgroup': u'SUSPICIOUS CIRCUMSTANCES', u'census_tract': u'2800.3001', u'initial_type_description': u'PROWLER - IP/JO', u'id': u'row-2228.ywx9.529t', u'event_clearance_group': u'SUSPICIOUS CIRCUMSTANCES', u'socrata_version': u'rv-pqdg_srny-7aan', u'event_clearance_description': u'SUSPICIOUS CIRCUMSTANCES - BUILDING (OPEN DOOR, ETC.)', u'zone_beat': u'J1', u'organization_name': u'Seattle Police Department', u'latitude': u'47.681445995', u'general_offense_number': u'201525039', u'district_sector': u'J', u'initial_type_group': u'PROWLER', u'event_clearance_date': {u'timezone': u'-08:00', u'$reql_type$': u'TIME', u'epoch_time': 1422017040}, u'socrata_created_at': {u'timezone': u'+00:00', u'$reql_type$': u'TIME', u'epoch_time': 1430280343.584}, u'incident_location': {u'type': u'Point', u'coordinates': [-122.346762, 47.681446]}, u'is_rms_event': False, u'socrata_updated_at': {u'timezone': u'+00:00', u'$reql_type$': u'TIME', u'epoch_time': 1437410708.024}, u'organization_id': u'cfee2384-fb23-450a-90bf-2cbfa2912876', u'initial_type_subgroup': u'PROWLER', u'event_clearance_code': u'282', u'socrata_@computed_region_kuhn_3gp2': u'25', u'longitude': u'-122.346762321', u'cad_event_number': u'15000025039', u'socrata_@computed_region_q256_3sug': u'18377'}, {u'hundred_block_location': u'15XX BLOCK OF 3RD AVE', u'cad_cdw_id': u'119939', u'event_clearance_subgroup': u'WARRANT CALLS', u'census_tract': u'8100.2005', u'socrata_@computed_region_q256_3sug': u'18081', u'id': u'row-222j.pp6k.rw8k', u'event_clearance_group': u'ARREST', u'socrata_version': u'rv-bja8-qcks_82yp', u'event_clearance_description': u'MISDEMEANOR WARRANT SERVICE', u'zone_beat': u'K1', u'organization_name': u'Seattle Police Department', u'latitude': u'47.610246302', u'general_offense_number': u'2010398567', u'district_sector': u'K', u'event_clearance_date': {u'timezone': u'-08:00', u'$reql_type$': u'TIME', u'epoch_time': 1289855340}, u'socrata_created_at': {u'timezone': u'+00:00', u'$reql_type$': u'TIME', u'epoch_time': 1430280343.584}, u'incident_location': {u'type': u'Point', u'coordinates': [-122.338247, 47.610246]}, u'is_rms_event': False, u'socrata_updated_at': {u'timezone': u'+00:00', u'$reql_type$': u'TIME', u'epoch_time': 1437410708.024}, u'organization_id': u'cfee2384-fb23-450a-90bf-2cbfa2912876', u'event_clearance_code': u'192', u'socrata_@computed_region_kuhn_3gp2': u'24', u'longitude': u'-122.338247307', u'cad_event_number': u'10000398567'}, {u'hundred_block_location': u'8XX BLOCK OF DENNY WAY', u'cad_cdw_id': u'71786', u'event_clearance_subgroup': u'WARRANT CALLS', u'census_tract': u'7200.1039', u'socrata_@computed_region_q256_3sug': u'19576', u'id': u'row-222j_bmbt~79j3', u'event_clearance_group': u'ARREST', u'socrata_version': u'rv-iw7y~jhxb.ftz8', u'event_clearance_description': u'MISDEMEANOR WARRANT SERVICE', u'zone_beat': u'M2', u'organization_name': u'Seattle Police Department', u'latitude': u'47.61854329', u'general_offense_number': u'2010327788', u'district_sector': u'M', u'event_clearance_date': {u'timezone': u'-08:00', u'$reql_type$': u'TIME', u'epoch_time': 1284881340}, u'socrata_created_at': {u'timezone': u'+00:00', u'$reql_type$': u'TIME', u'epoch_time': 1430280343.584}, u'incident_location': {u'type': u'Point', u'coordinates': [-122.340602, 47.618543]}, u'is_rms_event': False, u'socrata_updated_at': {u'timezone': u'+00:00', u'$reql_type$': u'TIME', u'epoch_time': 1437410708.024}, u'organization_id': u'cfee2384-fb23-450a-90bf-2cbfa2912876', u'event_clearance_code': u'192', u'socrata_@computed_region_kuhn_3gp2': u'7', u'longitude': u'-122.340602321', u'cad_event_number': u'10000327788'}, {u'hundred_block_location': u'E MARGINAL WY S / S HORTON ST', u'cad_cdw_id': u'719604', u'event_clearance_subgroup': u'HAZARDS', u'census_tract': u'9300.3045', u'socrata_@computed_region_q256_3sug': u'19584', u'id': u'row-2225-33qk.kuna', u'event_clearance_group': u'HAZARDS', u'socrata_version': u'rv-fdzv.94yr_cy9c', u'event_clearance_description': u'HAZARDS', u'zone_beat': u'O2', u'organization_name': u'Seattle Police Department', u'latitude': u'47.57438649', u'general_offense_number': u'201226674', u'district_sector': u'O', u'event_clearance_date': {u'timezone': u'-08:00', u'$reql_type$': u'TIME', u'epoch_time': 1327793880}, u'socrata_created_at': {u'timezone': u'+00:00', u'$reql_type$': u'TIME', u'epoch_time': 1430280343.584}, u'incident_location': {u'type': u'Point', u'coordinates': [-122.339936, 47.574386]}, u'is_rms_event': False, u'socrata_updated_at': {u'timezone': u'+00:00', u'$reql_type$': u'TIME', u'epoch_time': 1437410708.024}, u'organization_id': u'cfee2384-fb23-450a-90bf-2cbfa2912876', u'event_clearance_code': u'350', u'socrata_@computed_region_kuhn_3gp2': u'35', u'longitude': u'-122.339935928', u'cad_event_number': u'12000026674'}, {u'hundred_block_location': u'S HOLGATE ST / 6 AV S', u'cad_cdw_id': u'973533', u'event_clearance_subgroup': u'LIQUOR VIOLATIONS', u'census_tract': u'9300.2029', u'socrata_@computed_region_q256_3sug': u'19584', u'id': u'row-222g~5m53-hnmf', u'event_clearance_group': u'LIQUOR VIOLATIONS', u'socrata_version': u'rv-cinp.4vzp-fx3m', u'event_clearance_description': u'LIQUOR VIOLATION - INTOXICATED PERSON', u'zone_beat': u'K3', u'organization_name': u'Seattle Police Department', u'latitude': u'47.586171999', u'general_offense_number': u'2012406028', u'district_sector': u'K', u'event_clearance_date': {u'timezone': u'-08:00', u'$reql_type$': u'TIME', u'epoch_time': 1354084440}, u'socrata_created_at': {u'timezone': u'+00:00', u'$reql_type$': u'TIME', u'epoch_time': 1430280343.584}, u'incident_location': {u'type': u'Point', u'coordinates': [-122.325978, 47.586172]}, u'is_rms_event': False, u'socrata_updated_at': {u'timezone': u'+00:00', u'$reql_type$': u'TIME', u'epoch_time': 1437410708.024}, u'organization_id': u'cfee2384-fb23-450a-90bf-2cbfa2912876', u'event_clearance_code': u'177', u'socrata_@computed_region_kuhn_3gp2': u'35', u'longitude': u'-122.32597823', u'cad_event_number': u'12000406028'}, {u'hundred_block_location': u'30XX BLOCK OF NE 127 ST', u'socrata_@computed_region_2day_rhn5': u'127', u'cad_cdw_id': u'1541198', u'event_clearance_subgroup': u'DISTURBANCES', u'census_tract': u'100.5006', u'initial_type_description': u'PANHANDLING, AGGRESSIVE', u'id': u'row-2224_ntfu.xhw8', u'event_clearance_group': u'DISTURBANCES', u'socrata_@computed_region_cyqu_gs94': u'2', u'socrata_version': u'rv-a52f-yxhw_syfs', u'event_clearance_description': u'DISTURBANCE, OTHER', u'zone_beat': u'L3', u'organization_name': u'Seattle Police Department', u'latitude': u'47.721091916', u'general_offense_number': u'2015311556', u'district_sector': u'L', u'initial_type_group': u'DISTURBANCES', u'event_clearance_date': {u'timezone': u'-08:00', u'$reql_type$': u'TIME', u'epoch_time': 1441489740}, u'socrata_created_at': {u'timezone': u'+00:00', u'$reql_type$': u'TIME', u'epoch_time': 1430280343.584}, u'incident_location': {u'type': u'Point', u'coordinates': [-122.295248, 47.721092]}, u'is_rms_event': False, u'socrata_updated_at': {u'timezone': u'+00:00', u'$reql_type$': u'TIME', u'epoch_time': 1441491115.153}, u'organization_id': u'cfee2384-fb23-450a-90bf-2cbfa2912876', u'initial_type_subgroup': u'DISTURBANCES', u'event_clearance_code': u'245', u'socrata_@computed_region_kuhn_3gp2': u'29', u'longitude': u'-122.295248396', u'cad_event_number': u'15000311556', u'socrata_@computed_region_q256_3sug': u'19579'}, {u'hundred_block_location': u'42XX BLOCK OF AURORA AVE N', u'cad_cdw_id': u'109710', u'event_clearance_subgroup': u'SUSPICIOUS CIRCUMSTANCES', u'census_tract': u'5000.3020', u'socrata_@computed_region_q256_3sug': u'18377', u'id': u'row-2227~yqi3_jq8k', u'event_clearance_group': u'SUSPICIOUS CIRCUMSTANCES', u'socrata_version': u'rv-2fg7-y4q7.nxrw', u'event_clearance_description': u'SUSPICIOUS PERSON', u'zone_beat': u'J2', u'organization_name': u'Seattle Police Department', u'latitude': u'47.659003785', u'general_offense_number': u'2010383893', u'district_sector': u'J', u'event_clearance_date': {u'timezone': u'-08:00', u'$reql_type$': u'TIME', u'epoch_time': 1288797000}, u'socrata_created_at': {u'timezone': u'+00:00', u'$reql_type$': u'TIME', u'epoch_time': 1430280343.584}, u'incident_location': {u'type': u'Point', u'coordinates': [-122.347334, 47.659004]}, u'is_rms_event': False, u'socrata_updated_at': {u'timezone': u'+00:00', u'$reql_type$': u'TIME', u'epoch_time': 1437410708.024}, u'organization_id': u'cfee2384-fb23-450a-90bf-2cbfa2912876', u'event_clearance_code': u'280', u'socrata_@computed_region_kuhn_3gp2': u'2', u'longitude': u'-122.347333798', u'cad_event_number': u'10000383893'}, {u'hundred_block_location': u'92XX BLOCK OF 3 AV SW', u'cad_cdw_id': u'1106825', u'event_clearance_subgroup': u'BURGLARY ALARMS (FALSE)', u'census_tract': u'11300.1000', u'initial_type_description': u'ALARM - RESIDENTIAL - SILENT/AUD PANIC/DURESS', u'id': u'row-222c_fdhy.4mdb', u'event_clearance_group': u'FALSE ALARMS', u'socrata_version': u'rv-mtgq-xybv-y7vf', u'event_clearance_description': u'ALARMS - RESIDENTIAL BURGLARY (FALSE)', u'zone_beat': u'F3', u'organization_name': u'Seattle Police Department', u'at_scene_time': {u'timezone': u'-08:00', u'$reql_type$': u'TIME', u'epoch_time': 1432574640}, u'latitude': u'47.521193232', u'general_offense_number': u'2015171661', u'district_sector': u'F', u'initial_type_group': u'SUSPICIOUS CIRCUMSTANCES', u'event_clearance_date': {u'timezone': u'-08:00', u'$reql_type$': u'TIME', u'epoch_time': 1432575060}, u'socrata_created_at': {u'timezone': u'+00:00', u'$reql_type$': u'TIME', u'epoch_time': 1433099176.521}, u'incident_location': {u'type': u'Point', u'coordinates': [-122.338927, 47.521193]}, u'is_rms_event': False, u'socrata_updated_at': {u'timezone': u'+00:00', u'$reql_type$': u'TIME', u'epoch_time': 1437410708.024}, u'organization_id': u'cfee2384-fb23-450a-90bf-2cbfa2912876', u'initial_type_subgroup': u'ALARMS', u'event_clearance_code': u'201', u'socrata_@computed_region_kuhn_3gp2': u'15', u'longitude': u'-122.3389273', u'cad_event_number': u'15000171661', u'socrata_@computed_region_q256_3sug': u'18385'}, {u'hundred_block_location': u'1XX BLOCK OF S WASHINGTON ST', u'cad_cdw_id': u'1963750', u'census_tract': u'9200.2013', u'initial_type_description': u'DISTURBANCE, MISCELLANEOUS/OTHER', u'id': u'row-222v_edri.ytyc', u'socrata_version': u'rv-f82r_yfwg-2xgk', u'zone_beat': u'K3', u'organization_name': u'Seattle Police Department', u'at_scene_time': {u'timezone': u'-08:00', u'$reql_type$': u'TIME', u'epoch_time': 1394852460}, u'latitude': u'47.600882389', u'general_offense_number': u'201479192', u'district_sector': u'K', u'initial_type_group': u'DISTURBANCES', u'socrata_created_at': {u'timezone': u'+00:00', u'$reql_type$': u'TIME', u'epoch_time': 1430280343.584}, u'incident_location': {u'type': u'Point', u'coordinates': [-122.333529, 47.600882]}, u'is_rms_event': False, u'socrata_updated_at': {u'timezone': u'+00:00', u'$reql_type$': u'TIME', u'epoch_time': 1437410708.024}, u'organization_id': u'cfee2384-fb23-450a-90bf-2cbfa2912876', u'initial_type_subgroup': u'DISTURBANCES', u'socrata_@computed_region_kuhn_3gp2': u'20', u'longitude': u'-122.333529121', u'cad_event_number': u'14000079192', u'socrata_@computed_region_q256_3sug': u'18379'}], u'payload': {u'table': u'police_response_events', u'page': 1}}

import requests
import json
payload = {'table': 'police_internal_affairs_cases', 'filter': {'organization_id': 'cfee2384-fb23-450a-90bf-2cbfa2912876', 'is_sustained': True}}
payload = json.dumps(payload)
print requests.get('https://api.peoplesnsa.com/retrive/', {'payload': payload}).json()

[{u'Complaint': u'The complainant alleged the named employee grabbed her arm causing soreness and provided the name of another officer when the complainant asked for his name.', u'Analysis and conclusion': u'A thorough review of the evidence showed that the named retired employee violated Department policy when he committed the criminal violation of criminal impersonation of a police officer. The former employee was charged with a misdemeanor offense which was ultimately resolved through a deferral agreement with the Prosecutor.', u'Findings': u'Named Employee #1 Allegation #1 The evidence showed that the named retired employee violated Department policy. Therefore a Sustained finding was issued for Violation of Law. As the employee is retired, no Discipline can be issued, however, the named employee agreed he was ineligible to receive an \u201cExtended Authority Commission\u201d in the future. Discipline imposed: No Discipline \u2013 no longer an SPD employee', u'Issued date': u'06/15/2015', u'organization_id': u'cfee2384-fb23-450a-90bf-2cbfa2912876', u'Final discipline': u'No Discipline \u2013 no longer an SPD employee', u'Investigation': u'The OPA investigation included the following actions: 1. Review of the complaint phone call 2. Interview of the complainant 3. Search for and review of all relevant records and other evidence 4. Interviews of SPD employees', u'Incident synopsis': u'The named retired employee was working in uniform in 2013 without an \u201cExtended Authority Commission\u201d and work permit at a construction site. The complainant was attempting to cross the street when the named employee grabbed her arm and yelled at her.', u'Complaint number': u'OPA#13-0502', u'parsed_txt': u' \n\nOFFICE OF PROFESSIONAL ACCOUNTABILITY \n\nClosed Case Summary \n\n \n\nComplaint Number OPA# 13-0502 \n\n \n\nIssued Date: 06/15/2015 \n \n\nNamed Employee #1 \n\nAllegation #1 \n\nSeattle Police Department Manual 5.001 (III.A) Violation of Law \n(Policy that was issued 08/15/12) \n\nOPA Finding \n\nSustained \n\nFinal Discipline \n\nNo Discipline \u2013 no longer an SPD employee \n\n \n\nINCIDENT SYNOPSIS \n\nThe named retired employee was working in uniform in 2013 without an \u201cExtended Authority \nCommission\u201d and work permit at a construction site. The complainant was attempting to cross \nthe street when the named employee grabbed her arm and yelled at her. \n\n \n\nCOMPLAINT \n\nThe complainant alleged the named employee grabbed her arm causing soreness and provided \nthe name of another officer when the complainant asked for his name. \n\n \n\nINVESTIGATION \n\nThe OPA investigation included the following actions: \n\n1. Review of the complaint phone call \n2. Interview of the complainant \n3. Search for and review of all relevant records and other evidence \n4. Interviews of SPD employees \n\n \n\nComplaint Number OPA# 13-0502 \n\nPage 1 of 2 \n\n\x0cANALYSIS AND CONCLUSION \n\nA thorough review of the evidence showed that the named retired employee violated \nDepartment policy when he committed the criminal violation of criminal impersonation of a \npolice officer. The former employee was charged with a misdemeanor offense which was \nultimately resolved through a deferral agreement with the Prosecutor. \n \nFINDINGS \n \nNamed Employee #1 \nAllegation #1 \nThe evidence showed that the named retired employee violated Department policy. Therefore a \nSustained finding was issued for Violation of Law. As the employee is retired, no Discipline can \nbe issued, however, the named employee agreed he was ineligible to receive an \u201cExtended \nAuthority Commission\u201d in the future. \n \n \nDiscipline imposed: No Discipline \u2013 no longer an SPD employee \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n\nNOTE: The Seattle Police Department Manual policies cited for the allegation(s) made \nfor this OPA Investigation are policies that were in effect during the time of the incident. \nThe issued date of the policy is listed. \n\nComplaint Number OPA# 13-0502 \n\nPage 2 of 2 \n\n \n\n\x0c', u'pdf': u'13-0502ccs06-15-15.pdf', u'Summarized results': [{u'allegations': [{u'heading': u'Allegation #1', u'allegation': u'Seattle Police Department Manual 5.001 (III.A) Violation of Law (Policy that was issued 08/15/12)', u'opa_finding': u'Sustained'}], u'final_discipline': u'No Discipline \u2013 no longer an SPD employee', u'heading': u'Named Employee #1'}], u'txt': u'13-0502ccs06-15-15.txt', u'id': u'cfee2384-fb23-450a-90bf-2cbfa2912876_OPA#13-0502', u'OPA finding': u'Sustained', u'is_sustained': True}, {u'Complaint': u'The complainant alleged that the named employee did not want to take a digital photograph of the assault suspect that groped her as evidence.', u'Analysis and conclusion': u'The evidence showed that the named employee failed to conduct a thorough and complete search for evidence. The named employee should have secured a copy of the photo to include with the report she had written.', u'Findings': u'Named Employee #1 Allegation #1 The evidence showed that the named employee failed to conduct a thorough and complete search for evidence. Therefore a Sustained finding was issued for Primary Investigations: Search for Evidence. Discipline imposed: 2 day suspension without pay (under appeal)', u'Issued date': u'06/02/2015', u'organization_id': u'cfee2384-fb23-450a-90bf-2cbfa2912876', u'Final discipline': u'2 day suspension without pay (under appeal)', u'Investigation': u'The OPA investigation included the following actions: 1. Review of the complaint email 2. Interview of the complainant 3. Search for and review of all relevant records and other evidence 4. Interviews of SPD employees', u'Incident synopsis': u'The named employee was working as the desk clerk at a precinct. The complainant had come into the precinct to report that she had been groped and had taken a photo of the suspect. The named employee did not secure a copy of the photo and wrote a report without mentioning the photo.', u'Complaint number': u'OPA#2014-0580', u'parsed_txt': u' \n\nOFFICE OF PROFESSIONAL ACCOUNTABILITY \n\nClosed Case Summary \n\n \n\nComplaint Number OPA#2014-0580 \n\n \n\nIssued Date: 06/02/2015 \n \n\nNamed Employee #1 \n\nAllegation #1 \n\nSeattle Police Department Manual 15.180 (1) Primary Investigations: \nSearch for Evidence (Policy that was issued 05/21/14) \n\nOPA Finding \n\nSustained \n\nFinal Discipline \n\n2 day suspension without pay (under appeal) \n\n \n\nINCIDENT SYNOPSIS \n\nThe named employee was working as the desk clerk at a precinct. The complainant had come \ninto the precinct to report that she had been groped and had taken a photo of the suspect. The \nnamed employee did not secure a copy of the photo and wrote a report without mentioning the \nphoto. \n\n \n\nCOMPLAINT \n\nThe complainant alleged that the named employee did not want to take a digital photograph of \nthe assault suspect that groped her as evidence. \n\n \n\n \n\n \n\n \n\nComplaint Number OPA#2014-0580 \n\nPage 1 of 2 \n\n\x0cINVESTIGATION \n\nThe OPA investigation included the following actions: \n\n1. Review of the complaint email \n2. Interview of the complainant \n3. Search for and review of all relevant records and other evidence \n4. Interviews of SPD employees \n\n \n\nANALYSIS AND CONCLUSION \n\nThe evidence showed that the named employee failed to conduct a thorough and complete \nsearch for evidence. The named employee should have secured a copy of the photo to include \nwith the report she had written. \n \nFINDINGS \n \nNamed Employee #1 \nAllegation #1 \nThe evidence showed that the named employee failed to conduct a thorough and complete \nsearch for evidence. Therefore a Sustained finding was issued for Primary Investigations: \nSearch for Evidence. \n \nDiscipline imposed: 2 day suspension without pay (under appeal) \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n\nNOTE: The Seattle Police Department Manual policies cited for the allegation(s) made \nfor this OPA Investigation are policies that were in effect during the time of the incident. \nThe issued date of the policy is listed. \n\n \n\nComplaint Number OPA#2014-0580 \n\nPage 2 of 2 \n\n\x0c', u'pdf': u'2014-0580ccs06-04-15ua.pdf', u'Summarized results': [{u'allegations': [{u'heading': u'Allegation #1', u'allegation': u'Seattle Police Department Manual 15.180 (1) Primary Investigations: Search for Evidence (Policy that was issued 05/21/14)', u'opa_finding': u'Sustained'}], u'final_discipline': u'2 day suspension without pay (under appeal)', u'heading': u'Named Employee #1'}], u'txt': u'2014-0580ccs06-04-15ua.txt', u'id': u'cfee2384-fb23-450a-90bf-2cbfa2912876_OPA#2014-0580', u'OPA finding': u'Sustained', u'is_sustained': True}, {u'Complaint': u'The complainant alleged that the named employee took his wallet from him when he was arrested but it was not with the rest of his property when he was released from jail.', u'Analysis and conclusion': u'The investigation showed that the complainant was in possession of a wallet when he was arrested. In-Car Video shows that the named employee put the complainant\u2019s wallet and other items into a brown paper bag and then placed the bag in the trunk of his patrol car. However, the jail property sheet does not show that a wallet was turned in at the time the complainant was booked into the jail. As there was a delay from the date of the incident to the time that the complainant made the complaint, the holding cell video at the precinct could not be obtained and reviewed because it was not saved beyond the standard 90-day retention period. A search was made for the wallet at the precinct and the patrol vehicle, but it could not be located. The named employee failed to follow the policy to ensure the safekeeping of a detainee\u2019s personal property.', u'Findings': u'Named Employee #1 Allegation #1 The weight of the evidence showed that the named employee failed to follow the policy. Therefore a Sustained finding was issued for Detainee Property for Safekeeping. However, the named employee was still in training as a police officer at the time of the incident and additional training is to be provided. Discipline imposed: No Discipline \u2013 additional training to be provided', u'Issued date': u'06/15/2015', u'organization_id': u'cfee2384-fb23-450a-90bf-2cbfa2912876', u'Final discipline': u'No Discipline \u2013 additional training to be provided', u'Investigation': u'The OPA investigation included the following actions: 1. Review of the complaint statement 2. Interview of the complainant 3. Search for and review of all relevant records and other evidence 4. Review of In-Car Videos 5. Interviews of SPD employees', u'Incident synopsis': u'The named employee arrested the complainant based on a warrant. The named employee took custody of the complainant\u2019s property during the arrest. The complainant was taken to a precinct holding cell to wait for transportation to the jail. He was later taken to jail by a different SPD officer.', u'Complaint number': u'OPA#2014-0780', u'parsed_txt': u' \n\nOFFICE OF PROFESSIONAL ACCOUNTABILITY \n\nClosed Case Summary \n\n \n\nComplaint Number OPA#2014-0780 \n\n \n\nIssued Date: 06/15/2015 \n \n\nNamed Employee #1 \n\nAllegation #1 \n\nSeattle Police Department Manual 7.150 Detainee Property for \nSafekeeping (Policy that was issued 02/19/14) \n\nOPA Finding \n\nSustained \n\nFinal Discipline \n\nNo Discipline \u2013 additional training to be provided \n\n \n\nINCIDENT SYNOPSIS \n\nThe named employee arrested the complainant based on a warrant. The named employee took \ncustody of the complainant\u2019s property during the arrest. The complainant was taken to a \nprecinct holding cell to wait for transportation to the jail. He was later taken to jail by a different \nSPD officer. \n \nCOMPLAINT \n\nThe complainant alleged that the named employee took his wallet from him when he was \narrested but it was not with the rest of his property when he was released from jail. \n \nINVESTIGATION \n\nThe OPA investigation included the following actions: \n\n1. Review of the complaint statement \n2. Interview of the complainant \n3. Search for and review of all relevant records and other evidence \n4. Review of In-Car Videos \n5. Interviews of SPD employees \n\n \n\nComplaint Number OPA#2014-0780 \n\nPage 1 of 2 \n\n\x0cANALYSIS AND CONCLUSION \n\nThe investigation showed that the complainant was in possession of a wallet when he was \narrested. In-Car Video shows that the named employee put the complainant\u2019s wallet and other \nitems into a brown paper bag and then placed the bag in the trunk of his patrol car. However, \nthe jail property sheet does not show that a wallet was turned in at the time the complainant was \nbooked into the jail. As there was a delay from the date of the incident to the time that the \ncomplainant made the complaint, the holding cell video at the precinct could not be obtained \nand reviewed because it was not saved beyond the standard 90-day retention period. A search \nwas made for the wallet at the precinct and the patrol vehicle, but it could not be located. The \nnamed employee failed to follow the policy to ensure the safekeeping of a detainee\u2019s personal \nproperty. \n \nFINDINGS \n \nNamed Employee #1 \nAllegation #1 \nThe weight of the evidence showed that the named employee failed to follow the policy. \nTherefore a Sustained finding was issued for Detainee Property for Safekeeping. However, the \nnamed employee was still in training as a police officer at the time of the incident and additional \ntraining is to be provided. \n \nDiscipline imposed: No Discipline \u2013 additional training to be provided \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n\nNOTE: The Seattle Police Department Manual policies cited for the allegation(s) made \nfor this OPA Investigation are policies that were in effect during the time of the incident. \nThe issued date of the policy is listed. \n\nComplaint Number OPA#2014-0780 \n\nPage 2 of 2 \n\n \n\n\x0c', u'pdf': u'2014-0780ccs06-15-15.pdf', u'Summarized results': [{u'allegations': [{u'heading': u'Allegation #1', u'allegation': u'Seattle Police Department Manual 7.150 Detainee Property for Safekeeping (Policy that was issued 02/19/14)', u'opa_finding': u'Sustained'}], u'final_discipline': u'No Discipline \u2013 additional training to be provided', u'heading': u'Named Employee #1'}], u'txt': u'2014-0780ccs06-15-15.txt', u'id': u'cfee2384-fb23-450a-90bf-2cbfa2912876_OPA#2014-0780', u'OPA finding': u'Sustained', u'is_sustained': True}, {u'Complaint': u'Another jurisdiction reported that the named employee had been arrested for crimes committed in their jurisdiction.', u'Analysis and conclusion': u'The named employee confessed to committing the sexual crimes and pled guilty to three felonies.', u'Findings': u'Named Employee #1 Allegation #1 The weight of the evidence showed that the named employee did violate the law. Therefore a Sustained finding was issued for (Violation of Law) Discipline imposed: No Discipline \u2013 Resignation in lieu of termination', u'Issued date': u'06/15/2015', u'organization_id': u'cfee2384-fb23-450a-90bf-2cbfa2912876', u'Final discipline': u'No Discipline \u2013 Resignation in lieu of termination', u'Investigation': u'The OPA investigation included the following actions: 1. Review of the complaint notification 2. Review of the other jurisdictions report of the incident 3. Search for and review of all relevant records and other evidence 4. Review of court documents 5. Interviews of SPD employees', u'Incident synopsis': u'The named employee was arrested by another jurisdiction for sexual crimes.', u'Complaint number': u'OPA#2014-0116', u'parsed_txt': u' \n\nOFFICE OF PROFESSIONAL ACCOUNTABILITY \n\nClosed Case Summary \n\n \n\nComplaint Number OPA#2014-0116 \n\n \n\nIssued Date: 06/15/2015 \n \n\nNamed Employee #1 \n\nAllegation #1 \n\nSeattle Police Department Manual 5.001 (III.A) Violation of Law \n(Policy that was issued 08/15/12) \n\nOPA Finding \n\nSustained \n\nFinal Discipline \n\nNo Discipline \u2013 Resignation in lieu of termination \n\n \n\nINCIDENT SYNOPSIS \n\nThe named employee was arrested by another jurisdiction for sexual crimes. \n\n \n\nCOMPLAINT \n\nAnother jurisdiction reported that the named employee had been arrested for crimes committed \nin their jurisdiction. \n\n \n\nINVESTIGATION \n\nThe OPA investigation included the following actions: \n\n1. Review of the complaint notification \n2. Review of the other jurisdictions report of the incident \n3. Search for and review of all relevant records and other evidence \n4. Review of court documents \n5. Interviews of SPD employees \n\n \n\n \n\nComplaint Number OPA#2014-0116 \n\nPage 1 of 2 \n\n\x0cANALYSIS AND CONCLUSION \n\nThe named employee confessed to committing the sexual crimes and pled guilty to three \nfelonies. \n \nFINDINGS \n \nNamed Employee #1 \nAllegation #1 \nThe weight of the evidence showed that the named employee did violate the law. Therefore a \nSustained finding was issued for (Violation of Law) \n \nDiscipline imposed: No Discipline \u2013 Resignation in lieu of termination \n \n \n \n \n \n \n\nNOTE: The Seattle Police Department Manual policies cited for the allegation(s) made \nfor this OPA Investigation are policies that were in effect during the time of the incident. \nThe issued date of the policy is listed. \n\n \n\nComplaint Number OPA#2014-0116 \n\nPage 2 of 2 \n\n\x0c', u'pdf': u'2014-0116ccs06-15-15.pdf', u'Summarized results': [{u'allegations': [{u'heading': u'Allegation #1', u'allegation': u'Seattle Police Department Manual 5.001 (III.A) Violation of Law (Policy that was issued 08/15/12)', u'opa_finding': u'Sustained'}], u'final_discipline': u'No Discipline \u2013 Resignation in lieu of termination', u'heading': u'Named Employee #1'}], u'txt': u'2014-0116ccs06-15-15.txt', u'id': u'cfee2384-fb23-450a-90bf-2cbfa2912876_OPA#2014-0116', u'OPA finding': u'Sustained', u'is_sustained': True}, {u'Complaint': u'The complainants alleged that the named employee was unprofessional and used his position of authority for personal gain.', u'Analysis and conclusion': u'Department policy prohibits employees from using their position to further their personal interests. Department policy also prohibits behavior that undermines the public trust in the department or the officer. Officers should behave professionally and not abuse their access to private information or abuse the power and authority given to them. The named employee\u2019s actions were a fundamental violation of his role as a public servant.', u'Findings': u'Named Employee #1 Allegation #1 The weight of the evidence showed that the named employee acted in an unprofessional manner that was not consistent with departmental expectations and undermined the confidence of the public in the department; therefore a Sustained finding was issued for Professionalism. Allegation #2 The weight of the evidence showed a serious and repeated abuse of authority and an unsettling pattern of behavior by the named employee; therefore a Sustained finding was issued for Employees Shall Not Use Their Position For Personal Gain. Allegation #3 Conflicts of interest arise when an officer is called to investigate someone with whom they have a personal relationship or a personal relationship arises. Although the named employee sought to develop a personal relationship with the complainants, such a relationship did not exist at the time he took police action. Therefore, a finding of Not Sustained (Unfounded) was issued for Employees Must Avoid Conflicts of Interest. Discipline imposed: Termination', u'Issued date': u'03/13/2015', u'organization_id': u'cfee2384-fb23-450a-90bf-2cbfa2912876', u'Final discipline': u'Termination (under appeal)', u'Investigation': u'The OPA investigation included the following actions: 1. Review of the complaint memos 2. Interviews of the complainants 3. Search for and review of all relevant records and other evidence 4. Review of three months of activity logs for the named employee 5. Search for additional similar incidents 6. Interviews of SPD employees', u'Incident synopsis': u'The named employee on three separate occasions came into contact with female members of the public through legitimate police interactions. Within days or hours of each contact, the named employee used information received through the course of his police duties to initiate unnecessary, unprofessional and highly inappropriate additional communications with the women.', u'Complaint number': u'OPA#2014-0377,2014-0544,2014-0842', u'parsed_txt': u' \n\nOFFICE OF PROFESSIONAL ACCOUNTABILITY \n\nClosed Case Summary \n\n \n\nComplaint Number OPA#2014-0377, 2014-0544, 2014-0842 \n\n \n\nIssued Date: 03/13/2015 \n \n\nNamed Employee #1 \n\nAllegation #1 \n\nSeattle Police Department Manual 5.001 (9) Professionalism (Policy \nthat was issued 07/16/14) \n\nOPA Finding \n\nSustained \n\nAllegation #2 \n\nSeattle Police Department Manual 5.001 (12) Employees Shall Not \nUse Their Position For Personal Gain (Policy that was issued \n07/16/14) \n\nOPA Finding \n\nSustained \n\nAllegation #3 \n\nSeattle Police Department Manual 5.001 (17) Employees Must Avoid \nConflicts of Interest (Policy that was issued 07/16/14) \n\nOPA Finding \n\nNot Sustained (Unfounded) \n\nFinal Discipline \n\nTermination (under appeal) \n\n \n\nINCIDENT SYNOPSIS \n\nThe named employee on three separate occasions came into contact with female members of \nthe public through legitimate police interactions. Within days or hours of each contact, the \nnamed employee used information received through the course of his police duties to initiate \nunnecessary, unprofessional and highly inappropriate additional communications with the \nwomen. \n\n \n\n \n\n \n\nComplaint Number OPA#2014-0377, 2014-0544, 2014-0842 \n\nPage 1 of 2 \n\n\x0cCOMPLAINT \n\nThe complainants alleged that the named employee was unprofessional and used his position \nof authority for personal gain. \n \nINVESTIGATION \n\nThe OPA investigation included the following actions: \n\n1. Review of the complaint memos \n2. Interviews of the complainants \n3. Search for and review of all relevant records and other evidence \n4. Review of three months of activity logs for the named employee \n5. Search for additional similar incidents \n6. Interviews of SPD employees \n\n \nANALYSIS AND CONCLUSION \n\nDepartment policy prohibits employees from using their position to further their personal \ninterests. Department policy also prohibits behavior that undermines the public trust in the \ndepartment or the officer. Officers should behave professionally and not abuse their access to \nprivate information or abuse the power and authority given to them. The named employee\u2019s \nactions were a fundamental violation of his role as a public servant. \n \nFINDINGS \n\nNamed Employee #1 \nAllegation #1 \nThe weight of the evidence showed that the named employee acted in an unprofessional \nmanner that was not consistent with departmental expectations and undermined the confidence \nof the public in the department; therefore a Sustained finding was issued for Professionalism. \n \nAllegation #2 \nThe weight of the evidence showed a serious and repeated abuse of authority and an unsettling \npattern of behavior by the named employee; therefore a Sustained finding was issued for \nEmployees Shall Not Use Their Position For Personal Gain. \n \nAllegation #3 \nConflicts of interest arise when an officer is called to investigate someone with whom they have \na personal relationship or a personal relationship arises. Although the named employee sought \nto develop a personal relationship with the complainants, such a relationship did not exist at the \ntime he took police action. Therefore, a finding of Not Sustained (Unfounded) was issued for \nEmployees Must Avoid Conflicts of Interest. \n \nDiscipline imposed: Termination \n \n \n\nNOTE: The Seattle Police Department Manual policies cited for the allegation(s) made for this \nOPA Investigation are policies that were in effect during the time of the incident. The issued date of \nthe policy is listed. \n\nComplaint Number OPA#2014-0377, 2014-0544, 2014-0842 \n\nPage 2 of 2 \n\n \n\n\x0c', u'pdf': u'2014-0377_2014-0544_2014-0842ccs03-13-15ua.pdf', u'Summarized results': [{u'allegations': [{u'heading': u'Allegation #1', u'allegation': u'Seattle Police Department Manual 5.001 (9) Professionalism (Policy that was issued 07/16/14)', u'opa_finding': u'Sustained'}, {u'heading': u'Allegation #2', u'allegation': u'Seattle Police Department Manual 5.001 (12) Employees Shall Not Use Their Position For Personal Gain (Policy that was issued 07/16/14)', u'opa_finding': u'Sustained'}, {u'heading': u'Allegation #3', u'allegation': u'Seattle Police Department Manual 5.001 (17) Employees Must Avoid Conflicts of Interest (Policy that was issued 07/16/14)', u'opa_finding': u'Not Sustained (Unfounded)'}], u'final_discipline': u'Termination (under appeal)', u'heading': u'Named Employee #1'}], u'txt': u'2014-0377_2014-0544_2014-0842ccs03-13-15ua.txt', u'id': u'cfee2384-fb23-450a-90bf-2cbfa2912876_OPA#2014-0377,2014-0544,2014-0842', u'OPA finding': u'Sustained Allegation #2 Seattle Police Department Manual 5.001 (12) Employees Shall Not Use Their Position For Personal Gain (Policy that was issued 07/16/14) OPA Finding Sustained Allegation #3 Seattle Police Department Manual 5.001 (17) Employees Must Avoid Conflicts of Interest (Policy that was issued 07/16/14) OPA Finding Not Sustained (Unfounded)', u'is_sustained': True}, {u'Complaint': u'The complainant, a supervisor within the Department, alleged that the named employee drove outside of Department policy resulting in an injury collision.', u'Analysis and conclusion': u'Based on reviewing all of the evidence available it was determined that the named employee operated his police vehicle in an unsafe manner. He drove more than twice the speed limit, without activating overhead lights or emergency operation equipment, outside of the normal traffic pattern, including by driving southbound in the northbound lane around a blind curve.', u'Findings': u'Named Employee #1 The weight of the evidence showed that the named employee drove outside of Department policy. Therefore a finding of Sustained was found for Emergency Vehicle Operations.', u'Issued date': u'02/11/2015', u'organization_id': u'cfee2384-fb23-450a-90bf-2cbfa2912876', u'Final discipline': u'One day suspension without pay', u'Investigation': u'The OPA investigation included the following actions: 1. Review of In-Car Videos 2. Interviews of SPD employees', u'Incident synopsis': u'On October 5, 2013, the named employee observed a violator pass his location. The named employee quickly pulled onto the roadway and maneuvered around slower traffic prior to stopping for a traffic light. Once the light changed, the offender vehicle accelerated at a high rate of speed away from the previously stopped cars. The named employee again maneuvered around slower traffic and even though his vehicle was accelerating substantially, the offender vehicle still pulled away and nearly out of sight. An unknown vehicle turned directly into the path of the named employee\u2019s vehicle. The named employee\u2019s vehicle lost traction as it slid sideways into a power pole and came to a stop.', u'Complaint number': u'OPA#13-IS-0411', u'parsed_txt': u' \n\nOFFICE OF PROFESSIONAL ACCOUNTABILITY \n\nClosed Case Summary \n\nComplaint Number OPA#13-IS-0411 \n\n \n\n \n\nIssued Date: 02/11/2015 \n \n\nNamed Employee #1 \n\nAllegation #1 \n\nSeattle Police Department Manual 13.030 Emergency Vehicle \nOperations / Policy (Policy that was issued 11/21/12) \n\nOPA Finding \n\nSustained \n\nFinal Discipline \n\nOne day suspension without pay \n\n \n\nINCIDENT SYNOPSIS \n\nOn October 5, 2013, the named employee observed a violator pass his location. The named \nemployee quickly pulled onto the roadway and maneuvered around slower traffic prior to \nstopping for a traffic light. Once the light changed, the offender vehicle accelerated at a high \nrate of speed away from the previously stopped cars. The named employee again maneuvered \naround slower traffic and even though his vehicle was accelerating substantially, the offender \nvehicle still pulled away and nearly out of sight. An unknown vehicle turned directly into the \npath of the named employee\u2019s vehicle. The named employee\u2019s vehicle lost traction as it slid \nsideways into a power pole and came to a stop. \n\n \n\nCOMPLAINT \n\nThe complainant, a supervisor within the Department, alleged that the named employee drove \noutside of Department policy resulting in an injury collision. \n\n \n\n \n\n \n\nComplaint Number OPA# 13-IS-0411 \n\nPage 1 of 2 \n\n\x0cINVESTIGATION \n\nThe OPA investigation included the following actions: \n\n1. Review of In-Car Videos \n2. Interviews of SPD employees \n\n \n\nANALYSIS AND CONCLUSION \n\nBased on reviewing all of the evidence available it was determined that the named employee \noperated his police vehicle in an unsafe manner. He drove more than twice the speed limit, \nwithout activating overhead lights or emergency operation equipment, outside of the normal \ntraffic pattern, including by driving southbound in the northbound lane around a blind curve. \n \nFINDINGS \n \nNamed Employee #1 \nThe weight of the evidence showed that the named employee drove outside of Department \npolicy. Therefore a finding of Sustained was found for Emergency Vehicle Operations. \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n\nNOTE: The Seattle Police Department Manual policies cited for the allegation(s) made \nfor this OPA Investigation are policies that were in effect during the time of the incident. \nThe issued date of the policy is listed. \n\n \n\nComplaint Number OPA# 13-IS-0411 \n\nPage 2 of 2 \n\n\x0c', u'pdf': u'13-IS-0411ccs02-11-15.pdf', u'Summarized results': [{u'allegations': [{u'heading': u'Allegation #1', u'allegation': u'Seattle Police Department Manual 13.030 Emergency Vehicle Operations / Policy (Policy that was issued 11/21/12)', u'opa_finding': u'Sustained'}], u'final_discipline': u'One day suspension without pay', u'heading': u'Named Employee #1'}], u'txt': u'13-IS-0411ccs02-11-15.txt', u'id': u'cfee2384-fb23-450a-90bf-2cbfa2912876_OPA#13-IS-0411', u'OPA finding': u'Sustained', u'is_sustained': True}, {u'Complaint': u'The complainant, a supervisor within the department, alleged that the named employee had violated the law and was being charged criminally in another state for DUI.', u'Analysis and conclusion': u'OPA waited for the other state to finish their criminal investigation before commencing their administrative review of this case. The named employee had violated the law and had committed the DUI in another state.', u'Findings': u'Named Employee #1 Allegation #1 The evidence showed that the named employee violated the law. Therefore a Sustained finding was issued for Violation of Law.', u'Issued date': u'06/04/2015', u'organization_id': u'cfee2384-fb23-450a-90bf-2cbfa2912876', u'Final discipline': u'6 day suspension without pay', u'Investigation': u'The OPA investigation included the following actions: 1. Review of the complaint 2. Review of the police report and court documents 3. Search for and review of all relevant records and other evidence 4. Interviews of SPD employee', u'Incident synopsis': u'The named employee was arrested for DUI in another state in 2012.', u'Complaint number': u'OPA#2012-0534', u'parsed_txt': u' \n\nOFFICE OF PROFESSIONAL ACCOUNTABILITY \n\nClosed Case Summary \n\n \n\nComplaint Number OPA#2012-0534 \n\n \n\nIssued Date: 06/04/2015 \n \n\nNamed Employee #1 \n\nAllegation #1 \n\nSeattle Police Department Manual 5.001 (III.A) Violation of Law \n(Policy that was issued 08/15/12) \n\nOPA Finding \n\nSustained \n\nFinal Discipline \n\n6 day suspension without pay \n\n \n\nINCIDENT SYNOPSIS \n\nThe named employee was arrested for DUI in another state in 2012. \n\n \n\nCOMPLAINT \n\nThe complainant, a supervisor within the department, alleged that the named employee had \nviolated the law and was being charged criminally in another state for DUI. \n\n \n\nINVESTIGATION \n\nThe OPA investigation included the following actions: \n\n1. Review of the complaint \n2. Review of the police report and court documents \n3. Search for and review of all relevant records and other evidence \n4. Interviews of SPD employee \n\n \n\n \n\nComplaint Number OPA#2012-0534 \n\nPage 1 of 2 \n\n\x0cANALYSIS AND CONCLUSION \n\nOPA waited for the other state to finish their criminal investigation before commencing their \nadministrative review of this case. The named employee had violated the law and had \ncommitted the DUI in another state. \n \nFINDINGS \n \nNamed Employee #1 \nAllegation #1 \nThe evidence showed that the named employee violated the law. Therefore a Sustained \nfinding was issued for Violation of Law. \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n\nNOTE: The Seattle Police Department Manual policies cited for the allegation(s) made \nfor this OPA Investigation are policies that were in effect during the time of the incident. \nThe issued date of the policy is listed. \n\n \n\nComplaint Number OPA#2012-0534 \n\nPage 2 of 2 \n\n\x0c', u'pdf': u'2012-0534ccs06-04-15.pdf', u'Summarized results': [{u'allegations': [{u'heading': u'Allegation #1', u'allegation': u'Seattle Police Department Manual 5.001 (III.A) Violation of Law (Policy that was issued 08/15/12)', u'opa_finding': u'Sustained'}], u'final_discipline': u'6 day suspension without pay', u'heading': u'Named Employee #1'}], u'txt': u'2012-0534ccs06-04-15.txt', u'id': u'cfee2384-fb23-450a-90bf-2cbfa2912876_OPA#2012-0534', u'OPA finding': u'Sustained', u'is_sustained': True}, {u'Complaint': u'The named employee self-reported to his chain of command.', u'Analysis and conclusion': u'It was determined that the named employee purchased a controlled substance on more than one occasion from someone who was not a licensed pharmacist. While the named employee had a prescription for the substance that he purchased, it is unlawful to obtain a controlled substance in this manner. It was also determined that the named employee was given a different prescription medication by the same unauthorized source. SPD policy requires all employees to comply with the law.', u'Findings': u'Named Employee #1 The weight of the evidence showed that named employee #1 participated in illegal transactions for the medications; therefore a Sustained finding was issued for Adherence of Law.', u'Issued date': u'03/09/2015', u'organization_id': u'cfee2384-fb23-450a-90bf-2cbfa2912876', u'Final discipline': u'20 day suspension without pay', u'Investigation': u'The OPA investigation included the following actions: 1. Review of the complaint memo 2. Search for and review of all relevant records and other evidence 3. Review of other law enforcement agency available records 4. Interviews of Witnesses 5. Interviews of SPD employees', u'Incident synopsis': u'An outside law enforcement agency contacted the named employee regarding his purchase of a controlled substance from a person other than an authorized pharmacy. In exchange for his testimony concerning illegal drug sales by another person, the named employee received immunity from prosecution.', u'Complaint number': u'OPA#2014-0089', u'parsed_txt': u' \n\nOFFICE OF PROFESSIONAL ACCOUNTABILITY \n\nClosed Case Summary \n\n \n\nComplaint Number OPA#2014-0089 \n\n \n\nIssued Date: 03/09/2015 \n \n\nNamed Employee #1 \n\nAllegation #1 \n\nSeattle Police Department Manual 5.001 (III)(A) Standards & Duties \n\u2013 Adherence to Law (Policy that was issued 08/15/12) \n\nOPA Finding \n\nSustained \n\nFinal Discipline \n\n20 day suspension without pay \n\n \n\nINCIDENT SYNOPSIS \n\nAn outside law enforcement agency contacted the named employee regarding his purchase of a \ncontrolled substance from a person other than an authorized pharmacy. In exchange for his \ntestimony concerning illegal drug sales by another person, the named employee received \nimmunity from prosecution. \n\n \n\nCOMPLAINT \n\nThe named employee self-reported to his chain of command. \n \nINVESTIGATION \n\nThe OPA investigation included the following actions: \n\n1. Review of the complaint memo \n2. Search for and review of all relevant records and other evidence \n3. Review of other law enforcement agency available records \n4. Interviews of Witnesses \n5. Interviews of SPD employees \n\n \n\nComplaint Number OPA#2014-0089 \n\nPage 1 of 2 \n\n\x0cANALYSIS AND CONCLUSION \n\nIt was determined that the named employee purchased a controlled substance on more than \none occasion from someone who was not a licensed pharmacist. While the named employee \nhad a prescription for the substance that he purchased, it is unlawful to obtain a controlled \nsubstance in this manner. It was also determined that the named employee was given a \ndifferent prescription medication by the same unauthorized source. SPD policy requires all \nemployees to comply with the law. \n \nFINDINGS \n \nNamed Employee #1 \nThe weight of the evidence showed that named employee #1 participated in illegal transactions \nfor the medications; therefore a Sustained finding was issued for Adherence of Law. \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n\nNOTE: The Seattle Police Department Manual policies cited for the allegation(s) made \nfor this OPA Investigation are policies that were in effect during the time of the incident. \nThe issued date of the policy is listed. \n\n \n\nComplaint Number OPA#2014-0089 \n\nPage 2 of 2 \n\n\x0c', u'pdf': u'2014-0089ccs03-09-15.pdf', u'Summarized results': [{u'allegations': [{u'heading': u'Allegation #1', u'allegation': u'Seattle Police Department Manual 5.001 (III)(A) Standards & Duties \u2013 Adherence to Law (Policy that was issued 08/15/12)', u'opa_finding': u'Sustained'}], u'final_discipline': u'20 day suspension without pay', u'heading': u'Named Employee #1'}], u'txt': u'2014-0089ccs03-09-15.txt', u'id': u'cfee2384-fb23-450a-90bf-2cbfa2912876_OPA#2014-0089', u'OPA finding': u'Sustained', u'is_sustained': True}, {u'Complaint': u'The named employee self-reported that he had been arrested by another jurisdiction.', u'Analysis and conclusion': u'The evidence showed that the named employee was arrested for driving under the influence of alcohol and did not interact with the arresting officer in a professional or courteous manner. Furthermore, it was determined that the named employee had used marijuana on more than one occasion while not at work.', u'Findings': u'Named Employee Allegation #1, #2 and #3 The weight of the evidence showed that the named employee violated the law (DUI), was unprofessional and had used marijuana. Therefore a Sustained finding was issued for all of the allegations (Violation of Law, Professionalism, and Use of Marijuana, Medical or Otherwise, On- or Off-Duty). Discipline imposed: 12 Day Suspension without Pay', u'Issued date': u'05/08/2015', u'organization_id': u'cfee2384-fb23-450a-90bf-2cbfa2912876', u'Final discipline': u'12 Day Suspension without Pay', u'Investigation': u'The OPA investigation included the following actions: 1. Review of the complaint memo 2. Search for and review of all relevant records and other evidence 3. Interview of SPD employee', u'Incident synopsis': u'The named employee, a civilian SPD employee, was pulled over by another jurisdiction for obvious signs of impairment. The named empl[...]

import rethinkdb as r
obj = r.db('pizza')
obj = getattr(obj, "table")('tree')
obj = getattr(obj, "get")('zzz')

payload = {'table': 'police_internal_affairs_cases', 'filter': {'organization_id': 'cfee2384-fb23-450a-90bf-2cbfa2912876'}, 'has_fields': 'parsing_error', 'pluck': ['parsing_error']}
payload = json.dumps(payload)
print requests.get('http://ws.peoplesnsa.com/retrive/', {'payload': payload}).url

http://ws.peoplesnsa.com/retrive/?payload=%7B%22filter%22%3A+%7B%22organization_id%22%3A+%22cfee2384-fb23-450a-90bf-2cbfa2912876%22%7D%2C+%22table%22%3A+%22police_internal_affairs_cases%22%2C+%22pluck%22%3A+%5B%22parsing_error%22%5D%2C+%22has_fields%22%3A+%22parsing_error%22%7D

payload = {'table': 'police_internal_affairs_cases', 'filter': {'organization_id': 'cfee2384-fb23-450a-90bf-2cbfa2912876'}, 'has_fields': 'parsing_error', 'pluck': ['parsing_error']}
payload = json.dumps(payload)
print requests.get('http://ws.peoplesnsa.com/retrive/', {'payload': payload}).json()

[{u'parsing_error': u'list index out of range'}, {u'parsing_error': u'list index out of range'}, {u'parsing_error': u'list index out of range'}, {u'parsing_error': u'list index out of range'}, {u'parsing_error': u'list index out of range'}, {u'parsing_error': u'list index out of range'}, {u'parsing_error': u'list index out of range'}]

payload = {'table': 'police_internal_affairs_cases', 'action': 'get_fields'}
payload = json.dumps(payload)
print requests.get('http://ws.peoplesnsa.com/retrive/', {'payload': payload}).json()

[u'Analysis and conclusion', u'Complaint', u'Complaint number', u'Final discipline', u'Findings', u'Incident synopsis', u'Investigation', u'Issued date', u'OPA finding', u'Summarized results', u'id', u'is_sustained', u'organization_id', u'parsed_txt', u'parsing_error', u'pdf', u'txt']

payload = {'table': 'police_internal_affairs_cases', 'action': 'count'}
payload = json.dumps(payload)
print requests.get('http://ws.peoplesnsa.com/retrive/', {'payload': payload}).json()

{u'count': 209}

payload = {'table': 'police_internal_affairs_cases', 'match': {'field': 'Complaint', 'value': '.*?Force Review Board.*?'}}
payload = json.dumps(payload)
print requests.get('http://ws.peoplesnsa.com/retrive/', {'payload': payload}).url

http://ws.peoplesnsa.com/retrive/?payload=%7B%22table%22%3A+%22police_internal_affairs_cases%22%2C+%22match%22%3A+%7B%22field%22%3A+%22Complaint%22%2C+%22value%22%3A+%22.%2A%3FForce+Review+Board.%2A%3F%22%7D%7D

payload = {'table': 'police_internal_affairs_cases', 'action': 'percentage_simple_matching', 'has_string': {'field': 'Complaint', 'value': 'Force Review Board'}, 'numerator': {'field': 'is_sustained', 'value': True}}
payload = json.dumps(payload)
print requests.get('http://ws.peoplesnsa.com/retrive/', {'payload': payload}).json()

{u'percentage': u'0% (0/7)', u'denominator': 7, u'numerator': 0}

payload = {'table': 'police_internal_affairs_cases', 'has_string': {'field': 'Complaint', 'value': 'Force Review Board'}, 'pluck': ['Complaint number']}
payload = json.dumps(payload)
print requests.get('http://ws.peoplesnsa.com/retrive/', {'payload': payload}).json()

[{u'Complaint number': u'OPA#2015-0398'}, {u'Complaint number': u'OPA#2015-0243'}, {u'Complaint number': u'OPA#2015-0600'}, {u'Complaint number': u'OPA#2015-0361'}, {u'Complaint number': u'OPA#2015-0547'}, {u'Complaint number': u'OPA#2015-0775'}, {u'Complaint number': u'OPA#2015-0599'}]

payload = {'table': 'police_internal_affairs_cases', 'action': 'get_list', 'field': 'Complaint number'}
payload = json.dumps(payload)
print requests.get('http://ws.peoplesnsa.com/retrive/', {'payload': payload}).json()

[u'OPA#13-0502', u'14-IS-0101', u'OPA#2014-0091', u'2014-0525', u'14-0070', u'2014-0132', u'2014-0095', u'14-0128', u'OPA#14-0179', u'2014-0358', u'OPA#2014-0272', u'OPA#2014-0116', u'OPA#2014-0377,2014-0544,2014-0842', u'2014-0526', u'OPA#2012-0534', u'OPA#2014-0089', u'OPA#2014-0181', u'OPA#2014-0160', u'OPA#2014-0285', u'OPA#2014-0233', u'OPA#2014-0421', u'OPA#13-IS-0411', u'OPA#2014-0012', u'OPA#2014-0201', u'OPA#2014-0227', u'OPA#2014-0278', u'OPA#2014-0459', u'OPA#2014-0245', u'OPA#2014-0430', u'OPA#2014-0298', u'OPA#2014-0036', u'OPA#2014-0244', u'OPA#2014-0242', u'OPA#2014-0470', u'OPA#2014-0661', u'OPA#2014-0374', u'OPA#2014-0468', u'OPA#2014-0529', u'OPA#2014-0273', u'OPA#2014-0248', u'OPA#2014-0253', u'OPA#2014-0528', u'OPA#2014-0670', u'OPA#2014-0389', u'OPA#2014-0479', u'OPA#2014-0589', u'OPA#2014-0360', u'OPA#2014-0277', u'OPA#2014-0261', u'OPA#2014-0580', u'OPA#2014-0717', u'OPA#2014-0390', u'OPA#2014-0501', u'OPA#2014-0685', u'OPA#2014-0371', u'OPA#2014-0380', u'OPA#2014-0287', u'OPA#2014-0588', u'OPA#2014-0734', u'OPA#2014-0438', u'OPA#2014-0523', u'OPA#2014-0694', u'OPA#2014-0387', u'OPA#2014-0582', u'OPA#2014-0412', u'OPA#2014-0600', u'OPA#2014-0780', u'OPA#2014-0488', u'OPA#2014-0548', u'OPA#2014-0731', u'OPA#2014-0467', u'OPA#2014-0687', u'OPA#2014-0496', u'OPA#2014-0611', u'OPA#2015-0052', u'OPA#2014-0543', u'OPA#2014-0770', u'OPA#2014-0746', u'OPA#2014-0476', u'OPA#2014-0700', u'OPA#2014-0663', u'OPA#2014-0622', u'OPA#2015-0087', u'OPA#2014-0552', u'OPA#2014-0846', u'OPA#2014-0774', u'OPA#2014-0574', u'OPA#2014-0745', u'OPA#2014-0672', u'OPA#2015-0011', u'OPA#2015-0096', u'OPA#2014-0603', u'OPA#2015-0051', u'OPA#2014-0828', u'OPA#2014-0597', u'OPA#2014-0749', u'OPA#2014-0680', u'OPA#2015-0093', u'OPA#2015-0117', u'OPA#2014-0646', u'OPA#2015-0126', u'OPA#2015-0010', u'OPA#2014-0789', u'OPA#2014-0776', u'OPA#2014-0688', u'OPA#2015-0128', u'OPA#2015-0173', u'OPA#2014-0664andOPA#2015-0287', u'OPA#2015-0160', u'OPA#2015-0092', u'OPA#2015-0053', u'OPA#2015-0057', u'OPA#2014-0699', u'OPA#2015-0188', u'OPA#2015-0195', u'OPA#2014-0674', u'OPA#2015-0293', u'OPA#2015-0102', u'OPA#2015-0061', u'OPA#2015-0154', u'OPA#2014-0737', u'OPA#2015-0206', u'OPA#2015-0229', u'OPA#2014-0678', u'OPA#2015-0374', u'OPA#2015-0156', u'OPA#2015-0086', u'OPA#2015-0335', u'OPA#2014-0870', u'OPA#2015-0273', u'OPA#2015-0230', u'OPA#2014-0697', u'OPA#2015-0428', u'OPA#2015-0336', u'OPA#2015-0107', u'OPA#2015-0372', u'OPA#2015-0084', u'OPA#2015-0285', u'OPA#2015-0436', u'OPA#2014-0701', u'OPA#2015-0439', u'OPA#2015-0361', u'OPA#2015-0141', u'OPA#2015-0430', u'OPA#2015-0105', u'OPA#2015-0304', u'OPA#2015-0444', u'OPA#2014-0732', u'OPA#2015-0446', u'OPA#2015-0441', u'OPA#2015-0150', u'OPA#2015-0443', u'OPA#2015-0136', u'OPA#2015-0315', u'OPA#2015-0455', u'OPA#2014-0775andOPA#2015-0216', u'OPA#2015-0474', u'OPA#2015-0449', u'OPA#2015-0278', u'OPA#2015-0452', u'OPA#2015-0142', u'OPA#2015-0401', u'OPA#2015-0507', u'OPA#2015-0068', u'OPA#2015-0509', u'OPA#2015-0512', u'OPA#2015-0300', u'OPA#2015-0255', u'OPA#2015-0432', u'OPA#2015-0877', u'OPA#2015-0237', u'OPA#2015-0600', u'OPA#2015-0542', u'OPA#2015-0308', u'OPA#2015-0283', u'OPA#2015-0448', u'OPA#2015-0243', u'OPA#2015-0622', u'sOPA#2014-0555,2014-0656,2015-0080', u'OPA#2015-0398', u'OPA#2015-0451', u'OPA#2015-0345', u'OPA#2015-0317', u'OPA#2015-0645', u'OPA#2015-0429', u'OPA#2015-0571', u'OPA#2015-0358', u'OPA#2015-0384', u'OPA#2015-0434', u'OPA#2015-0690', u'OPA#2015-0367', u'OPA#2015-0442', u'OPA#2015-0438', u'OPA#2015-0437', u'OPA#2015-0447', u'OPA#2015-0453', u'OPA#2015-0445', u'OPA#2015-0456', u'OPA#2015-0470', u'OPA#2015-0454', u'OPA#2015-0475', u'OPA#2015-0478', u'OPA#2015-0547', u'OPA#2015-0504', u'OPA#2015-0601', u'OPA#2015-0575', u'OPA#2015-0644', u'OPA#2015-0599', u'OPA#2015-0775']

payload = {'table': 'police_internal_affairs_cases', 'action': 'get_set', 'field': 'Final discipline'}
payload = json.dumps(payload)
print requests.get('http://ws.peoplesnsa.com/retrive/', {'payload': payload}).json()

[u'No Discipline \u2013 Resignation in lieu of termination', u'N/A Named Employee #2 Allegation #1 Seattle Police Department Manual 8.100 (1) Using Force: When Authorized (Policy that was issued 01/01/14) OPA Finding Not Sustained (Lawful and Proper) Final Discipline N/A Named Employee #3 Allegation #1 Seattle Police Department Manual 8.100 (1) Using Force: When Authorized (Policy that was issued 01/01/14) OPA Finding Not Sustained (Lawful and Proper) Final Discipline N/A Complaint Number OPA#2015-0154 Page 1 of 3 \x0cNamed Employee #4 Allegation #1 Seattle Police Department Manual 8.100 (1) Using Force: When Authorized (Policy that was issued 01/01/14) OPA Finding Not Sustained (Lawful and Proper) Final Discipline N/A Named Employee #5 Allegation #1 Seattle Police Department Manual 16.090 (4) In-Car Video System: Employees Will Record Enforcement-Related Activity Which Occurs Within Camera Range (Policy that was issued 11/11/12) OPA Finding Not Sustained (Unfounded) Final Discipline N/A', u'N/A Named Employee #2 Allegation #1 Seattle Police Department Manual 5.100 (I.A) Operations Bureau Individual Responsibilities: Patrol Sergeant \u2013 Field Supervision (Policy that was issued 07/20/10) OPA Finding Not Sustained (Unfounded) Final Discipline N/A', u'N/A Named Employee #2 Allegation #1 Seattle Police Department Manual 8.100 Use of Force: When Authorized (Policy that was issued 01/01/14) OPA Finding Not Sustained (Training Referral) Final Discipline N/A', u'N/A Named Employee #2 Allegation #1 Seattle Police Department Manual 8.100 (1) Use of Force: When Authorized (Policy that was issued 01/01/14) OPA Finding Not Sustained (Lawful & Proper) Allegation #2 Seattle Police Department Manual 5.001 (9) Professionalism (Policy that was issued 07/16/14) OPA Finding Not Sustained (Unfounded) Final Discipline N/A Complaint Number OPA#2014-0661 Page 1 of 3 \x0c', u'Written Reprimand Named Employee #2 Allegation #1 Seattle Police Department Manual 5.001 (VI.A) Standards & Duties / Integrity (Policy that was issued prior to 7/16/14) OPA Finding Not Sustained (Inconclusive) Allegation #2 Seattle Police Department Manual 5.001 (VI.A) Standards & Duties / Professionalism (Policy that was issued prior to 7/16/14) OPA Finding Sustained Final Discipline 1 day suspension without pay Complaint Number OPA#2014-0248 Page 1 of 3 \x0c', u'20 day suspension without pay', u'No Discipline - Training Complaint Number OPA#2014-0597 Page 1 of 3 \x0c', u'N/A Named Employee #2 Allegation #1 Seattle Police Department Manual 5.001 \u2013 Standards and Duties Professionalism/Courtesy (Policy in effect prior to 07/16/14) OPA Finding Not Sustained (Lawful & Proper) Allegation #2 Seattle Police Department Manual 6.220 Stops & Detentions 6.220 (Policy that was issued 1/30/14) OPA Finding Not Sustained (Lawful & Proper) Final Discipline N/A Complaint Number OPA#2014-0160 Page 1 of 3 \x0c', u'N/A Named Employee #2 Allegation #1 Seattle Police Department Manual 8.100 (1) Using Force: When Authorized (Policy that was issued 01/01/14) OPA Finding Not Sustained (Lawful and Proper) Allegation #2 Seattle Police Department Manual 5.140 (2) Officers Will Not Engage in Bias-Based Policing (Policy that was issued 01/30/14) OPA Finding Not Sustained (Unfounded) Final Discipline N/A Complaint Number OPA#2015-0645 Page 1 of 2 \x0c', u'Oral Reprimand Named Employee #2 Allegation #1 Seattle Police Department Manual 5.001 (6) Employees Engaged in Department-Related Activities Identify Themselves When Requested (Policy that was issued 07/16/14) OPA Finding Not Sustained (Inconclusive) Final Discipline N/A Complaint Number OPA#2015-0384 Page 1 of 3 \x0c', u'N/A Named Employee #2 Allegation #1 Seattle Police Department Manual 8.100 (1) Using Force: When Authorized (Policy that was issued 01/01/14) OPA Finding Not Sustained (Lawful and Proper) Final Discipline N/A Named Employee #3 Allegation #1 Seattle Police Department Manual 8.100 (1) Using Force: When Authorized (Policy that was issued 01/01/14) OPA Finding Not Sustained (Lawful and Proper) Final Discipline N/A Complaint Number OPA#2014-0105 Page 1 of 3 \x0c', u'N/A Complaint Number OPA#2014-0737 Page 1 of 4 \x0cNamed Employee #2 Allegation #1 Seattle Police Department Manual 5.001 (9) Professionalism (Policy that was issued 07/16/14) OPA Finding Not Sustained (Unfounded) Allegation #2 Seattle Police Department Manual 5.001 (6) Employees Engaged in Department-Related Activities Identify Themselves When Requested (Policy that was issued 07/16/14) OPA Finding Not Sustained (Unfounded) Allegation #3 Seattle Police Department Manual 5.120 Secondary Employment (Policy that was issued 03/19/14) OPA Finding Not Sustained (Lawful and Proper) Final Discipline N/A', None, u'Oral Reprimand and Retraining on Policies 8.100(1) and 14.090(10b)', u'N/A Named Employee #2 Allegation #1 Seattle Police Department Manual 16.090 (4) Employees Will Record Enforcement-Related Activity Which Occurs Within Camera (Policy that was issued 11/21/12) OPA Finding Not Sustained (Lawful and Proper) Final Discipline N/A Named Employee #3 Allegation #1 Seattle Police Department Manual 16.090 (4) Employees Will Record Enforcement-Related Activity Which Occurs Within Camera (Policy that was issued 11/21/12) OPA Finding Not Sustained (Lawful and Proper) Final Discipline N/A Complaint Number OPA#2015-0475 Page 1 of 2 \x0c', u'Resignation in lieu of termination', u'N/A Named Employee #2 Allegation #1 Seattle Police Department Manual 16.090 (6) In Car Video System: Positioning of Car or Camera to Record Police Activity (Policy that was issued 02/01/15) OPA Finding Not Sustained (Training Referral) Allegation #2 Seattle Police Department Manual 16.090 (10) In Car Video System: Employees Will Turn Off the AM/FM Vehicle Radio During ICV Recordings (Policy that was issued 02/01/15) OPA Finding Not Sustained (Training Referral) Final Discipline N/A Complaint Number OPA#2015-0173 Page 1 of 3 \x0c', u'Termination (under appeal as of 10/8/15)', u'N/A Named Employee #2 Allegation #1 Seattle Police Department Manual 5.100 (I.A)(2) Take Appropriate Action Regarding Criminal Activity (Policy that was issued 07/20/10) OPA Finding Not Sustained (Training Referral) Final Discipline N/A', u'5 days suspension without pay; Disciplinary Transfer', u'3 Day Suspension without pay Complaint Number OPA#2014-0731 Page 1 of 5 \x0cNamed Employee #2 Allegation #1 Seattle Police Department Manual 8.300 \u2013 POL-3 (4) Use of Force Reporting and Investigation: Type II Investigation \u2013 Sergeant Will Complete a Sergeant\u2019s Force Investigation Report Within 3 Days (Policy that was issued 01/01/14) OPA Finding Sustained Final Discipline Oral Reprimand Named Employee #3 Allegation #1 Seattle Police Department Manual 8.300 \u2013 POL-3 (4.a) Use of Force Reporting and Investigation: Type II Investigation \u2013 Review of Sergeant\u2019s Force Investigation Report by Higher Level Supervisor (Policy that was issued 01/01/14) OPA Finding Sustained Allegation #2 Seattle Police Department Manual 8.400 \u2013 POL-1 (10) Reviewing Use of Force: Command Review of Use of Force \u2013 The Reviewing Lieutenant Will Make Determinations Regarding the Use of Force (Policy that was issued 01/01/14) OPA Finding Not Sustained (Lawful and Proper) Allegation #3 Seattle Police Department Manual 8.400 \u2013 POL-1 (11) Reviewing Use of Force: Command Review of Use of Force \u2013 The Reviewing Lieutenant Complete Review and Forward Reports to the Precinct or Section Captain Within 72 Business Hours (Policy that was issued 01/01/14) OPA Finding Sustained Final Discipline Written Reprimand Complaint Number OPA#2014-0731 Page 2 of 5 \x0c', u'Resignation in lieu of termination Named Employee #2 Allegation #1 Seattle Police Department Manual 5.001 (III.A.1) Standards & Duties: Knowledge of and Adherence to Laws (Policy that was issued 8/15/2012) and 5.001 (2) Standards and Duties: Employees Must Adhere to Laws and Department Policy (Policy that was issued 7/16/2014) OPA Finding Not Sustained (Inconclusive) Allegation #2 Seattle Police Department Manual 5.001 (VI.A.3) Standards & Duties: Integrity \u2013 Misuse of Authority: Employees shall not use their position or authority as a police officer for personal gain (Policy that was issued 8/15/2012) and 5.001 (12) Standards and Duties: Employees shall not use their position or authority for personal gain (Policy that was issued 07/16/14) OPA Finding Not Sustained (Inconclusive) Final Discipline N/A', u'No Discipline \u2013 Employee had already resigned', u'N/A Named Employee #2 Allegation #1 Seattle Police Department Manual 8.400 Reviewing Use of Force (Policy that was issued 1/1/14) OPA Finding Not Sustained (Lawful & Proper) Final Discipline N/A Named Employee #3 Allegation #1 Seattle Police Department Manual 8.400 Reviewing Use of Force (Policy that was issued 1/1/14) OPA Finding Not Sustained (Lawful & Proper) Final Discipline N/A Complaint Number OPA#2014-0242 Page 1 of 3 \x0cNamed Employee #4 Allegation #1 Seattle Police Department Manual 8.400 Reviewing Use of Force (Policy that was issued 1/1/14) OPA Finding Not Sustained (Lawful & Proper) Final Discipline N/A', u'One day suspension without pay', u'Retirement in lieu of Termination Complaint Number OPA#2014-0770 Page 1 of 3 \x0c', u'N/A Named Employee #2 Allegation #1 Seattle Police Department Manual 6.180 Searches - General (Policy that was issued prior to 01/1/15) OPA Finding Not Sustained (Lawful & Proper) Final Discipline N/A Named Employee #3 Allegation #1 Seattle Police Department Manual 6.180 Searches - General (Policy that was issued prior to 01/1/15) OPA Finding Not Sustained (Lawful & Proper) Final Discipline N/A Complaint Number OPA#2014-0272 Page 1 of 4 \x0cNamed Employee #4 Allegation #1 Seattle Police Department Manual 6.180 Searches - General (Policy that was issued prior to 01/1/15) OPA Finding Not Sustained (Lawful & Proper) Final Discipline N/A Named Employee #5 Allegation #1 Seattle Police Department Manual 6.180 Searches - General (Policy that was issued prior to 01/1/15) OPA Finding Not Sustained (Unfounded) Final Discipline N/A Named Employee #6 Allegation #1 Seattle Police Department Manual 6.180 Searches - General (Policy that was issued prior to 01/1/15) OPA Finding Not Sustained (Lawful & Proper) Final Discipline N/A', u'N/A Named Employee #2 Allegation #1 Seattle Police Department Manual 6.220 POL-1 (8) Voluntary Contact & Terry Stops \u2013 Frisk (Policy that was issued 12/01/14) OPA Finding Not Sustained (Lawful & Proper) Final Discipline N/A Complaint Number OPA#2014-0548 Page 1 of 3 \x0c', u'No Discipline \u2013 no longer an SPD employee', u'15 day suspension without pay (Under Appeal) Complaint Number OPA#2014-0233 Page 1 of 3 \x0cNamed Employee #2 Allegation #1 Seattle Police Department Manual 6.220 Voluntary Contacts & Terry Stops (Policy that was issued 1/30/14) OPA Finding Not Sustained (Lawful & Proper) Allegation #2 Seattle Police Department Manual 5.001(VII.A.) (6.b) Professionalism-Profanity (Policy that was issued 8/18/12) OPA Finding Sustained Allegation #3 Seattle Police Department Manual 5.001(VII.2) Professionalism- Courtesy (Policy that was issued 8/18/12) OPA Finding Sustained Allegation #4 Seattle Police Department Manual 8.100 Use of Force: When Authorized (Policy that was issued 1/1/14) OPA Finding Sustained Final Discipline 15 day suspension without pay (Under Appeal)', u'N/A Named Employee #2 Allegation #1 Seattle Police Department Manual 8.100 (1) Use of Force: When Authorized (Policy that was issued 01/01/14) OPA Finding Not Sustained (Lawful & Proper) Allegation #2 Seattle Police Department Manual 8.100 (3) Use of Force: De- escalation (Policy that was issued 01/01/14) OPA Finding Not Sustained (Lawful & Proper) Final Discipline N/A Complaint Number OPA#2014-0694 Page 1 of 3 \x0c', u'2 day suspension without pay (under appeal)', u'N/A Named Employee #2 Allegation #1 Seattle Police Department Manual 5.001 (9) Professionalism (Policy that was issued 07/16/14) OPA Finding Not Sustained (Unfounded) Final Discipline N/A Named Employee #3 Allegation #1 Seattle Police Department Manual 5.002 (4) Responsibilities of Employees concerning complaints of possible misconduct: Retaliation is prohibited (Policy that was issued 07/16/14) OPA Finding Not Sustained (Unfounded) Final Discipline N/A Complaint Number OPA#2014-0700 Page 1 of 3 \x0c', u'N/A Named Employee #2 Allegation #1 Seattle Police Department Manual 8.100 (I) Using Force: When Authorized (Policy that was issued 01/01/14) OPA Finding Not Sustained (Unfounded) Final Discipline N/A Named Employee #3 Allegation #1 Seattle Police Department Manual 8.100 (I) Using Force: When Authorized (Policy that was issued 01/01/14) OPA Finding Not Sustained (Unfounded) Final Discipline N/A Complaint Number OPA#2014-0389 Page 1 of 2 \x0c', u'N/A Named Employee #2 Allegation #1 Seattle Police Department Manual 5.001 (ll.A)(1.c) Responsibility of Supervisors (Policy that was in effect prior to 7116114) OPA Finding Not Sustained (Management Action) Final Discipline N/A Complaint Number OPA# 14-0070 Page 1 of 4 \x0cNamed Employee #3 Allegation #1 Seattle Police Department Manual 5.001 (ll.AX1.c) Responsibitity of Supervisors (Policy that was in effect prior to 7116114) OPA Finding Not Sustained (Management Action) Final Discipline N/A Named Employee #4 Allegation #1 Seattle Police Department Manual 1.040 Department Mission Statement & Priorities (Policy was effective 4128105 - 1l21l14) OPA Finding Not Sustained (Management Action) Final Discipline N/A Named Employee #5 Allegation #1 Seattle Police Department Manual 5.001 (ll.AX1.c) Responsibility of Supervisors (Policy that was in effect prior to 7116114) OPA Finding Not Sustained (Management Action) Final Discipline N/A', u'N/A Named Employee #2 Allegation #1 Seattle Police Department Manual 15.120 Malicious Harassment \u2013 Response (Policy that was issued 09/19/12) OPA Finding Not Sustained (Training Referral) Final Discipline N/A Named Employee #3 Allegation #1 Seattle Police Department Manual 7.010 Submitting Evidence (Policy that was issued 02/19/14) OPA Finding Not Sustained (unfounded) Final Discipline N/A Complaint Number OPA#2014-0488 Page 1 of 3 \x0c', u'12 Day Suspension without Pay', u'1 day suspension without pay and retraining on Policy 8.100 (1)', u'N/A Complaint Number OPA#2014-0387 Page 1 of 3 \x0cNamed Employee #2 Allegation #1 Seattle Police Department Manual 8.100 (1) Use of Force: When Authorized (Policy that was issued 01/01/14) OPA Finding Not Sustained (Unfounded) Allegation #2 Seattle Police Department Manual 5.001(2) Adhere to Department Policy & Training (Policy that was issued 07/16/14) OPA Finding Not Sustained (Lawful & Proper) Allegation #3 Seattle Police Department Manual 11.010 Detainee Management: Ensure Safety of Detainees (Policy that was issued 12/19/12) OPA Finding Not Sustained (Training Referral) Final Discipline N/A', u'Oral Reprimand', u'N/A Named Employee #2 Allegation #1 Seattle Police Department Manual 6.220 (1) Voluntary Contacts, Terry Stops & Detentions: Terry Stops are Seizures and Must Be Based on Reasonable Suspicion in Order to be Lawful (Policy that was issued 12/01/14) OPA Finding Not Sustained (Lawful and Proper) Allegation #2 Seattle Police Department Manual 8.200 (3) Use of Force Tools: Officers Will Use OC Spray Only When Such Force is Objectively Reasonable (Policy that was issued 01/01/14) OPA Finding Not Sustained (Lawful and Proper) Final Discipline N/A Complaint Number OPA#2015-0293 Page 1 of 3 \x0c', u'12 Day Suspension and Additional Training on Primary Investigations Named Employee #2 Allegation #1 Seattle Police Department Manual 15.120 -Pol - Malicious Harassment (Policy that was issued 09/09/12) OPA Finding Not Sustained (Unfounded) Final Discipline N/A Named Employee #3 Allegation #1 Seattle Police Department Manual 5.100 (II.A.3) Duty Officer - Take in-person complaints (Policy that was issued 7/20/10) OPA Finding Not Sustained (Inconclusive) Final Discipline N/A', u'Written Reprimand Complaint Number OPA#2015-0601 Page 1 of 3 \x0c', u'N/A', u'N/A Named Employee #2 Allegation #1 Seattle Police Department Manual 11.010 (2) Detainee Management in Department Facilities: Officers Will Assist Detainees with Reasonable Requests for Water and Restroom Access (Policy that was issued 12/19/2012) OPA Finding Not Sustained (Unfounded) Final Discipline N/A', u'N/A Named Employee #2 Allegation #1 Seattle Police Department Manual 6.220 (5) During a Terry Stop, Officers Will Limit the Seizure to a Reasonable Amount of Time (Policy that was issued 01/30/14) OPA Finding Not Sustained (Lawful and Proper) Final Discipline N/A Complaint Number OPA#2015-0575 Page 1 of 3 \x0c', u'N/A Named Employee #2 Allegation #1 Seattle Police Department Manual 12.050 Criminal Records (Policy that was issued 05/24/11) OPA Finding Not Sustained (Inconclusive) Allegation #2 Seattle Police Department Manual 5.001 IV (C)(1) Confidentiality (Policy that was issued 08/15/12) OPA Finding Not Sustained (Inconclusive) Final Discipline N/A Complaint Number OPA#2014-0012 Page 1 of 3 \x0c', u'N/A Complaint Number OPA#2015-0154 Page 1 of 3 \x0c Named Employee #2 Allegation #1 Seattle Police Department Manual 5.002 (6) Responsibilities of Employees Concerning Complaints of Possible Misconduct: Employees Must Otherwise Report Misconduct (Policy that was issued 07/16/14) OPA Finding Not Sustained (Inconclusive) Allegation #2 Seattle Police Department Manual 5.140 (6) Employees Will Document All Allegations of Bias-Based Policing (Policy that was issued 01/30/14) OPA Finding Sustained Final Discipline No Discipline \u2013 Employee already left SPD employment', u'N/A Named Employee #2 Allegation #1 Seattle Police Department Manual 8.100 Use of Force: When Authorized (Policy that was issued 01/01/14) OPA Finding Not Sustained (Lawful & Proper) Final Discipline N/A', u'N/A Named Employee #2 Allegation #1 Seattle Police Department Manual 8.100 Use-of-Force: When Authorized (Policy that was issued 1/1/2014) OPA Finding Not Sustained (Lawful & Proper) Final Discipline N/A', u'N/A Named Employee #2 Allegation #1 Seattle Police Department Manual 6.220 (1) Voluntary Contacts, Terry Stops & Detentions; Must be Based on Reasonable Suspicion (Policy that was issued 12/01/14) OPA Finding Not Sustained (Lawful and Proper) Allegation #2 Seattle Police Department Manual 6.220 (10) Officers Must Document All Terry Stops (Policy that was issued 12/01/14) OPA Finding Not Sustained (Training Referral) Final Discipline N/A Complaint Number OPA#2015-0285 Page 1 of 3 \x0c Named Employee #3 Allegation #1 Seattle Police Department Manual 6.220 (1) Voluntary Contacts, Terry Stops & Detentions; Must be Based on Reasonable Suspicion (Policy that was issued 12/01/14) OPA Finding Not Sustained (Lawful and Proper) Allegation #2 Seattle Police Department Manual 6.220 (10) Officers Must Document All Terry Stops (Policy that was issued 12/01/14) OPA Finding Not Sustained (Training Referral) Final Discipline N/A Named Employee #4 Allegation #1 Seattle Police Department Manual 6.220 (1) Voluntary Contacts, Terry Stops & Detentions; Must be Based on Reasonable Suspicion (Policy that was issued 12/01/14) OPA Finding Not Sustained (Lawful and Proper) Allegation #2 Seattle Police Department Manual 6.220 (10) Officers Must Document All Terry Stops (Policy that was issued 12/01/14) OPA Finding Not Sustained (Training Referral) Final Discipline N/A', u'Termination', u'Oral Reprimand and Training on Manual Policy Section 5.125', u'1 day suspension and Disciplinary Transfer out of any plainclothes or pro-act unit for a period of two years', u'Termination (under appeal)', u'6 day suspension without pay', u'N/A Named Employee #2 Allegation #1 Seattle Police Department Manual 8.100 (1) Use of Force: When Authorized (Policy that was issued 01/01/14) OPA Finding Not Sustained (Lawful & Proper) Final Discipline N/A Complaint Number OPA#2014-0749 Page 1 of 3 \x0c', u'No Discipline \u2013 additional training to be provided', u'N/A Named Employee #2 Allegation #1 Seattle Police Department Manual 5.001 (VII) (2) Professionalism/Courtesy (Policy issued prior to 07/16/14) OPA Finding Not Sustained (Unfounded) Final Discipline', u'N/A Named Employee #2 Allegation #1 Seattle Police Department Manual 6.180 - Searches-General: Must be pursuant to a warrant or legal exception to the warrant requirement (Policy that was issued 01/01/15) OPA Finding Not Sustained (Unfounded) Final Discipline N/A Complaint Number OPA#2015-0542 Page 1 of 3 \x0c', u'N/A Named Employee #2 Allegation #1 Seattle Police Department Manual 15.180 (1) Primary Investigations: Search for Evidence (Policy that was issued 05/21/14) OPA Finding Not Sustained (Lawful & Proper) Final Discipline N/A', u'N/A Named Employee #2 Allegation #1 Seattle Police Department Manual 5.001 (VII) (A) (1) Standards & Duties \u2013 Exercise of Discretion (Policy that was issued 08/15/12) OPA Finding Not Sustained (Unfounded) Allegation #2 Seattle Police Department Manual 5.140 Bias-Free Policing (Policy that was issued prior to 1/1/15) OPA Finding Not Sustained (Unfounded) Final Discipline N/A Complaint Number OPA#2014-0091 Page 1 of 4 \x0cNamed Employee #3 Allegation #1 Seattle Police Department Manual 5.001 (VII) (A) (1) Standards & Duties \u2013 Exercise of Discretion (Policy that was issued 08/15/12) OPA Finding Not Sustained (Unfounded) Allegation #2 Seattle Police Department Manual 5.140 Bias-Free Policing (Policy that was issued prior to 1/1/15) OPA Finding Not Sustained (Unfounded) Final Discipline N/A Named Employee #4 Allegation #1 Seattle Police Department Manual 5.001 (VII) (A) (1) Standards & Duties \u2013 Exercise of Discretion (Policy that was issued 08/15/12) OPA Finding Not Sustained (Unfounded) Allegation #2 Seattle Police Department Manual 5.140 Bias-Free Policing (Policy that was issued prior to 1/1/15) OPA Finding Not Sustained (Unfounded) Final Discipline N/A Named Employee #5 Allegation #1 Seattle Police Department Manual 5.001 (VII) (A) (1) Standards & Duties \u2013 Exercise of Discretion (Policy that was issued 08/15/12) OPA Finding Not Sustained (Unfounded) Allegation #2 Seattle Police Department Manual 5.140 Bias-Free Policing (Policy that was issued prior to 1/1/15) OPA Finding Not Sustained (Unfounded) Final Discipline N/A Complaint Number OPA#2014-0091 Page 2 of 4 \x0c', u'N/A Complaint Number OPA#2015-0206 Page 1 of 4 \x0cNamed Employee #2 Allegation #1 Seattle Police Department Manual 5.001 (5) Employees May Use Discretion (Policy that was issued 07/16/14) OPA Finding Not Sustained (Lawful and Proper) Allegation #2 Seattle Police Department Manual 5.001 (I.A.2) Operations Bureau Individual Responsibilities: Monitor and take appropriate action regarding criminal activity in assigned area (Policy that was issued 07/16/14) OPA Finding Not Sustained (Lawful and Proper) Allegation #3 Seattle Police Department Manual 15.180 (1) Primary Investigations: Officer Shall Conduct a Thorough and Complete Search for Evidence (Policy that was issued 05/21/14) OPA Finding Not Sustained (Lawful and Proper) Final Discipline N/A Named Employee #3 Allegation #1 Seattle Police Department Manual 5.001 (III.A.1.c) Operations Bureau Individual Responsibilities: Patrol Sergeant; Responsibilities; Direct supervision of any incident involving multiple units (Policy that was issued 07/16/14) OPA Finding Allegation #2 OPA Finding Not Sustained (Lawful and Proper) Seattle Police Department Manual 5.001 (5) Employees May Use Discretion (Policy that was issued 07/16/14) Not Sustained (Lawful and Proper) Final Discipline N/A Complaint Number OPA#2015-0206 Page 2 of 4 \x0c', u'N/A Complaint Number OPA#2014-0600 Page 1 of 3 \x0cNamed Employee #2 Allegation #1 Seattle Police Department Manual 6.220 (2)(a) Voluntary Contacts and Terry Stops: Voluntary Contact Defined (Policy that was issued 01/20/14) OPA Finding Not Sustained (Training Referral) Allegation #2 Seattle Police Department Manual 5.140 (2) Bias-Free Policing: Officers Will Not Engage in Bias-Based Policing (Policy that was issued 01/30/14) OPA Finding Not Sustained (Inconclusive) Final Discipline N/A', u'N/A Named Employee #2 Allegation #1 Seattle Police Department Manual 5.001 (2) Adherence to SPD Policies: Domestic Violence Investigations (Policy that was issued 07/16/14) OPA Finding Not Sustained (Training Referral) Final Discipline N/A Complaint Number OPA#2014-0588 Page 1 of 3 \x0c', u'No Discipline \u2013 Employee already had resigned', u'N/A Named Employee #2 Allegation #1 Seattle Police Department Manual 8.100 Use of Force: When Authorized (Policy that was issued prior to 1/1/14) OPA Finding Not Sustained (Unfounded) Final Discipline N/A Named Employee #3 Allegation #1 Seattle Police Department Manual 6.150 Advising Persons of Right to Counsel and Miranda (Policy that was issued prior to 1/1/15) OPA Finding Not Sustained (Training Referral) Final Discipline N/A Complaint Number OPA#2014-0227 Page 1 of 4 \x0cNamed Employee #4 Allegation #1 Seattle Police Department Manual 8.100 Use of Force: When Authorized (Policy that was issued prior to 1/1/14) OPA Finding Not Sustained (Unfounded) Final Discipline N/A', u'N/A Named Employee #2 Allegation #1 Seattle Police Department Manual 5.001 (2) Employee Must Adhere to Laws and Department Policy \u2013 Mandatory Arrest in Domestic Violence (Policy that was issued 02/26/09) OPA Finding Not Sustained (Unfounded) Allegation #2 Seattle Police Department Manual 15.180 (5) Document on General Offense Report (Policy that was issued 05/21/14) OPA Finding Not Sustained (Training Referral) Final Discipline N/A Complaint Number OPA#2014-0688 Page 1 of 3 \x0cNamed Employee #3 Allegation #1 Seattle Police Department Manual 5.001 (2) Employee Must Adhere to Laws and Department Policy \u2013 Mandatory Arrest in Domestic Violence (Policy that was issued 02/26/09) OPA Finding Not Sustained (Unfounded) Allegation #2 Seattle Police Department Manual 15.180 (5) Document on General Offense Report (Policy that was issued 05/21/14) OPA Finding Not Sustained (Unfounded) Final Discipline N/A', u'No Discipline, provide additional training', u'N/A Named Employee #2 Allegation #1 Seattle Police Department Manual 8.100 Use of Force: When Authorized (Policy that was issued 1/1/14) OPA Finding Not Sustained (Lawful & Proper) Final Discipline N/A', u'Written Reprimand', u'N/A Named Employee #2 Allegation #1 Seattle Police Department Manual 8.100 (I) Use of Force: When Authorized (Policy that was issued 01/01/14) OPA Finding Not Sustained (Unfounded) Final Discipline N/A']

payload = {'table': 'tables', 'action': 'do_row_mapping', 'field_for_key': 'categories'}
payload = json.dumps(payload)
print requests.get('http://ws.peoplesnsa.com/retrive/', {'payload': payload}).json()

{u'keys': [u'policing', u"People's NSA"], u'data': {u'policing': [{u'id': u'police_internal_affairs_cases', u'categories': [u'policing'], u'name': u'Police internal affairs cases'}], u"People's NSA": [{u'id': u'crawling_instructions', u'categories': [u"People's NSA"], u'name': u'Crawling instructions'}, {u'id': u'tables', u'categories': [u"People's NSA"], u'name': u'Tables'}, {u'id': u'apps', u'categories': [u"People's NSA"], u'name': u'Apps'}, {u'id': u'organizations', u'categories': [u"People's NSA"], u'name': u'Organizations'}]}, u'table_fields': [u'id', u'categories', u'name']}