names

33 rows where place_id = 602668

✎ 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
3651216 1910749 1910749 defendant Carver John clothmaker 602668 602668 Carver, John, of Lanham, clothmaker 0
3703441 1927350 1927350 defendant Breten Roger brewer 602668 602668 Breten, Roger, of Lanham, brewer 0
3738835 1938352 1938352 defendant Barker Anne widow 602668 602668 Barker, Anne, of Lanham, widow 0
3760330 1945235 1945235 plaintiff Crystoft Robert   602668 602668 Crystoft, Robert, of Lanham 0
3779389 1951275 1951275 defendant Brette John weaver 602668 602668 Brette, John, of Lanham, weaver 2
3815108 1962645 1962645 plaintiff Grome Robert   602668 602668 Grome, Robert, of Lanham 0
3824031 1965393 1965393 defendant Newton John merchant 602668 602668 Newton, John, of Lanham, merchant 0
3824032 1965393 1965393 defendant Breton John carrier 602668 602668 Breton, John, of Lanham, carrier 1
3842251 1971121 1971121 plaintiff Brett William   602668 602668 Brett, William, of Lanham 0
3845963 1972293 1972293 defendant Jolly William husbandman 602668 602668 Jolly, William, of Lanham, husbandman 1
3879661 1983453 1983453 defendant Joly William yeoman 602668 602668 Joly, William, of Lanham, yeoman 0
3880922 1983891 1983891 defendant Skotte Thomas clothier 602668 602668 Skotte, Thomas, of Lanham, clothier 1
3880923 1983891 1983891 defendant Johnson John laborer 602668 602668 Johnson, John, of Lanham, laborer 2
3880924 1983891 1983891 defendant Swanton James   602668 602668 Swanton, James, of Lanham, wheelwright 3
3899862 1990166 1990166 plaintiff Boyth alias Booth William husbandman 602668 602668 Boyth alias Booth, William, of Lanham, husbandman 0
3909911 1993622 1993622 defendant Greane John clothier 602668 602668 Greane, John, of Lanham, clothier 4
3916587 1995924 1995924 defendant Broun Robert yeoman 602668 602668 Broun, Robert, of Lanham, yeoman 1
3921191 1997440 1997440 defendant Andrewe William smith 602668 602668 Andrewe, William, of Lanham, smith 0
3921193 1997440 1997440 defendant Thrumble George carrier 602668 602668 Thrumble, George, of Lanham, carrier 2
3924843 1998627 1998627 defendant Conyars Henry tailor 602668 602668 Conyars, Henry, of Lanham, tailor 3
3928786 1999963 1999963 defendant Brankyn Gerrard   602668 602668 Brankyn, Gerrard, of Lanham, show maker 1
3999339 2024524 2024524 defendant Wylkyns Charles yeoman 602668 602668 Wylkyns, Charles, of Lanham, yeoman 0
3999342 2024525 2024525 defendant Wylkyns Charles yeoman 602668 602668 Wylkyns, Charles, of Lanham, yeoman 0
4029107 2035055 2035055 defendant Gryxe or Eryxe John, junior husbandman 602668 602668 Gryxe or Eryxe, John, junior, of Lanham, husbandman 1
4036480 2037733 2037733 defendant Sexten Robert carter 602668 602668 Sexten, Robert, of Lanham, carter 1
4198681 2095095 2095095 defendant Whatlocke John clothier 602668 602668 Whatlocke, John, of Lanham, clothier 0
4206909 2097960 2097960 defendant Rolfe Thomas   602668 602668 Rolfe, Thomas, of Lanham, pale maker 0
4213169 2100130 2100130 defendant Roper Thomas gent 602668 602668 Roper, Thomas, of Lanham, gent 1
4276438 2121702 2121702 defendant Segar Margery widow 602668 602668 Segar, Margery, of Lanham, widow 2
4289036 2126136 2126136 defendant Sprynge William gent 602668 602668 Sprynge, William, of Lanham, gent 0
4351038 2147617 2147617 defendant Preston Thomas brickmaker 602668 602668 Preston, Thomas, of Lanham, brickmaker 0
4637938 2242632 2242632 defendant Wellyng Robert   602668 602668 Wellyng, Robert, of Lanham 4
5109692 2389261 2389261 defendant Elwynton Geoffrey clerk 602668 602668 Elwynton, Geoffrey, of Lanham, clerk 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);