Columbia Power & Water Systems (CPWS) Data Access Guide
Columbia Power & Water Systems (CPWS) is a municipal utility serving roughly 36,500 electric customers in Columbia and Maury County, Tennessee, alongside water and broadband service. Customers access billing and hourly usage data through NISC's SmartHub portal on Elster EnergyAxis AMI meters, but CPWS publishes no Green Button, EDI, or API programs — third-party access runs through a manual Commercial Authorized Contact form.
How to Get Your Columbia Power & Water Systems (CPWS) Data: All Access Methods
| Method | 1st Party | 3rd Party | Customer Types | Data Types | Latency | Format |
|---|---|---|---|---|---|---|
| SmartHub Portal (web/mobile) | ✓ | ✓ | Residential and commercial (third parties via manual authorization) | Billing, payment history, hourly/daily usage | Daily usage updates; monthly bills | HTML / PDF |
| Commercial Authorized Contact form | — | ✓ | Commercial accounts delegating to consultants/energy managers | Same as portal: billing and usage | Manual processing of paper form | Portal / PDF |
| Public Records Request | ✓ | ✓ | Any requester under TN Public Records Act | Historical billing, rate schedules, reports | Per statutory processing timelines | PDF / Email |
| Outage Map | ✓ | ✓ | Public (no login) | Real-time outage locations and status | Real-time | Web only |
Billing Data Access
CPWS provides online billing access through the NISC SmartHub portal (web and mobile) for residential and commercial accounts. Third parties access billing data only through manual customer authorization via the Commercial Authorized Contact form — there is no API-based authorization system.
What Data Is on Your Columbia Power & Water Systems (CPWS) Bill
- Current month bill (PDF download)
- Multi-year billing history
- Daily and hourly usage graphs (Usage Explorer)
- Payment history
- Account alerts via email and SMS
How to Download Columbia Power & Water Systems (CPWS) Bills (Business & Commercial)
- 01Register the commercial account for SmartHub at https://cpws.smarthub.coop
- 02Open My Usage > Usage Explorer for daily and hourly consumption
- 03Download the current bill as PDF for records
- 04To delegate access, complete the Commercial Authorized Contact form at https://www.cpws.com/customer-service/forms/ and submit it signed to CPWS
- 05Authorized contacts then register or receive portal access with the customer's account number
How to Download Columbia Power & Water Systems (CPWS) Bills (Residential)
- 01Go to https://www.cpws.com/account/smarthub/ and click Register for Online Access
- 02Enter your account number from your monthly bill and create credentials
- 03Verify email address and phone number
- 04Log in at https://cpws.smarthub.coop on web or the iOS/Android app
- 05View current bill under Billing & Payments and download PDFs
- 06Enable Paperless Billing in account settings
Third-Party Access to Columbia Power & Water Systems (CPWS) Billing Data
Commercial Authorized Contact (manual)
- 01Account holder completes the Commercial Authorized Contact form naming the third party
- 02Customer signs and submits the form to CPWS (mail to 201 Pickens Lane, Columbia, TN 38401 or via askcpws@cpws.com)
- 03Third party registers for SmartHub with the customer's account number or contacts (931) 388-4833 for portal access
- 04Third party views the same billing and usage data as the customer and downloads PDFs as needed
Want to understand the charges on your bill?
See the Columbia Power & Water Systems (CPWS) Rate Schedules & Tariff Guide →Interval Data & Smart Meters
CPWS deployed Elster EnergyAxis AMI smart meters starting around 2010 (~25,000 planned meters). Customers view hourly and daily usage in SmartHub Usage Explorer, but 15-minute interval data is not officially exposed and there is no Green Button or ESPI export.
How to Download Columbia Power & Water Systems (CPWS) Interval Data
- 01Log into SmartHub at https://cpws.smarthub.coop
- 02Click My Usage > My Usage > Usage Explorer (web) or tap Energy Use in the mobile app
- 03Select a date range to view hourly and daily usage graphs
- 04Check the interface for CSV export options; if unavailable, record data manually
- 05Use the data for peak identification and efficiency analysis
Interval data is essential for rate comparison and TOU analysis.
See which Columbia Power & Water Systems (CPWS) rate schedule is best for your usage pattern →Third-Party API Access
CPWS publishes no official API, developer portal, or formal third-party data program. The NISC SmartHub platform has an internal JSON API that community projects have reverse-engineered (e.g., tedpearson/electric-usage-downloader on GitHub), but it is unsupported and violates terms of service for production use. Third-party access runs through the manual Commercial Authorized Contact form.
How to Register as a Columbia Power & Water Systems (CPWS) API Vendor
- 01Have the customer complete and sign the Commercial Authorized Contact form
- 02Submit the form to CPWS via mail or askcpws@cpws.com
- 03Call (931) 388-4833 to confirm receipt and request portal access
- 04Log into SmartHub and export bills/usage manually
- 05For portfolios, Nectar provides API access to CPWS billing data — see docs.nectarclimate.com
EDI (Electronic Data Interchange)
No published EDI trading partner program exists at CPWS. As a ~36,500-customer municipal utility, CPWS does not document EDI transaction sets, trading partner agreements, or VAN connections. Customers should call (931) 388-4833 to confirm current capabilities and ask about ACH/electronic payment and data export alternatives.
Rate Schedules & Tariff Analysis
CPWS publishes its electric rate schedule on its Rates & Fees page; the formal tariff document may require a public records request. Rates are set by the City of Columbia Board of Public Utilities and updated regularly.
For a deeper analysis including cost optimization strategies and historical rate trends:
Read the full Columbia Power & Water Systems (CPWS) Rate Optimization Guide →Other Data Access Programs
Exceleron MyUsage Prepay
Prepaid utility account platform deployed in 2016 with web/mobile usage monitoring and bill estimation for budget-conscious customers.
- 01Enroll in prepay through CPWS customer service
- 02Use the MyUsage web or mobile portal to monitor balance and usage
- 03Top up the account as needed based on usage projections
Public Records Requests
Tennessee Public Records Act requests can yield historical billing records, usage data (with authorization), rate schedules, and financial/operational reports.
- 01Complete the Public Records Request Form on the CPWS website
- 02Send the request to askcpws@cpws.com
- 03Comply with Tennessee Public Records Act requirements
Limitations & Considerations
- ⚠No formal third-party data access program — manual paper authorization only
- ⚠No EDI services published
- ⚠No official API or developer portal
- ⚠No Green Button / ESPI export of smart meter data
- ⚠15-minute interval data not exposed despite AMI meters supporting it
- ⚠CSV export availability in current SmartHub version is unclear
Columbia Power & Water Systems (CPWS) Data Access FAQ
What's the finest interval data granularity a C&I customer can get from CPWS?▾
Hourly. CPWS's Elster EnergyAxis AMI meters collect interval data, but SmartHub Usage Explorer only exposes hourly and daily views. 15-minute data is not officially accessible through the portal, and CSV export availability in the current SmartHub version is unclear — archive what you need manually.
How does a consultant or energy manager get authorized access to a CPWS commercial account?▾
Have the account holder complete and sign CPWS's Commercial Authorized Contact form (available at cpws.com/customer-service/forms/) and submit it by mail to 201 Pickens Lane, Columbia, TN 38401 or via askcpws@cpws.com. Then call (931) 388-4833 to request SmartHub access under that authorization — there is no online authorization portal.
Does CPWS support Green Button, EDI, or an API?▾
No. CPWS publishes no Green Button/ESPI export, no EDI trading partner program, and no official API or developer portal. The underlying NISC SmartHub JSON API has been reverse-engineered by community projects, but using it violates terms of service and is not viable for production systems.
How can energy software platforms ingest CPWS data automatically?▾
There is no utility-sanctioned automated path today. Options are manual portal exports under a Commercial Authorized Contact authorization, recurring data-sharing arrangements with the customer, or Nectar, which provides API access to this utility's billing data — see docs.nectarclimate.com. Public records requests can supply historical billing and rate documentation.
Is CPWS in a deregulated market — can customers shop for supply?▾
No. Tennessee has no retail electric choice. CPWS is a municipal utility regulated by the City of Columbia Board of Public Utilities, distributing TVA power, and customers take bundled service under CPWS's published rate schedule.
The Best Way to Access Data from Columbia Power & Water Systems (CPWS)
Nectar connects to Columbia Power & Water Systems (CPWS) and 7,000+ utility providers — billing, interval, and rate data delivered automatically. No portals, no forms, no manual downloads.
Nectar for Energy & Sustainability Teams
Managing utility data for commercial or industrial buildings? Nectar offers a free energy data audit — we'll review your current setup and show you where automation can save your team hours every month.
Get a Free AuditNectar for Developers & Consultants
Building energy tools or advising clients on utility data? Nectar works with technology partners and consultants who need reliable data infrastructure.
Partner with Us