cp40x

Custom SQL query

Queries

Tables

cases

id, roll_id, side, roll_number, image, county, case_type, plaintiff, defendant, source_row, source_file, roll_label, term, year, monarch, source_downloaded_at

Many rows

import_log

id, source_file, status, message, rows_imported, logged_at

576 rows

names

id, case_id, role, surname, forename, occupation, place_id, raw_segment, seq

Many rows

places

id, place_name, place_norm, locality, county, flags

238,900 rows

rolls

id, source_file, roll_label, term, year, indexed_by, alphabet_slice, row_count, imported_at, monarch, aalt_roll_url, source_downloaded_at

138 rows

sqlite_sequence

name, seq

5 rows