names

47 rows where place_id = 632975

✎ 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
3809946 1960999 1960999 defendant Isted Richard yeoman 632975 632975 Isted, Richard, of Maghfeld, yeoman 1
3839325 1970226 1970226 defendant Holbeme Richard laborer 632975 632975 Holbeme, Richard, of Maghfeld, laborer 1
4543362 2213812 2213812 defendant Tannere John   632975 632975 Tannere, John, of Maghfeld 0
4544752 2214274 2214274 defendant Speeke Thomas   632975 632975 Speeke, Thomas, of Maghfeld, vicar 1
4545556 2214534 2214534 defendant Specke Thomas   632975 632975 Specke, Thomas, of Maghfeld 1
4555398 2217623 2217623 defendant Tubbyl John   632975 632975 Tubbyl, John, of Maghfeld 0
4555399 2217623 2217623 defendant Dosy William   632975 632975 Dosy, William, of Maghfeld 1
4596487 2230144 2230144 defendant Hoke John   632975 632975 Hoke, John, of Maghfeld 1
4596489 2230144 2230144 defendant Manyngfeld Richard   632975 632975 Manyngfeld, Richard, of Maghfeld, vicar 3
4596490 2230144 2230144 defendant Ferour John   632975 632975 Ferour, John, of Maghfeld 4
4609564 2234091 2234091 plaintiff Burdon William   632975 632975 Burdon, William, of Maghfeld 0
4609565 2234091 2234091 plaintiff Bayly William   632975 632975 Bayly, William, of Maghfeld 1
4618205 2236702 2236702 defendant Gace Thomas   632975 632975 Gace, Thomas, of Maghfeld 0
4625919 2239059 2239059 defendant Baldelot Richard   632975 632975 Baldelot, Richard, of Maghfeld 0
4636708 2242301 2242301 defendant atte Forde John   632975 632975 atte Forde, John, of Maghfeld 0
4636709 2242301 2242301 defendant Speeke (illegible)   632975 632975 Speeke, _, of Maghfeld, formerly vicar 1
4652061 2246581 2246581 plaintiff atte Forde William   632975 632975 atte Forde, William, of Maghfeld 0
4668558 2255873 2255873 defendant atte Forde John   632975 632975 atte Forde, John, of Maghfeld 0
4688464 2261960 2261960 defendant atte Forde John   632975 632975 atte Forde, John, of Maghfeld 0
4696331 2264334 2264334 defendant Huchon Walter husbandman 632975 632975 Huchon, Walter, of Maghfeld, husbandman 1
4702711 2266249 2266249 defendant Stonlegh William yeoman 632975 632975 Stonlegh, William, of Maghfeld, yeoman 0
4707489 2267716 2267716 defendant Beynden Thomas husbandman 632975 632975 Beynden, Thomas, of Maghfeld, husbandman 0
4725023 2273121 2273121 defendant Hunte Richard laborer 632975 632975 Hunte, Richard, of Maghfeld, laborer 0
4730443 2274716 2274716 defendant Coweper William cooper 632975 632975 Coweper, William, of Maghfeld, cooper 0
4755635 2282144 2282144 defendant Auncell John baker 632975 632975 Auncell, John, of Maghfeld, baker 0
4763699 2284635 2284635 defendant Dreye John husbandman 632975 632975 Dreye, John, of Maghfeld, husbandman 4
4778063 2289125 2289125 defendant Keneward John smith 632975 632975 Keneward, John, of Maghfeld, smith 0
4778067 2289127 2289127 defendant Koneward or Koueward John smith 632975 632975 Koneward or Koueward, John, of Maghfeld, smith 0
4787357 2292116 2292116 defendant Dreye John husbandman 632975 632975 Dreye, John, of Maghfeld, husbandman 4
4787363 2292117 2292117 defendant Dreye John husbandman 632975 632975 Dreye, John, of Maghfeld, husbandman 4
4860114 2314532 2314532 defendant atte Forde John husbandman 632975 632975 atte Forde, John, of Maghfeld, husbandman 0
4860799 2314739 2314739 defendant Coupere Walter cooper 632975 632975 Coupere, Walter, of Maghfeld, cooper 0
4873614 2318686 2318686 defendant Bothell Thomas baker 632975 632975 Bothell, Thomas, of Maghfeld, baker 2
4925409 2334380 2334380 defendant Edward Stephen smith 632975 632975 Edward, Stephen, of Maghfeld, smith 0
4958989 2344656 2344656 defendant Ladde Richard yeoman 632975 632975 Ladde, Richard, of Maghfeld, yeoman 0
4989383 2353759 2353759 defendant Pentecost William husbandman 632975 632975 Pentecost, William, of Maghfeld, husbandman 0
5004755 2358295 2358295 defendant Forder John yeoman 632975 632975 Forder, John, of Maghfeld, yeoman 0
5304284 2446285 2446285 defendant Ponte John yeoman 632975 632975 Ponte, John, of Maghfeld, yeoman 0
5347328 2459328 2459328 defendant Wynter John husbandman 632975 632975 Wynter, John, of Maghfeld, husbandman 2
5355647 2461842 2461842 plaintiff Kent William   632975 632975 Kent, William, of Maghfeld 0
5381973 2469900 2469900 defendant German Thomas   632975 632975 German, Thomas, of Maghfeld 0
5381975 2469901 2469901 defendant Germen Thomas shoemaker 632975 632975 Germen, Thomas, of Maghfeld, shoemaker 0
5390379 2472311 2472311 defendant Bo_lm Thomas shoemaker 632975 632975 Bo_lm, Thomas, of Maghfeld, shoemaker 0
5466389 2494883 2494883 defendant Martyn Lawrence husbandman 632975 632975 Martyn, Lawrence, of Maghfeld, husbandman 0
5477698 2498349 2498349 defendant Martyn Lawrence husbandman 632975 632975 Martyn, Lawrence, of Maghfeld, husbandman 0
5557313 2522102 2522102 defendant Galett Richard, senior yeoman 632975 632975 Galett, Richard, senior, of Maghfeld, yeoman 0
5557314 2522102 2522102 defendant Galet Richard, junior yeoman 632975 632975 Galet, Richard, junior, of Maghfeld, yeoman 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);