Telecom Hardware Sustainability Tracker
This dataset provides comprehensive tracking of telecom hardware sustainability across multiple sites, including detailed asset lifecycle information, energy consumption, recycling rates, and compliance with environmental goals. It enables benchmarking, ESG reporting, and informed procurement decisions by capturing key metrics and relationships for each hardware asset and site.
Sample rows
preview · 8 of 80 rows · all 24 columns| site_idstring | environmental_compliance_statusstring | recycled_material_percentagefloat | esg_goal_achievedboolean | site_countrystring | site_namestring | site_street_addressstring | site_citystring | site_statestring | site_postal_codestring | hardware_idstring | hardware_typestring | manufacturerstring | modelstring | serial_numberstring | install_datedate | decommission_datedate | energy_consumption_kwhfloat | recycling_statusstring | esg_goal_referencestring | esg_goal_targetfloat | reporting_period_startdate | reporting_period_enddate | procurement_decision_flagboolean |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| NYC-01 | compliant | blank | true | USA | Manhattan Central Hub | 125 8th Ave | New York | NY | 10011 | HW-10001 | router | Cisco | CRS-1 | SN-A1001NY | 2022-01-15 | blank | 1455.3 | not-applicable | ESG-E1 | 1500 | 2023-01-01 | 2023-12-31 | true |
| TX-DFW-02 | compliant | blank | true | USA | Dallas Data Facility | 2012 Elm St | Dallas | TX | 75201 | HW-10002 | switch | Juniper | EX4200 | SN-B2202TX | 2021-06-20 | blank | 812.6 | not-applicable | ESG-E2 | 900 | 2023-07-01 | 2023-12-31 | true |
| SFO-03 | compliant | 87.5 | true | USA | San Francisco West | 888 Howard St | San Francisco | CA | 94103 | HW-10003 | server | Dell | PowerEdge R740 | SN-C3303CA | 2020-11-11 | 2023-04-10 | 2180.5 | completed | ESG-S1 | 2500 | 2022-10-01 | 2023-04-10 | false |
| CHI-04 | pending | blank | blank | USA | Chicago Loop Node | 350 S Clark St | Chicago | IL | 60604 | HW-10004 | antenna | Ericsson | AIR 6488 | SN-D4404IL | 2022-08-04 | blank | 521.7 | not-applicable | blank | blank | 2023-01-01 | 2023-12-31 | false |
| LON-05 | compliant | 80.1 | true | UK | London Docklands | 1 Canada Square | London | England | E14 5AB | HW-10005 | transceiver | Nokia | Flexi Multiradio | SN-E5505LN | 2021-03-31 | 2023-03-30 | 317.2 | completed | ESG-EU1 | 500 | 2022-04-01 | 2023-03-30 | true |
| MIA-06 | compliant | blank | true | USA | Miami Gateway | 1550 Biscayne Blvd | Miami | FL | 33132 | HW-10006 | server | HP | ProLiant DL360 | SN-F6606FL | 2022-07-19 | blank | 1630.9 | not-applicable | ESG-S2 | 1800 | 2023-01-01 | 2023-12-31 | false |
| TOR-07 | compliant | blank | true | Canada | Toronto North | 500 Yonge St | Toronto | ON | M4Y 1X9 | HW-10007 | router | Cisco | ASR 9000 | SN-G7707TO | 2021-12-05 | blank | 2105.8 | not-applicable | ESG-CA1 | 2200 | 2023-01-01 | 2023-12-31 | true |
| ATL-08 | compliant | blank | true | USA | Atlanta Peachtree | 303 Peachtree Center Ave | Atlanta | GA | 30303 | HW-10008 | switch | Juniper | EX3400 | SN-H8808GA | 2022-06-16 | blank | 705.2 | not-applicable | ESG-E3 | 800 | 2023-01-01 | 2023-12-31 | false |
| DEN-09 | compliant | blank | true | USA | Denver Tech Center | 7600 E Orchard Rd | Denver | CO | 80111 | HW-10009 | server | Dell | PowerEdge R640 | SN-I9909CO | 2023-02-21 | blank | 1950.4 | not-applicable | ESG-E4 | 2100 | 2023-02-21 | 2023-12-31 | true |
| PAR-10 | non-compliant | 72 | false | France | Paris Nord | 10 Rue La Fayette | Paris | Ile-de-France | 75009 | HW-10010 | other | Huawei | FusionModule2000 | SN-J1010PA | 2020-05-14 | 2023-02-28 | 1230.7 | completed | ESG-FR1 | 1200 | 2022-03-01 | 2023-02-28 | false |
| SEA-11 | pending | blank | blank | USA | Seattle Gateway | 2131 7th Ave | Seattle | WA | 98121 | HW-10011 | antenna | Ericsson | AIR 3239 | SN-K1111WA | 2022-04-08 | blank | 380.2 | not-applicable | blank | blank | 2023-01-01 | 2023-12-31 | false |
| BER-12 | compliant | blank | true | Germany | Berlin Mitte | Alexanderplatz 1 | Berlin | Berlin | 10178 | HW-10012 | router | Cisco | NCS 5500 | SN-L1212BE | 2021-09-12 | blank | 1307.6 | not-applicable | ESG-DE1 | 1400 | 2023-01-01 | 2023-12-31 | true |
| LA-13 | compliant | blank | true | USA | LA Metro Center | 555 S Flower St | Los Angeles | CA | 90071 | HW-10013 | switch | Juniper | QFX5100 | SN-M1313LA | 2022-03-15 | blank | 994.8 | not-applicable | ESG-E5 | 1200 | 2023-01-01 | 2023-12-31 | true |
| HOU-14 | compliant | 90.2 | true | USA | Houston Heights | 1300 N Loop W | Houston | TX | 77008 | HW-10014 | server | HP | ProLiant DL380 | SN-N1414TX | 2022-10-25 | 2023-08-10 | 1857.2 | completed | ESG-S3 | 2000 | 2022-10-25 | 2023-08-10 | false |
| SYD-15 | pending | blank | blank | Australia | Sydney CBD | 77 York St | Sydney | NSW | 2000 | HW-10015 | antenna | Ericsson | AIR 3246 | SN-O1515SY | 2023-01-18 | blank | 422.5 | not-applicable | blank | blank | 2023-01-18 | 2023-12-31 | false |
| BOS-16 | compliant | blank | true | USA | Boston Back Bay | 500 Boylston St | Boston | MA | 02116 | HW-10016 | router | Cisco | ASR 1006-X | SN-P1616MA | 2021-08-29 | blank | 1125.9 | not-applicable | ESG-E6 | 1200 | 2023-01-01 | 2023-12-31 | true |
| AMS-17 | compliant | 76.7 | true | Netherlands | Amsterdam Zuid | Prinses Irenestraat 59 | Amsterdam | North Holland | 1077 | HW-10017 | transceiver | Nokia | Flexi Zone | SN-Q1717AM | 2021-05-22 | 2023-05-20 | 410.6 | completed | ESG-EU2 | 600 | 2022-05-21 | 2023-05-20 | false |
| PHX-18 | compliant | blank | true | USA | Phoenix Midtown | 100 N Central Ave | Phoenix | AZ | 85004 | HW-10018 | server | Dell | PowerEdge R740xd | SN-R1818AZ | 2022-09-17 | blank | 1689.4 | not-applicable | ESG-E7 | 1700 | 2023-01-01 | 2023-12-31 | true |
| DEN-19 | pending | blank | blank | USA | Denver Tech North | 7800 E Orchard Rd | Denver | CO | 80111 | HW-10019 | switch | Juniper | EX4300 | SN-S1919CO | 2023-03-04 | blank | 826.1 | not-applicable | blank | blank | 2023-03-04 | 2023-12-31 | false |
| NYC-20 | compliant | blank | true | USA | Manhattan South Hub | 200 Varick St | New York | NY | 10014 | HW-10020 | router | Cisco | NCS 540 | SN-T2020NY | 2020-10-10 | blank | 1003.8 | not-applicable | ESG-E8 | 1100 | 2023-01-01 | 2023-12-31 | true |
What the 80 rows show
from the 80-row sampleCompliant (environmental compliance status) stands out: 51 of its 55 rows have esg_
- 74%esg_
goal_ achieved = true - 87.5median recycled_
material_ percentage - 4recycling statuses
- 6hardware types
- 9manufacturers
- 955.9median energy_
consumption_ kwh
Compliant (environmental compliance status)'s mean recycled_
Median 87.5, from 62.5 to 95.1.
- string 15
- float 3
- date 4
- boolean 2
Columns
24 columns in four groups| column | type | description | example |
|---|---|---|---|
| Text 15 columns | |||
site_id | string | Unique identifier for the telecom site or facility | NYC-01 |
site_name | string | Descriptive name of the telecom site | Manhattan Central Hub |
site_street_address | string | Street address of the telecom site | 125 8th Ave |
site_city | string | City where the telecom site is located | New York |
site_state | string | State or province of the telecom site | NY |
site_postal_code | string | Postal code of the telecom site | 10011 |
site_country | string | Country where the telecom site is located | USA |
hardware_id | string | Unique identifier for the hardware assetunique | HW-10001 |
hardware_type | string | Type of telecom hardware (e.g., router, switch, server)6 values | router |
manufacturer | string | Manufacturer of the hardware9 manufacturers | Cisco |
model | string | Model name or number of the hardware | CRS-1 |
serial_number | string | Serial number of the hardware assetunique | SN-A1001NY |
recycling_status | string | Current recycling status of the hardwarepending · in-process · completed · not-applicable | not-applicable |
environmental_compliance_status | string | Indicates if the hardware meets environmental compliance standardscompliant · non-compliant · pending | compliant |
esg_goal_reference | string | Reference code or name for the relevant ESG goaloptional | ESG-E1 |
| Numbers 3 columns | |||
energy_consumption_kwh | float | Total energy consumed by the hardware (in kWh) over its lifecycle or reporting period0 or more | 1455.3 |
recycled_material_percentage | float | Percentage of the hardware's material that was recycled upon decommissioning0 to 100 · optional | 87.5 |
esg_goal_target | float | Target value for the ESG goal (e.g., max energy consumption, recycling rate)0 or more · optional | 1500 |
| Dates and times 4 columns | |||
install_date | date | Date the hardware was installed at the site | 2022-01-15 |
decommission_date | date | Date the hardware was decommissioned (if applicable)optional | 2023-04-10 |
reporting_period_start | date | Start date of the reporting period for sustainability metrics | 2023-01-01 |
reporting_period_end | date | End date of the reporting period for sustainability metrics | 2023-12-31 |
| True or false 2 columns | |||
esg_goal_achieved | boolean | Indicates whether the hardware has met the referenced ESG goaloptional | true |
procurement_decision_flag | boolean | Indicates if sustainability metrics influenced procurement decisions for this hardwareoptional | true |
Use it for
A telecommunications dashboard
The esg_
goal_ achieved rate, recycled_ material_ percentage by environmental_ compliance_ status and a breakdown of site_ country. Excel, Power BI or Tableau. Why do 51 of 69 rows have esg_
goal_ achieved = true? A root-cause class exercise
Hand out the rows and one question. The answer is in the data, not in the brief.
- Sites80NYC-01compliantTX-DFW-02compliantPAR-1072non-comp…
A software demo
Believable sites with site_
name, site_ street_ address and site_ city to fill a screen in front of a buyer.
blueprint · telecom-hardware-sustainability-tracker
Behind this dataset
Same schema. As many rows as you need.
These 80 rows came out of a blueprint — 24 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.
- Each row represents a unique hardware asset at a telecom site.
- Assets must include model, installation date, and energy rating.
- Sustainability metrics recorded quarterly (energy use, recycling status, carbon footprint score).
- Assets flagged for replacement if energy rating falls below threshold.
- Compliance status calculated based on local and global ESG standards.
1 credit per row. New accounts start with 25 free credits.
- Exports
- CSV, JSON, JSONL, Parquet, SQL, Excel, TSV, XML
- Licence
- yours to use, including commercially
- API slug
- telecom-hardware-sustainability-tracker