names

35 rows where place_id = 593407

✎ 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
3611680 1871317 1871317 defendant Twygge John husbandman 593407 593407 Twygge, John, of Lawhitton, husbandman 6
3611682 1871317 1871317 defendant Tylham John husbandman 593407 593407 Tylham, John, of Lawhitton, husbandman 8
3611689 1871318 1871318 defendant Wille Richard husbandman 593407 593407 Wille, Richard, of Lawhitton, husbandman 5
3611690 1871318 1871318 defendant Twygge John husbandman 593407 593407 Twygge, John, of Lawhitton, husbandman 6
3611692 1871318 1871318 defendant Tylham John husbandman 593407 593407 Tylham, John, of Lawhitton, husbandman 8
3832842 1968196 1968196 defendant Swen John husbandman 593407 593407 Swen, John, of Lawhitton, husbandman 1
3832843 1968196 1968196 defendant Collyn John carver 593407 593407 Collyn, John, of Lawhitton, carver 2
3832844 1968196 1968196 defendant Tulley Richard husbandman 593407 593407 Tulley, Richard, of Lawhitton, husbandman 3
3832845 1968196 1968196 defendant Toker Robert butcher 593407 593407 Toker, Robert, of Lawhitton, butcher 4
3832846 1968196 1968196 defendant Hyll John laborer 593407 593407 Hyll, John, of Lawhitton, laborer 5
3832847 1968196 1968196 defendant Toker John, senior husbandman 593407 593407 Toker, John, senior, of Lawhitton, husbandman 6
3832848 1968196 1968196 defendant Toker John, junior husbandman 593407 593407 Toker, John, junior, of Lawhitton, husbandman 7
3871765 1980793 1980793 defendant Braye William clerk 593407 593407 Braye, William, of Lawhitton, clerk 0
3947247 2006104 2006104 defendant Clatforth John husbandman 593407 593407 Clatforth, John, of Lawhitton, husbandman 0
3947249 2006105 2006105 defendant Collyn William husbandman 593407 593407 Collyn, William, of Lawhitton, husbandman 0
4028064 2034687 2034687 defendant Bligh Thomas husbandman 593407 593407 Bligh, Thomas, of Lawhitton, husbandman 2
4083867 2054503 2054503 defendant Dyngle Richard yeoman 593407 593407 Dyngle, Richard, of Lawhitton, yeoman 0
4085313 2055027 2055027 defendant Burnberye Mathew husbandman 593407 593407 Burnberye, Mathew, of Lawhitton, husbandman 2
4085317 2055028 2055028 defendant Burnberye Mathew husbandman 593407 593407 Burnberye, Mathew, of Lawhitton, husbandman 2
4085320 2055029 2055029 defendant Burnberie Mathew husbandman 593407 593407 Burnberie, Mathew, of Lawhitton, husbandman 1
4086616 2055501 2055501 defendant Byngle Richard husbandman 593407 593407 Byngle, Richard, of Lawhitton, husbandman 0
4086617 2055501 2055501 defendant Dodderidge William husbandman 593407 593407 Dodderidge, William, of Lawhitton, husbandman 1
4105900 2062401 2062401 defendant Helliar Nicholas husbandman 593407 593407 Helliar, Nicholas, of Lawhitton, husbandman 0
4111102 2064224 2064224 defendant Blighe Thomas husbandman 593407 593407 Blighe, Thomas, of Lawhitton, husbandman 0
4117616 2066596 2066596 defendant Burneberye Mathew husbandman 593407 593407 Burneberye, Mathew, of Lawhitton, husbandman 0
4172302 2085779 2085779 defendant Jackman John husbandman 593407 593407 Jackman, John, of Lawhitton, husbandman 1
4284488 2124501 2124501 defendant Brendon Thomas yeoman 593407 593407 Brendon, Thomas, of Lawhitton, yeoman 0
4313327 2134769 2134769 defendant Shere John yeoman 593407 593407 Shere, John, of Lawhitton, yeoman 0
5020444 2362865 2362865 defendant Beaton John husbandman 593407 593407 Beaton, John, of Lawhitton, husbandman 0
5029752 2365574 2365574 defendant Beaton John husbandman 593407 593407 Beaton, John, of Lawhitton, husbandman 0
5029754 2365575 2365575 defendant Beaton John husbandman 593407 593407 Beaton, John, of Lawhitton, husbandman 0
5033242 2366603 2366603 defendant Gotacre Peter butcher 593407 593407 Gotacre, Peter, of Lawhitton, butcher 5
5071112 2377853 2377853 defendant Beaton John husbandman 593407 593407 Beaton, John, of Lawhitton, husbandman 0
5251491 2430566 2430566 defendant Burnard William chaplain 593407 593407 Burnard, William, of Lawhitton, chaplain 0
5251492 2430566 2430566 defendant Come R- miller 593407 593407 Come, R-, of Lawhitton, miller 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);