Data on the Los Angeles Open Data Portal

Getting Started

  1. Navigate to the LA Open Data Portal (


3. Click the magnifying glass: dp_image1

4. Find the “arrest data set” by typing “arrest” in the search tool dp_image2

5. In the results page, click on “Arrest Data from 2010 to Present” dp_image3

Viewing Data

  1. In the Data set page, you can view information about the data, such as column names, source of the data, etc.

7. After familiarizing yourself with the data set, click on “View Data” dp_image4

8. You can scroll through the data columns or records dp_image5

Filtering the data set by date

  1. Under “Filter” click the initial filter column

10. Choose “Arrest Date” as the column to filter by dp_image6

  1. Next click on “is” and change the filter condition to “is after”


12. Choose after “2016” dp_image8

Visualizing the data

  1. Click on “Visualize”

14. Choose whether to “sign in” and save your visualization, or continue without being able to save. Note you can| summer2019!

15. Click on “Select Column” to select a column to visualize. dp_image9

16. Select “Descent Code” to start visualizing the data. dp_image10

17. You can scroll down and group the data by other values, for example, “Descent Code by Sex” dp_image11

18. You can switch the visualization by clicking on one of the buttons on the right dp_image12

19. The green circle shows a recommended visualization dp_image13

Mapping our data

20. We will choose map, which is the globe to the right: dp_image14

21. To find Los Angeles, click the search icon in the map and type in “Los Angeles” dp_image15

22. This is our data, but we can scroll down for more options: dp_image16

  1. Let’s “Style by Value” to change how our points look.


24. We will choose “Sex Code” dp_image18

  1. White points are clustered points:


Summarizing our Map Points

26. Scroll down to “Point Aggregation” dp_image20

27. Select “Region Map” dp_image21

28. Choose “Zip Codes” dp_image22

29. Zoom back to Los Angeles again, by either searching “Los Angeles” or moving the map to there, now you can see our data by Zip Code dp_image23

Save the Visualization

30. If you have created a Socrata Account, you can save the Visulization by clicking at the bottom, “Save Draft” dp_image24

31. Give it a name and click save dp_image25

32. You can now “Publish” the visualization and share it via html link. Note, you cannot save your visualization as a static image or page.

Downloading the entire data

Return back to the page with the data by clicking on the X or “Back to Data Set” dp_image26

  1. Click on the “Export” button


  1. We will choose to download the data as “CSV” which is the simplest data type:

Download filtered Data

  1. Go back to “View Data” to open the Socrata data page for the arrest dataset:
  1. Click on “Filter” to filter the data:

37. Let’s only get data for 2017 to 2018, click on “Age”(1) and then choose “Arrest Date” (2):

  1. Next, select “is” (1) and choose “is between” (2):
  1. Choose the dates on the calendar (or type in “01/01/2017” and “01/01/2018”) :
  1. Click on “Export”
  1. Choose “CSV”
  1. Congratulations! You can now work with the data in other applications!