Journalists

idnameemaillanguage_proficiencyyears_experience
1John Doejohn@example.comEnglish3
2Jane Smithjane@example.comFrench6
3Alice Johnsonalice@example.comSpanish8
4Bob Brownbob@example.comGerman7
5Carol Whitecarol@example.comItalian4

Editors

idnameemaillanguage_proficiencyexperience_years
1Michael Jacksonmichael@example.comEnglish10
2Karen Clarkkaren@example.comChinese9
3David Leedavid@example.comArabic5
4Elizabeth Greenelizabeth@example.comRussian8
5Frank Millerfrank@example.comPortuguese6

Companies

idcompanyNamelocation
1The New York TimesNew York
2The GuardianLondon
3Le MondeParis
4Der SpiegelHamburg
5La RepubblicaMilan

JobPostings

idjobTitledescriptionsalary
1ReporterReport on breaking news stories.50000
2Copy EditorCheck articles for grammar and factual errors.55000
3Web ProducerManage website content and social media.60000
4Investigative ReporterConduct in-depth investigations into important issues.65000
5PhotographerCapture images for publication in print and online.52000

Applications

applicationIdapplicantEmailappliedJobapplyDate
1john@example.comReporter2023-04-17 12:30:00
2jane@example.comCopy Editor2023-04-17 12:35:00
3alice@example.comWeb Producer2023-04-17 12:40:00
4bob@example.comInvestigative Reporter2023-04-17 12:45:00
5carol@example.comPhotographer2023-04-17 12:50:00