World Country Flags & Currency Images

Flag, organization, currency images, government personnel by countries

Data Structure

continent [6]
bigint(20) unsigned
+ id (100%)
timestamp
+ ts (100%)
varchar(255)
+ title (100%)
country [196]
bigint(20) unsigned
+ id (100%)
timestamp
+ ts (100%)
varchar(255)
+ title (100%)
varchar(255)
+ slug (100%)
varchar(255)
+ capital_city (100%)
varchar(255)
+ population (100%)
varchar(255)
+ total_area (100%)
varchar(255)
+ formation (100%)
varchar(255)
+ highest_point (100%)
varchar(255)
+ gdp (100%)
varchar(255)
+ currency (100%)
varchar(255)
+ code (100%)
varchar(255)
+ calling_code (100%)
varchar(255)
+ internet_tld (100%)
varchar(255)
+ title_czech (100%)
varchar(255)
+ title_english (100%)
varchar(255)
+ title_german (100%)
varchar(255)
+ title_french (100%)
varchar(255)
+ title_italian (100%)
varchar(255)
+ title_spanish (100%)
varchar(255)
+ title_russian (100%)
varchar(255)
+ title_slovak (100%)
varchar(255)
+ title_polish (100%)
country_to_continent [202]
bigint(20) unsigned
+ id (100%)
timestamp
+ ts (100%)
bigint(20) unsigned
+ country_id (100%)
bigint(20) unsigned
+ continent_id (100%)
country_to_organization [73]
bigint(20) unsigned
+ id (100%)
timestamp
+ ts (100%)
bigint(20) unsigned
+ country_id (100%)
bigint(20) unsigned
+ organization_id (100%)
currency_image [1,441]
bigint(20) unsigned
+ id (100%)
timestamp
+ ts (100%)
bigint(20) unsigned
+ country_id (100%)
varchar(255)
+ mini_img (100%)
varchar(255)
+ big_img (100%)
flag [784]
bigint(20) unsigned
+ id (100%)
timestamp
+ ts (100%)
bigint(20) unsigned
+ country_id (100%)
varchar(255)
+ image_name (100%)
varchar(255)
+ type (100%)
varchar(255)
+ width_height (100%)
varchar(255)
+ file_size (100%)
government_position [65]
bigint(20) unsigned
+ id (100%)
timestamp
+ ts (100%)
varchar(255)
+ position (100%)
organization [4]
bigint(20) unsigned
+ id (100%)
timestamp
+ ts (100%)
varchar(255)
+ title (100%)
person [426]
bigint(20) unsigned
+ id (100%)
timestamp
+ ts (100%)
bigint(20) unsigned
+ country_id (100%)
varchar(255)
+ name (100%)
bigint(20) unsigned
+ government_position_id (100%)

Description

This database is mainly about flags and currency images of 196 countries from 6 continents all over the world. You can easily search one of the country's flag image including 4 versions: mini (30x20)*, normal (550x367)*, big (1600x800)* and ultra (2560x1536)* sizes, affiliated organizations that they take part in and currencies that they have used in the past and present from the 196 countries information database. It also comes with 426 important personnel and their government positions from the different countries. Each country record consists of title, slug, capital city, population, total area, formation date, highest point, GDP, currency, ISO official code, calling code, internet TLD and the name in 9 different languages. * These dimensions are approximate.

Data Profile

Size 688K
Tables 9
Last Commit 2016-09-07 01:24:32

Updates / Commits

Time Size Tables Columns Rows
2016-09-07 01:24:32 688K 9 57 3197

Pricing

All prices are in Datactory Credits.

TableRowsPrice per Row (Credits)Subtotal (Credits)
continent 6 .001 0.006
country 196 .001 0.196
country_to_continent 202 .001 0.202
country_to_organization 73 .001 0.073
currency_image 1,441 .001 1.441
flag 784 .001 0.784
government_position 65 .001 0.065
organization 4 .001 0.004
person 426 .001 0.426
Total Credits 3.197 Credits (1) (2)
(1). Plus cost by query time at 0.1 credits per second. A typical query takes about 0.001 seconds which would then charge you 0.0001 credits.
(2). This is the total amount of credits required for ALL rows in these tables. You are free to query for only a selected part of them, even a single row, and pay only for that.

How to Access

Click to see how to access this dataset.