In this musical instruments database, there are 7,604 records by 15 categories (such as Live Sound, Recording, Band & Orchestral Instruments, Drums & Percussion, Amplifiers & Effects, Ukuleles, Mandolins & Banjos, etc.). Each musical instrument consists of title, price, rating and description. The musical instruments data also contains 4,718 features and 36,275 reviews. The whole musical instruments API has 8 tables.
| Name | n3_chennan_musical_instrument_musiciansfriend_com |
|---|---|
| Data | 47.83M (+ 0B) |
| Tables | 8 (+ 0) |
| Columns | 37 (+ 0) |
| Table Rows | 111,848 (+ 0) |
| Media | 357.94M (+ 0B) |
| Files | 7,600 (+ 0) |
Tables & Columns
| Tables | Rows | Columns | Non-empty |
|---|---|---|---|
| category_1 | 15 | title |
100%
|
| category_1_x_musical_instrument | 7,619 | category_1_id |
100%
|
| musical_instrument_id |
100%
|
||
| feature | 4,718 | key |
99.85%
|
| value |
98.2%
|
||
| musical_instrument | 7,604 | title |
100%
|
| price |
98.13%
|
||
| rating |
100%
|
||
| description |
98.71%
|
||
| musical_instrument_x_feature | 17,538 | musical_instrument_id |
100%
|
| feature_id |
100%
|
||
| musical_instrument_x_review | 38,079 | musical_instrument_id |
100%
|
| review_id |
100%
|
||
| review | 36,275 | date |
100%
|
| author |
100%
|
||
| review_rating |
100%
|
||
| author_location |
100%
|
||
| comment |
32.61%
|
Notes:
- Meta columns id and ts are not shown here, but included in columns total.
- Some statistical or memo columns are not shown here, but included in columns total.
- Non-empty percentage indicates the percent of values that are non-empty for that particular column.
Media Sets
MUSICAL_INSTRUMENT_IMAGE
| Size (Bytes) | Files |
|---|---|
| 357.94M | 7,600 |
