names

22 rows where place_id = 615230

✎ 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
3707807 1928740 1928740 plaintiff Maye William tanner 615230 615230 Maye, William, of Drenkston, tanner 0
3773442 1949407 1949407 plaintiff Wren John esq 615230 615230 Wren, John, of Drenkston, esq 0
3779399 1951278 1951278 defendant Crente Roger tanner 615230 615230 Crente, Roger, of Drenkston, tanner 2
3795199 1956365 1956365 defendant Seman John husbandman 615230 615230 Seman, John, of Drenkston, husbandman 0
3795203 1956367 1956367 defendant Seman John husbandman 615230 615230 Seman, John, of Drenkston, husbandman 0
3797250 1957025 1957025 defendant Russhebroke Walter husbandman 615230 615230 Russhebroke, Walter, of Drenkston, husbandman 1
3834051 1968589 1968589 defendant Muskett William tanner 615230 615230 Muskett, William, of Drenkston, tanner 1
3834052 1968589 1968589 defendant Creme Roger tanner 615230 615230 Creme, Roger, of Drenkston, tanner 2
3873378 1981312 1981312 defendant Seman John husbandman 615230 615230 Seman, John, of Drenkston, husbandman 0
3876498 1982388 1982388 defendant Turnour John tailor 615230 615230 Turnour, John, of Drenkston, tailor 0
3918576 1996538 1996538 defendant Turnor James husbandman 615230 615230 Turnor, James, of Drenkston, husbandman 0
3922570 1997864 1997864 defendant Turnor James gent 615230 615230 Turnor, James, of Drenkston, gent 0
4667601 2255582 2255582 defendant Pumpy John smith 615230 615230 Pumpy, John, of Drenkston, smith 0
4667609 2255583 2255583 defendant Pumpy John smith 615230 615230 Pumpy, John, of Drenkston, smith 0
4897068 2325737 2325737 defendant Frauncebroun Alice widow 615230 615230 Frauncebroun, Alice, of Drenkston, widow 4
4906649 2328667 2328667 defendant Frauncebroun Alice widow 615230 615230 Frauncebroun, Alice, of Drenkston, widow 4
5078451 2380053 2380053 defendant Seman Roger   615230 615230 Seman, Roger, of Drenkston, wright 3
5118647 2391885 2391885 defendant Osteler Adam husbandman 615230 615230 Osteler, Adam, of Drenkston, husbandman 0
5118648 2391885 2391885 defendant Chetylbere Thomas husbandman 615230 615230 Chetylbere, Thomas, of Drenkston, husbandman 1
5118649 2391885 2391885 defendant Cokerell John husbandman 615230 615230 Cokerell, John, of Drenkston, husbandman 2
5118650 2391885 2391885 defendant Thressher John carpenter 615230 615230 Thressher, John, of Drenkston, carpenter 3
5344324 2458404 2458404 defendant Seman Thomas yeoman 615230 615230 Seman, Thomas, of Drenkston, yeoman 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);