names

38 rows where place_id = 586456

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3588766 1864129 1864129 defendant Marham William clerk 586456 586456 Marham, William, of Hornyngtoft, clerk 0
3614566 1872206 1872206 plaintiff Brown John   586456 586456 Brown, John, of Hornyngtoft, or of North Elmham, administrators of 0
3844108 1971706 1971706 defendant Oldman Thomas husbandman 586456 586456 Oldman, Thomas, of Hornyngtoft, husbandman 1
3853138 1974602 1974602 defendant Oldman Thomas husbandman 586456 586456 Oldman, Thomas, of Hornyngtoft, husbandman 2
3867625 1979407 1979407 defendant Oldman Thomas husbandman 586456 586456 Oldman, Thomas, of Hornyngtoft, husbandman 1
3867638 1979412 1979412 defendant Oldman Thomas husbandman 586456 586456 Oldman, Thomas, of Hornyngtoft, husbandman 1
4081714 2053762 2053762 defendant Burton Walter carpenter 586456 586456 Burton, Walter, of Hornyngtoft, carpenter 0
4220893 2102802 2102802 defendant Faux Thomas husbandman 586456 586456 Faux, Thomas, of Hornyngtoft, or of Biteringe Parva, husbandman 0
4323166 2138161 2138161 defendant Foster Richard yeoman 586456 586456 Foster, Richard, of Hornyngtoft, yeoman 2
4354798 2148899 2148899 defendant Foster Richard yeoman 586456 586456 Foster, Richard, of Hornyngtoft, yeoman 0
4408006 2167245 2167245 defendant Hunt William gent 586456 586456 Hunt, William, of Hornyngtoft, gent 1
4622604 2238047 2238047 defendant Smyth Roger   586456 586456 Smyth, Roger, of Hornyngtoft 2
4622605 2238047 2238047 defendant Colyn Hamon   586456 586456 Colyn, Hamon, of Hornyngtoft 3
4654133 2247175 2247175 defendant de Hoo Adam   586456 586456 de Hoo, Adam, of Hornyngtoft 1
4654137 2247176 2247176 defendant de Hoo Adam   586456 586456 de Hoo, Adam, of Hornyngtoft 2
4756652 2282446 2282446 plaintiff Gressenhale John   586456 586456 Gressenhale, John, of Hornyngtoft, parson 3
4763561 2284588 2284588 defendant Wortys Edmund husbandman 586456 586456 Wortys, Edmund, of Hornyngtoft, husbandman 0
4806459 2298230 2298230 defendant Goter John, junior yeoman 586456 586456 Goter, John, junior, of Hornyngtoft, yeoman 0
5026996 2364765 2364765 defendant Syre Thomas husbandman 586456 586456 Syre, Thomas, of Hornyngtoft, husbandman 4
5104726 2387820 2387820 defendant Lucas Richard clerk 586456 586456 Lucas, Richard, of Hornyngtoft, clerk 2
5224554 2422849 2422849 defendant Broun John husbandman 586456 586456 Broun, John, of Hornyngtoft, husbandman 0
5224556 2422850 2422850 defendant Broun John husbandman 586456 586456 Broun, John, of Hornyngtoft, husbandman 0
5230808 2424617 2424617 defendant Marham William clerk 586456 586456 Marham, William, of Hornyngtoft, clerk 0
5230810 2424618 2424618 defendant Marham William clerk 586456 586456 Marham, William, of Hornyngtoft, clerk 0
5236030 2426120 2426120 defendant Marham William clerk 586456 586456 Marham, William, of Hornyngtoft, clerk 0
5243828 2428388 2428388 defendant Broun John yeoman 586456 586456 Broun, John, of Hornyngtoft, yeoman 3
5288644 2441699 2441699 defendant Oldeman John husbandman 586456 586456 Oldeman, John, of Hornyngtoft, husbandman 3
5304449 2446328 2446328 defendant Oldeman John husbandman 586456 586456 Oldeman, John, of Hornyngtoft, husbandman 1
5338835 2456719 2456719 defendant Marham William clerk 586456 586456 Marham, William, of Hornyngtoft, clerk 3
5399547 2474951 2474951 defendant Bylberd Thomas husbandman 586456 586456 Bylberd, Thomas, of Hornyngtoft, husbandman 1
5413028 2478829 2478829 defendant Marham William clerk 586456 586456 Marham, William, of Hornyngtoft, clerk 1
5428059 2483341 2483341 defendant Marham William clerk 586456 586456 Marham, William, of Hornyngtoft, clerk 1
5491497 2502340 2502340 defendant Alyard Henry husbandman 586456 586456 Alyard, Henry, of Hornyngtoft, husbandman 1
5510017 2507974 2507974 defendant Alyard Thomas yeoman 586456 586456 Alyard, Thomas, of Hornyngtoft, yeoman 0
5510171 2508017 2508017 defendant Alyard Henry husbandman 586456 586456 Alyard, Henry, of Hornyngtoft, husbandman 1
5569134 2525523 2525523 defendant Slater Robert clerk 586456 586456 Slater, Robert, of Hornyngtoft, clerk 0
5569141 2525525 2525525 defendant Slater Robert clerk 586456 586456 Slater, Robert, of Hornyngtoft, clerk 0
5589112 2531603 2531603 defendant Frary William husbandman 586456 586456 Frary, William, of Hornyngtoft, husbandman 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);