names

24 rows where place_id = 710822

✎ 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
4185420 2090411 2090411 defendant Silvester Miles yeoman 710822 710822 Silvester, Miles, of Selbourne, yeoman 3
4464893 2189691 2189691 plaintiff Weston Thomas   710822 710822 Weston, Thomas, of Selbourne, prior 0
4548000 2215307 2215307 defendant Horn Richard   710822 710822 Horn, Richard, of Selbourne 0
4620700 2237459 2237459 defendant Almayn John   710822 710822 Almayn, John, of Selbourne 0
4732426 2275315 2275315 defendant Stevenes John husbandman 710822 710822 Stevenes, John, of Selbourne, husbandman 0
4764182 2284791 2284791 defendant Sutton John   710822 710822 Sutton, John, of Selbourne, vicar 0
4764186 2284791 2284791 defendant Gelys Robert husbandman 710822 710822 Gelys, Robert, of Selbourne, husbandman 4
4849481 2311310 2311310 plaintiff (not given) John prior of Stape 710822 710822 Stape, John, of Selbourne, prior of the church 0
4861342 2314916 2314916 defendant Banastre John yeoman 710822 710822 Banastre, John, of Selbourne, yeoman 0
4929122 2335530 2335530 plaintiff Stape John   710822 710822 Stape, John, of Selbourne, prior 0
5028596 2365242 2365242 defendant Newelyn Robert   710822 710822 Newelyn, Robert, of Selbourne, bailiff 0
5038749 2368235 2368235 defendant Prest William   710822 710822 with Prest, William, of Selbourne, vicar 3
5038755 2368237 2368237 defendant Preest William   710822 710822 Preest, William, of Selbourne, vicar 0
5060262 2374639 2374639 defendant Grene John yeoman 710822 710822 Grene, John, of Selbourne, yeoman 0
5115572 2390982 2390982 defendant Croucher John, senior husbandman 710822 710822 Croucher, John, senior, of Selbourne, husbandman 0
5115573 2390982 2390982 defendant Croucher John, junior husbandman 710822 710822 Croucher, John, junior, of Selbourne, husbandman 1
5131466 2395689 2395689 defendant (not given) Peter prior of Berne 710822 710822 Berne, Peter, of Selbourne, prior of the church of BM 0
5151599 2401622 2401622 defendant (not given) Peter prior of Berne 710822 710822 Berne, Peter, of Selbourne, prior of the church of the BM 0
5186790 2411881 2411881 defendant (not given) Peter prior of Berne 710822 710822 Berne, Peter, of Selbourne, prior of the church of the BM 0
5289836 2442033 2442033 defendant Shalmer John husbandman 710822 710822 Shalmer, John, of Selbourne, husbandman 4
5312778 2448854 2448854 defendant Newell John chaplain 710822 710822 Newell, John, of Selbourne, chaplain 0
5330146 2454093 2454093 defendant Netwell John chaplain 710822 710822 Netwell, John, of Selbourne, chaplain 0
5330427 2454179 2454179 defendant Shalmer John yeoman 710822 710822 Shalmer, John, of Selbourne, yeoman 4
5502881 2505815 2505815 defendant Lewes William yeoman 710822 710822 Lewes, William, of Selbourne, yeoman 4

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