jq -r '.[] | [.id, .name, .population, .allegiance_id] | @csv' systems_populated.json >systems.csv
jq -r '.[] | [.id] + (.minor_faction_presences[] | [.minor_faction_id, .influence]) | @csv' systems_populated.json > minor-faction-presences.csv