names

33 rows where place_id = 588604

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3595034 1866080 1866080 defendant Petwardyn William tailor 588604 588604 Petwardyn, William, of Houedon, tailor 0
3595035 1866080 1866080 defendant Petwardyn John barker 588604 588604 Petwardyn, John, of Houedon, barker 1
3596338 1866485 1866485 defendant Atkynson Henry yeoman 588604 588604 Atkynson, Henry, of Houedon, yeoman 0
3598078 1867026 1867026 defendant Durham Ralph gent 588604 588604 Durham, Ralph, of Houedon, gent 0
3598084 1867028 1867028 defendant Wright John yeoman 588604 588604 Wright, John, of Houedon, yeoman 0
3598085 1867028 1867028 defendant Barker John yeoman 588604 588604 Barker, John, of Houedon, yeoman 1
4878966 2320353 2320353 defendant Bemeslay John husbandman 588604 588604 Bemeslay, John, of Houedon, husbandman 0
4949546 2341853 2341853 defendant Laweton William gent 588604 588604 Laweton, William, of Houedon, gent 0
4983864 2352099 2352099 defendant Loncastre William fisher 588604 588604 Loncastre, William, of Houedon, fisher 0
5062342 2375301 2375301 defendant Knyght Thomas carpenter 588604 588604 Knyght, Thomas, of Houedon, carpenter 0
5065543 2376228 2376228 defendant Duffeld Thomas   588604 588604 Duffeld, Thomas, of Houedon, parish clerk 0
5076938 2379597 2379597 defendant Raweson Thomas husbandman 588604 588604 Raweson, Thomas, of Houedon, husbandman 0
5076939 2379597 2379597 defendant Raweson Robert husbandman 588604 588604 Raweson, Robert, of Houedon, husbandman 1
5090316 2383550 2383550 defendant Parkoure William yeoman 588604 588604 Parkoure, William, of Houedon, yeoman 0
5090317 2383550 2383550 defendant Flecher Robert fletcher 588604 588604 Flecher, Robert, of Houedon, fletcher 1
5096972 2385547 2385547 defendant Wilberfosse John gent 588604 588604 Wilberfosse, John, of Houedon, gent 0
5106068 2388214 2388214 defendant Skegge John butcher 588604 588604 Skegge, John, of Houedon, butcher 0
5106069 2388214 2388214 defendant Sadler Thomas saddler 588604 588604 Sadler, Thomas, of Houedon, saddler 1
5106070 2388214 2388214 defendant Kente William mercer 588604 588604 Kente, William, of Houedon, mercer 2
5114760 2390731 2390731 defendant Maners Thomas gent 588604 588604 Maners, Thomas, of Houedon, gent 1
5114761 2390731 2390731 defendant Lee Hugh   588604 588604 Lee, Hugh, of Houedon 2
5218907 2421255 2421255 defendant Laton or Lauton William gent 588604 588604 Laton or Lauton, William, of Houedon, gent 0
5229379 2424203 2424203 defendant Rynge John, senior   588604 588604 Rynge, John, senior, of Houedon, coverlet weaver 5
5229380 2424203 2424203 defendant Rynge John, junior   588604 588604 Rynge, John, junior, of Houedon, coverlet weaver 6
5229383 2424203 2424203 defendant Aunger William butcher 588604 588604 Aunger, William, of Houedon, butcher 9
5229384 2424203 2424203 defendant Laundevell William tailor 588604 588604 Laundevell, William, of Houedon, tailor 10
5229385 2424203 2424203 defendant Fraunkland Thomas butcher 588604 588604 Fraunkland, Thomas, of Houedon, butcher 11
5282079 2439833 2439833 plaintiff Cutte Thomas dyer 588604 588604 Cutte, Thomas, of Houedon, dyer 0
5282080 2439833 2439833 defendant Waryn William clerk 588604 588604 Waryn, William, of Houedon, clerk 0
5296482 2443961 2443961 defendant Sutton Simon shoemaker 588604 588604 Sutton, Simon, of Houedon, shoemaker 0
5321516 2451526 2451526 defendant Thex alias Usthwayte Robert husbandman 588604 588604 Thex alias Usthwayte, Robert, of Houedon, husbandman 4
5536232 2515826 2515826 defendant Conyngworth John shoemaker 588604 588604 Conyngworth, John, of Houedon, shoemaker 1
5536233 2515826 2515826 defendant Roger William laborer 588604 588604 Roger, William, of Houedon, laborer 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);