Skip to content

Instantly share code, notes, and snippets.

Date Last Researched,Research Status,Researcher,Country,Project Name,Capacity (MW),Capacity [ref],Capacity Rating,Capacity Rating [ref],Technology Type,Technology Type [ref],Status,Status [ref],Start year,Start year [ref],Operator IDs,Operator [ref],Latitude,Longitude,Location accuracy,Coordinates [ref],"Local area (taluk, county)","Major area (prefecture, district)",State/Province,GEM location ID,GEM phase ID,Other IDs (unit/phase)
2024-01-19,updated,Diren Kocakusak,United Kingdom,Abbey Fields solar farm,5.3,UKGovOct2023,unknown,,PV,https://www.gov.uk/government/publications/renewable-energy-planning-database-monthly-extract,operating,UKGovOct2023,2016,UKGovOct2023,,,51.3187,0.9029,exact,UKGovOct2023,Kent,South East,England,L100000825018,G100000828297,REPD: 5394
2024-01-19,no changes,Diren Kocakusak,United Kingdom,Abbey solar farm,9,UKGovOct2023,unknown,,PV,https://www.gov.uk/government/publications/renewable-energy-planning-database-monthly-extract,operating,UKGovOct2023,2014,UKGovOct2023,,,52.4193,-0.2366,
[
{
"id": 1,
"developer": [
{"name":"deva"}
],
"platforms": [
{"name":"PC"}
],
"rating": {
id title
1 game1_add_resource
2 game2_add_resource
{
"@generated-datetime": "2014-09-10T07:15:37Z",
"@version": "2.02",
"@linked-data-default": "http://data.example.org/",
"iati-activity": [
{
"@{http://www.w3.org/XML/1998/namespace}lang": "en",
"@default-currency": "USD",
"@last-updated-datetime": "2014-09-10T07:15:37Z",
"@humanitarian": true,
{
"responseHeader": {
"status": 0,
"QTime": 3
},
"response": {
"numFound": 1205,
"start": 0,
"numFoundExact": true,
"docs": [
{"title": "title from file",
"properties": {"prop1": {"title": "sub property title in base.json"},
"prop2": {"$ref": "#/properties/prop1"},
"prop3": {"$ref": "other.json"},
"prop4": {"$ref": "other.json#/properties/prop1"},
"prop5": {"$ref": "other.json#/properties/prop2"}
}
}
@kindly
kindly / test.json
Last active November 3, 2021 10:34
{"title": "title from url"}
import jsonlines
import flatterer
from pathlib import Path
import subprocess
def flatten_iterator(statement_type):
with jsonlines.open('statements.2021-08-31T08 14 34Z.jsonl') as f:
for object in f:
if object["statementType"] == statement_type:
yield object
##############################################################################
#
# Simple Python program to benchmark several Python Excel writing modules.
#
# python bench_excel_writers.py [num_rows] [num_cols]
#
# Copyright 2013-2018, John McNamara, Charlie Clark
#
import os
import sys
@kindly
kindly / csv_to_schema.py
Created May 18, 2021 10:09
CSV to JSON Schema
import csv
import click
import json
import json_merge_patch
@click.command()
@click.argument("file")
@click.option("-s", "--schema")
def csv_to_schema(file, schema=None):