🚓 SecureCheck: A Python-SQL Digital Ledger for Police Post

SecureCheck is a Data Science mini project that analyzes traffic stop data using Python, PostgreSQL, and Streamlit. It delivers SQL-powered insights through a clean and interactive dashboard. Ideal for those learning SQL integration with Python.

---

🔧 Tools Used

---

📁 Project Structure

Project_1-Secure_Check/
├── 📁 app/
│   └── main_app.py                # Streamlit app with SQL queries
├── 📁 data/
│   └── cleaned_traffic_stop.csv   # Cleaned dataset
├── 📁 notebooks/
│   └── Mini_project_1(Secure_Check).ipynb   # Data cleaning in Colab
├── 📁 video/
│   └── project_demo.mp4           # Project demonstration video
├── .gitignore
├── requirements.txt               # Python dependencies
└── README.txt                     # Project documentation

---

🚀 How to Run

1. Clone the repo
   git clone https://github.com/Infant-Joshva/Project_1-Secure_Check.git

2. Navigate to the app folder
   cd Project_1-Secure_Check/app

3. Install required packages
   pip install -r ../requirements.txt

4. Update your PostgreSQL connection string in main_app.py

5. Run the Streamlit app
   streamlit run main_app.py

---

📊 Features

• Store and query traffic stop data using PostgreSQL
• 20+ SQL queries (simple to advanced)
• Interactive dashboard with dropdown filters
• Clean UI built with Streamlit

---

---

📷 Screenshots

---

🎥 Demo

▶️ Watch the project in action: video/project_demo.mp4

---

📚 Sample SQL Insights

• Top 10 drug-related vehicles
• Most searched violations
• Arrest rate by age group
• Night-time vs day-time stops
• Year-wise arrest breakdown (using window functions)
• Driver demographics by country

---

👤 Author

Infant Joshva
📧 [email protected]
🐙 GitHub
🔗 LinkedIn

---

⭐ Give a Star!

If you found this project helpful, please give it a ⭐ on GitHub!