names

57 rows where place_id = 604408

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3657907 1912723 1912723 defendant Smyth William clothier 604408 604408 Smyth, William, of Guildford, Surr, clothier 0
3665014 1915003 1915003 defendant Milis Thomas   604408 604408 Milis, Thomas, of Guildford, Surr, cloth man 1
3931370 2000787 2000787 defendant Lygons William esq 604408 604408 Lygons, William, of Guildford, Surr, esq 1
4670833 2256557 2256557 defendant Gregory William chapman 604408 604408 Gregory, William, of Guildford, Surr, chapman 1
4670844 2256559 2256559 defendant Gregory William chapman 604408 604408 Gregory, William, of Guildford, Surr, chapman 0
4671235 2256658 2256658 defendant Wokkyngge William taverner 604408 604408 Wokkyngge, William, of Guildford, Surr, taverner 2
4689719 2262346 2262346 defendant Wokkynge Richard husbandman 604408 604408 (Wokkynge, Richard, of Guildford, Surr, husbandman 2
4747056 2279644 2279644 defendant Clerk Richard tailor 604408 604408 Clerk, Richard, of Guildford, Surr, tailor 0
4747058 2279645 2279645 defendant Clerk Richard tailor 604408 604408 Clerk, Richard, of Guildford, Surr, tailor 0
4749366 2280295 2280295 defendant Eton Richard husbandman 604408 604408 Eton, Richard, of Guildford, Surr, husbandman 0
4749768 2280411 2280411 defendant Mugge or Mudge Geoffrey esq 604408 604408 Mugge or Mudge, Geoffrey, of Guildford, Surr, esq 0
4812793 2300118 2300118 defendant Janyn John yeoman 604408 604408 (Janyn, John, of Guildford, Surr, yeoman 1
4818535 2301876 2301876 defendant Gregge John spicer 604408 604408 Gregge, John, of Guildford, Surr, spicer 2
4818588 2301895 2301895 defendant Gregge John spicer 604408 604408 Gregge, John, of Guildford, Surr, spicer 3
4824929 2303833 2303833 defendant Jauny John parker 604408 604408 Jauny, John, of Guildford, Surr, parker 1
4826650 2304370 2304370 defendant Syere John dyer 604408 604408 Syere, John, of Guildford, Surr, dyer 1
4826677 2304376 2304376 defendant Dyere John dyer 604408 604408 Dyere, John, of Guildford, Surr, dyer 1
4908456 2329198 2329198 defendant Heyward Henry dyer 604408 604408 Heyward, Henry, of Guildford, Surr, dyer 0
4916573 2331691 2331691 defendant Trisk William gent 604408 604408 Trisk, William, of Guildford, Surr, gent 4
5132496 2395996 2395996 defendant At Noke Richard yeoman 604408 604408 At Noke, Richard, of Guildford, Surr, yeoman 3
5132720 2396066 2396066 defendant Hunt alias Gentill Thomas ostiller 604408 604408 Hunt alias Gentill, Thomas, of Guildford, Surr, ostiller 2
5133614 2396324 2396324 defendant Russell John yeoman 604408 604408 Russell, John, of Guildford, Surr, yeoman 0
5135307 2396827 2396827 defendant Grover James chapman 604408 604408 Grover, James, of Guildford, Surr, chapman 0
5136219 2397111 2397111 defendant Grover James chapman 604408 604408 Grover, James, of Guildford, Surr, chapman 0
5136495 2397191 2397191 defendant Grover James chapman 604408 604408 Grover, James, of Guildford, Surr, chapman 0
5138045 2397632 2397632 defendant Rodes William dyer 604408 604408 Rodes, William, of Guildford, Surr, dyer 0
5143935 2399369 2399369 defendant Bedell John tailor 604408 604408 Bedell, John, of Guildford, Surr, tailor 1
5158716 2403670 2403670 defendant Rodes William dyer 604408 604408 Rodes, William, of Guildford, Surr, dyer 0
5174144 2408140 2408140 defendant Rodes William dyer 604408 604408 Rodes, William, of Guildford, Surr, dyer 0
5267813 2435695 2435695 defendant Wysbeche Richard ostler 604408 604408 Wysbeche, Richard, of Guildford, Surr, ostler 2
5270323 2436423 2436423 defendant Wysbeche Richard ostler 604408 604408 Wysbeche, Richard, of Guildford, Surr, ostler 1
5271849 2436860 2436860 defendant Playfoowe Thomas yeoman 604408 604408 Playfoowe, Thomas, of Guildford, Surr, yeoman 5
5275754 2437973 2437973 defendant Wysbeche Richard ostler 604408 604408 Wysbeche, Richard, of Guildford, Surr, ostler 2
5276959 2438341 2438341 defendant Wysbeche Richard   604408 604408 Wysbeche, Richard, of Guildford, Surr, inn holder 1
5309146 2447774 2447774 defendant Wokkyng John yeoman 604408 604408 Wokkyng, John, of Guildford, Surr, yeoman 0
5366797 2465270 2465270 defendant Haukyswode Walter baker 604408 604408 Haukyswode, Walter, of Guildford, Surr, baker 0
5383676 2470415 2470415 defendant Redknap Edmund merchant 604408 604408 Redknap, Edmund, of Guildford, Surr, merchant 1
5384144 2470556 2470556 defendant Harop Thomas pewterer 604408 604408 Harop, Thomas, of Guildford, Surr, pewterer 0
5384146 2470556 2470556 defendant George William yeoman 604408 604408 George, William, of Guildford, Surr, yeoman 2
5388087 2471653 2471653 defendant Basset Thomas esq 604408 604408 Basset, Thomas, of Guildford, Surr, esq 1
5396685 2474142 2474142 defendant George William yeoman 604408 604408 George, William, of Guildford, Surr, yeoman 1
5396687 2474143 2474143 defendant Harop Thomas pewterer 604408 604408 Harop, Thomas, of Guildford, Surr, pewterer 0
5396689 2474144 2474144 defendant Harop Thomas pewterer 604408 604408 Harop, Thomas, of Guildford, Surr, pewterer 0
5396691 2474144 2474144 defendant George William yeoman 604408 604408 George, William, of Guildford, Surr, yeoman 2
5397881 2474465 2474465 defendant George William yeoman 604408 604408 George, William, of Guildford, Surr, yeoman 1
5400723 2475269 2475269 defendant Basset Thomas esq 604408 604408 Basset, Thomas, of Guildford, Surr, esq 1
5400724 2475269 2475269 defendant Janyn Bernard gent 604408 604408 Janyn, Bernard, of Guildford, Surr, gent 2
5402806 2475880 2475880 defendant Kent Nicholas chapman 604408 604408 Kent, Nicholas, of Guildford, Surr, chapman 0
5409925 2477939 2477939 defendant George William yeoman 604408 604408 George, William, of Guildford, Surr, yeoman 0
5411125 2478284 2478284 defendant George William yeoman 604408 604408 George, William, of Guildford, Surr, yeoman 0
5421382 2481327 2481327 defendant Howler Walter yeoman 604408 604408 Howler, Walter, of Guildford, Surr, yeoman 1
5423604 2482024 2482024 defendant George William yeoman 604408 604408 George, William, of Guildford, Surr, yeoman 0
5425175 2482496 2482496 defendant George William yeoman 604408 604408 George, William, of Guildford, Surr, yeoman 0
5436853 2485952 2485952 defendant Saunder John clothman 604408 604408 Saunder, John, of Guildford, Surr, clothman 1
5437571 2486174 2486174 defendant Kyngeston Thomas yeoman 604408 604408 Kyngeston, Thomas, of Guildford, Surr, yeoman 0
5459098 2492616 2492616 defendant Normynton John gent 604408 604408 Normynton, John, of Guildford, Surr, gent 4
5476776 2498056 2498056 defendant Wysbeche Richard yeoman 604408 604408 Wysbeche, Richard, of Guildford, Surr, yeoman 2

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