names

32 rows where place_id = 628135

✎ 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
3780625 1951668 1951668 defendant Jamys William clerk 628135 628135 Jamys, William, of Marleborough, Wilts, clerk 0
3784572 1952962 1952962 defendant Poncharton Robert yeoman 628135 628135 Poncharton, Robert, of Marleborough, Wilts, yeoman 3
3817637 1963417 1963417 defendant Wrenne Richard tanner 628135 628135 Wrenne, Richard, of Marleborough, Wilts, tanner 0
3866246 1978937 1978937 defendant Fryce Henry innholder 628135 628135 Fryce, Henry, of Marleborough, Wilts, innholder 0
3935481 2002175 2002175 defendant Danyell Geoffrey gent 628135 628135 Danyell, Geoffrey, of Marleborough, Wilts, gent 0
3945657 2005556 2005556 defendant Hayward alias Baker Thomas yeoman 628135 628135 Hayward alias Baker, Thomas, of Marleborough, Wilts,, yeoman 1
3946644 2005891 2005891 defendant Tuggy William vintner 628135 628135 Tuggy, William, of Marleborough, Wilts, vintner 0
3946896 2005984 2005984 defendant Peche John gent 628135 628135 Peche, John, of Marleborough, Wilts, gent 0
3950524 2007263 2007263 defendant Lawny Richard chapman 628135 628135 Lawny, Richard, of Marleborough, Wilts, chapman 0
3967112 2013122 2013122 defendant Tuggy William yeoman 628135 628135 Tuggy, William, of Marleborough, Wilts, yeoman 0
3967114 2013123 2013123 defendant Tuggy William yeoman 628135 628135 Tuggy, William, of Marleborough, Wilts, yeoman 0
3976309 2016286 2016286 defendant Tugge William innholder 628135 628135 Tugge, William, of Marleborough, Wilts, innholder 0
3980138 2017661 2017661 defendant Midwinter alias Kynge William glover 628135 628135 Midwinter alias Kynge, William, of Marleborough, Wilts, glover 0
3995157 2023016 2023016 plaintiff Cornwall John tanner 628135 628135 Cornwall, John, of Marleborough, Wilts, tanner 0
4005009 2026574 2026574 defendant Tuggey William innholder 628135 628135 Tuggey, William, of Marleborough, Wilts, innholder 0
4005011 2026575 2026575 defendant Tuggey William innholder 628135 628135 Tuggey, William, of Marleborough, Wilts, innholder 0
4006783 2027203 2027203 plaintiff Lovell John tanner 628135 628135 Lovell, John, of Marleborough, Wilts, tanner 0
4019460 2031689 2031689 plaintiff Weare Robert (legal representative) 628135 628135 Weare, Robert, of Marleborough, Wilts, executors of 0
4019464 2031690 2031690 plaintiff Weare Robert (legal representative) 628135 628135 Weare, Robert, of Marleborough, Wilts, gent, executors of 0
4032221 2036196 2036196 defendant Bronsdon John chapman 628135 628135 Bronsdon, John, of Marleborough, Wilts, chapman 0
4052966 2043497 2043497 plaintiff Allen John   628135 628135 Allen, John, of Marleborough, Wilts, linen draper 0
4060923 2046315 2046315 plaintiff Diston Anthony fishmonger 628135 628135 Diston, Anthony, of Marleborough, Wilts, fishmonger 0
4060926 2046316 2046316 plaintiff Diston Anthony fishmonger 628135 628135 Diston, Anthony, of Marleborough, Wilts, fishmonger 0
4066635 2048362 2048362 defendant Tuggey William vintner 628135 628135 Tuggey, William, of Marleborough,, Wilts, vintner 0
4109398 2063623 2063623 defendant Masham William chapman 628135 628135 Masham, William, of Marleborough, Wilts, chapman 0
4169559 2084859 2084859 defendant Payne John chapman 628135 628135 Payne, John, of Marleborough, Wilts, chapman 0
4308552 2133144 2133144 defendant Love John chapman 628135 628135 Love, John, of Marleborough, Wilts, chapman 0
4328667 2139900 2139900 defendant Martyn Philip yeoman 628135 628135 Martyn, Philip, of Marleborough, Wilts, yeoman 0
5246696 2429194 2429194 defendant Somerfeld Robert chapman 628135 628135 Somerfeld, Robert, of Marleborough, Wilts, chapman 1
5246706 2429197 2429197 defendant Somerfeld Robert chapman 628135 628135 Somerfeld, Robert, of Marleborough, Wilts, chapman 1
5494517 2503244 2503244 defendant Fryce John mercer 628135 628135 Fryce, John, of Marleborough, Wilts, mercer 2
5565902 2524629 2524629 defendant Bytheway John tanner 628135 628135 Bytheway, John, of Marleborough, Wilts, tanner 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);