search

CS-505 / cs505-web-api

COVID-19 Tracking API
1 stars 0 forks source link

Setup Relational Database and the database model for Hospital data #1

Open shirazamin opened 4 years ago

shirazamin commented 4 years ago
  1. Docker image command for MySQL
  2. Model for hospitals
  3. Model distance.

Import the CSV files into the database.

ryanbowles commented 4 years ago

Alright currently I have a python script that will check to see if tables exist, drop them if they do. And then it builds two separate tables.

It takes a few seconds to populate the tables.

first table is zipcode_distances with columns zip_from ,zip_to ,distance second table is hospital_data with columns hospital_id ,hospital_zip ,beds