Electoral Bonds 2024

Insights into Political Financing: Electoral Bonds 2024 Dataset

@kaggle.sushantchougule_electoral_bonds_2024

Table List

1 table(197.14 KB)

Electoral Bonds Clean

@kaggle.sushantchougule_electoral_bonds_2024.electoral_bonds_clean

197.14 KB
18741 rows
16 columns

reference_no_urn Reference No (URN)	journal_date Journal Date	purchase_date Purchase Date	expiry_date Expiry Date	purchaser_name Purchaser Name	prefix Prefix	bond_number Bond Number	denominations Denominations	issue_branch_code Issue Branch Code	issue_teller Issue Teller	status Status	date_of_encashment Date Of Encashment	political_party Political Party	political_party_account_no Political Party Account No.	pay_branch_code Pay Branch Code	pay_teller Pay Teller
00001201904120000001166	12/Apr/2019	12/Apr/2019	26/Apr/2019	A B C INDIA LIMITED	TL	11448	1000000	1	5899230	Paid	25/Apr/2019	BHARATIYA JANATA PARTY	*******8244	691	3300196
00001201904120000001166	12/Apr/2019	12/Apr/2019	26/Apr/2019	A B C INDIA LIMITED	TL	11447	1000000	1	5899230	Paid	25/Apr/2019	BHARATIYA JANATA PARTY	*******8244	691	3300196
00001201904120000001166	12/Apr/2019	12/Apr/2019	26/Apr/2019	A B C INDIA LIMITED	TL	11441	1000000	1	5899230	Paid	25/Apr/2019	BHARATIYA JANATA PARTY	*******8244	691	3300196
00001201904120000001166	12/Apr/2019	12/Apr/2019	26/Apr/2019	A B C INDIA LIMITED	OL	1113	100000	1	5899230	Paid	25/Apr/2019	BHARATIYA JANATA PARTY	*******8244	691	3300196
00001201904120000001166	12/Apr/2019	12/Apr/2019	26/Apr/2019	A B C INDIA LIMITED	OL	1118	100000	1	5899230	Paid	25/Apr/2019	BHARATIYA JANATA PARTY	*******8244	691	3300196
00001201904120000001166	12/Apr/2019	12/Apr/2019	26/Apr/2019	A B C INDIA LIMITED	OL	1112	100000	1	5899230	Paid	25/Apr/2019	BHARATIYA JANATA PARTY	*******8244	691	3300196
00001201904120000001166	12/Apr/2019	12/Apr/2019	26/Apr/2019	A B C INDIA LIMITED	OL	1115	100000	1	5899230	Paid	25/Apr/2019	BHARATIYA JANATA PARTY	*******8244	691	3300196
00001201904120000001166	12/Apr/2019	12/Apr/2019	26/Apr/2019	A B C INDIA LIMITED	OL	1119	100000	1	5899230	Paid	25/Apr/2019	BHARATIYA JANATA PARTY	*******8244	691	3300196
00001201904120000001166	12/Apr/2019	12/Apr/2019	26/Apr/2019	A B C INDIA LIMITED	OL	1110	100000	1	5899230	Paid	25/Apr/2019	BHARATIYA JANATA PARTY	*******8244	691	3300196
00001201904120000001166	12/Apr/2019	12/Apr/2019	26/Apr/2019	A B C INDIA LIMITED	OL	1111	100000	1	5899230	Paid	25/Apr/2019	BHARATIYA JANATA PARTY	*******8244	691	3300196


CREATE TABLE electoral_bonds_clean (
  "reference_no_urn" VARCHAR,
  "journal_date" VARCHAR,
  "purchase_date" VARCHAR,
  "expiry_date" VARCHAR,
  "purchaser_name" VARCHAR,
  "prefix" VARCHAR,
  "bond_number" BIGINT,
  "denominations" BIGINT,
  "issue_branch_code" BIGINT,
  "issue_teller" BIGINT,
  "status" VARCHAR,
  "date_of_encashment" VARCHAR,
  "political_party" VARCHAR,
  "political_party_account_no" VARCHAR,
  "pay_branch_code" BIGINT,
  "pay_teller" BIGINT
);