names

28 rows where place_id = 610232

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3682596 1920660 1920660 defendant Malori Anthony esq 610232 610232 Malori, Anthony, of Bassyngborn, esq 1
3885067 1985266 1985266 defendant Pake Philip husbandman 610232 610232 Pake, Philip, of Bassyngborn, husbandman 1
3889936 1986871 1986871 defendant Dewys John (legal representative) 610232 610232 Dewys, John, of Bassyngborn, clerk, executor of 0
3906179 1992358 1992358 defendant Broun William husbandman 610232 610232 Broun, William, of Bassyngborn, husbandman 0
3912033 1994349 1994349 defendant Pynke Robert husbandman 610232 610232 Pynke, Robert, of Bassyngborn, husbandman 0
3912034 1994349 1994349 defendant Pratte John carpenter 610232 610232 Pratte, John, of Bassyngborn, carpenter 1
3919906 1996991 1996991 defendant Good William husbandman 610232 610232 Good, William, of Bassyngborn, husbandman 1
3919910 1996993 1996993 defendant Pratt John husbandman 610232 610232 Pratt, John, of Bassyngborn, husbandman 0
4024643 2033492 2033492 plaintiff Bolnest William   610232 610232 Bolnest, William, of Bassyngborn 0
4300285 2130201 2130201 defendant Waller Richard yeoman 610232 610232 Waller, Richard, of Bassyngborn, yeoman 1
4410519 2168110 2168110 defendant Pilgrym Walter yeoman 610232 610232 Pilgrym, Walter, of Bassyngborn, yeoman 0
4410520 2168110 2168110 defendant Pilgrym William yeoman 610232 610232 Pilgrym, William, of Bassyngborn, yeoman 1
4410521 2168110 2168110 defendant Everyte Robert husbandman 610232 610232 Everyte, Robert, of Bassyngborn, husbandman 2
4410522 2168110 2168110 defendant Killett Henry husbandman 610232 610232 Killett, Henry, of Bassyngborn, husbandman 3
4458213 2187608 2187608 defendant Hale Simon   610232 610232 Hale, Simon, of Bassyngborn 2
4609115 2233957 2233957 defendant Bate John   610232 610232 Bate, John, of Bassyngborn 1
4955816 2343709 2343709 defendant Angetyn George husbandman 610232 610232 Angetyn, George, of Bassyngborn, husbandman 0
4976417 2349909 2349909 defendant Swan Edmund laborer 610232 610232 Swan, Edmund, of Bassyngborn, laborer 1
5100852 2386664 2386664 defendant Benet William yeoman 610232 610232 Benet, William, of Bassyngborn, yeoman 1
5100854 2386664 2386664 defendant Ramerwyke John thatcher 610232 610232 Ramerwyke, John, of Bassyngborn, thatcher 3
5100855 2386664 2386664 defendant Nevyll John thatcher 610232 610232 Nevyll, John, of Bassyngborn, thatcher 4
5358486 2462709 2462709 defendant Lyon John husbandman 610232 610232 (Lyon, John, of Bassyngborn, husbandman 1
5358487 2462709 2462709 defendant Baweberd John husbandman 610232 610232 Baweberd, John, of Bassyngborn, husbandman 2
5419848 2480852 2480852 defendant Lovell Roger smith 610232 610232 Lovell, Roger, of Bassyngborn, smith 1
5470426 2496076 2496076 plaintiff Gery Thomas   610232 610232 Gery, Thomas, of Bassyngborn 0
5487395 2501124 2501124 plaintiff Tadlowe Thomas   610232 610232 Tadlowe, Thomas, of Bassyngborn 0
5505403 2506604 2506604 plaintiff Bolnest Robert yeoman 610232 610232 Bolnest, Robert, of Bassyngborn, yeoman 0
5563170 2523826 2523826 defendant Bentley John husbandman 610232 610232 Bentley, John, of Bassyngborn, husbandman 0

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