names

33 rows where place_id = 602456

✎ 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
3650221 1910438 1910438 defendant Butteler Thomas yeoman 602456 602456 Butteler, Thomas, of Brympton, yeoman 0
3717051 1931618 1931618 defendant Burneham William yeoman 602456 602456 Burneham, William, of Brympton, yeoman 1
3774966 1949903 1949903 defendant Burneham John husbandman 602456 602456 Burneham, John, of Brympton, husbandman 0
3804259 1959264 1959264 defendant Burnham John husbandman 602456 602456 Burnham, John, of Brympton, husbandman 1
3809927 1960993 1960993 plaintiff Boldrell Thomas (legal representative) 602456 602456 Boldrell, Thomas, of Brympton, gent, executors of 0
3903028 1991240 1991240 defendant Wygemore William husbandman 602456 602456 Wygemore, William, of Brympton, husbandman 0
3962364 2011422 2011422 defendant Sydenham Ursula widow 602456 602456 Sydenham, Ursula, of Brympton, widow 0
3962365 2011422 2011422 defendant Sampforde Thomas husbandman 602456 602456 Sampforde, Thomas, of Brympton, husbandman 1
4113503 2065110 2065110 plaintiff Sydenham John   602456 602456 Sydenham, John, of Brympton, knight 0
4159114 2081258 2081258 defendant Sydenham John   602456 602456 Sydenham, John, of Brympton, knight 0
4250580 2113179 2113179 defendant Sidenham John esq 602456 602456 Sidenham, John, of Brympton, esq 0
4307473 2132752 2132752 defendant Sydenham John (legal representative) 602456 602456 Sydenham, John, of Brympton, knight, executor of 0
4461502 2188677 2188677 plaintiff Staynton Simon de   602456 602456 Staynton, Simon de, of Brympton, parson 0
4823515 2303443 2303443 defendant Blenche Thomas fletcher 602456 602456 Blenche, Thomas, of Brympton, fletcher 0
4861722 2315037 2315037 defendant Taillour Humphrey tailor 602456 602456 Taillour, Humphrey, of Brympton, tailor 0
4865410 2316150 2316150 defendant Taillour Humphrey tailor 602456 602456 Taillour, Humphrey, of Brympton, tailor 3
4877619 2319959 2319959 plaintiff Stokes John   602456 602456 Stokes, John, of Brympton 0
4954187 2343225 2343225 defendant Stok John gent 602456 602456 Stok, John, of Brympton, gent 0
4961545 2345417 2345417 defendant Alten Humphrey tailor 602456 602456 Alten, Humphrey, of Brympton, tailor 2
4980520 2351113 2351113 defendant Stokys John   602456 602456 Stokys, John, of Brympton, Berks gent 0
4981090 2351276 2351276 plaintiff Stokes John   602456 602456 Stokes, John, of Brympton 0
5009278 2359600 2359600 defendant Milleward Henry husbandman 602456 602456 Milleward, Henry, of Brympton, husbandman 2
5084413 2381849 2381849 defendant Carewe William clerk 602456 602456 Carewe, William, of Brympton, clerk 0
5088756 2383088 2383088 defendant Stokys John gent 602456 602456 Stokys, John, of Brympton, gent 0
5126818 2394317 2394317 defendant Marke John clerk 602456 602456 Marke, John, of Brympton, clerk 2
5134190 2396495 2396495 defendant Stokys John gent 602456 602456 Stokys, John, of Brympton, gent 0
5145512 2399831 2399831 defendant Marke John clerk 602456 602456 Marke, John, of Brympton, clerk 2
5154098 2402357 2402357 defendant Stokys John gent 602456 602456 Stokys, John, of Brympton, gent 0
5165917 2405776 2405776 defendant Marke John clerk 602456 602456 Marke, John, of Brympton, clerk 2
5171296 2407328 2407328 defendant Stokys John gent 602456 602456 Stokys, John, of Brympton, gent 0
5189632 2412713 2412713 defendant Stokys John gent 602456 602456 Stokys, John, of Brympton, gent 0
5206579 2417657 2417657 defendant Stokys John gent 602456 602456 Stokys, John, of Brympton, gent 0
5585458 2530520 2530520 defendant Exyle Lewis, senior husbandman 602456 602456 Exyle, Lewis, senior, of Brympton, husbandman 4

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