names

65 rows where place_id = 600471

✎ 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
3641148 1907680 1907680 defendant Mott John yeoman 600471 600471 Mott, John, of Herstmonceux, yeoman 0
3756065 1943852 1943852 defendant Land or Laud John husbandman 600471 600471 Land or Laud, John, of Herstmonceux, husbandman 1
3797013 1956944 1956944 defendant Hanton or Hauton John saddler 600471 600471 Hanton or Hauton, John, of Herstmonceux, saddler 0
3804926 1959484 1959484 defendant Wenam John husbandman 600471 600471 Wenam, John, of Herstmonceux, husbandman 0
3804927 1959484 1959484 defendant Wenam Thomas husbandman 600471 600471 Wenam, Thomas, of Herstmonceux, husbandman 1
4013743 2029646 2029646 defendant Sampton Thomas husbandman 600471 600471 Sampton, Thomas, of Herstmonceux, husbandman 1
4072971 2050632 2050632 defendant Andrewes Richard gent 600471 600471 Andrewes, Richard, of Herstmonceux, gent 0
4073229 2050717 2050717 defendant Hatcher William yeoman 600471 600471 Hatcher, William, of Herstmonceux, yeoman 0
4074752 2051270 2051270 defendant Woodland John butcher 600471 600471 Woodland, John, of Herstmonceux, butcher 0
4074753 2051270 2051270 defendant Jackson William   600471 600471 Jackson, William, of Herstmonceux, surgeon 1
4082152 2053925 2053925 defendant Hemsley Edward yeoman 600471 600471 Hemsley, Edward, of Herstmonceux, yeoman 0
4097941 2059591 2059591 defendant Hatcher William yeoman 600471 600471 Hatcher, William, of Herstmonceux, yeoman 2
4097942 2059591 2059591 defendant Pont Edward yeoman 600471 600471 Pont, Edward, of Herstmonceux, yeoman 3
4097944 2059592 2059592 defendant Renne Thomas yeoman 600471 600471 Renne, Thomas, of Herstmonceux, yeoman 0
4097945 2059593 2059593 plaintiff Hemsley Edward yeoman 600471 600471 Hemsley, Edward, of Herstmonceux, yeoman 0
4097947 2059594 2059594 plaintiff Hemsley Edward yeoman 600471 600471 Hemsley, Edward, of Herstmonceux, yeoman 0
4097948 2059594 2059594 defendant Ren or Renne Thomas yeoman 600471 600471 Ren or Renne, Thomas, of Herstmonceux, yeoman 0
4097949 2059595 2059595 plaintiff Hemsley Edward yeoman 600471 600471 Hemsley, Edward, of Herstmonceux, yeoman 0
4097950 2059595 2059595 defendant Renne Thomas yeoman 600471 600471 Renne, Thomas, of Herstmonceux, yeoman 0
4098761 2059888 2059888 defendant Hemsley John yeoman 600471 600471 Hemsley, John, of Herstmonceux, yeoman 0
4108608 2063333 2063333 defendant Woodlande John butcher 600471 600471 Woodlande, John, of Herstmonceux, butcher 0
4109233 2063561 2063561 defendant Hemeslye Edward yeoman 600471 600471 Hemeslye, Edward, of Herstmonceux, yeoman 0
4123810 2068813 2068813 defendant Hemsley Edward yeoman 600471 600471 Hemsley, Edward, of Herstmonceux, yeoman 0
4126684 2069830 2069830 defendant Hemsley William carpenter 600471 600471 Hemsley, William, of Herstmonceux, carpenter 0
4126685 2069830 2069830 defendant Fawcett Miles yeoman 600471 600471 Fawcett, Miles, of Herstmonceux, yeoman 1
4128604 2070522 2070522 defendant Gregorye Richard yeoman 600471 600471 Gregorye, Richard, of Herstmonceux, yeoman 0
4130855 2071348 2071348 defendant Hemsley Edward yeoman 600471 600471 Hemsley, Edward, of Herstmonceux, yeoman 0
4133466 2072295 2072295 defendant Unwyne John shoemaker 600471 600471 Unwyne, John, of Herstmonceux, shoemaker 0
4133468 2072296 2072296 defendant Unwyne John shoemaker 600471 600471 Unwyne, John, of Herstmonceux, shoemaker 0
4137845 2073894 2073894 defendant Woodland John butcher 600471 600471 Woodland, John, of Herstmonceux, butcher 0
4137847 2073895 2073895 defendant Woodland John butcher 600471 600471 Woodland, John, of Herstmonceux, butcher 0
4172003 2085671 2085671 defendant Benjamyn Thomas yeoman 600471 600471 Benjamyn, Thomas, of Herstmonceux, yeoman 1
4176955 2087413 2087413 defendant Wood Thomas yeoman 600471 600471 Wood, Thomas, of Herstmonceux, yeoman 1
4185719 2090508 2090508 defendant Woodland John butcher 600471 600471 Woodland, John, of Herstmonceux, butcher 0
4191298 2092522 2092522 defendant Reynold John yeoman 600471 600471 Reynold, John, of Herstmonceux, yeoman 0
4191299 2092522 2092522 defendant Unwyn William yeoman 600471 600471 Unwyn, William, of Herstmonceux, yeoman 1
4191300 2092522 2092522 defendant Unwyn John yeoman 600471 600471 Unwyn, John, of Herstmonceux, yeoman 2
4191301 2092522 2092522 defendant Parker Simon yeoman 600471 600471 Parker, Simon, of Herstmonceux, yeoman 3
4195299 2093904 2093904 defendant Benjamyn Thomas yeoman 600471 600471 Benjamyn, Thomas, of Herstmonceux, yeoman 1
4200190 2095620 2095620 defendant Dufford Arthur yeoman 600471 600471 Dufford, Arthur, of Herstmonceux, yeoman 0
4225881 2104518 2104518 defendant Rabbett John yeoman 600471 600471 Rabbett, John, of Herstmonceux, or of Dallington, yeoman 1
4229841 2105920 2105920 defendant Dawes Thomas miller 600471 600471 Dawes, Thomas, of Herstmonceux, miller 0
4229842 2105920 2105920 defendant Borstowe Robert carpenter 600471 600471 Borstowe, Robert, of Herstmonceux, carpenter 1
4259848 2116265 2116265 defendant Britten alias Journold John husbandman 600471 600471 Britten alias Journold, John, of Herstmonceux, husbandman 1
4277989 2122232 2122232 defendant Salter Thomas yeoman 600471 600471 Salter, Thomas, of Herstmonceux, yeoman 0
4289597 2126346 2126346 defendant Asselden Thomas   600471 600471 Asselden, Thomas, of Herstmonceux, yeoman Raynold, Joan, of Ryoe widow 0
4289598 2126346 2126346 defendant Parker Simon yeoman 600471 600471 Parker, Simon, of Herstmonceux, yeoman 1
4313604 2134864 2134864 defendant Hemslie Edward yeoman 600471 600471 Hemslie, Edward, of Herstmonceux, yeoman 2
4315417 2135502 2135502 defendant Feilde Robert husbandman 600471 600471 Feilde, Robert, of Herstmonceux, or of Asheborneham, husbandman 0
4317778 2136330 2136330 defendant Gylbert Edward husbandman 600471 600471 Gylbert, Edward, of Herstmonceux, husbandman 0
4317779 2136330 2136330 defendant Myller Thomas husbandman 600471 600471 Myller, Thomas, of Herstmonceux, husbandman 1
4319316 2136865 2136865 defendant Danyell Robert yeoman 600471 600471 Danyell, Robert, of Herstmonceux, or of Wartlynge, yeoman 2
4319348 2136876 2136876 defendant Dan Salomon husbandman 600471 600471 Dan, Salomon, of Herstmonceux, husbandman 0
4371817 2154981 2154981 defendant Selwyn John husbandman 600471 600471 together with Selwyn, John, of Herstmonceux, husbandman 1
4702708 2266248 2266248 defendant atte Bergh Thomas yeoman 600471 600471 atte Bergh, Thomas, of Herstmonceux, yeoman 2
4726637 2273603 2273603 defendant Trygge Edmund laborer 600471 600471 Trygge, Edmund, of Herstmonceux, laborer 0
4839182 2308183 2308183 defendant Onewyn John butcher 600471 600471 Onewyn, John, of Herstmonceux, butcher 0
4920073 2332789 2332789 defendant Honwyn John butcher 600471 600471 Honwyn, John, of Herstmonceux, butcher 0
4952862 2342815 2342815 defendant Onewyn John butcher 600471 600471 Onewyn, John, of Herstmonceux, butcher 0
4952865 2342816 2342816 defendant Onewyn John butcher 600471 600471 Onewyn, John, of Herstmonceux, butcher 0
5158287 2403548 2403548 defendant Fenys Richard   600471 600471 Fenys, Richard, of Herstmonceux, knight 0
5383650 2470407 2470407 defendant Lynche John   600471 600471 Lynche, John, of Herstmonceux 0
5383651 2470407 2470407 defendant Alen John yeoman 600471 600471 Alen, John, of Herstmonceux, yeoman 1
5383652 2470407 2470407 defendant Tryce John yeoman 600471 600471 Tryce, John, of Herstmonceux, yeoman 2
5589569 2531737 2531737 defendant Melward William yeoman 600471 600471 Melward, William, of Herstmonceux, yeoman 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);