names

38 rows where place_id = 593121

✎ 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
3610572 1870971 1870971 defendant Peers Richard yeoman 593121 593121 Peers, Richard, of Elford, yeoman 0
3611855 1871369 1871369 defendant Peers Richard yeoman 593121 593121 Peers, Richard, of Elford, yeoman 0
3764418 1946533 1946533 defendant Wynter William clerk 593121 593121 Wynter, William, of Elford, clerk 0
3774052 1949600 1949600 defendant Slowe Nicholas chaplain 593121 593121 Slowe, Nicholas, of Elford, chaplain 0
3804639 1959391 1959391 plaintiff Smyth William (legal representative) 593121 593121 Smyth, William, of Elford, knight, executors of 0
3912695 1994580 1994580 defendant Huddelston Richard esq 593121 593121 Huddelston, Richard, of Elford, esq 0
3926022 1999023 1999023 plaintiff Ardern Nicholas gent 593121 593121 Ardern, Nicholas, of Elford, gent 0
3926023 1999023 1999023 defendant Huddelston Richard esq 593121 593121 Huddelston, Richard, of Elford, esq 0
3941889 2004299 2004299 defendant Clerke John laborer 593121 593121 Clerke, John, of Elford, laborer 3
4024948 2033586 2033586 plaintiff Bowes John esq 593121 593121 Bowes, John, of Elford, esq 0
4039422 2038724 2038724 defendant Bowes Edward gent 593121 593121 Bowes, Edward, of Elford, gent 2
4167637 2084177 2084177 defendant Smyth Thomas husbandman 593121 593121 Smyth, Thomas, of Elford, husbandman 3
4209084 2098726 2098726 defendant Chapman George miller 593121 593121 Chapman, George, of Elford, miller 2
4703018 2266326 2266326 defendant Walwayne William gent 593121 593121 Walwayne, William, of Elford, gent 0
4713366 2269503 2269503 defendant Holme John   593121 593121 Holme, John, of Elford, parson 2
4715448 2270168 2270168 defendant Hastynges Bartholomew gent 593121 593121 Hastynges, Bartholomew, of Elford, gent 0
4747902 2279893 2279893 defendant Lokwod William husbandman 593121 593121 Lokwod, William, of Elford, husbandman 0
4801979 2296803 2296803 defendant Lokwode William husbandman 593121 593121 Lokwode, William, of Elford, husbandman 0
4983418 2351948 2351948 defendant Wytyng William husbandman 593121 593121 Wytyng, William, of Elford, husbandman 1
5034144 2366853 2366853 plaintiff Stansey Thomas   593121 593121 Stansey, Thomas, of Elford 0
5120496 2392423 2392423 plaintiff Stanley Thomas esq 593121 593121 Stanley, Thomas, of Elford, esq 0
5120498 2392424 2392424 plaintiff Stanley Thomas esq 593121 593121 Stanley, Thomas, of Elford, esq 0
5271684 2436819 2436819 defendant Odam William laborer 593121 593121 Odam, William, of Elford, laborer 0
5271685 2436819 2436819 defendant Odam Walter husbandman 593121 593121 Odam, Walter, of Elford, husbandman 1
5282479 2439938 2439938 defendant Hastyng Edward gent 593121 593121 Hastyng, Edward, of Elford, gent 0
5301451 2445386 2445386 defendant Hastyng Edward gent 593121 593121 Hastyng, Edward, of Elford, gent 0
5404152 2476266 2476266 defendant Broun Roger husbandman 593121 593121 Broun, Roger, of Elford, husbandman 3
5417299 2480093 2480093 defendant Broun Roger husbandman 593121 593121 Broun, Roger, of Elford, husbandman 2
5434540 2485273 2485273 defendant Broun Roger husbandman 593121 593121 Broun, Roger, of Elford, husbandman 3
5434547 2485274 2485274 defendant Broun Roger husbandman 593121 593121 Broun, Roger, of Elford, husbandman 3
5487064 2501029 2501029 plaintiff Stanley John esq 593121 593121 Stanley, John, of Elford, esq 0
5517955 2510459 2510459 defendant Dilworth Thomas yeoman 593121 593121 Dilworth, Thomas, of Elford, yeoman 0
5547989 2519443 2519443 defendant Delworth Thomas yeoman 593121 593121 Delworth, Thomas, of Elford, yeoman 0
5547992 2519444 2519444 defendant Dylworth Thomas yeoman 593121 593121 Dylworth, Thomas, of Elford, yeoman 0
5551660 2520525 2520525 defendant Hall James clerk 593121 593121 Hall, James, of Elford, clerk 0
5561833 2523448 2523448 defendant Hastynges Edward gent 593121 593121 Hastynges, Edward, of Elford, gent 0
5561834 2523448 2523448 defendant Hastynges John gent 593121 593121 Hastynges, John, of Elford, gent 1
5607220 2537146 2537146 defendant Wytton Christopher clerk 593121 593121 Wytton, Christopher, of Elford, clerk 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);