names

53 rows where place_id = 609785

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3680292 1919912 1919912 defendant Marmyon John gent 609785 609785 Marmyon, John, of Wollaton, gent 0
3935615 2002227 2002227 defendant Draycott Alice widow 609785 609785 Draycott, Alice, of Wollaton, widow 0
3986825 2020030 2020030 plaintiff Willoughbye Henry (legal representative) 609785 609785 Willoughbye, Henry, of Wollaton, esq, executors of 0
3986829 2020031 2020031 plaintiff Willoughbye Henry (legal representative) 609785 609785 Willoughbye, Henry, of Wollaton, esq, executors of 0
4081722 2053765 2053765 defendant Leyke William yeoman 609785 609785 Leyke, William, of Wollaton, yeoman 1
4214171 2100473 2100473 defendant Hyll Richard yeoman 609785 609785 Hyll, Richard, of Wollaton, yeoman 0
4716491 2270478 2270478 plaintiff Willughby Hugh de   609785 609785 Willughby, Hugh de, of Wollaton 0
4716923 2270626 2270626 plaintiff Wylllughby Hugh esq 609785 609785 Wylllughby, Hugh, of Wollaton, esq 0
4739207 2277356 2277356 plaintiff Wyllughby Hugh esq 609785 609785 Wyllughby, Hugh, of Wollaton, esq 0
4746880 2279587 2279587 defendant Willughby Hugh esq 609785 609785 Willughby, Hugh, of Wollaton, esq 0
4775351 2288286 2288286 plaintiff Willughby (illegible)   609785 609785 Willughby, _, of Wollaton 0
4801759 2296732 2296732 plaintiff Wyllughby Hugh   609785 609785 Wyllughby, Hugh, of Wollaton 0
4853875 2312621 2312621 plaintiff Wyllughby Hugh   609785 609785 Wyllughby, Hugh, of Wollaton, knight alias esquire 0
4885892 2322458 2322458 plaintiff Wyllughby Hugh   609785 609785 Wyllughby, Hugh, of Wollaton, knight 0
4888550 2323219 2323219 plaintiff Wyllughby Hugh   609785 609785 Wyllughby, Hugh, of Wollaton, knight 0
4895074 2325124 2325124 defendant Fraunk William yeoman 609785 609785 Fraunk, William, of Wollaton, yeoman 1
4898713 2326249 2326249 plaintiff Wyllughby Hugh   609785 609785 Wyllughby, Hugh, of Wollaton, knight 0
4933065 2336733 2336733 plaintiff Wyllughby Hugh   609785 609785 Wyllughby, Hugh, of Wollaton, knight 0
4933066 2336733 2336733 defendant Wyllughby Hugh   609785 609785 Wyllughby, Hugh, of Wollaton, knight 0
4938974 2338582 2338582 defendant Wright William husbandman 609785 609785 Wright, William, of Wollaton, husbandman 1
4957890 2344332 2344332 plaintiff Willughby Hugh   609785 609785 Willughby, Hugh, of Wollaton, knight 0
4957894 2344333 2344333 plaintiff Willughby Hugh   609785 609785 Willughby, Hugh, of Wollaton, knight 0
4958403 2344481 2344481 plaintiff Wyllughby Hugh   609785 609785 Wyllughby, Hugh, of Wollaton, knight 0
4958405 2344482 2344482 plaintiff Wyllughby Hugh   609785 609785 Wyllughby, Hugh, of Wollaton, knight 0
4984426 2352274 2352274 defendant Hawardyne Richard laborer 609785 609785 Hawardyne, Richard, of Wollaton, laborer 1
4984428 2352275 2352275 defendant Perot John   609785 609785 Perot, John, of Wollaton, shepherd 0
4984429 2352276 2352276 plaintiff Willughby Hugh   609785 609785 Willughby, Hugh, of Wollaton, knight 0
4985005 2352447 2352447 plaintiff Wyllughby Hugh   609785 609785 Wyllughby, Hugh, of Wollaton, knight 0
4985009 2352448 2352448 plaintiff Wyllughby Hugh   609785 609785 Wyllughby, Hugh, of Wollaton, knight 0
4985011 2352449 2352449 plaintiff Wyllughby Hugh   609785 609785 Wyllughby, Hugh, of Wollaton, knight 0
5012112 2360393 2360393 plaintiff Wyllughby Hugh   609785 609785 Wyllughby, Hugh, of Wollaton, knight 0
5012115 2360394 2360394 plaintiff Wyllughby Hugh   609785 609785 Wyllughby, Hugh, of Wollaton, knight 0
5037494 2367836 2367836 defendant Franke William yeoman 609785 609785 Franke, William, of Wollaton, yeoman 1
5037497 2367837 2367837 plaintiff Willughby Hugh   609785 609785 Willughby, Hugh, of Wollaton, knight 0
5037498 2367837 2367837 defendant Franke William yeoman 609785 609785 Franke, William, of Wollaton, yeoman 0
5037501 2367838 2367838 plaintiff Willughby Hugh   609785 609785 Willughby, Hugh, of Wollaton, knight 0
5037963 2367986 2367986 plaintiff Wyllughby Hugh   609785 609785 Wyllughby, Hugh, of Wollaton, knight 0
5051602 2372100 2372100 plaintiff Willughby Hugh (legal representative) 609785 609785 Willughby, Hugh, of Wollaton, knight, executors of 0
5051611 2372101 2372101 plaintiff Willughby Hugh (legal representative) 609785 609785 Willughby, Hugh, of Wollaton, knight, executors of 0
5074440 2378860 2378860 plaintiff Willughby Hugh (legal representative) 609785 609785 Willughby, Hugh, of Wollaton, knight, executors of 0
5074448 2378861 2378861 plaintiff Willughby Hugh (legal representative) 609785 609785 Willughby, Hugh, of Wollaton, knight, executors of 0
5099685 2386348 2386348 plaintiff Willughby Hugh (legal representative) 609785 609785 Willughby, Hugh, of Wollaton, knight, executors of 0
5131258 2395630 2395630 defendant Smyth John yeoman 609785 609785 Smyth, John, of Wollaton, yeoman 1
5142411 2398905 2398905 plaintiff Willughby Richard esq 609785 609785 Willughby, Richard, of Wollaton, esq 0
5150771 2401369 2401369 defendant Smyth John yeoman 609785 609785 Smyth, John, of Wollaton, yeoman 1
5163705 2405121 2405121 plaintiff Willughby Richard esq 609785 609785 Willughby, Richard, of Wollaton, esq 0
5177228 2409035 2409035 plaintiff Willughby Richard esq 609785 609785 Willughby, Richard, of Wollaton, esq 0
5200137 2415796 2415796 plaintiff Willughby Richard esq 609785 609785 Willughby, Richard, of Wollaton, esq 0
5228873 2424052 2424052 plaintiff Willughby Richard esq 609785 609785 Willughby, Richard, of Wollaton, esq 0
5267175 2435495 2435495 plaintiff Willughby Hugh (legal representative) 609785 609785 Willughby, Hugh, of Wollaton, knight, executors of 0
5315170 2449592 2449592 plaintiff Clerke Richard gent 609785 609785 Clerke, Richard, of Wollaton, gent 0
5593134 2532837 2532837 defendant Langton Cuthbert gent 609785 609785 Langton, Cuthbert, of Wollaton, gent 1
5623358 2551238 2551238 plaintiff Wylughby Hugh de   609785 609785 (Wylughby, Hugh de, of Wollaton, parson 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);