names

149 rows where place_id = 592609

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3608236 1870231 1870231 defendant Robertson William husbandman 592609 592609 Robertson, William, of Leverton, husbandman 1
3611171 1871170 1871170 defendant Pepper Thomas husbandman 592609 592609 Pepper, Thomas, of Leverton, husbandman 1
3742174 1939419 1939419 defendant Hall Ralph gent 592609 592609 Hall, Ralph, of Leverton, gent 0
3769530 1948132 1948132 defendant Shepard John clerk 592609 592609 Shepard, John, of Leverton, clerk 0
3804319 1959287 1959287 defendant Lymme William husbandman 592609 592609 Lymme, William, of Leverton, husbandman 0
3806036 1959815 1959815 defendant Hopkynson John husbandman 592609 592609 Hopkynson, John, of Leverton, husbandman 2
3840345 1970548 1970548 defendant Fendyke Richard, junior husbandman 592609 592609 Fendyke, Richard, junior, of Leverton, husbandman 0
3853186 1974617 1974617 defendant Strales Christopher husbandman 592609 592609 Strales, Christopher, of Leverton, husbandman 0
3867679 1979425 1979425 defendant Strayles Christopher husbandman 592609 592609 Strayles, Christopher, of Leverton, husbandman 0
3868599 1979736 1979736 defendant Lymme Thomas husbandman 592609 592609 Lymme, Thomas, of Leverton, husbandman 0
3882470 1984399 1984399 defendant Lymme Thomas husbandman 592609 592609 Lymme, Thomas, of Leverton, husbandman 0
4007045 2027295 2027295 defendant Kenyngton Cuthbert weaver 592609 592609 Kenyngton, Cuthbert, of Leverton, weaver 0
4016864 2030730 2030730 plaintiff Sybsey Stephen yeoman 592609 592609 Sybsey, Stephen, of Leverton, yeoman 0
4132388 2071900 2071900 defendant Jackson Henry yeoman 592609 592609 Jackson, Henry, of Leverton, yeoman 0
4148173 2077493 2077493 defendant Stipladye John husbandman 592609 592609 Stipladye, John, of Leverton, husbandman 0
4148175 2077494 2077494 defendant Typladye John husbandman 592609 592609 Typladye, John, of Leverton, husbandman 0
4168616 2084508 2084508 defendant Cade Peter husbandman 592609 592609 Cade, Peter, of Leverton, husbandman 0
4168619 2084509 2084509 defendant Cade Peter husbandman 592609 592609 Cade, Peter, of Leverton, husbandman 0
4173110 2086052 2086052 defendant Roger Christopher yeoman 592609 592609 Roger, Christopher, of Leverton, yeoman 0
4173111 2086052 2086052 defendant Benyson Thomas yeoman 592609 592609 Benyson, Thomas, of Leverton, yeoman 1
4173112 2086052 2086052 defendant Sucket Thomas yeoman 592609 592609 Sucket, Thomas, of Leverton, yeoman 2
4173113 2086052 2086052 defendant Osborne Thomas yeoman 592609 592609 Osborne, Thomas, of Leverton, yeoman 3
4173114 2086052 2086052 defendant Stanose William yeoman 592609 592609 Stanose, William, of Leverton, yeoman 4
4173119 2086054 2086054 defendant Suckett Alan yeoman 592609 592609 Suckett, Alan, of Leverton, yeoman 0
4173120 2086054 2086054 defendant Stanes John yeoman 592609 592609 Stanes, John, of Leverton, yeoman 1
4173121 2086054 2086054 defendant Agarr Marmaduke yeoman 592609 592609 Agarr, Marmaduke, of Leverton, yeoman 2
4173122 2086054 2086054 defendant Toes Miles yeoman 592609 592609 Toes, Miles, of Leverton, yeoman 3
4173124 2086054 2086054 defendant Marsigell Henry yeoman 592609 592609 Marsigell, Henry, of Leverton, yeoman 5
4188523 2091461 2091461 defendant Jackson alias Cocke Henry tailor 592609 592609 Jackson alias Cocke, Henry, of Leverton, yeoman, tailor 0
4188525 2091462 2091462 defendant Jackson alias Cooke Henry tailor 592609 592609 Jackson alias Cooke, Henry, of Leverton, yeoman, tailor 0
4196373 2094275 2094275 defendant Parkynge John husbandman 592609 592609 Parkynge, John, of Leverton, husbandman 0
4219361 2102269 2102269 defendant Dowse Francis laborer 592609 592609 Dowse, Francis, of Leverton, laborer 0
4239765 2109539 2109539 defendant Robinson Simon yeoman 592609 592609 Robinson, Simon, of Leverton, yeoman 0
4243643 2110860 2110860 defendant Falkener William yeoman 592609 592609 Falkener, William, of Leverton, yeoman 0
4243645 2110861 2110861 defendant Falkener William yeoman 592609 592609 Falkener, William, of Leverton, yeoman 0
4243647 2110862 2110862 defendant Falkener William yeoman 592609 592609 Falkener, William, of Leverton, yeoman 0
4243649 2110863 2110863 defendant Falkoner William yeoman 592609 592609 Falkoner, William, of Leverton, yeoman 0
4243651 2110864 2110864 defendant Falkoner William yeoman 592609 592609 Falkoner, William, of Leverton, yeoman 0
4248075 2112342 2112342 defendant Robinson Simon yeoman 592609 592609 Robinson, Simon, of Leverton, yeoman 0
4254117 2114372 2114372 defendant Falkner William yeoman 592609 592609 Falkner, William, of Leverton, yeoman 0
4254119 2114373 2114373 defendant Falkner William yeoman 592609 592609 Falkner, William, of Leverton, yeoman 0
4254121 2114374 2114374 defendant Falkner William yeoman 592609 592609 Falkner, William, of Leverton, yeoman 0
4254123 2114375 2114375 defendant Julian Alexander yeoman 592609 592609 Julian, Alexander, of Leverton, yeoman 0
4254125 2114376 2114376 defendant Julyan Alexander yeoman 592609 592609 Julyan, Alexander, of Leverton, yeoman 0
4276073 2121580 2121580 defendant Chambers John clerk 592609 592609 Chambers, John, of Leverton, clerk 1
4283552 2124155 2124155 defendant Huckbodye John yeoman 592609 592609 Huckbodye, John, of Leverton, yeoman 3
4298981 2129732 2129732 defendant Julyon Alexander husbandman 592609 592609 Julyon, Alexander, of Leverton, husbandman 2
4310595 2133855 2133855 defendant Gaynes John yeoman 592609 592609 Gaynes, John, of Leverton, yeoman 0
4407017 2166904 2166904 defendant Bosse Thomas yeoman 592609 592609 Bosse, Thomas, of Leverton, yeoman 0
4435248 2175782 2175782 defendant Fendyk Walter de   592609 592609 Fendyk, Walter de, of Leverton 0
4461907 2188783 2188783 defendant Saule John pardoner 592609 592609 Saule, John, of Leverton, pardoner 3
4462859 2189073 2189073 defendant Tebald John   592609 592609 Tebald, John, of Leverton, son of William 0
4464781 2189649 2189649 defendant Saule John   592609 592609 Saule, John, of Leverton 4
4485995 2196324 2196324 defendant Prest William butcher 592609 592609 Prest, William, of Leverton, butcher 1
4495006 2199128 2199128 plaintiff Brymand Robert   592609 592609 Brymand, Robert, of Leverton 0
4503567 2201690 2201690 defendant Roper Richard   592609 592609 Roper, Richard, of Leverton 0
4503568 2201691 2201691 plaintiff Pikeryng John   592609 592609 Pikeryng, John, of Leverton 0
4503570 2201691 2201691 defendant Ropar Richard   592609 592609 Ropar, Richard, of Leverton 0
4548856 2215577 2215577 defendant atte Grene John   592609 592609 atte Grene, John, of Leverton 0
4549249 2215704 2215704 defendant Emson John   592609 592609 Emson, John, of Leverton 0
4549250 2215704 2215704 defendant Grene Philip   592609 592609 Grene, Philip, of Leverton 1
4563480 2220150 2220150 plaintiff Robertson Walter   592609 592609 Robertson, Walter, of Leverton 0
4563481 2220150 2220150 defendant Milner Hugh   592609 592609 Milner, Hugh, of Leverton 0
4607487 2233452 2233452 defendant Thomas Edmund   592609 592609 Thomas, Edmund, of Leverton 0
4615917 2235976 2235976 plaintiff Flete James   592609 592609 Flete, James, of Leverton 0
4626679 2239288 2239288 defendant Keger William   592609 592609 Keger, William, of Leverton 0
4638957 2242917 2242917 defendant Pykeryng William   592609 592609 Pykeryng, William, of Leverton 1
4641302 2243550 2243550 defendant Broun John, sen   592609 592609 Broun, John, sen, of Leverton 0
4662179 2249645 2249645 defendant Bust Walter laborer 592609 592609 Bust, Walter, of Leverton, laborer 0
4681013 2259685 2259685 defendant Belour Alan laborer 592609 592609 Belour, Alan, of Leverton, laborer 0
4681014 2259685 2259685 defendant Milner John laborer & son of Robert 592609 592609 Milner, John, of Leverton, laborer & son of Robert 1
4686723 2261459 2261459 defendant Cave John husbandman 592609 592609 Cave, John, of Leverton, husbandman 0
4686726 2261460 2261460 defendant Gane John husbandman 592609 592609 Gane, John, of Leverton, husbandman 0
4708207 2267944 2267944 defendant Studard Thomas yeoman 592609 592609 Studard, Thomas, of Leverton, yeoman 1
4731541 2275062 2275062 plaintiff Sote Helen   592609 592609 Sote, Helen, of Leverton 1
4745762 2279268 2279268 defendant Cook Thomas   592609 592609 Cook, Thomas, of Leverton, wright 2
4753436 2281451 2281451 defendant Lacy John husbandman 592609 592609 Lacy, John, of Leverton, husbandman 0
4771401 2287036 2287036 defendant Sleyght William laborer 592609 592609 Sleyght, William, of Leverton, laborer 1
4793136 2293946 2293946 defendant Warner Thomas husbandman 592609 592609 Warner, Thomas, of Leverton, husbandman 0
4793139 2293947 2293947 defendant Warner John husbandman 592609 592609 Warner, John, of Leverton, husbandman 0
4830110 2305459 2305459 defendant Serlam John fishmonger 592609 592609 Serlam, John, of Leverton, fishmonger 0
4832473 2306188 2306188 defendant Robertson Edmund husbandman 592609 592609 Robertson, Edmund, of Leverton, husbandman 0
4835433 2307077 2307077 defendant Wyllughby William miller 592609 592609 Wyllughby, William, of Leverton, miller 3
4846178 2310309 2310309 defendant Clemetson Richard husbandman 592609 592609 Clemetson, Richard, of Leverton, husbandman 0
4846179 2310309 2310309 defendant Studhard Thomas yeoman 592609 592609 Studhard, Thomas, of Leverton, yeoman 1
4847235 2310633 2310633 defendant Lacy John husbandman 592609 592609 Lacy, John, of Leverton, husbandman 0
4848748 2311074 2311074 defendant Pykeryng Richard   592609 592609 Pykeryng, Richard, of Leverton, wright 0
4868080 2316990 2316990 defendant Grene John husbandman 592609 592609 Grene, John, of Leverton, husbandman 0
4879918 2320633 2320633 defendant Grene John husbandman 592609 592609 Grene, John, of Leverton, husbandman 0
4886080 2322505 2322505 defendant Colson John husbandman 592609 592609 Colson, John, of Leverton, husbandman 1
4886081 2322505 2322505 defendant Towelyn William husbandman 592609 592609 Towelyn, William, of Leverton, husbandman 2
4886082 2322505 2322505 defendant Kecher William husbandman 592609 592609 Kecher, William, of Leverton, husbandman 3
4897477 2325872 2325872 defendant Roberdson Edmund husbandman 592609 592609 Roberdson, Edmund, of Leverton, husbandman 1
4897478 2325872 2325872 defendant Towelyn Edmund husbandman 592609 592609 Towelyn, Edmund, of Leverton, husbandman 2
4954933 2343433 2343433 defendant Robertson Edmund husbandman 592609 592609 Robertson, Edmund, of Leverton, husbandman 0
4960894 2345221 2345221 defendant Silon John husbandman 592609 592609 Silon, John, of Leverton, husbandman 2
4982344 2351634 2351634 defendant Caly John husbandman 592609 592609 Caly, John, of Leverton, husbandman 3
5009897 2359768 2359768 defendant Wylughby William milner 592609 592609 Wylughby, William, of Leverton, milner 6
5027017 2364773 2364773 defendant Pyerson Richard husbandman 592609 592609 Pyerson, Richard, of Leverton, husbandman 0
5031512 2366076 2366076 defendant Pereson Richard husbandman 592609 592609 Pereson, Richard, of Leverton, husbandman 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);