names

43 rows where place_id = 595345

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3620101 1873862 1873862 defendant Geldred John yeoman 595345 595345 Geldred, John, of Thurkilby, yeoman 0
3626587 1903169 1903169 defendant Peirson William husbandman 595345 595345 Peirson, William, of Thurkilby, husbandman 1
3626588 1903169 1903169 defendant Smyth Thomas husbandman 595345 595345 Smyth, Thomas, of Thurkilby, husbandman 2
3626589 1903169 1903169 defendant Peirson Robert husbandman 595345 595345 Peirson, Robert, of Thurkilby, husbandman 3
3626590 1903169 1903169 defendant Symson John husbandman 595345 595345 Symson, John, of Thurkilby, husbandman 4
4516384 2205535 2205535 defendant Bussy Robert   595345 595345 Bussy, Robert, of Thurkilby 0
4549075 2215646 2215646 defendant Bussy Robert   595345 595345 Bussy, Robert, of Thurkilby 0
4565366 2220735 2220735 defendant Bussy Robert   595345 595345 (Bussy, Robert, of Thurkilby 1
4617538 2236497 2236497 defendant Smyth John   595345 595345 Smyth, John, of Thurkilby 2
4617539 2236497 2236497 defendant Randby William   595345 595345 Randby, William, of Thurkilby 3
4617540 2236497 2236497 defendant Ouresyre John   595345 595345 Ouresyre, John, of Thurkilby 4
4662400 2249714 2249714 defendant Vendenale Walter chaplain 595345 595345 Vendenale, Walter, of Thurkilby, chaplain 0
4662401 2249714 2249714 defendant Stubbes John husbandman 595345 595345 Stubbes, John, of Thurkilby, husbandman 1
4670996 2256598 2256598 defendant Warde William husbandman 595345 595345 Warde, William, of Thurkilby, husbandman 2
4670998 2256598 2256598 defendant Clerk William husbandman 595345 595345 Clerk, William, of Thurkilby, husbandman 4
4721317 2271998 2271998 plaintiff Carter Richard   595345 595345 Carter, Richard, of Thurkilby 0
4728558 2274172 2274172 defendant Clerk William husbandman 595345 595345 Clerk, William, of Thurkilby, husbandman 0
4728559 2274172 2274172 defendant Semer William husbandman 595345 595345 Semer, William, of Thurkilby, husbandman 1
4728560 2274172 2274172 defendant Whithande Robert husbandman 595345 595345 Whithande, Robert, of Thurkilby, husbandman 2
4728561 2274172 2274172 defendant Pyper William husbandman 595345 595345 Pyper, William, of Thurkilby, husbandman 3
4728562 2274172 2274172 defendant Maryot John husbandman 595345 595345 Maryot, John, of Thurkilby, husbandman 4
4728563 2274172 2274172 defendant Gawescowe William husbandman 595345 595345 Gawescowe, William, of Thurkilby, husbandman 5
4728564 2274172 2274172 defendant Stokesley Thomas husbandman 595345 595345 Stokesley, Thomas, of Thurkilby, husbandman 6
4728565 2274172 2274172 defendant Pyper John husbandman 595345 595345 Pyper, John, of Thurkilby, husbandman 7
4824247 2303651 2303651 defendant Etton alias Oversyre John husbandman 595345 595345 Etton alias Oversyre, John, of Thurkilby, husbandman 0
4829976 2305419 2305419 defendant Barker William husbandman 595345 595345 Barker, William, of Thurkilby, husbandman 1
4854082 2312685 2312685 defendant Hebden Richard yeoman 595345 595345 Hebden, Richard, of Thurkilby, yeoman 2
4856794 2313499 2313499 defendant Barker William husbandman 595345 595345 Barker, William, of Thurkilby, husbandman 1
4864644 2315914 2315914 defendant Dawe William husbandman 595345 595345 Dawe, William, of Thurkilby, husbandman 4
4898525 2326188 2326188 defendant Thornton John husbandman 595345 595345 Thornton, John, of Thurkilby, husbandman 1
5012498 2360502 2360502 defendant Conton Thomas yeoman 595345 595345 Conton, Thomas, of Thurkilby, yeoman 0
5033877 2366784 2366784 defendant Couton Thomas yeoman 595345 595345 Couton, Thomas, of Thurkilby, yeoman 1
5073195 2378471 2378471 defendant Stokdale Ralph gent 595345 595345 Stokdale, Ralph, of Thurkilby, gent 1
5113128 2390236 2390236 defendant Stonley Robert yeoman 595345 595345 Stonley, Robert, of Thurkilby, yeoman 0
5251060 2430437 2430437 defendant Mortymer William husbandman 595345 595345 Mortymer, William, of Thurkilby, husbandman 0
5357324 2462355 2462355 defendant Geldard John yeoman 595345 595345 Geldard, John, of Thurkilby, yeoman 0
5357325 2462355 2462355 defendant Revele or Renele Alan yeoman 595345 595345 Revele or Renele, Alan, of Thurkilby, yeoman 1
5357326 2462355 2462355 defendant Preston John laborer 595345 595345 Preston, John, of Thurkilby, laborer 2
5407485 2477212 2477212 defendant Cramylton William yeoman 595345 595345 Cramylton, William, of Thurkilby, yeoman 1
5420729 2481125 2481125 defendant Cramylton William yeoman 595345 595345 Cramylton, William, of Thurkilby, yeoman 1
5527859 2513283 2513283 defendant Pierson Robert husbandman 595345 595345 Pierson, Robert, of Thurkilby, husbandman 1
5527860 2513283 2513283 defendant Robson John husbandman 595345 595345 Robson, John, of Thurkilby, husbandman 2
5527861 2513283 2513283 defendant Kendale Thomas husbandman 595345 595345 Kendale, Thomas, of Thurkilby, husbandman 3

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