names

60 rows where place_id = 622335

✎ 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
3746393 1940790 1940790 defendant Westlyn William sheather 622335 622335 Westlyn, William, of St Clement Danes without Temple Bar, sheather 0
3966521 2012924 2012924 defendant Durrant George yeoman 622335 622335 Durrant, George, of St Clement Danes without Temple Bar, yeoman 0
3980633 2017839 2017839 defendant Massye William baker 622335 622335 Massye, William, of St Clement Danes without Temple Bar, baker 0
3988189 2020523 2020523 plaintiff Androwes John tailor 622335 622335 Androwes, John, of St Clement Danes without Temple Bar, tailor 0
3988898 2020773 2020773 defendant Roper John butcher 622335 622335 Roper, John, of St Clement Danes without Temple Bar, butcher 0
4002710 2025734 2025734 plaintiff Higham John tailor 622335 622335 Higham, John, of St Clement Danes without Temple Bar, tailor 0
4002926 2025816 2025816 plaintiff Hodson William pulter 622335 622335 Hodson, William, of St Clement Danes without Temple Bar, pulter 0
4004907 2026537 2026537 plaintiff Joxe John tailor 622335 622335 Joxe, John, of St Clement Danes without Temple Bar, tailor 0
4004941 2026548 2026548 plaintiff Jurden Philip barber surgeon 622335 622335 Jurden, Philip, of St Clement Danes without Temple Bar, barber surgeon 0
4022079 2032627 2032627 plaintiff Andrewes John tailor 622335 622335 Andrewes, John, of St Clement Danes without Temple Bar, tailor 0
4022109 2032636 2032636 plaintiff Androwes John tailor 622335 622335 Androwes, John, of St Clement Danes without Temple Bar, tailor 0
4023042 2032961 2032961 defendant Capper Richard tailor 622335 622335 Capper, Richard, of St Clement Danes without Temple Bar, tailor 0
4023047 2032962 2032962 defendant Capper Richard tailor 622335 622335 Capper, Richard, of St Clement Danes without Temple Bar, tailor 0
4023514 2033119 2033119 plaintiff Base Henry butcher 622335 622335 Base, Henry, of St Clement Danes without Temple Bar, butcher 0
4031497 2035932 2035932 plaintiff Fletcher William cooper 622335 622335 Fletcher, William, of St Clement Danes without Temple Bar, cooper 0
4033002 2036454 2036454 plaintiff Godlad or Goodeladde Henry hosier 622335 622335 Godlad or Goodeladde, Henry, of St Clement Danes without Temple Bar, hosier 0
4033109 2036493 2036493 plaintiff Goodlade Henry tailor 622335 622335 Goodlade, Henry, of St Clement Danes without Temple Bar, tailor 0
4033507 2036642 2036642 plaintiff Grene William cordwainer 622335 622335 Grene, William, of St Clement Danes without Temple Bar, cordwainer 0
4035326 2037308 2037308 plaintiff Higham John tailor 622335 622335 Higham, John, of St Clement Danes without Temple Bar, tailor 0
4036365 2037691 2037691 plaintiff Humfrey Christopher tailor 622335 622335 Humfrey, Christopher, of St Clement Danes without Temple Bar, tailor 0
4036368 2037692 2037692 plaintiff Humfrey Christopher tailor 622335 622335 Humfrey, Christopher, of St Clement Danes without Temple Bar, tailor 0
4036371 2037693 2037693 plaintiff Humfrey Christopher tailor 622335 622335 Humfrey, Christopher, of St Clement Danes without Temple Bar, tailor 0
4036375 2037694 2037694 plaintiff Humfrey Christopher tailor 622335 622335 Humfrey, Christopher, of St Clement Danes without Temple Bar, tailor 0
4036817 2037853 2037853 plaintiff Jackson Ingraham innholder 622335 622335 Jackson, Ingraham, of St Clement Danes without Temple Bar, innholder 0
4037669 2038123 2038123 plaintiff Kilvard or Gylforde Thomas (legal representative) 622335 622335 Kilvard or Gylforde, Thomas, of St Clement Danes without Temple bar, innholder, executrix of 0
4037672 2038124 2038124 plaintiff Kilvarde Thomas (legal representative) 622335 622335 Kilvarde, Thomas, of St Clement Danes without Temple Bar, innholer, executrix of 0
4040811 2039206 2039206 plaintiff Moringe Thomas butcher 622335 622335 Moringe, Thomas, of St Clement Danes without Temple Bar, butcher 0
4040813 2039207 2039207 plaintiff Moringe Thomas butcher 622335 622335 Moringe, Thomas, of St Clement Danes without Temple Bar, butcher 0
4041810 2039552 2039552 plaintiff Nycholl Benedict cutler 622335 622335 Nycholl, Benedict, of St Clement Danes without Temple Bar, cutler 0
4042662 2039851 2039851 plaintiff Payne John (legal representative) 622335 622335 Payne, John, of St Clement Danes without Temple Bar, esq, executors of 0
4046869 2041333 2041333 plaintiff Somerforde Miles draper 622335 622335 Somerforde, Miles, of St Clement Danes without Temple Bar, draper 0
4051384 2042916 2042916 plaintiff Wild Denise widow 622335 622335 Wild, Denise, of St Clement Danes without Temple Bar, widow 1
4055732 2044437 2044437 defendant Prewen Ralph grocer 622335 622335 Prewen, Ralph, of St Clement Danes without Temple Bar, or of Newark, Nhants, grocer 0
4056071 2044558 2044558 plaintiff Boulton Henry   622335 622335 Boulton, Henry, of St Clement Danes without Temple Bar 0
4064003 2047408 2047408 defendant Denham Richard chandler 622335 622335 Denham, Richard, of St Clement Danes without Temple Bar, chandler 0
4065998 2048128 2048128 plaintiff Higham John tailor 622335 622335 Higham, John, of St Clement Danes without Temple Bar, tailor 0
4066066 2048152 2048152 plaintiff Hill William   622335 622335 Hill, William, of St Clement Danes without Temple Bar, purse maker 0
4123262 2068622 2068622 defendant Hardye John glover 622335 622335 Hardye, John, of St Clement Danes without Temple Bar, glover 0
4123926 2068856 2068856 defendant Warren Edward butcher 622335 622335 Warren, Edward, of St Clement Danes without Temple Bar, butcher 0
4124879 2069190 2069190 defendant ap Powell David tailor 622335 622335 ap Powell, David, of St Clement Danes without Temple Bar, tailor 0
4131043 2071418 2071418 defendant Dolley Andrew yeoman 622335 622335 Dolley, Andrew, of St Clement Danes without Temple Bar, yeoman 1
4141017 2075016 2075016 defendant Gardener Walter gent 622335 622335 Gardener, Walter, of St Clement Danes without Temple Bar, gent 0
4144120 2076105 2076105 defendant Garrard William, senior gent 622335 622335 Garrard, William, senior, of St Clement Danes without Temple Bar, gent 0
4165227 2083347 2083347 defendant Linney or Lumey John   622335 622335 Linney or Lumey, John, of St Clement Danes without Temple Bar, Middx, taulor 1
4166887 2083911 2083911 defendant Wayle Humphrey gent 622335 622335 Wayle, Humphrey, of St Clement Danes without Temple Bar, gent 0
4180610 2088702 2088702 defendant Higham John tailor 622335 622335 Higham, John, of St Clement Danes without Temple Bar, tailor 1
4180754 2088749 2088749 defendant Gomersall Richard mercer 622335 622335 Gomersall, Richard, of St Clement Danes without Temple Bar, mercer 0
4191483 2092588 2092588 defendant Ellys Thomas shoemaker 622335 622335 Ellys, Thomas, of St Clement Danes without Temple Bar, shoemaker 2
4199731 2095453 2095453 defendant Cooke Robert gent 622335 622335 Cooke, Robert, of St Clement Danes without Temple Bar, gent 0
4207421 2098148 2098148 defendant Somerforde John yeoman 622335 622335 Somerforde, John, of St Clement Danes without Temple Bar, yeoman 0
4208134 2098400 2098400 defendant Hamonde Simon shoemaker 622335 622335 Hamonde, Simon, of St Clement Danes without Temple Bar, shoemaker 1
4226284 2104664 2104664 defendant Thomas Robert tailor 622335 622335 Thomas, Robert, of St Clement Danes without Temple Bar, tailor 1
4244310 2111081 2111081 defendant Yonge William   622335 622335 Yonge, William, of St Clement Danes without Temple Bar, Middx, barbor 4
4253476 2114154 2114154 defendant Reddyche Robert   622335 622335 Reddyche, Robert, of St Clement Danes without Temple Bar, tailor, administrators of 0
4254285 2114433 2114433 defendant Baker Humphrey tailor 622335 622335 Baker, Humphrey, of St Clement Danes without Temple Bar, tailor 1
4254289 2114434 2114434 defendant Baker Humphrey tailor 622335 622335 Baker, Humphrey, of St Clement Danes without Temple Bar, tailor 1
4255499 2114830 2114830 defendant Yoounge William barber 622335 622335 Yoounge, William, of St Clement Danes without Temple Bar, barber 4
4353081 2148306 2148306 defendant Hope Richard gent 622335 622335 Hope, Richard, of St Clement Danes without Temple Bar, gent 0
4655453 2247601 2247601 plaintiff Broun Robert carver 622335 622335 Broun, Robert, of St Clement Danes without Temple Bar, carver 0
4655455 2247602 2247602 plaintiff Broun Robert carver 622335 622335 Broun, Robert, of St Clement Danes without Temple Bar, carver 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);