convert_from_minspeiding_to_csv.py

import json
import csv

with open('participants-roverway.json') as json_file:
    data = json.load(json_file)

participant_data = data['participants']
participant_data_labels = data['labels']


out_file = open('participantspathid.csv', 'w', newline='')
csv_writer = csv.writer(out_file)


csv_writer.writerow([
    'member_no',
    'first_name',
    'last_name',
    'patrol_id',
    'patrol_name',
    'group_id',
    'group_name',
    'fee'
])

for member in participant_data:
    if participant_data[member]['cancelled'] == False:
        participant = [
            participant_data[member]['member_no'],
            participant_data[member]['first_name'],
            participant_data[member]['last_name'],
            participant_data[member]['patrol_id'],
            participant_data[member]['patrol_name'],
            participant_data[member]['group_id'],
            participant_data[member]['group_name'],
            participant_data[member]['fee_id'],
        ]
        csv_writer.writerow(participant)

out_file.close()