In the bakeries database, there are 2,281 records with title, hours, more business, address, phone, website, latitude, longitude, city, state and service offered in each. All these bakeries are located in San Francisco. It contains 2,143 bakery images in the data. All the bakeries images are in the 32.86M media file. The whole San Francisco bakeries database has 4 tables in total.
| Name | n3zm_Bakery_yelp_com_San_Francisco |
|---|---|
| Data | 7.27M (+ 0B) |
| Tables | 4 (+ 0) |
| Columns | 23 (+ 0) |
| Table Rows | 4,424 (+ 0) |
| Media | 32.86M (+ 0B) |
| Files | 2,142 (+ 0) |
Tables & Columns
| Tables | Rows | Columns | Non-empty |
|---|---|---|---|
| bakery | 2,281 | title |
100%
|
| hours |
38.67%
|
||
| more_business |
42.83%
|
||
| address |
45.24%
|
||
| phone |
42.31%
|
||
| website |
22.75%
|
||
| latitude |
45.2%
|
||
| longitude |
45.2%
|
||
| city |
45.2%
|
||
| state |
45.2%
|
||
| services_offered |
0.26%
|
||
| bakery_image | 2,143 | bakery_id |
100%
|
| bakery_x_bakery_image | 0 | bakery_id |
0%
|
| bakery_image_id |
0%
|
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
BAKERY_IMAGE_DOWNLOAD
| Size (Bytes) | Files |
|---|---|
| 32.86M | 2,142 |
