names

23 rows where place_id = 590813

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3602389 1868408 1868408 defendant Shoyle William innholder 590813 590813 Shoyle, William, of Blanford Forum, Dorset, innholder 0
3884757 1985176 1985176 defendant Ryve John yeoman 590813 590813 Ryve, John, of Blanford Forum, Dorset, yeoman 0
4002211 2025575 2025575 defendant Keynoll John mercer 590813 590813 Keynoll, John, of Blanford Forum, Dorset, mercer 0
4003614 2026058 2026058 defendant Hatchett John chapman 590813 590813 Hatchett, John, of Blanford Forum, Dorset, chapman 0
4023569 2033138 2033138 plaintiff Bastard Joan widow of Thomas Basterd 590813 590813 Bastard, Joan, of Blanford Forum, Dorset, widow of Thomas Basterd 0
4033269 2036553 2036553 defendant Pynge William chapman 590813 590813 Pynge, William, of Blanford Forum, Dorset, chapman 0
4033272 2036554 2036554 defendant Pynge William chapman 590813 590813 Pynge, William, of Blanford Forum, Dorset, chapman 0
4051183 2042860 2042860 defendant Cheverell Richard draper 590813 590813 Cheverell, Richard, of Blanford Forum, Dorset, draper 0
4259080 2116008 2116008 defendant Whittell Henry merchant 590813 590813 Whittell, Henry, of Blanford Forum, Dorset, merchant 2
4293795 2127849 2127849 defendant Pytt John, junior   590813 590813 Pytt, John, junior, of Blanford Forum, Dorset, woollen draper 0
4324650 2138636 2138636 defendant Pytt John, junior   590813 590813 Pytt, John, junior, of Blanford Forum, Dorset, woollen draper 0
4395149 2162965 2162965 defendant Ryves alias Rewff Robert mercer 590813 590813 Ryves alias Rewff, Robert, of Blanford Forum, Dorset, mercer 0
4849630 2311364 2311364 defendant Carpynter John cutler 590813 590813 Carpynter, John, of Blanford Forum, Dorset, cutler 0
4971380 2348368 2348368 defendant Dyer William dyer 590813 590813 Dyer, William, of Blanford Forum, Dorset, dyer 1
5097391 2385668 2385668 defendant Bawe alias Smyth John smith 590813 590813 (Bawe alias Smyth, John, of Blanford Forum, Dorset, smith 1
5192520 2413545 2413545 defendant Rale Simon   590813 590813 Rale, Simon, of Blanford Forum, Dorset 1
5213365 2419639 2419639 defendant Ekeford John chapman 590813 590813 Ekeford, John, of Blanford Forum, Dorset, chapman 1
5218334 2421095 2421095 defendant Vode John   590813 590813 Vode, John, of Blanford Forum, Dorset, groom 1
5239700 2427198 2427198 defendant Hulle John yeoman 590813 590813 Hulle, John, of Blanford Forum, Dorset, yeoman 2
5277898 2438623 2438623 defendant Wolsell John woolmonger 590813 590813 Wolsell, John, of Blanford Forum, Dorset, woolmonger 0
5482711 2499772 2499772 defendant Cryme John husbandman 590813 590813 Cryme, John, of Blanford Forum, Dorset, husbandman 2
5495822 2503646 2503646 defendant Cryne or Cryve John husbandman 590813 590813 Cryne or Cryve, John, of Blanford Forum, Dorset, husbandman 0
5495826 2503647 2503647 defendant Cryne or Cryve John husbandman 590813 590813 Cryne or Cryve, John, of Blanford Forum, Dorset, husbandman 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);