names

14 rows where place_id = 764165

✎ 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
4486066 2196346 2196346 defendant Wyltonesse John   764165 764165 Wyltonesse, John, of Wylyngton, vicar 1
4503626 2201710 2201710 defendant Barton or Garton Henry   764165 764165 Barton or Garton, Henry, of Wylyngton 2
4642029 2243776 2243776 defendant Cundy John   764165 764165 Cundy, John, of Wylyngton 0
4642031 2243777 2243777 defendant Cundy John   764165 764165 Cundy, John, of Wylyngton 0
4663729 2250141 2250141 defendant Cundy John   764165 764165 Cundy, John, of Wylyngton 0
4676733 2258344 2258344 defendant Cundy John   764165 764165 Cundy, John, of Wylyngton, 0
4702020 2266043 2266043 defendant Cundy John   764165 764165 Cundy, John, of Wylyngton 0
4702546 2266208 2266208 defendant Grenhill John tanner 764165 764165 Grenhill, John, of Wylyngton, tanner 1
4721833 2272161 2272161 defendant Aller Richard gent 764165 764165 Aller, Richard, of Wylyngton, gent 1
4739150 2277336 2277336 defendant Hull Roger husbandman 764165 764165 Hull, Roger, of Wylyngton, husbandman 0
4819474 2302166 2302166 defendant Frenche Thomas gent 764165 764165 (Frenche, Thomas, of Wylyngton, gent 1
4859231 2314262 2314262 defendant Shepherd Richard drover 764165 764165 Shepherd, Richard, of Wylyngton, drover 0
5090852 2383715 2383715 defendant Chandos Robert gent 764165 764165 Chandos, Robert, of Wylyngton, gent 0
5285256 2440710 2440710 defendant Whirlat John clerk 764165 764165 Whirlat, John, of Wylyngton, clerk 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);