names

6 rows where place_id = 803954

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: surname, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
4800391 2296302 2296302 defendant Sydelok John barber 803954 803954 together with Sydelok, John, of Harlyngdon, Beds, barber 3
4915903 2331468 2331468 defendant Martyn William husbandman 803954 803954 Martyn, William, of Harlyngdon, Beds, husbandman 0
4961361 2345364 2345364 defendant Blundell John gent 803954 803954 Blundell, John, of Harlyngdon, Beds, gent 0
5031431 2366049 2366049 defendant Aclee Edmund yeoman 803954 803954 Aclee, Edmund, of Harlyngdon, Beds, yeoman 0
5271879 2436861 2436861 defendant Bygby John husbandman 803954 803954 Bygby, John, of Harlyngdon, Beds, husbandman 13
5318585 2450653 2450653 defendant Blundell John, junior husbandman 803954 803954 Blundell, John, junior, of Harlyngdon, Beds, husbandman 1

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

CREATE TABLE names (
    id INTEGER PRIMARY KEY AUTOINCREMENT,
    case_id INTEGER NOT NULL REFERENCES cases(id) ON DELETE CASCADE,
    role TEXT NOT NULL CHECK (role IN ('plaintiff', 'defendant')),
    surname TEXT NOT NULL,
    forename TEXT,
    occupation TEXT,
    place_id INTEGER REFERENCES places(id),
    raw_segment TEXT NOT NULL,
    seq INTEGER NOT NULL DEFAULT 0
);
CREATE INDEX idx_names_case_id ON names(case_id);
CREATE INDEX idx_names_surname ON names(surname);
CREATE INDEX idx_names_place_id ON names(place_id);
CREATE INDEX idx_names_role_surname ON names(role, surname);