names

71 rows where place_id = 593308

✎ 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
3611296 1871208 1871208 defendant Lyster Robert clerk 593308 593308 Lyster, Robert, of Redeham, clerk 0
3611297 1871208 1871208 defendant Whitton William laborer 593308 593308 Whitton, William, of Redeham, laborer 1
3611298 1871208 1871208 defendant Goneld Edmund laborer 593308 593308 Goneld, Edmund, of Redeham, laborer 2
3619150 1873593 1873593 defendant Lyster Robert clerk 593308 593308 Lyster, Robert, of Redeham, clerk 0
3619151 1873593 1873593 defendant Whitton William laborer 593308 593308 Whitton, William, of Redeham, laborer 1
3619152 1873593 1873593 defendant Goneld Edmund laborer 593308 593308 Goneld, Edmund, of Redeham, laborer 2
3733727 1936796 1936796 defendant Bodwell William tailor 593308 593308 Bodwell, William, of Redeham, tailor 4
3743586 1939870 1939870 plaintiff Rysyng William   593308 593308 Rysyng, William, of Redeham 1
3821399 1964588 1964588 defendant Stone Thomas carpenter 593308 593308 Stone, Thomas, of Redeham, carpenter 0
3852871 1974509 1974509 defendant Brome John husbandman 593308 593308 Brome, John, of Redeham, husbandman 0
3863415 1977957 1977957 defendant Barfoot John husbandman 593308 593308 Barfoot, John, of Redeham, husbandman 1
3897649 1989424 1989424 defendant Maggeson John husbandman 593308 593308 Maggeson, John, of Redeham, husbandman 0
3897653 1989425 1989425 defendant Maggeson John husbandman 593308 593308 Maggeson, John, of Redeham, husbandman 0
3901373 1990680 1990680 defendant Woodrove Thomas   593308 593308 Woodrove, Thomas, of Redeham, horse gelder 2
3908386 1993102 1993102 plaintiff Barney John esq 593308 593308 (Barney, John, of Redeham, esq 1
3914923 1995339 1995339 defendant Woderove William husbandman 593308 593308 Woderove, William, of Redeham, husbandman 0
3964985 2012359 2012359 defendant Myller Henry husbandman 593308 593308 Myller, Henry, of Redeham, husbandman 0
3968772 2013706 2013706 plaintiff Cock John (legal representative) 593308 593308 Cock, John, of Redeham, executor of 0
4085354 2055042 2055042 defendant Mares Thomas husbandman 593308 593308 Mares, Thomas, of Redeham, husbandman 2
4249774 2112906 2112906 defendant Johnes John laborer 593308 593308 Johnes, John, of Redeham, laborer 2
4324936 2138724 2138724 defendant Balles John gent 593308 593308 Balles, John, of Redeham, gent 2
4683465 2260430 2260430 defendant Gerveys John, senior esq 593308 593308 Gerveys, John, senior, of Redeham, esq 0
4683466 2260430 2260430 defendant Gerveys Thomas gent 593308 593308 Gerveys, Thomas, of Redeham, gent 1
4683467 2260430 2260430 defendant Gerveys John, junior gent 593308 593308 Gerveys, John, junior, of Redeham, gent 2
4683468 2260430 2260430 defendant Gerveys Robert gent 593308 593308 Gerveys, Robert, of Redeham, gent 3
4683469 2260430 2260430 defendant Gerveys Philip gent 593308 593308 Gerveys, Philip, of Redeham, gent 4
4897869 2325994 2325994 plaintiff Perys Edmund   593308 593308 Perys, Edmund, of Redeham 0
4916677 2331726 2331726 defendant Hardy John   593308 593308 Hardy, John, of Redeham 3
4916693 2331727 2331727 defendant Hardy John   593308 593308 Hardy, John, of Redeham 3
4961788 2345490 2345490 defendant Kirkeby Richard husbandman 593308 593308 Kirkeby, Richard, of Redeham, husbandman 3
5027506 2364923 2364923 defendant Russhemer William husbandman 593308 593308 Russhemer, William, of Redeham, husbandman 0
5115285 2390899 2390899 defendant Russhmer William husbandman 593308 593308 Russhmer, William, of Redeham, husbandman 0
5115287 2390899 2390899 defendant Swanton William husbandman 593308 593308 Swanton, William, of Redeham, husbandman 2
5156020 2402918 2402918 plaintiff Mome Richard   593308 593308 Mome, Richard, of Redeham 0
5219109 2421315 2421315 defendant Hullok Stephen husbandman 593308 593308 Hullok, Stephen, of Redeham, husbandman 0
5260602 2433449 2433449 defendant Berney John   593308 593308 Berney, John, of Redeham 0
5286581 2441086 2441086 defendant Mome Richard husbandman 593308 593308 Mome, Richard, of Redeham, husbandman 0
5299953 2444950 2444950 defendant Swanton Thomas   593308 593308 Swanton, Thomas, of Redeham, lime burner 1
5303227 2445959 2445959 defendant Whytton Nicholas yeoman 593308 593308 Whytton, Nicholas, of Redeham, yeoman 0
5303899 2446168 2446168 defendant Swanton Thomas   593308 593308 Swanton, Thomas, of Redeham, tile cutter 0
5303969 2446191 2446191 defendant Swanton William yeoman 593308 593308 Swanton, William, of Redeham, yeoman 0
5303970 2446191 2446191 defendant Preyst William husbandman 593308 593308 Preyst, William, of Redeham, husbandman 1
5303971 2446191 2446191 defendant Wilshyre James yeoman 593308 593308 Wilshyre, James, of Redeham, yeoman 2
5366993 2465324 2465324 defendant Sqanton William husbandman 593308 593308 Sqanton, William, of Redeham, husbandman 4
5373078 2467173 2467173 plaintiff Lyster Robert clerk & parson 593308 593308 Lyster, Robert, of Redeham, clerk & parson 0
5377031 2468409 2468409 plaintiff Sowele Henry   593308 593308 Sowele, Henry, of Redeham 0
5377032 2468409 2468409 defendant Smyth Richard husbandman 593308 593308 Smyth, Richard, of Redeham, husbandman 0
5389155 2471950 2471950 defendant Mome Henry husbandman 593308 593308 Mome, Henry, of Redeham, husbandman 1
5393026 2473077 2473077 plaintiff Soule Henry   593308 593308 Soule, Henry, of Redeham 0
5393027 2473077 2473077 defendant Smyth Richard husbandman 593308 593308 Smyth, Richard, of Redeham, husbandman 0
5395130 2473675 2473675 defendant Mome Henry husbandman 593308 593308 Mome, Henry, of Redeham, husbandman 1
5401866 2475600 2475600 defendant Mome Henry husbandman 593308 593308 Mome, Henry, of Redeham, husbandman 1
5406164 2476842 2476842 plaintiff Soule Henry   593308 593308 Soule, Henry, of Redeham 0
5406165 2476842 2476842 defendant Smyth Richard husbandman 593308 593308 Smyth, Richard, of Redeham, husbandman 0
5408184 2477422 2477422 defendant Whitton Nicholas yeoman 593308 593308 Whitton, Nicholas, of Redeham, yeoman 0
5411703 2478452 2478452 defendant Wylde Simon   593308 593308 Wylde, Simon, of Redeham 0
5421371 2481323 2481323 defendant Whitton Nicholas yeoman 593308 593308 Whitton, Nicholas, of Redeham, yeoman 0
5455649 2491594 2491594 defendant Smyth Richard husbandman 593308 593308 Smyth, Richard, of Redeham, husbandman 3
5460466 2493072 2493072 defendant Swethale William husbandman 593308 593308 Swethale, William, of Redeham, husbandman 2
5465939 2494739 2494739 defendant Swethale William husbandman 593308 593308 Swethale, William, of Redeham, husbandman 2
5467439 2495198 2495198 defendant Smyth Richard husbandman 593308 593308 Smyth, Richard, of Redeham, husbandman 3
5478728 2498659 2498659 defendant Smyth Richard husbandman 593308 593308 Smyth, Richard, of Redeham, husbandman 0
5506275 2506879 2506879 defendant Hyldwell Geoffrey husbandman 593308 593308 Hyldwell, Geoffrey, of Redeham, husbandman 12
5506507 2506940 2506940 defendant Swetale Nicholas husbandman 593308 593308 Swetale, Nicholas, of Redeham, husbandman 2
5514868 2509495 2509495 defendant Swethall Nicholas husbandman 593308 593308 Swethall, Nicholas, of Redeham, husbandman 0
5519517 2510946 2510946 defendant Whitton Nicholas yeoman 593308 593308 Whitton, Nicholas, of Redeham, yeoman 0
5519518 2510946 2510946 defendant Whitton Edmund laborer 593308 593308 Whitton, Edmund, of Redeham, laborer 1
5519520 2510947 2510947 defendant Whitton William husbandman 593308 593308 Whitton, William, of Redeham, husbandman 0
5535118 2515512 2515512 plaintiff Wrampyll William   593308 593308 Wrampyll, William, of Redeham 3
5542079 2517654 2517654 defendant Martyn Thomas esq 593308 593308 Martyn, Thomas, of Redeham, esq 0
5542082 2517655 2517655 defendant Martyn Thomas esq 593308 593308 Martyn, Thomas, of Redeham, esq 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);