names

30 rows where place_id = 599651

✎ 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
3637604 1906571 1906571 defendant Selyok Richard bellfounder 599651 599651 Selyok, Richard, of Notyngham, bellfounder 0
3657824 1912698 1912698 defendant Smyth Richard   599651 599651 Smyth, Richard, of Notyngham 0
3746228 1940729 1940729 defendant Rose John grocer 599651 599651 Rose, John, of Notyngham, grocer 0
3746570 1940842 1940842 defendant Holand Lawrence   599651 599651 Holand, Lawrence, of Notyngham, gent, groom of the chamber 0
3746680 1940874 1940874 plaintiff Covell Emmote widow 599651 599651 Emmote his wife, formerly Emmote Selyok, of Notyngham, widow 1
3749517 1941760 1941760 defendant Howys John dyer 599651 599651 Howys, John, of Notyngham, dyer 0
3750856 1942189 1942189 plaintiff Mellours Robert (legal representative) 599651 599651 Mellours, Robert, of Notyngham, bellfounder, executors of 0
3750861 1942190 1942190 plaintiff Mellours Robert (legal representative) 599651 599651 Mellours, Robert, of Notyngham, bellfounder, executors of 0
3750865 1942190 1942190 defendant Holland Lawrence gent 599651 599651 Holland, Lawrence, of Notyngham, gent 0
3752429 1942681 1942681 defendant Hall Robert bellfounder 599651 599651 Hall, Robert, of Notyngham, bellfounder 0
3755430 1943652 1943652 plaintiff Williamson John draper 599651 599651 Williamson, John, of Notyngham, draper 0
3801067 1958250 1958250 defendant Chamberleyn Edward husbandman 599651 599651 Chamberleyn, Edward, of Notyngham, husbandman 0
3859114 1976539 1976539 defendant Wolley John yeoman or bellfounder 599651 599651 Wolley, John, of Notyngham, yeoman or bellfounder 0
3873125 1981226 1981226 defendant Permytter William mercer 599651 599651 Permytter, William, of Notyngham, mercer 2
4436347 2176103 2176103 defendant Braundeston Celia   599651 599651 Braundeston, Celia, of Notyngham 7
4446944 2183961 2183961 plaintiff Draper (illegible)   599651 599651 Draper, ---, of Notyngham 0
4454277 2186357 2186357 defendant Mason Roger   599651 599651 Mason, Roger, of Notyngham 0
4510996 2203889 2203889 defendant Sanneby John   599651 599651 Sanneby, John, of Notyngham 1
4537837 2212114 2212114 defendant Barkyng John   599651 599651 Barkyng, John, of Notyngham 0
4583299 2226199 2226199 defendant Morlay John   599651 599651 Morlay, John, of Notyngham 0
5240492 2427433 2427433 defendant Peyntour John merchant 599651 599651 Peyntour, John, of Notyngham, merchant 0
5244325 2428524 2428524 defendant Ayssheby Thomas deyster 599651 599651 Ayssheby, Thomas, of Notyngham, deyster 0
5244339 2428527 2428527 defendant Ayssheby Thomas dyer 599651 599651 Ayssheby, Thomas, of Notyngham, dyer 0
5577904 2528161 2528161 defendant Eton John gent 599651 599651 Eton, John, of Notyngham, gent 0
5581594 2529320 2529320 defendant Selyok John alderman 599651 599651 Selyok, John, of Notyngham, brasier, alderman 0
5581595 2529320 2529320 defendant Selyok Richard bellfounder 599651 599651 Selyok, Richard, of Notyngham, bellfounder 1
5589315 2531662 2531662 defendant Hyggyns William merchant 599651 599651 Hyggyns, William, of Notyngham, merchant 0
5592284 2532572 2532572 defendant Howet John taverner 599651 599651 Howet, John, of Notyngham, taverner 0
5593115 2532831 2532831 plaintiff Wylliamson John draper 599651 599651 Wylliamson, John, of Notyngham, draper 0
5618188 2549505 2549505 plaintiff Mason Roger   599651 599651 Mason, Roger, of Notyngham 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);