names

38 rows where place_id = 602593

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3650847 1910630 1910630 defendant Cogyll William miller 602593 602593 Cogyll, William, of Hellowe, miller 0
3761307 1945540 1945540 defendant Wrey Thomas clerk 602593 602593 Wrey, Thomas, of Hellowe, clerk 0
4421143 2171505 2171505 defendant Graytoft Walter de   602593 602593 Graytoft, Walter de, of Hellowe, parson 1
4432199 2174854 2174854 defendant Braytoft Walter de   602593 602593 Braytoft, Walter de, of Hellowe, parson 1
4526124 2208464 2208464 defendant Lymme Alan   602593 602593 Lymme, Alan, of Hellowe, parson 0
4753421 2281445 2281445 defendant Jonson Thomas husbandman 602593 602593 Jonson, Thomas, of Hellowe, husbandman 0
4785856 2291608 2291608 defendant Kyrke William husbandman 602593 602593 Kyrke, William, of Hellowe, husbandman 1
5219083 2421310 2421310 defendant Colvyle Simon miller 602593 602593 Colvyle, Simon, of Hellowe, miller 1
5238726 2426921 2426921 defendant Colvyle Simon miller 602593 602593 Colvyle, Simon, of Hellowe, miller 1
5285453 2440766 2440766 defendant Dey Robert husbandman 602593 602593 Dey, Robert, of Hellowe, husbandman 1
5289241 2441856 2441856 defendant Canthorn or Cauthorn Thomas yeoman 602593 602593 Canthorn or Cauthorn, Thomas, of Hellowe, yeoman 4
5417086 2480021 2480021 defendant Okys John clerk 602593 602593 Okys, John, of Hellowe, clerk 1
5417087 2480021 2480021 defendant Chylde Thomas yeoman 602593 602593 Chylde, Thomas, of Hellowe, yeoman 2
5434195 2485179 2485179 defendant Okys John clerk 602593 602593 Okys, John, of Hellowe, clerk 0
5434196 2485179 2485179 defendant Childe Thomas yeoman 602593 602593 Childe, Thomas, of Hellowe, yeoman 1
5434197 2485179 2485179 defendant Dykson John laborer 602593 602593 Dykson, John, of Hellowe, laborer 2
5434198 2485179 2485179 defendant Carter Robert laborer 602593 602593 Carter, Robert, of Hellowe, laborer 3
5434199 2485179 2485179 defendant Carter Leonard laborer 602593 602593 Carter, Leonard, of Hellowe, laborer 4
5434204 2485179 2485179 defendant Spence Richard yeoman 602593 602593 Spence, Richard, of Hellowe, yeoman 9
5434205 2485179 2485179 defendant Hamerton Peter laborer 602593 602593 Hamerton, Peter, of Hellowe, laborer 10
5434206 2485179 2485179 defendant Day Robert laborer 602593 602593 Day, Robert, of Hellowe, laborer 11
5434207 2485179 2485179 defendant Okys John laborer 602593 602593 Okys, John, of Hellowe, laborer 12
5434217 2485180 2485180 defendant Okys John clerk 602593 602593 Okys, John, of Hellowe, clerk 1
5434218 2485180 2485180 defendant Chylde Thomas yeoman 602593 602593 Chylde, Thomas, of Hellowe, yeoman 2
5434239 2485181 2485181 defendant Hamerton Peter laborer 602593 602593 Hamerton, Peter, of Hellowe, laborer 0
5434240 2485181 2485181 defendant Day Robert laborer 602593 602593 Day, Robert, of Hellowe, laborer 1
5434241 2485181 2485181 defendant Okys John laborer 602593 602593 Okys, John, of Hellowe, laborer 2
5434250 2485181 2485181 defendant Okys John clerk 602593 602593 Okys, John, of Hellowe, clerk 11
5434251 2485181 2485181 defendant Childe Thomas yeoman 602593 602593 Childe,Thomas, of Hellowe, yeoman 12
5434252 2485181 2485181 defendant Dykson John laborer 602593 602593 Dykson, John, of Hellowe, laborer 13
5434254 2485181 2485181 defendant Carter Leonard laborer 602593 602593 Carter, Leonard, of Hellowe, laborer 15
5449654 2489788 2489788 defendant Okys John clerk 602593 602593 together with Okys, John, of Hellowe, clerk 4
5449656 2489788 2489788 defendant Hamerton Peter laborer 602593 602593 Hamerton, Peter, of Hellowe, laborer 6
5449657 2489788 2489788 defendant Day Robert laborer 602593 602593 Day, Robert, of Hellowe, laborer 7
5449658 2489788 2489788 defendant Carter Robert, junior laborer 602593 602593 Carter, Robert, junior, of Hellowe, laborer 8
5449659 2489788 2489788 defendant Carter Leonard laborer 602593 602593 Carter, Leonard, of Hellowe, laborer 9
5488613 2501478 2501478 defendant Hastynges Richard   602593 602593 Hastynges, Richard, of Hellowe, knight 0
5488615 2501479 2501479 defendant Hastynges Richard   602593 602593 Hastynges, Richard, of Hellowe, knight 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);