names

24 rows where place_id = 725344

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
4260817 2116582 2116582 defendant Pryce Philip   725344 725344 Pryce, Philip, of Louther 1
4455462 2186711 2186711 plaintiff Milner Richard   725344 725344 Milner, Richard, of Louther 0
4455464 2186712 2186712 plaintiff Milner Richard   725344 725344 Milner, Richard, of Louther 0
4457225 2187269 2187269 defendant del Milne Richard   725344 725344 del Milne, Richard, of Louther 0
4457229 2187270 2187270 defendant Milne Richard del   725344 725344 Milne, Richard del, of Louther 0
4721278 2271987 2271987 plaintiff Scanceby Thomas master & parson 725344 725344 Scanceby, Thomas, of Louther, master & parson 3
4834442 2306779 2306779 defendant Carter Richard yeoman 725344 725344 Carter, Richard, of Louther, yeoman 2
5041368 2369028 2369028 plaintiff Cleveland Thomas   725344 725344 Cleveland, Thomas, of Louther, parson 0
5172570 2407703 2407703 defendant Baudewyn William   725344 725344 Baudewyn, William, of Louther 10
5172574 2407703 2407703 defendant Alcok John   725344 725344 Alcok, John, of Louther 14
5172575 2407703 2407703 defendant Clerk John   725344 725344 Clerk, John, of Louther 15
5419667 2480799 2480799 defendant Jakson William yeoman 725344 725344 Jakson, William, of Louther, yeoman 1
5419668 2480799 2480799 defendant Marchall Gilbert yeoman 725344 725344 Marchall, Gilbert, of Louther, yeoman 2
5419669 2480799 2480799 defendant Thomson John yeoman 725344 725344 Thomson, John, of Louther, yeoman 3
5419670 2480799 2480799 defendant Thomson William yeoman 725344 725344 Thomson, William, of Louther, yeoman 4
5419671 2480799 2480799 defendant Chapelhowe William yeoman 725344 725344 Chapelhowe, William, of Louther, yeoman 5
5438115 2486335 2486335 defendant Jakson William yeoman 725344 725344 Jakson, William, of Louther, yeoman 1
5438116 2486335 2486335 defendant Marchall Gilbert yeoman 725344 725344 Marchall, Gilbert, of Louther, yeoman 2
5438117 2486335 2486335 defendant Thomson John yeoman 725344 725344 Thomson, John, of Louther, yeoman 3
5438118 2486335 2486335 defendant Thomson William yeoman 725344 725344 Thomson, William, of Louther, yeoman 4
5438119 2486335 2486335 defendant Chapelhowe William yeoman 725344 725344 Chapelhowe, William, of Louther, yeoman 5
5438122 2486336 2486336 defendant Marchall Gilbert yeoman 725344 725344 Marchall, Gilbert, of Louther, yeoman 1
5438123 2486336 2486336 defendant Thomson John yeoman 725344 725344 Thomson, John, of Louther, yeoman 2
5438124 2486336 2486336 defendant Thomson William yeoman 725344 725344 Thomson, William, of Louther, yeoman 3

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);