Usage & Publication License: database price dollar sign195.00

24,496 Bicycles in 24 Types from 320 Brands

Brand, model, weight, materials, frame and specifications of 24,496 bicycles classified into 24 types

database structure screenshot of 24,496 Bicycles in 24 Types from 320 Brands

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.

Related DBs:

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: 4312 MB
  • 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
  1. id
  2. type_id
  3. brand_id
  4. title
  5. model
  6. year
  7. material
  8. weight
  9. color
  10. frame
  11. fork
  12. crank
  13. chain_ring
  14. bottom_bracket
  15. front_derailleur
  16. handlebar
  17. stem
  18. headset
  19. size
  20. rear_shock
  21. sims
  22. hub
  23. spoke
  24. tire
  25. pedal
  26. chain
  27. rear_cogs
  28. rear_derailleur
  29. Shifter
  30. grips
  31. brake_set
  32. brake_levers
  33. saddle
  34. seat_post
  35. bar_ends
  36. skewers
  37. cages
  38. grips_bartape
  39. description
type 24
  1. id
  2. title
  3. count
  4. slug
brand 320
  1. id
  2. title
  3. count
  4. slug

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 - 8,283
  • Road - 6,931
  • BMX - 882
  • Fixed Gear - 2,447
  • Cyclocross - 705
  • Dirt Jumper - 914
  • Trials - 131
  • Triathlon/TT - 688
  • Unicycle - 108
  • Motorcycle - 218
  • Dirtbike - 106
  • Bigwheel - 63
  • Highwheel - 13
  • Tallbike - 46
  • Chopper - 85
  • Other - 848
  • Hybrid - 610
  • Recumbent - 85
  • Tandem - 72
  • Cruiser - 361
  • Commuter - 488
  • Touring - 316
  • Lowrider - 33
  • Mutant/Radrod - 63
  • - 0

brand

  • 243 Racing - 11
  • Unknown brand - 4,790
  • Achielle - 5
  • Aegis - 5
  • Affinity - 7
  • Airborne - 23
  • Alan - 7
  • Apollo - 33
  • Aquila - 10
  • Argon 18 - 30
  • Atala - 9
  • Author - 7
  • Avanti - 52
  • Azonic - 33
  • Azzurri - 6
  • BH - 15
  • BMC - 79
  • BT - 9
  • Bacchetta - 12
  • Balfa - 11
  • Banshee - 49
  • Basso - 11
  • Batavus - 17
  • Battaglin - 4
  • BeOne - 9
  • Benotto - 6
  • Bianchi - 567
  • Bike Friday - 13
  • Black Market - 36
  • Black Sheep - 6
  • Blue - 34
  • Bob Jackson - 8
  • Bontrager - 9
  • Bottecchia - 11
  • Breezer - 7
  • Bridgestone - 54
  • Brodie - 52
  • Brompton - 21
  • Brooklyn Machine Works - 11
  • Burley - 13
  • - 0

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.

One Payment, Lifetime Updates

This database is being constantly updated with regards to the volume and 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. You can download the updated version from the Download page by the same credentials we sent to you when you made the purchase, for a lifetime.

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
  • PDF

Let us know and we'll see what we can do. Additional fees may apply.


Share This Page:

Follow us at @UsableDatabases to be notified of database (data sets, lists) releases and updates.

We blog as well. Stay tuned by your preferred means so we can keep you posted on what we are working on!

Contact Us

Need assistance? We can't wait to help you find the perfect database or provide for your custom data needs! Use Custom Data Project form for serious project inquiries.

  1. We will get back to you at this email.

  2. What is your inquiry?

  3. Which is warmer, night or day?

    Please answer the question by common sense.

Back to Top

Subscribe to our Data Press feed to be notified when we release new databases!


Be notified when new data sets are released!
You would also receive running promo discounts and updates to current databases.

Worry Free: We use FeedBurner. You may receive periodic emails / posts from us but you can very easily unsubscribe anytime.