names

37 rows where place_id = 599644

✎ 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
3637581 1906564 1906564 defendant Sprote Peter laborer 599644 599644 Sprote, Peter, of Brandesburton, laborer 2
3650974 1910674 1910674 defendant Palmer John yeoman 599644 599644 Palmer, John, of Brandesburton, yeoman 0
3842753 1971265 1971265 defendant Dalton William yeoman 599644 599644 Dalton, William, of Brandesburton, yeoman 0
4045881 2040974 2040974 defendant Wensley George esq 599644 599644 Wensley, George, of Brandesburton, esq 0
4045883 2040975 2040975 defendant Wensley George esq 599644 599644 Wensley, George, of Brandesburton, esq 0
4178449 2087936 2087936 defendant Dakyns Hillary gent 599644 599644 Dakyns, Hillary, of Brandesburton, gent 1
4178454 2087938 2087938 defendant Dakyns Hillary gent 599644 599644 Dakyns, Hillary, of Brandesburton, gent 1
4222865 2103486 2103486 defendant Fennyck George yeoman 599644 599644 Fennyck, George, of Brandesburton, yeoman 3
4254103 2114369 2114369 defendant Wensley John gent 599644 599644 Wensley, John, of Brandesburton, gent 0
4254108 2114370 2114370 defendant Wensley John gent 599644 599644 Wensley, John, of Brandesburton, gent 0
4314550 2135202 2135202 defendant Fowe Thomas yeoman 599644 599644 Fowe, Thomas, of Brandesburton, yeoman 0
4319387 2136887 2136887 defendant Dales John yeoman 599644 599644 Dales, John, of Brandesburton, yeoman 0
4319388 2136887 2136887 defendant Thompson Robert yeoman 599644 599644 Thompson, Robert, of Brandesburton, yeoman 1
4319389 2136887 2136887 defendant Johnson John yeoman 599644 599644 Johnson, John, of Brandesburton, yeoman 2
4319390 2136887 2136887 defendant Clarke Augustine yeoman 599644 599644 Clarke, Augustine, of Brandesburton, yeoman 3
4349432 2147064 2147064 defendant Wensley George gent 599644 599644 Wensley, George, of Brandesburton, gent 0
4349433 2147064 2147064 defendant Maxwell William husbandman 599644 599644 Maxwell, William, of Brandesburton, husbandman 1
4401678 2165157 2165157 defendant Maxwell William husbandman 599644 599644 Maxwell, William, of Brandesburton, husbandman 1
4480239 2194479 2194479 defendant St Martin Thomas de   599644 599644 St Martin, Thomas de, of Brandesburton, parson 0
4591062 2228559 2228559 defendant German William   599644 599644 German, William, of Brandesburton 0
4615030 2235712 2235712 defendant burton Thomas   599644 599644 burton, Thomas, of Brandesburton 2
4656021 2247765 2247765 defendant Sqwyer Thomsd husbandman 599644 599644 Sqwyer, Thomsd, of Brandesburton, husbandman 0
4667383 2255519 2255519 defendant Sqwyer Thomas husbandman 599644 599644 Sqwyer, Thomas, of Brandesburton, husbandman 4
4790376 2293073 2293073 defendant Kirton Edmund clerk 599644 599644 Kirton, Edmund, of Brandesburton, clerk 0
4872819 2318450 2318450 plaintiff Ouste John   599644 599644 Ouste, John, of Brandesburton 0
5049315 2371427 2371427 defendant Smyth John husbandman 599644 599644 Smyth, John, of Brandesburton, husbandman 0
5107922 2388756 2388756 defendant Cokson Richard chaplain 599644 599644 Cokson, Richard, of Brandesburton, chaplain 0
5114991 2390800 2390800 defendant Kirk Thomas husbandman 599644 599644 Kirk, Thomas, of Brandesburton, husbandman 2
5224714 2422897 2422897 defendant Herward Roger husbandman 599644 599644 Herward, Roger, of Brandesburton, husbandman 0
5228561 2423960 2423960 plaintiff Wencelagh John   599644 599644 Wencelagh, John, of Brandesburton 0
5228566 2423961 2423961 plaintiff Wencelagh John   599644 599644 Wencelagh, John, of Brandesburton 0
5228570 2423962 2423962 plaintiff Wencelagh John   599644 599644 Wencelagh, John, of Brandesburton 0
5250343 2430219 2430219 defendant Miton William laborer 599644 599644 Miton, William, of Brandesburton, laborer 0
5251341 2430518 2430518 plaintiff Wencelagh John   599644 599644 Wencelagh, John, of Brandesburton 1
5386046 2471080 2471080 defendant Petlyngton Robert husbandman 599644 599644 Petlyngton, Robert, of Brandesburton, husbandman 2
5398276 2474576 2474576 defendant Petlyngton Robert husbandman 599644 599644 Petlyngton, Robert, of Brandesburton, husbandman 2
5493536 2502980 2502980 defendant Haryngton Thomas chaplain 599644 599644 Haryngton, Thomas, of Brandesburton, chaplain 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);