names

24 rows where place_id = 647498

✎ 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
3896564 1989058 1989058 plaintiff Uvedale alias Woddall John, junior   647498 647498 Uvedale alias Woddall, John, junior, of Deen 0
3896566 1989059 1989059 plaintiff Uvedale alias Wodhall John, junior   647498 647498 Uvedale alias Wodhall, John, junior, of Deen 0
4415627 2169767 2169767 defendant Turney Lawrence   647498 647498 Turney, Lawrence, of Deen, parson 1
4480203 2194467 2194467 plaintiff Knyghton William   647498 647498 Knyghton, William, of Deen, parson 0
4538753 2212393 2212393 plaintiff Turney (illegible)   647498 647498 Turney, _, of Deen 0
4599513 2231064 2231064 plaintiff Sutton Richard (legal representative) 647498 647498 Sutton, Richard, of Deen, master & canon of the new college of the BM, in Leicester, executors of 0
4599517 2231065 2231065 plaintiff Sutton Richard (legal representative) 647498 647498 Sutton, Richard, of Deen, parson, executors of 0
4621394 2237684 2237684 defendant Wacedall William   647498 647498 Wacedall, William, of Deen 0
4647330 2245273 2245273 defendant Weston William   647498 647498 Weston, William, of Deen, parson 0
4681420 2259810 2259810 defendant Baxster Thomas   647498 647498 Baxster, Thomas, of Deen, bailiff 1
4708796 2268121 2268121 defendant Turnay John husbandman 647498 647498 Turnay, John, of Deen, husbandman 0
4708797 2268121 2268121 defendant Denys Richard husbandman 647498 647498 Denys, Richard, of Deen, husbandman 1
4708799 2268122 2268122 defendant Turnay John husbandman 647498 647498 Turnay, John, of Deen, husbandman 0
4708800 2268122 2268122 defendant Denys Richard husbandman 647498 647498 Denys, Richard, of Deen, husbandman 1
4758551 2283053 2283053 defendant Gill Adam husbandman 647498 647498 Gill, Adam, of Deen, husbandman 2
4804977 2297762 2297762 defendant Watkyn William clerk 647498 647498 Watkyn, William, of Deen, clerk 0
4804979 2297763 2297763 defendant Watkyn William clerk 647498 647498 Watkyn, William, of Deen, clerk 0
4879291 2320457 2320457 defendant Whetehull Robert gent 647498 647498 Whetehull, Robert, of Deen, gent 0
4894554 2324968 2324968 defendant Whetehill Robert gent 647498 647498 Whetehill, Robert, of Deen, gent 1
4957117 2344086 2344086 defendant Colle John husbandman 647498 647498 Colle, John, of Deen, husbandman 0
4957119 2344087 2344087 defendant Colle John husbandman 647498 647498 Colle, John, of Deen, husbandman 0
5095481 2385096 2385096 defendant Crakeplace Simon gent 647498 647498 Crakeplace, Simon, of Deen, gent 2
5095482 2385096 2385096 defendant Wodhall Thomas gent 647498 647498 Wodhall, Thomas, of Deen, gent 3
5628877 2553002 2553002 defendant Quene John chaplain 647498 647498 Quene, John, of Deen, chaplain 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);