names

1,187 rows where place_id = 586836

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3589769 1864440 1864440 defendant Danyell Christopher merchant 586836 586836 Danyell, Christopher, of Newcastle on Tyne, merchant 0
3589770 1864440 1864440 defendant Sample Roger merchant 586836 586836 Sample, Roger, of Newcastle on Tyne, merchant 1
3590348 1864622 1864622 defendant Selle or Selbe William yeoman 586836 586836 Selle or Selbe, William, of Newcastle on Tyne, yeoman 0
3594296 1865851 1865851 defendant harbred Thomas merchant 586836 586836 harbred, Thomas, of Newcastle on Tyne, merchant 3
3594305 1865852 1865852 defendant Robson Robert tailor 586836 586836 Robson, Robert, of Newcastle on Tyne, tailor 6
3594306 1865852 1865852 defendant Robson William yeoman 586836 586836 Robson, William, of Newcastle on Tyne, yeoman 7
3594400 1865883 1865883 defendant Benle or Beule Edmund merchant 586836 586836 Benle or Beule, Edmund, of Newcastle on Tyne, merchant 0
3594402 1865884 1865884 defendant Benle Edmund merchant 586836 586836 Benle, Edmund, of Newcastle on Tyne, merchant 0
3595832 1866333 1866333 defendant Selke George merchant 586836 586836 Selke, George, of Newcastle on Tyne, merchant 0
3597349 1866790 1866790 defendant Conyngham George merchant 586836 586836 Conyngham, George, of Newcastle on Tyne, merchant 0
3601191 1868037 1868037 defendant Watson Thomas merchant 586836 586836 Watson, Thomas, of Newcastle on Tyne, merchant 0
3601192 1868037 1868037 defendant Tompson Robert merchant 586836 586836 Tompson, Robert, of Newcastle on Tyne, merchant 1
3606903 1869823 1869823 defendant Colte Thomas (legal representative) 586836 586836 Colte, Thomas, of Newcastle on Tyne, merchant, executors of 2
3607358 1869962 1869962 defendant Penreth Thomas merchant 586836 586836 Penreth, Thomas, of Newcastle on Tyne, merchant 0
3607359 1869962 1869962 defendant Kar William merchant 586836 586836 Kar, William, of Newcastle on Tyne, merchant 1
3607361 1869963 1869963 defendant Penreth Thomas merchant 586836 586836 Penreth, Thomas, of Newcastle on Tyne, merchant 0
3607362 1869963 1869963 defendant Kar William merchant 586836 586836 Kar, William, of Newcastle on Tyne, merchant 1
3607364 1869964 1869964 defendant Penreth Thomas merchant 586836 586836 Penreth, Thomas, of Newcastle on Tyne, merchant 0
3607365 1869964 1869964 defendant Kar William merchant 586836 586836 Kar, William, of Newcastle on Tyne, merchant 1
3607432 1869983 1869983 defendant Stokehall Robert merchant 586836 586836 Stokehall, Robert, of Newcastle on Tyne, merchant 0
3607433 1869983 1869983 defendant Borell Christopher merchant 586836 586836 Borell, Christopher, of Newcastle on Tyne, merchant 1
3607436 1869984 1869984 defendant Stokehall Robert merchant 586836 586836 Stokehall, Robert, of Newcastle on Tyne, merchant 0
3607437 1869984 1869984 defendant Borell Christopher merchant 586836 586836 Borell, Christopher, of Newcastle on Tyne, merchant 1
3607440 1869985 1869985 defendant Stokhall Robert merchant 586836 586836 Stokhall, Robert, of Newcastle on Tyne, merchant 0
3607441 1869985 1869985 defendant Borell Christopher merchant 586836 586836 Borell, Christopher, of Newcastle on Tyne, merchant 1
3607510 1870008 1870008 defendant Doddyn Richard barker 586836 586836 Doddyn, Richard, of Newcastle on Tyne, barker 1
3607525 1870011 1870011 defendant Hanyng William merchant 586836 586836 Hanyng, William, of Newcastle on Tyne, merchant 1
3608105 1870187 1870187 defendant Lokwode Thomas mercer 586836 586836 Lokwode, Thomas, of Newcastle on Tyne, mercer 0
3608204 1870222 1870222 defendant Clerk Robert yeoman 586836 586836 Clerk, Robert, of Newcastle on Tyne, yeoman 3
3610821 1871051 1871051 defendant Wate William chaplain 586836 586836 Wate, William, of Newcastle on Tyne, chaplain 0
3613706 1871935 1871935 defendant Johnson Cuthbert carpenter 586836 586836 Johnson, Cuthbert, of Newcastle on Tyne, carpenter 0
3613708 1871936 1871936 defendant Johnson Cuthbert carpenter 586836 586836 Johnson, Cuthbert, of Newcastle on Tyne, carpenter 0
3617635 1873138 1873138 defendant Lokwod Thomas merchant 586836 586836 Lokwod, Thomas, of Newcastle on Tyne, merchant 0
3617636 1873138 1873138 defendant Swanne Thomas merchant 586836 586836 Swanne, Thomas, of Newcastle on Tyne, merchant 1
3617637 1873138 1873138 defendant Baxster Roger merchant 586836 586836 Baxster, Roger, of Newcastle on Tyne, merchant 2
3622311 1874514 1874514 defendant Herryson Thomas (legal representative) 586836 586836 Herryson, Thomas, of Newcastle on Tyne, merchant, executors of 0
3622312 1874514 1874514 defendant Camby Thomas   586836 586836 (Camby, Thomas, of Newcastle on Tyne 1
3627177 1903355 1903355 defendant Hardyng Alan merchant 586836 586836 Hardyng, Alan, of Newcastle on Tyne, merchant 3
3635724 1905976 1905976 defendant Tyrpyn Christopher yeoman 586836 586836 Tyrpyn, Christopher, of Newcastle on Tyne, yeoman 0
3643370 1908353 1908353 defendant Carre Robert yeoman 586836 586836 Carre, Robert, of Newcastle on Tyne, yeoman 0
3645059 1908864 1908864 defendant Turpyn Nicholas gent 586836 586836 Turpyn, Nicholas, of Newcastle on Tyne, gent 0
3646238 1909214 1909214 defendant Symond William mariner 586836 586836 Symond, William, of Newcastle on Tyne, mariner 0
3646752 1909388 1909388 defendant Watson Robert fuller 586836 586836 Watson, Robert, of Newcastle on Tyne, fuller 0
3650152 1910417 1910417 defendant Wodroff Henry beer brewer 586836 586836 Wodroff, Henry, of Newcastle on Tyne, beer brewer 0
3672900 1917538 1917538 defendant Thomason Archibald smith 586836 586836 Thomason, Archibald, of Newcastle on Tyne, smith 0
3677342 1918962 1918962 defendant Leyrmoth Nicholas merchant 586836 586836 Leyrmoth, Nicholas, of Newcastle on Tyne, merchant 0
3685719 1921692 1921692 defendant Swan George innholder 586836 586836 Swan, George, of Newcastle on Tyne, innholder 0
3689191 1922784 1922784 defendant Dent John clerk 586836 586836 Dent, John, of Newcastle on Tyne, clerk 0
3689192 1922784 1922784 defendant Dent Roger gent 586836 586836 Dent, Roger, of Newcastle on Tyne, gent 1
3689220 1922794 1922794 defendant Lawson James merchant 586836 586836 Lawson, James, of Newcastle on Tyne, merchant 0
3692996 1924012 1924012 defendant Hanson Thomas merchant 586836 586836 Hanson, Thomas, of Newcastle on Tyne, merchant 0
3694843 1924594 1924594 defendant Blunt John merchant 586836 586836 Blunt, John, of Newcastle on Tyne, merchant 0
3694844 1924594 1924594 defendant Myddylton Gilbert merchant 586836 586836 Myddylton, Gilbert, of Newcastle on Tyne, merchant 1
3694876 1924606 1924606 defendant Blunt John merchant 586836 586836 Blunt, John, of Newcastle on Tyne, merchant 0
3694877 1924606 1924606 defendant Middylton Gilbert merchant 586836 586836 Middylton, Gilbert, of Newcastle on Tyne, merchant 1
3701507 1926720 1926720 plaintiff Brigham Christopher merchant 586836 586836 Brigham, Christopher, of Newcastle on Tyne, merchant 0
3714996 1930987 1930987 plaintiff Brandlyng John (legal representative) 586836 586836 Brandlyng, John, of Newcastle on Tyne, merchant, executor of 0
3717828 1931880 1931880 defendant Russell Robert yeoman of the crown 586836 586836 Russell, Robert, of Newcastle on Tyne, yeoman of the crown 0
3722449 1933280 1933280 defendant Johnson Thomas merchant 586836 586836 Johnson, Thomas, of Newcastle on Tyne, merchant 0
3733568 1936742 1936742 defendant Dent John clerk 586836 586836 Dent, John, of Newcastle on Tyne, clerk 0
3733569 1936742 1936742 defendant Dent Roger gent 586836 586836 Dent, Roger, of Newcastle on Tyne, gent 1
3733813 1936829 1936829 defendant Jeklowe Bartram merchant 586836 586836 Jeklowe, Bartram, of Newcastle on Tyne, merchant 0
3739236 1938491 1938491 defendant Taylor John mariner 586836 586836 Taylor, John, of Newcastle on Tyne, mariner 1
3742413 1939499 1939499 defendant Care William merchant 586836 586836 Care, William, of Newcastle on Tyne, merchant 0
3742414 1939499 1939499 defendant Care Humphrey merchant 586836 586836 Care, Humphrey, of Newcastle on Tyne, merchant 1
3742415 1939499 1939499 defendant Bartram Robert merchant 586836 586836 Bartram, Robert, of Newcastle on Tyne, merchant 2
3742416 1939499 1939499 defendant Care George chaplain 586836 586836 Care, George, of Newcastle on Tyne, chaplain 3
3743374 1939800 1939800 defendant Kendall Robert merchant 586836 586836 Kendall, Robert, of Newcastle on Tyne, merchant 2
3746697 1940878 1940878 defendant Blunt John merchant 586836 586836 Blunt, John, of Newcastle on Tyne, merchant 3
3750932 1942216 1942216 defendant Brandlyng Robert merchant 586836 586836 Brandlyng, Robert, of Newcastle on Tyne, merchant 0
3750933 1942216 1942216 defendant Myddylton Gilbert merchant 586836 586836 Myddylton, Gilbert, of Newcastle on Tyne, merchant 1
3750934 1942216 1942216 defendant Elwold George merchant 586836 586836 Elwold, George, of Newcastle on Tyne, merchant 2
3750935 1942216 1942216 defendant Ryddell Thomas merchant 586836 586836 Ryddell, Thomas, of Newcastle on Tyne, merchant 3
3750936 1942216 1942216 defendant Nordus Robert mariner 586836 586836 Nordus, Robert, of Newcastle on Tyne, mariner 4
3760887 1945410 1945410 defendant Thomson Archibald smith 586836 586836 Thomson, Archibald, of Newcastle on Tyne, smith 0
3773484 1949418 1949418 defendant Broun John clerk 586836 586836 Broun, John, of Newcastle on Tyne, clerk 0
3773486 1949419 1949419 defendant Broun John clerk 586836 586836 Broun, John, of Newcastle on Tyne, clerk 0
3776860 1950502 1950502 defendant Aylmer Thomas merchant 586836 586836 Aylmer, Thomas, of Newcastle on Tyne, merchant 0
3776862 1950503 1950503 defendant Aylmer Thomas merchant 586836 586836 Aylmer, Thomas, of Newcastle on Tyne, merchant 0
3778648 1951034 1951034 plaintiff Davell George merchant 586836 586836 Davell, George, of Newcastle on Tyne, merchant 0
3778930 1951127 1951127 plaintiff Dobson John tailor 586836 586836 Dobson, John, of Newcastle on Tyne, tailor 0
3778931 1951127 1951127 defendant Sparke William tailor 586836 586836 Sparke, William, of Newcastle on Tyne, tailor 0
3787318 1953825 1953825 plaintiff Riddall Thomas merchant 586836 586836 Riddall, Thomas, of Newcastle on Tyne, merchant 0
3788929 1954348 1954348 defendant Davell George merchant 586836 586836 Davell, George, of Newcastle on Tyne, merchant 0
3791429 1955156 1955156 defendant Doxforth John merchant 586836 586836 Doxforth, John, of Newcastle on Tyne, merchant 0
3791433 1955157 1955157 defendant Doxforth John merchant 586836 586836 Doxforth, John, of Newcastle on Tyne, merchant 0
3795452 1956454 1956454 defendant Grene Thomas chapman 586836 586836 Grene, Thomas, of Newcastle on Tyne, chapman 2
3795453 1956454 1956454 defendant Strokyll Nicholas chapman 586836 586836 Strokyll, Nicholas, of Newcastle on Tyne, chapman 3
3796001 1956611 1956611 defendant Aunderson John mercer 586836 586836 Aunderson, John, of Newcastle on Tyne, mercer 0
3798256 1957351 1957351 defendant Lighton Peter chapman 586836 586836 Lighton, Peter, of Newcastle on Tyne, chapman 0
3800308 1958015 1958015 defendant Hanson Thomas merchant 586836 586836 Hanson, Thomas, of Newcastle on Tyne, merchant 0
3806508 1959948 1959948 defendant Borough John gent 586836 586836 Borough, John, of Newcastle on Tyne, gent 3
3810238 1961096 1961096 plaintiff Brandlyng John (legal representative) 586836 586836 Brandlyng, John, of Newcastle on Tyne, merchant, executor of 0
3813074 1961995 1961995 defendant Bee Bartholomew merchant 586836 586836 Bee, Bartholomew, of Newcastle on Tyne, merchant 0
3813076 1961996 1961996 defendant Borell George merchant 586836 586836 Borell, George, of Newcastle on Tyne, merchant 0
3815475 1962755 1962755 defendant Wotwod Robert yeoman 586836 586836 Wotwod, Robert, of Newcastle on Tyne, yeoman 0
3817676 1963431 1963431 defendant Musgrave Leonard esq 586836 586836 Musgrave, Leonard, of Newcastle on Tyne, esq 1
3817701 1963439 1963439 defendant Jobson Thomas saddler 586836 586836 Jobson, Thomas, of Newcastle on Tyne, saddler 0
3818753 1963769 1963769 defendant Handson Thomas merchant 586836 586836 Handson, Thomas, of Newcastle on Tyne, merchant 0
3821917 1964746 1964746 defendant Hanson Thomas merchant 586836 586836 Hanson, Thomas, of Newcastle on Tyne, merchant 0

Next page

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);