names

36 rows where place_id = 586248

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3588259 1863982 1863982 defendant Dorlaston Nicholas husbandman 586248 586248 Dorlaston, Nicholas, of Wygynton, husbandman 0
3637517 1906544 1906544 defendant Ruggeley Nicholas yeoman 586248 586248 Ruggeley, Nicholas, of Wygynton, yeoman 2
3669623 1916438 1916438 defendant Crofte William husbandman 586248 586248 Crofte, William, of Wygynton, husbandman 0
3827971 1966615 1966615 defendant Harrys John husbandman 586248 586248 Harrys, John, of Wygynton, husbandman 2
3827989 1966619 1966619 defendant Harrys John husbandman 586248 586248 Harrys, John, of Wygynton, husbandman 1
3890612 1987124 1987124 defendant Haford John gent 586248 586248 Haford, John, of Wygynton, gent 0
4029203 2035089 2035089 defendant Shemond Thomas husbandman 586248 586248 Shemond, Thomas, of Wygynton, husbandman 0
4029204 2035089 2035089 defendant Shemond Bartholomew husbandman 586248 586248 Shemond, Bartholomew, of Wygynton, husbandman 1
4418045 2170523 2170523 defendant Baldewyn Thomas   586248 586248 Baldewyn, Thomas, of Wygynton 0
4424379 2172467 2172467 defendant Barre John de   586248 586248 Barre, John de, of Wygynton 0
4655260 2247530 2247530 defendant Ruggeley John gent 586248 586248 Ruggeley, John, of Wygynton, gent 1
4775773 2288421 2288421 defendant Notehurst Thomas husbandman 586248 586248 Notehurst, Thomas, of Wygynton, husbandman 0
4804395 2297558 2297558 defendant Eburton John clerk 586248 586248 Eburton, John, of Wygynton, clerk 0
4857348 2313683 2313683 defendant Eburton John clerk 586248 586248 Eburton, John, of Wygynton, clerk 0
4881913 2321241 2321241 defendant Blount John esq 586248 586248 Blount, John, of Wygynton, esq 0
4891341 2324021 2324021 defendant Kelyng Nicholas husbandman 586248 586248 Kelyng, Nicholas, of Wygynton, husbandman 1
4891342 2324021 2324021 defendant Mey John husbandman 586248 586248 Mey, John, of Wygynton, husbandman 2
4891343 2324021 2324021 defendant Lane Henry husbandman 586248 586248 Lane, Henry, of Wygynton, husbandman 3
4891344 2324021 2324021 defendant Dorlaston John husbandman 586248 586248 Dorlaston, John, of Wygynton, husbandman 4
4899080 2326355 2326355 defendant Mey John husbandman 586248 586248 Mey, John, of Wygynton, husbandman 2
4899081 2326355 2326355 defendant Lane Henry husbandman 586248 586248 Lane, Henry, of Wygynton, husbandman 3
4899082 2326355 2326355 defendant Dorlaston John husbandman 586248 586248 Dorlaston, John, of Wygynton, husbandman 4
4923436 2333757 2333757 defendant Ronvale Henry husbandman 586248 586248 Ronvale, Henry, of Wygynton, husbandman 0
4949130 2341718 2341718 defendant Tarte John yeoman 586248 586248 Tarte, John, of Wygynton, yeoman 0
4994193 2355138 2355138 defendant Kelyng Nicholas (legal representative) 586248 586248 Kelyng, Nicholas, of Wygynton, husbandman, executor of 2
4994194 2355138 2355138 defendant Kelyng Nicholas husbandman 586248 586248 Kelyng, Nicholas, of Wygynton, husbandman 3
5013481 2360779 2360779 defendant Bates Thomas husbandman 586248 586248 Bates, Thomas, of Wygynton, husbandman 4
5073926 2378688 2378688 defendant Dolfyn Robert smith 586248 586248 Dolfyn, Robert, of Wygynton, smith 19
5096966 2385546 2385546 defendant Tart Robert yeoman 586248 586248 Tart, Robert, of Wygynton, yeoman 0
5096967 2385546 2385546 defendant Tart John yeoman 586248 586248 Tart, John, of Wygynton, yeoman 1
5247875 2429516 2429516 defendant Knygeley Richard yeoman 586248 586248 Knygeley, Richard, of Wygynton, yeoman 3
5331081 2454365 2454365 defendant Dorlaston Nicholas husbandman 586248 586248 Dorlaston, Nicholas, of Wygynton, husbandman 0
5331083 2454366 2454366 defendant Dorlaston Nicholas husbandman 586248 586248 Dorlaston, Nicholas, of Wygynton, husbandman 0
5423954 2482118 2482118 defendant Crippis William husbandman 586248 586248 Crippis, William, of Wygynton, husbandman 4
5455768 2491624 2491624 defendant Crype William husbandman 586248 586248 Crype, William, of Wygynton, husbandman 3
5542499 2517776 2517776 defendant Dorlaston Nicholas husbandman 586248 586248 Dorlaston, Nicholas, of Wygynton, husbandman 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);