Device IMEI Database and Type Allocation Codes (TAC)

This dataset provides a comprehensive registry of mobile device IMEIs, mapping each to its Type Allocation Code (TAC), manufacturer, model, and technical capabilities such as LTE, VoLTE, and 5G support. It includes blacklist/whitelist status, stolen device reporting, and EIR blocking for regulatory and security purposes, making it invaluable for telecom operators, fraud prevention, and device tracking.

  • opened 24 times
  • last updated 1 Nov 2025
  • by GoMask
The brief that made it

Network access control and fraud prevention

Sample rows

preview · 8 of 100 rows · all 25 columns
imeistringdevice_typestringvolte_supportedbooleanbluetooth_versionstringtacstringmanufacturerstringmodelstringrelease_yearintegerlte_supportedbooleanfiveg_supportedbooleanwifi_supportedbooleanos_typestringos_versionstringblacklist_statusstringblacklist_reasonstringblacklist_datedatewhitelist_datedateeir_blockedbooleaneir_block_datedateeir_unblock_datedatestolen_reportedbooleanstolen_report_datedatecountry_of_registrationstringnetwork_operatorstringlast_seen_datedate
358413067124851smartphonetrue5.235841306SamsungGalaxy S222022truetruetrueAndroid13.0whitelistedblankblank2022-04-05falseblankblankfalseblankGermanyDeutsche Telekom2024-05-21
353968090571284smartphonetrue5.035396809AppleiPhone 13 Pro2021truetruetrueiOS15.3whitelistedblankblank2021-11-19falseblankblankfalseblankFranceOrange2024-05-16
356901001812567smartphonetrue5.035690100XiaomiRedmi Note 102021truefalsetrueAndroid12.0blacklistedstolen2023-10-11blanktrue2023-10-12blanktrue2023-10-11IndiaAirtel2023-10-11
352356084129753feature phonefalse3.035235608Nokia1052020falsefalsefalseOtherblankunknownblankblankblankfalseblankblankfalseblankNigeriaMTN2024-03-20
354512090232184smartphonetrue5.035451209HuaweiP40 Lite2020truefalsetrueAndroid10.0whitelistedblankblank2020-07-15falseblankblankfalseblankSpainVodafone2024-06-02
357983098765412smartphonetrue5.135798309OppoA742021truefalsetrueAndroid11.0unknownblankblankblankfalseblankblankfalseblankMalaysiaMaxis2024-05-29
353967090574123smartphonetrue5.035396709AppleiPhone 122020truetruetrueiOS14.4whitelistedblankblank2020-12-10falseblankblankfalseblankUnited StatesAT&T2024-05-27
356903001812569smartphonetrue5.135690300XiaomiMi 11 Lite2021truefalsetrueAndroid11.0unknownblankblankblankfalseblankblankfalseblankBrazilVivo2024-06-03

What the 100 rows show

from the 100-row sample

Smartphone (device type) stands out: 65 of its 71 rows have volte_supported = true, against 1 of 29 for the rest.

  • 66%volte_supported = true
  • 3blacklist statuses
  • 4os types
  • 4blacklist reasons
  • 18manufacturers
  • 22os versions
Volte supported rate by device_typevolte_supported = true
0%50%100%92%smartpho…65 of 7113%tablet1 of 80%modem0 of 60%feature …0 of 15
bluetooth_version88 rows with a value · 12 left blank
  1. 5.046
  2. 5.115
  3. 5.211
  4. 4.27
  5. 3.04
  6. 4.13
  7. 5.32
25 columns by typefrom the column list below
  • string 12
  • integer 1
  • date 6
  • boolean 6

Columns

25 columns in four groups
blueprint · 25 columns
columntypedescriptionexample
Text 12 columns
imeistringInternational Mobile Equipment Identity, a unique 15-digit identifier for each mobile device.unique358413067124851
tacstringType Allocation Code, the first 8 digits of the IMEI, identifying the device model and manufacturer.35841306
manufacturerstringName of the device manufacturer.Samsung
modelstringDevice model name or number.Galaxy S22
device_typestringType of device (e.g., smartphone, tablet, modem, feature phone).smartphone · tablet · modem · feature phone · othersmartphone
bluetooth_versionstringBluetooth version supported by the device (e.g., 4.2, 5.0).7 versions · optional5.2
os_typestringOperating system type (e.g., Android, iOS, KaiOS, Windows).Android · iOS · KaiOS · Windows · Other · optionalAndroid
os_versionstringOperating system version (e.g., 12.0, 15.3.1).optional13.0
blacklist_statusstringBlacklist status of the device (e.g., blacklisted, whitelisted, unknown).blacklisted · whitelisted · unknownwhitelisted
blacklist_reasonstringReason for blacklisting (e.g., stolen, lost, fraud, unpaid bills).4 reasons · optionalstolen
country_of_registrationstringCountry where the device was registered or sold.optionalGermany
network_operatorstringNetwork operator associated with the device (if available).optionalDeutsche Telekom
Numbers 1 column
release_yearintegerYear the device model was released.1,990 to 2,100 · optional2022
Dates and times 6 columns
blacklist_datedateDate when the device was blacklisted.optional2023-10-11
whitelist_datedateDate when the device was whitelisted.optional2022-04-05
eir_block_datedateDate when the device was blocked by EIR.optional2023-10-12
eir_unblock_datedateDate when the device was unblocked by EIR.optional2022-01-22
stolen_report_datedateDate when the device was reported as stolen.optional2023-10-11
last_seen_datedateDate when the device was last seen on a network.optional2024-05-21
True or false 6 columns
lte_supportedbooleanIndicates if the device supports LTE (4G).true
volte_supportedbooleanIndicates if the device supports Voice over LTE (VoLTE).true
fiveg_supportedbooleanIndicates if the device supports 5G networks.true
wifi_supportedbooleanIndicates if the device supports Wi-Fi connectivity.true
eir_blockedbooleanIndicates if the device is blocked by the Equipment Identity Register (EIR).false
stolen_reportedbooleanIndicates if the device has been reported as stolen.false

