About this Dataset

Connecticut Personal Income Tax Summary

Beginning with tax year ("TY") 2021, this data asset will be the new home for the "Individual Income Tax Reports" which were previously uploaded to the Department of Revenue Services ("DRS") page of the state website. Connecticut imposes a tax on income earned by resident individuals, trusts, and estates. Nonresidents and part-year resident individuals, trusts, and estates are also subject to the tax on income derived from or connected with sources within the State.
Organization: State of Connecticut
Last updated: 2024-02-02T15:33:33.072943
Tags: ct-personal-income-tax-credits, department-of-revenue-services, drs-tax-data, tax-credits

Tables

Table 1

@usgov.state_of_connecticut_connecticut_personal_income_tax_summary.table_1

246.75 kB
696 rows
59 columns

CREATE TABLE table_1 (
  "filing_period" BIGINT,
  "residency" VARCHAR,
  "filing_status" VARCHAR,
  "ct_agi_interval" VARCHAR,
  "number_of_filers" BIGINT,
  "federal_agi" BIGINT,
  "federal_agi_additions" BIGINT,
  "federal_agi_subtractions" BIGINT,
  "ct_agi" BIGINT,
  "nr_py_income_ct_sources" BIGINT,
  "nr_py_ct_agi_or_ct_sources_income" BIGINT,
  "nr_py_income_tax" BIGINT,
  "nr_py_line_9_x_line_8" BIGINT,
  "nr_py_credit_other_jurisdictions" BIGINT,
  "income_tax_from_schedules" BIGINT  -- Income Tax (From Schedules),
  "credit_for_taxes_paid_to_other_jurisdictions" BIGINT,
  "ct_alternative_minimum_tax" BIGINT,
  "credit_for_property_tax" BIGINT,
  "total_allowable_credits" BIGINT,
  "ct_income_tax" BIGINT,
  "use_tax" BIGINT,
  "total_tax" BIGINT,
  "income_tax_withheld" BIGINT,
  "estimated_payments" BIGINT,
  "extension_payments" BIGINT,
  "ct_earned_income_tax_credit" BIGINT,
  "claim_of_right_credit" BIGINT,
  "pass_through_entity_tax_credit" BIGINT,
  "total_payments_credits" BIGINT  -- Total Payments & Credits,
  "carryforward" BIGINT,
  "charitable_deduction" BIGINT,
  "chet_refund" BIGINT,
  "refund_amount" BIGINT,
  "tax_owed" BIGINT,
  "underpayment_interest" BIGINT,
  "interest_on_state_and_local_government_obligations_oth_4ed66779" BIGINT  -- Interest On State And Local Government Obligations Other Than Connecticut,
  "mutual_fund_exempt_interest_dividends_from_non_connect_bf1f30d6" BIGINT  -- Mutual Fund Exempt-Interest Dividends From Non-Connecticut State Or Municipal Government Obligations,
  "taxable_amount_of_lump_sum_distributions_from_qualifie_4a40d184" BIGINT  -- Taxable Amount Of Lump-Sum Distributions From Qualified Plans Not Included In Federal Adjusted Gross Income,
  "beneficiary_s_share_of_connecticut_fiduciary_adjustmen_d2570a2a" BIGINT  -- Beneficiary's Share Of Connecticut Fiduciary Adjustment - Addition,
  "loss_on_sale_of_connecticut_state_and_local_government_bonds" BIGINT,
  "section_168_k_federal_bonus_depreciation_deduction_all_c152a510" BIGINT  -- Section 168(k) Federal Bonus Depreciation Deduction Allowed For Property Placed In Service During This Year,
  "percent_of_section_179_federal_deduction" BIGINT,
  "other_additions_amount" BIGINT,
  "total_additions" BIGINT,
  "interest_on_u_s_government_obligations" BIGINT  -- Interest On U.S. Government Obligations,
  "exempt_dividends_from_certain_qualifying_mutual_funds__56951fb2" BIGINT  -- Exempt Dividends From Certain Qualifying Mutual Funds Derived From U.S. Government Obligations,
  "social_security_benefit_adjustment" BIGINT,
  "refunds_of_state_and_local_income_taxes" BIGINT,
  "tier_1_and_tier_2_railroad_retirement_benefits_and_sup_471c8ded" BIGINT  -- Tier 1 And Tier 2 Railroad Retirement Benefits And Supplemental Annuities,
  "military_retirement_pay" BIGINT,
  "percent_of_income_received_from_the_connecticut_teache_1cb74746" BIGINT  -- Percent Of Income Received From The Connecticut Teachers' Retirement System,
  "beneficiary_s_share_of_connecticut_fiduciary_adjustmen_4b9c543c" BIGINT  -- Beneficiary's Share Of Connecticut Fiduciary Adjustment - Subtraction,
  "gain_on_sale_of_connecticut_state_and_local_government_bonds" BIGINT,
  "connecticut_higher_education_trust_chet_contributions_made" BIGINT  -- Connecticut Higher Education Trust (CHET) Contributions Made,
  "percent_of_section_168_k_federal_bonus_depreciation_de_4dd71ac7" BIGINT  -- Percent Of Section 168(k) Federal Bonus Depreciation Deduction Added Back In Eligible Number Of Preceding Years,
  "pension_or_annuity_income" BIGINT,
  "business_expenses_for_taxpayers_licensed_under_chapter_bb8768bb" DOUBLE  -- Business Expenses For Taxpayers Licensed Under Chapter 420f Or 420h,
  "other_subtractions_amount" BIGINT,
  "total_subtractions" BIGINT
);