names

28 rows where place_id = 586893

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3589915 1864485 1864485 defendant Smyth Thomas husbandman 586893 586893 Smyth, Thomas, of Toft Monks, Norf, husbandman 3
3742215 1939434 1939434 defendant Davye John husbandman 586893 586893 Davye, John, of Toft Monks, Norf, husbandman 0
3742284 1939458 1939458 defendant Davy William   586893 586893 Davy, William, of Toft Monks, Norf, organ player 1
3743630 1939884 1939884 defendant Myleham Robert singleman 586893 586893 Myleham, Robert, of Toft Monks, Norf, singleman 0
3754355 1943319 1943319 defendant Kene Thomas yeoman 586893 586893 Kene, Thomas, of Toft Monks, Norf, yeoman 0
3765725 1946945 1946945 defendant Davy William carpenter 586893 586893 Davy, William, of Toft Monks, Norf, carpenter 1
3771608 1948820 1948820 defendant Davy William husbandman and organ player 586893 586893 Davy, William, of Toft Monks, Norf, husbandman and organ player 0
3773515 1949428 1949428 defendant Davy William   586893 586893 Davy, William, of Toft Monks, Norf, organ player 0
3773519 1949429 1949429 defendant Davy William   586893 586893 Davy, William, of Toft Monks, Norf, organ player 0
3789302 1954474 1954474 defendant Davy William husbandman 586893 586893 Davy, William, of Toft Monks, Norf, husbandman 0
3838173 1969855 1969855 defendant Davy William yeoman or organplayer 586893 586893 Davy, William, of Toft Monks, Norf, yeoman or organplayer 0
3839588 1970304 1970304 defendant Davy William yeoman or organplayer 586893 586893 Davy, William, of Toft Monks, Norf, yeoman or organplayer 0
3849201 1973345 1973345 defendant Broke Thomas husbandman 586893 586893 Broke, Thomas, of Toft Monks, Norf, husbandman 4
3851018 1973911 1973911 defendant Davy William yeoman or organ player 586893 586893 Davy, William, of Toft Monks, Norf, yeoman or organ player 0
3882517 1984418 1984418 defendant Davy William yeoman 586893 586893 Davy, William, of Toft Monks, Norf, yeoman 0
3922623 1997882 1997882 defendant Barker John husbandman 586893 586893 Barker, John, of Toft Monks, Norf, husbandman 1
4275702 2121446 2121446 defendant Pulham Arthur yeoman 586893 586893 Pulham, Arthur, of Toft Monks, Norf, yeoman 2
4278822 2122530 2122530 defendant Kedgell Miles gent 586893 586893 together with Kedgell, Miles, of Toft Monks, Norf, gent 2
4329211 2140082 2140082 defendant Kedgell Miles gent 586893 586893 Kedgell, Miles, of Toft Monks, Norf, gent 0
4972049 2348576 2348576 defendant Ryston Thomas husbandman 586893 586893 Ryston, Thomas, of Toft Monks, Norf, husbandman 0
5137407 2397452 2397452 defendant Ryston Geoffrey husbandman 586893 586893 Ryston, Geoffrey, of Toft Monks, Norf, husbandman 0
5142845 2399036 2399036 defendant Reydon William husbandman 586893 586893 Reydon, William, of Toft Monks, Norf, husbandman 2
5164201 2405269 2405269 defendant Reydon William husbandman 586893 586893 Reydon, William, of Toft Monks, Norf, husbandman 2
5164208 2405270 2405270 defendant Reydon William husbandman 586893 586893 Reydon, William, of Toft Monks, Norf, husbandman 2
5177193 2409023 2409023 defendant Odams John yeoman 586893 586893 Odams, John, of Toft Monks, Norf, yeoman 2
5281459 2439646 2439646 defendant Stronde James yeoman 586893 586893 Stronde, James, of Toft Monks, Norf, yeoman 0
5533777 2515111 2515111 defendant Doget John husbandman 586893 586893 Doget, John, of Toft Monks, Norf, husbandman 1
5607151 2537126 2537126 defendant Smyth Benedict husbandman 586893 586893 Smyth, Benedict, of Toft Monks, Norf, husbandman 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);