Web Analytics Made Easy -
StatCounter

Index of database projects made so far

Here is the list of 80+ database projects made by me, from personal interest to distribute freely (small ones) or sell for professional use (big ones), as well as databases made at request of single or multiple customers and published on website to allow other customers to purchase them if interested.

Not included in below list are the databases created as one-time project for single customers outside of my fields of interest, few of them made under non-disclosure agreement.

I offer web scraping services, making custom databases according your requirements.

Project Type Size (KB) Pages / rows How was
made
Price Made in Update frequency
World Geography
Solar System (Word version) DOC manual free 2000 ? deleted
Solar System (Excel version) XLS 45 35 rows manual free 2014 no
World countries & facts (Word, based on old atlas) DOC manual free 1998-2000 deleted
World countries & facts (Excel, based Encarta 2002) XLS 81 ~200 rows manual free 2004 abandoned
World countries & facts
(based on The World Factbook)
XLSX 2208 268 rows scraping $36 2017 by request (low sales)
World cities population (original version) DOC 727 130 pages manual free 2003-2005 deleted
World cities population (Word simple) DOC 477 50 pages manual $10 2016 by request (low sales)
World cities population (Word detailed) DOC 781 150 pages manual $20 2016 by request (low sales)
World cities population (Excel detailed) XLS 1075 7500+ rows manual $40 2016 by request (low sales)
World tallest buildings database XLS 5425 15000+ rows scraping about $150 2015 no (no sales)
United States all buildings database XLS 91627 160000+ rows scraping about $800 2016 no (no sales)
Singapore real estate
Database of HDB Blocks XLS 6000+ 14000+ rows manual $150-1200 2009 at new announcements
Database of HDB Resale Flat Prices 2009-2013 XLS 24307 160000+ rows copy-paste 2009 no
Database of HDB Resale Flat Prices 1990-2018 XLSX 60000+ 700000+ rows copy-paste 2017 by request (low sales)
Database of condos SingaporeExpats XLS 2981 3100+ rows scraping about $150 2015 by request (low sales)
Database of condos PropertyGuru XLS 2334 3200+ rows scraping about $300 2016 by request (low sales)
Database of all buildings XLSX 13737 120000+ rows scraping about $600 2017 by request (low sales)
Managing Agent Database XLS 1185 4200+ rows scraping about $200 2017 by request (low sales)
List of BTO & DBSS projects XLS 103 300+ rows manual free 2009 at new announcements
List of BTO prices XLS 183 700+ rows manual about $30 2015 at new announcements
List of SERS sites XLS 49 80 rows manual free 2009 at new announcements
List of HUDC estates XLS 64 24 rows manual free 2009 at new announcements
List of Executive Condominiums XLS 132 66 rows manual free 2009 at new announcements
Hong Kong real estate – download from https://www.teoalida.com/hongkong/housingdatabase/
Hong Kong Public & Private Housing Estates
(Gohome and Centadata mixed up)
XLS 592 1000+ rows manual about $200 2011 abandoned
Hong Kong Housing Database Estates (Centadata) XLS 806 3200+ rows scraping about $70 Sep 2016 by request (low sales)
Hong Kong Housing Database Buildings (Centadata) XLS 4093 24370 rows scraping about $500 May 2018 by request (low sales)
Hong Kong Housing Authority XLS 420 476 rows scraping about $50 May 2018 by request (low sales)
Automobile research – download from www.teoalida.com/cardatabase
Car Models List (Worldwide) DOC 403 59 pages manual free 2003 abandoned 2015 (free product
don’t deserve updates)
Car Models Timeline (Worldwide) XLS 584 manual free 2003 abandoned 2015 (free product
don’t deserve updates)
Car Models List (Worldwide) XLS 1545 4500+ rows manual about $25-50 2012 every 3-6 months (high sales)
Car Nameplates List (Worldwide) XLS 524 3000+ rows manual about $30 2016 every year (low sales)
Car Models Encyclopedia (Europe) DOC 1680 360 pages manual about $50 2005 abandoned 2013 (low sales)
Car Models Database (Europe) XLS 1346 3500+ rows manual about $30-$80 2005 every 3-6 months (high sales)
Car Models & Engines Database (Europe) XLS 13532 18000+ rows manual about $150-500 2003 every 3-6 months (high sales)
American Year-Make-Model XLS 1567 14000+ rows manual about $10-80 2013 every year (high sales)
American Year-Make-Model-Trim-Specs XLS 104707 55000+ rows scraping about $50-350 2014 every 3 months (high sales)
Second American Car Database XLS 113716 55000+ rows scraping about $50-450 2017 every 3 months (high sales)
German Car Database XLS 250178 110000+ rows scraping about $200-500 2015 every 3-6 months (low sales)
UK Car Database XLSX ? 80000+ rows scraping about $160-320 Jan 2019
Japan Car Database XLSX ? 80000+ rows scraping Mar 2019
Indian Car Database XLS 17152 4000+ rows scraping $40-160 2015 every month (high sales)
Indian Bike Database XLS 1825 600+ rows scraping $25-50 2016 by request (low sales)
Middle East GCC Car Database XLS 7607 11000+ rows scraping about $10-120 2016 every 3 months (high sales)
Malaysia Car Database XLS scraping Sep 2018
Singapore Car Database XLS scraping Nov 2018
Australian Car Database small XLS 1041 14000+ rows scraping about $10-70 2017 every 3 months (high sales)
Australian Car Database big XLSX 51223 90000+ rows scraping about $40-500 2017 every 3 months (high sales)
Motorcycles Database XLS 24569 30000+ rows scraping about $300 2016 every 3-6 months (high sales)
AutoKatalog Statistics XLS 212 manual free 2012 2014 is the last AutoKatalog
Automobile Production XLS 130 copy-paste free 2012 every year
Automobile Sales Figures XLS 833 scraping up to $100 Feb 2017 every year
UAE Car Valuation XLS 2883 23000+ rows scraping about $120 Jul 1905 every 3 months (high sales)
Wheels and Tires Size (Worldwide) XLSX 34113 400000+ rows scraping about $250 Mar 2018 by request (low sales)
Chip tuning / ECU remap database (Europe) XLS 2038 4000+ rows scraping about $100 Feb 2018 by request (low sales)
Lights Bulbs Database (American) XLS 21333 37000+ rows scraping about $300 Mar 2017 by request (low sales)
Computers & technology
Excel colors with RGB values XLSX 25 manual free 2018 no
Calendar for any year 1900-9999 XLS 224 manual free 2018 no
Screen size calculator XLS 50.5 manual free May 2014 abandoned 2016
Screen resolution statistics XLS 326 copy-paste free May 2014 abandoned 2016
Screen resolution statistics by country XLS 2380 copy-paste free May 2014 abandoned 2016
Mobile phones database XLS 8968 9000+ rows scraping about $200 Aug 2016 every month (high sales)
Digital cameras database XLS 2805 3700+ rows scraping about $60 Dec 2017 by request (low sales)
Gaming stuff – see www.teoalida.com/games
Age of Empires DOC 208 manual free 2001? no
Age of Empires XLS 106 manual free 2007? no
Age of Empires Expansion XLS 112 manual free 2007? no
Beetle Crazy Cup XLS 71 manual free 2002? no
Driver Education (questions) DOC 264 manual free 2000, 2006 no
GTA Vice City XLS 117 manual free 2005 no
GTA San Andreas XLS 134 manual free 2007 no
Midtown Madness XLS 40 manual free 2003 no
Midtown Madness 2 XLS 35 manual free 2005 no
Need For Speed: Hot Pursuit 2 XLS 58 manual free 2003 no
Need For Speed: Porsche Unleashed XLS 217 manual free 2003-2006 no
Need For Speed: Underground XLS 161 manual free 2006 no
Quake 3 XLS manual free 2000-2007 no
The Sims 2/3 statistics of the houses made by me XLS 24 manual free 2013 no
The Sims 1 neighborhoods and lots XLS 44 81 lots manual free Dec 2018 no
The Sims 1 career tracks XLS 145 211 jobs manual free 2017 no
The Sims 2 neighborhoods and lots XLS 135 manual $14 Mar 2019 no
The Sims 2 career tracks XLS 216 313 jobs manual free 2012 no
The Sims 2 list of items XLS 219 4544 items manual $44 2012 no
The Sims 3 words and lots XLS 398 1845 lots manual $23 2013 no
Miscellaneous works
Music Database XLS 2200+ 6000+ rows manual free 2005 when I download new songs
Stadiums Database XLS 5360 3125 rows scraping about $60 2018 by request (low sales)

