SheetHub
Search
Login
ronnywang
Natural Earth-Countries
本站大部份資料在 2016 年後就未更新,若資料內無明確標示資料時間,請預設該資料為過時資料並斟酌使用,謝謝
詳細資料
資料瀏覽
地圖瀏覽
SQL
索引
下載
CSV
Excel
JSON
ArrayJSON
GeoJSON
SELECT * FROM this WHERE %56 = 'North America' AND %57 = 'Seven seas (open ocean)' ORDER BY _id_ ASC
RUN
(計算時間: 0.005秒, 共找到 1 筆資料,顯示第 1 到 1 筆)
可用欄位參考
scalerank
featurecla
LABELRANK
SOVEREIGNT
SOV_A3
ADM0_DIF
LEVEL
TYPE
ADMIN
ADM0_A3
GEOU_DIF
GEOUNIT
GU_A3
SU_DIF
SUBUNIT
SU_A3
BRK_DIFF
NAME
NAME_LONG
BRK_A3
BRK_NAME
BRK_GROUP
ABBREV
POSTAL
FORMAL_EN
FORMAL_FR
NOTE_ADM0
NOTE_BRK
NAME_SORT
NAME_ALT
MAPCOLOR7
MAPCOLOR8
MAPCOLOR9
MAPCOLOR13
POP_EST
GDP_MD_EST
POP_YEAR
LASTCENSUS
GDP_YEAR
ECONOMY
INCOME_GRP
WIKIPEDIA
FIPS_10_
ISO_A2
ISO_A3
ISO_N3
UN_A3
WB_A2
WB_A3
WOE_ID
WOE_ID_EH
WOE_NOTE
ADM0_A3_IS
ADM0_A3_US
ADM0_A3_UN
ADM0_A3_WB
CONTINENT
REGION_UN
SUBREGION
REGION_WB
NAME_LEN
LONG_LEN
ABBREV_LEN
TINY
HOMEPART
scalerank
featurecla
LABELRANK
SOVEREIGNT
SOV_A3
ADM0_DIF
LEVEL
TYPE
ADMIN
ADM0_A3
GEOU_DIF
GEOUNIT
GU_A3
SU_DIF
SUBUNIT
SU_A3
BRK_DIFF
NAME
NAME_LONG
BRK_A3
BRK_NAME
BRK_GROUP
ABBREV
POSTAL
FORMAL_EN
FORMAL_FR
NOTE_ADM0
NOTE_BRK
NAME_SORT
NAME_ALT
MAPCOLOR7
MAPCOLOR8
MAPCOLOR9
MAPCOLOR13
POP_EST
GDP_MD_EST
POP_YEAR
LASTCENSUS
GDP_YEAR
ECONOMY
INCOME_GRP
WIKIPEDIA
FIPS_10_
ISO_A2
ISO_A3
ISO_N3
UN_A3
WB_A2
WB_A3
WOE_ID
WOE_ID_EH
WOE_NOTE
ADM0_A3_IS
ADM0_A3_US
ADM0_A3_UN
ADM0_A3_WB
CONTINENT
REGION_UN
SUBREGION
REGION_WB
NAME_LEN
LONG_LEN
ABBREV_LEN
TINY
HOMEPART
5
Admin-0 country
5
United States of America
US1
1
2
Dependency
United States Minor Outlying Islands
UMI
0
United States Minor Outlying Islands
UMI
0
United States Minor Outlying Islands
UMI
0
U.S. Minor Outlying Is.
United States Minor Outlying Islands
UMI
U.S. Minor Outlying Is.
U.S. MOI
UM
U.S.A.
United States Minor Outlying Islands
4
5
1
1
-99
-99
-99
-99
-99
7. Least developed region
5. Low income
-99
-99
UM
UMI
581
-099
-99
-99
28289407
28289407
Exact WOE match as country
UMI
UMI
-99
-99
North America
Seven seas (open ocean)
Seven seas (open ocean)
East Asia & Pacific
23
36
8
-99
-99
«
Previous
1
»
Next