How do I use `WHERE NOT EXISTS`?

INSERT INTO Filing (location_id, filing_date, other_columns)
SELECT L.location_id, '2023-01-01'::date, default_values_for_other_columns
FROM Location L
WHERE NOT EXISTS (
  SELECT 1
  FROM Filing F
  WHERE F.location_id = L.location_id
    AND F.filing_date = '2023-01-01'::date
);

INSERT INTO Filing (location_id, filing_date, other_columns)
SELECT L.location_id, '2023-01-01'::date, default_values_for_other_columns
FROM Location L
WHERE NOT EXISTS (
  SELECT 1
  FROM Filing F
  WHERE F.location_id = L.location_id
    AND F.filing_date = '2023-01-01'::date
);