Prompt

Task: Extract structured data regarding job openings from the provided source and format it as CSV.

Source: URL or file provided. Also, use online research to verify the status and supplement details (like salary ranges, specific locations, or posting dates) for the jobs found at the primary source, using the most current publicly available information.

Proposed CSV Schema (Columns/data fields):

company_name: The name of the company offering the job.
job_title: The specific title of the position.
job_id: Unique ID for the opening, if available.
location: Location(s) where the job is based.
employment_type: Full-time, Part-time, Contract, Internship, etc.
department: Department or team, if specified.
salary_min: Minimum salary (numeric), if specified.
salary_max: Maximum salary (numeric), if specified.
salary_currency: Currency of the salary (e.g., JPY, USD).
salary_period: Period the salary covers (e.g., Annual, Monthly).
salary_notes: Text field for non-numeric salary details (e.g., “Competitive”, range text).
job_description_summary: Brief summary or key responsibilities.
job_url: Direct URL to the specific job posting, if available.
date_posted: Posting date, if available.

Output Requirements:

First, provide a textual description of the overall findings using a bullet list. Include important summary points such as: the company name, the total number of openings processed, a general overview of the types of roles found, general location trends (e.g., main cities, remote options mentioned), and a note on salary information availability (e.g., if ranges are commonly provided or not). Avoid listing specifics like individual salaries or URLs for every job in this summary section.
Then, create the CSV data representing the extracted job openings.
Format the CSV with a header row exactly matching the field names listed above.
Ensure each field in the CSV is enclosed in double quotes (").
Use "" (an empty quoted string) for fields where information could not be found.
Output the result in Japanese.

Example Final CSV Block:


"company_name","job_title","job_id","location","employment_type","department","salary_min","salary_max","salary_currency","salary_period","salary_notes","job_description_summary","job_url","date_posted"
"SAKURA internet Inc.","Cloud Engineer","ENG-001","Osaka, Japan","Full-time","Infrastructure","6000000","8000000","JPY","Annual","Based on skills and experience","Manage and develop cloud platform...","https://www.sakura.ad.jp/recruit/graduates/job/eng001","2025-04-15"
"SAKURA internet Inc.","Web Developer (Frontend)","WD-005","Tokyo or Remote","Full-time","Web Services","5500000","7500000","JPY","Annual","","Develop user interfaces for web services...","https://www.sakura.ad.jp/recruit/graduates/job/wd005","2025-04-10"
"SAKURA internet Inc.","Sales Associate","SAL-002","Fukuoka, Japan","Full-time","Sales","","","JPY","Annual","Competitive + Commission","Generate leads and manage client accounts...","https://www.sakura.ad.jp/recruit/graduates/job/sal002","2025-04-16"
"SAKURA internet Inc.","Part-time Support Staff","SUP-PT-01","Ishikari, Hokkaido","Part-time","Customer Support","1500","1800","JPY","Hourly","Shift work required","Provide technical support via email/phone...","https://www.sakura.ad.jp/recruit/graduates/job/suppt01","2025-04-01"