names

22 rows where place_id = 603294

✎ 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
3654086 1911541 1911541 defendant Heret Peter dyer 603294 603294 Heret, Peter, of Southwerk, Surr, dyer 0
3657031 1912461 1912461 plaintiff Cooke Richard brewer 603294 603294 Cooke, Richard, of Southwerk, Surr, brewer 0
3664433 1914824 1914824 defendant Brandon Robert   603294 603294 Brandon, Robert, of Southwerk, Surr, knight 0
3666040 1915316 1915316 defendant Flouer Francis glasier 603294 603294 Flouer, Francis, of Southwerk, Surr, glasier 0
3666041 1915317 1915317 defendant Flouer Francis glasier 603294 603294 Flouer, Francis, of Southwerk, Surr, glasier 0
4682028 2259998 2259998 defendant Palmere Richard butcher 603294 603294 Palmere, Richard, of Southwerk, Surr, butcher 0
4753830 2281575 2281575 defendant Coupewode Geoffrey dyer 603294 603294 Coupewode, Geoffrey, of Southwerk, Surr, dyer 0
4753836 2281577 2281577 defendant Coupewode Geoffrey dyer 603294 603294 Coupewode, Geoffrey, of Southwerk, Surr, dyer 0
4753840 2281578 2281578 defendant Coupewode Geoffrey dyer 603294 603294 Coupewode, Geoffrey, of Southwerk, Surr, dyer 0
4802166 2296868 2296868 defendant Burton John esq 603294 603294 Burton, John, of Southwerk, Surr, esq 0
4805675 2297983 2297983 defendant Magot Richard butcher 603294 603294 Magot, Richard, of Southwerk, Surr, butcher 2
4908806 2329305 2329305 defendant Panfeld Richard hostiller 603294 603294 Panfeld, Richard, of Southwerk, Surr, hostiller 1
4918449 2332288 2332288 defendant Egremond John yeoman 603294 603294 (Egremond, John, of Southwerk, Surr, yeoman 1
5047516 2370877 2370877 defendant Croke John butcher 603294 603294 Croke, John, of Southwerk, Surr, butcher 0
5132968 2396134 2396134 defendant Mudde John yeoman 603294 603294 Mudde, John, of Southwerk, Surr, yeoman 1
5276155 2438099 2438099 plaintiff Tyngleden Richard gent 603294 603294 Tyngleden, Richard, of Southwerk, Surr, gent 0
5276157 2438100 2438100 plaintiff Tyngleden Richard gent 603294 603294 Tyngleden, Richard, of Southwerk, Surr, gent 0
5414573 2479296 2479296 defendant Cope Edmund barber 603294 603294 Cope, Edmund, of Southwerk, Surr, barber 0
5414640 2479314 2479314 defendant Cope Edmund barber 603294 603294 Cope, Edmund, of Southwerk, Surr, barber 0
5446253 2488770 2488770 defendant Morgan William carpenter 603294 603294 Morgan, William, of Southwerk, Surr, carpenter 0
5451604 2490352 2490352 defendant Claperton Robert laborer 603294 603294 Claperton, Robert, of Southwerk, Surr, laborer 0
5460164 2492974 2492974 defendant Haryson Geoffrey yeoman 603294 603294 Haryson, Geoffrey, of Southwerk, Surr, yeoman 1

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