names

54 rows where place_id = 595899

✎ 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
3622330 1874521 1874521 defendant Jorden Richard yeoman 595899 595899 Jorden, Richard, of Suthwyk, yeoman 0
3624672 1875252 1875252 defendant Broke William laborer 595899 595899 Broke, William, of Suthwyk, laborer 0
3629790 1904169 1904169 defendant Lynne Margaret widow 595899 595899 Lynne, Margaret, of Suthwyk, widow 0
3696006 1924990 1924990 defendant Devyses Henry husbandman 595899 595899 Devyses, Henry, of Suthwyk, husbandman 0
3799429 1957741 1957741 defendant Fyll Henry husbandman 595899 595899 Fyll, Henry, of Suthwyk, husbandman 3
4482633 2195272 2195272 defendant (not given) William prior of Horsele 595899 595899 Horsele, William, of Suthwyk, prior of the church 0
4556801 2218062 2218062 defendant Druet Walter   595899 595899 Druet, Walter, of Suthwyk 1
4624275 2238580 2238580 defendant Mubbrugg Valentine   595899 595899 Mubbrugg, Valentine, of Suthwyk 0
4666903 2255379 2255379 defendant Rothe George husbandman 595899 595899 Rothe, George, of Suthwyk, husbandman 0
4666904 2255379 2255379 defendant More John laborer 595899 595899 More, John, of Suthwyk, laborer 1
4722876 2272470 2272470 plaintiff (not given) Thomas prior of Courteys 595899 595899 Courteys, Thomas, of Suthwyk, prior of the church of the BM 0
4735780 2276339 2276339 defendant Michell Simon husbandman 595899 595899 Michell, Simon, of Suthwyk, husbandman 1
4800378 2296298 2296298 defendant Man William hosteler 595899 595899 Man, William, of Suthwyk, hosteler 0
4808213 2298747 2298747 plaintiff (not given) Thomas prior of Courteys 595899 595899 Courteys, Thomas, of Suthwyk, prior of the church of the BM 0
4808609 2298858 2298858 plaintiff Curteys Thomas   595899 595899 Curteys, Thomas, of Suthwyk, prior 0
4835299 2307039 2307039 plaintiff Dene Edward   595899 595899 Dene, Edward, of Suthwyk, prior 0
4872122 2318242 2318242 defendant Lynch Adam baker 595899 595899 Lynch, Adam, of Suthwyk, baker 0
4881537 2321127 2321127 defendant Compton Henry husbandman 595899 595899 Compton, Henry, of Suthwyk, husbandman 0
4893053 2324547 2324547 defendant Gernesey William tailor 595899 595899 Gernesey, William, of Suthwyk, tailor 0
4893054 2324547 2324547 defendant Farnest John weaver 595899 595899 Farnest, John, of Suthwyk, weaver 1
4893953 2324809 2324809 defendant Pery John husbandman 595899 595899 Pery, John, of Suthwyk, husbandman 0
4940178 2338960 2338960 defendant Hygon John husbandman 595899 595899 Hygon, John, of Suthwyk, husbandman 0
4943569 2339958 2339958 defendant Elmys William merchant 595899 595899 Elmys, William, of Suthwyk, merchant 0
4943571 2339958 2339958 defendant Trewe Walter laborer 595899 595899 Trewe, Walter, of Suthwyk, laborer 2
4946113 2340772 2340772 defendant Norton Joan widow 595899 595899 Norton, Joan, of Suthwyk, widow 5
4946120 2340773 2340773 defendant Norton Joan widow 595899 595899 Norton, Joan, of Suthwyk, widow 5
4992944 2354772 2354772 defendant Wandell Richard husbandman 595899 595899 Wandell, Richard, of Suthwyk, husbandman 0
5022382 2363443 2363443 defendant Norton Thomas husbandman 595899 595899 Norton, Thomas, of Suthwyk, husbandman 0
5197927 2415134 2415134 defendant Goddysmarke John husbandman 595899 595899 Goddysmarke, John, of Suthwyk, husbandman 0
5273740 2437401 2437401 defendant Vyle John husbandman 595899 595899 Vyle, John, of Suthwyk, husbandman 0
5300473 2445103 2445103 defendant Bancrofte James (legal representative) 595899 595899 Bancrofte, James, of Suthwyk, gent, executor of 0
5309209 2447790 2447790 plaintiff (not given) Philip prior of Stambrok 595899 595899 Stambrok, Philip, of Suthwyk, prior of the house & church of the BM 0
5309214 2447791 2447791 plaintiff (not given) Philip prior of Stambrok 595899 595899 Stambrok, Philip, of Suthwyk, prior of the house & church of the BM 0
5309392 2447847 2447847 defendant Sebot Robert laborer 595899 595899 Sebot, Robert, of Suthwyk, laborer 0
5317182 2450222 2450222 defendant Sebote Robert husbandman 595899 595899 Sebote, Robert, of Suthwyk, husbandman 0
5317183 2450222 2450222 defendant Edward John husbandman 595899 595899 Edward, John, of Suthwyk, husbandman 1
5343448 2458140 2458140 defendant Edward Robert tanner 595899 595899 Edward, Robert, of Suthwyk, tanner 0
5367402 2465456 2465456 defendant Hill Richard laborer 595899 595899 Hill, Richard, of Suthwyk, laborer 7
5367403 2465456 2465456 defendant Wever William weaver 595899 595899 Wever, William, of Suthwyk, weaver 8
5411576 2478417 2478417 defendant Mill Thomas chapman 595899 595899 Mill, Thomas, of Suthwyk, chapman 2
5433415 2484951 2484951 defendant Wymer John yeoman 595899 595899 Wymer, John, of Suthwyk, yeoman 1
5437835 2486248 2486248 plaintiff (not given) Philip prior of Stanebrok 595899 595899 Stanebrok, Philip, of Suthwyk, prior of St Mary's house & church 0
5469855 2495910 2495910 defendant Senok John baker 595899 595899 Senok, John, of Suthwyk, baker 1
5490422 2502030 2502030 defendant Dalyrose Robert husbandman 595899 595899 Dalyrose, Robert, of Suthwyk, husbandman 1
5490424 2502030 2502030 defendant Seynok John baker 595899 595899 Seynok, John, of Suthwyk, baker 3
5502884 2505816 2505816 defendant Wylkyns Robert husbandman 595899 595899 Wylkyns, Robert, of Suthwyk, husbandman 1
5515333 2509640 2509640 defendant Sevenok John baker 595899 595899 Sevenok, John, of Suthwyk, baker 1
5583179 2529816 2529816 defendant Avery John husbandman 595899 595899 Avery, John, of Suthwyk, husbandman 0
5583305 2529850 2529850 defendant Avery John husbandman 595899 595899 Avery, John, of Suthwyk, husbandman 0
5583312 2529852 2529852 defendant Throp John husbandman 595899 595899 Throp, John, of Suthwyk, husbandman 0
5613665 2548049 2548049 defendant Corbet Richard   595899 595899 Corbet, Richard, of Suthwyk 0
5635723 2555130 2555130 defendant Strevelyng Simon tanner 595899 595899 Strevelyng, Simon, of Suthwyk, tanner 0
5635724 2555130 2555130 defendant Turnour Lawrence tanner 595899 595899 Turnour, Lawrence, of Suthwyk, tanner 1
5635725 2555130 2555130 defendant Clerk William laborer 595899 595899 Clerk, William, of Suthwyk, laborer 2

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