names

13 rows where place_id = 768005

✎ 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
4545282 2214447 2214447 defendant Tuner Richard   768005 768005 Tuner, Richard, of Park 2
4982570 2351700 2351700 defendant Tretherf Reginald esq 768005 768005 Tretherf, Reginald, of Park, esq 1
4982574 2351701 2351701 defendant Alen Roger esq 768005 768005 Alen, Roger, of Park, esq 1
5160842 2404267 2404267 defendant Styleman John husbandman 768005 768005 Styleman, John, of Park, husbandman 0
5175500 2408518 2408518 defendant Rys Richard husbandman 768005 768005 Rys, Richard, of Park, husbandman 18
5175501 2408518 2408518 defendant Dryver Richard husbandman 768005 768005 Dryver, Richard, of Park, husbandman 19
5175505 2408518 2408518 defendant Notkyn Henry miller 768005 768005 Notkyn, Henry, of Park, miller 23
5175507 2408518 2408518 defendant atte Hoo Thomas husbandman 768005 768005 atte Hoo, Thomas, of Park, husbandman 25
5175508 2408518 2408518 defendant Felyp William laborer 768005 768005 Felyp, William, of Park, laborer 26
5196736 2414794 2414794 defendant Styleman John husbandman 768005 768005 Styleman, John, of Park, husbandman 0
5209792 2418598 2418598 defendant Stykeman John husbandman 768005 768005 Stykeman, John, of Park, husbandman 0
5282285 2439878 2439878 defendant Smyth Roger husbandman 768005 768005 Smyth, Roger, of Park, husbandman 0
5316201 2449928 2449928 defendant Reynold John laborer 768005 768005 Reynold, John, of Park, laborer 1

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