names

35 rows where place_id = 769499

✎ 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
4558953 2218764 2218764 defendant Craas Walter   769499 769499 Craas, Walter, of Frome in Selwode, Soms 0
4558957 2218765 2218765 defendant Craas Walter   769499 769499 Craas, Walter, of Frome in Selwode, Soms 0
4716323 2270418 2270418 defendant Molde Thomas yeoman 769499 769499 Molde, Thomas, of Frome in Selwode, Soms, yeoman 0
4843992 2309633 2309633 defendant Brende John chapman 769499 769499 Brende, John, of Frome in Selwode, Soms, chapman 3
4876290 2319546 2319546 defendant Wether William husbandman 769499 769499 Wether, William, of Frome in Selwode, Soms, husbandman 0
4879476 2320510 2320510 defendant Gay William butcher 769499 769499 Gay, William, of Frome in Selwode, Soms, butcher 0
4930865 2336055 2336055 defendant Raulyns John tailor 769499 769499 Raulyns, John, of Frome in Selwode, Soms, tailor 1
4937682 2338162 2338162 defendant Cathell Philip mercer 769499 769499 Cathell, Philip, of Frome in Selwode, Soms, mercer 0
4951524 2342434 2342434 defendant Shulder John husbandman 769499 769499 Shulder, John, of Frome in Selwode, Soms, husbandman 1
4997502 2356104 2356104 defendant Payn William clother 769499 769499 Payn, William, of Frome in Selwode, Soms, clother 2
5041816 2369151 2369151 defendant Sawer John weaver 769499 769499 Sawer, John, of Frome in Selwode, Soms, weaver 3
5054135 2372828 2372828 defendant Rawlyn John tailor 769499 769499 Rawlyn, John, of Frome in Selwode, Soms, tailor 0
5062213 2375257 2375257 defendant Stokton John, junior yeoman 769499 769499 Stokton, John, junior, of Frome in Selwode, Soms, yeoman 0
5068343 2377035 2377035 defendant Fyssher John clothier 769499 769499 Fyssher, John, of Frome in Selwode, Soms, clothier 1
5068348 2377036 2377036 defendant Fyssher John clothier 769499 769499 Fyssher, John, of Frome in Selwode, Soms, clothier 1
5072507 2378262 2378262 defendant Rawlyn John tailor 769499 769499 Rawlyn, John, of Frome in Selwode, Soms, tailor 4
5073329 2378510 2378510 defendant Sutton John yeoman 769499 769499 Sutton, John, of junior, of Frome in Selwode, Soms, yeoman 1
5092859 2384293 2384293 defendant Rawelyn John tailor 769499 769499 Rawelyn, John, of Frome in Selwode, Soms, tailor 0
5107499 2388623 2388623 defendant Baker John clothman 769499 769499 Baker, John, of Frome in Selwode, Soms, clothman 2
5121085 2392597 2392597 defendant Symons John clothmaker 769499 769499 Symons, John, of Frome in Selwode, Soms, clothmaker 1
5121307 2392666 2392666 plaintiff Taylour Alan (legal representative) 769499 769499 Taylour, Alan, of Frome in Selwode, Soms, draper, executors of 0
5121349 2392676 2392676 defendant Baker John clothmaker 769499 769499 Baker, John, of Frome in Selwode, Soms, clothmaker 2
5121356 2392678 2392678 defendant Osbern John clothmaker 769499 769499 Osbern, John, of Frome in Selwode, Soms, clothmaker 1
5121360 2392679 2392679 defendant Osbern John clothmaker 769499 769499 Osbern, John, of Frome in Selwode, Soms, clothmaker 1
5121377 2392684 2392684 defendant Kaynesham John clothmaker 769499 769499 Kaynesham, John, of Frome in Selwode, Soms, clothmaker 1
5121381 2392685 2392685 defendant Kaynesham John clothmaker 769499 769499 Kaynesham, John, of Frome in Selwode, Soms, clothmaker 1
5227374 2423633 2423633 defendant Twyneho Thomas gent 769499 769499 Twyneho, Thomas, of Frome in Selwode, Soms, gent 3
5235724 2426026 2426026 defendant Champenes Henry gent 769499 769499 Champenes, Henry, of Frome in Selwode, Soms, gent 1
5235752 2426032 2426032 defendant Stokton John clothman 769499 769499 Stokton, John, of Frome in Selwode, Soms, clothman 2
5242281 2427946 2427946 defendant Grace Matthew weaver 769499 769499 Grace, Matthew, of Frome in Selwode, Soms, weaver 0
5278955 2438956 2438956 defendant Touker Walter yeoman 769499 769499 Touker, Walter, of Frome in Selwode, Soms, yeoman 2
5413633 2479001 2479001 defendant Osbern John (legal representative) 769499 769499 Osbern, John, of Frome in Selwode, Soms, yeoman, executrix of 7
5470378 2496063 2496063 defendant Osbern John (legal representative) 769499 769499 Osbern, John, of Frome in Selwode, Soms, yeoman, executrix of 4
5626705 2552326 2552326 defendant Sawnder John merchant 769499 769499 Sawnder, John, of Frome in Selwode, Soms, merchant 0
5634234 2554690 2554690 defendant Colesborne William husbandman 769499 769499 Colesborne, William, of Frome in Selwode, Soms, husbandman 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);