names

36 rows where place_id = 591218

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3603744 1868842 1868842 defendant Dene William chapman 591218 591218 Dene, William, of Wallyngford, Berks, chapman 2
3694397 1924452 1924452 defendant Osbaston Lambert beer brewer 591218 591218 Osbaston, Lambert, of Wallyngford, Berks, beer brewer 2
3703683 1927433 1927433 defendant Gay Thomas   591218 591218 Gay, Thomas, of Wallyngford, Berks, tallow chandler 0
3744600 1940206 1940206 defendant Osbaston Lambart brewer 591218 591218 Osbaston, Lambart, of Wallyngford, Berks, brewer 4
3886926 1985890 1985890 plaintiff Cheyney John mercer 591218 591218 Cheyney, John, of Wallyngford, Berks, mercer 0
3918647 1996563 1996563 plaintiff Huntley Henry gent 591218 591218 Huntley, Henry, of Wallyngford, Berks, gent 0
3951577 2007608 2007608 defendant Dobbynson Robert glover 591218 591218 Dobbynson, Robert, of Wallyngford, Berks, glover 0
3985592 2019610 2019610 defendant Payne Nicholas clerk of Queen's household 591218 591218 Payne, Nicholas, of Wallyngford, Berks, gent, clerk of Queen's household 0
4002641 2025715 2025715 defendant Pollyngton Ralph clothier 591218 591218 Pollyngton, Ralph, of Wallyngford, Berks, clothier 0
4019866 2031838 2031838 plaintiff West Thomas yeoman 591218 591218 West, Thomas, of Wallyngford, Berks, yeoman 0
4019870 2031839 2031839 plaintiff West Thomas yeoman 591218 591218 West, Thomas, of Wallyngford, Berks, yeoman 0
4061390 2046478 2046478 defendant Payne John gent 591218 591218 Payne, John, of Wallyngford, Berks, gent 0
4140195 2074737 2074737 plaintiff Wasse Mark   591218 591218 Wasse, Mark, of Wallyngford, Berks, wheelwright 0
4141284 2075111 2075111 defendant Waterer Henry chapman 591218 591218 Waterer, Henry, of Wallyngford, Berks, chapman 0
4176262 2087174 2087174 defendant Waters Henry chapman 591218 591218 Waters, Henry, of Wallyngford, Berks, chapman 3
4270098 2119582 2119582 defendant Payne Griffin gent 591218 591218 Payne, Griffin, of Wallyngford, Berks, gent 0
4728166 2274057 2274057 defendant Brewode John fishmonger 591218 591218 Brewode, John, of Wallyngford, Berks, fishmonger 0
4978811 2350613 2350613 defendant Orill John, senior   591218 591218 Orill, John, senior, of Wallyngford, Berks, servant 0
4998867 2356545 2356545 defendant Kellyngton Robert clerk 591218 591218 Kellyngton, Robert, of Wallyngford, Berks, clerk 0
5008529 2359391 2359391 defendant Flexmere John clerk 591218 591218 Flexmere, John, of Wallyngford, Berks, clerk 1
5193374 2413789 2413789 defendant Gilbert John chapman 591218 591218 Gilbert, John, of Wallyngford, Berks, chapman 3
5215536 2420267 2420267 defendant Glaswas William yeoman 591218 591218 Glaswas, William, of Wallyngford, Berks, yeoman 3
5215541 2420268 2420268 defendant Glaswas William yeoman 591218 591218 Glaswas, William, of Wallyngford, Berks, yeoman 3
5222075 2422158 2422158 defendant Boton John hosteler 591218 591218 Boton, John, of Wallyngford, Berks, hosteler 2
5227563 2423684 2423684 defendant Boton John yeoman 591218 591218 Boton, John, of Wallyngford, Berks, yeoman 3
5227568 2423685 2423685 defendant Boton John yeoman 591218 591218 Boton, John, of Wallyngford, Berks, yeoman 3
5259679 2433150 2433150 defendant Bronde Robert chapman 591218 591218 Bronde, Robert, of Wallyngford, Berks, chapman 0
5267873 2435717 2435717 defendant Collys Thomas chapman 591218 591218 Collys, Thomas, of Wallyngford, Berks, chapman 0
5279813 2439178 2439178 defendant Castell Richard   591218 591218 Castell, Richard, of Wallyngford, Berks 4
5279819 2439179 2439179 defendant Castell Richard chapman 591218 591218 Castell, Richard, of Wallyngford, Berks, chapman 4
5292965 2442933 2442933 defendant Bronde Robert chapman 591218 591218 Bronde, Robert, of Wallyngford, Berks, chapman 2
5298117 2444463 2444463 defendant Playstowe Thomas fishmonger 591218 591218 Playstowe, Thomas, of Wallyngford, Berks, fishmonger 2
5362247 2463854 2463854 defendant Brystowe John husbandman 591218 591218 Brystowe, John, of Wallyngford, Berks, husbandman 2
5490438 2502035 2502035 defendant Aden John chapman 591218 591218 Aden, John, of Wallyngford, Berks, chapman 0
5557517 2522153 2522153 defendant Rede William   591218 591218 Rede, William, of Wallyngford, Berks, knight 0
5605229 2536512 2536512 defendant Wytbourn William miller 591218 591218 Wytbourn, William, of Wallyngford, Berks, miller 0

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