names

34 rows where place_id = 599335

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3636326 1906153 1906153 defendant Gayton Robert clothmaker 599335 599335 Gayton, Robert, of Ledys, Yorks, clothmaker 0
3675192 1918273 1918273 defendant Ottys George mercer 599335 599335 Ottys, George, of Ledys, Yorks, mercer 0
3704626 1927733 1927733 defendant Aked Edmund mercer 599335 599335 Aked, Edmund, of Ledys, Yorks, mercer 2
3705375 1927969 1927969 defendant Dyxson Robert mercer 599335 599335 Dyxson, Robert, of Ledys, Yorks, mercer 0
3705386 1927971 1927971 defendant Dyxson Robert mercer 599335 599335 Dyxson, Robert, of Ledys, Yorks, mercer 0
3738457 1938232 1938232 defendant Ottys William mercer 599335 599335 Ottys, William, of Ledys, Yorks, mercer 0
3772629 1949132 1949132 defendant Akehed alias Pacche Edmund mercer 599335 599335 Akehed alias Pacche, Edmund, of Ledys, Yorks, mercer 0
3772632 1949133 1949133 defendant Akehed Edmund mercer 599335 599335 Akehed, Edmund, of Ledys, Yorks, mercer 0
3772864 1949207 1949207 defendant Alkok alias Hawkoke John clothmaker 599335 599335 Alkok alias Hawkoke, John, of Ledys, Yorks, clothmaker 0
3772866 1949208 1949208 defendant Nelson Thomas clothmaker 599335 599335 Nelson, Thomas, of Ledys, Yorks, clothmaker 0
3772868 1949209 1949209 defendant Alkok alias Hawkoke John clothmaker 599335 599335 Alkok alias Hawkoke, John, of Ledys, Yorks, clothmaker 0
3772870 1949210 1949210 defendant Nelson Thomas clothmaker 599335 599335 Nelson, Thomas, of Ledys, Yorks, clothmaker 0
3778769 1951075 1951075 defendant Nelson Thomas yeoman 599335 599335 Nelson, Thomas, of Ledys, Yorks, yeoman 0
3778784 1951081 1951081 defendant Nelson Thomas yeoman 599335 599335 Nelson, Thomas, of Ledys, Yorks, yeoman 0
3781107 1951828 1951828 defendant Smegergyll Richard clothier 599335 599335 Smegergyll, Richard, of Ledys, Yorks, clothier 0
3781118 1951831 1951831 defendant Nelson Thomas clothier 599335 599335 Nelson, Thomas, of Ledys, Yorks, clothier 0
3785467 1953244 1953244 defendant Bell Peter clothier 599335 599335 Bell, Peter, of Ledys, Yorks, clothier 1
3805016 1959513 1959513 defendant Hoddyswell John yeoman 599335 599335 Hoddyswell, John, of Ledys, Yorks, yeoman 1
3805020 1959514 1959514 defendant Smegergyll Christopher   599335 599335 Smegergyll, Christopher, of Ledys, Yorks 0
3805025 1959515 1959515 defendant Smerger- Christopher yeoman 599335 599335 Smerger-, Christopher, of Ledys, Yorks, yeomanPattys, Edmund, of Ledys, yeoman 0
3821500 1964619 1964619 defendant Smyggergyll Christopher clothman 599335 599335 Smyggergyll, Christopher, of Ledys, Yorks, clothman 1
3862515 1977659 1977659 defendant Ottys George mercer 599335 599335 Ottys, George, of Ledys, Yorks, mercer 0
3882491 1984408 1984408 defendant Halewell Richard clothier 599335 599335 Halewell, Richard, of Ledys, Yorks, clothier 0
3917714 1996280 1996280 defendant Myrfelde Christopher gent 599335 599335 Myrfelde, Christopher, of Ledys, Yorks, gent 2
4947190 2341112 2341112 plaintiff Ledys Richard   599335 599335 Ledys, Richard, of Ledys, Yorks, yeoman, administrators of 0
5501308 2505348 2505348 defendant Smyth John tailor 599335 599335 Smyth, John, of Ledys, Yorks, tailor 4
5501343 2505355 2505355 defendant Colman Thomas yeoman 599335 599335 Colman, Thomas, of Ledys, Yorks, yeoman 0
5501349 2505356 2505356 defendant Colman Thomas yeoman 599335 599335 Colman, Thomas, of Ledys, Yorks, yeoman 0
5501411 2505372 2505372 defendant Smyth John tailor 599335 599335 Smyth, John, of Ledys, Yorks, tailor 0
5501860 2505508 2505508 defendant Banke Peter chapman 599335 599335 Banke, Peter, of Ledys, Yorks, chapman 0
5501867 2505509 2505509 defendant Banke Peter chapman 599335 599335 Banke, Peter, of Ledys, Yorks, chapman 0
5533201 2514934 2514934 defendant Beke Hugh chapman 599335 599335 Beke, Hugh, of Ledys, Yorks, chapman 2
5566770 2524876 2524876 defendant Medelton James gent 599335 599335 Medelton, James, of Ledys, Yorks, gent 0
5588797 2531509 2531509 plaintiff Pollard Richard clothman 599335 599335 Pollard, Richard, of Ledys, Yorks, clothman 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);