names

32 rows where place_id = 657845

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3941278 2004089 2004089 plaintiff Torner William (legal representative) 657845 657845 Torner, William, of West Wynch, executors of 0
3945993 2005675 2005675 defendant Harpley Thomas husbandman 657845 657845 Harpley, Thomas, of West Wynch, husbandman 0
3956468 2009326 2009326 defendant Johnson John   657845 657845 Johnson, John, of West Wynch, shepherd 1
3965400 2012511 2012511 plaintiff Bastard Francis gent 657845 657845 Bastard, Francis, of West Wynch, gent 0
3981632 2018188 2018188 defendant Lucke William yeoman 657845 657845 Lucke, William, of West Wynch, yeoman 0
3999853 2024713 2024713 defendant Cropper Thomas gent 657845 657845 Cropper, Thomas, of West Wynch, gent 0
4083936 2054531 2054531 defendant Bastard Francis gent 657845 657845 Bastard, Francis, of West Wynch, gent 0
4097503 2059433 2059433 defendant Jenyson William tanner 657845 657845 Jenyson, William, of West Wynch, or of Reyneham, tanner 1
4214498 2100581 2100581 defendant Gybson William yeoman 657845 657845 Gybson, William, of West Wynch, yeoman 0
4248670 2112541 2112541 defendant Carey Edward husbandman 657845 657845 Carey, Edward, of West Wynch, husbandman 0
4394667 2162804 2162804 defendant Lamberd John husbandman 657845 657845 Lamberd, John, of West Wynch, husbandman 2
4395969 2163227 2163227 defendant Barvyll Henry yeoman 657845 657845 Barvyll, Henry, of West Wynch, yeoman 0
4397077 2163591 2163591 defendant Pell Valentine   657845 657845 Pell, Valentine, of West Wynch gent 0
4570565 2222368 2222368 defendant Deye Thomas   657845 657845 Deye, Thomas, of West Wynch 0
5019263 2362524 2362524 defendant Taverner John laborer 657845 657845 Taverner, John, of West Wynch, laborer 10
5036264 2367457 2367457 defendant Taverner John laborer 657845 657845 Taverner, John, of West Wynch, laborer 7
5080450 2380642 2380642 defendant Necholas John, junior husbandman 657845 657845 Necholas, John, junior, of West Wynch, husbandman 1
5080457 2380643 2380643 defendant Necholas John husbandman 657845 657845 Necholas, John, of West Wynch, husbandman 1
5115965 2391098 2391098 defendant Ivys Richard husbanman 657845 657845 Ivys, Richard, of West Wynch, husbanman 0
5147545 2400423 2400423 defendant Shotesham Thomas husbandman 657845 657845 Shotesham, Thomas, of West Wynch, husbandman 3
5155075 2402635 2402635 defendant Aufyn Richard clerk & parson 657845 657845 Aufyn, Richard, of West Wynch, clerk & parson 4
5157852 2403422 2403422 defendant Nicolasson John husbandman 657845 657845 Nicolasson, John, of West Wynch, husbandman 2
5167197 2406139 2406139 defendant Shotesham Thomas husbandman 657845 657845 Shotesham, Thomas, of West Wynch, husbandman 3
5171860 2407484 2407484 defendant Aufyn Richard clerk & master 657845 657845 Aufyn, Richard, of West Wynch, parson, clerk & master 4
5173605 2407981 2407981 defendant Nicolasson John husbandman 657845 657845 Nicolasson, John, of West Wynch, husbandman 2
5207034 2417793 2417793 defendant Ausyn Richard clerk & master 657845 657845 Ausyn, Richard, of West Wynch, clerk & master 4
5214941 2420091 2420091 defendant Cobbe Thomas yeoman 657845 657845 Cobbe, Thomas, of West Wynch, yeoman 1
5218817 2421229 2421229 defendant Mannyng William reeder 657845 657845 Mannyng, William, of West Wynch, reeder 1
5218818 2421229 2421229 defendant Nicholas John yeoman 657845 657845 Nicholas, John, of West Wynch, yeoman 2
5327690 2453349 2453349 plaintiff Nicholas John   657845 657845 Nicholas, John, of West Wynch 1
5486694 2500921 2500921 defendant Whyght Robert yeoman 657845 657845 Whyght, Robert, of West Wynch, yeoman 0
5630412 2553522 2553522 defendant Scrowth Avelina widow 657845 657845 Scrowth, Avelina, of West Wynch, widow 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);