names

45 rows where place_id = 601858

✎ 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
3647306 1909543 1909543 defendant Dey Nicholas husbandman 601858 601858 Dey, Nicholas, of Ilkeston, husbandman 0
3647307 1909543 1909543 defendant Rokeley John husbandman 601858 601858 Rokeley, John, of Ilkeston, husbandman 1
3647309 1909543 1909543 defendant Cooke Thomas husbandman 601858 601858 Cooke, Thomas, of Ilkeston, husbandman 3
3695980 1924982 1924982 defendant Stanley George yeoman 601858 601858 Stanley, George, of Ilkeston, yeoman 0
3756672 1944066 1944066 defendant Eyton Fulk gent 601858 601858 Eyton, Fulk, of Ilkeston, gent 0
3756673 1944066 1944066 defendant Stanley George yeoman 601858 601858 Stanley, George, of Ilkeston, yeoman 1
3756674 1944066 1944066 defendant Savage George gent 601858 601858 Savage, George, of Ilkeston, gent 2
3763908 1946354 1946354 defendant Porter James husbandman 601858 601858 Porter, James, of Ilkeston, husbandman 0
4311353 2134116 2134116 defendant Jackson Ralph yeoman 601858 601858 Jackson, Ralph, of Ilkeston, yeoman 3
4423070 2172076 2172076 plaintiff Fycyll John, senior   601858 601858 Fycyll, John, senior, of Ilkeston 0
4538152 2212217 2212217 plaintiff Thurgarton Hugh de   601858 601858 Thurgarton, Hugh de, of Ilkeston, vicar 0
4584376 2226529 2226529 plaintiff Glover Elizabeth   601858 601858 Glover, Elizabeth, of Ilkeston, formerly wife of Richard 0
4597209 2230371 2230371 defendant Cooke Ralph   601858 601858 Cooke, Ralph, of Ilkeston 0
4613503 2235241 2235241 plaintiff Clerk William   601858 601858 Clerk, William, of Ilkeston 1
4613506 2235242 2235242 plaintiff Clerk William   601858 601858 Clerk, William, of Ilkeston 1
4661285 2249350 2249350 defendant Chapman John chapman 601858 601858 Chapman, John, of Ilkeston, chapman 0
4664846 2250484 2250484 plaintiff Hayward Robert   601858 601858 Hayward, Robert, of Ilkeston 0
4687719 2261733 2261733 defendant Betonson John   601858 601858 Betonson, John, of Ilkeston, cartwright 0
4744597 2278940 2278940 defendant Godyere Robert husbandman 601858 601858 Godyere, Robert, of Ilkeston, husbandman 0
4744598 2278940 2278940 defendant Clerk Roger husbandman 601858 601858 Clerk, Roger, of Ilkeston, husbandman 1
4744599 2278940 2278940 defendant Berege Thomas husbandman 601858 601858 Berege, Thomas, of Ilkeston, husbandman 2
4744600 2278940 2278940 defendant Thomson John husbandman 601858 601858 Thomson, John, of Ilkeston, husbandman 3
4814020 2300491 2300491 defendant Bocher William weaver 601858 601858 Bocher, William, of Ilkeston, weaver 0
4817472 2301554 2301554 defendant Bentilegh Nicholas yeoman 601858 601858 Bentilegh, Nicholas, of Ilkeston, yeoman 0
4869344 2317379 2317379 defendant Bentley Nicholas yeoman 601858 601858 Bentley, Nicholas, of Ilkeston, yeoman 0
4875606 2319328 2319328 defendant Wryght John husbandman 601858 601858 Wryght, John, of Ilkeston, husbandman 3
4899443 2326467 2326467 defendant Colley Alice widow 601858 601858 Colley, Alice, of Ilkeston, widow 1
4899445 2326467 2326467 defendant Symson Richard chaplain 601858 601858 Symson, Richard, of Ilkeston, chaplain 3
4901308 2327019 2327019 defendant Walssh William chapman 601858 601858 Walssh, William, of Ilkeston, chapman 0
4906238 2328542 2328542 defendant Waiko Hugh   601858 601858 Waiko, Hugh, of Ilkeston, scythe smith 0
4912981 2330557 2330557 defendant Wragby John tailor 601858 601858 Wragby, John, of Ilkeston, tailor 1
4955919 2343737 2343737 defendant Cok John smith 601858 601858 Cok, John, of Ilkeston, smith 0
4978392 2350485 2350485 defendant Tabald William   601858 601858 Tabald, William, of Ilkeston, scythe smith 0
4984989 2352444 2352444 defendant del Mersshe Nicholas husbandman 601858 601858 del Mersshe, Nicholas, of Ilkeston, husbandman 1
4984990 2352444 2352444 defendant Saundre John husbandman 601858 601858 Saundre, John, of Ilkeston, husbandman 2
4984991 2352444 2352444 defendant Mayho Thomas husbandman 601858 601858 Mayho, Thomas, of Ilkeston, husbandman 3
4984992 2352444 2352444 defendant Vycars John husbandman 601858 601858 Vycars, John, of Ilkeston, husbandman 4
5019154 2362491 2362491 defendant Charlet Robert draper 601858 601858 Charlet, Robert, of Ilkeston, draper 0
5033469 2366672 2366672 defendant Trowell Henry   601858 601858 Trowell, Henry, of Ilkeston, mason 0
5243867 2428399 2428399 defendant Page John yeoman 601858 601858 Page, John, of Ilkeston, yeoman 0
5269659 2436237 2436237 defendant Page John yeoman 601858 601858 Page, John, of Ilkeston, yeoman 0
5269661 2436238 2436238 defendant Page John yeoman 601858 601858 Page, John, of Ilkeston, yeoman 0
5498857 2504598 2504598 defendant Bell Robert yeoman 601858 601858 Bell, Robert, of Ilkeston, yeoman 0
5498860 2504598 2504598 defendant Marshe John laborer 601858 601858 Marshe, John, of Ilkeston, laborer 3
5498861 2504598 2504598 defendant Marshe Joan widow 601858 601858 Marshe, Joan, of Ilkeston, widow 4

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