Skip to main content

🔍 Explore Table Structure

Let's see what's in your new Express Entry draws table

✅ Table Found!

Table Name: ImmiWatch

📊 Sample Data (First 3 Rows)

[
  {
    "whalesync_postgres_id": "9933520f-f761-45bd-9909-def9250b1240",
    "name": "OINP-FWS - 2025-06-03",
    "program": "OINP-FWS",
    "region": "ALL",
    "draw_date_most_recent": "2025-06-03",
    "score": 32,
    "scoring_system": "PNP",
    "filter_by_program": "OINP",
    "invitation": 411,
    "category": "REDI",
    "criteria": null,
    "meta": null,
    "created_at": null,
    "updated_at": null
  },
  {
    "whalesync_postgres_id": "d99b5a2c-bb45-4e5b-8e6a-e508cfc2b598",
    "name": "OINP-FWS - 2025-09-03",
    "program": "OINP-FWS",
    "region": "ALL",
    "draw_date_most_recent": "2025-09-03",
    "score": 42,
    "scoring_system": "PNP",
    "filter_by_program": "OINP",
    "invitation": 1134,
    "category": "Other Priority Occupations",
    "criteria": null,
    "meta": null,
    "created_at": null,
    "updated_at": null
  },
  {
    "whalesync_postgres_id": "63f0170d-4b8a-45a5-b5b8-503a478bdd32",
    "name": "EE-PNP - 2026-09-28",
    "program": "EE-PNP",
    "region": "All",
    "draw_date_most_recent": "2026-09-28",
    "score": 725,
    "scoring_system": "CRS",
    "filter_by_program": "Express Entry",
    "invitation": 733,
    "category": "General",
    "criteria": null,
    "meta": {
      "ircc": {
        "round": "445",
        "source": "ircc_ee_rounds_json",
        "official_name": "Provincial Nominee Program",
        "tie_break_date": "2026-09-17"
      }
    },
    "created_at": "2026-09-28T13:24:02.776293+00:00",
    "updated_at": "2026-09-28T13:24:02.776293+00:00"
  }
]

🔍 Column Analysis

whalesync_postgres_id

Type: string
Sample Value: 9933520f-f761-45bd-9909-def9250b1240

name

Type: string
Sample Value: OINP-FWS - 2025-06-03

program

Type: string
Sample Value: OINP-FWS

region

Type: string
Sample Value: ALL

draw_date_most_recent

Type: string
Sample Value: 2025-06-03

score

Type: number
Sample Value: 32

scoring_system

Type: string
Sample Value: PNP

filter_by_program

Type: string
Sample Value: OINP

invitation

Type: number
Sample Value: 411

category

Type: string
Sample Value: REDI

criteria

Type: object
Sample Value: null

meta

Type: object
Sample Value: null

created_at

Type: object
Sample Value: null

updated_at

Type: object
Sample Value: null

🔧 Manual Table Check

If the automatic detection didn't work, please provide the exact table name:

Common places to find table name:
• Supabase Dashboard → Table Editor → Look for your table name
• Check if it's in a different schema (not 'public')
• The name might be slightly different than expected