names

57 rows where place_id = 753362

✎ 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
4412983 2168934 2168934 plaintiff Amore John   753362 753362 Amore, John, of Tuttebury 0
4412986 2168935 2168935 plaintiff Amoret John   753362 753362 Amoret, John, of Tuttebury 0
4417079 2170211 2170211 defendant Baldwyche Nicholas merchant 753362 753362 Baldwyche, Nicholas, of Tuttebury, merchant 0
4473573 2192394 2192394 defendant Skynnere Robert   753362 753362 Skynnere, Robert, of Tuttebury 0
4478940 2194079 2194079 plaintiff Holynton John   753362 753362 Holynton, John, of Tuttebury 0
4495999 2199426 2199426 defendant Balyden Thomas   753362 753362 Balyden, Thomas, of Tuttebury 0
4557164 2218173 2218173 defendant Burton Richard   753362 753362 Burton, Richard, of Tuttebury 0
4575404 2223821 2223821 defendant Spenser John   753362 753362 Spenser, John, of Tuttebury 0
4576944 2224296 2224296 defendant Coupere William   753362 753362 Coupere, William, of Tuttebury 0
4576945 2224296 2224296 defendant Coupere Richard   753362 753362 Coupere, Richard, of Tuttebury 1
4598922 2230884 2230884 defendant Egynton William baker 753362 753362 Egynton, William, of Tuttebury, baker 0
4600982 2231535 2231535 defendant Hethur Thomas   753362 753362 Hethur, Thomas, of Tuttebury 0
4603748 2232358 2232358 defendant Burton Richard de   753362 753362 Burton, Richard de, of Tuttebury 0
4605473 2232841 2232841 defendant Chapman John   753362 753362 Chapman, John, of Tuttebury 1
4623436 2238304 2238304 defendant Dethyk Peter   753362 753362 Dethyk, Peter, of Tuttebury, image maker 0
4623447 2238307 2238307 defendant Wedon Roger de   753362 753362 Wedon, Roger de, of Tuttebury 1
4629087 2240021 2240021 defendant Eyr Thomas   753362 753362 Eyr, Thomas, of Tuttebury 1
4632232 2240965 2240965 defendant Chapmon John   753362 753362 Chapmon, John, of Tuttebury 0
4634287 2241566 2241566 defendant Dethyk Richard   753362 753362 Dethyk, Richard, of Tuttebury 0
4649234 2245826 2245826 defendant Chapman John   753362 753362 Chapman, John, of Tuttebury 0
4690141 2262472 2262472 plaintiff Wedon Roger   753362 753362 Wedon, Roger, of Tuttebury 0
4713365 2269503 2269503 defendant Wedon Roger   753362 753362 Wedon, Roger, of Tuttebury, burgess 1
4713405 2269515 2269515 defendant Dethek Peter yeoman 753362 753362 Dethek, Peter, of Tuttebury, yeoman 1
4713406 2269515 2269515 defendant Cutwyssell Richard yeoman 753362 753362 Cutwyssell, Richard, of Tuttebury, yeoman 2
4713407 2269515 2269515 defendant Chapman John yeoman 753362 753362 Chapman, John, of Tuttebury, yeoman 3
4714870 2269985 2269985 defendant Chapman John   753362 753362 Chapman, John, of Tuttebury 0
4715031 2270028 2270028 defendant Clerk William   753362 753362 Clerk, William, of Tuttebury 0
4735753 2276329 2276329 defendant Pasmere John yeoman 753362 753362 Pasmere, John, of Tuttebury, yeoman 1
4772764 2287450 2287450 defendant Isok Richard chapman 753362 753362 Isok, Richard, of Tuttebury, chapman 0
4808120 2298715 2298715 defendant Shirley William parker 753362 753362 Shirley, William, of Tuttebury, parker 1
4808121 2298715 2298715 defendant Isok Richard yeoman 753362 753362 Isok, Richard, of Tuttebury, yeoman 2
4813074 2300204 2300204 defendant Preaux Adam   753362 753362 Preaux, Adam, of Tuttebury, prior 0
4820865 2302612 2302612 defendant Wilde John gent 753362 753362 Wilde, John, of Tuttebury, gent 8
4866000 2316336 2316336 defendant Cade Robert butcher 753362 753362 Cade, Robert, of Tuttebury, butcher 2
4866001 2316336 2316336 defendant Willyngton Robert butcher 753362 753362 Willyngton, Robert, of Tuttebury, butcher 3
4866005 2316336 2316336 defendant Willyngton Rose widow 753362 753362 Willyngton, Rose, of Tuttebury, widow 7
4928900 2335461 2335461 defendant (not given) Thomas prior of Gedney 753362 753362 Gedney, Thomas, of Tuttebury, prior of the priory of the BM 0
4968617 2347580 2347580 defendant Isok Richard yeoman 753362 753362 Isok, Richard, of Tuttebury, yeoman 0
4968618 2347580 2347580 defendant Pante or Paute John yeoman 753362 753362 Pante or Paute, John, of Tuttebury, yeoman 1
4976365 2349892 2349892 defendant Chekley Richard laborer 753362 753362 Chekley, Richard, of Tuttebury, laborer 0
4984283 2352224 2352224 defendant Milward Hugh   753362 753362 Milward, Hugh, of Tuttebury, millward 0
4995334 2355449 2355449 plaintiff (not given) Thomas prior of Gedney 753362 753362 Gedney, Thomas, of Tuttebury, prior of the monastery of the BM 0
4995335 2355449 2355449 defendant Isak Richard yeoman 753362 753362 Isak, Richard, of Tuttebury, yeoman 0
5016230 2361631 2361631 plaintiff Browne Thomas   753362 753362 Browne, Thomas, of Tuttebury 0
5022841 2363591 2363591 defendant Justelyn John laborer 753362 753362 Justelyn, John, of Tuttebury, laborer 0
5023374 2363744 2363744 defendant Isoke Felicia widow 753362 753362 Isoke, Felicia, of Tuttebury, widow 1
5038272 2368084 2368084 plaintiff Ysok Richard (legal representative) 753362 753362 Ysok, Richard, of Tuttebury, executrix of 0
5049587 2371505 2371505 defendant Wylde John gent 753362 753362 Wylde, John, of Tuttebury, gent 0
5056659 2373562 2373562 defendant Justelyn John husbandman 753362 753362 Justelyn, John, of Tuttebury, husbandman 0
5134052 2396456 2396456 defendant Gedney Thomas   753362 753362 Gedney, Thomas, of Tuttebury, the former prior 1
5189331 2412611 2412611 defendant Gedney Thomas   753362 753362 Gedney, Thomas, of Tuttebury, Staffs, prior 0
5288515 2441655 2441655 defendant Broun Henry yeoman 753362 753362 Broun, Henry, of Tuttebury, yeoman 0
5574594 2527129 2527129 defendant Shepherd Arthur husbandman 753362 753362 Shepherd, Arthur, of Tuttebury, husbandman 0
5618599 2549651 2549651 defendant Chapman William   753362 753362 Chapman, William, of Tuttebury 1
5623068 2551151 2551151 defendant Bakere Richard   753362 753362 Bakere, Richard, of Tuttebury 4
5632442 2554181 2554181 defendant Wedon Roger husbandman 753362 753362 Wedon, Roger, of Tuttebury, husbandman 1
5634470 2554780 2554780 defendant Clerk William   753362 753362 Clerk, William, of Tuttebury 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);