names

36 rows where place_id = 762795

✎ 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
4491123 2197912 2197912 defendant Litcester Isabel   762795 762795 Litcester, Isabel, of Hornsebek 5
4507717 2202873 2202873 defendant Skelton John   762795 762795 Skelton, John, of Hornsebek 2
4530901 2209957 2209957 defendant Cherk John   762795 762795 Cherk, John, of Hornsebek 0
4538415 2212299 2212299 defendant Kirke John   762795 762795 Kirke, John, of Hornsebek 3
4540956 2213078 2213078 defendant Skelton John de   762795 762795 Skelton, John de, of Hornsebek 0
4601874 2231810 2231810 defendant Butter Robert   762795 762795 Butter, Robert, of Hornsebek 0
4601877 2231811 2231811 defendant Butter Robert   762795 762795 Butter, Robert, of Hornsebek 0
4614891 2235664 2235664 defendant Titelot William   762795 762795 Titelot, William, of Hornsebek 0
4658169 2248432 2248432 defendant Brancyng or Brantyng Isabel widow 762795 762795 Brancyng or Brantyng, Isabel, of Hornsebek, widow 1
4675625 2257986 2257986 defendant Mandsone Robert shipman 762795 762795 Mandsone, Robert, of Hornsebek, shipman 6
4686587 2261414 2261414 defendant Foster William shipman 762795 762795 Foster, William, of Hornsebek, shipman 0
4735480 2276243 2276243 defendant Muk alias Huk Thomas   762795 762795 Muk alias Huk, Thomas, of Hornsebek 0
4777987 2289100 2289100 defendant Raa Thomas shipman 762795 762795 Raa, Thomas, of Hornsebek, shipman 1
4777988 2289100 2289100 defendant Kirk Walter shipman 762795 762795 Kirk, Walter, of Hornsebek, shipman 2
4790894 2293242 2293242 defendant Grisacre Richard shipman 762795 762795 Grisacre, Richard, of Hornsebek, shipman 1
4790895 2293242 2293242 defendant Courtson John shipman 762795 762795 Courtson, John, of Hornsebek, shipman 2
4790896 2293242 2293242 defendant Cotyngham John shipman 762795 762795 Cotyngham, John, of Hornsebek, shipman 3
4815874 2301066 2301066 defendant Mody William butcher 762795 762795 Mody, William, of Hornsebek, butcher 0
4815875 2301066 2301066 defendant Gryssacre Richard shipman 762795 762795 Gryssacre, Richard, of Hornsebek, shipman 1
4815877 2301066 2301066 defendant Campyon William shipman 762795 762795 Campyon, William, of Hornsebek, shipman 3
4819874 2302290 2302290 defendant Mody William butcher 762795 762795 Mody, William, of Hornsebek, butcher 0
4820309 2302422 2302422 defendant Storoure William yeoman 762795 762795 Storoure, William, of Hornsebek, yeoman 0
4847712 2310778 2310778 defendant Ravensey William tailor 762795 762795 Ravensey, William, of Hornsebek, tailor 1
4883932 2321883 2321883 defendant Mede William butcher 762795 762795 Mede, William, of Hornsebek, butcher 0
4898842 2326281 2326281 defendant Lelley Robert mariner 762795 762795 Lelley, Robert, of Hornsebek, mariner 1
4898922 2326305 2326305 defendant Maldson Robert mariner 762795 762795 Maldson, Robert, of Hornsebek, mariner 0
4898923 2326305 2326305 defendant Hayburn Paton mariner 762795 762795 Hayburn, Paton, of Hornsebek, mariner 1
4898924 2326305 2326305 defendant Pynch- John mariner 762795 762795 Pynch-, John, of Hornsebek, mariner 2
4923628 2333825 2333825 defendant Curtson John shipman 762795 762795 Curtson, John, of Hornsebek, shipman 0
5001224 2357240 2357240 defendant Gell Alan panyer man 762795 762795 Gell, Alan, of Hornsebek, panyer man 0
5033231 2366601 2366601 plaintiff Skelton John mariner 762795 762795 Skelton, John, of Hornsebek, mariner 0
5137533 2397491 2397491 defendant Meteham William yeoman 762795 762795 Meteham, William, of Hornsebek, yeoman 1
5158187 2403515 2403515 defendant Meteham William yeoman 762795 762795 Meteham, William, of Hornsebek, yeoman 1
5173860 2408052 2408052 defendant Metham William yeoman 762795 762795 Metham, William, of Hornsebek, yeoman 1
5281395 2439629 2439629 defendant Escryk John yeoman 762795 762795 Escryk, John, of Hornsebek, yeoman 2
5368013 2465620 2465620 defendant Wederby Matilda widow 762795 762795 Wederby, Matilda, of Hornsebek, widow 1

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