names

16 rows where place_id = 642667

✎ 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
3867246 1979282 1979282 defendant Marten James   642667 642667 Marten, James, of Walle, surgeon 0
3869278 1979966 1979966 defendant Nayle John yeoman 642667 642667 Nayle, John, of Walle, yeoman 2
3869282 1979967 1979967 defendant Nayle John yeoman 642667 642667 Nayle, John, of Walle, yeoman 2
4106485 2062611 2062611 defendant Asshemolle John husbandman 642667 642667 Asshemolle, John, of Walle, or of Pype Hyll, husbandman 0
4106488 2062612 2062612 defendant Asshemolle John husbandman 642667 642667 Asshemolle, John, of Walle, or of Pypehyll, husbandman 0
4324965 2138733 2138733 defendant Howson William husbandman 642667 642667 Howson, William, of Walle, husbandman 1
4429158 2173926 2173926 defendant Sprenchehose John   642667 642667 Sprenchehose, John, of Walle 0
4429276 2173964 2173964 defendant Foner Randolf le   642667 642667 Foner, Randolf le, of Walle 8
4760577 2283656 2283656 defendant Aleynesson William yeoman 642667 642667 Aleynesson, William, of Walle, yeoman 3
4872027 2318218 2318218 defendant Halsey Richard husbandman 642667 642667 Halsey, Richard, of Walle, husbandman 10
4872053 2318219 2318219 defendant Halsey Richard husbandman 642667 642667 Halsey, Richard, of Walle, husbandman 16
5020910 2363012 2363012 defendant Baylly Richard husbandman 642667 642667 Baylly, Richard, of Walle under Eywode, husbandman 2
5020911 2363012 2363012 defendant Smyth Richard husbandman 642667 642667 Smyth, Richard, of Walle under Eywode, husbandman 3
5241317 2427661 2427661 defendant Radnore John husbandman 642667 642667 Radnore, John, of Walle under Gywode, husbandman 0
5241321 2427662 2427662 defendant Radnore John husbandman 642667 642667 Radnore, John, of Walle under Gywode, husbandman 0
5271962 2436882 2436882 defendant Baxster John husbandman 642667 642667 Baxster, John, of Walle, husbandman 1

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