Hi, I discovered that there are a number of ingredients that have item_id values that are not present in the items list. For some background, I pulled the recipe list and for each of those pulled the details. For each ingredient I created an entry in an ingredients table that is little more than a join table consisting of the recipe_id, the item_id and the count. Here is the output from a little program I whipped up to find out the details:
Total records in “ingredients” with item_ids that are missing in “items”: 298
8576: Missing in 2
12151: Missing in 3
12271: Missing in 7
12324: Missing in 8
13006: Missing in 9
13007: Missing in 9
13008: Missing in 9
13009: Missing in 9
13010: Missing in 11
19664: Missing in 5
19665: Missing in 2
19666: Missing in 2
19667: Missing in 3
19668: Missing in 1
19669: Missing in 2
19670: Missing in 2
19671: Missing in 3
19717: Missing in 20
19790: Missing in 56
19791: Missing in 75
19794: Missing in 59
19924: Missing in 1
Obviously that means that there are 298 ingredient entries that are missing a matching entry in items.
I downloaded the entire database to have it offline. Instead of building a online web program I am building some desktop stuff that uses these files directly. I still need to further evaluate the data to fully design the tables, since it is more of a tree than a set of relational database tables. But there is significant value in having a desktop app.