Gas Prices For Industrial Consumers - Bi-annual Data (until 2007)
Eurostat code: nrg_pc_203_h ยท (1985-S1 - 2007-S2)
@eurostat.nrg_pc_203_h
Gas Prices For Industrial Consumers - Bi-annual Data (until 2007) - Unpivoted
@eurostat.nrg_pc_203_h.tidy
This table contains the same data as the raw table, but in a tidy format: time period values are unpivoted into rows under a single time_period column, making the dataset easier to analyze and visualize.
- 120.85 KB
- 29718 rows
- 9 columns
freqFreq | productProduct | consomConsom | unitUnit | taxTax | currencyCurrency | geoGeo | time_periodTime Period | valueValue |
|---|---|---|---|---|---|---|---|---|
| Half-yearly, semesterly | Natural gas | Industry - I1 (annual consumption: 418.6 GJ; no load factor) (for Belgium: fixed supply (non-erasable) for non-specific applications that can easily be substituted by residual fuel oils (CNE 1 P 1)) | Gigajoule (gross calorific value - GCV) | All taxes and levies included | Euro | Belgium | 1985-S1 | 9.6835 |
| Half-yearly, semesterly | Natural gas | Industry - I1 (annual consumption: 418.6 GJ; no load factor) (for Belgium: fixed supply (non-erasable) for non-specific applications that can easily be substituted by residual fuel oils (CNE 1 P 1)) | Gigajoule (gross calorific value - GCV) | All taxes and levies included | Euro | Germany | 1985-S1 | 8.7356 |
| Half-yearly, semesterly | Natural gas | Industry - I1 (annual consumption: 418.6 GJ; no load factor) (for Belgium: fixed supply (non-erasable) for non-specific applications that can easily be substituted by residual fuel oils (CNE 1 P 1)) | Gigajoule (gross calorific value - GCV) | All taxes and levies included | National currency | Belgium | 1985-S1 | 10.6867 |
| Half-yearly, semesterly | Natural gas | Industry - I1 (annual consumption: 418.6 GJ; no load factor) (for Belgium: fixed supply (non-erasable) for non-specific applications that can easily be substituted by residual fuel oils (CNE 1 P 1)) | Gigajoule (gross calorific value - GCV) | All taxes and levies included | National currency | Germany | 1985-S1 | 9.9344 |
| Half-yearly, semesterly | Natural gas | Industry - I1 (annual consumption: 418.6 GJ; no load factor) (for Belgium: fixed supply (non-erasable) for non-specific applications that can easily be substituted by residual fuel oils (CNE 1 P 1)) | Gigajoule (gross calorific value - GCV) | All taxes and levies included | National currency (former currencies of the euro area countries) | Belgium | 1985-S1 | 431.1 |
| Half-yearly, semesterly | Natural gas | Industry - I1 (annual consumption: 418.6 GJ; no load factor) (for Belgium: fixed supply (non-erasable) for non-specific applications that can easily be substituted by residual fuel oils (CNE 1 P 1)) | Gigajoule (gross calorific value - GCV) | All taxes and levies included | National currency (former currencies of the euro area countries) | Germany | 1985-S1 | 19.43 |
| Half-yearly, semesterly | Natural gas | Industry - I1 (annual consumption: 418.6 GJ; no load factor) (for Belgium: fixed supply (non-erasable) for non-specific applications that can easily be substituted by residual fuel oils (CNE 1 P 1)) | Gigajoule (gross calorific value - GCV) | Excluding taxes and levies | Euro | Belgium | 1985-S1 | 8.2752 |
| Half-yearly, semesterly | Natural gas | Industry - I1 (annual consumption: 418.6 GJ; no load factor) (for Belgium: fixed supply (non-erasable) for non-specific applications that can easily be substituted by residual fuel oils (CNE 1 P 1)) | Gigajoule (gross calorific value - GCV) | Excluding taxes and levies | Euro | Germany | 1985-S1 | 7.661 |
| Half-yearly, semesterly | Natural gas | Industry - I1 (annual consumption: 418.6 GJ; no load factor) (for Belgium: fixed supply (non-erasable) for non-specific applications that can easily be substituted by residual fuel oils (CNE 1 P 1)) | Gigajoule (gross calorific value - GCV) | Excluding taxes and levies | National currency | Belgium | 1985-S1 | 9.1324 |
| Half-yearly, semesterly | Natural gas | Industry - I1 (annual consumption: 418.6 GJ; no load factor) (for Belgium: fixed supply (non-erasable) for non-specific applications that can easily be substituted by residual fuel oils (CNE 1 P 1)) | Gigajoule (gross calorific value - GCV) | Excluding taxes and levies | National currency | Germany | 1985-S1 | 8.7124 |
CREATE TABLE tidy (
"freq" VARCHAR,
"product" VARCHAR,
"consom" VARCHAR,
"unit" VARCHAR,
"tax" VARCHAR,
"currency" VARCHAR,
"geo" VARCHAR,
"time_period" VARCHAR,
"value" DOUBLE
);