names

27 rows where place_id = 596155

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: case_id, role, surname, forename, occupation, raw_segment, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3623392 1874847 1874847 defendant Wode Robert clerk 596155 596155 Wode, Robert, of Estyngton, clerk 0
3633496 1905291 1905291 plaintiff Kyng Thomas (legal representative) 596155 596155 Kyng, Thomas, of Estyngton, husbandman, executor of 0
3662517 1914193 1914193 defendant Cole William, senior husbandman 596155 596155 Cole, William, senior, of Estyngton, husbandman 0
3662519 1914194 1914194 defendant Cole William, senior husbandman 596155 596155 Cole, William, senior, of Estyngton, husbandman 0
3663331 1914454 1914454 defendant Crabbe William husbandman 596155 596155 Crabbe, William, of Estyngton, husbandman 2
3805666 1959715 1959715 defendant Watkyns William husbandman 596155 596155 Watkyns, William, of Estyngton, husbandman 0
3872639 1981065 1981065 defendant Byrdeley Thomas, junior clothmaker 596155 596155 Byrdeley, Thomas, junior, of Estyngton, clothmaker 0
3893112 1987943 1987943 plaintiff Osborne Walter yeoman 596155 596155 Osborne, Walter, of Estyngton, yeoman 2
3907224 1992707 1992707 defendant Blanche William tucker 596155 596155 Blanche, William, of Estyngton, tucker 0
3917212 1996116 1996116 defendant Grene John husbandman 596155 596155 Grene, John, of Estyngton, husbandman 0
3919253 1996769 1996769 defendant Heynes John carrier 596155 596155 Heynes, John, of Estyngton, carrier 3
3921025 1997380 1997380 defendant Davys John weaver 596155 596155 Davys, John, of Estyngton, weaver 0
4602396 2231965 2231965 plaintiff Welle John   596155 596155 Welle, John, of Estyngton, parson 0
4678743 2258956 2258956 defendant Jorge Willaim   596155 596155 Jorge, Willaim, of Estyngton, franklin 9
4681602 2259858 2259858 defendant Ibray William husbandman 596155 596155 Ibray, William, of Estyngton, husbandman 1
4688778 2262046 2262046 defendant Wyllyng Joan widow & formerly wife of Roger Wyllyng 596155 596155 Wyllyng, Joan, of Estyngton, widow & formerly wife of Roger Wyllyng 1
4688779 2262046 2262046 defendant Priour Thomas husbandman 596155 596155 Priour, Thomas, of Estyngton, husbandman 2
4697057 2264560 2264560 defendant Dorset John   596155 596155 Dorset, John, of Estyngton, mason 0
4770799 2286845 2286845 defendant Hulman William husbandman 596155 596155 Hulman, William, of Estyngton, husbandman 2
4857022 2313576 2313576 defendant Mason John   596155 596155 Mason, John, of Estyngton, mason 2
4873317 2318607 2318607 defendant Stamppe John husbandman 596155 596155 Stamppe, John, of Estyngton, husbandman 0
5378812 2468958 2468958 defendant Cloterboke John fuller of cloth 596155 596155 Cloterboke, John, of Estyngton, fuller of cloth 0
5525929 2512702 2512702 defendant Aleyn Roger husbandman 596155 596155 Aleyn, Roger, of Estyngton, husbandman 0
5543219 2517998 2517998 defendant Cole William yeoman 596155 596155 Cole, William, of Estyngton, yeoman 0
5543357 2518041 2518041 defendant Cole William yeoman 596155 596155 Cole, William, of Estyngton, yeoman 0
5627253 2552492 2552492 defendant Talgart Philip chaplain 596155 596155 Talgart, Philip, of Estyngton, chaplain 0
5627254 2552492 2552492 defendant Estyngton John butcher 596155 596155 Estyngton, John, of Estyngton, butcher 1

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