Weekly Insights
Weekly data-driven deep dives into social economic issues around the world, but with a bit of focus on Sub-Sahara Africa. These are generally current events I'm interested in of which there is a level of open source reporting and data. I publish these on my own platform instead of elswhere (i.e., Substack), because I want full control over the interactive elements and technical presentation. In addition to these current events I'll also sprinkle tid bits about data architectures and designs that I am exploring. I hope you enjoy some of my thoughts and analysis. If you want to continue the conversation feel free to email me: lawrencekarongo@gmail.com.
March 3, 2026
Current and Historical Gas Prices by State and Nationally
This is a dashboard that updates regularly with the current average gas price by state and nationally in relation to the historical trend.
February 18, 2026
Using AWS Lambda functions to trigger data flow
This is short overview of work I've recently completed, where new csv data uploaded to a specific S3 buckets triggers a cascading data pipeline concluding in a QuickSight Dashboard.
February 16, 2026
The Unnecessary Trade: U.S. Lead Imports from Poisoning Operations
Why are U.S. companies paying premium prices to import lead from Nigerian facilities that are poisoning 70% of nearby residents? A data-driven investigation reveals it's not about cost or necessity, it's about supply chain negligence.