names

31 rows where place_id = 587141

✎ 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
3590581 1864696 1864696 defendant Budder Thomas husbandman 587141 587141 Budder, Thomas, of Bishops Hatfeld, Herts, husbandman 2
3620710 1874052 1874052 defendant Rogers John yeoman 587141 587141 Rogers, John, of Bishops Hatfeld, Herts, yeoman 0
3632696 1905044 1905044 defendant Wymer Clement clerk 587141 587141 Wymer, Clement, of Bishops Hatfeld, Herts, clerk 0
3634637 1905633 1905633 defendant Fortescu John esq 587141 587141 Fortescu, John, of Bishops Hatfeld, Herts, esq 0
3669548 1916413 1916413 defendant Wright Thomas singleman 587141 587141 Wright, Thomas, of Bishops Hatfeld, Herts, laborer, kisnman, of Wright, John, of Monken Hadley, Middx, singleman 0
3673802 1917836 1917836 defendant Bassyngborne John gent 587141 587141 Bassyngborne, John, of Bishops Hatfeld, Herts, gent 0
4000617 2024994 2024994 defendant Hickman Richard yeoman 587141 587141 Hickman, Richard, of Bishops Hatfeld, Herts, yeoman 0
4018164 2031219 2031219 defendant Caldwell George chapman 587141 587141 Caldwell, George, of Bishops Hatfeld, Herts, chapman 1
4797342 2295341 2295341 defendant Leper Henry collier 587141 587141 Leper, Henry, of Bishops Hatfeld, Herts, collier 0
4897173 2325772 2325772 defendant Neuman Nicholas smith 587141 587141 Neuman, Nicholas, of Bishops Hatfeld, Herts, smith 0
4934486 2337179 2337179 defendant Bygge John husbandman 587141 587141 Bygge, John, of Bishops Hatfeld, Herts, husbandman 0
4956559 2343919 2343919 defendant Baseley John husbandman 587141 587141 Baseley, John, of Bishops Hatfeld, Herts, husbandman 3
4956569 2343920 2343920 defendant Baseley John husbandman 587141 587141 Baseley, John, of Bishops Hatfeld, Herts, husbandman 3
4960697 2345158 2345158 defendant Fyssh William gent 587141 587141 Fyssh, William, of Bishops Hatfeld, Herts, gent 1
4960700 2345159 2345159 defendant Fyssh William gent 587141 587141 Fyssh, William, of Bishops Hatfeld, Herts, gent 1
4969345 2347790 2347790 defendant Basseley William husbandman 587141 587141 Basseley, William, of Bishops Hatfeld, Herts, husbandman 0
5033005 2366541 2366541 defendant Grene John butcher 587141 587141 Grene, John, of Bishops Hatfeld, Herts, butcher 3
5033013 2366542 2366542 defendant Grene John butcher 587141 587141 Grene, John, of Bishops Hatfeld, Herts, butcher 1
5060074 2374579 2374579 defendant Bassyngborn John esq 587141 587141 Bassyngborn, John, of Bishops Hatfeld, Herts, esq 0
5060497 2374717 2374717 defendant Been John yeoman 587141 587141 Been, John, of Bishops Hatfeld, Herts, yeoman 1
5321017 2451378 2451378 defendant Clyff William yeoman 587141 587141 Clyff, William, of Bishops Hatfeld, Herts, yeoman 1
5329896 2454013 2454013 defendant Swan Thomas esq 587141 587141 Swan, Thomas, of Bishops Hatfeld, Herts, esq 0
5335317 2455632 2455632 defendant Swane Thomas esq 587141 587141 Swane, Thomas, of Bishops Hatfeld, Herts, esq 0
5340881 2457346 2457346 defendant Rogears John innholder 587141 587141 Rogears, John, of Bishops Hatfeld, Herts, innholder 0
5340885 2457347 2457347 defendant Rogeers John innholder 587141 587141 Rogeers, John, of Bishops Hatfeld, Herts, innholder 0
5343126 2458040 2458040 defendant Swan Thomas gent 587141 587141 Swan, Thomas, of Bishops Hatfeld, Herts, gent 0
5347897 2459485 2459485 defendant Swan Thomas (legal representative) 587141 587141 Swan, Thomas, of Bishops Hatfeld, Herts, gent, executors of 0
5481951 2499534 2499534 defendant Kebyll Roger yeoman 587141 587141 Kebyll, Roger, of Bishops Hatfeld, Herts, yeoman 3
5525227 2512484 2512484 plaintiff Grey William tailor 587141 587141 Grey, William, of Bishops Hatfeld, Herts, tailor 0
5543765 2518156 2518156 defendant Bassyngbourne John esq 587141 587141 Bassyngbourne, John, of Bishops Hatfeld, Herts, esq 0
5585994 2530666 2530666 defendant Maidewell Thomas corveser 587141 587141 Maidewell, Thomas, of Bishops Hatfeld, Herts, corveser 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);