Nutritional information for Taiwanese foods, powered by Taiwan FDA open data.
Loading SQL.js... Downloading database... {{ formatBytes(downloadProgress.loaded) }} / {{ formatBytes(downloadProgress.total) }} Initializing database...
Failed to load database: {{ loadError }}
Please try refreshing the page.
LIKE for text search. FTS5 works with the downloaded database.
| {{ col }} |
|---|
| NULL {{ cell }} |
{{ results.values.length }} row(s) returned
Query executed successfully. No results returned.
Run a query to see results
| Column | Type |
|---|---|
| id | INTEGER PK |
| name | TEXT |
Food categories (e.g., 穀物類, 肉類)
| Column | Type |
|---|---|
| id | INTEGER PK |
| name | TEXT |
Nutrient groups (e.g., 維生素, 礦物質)
| Column | Type |
|---|---|
| id | INTEGER PK |
| code | TEXT UNIQUE |
| name_zh | TEXT |
| name_en | TEXT NULL |
| category_id | INTEGER FK |
| alias | TEXT NULL |
| description | TEXT NULL |
| waste_rate | REAL NULL |
| serving_size | REAL NULL |
category_id → categories.id
| Column | Type |
|---|---|
| id | INTEGER PK |
| category_id | INTEGER FK |
| name | TEXT |
| unit | TEXT NULL |
category_id → nutrient_categories.id
Units: mg, g, ug, kcal, I.U.
| Column | Type |
|---|---|
| food_id | INTEGER PK,FK |
| nutrient_id | INTEGER PK,FK |
| value_per_100g | REAL NULL |
| sample_count | INTEGER NULL |
| std_deviation | REAL NULL |
food_id → foods.id
nutrient_id → nutrients.id