names

81 rows where place_id = 595859

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3622151 1874463 1874463 defendant Nasshe John husbandman 595859 595859 Nasshe, John, of Hambury, husbandman 0
3672654 1917448 1917448 defendant Vernon Thomas yeoman 595859 595859 Vernon, Thomas, of Hambury, yeoman 0
3675337 1918325 1918325 defendant Haywood Thomas yeoman 595859 595859 Haywood, Thomas, of Hambury, yeoman 0
3681138 1920182 1920182 defendant Heywode William husbandman 595859 595859 Heywode, William, of Hambury, husbandman 0
3681183 1920198 1920198 defendant Heywode Thomas husbandman 595859 595859 Heywode, Thomas, of Hambury, husbandman 0
3681184 1920198 1920198 defendant Heywode Robert husbandman 595859 595859 Heywode, Robert, of Hambury, husbandman 1
3722950 1933444 1933444 defendant Menske Robert husbandman 595859 595859 Menske, Robert, of Hambury, husbandman 0
3738818 1938348 1938348 defendant Mouske or Monske Robert husbandman 595859 595859 Mouske or Monske, Robert, of Hambury, husbandman 0
3768114 1947663 1947663 defendant Wylde John husbandman 595859 595859 Wylde, John, of Hambury, husbandman 1
3770912 1948589 1948589 defendant Slalard John husbandman 595859 595859 Slalard, John, of Hambury, husbandman 0
3770913 1948589 1948589 defendant Coke Elizabeth widow 595859 595859 Coke, Elizabeth, of Hambury, widow 1
3785391 1953218 1953218 defendant Vernam Thomas gent 595859 595859 Vernam, Thomas, of Hambury, gent 2
3831756 1967832 1967832 defendant Yate William husbandman 595859 595859 Yate, William, of Hambury, husbandman 1
3831757 1967832 1967832 defendant Ponge William husbandman 595859 595859 Ponge, William, of Hambury, husbandman 2
3832976 1968232 1968232 defendant Nasshe John husbandman 595859 595859 Nasshe, John, of Hambury, husbandman 1
3846712 1972527 1972527 defendant Baylys Robert husbandman 595859 595859 Baylys, Robert, of Hambury, husbandman 1
3847674 1972844 1972844 defendant Yate Edward husbandman 595859 595859 Yate, Edward, of Hambury, husbandman 0
3853418 1974695 1974695 defendant Herryson John husbandman 595859 595859 Herryson, John, of Hambury, husbandman 0
3857737 1976056 1976056 defendant Nasshe Thomas yeoman 595859 595859 Nasshe, Thomas, of Hambury, yeoman 2
3865501 1978681 1978681 defendant Hunt John yeoman 595859 595859 Hunt, John, of Hambury, yeoman 0
3866000 1978863 1978863 defendant Menske Thomas husbandman 595859 595859 Menske, Thomas, of Hambury, husbandman 0
3866001 1978863 1978863 defendant Yate William husbandman 595859 595859 Yate, William, of Hambury, husbandman 1
3866002 1978863 1978863 defendant Heywod Richard husbandman 595859 595859 Heywod, Richard, of Hambury, husbandman 2
3871806 1980807 1980807 defendant Nasshe Thomas yeoman 595859 595859 Nasshe, Thomas, of Hambury, yeoman 1
3871807 1980807 1980807 defendant Harryson John yeoman 595859 595859 Harryson, John, of Hambury, yeoman 2
3885221 1985308 1985308 defendant Walker William husbandman 595859 595859 Walker, William, of Hambury, husbandman 0
3892679 1987800 1987800 defendant More John husbandman 595859 595859 More, John, of Hambury, husbandman 1
3892680 1987800 1987800 defendant Yate Edward husbandman 595859 595859 Yate, Edward, of Hambury, husbandman 2
3918735 1996596 1996596 defendant Andros William gent 595859 595859 Andros, William, of Hambury, gent 1
3920721 1997277 1997277 defendant Heywod John husbandman 595859 595859 Heywod, John, of Hambury, husbandman 3
3921100 1997407 1997407 defendant Androse John gent 595859 595859 Androse, John, of Hambury, gent 0
3921605 1997571 1997571 defendant Walker Thomas laborer 595859 595859 Walker, Thomas, of Hambury, laborer 0
3925913 1998981 1998981 defendant More John husbandman 595859 595859 More, John, of Hambury, husbandman 2
4325019 2138753 2138753 defendant Morgan Edward gent 595859 595859 Morgan, Edward, of Hambury, gent 0
4423645 2172240 2172240 plaintiff Passener Richard   595859 595859 (Passener, Richard, of Hambury, parson 1
4435779 2175935 2175935 defendant Chaumbre John de la   595859 595859 Chaumbre, John de la, of Hambury 0
4491908 2198154 2198154 plaintiff Wybbe John   595859 595859 Wybbe, John, of Hambury 0
4583335 2226208 2226208 defendant Forster Richard   595859 595859 Forster, Richard, of Hambury 0
4606101 2233022 2233022 defendant Canon Robert   595859 595859 Canon, Robert, of Hambury 3
4606108 2233023 2233023 defendant Canon Robert   595859 595859 Canon, Robert, of Hambury 3
4650631 2246203 2246203 defendant Wawe Robert   595859 595859 Wawe, Robert, of Hambury 2
4716805 2270583 2270583 defendant Kene Richard husbandman 595859 595859 Kene, Richard, of Hambury, husbandman 0
4716806 2270583 2270583 defendant Canon Robert husbandman 595859 595859 Canon, Robert, of Hambury, husbandman 1
4779188 2289466 2289466 defendant Lumbard Giles husbandman 595859 595859 Lumbard, Giles, of Hambury, husbandman 0
4779189 2289466 2289466 defendant Taillour John husbandman 595859 595859 Taillour, John, of Hambury, husbandman 1
4886952 2322768 2322768 defendant Wybbe Thomas gent 595859 595859 Wybbe, Thomas, of Hambury, gent 0
4891977 2324227 2324227 defendant Wybbe Thomas gent 595859 595859 Wybbe, Thomas, of Hambury, gent 0
4951083 2342302 2342302 defendant Fynamoure John husbandman 595859 595859 Fynamoure, John, of Hambury, husbandman 0
4951084 2342302 2342302 defendant Fynamoure William husbandman 595859 595859 Fynamoure, William, of Hambury, husbandman 1
4951085 2342302 2342302 defendant Fynamoure Thomas husbandman 595859 595859 Fynamoure, Thomas, of Hambury, husbandman 2
4969552 2347842 2347842 defendant Coton Thomas gent 595859 595859 Coton, Thomas, of Hambury, gent 0
4988261 2353459 2353459 defendant Oldebury Thomas clerk 595859 595859 Oldebury, Thomas, of Hambury, clerk 1
5020764 2362970 2362970 defendant Pylgreme John   595859 595859 Pylgreme, John, of Hambury, servant 1
5020770 2362971 2362971 defendant Pylgreme John   595859 595859 Pylgreme, John, of Hambury, servant 1
5052411 2372321 2372321 defendant Catton Nicholas   595859 595859 Catton, Nicholas, of Hambury, cook 1
5052412 2372321 2372321 defendant Carter John tailor 595859 595859 Carter, John, of Hambury, tailor 2
5052417 2372322 2372322 defendant Catton Nicholas   595859 595859 Catton, Nicholas, of Hambury, cook 1
5052418 2372322 2372322 defendant Carter alias Taillour John tailor 595859 595859 Carter alias Taillour, John, of Hambury, tailor 2
5103947 2387580 2387580 defendant Bercrofte Thomas husbandman 595859 595859 Bercrofte, Thomas, of Hambury, husbandman 0
5103948 2387580 2387580 defendant Parker John husbandman 595859 595859 Parker, John, of Hambury, husbandman 1
5150785 2401374 2401374 plaintiff (not given) John rector of Garner 595859 595859 Garner, John, of Hambury, clerk & Master & rector of the parish church 0
5150786 2401374 2401374 defendant Hambury William gent 595859 595859 Hambury, William, of Hambury, gent 0
5169165 2406718 2406718 defendant Hambury William gent 595859 595859 Hambury, William, of Hambury, gent 0
5237487 2426546 2426546 defendant Waltur John husbandman 595859 595859 Waltur, John, of Hambury, husbandman 0
5262077 2433888 2433888 defendant Hambury William yeoman 595859 595859 Hambury, William, of Hambury, yeoman 0
5262080 2433888 2433888 defendant Elvyn Richard yeoman 595859 595859 Elvyn, Richard, of Hambury, yeoman 3
5262082 2433889 2433889 defendant Hambury William yeoman 595859 595859 Hambury, William, of Hambury, yeoman 0
5262085 2433889 2433889 defendant Elvyn Richard yeoman 595859 595859 Elvyn, Richard, of Hambury, yeoman 3
5330549 2454226 2454226 defendant Barnby John clerk 595859 595859 Barnby, John, of Hambury, clerk 0
5394580 2473511 2473511 defendant Kayl William husbandman 595859 595859 Kayl, William, of Hambury, husbandman 3
5394581 2473511 2473511 defendant Alderley Robert fuller 595859 595859 Alderley, Robert, of Hambury, fuller 4
5490404 2502024 2502024 defendant Constable Marmaduke   595859 595859 Constable, Marmaduke, of Hambury, knight 0
5490406 2502025 2502025 defendant Constable Marmaduke   595859 595859 Constable, Marmaduke, of Hambury, knight 0
5505340 2506582 2506582 defendant Constable Marmaduke   595859 595859 Constable, Marmaduke, of Hambury, knight 0
5555848 2521702 2521702 defendant Naysshe John yeoman 595859 595859 Naysshe, John, of Hambury, yeoman 0
5570456 2525930 2525930 defendant Byllyng Richard husbandman 595859 595859 Byllyng, Richard, of Hambury, husbandman 1
5571258 2526153 2526153 defendant Nasshe John yeoman 595859 595859 Nasshe, John, of Hambury, yeoman 0
5587504 2531107 2531107 defendant Morton Robert laborer 595859 595859 Morton, Robert, of Hambury, laborer 1
5589245 2531643 2531643 defendant Lee Thomas husbandman 595859 595859 Lee, Thomas, of Hambury, husbandman 0
5607117 2537113 2537113 defendant Heddeley Lawrence husbandman 595859 595859 Heddeley, Lawrence, of Hambury, husbandman 0
5614435 2548308 2548308 plaintiff Ernald John (legal representative) 595859 595859 Ernald, John, of Hambury, executor of 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);