Mobile phones database

I created an Excel database with mobile phones sourcing data from www.gsmarena.com, for my personal research of how handheld devices evolved along history, and publishing it here for anyone else interested in same thing. I also created a digital cameras database and I am interested in laptops and other electronics, please suggest websites to scrap data from!

Warning for Indian spammers: I am selling database of phone DEVICES. I am NOT selling any database of phone numbers or any kind of people’s personal information, DO NOT ask me for such things. While people from rest of world do understand what I sell, about 20-30% of requests from India are about phone numbers… SMS marketing spamming is trendy there?

Mobile phones specifications database

Download SAMPLE: Mobile Phones Database.xls.
LITE version include 7 columns: Brand, Phone, Notes, Image URL, Technology, Announced, Status.

Buy FULL database + 1 year of FREE monthly updates (see changelog):

Buy & download

Instant download (example email). Price in Singapore Dollar (1 SGD = 0.7 USD).

Mobile phone database coverage

The mobile phone specification database include classic phones and smartphones, tablets and smartwatches, from 110 most popular phone brands in western world. There may be missing brands especially from China which have a lot of brands totally unknown 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.

110 mobile phone brands included

Acer, alcatel, Allview, Amazon, Amoi, Apple, Archos, Asus, AT&T, Benefon, BenQ, BenQ-Siemens, Bird, BlackBerry, Blackview, 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, Razer, 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

Database include 71 columns, each field having the following completion percentages (as 7 July 2017):

Naming: Brand 100.00%, Phone 100.00%, Notes 29.83%, Image URL 92.62% (you can use Tab Save extension for Chrome to download image files).
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%.

Indian mobile phones

This page has been getting significant traffic from India, with many people contacting me but refusing to buy above worldwide mobile phones database and asking me if I can create another mobile phones database with only models available in Indian market. Job done!

I sourced data from 91mobiles.com, this website have 10 category of products, such as Tablets, Cameras, TVs, Home Theaters, Smartwatches, Washing machines, Air conditioners, Refrigerators, Microwave oven, but I do not intend to scrap all categories and create databases for each, because would take a lot of time to regularly update each of them, for their sale volume, they will become products sell-able only in India and we all know how little indians pay, if people from western world contact me if they are able to make a purchase, many indians contact me regardless they are willing to pay or not, and just few leads actually convert to sales.

Download SAMPLE: India Mobile Phones Database.xls.

Buy FULL database + 1 year of FREE updates:

Buy & download

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.

19 comments

3 pings

Skip to comment form

    • aref on April 17, 2018 at 4:40 am
    • Reply

    hello everybody,
    I have a question: in the sample file, there isn’t any field due to number of slot of each brand models.
    has this database, the number of slot of each brand model?

    1. Column S have values like Mini-SIM, Micro-SIM, Single SIM, Dual SIM, etc… hope it helps

  1. Gaming laptops are widely used if you have any problem in your gaming laptop then you can contact gaming laptop support number here you will find all possible solution for your issues.

  2. First off I would like to say superb blog! I had a quick question which I’d like to ask if you do not mind.
    I was interested to know how you center yourself and clear your thoughts before writing.
    I have had a tough time clearing my thoughts in getting my ideas out.
    I do take pleasure in writing however it just seems like the first 10 to 15 minutes tend to be wasted simply just trying to figure
    out how to begin. Any suggestions or tips? Kudos!

  3. Chat started on Sunday, July 01, 2018 3:53:01 PM

    (3:53:01 PM) *** Visitor 30768770 has joined the chat ***
    (3:53:03 PM) Teoalida (site owner): Hi there… are you looking for a specific database? you are welcome for a chat!
    (4:05:09 PM) Visitor 30768770: hi
    (4:05:17 PM) *** Teoalida has joined the chat ***
    (4:05:20 PM) Teoalida: what’s up
    (4:05:25 PM) Visitor 30768770: i want to buy the full excel for phones
    (4:05:31 PM) Visitor 30768770: but i want to pay in ethereum
    (4:05:56 PM) Teoalida: you don’t have traditional ways of payment?
    (4:07:05 PM) Visitor 30768770: well i have paypal but i see u also accept crypto
    (4:07:37 PM) Teoalida: and perhaps you’re tired of crypto fall and want to escape from it before it will fall even more?
    (4:08:38 PM) Visitor 30768770: lol
    (4:08:49 PM) Visitor 30768770: is that a sarcastic reply?
    (4:09:06 PM) Teoalida: when did you joined cryptocurrency?
    (4:09:11 PM) Visitor 30768770: anyway thank you for ur time
    (4:09:23 PM) Teoalida: https://www.teoalida.com/offtopic/cryptocurrency
    (4:09:29 PM) Teoalida: let me log in Binance to find my ETH address
    (4:10:10 PM) Teoalida: here it is: 0x3afa7e0d194a62109440cc00e5887486f420b208
    (4:11:40 PM) *** Visitor 30768770 has left ***

    Where did you have gone?
    No payment in Ethereum, no payment in PayPal…

  4. After I initially commented I appear to have clicked
    the -Notify me when new comments are added- checkbox and from now on every time a comment is added
    I receive 4 emails with the same comment. There has to be a way you are able to remove
    me from that service? Kudos!

  5. Good job. I will let you know if I need your this service.

  1. […] prin web scraping în 2015, peste 15000 clădiri din lume cu înaltime peste 100 metri. – Baza de date a telefoanelor mobile, realizată prin web scraping în 2016, peste 8000 modele de celulare. – Şi alte 50 baze de […]

  2. […] Mobile phones database […]

Leave a Reply

Your email address will not be published.