names

11 rows where place_id = 598844

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3634287 1905521 1905521 defendant Bown Roger husbandman 598844 598844 Bown, Roger, of Matloke, husbandman 2
3773356 1949380 1949380 defendant Tagge John husbandman 598844 598844 Tagge, John, of Matloke, husbandman 1
3903396 1991360 1991360 defendant Tagge William yeoman 598844 598844 Tagge, William, of Matloke, yeoman 1
5268904 2436018 2436018 defendant Helde Thurstan yeoman 598844 598844 Helde, Thurstan, of Matloke, yeoman 8
5268906 2436018 2436018 defendant Amote Thomas laborer 598844 598844 Amote, Thomas, of Matloke, laborer 10
5268907 2436018 2436018 defendant Burton John husbandman 598844 598844 Burton, John, of Matloke, husbandman 11
5574821 2527205 2527205 defendant Bowne Roger husbandman 598844 598844 Bowne, Roger, of Matloke, husbandman 0
5574823 2527205 2527205 defendant Spateman Edward husbandman 598844 598844 Spateman, Edward, of Matloke, husbandman 2
5586369 2530780 2530780 defendant Flynt Henry miner 598844 598844 Flynt, Henry, of Matloke, miner 1
5586959 2530949 2530949 defendant Madder John husbandman 598844 598844 Madder, John, of Matloke, husbandman 1
5593267 2532875 2532875 defendant Flynt James husbandman 598844 598844 Flynt, James, of Matloke, husbandman 6

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