names

15 rows where place_id = 702087

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
4141247 2075099 2075099 defendant Hymsworth or Hesworth Stephen yeoman 702087 702087 Hymsworth or Hesworth, Stephen, of Swillyngton, yeoman 0
4482545 2195244 2195244 plaintiff Mirfeld William   702087 702087 Mirfeld, William, of Swillyngton, parson, on his own account 0
4482549 2195245 2195245 plaintiff Mirfeld William   702087 702087 Mirfeld, William, of Swillyngton, parson, on his own account 0
4502465 2201354 2201354 plaintiff Mirfeld William   702087 702087 Mirfeld, William, of Swillyngton, parson, on his own account 0
4700359 2265527 2265527 defendant Dene William de husbandman 702087 702087 Dene, William de, of Swillyngton, husbandman 2
4724865 2273074 2273074 defendant Wryght Nicholas carpenter 702087 702087 Wryght, Nicholas, of Swillyngton, carpenter 0
4724866 2273074 2273074 defendant Pese Robert husbandman 702087 702087 Pese, Robert, of Swillyngton, husbandman 1
4736206 2276459 2276459 defendant Ardeslowe John clerk 702087 702087 Ardeslowe, John, of Swillyngton, clerk 2
4737933 2276970 2276970 defendant Mirfeld William (legal representative) 702087 702087 Mirfeld, William, of Swillyngton, executor of 0
4739235 2277363 2277363 plaintiff Daniell Richard   702087 702087 Daniell, Richard, of Swillyngton, parson 4
4824064 2303600 2303600 defendant Pees Robert laborer 702087 702087 Pees, Robert, of Swillyngton, laborer 3
5001798 2357424 2357424 defendant Ellerton John yeoman 702087 702087 Ellerton, John, of Swillyngton, yeoman 0
5001802 2357425 2357425 defendant Ellerton John yeoman 702087 702087 Ellerton, John, of Swillyngton, yeoman 0
5304398 2446316 2446316 plaintiff Hopton John esq 702087 702087 Hopton, John, of Swillyngton, esq 0
5341632 2457576 2457576 defendant Bythewater Richard yeoman 702087 702087 Bythewater, Richard, of Swillyngton, yeoman 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);