«

»

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 + FREE updates for one year:

Buy & download

Mobile phones specifications database

Mobile phone database coverage & list of updates

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.

8191 phone models – August 2016, database created from personal interest.
8281 phone models – 6 October 2016, first sale done so I updated database for first time.
8419 phone models – 2 January 2017, new update after 2 more sales.
8464 phone models – 24 January 2017, a customer suggested adding one extra column: image URL, by this way I done a new update.
8554 phone models – 8 April 2017 – a customer requested update.
8600 phone models – 26 May 2017.
8641 phone models – 7 July 2017.
8724 phone models – 2 September 2017.

Too much time passed since last update? JUST ASK for a new update, I will do it today!

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 71 columns, each field having the following completion percentages:

Naming: Brand 100.00%, Phone 100.00%, Notes 29.83%, Image URL 92.62%.
Network: Technology 100.00%, 2G bands 100.00%, 3G bands 56.49%, 4G bands 18.83%, Speed 56.80%, GPRS 99.63%, Edge 99.73%.
Launch: Announced 99.83%, Status 100.00%.
Body: Dimensions 99.78%, Weight 98.95%, Build 0.96%, Keyboard 8.15%, SIM 99.99%, Other 99.78%.
Display: Type 99.95%, Size 86.11%, Resolution 99.46%, Multitouch 47.96%, Protection 16.03%, Other 99.95%.
Platform: OS 57.05%, Chipset 42.98%, CPU 56.22%, GPU 40.64%.
Memory: Card slot 100.00%, Phonebook 42.31%, Internal 79.92%, Call records 41.35%.
Camera: Primary 86.36%, Features 48.77%, Video 85.49%, Secondary 86.00%, Other 100.00%.
Sound: Alert types 99.95%, Loudspeaker 100.00%, 3.5mm jack 99.21%, unnamed 99.95%.
Comms: WLAN 99.95%, Bluetooth 99.78%, GPS 99.66%, NFC 9.22%, Radio 98.91%, USB 89.70%.
Features: Sensors 53.39%, Messaging 99.99%, Browser 96.99%, Clock 5.44%, Alarm 5.44%, Games 42.30%, Languages 3.12%, Java 99.27%, Other 99.99%.
Battery: Battery 99.98%, Stand by 76.70%, Talk time 80.73%, Music play 85.49%.
Misc: Colors 93.08%, SAR US 22.73%, SAR EU 26.44%, Price group 58.11%.
Tests: Performance 3.44%, Display 5.45%, Camera 7.01%, Loudspeaker 8.58%, Audio quality 7.82%, Battery life 5.08%.

Percentages as 7 July 2017.

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.

6 comments

Skip to comment form

  1. Tom

    Thanks! Database seems to be what we just needed!

  2. Vlogging Camera

    Hi Dear,
    Thanks for your good job. But I have some query should I ask here?

    1. Teoalida (site owner)

      Ask directly any query you have. Or you posted comment just to SPAM a backlink to your website?

  3. Teoalida (site owner)

    Does anyone knows what does mean ERD? I lost a customer because didn’t understood him

    Chat started on Monday, April 10, 2017 11:37:04 AM
    Country: Pakistan

    (11:37:04 AM) *** Visitor 83172926 has joined the chat ***
    (11:37:06 AM) teoalida: Hello from website admin… are you looking for a specific database? you are welcome for a chat!
    (11:38:14 AM) Visitor 83172926: hey
    (11:38:20 AM) *** Teoalida has joined the chat ***
    (11:38:22 AM) Teoalida: what’s up
    (11:38:33 AM) Visitor 83172926: i need a database of mobile spec
    (11:39:17 AM) Teoalida: This is what I offer
    (11:39:25 AM) Visitor 83172926: what ?
    (11:39:39 AM) Teoalida: what is the confusion more exactly?
    (11:40:01 AM) Visitor 83172926: give me an ERD
    (11:40:24 AM) Teoalida: what is ERD?
    (11:41:35 AM) Visitor 83172926: WHATS YOUR NAME?
    (11:41:43 AM) Teoalida: just call me Teoalida
    (11:41:52 AM) Teoalida: like website URL
    (11:41:53 AM) Visitor 83172926: ARE YOU A GUY ?
    (11:42:03 AM) Teoalida: yes, even if the name sounds female
    (11:42:41 AM) *** Visitor 83172926 has left ***

  4. Raman

    I am interested in buying the mobile phone database, I like to know about the charges for the updates you release over the time.

    1. Teoalida (site owner)

      I was in another room and speakers too low and when I came back and answered you, you quit!

      Chat started on Tuesday, June 06, 2017 5:17:35 PM

      (5:17:35 PM) *** Visitor 21321368 has joined the chat ***
      (5:17:35 PM) Visitor 21321368: hi
      (5:17:52 PM) Visitor 21321368: hello
      (5:19:37 PM) Auto-respond @ 2 min: I am busy or out of office for a moment. Try messaging again in 10 minutes. Or leave a message with your email address and I will contact you when I come back!
      (5:20:06 PM) Raman: Hi, I like to know about the pricing for updates?
      (5:20:23 PM) Raman: Kindly mail me the details. Thanks.
      (5:22:19 PM) *** Teoalida has joined the chat ***
      (5:22:22 PM) Teoalida: free updates for one year
      (5:22:30 PM) Teoalida: pay 50% for next year
      (5:23:12 PM) *** Raman has left ***

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>