names

112 rows where place_id = 588849

✎ 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
3595773 1866310 1866310 defendant Bange John yeoman 588849 588849 Bange, John, of North Tudenham, yeoman 0
3595775 1866311 1866311 defendant Smyth Thomas yeoman 588849 588849 Smyth, Thomas, of North Tudenham, yeoman 0
3603451 1868745 1868745 defendant Leek Walter yeoman 588849 588849 Leek, Walter, of North Tudenham, yeoman 0
3603459 1868747 1868747 defendant Smyth Thomas raffman 588849 588849 Smyth, Thomas, of North Tudenham, raffman 0
3604015 1868922 1868922 defendant Byset alias Beysert John clerk 588849 588849 Byset alias Beysert, John, of North Tudenham, clerk 0
3606606 1869740 1869740 defendant Farwell William husbandman 588849 588849 Farwell, William, of North Tudenham, husbandman 0
3608288 1870249 1870249 defendant Farwell William husbandman 588849 588849 Farwell, William, of North Tudenham, husbandman 0
3610969 1871107 1871107 defendant Leek Walter yeoman 588849 588849 Leek, Walter, of North Tudenham, yeoman 0
3619557 1873685 1873685 defendant Outhlaugh or Owtelawe John husbandman 588849 588849 Outhlaugh or Owtelawe, John, of North Tudenham, husbandman 0
3640449 1907445 1907445 defendant Vyncent Godfrey husbandman 588849 588849 Vyncent, Godfrey, of North Tudenham, husbandman 0
3648244 1909848 1909848 defendant Wolby Simon husbandman 588849 588849 Wolby, Simon, of North Tudenham, husbandman 2
3680201 1919879 1919879 defendant Vyncent Geoffrey husbandman 588849 588849 Vyncent, Geoffrey, of North Tudenham, husbandman 3
3693658 1924210 1924210 defendant Yorke Thomas   588849 588849 Yorke, Thomas, of North Tudenham, wool chapman 2
3712311 1930168 1930168 defendant Yorke Thomas husbandman 588849 588849 Yorke, Thomas, of North Tudenham, husbandman 0
3715807 1931230 1931230 defendant Burry John husbandman 588849 588849 Burry, John, of North Tudenham, husbandman 2
3720338 1932640 1932640 defendant Shaxton John yeoman 588849 588849 Shaxton, John, of North Tudenham, yeoman 1
3727468 1934868 1934868 defendant Bogge alias Yorke Thomas husbandman 588849 588849 Bogge alias Yorke, Thomas, of North Tudenham, husbandman 0
3781938 1952101 1952101 defendant Hatleese Peter husbandman 588849 588849 Hatleese, Peter, of North Tudenham, husbandman 0
3781939 1952101 1952101 defendant Bawdewen John husbandman 588849 588849 Bawdewen, John, of North Tudenham, husbandman 1
3782362 1952237 1952237 defendant Fote Alexander   588849 588849 Fote, Alexander, of North Tudenham 1
3782363 1952237 1952237 defendant Deny William husbandman 588849 588849 Deny, William, of North Tudenham, husbandman 2
3791316 1955119 1955119 plaintiff Wutton William (legal representative) 588849 588849 Wutton, William, of North Tudenham, baron of Exchecquer, executor of Southwell, Robert, executors of 0
3798623 1957477 1957477 defendant Hatleese Robert husbandman 588849 588849 Hatleese, Robert, of North Tudenham, husbandman 0
3798972 1957590 1957590 defendant Fote Alexander husbandman 588849 588849 Fote, Alexander, of North Tudenham, husbandman 3
3800900 1958190 1958190 defendant Yorke Thomas   588849 588849 Yorke, Thomas, of North Tudenham, wool chapman 1
3825103 1965721 1965721 plaintiff Wotton William (legal representative) 588849 588849 Wotton, William, of North Tudenham, Baron of Exchequer, executor of Southwell, Robert, knight, executors of 0
3825168 1965738 1965738 plaintiff Wutton William (legal representative) 588849 588849 Wutton, William, of North Tudenham, baron of Exchequer, executors of 0
3834135 1968618 1968618 defendant Groos Miles gent 588849 588849 Groos, Miles, of North Tudenham, gent 0
3848427 1973085 1973085 defendant Shetyll John   588849 588849 Shetyll, John, of North Tudenham, wool chapman or fishmonger 0
3848430 1973086 1973086 defendant Yorke Thomas   588849 588849 Yorke, Thomas, of North Tudenham, wool chapman 0
3879441 1983376 1983376 defendant Smyth Thomas husbandman 588849 588849 Smyth, Thomas, of North Tudenham, husbandman 1
3882764 1984498 1984498 defendant Gryme Edmund husbandman 588849 588849 Gryme, Edmund, of North Tudenham, husbandman 0
3882766 1984499 1984499 defendant Gryme John husbandman 588849 588849 Gryme, John, of North Tudenham, husbandman 0
3886435 1985716 1985716 defendant Cock James husbandman 588849 588849 Cock, James, of North Tudenham, husbandman 0
3893293 1987986 1987986 defendant Caly John husbandman 588849 588849 Caly, John, of North Tudenham, husbandman 1
3898043 1989553 1989553 plaintiff Yorke Thomas   588849 588849 Yorke, Thomas, of North Tudenham 0
3923406 1998135 1998135 plaintiff Smyth Thomas   588849 588849 Smyth, Thomas, of North Tudenham 0
3923407 1998135 1998135 defendant Lonsdaye John tailor 588849 588849 Lonsdaye, John, of North Tudenham, tailor 0
3923408 1998135 1998135 defendant Lylly or Lybby Mathew yeoman 588849 588849 Lylly or Lybby, Mathew, of North Tudenham, yeoman 1
3931529 2000845 2000845 defendant Marche Nicholas laborer 588849 588849 Marche, Nicholas, of North Tudenham, laborer 1
3931532 2000845 2000845 defendant Browster Robert husbandman 588849 588849 Browster, Robert, of North Tudenham, husbandman 4
3939964 2003666 2003666 defendant Hatclyff John yeoman 588849 588849 Hatclyff, John, of North Tudenham, yeoman 0
3961463 2011104 2011104 defendant Hynderwell William tailor 588849 588849 Hynderwell, William, of North Tudenham, tailor 0
4197018 2094509 2094509 defendant Brande Edmund fishmonger 588849 588849 Brande, Edmund, of North Tudenham, fishmonger 0
4213287 2100162 2100162 defendant Entwisell Lawrence husbandman 588849 588849 Entwisell, Lawrence, of North Tudenham, husbandman 1
4260193 2116373 2116373 defendant Harryson Thomas shoemaker 588849 588849 Harryson, Thomas, of North Tudenham, shoemaker 0
4709447 2268310 2268310 defendant Niche William husbandman 588849 588849 Niche, William, of North Tudenham, husbandman 0
4736190 2276454 2276454 defendant Harneys Richard (legal representative) 588849 588849 Harneys, Richard, of North Tudenham, executrix of 0
4755212 2282017 2282017 defendant Kentyng John, sen laborer 588849 588849 Kentyng, John, sen, of North Tudenham, laborer 1
4769506 2286443 2286443 defendant Harneys Richard (legal representative) 588849 588849 Harneys, Richard, of North Tudenham, executrix of 0
4783973 2290997 2290997 defendant Butiller Joan widow 588849 588849 (Butiller, Joan, of North Tudenham, widow 1
4975798 2349727 2349727 defendant Clubbe William laborer 588849 588849 Clubbe, William, of North Tudenham, laborer 1
5012220 2360423 2360423 defendant Garard Richard husbandman 588849 588849 Garard, Richard, of North Tudenham, husbandman 0
5101657 2386908 2386908 defendant Gogney William laborer 588849 588849 Gogney, William, of North Tudenham, laborer 2
5116984 2391393 2391393 defendant Gerard Richard yeoman 588849 588849 Gerard, Richard, of North Tudenham, yeoman 0
5223735 2422625 2422625 defendant Belsette John clerk 588849 588849 Belsette, John, of North Tudenham, clerk 3
5245424 2428814 2428814 defendant Broun Walter laborer 588849 588849 Broun, Walter, of North Tudenham, laborer 2
5252836 2431000 2431000 defendant Gerard Richard yeoman 588849 588849 Gerard, Richard, of North Tudenham, yeoman 0
5252838 2431000 2431000 defendant Blakhed Thomas pedder 588849 588849 Blakhed, Thomas, of North Tudenham, pedder 2
5254424 2431511 2431511 defendant Harveys William chaplain 588849 588849 Harveys, William, of North Tudenham, chaplain 0
5254425 2431511 2431511 defendant Harveys Richard yeoman 588849 588849 Harveys, Richard, of North Tudenham, yeoman 1
5254426 2431511 2431511 defendant Peyntour William husbandman 588849 588849 Peyntour, William, of North Tudenham, husbandman 2
5254430 2431511 2431511 defendant Gerard Richard (legal representative) 588849 588849 Gerard, Richard, of North Tudenham, yeoman, executors of 6
5254431 2431511 2431511 defendant Gerard Richard yeoman 588849 588849 (Gerard, Richard, of North Tudenham, yeoman 7
5264613 2434686 2434686 defendant Harveys Richard husbandman 588849 588849 Harveys, Richard, of North Tudenham, husbandman 1
5264616 2434686 2434686 defendant Gerard Richard yeoman 588849 588849 Gerard, Richard, of North Tudenham, yeoman 4
5264938 2434793 2434793 defendant Wacy William husbandman 588849 588849 Wacy, William, of North Tudenham, husbandman 2
5269223 2436104 2436104 defendant Gogeney John (legal representative) 588849 588849 Gogeney, John, of North Tudenham, husbandman, executrix of 0
5270564 2436486 2436486 defendant Harneys oor Harveys Richard husbandman 588849 588849 Harneys oor Harveys, Richard, of North Tudenham, husbandman 0
5279359 2439052 2439052 defendant Broun Walter husbandman 588849 588849 Broun, Walter, of North Tudenham, husbandman 6
5280252 2439301 2439301 defendant Lekke Walter husbandman 588849 588849 Lekke, Walter, of North Tudenham, husbandman 1
5284092 2440367 2440367 defendant Gogney Henry husbandman 588849 588849 Gogney, Henry, of North Tudenham, husbandman 0
5288554 2441670 2441670 defendant Candeler William husbandman 588849 588849 Candeler, William, of North Tudenham, husbandman 0
5308915 2447711 2447711 plaintiff Snellyng Richard   588849 588849 Snellyng, Richard, of North Tudenham 0
5308916 2447711 2447711 plaintiff Leek Walter   588849 588849 Leek, Walter, of North Tudenham 1
5312518 2448781 2448781 defendant Broun John husbandman 588849 588849 Broun, John, of North Tudenham, husbandman 3
5325898 2452831 2452831 defendant Snellyng Richard butcher 588849 588849 Snellyng, Richard, of North Tudenham, butcher 0
5333038 2454949 2454949 defendant Harneys or Harveys Richard husbandman 588849 588849 Harneys or Harveys, Richard, of North Tudenham, husbandman 1
5333618 2455128 2455128 defendant Lecke Walter husbandman 588849 588849 Lecke, Walter, of North Tudenham, husbandman 0
5337359 2456244 2456244 defendant Felawe James laborer 588849 588849 Felawe, James, of North Tudenham, laborer 0
5345815 2458831 2458831 defendant Snellyng Thomas butcher 588849 588849 Snellyng, Thomas, of North Tudenham, butcher 0
5357374 2462373 2462373 defendant Wodecroft Thomas husbandman 588849 588849 Wodecroft, Thomas, of North Tudenham, husbandman 0
5368804 2465833 2465833 defendant Brigge Robert husbandman 588849 588849 Brigge, Robert, of North Tudenham, husbandman 3
5378261 2468776 2468776 defendant Bauge John yeoman 588849 588849 Bauge, John, of North Tudenham, yeoman 0
5379996 2469330 2469330 defendant Harneys Robert husbandman 588849 588849 Harneys, Robert, of North Tudenham, husbandman 0
5379997 2469330 2469330 defendant Harneys William chaplain 588849 588849 Harneys, William, of North Tudenham, chaplain 1
5379998 2469330 2469330 defendant Blathed Thomas yeoman 588849 588849 Blathed, Thomas, of North Tudenham, yeoman 2
5380002 2469331 2469331 defendant Harneys William chaplain 588849 588849 Harneys, William, of North Tudenham, chaplain 2
5389892 2472172 2472172 defendant Vyncent John plumber 588849 588849 Vyncent, John, of North Tudenham, plumber 0
5394685 2473541 2473541 defendant Forwell William yeoman 588849 588849 Forwell, William, of North Tudenham, yeoman 12
5408807 2477595 2477595 defendant Harneys William chaplain 588849 588849 Harneys, William, of North Tudenham, chaplain 2
5440323 2487005 2487005 defendant Farwell William yeoman 588849 588849 Farwell, William, of North Tudenham, yeoman 11
5466481 2494911 2494911 defendant Harveys William chaplain 588849 588849 Harveys, William, of North Tudenham, chaplain 2
5467011 2495080 2495080 defendant Harnesse Richard husbandman 588849 588849 Harnesse, Richard, of North Tudenham, husbandman 1
5477825 2498385 2498385 defendant Harveys or Harneys William chaplain 588849 588849 Harveys or Harneys, William, of North Tudenham, chaplain 4
5484512 2500288 2500288 defendant Leek Walter husbandman 588849 588849 Leek, Walter, of North Tudenham, husbandman 0
5495772 2503630 2503630 defendant Vyncent John husbandman 588849 588849 Vyncent, John, of North Tudenham, husbandman 0
5495773 2503630 2503630 defendant Farewell William husbandman 588849 588849 Farewell, William, of North Tudenham, husbandman 1
5495774 2503630 2503630 defendant Drury Thomas thatcher 588849 588849 Drury, Thomas, of North Tudenham, thatcher 2
5505216 2506540 2506540 defendant Banges John yeoman 588849 588849 Banges, John, of North Tudenham, yeoman 3

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