names

30 rows where place_id = 600405

✎ 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
3640920 1907604 1907604 defendant Paynter John butcher 600405 600405 Paynter, John, of Stoke juxta Ipswich, butcher 0
3681523 1920312 1920312 defendant Pone John glover 600405 600405 Pone, John, of Stoke juxta Ipswich, glover 0
3812420 1961775 1961775 defendant Cady John husbandman 600405 600405 Cady, John, of Stoke juxta Ipswich, husbandman 0
3901841 1990839 1990839 defendant Byles Edward laborer 600405 600405 Byles, Edward, of Stoke juxta Ipswich, laborer 0
3908811 1993241 1993241 defendant Leygood William   600405 600405 Leygood, William, of Stoke juxta Ipswich, wheelwright 0
4214612 2100616 2100616 defendant Garthe Ralph clerk 600405 600405 Garthe, Ralph, of Stoke juxta Ipswich, clerk 2
4246841 2111920 2111920 defendant Manne John yeoman 600405 600405 Manne, John, of Stoke juxta Ipswich, yeoman 1
4250684 2113208 2113208 defendant Cantrell William gent 600405 600405 Cantrell, William, of Stoke juxta Ipswich, gent 1
4303138 2131226 2131226 defendant Pattinson John bricklayer 600405 600405 Pattinson, John, of Stoke juxta Ipswich, bricklayer 2
4303140 2131226 2131226 defendant Allen Thomas yeoman 600405 600405 Allen, Thomas, of Stoke juxta Ipswich, yeoman 4
4781771 2290314 2290314 defendant Smyth Robert smith 600405 600405 Smyth, Robert, of Stoke juxta Ipswich, smith 0
4861854 2315085 2315085 defendant Andrewe James esq 600405 600405 Andrewe, James, of Stoke juxta Ipswich, esq 0
4867976 2316951 2316951 defendant Andrewe James gent 600405 600405 Andrewe, James, of Stoke juxta Ipswich, gent 0
4889562 2323530 2323530 defendant Andrewe John gent 600405 600405 Andrewe, John, of Stoke juxta Ipswich, gent 0
4898283 2326125 2326125 defendant Andrewe William gent 600405 600405 Andrewe, William, of Stoke juxta Ipswich, gent 0
4898284 2326125 2326125 defendant Andrewe Thomas gent 600405 600405 Andrewe, Thomas, of Stoke juxta Ipswich, gent 1
4898285 2326125 2326125 defendant Margery John yeoman 600405 600405 Margery, John, of Stoke juxta Ipswich, yeoman 2
4898286 2326125 2326125 defendant Castell Reginald   600405 600405 together with Castell, Reginald, of Stoke juxta Ipswich, wheelwright 3
4898287 2326125 2326125 defendant Abbrede Robert fuller 600405 600405 Abbrede, Robert, of Stoke juxta Ipswich, fuller 4
4898288 2326125 2326125 defendant Fennyng John, junior   600405 600405 Fennyng, John, junior, of Stoke juxta Ipswich, servant 5
4963275 2345927 2345927 defendant Fox Nicholas fuller 600405 600405 Fox, Nicholas, of Stoke juxta Ipswich, fuller 0
4963276 2345927 2345927 defendant Pypho Thomas   600405 600405 Pypho, Thomas, of Stoke juxta Ipswich, tile maker 1
4963277 2345927 2345927 defendant Broun Margaret widow 600405 600405 Broun, Margaret, of Stoke juxta Ipswich, widow 2
4963278 2345927 2345927 defendant Smyth John smith 600405 600405 Smyth, John, of Stoke juxta Ipswich, smith 3
5012978 2360629 2360629 defendant Sextayn John husbandman 600405 600405 Sextayn, John, of Stoke juxta Ipswich, husbandman 3
5265273 2434899 2434899 defendant Canonn John husbandman 600405 600405 Canonn, John, of Stoke juxta Ipswich, husbandman 0
5289010 2441793 2441793 defendant Wyndesore Thomas smith 600405 600405 Wyndesore, Thomas, of Stoke juxta Ipswich, smith 0
5490211 2501956 2501956 defendant Smyth Thomas husbandman 600405 600405 Smyth, Thomas, of Stoke juxta Ipswich, husbandman 0
5490213 2501957 2501957 defendant Smyth Thomas husbandman 600405 600405 Smyth, Thomas, of Stoke juxta Ipswich, husbandman 0
5596137 2533708 2533708 plaintiff Cady Thomas yeoman 600405 600405 Cady, Thomas, of Stoke juxta Ipswich, yeoman 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);