names

25 rows where place_id = 638136

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3840727 1970667 1970667 defendant Graydon William husbandman 638136 638136 Graydon, William, of Harton, husbandman 0
3840728 1970667 1970667 defendant Sysson William husbandman 638136 638136 Sysson, William, of Harton, husbandman 1
3840729 1970667 1970667 defendant Flayworth John husbandman 638136 638136 Flayworth, John, of Harton, husbandman 2
3915129 1995419 1995419 defendant Esyngton Christopher husbandman 638136 638136 Esyngton, Christopher, of Harton, husbandman 0
4092720 2057707 2057707 defendant Lyster Nicholas yeoman 638136 638136 Lyster, Nicholas, of Harton, yeoman 0
4092721 2057707 2057707 defendant Lyster John yeoman 638136 638136 Lyster, John, of Harton, yeoman 1
4358639 2150259 2150259 defendant Bull William gent 638136 638136 Bull, William, of Harton, Old Radnor, Radnor, gent 0
4360741 2151013 2151013 defendant Bull or Boole William gent 638136 638136 Bull or Boole, William, of Harton, gent 0
4807295 2298479 2298479 defendant Wright William husbandman 638136 638136 Wright, William, of Harton, husbandman 4
4835964 2307230 2307230 defendant Skepper John husbandman 638136 638136 Skepper, John, of Harton, husbandman 0
4835965 2307230 2307230 defendant Skepper Thomas husbandman 638136 638136 Skepper, Thomas, of Harton, husbandman 1
4853238 2312430 2312430 defendant Skepper John husbandman 638136 638136 Skepper, John, of Harton, husbandman 2
4853240 2312430 2312430 defendant Wright William husbandman 638136 638136 Wright, William, of Harton, husbandman 4
4854180 2312716 2312716 defendant Ipe Thomas husbandman 638136 638136 Ipe, Thomas, of Harton, husbandman 0
4868355 2317078 2317078 defendant Watson Richard husbandman 638136 638136 Watson, Richard, of Harton, husbandman 7
4868629 2317161 2317161 defendant Watson Richard husbandman 638136 638136 Watson, Richard, of Harton, husbandman 7
5238759 2426926 2426926 defendant Person William husbandman 638136 638136 Person, William, of Harton, husbandman 5
5335901 2455806 2455806 defendant Sendall alias Cardyff John tailor 638136 638136 Sendall alias Cardyff, John, of Harton, tailor 0
5467654 2495254 2495254 defendant Waldron Thomas husbandman 638136 638136 Waldron, Thomas, of Harton, husbandman 0
5552967 2520910 2520910 defendant Lilley Nicholas yeoman 638136 638136 Lilley, Nicholas, of Harton, yeoman 1
5553571 2521079 2521079 defendant Lylly John yeoman 638136 638136 Lylly, John, of Harton, yeoman 0
5553572 2521079 2521079 defendant Clerk Brian yeoman 638136 638136 Clerk, Brian, of Harton, yeoman 1
5553574 2521080 2521080 defendant Lylly John yeoman 638136 638136 Lylly, John, of Harton, yeoman 0
5553575 2521080 2521080 defendant Clerk Brian yeoman 638136 638136 Clerk, Brian, of Harton, yeoman 1
5553580 2521081 2521081 defendant Lylly Nicholas yeoman 638136 638136 Lylly, Nicholas, of Harton, yeoman 3

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);