names

39 rows where place_id = 591729

✎ 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
3605367 1869346 1869346 defendant Sturmy John gent 591729 591729 Sturmy, John, of Knoll, gent 0
3671610 1917105 1917105 defendant Brandon Nicholas yeoman 591729 591729 Brandon, Nicholas, of Knoll, yeoman 0
3784570 1952962 1952962 defendant Yardley John yeoman 591729 591729 Yardley, John, of Knoll, yeoman 1
3824687 1965596 1965596 plaintiff White John   591729 591729 White, John, of Knoll 0
3858449 1976301 1976301 defendant Carter Richard husbandman 591729 591729 Carter, Richard, of Knoll, husbandman 3
3867980 1979525 1979525 defendant Trussell Thomas gent 591729 591729 Trussell, Thomas, of Knoll, gent 0
3877951 1982871 1982871 defendant Egramount William cordwainer 591729 591729 Egramount, William, of Knoll, cordwainer 0
3959783 2010514 2010514 defendant Williams John yeoman 591729 591729 Williams, John, of Knoll, yeoman 1
4071025 2049937 2049937 defendant Richard Denis grocer 591729 591729 Richard, Denis, of Knoll, grocer 0
4157353 2080638 2080638 defendant London John joiner 591729 591729 London, John, of Knoll, joiner 2
4174374 2086502 2086502 defendant Tyrer Christopher mercer 591729 591729 Tyrer, Christopher, of Knoll, mercer 0
4187485 2091121 2091121 defendant Horborne Joan widow 591729 591729 Horborne, Joan, of Knoll, widow 2
4457678 2187410 2187410 defendant Fouke Robert   591729 591729 Fouke, Robert, of Knoll 1
4637669 2242564 2242564 defendant Longedon John   591729 591729 Longedon, John, of Knoll 5
4675209 2257859 2257859 defendant Sawer John husbandman 591729 591729 Sawer, John, of Knoll, husbandman 1
4727385 2273813 2273813 defendant Newerk John spicer 591729 591729 Newerk, John, of Knoll, spicer 3
4826571 2304346 2304346 defendant Bocher John butcher 591729 591729 Bocher, John, of Knoll, butcher 2
4849038 2311170 2311170 defendant Dodde Hugh gent 591729 591729 Dodde, Hugh, of Knoll, gent 0
4885885 2322454 2322454 defendant Aveney Thomas yeoman 591729 591729 Aveney, Thomas, of Knoll, yeoman 1
5006933 2358927 2358927 defendant Kyxley Richard husbandman 591729 591729 Kyxley, Richard, of Knoll, husbandman 2
5006934 2358927 2358927 defendant Sougod Richard butcher 591729 591729 Sougod, Richard, of Knoll, butcher 3
5006935 2358927 2358927 defendant Solyhull William husbandman 591729 591729 Solyhull, William, of Knoll, husbandman 4
5033455 2366666 2366666 plaintiff Smyth Richard   591729 591729 Smyth, Richard, of Knoll 0
5074257 2378790 2378790 defendant Broun John yeoman 591729 591729 Broun, John, of Knoll, yeoman 0
5160990 2404318 2404318 defendant Sturmy William gent 591729 591729 Sturmy, William, of Knoll, gent 0
5218760 2421213 2421213 defendant Smyth Richard   591729 591729 Smyth, Richard, of Knoll, franklin 1
5225833 2423228 2423228 defendant Hoper John, senior husbandman 591729 591729 Hoper, John, senior, of Knoll, husbandman 1
5230206 2424454 2424454 defendant Cardemaker Richard pardoner 591729 591729 Cardemaker, Richard, of Knoll, pardoner 0
5230207 2424454 2424454 defendant Don Geoffrey husbandman 591729 591729 Don, Geoffrey, of Knoll, husbandman 1
5230208 2424454 2424454 defendant Don Edward husbandman 591729 591729 Don, Edward, of Knoll, husbandman 2
5230754 2424603 2424603 defendant Parker William yeoman 591729 591729 Parker, William, of Knoll, yeoman 0
5295686 2443733 2443733 defendant Hoggys John yeoman 591729 591729 Hoggys, John, of Knoll, yeoman 2
5295690 2443734 2443734 defendant Hoggys John yeoman 591729 591729 Hoggys, John, of Knoll, yeoman 2
5309143 2447773 2447773 defendant Stormy William gent 591729 591729 Stormy, William, of Knoll, gent 0
5311768 2448545 2448545 defendant Sturmy William gent 591729 591729 Sturmy, William, of Knoll, gent 0
5337807 2456385 2456385 defendant Smyth William smith 591729 591729 Smyth, William, of Knoll, smith 0
5498949 2504621 2504621 defendant Ayleston Henry husbandman 591729 591729 Ayleston, Henry, of Knoll, husbandman 0
5543761 2518155 2518155 defendant Fyssher John baker 591729 591729 Fyssher, John, of Knoll, baker 0
5543762 2518155 2518155 defendant Basset John butcher 591729 591729 Basset, John, of Knoll, butcher 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);