The Price-Cap Review Dataset (PCRD) contains data on demand, rates, and revenue for selected U.S. local telephone companies from 1992 to 2009. These data have been publicly filed at the U.S. Federal Communications Commission (FCC) as part of annual access Tariff Review Plans (TRPs) for price-cap regulated local telephone companies.[1] The FCC standardizes yearly the form of the TRP that all price-cap carriers use. The TRPs describe ILECs interstate access rates and provide for review of rate changes. The PCRD compiles a key section of the TRPs in order to facilitate exploratory analysis of local telephone services and price-cap regulation and to foster better 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 through ETFS. 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 main elements of the PCRD are the tab-delimited text files "rte 1992-2009 v2.txt" and "template.txt". Some summary statistics from the PCRD are available in an interstate voice access demand spreadsheet (Excel version). A relational database such as OpenOffice.org Base or Microsoft Access is the best means for using the dataset.
You should verify and validate figures in this dataset as appropriate for your particular purposes. Spreadsheets in open-document format provide copies of the source data by company (see sources 1992-1999, sources 2000-2009, and sources ba 1992-2004). These spreadsheets provide a convenient, accessible way to examine an intermediate source for the PCRD. They include some descriptive lines not included in the PCRD. The 1992-1999 source compilation has been revised slightly.
The "telco TRP" folder includes zipped files containing the original sources that went into the PCRD as well as all other TRPs filed for price-cap local telephone companies in the specified years. These original sources are Lotus 1-2-3 spreadsheets in .wk3 and .wk4 formats. These zipped files are named "trp v2 [years]", where [years] indicates the filing year of the included Lotus spreadsheets. The zipped file "usw ods format" provides TRPs for US West from 1992 to 2009 converted into an open document format (accessible via OpenOffice.org Calc and Micrsoft Excel). The conversion may introduce some distortions and errors in the source. The converted files are meant to provide a more accessible, but less reliable, view of the form of the sources. The rate detail files that are the basis for the figures in the TRPs are also available. Also available as bulk downloads: TRP archive and rate detail archive. These source files allow for a more extensive check and reconstruction of the PCRD. They also provide the material for the construction of a more comprehensive dataset.
The file PCRD notes.txt provides minor data notes and descriptions of the most significant changes across versions of the PCRD.
You can show appreciation for the public availability of the PCRD by notifying Douglas Galbi about any errors you discover in it, by improving and extending the dataset, and by sharing your extensions and analysis of the dataset with everyone.
* * * * *
The PCRD is construted from the RTE section of the TRPs. Almost all the ILEC-specific data included in the TRP are in a TRP section labeled RTE-1 (rate review section 1). Because TRPs filed from 1992 to the present include only one RTE section, RTE is used here to refer to the TRP section labeled RTE-1. That section is also written as RTE1 in some FCC orders.
A category of data not included in the RTE are exogenous costs for the filing year. Exogenous cost items are sale of exchanges, regulatory fees, excess deferred taxes, Investment Tax Credit (ITC) amortization, “removal of low end adjustment”, “trueup prior sharing / low end adjustment”, “current low end adjustment”, telecommunications relay services (communications services for persons with disabilities), “reg/non-reg” (changes in the allocation of costs between regulated and unregulated activities), North American Numbering Plan (NANP) expenses, removal of thousand block number pooling (TBNP), and other exogenous expenses that an ILEC claims, e.g. some payphone expenses and some local-number portability (LNP) expenses. The RTE includes price-cap indices (PCIs), actual price indices (APIs), and sub-band price indices (SBIs). Exogenous cost items not included in the RTE are important for interpreting changes in PCIs.
The Price-Cap Review Dataset (PCRD) includes RTEs from 1992 to 2009. The filings are from the annual access filing (about mid-June of filing year). Some carriers filed revisions to annual filings, and in earlier years some annual filings could not be located. The specific filings included in the PCRD were chosen on the basis of the most accurate and complete representation of annual filing data. Thus if revisions were made, and the revised filing was available, that filing was chosen for inclusion. If an annual filing could not be located, the available filing closest to an annual filing was sought. See the filing dates in Table 1 for identification of specific filings included in the PCRD.
The PCRD includes some filings for thirteen historical ILEC serving areas. The PCRD includes RTEs for the all the original Regional Bell Operation Company (RBOC) services areas. Company serving areas (cosa’s) covered are described in Tables 1 and 2 below. Note that coverage for filing years 1992 and 1993 is significantly less than for filing years 1994-2009. Imputations are thus necessary to construct aggregations for 1992-1993 that are consistent with those for 1994-2009. The historical construction of the New Bell Atlantic (BNTR) and then Verizon (VZTC) combined the Bell Atlantic, Nynex, and GTE serving areas included in the PCRD. The Verizon filings for 2006-2009 include GTE serving areas not previously in the PCRD. In 2007, about 14% of Verizon switched access lines were in GTE serving areas not previously included in serving areas in the PCRD. These additional Verizon-GTE switched access lines amount to about 5% of total switched access lines covered in the PCRD in 2007.
The PCRD covers a substantial share of U.S. switched access lines. The PCRD includes ILEC serving areas with 90% and 86% of switched access lines subject to price-cap regulation in 1994 and 2007, respectively. It includes ILEC serving areas with 80% and 64% of all U.S. switched access (both price-cap regulated and rate-of-return regulated lines) in 1994 and 2007, respectively. The underlying data and calculations for these figures are documented in the online PCRD coverage workbook (also Excel version). Lines included in the PCRD are not a representative sample of U.S. switched access lines. The PCRD mainly includes lines from large ILECs. Smaller ILECs and competitive LECs have significantly different regulation and rate structures than do large ILECs.
Demand and rate fields exist only for TRP categories that encompass only one rate element. In same cases, the reported revenue is not the same as revenue calculated from the reported rate and demand figures. In the PCRD, 41 lines have a revenue inconsistency greater than $100. For details, see the revenue inconsistency spreadsheet (here as an Excel file). The largest revenue inconsistency is about $2.7 million. A possible source of these inconsistencies is reporting demand and rates with less precision than was used in calculating the reported revenue.
|
Table 1 LEC Serving Areas included in the Price-Cap RTE Dataset
|
||||||||
|
|
COSA (company serving area code) |
|||||||
|
year |
AMTR |
BATR |
BNTR |
BSTR |
CBTC |
GTCA |
GTFL |
GTTX |
|
1992 |
|
6/26/1992 |
|
6/26/1992 |
|
|
|
|
|
1993 |
8/16/1993 |
7/19/1993 |
|
11/16/1993 |
|
6/1/1993 |
6/1/1993 |
|
|
1994 |
6/30/1994 |
6/29/1994 |
|
7/7/1994 |
|
7/7/1994 |
7/7/1994 |
7/7/1994 |
|
1995 |
7/27/1995 |
7/27/1995 |
|
5/9/1995 |
|
5/9/1995 |
5/9/1995 |
5/9/1995 |
|
1996 |
6/18/1996 |
4/2/1996 |
|
4/2/1996 |
|
4/2/1996 |
4/2/1996 |
4/2/1996 |
|
1997 |
6/16/1997 |
6/30/1997 |
|
6/30/1997 |
6/16/1997 |
6/16/1997 |
6/16/1997 |
6/16/1997 |
|
1998 |
6/16/1998 |
6/16/1998 |
|
6/16/1998 |
6/16/1998 |
6/22/1998 |
6/22/1998 |
6/22/1998 |
|
1999 |
6/16/1999 |
|
6/16/1999 |
6/16/1999 |
6/16/1999 |
6/16/1999 |
6/16/1999 |
6/16/1999 |
|
2000 |
7/27/2000 |
|
7/27/2000 |
7/27/2000 |
6/16/2000 |
7/27/2000 |
7/27/2000 |
7/27/2000 |
|
2001 |
6/18/2001 |
|
6/18/2001 |
6/18/2001 |
6/18/2001 |
6/18/2001 |
6/18/2001 |
6/18/2001 |
|
2002 |
6/17/2002 |
|
6/17/2002 |
6/17/2002 |
7/2/2002 |
6/17/2002 |
6/17/2002 |
6/17/2002 |
|
2003 |
6/16/2003 |
|
6/16/2003 |
6/16/2003 |
6/16/2003 |
6/16/2003 |
6/16/2003 |
6/16/2003 |
|
2004 |
6/16/2004 |
|
6/16/2004 |
6/16/2004 |
6/16/2004 |
6/16/2004 |
6/16/2004 |
6/16/2004 |
|
2005 |
6/16/2005 |
|
6/16/2005 |
6/16/2005 |
6/16/2005 |
6/16/2005 |
6/16/2005 |
6/16/2005 |
|
2006 |
6/16/2006 |
|
|
6/16/2006 |
6/16/2006 |
|
|
|
|
2007 |
6/15/2007 |
|
|
6/15/2007 |
6/30/2007 |
|
|
|
|
2008 |
6/16/2008 |
|
|
6/16/2008 |
6/16/2008 |
|
|
|
|
2009 |
6/16/2009 |
|
|
6/16/2009 |
6/16/2009 |
|
|
|
|
Table 1 (continued)
|
|||||||
|
year |
NXTR |
PTCA |
PTNV |
SNCT |
SWTR |
USTR |
VZTC |
|
1992 |
9/17/1992 |
|
|
|
6/26/1992 |
6/28/1992 |
|
|
1993 |
6/1/1993 |
8/27/1993 |
9/1/1993 |
|
9/1/1993 |
6/29/1993 |
|
|
1994 |
6/29/1994 |
6/14/1994 |
6/14/1994 |
7/7/1994 |
7/5/1994 |
7/7/1994 |
|
|
1995 |
5/25/1995 |
6/16/1995 |
7/7/1995 |
5/9/1995 |
5/9/1995 |
7/13/1995 |
|
|
1996 |
6/27/1996 |
4/2/1996 |
6/27/1996 |
4/2/1996 |
5/2/1996 |
4/2/1996 |
|
|
1997 |
6/30/1997 |
6/30/1997 |
6/30/1997 |
6/30/1997 |
6/30/1997 |
6/30/1997 |
|
|
1998 |
6/16/1998 |
6/30/1998 |
6/30/1998 |
6/16/1998 |
6/30/1998 |
6/16/1998 |
|
|
1999 |
|
6/16/1999 |
6/16/1999 |
6/16/1999 |
6/16/1999 |
6/16/1999 |
|
|
2000 |
|
7/27/2000 |
7/27/2000 |
7/27/2000 |
7/27/2000 |
7/27/2000 |
|
|
2001 |
|
6/18/2001 |
6/18/2001 |
6/18/2001 |
6/18/2001 |
7/27/2001 |
|
|
2002 |
|
6/17/2002 |
6/17/2002 |
6/17/2002 |
6/17/2002 |
6/17/2002 |
|
|
2003 |
|
6/16/2003 |
6/16/2003 |
6/16/2003 |
6/16/2003 |
6/16/2003 |
|
|
2004 |
|
6/16/2004 |
6/16/2004 |
6/16/2004 |
6/16/2004 |
6/16/2004 |
|
|
2005 |
|
6/16/2005 |
6/16/2005 |
6/16/2005 |
6/16/2005 |
6/16/2005 |
|
|
2006 |
|
6/16/2006 |
6/16/2006 |
6/16/2006 |
6/16/2006 |
6/16/2006 |
6/16/2006 |
|
2007 |
|
6/15/2007 |
6/15/2007 |
6/15/2007 |
6/15/2007 |
6/15/2007 |
6/15/2007 |
|
2008 |
|
6/16/2008 |
6/16/2008 |
6/16/2008 |
6/16/2008 |
6/16/2008 |
6/16/2008 |
|
2009 |
|
6/16/2009 |
6/16/2009 |
6/16/2009 |
6/16/2009 |
6/16/2009 |
6/16/2009 |
|
Table 2 COSA Code Descriptions
|
|
|
cosa |
company |
|
AMTR |
Ameritech |
|
BATR |
historic Bell Atlantic |
|
BNTR |
new Bell Atlantic |
|
BSTR |
Bell South |
|
CBTC |
Cincinnati Bell |
|
GTCA |
GTE California |
|
GTFL |
GTE Florida |
|
GTTX |
GTE Texas |
|
NXTR |
Nynex |
|
PTCA |
Pacific Bell - California |
|
PTNV |
Pacific Bell - Nevada |
|
SNCT |
Southern New England Telephone |
|
SWTR |
Southwestern Bell |
|
USTR |
US West (now Qwest) |
|
VZTC |
Verizon |
|
For fuller descriptions of cosa’s see, http://www.fcc.gov/wcb/armis/carrier_filing_history/ |
|
PCRD Technical Description
The PCRD table "rte 1992-2009.txt" contains the RTE data lines for all cosa’s. Descriptive, non-data lines from the RTEs have been preserved where consistent with field definitions, i.e. text fields. Selecting on a year / cosa and sorting on line number (ln) will place these descriptive records in source-order relative to the data records. The table “template.txt” describes the standardized TRP across years. The template table is used to add or modify descriptive category fields in the rte table. To update the rte table with different template entries, joins the rte table to the template table using the lcode field. Filter records by rte year field falling within year-s and year-e in the template table. The template table can be easily updated to accommodate additional years’ data appended to the rte table by incrementing year-e fields of 2009, and making whatever additional changes are appropriate. Not dynamically joining the rte and template tables allow queries to run faster and the rte table to be analyzed independently from the template table.
Note that the use of subtotal lines is ad hoc in the RTEs. Hence care must be exercised in summing categories to compute aggregates. Some categories include total lines (as well as index lines). The template table should be inspected to determine how to get aggregates.
The “” table includes some additional filings for some cosa’s in some years. The filings included in "rte 1992-2009" were considered better than other filings in “rte extra filings” for the purpose of a compilation of annual access filings. The “rte extra filings” table also includes Bell Atlantic filings where available after Bell Atlantic was subsumed in the new Bell Atlantic and then Verizon. The “rte extra filings” table has the same field structure as the rte 1992-2009 table.
Descriptive fields added to the RTE data records are basket, cat1 to cat3, zone, and band. These descriptive fields follow directly from the standardized specification of the RTE data lines (lname and associated FCC TRP definitions). The fields cat1 to cat3 use abbreviations similar to those used in the bandwidth demand and prices datasets. See the descriptions for those datasets to better understand abbreviations used in cat1-3. The field cat3 includes tags differentiating between premium services (services that provide Feature Group D equal access to presubscribed interstate interexchange carriers) and non-premium services (which do not support equal access). Tags in cat2 differentiate local switching (tagged in cat1) between LS1 (Feature Group A and B service) and LS2 (Feature Group C and D service). Premium, LS2 services predominate in minutes of use for cosa’s included in the PCRD. Codes for “total” occur in cat1, cat2, and cat3. The field containing the total code depends on the position of the total line in the aggregation hierarchy. The same is true for index codes API, PCI, SBI, upper SBI, and lower SBI. The template table should be consulted to understand how to select appropriately on cat fields to get consistent data across years.
Note that demand and rate fields are blank for data lines that encompass more than one rate element. Demand and rates for all rate elements are listed in unstructured rate detail files.
|
Table 3 Field Descriptions for RTE Table
|
|
|
field |
description |
|
cosa |
company study area code |
|
year |
filing year |
|
date |
filing date |
|
ln |
source record sequence number (includes non-integers for corrections/insertions) |
|
lcode |
standardized TRP data line numbers (some changes across years); includes some descriptive text for non-data lines |
|
lname |
TRP line description text |
|
basket |
price cap basket name |
|
cat1 |
cat1-3 categorize data lines (see above) |
|
cat2 |
|
|
cat3 |
|
|
zone |
service zone (inc. "nz" and "all") |
|
band |
service band (used only in 1992-1993) |
|
demand |
monthly demand units for the previous calendar year (base year) |
|
lrate |
rate at last update of the PCI |
|
crate |
current rate |
|
prate |
proposed rate |
|
lrev |
revenue calculated as lrate times demand (as defined in previous fields) |
|
crev |
revenue calculated as crate times demand |
|
prev |
revenue calculated as prate times demand |
|
index |
field containing PCI, API, and SBI indices and bands, according to line specification |
|
Table 4 Field Descriptions for Template Table
|
|
|
field |
description |
|
ln |
line sequence number (most useful in conjunction with selection of records with a common start year) |
|
year-s |
filing year the standardized data line entered the TRP |
|
year-e |
last filing year the standardized data line was in the TRP |
|
lcode |
standardized data line code (used in match to data lines in RTE table) |
|
lname |
line description from the TRP (some variants across years) |
|
basket |
price cap basket to which the line belongs |
|
cat1 |
cat1-cat3 are descriptive tags for the line |
|
cat2 |
|
|
cat3 |
|
|
zone |
service zone associated with the line |
|
band |
band associated with the line |
[1] ILECs subject to rate review have filed standardized TRPs since just after the AT&T divestiture. See, e.g. Commission Requirements for Cost Support Material To Be Filed with Access Tariffs on October 3, 1986, Mimeo No. 6356, released Aug. 15, 1986 (1987 TRP Order); Commission Requirements for Cost Support Material To Be Filed with 1988 Annual Access Tariffs, Mimeo No. 4219, released July 30, 1987 (1988 TRP Order).