names

34 rows where place_id = 623063

✎ 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
3750475 1942061 1942061 defendant Scott John yeoman 623063 623063 Scott, John, of Sandhurst, yeoman 0
3783840 1952717 1952717 defendant Scott John yeoman 623063 623063 Scott, John, of Sandhurst, yeoman 0
3787625 1953918 1953918 defendant Slythurst Richard husbandman 623063 623063 Slythurst, Richard, of Sandhurst, husbandman 0
3866603 1979057 1979057 defendant Marden Thomas yeoman 623063 623063 Marden, Thomas, of Sandhurst, yeoman 0
4196354 2094267 2094267 defendant Woodes Thomas husbandman 623063 623063 Woodes, Thomas, of Sandhurst, husbandman 1
4196355 2094267 2094267 defendant Cheslake Thomas yeoman 623063 623063 Cheslake, Thomas, of Sandhurst, yeoman 2
4387858 2160571 2160571 defendant Purlewent Margaret widow 623063 623063 Purlewent, Margaret, of Sandhurst, widow 1
4412202 2168674 2168674 defendant Symes Eleanor widow 623063 623063 Symes, Eleanor, of Sandhurst, widow 3
4438807 2181429 2181429 plaintiff atte Halle William   623063 623063 atte Halle, William, of Sandhurst 0
4603190 2232206 2232206 defendant Betrisden Robert   623063 623063 Betrisden, Robert, of Sandhurst 0
4603191 2232206 2232206 defendant Betrisden William   623063 623063 Betrisden, William, of Sandhurst 1
4603192 2232206 2232206 defendant Betrisden Richard   623063 623063 Betrisden, Richard, of Sandhurst 2
4604030 2232429 2232429 defendant Betrisden Robert   623063 623063 Betrisden, Robert, of Sandhurst 0
4604031 2232429 2232429 defendant Betrisden William   623063 623063 Betrisden, William, of Sandhurst 1
4604032 2232429 2232429 defendant Betrisden Richard   623063 623063 Betrisden, Richard, of Sandhurst 2
4609246 2233995 2233995 defendant Faukener William   623063 623063 Faukener, William, of Sandhurst 0
4625410 2238912 2238912 defendant Kent William   623063 623063 Kent, William, of Sandhurst 0
4757380 2282678 2282678 defendant Coppe Thomas laborer 623063 623063 Coppe, Thomas, of Sandhurst, laborer 1
4771943 2287197 2287197 defendant Thecchere William laborer 623063 623063 Thecchere, William, of Sandhurst, laborer 1
4813432 2300313 2300313 defendant Purlewent Thomas gent 623063 623063 Purlewent, Thomas, of Sandhurst, gent 0
4986557 2352907 2352907 defendant Beche John laborer 623063 623063 Beche, John, of Sandhurst, laborer 0
4995575 2355514 2355514 defendant Jacob John shoemaker 623063 623063 Jacob, John, of Sandhurst, shoemaker 0
4997359 2356060 2356060 defendant Purlewent Thomas gent 623063 623063 Purlewent, Thomas, of Sandhurst, gent 0
5028548 2365224 2365224 defendant Warde James husbandman 623063 623063 Warde, James, of Sandhurst, husbandman 0
5169318 2406761 2406761 defendant Murleyn James laborer 623063 623063 Murleyn, James, of Sandhurst, laborer 1
5176408 2408786 2408786 defendant Tusseley John husbandman 623063 623063 Tusseley, John, of Sandhurst, husbandman 0
5186000 2411654 2411654 defendant White Lawrence butcher 623063 623063 White, Lawrence, of Sandhurst, butcher 2
5205033 2417227 2417227 defendant White Lawrence butcher 623063 623063 White, Lawrence, of Sandhurst, butcher 2
5224268 2422770 2422770 defendant Bolseley Walter laborer 623063 623063 Bolseley, Walter, of Sandhurst, laborer 0
5262683 2434074 2434074 defendant Purlewent John gent 623063 623063 Purlewent, John, of Sandhurst, gent 0
5303685 2446097 2446097 defendant White James husbandman 623063 623063 White, James, of Sandhurst, husbandman 1
5323659 2452161 2452161 defendant Purlewent John gent 623063 623063 Purlewent, John, of Sandhurst, gent 0
5358387 2462676 2462676 defendant Purlewent John gent 623063 623063 Purlewent, John, of Sandhurst, gent 0
5479561 2498897 2498897 defendant Lewes John husbandman 623063 623063 Lewes, John, of Sandhurst, husbandman 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);