names

33 rows where place_id = 763457

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
4497371 2199825 2199825 defendant Clerk William, senior   763457 763457 Clerk, William, senior, of Wylyton 2
4497372 2199825 2199825 defendant Clerk William, junior   763457 763457 Clerk, William, junior, of Wylyton 3
4550985 2216244 2216244 defendant Clerk William   763457 763457 Clerk, William, of Wylyton 3
4580907 2225509 2225509 defendant Clerk William   763457 763457 Clerk, William, of Wylyton 3
4758044 2282888 2282888 defendant Orchard John husbandman 763457 763457 (Orchard, John, of Wylyton, husbandman 1
4800503 2296338 2296338 defendant Alre Richard gent 763457 763457 Alre, Richard, of Wylyton, gent 3
4802881 2297089 2297089 defendant Aller Richard gent 763457 763457 Aller, Richard, of Wylyton, gent 0
4809256 2299070 2299070 defendant Phelpes John husbadnman 763457 763457 Phelpes, John, of Wylyton, husbadnman 1
4818602 2301899 2301899 defendant Shereff John laborer 763457 763457 Shereff, John, of Wylyton, laborer 0
4845141 2309994 2309994 defendant Wylcok William smith 763457 763457 Wylcok, William, of Wylyton, smith 0
4845142 2309994 2309994 defendant Troubrigge Richard laborer 763457 763457 Troubrigge, Richard, of Wylyton, laborer 1
4865679 2316230 2316230 defendant Wybwyll Walter husbandman 763457 763457 Wybwyll, Walter, of Wylyton, husbandman 2
4890254 2323721 2323721 defendant Cloteham William drover 763457 763457 Cloteham, William, of Wylyton, drover 3
4914348 2331002 2331002 defendant Forde John   763457 763457 Forde, John, of Wylyton, "synyer" or senior 2
4970847 2348222 2348222 defendant Persons John husbandman 763457 763457 Persons, John, of Wylyton, husbandman 0
5072206 2378176 2378176 defendant Wylcokys William husbandman 763457 763457 Wylcokys, William, of Wylyton, husbandman 1
5081038 2380830 2380830 defendant Brytte James yeoman 763457 763457 Brytte, James, of Wylyton, yeoman 4
5104308 2387682 2387682 defendant Wylcokys William smith 763457 763457 Wylcokys, William, of Wylyton, smith 0
5166552 2405936 2405936 defendant Wylcokys William smith 763457 763457 Wylcokys, William, of Wylyton, smith 0
5173881 2408059 2408059 defendant atte Yate William yeoman 763457 763457 atte Yate, William, of Wylyton, yeoman 0
5188100 2412233 2412233 defendant Sporewey John husbandman 763457 763457 Sporewey, John, of Wylyton, husbandman 0
5285321 2440727 2440727 defendant Hoper Cornelius fisher 763457 763457 Hoper, Cornelius, of Wylyton, fisher 1
5309670 2447930 2447930 defendant Haddeley John gent 763457 763457 Haddeley, John, of Wylyton, gent 0
5316826 2450119 2450119 defendant Hadley John esq 763457 763457 Hadley, John, of Wylyton, esq 0
5440030 2486919 2486919 defendant Lytyll John husbandman 763457 763457 Lytyll, John, of Wylyton, husbandman 0
5451305 2490265 2490265 defendant Tapper Robert husbandman 763457 763457 Tapper, Robert, of Wylyton, husbandman 0
5464167 2494189 2494189 defendant Trobrigge John husbandman 763457 763457 Trobrigge, John, of Wylyton, husbandman 0
5464173 2494191 2494191 defendant Tapper Robert husbandman 763457 763457 Tapper, Robert, of Wylyton, husbandman 0
5464175 2494192 2494192 defendant Tapper Robert husbandman 763457 763457 Tapper, Robert, of Wylyton, husbandman 0
5475722 2497734 2497734 defendant Trobrigge John husbandman 763457 763457 Trobrigge, John, of Wylyton, husbandman 0
5475726 2497735 2497735 defendant Trobrygge John husbandman 763457 763457 Trobrygge, John, of Wylyton, husbandman 0
5506718 2507020 2507020 defendant Gore John husbandman 763457 763457 Gore, John, of Wylyton, husbandman 0
5592581 2532670 2532670 defendant Thressher Thomas yeoman 763457 763457 Thressher, Thomas, of Wylyton, yeoman 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);