names

25 rows where place_id = 607880

✎ 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
3671233 1916976 1916976 defendant Tayllour Richard butcher 607880 607880 Tayllour, Richard, of Knesall, butcher 1
3712272 1930151 1930151 defendant Taylour Richard husbandman 607880 607880 Taylour, Richard, of Knesall, husbandman 2
3755187 1943573 1943573 defendant Taillour Richard husbandman 607880 607880 Taillour, Richard, of Knesall, husbandman 3
3759797 1945058 1945058 defendant Birkehed Robert husbandman 607880 607880 Birkehed, Robert, of Knesall, husbandman 0
3772774 1949177 1949177 defendant Taillour Richard husbandman 607880 607880 Taillour, Richard, of Knesall, husbandman 3
3777118 1950593 1950593 defendant Sparlyng Alan husbandman 607880 607880 Sparlyng, Alan, of Knesall, husbandman 0
3798887 1957568 1957568 defendant Tayler Richard husbandman 607880 607880 Tayler, Richard, of Knesall, husbandman 0
3805199 1959571 1959571 defendant Redesmyth Richard laborer 607880 607880 Redesmyth, Richard, of Knesall, laborer 2
3806684 1959989 1959989 defendant Smyth John husbandman 607880 607880 Smyth, John, of Knesall, husbandman 0
4059459 2045778 2045778 defendant Swanne William gent 607880 607880 Swanne, William, of Knesall, gent 0
4290989 2126841 2126841 defendant Yates Anthony gent 607880 607880 Yates, Anthony, of Knesall, gent 0
4607515 2233463 2233463 defendant Nicolson Thomas   607880 607880 Nicolson, Thomas, of Knesall 0
4812373 2299982 2299982 plaintiff Gylby John   607880 607880 Gylby, John, of Knesall, parson 0
4813038 2300194 2300194 plaintiff Gylby John   607880 607880 (Gylby, John, of Knesall, parson & Master 1
4839050 2308143 2308143 plaintiff Gylby John   607880 607880 Gylby, John, of Knesall, parson 0
4854127 2312702 2312702 defendant Marnham John husbandman 607880 607880 Marnham, John, of Knesall, husbandman 1
4871264 2317984 2317984 defendant Gylby John gent 607880 607880 Gylby, John, of Knesall, gent 0
4871266 2317985 2317985 defendant Gylby John gent 607880 607880 Gylby, John, of Knesall, gent 0
5069882 2377485 2377485 defendant Parker John yeoman 607880 607880 Parker, John, of Knesall, yeoman 2
5180059 2409904 2409904 defendant Aston John husbandman 607880 607880 Aston, John, of Knesall, husbandman 1
5226504 2423415 2423415 defendant Smyth William smith 607880 607880 Smyth, William, of Knesall, smith 3
5246069 2429016 2429016 defendant Gello Robert husbandman 607880 607880 Gello, Robert, of Knesall, husbandman 1
5323504 2452110 2452110 defendant Walker William husbandman 607880 607880 Walker, William, of Knesall, or of Kelom, Notts, husbandman 0
5341508 2457532 2457532 defendant Parker Robert yeoman 607880 607880 Parker, Robert, of Knesall, yeoman 13
5551185 2520376 2520376 defendant Pyche William husbandman 607880 607880 Pyche, William, of Knesall, husbandman 4

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