names

79 rows where place_id = 596794

✎ 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
3626204 1903054 1903054 defendant Byrchynsawe Thomas maltman 596794 596794 Byrchynsawe, Thomas, of Hychyn, maltman 0
3628740 1903867 1903867 defendant Stonley John laborer 596794 596794 Stonley, John, of Hychyn, laborer 0
3650226 1910440 1910440 defendant Belle Thomas carpenter 596794 596794 Belle, Thomas, of Hychyn, carpenter 0
3650243 1910447 1910447 defendant Belle Thomas carpenter 596794 596794 Belle, Thomas, of Hychyn, carpenter 0
3662306 1914125 1914125 defendant Fage William laborer 596794 596794 Fage, William, of Hychyn, laborer 3
3676661 1918739 1918739 defendant Crosby Thomas butcher 596794 596794 Crosby, Thomas, of Hychyn, butcher 1
3676664 1918739 1918739 defendant Toky Thomas   596794 596794 Toky, Thomas, of Hychyn, tile maker 4
3687273 1922200 1922200 defendant Ive John carpenter 596794 596794 Ive, John, of Hychyn, carpenter 0
3740918 1939020 1939020 defendant Docwra John gent 596794 596794 Docwra, John, of Hychyn, gent 0
3740919 1939020 1939020 defendant Whytyng John husbandman 596794 596794 Whytyng, John, of Hychyn, husbandman 1
3740920 1939020 1939020 defendant Bray John husbandman 596794 596794 Bray, John, of Hychyn, husbandman 2
3740921 1939020 1939020 defendant Sawyer Henry laborer 596794 596794 Sawyer, Henry, of Hychyn, laborer 3
3740922 1939020 1939020 defendant Cely Henry laborer 596794 596794 Cely, Henry, of Hychyn, laborer 4
3753297 1942969 1942969 defendant Docwra John gent 596794 596794 Docwra, John, of Hychyn, gent 0
3753298 1942969 1942969 defendant Whytyng John husbandman 596794 596794 Whytyng, John, of Hychyn, husbandman 1
3753299 1942969 1942969 defendant Bray John husbandman 596794 596794 Bray, John, of Hychyn, husbandman 2
3753300 1942969 1942969 defendant Sawyer Henry laborer 596794 596794 Sawyer, Henry, of Hychyn, laborer 3
3770689 1948514 1948514 defendant Barker John fuller 596794 596794 Barker, John, of Hychyn, fuller 0
3782668 1952321 1952321 defendant Smyth Roger yeoman 596794 596794 Smyth, Roger, of Hychyn, yeoman 0
3785460 1953241 1953241 defendant Goldsmyth Thomas innholder 596794 596794 Goldsmyth, Thomas, of Hychyn, innholder 0
3785902 1953382 1953382 defendant Jen William yeoman 596794 596794 Jen, William, of Hychyn, yeoman 0
3789873 1954658 1954658 defendant Smyth Roger yeoman 596794 596794 Smyth, Roger, of Hychyn, yeoman 2
3799943 1957902 1957902 plaintiff Lacy John miller 596794 596794 Lacy, John, of Hychyn, miller 0
3799944 1957902 1957902 defendant Ruste William yeoman 596794 596794 Ruste, William, of Hychyn, yeoman 0
3803789 1959098 1959098 defendant Barker John fuller 596794 596794 Barker, John, of Hychyn, fuller 0
3828282 1966719 1966719 defendant Smyth William butcher 596794 596794 Smyth, William, of Hychyn, butcher 0
3842602 1971213 1971213 defendant Smyth William butcher 596794 596794 Smyth, William, of Hychyn, butcher 0
3900005 1990219 1990219 defendant Saunder Ralph maltman 596794 596794 Saunder, Ralph, of Hychyn, maltman 0
3902493 1991065 1991065 defendant Love Thomas   596794 596794 Love, Thomas, of Hychyn, Wheelwright 0
3902494 1991065 1991065 defendant Hukkyll Thomas carpenter 596794 596794 Hukkyll, Thomas, of Hychyn, carpenter 1
4457632 2187394 2187394 plaintiff Peyntour Thomas   596794 596794 Peyntour, Thomas, of Hychyn 0
4457633 2187394 2187394 defendant Bolle Agnes   596794 596794 Bolle, Agnes, of Hychyn 0
4572799 2223029 2223029 defendant Lynchelade John   596794 596794 Lynchelade, John, of Hychyn 0
4585860 2226999 2226999 defendant Lawe William   596794 596794 Lawe, William, of Hychyn 0
4652579 2246763 2246763 defendant Skynnere Walter miller 596794 596794 Skynnere, Walter, of Hychyn, miller 0
4694846 2263877 2263877 defendant Boldro Thomas   596794 596794 Boldro, Thomas, of Hychyn 0
4697657 2264758 2264758 defendant Frankeleyn Lucy laborer 596794 596794 Frankeleyn, Lucy, of Hychyn, laborer 0
4706618 2267449 2267449 defendant Barboure John barber 596794 596794 Barboure, John, of Hychyn, barber 0
4752833 2281282 2281282 defendant Campyon William husbandman 596794 596794 Campyon, William, of Hychyn, husbandman 0
4912616 2330447 2330447 defendant Yate Robert laborer 596794 596794 Yate, Robert, of Hychyn, laborer 2
5062290 2375283 2375283 defendant Sawyr Robert sawyer 596794 596794 Sawyr, Robert, of Hychyn, sawyer 0
5076652 2379517 2379517 defendant Boldro John yeoman 596794 596794 Boldro, John, of Hychyn, yeoman 0
5076917 2379591 2379591 plaintiff Bele John gent 596794 596794 Bele, John, of Hychyn, gent 0
5130815 2395495 2395495 defendant Herst William husbandman 596794 596794 Herst, William, of Hychyn, husbandman 0
5141593 2398652 2398652 defendant Chertesey Thomas miller 596794 596794 Chertesey, Thomas, of Hychyn, miller 0
5232037 2424941 2424941 defendant Edward John husbandman 596794 596794 Edward, John, of Hychyn, husbandman 1
5232040 2424941 2424941 defendant Taylour John butcher 596794 596794 Taylour, John, of Hychyn, butcher 4
5244479 2428567 2428567 defendant Thurgat John fuller 596794 596794 Thurgat, John, of Hychyn, fuller 1
5253673 2431262 2431262 plaintiff Bray Nicholas (legal representative) 596794 596794 Bray, Nicholas, of Hychyn, executors of 0
5253677 2431262 2431262 defendant Albon John butcher 596794 596794 Albon, John, of Hychyn, butcher 1
5253680 2431263 2431263 plaintiff Bray Nicholas (legal representative) 596794 596794 Bray, Nicholas, of Hychyn, executors of 0
5253684 2431263 2431263 defendant Albon John butcher 596794 596794 Albon, John, of Hychyn, butcher 1
5321084 2451400 2451400 defendant Yngold John butcher 596794 596794 Yngold, John, of Hychyn, butcher 3
5366025 2465032 2465032 defendant Gosse Thomas glover 596794 596794 Gosse, Thomas, of Hychyn, glover 0
5366028 2465032 2465032 defendant Frest John tanner 596794 596794 Frest, John, of Hychyn, tanner 3
5366029 2465032 2465032 defendant Ingold John butcher 596794 596794 Ingold, John, of Hychyn, butcher 4
5366770 2465264 2465264 defendant Lawe William   596794 596794 Lawe, William, of Hychyn, tile maker 1
5368988 2465893 2465893 plaintiff Drakys Richard   596794 596794 Drakys, Richard, of Hychyn 0
5368989 2465893 2465893 defendant atte Hoo Roger yeoman 596794 596794 atte Hoo, Roger, of Hychyn, yeoman 0
5368990 2465893 2465893 defendant Wever Henry weaver 596794 596794 Wever, Henry, of Hychyn, weaver 1
5380590 2469499 2469499 defendant Lawe William   596794 596794 Lawe, William, of Hychyn, tile maker 3
5380596 2469500 2469500 defendant Lawe William   596794 596794 Lawe, William, of Hychyn, tile maker 3
5380810 2469565 2469565 defendant fitz Water Thomas tilemaker 596794 596794 fitz Water,Thomas, of Hychyn, tilemaker 1
5398666 2474684 2474684 defendant Fitzwater Thomas   596794 596794 Fitzwater, Thomas, of Hychyn, tile maker 1
5400224 2475139 2475139 defendant Tayller William yeoman 596794 596794 Tayller, William, of Hychyn, yeoman 0
5400226 2475139 2475139 defendant Dyer John yeoman 596794 596794 Dyer, John, of Hychyn, yeoman 2
5406137 2476832 2476832 plaintiff Snowe John   596794 596794 Snowe, John, of Hychyn 0
5408626 2477544 2477544 defendant Phares William husbandman 596794 596794 Phares, William, of Hychyn, husbandman 2
5408627 2477544 2477544 defendant Bredyman William husbandman 596794 596794 Bredyman, William, of Hychyn, husbandman 3
5434739 2485326 2485326 defendant Lawe William   596794 596794 Lawe, William, of Hychyn, tile maker 1
5451294 2490261 2490261 plaintiff Scot John   596794 596794 Scot, John, of Hychyn 0
5459449 2492740 2492740 defendant Carter John husbandman 596794 596794 Carter, John, of Hychyn, husbandman 0
5492497 2502669 2502669 defendant Tele William tailor 596794 596794 Tele, William, of Hychyn, tailor 0
5573886 2526929 2526929 plaintiff Pulter William esq 596794 596794 Pulter, William, of Hychyn, esq 0
5580289 2528921 2528921 defendant Slot John butcher 596794 596794 Slot, John, of Hychyn, butcher 0
5580292 2528921 2528921 defendant Crosby John butcher 596794 596794 Crosby, John, of Hychyn, butcher 3
5589720 2531781 2531781 defendant Bukley William smith 596794 596794 Bukley, William, of Hychyn, smith 0
5593450 2532933 2532933 defendant Gell John laborer 596794 596794 Gell, John, of Hychyn, laborer 1
5594283 2533187 2533187 defendant Hurst Christopher   596794 596794 Hurst, Christopher, of Hychyn, tile maker 5

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