entities: ENT_MES_UGALLU

The core table — every entity in the database, spanning gods, angels, demons, aeons, prophets, saints, heroes, spirits, monsters, personified abstractions, cosmological realms, and ritual categories. Use category to filter by functional type (146 values: Underworld Deity, Hero, Adversarial Being, Revealer Figure, etc.). Use tradition to filter by tradition. The short_note column contains a scholarly description with source citations.

This data as json

entity_id	canonical_name	greek_name	tradition	entity_type	category	primary_domains	tags	cult_scope	primary_period	evidence_confidence	review_status	inclusion_basis	earth_association_score	chthonic_flag	serpent_flag	short_note	entity_class
ENT_MES_UGALLU	Ugallu		Mesopotamian	Demon	Apotropaic demon	storm; protection of the threshold		Mesopotamian		B	candidate_verified_name	Apotropaic lion-demon	0	1	0	The "Big Weather-Beast," a lion-headed storm demon used apotropaically at doorways.	demon

Links from other tables

0 rows from entity_id in entity_duplicate_review
0 rows from entity_id in entity_epithets
0 rows from entity_id in entity_aliases
0 rows from entity_id in entity_cult_centers
0 rows from entity_id in entity_animals
0 rows from entity_id in entity_functions
1 row from entity_id in entity_periods
0 rows from entity_id in entity_plants
0 rows from entity_id in entity_regions
0 rows from object_entity_id in entity_relationships
3 rows from subject_entity_id in entity_relationships
0 rows from entity_id in entity_metals
0 rows from entity_id in entity_tradition_tags
0 rows from entity_id in names
0 rows from entity_id in entity_scores
1 row from entity_id in entity_sources
0 rows from entity_id in places
0 rows from object_entity_id in relationships
0 rows from subject_entity_id in relationships
0 rows from entity_id in claims
1 row from entity_id in entity_citations