names

34 rows where place_id = 592386

✎ 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
3607549 1870019 1870019 defendant Clerk John yeoman 592386 592386 Clerk, John, of Takeley, yeoman 0
3607550 1870019 1870019 defendant Payn John yeoman 592386 592386 Payn, John, of Takeley, yeoman 1
3621435 1874242 1874242 defendant Stok John yeoman 592386 592386 Stok, John, of Takeley, yeoman 2
3623993 1875036 1875036 defendant Waleys Richard husbandman 592386 592386 Waleys, Richard, of Takeley, husbandman 0
3642799 1908196 1908196 plaintiff Clerke John   592386 592386 Clerke, John, of Takeley 0
3647298 1909539 1909539 defendant Gyva John   592386 592386 Gyva, John, of Takeley, fan maker 0
3662906 1914312 1914312 plaintiff Newman Thomas   592386 592386 Newman, Thomas, of Takeley, pale maker 0
3728694 1935215 1935215 defendant Clerke John yeoman 592386 592386 Clerke, John, of Takeley, yeoman 0
3728695 1935215 1935215 defendant Clerke Nicholas yeoman 592386 592386 Clerke, Nicholas, of Takeley, yeoman 1
3728696 1935215 1935215 defendant Wyberd John yeoman 592386 592386 Wyberd, John, of Takeley, yeoman 2
3770432 1948431 1948431 defendant Coke John husbandman 592386 592386 Coke, John, of Takeley, husbandman 1
3771954 1948921 1948921 defendant Coke John husbandman 592386 592386 Coke, John, of Takeley, husbandman 0
3842616 1971218 1971218 defendant Hellam Ralph husbandman 592386 592386 Hellam, Ralph, of Takeley, husbandman 2
4114994 2065652 2065652 defendant Urley John husbandman 592386 592386 Urley, John, of Takeley, husbandman 1
4114995 2065652 2065652 defendant Grave Thomas husbandman 592386 592386 Grave, Thomas, of Takeley, husbandman 2
4114996 2065652 2065652 defendant Clarke Francis husbandman 592386 592386 Clarke, Francis, of Takeley, husbandman 3
4374594 2155973 2155973 defendant Godfrey John husbandman 592386 592386 Godfrey, John, of Takeley, husbandman 0
4374596 2155974 2155974 defendant Godfrey John husbandman 592386 592386 Godfrey, John, of Takeley, husbandman 0
4374598 2155975 2155975 defendant Laver John husbandman 592386 592386 Laver, John, of Takeley, husbandman 0
4374600 2155976 2155976 defendant Laver John husbandman 592386 592386 Laver, John, of Takeley, husbandman 0
4618890 2236901 2236901 defendant Bernard John   592386 592386 Bernard, John, of Takeley 0
5108605 2388951 2388951 defendant Clerk Richard turner 592386 592386 Clerk, Richard, of Takeley, turner 11
5108606 2388951 2388951 defendant Wodson John turner 592386 592386 Wodson, John, of Takeley, turner 12
5108607 2388951 2388951 defendant Wodson Robert husbandman 592386 592386 Wodson, Robert, of Takeley, husbandman 13
5229042 2424102 2424102 defendant Benbury William, junior gent 592386 592386 Benbury, William, junior, of Takeley, gent 0
5321474 2451514 2451514 defendant Gybbe John husbandman 592386 592386 Gybbe, John, of Takeley, husbandman 4
5331616 2454537 2454537 defendant Marchall John husbandman 592386 592386 Marchall, John, of Takeley, husbandman 0
5469300 2495747 2495747 defendant Courte William clerk 592386 592386 Courte, William, of Takeley, clerk 2
5492880 2502780 2502780 defendant Sumner Oliver clerk 592386 592386 Sumner, Oliver, of Takeley, clerk 0
5498330 2504461 2504461 defendant Canfeld Joan widow 592386 592386 Canfeld, Joan, of Takeley, widow 0
5498331 2504461 2504461 defendant Sanoll or Savoll Thomas laborer 592386 592386 Sanoll or Savoll, Thomas, of Takeley, laborer 1
5531723 2514459 2514459 defendant Clerk John yeoman 592386 592386 Clerk, John, of Takeley, yeoman 0
5588104 2531291 2531291 defendant Newers Edmund gent 592386 592386 Newers, Edmund, of Takeley, gent 0
5616183 2548854 2548854 defendant Hog Simon   592386 592386 Hog, Simon, of Takeley 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);