Raw 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