names

42 rows where place_id = 593299

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3611247 1871195 1871195 defendant Boket William husbandman 593299 593299 Boket, William, of Strubby, husbandman 1
3753813 1943135 1943135 defendant Robertson Thomas husbandman 593299 593299 Robertson, Thomas, of Strubby, husbandman 0
3832271 1968007 1968007 defendant Robynson John husbandman 593299 593299 Robynson, John, of Strubby, husbandman 4
3887866 1986191 1986191 defendant Ratheby Lionel gent 593299 593299 Ratheby, Lionel, of Strubby, gent 0
4044517 2040492 2040492 plaintiff Redesby John (legal representative) 593299 593299 Redesby, John, of Strubby, yeoman, executors of 0
4044520 2040492 2040492 defendant West Thomas (legal representative) 593299 593299 West, Thomas, of Strubby, husbandman, executor of 0
4124613 2069100 2069100 defendant Watson Richard yeoman 593299 593299 Watson, Richard, of Strubby, yeoman 0
4207869 2098310 2098310 defendant Mawer Thomas husbandman 593299 593299 Mawer, Thomas, of Strubby, husbandman 0
4269214 2119296 2119296 defendant Waterhowse Edward yeoman 593299 593299 Waterhowse, Edward, of Strubby, yeoman 0
4269215 2119296 2119296 defendant Cooke Robert yeoman 593299 593299 Cooke, Robert, of Strubby, yeoman 1
4269216 2119296 2119296 defendant Waterhowse Katherine widow 593299 593299 Waterhowse, Katherine, of Strubby, widow 2
4606705 2233210 2233210 defendant Ronderby William   593299 593299 Ronderby, William, of Strubby 0
4646804 2245128 2245128 defendant Beseby John de   593299 593299 Beseby, John de, of Strubby 0
4673835 2257435 2257435 defendant Clerk John yeoman 593299 593299 Clerk, John, of Strubby, yeoman 2
4716129 2270351 2270351 plaintiff West William   593299 593299 West, William, of Strubby 0
4762322 2284198 2284198 defendant Cumberworth Thomas gent 593299 593299 Cumberworth, Thomas, of Strubby, gent 0
4762323 2284198 2284198 defendant Jakson Thomas husbandman 593299 593299 together with Jakson, Thomas, of Strubby, husbandman 1
4762325 2284199 2284199 defendant Cumberworth Thomas gent 593299 593299 Cumberworth, Thomas, of Strubby, gent 0
4762326 2284199 2284199 defendant Beseby John husbandman 593299 593299 together with Beseby, John, of Strubby, husbandman 1
4762327 2284199 2284199 defendant Roldesby John husbandman 593299 593299 Roldesby, John, of Strubby, husbandman 2
4762328 2284199 2284199 defendant Jakson Thomas husbandman 593299 593299 Jakson, Thomas, of Strubby, husbandman 3
4762329 2284199 2284199 defendant Roldesby William laborer 593299 593299 Roldesby, William, of Strubby, laborer 4
4768255 2286041 2286041 defendant Comberworth Thomas esq 593299 593299 Comberworth, Thomas, of Strubby, esq 1
4775752 2288413 2288413 defendant Hanson John laborer 593299 593299 Hanson, John, of Strubby, laborer 0
4787913 2292286 2292286 defendant Cumberworth Thomas gent 593299 593299 Cumberworth, Thomas, of Strubby, gent 0
4880512 2320817 2320817 defendant Thwede John husbandman 593299 593299 Thwede, John, of Strubby, husbandman 0
4880513 2320817 2320817 defendant Otteley John husbandman 593299 593299 Otteley, John, of Strubby, husbandman 1
4880514 2320817 2320817 defendant Jakeson Thomas husbandman 593299 593299 Jakeson, Thomas, of Strubby, husbandman 2
4880515 2320817 2320817 defendant Ibbe John husbandman 593299 593299 Ibbe, John, of Strubby, husbandman 3
4923467 2333771 2333771 plaintiff Maydenwell William   593299 593299 Maydenwell, William, of Strubby 0
4974684 2349395 2349395 defendant Ibbe Gilbert husbandman 593299 593299 Ibbe, Gilbert, of Strubby, husbandman 0
5016476 2361713 2361713 defendant Bulwyth Thomas husbandman 593299 593299 Bulwyth, Thomas, of Strubby, husbandman 4
5022111 2363359 2363359 defendant Rodesby William husbandman 593299 593299 Rodesby, William, of Strubby, husbandman 0
5154789 2402558 2402558 defendant Twede John husbandman 593299 593299 Twede, John, of Strubby, husbandman 0
5154790 2402558 2402558 defendant Roddesby William husbandman 593299 593299 Roddesby, William, of Strubby, husbandman 1
5171711 2407448 2407448 defendant Twede John husbandman 593299 593299 Twede, John, of Strubby, husbandman 0
5171712 2407448 2407448 defendant Reddesby John husbandman 593299 593299 Reddesby, John, of Strubby, husbandman 1
5189193 2412570 2412570 defendant Jakson Richard husbandman 593299 593299 Jakson, Richard, of Strubby, husbandman 2
5190407 2412941 2412941 defendant Twede John husbandman 593299 593299 Twede, John, of Strubby, husbandman 0
5190408 2412941 2412941 defendant Reddesby John husbandman 593299 593299 Reddesby, John, of Strubby, husbandman 1
5220843 2421788 2421788 defendant Jakson Richard husbndman 593299 593299 Jakson, Richard, of Strubby, husbndman 2
5488619 2501480 2501480 defendant Wilson Richard gent 593299 593299 Wilson, Richard, of Strubby, gent 1

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