🔧 Processing Diagnostics processing

🎛️ Dashboard View Public API Raw Download Audio

📊 Core Incident Data

call_id	2026031708567
incident_type
headline
description
location	Unknown
agencies
datetime	2026-03-17 08:56:57
category	fire
severity	not set
update_type	new_incident

🎯 Processing & Status

processing_status	processing
ai_completed_at	not set
confidence_score	not set
should_post_publicly	YES
pre_alert_sent	NO
summary_alert_sent	NO
audio_hash	not set
file_name	WT_47_City_of_Watertown_2026_03_17_08_56_57.mp3
source_file	WT_47_City_of_Watertown_2026_03_17_08_56_57.mp3

🔊 Audio Playback

File: /audio/WT_47_City_of_Watertown_2026_03_17_08_56_57.mp3

📝 Primary Transcription (OpenAI)

No transcription available

📝 Secondary Transcription (Whisper)

No secondary transcription available

🤖 AI Context & Reasoning

No AI memory/context available

🔍 Database Info

▼

Test Queries:

Get this incident:

SELECT * FROM incidents WHERE call_id = '2026031708567';

Get alert queue:

SELECT * FROM u390051648_alerting.alert_queue WHERE call_id = '2026031708567';

Get related incidents:

SELECT * FROM incidents WHERE JSON_CONTAINS(related_calls, '"2026031708567"');

Get latest incidents:

SELECT * FROM incidents ORDER BY ai_completed_at DESC LIMIT 10;

Raw Database Record:

{
    "call_id": "2026031708567",
    "headline": null,
    "description": null,
    "location": null,
    "agencies": null,
    "incident_type": "",
    "file_name": "WT_47_City_of_Watertown_2026_03_17_08_56_57.mp3",
    "source_file": "WT_47_City_of_Watertown_2026_03_17_08_56_57.mp3",
    "date": "0000-00-00 00:00:00",
    "category": "fire",
    "model_feedback": null,
    "memory": null,
    "related_calls": null,
    "update_type": null,
    "severity": null,
    "should_post_publicly": 1,
    "transcription": null,
    "transcription2": null,
    "datetime": "2026-03-17 08:56:57",
    "confidence_score": null,
    "audio_hash": null,
    "processing_status": "processing",
    "ai_completed_at": null,
    "pre_alert_sent": 0,
    "summary_alert_sent": 0,
    "latitude": null,
    "longitude": null,
    "follow_up_alerts_sent": null,
    "detected_tones": "[\"47\"]",
    "location_validation_log": null,
    "low_confidence_reason": null,
    "transcription_agreement": null,
    "cad_code": "",
    "incident_type_friendly": "",
    "type_icon": null
}