Skip to content

Instantly share code, notes, and snippets.

@JT5D

JT5D/csvtojson.py

Forked from bradmontgomery/csvtojson.py
Created November 3, 2013 23:47
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save JT5D/7296115 to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save JT5D/7296115 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
csvtojson.py
"""
Read a CSV file and save it as a JSON file. Based on
http://stackoverflow.com/questions/12951337/csv-file-to-json-file-in-python
The `data.csv`, here is a sample file from:
http://www.ferc.gov/docs-filing/eqr/soft-tools/sample-csv/contract.txt
"""
import csv
import json
from sys import argv
def csv_to_json(path_to_csv_file):
"""Reads a CSV file and returns a JSON string"""
with open(path_to_csv_file, 'rb') as csvfile:
reader = csv.DictReader(csvfile)
return json.dumps([row for row in reader], indent=4)
if __name__ == "__main__":
"""If run as a command-line program, reads a specified CSV file and
writes to a specified JSON file.
Usage::
python csvtojson.py <input_csv> <output_json>
"""
if len(argv) != 3:
print("\nUSAGE: csvtojson.py <path_to_csv> <path_to_json>\n")
else:
path_to_csv = argv[1]
path_to_json = argv[2]
with open(path_to_json, 'w') as json_file:
data = csv_to_json(path_to_csv)
json_file.write(data)
Raw
data.csv
contract_id seller_company_name customer_company_name customer_duns_number contract_affiliate FERC_tariff_reference contract_service_agreement_id contract_execution_date contract_commencement_date contract_termination_date actual_termination_date extension_provision_description class_name term_name increment_name increment_peaking_name product_type_name product_name quantity units_for_contract rate rate_minimum rate_maximum rate_description units_for_rate point_of_receipt_control_area point_of_receipt_specific_location point_of_delivery_control_area point_of_delivery_specific_location begin_date end_date time_zone
C71 The Electric Company The Power Company 456543333 N FERC Electric Tariff Original Volume No. 10 2 2/15/2001 2/15/2001 Evergreen N/A N/A N/A N/A MB ENERGY 0 Market Based ES
C72 The Electric Company Utility A 38495837 n FERC Electric Tariff Original Volume No. 10 15 7/25/2001 8/1/2001 Evergreen N/A N/A N/A N/A MB ENERGY 0 Market Based ES
C73 The Electric Company Utility B 493758794 N FERC Electric Tariff Original Volume No. 10 7 6/8/2001 7/6/2001 Evergreen N/A N/A N/A N/A MB ENERGY 0 Market Based ep
C74 The Electric Company Utility C 594739573 n FERC Electric Tariff Original Volume No. 10 25 6/8/2001 7/6/2001 Evergreen N/A N/A N/A N/A MB ENERGY 0 Market Based ep
C75 The Electric Company The Power Company 456543333 N FERC Electric Tariff Third Revised Volume No. 7 94 2/13/2001 7/1/2001 12/31/2006 None F LT M P T ENERGY 2000 KWh .1475 Max amount of capacity and energy to be transmitted. Bill based on monthly max delivery to City. $/KWh PJM Point A PJM Point B ep
C75 The Electric Company The Power Company 456543333 N FERC Electric Tariff Third Revised Volume No. 7 94 2/13/2001 7/1/2001 12/31/2006 None F LT M P T point-to-point agreement 2000 KW 0.01 $/kw-mo PJM Point A PJM Point B ep
C75 The Electric Company The Power Company 456543333 N FERC Electric Tariff Third Revised Volume No. 7 94 2/13/2001 7/1/2001 12/31/2006 None F LT M P T network 2000 KW 0.2 $/kw-mo PJM Point A PJM Point B ep
C75 The Electric Company The Power Company 456543333 N FERC Electric Tariff Third Revised Volume No. 7 94 2/13/2001 7/1/2001 12/31/2006 None F LT M P T BLACK START SERVICE 2000 KW 0.22 $/kw-mo PJM Point A PJM Point B ep
C75 The Electric Company The Power Company 456543333 N FERC Electric Tariff Third Revised Volume No. 7 94 2/13/2001 7/1/2001 12/31/2006 None F LT M P T CAPACITY 2000 KW 0.04 $/kw-mo PJM Point A PJM Point B ep
C75 The Electric Company The Power Company 456543333 N FERC Electric Tariff Third Revised Volume No. 7 94 2/13/2001 7/1/2001 12/31/2006 None F LT M P T regulation & frequency response 2000 KW 0.1 $/kw-mo PJM Point A PJM Point B ep
C75 The Electric Company The Power Company 456543333 N FERC Electric Tariff Third Revised Volume No. 7 94 2/13/2001 7/1/2001 12/31/2006 None F LT M P T real power transmission loss 2000 KW 7 $/kw-mo PJM Point A PJM Point B ep
C76 The Electric Company The Power Company 456534333 N FERC Electric Tariff Original Volume No. 10 132 12/15/2001 1/1/2002 12/31/2004 12/31/2004 None F LT M FP MB CAPACITY 70 MW 3750 70MW for each and every hour over the term of the agreement (7x24 schedule). $/MW ep
C78 The Electric Company The Electric Marketing Co., LLC 23456789 Y FERC Electric Tariff Original Volume No. 2 Service Agreement 1 1/2/1992 1/2/1992 1/1/2012 Renewable annually by mutual agreement after termination date. UP LT Y FP CB ENERGY 0 MWH 35 $/MWH PJM Bus 4321 20020101 20030101 EP
C78 The Electric Company The Electric Marketing Co., LLC 23456789 Y FERC Electric Tariff Original Volume No. 2 Service Agreement 1 1/2/1992 1/2/1992 1/1/2012 Renewable annually by mutual agreement after termination date. UP LT Y FP CB ENERGY 0 MWH 37 $/MWH PJM Bus 4321 20030101 20040101 EP
C78 The Electric Company The Electric Marketing Co., LLC 23456789 Y FERC Electric Tariff Original Volume No. 2 Service Agreement 1 1/2/1992 1/2/1992 1/1/2012 Renewable annually by mutual agreement after termination date. UP LT Y FP CB ENERGY 0 MWH 39 $/MWH PJM Bus 4321 20040101 20050101 EP
C78 The Electric Company The Electric Marketing Co., LLC 23456789 Y FERC Electric Tariff Original Volume No. 2 Service Agreement 1 1/2/1992 1/2/1992 1/1/2012 Renewable annually by mutual agreement after termination date. UP LT Y FP CB ENERGY 0 MWH 41 $/MWH PJM Bus 4321 20050101 20060101 EP
C78 The Electric Company The Electric Marketing Co., LLC 23456789 Y FERC Electric Tariff Original Volume No. 2 Service Agreement 1 1/2/1992 1/2/1992 1/1/2012 Renewable annually by mutual agreement after termination date. UP LT Y FP CB ENERGY 0 MWH 43 $/MWH PJM Bus 4321 20060101 20070101 EP
C78 The Electric Company The Electric Marketing Co., LLC 23456789 Y FERC Electric Tariff Original Volume No. 2 Service Agreement 1 1/2/1992 1/2/1992 1/1/2012 Renewable annually by mutual agreement after termination date. UP LT Y FP CB ENERGY 0 MWH 45 $/MWH PJM Bus 4321 20070101 20080101 EP
C78 The Electric Company The Electric Marketing Co., LLC 23456789 Y FERC Electric Tariff Original Volume No. 2 Service Agreement 1 1/2/1992 1/2/1992 1/1/2012 Renewable annually by mutual agreement after termination date. UP LT Y FP CB ENERGY 0 MWH 47 $/MWH PJM Bus 4321 20080101 20090101 EP
C78 The Electric Company The Electric Marketing Co., LLC 23456789 Y FERC Electric Tariff Original Volume No. 2 Service Agreement 1 1/2/1992 1/2/1992 1/1/2012 Renewable annually by mutual agreement after termination date. UP LT Y FP CB ENERGY 0 MWH 49 $/MWH PJM Bus 4321 20090101 20100101 EP
C78 The Electric Company The Electric Marketing Co., LLC 23456789 Y FERC Electric Tariff Original Volume No. 2 Service Agreement 1 1/2/1992 1/2/1992 1/1/2012 Renewable annually by mutual agreement after termination date. UP LT Y FP CB ENERGY 0 MWH 51 $/MWH PJM Bus 4321 20100101 20110101 EP
C78 The Electric Company The Electric Marketing Co., LLC 23456789 Y FERC Electric Tariff Original Volume No. 2 Service Agreement 1 1/2/1992 1/2/1992 1/1/2012 Renewable annually by mutual agreement after termination date. UP LT Y FP CB ENERGY 0 MWH 53 $/MWH PJM Bus 4321 20110101 20120101 EP
Raw
data.json
[
{
"product_type_name": "MB",
"class_name": "N/A",
"point_of_receipt_control_area": "",
"rate": " ",
"FERC_tariff_reference": "FERC Electric Tariff Original Volume No. 10",
"point_of_receipt_specific_location": "",
"point_of_delivery_control_area": "",
"units_for_rate": "",
"customer_company_name": "The Power Company",
"begin_date": "",
"contract_id": "C71",
"rate_description": "Market Based",
"contract_execution_date": "2/15/2001",
"contract_termination_date": "",
"contract_service_agreement_id": "2",
"extension_provision_description": "Evergreen",
"product_name": "ENERGY",
"term_name": "N/A",
"end_date": "",
"rate_maximum": " ",
"units_for_contract": "",
"actual_termination_date": "",
"customer_duns_number": "456543333",
"contract_affiliate": "N",
"contract_commencement_date": "2/15/2001",
"increment_name": "N/A",
"seller_company_name": "The Electric Company",
"increment_peaking_name": "N/A",
"time_zone": "ES",
"rate_minimum": " ",
"point_of_delivery_specific_location": "",
"quantity": "0"
},
{
"product_type_name": "MB",
"class_name": "N/A",
"point_of_receipt_control_area": "",
"rate": " ",
"FERC_tariff_reference": "FERC Electric Tariff Original Volume No. 10",
"point_of_receipt_specific_location": "",
"point_of_delivery_control_area": "",
"units_for_rate": "",
"customer_company_name": "Utility A",
"begin_date": "",
"contract_id": "C72",
"rate_description": "Market Based",
"contract_execution_date": "7/25/2001",
"contract_termination_date": "",
"contract_service_agreement_id": "15",
"extension_provision_description": "Evergreen",
"product_name": "ENERGY",
"term_name": "N/A",
"end_date": "",
"rate_maximum": " ",
"units_for_contract": "",
"actual_termination_date": "",
"customer_duns_number": "38495837",
"contract_affiliate": "n",
"contract_commencement_date": "8/1/2001",
"increment_name": "N/A",
"seller_company_name": "The Electric Company",
"increment_peaking_name": "N/A",
"time_zone": "ES",
"rate_minimum": " ",
"point_of_delivery_specific_location": "",
"quantity": "0"
},
{
"product_type_name": "MB",
"class_name": "N/A",
"point_of_receipt_control_area": "",
"rate": " ",
"FERC_tariff_reference": "FERC Electric Tariff Original Volume No. 10",
"point_of_receipt_specific_location": "",
"point_of_delivery_control_area": " ",
"units_for_rate": "",
"customer_company_name": "Utility B",
"begin_date": "",
"contract_id": "C73",
"rate_description": "Market Based",
"contract_execution_date": "6/8/2001",
"contract_termination_date": "",
"contract_service_agreement_id": "7",
"extension_provision_description": "Evergreen",
"product_name": "ENERGY",
"term_name": "N/A",
"end_date": "",
"rate_maximum": " ",
"units_for_contract": "",
"actual_termination_date": "",
"customer_duns_number": "493758794",
"contract_affiliate": "N",
"contract_commencement_date": "7/6/2001",
"increment_name": "N/A",
"seller_company_name": "The Electric Company",
"increment_peaking_name": "N/A",
"time_zone": "ep",
"rate_minimum": " ",
"point_of_delivery_specific_location": " ",
"quantity": "0"
},
{
"product_type_name": "MB",
"class_name": "N/A",
"point_of_receipt_control_area": "",
"rate": " ",
"FERC_tariff_reference": "FERC Electric Tariff Original Volume No. 10",
"point_of_receipt_specific_location": "",
"point_of_delivery_control_area": " ",
"units_for_rate": "",
"customer_company_name": "Utility C",
"begin_date": "",
"contract_id": "C74",
"rate_description": "Market Based",
"contract_execution_date": "6/8/2001",
"contract_termination_date": "",
"contract_service_agreement_id": "25",
"extension_provision_description": "Evergreen",
"product_name": "ENERGY",
"term_name": "N/A",
"end_date": "",
"rate_maximum": " ",
"units_for_contract": "",
"actual_termination_date": "",
"customer_duns_number": "594739573",
"contract_affiliate": "n",
"contract_commencement_date": "7/6/2001",
"increment_name": "N/A",
"seller_company_name": "The Electric Company",
"increment_peaking_name": "N/A",
"time_zone": "ep",
"rate_minimum": " ",
"point_of_delivery_specific_location": " ",
"quantity": "0"
},
{
"product_type_name": "T",
"class_name": "F",
"point_of_receipt_control_area": "PJM",
"rate": ".1475",
"FERC_tariff_reference": "FERC Electric Tariff Third Revised Volume No. 7",
"point_of_receipt_specific_location": "Point A",
"point_of_delivery_control_area": "PJM",
"units_for_rate": "$/KWh",
"customer_company_name": "The Power Company",
"begin_date": "",
"contract_id": "C75",
"rate_description": "Max amount of capacity and energy to be transmitted. Bill based on monthly max delivery to City.",
"contract_execution_date": "2/13/2001",
"contract_termination_date": "12/31/2006",
"contract_service_agreement_id": "94",
"extension_provision_description": "None",
"product_name": "ENERGY",
"term_name": "LT",
"end_date": "",
"rate_maximum": " ",
"units_for_contract": "KWh",
"actual_termination_date": "",
"customer_duns_number": "456543333",
"contract_affiliate": "N",
"contract_commencement_date": "7/1/2001",
"increment_name": "M",
"seller_company_name": "The Electric Company",
"increment_peaking_name": "P",
"time_zone": "ep",
"rate_minimum": " ",
"point_of_delivery_specific_location": "Point B",
"quantity": "2000"
},
{
"product_type_name": "T",
"class_name": "F",
"point_of_receipt_control_area": "PJM",
"rate": "0.01",
"FERC_tariff_reference": "FERC Electric Tariff Third Revised Volume No. 7",
"point_of_receipt_specific_location": "Point A",
"point_of_delivery_control_area": "PJM",
"units_for_rate": "$/kw-mo",
"customer_company_name": "The Power Company",
"begin_date": "",
"contract_id": "C75",
"rate_description": "",
"contract_execution_date": "2/13/2001",
"contract_termination_date": "12/31/2006",
"contract_service_agreement_id": "94",
"extension_provision_description": "None",
"product_name": "point-to-point agreement",
"term_name": "LT",
"end_date": "",
"rate_maximum": " ",
"units_for_contract": "KW",
"actual_termination_date": "",
"customer_duns_number": "456543333",
"contract_affiliate": "N",
"contract_commencement_date": "7/1/2001",
"increment_name": "M",
"seller_company_name": "The Electric Company",
"increment_peaking_name": "P",
"time_zone": "ep",
"rate_minimum": " ",
"point_of_delivery_specific_location": "Point B",
"quantity": "2000"
},
{
"product_type_name": "T",
"class_name": "F",
"point_of_receipt_control_area": "PJM",
"rate": "0.2",
"FERC_tariff_reference": "FERC Electric Tariff Third Revised Volume No. 7",
"point_of_receipt_specific_location": "Point A",
"point_of_delivery_control_area": "PJM",
"units_for_rate": "$/kw-mo",
"customer_company_name": "The Power Company",
"begin_date": "",
"contract_id": "C75",
"rate_description": "",
"contract_execution_date": "2/13/2001",
"contract_termination_date": "12/31/2006",
"contract_service_agreement_id": "94",
"extension_provision_description": "None",
"product_name": "network",
"term_name": "LT",
"end_date": "",
"rate_maximum": " ",
"units_for_contract": "KW",
"actual_termination_date": "",
"customer_duns_number": "456543333",
"contract_affiliate": "N",
"contract_commencement_date": "7/1/2001",
"increment_name": "M",
"seller_company_name": "The Electric Company",
"increment_peaking_name": "P",
"time_zone": "ep",
"rate_minimum": " ",
"point_of_delivery_specific_location": "Point B",
"quantity": "2000"
},
{
"product_type_name": "T",
"class_name": "F",
"point_of_receipt_control_area": "PJM",
"rate": "0.22",
"FERC_tariff_reference": "FERC Electric Tariff Third Revised Volume No. 7",
"point_of_receipt_specific_location": "Point A",
"point_of_delivery_control_area": "PJM",
"units_for_rate": "$/kw-mo",
"customer_company_name": "The Power Company",
"begin_date": "",
"contract_id": "C75",
"rate_description": "",
"contract_execution_date": "2/13/2001",
"contract_termination_date": "12/31/2006",
"contract_service_agreement_id": "94",
"extension_provision_description": "None",
"product_name": "BLACK START SERVICE",
"term_name": "LT",
"end_date": "",
"rate_maximum": " ",
"units_for_contract": "KW",
"actual_termination_date": "",
"customer_duns_number": "456543333",
"contract_affiliate": "N",
"contract_commencement_date": "7/1/2001",
"increment_name": "M",
"seller_company_name": "The Electric Company",
"increment_peaking_name": "P",
"time_zone": "ep",
"rate_minimum": " ",
"point_of_delivery_specific_location": "Point B",
"quantity": "2000"
},
{
"product_type_name": "T",
"class_name": "F",
"point_of_receipt_control_area": "PJM",
"rate": "0.04",
"FERC_tariff_reference": "FERC Electric Tariff Third Revised Volume No. 7",
"point_of_receipt_specific_location": "Point A",
"point_of_delivery_control_area": "PJM",
"units_for_rate": "$/kw-mo",
"customer_company_name": "The Power Company",
"begin_date": "",
"contract_id": "C75",
"rate_description": "",
"contract_execution_date": "2/13/2001",
"contract_termination_date": "12/31/2006",
"contract_service_agreement_id": "94",
"extension_provision_description": "None",
"product_name": "CAPACITY",
"term_name": "LT",
"end_date": "",
"rate_maximum": " ",
"units_for_contract": "KW",
"actual_termination_date": "",
"customer_duns_number": "456543333",
"contract_affiliate": "N",
"contract_commencement_date": "7/1/2001",
"increment_name": "M",
"seller_company_name": "The Electric Company",
"increment_peaking_name": "P",
"time_zone": "ep",
"rate_minimum": " ",
"point_of_delivery_specific_location": "Point B",
"quantity": "2000"
},
{
"product_type_name": "T",
"class_name": "F",
"point_of_receipt_control_area": "PJM",
"rate": "0.1",
"FERC_tariff_reference": "FERC Electric Tariff Third Revised Volume No. 7",
"point_of_receipt_specific_location": "Point A",
"point_of_delivery_control_area": "PJM",
"units_for_rate": "$/kw-mo",
"customer_company_name": "The Power Company",
"begin_date": "",
"contract_id": "C75",
"rate_description": "",
"contract_execution_date": "2/13/2001",
"contract_termination_date": "12/31/2006",
"contract_service_agreement_id": "94",
"extension_provision_description": "None",
"product_name": "regulation & frequency response",
"term_name": "LT",
"end_date": "",
"rate_maximum": " ",
"units_for_contract": "KW",
"actual_termination_date": "",
"customer_duns_number": "456543333",
"contract_affiliate": "N",
"contract_commencement_date": "7/1/2001",
"increment_name": "M",
"seller_company_name": "The Electric Company",
"increment_peaking_name": "P",
"time_zone": "ep",
"rate_minimum": " ",
"point_of_delivery_specific_location": "Point B",
"quantity": "2000"
},
{
"product_type_name": "T",
"class_name": "F",
"point_of_receipt_control_area": "PJM",
"rate": "7",
"FERC_tariff_reference": "FERC Electric Tariff Third Revised Volume No. 7",
"point_of_receipt_specific_location": "Point A",
"point_of_delivery_control_area": "PJM",
"units_for_rate": "$/kw-mo",
"customer_company_name": "The Power Company",
"begin_date": "",
"contract_id": "C75",
"rate_description": "",
"contract_execution_date": "2/13/2001",
"contract_termination_date": "12/31/2006",
"contract_service_agreement_id": "94",
"extension_provision_description": "None",
"product_name": "real power transmission loss",
"term_name": "LT",
"end_date": "",
"rate_maximum": " ",
"units_for_contract": "KW",
"actual_termination_date": "",
"customer_duns_number": "456543333",
"contract_affiliate": "N",
"contract_commencement_date": "7/1/2001",
"increment_name": "M",
"seller_company_name": "The Electric Company",
"increment_peaking_name": "P",
"time_zone": "ep",
"rate_minimum": " ",
"point_of_delivery_specific_location": "Point B",
"quantity": "2000"
},
{
"product_type_name": "MB",
"class_name": "F",
"point_of_receipt_control_area": "",
"rate": "3750",
"FERC_tariff_reference": "FERC Electric Tariff Original Volume No. 10",
"point_of_receipt_specific_location": "",
"point_of_delivery_control_area": "",
"units_for_rate": "$/MW",
"customer_company_name": "The Power Company",
"begin_date": "",
"contract_id": "C76",
"rate_description": "70MW for each and every hour over the term of the agreement (7x24 schedule).",
"contract_execution_date": "12/15/2001",
"contract_termination_date": "12/31/2004",
"contract_service_agreement_id": "132",
"extension_provision_description": "None",
"product_name": "CAPACITY",
"term_name": "LT",
"end_date": "",
"rate_maximum": " ",
"units_for_contract": "MW",
"actual_termination_date": "12/31/2004",
"customer_duns_number": "456534333",
"contract_affiliate": "N",
"contract_commencement_date": "1/1/2002",
"increment_name": "M",
"seller_company_name": "The Electric Company",
"increment_peaking_name": "FP",
"time_zone": "ep",
"rate_minimum": " ",
"point_of_delivery_specific_location": "",
"quantity": "70"
},
{
"product_type_name": "CB",
"class_name": "UP",
"point_of_receipt_control_area": "",
"rate": "35",
"FERC_tariff_reference": "FERC Electric Tariff Original Volume No. 2",
"point_of_receipt_specific_location": "",
"point_of_delivery_control_area": "PJM",
"units_for_rate": "$/MWH",
"customer_company_name": "The Electric Marketing Co., LLC",
"begin_date": "20020101",
"contract_id": "C78",
"rate_description": "",
"contract_execution_date": "1/2/1992",
"contract_termination_date": "1/1/2012",
"contract_service_agreement_id": "Service Agreement 1",
"extension_provision_description": "Renewable annually by mutual agreement after termination date.",
"product_name": "ENERGY",
"term_name": "LT",
"end_date": "20030101",
"rate_maximum": " ",
"units_for_contract": "MWH",
"actual_termination_date": "",
"customer_duns_number": "23456789",
"contract_affiliate": "Y",
"contract_commencement_date": "1/2/1992",
"increment_name": "Y",
"seller_company_name": "The Electric Company",
"increment_peaking_name": "FP",
"time_zone": "EP",
"rate_minimum": " ",
"point_of_delivery_specific_location": "Bus 4321",
"quantity": "0"
},
{
"product_type_name": "CB",
"class_name": "UP",
"point_of_receipt_control_area": "",
"rate": "37",
"FERC_tariff_reference": "FERC Electric Tariff Original Volume No. 2",
"point_of_receipt_specific_location": "",
"point_of_delivery_control_area": "PJM",
"units_for_rate": "$/MWH",
"customer_company_name": "The Electric Marketing Co., LLC",
"begin_date": "20030101",
"contract_id": "C78",
"rate_description": "",
"contract_execution_date": "1/2/1992",
"contract_termination_date": "1/1/2012",
"contract_service_agreement_id": "Service Agreement 1",
"extension_provision_description": "Renewable annually by mutual agreement after termination date.",
"product_name": "ENERGY",
"term_name": "LT",
"end_date": "20040101",
"rate_maximum": " ",
"units_for_contract": "MWH",
"actual_termination_date": "",
"customer_duns_number": "23456789",
"contract_affiliate": "Y",
"contract_commencement_date": "1/2/1992",
"increment_name": "Y",
"seller_company_name": "The Electric Company",
"increment_peaking_name": "FP",
"time_zone": "EP",
"rate_minimum": " ",
"point_of_delivery_specific_location": "Bus 4321",
"quantity": "0"
},
{
"product_type_name": "CB",
"class_name": "UP",
"point_of_receipt_control_area": "",
"rate": "39",
"FERC_tariff_reference": "FERC Electric Tariff Original Volume No. 2",
"point_of_receipt_specific_location": "",
"point_of_delivery_control_area": "PJM",
"units_for_rate": "$/MWH",
"customer_company_name": "The Electric Marketing Co., LLC",
"begin_date": "20040101",
"contract_id": "C78",
"rate_description": "",
"contract_execution_date": "1/2/1992",
"contract_termination_date": "1/1/2012",
"contract_service_agreement_id": "Service Agreement 1",
"extension_provision_description": "Renewable annually by mutual agreement after termination date.",
"product_name": "ENERGY",
"term_name": "LT",
"end_date": "20050101",
"rate_maximum": " ",
"units_for_contract": "MWH",
"actual_termination_date": "",
"customer_duns_number": "23456789",
"contract_affiliate": "Y",
"contract_commencement_date": "1/2/1992",
"increment_name": "Y",
"seller_company_name": "The Electric Company",
"increment_peaking_name": "FP",
"time_zone": "EP",
"rate_minimum": " ",
"point_of_delivery_specific_location": "Bus 4321",
"quantity": "0"
},
{
"product_type_name": "CB",
"class_name": "UP",
"point_of_receipt_control_area": "",
"rate": "41",
"FERC_tariff_reference": "FERC Electric Tariff Original Volume No. 2",
"point_of_receipt_specific_location": "",
"point_of_delivery_control_area": "PJM",
"units_for_rate": "$/MWH",
"customer_company_name": "The Electric Marketing Co., LLC",
"begin_date": "20050101",
"contract_id": "C78",
"rate_description": "",
"contract_execution_date": "1/2/1992",
"contract_termination_date": "1/1/2012",
"contract_service_agreement_id": "Service Agreement 1",
"extension_provision_description": "Renewable annually by mutual agreement after termination date.",
"product_name": "ENERGY",
"term_name": "LT",
"end_date": "20060101",
"rate_maximum": " ",
"units_for_contract": "MWH",
"actual_termination_date": "",
"customer_duns_number": "23456789",
"contract_affiliate": "Y",
"contract_commencement_date": "1/2/1992",
"increment_name": "Y",
"seller_company_name": "The Electric Company",
"increment_peaking_name": "FP",
"time_zone": "EP",
"rate_minimum": " ",
"point_of_delivery_specific_location": "Bus 4321",
"quantity": "0"
},
{
"product_type_name": "CB",
"class_name": "UP",
"point_of_receipt_control_area": "",
"rate": "43",
"FERC_tariff_reference": "FERC Electric Tariff Original Volume No. 2",
"point_of_receipt_specific_location": "",
"point_of_delivery_control_area": "PJM",
"units_for_rate": "$/MWH",
"customer_company_name": "The Electric Marketing Co., LLC",
"begin_date": "20060101",
"contract_id": "C78",
"rate_description": "",
"contract_execution_date": "1/2/1992",
"contract_termination_date": "1/1/2012",
"contract_service_agreement_id": "Service Agreement 1",
"extension_provision_description": "Renewable annually by mutual agreement after termination date.",
"product_name": "ENERGY",
"term_name": "LT",
"end_date": "20070101",
"rate_maximum": " ",
"units_for_contract": "MWH",
"actual_termination_date": "",
"customer_duns_number": "23456789",
"contract_affiliate": "Y",
"contract_commencement_date": "1/2/1992",
"increment_name": "Y",
"seller_company_name": "The Electric Company",
"increment_peaking_name": "FP",
"time_zone": "EP",
"rate_minimum": " ",
"point_of_delivery_specific_location": "Bus 4321",
"quantity": "0"
},
{
"product_type_name": "CB",
"class_name": "UP",
"point_of_receipt_control_area": "",
"rate": "45",
"FERC_tariff_reference": "FERC Electric Tariff Original Volume No. 2",
"point_of_receipt_specific_location": "",
"point_of_delivery_control_area": "PJM",
"units_for_rate": "$/MWH",
"customer_company_name": "The Electric Marketing Co., LLC",
"begin_date": "20070101",
"contract_id": "C78",
"rate_description": "",
"contract_execution_date": "1/2/1992",
"contract_termination_date": "1/1/2012",
"contract_service_agreement_id": "Service Agreement 1",
"extension_provision_description": "Renewable annually by mutual agreement after termination date.",
"product_name": "ENERGY",
"term_name": "LT",
"end_date": "20080101",
"rate_maximum": " ",
"units_for_contract": "MWH",
"actual_termination_date": "",
"customer_duns_number": "23456789",
"contract_affiliate": "Y",
"contract_commencement_date": "1/2/1992",
"increment_name": "Y",
"seller_company_name": "The Electric Company",
"increment_peaking_name": "FP",
"time_zone": "EP",
"rate_minimum": " ",
"point_of_delivery_specific_location": "Bus 4321",
"quantity": "0"
},
{
"product_type_name": "CB",
"class_name": "UP",
"point_of_receipt_control_area": "",
"rate": "47",
"FERC_tariff_reference": "FERC Electric Tariff Original Volume No. 2",
"point_of_receipt_specific_location": "",
"point_of_delivery_control_area": "PJM",
"units_for_rate": "$/MWH",
"customer_company_name": "The Electric Marketing Co., LLC",
"begin_date": "20080101",
"contract_id": "C78",
"rate_description": "",
"contract_execution_date": "1/2/1992",
"contract_termination_date": "1/1/2012",
"contract_service_agreement_id": "Service Agreement 1",
"extension_provision_description": "Renewable annually by mutual agreement after termination date.",
"product_name": "ENERGY",
"term_name": "LT",
"end_date": "20090101",
"rate_maximum": " ",
"units_for_contract": "MWH",
"actual_termination_date": "",
"customer_duns_number": "23456789",
"contract_affiliate": "Y",
"contract_commencement_date": "1/2/1992",
"increment_name": "Y",
"seller_company_name": "The Electric Company",
"increment_peaking_name": "FP",
"time_zone": "EP",
"rate_minimum": " ",
"point_of_delivery_specific_location": "Bus 4321",
"quantity": "0"
},
{
"product_type_name": "CB",
"class_name": "UP",
"point_of_receipt_control_area": "",
"rate": "49",
"FERC_tariff_reference": "FERC Electric Tariff Original Volume No. 2",
"point_of_receipt_specific_location": "",
"point_of_delivery_control_area": "PJM",
"units_for_rate": "$/MWH",
"customer_company_name": "The Electric Marketing Co., LLC",
"begin_date": "20090101",
"contract_id": "C78",
"rate_description": "",
"contract_execution_date": "1/2/1992",
"contract_termination_date": "1/1/2012",
"contract_service_agreement_id": "Service Agreement 1",
"extension_provision_description": "Renewable annually by mutual agreement after termination date.",
"product_name": "ENERGY",
"term_name": "LT",
"end_date": "20100101",
"rate_maximum": " ",
"units_for_contract": "MWH",
"actual_termination_date": "",
"customer_duns_number": "23456789",
"contract_affiliate": "Y",
"contract_commencement_date": "1/2/1992",
"increment_name": "Y",
"seller_company_name": "The Electric Company",
"increment_peaking_name": "FP",
"time_zone": "EP",
"rate_minimum": " ",
"point_of_delivery_specific_location": "Bus 4321",
"quantity": "0"
},
{
"product_type_name": "CB",
"class_name": "UP",
"point_of_receipt_control_area": "",
"rate": "51",
"FERC_tariff_reference": "FERC Electric Tariff Original Volume No. 2",
"point_of_receipt_specific_location": "",
"point_of_delivery_control_area": "PJM",
"units_for_rate": "$/MWH",
"customer_company_name": "The Electric Marketing Co., LLC",
"begin_date": "20100101",
"contract_id": "C78",
"rate_description": "",
"contract_execution_date": "1/2/1992",
"contract_termination_date": "1/1/2012",
"contract_service_agreement_id": "Service Agreement 1",
"extension_provision_description": "Renewable annually by mutual agreement after termination date.",
"product_name": "ENERGY",
"term_name": "LT",
"end_date": "20110101",
"rate_maximum": " ",
"units_for_contract": "MWH",
"actual_termination_date": "",
"customer_duns_number": "23456789",
"contract_affiliate": "Y",
"contract_commencement_date": "1/2/1992",
"increment_name": "Y",
"seller_company_name": "The Electric Company",
"increment_peaking_name": "FP",
"time_zone": "EP",
"rate_minimum": " ",
"point_of_delivery_specific_location": "Bus 4321",
"quantity": "0"
},
{
"product_type_name": "CB",
"class_name": "UP",
"point_of_receipt_control_area": "",
"rate": "53",
"FERC_tariff_reference": "FERC Electric Tariff Original Volume No. 2",
"point_of_receipt_specific_location": "",
"point_of_delivery_control_area": "PJM",
"units_for_rate": "$/MWH",
"customer_company_name": "The Electric Marketing Co., LLC",
"begin_date": "20110101",
"contract_id": "C78",
"rate_description": "",
"contract_execution_date": "1/2/1992",
"contract_termination_date": "1/1/2012",
"contract_service_agreement_id": "Service Agreement 1",
"extension_provision_description": "Renewable annually by mutual agreement after termination date.",
"product_name": "ENERGY",
"term_name": "LT",
"end_date": "20120101",
"rate_maximum": " ",
"units_for_contract": "MWH",
"actual_termination_date": "",
"customer_duns_number": "23456789",
"contract_affiliate": "Y",
"contract_commencement_date": "1/2/1992",
"increment_name": "Y",
"seller_company_name": "The Electric Company",
"increment_peaking_name": "FP",
"time_zone": "EP",
"rate_minimum": " ",
"point_of_delivery_specific_location": "Bus 4321",
"quantity": "0"
}
]
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment