names

111 rows where place_id = 595017

✎ 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
3618541 1873422 1873422 defendant Malet William gent 595017 595017 Malet, William, of Inner Temple, London, gent 0
3721450 1933018 1933018 defendant Grenfeld alias Grevynfeld John gent 595017 595017 Grenfeld alias Grevynfeld, John, of Inner Temple, London, gent 1
3832308 1968021 1968021 defendant Symondys William gent 595017 595017 Symondys, William, of Inner Temple, London, gent 1
3835739 1969105 1969105 defendant Beamounte John gent 595017 595017 Beamounte, John, of Inner Temple, London, gent 0
3841970 1971050 1971050 defendant Denys Maurice gent 595017 595017 Denys, Maurice, of Inner Temple, London, gent 0
3850084 1973620 1973620 defendant Palmer John gent 595017 595017 Palmer, John, of Inner temple, London, gent 0
3855229 1975268 1975268 defendant Herverd William gent 595017 595017 Herverd, William, of Inner Temple, London, gent 1
3925941 1998991 1998991 defendant Hogyng alias Huggon William gent 595017 595017 Hogyng alias Huggon, William, of Inner Temple, London, gent 0
3951227 2007500 2007500 defendant Bury John gent 595017 595017 Bury, John, of Inner Temple, London, gent 0
3953964 2008457 2008457 defendant Bery John gent 595017 595017 Bery, John, of Inner Temple, London, gent 0
3963449 2011821 2011821 plaintiff Wythe Robert gent 595017 595017 Wythe, Robert, of Inner Temple, London, gent 0
3964247 2012102 2012102 defendant Russell John gent 595017 595017 Russell, John, of Inner Temple, London, gent 0
3966324 2012848 2012848 defendant Lutwich Edward gent 595017 595017 Lutwich, Edward, of Inner Temple, London, gent 0
3972420 2014927 2014927 plaintiff Fytz John esq 595017 595017 Fytz, John, of Inner Temple, London, esq 0
3972422 2014928 2014928 plaintiff Fytz John esq 595017 595017 Fytz, John, of Inner Temple, London, esq 0
3972423 2014928 2014928 defendant Fletcher Thomas gent 595017 595017 Fletcher, Thomas, of Inner Temple, London, gent 0
3973295 2015233 2015233 plaintiff Grenewood Robert gent 595017 595017 Grenewood, Robert, of Inner Temple, London, gent 0
3977738 2016784 2016784 plaintiff Lutwyche Edward gent 595017 595017 Lutwyche, Edward, of Inner Temple, London, gent 0
3978048 2016897 2016897 plaintiff Mardyn Thomas gent 595017 595017 Mardyn, Thomas, of Inner Temple, London, gent 0
3981124 2018007 2018007 plaintiff Puleston Roger esq 595017 595017 Puleston, Roger, of Inner Temple, London, esq 0
3981274 2018069 2018069 plaintiff Pytt Edward gent 595017 595017 Pytt, Edward, of Inner Temple, London, gent 0
3981966 2018312 2018312 defendant Fletcher Thomas gent 595017 595017 Fletcher, Thomas, of Inner Temple, London, gent 0
3982848 2018639 2018639 defendant Franckland Richard gent 595017 595017 Franckland, Richard, of Inner Temple, London, gent 0
3983390 2018835 2018835 plaintiff Sneyd Ralph esq 595017 595017 Sneyd, Ralph, of Inner Temple, London, esq 0
3983957 2019030 2019030 defendant Smyth Thomas gent 595017 595017 Smyth, Thomas, of Inner Temple, London, gent 0
3984195 2019113 2019113 defendant Heathe Robert gent 595017 595017 Heathe, Robert, of Inner Temple, London, gent 1
3984481 2019206 2019206 defendant Franklyn William   595017 595017 Franklyn, William, of Inner Temple, London, gent, attorney of the bench 0
3985101 2019425 2019425 defendant Wood Owen gent 595017 595017 Wood, Owen, of Inner Temple, London, gent 0
3987613 2020319 2020319 defendant Mullinax Thomas gent 595017 595017 Mullinax, Thomas, of Inner Temple, London, gent 0
3988220 2020535 2020535 defendant Fenner Edward gent 595017 595017 Fenner, Edward, of Inner Temple, London, gent 0
3989317 2020920 2020920 plaintiff Bamforthe or Bainforthe Thurstan gent 595017 595017 Bamforthe or Bainforthe, Thurstan, of Inner Temple, London, gent 0
3992201 2021976 2021976 plaintiff Bullock John gent 595017 595017 Bullock, John, of Inner Temple, London, gent 0
3994283 2022708 2022708 plaintiff Cobbe John gent 595017 595017 Cobbe, John, of Inner Temple, London, gent 0
3995837 2023259 2023259 plaintiff Culme Hugh gent 595017 595017 Culme, Hugh, of Inner Temple, London, gent 0
4000906 2025095 2025095 plaintiff Guybon William gent 595017 595017 Guybon, William, of Inner Temple, London, gent 0
4004763 2026481 2026481 plaintiff Johnson William   595017 595017 Johnson, William, of Inner Temple, London 0
4006284 2027027 2027027 plaintiff Lee William gent 595017 595017 Lee, William, of Inner Temple, London, gent 0
4007294 2027390 2027390 plaintiff Malorye Andrew gent 595017 595017 Malorye, Andrew, of Inner Temple, London, gent 0
4010507 2028531 2028531 defendant Browne Ralph gent 595017 595017 Browne, Ralph, of Inner Temple, London, gent 0
4014089 2029767 2029767 defendant Phillipps John gent 595017 595017 Phillipps, John, of Inner Temple, London, gent 7
4016880 2030736 2030736 plaintiff Sydenham Walter esq 595017 595017 Sydenham, Walter, of Inner Temple, London, esq 0
4016892 2030740 2030740 defendant Carpenter Richard gent 595017 595017 Carpenter, Richard, of Inner Temple, London, gent 0
4016902 2030745 2030745 plaintiff Sydnam Walter esq 595017 595017 Sydnam, Walter, of Inner Temple, London, esq 0
4018194 2031230 2031230 plaintiff Turnor John gent 595017 595017 Turnor, John, of Inner Temple, London, gent 0
4018275 2031264 2031264 plaintiff Tylden Richard gent 595017 595017 Tylden, Richard, of Inner Temple, London, gent 0
4021277 2032335 2032335 plaintiff Colepeper Francis gent 595017 595017 Colepeper, Francis, of Inner Temple, London, gent 1
4024700 2033515 2033515 plaintiff Bonvyle Guy gent 595017 595017 Bonvyle, Guy, of Inner Temple, London, gent 0
4024806 2033554 2033554 plaintiff Bovile Guy gent 595017 595017 Bovile, Guy, of Inner temple, ,London, gent 0
4028706 2034918 2034918 plaintiff Coventry Thomas gent 595017 595017 Coventry, Thomas, of Inner Temple, London, gent 0
4028710 2034919 2034919 plaintiff Coventry Thomas gent 595017 595017 Coventry, Thomas, of Inner Temple, London, gent 0
4029780 2035292 2035292 plaintiff Dennys Francis gent 595017 595017 Dennys, Francis, of Inner Temple, London, gent 0
4031251 2035849 2035849 defendant Puresey Michael gent 595017 595017 Puresey, Michael, of Inner Temple, London, gent 0
4033231 2036540 2036540 plaintiff Grafton Robert clerk 595017 595017 Grafton, Robert, of Inner Temple, London, clerk 0
4034337 2036953 2036953 plaintiff Hare Nicholas gent 595017 595017 Hare, Nicholas, of Inner Temple, London, gent 0
4034962 2037184 2037184 plaintiff Heale John gent 595017 595017 Heale, John, of Inner Temple, London, gent 0
4034998 2037200 2037200 plaintiff Hele John gent 595017 595017 Hele, John, of Inner Temple, London, gent 0
4039049 2038590 2038590 plaintiff Love Richard gent 595017 595017 Love, Richard, of Inner Temple, London, gent 0
4041897 2039588 2039588 plaintiff Ogle Nicholas gent 595017 595017 Ogle, Nicholas, of Inner Temple, London, gent 0
4050070 2042452 2042452 plaintiff Walshe Thomas gent 595017 595017 Walshe, Thomas, of Inner Temple, London, gent 0
4051136 2042845 2042845 defendant Grymston Edward gent 595017 595017 Grymston, Edward, of Inner Temple, London, gent 3
4051147 2042848 2042848 defendant Grymston Edward gent 595017 595017 Grymston, Edward, of Inner Temple, London, gent 3
4055182 2044246 2044246 plaintiff Bedill Richard (legal representative) 595017 595017 Bedill, Richard, of Inner Temple, London, esq, administrator of 0
4058956 2045598 2045598 plaintiff Cock Thomas gent 595017 595017 Cock, Thomas, of Inner Temple, London, gent 0
4059394 2045751 2045751 defendant Pytt Edward gent 595017 595017 Pytt, Edward, of Inner Temple, London, gent 0
4060757 2046253 2046253 defendant Blackwell Robert   595017 595017 Blackwell, Robert, of Inner Temple, London, gent, attorney of the bench 0
4065018 2047772 2047772 plaintiff Hare Hugh gent 595017 595017 Hare, Hugh, of Inner Temple, London, gent 0
4066829 2048436 2048436 defendant Warre Richard gent 595017 595017 Warre, Richard, of Inner Temple, London, gent 2
4067833 2048807 2048807 plaintiff Johnson William (legal representative) 595017 595017 Johnson, William, of Inner Temple, London, gent, executor of 0
4067836 2048808 2048808 plaintiff Johnson William (legal representative) 595017 595017 Johnson, William, of Inner Temple, London, gent, executor of 0
4070202 2049632 2049632 plaintiff Manwood Roger, junior gent 595017 595017 Manwood, Roger, junior, of Inner Temple, London, gent 3
4071185 2049997 2049997 defendant Bradshawe Anthony gent 595017 595017 Bradshawe, Anthony, of Inner Temple, London, gent 0
4071187 2049998 2049998 defendant Bradshawe Anthony gent 595017 595017 Bradshawe, Anthony, of Inner Temple, London, gent 0
4074080 2051023 2051023 plaintiff Puleston Edward gent 595017 595017 Puleston, Edward, of Inner Temple, London, gent 0
4074082 2051024 2051024 plaintiff Puleston Edward gent 595017 595017 Puleston, Edward, of Inner Temple, London, gent 0
4074084 2051025 2051025 plaintiff Puleston Edward gent 595017 595017 Puleston, Edward, of Inner Temple, London, gent 0
4081094 2053551 2053551 plaintiff West William gent 595017 595017 West, William, of Inner Temple, London, or of Botherham, gent 0
4095745 2058811 2058811 defendant Modlicott Richard   595017 595017 Modlicott, Richard, of Inner Temple, London, gent, clerk of Richard Love, esq, Prothonotary of the Court 0
4098008 2059616 2059616 defendant Modlicott Richard   595017 595017 Modlicott, Richard, of Inner Temple, London, gent, clerk of Richard Love, esq, Prothonotary of the Court 0
4101709 2060918 2060918 defendant Willyams William gent 595017 595017 Willyams, William, of Inner Temple, London, gent 2
4105972 2062427 2062427 defendant Nele Robert gent 595017 595017 Nele, Robert, of Inner Temple, London, gent 0
4110781 2064112 2064112 defendant Davyes Richard gent 595017 595017 Davyes, Richard, of Inner Temple, London, gent 1
4156468 2080338 2080338 defendant Marshall John gent 595017 595017 Marshall, John, of Inner Temple, London, gent 0
4166962 2083946 2083946 defendant Bawde Thomas esq 595017 595017 Bawde, Thomas, of Inner Temple, London, esq 0
4194709 2093706 2093706 defendant Nedeham George gent 595017 595017 Nedeham, George, of Inner Temple, London, gent 0
4196164 2094204 2094204 defendant Neale Robert gent 595017 595017 Neale, Robert, of Inner Temple, London, esq, or of the Savoye, Middx, gent 0
4198844 2095153 2095153 defendant Duncun Edward gent 595017 595017 Duncun, Edward, of Inner Temple, London, gent 1
4200254 2095641 2095641 defendant Barney Henry gent 595017 595017 Barney, Henry, of Inner Temple, London, gent 1
4204210 2097022 2097022 defendant Wynter Walter gent 595017 595017 Wynter, Walter, of Inner Temple, London, gent 3
4228538 2105463 2105463 defendant Hare Hugh esq 595017 595017 Hare, Hugh, of Inner Temple, London, esq 0
4235247 2107888 2107888 defendant Woodroffe David gent 595017 595017 Woodroffe, David, of Inner Temple, London, gent 0
4249818 2112922 2112922 defendant Cholmeley Nicholas gent 595017 595017 Cholmeley, Nicholas, of Inner Temple, London, gent 2
4249823 2112923 2112923 defendant Cholmeley Nicholas gent 595017 595017 Cholmeley, Nicholas, of Inner Temple, London, gent 2
4254971 2114654 2114654 defendant Grymesdiche Thomas gent 595017 595017 Grymesdiche, Thomas, of Inner Temple, London, gent 0
4263144 2117340 2117340 defendant Williams Reginald esq 595017 595017 Williams, Reginald, of Inner Temple, London, esq 0
4264564 2117791 2117791 defendant Badger Thomas gent 595017 595017 Badger, Thomas, of Inner Temple, London, gent 4
4271614 2120089 2120089 defendant Morgan Anthony esq 595017 595017 Morgan, Anthony, of Inner Temple, London, esq 1
4271617 2120090 2120090 defendant Morgan Anthony esq 595017 595017 Morgan, Anthony, of Inner Temple, London, esq 1
4300014 2130102 2130102 defendant Wysam Anthony gent 595017 595017 Wysam, Anthony, of Inner Temple, London, gent 0
4302447 2130976 2130976 defendant Savage Edward esq 595017 595017 Savage, Edward, of Inner Temple, London, esq 0
4313960 2134988 2134988 defendant Carleton Edward esq 595017 595017 Carleton, Edward, of Inner Temple, London, esq 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);