names

43 rows where place_id = 598081

✎ 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
3631032 1904527 1904527 defendant Barsham Geoffrey husbandman 598081 598081 Barsham, Geoffrey, of Hyndolveston, husbandman 1
3632391 1904950 1904950 defendant Sheryngham William butcher 598081 598081 Sheryngham, William, of Hyndolveston, butcher 0
3632392 1904950 1904950 defendant Barsham Geoffrey husbandman 598081 598081 Barsham, Geoffrey, of Hyndolveston, husbandman 1
3676149 1918582 1918582 plaintiff Hunt Nicholas   598081 598081 Hunt, Nicholas, of Hyndolveston 0
3908225 1993049 1993049 defendant Matsalle William chapman 598081 598081 Matsalle, William, of Hyndolveston, chapman 1
4252527 2113836 2113836 defendant Ollye Nicholas husbandman 598081 598081 Ollye, Nicholas, of Hyndolveston, husbandman 1
4256435 2115121 2115121 defendant Gilbert James yeoman 598081 598081 Gilbert, James, of Hyndolveston, yeoman 0
4326601 2139257 2139257 defendant Ollye Nicholas carpenter 598081 598081 Ollye, Nicholas, of Hyndolveston, carpenter 0
4411156 2168320 2168320 defendant Tompson Robert tailor 598081 598081 Tompson, Robert, of Hyndolveston, tailor 0
5156723 2403126 2403126 defendant Hunt John husbandman 598081 598081 Hunt, John, of Hyndolveston, husbandman 0
5246660 2429182 2429182 defendant Talface Richard husbandman 598081 598081 Talface, Richard, of Hyndolveston, husbandman 2
5257655 2432516 2432516 plaintiff Fuller Geoffrey   598081 598081 Fuller, Geoffrey, of Hyndolveston 0
5257657 2432516 2432516 defendant Robynes John laborer 598081 598081 Robynes, John, of Hyndolveston, laborer 0
5365486 2464879 2464879 defendant Robynes John yeoman 598081 598081 Robynes, John, of Hyndolveston, yeoman 3
5365543 2464896 2464896 defendant Robyns Robert carpenter 598081 598081 Robyns, Robert, of Hyndolveston, carpenter 3
5377072 2468418 2468418 defendant Yareham John carpenter 598081 598081 Yareham, John, of Hyndolveston, carpenter 0
5377075 2468418 2468418 defendant Tylney Richard husbandman 598081 598081 Tylney, Richard, of Hyndolveston, husbandman 3
5387584 2471517 2471517 defendant Clevent Edmund husbandman 598081 598081 Clevent, Edmund, of Hyndolveston, husbandman 0
5387586 2471517 2471517 defendant Bewryng Robert husbandman 598081 598081 Bewryng, Robert, of Hyndolveston, husbandman 2
5387587 2471517 2471517 defendant Myles Edmund husbandman 598081 598081 Myles, Edmund, of Hyndolveston, husbandman 3
5387588 2471517 2471517 defendant Robyns Robert husbandman 598081 598081 Robyns, Robert, of Hyndolveston, husbandman 4
5393554 2473218 2473218 plaintiff Talfas Richard husbandman 598081 598081 Talfas, Richard, of Hyndolveston, husbandman 0
5393555 2473218 2473218 defendant Fuller Robert yeoman 598081 598081 Fuller, Robert, of Hyndolveston, yeoman, son of Geoffrey Fuller, yeoman 0
5394456 2473477 2473477 defendant Yarham Thomas carpenter 598081 598081 Yarham, Thomas, of Hyndolveston, carpenter 0
5403500 2476071 2476071 defendant Neuman Edmund carpenter 598081 598081 Neuman, Edmund, of Hyndolveston, carpenter 1
5412272 2478620 2478620 defendant Yarham John carpenter 598081 598081 Yarham, John, of Hyndolveston, carpenter 9
5413182 2478866 2478866 defendant Clement Edmund husbandman 598081 598081 Clement, Edmund, of Hyndolveston, husbandman 0
5413184 2478866 2478866 defendant Beteryng Robert husbandman 598081 598081 Beteryng, Robert, of Hyndolveston, husbandman 2
5413186 2478866 2478866 defendant Robyns Robert husbandman 598081 598081 Robyns, Robert, of Hyndolveston, husbandman 4
5419331 2480703 2480703 defendant Yardham John   598081 598081 Yardham, John, of Hyndolveston 2
5419886 2480863 2480863 defendant Fuller Robert   598081 598081 Fuller, Robert, of Hyndolveston, yeoman, son of Geoffrey 0
5426969 2483004 2483004 defendant Yarham John carpenter 598081 598081 Yarham, John, of Hyndolveston, carpenter 8
5428348 2483403 2483403 defendant Clement Edmund husbandman 598081 598081 Clement, Edmund, of Hyndolveston, husbandman 0
5428695 2483498 2483498 defendant Odams John carpenter 598081 598081 Odams, John, of Hyndolveston, carpenter 0
5428703 2483499 2483499 defendant Odams John carpenter 598081 598081 Odams, John, of Hyndolveston, carpenter 0
5433512 2484985 2484985 defendant Neuman Edmunds carpenter 598081 598081 Neuman, Edmunds, of Hyndolveston, carpenter 1
5434282 2485188 2485188 defendant Robyns John husbandman 598081 598081 Robyns, John, of Hyndolveston, husbandman 0
5437582 2486177 2486177 defendant Tylney Richard yeoman 598081 598081 Tylney, Richard, of Hyndolveston, yeoman 3
5445954 2488679 2488679 defendant Odame John carpenter 598081 598081 Odame, John, of Hyndolveston, carpenter 0
5448541 2489461 2489461 defendant Robyns Robert husbandman 598081 598081 Robyns, Robert, of Hyndolveston, husbandman 0
5453602 2490969 2490969 defendant Yarham John husbandman 598081 598081 Yarham, John, of Hyndolveston, husbandman 1
5474949 2497489 2497489 defendant Odams John carpenter 598081 598081 Odams, John, of Hyndolveston, carpenter 4
5609048 2537735 2537735 defendant Fuller William yeoman 598081 598081 Fuller, William, of Hyndolveston, yeoman 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);