Since childhood I love writing books, doing research, making databases and statistics. I started using computers in 1997, my dad taught me to use Word, but around 2003 I started using Excel more than Word. Analyzing data, making tables and charts about everything encountered in my life! For example, in racing games I measure the speed of each car and write the numbers in an Excel spreadsheet then make a chart.

Early works were pure hobbies, made from personal interest, with no plans to commercialize them.

Hong Kong Housing Database was also made from personal interest of analyzing public housing estates, few months later, an insurance company asked me if I can expand it to private housing estates. It became my FIRST large project made for a customer.

Car Database were also started as hobby for my personal use, but had an unexpected turnout into business after 2012 when I realized that many companies in automotive industry are paying big $$ to get a complete, accurate, and frequently updated database. I went through extensive transformation to make my hobby databases suitable for professional use.

Seeing the success with car database, I decided to transform other hobby databases and sell them for professional use, such as HDB Database and World Cities Database.

Starting from 2015 I learned web scraping. Scraping usually means running a software to visit a list of given pages, extract specific data and put it in a database automatically. This allow me to create very large databases with little effort, spending ~30 min to write codes and leave scraping software to run in background for few hours or days.

Between 2015 to 2017 I created over 50 databases via web scraping, some from personal interest to sell to multiple people (India, Middle East and Australia car databases, mobile phones databases, etc) and others for single customers who requested them (web scraping services).

