names

16 rows where case_id = 2159127

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, forename, occupation, place_id, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
4383283 2159127 2159127 plaintiff Arnold John attorney   Arnold, John, attorney 0
4383284 2159127 2159127 defendant Garrard Henry   633195 633195 Garrard, Henry, of Faltenham, poldave weaver 0
4383285 2159127 2159127 defendant Scott Robert sawyer 633195 633195 Scott, Robert, of Faltenham, sawyer 1
4383286 2159127 2159127 defendant Humfrey John   586134 586134 Humfrey, John, of Ipswich scrivener 2
4383287 2159127 2159127 defendant Mortymer Richard weaver 587759 587759 Mortymer, Richard, of Nedeham, weaver 3
4383288 2159127 2159127 defendant Marche Thomas yeoman 633618 633618 Marche, Thomas, of Tremley, yeoman 4
4383289 2159127 2159127 defendant Littlebury Michael yeoman 586134 586134 Littlebury, Michael, of Ipswich, yeoman 5
4383290 2159127 2159127 defendant Barley Thomas husbandman 699155 699155 Barley, Thomas, of Waldringfeild, husbandman 6
4383291 2159127 2159127 defendant Bryden Joseph yeoman 733149 733149 Bryden, Joseph, of Bucklesham, yeoman 7
4383292 2159127 2159127 defendant Evans Richard clerk 629934 629934 Evans, Richard, of Hollesley, clerk 8
4383293 2159127 2159127 defendant Styles Thomas husbandman 695972 695972 Styles, Thomas, of Wenham Parva, husbandman 9
4383294 2159127 2159127 defendant Skynner Henry baker 586134 586134 Skynner, Henry, of Ipswich, baker 10
4383295 2159127 2159127 defendant Damsell Thomas cooper 652642 652642 Damsell, Thomas, of Newborne, cooper 11
4383296 2159127 2159127 defendant Sage Thomas yeoman 657881 657881 Sage, Thomas, of Sproughton, yeoman 12
4383297 2159127 2159127 defendant Colman John barber 586134 586134 Colman, John, of Ipswich, barber 13
4383298 2159127 2159127 defendant Palmer John   588489 588489 Palmer, John, of Melton, sailor 14

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);