ABP8ChVL

1CREATE KEYSPACE IF NOT EXISTS mykeyspace WITH REPLICATION = { 'class' : 'SimpleStrategy', 'replication_factor' : 1 };
2USE mykeyspace;
3CREATE TABLE IF NOT EXISTS air_quality_data (sensor_id text,time timestamp,location text, co_ppm int,PRIMARY KEY (sensor_id, time));
4INSERT INTO air_quality_data(sensor_id, time, location, co_ppm) VALUES ('my_home', '2018-06-05 07:01:00', 'ISR', 17);
5INSERT INTO air_quality_data(sensor_id, time, location, co_ppm) VALUES ('my_home', '2018-06-06 07:02:01', 'ISR', 18);
6INSERT INTO air_quality_data(sensor_id, time, location, co_ppm) VALUES ('my_home', '2018-06-07 07:03:02', 'ISR', 19);
7INSERT INTO air_quality_data(sensor_id, time, location, co_ppm) VALUES ('my_home', '2018-06-08 07:04:03', 'ISR', 20);
8INSERT INTO air_quality_data(sensor_id, time, location, co_ppm) VALUES ('my_home', '2018-06-09 07:05:04', 'ISR', 30);
9INSERT INTO air_quality_data(sensor_id, time, location, co_ppm) VALUES ('my_home', '2018-06-10 07:06:04', 'ISR', 31);
10INSERT INTO air_quality_data(sensor_id, time, location, co_ppm) VALUES ('my_home', '2018-06-11 07:07:10', 'ISR', 20);
11INSERT INTO air_quality_data(sensor_id, time, location, co_ppm) VALUES ('my_home', '2018-06-12 07:01:00', 'ISR', 17);
12INSERT INTO air_quality_data(sensor_id, time, location, co_ppm) VALUES ('my_home', '2018-06-13 07:02:01', 'ISR', 18);
13INSERT INTO air_quality_data(sensor_id, time, location, co_ppm) VALUES ('my_home', '2018-06-14 07:03:02', 'ISR', 19);
14INSERT INTO air_quality_data(sensor_id, time, location, co_ppm) VALUES ('my_home', '2018-06-15 07:04:03', 'ISR', 25);
15INSERT INTO air_quality_data(sensor_id, time, location, co_ppm) VALUES ('my_home', '2018-06-16 07:05:04', 'ISR', 30);
16INSERT INTO air_quality_data(sensor_id, time, location, co_ppm) VALUES ('my_home', '2018-06-17 07:06:04', 'ISR', 31);
17INSERT INTO air_quality_data(sensor_id, time, location, co_ppm) VALUES ('my_home', '2018-06-18 07:07:10', 'ISR', 25);
18INSERT INTO air_quality_data(sensor_id, time, location, co_ppm) VALUES ('my_home', '2018-06-19 07:01:00', 'ISR', 17);
19INSERT INTO air_quality_data(sensor_id, time, location, co_ppm) VALUES ('my_home', '2018-06-20 07:02:01', 'ISR', 18);
20INSERT INTO air_quality_data(sensor_id, time, location, co_ppm) VALUES ('my_home', '2018-06-21 07:03:02', 'ISR', 15);
21INSERT INTO air_quality_data(sensor_id, time, location, co_ppm) VALUES ('my_home', '2018-06-22 07:04:03', 'ISR', 20);
22INSERT INTO air_quality_data(sensor_id, time, location, co_ppm) VALUES ('my_home', '2018-06-23 07:05:04', 'ISR', 30);
23INSERT INTO air_quality_data(sensor_id, time, location, co_ppm) VALUES ('my_home', '2018-06-24 07:06:04', 'ISR', 31);
24INSERT INTO air_quality_data(sensor_id, time, location, co_ppm) VALUES ('my_home', '2018-06-25 07:07:10', 'ISR', 20);
25INSERT INTO air_quality_data(sensor_id, time, location, co_ppm) VALUES ('my_home', '2018-06-26 07:01:00', 'ISR', 27);
26INSERT INTO air_quality_data(sensor_id, time, location, co_ppm) VALUES ('my_home', '2018-06-27 07:02:01', 'ISR', 14);
27INSERT INTO air_quality_data(sensor_id, time, location, co_ppm) VALUES ('my_home', '2018-06-28 07:03:02', 'ISR', 29);
28INSERT INTO air_quality_data(sensor_id, time, location, co_ppm) VALUES ('my_home', '2018-06-29 07:04:03', 'ISR', 20);
29INSERT INTO air_quality_data(sensor_id, time, location, co_ppm) VALUES ('my_home', '2018-06-30 07:05:04', 'ISR', 11);
30INSERT INTO air_quality_data(sensor_id, time, location, co_ppm) VALUES ('your_home', '2018-06-05 07:01:00', 'USA', 30);
31INSERT INTO air_quality_data(sensor_id, time, location, co_ppm) VALUES ('your_home', '2018-06-06 07:02:01', 'USA', 31);
32INSERT INTO air_quality_data(sensor_id, time, location, co_ppm) VALUES ('your_home', '2018-06-07 07:03:02', 'USA', 32);
33INSERT INTO air_quality_data(sensor_id, time, location, co_ppm) VALUES ('your_home', '2018-06-08 07:04:03', 'USA', 44);
34INSERT INTO air_quality_data(sensor_id, time, location, co_ppm) VALUES ('your_home', '2018-06-09 07:05:04', 'USA', 70);
35INSERT INTO air_quality_data(sensor_id, time, location, co_ppm) VALUES ('your_home', '2018-06-10 07:06:10', 'USA', 80);
36INSERT INTO air_quality_data(sensor_id, time, location, co_ppm) VALUES ('your_home', '2018-06-11 07:07:11', 'USA', 90);
37INSERT INTO air_quality_data(sensor_id, time, location, co_ppm) VALUES ('your_home', '2018-06-12 07:01:00', 'USA', 37);
38INSERT INTO air_quality_data(sensor_id, time, location, co_ppm) VALUES ('your_home', '2018-06-13 07:02:01', 'USA', 38);
39INSERT INTO air_quality_data(sensor_id, time, location, co_ppm) VALUES ('your_home', '2018-06-14 07:03:02', 'USA', 32);
40INSERT INTO air_quality_data(sensor_id, time, location, co_ppm) VALUES ('your_home', '2018-06-15 07:04:03', 'USA', 35);
41INSERT INTO air_quality_data(sensor_id, time, location, co_ppm) VALUES ('your_home', '2018-06-16 07:05:04', 'USA', 42);
42INSERT INTO air_quality_data(sensor_id, time, location, co_ppm) VALUES ('your_home', '2018-06-17 07:06:04', 'USA', 41);
43INSERT INTO air_quality_data(sensor_id, time, location, co_ppm) VALUES ('your_home', '2018-06-18 07:07:10', 'USA', 35);
44INSERT INTO air_quality_data(sensor_id, time, location, co_ppm) VALUES ('your_home', '2018-06-19 07:01:00', 'USA', 47);
45INSERT INTO air_quality_data(sensor_id, time, location, co_ppm) VALUES ('your_home', '2018-06-20 07:02:01', 'USA', 42);
46INSERT INTO air_quality_data(sensor_id, time, location, co_ppm) VALUES ('your_home', '2018-06-21 07:03:02', 'USA', 35);
47INSERT INTO air_quality_data(sensor_id, time, location, co_ppm) VALUES ('your_home', '2018-06-22 07:04:03', 'USA', 40);
48INSERT INTO air_quality_data(sensor_id, time, location, co_ppm) VALUES ('your_home', '2018-06-23 07:05:04', 'USA', 33);
49INSERT INTO air_quality_data(sensor_id, time, location, co_ppm) VALUES ('your_home', '2018-06-24 07:06:04', 'USA', 41);
50INSERT INTO air_quality_data(sensor_id, time, location, co_ppm) VALUES ('your_home', '2018-06-25 07:07:10', 'USA', 30);
51INSERT INTO air_quality_data(sensor_id, time, location, co_ppm) VALUES ('your_home', '2018-06-26 07:01:00', 'USA', 44);
52INSERT INTO air_quality_data(sensor_id, time, location, co_ppm) VALUES ('your_home', '2018-06-27 07:02:01', 'USA', 34);
53INSERT INTO air_quality_data(sensor_id, time, location, co_ppm) VALUES ('your_home', '2018-06-28 07:03:02', 'USA', 39);
54INSERT INTO air_quality_data(sensor_id, time, location, co_ppm) VALUES ('your_home', '2018-06-29 07:04:03', 'USA', 44);
55INSERT INTO air_quality_data(sensor_id, time, location, co_ppm) VALUES ('your_home', '2018-06-30 07:05:04', 'USA', 34);