The next part in the equation. A little AHA! moment. After building the API dash for Covid for NZ I found that it was SLOW! I tried cleaning the code up a bit and that did help but it was still SLOW. I then thought about how plases like John Hopkins and how they were

Its been slower writing the last 100 posts compared to the previous 200. But I’ve got there, with this being the 300th post. You can view the actual table here. ﻿Your browser does not support iframes Slower because of other activities I’ve broken out of just exploring this area of posting and started doing a

This is in fact an article How to import JSON data into Google Sheets to create a live COVID-19 chart that I came across on my RSS feed from Datawrapper. I want to follow this as it sort of comes full circle. I’d started my covid data exploration with Google Sheets and importXML() and now,

Developing my covid map using API data pulled in in JSON format has caused me some grief. I have spent a couple of days with no progress at all trying to get variable data pushed through a function to use in a JS Template literal. In the end I had to wrap the whole thing

I m very excited as I’ve found out about JS Template literals, I think I’ve used some in code but was not aware of it. The video below is a very good tutorial: There is also a link to Codepen of 1/ the basics, so you can follow along, and the complete solution HERE. The

After pulling the data from an API ans displaying it in a web page Chart, and developing a crude selection list for different countries and dates, I started to think about creating my own API as a project. As I looked around for data I came across Dixon Cheng’s Github repository of Covid-19 data scraped

This is definitely worth my time. Up until now I’ve been using Notepad++ to do my code editing, and after adding code, I have to save file, go across to browser and refresh page to see the updates, so I’m constantly jumping between programmes. Quite distracting. The video below shows you how the Live Server

I want to play with 1/ Covid Data & 2/ API’s. I’ve done some bits with Postman & API’s before but not very successfully. So this time I’m watching the following video: It is pulling in the Postman scripts for the API calls and I want to follow on with what they are doing. After

The Ministry of Health(MoH) have posted the original dataset on a different web page of each case and which District Health Board (DHB) they are under. The data can be found here. Instead of by region, its mapped to the District Health Board Regions. So the original map I was using in this post is

Max Drake

About

My current area of interest is in exploring Asset & Facilities Management tools based on capturing information at Design/Construction phase for use throughout the life of the building. Tools I am using are open-source or common programmes to allow maximum accessibility to the information both in geometric and data format.

This has dropped me into the world of programming HTML, CSS, JavaScript, SQL, VBA, PHP & AJAX to name but a few distractions.