names

73 rows where place_id = 598029

✎ 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
3630805 1904457 1904457 defendant Byllyngay Gilbert husbandman 598029 598029 Byllyngay, Gilbert, of Caxton, husbandman 0
3679290 1919583 1919583 defendant Lavender William husbandman 598029 598029 Lavender, William, of Caxton, husbandman 0
3679291 1919583 1919583 defendant Cretyng John innholder 598029 598029 Cretyng, John, of Caxton, innholder 1
3756886 1944129 1944129 defendant Cretyng John husbandman 598029 598029 Cretyng, John, of Caxton, husbandman 0
3756887 1944129 1944129 defendant Cowlege Thomas husbandman 598029 598029 Cowlege, Thomas, of Caxton, husbandman 1
3756888 1944129 1944129 defendant Lavender William husbandman 598029 598029 Lavender, William, of Caxton, husbandman 2
3756889 1944129 1944129 defendant Lavender Thomas husbandman 598029 598029 Lavender, Thomas, of Caxton, husbandman 3
3766169 1947072 1947072 defendant Lavander William husbandman 598029 598029 Lavander, William, of Caxton, husbandman 0
3773410 1949394 1949394 defendant Lavender William husbandman 598029 598029 Lavender, William, of Caxton, husbandman 0
3780316 1951575 1951575 defendant Samy Robert husbandman 598029 598029 Samy, Robert, of Caxton, husbandman 2
3782592 1952297 1952297 defendant Scowchye Edmund laborer 598029 598029 Scowchye, Edmund, of Caxton, laborer 0
3782593 1952297 1952297 defendant Slowe William laborer 598029 598029 Slowe, William, of Caxton, laborer 1
3782594 1952297 1952297 defendant Byllyng Gilbert husbandman 598029 598029 Byllyng, Gilbert, of Caxton, husbandman 2
3784111 1952812 1952812 defendant Lavender William husbandman 598029 598029 Lavender, William, of Caxton, husbandman 0
3813775 1962222 1962222 defendant Lavender William innholder 598029 598029 Lavender, William, of Caxton, innholder 0
3813776 1962222 1962222 defendant Samye Robert laborer 598029 598029 Samye, Robert, of Caxton, laborer 1
3816209 1962978 1962978 defendant Lavender John husbandman 598029 598029 Lavender, John, of Caxton, husbandman 0
3816210 1962978 1962978 defendant Lavender William husbandman 598029 598029 Lavender, William, of Caxton, husbandman 1
3844827 1971925 1971925 defendant Sawe Thomas butcher 598029 598029 Sawe, Thomas, of Caxton, butcher 0
3944977 2005338 2005338 defendant Clopton Edward gent 598029 598029 Clopton, Edward, of Caxton, gent 0
4225329 2104326 2104326 defendant Anger William yeoman 598029 598029 Anger, William, of Caxton, yeoman 0
4225330 2104326 2104326 defendant Lavender Thomas tailor 598029 598029 Lavender, Thomas, of Caxton, tailor 1
4225331 2104326 2104326 defendant Anger John husbandman 598029 598029 Anger, John, of Caxton, husbandman 2
4269005 2119228 2119228 defendant Harte Andrew husbandman 598029 598029 Harte, Andrew, of Caxton, husbandman 0
4269418 2119363 2119363 defendant Anger William husbandman 598029 598029 Anger, William, of Caxton, husbandman 0
4433732 2175315 2175315 defendant Dane William de   598029 598029 Dane, William de, of Caxton, parson 0
4470792 2191517 2191517 plaintiff Burgeyn Simon   598029 598029 Burgeyn, Simon, of Caxton 0
4507053 2202675 2202675 defendant Limsey John de smith 598029 598029 Limsey, John de, of Caxton, smith 0
4657598 2248266 2248266 defendant Lorde John husbandman 598029 598029 Lorde, John, of Caxton, husbandman 0
4754382 2281752 2281752 defendant Person John husbandman 598029 598029 Person, John, of Caxton, husbandman 0
4754384 2281753 2281753 defendant Slach William husbandman 598029 598029 Slach, William, of Caxton, husbandman 0
4760537 2283647 2283647 defendant Burgyn William husbandman 598029 598029 Burgyn, William, of Caxton, husbandman 0
4760538 2283647 2283647 defendant Selley John husbandman 598029 598029 Selley, John, of Caxton, husbandman 1
4760539 2283647 2283647 defendant Tredelof John husbandman 598029 598029 Tredelof, John, of Caxton, husbandman 2
4768912 2286257 2286257 defendant Grygge John tailor 598029 598029 Grygge, John, of Caxton, tailor 1
4775400 2288303 2288303 defendant Alyneth John husbandman 598029 598029 Alyneth, John, of Caxton, husbandman 0
4775402 2288304 2288304 defendant Person John husbandman 598029 598029 Person, John, of Caxton, husbandman 0
4775404 2288305 2288305 defendant Slache William husbandman 598029 598029 Slache, William, of Caxton, husbandman 0
4785272 2291412 2291412 defendant Person John husbandman 598029 598029 Person, John, of Caxton, husbandman 1
4805831 2298032 2298032 defendant Person John husbandman 598029 598029 Person, John, of Caxton, husbandman 0
4805832 2298032 2298032 defendant Dunton Thomas husbandman 598029 598029 Dunton, Thomas, of Caxton, husbandman 1
4805841 2298035 2298035 defendant Person John husbandman 598029 598029 Person, John, of Caxton, husbandman 0
4805842 2298035 2298035 defendant Dunton Thomas husbandman 598029 598029 Dunton, Thomas, of Caxton, husbandman 1
4833562 2306503 2306503 defendant Persons John husbandman 598029 598029 Persons, John, of Caxton, husbandman 1
4845804 2310199 2310199 plaintiff Person John   598029 598029 Person, John, of Caxton 0
4858844 2314143 2314143 defendant Slach William husbandman 598029 598029 Slach, William, of Caxton, husbandman 2
4858853 2314146 2314146 defendant Lewe John laborer 598029 598029 Lewe, John, of Caxton, laborer 0
4858855 2314147 2314147 defendant Lewe John laborer 598029 598029 Lewe, John, of Caxton, laborer 0
4870020 2317588 2317588 defendant Esterle Hugh fisher 598029 598029 Esterle, Hugh, of Caxton, fisher 2
4886345 2322588 2322588 defendant Slache Simon husbandman 598029 598029 Slache, Simon, of Caxton, husbandman 0
4888853 2323302 2323302 defendant Person John husbandman 598029 598029 Person, John, of Caxton, husbandman 2
4911990 2330256 2330256 defendant Person John husbandman 598029 598029 Person, John, of Caxton, husbandman 0
4911991 2330256 2330256 defendant Sleche Simon husbandman 598029 598029 Sleche, Simon, of Caxton, husbandman 1
4937475 2338095 2338095 defendant Person John yeoman 598029 598029 Person, John, of Caxton, yeoman 0
4944724 2340337 2340337 defendant Slache Simon butcher 598029 598029 Slache, Simon, of Caxton, butcher 0
4957045 2344060 2344060 defendant Burgayn Thomas husbandman 598029 598029 Burgayn, Thomas, of Caxton, husbandman 1
4957046 2344060 2344060 defendant Estwyk John, senior husbandman 598029 598029 Estwyk, John, senior, of Caxton, husbandman 2
4958364 2344468 2344468 defendant Slathe Simon butcher 598029 598029 Slathe, Simon, of Caxton, butcher 2
4968003 2347374 2347374 defendant Persons John husbandman 598029 598029 Persons, John, of Caxton, husbandman 0
5062423 2375328 2375328 defendant Papworth John husbandman 598029 598029 Papworth, John, of Caxton, husbandman 1
5107229 2388542 2388542 defendant Hopper James maltman 598029 598029 Hopper, James, of Caxton, maltman 1
5107230 2388542 2388542 defendant Sellys John butcher 598029 598029 Sellys, John, of Caxton, butcher 2
5111119 2389638 2389638 defendant Sylake Robert husbandman 598029 598029 Sylake, Robert, of Caxton, husbandman 0
5167294 2406165 2406165 defendant Paynet Henry yeoman 598029 598029 Paynet, Henry, of Caxton, yeoman 1
5205773 2417427 2417427 defendant Sylagge Robert husbandman 598029 598029 Sylagge, Robert, of Caxton, husbandman 1
5252208 2430804 2430804 defendant Paynet Henry yeoman 598029 598029 Paynet, Henry, of Caxton, yeoman 0
5293088 2442962 2442962 defendant Estwyk John husbandman 598029 598029 Estwyk, John, of Caxton, husbandman 1
5414097 2479152 2479152 defendant Burgeyn William husbandman 598029 598029 Burgeyn, William, of Caxton, husbandman 2
5517764 2510398 2510398 defendant Estwyk John husbandman 598029 598029 Estwyk, John, of Caxton, husbandman 1
5537141 2516100 2516100 defendant Boterell John husbandman 598029 598029 Boterell, John, of Caxton, husbandman 0
5537142 2516100 2516100 defendant Gylmyn John husbandman 598029 598029 Gylmyn, John, of Caxton, husbandman 1
5537143 2516100 2516100 defendant Estwyk William husbandman 598029 598029 Estwyk, William, of Caxton, husbandman 2
5630822 2553647 2553647 defendant Emond John husbandman 598029 598029 Emond, John, of Caxton, 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);