names

32 rows where place_id = 638406

✎ 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
3842281 1971130 1971130 defendant Scott William esq 638406 638406 Scott, William, of Smethe, Kent, esq 1
3842285 1971131 1971131 defendant Scott William esq 638406 638406 Scott, William, of Smethe, Kent, esq 1
3842289 1971132 1971132 defendant Scott William esq 638406 638406 Scott, William, of Smethe, Kent, esq 1
4583500 2226263 2226263 defendant Clerk Richard   638406 638406 Clerk, Richard, of Smethe, Kent 1
4583504 2226264 2226264 defendant Clerk Richard   638406 638406 Clerk, Richard, of Smethe, Kent 1
4806997 2298386 2298386 defendant Copherst John tailor 638406 638406 Copherst, John, of Smethe, Kent, tailor 1
4826418 2304299 2304299 defendant Passheley John   638406 638406 Passheley, John, of Smethe, Kent, knight 0
5041143 2368968 2368968 defendant Parys John husbandman 638406 638406 Parys, John, of Smethe, Kent, husbandman 1
5081216 2380887 2380887 defendant Passhele John esq 638406 638406 Passhele, John, of Smethe, Kent, esq 0
5094996 2384948 2384948 plaintiff Scot John esq 638406 638406 Scot, John, of Smethe, Kent, esq 0
5105804 2388144 2388144 defendant Passhelee John esq 638406 638406 Passhelee, John, of Smethe, Kent, esq 0
5147976 2400553 2400553 defendant Passhelee John esq 638406 638406 Passhelee, John, of Smethe, Kent, esq 0
5148097 2400589 2400589 defendant Passhelee John esq 638406 638406 Passhelee, John, of Smethe, Kent, esq 0
5150834 2401388 2401388 defendant Passhele John esq 638406 638406 Passhele, John, of Smethe, Kent, esq 0
5183036 2410783 2410783 defendant Passhle John esq 638406 638406 Passhle, John, of Smethe, Kent, esq 0
5189123 2412552 2412552 defendant Passheley John esq 638406 638406 Passheley, John, of Smethe, Kent, esq 0
5189133 2412554 2412554 defendant Passheley John esq 638406 638406 Passheley, John, of Smethe, Kent, esq 0
5215734 2420327 2420327 defendant mainpernors for Passhele John esq 638406 638406 mainpernors for Passhele, John, of Smethe, Kent, esq 4
5217261 2420782 2420782 defendant Passhele John esq 638406 638406 Passhele, John, of Smethe, Kent, esq 0
5217264 2420783 2420783 defendant Passhele John esq 638406 638406 Passhele, John, of Smethe, Kent, esq 0
5240347 2427390 2427390 defendant Skot John   638406 638406 Skot, John, of Smethe, Kent, knight 1
5240351 2427391 2427391 defendant Skot John   638406 638406 Skot, John, of Smethe, Kent, knight 1
5409219 2477723 2477723 defendant Ware Richard yeoman 638406 638406 Ware, Richard, of Smethe, Kent, yeoman 0
5422718 2481746 2481746 defendant Ware Richard yeoman 638406 638406 Ware, Richard, of Smethe, Kent, yeoman 0
5422720 2481747 2481747 defendant Ware Richard yeoman 638406 638406 Ware, Richard, of Smethe, Kent, yeoman 0
5455003 2491414 2491414 defendant Fynche John gent 638406 638406 Fynche, John, of Smethe, Kent, gent 0
5484678 2500341 2500341 defendant Hare or Hard Richard yeoman 638406 638406 Hare or Hard, Richard, of Smethe, Kent, yeoman 0
5484684 2500344 2500344 defendant Pympe Reginald gent 638406 638406 Pympe, Reginald, of Smethe, Kent, gent 0
5509849 2507918 2507918 defendant May William yeoman 638406 638406 May, William, of Smethe, Kent, yeoman 0
5509855 2507921 2507921 defendant Poneigl Edward   638406 638406 Poneigl, Edward, of Smethe, Kent, knight 0
5509858 2507922 2507922 defendant Ponyngys Edward   638406 638406 Ponyngys, Edward, of Smethe, Kent, knight 0
5509862 2507923 2507923 defendant Pympe Reginald gent 638406 638406 Pympe, Reginald, of Smethe, Kent, gent 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);