names

55 rows where place_id = 599956

✎ 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
3639013 1907024 1907024 defendant Reddeford John grasier 599956 599956 Reddeford, John, of Shere, grasier 0
3639014 1907024 1907024 defendant Ware John husbandman 599956 599956 Ware, John, of Shere, husbandman 1
3639015 1907024 1907024 defendant Stylwell Stephen husbandman 599956 599956 Stylwell, Stephen, of Shere, husbandman 2
3639016 1907024 1907024 defendant Gatten John husbandman 599956 599956 Gatten, John, of Shere, husbandman 3
3639017 1907024 1907024 defendant Millis John husbandman 599956 599956 Millis, John, of Shere, husbandman 4
3706396 1928289 1928289 defendant Pyttys John clerk 599956 599956 Pyttys, John, of Shere, clerk 0
3706397 1928289 1928289 defendant Whyte John husbandman 599956 599956 Whyte, John, of Shere, husbandman 1
3706398 1928289 1928289 defendant Page John tailor 599956 599956 Page, John, of Shere, tailor 2
3706399 1928289 1928289 defendant Page Richard tailor 599956 599956 Page, Richard, of Shere, tailor 3
3706401 1928290 1928290 defendant Pyttys John clerk 599956 599956 Pyttys, John, of Shere, clerk 0
3706402 1928290 1928290 defendant Whyte John husbandman 599956 599956 Whyte, John, of Shere, husbandman 1
3706403 1928290 1928290 defendant Page John tailor 599956 599956 Page, John, of Shere, tailor 2
3706404 1928290 1928290 defendant Page Richard tailor 599956 599956 Page, Richard, of Shere, tailor 3
3739191 1938474 1938474 plaintiff Parkhurst Henry   599956 599956 Parkhurst, Henry, of Shere 0
3786917 1953711 1953711 defendant Page John tailor 599956 599956 Page, John, of Shere, tailor 0
3834951 1968868 1968868 defendant Mabank Richard laborer 599956 599956 Mabank, Richard, of Shere, laborer 7
3935547 2002199 2002199 defendant Redforde George yeoman 599956 599956 Redforde, George, of Shere, yeoman 0
3937591 2002906 2002906 defendant Morer Thomas laborer 599956 599956 Morer, Thomas, of Shere, laborer 2
3937592 2002906 2002906 defendant Agas Thomas yeoman 599956 599956 Agas, Thomas, of Shere, yeoman 3
3937593 2002906 2002906 defendant Agas Richard laborer 599956 599956 Agas, Richard, of Shere, laborer 4
4068347 2048979 2048979 defendant Ridford George yeoman 599956 599956 Ridford, George, of Shere, yeoman 0
4188587 2091486 2091486 defendant de Feere Adrian   599956 599956 de Feere, Adrian, of Shere, "fyner" 2
4227144 2104971 2104971 defendant Parkehurste Edward clothier 599956 599956 Parkehurste, Edward, of Shere, clothier 0
4228415 2105420 2105420 defendant Penhurst Edward yeoman 599956 599956 Penhurst, Edward, of Shere, yeoman 0
4228974 2105616 2105616 defendant Parkehurste Edward clothier 599956 599956 Parkehurste, Edward, of Shere, clothier 0
4238213 2108974 2108974 defendant Fraunc Thomas yeoman 599956 599956 Fraunc, Thomas, of Shere, yeoman 1
4244189 2111040 2111040 defendant Parkehouse Edward clothier 599956 599956 Parkehouse, Edward, of Shere, clothier 0
4246034 2111651 2111651 defendant Parkehurst Edward clothier 599956 599956 Parkehurst, Edward, of Shere, clothier 0
4276709 2121787 2121787 defendant Mabancke John collier 599956 599956 Mabancke, John, of Shere, collier 0
4322454 2137922 2137922 defendant Lawrence Richard weaver 599956 599956 Lawrence, Richard, of Shere, weaver 2
4323513 2138284 2138284 defendant Redford John yeoman 599956 599956 Redford, John, of Shere, yeoman 0
4341335 2144245 2144245 defendant Redford John yeoman 599956 599956 Redford, John, of Shere, yeoman 0
4364946 2152516 2152516 defendant Redford John yeoman 599956 599956 Redford, John, of Shere, yeoman 0
4379851 2157894 2157894 defendant Redford John yeoman 599956 599956 Redford, John, of Shere, yeoman 0
4388288 2160713 2160713 defendant Kelsey John husbandman 599956 599956 Kelsey, John, of Shere, husbandman 0
4391617 2161812 2161812 defendant Mabancke James yeoman 599956 599956 Mabancke, James, of Shere, yeoman 0
4391618 2161812 2161812 defendant Daye Edward husbandman 599956 599956 Daye, Edward, of Shere, husbandman 1
4412489 2168767 2168767 defendant Fraunces Richard yeoman 599956 599956 Fraunces, Richard, of Shere, yeoman 0
4412491 2168768 2168768 defendant Redforde George, senior yeoman 599956 599956 Redforde, George, senior, of Shere, yeoman 0
4412492 2168768 2168768 defendant Redforde John yeoman 599956 599956 Redforde, John, of Shere, yeoman 1
4459986 2188178 2188178 plaintiff Sekyndon Robert   599956 599956 Sekyndon, Robert, of Shere, parson 0
4459988 2188178 2188178 defendant Palfrayman John   599956 599956 Palfrayman, John, of Shere 1
4490872 2197843 2197843 defendant Weston John   599956 599956 Weston, John, of Shere 0
4516133 2205458 2205458 defendant (illegible) Richard   599956 599956 _, Richard, of Shere 2
4578952 2224897 2224897 defendant Walton Richard   599956 599956 Walton, Richard, of Shere 0
4698153 2264910 2264910 defendant Eyme Nicholas laborer 599956 599956 Eyme, Nicholas, of Shere, laborer 0
4701250 2265791 2265791 defendant Clerk Richard fuller 599956 599956 Clerk, Richard, of Shere, fuller 3
4702904 2266304 2266304 defendant Kestell John clerk 599956 599956 Kestell, John, of Shere, clerk 2
4709151 2268228 2268228 defendant Virgelay John carpenter 599956 599956 Virgelay, John, of Shere, carpenter 0
4709152 2268228 2268228 defendant Eme Nicholas laborer 599956 599956 Eme, Nicholas, of Shere, laborer 1
4715613 2270208 2270208 defendant Clerk Richard yeoman 599956 599956 Clerk, Richard, of Shere, yeoman 4
4773500 2287682 2287682 defendant Wykherst Nicholas laborer 599956 599956 Wykherst, Nicholas, of Shere, laborer 1
4773501 2287682 2287682 defendant Foule John laborer 599956 599956 Foule, John, of Shere, laborer 2
5046419 2370569 2370569 defendant Ingram Thomas (legal representative) 599956 599956 Ingram, Thomas, of Shere, yeoman, executors of 0
5617649 2549348 2549348 defendant Piers Robert   599956 599956 Piers, Robert, of Shere 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);