judic
Queries
Tables
cantonal_law_sync_runs
id, started_at, finished_at, mode, rows_fetched, rows_new, rows_updated, rows_failed, status, error
13 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
239 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, Abteilung
256,125 rows
imported_deltas
delta_date, parquet_sha256, parquet_bytes, imported_at, rows_total, rows_inserted, rows_skipped
178 rows
judic_scraper_runs
id, started_at, finished_at, rows_listed, rows_new, rows_updated, rows_failed, status, error
143 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
1,011 rows
pipeline_runs
id, started_at, finished_at, file, rows_total, rows_new, rows_updated, status
440 rows
... and 7 hidden tables