names

596 rows where place_id = 589401

✎ 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
3597538 1866852 1866852 defendant Anderson Thomas merchant 589401 589401 Anderson, Thomas, of Scardeburgh, merchant 0
3597540 1866853 1866853 defendant Anderson Thomas merchant 589401 589401 Anderson, Thomas, of Scardeburgh, merchant 0
3606873 1869815 1869815 plaintiff Percy John   589401 589401 Percy, John, of Scardeburgh 0
3607515 1870009 1870009 defendant Noram Robert fisherman 589401 589401 Noram, Robert, of Scardeburgh, fisherman 0
3607518 1870010 1870010 defendant Thistill Lawrence fisherman 589401 589401 Thistill, Lawrence, of Scardeburgh, fisherman 0
3607521 1870010 1870010 defendant Homanby William clerk 589401 589401 Homanby, William, of Scardeburgh, clerk 3
3607523 1870011 1870011 plaintiff Sage Thomas gent 589401 589401 Sage, Thomas, of Scardeburgh, gent 0
3607524 1870011 1870011 defendant Baxster John fisherman 589401 589401 Baxster, John, of Scardeburgh, fisherman 0
3607526 1870011 1870011 defendant Johnson John fisherman 589401 589401 Johnson, John, of Scardeburgh, fisherman 2
3610570 1870970 1870970 defendant Saweton John baker 589401 589401 Saweton, John, of Scardeburgh, baker 0
3622863 1874678 1874678 defendant Robynson Henry merchant 589401 589401 Robynson, Henry, of Scardeburgh, merchant 0
3635742 1905978 1905978 defendant Panyerman Thomas tailor 589401 589401 Panyerman, Thomas, of Scardeburgh, tailor 0
3639041 1907032 1907032 plaintiff Wales Richard   589401 589401 Wales, Richard, of Scardeburgh 0
3653079 1911292 1911292 defendant Sparowe William gent 589401 589401 Sparowe, William, of Scardeburgh, gent 0
3695099 1924682 1924682 defendant Percy Thomas gent 589401 589401 Percy, Thomas, of Scardeburgh, gent 0
3813779 1962223 1962223 defendant Fysshe Guy yeoman 589401 589401 Fysshe, Guy, of Scardeburgh, yeoman 0
3813780 1962223 1962223 defendant Cant John merchant 589401 589401 Cant, John, of Scardeburgh, merchant 1
3813781 1962223 1962223 defendant Cowton John goldsmith 589401 589401 Cowton, John, of Scardeburgh, goldsmith 2
3813782 1962223 1962223 defendant Fysshe William tanner 589401 589401 Fysshe, William, of Scardeburgh, tanner 3
4421751 2171685 2171685 plaintiff Cut or Out William, senior   589401 589401 Cut or Out, William, senior, of Scardeburgh 0
4421753 2171686 2171686 plaintiff Cut or Out William, senior   589401 589401 Cut or Out, William, senior, of Scardeburgh 0
4421755 2171687 2171687 plaintiff Cut William   589401 589401 Cut, William, of Scardeburgh 0
4421757 2171687 2171687 defendant Lymbsynner John   589401 589401 Lymbsynner, John, of Scardeburgh, bailiff 1
4427606 2173471 2173471 plaintiff Semer Adam de   589401 589401 Semer, Adam de, of Scardeburgh 0
4427609 2173471 2173471 defendant Cut William, senior   589401 589401 Cut, William, senior, of Scardeburgh 2
4437810 2181151 2181151 plaintiff Acclom John de   589401 589401 Acclom, John de, of Scardeburgh 0
4438655 2181378 2181378 plaintiff Atclom John de   589401 589401 Atclom, John de, of Scardeburgh 0
4439653 2181670 2181670 plaintiff Barbour Richard   589401 589401 Barbour, Richard, of Scardeburgh 0
4439853 2181742 2181742 defendant Semer William   589401 589401 Semer, William, of Scardeburgh 0
4442959 2182758 2182758 defendant Wawan John   589401 589401 Wawan, John, of Scardeburgh 1
4443327 2182873 2182873 plaintiff Carter William   589401 589401 Carter, William, of Scardeburgh 0
4443328 2182873 2182873 defendant Gegge John   589401 589401 Gegge, John, of Scardeburgh 0
4449033 2184641 2184641 defendant Carter William   589401 589401 Carter, William, of Scardeburgh 0
4449548 2184808 2184808 defendant Page William   589401 589401 Page, William, of Scardeburgh 0
4450678 2185171 2185171 defendant Ledelet Richard   589401 589401 Ledelet, Richard, of Scardeburgh 0
4456904 2187171 2187171 plaintiff Paa Robert   589401 589401 Paa, Robert, of Scardeburgh 0
4457395 2187326 2187326 defendant del Peke Thomas   589401 589401 del Peke, Thomas, of Scardeburgh 0
4457424 2187332 2187332 defendant Carter John   589401 589401 Carter, John, of Scardeburgh 2
4457904 2187492 2187492 defendant Page John   589401 589401 Page, John, of Scardeburgh 0
4459425 2187998 2187998 plaintiff Ryllyngton Robert de   589401 589401 Ryllyngton, Robert de, of Scardeburgh 0
4460049 2188201 2188201 plaintiff Semere William   589401 589401 Semere, William, of Scardeburgh 0
4460050 2188201 2188201 defendant Rillyngton John de   589401 589401 Rillyngton, John de, of Scardeburgh 0
4460053 2188203 2188203 plaintiff Semers William   589401 589401 Semers, William, of Scardeburgh 0
4460054 2188203 2188203 defendant Rillyngeton John   589401 589401 Rillyngeton, John, of Scardeburgh 0
4460080 2188214 2188214 plaintiff Sergeant John   589401 589401 Sergeant, John, of Scardeburgh 0
4460233 2188257 2188257 defendant Ridlyngton Robert de   589401 589401 Ridlyngton, Robert de, of Scardeburgh 0
4460902 2188476 2188476 defendant Rillyngton Robert de   589401 589401 Rillyngton, Robert de, of Scardeburgh 0
4464563 2189586 2189586 defendant Mauby Robert   589401 589401 Mauby, Robert, of Scardeburgh 0
4464567 2189587 2189587 defendant Rydale John de   589401 589401 Rydale, John de, of Scardeburgh 0
4466551 2190214 2190214 defendant Leget Richard   589401 589401 Leget, Richard, of Scardeburgh 0
4466553 2190215 2190215 defendant Egton John fisher 589401 589401 Egton, John, of Scardeburgh, fisher 0
4468589 2190848 2190848 plaintiff Bedale de Emma   589401 589401 Bedale de, Emma, of Scardeburgh, formerly wife of William de Bedale 0
4468590 2190848 2190848 defendant Sage Simon   589401 589401 Sage, Simon, of Scardeburgh 0
4470094 2191297 2191297 defendant Page William   589401 589401 Page, William, of Scardeburgh 0
4471028 2191595 2191595 plaintiff Bynglay William de   589401 589401 Bynglay, William de, of Scardeburgh 0
4471339 2191703 2191703 plaintiff Carter William   589401 589401 Carter, William, of Scardeburgh 0
4471344 2191704 2191704 plaintiff Carter William   589401 589401 Carter, William, of Scardeburgh, son of William 0
4473137 2192261 2192261 plaintiff (not given) John vicar of Coxhill 589401 589401 Coxhill, John, of Scardeburgh, vicar of St Mary's church 0
4474041 2192535 2192535 defendant Irton William de   589401 589401 Irton, William de, of Scardeburgh 1
4476546 2193329 2193329 plaintiff Galon Robert (legal representative) 589401 589401 Galon, Robert, of Scardeburgh, executors of 0
4476547 2193329 2193329 plaintiff Marche William draper 589401 589401 (Marche, William, of Scardeburgh, draper 1
4476548 2193329 2193329 plaintiff Wystowe Peter de   589401 589401 Wystowe, Peter de, of Scardeburgh 2
4476613 2193347 2193347 plaintiff Gardiner William   589401 589401 Gardiner, William, of Scardeburgh 0
4479675 2194302 2194302 defendant Wright Richard   589401 589401 Wright, Richard, of Scardeburgh 1
4485832 2196277 2196277 plaintiff Rillyngton Robert de (legal representative) 589401 589401 Rillyngton, Robert de, of Scardeburgh, executors of 0
4487324 2196750 2196750 defendant Lynton William de   589401 589401 Lynton, William de, of Scardeburgh 0
4487327 2196751 2196751 defendant Lynton John de   589401 589401 with Lynton, John de, of Scardeburgh 1
4487568 2196831 2196831 defendant Rillyngton Alice de   589401 589401 Rillyngton, Alice de, of Scardeburgh, formerly wife of John 0
4487572 2196832 2196832 defendant Scalby Joan (legal representative) 589401 589401 Scalby, Joan, of Scardeburgh, formerly wife of Thomas de Scalby, executors of 0
4490808 2197827 2197827 plaintiff Rillyngton Helen   589401 589401 Rillyngton, Helen, of Scardeburgh, formerly wife of Robert de Rillygnton, 2
4493694 2198726 2198726 plaintiff Baumburgh Adam de   589401 589401 Baumburgh, Adam de, of Scardeburgh, on his own account 0
4494759 2199055 2199055 defendant Joynour Thomas   589401 589401 Joynour, Thomas, of Scardeburgh 6
4495485 2199268 2199268 plaintiff Carethorp Thomas de   589401 589401 Carethorp, Thomas de, of Scardeburgh, on his own account 0
4495707 2199338 2199338 defendant Porter Richard   589401 589401 Porter, Richard, of Scardeburgh 0
4496701 2199636 2199636 plaintiff Crunol Alan   589401 589401 Crunol, Alan, of Scardeburgh 0
4496702 2199636 2199636 defendant Lowe John   589401 589401 Lowe, John, of Scardeburgh, junior 0
4496703 2199636 2199636 defendant Lowe Thomas   589401 589401 Lowe, Thomas, of Scardeburgh 1
4498584 2200200 2200200 plaintiff Funelay Henry de   589401 589401 Funelay, Henry de, of Scardeburgh 0
4498585 2200200 2200200 defendant Tomson Simon fisher 589401 589401 Tomson, Simon, of Scardeburgh, fisher 0
4498706 2200231 2200231 plaintiff Gardiner William   589401 589401 Gardiner, William, of Scardeburgh, on his own account 0
4498870 2200281 2200281 defendant Perkynson John   589401 589401 Perkynson, John, of Scardeburgh 1
4498871 2200281 2200281 defendant Wilcok John   589401 589401 Wilcok, John, of Scardeburgh 2
4499427 2200472 2200472 plaintiff Harom William   589401 589401 Harom, William, of Scardeburgh, on his own account 0
4499430 2200473 2200473 plaintiff Harou William   589401 589401 Harou, William, of Scardeburgh 0
4500891 2200900 2200900 defendant Taverner Thomas   589401 589401 Taverner, Thomas, of Scardeburgh 0
4501707 2201136 2201136 plaintiff Lynne John   589401 589401 Lynne, John, of Scardeburgh 0
4501708 2201136 2201136 defendant Loksmyth Thomas   589401 589401 Loksmyth, Thomas, of Scardeburgh 0
4504685 2202007 2202007 defendant del Fery John   589401 589401 del Fery, John, of Scardeburgh 0
4505841 2202331 2202331 defendant Leye Nicholas de   589401 589401 Leye, Nicholas de, of Scardeburgh 0
4505842 2202331 2202331 defendant Stokwyth John de, junior   589401 589401 Stokwyth, John de, junior, of Scardeburgh 1
4507588 2202833 2202833 defendant Lokton Roger   589401 589401 Lokton, Roger, of Scardeburgh 5
4508077 2202998 2202998 plaintiff Wystowe Peter de   589401 589401 Wystowe, Peter de, of Scardeburgh 0
4508107 2203010 2203010 defendant Wartre John de   589401 589401 Wartre, John de, of Scardeburgh 0
4508347 2203098 2203098 plaintiff Acclom John   589401 589401 Acclom, John, of Scardeburgh 0
4508616 2203173 2203173 defendant Seteryngton John de   589401 589401 Seteryngton, John de, of Scardeburgh 0
4510084 2203642 2203642 plaintiff Bamburgh Adam   589401 589401 Bamburgh, Adam, of Scardeburgh 0
4514767 2205035 2205035 plaintiff Carethorp Thomas   589401 589401 Carethorp, Thomas, of Scardeburgh, formerly bailiff 1
4514769 2205035 2205035 defendant Symson Thomas   589401 589401 Symson, Thomas, of Scardeburgh 1
4514775 2205038 2205038 defendant Langlay William   589401 589401 Langlay, William, of Scardeburgh 0
4515822 2205370 2205370 plaintiff Cleveland Robert de   589401 589401 Cleveland, Robert de, of Scardeburgh 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);