names

32 rows where place_id = 595982

✎ 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
3622655 1874616 1874616 defendant Wylson Richard merchant 595982 595982 Wylson, Richard, of Cley juxta Mare, Norf, merchant 1
3638164 1906753 1906753 defendant Childe Nicholas yeoman 595982 595982 Childe, Nicholas, of Cley juxta Mare, Norf, yeoman 0
3745696 1940562 1940562 defendant Collys Thomas yeoman 595982 595982 Collys, Thomas, of Cley juxta Mare, Norf, yeoman 0
3758640 1944697 1944697 defendant Collys Thomas yeoman 595982 595982 Collys, Thomas, of Cley juxta Mare, Norf, yeoman 0
3848079 1972977 1972977 defendant Bright Walter mariner 595982 595982 Bright, Walter, of Cley juxta Mare, Norf, mariner 0
3860514 1977009 1977009 defendant Collys Thomas   595982 595982 Collys, Thomas, of Cley juxta Mare, Norf, freemason 1
3905874 1992248 1992248 defendant Michelson Andrew mariner 595982 595982 Michelson, Andrew, of Cley juxta Mare, Norf, mariner 0
3970566 2014301 2014301 defendant Lyttell Robert yeoman 595982 595982 Lyttell, Robert, of Cley juxta Mare, Norf, yeoman 1
3985863 2019708 2019708 defendant Bourne James merchant 595982 595982 Bourne, James, of Cley juxta Mare, Norf, merchant 0
3985912 2019726 2019726 defendant Borne James gent 595982 595982 Borne, James, of Cley juxta Mare, Norf, gent 0
4002251 2025588 2025588 defendant Lytell Robert merchant 595982 595982 Lytell, Robert, of Cley juxta Mare, Norf, merchant 0
4002256 2025589 2025589 defendant Lytell Robert merchant 595982 595982 Lytell, Robert, of Cley juxta Mare, Norf, merchant 0
4018663 2031408 2031408 defendant Lyttell James merchant 595982 595982 Lyttell, James, of Cley juxta Mare, Norf, merchant 2
4036206 2037632 2037632 plaintiff Howarde Thomas   595982 595982 Howarde, Thomas, of Cley juxta Mare, Norf, ship master 0
4050385 2042568 2042568 defendant Rooper Robert gent 595982 595982 Rooper, Robert, of Cley juxta Mare, Norf, gent 0
4079527 2052976 2052976 plaintiff Turcock Robert (legal representative) 595982 595982 Turcock, Robert, of Cley juxta Mare, Norf, merchant, administratrix of 0
4079539 2052979 2052979 defendant Mychelson Andrew yeoman 595982 595982 Mychelson, Andrew, of Cley juxta Mare, Norf, yeoman 0
4079541 2052980 2052980 defendant Mychelson Andrew yeoman 595982 595982 Mychelson, Andrew, of Cley juxta Mare, Norf, yeoman 0
5086522 2382450 2382450 defendant Goodknap Simon husbandman 595982 595982 Goodknap, Simon, of Cley juxta Mare, Norf, husbandman 0
5086528 2382451 2382451 defendant Conyngton or Covyngton alias Howes William husbandman 595982 595982 Conyngton or Covyngton alias Howes, William, of Cley juxta Mare, Norf, husbandman 0
5122514 2393014 2393014 defendant Ferise John shipman 595982 595982 Ferise, John, of Cley juxta Mare, Norf, shipman 0
5227848 2423760 2423760 defendant Broun William merchant 595982 595982 Broun, William, of Cley juxta Mare, Norf, merchant 0
5509914 2507941 2507941 defendant Broke Thomas   595982 595982 Broke, Thomas, of Cley juxta Mare, Norf, holy water clerk 1
5509922 2507943 2507943 defendant Broke Thomas   595982 595982 Broke, Thomas, of Cley juxta Mare, Norf, holy water clerk 3
5517962 2510462 2510462 defendant Pycto Robert (legal representative) 595982 595982 Pycto, Robert, of Cley juxta Mare, Norf, husbandman, executors of 0
5518917 2510752 2510752 defendant Pallyng Robert merchant 595982 595982 Pallyng, Robert, of Cley juxta Mare, Norf, merchant 0
5526931 2512988 2512988 defendant Elsey John mariner 595982 595982 Elsey, John, of Cley juxta Mare, Norf, mariner 0
5526933 2512989 2512989 defendant Elsey John mariner 595982 595982 Elsey, John, of Cley juxta Mare, Norf, mariner 0
5532722 2514785 2514785 defendant Gurney Walter gent 595982 595982 Gurney, Walter, of Cley juxta Mare, Norf, gent 1
5541850 2517565 2517565 defendant Gurnay Walter esq 595982 595982 Gurnay, Walter, of Cley juxta Mare, Norf, esq 0
5542515 2517782 2517782 defendant Gurney Walter gent 595982 595982 Gurney, Walter, of Cley juxta Mare, Norf, gent 0
5595290 2533474 2533474 defendant Herryson Thomas yeoman 595982 595982 Herryson, Thomas, of Cley juxta Mare, Norf, yeoman 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);