names

46 rows where place_id = 618373

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3724251 1933871 1933871 defendant Benforth Thomas yeoman 618373 618373 Benforth, Thomas, of Tanworth, yeoman 1
3724252 1933871 1933871 defendant Heth Baldwin gent 618373 618373 Heth, Baldwin, of Tanworth, gent 2
3724977 1934099 1934099 defendant Whateley Richard husbandman 618373 618373 Whateley, Richard, of Tanworth, husbandman 0
3724979 1934100 1934100 defendant Whateley Richard husbandman 618373 618373 Whateley, Richard, of Tanworth, husbandman 0
3843544 1971518 1971518 defendant Edys William yeoman 618373 618373 Edys, William, of Tanworth, yeoman 1
3904868 1991891 1991891 defendant Edwardes Richard yeoman 618373 618373 Edwardes, Richard, of Tanworth, yeoman 0
3904869 1991891 1991891 defendant Tyrry Nicholas yeoman 618373 618373 Tyrry, Nicholas, of Tanworth, yeoman 1
3911862 1994292 1994292 defendant Waren Thomas yeoman 618373 618373 Waren, Thomas, of Tanworth, yeoman 0
3924792 1998609 1998609 defendant Pyrry Nicholas husbandman 618373 618373 Pyrry, Nicholas, of Tanworth, husbandman 0
3934857 2001960 2001960 defendant Edwardes Richard husbandman 618373 618373 Edwardes, Richard, of Tanworth, husbandman 0
3996852 2023642 2023642 defendant Hafelock Richard laborer 618373 618373 Hafelock, Richard, of Tanworth, laborer 0
4073864 2050943 2050943 defendant Wescott Richard husbandman 618373 618373 Wescott, Richard, of Tanworth, husbandman 1
4218307 2101900 2101900 defendant Boswell alias Maxefeilde John, junior yeoman 618373 618373 Boswell alias Maxefeilde, John, junior, of Tanworth, yeoman 2
4221408 2102985 2102985 defendant Smyth William yeoman 618373 618373 Smyth, William, of Tanworth, yeoman 0
4221409 2102985 2102985 defendant Stawly Thomas yeoman 618373 618373 Stawly, Thomas, of Tanworth, yeoman 1
4221410 2102985 2102985 defendant Medcock Philip yeoman 618373 618373 Medcock, Philip, of Tanworth, yeoman 2
4221411 2102985 2102985 defendant Edward William yeoman 618373 618373 Edward, William, of Tanworth, yeoman 3
4275355 2121315 2121315 defendant Kynge William gent 618373 618373 Kynge, William, of Tanworth, gent 2
4283166 2124011 2124011 defendant Wescote Richard yeoman 618373 618373 Wescote, Richard, of Tanworth, yeoman 0
4294248 2128019 2128019 defendant Westcote Richard yeoman 618373 618373 Westcote, Richard, of Tanworth, yeoman 0
4295056 2128313 2128313 defendant Greene Thomas yeoman 618373 618373 Greene, Thomas, of Tanworth, yeoman 0
4295057 2128313 2128313 defendant Westcote Richard, senior yeoman 618373 618373 Westcote, Richard, senior, of Tanworth, yeoman 1
4295059 2128313 2128313 defendant Itchener William yeoman 618373 618373 Itchener, William, of Tanworth, yeoman 3
4295091 2128326 2128326 defendant Fulwood Raphael gent 618373 618373 Fulwood, Raphael, of Tanworth, gent 1
4297343 2129155 2129155 defendant Smythe Henry cooper 618373 618373 Smythe, Henry, of Tanworth, cooper 2
4362967 2151817 2151817 defendant Fulwood Humphrey gent 618373 618373 Fulwood, Humphrey, of Tanworth, gent 0
4362970 2151818 2151818 defendant Fulwood Humphrey gent 618373 618373 Fulwood, Humphrey, of Tanworth, gent 1
4365495 2152725 2152725 defendant Curtis Nathaniel yeoman 618373 618373 Curtis, Nathaniel, of Tanworth, yeoman 4
4366743 2153151 2153151 defendant Baker George husbandman 618373 618373 Baker, George, of Tanworth, husbandman 0
4369374 2154111 2154111 defendant Chapman Richard butcher 618373 618373 Chapman, Richard, of Tanworth, butcher 0
4371775 2154964 2154964 defendant Parsones alias Hobbens Robert laborer 618373 618373 Parsones alias Hobbens, Robert, of Tanworth, laborer 2
4374359 2155897 2155897 defendant Bellamie Richard joiner 618373 618373 Bellamie, Richard, of Tanworth, joiner 0
4374360 2155897 2155897 defendant Bellamie Henry husbandman 618373 618373 Bellamie, Henry, of Tanworth, husbandman 1
4374361 2155897 2155897 defendant Dolphin Thomas tailor 618373 618373 Dolphin, Thomas, of Tanworth, tailor 2
4377583 2157059 2157059 defendant Fulwood Raphael gent 618373 618373 Fulwood, Raphael, of Tanworth, gent 0
4381588 2158524 2158524 defendant Wescote Richard yeoman 618373 618373 Wescote, Richard, of Tanworth, yeoman 0
4381660 2158550 2158550 defendant Wescote Richard tanner 618373 618373 Wescote, Richard, of Tanworth, tanner 0
4390747 2161516 2161516 defendant Bellamy Henry husbandman 618373 618373 Bellamy, Henry, of Tanworth, husbandman 0
4411407 2168405 2168405 defendant Hollyocke Edward yeoman 618373 618373 Hollyocke, Edward, of Tanworth, yeoman 0
4411408 2168405 2168405 defendant Normancell Thomas husbandman 618373 618373 Normancell, Thomas, of Tanworth, husbandman 1
4456874 2187159 2187159 defendant Sadlere John   618373 618373 Sadlere, John, of Tanworth 0
5146647 2400157 2400157 defendant Wright John carpenter 618373 618373 Wright, John, of Tanworth, carpenter 2
5178050 2409281 2409281 defendant Babour William barber 618373 618373 Babour, William, of Tanworth, barber 1
5270884 2436581 2436581 defendant Hadnot John husbandman 618373 618373 Hadnot, John, of Tanworth, husbandman 1
5270885 2436581 2436581 defendant Geffreys John husbandman 618373 618373 Geffreys, John, of Tanworth, husbandman 2
5622679 2551024 2551024 defendant Balle Henry   618373 618373 Balle, Henry, of Tanworth 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);