names

44 rows where place_id = 591132

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3603429 1868739 1868739 defendant Gedge John chaplain 591132 591132 Gedge, John, of Stodey, chaplain 18
3620486 1873984 1873984 defendant Braunche Henry gent 591132 591132 Braunche, Henry, of Stodey, gent 1
3672861 1917524 1917524 plaintiff Doo Edmund   591132 591132 Doo, Edmund, of Stodey 0
3700968 1926552 1926552 defendant Burnesey Alan yeoman 591132 591132 Burnesey, Alan, of Stodey, yeoman 0
3727474 1934869 1934869 defendant Fulke John smith 591132 591132 Fulke, John, of Stodey, smith 0
3780154 1951515 1951515 defendant Fulk John smith 591132 591132 Fulk, John, of Stodey, smith 0
3781433 1951928 1951928 defendant Doo Edmund husbandman 591132 591132 Doo, Edmund, of Stodey, husbandman 0
3787766 1953965 1953965 defendant Fulby John smith 591132 591132 Fulby, John, of Stodey, smith 0
3800115 1957960 1957960 defendant Bosom John esq 591132 591132 Bosom, John, of Stodey, esq 0
3800117 1957960 1957960 defendant Kent John laborer 591132 591132 Kent, John, of Stodey, laborer 2
3800118 1957960 1957960 defendant Cornysshe Thomas laborer 591132 591132 Cornysshe, Thomas, of Stodey, laborer 3
3800119 1957960 1957960 defendant Freman Robert laborer 591132 591132 Freman, Robert, of Stodey, laborer 4
3809793 1960950 1960950 defendant Doo Edmund husbandman 591132 591132 Doo, Edmund, of Stodey, husbandman 2
3817229 1963304 1963304 defendant Fulk John husbandman 591132 591132 Fulk, John, of Stodey, husbandman 3
3831507 1967739 1967739 defendant Fulke John smith 591132 591132 Fulke, John, of Stodey, smith 0
3831903 1967872 1967872 defendant Fulke John smith 591132 591132 Fulke, John, of Stodey, smith 0
3851794 1974150 1974150 defendant Pellys Thomas yeoman 591132 591132 Pellys, Thomas, of Stodey, yeoman 0
3944427 2005152 2005152 defendant Feke Simon tanner 591132 591132 Feke, Simon, of Stodey, tanner 0
4335608 2142185 2142185 defendant Tubbyng John tanner 591132 591132 Tubbyng, John, of Stodey, tanner 2
4739281 2277372 2277372 defendant Skye John tanner 591132 591132 Skye, John, of Stodey, tanner 0
4902469 2327386 2327386 defendant de Banham Richard clerk 591132 591132 de Banham, Richard, of Stodey, clerk 2
4995286 2355436 2355436 defendant Lampyt Ralph esq 591132 591132 Lampyt, Ralph, of Stodey, esq 1
4995294 2355437 2355437 defendant Lampyt Ralph esq 591132 591132 Lampyt, Ralph, of Stodey, formerly of Great Yarmouth, esq 1
5035909 2367357 2367357 defendant Lampet Ralph gent 591132 591132 Lampet, Ralph, of Stodey, gent 0
5056017 2373370 2373370 defendant Mony Robert butcher 591132 591132 Mony, Robert, of Stodey, butcher 0
5057468 2373800 2373800 defendant But John husbandman 591132 591132 But, John, of Stodey, husbandman 3
5097294 2385640 2385640 defendant Pelles John mercer 591132 591132 Pelles, John, of Stodey, mercer 2
5248827 2429775 2429775 defendant Mony Robert butcher 591132 591132 Mony, Robert, of Stodey, butcher 0
5251526 2430582 2430582 defendant Mony Edmund husbandman 591132 591132 Mony, Edmund, of Stodey, husbandman 0
5251538 2430585 2430585 defendant Mony Edmund husbandman 591132 591132 Mony, Edmund, of Stodey, husbandman 0
5255454 2431827 2431827 defendant Mony Robert butcher 591132 591132 Mony, Robert, of Stodey, butcher 1
5269226 2436105 2436105 defendant Mony Robert butcher 591132 591132 Mony, Robert, of Stodey, butcher 0
5339761 2457011 2457011 defendant Mony Robert husbandman 591132 591132 Mony, Robert, of Stodey, husbandman 1
5366614 2465211 2465211 defendant Pellys William husbandman 591132 591132 Pellys, William, of Stodey, husbandman 0
5385247 2470855 2470855 defendant Say John husbandman 591132 591132 Say, John, of Stodey, husbandman 1
5385248 2470855 2470855 defendant Pellys William husbandman 591132 591132 Pellys, William, of Stodey, husbandman 2
5510283 2508054 2508054 defendant Sage John yeoman 591132 591132 Sage, John, of Stodey, yeoman 0
5513223 2508985 2508985 defendant Say John husbandman 591132 591132 Say, John, of Stodey, husbandman 0
5514834 2509485 2509485 defendant Saye John yeoman 591132 591132 Saye, John, of Stodey, yeoman 0
5515356 2509647 2509647 defendant Say John yeoman 591132 591132 Say, John, of Stodey, yeoman 0
5573367 2526766 2526766 plaintiff Pellis John   591132 591132 Pellis, John, of Stodey 0
5573369 2526766 2526766 defendant Mason William husbandman 591132 591132 Mason, William, of Stodey, husbandman 0
5573370 2526767 2526767 plaintiff Pellys     591132 591132 Pellys, , of Stodey 0
5573372 2526767 2526767 defendant Mason William husbandman 591132 591132 Mason, William, of Stodey, husbandman 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);