names

46 rows where place_id = 595560

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3620995 1874124 1874124 defendant Peke Benedict merchant 595560 595560 Peke, Benedict, of Topsam, merchant 0
3621349 1874219 1874219 defendant Peke Benedict merchant 595560 595560 Peke, Benedict, of Topsam, merchant 0
3634780 1905676 1905676 defendant Cawlyng Henry gent 595560 595560 Cawlyng, Henry, of Topsam, gent 0
3634782 1905677 1905677 defendant Cawlyng Henry gent 595560 595560 Cawlyng, Henry, of Topsam, gent 0
3636120 1906090 1906090 defendant Squyer John merchant 595560 595560 Squyer, John, of Topsam, merchant 0
3644498 1908698 1908698 plaintiff Fefer Michael (legal representative) 595560 595560 Fefer, Michael, of Topsam, administrator of 0
3644500 1908698 1908698 defendant Cowlyng Henry gent 595560 595560 Cowlyng, Henry, of Topsam, gent 0
3795469 1956460 1956460 defendant Hamell Ambrose merchant 595560 595560 Hamell, Ambrose, of Topsam, merchant 0
3802719 1958747 1958747 defendant Cowlyn Henry (legal representative) 595560 595560 Cowlyn, Henry, of Topsam, gent, executors of 0
3837889 1969764 1969764 defendant Coyle Thomas merchant 595560 595560 Coyle, Thomas, of Topsam, merchant 0
3884949 1985232 1985232 plaintiff Avery John (legal representative) 595560 595560 Avery, John, of Topsam, executors of 0
3886363 1985695 1985695 defendant Forde William merchant 595560 595560 Forde, William, of Topsam, merchant 1
3905945 1992273 1992273 defendant Ford William merchant 595560 595560 Ford, William, of Topsam, merchant 0
3906253 1992379 1992379 defendant Mongey John clerk 595560 595560 Mongey, John, of Topsam, clerk 0
3908060 1992991 1992991 defendant Furde William merchant 595560 595560 Furde, William, of Topsam, merchant 0
3908143 1993021 1993021 defendant Forde William merchant 595560 595560 Forde, William, of Topsam, merchant 0
3932605 2001198 2001198 defendant Denbold Michael yeoman 595560 595560 Denbold, Michael, of Topsam, yeoman 0
3979977 2017600 2017600 defendant Husband William husbandman 595560 595560 Husband, William, of Topsam, husbandman 1
3979980 2017601 2017601 defendant Husbond William husbandman 595560 595560 Husbond, William, of Topsam, husbandman 1
3982725 2018590 2018590 defendant Voyll John merchant 595560 595560 Voyll, John, of Topsam, merchant 0
3995501 2023138 2023138 plaintiff Coyle Thomas vintner 595560 595560 Coyle, Thomas, of Topsam, vintner 0
4006530 2027116 2027116 defendant Wichlacke Richard carrier 595560 595560 Wichlacke, Richard, of Topsam, carrier 0
4584749 2226655 2226655 defendant Whitelegh Nicholas   595560 595560 Whitelegh, Nicholas, of Topsam 0
4733016 2275505 2275505 defendant Olyver William husbandman 595560 595560 Olyver, William, of Topsam, husbandman 0
4759575 2283336 2283336 defendant Coyle John merchant 595560 595560 Coyle, John, of Topsam, merchant 3
4765880 2285324 2285324 defendant Poyer Robert husbandman 595560 595560 Poyer, Robert, of Topsam, husbandman 1
4797191 2295294 2295294 defendant Furton Richard chapman 595560 595560 Furton, Richard, of Topsam, chapman 0
4914974 2331191 2331191 defendant Holand John esq 595560 595560 Holand, John, of Topsam, esq 0
4980991 2351246 2351246 defendant Coyle John (legal representative) 595560 595560 Coyle, John, of Topsam, merchant, executrix of 3
4980992 2351246 2351246 defendant Coyle Agnes widow 595560 595560 Coyle, Agnes, of Topsam, widow 4
5105799 2388143 2388143 defendant Nycoll Oliver merchant 595560 595560 Nycoll, Oliver, of Topsam, merchant 0
5376598 2468279 2468279 defendant atte Well Thomas merchant 595560 595560 atte Well, Thomas, of Topsam, merchant 1
5383552 2470379 2470379 plaintiff Andrewe Mathewe   595560 595560 Andrewe, Mathewe, of Topsam 0
5383554 2470379 2470379 defendant Sketon Nicholas mariner 595560 595560 Sketon, Nicholas, of Topsam, mariner 1
5393302 2473139 2473139 defendant atte Welle Thomas merchant 595560 595560 atte Welle, Thomas, of Topsam, merchant 2
5395177 2473693 2473693 plaintiff A---- Mathew   595560 595560 A----, Mathew, of Topsam 0
5395178 2473693 2473693 defendant Sketon Nicholas miariner 595560 595560 Sketon, Nicholas, of Topsam, miariner 0
5395385 2473755 2473755 plaintiff Andrew Mathewe   595560 595560 Andrew, Mathewe, of Topsam 0
5413841 2479063 2479063 defendant Ilys William roper 595560 595560 Ilys, William, of Topsam, roper 2
5418914 2480580 2480580 defendant atte Welle Thomas merchant 595560 595560 atte Welle, Thomas, of Topsam, merchant 2
5421898 2481485 2481485 plaintiff Andrewe Mathew   595560 595560 Andrewe, Mathew, of Topsam 0
5429240 2483672 2483672 defendant Ilys William   595560 595560 Ilys, William, of Topsam, rope maker 0
5436994 2486000 2486000 defendant atte Welle Thomas merchant 595560 595560 atte Welle, Thomas, of Topsam, merchant 0
5465382 2494554 2494554 defendant Tayllour Richard merchant 595560 595560 Tayllour, Richard, of Topsam, merchant 1
5476866 2498086 2498086 defendant Taillour Richard merchant 595560 595560 Taillour, Richard, of Topsam, merchant 1
5532923 2514837 2514837 defendant Broke Thomas mariner 595560 595560 Broke, Thomas, of Topsam, mariner 3

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