script to get pypi package events (last 100k)

get_pypi_events.py

import datetime
import xmlrpc.client
import csv

client = xmlrpc.client.ServerProxy('https://pypi.org/pypi')
serial = client.changelog_last_serial()
serial = serial - 50000
events = client.changelog_since_serial(serial)
with open('events.csv', 'w+', newline='') as csvfile:
    csvwriter = csv.writer(csvfile)
    csvwriter.writerow(['package_name', 'package_version', 'date', 'event'])
    for package_name, package_version, timestamp, event, _ in events[::-1]:
        date = datetime.datetime.fromtimestamp(timestamp)
        date = date.strftime('%Y-%m-%d')
        csvwriter.writerow([package_name, package_version, date, event])