names

71 rows where place_id = 607684

✎ 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
3670375 1916688 1916688 defendant Dey John husbandman 607684 607684 Dey, John, of Gressenhale, husbandman 0
3670376 1916688 1916688 defendant Candeler Robert husbandman 607684 607684 Candeler, Robert, of Gressenhale, husbandman 1
3677771 1919096 1919096 defendant Glover Henry clerk 607684 607684 Glover, Henry, of Gressenhale, clerk 0
3680440 1919964 1919964 defendant Whynby Henry husbandman 607684 607684 Whynby, Henry, of Gressenhale, husbandman 0
3707190 1928539 1928539 defendant Ferrour Edmund husbandman 607684 607684 Ferrour, Edmund, of Gressenhale, husbandman 0
3711673 1929962 1929962 defendant Ferrour Edmund yeoman 607684 607684 Ferrour, Edmund, of Gressenhale, yeoman 2
3734187 1936933 1936933 defendant Ferrour Edmund yeoman 607684 607684 Ferrour, Edmund, of Gressenhale, yeoman 1
3735258 1937262 1937262 plaintiff Sekker Richard   607684 607684 Sekker, Richard, of Gressenhale 2
3735263 1937263 1937263 plaintiff Sekker Richard   607684 607684 Sekker, Richard, of Gressenhale 2
3767659 1947523 1947523 defendant Ferrour Edmund yeoman 607684 607684 Ferrour, Edmund, of Gressenhale, yeoman 0
3791492 1955177 1955177 defendant Corbrigge Cuthbert blacksmith 607684 607684 Corbrigge, Cuthbert, of Gressenhale, blacksmith 0
3796951 1956928 1956928 plaintiff Fostor William chaplain 607684 607684 Fostor, William, of Gressenhale, chaplain 0
3799832 1957866 1957866 defendant Smyth Richard pardoner 607684 607684 Smyth, Richard, of Gressenhale, pardoner 1
3874336 1981641 1981641 defendant Ferrour Edmund yeoman 607684 607684 Ferrour, Edmund, of Gressenhale, yeoman 0
3877127 1982590 1982590 defendant Ansell John husbandman 607684 607684 Ansell, John, of Gressenhale, husbandman 1
3886226 1985645 1985645 defendant Rudde William husbandman 607684 607684 Rudde, William, of Gressenhale, husbandman 2
3893291 1987986 1987986 plaintiff Pavy Katherine widow 607684 607684 Katherine his wife, formerly Katherine Caly, of Gressenhale, widow 1
3898938 1989848 1989848 defendant Trenche John yeoman 607684 607684 Trenche, John, of Gressenhale, yeoman 0
3908942 1993285 1993285 defendant Trenche Edward yeoman 607684 607684 Trenche, Edward, of Gressenhale, yeoman 0
3917980 1996380 1996380 defendant Trenche Edmund yeoman 607684 607684 Trenche, Edmund, of Gressenhale, yeoman 1
3922783 1997929 1997929 defendant Trenche Edmund yeoman 607684 607684 Trenche, Edmund, of Gressenhale, yeoman 0
3927833 1999648 1999648 defendant Trenche John yeoman 607684 607684 Trenche, John, of Gressenhale, yeoman 0
4090504 2056886 2056886 defendant Hanforthe Richard husbandman 607684 607684 Hanforthe, Richard, of Gressenhale, husbandman 3
4548763 2215550 2215550 defendant Rous Alan   607684 607684 Rous, Alan, of Gressenhale 0
4548764 2215550 2215550 defendant Sekkere Simon   607684 607684 Sekkere, Simon, of Gressenhale 1
4590388 2228353 2228353 plaintiff Man Henry   607684 607684 Man, Henry, of Gressenhale 0
4642486 2243925 2243925 defendant Lamberkyn Geoffrey   607684 607684 Lamberkyn, Geoffrey, of Gressenhale 1
4645851 2244854 2244854 defendant Haweys William   607684 607684 Haweys, William, of Gressenhale 0
4663751 2250149 2250149 defendant Bleford Henry husbandman 607684 607684 Bleford, Henry, of Gressenhale, husbandman 0
4663756 2250150 2250150 defendant Bleford Henry husbandman 607684 607684 Bleford, Henry, of Gressenhale, husbandman 0
4784683 2291215 2291215 defendant Essex John, junior yeoman 607684 607684 Essex, John, junior, of Gressenhale, yeoman 1
4791893 2293565 2293565 defendant Hastynges Edward   607684 607684 Hastynges, Edward, of Gressenhale, knight 0
4924318 2334040 2334040 defendant Broun John husbandman 607684 607684 Broun, John, of Gressenhale, husbandman 1
4961173 2345305 2345305 defendant Goodson Richard husbandman 607684 607684 Goodson, Richard, of Gressenhale, husbandman 0
5075124 2379058 2379058 defendant Trenche Thomas husbandman 607684 607684 Trenche, Thomas, of Gressenhale, husbandman 4
5090253 2383521 2383521 defendant Boole Walter carpenter 607684 607684 Boole, Walter, of Gressenhale, carpenter 0
5097674 2385746 2385746 defendant Glastryon Robert husbandman 607684 607684 Glastryon, Robert, of Gressenhale, husbandman 0
5100017 2386441 2386441 defendant Beverley Robert yeoman 607684 607684 Beverley, Robert, of Gressenhale, yeoman 5
5105344 2388007 2388007 defendant Lely John yeoman 607684 607684 Lely, John, of Gressenhale, yeoman 0
5120066 2392306 2392306 defendant Glastryon Robert husbandman 607684 607684 Glastryon, Robert, of Gressenhale, husbandman 4
5139795 2398116 2398116 defendant Farwell John husbandman 607684 607684 Farwell, John, of Gressenhale, husbandman 2
5197474 2415002 2415002 defendant Farwell John husbandman 607684 607684 Farwell, John, of Gressenhale, husbandman 2
5228963 2424075 2424075 defendant Ketilston Thomas yeoman 607684 607684 Ketilston, Thomas, of Gressenhale, yeoman 1
5278856 2438926 2438926 defendant Lamkyn Thomas laborer 607684 607684 Lamkyn, Thomas, of Gressenhale, laborer 0
5282973 2440081 2440081 defendant Robyns Thomas, senior carpenter 607684 607684 Robyns, Thomas, senior, of Gressenhale, carpenter 0
5282974 2440081 2440081 defendant Robyns Henry yeoman 607684 607684 Robyns, Henry, of Gressenhale, yeoman 1
5288843 2441746 2441746 defendant Avelyn John clerk 607684 607684 Avelyn, John, of Gressenhale, clerk 1
5302377 2445679 2445679 defendant Lamkyn Thomas husbandman 607684 607684 Lamkyn, Thomas, of Gressenhale, husbandman 1
5316783 2450105 2450105 defendant Robyns Thomas carpenter 607684 607684 Robyns, Thomas, of Gressenhale, carpenter 0
5316784 2450105 2450105 defendant Robyns Henry yeoman 607684 607684 Robyns, Henry, of Gressenhale, yeoman 1
5317461 2450308 2450308 plaintiff Ferrour John, senior   607684 607684 Ferrour, John, senior, of Gressenhale 0
5428081 2483345 2483345 plaintiff Ferrour John, sen (legal representative) 607684 607684 Ferrour, John, sen, of Gressenhale, executors of 0
5428088 2483346 2483346 plaintiff Ferrour John, sen (legal representative) 607684 607684 Ferrour, John, sen, of Gressenhale, executors of 0
5445587 2488574 2488574 plaintiff Ferrour John, sen (legal representative) 607684 607684 Ferrour, John, sen, of Gressenhale, executors of 0
5445594 2488575 2488575 plaintiff Ferrour John, sen (legal representative) 607684 607684 Ferrour, John, sen, of Gressenhale, executors of 0
5481350 2499362 2499362 plaintiff Ferrour John (legal representative) 607684 607684 Ferrour, John, of Gressenhale, executors of 0
5481356 2499363 2499363 plaintiff Ferrour John (legal representative) 607684 607684 Ferrour, John, of Gressenhale, executors of 0
5481368 2499365 2499365 plaintiff Ferrour John, senior (legal representative) 607684 607684 Ferrour, John, senior, of Gressenhale, executors of 0
5481376 2499366 2499366 plaintiff Ferrour John, senior (legal representative) 607684 607684 Ferrour, John, senior, of Gressenhale, executors of 0
5573139 2526696 2526696 defendant Wynde John husbandman 607684 607684 Wynde, John, of Gressenhale, husbandman 1
5573988 2526955 2526955 defendant Shawe John yeoman 607684 607684 Shawe, John, of Gressenhale, yeoman 0
5575837 2527530 2527530 defendant Shawe John husbandman 607684 607684 Shawe, John, of Gressenhale, husbandman 3
5586707 2530881 2530881 defendant Robyns John (legal representative) 607684 607684 Robyns, John, of Gressenhale, executrix of 0
5586708 2530881 2530881 defendant Robyns Beatrice widow 607684 607684 Robyns, Beatrice, of Gressenhale, widow 1
5588703 2531477 2531477 defendant Ferrour Edmund yeoman 607684 607684 Ferrour, Edmund, of Gressenhale, yeoman 0
5593542 2532963 2532963 defendant Halman Thomas husbandman 607684 607684 Halman, Thomas, of Gressenhale, husbandman 0
5598568 2534437 2534437 defendant Shawe John yeoman 607684 607684 Shawe, John, of Gressenhale, yeoman 0
5606618 2536950 2536950 defendant Ferrour Edmund yeoman 607684 607684 Ferrour, Edmund, of Gressenhale, yeoman 0
5633532 2554484 2554484 defendant Coupere John laborer 607684 607684 Coupere, John, of Gressenhale, laborer 1
5633533 2554484 2554484 defendant Walssheman Philip laborer 607684 607684 Walssheman, Philip, of Gressenhale, laborer 2
5633535 2554484 2554484 defendant Hoo John chaplain 607684 607684 Hoo, John, of Gressenhale, chaplain 4

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