names

28 rows where place_id = 586579

✎ 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
3589089 1864235 1864235 defendant Cokkys Richard laborer 586579 586579 Cokkys, Richard, of Balsall, laborer 0
3671609 1917105 1917105 plaintiff Coldale Robert   586579 586579 Coldale, Robert, of Balsall 0
3671611 1917106 1917106 plaintiff Coldale Robert   586579 586579 Coldale, Robert, of Balsall 0
3688839 1922669 1922669 plaintiff Dokwra Martin gent 586579 586579 Dokwra, Martin, of Balsall, gent 0
3690818 1923293 1923293 defendant Docwra Martin gent 586579 586579 Docwra, Martin, of Balsall, gent 0
3690820 1923294 1923294 defendant Docwra Martin gent 586579 586579 Docwra, Martin, of Balsall, gent 0
3796025 1956619 1956619 defendant Ebrall Philip husbandman 586579 586579 Ebrall, Philip, of Balsall, husbandman 2
3796026 1956619 1956619 defendant Clerk John, junior husbandman 586579 586579 Clerk, John, junior, of Balsall, husbandman 3
3796027 1956619 1956619 defendant Ferrour Thomas husbandman 586579 586579 Ferrour, Thomas, of Balsall, husbandman 4
3796028 1956619 1956619 defendant Ebrall Thomas husbandman 586579 586579 Ebrall, Thomas, of Balsall, husbandman 5
3796029 1956619 1956619 defendant Marsshe Thomas husbandman 586579 586579 Marsshe, Thomas, of Balsall, husbandman 6
3796030 1956619 1956619 defendant Berwell John husbandman 586579 586579 Berwell, John, of Balsall, husbandman 7
3797720 1957185 1957185 defendant Belamye Thomas   586579 586579 Belamye, Thomas, of Balsall, wheelwright 2
3813142 1962021 1962021 defendant Bryan Thomas husbandman 586579 586579 Bryan, Thomas, of Balsall, husbandman 0
3813143 1962021 1962021 defendant Bayly Edmund husbandman 586579 586579 Bayly, Edmund, of Balsall, husbandman 1
3813145 1962022 1962022 defendant Bryan Thomas husbandman 586579 586579 Bryan, Thomas, of Balsall, husbandman 0
3813147 1962022 1962022 defendant Horborn John husbandman 586579 586579 Horborn, John, of Balsall, husbandman 2
3813148 1962022 1962022 defendant Ede John husbandman 586579 586579 Ede, John, of Balsall, husbandman 3
3813156 1962025 1962025 plaintiff Docwray Martin gent 586579 586579 Docwray, Martin, of Balsall, gent 0
3945726 2005580 2005580 defendant Herre Walter yeoman 586579 586579 Herre, Walter, of Balsall, yeoman 0
3956924 2009489 2009489 defendant Synderford Geoffrey gent 586579 586579 Synderford, Geoffrey, of Balsall, gent 1
4026283 2034045 2034045 defendant Farre Giles yeoman 586579 586579 Farre, Giles, of Balsall, yeoman 0
4153163 2079205 2079205 defendant Whateley William joiner 586579 586579 Whateley, William, of Balsall, joiner 0
4153164 2079205 2079205 defendant Whateley Isabel widow 586579 586579 Isabel his wife, alias Isabel Meisy, of Balsall, widow 1
4161535 2082106 2082106 defendant Coles John yeoman 586579 586579 Coles, John, of Balsall, yeoman 3
4187483 2091121 2091121 defendant Hayward Richard cardmaker 586579 586579 Hayward, Richard, of Balsall, cardmaker 0
4187484 2091121 2091121 defendant Horborne Lawrence (legal representative) 586579 586579 Horborne, Lawrence, of Balsall, yeoman, executrix of 1
4295087 2128325 2128325 defendant Paynter Thomas yeoman 586579 586579 Paynter, Thomas, of Balsall, yeoman 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);