text: CREATE DATABASE  IF NOT EXISTS `bikesdata` /*!40100 DEFAULT CHARACTER SET latin1 */;
  USE `bikesdata`;
  -- MySQL dump 10.13  Distrib 5.7.17, for Linux (x86_64)
  --
  -- Host: bikes.ciqr4q2vn3eh.us-west-2.rds.amazonaws.com    Database: bikesdata
  -- ------------------------------------------------------
  -- Server version	5.6.39-log
  
  /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
  /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
  /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
  /*!40101 SET NAMES utf8 */;
  /*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
  /*!40103 SET TIME_ZONE='+00:00' */;
  /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
  /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
  /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
  /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
  
  --
  -- Table structure for table `weather`
  --
  
  DROP TABLE IF EXISTS `weather`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!40101 SET character_set_client = utf8 */;
  CREATE TABLE `weather` (
    `timestamp` datetime NOT NULL,
    `weather_id` int(11) DEFAULT NULL,
    `main_weather` varchar(45) DEFAULT NULL,
    `description` varchar(100) DEFAULT NULL,
    `weather_icon` varchar(15) DEFAULT NULL,
    `temperature` float DEFAULT NULL,
    `humidity` int(11) DEFAULT NULL,
    `pressure` int(11) DEFAULT NULL,
    `temp_min` float DEFAULT NULL,
    `temp_max` float DEFAULT NULL,
    `wind_speed` float DEFAULT NULL,
    `wind_dir` int(11) DEFAULT NULL,
    `cloud_cover` int(11) DEFAULT NULL,
    PRIMARY KEY (`timestamp`)
  ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Dumping data for table `weather`
  --
  
  LOCK TABLES `weather` WRITE;
  /*!40000 ALTER TABLE `weather` DISABLE KEYS */;
  INSERT INTO `weather` VALUES ('2018-04-06 00:00:00',500,'Rain','light rain','10n',280.37,97,1017,280.37,280.433,13.46,149,92),('2018-04-06 12:00:00',500,'Rain','light rain','10d',281.08,93,1009,281.08,281.188,13.83,158,92),('2018-04-06 15:00:00',500,'Rain','light rain','10d',282.3,85,1008,282.3,282.375,11.02,176,20),('2018-04-06 18:00:00',800,'Clear','clear sky','02d',282.31,86,1009,282.31,282.352,10.16,185,8),('2018-04-06 21:00:00',500,'Rain','light rain','10n',281.818,89,1011,281.818,281.818,9.08,189,8),('2018-04-07 00:00:00',800,'Clear','clear sky','01n',281.486,91,1012,281.486,281.486,7.2,195,0),('2018-04-07 03:00:00',803,'Clouds','broken clouds','04n',281.117,93,1013,281.117,281.117,4.33,186,76),('2018-04-07 06:00:00',803,'Clouds','broken clouds','04d',280.645,95,1013,280.645,280.645,2.78,163,64),('2018-04-07 09:00:00',500,'Rain','light rain','10d',281.142,93,1014,281.142,281.142,2.33,149,68),('2018-04-07 12:00:00',801,'Clouds','few clouds','02d',281.914,93,1015,281.914,281.914,2.13,137,24),('2018-04-07 15:00:00',500,'Rain','light rain','10d',281.883,93,1015,281.883,281.883,3.54,138,24),('2018-04-07 18:00:00',500,'Rain','light rain','10d',281.917,93,1015,281.917,281.917,3.11,162,36),('2018-04-07 21:00:00',803,'Clouds','broken clouds','04n',281.694,91,1015,281.694,281.694,2.8,175,80),('2018-04-08 00:00:00',803,'Clouds','broken clouds','04n',281.232,93,1015,281.232,281.232,2.57,196,68),('2018-04-08 03:00:00',500,'Rain','light rain','10n',280.903,95,1015,280.903,280.903,2.28,233,32),('2018-04-08 06:00:00',802,'Clouds','scattered clouds','03d',280.676,96,1015,280.676,280.676,1.46,247,44),('2018-04-08 09:00:00',800,'Clear','clear sky','01d',281.394,93,1015,281.394,281.394,0.77,277,0),('2018-04-08 12:00:00',500,'Rain','light rain','10d',281.783,94,1016,281.783,281.783,1.76,60,12),('2018-04-08 15:00:00',500,'Rain','light rain','10d',281.729,97,1016,281.729,281.729,1.15,114,12),('2018-04-08 18:00:00',500,'Rain','light rain','10d',282.055,94,1017,282.055,282.055,0.62,146,0),('2018-04-08 21:00:00',800,'Clear','clear sky','01n',281.168,95,1018,281.168,281.168,2.01,152,0),('2018-04-09 00:00:00',800,'Clear','clear sky','01n',281.171,95,1018,281.171,281.171,2.75,200,0),('2018-04-09 03:00:00',800,'Clear','clear sky','01n',280.767,96,1018,280.767,280.767,1.81,214,0),('2018-04-09 06:00:00',800,'Clear','clear sky','01d',280.434,98,1017,280.434,280.434,2.31,226,0),('2018-04-09 09:00:00',801,'Clouds','few clouds','02d',281.634,95,1017,281.634,281.634,1.72,236,24),('2018-04-09 12:00:00',500,'Rain','light rain','10d',282.185,94,1015,282.185,282.185,1.76,120,56),('2018-04-09 15:00:00',500,'Rain','light rain','10d',281.745,97,1012,281.745,281.745,5.71,138,32),('2018-04-09 18:00:00',802,'Clouds','scattered clouds','03d',281.215,97,1010,281.215,281.215,4.91,127,32),('2018-04-09 21:00:00',802,'Clouds','scattered clouds','03n',280.429,99,1010,280.429,280.429,3.67,100,44),('2018-04-10 00:00:00',500,'Rain','light rain','10n',280.917,97,1009,280.917,280.917,6.01,72,88),('2018-04-10 03:00:00',500,'Rain','light rain','10n',280.623,99,1008,280.623,280.623,7.25,55,92),('2018-04-10 06:00:00',500,'Rain','light rain','10d',280.555,98,1010,280.555,280.555,7.71,47,92),('2018-04-10 09:00:00',500,'Rain','light rain','10d',280.605,98,1012,280.605,280.605,7.8,39,68),('2018-04-10 12:00:00',500,'Rain','light rain','10d',280.8,97,1013,280.8,280.8,6.06,29,76),('2018-04-10 15:00:00',500,'Rain','light rain','10d',280.856,97,1014,280.856,280.856,6.11,18,80),('2018-04-10 18:00:00',500,'Rain','light rain','10d',281.289,95,1015,281.289,281.289,6.37,10,56),('2018-04-10 21:00:00',500,'Rain','light rain','10n',280.446,99,1023,280.446,280.446,10.46,57,92),('2018-04-11 00:00:00',500,'Rain','light rain','10n',280.896,97,1016,280.896,280.896,3.86,329,92),('2018-04-11 03:00:00',500,'Rain','light rain','10n',280.829,97,1016,280.829,280.829,2.76,319,76),('2018-04-11 06:00:00',500,'Rain','light rain','10d',280.655,98,1015,280.655,280.655,2.12,316,92),('2018-04-11 09:00:00',500,'Rain','light rain','10d',281.189,98,1016,281.189,281.189,1.06,280,88),('2018-04-11 12:00:00',500,'Rain','light rain','10d',281.813,96,1015,281.813,281.813,0.76,128,32),('2018-04-11 15:00:00',500,'Rain','light rain','10d',282.209,94,1014,282.209,282.209,3.06,119,8),('2018-04-11 18:00:00',801,'Clouds','few clouds','02d',282.302,92,1013,282.302,282.302,4.06,138,24),('2018-04-11 21:00:00',800,'Clear','clear sky','01n',281.897,93,1013,281.897,281.897,3.6,159,0),('2018-04-12 06:00:00',500,'Rain','light rain','10d',279.252,100,1017,279.252,279.252,7.44,59,92),('2018-04-12 09:00:00',500,'Rain','light rain','10d',279.538,100,1016,279.538,279.538,6.29,53,92),('2018-04-12 12:00:00',500,'Rain','light rain','10d',279.839,100,1016,279.839,279.839,4.77,52,92),('2018-04-12 15:00:00',500,'Rain','light rain','10d',280.131,100,1015,280.131,280.131,3.39,55,48),('2018-04-12 18:00:00',801,'Clouds','few clouds','02d',280.112,100,1015,280.112,280.112,2.81,58,24),('2018-04-12 21:00:00',801,'Clouds','few clouds','02n',279.525,100,1015,279.525,279.525,2.1,12,12),('2018-04-13 06:00:00',801,'Clouds','few clouds','02d',280.047,100,1016,280.047,280.047,3.95,40,24),('2018-04-13 09:00:00',803,'Clouds','broken clouds','04d',280.501,99,1016,280.501,280.501,3.53,22,76),('2018-04-13 12:00:00',500,'Rain','light rain','10d',280.409,100,1016,280.409,280.409,3.58,24,92),('2018-04-13 15:00:00',500,'Rain','light rain','10d',280.623,100,1016,280.623,280.623,1.86,11,92),('2018-04-13 18:00:00',500,'Rain','light rain','10d',280.983,98,1016,280.983,280.983,0.7,174,64),('2018-04-13 21:00:00',800,'Clear','clear sky','01n',280.419,100,1017,280.419,280.419,3.42,167,0),('2018-04-14 06:00:00',500,'Rain','light rain','10d',279.735,100,1015,279.735,279.735,1.41,229,68),('2018-04-14 09:00:00',500,'Rain','light rain','10d',281.038,99,1014,281.038,281.038,2.91,175,24),('2018-04-14 12:00:00',500,'Rain','light rain','10d',282.184,92,1014,282.184,282.184,5.46,168,0),('2018-04-14 15:00:00',500,'Rain','light rain','10d',282.529,90,1012,282.529,282.529,8.21,170,0),('2018-04-14 18:00:00',500,'Rain','light rain','10d',282.011,92,1011,282.011,282.011,8.56,161,68),('2018-04-14 21:00:00',500,'Rain','light rain','10n',281.919,92,1010,281.919,281.919,9.66,154,92),('2018-04-15 06:00:00',500,'Rain','light rain','10d',280.994,99,1019,280.994,280.994,6.41,76,92),('2018-04-15 09:00:00',500,'Rain','light rain','10d',281.3,97,1018,281.3,281.3,7.86,76,68);
  /*!40000 ALTER TABLE `weather` ENABLE KEYS */;
  UNLOCK TABLES;
  /*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
  
  /*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
  /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
  /*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
  /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
  /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
  /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
  /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
  
  -- Dump completed on 2018-04-11 12:13:46
  