Data Auditor

Audit data integrity, inspect scraped data timelines, and validate records across Elasticsearch and MongoDB.

Videos

tubecvideos

Video Stats

tubecvideos_stats

Channels

tubecbasics

Channel Stats

tubecbasics_stats

Video Flags

tubecvideos_flags

Flag Log

tubecvideos_flag_log

Integrity Checks (12)

Orphaned Stats

Stats snapshots with no matching video document

Missing Stats

Videos with no recent stats snapshots (>48h)

Channel-Video Link

Videos referencing non-existent channels

Duplicate Videos

Multiple video documents with the same YouTube ID

Mapping Validation

Verify field types match expected mappings (long, not text)

Stale Channels

Channels with no video updates in >30 days

Required Fields

Videos missing id, channelId, title, viewCount, or publishedAt

View Corrections

Negative view deltas — normal YouTube bot/spam corrections

Missing Shorts Flag

Videos with undefined is_short (never checked via UUSH)

Stale Channel Scrape

Channels not scraped in the last 24h 5min

Stale Video Scrape

Videos not scraped in the last 24h 5min

Duplicate Channels

Multiple channel docs with the same YouTube channel ID

Scrape Data Inspector

Inspect every scraped stats snapshot, computed deltas, and detected metadata changes for a specific video or channel within a time period.

Enter a video or channel ID above and click “Inspect” to view all scraped data and timestamps.

Quick Lookup

Look up a specific video or channel to inspect their data, flag assignments, and metadata.