names

38 rows where place_id = 588515

✎ 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
3594787 1865995 1865995 defendant Johnson Thomas tailor 588515 588515 Johnson, Thomas, of Blaston, tailor 0
3853180 1974614 1974614 defendant Burton Richard husbandman 588515 588515 Burton, Richard, of Blaston, husbandman 0
3942972 2004656 2004656 plaintiff Yeman John clerk 588515 588515 Yeman, John, of Blaston, clerk 0
4317753 2136321 2136321 defendant Grey John esq 588515 588515 Grey, John, of Blaston, esq 0
4441225 2182187 2182187 plaintiff Bole John   588515 588515 Bole, John, of Blaston 0
4465872 2189991 2189991 defendant Kyriel Thomas   588515 588515 Kyriel, Thomas, of Blaston 0
4487920 2196944 2196944 defendant Neuton Ralph de   588515 588515 Neuton, Ralph de, of Blaston 0
4489558 2197454 2197454 defendant Murye John   588515 588515 Murye, John, of Blaston 0
4497341 2199815 2199815 defendant Neuton Ralph de   588515 588515 Neuton, Ralph de, of Blaston 0
4501423 2201049 2201049 defendant Gardyner William   588515 588515 Gardyner, William, of Blaston 1
4505464 2202238 2202238 defendant Neuton Ralph   588515 588515 Neuton, Ralph, of Blaston 0
4518611 2206193 2206193 defendant Walton Stephen   588515 588515 Walton, Stephen, of Blaston 0
4544923 2214331 2214331 defendant Caynell Richard   588515 588515 Caynell, Richard, of Blaston 0
4544925 2214332 2214332 defendant Haukyn Richard   588515 588515 Haukyn, Richard, of Blaston 0
4544926 2214332 2214332 defendant Wattesson Thomas   588515 588515 Wattesson, Thomas, of Blaston 1
4544927 2214332 2214332 defendant Gardyner William   588515 588515 Gardyner, William, of Blaston 2
4544928 2214332 2214332 defendant Judde Walter   588515 588515 Judde, Walter, of Blaston 3
4544929 2214332 2214332 defendant Caynell Richard   588515 588515 together with Caynell, Richard, of Blaston 4
4550487 2216096 2216096 defendant Caynell Richard   588515 588515 Caynell, Richard, of Blaston 0
4550489 2216097 2216097 defendant Haukyn Richard   588515 588515 Haukyn, Richard, of Blaston 0
4550490 2216097 2216097 defendant Wattesson Thomas   588515 588515 Wattesson, Thomas, of Blaston 1
4550491 2216097 2216097 defendant Gardyner William   588515 588515 Gardyner, William, of Blaston 2
4550492 2216097 2216097 defendant Judde Walter   588515 588515 Judde, Walter, of Blaston 3
4550493 2216097 2216097 defendant Caynell Richard   588515 588515 together with Caynell, Richard, of Blaston 4
4556214 2217882 2217882 defendant Neweton Ralph   588515 588515 Neweton, Ralph, of Blaston 7
4558130 2218482 2218482 defendant Neweton Ralph   588515 588515 Neweton, Ralph, of Blaston 3
4654629 2247328 2247328 defendant Seymour William, senior gent 588515 588515 Seymour, William, senior, of Blaston, gent 0
4668323 2255807 2255807 defendant Saymoure William, senior gent 588515 588515 Saymoure, William, senior, of Blaston, gent 0
4669427 2256144 2256144 defendant Seymour William gent 588515 588515 Seymour, William, of Blaston, gent 0
4670230 2256395 2256395 plaintiff Knyght John   588515 588515 (Knyght, John, of Blaston 1
4674853 2257745 2257745 defendant Leddebury Alexander skinner 588515 588515 Leddebury, Alexander, of Blaston, skinner 0
4677463 2258564 2258564 defendant Barton John clerk 588515 588515 Barton, John, of Blaston, clerk 0
4812048 2299882 2299882 defendant Laley William husbandman 588515 588515 Laley, William, of Blaston, husbandman 0
4889937 2323639 2323639 defendant Braunston Nicholas husbandman 588515 588515 Braunston, Nicholas, of Blaston, husbandman 0
4998951 2356566 2356566 defendant Newton Robert husbandman 588515 588515 Newton, Robert, of Blaston, husbandman 0
5025960 2364487 2364487 defendant Newton Robert husbandman 588515 588515 Newton, Robert, of Blaston, husbandman 0
5146972 2400255 2400255 defendant Webster Thomas yeoman 588515 588515 Webster, Thomas, of Blaston, yeoman 0
5400382 2475184 2475184 plaintiff Frye Thomas (legal representative) 588515 588515 Frye, Thomas, of Blaston, esqexecutor of 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);