Database
24,496 Bicycles by 24 Types of 320 Brands
Brand, model, weight, materials, frame and specifications of 24,496 bicycles classified into 24 types
Description: In this bicycles database, there are 24,496 records from 320 well-known brands classified into 24 kinds by use. 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.
Database Statistics
- Size: 16.50 MB
- Tables: 3
- Records: 24,496
- Formats: MySQL, CSV, MS Excel, MS Access, XML (See Downloads for sure.)
Database Categories
Images Statistics
- Images: 4.21G
- Dimensions: 120 x 90, 600 x 400
- Image formats: jpg,png
- Images count: 61,539
- Reference field: bicycle.id
Database Structure
| Table | Records | Fields |
|---|---|---|
| bicycle | 24,496 |
|
| type | 24 |
|
| brand | 320 |
|
Database Attachments
Images: This database is attached with 61,539 images. See them under the Attachments tab.
Content Scope
Below are the categories / subjects / topics this database contains record entries about and the number of entries under each of them:
type
- Mountain
- Road
- BMX
- Fixed Gear
- Cyclocross
- Dirt Jumper
- Trials
- Triathlon/TT
- Unicycle
- Motorcycle
- Dirtbike
- Bigwheel
- Highwheel
- Tallbike
- Chopper
- Other
- Hybrid
- Recumbent
- Tandem
- Cruiser
- Commuter
- Touring
- Lowrider
- Mutant/Radrod
brand
- 243 Racing
- Unknown brand
- Achielle
- Aegis
- Affinity
- Airborne
- Alan
- Apollo
- Aquila
- Argon 18
- Atala
- Author
- Avanti
- Azonic
- Azzurri
- BH
- BMC
- BT
- Bacchetta
- Balfa
- Banshee
- Basso
- Batavus
- Battaglin
- BeOne
- Benotto
- Bianchi
- Bike Friday
- Black Market
- Black Sheep
- Blue
- Bob Jackson
- Bontrager
- Bottecchia
- Breezer
- Bridgestone
- Brodie
- Brompton
- Brooklyn Machine Works
- Burley
Miscellaneous
Notes:
- There are 23,821 records with a non-empty title field in table bicycle.
- There are 20,728 records that have a populated model field.
- There are 19,413 records with a year.
- There are 18,510 records with a material.
- There are 12,750 records with a weight.
- There are 21,339 records with a color.
- There are 23,684 records with a frame.
- There are 11,408 records with a fork.
- There are 10,582 records with a crank.
- There are 7,267 records with a chain ring.
- There are 7,459 records with a bottom bracket.
- There are 8,229 records with a front derailleur.
- There are 9,588 records with a handlebar.
- There are 8,918 records with a stem.
- There are 7,928 records with a headset.
- There are 5,564 records with a rear shock.
- There are 11,143 records with a sims.
- There are 9,341 records with a hub.
- There are 6,624 records with a spoke.
- There are 10,889 records with a tire.
- There are 10,289 records with a pedal.
- There are 8,083 records with a chain.
- There are 7,998 records with a rear cogs.
- There are 8,835 records with a rear derailleur.
- There are 9,327 records with a brake set.
- There are 7,937 records with a brake levers.
- There are 9,720 records with a saddle.
- There are 8,397 records with a seat post.
- There are 3,737 records with a bar ends.
- There are 4,245 records with a skewers.
- There are 3,946 records with a cages.
- There are 6,725 records with a grips bartape.
Lifetime Updates (fees may apply)
This database is being constantly updated with regards to both data volume and data structure, once every 0.5 - 5 years depending on niche, and you will be notified via our Blog or Twitter when new versions come out.
Other Formats upon Request
We include the most common, popular and usable formats readily accessible on the download page, but should you need the database in other formats such as:
- Microsoft SQL Server
- Microsoft SQL Server Compact Edition
- Oracle
- PostgreSQL
- ODBC
- Interbase / Firebird
- WordPress
- Single Table (multiple tables are combined into one)
- Microsoft Word .DOC
Let us know and we'll see what we can do. Additional fees may apply.