names

16 rows where place_id = 599201

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: case_id, role, surname, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3635712 1905970 1905970 defendant Brystowe John gent 599201 599201 Brystowe, John, of Croston, gent 0
3686429 1921911 1921911 plaintiff Bristo John esq 599201 599201 Bristo, John, of Croston, Cumber, esq 0
3696425 1925107 1925107 defendant Bristo John gent 599201 599201 Bristo, John, of Croston, gent 0
3696426 1925107 1925107 defendant Bristo Richard gent 599201 599201 Bristo, Richard, of Croston, gent 1
4095743 2058810 2058810 defendant Worsley Edward yeoman 599201 599201 Worsley, Edward, of Croston, yeoman 3
4125812 2069515 2069515 defendant Hornsey John husbandman 599201 599201 Hornsey, John, of Croston, husbandman 1
4149034 2077781 2077781 defendant Hornsey John yeoman 599201 599201 Hornsey, John, of Croston, yeoman 1
4532273 2210361 2210361 defendant Sare John   599201 599201 Sare, John, of Croston 0
4689215 2262185 2262185 defendant Courte Henry shipman 599201 599201 Courte, Henry, of Croston, shipman 1
4703894 2266594 2266594 defendant Roberdston Roberdson husbandman 599201 599201 Roberdston, Roberdson, of Croston, husbandman 2
5020327 2362830 2362830 defendant Scotte Richard husbandman 599201 599201 Scotte, Richard, of Croston, husbandman 14
5280127 2439260 2439260 defendant Collas Thomas   599201 599201 Collas, Thomas, of Croston, franklin 1
5291244 2442443 2442443 defendant Assheton Hugh esq 599201 599201 Assheton, Hugh, of Croston, esq 1
5426622 2482911 2482911 defendant Alpe John maltman 599201 599201 Alpe, John, of Croston, maltman 0
5493608 2503003 2503003 defendant Lamberd Thomas yeoman 599201 599201 Lamberd, Thomas, of Croston, yeoman 0
5581867 2529407 2529407 plaintiff Croseley John yeoman 599201 599201 Croseley, John, of Croston, yeoman 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);