names

61 rows where place_id = 615651

✎ 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
3710021 1929443 1929443 defendant Russell John husbandman 615651 615651 Russell, John, of Taverham, husbandman 0
3710301 1929538 1929538 defendant Likberd William tailor 615651 615651 Likberd, William, of Taverham, tailor 1
3781739 1952036 1952036 defendant Page John laborer 615651 615651 Page, John, of Taverham, laborer 0
3781740 1952036 1952036 defendant Love Robert chaplain 615651 615651 Love, Robert, of Taverham, chaplain 1
3802477 1958673 1958673 defendant Stokys Robert gent 615651 615651 Stokys, Robert, of Taverham, gent 4
3803725 1959080 1959080 plaintiff Rogers Stephen husbandman 615651 615651 Rogers, Stephen, of Taverham, husbandman 0
3810278 1961104 1961104 defendant Myklyng Thomas laborer 615651 615651 Myklyng, Thomas, of Taverham, laborer 3
3815076 1962637 1962637 defendant Russell John yeoman 615651 615651 Russell, John, of Taverham, yeoman 1
3836571 1969341 1969341 plaintiff Rogers Stephen   615651 615651 Rogers, Stephen, of Taverham 0
3836573 1969342 1969342 plaintiff Rogers Stephen   615651 615651 Rogers, Stephen, of Taverham 0
3838911 1970095 1970095 defendant Shengilwood Richard yeoman 615651 615651 Shengilwood, Richard, of Taverham, yeoman 2
3873526 1981362 1981362 defendant Lykberd William husbandman 615651 615651 Lykberd, William, of Taverham, husbandman 0
3879728 1983475 1983475 defendant Orlowe William husbandman 615651 615651 Orlowe, William, of taverham, husbandman 0
3887433 1986061 1986061 defendant Just Thomas husbandman 615651 615651 Just, Thomas, of Taverham, husbandman 2
4159173 2081274 2081274 defendant Ward Richard husbandman 615651 615651 Ward, Richard, of Taverham, husbandman 3
4182936 2089511 2089511 defendant Warde Richard husbandman 615651 615651 Warde, Richard, of Taverham, husbandman 3
4229480 2105796 2105796 defendant Osborn John yeoman 615651 615651 Osborn, John, of Taverham, yeoman 0
4284459 2124491 2124491 defendant Makyns Nicholas husbandman 615651 615651 Makyns, Nicholas, of Taverham, husbandman 1
4395918 2163213 2163213 defendant Grave Thomas husbandman 615651 615651 Grave, Thomas, of Taverham, husbandman 2
4396370 2163360 2163360 defendant Drake Henry yeoman 615651 615651 Drake, Henry, of Taverham, yeoman 0
4703250 2266395 2266395 defendant Wryght Henry laborer 615651 615651 Wryght, Henry, of Taverham, laborer 0
4767045 2285682 2285682 defendant Deye Thomas yeoman 615651 615651 Deye, Thomas, of Taverham, yeoman 2
4768803 2286221 2286221 defendant Deye Thomas yeoman 615651 615651 Deye, Thomas, of Taverham, yeoman 0
4850311 2311554 2311554 defendant Deye Thomas yeoman 615651 615651 Deye, Thomas, of Taverham, yeoman 1
4874126 2318848 2318848 defendant Wryght Henry husbandman 615651 615651 Wryght, Henry, of Taverham, husbandman 5
4969543 2347840 2347840 defendant Walby Walter husbandman 615651 615651 Walby, Walter, of Taverham, husbandman 0
4970535 2348131 2348131 defendant Baron John laborer 615651 615651 Baron, John, of Taverham, laborer 3
4987429 2353195 2353195 defendant Deye Simon yeoman 615651 615651 Deye, Simon, of Taverham, yeoman 2
4987430 2353195 2353195 defendant Ely William husbandman 615651 615651 Ely, William, of Taverham, husbandman 3
4993665 2354980 2354980 plaintiff Ely John   615651 615651 Ely, John, of Taverham 0
5002591 2357669 2357669 defendant Davy John clerk 615651 615651 Davy, John, of Taverham, clerk 0
5003038 2357794 2357794 defendant Stokes John yeoman 615651 615651 Stokes, John, of Taverham, yeoman 0
5021027 2363047 2363047 defendant Dey Thomas (legal representative) 615651 615651 Dey, Thomas, of Taverham, executrix of 4
5021028 2363047 2363047 defendant Dey Joan widow 615651 615651 Dey, Joan, of Taverham, widow 5
5035165 2367149 2367149 defendant Broun Thomas husbandman 615651 615651 Broun, Thomas, of Taverham, husbandman 0
5035166 2367149 2367149 defendant Ely William   615651 615651 Ely, William, of Taverham, shepherd 1
5044400 2369956 2369956 defendant Warrewyk William carpenter 615651 615651 Warrewyk, William, of Taverham, carpenter 2
5072430 2378243 2378243 defendant Snape Henry husbandman 615651 615651 Snape, Henry, of Taverham, husbandman 2
5072431 2378243 2378243 defendant Ely John (legal representative) 615651 615651 Ely, John, of Taverham, executor of 3
5072432 2378243 2378243 defendant Chapman William husbandman 615651 615651 Chapman, William, of Taverham, husbandman 4
5081284 2380913 2380913 defendant Ely William yeoman 615651 615651 Ely, William, of Taverham, yeoman 1
5123789 2393416 2393416 defendant Broun John   615651 615651 Broun, John, of Taverham, shepherd 1
5148383 2400664 2400664 defendant Ely William yeoman 615651 615651 Ely, William, of Taverham, yeoman 1
5148530 2400696 2400696 defendant Deye Simon yeoman 615651 615651 Deye, Simon, of Taverham, yeoman 0
5167671 2406269 2406269 defendant Ely William yeoman 615651 615651 Ely, William, of Taverham, yeoman 1
5167786 2406291 2406291 defendant Dey Simon yeoman 615651 615651 Dey, Simon, of Taverham, yeoman 0
5197884 2415118 2415118 defendant Ely John (legal representative) 615651 615651 Ely, John, of Taverham, executors of 0
5197885 2415118 2415118 defendant Chapman William husbandman 615651 615651 (Chapman, William, of Taverham, husbandman 1
5210320 2418746 2418746 defendant Ely John (legal representative) 615651 615651 Ely, John, of Taverham, executors of 0
5210321 2418746 2418746 defendant Chapman William husbandman 615651 615651 (Chapman, William, of Taverham, husbandman 1
5242625 2428048 2428048 defendant Dey Simon yeoman 615651 615651 Dey, Simon, of Taverham, yeoman 0
5249174 2429880 2429880 defendant Randolff William husbandman 615651 615651 Randolff, William, of Taverham, husbandman 0
5249175 2429880 2429880 defendant Broun Robert   615651 615651 Broun, Robert, of Taverham 1
5386842 2471303 2471303 defendant Sadeler Thomas dyer 615651 615651 Sadeler, Thomas, of Taverham, dyer 0
5399282 2474869 2474869 defendant Sadeler Thomas dyer of fabrics 615651 615651 Sadeler, Thomas, of Taverham, dyer of fabrics 0
5412289 2478623 2478623 defendant Sadler Thomas dyer 615651 615651 Sadler, Thomas, of Taverham, dyer 0
5529839 2513842 2513842 defendant Stokes Nicholas, senior yeoman 615651 615651 Stokes, Nicholas, senior, of Taverham, yeoman 0
5536317 2515847 2515847 defendant Stokys Nicholoas yeoman 615651 615651 Stokys, Nicholoas, of Taverham, yeoman 1
5557966 2522283 2522283 defendant Botte John thatcher 615651 615651 Botte, John, of Taverham, thatcher 2
5588416 2531382 2531382 defendant Salyng William   615651 615651 Salyng, William, of Taverham 0
5602222 2535592 2535592 defendant Feryar Richard husbandman 615651 615651 Feryar, Richard, of Taverham, husbandman 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);