names

29 rows where place_id = 789237

✎ 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
4427711 2173503 2173503 defendant Duffeld William de   789237 789237 Duffeld, William de, of Kercolston, parson 0
4712277 2269154 2269154 defendant Kyrk John de husbandman 789237 789237 Kyrk, John de, of Kercolston, husbandman 0
4712278 2269154 2269154 defendant Kyrk Hugh de husbandman 789237 789237 Kyrk, Hugh de, of Kercolston, husbandman 1
4719834 2271548 2271548 defendant Atkyrk Hugh husbandman 789237 789237 Atkyrk, Hugh, of Kercolston, husbandman 3
4748330 2280017 2280017 defendant Wryght William husbandman 789237 789237 Wryght, William, of Kercolston, husbandman 1
4859150 2314238 2314238 defendant Hode William husbandman 789237 789237 Hode, William, of Kercolston, husbandman 1
4859152 2314238 2314238 defendant Cheworth John yeoman 789237 789237 Cheworth, John, of Kercolston, yeoman 3
4868405 2317089 2317089 defendant Gloucestre John esq 789237 789237 Gloucestre, John, of Kercolston, esq 0
4872134 2318245 2318245 defendant Strut John husbandman 789237 789237 Strut, John, of Kercolston, husbandman 3
4875533 2319301 2319301 defendant Warde Hugh husbandman 789237 789237 Warde, Hugh, of Kercolston, husbandman 1
4875535 2319301 2319301 defendant Croft John husbandman 789237 789237 Croft, John, of Kercolston, husbandman 3
4875536 2319301 2319301 defendant Croft William husbandman 789237 789237 Croft, William, of Kercolston, husbandman 4
4875537 2319301 2319301 defendant Croft Thomas husbandman 789237 789237 Croft, Thomas, of Kercolston, husbandman 5
4920376 2332889 2332889 defendant Gloucestre John esq 789237 789237 Gloucestre, John, of Kercolston, esq 0
5037992 2367997 2367997 defendant Byngham John gent 789237 789237 Byngham, John, of Kercolston, gent 0
5038243 2368073 2368073 defendant Gloucestre John gent 789237 789237 Gloucestre, John, of Kercolston, or of Sutton on Trent, Notts, gent 0
5068709 2377137 2377137 defendant Lawney William husbandman 789237 789237 Lawney, William,of Kercolston, husbandman 1
5079225 2380279 2380279 plaintiff Byngham John   789237 789237 Byngham, John, of Kercolston 2
5079896 2380467 2380467 defendant Arnold William husbandman 789237 789237 Arnold, William, of Kercolston, husbandman 1
5094918 2384927 2384927 defendant Shepard John husbandman 789237 789237 Shepard, John, of Kercolston, husbandman 0
5099708 2386352 2386352 defendant Chambyr John husbandman 789237 789237 Chambyr, John, of Kercolston, husbandman 1
5212303 2419340 2419340 defendant Chamber John yeoman 789237 789237 Chamber, John, of Kercolston, yeoman 0
5212304 2419340 2419340 defendant Kyrke Hugh yeoman 789237 789237 Kyrke, Hugh, of Kercolston, yeoman 1
5212306 2419341 2419341 defendant Chamber John yeoman 789237 789237 Chamber, John, of Kercolston, yeoman 0
5212307 2419341 2419341 defendant Kyrke Hugh yeoman 789237 789237 Kyrke, Hugh, of Kercolston, yeoman 1
5416135 2479757 2479757 defendant Vavesour Thomas chaplain 789237 789237 Vavesour, Thomas, of Kercolston, chaplain 0
5431957 2484528 2484528 defendant Kyrk William husbandman 789237 789237 Kyrk, William, of Kercolston, husbandman 0
5432860 2484795 2484795 defendant Vyncent Nicholas husbandman 789237 789237 Vyncent, Nicholas, of Kercolston, husbandman 0
5432864 2484796 2484796 defendant Vavesour Thomas chaplain 789237 789237 Vavesour, Thomas, of Kercolston, chaplain 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);