names

66 rows where place_id = 599243

✎ 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
3635905 1906025 1906025 defendant Bull John husbandman 599243 599243 Bull, John, of Newyngton, husbandman 0
3641582 1907827 1907827 defendant Jose Robert smith 599243 599243 Jose, Robert, of Newyngton, smith 1
3649201 1910139 1910139 defendant Smyth John tailor 599243 599243 Smyth, John, of Newyngton, tailor 4
3670656 1916785 1916785 defendant Wylkys John husbandman 599243 599243 Wylkys, John, of Newyngton, husbandman 0
3670669 1916791 1916791 defendant Wylkys Thomas yeoman 599243 599243 Wylkys, Thomas, of Newyngton, yeoman 0
3695280 1924744 1924744 defendant Plott Thomas husbandman 599243 599243 Plott, Thomas, of Newyngton, husbandman 0
3722132 1933184 1933184 defendant Turnore William (legal representative) 599243 599243 Turnore, William, of Newyngton, tailor, executors of 3
3723831 1933732 1933732 defendant Reyley Robert shoemaker 599243 599243 Reyley, Robert, of Newyngton, shoemaker 0
3735502 1937343 1937343 defendant Fynche Lawrence   599243 599243 Fynche, Lawrence, of Newyngton, wheel wright 0
3738242 1938174 1938174 defendant Dybdale William husbandman 599243 599243 Dybdale, William, of Newyngton, husbandman 0
3739661 1938617 1938617 defendant Reyley Robert shoemaker 599243 599243 Reyley, Robert, of Newyngton, shoemaker 0
3740010 1938733 1938733 defendant Lygh George gent 599243 599243 (Lygh, George, of Newyngton, gent 2
3750296 1942010 1942010 defendant Hurst Richard husbandman 599243 599243 Hurst, Richard, of Newyngton, husbandman 0
3755503 1943676 1943676 defendant Fremlyn Thomas husbandman 599243 599243 Fremlyn, Thomas, of Newyngton, husbandman 0
3756622 1944053 1944053 defendant Worall Thomas carter 599243 599243 Worall, Thomas, of Newyngton, carter 1
3756627 1944054 1944054 defendant Worall Thomas carter 599243 599243 Worall, Thomas, of Newyngton, carter 1
3758895 1944773 1944773 defendant Burgyn Lawrence chapman 599243 599243 Burgyn, Lawrence, of Newyngton, chapman 1
3783762 1952686 1952686 defendant Hurst Richard husbandman 599243 599243 Hurst, Richard, of Newyngton, husbandman 0
3788913 1954343 1954343 defendant Drayton William innholder 599243 599243 Drayton, William, of Newyngton, innholder 3
3792926 1955642 1955642 defendant Stevynson William baker 599243 599243 Stevynson, William, of Newyngton, baker 0
3800035 1957936 1957936 defendant Schifte John mercer 599243 599243 Schifte, John, of Newyngton, mercer 1
3804746 1959431 1959431 defendant Gunnell John laborer 599243 599243 Gunnell, John, of Newyngton, laborer 0
3804970 1959498 1959498 defendant Fynche Lawtrence   599243 599243 Fynche, Lawtrence, of Newyngton, wheelwright 1
3817466 1963375 1963375 defendant Swyft John chapman 599243 599243 Swyft, John, of Newyngton, chapman 1
3817470 1963376 1963376 defendant Swyfte John chapman 599243 599243 Swyfte, John, of Newyngton, chapman 1
3819123 1963872 1963872 defendant Caym or Chaym John butcher 599243 599243 Caym or Chaym, John, of Newyngton, butcher 0
3819833 1964084 1964084 defendant Shepard William yeoman 599243 599243 Shepard, William, of Newyngton, yeoman 3
3835150 1968934 1968934 defendant Jekyll Bartholomew gent 599243 599243 Jekyll, Bartholomew, of Newyngton, gent 1
3836708 1969381 1969381 defendant Lygh George gent 599243 599243 Lygh, George, of Newyngton, gent 0
3838670 1970019 1970019 defendant Awnsell Edward yeoman 599243 599243 Awnsell, Edward, of Newyngton, yeoman 0
3838672 1970019 1970019 defendant Wheler Margaret widow 599243 599243 Wheler, Margaret, of Newyngton, widow 2
3842364 1971145 1971145 defendant Pole Robert grocer 599243 599243 Pole, Robert, of Newyngton, grocer 4
3847929 1972929 1972929 plaintiff Honywodde John   599243 599243 Honywodde, John, of Newyngton 0
3850086 1973621 1973621 defendant Butler Thomas barber 599243 599243 Butler, Thomas, of Newyngton, barber 0
3865676 1978740 1978740 defendant Haywod Robert tailor 599243 599243 Haywod, Robert, of Newyngton, tailor 0
3866494 1979022 1979022 defendant Martyn Thomas tailor 599243 599243 Martyn, Thomas, of Newyngton, tailor 0
3867544 1979381 1979381 defendant Cayme John butcher 599243 599243 Cayme, John, of Newyngton, butcher 2
3878039 1982900 1982900 defendant Webbys William husbandman 599243 599243 Webbys, William, of Newyngton, husbandman 0
3906817 1992570 1992570 defendant Kyng John tailor 599243 599243 Kyng, John, of Newyngton, tailor 0
3950196 2007153 2007153 defendant Plott George yeoman 599243 599243 Plott, George, of Newyngton, yeoman 0
3980861 2017916 2017916 defendant Hardyng John butcher 599243 599243 Hardyng, John, of Newyngton, butcher 0
4003258 2025925 2025925 plaintiff Hooke Alice widow 599243 599243 Hooke, Alice, of Newyngton, widow 0
4012887 2029337 2029337 plaintiff Reder William gent 599243 599243 Reder, William, of Newyngton, gent 0
4035547 2037382 2037382 defendant Cobham alias Broke John esq 599243 599243 Cobham alias Broke, John, of Newyngton, esq 0
4035548 2037383 2037383 plaintiff Holbrook Francis gent 599243 599243 Holbrook, Francis, of Newyngton, gent 0
4041690 2039511 2039511 plaintiff Norton Edward gent 599243 599243 Norton, Edward, of Newyngton, gent 0
4041692 2039512 2039512 plaintiff Norton Edward gent 599243 599243 Norton, Edward, of Newyngton, gent 0
4044508 2040489 2040489 defendant Surredge Geoffrey yeoman 599243 599243 Surredge, Geoffrey, of Newyngton, yeoman 0
4044509 2040489 2040489 defendant Brakenburye Thomas yeoman 599243 599243 Brakenburye, Thomas, of Newyngton, yeoman 1
4056108 2044573 2044573 plaintiff Bowden Robert yeoman 599243 599243 Bowden, Robert, of Newyngton, yeoman 0
4063292 2047165 2047165 defendant Brooke William gent 599243 599243 Brooke, William, of Newyngton, gent 0
4129500 2070855 2070855 defendant Thacher Clement yeoman 599243 599243 Thacher, Clement, of Newyngton, yeoman 0
4144019 2076071 2076071 defendant Salisburye Thomas gent 599243 599243 Salisburye, Thomas, of Newyngton, gent 0
4170903 2085310 2085310 defendant Maye William innholder 599243 599243 Maye, William, of Newyngton, innholder 0
4323226 2138183 2138183 defendant Busgate John husbandman 599243 599243 Busgate, John, of Newyngton, husbandman 0
4711727 2268989 2268989 defendant Costede John skinner 599243 599243 (Costede, John, of Newyngton, skinner 3
4916339 2331612 2331612 defendant Baldok Thomas laborer 599243 599243 Baldok, Thomas, of Newyngton, laborer 0
5057966 2373956 2373956 defendant Chapell William yeoman 599243 599243 Chapell, William, of Newyngton, yeoman 4
5270872 2436578 2436578 defendant Mason William yeoman 599243 599243 Mason, William, of Newyngton, yeoman 1
5279673 2439137 2439137 defendant Beke John yeoman 599243 599243 Beke, John, of Newyngton, yeoman 0
5279675 2439138 2439138 defendant Beke John yeoman 599243 599243 Beke, John, of Newyngton, yeoman 0
5299158 2444733 2444733 defendant Denyce Stephen husbandman 599243 599243 Denyce, Stephen, of Newyngton, husbandman 0
5329507 2453890 2453890 defendant London John glover 599243 599243 London, John, of Newyngton, glover 3
5367310 2465427 2465427 defendant Oudrey Richard tailor 599243 599243 Oudrey, Richard, of Newyngton, tailor 0
5417292 2480091 2480091 defendant Atlye Thomas   599243 599243 Atlye, Thomas, of Newyngton, iron worker 0
5532618 2514747 2514747 defendant Downe John, senior gent 599243 599243 Downe, John, senior, of Newyngton, gent 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);