Electoral Bond Data Repository

This repository contains data and queries related to electoral bonds, including purchaser details and transaction information.

Data

The repository includes the following data files:

• purchasers.csv: CSV file containing details of electoral bond purchasers.
• parties.csv: CSV file containing details of political parties receiving electoral bonds.
• branches.csv: CSV file containing information about bank branches.

Data Fields

purchasers.csv

1. Sr No.: Serial number
2. Reference No (URN): Unique Reference Number
3. Journal Date: Date of journal
4. Date of Purchase: Date of bond purchase
5. Date of Expiry: Date of bond expiry
6. Name of the Purchaser: Name of the bond purchaser
7. Prefix: Prefix of the bond
8. Bond Number: Electoral bond number
9. Denominations: Denominations
10. Issue Branch Code: Branch code of issue
11. Issue Teller: Teller ID of issue
12. Status: Status of the bond

parties.csv

1. Sr No.: Serial number
2. Date of Encashment: Date of bond encashment
3. Name of the Political Party: Name of the political party receiving the bond
4. Account no. of Political Party: Account number of the political party
5. Prefix: Prefix of the bond
6. Bond Number: Electoral bond number
7. Denominations: Denominations
8. Pay Branch Code: Branch code of payment
9. Pay Teller: Teller ID of payment

branches.csv

1. IFSC: Indian Financial System Code
2. MICR: Magnetic Ink Character Recognition
3. BRANCH: Branch Name
4. ADDRESS: Branch Address
5. STATE: State
6. CONTACT: Contact Information
7. UPI: UPI Availability (True/False)
8. RTGS: RTGS Availability (True/False)
9. CITY: City
10. CENTRE: Centre
11. DISTRICT: District
12. NEFT: NEFT Availability (True/False)
13. IMPS: IMPS Availability (True/False)
14. SWIFT: SWIFT Code
15. ISO3166: ISO 3166 Code
16. BANK: Bank Name
17. BANKCODE: Bank Code

Queries

The repository includes SQL queries for retrieving and processing electoral bond data stored in the purchasers.csv and parties.csv files.

Query Files

• retrieve_purchaser_party_details.sql: SQL query to retrieve details of bond purchasers and the political parties receiving the bonds.

CSV Fiddle

Here's a CSV fiddle containing multiple queries on the electoral bond data: