home

judic

Custom SQL query

Tables

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

211,216 rows

imported_deltas

delta_date, parquet_sha256, parquet_bytes, imported_at, rows_total, rows_inserted, rows_skipped

78 rows

judic_scraper_runs

id, started_at, finished_at, rows_listed, rows_new, rows_updated, rows_failed, status, error

4 rows

pipeline_runs

id, started_at, finished_at, file, rows_total, rows_new, rows_updated, status

33 rows

sqlite_sequence

name, seq

2 rows

... and 1 hidden table

Powered by Datasette · Queries took 5.373ms