Project Title Collect and Analyze Official Government Statements (Time-Sensitive Academic Project) Project Description I am looking for a highly reliable freelancer or small research team to collect and perform a structured preliminary analysis of official public statements issued by governments and international organizations. This project is time-sensitive and supports an international academic conference presentation on 22 January. The task includes both data collection and controlled descriptive analysis, following strict methodological instructions. Project Objective The objective is to deliver a ready-to-use analytical summary based on official institutional statements, in order to assess discursive shifts related to security and sovereignty in the Red Sea and Horn of Africa region following Israel’s recognition of Somaliland. The analysis must be evidence-based, transparent, and reproducible, not interpretive or opinion-driven. Timeline and Deadlines (VERY IMPORTANT) Phase 1: Data Collection Reference event (T0): 26 December 2025 Data collection window: 26 September 2025 – 18 January 2026 No documents published after 18 January 2026 may be included. Deadline for raw data completion: 18 January 2026 (end of day, UTC) Phase 2: Analysis and Reporting Analysis period: 19–20 January 2026 Final delivery deadline: 20 January 2026 This schedule is fixed and non-negotiable. Languages Collect documents in their original published language, including: English Arabic French (if applicable) Important Do not translate documents manually. Automated translation tools (e.g. Google Translate / DeepL) may be used only for analysis, not to replace original texts. All original-language texts must be preserved in the dataset. The client will conduct final reading and interpretation in English only. Sources to Use You will be provided with a comprehensive list of official sources, including: National governments (foreign ministries, presidencies, prime minister offices) International and regional organizations (UN, AU, OIC, Arab League, IGAD, EU) Maritime security mechanisms All listed sources must be checked, even if no relevant documents are found. What to Collect Collect only official institutional documents, such as: Press releases Official statements Communiqués Ministerial or Security Council announcements Do NOT collect: News articles Opinion pieces NGO or think-tank reports Interviews or commentary Required Dataset Structure Each document must be entered as one row in an Excel or CSV file with the following columns: Column Description Actor Country or organization Institution Specific body Document_Type Statement / Press Release / Communiqué Title Official title Publication_Date YYYY-MM-DD URL Direct document link Language English / Arabic / French Script Latin / Arabic Full_Text Full original text Region_Tag Red Sea / Somalia / Somaliland / Horn of Africa / General Notes Access issues only Analysis Tasks (REQUIRED) The analysis must be strictly descriptive and quantitative, not interpretive. Keyword-Based Discourse Analysis Using keyword frequency counts, analyze: Security-related terms (e.g. security, stability, maritime, threat; Arabic equivalents) Sovereignty/legal terms (e.g. sovereignty, territorial integrity, illegal, occupying power; Arabic equivalents) Output: Frequency tables (per institution and over time) Simple comparisons (before vs after 26 Dec 2025) Institutional Reaction Timeline Create a chronological table showing: Which institutions reacted How quickly (days after T0) In what form (statement, communiqué, etc.) Output: One timeline table (Excel or Word) Executive Analytical Summary (VERY IMPORTANT) Prepare a 2–3 page English summary (Word or PDF) that includes: Data sources and methodology (brief) Key observable patterns (no speculation) Tables or charts (simple, clear) Clear bullet points suitable for conference slides Do NOT: Infer hidden intentions Make policy recommendations Go beyond what the data shows Deliverables (ALL REQUIRED) By 20 January 2026, deliver: Clean dataset (Excel or CSV) Keyword frequency tables Institutional reaction timeline 2–3 page analytical summary (English) File naming example: RedSea_Discourse_Analysis_Final_2026-01-20.zip Required Skills Experience with structured political or institutional data collection Ability to work with multilingual text using translation tools Strong Excel / data-handling skills Ability to follow strict methodological instructions Ability to meet tight deadlines Arabic proficiency is not required, but familiarity with Arabic text handling is a plus. How to Apply Please include: Confirmation you can meet the fixed deadlines Experience with similar research or data analysis tasks Confirmation that you understand the analysis must be descriptive, not interpretive One-Sentence Summary for Applicants This project requires collecting official multilingual statements, performing structured keyword-based analysis, and delivering a ready-to-use analytical summary for an academic conference within a fixed deadline.