names

34 rows where place_id = 602406

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3649986 1910362 1910362 defendant Smyth Richard clerk 602406 602406 Smyth, Richard, of Hagham, clerk 1
3677051 1918862 1918862 defendant Beare Robert husbandman 602406 602406 Beare, Robert, of Hagham, husbandman 0
3677052 1918862 1918862 defendant Chadworth John husbandman 602406 602406 Chadworth, John, of Hagham, husbandman 1
3715417 1931108 1931108 defendant Langcastre Thomas husbandman 602406 602406 Langcastre, Thomas, of Hagham, husbandman 0
3722617 1933332 1933332 defendant Lamastre Thomas yeoman 602406 602406 Lamastre, Thomas, of Hagham, yeoman 2
3729858 1935596 1935596 defendant Langcaster Thomas yeoman 602406 602406 Langcaster, Thomas, of Hagham, yeoman 0
3771139 1948663 1948663 defendant Lancaster Thomas yeoman 602406 602406 Lancaster, Thomas, of Hagham, yeoman 3
3780843 1951744 1951744 defendant Cresby John husbandman 602406 602406 Cresby, John, of hagham, husbandman 1
3788850 1954317 1954317 defendant Lancastre Thomas husbandman 602406 602406 Lancastre, Thomas, of Hagham, husbandman 0
3801365 1958353 1958353 defendant Lancaster Thomas yeoman 602406 602406 Lancaster, Thomas, of Hagham, yeoman 0
4420576 2171339 2171339 plaintiff Busshy John   602406 602406 Busshy, John, of Hagham, knight 0
4421359 2171584 2171584 defendant Bussy John   602406 602406 Bussy, John, of Hagham, knight 0
4421361 2171585 2171585 defendant Bussy John   602406 602406 Bussy, John, of Hagham, knight 0
4444444 2183241 2183241 defendant Gilliot Roger   602406 602406 Gilliot, Roger, of Hagham, servant of Robert 3
4463027 2189137 2189137 defendant Hagh John   602406 602406 Hagh, John, of Hagham, servant of the parson 6
4559170 2218820 2218820 defendant Toures William   602406 602406 Toures, William, of Hagham, vicar 0
4564717 2220529 2220529 defendant Toures William   602406 602406 Toures, William, of Hagham, vicar 0
4570095 2222221 2222221 defendant Skynner Thomas   602406 602406 Skynner, Thomas, of Hagham 0
4594808 2229630 2229630 plaintiff Proktour John   602406 602406 Proktour, John, of Hagham 0
4594809 2229630 2229630 defendant Margretson Robert   602406 602406 Margretson, Robert, of Hagham 0
4594810 2229631 2229631 plaintiff Proktour John   602406 602406 Proktour, John, of Hagham 0
4594812 2229632 2229632 plaintiff Proktour John   602406 602406 Proktour, John, of Hagham 0
4594813 2229632 2229632 defendant Tours William   602406 602406 Tours, William, of Hagham, vicar 0
4712778 2269311 2269311 plaintiff Spencer Robert   602406 602406 Spencer, Robert, of Hagham 0
4719008 2271292 2271292 defendant Spenser Robert husbandman 602406 602406 Spenser, Robert, of Hagham, husbandman 2
5135352 2396843 2396843 defendant Potell Henry   602406 602406 Potell, Henry, of Hagham, vicar 0
5155595 2402790 2402790 defendant Potell Henry   602406 602406 Potell, Henry, of Hagham, vicar 0
5172167 2407579 2407579 defendant Potell Henry   602406 602406 Potell, Henry, of Hagham, vicar 0
5191324 2413200 2413200 defendant Potell Henry   602406 602406 Potell, Henry, of Hagham, vicar 0
5207289 2417872 2417872 defendant Potell Henry   602406 602406 Potell, Henry, of Hagham, vicar 0
5289749 2442007 2442007 defendant Thorp Roger gent 602406 602406 Thorp, Roger, of Hagham, gent 0
5320362 2451176 2451176 defendant Halle Thomas husbandman 602406 602406 Halle, Thomas, of Hagham, husbandman 1
5326151 2452914 2452914 defendant Bowede Robert husbandman 602406 602406 Bowede, Robert, of Hagham, husbandman 0
5573893 2526932 2526932 defendant Michelson Robert husbandman 602406 602406 Michelson, Robert, of Hagham, 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);