Lets share that profit

Browsing through some of my friend’s daily status updates on everybody’s _favourite_ social networking site facebook, I came across something that caught my eye. An application that gives you a survey to fill in about yourself and general information on your likes and dislikes.

As with many facebook applications these surveys get posted to your profile then for all your friends to see, being the happy chappy you are with the new content on your profile, what you don’t realise is the amount of data you’ve just freely given to some company which they may then sell, or use for their own gain.

Is there any difference between the idea of making profit off the Internet and the believing that there is gold at the end of the rainbow? Fact is the former is true, companies are making millions by utilising the need for people to connect. Information, friends, even relationships is just a click away so why not profit off of it?

So how do I then get my share of this ever expanding goldmine? Day by day more and more ways have been popping up of making money off the internet, and its not just available to people with the know how of the net but to the everyday computer literate Joe. There is no secret to how to be profitable online. The information you need is easy accessible all over the web, and he who controls information is king.

Whether you are looking to start an online shop, an initiative to connect people and then profit off of advertisements or working for a company scraping information off the internet, the perks remains the same, you can do more in less time, meaning more buck for your mo and your audience is not going to vanish anytime soon.

Country ISO 3166-1, ISO 4217 v2

Updated the SQL and CSV files to include the demonyms for each country, also removed all uninhabitable countries from the list.

SQL download countries.sql
CSV download countries.csv

Country ISO 3166-1, ISO 4217

Today I had to setup a database table of countries with their respective ISO 3166-1/4217 & international dialing code numbers, after beating Google with a stick and not finding the right import, I decided to compile one from information found all over. Guess sharing is caring so I’m sticking the csv and sql script up here for free use have fun!

ISO 3166-1 alpha-2 codes are two-letter country codes defined in ISO 3166-1, part of the ISO 3166 standard published by the International Organization for Standardization (ISO), to represent countries, dependent territories, and special areas of geographical interest. They are the most widely used of the country codes published by ISO, and are used most prominently for the Internet’s country code top-level domains (with a few exceptions). They were first included as part of the ISO 3166 standard in its first edition in 1974. -wikipedia

ISO 4217 is the international standard describing three-letter codes (also known as the currency code) to define the names of currencies established by the International Organization for Standardization (ISO). The ISO 4217 code list is the established norm in banking and business all over the world for defining different currencies, and in many countries the codes for the more common currencies are so well known publicly, that exchange rates published in newspapers or posted in banks use only these to define the different currencies, instead of translated currency names or ambiguous currency symbols. ISO 4217 codes are used on airline tickets and international train tickets to remove any ambiguity about the price.

SQL download countries.sql
CSV download countries.csv

The countries database has been updated here!