The Nynex Telco Price and Demand Dataset (NNPD) contains public data on prices and demand for interstate rate elements in the historical Nynex service area from 1993 to 2009. Nynex is a large U.S. local telephone operating company. The source data are interstate access price-cap tariff filings made publicly at the Federal Communications Commission (FCC). The NNPD compiles and organizes all records listed in the available rate detail files that are part of Nynex’s annual access filings. The dataset is a tab-delimited text file with the field names as the first record. It is named "nynex rd 1993-2009 v2.txt" (also available as a Winzipped file).
This dataset is intended to foster better understanding of communications industry developments, keener appreciation for the realities of economic regulation, and more informed public policy deliberation. This dataset is neither an official nor authoritative compilation. The official FCC public record of tariff filings is the FCC's Electronic Tariff Filing System (ETFS). Annual access filings for 2003 to 2009 are currently available online. One way to find annual access filings is to search by company name for June 10 to June 20 for the filing year of interest. The files for 2003 to 2009 in the source data compilation are named by their file description on ETFS. Nynex-area tariff documents from 2006 to 2009 are in Verizon's FCC Tariff 11.
The historical Nynex service area consists of the historical service areas of the New York Telephone Company and the New England Telephone and Telegraph Company. These local telephone operating companies' service areas together cover customer premises in New York, New Hampshire, Massachusetts, Maine, Rhode Island, and Vermont. Bell Atlantic acquired Nynex on August 14, 1997. Bell Atlantic subsequently acquired GTE Telephone Companies and became Verizon.
From 1993 to 1998, Nynex rate detail filings are associated with the company service area code (COSA) NXTR. From 1999 to 2005, Nynex rate detail are included within the rate detail files for the new Bell Atlantic. From 2006 to 2009, Nynex rate detail are included within the rate detail files for Verizon.
The NNPD price-cap basket sums have been validated against the sums reported in Nynex’s annual access filing Tariff Review Plans (TRPs), where available. The 1998 rate detail filing is missing all marketing-basket rate elements. Nynex TRPs are not available after 1998. However, rate detail filings for 2002 and subsequent years include basket total lines. These lines have been used to validate the rate element sums. For details and some summary statistics, see the workbook nynex review (Excel version)
Note that in summing records from the NNPD, total lines should be excluded. The individual, bottom-level rate-elements are coded with line-type=“e”.
DS1 channel termination and channel mileage rate elements for the New York Telephone service area in the Nynex region are also available in a separate file called "ny ds1 extract.txt". It is a tab delimited text file with field names in the first row after the description information. In addition to fields defined in the NNPD technical specification, this extract file includes the following additional fields and associated element indicators:
The codes for these fields follow directly from the content of fields lname and lname2. Direct-trunked transport is switched access. Here's some discussion of the distinction between special access and switched access. The distance 0 (0-0 channel mileage) rate elements all have zero rates, but some of these elements include positive demand. Here's some analysis of this DS1 data.
The rate-detail source files used to the construct the NNPD are available in the rate detail archive. Nynex’s TRPs are available in the TRP archive.
NNPD Technical Specification
Dataset Fields
|
Field name |
Source |
Description |
|
year |
a |
filing year; see date table for dates of rates |
|
date |
a |
filing date; some years include multiple filings distinguished by date |
|
ln |
a |
record sequence number, based on sequence in the source file |
|
basket |
a |
price-cap basket name |
|
line-type |
a |
“e” – rate element; “t” – total line |
|
tariff-line |
s |
Identifies the relevant tariff section |
|
lcode |
s |
line code included in the source |
|
lname2 |
s |
more generic description field included for some years |
|
lname |
s |
service description; in some cases contains header line text |
|
usoc |
s |
universal service ordering code |
|
area |
a |
area for which rate element is applicable; includes cities, states, and regions (not completely coded) |
|
zone |
a |
zone for which rate element is applicable; null if whole region |
|
term |
a |
purchase commitment term indicated in the rate element description (in months; incompletely coded, with monthly elements not coded) |
|
demand |
s |
previous year's demand (base period demand); for elements charged monthly, it's the sum of charged elements across months |
|
crate |
s |
current price for rate element, existing about June 15 of year of filing |
|
prate |
s |
proposed price for rate element, proposed to go into effect about July 1 of year of filing |
|
lrate |
s |
price at last price-cap index (PCI) update |
|
crev |
s |
current price times previous year's demand (crate * demand) |
|
prev |
s |
proposed price times previous year's demand (prate * demand) |
|
lrev |
s |
price at last PCI update times previous year’s demand (lrate * demand) |
Note: The source column above indicates whether the field is directly from the source data (“s”) or an added classification of the source data (“a”). Added classifications follow directly from text in element description (lname).
For some additional, minor technical notes and version changes, see the file “nynex rd notes.txt”.