names

45 rows where place_id = 622098

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3721226 1932941 1932941 defendant Wentworth Thomas   622098 622098 Wentworth, Thomas, of West Bretton, knight 0
3745182 1940399 1940399 defendant Denton Richard husbandman 622098 622098 Denton, Richard, of West Bretton, husbandman 1
3745183 1940399 1940399 defendant Sykys William husbandman 622098 622098 Sykys, William, of West Bretton, husbandman 2
3915212 1995447 1995447 defendant Wentworth Isabel widow 622098 622098 Wentworth, Isabel, of West Bretton, widow 1
3962415 2011445 2011445 plaintiff Wentworth Thomas (legal representative) 622098 622098 Wentworth, Thomas, of West Bretton, esq, executors of 0
4019808 2031813 2031813 plaintiff Wentworth Mathew esq 622098 622098 Wentworth, Mathew, of West Bretton, esq 0
4270275 2119642 2119642 defendant Bretton Robert yeoman 622098 622098 Bretton, Robert, of West Bretton, yeoman 0
4419181 2170871 2170871 plaintiff Ayre John   622098 622098 Ayre, John, of West Bretton, son of William 0
4419182 2170871 2170871 defendant Ayre Elizabeth   622098 622098 Ayre, Elizabeth, of West Bretton, formerly wife of Thomas 0
4580634 2225425 2225425 plaintiff del Wode Richard   622098 622098 del Wode, Richard, of West Bretton 0
4612172 2234874 2234874 plaintiff Corff Robert   622098 622098 Corff, Robert, of West Bretton 0
4612173 2234874 2234874 defendant Lytster Thomas   622098 622098 Lytster, Thomas, of West Bretton 0
4612174 2234874 2234874 defendant Lytster John   622098 622098 Lytster, John, of West Bretton 1
4749492 2280331 2280331 defendant Vesty Adam yeoman 622098 622098 Vesty, Adam, of West Bretton, yeoman 1
5021339 2363147 2363147 defendant Ingall John yeoman 622098 622098 Ingall, John, of West Bretton, yeoman 2
5043280 2369614 2369614 defendant Hyne Meykyn yeoman 622098 622098 Hyne, Meykyn, of West Bretton, yeoman 0
5123751 2393406 2393406 defendant Smyth Ralph smith 622098 622098 Smyth, Ralph, of West Bretton, smith 1
5123755 2393407 2393407 defendant Smyth Ralph smith 622098 622098 Smyth, Ralph, of West Bretton, smith 1
5216478 2420550 2420550 defendant Erle William nailer 622098 622098 Erle, William, of West Bretton, nailer 2
5216479 2420550 2420550 defendant Vesse Robet nailer 622098 622098 Vesse, Robet, of West Bretton, nailer 3
5384163 2470560 2470560 defendant Sykes John tanner 622098 622098 Sykes, John, of West Bretton, tanner 6
5384164 2470560 2470560 defendant Bretton John yeoman 622098 622098 Bretton, John, of West Bretton, yeoman 7
5384165 2470560 2470560 defendant Jakson James yeoman 622098 622098 Jakson, James, of West Bretton, yeoman 8
5386494 2471206 2471206 defendant Denton Richard tanner 622098 622098 Denton, Richard, of West Bretton, tanner 2
5398784 2474717 2474717 defendant Wentworth Richard gent 622098 622098 Wentworth, Richard, of West Bretton, gent 0
5398788 2474717 2474717 defendant Denton Richard tanner 622098 622098 Denton, Richard, of West Bretton, tanner 4
5398797 2474718 2474718 defendant Wyntworth Richard gent 622098 622098 Wyntworth, Richard, of West Bretton, gent 0
5398801 2474718 2474718 defendant Denton Richard tanner 622098 622098 Denton, Richard, of West Bretton, tanner 4
5422756 2481758 2481758 defendant Sykes John tanner 622098 622098 Sykes, John, of West Bretton, tanner 6
5422757 2481758 2481758 defendant Bretton John yeoman 622098 622098 Bretton, John, of West Bretton, yeoman 7
5422758 2481758 2481758 defendant Jakson James yeoman 622098 622098 Jakson, James, of West Bretton, yeoman 8
5426378 2482843 2482843 defendant Wentworth Richard gent 622098 622098 Wentworth, Richard, of West Bretton, gent 0
5426382 2482843 2482843 defendant Denton Richard tanner 622098 622098 Denton, Richard, of West Bretton, tanner 4
5426391 2482844 2482844 defendant Wentworth Richard gent 622098 622098 Wentworth, Richard, of West Bretton, gent 0
5426395 2482844 2482844 defendant Denton Richard tanner 622098 622098 Denton, Richard, of West Bretton, tanner 4
5426404 2482845 2482845 defendant Wentworth Richard gent 622098 622098 Wentworth, Richard, of West Bretton, gent 0
5426408 2482845 2482845 defendant Denton Richard tanner 622098 622098 Denton, Richard, of West Bretton, tanner 4
5426417 2482846 2482846 defendant Wyntworth Richard gent 622098 622098 Wyntworth, Richard, of West Bretton, gent 0
5426421 2482846 2482846 defendant Denton Richard tanner 622098 622098 Denton, Richard, of West Bretton, tanner 4
5444512 2488264 2488264 defendant Wentworth Richard gent 622098 622098 Wentworth, Richard, of West Bretton, gent 0
5444523 2488265 2488265 defendant Wentworth Richard   622098 622098 Wentworth, Richard, of West Bretton 0
5449870 2489850 2489850 defendant Bretton John yeoman 622098 622098 Bretton, John, of West Bretton, yeoman 7
5449871 2489850 2489850 defendant Jakson James yeoman 622098 622098 Jakson, James, of West Bretton, yeoman 8
5515714 2509760 2509760 defendant Wyntworth Mathew gent 622098 622098 Wyntworth, Mathew, of West Bretton, gent 2
5530986 2514206 2514206 defendant Wentworth William gent 622098 622098 Wentworth, William, of West Bretton, gent 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);