names

54 rows where place_id = 602137

✎ 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
3648604 1909952 1909952 defendant Lesyngham Edmund husbandman 602137 602137 Lesyngham, Edmund, of Ingworth, husbandman 3
3828878 1966911 1966911 defendant Furnes Robert clerk 602137 602137 Furnes, Robert, of Ingworth, clerk 0
3952939 2008098 2008098 plaintiff Howmans John   602137 602137 Howmans, John, of Ingworth, administrators of 0
4000132 2024814 2024814 defendant Rycheman Robert yeoman 602137 602137 Rycheman, Robert, of Ingworth, yeoman 0
4015036 2030074 2030074 defendant Wyllesey Richard (legal representative) 602137 602137 Wyllesey, Richard, of Ingworth, husbandman, administratrix of 12
4015037 2030074 2030074 defendant Wyllesey Alice widow 602137 602137 Wyllesey, Alice, of Ingworth, widow 13
4018440 2031328 2031328 defendant Collyns William husbandman 602137 602137 Collyns, William, of Ingworth, husbandman 0
4023796 2033215 2033215 defendant Collens William yeoman 602137 602137 Collens, William, of Ingworth, yeoman 0
4023829 2033229 2033229 defendant Collens William yeoman 602137 602137 Collens, William, of Ingworth, yeoman 0
4058955 2045597 2045597 defendant Collyns William yeoman 602137 602137 Collyns, William, of Ingworth, yeoman 0
4111770 2064459 2064459 defendant Pye William husbandman 602137 602137 Pye, William, of Ingworth, husbandman 3
4150781 2078410 2078410 defendant Collyns William husbandman 602137 602137 Collyns, William, of Ingworth, husbandman 0
4150782 2078410 2078410 defendant Andrewes John   602137 602137 Andrewes, John, of Ingworth, mason 1
4150783 2078410 2078410 defendant Burton John tailor 602137 602137 Burton, John, of Ingworth, tailor 2
4174879 2086680 2086680 defendant Collyns William yeoman 602137 602137 Collyns, William, of Ingworth, yeoman 3
4182551 2089375 2089375 defendant Collyns William yeoman 602137 602137 Collyns, William, of Ingworth, yeoman 3
4449284 2184723 2184723 defendant Clerk John   602137 602137 Clerk, John, of Ingworth 0
4533757 2210824 2210824 defendant Clerk John   602137 602137 Clerk, John, of Ingworth 4
4572473 2222930 2222930 defendant Wattys Thomas   602137 602137 Wattys, Thomas, of Ingworth 4
4572762 2223019 2223019 plaintiff atte Wodehous John   602137 602137 atte Wodehous, John, of Ingworth, his son 1
4572763 2223019 2223019 defendant Clerk John   602137 602137 Clerk, John, of Ingworth 0
4572765 2223019 2223019 defendant Kydman William   602137 602137 Kydman, William, of Ingworth 2
4685480 2261053 2261053 defendant Stannard Henry husbandman 602137 602137 Stannard, Henry, of Ingworth, husbandman 3
4717505 2270811 2270811 defendant Danby Thomas   602137 602137 Danby, Thomas, of Ingworth, formerly parson 0
4717506 2270811 2270811 defendant Wodhous John yeoman 602137 602137 Wodhous, John, of Ingworth, yeoman 1
4758466 2283026 2283026 defendant Turnour Henry yeoman 602137 602137 Turnour, Henry, of Ingworth, yeoman 1
4851938 2312041 2312041 defendant Wodhous John yeoman 602137 602137 Wodhous, John, of Ingworth, yeoman 1
4857060 2313589 2313589 defendant Saneer or Saveer John glover 602137 602137 Saneer or Saveer, John, of Ingworth, glover 1
4864183 2315775 2315775 defendant Clerk John husbandman 602137 602137 Clerk, John, of Ingworth, husbandman 0
4957590 2344243 2344243 defendant Grene John yeoman 602137 602137 Grene, John, of Ingworth, yeoman 3
4993924 2355053 2355053 defendant Goneld Richard clerk 602137 602137 Goneld, Richard, of Ingworth, clerk 0
5007418 2359064 2359064 defendant Custaunce Richard   602137 602137 Custaunce, Richard, of Ingworth, glove maker 0
5059912 2374529 2374529 defendant Custaunce Richard husbandman 602137 602137 Custaunce, Richard, of Ingworth, husbandman 4
5069370 2377332 2377332 defendant Westdale John carpenter 602137 602137 Westdale, John, of Ingworth, carpenter 0
5077219 2379691 2379691 plaintiff Bettes William   602137 602137 Bettes, William, of Ingworth 0
5247507 2429424 2429424 defendant Custaunce Richard glover 602137 602137 Custaunce, Richard, of Ingworth, glover 0
5251535 2430584 2430584 defendant Custauns Richard glover 602137 602137 Custauns, Richard, of Ingworth, glover 3
5328716 2453668 2453668 defendant Barker Robert clerk 602137 602137 Barker, Robert, of Ingworth, clerk 0
5359154 2462900 2462900 defendant Smyth John thatcher 602137 602137 Smyth, John, of Ingworth, thatcher 1
5362698 2463982 2463982 defendant Smyth John thatcher 602137 602137 Smyth, John, of Ingworth, thatcher 0
5372015 2466839 2466839 defendant Dobbys Thomas laborer 602137 602137 Dobbys, Thomas, of Ingworth, laborer 3
5375398 2467893 2467893 defendant Smyth John thatcher 602137 602137 Smyth, John, of Ingworth, thatcher 2
5415131 2479466 2479466 defendant Dobbes Thomas laborer 602137 602137 Dobbes, Thomas, of Ingworth, laborer 0
5421113 2481243 2481243 defendant Barker Robert clerk 602137 602137 Barker, Robert, of Ingworth, clerk 2
5431253 2484293 2484293 defendant Dobbes Thomas laborer 602137 602137 Dobbes, Thomas, of Ingworth, laborer 0
5447763 2489209 2489209 defendant Dobbes Thomas laborer 602137 602137 Dobbes, Thomas, of Ingworth, laborer 0
5474177 2497249 2497249 defendant Smyth John thatcher 602137 602137 Smyth, John, of Ingworth, thatcher 4
5476431 2497954 2497954 defendant Smith John thatcher 602137 602137 Smith, John, of Ingworth, thatcher 0
5483195 2499914 2499914 defendant Dobbes Thomas laborer 602137 602137 Dobbes, Thomas, of Ingworth, laborer 2
5485613 2500601 2500601 defendant Smyth John thatcher 602137 602137 Smyth, John, of Ingworth, thatcher 1
5487957 2501286 2501286 defendant Smyth John thatcher 602137 602137 Smyth, John, of Ingworth, thatcher 0
5532094 2514582 2514582 defendant Dobbys Thomas husbandman 602137 602137 Dobbys, Thomas, of Ingworth, husbandman 0
5605197 2536501 2536501 defendant Collens Richard husbandman 602137 602137 Collens, Richard, of Ingworth, husbandman 0
5610128 2546876 2546876 plaintiff atte Heithe Ralph   602137 602137 atte Heithe, Ralph, of Ingworth, parson 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);