names

24 rows where place_id = 604959

✎ 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
3659867 1913341 1913341 defendant Caryngton Thomas clerk 604959 604959 Caryngton, Thomas, of Stoke Doyle, clerk 0
3659868 1913341 1913341 defendant Arden Nicholas   604959 604959 Arden, Nicholas, of Stoke Doyle, tallow chandler 1
3659869 1913341 1913341 defendant Frayney William husbandman 604959 604959 Frayney, William, of Stoke Doyle, husbandman 2
4296908 2128994 2128994 defendant Slynne Andrew gent 604959 604959 Slynne, Andrew, of Stoke Doyle, or of Northampton, gent 0
4296910 2128995 2128995 defendant Willimott Timothy husbandman 604959 604959 Willimott, Timothy, of Stoke Doyle, husbandman 0
4316616 2135931 2135931 defendant Slynne Andrew gent 604959 604959 Slynne, Andrew, of Stoke Doyle, gent 0
4316618 2135932 2135932 defendant Willimott Timothy husbandman 604959 604959 Willimott, Timothy, of Stoke Doyle, husbandman 0
4330250 2140421 2140421 defendant Webstar alias Stanyarn John husbandman 604959 604959 Webstar alias Stanyarn, John, of Stoke Doyle, husbandman 0
4330251 2140421 2140421 defendant Webstar alias Stanyarn Richard tanner 604959 604959 Webstar alias Stanyarn, Richard, of Stoke Doyle, tanner 1
4332350 2141112 2141112 defendant Fidgin Hugh shoemaker 604959 604959 Fidgin, Hugh, of Stoke Doyle, shoemaker 0
4356602 2149542 2149542 defendant Stevens Thomas whitawer 604959 604959 Stevens, Thomas, of Stoke Doyle, whitawer 0
4532187 2210332 2210332 plaintiff Porter Richard   604959 604959 Porter, Richard, of Stoke Doyle 0
4694596 2263806 2263806 defendant Hylde John husbandman 604959 604959 Hylde, John, of Stoke Doyle, husbandman 2
4842363 2309144 2309144 defendant Chyk William husbandman 604959 604959 Chyk, William, of Stoke Doyle, husbandman 0
5068807 2377167 2377167 defendant Hylde Nicholas yeoman 604959 604959 Hylde, Nicholas, of Stoke Doyle, yeoman 1
5068811 2377168 2377168 defendant Hylde Nicholas yeoman 604959 604959 Hylde, Nicholas, of Stoke Doyle, yeoman 1
5143604 2399265 2399265 defendant Grene William husbandman 604959 604959 Grene, William, of Stoke Doyle, husbandman 2
5164759 2405426 2405426 defendant Grene William husbandman 604959 604959 Grene, William, of Stoke Doyle, husbandman 1
5178222 2409335 2409335 defendant Grene William husbandman 604959 604959 Grene, William, of Stoke Doyle, husbandman 0
5201338 2416149 2416149 defendant Grene William husbandman 604959 604959 Grene, William, of Stoke Doyle, husbandman 0
5259813 2433191 2433191 defendant Purdon John husbandman 604959 604959 Purdon, John, of Stoke Doyle, husbandman 1
5291887 2442632 2442632 defendant Grene William yeoman 604959 604959 Grene, William, of Stoke Doyle, yeoman 1
5377689 2468603 2468603 defendant Travers Simon husbandman 604959 604959 Travers, Simon, of Stoke Doyle, husbandman 0
5377690 2468603 2468603 defendant Seyton Nicholas husbandman 604959 604959 Seyton, Nicholas, of Stoke Doyle, 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);