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
|Price||Made in||Update frequency|
|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)|
|Romania geography – download from www.teoalida.ro/geografie|
|Geografia Romaniei||DOC||215||23 pages||manual||free||1999||2006|
|Drumuri nationale||DOC||70.5||6 pages||manual||free||1999||2006|
|Cai ferate||DOC||72.5||6 pages||manual||free||1999||2006|
|Cai ferate detaliat||DOC||347||51 pages||manual||$20||2000||2006|
|Impartirea administrativa interbelica||DOC||166||11 pages||manual||free||2006||2006|
|Impartirea administrativa in regiuni si raioane||DOC||80||7 pages||manual||free||1999||2006|
|Impartirea administrativa in judete||DOC||103||10 pages||manual||free||1998||2006|
|Populatia oraselor si judetelor||XLS||213||320 rows||manual||$20||2004||2011 census|
|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)|
|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)|
|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 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 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|
|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||2018||no|
|The Sims 1 career tracks||XLS||145||211 jobs||manual||free||2017||no|
|The Sims 2 list of items||XLS||219||4544 items||manual||$44||2012||no|
|The Sims 2 career tracks||XLS||216||313 jobs||manual||free||2012||no|
|The Sims 3 words and lots||XLS||398||1845 lots||manual||$23||2013||no|
|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.
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.
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!
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.