FERC Form 1 Data Dictionary#

We have mapped the Visual FoxPro DBF files to their corresponding FERC Form 1 database tables and provided a short description of the contents of each table here.

Note

  • The Table Names link to the contents of the database table on our FERC Form 1 Datasette deployment where you can browse and query the raw data yourself or download the SQLite DB in its entirety.

  • The mapping of File Name to Table Name is consistent across all years of data.

  • Page numbers correspond to the pages of the FERC Form 1 PDF as it appeared in 2015 and may not be valid for other years.

  • Many tables without descriptions were discontinued prior to 2015.

  • The “Freq” column indicates the reporting frequency – A for Annual; Q for Quarterly. A/Q if the data is reported both annually and quarterly.

Table Name / Data Link

File Name

Pages

Freq

Table Description

f1_106_2009

F1_106_2009.DBF

106

A

Information on Formula Rates

f1_106a_2009

F1_106A_2009.DBF

106

A

Information on Formula Rates

f1_106b_2009

F1_106B_2009.DBF

106

A

Information on Formula Rates

f1_208_elc_dep

F1_208_ELC_DEP.DBF

208

Q

Electric Plant In Service and Accumulated Provision For Depreciation by Function

f1_231_trn_stdycst

F1_231_TRN_STDYCST.DBF

231

A/Q

Transmission Service and Generation Interconnection Study Costs

f1_324_elc_expns

F1_324_ELC_EXPNS.DBF

324

Q

Electric Production, Other Power Supply Expenses, Transmission and Distribution Expenses

f1_325_elc_cust

F1_325_ELC_CUST.DBF

325

Q

Electric Customer Accounts, Service, Sales, Administration and General Expenses

f1_331_transiso

F1_331_TRANSISO.DBF

331

A/Q

Transmission of Electricity by ISO/RTOs

f1_338_dep_depl

F1_338_DEP_DEPL.DBF

338

Q

Depreciation, Depletion and Amortization of Electric Plant (FERC Accounts 403, 403.1, 404, and 405, except Amortization of Acquisition Adjustments)

f1_397_isorto_stl

F1_397_ISORTO_STL.DBF

397

A/Q

Amounts Included in ISO/RTO Settlement Statements

f1_398_ancl_ps

F1_398_ANCL_PS.DBF

398

A

Purchases and Sales of Ancillary Services

f1_399_mth_peak

F1_399_MTH_PEAK.DBF

399

A/Q

Monthly Peak Loads and Energy Output

f1_400_sys_peak

F1_400_SYS_PEAK.DBF

400

A/Q

Monthly Transmission System Peak Load

f1_400a_iso_peak

F1_400A_ISO_PEAK.DBF

980, 400a

A/Q

Monthly ISO/RTO Transmission System Peak Load

f1_429_trans_aff

F1_429_TRANS_AFF.DBF

429

A

Transactions with Associated (Affiliated) Companies

f1_acb_epda

F1_2.DBF

336-337

A

Depreciation & Amortization of Electric Plant (Basis for Amortization Charges)

f1_accumdepr_prvsn

F1_3.DBF

219

A

Accumulated Provision for Depreciation of Elecric Utility Plant (Account 108)

f1_accumdfrrdtaxcr

F1_4.DBF

266-267

A

Accumulated Deferred Investment Tax Credits

f1_adit_190_detail

F1_5.DBF

234-234a

A

Accumulated Deferred Income Taxes (Individual Schedule Lines)

f1_adit_190_notes

F1_6.DBF

234-234b

A

Accumulated Deferred Income Taxes (Notes)

f1_adit_amrt_prop

F1_7.DBF

272-273

A

Accumulated Deferred Income Taxes - Accelerated Amortization Property

f1_adit_other

F1_8.DBF

276-277

A

Accumulated Deferred Income Taxes - Other

f1_adit_other_prop

F1_9.DBF

274-275

A

Accumulated Deferred Income Taxes - Other Property

f1_allowances

F1_10.DBF

228-229

A

SO2 Emissions Allowances

f1_allowances_nox

F1_ALLOWANCES_NOX.DBF

228-229

A

NOx Emissions Allowances

f1_audit_log

F1_78.DBF

Not a data table. Has to do with data access logging? Appears only in 1994-1995 data.

f1_bal_sheet_cr

F1_11.DBF

112-113

A/Q

Comparative Balance Sheet (Liabilities & Other Credits)

f1_capital_stock

F1_12.DBF

250-251

A

Capital Stock

f1_cash_flow

F1_13.DBF

120-121

A/Q

Statement of Cash Flows

f1_cmmn_utlty_p_e

F1_14.DBF

356

A

Common Utility Plant & Expenses

f1_cmpinc_hedge

F1_CMPINC_HEDGE.DBF

990, 122(a)(b)

A/Q

Statement of Accumulated Comparative Income, Comparative Income, and Hedging Activities

