Disposition Of Offensive Language Allegations 2009

Dataset

Name Value
Catalog Link
Metadata Link
Data: JSON 100 Rows
Data: CSV 100 Rows
Host data.cityofnewyork.us
Id g7ee-832z
Name Disposition Of Offensive Language Allegations 2009
Attribution Civilian Complaint Review Board (CCRB)
Category Public Safety
Tags complaint, civilian, review, board, activity, ccrb, civilian complaint review board, 2005, 2006, 2007, 2008, 2009, complaint activity, statistics, disciplinary recommendation, allegation, misconduct
Created 2011-09-28T23:58:19Z
Publication Date 2011-09-28T23:59:34Z

Description

CCRB: Disposition of Offensive Language Allegations 2009

Columns

| Included | Schema Type    | Field Name                            | Name                                  | Data Type | Render Type |
| ======== | ============== | ===================================== | ===================================== | ========= | =========== |
| Yes      | series tag     | type_of_abuse_of_authority_allegation | Type of Abuse of Authority Allegation | text      | text        |
| Yes      | series tag     | substantiated_number                  | Substantiated Number                  | text      | number      |
| Yes      | numeric metric | sunstantiated_rate                    | Sunstantiated rate                    | percent   | percent     |
| Yes      | series tag     | exonerated_number                     | Exonerated number                     | text      | number      |
| Yes      | numeric metric | exonerated_rate                       | Exonerated rate                       | percent   | percent     |
| Yes      | series tag     | unsubstantiated_number                | Unsubstantiated number                | text      | number      |
| Yes      | numeric metric | unsubstantiated_rate                  | Unsubstantiated rate                  | percent   | percent     |
| Yes      | series tag     | unfounded_number                      | Unfounded number                      | text      | number      |
| Yes      | numeric metric | unfounded_rate                        | Unfounded rate                        | percent   | percent     |
| Yes      | series tag     | officer_unidentified_number           | Officer Unidentified number           | text      | number      |
| Yes      | numeric metric | officer_unidentified_rate             | Officer Unidentified rate             | percent   | percent     |
| Yes      | numeric metric | miscellaneous                         | Miscellaneous                         | number    | number      |
| Yes      | numeric metric | miscellaneous_rate                    | Miscellaneous rate                    | percent   | percent     |

Time Field

Value = 2009
Format & Zone = yyyy

Data Commands

series e:g7ee-832z d:2009-01-01T00:00:00.000Z t:type_of_abuse_of_authority_allegation=Race t:substantiated_number=1 t:exonerated_number=0 t:unfounded_number=44 t:unsubstantiated_number=70 t:officer_unidentified_number=16 m:miscellaneous=5 m:unfounded_rate=32.4 m:officer_unidentified_rate=11.8 m:miscellaneous_rate=3.7 m:sunstantiated_rate=0.7 m:unsubstantiated_rate=51.5 m:exonerated_rate=0

series e:g7ee-832z d:2009-01-01T00:00:00.000Z t:type_of_abuse_of_authority_allegation=Ethnicity t:substantiated_number=0 t:exonerated_number=0 t:unfounded_number=15 t:unsubstantiated_number=25 t:officer_unidentified_number=1 m:miscellaneous=0 m:unfounded_rate=36.6 m:officer_unidentified_rate=2.4 m:miscellaneous_rate=0 m:sunstantiated_rate=0 m:unsubstantiated_rate=61 m:exonerated_rate=0

series e:g7ee-832z d:2009-01-01T00:00:00.000Z t:type_of_abuse_of_authority_allegation=Religion t:substantiated_number=0 t:exonerated_number=0 t:unfounded_number=1 t:unsubstantiated_number=2 t:officer_unidentified_number=0 m:miscellaneous=0 m:unfounded_rate=33.3 m:officer_unidentified_rate=0 m:miscellaneous_rate=0 m:sunstantiated_rate=0 m:unsubstantiated_rate=66.7 m:exonerated_rate=0

Meta Commands

metric m:sunstantiated_rate p:float l:"Sunstantiated rate" t:dataTypeName=percent

metric m:exonerated_rate p:float l:"Exonerated rate" t:dataTypeName=percent

metric m:unsubstantiated_rate p:float l:"Unsubstantiated rate" t:dataTypeName=percent

metric m:unfounded_rate p:float l:"Unfounded rate" t:dataTypeName=percent

metric m:officer_unidentified_rate p:float l:"Officer Unidentified rate" t:dataTypeName=percent

metric m:miscellaneous p:integer l:Miscellaneous t:dataTypeName=number

metric m:miscellaneous_rate p:float l:"Miscellaneous rate" t:dataTypeName=percent

entity e:g7ee-832z l:"Disposition Of Offensive Language Allegations 2009" t:attribution="Civilian Complaint Review Board (CCRB)" t:url=https://data.cityofnewyork.us/api/views/g7ee-832z

property e:g7ee-832z t:meta.view v:id=g7ee-832z v:category="Public Safety" v:averageRating=0 v:name="Disposition Of Offensive Language Allegations 2009" v:attribution="Civilian Complaint Review Board (CCRB)"

property e:g7ee-832z t:meta.view.owner v:id=5fuc-pqz2 v:screenName="NYC OpenData" v:lastNotificationSeenAt=1491336998 v:displayName="NYC OpenData"

property e:g7ee-832z t:meta.view.tableauthor v:id=5fuc-pqz2 v:screenName="NYC OpenData" v:roleName=administrator v:lastNotificationSeenAt=1491336998 v:displayName="NYC OpenData"

Top Records

| type_of_abuse_of_authority_allegation | substantiated_number | sunstantiated_rate | exonerated_number | exonerated_rate | unsubstantiated_number | unsubstantiated_rate | unfounded_number | unfounded_rate | officer_unidentified_number | officer_unidentified_rate | miscellaneous | miscellaneous_rate | 
| ===================================== | ==================== | ================== | ================= | =============== | ====================== | ==================== | ================ | ============== | =========================== | ========================= | ============= | ================== | 
| Race                                  | 1                    | 0.70               | 0                 | 0.00            | 70                     | 51.50                | 44               | 32.40          | 16                          | 11.80                     | 5             | 3.70               | 
| Ethnicity                             | 0                    | 0.00               | 0                 | 0.00            | 25                     | 61.00                | 15               | 36.60          | 1                           | 2.40                      | 0             | 0.00               | 
| Religion                              | 0                    | 0.00               | 0                 | 0.00            | 2                      | 66.70                | 1                | 33.30          | 0                           | 0.00                      | 0             | 0.00               | 
| Sex                                   | 1                    | 2.70               | 0                 | 0.00            | 23                     | 62.20                | 12               | 32.40          | 1                           | 2.70                      | 0             | 0.00               | 
| Physical disability                   | 0                    | 0.00               | 0                 | 0.00            | 2                      | 100.00               | 0                | 0.00           | 0                           | 0.00                      | 0             | 0.00               | 
| Sexual orientation                    | 1                    | 2.90               | 0                 | 0.00            | 21                     | 60.00                | 8                | 22.90          | 4                           | 11.40                     | 1             | 2.90               | 
| Other                                 | 0                    | 0.00               | 0                 | 0.00            | 2                      | 66.70                | 1                | 33.30          | 0                           | 0.00                      | 0             | 0.00               | 
| Total                                 | 3                    | 1.20               | 0                 | 0.00            | 145                    | 56.40                | 81               | 31.50          | 22                          | 8.60                      | 6             | 2.30               |