This is a boats and boats sales database with 1,592 boats and 109 sales records in each. All boats are categorized into 7 makes of Bennington, Carolina Skiff, Grady White, Regal, Sea Hunt, Yamaha marine and Load Rite. In table boat, it comprised of title, category type id, description, model, etc and the boat sales table, there are condition, year, model, color, length, beam, horsepower, propulsion, fuel type, sale boat no id, etc. The boats data also comes with 12,884 images of boats and sale boats in the 1.43G and 245.95M media package.
The whole boats and boats sales data set has 16 tables.
| Name | n3_lyz_norfolkmarine.com |
|---|---|
| Data | 33.12M (+ 0B) |
| Tables | 16 (+ 0) |
| Columns | 77 (+ 0) |
| Table Rows | 76,786 (+ 0) |
| Media | 1.67G (+ 0B) |
| Files | 15,908 (+ 0) |
Data Samples
- By Table / Main (Desktop) / JSON / XML / Excel / CSV (Download)
- By Table / Main (Desktop) / JSON / XML / Excel / CSV (Download)
Database APIs
Media Files
- boat_image Bytes: 1.43G / Files: 12,883
- sale_boat_image Bytes: 245.95M / Files: 3,025
Tables & Columns
| Tables | Rows | Columns | Non-empty |
|---|---|---|---|
| boat | 1,592 | title |
100%
|
| category_type_id |
100%
|
||
| description |
74.62%
|
||
| model |
94.16%
|
||
| engine |
22.74%
|
||
| beam |
48.43%
|
||
| fuel_type |
26.51%
|
||
| dry_weight |
9.05%
|
||
| boat_feature_key | 9,643 | key |
99.97%
|
| boat_id |
100%
|
||
| boat_feature_value | 22,674 | value |
100%
|
| boat_feature_key_id |
100%
|
||
| boat_speci_key | 5,492 | main_key |
100%
|
| boat_id |
100%
|
||
| boat_speci_value | 21,012 | key |
100%
|
| value |
100%
|
||
| boat_speci_key_id |
100%
|
||
| category_make | 18 | make |
100%
|
| category_year_id |
100%
|
||
| category_type | 109 | title |
100%
|
| category_make_id |
100%
|
||
| category_year | 3 | year |
100%
|
| image_slug | 12,884 | boat_id |
100%
|
| make | 7 | make |
100%
|
| sale_boat | 109 | condition |
100%
|
| year |
100%
|
||
| sale_price |
22.02%
|
||
| model |
100%
|
||
| color |
100%
|
||
| length |
98.17%
|
||
| beam |
55.96%
|
||
| horsepower |
97.25%
|
||
| engine_hours |
47.71%
|
||
| propulsion |
92.66%
|
||
| hull_material |
77.06%
|
||
| fuel_type |
98.17%
|
||
| decription |
100%
|
||
| sale_boat_no_id |
100%
|
||
| sale_boat_no | 109 | type |
100%
|
| sale_boat_x_make | 109 | sale_boat_id |
100%
|
| make_id |
100%
|
||
| sale_image_slug | 3,025 | sale_boat_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
BOAT_IMAGE
| Size (Bytes) | Files |
|---|---|
| 1.43G | 12,883 |
SALE_BOAT_IMAGE
| Size (Bytes) | Files |
|---|---|
| 245.95M | 3,025 |
