ToolsBlog

Querying the LA Crime Database with GPT-4

Try it free:CSV AIData Profiler

Table of Contents

  • Top 10 Crimes Breakdown
  • Top 5 Most Common Ages of Victims
  • Street with the Highest Crime Rates
  • Conclusion

One of the biggest hurdles in data-driven decision-making is the need for SQL knowledge. Our mission at ChatDB is to simplify that process, making it accessible to everyone, regardless of their technical skills.

Let's take an open source dataset, LA Crimes Dataset, and connect it to ChatDB so we can understand the data!

Top 10 Crimes Breakdown #

Our first query aimed to understand the most common types of crimes in LA. ChatDB simplified what would have been complex SQL queries into a simple question: "What are the top 10 most common crimes in LA?"

10 Crimes Breakdown Table

The data clearly shows that stolen vehicles rank as the most frequent crime. And the best part? You can visualize this data through various lenses, whether it’s a table, pie chart, or bar chart.

10 Crimes Breakdown Pie Chart

If pie charts aren't your thing, ChatDB also lets you switch to a more conventional bar chart to better compare the frequency of these crimes side-by-side.

10 Crimes Breakdown Bar Chart

Top 5 Most Common Ages of Victims #

Understanding the demographics of crime victims can be incredibly valuable for targeted community support. By asking ChatDB, "What are the most common ages of crime victims?", we found that apart from the default value of 0, the late 20s and early 30s are the most vulnerable ages.

5 Victim ages

Street with the Highest Crime Rates #

To better understand crime distribution, we queried, "Which street has the highest crime rate in LA?" The result? 800 N Alameda St has the most recorded crimes.

We can also view the SQL code it used to find the answer

Highest crime rate street

Conclusion #

Here at ChatDB, we are committed to breaking down the barriers between you and your data. No SQL, no problem. With natural language querying and custom dashboards, the Los Angeles Crime Database became an open book, and the same can happen for your databases too.

For more updates, stay tuned, and let us know what other databases you’d like us to explore next!

Try the tools from this post

Free and private: your files stay in your browser.

  • CSV AIGet insights from your CSV files using natural language.
  • Data ProfilerProfile CSV, Parquet, or JSON files with column stats and distributions.

Related posts

Analyzing Your Customer's Data with ChatDB

Analyze your customer's data with no SQL required.

2023-10-23

CSV AI: Querying CSV files with AI and natural language

We are proud to introduce a new, free tool where you can query your CSV with AI.

2024-05-01

Introducing ChatDB Dashboards

We are proud to announce charts and MySQL support!

2024-01-28

ChatDB

Free, browser-side data tools. No uploads, no accounts.

Data tools

Reader

  • Online CSV Viewer
  • Parquet Viewer & Reader
  • Excel Viewer and Editor
  • SQLite Viewer
  • Gzip CSV Reader
  • CSV Size Analyzer
  • Parquet Schema Reader
  • Parquet Metadata Reader
  • Data Profiler
  • Image Measure
  • Shapefile Viewer
  • GeoJSON Viewer

Editor

  • CSV Viewer and Editor
  • Excel Viewer and Editor
  • Online Excel Editor
  • CSV Splitter
  • Markdown Editor
  • Image Cropper
  • SVG Editor
  • Screenshot Background Creator
  • Document Scanner
  • Audio Clipper
  • Video Trim & Crop Tool

Converter

  • CSV to Gzip Converter
  • CSV to Parquet Converter
  • Excel to CSV Converter
  • Parquet to CSV Converter
  • JSON to Parquet Converter
  • Parquet to JSON Converter
  • CSV Decompressor
  • CSV to JSON Converter
  • CSV to Markdown Table
  • Image Converter
  • KML to GeoJSON Converter
  • GPX to GeoJSON Converter
  • GeoJSON to KML Converter
  • Shapefile to GeoJSON Converter

Formatter

  • CSV Encoder
  • SQL Formatter
  • JSON Formatter
  • XML Formatter
  • YAML Formatter
  • Dataset README Generator
  • URL Encoder & Decoder
  • Regex Tester

Compressor

  • CSV Compressor
  • CSV to Gzip Converter
  • CSV Decompressor
  • Image Compressor

AI

  • Parquet AI
  • CSV AI
  • Color Palette Generator
  • Extract Image Colors

GIS

  • Lat/Lng Point Finder
  • KML to GeoJSON Converter
  • GPX to GeoJSON Converter
  • GeoJSON to KML Converter
  • Shapefile to GeoJSON Converter
  • Shapefile Viewer
  • GeoJSON Viewer

Image tools

Convert To

  • Convert to JPEG
  • Convert to PNG
  • Convert to WEBP
  • Convert to GIF
  • Convert to BMP
  • Convert to TIFF
  • Convert to ICO
  • Convert to AVIF
  • Convert to FF
  • Convert to HDR
  • Convert to EXR
  • Convert to QOI
  • Convert to TGA
  • Convert to PNM

Edit

  • Image Cropper
  • SVG Editor
  • Screenshot Background Creator
  • Document Scanner

Compress

  • Compress JPG
  • Compress JPEG
  • Compress PNG
  • Compress WEBP
  • Compress GIF

Company

  • All tools
  • Blog
  • Privacy Policy
  • Terms of Service

© 2026 ChatDB. All rights reserved.

v2.4.1