names

41 rows where place_id = 621402

✎ 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
3741177 1939101 1939101 defendant Woodcok Hugh clerk 621402 621402 Woodcok, Hugh, of Tudenham, clerk 3
3822906 1965069 1965069 defendant Largeaunt Robert husbandman 621402 621402 Largeaunt, Robert, of Tudenham, husbandman 0
3851868 1974176 1974176 defendant Smyth Richard husbandman 621402 621402 Smyth, Richard, of Tudenham, husbandman 2
3866399 1978993 1978993 defendant Jervys John yeoman 621402 621402 Jervys, John, of Tudenham, yeoman 1
4595372 2229806 2229806 plaintiff Rede William   621402 621402 Rede, William, of tudenham 0
4649570 2245904 2245904 plaintiff Wade John   621402 621402 Wade, John, of Tudenham 0
4731798 2275134 2275134 defendant Broun Walter   621402 621402 Broun, Walter, of Tudenham, shepherd 2
4731800 2275134 2275134 defendant Sowode Richard butcher 621402 621402 Sowode, Richard, of Tudenham, butcher 4
4764438 2284865 2284865 plaintiff Shelton Peter   621402 621402 (Shelton, Peter, of Tudenham, parson of the church 1
4764443 2284866 2284866 plaintiff Shelton Peter   621402 621402 (Shelton, Peter, of Tudenham, parson of the church 1
4831750 2305954 2305954 defendant Gedircole John, sen husbandman 621402 621402 Gedircole, John, sen, of Tudenham, husbandman 0
4861261 2314890 2314890 defendant Kempe Thomas laborer 621402 621402 Kempe, Thomas, of Tudenham, laborer 0
4881216 2321030 2321030 defendant Forthe Richard   621402 621402 Forthe, Richard, of Tudenham, wright 0
4940420 2339027 2339027 defendant Bullyng John laborer 621402 621402 Bullyng, John, of Tudenham, laborer 0
4940421 2339027 2339027 defendant Silvestre Robert husbandman 621402 621402 Silvestre, Robert, of Tudenham, husbandman 1
4966354 2346871 2346871 defendant Mynter John yeoman 621402 621402 Mynter, John, of Tudenham, yeoman 2
4966359 2346872 2346872 defendant Mynter John yeoman 621402 621402 Mynter, John, of Tudenham, yeoman 2
4982696 2351737 2351737 defendant Mynter John husbandman 621402 621402 Mynter, John, of Tudenham, husbandman 0
4989610 2353818 2353818 defendant Mynter John husbandman 621402 621402 Mynter, John, of Tudenham, husbandman 4
4993235 2354856 2354856 defendant Kervere Henry spicer 621402 621402 Kervere, Henry, of Tudenham, spicer 0
5127540 2394535 2394535 defendant Groundshawe Richard yeoman 621402 621402 Groundshawe, Richard, of Tudenham, yeoman 0
5196348 2414682 2414682 defendant Myntyr Robert yeoman 621402 621402 Myntyr, Robert, of Tudenham, yeoman 0
5199116 2415495 2415495 defendant Man Roger husbandman 621402 621402 Man, Roger, of Tudenham, husbandman 0
5201058 2416069 2416069 defendant Myntyr Robert yeoman 621402 621402 Myntyr, Robert, of Tudenham, yeoman 0
5209611 2418550 2418550 defendant Mynter Robert yeoman 621402 621402 Mynter, Robert, of Tudenham, yeoman 0
5216665 2420608 2420608 defendant Edwyn John husbandman 621402 621402 Edwyn, John, of Tudenham, husbandman 4
5221517 2421990 2421990 defendant Mynter Robert husbandman 621402 621402 Mynter, Robert, of Tudenham, husbandman 2
5224463 2422824 2422824 defendant Wymark William husbandman 621402 621402 Wymark, William, of Tudenham, husbandman 0
5311600 2448493 2448493 defendant Hamond John   621402 621402 Hamond, John, of Tudenham, bell hanger 2
5311601 2448493 2448493 defendant Hamond John husbandman 621402 621402 Hamond, John, of Tudenham, husbandman 3
5358522 2462724 2462724 defendant Mynter Robert husbandman 621402 621402 Mynter, Robert, of Tudenham, husbandman 1
5379681 2469230 2469230 defendant Hamond John husbandman 621402 621402 Hamond, John, of Tudenham, husbandman 2
5379686 2469231 2469231 defendant Hamond John husbandman 621402 621402 Hamond, John, of Tudenham, husbandman 2
5397468 2474357 2474357 defendant Edwyn John, senior husbandman 621402 621402 Edwyn, John, senior, of Tudenham, husbandman 9
5424641 2482336 2482336 defendant Ewyn John, sen husbandman 621402 621402 Ewyn, John, sen, of Tudenham, husbandman 9
5444793 2488337 2488337 defendant Higdoun Thomas   621402 621402 Higdoun, Thomas, of Tudenham 0
5454128 2491133 2491133 defendant Edwyn John husbandman 621402 621402 Edwyn, John, of Tudenham, husbandman 9
5494250 2503184 2503184 defendant More Roger laborer 621402 621402 More Roger, of Tudenham, laborer 1
5494251 2503184 2503184 defendant More John thatcher 621402 621402 More John, of Tudenham, thatcher 2
5515415 2509666 2509666 defendant Hardgrey William yeoman 621402 621402 Hardgrey, William, of Tudenham, yeoman 0
5541376 2517420 2517420 defendant Smyth Robert husbandman 621402 621402 Smyth, Robert, of Tudenham, husbandman 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);