names

70 rows where place_id = 592951

✎ 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
3609521 1870638 1870638 defendant Barne John yeoman 592951 592951 Barne, John, of Sondon, yeoman 0
3612350 1871495 1871495 defendant Erdiswyk Hugh esq 592951 592951 Erdiswyk, Hugh, of Sondon, esq 1
3617933 1873232 1873232 defendant Carver John yeoman 592951 592951 Carver, John, of Sondon, yeoman 0
3619801 1873766 1873766 defendant Carver John husbandman 592951 592951 Carver, John, of Sondon, husbandman 0
3625153 1875401 1875401 defendant Bern Thomas yeoman 592951 592951 Bern, Thomas, of Sondon, yeoman 1
3630179 1904288 1904288 defendant Philippe Edmund husbandman 592951 592951 Philippe, Edmund, of Sondon, husbandman 0
3630180 1904288 1904288 defendant Sterky John husbandman 592951 592951 Sterky, John, of Sondon, husbandman 1
3640660 1907519 1907519 defendant Bold Roger husbandman 592951 592951 Bold, Roger, of Sondon, husbandman 1
3640663 1907520 1907520 defendant Bolde Roger husbandman 592951 592951 Bolde, Roger, of Sondon, husbandman 1
3640666 1907521 1907521 defendant Bolde Roger husbandman 592951 592951 Bolde, Roger, of Sondon, husbandman 1
3654346 1911621 1911621 defendant Hanson Ralph clerk 592951 592951 Hanson, Ralph, of Sondon, clerk 0
3654347 1911621 1911621 defendant Skra John weaver 592951 592951 Skra, John, of Sondon, weaver 1
3669428 1916377 1916377 defendant Hanson Ralph clerk 592951 592951 Hanson, Ralph, of Sondon, clerk 0
3669430 1916377 1916377 defendant Smyth Ralph yeoman 592951 592951 Smyth, Ralph, of Sondon, yeoman 2
3669431 1916377 1916377 defendant Sterke Ralph capper 592951 592951 Sterke, Ralph, of Sondon, capper 3
3669865 1916519 1916519 defendant Morrey Roger husbandman 592951 592951 Morrey, Roger, of Sondon, husbandman 0
3771474 1948770 1948770 defendant Smyth Thomas husbandman 592951 592951 Smyth, Thomas, of Sondon, husbandman 0
3840698 1970655 1970655 defendant Strarke or Starke John yeoman 592951 592951 Strarke or Starke, John, of Sondon, yeoman 2
3878477 1983045 1983045 defendant Preston Robert husbandman 592951 592951 Preston, Robert, of Sondon, husbandman 0
3884239 1984993 1984993 defendant Carnell John husbandman 592951 592951 Carnell, John, of Sondon, husbandman 0
3891227 1987329 1987329 defendant Preston Robert maltman 592951 592951 Preston, Robert, of Sondon, maltman 0
3891228 1987329 1987329 defendant Preston Richard husbandman 592951 592951 Preston, Richard, of Sondon, husbandman 1
3898829 1989811 1989811 defendant Wyllyamson alias Smyth Thomas husbandman 592951 592951 Wyllyamson alias Smyth, Thomas, of Sondon, husbandman 0
3909515 1993485 1993485 plaintiff Smyth Ralph   592951 592951 Smyth, Ralph, of Sondon 0
3912159 1994391 1994391 defendant Preston Robert husbandman 592951 592951 Preston, Robert, of Sondon, husbandman 1
3912952 1994663 1994663 plaintiff Baker John husbandman 592951 592951 Baker, John, of Sondon, husbandman 0
3912953 1994663 1994663 defendant Wyllyamson alias Smythe Thomas husbandman 592951 592951 Wyllyamson alias Smythe, Thomas, of Sondon, husbandman 0
3968933 2013756 2013756 defendant Erdyswyck John gent 592951 592951 Erdyswyck, John, of Sondon, gent 2
3968938 2013757 2013757 defendant Erdyswycke John gent 592951 592951 Erdyswycke, John, of Sondon, gent 3
3984052 2019065 2019065 plaintiff Streame Thomas husbandman 592951 592951 Streame, Thomas, of Sondon, husbandman 0
4415177 2169646 2169646 defendant Wolrich Richard   592951 592951 Wolrich, Richard, of Sondon 0
4415178 2169646 2169646 defendant Botiller Nicholas le   592951 592951 Botiller, Nicholas le, of Sondon, knight 1
4415179 2169646 2169646 defendant Smalrys Richard   592951 592951 Smalrys, Richard, of Sondon 2
4445681 2183605 2183605 defendant Dorcestre Richard de   592951 592951 Dorcestre, Richard de, of Sondon, formerly vicar 0
4461514 2188682 2188682 defendant Dikun Richard   592951 592951 Dikun, Richard, of Sondon 0
4461515 2188682 2188682 defendant Wolrich Roger, senior   592951 592951 Wolrich, Roger, senior, of Sondon 1
4598617 2230808 2230808 defendant atte Halle Thomas   592951 592951 atte Halle, Thomas, of Sondon 0
4688195 2261876 2261876 plaintiff Taillour Henry   592951 592951 Taillour, Henry, of Sondon 0
4776389 2288607 2288607 defendant Baudewyn John husbandman 592951 592951 Baudewyn, John, of Sondon, husbandman 1
4786704 2291896 2291896 defendant Frebern John husbandman 592951 592951 Frebern, John, of Sondon, husbandman 0
4793287 2293996 2293996 defendant B- William maltman 592951 592951 B-, William, of Sondon, maltman 1
4847633 2310751 2310751 defendant Faysant John yeoman 592951 592951 Faysant, John, of Sondon, yeoman 1
4885770 2322419 2322419 defendant Wellys John yeoman 592951 592951 Wellys, John, of Sondon, yeoman 3
4894033 2324834 2324834 defendant Kerver William yeoman 592951 592951 Kerver, William, of Sondon, yeoman 1
5063927 2375742 2375742 defendant Smyth John husbandman 592951 592951 Smyth, John, of Sondon, husbandman 0
5063928 2375742 2375742 defendant Hardyng Roger husbandman 592951 592951 Hardyng, Roger, of Sondon, husbandman 1
5063929 2375742 2375742 defendant Kerver John husbandman 592951 592951 Kerver, John, of Sondon, husbandman 2
5065572 2376238 2376238 defendant Beron Thomas husbandman 592951 592951 Beron, Thomas, of Sondon, husbandman 0
5065573 2376238 2376238 defendant Golles Simon husbandman 592951 592951 Golles, Simon, of Sondon, husbandman 1
5065574 2376238 2376238 defendant Kerver John husbandman 592951 592951 Kerver, John, of Sondon, husbandman 2
5125937 2394070 2394070 defendant Bolde Thomas chapman 592951 592951 Bolde, Thomas, of Sondon, chapman 1
5144547 2399565 2399565 defendant Bolde Thomas chapman 592951 592951 Bolde, Thomas, of Sondon, chapman 1
5165466 2405644 2405644 defendant Beron John yeoman 592951 592951 Beron, John, of Sondon, yeoman 0
5179577 2409761 2409761 defendant Beron John yeoman 592951 592951 Beron, John, of Sondon, yeoman 0
5232251 2425009 2425009 defendant atte Halle Thomas husbandman 592951 592951 atte Halle, Thomas, of Sondon, husbandman 0
5232252 2425009 2425009 defendant Berne John husbandman 592951 592951 Berne, John, of Sondon, husbandman 1
5240628 2427471 2427471 defendant Frebern Andrew husbandman 592951 592951 Frebern, Andrew, of Sondon, husbandman 0
5248924 2429810 2429810 defendant Berne Edward yeoman 592951 592951 Berne, Edward, of Sondon, yeoman 0
5248925 2429810 2429810 defendant Berne John yeoman 592951 592951 Berne, John, of Sondon, yeoman 1
5255949 2431985 2431985 defendant Bolde Henry yeoman 592951 592951 Bolde, Henry, of Sondon, yeoman 0
5273139 2437215 2437215 defendant Albon Richard butcher 592951 592951 Albon, Richard, of Sondon, butcher 0
5328521 2453606 2453606 defendant Walkeden Geoffrey chaplain 592951 592951 Walkeden, Geoffrey, of Sondon, chaplain 0
5331122 2454381 2454381 defendant Wolsey John husbandman 592951 592951 Wolsey, John, of Sondon, husbandman 3
5413297 2478905 2478905 defendant Cowley Thomas yeoman 592951 592951 Cowley, Thomas, of Sondon, yeoman 0
5447755 2489206 2489206 defendant Reyhold John husbandman 592951 592951 Reyhold, John, of Sondon, husbandman 2
5495363 2503514 2503514 defendant Heth John yeoman 592951 592951 Heth, John, of Sondon, yeoman 0
5567798 2525157 2525157 defendant Corbette Elizabeth widow 592951 592951 Corbette, Elizabeth, of Sondon, widow 0
5594595 2533289 2533289 defendant Hanson Ralph clerk 592951 592951 Hanson, Ralph, of Sondon, clerk 0
5594597 2533290 2533290 defendant Hanson Ralph clerk 592951 592951 Hanson, Ralph, of Sondon, clerk 0
5596297 2533755 2533755 defendant Feld William, junior husbandman 592951 592951 Feld, William, junior, of Sondon, 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);