names

79 rows where place_id = 591756

✎ 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
3605489 1869382 1869382 defendant Edon William chaplain 591756 591756 Edon, William, of Dunston, chaplain 1
3619269 1873629 1873629 defendant Uttyng John husbandman 591756 591756 Uttyng, John, of Dunston, husbandman 3
3653030 1911277 1911277 defendant Applyard Thomas gent 591756 591756 Applyard, Thomas, of Dunston, gent 0
3671797 1917172 1917172 defendant Vaux Robert   591756 591756 Vaux, Robert, of Dunston 0
3801294 1958330 1958330 defendant Beyreley William husbandman 591756 591756 Beyreley, William, of Dunston, husbandman 0
3818763 1963774 1963774 defendant Beyreley William husbandman 591756 591756 Beyreley, William, of Dunston, husbandman 0
3851998 1974214 1974214 plaintiff Poynton John husbandman 591756 591756 Poynton, John, of Dunston, husbandman 0
3852000 1974215 1974215 plaintiff Poynton John husbandman 591756 591756 Poynton, John, of Dunston, husbandman 0
3861780 1977406 1977406 defendant Flowrdewe William husbandman 591756 591756 (Flowrdewe, William, of Dunston, husbandman 1
3889403 1986688 1986688 defendant Feldesend Thurstan laborer 591756 591756 Feldesend, Thurstan, of Dunston, laborer 0
3889405 1986688 1986688 defendant Laughton John husbandman 591756 591756 Laughton, John, of Dunston, husbandman 2
3889408 1986689 1986689 defendant Clerke Robert husbandman 591756 591756 Clerke, Robert, of Dunston, husbandman 1
3889409 1986689 1986689 defendant Palester John husbandman 591756 591756 Palester, John, of Dunston, husbandman 2
3923147 1998048 1998048 defendant Flowerdewe John husbandman 591756 591756 Flowerdewe, John, of Dunston, husbandman 1
3925932 1998987 1998987 defendant Wynter Thomas husbandman 591756 591756 Wynter, Thomas, of Dunston, husbandman 1
3963689 2011909 2011909 defendant Grymbald James husbandman 591756 591756 Grymbald, James, of Dunston, husbandman 0
4021747 2032503 2032503 defendant Spokes John husbandman 591756 591756 Spokes, John, of Dunston, husbandman 1
4059735 2045875 2045875 defendant Barker Gregory husbandman 591756 591756 Barker, Gregory, of Dunston, husbandman 2
4095819 2058838 2058838 defendant Barker Gregory husbandman 591756 591756 Barker, Gregory, of Dunston, husbandman 2
4095823 2058839 2058839 defendant Barker George husbandman 591756 591756 Barker, George, of Dunston, husbandman 2
4150650 2078365 2078365 defendant Foxe Lawrence yeoman 591756 591756 Foxe, Lawrence, of Dunston, yeoman 0
4150653 2078366 2078366 defendant Foxe Lawrence yeoman 591756 591756 Foxe, Lawrence, of Dunston, yeoman 1
4175196 2086785 2086785 defendant Over John merchant 591756 591756 Over, John, of Dunston, merchant 0
4184046 2089916 2089916 defendant Cooper Thomas fishmonger 591756 591756 Cooper, Thomas, of Dunston, or of Lincoln, fishmonger 0
4269122 2119266 2119266 defendant Bevis Nicholas husbandman 591756 591756 Bevis, Nicholas, of Dunston, husbandman 0
4327783 2139616 2139616 defendant Pooler Thomas husbandman 591756 591756 Pooler, Thomas, of Dunston, husbandman 2
4447209 2184034 2184034 defendant Rece Richard   591756 591756 Rece, Richard, of Dunston 0
4512697 2204403 2204403 defendant Hand Thomas   591756 591756 Hand, Thomas, of Dunston 2
4572400 2222907 2222907 defendant Bythebroke John   591756 591756 Bythebroke, John, of Dunston 0
4645358 2244714 2244714 defendant Joweler John miller 591756 591756 Joweler, John, of Dunston, miller 2
4675554 2257964 2257964 defendant Clerk William husbandman 591756 591756 Clerk, William, of Dunston, husbandman 0
4694863 2263883 2263883 defendant Bankewell Roger   591756 591756 Bankewell, Roger, of Dunston 0
4702202 2266097 2266097 defendant Crispyng John   591756 591756 Crispyng, John, of Dunston 0
4706830 2267515 2267515 defendant Clerk William husbandman 591756 591756 Clerk, William, of Dunston, husbandman 2
4714264 2269791 2269791 defendant Wilkynson Thomas yeoman 591756 591756 Wilkynson, Thomas, of Dunston, yeoman 0
4727671 2273896 2273896 defendant Duraunt Richard husbandman 591756 591756 Duraunt, Richard, of Dunston, husbandman 0
4743283 2278562 2278562 defendant Wigley John husbandman 591756 591756 Wigley, John, of Dunston, husbandman 0
4743287 2278562 2278562 defendant Parker William husbandman 591756 591756 Parker, William, of Dunston, husbandman 4
4743288 2278562 2278562 defendant Newbald Robert husbandman 591756 591756 Newbald, Robert, of Dunston, husbandman 5
4829242 2305186 2305186 defendant Crayle John husbandman 591756 591756 Crayle, John, of Dunston, husbandman 0
4924532 2334112 2334112 defendant Miller Richard miller 591756 591756 Miller, Richard, of Dunston, miller 0
4938154 2338311 2338311 defendant Warde Thomas gent 591756 591756 Warde, Thomas, of Dunston, gent 0
4953032 2342873 2342873 defendant Wilky John hooper 591756 591756 Wilky, John, of Dunston, hooper 0
4953033 2342873 2342873 defendant Nythecote David tucker 591756 591756 Nythecote, David, of Dunston, tucker 1
4961377 2345370 2345370 defendant Warde Thomas gent 591756 591756 Warde, Thomas, of Dunston, gent 0
4966114 2346794 2346794 defendant atte Yate John clerk 591756 591756 atte Yate, John, of Dunston, clerk 1
4978382 2350481 2350481 defendant Foterell William husbandman 591756 591756 Foterell, William, of Dunston, husbandman 2
4987830 2353325 2353325 defendant Eton Katherine widow 591756 591756 Eton, Katherine, of Dunston, widow 0
5048439 2371170 2371170 defendant Weryng Mathew husbandman 591756 591756 Weryng, Mathew, of Dunston, husbandman 1
5048440 2371170 2371170 defendant Foterell William husbandman 591756 591756 Foterell, William, of Dunston, husbandman 2
5048443 2371171 2371171 defendant Weryng Mathew husbandman 591756 591756 Weryng, Mathew, of Dunston, husbandman 1
5048444 2371171 2371171 defendant Foterell William husbandman 591756 591756 Foterell, William, of Dunston, husbandman 2
5063018 2375471 2375471 defendant Dunston Richard yeoman 591756 591756 Dunston, Richard, of Dunston, yeoman 0
5073746 2378635 2378635 plaintiff Warde Thomas gent 591756 591756 Warde, Thomas, of Dunston, gent 0
5073747 2378635 2378635 defendant Wodsyde Henry yeoman 591756 591756 Wodsyde, Henry, of Dunston, yeoman 0
5098788 2386076 2386076 defendant Norman William   591756 591756 Norman, William, of Dunston, servant 0
5098792 2386078 2386078 defendant Wattys John   591756 591756 Wattys, John, of Dunston, servant 0
5117654 2391597 2391597 defendant Morgan Thomas laborer 591756 591756 Morgan, Thomas, of Dunston, laborer 4
5255690 2431897 2431897 defendant Foterell Walter, junior   591756 591756 Foterell, Walter, junior, of Dunston, groom 4
5313247 2448999 2448999 defendant Lyghtfote John gent 591756 591756 Lyghtfote, John, of Dunston, gent 0
5333967 2455231 2455231 defendant Eyre Robert husbandman 591756 591756 Eyre, Robert, of Dunston, husbandman 13
5340752 2457307 2457307 defendant Alounday William husbandman 591756 591756 Alounday, William, of Dunston, husbandman 0
5370682 2466420 2466420 defendant Flouredewe John husbandman 591756 591756 Flouredewe, John, of Dunston, husbandman 1
5372157 2466882 2466882 defendant Smyth John clerk 591756 591756 Smyth, John, of Dunston, clerk 0
5372160 2466882 2466882 defendant Skeldynghop Robert husbandman 591756 591756 Skeldynghop, Robert, of Dunston, husbandman 3
5384826 2470735 2470735 defendant Herdman William   591756 591756 Herdman, William, of Dunston, knight 0
5395757 2473869 2473869 defendant Lyghtfote John gent 591756 591756 Lyghtfote, John, of Dunston, gent 0
5395758 2473869 2473869 defendant Warde Thomas gent 591756 591756 Warde, Thomas, of Dunston, gent 1
5442068 2487549 2487549 defendant Knysesmith John yeoman 591756 591756 Knysesmith, John, of Dunston, yeoman 0
5481490 2499395 2499395 defendant Knyvesmyth John husbandman 591756 591756 Knyvesmyth, John, of Dunston, husbandman 2
5486675 2500913 2500913 defendant Yoo John husbandman 591756 591756 Yoo, John, of Dunston, husbandman 2
5515452 2509678 2509678 defendant Smyth William yeoman 591756 591756 Smyth, William, of Dunston, yeoman 0
5520502 2511233 2511233 defendant Uttyng John husbandman 591756 591756 Uttyng, John, of Dunston, husbandman 0
5523413 2512152 2512152 defendant Abbot Admund yeoman 591756 591756 Abbot, Admund, of Dunston, yeoman 1
5532690 2514772 2514772 defendant Brychemer John chaplain 591756 591756 Brychemer, John, of Dunston, chaplain 0
5551572 2520501 2520501 defendant Roger Thomas yeoman 591756 591756 Roger, Thomas, of Dunston, yeoman 0
5551573 2520501 2520501 defendant Bykham John yeoman 591756 591756 Bykham, John, of Dunston, yeoman 1
5566914 2524918 2524918 defendant Roger Thomas yeoman 591756 591756 Roger, Thomas, of Dunston, yeoman 0
5566915 2524918 2524918 defendant Bykham John yeoman 591756 591756 Bykham, John, of Dunston, yeoman 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);