Average Car Prices - Brazil

Average prices of cars sold in Brazil in the last 2 years (Jan 2021 - Jan 2023)

@kaggle.vagnerbessa_average_car_prices_bazil

Table List

2 tables(18.26 MB)

Fipe 2022

Fipe Cars

@kaggle.vagnerbessa_average_car_prices_bazil.fipe_cars

12.22 MB
599007 rows
11 columns

year_of_reference Year Of Reference	month_of_reference Month Of Reference	fipe_code Fipe Code	authentication Authentication	brand Brand	model Model	fuel Fuel	gear Gear	engine_size Engine Size	year_model Year Model	avg_price_brl Avg Price Brl
2021	January	038001-6	tlp4qry07m	Acura	NSX 3.0	Gasoline	manual	3	1995	40374
2021	January	038001-6	s1wksdv9by	Acura	NSX 3.0	Gasoline	manual	3	1994	38939
2021	January	038001-6	skrbcfnkch	Acura	NSX 3.0	Gasoline	manual	3	1993	37648
2021	January	038001-6	rxzh76d5db	Acura	NSX 3.0	Gasoline	manual	3	1992	35962
2021	January	038001-6	qrm322tpd8	Acura	NSX 3.0	Gasoline	manual	3	1991	32863
2021	January	038002-4	mr0qcv97rl	Acura	Legend 3.2/3.5	Gasoline	manual	3.2	1998	24963
2021	January	038002-4	lnfvbxbt8q	Acura	Legend 3.2/3.5	Gasoline	manual	3.2	1997	22014
2021	January	038002-4	k60nzw7sqt	Acura	Legend 3.2/3.5	Gasoline	manual	3.2	1996	20869
2021	January	038002-4	kd43rx4qhn	Acura	Legend 3.2/3.5	Gasoline	manual	3.2	1995	18749
2021	January	038002-4	jpnl93zx5x	Acura	Legend 3.2/3.5	Gasoline	manual	3.2	1994	16830


CREATE TABLE fipe_cars (
  "year_of_reference" BIGINT,
  "month_of_reference" VARCHAR,
  "fipe_code" VARCHAR,
  "authentication" VARCHAR,
  "brand" VARCHAR,
  "model" VARCHAR,
  "fuel" VARCHAR,
  "gear" VARCHAR,
  "engine_size" DOUBLE,
  "year_model" BIGINT,
  "avg_price_brl" DOUBLE
);