names

35 rows where place_id = 638907

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, surname, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3845557 1972158 1972158 defendant Horebyn William husbandman 638907 638907 Horebyn, William, of Shene, husbandman 1
4489429 2197413 2197413 defendant Dey Hugh   638907 638907 Dey, Hugh, of Shene 0
4567827 2221509 2221509 defendant Hervy William   638907 638907 Hervy, William, of Shene 3
4672939 2257177 2257177 defendant Barowe John carpenter 638907 638907 Barowe, John, of Shene, carpenter 1
4672943 2257178 2257178 defendant Barowe John carpenter 638907 638907 Barowe, John, of Shene, carpenter 1
4697640 2264751 2264751 defendant Baily Thomas carpenter 638907 638907 Baily, Thomas, of Shene, carpenter 1
4815947 2301079 2301079 defendant Hervy Thomas smith 638907 638907 Hervy, Thomas, of Shene, smith 0
4830654 2305611 2305611 plaintiff (not given) John prior of Bokyngham 638907 638907 Bokyngham, John, of Shene, prior of the house of John of Bethlehem 0
4871416 2318024 2318024 defendant Cursyll John husbandman 638907 638907 Cursyll, John, of Shene, husbandman 4
4893310 2324614 2324614 defendant Elynger William   638907 638907 Elynger, William, of Shene, groom 2
4938513 2338423 2338423 defendant Pole Geoffrey gent 638907 638907 Pole, Geoffrey, of Shene, or of Dartford, Kent, gent 3
4951964 2342561 2342561 defendant Pole Geffrey gent 638907 638907 Pole, Geffrey, of Shene, or of Dartford, Kent, gent 3
4989261 2353721 2353721 plaintiff (not given) John prior of Buckyngham 638907 638907 Buckyngham, John, of Shene, brother & prior of the house of John of Bethlem 0
4992165 2354548 2354548 defendant Gyse Walter   638907 638907 Gyse, Walter, of Shene, dreke maker 0
5170842 2407196 2407196 plaintiff (not given) John prior of Ives 638907 638907 Ives, John, of Shene, prior of the house of John of Bethlehem 0
5188871 2412478 2412478 plaintiff (not given) John prior of Ives 638907 638907 Ives, John, of Shene, prior of the House of John of Bethelehem 0
5206278 2417570 2417570 plaintiff (not given) John prior of Ive 638907 638907 Ive, John, of Shene, prior of the house of Bethelem 0
5206284 2417573 2417573 plaintiff (not given) John prior of Ives 638907 638907 Ives, John, of Shene, prior of the house of St John of Bethlehem 0
5311453 2448454 2448454 plaintiff (not given) William prior of Wyldy 638907 638907 Wyldy, William, of Shene, prior of the house of John of Bethlehem 0
5311456 2448455 2448455 plaintiff (not given) William prior of Wyley 638907 638907 Wyley, William, of Shene, prior of the house of John of Jerusalem 0
5415045 2479434 2479434 plaintiff (not given) John prior of Ingleby 638907 638907 Ingleby, John, of Shene, prior of the House of Jesus of Bethlehem 0
5415047 2479435 2479435 plaintiff (not given) John prior of Ingleby 638907 638907 Ingleby, John, of Shene, prior of the House of Jesus, of Bethlehem, carthusian order 0
5415049 2479436 2479436 plaintiff (not given) John prior of Ingleby 638907 638907 Ingleby, John, of Shene, prior of the house of John of Bethlehem 0
5415051 2479437 2479437 plaintiff (not given) John prior of Ingleby 638907 638907 Ingleby, John, of Shene, prior of the house of John of Bethlehem 0
5415055 2479438 2479438 plaintiff (not given) John prior of Ingleby 638907 638907 Ingleby, John, of Shene, prior of the house of John of Bethlehem, carthusian order 0
5431095 2484240 2484240 plaintiff (not given) John prior of Ingelby 638907 638907 Ingelby, John, of Shene, prior of the house of John of Bethleham, carthusian order 0
5431118 2484246 2484246 plaintiff (not given) John prior of Ingilby 638907 638907 Ingilby, John, of Shene, prior of the house of St John of Bethlehem 0
5431120 2484247 2484247 plaintiff (not given) John prior of Ingleby 638907 638907 Ingleby, John, of Shene, prior of the House of John of Bethlehem 0
5431122 2484248 2484248 plaintiff (not given) John prior of Ingleby 638907 638907 Ingleby, John, of Shene, prior of the House of John of Bethlehem, carthusian order 0
5431124 2484249 2484249 plaintiff (not given) John prior of Ingleby 638907 638907 Ingleby, John, of Shene, prior of the House of John of Bethlehem, carthusian order 0
5431126 2484250 2484250 plaintiff (not given) John prior of Ingleby 638907 638907 Ingleby, John, of Shene, prior of the House of John of Bethlehem, carthusian order 0
5431130 2484251 2484251 plaintiff (not given) John prior of Ingleby 638907 638907 Ingleby, John, of Shene, prior of the house of St John of Bethlehem 0
5440781 2487154 2487154 plaintiff (not given) John prior of Yngleby 638907 638907 Yngleby, John, of Shene, prior of the House of John of Bethlehem 0
5447679 2489181 2489181 plaintiff (not given) John prior of Ingilby 638907 638907 Ingilby, John, of Shene, prior of the House of John of Bethlehem 0
5460071 2492943 2492943 plaintiff (not given) John prior of Ingilby 638907 638907 Ingilby, John, of Shene, prior of the house of Jesus of Bethlehem 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);