Data DNA is your monthly learning and development appointment with yourself and hundreds of passionate data people. For free!
Join us every month to work with a given data set and create better, more effective data visualizations, analysis and help us make information more accessible.
The Data DNA community comes together every month from around the globe and we would love for YOU to become part of it, too.
A winning entry will be chosen based on best visualization and successfully following the entry rules – winning a £50 Amazon voucher code and a Hard Copy of the Book Becoming A Data Head By Jordan Goldmeier!
The top 5 entries will also receive 2 data books from our sponsors Packt!
Randomly generated persistent ID for each arrest
Exact date of arrest for the reported event
Date & Time
Three digit internal classification code (more granular than Key Code)
Description of internal classification corresponding with PD code (more granular than Offense Description)
Three digit internal classification code (more general category than PD code)
Description of internal classification corresponding with KY code (more general category than PD description)
Law code charges corresponding to the NYS Penal Law, VTL and other various local laws
Level of offense: felony, misdemeanor, violation
Borough of arrest. B(Bronx), S(Staten Island), K(Brooklyn), M(Manhattan), Q(Queens)
Precinct where the arrest occurred
Jurisdiction responsible for arrest. Jurisdiction codes 0(Patrol), 1(Transit) and 2(Housing) represent NYPD whilst codes 3 and more represent non NYPD jurisdictions
Perpetrator’s age within a category
Perpetrator’s sex description
Perpetrator’s race description
Midblock X-coordinate for New York State Plane Coordinate System, Long Island Zone, NAD 83, units feet (FIPS 3104)
Midblock Y-coordinate for New York State Plane Coordinate System, Long Island Zone, NAD 83, units feet (FIPS 3104)
Latitude coordinate for Global Coordinate System, WGS 1984, decimal degrees (EPSG 4326)
Longitude coordinate for Global Coordinate System, WGS 1984, decimal degrees (EPSG 4326)
|New Georeferenced Column|
Welcome to the Microsoft Power BI – UK November 2021 Data DNA – Dataset Challenge!
This month we will be visualizing the NYPD Arrest Data (Year To Date)
This month’s winning visualization is by –