names

20 rows where place_id = 626053

✎ 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
3767714 1947539 1947539 defendant Lofthouse William yeoman 626053 626053 Lofthouse, William, of Helagh, yeoman 1
3767715 1947539 1947539 defendant Lofthouse Thomas yeoman 626053 626053 Lofthouse, Thomas, of Helagh, yeoman 2
3782739 1952346 1952346 defendant Leke John yeoman 626053 626053 Leke, John, of Helagh, yeoman 0
3801880 1958486 1958486 defendant Lofthous Thomas yeoman 626053 626053 Lofthous, Thomas, of Helagh, yeoman 0
3801882 1958487 1958487 defendant Lofthous William yeoman 626053 626053 Lofthous, William, of Helagh, yeoman 0
3810812 1961283 1961283 defendant Soureby Thomas husbandman 626053 626053 Soureby, Thomas, of Helagh, husbandman 0
3822337 1964894 1964894 defendant Arundell Simon yeoman 626053 626053 Arundell, Simon, of Helagh, yeoman 1
3822338 1964894 1964894 defendant Arundell Anthony yeoman 626053 626053 Arundell, Anthony, of Helagh, yeoman 2
3856428 1975635 1975635 plaintiff Wryght John   626053 626053 Wryght, John, of Helagh 0
4659945 2248961 2248961 defendant Forster Robert yeoman 626053 626053 Forster, Robert, of Helagh, yeoman 0
4714354 2269819 2269819 defendant Wodde William husbandman 626053 626053 Wodde, William, of Helagh, husbandman 2
4714355 2269819 2269819 defendant Hoggeson Dawes Thomas yeoman 626053 626053 Hoggeson Dawes, Thomas, of Helagh, yeoman 3
4885706 2322406 2322406 defendant Pereson John yeoman 626053 626053 Pereson, John, of Helagh, yeoman 0
5265851 2435072 2435072 defendant Davy Robert yeoman 626053 626053 Davy, Robert, of Helagh, yeoman 1
5340916 2457356 2457356 defendant Burton John clerk 626053 626053 Burton, John, of Helagh, clerk 0
5340920 2457357 2457357 defendant Burton John clerk 626053 626053 Burton, John, of Helagh, clerk 0
5348039 2459526 2459526 defendant Wrygh Richard carpenter 626053 626053 Wrygh, Richard, of Helagh, carpenter 1
5364489 2464552 2464552 defendant Davy Robert gent 626053 626053 Davy, Robert, of Helagh, gent 1
5569585 2525670 2525670 defendant Turry Edmund husbandman 626053 626053 Turry, Edmund, of Helagh, husbandman 0
5569586 2525670 2525670 defendant Thexton John husbandman 626053 626053 Thexton, John, of Helagh, 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);