Keeping all databases regularly updated takes is a huge workload. Scraping more websites, if they take too much time, will create additional workload and will delay everyone’s updates. As 2018 I decided to STOP updating databases having less than 5 sales per year so I can focus on the ~20 best-selling databases that produce 80% of my income.

So… unless you come with a GREAT IDEA of database that can be sold to multiple customers, I have the right to NOT do your web scraping project if it takes more than ~2 hours of manual work and more than ~50 hours of running scraper in background.

Some projects (example Database of HDB Resale Flat Prices) involve copying the data from a source website and pasting in Excel, then few visual adjustments to make it beautiful, which takes just few hours to create a 20 MB Excel database.

Other projects (example Database of HDB blocks) involve compiling data from various sources and manual data entry in Excel, taking hundreds hours of work!

All my projects are made primarily for visualization in Excel, but some (especially the Car Database) are often used by professionals who are converting the Excel spreadsheet to CSV and MySQL and use in web design and mobile app development.

Working style

My parents encouraged me to work in Microsoft Word, and told me to finish and print the work because “what is not finished have ZERO value“. I never understand why they wanted to print… some works for example Car Database should NOT be printed and cannot be “finished”, it need to be updated constantly with new launched cars. They promised me that will help me publishing a book… but this never happened (there is a possibility that they encouraged me just to give me a solitary occupation at computer to prevent me disturbing them, instead of letting me to have a social life).

My dad even set me rules, how a book should be written: Arial font, 12pt body text, 16-20pt titles, all titles centered, bolded, underlined. However, since my writings were not really a book but a list of… something, the rules imposed by dad created excessive bold and centered text.

Around 2001-2003 I got fascinated by Notepad and by fixed-width font and I was using lines of — and === signs full page width to enhance titles.

Since 2003 I broke away from dad rules and started using Excel more than Word. New works in Word were optimized for on-screen display instead of printing, often using non-standard page sizes, to make exactly 1 page for each subject. I write with 10pt font for body text, 20pt and 15pt for titles, 10pt and 5pt for empty spaces.

Since 2003 for both Word and Excel works, the titles were white text on blue background for full page width, which does not look very well on paper. I used same style when created my website in 2009.

Since 2010, one of the distinctive features of all my Excel works are the coloured columns, older works were coloured to this format too. I combine the Excel databases with my graphic design hobby, making Excel files also artistic!

Since 2015 I changed the standard of Word files, removing full-width coloured backgrounds of titles and putting instead full-width horizontal lines (similar with what I was doing in 2001-2003 in Notepad). This will be better for printing (even if I assume that nobody will print my works). I changed also my website design to this format.

One of my friends said that my website looks like being made by an expert in typography rather than by a webdesigner!

Example of styling in my books: 2012, 2013, 2015 editions of Car Models Encyclopedia

I also done some kind of competition between my works, a race to create biggest database in Excel or biggest book in Word, in terms of pages and file size, under certain standards (10pt font, no duplicate stuff, no large open spaces, NO bullshit but useful content, etc). I kept track of file size in an Excel table similar with above table.

1 comment

  1. Hi there colleagues, how is the whole thing, and what you would like to say concerning this paragraph, in my
    view its really amazing for me. Billige manchester city drakt

Leave a Reply

Your email address will not be published.