names

27 rows where place_id = 757848

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: case_id, surname, forename, occupation, raw_segment, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
4447267 2184051 2184051 defendant Elyot Thomas   757848 757848 Elyot, Thomas, of Byre or Beer 0
4449068 2184651 2184651 defendant Elyot Thomas   757848 757848 Elyot, Thomas, of Byre 1
4450519 2185126 2185126 defendant Couk Roger   757848 757848 Couk, Roger, of Byre 0
4455075 2186589 2186589 defendant Elyethe Thomas   757848 757848 Elyethe, Thomas, of Byre 2
4457645 2187399 2187399 defendant Toukere Roger   757848 757848 Toukere, Roger, of Byre 0
4457646 2187399 2187399 defendant Elyot Thomas   757848 757848 Elyot, Thomas, of Byre or Beer 1
4464406 2189539 2189539 defendant Jurdan John   757848 757848 Jurdan, John, of Byre 0
4496268 2199505 2199505 defendant Sherer William (legal representative) 757848 757848 Sherer, William, of Byre, executors of 3
4573945 2223368 2223368 defendant Shoyle Stephen   757848 757848 Shoyle, Stephen, of Byre 1
4718704 2271189 2271189 defendant Bryce Thomas ostler 757848 757848 Bryce, Thomas, of Byre, ostler 0
4728662 2274202 2274202 defendant Gyn Richard butcher 757848 757848 Gyn, Richard, of Byre, butcher 0
4742554 2278322 2278322 defendant Tynham Joan widow & formerly wife of Testator 757848 757848 Tynham, Joan, of Byre, widow & formerly wife of Testator 6
4747517 2279779 2279779 defendant Gyn Richard butcher 757848 757848 Gyn, Richard, of Byre, butcher 0
4767403 2285789 2285789 defendant Coterygge John husbandman 757848 757848 Coterygge, John, of Byre, husbandman 0
4781124 2290104 2290104 defendant Renne Walter husbandman 757848 757848 Renne, Walter, of Byre, husbandman 0
4781125 2290104 2290104 defendant Smert John husbandman 757848 757848 Smert, John, of Byre, husbandman 1
4783364 2290819 2290819 defendant Kay Roger yeoman 757848 757848 Kay, Roger, of Byre, yeoman 8
4783391 2290821 2290821 defendant Kay Roger yeoman 757848 757848 Kay, Roger, of Byre, yeoman 8
4849740 2311391 2311391 defendant Renne Walter yeoman 757848 757848 Renne, Walter, of Byre, yeoman 1
4897962 2326027 2326027 defendant Swethyn John   757848 757848 Swethyn, John, of Byre, cook 0
4901994 2327227 2327227 defendant Nurse John weaver 757848 757848 Nurse, John, of Byre, weaver 0
4907345 2328859 2328859 defendant Turbervyle William esq 757848 757848 Turbervyle, William, of Byre, esq 0
4948462 2341498 2341498 defendant Gyles Edward husbandman 757848 757848 Gyles, Edward, of Byre, husbandman 0
5019372 2362548 2362548 defendant Manston John gent 757848 757848 Manston, John, of Byre, gent 0
5109017 2389056 2389056 defendant Bradford Thomas husbandman 757848 757848 Bradford, Thomas, of Byre, husbandman 0
5109311 2389150 2389150 defendant Meyre Robert husbandman 757848 757848 Meyre, Robert, of Byre, husbandman 0
5490066 2501912 2501912 defendant Dryvyng Thomas gent 757848 757848 Dryvyng, Thomas, of Byre, gent 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);