-
Notifications
You must be signed in to change notification settings - Fork 0
/
dc11.10.sql
785 lines (755 loc) · 60 KB
/
dc11.10.sql
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
309
310
311
312
313
314
315
316
317
318
319
320
321
322
323
324
325
326
327
328
329
330
331
332
333
334
335
336
337
338
339
340
341
342
343
344
345
346
347
348
349
350
351
352
353
354
355
356
357
358
359
360
361
362
363
364
365
366
367
368
369
370
371
372
373
374
375
376
377
378
379
380
381
382
383
384
385
386
387
388
389
390
391
392
393
394
395
396
397
398
399
400
401
402
403
404
405
406
407
408
409
410
411
412
413
414
415
416
417
418
419
420
421
422
423
424
425
426
427
428
429
430
431
432
433
434
435
436
437
438
439
440
441
442
443
444
445
446
447
448
449
450
451
452
453
454
455
456
457
458
459
460
461
462
463
464
465
466
467
468
469
470
471
472
473
474
475
476
477
478
479
480
481
482
483
484
485
486
487
488
489
490
491
492
493
494
495
496
497
498
499
500
501
502
503
504
505
506
507
508
509
510
511
512
513
514
515
516
517
518
519
520
521
522
523
524
525
526
527
528
529
530
531
532
533
534
535
536
537
538
539
540
541
542
543
544
545
546
547
548
549
550
551
552
553
554
555
556
557
558
559
560
561
562
563
564
565
566
567
568
569
570
571
572
573
574
575
576
577
578
579
580
581
582
583
584
585
586
587
588
589
590
591
592
593
594
595
596
597
598
599
600
601
602
603
604
605
606
607
608
609
610
611
612
613
614
615
616
617
618
619
620
621
622
623
624
625
626
627
628
629
630
631
632
633
634
635
636
637
638
639
640
641
642
643
644
645
646
647
648
649
650
651
652
653
654
655
656
657
658
659
660
661
662
663
664
665
666
667
668
669
670
671
672
673
674
675
676
677
678
679
680
681
682
683
684
685
686
687
688
689
690
691
692
693
694
695
696
697
698
699
700
701
702
703
704
705
706
707
708
709
710
711
712
713
714
715
716
717
718
719
720
721
722
723
724
725
726
727
728
729
730
731
732
733
734
735
736
737
738
739
740
741
742
743
744
745
746
747
748
749
750
751
752
753
754
755
756
757
758
759
760
761
762
763
764
765
766
767
768
769
770
771
772
773
774
775
776
777
778
779
780
781
782
783
784
785
-- --------------------------------------------------------
-- Host: 127.0.0.1
-- Server version: 5.1.71-community - MySQL Community Server (GPL)
-- Server OS: Win32
-- HeidiSQL Version: 8.1.0.4545
-- --------------------------------------------------------
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET NAMES utf8 */;
/*!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' */;
-- Dumping database structure for datarepo
CREATE DATABASE IF NOT EXISTS `datarepo` /*!40100 DEFAULT CHARACTER SET latin1 */;
USE `datarepo`;
-- Dumping structure for table datarepo.api
CREATE TABLE IF NOT EXISTS `api` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`key` varchar(50) DEFAULT NULL,
`query_string` varchar(1000) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;
-- Dumping data for table datarepo.api: ~0 rows (approximately)
/*!40000 ALTER TABLE `api` DISABLE KEYS */;
INSERT INTO `api` (`id`, `key`, `query_string`) VALUES
(1, 'c4ca4238a0b923820dcc509a6f75849b', 'datasets=1,2,3&fields=576,594,594,600');
/*!40000 ALTER TABLE `api` ENABLE KEYS */;
-- Dumping structure for table datarepo.d1
CREATE TABLE IF NOT EXISTS `d1` (
`d1_id` int(11) NOT NULL AUTO_INCREMENT,
`_year` text,
`_jan` text,
`_feb` text,
`_mar` text,
`_apr` text,
`_may` text,
`_jun` text,
`_jul` text,
`_aug` text,
`_sep` text,
`_oct` text,
`_nov` text,
`_dec` text,
`_annual` text,
`_jan_feb` text,
`_march_may` text,
`_june_september` text,
`_oct_dec` text,
PRIMARY KEY (`d1_id`)
) ENGINE=InnoDB AUTO_INCREMENT=113 DEFAULT CHARSET=latin1;
-- Dumping data for table datarepo.d1: ~112 rows (approximately)
/*!40000 ALTER TABLE `d1` DISABLE KEYS */;
INSERT INTO `d1` (`d1_id`, `_year`, `_jan`, `_feb`, `_mar`, `_apr`, `_may`, `_jun`, `_jul`, `_aug`, `_sep`, `_oct`, `_nov`, `_dec`, `_annual`, `_jan_feb`, `_march_may`, `_june_september`, `_oct_dec`) VALUES
(1, '1901', '34.7', '38.6', '17.8', '38.9', '50.6', '113.2', '241.4', '271.6', '124.7', '52.4', '38.7', '8.2', '1030.8', '73.2', '107.3', '751', '99.3'),
(2, '1902', '7.4', '4.2', '19', '44.1', '48.8', '111.7', '284.9', '201', '200.2', '62.5', '29.4', '25.2', '1038.4', '11.6', '111.9', '797.8', '117.2'),
(3, '1903', '16.7', '8', '31.1', '17.1', '59.5', '120.3', '293.2', '274', '198.1', '119.5', '40.3', '18', '1195.9', '24.7', '107.7', '885.6', '177.8'),
(4, '1904', '14.9', '9.7', '31.4', '33.7', '73.8', '165.5', '260.3', '207.7', '130.8', '69.8', '11.2', '16.4', '1025.1', '24.5', '138.8', '764.3', '97.4'),
(5, '1905', '24.7', '20.3', '41.8', '33.8', '55.8', '93.7', '253', '201.7', '178.1', '54.9', '9.6', '10.1', '977.5', '45', '131.4', '726.4', '74.7'),
(6, '1906', '21.4', '49.9', '31.4', '15.8', '37.2', '177', '286.5', '251.4', '183.9', '50.6', '17.7', '26.3', '1149.2', '71.3', '84.4', '898.9', '94.6'),
(7, '1907', '16', '45.5', '37.4', '62', '32.7', '153.1', '225.4', '308.3', '95.4', '23', '23.1', '12.9', '1034.8', '61.5', '132.1', '782.2', '58.9'),
(8, '1908', '19.9', '17.1', '8.3', '31', '45.4', '125.6', '320.5', '306', '150.8', '38.4', '6.8', '7.4', '1077.4', '37', '84.7', '903', '52.7'),
(9, '1909', '22.7', '15.2', '6.6', '61.6', '51.2', '207.2', '302.3', '228.7', '157.7', '37.5', '10', '27.9', '1128.5', '37.9', '119.4', '895.7', '75.4'),
(10, '1910', '13.5', '10.3', '13.7', '29', '40.8', '211.9', '247.2', '283.4', '185.9', '108.2', '34.6', '5.4', '1183.9', '23.8', '83.5', '928.5', '148.2'),
(11, '1911', '40.4', '5.5', '43', '23.1', '48.2', '191.3', '163.1', '209.9', '178.5', '71.5', '42.4', '12.1', '1028.9', '45.8', '114.3', '742.8', '126'),
(12, '1912', '20.3', '21.6', '19.9', '37.9', '43.8', '107.1', '326.3', '259.2', '119.2', '58.2', '51.7', '5.3', '1070.4', '41.9', '101.6', '811.8', '115.2'),
(13, '1913', '6.3', '38.1', '23.7', '25.7', '72.9', '214.8', '269.8', '192.6', '109.6', '68.6', '16.8', '23.2', '1061.8', '44.4', '122.2', '786.7', '108.5'),
(14, '1914', '5', '26.9', '25.4', '42.8', '67.9', '157', '342', '239.7', '191.3', '45.5', '20.7', '21.6', '1185.9', '31.9', '136.1', '930', '87.9'),
(15, '1915', '19.8', '37.5', '44.1', '33.6', '63.9', '155.1', '227.9', '226.9', '171.7', '90.5', '45.2', '8.2', '1124.4', '57.3', '141.6', '781.5', '143.9'),
(16, '1916', '4.6', '20.1', '11', '35.2', '59.4', '232', '265', '309.7', '199.6', '139.2', '46.3', '2.9', '1324.8', '24.7', '105.6', '1006.2', '188.4'),
(17, '1917', '7.6', '37.9', '20.5', '40.1', '74', '230.7', '282.7', '292.8', '278.1', '161.3', '29.1', '9.3', '1463.9', '45.5', '134.5', '1084.3', '199.6'),
(18, '1918', '11.8', '4', '36.6', '35.8', '103.6', '212.3', '183.8', '240.9', '111.8', '19.5', '44.7', '15.5', '1020.2', '15.8', '176', '748.8', '79.6'),
(19, '1919', '48.8', '20.2', '19.1', '32.7', '59.5', '194.7', '304.6', '285.3', '163.1', '91.5', '50.1', '18.2', '1287.9', '69', '111.4', '947.7', '159.8'),
(20, '1920', '23.9', '21.3', '55.1', '38.2', '52.5', '163.7', '295.7', '191.6', '123', '45.9', '25.2', '3', '1039.1', '45.2', '145.7', '774.1', '74'),
(21, '1921', '37.6', '7.4', '17.8', '43.9', '51.2', '193.9', '293.7', '274.4', '203.3', '70.5', '16.1', '15.3', '1225', '45', '112.9', '965.2', '101.9'),
(22, '1922', '28.9', '9.8', '14.3', '33', '48.8', '204.9', '314.9', '218.9', '199.8', '62', '55.6', '13.3', '1204.2', '38.7', '96.1', '938.4', '131'),
(23, '1923', '21.6', '38.9', '21.2', '31', '58.1', '102', '337.8', '272.8', '173.8', '58', '17.6', '15.8', '1148.6', '60.5', '110.3', '886.4', '91.4'),
(24, '1924', '21.1', '21.9', '14', '30.7', '61.4', '136.8', '328.7', '255.4', '238.4', '65.8', '57.1', '14.6', '1245.9', '42.9', '106.1', '959.3', '137.6'),
(25, '1925', '13', '11.2', '15.3', '44.1', '100.8', '204.7', '300.9', '234.5', '140.2', '67.2', '41.5', '16.1', '1189.5', '24.3', '160.2', '880.2', '124.8'),
(26, '1926', '28.3', '10.3', '55.7', '39.4', '57.8', '98.7', '316.9', '330.5', '210.1', '57.3', '10.9', '10.3', '1226.2', '38.7', '152.9', '956.2', '78.5'),
(27, '1927', '13.1', '34.7', '22.4', '36.3', '50.4', '177.7', '346.6', '253.2', '173.6', '69.3', '57.2', '10.1', '1244.6', '47.9', '109.1', '951.1', '136.6'),
(28, '1928', '20.9', '40.3', '21.1', '34.6', '54.4', '178.9', '303.5', '229', '144', '127.7', '21.6', '24.4', '1200.2', '61.1', '110', '855.4', '173.7'),
(29, '1929', '29.6', '18.6', '14.4', '54.6', '65.9', '194.1', '296.7', '241', '125.5', '92.9', '19.6', '40.1', '1193.2', '48.2', '134.9', '857.4', '152.7'),
(30, '1930', '23.5', '23.2', '28.9', '51', '55.9', '181.5', '288.6', '212', '174.1', '96.7', '53', '10.3', '1198.5', '46.7', '135.8', '856.1', '160'),
(31, '1931', '12.4', '32.9', '19', '37.3', '59.4', '134.5', '319.6', '303.9', '191.1', '120.5', '41.4', '21', '1292.8', '45.2', '115.7', '949.1', '182.8'),
(32, '1932', '9.2', '22.9', '20.1', '31', '85.7', '141.7', '328.3', '237.9', '181.9', '69.4', '60.3', '14.4', '1202.9', '32.2', '136.8', '889.8', '144.1'),
(33, '1933', '16.5', '29.6', '25.1', '48.1', '102.4', '215.1', '279.7', '313.4', '211.6', '93.6', '20.5', '16.5', '1372', '46', '175.6', '1019.8', '130.6'),
(34, '1934', '23.3', '11.5', '16.1', '46.8', '47.3', '217.7', '284.8', '294.4', '166.8', '65.8', '32.4', '10.5', '1217.5', '34.7', '110.2', '963.7', '108.7'),
(35, '1935', '26.9', '20.7', '19', '41.5', '36.8', '159.4', '313.5', '246.9', '185.3', '49.9', '16.7', '11.2', '1127.9', '47.7', '97.3', '905.2', '77.8'),
(36, '1936', '12.3', '41.8', '37.8', '33.5', '82.7', '245.8', '292.5', '236.7', '193.9', '66.4', '57.2', '21.2', '1321.8', '54.1', '154.1', '968.8', '144.7'),
(37, '1937', '6.3', '50.6', '19', '56.3', '58', '162.2', '336.2', '208.2', '174', '94.6', '20.3', '18.9', '1204.4', '56.9', '133.2', '880.6', '133.8'),
(38, '1938', '29.9', '30.7', '33.4', '34.2', '70.9', '273.4', '300.2', '249.7', '171.6', '75.4', '16.2', '5', '1290.5', '60.6', '138.5', '994.8', '96.6'),
(39, '1939', '13.3', '32.1', '30.6', '40.7', '40.6', '172.9', '272.4', '231.5', '154.9', '91.2', '29.6', '1.7', '1111.6', '45.5', '111.9', '831.8', '122.5'),
(40, '1940', '13', '25.8', '47.7', '26.9', '80.8', '173.8', '308.4', '278.1', '125.5', '63', '40.9', '17.4', '1201.3', '38.8', '155.4', '885.8', '121.3'),
(41, '1941', '22.9', '16.4', '20.4', '31.5', '81', '171.8', '238.7', '228.4', '154', '62.1', '26.5', '20.3', '1073.9', '39.3', '132.8', '792.8', '108.9'),
(42, '1942', '21.4', '46', '20.6', '44.7', '63.7', '191.5', '339.6', '287', '182.5', '34.5', '17.7', '23.5', '1272.9', '67.5', '129', '1000.7', '75.8'),
(43, '1943', '56.8', '9.8', '32.5', '47.9', '94.3', '167.8', '308.9', '228.4', '211.4', '89', '17.1', '5.2', '1269.2', '66.6', '174.7', '916.5', '111.3'),
(44, '1944', '27.6', '37.8', '54.9', '31.9', '61', '155.6', '349.1', '287', '156.2', '92.3', '29.4', '15.6', '1298.5', '65.4', '147.8', '948', '137.4'),
(45, '1945', '34.2', '10.2', '20.1', '47.1', '53.6', '159.1', '333.3', '246.7', '214.5', '80.6', '17.9', '4.9', '1222', '44.3', '120.8', '953.5', '103.4'),
(46, '1946', '4.4', '19.1', '24.5', '48', '71.3', '214', '318.3', '296.3', '145', '84.4', '76', '35.8', '1337.2', '23.5', '143.9', '973.6', '196.2'),
(47, '1947', '22.4', '18.3', '26', '39.1', '55.9', '130.1', '314.4', '290.4', '240', '69.8', '7.2', '22.6', '1236.3', '40.8', '121', '974.9', '99.6'),
(48, '1948', '25.2', '29', '39.5', '42.5', '91.3', '164.1', '347.7', '282.7', '178', '61.2', '71.1', '10', '1342.2', '54.2', '173.3', '972.4', '142.3'),
(49, '1949', '12.6', '28.8', '24.1', '53', '89.3', '164.3', '316.8', '243.2', '227', '95.1', '10.6', '4.7', '1269.6', '41.4', '166.4', '951.3', '110.5'),
(50, '1950', '35.4', '25.4', '36.7', '28.7', '49.4', '135.7', '331.6', '235.6', '202.6', '57.7', '27.5', '7.9', '1174.2', '60.8', '114.8', '905.5', '93.1'),
(51, '1951', '15.7', '12.1', '44.4', '54.4', '59.4', '163.3', '252.7', '222.8', '124.6', '73.9', '31.3', '5.8', '1060.6', '27.8', '158.3', '763.4', '111.1'),
(52, '1952', '10.5', '19.8', '37.4', '32.4', '69.7', '165.6', '286.6', '256.6', '120', '79.6', '9.2', '22.5', '1110.1', '30.3', '139.5', '828.9', '111.3'),
(53, '1953', '30.2', '10.6', '25.3', '38.3', '47.1', '162.2', '323.1', '299.2', '179.9', '85.8', '12.3', '8', '1222.1', '40.8', '110.7', '964.4', '106.1'),
(54, '1954', '37.6', '37.2', '17.1', '22.8', '53.9', '145.5', '297.2', '232', '246.7', '73.8', '3.6', '13.9', '1181.4', '74.9', '93.9', '921.3', '91.3'),
(55, '1955', '20.8', '4.1', '21.3', '30.6', '72.6', '177.7', '236.8', '313.8', '215.7', '146.3', '26.4', '9.3', '1275.4', '24.9', '124.5', '944', '182'),
(56, '1956', '17', '11.1', '31.5', '28.1', '85.5', '211', '354.1', '254.3', '163.9', '150.1', '44', '11.9', '1362.6', '28.1', '145', '983.3', '206.1'),
(57, '1957', '31.1', '10.9', '24.2', '39.5', '71.2', '153.2', '300.8', '265.4', '131.7', '64', '28.6', '11.3', '1131.9', '42', '134.9', '851.1', '103.8'),
(58, '1958', '12.4', '16.5', '19.1', '36.9', '80.5', '123.7', '316.9', '324.9', '225.7', '114.7', '30', '10.9', '1312.3', '28.9', '136.5', '991.3', '155.7'),
(59, '1959', '31.8', '23.8', '21.3', '25.9', '75.3', '169.8', '375.5', '265.1', '237.3', '119.7', '26', '5.3', '1376.9', '55.6', '122.6', '1047.7', '151.1'),
(60, '1960', '13.8', '2.7', '35.2', '20', '57.7', '157.3', '320', '252.9', '184.7', '68.5', '33.7', '8.3', '1154.8', '16.5', '112.8', '914.9', '110.5'),
(61, '1961', '26.1', '34.8', '26', '28.5', '77.6', '192.9', '336.6', '287.6', '234.9', '122.2', '21.7', '10.4', '1399.2', '60.9', '132.1', '1052', '154.2'),
(62, '1962', '12.6', '21.6', '16', '43.6', '70.8', '137.1', '281.6', '276.9', '211', '78.4', '18.3', '29.9', '1198', '34.3', '130.4', '906.6', '126.7'),
(63, '1963', '6.8', '9.8', '41.7', '50.6', '60.9', '168', '258.6', '316.7', '164.9', '99.1', '28.4', '15.5', '1220.9', '16.6', '153.1', '908.2', '142.9'),
(64, '1964', '18.6', '14.1', '19', '40', '52.1', '177.2', '345.7', '273.7', '200.4', '67.4', '22.8', '13.3', '1244.4', '32.7', '111.1', '997', '103.5'),
(65, '1965', '11.8', '28.1', '26.7', '45.1', '52.7', '116.1', '270.1', '192.8', '129.5', '34', '18.2', '22.2', '947.4', '39.9', '124.6', '708.5', '74.4'),
(66, '1966', '13.1', '25.4', '20.3', '30.6', '57.2', '178.8', '252.5', '212.5', '143.9', '56.1', '51', '16.7', '1058', '38.5', '108', '787.8', '123.7'),
(67, '1967', '11.1', '14.2', '63.3', '29.5', '42.8', '144', '305.6', '264.3', '170.3', '40.6', '12.1', '56.1', '1154', '25.3', '135.6', '884.2', '108.9'),
(68, '1968', '29.4', '19.8', '27.5', '32.6', '46.7', '149.6', '309.9', '212.8', '129.5', '67.1', '21.8', '12.6', '1059.3', '49.2', '106.8', '801.7', '101.6'),
(69, '1969', '12.7', '14.5', '20.1', '39.7', '63.4', '130.2', '317.8', '273.4', '172.7', '55', '35.8', '12.7', '1147.8', '27.2', '123.1', '894', '103.4'),
(70, '1970', '23.2', '27.3', '25.9', '29.2', '69.7', '215.9', '245.6', '313', '212.7', '75.3', '15.7', '1.6', '1255', '50.5', '124.8', '987.1', '92.6'),
(71, '1971', '16.1', '23.6', '10.8', '52.8', '75', '229.9', '267.2', '267.3', '146.5', '99.9', '15.9', '12', '1216.9', '39.7', '138.6', '910.8', '127.8'),
(72, '1972', '10.3', '27.6', '21.6', '37.1', '55.3', '123.3', '204', '219.5', '127.5', '65.7', '31.4', '23.7', '947.1', '37.8', '114', '674.3', '120.9'),
(73, '1973', '21', '21.8', '21.2', '27.5', '56.5', '149.9', '277.4', '311', '182.1', '114.6', '18.9', '17.7', '1219.5', '42.8', '105.2', '920.3', '151.2'),
(74, '1974', '16.1', '12.9', '20.5', '33.7', '64.2', '122', '283.6', '232.5', '145.3', '101.6', '10.7', '12.1', '1055.3', '29.1', '118.4', '783.4', '124.4'),
(75, '1975', '15.4', '20.8', '28.7', '28.3', '50.2', '175.6', '310.7', '292.5', '224.6', '121.9', '22.8', '3.3', '1294.8', '36.1', '107.3', '1003.4', '148'),
(76, '1976', '11.5', '24.5', '25.5', '36.3', '45.4', '160.3', '294.1', '294', '144.2', '33', '55', '7.6', '1131.6', '36', '107.3', '892.7', '95.6'),
(77, '1977', '21', '10.2', '14.6', '68.3', '84.4', '187.2', '323.4', '245.4', '147.8', '85.6', '65.8', '16.1', '1269.7', '31.2', '167.3', '903.8', '167.4'),
(78, '1978', '12.3', '27', '44.2', '33.1', '60.2', '208.8', '290', '282', '161.9', '49.1', '49.9', '18.8', '1237.2', '39.3', '137.4', '942.7', '117.8'),
(79, '1979', '20.9', '35', '28.9', '21.2', '54.2', '140.5', '239.6', '210.6', '136.8', '51.8', '76.1', '14.4', '1030.2', '55.9', '104.3', '727.6', '142.4'),
(80, '1980', '12.8', '22.3', '32.5', '34.6', '55.3', '227.8', '295', '263.8', '145.7', '49.3', '24.2', '19', '1182.3', '35.1', '122.5', '932.4', '92.4'),
(81, '1981', '29.3', '20.4', '48', '37.3', '67.1', '151.3', '309.1', '237', '184.5', '45.1', '27.4', '14', '1170.7', '49.7', '152.4', '882', '86.6'),
(82, '1982', '23.8', '24.2', '45.7', '49.8', '59', '137.8', '230.8', '276.9', '124.9', '51.7', '46', '13.9', '1084.4', '48', '154.5', '770.4', '111.5'),
(83, '1983', '18.5', '23.3', '43.4', '57', '70.1', '150.8', '282.2', '304.3', '251.6', '85.9', '10.8', '22.9', '1320.9', '41.7', '170.5', '988.9', '119.7'),
(84, '1984', '19', '35.9', '22.8', '45.3', '60.4', '192.3', '291.9', '256.5', '144.6', '61', '15.7', '15.3', '1160.8', '54.9', '128.5', '885.4', '92'),
(85, '1985', '23.2', '9.9', '20.1', '39.5', '63', '156.5', '290.1', '231.7', '149.6', '114.1', '18.8', '28.4', '1144.9', '33.1', '122.6', '827.9', '161.4'),
(86, '1986', '15.5', '36.6', '29.9', '50', '49.4', '182.6', '264.2', '228.3', '128.4', '74.7', '49.6', '28.4', '1137.6', '52', '129.3', '803.6', '152.7'),
(87, '1987', '13.2', '23.8', '28.8', '43.9', '67', '133.9', '223.2', '242.1', '152.2', '94.4', '44.4', '21.9', '1088.9', '37', '139.8', '751.4', '160.7'),
(88, '1988', '10.4', '28.7', '53.7', '41.7', '70.4', '161.8', '374.8', '295.3', '217.7', '53.6', '16.2', '17.8', '1342.1', '39.1', '165.8', '1049.6', '87.7'),
(89, '1989', '15.4', '15.3', '28.8', '34.6', '57.5', '184.7', '302.3', '236.2', '163.1', '51.9', '20.3', '17.2', '1127.4', '30.7', '121', '886.3', '89.4'),
(90, '1990', '16', '44.2', '54', '43.8', '112.9', '191.3', '282.9', '293.6', '197.4', '104.1', '30.2', '31', '1401.4', '60.3', '210.7', '965.2', '165.3'),
(91, '1991', '14.3', '28.1', '27.8', '51.7', '68.9', '184.7', '279.2', '268.1', '140.7', '61.8', '30.2', '14.7', '1170.2', '42.3', '148.5', '872.7', '106.8'),
(92, '1992', '16', '16.5', '24.8', '26.1', '59.3', '139.7', '262.5', '274', '171.7', '64.7', '41.6', '5.6', '1102.7', '32.5', '110.2', '848', '112'),
(93, '1993', '18.2', '25.6', '41.6', '27', '71.3', '172.1', '305.4', '203.2', '208.5', '87.9', '30.5', '16.5', '1207.8', '43.8', '139.9', '889.3', '134.9'),
(94, '1994', '25', '27.9', '25.2', '45.9', '53.1', '205.7', '350', '282.2', '149.4', '82.8', '25.5', '22.6', '1295.3', '52.9', '124.1', '987.4', '130.9'),
(95, '1995', '31.3', '29.4', '28.3', '32.4', '82.4', '143.3', '323.4', '269', '179', '78', '36.8', '9.2', '1242.4', '60.7', '143', '914.7', '123.9'),
(96, '1996', '22.9', '23.2', '32.1', '31.4', '56', '185.7', '262.1', '292.4', '146.1', '100.5', '13.6', '16.9', '1182.9', '46.1', '119.6', '886.2', '130.9'),
(97, '1997', '14.3', '10.4', '30.3', '46', '48.6', '171.7', '281.5', '261.9', '151.4', '61.1', '57.6', '48.3', '1183.1', '24.7', '124.8', '866.5', '167'),
(98, '1998', '16.4', '28.2', '39.1', '36.3', '49.2', '163.9', '278.4', '243.8', '196.5', '107.4', '39.3', '10.3', '1208.8', '44.6', '124.6', '882.6', '157'),
(99, '1999', '13.7', '11.2', '8.8', '19.3', '94.9', '169.9', '261.7', '213.2', '183', '117.2', '20', '3.7', '1116.6', '24.9', '122.9', '827.9', '141'),
(100, '2000', '18.4', '28.2', '17.9', '34.7', '71.6', '179', '263.5', '221.1', '134.5', '41.9', '14.6', '10', '1035.4', '46.6', '124.3', '798.1', '66.4'),
(101, '2001', '6.7', '11.6', '19.9', '44.6', '62.9', '221.2', '281.1', '205.5', '111', '100.4', '19.7', '16.1', '1100.7', '18.3', '127.4', '818.8', '136.2'),
(102, '2002', '17.1', '20.1', '23.8', '38.6', '59.8', '172.6', '143.8', '246.1', '137.9', '55.6', '15.6', '5', '935.9', '37.3', '122.1', '700.5', '76.1'),
(103, '2003', '7.3', '42.3', '36.7', '36.6', '40.1', '169.3', '306.5', '243.6', '183.4', '92.7', '11.5', '17.2', '1187.3', '49.6', '113.5', '902.9', '121.3'),
(104, '2004', '25.1', '10', '12.8', '55.2', '80.6', '171.1', '250.5', '254', '131.5', '95', '17.9', '2.8', '1106.5', '35.1', '148.6', '807.1', '115.7'),
(105, '2005', '28.1', '41.8', '42.5', '37.7', '46.1', '143.2', '334.1', '190.1', '206.9', '99.3', '27.2', '11.2', '1208.3', '69.9', '126.3', '874.3', '137.7'),
(106, '2006', '17.7', '11.9', '35.6', '32.7', '75', '141.8', '287.6', '281.3', '178.6', '51.8', '34.6', '13.1', '1161.6', '29.6', '143.2', '889.3', '99.5'),
(107, '2007', '1.7', '36.7', '35.2', '30.6', '46.8', '192.5', '286.2', '257.4', '206.8', '55.7', '14.4', '15.3', '1179.3', '38.3', '112.6', '943', '85.4'),
(108, '2008', '18.4', '19.3', '41.2', '29.5', '43.7', '202', '245', '265.8', '165.1', '51.6', '25.5', '11', '1118', '37.7', '114.5', '877.8', '88.1'),
(109, '2009', '12', '12', '14.2', '25.1', '56', '85.7', '280.7', '192.5', '139.4', '71.4', '53.7', '11.1', '953.7', '24', '95.3', '698.3', '136.1'),
(110, '2010', '7.5', '17', '14', '39', '73.8', '138.1', '300.7', '274.7', '197.7', '69', '61.4', '22.7', '1215.5', '24.5', '126.8', '911.1', '153.2'),
(111, '2011', '6.8', '25.8', '22.4', '41.1', '53.1', '183.5', '246', '284.9', '186.9', '38.1', '20.1', '7.6', '1116.3', '32.6', '116.6', '901.3', '65.8'),
(112, '2012', '26.5', '12.7', '11.3', '47.5', '31.7', '117.8', '250.2', '262.4', '193.5', '58.7', '30.7', '11.7', '1054.7', '39.2', '90.5', '823.9', '101.1');
/*!40000 ALTER TABLE `d1` ENABLE KEYS */;
-- Dumping structure for table datarepo.d2
CREATE TABLE IF NOT EXISTS `d2` (
`d2_id` int(11) NOT NULL AUTO_INCREMENT,
`_year` text,
`_annual` text,
`_jan_feb` text,
`_mar_may` text,
`_jun_sep` text,
`_oct_dec` text,
PRIMARY KEY (`d2_id`)
) ENGINE=InnoDB AUTO_INCREMENT=113 DEFAULT CHARSET=latin1;
-- Dumping data for table datarepo.d2: ~112 rows (approximately)
/*!40000 ALTER TABLE `d2` DISABLE KEYS */;
INSERT INTO `d2` (`d2_id`, `_year`, `_annual`, `_jan_feb`, `_mar_may`, `_jun_sep`, `_oct_dec`) VALUES
(1, '1901', '28.96', '23.27', '31.46', '31.27', '27.25'),
(2, '1902', '29.22', '25.75', '31.76', '31.09', '26.49'),
(3, '1903', '28.47', '24.24', '30.71', '30.92', '26.26'),
(4, '1904', '28.49', '23.62', '30.95', '30.67', '26.40'),
(5, '1905', '28.30', '22.25', '30.00', '31.33', '26.57'),
(6, '1906', '28.73', '23.03', '31.11', '30.86', '27.29'),
(7, '1907', '28.65', '24.23', '29.92', '30.81', '27.36'),
(8, '1908', '28.83', '24.42', '31.43', '30.72', '26.64'),
(9, '1909', '28.39', '23.52', '31.02', '30.33', '26.88'),
(10, '1910', '28.53', '24.20', '31.14', '30.48', '26.20'),
(11, '1911', '28.62', '23.90', '30.70', '31.14', '26.31'),
(12, '1912', '28.95', '24.88', '31.10', '31.15', '26.57'),
(13, '1913', '28.67', '24.25', '30.90', '30.92', '26.42'),
(14, '1914', '28.66', '24.59', '30.73', '30.84', '26.40'),
(15, '1915', '28.94', '23.22', '31.06', '31.51', '27.18'),
(16, '1916', '28.82', '24.57', '31.88', '30.52', '26.32'),
(17, '1917', '28.11', '24.52', '30.06', '30.24', '25.74'),
(18, '1918', '28.66', '23.57', '30.68', '31.11', '26.77'),
(19, '1919', '28.66', '23.71', '31.17', '30.80', '26.60'),
(20, '1920', '28.76', '23.64', '30.40', '31.08', '27.45'),
(21, '1921', '28.86', '23.91', '32.05', '30.81', '26.43'),
(22, '1922', '28.80', '24.43', '31.21', '30.90', '26.38'),
(23, '1923', '28.74', '23.73', '31.40', '30.98', '26.43'),
(24, '1924', '28.80', '23.94', '31.44', '30.96', '26.49'),
(25, '1925', '28.67', '23.57', '31.47', '30.67', '26.59'),
(26, '1926', '28.70', '24.73', '30.21', '31.14', '26.61'),
(27, '1927', '28.59', '23.76', '30.72', '30.80', '26.72'),
(28, '1928', '28.98', '24.21', '31.51', '31.14', '26.73'),
(29, '1929', '28.76', '23.53', '31.72', '31.03', '26.27'),
(30, '1930', '28.65', '23.20', '30.94', '30.98', '26.90'),
(31, '1931', '29.15', '24.55', '31.71', '31.16', '26.97'),
(32, '1932', '29.09', '24.51', '31.17', '31.25', '27.18'),
(33, '1933', '28.49', '24.13', '30.42', '30.41', '26.92'),
(34, '1934', '29.03', '24.53', '31.28', '31.22', '26.94'),
(35, '1935', '28.76', '23.41', '31.15', '30.85', '26.88'),
(36, '1936', '28.71', '24.11', '31.17', '30.68', '26.69'),
(37, '1937', '28.70', '24.13', '30.84', '31.22', '26.26'),
(38, '1938', '28.70', '23.31', '31.74', '30.59', '26.71'),
(39, '1939', '28.85', '24.25', '30.76', '31.06', '27.05'),
(40, '1940', '28.88', '24.46', '30.66', '30.93', '27.24'),
(41, '1941', '29.46', '24.37', '32.12', '31.37', '27.62'),
(42, '1942', '28.98', '24.03', '31.80', '30.99', '27.23'),
(43, '1943', '28.80', '24.02', '30.80', '30.83', '27.33'),
(44, '1944', '28.89', '23.62', '31.03', '31.25', '27.16'),
(45, '1945', '28.97', '23.86', '31.19', '31.48', '26.82'),
(46, '1946', '29.37', '25.49', '31.50', '31.23', '27.30'),
(47, '1947', '28.84', '23.99', '31.78', '31.20', '26.70'),
(48, '1948', '28.73', '23.62', '31.27', '30.84', '26.77'),
(49, '1949', '28.89', '24.49', '31.27', '30.88', '26.79'),
(50, '1950', '28.47', '24.02', '30.72', '30.48', '26.58'),
(51, '1951', '29.09', '24.16', '30.67', '31.13', '27.77'),
(52, '1952', '29.16', '25.17', '31.13', '31.11', '27.26'),
(53, '1953', '29.43', '24.71', '32.19', '31.12', '27.56'),
(54, '1954', '28.92', '24.20', '31.89', '30.90', '26.46'),
(55, '1955', '28.76', '24.90', '30.88', '30.72', '26.59'),
(56, '1956', '28.63', '24.40', '31.53', '30.25', '26.37'),
(57, '1957', '28.64', '23.87', '30.41', '31.07', '26.82'),
(58, '1958', '29.33', '25.43', '31.73', '31.23', '27.01'),
(59, '1959', '29.02', '24.03', '31.69', '30.99', '27.03'),
(60, '1960', '29.31', '25.48', '31.16', '31.29', '27.36'),
(61, '1961', '28.72', '24.17', '31.47', '30.75', '26.30'),
(62, '1962', '28.89', '24.24', '31.31', '31.08', '26.65'),
(63, '1963', '29.04', '24.73', '30.94', '31.28', '27.00'),
(64, '1964', '29.09', '24.29', '31.89', '30.82', '27.20'),
(65, '1965', '29.16', '24.67', '30.73', '31.37', '27.62'),
(66, '1966', '29.41', '25.54', '31.69', '31.24', '27.26'),
(67, '1967', '29.14', '25.31', '31.04', '31.32', '26.90'),
(68, '1968', '29.07', '23.68', '31.24', '31.54', '27.19'),
(69, '1969', '29.61', '24.99', '32.02', '31.55', '27.71'),
(70, '1970', '29.47', '25.19', '32.03', '31.16', '27.50'),
(71, '1971', '29.15', '24.99', '31.58', '30.91', '27.17'),
(72, '1972', '29.31', '24.49', '31.49', '31.66', '27.21'),
(73, '1973', '29.44', '25.35', '32.19', '31.28', '26.97'),
(74, '1974', '29.26', '24.34', '31.92', '31.39', '27.03'),
(75, '1975', '28.89', '24.12', '31.62', '30.66', '26.99'),
(76, '1976', '29.27', '24.61', '31.45', '31.09', '27.76'),
(77, '1977', '29.41', '25.15', '31.65', '31.22', '27.59'),
(78, '1978', '29.23', '24.36', '31.57', '31.11', '27.64'),
(79, '1979', '29.63', '24.99', '31.70', '31.87', '27.67'),
(80, '1980', '29.58', '25.21', '32.20', '31.36', '27.51'),
(81, '1981', '29.32', '24.90', '31.64', '31.34', '27.24'),
(82, '1982', '29.12', '24.51', '30.79', '31.55', '27.26'),
(83, '1983', '29.11', '24.62', '30.84', '31.48', '27.24'),
(84, '1984', '29.28', '24.11', '32.12', '31.09', '27.46'),
(85, '1985', '29.61', '25.29', '32.51', '31.28', '27.35'),
(86, '1986', '29.33', '24.64', '31.58', '31.44', '27.40'),
(87, '1987', '29.72', '25.07', '31.37', '32.24', '27.82'),
(88, '1988', '29.55', '25.39', '31.75', '31.34', '27.76'),
(89, '1989', '29.18', '24.51', '31.35', '31.11', '27.57'),
(90, '1990', '29.14', '24.99', '30.84', '31.18', '27.50'),
(91, '1991', '29.32', '24.74', '31.46', '31.45', '27.40'),
(92, '1992', '29.23', '24.60', '31.32', '31.28', '27.49'),
(93, '1993', '29.55', '25.31', '31.61', '31.47', '27.74'),
(94, '1994', '29.46', '25.09', '31.85', '31.31', '27.52'),
(95, '1995', '30.18', '25.68', '32.40', '32.01', '28.52'),
(96, '1996', '29.58', '26.30', '32.07', '31.19', '27.29'),
(97, '1997', '29.05', '24.64', '31.26', '31.77', '26.65'),
(98, '1998', '29.70', '24.97', '31.89', '31.75', '27.83'),
(99, '1999', '29.81', '25.11', '32.45', '31.55', '27.95'),
(100, '2000', '29.75', '24.82', '32.22', '31.25', '28.53'),
(101, '2001', '29.99', '25.88', '32.61', '31.61', '28.13'),
(102, '2002', '30.23', '25.37', '33.06', '32.02', '28.36'),
(103, '2003', '29.75', '25.32', '32.05', '31.72', '27.70'),
(104, '2004', '29.79', '25.49', '32.69', '31.42', '27.65'),
(105, '2005', '29.60', '24.96', '31.81', '31.84', '27.50'),
(106, '2006', '30.06', '27.44', '32.08', '31.39', '27.78'),
(107, '2007', '29.84', '25.73', '32.32', '31.40', '28.03'),
(108, '2008', '29.64', '24.72', '32.11', '31.25', '28.29'),
(109, '2009', '30.29', '26.50', '32.57', '32.24', '27.96'),
(110, '2010', '30.12', '25.96', '33.46', '31.43', '27.78'),
(111, '2011', '29.82', '25.33', '32.07', '31.55', '28.23'),
(112, '2012', '29.81', '25.03', '32.33', '31.77', '27.88');
/*!40000 ALTER TABLE `d2` ENABLE KEYS */;
-- Dumping structure for table datarepo.dataset_keys
CREATE TABLE IF NOT EXISTS `dataset_keys` (
`dataset_key_id` int(20) NOT NULL AUTO_INCREMENT,
`location_index_id` int(20) DEFAULT NULL,
`keyname` varchar(100) DEFAULT NULL,
PRIMARY KEY (`dataset_key_id`),
KEY `FK_dataset_keys_location_index` (`location_index_id`),
CONSTRAINT `FK_dataset_keys_location_index` FOREIGN KEY (`location_index_id`) REFERENCES `location_index` (`location_index_id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=606 DEFAULT CHARSET=latin1;
-- Dumping data for table datarepo.dataset_keys: ~24 rows (approximately)
/*!40000 ALTER TABLE `dataset_keys` DISABLE KEYS */;
INSERT INTO `dataset_keys` (`dataset_key_id`, `location_index_id`, `keyname`) VALUES
(576, 1, '_year'),
(577, 1, '_jan'),
(578, 1, '_feb'),
(579, 1, '_mar'),
(580, 1, '_apr'),
(581, 1, '_may'),
(582, 1, '_jun'),
(583, 1, '_jul'),
(584, 1, '_aug'),
(585, 1, '_sep'),
(586, 1, '_oct'),
(587, 1, '_nov'),
(588, 1, '_dec'),
(589, 1, '_annual'),
(590, 1, '_jan_feb'),
(591, 1, '_march_may'),
(592, 1, '_june_september'),
(593, 1, '_oct_dec'),
(594, 2, '_year'),
(595, 2, '_annual'),
(596, 2, '_jan_feb'),
(597, 2, '_mar_may'),
(598, 2, '_jun_sep'),
(599, 2, '_oct_dec'),
(600, 3, '_year'),
(601, 3, '_annual'),
(602, 3, '_jan_feb'),
(603, 3, '_mar_may'),
(604, 3, '_jun_sep'),
(605, 3, '_oct_dec');
/*!40000 ALTER TABLE `dataset_keys` ENABLE KEYS */;
-- Dumping structure for view datarepo.dataset_loc_view
-- Creating temporary table to overcome VIEW dependency errors
CREATE TABLE `dataset_loc_view` (
`location_index_id` INT(20) NOT NULL,
`country` VARCHAR(50) NULL COLLATE 'latin1_swedish_ci',
`state` VARCHAR(50) NULL COLLATE 'latin1_swedish_ci',
`district` VARCHAR(50) NULL COLLATE 'latin1_swedish_ci',
`department` VARCHAR(50) NOT NULL COLLATE 'latin1_swedish_ci',
`dataset_name` VARCHAR(50) NOT NULL COLLATE 'latin1_swedish_ci',
`date_time` TIMESTAMP NOT NULL,
`dataset_key_id` INT(20) NOT NULL,
`keyname` VARCHAR(100) NULL COLLATE 'latin1_swedish_ci'
) ENGINE=MyISAM;
-- Dumping structure for table datarepo.dataset_relation
CREATE TABLE IF NOT EXISTS `dataset_relation` (
`relation_id` int(11) NOT NULL AUTO_INCREMENT,
`from_dataset_id` int(11) DEFAULT NULL,
`to_dataset_id` int(11) DEFAULT NULL,
`from_field_id` int(11) DEFAULT NULL,
`to_field_id` int(11) DEFAULT NULL,
PRIMARY KEY (`relation_id`),
KEY `FK_dataset_relation_location_index` (`from_dataset_id`),
CONSTRAINT `FK_dataset_relation_location_index` FOREIGN KEY (`from_dataset_id`) REFERENCES `location_index` (`location_index_id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=latin1;
-- Dumping data for table datarepo.dataset_relation: ~0 rows (approximately)
/*!40000 ALTER TABLE `dataset_relation` DISABLE KEYS */;
INSERT INTO `dataset_relation` (`relation_id`, `from_dataset_id`, `to_dataset_id`, `from_field_id`, `to_field_id`) VALUES
(5, 2, 1, 594, 576),
(6, 1, 2, 576, 594),
(7, 3, 1, 600, 576),
(8, 1, 3, 576, 600);
/*!40000 ALTER TABLE `dataset_relation` ENABLE KEYS */;
-- Dumping structure for table datarepo.document_model
CREATE TABLE IF NOT EXISTS `document_model` (
`term_freq_id` bigint(20) NOT NULL AUTO_INCREMENT,
`dataset_id` int(11) DEFAULT NULL,
`bag_of_words` mediumtext,
PRIMARY KEY (`term_freq_id`),
FULLTEXT KEY `Index 2` (`bag_of_words`)
) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=latin1;
-- Dumping data for table datarepo.document_model: 2 rows
/*!40000 ALTER TABLE `document_model` DISABLE KEYS */;
INSERT INTO `document_model` (`term_freq_id`, `dataset_id`, `bag_of_words`) VALUES
(1, 1, ''),
(2, 2, ''),
(3, 3, '');
/*!40000 ALTER TABLE `document_model` ENABLE KEYS */;
-- Dumping structure for table datarepo.document_model_tuple
CREATE TABLE IF NOT EXISTS `document_model_tuple` (
`document_model_tuple_id` bigint(20) NOT NULL AUTO_INCREMENT,
`dataset_id` bigint(20) NOT NULL DEFAULT '0',
`tuple_id` bigint(20) NOT NULL DEFAULT '0',
`bag_of_words` mediumtext NOT NULL,
PRIMARY KEY (`document_model_tuple_id`),
FULLTEXT KEY `bag_of_words` (`bag_of_words`)
) ENGINE=MyISAM AUTO_INCREMENT=337 DEFAULT CHARSET=latin1;
-- Dumping data for table datarepo.document_model_tuple: 224 rows
/*!40000 ALTER TABLE `document_model_tuple` DISABLE KEYS */;
INSERT INTO `document_model_tuple` (`document_model_tuple_id`, `dataset_id`, `tuple_id`, `bag_of_words`) VALUES
(1, 1, 0, '[1901, 34.7, 38.6, 17.8, 38.9, 50.6, 113.2, 241.4, 271.6, 124.7, 52.4, 38.7, 8.2, 1030.8, 73.2, 107.3, 751, 99.3]'),
(2, 1, 0, '[1902, 7.4, 4.2, 19, 44.1, 48.8, 111.7, 284.9, 201, 200.2, 62.5, 29.4, 25.2, 1038.4, 11.6, 111.9, 797.8, 117.2]'),
(3, 1, 0, '[1903, 16.7, 8, 31.1, 17.1, 59.5, 120.3, 293.2, 274, 198.1, 119.5, 40.3, 18, 1195.9, 24.7, 107.7, 885.6, 177.8]'),
(4, 1, 0, '[1904, 14.9, 9.7, 31.4, 33.7, 73.8, 165.5, 260.3, 207.7, 130.8, 69.8, 11.2, 16.4, 1025.1, 24.5, 138.8, 764.3, 97.4]'),
(5, 1, 0, '[1905, 24.7, 20.3, 41.8, 33.8, 55.8, 93.7, 253, 201.7, 178.1, 54.9, 9.6, 10.1, 977.5, 45, 131.4, 726.4, 74.7]'),
(6, 1, 0, '[1906, 21.4, 49.9, 31.4, 15.8, 37.2, 177, 286.5, 251.4, 183.9, 50.6, 17.7, 26.3, 1149.2, 71.3, 84.4, 898.9, 94.6]'),
(7, 1, 0, '[1907, 16, 45.5, 37.4, 62, 32.7, 153.1, 225.4, 308.3, 95.4, 23, 23.1, 12.9, 1034.8, 61.5, 132.1, 782.2, 58.9]'),
(8, 1, 0, '[1908, 19.9, 17.1, 8.3, 31, 45.4, 125.6, 320.5, 306, 150.8, 38.4, 6.8, 7.4, 1077.4, 37, 84.7, 903, 52.7]'),
(9, 1, 0, '[1909, 22.7, 15.2, 6.6, 61.6, 51.2, 207.2, 302.3, 228.7, 157.7, 37.5, 10, 27.9, 1128.5, 37.9, 119.4, 895.7, 75.4]'),
(10, 1, 0, '[1910, 13.5, 10.3, 13.7, 29, 40.8, 211.9, 247.2, 283.4, 185.9, 108.2, 34.6, 5.4, 1183.9, 23.8, 83.5, 928.5, 148.2]'),
(11, 1, 0, '[1911, 40.4, 5.5, 43, 23.1, 48.2, 191.3, 163.1, 209.9, 178.5, 71.5, 42.4, 12.1, 1028.9, 45.8, 114.3, 742.8, 126]'),
(12, 1, 0, '[1912, 20.3, 21.6, 19.9, 37.9, 43.8, 107.1, 326.3, 259.2, 119.2, 58.2, 51.7, 5.3, 1070.4, 41.9, 101.6, 811.8, 115.2]'),
(13, 1, 0, '[1913, 6.3, 38.1, 23.7, 25.7, 72.9, 214.8, 269.8, 192.6, 109.6, 68.6, 16.8, 23.2, 1061.8, 44.4, 122.2, 786.7, 108.5]'),
(14, 1, 0, '[1914, 5, 26.9, 25.4, 42.8, 67.9, 157, 342, 239.7, 191.3, 45.5, 20.7, 21.6, 1185.9, 31.9, 136.1, 930, 87.9]'),
(15, 1, 0, '[1915, 19.8, 37.5, 44.1, 33.6, 63.9, 155.1, 227.9, 226.9, 171.7, 90.5, 45.2, 8.2, 1124.4, 57.3, 141.6, 781.5, 143.9]'),
(16, 1, 0, '[1916, 4.6, 20.1, 11, 35.2, 59.4, 232, 265, 309.7, 199.6, 139.2, 46.3, 2.9, 1324.8, 24.7, 105.6, 1006.2, 188.4]'),
(17, 1, 0, '[1917, 7.6, 37.9, 20.5, 40.1, 74, 230.7, 282.7, 292.8, 278.1, 161.3, 29.1, 9.3, 1463.9, 45.5, 134.5, 1084.3, 199.6]'),
(18, 1, 0, '[1918, 11.8, 4, 36.6, 35.8, 103.6, 212.3, 183.8, 240.9, 111.8, 19.5, 44.7, 15.5, 1020.2, 15.8, 176, 748.8, 79.6]'),
(19, 1, 0, '[1919, 48.8, 20.2, 19.1, 32.7, 59.5, 194.7, 304.6, 285.3, 163.1, 91.5, 50.1, 18.2, 1287.9, 69, 111.4, 947.7, 159.8]'),
(20, 1, 0, '[1920, 23.9, 21.3, 55.1, 38.2, 52.5, 163.7, 295.7, 191.6, 123, 45.9, 25.2, 3, 1039.1, 45.2, 145.7, 774.1, 74]'),
(21, 1, 0, '[1921, 37.6, 7.4, 17.8, 43.9, 51.2, 193.9, 293.7, 274.4, 203.3, 70.5, 16.1, 15.3, 1225, 45, 112.9, 965.2, 101.9]'),
(22, 1, 0, '[1922, 28.9, 9.8, 14.3, 33, 48.8, 204.9, 314.9, 218.9, 199.8, 62, 55.6, 13.3, 1204.2, 38.7, 96.1, 938.4, 131]'),
(23, 1, 0, '[1923, 21.6, 38.9, 21.2, 31, 58.1, 102, 337.8, 272.8, 173.8, 58, 17.6, 15.8, 1148.6, 60.5, 110.3, 886.4, 91.4]'),
(24, 1, 0, '[1924, 21.1, 21.9, 14, 30.7, 61.4, 136.8, 328.7, 255.4, 238.4, 65.8, 57.1, 14.6, 1245.9, 42.9, 106.1, 959.3, 137.6]'),
(25, 1, 0, '[1925, 13, 11.2, 15.3, 44.1, 100.8, 204.7, 300.9, 234.5, 140.2, 67.2, 41.5, 16.1, 1189.5, 24.3, 160.2, 880.2, 124.8]'),
(26, 1, 0, '[1926, 28.3, 10.3, 55.7, 39.4, 57.8, 98.7, 316.9, 330.5, 210.1, 57.3, 10.9, 10.3, 1226.2, 38.7, 152.9, 956.2, 78.5]'),
(27, 1, 0, '[1927, 13.1, 34.7, 22.4, 36.3, 50.4, 177.7, 346.6, 253.2, 173.6, 69.3, 57.2, 10.1, 1244.6, 47.9, 109.1, 951.1, 136.6]'),
(28, 1, 0, '[1928, 20.9, 40.3, 21.1, 34.6, 54.4, 178.9, 303.5, 229, 144, 127.7, 21.6, 24.4, 1200.2, 61.1, 110, 855.4, 173.7]'),
(29, 1, 0, '[1929, 29.6, 18.6, 14.4, 54.6, 65.9, 194.1, 296.7, 241, 125.5, 92.9, 19.6, 40.1, 1193.2, 48.2, 134.9, 857.4, 152.7]'),
(30, 1, 0, '[1930, 23.5, 23.2, 28.9, 51, 55.9, 181.5, 288.6, 212, 174.1, 96.7, 53, 10.3, 1198.5, 46.7, 135.8, 856.1, 160]'),
(31, 1, 0, '[1931, 12.4, 32.9, 19, 37.3, 59.4, 134.5, 319.6, 303.9, 191.1, 120.5, 41.4, 21, 1292.8, 45.2, 115.7, 949.1, 182.8]'),
(32, 1, 0, '[1932, 9.2, 22.9, 20.1, 31, 85.7, 141.7, 328.3, 237.9, 181.9, 69.4, 60.3, 14.4, 1202.9, 32.2, 136.8, 889.8, 144.1]'),
(33, 1, 0, '[1933, 16.5, 29.6, 25.1, 48.1, 102.4, 215.1, 279.7, 313.4, 211.6, 93.6, 20.5, 16.5, 1372, 46, 175.6, 1019.8, 130.6]'),
(34, 1, 0, '[1934, 23.3, 11.5, 16.1, 46.8, 47.3, 217.7, 284.8, 294.4, 166.8, 65.8, 32.4, 10.5, 1217.5, 34.7, 110.2, 963.7, 108.7]'),
(35, 1, 0, '[1935, 26.9, 20.7, 19, 41.5, 36.8, 159.4, 313.5, 246.9, 185.3, 49.9, 16.7, 11.2, 1127.9, 47.7, 97.3, 905.2, 77.8]'),
(36, 1, 0, '[1936, 12.3, 41.8, 37.8, 33.5, 82.7, 245.8, 292.5, 236.7, 193.9, 66.4, 57.2, 21.2, 1321.8, 54.1, 154.1, 968.8, 144.7]'),
(37, 1, 0, '[1937, 6.3, 50.6, 19, 56.3, 58, 162.2, 336.2, 208.2, 174, 94.6, 20.3, 18.9, 1204.4, 56.9, 133.2, 880.6, 133.8]'),
(38, 1, 0, '[1938, 29.9, 30.7, 33.4, 34.2, 70.9, 273.4, 300.2, 249.7, 171.6, 75.4, 16.2, 5, 1290.5, 60.6, 138.5, 994.8, 96.6]'),
(39, 1, 0, '[1939, 13.3, 32.1, 30.6, 40.7, 40.6, 172.9, 272.4, 231.5, 154.9, 91.2, 29.6, 1.7, 1111.6, 45.5, 111.9, 831.8, 122.5]'),
(40, 1, 0, '[1940, 13, 25.8, 47.7, 26.9, 80.8, 173.8, 308.4, 278.1, 125.5, 63, 40.9, 17.4, 1201.3, 38.8, 155.4, 885.8, 121.3]'),
(41, 1, 0, '[1941, 22.9, 16.4, 20.4, 31.5, 81, 171.8, 238.7, 228.4, 154, 62.1, 26.5, 20.3, 1073.9, 39.3, 132.8, 792.8, 108.9]'),
(42, 1, 0, '[1942, 21.4, 46, 20.6, 44.7, 63.7, 191.5, 339.6, 287, 182.5, 34.5, 17.7, 23.5, 1272.9, 67.5, 129, 1000.7, 75.8]'),
(43, 1, 0, '[1943, 56.8, 9.8, 32.5, 47.9, 94.3, 167.8, 308.9, 228.4, 211.4, 89, 17.1, 5.2, 1269.2, 66.6, 174.7, 916.5, 111.3]'),
(44, 1, 0, '[1944, 27.6, 37.8, 54.9, 31.9, 61, 155.6, 349.1, 287, 156.2, 92.3, 29.4, 15.6, 1298.5, 65.4, 147.8, 948, 137.4]'),
(45, 1, 0, '[1945, 34.2, 10.2, 20.1, 47.1, 53.6, 159.1, 333.3, 246.7, 214.5, 80.6, 17.9, 4.9, 1222, 44.3, 120.8, 953.5, 103.4]'),
(46, 1, 0, '[1946, 4.4, 19.1, 24.5, 48, 71.3, 214, 318.3, 296.3, 145, 84.4, 76, 35.8, 1337.2, 23.5, 143.9, 973.6, 196.2]'),
(47, 1, 0, '[1947, 22.4, 18.3, 26, 39.1, 55.9, 130.1, 314.4, 290.4, 240, 69.8, 7.2, 22.6, 1236.3, 40.8, 121, 974.9, 99.6]'),
(48, 1, 0, '[1948, 25.2, 29, 39.5, 42.5, 91.3, 164.1, 347.7, 282.7, 178, 61.2, 71.1, 10, 1342.2, 54.2, 173.3, 972.4, 142.3]'),
(49, 1, 0, '[1949, 12.6, 28.8, 24.1, 53, 89.3, 164.3, 316.8, 243.2, 227, 95.1, 10.6, 4.7, 1269.6, 41.4, 166.4, 951.3, 110.5]'),
(50, 1, 0, '[1950, 35.4, 25.4, 36.7, 28.7, 49.4, 135.7, 331.6, 235.6, 202.6, 57.7, 27.5, 7.9, 1174.2, 60.8, 114.8, 905.5, 93.1]'),
(51, 1, 0, '[1951, 15.7, 12.1, 44.4, 54.4, 59.4, 163.3, 252.7, 222.8, 124.6, 73.9, 31.3, 5.8, 1060.6, 27.8, 158.3, 763.4, 111.1]'),
(52, 1, 0, '[1952, 10.5, 19.8, 37.4, 32.4, 69.7, 165.6, 286.6, 256.6, 120, 79.6, 9.2, 22.5, 1110.1, 30.3, 139.5, 828.9, 111.3]'),
(53, 1, 0, '[1953, 30.2, 10.6, 25.3, 38.3, 47.1, 162.2, 323.1, 299.2, 179.9, 85.8, 12.3, 8, 1222.1, 40.8, 110.7, 964.4, 106.1]'),
(54, 1, 0, '[1954, 37.6, 37.2, 17.1, 22.8, 53.9, 145.5, 297.2, 232, 246.7, 73.8, 3.6, 13.9, 1181.4, 74.9, 93.9, 921.3, 91.3]'),
(55, 1, 0, '[1955, 20.8, 4.1, 21.3, 30.6, 72.6, 177.7, 236.8, 313.8, 215.7, 146.3, 26.4, 9.3, 1275.4, 24.9, 124.5, 944, 182]'),
(56, 1, 0, '[1956, 17, 11.1, 31.5, 28.1, 85.5, 211, 354.1, 254.3, 163.9, 150.1, 44, 11.9, 1362.6, 28.1, 145, 983.3, 206.1]'),
(57, 1, 0, '[1957, 31.1, 10.9, 24.2, 39.5, 71.2, 153.2, 300.8, 265.4, 131.7, 64, 28.6, 11.3, 1131.9, 42, 134.9, 851.1, 103.8]'),
(58, 1, 0, '[1958, 12.4, 16.5, 19.1, 36.9, 80.5, 123.7, 316.9, 324.9, 225.7, 114.7, 30, 10.9, 1312.3, 28.9, 136.5, 991.3, 155.7]'),
(59, 1, 0, '[1959, 31.8, 23.8, 21.3, 25.9, 75.3, 169.8, 375.5, 265.1, 237.3, 119.7, 26, 5.3, 1376.9, 55.6, 122.6, 1047.7, 151.1]'),
(60, 1, 0, '[1960, 13.8, 2.7, 35.2, 20, 57.7, 157.3, 320, 252.9, 184.7, 68.5, 33.7, 8.3, 1154.8, 16.5, 112.8, 914.9, 110.5]'),
(61, 1, 0, '[1961, 26.1, 34.8, 26, 28.5, 77.6, 192.9, 336.6, 287.6, 234.9, 122.2, 21.7, 10.4, 1399.2, 60.9, 132.1, 1052, 154.2]'),
(62, 1, 0, '[1962, 12.6, 21.6, 16, 43.6, 70.8, 137.1, 281.6, 276.9, 211, 78.4, 18.3, 29.9, 1198, 34.3, 130.4, 906.6, 126.7]'),
(63, 1, 0, '[1963, 6.8, 9.8, 41.7, 50.6, 60.9, 168, 258.6, 316.7, 164.9, 99.1, 28.4, 15.5, 1220.9, 16.6, 153.1, 908.2, 142.9]'),
(64, 1, 0, '[1964, 18.6, 14.1, 19, 40, 52.1, 177.2, 345.7, 273.7, 200.4, 67.4, 22.8, 13.3, 1244.4, 32.7, 111.1, 997, 103.5]'),
(65, 1, 0, '[1965, 11.8, 28.1, 26.7, 45.1, 52.7, 116.1, 270.1, 192.8, 129.5, 34, 18.2, 22.2, 947.4, 39.9, 124.6, 708.5, 74.4]'),
(66, 1, 0, '[1966, 13.1, 25.4, 20.3, 30.6, 57.2, 178.8, 252.5, 212.5, 143.9, 56.1, 51, 16.7, 1058, 38.5, 108, 787.8, 123.7]'),
(67, 1, 0, '[1967, 11.1, 14.2, 63.3, 29.5, 42.8, 144, 305.6, 264.3, 170.3, 40.6, 12.1, 56.1, 1154, 25.3, 135.6, 884.2, 108.9]'),
(68, 1, 0, '[1968, 29.4, 19.8, 27.5, 32.6, 46.7, 149.6, 309.9, 212.8, 129.5, 67.1, 21.8, 12.6, 1059.3, 49.2, 106.8, 801.7, 101.6]'),
(69, 1, 0, '[1969, 12.7, 14.5, 20.1, 39.7, 63.4, 130.2, 317.8, 273.4, 172.7, 55, 35.8, 12.7, 1147.8, 27.2, 123.1, 894, 103.4]'),
(70, 1, 0, '[1970, 23.2, 27.3, 25.9, 29.2, 69.7, 215.9, 245.6, 313, 212.7, 75.3, 15.7, 1.6, 1255, 50.5, 124.8, 987.1, 92.6]'),
(71, 1, 0, '[1971, 16.1, 23.6, 10.8, 52.8, 75, 229.9, 267.2, 267.3, 146.5, 99.9, 15.9, 12, 1216.9, 39.7, 138.6, 910.8, 127.8]'),
(72, 1, 0, '[1972, 10.3, 27.6, 21.6, 37.1, 55.3, 123.3, 204, 219.5, 127.5, 65.7, 31.4, 23.7, 947.1, 37.8, 114, 674.3, 120.9]'),
(73, 1, 0, '[1973, 21, 21.8, 21.2, 27.5, 56.5, 149.9, 277.4, 311, 182.1, 114.6, 18.9, 17.7, 1219.5, 42.8, 105.2, 920.3, 151.2]'),
(74, 1, 0, '[1974, 16.1, 12.9, 20.5, 33.7, 64.2, 122, 283.6, 232.5, 145.3, 101.6, 10.7, 12.1, 1055.3, 29.1, 118.4, 783.4, 124.4]'),
(75, 1, 0, '[1975, 15.4, 20.8, 28.7, 28.3, 50.2, 175.6, 310.7, 292.5, 224.6, 121.9, 22.8, 3.3, 1294.8, 36.1, 107.3, 1003.4, 148]'),
(76, 1, 0, '[1976, 11.5, 24.5, 25.5, 36.3, 45.4, 160.3, 294.1, 294, 144.2, 33, 55, 7.6, 1131.6, 36, 107.3, 892.7, 95.6]'),
(77, 1, 0, '[1977, 21, 10.2, 14.6, 68.3, 84.4, 187.2, 323.4, 245.4, 147.8, 85.6, 65.8, 16.1, 1269.7, 31.2, 167.3, 903.8, 167.4]'),
(78, 1, 0, '[1978, 12.3, 27, 44.2, 33.1, 60.2, 208.8, 290, 282, 161.9, 49.1, 49.9, 18.8, 1237.2, 39.3, 137.4, 942.7, 117.8]'),
(79, 1, 0, '[1979, 20.9, 35, 28.9, 21.2, 54.2, 140.5, 239.6, 210.6, 136.8, 51.8, 76.1, 14.4, 1030.2, 55.9, 104.3, 727.6, 142.4]'),
(80, 1, 0, '[1980, 12.8, 22.3, 32.5, 34.6, 55.3, 227.8, 295, 263.8, 145.7, 49.3, 24.2, 19, 1182.3, 35.1, 122.5, 932.4, 92.4]'),
(81, 1, 0, '[1981, 29.3, 20.4, 48, 37.3, 67.1, 151.3, 309.1, 237, 184.5, 45.1, 27.4, 14, 1170.7, 49.7, 152.4, 882, 86.6]'),
(82, 1, 0, '[1982, 23.8, 24.2, 45.7, 49.8, 59, 137.8, 230.8, 276.9, 124.9, 51.7, 46, 13.9, 1084.4, 48, 154.5, 770.4, 111.5]'),
(83, 1, 0, '[1983, 18.5, 23.3, 43.4, 57, 70.1, 150.8, 282.2, 304.3, 251.6, 85.9, 10.8, 22.9, 1320.9, 41.7, 170.5, 988.9, 119.7]'),
(84, 1, 0, '[1984, 19, 35.9, 22.8, 45.3, 60.4, 192.3, 291.9, 256.5, 144.6, 61, 15.7, 15.3, 1160.8, 54.9, 128.5, 885.4, 92]'),
(85, 1, 0, '[1985, 23.2, 9.9, 20.1, 39.5, 63, 156.5, 290.1, 231.7, 149.6, 114.1, 18.8, 28.4, 1144.9, 33.1, 122.6, 827.9, 161.4]'),
(86, 1, 0, '[1986, 15.5, 36.6, 29.9, 50, 49.4, 182.6, 264.2, 228.3, 128.4, 74.7, 49.6, 28.4, 1137.6, 52, 129.3, 803.6, 152.7]'),
(87, 1, 0, '[1987, 13.2, 23.8, 28.8, 43.9, 67, 133.9, 223.2, 242.1, 152.2, 94.4, 44.4, 21.9, 1088.9, 37, 139.8, 751.4, 160.7]'),
(88, 1, 0, '[1988, 10.4, 28.7, 53.7, 41.7, 70.4, 161.8, 374.8, 295.3, 217.7, 53.6, 16.2, 17.8, 1342.1, 39.1, 165.8, 1049.6, 87.7]'),
(89, 1, 0, '[1989, 15.4, 15.3, 28.8, 34.6, 57.5, 184.7, 302.3, 236.2, 163.1, 51.9, 20.3, 17.2, 1127.4, 30.7, 121, 886.3, 89.4]'),
(90, 1, 0, '[1990, 16, 44.2, 54, 43.8, 112.9, 191.3, 282.9, 293.6, 197.4, 104.1, 30.2, 31, 1401.4, 60.3, 210.7, 965.2, 165.3]'),
(91, 1, 0, '[1991, 14.3, 28.1, 27.8, 51.7, 68.9, 184.7, 279.2, 268.1, 140.7, 61.8, 30.2, 14.7, 1170.2, 42.3, 148.5, 872.7, 106.8]'),
(92, 1, 0, '[1992, 16, 16.5, 24.8, 26.1, 59.3, 139.7, 262.5, 274, 171.7, 64.7, 41.6, 5.6, 1102.7, 32.5, 110.2, 848, 112]'),
(93, 1, 0, '[1993, 18.2, 25.6, 41.6, 27, 71.3, 172.1, 305.4, 203.2, 208.5, 87.9, 30.5, 16.5, 1207.8, 43.8, 139.9, 889.3, 134.9]'),
(94, 1, 0, '[1994, 25, 27.9, 25.2, 45.9, 53.1, 205.7, 350, 282.2, 149.4, 82.8, 25.5, 22.6, 1295.3, 52.9, 124.1, 987.4, 130.9]'),
(95, 1, 0, '[1995, 31.3, 29.4, 28.3, 32.4, 82.4, 143.3, 323.4, 269, 179, 78, 36.8, 9.2, 1242.4, 60.7, 143, 914.7, 123.9]'),
(96, 1, 0, '[1996, 22.9, 23.2, 32.1, 31.4, 56, 185.7, 262.1, 292.4, 146.1, 100.5, 13.6, 16.9, 1182.9, 46.1, 119.6, 886.2, 130.9]'),
(97, 1, 0, '[1997, 14.3, 10.4, 30.3, 46, 48.6, 171.7, 281.5, 261.9, 151.4, 61.1, 57.6, 48.3, 1183.1, 24.7, 124.8, 866.5, 167]'),
(98, 1, 0, '[1998, 16.4, 28.2, 39.1, 36.3, 49.2, 163.9, 278.4, 243.8, 196.5, 107.4, 39.3, 10.3, 1208.8, 44.6, 124.6, 882.6, 157]'),
(99, 1, 0, '[1999, 13.7, 11.2, 8.8, 19.3, 94.9, 169.9, 261.7, 213.2, 183, 117.2, 20, 3.7, 1116.6, 24.9, 122.9, 827.9, 141]'),
(100, 1, 0, '[2000, 18.4, 28.2, 17.9, 34.7, 71.6, 179, 263.5, 221.1, 134.5, 41.9, 14.6, 10, 1035.4, 46.6, 124.3, 798.1, 66.4]'),
(101, 1, 0, '[2001, 6.7, 11.6, 19.9, 44.6, 62.9, 221.2, 281.1, 205.5, 111, 100.4, 19.7, 16.1, 1100.7, 18.3, 127.4, 818.8, 136.2]'),
(102, 1, 0, '[2002, 17.1, 20.1, 23.8, 38.6, 59.8, 172.6, 143.8, 246.1, 137.9, 55.6, 15.6, 5, 935.9, 37.3, 122.1, 700.5, 76.1]'),
(103, 1, 0, '[2003, 7.3, 42.3, 36.7, 36.6, 40.1, 169.3, 306.5, 243.6, 183.4, 92.7, 11.5, 17.2, 1187.3, 49.6, 113.5, 902.9, 121.3]'),
(104, 1, 0, '[2004, 25.1, 10, 12.8, 55.2, 80.6, 171.1, 250.5, 254, 131.5, 95, 17.9, 2.8, 1106.5, 35.1, 148.6, 807.1, 115.7]'),
(105, 1, 0, '[2005, 28.1, 41.8, 42.5, 37.7, 46.1, 143.2, 334.1, 190.1, 206.9, 99.3, 27.2, 11.2, 1208.3, 69.9, 126.3, 874.3, 137.7]'),
(106, 1, 0, '[2006, 17.7, 11.9, 35.6, 32.7, 75, 141.8, 287.6, 281.3, 178.6, 51.8, 34.6, 13.1, 1161.6, 29.6, 143.2, 889.3, 99.5]'),
(107, 1, 0, '[2007, 1.7, 36.7, 35.2, 30.6, 46.8, 192.5, 286.2, 257.4, 206.8, 55.7, 14.4, 15.3, 1179.3, 38.3, 112.6, 943, 85.4]'),
(108, 1, 0, '[2008, 18.4, 19.3, 41.2, 29.5, 43.7, 202, 245, 265.8, 165.1, 51.6, 25.5, 11, 1118, 37.7, 114.5, 877.8, 88.1]'),
(109, 1, 0, '[2009, 12, 12, 14.2, 25.1, 56, 85.7, 280.7, 192.5, 139.4, 71.4, 53.7, 11.1, 953.7, 24, 95.3, 698.3, 136.1]'),
(110, 1, 0, '[2010, 7.5, 17, 14, 39, 73.8, 138.1, 300.7, 274.7, 197.7, 69, 61.4, 22.7, 1215.5, 24.5, 126.8, 911.1, 153.2]'),
(111, 1, 0, '[2011, 6.8, 25.8, 22.4, 41.1, 53.1, 183.5, 246, 284.9, 186.9, 38.1, 20.1, 7.6, 1116.3, 32.6, 116.6, 901.3, 65.8]'),
(112, 1, 0, '[2012, 26.5, 12.7, 11.3, 47.5, 31.7, 117.8, 250.2, 262.4, 193.5, 58.7, 30.7, 11.7, 1054.7, 39.2, 90.5, 823.9, 101.1]'),
(113, 2, 0, '[1901, 28.96, 23.27, 31.46, 31.27, 27.25]'),
(114, 2, 0, '[1902, 29.22, 25.75, 31.76, 31.09, 26.49]'),
(115, 2, 0, '[1903, 28.47, 24.24, 30.71, 30.92, 26.26]'),
(116, 2, 0, '[1904, 28.49, 23.62, 30.95, 30.67, 26.40]'),
(117, 2, 0, '[1905, 28.30, 22.25, 30.00, 31.33, 26.57]'),
(118, 2, 0, '[1906, 28.73, 23.03, 31.11, 30.86, 27.29]'),
(119, 2, 0, '[1907, 28.65, 24.23, 29.92, 30.81, 27.36]'),
(120, 2, 0, '[1908, 28.83, 24.42, 31.43, 30.72, 26.64]'),
(121, 2, 0, '[1909, 28.39, 23.52, 31.02, 30.33, 26.88]'),
(122, 2, 0, '[1910, 28.53, 24.20, 31.14, 30.48, 26.20]'),
(123, 2, 0, '[1911, 28.62, 23.90, 30.70, 31.14, 26.31]'),
(124, 2, 0, '[1912, 28.95, 24.88, 31.10, 31.15, 26.57]'),
(125, 2, 0, '[1913, 28.67, 24.25, 30.90, 30.92, 26.42]'),
(126, 2, 0, '[1914, 28.66, 24.59, 30.73, 30.84, 26.40]'),
(127, 2, 0, '[1915, 28.94, 23.22, 31.06, 31.51, 27.18]'),
(128, 2, 0, '[1916, 28.82, 24.57, 31.88, 30.52, 26.32]'),
(129, 2, 0, '[1917, 28.11, 24.52, 30.06, 30.24, 25.74]'),
(130, 2, 0, '[1918, 28.66, 23.57, 30.68, 31.11, 26.77]'),
(131, 2, 0, '[1919, 28.66, 23.71, 31.17, 30.80, 26.60]'),
(132, 2, 0, '[1920, 28.76, 23.64, 30.40, 31.08, 27.45]'),
(133, 2, 0, '[1921, 28.86, 23.91, 32.05, 30.81, 26.43]'),
(134, 2, 0, '[1922, 28.80, 24.43, 31.21, 30.90, 26.38]'),
(135, 2, 0, '[1923, 28.74, 23.73, 31.40, 30.98, 26.43]'),
(136, 2, 0, '[1924, 28.80, 23.94, 31.44, 30.96, 26.49]'),
(137, 2, 0, '[1925, 28.67, 23.57, 31.47, 30.67, 26.59]'),
(138, 2, 0, '[1926, 28.70, 24.73, 30.21, 31.14, 26.61]'),
(139, 2, 0, '[1927, 28.59, 23.76, 30.72, 30.80, 26.72]'),
(140, 2, 0, '[1928, 28.98, 24.21, 31.51, 31.14, 26.73]'),
(141, 2, 0, '[1929, 28.76, 23.53, 31.72, 31.03, 26.27]'),
(142, 2, 0, '[1930, 28.65, 23.20, 30.94, 30.98, 26.90]'),
(143, 2, 0, '[1931, 29.15, 24.55, 31.71, 31.16, 26.97]'),
(144, 2, 0, '[1932, 29.09, 24.51, 31.17, 31.25, 27.18]'),
(145, 2, 0, '[1933, 28.49, 24.13, 30.42, 30.41, 26.92]'),
(146, 2, 0, '[1934, 29.03, 24.53, 31.28, 31.22, 26.94]'),
(147, 2, 0, '[1935, 28.76, 23.41, 31.15, 30.85, 26.88]'),
(148, 2, 0, '[1936, 28.71, 24.11, 31.17, 30.68, 26.69]'),
(149, 2, 0, '[1937, 28.70, 24.13, 30.84, 31.22, 26.26]'),
(150, 2, 0, '[1938, 28.70, 23.31, 31.74, 30.59, 26.71]'),
(151, 2, 0, '[1939, 28.85, 24.25, 30.76, 31.06, 27.05]'),
(152, 2, 0, '[1940, 28.88, 24.46, 30.66, 30.93, 27.24]'),
(153, 2, 0, '[1941, 29.46, 24.37, 32.12, 31.37, 27.62]'),
(154, 2, 0, '[1942, 28.98, 24.03, 31.80, 30.99, 27.23]'),
(155, 2, 0, '[1943, 28.80, 24.02, 30.80, 30.83, 27.33]'),
(156, 2, 0, '[1944, 28.89, 23.62, 31.03, 31.25, 27.16]'),
(157, 2, 0, '[1945, 28.97, 23.86, 31.19, 31.48, 26.82]'),
(158, 2, 0, '[1946, 29.37, 25.49, 31.50, 31.23, 27.30]'),
(159, 2, 0, '[1947, 28.84, 23.99, 31.78, 31.20, 26.70]'),
(160, 2, 0, '[1948, 28.73, 23.62, 31.27, 30.84, 26.77]'),
(161, 2, 0, '[1949, 28.89, 24.49, 31.27, 30.88, 26.79]'),
(162, 2, 0, '[1950, 28.47, 24.02, 30.72, 30.48, 26.58]'),
(163, 2, 0, '[1951, 29.09, 24.16, 30.67, 31.13, 27.77]'),
(164, 2, 0, '[1952, 29.16, 25.17, 31.13, 31.11, 27.26]'),
(165, 2, 0, '[1953, 29.43, 24.71, 32.19, 31.12, 27.56]'),
(166, 2, 0, '[1954, 28.92, 24.20, 31.89, 30.90, 26.46]'),
(167, 2, 0, '[1955, 28.76, 24.90, 30.88, 30.72, 26.59]'),
(168, 2, 0, '[1956, 28.63, 24.40, 31.53, 30.25, 26.37]'),
(169, 2, 0, '[1957, 28.64, 23.87, 30.41, 31.07, 26.82]'),
(170, 2, 0, '[1958, 29.33, 25.43, 31.73, 31.23, 27.01]'),
(171, 2, 0, '[1959, 29.02, 24.03, 31.69, 30.99, 27.03]'),
(172, 2, 0, '[1960, 29.31, 25.48, 31.16, 31.29, 27.36]'),
(173, 2, 0, '[1961, 28.72, 24.17, 31.47, 30.75, 26.30]'),
(174, 2, 0, '[1962, 28.89, 24.24, 31.31, 31.08, 26.65]'),
(175, 2, 0, '[1963, 29.04, 24.73, 30.94, 31.28, 27.00]'),
(176, 2, 0, '[1964, 29.09, 24.29, 31.89, 30.82, 27.20]'),
(177, 2, 0, '[1965, 29.16, 24.67, 30.73, 31.37, 27.62]'),
(178, 2, 0, '[1966, 29.41, 25.54, 31.69, 31.24, 27.26]'),
(179, 2, 0, '[1967, 29.14, 25.31, 31.04, 31.32, 26.90]'),
(180, 2, 0, '[1968, 29.07, 23.68, 31.24, 31.54, 27.19]'),
(181, 2, 0, '[1969, 29.61, 24.99, 32.02, 31.55, 27.71]'),
(182, 2, 0, '[1970, 29.47, 25.19, 32.03, 31.16, 27.50]'),
(183, 2, 0, '[1971, 29.15, 24.99, 31.58, 30.91, 27.17]'),
(184, 2, 0, '[1972, 29.31, 24.49, 31.49, 31.66, 27.21]'),
(185, 2, 0, '[1973, 29.44, 25.35, 32.19, 31.28, 26.97]'),
(186, 2, 0, '[1974, 29.26, 24.34, 31.92, 31.39, 27.03]'),
(187, 2, 0, '[1975, 28.89, 24.12, 31.62, 30.66, 26.99]'),
(188, 2, 0, '[1976, 29.27, 24.61, 31.45, 31.09, 27.76]'),
(189, 2, 0, '[1977, 29.41, 25.15, 31.65, 31.22, 27.59]'),
(190, 2, 0, '[1978, 29.23, 24.36, 31.57, 31.11, 27.64]'),
(191, 2, 0, '[1979, 29.63, 24.99, 31.70, 31.87, 27.67]'),
(192, 2, 0, '[1980, 29.58, 25.21, 32.20, 31.36, 27.51]'),
(193, 2, 0, '[1981, 29.32, 24.90, 31.64, 31.34, 27.24]'),
(194, 2, 0, '[1982, 29.12, 24.51, 30.79, 31.55, 27.26]'),
(195, 2, 0, '[1983, 29.11, 24.62, 30.84, 31.48, 27.24]'),
(196, 2, 0, '[1984, 29.28, 24.11, 32.12, 31.09, 27.46]'),
(197, 2, 0, '[1985, 29.61, 25.29, 32.51, 31.28, 27.35]'),
(198, 2, 0, '[1986, 29.33, 24.64, 31.58, 31.44, 27.40]'),
(199, 2, 0, '[1987, 29.72, 25.07, 31.37, 32.24, 27.82]'),
(200, 2, 0, '[1988, 29.55, 25.39, 31.75, 31.34, 27.76]'),
(201, 2, 0, '[1989, 29.18, 24.51, 31.35, 31.11, 27.57]'),
(202, 2, 0, '[1990, 29.14, 24.99, 30.84, 31.18, 27.50]'),
(203, 2, 0, '[1991, 29.32, 24.74, 31.46, 31.45, 27.40]'),
(204, 2, 0, '[1992, 29.23, 24.60, 31.32, 31.28, 27.49]'),
(205, 2, 0, '[1993, 29.55, 25.31, 31.61, 31.47, 27.74]'),
(206, 2, 0, '[1994, 29.46, 25.09, 31.85, 31.31, 27.52]'),
(207, 2, 0, '[1995, 30.18, 25.68, 32.40, 32.01, 28.52]'),
(208, 2, 0, '[1996, 29.58, 26.30, 32.07, 31.19, 27.29]'),
(209, 2, 0, '[1997, 29.05, 24.64, 31.26, 31.77, 26.65]'),
(210, 2, 0, '[1998, 29.70, 24.97, 31.89, 31.75, 27.83]'),
(211, 2, 0, '[1999, 29.81, 25.11, 32.45, 31.55, 27.95]'),
(212, 2, 0, '[2000, 29.75, 24.82, 32.22, 31.25, 28.53]'),
(213, 2, 0, '[2001, 29.99, 25.88, 32.61, 31.61, 28.13]'),
(214, 2, 0, '[2002, 30.23, 25.37, 33.06, 32.02, 28.36]'),
(215, 2, 0, '[2003, 29.75, 25.32, 32.05, 31.72, 27.70]'),
(216, 2, 0, '[2004, 29.79, 25.49, 32.69, 31.42, 27.65]'),
(217, 2, 0, '[2005, 29.60, 24.96, 31.81, 31.84, 27.50]'),
(218, 2, 0, '[2006, 30.06, 27.44, 32.08, 31.39, 27.78]'),
(219, 2, 0, '[2007, 29.84, 25.73, 32.32, 31.40, 28.03]'),
(220, 2, 0, '[2008, 29.64, 24.72, 32.11, 31.25, 28.29]'),
(221, 2, 0, '[2009, 30.29, 26.50, 32.57, 32.24, 27.96]'),
(222, 2, 0, '[2010, 30.12, 25.96, 33.46, 31.43, 27.78]'),
(223, 2, 0, '[2011, 29.82, 25.33, 32.07, 31.55, 28.23]'),
(224, 2, 0, '[2012, 29.81, 25.03, 32.33, 31.77, 27.88]'),
(225, 3, 0, '[1901, 19.51, 14.16, 20.67, 23.38, 16.59]'),
(226, 3, 0, '[1902, 19.44, 13.64, 21.12, 23.28, 16.5]'),
(227, 3, 0, '[1903, 19.25, 13.87, 20.25, 23.4, 16.29]'),
(228, 3, 0, '[1904, 19.22, 13.71, 20.72, 22.96, 16.44]'),
(229, 3, 0, '[1905, 19.03, 12.81, 19.97, 23.43, 16.39]'),
(230, 3, 0, '[1906, 19.51, 13.71, 20.76, 23.45, 16.88]'),
(231, 3, 0, '[1907, 19.08, 14.46, 19.88, 22.99, 16.14]'),
(232, 3, 0, '[1908, 19.09, 13.67, 20.61, 23.19, 15.7]'),
(233, 3, 0, '[1909, 19.13, 13.33, 20.4, 22.97, 16.61]'),
(234, 3, 0, '[1910, 19.01, 13.68, 20.35, 23.15, 15.72]'),
(235, 3, 0, '[1911, 19.31, 13.8, 20.41, 23.26, 16.66]'),
(236, 3, 0, '[1912, 19.27, 14.56, 20.54, 23.12, 16.02]'),
(237, 3, 0, '[1913, 19.09, 13.91, 20.24, 22.96, 16.24]'),
(238, 3, 0, '[1914, 19.41, 14.03, 20.34, 23.47, 16.66]'),
(239, 3, 0, '[1915, 19.64, 13.73, 21, 23.72, 16.79]'),
(240, 3, 0, '[1916, 19.34, 13.64, 20.96, 23.31, 16.23]'),
(241, 3, 0, '[1917, 19.02, 13.6, 19.72, 23.29, 16.25]'),
(242, 3, 0, '[1918, 19.02, 13.24, 20.15, 23.06, 16.33]'),
(243, 3, 0, '[1919, 19.37, 14.22, 20.53, 23.33, 16.36]'),
(244, 3, 0, '[1920, 19.07, 13.79, 20.15, 23.02, 16.26]'),
(245, 3, 0, '[1921, 19.54, 13.85, 21.16, 23.18, 16.34]'),
(246, 3, 0, '[1922, 19.32, 14.31, 20.56, 23.27, 16.03]'),
(247, 3, 0, '[1923, 19.36, 13.88, 20.83, 23.24, 16.37]'),
(248, 3, 0, '[1924, 19.52, 14.11, 20.86, 23.42, 16.56]'),
(249, 3, 0, '[1925, 19.24, 13.05, 20.91, 23.18, 16.43]'),
(250, 3, 0, '[1926, 19.37, 14.63, 20.36, 23.69, 15.92]'),
(251, 3, 0, '[1927, 19.3, 13.81, 20.3, 23.18, 16.8]'),
(252, 3, 0, '[1928, 19.61, 14.57, 20.86, 23.23, 16.9]'),
(253, 3, 0, '[1929, 19.4, 13.72, 21, 23.17, 16.55]'),
(254, 3, 0, '[1930, 19.21, 13.27, 20.7, 23.1, 16.51]'),
(255, 3, 0, '[1931, 19.73, 14.52, 21.01, 23.44, 16.97]'),
(256, 3, 0, '[1932, 19.32, 13.72, 20.65, 23.36, 16.33]'),
(257, 3, 0, '[1933, 19.35, 14.08, 20.25, 23.34, 16.63]'),
(258, 3, 0, '[1934, 19.22, 13.78, 20.5, 23.37, 16.16]'),
(259, 3, 0, '[1935, 19.21, 13.84, 20.39, 23.07, 16.41]'),
(260, 3, 0, '[1936, 19.53, 13.96, 20.88, 23.18, 17.03]'),
(261, 3, 0, '[1937, 19.25, 14.11, 20.39, 23.4, 16.02]'),
(262, 3, 0, '[1938, 19.28, 13.61, 21.25, 23.14, 15.95]'),
(263, 3, 0, '[1939, 19.16, 13.95, 20.08, 23.23, 16.29]'),
(264, 3, 0, '[1940, 19.24, 13.57, 20.31, 23.25, 16.62]'),
(265, 3, 0, '[1941, 19.85, 14.25, 21.53, 23.52, 17]'),
(266, 3, 0, '[1942, 19.45, 14.1, 21.19, 23.37, 16.2]'),
(267, 3, 0, '[1943, 19.06, 13.75, 20.33, 23.1, 16.02]'),
(268, 3, 0, '[1944, 19.18, 13.45, 20.39, 23.29, 16.38]'),
(269, 3, 0, '[1945, 18.88, 12.93, 20.26, 23.36, 15.51]'),
(270, 3, 0, '[1946, 19.38, 13.55, 20.73, 23.25, 16.78]'),
(271, 3, 0, '[1947, 19.23, 13.57, 21.05, 23.46, 16.08]'),
(272, 3, 0, '[1948, 19.49, 14.03, 20.81, 23.32, 16.7]'),
(273, 3, 0, '[1949, 19.28, 13.87, 21.01, 23.29, 15.8]'),
(274, 3, 0, '[1950, 18.95, 13.39, 20.28, 23.26, 15.72]'),
(275, 3, 0, '[1951, 19.36, 13.2, 20.27, 23.24, 17.16]'),
(276, 3, 0, '[1952, 19.51, 14.53, 20.91, 23.39, 16.26]'),
(277, 3, 0, '[1953, 19.71, 14.22, 21.55, 23.52, 16.46]'),
(278, 3, 0, '[1954, 19.33, 14.02, 21.11, 23.28, 15.84]'),
(279, 3, 0, '[1955, 19.19, 14.02, 20.29, 23.23, 16.13]'),
(280, 3, 0, '[1956, 19.29, 13.25, 21.09, 23.07, 16.46]'),
(281, 3, 0, '[1957, 19.3, 13.6, 20.09, 23.23, 17.06]'),
(282, 3, 0, '[1958, 19.92, 14.58, 21.18, 23.64, 17.26]'),
(283, 3, 0, '[1959, 19.6, 13.82, 20.93, 23.48, 16.96]'),
(284, 3, 0, '[1960, 19.27, 13.99, 20.25, 23.39, 16.32]'),
(285, 3, 0, '[1961, 19.27, 13.79, 20.76, 23.38, 15.96]'),
(286, 3, 0, '[1962, 19.2, 13.52, 20.53, 23.21, 16.32]'),
(287, 3, 0, '[1963, 19.27, 13.39, 20.22, 23.14, 17.08]'),
(288, 3, 0, '[1964, 19.11, 13.38, 20.87, 23.01, 15.96]'),
(289, 3, 0, '[1965, 18.97, 13.76, 19.76, 22.8, 16.57]'),
(290, 3, 0, '[1966, 19.31, 14.32, 20.46, 23.12, 16.4]'),
(291, 3, 0, '[1967, 19.08, 13.57, 20.07, 23.08, 16.44]'),
(292, 3, 0, '[1968, 18.83, 12.82, 20.02, 22.94, 16.18]'),
(293, 3, 0, '[1969, 19.32, 13.4, 20.76, 23.17, 16.69]'),
(294, 3, 0, '[1970, 19.16, 13.92, 20.77, 23.11, 15.76]'),
(295, 3, 0, '[1971, 18.76, 13.12, 20.16, 22.72, 15.84]'),
(296, 3, 0, '[1972, 18.9, 12.67, 20.1, 22.91, 16.53]'),
(297, 3, 0, '[1973, 19.38, 14.12, 20.88, 23.34, 16.09]'),
(298, 3, 0, '[1974, 18.76, 12.77, 20.57, 22.67, 15.73]'),
(299, 3, 0, '[1975, 18.61, 13.26, 20.03, 22.5, 15.58]'),
(300, 3, 0, '[1976, 18.9, 13.18, 19.83, 22.66, 16.76]'),
(301, 3, 0, '[1977, 19.31, 13.51, 20.42, 23.09, 17.02]'),
(302, 3, 0, '[1978, 19.24, 13.5, 20.42, 23.07, 16.79]'),
(303, 3, 0, '[1979, 19.55, 13.94, 20.3, 23.27, 17.56]'),
(304, 3, 0, '[1980, 19.53, 14.07, 20.97, 23.22, 16.82]'),
(305, 3, 0, '[1981, 19.25, 13.94, 20.67, 23.14, 16.17]'),
(306, 3, 0, '[1982, 19.21, 13.77, 20.06, 23.1, 16.81]'),
(307, 3, 0, '[1983, 19.14, 13.57, 20.1, 23.41, 16.2]'),
(308, 3, 0, '[1984, 19.25, 13.62, 20.9, 23.12, 16.18]'),
(309, 3, 0, '[1985, 19.3, 13.93, 20.94, 22.98, 16.33]'),
(310, 3, 0, '[1986, 19.09, 13.61, 20.31, 22.92, 16.43]'),
(311, 3, 0, '[1987, 19.42, 13.81, 20.32, 23.52, 16.8]'),
(312, 3, 0, '[1988, 19.33, 14.07, 20.72, 23.17, 16.33]'),
(313, 3, 0, '[1989, 18.95, 13.02, 20.18, 22.9, 16.41]'),
(314, 3, 0, '[1990, 19.29, 13.91, 20.24, 23.18, 16.74]'),
(315, 3, 0, '[1991, 19.29, 13.73, 20.63, 23.29, 16.34]'),
(316, 3, 0, '[1992, 19.15, 13.58, 20.07, 23.14, 16.62]'),
(317, 3, 0, '[1993, 19.34, 13.91, 20.41, 23.25, 16.69]'),
(318, 3, 0, '[1994, 19.48, 14.45, 20.76, 23.32, 16.43]'),
(319, 3, 0, '[1995, 20.39, 14.99, 21.47, 24.16, 17.84]'),
(320, 3, 0, '[1996, 19.55, 15.28, 20.93, 23.29, 16.24]'),
(321, 3, 0, '[1997, 19.21, 13.13, 20.13, 23.45, 17.21]'),
(322, 3, 0, '[1998, 19.84, 14.49, 20.97, 23.67, 17.03]'),
(323, 3, 0, '[1999, 19.53, 14.43, 20.86, 23.24, 16.65]'),
(324, 3, 0, '[2000, 19.48, 13.84, 20.77, 23.25, 16.88]'),
(325, 3, 0, '[2001, 19.49, 13.6, 21.04, 23.36, 16.95]'),
(326, 3, 0, '[2002, 19.78, 13.93, 21.38, 23.4, 16.79]'),
(327, 3, 0, '[2003, 19.7, 14.32, 21, 23.56, 16.76]'),
(328, 3, 0, '[2004, 19.69, 14.39, 21.3, 23.27, 16.84]'),
(329, 3, 0, '[2005, 19.58, 14.62, 20.84, 23.46, 16.43]'),
(330, 3, 0, '[2006, 20.07, 15.48, 20.96, 23.44, 17.56]'),
(331, 3, 0, '[2007, 19.69, 14.47, 21.06, 23.59, 16.62]'),
(332, 3, 0, '[2008, 19.6, 13.6, 20.82, 23.3, 17.43]'),
(333, 3, 0, '[2009, 19.94, 14.95, 21.15, 23.59, 17.2]'),
(334, 3, 0, '[2010, 20.15, 14.51, 22.09, 23.57, 17.42]'),
(335, 3, 0, '[2011, 19.58, 13.84, 20.68, 23.56, 17.16]'),
(336, 3, 0, '[2012, 19.54, 13.68, 20.78, 23.68, 16.8]');
/*!40000 ALTER TABLE `document_model_tuple` ENABLE KEYS */;
-- Dumping structure for table datarepo.location_index
CREATE TABLE IF NOT EXISTS `location_index` (
`location_index_id` int(20) NOT NULL AUTO_INCREMENT,
`country` varchar(50) DEFAULT NULL,
`state` varchar(50) DEFAULT NULL,
`district` varchar(50) DEFAULT NULL,
`department` varchar(50) NOT NULL,
`dataset_name` varchar(50) NOT NULL,
`date_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
PRIMARY KEY (`location_index_id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=latin1;
-- Dumping data for table datarepo.location_index: ~2 rows (approximately)
/*!40000 ALTER TABLE `location_index` DISABLE KEYS */;
INSERT INTO `location_index` (`location_index_id`, `country`, `state`, `district`, `department`, `dataset_name`, `date_time`) VALUES
(1, 'India', '', '', 'Earth Science', 'Rainfall', '2013-11-10 22:51:53'),
(2, 'India', '', '', 'Earth Science', 'Max Temperature', '2013-11-10 22:52:31'),
(3, 'India', '', '', 'Earth Science', 'Min Temperature', '2013-11-10 23:17:53');
/*!40000 ALTER TABLE `location_index` ENABLE KEYS */;
-- Dumping structure for view datarepo.dataset_loc_view
-- Removing temporary table and create final VIEW structure
DROP TABLE IF EXISTS `dataset_loc_view`;
CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` VIEW `dataset_loc_view` AS SELECT * from location_index natural join dataset_keys ;
/*!40101 SET SQL_MODE=IFNULL(@OLD_SQL_MODE, '') */;
/*!40014 SET FOREIGN_KEY_CHECKS=IF(@OLD_FOREIGN_KEY_CHECKS IS NULL, 1, @OLD_FOREIGN_KEY_CHECKS) */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;