names

20 rows where place_id = 601175

✎ 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
3644187 1908614 1908614 defendant Peynton William mercer 601175 601175 Peynton, William, of Wherwell, mercer 1
3644220 1908623 1908623 defendant Peynton William mercer 601175 601175 Peynton, William, of Wherwell, mercer 1
3698388 1925717 1925717 defendant Symkyn Edward smith 601175 601175 Symkyn, Edward, of Wherwell, smith 1
4032100 2036146 2036146 defendant Skyll Richard husbandman 601175 601175 Skyll, Richard, of Wherwell, or of Cramborne, husbandman 1
4032104 2036147 2036147 defendant Skyll Richard husbandman 601175 601175 Skyll, Richard, of Wherwell, or of Cramborne, husbandman 1
4549349 2215738 2215738 defendant Monk Hugh   601175 601175 Monk, Hugh, of Wherwell 0
4560222 2219147 2219147 defendant Hikkes John   601175 601175 Hikkes, John, of Wherwell 0
4596925 2230278 2230278 defendant Spaldyng John   601175 601175 Spaldyng, John, of Wherwell 2
4611162 2234554 2234554 defendant Smyth Thomas   601175 601175 Smyth, Thomas, of Wherwell 3
4778394 2289221 2289221 defendant Bussh John husbandman 601175 601175 (Bussh, John, of Wherwell, husbandman 4
4797308 2295331 2295331 defendant Dymmok John yeoman 601175 601175 Dymmok, John, of Wherwell, yeoman 1
4999182 2356627 2356627 defendant Wilshyre John husbandman 601175 601175 Wilshyre, John, of Wherwell, husbandman 0
4999183 2356627 2356627 defendant Tomber Richard   601175 601175 Tomber, Richard, of Wherwell, servant 1
5080976 2380809 2380809 defendant Marsfeld Robert tailor 601175 601175 Marsfeld, Robert, of Wherwell, tailor 0
5213349 2419635 2419635 defendant Wilteshire Thomas husbandman 601175 601175 Wilteshire, Thomas, of Wherwell, husbandman 0
5213350 2419635 2419635 defendant Ine or Ive John yeoman 601175 601175 Ine or Ive, John, of Wherwell, yeoman 1
5262304 2433960 2433960 defendant Hopkyn Robert tanner 601175 601175 Hopkyn, Robert, of Wherwell, tanner 3
5274029 2437481 2437481 plaintiff Overy Julian or Julia   601175 601175 Overy, Julian or Julia, of Wherwell, abbess of the House & church of St Cross 0
5396817 2474172 2474172 defendant Symkyns William smith 601175 601175 Symkyns, William, of Wherwell, smith 3
5516980 2510138 2510138 defendant Frelond Edward gent 601175 601175 Frelond, Edward, of Wherwell, gent 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);