names

37 rows where place_id = 627534

✎ 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
3776757 1950476 1950476 defendant Gawge John yeoman 627534 627534 Gawge, John, of Gosfeld, yeoman 0
3780684 1951689 1951689 defendant Gawge John yeoman 627534 627534 Gawge, John, of Gosfeld, yeoman 0
3791172 1955070 1955070 defendant Gawge John yeoman 627534 627534 Gawge, John, of Gosfeld, yeoman 0
3806854 1960050 1960050 defendant Gawge John yeoman 627534 627534 Gawge, John, of Gosfeld, yeoman 1
3848776 1973202 1973202 defendant Brett William carpenter 627534 627534 Brett, William, of Gosfeld, carpenter 1
4101890 2060986 2060986 defendant Waspe John yeoman 627534 627534 Waspe, John, of Gosfeld, yeoman 1
4545950 2214669 2214669 defendant Aspelun Thomas   627534 627534 Aspelun, Thomas, of Gosfeld 1
4686481 2261377 2261377 defendant Herde Lawrence laborer 627534 627534 Herde, Lawrence, of Gosfeld, laborer 0
4692823 2263264 2263264 defendant Clerk John husbandman 627534 627534 Clerk, John, of Gosfeld, husbandman 5
4718252 2271045 2271045 defendant Strete William husbandman 627534 627534 Strete, William, of Gosfeld, husbandman 0
4718253 2271045 2271045 defendant Chilterne Maud   627534 627534 Chilterne, Maud, of Gosfeld, widow, formerly wife of Richard Chilterne 1
4795714 2294810 2294810 defendant Tyter John, junior laborer 627534 627534 Tyter, John, junior, of Gosfeld, laborer 0
4795716 2294811 2294811 defendant Tyler Thomas, junior laborer 627534 627534 Tyler, Thomas, junior, of Gosfeld, laborer 0
4849391 2311287 2311287 defendant William William yeoman 627534 627534 William, William, of Gosfeld, yeoman 1
4898403 2326156 2326156 defendant Thedam Thomas yeoman 627534 627534 Thedam, Thomas, of Gosfeld, yeoman 2
4930979 2336087 2336087 defendant Willyam William yeoman 627534 627534 Willyam, William, of Gosfeld, yeoman 0
5019754 2362656 2362656 defendant Mors John butcher 627534 627534 Mors, John, of Gosfeld, butcher 4
5019760 2362657 2362657 defendant Mors John butcher 627534 627534 Mors, John, of Gosfeld, butcher 4
5272696 2437092 2437092 defendant Morgan Thomas yeoman 627534 627534 Morgan, Thomas, of Gosfeld, yeoman 0
5272697 2437092 2437092 defendant Longe John husbandman 627534 627534 Longe, John, of Gosfeld, husbandman 1
5272698 2437092 2437092 defendant Coo Robert husbandman 627534 627534 Coo, Robert, of Gosfeld, husbandman 2
5295286 2443616 2443616 defendant Morgan Thomas yeoman 627534 627534 Morgan, Thomas, of Gosfeld, yeoman 0
5295287 2443616 2443616 defendant Longe John husbandman 627534 627534 Longe, John, of Gosfeld, husbandman 1
5295288 2443616 2443616 defendant Coo Robert husbandman 627534 627534 Coo, Robert, of Gosfeld, husbandman 2
5295290 2443617 2443617 defendant Morgan Thomas yeoman 627534 627534 Morgan, Thomas, of Gosfeld, yeoman 0
5295291 2443617 2443617 defendant Longe John husbandman 627534 627534 Longe, John, of Gosfeld, husbandman 1
5295292 2443617 2443617 defendant Coo Robert husbandman 627534 627534 Coo, Robert, of Gosfeld, husbandman 2
5335788 2455769 2455769 plaintiff Grene John (legal representative) 627534 627534 Grene, John, of Gosfeld, esq, executors of 0
5335793 2455769 2455769 defendant Coo Robert husbandman 627534 627534 Coo, Robert, of Gosfeld, husbandman 2
5335794 2455770 2455770 plaintiff Grene John (legal representative) 627534 627534 Grene, John, of Gosfeld, esq, executors of 0
5340955 2457368 2457368 defendant Bygner John husbandman 627534 627534 Bygner, John, of Gosfeld, husbandman 1
5399418 2474908 2474908 defendant Kene Richard cooper 627534 627534 Kene, Richard, of Gosfeld, cooper 0
5473673 2497093 2497093 plaintiff Coggeshale John   627534 627534 Coggeshale, John, of Gosfeld 1
5473674 2497093 2497093 defendant Akern John husbandman 627534 627534 Akern, John, of Gosfeld, husbandman 0
5473675 2497093 2497093 defendant Bykenere William husbandman 627534 627534 Bykenere, William, of Gosfeld, husbandman 1
5504227 2506235 2506235 defendant Brybras Thomas husbandman 627534 627534 Brybras, Thomas, of Gosfeld, husbandman 1
5537439 2516204 2516204 defendant Bykmer John husbandman 627534 627534 Bykmer, John, of Gosfeld, husbandman 3

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);