Database Consulting: OpenCellID - Open Database of Cell Towers

This listing contains OpenCellID.org data: the world's largest Open Database of Cell Towers. With OpenCellID.org data, you can analyze carrier coverage, locate devices without GPS, and much more. The data can be used and distributed free of charge as described on https://opencellid.org . CSV files only contain cells observed in the last 18 months (from Revision date).

OpenCelliD Project is licensed under a Creative Commons Attribution-ShareAlike 4.0 International License. See more at https://opencellid.org 

Provided on AWS Data Exchange by Database Consulting (http://datacons.co.uk ).

MCC and and NET (also called MNC) can be used to assign each row with specific country and network provider. See https://en.wikipedia.org/wiki/Mobile_country_code  for more info.

You may use OpenCellID dataset with Amazon Athena (https://aws.amazon.com/athena/ ) and use standard SQL to analyze data

The following DDL in Athena can be used to define table on the top of raw data downloaded into S3 bucket

CREATE EXTERNAL TABLE IF NOT EXISTS raw_cell_towers( radio string, mcc string, net string, area int, cell int, unit int, lon decimal(38,20), lat decimal(38,20), cell_range int, samples int, changeable int, created int, updated int, averageSignal int ) ROW FORMAT DELIMITED FIELDS TERMINATED BY ',' LOCATION 's3://bucket-name/directory-path/' TBLPROPERTIES ("skip.header.line.count"="1"); WITH data as ( select mcc, case substr(mcc, 1, 1) when '0' then 'Test networks' when '2' then 'Europe' when '3' then 'North America and the Caribbean' when '4' then 'Asia and the Middle East' when '5' then 'Australia and Oceania' when '6' then 'Africa' when '7' then 'South and Central America' when '9' then 'Worldwide' end as region, case mcc when '202' then 'Greece' when '204' then 'Netherlands (Kingdom of the Netherlands)' when '206' then 'Belgium' when '208' then 'France' when '212' then 'Monaco' when '213' then 'Andorra' when '214' then 'Spain' when '216' then 'Hungary' when '218' then 'Bosnia and Herzegovina' when '219' then 'Croatia' when '220' then 'Serbia' when '221' then 'Kosovo' when '222' then 'Italy' when '226' then 'Romania' when '228' then 'Switzerland' when '230' then 'Czech Republic' when '231' then 'Slovakia' when '232' then 'Austria' when '234' then 'United Kingdom' when '235' then 'United Kingdom' when '238' then 'Denmark (Kingdom of Denmark)' when '240' then 'Sweden' when '242' then 'Norway' when '244' then 'Finland' when '246' then 'Lithuania' when '247' then 'Latvia' when '248' then 'Estonia' when '250' then 'Russian Federation' when '255' then 'Ukraine' when '257' then 'Belarus' when '259' then 'Moldova' when '260' then 'Poland' when '262' then 'Germany' when '266' then 'Gibraltar (United Kingdom)' when '268' then 'Portugal' when '270' then 'Luxembourg' when '272' then 'Ireland' when '274' then 'Iceland' when '276' then 'Albania' when '278' then 'Malta' when '280' then 'Cyprus' when '282' then 'Georgia' when '283' then 'Armenia' when '284' then 'Bulgaria' when '286' then 'Turkey' when '288' then 'Faroe Islands (Kingdom of Denmark)' when '289' then 'Abkhazia' when '290' then 'Greenland (Kingdom of Denmark)' when '292' then 'San Marino' when '293' then 'Slovenia' when '294' then 'North Macedonia' when '295' then 'Liechtenstein' when '297' then 'Montenegro' end as country, radio from raw_cell_towers ) select mcc, country, count(case when radio = 'NR' then 1 end) as "NR", count(case when radio = 'LTE' then 1 end) as "LTE", count(case when radio = 'UMTS' then 1 end) as "UMTS", count(case when radio = 'CDMA' then 1 end) as "CDMA", count(case when radio = 'GSM' then 1 end) as "GSM", count(*) as "ALL" from data where region = 'Europe' group by grouping sets ((mcc, country), ()) order by case when mcc is not null then 0 else 1 end, "ALL" desc;

Sample result

+----+-----+------------------------------------------+-----+---------+---------+------+---------+----------+ | # | mcc | country | NR | LTE | UMTS | CDMA | GSM | ALL | +----+-----+------------------------------------------+-----+---------+---------+------+---------+----------+ | 1 | 262 | Germany | 30 | 280493 | 1149770 | 0 | 1168995 | 2599288 | | 2 | 250 | Russian Federation | 4 | 291378 | 1127474 | 8 | 525660 | 1944524 | | 3 | 208 | France | 17 | 373926 | 1048168 | 0 | 452561 | 1874672 | | 4 | 234 | United Kingdom | 8 | 310200 | 978779 | 0 | 323518 | 1612505 | | 5 | 260 | Poland | 14 | 224559 | 735252 | 0 | 358761 | 1318586 | | 6 | 222 | Italy | 1 | 228602 | 806932 | 0 | 242586 | 1278121 | | 7 | 214 | Spain | 0 | 159353 | 592677 | 0 | 202348 | 954378 | | 8 | 286 | Turkey | 321 | 78606 | 524394 | 0 | 89294 | 692615 | | 9 | 204 | Netherlands (Kingdom of the Netherlands) | 1 | 125769 | 232022 | 0 | 134638 | 492430 | | 10 | 232 | Austria | 0 | 77488 | 233573 | 0 | 152425 | 463486 | | 11 | 240 | Sweden | 3 | 129303 | 243906 | 0 | 73942 | 447154 | | 12 | 255 | Ukraine | 0 | 6898 | 148389 | 0 | 163471 | 318758 | | 13 | 238 | Denmark (Kingdom of Denmark) | 0 | 60748 | 150525 | 0 | 57175 | 268448 | | 14 | 206 | Belgium | 0 | 56040 | 105882 | 0 | 102699 | 264621 | | 15 | 230 | Czech Republic | 0 | 67087 | 85338 | 0 | 102997 | 255422 | | 16 | 244 | Finland | 8 | 63174 | 127645 | 0 | 48340 | 239167 | | 17 | 226 | Romania | 0 | 28789 | 126741 | 0 | 64909 | 220439 | | 18 | 228 | Switzerland | 0 | 46773 | 105154 | 0 | 63691 | 215618 | | 19 | 216 | Hungary | 0 | 44604 | 89995 | 0 | 50253 | 184852 | | 20 | 202 | Greece | 0 | 27766 | 91742 | 0 | 52646 | 172154 | | 21 | 242 | Norway | 0 | 51154 | 62995 | 0 | 45008 | 159157 | | 22 | 268 | Portugal | 0 | 21449 | 89087 | 0 | 45113 | 155649 | | 23 | 272 | Ireland | 0 | 23453 | 88185 | 0 | 27200 | 138838 | | 24 | 257 | Belarus | 0 | 3350 | 71682 | 0 | 37022 | 112054 | | 25 | 284 | Bulgaria | 0 | 9996 | 67951 | 0 | 26521 | 104468 | | 26 | 219 | Croatia | 0 | 24779 | 48261 | 0 | 28845 | 101885 | | 27 | 231 | Slovakia | 0 | 14223 | 31497 | 0 | 30870 | 76590 | | 28 | 220 | Serbia | 0 | 4661 | 39266 | 0 | 16623 | 60550 | | 29 | 293 | Slovenia | 0 | 7475 | 23576 | 0 | 16704 | 47755 | | 30 | 246 | Lithuania | 0 | 11668 | 19065 | 0 | 12132 | 42865 | | 31 | 247 | Latvia | 0 | 11056 | 17447 | 0 | 12204 | 40707 | | 32 | 248 | Estonia | 0 | 9633 | 17310 | 0 | 11566 | 38509 | | 33 | 282 | Georgia | 0 | 2891 | 10015 | 0 | 11282 | 24188 | | 34 | 270 | Luxembourg | 0 | 4629 | 7122 | 0 | 10333 | 22084 | | 35 | 259 | Moldova | 0 | 2565 | 14502 | 0 | 4087 | 21154 | | 36 | 280 | Cyprus | 0 | 2601 | 10309 | 0 | 7675 | 20585 | | 37 | 283 | Armenia | 0 | 1179 | 9996 | 0 | 6137 | 17312 | | 38 | 218 | Bosnia and Herzegovina | 0 | 50 | 8032 | 0 | 8053 | 16135 | | 39 | 294 | North Macedonia | 0 | 1922 | 8850 | 0 | 5306 | 16078 | | 40 | 278 | Malta | 0 | 2252 | 8393 | 0 | 3310 | 13955 | | 41 | 276 | Albania | 0 | 1321 | 7724 | 0 | 4677 | 13722 | | 42 | 274 | Iceland | 0 | 3603 | 5722 | 0 | 2524 | 11849 | | 43 | 297 | Montenegro | 0 | 634 | 5085 | 0 | 2505 | 8224 | | 44 | 289 | Abkhazia | 0 | 70 | 738 | 0 | 622 | 1430 | | 45 | 295 | Liechtenstein | 0 | 147 | 448 | 0 | 734 | 1329 | | 46 | 288 | Faroe Islands (Kingdom of Denmark) | 0 | 147 | 471 | 0 | 202 | 820 | | 47 | 213 | Andorra | 0 | 92 | 418 | 0 | 181 | 691 | | 48 | 212 | Monaco | 0 | 177 | 203 | 0 | 144 | 524 | | 49 | 266 | Gibraltar (United Kingdom) | 0 | 72 | 142 | 0 | 114 | 328 | | 50 | 290 | Greenland (Kingdom of Denmark) | 0 | 22 | 129 | 0 | 45 | 196 | | 51 | 221 | Kosovo | 0 | 61 | 65 | 0 | 57 | 183 | | 52 | 292 | San Marino | 0 | 0 | 35 | 0 | 22 | 57 | | 53 | 235 | United Kingdom | 0 | 2 | 0 | 0 | 0 | 2 | | 54 | | | 407 | 2898890 | 9379079 | 8 | 4808727 | 17087111 | +----+-----+------------------------------------------+-----+---------+---------+------+---------+----------+