names

34 rows where place_id = 603552

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3634577 1905618 1905618 defendant Dylcok William   603552 603552 Dylcok, William, of Iver, Bucks, parish clerk 0
3654907 1911793 1911793 defendant Abbray William gent 603552 603552 Abbray, William, of Iver, Bucks, gent 1
3657190 1912514 1912514 defendant Nicols William husbandman 603552 603552 Nicols, William, of Iver, Bucks, husbandman 2
3657197 1912515 1912515 defendant Nicols William husbandman 603552 603552 Nicols, William, of Iver, Bucks, husbandman 2
3664825 1914945 1914945 plaintiff Shawcrosse John (legal representative) 603552 603552 Shawcrosse, John, of Iver, Bucks, gent, executors of 0
3695998 1924988 1924988 defendant Hurleston Nicholas gent 603552 603552 Hurleston, Nicholas, of Iver, Bucks, gent 0
3709917 1929416 1929416 defendant Hurleston Nicholas gent 603552 603552 Hurleston, Nicholas, of Iver, Bucks, gent 0
4021271 2032332 2032332 defendant Britridge William yeoman 603552 603552 Britridge, William, of Iver, Bucks, yeoman 1
4021906 2032560 2032560 defendant Blount Richard (legal representative) 603552 603552 Blount, Richard, of Iver, Bucks, knight, executrix of 0
4022146 2032649 2032649 defendant Blount Richard (legal representative) 603552 603552 Blount, Richard, of Iver, Bucks, esq, executrix of 0
4193641 2093344 2093344 defendant Urlyn William yeoman 603552 603552 Urlyn, William, of Iver, Bucks, yeoman 0
4200396 2095694 2095694 defendant Kinge John yeoman 603552 603552 Kinge, John, of Iver, Bucks, yeoman 0
4214876 2100703 2100703 defendant Lewes Griffin butcher 603552 603552 Lewes, Griffin, of Iver, Bucks, butcher 1
4250281 2113074 2113074 defendant Lewes Griffin butcher 603552 603552 Lewes, Griffin, of Iver, Bucks, butcher 1
4269127 2119268 2119268 defendant Stone Thomas laborer 603552 603552 Stone, Thomas, of Iver, Bucks, laborer 0
4293504 2127739 2127739 defendant Garrawaye Paul gent 603552 603552 Garrawaye, Paul, of Iver, Bucks, gent 0
4327027 2139369 2139369 defendant Clarke John fisherman 603552 603552 Clarke, John, of Iver, Bucks, fisherman 2
4337207 2142742 2142742 defendant Barringer James glover 603552 603552 Barringer, James, of Iver, Bucks, glover 0
4392085 2161981 2161981 defendant Carpenter Thomas blacksmith 603552 603552 Carpenter, Thomas, of Iver, Bucks, blacksmith 0
4769955 2286576 2286576 defendant Underwode Richard chapman 603552 603552 Underwode, Richard, of Iver, Bucks, chapman 0
5121893 2392839 2392839 defendant Dene John drover 603552 603552 Dene, John, of Iver, Bucks, drover 1
5212231 2419316 2419316 defendant Forde William gent 603552 603552 Forde, William, of Iver, Bucks, gent 0
5227721 2423725 2423725 defendant atte Dene William husbandman 603552 603552 atte Dene, William, of Iver, Bucks, husbandman 0
5227726 2423726 2423726 defendant atte William husbandman 603552 603552 atte, William, of Iver, Bucks, husbandman 0
5265242 2434887 2434887 defendant Forthe William gent 603552 603552 Forthe, William, of Iver, Bucks, gent 0
5293012 2442943 2442943 defendant Smyth Lawrence yeoman 603552 603552 Smyth, Lawrence, of Iver, Bucks, yeoman 2
5466774 2495011 2495011 defendant Park William husbandman 603552 603552 Park, William, of Iver, Bucks, husbandman 3
5504497 2506326 2506326 defendant Herbert William esq 603552 603552 Herbert, William, of Iver, Bucks, esq 0
5517628 2510355 2510355 defendant Aubrey William gent 603552 603552 (Aubrey, William, of Iver, Bucks, gent 1
5517634 2510356 2510356 defendant Aubrey William gent 603552 603552 (Aubrey, William, of Iver, Bucks, gent 1
5517640 2510357 2510357 defendant Aubrey William gent 603552 603552 (Aubrey, William, of Iver, Bucks, gent 1
5517646 2510358 2510358 defendant Aubrey William gent 603552 603552 (Aubrey, William, of Iver, Bucks, gent 1
5517652 2510359 2510359 defendant Aubrey William gent 603552 603552 (Aubrey, William, of Iver, Bucks, gent 1
5517658 2510360 2510360 defendant Aubrey William gent 603552 603552 (Aubrey, William, of Iver, Bucks, gent 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);