names

13 rows where case_id = 2302485

✎ 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
4820505 2302485 2302485 plaintiff Ratheby John     Ratheby, John, on his own account 0
4820506 2302485 2302485 defendant Grene John husbandman 595949 595949 Grene, John, of Belcheford, husbandman 0
4820507 2302485 2302485 defendant Wentworth Henry yeoman 586846 586846 Wentworth, Henry, of Lincoln, yeoman 1
4820508 2302485 2302485 defendant Copuldyke Ralph yeoman 807472 807472 Copuldyke, Ralph, of Harwyk by Wragby, yeoman 2
4820509 2302485 2302485 defendant Whittop Richard yeoman 623040 623040 Whittop, Richard, of Edenham, yeoman 3
4820510 2302485 2302485 defendant Hormeston John husbandman 591972 591972 Hormeston, John, of Stapulford, husbandman 4
4820511 2302485 2302485 defendant Geffray Thomas husbandman 603356 603356 Geffray, Thomas, of Pykworth, husbandman 5
4820512 2302485 2302485 defendant Shipton John yeoman 603356 603356 Shipton, John, of Pykworth, yeoman 6
4820513 2302485 2302485 defendant Stepyng John husbandman 603356 603356 Stepyng, John, of Pykworth, husbandman 7
4820514 2302485 2302485 defendant Barneby John yeoman 587210 587210 Barneby, John, of Merston, yeoman 8
4820515 2302485 2302485 defendant Forster Henry husbandman 807473 807473 Forster, Henry, of Trymesthorp, husbandman 9
4820516 2302485 2302485 defendant Richardson John husbandman 594818 594818 Richardson, John, of Byker, husbandman 10
4820517 2302485 2302485 defendant Bay Walter husbandman 594818 594818 Bay, Walter, of Byker, husbandman 11

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