Skip to content

Database

Cars evolution

Car database in Excel

I started collecting car data in Excel voluntarily in 2003 and the hobby turned into business in 2012. My databases are now used by thousands businesses including car parts shops, tuning shops, car dealers, insurance, shipping services, etc. In the future I may offer API SaaS web service beside Excel download.

Singapore HDB

Singapore HDB database

Collecting data from multiple sources, I spent 500+ hours entering data in one Excel table: block number, street address, postal code, GPS coordinates, construction year, lease commence date, number of floors, number of units breakdown by flat type, upgrading programmes, brochures and floor plans, etc. I sold database to companies including home insurance, telecommunication, door-to-door services, real estate portals, flyer distributors, etc.

Mobile Phones Database

Mobile phones database

I created an Excel database containing over 13,000 devices from 1994 cell phones to modern smartphones, tablets and smartwatches, with 88 columns of specifications. Useful for web development, mobile apps, GSM shop or anything similar. I offer FREE monthly updates and weekly updates for $100/year.

World Cities Database

World cities database

Worldwide cities database organized by country, state and province, with city population indicated. An original product “Made by Teoalida” that you will NOT find elsewhere on internet, compiled by me since 2003 and gradually expanded over years, based on Microsoft Encarta Encyclopedia. Currently it include over 16000 cities, more exactly ALL cities in the world with population over 20,000 people.

Web scraping services

Web scraping services

I offer data mining and web scraping services. “Scraping” usually means coding a bot that visit a list of given pages, copy specific data from each page and put it in an Excel / CSV file automatically, at rate of few pages per second. Watch the video!

If you are building a website, a mobile app, or just require specific data but cannot find in usable format, just give me link to a website having required data, I will make a scraper and turn website into an Excel database, for you and for future customers.

Excel, XLS, XLSX, CSV, SQL, XML, JSON

Teoalida Music Database

Music Database

We all love music, but I may be the only person who made an Excel database and show to everyone what are my musical preferences in the style of a data scientist. Since 2005 I use Excel to organize the music I am listening, rate each songs from 0 to 16, then use complex mathematical formulas to calculate scores and rank best artists, best albums, best music genres, etc.

Index of databases made by Teoalida

During my live I made over 100+ databases, from personal interest to distribute freely or sell for professional use. Some projects I made at request and published on website to allow other customers to purchase if interested. They have been used by numerous people from students practicing data analysis, to multi-national companies in real estate and automobile industry. I offer web scraping services in VB.NET and Python, making custom databases according your requirements. I work in Word and Excel, other file formats available: CSV, SQL, XML, JSON.

Digital Cameras Database

Digital cameras database

If you are looking for a database of digital cameras specifications in Excel format to create a website, use in a repair shop or anything similar, I created an Excel database for you. Contains 36 camera brands with a total of over 3800 models.

Countries database

World countries database

Are you looking for a database of countries in Excel format with their facts and figures, for research or to create a website? I made a database for you. Took few hours to make a scraping script which extract data from The World Factbook and create a CSV file. Takes about 35 min to extract the 268 entries, and I can update anytime you want!

Skyscrapers

Skyscrapers database

After making databases of HDB and condos from Singapore, as well as public and private housing estates from Hong Kong, and other databases, in November 2015 I started making a database of skyscrapers, to study evolution of skyscrapers over history.

Airports database

Airports database

Are you looking for a database of airports and other airfields in Excel format for research or to make a website? I made a database for you, you can open XLS file, save as CSV and import in SQL if needed.

ID 100%, Ident 100%, Type 100%, Name 100%, Latitude 100%, Longitude 100%, Elevation (ft) 87.33%, Continent 100%, ISO country 100%, Country 100%, ISO region 100%, Region 100%, Municipality 89.67%, Scheduled service 100%, GPS code 74.11%, IATA code 16.58%, Local code 52.24%, Home link 5.43%, Wikipedia link 17.86%, Keywords 17.22%.

Solar System Database

Solar System Database

Are you looking for a database of planets and satellites in Excel format with their facts and figures, for research or to make a website? I made a database in 2014 with planets and main satellites, sourcing data from solarsystem.nasa.gov.

Given by high number of free downloads, in 2019 I made a larger Excel database containing EVERY celestial body listed on NASA website (1 sun, 8 planets, 5 dwarf planets, 190 satellites) and offer for paid download.

Football stadiums database

Football Database

Download free SAMPLE: 2018-FIFA-World-Cup.xls

Took me about 5 minutes to compile this table sourcing data from Wikipedia using “XPath Helper” extension for Chrome.

If you are interested in similar table for all FIFA World Cups 1930-2018, UEFA Euro Cups and other football tournaments, please contact me.

Excel colors

Colors database RGB & HEX

First time I made such table was in 2004 (15 years old) when I spent few days making in Paint an image with 48 hue levels and 32 lighting levels (Excel 97-2003 was limited to 56 colors).

In 2018 I remade it in Excel, adding RGB values for easier use, the job took about 4 hours, 48 hue levels and 16 lighting levels. In 2019 also made a Scalable Vector Graphics table with HEX colors.

Business database

Although I am making databases for over 20 years (See whole list of 100+ databases made by me), the business databases that include email and phone numbers for marketing/spamming (aka B2B databases) are a NEW field for me.

CIBD Malaysia Contractors Database

In September 2019 someone paid me for web scraping service from cims.cidb.gov.my to obtain Malaysia contractors data, registration number, phone and fax number, etc, I got over 150,000 results, I publish database here in case other people are interested too.