names

23 rows where place_id = 601452

✎ 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
3645394 1908967 1908967 defendant Machyn Ralph smith 601452 601452 Machyn, Ralph, of High Offeley, smith 0
3741052 1939064 1939064 defendant Colclough Richard husbandman 601452 601452 Colclough, Richard, of High Offeley, husbandman 2
3741057 1939065 1939065 defendant Snelston Edmund clerk 601452 601452 Snelston, Edmund, of High Offeley, clerk 0
3741058 1939065 1939065 defendant Grene Godfrey yeoman 601452 601452 Grene, Godfrey, of High Offeley, yeoman 1
3741059 1939065 1939065 defendant Leke John, senior yeoman 601452 601452 Leke, John, senior, of High Offeley, yeoman 2
3747898 1941265 1941265 defendant Cauke Roger husbandman 601452 601452 Cauke, Roger, of High Offeley, husbandman 3
3751460 1942374 1942374 defendant Machyn Ralph smith 601452 601452 Machyn, Ralph, of High Offeley, smith 0
3830920 1967555 1967555 defendant Machyn Thomas husbandman 601452 601452 Machyn, Thomas, of High Offeley, husbandman 0
3830921 1967555 1967555 defendant Gravenour Robert gent 601452 601452 Gravenour, Robert, of High Offeley, gent 1
3853555 1974737 1974737 defendant Cauke or Canke John yeoman 601452 601452 Cauke or Canke, John, of High Offeley, yeoman 0
3869474 1980031 1980031 defendant Machyn Thomas husbandman 601452 601452 Machyn, Thomas, of High Offeley, husbandman 1
3875936 1982206 1982206 defendant Machyn Thomas husbandman 601452 601452 Machyn, Thomas, of High Offeley, husbandman 0
3875937 1982206 1982206 defendant Saunders Francis husbandman 601452 601452 Saunders, Francis, of High Offeley, husbandman 1
3875938 1982206 1982206 defendant Ithell David husbandman 601452 601452 Ithell, David, of High Offeley, husbandman 2
3875939 1982206 1982206 defendant Heycocke Thomas husbandman 601452 601452 Heycocke, Thomas, of High Offeley, husbandman 3
3977762 2016791 2016791 defendant Huntbache Michael husbandman 601452 601452 Huntbache, Michael, of High Offeley, husbandman 0
3999379 2024537 2024537 defendant Wright Thomas yeoman 601452 601452 Wright, Thomas, of High Offeley, yeoman 0
3999381 2024538 2024538 defendant Wright Thomas yeoman 601452 601452 Wright, Thomas, of High Offeley, yeoman 0
4023330 2033053 2033053 defendant Selete Humphrey shoemaker 601452 601452 Selete, Humphrey, of High Offeley, shoemaker 0
4024531 2033450 2033450 defendant Saunders Nicholas yeoman 601452 601452 Saunders, Nicholas, of High Offeley, yeoman 1
5066791 2376595 2376595 defendant Harries William laborer 601452 601452 Harries, William, of High Offeley, laborer 0
5529946 2513868 2513868 defendant Wade Thomas chaplain 601452 601452 Wade, Thomas, of High Offeley, chaplain 0
5529948 2513868 2513868 defendant Perkyn Richard tailor 601452 601452 Perkyn, Richard, of High Offeley, tailor 2

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