names

187 rows where place_id = 590586

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, forename, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3601715 1868190 1868190 defendant Thistill Joan widow 590586 590586 Thistill, Joan, of Scarburgh, widow 1
3601716 1868190 1868190 defendant Thistill Lawrence fisherman 590586 590586 Thistill, Lawrence, of Scarburgh, fisherman 2
3608511 1870322 1870322 defendant Roderam Henry beer brewer 590586 590586 Roderam, Henry, of Scarburgh, beer brewer 0
3629041 1903960 1903960 defendant Scott James yeoman 590586 590586 Scott, James, of Scarburgh, yeoman 2
3690138 1923074 1923074 defendant Hagerston Cuthbert (legal representative) 590586 590586 Hagerston, Cuthbert, of Scarburgh, merchant, executors of 0
3690149 1923076 1923076 defendant Corwell Thomas (legal representative) 590586 590586 Corwell, Thomas, of Scarburgh, draper, executor of 0
3690150 1923076 1923076 defendant Corwell William smith 590586 590586 Corwell, William, of Scarburgh, smith 1
3698456 1925738 1925738 defendant Threske William merchant 590586 590586 Threske, William, of Scarburgh, merchant 0
3698457 1925738 1925738 defendant Pulley John merchant 590586 590586 Pulley, John, of Scarburgh, merchant 1
3701363 1926671 1926671 defendant Gower Thomas yeoman 590586 590586 Gower, Thomas, of Scarburgh, yeoman 0
3704593 1927726 1927726 plaintiff Fysshe John (legal representative) 590586 590586 Fysshe, John, of Scarburgh, merchant, executors of 0
3704598 1927726 1927726 defendant Hagerston Cuthbert merchant 590586 590586 Hagerston, Cuthbert, of Scarburgh, merchant 2
3712962 1930378 1930378 defendant Wod John cordwainer 590586 590586 Wod, John, of Scarburgh, cordwainer 0
3712963 1930378 1930378 defendant Walles Richard tanner 590586 590586 Walles, Richard, of Scarburgh, tanner 1
3712964 1930378 1930378 defendant Harwode Thomas yeoman 590586 590586 Harwode, Thomas, of Scarburgh, yeoman 2
3756298 1943931 1943931 defendant Harlond Roland   590586 590586 Harlond, Roland, of Scarburgh, wool driver 0
3756299 1943931 1943931 defendant Hynderwell Richard   590586 590586 Hynderwell, Richard, of Scarburgh, wool driver 1
3813000 1961968 1961968 defendant Fysshe William tanner 590586 590586 Fysshe, William, of Scarburgh, tanner 0
3820082 1964159 1964159 defendant Nicolson William baker 590586 590586 Nicolson, William, of Scarburgh, baker 0
3820083 1964159 1964159 defendant Richardson William tailor 590586 590586 Richardson, William, of Scarburgh, tailor 1
3820084 1964159 1964159 defendant Fysshe Guy tanner 590586 590586 Fysshe, Guy, of Scarburgh, tanner 2
3820085 1964159 1964159 defendant Hagarston Roger yeoman 590586 590586 Hagarston, Roger, of Scarburgh, yeoman 3
3820086 1964159 1964159 defendant Wallys Robert yeoman 590586 590586 Wallys, Robert, of Scarburgh, yeoman 4
3820087 1964159 1964159 defendant Hall Henry baker 590586 590586 Hall, Henry, of Scarburgh, baker 5
3820088 1964159 1964159 defendant Fysshe Lawrence yeoman 590586 590586 Fysshe, Lawrence, of Scarburgh, yeoman 6
3820089 1964159 1964159 defendant Lounde Roger laborer 590586 590586 Lounde, Roger, of Scarburgh, laborer 7
3820090 1964159 1964159 defendant Darby Richard laborer 590586 590586 Darby, Richard, of Scarburgh, laborer 8
3987313 2020210 2020210 defendant Conyers Richard yeoman 590586 590586 Conyers, Richard, of Scarburgh, yeoman 0
4506911 2202632 2202632 defendant Ryghollye Robert   590586 590586 Ryghollye, Robert, of Scarburgh 2
4512792 2204435 2204435 defendant Byngle Richard   590586 590586 Byngle, Richard, of Scarburgh 2
4520531 2206771 2206771 plaintiff Fobton John   590586 590586 Fobton, John, of Scarburgh 0
4524979 2208150 2208150 plaintiff Hunter Robert   590586 590586 Hunter, Robert, of Scarburgh 0
4524982 2208151 2208151 plaintiff Hunter Robert   590586 590586 Hunter, Robert, of Scarburgh 0
4525870 2208389 2208389 defendant Porter John   590586 590586 Porter, John, of Scarburgh, burgess 0
4559239 2218844 2218844 plaintiff Mauby Richard   590586 590586 Mauby, Richard, of Scarburgh 0
4570051 2222204 2222204 defendant Santon Thomas merchant 590586 590586 Santon, Thomas, of Scarburgh, merchant 3
4571490 2222662 2222662 defendant Lokton Roger de   590586 590586 Lokton, Roger de, of Scarburgh 5
4574704 2223617 2223617 defendant Barker Roger   590586 590586 Barker, Roger, of Scarburgh 0
4574705 2223617 2223617 defendant Webster William   590586 590586 Webster, William, of Scarburgh 1
4574706 2223617 2223617 defendant Endwyne Thomas   590586 590586 Endwyne, Thomas, of Scarburgh 2
4581355 2225635 2225635 defendant Sledmere Robert   590586 590586 Sledmere, Robert, of Scarburgh 0
4581356 2225635 2225635 defendant Sledmere John   590586 590586 Sledmere, John, of Scarburgh 1
4584298 2226499 2226499 defendant Couper Richard   590586 590586 Couper, Richard, of Scarburgh 3
4595402 2229817 2229817 defendant Santon Thomas merchant 590586 590586 Santon, Thomas, of Scarburgh, merchant 0
4603222 2232214 2232214 defendant Scote John   590586 590586 Scote, John, of Scarburgh 5
4610337 2234319 2234319 plaintiff Carethorp Thomas   590586 590586 Carethorp, Thomas, of Scarburgh 0
4618433 2236775 2236775 plaintiff Harom William   590586 590586 Harom, William, of Scarburgh 0
4618435 2236776 2236776 plaintiff Harom William   590586 590586 Harom, William, of Scarburgh 0
4629557 2240171 2240171 defendant Gillymore Thomas   590586 590586 Gillymore, Thomas, of Scarburgh 0
4633998 2241486 2241486 defendant Collum John   590586 590586 Collum, John, of Scarburgh 0
4633999 2241486 2241486 defendant Percy William   590586 590586 Percy, William, of Scarburgh 1
4638437 2242785 2242785 plaintiff Carethorp Thomas   590586 590586 Carethorp, Thomas, of Scarburgh 0
4647545 2245342 2245342 plaintiff Shilbotell Robert (legal representative) 590586 590586 Shilbotell, Robert, of Scarburgh, executors of 0
4647546 2245342 2245342 plaintiff Bautre Richard de   590586 590586 (Bautre, Richard de, of Scarburgh 1
4647548 2245342 2245342 defendant Colvyle Thomas   590586 590586 Colvyle, Thomas, of Scarburgh, ship wright 0
4647549 2245342 2245342 defendant Burton William   590586 590586 Burton, William, of Scarburgh 1
4652281 2246663 2246663 defendant Edeson William fisher 590586 590586 Edeson, William, of Scarburgh, fisher 0
4661139 2249309 2249309 defendant Wassand William glover 590586 590586 Wassand, William, of Scarburgh, glover 0
4661257 2249342 2249342 defendant Fyveley Henry yeoman 590586 590586 Fyveley, Henry, of Scarburgh, yeoman 0
4669745 2256239 2256239 defendant Remmeswell William yeoman 590586 590586 Remmeswell, William, of Scarburgh, yeoman 3
4669746 2256239 2256239 defendant Webster John weaver & brother of William Remmeswell 590586 590586 Webster, John, of Scarburgh, weaver & brother of William Remmeswell 4
4678255 2258807 2258807 plaintiff Hill John   590586 590586 Hill, John, of Scarburgh 0
4678256 2258807 2258807 defendant Adamson John mariner 590586 590586 Adamson, John, of Scarburgh, mariner 0
4678257 2258807 2258807 defendant Gilson Richard mariner 590586 590586 Gilson, Richard, of Scarburgh, mariner 1
4678258 2258807 2258807 defendant Morton Thomas mariner 590586 590586 Morton, Thomas, of Scarburgh, mariner 2
4680522 2259520 2259520 defendant Sage William merchant 590586 590586 Sage, William, of Scarburgh, merchant 0
4684221 2260668 2260668 defendant Alnewyk John butcher 590586 590586 Alnewyk, John, of Scarburgh, butcher 0
4685309 2261001 2261001 defendant Bautre Richard yeoman 590586 590586 Bautre, Richard, of Scarburgh, yeoman 0
4686242 2261298 2261298 defendant Bautre Richard   590586 590586 Bautre, Richard, of Scarburgh 0
4688127 2261855 2261855 defendant Harwode John fisher 590586 590586 Harwode, John, of Scarburgh, fisher 0
4711814 2269020 2269020 defendant Skryvener Thomas yeoman 590586 590586 Skryvener, Thomas, of Scarburgh, yeoman 0
4715922 2270293 2270293 defendant Betester John butcher 590586 590586 Betester, John, of Scarburgh, butcher 1
4715923 2270293 2270293 defendant Wylle Richard   590586 590586 Wylle, Richard, of Scarburgh, wright 2
4720221 2271668 2271668 defendant Wade John husbandman 590586 590586 Wade, John, of Scarburgh, husbandman 3
4720905 2271872 2271872 plaintiff Burton Robert (legal representative) 590586 590586 Burton, Robert, of Scarburgh, executrix of 0
4720906 2271872 2271872 plaintiff Burton Alice   590586 590586 Burton, Alice, of Scarburgh, formerly wife of Robert 1
4720907 2271872 2271872 defendant Bernard John shipman 590586 590586 Bernard, John, of Scarburgh, shipman 0
4720908 2271872 2271872 defendant Andrewe John yeoman 590586 590586 Andrewe, John, of Scarburgh, yeoman 1
4723860 2272766 2272766 plaintiff Wardale Robert   590586 590586 Wardale, Robert, of Scarburgh, burgess 1
4723864 2272767 2272767 plaintiff Wardale Robert   590586 590586 Wardale, Robert, of Scarburgh, burgess 1
4737757 2276913 2276913 defendant Wresill John fishmonger 590586 590586 Wresill, John, of Scarburgh, fishmonger 0
4741455 2277996 2277996 defendant Woller William yeoman 590586 590586 Woller, William, of Scarburgh, yeoman 0
4743684 2278682 2278682 defendant Couper John yeoman 590586 590586 Couper, John, of Scarburgh, yeoman 0
4743685 2278682 2278682 defendant Lous Ralph yeoman 590586 590586 Lous, Ralph, of Scarburgh, yeoman 1
4743697 2278686 2278686 defendant Topeclyff George gent 590586 590586 Topeclyff, George, of Scarburgh, gent 0
4752665 2281239 2281239 defendant Santon Thomas yeoman 590586 590586 Santon, Thomas, of Scarburgh, yeoman 6
4752740 2281259 2281259 plaintiff Topclyf Beatrice   590586 590586 Topclyf, Beatrice, of Scarburgh, formerly wife of Richard Topclyf 0
4752741 2281259 2281259 defendant Sowelyng James fisher 590586 590586 Sowelyng, James, of Scarburgh, fisher 0
4762338 2284203 2284203 plaintiff Flesshewer John   590586 590586 Flesshewer, John, of Scarburgh 0
4783199 2290762 2290762 defendant Doweson John fisherman 590586 590586 Doweson, John, of Scarburgh, fisherman 0
4783201 2290763 2290763 defendant Jonson Robert chapman 590586 590586 Jonson, Robert, of Scarburgh, chapman 0
4784033 2291014 2291014 defendant Aklom John merchant 590586 590586 Aklom, John, of Scarburgh, merchant 2
4785883 2291618 2291618 plaintiff Flesshewer John   590586 590586 Flesshewer, John, of Scarburgh 0
4787439 2292143 2292143 defendant Helperby Joan   590586 590586 Helperby, Joan, of Scarburgh, widow of Helperby, William 0
4803245 2297207 2297207 defendant Ikilton Roger chapman 590586 590586 Ikilton, Roger, of Scarburgh, chapman 0
4805467 2297921 2297921 defendant Wressyll Richard (legal representative) 590586 590586 Wressyll, Richard, of Scarburgh, executrix of 0
4805468 2297921 2297921 defendant Wressyll Agnes widow 590586 590586 Wressyll, Agnes, of Scarburgh, widow 1
4815876 2301066 2301066 defendant Fox John laborer 590586 590586 Fox, John, of Scarburgh, laborer 2
4816320 2301191 2301191 defendant Bynglay John chapman 590586 590586 Bynglay, John, of Scarburgh, chapman 0
4825796 2304105 2304105 defendant Mawellum Thomas draper 590586 590586 Mawellum, Thomas, of Scarburgh, draper 0

Next page

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