Car database

In 2003 I started making voluntarily a car encyclopedia, several lists in .DOC format and tables in .XLS format which allows you to sort and filter car models. The hobby turned into a business since 2012 when I found professionals looking for such data, I improved original European car databases and created new databases for America and Asia using web scraping, they have been purchased by hundreds companies including car parts, insurance, shipping, as well as web designers and mobile app developers.

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 people who downloaded it, 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).

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.

– Index of databases –

Here is the list of 100+ databases I made during my life. I posted them on my website for everyone, from students practicing data analysis, to multi-national companies in real estate and automobile industry. Most projects I made 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. I offer web scraping services, making custom databases according your requirements.

Buildings 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, published it in January 2016, having over 15,000 buildings taller than 100 meters. Under construction buildings are included.

Music Database

First time I used Excel to organize and rate songs I had in my computer was in 2002. The current Music Database, including complete discographies of selected artists, is a project started in 2005, shortly after connecting to internet I started creating a database in Excel with the MP3 songs downloaded from internet, to review each song and give a rating from 0 to 16, and make top best artists, best albums, best genres, etc, using complex mathematical formulas, to show to friends exactly what music I like and how much. Database is useful for me to organize my own music. How useful is for other people, I don’t know… your feedback is needed to make a better database for YOU and future customers!

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.

Brands included: Acer, AgfaPhoto, BenQ, Canon, Casio, Concord, Contax, Epson, Fujifilm, GE, HP, Jenoptik, JVC, Kodak, Konica, Konica-Minolta, Kyocera, Leica, Minolta, Minox, Nikon, Nokia, Olympus, Panasonic, Pentax, Praktica, Ricoh, Rollei, Samsung, Sanyo, Sigma, Sony, Toshiba, Vivitar, Yakumo.

Is possible (and legal) to obtain a mobile phone numbers database?

Homeowners associations does have phone numbers of some owners (is a good practice to give your contact info to be announced in case there is a problem in your home while you are away), car insurance companies also have phone numbers of their clients, but what makes you to think that they would give their database to you or potential competitors? Also, distributing / selling phone numbers without owner consent is ILLEGAL all over the world. In Singapore you can be fined up to $10,000 or up to 12 months of jail according pdpc.gov.sg.

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%.

Singapore car database

Singapore car databaseAre you a car parts shop, car rental, dealership, tuning, insurance company, or any other business that deal with cars? Or you just need a table with cars sold in Singapore in Excel format to make a website, a mobile app, or data analysis for a school project?

I spent several hours coding a scraper for sgcarmart.com and created this Excel database for YOU!

For other countries, see www.teoalida.com/cardatabase

Laptops & computer components database

Since I made in 2016 a very complete and accurate Mobile Phones Database, several people asked me if I can make a database of laptops or computers.

This is a trouble: while phones have under case same specifications, and we have websites like gsmarena.com which shows all phone models from most popular manufacturers from 1994 to present, laptop manufacturers produce them with a lot of different specifications under same case, and allow you to further customize them before ordering. Laptops can also be customized aftermarket by anyone. So, any laptops database I make, its accuracy risk to be poor (not match the specifications of laptops available for sale on various websites).

World hotels database

On 27 September 2018 an Indian visited www.teoalida.com/database/cities and asked me if I have database of HOTELS… not sure what made him to ask about hotels in a page about city population. He needed only 5 columns: hotel name, address, city, country, star rating. His budget was very low so we could not make the deal. But making a world hotels database is a GREAT IDEA because it may be in the interest for many people all over the world, not like Car Database, which require dozens separate databases for each region.

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.