Moscow City Court Cases

Moscow City Court Cases brings Moscow courts data to your Mac: search and browse matters against a local SQLite database, with optional saving of materials to disk.

Built for people who work with Moscow courts’ open data: attach a SQLite DB, filter across many fields, and open a rich case card with parties, dates, and attachments — without endless manual website hopping.

Who it is for

• Lawyers and paralegals who need fast filtering by case number, judge, court, article, parties, and dates.
• Analysts, journalists, and researchers working large extracts who want data on their machine.
• Anyone already downloading or assembling JSON/SQLite dumps of Moscow court cases for unified viewing.

Two ways to load data

• Open an existing .sqlite3 file (or folder containing it).
• Create a DB from JSON — import and convert to SQLite for ongoing use.

Three-column UI

Search panel → result list → detailed card (number, court, judge, articles, statuses, hearing dates, parties, documents).

Powerful search

Party, case number, court picklists, court code, judge (scoped to court), article, document type, year, plus advanced filters (UID, publication status, attachment title, instance, proceeding type, category, registration/closing date ranges). Pattern helpers (*, %) support prefix, substring, and tighter patterns.

Documents

Open links from the case card; download one matter, everything in the current result set, or bulk flows with a target folder and document-type filters where the downloader exposes them.

Settings

Sections for database, import (including open-data sources), general options, and appearance.

Progress feedback

Spinners, progress, and status text so you can see DB queries vs batch downloads.

Important

• Local data only — this does not replace the official court site; it reads your attached or imported database.
• Freshness and coverage depend on the files you load.
• Platform: the primary shipped workflow targets macOS; the separate iOS target is not presented here as a finished product.

Getting started

1. Prepare a SQLite file or JSON export of cases.
2. In the app choose “Open database” or “Create database from JSON”.
3. Set search criteria, pick a row, and save documents to a folder if needed.