names

34 rows where place_id = 636480

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3831030 1967588 1967588 defendant Adene James laborer 636480 636480 Adene, James, of Lydney, laborer 0
3834298 1968671 1968671 defendant Pembrigge Thomas yeoman 636480 636480 Pembrigge, Thomas, of Lydney, yeoman 1
3834341 1968684 1968684 defendant Pembrigge Thomas yeoman 636480 636480 Pembrigge, Thomas, of Lydney, yeoman 1
3834345 1968685 1968685 defendant Pembrigge Thomas yeoman 636480 636480 Pembrigge, Thomas, of Lydney, yeoman 1
3946091 2005708 2005708 defendant Jones Charles yeoman 636480 636480 Jones, Charles, of Lydney, yeoman 0
3946092 2005708 2005708 defendant Skydmore William husbandman 636480 636480 Skydmore, William, of Lydney, husbandman 1
4057166 2044947 2044947 defendant Goughe Robert yeoman 636480 636480 Goughe, Robert, of Lydney, yeoman 2
4105716 2062333 2062333 defendant Tayler Thomas yeoman 636480 636480 Tayler, Thomas, of Lydney, yeoman 0
4167873 2084248 2084248 defendant Goughe Robert yeoman 636480 636480 Goughe, Robert, of Lydney, yeoman 2
4219931 2102472 2102472 defendant Morton Thomas tailor 636480 636480 Morton, Thomas, of Lydney, or of Magna Deane, tailor 0
4228940 2105603 2105603 defendant Morton Thomas tailor 636480 636480 Morton, Thomas, of Lydney, yeoman, or of Magna Deane, tailor 0
4720611 2271779 2271779 defendant Foxley John yeoman 636480 636480 Foxley, John, of Lydney, yeoman 3
4735640 2276297 2276297 defendant Dyer William (legal representative) 636480 636480 Dyer, William, of Lydney, executors of 1
4735641 2276297 2276297 defendant Romsey John dyer 636480 636480 (Romsey, John, of Lydney, dyer 2
4735657 2276301 2276301 defendant Dyer William (legal representative) 636480 636480 Dyer, William, of Lydney, executors of 1
4735658 2276301 2276301 defendant Romsey John dyer 636480 636480 (Romsey, John, of Lydney, dyer 2
4832288 2306129 2306129 defendant Heysouke John husbandman 636480 636480 Heysouke, John, of Lydney, husbandman 6
4859187 2314247 2314247 defendant Heysouke or Heysonke John husbandman 636480 636480 Heysouke or Heysonke, John, of Lydney, husbandman 3
4866070 2316358 2316358 defendant Cadull John yeoman 636480 636480 Cadull, John, of Lydney, yeoman 0
4879097 2320396 2320396 defendant Kegewyn Henry husbandman 636480 636480 Kegewyn, Henry, of Lydney, husbandman 0
4887081 2322802 2322802 defendant Webbe William husbandman 636480 636480 Webbe, William, of Lydney, husbandman 0
4887082 2322802 2322802 defendant Keggewyn Henry husbandman 636480 636480 Keggewyn, Henry, of Lydney, husbandman 1
4887084 2322802 2322802 defendant Heyward Thomas husbandman 636480 636480 Heyward, Thomas, of Lydney, husbandman 3
4887085 2322802 2322802 defendant Alford Richard husbandman 636480 636480 Alford, Richard, of Lydney, husbandman 4
4887086 2322802 2322802 defendant Rede Thomas husbandman 636480 636480 Rede, Thomas, of Lydney, husbandman 5
4950286 2342055 2342055 defendant Rede Richard yeoman 636480 636480 Rede, Richard, of Lydney, yeoman 0
5039631 2368500 2368500 defendant Dunnyng John husbandman 636480 636480 Dunnyng, John, of Lydney, husbandman 0
5039639 2368501 2368501 defendant Dunnyng John husbandman 636480 636480 Dunnyng, John, of Lydney, husbandman 0
5250119 2430147 2430147 defendant Wynter Richard yeoman 636480 636480 Wynter, Richard, of Lydney, yeoman 0
5250120 2430147 2430147 defendant Wynter Robert yeoman 636480 636480 Wynter, Robert, of Lydney, yeoman 1
5347497 2459380 2459380 defendant Grey Thomas gent 636480 636480 Grey, Thomas, of Lydney, gent 0
5347498 2459380 2459380 defendant Grey John yeoman 636480 636480 together with Grey, John, of Lydney, yeoman 1
5347499 2459380 2459380 defendant Wynter Richard grasier 636480 636480 Wynter, Richard, of Lydney, grasier 2
5347500 2459380 2459380 defendant Wynter John grasier 636480 636480 Wynter, John, of Lydney, grasier 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);