names

637 rows where place_id = 605984

✎ 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
3663591 1914543 1914543 defendant Patty George merchant 605984 605984 Patty, George, of Newcastle upon Tyne, merchant 2
3663592 1914543 1914543 defendant Allgood John merchant 605984 605984 Allgood, John, of Newcastle upon Tyne, merchant 3
3663593 1914543 1914543 defendant Waller Thomas merchant 605984 605984 Waller, Thomas, of Newcastle upon tyne, merchant 4
3928846 1999985 1999985 defendant Orde Bertram merchant 605984 605984 Orde, Bertram, of Newcastle upon Tyne, merchant 0
3928862 1999989 1999989 defendant Benson Richard   605984 605984 Benson, Richard, of Newcastle upon Tyne 2
3930396 2000512 2000512 defendant Davyson Margaret widow 605984 605984 Davyson, Margaret, of Newcastle upon Tyne, widow 0
3930400 2000513 2000513 defendant Davyson Margaret widow 605984 605984 Davyson, Margaret, of Newcastle upon Tyne, widow 0
3931990 2001000 2001000 defendant Dudley John merchant 605984 605984 Dudley, John, of Newcastle upon Tyne, merchant 0
3931992 2001001 2001001 defendant Dudley John merchant 605984 605984 Dudley, John, of Newcastle upon Tyne, merchant 0
3931998 2001003 2001003 defendant Steward Thomas gent 605984 605984 Steward, Thomas, of Newcastle upon Tyne, gent 1
3932002 2001004 2001004 defendant Steward Thomas   605984 605984 Steward, Thomas, of Newcastle upon Tyne 1
3933303 2001435 2001435 defendant Fenwyk Oswald merchant 605984 605984 Fenwyk, Oswald, of Newcastle upon Tyne, merchant 0
3933304 2001435 2001435 defendant Carre Peter merchant 605984 605984 Carre, Peter, of Newcastle upon Tyne, merchant 1
3933308 2001436 2001436 defendant Whetley Richard merchant 605984 605984 Whetley, Richard, of Newcastle upon Tyne, merchant 2
3935216 2002087 2002087 defendant Arnold James mariner 605984 605984 Arnold, James, of Newcastle upon Tyne, mariner 0
3935638 2002232 2002232 defendant Anderson Henry merchant 605984 605984 Anderson, Henry, of Newcastle upon Tyne, merchant 0
3936704 2002604 2002604 defendant Stole Robert merchant 605984 605984 Stole, Robert, of Newcastle upon Tyne, merchant 0
3936707 2002605 2002605 defendant Stole Robert merchant 605984 605984 Stole, Robert, of Newcastle upon Tyne, merchant 1
3939330 2003460 2003460 defendant Anderson Thomas chapman 605984 605984 Anderson, Thomas, of Newcastle upon Tyne, chapman 3
3939549 2003529 2003529 defendant Carre William merchant 605984 605984 Carre, William, of Newcastle upon Tyne, merchant 0
3940939 2003978 2003978 defendant Stott Robert merchant 605984 605984 Stott, Robert, of Newcastle upon Tyne, merchant 0
3940940 2003978 2003978 defendant Stott Richard glover 605984 605984 Stott, Richard, of Newcastle upon Tyne, glover 1
3940941 2003978 2003978 defendant Grene Thomas merchant 605984 605984 Grene, Thomas, of Newcastle upon Tyne, merchant 2
3942204 2004410 2004410 defendant Clarkson George yeoman 605984 605984 Clarkson, George, of Newcastle upon Tyne, yeoman 4
3942206 2004411 2004411 defendant Hynd John gent 605984 605984 Hynd, John, of Newcastle upon Tyne, gent 0
3942359 2004458 2004458 defendant Fenwyke Oswick merchant 605984 605984 Fenwyke, Oswick, of Newcastle upon Tyne, merchant 0
4415408 2169716 2169716 defendant Graper Peter   605984 605984 Graper, Peter, of Newcastle upon Tyne 0
4417251 2170278 2170278 defendant Threkeld Walter de   605984 605984 Threkeld, Walter de, of Newcastle upon Tyne, burgess 0
4417267 2170285 2170285 plaintiff Sadelyngstanes Hugh de   605984 605984 Sadelyngstanes, Hugh de, of Newcastle upon Tyne, burgess 0
4417389 2170322 2170322 plaintiff Scot Richard   605984 605984 Scot, Richard, of Newcastle upon Tyne 0
4418742 2170726 2170726 plaintiff Acton Maud de   605984 605984 Acton, Maud de, of Newcastle upon Tyne, formerly wife of Richard 0
4418743 2170726 2170726 defendant Conners Isolda   605984 605984 Conners, Isolda, of Newcastle upon Tyne 0
4418744 2170727 2170727 plaintiff Acton Maud de   605984 605984 Acton, Maud de, of Newcastle upon Tyne, formerly wife of Richard 0
4419814 2171093 2171093 defendant Dalton William de   605984 605984 Dalton, William de, of Newcastle upon Tyne 1
4419976 2171154 2171154 defendant Haukyn Thomas   605984 605984 Haukyn, Thomas, of Newcastle upon Tyne, son of Gilbert 0
4419977 2171154 2171154 defendant Almouth Peter   605984 605984 Almouth, Peter, of Newcastle upon Tyne 1
4422187 2171809 2171809 plaintiff Duresme John   605984 605984 Duresme, John, of Newcastle upon Tyne 0
4422189 2171810 2171810 plaintiff Duresme John   605984 605984 Duresme, John, of Newcastle upon Tyne, burgess 0
4422458 2171881 2171881 defendant Karliole Hugh de   605984 605984 Karliole, Hugh de, of Newcastle upon Tyne 0
4422459 2171881 2171881 defendant Flemyng Thomas   605984 605984 Flemyng, Thomas, of Newcastle upon Tyne 1
4427336 2173385 2173385 defendant Threlkeld Walter de   605984 605984 Threlkeld, Walter de, of Newcastle upon Tyne, burgess 0
4427340 2173386 2173386 defendant Threlkeld Walter de   605984 605984 Threlkeld, Walter de, of Newcastle upon Tyne, burgess 0
4427341 2173386 2173386 defendant Dalton Lawrence de   605984 605984 together with Dalton, Lawrence de, of Newcastle upon Tyne, burgess 1
4427342 2173386 2173386 defendant Dalton William de   605984 605984 Dalton, William de, of Newcastle upon Tyne, burgess 2
4427406 2173411 2173411 plaintiff Sadelyngstanes Hugh de   605984 605984 Sadelyngstanes, Hugh de, of Newcastle upon Tyne, burgess 0
4427561 2173454 2173454 plaintiff Scot Richard   605984 605984 Scot, Richard, of Newcastle upon Tyne 0
4429821 2174111 2174111 defendant Gray Thomas   605984 605984 Gray, Thomas, of Newcastle upon Tyne 1
4436260 2176083 2176083 plaintiff Sadelyngstanes Hugh de   605984 605984 Sadelyngstanes, Hugh de, of Newcastle upon Tyne, burgess 0
4439640 2181665 2181665 defendant Corbrigge de   605984 605984 Corbrigge, de, of Newcastle upon Tyne 2
4442767 2182693 2182693 defendant Bristell Stephen   605984 605984 Bristell, Stephen, of Newcastle upon Tyne 0
4442769 2182694 2182694 defendant Wrisell Stephen   605984 605984 Wrisell, Stephen, of Newcastle upon Tyne 0
4442771 2182695 2182695 defendant Wrisell Stephen   605984 605984 Wrisell, Stephen, of Newcastle upon Tyne 0
4450220 2185027 2185027 plaintiff Halywell Robert   605984 605984 Halywell, Robert, of Newcastle upon Tyne 0
4455702 2186794 2186794 defendant Muston William de   605984 605984 Muston, William de, of Newcastle upon Tyne, burgess 0
4455707 2186796 2186796 defendant del Chaumbre John (legal representative) 605984 605984 del Chaumbre, John, of Newcastle upon Tyne, executors of 0
4455708 2186796 2186796 defendant del Chaumbre Elizabeth   605984 605984 (del Chaumbre, Elizabeth, of Newcastle upon Tyne, formerly wife of John 1
4455978 2186889 2186889 defendant del Chaumbre John (legal representative) 605984 605984 del Chaumbre, John, of Newcastle upon Tyne, executors of 0
4455979 2186889 2186889 defendant del Chaumbre Elizabeth   605984 605984 (del Chaumbre, Elizabeth, of Newcastle upon Tyne, formerly wife of John 1
4458638 2187749 2187749 defendant Catryk William   605984 605984 Catryk, William, of Newcastle upon Tyne 1
4458838 2187812 2187812 defendant Catryk William   605984 605984 Catryk, William, of Newcastle upon Tyne 1
4463473 2189271 2189271 defendant Raynton Robert de   605984 605984 Raynton, Robert de, of Newcastle upon Tyne, burgess 0
4465034 2189725 2189725 defendant Cant Adam   605984 605984 Cant, Adam, of Newcastle upon Tyne, burgess 0
4465538 2189891 2189891 defendant Hostwell Richard   605984 605984 Hostwell, Richard, of Newcastle upon Tyne 0
4465539 2189891 2189891 defendant Coleman William   605984 605984 Coleman, William, of Newcastle upon Tyne 1
4465540 2189891 2189891 defendant Negwych Richard   605984 605984 Negwych, Richard, of Newcastle upon Tyne 2
4466538 2190209 2190209 defendant Palston Robert de   605984 605984 Palston, Robert de, of Newcastle upon Tyne, burgess 0
4466541 2190210 2190210 defendant Palston Robert   605984 605984 Palston, Robert, of Newcastle upon Tyne, burgess 0
4470915 2191555 2191555 defendant Langhirst Robert   605984 605984 Langhirst, Robert, of Newcastle upon Tyne 1
4470918 2191555 2191555 defendant York William   605984 605984 York, William, of Newcastle upon Tyne 4
4472626 2192107 2192107 defendant Conton John de   605984 605984 Conton, John de, of Newcastle upon Tyne 1
4472788 2192159 2192159 defendant Couper John   605984 605984 Couper, John, of Newcastle upon Tyne 2
4474151 2192568 2192568 defendant D--- Walter   605984 605984 D---, Walter, of Newcastle upon Tyne, burgess 0
4474157 2192570 2192570 defendant Humbleton William de   605984 605984 Humbleton, William de, of Newcastle upon Tyne 0
4474758 2192774 2192774 plaintiff Duresme William de   605984 605984 Duresme, William de, of Newcastle upon Tyne 0
4474759 2192774 2192774 defendant Bulkham John de   605984 605984 Bulkham, John de, of Newcastle upon tyne, administrators of 0
4474761 2192775 2192775 plaintiff Duresme William de   605984 605984 Duresme, William de, of Newcastle upon Tyne, burgess 0
4474762 2192775 2192775 defendant Bulkham John de   605984 605984 Bulkham, John de, of Newcastle upon Tyne, administrators of 0
4476132 2193205 2193205 defendant Hunter Stephen   605984 605984 Hunter, Stephen, of Newcastle upon Tyne 0
4476535 2193325 2193325 defendant Bulkham John   605984 605984 Bulkham, John, of Newcastle upon Tyne 0
4477766 2193713 2193713 plaintiff Halle William de   605984 605984 Halle, William de, of Newcastle upon Tyne 0
4478601 2193971 2193971 defendant Sclater William   605984 605984 Sclater, William, of Newcastle upon Tyne 0
4479074 2194111 2194111 defendant Masham John   605984 605984 Masham, John, of Newcastle upon Tyne 0
4479196 2194148 2194148 plaintiff Howeden John de   605984 605984 Howeden, John de, of Newcastle upon Tyne 0
4482459 2195215 2195215 defendant Cleyc--- Thomas tailor 605984 605984 Cleyc---, Thomas, of Newcastle upon Tyne, tailor 1
4482488 2195224 2195224 defendant Roos Rolcomus   605984 605984 Roos, Rolcomus, of Newcastle upon tyne 0
4482987 2195375 2195375 defendant Bysshoppisdale William   605984 605984 Bysshoppisdale, William, of Newcastle upon Tyne, formerly mayor 1
4482992 2195376 2195376 defendant Cleveland Thomas   605984 605984 Cleveland, Thomas, of Newcastle upon Tyne 0
4482999 2195378 2195378 defendant Bysshoppisdale William   605984 605984 Bysshoppisdale, William, of Newcastle upon Tyne, mayor 1
4483731 2195603 2195603 defendant Midelton William mercer 605984 605984 Midelton, William, of Newcastle upon Tyne, mercer 0
4484627 2195888 2195888 defendant Kempe John walker 605984 605984 Kempe, John, of Newcastle upon Tyne, walker 0
4486354 2196444 2196444 plaintiff Rys Nicholas   605984 605984 Rys, Nicholas, of Newcastle upon Tyne, vicar 0
4489132 2197317 2197317 defendant Balford Thomas   605984 605984 Balford, Thomas, of Newcastle upon Tyne 0
4490340 2197679 2197679 defendant Paul John   605984 605984 Paul, John, of Newcastle upon Tyne 0
4490896 2197850 2197850 defendant Page William   605984 605984 Page, William, of Newcastle upon Tyne 0
4491825 2198122 2198122 defendant Felton John de mercer 605984 605984 Felton, John de, of Newcastle upon tyne, mercer 0
4492266 2198261 2198261 defendant Haton William   605984 605984 Haton, William, of Newcastle upon Tyne 0
4492273 2198262 2198262 defendant Heton William   605984 605984 Heton, William, of Newcastle upon tyne 0
4494162 2198867 2198867 plaintiff Blake William   605984 605984 Blake, William, of Newcastle upon Tyne, on his own account 0
4495186 2199178 2199178 defendant Galon John (legal representative) 605984 605984 Galon, John, of Newcastle upon Tyne, mercer, executors of 0
4497360 2199821 2199821 defendant More John   605984 605984 More, John, of Newcastle upon Tyne 3

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