names

32 rows where place_id = 754489

✎ 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
4420522 2171320 2171320 defendant Moigne John   754489 754489 Moigne, John, of Dokesworth 0
4472867 2192190 2192190 defendant Catmere John butcher 754489 754489 Catmere, John, of Dokesworth, butcher 1
4591563 2228722 2228722 defendant Smyth Nicholas   754489 754489 Smyth, Nicholas, of Dokesworth 1
4653873 2247119 2247119 defendant Skeyt John, senior laborer 754489 754489 Skeyt, John, senior, of Dokesworth, laborer 0
4653874 2247119 2247119 defendant Skeyt John, junior laborer 754489 754489 Skeyt, John, junior, of Dokesworth, laborer 1
4653876 2247120 2247120 defendant Skeyt John, senior laborer 754489 754489 Skeyt, John, senior, of Dokesworth, laborer 0
4653877 2247120 2247120 defendant Skeyt John, junior laborer 754489 754489 Skeyt, John, junior, of Dokesworth, laborer 1
4707105 2267607 2267607 defendant Godyn John yeoman 754489 754489 Godyn, John, of Dokesworth, yeoman 0
4747231 2279695 2279695 plaintiff Joye William   754489 754489 Joye, William, of Dokesworth, on his own account 0
4747232 2279695 2279695 defendant Stote William husbandman 754489 754489 Stote, William, of Dokesworth, husbandman 0
4763234 2284490 2284490 defendant Wryght John miller 754489 754489 Wryght, John, of Dokesworth, miller 0
4769292 2286372 2286372 defendant Whrit John miller 754489 754489 Whrit, John, of Dokesworth, miller 4
4773266 2287609 2287609 defendant Stote William yeoman 754489 754489 Stote, William, of Dokesworth, yeoman 1
4792880 2293862 2293862 defendant Stote William yeoman 754489 754489 Stote, William, of Dokesworth, yeoman 0
4798583 2295736 2295736 defendant Stote William yeoman 754489 754489 Stote, William, of Dokesworth, yeoman 1
4800708 2296405 2296405 plaintiff Welle William   754489 754489 Welle, William, of Dokesworth 0
4850818 2311706 2311706 defendant Trope John, sen   754489 754489 Trope, John, sen, of Dokesworth 0
4850822 2311706 2311706 defendant Crosse John   754489 754489 Crosse, John, of Dokesworth 4
4850823 2311706 2311706 defendant Malt John   754489 754489 Malt, John, of Dokesworth 5
4878789 2320304 2320304 defendant Trope John husbandman 754489 754489 Trope, John, of Dokesworth, husbandman 0
4878790 2320304 2320304 defendant Godyn Ralph husbandman 754489 754489 Godyn, Ralph, of Dokesworth, husbandman 1
4878791 2320304 2320304 defendant Robynet William husbandman 754489 754489 Robynet, William, of Dokesworth, husbandman 2
4878792 2320304 2320304 defendant Byggyng John husbandman 754489 754489 Byggyng, John, of Dokesworth, husbandman 3
4878793 2320304 2320304 defendant Crosse John husbandman 754489 754489 Crosse, John, of Dokesworth, husbandman 4
4878794 2320304 2320304 defendant Malt John husbandman 754489 754489 Malt, John, of Dokesworth, husbandman 5
5064956 2376052 2376052 defendant Smyth John gent 754489 754489 Smyth, John, of Dokesworth, gent, son of Smyth, John, senior, of Dokesworth, gent 0
5064958 2376053 2376053 defendant Smyth John husbandman 754489 754489 Smyth, John, of Dokesworth, husbandman 0
5064960 2376054 2376054 defendant Smyth John husbandman 754489 754489 Smyth, John, of Dokesworth, husbandman 0
5307673 2447309 2447309 defendant Malte John husbandman 754489 754489 Malte, John, of Dokesworth, husbandman 0
5628493 2552882 2552882 defendant Lowe Robert ploughman 754489 754489 Lowe, Robert, of Dokesworth, ploughman 0
5628523 2552891 2552891 defendant Lawe Robert ploughman 754489 754489 Lawe, Robert, of Dokesworth, ploughman 0
5631449 2553842 2553842 defendant Sybern Richard weaver 754489 754489 Sybern, Richard, of Dokesworth, weaver 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);