names

36 rows where place_id = 586515

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3588935 1864191 1864191 defendant Bramfeld John, senior husbandman 586515 586515 Bramfeld, John, senior, of Walkern, husbandman 0
3588937 1864192 1864192 defendant Bramfeld John, senior husbandman 586515 586515 Bramfeld, John, senior, of Walkern, husbandman 0
3603531 1868772 1868772 defendant Waleys Richard husbandman 586515 586515 Waleys, Richard, of Walkern, husbandman 1
3699555 1926092 1926092 defendant Auncell John maltman 586515 586515 Auncell, John, of Walkern, maltman 2
3699559 1926093 1926093 defendant Auncell John maltman 586515 586515 Auncell, John, of Walkern, maltman 2
3706322 1928264 1928264 defendant Harley John yeoman 586515 586515 Harley, John, of Walkern, yeoman 2
3736170 1937556 1937556 plaintiff Humberston William (legal representative) 586515 586515 Humberston, William, of Walkern, yeoman, executors of 0
3782261 1952206 1952206 defendant Ussher William husbandman 586515 586515 Ussher, William, of Walkern, husbandman 0
3782262 1952206 1952206 defendant Halfhyde Roger laborer 586515 586515 Halfhyde, Roger, of Walkern, laborer 1
3804317 1959286 1959286 defendant Sheperd Thomas husbandman 586515 586515 Sheperd, Thomas, of Walkern, husbandman 0
3847903 1972920 1972920 plaintiff Homerston William (legal representative) 586515 586515 Homerston, William, of Walkern, executors of 0
4047173 2041435 2041435 defendant Bramfyld William   586515 586515 Bramfyld, William, of Walkern, malt carrier 0
4237395 2108672 2108672 defendant Cooe Christopher gent 586515 586515 Cooe, Christopher, of Walkern, gent 0
4237397 2108673 2108673 defendant Rottinge Robert laborer 586515 586515 Rottinge, Robert, of Walkern, laborer 0
4258447 2115791 2115791 defendant Cood Christopher gent 586515 586515 Cood, Christopher, of Walkern, gent 0
4277765 2122147 2122147 defendant Bramdeilde William   586515 586515 Bramdeilde, William, of Walkern, malt carrier 2
4279112 2122624 2122624 defendant Scarborowe Ralph maltman 586515 586515 Scarborowe, Ralph, of Walkern, maltman 0
4415025 2169598 2169598 defendant Popeler (illegible)   586515 586515 Popeler, _, of Walkern 0
4415026 2169598 2169598 defendant Popeler John   586515 586515 Popeler, John, of Walkern 1
4793542 2294090 2294090 defendant Scot John husbandman 586515 586515 Scot, John, of Walkern, husbandman 0
4909453 2329496 2329496 defendant Hawys Thomas husbandman 586515 586515 Hawys, Thomas, of Walkern, husbandman 0
4909454 2329496 2329496 defendant Beke Peter husbandman 586515 586515 with Beke, Peter, of Walkern, husbandman 1
4909455 2329496 2329496 defendant Lorde John husbandman 586515 586515 Lorde, John, of Walkern, husbandman 2
4979190 2350734 2350734 defendant Huddy Edmund husbandman 586515 586515 Huddy, Edmund, of Walkern, husbandman 1
4982687 2351735 2351735 defendant Gayly John maltman 586515 586515 Gayly, John, of Walkern, maltman 1
5048406 2371162 2371162 plaintiff Richardes Geoffrey   586515 586515 Richardes, Geoffrey, of Walkern, parson 0
5112295 2389980 2389980 plaintiff Humberston John   586515 586515 Humberston, John, of Walkern 0
5133358 2396248 2396248 plaintiff Humberston John   586515 586515 Humberston, John, of Walkern, on his own account 0
5326792 2453083 2453083 defendant Austeyn John, junior husbandman 586515 586515 Austeyn, John, junior, of Walkern, husbandman 0
5326793 2453083 2453083 defendant Lord Edmund husbandman 586515 586515 Lord, Edmund, of Walkern, husbandman 1
5326794 2453083 2453083 defendant Eyer William husbandman 586515 586515 Eyer, William, of Walkern, husbandman 2
5326795 2453083 2453083 defendant Fuller Thomas smith 586515 586515 Fuller, Thomas, of Walkern, smith 3
5345970 2458873 2458873 defendant Bynde Robert butcher 586515 586515 Bynde, Robert, of Walkern, butcher 0
5438297 2486387 2486387 defendant Mortymer John husbandman 586515 586515 Mortymer, John, of Walkern, husbandman 0
5487665 2501202 2501202 defendant Mortymer John husbandman 586515 586515 Mortymer, John, of Walkern, husbandman 0
5594826 2533351 2533351 defendant Mortymer John husbandman 586515 586515 Mortymer, John, of Walkern, husbandman 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);