names

22 rows where place_id = 758827

✎ 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
4457055 2187220 2187220 plaintiff Parker William   758827 758827 Parker, William, of Brunstede 0
4561216 2219470 2219470 plaintiff Parker William   758827 758827 Parker, William, of Brunstede 0
4598193 2230675 2230675 defendant Mabelot Bartholomew   758827 758827 Mabelot, Bartholomew, of Brunstede 0
4598194 2230675 2230675 defendant Skynnere John   758827 758827 Skynnere, John, of Brunstede 1
4649753 2245951 2245951 plaintiff Walsham John   758827 758827 Walsham, John, of Brunstede 0
4687165 2261591 2261591 defendant Here Thomas husbandman 758827 758827 Here, Thomas, of Brunstede, husbandman 0
4722117 2272246 2272246 defendant Walsham Thomas husbandman 758827 758827 Walsham, Thomas, of Brunstede, husbandman 2
4722121 2272247 2272247 defendant Cleye Parnell   758827 758827 (Cleye, Parnell, of Brunstede, widow, formerly wife of Richard 1
4744341 2278868 2278868 defendant Mabelot Bartholomew husbandman 758827 758827 Mabelot, Bartholomew, of Brunstede, husbandman 1
4775478 2288328 2288328 defendant Abelot Bartholomew husbandman 758827 758827 Abelot, Bartholomew, of Brunstede, husbandman 0
4845489 2310103 2310103 defendant Grene John   758827 758827 Grene, John, of Brunstede, wright 0
4845490 2310103 2310103 defendant Poule William husbandman 758827 758827 Poule, William, of Brunstede, husbandman 1
4853482 2312499 2312499 defendant Wakeman John husbandman 758827 758827 Wakeman, John, of Brunstede, husbandman 0
4853483 2312499 2312499 defendant Benet Nicholas husbandman 758827 758827 Benet, Nicholas, of Brunstede, husbandman 1
4884488 2322050 2322050 defendant Dengayn William merchant 758827 758827 Dengayn, William, of Brunstede, merchant 3
4889759 2323591 2323591 defendant Benet Nicholas yeoman 758827 758827 Benet, Nicholas, of Brunstede, yeoman 0
4936756 2337874 2337874 defendant Dengayn Thomas esq 758827 758827 Dengayn, Thomas, of Brunstede, esq 0
5048236 2371107 2371107 plaintiff Rawelyns Walter   758827 758827 Rawelyns, Walter, of Brunstede 0
5091517 2383909 2383909 defendant Coweherd William husbandman 758827 758827 Coweherd, William, of Brunstede, husbandman 1
5115020 2390808 2390808 defendant Dengayn Simon gent 758827 758827 Dengayn, Simon, of Brunstede, gent 0
5188821 2412460 2412460 defendant Foulman Robert esq 758827 758827 Foulman, Robert, of Brunstede, esq 1
5488943 2501565 2501565 defendant Cook William yeoman 758827 758827 Cook, William, of Brunstede, 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);