names

38 rows where place_id = 600116

✎ 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
3639740 1907237 1907237 defendant Boston Robert yeoman 600116 600116 Boston, Robert, of Wyboldeston, Beds, yeoman 0
3639744 1907239 1907239 defendant Boston Robert yeoman 600116 600116 Boston, Robert, of Wyboldeston, Beds, yeoman 0
3841310 1970862 1970862 defendant Mosedale Robert husbandman 600116 600116 Mosedale, Robert, of Wyboldeston, Beds, husbandman 0
4770453 2286732 2286732 defendant Stokker Thomas   600116 600116 Stokker, Thomas, of Wyboldeston, Beds, wool man 0
4828728 2305027 2305027 defendant Stokker Thomas   600116 600116 Stokker, Thomas, of Wyboldeston, Beds, wool man 0
4837241 2307592 2307592 defendant Stokkere Thomas   600116 600116 Stokkere, Thomas, of Wyboldeston, Beds, wool man 0
4865480 2316168 2316168 defendant Stokker Henry yeoman 600116 600116 Stokker, Henry, of Wyboldeston, Beds, yeoman 1
4903528 2327715 2327715 defendant Stokker Thomas woolman 600116 600116 Stokker, Thomas, of Wyboldeston, Beds, woolman 0
4919784 2332693 2332693 defendant Stokker Thomas chapman 600116 600116 Stokker, Thomas, of Wyboldeston, Beds, chapman 0
5003245 2357849 2357849 defendant Stokker Thomas husbandman 600116 600116 Stokker, Thomas, of Wyboldeston, Beds, husbandman 0
5024619 2364113 2364113 defendant Laurence John gent 600116 600116 Laurence, John, of Wyboldeston, Beds, gent 1
5026098 2364528 2364528 defendant Laurence John gent 600116 600116 Laurence, John, of Wyboldeston, Beds, gent 0
5026100 2364529 2364529 defendant Laurence John gent 600116 600116 Laurence, John, of Wyboldeston, Beds, gent 0
5034438 2366933 2366933 defendant Laurence John gent 600116 600116 Laurence, John, of Wyboldeston, Beds, gent 0
5064698 2375983 2375983 defendant Laurence John gent 600116 600116 Laurence, John, of Wyboldeston, Beds, gent 0
5071612 2378004 2378004 defendant Laurence John gent 600116 600116 Laurence, John, of Wyboldeston, Beds, gent 2
5071994 2378112 2378112 defendant Laurance John gent 600116 600116 Laurance, John, of Wyboldeston, Beds, gent 0
5072000 2378113 2378113 defendant Laurance John gent 600116 600116 Laurance, John, of Wyboldeston, Beds, gent 0
5087482 2382717 2382717 defendant Laurence John gent 600116 600116 Laurence, John, of Wyboldeston, Beds, gent 0
5114452 2390625 2390625 defendant Laurence John gent 600116 600116 Laurence, John, of Wyboldeston, Beds, gent 0
5193508 2413826 2413826 defendant Laurence John gent 600116 600116 Laurence, John, of Wyboldeston, Beds, gent 0
5193522 2413828 2413828 defendant Laurence John gent 600116 600116 Laurence, John, of Wyboldeston, Beds, gent 0
5208217 2418131 2418131 defendant Laurence John gent 600116 600116 Laurence, John, of Wyboldeston, Beds, gent 0
5222136 2422178 2422178 defendant Laurence John gent 600116 600116 Laurence, John, of Wyboldeston, Beds, gent 2
5222141 2422180 2422180 defendant Laurence John gent 600116 600116 Laurence, John, of Wyboldeston, Beds, gent 0
5223944 2422686 2422686 defendant Laurence John gent 600116 600116 Laurence, John, of Wyboldeston, Beds, gent 0
5234516 2425683 2425683 defendant Laurence John gent 600116 600116 Laurence, John, of Wyboldeston, Beds, gent 0
5234520 2425684 2425684 defendant Laurence John gent 600116 600116 Laurence, John, of Wyboldeston, Beds, gent 0
5234524 2425685 2425685 defendant Laurence John gent 600116 600116 Laurence, John, of Wyboldeston, Beds, gent 0
5283131 2440126 2440126 defendant Laurens John gent 600116 600116 Laurens, John, of Wyboldeston, Beds, gent 2
5302156 2445601 2445601 defendant Laurens John gent 600116 600116 Laurens, John, of Wyboldeston, Beds, gent 2
5316922 2450140 2450140 defendant Laurens John gent 600116 600116 Laurens, John, of Wyboldeston, Beds, gent 0
5316924 2450141 2450141 defendant Laurens John gent 600116 600116 Laurens, John, of Wyboldeston, Beds, gent 0
5321539 2451530 2451530 defendant Whale Robert gent 600116 600116 Whale, Robert, of Wyboldeston, Beds, gent 0
5325095 2452589 2452589 defendant Laurence John gent 600116 600116 Laurence, John, of Wyboldeston, Beds, gent 0
5335996 2455839 2455839 defendant Laurens John gent 600116 600116 Laurens, John, of Wyboldeston, Beds, gent 2
5481476 2499392 2499392 defendant Laurence John gent 600116 600116 Laurence, John, of Wyboldeston, Beds, gent 0
5481481 2499393 2499393 defendant Laurence John gent 600116 600116 Laurence, John, of Wyboldeston, Beds, gent 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);