names

23 rows where place_id = 596157

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3623404 1874852 1874852 defendant Hert Thomas scrivener 596157 596157 Hert, Thomas, of Newerke, Notts, scrivener 0
3711683 1929965 1929965 defendant Johnson William draper 596157 596157 Johnson, William, of Newerke, Notts, draper 1
3851143 1973947 1973947 defendant Clerke Thomas mercer 596157 596157 Clerke, Thomas, of Newerke, Notts, mercer 0
4681086 2259713 2259713 defendant Kelom Robert gent 596157 596157 Kelom, Robert, of Newerke, Notts, gent 0
4962048 2345557 2345557 defendant Carlele Richard chapman 596157 596157 Carlele, Richard, of Newerke, Notts, chapman 4
4962069 2345561 2345561 defendant Bene William chapman 596157 596157 Bene, William, of Newerke, Notts, chapman 3
4969822 2347920 2347920 defendant Gale Alice widow 596157 596157 Gale, Alice, of Newerke, Notts, widow 0
5036299 2367467 2367467 defendant Heseham Thomas merchant 596157 596157 Heseham, Thomas, of Newerke, Notts, merchant 2
5089043 2383171 2383171 defendant Kelsterne William dyer 596157 596157 Kelsterne, William, of Newerke, Notts, dyer 0
5089047 2383172 2383172 defendant Kelsterne William dyer 596157 596157 Kelsterne, William, of Newerke, Notts, dyer 0
5122433 2392988 2392988 defendant Esyngwold John gent 596157 596157 Esyngwold, John, of Newerke, Notts, gent 0
5135246 2396807 2396807 defendant Atkynson Richard chapman 596157 596157 Atkynson, Richard, of Newerke, Notts, chapman 2
5155372 2402722 2402722 defendant Atkynson Richard chapman 596157 596157 Atkynson, Richard, of Newerke, Notts, chapman 2
5171065 2407261 2407261 defendant Prentice William merchant 596157 596157 Prentice, William, of Newerke, Notts, merchant 0
5172029 2407534 2407534 defendant Atkynson Richard chapman 596157 596157 Atkynson, Richard, of Newerke, Notts, chapman 2
5189326 2412610 2412610 defendant Prentice William merchant 596157 596157 Prentice, William, of Newerke, Notts, merchant 0
5254592 2431556 2431556 defendant Humburston John merchant 596157 596157 Humburston, John, of Newerke, Notts, merchant 0
5261181 2433611 2433611 defendant Shire Thomas yeoman 596157 596157 Shire, Thomas, of Newerke, Notts, yeoman 0
5395256 2473717 2473717 defendant Hund Andrew   596157 596157 Hund, Andrew, of Newerke, Notts, inn holder 1
5421694 2481426 2481426 defendant Hund Andrew husbandman 596157 596157 Hund, Andrew, of Newerke, Notts, husbandman 1
5501564 2505420 2505420 defendant Horton Richard mercer 596157 596157 Horton, Richard, of Newerke, Notts, mercer 2
5591647 2532368 2532368 defendant Fauconer Henry mercer 596157 596157 Fauconer, Henry, of Newerke, Notts, mercer 0
5591649 2532369 2532369 defendant Faunconer Henry mercer 596157 596157 Faunconer, Henry, of Newerke, Notts, mercer 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);