names

13 rows where place_id = 680367

✎ 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
3955600 2009030 2009030 defendant Davye or Davyd Henry laborer 680367 680367 Davye or Davyd, Henry, of Depden, Essex, husbandman, son of Davys or Davide, John, of Amberden, Depden, laborer 0
4040206 2039000 2039000 plaintiff Hamonde Richard yeoman 680367 680367 Hamonde, Richard, of Depden, Essex, yeoman 1
5385664 2470970 2470970 defendant Martyn Nicholas yeoman 680367 680367 Martyn, Nicholas, of Depden, Essex, yeoman 1
5394767 2473570 2473570 defendant Gelowe John, senior smith 680367 680367 Gelowe, John, senior, of Depden, Essex, smith 2
5394768 2473570 2473570 defendant Martyn Nicholas husbandman 680367 680367 Martyn, Nicholas, of Depden, Essex, husbandman 3
5397837 2474452 2474452 defendant Martyn Nicholas yeoman 680367 680367 Martyn, Nicholas, of Depden, Essex, yeoman 1
5407997 2477368 2477368 defendant Gelows John, senior smith 680367 680367 Gelows, John, senior, of Depden, Essex, smith 2
5408002 2477369 2477369 defendant Gelows John, senior smith 680367 680367 Gelows, John, senior, of Depden, Essex, smith 2
5408006 2477370 2477370 defendant Martyn Nicholas yeoman 680367 680367 Martyn, Nicholas, of Depden, Essex, yeoman 1
5408008 2477370 2477370 defendant Gelow John smith 680367 680367 Gelow, John, of Depden, Essex, smith 3
5434645 2485299 2485299 defendant Wright John husbandman 680367 680367 Wright, John, of Depden, Essex, husbandman 2
5449969 2489880 2489880 defendant Wright John husbandman 680367 680367 Wright, John, of Depden, Essex, husbandman 2
5462127 2493565 2493565 defendant Wright John husbandman 680367 680367 Wright, John, of Depden, Essex, 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);