names

18 rows where place_id = 597560

✎ 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
3629019 1903952 1903952 defendant Smyth Thomas husbandman 597560 597560 Smyth, Thomas, of Basford, husbandman 0
3662045 1914064 1914064 defendant Launde John yeoman 597560 597560 Launde, John, of Basford, yeoman 1
3674240 1917984 1917984 defendant Cowley William husbandman 597560 597560 Cowley, William, of Basford, husbandman 0
3693448 1924165 1924165 defendant Laundy John husbandman 597560 597560 Laundy, John, of Basford, husbandman 4
3724618 1933982 1933982 defendant Laundy John husbandman 597560 597560 Laundy, John, of Basford, husbandman 1
3724837 1934054 1934054 plaintiff Scott John (legal representative) 597560 597560 Scott, John, of Basford, yeoman, administrator of 0
3745651 1940547 1940547 defendant Smelley Robert miller 597560 597560 Smelley, Robert, of Basford, miller 0
3767670 1947526 1947526 defendant Veysy Thomas yeoman 597560 597560 Veysy, Thomas, of Basford, yeoman 1
3827123 1966345 1966345 defendant Poley Thomas gent 597560 597560 Poley, Thomas, of Basford, gent 0
3914640 1995239 1995239 defendant Hallam Roger husbandman 597560 597560 Hallam, Roger, of Basford, husbandman 0
3921948 1997685 1997685 plaintiff Rasche Richard   597560 597560 Rasche, Richard, of Basford, administrators of 0
4570469 2222337 2222337 defendant Rysley Johnn   597560 597560 Rysley, Johnn, of Basford 4
4607458 2233441 2233441 defendant Dall John   597560 597560 Dall, John, of Basford 3
5100728 2386638 2386638 defendant Posford Thomas husbandman 597560 597560 Posford, Thomas, of Basford, husbandman 1
5569733 2525720 2525720 defendant Tencrey John yeoman 597560 597560 Tencrey, John,of Basford, yeoman 0
5591486 2532310 2532310 defendant Betesfeld John yeoman 597560 597560 Betesfeld, John, of Basford, yeoman 0
5591487 2532310 2532310 defendant Webstar John laborer 597560 597560 Webstar, John, of Basford, laborer 1
5591488 2532310 2532310 defendant Marsche Thomas weaver 597560 597560 Marsche, Thomas, of Basford, weaver 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);