5 Year French Wealth Analysis

Dataset Description and Characteristics for IFI in France Tax

@kaggle.santiagopatioserna_5_year_french_wealth_analysis

Table List

1 table(23.72 KB)

Df Ificom

@kaggle.santiagopatioserna_5_year_french_wealth_analysis.df_ificom

23.72 KB
712 rows
9 columns

region Region	department Department	commune_code_insee Commune Code INSEE	city City	number_of_taxpayers Number Of Taxpayers	average_assets_in_euro Average Assets In Euro	average_tax_in_euro Average Tax In Euro	source_file Source File	year Year
OCCITANIE	HERAULT	34003	AGDE	57	2121132	8349	ificom-2019.xls	2019
OCCITANIE	HERAULT	34003	AGDE	66	2155865	8598	ificom-2020.xlsx	2020
OCCITANIE	HERAULT	34003	AGDE	64	2175962	8893	ificom-2021.xlsx	2021
OCCITANIE	HERAULT	34003	AGDE	76	2112517	8321	ificom-2022.xlsx	2022
PROVENCE-ALPES-COTE D'AZUR	BOUCHES-DU-RHONE	13001	AIX EN PROVENCE	875	2192630	8895	ificom-2019.xls	2019
PROVENCE-ALPES-COTE D'AZUR	BOUCHES-DU-RHONE	13001	AIX EN PROVENCE	895	2285318	9664	ificom-2020.xlsx	2020
PROVENCE-ALPES-COTE D'AZUR	BOUCHES-DU-RHONE	13001	AIX EN PROVENCE	941	2238380	9219	ificom-2021.xlsx	2021
PROVENCE-ALPES-COTE D'AZUR	BOUCHES-DU-RHONE	13001	AIX EN PROVENCE	982	2318581	9540	ificom-2022.xlsx	2022
AUVERGNE-RHONE-ALPES	SAVOIE	73008	AIX-LES-BAINS	68	1937107	7006	ificom-2019.xls	2019
AUVERGNE-RHONE-ALPES	SAVOIE	73008	AIX-LES-BAINS	67	2052633	7639	ificom-2020.xlsx	2020


CREATE TABLE df_ificom (
  "region" VARCHAR,
  "department" VARCHAR,
  "commune_code_insee" VARCHAR,
  "city" VARCHAR,
  "number_of_taxpayers" DOUBLE,
  "average_assets_in_euro" DOUBLE,
  "average_tax_in_euro" DOUBLE,
  "source_file" VARCHAR,
  "year" BIGINT
);