Non-financial Transactions - Selected International Quarterly Data

Eurostat code: naidsq_10_nf_tr · (1947-Q1 - 2024-Q4)

@eurostat.naidsq_10_nf_tr

Table List

2 tables(19.57 MB)

Non-financial Transactions - Selected International Quarterly Data - Raw

Non-financial Transactions - Selected International Quarterly Data - Unpivoted

Non-financial Transactions - Selected International Quarterly Data - Unpivoted

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

9.71 MB
2915257 rows
9 columns

freq Freq	unit Unit	direct Direct	sector Sector	na_item Na Item	s_adj S Adj	geo Geo	time_period Time Period	value Value
Quarterly	Current prices, million units of national currency	Paid	Total economy	National income/Balance of primary incomes, gross	Unadjusted data (i.e. neither seasonally adjusted nor calendar adjusted data)	United States	1947-Q1	60268
Quarterly	Current prices, million units of national currency	Paid	Total economy	National income/Balance of primary incomes, gross	Seasonally and calendar adjusted data	United States	1947-Q1	60268
Quarterly	Current prices, million units of national currency	Paid	Households; non-profit institutions serving households	Disposable income, gross	Seasonally and calendar adjusted data	United States	1947-Q1	44003
Quarterly	Current prices, million units of national currency	Paid	Households; non-profit institutions serving households	Saving, gross	Seasonally and calendar adjusted data	United States	1947-Q1	4963
Quarterly	Current prices, million units of national currency	Received	Total economy	National income/Balance of primary incomes, gross	Unadjusted data (i.e. neither seasonally adjusted nor calendar adjusted data)	United States	1947-Q1	60268
Quarterly	Current prices, million units of national currency	Received	Total economy	National income/Balance of primary incomes, gross	Seasonally and calendar adjusted data	United States	1947-Q1	60268
Quarterly	Current prices, million units of national currency	Received	Households; non-profit institutions serving households	Disposable income, gross	Seasonally and calendar adjusted data	United States	1947-Q1	44003
Quarterly	Current prices, million units of national currency	Received	Households; non-profit institutions serving households	Saving, gross	Seasonally and calendar adjusted data	United States	1947-Q1	4963
Quarterly	Current prices, million units of national currency	Received	Households; non-profit institutions serving households	Compensation of employees	Seasonally and calendar adjusted data	United States	1947-Q1	32247
Quarterly	Current prices, million units of national currency	Received	Households; non-profit institutions serving households	Social benefits other than social transfers in kind	Seasonally and calendar adjusted data	United States	1947-Q1	2338


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

Share link

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