3 База данных (с заданиями).xls

	A	B	C	D	E	F	G	H	I	J	K	L
1	Код	Название	Континент	Регион	Площадь	Год независимости	Население	ОПЖ	ВНД	ВНД_пред	Форма правления	Код столицы
2	ABW	Aruba	North America	Caribbean	193	NULL	103000	78,4	828	793	Nonmetropolitan Territory of The Netherlands	129
3	AFG	Afghanistan	Asia	Southern and Central Asia	652090	1919	22720000	45,9	5976	NULL	Islamic Emirate	1
4	AGO	Angola	Africa	Central Africa	1246700	1975	12878000	38,3	6648	7984	Republic	56
5	AIA	Anguilla	North America	Caribbean	96	NULL	8000	76,1	63,2	NULL	Dependent Territory of the uK	62
6	ALB	Albania	Europe	Southern Europe	28748	1912	3401200	71,6	3205	2500	Republic	34
7	AND	Andorra	Europe	Southern Europe	468	1278	78000	83,5	1630	NULL	Parliamentary Coprincipality	55
8	ANT	Netherlands Antilles	North America	Caribbean	800	NULL	217000	74,7	1941	NULL	Nonmetropolitan Territory of The Netherlands	33
9	ARE	united Arab Emirates	Asia	Middle East	83600	1971	2441000	74,1	37966	36846	Emirate Federation	65
10	ARG	Argentina	South America	South America	2780400	1816	37032000	75,1	340238	323310	Federal Republic	69
11	ARM	Armenia	Asia	Middle East	29800	1991	3520000	66,4	1813	1627	Republic	126
12	ASM	American Samoa	Oceania	Polynesia	199	NULL	68000	75,1	334	NULL	uS Territory	54
13	ATA	Antarctica	Antarctica	Antarctica	13120000	NULL	0	NULL	0	NULL	Co-administrated	NULL
14	ATF	French Southern territories	Antarctica	Antarctica	7780	NULL	0	NULL	0	NULL	Nonmetropolitan Territory of France	NULL
15	ATG	Antigua and Barbuda	North America	Caribbean	442	1981	68000	70,5	612	584	Constitutional Monarchy	63
16	AUS	Australia	Oceania	Australia and New Zealand	7741220	1901	18886000	79,8	351182	392911	Constitutional Monarchy, Federation	135
17	AUT	Austria	Europe	Western Europe	83859	1918	8091800	77,7	211860	206025	Federal Republic	1523
18	AZE	Azerbaijan	Asia	Middle East	86600	1991	7734000	62,9	4127	4100	Federal Republic	144
19	BDI	Burundi	Africa	Eastern Africa	27834	1962	6695000	46,2	903	982	Republic	552
20	BEL	Belgium	Europe	Western Europe	30518	1830	10239000	77,8	249704	243948	Constitutional Monarchy, Federation	179
21	BEN	Benin	Africa	Western Africa	112622	1960	6097000	50,2	2357	2141	Republic	187
22	BFA	Burkina Faso	Africa	Western Africa	274000	1960	11937000	46,7	2425	2201	Republic	549
23	BGD	Bangladesh	Asia	Southern and Central Asia	143998	1971	129155000	60,2	32852	31966	Republic	150
24	BGR	Bulgaria	Europe	Eastern Europe	110994	1908	8190900	70,9	12178	10169	Republic	539
25	BHR	Bahrain	Asia	Middle East	694	1971	617000	73	6366	6097	Monarchy (Emirate)	149
26	BHS	Bahamas	North America	Caribbean	13878	1973	307000	71,1	3527	3347	Constitutional Monarchy	148
27	BIH	Bosnia and Herzegovina	Europe	Southern Europe	51197	1992	3972000	71,5	2841	NULL	Federal Republic	201
28	BLR	Belarus	Europe	Eastern Europe	207600	1991	10236000	68	13714	NULL	Republic	3520
29	BLZ	Belize	North America	Central America	22696	1981	241000	70,9	630	616	Constitutional Monarchy	185
30	BMU	Bermuda	North America	North America	53	NULL	65000	76,9	2328	2190	Dependent Territory of the uK	191
31	BOL	Bolivia	South America	South America	1098581	1825	8329000	63,7	8571	7967	Republic	194
32	BRA	Brazil	South America	South America	8547403	1822	170115000	62,9	776739	804108	Federal Republic	211
33	BRB	Barbados	North America	Caribbean	430	1966	270000	73	2223	2186	Constitutional Monarchy	174
34	BRN	Brunei	Asia	Southeast Asia	5765	1984	328000	73,6	11705	12460	Monarchy (Sultanate)	538
35	BTN	Bhutan	Asia	Southern and Central Asia	47000	1910	2124000	52,4	372	383	Monarchy	192
36	BVT	Bouvet Island	Antarctica	Antarctica	59	NULL	0	NULL	0	NULL	Dependent Territory of Norway	NULL
37	BWA	Botswana	Africa	Southern Africa	581730	1966	1622000	39,3	4834	4935	Republic	204
38	CAF	Central African Republic	Africa	Central Africa	622984	1960	3615000	44	1054	993	Republic	1889
39	CAN	Canada	North America	North America	9970610	1867	31147000	79,4	598862	625626	Constitutional Monarchy, Federation	1822
40	CCK	Cocos (Keeling) Islands	Oceania	Australia and New Zealand	14	NULL	600	NULL	0	NULL	Territory of Australia	2317
41	CHE	Switzerland	Europe	Western Europe	41284	1499	7160400	79,6	264478	256092	Federation	3248
42	CHL	Chile	South America	South America	756626	1810	15211000	75,7	72949	75780	Republic	554
43	CHN	China	Asia	Eastern Asia	9572900	-1523	1277558000	71,4	982268	917719	People'sRepublic	1891
44	CIV	Cote dIvoire	Africa	Western Africa	322463	1960	14786000	45,2	11345	10285	Republic	2814
45	CMR	Cameroon	Africa	Central Africa	475442	1960	15085000	54,8	9174	8596	Republic	1804
46	COD	Congo, The Democratic Republic of the	Africa	Central Africa	2344858	1960	51654000	48,8	6964	2474	Republic	2298
47	COG	Congo	Africa	Central Africa	342000	1960	2943000	47,4	2108	2287	Republic	2296
48	COK	Cook Islands	Oceania	Polynesia	236	NULL	20000	71,1	100	NULL	Nonmetropolitan Territory of New Zealand	583
49	COL	Colombia	South America	South America	1138914	1810	42321000	70,3	102896	105116	Republic	2257
50	COM	Comoros	Africa	Eastern Africa	1862	1975	578000	60	4401	4361	Republic	2295
51	CPV	Cape Verde	Africa	Western Africa	4033	1975	428000	68,9	435	420	Republic	1859
52	CRI	Costa Rica	North America	Central America	51100	1821	4023000	75,8	10226	9757	Republic	584
53	CUB	Cuba	North America	Caribbean	110861	1902	11201000	76,2	17843	18862	Socialistic Republic	2413
54	CXR	Christmas Island	Oceania	Australia and New Zealand	135	NULL	2500	NULL	0	NULL	Territory of Australia	1791
55	CYM	Cayman Islands	North America	Caribbean	264	NULL	38000	78,9	1263	1186	Dependent Territory of the uK	553
56	CYP	Cyprus	Asia	Middle East	9251	1960	754700	76,7	9333	8246	Republic	2430
57	CZE	Czech Republic	Europe	Eastern Europe	78866	1993	10278100	74,5	55017	52037	Republic	3339
58	DEU	Germany	Europe	Western Europe	357022	1955	82164700	77,4	2133367	2102826	Federal Republic	3068
59	DJI	Djibouti	Africa	Eastern Africa	23200	1977	638000	50,8	382	373	Republic	585
60	DMA	Dominica	North America	Caribbean	751	1978	71000	73,4	256	243	Republic	586
61	DNK	Denmark	Europe	Nordic Countries	43094	800	5330000	76,5	174099	169264	Constitutional Monarchy	3315
62	DOM	Dominican Republic	North America	Caribbean	48511	1844	8495000	73,2	15846	15076	Republic	587
63	DZA	Algeria	Africa	Northern Africa	2381741	1962	31471000	69,7	49982	46966	Republic	35
64	ECU	Ecuador	South America	South America	283561	1822	12646000	71,1	19770	19769	Republic	594
65	EGY	Egypt	Africa	Northern Africa	1001449	1922	68470000	63,3	82710	75617	Republic	608
66	ERI	Eritrea	Africa	Eastern Africa	117600	1993	3850000	55,8	650	755	Republic	652
67	ESH	Western Sahara	Africa	Northern Africa	266000	NULL	293000	49,8	60	NULL	Occupied by Marocco	2453
68	ESP	Spain	Europe	Southern Europe	505992	1492	39441700	78,8	553233	532031	Constitutional Monarchy	653
69	EST	Estonia	Europe	Baltic Countries	45227	1991	1439200	69,5	5328	3371	Republic	3791
70	ETH	Ethiopia	Africa	Eastern Africa	1104300	-1000	62565000	45,2	6353	6180	Republic	756
71	FIN	Finland	Europe	Nordic Countries	338145	1917	5171300	77,4	121914	119833	Republic	3236
72	FJI	Fiji Islands	Oceania	Melanesia	18274	1970	817000	67,9	1536	2149	Republic	764
73	FLK	Falkland Islands	South America	South America	12173	NULL	2000	NULL	0	NULL	Dependent Territory of the uK	763
74	FRA	France	Europe	Western Europe	551500	843	59225700	78,8	1424285	1392448	Republic	2974
75	FRO	Faroe Islands	Europe	Nordic Countries	1399	NULL	43000	78,4	0	NULL	Part of Denmark	901
76	FSM	Micronesia, Federated States of	Oceania	Micronesia	702	1990	119000	68,6	212	NULL	Federal Republic	2689
77	GAB	Gabon	Africa	Central Africa	267668	1960	1226000	50,1	5493	5279	Republic	902
78	GBR	united Kingdom	Europe	British Islands	242900	1066	59623400	77,7	1378330	1296830	Constitutional Monarchy	456
79	GEO	Georgia	Asia	Middle East	69700	1991	4968000	64,5	6064	5924	Republic	905
80	GHA	Ghana	Africa	Western Africa	238533	1957	20212000	57,4	7137	6884	Republic	910
81	GIB	Gibraltar	Europe	Southern Europe	6	NULL	25000	79	258	NULL	Dependent Territory of the uK	915
82	GIN	Guinea	Africa	Western Africa	245857	1958	7430000	45,6	2352	2383	Republic	926
83	GLP	Guadeloupe	North America	Caribbean	1705	NULL	456000	77	3501	NULL	Overseas Department of France	919
84	GMB	Gambia	Africa	Western Africa	11295	1965	1305000	53,2	320	325	Republic	904
85	GNB	Guinea-Bissau	Africa	Western Africa	36125	1974	1213000	49	293	272	Republic	927
86	GNQ	Equatorial Guinea	Africa	Central Africa	28051	1968	453000	53,6	283	542	Republic	2972
87	GRC	Greece	Europe	Southern Europe	131626	1830	10545700	78,4	120724	119946	Republic	2401
88	GRD	Grenada	North America	Caribbean	344	1974	94000	64,5	318	NULL	Constitutional Monarchy	916
89	GRL	Greenland	North America	North America	2166090	NULL	56000	68,1	0	NULL	Part of Denmark	917
90	GTM	Guatemala	North America	Central America	108889	1821	11385000	66,2	19008	17797	Republic	922
91	GUF	French Guiana	South America	South America	90000	NULL	181000	76,1	681	NULL	Overseas Department of France	3014
92	GUM	Guam	Oceania	Micronesia	549	NULL	168000	77,8	1197	1136	uS Territory	921
93	GUY	Guyana	South America	South America	214969	1966	861000	64	722	743	Republic	928
94	HKG	Hong Kong	Asia	Eastern Asia	1075	NULL	6782000	79,5	166448	173610	Special Administrative Region of China	937
95	HMD	Heard Island and McDonald Islands	Antarctica	Antarctica	359	NULL	0	NULL	0	NULL	Territory of Australia	NULL
96	HND	Honduras	North America	Central America	112088	1838	6485000	69,9	5333	4697	Republic	933
97	HRV	Croatia	Europe	Southern Europe	56538	1991	4473000	73,7	20208	19300	Republic	2409
98	HTI	Haiti	North America	Caribbean	27750	1804	8222000	49,2	3459	3107	Republic	929
99	HUN	Hungary	Europe	Eastern Europe	93030	1918	10043200	71,4	48267	45914	Republic	3483
100	IDN	Indonesia	Asia	Southeast Asia	1904569	1945	212107000	68	84982	215002	Republic	939