Database
603K Recipes in 59 Categories: Ingredient, Direction, 63.9K Reviews, 51.6K images
title, category, introduce, mark, star, ratings, nutritional information and so on
Description: This is a recipes database with 603,704 records. Each record is comprised of title, introduce, ingredient, time, ingredient, direction, tip, mark, nutritional, minutes to prepare, minutes to cook, and so on. The recipe data also has 63,915 reviews and 51,681 images. The whole recipe data set consists of 7 tables.
Data Samples (JSON, CSV, XML, Excel):
http://n3.datasn.io/data/api/v1/n3zm/recipe_2/main/list/
Database Statistics
- Size: 1.60 GB
- Tables: 5
- Records: 603,704
- Formats: MySQL, CSV, MS Excel, MS Access, XML (See Downloads for sure.)
Database Categories
Images Statistics
- Images: 18.58G
- Dimensions: 1200 x 800 on average
- Image formats: JPEG
- Images count: 51681
- Reference field: image_name_field
Database Structure
Table | Records | Fields |
---|---|---|
category | 7 |
|
subcategory | 59 |
|
recipe | 603,704 |
|
recipe_x_subcategory | 1,357,931 |
|
review | 63,915 |
|
Database Attachments
Images: This database is attached with 51681 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:
subcategory
- Poultry
- Beef / Pork
- Fish
- Vegetarian
- Desserts
- Side Items
- Snacks
- Appetizers / Soups / Salads
- Asian
- Italian
- Mexican
- French
- German
- Indian
- Spanish
- Breakfast
- Lunch
- Dinner
- Dessert
- Side Dish
- Snack
- Drink
- Sandwich
- Soup
- Salad
- Slow Cooker
- Brunch
- Party
- Thanksgiving
- Christmas
- Cookout
- Kids
- Birthday
- Picnic
- Vegetarian
- Vegan
- Lactose Free
- Gluten Free
- Low Fat
- Low Carb
- Sugar Free
- < 15 minutes
- < 30 minutes
- < 45 minutes
- < 1 hour
- homemade?protein?bars
- flat iron steak
- portabella mushroom
- japanese eggplant
- picnic side dishes
- low fat ice cream
- ramen noodle salad
- pancake from scratch
- abs diet recipes
- cucumber salad vinegar
- hamburger meat
- chicken thigh
- tuna fish
- p90x recipes
category
- Category
- Cuisine
- Course
- Occasion
- Dietary Needs
- Time to Make
- Recent Searches
Lifetime Updates (fees may apply)
This database is being constantly updated with regards to both data volume and data 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.
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
Let us know and we'll see what we can do. Additional fees may apply.