import requests
import csv

r = requests.get('https://api.db.nomics.world/v22/providers/').json()

data = []
for item in r['providers']['docs']:
    item = (item['code'], item['region'],
            item['website'], item['converted_at'][0:10], item['name'], f"https://db.nomics.world/{item['code']}")
    data.append(item)

final = []
for item in data:
    final.append(item)

with open('output.csv', 'w+', newline='') as file:
    writer = csv.writer(file)
    writer.writerow(['Name', 'Region', 'Website',
                     'Updated by DBnomics on', 'Dataset Name', 'Link'])
    writer.writerows(data)
    print("Operation Completed")