names

41 rows where place_id = 622292

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3746242 1940733 1940733 defendant Nederam Thomas clerk 622292 622292 Nederam, Thomas, of Corston, clerk 0
3760358 1945244 1945244 plaintiff Curat John gent 622292 622292 Curat, John, of Corston, gent 0
3760362 1945245 1945245 plaintiff Curat John gent 622292 622292 Curat, John, of Corston, gent 0
3822587 1964969 1964969 defendant Mylle John husbandman 622292 622292 Mylle, John, of Corston, husbandman 0
4166784 2083877 2083877 defendant Gardener William laborer 622292 622292 Gardener, William, of Corston, laborer 1
4225021 2104220 2104220 defendant Harrington Francis gent 622292 622292 Harrington, Francis, of Corston, gent 0
4225022 2104220 2104220 defendant Bilbie John yeoman 622292 622292 Bilbie, John, of Corston, yeoman 1
4466486 2190191 2190191 defendant Cook Thomas   622292 622292 Cook, Thomas, of Corston 0
4508003 2202971 2202971 defendant Holm John   622292 622292 Holm, John, of Corston 0
4509769 2203539 2203539 defendant Holm John   622292 622292 Holm, John, of Corston 0
4541646 2213282 2213282 defendant Dun John   622292 622292 Dun, John, of Corston 0
4600027 2231233 2231233 defendant Holm John   622292 622292 Holm, John, of Corston 0
4630709 2240502 2240502 defendant Holm John   622292 622292 Holm, John, of Corston 1
4638582 2242820 2242820 defendant Dolfyn Richard   622292 622292 Dolfyn, Richard, of Corston 0
4684796 2260843 2260843 defendant Do John husbandman 622292 622292 Do, John, of Corston, husbandman 1
4684797 2260843 2260843 defendant Gybbes William laborer 622292 622292 Gybbes, William, of Corston, laborer 2
4685048 2260923 2260923 defendant Gybbes John husbandman 622292 622292 Gybbes, John, of Corston, husbandman 0
4685050 2260923 2260923 defendant Gybbes William laborer 622292 622292 Gybbes, William, of Corston, laborer 2
4740155 2277638 2277638 defendant Barell Richard gent 622292 622292 Barell, Richard, of Corston, gent 0
4768136 2286005 2286005 defendant Barell Richard gent 622292 622292 Barell, Richard, of Corston, gent 0
4869660 2317476 2317476 plaintiff Lawes William   622292 622292 Lawes, William, of Corston 0
4911298 2330038 2330038 defendant Brewester John husbandman 622292 622292 Brewester, John, of Corston, husbandman 5
4919106 2332489 2332489 defendant Ynge Thomas gent 622292 622292 Ynge, Thomas, of Corston, gent 0
4922213 2333364 2333364 defendant Kyng John husbandman 622292 622292 Kyng, John, of Corston, husbandman 0
4922214 2333364 2333364 defendant Pryket Walter husbandman 622292 622292 Pryket, Walter, of Corston, husbandman 1
4962124 2345577 2345577 defendant Gander John   622292 622292 Gander, John, of Corston, wright 2
4973974 2349179 2349179 defendant Gilberd John husbandman 622292 622292 Gilberd, John, of Corston, husbandman 0
4997329 2356051 2356051 defendant Hyde Thomas yeoman 622292 622292 Hyde, Thomas, of Corston, yeoman 0
5135171 2396784 2396784 defendant Cole William husbandman 622292 622292 Cole, William, of Corston, husbandman 3
5135172 2396784 2396784 defendant Horwode Robert laborer 622292 622292 Horwode, Robert, of Corston, laborer 4
5148393 2400664 2400664 defendant Jacob John chaplain 622292 622292 Jacob, John, of Corston, chaplain 11
5167681 2406269 2406269 defendant Jacob John chaplain 622292 622292 Jacob, John, of Corston, chaplain 11
5247103 2429310 2429310 defendant Bawdewyn Edmund husbandman 622292 622292 Bawdewyn, Edmund, of Corston, husbandman 0
5284145 2440383 2440383 plaintiff Forster Robert   622292 622292 Forster, Robert, of Corston 0
5331233 2454414 2454414 defendant Baily William husbandman 622292 622292 Baily, William, of Corston, husbandman 0
5564317 2524176 2524176 defendant Duke Thomas clerk 622292 622292 Duke, Thomas, of Corston, clerk 0
5564318 2524176 2524176 defendant Taillour William husbandman 622292 622292 Taillour, William, of Corston, husbandman 1
5626680 2552318 2552318 defendant Baker William ploughman 622292 622292 Baker, William, of Corston, ploughman 0
5626681 2552318 2552318 defendant Bartelot Thomas husbandman 622292 622292 Bartelot, Thomas, of Corston, husbandman 1
5626682 2552318 2552318 defendant Felpys William ploughman 622292 622292 Felpys, William, of Corston, ploughman 2
5626683 2552318 2552318 defendant atte Well John ploughman 622292 622292 atte Well, John, of Corston, ploughman 3

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