names

29 rows where place_id = 760291

✎ 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
4468757 2190904 2190904 plaintiff Benge Walter   760291 760291 Benge, Walter, of Repyngton 0
4573620 2223263 2223263 defendant Dauber Robert   760291 760291 Dauber, Robert, of Repyngton 2
4642935 2244040 2244040 defendant Malveson Robert   760291 760291 Malveson, Robert, of Repyngton 5
4645129 2244645 2244645 defendant Broun John   760291 760291 Broun, John, of Repyngton 2
4768701 2286189 2286189 defendant Hanson Robert   760291 760291 Hanson, Robert, of Repyngton, shoe maker 1
4787187 2292059 2292059 defendant Spencer John smith 760291 760291 Spencer, John, of Repyngton, smith 0
4791551 2293450 2293450 defendant Osberton Swet yeoman 760291 760291 Osberton, Swet, of Repyngton, yeoman 3
4793283 2293995 2293995 defendant Hanneson Robert cordwainer 760291 760291 Hanneson, Robert, of Repyngton, cordwainer 0
4802112 2296852 2296852 defendant Pratte Thomas hosier 760291 760291 Pratte, Thomas, of Repyngton, hosier 0
4946094 2340766 2340766 plaintiff Broun Richard   760291 760291 Broun, Richard, of Repyngton 2
4988925 2353634 2353634 defendant Sterre John baker 760291 760291 Sterre, John, of Repyngton, baker 5
4988926 2353634 2353634 defendant Reynold John husbandman 760291 760291 Reynold, John, of Repyngton, husbandman 6
4988927 2353634 2353634 defendant Nyk John husbandman 760291 760291 Nyk, John, of Repyngton, husbandman 7
4988931 2353634 2353634 defendant Chamberleyn William tailor 760291 760291 Chamberleyn, William, of Repyngton, tailor 11
4988932 2353634 2353634 defendant Hether Richard tanner 760291 760291 Hether, Richard, of Repyngton, tanner 12
4988933 2353634 2353634 defendant Boteler John yeoman 760291 760291 Boteler, John, of Repyngton, yeoman 13
4988934 2353634 2353634 defendant Halle John weaver 760291 760291 Halle, John, of Repyngton, weaver 14
4988942 2353634 2353634 defendant Reynold William laborer 760291 760291 Reynold, William, of Repyngton, laborer 22
4994797 2355304 2355304 defendant Broun Joan   760291 760291 Broun, Joan, of Repyngton, widow, formerly wife of Richard 0
4994804 2355304 2355304 defendant Wayt Richard yeoman 760291 760291 Wayt, Richard, of Repyngton, yeoman 7
4994805 2355304 2355304 defendant Fyssher Ambrose chaplain 760291 760291 Fyssher, Ambrose, of Repyngton, chaplain 8
4994814 2355305 2355305 defendant Wayt Richard yeoman 760291 760291 Wayt, Richard, of Repyngton, yeoman 7
4994815 2355305 2355305 defendant Fyssher Robert chaplain 760291 760291 Fyssher, Robert, of Repyngton, chaplain 8
4995036 2355370 2355370 defendant Sclater Robert slater 760291 760291 Sclater, Robert, of Repyngton, slater 4
5034646 2366990 2366990 defendant Sterre John yeoman 760291 760291 Sterre, John, of Repyngton, yeoman 2
5047892 2370986 2370986 defendant Broun William yeoman 760291 760291 Broun, William, of Repyngton, yeoman 0
5068540 2377082 2377082 defendant Broun William yeoman 760291 760291 Broun, William, of Repyngton, yeoman 0
5093026 2384351 2384351 defendant Broun William yeoman 760291 760291 Broun, William, of Repyngton, yeoman 0
5235638 2426003 2426003 defendant Clerk John butcher 760291 760291 Clerk, John, of Repyngton, butcher 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);