names

27 rows where place_id = 608997

✎ 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
3676470 1918686 1918686 defendant Nundy William husbandman 608997 608997 Nundy, William, of Arkesey, husbandman 0
3676471 1918686 1918686 defendant Nundy William, junior husbandman 608997 608997 Nundy, William, junior, of Arkesey, husbandman 1
3956572 2009364 2009364 defendant Brokesbanke William (legal representative) 608997 608997 Brokesbanke, William, of Arkesey, clerk, executors of 0
4183937 2089877 2089877 defendant Fitzwilliams Gervase esq 608997 608997 Fitzwilliams, Gervase, of Arkesey, esq 0
4418017 2170514 2170514 defendant Sandale John de   608997 608997 Sandale, John de, of Arkesey, parson 0
4525234 2208229 2208229 defendant Geve John de   608997 608997 Geve, John de, of Arkesey, son of Thomas 0
4785091 2291349 2291349 defendant Athewyk John husbandman 608997 608997 Athewyk, John, of Arkesey, husbandman 0
4869089 2317304 2317304 defendant Janyn Edmund husbandman 608997 608997 Janyn, Edmund, of Arkesey, husbandman 1
4869092 2317305 2317305 defendant Janyn Edmynd husbandman 608997 608997 Janyn, Edmynd, of Arkesey, husbandman 1
4888747 2323268 2323268 defendant Kyrkelyng Richard   608997 608997 Kyrkelyng, Richard, of Arkesey, servant 0
4965485 2346593 2346593 defendant Tumbholm William husbandman 608997 608997 Tumbholm, William, of Arkesey, husbandman 0
4965486 2346593 2346593 defendant Burton Peter yeoman 608997 608997 Burton, Peter, of Arkesey, yeoman 1
4974743 2349413 2349413 defendant Sargeantson William yeoman 608997 608997 Sargeantson, William, of Arkesey, yeoman 0
4992065 2354518 2354518 defendant Tumbholm William husbandman 608997 608997 Tumbholm, William, of Arkesey, husbandman 0
4992066 2354518 2354518 defendant Burton Peter yeoman 608997 608997 Burton, Peter, of Arkesey, yeoman 1
5045425 2370260 2370260 defendant Sidall Robert husbandman 608997 608997 Sidall, Robert, of Arkesey, husbandman 2
5116162 2391153 2391153 defendant Knyght Richard yeoman 608997 608997 Knyght, Richard, of Arkesey, yeoman 0
5200918 2416034 2416034 defendant Kynwolmershe William clerk 608997 608997 Kynwolmershe, William, of Arkesey by Doncaster, clerk, & formerly parson of Boseworth, Leics, clerk 0
5215611 2420288 2420288 defendant Wayte Richard yeoman 608997 608997 Wayte, Richard, of Arkesey, yeoman 2
5347335 2459329 2459329 defendant Sandford William gent 608997 608997 Sandford, William, of Arkesey, gent 5
5386505 2471208 2471208 plaintiff Cresacre Edward clerk & rector 608997 608997 Cresacre, Edward, of Arkesey, clerk & rector 0
5398777 2474716 2474716 defendant Janyn Richard, junior husbandman 608997 608997 Janyn, Richard, junior, of Arkesey, husbandman 2
5398811 2474720 2474720 plaintiff Cresacre Edward   608997 608997 Cresacre, Edward, of Arkesey, rector 0
5400950 2475334 2475334 plaintiff Gresacre Edward   608997 608997 Gresacre, Edward, of Arkesey, Rector 0
5445037 2488402 2488402 defendant Bentley Edmund yeoman 608997 608997 Bentley, Edmund, of Arkesey, yeoman 0
5484096 2500179 2500179 defendant Smyth William yeoman 608997 608997 Smyth, William, of Arkesey, yeoman 0
5550150 2520076 2520076 defendant Janyn William yeoman 608997 608997 Janyn, William, of Arkesey, yeoman 1

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);