names

36 rows where place_id = 625329

✎ 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
3763502 1946219 1946219 plaintiff Harrys William yeoman 625329 625329 Harrys, William, of Bermondesey, yeoman 0
3778824 1951092 1951092 defendant Hall Thomas yeoman 625329 625329 Hall, Thomas, of Bermondesey, yeoman 3
4501450 2201055 2201055 defendant Brillestede Peter   625329 625329 Brillestede, Peter, of Bermondesey 4
4668124 2255738 2255738 defendant Walton Henry yeoman 625329 625329 Walton, Henry, of Bermondesey, yeoman 0
4678322 2258828 2258828 defendant Lynkefeld Nicholas tanner 625329 625329 Lynkefeld, Nicholas, of Bermondesey, tanner 0
4776529 2288653 2288653 plaintiff Alfrede William   625329 625329 Alfrede, William, of Bermondesey 0
4902275 2327321 2327321 defendant Notyngham Thomas weaver 625329 625329 Notyngham, Thomas, of Bermondesey, weaver 0
4909018 2329363 2329363 defendant Goderich John esq 625329 625329 Goderich, John, of Bermondesey, esq 0
4955909 2343733 2343733 defendant Gouderych John esq 625329 625329 Gouderych, John, of Bermondesey, esq 0
4955911 2343734 2343734 defendant Gouderych John esq 625329 625329 Gouderych, John, of Bermondesey, esq 0
4957458 2344199 2344199 defendant Goderych John gent 625329 625329 Goderych, John, of Bermondesey, gent 3
4979578 2350850 2350850 defendant Burgh Katherine   625329 625329 Burgh, Katherine, of Bermondesey, Surrey widow 1
5027882 2365037 2365037 defendant Hewes Richard whitawer 625329 625329 Hewes, Richard, of Bermondesey, whitawer 1
5027884 2365037 2365037 defendant Tyler Thomas tiler 625329 625329 Tyler, Thomas, of Bermondesey, tiler 3
5027887 2365037 2365037 defendant Wylmot Peter carter 625329 625329 Wylmot, Peter, of Bermondesey, carter 6
5044264 2369914 2369914 defendant Barbour Henry   625329 625329 Barbour, Henry, of Bermondesey, surgeon 0
5095423 2385083 2385083 defendant Stokes Thomas fruiterer 625329 625329 Stokes, Thomas, of Bermondesey, fruiterer 0
5119463 2392122 2392122 defendant Clyff William weaver 625329 625329 Clyff, William, of Bermondesey, weaver 0
5179305 2409685 2409685 defendant Syward William gent 625329 625329 Syward, William, of Bermondesey, gent 0
5201840 2416304 2416304 defendant Syward William gent 625329 625329 Syward, William, of Bermondesey, gent 0
5212179 2419300 2419300 defendant Payn John gent 625329 625329 Payn, John, of Bermondesey, gent 3
5213036 2419550 2419550 defendant Syward William gent 625329 625329 Syward, William, of Bermondesey, gent 0
5253814 2431307 2431307 defendant Coteler Edward yeoman 625329 625329 Coteler, Edward, of Bermondesey, yeoman 0
5274015 2437478 2437478 defendant Goderyche Richard gent 625329 625329 Goderyche, Richard, of Bermondesey, gent 0
5278476 2438811 2438811 defendant Grene Richard gent 625329 625329 Grene, Richard, of Bermondesey, gent 2
5278477 2438811 2438811 defendant Crowe William yeoman 625329 625329 Crowe, William, of Bermondesey, yeoman 3
5290735 2442293 2442293 defendant Goderyche Richard gent 625329 625329 Goderyche, Richard, of Bermondesey, gent 0
5290744 2442294 2442294 defendant Goderyche Richard gent 625329 625329 together with Goderyche, Richard, of Bermondesey, gent 1
5307129 2447130 2447130 defendant Goderyche Richard gent 625329 625329 Goderyche, Richard, of Bermondesey, gent 0
5307133 2447132 2447132 defendant Goderyche Richard gent 625329 625329 Goderyche, Richard, of Bermondesey, gent 0
5322487 2451798 2451798 defendant Aleyn John fellmonger 625329 625329 Aleyn, John, of Bermondesey, fellmonger 0
5395472 2473781 2473781 defendant Marlowe John   625329 625329 Marlowe, John, of Bermondesey, abbot of the exempt monastery of St Salvatore 0
5395474 2473782 2473782 defendant Marlowe John   625329 625329 Marlowe, John, of Bermondesey, abbot of the exempt monastery of St Salvatore 0
5453039 2490790 2490790 defendant Saunders Thomas yeoman 625329 625329 Saunders, Thomas, of Bermondesey, yeoman 2
5488058 2501317 2501317 defendant Saunders Thomas yeoman 625329 625329 Saunders, Thomas, of Bermondesey, yeoman 3
5581496 2529286 2529286 defendant Deryk William leather seller 625329 625329 Deryk, William, of Bermondesey, leather seller 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);