names

52 rows where place_id = 760411

✎ 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
4469813 2191231 2191231 defendant Bodeford John   760411 760411 Bodeford, John, of Haveryng atte Boure, Essex 0
4469845 2191236 2191236 defendant Bedeford John   760411 760411 Bedeford, John, of Haveryng atte Boure, Essex 0
4681758 2259905 2259905 defendant Clyve Thomas yeoman 760411 760411 Clyve, Thomas, of Haveryng atte Boure, Essex, yeoman 0
4740602 2277766 2277766 defendant Chaterton Henry gent 760411 760411 Chaterton, Henry, of Haveryng atte Boure, Essex, gent 0
4755991 2282257 2282257 defendant Haynton Robert clerk 760411 760411 Haynton, Robert, of Haveryng atte Boure, Essex, clerk 0
4785360 2291437 2291437 defendant Imayn Thomas husbandman 760411 760411 Imayn, Thomas, of Haveryng atte Boure, Essex, husbandman 0
4818247 2301785 2301785 defendant Alberdyn Agnes widow 760411 760411 Alberdyn, Agnes, of Haveryng atte Boure, Essex, widow 1
4842671 2309244 2309244 plaintiff Longe John   760411 760411 Longe, John, of Haveryng atte Boure, Essex 0
4883370 2321721 2321721 defendant Marssh Thomas tiler 760411 760411 Marssh, Thomas, of Haveryng atte Boure, Essex, tiler 0
4935235 2337421 2337421 defendant De- Thomas gent 760411 760411 De-, Thomas, of Haveryng atte Boure, Essex, gent 0
4935237 2337422 2337422 defendant Dencourt Thomas gent 760411 760411 Dencourt, Thomas, of Haveryng atte Boure, Essex, gent 0
4956492 2343900 2343900 defendant Furmentyne John husbandman 760411 760411 Furmentyne, John, of Haveryng atte Boure, Essex, husbandman 1
4956495 2343901 2343901 defendant Furmentyne John husbandman 760411 760411 Furmentyne, John, of Haveryng atte Boure, Essex, husbandman 1
4962303 2345627 2345627 defendant Stace William husbandman 760411 760411 Stace, William, of Haveryng atte Boure, Essex, husbandman 0
4968945 2347676 2347676 defendant Uphaveryng John   760411 760411 Uphaveryng, John, of Haveryng atte Boure, Essex, husbandman, brother of Uphaveryng, Thomas, of Haveryng atte Boure 0
4968950 2347678 2347678 defendant Uphaveryng John   760411 760411 Uphaveryng, John, of Haveryng atte Boure, Essex, husbandman, brother of Uphaveryng, Thomas, of Haveryng atte Boure 0
4988778 2353598 2353598 defendant Stacy William chapman 760411 760411 Stacy, William, of Haveryng atte Boure, Essex, chapman 5
5006294 2358738 2358738 defendant Bole John yeoman 760411 760411 Bole, John, of Haveryng atte Boure, Essex, yeoman 0
5013987 2360948 2360948 defendant Chaderton Joan esq 760411 760411 Chaderton, Joan, of Haveryng atte Boure, Essex, widow of Hamme, Richard, esq 0
5023200 2363686 2363686 defendant Welot Thomas husbandman 760411 760411 Welot, Thomas, of Haveryng atte Boure, Essex, husbandman 0
5023581 2363807 2363807 defendant Chadyrton Henry esq 760411 760411 Chadyrton, Henry, of Haveryng atte Boure, Essex, esq 3
5047326 2370817 2370817 defendant F---- John yeoman 760411 760411 F----, John, of Haveryng atte Boure, Essex, yeoman 0
5067577 2376800 2376800 defendant Cole John tailor 760411 760411 Cole, John, of Haveryng atte Boure, Essex, tailor 0
5096669 2385461 2385461 defendant Stacy Richard, senior husbandman 760411 760411 Stacy, Richard, senior, of Haveryng atte Boure, Essex, husbandman 2
5096674 2385462 2385462 defendant Stace Richard, senior husbandman 760411 760411 Stace, Richard, senior, of Haveryng atte Boure, Essex, husbandman 2
5116457 2391247 2391247 defendant Herd John   760411 760411 Herd, John, of Haveryng atte Boure, Essex 0
5134141 2396480 2396480 defendant Banke Robert yeoman 760411 760411 Banke, Robert, of Haveryng atte Boure, Essex, yeoman 1
5136788 2397279 2397279 defendant Stase Richard husbandman 760411 760411 Stase, Richard, of Haveryng atte Boure, Essex, husbandman 4
5143844 2399335 2399335 defendant Walle William husbandman 760411 760411 Walle, William, of Haveryng atte Boure, Essex, husbandman 1
5148482 2400683 2400683 defendant Chaterton Henry esq 760411 760411 Chaterton, Henry, of Haveryng atte Boure, Essex, esq 0
5154058 2402345 2402345 defendant Banke Robert yeoman 760411 760411 Banke, Robert, of Haveryng atte Boure, Essex, yeoman 1
5167769 2406287 2406287 defendant Chaterton Henry esq 760411 760411 Chaterton, Henry, of Haveryng atte Boure, Essex, esq 0
5171831 2407479 2407479 defendant Robynson John husbandman 760411 760411 Robynson, John, of Haveryng atte Boure, Essex, husbandman 3
5173314 2407906 2407906 defendant Scase Richard husbandman 760411 760411 Scase, Richard, of Haveryng atte Boure, Essex, husbandman 3
5175076 2408405 2408405 defendant Uphaveryng John laborer 760411 760411 Uphaveryng, John, of Haveryng atte Boure, Essex, laborer 0
5181694 2410387 2410387 defendant Convers John collier 760411 760411 Convers, John, of Haveryng atte Boure, Essex, collier 0
5181899 2410454 2410454 defendant Skargyll Thomas esq 760411 760411 Skargyll, Thomas, of Haveryng atte Boure, Essex, esq 0
5183355 2410872 2410872 defendant Chaterton Henry esq 760411 760411 Chaterton, Henry, of Haveryng atte Boure, Essex, esq 0
5190220 2412879 2412879 defendant Robynson John husbandman 760411 760411 Robynson, John, of Haveryng atte Boure, Essex, husbandman 0
5203047 2416651 2416651 defendant Convers John collier 760411 760411 Convers, John, of Haveryng atte Boure, Essex, collier 0
5203845 2416876 2416876 defendant Chaterton Henry esq 760411 760411 Chaterton, Henry, of Haveryng atte Boure, Essex, esq 0
5212209 2419309 2419309 defendant Wreyght John yeoman 760411 760411 Wreyght, John, of Haveryng atte Boure, Essex, yeoman 1
5230027 2424395 2424395 defendant Parchemener William yeoman 760411 760411 Parchemener, William, of Haveryng atte Boure, Essex, yeoman 0
5280000 2439221 2439221 defendant Patryk William tailor 760411 760411 Patryk, William, of Haveryng atte Boure, Essex, tailor 0
5321727 2451572 2451572 defendant Sterlyng John husbandman 760411 760411 Sterlyng, John, of Haveryng atte Boure, Essex, husbandman 1
5322081 2451678 2451678 defendant Robynson Peter fuller 760411 760411 Robynson, Peter, of Haveryng atte Boure, Essex, fuller 0
5340371 2457192 2457192 defendant Boyse John gent 760411 760411 Boyse, John, of Haveryng atte Boure, Essex, gent 1
5354131 2461357 2461357 defendant Ruk Thomas tanner 760411 760411 Ruk, Thomas, of Haveryng atte Boure, Essex, tanner 0
5512765 2508847 2508847 defendant Reynold John butcher 760411 760411 Reynold, John, of Haveryng atte Boure, Essex, butcher 4
5523121 2512058 2512058 defendant Coke Philip   760411 760411 Coke, Philip, of Haveryng atte Boure, Essex, knight 0
5528122 2513361 2513361 defendant Cotton Margaret widow 760411 760411 (Cotton, Margaret, of Haveryng atte Boure, Essex, widow 2
5611521 2547336 2547336 defendant Wedeford John   760411 760411 Wedeford, John, of Haveryng atte Boure, Essex 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);