names

14 rows where place_id = 587753

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3592347 1865222 1865222 defendant Chapleyn Robert cooper 587753 587753 Chapleyn, Robert, of Blythburgh, Suff, cooper 2
3854840 1975159 1975159 defendant Barker Peter cordwainer 587753 587753 Barker, Peter, of Blythburgh, Suff, cordwainer 0
3854842 1975160 1975160 defendant Hapton John painter 587753 587753 Hapton, John, of Blythburgh, Suff, painter 0
3854846 1975161 1975161 defendant Hopton John painter 587753 587753 Hopton, John, of Blythburgh, Suff, painter 0
3956564 2009361 2009361 defendant Pryme Thomas scrivener 587753 587753 Pryme, Thomas, of Blythburgh, Suff, scrivener 0
3991476 2021704 2021704 defendant Pycknet Robert innholder 587753 587753 Pycknet, Robert, of Blythburgh, Suff, innholder 0
4012483 2029185 2029185 defendant Lingwood Anthony gent 587753 587753 Lingwood, Anthony, of Blythburgh, Suff, gent 0
4015658 2030297 2030297 defendant Charvell Richard tailor 587753 587753 Charvell, Richard, of Blythburgh, Suff, tailor 1
4039280 2038678 2038678 defendant Goodwyn Thomas yeoman 587753 587753 Goodwyn, Thomas, of Blythburgh, Suff, yeoman 0
4039284 2038679 2038679 defendant Goodwyn Thomas yeoman 587753 587753 Goodwyn, Thomas, of Blythburgh, Suff, yeoman 0
4039288 2038680 2038680 defendant Tarver or Cerver William husbandman 587753 587753 Tarver or Cerver, William, of Blythburgh, Suff, husbandman 0
4039290 2038681 2038681 defendant Tarver William husbandman 587753 587753 Tarver, William, of Blythburgh, Suff, husbandman 0
5264634 2434693 2434693 defendant Stapylton Simon joiner 587753 587753 Stapylton, Simon, of Blythburgh, Suff, joiner 0
5430879 2484177 2484177 defendant Dyer Alice spinster 587753 587753 Dyer, Alice, of Blythburgh, Suff, spinster 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);