names

122 rows where place_id = 662092

✎ 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
3963760 2011927 2011927 defendant Vaughan William gent 662092 662092 Vaughan, William, of Grays Inn, Middx, gent 0
3967424 2013239 2013239 defendant Rowse Cyriac gent 662092 662092 Rowse, Cyriac, of Grays Inn, Middx, gent 0
3979514 2017430 2017430 plaintiff Norton Walter gent 662092 662092 Norton, Walter, of Grays Inn, Middx, gent 0
3981641 2018191 2018191 plaintiff Repyngton John gent 662092 662092 Repyngton, John, of Grays Inn, Middx, gent 0
3986968 2020083 2020083 defendant Nevyll Francis gent 662092 662092 Nevyll, Francis, of Grays Inn, Middx, gent 1
3987419 2020249 2020249 plaintiff Wynnyngton Peter gent 662092 662092 Wynnyngton, Peter, of Grays Inn, Middx, gent 0
3987421 2020250 2020250 plaintiff Wynnyngton Peter gent 662092 662092 Wynnyngton, Peter, of Grays Inn, Middx, gent 0
3988745 2020721 2020721 defendant Leigh Robert gent 662092 662092 Leigh, Robert, of Grays Inn, Middx, gent 1
3989393 2020947 2020947 defendant Kewe Robert gent 662092 662092 Kewe, Robert, of Grays Inn, Middx, gent 0
3991261 2021637 2021637 defendant Purefey Humphrey gent 662092 662092 (Purefey, Humphrey, of Grays Inn, Middx, gent 1
3994903 2022929 2022929 plaintiff Cooke Richard gent 662092 662092 Cooke, Richard, of Grays Inn, Middx, gent 0
3995877 2023274 2023274 defendant Owen Hugh gent 662092 662092 Owen, Hugh, of Grays Inn, Middx, gent 0
4002380 2025626 2025626 defendant Ruse Ciriacus gent 662092 662092 Ruse, Ciriacus, of Grays Inn, Middx, gent 0
4003528 2026024 2026024 defendant Johnson Thomas gent 662092 662092 Johnson, Thomas, of Grays Inn, Middx, gent 0
4007440 2027444 2027444 plaintiff Markham Richard gent 662092 662092 Markham, Richard, of Grays Inn, Middx, gent 0
4007851 2027587 2027587 defendant Nunne James gent 662092 662092 Nunne, James, of Grays Inn, Middx, gent 1
4007857 2027588 2027588 defendant Nunne James gent 662092 662092 Nunne, James, of Grays Inn, Middx, gent 1
4007880 2027592 2027592 defendant Buttell Thomas gent 662092 662092 Buttell, Thomas, of Grays Inn, Middx, gent 2
4007888 2027593 2027593 defendant Fynes John gent 662092 662092 Fynes, John, of Grays Inn, Middx, gent 3
4007894 2027594 2027594 defendant Fynes John gent 662092 662092 Fynes, John, of Grays Inn, Middx, gent 2
4007955 2027607 2027607 defendant Buttell Thomas gent 662092 662092 Buttell, Thomas, of Grays Inn, Middx, gent 2
4013191 2029450 2029450 defendant Hill John gent 662092 662092 Hill, John, of Grays Inn, Middx, gent 1
4013646 2029618 2029618 plaintiff Rugge William esq 662092 662092 Rugge, William, of Grays Inn, Middx, esq 0
4016674 2030671 2030671 plaintiff Styward John gent 662092 662092 Styward, John, of Grays Inn, Middx, gent 0
4023322 2033050 2033050 defendant Whyskyns William esq 662092 662092 Whyskyns, William, of Grays Inn, Middx, or of Ely, Cams, esq 0
4025467 2033770 2033770 defendant Burgoyne Thomas gent 662092 662092 Burgoyne, Thomas, of Grays Inn, Middx, gent 0
4025499 2033777 2033777 defendant Burgoyne Thomas gent 662092 662092 Burgoyne, Thomas, of Grays Inn, Middx, gent 0
4030439 2035543 2035543 defendant Fyncham William gent 662092 662092 Fyncham, William, of Grays Inn, Middx, gent 2
4030444 2035544 2035544 defendant Fyncham William gent 662092 662092 Fyncham, William, of Grays Inn, Middx, gent 2
4030461 2035550 2035550 defendant Fyncham William gent 662092 662092 Fyncham, William, of Grays Inn, Middx, gent 2
4031513 2035937 2035937 defendant More Jasper gent 662092 662092 More, Jasper, of Grays Inn, Middx, gent 0
4034287 2036930 2036930 defendant Ruse Ciriac gent 662092 662092 Ruse, Ciriac, of Grays Inn, Middx, gent 0
4034324 2036946 2036946 defendant Ruse Ciriac gent 662092 662092 Ruse, Ciriac, of Grays Inn, Middx, gent 0
4040802 2039202 2039202 plaintiff Morgan Thomas gent 662092 662092 Morgan, Thomas, of Grays Inn, Middx, gent 0
4040804 2039203 2039203 plaintiff Morgan Thomas gent 662092 662092 Morgan, Thomas, of Grays Inn, Middx, gent 0
4041445 2039429 2039429 defendant Hyll John gent 662092 662092 Hyll, John, of Grays Inn, Middx, gent 1
4041448 2039430 2039430 defendant Hill John gent 662092 662092 Hill, John, of Grays Inn, Middx, gent 1
4042764 2039884 2039884 defendant Burgoyne Thomas gent 662092 662092 Burgoyne, Thomas, of Grays Inn, Middx, gent 0
4044200 2040378 2040378 plaintiff Radclyff Owen gent 662092 662092 Radclyff, Owen, of Grays Inn, Middx, gent 0
4044979 2040662 2040662 plaintiff Rolle Henry esq 662092 662092 Rolle, Henry, of Grays inn, Middx, esq 0
4052363 2043266 2043266 plaintiff Wynyngton Peter   662092 662092 Wynyngton, Peter, of Grays Inn, Middx, gent, servant to Gilbert Gerrard, esq, Attorney General 0
4052365 2043267 2043267 plaintiff Wynyngton Peter   662092 662092 Wynyngton, Peter, of Grays Inn, Middx, gent, servant to Gilbert Gerrard, esq, Attorney General to the Queen 0
4058156 2045299 2045299 plaintiff Cary Thomas esq 662092 662092 Cary, Thomas, of Grays Inn, Middx, esq 0
4058421 2045398 2045398 plaintiff Chapman Thomas gent 662092 662092 Chapman, Thomas, of Grays Inn, Middx, gent 0
4059104 2045654 2045654 plaintiff Colepepir Robert gent 662092 662092 Colepepir, Robert, of Grays Inn, Middx, gent 0
4059106 2045655 2045655 plaintiff Colepepir Robert gent 662092 662092 Colepepir, Robert, of Grays Inn, Middx, gent 0
4059112 2045657 2045657 plaintiff Colepepyr Richard gent 662092 662092 Colepepyr, Richard, of Grays Inn, Middx, gent 0
4059114 2045658 2045658 plaintiff Colepepyr Richard gent 662092 662092 Colepepyr, Richard, of Grays Inn, Middx, gent 0
4059135 2045667 2045667 defendant Gery William gent 662092 662092 Gery, William, of Grays Inn, Middx, gent 0
4061414 2046486 2046486 plaintiff Duskell Thomas gent 662092 662092 Duskell, Thomas, of Grays Inn, Middx, gent 0
4061619 2046554 2046554 defendant Hyll James gent 662092 662092 Hyll, James, of Grays Inn, Middx, gent 0
4062062 2046716 2046716 defendant Darrell Henry gent 662092 662092 Darrell, Henry, of Grays Inn, Middx, gent 0
4062066 2046718 2046718 defendant Pelham Edmund gent 662092 662092 Pelham, Edmund, of Grays Inn, Middx, gent 0
4068455 2049015 2049015 defendant Williams Robert esq 662092 662092 Williams, Robert, of Grays Inn, Middx, esq 1
4076164 2051763 2051763 plaintiff Shakerley Francis esq 662092 662092 Shakerley, Francis, of Grays Inn, Middx, esq 0
4076962 2052044 2052044 defendant Ellys Edward gent 662092 662092 Ellys, Edward, of Grays Inn, Middx, gent 0
4077789 2052350 2052350 defendant Radclyff Owen gent 662092 662092 Radclyff, Owen, of Grays Inn, Middx, gent 1
4077823 2052366 2052366 defendant Radclyf Owen gent 662092 662092 Radclyf, Owen, of Grays inn, Middx, gent 0
4077868 2052384 2052384 defendant Pott John, junior   662092 662092 Pott, John, junior, of Grays Inn, Middx, gent, his son 1
4084161 2054611 2054611 defendant Hagar John gent 662092 662092 Hagar, John, of Grays Inn, Middx, gent 0
4084602 2054769 2054769 defendant Boothe George gent 662092 662092 Boothe, George, of Grays Inn, Middx, gent 0
4090964 2057059 2057059 defendant Hill James gent 662092 662092 Hill, James, of Grays Inn, Middx, gent 0
4093453 2057977 2057977 defendant Purfrey Humphrey gent 662092 662092 Purfrey, Humphrey, of Grays Inn, Middx, gent 1
4103176 2061421 2061421 defendant Colbey Francis gent 662092 662092 Colbey, Francis, of Grays Inn, Middx, gent 2
4116797 2066304 2066304 defendant Hungaite William gent 662092 662092 Hungaite, William, of Grays Inn, Middx, gent 1
4168963 2084639 2084639 defendant Muskett Simon gent 662092 662092 Muskett, Simon, of Grays Inn, Middx, gent 0
4185318 2090375 2090375 defendant Androwes Edward gent 662092 662092 Androwes, Edward, of Grays Inn, Middx, gent 0
4210136 2099104 2099104 defendant Botyll William gent 662092 662092 Botyll, William, of Grays Inn, Middx, gent 0
4230454 2106145 2106145 defendant Crowder John gent 662092 662092 Crowder, John, of Grays Inn, Middx, gent 0
4245806 2111577 2111577 defendant Lynne William (legal representative) 662092 662092 Lynne, William, of Grays Inn, Middx, gent, executors of 1
4248771 2112576 2112576 defendant Cary Richard esq 662092 662092 Cary, Richard, of Grays Inn, Middx, esq 0
4253200 2114066 2114066 defendant Burston Richard gent 662092 662092 Burston, Richard, of Grays Inn, Middx, gent 0
4254015 2114341 2114341 defendant Nevell Peter gent 662092 662092 Nevell, Peter, of Grays Inn, Middx, gent 1
4254133 2114379 2114379 defendant Smythe Ambrose gent 662092 662092 Smythe, Ambrose, of Grays Inn, Middx, gent administrator of 2
4254361 2114454 2114454 defendant Spurlinge John esq 662092 662092 Spurlinge, John, of Grays Inn, Middx, esq 3
4254367 2114455 2114455 defendant Spurlinge John esq 662092 662092 Spurlinge, John, of Grays Inn, Middx, esq 3
4255119 2114704 2114704 defendant Wingate William gent 662092 662092 Wingate, William, of Grays Inn, Middx, gent 3
4255124 2114705 2114705 defendant Wingate William gent 662092 662092 Wingate, William, of Grays Inn, Middx, gent 3
4255819 2114921 2114921 defendant Roodes Francis gent 662092 662092 Roodes, Francis, of Grays Inn, Middx, gent 0
4257688 2115545 2115545 defendant Godfrye Owen gent 662092 662092 Godfrye, Owen, of Grays Inn, Middx, gent 0
4257761 2115568 2115568 defendant Godfrye Owen gent 662092 662092 Godfrye, Owen, of Grays Inn, Middx, gent 0
4258031 2115657 2115657 defendant Lynne William (legal representative) 662092 662092 Lynne, William, of Grays Inn, Middx, gent, executors of 1
4260838 2116588 2116588 defendant Burche Thomas gent 662092 662092 Burche, Thomas, of Grays Inn, Middx, gent 1
4260981 2116634 2116634 defendant Arderne Richard gent 662092 662092 Arderne, Richard, of Grays Inn, Middx, gent 3
4263407 2117422 2117422 defendant Carye Richard esq 662092 662092 Carye, Richard, of Grays Inn, Middx, esq 1
4264562 2117791 2117791 defendant Browne John gent 662092 662092 Browne, John, of Grays Inn, Middx, gent 2
4266998 2118604 2118604 defendant Nevell Peter gent 662092 662092 Nevell, Peter, of Grays Inn, Middx, gent 1
4268139 2118961 2118961 defendant Roodes Francis gent 662092 662092 Roodes, Francis, of Grays Inn, Middx, gent 0
4270123 2119591 2119591 defendant Ferneley John gent 662092 662092 Ferneley, John, of Grays Inn, Middx, gent 0
4272058 2120220 2120220 defendant Bruche Thomas gent 662092 662092 Bruche, Thomas, of Grays Inn, Middx, gent 1
4272169 2120257 2120257 defendant Arderne Richard gent 662092 662092 Arderne, Richard, of Grays Inn, Middx, gent 3
4280647 2123135 2123135 defendant Brantingham Elias gent 662092 662092 Brantingham, Elias, of Grays Inn, Middx, gent 2
4292813 2127493 2127493 defendant Wyllard John gent 662092 662092 Wyllard, John, of Grays Inn, Middx, gent 0
4303870 2131487 2131487 defendant Whiskyns William esq 662092 662092 Whiskyns, William, of Grays Inn, Middx, esq 0
4303898 2131497 2131497 defendant Cuddon Robert (legal representative) 662092 662092 Cuddon, Robert, of Grays Inn, Middx, gent, executors of 0
4304407 2131678 2131678 defendant Hansarde Richard gent 662092 662092 Hansarde, Richard, of Grays Inn, Middx, gent 0
4305074 2131916 2131916 defendant Jenor Francis (legal representative) 662092 662092 Jenor, Francis, of Grays Inn, Middx, gent, administratrix of 0
4310710 2133890 2133890 defendant Leigh Thomas gent 662092 662092 Leigh, Thomas, of Grays Inn, Middx, gent 0
4327049 2139379 2139379 defendant Jones Morgan gent 662092 662092 Jones, Morgan, of Grays Inn, Middx, gent 0
4329201 2140078 2140078 defendant Jenour Francis (legal representative) 662092 662092 Jenour, Francis, of Grays Inn, Middx, gent, administratrix of 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);