Skip to content

mirror database

Latest
Compare
Choose a tag to compare
@ErikOrtmann ErikOrtmann released this 03 Sep 20:56
· 81 commits to main since this release

This is a sqlite3 database including oparl objects until 27.07.2023.

To imitate a oparl scraping process start with following sql-statement:
"SELECT data FROM mirror WHERE id=https://ratsinformation.leipzig.de/allris_leipzig_public/oparl/papers?body=2387&page=1"

It contains a single table called 'mirror' with two columns:
"id" is the id from an oparl object or the link from a paper pagination.
"data" contains raw bytestring interpretable as json object.

Contains:

  • papers as page
  • organizations
  • persons
  • memberships ,locations, consultations and mainFiles as part of the above objects

Objects that have a "deleted: True" attribute were not stored in the db.
If a db querry is empty a deleted object can be created like: {id: url, deleted: True}.