names

29 rows where place_id = 603439

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: case_id, role, surname, forename, occupation, raw_segment, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3654542 1911682 1911682 plaintiff Bagore Thomas yeoman 603439 603439 Bagore, Thomas, of Corley, yeoman 0
3727757 1934951 1934951 defendant Barre John husbandman 603439 603439 Barre, John, of Corley, husbandman 0
3862053 1977496 1977496 defendant Shepard Richard husbandman 603439 603439 Shepard, Richard, of Corley, husbandman 1
3929236 2000122 2000122 defendant Bagger Katherine spinster 603439 603439 Bagger, Katherine, of Corley, spinster 0
4003133 2025880 2025880 defendant Hatton Thomas yeoman 603439 603439 Hatton, Thomas, of Corley, yeoman 0
4028775 2034940 2034940 plaintiff Cowngley George   603439 603439 Cowngley, George, of Corley 0
4028777 2034941 2034941 plaintiff Cowngley George   603439 603439 Cowngley, George, of Corley 0
4169139 2084707 2084707 defendant Jones Geoffrey clerk 603439 603439 Jones, Geoffrey, of Corley, clerk 0
4213391 2100201 2100201 defendant Barr Michael yeoman 603439 603439 Barr, Michael, of Corley, yeoman 1
4215467 2100904 2100904 defendant Holbache Thomas yeoman 603439 603439 Holbache, Thomas, of Corley, yeoman 0
4215648 2100972 2100972 defendant Mathoes John husbandman 603439 603439 Mathoes, John, of Corley, husbandman 1
4369338 2154099 2154099 defendant Pachett John yeoman 603439 603439 Pachett, John, of Corley, yeoman 0
4369340 2154099 2154099 defendant Jurden Thomas husbandman 603439 603439 Jurden, Thomas, of Corley, husbandman 2
4549215 2215695 2215695 defendant Marchall Henry   603439 603439 Marchall, Henry, of Corley 0
4549217 2215696 2215696 defendant Marchall John   603439 603439 Marchall, John, of Corley, son of Henry 0
4549839 2215884 2215884 defendant Marchall John   603439 603439 Marchall, John, of Corley 0
4557081 2218142 2218142 defendant Marssal John   603439 603439 Marssal, John, of Corley, son of Henry 0
4557082 2218142 2218142 defendant Mars_ Henry   603439 603439 Mars_, Henry, of Corley 1
4680284 2259448 2259448 defendant Spenser Richard widow & formerly wife of Testator 603439 603439 Spenser, Richard, of Corley, husbandman, Spenser, Joan, of Corley, widow & formerly wife of Testator 1
4726442 2273553 2273553 defendant (not given) Nicholas vicar of Harpham 603439 603439 Harpham, Nicholas, of Corley, vicar, formerly vicar of Elsham 0
4836748 2307461 2307461 defendant Falk Richard husbandman 603439 603439 Falk, Richard, of Corley, husbandman 0
5156228 2402983 2402983 defendant Poley William husbandman 603439 603439 Poley, William, of Corley, husbandman 0
5156271 2402989 2402989 defendant Poley William husbandman 603439 603439 Poley, William, of Corley, husbandman 0
5172505 2407684 2407684 defendant Poley William husbandman 603439 603439 Poley, William, of Corley, husbandman 0
5191989 2413387 2413387 defendant Poley William husbandman 603439 603439 Poley, William, of Corley, husbandman 0
5270886 2436581 2436581 defendant Falke Mathew husbandman 603439 603439 Falke, Mathew, of Corley, husbandman 3
5283763 2440293 2440293 defendant Falke Mathew husbandman 603439 603439 Falke, Mathew, of Corley, husbandman 4
5417219 2480063 2480063 defendant Wheytman Henrym husbandman 603439 603439 Wheytman, Henrym, of Corley, husbandman 0
5589907 2531828 2531828 defendant Smyth Ralph smith 603439 603439 Smyth, Ralph, of Corley, smith 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);