15 SQL practice questions for the Device IMEI Database and Type Allocation Codes (TAC)

Written for this data and checked against it: 12 SQL and 3 Power BI exercises from beginner to advanced. Try the first three free; the practice kit has all 15, a starter .sql file and an answer key with every expected result.

  1. 01BeginnerFreeSELECT · WHERE · ORDER BY

    Blacklisted devices list

    Return imei, manufacturer, model and blacklist_reason for every device whose blacklist_status is 'blacklisted'. Order the results by imei ascending.

    Tables: device_imei_database_and_type_allocation_codes_t · your result: 4 columns, 15 rows
  2. 02BeginnerFreeDISTINCT · ORDER BY

    Distinct device types

    Return each distinct device_type found in the data, ordered alphabetically. The result must have a single column named device_type.

    Tables: device_imei_database_and_type_allocation_codes_t · your result: 1 columns, 4 rows
  3. 03BeginnerFreeGROUP BY · COUNT

    Devices per manufacturer

    Count the devices for each manufacturer. Return manufacturer and device_count, ordered by device_count descending and then by manufacturer ascending.

    Tables: device_imei_database_and_type_allocation_codes_t · your result: 2 columns, 18 rows
  1. 045G support by device typeBeginner
  2. 05Blacklisted devices by reasonPower BI
  3. 06Operators with many blacklisted devicesIntermediate
  4. 07Device age bucketsIntermediate
  5. 08Blacklists by monthIntermediate
  6. 09Manufacturers with newer-than-average devicesIntermediate
  7. 10Stolen report rate measurePower BI
  8. 11Rank manufacturers by blacklisted devicesAdvanced
  9. 12Gap between consecutive blacklistsAdvanced
  10. 13Running total of blacklistsAdvanced
  11. 14Share of devices by countryAdvanced
  12. 15Whitelist cohort by yearPower BI

Get the practice kit: the full dataset, all 15 exercises, a starter .sql and the answer key. One-time $3.99.

Get the practice kit · $3.99

Use it for

  • volte supported66%66 of 100 rowsvolte supported by de…92%smar…13%tabl…0%modem0%feat…

    A telecommunications dashboard

    The volte_supported rate, volte_supported by device_type and a breakdown of bluetooth_version. Excel, Power BI or Tableau.

  • Why do 66 of 100 rows have volte_supported = true?

    A root-cause class exercise

    Hand out the rows and one question. The answer is in the data, not in the brief.

  • A software demo

    Believable imeis with tac, manufacturer and model to fill a screen in front of a buyer.

Not quite right?

Make it yours.

Same 25 columns, your size and your rules. See 20 rows before you pay.

Preview 20 rows free

1,000 rows: $1.99 · 10,000: $12.99One-time. No subscription. All prices

This dataset100 rows25 columns
Yours1,000 rows25 columnscountry_of_registration: UK only

blueprint · device-imei-database-and-type-allocation-codes-tac

Behind this dataset

Same schema. As many rows as you need.

These 100 rows came out of a blueprint — 25 columns with generation rules behind each one. Open it in Data Factory to retune a column, add your own, wire in foreign keys, and run it at the size you actually need.

Rules it was built with
  • IMEI 15-digit identifier: TAC (8 digits) + serial number (6 digits) + check digit
  • TAC (Type Allocation Code) mapping to manufacturer and device model
  • Device capabilities: 2G/3G/4G/5G support, frequency bands, VoLTE/VoWi-Fi
  • Device category: smartphone, feature phone, tablet, IoT module, hotspot
  • Operating system: iOS, Android, KaiOS with version
  • EIR (Equipment Identity Register): whitelist (allowed), greylist, blacklist (blocked)
  • Stolen/lost device blocking with cross-operator blacklist sharing
  • IMEI validation: check digit calculation, duplicate IMEI detection (cloning)
Rows
Open the blueprint in Data Factory

1 credit per row. Preview 20 rows free. Buy rows for the full run.

Exports
CSV, JSON, JSONL, Parquet, SQL, Excel, TSV, XML
Licence
yours to use, including commercially
API slug
device-imei-database-and-type-allocation-codes-tac

More in Telecommunications

Browse all
Also in TelecommunicationsTelecom Device Supply Chain EmissionsNetwork Outage Incident LogsMobile Data Usage Pattern DatasetAll 1,966 datasets

What should your data show?

Preview 20 rows free
No signup. No card.