names

19 rows where case_id = 2450390

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
5317723 2450390 2450390 plaintiff Fortescu John knight   Fortescu, John, knight 0
5317724 2450390 2450390 plaintiff Illyngworth Richard knight   Illyngworth, Richard, knight 1
5317725 2450390 2450390 plaintiff Curson Thomas esq   Curson, Thomas, esq 2
5317726 2450390 2450390 defendant Chaldewell Richard husbandman 591977 591977 Chaldewell, Richard, of Laxton, husbandman 0
5317727 2450390 2450390 defendant Chappell John husbandman 591977 591977 Chappell, John, of Laxton, husbandman 1
5317728 2450390 2450390 defendant Chappell Henry husbandman 591977 591977 Chappell, Henry, of Laxton, husbandman 2
5317729 2450390 2450390 defendant Taillour John husbandman 872708 872708 Taillour, John, of Laxton Morehous, husbandman 3
5317730 2450390 2450390 defendant Cluke John husbandman 597971 597971 Cluke, John, of North Leverton, husbandman 4
5317731 2450390 2450390 defendant Wright Peter   591977 591977 Wright, Peter, of Laxton, wright 5
5317732 2450390 2450390 defendant Dughty Robert shoemaker 591977 591977 Dughty, Robert, of Laxton, shoemaker 6
5317733 2450390 2450390 defendant Leverton William husbandman 591977 591977 Leverton, William, of Laxton, husbandman 7
5317734 2450390 2450390 defendant Leveton William husbandman 591977 591977 Leveton, William, of Laxton, husbandman 8
5317735 2450390 2450390 defendant Leverton Simon yeoman 591977 591977 Leverton, Simon, of Laxton, yeoman 9
5317736 2450390 2450390 defendant Snoe Robert yeoman 591977 591977 Snoe, Robert, of Laxton, yeoman 10
5317737 2450390 2450390 defendant Snowe William yeoman 591977 591977 Snowe, William, of Laxton, yeoman 11
5317738 2450390 2450390 defendant Telyer John husbandman 591977 591977 Telyer, John, of Laxton, husbandman 12
5317739 2450390 2450390 defendant Kyrkegarth John husbandman 591977 591977 Kyrkegarth, John, of Laxton, husbandman 13
5317740 2450390 2450390 defendant Hill John husbandman 591977 591977 Hill, John, of Laxton, husbandman 14
5317741 2450390 2450390 defendant Feld Robet miller 872710 872710 Feld, Robet, of Kyrkegarth, miller 15

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