judic
Queries
Tables
cantonal_law_sync_runs
id, started_at, finished_at, mode, rows_fetched, rows_new, rows_updated, rows_failed, status, error
5 rows
cantonal_laws
lexfind_id, canton, systematic_number, keywords, title, category, is_active, version_active_since, original_url, article_count, content_hash, json_path, fetch_status, last_fetch_attempt, downloaded_at, error_message
37 rows
decisions
decision_id, court, canton, chamber, docket_number, docket_number_2, decision_date, publication_date, language, title, legal_area, regeste, abstract_de, abstract_fr, abstract_it, full_text, outcome, decision_type, judges, clerks, collection, appeal_info, source_url, pdf_url, bge_reference, cited_decisions, scraped_at, external_id, source, source_id, source_spider, content_hash, has_full_text, text_length, Sachgebiet, Themen, Liste_Neuheiten, BGE_PublikationVorgesehen, erledigung, AnzahlRichter, local_json_path, imported_at, last_seen_at, from_delta, from_judic_scraper, judic_structured, judic_scraped_at, judic_raw_content, raw_html_path, Vorinstanz_Gericht, Vorinstanz_Kammer
238,986 rows
imported_deltas
delta_date, parquet_sha256, parquet_bytes, imported_at, rows_total, rows_inserted, rows_skipped
127 rows
judic_scraper_runs
id, started_at, finished_at, rows_listed, rows_new, rows_updated, rows_failed, status, error
99 rows
laws
sr_number, work_uri, consolidation_uri, consolidation_date, title_de, title_fr, title_it, abbr_de, abbr_fr, abbr_it, xml_path_de, xml_path_fr, xml_path_it, fetch_status, last_fetch_attempt, downloaded_at, error_message
560 rows
pipeline_runs
id, started_at, finished_at, file, rows_total, rows_new, rows_updated, status
236 rows
... and 7 hidden tables