names

41 rows where place_id = 585927

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3587518 1863743 1863743 defendant Staunton Humphrey gent 585927 585927 Staunton, Humphrey, of Bradford, Wilts, gent 0
3590801 1864762 1864762 defendant Stevyns John dyer 585927 585927 Stevyns, John, of Bradford, Wilts, dyer 0
3590804 1864763 1864763 defendant Stevyns John dyer 585927 585927 Stevyns, John, of Bradford, Wilts, dyer 0
3596191 1866437 1866437 defendant Halle Henry esq 585927 585927 Halle, Henry, of Bradford, Wilts, esq 0
3603607 1868797 1868797 defendant Hall Thomas gent 585927 585927 Hall, Thomas, of Bradford, Wilts, gent 0
3605622 1869423 1869423 defendant Vyner William clothier 585927 585927 Vyner, William, of Bradford, Wilts, clothier 0
3610320 1870884 1870884 defendant Baret Richard glover 585927 585927 Baret, Richard, of Bradford, Wilts, glover 0
3610322 1870885 1870885 defendant Baret Richard glover 585927 585927 Baret, Richard, of Bradford, Wilts, glover 0
3693465 1924169 1924169 defendant Palmer James clothman 585927 585927 Palmer, James, of Bradford, Wilts, clothman 0
3760428 1945264 1945264 defendant Pullen John husbandman 585927 585927 Pullen, John, of Bradford, Wilts, husbandman 0
3784291 1952877 1952877 defendant Berd John clothier 585927 585927 Berd, John, of Bradford, Wilts, clothier 1
3905951 1992276 1992276 defendant Hall Thomas gent 585927 585927 Hall, Thomas, of Bradford, Wilts, gent 0
3918833 1996622 1996622 defendant Lucas Thomas clothier 585927 585927 (Lucas, Thomas, of Bradford, Wilts, clothier 1
3918840 1996623 1996623 defendant Lucas Thomas clothier 585927 585927 (Lucas, Thomas, of Bradford, Wilts, clothier 1
3923844 1998283 1998283 defendant Rogers Anthony gent 585927 585927 Rogers, Anthony, of Bradford, Wilts, gent 0
3926430 1999169 1999169 defendant Lucas Robert clothier 585927 585927 (Lucas, Robert, of Bradford, Wilts, clothier 1
3928130 1999747 1999747 defendant Hall Thomas gent 585927 585927 Hall, Thomas, of Bradford, Wilts, gent 0
3928135 1999748 1999748 defendant Hall Thomas gent 585927 585927 Hall, Thomas, of Bradford, Wilts, gent 0
3936637 2002580 2002580 defendant Broune Edward gent 585927 585927 Broune, Edward, of Bradford, Wilts, gent 0
4017599 2031004 2031004 defendant Halle Thomas esq 585927 585927 Halle, Thomas, of Bradford, Wilts, esq 0
4026895 2034269 2034269 defendant Graunt Philip clothier 585927 585927 Graunt, Philip, of Bradford, Wilts, clothier 0
4193220 2093198 2093198 defendant Haull John esq 585927 585927 Haull, John, of Bradford, Wilts, esq 0
4300221 2130178 2130178 defendant Stevens Valentine chapman 585927 585927 Stevens, Valentine, of Bradford, Wilts, chapman 0
4358749 2150294 2150294 defendant Colls Robert husbandman 585927 585927 Colls, Robert, of Bradford, Wilts, husbandman 2
4816489 2301249 2301249 defendant Pay John chapman 585927 585927 Pay, John, of Bradford, Wilts, chapman 1
4816506 2301254 2301254 defendant Paye John chapman 585927 585927 Paye, John, of Bradford, Wilts, chapman 2
4923641 2333830 2333830 defendant Besile William gent 585927 585927 Besile, William, of Bradford, Wilts, gent 0
4928344 2335288 2335288 defendant Besyle William gent 585927 585927 Besyle, William, of Bradford, Wilts, gent 1
5199125 2415498 2415498 defendant Besyle William gent 585927 585927 Besyle, William, of Bradford, Wilts, gent 0
5217706 2420910 2420910 defendant Towker James clothier 585927 585927 Towker, James, of Bradford, Wilts, clothier 5
5265200 2434874 2434874 plaintiff Stoford William clothman 585927 585927 Stoford, William, of Bradford, Wilts, clothman 0
5268802 2435989 2435989 defendant Lysle Richard (legal representative) 585927 585927 Lysle, Richard, of Bradford, Wilts, gent, executors of 0
5293857 2443170 2443170 defendant Everard Thomas fyer 585927 585927 Everard, Thomas, of Bradford, Wilts, fyer 1
5293860 2443171 2443171 defendant Everard Thomas dyer 585927 585927 Everard, Thomas, of Bradford, Wilts, dyer 0
5296226 2443885 2443885 defendant Everard Thomas dyer 585927 585927 Everard, Thomas, of Bradford, Wilts, dyer 1
5326742 2453066 2453066 defendant Ponyng William yeoman 585927 585927 Ponyng, William, of Bradford, Wilts, yeoman 0
5362605 2463950 2463950 defendant Hill Thomas chapman 585927 585927 Hill, Thomas, of Bradford, Wilts, chapman 4
5392694 2472976 2472976 defendant Hickes Thomas husbandman 585927 585927 Hickes, Thomas, of Bradford, Wilts, husbandman 0
5405758 2476719 2476719 defendant Hickes Thomas husbandman 585927 585927 Hickes, Thomas, of Bradford, Wilts, husbandman 0
5405760 2476720 2476720 defendant Hickes Thomas husbandman 585927 585927 Hickes, Thomas, of Bradford, Wilts, husbandman 0
5595489 2533538 2533538 defendant Hall Thomas esq 585927 585927 Hall, Thomas, of Bradford, Wilts, esq 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);