f1_cmpinc_hedge_a

F1_CMPINC_HEDGE_A.DBF

990

Statement of Accumulated Comparative Income, Comparative Income, and Hedging Activities

f1_co_directors

F1_18.DBF

105

A

Names, Titles, and Addresses of Directors

f1_codes_val

F1_76.DBF

Contains various DBF/Visual FoxPro error codes and their meanings.

f1_col_lit_tbl

F1_79.DBF

Descriptive headers for each column in the Form 1. Useful for discerning their semantic content.

f1_comp_balance_db

F1_15.DBF

110-111

A/Q

Comparative Balance Sheet (Assets & Other Debits)

f1_construction

F1_16.DBF

217

Spending on Construction (1994-2002 only)

f1_control_respdnt

F1_17.DBF

102

A

Control Over Respondent

f1_cptl_stk_expns

F1_19.DBF

254-254b

A

Capital Stock Expense

f1_csscslc_pcsircs

F1_20.DBF

252

Information related to utility preferred capital stock. Reported 1994-2002.

f1_dacs_epda

F1_21.DBF

336-337

A

Depreciation & Amortization of Electric Plant (Depreciation & Amortization Charges)

f1_dscnt_cptl_stk

F1_22.DBF

254

Discount on capital stock

f1_edcfu_epda

F1_23.DBF

336-337

A

Depreciation & Amortization of Electric Plant (Factors Used in Estimating Depreciation Charges)

f1_elc_op_mnt_expn

F1_27.DBF

320-323

A

Electric Operation & Maintenance Expenses

f1_elc_oper_rev_nb

F1_26.DBF

300-301b

A/Q

Electric Operating Revenues (Unbilled Revenues Only)

f1_elctrc_erg_acct

F1_24.DBF

401-401a

A

Electric Energy Account

f1_elctrc_oper_rev

F1_25.DBF

300-301a

A/Q

Electric Operating Revenues (Individual Schedule Lines)

f1_electric

F1_28.DBF

429

Meaning unclear. We do not have a copy of this page.

f1_email

F1_EMAIL.DBF

Respondent point of contact email addresses.

f1_envrnmntl_expns

F1_29.DBF

431

Environmental Expenses. Filed 1994-2002. We do not have a copy of this page.

f1_envrnmntl_fclty

F1_30.DBF

430

Environmental Facilities. Filed 1994-2002. We do not have a copy of this page.

f1_footnote_data

F1_85.DBF

450

A/Q

Footnote Data. Used to be large binary attachments, now nearly empty. Not loaded into the combined FERC 1 SQLite DB.

f1_footnote_tbl

F1_87.DBF

Table containing pointers to the footnote data. Not loaded into the combined FERC 1 SQLite DB.

f1_freeze

F1_FREEZE.DBF

f1_fuel

F1_31.DBF

402-403b

A

Steam-Electric Generation Plant Statistics - Large Plants (Fuel Details)

f1_general_info

F1_32.DBF

101

A

General Information

f1_gnrt_plant

F1_33.DBF

410-411

A

Generating Plant Statistics (Small Plants)

f1_hydro

F1_86.DBF

406-407

A

Hydroelectric Gen Plant Stats (Large Plants)

f1_ident_attsttn

F1_88.DBF

1

A/Q

Identification & Attestation

f1_important_chg

F1_34.DBF

108-109

A/Q

Important Changes During the Quarter/Year

f1_incm_stmnt_2

F1_35.DBF

114-117b

A/Q

Statement of Income (Other Income & Deductions, Interest Charges, Extraordinary Items)

f1_income_stmnt

F1_36.DBF

114-117a

A/Q

Statement of Income

f1_leased

F1_90.DBF

213

A

Electric Plant Leased to Others

f1_load_file_names

F1_80.DBF

Lists files containing various pieces of information to be loaded into the DBF database. Only present in 1995.

f1_long_term_debt

F1_93.DBF

256-257

A

Long-Term Debt

f1_misc_dfrrd_dr

F1_38.DBF

233

A

Miscellaneous Deferred Debits

f1_miscgen_expnelc

F1_37.DBF

335

A

Miscellaneous General Expenses - Electric

f1_mthly_peak_otpt

F1_39.DBF

401-401b

A

Monthly Peaks & Output

f1_mtrl_spply

F1_40.DBF

227, 228-229

A

Materials & Supplies

f1_nbr_elc_deptemp

F1_41.DBF

320

Payroll totals and number of permanent and temporary employees. Reported 1994-2001.

f1_nonutility_prop

F1_42.DBF

221

Investments in non-utility property. Reported 1994-2002.

f1_note_fin_stmnt

F1_43.DBF

122-123

A/Q

Notes to Financial Statements

f1_nuclear_fuel

F1_44.DBF

202-203

A

Nuclear Fuel Materials

f1_officers_co

