names

63 rows where place_id = 587691

✎ 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
3592161 1865168 1865168 defendant Brandon Robert husbandman 587691 587691 Brandon, Robert, of Reculver, husbandman 0
3597337 1866785 1866785 defendant Brandon Robert   587691 587691 Brandon, Robert, of Reculver, mason 0
3766869 1947303 1947303 defendant Quested Richard chaplain 587691 587691 Quested, Richard, of Reculver, chaplain 0
4281603 2123472 2123472 defendant Bartlett Richard laborer 587691 587691 Bartlett, Richard, of Reculver, laborer 1
4462319 2188914 2188914 defendant Symme John   587691 587691 Symme, John, of Reculver 0
4486385 2196453 2196453 defendant Lacy Henry   587691 587691 Lacy, Henry, of Reculver 0
4557224 2218193 2218193 defendant Mylde John   587691 587691 Mylde, John, of Reculver 0
4609793 2234156 2234156 defendant Estre Robert   587691 587691 Estre, Robert, of Reculver 1
4625616 2238971 2238971 defendant Hardys John   587691 587691 Hardys, John, of Reculver 0
4625618 2238972 2238972 defendant Hardys John   587691 587691 Hardys, John, of Reculver 0
4638079 2242671 2242671 defendant Estre Robert   587691 587691 Estre, Robert, of Reculver 0
4647575 2245348 2245348 defendant Wendyston William   587691 587691 Wendyston, William, of Reculver, vicar 2
4702571 2266216 2266216 defendant Paunplot John husbandman 587691 587691 Paunplot, John, of Reculver, husbandman 2
4702572 2266216 2266216 defendant Haycchard William husbandman 587691 587691 Haycchard, William, of Reculver, husbandman 3
4808971 2298980 2298980 defendant Gybbe Simon laborer 587691 587691 Gybbe, Simon, of Reculver, laborer 0
4848944 2311136 2311136 defendant Symond Thomas laborer 587691 587691 Symond, Thomas, of Reculver, laborer 0
4911945 2330243 2330243 defendant Stephen John yeoman 587691 587691 Stephen, John, of Reculver, yeoman 0
4915728 2331419 2331419 defendant Stephen John yeoman 587691 587691 Stephen, John, of Reculver, yeoman 0
4916243 2331585 2331585 defendant Steven John husbandman 587691 587691 Steven, John, of Reculver, husbandman 2
4956899 2344022 2344022 defendant Stephen John   587691 587691 Stephen, John, of Reculver, bailiff 1
4960012 2344959 2344959 defendant Charles Stephen husbandman 587691 587691 Charles, Stephen, of Reculver, husbandman 0
4962466 2345678 2345678 defendant Craft Richard husbandman 587691 587691 Craft, Richard, of Reculver, husbandman 0
4962468 2345678 2345678 defendant Gate Joan widow 587691 587691 Gate, Joan, of Reculver, widow 2
4965369 2346565 2346565 defendant Brook James husbandman 587691 587691 Brook, James, of Reculver, husbandman 0
4965370 2346565 2346565 defendant Lytilwode Thomas, junior husbandman 587691 587691 Lytilwode, Thomas, junior, of Reculver, husbandman 1
4965371 2346565 2346565 defendant Ayleward Thomas husbandman 587691 587691 Ayleward, Thomas, of Reculver, husbandman 2
4965372 2346565 2346565 defendant Pampelet John husbandman 587691 587691 Pampelet, John, of Reculver, husbandman 3
4965373 2346565 2346565 defendant Cobbe John husbandman 587691 587691 Cobbe, John, of Reculver, husbandman 4
4965375 2346565 2346565 defendant Badcok Henry husbandman 587691 587691 Badcok, Henry, of Reculver, husbandman 6
4987832 2353326 2353326 defendant Honymowth James husbandman 587691 587691 Honymowth, James, of Reculver, husbandman 0
5007800 2359175 2359175 defendant Aleyn John husbandman 587691 587691 Aleyn, John, of Reculver, husbandman 1
5007801 2359175 2359175 defendant Hachard John husbandman 587691 587691 Hachard, John, of Reculver, husbandman 2
5098692 2386048 2386048 defendant Spere William clerk 587691 587691 Spere, William, of Reculver, clerk 0
5098693 2386048 2386048 defendant Taillour Nicholas tailor 587691 587691 Taillour, Nicholas, of Reculver, tailor 1
5098694 2386048 2386048 defendant Mey William husbandman 587691 587691 Mey, William, of Reculver, husbandman 2
5098695 2386048 2386048 defendant German Thomas husbandman 587691 587691 German, Thomas, of Reculver, husbandman 3
5098696 2386048 2386048 defendant Aleyn John husbandman 587691 587691 Aleyn, John, of Reculver, husbandman 4
5223880 2422670 2422670 defendant Walwere Christopher husbandman 587691 587691 Walwere, Christopher, of Reculver, husbandman 0
5223881 2422670 2422670 defendant Jermyn Henry husbandman 587691 587691 Jermyn, Henry, of Reculver, husbandman 1
5223882 2422670 2422670 defendant May James husbandman 587691 587691 May, James, of Reculver, husbandman 2
5223883 2422670 2422670 defendant Roke Richard baker 587691 587691 Roke, Richard, of Reculver, baker 3
5271103 2436641 2436641 defendant Cobbe Thomas husbandman 587691 587691 Cobbe, Thomas, of Reculver, husbandman 1
5280877 2439480 2439480 defendant Cobbe Thomas husbandman 587691 587691 Cobbe, Thomas, of Reculver, husbandman 1
5299753 2444897 2444897 defendant Germyn Lawrence laborer 587691 587691 Germyn, Lawrence, of Reculver, laborer 1
5335572 2455711 2455711 defendant Reve John husbandman 587691 587691 Reve, John, of Reculver, husbandman 0
5335573 2455711 2455711 defendant Knoller John husbandman 587691 587691 Knoller, John, of Reculver, husbandman 1
5338722 2456681 2456681 plaintiff Lolles Robert   587691 587691 Lolles, Robert, of Reculver 0
5341011 2457389 2457389 defendant Cotes Thomas husbandman 587691 587691 Cotes, Thomas, of Reculver, husbandman 0
5360874 2463430 2463430 defendant Fantyng Henry tanner 587691 587691 Fantyng, Henry, of Reculver, tanner 0
5362150 2463828 2463828 defendant Bonaunter or Bovaunter John chaplain 587691 587691 Bonaunter or Bovaunter, John, of Reculver, chaplain 0
5386195 2471116 2471116 defendant Roke Richard husbandman 587691 587691 Roke, Richard, of Reculver, husbandman 0
5386196 2471116 2471116 defendant Cobbe Henry husbandman 587691 587691 Cobbe, Henry, of Reculver, husbandman 1
5424575 2482324 2482324 defendant Jacob William husbandman 587691 587691 Jacob, William, of Reculver, husbandman 0
5424577 2482324 2482324 defendant Broke Richard husbandman 587691 587691 Broke, Richard, of Reculver, husbandman 2
5443362 2487932 2487932 defendant Jacob William husbandman 587691 587691 Jacob, William, of Reculver, husbandman 0
5443363 2487932 2487932 defendant Broke Richard husbandman 587691 587691 Broke, Richard, of Reculver, husbandman 1
5454146 2491136 2491136 defendant Jacob William husbandman 587691 587691 Jacob, William, of Reculver, husbandman 0
5454147 2491136 2491136 defendant Broke William husbandman 587691 587691 Broke, William, of Reculver, husbandman 1
5495814 2503643 2503643 defendant Newe Thomas husbandman 587691 587691 Newe, Thomas, of Reculver, husbandman 2
5498321 2504458 2504458 defendant Pamplet John husbandman 587691 587691 Pamplet, John, of Reculver, husbandman 0
5498322 2504458 2504458 defendant Pamplet Robert laborer 587691 587691 Pamplet, Robert, of Reculver, laborer 1
5511237 2508358 2508358 defendant May James husbandman 587691 587691 May, James, of Reculver, husbandman 1
5635142 2554970 2554970 defendant Lowe Nicholas husbandman 587691 587691 Lowe, Nicholas, of Reculver, husbandman 2

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