names

44 rows where place_id = 591336

✎ 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
3604106 1868950 1868950 defendant Ingham John husbandman 591336 591336 Ingham, John, of Asshefeld, husbandman 0
3707892 1928765 1928765 defendant Bronte or Broute Henry laborer 591336 591336 Bronte or Broute, Henry, of Asshefeld, laborer 11
3760618 1945320 1945320 defendant Noblot Robert laborer 591336 591336 Noblot, Robert, of Asshefeld, laborer 0
3791601 1955212 1955212 defendant Jurnett John sawyer 591336 591336 Jurnett, John, of Asshefeld, sawyer 3
3813250 1962055 1962055 defendant Beckett William shoemaker 591336 591336 Beckett, William, of Asshefeld, shoemaker 0
3884508 1985092 1985092 defendant Awoode John yeoman 591336 591336 Awoode, John, of Asshefeld, yeoman 0
4450791 2185210 2185210 defendant Blussh Thomas   591336 591336 Blussh, Thomas, of Asshefeld 0
4456919 2187176 2187176 defendant Gense John   591336 591336 Gense, John, of Asshefeld 0
4457358 2187314 2187314 defendant Rous John   591336 591336 Rous, John, of Asshefeld 3
4457403 2187328 2187328 defendant Rous John   591336 591336 Rous, John, of Asshefeld 3
4570224 2222258 2222258 defendant Qwynsy John   591336 591336 Qwynsy, John, of Asshefeld 0
4585901 2227014 2227014 plaintiff Haukyn Adam   591336 591336 Haukyn, Adam, of Asshefeld 0
4585902 2227014 2227014 defendant Potell Nicholas   591336 591336 Potell, Nicholas, of Asshefeld 0
4597251 2230384 2230384 plaintiff Seriaunt William   591336 591336 Seriaunt, William, of Asshefeld 0
4668698 2255925 2255925 defendant Cook John yeoman 591336 591336 Cook, John, of Asshefeld, yeoman 0
4668699 2255925 2255925 defendant Broys John yeoman 591336 591336 Broys, John, of Asshefeld, yeoman 1
4691748 2262952 2262952 defendant Taboure Edmund tiler 591336 591336 Taboure, Edmund, of Asshefeld, tiler 0
4691750 2262952 2262952 defendant Honell of Hovell Edmund miller 591336 591336 Honell of Hovell, Edmund, of Asshefeld, miller 2
4691751 2262952 2262952 defendant Hore William laborer 591336 591336 Hore, William, of Asshefeld, laborer 3
4723479 2272652 2272652 defendant Pykenot John husbandman 591336 591336 Pykenot, John, of Asshefeld, husbandman 4
4737508 2276844 2276844 defendant Syre Robert chaplain 591336 591336 Syre, Robert, of Asshefeld, chaplain 1
4801926 2296786 2296786 defendant Syre John husbandman 591336 591336 Syre, John, of Asshefeld, husbandman 0
4806195 2298143 2298143 defendant Michell William yeoman 591336 591336 Michell, William, of Asshefeld, yeoman 0
4806196 2298143 2298143 defendant Martyn Robert yeoman 591336 591336 Martyn, Robert, of Asshefeld, yeoman 1
4843147 2309385 2309385 defendant More John butcher 591336 591336 More, John, of Asshefeld, butcher 0
4995491 2355490 2355490 defendant Helpysby Thomas husbandman 591336 591336 Helpysby, Thomas, of Asshefeld, husbandman 0
5039566 2368481 2368481 defendant Clerk Thomas husbandman 591336 591336 Clerk, Thomas, of Asshefeld, husbandman 0
5140375 2398290 2398290 defendant Syre Robert   591336 591336 Syre, Robert, of Asshefeld 1
5167903 2406325 2406325 defendant Baldewyn John husbandman 591336 591336 Baldewyn, John, of Asshefeld, husbandman 0
5235003 2425818 2425818 defendant Baldewyn John husbandman 591336 591336 Baldewyn, John, of Asshefeld, husbandman 0
5259913 2433223 2433223 defendant Hotard Richard (legal representative) 591336 591336 Hotard, Richard, of Asshefeld, yeoman, executor of 0
5265302 2434906 2434906 defendant Caly William yeoman 591336 591336 Caly, William, of Asshefeld, yeoman 0
5287070 2441229 2441229 defendant Lowe Lawrence gent 591336 591336 Lowe, Lawrence, of Asshefeld, gent 0
5289003 2441791 2441791 defendant Cerner or Cerver John laborer 591336 591336 Cerner or Cerver, John, of Asshefeld, laborer 1
5289004 2441791 2441791 defendant Syre Robert husbandman 591336 591336 Syre, Robert, of Asshefeld, husbandman 2
5386579 2471229 2471229 defendant Clerk John husbandman 591336 591336 Clerk, John, of Asshefeld, husbandman 2
5411969 2478535 2478535 defendant Clerk (illegible) husbandman 591336 591336 Clerk, _, of Asshefeld, husbandman 2
5426519 2482879 2482879 defendant Clerk Robert husbandman 591336 591336 Clerk, Robert, of Asshefeld, husbandman 2
5447450 2489124 2489124 defendant Wode Richard husbandman 591336 591336 Wode, Richard, of Asshefeld, by Thorp St Peter, husbandman 3
5459915 2492894 2492894 defendant Wode Richard husbandman 591336 591336 Wode, Richard, of Asshefeld, by Thorp St Peter, husbandman 3
5471581 2496447 2496447 defendant Wode Richard husbandman 591336 591336 Wode, Richard, of Asshefeld, by Thorp St Peter, husbandman 3
5494822 2503342 2503342 defendant Clerk Robert husbandman 591336 591336 Clerk, Robert, of Asshefeld, husbandman 0
5573200 2526713 2526713 defendant Palmer William husbandman 591336 591336 Palmer, William, of Asshefeld, husbandman 1
5608117 2537444 2537444 defendant Kenrede Walter husbandman 591336 591336 Kenrede, Walter, of Asshefeld, husbandman 2

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