names

26 rows where place_id = 591025

✎ 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
3603079 1868629 1868629 defendant Hervy Thomas gent 591025 591025 Hervy, Thomas, of Lowestofte, Suff, gent 1
3635368 1905857 1905857 defendant Heigham John merchant 591025 591025 Heigham, John, of Lowestofte, Suff, merchant 2
3645987 1909138 1909138 defendant Broun John clerk 591025 591025 Broun, John, of Lowestofte, Suff, clerk 0
3706308 1928260 1928260 defendant Lobbys Geoffrey merchant 591025 591025 Lobbys, Geoffrey, of Lowestofte, Suff, merchant 2
3739220 1938487 1938487 defendant Downyng John mercer 591025 591025 Downyng, John, of Lowestofte, Suff, mercer 0
3739246 1938495 1938495 defendant Downyng John mercer 591025 591025 Downyng, John, of Lowestofte, Suff, mercer 0
3752000 1942547 1942547 defendant Deane Ralph yeoman 591025 591025 Deane, Ralph, of Lowestofte, Suff, yeoman 0
3752638 1942756 1942756 defendant Broun John clerk 591025 591025 Broun, John, of Lowestofte, Suff, clerk 1
3758989 1944800 1944800 defendant Higham John yeoman 591025 591025 Higham, John, of Lowestofte, Suff, yeoman 2
3769447 1948104 1948104 defendant Broun John clerk 591025 591025 Broun, John, of Lowestofte, Suff, clerk 1
3774080 1949607 1949607 defendant Chester Robert tailor 591025 591025 Chester, Robert, of Lowestofte, Suff, tailor 4
3895520 1988706 1988706 defendant Culleys William baker 591025 591025 Culleys, William, of Lowestofte, Suff, baker 0
3927525 1999549 1999549 defendant Beamond John   591025 591025 Beamond, John, of Lowestofte, Suff, horse corser 2
4061142 2046394 2046394 defendant Webbe John yeoman 591025 591025 Webbe, John, of Lowestofte, Suff, yeoman 0
4072085 2050314 2050314 defendant Davye Edward yeoman 591025 591025 Davye, Edward, of Lowestofte, Suff, yeoman 11
4117280 2066483 2066483 defendant Burrell Stephen merchant 591025 591025 Burrell, Stephen, of Lowestofte, Suff, merchant 0
4199449 2095357 2095357 defendant Belwarde Richard butcher 591025 591025 Belwarde, Richard, of Lowestofte, Suff, butcher 0
4217554 2101633 2101633 defendant Gosslinge William yeoman 591025 591025 Gosslinge, William, of Lowestofte, Suff, yeoman 0
4243819 2110914 2110914 defendant Gosslinge William yeoman 591025 591025 Gosslinge, William, of Lowestofte, Suff, yeoman 0
5292044 2442678 2442678 defendant Saxmendham William merchant 591025 591025 Saxmendham, William, of Lowestofte, Suff, merchant 0
5515669 2509745 2509745 defendant Boof or Boos John gent 591025 591025 Boof or Boos, John, of Lowestofte, Suff, gent 0
5529600 2513758 2513758 defendant Hughson Nicholas merchant 591025 591025 Hughson, Nicholas, of Lowestofte, Suff, merchant 1
5546437 2518957 2518957 defendant Gall Richard merchant 591025 591025 Gall, Richard, of Lowestofte, Suff, merchant 0
5551089 2520342 2520342 defendant Denne Ralph draper 591025 591025 Denne, Ralph, of Lowestofte, Suff, draper 0
5560991 2523184 2523184 defendant Denne Ralph tailor 591025 591025 Denne, Ralph, of Lowestofte, Suff, tailor 1
5573164 2526701 2526701 defendant Bosse or Boffe John yeoman 591025 591025 Bosse or Boffe, John, of Lowestofte, Suff, 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);