names

23 rows where place_id = 591098

✎ 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
3603328 1868715 1868715 plaintiff Daubeney Clement   591098 591098 Daubeney, Clement, of Hunden, Suff 0
3683120 1920838 1920838 defendant Coksall Thomas gent 591098 591098 Coksall, Thomas, of Hunden, Suff, gent 1
3706556 1928334 1928334 defendant Ive William husbandman 591098 591098 Ive, William, of Hunden, Suff, husbandman 0
3719702 1932429 1932429 defendant Coggeshale Thomas gent 591098 591098 Coggeshale, Thomas, of Hunden, Suff, gent 1
3758002 1944485 1944485 defendant Coggeshall Thomas yeoman 591098 591098 Coggeshall, Thomas, of Hunden, Suff, yeoman 0
3787202 1953788 1953788 defendant Heygham John gent 591098 591098 Heygham, John, of Hunden, Suff, gent 1
3787204 1953789 1953789 defendant Heygham John gent 591098 591098 Heygham, John, of Hunden, Suff, gent 0
3876054 1982244 1982244 defendant Hamond William husbandman 591098 591098 Hamond, William, of Hunden, Suff, husbandman 0
4005852 2026863 2026863 defendant Ostler Alexander blacksmith 591098 591098 Ostler, Alexander, of Hunden, Suff, blacksmith 0
4066746 2048404 2048404 defendant Barnard Robert tailor 591098 591098 Barnard, Robert, of Hunden, Suff, tailor 0
4192072 2092788 2092788 defendant Taylor Gregory joiner 591098 591098 Taylor, Gregory, of Hunden, Suff, joiner 0
4773097 2287556 2287556 defendant Weltop John husbandman 591098 591098 Weltop, John, of Hunden, Suff, husbandman 0
4912691 2330473 2330473 defendant Goggeshale or Coggeshale William yeoman 591098 591098 Goggeshale or Coggeshale, William, of Hunden, Suff, yeoman 1
5037715 2367904 2367904 defendant Syttewell John husbandman 591098 591098 Syttewell, John, of Hunden, Suff, husbandman 3
5141054 2398505 2398505 defendant (not given) Robert prior of Balhede 591098 591098 Balhede, Robert, of Hunden, Suff, clerk & prior of Bryset or Bricett 0
5197200 2414920 2414920 defendant Rande William chapman 591098 591098 Rande, William, of Hunden, Suff, chapman 1
5209962 2418646 2418646 defendant Rande William chapman 591098 591098 Rande, William, of Hunden, Suff, chapman 1
5225916 2423252 2423252 defendant Coksale William yeoman 591098 591098 Coksale, William, of Hunden, Suff, yeoman 0
5266150 2435163 2435163 defendant Cukkowe William shoemaker 591098 591098 Cukkowe, William, of Hunden, Suff, shoemaker 0
5337478 2456283 2456283 defendant Waterley William yeoman 591098 591098 Waterley, William, of Hunden, Suff, yeoman 0
5367428 2465463 2465463 defendant Venour John butcher 591098 591098 Venour, John, of Hunden, Suff, butcher 1
5393859 2473304 2473304 defendant Coggeshall William gent 591098 591098 Coggeshall, William, of Hunden, Suff, gent 0
5393860 2473304 2473304 defendant Clerk William husbandman 591098 591098 Clerk, William, of Hunden, Suff, husbandman 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);