names

23 rows where place_id = 596382

✎ 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
3624505 1875200 1875200 defendant Gerard Thomas yeoman 596382 596382 Gerard, Thomas, of Donyngton, Lincs, yeoman 0
3624506 1875200 1875200 defendant Brown William (legal representative) 596382 596382 Brown, William, of Donyngton, Lincs, yeoman, executor of 1
3647746 1909686 1909686 defendant Carre James yeoman 596382 596382 Carre, James, of Donyngton, Lincs, yeoman 0
3672776 1917492 1917492 defendant Hilton Roger gent 596382 596382 Hilton, Roger, of Donyngton, Lincs, gent 0
3672780 1917493 1917493 defendant Hilton Roger gent 596382 596382 Hilton, Roger, of Donyngton, Lincs, gent 0
3714977 1930980 1930980 defendant Botyll Richard yeoman 596382 596382 Botyll, Richard, of Donyngton, Lincs, yeoman 0
3715944 1931274 1931274 defendant Hylton Roger gent 596382 596382 Hylton, Roger, of Donyngton, Lincs, gent 0
3719777 1932449 1932449 defendant Botyll Richard yeoman 596382 596382 Botyll, Richard, of Donyngton, Lincs, yeoman 0
3784590 1952967 1952967 defendant Robert Henry yeoman 596382 596382 Robert, Henry, of Donyngton, Lincs, yeoman 3
3784596 1952968 1952968 defendant Robert Henry yeoman 596382 596382 Robert, Henry, of Donyngton, Lincs, yeoman 3
3831743 1967829 1967829 defendant Robert Henry husbandman 596382 596382 Robert, Henry, of Donyngton, Lincs, husbandman 1
3909613 1993521 1993521 defendant Hall Simon yeoman 596382 596382 Hall, Simon, of Donyngton, Lincs, yeoman 0
4217619 2101656 2101656 defendant Thurstone Thomas husbandman 596382 596382 Thurstone, Thomas, of Donyngton, Lincs, husbandman 0
4228585 2105480 2105480 defendant Grandorge William gent 596382 596382 Grandorge, William, of Donyngton, Lincs, gent 0
4532868 2210548 2210548 defendant Neweman Reginald   596382 596382 Neweman, Reginald, of Donyngton, Lincs, vicar 0
4532876 2210551 2210551 defendant Neweman Reginald   596382 596382 Neweman, Reginald, of Donyngton, Lincs, vicar 1
4682950 2260282 2260282 defendant Toplassh John husbandman 596382 596382 Toplassh, John, of Donyngton, Lincs, husbandman 0
4734209 2275880 2275880 defendant Tetenay John husbandman 596382 596382 Tetenay, John, of Donyngton, Lincs, husbandman 0
4774545 2288024 2288024 defendant Chese John   596382 596382 Chese, John, of Donyngton, Lincs, shoe maker 1
4854874 2312878 2312878 defendant Broun Simon merchant 596382 596382 Broun, Simon, of Donyngton, Lincs, merchant 0
5017461 2361995 2361995 defendant Tyther John   596382 596382 Tyther, John, of Donyngton, Lincs, merchant, administrators of 9
5017474 2361996 2361996 defendant Tyther John   596382 596382 Tyther, John, of Donyngton, Lincs, merchant, administrators of 9
5296666 2444010 2444010 defendant Nevyll John fisher 596382 596382 Nevyll, John, of Donyngton, Lincs, fisher 3

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