names

51 rows where place_id = 592861

✎ 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
3609191 1870536 1870536 plaintiff Wodcroft Robert   592861 592861 Wodcroft, Robert, of Hylderston 0
3650675 1910576 1910576 defendant Yerham John carpenter 592861 592861 Yerham, John, of Hylderston, carpenter 1
3681142 1920184 1920184 defendant Wollaston William husbandman 592861 592861 Wollaston, William, of Hylderston, husbandman 0
3681143 1920184 1920184 defendant Amery John husbandman 592861 592861 Amery, John, of Hylderston, husbandman 1
3684434 1921262 1921262 defendant Hunt Nicholas yeoman 592861 592861 Hunt, Nicholas, of Hylderston, yeoman 0
3748999 1941618 1941618 defendant Yarham John carpenter 592861 592861 Yarham, John, of Hylderston, carpenter 1
3794880 1956266 1956266 defendant Kenryoke Thomas husbandman 592861 592861 Kenryoke, Thomas, of Hylderston, husbandman 2
3797269 1957031 1957031 defendant Pulton John husbandman 592861 592861 Pulton, John, of Hylderston, husbandman 1
3804486 1959343 1959343 defendant Pulton James yeoman 592861 592861 Pulton, James, of Hylderston, yeoman 1
3804487 1959343 1959343 defendant Pulton John yeoman 592861 592861 Pulton, John, of Hylderston, yeoman 2
3874404 1981666 1981666 defendant Kyng John butcher 592861 592861 Kyng, John, of of Hylderston, butcher 0
3890619 1987127 1987127 defendant Olley Nicholas husbandman 592861 592861 Olley, Nicholas, of Hylderston, husbandman 0
3890620 1987127 1987127 defendant Olley Henry laborer 592861 592861 Olley, Henry, of Hylderston, laborer 1
3893090 1987935 1987935 defendant Olley Nicholas husbandman 592861 592861 Olley, Nicholas, of Hylderston, husbandman 1
3893091 1987935 1987935 defendant Olley Henry laborer 592861 592861 Olley, Henry, of Hylderston, laborer 2
3893092 1987935 1987935 defendant Yarham Nicholas carpenter 592861 592861 Yarham, Nicholas, of Hylderston, carpenter 3
3944751 2005265 2005265 defendant Smyth John laborer 592861 592861 Smyth, John, of Hylderston, laborer 4
3944757 2005266 2005266 defendant Smyth John laborer 592861 592861 Smyth, John, of Hylderston, laborer 4
3957935 2009838 2009838 defendant Hunt Alice widow 592861 592861 Hunt, Alice, of Hylderston, widow 0
3963482 2011833 2011833 defendant Waller John husbandman 592861 592861 Waller, John, of Hylderston, husbandman 0
3980499 2017793 2017793 defendant Waller John yeoman 592861 592861 Waller, John, of Hylderston, yeoman 1
3981920 2018293 2018293 defendant Yarham Richard yeoman 592861 592861 Yarham, Richard, of Hylderston, yeoman 0
3982092 2018355 2018355 defendant Spargey John carpenter 592861 592861 Spargey, John, of Hylderston, carpenter 0
3985378 2019530 2019530 plaintiff Rockbye Erasmus   592861 592861 Rockbye, Erasmus, of Hylderston 1
3987539 2020294 2020294 defendant Akers James husbandman 592861 592861 Akers, James, of Hylderston, husbandman 0
4015049 2030076 2030076 defendant Yarham Richard yeoman 592861 592861 Yarham, Richard, of Hylderston, yeoman 0
4027128 2034348 2034348 defendant Pulton Humphrey blacksmith 592861 592861 Pulton, Humphrey, of Hylderston, blacksmith 4
4076676 2051944 2051944 defendant Yarham Richard yeoman 592861 592861 Yarham, Richard, of Hylderston, yeoman 2
4150750 2078402 2078402 defendant Kynge Thomas tailor 592861 592861 Kynge, Thomas, of Hylderston, tailor 2
4150754 2078403 2078403 defendant Watson Nicholas yeoman 592861 592861 Watson, Nicholas, of Hylderston, yeoman 2
4328374 2139806 2139806 defendant Gilberd James yeoman 592861 592861 Gilberd, James, of Hylderston, yeoman 2
5237369 2426514 2426514 defendant Westwode James shoemaker 592861 592861 Westwode, James, of Hylderston, shoemaker 2
5271032 2436622 2436622 defendant Yaram John husbandman 592861 592861 Yaram, John, of Hylderston, husbandman 0
5271033 2436622 2436622 defendant Acre John husbandman 592861 592861 Acre, John, of Hylderston, husbandman 1
5281454 2439645 2439645 defendant Robardes John yeoman 592861 592861 Robardes, John, of Hylderston, yeoman 3
5284104 2440370 2440370 defendant Yaram John husbandman 592861 592861 Yaram, John, of Hylderston, husbandman 0
5284105 2440370 2440370 defendant Acre Johm husbandman 592861 592861 Acre, Johm, of Hylderston, husbandman 1
5313826 2449164 2449164 defendant Estweyght Ralph husbandman 592861 592861 Estweyght, Ralph, of Hylderston, husbandman 0
5313835 2449165 2449165 defendant Yarham John husbandman 592861 592861 Yarham, John, of Hylderston, husbandman 2
5328450 2453583 2453583 defendant Bate James husbandman 592861 592861 Bate, James, of Hylderston, husbandman 5
5328451 2453583 2453583 defendant Bate Robert yeoman 592861 592861 Bate, Robert, of Hylderston, yeoman 6
5345516 2458770 2458770 defendant Yareham John husbandman 592861 592861 Yareham, John, of Hylderston, husbandman 0
5357964 2462555 2462555 defendant Southwode John yeoman 592861 592861 Southwode, John, of Hylderston, yeoman 4
5363743 2464312 2464312 defendant Bate Robert laborer 592861 592861 Bate, Robert, of Hylderston, laborer 5
5384749 2470723 2470723 defendant Wreth Henry clerk 592861 592861 Wreth, Henry, of Hylderston, clerk 3
5394912 2473617 2473617 defendant _rint Geoffrey husbandman 592861 592861 _rint, Geoffrey, of Hylderston, husbandman 0
5488538 2501458 2501458 defendant Yareham John husbandman 592861 592861 Yareham, John, of Hylderston, husbandman 1
5505049 2506489 2506489 defendant Fuller William husbandman 592861 592861 Fuller, William, of Hylderston, husbandman 1
5572755 2526579 2526579 defendant Stacy Joan widow 592861 592861 Stacy, Joan, of Hylderston, widow 4
5592676 2532701 2532701 defendant Sheryngham William butcher 592861 592861 Sheryngham, William, of Hylderston, butcher 3
5595411 2533514 2533514 defendant Yaram John carpenter 592861 592861 Yaram, John, of Hylderston, carpenter 4

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