Bicycles Database

Type, brand, model, weight, materials, frame and specifications of bicycles

Data Structure

bicycle [24,496]
bigint(20) unsigned
+ id (100%)
timestamp
+ ts (100%)
bigint(20) unsigned
+ type_id (100%)
bigint(20) unsigned
+ brand_id (100%)
varchar(255)
+ title (97.2%)
varchar(255)
+ model (84.6%)
varchar(255)
+ year (79.2%)
varchar(255)
+ material (75.6%)
varchar(255)
+ weight (52%)
varchar(255)
+ color (87.1%)
varchar(255)
+ frame (96.7%)
varchar(255)
+ fork (46.6%)
varchar(255)
+ crank (43.2%)
varchar(255)
+ chain_ring (29.7%)
varchar(255)
+ bottom_bracket (30.4%)
varchar(255)
+ front_derailleur (33.6%)
varchar(255)
+ handlebar (39.1%)
varchar(255)
+ stem (36.4%)
varchar(255)
+ headset (32.4%)
varchar(255)
+ size (67.6%)
varchar(255)
+ rear_shock (22.7%)
varchar(255)
+ sims (45.5%)
varchar(255)
+ hub (38.1%)
varchar(255)
+ spoke (27%)
varchar(255)
+ tire (44.5%)
varchar(255)
+ pedal (42%)
varchar(255)
+ chain (33%)
varchar(255)
+ rear_cogs (32.7%)
varchar(255)
+ rear_derailleur (36.1%)
varchar(255)
+ shifter (35.6%)
varchar(255)
+ brake_set (38.1%)
varchar(255)
+ brake_levers (32.4%)
varchar(255)
+ saddle (39.7%)
varchar(255)
+ seat_post (34.3%)
varchar(255)
+ bar_ends (15.3%)
varchar(255)
+ skewers (17.3%)
varchar(255)
+ cages (16.1%)
varchar(255)
+ grips_bartape (27.5%)
text
+ description (100%)
brand [320]
bigint(20) unsigned
+ id (100%)
timestamp
+ ts (100%)
varchar(255)
+ title (100%)
int(11)
+ count (100%)
varchar(255)
+ slug (100%)
type [24]
bigint(20) unsigned
+ id (100%)
timestamp
+ ts (100%)
varchar(255)
+ title (100%)
int(11)
+ count (100%)
varchar(255)
+ slug (100%)

Description

In this worldwide bicycles database, there are 24,496 records from 320 well-known brands classified into 24 types. Each record consists of brand, model, factory year, materials, weight, colors of bike, frame, fork, crank, chain ring, bottom bracket, front derailleur, handle bar, stem, headset, size, rear shock, sims, hub, spoke, tire, pedal, chain, rear cogs, rear derailleur, shifter, brake set, brake levers, saddle, seat post, bar ends, skewers, cages, grips bartape and detailed description.

Data Profile

Size 15.16M
Tables 3
Last Commit 2016-09-02 03:27:07

Updates / Commits

Time Size Tables Columns Rows
2016-09-02 03:27:07 15.16M 3 49 24840

Pricing

All prices are in Datactory Credits.

TableRowsPrice per Row (Credits)Subtotal (Credits)
bicycle 24,496 .001 24.496
brand 320 .001 0.32
type 24 .001 0.024
Total Credits 24.84 Credits (1) (2)
(1). Plus cost by query time at 0.1 credits per second. A typical query takes about 0.001 seconds which would then charge you 0.0001 credits.
(2). This is the total amount of credits required for ALL rows in these tables. You are free to query for only a selected part of them, even a single row, and pay only for that.

How to Access

Click to see how to access this dataset.