names

85 rows where place_id = 611755

✎ 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
3689916 1923005 1923005 defendant Charleton Thomas husbandman 611755 611755 Charleton, Thomas, of Surrey, husbandman 0
3886825 1985856 1985856 plaintiff Champyon Arnold clothman 611755 611755 Champyon, Arnold, of Surrey, clothman 0
3886828 1985857 1985857 plaintiff Champyon Arnold clothman 611755 611755 Champyon, Arnold, of Surrey, clothman 0
3895348 1988651 1988651 defendant Gilbert William vintner 611755 611755 Gilbert, William, of Surrey, vintner 0
3978855 2017187 2017187 plaintiff Morgan Christopher gent 611755 611755 Morgan, Christopher, of Surrey, gent 0
4143202 2075792 2075792 defendant Knight John gent 611755 611755 Knight, John, of Knight Hill, Surrey, gent 2
4255067 2114689 2114689 defendant Stokes Richard gent 611755 611755 Stokes, Richard, of Surrey, gent 0
4263761 2117537 2117537 defendant Cornwallys Thomas esq 611755 611755 Cornwallys, Thomas, of Surrey, esq 1
4267616 2118802 2118802 defendant Stokes Richard gent 611755 611755 Stokes, Richard, of Surrey, gent 0
4437937 2181185 2181185 defendant Walsshe William   611755 611755 Walsshe, William, of Surrey 0
4448685 2184523 2184523 defendant Palfreyman John   611755 611755 Palfreyman, John, of Surrey 0
4471883 2191870 2191870 defendant Pelleham John   611755 611755 Pelleham, John, of Surrey 0
4471888 2191871 2191871 defendant Pelleham John   611755 611755 Pelleham, John, of Surrey 0
4490130 2197632 2197632 defendant Walyngford William   611755 611755 Walyngford, William, of Surrey 0
4490131 2197632 2197632 defendant Stonhous Robert   611755 611755 Stonhous, Robert, of Surrey 1
4492271 2198261 2198261 defendant Holyngbourne John   611755 611755 Holyngbourne, John, of Surrey 5
4492278 2198262 2198262 defendant Holyngbourne John   611755 611755 Holyngbourne, John, of Surrey 5
4496971 2199718 2199718 defendant Westende Walter   611755 611755 Westende, Walter, of Surrey 6
4501693 2201132 2201132 defendant Aston John   611755 611755 Aston, John, of Surrey 0
4505677 2202287 2202287 defendant atte Hacche Nicholas   611755 611755 atte Hacche, Nicholas, of Surrey 0
4505980 2202381 2202381 defendant Shall-- Thomas   611755 611755 Shall--, Thomas, of Surrey 1
4510606 2203777 2203777 defendant Shipman Thomas chapman 611755 611755 Shipman, Thomas, of Surrey, chapman 1
4510613 2203778 2203778 defendant Shopman Thomas chapman 611755 611755 Shopman, Thomas, of Surrey, chapman 1
4525127 2208202 2208202 defendant atte Seler Thomas   611755 611755 atte Seler, Thomas, of Surrey 0
4537453 2211981 2211981 defendant Brocas Thomas   611755 611755 Brocas, Thomas, of Surrey 1
4539471 2212601 2212601 plaintiff Waleys William   611755 611755 Waleys, William, of Surrey 0
4542778 2213629 2213629 defendant Dulle Richard   611755 611755 Dulle, Richard, of Surrey 0
4547289 2215086 2215086 plaintiff Burys Robert   611755 611755 Burys, Robert, of Surrey 0
4552179 2216634 2216634 defendant Fremantell John   611755 611755 Fremantell, John, of Surrey 0
4553203 2216935 2216935 defendant Bryen John esq 611755 611755 Bryen, John, of Surrey, esq 2
4556219 2217883 2217883 defendant Courtenay John esq 611755 611755 Courtenay, John, of Surrey, esq 1
4561129 2219437 2219437 defendant Preston John   611755 611755 Preston, John, of Surrey 0
4565837 2220871 2220871 defendant Martyndale John   611755 611755 Martyndale, John, of Surrey 3
4565840 2220871 2220871 defendant Neweport William   611755 611755 Neweport, William, of Surrey 6
4565844 2220872 2220872 defendant Neuport William   611755 611755 Neuport, William, of Surrey 2
4565845 2220872 2220872 defendant Martyndale John   611755 611755 Martyndale, John, of Surrey 3
4570042 2222202 2222202 defendant Merscham Hugh de   611755 611755 Merscham, Hugh de, of Surrey, quarry man 3
4572293 2222875 2222875 defendant Certeseye Nicholas de   611755 611755 Certeseye, Nicholas de, of Surrey, son of John 0
4602415 2231973 2231973 defendant Asshburnham John esq 611755 611755 Asshburnham, John, of Surrey, esq 0
4612769 2235059 2235059 defendant Mathewe Walter   611755 611755 Mathewe, Walter, of Surrey 3
4623323 2238266 2238266 defendant Kyngeston Robert   611755 611755 Kyngeston, Robert, of Surrey 0
4623487 2238321 2238321 plaintiff (not given)   prior of Merton 611755 611755 Merton, prior of, of Surrey 0
4633566 2241352 2241352 defendant Carrewe Nicholas   611755 611755 Carrewe, Nicholas, of Surrey 0
4639703 2243126 2243126 defendant Mathewe Henry   611755 611755 Mathewe, Henry, of Surrey 0
4639711 2243127 2243127 defendant Mathewe Henry   611755 611755 Mathewe, Henry, of Surrey 0
4650451 2246149 2246149 defendant Monsherst Richard   611755 611755 Monsherst, Richard, of Surrey 1
4652328 2246680 2246680 defendant Graveshende John   611755 611755 Graveshende, John, of Surrey, esq, administrators of 0
4668305 2255802 2255802 plaintiff Basset Robert   611755 611755 Basset, Robert, of Surrey, on his own account 0
4729687 2274497 2274497 plaintiff Leycestre William   611755 611755 Leycestre, William, of Surrey 0
4729688 2274497 2274497 plaintiff Lucas Thomas baker 611755 611755 Lucas, Thomas, of Surrey, baker 1
4742539 2278319 2278319 plaintiff Caxton Philip esq 611755 611755 Caxton, Philip, of Surrey, esq, on his own account 0
4762935 2284391 2284391 plaintiff Gaynesford John   611755 611755 Gaynesford, John, of Surrey 0
4786661 2291882 2291882 plaintiff Gaynesford John   611755 611755 Gaynesford, John, of Surrey 0
4804338 2297543 2297543 plaintiff Blanchard William husbandman 611755 611755 Blanchard, William, of Surrey, husbandman, on his own account 0
4923534 2333793 2333793 defendant Holbek Henry dyer 611755 611755 Holbek, Henry, of Surrey, dyer 0
4957974 2344354 2344354 plaintiff Wodecok John (legal representative) 611755 611755 Wodecok, John, of Surrey, esq, administrator of 0
4979577 2350850 2350850 defendant Burgh John (legal representative) 611755 611755 Burgh, John, of Surrey, esq, executrix of 0
5000623 2357051 2357051 plaintiff Malton John gent 611755 611755 Malton, John, of Surrey, gent 0
5043271 2369611 2369611 plaintiff fitz John John mercer 611755 611755 fitz John, John, of Surrey, mercer 0
5048203 2371093 2371093 plaintiff Radmyld Robert   611755 611755 Radmyld, Robert, of Surrey, sheriff 0
5064963 2376056 2376056 plaintiff Leycestre John   611755 611755 Leycestre, John, of Surrey 0
5064971 2376057 2376057 plaintiff Leycestre John   611755 611755 Leycestre, John, of Surrey 0
5075401 2379138 2379138 plaintiff Drax Richard   611755 611755 (Drax, Richard, of Surrey 1
5093068 2384360 2384360 defendant Longherste John husbandman 611755 611755 Longherste, John, of Surrey, husbandman 0
5130648 2395454 2395454 defendant (illegible) Alexander gent 611755 611755 --, Alexander, of Surrey, gent 0
5136510 2397193 2397193 defendant Heriette Elizabeth widow 611755 611755 Heriette, Elizabeth, of Surrey, widow 1
5188642 2412401 2412401 plaintiff Huntte Hugh   611755 611755 Huntte, Hugh, of Surrey 0
5220307 2421635 2421635 plaintiff Hunte Hugh   611755 611755 Hunte, Hugh, of Surrey 0
5269686 2436246 2436246 plaintiff Cobham Thomas   611755 611755 Cobham, Thomas, of Surrey, sheriff & knight 0
5270586 2436493 2436493 defendant Camerwell Richard yeoman 611755 611755 Camerwell, Richard, of Surrey, yeoman 1
5272892 2437146 2437146 plaintiff Lewekenor Richard esq & sheriff 611755 611755 Lewekenor, Richard, of Surrey, esq & sheriff 0
5272904 2437149 2437149 plaintiff Lewekenore Richard esq & sheriff 611755 611755 Lewekenore, Richard, of Surrey, esq & sheriff 0
5272908 2437150 2437150 plaintiff Lewekenore Richard esq & sheriffq 611755 611755 Lewekenore, Richard, of Surrey, esq & sheriffq 0
5273006 2437180 2437180 defendant Dorkyng Henry   611755 611755 Dorkyng, Henry, of Surrey 0
5391259 2472578 2472578 defendant Smalpece Robert husbandman 611755 611755 Smalpece, Robert, of Surrey, husbandman 0
5427390 2483136 2483136 plaintiff Dynham Oliver clerk & archdeacon 611755 611755 Dynham, Oliver, of Surrey, clerk & archdeacon 0
5447370 2489107 2489107 defendant Abell John gent 611755 611755 Abell, John, of Surrey, gent 1
5450409 2490010 2490010 defendant (illegible) Ralph carpenter 611755 611755 _, Ralph, of Surrey, carpenter 2
5469659 2495849 2495849 defendant (illegible) Richard yeoman 611755 611755 _, Richard, of Surrey, yeoman 2
5469660 2495849 2495849 defendant (illegible) John yeoman 611755 611755 _, John, of Surrey, yeoman 3
5515208 2509603 2509603 defendant Averey Thomas gent 611755 611755 Averey, Thomas, of Surrey, gent 0
5522126 2511734 2511734 plaintiff Cumpton Nicholas gent 611755 611755 Cumpton, Nicholas, of Surrey, gent 0
5612549 2547673 2547673 defendant Meteham Hamlin de   611755 611755 Meteham, Hamlin de, of Surrey 0
5618350 2549560 2549560 plaintiff (not given) Robert prior of Merton 611755 611755 Merton, Robert, of Surrey, prior of 0
5622924 2551104 2551104 defendant Parys John   611755 611755 Parys, John, of Surrey 0

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