names

79 rows where place_id = 599075

✎ 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
3635109 1905780 1905780 defendant Coppyng John clerk 599075 599075 Coppyng, John, of Burgate, clerk 0
3651540 1910839 1910839 defendant Waller John gent 599075 599075 Waller, John, of Burgate, gent 0
3651662 1910880 1910880 defendant Waller John gent 599075 599075 Waller, John, of Burgate, gent 0
3651664 1910880 1910880 defendant Underwoode John yeoman 599075 599075 Underwoode, John, of Burgate, yeoman 2
3652558 1911132 1911132 plaintiff Waller John gent 599075 599075 Waller, John, of Burgate, gent 0
3665964 1915288 1915288 defendant Underwode John yeoman 599075 599075 Underwode, John, of Burgate, yeoman 2
3674207 1917971 1917971 defendant Terry Robert husbandman 599075 599075 Terry, Robert, of Burgate, husbandman 0
3726936 1934691 1934691 defendant Coppyng John clerk 599075 599075 Coppyng, John, of Burgate, clerk 0
3742567 1939546 1939546 defendant Coppyng John clerk 599075 599075 Coppyng, John, of Burgate, clerk 0
3750098 1941945 1941945 plaintiff Kyrke Henry   599075 599075 Kyrke, Henry, of Burgate 0
3789027 1954380 1954380 defendant Warde William husbandman 599075 599075 Warde, William, of Burgate, husbandman 1
3824039 1965394 1965394 defendant Kyrke Henry husbandman 599075 599075 Kyrke, Henry, of Burgate, husbandman 1
3824040 1965394 1965394 defendant Kyrke Ralph husbandman 599075 599075 Kyrke, Ralph, of Burgate, husbandman 2
3832217 1967988 1967988 defendant Waller John gent 599075 599075 Waller, John, of Burgate, gent 0
3867485 1979359 1979359 defendant Coppyng John clerk 599075 599075 Coppyng, John, of Burgate, clerk 0
3874190 1981591 1981591 plaintiff Grome Thomas husbandman 599075 599075 Grome, Thomas, of Burgate, husbandman 1
3877731 1982793 1982793 defendant Denny George husbandman 599075 599075 Denny, George, of Burgate, husbandman 0
3900623 1990439 1990439 plaintiff Cappyng John clerk 599075 599075 Cappyng, John, of Burgate, clerk 0
3902033 1990909 1990909 plaintiff Denny George   599075 599075 Denny, George, of Burgate 0
3920824 1997310 1997310 defendant Denny George yeoman 599075 599075 Denny, George, of Burgate, yeoman 1
4241597 2110175 2110175 defendant Herne Edmund tailor 599075 599075 Herne, Edmund, of Burgate, tailor 1
4246072 2111666 2111666 defendant Yong John saddler 599075 599075 Yong, John, of Burgate, saddler 0
4247005 2111973 2111973 defendant Morris William yeoman 599075 599075 Morris, William, of Burgate, yeoman 2
4277822 2122169 2122169 defendant M-cyer Michael husbandman 599075 599075 M-cyer, Michael, of Burgate, husbandman 0
4306670 2132471 2132471 defendant Reade Robert yeoman 599075 599075 Reade, Robert, of Burgate, yeoman 0
4325711 2138976 2138976 defendant Reade Robert yeoman 599075 599075 Reade, Robert, of Burgate, yeoman 1
4329230 2140089 2140089 defendant Reade Robert yeoman 599075 599075 Reade, Robert, of Burgate, yeoman 0
4331422 2140807 2140807 defendant Reade Robert yeoman 599075 599075 Reade, Robert, of Burgate, yeoman 1
4331423 2140807 2140807 defendant Yeule Richard husbandman 599075 599075 Yeule, Richard, of Burgate, husbandman 2
4339868 2143716 2143716 defendant Morrys William yeoman 599075 599075 together with Morrys, William, of Burgate, yeoman 1
4343495 2145001 2145001 defendant Levye Gregory spooner 599075 599075 Levye, Gregory, of Burgate, spooner 0
4352600 2148146 2148146 defendant Morrys William yeoman 599075 599075 Morrys, William, of Burgate, yeoman 0
4352601 2148146 2148146 defendant Thurlee Thomas yeoman 599075 599075 Thurlee, Thomas, of Burgate, yeoman 1
4356438 2149481 2149481 defendant Reade Robert yeoman 599075 599075 Reade, Robert, of Burgate, yeoman 0
4384853 2159623 2159623 plaintiff Bayley Charles yeoman 599075 599075 Bayley, Charles, of Burgate, yeoman 0
4389531 2161125 2161125 defendant Morris William yeoman 599075 599075 Morris, William, of Burgate, yeoman 1
4400450 2164745 2164745 defendant Nuttall James husbandman 599075 599075 Nuttall, James, of Burgate, husbandman 3
4409383 2167734 2167734 defendant Reade Robert yeoman 599075 599075 Reade, Robert, of Burgate, yeoman 0
4417956 2170490 2170490 plaintiff Tendryngge Roger de   599075 599075 Tendryngge, Roger de, of Burgate, parson 0
4421788 2171693 2171693 defendant Cook Thomas le chaplain 599075 599075 Cook, Thomas le, of Burgate, chaplain 6
4436892 2176279 2176279 plaintiff Tendryng Richard   599075 599075 Tendryng, Richard, of Burgate, parson 0
4532139 2210317 2210317 defendant Neweman John   599075 599075 Neweman, John, of Burgate 0
4570395 2222315 2222315 plaintiff Chapman William   599075 599075 Chapman, William, of Burgate 2
4570400 2222316 2222316 plaintiff Chapman William   599075 599075 Chapman, William, of Burgate 2
4668217 2255771 2255771 defendant Cole William husbandman 599075 599075 Cole, William, of Burgate, husbandman 0
4724736 2273033 2273033 defendant Pope Thomas butcher 599075 599075 Pope, Thomas, of Burgate, butcher 0
4892153 2324288 2324288 defendant Pope John husbandman 599075 599075 Pope, John, of Burgate, husbandman 0
4911712 2330164 2330164 defendant Slathe Simon   599075 599075 Slathe, Simon, of Burgate, parson 0
4913513 2330722 2330722 defendant Bettes Thomas yeoman 599075 599075 Bettes, Thomas, of Burgate, yeoman 2
4914572 2331078 2331078 defendant Undirwod William yeoman 599075 599075 Undirwod, William, of Burgate, yeoman 1
4998881 2356549 2356549 defendant Stevenes John tailor 599075 599075 Stevenes, John, of Burgate, tailor 0
5006794 2358887 2358887 defendant Colman William yeoman 599075 599075 Colman, William, of Burgate, yeoman 0
5053371 2372611 2372611 defendant Coterell Richard yeoman 599075 599075 Coterell, Richard, of Burgate, yeoman 2
5055715 2373278 2373278 defendant Hose Thomas butcher 599075 599075 Hose, Thomas, of Burgate, butcher 2
5073856 2378670 2378670 plaintiff Waryn Richard   599075 599075 Waryn, Richard, of Burgate 0
5114888 2390768 2390768 defendant Hose Thomas   599075 599075 Hose, Thomas, of Burgate 0
5262257 2433943 2433943 defendant Martyn John   599075 599075 Martyn, John, of Burgate, gent, attorney 0
5262259 2433944 2433944 defendant Martyn John   599075 599075 Martyn, John, of Burgate, gent, attorney 0
5294128 2443255 2443255 defendant Terry William husbandman 599075 599075 Terry, William, of Burgate, husbandman 3
5313094 2448951 2448951 defendant Martyn John   599075 599075 Martyn, John, of Burgate, gent, attorney 0
5380142 2469370 2469370 defendant Pope Richard sawyer 599075 599075 Pope, Richard, of Burgate, sawyer 0
5390345 2472305 2472305 defendant Keell William chaplain 599075 599075 Keell, William, of Burgate, chaplain 1
5392561 2472942 2472942 defendant Pope Richard sawyer 599075 599075 Pope, Richard, of Burgate, sawyer 0
5403187 2475997 2475997 defendant Keell William chaplain 599075 599075 Keell, William, of Burgate, chaplain 1
5432958 2484825 2484825 defendant Beall William chaplain 599075 599075 Beall, William, of Burgate, chaplain 0
5496563 2503885 2503885 defendant Poope Richard sawyer 599075 599075 Poope, Richard, of Burgate, sawyer 2
5496572 2503888 2503888 defendant Fulcher William husbandman 599075 599075 (Fulcher, William, of Burgate, husbandman 1
5496576 2503889 2503889 defendant Fulcher William husbandman 599075 599075 Fulcher, William, of Burgate, husbandman 0
5502742 2505773 2505773 defendant Martyn John (legal representative) 599075 599075 Martyn, John, of Burgate, executor of 0
5511514 2508448 2508448 defendant Pope Richard sawyer 599075 599075 Pope, Richard, of Burgate, sawyer 1
5517549 2510329 2510329 defendant Terry Robert husbandman 599075 599075 Terry, Robert, of Burgate, husbandman 0
5564748 2524276 2524276 defendant Yppeswych Edmund gent 599075 599075 Yppeswych, Edmund, of Burgate, gent 0
5564749 2524276 2524276 defendant Underwode John, senior yeoman 599075 599075 Underwode, John, senior, of Burgate, yeoman 1
5564750 2524276 2524276 defendant Underwode John, junior yeoman 599075 599075 Underwode, John, junior, of Burgate, yeoman 2
5564754 2524277 2524277 defendant Terry Robert yeoman 599075 599075 Terry, Robert, of Burgate, yeoman 0
5568727 2525402 2525402 defendant Undyrwode John, senior yeoman 599075 599075 Undyrwode, John, senior, of Burgate, yeoman 0
5579619 2528709 2528709 defendant Undirwode John, junior yeoman 599075 599075 Undirwode, John, junior, of Burgate, yeoman 0
5579623 2528710 2528710 defendant Undirwode John, junior yeoman 599075 599075 Undirwode, John, junior, of Burgate, yeoman 0
5609425 2537846 2537846 defendant Pope Richard sawyer 599075 599075 Pope, Richard, of Burgate, sawyer 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);