[Answer]-Importing csv data in python

A 500 HTTP response code is a problem with the server not on your end:

Response status codes beginning with the digit “5” indicate cases in
which the server is aware that it has erred or is incapable of
performing the request. Except when responding to a HEAD request, the
server SHOULD include an entity containing an explanation of the error
situation, and whether it is a temporary or permanent condition. User
agents SHOULD display any included entity to the user. These response
codes are applicable to any request method.

FWIW, it may work out better for you to pull down the entires page with a page = response.read() and then loop over the lines after retrieval using cr = csv.reader(page.splitlines(), delimiter=';', quotechar='"').

500 is Internal Server Error, which means either the security settings are blocking the access or the database is corrupt and you are not able to read. Check the security settings and see if you are able to query the DB through website.