names

55 rows where place_id = 586291

✎ 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
3588368 1864013 1864013 plaintiff Bell Richard   586291 586291 Bell, Richard, of Fulstowe 0
3609370 1870589 1870589 defendant Rodes John yeoman 586291 586291 Rodes, John, of Fulstowe, yeoman 3
3611836 1871361 1871361 defendant Milner William miller 586291 586291 Milner, William, of Fulstowe, miller 1
3622800 1874662 1874662 defendant Bell Robert husbandman 586291 586291 Bell, Robert, of Fulstowe, husbandman 0
3634835 1905695 1905695 defendant Redmere Walter yeoman 586291 586291 Redmere, Walter, of Fulstowe, yeoman 1
3685937 1921759 1921759 defendant Redmayn Walter yeoman 586291 586291 Redmayn, Walter, of Fulstowe, yeoman 0
3690903 1923318 1923318 defendant Redmayn Walter yeoman 586291 586291 Redmayn, Walter, of Fulstowe, yeoman 2
3721095 1932895 1932895 defendant Redmar alias Redman Walter yeoman 586291 586291 Redmar alias Redman, Walter, of Fulstowe, yeoman 0
3771140 1948663 1948663 defendant Swyne Alan husbandman 586291 586291 Swyne, Alan, of Fulstowe, husbandman 4
3805290 1959601 1959601 defendant Swyne John husbandman 586291 586291 Swyne, John, of Fulstowe, husbandman 0
3805291 1959601 1959601 defendant Wakerley Henry husbandman 586291 586291 Wakerley, Henry, of Fulstowe, husbandman 1
3805292 1959601 1959601 defendant Swyne William husbandman 586291 586291 Swyne, William, of Fulstowe, husbandman 2
3805293 1959601 1959601 defendant Marchaunt William laborer 586291 586291 Marchaunt, William, of Fulstowe, laborer 3
3805294 1959601 1959601 defendant Fawconer Christopher husbandman 586291 586291 Fawconer, Christopher, of Fulstowe, husbandman 4
3805295 1959601 1959601 defendant Ravensey Robert husbandman 586291 586291 Ravensey, Robert, of Fulstowe, husbandman 5
3826909 1966266 1966266 defendant Redman Walter yeoman 586291 586291 Redman, Walter, of Fulstowe, yeoman 2
3872224 1980938 1980938 defendant Swyne Alan salter 586291 586291 Swyne, Alan, of Fulstowe, salter 3
3872248 1980942 1980942 defendant Swyne Alan salter 586291 586291 Swyne, Alan, of Fulstowe, salter 4
3878221 1982964 1982964 defendant Bracebryg Robert husbandman 586291 586291 Bracebryg, Robert, of Fulstowe, husbandman 0
3966799 2013024 2013024 defendant Hollye John husbandman 586291 586291 Hollye, John, of Fulstowe, husbandman 0
4129547 2070871 2070871 defendant May Richard laborer 586291 586291 May, Richard, of Fulstowe, laborer 1
4152937 2079133 2079133 defendant May Richard laborer 586291 586291 May, Richard, of Fulstowe, laborer 1
4170059 2085022 2085022 defendant Smyth William husbandman 586291 586291 Smyth, William, of Fulstowe, husbandman 1
4193388 2093255 2093255 defendant Smyth William husbandman 586291 586291 Smyth, William, of Fulstowe, husbandman 1
4232459 2106861 2106861 defendant Wooer William laborer 586291 586291 Wooer, William, of Fulstowe, laborer 1
4232460 2106861 2106861 defendant Parker William brewer 586291 586291 Parker, William, of Fulstowe, laborer, brewer 2
4247127 2112013 2112013 defendant Woer William yeoman 586291 586291 (Woer, William, of Fulstowe, yeoman 1
4253837 2114280 2114280 defendant Woower William maltster 586291 586291 Woower, William, of Fulstowe, laborer, maltster 0
4260543 2116492 2116492 defendant Woer William yeoman 586291 586291 (Woer, William, of Fulstowe, yeoman 1
4274168 2120909 2120909 defendant Leycon John gent 586291 586291 Leycon, John, of Fulstowe, gent 0
4277686 2122120 2122120 defendant Stringer Thomas husbandman 586291 586291 Stringer, Thomas, of Fulstowe, husbandman 0
4339675 2143648 2143648 defendant Lacon John gent 586291 586291 Lacon, John, of Fulstowe, gent 0
4341085 2144154 2144154 defendant Lacon John gent 586291 586291 Lacon, John, of Fulstowe, gent 0
4362981 2151823 2151823 defendant Laycon John gent 586291 586291 Laycon, John, of Fulstowe, gent 0
4368424 2153751 2153751 defendant Fanthorpe William husbandman 586291 586291 Fanthorpe, William, of Fulstowe, husbandman 1
4937877 2338227 2338227 defendant Mumby Thomas husbandman 586291 586291 Mumby, Thomas, of Fulstowe, husbandman 0
5025490 2364356 2364356 defendant Frend John husbandman 586291 586291 Frend, John, of Fulstowe, husbandman 1
5066831 2376608 2376608 defendant Mumby William husbandman 586291 586291 Mumby, William, of Fulstowe, husbandman 0
5066832 2376608 2376608 defendant Pynder Richard husbandman 586291 586291 Pynder, Richard, of Fulstowe, husbandman 1
5070970 2377808 2377808 defendant Belle Richard husbandman 586291 586291 Belle, Richard, of Fulstowe, husbandman 7
5197672 2415058 2415058 defendant Palmer John husbandman 586291 586291 Palmer, John, of Fulstowe, husbandman 1
5197673 2415058 2415058 defendant Hobulday John husbandman 586291 586291 Hobulday, John, of Fulstowe, husbandman 2
5308757 2447658 2447658 defendant Edward Robert husbandman 586291 586291 Edward, Robert, of Fulstowe, husbandman 0
5320951 2451356 2451356 defendant Swyne alias Salter Thomas husbandman 586291 586291 Swyne alias Salter, Thomas, of Fulstowe, husbandman 0
5352248 2460801 2460801 defendant Hyrne Roger husbandman 586291 586291 Hyrne, Roger, of Fulstowe, husbandman 2
5355560 2461809 2461809 defendant Hyrne Robert smith 586291 586291 Hyrne, Robert, of Fulstowe, smith 3
5377346 2468505 2468505 defendant Edward Robert husbandman 586291 586291 Edward, Robert, of Fulstowe, husbandman 2
5380783 2469558 2469558 defendant Scotte Robert salter 586291 586291 Scotte, Robert, of Fulstowe, salter 2
5386181 2471111 2471111 defendant Scotte Roger salter 586291 586291 Scotte, Roger, of Fulstowe, salter 2
5484501 2500283 2500283 defendant Herne or Herve Roger husbandman 586291 586291 Herne or Herve, Roger, of Fulstowe, husbandman 0
5530742 2514133 2514133 plaintiff Rychardson Thomas gent 586291 586291 Rychardson, Thomas, of Fulstowe, gent 0
5535256 2515555 2515555 defendant Swyn Richard yeoman 586291 586291 Swyn, Richard, of Fulstowe, yeoman 1
5554050 2521224 2521224 defendant Rychardson Thomas gent 586291 586291 Rychardson, Thomas, of Fulstowe, gent 0
5562211 2523546 2523546 defendant Fawkener Robert yeoman 586291 586291 Fawkener, Robert, of Fulstowe, yeoman 0
5589653 2531760 2531760 defendant Richardson Thomas, junior gent 586291 586291 Richardson, Thomas, junior, of Fulstowe, 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);