names

53 rows where place_id = 596643

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3625619 1875546 1875546 defendant Adcok William clothmaker 596643 596643 Adcok, William, of Stapylherst, clothmaker 1
3638194 1906763 1906763 defendant Kyng James laborer 596643 596643 Kyng, James, of Stapylherst, laborer 0
3654811 1911764 1911764 defendant Wygewod John husbandman 596643 596643 Wygewod, John, of Stapylherst, husbandman 2
3656942 1912429 1912429 defendant Colyer Henry weaver 596643 596643 Colyer, Henry, of Stapylherst, weaver 0
3660354 1913500 1913500 defendant Colyer William weaver 596643 596643 Colyer, William, of Stapylherst, weaver 0
3672825 1917512 1917512 defendant Hayes Thomas weaver 596643 596643 Hayes, Thomas, of Stapylherst, weaver 0
3717053 1931619 1931619 defendant Styder Richard yeoman 596643 596643 Styder, Richard, of Stapylherst, yeoman 0
3758406 1944623 1944623 defendant Colyer William weaver 596643 596643 Colyer, William, of Stapylherst, weaver 0
3759515 1944968 1944968 defendant Alen John baker 596643 596643 Alen, John, of Stapylherst, baker 3
3769509 1948126 1948126 plaintiff Roberd Thomas   596643 596643 Roberd, Thomas, of Stapylherst 0
3769512 1948126 1948126 defendant Porter John glover 596643 596643 Porter, John, of Stapylherst, glover 2
3784565 1952960 1952960 defendant Kyng John laborer 596643 596643 Kyng, John, of Stapylherst, laborer 1
3784704 1953004 1953004 defendant Kyng John laborer 596643 596643 Kyng, John, of Stapylherst, laborer 1
3785826 1953354 1953354 defendant Whyte Richard laborer 596643 596643 Whyte, Richard, of Stapylherst, laborer 1
3789253 1954455 1954455 defendant Cobbe Thomas carpenter 596643 596643 Cobbe, Thomas, of Stapylherst, carpenter 4
3792210 1955417 1955417 defendant Bryslond James tanner 596643 596643 Bryslond, James, of Stapylherst, tanner 1
3802575 1958700 1958700 defendant Pavyer Walter scrivener 596643 596643 Pavyer, Walter, of Stapylherst, scrivener 2
3822928 1965076 1965076 defendant A Wodde John laborer 596643 596643 A Wodde, John, of Stapylherst, laborer 3
3824119 1965416 1965416 defendant Hopper Alexander mercer 596643 596643 Hopper, Alexander, of Stapylherst, mercer 0
4608811 2233859 2233859 defendant atte Rode John butcher 596643 596643 atte Rode, John, of Stapylherst, butcher 0
4619475 2237083 2237083 defendant Larke John, sen   596643 596643 Larke, John, sen, of Stapylherst 0
4641580 2243639 2243639 defendant Herman Robert   596643 596643 Herman, Robert, of Stapylherst 0
4666758 2255333 2255333 defendant Larke John laborer 596643 596643 Larke, John, of Stapylherst, laborer 0
4727750 2273923 2273923 defendant Larke John laborer 596643 596643 Larke, John, of Stapylherst, laborer 1
4727752 2273923 2273923 defendant Sprot John (legal representative) 596643 596643 Sprot, John, of Stapylherst, administrator of 3
4727753 2273923 2273923 defendant Hosiere Thomas tailor 596643 596643 Hosiere, Thomas, of Stapylherst, tailor 4
4733852 2275768 2275768 defendant Haytherst John husbandman 596643 596643 Haytherst, John, of Stapylherst, husbandman 0
4746578 2279490 2279490 defendant Herynden Stephen husbandman 596643 596643 Herynden, Stephen, of Stapylherst, husbandman 0
4778224 2289173 2289173 defendant Ropere Thomas laborer 596643 596643 Ropere, Thomas, of Stapylherst, laborer 0
4789262 2292701 2292701 defendant Ropere Thomas laborer 596643 596643 Ropere, Thomas, of Stapylherst, laborer 0
4872971 2318504 2318504 defendant Cryps John tailor 596643 596643 Cryps, John, of Stapylherst, tailor 0
4897441 2325860 2325860 defendant Knok John repyer or fishmonger 596643 596643 Knok, John, of Stapylherst, repyer or fishmonger 1
4952702 2342765 2342765 defendant Jordan John   596643 596643 Jordan, John, of Stapylherst, "clovyer" or clothier 2
4987622 2353260 2353260 defendant Lodyngden Osbert husbandman 596643 596643 Lodyngden, Osbert, of Stapylherst, husbandman 0
4987623 2353260 2353260 defendant Lodynden Thomas laborer 596643 596643 Lodynden, Thomas, of Stapylherst, laborer 1
5031815 2366176 2366176 defendant Herssherd James husbandman 596643 596643 Herssherd, James, of Stapylherst, husbandman 0
5033569 2366703 2366703 defendant Bratell John laborer 596643 596643 Bratell, John, of Stapylherst, laborer 0
5048447 2371172 2371172 defendant More William wheeler 596643 596643 More, William, of Stapylherst, wheeler 1
5063107 2375502 2375502 defendant Clampe Peter husbandman 596643 596643 Clampe, Peter, of Stapylherst, husbandman 0
5216938 2420693 2420693 defendant Dey John fuller 596643 596643 Dey, John, of Stapylherst, fuller 2
5317034 2450170 2450170 defendant Grene Richard cordwainer 596643 596643 Grene, Richard, of Stapylherst, cordwainer 0
5348044 2459528 2459528 defendant Wanden Richard fuller 596643 596643 Wanden, Richard, of Stapylherst, fuller 1
5354946 2461618 2461618 defendant Hamond Richard clothmaker 596643 596643 Hamond, Richard, of Stapylherst, clothmaker 0
5513003 2508918 2508918 defendant Southland Robert yeoman 596643 596643 Southland, Robert, of Stapylherst, yeoman 1
5551663 2520526 2520526 defendant Hershet John yeoman 596643 596643 Hershet, John, of Stapylherst, yeoman 1
5568161 2525235 2525235 defendant Ferrar Richard yeoman 596643 596643 Ferrar, Richard, of Stapylherst, yeoman 1
5588546 2531423 2531423 defendant Skorme John husbandman 596643 596643 Skorme, John, of Stapylherst, husbandman 0
5588547 2531423 2531423 defendant Cobbe John husbandman 596643 596643 Cobbe, John, of Stapylherst, husbandman 1
5588548 2531423 2531423 defendant Hopper Richard husbandman 596643 596643 Hopper, Richard, of Stapylherst, husbandman 2
5589461 2531704 2531704 defendant Feraff Stephen yeoman 596643 596643 Feraff, Stephen, of Stapylherst, yeoman 5
5602761 2535742 2535742 defendant Lynford John summoner 596643 596643 Lynford, John, of Stapylherst, summoner 4
5603658 2536011 2536011 defendant Goldham John husbandman 596643 596643 Goldham, John, of Stapylherst, husbandman 2
5604506 2536271 2536271 defendant Ferar Stephen yeoman 596643 596643 Ferar, Stephen, of Stapylherst, 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);