names

164 rows where place_id = 650763

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3913808 1994964 1994964 defendant Apoell Morris gent 650763 650763 Apoell, Morris, of Lincolns Inn, Middx, gent 0
3943890 2004972 2004972 plaintiff Ayloff William gent 650763 650763 Ayloff, William, of Lincolns Inn, Middx, gent 0
3947026 2006024 2006024 defendant Cave Ambrose gent 650763 650763 Cave, Ambrose, of Lincolns Inn, Middx, gent 1
3958474 2010035 2010035 plaintiff Rokewode Nicholas (legal representative) 650763 650763 Rokewode, Nicholas, of Lincolns Inn, Middx, esq, chief prothonotary of the Common Bench, executors of 0
3966763 2013010 2013010 defendant Wyndham Henry gent 650763 650763 Wyndham, Henry, of Lincolns Inn, Middx, gent 0
3969337 2013880 2013880 plaintiff Cope George gent 650763 650763 Cope, George, of Lincolns Inn, Middx, gent 0
3975560 2016018 2016018 defendant Bysshopp Francis   650763 650763 Bysshopp, Francis, of Lincolns Inn, Middx, gent, son of Thomas 1
3977471 2016691 2016691 defendant Taylboys Anthony gent 650763 650763 Taylboys, Anthony, of Lincolns Inn, Middx, gent 1
3977542 2016716 2016716 plaintiff Lodge Thomas gent 650763 650763 Lodge, Thomas, of Lincolns Inn, Middx, gent 0
3982501 2018519 2018519 plaintiff Saxy William gent 650763 650763 Saxy, William, of Lincolns Inn, Middx, gent 0
3982505 2018520 2018520 plaintiff Saxy William gent 650763 650763 Saxy, William, of Lincolns Inn, Middx, gent 0
3983064 2018718 2018718 defendant Burell Lambert gent 650763 650763 Burell, Lambert, of Lincolns Inn, Middx, gent 0
3985699 2019647 2019647 plaintiff Walmysley Robert gent 650763 650763 Walmysley, Robert, of Lincolns Inn, Middx, gent 0
3987220 2020176 2020176 plaintiff Wyldgose Alexander gent 650763 650763 Wyldgose, Alexander, of Lincolns Inn, Middx, gent 0
3993940 2022583 2022583 plaintiff Clarke Edward gent 650763 650763 Clarke, Edward, of Lincolns Inn, Middx, gent 0
3994464 2022771 2022771 defendant Barbour John gent 650763 650763 Barbour, John, of Lincolns Inn, Middx, gent 4
3994475 2022772 2022772 defendant Leighe Ralph (legal representative) 650763 650763 Leighe, Ralph, of Lincolns Inn, Middx, gent, administratrix of 0
3994718 2022863 2022863 defendant Kernesbewe John gent 650763 650763 Kernesbewe, John, of Lincolns Inn, Middx, gent 0
3999803 2024692 2024692 plaintiff Gascoigne William gent 650763 650763 Gascoigne, William, of Lincolns Inn, Middx, gent 0
4001606 2025353 2025353 defendant Scrope Ralph esq 650763 650763 Scrope, Ralph, of Lincolns Inn, Middx, esq 0
4001679 2025379 2025379 plaintiff Harpur Henry gent 650763 650763 Harpur, Henry, of Lincolns Inn, Middx, gent 0
4003840 2026139 2026139 plaintiff Hunt Nicholas (legal representative) 650763 650763 Hunt, Nicholas, of Lincolns Inn, Middx, gent, executors of 0
4005487 2026739 2026739 defendant Corbett William gent 650763 650763 Corbett, William, of Lincolns Inn, Middx, gent 2
4005672 2026801 2026801 defendant Townshend Edmund gent 650763 650763 Townshend, Edmund, of Lincolns Inn, Middx, gent 2
4005811 2026852 2026852 defendant Gravett Henry gent 650763 650763 Gravett, Henry, of Lincolns Inn, Middx, gent 3
4006618 2027144 2027144 plaintiff Lodge Thomas   650763 650763 Lodge, Thomas, of Lincolns Inn, Middx, gent, attorney of the bench 0
4006620 2027145 2027145 plaintiff Lodge Thomas   650763 650763 Lodge, Thomas, of Lincolns Inn, Middx, gent, attorney of the bench 0
4015900 2030376 2030376 plaintiff Spencer Robert gent 650763 650763 Spencer, Robert, of Lincolns Inn, Middx, gent 0
4017345 2030911 2030911 plaintiff Thetford Thomas gent 650763 650763 Thetford, Thomas, of Lincolns Inn, Middx, gent 0
4018809 2031459 2031459 plaintiff Waldron Humphrey gent 650763 650763 Waldron, Humphrey, of Lincolns Inn, Middx, gent 0
4020377 2032009 2032009 plaintiff Wilford Robert gent 650763 650763 Wilford, Robert, of Lincolns Inn, Middx, gent 0
4021280 2032336 2032336 plaintiff Wylford Robert gent 650763 650763 Wylford, Robert, of Lincolns Inn, Middx, gent 0
4022094 2032632 2032632 plaintiff Andrewes Thomas gent 650763 650763 Andrewes, Thomas, of Lincolns Inn, Middx, gent 0
4022099 2032633 2032633 plaintiff Andrewes Thomas gent 650763 650763 Andrewes, Thomas, of Lincolns Inn, Middx, gent 0
4022823 2032886 2032886 defendant Mounson Robert gent 650763 650763 Mounson, Robert, of Lincolns Inn, Middx, gent 0
4025502 2033777 2033777 defendant Dutton John gent 650763 650763 Dutton, John, of Lincolns Inn, Middx, gent 3
4025504 2033778 2033778 defendant Dutton John gent 650763 650763 Dutton, John, of Lincolns Inn, Middx, gent 0
4025720 2033851 2033851 plaintiff Browne Thomas   650763 650763 Browne, Thomas, of Lincolns Inn, Middx 0
4025722 2033852 2033852 plaintiff Browne Thomas gent 650763 650763 Browne, Thomas, of Lincolns Inn, Middx, gent 0
4027493 2034479 2034479 plaintiff Clarke Edward gent 650763 650763 Clarke, Edward, of Lincolns Inn, Middx, gent 0
4027496 2034480 2034480 plaintiff Clarke Edward gent 650763 650763 Clarke, Edward, of Lincolns Inn, Middx, gent 0
4030254 2035473 2035473 plaintiff Dutton John, senior gent 650763 650763 Dutton, John, senior, of Lincolns Inn, Middx, gent 0
4032501 2036270 2036270 plaintiff Gascoigne William gent 650763 650763 Gascoigne, William, of Lincolns Inn, Middx, gent 0
4032786 2036380 2036380 plaintiff Glanvyle John gent 650763 650763 Glanvyle, John, of Lincolns Inn, Middx, gent 0
4034370 2036964 2036964 defendant Scrope Ralph esq 650763 650763 Scrope, Ralph, of Lincolns Inn, Middx, esq 0
4036222 2037638 2037638 defendant Wylford Robert gent 650763 650763 Wylford, Robert, of Lincolns Inn, Middx, gent 1
4045513 2040847 2040847 plaintiff Salven John (legal representative) 650763 650763 Salven, John, of Lincolns Inn, Middx, esq, executors of 0
4045518 2040848 2040848 plaintiff Salven John (legal representative) 650763 650763 Salven, John, of Lincolns Inn, Middx, esq, executors of 0
4047088 2041405 2041405 plaintiff Spencer Robert gent 650763 650763 Spencer, Robert, of Lincolns Inn, Middx, gent 0
4054074 2043841 2043841 plaintiff Ayolfe Ralph gent 650763 650763 Ayolfe, Ralph, of Lincolns Inn, Middx, gent 0
4054962 2044169 2044169 plaintiff Baxster Thomas gent 650763 650763 Baxster, Thomas, of Lincolns Inn, Middx, gent 0
4057297 2044994 2044994 plaintiff Burdsall William gent 650763 650763 Burdsall, William, of Lincolns Inn, Middx, gent 0
4058730 2045515 2045515 plaintiff Phillips Henry gent 650763 650763 Phillips, Henry, of Lincolns Inn, Middx, gent 1
4064746 2047677 2047677 defendant Danyell John gent 650763 650763 Danyell, John, of Lincolns Inn, Middx, gent 1
4064872 2047722 2047722 defendant Beston Hugh gent 650763 650763 Beston, Hugh, of Lincolns Inn, Middx, gent 2
4071688 2050172 2050172 plaintiff Nayler William   650763 650763 Nayler, William, of Lincolns Inn, Middx 0
4071690 2050173 2050173 plaintiff Nayler William gent 650763 650763 Nayler, William, of Lincolns Inn, Middx, gent 0
4072784 2050566 2050566 plaintiff Paschall John gent 650763 650763 Paschall, John, of Lincolns Inn, Middx, gent 0
4074348 2051129 2051129 plaintiff Pytt Richard   650763 650763 Pytt, Richard, of Lincolns Inn, Middx 0
4074407 2051151 2051151 defendant Calthrope Charles esq 650763 650763 Calthrope, Charles, of Lincolns Inn, Middx, esq 1
4076741 2051969 2051969 defendant Dutton John gent 650763 650763 Dutton, John, of Lincolns Inn, Middx, gent 0
4076744 2051970 2051970 defendant Dutton John gent 650763 650763 Dutton, John, of Lincolns Inn, Middx, gent 0
4076752 2051973 2051973 defendant Dutton John gent 650763 650763 Dutton, John, of Lincolns Inn, Middx, gent 1
4079636 2053016 2053016 defendant Chapman John gent 650763 650763 Chapman, John, of Lincolns Inn, Middx, gent 1
4079683 2053033 2053033 defendant Touneshend Edmund gent 650763 650763 Touneshend, Edmund, of Lincolns Inn, Middx, gent 0
4081126 2053562 2053562 plaintiff Wetherall Roger (legal representative) 650763 650763 Wetherall, Roger, of Lincolns Inn, Middx, esq, executors of 0
4081130 2053563 2053563 plaintiff Wetherall Roger (legal representative) 650763 650763 Wetherall, Roger, of Lincolns Inn, Middx, esq, executors of 0
4081134 2053564 2053564 plaintiff Wethereld Roger esq 650763 650763 Wethereld, Roger, of Lincolns Inn, Middx, esq 0
4081137 2053565 2053565 plaintiff Wethereld Roger (legal representative) 650763 650763 Wethereld, Roger, of Lincolns Inn, Middx, esq, executors of 0
4082088 2053888 2053888 defendant Dutton John gent 650763 650763 Dutton, John, of Lincolns Inn, Middx, gent 2
4083923 2054527 2054527 plaintiff Baker Robert gent 650763 650763 Baker, Robert, of Lincolns Inn, Middx, gent 0
4085401 2055054 2055054 defendant Willett John (legal representative) 650763 650763 Willett, John, of Lincolns Inn, Middx, gent, executrix of 0
4095747 2058812 2058812 defendant Jenney Chrisopher gent 650763 650763 Jenney, Chrisopher, of Lincolns Inn, Middx, gent 0
4097701 2059508 2059508 defendant Touneshend Edmund gent 650763 650763 Touneshend, Edmund, of Lincolns Inn, Middx, gent 0
4101602 2060879 2060879 defendant Jennye Christopher gent 650763 650763 Jennye, Christopher, of Lincolns Inn, Middx, gent 0
4103520 2061544 2061544 defendant Calthropp Charles gent 650763 650763 Calthropp, Charles, of Lincolns Inn, Middx, gent 3
4107252 2062886 2062886 defendant Copley Alvered gent 650763 650763 Copley, Alvered, of Lincolns Inn, Middx, gent 0
4108366 2063248 2063248 defendant Penson Valentine gent 650763 650763 Penson, Valentine, of Lincolns Inn, Middx, gent 1
4109646 2063707 2063707 defendant Calthrop Charles gent 650763 650763 Calthrop, Charles, of Lincolns Inn, Middx, gent 0
4109993 2063834 2063834 defendant Browne Thomas gent 650763 650763 Browne, Thomas, of Lincolns Inn, Middx, gent 0
4113298 2065023 2065023 defendant Baker Robert gent 650763 650763 Baker, Robert, of Lincolns Inn, Middx, gent 0
4116796 2066304 2066304 defendant Hungaite Robert gent 650763 650763 Hungaite, Robert, of Lincolns Inn, Middx, gent 0
4121033 2067811 2067811 defendant Levesey Edward gent 650763 650763 Levesey, Edward, of Lincolns Inn, Middx, gent 0
4127371 2070080 2070080 defendant Savyle John gent 650763 650763 Savyle, John, of Lincolns Inn, Middx, gent 0
4127868 2070257 2070257 defendant Trenche Richard gent 650763 650763 Trenche, Richard, of Lincolns Inn, Middx, gent 0
4128191 2070370 2070370 defendant Dalabere Richard gent 650763 650763 Dalabere, Richard, of Lincolns Inn, Middx, gent 2
4132089 2071787 2071787 defendant Downes Ralph gent 650763 650763 Downes, Ralph, of Lincolns Inn, Middx, gent 0
4134449 2072651 2072651 defendant Blake William merchant 650763 650763 Blake, William, of Lincolns Inn, Middx, gent, or of Endelyan, Cornw, merchant 0
4134567 2072695 2072695 defendant Baker Robert gent 650763 650763 Baker, Robert, of Lincolns Inn, Middx, gent 0
4134570 2072696 2072696 defendant Baker Robert gent 650763 650763 Baker, Robert, of Lincolns Inn, Middx, gent 0
4135612 2073060 2073060 defendant Crake Ralph, junior gent 650763 650763 Crake, Ralph, junior, of Lincolns Inn, Middx, gent 0
4136971 2073571 2073571 defendant Calthorpe Charles esq 650763 650763 Calthorpe, Charles, of Lincolns Inn, Middx, esq 0
4138288 2074060 2074060 defendant Bacon George gent 650763 650763 Bacon, George, of Lincolns Inn, Middx, gent 2
4147200 2077160 2077160 defendant Browne Thomas gent 650763 650763 Browne, Thomas, of Lincolns Inn, Middx, gent 0
4151597 2078676 2078676 defendant Dalabere Richard gent 650763 650763 Dalabere, Richard, of Lincolns Inn, Middx, gent 5
4161169 2081983 2081983 defendant Lloyde Henry gent 650763 650763 Lloyde, Henry, of Lincolns Inn, Middx, gent 1
4162854 2082542 2082542 defendant Raynesford Thomas gent 650763 650763 Raynesford, Thomas, of Lincolns Inn, Middx, gent 40
4163435 2082735 2082735 defendant Perman John gent 650763 650763 Perman, John, of Lincolns Inn, Middx, gent 3
4164747 2083180 2083180 defendant Wood Tobias gent 650763 650763 (Wood, Tobias, of Lincolns inn, Middx, gent 2
4168595 2084501 2084501 defendant Hooper Henry gent 650763 650763 Hooper, Henry, of Lincolns Inn, Middx, gent 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);