names

17 rows where place_id = 592430

✎ 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
3607672 1870054 1870054 defendant Woullse or Woulffe Robert shipman 592430 592430 Woullse or Woulffe, Robert, of Bawetre, Yorks, shipman 0
4806069 2298106 2298106 defendant Morton Charles   592430 592430 Morton, Charles, of Bawetre, Yorks, esq, son & heir of Tobert Morton, of Bawetre 4
4806078 2298107 2298107 defendant Morton Charles   592430 592430 Morton, Charles, of Bawetre, Yorks, esq, son & heir of Robert Morton 4
4854210 2312726 2312726 defendant Morton Charles gent 592430 592430 Morton, Charles, of Bawetre, Yorks, gent 0
4856321 2313351 2313351 defendant Morton Charles esq 592430 592430 Morton, Charles, of Bawetre, Yorks, esq 0
4932121 2336442 2336442 defendant Morton Charles   592430 592430 Morton, Charles, of Bawetre, Yorks 0
5001782 2357419 2357419 defendant Byrkes George yeoman 592430 592430 Byrkes, George, of Bawetre, Yorks, yeoman 0
5130105 2395293 2395293 plaintiff Dukmanton Robert mercer 592430 592430 Dukmanton, Robert, of Bawetre, Yorks, mercer 0
5149421 2400964 2400964 plaintiff Dukmanton Robert mercer 592430 592430 Dukmanton, Robert, of Bawetre, Yorks, mercer 0
5238513 2426854 2426854 defendant Gayteclyf Thomas   592430 592430 Gayteclyf, Thomas, of Bawetre, Yorks, mason 0
5312038 2448631 2448631 defendant Drapur Richard draper 592430 592430 Drapur, Richard, of Bawetre, Yorks, draper 1
5312041 2448632 2448632 defendant Drapur Richard draper 592430 592430 Drapur, Richard, of Bawetre, Yorks, draper 1
5315227 2449609 2449609 defendant Hole Richard yeoman 592430 592430 Hole, Richard, of Bawetre, Yorks, yeoman 2
5446710 2488913 2488913 plaintiff Hall John yeoman 592430 592430 Hall, John, of Bawetre, Yorks, yeoman 0
5459300 2492691 2492691 plaintiff Hall John yeoman 592430 592430 Hall, John, of Bawetre, Yorks, yeoman 0
5470964 2496250 2496250 plaintiff Hall John yeoman 592430 592430 Hall, John, of Bawetre, Yorks, yeoman 0
5480799 2499215 2499215 defendant Inkersell William dyer 592430 592430 Inkersell, William, of Bawetre, Yorks, dyer 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);