names

38 rows where place_id = 602186

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3648857 1910031 1910031 defendant Bardewell John gent 602186 602186 Bardewell, John, of Happysburgh, gent 0
3648861 1910032 1910032 defendant Bardwell John gent 602186 602186 Bardwell, John, of Happysburgh, gent 2
3697999 1925599 1925599 defendant Mydylton Thomas yeoman 602186 602186 Mydylton, Thomas, of Happysburgh, yeoman 4
3750837 1942183 1942183 plaintiff Medylton Thomas   602186 602186 Medylton, Thomas, of Happysburgh 0
3750839 1942183 1942183 defendant Grene Robert   602186 602186 Grene, Robert, of Happysburgh 1
3763983 1946376 1946376 defendant Dogget John yeoman 602186 602186 Dogget, John, of Happysburgh, yeoman 0
3912537 1994524 1994524 plaintiff Amonte Edmund   602186 602186 Amonte, Edmund, of Happysburgh 0
3912538 1994524 1994524 plaintiff Trace Martin   602186 602186 Trace, Martin, of Happysburgh 1
3936685 2002598 2002598 plaintiff Medylton Clement   602186 602186 Medylton, Clement, of Happysburgh, single man 0
4059465 2045781 2045781 defendant Benslye John husbandman 602186 602186 Benslye, John, of Happysburgh, husbandman 0
4069430 2049349 2049349 defendant Nutt Leonard mariner 602186 602186 Nutt, Leonard, of Happysburgh, mariner 0
4933147 2336761 2336761 defendant Sweerd John yeoman 602186 602186 Sweerd, John, of Happysburgh, yeoman 0
4933148 2336761 2336761 defendant Cook Geoffrey yeoman 602186 602186 Cook, Geoffrey, of Happysburgh, yeoman 1
5007586 2359117 2359117 defendant Horn Nicholas smith 602186 602186 Horn, Nicholas, of Happysburgh, smith 0
5007587 2359117 2359117 defendant Horn John   602186 602186 Horn, John, of Happysburgh, husbandman, son of Nicholas 1
5041520 2369066 2369066 defendant Rift John   602186 602186 Rift, John, of Happysburgh, net beater 1
5097364 2385659 2385659 defendant Here William husbandman 602186 602186 Here, William, of Happysburgh, husbandman 1
5097373 2385661 2385661 defendant Here William husbandman 602186 602186 Here, William, of Happysburgh, husbandman 1
5115850 2391061 2391061 defendant Stapilton Brian esq 602186 602186 Stapilton, Brian, of Happysburgh, esq 0
5158930 2403732 2403732 defendant Lynsted Edmund yeoman 602186 602186 Lynsted, Edmund, of Happysburgh, yeoman 0
5197440 2414994 2414994 defendant Lynsted Agnes widow 602186 602186 Lynsted, Agnes, of Happysburgh, widow 0
5201275 2416129 2416129 defendant Lynsted Nicholas yeoman 602186 602186 Lynsted, Nicholas, of Happysburgh, yeoman 0
5211980 2419241 2419241 defendant Lynstede Nicholas yeoman 602186 602186 Lynstede, Nicholas, of Happysburgh, yeoman 1
5217960 2420987 2420987 defendant Tubbyng Robert yeoman 602186 602186 Tubbyng, Robert, of Happysburgh, yeoman 1
5234795 2425766 2425766 defendant Lynsted Edmund yeoman 602186 602186 Lynsted, Edmund, of Happysburgh, yeoman 0
5234796 2425766 2425766 defendant Souter Thomas souter 602186 602186 Souter, Thomas, of Happysburgh, souter 1
5234797 2425766 2425766 defendant Horn Nicholas smith 602186 602186 Horn, Nicholas, of Happysburgh, smith 2
5234798 2425766 2425766 defendant Levedy Robert husbandman 602186 602186 Levedy, Robert, of Happysburgh, husbandman 3
5234799 2425766 2425766 defendant Turnour William thatcher 602186 602186 Turnour, William, of Happysburgh, thatcher 4
5234800 2425766 2425766 defendant Bevys Thomas husbandman 602186 602186 Bevys, Thomas, of Happysburgh, husbandman 5
5234801 2425766 2425766 defendant Auncell John husbandman 602186 602186 Auncell, John, of Happysburgh, husbandman 6
5234802 2425766 2425766 defendant Cryspyng Edmund husbandman 602186 602186 Cryspyng, Edmund, of Happysburgh, husbandman 7
5234803 2425766 2425766 defendant Bange John husbandman 602186 602186 Bange, John, of Happysburgh, husbandman 8
5234804 2425766 2425766 defendant Middelton Edmund husbandman 602186 602186 Middelton, Edmund, of Happysburgh, husbandman 9
5237920 2426676 2426676 plaintiff Lynsted Nicholas   602186 602186 Lynsted, Nicholas, of Happysburgh 2
5237921 2426676 2426676 defendant Grene Robert (legal representative) 602186 602186 Grene, Robert, of Happysburgh, husbandman, executors of 0
5297490 2444271 2444271 defendant Doon (illegible) shipman 602186 602186 Doon, _, of Happysburgh, shipman 1
5540281 2517088 2517088 defendant Baxster Robert husbandman 602186 602186 Baxster, Robert, of Happysburgh, 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);