F1_45.DBF

104

A

Officers

f1_othr_dfrrd_cr

F1_46.DBF

269

A

Other Deferred Credits

f1_othr_pd_in_cptl

F1_47.DBF

253

A

Other Paid-in Capital

f1_othr_reg_assets

F1_48.DBF

232

A/Q

Other Regulatory Assets

f1_othr_reg_liab

F1_49.DBF

278

A/Q

Other Regulatory Liabilities

f1_overhead

F1_50.DBF

218

Overhead. Reported 1994-2002. We have no copy of this page.

f1_pccidica

F1_51.DBF

340

Deductions of income and interest charges. Reported 1994-2001.

f1_pins

F1_PINS.DBF

Personal Identification Numbers used to authenticate respondents. Not distributed in FERC’s public data.

f1_plant

F1_92.DBF

204, 214

A

Electric Plant Held for Future Use

f1_plant_in_srvce

F1_52.DBF

204-207

A

Electric Plant in Service

f1_privilege

F1_81.DBF

Empty table pertaining to original DBF database permissions.

f1_pumped_storage

F1_53.DBF

408-409

A

Pumped Storage Generating Plant Statistics (Large Plants)

f1_purchased_pwr

F1_54.DBF

326-327

A

Purchased Power

f1_r_d_demo_actvty

F1_59.DBF

352-353

A

Research, Development & Demonstration Activities

f1_reconrpt_netinc

F1_55.DBF

261

A

Reconciliation of Reported Net Income with Taxable Income for Federal Income Taxes

f1_reg_comm_expn

F1_56.DBF

350-351

A

Regulatory Commission Expenses

f1_respdnt_control

F1_57.DBF

103

A

Corporations Controlled by Respondent

f1_respondent_id

F1_1.DBF

Respondent ID

f1_retained_erng

F1_58.DBF

118-119

A/Q

Statement of Retained Earnings for the Year

f1_rg_trn_srv_rev

F1_RG_TRN_SRV_REV.DBF

302

A/Q

Regional Transmission Service Revenues (Account 457.1)

f1_row_lit_tbl

F1_84.DBF

Descriptive labels for each numbered row in the Form 1. Useful for identifying semantic content and changes in line numbers from year to year.

f1_s0_checks

F1_S0_CHECKS.DBF

Empty table, apparently related to validating calculations within the DBF database.

f1_s0_filing_log

F1_S0_FILING_LOG.DBF

Records the email of whoever submitted each filing, and when it was submitted, received, and loaded.

f1_sale_for_resale

F1_61.DBF

310-311

A

Sales for Resale

f1_sales_by_sched

F1_60.DBF

304

A

Sales of Electricity by Rate Schedules

f1_sbsdry_detail

F1_91.DBF

224-225

A

Investment in Subsidiary Companies (Account 123.1)

f1_sbsdry_totals

F1_62.DBF

224-225

A

Investment in Subsidiary Companies (Total Line for Schedule)

f1_sched_lit_tbl

F1_77.DBF

Strings used to describe the schedules in the form each year.

f1_schedules_list

F1_63.DBF

002-004

A/Q

Lists the schedules submitted by each respondent each quarter or year.

f1_security

F1_SECURITY.DBF

106

Respondent password information. Empty table.

f1_security_holder

F1_64.DBF

106

Shares held by the utility. Describes proxy voting.

f1_slry_wg_dstrbtn

F1_65.DBF

354-355

A

Distribution of Salaries & Wages

f1_steam

F1_89.DBF

402-403a

A

Steam-Electric Generation Plant Statistics - Large Plants (Plant Information)

f1_substations

F1_66.DBF

426-427

A

Substations

f1_sys_error_log

F1_82.DBF

Database error logs. Reported 1994-1995 only.

f1_taxacc_ppchrgyr

F1_67.DBF

262-263

A

Taxes Accrued, Prepaid & Charged During Year

f1_unique_num_val

F1_83.DBF

Very small junk table.

f1_unrcvrd_cost

F1_68.DBF

230-230b

A

Unrecovered Plant & Regulatory Study Costs

f1_utltyplnt_smmry

F1_69.DBF

200-201

A/Q

Summary of Utility Plant & Accumulated Provisions for Depreciation, Amortization, & Depletion

f1_work

F1_70.DBF

216

A

Construction Work in Progress - Electric

f1_xmssn_adds

F1_71.DBF

424-425

A

Transmission Lines Added During Year

f1_xmssn_elc_bothr

F1_72.DBF

332

A/Q

Transmission of Electricity by Others

f1_xmssn_elc_fothr

F1_73.DBF

328-330

A/Q

Transmission of Electricity for Others

f1_xmssn_line

F1_74.DBF

422-423

A

Transmission Line Statistics

f1_xtraordnry_loss

F1_75.DBF

230-230a

A

Extraordinary Property Losses