QA Dashboard

Constraint, derivation, and volume checks for admin validation.

Duplicate Business Natural Keys
0
Rows beyond unique natural key pairs in business
Duplicate Inspection Natural Keys
0
Rows beyond unique natural key pairs in inspection
Duplicate Violation Natural Keys
0
Rows beyond unique natural key pairs in violation
Inspections Without Violations
46750
Inspections currently with no violations
Rating Mismatch Count
421
Inspections where derived rating disagrees with violation flags
Unmatched Closure Report Rows
0
Closure report rows that did not map to a facility
Follow-up Outstanding Mismatch
89
VCH follow-up inspections marked excellent/0 obs but near a closure event
Risk v1 vs v2 Differences
0
Businesses whose preferred risk changed under enforcement-aware risk_v2
Businesses Missing Coordinates
1586
Businesses still missing latitude or longitude

Inspection Volume by Source

Source Inspections
vch_food_inspections 114897

Coordinate Coverage by Source

Coverage of `business.latitude` / `business.longitude` plus geocode attempt status counts.

Source Businesses With Coordinates Missing Coverage Success No Match Insufficient Address Error Unattempted Geocode
vch_food_inspections
vch_food_inspections
 10620 9034 1586 85.1% 10 0 0 0 10610

Unmatched Closure Report Rows

Rows from closure reports that were not linked to a facility and require manual assignment.

No unmatched closure rows.

Follow-up Outstanding Mismatch

Potential VCH undercounts where an excellent follow-up with 0 observations occurs near a closure event.

