names

36 rows where place_id = 600883

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3642969 1908251 1908251 defendant Sagemore William mercer 600883 600883 Sagemore, William, of Bodman, Cornw, mercer 2
3644371 1908657 1908657 defendant Richardys Blanche widow 600883 600883 Richardys, Blanche, of Bodman, Cornw, widow 1
3702987 1927208 1927208 defendant Arundell John gent 600883 600883 Arundell, John, of Bodman, Cornw, gent 1
3761275 1945530 1945530 defendant Oppy Elizabeth widow 600883 600883 (Oppy, Elizabeth, of Bodman, Cornw, widow 1
3766695 1947243 1947243 defendant Wyett Richard cordwainer 600883 600883 Wyett, Richard, of Bodman, Cornw, cordwainer 0
3876392 1982351 1982351 defendant Wyat Richard tinner 600883 600883 Wyat, Richard, of Bodman, Cornw, tinner 0
3945258 2005426 2005426 defendant Cundye Richard chapman 600883 600883 Cundye, Richard, of Bodman, Cornw, chapman 0
3965278 2012472 2012472 defendant Salt Thomas capper 600883 600883 Salt, Thomas, of Bodman, Cornw, capper 0
4043833 2040243 2040243 defendant Condy Richard, junior draper 600883 600883 Condy, Richard, junior, of Bodman, Cornw, draper 0
4072092 2050317 2050317 defendant Hartwell Robert chapman 600883 600883 Hartwell, Robert, of Bodman, Cornw, chapman 1
4103554 2061553 2061553 defendant Warde Henry retailer 600883 600883 Warde, Henry, of Bodman, Cornw, retailer 0
4180273 2088578 2088578 defendant Meader Thomas glover 600883 600883 Meader, Thomas, of Bodman, Cornw, glover 0
4185783 2090525 2090525 defendant Mapowder George chapman 600883 600883 Mapowder, George, of Bodman, Cornw, chapman 0
4191324 2092529 2092529 defendant Tompson John haberdasher 600883 600883 Tompson, John, of Bodman, Cornw, haberdasher 0
4203587 2096809 2096809 defendant Meader Thomas glover 600883 600883 Meader, Thomas, of Bodman, Cornw, glover 0
4207781 2098284 2098284 defendant Durant Richard chapman 600883 600883 Durant, Richard, of Bodman, Cornw, chapman 1
4785403 2291453 2291453 defendant Myrevyld William husbandman 600883 600883 Myrevyld, William, of Bodman, Cornw, husbandman 0
4889150 2323395 2323395 defendant Erle John chapman 600883 600883 Erle, John, of Bodman, Cornw, chapman 0
4896126 2325445 2325445 defendant Erle John chapman 600883 600883 Erle, John, of Bodman, Cornw, chapman 0
4918714 2332369 2332369 defendant Glyn Thomas gent 600883 600883 Glyn, Thomas, of Bodman, Cornw, gent 4
4948622 2341549 2341549 defendant Rawlyn John mercer 600883 600883 Rawlyn, John, of Bodman, Cornw, mercer 0
5054213 2372851 2372851 defendant Lanhergy Thomas gent 600883 600883 Lanhergy, Thomas, of Bodman, Cornw, gent 2
5095115 2384988 2384988 defendant Cokke John chapman 600883 600883 Cokke, John, of Bodman, Cornw, chapman 2
5095445 2385086 2385086 defendant Erle John mercer 600883 600883 Erle, John, of Bodman, Cornw, mercer 4
5248928 2429812 2429812 plaintiff Thomas John (legal representative) 600883 600883 Thomas, John, of Bodman, Cornw, brasier, executor of 0
5261446 2433691 2433691 plaintiff Mayhewe John merchant 600883 600883 Mayhewe, John, of Bodman, Cornw, merchant 0
5278596 2438851 2438851 defendant Burlas Robert gent 600883 600883 Burlas, Robert, of Bodman, Cornw, gent 2
5319927 2451045 2451045 defendant Beer John esq 600883 600883 Beer, John, of Bodman, Cornw, esq 0
5319929 2451046 2451046 defendant Beer John esq 600883 600883 Beer, John, of Bodman, Cornw, esq 0
5498283 2504445 2504445 defendant Richardys John chapman 600883 600883 Richardys, John, of Bodman, Cornw, chapman 0
5509072 2507691 2507691 defendant Southwode Thomas gent 600883 600883 Southwode, Thomas, of Bodman, Cornw, gent 1
5538537 2516534 2516534 defendant Seggemore William mercer 600883 600883 Seggemore, William, of Bodman, Cornw, mercer 2
5550100 2520065 2520065 defendant Nycoll Peter gent 600883 600883 Nycoll, Peter, of Bodman, Cornw, gent 1
5557418 2522131 2522131 defendant Sawegemore William chapman 600883 600883 Sawegemore, William, of Bodman, Cornw, chapman 0
5632967 2554316 2554316 defendant Talek Robert tailor 600883 600883 Talek, Robert, of Bodman, Cornw, tailor 3
5632973 2554317 2554317 defendant Talek Robert tailor 600883 600883 Talek, Robert, of Bodman, Cornw, tailor 3

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