names

66 rows where place_id = 585886

✎ 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
3587418 1863710 1863710 defendant Mugge Walter gent 585886 585886 Mugge, Walter, of Guldeford, Surrey, gent 0
3587422 1863711 1863711 defendant Mugge Walter gent 585886 585886 Mugge, Walter, of Guldeford, Surrey, gent 0
3594620 1865947 1865947 defendant Basset Thomas, senior esq 585886 585886 Basset, Thomas, senior, of Guldeford, Surrey, esq 2
3631540 1904680 1904680 defendant Aldey Thomas glover 585886 585886 Aldey, Thomas, of Guldeford, Surrey, glover 2
3675707 1918435 1918435 defendant Stangar James innholder 585886 585886 Stangar, James, of Guldeford, Surrey, innholder 0
3768225 1947700 1947700 defendant Sounde Geoffrey dyer 585886 585886 Sounde, Geoffrey, of Guldeford, Surrey, dyer 2
3773290 1949355 1949355 defendant Ellyot John dyer 585886 585886 Ellyot, John, of Guldeford, Surrey, dyer 1
3791095 1955049 1955049 defendant Ellyott John dyer 585886 585886 Ellyott, John, of Guldeford, Surrey, dyer 0
3801508 1958384 1958384 defendant Browne Lucy widow 585886 585886 Browne, Lucy, of Guldeford, Surrey, widow 0
3801977 1958513 1958513 defendant Glover Walter mercer 585886 585886 Glover, Walter, of Guldeford, Surrey, mercer 0
3801988 1958516 1958516 defendant Glover Walter mercer 585886 585886 Glover, Walter, of Guldeford, Surrey, mercer 0
3818980 1963830 1963830 defendant Browne Lucy widow 585886 585886 Browne, Lucy, of Guldeford, Surrey, widow 0
3872854 1981135 1981135 defendant Roomffe Robert merchant 585886 585886 Roomffe, Robert, of Guldeford, Surrey, merchant 0
3917677 1996269 1996269 plaintiff Hamond William clothman 585886 585886 Hamond, William, of Guldeford, Surrey, clothman 0
3922620 1997881 1997881 defendant Rumpe Joan widow 585886 585886 Rumpe, Joan, of Guldeford, Surrey, widow 0
4065596 2047986 2047986 defendant Bab Henry chapman 585886 585886 Bab, Henry, of Guldeford, Surrey, chapman 0
4110682 2064078 2064078 defendant Coxe John clothier 585886 585886 Coxe, John, of Guldeford, Surrey, clothier 0
4303371 2131305 2131305 defendant Lovedall Thomas clothier 585886 585886 Lovedall, Thomas, of Guldeford, Surrey, clothier 0
4721176 2271956 2271956 defendant Wokkyng Richard merchant 585886 585886 Wokkyng, Richard, of Guldeford, Surrey, merchant 0
4858269 2313959 2313959 defendant Mace or Mate Henry dyer 585886 585886 Mace or Mate, Henry, of Guldeford, Surrey, dyer 0
4890572 2323810 2323810 defendant Hayward Henry dyer 585886 585886 Hayward, Henry, of Guldeford, Surrey, dyer 2
4897274 2325806 2325806 defendant Hayward Henry dyer 585886 585886 Hayward, Henry, of Guldeford, Surrey, dyer 2
4934418 2337155 2337155 defendant FitzJohn Nicholas esq 585886 585886 FitzJohn, Nicholas, of Guldeford, Surrey, esq 0
4934420 2337156 2337156 defendant FitzJohn Nicholas esq 585886 585886 FitzJohn, Nicholas, of Guldeford, Surrey, esq 0
4934574 2337206 2337206 defendant Eton Richard gent 585886 585886 Eton, Richard, of Guldeford, Surrey, gent 3
4937741 2338183 2338183 defendant Helyer John helyer or roofer 585886 585886 Helyer, John, of Guldeford, Surrey, helyer or roofer 0
4973145 2348901 2348901 defendant Buntyng John husbandman 585886 585886 Buntyng, John, of Guldeford, Surrey, husbandman 0
4976578 2349955 2349955 defendant Kyngesdoune John yeoman 585886 585886 Kyngesdoune, John, of Guldeford, Surrey, yeoman 4
4979493 2350823 2350823 defendant Upton John butcher 585886 585886 Upton, John, of Guldeford, Surrey, butcher 1
5022830 2363588 2363588 defendant Thirske William gent 585886 585886 Thirske, William, of Guldeford, Surrey, gent 0
5059949 2374540 2374540 defendant FitzJohn John chapman 585886 585886 FitzJohn, John, of Guldeford, Surrey, chapman 0
5071125 2377857 2377857 defendant Preston John butcher 585886 585886 Preston, John, of Guldeford, Surrey, butcher 0
5075431 2379145 2379145 defendant Mundy John yeoman 585886 585886 Mundy, John, of Guldeford, Surrey, yeoman 0
5075433 2379146 2379146 defendant Mundy John yeoman 585886 585886 Mundy, John, of Guldeford, Surrey, yeoman 0
5088941 2383141 2383141 defendant Rypon John yeoman 585886 585886 Rypon, John, of Guldeford, Surrey, yeoman 0
5096600 2385439 2385439 defendant Edyndon John barber 585886 585886 Edyndon, John, of Guldeford, Surrey, barber 2
5096602 2385440 2385440 defendant Mundy John chapman 585886 585886 Mundy, John, of Guldeford, Surrey, chapman 0
5103434 2387430 2387430 defendant Perkyn Thomas baker 585886 585886 Perkyn, Thomas, of Guldeford, Surrey, baker 0
5110085 2389364 2389364 defendant Grover James chapman 585886 585886 Grover, James, of Guldeford, Surrey, chapman 0
5110091 2389365 2389365 defendant Grover James chapman 585886 585886 Grover, James, of Guldeford, Surrey, chapman 0
5116883 2391365 2391365 defendant Russell John merchant 585886 585886 Russell, John, of Guldeford, Surrey, merchant 3
5116906 2391371 2391371 defendant Russell John merchant 585886 585886 Russell, John, of Guldeford, Surrey, merchant 3
5121376 2392684 2392684 defendant Wodeward alias Shawe John ostler 585886 585886 Wodeward alias Shawe, John, of Guldeford, Surrey, ostler 0
5121380 2392685 2392685 defendant Wodeward alias Shawe John ostler 585886 585886 Wodeward alias Shawe, John, of Guldeford, Surrey, ostler 0
5153130 2402056 2402056 defendant Hunt Thomas ostler 585886 585886 Hunt, Thomas, of Guldeford, Surrey, ostler 1
5233625 2425424 2425424 defendant Bassett Thomas esq 585886 585886 Bassett, Thomas, of Guldeford, Surrey, esq 0
5248121 2429586 2429586 defendant Hilton Hugh yeoman 585886 585886 Hilton, Hugh, of Guldeford, Surrey, yeoman 0
5254139 2431416 2431416 defendant Kynston Thomas ostler 585886 585886 Kynston, Thomas, of Guldeford, Surrey, ostler 1
5254142 2431417 2431417 defendant Kynston Thomas ostler 585886 585886 Kynston, Thomas, of Guldeford, Surrey, ostler 1
5255397 2431805 2431805 defendant Perversh John tailor 585886 585886 Perversh, John, of Guldeford, Surrey, tailor 0
5256050 2432017 2432017 defendant Twychener William husbandman 585886 585886 Twychener, William, of Guldeford, Surrey, husbandman 0
5256320 2432096 2432096 defendant Wokkyng John yeoman 585886 585886 Wokkyng, John, of Guldeford, Surrey, yeoman 2
5258909 2432904 2432904 defendant Hylton Hugh yeoman 585886 585886 Hylton, Hugh, of Guldeford, Surrey, yeoman 0
5283998 2440344 2440344 defendant Basset Reginald clerk 585886 585886 Basset, Reginald, of Guldeford, Surrey, clerk 0
5284002 2440345 2440345 defendant Basset Thomas esq 585886 585886 Basset, Thomas, of Guldeford, Surrey, esq 0
5284981 2440630 2440630 defendant Kyngeston Thomas yeoman 585886 585886 Kyngeston, Thomas, of Guldeford, Surrey, yeoman 0
5287509 2441370 2441370 defendant Basset Thomas esq 585886 585886 Basset, Thomas, of Guldeford, Surrey, esq 0
5287515 2441372 2441372 defendant Janyn Barnard gent 585886 585886 Janyn, Barnard, of Guldeford, Surrey, gent 1
5290712 2442286 2442286 defendant Butte John chapman 585886 585886 Butte, John, of Guldeford, Surrey, chapman 0
5334367 2455348 2455348 defendant Haller Walter hosier 585886 585886 Haller, Walter, of Guldeford, Surrey, hosier 4
5348158 2459567 2459567 defendant Mogge Thomas yeoman 585886 585886 Mogge, Thomas, of Guldeford, Surrey, yeoman 2
5361785 2463715 2463715 defendant Butte John chapman 585886 585886 Butte, John, of Guldeford, Surrey, chapman 4
5540628 2517193 2517193 defendant Oldham George yeoman 585886 585886 Oldham, George, of Guldeford, Surrey, yeoman 1
5541363 2517414 2517414 defendant Marchall Robert dyer 585886 585886 Marchall, Robert, of Guldeford, Surrey, dyer 2
5586282 2530751 2530751 defendant Mugge Daniel gent 585886 585886 Mugge, Daniel, of Guldeford, Surrey, gent 1
5599333 2534674 2534674 defendant Southwod John clerk 585886 585886 Southwod, John, of Guldeford, Surrey, clerk 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);