General Information About The Enterprises (2000)
Eurostat code: inn_gen ยท (2000 - 2000)
@eurostat.inn_gen
General Information About The Enterprises (2000) - Unpivoted
@eurostat.inn_gen.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.
- 683.45 KB
- 196601 rows
- 9 columns
freqFreq | indic_inIndic In | nace_r1Nace R1 | sizeclasSizeclas | unitUnit | type_innType Inn | geoGeo | time_periodTime Period | valueValue |
|---|---|---|---|---|---|---|---|---|
| Annual | Number of enterprises in current strata (realised sample) | Mining and quarrying | From 10 to 249 employees | Number | Product and/or process innovative enterprises, regardless of organisational or marketing innovation (including enterprises with abandoned/suspended or on-going innovation activities) | Austria | 2000 | 19 |
| Annual | Number of enterprises in current strata (realised sample) | Mining and quarrying | From 10 to 249 employees | Number | Product and/or process innovative enterprises, regardless of organisational or marketing innovation (including enterprises with abandoned/suspended or on-going innovation activities) | Belgium | 2000 | 17 |
| Annual | Number of enterprises in current strata (realised sample) | Mining and quarrying | From 10 to 249 employees | Number | Product and/or process innovative enterprises, regardless of organisational or marketing innovation (including enterprises with abandoned/suspended or on-going innovation activities) | Germany | 2000 | 264 |
| Annual | Number of enterprises in current strata (realised sample) | Mining and quarrying | From 10 to 249 employees | Number | Product and/or process innovative enterprises, regardless of organisational or marketing innovation (including enterprises with abandoned/suspended or on-going innovation activities) | Denmark | 2000 | 23 |
| Annual | Number of enterprises in current strata (realised sample) | Mining and quarrying | From 10 to 249 employees | Number | Product and/or process innovative enterprises, regardless of organisational or marketing innovation (including enterprises with abandoned/suspended or on-going innovation activities) | Greece | 2000 | 5 |
| Annual | Number of enterprises in current strata (realised sample) | Mining and quarrying | From 10 to 249 employees | Number | Product and/or process innovative enterprises, regardless of organisational or marketing innovation (including enterprises with abandoned/suspended or on-going innovation activities) | Spain | 2000 | 211 |
| Annual | Number of enterprises in current strata (realised sample) | Mining and quarrying | From 10 to 249 employees | Number | Product and/or process innovative enterprises, regardless of organisational or marketing innovation (including enterprises with abandoned/suspended or on-going innovation activities) | Finland | 2000 | 17 |
| Annual | Number of enterprises in current strata (realised sample) | Mining and quarrying | From 10 to 249 employees | Number | Product and/or process innovative enterprises, regardless of organisational or marketing innovation (including enterprises with abandoned/suspended or on-going innovation activities) | France | 2000 | 61 |
| Annual | Number of enterprises in current strata (realised sample) | Mining and quarrying | From 10 to 249 employees | Number | Product and/or process innovative enterprises, regardless of organisational or marketing innovation (including enterprises with abandoned/suspended or on-going innovation activities) | Iceland | 2000 | 4 |
| Annual | Number of enterprises in current strata (realised sample) | Mining and quarrying | From 10 to 249 employees | Number | Product and/or process innovative enterprises, regardless of organisational or marketing innovation (including enterprises with abandoned/suspended or on-going innovation activities) | Italy | 2000 | 336 |
CREATE TABLE tidy (
"freq" VARCHAR,
"indic_in" VARCHAR,
"nace_r1" VARCHAR,
"sizeclas" VARCHAR,
"unit" VARCHAR,
"type_inn" VARCHAR,
"geo" VARCHAR,
"time_period" VARCHAR,
"value" DOUBLE
);