LEGO Database

The LEGO Parts/Sets/Colors and Inventories of every official LEGO set

@kaggle.rtatman_lego_database

Colors

@kaggle.rtatman_lego_database.colors

id Id	name Name	rgb Rgb	is_trans Is Trans
-1	Unknown	0033B2	f
	Black	05131D	f
1	Blue	0055BF	f
2	Green	237841	f
3	Dark Turquoise	008F9B	f
4	Red	C91A09	f
5	Dark Pink	C870A0	f
6	Brown	583927	f
7	Light Gray	9BA19D	f
8	Dark Gray	6D6E5C	f


CREATE TABLE colors (
  "id" BIGINT,
  "name" VARCHAR,
  "rgb" VARCHAR,
  "is_trans" VARCHAR
);