names

20 rows where place_id = 801198

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
4778509 2289257 2289257 plaintiff Bere John merchant 801198 801198 Bere, John, of Berwyk on Twede, merchant 0
4856978 2313563 2313563 plaintiff Bere John merchant 801198 801198 Bere, John, of Berwyk on Twede, merchant 0
4856981 2313564 2313564 plaintiff Bere John merchant 801198 801198 Bere, John, of Berwyk on Twede, merchant 0
4857737 2313797 2313797 defendant Ryddale John merchant 801198 801198 (Ryddale, John, of Berwyk on Twede, merchant 4
4857738 2313797 2313797 defendant Bullok John merchant 801198 801198 Bullok, John, of Berwyk on Twede, merchant 5
4887158 2322828 2322828 defendant Gryndon William chapman 801198 801198 Gryndon, William, of Berwyk on Twede, or of Alnewyk, Northumb, chapman 0
5020120 2362773 2362773 defendant Dolphynby Robert   801198 801198 Dolphynby, Robert, of Berwyk on Twede, merchant, administrators of 2
5020123 2362773 2362773 defendant Dolphynby Alexander husbandman 801198 801198 Dolphynby, Alexander, of Berwyk on Twede, husbandman 5
5248116 2429585 2429585 defendant Carre Ralph (legal representative) 801198 801198 Carre, Ralph, of Berwyk on Twede, gent, apprentice of Brampton, John, of London, merchant, executors of 0
5250863 2430382 2430382 defendant Werke Robert merchant 801198 801198 Werke, Robert, of Berwyk on Twede, merchant 0
5250864 2430382 2430382 defendant Borell Edmund merchant 801198 801198 Borell, Edmund, of Berwyk on Twede, merchant 1
5250903 2430391 2430391 defendant Werke Robert merchant 801198 801198 Werke, Robert, of Berwyk on Twede, merchant 0
5250904 2430391 2430391 defendant Borell Edmund merchant 801198 801198 Borell, Edmund, of Berwyk on Twede, merchant 1
5502407 2505674 2505674 defendant Berhalghe Thomas   801198 801198 Berhalghe, Thomas, of Berwyk on Twede, merchant, bailiff 1
5502408 2505674 2505674 defendant Lilborn John   801198 801198 Lilborn, John, of Berwyk on Twede, esq, marshall 2
5502409 2505674 2505674 defendant Morton George yeoman 801198 801198 Morton, George, of Berwyk on Twede, yeoman 3
5502412 2505675 2505675 defendant Lylborn John   801198 801198 Lylborn, John, of Berwyk on Twede, esq, marshall 1
5502413 2505675 2505675 defendant Morton George soldier 801198 801198 Morton, George, of Berwyk on Twede, yeoman, soldier 2
5502414 2505675 2505675 defendant Berhalghe Thomas   801198 801198 Berhalghe, Thomas, of Berwyk on Twede, merchant, bailiff 3
5509861 2507923 2507923 defendant Turvull David yeoman 801198 801198 Turvull, David, of Berwyk on Twede, yeoman 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);