PIT Annual Report 2020 Excel

data.ftb.ca.gov | Last Updated 3 Jan 2022

Excel Summary of the Department's major program activities and statistical profile of California individual taxpayers.

Tags: excel, annual report, 2020, personal income tax

This dataset has the following 150 columns:

Column NameAPI Column NameData TypeSample Values
Adjusted Gross Income Classadjusted_gross_income_classtext
Number of Returnsnumber_of_returnstext
Unnamed Columnunnamed_columntext
Federal AGI (Thousands)federal_agi_thousandstext
California Adjustments (Thousands)california_adjustmentstext
California AGI (Thousands)california_agi_thousandstext
California Deductions (Thousands)california_deductionstext
Taxable Income (Thousands)taxable_income_thousandstext
Total Tax Liability (Thousands)total_tax_liability_thousandstext
Wages and Salarieswages_and_salariestext
Unnamed Column 1unnamed_column_1text
Taxable Interesttaxable_interesttext
Unnamed Column 2unnamed_column_2text
Taxable Dividendstaxable_dividendstext
Unnamed Column 3unnamed_column_3text
Taxable Pensions and Annuitiestaxable_pensions_and_annuitiestext
Unnamed Column 4unnamed_column_4text
Business Incomebusiness_incometext
Unnamed Column 5unnamed_column_5text
Unnamed Column 6unnamed_column_6text
Unnamed Column 7unnamed_column_7text
Net Sale of Capital Assetsnet_sale_of_capital_assetstext
Unnamed Column 8unnamed_column_8text
Unnamed Column 9unnamed_column_9text
Unnamed Column 10unnamed_column_10text
Rents and Royaltiesrents_and_royaltiestext
Unnamed Column 11unnamed_column_11text
Unnamed Column 12unnamed_column_12text
Unnamed Column 13unnamed_column_13text
Partnerships and S-Corp Gainpartnerships_and_s_corp_gaintext
Unnamed Column 14unnamed_column_14text
Partnerships and S-Corp Losspartnerships_and_s_corp_losstext
Unnamed Column 15unnamed_column_15text
Estates and Trusts Gainestates_and_trusts_gaintext
Unnamed Column 16unnamed_column_16text
Estates and Trusts Lossestates_and_trusts_losstext
Unnamed Column 17unnamed_column_17text
Farm Incomefarm_incometext
Unnamed Column 18unnamed_column_18text
Unnamed Column 19unnamed_column_19text
Unnamed Column 20unnamed_column_20text
All Other Federal Income Sources Profitall_other_federal_incometext
Unnamed Column 21unnamed_column_21text
All Other Federal Income Sources Lossall_other_federal_income_1text
Unnamed Column 22unnamed_column_22text
Total Incometotal_incometext
Unnamed Column 23unnamed_column_23text
Individual Retirement Planindividual_retirement_plantext
Unnamed Column 24unnamed_column_24text
Student Loan Intereststudent_loan_interesttext
Unnamed Column 25unnamed_column_25text
Tuition & Feestuition_feestext
Unnamed Column 26unnamed_column_26text
Moving Expensemoving_expensetext
Unnamed Column 27unnamed_column_27text
Half Self-Employment Taxhalf_self_employment_taxtext
Unnamed Column 28unnamed_column_28text
Self-Employed Health Insuranceself_employed_health_insurancetext
Unnamed Column 29unnamed_column_29text
Self-Employed Retirement Planself_employed_retirementtext
Unnamed Column 30unnamed_column_30text
Penalty on Early Withdrawal of Savingspenalty_on_early_withdrawaltext
Unnamed Column 31unnamed_column_31text
Alimony Paidalimony_paidtext
Unnamed Column 32unnamed_column_32text
Domestic Productiondomestic_productiontext
Unnamed Column 33unnamed_column_33text
Total Adjustmentstotal_adjustmentstext
Unnamed Column 34unnamed_column_34text
Total California Subtractionstotal_california_subtractionstext
Unnamed Column 35unnamed_column_35text
Total California Additionstotal_california_additionstext
Unnamed Column 36unnamed_column_36text
Medical Expensesmedical_expensestext
Unnamed Column 37unnamed_column_37text
State and Local Income Taxesstate_and_local_income_taxestext
Unnamed Column 38unnamed_column_38text
Real Estate Taxesreal_estate_taxestext
Unnamed Column 39unnamed_column_39text
Personal Property Taxespersonal_property_taxestext
Unnamed Column 40unnamed_column_40text
Other Taxesother_taxestext
Unnamed Column 41unnamed_column_41text
Total Taxestotal_taxestext
Unnamed Column 42unnamed_column_42text
Mortgage Interestmortgage_interesttext
Unnamed Column 43unnamed_column_43text
Points and Investment Interestpoints_and_investment_interesttext
Unnamed Column 44unnamed_column_44text
Total Interesttotal_interesttext
Unnamed Column 45unnamed_column_45text
Cash/Check Contributionscash_check_contributionstext
Unnamed Column 46unnamed_column_46text
Non-Cash Contributionsnon_cash_contributionstext
Unnamed Column 47unnamed_column_47text
Contribution Carryovercontribution_carryovertext
Unnamed Column 48unnamed_column_48text
Total Contributionstotal_contributionstext
Unnamed Column 49unnamed_column_49text
Casualty and Theft Lossescasualty_and_theft_lossestext
Unnamed Column 50unnamed_column_50text
All Other Deductionsall_other_deductionstext
Unnamed Column 51unnamed_column_51text
Total Federal Itemized Deductionstotal_federal_itemizedtext
Unnamed Column 52unnamed_column_52text
California Adjusted to Fed Itemized Deductionscalifornia_adjusted_to_fedtext
Unnamed Column 53unnamed_column_53text
California Itemized Deductionscalifornia_itemized_deductionstext
Unnamed Column 54unnamed_column_54text
California Standard Deductionscalifornia_standard_deductionstext
Unnamed Column 55unnamed_column_55text
Personal Exemption Creditpersonal_exemption_credittext
Personal Exemption Credit 1personal_exemption_credit_1text
Dependent Exemption Creditdependent_exemption_credittext
Dependent Exemption Credit 1dependent_exemption_credit_1text
Senior/Blind Exemption Creditsenior_blind_exemption_credittext
Senior/Blind Exemption Credit 1senior_blind_exemption_credit_1text
Total Exemption Credittotal_exemption_credittext
Unnamed Column 56unnamed_column_56text
Other State Tax Creditother_state_tax_credittext
Unnamed Column 57unnamed_column_57text
Total Special Credittotal_special_credittext
Unnamed Column 58unnamed_column_58text
Renter's Creditrenter_s_credittext
Unnamed Column 59unnamed_column_59text
G-1 Tax/5870A Taxg_1_tax_5870a_taxtext
Unnamed Column 60unnamed_column_60text
Alternative Minimum Taxalternative_minimum_taxtext
Unnamed Column 61unnamed_column_61text
Mental Health Taxmental_health_taxtext
Unnamed Column 62unnamed_column_62text
Other Taxes 1other_taxes_1text
Unnamed Column 63unnamed_column_63text
Taxes Witheldtaxes_witheldtext
Unnamed Column 64unnamed_column_64text
Estimated Taxes Paidestimated_taxes_paidtext
Unnamed Column 65unnamed_column_65text
Excess State Disability Insurance (SDI)excess_state_disabilitytext
Unnamed Column 66unnamed_column_66text
Nonrefundable Child and Dependent Creditnonrefundable_child_andtext
Unnamed Column 67unnamed_column_67text
Overpaymentoverpaymenttext
Unnamed Column 68unnamed_column_68text
Credit to Next Year's Taxcredit_to_next_year_s_taxtext
Unnamed Column 69unnamed_column_69text
Total Voluntary Contributionstotal_voluntary_contributionstext
Unnamed Column 70unnamed_column_70text
Refundrefundtext
Unnamed Column 71unnamed_column_71text
Tax Duetax_duetext