names

66 rows where place_id = 588550

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3594902 1866033 1866033 defendant Stone Richard yeoman 588550 588550 Stone, Richard, of Erlyngton, yeoman 0
3594903 1866033 1866033 defendant Grente William yeoman 588550 588550 Grente, William, of Erlyngton, yeoman 1
3594904 1866033 1866033 defendant Pynson William yeoman 588550 588550 Pynson, William, of Erlyngton, yeoman 2
3623593 1874910 1874910 defendant Mabbe Peter yeoman 588550 588550 Mabbe, Peter, of Erlyngton, yeoman 1
3625237 1875429 1875429 defendant Grent William yeoman 588550 588550 Grent, William, of Erlyngton, yeoman 0
3625238 1875429 1875429 defendant Pynson William yeoman 588550 588550 Pynson, William, of Erlyngton, yeoman 1
3704354 1927665 1927665 defendant Cane or Cave Thomas husbandman 588550 588550 Cane or Cave, Thomas, of Erlyngton, husbandman 0
3749768 1941837 1941837 defendant Fenys Giles esq 588550 588550 Fenys, Giles, of Erlyngton, esq 0
3764885 1946682 1946682 defendant Fenys Giles esq 588550 588550 Fenys, Giles, of Erlyngton, esq 0
3916536 1995905 1995905 defendant Chechester Amisia gent 588550 588550 Chechester, Amisia, of Erlyngton, gent 1
4543648 2213909 2213909 defendant Parker Osbert   588550 588550 Parker, Osbert, of Erlyngton 0
4656488 2247925 2247925 defendant Sutton John butcher 588550 588550 Sutton, John, of Erlyngton, butcher 1
4702545 2266208 2266208 defendant Swan Thomas laborer 588550 588550 Swan, Thomas, of Erlyngton, laborer 0
4720887 2271866 2271866 defendant Floure Roger esq 588550 588550 Floure, Roger, of Erlyngton, esq 0
4734610 2275987 2275987 defendant Milward Richard husbandman 588550 588550 Milward, Richard, of Erlyngton, husbandman 2
4762269 2284181 2284181 defendant Aleyn John husbandman 588550 588550 Aleyn, John, of Erlyngton, husbandman 0
4763912 2284706 2284706 defendant Haselwode Thomas husbandman 588550 588550 Haselwode, Thomas, of Erlyngton, husbandman 0
4801336 2296607 2296607 defendant Hiches Richard husbandman 588550 588550 Hiches, Richard, of Erlyngton, husbandman 2
4833971 2306634 2306634 defendant Hobey John laborer 588550 588550 Hobey, John, of Erlyngton, laborer 4
4861089 2314825 2314825 defendant Hychys Richard laborer 588550 588550 Hychys, Richard, of Erlyngton, laborer 2
4861090 2314825 2314825 defendant Page Richard weaver 588550 588550 Page, Richard, of Erlyngton, weaver 3
4870050 2317599 2317599 defendant Aleyn Stephen husbandman 588550 588550 Aleyn, Stephen, of Erlyngton, husbandman 0
4884161 2321954 2321954 defendant Hunte Stephen husbandman 588550 588550 Hunte, Stephen, of Erlyngton, husbandman 0
4887398 2322896 2322896 defendant Furder John husbandman 588550 588550 Furder, John, of Erlyngton, husbandman 0
4892595 2324411 2324411 defendant Wodeward Henry husbandman 588550 588550 Wodeward, Henry, of Erlyngton, husbandman 0
4892596 2324411 2324411 defendant Wodeward Robert husbandman 588550 588550 Wodeward, Robert, of Erlyngton, husbandman 1
4892597 2324411 2324411 defendant Foule William husbandman 588550 588550 Foule, William, of Erlyngton, husbandman 2
4894458 2324941 2324941 defendant Bayly Thomas husbandman 588550 588550 Bayly, Thomas, of Erlyngton, husbandman 1
4924100 2333977 2333977 defendant Hobey Richard husbandman 588550 588550 Hobey, Richard, of Erlyngton, husbandman 0
4970251 2348056 2348056 defendant Meyere William clerk 588550 588550 Meyere, William, of Erlyngton, clerk 0
4976430 2349914 2349914 defendant Hunte Stephen husbandman 588550 588550 Hunte, Stephen, of Erlyngton, husbandman 0
5001790 2357420 2357420 defendant Fordere Giles yeoman 588550 588550 Fordere, Giles, of Erlyngton, yeoman 1
5014049 2360963 2360963 defendant Rotherforde Gilbert (legal representative) 588550 588550 Rotherforde, Gilbert, of Erlyngton, executor of 0
5029906 2365618 2365618 defendant Hunte Stephen husbandman 588550 588550 Hunte, Stephen, of Erlyngton, husbandman 0
5058254 2374025 2374025 defendant Hore William yeoman 588550 588550 Hore, William, of Erlyngton, yeoman 1
5058851 2374213 2374213 defendant Bell Richard tiler 588550 588550 Bell, Richard, of Erlyngton, tiler 3
5117226 2391469 2391469 defendant Grent William husbandman 588550 588550 Grent, William, of Erlyngton, husbandman 0
5124534 2393637 2393637 defendant Grent William yeoman 588550 588550 Grent, William, of Erlyngton, yeoman 0
5130771 2395488 2395488 defendant Grent or Greut William yeoman 588550 588550 Grent or Greut, William, of Erlyngton, yeoman 0
5150193 2401196 2401196 defendant Grent William yeoman 588550 588550 Grent, William, of Erlyngton, yeoman 0
5152430 2401841 2401841 defendant Cobbe John husbandman 588550 588550 Cobbe, John, of Erlyngton, husbandman 2
5168854 2406620 2406620 defendant Grent William yeoman 588550 588550 Grent, William, of Erlyngton, yeoman 0
5185102 2411383 2411383 defendant Grent William yeoman 588550 588550 Grent, William, of Erlyngton, yeoman 0
5274457 2437608 2437608 defendant Profoot John husbandman 588550 588550 Profoot, John, of Erlyngton, husbandman 0
5292607 2442835 2442835 defendant Mabbe Henry husbandman 588550 588550 Mabbe, Henry, of Erlyngton, husbandman 0
5292608 2442835 2442835 defendant Heed John, junior yeoman 588550 588550 Heed, John, junior, of Erlyngton, yeoman 1
5324739 2452473 2452473 defendant Mabbe Lawrence husbandman 588550 588550 Mabbe, Lawrence, of Erlyngton, husbandman 1
5367253 2465411 2465411 defendant Purfote John husbandman 588550 588550 Purfote, John, of Erlyngton, husbandman 0
5367254 2465411 2465411 defendant Rayner George clerk 588550 588550 Rayner, George, of Erlyngton, clerk 1
5411255 2478327 2478327 defendant Hereward Edward gent 588550 588550 Hereward, Edward, of Erlyngton, gent 0
5411256 2478327 2478327 defendant Herward John gent 588550 588550 Herward, John, of Erlyngton, gent 1
5411257 2478327 2478327 defendant Tomber Henry yeoman 588550 588550 Tomber, Henry, of Erlyngton, yeoman 2
5411258 2478327 2478327 defendant Taillour Thomas yeoman 588550 588550 Taillour, Thomas, of Erlyngton, yeoman 3
5411259 2478327 2478327 defendant Godfrey John husbandman 588550 588550 Godfrey, John, of Erlyngton, husbandman 4
5411260 2478327 2478327 defendant Bukhorne John yeoman 588550 588550 Bukhorne, John, of Erlyngton, yeoman 5
5464858 2494403 2494403 defendant Hore John yeoman 588550 588550 Hore, John, of Erlyngton, yeoman 1
5476364 2497935 2497935 defendant Hore John yeoman 588550 588550 Hore, John, of Erlyngton, yeoman 1
5476368 2497936 2497936 defendant Hore John yeoman 588550 588550 Hore, John, of Erlyngton, yeoman 1
5481829 2499498 2499498 defendant Hore Edward yeoman 588550 588550 Hore, Edward, of Erlyngton, yeoman 0
5531329 2514320 2514320 defendant Shadwell Richard yeoman 588550 588550 Shadwell, Richard, of Erlyngton, yeoman 0
5531330 2514320 2514320 defendant Swanne Thomas yeoman 588550 588550 Swanne, Thomas, of Erlyngton, yeoman 1
5531331 2514320 2514320 defendant Mabe Peter yeoman 588550 588550 Mabe, Peter, of Erlyngton, yeoman 2
5531332 2514320 2514320 defendant Parker Robert yeoman 588550 588550 Parker, Robert, of Erlyngton, yeoman 3
5531333 2514320 2514320 defendant Mabbe Peter yeoman 588550 588550 Mabbe, Peter, of Erlyngton, yeoman 4
5582794 2529691 2529691 defendant Mabbe Agnes widow 588550 588550 Mabbe, Agnes, of Erlyngton, widow 2
5605851 2536721 2536721 defendant Cooke William husbandman 588550 588550 Cooke, William, of Erlyngton, husbandman 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);