names

80 rows where place_id = 593690

✎ 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
3612951 1871697 1871697 defendant Nithgale William husbandman 593690 593690 Nithgale, William, of Shelley, husbandman 0
3612957 1871699 1871699 defendant Lughton William husbandman 593690 593690 Lughton, William, of Shelley, husbandman 0
3615750 1872566 1872566 defendant Laughton William   593690 593690 Laughton, William, of Shelley, wax chandler 3
3626444 1903126 1903126 plaintiff Aylemer Thomas esq 593690 593690 Aylemer, Thomas, of Shelley, esq 0
3627838 1903566 1903566 defendant Jenkynson John, junior yeoman 593690 593690 Jenkynson, John, junior, of Shelley, yeoman 0
3637944 1906686 1906686 defendant Lukyn Thomas husbandman 593690 593690 Lukyn, Thomas, of Shelley, husbandman 0
3682882 1920755 1920755 defendant Lokewode James tailor 593690 593690 Lokewode, James, of Shelley, tailor 2
3693251 1924099 1924099 defendant Melbourne William laborer 593690 593690 Melbourne, William, of Shelley, laborer 1
3758803 1944741 1944741 defendant Ramsey Thomas laborer 593690 593690 Ramsey, Thomas, of Shelley, laborer 2
3833697 1968468 1968468 defendant Stane Richard yeoman 593690 593690 Stane, Richard, of Shelley, yeoman 0
3979417 2017388 2017388 plaintiff Nicols Thomas yeoman 593690 593690 Nicols, Thomas, of Shelley, yeoman 0
4001882 2025447 2025447 defendant Scrivener William   593690 593690 Scrivener, William, of Shelley, ash burner 0
4001996 2025493 2025493 defendant Turnor Agnes widow 593690 593690 Turnor, Agnes, of Shelley, widow 1
4010639 2028575 2028575 defendant Lee Jasper laborer 593690 593690 Lee, Jasper, of Shelley, laborer 3
4050037 2042444 2042444 plaintiff Walmesley Robert gent 593690 593690 Walmesley, Robert, of Shelley, or of Lincolns Inn, gent 0
4138994 2074317 2074317 defendant Waspe John yeoman 593690 593690 Waspe, John, of Shelley, yeoman 3
4144720 2076314 2076314 defendant Bennett John sherman 593690 593690 Bennett, John, of Shelley, sherman 0
4176824 2087364 2087364 defendant Pickas or Pickes Lawrence husbandman 593690 593690 Pickas or Pickes, Lawrence, of Shelley, husbandman 0
4192959 2093102 2093102 defendant Isaak Ralph husbandman 593690 593690 Isaak, Ralph, of Shelley, husbandman 0
4199995 2095548 2095548 defendant Pickas Lawrence husbandman 593690 593690 Pickas, Lawrence, of Shelley, husbandman 0
4247842 2112263 2112263 defendant Dixsonne Thomas tailor 593690 593690 Dixsonne, Thomas, of Shelley, tailor 0
4304164 2131589 2131589 defendant Martyn Edmund husbandman 593690 593690 Martyn, Edmund, of Shelley, husbandman 0
4310972 2133982 2133982 defendant Skayse alias Rigg Robert yeoman 593690 593690 Skayse alias Rigg, Robert, of Shelley, yeoman 3
4343523 2145012 2145012 defendant Martyn Edmund husbandman 593690 593690 Martyn, Edmund, of Shelley, husbandman 0
4412496 2168769 2168769 defendant Reade Nicholas husbandman 593690 593690 Reade, Nicholas, of Shelley, husbandman 2
4412497 2168769 2168769 defendant Dixon Thomas tailor 593690 593690 Dixon, Thomas, of Shelley, tailor 3
4460329 2188289 2188289 defendant Cookes John   593690 593690 Cookes, John, of Shelley 0
4477073 2193486 2193486 defendant Caney Henry   593690 593690 Caney, Henry, of Shelley 0
4521115 2206944 2206944 defendant Capel John   593690 593690 Capel, John, of Shelley 0
4521120 2206945 2206945 defendant Capel Robert   593690 593690 Capel, Robert, of Shelley 0
4549306 2215724 2215724 defendant Gerveys Thomas   593690 593690 Gerveys, Thomas, of Shelley 0
4549307 2215724 2215724 defendant Humfrey John   593690 593690 Humfrey, John, of Shelley 1
4549308 2215724 2215724 defendant Plat Geoffrey   593690 593690 Plat, Geoffrey, of Shelley 2
4557610 2218315 2218315 defendant Gerveys Thomas   593690 593690 Gerveys, Thomas, of Shelley 0
4676528 2258275 2258275 plaintiff Godman Roger (legal representative) 593690 593690 Godman, Roger, of Shelley, executors of 0
4683328 2260390 2260390 defendant Goodman Roger (legal representative) 593690 593690 Goodman, Roger, of Shelley, executors of 0
4684637 2260793 2260793 defendant Cok John fuller 593690 593690 Cok, John, of Shelley, fuller 0
4749664 2280388 2280388 defendant Brigge John husbandman 593690 593690 Brigge, John, of Shelley, husbandman 1
4823833 2303535 2303535 defendant Bedell Richard husbandman 593690 593690 Bedell, Richard, of Shelley, husbandman 0
4870898 2317874 2317874 plaintiff Maryot John   593690 593690 Maryot, John, of Shelley 0
4899562 2326503 2326503 defendant Brygge Henry yeoman 593690 593690 Brygge, Henry, of Shelley, yeoman 0
4943762 2340018 2340018 defendant Dowe John cordwainer 593690 593690 Dowe, John, of Shelley, cordwainer 0
4946676 2340962 2340962 defendant Warde William yeoman 593690 593690 Warde, William, of Shelley, yeoman 1
4992587 2354666 2354666 defendant Warde William husbandman 593690 593690 Warde, William, of Shelley, husbandman 0
4992592 2354667 2354667 defendant Warde William husbandman 593690 593690 Warde, William, of Shelley, husbandman 0
5030207 2365705 2365705 defendant Dale Thomas husbandman 593690 593690 Dale, Thomas, of Shelley, husbandman 1
5041691 2369115 2369115 plaintiff Colyn John   593690 593690 Colyn, John, of Shelley, parson 0
5133938 2396423 2396423 defendant Campell Thomas husbandman 593690 593690 Campell, Thomas, of Shelley, husbandman 4
5153859 2402283 2402283 defendant Campell Thomas husbandman 593690 593690 Campell, Thomas, of Shelley, husbandman 3
5201178 2416104 2416104 defendant Warde William tailor 593690 593690 Warde, William, of Shelley, tailor 1
5246624 2429174 2429174 defendant Warde William tailor 593690 593690 Warde, William, of Shelley, tailor 2
5263332 2434280 2434280 defendant Warde William husbandman 593690 593690 Warde, William, of Shelley, husbandman 0
5274256 2437551 2437551 defendant Bevyse or Benyse Henry husbandman 593690 593690 Bevyse or Benyse, Henry, of Shelley, husbandman 0
5291229 2442438 2442438 defendant Benys or Bevys Henry husbandman 593690 593690 Benys or Bevys, Henry, of Shelley, husbandman 0
5300651 2445157 2445157 defendant Wygeyn Thomas woodman 593690 593690 Wygeyn, Thomas, of Shelley, woodman 1
5320786 2451307 2451307 plaintiff Kynge John (legal representative) 593690 593690 Kynge, John, of Shelley, or of London, grocer, executors of 0
5323035 2451967 2451967 defendant Legh Thomas gent 593690 593690 Legh, Thomas, of Shelley, gent 0
5345978 2458876 2458876 plaintiff Wygeyn Thomas   593690 593690 Wygeyn, Thomas, of Shelley 0
5378468 2468851 2468851 defendant Wygon Thomas yeoman 593690 593690 Wygon, Thomas, of Shelley, yeoman 0
5384151 2470558 2470558 defendant Beamond John husbandman 593690 593690 Beamond, John, of Shelley, husbandman 0
5384154 2470559 2470559 defendant Beamond John   593690 593690 Beamond, John, of Shelley 0
5384166 2470560 2470560 defendant Beamond John husbandman 593690 593690 Beamond, John, of Shelley, husbandman 9
5387102 2471379 2471379 defendant Houghton John husbandman 593690 593690 Houghton, John, of Shelley, husbandman 1
5393967 2473333 2473333 defendant Wygon Thomas yeoman & wood man 593690 593690 Wygon, Thomas, of Shelley, yeoman & wood man 0
5395972 2473934 2473934 defendant Beamond John husbandman 593690 593690 Beamond, John, of Shelley, husbandman 0
5395982 2473935 2473935 defendant Beamond John husbandman 593690 593690 Beamond, John, of Shelley, husbandman 7
5395993 2473936 2473936 defendant Beamond John husbandman 593690 593690 Beamond, John, of Shelley, husbandman 9
5399513 2474940 2474940 defendant Houghton John husbandman 593690 593690 Houghton, John, of Shelley, husbandman 1
5399519 2474942 2474942 defendant Houghton John husbandman 593690 593690 Houghton, John, of Shelley, husbandman 1
5407151 2477104 2477104 defendant Wygon Thomas yeoman 593690 593690 Wygon, Thomas, of Shelley, yeoman 0
5407153 2477105 2477105 defendant Wygon Thomas yeoman & woodier 593690 593690 Wygon, Thomas, of Shelley, yeoman & woodier 0
5412518 2478691 2478691 defendant Houghton John husbandman 593690 593690 Houghton, John, of Shelley, husbandman 1
5420324 2481003 2481003 defendant Wygayn Thomas yeoman 593690 593690 Wygayn, Thomas, of Shelley, yeoman 0
5422747 2481757 2481757 defendant Beamond John husbandman 593690 593690 Beamond, John, of Shelley, husbandman 0
5422759 2481758 2481758 defendant Beamond John husbandman 593690 593690 Beamond, John, of Shelley, husbandman 9
5444278 2488193 2488193 defendant Cooke William draper 593690 593690 Cooke, William, of Shelley, draper 0
5447800 2489222 2489222 defendant Danyell John, sen butcher 593690 593690 Danyell, John, sen, of Shelley, butcher 3
5488408 2501427 2501427 defendant Mannyng John husbandman 593690 593690 Mannyng, John, of Shelley, husbandman 1
5534496 2515336 2515336 plaintiff Aylemer Thomas gent 593690 593690 Aylemer, Thomas, of Shelley, gent 0
5595503 2533541 2533541 defendant Aylmer Thomas esq 593690 593690 Aylmer, Thomas, of Shelley, esq 1

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