names

32 rows where place_id = 611052

✎ 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
3686536 1921938 1921938 defendant Wade Robert husbandman 611052 611052 Wade, Robert, of Blore, husbandman 3
3686539 1921939 1921939 defendant Wade Robert husbandman 611052 611052 Wade, Robert, of Blore, husbandman 0
3749391 1941727 1941727 defendant Grocoke Robert husbandman 611052 611052 Grocoke, Robert, of Blore, husbandman 0
3749392 1941727 1941727 defendant Preston John husbandman 611052 611052 Preston, John, of Blore, husbandman 1
4053868 2043761 2043761 defendant Bate John laborer 611052 611052 Bate, John, of Blore, laborer 1
4053869 2043761 2043761 defendant Atson Thomas tailor 611052 611052 Atson, Thomas, of Blore, tailor 2
4214186 2100479 2100479 defendant Cartwright William husbandman 611052 611052 Cartwright, William, of Blore, husbandman 3
4218618 2102009 2102009 defendant Wolley Humphrey husbandman 611052 611052 Wolley, Humphrey, of Blore, husbandman 1
4330297 2140436 2140436 defendant Cartwright William husbandman 611052 611052 Cartwright, William, of Blore, husbandman 2
4340165 2143821 2143821 defendant Wolley Humphrey husbandman 611052 611052 Wolley, Humphrey, of Blore, husbandman 1
4344507 2145358 2145358 defendant Willatt William laborer 611052 611052 Willatt, William, of Blore, laborer 0
4356240 2149405 2149405 defendant Cartwright William husbandman 611052 611052 Cartwright, William, of Blore, husbandman 0
4356242 2149406 2149406 defendant Langshawe Humphrey husbandman 611052 611052 Langshawe, Humphrey, of Blore, husbandman 0
4356244 2149407 2149407 defendant Jonson alias Smyth Andrew husbandman 611052 611052 Jonson alias Smyth, Andrew, of Blore, husbandman 0
4464701 2189628 2189628 defendant Swettok Hugh   611052 611052 Swettok, Hugh, of Blore 0
4678820 2258981 2258981 plaintiff Hycheman Henry   611052 611052 Hycheman, Henry, of Blore 0
5041536 2369070 2369070 defendant Okener Philip esq 611052 611052 Okener, Philip, of Blore, esq 1
5041540 2369070 2369070 defendant Hochyn Thomas yeoman 611052 611052 Hochyn, Thomas, of Blore, yeoman 5
5097201 2385616 2385616 defendant Basset Ralph esq 611052 611052 Basset, Ralph, of Blore, esq 0
5097202 2385616 2385616 defendant Basset William gent 611052 611052 Basset, William, of Blore, gent 1
5097203 2385616 2385616 defendant Basset Richard gent 611052 611052 Basset, Richard, of Blore, gent 2
5097204 2385616 2385616 defendant Walker Humphrey gent 611052 611052 Walker, Humphrey, of Blore, gent 3
5097205 2385616 2385616 defendant Dethike Oliver yeoman 611052 611052 Dethike, Oliver, of Blore, yeoman 4
5097206 2385616 2385616 defendant Ford Henry yeoman 611052 611052 Ford, Henry, of Blore, yeoman 5
5097213 2385616 2385616 defendant Asshenhurst John yeoman 611052 611052 Asshenhurst, John, of Blore, yeoman 12
5230603 2424563 2424563 plaintiff Basset William esq 611052 611052 Basset, William, of Blore, esq 0
5230606 2424564 2424564 plaintiff Basset William esq 611052 611052 Basset, William, of Blore, esq 0
5279610 2439115 2439115 defendant Hill William gent 611052 611052 Hill, William, of Blore, gent 0
5519529 2510950 2510950 defendant Cartelegge Ralph yeoman 611052 611052 Cartelegge, Ralph, of Blore, yeoman 1
5519530 2510950 2510950 defendant Geele Ralph yeoman 611052 611052 Geele, Ralph, of Blore, yeoman 2
5519531 2510950 2510950 defendant Bentley Thomas yeoman 611052 611052 Bentley, Thomas, of Blore, yeoman 3
5519534 2510950 2510950 defendant Brakley William yeoman 611052 611052 Brakley, William, of Blore, yeoman 6

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