Skip to content

Instantly share code, notes, and snippets.

@simonw

simonw/output.txt

Created August 24, 2021 23:56
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save simonw/719b6d1cbd8f0b535b2eba91329c4ae9 to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save simonw/719b6d1cbd8f0b535b2eba91329c4ae9 to your computer and use it in GitHub Desktop.
Download ZIP
Output of "sqlite-utils memory global_power_plant_database.csv --analyze"
Raw
output.txt
global_power_plant_database.country: (1/25)
Total rows: 33643
Null rows: 0
Blank rows: 0
Distinct values: 167
Most common:
8688: USA
4235: CHN
2603: GBR
2360: BRA
2155: FRA
1590: IND
1309: DEU
1159: CAN
829: ESP
545: RUS
Least common:
1: DJI
1: ESH
1: GNB
1: LCA
1: LSO
1: PSE
1: SUR
2: LBR
2: LUX
2: ZWE
global_power_plant_database.country_long: (2/25)
Total rows: 33643
Null rows: 0
Blank rows: 0
Distinct values: 167
Most common:
8688: United States of America
4235: China
2603: United Kingdom
2360: Brazil
2155: France
1590: India
1309: Germany
1159: Canada
829: Spain
545: Russia
Least common:
1: Djibouti
1: Guinea-Bissau
1: Lesotho
1: Palestine
1: Saint Lucia
1: Suriname
1: Western Sahara
2: Liberia
2: Luxembourg
2: Zimbabwe
global_power_plant_database.name: (3/25)
Total rows: 33643
Null rows: 0
Blank rows: 0
Distinct values: 33232
Most common:
6: Santo Antônio
5: São José
5: Santa Rosa
5: Santa Helena
5: Funil
4: São Pedro
4: São Domingos
4: Santa Maria
4: Salto
4: Buriti
Least common:
1: Žatčany Solar Power Plant
1: Žebrák Solar Power Plant
1: Želeč - Jihočeský Solar Power Plant
1: Želeč - Olomouc Solar Power Plant
1: Žeraviny Solar Power Plant
1: Žákovice Solar Power Plant
1: Žíšov Solar Power Plant
1: ГТ HPP Velskaya
1: Янискоски ГЭС
1: ​Värtaverket
global_power_plant_database.gppd_idnr: (4/25)
Total rows: 33643
Null rows: 0
Blank rows: 0
Distinct values: 33643
global_power_plant_database.capacity_mw: (5/25)
Total rows: 33643
Null rows: 0
Blank rows: 0
Distinct values: 5712
Most common:
1139: 5.0
936: 10.0
861: 20.0
715: 1.0
674: 2.0
579: 49.0
526: 30.0
451: 50.0
442: 12.0
427: 3.0
Least common:
1: 6720.0
1: 6794.0
1: 6809.0
1: 8212.0
1: 8535.0
1: 8851.0
1: 8865.0
1: 12600.0
1: 13050.0
1: 22500.0
global_power_plant_database.latitude: (6/25)
Total rows: 33643
Null rows: 0
Blank rows: 0
Distinct values: 30657
Most common:
14: -2.5213
11: 36.0139
11: 15.662
11: -23.544
11: -23.6461
8: 42.0357
8: -22.899
7: 36.4
7: 36.36
7: -23.5435
Least common:
1: 70.2
1: 70.2206
1: 70.2353
1: 70.372
1: 70.4826
1: 70.6429
1: 70.684
1: 70.9217
1: 71.0109
1: 71.292
global_power_plant_database.longitude: (7/25)
Total rows: 33643
Null rows: 0
Blank rows: 0
Distinct values: 31805
Most common:
14: 121.357
12: 78.257
12: -46.6265
12: -46.6386
11: -5.6069
8: -6.9054
8: -43.1985
7: 26.6
7: -76.22
6: -121.2958
Least common:
1: 177.5057
1: 177.5355
1: 177.5469
1: 177.682
1: 177.9413
1: 178.027
1: 178.0498
1: 178.4799
1: 178.8359
1: 179.3887
global_power_plant_database.primary_fuel: (8/25)
Total rows: 33643
Null rows: 0
Blank rows: 0
Distinct values: 15
Most common:
9662: Solar
7155: Hydro
5188: Wind
3922: Gas
2390: Coal
2290: Oil
1396: Biomass
1087: Waste
198: Nuclear
189: Geothermal
Least common:
10: Wave and Tidal
13: Petcoke
41: Cogeneration
44: Other
58: Storage
189: Geothermal
198: Nuclear
1087: Waste
1396: Biomass
2290: Oil
global_power_plant_database.other_fuel1: (9/25)
Total rows: 33643
Null rows: 0
Blank rows: 31680
Distinct values: 13
Most common:
31680:
1210: Oil
376: Gas
105: Waste
85: Coal
44: Biomass
33: Other
24: Storage
24: Hydro
23: Petcoke
Least common:
6: Wind
11: Cogeneration
22: Solar
23: Petcoke
24: Hydro
24: Storage
33: Other
44: Biomass
85: Coal
105: Waste
global_power_plant_database.other_fuel2: (10/25)
Total rows: 33643
Null rows: 0
Blank rows: 33340
Distinct values: 12
Most common:
33340:
111: Gas
73: Oil
36: Other
24: Biomass
20: Waste
15: Solar
6: Hydro
6: Coal
5: Storage
Least common:
3: Petcoke
4: Wind
5: Storage
6: Coal
6: Hydro
15: Solar
20: Waste
24: Biomass
36: Other
73: Oil
global_power_plant_database.other_fuel3: (11/25)
Total rows: 33643
Null rows: 0
Blank rows: 33539
Distinct values: 8
Most common:
33539:
38: Gas
24: Other
15: Oil
14: Biomass
6: Hydro
5: Solar
2: Wind
global_power_plant_database.commissioning_year: (12/25)
Total rows: 33643
Null rows: 0
Blank rows: 17340
Distinct values: 2214
Most common:
17340:
771: 2016.0
751: 2014.0
746: 2015.0
674: 2012.0
660: 2013.0
645: 2017.0
536: 2011.0
502: 2009.0
483: 2010.0
Least common:
1: 2015.8058252427186
1: 2015.8125
1: 2015.8944000000004
1: 2016.28125
1: 2016.7054134838922
1: 2016.733333333333
1: 2016.752696763883
1: 2017.0000000000005
1: 2017.000000000001
1: 2017.4999999999998
global_power_plant_database.owner: (13/25)
Total rows: 33643
Null rows: 0
Blank rows: 14112
Distinct values: 9566
Most common:
14112:
120: Lightsource Renewable Energy
109: Cypress Creek Renewables
85: Sustainable Power Group LLC
83: Verbund
81: Pacific Gas & Electric Co.
71: Erie Boulevard Hydropower LP
66: CFE
65: 100% Vattenfall
62: Southern California Edison Co
Least common:
1: vento ludens
1: Ökotech Ingenieurgesellschaft mbh
1: Çelikler Elektrik
1: Çolakoğlu Metalurji
1: Énergie Hydroélectrique Ouiatchouan (Société en Commandite)
1: Énergie La Lièvre SEC
1: ČAS Solární
1: ČST Energetická
1: İzmir Demir Çelik
1: ŽV – SUN
global_power_plant_database.source: (14/25)
Total rows: 33643
Null rows: 0
Blank rows: 15
Distinct values: 867
Most common:
8644: U.S. Energy Information Administration
3733: Wiki-Solar
2413: UK Renewable Energy Planning Database
2404: Open Power System Data
2340: Agência Nacional de Energia Elétrica (Brazil)
1619: UNFCCC CDM Registry
1125: Natural Resources Canada
1100: GCPT
614: Red Eléctrica de España
516: ENTSOE
Least common:
1: Yashwantrao Krishna ssk
1: Yingli Solar
1: Ym Ssk ltd
1: ZEC Starachowice
1: ZJ Energy
1: ZPC Żory
1: Zhongshan Jiaming Electric Power Co Ltd
1: et97
1: mp-tec GmbH & Co KG
1: �WG Solar GmbH
global_power_plant_database.url: (15/25)
Total rows: 33643
Null rows: 0
Blank rows: 18
Distinct values: 4871
Most common:
8644: http://www.eia.gov/electricity/data/browser/
3733: https://www.wiki-solar.org
2413: https://www.gov.uk/government/collections/renewable-energy-planning-data
2340: http://www2.aneel.gov.br/aplicacoes/capacidadebrasil/capacidadebrasil.cfm
1856: http://data.open-power-system-data.org/renewable_power_plants/2016-10-21/
1100: https://endcoal.org/global-coal-plant-tracker/
878: ftp://ftp.maps.canada.ca/pub/nacei_cnaie/energy_infrastructure/PowerPlantsRenewG...
614: http://www.ree.es/en/statistical-data-of-spanish-electrical-system/annual-report...
548: http://data.open-power-system-data.org/
493: http://www.cea.nic.in/
Least common:
1: https://www.stadtwerke-bielefeld.de
1: https://www.suas.cz/index.php/produkty/elektricka-energie
1: https://www.synthosgroup.com/en/synthos-group/group/synthos-dwory-7/
1: https://www.theguardian.com/environment/2015/nov/23/how-africas-fastest-solar-po...
1: https://www.toshiba.co.jp/about/press/2010_09/pr2701.htm
1: https://www.toshiba.com.cn/news/business_news/news_2015/news-20150929-01.html
1: https://www.uniper.energy/sverige/sv.html
1: https://www.worldenergy.org/data/resources/country/kazakhstan/hydropower/
1: https://www.zaubacorp.com/company/MAHATMA-SUGAR-POWER-LIMITED/U15421MH1997PLC111...
1: https://www.zecstar.pl/
global_power_plant_database.geolocation_source: (16/25)
Total rows: 33643
Null rows: 0
Blank rows: 419
Distinct values: 29
Most common:
8644: U.S. Energy Information Administration
3733: Wiki-Solar
2870: WRI
2413: UK Renewable Energy Planning Database
2389: Open Power System Data
2338: Agência Nacional de Energia Elétrica (Brazil)
1788: GEODB
1598: UNFCCC CDM Registry
1327: Industry About
1295: CARMA
Least common:
4: National Renewable Energy Laboratory
5: CDM
9: GEO
11: Estonian Wind Energy Association
35: KTH
73: La Administración Nacional de Usinas y Trasmisiones Eléctricas (Uruguay)
74: Guatemala Energy Data Visualization Center at Universidad Rafael Landivar
174: Open Development Vietnam
177: Power Africa
187: University of Dąbrowa Górnicza
global_power_plant_database.wepp_id: (17/25)
Total rows: 33643
Null rows: 0
Blank rows: 17262
Distinct values: 15400
Most common:
17262:
14: 1082676
13: 1084787
10: 1105009
9: 1070494
8: 56708
8: 1087949
7: 1092478
7: 1089628
7: 1073528
Least common:
1: 70798
1: 70803
1: 70834
1: 70860
1: 70862
1: 70886
1: 70888
1: 70910
1: 70955
1: 71006
global_power_plant_database.year_of_capacity_data: (18/25)
Total rows: 33643
Null rows: 0
Blank rows: 19900
Distinct values: 11
Most common:
19900:
12015: 2017
781: 2016
566: 2018
281: 2015
58: 2000
20: 2014
14: 2013
6: 2012
1: 2009
Least common:
1: 2009
1: 2010
6: 2012
14: 2013
20: 2014
58: 2000
281: 2015
566: 2018
781: 2016
12015: 2017
global_power_plant_database.generation_gwh_2013: (19/25)
Total rows: 33643
Null rows: 0
Blank rows: 26648
Distinct values: 5975
Most common:
26648:
618: 0.0
12: 0.003
11: 0.01
9: 0.029
8: 0.018000000000000002
8: 0.013000000000000001
8: 0.006
8: 0.002
8: 0.001
Least common:
1: 20487.14
1: 21021.244
1: 21073.181
1: 21658.200776
1: 21973.0
1: 26718.113000000005
1: 26761.39
1: 27586.2
1: 31431.08
1: 50834.0
global_power_plant_database.generation_gwh_2014: (20/25)
Total rows: 33643
Null rows: 0
Blank rows: 26213
Distinct values: 6309
Most common:
26213:
670: 0.0
13: 0.002
12: 0.001
11: 0.003
10: 0.006
10: 0.004
9: 0.038
7: 0.022
7: 0.011
Least common:
1: 20263.665
1: 20603.0
1: 20651.667
1: 21193.381
1: 22215.0
1: 24501.0
1: 26738.300000000003
1: 27594.0
1: 28127.0
1: 32320.917
global_power_plant_database.generation_gwh_2015: (21/25)
Total rows: 33643
Null rows: 0
Blank rows: 25234
Distinct values: 7186
Most common:
25234:
738: 0.0
12: 0.002
10: 0.001
9: 0.005
8: 0.008
8: 0.003
7: 0.014
7: 0.012
7: 0.007
Least common:
1: 27669.694
1: 28869.402
1: 29047.0
1: 29180.481
1: 29342.0
1: 30539.0
1: 32153.781
1: 32525.595
1: 36024.124
1: 37433.607
global_power_plant_database.generation_gwh_2016: (22/25)
Total rows: 33643
Null rows: 0
Blank rows: 24297
Distinct values: 7817
Most common:
24297:
861: 0.0
16: 0.008
14: 0.003
9: 0.03
9: 0.007
9: 0.004
9: 0.001
8: 0.014
7: 0.005
Least common:
1: 25303.0
1: 26214.623000000003
1: 27671.0
1: 28078.0
1: 28499.632
1: 30015.0
1: 30488.065
1: 31096.403
1: 31537.575
1: 32377.477
global_power_plant_database.generation_gwh_2017: (23/25)
Total rows: 33643
Null rows: 0
Blank rows: 23974
Distinct values: 8584
Most common:
23974:
319: 0.0
14: 0.002
11: 0.015
10: 0.012
10: 0.009000000000000001
9: 0.02
9: 0.019
8: 0.004
8: 0.003
Least common:
1: 26114.388
1: 27132.915
1: 27494.473
1: 27847.879
1: 29909.0
1: 31471.106
1: 32340.138
1: 32908.815
1: 35116.0
1: 36448.643
global_power_plant_database.generation_data_source: (24/25)
Total rows: 33643
Null rows: 0
Blank rows: 23380
Distinct values: 18
Most common:
23380:
8584: U.S. Energy Information Administration
509: JRC-PPDB-OPEN
438: Central Electricity Authority
262: Australia Clean Energy Regulator
156: Open Development Vietnam
72: Guatemala Energy Data Visualization Center at Universidad Rafael Landivar
58: ENTSOE
39: Egyptian Electricity Holding Company
36: Venezuela Electricity Sector
Least common:
2: IAEA
5: Arab Union of Electricity
5: Office National de l'Electricite
5: Volta River Authority
15: Wind Stats Netherlands
17: Agencia de Regulacion y Control de Electricidad
30: Open Development Myanmar
30: Peru Ministry of Energy and Mines
36: Venezuela Electricity Sector
39: Egyptian Electricity Holding Company
global_power_plant_database.estimated_generation_gwh: (25/25)
Total rows: 33643
Null rows: 0
Blank rows: 8137
Distinct values: 12635
Most common:
8137:
553: 149.98564434532332
333: 0.0
329: 10.66716397375124
257: 2.346547937938379
227: 2.222573567212551
150: 5.33358198687562
136: 0.9606992027116417
131: 22.839722500041958
125: 26.667909934378102
Least common:
1: 37932.232690406694
1: 38332.77918323094
1: 39746.04007477126
1: 43685.84252235933
1: 44170.3196347032
1: 48610.465116279076
1: 51773.439382053366
1: 53622.49078855527
1: 92452.5703250953
1: 450562.6923495511
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment