names

20 rows where place_id = 590607

✎ 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
3601776 1868213 1868213 defendant Doget John yeoman 590607 590607 Doget, John, of Milton, Kent, yeoman 0
3802932 1958814 1958814 defendant Corsiar alias Corveser John, senior butcher 590607 590607 Corsiar alias Corveser, John, senior, of Milton, Kent, butcher 0
3915854 1995680 1995680 defendant Wilde William esq 590607 590607 Wilde, William, of Milton, Kent, esq 0
4334068 2141675 2141675 defendant Tucker George gent 590607 590607 Tucker, George, of Milton, Kent, gent 1
4698383 2264973 2264973 defendant Bokton William husbandman 590607 590607 Bokton, William, of Milton, Kent, husbandman 0
4766947 2285649 2285649 defendant Quyn Alice widow 590607 590607 Quyn, Alice, of Milton, Kent, widow 6
4782500 2290535 2290535 defendant Teryngton William clerk 590607 590607 Teryngton, William, of Milton, Kent, clerk 4
4782506 2290536 2290536 defendant Teryngton William clerk 590607 590607 Teryngton, William, of Milton, Kent, clerk 4
4900151 2326672 2326672 defendant Bartram Richard husbandman 590607 590607 Bartram, Richard, of Milton, Kent, husbandman 4
5124538 2393639 2393639 defendant Clyfford John esq 590607 590607 Clyfford, John, of Milton, Kent, esq 2
5127965 2394656 2394656 defendant Semenet William mariner 590607 590607 Semenet, William, of Milton, Kent, mariner 2
5153040 2402034 2402034 defendant Clyfford John esq 590607 590607 Clyfford, John, of Milton, Kent, esq 1
5221417 2421962 2421962 defendant Graveley Thomas tailor 590607 590607 Graveley, Thomas, of Milton, Kent, tailor 0
5221421 2421962 2421962 defendant Alee John miller 590607 590607 Alee, John, of Milton, Kent, miller 4
5270325 2436423 2436423 defendant Dyer Robert dyer 590607 590607 Dyer, Robert, of Milton, Kent, dyer 3
5284754 2440558 2440558 defendant Atsole Thomas   590607 590607 Atsole, Thomas, of Milton, Kent, holy water clerk 0
5297863 2444382 2444382 defendant Roteland William husbandman 590607 590607 Roteland, William, of Milton, Kent, husbandman 0
5299253 2444756 2444756 defendant Kyng Richard tanner 590607 590607 Kyng, Richard, of Milton, Kent, tanner 0
5521302 2511480 2511480 defendant Barnard William, junior salter 590607 590607 Barnard, William, junior, of Milton, Kent, merchant, apprentice to Edmond, Henry, of Byllyngysgate, London, salter 0
5568854 2525441 2525441 defendant Fynche Henry yeoman 590607 590607 Fynche, Henry, of Milton, Kent, 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);