names

22 rows where place_id = 615029

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3706762 1928400 1928400 defendant Coryngdon Nicholas laborer 615029 615029 Coryngdon, Nicholas, of Bageworth, laborer 1
3760173 1945180 1945180 defendant Bell Walter husbandman 615029 615029 Bell, Walter, of Bageworth, husbandman 0
3906220 1992368 1992368 defendant Cocke Richard husbandman 615029 615029 Cocke, Richard, of Bageworth, husbandman 2
3917300 1996144 1996144 defendant Hardyng John husbandman 615029 615029 Hardyng, John, of Bageworth, husbandman 0
3917301 1996144 1996144 defendant Saunde John husbandman 615029 615029 Saunde, John, of Bageworth, husbandman 1
3917302 1996144 1996144 defendant Bubbe Walter husbandman 615029 615029 Bubbe, Walter, of Bageworth, husbandman 2
3917303 1996144 1996144 defendant Fyllto William husbandman 615029 615029 Fyllto, William, of Bageworth, husbandman 3
3931379 2000791 2000791 defendant Vyncent Thomas gent 615029 615029 Vyncent, Thomas, of Bageworth, gent 0
3933399 2001464 2001464 defendant Vyncent Thomas gent 615029 615029 Vyncent, Thomas, of Bageworth, gent 0
3958443 2010023 2010023 defendant Rogers Hugh husbandman 615029 615029 Rogers, Hugh, of Bageworth, husbandman 0
4005709 2026816 2026816 defendant Chyld John yeoman 615029 615029 Chyld, John, of Bageworth, yeoman 0
4005711 2026817 2026817 defendant Chyld John yeoman 615029 615029 Chyld, John, of Bageworth, yeoman 0
4593294 2229194 2229194 defendant Pye John   615029 615029 Pye, John, of Bageworth 0
4593295 2229194 2229194 defendant Hynton William   615029 615029 Hynton, William, of Bageworth 1
4593296 2229194 2229194 defendant Joneson Robert   615029 615029 Joneson, Robert, of Bageworth 2
4593297 2229194 2229194 defendant Tewere Robert   615029 615029 Tewere, Robert, of Bageworth 3
4593299 2229194 2229194 defendant Godewyn William   615029 615029 Godewyn, William, of Bageworth 5
4593300 2229194 2229194 defendant Staunderose Walter   615029 615029 Staunderose, Walter, of Bageworth 6
4593301 2229194 2229194 defendant Eddeston Joan   615029 615029 Eddeston, Joan, of Bageworth 7
4593302 2229194 2229194 defendant Watte Richard   615029 615029 Watte, Richard, of Bageworth 8
4593303 2229194 2229194 defendant Joneson William   615029 615029 Joneson, William, of Bageworth 9
5133567 2396309 2396309 defendant Lideford William hoper 615029 615029 Lideford, William, of bageworth, hoper 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);