names

21 rows where place_id = 592590

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3608191 1870220 1870220 plaintiff Lathum Robert   592590 592590 (Lathum, Robert, of North Wokyndon 1
3686466 1921919 1921919 defendant Sawell Thomas carpenter 592590 592590 Sawell, Thomas, of North Wokyndon, carpenter 4
3788563 1954219 1954219 defendant Benson John husbandman 592590 592590 Benson, John, of North Wokyndon, husbandman 4
4413948 2169263 2169263 plaintiff Chapman Geoffrey le   592590 592590 Chapman, Geoffrey le, of North Wokyndon 0
4413949 2169263 2169263 defendant Stacy Robert   592590 592590 Stacy, Robert, of North Wokyndon 0
4420930 2171441 2171441 plaintiff Chapman Geoffrey le   592590 592590 Chapman, Geoffrey le, of North Wokyndon 0
4432092 2174820 2174820 defendant Roke William   592590 592590 Roke, William, of North Wokyndon, parson 0
4432094 2174821 2174821 defendant Roke William   592590 592590 Roke, William, of North Wokyndon, parson 0
4470832 2191529 2191529 defendant Bocher Richard   592590 592590 Bocher, Richard, of North Wokyndon 0
4811336 2299655 2299655 defendant Souder John husbandman 592590 592590 Souder, John, of North Wokyndon, husbandman 0
4811337 2299655 2299655 defendant Gens Simon husbandman 592590 592590 Gens, Simon, of North Wokyndon, husbandman 1
4871917 2318193 2318193 defendant Poynes John gent 592590 592590 (Poynes, John, of North Wokyndon, gent 2
5006238 2358717 2358717 defendant Copto Thomas   592590 592590 Copto, Thomas, of North Wokyndon, parson & rector, and clerk 0
5142127 2398817 2398817 defendant Kynot William husbandman 592590 592590 Kynot, William, of North Wokyndon, husbandman 0
5176987 2408960 2408960 defendant Kynot William husbandman 592590 592590 Kynot, William, of North Wokyndon, husbandman 0
5233504 2425391 2425391 defendant Lake Richard carpenter 592590 592590 Lake, Richard, of North Wokyndon, carpenter 0
5233505 2425391 2425391 defendant Stubber William husbandman 592590 592590 Stubber, William, of North Wokyndon, husbandman 1
5382800 2470146 2470146 plaintiff Stubber William husbandman 592590 592590 Stubber, William, of North Wokyndon, husbandman 0
5382802 2470147 2470147 plaintiff Stubber William husbandman 592590 592590 Stubber, William, of North Wokyndon, husbandman 0
5382804 2470148 2470148 plaintiff Stubber William husbandman 592590 592590 Stubber, William, of North Wokyndon, husbandman 0
5457020 2492007 2492007 plaintiff Reynold John yeoman 592590 592590 Reynold, John, of North Wokyndon, yeoman 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);