names

28 rows where place_id = 598688

✎ 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
3633595 1905320 1905320 defendant Hudson Henry yeoman 598688 598688 Hudson, Henry, of Unthank, yeoman 0
4561261 2219479 2219479 defendant Robynson Henry   598688 598688 Robynson, Henry, of Unthank 10
4561262 2219479 2219479 defendant del Feld Thomas   598688 598688 del Feld, Thomas, of Unthank 11
4561263 2219479 2219479 defendant Ledyman Wiliam   598688 598688 Ledyman, Wiliam, of Unthank 12
4561271 2219481 2219481 defendant del Feld John   598688 598688 del Feld, John, of Unthank 3
4561281 2219481 2219481 defendant Ledyn Wiliam   598688 598688 Ledyn, Wiliam, of Unthank 13
4561282 2219481 2219481 defendant Ravyll William   598688 598688 Ravyll, William, of Unthank 14
4600576 2231403 2231403 plaintiff Tomson William   598688 598688 Tomson, William, of Unthank 0
4600577 2231403 2231403 defendant Colman John   598688 598688 Colman, John, of Unthank 0
4666825 2255350 2255350 defendant Jonson Wilalim yeoman 598688 598688 Jonson, Wilalim, of Unthank, yeoman 0
4671113 2256630 2256630 defendant Jonesson William husbandman 598688 598688 Jonesson, William, of Unthank, husbandman 0
4671134 2256636 2256636 defendant Colman John   598688 598688 Colman, John, of Unthank 1
4706059 2267269 2267269 defendant Colman John husbandman 598688 598688 Colman, John, of Unthank, husbandman 2
4719794 2271536 2271536 defendant Arlossh Robert husbandman 598688 598688 Arlossh, Robert, of Unthank, husbandman 0
4723194 2272563 2272563 defendant Calfherd Thomas husbandman 598688 598688 Calfherd, Thomas, of Unthank, husbandman 2
4742083 2278180 2278180 defendant Ladyman John husbandman 598688 598688 Ladyman, John, of Unthank, husbandman 4
4758550 2283053 2283053 defendant Wilkynson John husbandman 598688 598688 Wilkynson, John, of Unthank, husbandman 1
4770716 2286821 2286821 defendant Canon Robert husbandman 598688 598688 Canon, Robert, of Unthank, husbandman 0
4778194 2289165 2289165 defendant Calvehird Thomas   598688 598688 Calvehird, Thomas, of Unthank, servant 2
4801003 2296504 2296504 defendant Henryson John husbandman 598688 598688 Henryson, John, of Unthank, husbandman 0
4852859 2312313 2312313 defendant Canon Robert yeoman 598688 598688 Canon, Robert, of Unthank, yeoman 0
4878759 2320295 2320295 defendant Canon Robert yeoman 598688 598688 Canon, Robert, of Unthank, yeoman 0
4945244 2340488 2340488 defendant Calfhard Thomas husbandman 598688 598688 Calfhard, Thomas, of Unthank, husbandman 0
5430838 2484163 2484163 defendant Thomson Robert yeoman 598688 598688 Thomson, Robert, of Unthank, yeoman 0
5430840 2484164 2484164 defendant Thomson Robert yeoman 598688 598688 Thomson, Robert, of Unthank, yeoman 0
5430842 2484165 2484165 defendant Thomson Robert yeoman 598688 598688 Thomson, Robert, of Unthank, yeoman 0
5447430 2489119 2489119 defendant thomson Robert yeoman 598688 598688 thomson, Robert, of Unthank, yeoman 0
5633749 2554552 2554552 defendant Jonson William yeoman 598688 598688 Jonson, William, of Unthank, yeoman 4

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