names

33 rows where place_id = 596631

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3625581 1875534 1875534 defendant Levendale John yeoman 596631 596631 Levendale, John, of Leuesham, Kent, yeoman 1
3625659 1875561 1875561 defendant Graveley Edward gent 596631 596631 Graveley, Edward, of Leuesham, Kent, gent 1
3705393 1927972 1927972 defendant Page Richard clothman 596631 596631 Page, Richard, of Leuesham, kent, clothman 2
4737608 2276872 2276872 defendant Wylteshire William carpenter 596631 596631 Wylteshire, William, of Leuesham, Kent, carpenter 2
4942705 2339690 2339690 defendant Halle Thomas husbandman 596631 596631 Halle, Thomas, of Leuesham, Kent, husbandman 1
5091707 2383965 2383965 defendant Segard Nicholas husbandman 596631 596631 Segard, Nicholas, of Leuesham, Kent, husbandman 1
5091710 2383966 2383966 defendant Segard Nicholas husbandman 596631 596631 Segard, Nicholas, of Leuesham, Kent, husbandman 1
5110136 2389376 2389376 defendant Segar Nicholas husbandman 596631 596631 Segar, Nicholas, of Leuesham, Kent, husbandman 1
5110362 2389434 2389434 defendant Cumbe Richard husbandman 596631 596631 Cumbe, Richard, of Leuesham, Kent, husbandman 3
5110367 2389435 2389435 defendant Style Andrew husbandman 596631 596631 Style, Andrew, of Leuesham, Kent, husbandman 2
5161265 2404388 2404388 defendant Rykeman Peter yeoman 596631 596631 Rykeman, Peter, of Leuesham, Kent, clerk. Segarde, Nicholas, of Leuesham, yeoman 3
5175714 2408579 2408579 defendant Rykeman Peter yeoman 596631 596631 Rykeman, Peter, of Leuesham, Kent, clerk. Segarde, Nicholas, of Leuesham, yeoman 3
5175719 2408580 2408580 defendant Rykeman Peter yeoman 596631 596631 Rykeman, Peter, of Leuesham, Kent, clerk. Segarde, Nicholas, of Leuesham, yeoman 3
5185252 2411434 2411434 defendant Gossyp John husbandman 596631 596631 Gossyp, John, of Leuesham, Kent, husbandman 0
5185253 2411434 2411434 defendant Richeman Peter clerk 596631 596631 Richeman, Peter, of Leuesham, Kent, clerk 1
5186176 2411708 2411708 defendant Gossyp John smith 596631 596631 Gossyp, John, of Leuesham, Kent, smith 0
5197175 2414912 2414912 defendant Rykeman Peter clerk 596631 596631 Rykeman, Peter, of Leuesham, Kent, clerk 3
5204729 2417128 2417128 defendant Gossyp John husbandman 596631 596631 Gossyp, John, of Leuesham, Kent, husbandman 0
5204730 2417128 2417128 defendant Richeman Peter clerk 596631 596631 Richeman, Peter, of Leuesham, Kent, clerk 1
5217576 2420881 2420881 defendant Gossyp or Gessyp John smith 596631 596631 Gossyp or Gessyp, John, of Leuesham, Kent, smith 0
5227850 2423760 2423760 defendant Assheley William yeoman 596631 596631 Assheley, William, of Leuesham, Kent, yeoman 2
5267762 2435678 2435678 defendant Walter William tailor 596631 596631 Walter, William, of Leuesham, Kent, tailor 0
5267768 2435679 2435679 defendant Walter William tailor 596631 596631 Walter, William, of Leuesham, Kent, tailor 0
5355157 2461684 2461684 defendant Graveley Edmund esq 596631 596631 Graveley, Edmund, of Leuesham Lemman, Kent, esq 0
5410304 2478033 2478033 defendant Combe Robert husbandman 596631 596631 (Combe, Robert, of Leuesham, Kent, husbandman 5
5410305 2478033 2478033 defendant Combe Isabel   596631 596631 Combe, Isabel, of Leuesham, Kent, widow, formerly wife of Richard 6
5424137 2482180 2482180 defendant Combe Robert husbandman 596631 596631 (Combe, Robert, of Leuesham, Kent, husbandman 5
5463093 2493875 2493875 plaintiff Rukke Henry yeoman 596631 596631 Rukke, Henry, of Leuesham, Kent, yeoman 0
5472719 2496808 2496808 defendant Hochonson Richard brewer 596631 596631 Hochonson, Richard, of Leuesham, Kent, brewer 0
5472721 2496809 2496809 defendant Hochonson Richard brewer 596631 596631 Hochonson, Richard, of Leuesham, Kent, brewer 0
5472730 2496811 2496811 defendant Shepperd John   596631 596631 Shepperd, John, of Leuesham, Kent 0
5474638 2497396 2497396 plaintiff Rukke Henry   596631 596631 Rukke, Henry, of Leuesham, Kent 0
5633508 2554475 2554475 defendant Samford Joan widow of Thomas Samford 596631 596631 Samford, Joan, of Leuesham, Kent, widow of Thomas Samford 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);