names

21 rows where place_id = 593422

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3611746 1871337 1871337 defendant Turnbull Robert husbandman 593422 593422 Turnbull, Robert, of Cavendissh, husbandman 0
3611747 1871337 1871337 defendant Heggeman Ralph fuller 593422 593422 Heggeman, Ralph, of Cavendissh, fuller 1
3762556 1945934 1945934 plaintiff Goldyng Thomas yeoman 593422 593422 Goldyng, Thomas, of Cavendissh, yeoman 0
3780688 1951691 1951691 plaintiff Goldyng Thomas yeoman 593422 593422 Goldyng, Thomas, of Cavendissh, yeoman 0
3780690 1951692 1951692 plaintiff Goldyng Thomas yeoman 593422 593422 Goldyng, Thomas, of Cavendissh, yeoman 0
3780692 1951693 1951693 plaintiff Goldyng Thomas yeoman 593422 593422 Goldyng, Thomas, of Cavendissh, yeoman 0
3780694 1951694 1951694 plaintiff Goldyng Thomas yeoman 593422 593422 Goldyng, Thomas, of Cavendissh, yeoman 0
4522785 2207463 2207463 defendant Fullere John   593422 593422 Fullere, John, of Cavendissh 1
4838346 2307908 2307908 defendant Fuller Simon husbandman 593422 593422 Fuller, Simon, of Cavendissh, husbandman 0
5121537 2392730 2392730 defendant Shord John husbandman 593422 593422 Shord, John, of Cavendissh, husbandman 1
5140698 2398392 2398392 plaintiff the Raven Joan widow 593422 593422 the Raven, Joan, of Cavendissh, widow 0
5140700 2398392 2398392 plaintiff Haukyn John   593422 593422 Haukyn, John, of Cavendissh 2
5140702 2398393 2398393 plaintiff the Raven Joan widow 593422 593422 the Raven, Joan, of Cavendissh, widow 0
5140704 2398393 2398393 plaintiff Haukyn John   593422 593422 Haukyn, John, of Cavendissh 2
5140747 2398408 2398408 defendant Shorde William husbandman 593422 593422 Shorde, William, of Cavendissh, husbandman 1
5143133 2399126 2399126 plaintiff Hauykyn John   593422 593422 Hauykyn, John, of Cavendissh 2
5158725 2403672 2403672 plaintiff Raven Joan the widow 593422 593422 Raven, Joan the, of Cavendissh, widow 0
5158727 2403672 2403672 plaintiff Haukyn John   593422 593422 Haukyn, John, of Cavendissh 2
5389114 2471935 2471935 defendant Olyve William weaver 593422 593422 Olyve, William, of Cavendissh, weaver 1
5462739 2493764 2493764 defendant Broun John   593422 593422 Broun, John, of Cavendissh, mill wright 0
5592006 2532489 2532489 defendant Smyth John gent 593422 593422 Smyth, John, of Cavendissh, gent 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);