names

29 rows where place_id = 612130

✎ 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
3691725 1923572 1923572 defendant Atkynson Robert husbandman 612130 612130 Atkynson, Robert, of Bagby, husbandman 0
3927440 1999523 1999523 defendant Wright William yeoman 612130 612130 Wright, William, of Bagby, yeoman 0
4002386 2025629 2025629 defendant Hodge Agnes widow 612130 612130 Hodge, Agnes, of Bagby, widow 0
4035037 2037213 2037213 defendant Hodge Agnes widow 612130 612130 Hodge, Agnes, of Bagby, widow 0
4133694 2072385 2072385 defendant Chapman William yeoman 612130 612130 Chapman, William, of Bagby, yeoman 0
4319646 2136985 2136985 defendant Wright John yeoman 612130 612130 Wright, John, of Bagby, yeoman 0
4319647 2136985 2136985 defendant Mounckton John yeoman 612130 612130 Mounckton, John, of Bagby, yeoman 1
4319648 2136985 2136985 defendant Mounckton Katherine widow 612130 612130 Mounckton, Katherine, of Bagby, widow 2
4405320 2166358 2166358 defendant Carver William husbandman 612130 612130 Carver, William, of Bagby, husbandman 3
4405324 2166359 2166359 defendant More John tailor 612130 612130 More, John, of Bagby, tailor 2
4405333 2166361 2166361 defendant Ridesdell William, junior weaver 612130 612130 Ridesdell, William, junior, of Bagby, weaver 1
4651408 2246445 2246445 defendant Beweser William walker 612130 612130 Beweser, William, of Bagby, walker 3
4747663 2279824 2279824 defendant Dale William   612130 612130 Dale, William, of Bagby, cartwright 0
4773707 2287753 2287753 defendant Dale William   612130 612130 Dale, William, of Bagby, wheel wright 0
4808749 2298903 2298903 defendant Wilcok Richard husbandman 612130 612130 Wilcok, Richard, of Bagby, husbandman 1
4808750 2298903 2298903 defendant Jakeson John husbandman 612130 612130 Jakeson, John, of Bagby, husbandman 2
4822029 2302964 2302964 defendant Wylcok Richard husbandman 612130 612130 Wylcok, Richard, of Bagby, husbandman 0
4822030 2302964 2302964 defendant Dale William carpenter 612130 612130 Dale, William, of Bagby, carpenter 1
4947030 2341066 2341066 plaintiff Laton John   612130 612130 Laton, John, of Bagby 0
5020835 2362990 2362990 defendant Byngham William gent 612130 612130 Byngham, William, of Bagby, gent 2
5022418 2363456 2363456 defendant Mylner John chaplain 612130 612130 Mylner, John, of Bagby, chaplain 0
5051887 2372177 2372177 defendant Mareschall Thomas gent 612130 612130 Mareschall, Thomas, of Bagby, gent 1
5108141 2388818 2388818 defendant Laweson William husbandman 612130 612130 Laweson, William, of Bagby, husbandman 1
5222011 2422142 2422142 defendant Johnson Thomas yeoman 612130 612130 Johnson, Thomas, of Bagby, yeoman 2
5251064 2430438 2430438 defendant Balk Robert husbandman 612130 612130 Balk, Robert, of Bagby, husbandman 2
5341965 2457676 2457676 defendant Smelt Thomas chaplain 612130 612130 Smelt, Thomas, of Bagby, chaplain 0
5385074 2470806 2470806 defendant Wright William yeoman 612130 612130 Wright, William, of Bagby, yeoman 2
5517445 2510298 2510298 defendant Ben William chaplain 612130 612130 Ben, William, of Bagby, chaplain 0
5527201 2513084 2513084 defendant Pygott Thomas gent 612130 612130 Pygott, Thomas, of Bagby, gent 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);