This is a fields-rich musical instruments database with 17,750 records by 16 categories (Guit/Bass, Drums, Keys, Studio, Software, PA, Lighting, DJ, Microphones, Signal Proc., Brass, Traditional, Sheet, Cases, Cables & Accessories). Each record is comprised of title, price, model and manufacturer. There are 70,043 features and 8,499 further informations of these musical instruments in this data. The whole musical instruments data set has 10 tables.
| Name | n3_chennan_musical_instrument_thomann_de |
|---|---|
| Data | 58.64M (+ 0B) |
| Tables | 10 (+ 0) |
| Columns | 45 (+ 0) |
| Table Rows | 323,469 (+ 0) |
| Media | 840.54M (+ 0B) |
| Files | 17,727 (+ 0) |
Tables & Columns
| Tables | Rows | Columns | Non-empty |
|---|---|---|---|
| category_1 | 16 | title |
100%
|
| category_2 | 252 | title |
100%
|
| category_1_id |
100%
|
||
| category_1 |
100%
|
||
| category_3 | 1,310 | title |
100%
|
| category_2_id |
100%
|
||
| category_2 |
100%
|
||
| category_3_x_musical_instrument | 23,720 | category_3_id |
100%
|
| musical_instrument_id |
100%
|
||
| feature | 70,043 | value |
100%
|
| further_information | 8,499 | key |
100%
|
| value |
99.99%
|
||
| musical_instrument | 17,750 | title |
0%
|
| model |
100%
|
||
| cmanufacturer |
100%
|
||
| price |
99.98%
|
||
| musical_instrument_x_feature | 119,428 | musical_instrument_id |
100%
|
| feature_id |
100%
|
||
| musical_instrument_x_further_information | 82,451 | musical_instrument_id |
100%
|
| further_information_id |
100%
|
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 |
|---|---|
| 840.54M | 17,727 |