Source Inspection Date Latest Closure Date Business Type Inspection
vch_food_inspections 2026-03-31 2026-03-27 Yama Sushi Routine Follow-up Open
vch_food_inspections 2026-03-30 2026-03-27 Yama Sushi Routine Follow-up Open
vch_food_inspections 2026-03-25 2026-03-09 Mr. Beigai Bbq Routine Follow-up Open
vch_food_inspections 2025-11-24 2025-11-20 Little Mexico Cantina Routine Follow-up Open
vch_food_inspections 2025-06-20 2025-06-18 Pacific Coast News #0849 Routine Follow-up Open
vch_food_inspections 2025-05-30 2025-05-09 Lefong Trading INC. Routine Follow-up Open
vch_food_inspections 2025-05-22 2025-05-09 Lefong Trading INC. Routine Follow-up Open
vch_food_inspections 2025-05-20 2025-05-16 Space for Everyone Shared Kitchen Routine Follow-up Open
vch_food_inspections 2025-05-14 2025-05-09 Lefong Trading INC. Routine Follow-up Open
vch_food_inspections 2025-05-14 2025-05-01 Ajea Noodle Routine Follow-up Open
vch_food_inspections 2025-04-01 2025-03-28 Apex Foods Routine Follow-up Open
vch_food_inspections 2025-03-26 2025-03-25 Star 6 Indian Cuisine Routine Follow-up Open
vch_food_inspections 2025-03-06 2025-02-18 Dolsot Routine Follow-up Open
vch_food_inspections 2025-01-27 2025-01-09 Cloudburst Locavore Processing Kitchen Routine Follow-up Open
vch_food_inspections 2025-01-21 2025-01-20 WoodLeaf Meats INC. Routine Follow-up Open
vch_food_inspections 2024-12-05 2024-12-02 Yunshang Rice Noodle Routine Follow-up Open
vch_food_inspections 2024-08-23 2024-08-22 Kokoro Japanese Ramen Routine Follow-up Open
vch_food_inspections 2024-07-16 2024-07-15 Sushi Man Japanese Restaurant Routine Follow-up Open
vch_food_inspections 2024-06-26 2024-06-25 Japadog Restaurant Routine Follow-up Open
vch_food_inspections 2024-06-06 2024-05-30 Hula Poke Routine Follow-up Open
vch_food_inspections 2024-05-31 2024-05-30 Hula Poke Routine Follow-up Open
vch_food_inspections 2024-05-07 2024-05-06 Blackberry Hill Routine Follow-up Open
vch_food_inspections 2024-05-07 2024-05-06 Dundarave Olive Company Routine Follow-up Open
vch_food_inspections 2024-04-10 2024-03-19 Cantonese Bbq Restaurant Routine Follow-up Open
vch_food_inspections 2024-02-21 2024-02-20 Lucha Libre Taqueria Routine Follow-up Open
vch_food_inspections 2023-10-06 2023-10-04 Miss Fu in Chengdu Routine Follow-up Open
vch_food_inspections 2023-09-21 2023-09-14 Hong Liu Dim Sum Routine Follow-up Open
vch_food_inspections 2023-09-08 2023-09-07 Chicha San Chen Routine Follow-up Open
vch_food_inspections 2023-08-23 2023-08-18 Nam Bak Trading Co. LTD Routine Follow-up Open
vch_food_inspections 2023-07-19 2023-06-28 Lefong Trading INC. Routine Follow-up Open
vch_food_inspections 2023-04-14 2023-03-16 Kolbeh Restaurant INC. Routine Follow-up Open
vch_food_inspections 2023-03-24 2023-03-23 Empire Seafood Restaurant Routine Follow-up Open
vch_food_inspections 2023-03-17 2023-03-16 Kolbeh Restaurant INC. Routine Follow-up Open
vch_food_inspections 2023-02-10 2023-02-08 Joe Pestos Wood Fired Pizzeria Request Follow-up Open
vch_food_inspections 2023-01-27 2023-01-23 Tandoori Kona Restaurant Routine Follow-up Open
vch_food_inspections 2023-01-18 2023-01-17 Happy Lamb Hot Pot Routine Follow-up Open
vch_food_inspections 2022-12-19 2022-12-15 Sushi Town Restaurant (North Van) LTD. Incorporation Number Bc1192046 Routine Follow-up Open
vch_food_inspections 2022-12-14 2022-12-13 The Boatshed Ambleside Routine Follow-up Open
vch_food_inspections 2022-10-13 2022-10-06 Sea Fortune Restaurant Routine Follow-up Open
vch_food_inspections 2022-10-12 2022-09-29 Gah Lok Dim Sum LTD Routine Follow-up Open
vch_food_inspections 2022-07-29 2022-07-14 Pho Hoa Restaurant - Richmond Routine Follow-up Open
vch_food_inspections 2022-07-20 2022-07-19 Tim Hortons C-34 Routine Follow-up Open
vch_food_inspections 2022-06-09 2022-05-31 Garden City Kosher Bakery LTD Routine Follow-up Open
vch_food_inspections 2022-05-13 2022-05-07 Trues Club/ Lounge, Restaurant, Bar Routine Follow-up Open
vch_food_inspections 2022-05-10 2022-05-07 Chef Pin Routine Follow-up Open
vch_food_inspections 2022-05-03 2022-05-02 Joey Burrard Routine Follow-up Open
vch_food_inspections 2022-04-19 2022-04-06 Neptune Seafood Restaurant Routine Follow-up Open
vch_food_inspections 2022-02-28 2022-02-25 Ryuu Japanese Kitchen Routine Follow-up Open
vch_food_inspections 2022-02-03 2022-01-13 Bubble Waffle Cafe - Lansdowne Routine Follow-up Open
vch_food_inspections 2022-02-02 2022-01-31 Sushi Town Restaurant (North Van) LTD. Incorporation Number Bc1192046 Routine Follow-up Open
vch_food_inspections 2022-01-14 2022-01-13 Bourbon St Grill Routine Follow-up Open
vch_food_inspections 2021-12-03 2021-12-01 The Three Brits Public House Routine Follow-up Open
vch_food_inspections 2021-12-01 2021-11-18 Cineplex - Melt & Starbucks Routine Follow-up Open
vch_food_inspections 2021-11-19 2021-11-17 Minato Sushi Routine Follow-up Open
vch_food_inspections 2021-11-12 2021-11-10 1245318 Bc LTD (O/A - Osmow's) Routine Follow-up Open
vch_food_inspections 2021-10-19 2021-10-14 Falafel King - Denman Routine Follow-up Open
vch_food_inspections 2021-09-15 2021-09-13 Vina Restaurant Park Royal Routine Follow-up Open
vch_food_inspections 2021-08-09 2021-07-20 Kowloon Delight Routine Follow-up Open
vch_food_inspections 2021-07-29 2021-07-28 Bourbon St. Grill Routine Follow-up Open
vch_food_inspections 2021-06-11 2021-06-11 Galiano Cafe Routine Follow-up Open
vch_food_inspections 2021-04-14 2021-04-04 Cactus Club Cafe - Main Request Follow-up Open
vch_food_inspections 2021-03-03 2021-02-28 Fairmont Hotel Vancouver - Notch 8 Request Follow-up Open
vch_food_inspections 2021-02-26 2021-02-26 Cavo Bar + Kitchen Request Follow-up Open
vch_food_inspections 2021-01-29 2021-01-27 Joe Fortes Seafood & Chop House Request Follow-up Open
vch_food_inspections 2021-01-18 2021-01-07 Golestan Bakery Routine Follow-up Open
vch_food_inspections 2021-01-08 2021-01-07 Golestan Bakery Routine Follow-up Open
vch_food_inspections 2020-12-23 2020-12-17 Persia Foods - Marine Drive Routine Follow-up Open
vch_food_inspections 2020-12-21 2020-12-17 Persia Foods - Marine Drive Request Follow-up Open
vch_food_inspections 2020-12-21 2020-12-17 Persia Foods - Marine Drive Routine Follow-up Open
vch_food_inspections 2020-12-18 2020-12-17 Persia Foods - Marine Drive Routine Follow-up Open
vch_food_inspections 2020-09-08 2020-09-04 Babylon Restaurant Request Follow-up Open
vch_food_inspections 2020-09-07 2020-09-04 Babylon Restaurant Request Follow-up Open
vch_food_inspections 2020-09-04 2020-09-04 Babylon Restaurant Request Follow-up Open
vch_food_inspections 2020-09-02 2020-08-31 The Famous Warehouse Request Follow-up Open
vch_food_inspections 2020-09-01 2020-08-31 The Famous Warehouse Request Follow-up Open
vch_food_inspections 2020-08-31 2020-08-31 The Famous Warehouse Request Follow-up Open
vch_food_inspections 2020-08-18 2020-08-17 Shawarma Palace Routine Follow-up Open
vch_food_inspections 2020-04-21 2020-04-15 Persia Foods - Marine Drive Routine Follow-up Open
vch_food_inspections 2020-03-11 2020-03-10 Pho Lan Restaurant Routine Follow-up Open
vch_food_inspections 2020-01-10 2020-01-06 Jen-Rex (Philippine-Canadian) Market aka Fiesta Routine Follow-up Open
vch_food_inspections 2019-12-06 2019-11-25 Gramma's Marine Pub Routine Follow-up Open
vch_food_inspections 2019-07-15 2019-07-15 Lingyen Mountain Temple (Canada) Routine Follow-up Open
vch_food_inspections 2019-05-18 2019-05-17 Farm to Table Routine Follow-up Open
vch_food_inspections 2019-04-04 2019-03-15 Rothewood Academy-Richmond City Centre Routine Follow-up Open
vch_food_inspections 2019-01-03 2019-01-02 Cazba Restaurant Routine Follow-up Open
vch_food_inspections 2018-12-20 2018-12-20 Subway #49970 Routine Follow-up Open
vch_food_inspections 2018-11-23 2018-11-22 Tamarind Hill Malaysian Cuisine Routine Follow-up Open
vch_food_inspections 2018-07-11 2018-06-27 Seoul House Korean Restaurant Routine Follow-up Open
vch_food_inspections 2017-11-14 2017-11-14 Flaming Wok Routine Follow-up Open

Risk Model Deltas

Businesses whose derived risk changed between additive `risk_v1` and enforcement-aware `risk_v2`.

No differences detected between `risk_v1` and `risk_v2`.