Non-financial Transactions - Selected International Annual Data

Eurostat code: naidsa_10_nf_tr · (1949 - 2024)

@eurostat.naidsa_10_nf_tr

Table List

2 tables(12.32 MB)

Non-financial Transactions - Selected International Annual Data - Raw

Non-financial Transactions - Selected International Annual Data - Unpivoted

Non-financial Transactions - Selected International Annual Data - Unpivoted

@eurostat.naidsa_10_nf_tr.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.

6.25 MB
1834865 rows
8 columns

freq Freq	unit Unit	direct Direct	na_item Na Item	sector Sector	geo Geo	time_period Time Period	value Value
Annual	Current prices, million euro	Paid	Total employment (thousands of hours worked) domestic concept	Total economy	France	1949	44122194
Annual	Current prices, million euro	Paid	Total employment (thousands of persons) domestic concept	Total economy	France	1949	19439
Annual	Current prices, million euro	Received	Total employment (thousands of hours worked) domestic concept	Total economy	France	1949	44122194
Annual	Current prices, million euro	Received	Total employment (thousands of persons) domestic concept	Total economy	France	1949	19439
Annual	Current prices, million units of national currency	Paid	Change in net worth due to saving and capital transfers	Total economy	France	1949	3332
Annual	Current prices, million units of national currency	Paid	Change in net worth due to saving and capital transfers	Non-financial corporations	France	1949	1333
Annual	Current prices, million units of national currency	Paid	Change in net worth due to saving and capital transfers	Financial corporations	France	1949	155
Annual	Current prices, million units of national currency	Paid	Change in net worth due to saving and capital transfers	General government	France	1949	148
Annual	Current prices, million units of national currency	Paid	Change in net worth due to saving and capital transfers	Households	France	1949	1531
Annual	Current prices, million units of national currency	Paid	Change in net worth due to saving and capital transfers	Households; non-profit institutions serving households	France	1949	1696


CREATE TABLE tidy (
  "freq" VARCHAR,
  "unit" VARCHAR,
  "direct" VARCHAR,
  "na_item" VARCHAR,
  "sector" VARCHAR,
  "geo" VARCHAR,
  "time_period" VARCHAR,
  "value" DOUBLE
);

Share link

Anyone who has the link will be able to view this.