names

45 rows where place_id = 586877

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, surname, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3589873 1864473 1864473 defendant Blakke Robert yeoman 586877 586877 Blakke, Robert, of Ranworth, yeoman 0
3635254 1905815 1905815 defendant Sekker William clerk 586877 586877 Sekker William, of Ranworth, clerk 1
3678583 1919359 1919359 defendant Mounforth William husbandman 586877 586877 Mounforth, William, of Ranworth, husbandman 2
3711833 1930016 1930016 defendant Crabbe John husbandman 586877 586877 Crabbe, John, of Ranworth, husbandman 0
3750114 1941949 1941949 defendant Goddyng Thomas yeoman 586877 586877 Goddyng, Thomas, of Ranworth, yeoman 0
3762793 1946000 1946000 defendant Goddyng Thomas yeoman 586877 586877 Goddyng, Thomas, of Ranworth, yeoman 2
3765430 1946851 1946851 defendant Goddyng Thomas husbandman 586877 586877 Goddyng, Thomas, of Ranworth, husbandman 0
3815022 1962619 1962619 defendant Goddyng Thomas yeoman 586877 586877 Goddyng, Thomas, of Ranworth, yeoman 0
3820791 1964393 1964393 defendant Moundeford Robert husbandman 586877 586877 Moundeford, Robert, of Ranworth, husbandman 2
3828581 1966816 1966816 defendant Goddyng Thomas yeoman 586877 586877 Goddyng, Thomas, of Ranworth, yeoman 0
3835513 1969047 1969047 defendant Goddyng Thomas yeoman 586877 586877 Goddyng, Thomas, of Ranworth, yeoman 1
3892921 1987880 1987880 defendant Goddyng Thomas yeoman 586877 586877 Goddyng, Thomas, of Ranworth, yeoman 0
3921029 1997382 1997382 defendant Smyth William   586877 586877 Smyth, William, of Ranworth, worsted weaver 0
3921040 1997386 1997386 defendant Goddyng Thomas yeoman 586877 586877 Goddyng, Thomas, of Ranworth, yeoman 0
3952529 2007952 2007952 defendant Toby Peter husbandman 586877 586877 Toby, Peter, of Ranworth, husbandman 0
3953503 2008296 2008296 defendant Mountforth John yeoman 586877 586877 Mountforth, John, of Ranworth, yeoman 1
4003059 2025859 2025859 plaintiff Holdych Robert gent 586877 586877 Holdych, Robert, of Ranworth, gent 0
4003062 2025860 2025860 plaintiff Holdyche Robert gent 586877 586877 Holdyche, Robert, of Ranworth, gent 0
4138205 2074033 2074033 defendant Churche John husbandman 586877 586877 Churche, John, of Ranworth, husbandman 0
4252274 2113753 2113753 defendant Bales John husbandman 586877 586877 Bales, John, of Ranworth, husbandman 1
4330070 2140357 2140357 defendant Stamford Edward husbandman 586877 586877 Stamford, Edward, of Ranworth, husbandman 2
4330071 2140357 2140357 defendant Goodwyn Miles husbandman 586877 586877 Goodwyn, Miles, of Ranworth, husbandman 3
4333213 2141395 2141395 defendant Chryspe or Crispe Nicholas yeoman 586877 586877 Chryspe or Crispe, Nicholas, of Ranworth, yeoman 0
4678708 2258947 2258947 defendant Wryghte John husbandman 586877 586877 Wryghte, John, of Ranworth, husbandman 0
4736040 2276412 2276412 defendant Clerk Robert yeoman 586877 586877 Clerk, Robert, of Ranworth, yeoman 0
4757656 2282770 2282770 defendant Clerk Robert mercer 586877 586877 Clerk, Robert, of Ranworth, mercer 0
4900852 2326898 2326898 defendant Palmere Robert husbandman 586877 586877 Palmere, Robert, of Ranworth, husbandman 1
4962208 2345600 2345600 defendant Gryggys John yeoman 586877 586877 Gryggys, John, of Ranworth, yeoman 1
5112951 2390182 2390182 defendant Gryggys John yeoman 586877 586877 Gryggys, John, of Ranworth,yeoman 0
5233024 2425240 2425240 defendant Grygges John yeoman 586877 586877 Grygges, John, of Ranworth, yeoman 0
5240012 2427278 2427278 defendant Grigges John yeoman 586877 586877 Grigges, John, of Ranworth, yeoman 3
5241096 2427596 2427596 defendant Rudlond Thomas clerk 586877 586877 Rudlond, Thomas, of Ranworth, clerk 0
5245487 2428835 2428835 defendant Gryme John husbandman 586877 586877 Gryme, John, of Ranworth, husbandman 3
5257757 2432546 2432546 defendant Halyday Nicholas husbandman 586877 586877 Halyday, Nicholas, of Ranworth, husbandman 0
5260033 2433259 2433259 defendant Grigges John yeoman 586877 586877 Grigges, John, of Ranworth, yeoman 2
5268785 2435985 2435985 defendant Galt William husbandman 586877 586877 Galt, William, of Ranworth, husbandman 10
5274625 2437658 2437658 defendant Ailmer Thomas yeoman 586877 586877 Ailmer, Thomas, of Ranworth, yeoman 2
5374730 2467694 2467694 defendant Grygges Thomas yeoman 586877 586877 Grygges, Thomas, of Ranworth, yeoman 0
5448432 2489427 2489427 defendant Multon Robert husbandman 586877 586877 Multon, Robert, of Ranworth, husbandman 2
5460740 2493158 2493158 defendant Multon Roger husbandman 586877 586877 Multon, Roger, of Ranworth, husbandman 2
5460763 2493165 2493165 defendant Multon Roger husbandman 586877 586877 Multon, Roger, of Ranworth, husbandman 2
5472337 2496693 2496693 defendant Multon Roger husbandman 586877 586877 Multon, Roger, of Ranworth, husbandman 1
5472344 2496694 2496694 defendant Multon Roger husbandman 586877 586877 Multon, Roger, of Ranworth, husbandman 2
5483787 2500096 2500096 defendant Multon Roger husbandman 586877 586877 Multon, Roger, of Ranworth, husbandman 2
5514869 2509495 2509495 defendant Grygges Thomas husbandman 586877 586877 Grygges, Thomas, of Ranworth, husbandman 1

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