This project visualizes data of children who went missing at 18 years or younger from 2007 to 2021.
Youtube Demo
·
The Site
·
Process Blog
To skip registration, use user: [email protected] and password: password.
This project visualizes the record of children who went missing when they were 18 years or younger from 2007 to 2021. The data is generated from the NAMUS-National Missing and Unidentified Persons System with the search criteria set to search for historical records of all missing children in the US including all 52 states.
The data is supplemented with geolocation data converted by Geocodio, integrated into a Mapbox tileset and visualized with Mapbox studio. The same dataset is used to generate the Age to Year Missing Graph with Gender colour legends and built with React and D3.
Information from the NCMEC is used to supplement the information on both the map and graph by showing categories of children who are missing.
To sign up as a web sleuth, users log into the app with their email and password. Users are then able to perform advanced searches through the database. Search result data is retrieved from the backend asynchronously with AJAX. With the generated results, users are able to securely add notes, save, update and delete their searches with sessions.
- Python
- Javascript
- React
- Flask
- Jinja
- SQLalchemy
- postgreSQL
APIs
- Mapbox
- [Geocodio] (https://www.geocod.io/docs/#introduction)
- Google Charts
Front-end
- Javascript
- React
- JQuery
- AJAX
- Bootstrap
- HTML/ CSS
Working map showing first names of missing children mapped to state and city.
Increasing awareness by providing input form for users to generate a list of missing children who are currently at their age. A number of visualizations with graphs and figures.
Buttons for subscribing to Missing Children's Network and volunteering opportunities. A search bar for users to search for entries based on state and city. An account page to store user's saved searches and notes.
A community forum for web sleuths to compare notes, web scraping to get latest cases to the database, and secure login features.
You may like to use the data or view the data behind the visualizations which was accessed from NAMUS-The National Missing and Unidentified Persons System on the 3rd of April 2021, and supplemented with GPS co-ordinates.
(As of April 10, the future availabilty of this data remains undercertain due to funding cuts by the National Institute of Justice.)
To get a local copy up and running follow these simple steps.
- In your terminal type: git clone https://github.com/Debiday/The_Lost_Children.git
- Go to the folder: cd tlc
- Setup virtualenv via:
- On mac/linux run: virtualenv env
- On windows run: virtualenv env --always-copy
- Enter virtualenv: source env/bin/activate
- Install required python libraries via: pip3 install -r requirements.txt
- Set up the data and seed with data with: python3 seed.py
- Launch the web app using: python3 server.py
- To view this web app in browser simply follow this link: http://localhost:5000
Deborah Ong - @debieday - [email protected]
Project Link: https://github.com/debiday/The_Lost_Children