names

53 rows where place_id = 593672

✎ 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
3612881 1871677 1871677 defendant Skrymshawe William yeoman 593672 593672 Skrymshawe, William, of Rolleston, yeoman 0
3612882 1871677 1871677 defendant Carter William laborer 593672 593672 Carter, William, of Rolleston,laborer 1
3612884 1871677 1871677 defendant Sharp Richard laborer 593672 593672 Sharp, Richard, of Rolleston, laborer 3
3821176 1964515 1964515 defendant Townsend Ralph husbandman 593672 593672 Townsend, Ralph, of Rolleston, husbandman 0
3913179 1994741 1994741 defendant Bull Thomas laborer 593672 593672 Bull, Thomas, of Rolleston, laborer 5
3913180 1994741 1994741 defendant Knyvesmyth William husbandman 593672 593672 Knyvesmyth, William, of Rolleston, husbandman 6
3926230 1999096 1999096 defendant Cortell Thomas yeoman 593672 593672 Cortell, Thomas, of Rolleston, yeoman 0
3959481 2010407 2010407 plaintiff Skillinge William esq 593672 593672 Skillinge, William, of Rolleston, esq 0
4020065 2031904 2031904 defendant Merynge James (legal representative) 593672 593672 Merynge, James, of Rolleston, gent, executors of 0
4309348 2133427 2133427 defendant Sheppard John husbandman 593672 593672 Sheppard, John, of Rolleston, husbandman 0
4321668 2137667 2137667 defendant Tynker Thomas yeoman 593672 593672 Tynker, Thomas, of Rolleston, yeoman 0
4323489 2138276 2138276 defendant Graunger John yeoman 593672 593672 Graunger, John, of Rolleston, or of Stokeley Park, yeoman 0
4466168 2190082 2190082 defendant Smyth John   593672 593672 Smyth, John, of Rolleston 0
4466616 2190237 2190237 plaintiff Anot William   593672 593672 Anot, William, of Rolleston 0
4503492 2201662 2201662 defendant Esthorp William   593672 593672 Esthorp, William, of Rolleston 0
4528217 2209099 2209099 defendant Pykeryng William   593672 593672 Pykeryng, William, of Rolleston 0
4531606 2210153 2210153 defendant Pymond William   593672 593672 Pymond, William, of Rolleston 0
4531621 2210154 2210154 defendant Pymond William   593672 593672 Pymond, William, of Rolleston 2
4534059 2210921 2210921 defendant Merston Thomas   593672 593672 Merston, Thomas, of Rolleston 2
4561744 2219608 2219608 defendant Pymond William   593672 593672 Pymond, William, of Rolleston 2
4584640 2226616 2226616 defendant Smyth Richard   593672 593672 Smyth, Richard, of Rolleston 1
4589113 2227972 2227972 defendant Sergeant Beatrice   593672 593672 Sergeant, Beatrice, of Rolleston, formerly wife of Richard 0
4593811 2229338 2229338 defendant Clerk John   593672 593672 Clerk, John, of Rolleston 0
4594979 2229686 2229686 plaintiff Pymond William (legal representative) 593672 593672 Pymond, William, of Rolleston, executors of 0
4633552 2241348 2241348 defendant Scaven John   593672 593672 Scaven, John, of Rolleston 0
4646076 2244926 2244926 defendant Clerk William   593672 593672 Clerk, William, of Rolleston 0
4818174 2301760 2301760 defendant Barley Philip de gent 593672 593672 Barley, Philip de, of Rolleston, gent 0
4846165 2310306 2310306 defendant Meke Robert husbandman 593672 593672 Meke, Robert, of Rolleston, husbandman 1
4846166 2310306 2310306 defendant Lane Edmund in the husbandman 593672 593672 Lane, Edmund in the, of Rolleston, husbandman 2
4846167 2310306 2310306 defendant Bate Richard husbandman 593672 593672 Bate, Richard, of Rolleston, husbandman 3
4846168 2310306 2310306 defendant Steventon Richard husbandman 593672 593672 Steventon, Richard, of Rolleston, husbandman 4
4846169 2310306 2310306 defendant Marsshall John smith 593672 593672 Marsshall, John, of Rolleston, smith 5
4846170 2310306 2310306 defendant Page William husbandman 593672 593672 Page, William, of Rolleston, husbandman 6
4866009 2316338 2316338 defendant in the Lone Roger husbandman 593672 593672 in the Lone, Roger, of Rolleston, husbandman 0
4866010 2316338 2316338 defendant Wythed Walter shoemaker 593672 593672 Wythed, Walter, of Rolleston, shoemaker 1
4866011 2316338 2316338 defendant Cortell Robert husbandman 593672 593672 Cortell, Robert, of Rolleston, husbandman 2
4866012 2316338 2316338 defendant Laurence John husbandman 593672 593672 Laurence, John, of Rolleston, husbandman 3
4873157 2318555 2318555 defendant Brokke William husbandman 593672 593672 Brokke, William, of Rolleston, husbandman 2
4917434 2331967 2331967 defendant att Boure John husbandman 593672 593672 att Boure, John, of Rolleston, husbandman 1
4921110 2333118 2333118 defendant Treweman William husbandman 593672 593672 Treweman, William, of Rolleston, husbandman 0
4944790 2340357 2340357 defendant Charles Richard husbandman 593672 593672 Charles, Richard, of Rolleston, husbandman 0
4959328 2344756 2344756 defendant Skydmore Thomas gent 593672 593672 Skydmore, Thomas, of Rolleston, gent 3
5033373 2366641 2366641 defendant Smyth Hugh smith 593672 593672 Smyth, Hugh, of Rolleston, smith 1
5037104 2367723 2367723 defendant Smyth Henry smith 593672 593672 Smyth, Henry, of Rolleston, smith 0
5043374 2369640 2369640 defendant Smyth Thomas husbandman 593672 593672 Smyth, Thomas, of Rolleston, husbandman 3
5247126 2429316 2429316 defendant Clerke Richard husbandman 593672 593672 Clerke, Richard, of Rolleston, husbandman 0
5336970 2456129 2456129 defendant Orchard Thomas yeoman 593672 593672 Orchard, Thomas, of Rolleston, yeoman 0
5357562 2462434 2462434 defendant Greyvys Christopher yeoman 593672 593672 Greyvys, Christopher, of Rolleston, yeoman 0
5357564 2462435 2462435 defendant Greyvys Christopher yeoman 593672 593672 Greyvys, Christopher, of Rolleston, yeoman 0
5441384 2487342 2487342 defendant Leevete Roger yeoman 593672 593672 Leevete, Roger, of Rolleston, yeoman 1
5460088 2492948 2492948 defendant Lewete Roger yeoman 593672 593672 Lewete, Roger, of Rolleston, yeoman 0
5471735 2496496 2496496 defendant Lewete Roger yeoman 593672 593672 Lewete, Roger, of Rolleston, yeoman 0
5528765 2513517 2513517 defendant Knyfesmyth John husbandman 593672 593672 Knyfesmyth, John, of Rolleston, husbandman 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);