names

49 rows where place_id = 592622

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3608276 1870246 1870246 plaintiff Sturmy John gent 592622 592622 Sturmy, John, of Knolle, gent 0
3659734 1913296 1913296 defendant Myllok William tyler 592622 592622 Myllok, William, of Knolle, tyler 1
3663235 1914425 1914425 defendant Bre-- Thomas husbandman 592622 592622 Bre--, Thomas, of Knolle, husbandman 1
3673287 1917661 1917661 defendant Elyott William, senior yeoman 592622 592622 Elyott, William, senior, of Knolle, yeoman 0
3673288 1917661 1917661 defendant Pety William gent 592622 592622 Pety, William, of Knolle, gent 1
3688325 1922505 1922505 defendant Eliott William tiler 592622 592622 Eliott, William, of Knolle, tiler 0
3720121 1932569 1932569 defendant Pratte John husbandman 592622 592622 Pratte, John, of Knolle, husbandman 0
3720122 1932569 1932569 defendant Baker Thomas laborer 592622 592622 Baker, Thomas, of Knolle, laborer 1
3722300 1933236 1933236 defendant Averey Thomas yeoman 592622 592622 Averey, Thomas, of Knolle, yeoman 0
3768042 1947640 1947640 defendant Palmer Robert husbandman 592622 592622 Palmer, Robert, of Knolle, husbandman 0
3785673 1953311 1953311 defendant Horborn Thomas husbandman 592622 592622 Horborn, Thomas, of Knolle, husbandman 0
3813803 1962231 1962231 defendant Norton Thomas gent 592622 592622 Norton, Thomas, of Knolle, gent 0
3813804 1962231 1962231 defendant Norton Mary widow 592622 592622 Norton, Mary, of Knolle, widow 1
4079061 2052811 2052811 defendant Palmer William yeoman 592622 592622 Palmer, William, of Knolle, yeoman 0
4079062 2052811 2052811 defendant Horborne Lawrence husbandman 592622 592622 Horborne, Lawrence, of Knolle, husbandman 1
4546109 2214727 2214727 defendant Jacson John   592622 592622 Jacson, John, of Knolle 0
4679091 2259066 2259066 defendant Smyth Richard husbandman 592622 592622 Smyth, Richard, of Knolle, husbandman 0
4755036 2281961 2281961 defendant Wylkokkys John husbandman 592622 592622 Wylkokkys, John, of Knolle, husbandman 0
4809749 2299212 2299212 defendant Veyne John husbandman 592622 592622 Veyne, John, of Knolle, husbandman 1
4810555 2299447 2299447 defendant Hugyn John husbandman 592622 592622 Hugyn, John, of Knolle, husbandman 0
4928521 2335347 2335347 plaintiff Smyth Richard   592622 592622 Smyth, Richard, of Knolle 0
5026331 2364592 2364592 defendant Knolle Richard husbandman 592622 592622 Knolle, Richard, of Knolle, husbandman 0
5074210 2378771 2378771 defendant Broun Richard gent 592622 592622 Broun, Richard, of Knolle, gent 0
5120189 2392345 2392345 defendant Parker William   592622 592622 Parker, William, of Knolle, friary clerk 0
5156219 2402981 2402981 defendant Broun Richard gent 592622 592622 Broun, Richard, of Knolle, gent 1
5156279 2402990 2402990 defendant Broun Richard gent 592622 592622 Broun, Richard, of Knolle, gent 2
5172501 2407682 2407682 defendant Broun Richard gent 592622 592622 Broun, Richard, of Knolle, gent 2
5191986 2413386 2413386 defendant Dorley Simon husbandman 592622 592622 Dorley, Simon, of Knolle, husbandman 3
5191999 2413389 2413389 defendant Broun Richard gent 592622 592622 Broun, Richard, of Knolle, gent 2
5192011 2413392 2413392 defendant Broun Ridhard gent 592622 592622 Broun, Ridhard, of Knolle, gent 1
5192016 2413393 2413393 defendant Broun Richard gent 592622 592622 Broun, Richard, of Knolle, gent 2
5233676 2425436 2425436 plaintiff Clencher Richard   592622 592622 Clencher, Richard, of Knolle 0
5253436 2431177 2431177 defendant Knyght Bartholomew gent 592622 592622 Knyght, Bartholomew, of Knolle, gent 0
5253438 2431178 2431178 defendant Knyght Bartholomew gent 592622 592622 Knyght, Bartholomew, of Knolle, gent 0
5262832 2434118 2434118 defendant Knyght Bartholomew esq 592622 592622 Knyght, Bartholomew, of Knolle, esq 0
5262838 2434119 2434119 defendant Knyght Bartholomew esq 592622 592622 Knyght, Bartholomew, of Knolle, esq 0
5327300 2453236 2453236 defendant Selke Richard yeoman 592622 592622 Selke, Richard, of Knolle, yeoman 0
5330884 2454307 2454307 defendant Halle John baker 592622 592622 Halle, John, of Knolle, baker 1
5393608 2473233 2473233 defendant Hole Robert husbandman 592622 592622 Hole, Robert, of Knolle, husbandman 0
5402971 2475931 2475931 defendant Michell Hugh laborer 592622 592622 Michell, Hugh, of Knolle, laborer 1
5418730 2480526 2480526 defendant Sturmy Agnes   592622 592622 Sturmy, Agnes, of Knolle, formerly wife of William 0
5432605 2484720 2484720 defendant Michell Hugh laborer 592622 592622 Michell, Hugh, of Knolle, laborer 1
5438657 2486497 2486497 defendant Hoper John yeoman 592622 592622 Hoper, John, of Knolle, yeoman 0
5464503 2494305 2494305 defendant Hoper John yeoman 592622 592622 Hoper, John, of Knolle, yeoman 0
5476022 2497842 2497842 defendant Hoper John husbandman 592622 592622 Hoper, John, of Knolle, husbandman 0
5476024 2497843 2497843 defendant Hoper John yeoman 592622 592622 Hoper, John, of Knolle, yeoman 0
5476026 2497844 2497844 defendant Hoper John yeoman 592622 592622 Hoper, John, of Knolle, yeoman 0
5485137 2500475 2500475 defendant Ayleston William husbandman 592622 592622 Ayleston, William, of Knolle, husbandman 0
5620272 2550198 2550198 defendant Crudie John   592622 592622 Crudie, John, of Knolle 1

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