names

37 rows where place_id = 672373

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
4005373 2026702 2026702 defendant Kinge Thomas husbandman 672373 672373 Kinge, Thomas, of Syresham, husbandman 0
4041436 2039426 2039426 defendant Knyght John yeoman 672373 672373 Knyght, John, of Syresham, yeoman 1
4041439 2039427 2039427 defendant Knyght John yeoman 672373 672373 Knyght, John, of Syresham, yeoman 1
4157588 2080726 2080726 defendant Keelynge Richard yeoman 672373 672373 Keelynge, Richard, of Syresham, yeoman 2
4440957 2182092 2182092 defendant Holeweye Robert   672373 672373 Holeweye, Robert, of Syresham, formerly parson of the church 0
4515484 2205262 2205262 defendant Covele William   672373 672373 Covele, William, of Syresham 0
4558784 2218704 2218704 defendant Scot William   672373 672373 Scot, William, of Syresham 0
4625372 2238900 2238900 defendant Hert William   672373 672373 Hert, William, of Syresham 0
4651369 2246430 2246430 defendant Awebon John weaver 672373 672373 Awebon, John, of Syresham, weaver 0
4654568 2247308 2247308 defendant Richard Richard husbandman 672373 672373 Richard, Richard, of Syresham, husbandman 0
4655314 2247550 2247550 defendant Ricard Richard husbandman 672373 672373 Ricard, Richard, of Syresham, husbandman 0
4731181 2274953 2274953 plaintiff Mold William   672373 672373 Mold, William, of Syresham 0
4765302 2285132 2285132 defendant Turnour Richard gent 672373 672373 Turnour, Richard, of Syresham, gent 0
4818478 2301860 2301860 defendant Thorn John yeoman 672373 672373 Thorn, John, of Syresham, yeoman 0
4851860 2312016 2312016 defendant Ricardes Richard husbandman 672373 672373 Ricardes, Richard, of Syresham, husbandman 3
4865935 2316318 2316318 defendant Mold William butcher 672373 672373 Mold, William, of Syresham, butcher 1
4879900 2320626 2320626 defendant Rycardes Richard husbandman 672373 672373 Rycardes, Richard, of Syresham, husbandman 3
4892987 2324531 2324531 defendant Reve John collier 672373 672373 Reve, John, of Syresham, collier 0
4944956 2340412 2340412 defendant Gybon Stephen cordwainer 672373 672373 Gybon, Stephen, of Syresham, cordwainer 0
4944957 2340412 2340412 defendant Ricardes William laborer 672373 672373 Ricardes, William, of Syresham, singleman, laborer 1
4944959 2340413 2340413 defendant Gybon Stephen cordwainer 672373 672373 Gybon, Stephen, of Syresham, cordwainer 0
4944960 2340413 2340413 defendant Ricardes William laborer 672373 672373 Ricardes, William, of Syresham, singleman, laborer 1
5000160 2356928 2356928 defendant Colles Nicholas husbandman 672373 672373 Colles, Nicholas, of Syresham, husbandman 0
5014828 2361213 2361213 defendant Molde Thomas husbandman 672373 672373 Molde, Thomas, of Syresham, husbandman 0
5035436 2367222 2367222 defendant Colles Nicholas husbandman 672373 672373 Colles, Nicholas, of Syresham, husbandman 0
5089586 2383328 2383328 defendant Bechem John husbandman 672373 672373 Bechem, John, of Syresham, husbandman 1
5305647 2446695 2446695 defendant Fraunceys Hugh   672373 672373 Fraunceys, Hugh, of Syresham 0
5305649 2446696 2446696 defendant Gebons Richard husbandman 672373 672373 Gebons, Richard, of Syresham, husbandman 0
5305651 2446696 2446696 defendant Fraunceys Hugh   672373 672373 together with Fraunceys, Hugh, of Syresham 2
5306950 2447075 2447075 defendant Blysse William weaver 672373 672373 Blysse, William, of Syresham, weaver 2
5379584 2469201 2469201 defendant Blys William weaver 672373 672373 Blys, William, of Syresham, weaver 0
5537741 2516290 2516290 defendant Thorne Thomas gent 672373 672373 Thorne, Thomas, of Syresham, gent 2
5539669 2516887 2516887 defendant Markham John yeoman 672373 672373 Markham, John, of Syresham, yeoman 0
5539681 2516892 2516892 defendant Veysy John husbandman 672373 672373 Veysy, John, of Syresham, husbandman 0
5539682 2516892 2516892 defendant Squyer Stephen husbandman 672373 672373 Squyer, Stephen, of Syresham, husbandman 1
5632710 2554245 2554245 defendant Freman Robert   672373 672373 Freman, Robert, of Syresham 0
5632711 2554245 2554245 defendant Malesore John   672373 672373 Malesore, John, of Syresham 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);