RandomFractals / chicago-crimes

Exploring Chicago crimes dataset with Jupyter notebooks, DuckDB, Malloy and new Panel/PyScript data and dashboard tools.
GNU Affero General Public License v3.0
38 stars 4 forks source link

Add Malloy DuckDB parquet data loading and queries example #24

Closed RandomFractals closed 1 year ago

RandomFractals commented 1 year ago

Use smaller 2022 crimes dataset added in #22

Malloy docs: https://looker-open-source.github.io/malloy/documentation/language/basic.html

MalloyData VSCode extension in VS Marketplace:

https://marketplace.visualstudio.com/items?itemName=malloydata.malloy-vscode

MalloyData home on github: https://github.com/malloydata

RandomFractals commented 1 year ago

Quick data loading and queries example using duckdb and parquet data file:

chicago-crimes-parquet-duckdb-malloy-2022

RandomFractals commented 1 year ago

2022 crime reports by primary type:

chicago-crime-reports-by-type-2022

RandomFractals commented 1 year ago

Crime reports summary by crime type and description:

chicago-crimes-by-type-and-description-2022

RandomFractals commented 1 year ago

Updated crimes data and summary by reported crime location description:

chicago-crimes-by-location-summary-2022

RandomFractals commented 1 year ago

Updated Malloy script with named queries and query outline display for docs:

chicago-crimes-duckdb-malloy-2022

RandomFractals commented 1 year ago

see new With Malloy data section in docs: https://github.com/RandomFractals/chicago-crimes#with-malloy-data

RandomFractals commented 1 year ago

Crimes by primary type with nested description summary query results example:

chicago-crimes-with-nested-description-summary