Assembly ConstituencyOntology Layer

Ontology Layer

v1.0.0-ontology-phase · Entity classes · Relationships · Live graph stats

Neo4j LIVE

PostgreSQL LIVE

Total Nodes

in Neo4j

Total Edges

relationships

Active Constraints

—

5 v2 added

HeatMap Coverage

0/0 booths geocoded

Entity Classes (16)

LIVE COUNTS

Statestate_id

e.g. UP

—

nodes

Districtdistrict_id

e.g. GKP

—

nodes

AssemblyConstituencyac_id

e.g. GKP_322

—

nodes

Boothbooth_id

e.g. GKP_322_001

—

nodes

Candidatecandidate_id

e.g. GKP_CAN_2022_001

—

nodes

Partyparty_id

e.g. BJP

—

nodes

Issuecode

e.g. water

—

nodes

Schemename

e.g. PM_UJJWALA

—

nodes

PulseEventevent_id

e.g. PE_YT_abc123

—

nodes

YouTubeVideovideo_id

e.g. dQw4w9WgXcQ

—

nodes

Channelchannel_id

e.g. UCxxx

—

nodes

Panchayatpanchayat_id

e.g. PAN_GKP_001

—

nodes

Narrative(booth_id, narrative_type, computed_at)

e.g. anti_incumbency@B001

—

nodes

DataQuality(booth_id, computed_at)

e.g. DQ_B001_2024

—

nodes

SchemeGap(booth_id, scheme_name, computed_at)

e.g. GAP_B001_UJJWALA

—

nodes

ContradictionFlag(booth_id, entity, source_a, …)

e.g. CF_B001_BJP_NEWS_SM

—

nodes

Relationship Taxonomy (20)

0 total edges

From	Type	To	Count
State	[:HAS_DISTRICT]	District	—
District	[:HAS_AC]	AssemblyConstituency	—
AssemblyConstituency	[:HAS_BOOTH]	Booth	—
Candidate	[:REPRESENTS]	Party	—
Candidate	[:CONTESTED_IN]	AssemblyConstituency	—
Candidate	[:HAS_CRIMINAL_RECORD]	CriminalRecord	—
Candidate	[:HAS_ASSETS]	AssetDeclaration	—
PulseEvent	[:AT_BOOTH (inv)]	Booth	—
PulseEvent	[:TAGGED_ISSUE]	Issue	—
PulseEvent	[:MENTIONS_PARTY]	Party	—
YouTubeVideo	[:ABOUT_AC]	AssemblyConstituency	—
YouTubeVideo	[:FROM_CHANNEL]	Channel	—
Panchayat	[:WITHIN_AC]	AssemblyConstituency	—
Booth	[:HAS_QUALITY]	DataQuality	—
Booth	[:HAS_NARRATIVE]	Narrative	—
Narrative	[:TAGGED_ISSUE]	Issue	—
Narrative	[:INVOLVES_PARTY]	Party	—
Booth	[:HAS_SCHEME_GAP]	SchemeGap	—
SchemeGap	[:FOR_SCHEME]	Scheme	—
Booth	[:HAS_CONTRADICTION]	ContradictionFlag	—

Live Edge Distribution

No edge data

Constraints v1

0 active

AssemblyConstituency(ac_id)

UNIQUE · Missing

Booth(booth_id)

UNIQUE · Missing

Party(party_id)

UNIQUE · Missing

Candidate(candidate_id)

UNIQUE · Missing

Issue(code)

UNIQUE · Missing

YouTubeVideo(video_id)

UNIQUE · Missing

Channel(channel_id)

UNIQUE · Missing

PulseEvent(event_id)

UNIQUE · Missing

Constraints v2

ACTIVATED

State(state_id)

UNIQUE v2 · Active

District(district_id)

UNIQUE v2 · Active

DemographicSegment(segment_id)

UNIQUE v2 · Active

GovernanceAsset(asset_id)

UNIQUE v2 · Active

TwinScenario(scenario_id)

UNIQUE v2 · Active

NODE KEY constraints require Neo4j Enterprise (skipped on Community)

PostgreSQL Tables

ac_master0

booth_master0

booth_metrics0

election_results_20220

ac_election_summary0

candidate_master0

candidate_affidavits0

demographic_segments0

pulse_events0

youtube_videos—

scheme_gap_analysis—

booth_narratives—

contradiction_flags—

data_quality_metrics—

ID Normalization

State

District

GKP

GKP_322

Booth

GKP_322_<booth_num_3d>

Candidate

GKP_CAN_<year>_<seq>

PulseEvent

PE_<source>_<hash>

Scheme

SCHEME_<name_upper>

Phase Progress

100%

Entity class definitions

ID normalization rules

Relationship taxonomy

Ontology version field

Constraints v1 applied

Form-20 election data loaded

Digital Signal ingestion

Constraint activation (v2)

Graph hardening (loaders)

HeatMap ≥85% coverage

Twin snapshot endpoint

Demographic segment API

All phases complete ✓