John Ritchey requesting csv of last 6 months for select NCs

[edwinjue]

Overview

Per JR: Any chance I could get the csvs for: Studio City, North Hollywood, Sherman Oaks, West LA, Mar Vista and Palms? Looking for the last 6 months ideally.

Action Items

• Download latest csv file from MyLA311 Service Request Data 2023: data.lacity.org https://data.lacity.org/City-Infrastructure-Service-Requests/MyLA311-Service-Request-Data-2023/4a4x-mna2
• Import into duckdb
• Extract subset of the data as per JR (in overview) and export as .csv
• Provide him with the csv file

Resources/Instructions

https://data.lacity.org/City-Infrastructure-Service-Requests/MyLA311-Service-Request-Data-2023/4a4x-mna2

[edwinjue]

Dataset used:
https://data.lacity.org/City-Infrastructure-Service-Requests/MyLA311-Service-Request-Data-2023/4a4x-mna2

List of all NCs in the dataset:
ncnames.csv

Requested data (last 6 months):
palms.csv

sherman_oaks.csv

studio_city.csv

west_la.csv

mar_vista.csv

north_hollywood.csv (includes North Hollywood Northeast and West)

[edwinjue]

Just for reference, here are the duckdb queries used to generate the extracts above: https://gist.github.com/edwinjue/35bf6b91cad008fcdb41afa203e866d3