Repository navigation
Expand file tree
/
Copy pathdatabase_dump.txt
More file actions
4370 lines (4266 loc) · 246 KB
/
Copy pathdatabase_dump.txt
File metadata and controls
4370 lines (4266 loc) · 246 KB
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
786
787
788
789
790
791
792
793
794
795
796
797
798
799
800
801
802
803
804
805
806
807
808
809
810
811
812
813
814
815
816
817
818
819
820
821
822
823
824
825
826
827
828
829
830
831
832
833
834
835
836
837
838
839
840
841
842
843
844
845
846
847
848
849
850
851
852
853
854
855
856
857
858
859
860
861
862
863
864
865
866
867
868
869
870
871
872
873
874
875
876
877
878
879
880
881
882
883
884
885
886
887
888
889
890
891
892
893
894
895
896
897
898
899
900
901
902
903
904
905
906
907
908
909
910
911
912
913
914
915
916
917
918
919
920
921
922
923
924
925
926
927
928
929
930
931
932
933
934
935
936
937
938
939
940
941
942
943
944
945
946
947
948
949
950
951
952
953
954
955
956
957
958
959
960
961
962
963
964
965
966
967
968
969
970
971
972
973
974
975
976
977
978
979
980
981
982
983
984
985
986
987
988
989
990
991
992
993
994
995
996
997
998
999
1000
--
-- PostgreSQL database dump
--
-- Dumped from database version 14.2
-- Dumped by pg_dump version 14.2
SET statement_timeout = 0;
SET lock_timeout = 0;
SET idle_in_transaction_session_timeout = 0;
SET client_encoding = 'UTF8';
SET standard_conforming_strings = on;
SELECT pg_catalog.set_config('search_path', '', false);
SET check_function_bodies = false;
SET xmloption = content;
SET client_min_messages = warning;
SET row_security = off;
SET default_tablespace = '';
SET default_table_access_method = heap;
--
-- Name: country; Type: TABLE; Schema: public; Owner: postgres
--
CREATE TABLE public.country (
country_key integer NOT NULL,
name character varying(255),
region character varying(255),
continent character varying(255),
currency character varying(255),
capital character varying(255),
total_population integer,
birth_rate double precision,
gross_national_income double precision,
life_expectancy_at_birth double precision,
labor_force_total integer,
human_capital_index integer,
population_grown_annual double precision
);
ALTER TABLE public.country OWNER TO postgres;
--
-- Name: education; Type: TABLE; Schema: public; Owner: postgres
--
CREATE TABLE public.education (
education_key integer NOT NULL,
total_literacy_rate double precision,
male_literacy_rate double precision,
female_literacy_rate double precision,
primary_school_enrollment double precision,
secondary_school_enrollment double precision,
post_secondary_school_enrollment double precision,
public_education_spending double precision,
pop_compuslory_school_age_total integer,
pop_offical_entrance_age_primary_total integer,
pop_offical_entrance_age_secondary_total integer,
teachers_primary_total integer,
teachers_secondary_total integer
);
ALTER TABLE public.education OWNER TO postgres;
--
-- Name: event; Type: TABLE; Schema: public; Owner: postgres
--
CREATE TABLE public.event (
event_key integer NOT NULL,
name character varying(255),
disaster_type character varying(255),
start_day integer,
end_day integer,
start_month integer,
end_month integer,
start_year integer,
end_year integer,
disaster_subgroup character varying(255),
total_deaths integer,
no_injured integer,
no_affected integer
);
ALTER TABLE public.event OWNER TO postgres;
--
-- Name: fact_table; Type: TABLE; Schema: public; Owner: postgres
--
CREATE TABLE public.fact_table (
month_key integer,
country_key integer,
education_key integer,
population_key integer,
quality_of_life_key integer,
health_key integer,
event_key integer,
quality_of_life integer,
development_index integer,
human_development_index integer
);
ALTER TABLE public.fact_table OWNER TO postgres;
--
-- Name: health; Type: TABLE; Schema: public; Owner: postgres
--
CREATE TABLE public.health (
health_key integer NOT NULL,
domestic_general_government_health_expenditure double precision,
hospital_beds double precision,
immunization_hepb3 double precision,
immunization_dpt double precision,
immunization_measles double precision,
immunization_pol3 double precision,
number_of_surgical_procedures double precision,
number_of_infant_deaths double precision,
number_of_stillbirths double precision,
number_of_deaths_ages_20_24 double precision,
physicians_per_1000 double precision,
prevalence_of_overweight double precision,
diabetes_prevalence double precision,
prevalence_of_hiv_total double precision,
adults_living_with_hiv double precision,
adults_newly_infected_with_hiv double precision,
children_living_with_hiv double precision,
children_newly_infected_with_hiv double precision
);
ALTER TABLE public.health OWNER TO postgres;
--
-- Name: month; Type: TABLE; Schema: public; Owner: postgres
--
CREATE TABLE public.month (
month_key integer NOT NULL,
name character varying(255),
month integer,
quarter integer,
year integer,
decade integer
);
ALTER TABLE public.month OWNER TO postgres;
--
-- Name: population; Type: TABLE; Schema: public; Owner: postgres
--
CREATE TABLE public.population (
population_key integer NOT NULL,
life_expectancy_at_birth_f double precision,
life_expectancy_at_birth_m double precision,
life_expectancy_at_birth_t double precision,
net_migration integer,
population_ages_0_14 integer,
population_ages_15_19 integer,
population_ages_20_24 integer,
population_ages_24_29 integer,
population_ages_30_34 integer,
population_ages_35_39 integer,
population_ages_40_44 integer,
population_ages_45_49 integer,
population_ages_50_54 integer,
population_ages_55_59 integer,
population_ages_60_64 integer,
population_ages_65_up integer,
rural_population double precision,
rural_population_growth_rate double precision,
rural_poverty_rate double precision,
urban_population double precision,
urban_population_growth_rate double precision,
urban_poverty_rate double precision
);
ALTER TABLE public.population OWNER TO postgres;
--
-- Name: quality_of_life; Type: TABLE; Schema: public; Owner: postgres
--
CREATE TABLE public.quality_of_life (
quality_of_life_key integer NOT NULL,
access_to_drinking_water double precision,
access_to_sanitation double precision,
access_to_basic_handwashing_facilities double precision,
unemployment_rate_f double precision,
unemployment_rate_m double precision,
unemployment_rate_t double precision,
maternal_leave_benefits double precision,
access_to_electricity_total double precision,
access_to_electricity_urban double precision,
access_to_electricity_rural double precision,
part_time_employment_t double precision,
part_time_employment_f double precision,
part_time_employment_m double precision
);
ALTER TABLE public.quality_of_life OWNER TO postgres;
--
-- Data for Name: country; Type: TABLE DATA; Schema: public; Owner: postgres
--
COPY public.country (country_key, name, region, continent, currency, capital, total_population, birth_rate, gross_national_income, life_expectancy_at_birth, labor_force_total, human_capital_index, population_grown_annual) FROM stdin;
0 Canada North America North America Canadian Dollar Ottawa 32243753 10.6 34810 80.1926829268293 20788261 \N 0.944466927450734
1 Canada North America North America Canadian Dollar Ottawa 32571174 10.9 38510 80.3439024390244 20492683 \N 1.01033450270045
2 Canada North America North America Canadian Dollar Ottawa 32889025 11.2 43090 80.5439024390244 20396697 \N 0.971135141368055
3 Canada North America North America Canadian Dollar Ottawa 33247118 11.3 45650 80.6951219512195 20218270 \N 1.08290711607014
4 Canada North America North America Canadian Dollar Ottawa 33628895 11.3 43230 80.9951219512195 19955331 \N 1.14175809912162
5 Canada North America North America Canadian Dollar Ottawa 34004889 11.1 44490 81.2463414634146 19747709 1 1.11186407517168
6 Canada North America North America Canadian Dollar Ottawa 34339328 11 47190 81.4487804878049 19629145 \N 0.978697786570341
7 Canada North America North America Canadian Dollar Ottawa 34714222 11 51080 81.6487804878049 19546552 \N 1.08581726304756
8 Canada North America North America Canadian Dollar Ottawa 35082954 10.8 52800 81.7487804878049 17821886 \N 1.05659125917789
9 Canada North America North America Canadian Dollar Ottawa 35437435 10.8 52200 81.8 19322866 \N 1.00533757867378
10 Canada North America North America Canadian Dollar Ottawa 35702908 10.7 47590 81.9 19147395 \N 0.746339477969813
11 Canada North America North America Canadian Dollar Ottawa 36109487 10.6 43890 81.9 19001081 \N 1.13234865466606
12 Canada North America North America Canadian Dollar Ottawa 36545295 10.3 42900 81.9 18799155 1 1.19968215419992
13 Canada North America North America Canadian Dollar Ottawa 37065178 10.1 45080 82.0487804878049 18667574 1 1.412548033188
14 Canada North America North America Canadian Dollar Ottawa 37593384 9.9 46550 82.0487804878049 18379605 \N 1.41501469953534
15 Canada North America North America Canadian Dollar Ottawa \N \N 43580 \N 18030705 1 1.08959148655862
16 United States North America North America U.S. Dollar Washington D.C 295516599 14 46180 77.4878048780488 166355636 \N 0.921713167161207
17 United States North America North America U.S. Dollar Washington D.C 298379912 14.3 47850 77.6878048780488 163738061 \N 0.964253917136075
18 United States North America North America U.S. Dollar Washington D.C 301231207 14.3 48520 77.9878048780488 164634753 \N 0.951055242772428
19 United States North America North America U.S. Dollar Washington D.C 304093966 14 49090 78.0390243902439 163395307 \N 0.945865287282592
20 United States North America North America U.S. Dollar Washington D.C 306771529 13.5 47830 78.390243902439 161836238 \N 0.876651298802912
21 United States North America North America U.S. Dollar Washington D.C 309327143 13 49140 78.5414634146342 159912569 1 0.829616674709795
22 United States North America North America U.S. Dollar Washington D.C 311583481 12.7 50630 78.6414634146341 158910317 \N 0.726786704810745
23 United States North America North America U.S. Dollar Washington D.C 313877662 12.6 52780 78.7414634146342 158252925 \N 0.733599941250847
24 United States North America North America U.S. Dollar Washington D.C 316059947 12.4 53980 78.7414634146342 151976098 \N 0.692860276624581
25 United States North America North America U.S. Dollar Washington D.C 318386329 12.5 55800 78.8414634146341 157841889 \N 0.733361519937424
26 United States North America North America U.S. Dollar Washington D.C 320738994 12.4 56640 78.690243902439 157163170 \N 0.73621730882542
27 United States North America North America U.S. Dollar Washington D.C 323071755 12.2 57130 78.5390243902439 157111093 \N 0.724676067451429
28 United States North America North America U.S. Dollar Washington D.C 325122128 11.8 59240 78.5390243902439 157079943 1 0.63264399508256
29 United States North America North America U.S. Dollar Washington D.C 326838199 11.6 63490 78.6390243902439 156907793 1 0.526435395564053
30 United States North America North America U.S. Dollar Washington D.C 328329953 11.4 65970 78.7878048780488 155224880 \N 0.455381285963537
31 United States North America North America U.S. Dollar Washington D.C \N \N 64530 \N 153855509 1 0.350911063312921
32 Mexico North America North America Mexican Peso Mexico City 106005199 21.741 8050 75.3 56596004 \N 1.4158169793862
33 Mexico North America North America Mexican Peso Mexico City 107560155 21.343 8690 75.296 53080123 \N 1.4562132376675
34 Mexico North America North America Mexican Peso Mexico City 109170503 20.973 9250 75.255 55190039 \N 1.48606353186843
35 Mexico North America North America Mexican Peso Mexico City 110815272 20.635 9780 75.194 54096291 \N 1.49536909755127
36 Mexico North America North America Mexican Peso Mexico City 112463886 20.327 8820 75.128 53507498 \N 1.47675580253545
37 Mexico North America North America Mexican Peso Mexico City 114092961 20.042 9040 75.065 52732562 1 1.43814066910139
38 Mexico North America North America Mexican Peso Mexico City 115695468 19.766 9310 75.011 51780845 \N 1.39478996981758
39 Mexico North America North America Mexican Peso Mexico City 117274156 19.488 10050 74.966 51318641 \N 1.35529442643505
40 Mexico North America North America Mexican Peso Mexico City 118827158 19.198 10270 74.93 42869547 \N 1.31555760676608
41 Mexico North America North America Mexican Peso Mexico City 120355137 18.892 10500 74.908 50512846 \N 1.27768636604222
42 Mexico North America North America Mexican Peso Mexico City 121858251 18.573 10160 74.904 49035908 \N 1.24116450246976
43 Mexico North America North America Mexican Peso Mexico City 123333379 18.245 9390 74.917 47982609 \N 1.20325950587092
44 Mexico North America North America Mexican Peso Mexico City 124777326 17.918 8920 74.947 47176107 1 1.16396694963579
45 Mexico North America North America Mexican Peso Mexico City 126190782 17.602 9180 74.992 46199021 1 1.12641479134149
46 Mexico North America North America Mexican Peso Mexico City 127575529 17.297 9470 75.054 45304973 \N 1.09136688717461
47 Mexico North America North America Mexican Peso Mexico City \N \N 8480 \N 44352857 1 1.05824003448927
48 Indonesia South East Asia Asia Indonesian Rupiah Jakarta 226289468 21.765 1220 67.334 136202238 \N 1.33630464499704
49 Indonesia South East Asia Asia Indonesian Rupiah Jakarta 229318262 21.624 1380 67.717 136459585 \N 1.32958175171436
50 Indonesia South East Asia Asia Indonesian Rupiah Jakarta 232374239 21.448 1600 68.105 133000453 \N 1.32383420748243
51 Indonesia South East Asia Asia Indonesian Rupiah Jakarta 235469755 21.251 1940 68.485 129127477 \N 1.32333051767653
52 Indonesia South East Asia Asia Indonesian Rupiah Jakarta 238620554 21.034 2150 68.853 126206202 \N 1.32921737939261
53 Indonesia South East Asia Asia Indonesian Rupiah Jakarta 241834226 20.795 2530 69.205 124807236 0 1.3377824768766
54 Indonesia South East Asia Asia Indonesian Rupiah Jakarta 245115988 20.526 3010 69.542 122770335 \N 1.34790440280692
55 Indonesia South East Asia Asia Indonesian Rupiah Jakarta 248451714 20.225 3580 69.866 120972115 \N 1.35169978721169
56 Indonesia South East Asia Asia Indonesian Rupiah Jakarta 251805314 19.893 3730 70.179 102184327 \N 1.34077086414715
57 Indonesia South East Asia Asia Indonesian Rupiah Jakarta 255128076 19.537 3620 70.481 120144188 \N 1.31094524538172
58 Indonesia South East Asia Asia Indonesian Rupiah Jakarta 258383257 19.165 3430 70.768 117225410 \N 1.26782970253157
59 Indonesia South East Asia Asia Indonesian Rupiah Jakarta 261556386 18.79 3400 71.035 114596174 \N 1.22059105826764
60 Indonesia South East Asia Asia Indonesian Rupiah Jakarta 264650969 18.422 3530 71.282 112039660 1 1.17619742367279
61 Indonesia South East Asia Asia Indonesian Rupiah Jakarta 267670549 18.072 3840 71.509 110890081 1 1.13450697951891
62 Indonesia South East Asia Asia Indonesian Rupiah Jakarta 270625567 17.746 4050 71.716 108893086 \N 1.09792643725552
63 Indonesia South East Asia Asia Indonesian Rupiah Jakarta \N \N 3870 \N 103776784 1 1.06517898587775
64 Angola Southern Africa Africa Angolan Kwanza Luanda 19433604 47.453 1370 50.165 13116712 \N 3.53760476294198
65 Angola Southern Africa Africa Angolan Kwanza Luanda 20149905 47.215 1810 51.143 13415460 \N 3.61958411912021
66 Angola Southern Africa Africa Angolan Kwanza Luanda 20905360 46.92 2460 52.177 12659938 \N 3.68060116794567
67 Angola Southern Africa Africa Angolan Kwanza Luanda 21695636 46.563 3030 53.243 12223456 \N 3.71055489102729
68 Angola Southern Africa Africa Angolan Kwanza Luanda 22514275 46.143 3170 54.311 11804734 \N 3.70384181489182
69 Angola Southern Africa Africa Angolan Kwanza Luanda 23356247 45.656 3230 55.35 11402381 \N 3.67149333263444
70 Angola Southern Africa Africa Angolan Kwanza Luanda 24220660 45.102 3410 56.33 11004723 \N 3.63415021537353
71 Angola Southern Africa Africa Angolan Kwanza Luanda 25107925 44.493 4170 57.236 10621492 \N 3.59775453949706
72 Angola Southern Africa Africa Angolan Kwanza Luanda 26015786 43.847 4780 58.054 7971743 \N 3.55199742692341
73 Angola Southern Africa Africa Angolan Kwanza Luanda 26941773 43.182 5010 58.776 10252532 \N 3.49744741099259
74 Angola Southern Africa Africa Angolan Kwanza Luanda 27884380 42.52 4520 59.398 9898462 \N 3.43886936840162
75 Angola Southern Africa Africa Angolan Kwanza Luanda 28842482 41.882 3770 59.925 9556361 \N 3.37826943218091
76 Angola Southern Africa Africa Angolan Kwanza Luanda 29816769 41.281 3450 60.379 9211974 0 3.32215836256296
77 Angola Southern Africa Africa Angolan Kwanza Luanda 30809787 40.729 3210 60.782 8879695 0 3.2761445879162
78 Angola Southern Africa Africa Angolan Kwanza Luanda 31825299 40.232 2970 61.147 8560730 \N 3.24291402840967
79 Angola Southern Africa Africa Angolan Kwanza Luanda \N \N 2140 \N 8257189 0 3.21853035205175
80 Cambodia South East Asia Asia Cambodian Riel Phnom Penh 13273355 26.147 460 63.088 9221528 \N 1.57088526587846
81 Cambodia South East Asia Asia Cambodian Riel Phnom Penh 13477705 26.101 520 63.927 9185555 \N 1.52781964519231
82 Cambodia South East Asia Asia Cambodian Riel Phnom Penh 13679953 26.05 590 64.697 9088032 \N 1.48946377519015
83 Cambodia South East Asia Asia Cambodian Riel Phnom Penh 13883835 25.947 670 65.394 8957446 \N 1.4793737229702
84 Cambodia South East Asia Asia Cambodian Riel Phnom Penh 14093605 25.767 700 66.014 8841029 \N 1.49959346560005
85 Cambodia South East Asia Asia Cambodian Riel Phnom Penh 14312205 25.502 750 66.56 8450593 \N 1.53915213466393
86 Cambodia South East Asia Asia Cambodian Riel Phnom Penh 14541421 25.166 810 67.043 8362550 \N 1.58885279806388
87 Cambodia South East Asia Asia Cambodian Riel Phnom Penh 14780454 24.797 880 67.48 8183449 \N 1.63044345047096
88 Cambodia South East Asia Asia Cambodian Riel Phnom Penh 15026330 24.422 970 67.888 6740643 \N 1.6498363404781
89 Cambodia South East Asia Asia Cambodian Riel Phnom Penh 15274506 24.048 1020 68.273 8280172 \N 1.6381168470705
90 Cambodia South East Asia Asia Cambodian Riel Phnom Penh 15521435 23.674 1060 68.637 8334043 \N 1.60368077118284
91 Cambodia South East Asia Asia Cambodian Riel Phnom Penh 15766290 23.291 1140 68.977 8087213 \N 1.56521446599878
92 Cambodia South East Asia Asia Cambodian Riel Phnom Penh 16009413 22.889 1230 69.289 7639032 0 1.53027452708458
93 Cambodia South East Asia Asia Cambodian Riel Phnom Penh 16249795 22.464 1380 69.57 7408126 0 1.49034315597302
94 Cambodia South East Asia Asia Cambodian Riel Phnom Penh 16486542 22.02 1530 69.823 7175247 \N 1.44641184190217
95 Cambodia South East Asia Asia Cambodian Riel Phnom Penh \N \N 1500 \N 6957261 0 1.39996509699246
96 Thailand South East Asia Asia Thai Baht Bangkok 65416189 12.87 2790 72.099 38777939 \N 0.645476031073619
97 Thailand South East Asia Asia Thai Baht Bangkok 65812540 12.632 3100 72.499 39036695 \N 0.604063162436286
98 Thailand South East Asia Asia Thai Baht Bangkok 66182064 12.407 3530 72.916 39029222 \N 0.559909199584795
99 Thailand South East Asia Asia Thai Baht Bangkok 66530980 12.188 3970 73.341 38609507 \N 0.525821416507964
100 Thailand South East Asia Asia Thai Baht Bangkok 66866834 11.971 4140 73.766 38766594 \N 0.503538550690529
101 Thailand South East Asia Asia Thai Baht Bangkok 67195032 11.757 4580 74.184 39026171 1 0.489622687570703
102 Thailand South East Asia Asia Thai Baht Bangkok 67518379 11.548 4950 74.593 39079265 \N 0.480052607326658
103 Thailand South East Asia Asia Thai Baht Bangkok 67835969 11.351 5520 74.992 39030418 \N 0.469272819846721
104 Thailand South East Asia Asia Thai Baht Bangkok 68144519 11.169 5720 75.378 37939157 \N 0.453815887976248
105 Thailand South East Asia Asia Thai Baht Bangkok 68438748 10.999 5760 75.747 40234291 \N 0.430842608467137
106 Thailand South East Asia Asia Thai Baht Bangkok 68714519 10.836 5710 76.091 40083149 \N 0.402136059408841
107 Thailand South East Asia Asia Thai Baht Bangkok 68971313 10.676 5700 76.403 38876587 \N 0.373014846949147
108 Thailand South East Asia Asia Thai Baht Bangkok 69209817 10.513 5970 76.683 39127730 1 0.345205219913361
109 Thailand South East Asia Asia Thai Baht Bangkok 69428454 10.344 6610 76.931 39082810 1 0.315406676202042
110 Thailand South East Asia Asia Thai Baht Bangkok 69625581 10.168 7260 77.15 38769324 \N 0.283525943067606
111 Thailand South East Asia Asia Thai Baht Bangkok \N \N 7040 \N 38013146 1 0.250165166562935
112 South Africa Southern Africa Africa South African Rand Cape Town 47880595 23.073 5610 53.447 22989511 \N 1.23774061841899
113 South Africa Southern Africa Africa South African Rand Cape Town 48489464 23.238 6310 53.795 21345809 \N 1.26362297174921
114 South Africa Southern Africa Africa South African Rand Cape Town 49119766 23.367 6630 54.452 22608291 \N 1.29149827532559
115 South Africa Southern Africa Africa South African Rand Cape Town 49779472 23.433 6660 55.36 22360602 \N 1.3341170229958
116 South Africa Southern Africa Africa South African Rand Cape Town 50477013 23.417 6510 56.46 21767744 \N 1.39153543190923
117 South Africa Southern Africa Africa South African Rand Cape Town 51216967 23.305 6880 57.669 21379123 0 1.45528193348191
118 South Africa Southern Africa Africa South African Rand Cape Town 52003759 23.097 7760 58.895 20542666 \N 1.52451405625199
119 South Africa Southern Africa Africa South African Rand Cape Town 52832659 22.815 8370 60.06 20110076 \N 1.58135367305518
120 South Africa Southern Africa Africa South African Rand Cape Town 53687125 22.483 8070 61.099 18550441 \N 1.60436736931238
121 South Africa Southern Africa Africa South African Rand Cape Town 54544184 22.113 7370 61.968 19550791 \N 1.58378739591921
122 South Africa Southern Africa Africa South African Rand Cape Town 55386369 21.719 6610 62.649 19095444 \N 1.53224277341692
123 South Africa Southern Africa Africa South African Rand Cape Town 56207649 21.314 5990 63.153 18827666 \N 1.47193342939738
124 South Africa Southern Africa Africa South African Rand Cape Town 57009751 20.908 5910 63.538 19114540 0 1.41694725378631
125 South Africa Southern Africa Africa South African Rand Cape Town 57792520 20.51 6340 63.857 19441243 0 1.36370321600461
126 South Africa Southern Africa Africa South African Rand Cape Town 58558267 20.129 6670 64.131 19146437 \N 1.31629200967216
127 South Africa Southern Africa Africa South African Rand Cape Town \N \N 6010 \N 18850913 0 1.27335626330668
128 Zimbabwe Southern Africa Africa Real Time Gross Settlement Dollar Harare 12076697 33.764 460 43.241 7156060 \N 0.471320321280555
129 Zimbabwe Southern Africa Africa Real Time Gross Settlement Dollar Harare 12155496 34.384 440 43.853 7204228 \N 0.650368522177336
130 Zimbabwe Southern Africa Africa Real Time Gross Settlement Dollar Harare 12255920 35.021 420 44.947 7028775 \N 0.822767237368314
131 Zimbabwe Southern Africa Africa Real Time Gross Settlement Dollar Harare 12379553 35.624 330 46.504 6909356 \N 1.00370744192155
132 Zimbabwe Southern Africa Africa Real Time Gross Settlement Dollar Harare 12526964 36.134 480 48.449 6802164 \N 1.18372810843137
133 Zimbabwe Southern Africa Africa Real Time Gross Settlement Dollar Harare 12697728 36.464 700 50.64 6709332 0 1.35396387573417
134 Zimbabwe Southern Africa Africa Real Time Gross Settlement Dollar Harare 12894323 36.526 1060 52.896 6611175 \N 1.53640571630567
135 Zimbabwe Southern Africa Africa Real Time Gross Settlement Dollar Harare 13115149 36.292 1260 55.032 6465320 \N 1.69808373055654
136 Zimbabwe Southern Africa Africa Real Time Gross Settlement Dollar Harare 13350378 35.768 1320 56.897 5852903 \N 1.77767247608678
137 Zimbabwe Southern Africa Africa Real Time Gross Settlement Dollar Harare 13586710 34.978 1370 58.41 6322675 \N 1.7547410030553
138 Zimbabwe Southern Africa Africa Real Time Gross Settlement Dollar Harare 13814642 33.981 1390 59.534 6184085 \N 1.66369350951633
139 Zimbabwe Southern Africa Africa Real Time Gross Settlement Dollar Harare 14030338 32.864 1390 60.294 6110955 \N 1.54929408793871
140 Zimbabwe Southern Africa Africa Real Time Gross Settlement Dollar Harare 14236599 31.732 1350 60.812 6052658 0 1.45940581314681
141 Zimbabwe Southern Africa Africa Real Time Gross Settlement Dollar Harare 14438812 30.676 1350 61.195 5999036 0 1.41038154233327
142 Zimbabwe Southern Africa Africa Real Time Gross Settlement Dollar Harare 14645473 29.747 1210 61.49 5949276 \N 1.42114188586135
143 Zimbabwe Southern Africa Africa Real Time Gross Settlement Dollar Harare \N \N 1140 \N 5901376 0 1.47387141587655
\.
--
-- Data for Name: education; Type: TABLE DATA; Schema: public; Owner: postgres
--
COPY public.education (education_key, total_literacy_rate, male_literacy_rate, female_literacy_rate, primary_school_enrollment, secondary_school_enrollment, post_secondary_school_enrollment, public_education_spending, pop_compuslory_school_age_total, pop_offical_entrance_age_primary_total, pop_offical_entrance_age_secondary_total, teachers_primary_total, teachers_secondary_total) FROM stdin;
0 \N \N \N 97.3645706176758 101.391189575195 \N 4.76588010787964 4092573 368975 426980 \N \N
1 \N \N \N 98.8806304931641 101.728248596191 \N \N 4054588 361128 427609 \N \N
2 \N \N \N 98.9664764404297 101.90348815918 63.6000595092773 4.7664098739624 4012842 356032 421977 \N \N
3 \N \N \N 98.013313293457 102.344436645508 63.7673988342285 4.62612009048462 3961374 353599 412521 \N \N
4 \N \N \N 99.0087966918945 102.734443664551 63.0657691955566 4.84057998657227 3905068 353547 403277 \N \N
5 \N \N \N 98.6416015625 102.398483276367 61.6558494567871 5.356369972229 3851269 355584 393451 \N \N
6 \N \N \N 98.1893692016602 103.348960876465 63.4673194885254 5.26205015182495 3807165 359040 384607 \N \N
7 \N \N \N 99.5182800292969 109.987487792969 63.980770111084 \N 3794610 362975 383046 \N \N
8 \N \N \N 100.340713500977 109.485992431641 65.3322982788086 \N 3785262 370329 381453 \N \N
9 \N \N \N 101.536659240723 109.333099365234 65.612907409668 \N 3783967 379571 377140 \N \N
10 \N \N \N 102.485076904297 110.35652923584 64.7869567871094 \N 3792501 389428 369202 \N \N
11 \N \N \N 101.023872375488 112.514282226563 66.4391784667969 \N 3809992 397794 363467 \N \N
12 \N \N \N 100.94367980957 113.76286315918 68.9225082397461 \N 3850892 400896 370148 \N \N
13 \N \N \N 101.501091003418 114.123512268066 70.1130218505859 \N 3884643 400334 380333 \N \N
14 \N \N \N 100.989753723145 114.333267211914 75.6988220214844 \N 3913933 397848 387874 \N \N
15 \N \N \N \N \N \N \N \N 395376 394591 \N \N
16 \N \N \N 101.8740234375 95.0524826049805 80.6348266601563 \N 49682243 3822089 4293550 \N \N
17 \N \N \N \N \N \N \N 49713141 3828153 4251162 \N \N
18 \N \N \N \N \N \N \N 49768249 3891329 4196880 \N \N
19 \N \N \N \N \N \N \N 49899954 4046402 4192002 \N \N
20 \N \N \N \N \N \N \N 49809178 3988117 4159477 \N \N
21 \N \N \N \N \N \N \N 49819384 4018200 4110576 \N \N
22 \N \N \N \N \N \N \N 49806498 4062428 4125653 \N \N
23 \N \N \N \N \N \N \N 49648974 4081627 4135866 \N \N
24 \N \N \N 99.455436706543 96.1864929199219 88.7264175415039 \N 49602123 4106467 4206506 \N \N
25 \N \N \N 99.6733779907227 96.9245376586914 88.6268692016602 \N 49617380 4146714 4136933 1687937 1638606
26 \N \N \N 100.299911499023 97.6525497436523 88.8894119262695 \N 49715732 4114053 4094386 1714415 1661375
27 \N \N \N 101.362861633301 98.7699279785156 88.8350524902344 \N 49698279 4000424 4104538 \N \N
28 \N \N \N 101.821441650391 98.9523391723633 88.1673889160156 \N 49724657 4045867 4131553 1769451 1694959
29 \N \N \N 101.256561279297 99.2755813598633 88.2991790771484 \N 49701081 4052748 4150564 \N \N
30 \N \N \N 100.981300354004 100.063430786133 87.8887100219727 \N \N \N \N \N \N
31 \N \N \N \N \N \N \N \N \N \N \N \N
32 91.6302719116211 93.1904067993164 90.2104110717773 108.60083770752 82.3040771484375 24.2164001464844 4.84568977355957 24608995 2251858 2228239 519112 593451
33 91.7345199584961 93.9011993408203 89.8345108032227 108.174766540527 84.0856018066406 24.7904300689697 4.69992017745972 24627787 2242275 2248436 521183 610387
34 92.7951736450195 94.4415130615234 91.3555526733398 108.799713134766 84.9070510864258 25.4210605621338 4.69050979614258 24654878 2239799 2252781 522733 620808
35 92.9255981445313 94.5921630859375 91.45361328125 109.424423217773 86.4275283813477 26.1120300292969 4.82006978988647 24686831 2245319 2245920 524517 635518
36 93.4418792724609 94.9165725708008 92.1162490844727 110.545280456543 85.9380111694336 26.5867290496826 5.18794012069702 24715370 2254432 2240778 528555 650513
37 93.0689392089844 94.3839416503906 91.8534164428711 110.633491516113 87.0699234008789 27.5634708404541 5.15922021865845 24732518 2262628 2231609 529599 652140
38 93.5199813842773 94.7827682495117 92.3382797241211 110.540756225586 88.1901779174805 28.3414993286133 5.10564994812012 24724507 2264212 2223740 531256 669583
39 94.228401184082 95.3916320800781 93.1792373657227 110.413452148438 90.6671981811523 29.4718399047852 5.10309982299805 31447472 2263229 2228149 533866 684249
40 93.9628524780273 95.1121063232422 92.903938293457 109.441482543945 93.3275527954102 30.3000392913818 4.69605016708374 31407043 2256134 2239593 575337 683411
41 94.5558776855469 95.6204681396484 93.5913391113281 108.005752563477 97.3433837890625 31.0941390991211 5.25747013092041 31358984 2245666 2248138 573238 782545
42 94.472282409668 95.5493316650391 93.4854965209961 106.606109619141 100.832740783691 31.8190402984619 5.22942018508911 31318900 2234718 2257952 574276 813747
43 94.859619140625 95.8448181152344 93.9685211181641 106.277732849121 102.40406036377 38.4333801269531 4.90681982040405 31306937 2227103 2264619 574210 830578
44 94.9727783203125 95.8723678588867 94.1657562255859 105.770011901855 104.385032653809 40.2289581298828 4.51821994781494 31315892 2226776 2258855 573284 827017
45 95.3799133300781 96.2329025268555 94.6080474853516 105.02806854248 105.103363037109 41.5228004455566 4.25442981719971 31340326 2231977 2247894 571520 833944
46 \N \N \N 104.655822753906 104.647239685059 42.8306999206543 \N 31362235 2239200 2238965 \N \N
47 95.2478485107422 96.0587463378906 94.4951324462891 \N \N \N \N \N 2244671 2228497 \N \N
48 \N \N \N 107.955436706543 60.1542892456055 17.2262992858887 2.8728199005127 40397965 4503257 4478233 1427974 1281677
49 91.9822692871094 95.1585388183594 88.786979675293 106.268379211426 62.6410293579102 17.280179977417 \N 40781235 4548490 4517417 1525400 1369424
50 \N \N \N 109.305770874023 70.5409164428711 17.7949295043945 3.04425001144409 40633092 4566992 4479279 1583589 1434874
51 92.1922988891602 95.383186340332 89.1013870239258 107.822540283203 69.6562271118164 20.6682090759277 2.90190005302429 40645415 4592159 4462549 1425828 1531383
52 92.5817031860352 95.6470108032227 89.677116394043 108.549240112305 74.6276473999023 22.9891204833984 3.52513003349304 40812931 4625583 4469530 1511977 1550054
53 \N \N \N 109.150337219238 76.4262466430664 24.0762596130371 2.81227993965149 41118609 4666449 4501293 1595955 1640533
54 92.8119125366211 95.5910873413086 90.0687026977539 109.179832458496 79.1144790649414 26.3031997680664 3.18944001197815 41541270 4712482 4563250 1615479 1407035
55 \N \N \N 109.273422241211 80.4523315429688 30.4290008544922 3.40748000144959 41835466 4709390 4623136 1655764 1290585
56 \N \N \N 106.841590881348 82.6376419067383 31.0637092590332 3.35904002189636 42005790 4684236 4654753 1870834 1451842
57 95.1162185668945 96.7910079956055 93.4508972167969 106.073402404785 82.6823806762695 30.8957595825195 3.28800988197327 42054324 4649152 4667376 1801909 1459756
58 95.2179336547852 97.1065216064453 93.3357086181641 105.960243225098 86.1227493286133 33.2507209777832 3.58360004425049 42017587 4616348 4683986 \N \N
59 95.3769683837891 97.1744384765625 93.5869216918945 105.609878540039 84.9521179199219 35.4373588562012 3.5 41935960 4595834 4708485 2106887 1674317
60 \N \N \N 105.911430358887 87.0592193603516 36.4444389343262 2.6699800491333 41788284 4596194 4705051 1827213 1586484
61 95.658561706543 97.3313369750977 93.9921798706055 106.410820007324 88.9101715087891 36.3110389709473 3 41727304 4647805 4680038 1727377 1636970
62 \N \N \N \N \N \N 2.84185004234314 41760251 4727440 4642754 1771614 \N
63 95.9990081787109 97.4493103027344 94.5523529052734 \N \N \N \N \N 4810671 4605890 \N \N
64 \N \N \N \N \N 2.43892002105713 2.12011003494263 2306240 609090 529100 \N \N
65 \N \N \N \N \N 2.3798201084137 2.28146004676819 2391150 633521 545733 \N \N
66 \N \N \N 98.9735794067383 \N \N \N 3595510 660238 528706 86769 \N
67 \N \N \N 105.180206298828 21.2894592285156 \N \N 3736493 688394 546105 \N \N
68 \N \N \N 104.130569458008 22.6925506591797 \N \N 3885762 717087 564807 \N \N
69 \N \N \N 105.781036376953 26.259220123291 \N 3.42131996154785 4039482 745239 584993 93734 \N
70 \N \N \N 119.530143737793 26.4825401306152 6.13030004501343 3.2437698841095 4205469 777542 606439 118158 32279
71 \N \N \N \N \N \N 3.27847003936768 4383296 811625 630476 \N \N
72 \N \N \N \N \N 8.83833026885986 3.8720600605011 4570069 846117 655900 \N \N
73 66.0301132202148 79.9741516113281 53.4072113037109 \N \N \N 2.93055009841919 4761994 879590 682061 \N \N
74 \N \N \N 113.477958679199 \N 8.40093994140625 3.48690009117126 4953310 910404 709888 112352 72859
75 \N \N \N \N 50.6714782714844 9.33625984191895 2.75494003295898 5149203 941905 740259 95827 75997
76 \N \N \N \N \N \N 2.46688008308411 5340692 971420 772730 \N \N
77 \N \N \N \N \N \N 2.04469990730286 5524854 999138 805604 \N \N
78 \N \N \N \N \N \N 1.82117998600006 5698765 1025194 839167 \N \N
79 \N \N \N \N \N \N \N \N 1050022 871796 \N \N
80 \N \N \N 130.898712158203 \N 3.3885600566864 \N \N 317733 361721 50654 \N
81 \N \N \N 128.833190917969 39.738410949707 5.67854976654053 \N \N 308238 369665 51212 27070
82 \N \N \N 127.848602294922 42.6907386779785 7.31445980072021 1.59930002689362 \N 302389 360458 48736 30258
83 76.8712921142578 84.9874572753906 69.5864105224609 123.756790161133 45.2158813476563 9.12242984771729 \N \N 299305 344993 48223 \N
84 76.1379623413086 83.9326782226563 69.109016418457 123.281227111816 \N 11.7689504623413 1.66568005084991 \N 298296 333732 46658 \N
85 \N \N \N 123.834930419922 \N 13.9649896621704 1.53378999233246 \N 298501 325253 46905 \N
86 \N \N \N 122.141471862793 \N 14.8900699615479 1.51068997383118 \N 298617 318415 47033 \N
87 \N \N \N 121.787933349609 \N \N 1.56089997291565 \N 301828 311070 48002 \N
88 \N \N \N 123.448059082031 \N \N 2.05053997039795 \N 309787 305566 47413 \N
89 78.0550918579102 84.8141479492188 71.7817993164063 116.808219909668 \N \N 1.90938997268677 \N 320285 300299 47691 \N
90 80.5264892578125 86.5324401855469 75.0338668823242 117.078483581543 \N 13.1356296539307 \N \N 331089 294235 47866 \N
91 \N \N \N 110.187652587891 \N \N \N \N 339214 291380 49511 \N
92 \N \N \N 107.813056945801 \N 13.1342802047729 \N \N 345120 295972 50684 \N
93 \N \N \N 107.414848327637 \N 13.6877603530884 2.16285991668701 \N 348782 304832 51490 \N
94 \N \N \N 106.474739074707 \N 14.7389602661133 \N \N 350857 313149 51578 \N
95 \N \N \N 105.351997375488 54.8304100036621 \N \N \N 352084 322127 \N \N
96 93.5064697265625 95.6002426147461 91.5295715332031 101.92333984375 73.6311569213867 44.5769500732422 3.93859004974365 8933953 932667 1022869 \N \N
97 \N \N \N 101.81307220459 74.1841506958008 44.8578300476074 4.05038022994995 8793035 911044 1014884 319916 208812
98 \N \N \N 101.379493713379 79.3435363769531 49.0348014831543 3.60314989089966 8645097 893444 997781 321930 227929
99 \N \N \N 100.828437805176 79.2197723388672 48.6715698242188 3.50850009918213 8492383 876171 976935 347959 222799
100 \N \N \N 99.1733322143555 80.8186874389648 49.4026985168457 3.86193990707397 8336247 859556 959067 \N \N
101 96.430908203125 96.4350204467773 96.4270477294922 96.8581390380859 82.4288482666016 50.3747406005859 3.5084400177002 8183489 843823 943751 316552 \N
102 \N \N \N 96.7558822631836 85.0075988769531 52.2556991577148 4.80555009841919 8038740 829237 928541 319568 \N
103 \N \N \N 97.0294494628906 83.7614593505859 50.6790084838867 4.53670978546143 7965633 824199 920553 307446 \N
104 93.7020721435547 95.2512588500977 92.2491607666016 96.9178466796875 81.999153137207 49.8533706665039 4.12402009963989 7897749 822309 910375 \N \N
105 \N \N \N 102.110877990723 120.332298278809 50.180061340332 3.72356009483337 7831867 821422 899035 336676 229937
106 92.8683090209961 94.6591186523438 91.1919326782227 100.650863647461 120.651168823242 \N 3.75967001914978 7766912 819620 884644 300968 240005
107 \N \N \N 100.757530212402 118.625907897949 49.2868118286133 3.63752007484436 7701605 814196 871387 303969 246711
108 \N \N \N 99.6250305175781 116.733940124512 \N 3.3557300567627 7592844 804082 859397 293265 240251
109 93.7677612304688 95.202392578125 92.4285583496094 99.7743606567383 117.738807678223 \N 3.05677008628845 7494139 792856 851885 \N 241484
110 \N \N \N 101.052673339844 115.152656555176 \N 2.96898007392883 7401193 781034 842800 378131 229313
111 \N \N \N 102.225120544434 113.794387817383 \N \N \N 769176 833611 \N \N
112 \N \N \N 105.948272705078 87.3967132568359 \N 5.06319999694824 9004960 955310 1042773 232999 141562
113 \N \N \N 106.250091552734 90.6488265991211 \N 5.07256984710693 8899564 951051 1026393 219582 158544
114 88.7172470092773 90.7175903320313 87.043098449707 108.024749755859 92.3353729248047 \N 4.97414016723633 8805852 950598 1010026 220308 164990
115 \N \N \N 107.526397705078 90.8973999023438 \N 4.86600017547607 8731949 953913 996120 221065 168556
116 92.8948593139648 94.1214599609375 91.7681579589844 106.341697692871 92.5119018554688 \N 5.24869012832642 8685285 961151 984918 212296 187162
117 92.8773193359375 94.1438522338867 91.7139892578125 104.729377746582 93.7371978759766 18.3626308441162 5.72173976898193 8668045 972205 974326 238032 \N
118 93.1021423339844 94.2450866699219 92.0478897094727 103.418388366699 96.1824569702148 19.6080207824707 5.88102006912231 8667892 986256 964327 213440 \N
119 93.7294692993164 94.9637222290039 92.5862503051758 103.229202270508 98.8268585205078 19.1436595916748 6.07742023468018 8710990 1010687 958339 212657 \N
120 \N \N \N 102.670402526855 \N 19.9304904937744 5.86465978622437 8798269 1041124 956523 220544 \N
121 94.1399002075195 95.2868499755859 93.0730590820313 102.704963684082 107.804122924805 19.8092403411865 5.99946022033691 8922501 1073099 957609 219579 \N
122 94.367919921875 95.3965301513672 93.4080276489258 105.570388793945 109.444076538086 22.260929107666 5.95619010925293 9074756 1102645 958332 249103 190022
123 \N \N \N 103.184959411621 107.176948547363 20.9184494018555 5.94285011291504 9256748 1127593 959561 \N 192359
124 87.0466690063477 87.6777496337891 86.4586334228516 100.864730834961 104.697982788086 22.3660297393799 6.11305999755859 9447226 1144807 968956 \N 182937
125 \N \N \N 98.5389022827148 100.511169433594 23.8019599914551 6.15898990631104 9641171 1155954 990907 \N 182982
126 95.0229721069336 95.5453720092773 94.5331726074219 98.3744735717773 102.556663513184 23.8665599822998 6.50505018234253 9827385 1162848 1020897 \N \N
127 \N \N \N \N \N \N 6.83613014221191 \N 1167175 1049733 \N \N
128 \N \N \N \N \N \N \N 2251272 326138 320119 \N \N
129 \N \N \N \N \N \N \N 2242521 327946 314779 \N \N
130 \N \N \N \N \N \N \N 2245701 330994 311711 \N \N
131 \N \N \N \N \N \N \N 2258837 335191 310788 \N \N
132 \N \N \N \N \N \N \N 2279942 340313 311594 \N \N
133 \N \N \N \N \N 6.69837999343872 1.54405999183655 2306084 346119 314280 \N \N
134 83.5827102661133 87.7648086547852 80.0656585693359 \N \N 6.70255994796753 \N 2330166 354445 314332 \N \N
135 \N \N \N 112.516792297363 51.5509910583496 6.85413980484009 6.07020998001099 2369825 365217 315421 74355 41759
136 \N \N \N 109.892791748047 52.4056701660156 6.93525981903076 5.99597978591919 2423441 377304 317450 73148 42585
137 88.6934204101563 89.1853713989258 88.2838287353516 \N \N \N 6.13835000991821 2488048 389639 321155 \N \N
138 \N \N \N 103.833992004395 \N 10.0065498352051 5.81278991699219 2560255 400870 325775 \N \N
139 \N \N \N 101.309677124023 \N 8.17144012451172 5.47262001037598 2627597 412180 330955 \N \N
140 \N \N \N 98.9331893920898 \N 8.87594985961914 5.3810601234436 2705346 424853 339846 \N \N
141 \N \N \N 97.7508087158203 \N \N 3.58728003501892 2788693 436916 350684 \N \N
142 \N \N \N 97.1402130126953 \N \N \N 2871820 446279 361149 \N \N
143 \N \N \N 97.3049087524414 \N \N \N \N 450565 370097 \N \N
\.
--
-- Data for Name: event; Type: TABLE DATA; Schema: public; Owner: postgres
--
COPY public.event (event_key, name, disaster_type, start_day, end_day, start_month, end_month, start_year, end_year, disaster_subgroup, total_deaths, no_injured, no_affected) FROM stdin;
0 Null Flood 27 28 1 3 2005 2005 Hydrological \N \N \N
1 Null Transport accident 8 8 2 2 2005 2005 Technological 20 70 \N
2 Null Earthquake 28 28 3 3 2005 2005 Geophysical 915 1146 104167
3 Null Earthquake 23 23 1 1 2005 2005 Geophysical 1 4 680
4 Null Landslide 21 21 2 2 2005 2005 Hydrological 143 \N \N
5 Casa 212 Transport accident 22 22 3 3 2005 2005 Technological 15 3 \N
6 Null Transport accident 13 13 3 3 2005 2005 Technological 33 \N \N
7 Null Flood 17 23 2 2 2005 2005 Hydrological 9 \N 150
8 Null Flood 7 11 1 1 2005 2005 Hydrological 28 8 500
9 Null Storm 22 24 1 1 2005 2005 Meteorological 20 \N \N
10 Null Transport accident 7 7 1 1 2005 2005 Technological 9 200 750
11 Null Transport accident 5 5 1 1 2005 2005 Technological 12 13 \N
12 Sea Breeze Transport accident 25 25 1 1 2005 2005 Technological 17 \N \N
13 Null Transport accident 17 17 1 1 2005 2005 Technological \N 200 \N
14 Null Transport accident 26 26 1 1 2005 2005 Technological 11 180 \N
15 Raffinerie BP Industrial accident 23 23 3 3 2005 2005 Technological 15 170 \N
16 Null Earthquake 9 9 3 3 2005 2005 Geophysical 2 58 \N
17 Null Transport accident 25 25 3 3 2005 2005 Technological 10 69 \N
18 Null Flood 26 27 4 4 2005 2005 Hydrological 47 18 750
19 Null Flood 18 19 10 10 2005 2005 Hydrological 28 211 12000
20 Null Flood 31 3 12 1 2005 2006 Hydrological 79 30 7781
21 Null Flood 27 29 9 9 2005 2005 Hydrological \N \N 600
22 Null Flood 7 1 6 7 2005 2005 Hydrological 4 \N 5000
23 Null Wildfire \N \N 7 7 2005 2005 Climatological \N \N \N
24 Null Wildfire \N \N 8 8 2005 2005 Climatological \N \N \N
25 Food poisoning Miscellaneous accident 30 1 11 12 2005 2005 Technological \N 506 \N
26 Poisoning Miscellaneous accident 8 8 5 5 2005 2005 Technological \N 155 \N
27 Null Storm 26 29 9 9 2005 2005 Meteorological \N \N 300
28 Mt. Talang Volcanic activity 12 12 4 4 2005 2005 Geophysical \N \N 26000
29 Null Landslide 2 2 9 9 2005 2005 Hydrological 25 10 \N
30 Null Wildfire 9 9 8 8 2005 2005 Climatological \N \N \N
31 Poliomyelitis Epidemic \N 31 6 1 2005 2006 Biological \N \N 329
32 Boeing 737-200 Transport accident 5 5 9 9 2005 2005 Technological 150 \N 14
33 Ferry "Digul" Transport accident 7 7 7 7 2005 2005 Technological 200 \N \N
34 Null Transport accident 24 24 9 9 2005 2005 Technological 18 \N 34
35 Null Transport accident 30 30 6 6 2005 2005 Technological 2 125 \N
36 Null Flood 22 4 12 1 2006 2007 Hydrological 236 \N 618486
37 Null Earthquake 17 17 12 12 2006 2006 Geophysical 8 200 1000
38 Null Flood 13 23 2 2 2006 2006 Hydrological 39 39 17500
39 Null Flood 19 23 6 6 2006 2006 Hydrological 236 56 28505
40 Null Flood 25 29 6 6 2006 2006 Hydrological 52 \N 18250
41 Null Flood 26 14 1 2 2006 2006 Hydrological 19 \N 10000
42 Null Flood 19 23 4 4 2006 2006 Hydrological 22 2 400
43 Null Flood 24 26 6 6 2006 2006 Hydrological 41 \N \N
44 Null Earthquake 14 14 3 3 2006 2006 Geophysical 3 2 1200
45 Null Flood 22 31 4 5 2006 2006 Hydrological \N \N 2000
46 Null Flood \N \N 1 1 2006 2006 Hydrological \N \N \N
47 Cholera Epidemic 13 8 2 2 2006 2007 Biological 2354 \N 57570
48 Cholera Epidemic 24 \N 10 11 2006 2006 Biological 68 \N \N
49 Helicopter MI-17 Transport accident 25 25 2 2 2006 2006 Technological 18 12 \N
50 Null Flood 18 24 4 4 2006 2006 Hydrological \N \N 200
51 Null Flood 12 20 4 4 2006 2006 Hydrological \N \N 1000
52 Null Flood 26 2 5 6 2006 2006 Hydrological \N \N 300
53 Null Flood 20 28 5 5 2006 2006 Hydrological 1 \N 400
54 Null Earthquake 26 26 5 5 2006 2006 Geophysical 5778 137883 2340745
55 Null Earthquake 1 1 12 12 2006 2006 Geophysical 1 14 \N
56 Null Earthquake 17 17 7 7 2006 2006 Geophysical 802 543 35000
57 Mt. Merapi Volcanic activity 18 15 4 5 2006 2006 Geophysical \N \N 11000
58 Null Flood 23 27 6 6 2006 2006 Hydrological \N \N 5000
59 Null Landslide 1 4 1 1 2006 2006 Hydrological 156 13 \N
60 Null Landslide 22 27 1 1 2006 2006 Hydrological 11 \N 3000
61 Null Landslide 15 15 12 12 2006 2006 Hydrological 17 \N \N
62 Null Wildfire \N \N 8 8 2006 2006 Climatological \N 200 \N
63 Null Transport accident 17 17 11 11 2006 2006 Technological 12 \N \N
64 Null Transport accident 1 1 1 1 2006 2006 Technological 11 14 \N
65 Ferry Transport accident 31 31 1 1 2006 2006 Technological 117 \N 71
66 Inter-island ferry "Citra Mandala Bakti" Transport accident 31 31 1 1 2006 2006 Technological 45 \N 114
67 Cargo Transport accident 6 6 4 4 2006 2006 Technological 29 \N \N
68 Ferry Transport accident 18 18 4 4 2006 2006 Technological 10 \N 50
69 Ferry Transport accident 21 22 6 6 2006 2006 Technological 35 \N \N
70 Ferry "Trista I" Transport accident 29 29 12 12 2006 2006 Technological 50 \N \N
71 Ferry "Senopati Nusantara" Transport accident 30 31 12 12 2006 2006 Technological 400 \N 250
72 Null Transport accident 15 15 4 4 2006 2006 Technological 13 26 \N
73 Null Industrial accident 22 22 11 11 2006 2006 Technological 12 11 \N
74 Null Industrial accident 29 29 5 5 2006 2006 Technological 13 \N \N
152 Null Flood 27 7 7 8 2006 2006 Hydrological \N \N \N
75 Gold mine Industrial accident 6 6 5 5 2006 2006 Technological 11 \N \N
76 Null Miscellaneous accident 8 8 9 9 2006 2006 Technological 23 \N \N
77 Null Storm 14 15 2 2 2007 2007 Meteorological 2 \N \N
78 Null Landslide 12 14 1 1 2007 2007 Hydrological 32 \N 3990
79 Null Flood 10 10 1 5 2007 2007 Hydrological \N \N \N
80 Null Flood 17 25 1 1 2007 2007 Hydrological 105 \N 40000
81 Cholera Epidemic 1 31 1 12 2007 2007 Biological 515 \N 17875
82 Null Flood 31 22 1 2 2007 2007 Hydrological 68 1 217086
83 Null Landslide 9 9 1 1 2007 2007 Hydrological 11 \N \N
84 Boeing Transport accident 1 1 1 1 2007 2007 Technological 102 \N \N
85 Null Transport accident 1 1 1 1 2007 2007 Technological 15 \N 10
86 Null Transport accident 16 16 1 1 2007 2007 Technological 5 100 \N
87 Null Epidemic \N \N 2 2 2007 2007 Biological 22 \N 357
88 Katrina Storm 29 19 8 9 2005 2005 Meteorological 1833 \N 500000
89 Null Flood 31 18 12 1 2005 2006 Hydrological 3 \N 3600
90 Null Drought \N \N 4 4 2005 2005 Climatological \N \N 600000
91 Hurricane "Wilma" Storm 24 24 10 10 2005 2005 Meteorological 4 \N 30000
92 Null Flood 21 30 8 8 2005 2005 Hydrological 30 \N 10000
93 Null Flood 23 12 11 1 2005 2006 Hydrological 55 \N 700000
94 Damrey Storm 26 30 9 9 2005 2005 Meteorological 10 \N 2000
95 Null Wildfire \N \N 8 8 2005 2005 Climatological \N \N \N
96 Null Storm 21 21 5 5 2005 2005 Meteorological \N \N 1500
97 Stan Storm 1 13 10 10 2005 2005 Meteorological 36 \N 1954571
98 Hurricane "Wilma" Storm 19 24 10 10 2005 2005 Meteorological 7 \N 700000
99 Null Flood 5 5 5 5 2005 2005 Hydrological 8 \N 1000
100 Null Flood 6 8 5 5 2005 2005 Hydrological \N \N \N
101 Null Flood 8 16 10 10 2005 2005 Hydrological 11 \N 3000
102 Bret Storm 29 30 6 6 2005 2005 Meteorological 2 \N 15000
103 Null Storm 6 8 4 4 2005 2005 Meteorological \N 8 45
104 Rita Storm 23 1 9 10 2005 2005 Meteorological 10 \N 300000
105 Null Flood 8 29 9 9 2005 2005 Hydrological 16 \N \N
106 Landmine Miscellaneous accident 13 13 11 11 2005 2005 Technological 13 \N \N
107 Null Flood 26 29 9 9 2005 2005 Hydrological 3 \N 3000
108 Emily Storm 18 18 7 7 2005 2005 Meteorological 2 \N \N
109 Null Transport accident 6 6 4 4 2005 2005 Technological 20 15 \N
110 Fireworks market Miscellaneous accident 15 15 9 9 2005 2005 Technological \N 104 \N
111 Null Flood 13 31 8 8 2005 2005 Hydrological 21 40 119270
112 Boat "Runj Roj" Transport accident 5 5 3 3 2005 2005 Technological 10 65 \N
113 Null Drought \N \N 1 3 2005 2005 Climatological \N \N \N
114 Null Storm 18 18 8 8 2005 2005 Meteorological \N \N 120
115 Null Storm 8 9 12 12 2005 2005 Meteorological 10 \N \N
116 Null Flood 1 6 4 4 2005 2005 Hydrological 2 \N 11000
117 Hurricane "Dennis" Storm 10 10 7 7 2005 2005 Meteorological 5 \N \N
118 Null Extreme temperature 4 30 7 7 2005 2005 Meteorological 33 31 \N
119 Null Wildfire 27 4 12 1 2005 2006 Climatological 5 \N \N
120 Bimoteur Grumman G-73T Transport accident 19 19 12 12 2005 2005 Technological 19 \N \N
121 Null Transport accident 23 23 9 9 2005 2005 Technological 24 17 \N
122 Null Transport accident 2 2 10 10 2005 2005 Technological 21 \N 28
123 Null Transport accident 15 15 7 7 2005 2005 Technological 23 \N \N
124 Null Transport accident 19 19 8 8 2005 2005 Technological 13 8 \N
125 Null Transport accident 2 2 9 9 2005 2005 Technological 19 \N \N
126 Null Transport accident 16 17 12 12 2005 2005 Technological 20 77 \N
127 Porte conteneur "Euro da Brasil" et chalutier "Lindsay" Transport accident 8 8 5 5 2005 2005 Technological 14 \N 2
128 Null Transport accident 13 13 7 7 2005 2005 Technological \N 162 \N
129 Null Transport accident 25 25 4 4 2005 2005 Technological 11 53 \N
130 Null Flood 4 17 4 4 2006 2006 Hydrological 1 \N 600
131 Null Flood 14 23 3 3 2006 2006 Hydrological 7 \N \N
132 John Storm 2 4 9 9 2006 2006 Meteorological 7 \N 10000
133 Lane Storm 16 18 9 9 2006 2006 Meteorological 4 \N 240700
134 Null Earthquake 15 15 10 10 2006 2006 Geophysical \N 10 3519
135 Null Flood 22 11 5 6 2006 2006 Hydrological 116 \N 342895
136 Null Flood 20 13 8 12 2006 2006 Hydrological 164 \N 2212413
137 Null Flood 25 1 6 7 2006 2006 Hydrological 11 \N 65000
138 Null Storm 2 3 4 4 2006 2006 Meteorological 28 36 3600
139 Null Storm 6 8 4 4 2006 2006 Meteorological 12 160 465
140 Null Storm 1 7 5 5 2006 2006 Meteorological 1 \N 600
141 Null Flood 10 1 8 11 2006 2006 Hydrological 5 \N 33000
142 Null Flood 11 22 5 5 2006 2006 Hydrological 2 \N 2500
143 Null Flood 22 26 9 9 2006 2006 Hydrological 14 10 1200
144 Null Storm 30 3 11 12 2006 2006 Meteorological 11 \N \N
145 Paul Storm 25 28 10 10 2006 2006 Meteorological 4 \N 20000
146 Null Storm 11 13 3 3 2006 2006 Meteorological 10 42 \N
147 Null Storm 15 16 11 11 2006 2006 Meteorological 12 20 \N
148 Null Storm 12 14 10 10 2006 2006 Meteorological 3 \N \N
149 Ernesto Storm 2 7 8 9 2006 2006 Meteorological 6 \N 140
150 Null Flood 6 7 7 7 2006 2006 Hydrological \N \N 5000
151 Dengue Epidemic \N \N \N \N 2006 2006 Biological \N \N 4368
153 Null Landslide 2 2 8 8 2006 2006 Hydrological 11 \N \N
154 Null Landslide 6 6 9 9 2006 2006 Hydrological 10 \N \N
155 Null Extreme temperature \N \N 11 11 2006 2006 Meteorological 5 \N \N
156 Null Transport accident 17 17 4 4 2006 2006 Technological 57 3 \N
157 Null Transport accident 16 16 10 10 2006 2006 Technological 14 \N \N
158 Null Transport accident 28 28 12 12 2006 2006 Technological 22 9 \N
159 Mine Industrial accident 19 19 2 2 2006 2006 Technological 65 8 \N
160 Null Flood 10 18 2 2 2006 2006 Hydrological \N \N 2000
161 Null Storm 25 25 12 12 2006 2006 Meteorological \N \N 600
162 Null Storm 21 21 12 12 2006 2006 Meteorological \N \N \N
163 Null Storm 27 31 12 12 2006 2006 Meteorological \N \N \N
164 Null Flood 22 25 6 6 2006 2006 Hydrological 2 \N 2400
165 Null Flood 27 7 7 8 2006 2006 Hydrological \N \N \N
166 Null Flood 27 30 7 7 2006 2006 Hydrological 1 \N 600
167 Null Flood 19 24 8 8 2006 2006 Hydrological \N \N 150
168 Null Flood 9 14 10 10 2006 2006 Hydrological \N \N 100
169 Null Flood 5 10 11 11 2006 2006 Hydrological 2 \N 1500
170 Null Extreme temperature 14 15 7 8 2006 2006 Meteorological 164 \N \N
171 Null Extreme temperature 30 6 7 8 2006 2006 Meteorological 24 \N \N
172 Null Wildfire 26 27 10 10 2006 2006 Climatological 4 1 \N
173 Null Wildfire 3 6 12 12 2006 2006 Climatological \N \N \N
174 Null Transport accident 27 27 8 8 2006 2006 Technological 49 \N 1
175 "Paquebot "Crown princess" Transport accident 18 18 7 7 2006 2006 Technological \N 100 \N
176 Mine Industrial accident 2 2 1 1 2006 2006 Technological 13 1 6
177 Hall for mentally handicapped people Miscellaneous accident 26 27 11 11 2006 2006 Technological 10 19 \N
178 Null Wildfire 9 14 7 7 2006 2006 Climatological 1 17 \N
179 Null Storm 14 15 12 12 2006 2006 Meteorological 10 \N \N
180 Null Flood 26 30 3 3 2006 2006 Hydrological 6 \N 4160
181 Null Flood 2 4 8 8 2006 2006 Hydrological 6 \N 3000
182 Null Transport accident 7 7 2 2 2006 2006 Technological 11 35 \N
183 Null Transport accident 18 18 6 6 2006 2006 Technological 12 \N \N
184 Null Transport accident 18 18 6 6 2006 2006 Technological 11 \N \N
185 Null Transport accident 24 24 6 6 2006 2006 Technological 14 4 \N
186 Null Transport accident 8 8 7 7 2006 2006 Technological 10 \N \N
187 Null Transport accident 24 24 12 12 2006 2006 Technological 12 34 \N
188 Cargo "Alexandros T" Transport accident 4 4 5 5 2006 2006 Technological 26 \N 7
189 Null Transport accident 13 13 11 11 2006 2006 Technological 20 6 \N
190 Null Miscellaneous accident 29 29 3 3 2006 2006 Technological 12 33 \N
191 Null Storm 12 17 1 1 2007 2007 Meteorological 65 220 \N
192 Null Storm 14 15 2 2 2007 2007 Meteorological 16 \N \N
193 Null Transport accident 24 24 1 1 2007 2007 Technological 29 25 \N
194 Null Transport accident 19 19 1 1 2007 2007 Technological 16 30 \N
195 Null Transport accident 14 14 1 1 2007 2007 Technological 3 100 \N
196 Null Storm 2 2 2 2 2007 2007 Meteorological 20 \N 6600
197 Null Flood 15 25 1 1 2007 2007 Hydrological 24 \N \N
198 Null Transport accident 1 1 2 2 2007 2007 Technological 20 \N \N
199 Cholera Epidemic \N \N 5 6 2005 2005 Biological 14 \N 203
200 Cholera Epidemic 10 18 12 5 2005 2006 Biological 73 \N 980
201 Null Transport accident 25 25 8 8 2005 2005 Technological 18 62 \N
202 Food poisoning Miscellaneous accident 13 13 11 11 2005 2005 Technological 14 200 \N
203 Null Transport accident 6 6 6 6 2006 2006 Technological 18 43 \N
204 Null Transport accident 7 7 8 8 2006 2006 Technological 33 20 \N
205 Null Flood 1 10 3 3 2007 2007 Hydrological 74 26 11530
206 Null Flood \N \N 7 7 2007 2007 Hydrological 58 \N 5000
207 Null Flood 22 7 7 8 2007 2007 Hydrological 88 12 3377
208 Null Flood 25 \N 12 12 2007 2007 Hydrological 127 95 259545
209 Null Flood 2 4 9 9 2007 2007 Hydrological 4 \N 1000
210 Null Earthquake 12 12 9 9 2007 2007 Geophysical 25 82 422685
211 Null Industrial accident 3 3 11 11 2007 2007 Technological 5 100 \N
212 Unknown Epidemic 2 29 10 11 2007 2007 Biological \N \N 468
213 Null Flood 6 11 6 6 2007 2007 Hydrological \N \N 500
214 Null Storm 23 26 12 12 2007 2007 Meteorological 4 \N \N
215 Null Earthquake 6 6 3 3 2007 2007 Geophysical 67 826 136834
216 Null Earthquake 9 9 9 9 2007 2007 Geophysical \N 19 450
217 Null Earthquake 25 25 11 11 2007 2007 Geophysical 3 1800 20000
218 Mt. Gamkonora Volcanic activity 9 9 7 7 2007 2007 Geophysical \N \N 9758
219 Mt. Kelud Volcanic activity 16 18 10 10 2007 2007 Geophysical \N \N 22154
220 Null Flood 15 5 5 6 2007 2007 Hydrological 4 \N 60000
221 Null Flood 25 2 7 8 2007 2007 Hydrological 15 \N 2000
222 Dengue Epidemic \N \N 7 7 2007 2007 Biological 365 \N 34542
223 Dengue Epidemic \N \N 2 3 2007 2007 Biological 16 \N 312
224 Null Transport accident 7 7 3 3 2007 2007 Technological 22 50 \N
225 Ferry Levina I Transport accident 22 22 2 2 2007 2007 Technological 77 \N \N
226 Passenger ship "Wahai Star" Transport accident 11 11 7 7 2007 2007 Technological 47 \N \N
227 Ferry "Acita" Transport accident 18 18 10 10 2007 2007 Technological 60 20 \N
228 Null Transport accident 25 25 10 10 2007 2007 Technological 30 \N \N
229 Bridge Miscellaneous accident 26 26 12 12 2007 2007 Technological 50 \N \N
230 Null Flood 11 27 2 2 2008 2008 Hydrological 11 \N 3500
231 Null Flood 15 16 11 11 2008 2008 Hydrological 33 \N 83000
232 Null Flood 1 14 3 3 2008 2008 Hydrological 3 \N 12000
233 Null Flood 26 1 4 5 2008 2008 Hydrological \N \N 2000
234 Null Flood 31 3 1 3 2008 2008 Hydrological 7 \N 81400
235 Cholera Epidemic 1 30 1 11 2008 2008 Biological 229 \N 9942
236 Cholera Epidemic 1 17 1 5 2008 2009 Biological 134 \N 7495
237 King Air B200 Transport accident 19 19 1 1 2008 2008 Technological 25 \N \N
238 Null Transport accident 15 15 2 2 2008 2008 Technological 15 \N \N
239 Building Miscellaneous accident 13 13 3 3 2008 2008 Technological 11 \N \N
240 Null Flood 10 24 4 4 2008 2008 Hydrological \N \N 400
241 Propone gaz facility Industrial accident 10 10 8 8 2008 2008 Technological 2 18 12500
242 Null Earthquake 20 20 2 2 2008 2008 Geophysical 3 25 \N
243 Null Earthquake 9 9 9 9 2008 2008 Geophysical 2 60 565
244 Null Earthquake 16 16 11 11 2008 2008 Geophysical 6 77 10000
245 Mt. Egon Volcanic activity 15 15 4 4 2008 2008 Geophysical \N \N 600
246 Null Flood 8 12 2 2 2008 2008 Hydrological 14 \N 7000
247 Null Flood 23 27 4 4 2008 2008 Hydrological \N \N 34514
248 Null Flood 2 6 1 1 2008 2008 Hydrological \N \N 1000
249 Null Flood 1 6 2 2 2008 2008 Hydrological 3 \N 88261
250 Null Flood 30 31 1 1 2008 2008 Hydrological 3 \N 40000
251 Null Flood 10 3 3 4 2008 2008 Hydrological \N \N 60000
252 Null Flood 6 8 9 9 2008 2008 Hydrological 16 \N 118000
253 Null Flood \N \N 10 10 2008 2008 Hydrological 5 \N 11000
254 Null Flood 26 12 12 1 2008 2009 Hydrological 24 \N 15000
255 Null Landslide 5 5 5 5 2008 2008 Hydrological 21 \N \N
256 Sand mine Industrial accident 29 29 10 10 2008 2008 Technological 25 \N \N
257 Null Miscellaneous accident 29 29 7 7 2008 2008 Technological 16 \N \N
258 Stampede Miscellaneous accident 15 15 9 9 2008 2008 Technological 21 11 \N
259 Null Flood 27 2 1 2 2009 2009 Hydrological 18 \N 12000
260 Null Flood 26 27 3 3 2009 2009 Hydrological 64 \N 1600
261 Null Flood 14 16 2 2 2009 2009 Hydrological 2 \N \N
262 Null Flood 1 16 3 4 2009 2009 Hydrological 60 \N 220000
263 Cholera Epidemic \N \N 3 3 2009 2009 Biological 9 \N 143
264 Helicopter Transport accident 12 12 3 3 2009 2009 Technological 16 \N 1
265 Null Earthquake 3 3 1 1 2009 2009 Geophysical 5 250 4000
266 Null Earthquake 11 11 2 2 2009 2009 Geophysical \N 64 2985
267 Null Landslide 18 18 1 1 2009 2009 Hydrological 15 \N 5
268 Fokker 27 Transport accident 6 6 4 4 2009 2009 Technological 24 \N \N
269 Null Transport accident 17 17 4 4 2009 2009 Technological 11 \N \N
270 Ferry "Teratai Prima" Transport accident 10 11 1 1 2009 2009 Technological 247 \N 34
271 Null Transport accident 13 14 1 1 2009 2009 Technological 28 \N \N
272 Null Flood 28 16 10 11 2007 2007 Hydrological 22 \N 1600000
273 Null Flood 16 27 8 8 2007 2007 Hydrological 26 40 2800
274 Lorenzo Storm 28 1 9 10 2007 2007 Meteorological 5 \N 33000
275 Null Storm 3 7 12 12 2007 2007 Meteorological 17 28 1100
276 Null Storm 4 8 5 5 2007 2007 Meteorological 12 40 \N
277 Null Storm 13 17 4 4 2007 2007 Meteorological 23 \N \N
278 Null Flood 26 6 6 7 2007 2007 Hydrological 8 \N 5000
279 Null Flood 14 15 4 4 2007 2007 Hydrological 38 \N \N
280 Null Landslide 6 6 11 11 2007 2007 Hydrological 16 \N \N
281 Null Flood 7 21 12 12 2007 2007 Hydrological 3 \N 65000
282 Null Storm 21 25 5 5 2007 2007 Meteorological 5 \N \N
283 Null Flood 19 20 6 6 2007 2007 Hydrological 4 \N 120
284 Null Wildfire 21 24 10 10 2007 2007 Climatological 8 64 640000
285 Null Storm 23 25 2 2 2007 2007 Meteorological 4 27 \N
286 Dean Storm 21 24 8 8 2007 2007 Meteorological 9 \N 140000
287 Felix Storm 4 6 9 9 2007 2007 Meteorological \N \N \N
288 Null Storm 24 26 4 4 2007 2007 Meteorological 10 80 \N
289 Erin Storm 16 19 8 8 2007 2007 Meteorological 7 \N \N
290 Null Storm 23 26 12 12 2007 2007 Meteorological 22 \N \N
291 Null Storm 9 11 12 12 2007 2007 Meteorological 24 2 \N
292 Null Flood 10 24 8 8 2007 2007 Hydrological 2 \N 19000
293 Dengue Epidemic \N \N 7 7 2007 2007 Biological 182 \N 17000
294 Antonov AN-24 XU-UA4 Transport accident 25 25 6 6 2007 2007 Technological 22 \N \N
295 Null Flood 4 12 9 9 2007 2007 Hydrological \N \N 55000
296 Henriette Storm 1 1 9 9 2007 2007 Meteorological 6 \N \N
297 Null Transport accident 4 4 7 7 2007 2007 Technological 32 \N \N
298 Null Transport accident 9 9 9 9 2007 2007 Technological 29 120 \N
299 Null Transport accident 15 15 9 9 2007 2007 Technological 15 12 \N
300 Null Transport accident 19 19 10 10 2007 2007 Technological 24 \N \N
301 Oil plateform Industrial accident 23 24 10 10 2007 2007 Technological 23 \N 63
302 Null Flood 11 21 5 5 2007 2007 Hydrological \N \N 1000
303 Monsoonal rain Flood 5 10 9 11 2007 2007 Hydrological 10 \N 17000
304 Null Flood 22 29 10 10 2007 2007 Hydrological 2 \N 100000
305 MD-82 Transport accident 16 16 9 9 2007 2007 Technological 90 40 \N
306 Null Transport accident 20 20 3 3 2007 2007 Technological 29 37 \N
307 Null Transport accident 23 23 12 12 2007 2007 Technological 22 \N \N
308 Null Storm 1 2 3 3 2007 2007 Meteorological 20 20 \N
309 Null Flood 24 29 5 5 2007 2007 Hydrological 8 \N 100
310 Null Flood 17 22 6 6 2007 2007 Hydrological 10 \N 750
311 Null Wildfire 24 2 6 7 2007 2007 Climatological \N \N \N
312 Null Wildfire 24 27 11 11 2007 2007 Climatological \N \N 10000
313 Cessna 208B Transport accident 7 7 10 10 2007 2007 Technological 10 \N \N
314 Bridge Miscellaneous accident 2 2 8 8 2007 2007 Technological 29 60 \N
315 Null Drought \N \N 10 6 2007 2009 Climatological \N \N \N
316 Home Miscellaneous accident 7 8 3 3 2007 2007 Technological 10 \N \N
317 Hurricane Dolly Storm 20 21 7 7 2008 2008 Meteorological 2 \N 500000
318 Null Flood 5 9 1 1 2008 2008 Hydrological 2 \N 1500
319 Null Storm 22 26 5 5 2008 2008 Meteorological 7 70 \N
320 Null Storm 10 12 5 5 2008 2008 Meteorological 22 150 \N
321 Null Storm 5 6 2 2 2008 2008 Meteorological 59 150 \N
322 Null Storm 14 14 3 3 2008 2008 Meteorological 2 27 150
323 Hurricane Dolly Storm 23 23 7 7 2008 2008 Meteorological \N \N \N
324 Null Flood 17 20 3 4 2008 2008 Hydrological 18 \N 1000
325 Null Flood 9 30 6 6 2008 2008 Hydrological 24 148 11000000
326 Cyclone Nargis Storm 2 3 5 5 2008 2008 Meteorological \N \N \N
327 Tropical storm "Kammuri" (Julian) Storm 11 20 8 8 2008 2008 Meteorological \N \N \N
328 Tropical Storm "Fay" Storm 20 28 8 8 2008 2008 Meteorological 12 \N 400
329 Hurricane Ike Storm 12 16 9 9 2008 2008 Meteorological 82 \N 200000
330 Null Flood 6 11 7 7 2008 2008 Hydrological 12 \N 20000
331 Null Landslide 17 18 9 9 2008 2008 Hydrological 22 \N \N
332 Helicopter Bell-212 Transport accident 18 18 4 4 2008 2008 Technological 11 \N \N
333 Bi-motor Transport accident 4 4 11 11 2008 2008 Technological 15 7 \N
334 Null Transport accident 19 19 5 5 2008 2008 Technological 24 \N \N
335 Null Transport accident 29 29 6 6 2008 2008 Technological 14 28 \N
336 Null Transport accident 7 7 7 7 2008 2008 Technological 11 \N \N
337 Null Transport accident 18 18 10 10 2008 2008 Technological 11 20 \N
338 Null Transport accident 7 7 11 11 2008 2008 Technological 17 5 \N
339 Null Miscellaneous accident 20 20 6 6 2008 2008 Technological 12 20 \N
340 Null Flood 20 20 11 12 2008 2008 Hydrological 21 \N 700000
341 Null Flood 29 19 12 1 2008 2009 Hydrological \N \N 32584
342 Null Flood 13 7 9 10 2008 2008 Hydrological 18 \N 839573
343 Helicopter UH-1H Transport accident 5 5 8 8 2008 2008 Technological 10 \N \N
344 Null Transport accident 10 10 10 10 2008 2008 Technological 22 27 \N
345 Null Drought \N \N 4 \N 2008 2008 Climatological \N \N 10000000
346 Null Storm 29 30 1 1 2008 2008 Meteorological 4 \N \N
347 Null Storm 9 11 4 4 2008 2008 Meteorological 3 \N \N
348 Null Storm 28 28 4 4 2008 2008 Meteorological \N 200 \N
349 Null Storm 11 22 12 12 2008 2008 Meteorological 5 \N \N
350 Null Extreme temperature 11 14 12 12 2008 2008 Meteorological \N \N \N
351 Null Earthquake 21 21 2 2 2008 2008 Geophysical \N 3 2100
352 Null Flood 29 16 12 1 2008 2009 Hydrological \N \N 30000
353 Null Storm 4 9 1 1 2008 2008 Meteorological 12 \N \N
354 Hurricane "Gustav" Storm 1 1 9 9 2008 2008 Meteorological 43 \N 2100000
355 Hurricane Hanna Storm 28 28 8 8 2008 2008 Meteorological 7 \N \N
356 Null Wildfire 20 9 6 7 2008 2008 Climatological 1 \N \N
357 Bimoteur Transport accident 22 22 8 8 2008 2008 Technological 10 \N \N
358 Null Transport accident 8 8 8 8 2008 2008 Technological 12 26 \N
359 Null Transport accident 5 5 10 10 2008 2008 Technological 10 30 \N
360 Null Transport accident 13 13 9 9 2008 2008 Technological 25 135 \N
361 House Miscellaneous accident 3 3 4 4 2008 2008 Technological 10 \N 2
362 Null Wildfire 13 18 11 11 2008 2008 Climatological \N 20 55000
363 Null Storm 9 10 4 4 2009 2009 Meteorological 9 72 750
364 Null Transport accident 16 16 3 3 2009 2009 Technological 11 18 \N
365 Null Transport accident 16 16 4 4 2009 2009 Technological 18 66 \N
366 Gas intoxication Industrial accident 21 21 3 3 2009 2009 Technological 11 1 \N
367 Null Transport accident 27 27 3 3 2009 2009 Technological 17 59 \N
368 Nightclub "Santika" Miscellaneous accident 1 1 1 1 2009 2009 Technological 66 200 \N
369 Null Flood 24 20 3 4 2009 2009 Hydrological 2 60 5000
370 Null Extreme temperature 26 28 1 1 2009 2009 Meteorological 58 \N \N
371 Bombardier Dash 8 Q400 Transport accident 12 12 2 2 2009 2009 Technological 50 \N \N
372 Null Transport accident 22 22 3 3 2009 2009 Technological 14 \N \N
373 Null Flood 13 \N 12 12 2007 2007 Hydrological 3 \N 15000
374 Null Drought \N \N 1 6 2007 2009 Climatological \N \N 2100000
375 Null Extreme temperature 21 27 5 5 2007 2007 Meteorological 22 \N \N
376 Null Flood 27 2 7 8 2007 2007 Hydrological \N \N 38000
377 Null Wildfire 27 30 7 7 2007 2007 Climatological 26 \N \N
378 Null Transport accident 19 19 2 2 2007 2007 Technological 17 45 \N
379 Null Transport accident 24 24 5 5 2007 2007 Technological 14 3 \N
380 Null Transport accident 19 19 8 8 2007 2007 Technological 22 \N \N
381 Null Transport accident 8 8 9 9 2007 2007 Technological 15 \N \N
382 Null Transport accident 7 7 10 10 2007 2007 Technological 12 6 \N
383 Null Transport accident 22 22 12 12 2007 2007 Technological 10 21 \N
384 St Helena Mine Industrial accident 2 2 10 10 2007 2007 Technological 23 \N \N
385 Null Miscellaneous accident 30 30 9 9 2007 2007 Technological 2 \N \N
386 Home for old people Miscellaneous accident 6 6 11 11 2007 2007 Technological 15 \N \N
387 Null Flood 19 2 12 1 2007 2008 Hydrological 24 \N 2000
388 Favio Storm 27 27 2 2 2007 2007 Meteorological \N \N \N
389 Null Transport accident 6 6 3 3 2007 2007 Technological 34 \N \N
390 Null Transport accident 29 29 12 12 2007 2007 Technological 12 3 \N
391 Null Epidemic 25 \N 5 2 2007 2008 Biological 67 \N 10000
392 Null Storm 14 14 11 11 2008 2008 Meteorological 5 76 \N
393 Null Flood 19 19 6 6 2008 2008 Hydrological 11 \N 4000
394 Null Wildfire 30 3 8 9 2008 2008 Climatological 34 25 \N
395 Cholera Epidemic 15 31 11 5 2008 2009 Biological 65 \N 12752
396 Null Transport accident 3 3 3 3 2008 2008 Technological 10 \N \N
397 Null Transport accident 2 2 3 3 2008 2008 Technological 10 \N \N
398 Null Transport accident 3 3 4 4 2008 2008 Technological 17 53 \N
399 Null Transport accident 27 27 5 5 2008 2008 Technological 28 20 \N
400 Null Transport accident 7 7 10 10 2008 2008 Technological 27 \N \N
401 Null Transport accident 12 12 11 11 2008 2008 Technological 23 9 \N
402 Null Transport accident 22 22 12 12 2008 2008 Technological 14 \N 5
403 Cholera Epidemic 15 23 8 7 2008 2009 Biological 4276 \N 98349
404 Null Transport accident 30 30 6 6 2008 2008 Technological 14 \N \N
405 Null Earthquake 30 30 9 9 2009 2009 Geophysical 1195 1798 2500000
406 Null Earthquake 2 2 9 9 2009 2009 Geophysical 128 1442 338350
407 Null Storm 3 4 1 1 2009 2009 Meteorological 18 \N \N
408 Null Flood 28 3 2 3 2009 2009 Hydrological 3 \N 300
409 Null Transport accident 15 15 4 4 2009 2009 Technological 29 39 \N
410 Null Flood 10 10 12 12 2009 2009 Hydrological \N \N \N
411 Diarroheic diseases Epidemic \N \N 1 12 2009 2009 Biological 107 \N 25795
412 Null Transport accident 12 12 11 11 2009 2009 Technological 32 40 \N
413 Null Storm 1 3 8 8 2009 2009 Meteorological 2 \N \N
414 Null Flood 1 9 4 4 2009 2009 Hydrological \N \N 200
415 Hurricane Bill Storm 23 23 8 8 2009 2009 Meteorological \N 3 \N
416 Null Earthquake 8 8 11 11 2009 2009 Geophysical 2 100 1410
417 Null Flood 15 18 9 9 2009 2009 Hydrological 38 \N 10000
418 Null Flood 8 8 10 10 2009 2009 Hydrological \N \N 2500
419 Null Flood 8 8 12 12 2009 2009 Hydrological 6 4 700
420 Null Landslide 8 8 11 11 2009 2009 Hydrological 14 \N \N
421 Military plane Air Force Fokker F-27 Transport accident 20 20 5 5 2009 2009 Technological 100 15 \N
422 Ferry "Dumai Express 10" Transport accident 22 22 11 11 2009 2009 Technological 46 \N 245
423 Coal mine Industrial accident 16 16 6 6 2009 2009 Technological 41 \N \N
424 Aldulterated alcool Miscellaneous accident 23 28 5 5 2009 2009 Technological 25 \N \N
425 Karaoke club Miscellaneous accident 4 4 12 12 2009 2009 Technological 20 13 \N
426 Mt. Merapi Volcanic activity 24 24 10 10 2010 2010 Geophysical 322 454 136686
427 Null Earthquake 16 16 6 6 2010 2010 Geophysical 17 \N \N
428 Null Flood 2 6 10 10 2010 2010 Hydrological 291 3417 9011
429 Null Flood 23 1 2 3 2010 2010 Hydrological 44 \N \N
430 Null Flood 23 25 7 7 2010 2010 Hydrological 21 7 15000
431 Null Earthquake 25 25 10 10 2010 2010 Geophysical 530 412 11452
432 Null Flood 1 17 3 3 2010 2010 Hydrological 7 11 110875
433 Null Flood 21 22 3 3 2010 2010 Hydrological \N \N \N
434 Null Flood 15 18 10 10 2010 2010 Hydrological 18 20 \N
435 Null Storm 26 28 12 12 2010 2010 Meteorological \N \N \N
436 Mt. Sinabung Volcanic activity 29 7 8 9 2010 2010 Geophysical 1 1 15059
437 Null Flood 22 22 1 1 2010 2010 Hydrological 10 \N 225
438 Null Flood 2 5 11 11 2010 2010 Hydrological 16 \N 200
439 Null Flood 11 11 1 1 2010 2010 Hydrological 5 \N 28500
440 Null Flood 11 11 9 9 2010 2010 Hydrological 24 \N \N
441 Null Landslide 12 12 10 10 2010 2010 Hydrological 13 18 \N
442 Null Transport accident 9 9 8 8 2010 2010 Technological 10 \N 78
443 Ferry Transport accident 22 22 10 10 2010 2010 Technological 22 \N 44
444 Null Transport accident 2 2 10 10 2010 2010 Technological 36 30 \N
445 Bridge Miscellaneous accident 6 6 6 6 2010 2010 Technological 12 25 \N
446 Null Earthquake 11 11 3 3 2011 2011 Geophysical 1 \N \N
447 Null Flood 3 4 1 1 2011 2011 Hydrological 17 \N \N
448 Null Flood \N \N 3 3 2011 2011 Hydrological 113 \N 65084
449 Null Flood 4 31 4 5 2011 2011 Hydrological 5 \N 2000
450 Null Flood 6 7 2 2 2011 2011 Hydrological \N \N 60
451 Null Flood 16 20 1 1 2011 2011 Hydrological \N \N 12000
452 Null Flood 10 11 3 3 2011 2011 Hydrological 21 \N 750
453 Null Landslide 6 6 5 5 2011 2011 Hydrological 19 4 \N
454 MA-60 Transport accident 7 7 5 5 2011 2011 Technological 25 \N \N
455 Null Transport accident 12 12 7 7 2011 2011 Technological 16 \N \N
456 Ferry "Laut Teduh II" Transport accident 28 28 1 1 2011 2011 Technological 27 200 427
457 Null Transport accident 6 6 6 6 2011 2011 Technological 28 \N 70
458 Hurricane Jimena Storm 2 3 9 9 2009 2009 Meteorological 4 \N 72000
459 Null Storm 10 18 6 6 2009 2009 Meteorological 1 2 \N
460 Null Storm 16 18 4 4 2009 2009 Meteorological 6 \N \N
461 Null Flood 10 19 9 9 2009 2009 Hydrological 3 \N 18000
462 Null Flood 3 10 5 5 2009 2009 Hydrological \N \N \N
463 Null Storm 26 28 3 3 2009 2009 Meteorological 6 25 \N
464 Null Storm 20 21 7 7 2009 2009 Meteorological 1 \N \N
465 Null Storm 10 13 2 2 2009 2009 Meteorological 16 50 \N
466 Hurricane "Ida" Storm 9 10 11 11 2009 2009 Meteorological 6 \N \N
467 Hurricane Bill Storm 23 23 8 8 2009 2009 Meteorological 3 9 \N
468 Tropical storm "Ondoy" (Ketsana) Storm 29 30 9 9 2009 2009 Meteorological 17 91 178000
469 Tropical storm "Mirinae" (Santi) Storm 2 3 11 11 2009 2009 Meteorological 2 \N \N
470 Null Transport accident 10 10 10 10 2009 2009 Technological 27 \N 13
471 Null Flood 1 10 9 9 2009 2009 Hydrological 4 \N 1500
472 Null Flood 1 12 11 11 2009 2009 Hydrological \N \N 107670
473 Null Flood 2 2 10 10 2009 2009 Hydrological 10 14 13000
474 Null Flood 14 16 7 7 2009 2009 Hydrological 11 \N \N
475 Hurricane "Ida" Storm 8 8 11 11 2009 2009 Meteorological \N \N 40000
476 Dengue Epidemic \N \N 10 12 2009 2009 Biological \N \N 41687
477 Nursery Miscellaneous accident 5 5 6 6 2009 2009 Technological 49 30 \N