names

71 rows where place_id = 587809

✎ 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
3592507 1865271 1865271 defendant Villers Charles merchant 587809 587809 Villers, Charles, of Loughborough, merchant 0
3595808 1866323 1866323 defendant Bagnale John laborer 587809 587809 Bagnale, John, of Loughborough, laborer 0
3658984 1913075 1913075 defendant Howden John   587809 587809 Howden, John, of Loughborough, inn holder 0
3664839 1914949 1914949 defendant Irelond Hugh husbandman 587809 587809 Irelond, Hugh, of Loughborough, husbandman 0
3701104 1926593 1926593 plaintiff Blower John   587809 587809 Blower, John, of Loughborough 0
3701105 1926593 1926593 defendant Lemyngton Ralph (legal representative) 587809 587809 Lemyngton, Ralph, of Loughborough, merchant of the staple, executor of 0
3705652 1928050 1928050 defendant Baker Richard husbandman 587809 587809 Baker, Richard, of Loughborough, husbandman 0
3711957 1930054 1930054 defendant Harvy John mercer 587809 587809 Harvy, John, of Loughborough, mercer 0
3720494 1932693 1932693 defendant Benham Edward yeoman 587809 587809 Benham, Edward, of Loughborough, yeoman 1
3720495 1932693 1932693 defendant Smyth Thomas yeoman 587809 587809 Smyth, Thomas, of Loughborough, yeoman 2
3725114 1934143 1934143 defendant Taylyer John chaplain 587809 587809 Taylyer, John, of Loughborough, chaplain 0
3725115 1934143 1934143 defendant Jenkynson John chaplain 587809 587809 Jenkynson, John, of Loughborough, chaplain 1
3740063 1938746 1938746 defendant Lane William mercer 587809 587809 Lane, William, of Loughborough, mercer 2
3740716 1938959 1938959 defendant Melbourne Edward smith 587809 587809 Melbourne, Edward, of Loughborough, smith 0
3740718 1938960 1938960 defendant Melbourne Edward smith 587809 587809 Melbourne, Edward, of Loughborough, smith 0
3744925 1940316 1940316 defendant Blower John miller 587809 587809 Blower, John, of Loughborough, miller 0
3749176 1941671 1941671 defendant Blower John miller 587809 587809 Blower, John, of Loughborough, miller 0
3753878 1943160 1943160 plaintiff Stathum Robert   587809 587809 Stathum, Robert, of Loughborough 0
3753879 1943160 1943160 defendant Chasse Edward butcher 587809 587809 Chasse, Edward, of Loughborough, butcher 0
3755889 1943795 1943795 defendant Blewes William baker 587809 587809 Blewes, William, of Loughborough, baker 0
3755890 1943795 1943795 defendant Denham Edward innholder 587809 587809 Denham, Edward, of Loughborough, innholder 1
3763715 1946297 1946297 defendant Columbell John husbandman 587809 587809 Columbell, John, of Loughborough, husbandman 0
3770300 1948381 1948381 defendant Denham Edward yeoman 587809 587809 Denham, Edward, of Loughborough, yeoman 1
3770301 1948381 1948381 defendant Smyth Thomas yeoman 587809 587809 Smyth, Thomas, of Loughborough, yeoman 2
3781666 1952006 1952006 plaintiff Hawden Robert mercer 587809 587809 Hawden, Robert, of Loughborough, mercer 0
3795914 1956586 1956586 defendant Hawden Robert mercer 587809 587809 Hawden, Robert, of Loughborough, mercer 0
3804268 1959268 1959268 defendant Hawden Robert mercer 587809 587809 Hawden, Robert, of Loughborough, mercer 0
3821929 1964752 1964752 defendant Baker Richard husbandman 587809 587809 Baker, Richard, of Loughborough, husbandman 0
3821930 1964752 1964752 defendant Columbell John innholder 587809 587809 Columbell, John, of Loughborough, innholder 1
3832613 1968125 1968125 defendant Wyllond Christopher draper 587809 587809 Wyllond, Christopher, of Loughborough, draper 0
3926179 1999077 1999077 defendant Howden Robert mercer 587809 587809 Howden, Robert, of Loughborough, mercer 0
4674001 2257484 2257484 plaintiff Dexter Henry   587809 587809 Dexter, Henry, of Loughborough 0
4706713 2267484 2267484 defendant Irenmonger Ralph husbandman 587809 587809 Irenmonger, Ralph, of Loughborough, husbandman 2
4707370 2267680 2267680 defendant Marchall Richard husbandman 587809 587809 Marchall, Richard, of Loughborough, husbandman 0
4717021 2270653 2270653 defendant Irnemonger Ralph husbandman 587809 587809 Irnemonger, Ralph, of Loughborough, husbandman 0
4717023 2270653 2270653 defendant Foster John   587809 587809 Foster, John, of Loughborough, fish monger 2
4742157 2278199 2278199 defendant Bunk John husbandman 587809 587809 Bunk, John, of Loughborough, husbandman 2
4742209 2278212 2278212 defendant Bocher Richard husbandman 587809 587809 Bocher, Richard, of Loughborough, husbandman 2
4743988 2278768 2278768 defendant Ludlowe John   587809 587809 Ludlowe, John, of Loughborough, bailiff 0
4744525 2278924 2278924 defendant Barton John husbandman 587809 587809 Barton, John, of Loughborough, husbandman 2
4748009 2279930 2279930 plaintiff Loretop Richard   587809 587809 Loretop, Richard, of Loughborough 0
4753980 2281628 2281628 defendant Milner Roger milner 587809 587809 Milner, Roger, of Loughborough, milner 0
4756928 2282534 2282534 defendant Man William husbandman 587809 587809 Man, William, of Loughborough, husbandman 0
4757443 2282702 2282702 defendant Sadeler Robert husbandman 587809 587809 Sadeler, Robert, of Loughborough, husbandman 1
4767366 2285782 2285782 plaintiff Marchall Richard   587809 587809 Marchall, Richard, of Loughborough 0
4832122 2306077 2306077 plaintiff Burton William   587809 587809 Burton, William, of Loughborough 0
4832126 2306077 2306077 defendant Bocher John butcher 587809 587809 Bocher, John, of Loughborough, butcher 3
4844216 2309699 2309699 defendant Rothelay John merchant 587809 587809 Rothelay, John, of Loughborough, merchant 0
4926557 2334725 2334725 defendant Irenmonger William spicer 587809 587809 Irenmonger, William, of Loughborough, spicer 1
4927668 2335089 2335089 defendant Derby John (legal representative) 587809 587809 Derby, John, of Loughborough, executors of 0
4927676 2335090 2335090 defendant Derby John (legal representative) 587809 587809 Derby, John, of Loughborough, executors of 0
5124961 2393776 2393776 defendant Hanne William yeoman 587809 587809 Hanne, William, of Loughborough, yeoman 0
5141742 2398698 2398698 defendant Rydynges John yeoman 587809 587809 Rydynges, John, of Loughborough, yeoman 2
5142787 2399019 2399019 defendant Hygdon William husbandman 587809 587809 Hygdon, William, of Loughborough, husbandman 3
5418882 2480573 2480573 defendant Parker (illegible) yeoman 587809 587809 Parker, _, of Loughborough, yeoman 0
5436661 2485892 2485892 defendant Byllyngton John butcher 587809 587809 Byllyngton, John, of Loughborough, butcher 3
5452521 2490634 2490634 defendant Coles William   587809 587809 Coles, William, of Loughborough 0
5480681 2499185 2499185 defendant Coles William butcher 587809 587809 Coles, William, of Loughborough, butcher 0
5480682 2499185 2499185 defendant Laurence John miller 587809 587809 Laurence, John, of Loughborough, miller 1
5484434 2500261 2500261 defendant Hallot William yeoman 587809 587809 Hallot, William, of Loughborough, yeoman 0
5484440 2500263 2500263 defendant Rydyngys John yeoman 587809 587809 Rydyngys, John, of Loughborough, yeoman 0
5484442 2500264 2500264 defendant Rythyngg John yeoman 587809 587809 Rythyngg, John, of Loughborough, yeoman 0
5512309 2508708 2508708 defendant Parker Richard yeoman 587809 587809 Parker, Richard, of Loughborough, yeoman 1
5512689 2508824 2508824 defendant Meryng Gilbert (legal representative) 587809 587809 Meryng, Gilbert, of Loughborough, gent, administratrix of 0
5523612 2512210 2512210 defendant Brodehurst John yeoman 587809 587809 Brodehurst, John, of Loughborough, yeoman 0
5536714 2515968 2515968 defendant Taylour Thomas innholder 587809 587809 Taylour, Thomas, of Loughborough, innholder 1
5573150 2526699 2526699 defendant Lygh John yeoman 587809 587809 Lygh, John, of Loughborough, yeoman 0
5573151 2526699 2526699 defendant Lygh Bartholomew yeoman 587809 587809 Lygh, Bartholomew, of Loughborough, yeoman 1
5573152 2526699 2526699 defendant Newton Richard yeoman 587809 587809 Newton, Richard, of Loughborough, yeoman 2
5596143 2533710 2533710 defendant Wheytley John husbandman 587809 587809 Wheytley, John, of Loughborough, husbandman 0
5613143 2547891 2547891 defendant Haytleye Thomas   587809 587809 Haytleye, Thomas, of Loughborough 0

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