FREE STATE Health pass 1

[jbothma]

• Source URL
• Trusted Archive copy (Fill this using the archive URL generated by e.g. https://archive.org/web/ Save Page Now)

[JasonTame]

@jbothma I'm happy to take this one on

[jbothma]

Thanks!

[jbothma]

This is an interesting case - looks like we should clarify the documentation (I probably didn't pay attention properly if you asked):

• We don't want total rows
• We do want total columns - the Free State often provide this breakdown of committed (order_amount_zar) and paid/unpaid split. We want the total in this case.

Do you mind including the final column after all?

[jbothma]

Looks like the last row is shifted to the left - could you fix that?

[jbothma]

In this case the item description needs to be filled down.

We need a row for each unique

• supplier
• order amount
• buyer
• order number (this is often not provided but we wouldn't merge the same supplier coming up twice in a table into one row - distinct rows imply distinct orders)

[jbothma]

Looks like the quantity column in one table aligned with a cost column in another table

[jbothma]

I wonder if each table is a hospital. But I don't see headings suggesting that.

Would be cool to ask them.

[jbothma]

missed the last row of the last table but I'll add it

[jbothma]

Started uploading this

[jbothma]

Done the first file but distracted by bugs and adding a couple of new fields for this dataset in the backend. The first file is available at https://keepthereceipts.org.za/?implementation_location_province=Free+State&buyer_name=Free+State+Department+of+Health so long.

[tristynferreiro]

Uploaded table 2

[tristynferreiro]

Uploaded table 3

[tristynferreiro]

uploaded table 4

[tristynferreiro]

uploaded table 5

[tristynferreiro]

uploaded table 6

[tristynferreiro]

uploaded table 7