names

62 rows where place_id = 592863

✎ 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
3600711 1867876 1867876 defendant Sturmyn John   592863 592863 Sturmyn, John, of Magna Snoryng, shepherd 0
3609193 1870536 1870536 defendant Synys John chaplain 592863 592863 Synys, John, of Magna Snoryng, chaplain 1
3751605 1942417 1942417 defendant Cadys Adam husbandman 592863 592863 Cadys, Adam, of Magna Snoryng, husbandman 1
3752006 1942550 1942550 defendant Coo William husbandman 592863 592863 Coo, William, of Magna Snoryng, husbandman 0
3785660 1953305 1953305 defendant Coo William husbandman 592863 592863 Coo, William, of Magna Snoryng, husbandman 3
3785670 1953310 1953310 defendant Somer John husbandman 592863 592863 Somer, John, of Magna Snoryng, husbandman 0
3816358 1963026 1963026 defendant Coo William husbandman 592863 592863 Coo, William, of Magna Snoryng, husbandman 0
3820058 1964152 1964152 defendant Coo William husbandman 592863 592863 Coo, William, of Magna Snoryng, husbandman 1
3823910 1965349 1965349 defendant Coo William yeoman 592863 592863 Coo, William, of Magna Snoryng, yeoman 0
3840670 1970645 1970645 defendant Coo William husbandman 592863 592863 Coo, William, of Magna Snoryng, husbandman 1
3847421 1972756 1972756 defendant Morysch John   592863 592863 Morysch, John, of Magna Snoryng 1
3851067 1973926 1973926 defendant Coo William husbandman 592863 592863 Coo, William, of Magna Snoryng, husbandman 0
3913303 1994782 1994782 defendant Grene Richard husbandman 592863 592863 Grene, Richard, of Magna Snoryng, husbandman 0
3917415 1996183 1996183 defendant Hubberd Robert husbandman 592863 592863 Hubberd, Robert, of Magna Snoryng, husbandman 0
3943797 2004940 2004940 defendant Baxster William husbandman 592863 592863 Baxster, William, of Magna Snoryng, husbandman 0
3947527 2006206 2006206 defendant Haylott William husbandman 592863 592863 Haylott, William, of Magna Snoryng, husbandman 1
3984279 2019141 2019141 defendant Hudson Nicholas husbandman 592863 592863 Hudson, Nicholas, of Magna Snoryng, husbandman 1
4001853 2025436 2025436 defendant Bell John yeoman 592863 592863 Bell, John, of Magna Snoryng, yeoman 0
4015341 2030180 2030180 defendant Lightfote Thomas husbandman 592863 592863 Lightfote, Thomas, of Magna Snoryng, husbandman 1
4037460 2038059 2038059 defendant Lyghtfote Thomas husbandman 592863 592863 Lyghtfote, Thomas, of Magna Snoryng, husbandman 0
4132666 2072004 2072004 defendant Symond James sawyer 592863 592863 Symond, James, of Magna Snoryng, carpenter, sawyer 0
4136549 2073416 2073416 defendant Symond James husbandman 592863 592863 Symond, James, of Magna Snoryng, husbandman 0
4175714 2086977 2086977 defendant Rolfe John gent 592863 592863 Rolfe, John, of Magna Snoryng, gent 0
4656462 2247917 2247917 defendant Leek John husbandman 592863 592863 Leek, John, of Magna Snoryng, husbandman 1
4797368 2295348 2295348 defendant Neweman John yeoman 592863 592863 Neweman, John, of Magna Snoryng, yeoman 3
4876929 2319752 2319752 defendant Neweman Reginald yeoman 592863 592863 Neweman, Reginald, of Magna Snoryng, yeoman 0
4905052 2328189 2328189 defendant Newman John husbandman 592863 592863 Newman, John, of Magna Snoryng, husbandman 0
4934858 2337305 2337305 defendant Rudde Christian (legal representative) 592863 592863 Rudde, Christian, of Magna Snoryng, executrix of Rudde, Robert, of Magna Snoryng, executors of 0
4934859 2337305 2337305 defendant Dykkys Alan chaplain 592863 592863 (Dykkys, Alan, of Magna Snoryng, chaplain 1
4956660 2343949 2343949 defendant Offycyall Henry husbandman 592863 592863 Offycyall, Henry, of Magna Snoryng, husbandman 1
4968215 2347445 2347445 defendant Neweman John husbandman 592863 592863 Neweman, John, of Magna Snoryng, husbandman 1
4974738 2349412 2349412 defendant Snoryng Geoffrey gent 592863 592863 Snoryng, Geoffrey, of Magna Snoryng, gent 0
5032664 2366439 2366439 defendant Pyrtwell John thatcher 592863 592863 Pyrtwell, John, of Magna Snoryng, thatcher 0
5093588 2384524 2384524 defendant Seman Henry husbandman 592863 592863 Seman, Henry, of Magna Snoryng, husbandman 0
5093589 2384524 2384524 defendant Wright Robert husbandman 592863 592863 Wright, Robert, of Magna Snoryng, husbandman 1
5100760 2386646 2386646 defendant Pynner Alice   592863 592863 Pynner, Alice, of Magna Snoryng, servant 1
5110940 2389592 2389592 defendant Martyn John husbandman 592863 592863 Martyn, John, of Magna Snoryng, husbandman 0
5110941 2389592 2389592 defendant Whelpe Roger   592863 592863 Whelpe, Roger, of Magna Snoryng, shepherd 1
5112064 2389914 2389914 defendant Vyell John husbandman 592863 592863 Vyell, John, of Magna Snoryng, husbandman 0
5123609 2393363 2393363 defendant Sperhauk Thomas husbandman 592863 592863 Sperhauk, Thomas, of Magna Snoryng, husbandman 0
5214657 2420015 2420015 defendant Bateman John husbandman 592863 592863 Bateman, John, of Magna Snoryng, husbandman 4
5248520 2429692 2429692 defendant Qwelp Roger   592863 592863 Qwelp, Roger, of Magna Snoryng, shepherd 0
5248526 2429694 2429694 defendant Roudyard Richard husbandman 592863 592863 Roudyard, Richard, of Magna Snoryng, husbandman 0
5248527 2429694 2429694 defendant Sperhauk John husbandman 592863 592863 Sperhauk, John, of Magna Snoryng, husbandman 1
5248528 2429694 2429694 defendant Ryckys John husbandman 592863 592863 Ryckys, John, of Magna Snoryng, husbandman 2
5267093 2435466 2435466 defendant Whelpe Roger   592863 592863 Whelpe, Roger, of Magna Snoryng, shepherd 0
5295338 2443630 2443630 defendant Ilok Richard chapman 592863 592863 Ilok, Richard, of Magna Snoryng, chapman 3
5296849 2444067 2444067 defendant Whelp Roger   592863 592863 Whelp, Roger, of Magna Snoryng, shepherd 2
5312713 2448840 2448840 plaintiff Bateman John (legal representative) 592863 592863 Bateman, John, of Magna Snoryng, yeoman, executor of 0
5482659 2499758 2499758 defendant Hylok Richard husbandman 592863 592863 Hylok, Richard, of Magna Snoryng, husbandman 1
5487977 2501292 2501292 defendant Hert John tailor 592863 592863 Hert, John, of Magna Snoryng, tailor 2
5494811 2503338 2503338 defendant Bateman Ralph husbandman 592863 592863 (Bateman, Ralph, of Magna Snoryng, husbandman 1
5496521 2503870 2503870 defendant Bateman Ralph husbandman 592863 592863 (Bateman, Ralph, of Magna Snoryng, husbandman 1
5531306 2514310 2514310 defendant Grene Robert husbandman 592863 592863 Grene, Robert, of Magna Snoryng, husbandman 0
5538687 2516581 2516581 defendant Willyamson Edmund husbandman 592863 592863 Willyamson, Edmund, of Magna Snoryng, husbandman 0
5538690 2516582 2516582 defendant Wyllyamson Edmund husbandman 592863 592863 Wyllyamson, Edmund, of Magna Snoryng, husbandman 0
5546084 2518852 2518852 defendant Wyllyamson Edmund husbandman 592863 592863 Wyllyamson, Edmund, of Magna Snoryng, husbandman 0
5558951 2522569 2522569 plaintiff Pytt John   592863 592863 Pytt, John, of Magna Snoryng 0
5574370 2527068 2527068 defendant Jesoppe John (legal representative) 592863 592863 Jesoppe, John, of Magna Snoryng, saddler, executors of 0
5574371 2527068 2527068 defendant Grene Robert yeoman 592863 592863 (Grene, Robert, of Magna Snoryng, yeoman 1
5577133 2527896 2527896 defendant Spek William husbandman 592863 592863 Spek, William, of Magna Snoryng, husbandman 1
5590567 2532018 2532018 defendant Hiloke Thomas husbandman 592863 592863 Hiloke, Thomas, of Magna Snoryng, husbandman 2

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