Tracking Frontex's Newest UAV

This is a high level article on the UAV operations. If you want more background on how I load and store the data, head here. Reports in a number of portals including Times of Malta show that an unmanned aerial vehicle has been deployed from Luqa airport. The timing, right ahead of the typically busy summer migration time, seems to be an indication of what the main mission probably is. [Read More]

Building a Pipeline to Store Flight Info Using RSQLite, httr and jsonlite

This is the “how the sausage is made” post of this subject, detailing how I created a process to save ADS-B data from OpenSky Network into an SQLite database. If you just want to read the article about UAV operations, head here. Step 1: Sketch up the plan Going into this project, I knew I wanted to use OpenSky Network’s API to query the activity of the UAV in question, but it became clear I needed some way to run an automatic process and store data locally because the two services I’d be using had some limitations. [Read More]

Who would have been elected if we had the gender reform bill in the past?

With Parliament’s Gender Quota bill passing it’s third reading, it’s only a President’s signature away from becoming law. Whether the mechanism has the desired effect or not can only be assessed in the future following a few Parliamentary cycles. What we can do is play around with data and entertain what some previous Parliaments might have of looked like had these rules already been in place. This sort of backtesting is quite common in some domains, so adopting it to policy decisions shouldn’t be that much of a leap. [Read More]

Where Facebook Thinks you Live

Researchers at Facebook and Columbia University have been trying to create much more detailed population density maps for close to a decade. They delve into their weakly supervised approach here, but in a sentence my understanding of the approach is that they enhance national level demographic data with Facebook/Instagram data and remap that “population” onto satellite imagery. These population estimates have been released under their “Data for Good” umbrella here, (and this data can do a great deal of good, from helping NGO’s target their key demographics to informing the most mundane social policy decisions like where to install a bus stop). [Read More]

Text Mining Historical Mass Meeting Speeches

Intro The Department of Maltese at the University of Malta launched a splendid website available here, and it also spotlights some of the dissertations by its students. Two of them immediately piqued my attention, Il-kelma Maltija ta’ Eddie Fenech Adami by James Aaron Ellul and L-arti tal-kelma fid-diskorsi politiċi ta’ Duminku Mintoff (1962) by Christabelle Borg. Both dissertations included sizable appendices with political speeches that are relatively hard to come by on the web, so I got curious to see what some old school text mining can reveal. [Read More]

Making 'Tracking Malta's Vaccine Rollout'

This is intended to be a companion article to this shiny app for those who are more technically oriented and want the details. Where is the data from? Originally, I was going to use OurWorldInData as a source, but then I discovered they were actually just piggybacking off a local project on GitHub which seems to be managed by the Department of Health, so I used that! The only additional field I add is the daily rate of vaccinatations, which I calculate by subtracting the day’s total from the previous day’s. [Read More]

Donkey Voting Part 2

I had given donkey voting an exhaustive treatment here, but Mark Anthony Sammut brought it back to light in this video. His argument for the presence of Donkey voting is essentially the lack of a uniform distribution of MP’s surnames across all the letters of the alphabet (given there are 30 Maltese letters, and 67 seats, you would expect each letter to have 2.2 seats). This distribution would make sense if surnames are evenly distributed across the alphabet… but it almost certainly isn’t. [Read More]

No, PN probably didn’t “gain” Gozo to lose it after a month

Whole Survey Margin of Errors Break Down in Subgroups Some casual MaltaToday readers were in a flurry over the past month and a half over the possibility that PN had not only made a sizeable dent in Labour’s lead in the 13th electoral district, but carried it completely. A new survey in early December subsequently wrote off the gains, but disappointingly seemed to play in to the narrative of a dynamic race. [Read More]

Impact of COVID19 on Air Malta's Operations

Introduction I’ve wanted to analyse something airline related for a while now, but getting my hands on data that was relevant and interesting to me was challenging. Then I read this blog post and discovered the wonderful world of and their REST API. The focus of this post will be to: Come up with several numerical assessments to Air Malta’s operations. Quantify the COVID-19 Pandemic’s impact on Air Malta. [Read More]

The Reading Habits of Shakespeare & Company Patrons

The Literary Utopia on Paris’ Left Bank Shakespeare and Company is as legendary as bookshops get. Owner Sylvia Beach was the publisher of “Ulysses”, written by one of her patrons, James Joyce. Besides Joyce, had you visited, you might also have of run into other literary giants like Ezra Pound, F. Scott Fitzgerald, Gertrude Stein and Ernest Hemingway. Hemingway was so fond of the shop on rue de l’Odéon in Paris’s 6th arrondissement that he visited it with militiamen during the liberation of Paris to ensure its freedom. [Read More]