free hit counter

«

»

Aug 18

Mobile phones database

I was looking to buy a phone, and due of passion for making databases and statistics, I created an Excel database of mobile phone specifications sourcing data from GSM Arena website, for my personal research of how mobile devices evolved along history, and I am publishing it there because other people may be interested too.

Looking for database of digital cameras, laptops, or other kind of electronics? Please recommend me a website similar with www.gsmarena.com and I will create more databases!

Download SAMPLE: Mobile Phones Database.xls.

Buy FULL database:

Buy & download

Mobile phones specifications database

Mobile phone database coverage

The mobile phone specification database include classic phones and smartphones, tablets and smartwatches, from 108 phone brands that are commonly seen in the western world. There may be missing brands especially from China which have a lot of brands not known at all outside their domestic market.

Earliest models included are Ericsson phones launched in 1994, but I guess that some early phone models are missing, as number of phones launched per year is significant only after 2003.

Database created from personal interest in August 2016 (8191 phone models).
Updated when done first sale on 6 October 2016 (8281 phone models).
Tell me how often would you like to have database updated in the future?

Mobile phone brands included

Acer, alcatel, Allview, Amazon, Amoi, Apple, Archos, Asus, AT&T, Benefon, BenQ, BenQ-Siemens, Bird, BlackBerry, BLU, Bosch, BQ, Casio, Cat, Celkon, Chea, Coolpad, Dell, Emporia, Energizer, Ericsson, Eten, Fujitsu Siemens, Garmin-Asus, Gigabyte, Gionee, Google, Haier, HP, HTC, Huawei, i-mate, i-mobile, Icemobile, Innostream, iNQ, Intex, Jolla, Karbonn, Kyocera, Lava, LeEco, Lenovo, LG, Maxon, Maxwest, Meizu, Micromax, Microsoft, Mitac, Mitsubishi, Modu, Motorola, MWg, NEC, Neonode, NIU, Nokia, Nvidia, O2, OnePlus, Oppo, Orange, Palm, Panasonic, Pantech, Parla, Philips, Plum, Posh, Prestigio, QMobile, Qtek, Sagem, Samsung, Sendo, Sewon, Sharp, Siemens, Sonim, Sony, Sony Ericsson, Spice, T-Mobile, Tel.Me., Telit, Thuraya, Toshiba, Unnecto, Vertu, verykool, vivo, VK Mobile, Vodafone, Wiko, WND, XCute, Xiaomi, XOLO, Yezz, Yota, YU, ZTE

Mobile phone specifications included

LITE version include 6 columns: Brand, Phone, Notes, Technology, Announced, Status.

FULL version include 69 columns, each field having the following completion percentages:

Naming: Brand 100.00%, Phone 100.00%, Notes 29.53%.
Network: Technology 100.00%, 2G bands 99.85%, 3G bands 54.40%, 4G bands 16.08%, Speed 54.71%, GPRS 99.62%, Edge 99.74%.
Launch: Announced 99.82%, Status 100.00%.
Body: Dimensions 99.77%, Weight 98.89%, Build 0.87%, Keyboard 8.42%, SIM 99.99%, Other 11.54%.
Display: Type 99.95%, Size 85.19%, Resolution 99.47%, Multitouch 45.54%, Protection 14.98%.
Platform: OS 55.00%, Chipset 40.51%, CPU 54.24%, GPU 38.37%.
Memory: Card slot 100.00%, Phonebook %, Internal 78.89%, Call records 43.28%.
Camera: Primary 85.53%, Features 46.37%, Video 84.61%, Secondary 85.19%, Other 14.47%.
Sound: Alert types 99.95%, Loudspeaker 100.00%, 3.5mm jack 99.17%, Other 21.16%.
Comms: WLAN 99.95%, Bluetooth 99.78%, GPS 99.65%, NFC %, Radio 99.08%, USB 88.91%.
Features: Sensors 51.15%, Messaging 99.99%, Browser 96.62%, Clock 5.96%, Alarm 5.96%, Games 44.24%, Languages 3.35%, Java 99.24%, Other 98.61%.
Battery: Battery 99.94%, Stand by 78.85%, Talk time 82.65%, Music play 84.61%.
Misc: Colors 92.67%, SAR US 23.46%, SAR EU 27.18%, Price group 56.82%.
Tests: Performance 2.89%, Display 5.03%, Camera 6.65%, Loudspeaker 8.30%, Audio quality 7.59%, Battery life 4.59%.

How the Excel phone database can be used

Filter the mobile phone database and get a list of mobile phones having specific features.
Filter the mobile phone table by year and make list of features introduced in each year of history.
Analyze data and make statistics what are the best phones in each price range.
Convert Excel spreadsheet to CSV or MySQL and create your own phone comparison website or mobile app.
Etc…

Actually I do not recommend using this database in making websites. Feel free to use it for research and analysis purposes. I am NOT responsible for any copyright troubles you may face if you use their data commercially, making own website, etc. This is NOT an original database “Made by Teoalida”, but rather a database showcasing abilities of data scraping, and the data belongs to www.gsmarena.com. Please consider the price a fee for data scraping service from website rather than author of data.

1 comment

  1. Tom

    Thanks! Seems to be what we just needed!

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>