names

18 rows where place_id = 605910

✎ 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
3663349 1914460 1914460 defendant Bryght John clothier 605910 605910 Bryght, John, of Havent, Hants, clothier 1
3663390 1914474 1914474 defendant Bryght John chapman 605910 605910 Bryght, John, of Havent, Hants, chapman 0
3919387 1996814 1996814 defendant Foster Andrew chapman 605910 605910 Foster, Andrew, of Havent, Hants, chapman 1
4649948 2246002 2246002 defendant Culpas Thomas   605910 605910 Culpas, Thomas, of Havent, Hants 3
4665981 2250835 2250835 defendant Exham John clerk 605910 605910 Exham, John, of Havent, Hants, clerk 1
4665985 2250836 2250836 defendant Exham John clerk 605910 605910 Exham, John, of Havent, Hants, clerk 1
4691953 2263017 2263017 defendant Balkeman William yeoman 605910 605910 Balkeman, William, of Havent, Hants, yeoman 0
4716125 2270349 2270349 defendant Marnham John   605910 605910 Marnham, John, of Havent, Hants 1
4816809 2301359 2301359 defendant Morys Nicholas clerk 605910 605910 Morys, Nicholas, of Havent, Hants, clerk 0
4989355 2353751 2353751 defendant Bocher John butcher 605910 605910 Bocher, John, of Havent, Hants, butcher 1
5016124 2361597 2361597 defendant Lucas William tanner 605910 605910 Lucas, William, of Havent, Hants, tanner 0
5053374 2372612 2372612 defendant Bocher Robert butcher 605910 605910 Bocher, Robert, of Havent, Hants, butcher 0
5077611 2379800 2379800 defendant Bayly Robert chapman 605910 605910 Bayly, Robert, of Havent, Hants, chapman 2
5077617 2379801 2379801 defendant Bayly Robert chapman 605910 605910 Bayly, Robert, of Havent, Hants, chapman 2
5115980 2391101 2391101 defendant Foly John merchant 605910 605910 Foly, John, of Havent, Hants, merchant 0
5121154 2392613 2392613 defendant Foly Peter merchant 605910 605910 Foly, Peter, of Havent, Hants, merchant 0
5121158 2392614 2392614 defendant Ster John dyer 605910 605910 Ster, John, of Havent, Hants, dyer 2
5438185 2486354 2486354 defendant Hoskyn Walter weaver 605910 605910 Hoskyn, Walter, of Havent, Hants, weaver 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);