Baselight

U.S. Government Revenue Collections

U.S. Government Revenue Collections from 12/28/2018 to 12/27/2023

@kaggle.sriharshaeedala_u_s_government_revenue_collections

Usgovtrevcollect 20041001–20231227
@kaggle.sriharshaeedala_u_s_government_revenue_collections.usgovtrevcollect_20041001_20231227

  • 984.63 KB
  • 81248 rows
  • 15 columns
record_date

Record Date

electronic_category_description

Electronic Category Description

channel_type_description

Channel Type Description

tax_category_description

Tax Category Description

net_collections_amount

Net Collections Amount

electronic_category_id

Electronic Category ID

channel_type_id

Channel Type ID

tax_category_id

Tax Category ID

source_line_number

Source Line Number

fiscal_year

Fiscal Year

fiscal_quarter_number

Fiscal Quarter Number

calendar_year

Calendar Year

calendar_quarter_number

Calendar Quarter Number

calendar_month_number

Calendar Month Number

calendar_day_number

Calendar Day Number

Wed Dec 27 2023 00:00:00 GMT+0000 (Coordinated Universal Time)Non-ElectronicMailNon-Tax726.95421120241202341227
Wed Dec 27 2023 00:00:00 GMT+0000 (Coordinated Universal Time)Electronic SettlementOver-the-Counter (OTC)Non-Tax243104.79311220241202341227
Wed Dec 27 2023 00:00:00 GMT+0000 (Coordinated Universal Time)Non-ElectronicOver-the-Counter (OTC)Non-Tax9395109.54411320241202341227
Wed Dec 27 2023 00:00:00 GMT+0000 (Coordinated Universal Time)Fully Electronic - FSOver-the-Counter (OTC)IRS Non-Tax48241.05212420241202341227
Wed Dec 27 2023 00:00:00 GMT+0000 (Coordinated Universal Time)Fully Electronic - AllBankIRS Tax2905.82153520241202341227
Wed Dec 27 2023 00:00:00 GMT+0000 (Coordinated Universal Time)Non-ElectronicOver-the-Counter (OTC)IRS Tax8928690.37413620241202341227
Wed Dec 27 2023 00:00:00 GMT+0000 (Coordinated Universal Time)Fully Electronic - AllInternetIRS Non-Tax340448.95132720241202341227
Wed Dec 27 2023 00:00:00 GMT+0000 (Coordinated Universal Time)Fully Electronic - AllBankNon-Tax1745081461.06151820241202341227
Wed Dec 27 2023 00:00:00 GMT+0000 (Coordinated Universal Time)Fully Electronic - FSOver-the-Counter (OTC)Non-Tax108002625.79211920241202341227
Wed Dec 27 2023 00:00:00 GMT+0000 (Coordinated Universal Time)Fully Electronic - FSOver-the-Counter (OTC)IRS Tax228590095.332131020241202341227

CREATE TABLE usgovtrevcollect_20041001_20231227 (
  "record_date" TIMESTAMP,
  "electronic_category_description" VARCHAR,
  "channel_type_description" VARCHAR,
  "tax_category_description" VARCHAR,
  "net_collections_amount" DOUBLE,
  "electronic_category_id" BIGINT,
  "channel_type_id" BIGINT,
  "tax_category_id" BIGINT,
  "source_line_number" BIGINT,
  "fiscal_year" BIGINT,
  "fiscal_quarter_number" BIGINT,
  "calendar_year" BIGINT,
  "calendar_quarter_number" BIGINT,
  "calendar_month_number" BIGINT,
  "calendar_day_number" BIGINT
);

Share link

Anyone who has the link will be able to view this.