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 2022

@kaggle.vagnerbessa_average_car_prices_bazil.fipe_2022

6.04 MB
290275 rows
12 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	age_years Age Years
2022	January	038001-6	vwmrywl5qs	Acura	NSX 3.0	Gasoline	manual	3	1995	43779	28
2022	January	038001-6	t9mt723qhz	Acura	NSX 3.0	Gasoline	manual	3	1994	42244	29
2022	January	038001-6	tr5wv4z21g	Acura	NSX 3.0	Gasoline	manual	3	1993	40841	30
2022	January	038001-6	s2xxsjz3mt	Acura	NSX 3.0	Gasoline	manual	3	1992	39028	31
2022	January	038001-6	rtm9gj7zk8	Acura	NSX 3.0	Gasoline	manual	3	1991	35678	32
2022	January	038002-4	nlf2w6k7vd	Acura	Legend 3.2/3.5	Gasoline	manual	3.2	1998	27132	25
2022	January	038002-4	mcyp7ypwtc	Acura	Legend 3.2/3.5	Gasoline	manual	3.2	1997	23934	26
2022	January	038002-4	lxckds9y6h	Acura	Legend 3.2/3.5	Gasoline	manual	3.2	1996	22690	27
2022	January	038002-4	k1fntq7ycs	Acura	Legend 3.2/3.5	Gasoline	manual	3.2	1995	20393	28
2022	January	038002-4	j1b3jg70bz	Acura	Legend 3.2/3.5	Gasoline	manual	3.2	1994	17742	29


CREATE TABLE fipe_2022 (
  "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,
  "age_years" BIGINT
);