names

12 rows where place_id = 674527

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, surname, forename, occupation, raw_segment, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
4014411 2029877 2029877 plaintiff Sekerston Ralph   674527 674527 Sekerston, Ralph, of Liverpool 0
4014413 2029878 2029878 plaintiff Sekerston Ralph merchant 674527 674527 Sekerston, Ralph, of Liverpool, merchant 0
4014416 2029879 2029879 plaintiff Sekerston Ralph merchant 674527 674527 Sekerston, Ralph, of Liverpool, merchant 0
4014419 2029880 2029880 plaintiff Sekerston Ralph merchant 674527 674527 Sekerston, Ralph, of Liverpool, merchant 0
4051706 2043028 2043028 defendant Mellynge Ralph chapman 674527 674527 Mellynge, Ralph, of Liverpool, chapman 1
4077223 2052139 2052139 defendant Baven Thomas chapman 674527 674527 Baven, Thomas, of Liverpool, chapman 0
4084101 2054587 2054587 defendant Roose Roger yeoman 674527 674527 Roose, Roger, of Liverpool, yeoman 1
4288688 2126009 2126009 defendant Hodson or Hodgson Richard merchant 674527 674527 Hodson or Hodgson, Richard, of Liverpool, merchant 1
4289803 2126413 2126413 defendant Croose Ralph   674527 674527 Croose, Ralph, of Liverpool, gent, his son 1
4508452 2203125 2203125 defendant Seacome Robert   674527 674527 Seacome, Robert, of Liverpool 2
4541922 2213362 2213362 defendant Derby Robert de   674527 674527 Derby, Robert de, of Liverpool 1
4604303 2232516 2232516 defendant Derby Robert de   674527 674527 Derby, Robert de, of Liverpool 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);