names

15 rows where place_id = 634784

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3821341 1964566 1964566 defendant Smyth Hugh smith 634784 634784 Smyth, Hugh, of Odyngley, smith 1
3834476 1968728 1968728 defendant Kempstowe William clerk 634784 634784 Kempstowe, William, of Odyngley, clerk 2
3895486 1988698 1988698 defendant Kempstowe William clerk 634784 634784 Kempstowe, William, of Odyngley, clerk 5
4091605 2057289 2057289 defendant Yarnold Robert husbandman or yeoman 634784 634784 Yarnold, Robert, of Odyngley, husbandman or yeoman 0
4091608 2057290 2057290 defendant Yarnold Robert yeoman 634784 634784 Yarnold, Robert, of Odyngley, yeoman 0
4323523 2138287 2138287 defendant Bartlam alias Sale Thomas yeoman 634784 634784 Bartlam alias Sale, Thomas, of Odyngley, yeoman 0
4326283 2139157 2139157 defendant Atwall Nicholas husbandman 634784 634784 Atwall, Nicholas, of Odyngley, husbandman 0
4326285 2139157 2139157 defendant Hemynge James yeoman 634784 634784 Hemynge, James, of Odyngley, yeoman 2
4326312 2139165 2139165 defendant Yearnold Robert yeoman 634784 634784 Yearnold, Robert, of Odyngley, yeoman 2
4326313 2139165 2139165 defendant Hepton Walter clerk 634784 634784 Hepton, Walter, of Odyngley, clerk 3
4349871 2147215 2147215 defendant Tomlynson John yeoman 634784 634784 Tomlynson, John, of Odyngley, or of Greves Lane, Notts, yeoman 0
4389006 2160955 2160955 defendant Bartlan alias Sele Thomas yeoman 634784 634784 Bartlan alias Sele, Thomas, of Odyngley, yeoman 1
4668428 2255837 2255837 defendant More John   634784 634784 More, John, of Odyngley, son of Roger More 4
5557145 2522048 2522048 defendant Broke John husbandman 634784 634784 Broke, John, of Odyngley, husbandman 0
5557146 2522048 2522048 defendant Broke Richard husbandman 634784 634784 Broke, Richard, of Odyngley, 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);