names

11 rows where place_id = 596216

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3623717 1874950 1874950 defendant Drake Henry yeoman 596216 596216 Drake, Henry, of Bryggeton Pomeray, yeoman 3
3646269 1909224 1909224 defendant Fursdon Sincler laborer 596216 596216 Fursdon, Sincler, of Bryggeton Pomeray, laborer 1
5037475 2367831 2367831 defendant Helyer Thomas helyer or roofer 596216 596216 Helyer, Thomas, of Bryggeton Pomeray, helyer or roofer 0
5126667 2394274 2394274 defendant Drake John yeoman 596216 596216 Drake, John, of Bryggeton Pomeray, yeoman 0
5149366 2400949 2400949 defendant Drake John yeoman 596216 596216 Drake, John, of Bryggeton Pomeray, yeoman 0
5194151 2414023 2414023 defendant Tracy John, sen crokker or potter 596216 596216 Tracy, John, sen, of Bryggeton Pomeray, crokker or potter 0
5208574 2418236 2418236 defendant Tracy John, sen potter 596216 596216 Tracy, John, sen, of Bryggeton Pomeray, potter 0
5226183 2423323 2423323 defendant Appryse John yeoman 596216 596216 Appryse, John, of Bryggeton Pomeray, yeoman 5
5550559 2520186 2520186 defendant Hunte Nicholas husbandman 596216 596216 Hunte, Nicholas, of Bryggeton Pomeray, husbandman 2
5550560 2520186 2520186 defendant Olyver Richard laborer 596216 596216 Olyver, Richard, of Bryggeton Pomeray, laborer 3
5550561 2520186 2520186 defendant Fursdon Detneclar laborer 596216 596216 Fursdon, Detneclar, of Bryggeton Pomeray, laborer 4

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