names

23 rows where place_id = 622288

✎ 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
3746216 1940724 1940724 defendant Colcell Thomas husbandman 622288 622288 Colcell, Thomas, of Wyng, Bucks, husbandman 1
3811768 1961579 1961579 defendant Colsell Thomas husbandman 622288 622288 Colsell, Thomas, of Wyng, Bucks, husbandman 2
3811772 1961580 1961580 defendant Colsell Thomas husbandman 622288 622288 Colsell, Thomas, of Wyng, Bucks, husbandman 2
3884358 1985036 1985036 defendant More John, junior gent 622288 622288 More, John, junior, of Wyng, Bucks, gent 0
3891202 1987324 1987324 defendant Jackeman William, senior yeoman 622288 622288 Jackeman, William, senior, of Wyng, Bucks, yeoman 0
3891205 1987325 1987325 defendant Jackeman William, senior yeoman 622288 622288 Jackeman, William, senior, of Wyng, Bucks, yeoman 0
3934577 2001860 2001860 defendant More John gent 622288 622288 More, John, of Wyng, Bucks, gent 0
4889017 2323355 2323355 plaintiff Funtayn William   622288 622288 Funtayn, William, of Wyng, Bucks 0
4896326 2325516 2325516 plaintiff Funtayn William   622288 622288 Funtayn, William, of Wyng, Bucks 0
4924748 2334175 2334175 defendant Fountayn William chapman 622288 622288 Fountayn, William, of Wyng, Bucks, chapman 1
5249976 2430104 2430104 defendant Rokes Thomas esq 622288 622288 Rokes, Thomas, of Wyng, Bucks, esq 0
5288163 2441557 2441557 defendant Founteyn William chapman 622288 622288 Founteyn, William, of Wyng, Bucks, chapman 0
5308299 2447515 2447515 defendant Rokys John   622288 622288 Rokys, John, of Wyng, Bucks 0
5390435 2472327 2472327 plaintiff Meriden John, senior glasier 622288 622288 Meriden, John, senior, of Wyng, Bucks, glasier 0
5403392 2476044 2476044 plaintiff Meryden John   622288 622288 Meryden, John, of Wyng, Bucks 0
5407279 2477144 2477144 defendant Merden alias More John, senior grasier 622288 622288 Merden alias More, John, senior, of Wyng, Bucks, grasier 0
5504389 2506289 2506289 defendant Clobber Thomas husbandman 622288 622288 Clobber, Thomas, of Wyng, Bucks, husbandman 0
5509197 2507735 2507735 plaintiff Founten Nicholas woolman 622288 622288 Founten, Nicholas, of Wyng, Bucks, woolman 0
5540220 2517070 2517070 defendant Colshyll Thomas yeoman 622288 622288 Colshyll, Thomas, of Wyng, Bucks, yeoman 1
5540224 2517071 2517071 defendant Colshyll Thomas yeoman 622288 622288 Colshyll, Thomas, of Wyng, Bucks, yeoman 1
5549431 2519886 2519886 defendant Rollys John chapman 622288 622288 Rollys, John, of Wyng, Bucks, chapman 3
5588140 2531298 2531298 defendant Blacknoll William grasier 622288 622288 Blacknoll, William, of Wyng, Bucks, grasier 0
5601294 2535297 2535297 defendant Blakenall William, senior grasier 622288 622288 Blakenall, William, senior, of Wyng, Bucks, grasier 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);