devinit / devinit/ddw-analyst-ui

Create a new humanitarian_statistics table

Open
#775 3 comments 0 reactions 0 assignees View on GitHub
ETL humportal pinned
Dominant language
TypeScript
Stars
2
Forks
2
Avg merge
4d 27m
Merged PRs (30d)
7

Description

Create a new table that is run outside of the IATI refresh/reload process that is capable of reducing the raw_iati_activities, raw_iati_transactions, and iati_publisher_frequency table into statistics about humanitarian publishers. Until the iati_publisher_frequency table can be populated with enough timestamps to make meaningful use of it, the frequency statistics may need to be replicated from another source of data.

Contributor guide

No contributing guide indexed for this repository

Research direction

No files, tests, or entry points are named in the issue. Start by locating the raw_iati_activities, raw_iati_transactions, and iati_publisher_frequency definitions and the IATI refresh/reload process; done should mean a separate humanitarian_statistics table produces meaningful publisher statistics without running in that process.

Written by the indexing model from the issue text.

Assessment

Domain
data-engineering, databases
Issue type
Feature
Difficulty
5/5
Estimated time
Over a week
Activity status
Stale
Clarity
Needs clarification
Newbie friendliness
25/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.