names

13 rows where case_id = 1875483

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3625390 1875483 1875483 plaintiff Willesthorp Miles     Willesthorp, Miles 0
3625391 1875483 1875483 defendant Snawsell Seth gent 589293 589293 Snawsell, Seth, of Bylton, gent 0
3625392 1875483 1875483 defendant Gayton Thomas yeoman 589293 589293 Gayton, Thomas, of Bylton, yeoman 1
3625393 1875483 1875483 defendant Chambre Lawrence yeoman 589293 589293 Chambre, Lawrence, of Bylton, yeoman 2
3625394 1875483 1875483 defendant Waven or Wanen James yeoman 589293 589293 Waven or Wanen, James, of Bylton, yeoman 3
3625395 1875483 1875483 defendant Wright William yeoman 589293 589293 Wright, William, of Bylton, yeoman 4
3625396 1875483 1875483 defendant Bebe or Beve James husbandman 589293 589293 Bebe or Beve, James, of Bylton, husbandman 5
3625397 1875483 1875483 defendant Langton Richard yeoman 596590 596590 Langton, Richard, of Wederby, yeoman 6
3625398 1875483 1875483 defendant Kyrkby Ralph yeoman 596591 596591 Kyrkby, Ralph, of Kirkhamerton, yeoman 7
3625399 1875483 1875483 defendant Dewes Peter walker 596591 596591 Dewes, Peter, of Kirkhamerton, walker 8
3625400 1875483 1875483 defendant Gell Richard walker 596591 596591 Gell, Richard, of Kirkhamerton, walker 9
3625401 1875483 1875483 defendant Lynton John yeoman 596592 596592 Lynton, John, of Non Monkton, yeoman 10
3625402 1875483 1875483 defendant Courtney Edward   596592 596592 Courtney, Edward, of Non Monkton 11

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