names

20 rows where place_id = 595329

✎ 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
3620051 1873847 1873847 defendant Ireton John gent 595329 595329 Ireton, John, of Ireton, gent 0
3972684 2015021 2015021 defendant Grene Robert husbandman 595329 595329 Grene, Robert, of Ireton, husbandman 1
4185064 2090283 2090283 defendant Dey John husbandman 595329 595329 Dey, John, of Ireton, husbandman 2
4640461 2243322 2243322 defendant Parker John   595329 595329 Parker, John, of Ireton 5
4682504 2260155 2260155 defendant Rappok William husbandman 595329 595329 Rappok, William, of Ireton, husbandman 2
4843007 2309353 2309353 defendant Alsop William yeoman 595329 595329 Alsop, William, of Ireton, yeoman 3
5115123 2390843 2390843 defendant Verney John yeoman 595329 595329 Verney, John, of Ireton, yeoman 2
5391464 2472633 2472633 defendant Ireton John gent 595329 595329 Ireton, John, of Ireton, gent 0
5391466 2472633 2472633 defendant Wyllyngton John laborer 595329 595329 Wyllyngton, John, of Ireton, laborer 2
5391468 2472633 2472633 defendant Hardy John husbandman 595329 595329 Hardy, John, of Ireton, husbandman 4
5391469 2472633 2472633 defendant Hardy William laborer 595329 595329 Hardy, William, of Ireton, laborer 5
5391470 2472633 2472633 defendant Hardy Thomas laborer 595329 595329 Hardy, Thomas, of Ireton, laborer 6
5391471 2472633 2472633 defendant Wodehous William husbandman 595329 595329 Wodehous, William, of Ireton, husbandman 7
5391472 2472633 2472633 defendant Wodehous John laborer 595329 595329 Wodehous, John, of Ireton, laborer 8
5391473 2472633 2472633 defendant Wodehous Robert laborer 595329 595329 Wodehous, Robert, of Ireton, laborer 9
5391474 2472633 2472633 defendant Sale Robert laborer 595329 595329 Sale, Robert, of Ireton, laborer 10
5392416 2472912 2472912 defendant Smyth Richard chaplain 595329 595329 Smyth, Richard, of Ireton, chaplain 16
5392417 2472912 2472912 defendant Day John laborer 595329 595329 Day, John, of Ireton, laborer 17
5392418 2472912 2472912 defendant Foucher Thomas laborer 595329 595329 Foucher, Thomas, of Ireton, laborer 18
5431146 2484256 2484256 defendant Stafford Thomas laborer 595329 595329 Stafford, Thomas, of Ireton, laborer 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);