names

32 rows where place_id = 724224

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, surname, forename, occupation, raw_segment, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3971805 2014698 2014698 defendant Carsewell Nicholas haberdasher 724224 724224 Carsewell, Nicholas, of Towcester, Nhants, yeoman, haberdasher 0
4254845 2114611 2114611 defendant Pleasdall Jane widow 724224 724224 Pleasdall, Jane, of Towcester, Nhants, widow 1
4254848 2114612 2114612 defendant Lacye Thomas yeoman 724224 724224 Lacye, Thomas, of Towcester, Nhants, yeoman 0
4267444 2118747 2118747 defendant Pleadall Jane widow 724224 724224 Pleadall, Jane, of Towcester, Nhants, widow 1
4267448 2118748 2118748 defendant Lacye Thomas yeoman 724224 724224 Lacye, Thomas, of Towcester, Nhants, yeoman 0
4289819 2126421 2126421 defendant Wickens William gent 724224 724224 Wickens, William, of Towcester, Nhants, gent 0
4520938 2206888 2206888 defendant Saundres William   724224 724224 Saundres, William, of Towcester, Nhants 2
4727141 2273748 2273748 defendant Acton Thomas tailor 724224 724224 (Acton, Thomas, of Towcester, Nhants, tailor 3
4767226 2285735 2285735 defendant Mortimer Laurence gent 724224 724224 Mortimer, Laurence, of Towcester, Nhants, gent 1
4830901 2305689 2305689 defendant Wyghton John chapman 724224 724224 Wyghton, John, of Towcester, Nhants, chapman 0
4843579 2309513 2309513 defendant Wighton John chapman 724224 724224 Wighton, John, of Towcester, Nhants, chapman 2
4843585 2309514 2309514 defendant Wyghton John chapman 724224 724224 Wyghton, John, of Towcester, Nhants, chapman 2
4848102 2310875 2310875 defendant Berell John hosteller 724224 724224 Berell, John, of Towcester, Nhants, hosteller 0
4919193 2332515 2332515 plaintiff Hertwell John (legal representative) 724224 724224 Hertwell, John, of Towcester, Nhants, executors of 0
4919196 2332515 2332515 defendant Hertwell John (legal representative) 724224 724224 Hertwell, John, of Towcester, Nhants, executors of 0
5148839 2400782 2400782 defendant Grene Robert weaver 724224 724224 Grene, Robert, of Towcester, Nhants, weaver 1
5200302 2415848 2415848 defendant Salford Richard tanner 724224 724224 Salford, Richard, of Towcester, Nhants, tanner 0
5200306 2415849 2415849 defendant Salford Richard tanner 724224 724224 Salford, Richard, of Towcester, Nhants, tanner 0
5203972 2416912 2416912 defendant Grene Robert weaver 724224 724224 Grene, Robert, of Towcester, Nhants, weaver 1
5203976 2416913 2416913 defendant Grene Robert weaver 724224 724224 Grene, Robert, of Towcester, Nhants, weaver 1
5272303 2436970 2436970 defendant Weste William chapman 724224 724224 Weste, William, of Towcester, Nhants, chapman 1
5272309 2436971 2436971 defendant Weste William chapman 724224 724224 Weste, William, of Towcester, Nhants, chapman 1
5275126 2437801 2437801 defendant London Elizabeth widow 724224 724224 London, Elizabeth, of Towcester, Nhants, widow 1
5389132 2471943 2471943 defendant Brawene John innholder 724224 724224 Brawene, John, of Towcester, Nhants, innholder 0
5394251 2473417 2473417 defendant Brawene John innholder 724224 724224 Brawene, John, of Towcester, Nhants, innholder 0
5401831 2475588 2475588 defendant Brawene John   724224 724224 Brawene, John, of Towcester, Nhants, inn holder 0
5425834 2482691 2482691 defendant Sergeant Joan widow of Thomas 724224 724224 Sergeant, Joan, of Towcester, Nhants, widow of Thomas 6
5433833 2485089 2485089 defendant Dene William butcher 724224 724224 Dene, William, of Towcester, Nhants, butcher 0
5440898 2487191 2487191 defendant Dene William butcher 724224 724224 Dene, William, of Towcester, Nhants, butcher 0
5444143 2488152 2488152 defendant Sergeant Joan widow 724224 724224 Sergeant, Joan, of Towcester, Nhants, widow 6
5456931 2491976 2491976 defendant Sergeant Joan widow 724224 724224 Sergeant, Joan, of Towcester, Nhants, widow 2
5463916 2494126 2494126 defendant Norton William yeoman 724224 724224 Norton, William, of Towcester, Nhants, 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);