names

29 rows where place_id = 614481

✎ 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
3703915 1927506 1927506 defendant Smyth Roger yeoman 614481 614481 Smyth, Roger, of Bossall, yeoman 0
3845172 1972051 1972051 defendant Constable John esq 614481 614481 Constable, John, of Bossall, esq 0
4230631 2106209 2106209 defendant Nellis John tailor 614481 614481 Nellis, John, of Bossall, or of Bowth, tailor 2
4252058 2113677 2113677 defendant Denton William clerk 614481 614481 Denton, William, of Bossall, clerk 1
4302831 2131111 2131111 defendant Denton William clerk 614481 614481 Denton, William, of Bossall, clerk 0
4302833 2131111 2131111 defendant Baxter John laborer 614481 614481 Baxter, John, of Bossall, laborer 2
4312522 2134513 2134513 defendant Denton William clerk 614481 614481 Denton, William, of Bossall, clerk 0
4312524 2134513 2134513 defendant Baxter John laborer 614481 614481 Baxter, John, of Bossall, laborer 2
4584293 2226498 2226498 defendant Menyngthorp Robert   614481 614481 Menyngthorp, Robert, of Bossall 4
4779759 2289662 2289662 defendant Clerk William husbandman 614481 614481 Clerk, William, of Bossall, husbandman 3
4781839 2290337 2290337 plaintiff Clerk William   614481 614481 Clerk, William, of Bossall 0
4781843 2290338 2290338 plaintiff Clerk William   614481 614481 Clerk, William, of Bossall 0
4807293 2298479 2298479 defendant Clere William husbandman 614481 614481 Clere, William, of Bossall, husbandman 2
4827739 2304724 2304724 defendant Clerk William yeoman 614481 614481 Clerk, William, of Bossall, yeoman 3
4831261 2305808 2305808 defendant Clerk William husbandman 614481 614481 Clerk, William, of Bossall, husbandman 0
4853241 2312430 2312430 defendant Clerk William husbandman 614481 614481 Clerk, William, of Bossall, husbandman 5
4860588 2314669 2314669 defendant Clerk William husbandman 614481 614481 Clerk, William, of Bossall, husbandman 0
4913866 2330843 2330843 defendant Clerk William yeoman 614481 614481 Clerk, William, of Bossall, yeoman 0
4913868 2330844 2330844 defendant Clerk William yeoman 614481 614481 Clerk, William, of Bossall, yeoman 0
4913870 2330845 2330845 defendant Queldryk Thomas   614481 614481 Queldryk, Thomas, of Bossall, vicar 0
4932486 2336555 2336555 defendant Clerk William yeoman 614481 614481 Clerk, William, of Bossall, yeoman 1
4964404 2346268 2346268 defendant Clerk William yeoman 614481 614481 Clerk, William, of Bossall, yeoman 0
4966204 2346825 2346825 defendant Clerk William husbandman 614481 614481 Clerk, William, of Bossall, husbandman 0
5005021 2358367 2358367 plaintiff Redeman Richard esq 614481 614481 Redeman, Richard, of Bossall, esq 0
5036409 2367506 2367506 defendant Redeman Richard esq 614481 614481 Redeman, Richard, of Bossall, esq 1
5159978 2404018 2404018 defendant Redeman Richard esq 614481 614481 Redeman, Richard, of Bossall, esq 0
5295012 2443530 2443530 defendant Radmayn Brian esq 614481 614481 Radmayn, Brian, of Bossall, esq 3
5478185 2498503 2498503 defendant Thomson Robert clerk 614481 614481 Thomson, Robert, of Bossall, clerk 0
5553577 2521081 2521081 defendant Redman Thomas gent 614481 614481 Redman, Thomas, of Bossall, gent 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);