names

24 rows where place_id = 636540

✎ 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
3752852 1942815 1942815 defendant Herne John   636540 636540 Herne, John, of Emberton, yeoman, bailiff of Newport Paynell 0
3831363 1967698 1967698 defendant Heron John husbandman 636540 636540 Heron, John, of Emberton, husbandman 0
3831364 1967698 1967698 defendant Heron Thomas (legal representative) 636540 636540 Heron, Thomas, of Emberton, yeoman, executors of 1
4447002 2183977 2183977 plaintiff Drayton John   636540 636540 Drayton, John, of Emberton 0
4645726 2244814 2244814 defendant Balteswell John   636540 636540 Balteswell, John, of Emberton 0
4796171 2294953 2294953 defendant Smyth Thomas husbandman 636540 636540 Smyth, Thomas, of Emberton, husbandman 3
4885786 2322425 2322425 defendant Smyth Thomas husbandman 636540 636540 Smyth, Thomas, of Emberton, husbandman 0
4916542 2331680 2331680 defendant Smyth Thomas husbandman 636540 636540 Smyth, Thomas, of Emberton, husbandman 0
4944247 2340173 2340173 defendant Andrewe Thomas husbandman 636540 636540 Andrewe, Thomas, of Emberton, husbandman 0
4947096 2341084 2341084 defendant Smyth Thomas husbandman 636540 636540 Smyth, Thomas, of Emberton, husbandman 2
5059921 2374531 2374531 defendant Shelton Richard husbandman 636540 636540 Shelton, Richard, of Emberton, husbandman 3
5081201 2380883 2380883 defendant Hardyng William husbandman 636540 636540 Hardyng, William, of Emberton, husbandman 0
5153364 2402137 2402137 defendant Andrewe Thomas husbandman 636540 636540 Andrewe, Thomas, of Emberton, husbandman 0
5170811 2407185 2407185 defendant Andrewe Thomas husbandman 636540 636540 Andrewe, Thomas, of Emberton, husbandman 0
5188823 2412461 2412461 defendant Andrewe Thomas husbandman 636540 636540 Andrewe, Thomas, of Emberton, husbandman 0
5215274 2420196 2420196 defendant Andrew Thomas husbandman 636540 636540 Andrew, Thomas, of Emberton, husbandman 0
5215275 2420196 2420196 defendant Andrew William clerk 636540 636540 Andrew, William, of Emberton, clerk 1
5215280 2420197 2420197 defendant Andrew Thomas husbandman 636540 636540 Andrew, Thomas, of Emberton, husbandman 0
5215281 2420197 2420197 defendant Andrew William clerk 636540 636540 Andrew, William, of Emberton, clerk 1
5232265 2425014 2425014 defendant Hewet Thomas husbandman 636540 636540 Hewet, Thomas, of Emberton, husbandman 0
5267665 2435644 2435644 defendant Andrewe Thomas yeoman 636540 636540 Andrewe, Thomas, of Emberton, yeoman 0
5267683 2435650 2435650 defendant Andrewe Thomas yeoman 636540 636540 Andrewe, Thomas, of Emberton, yeoman 0
5306821 2447035 2447035 defendant Andrewe Roger husbandman 636540 636540 Andrewe, Roger, of Emberton, husbandman 0
5312025 2448626 2448626 defendant Heyron John husbandman 636540 636540 Heyron, John, of Emberton, husbandman 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);