names

38 rows where place_id = 698346

✎ 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
4123738 2068791 2068791 defendant Horton John wainman 698346 698346 Horton, John, of Worcestershire, wainman 1
4511084 2203919 2203919 plaintiff Befford Beatrice   698346 698346 Befford, Beatrice, of Worcestershire, formerly wife of Alexander 0
4525494 2208303 2208303 defendant Wysham William   698346 698346 Wysham, William, of Worcestershire, knight 0
4541578 2213259 2213259 defendant Walsshe Thomas le   698346 698346 Walsshe, Thomas le, of Worcestershire 0
4558999 2218773 2218773 defendant spenser Richard   698346 698346 spenser, Richard, of Worcestershire 1
4563961 2220300 2220300 defendant Hyrtelere Richard   698346 698346 Hyrtelere, Richard, of Worcestershire 1
4564325 2220412 2220412 defendant Stowe John   698346 698346 Stowe, John, of Worcestershire 0
4566329 2221039 2221039 defendant Mare Peter de la   698346 698346 Mare, Peter de la, of Worcestershire 0
4566331 2221040 2221040 defendant Mare Peter de la   698346 698346 Mare, Peter de la, of Worcestershire 0
4570514 2222351 2222351 defendant Tyso William   698346 698346 Tyso, William, of Worcestershire 0
4573544 2223246 2223246 defendant Wyseham William   698346 698346 Wyseham, William, of Worcestershire, knight 3
4575995 2223987 2223987 defendant Wygyndon Richard   698346 698346 Wygyndon, Richard, of Worcestershire 1
4584215 2226477 2226477 defendant Cokkys William   698346 698346 Cokkys, William, of Worcestershire 1
4587441 2227475 2227475 defendant Bacon Walter   698346 698346 Bacon, Walter, of Worcestershire 1
4587858 2227603 2227603 defendant Bawedryk John   698346 698346 Bawedryk, John, of Worcestershire 1
4589590 2228112 2228112 defendant Darston Walter esq 698346 698346 Darston, Walter, of Worcestershire, esq 3
4590486 2228384 2228384 defendant Wybbe John   698346 698346 Wybbe, John, of Worcestershire 0
4604615 2232608 2232608 defendant Wysham William   698346 698346 Wysham, William, of Worcestershire, knight 0
4604617 2232609 2232609 defendant Wysham William   698346 698346 Wysham, William, of Worcestershire, knight 0
4608418 2233742 2233742 defendant Heykeley John   698346 698346 Heykeley, John, of Worcestershire 3
4608864 2233874 2233874 defendant Cotour Gilbert   698346 698346 Cotour, Gilbert, of Worcestershire 1
4621171 2237611 2237611 defendant Lyttulton Thomas   698346 698346 Lyttulton, Thomas, of Worcestershire 0
4621173 2237612 2237612 defendant Lyttylton Thomas   698346 698346 Lyttylton, Thomas, of Worcestershire 0
4639440 2243050 2243050 defendant Wybbe William   698346 698346 Wybbe, William, of Worcestershire 0
4642737 2243993 2243993 defendant Lyngell Thomas   698346 698346 Lyngell, Thomas, of Worcestershire 0
4642743 2243994 2243994 defendant Lyngell Thomas   698346 698346 Lyngell, Thomas, of Worcestershire 0
4649148 2245799 2245799 plaintiff Trentham Nicholas   698346 698346 Trentham, Nicholas, of Worcestershire 0
4719838 2271550 2271550 plaintiff Boteler William (legal representative) 698346 698346 Boteler, William, of Worcestershire, esq, executors of 0
4735520 2276257 2276257 defendant Beauchamp Ankyrus esq 698346 698346 Beauchamp, Ankyrus, of Worcestershire, esq 0
4741532 2278018 2278018 plaintiff Boteler William (legal representative) 698346 698346 Boteler, William, of Worcestershire, esq, executors of 0
4821501 2302810 2302810 defendant Belle Edward weaver 698346 698346 Belle, Edward, of Worcestershire, weaver 1
4920264 2332854 2332854 plaintiff Hygford Thomas   698346 698346 Hygford, Thomas, of Worcestershire, formerly deputy sheriff 0
5136241 2397115 2397115 defendant Thomson Richard yeoman 698346 698346 Thomson, Richard, of Worcestershire, yeoman 2
5140010 2398181 2398181 defendant Vampage John, senior gent 698346 698346 Vampage, John, senior, of Worcestershire, gent 0
5297414 2444245 2444245 defendant Dawys William skinner 698346 698346 Dawys, William, of Worcestershire, skinner 1
5396303 2474033 2474033 plaintiff Blount Humphrey (legal representative) 698346 698346 Blount, Humphrey, of Worcestershire, executors of 0
5410979 2478234 2478234 defendant Murihurst William butcher 698346 698346 Murihurst, William, of Worcestershire, butcher 3
5609541 2537880 2537880 defendant Mel--- William   698346 698346 Mel---, William, of Worcestershire 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);