names

16 rows where place_id = 588134

✎ 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
3593477 1865594 1865594 defendant Baile John husbandman 588134 588134 Baile, John, of Pokyngton, husbandman 0
3661536 1913881 1913881 defendant Hopkyns William husbandman 588134 588134 Hopkyns, William, of Pokyngton, husbandman 0
3677125 1918888 1918888 defendant Hoskyns William husbandman 588134 588134 Hoskyns, William, of Pokyngton, husbandman 0
3855509 1975366 1975366 defendant Stephynson Leonard clerk 588134 588134 Stephynson, Leonard, of Pokyngton, clerk 2
4639265 2243001 2243001 defendant Rocchesdale William   588134 588134 Rocchesdale, William, of Pokyngton 0
4735720 2276317 2276317 defendant Rachesdale William   588134 588134 Rachesdale, William, of Pokyngton, parson 0
4772773 2287452 2287452 defendant Rachesdale William   588134 588134 Rachesdale, William, of Pokyngton, parson 0
4931359 2336188 2336188 defendant Nikkes Richard husbandman 588134 588134 Nikkes, Richard, of Pokyngton, husbandman 1
4931360 2336188 2336188 defendant Wattes John husbandman 588134 588134 Wattes, John, of Pokyngton, husbandman 2
5049043 2371348 2371348 defendant Stonard Richard   588134 588134 Stonard, Richard, of Pokyngton, tallow chandler 0
5137593 2397509 2397509 defendant Muttelbury William   588134 588134 Muttelbury, William, of Pokyngton 2
5158249 2403534 2403534 defendant Muttelbury William butcher 588134 588134 Muttelbury, William, of Pokyngton, butcher 2
5173888 2408061 2408061 defendant Muttelbury William butcher 588134 588134 Muttelbury, William, of Pokyngton, butcher 2
5194118 2414011 2414011 defendant Muttelbury William butcher 588134 588134 Muttelbury, William, of Pokyngton, butcher 2
5286066 2440933 2440933 defendant Dawe John husbandman 588134 588134 Dawe, John, of Pokyngton, husbandman 2
5358579 2462742 2462742 defendant Sylvester George yeoman 588134 588134 Sylvester, George, of Pokyngton, yeoman 0

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