names

19 rows where case_id = 2350146

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
4977225 2350146 2350146 plaintiff Pomeray Edward esq   Pomeray, Edward, esq 0
4977226 2350146 2350146 defendant Austyn John yeoman 829693 829693 Austyn, John, of Bukfaste, yeoman 0
4977227 2350146 2350146 defendant Bery William yeoman 829693 829693 Bery, William, of Bukfaste, yeoman 1
4977228 2350146 2350146 defendant Bery Robert yeoman 829693 829693 Bery, Robert, of Bukfaste, yeoman 2
4977229 2350146 2350146 defendant Drake Robert laborer 829693 829693 Drake, Robert, of Bukfaste, laborer 3
4977230 2350146 2350146 defendant Budde William helier or roofer 589257 589257 Budde, William, of Bukfastlegh, helier or roofer 4
4977231 2350146 2350146 defendant Choldewelle Walter carpenter 589257 589257 Choldewelle, Walter, of Bukfastlegh, carpenter 5
4977232 2350146 2350146 defendant Dounyng John carpenter 589257 589257 Dounyng, John, of Bukfastlegh, carpenter 6
4977233 2350146 2350146 defendant Tokere John carpenter 589257 589257 Tokere, John, of Bukfastlegh, carpenter 7
4977234 2350146 2350146 defendant Cole John carpenter 589257 589257 Cole, John, of Bukfastlegh, carpenter 8
4977235 2350146 2350146 defendant Lakeman John   589257 589257 Lakeman, John, of Bukfastlegh, mason 9
4977236 2350146 2350146 defendant Whyte Adam husbandman 589257 589257 Whyte, Adam, of Bukfastlegh, husbandman 10
4977237 2350146 2350146 defendant Simon John glover 589257 589257 Simon, John, of Bukfastlegh, glover 11
4977238 2350146 2350146 defendant Simon Thomas glover 589257 589257 Simon, Thomas, of Bukfastlegh, glover 12
4977239 2350146 2350146 defendant Lovetorre William glover 589257 589257 Lovetorre, William, of Bukfastlegh, glover 13
4977240 2350146 2350146 defendant Lovetorre John glover 589257 589257 Lovetorre, John, of Bukfastlegh, glover 14
4977241 2350146 2350146 defendant Wode Robert cordwainer 589257 589257 Wode, Robert, of Bukfastlegh, cordwainer 15
4977242 2350146 2350146 defendant Freynsshe William smith 589257 589257 Freynsshe, William, of Bukfastlegh, smith 16
4977243 2350146 2350146 defendant Rogger Richard carpenter 589257 589257 Rogger, Richard, of Bukfastlegh, carpenter 17

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